Version History of Helsinki Financial Statements from 2012-2014 sourced from Helsingin kaupunginkanslia, Finland
Click here for a data sample
This table represents the version history of the 'Helsinki Financial Statements' data, sourced from the website of Helsinki City Government, located in Finland (ISO country code: 'FI'). The table captures changes in the financial statement data over time, with additional columns '_start_date' and '_end_date' indicating the extraction dates of each row. The table contains various columns such as 'yritys__nimi', 'paaluokka_nro', 'paaluokka_nimi', 'luku_nro', 'luku_nimi', 'kohta_nro', 'kohta_nimi', 'tulosyksikko_nro', 'tulosyksikko_nimi', 'toteuma_yht_uls', 'talousarvion_tiliryhma', 'paakirjatili_nimi', 'paakirjatili_nro', and 'vuosi'. The data in this table can be utilized for various data analytics purposes, such as analyzing financial trends, comparing performance across different years, evaluating expenditure patterns within specific categories, and performing budget analyses.
Field Descriptions
| Name |
Data type |
Description |
| _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 row number of the version in the base table. |
|---|
| 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 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 actualization total for foreign currency. |
|---|
| talousarvion_tiliryhma | string | The budget account group. |
|---|
| paakirjatili_nimi | string | The name of the main ledger account. |
|---|
| paakirjatili_nro | int | The number of the main ledger account. |
|---|
| vuosi | int | The year. |
|---|
