Version History of Helsinki Budget 2012 Starting from CSV Table

To download the data set, please sign up or log in

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_datedateThe start date of the validity period for the row version.
_end_datedateThe end date of the validity period for the row version.
_row_numberlongThe number assigned to the row version.
yritys__nimistringThe name of the company associated with the row version.
osasto_nrointThe department number associated with the row version.
tulosyksikko__nimistringThe name of the profit center associated with the row version.
talousarvion_tiliryhmastringThe accounting group of the budget associated with the row version.
paakirjatili__nimistringThe name of the main ledger account associated with the row version.
tulosbudjettiintThe budget for the row version.
vuosiintThe year associated with the row version.

No sample for this dataset

Additional Information

Last updated April 23, 2024
Created April 23, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_helsingin_kaupunginkanslia
Id27c4327b-0a6b-4c45-af5f-54e0151f48d9
Package id7bf443e6-aa08-49b6-a0c1-90b44031977d
Position1
Revision id6c1c1da2-d056-4e2f-9f29-c9886d4e0920
Stateactive
Tablehelsingin_tulosbudjetti_2012_alkaen_csv__table__history