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

Helsinki Financial Statements 2016

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

Tables

  • Financial Statements Report 2016TSV

    This table contains financial data from the 'Helsinki City Office' for the year 2016. It provides information about various aspects of the financial performance of different entities. The table includes columns such as 'Extract Date', 'Row Number', 'Company Name', 'Main Category Number', 'Main Category Name', 'Figure Number', 'Figure Name', 'Item Number', 'Item Name', 'Operating Unit Number', 'Operating Unit Name', 'Actual Cumulative Amount in Foreign Currency', 'Budget Account Group', 'Main Account Name in Finnish', 'Main Account Number', and 'Year'. The data can be utilized for data analytics purposes, such as analyzing the financial performance of different companies or entities, comparing actual results to budgeted amounts, identifying trends or patterns in financial data, and...

  • Version History of Financial Statements for Helsinki City Council 2016TSV

    This table contains the version history of the rows extracted from the 'Helsingin kaupunginkanslia' website. It is derived from the base table 'helsinki_tilinpaatos_2016_xlsxraportti_1'. The table has additional columns '_start_date' and '_end_date', indicating the extraction dates of each row version. The rows in this table represent different versions of data entries. The data is related to financial statements of various companies in Helsinki for the year 2016. The table includes columns such as 'yritysnimi', 'paaluokka_nro', 'paaluokka_nimi', 'luku_nro', 'luku_nimi', 'kohta_nro', 'kohta_nimi', 'tulosyksikko_nro', 'tulosyksikko_nimi', 'toteuma_yht_uls', 'talousarvion_tiliryhma', 'paakirjatili_nimi_fi', 'paakirjatili_nro', and 'vuosi'. The data in this table can be utilized for...

Column Descriptions

Financial Statements Report 2016

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The sequential number of the row.
yritys__nimi string The name of the company.
paaluokka_nro int The primary category number.
paaluokka_nimi string The name of the primary category.
luku_nro int The chapter number.
luku_nimi string The name of the chapter.
kohta_nro int The section number.
kohta_nimi string The name of the section.
tulosyksikko_nro int The result unit number.
tulosyksikko_nimi string The name of the result unit.
toteuma_yht_uls float The total result for the year in 1000 ule.
talousarvion_tiliryhma string The budget account group.
paakirjatili_nimi_fi string The name of the main ledger account (in Finnish).
paakirjatili_nro int The number of the main ledger account.
vuosi int The year.

Version History of Financial Statements for Helsinki City Council 2016

Column Type Comment
_start_date date The validity period start date of the row version.
_end_date date The validity period end date of the row version.
_row_number long The row number of the version history.
yritys__nimi string The name of the company.
paaluokka_nro int The main class number.
paaluokka_nimi string The name of the main class.
luku_nro int The chapter number.
luku_nimi string The name of the chapter.
kohta_nro int The item number.
kohta_nimi string The name of the item.
tulosyksikko_nro int The result unit number.
tulosyksikko_nimi string The name of the result unit.
toteuma_yht_uls float The actual total amount in local currency.
talousarvion_tiliryhma string The budget account group.
paakirjatili_nimi_fi string The name of the main account in Finnish.
paakirjatili_nro int The main account number.
vuosi int The year.

Additional Info

Last Updated April 23, 2024
Created April 23, 2024