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

Budget Results of Helsinki 2012 onwards

This dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunginkanslia in Finland.

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