Helsinki Results Budget 2012 (CSV)
Tables
-
Budget Results for Helsinki 2012 and onwards CSV TableTSV
The table contains data from the Helsingin kaupunginkanslia website. It represents the Helsinki budget for the year 2012 onwards. The table includes various columns such as extract date, row number, company name, department number, unit name, budget account group, main account name, budget, and year. The data in this table can be utilized for various data analytics purposes such as analyzing budget allocations across different departments, tracking budget variations over time, and identifying the main account names associated with specific budget amounts. This dataset is sourced from Finland (ISO country code: fi).
-
Version History of Helsinki Budget 2012 Starting from CSV TableTSV
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...
Column Descriptions
Budget Results for Helsinki 2012 and onwards CSV Table
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data was extracted. |
_row_number | long | The row number of the entry in the table. |
yritys__nimi | string | The name of the company. |
osasto_nro | int | The department number. |
tulosyksikko__nimi | string | The name of the result unit. |
talousarvion_tiliryhma | string | The financial budget account group. |
paakirjatili__nimi | string | The name of the main ledger account. |
tulosbudjetti | int | The result budget. |
vuosi | int | The year of the data entry. |
Version History of Helsinki Budget 2012 Starting from CSV Table
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 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. |
Additional Info
Last Updated | April 27, 2024 |
---|---|
Created | April 23, 2024 |