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

Helsinki Results Budget 2012 (CSV)

The dataset collection 'helsingin_tulosbudjetti_2012_alkaen_csv' consists of one or more dataset tables sourced from the website of the 'Helsinki City Office' in Finland.

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