Version History of Helsinki 2017 Financial Statement (XLSX Report 1)
Click here for a data sample
This table contains the version history of rows extracted from the web site of 'Helsingin kaupunginkanslia', which originates from Finland. The table '_helsinki_tilinpaatos_2017_xlsxraportti_1history' is a historical record of the base table 'helsinki_tilinpaatos_2017_xlsx__raportti_1', and it includes additional columns '_start_date' and '_end_date'. The column '_start_date' represents the extraction date of a row, while the column '_end_date' represents the date when a new version of the row was extracted. If the value of '_end_date' is null, it indicates that the row is the most recent version. This table provides valuable data for various data analytics tasks, such as trend analysis, performance monitoring, and financial forecasting. By analyzing the changes in the different columns over time, it is possible to gain insights into the evolution of 'Helsingin kaupunginkanslia' data. For example, one can track the changes in 'toteuma_yht_uls' (actual total outside the budget), 'talousarvion_tiliryhma' (budget account group), or 'paakirjatili_nimi_fi' (main account name in Finnish) to understand budgetary trends or financial performance. The 'tulosyksikko_nro' (profit center number) and 'tulosyksikko_nimi' (profit center name) columns can be utilized to analyze profitability across different units. Additionally, the 'vuosi' (year) column enables year-over-year comparisons. Utilizing this historical data, businesses and researchers can gain valuable insights into the financial aspects of the 'Helsingin kaupunginkanslia' web site.
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date of the validity period of the row version. |
_end_date | date | The end date of the validity period of the row version. |
_row_number | long | The number assigned to each row version. |
yritys__nimi | string | The name of the company associated with the row version. |
paaluokka_nro | int | The number assigned to the main class. |
paaluokka_nimi | string | The name of the main class. |
luku_nro | int | The number assigned to the chapter. |
luku_nimi | string | The name of the chapter. |
kohta_nro | int | The number assigned to the section. |
kohta_nimi | string | The name of the section. |
tulosyksikko_nro | int | The number assigned to the result unit. |
tulosyksikko_nimi | string | The name of the result unit. |
toteuma_yht_uls | float | The actual result for the given year and account. |
talousarvion_tiliryhma | string | The accounting group in the budget. |
paakirjatili_nimi_fi | string | The name of the main ledger account. |
paakirjatili_nro | int | The number of the main ledger account. |
vuosi | int | The year associated with the row version. |