Budget Results of Helsinki 2012 onwards
Tables
-
Budget Results for Helsinki City from 2012 onwardsTSV
This table contains data from the Helsingin kaupunginkanslia website for the city of Helsinki in Finland. It provides information on the budget for the year 2012. The data includes various financial details related to different businesses and departments within the city administration. The table includes columns such as '_extract_date', '_row_number', 'yritysnimi', 'osasto_nro', 'tulosyksikkonimi', 'talousarvion_tiliryhma', 'paakirjatili__nimi', 'tulosbudjetti', and 'vuosi'. The table can be used for data analytics to gain insights into the budget allocation for different businesses and departments, analyze financial trends, compare budget figures across various categories, and track the performance of different units within the city administration.
-
Version history of the 'Helsinki Financial Budget 2012 and onwards' rows from the 'City of Helsinki Administration' (country: Finland) - 'Financial Budget'TSV
This table contains the version history of the rows from the 'Helsingin tulosbudjetti 2012 alkaen xlsx - Tulosbudjetti' table. The table has additional columns '_start_date' and '_end_date' which indicate the extraction dates of the rows. The table is sourced from the website of 'City of Helsinki Government' from Finland (ISO country code: 'fi'). The data in this table can be utilized for various data analytics purposes such as analyzing changes in budget allocations over time, tracking historical financial performance of different departments or units, identifying trends in budgetary trends and expenditures, and conducting comparative analysis between different years or budget categories.
Column Descriptions
Budget Results for Helsinki City from 2012 onwards
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data was extracted from the source system. |
_row_number | long | The row number for each record in the table. |
yritys__nimi | string | The name of the company. |
osasto_nro | int | The department number. |
tulosyksikko__nimi | string | The name of the business unit. |
talousarvion_tiliryhma | string | The accounting group of the budget. |
paakirjatili__nimi | string | The name of the main ledger account. |
tulosbudjetti | float | The budgeted result. |
vuosi | int | The year of the record. |
Version history of the 'Helsinki Financial Budget 2012 and onwards' rows from the 'City of Helsinki Administration' (country: Finland) - 'Financial Budget'
Column | Type | Comment |
---|---|---|
_start_date | date | The start date of the validity period for the row version. |
_end_date | date | The end date of the validity period for the row version. |
_row_number | long | The number assigned to each row version. |
yritys__nimi | string | The name of the company. |
osasto_nro | int | The department number. |
tulosyksikko__nimi | string | The name of the profit center. |
talousarvion_tiliryhma | string | The budget account group. |
paakirjatili__nimi | string | The name of the main ledger account. |
tulosbudjetti | float | The budgeted result. |
vuosi | int | The year of the row version. |
Additional Info
Last Updated | April 23, 2024 |
---|---|
Created | April 23, 2024 |