Version History of Helsinki Budget 2012 Starting from CSV Table
Click here for a data sample
This table provides the version history of rows extracted from the 'Helsingin kaupunginkanslia' website's 'helsingin_tulosbudjetti_2012_alkaen_csvtable' table. It contains the '_start_date' column which indicates the date when each row was extracted, and the '_end_date' column which indicates the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row is the most recent version. The table includes various columns such as 'yritysnimi', 'osasto_nro', 'tulosyksikkonimi', 'talousarvion_tiliryhma', 'paakirjatilinimi', 'tulosbudjetti', and 'vuosi'. These columns can be utilized in data analytics to gain insights into the budgeting and financial performance of different departments, units, and accounts. By analyzing the 'tulosbudjetti' column over time, it is possible to track the budgeting trends and changes within the 'Helsingin kaupunginkanslia' organization. This data is sourced from the website of 'City of Helsinki Administration' originating from Finland (ISO country code: 'fi').
Field Descriptions
Name |
Data type |
Description |
_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 the row version. |
yritys__nimi | string | The name of the company associated with the row version. |
osasto_nro | int | The department number associated with the row version. |
tulosyksikko__nimi | string | The name of the profit center associated with the row version. |
talousarvion_tiliryhma | string | The accounting group of the budget associated with the row version. |
paakirjatili__nimi | string | The name of the main ledger account associated with the row version. |
tulosbudjetti | int | The budget for the row version. |
vuosi | int | The year associated with the row version. |