Version History of Financial Statements for Helsinki City Council 2016

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

Click here for a data sample

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 various data analytics purposes like analyzing the financial performance of different companies, identifying trends in financial statements over time, and comparing the actual outcomes with the budgeted figures for different expense categories. The table is sourced from the website of 'City of Helsinki Administration' and originates from Finland (country code: 'fi').

Field Descriptions

Name Data type Description
_start_datedateThe validity period start date of the row version.
_end_datedateThe validity period end date of the row version.
_row_numberlongThe row number of the version history.
yritys__nimistringThe name of the company.
paaluokka_nrointThe main class number.
paaluokka_nimistringThe name of the main class.
luku_nrointThe chapter number.
luku_nimistringThe name of the chapter.
kohta_nrointThe item number.
kohta_nimistringThe name of the item.
tulosyksikko_nrointThe result unit number.
tulosyksikko_nimistringThe name of the result unit.
toteuma_yht_ulsfloatThe actual total amount in local currency.
talousarvion_tiliryhmastringThe budget account group.
paakirjatili_nimi_fistringThe name of the main account in Finnish.
paakirjatili_nrointThe main account number.
vuosiintThe year.

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
Ideb33bf02-5fd2-45b3-97cb-b735e4862a06
Package id39c660f0-6276-4d2a-b623-037c5859d665
Position1
Revision id20f07413-c4b5-4506-9c96-134b54218d31
Stateactive
Tablehelsinki_tilinpaatos_2016_xlsx__raportti_1__history