Version History of Financial Statements for Helsinki City Council 2016
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_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. |