Version History of Helsinki 2017 Financial Statement (XLSX Report 1)

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

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_datedateThe start date of the validity period of the row version.
_end_datedateThe end date of the validity period of the row version.
_row_numberlongThe number assigned to each row version.
yritys__nimistringThe name of the company associated with the row version.
paaluokka_nrointThe number assigned to the main class.
paaluokka_nimistringThe name of the main class.
luku_nrointThe number assigned to the chapter.
luku_nimistringThe name of the chapter.
kohta_nrointThe number assigned to the section.
kohta_nimistringThe name of the section.
tulosyksikko_nrointThe number assigned to the result unit.
tulosyksikko_nimistringThe name of the result unit.
toteuma_yht_ulsfloatThe actual result for the given year and account.
talousarvion_tiliryhmastringThe accounting group in the budget.
paakirjatili_nimi_fistringThe name of the main ledger account.
paakirjatili_nrointThe number of the main ledger account.
vuosiintThe year associated with the row version.

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
Idc718b238-2cc4-4c4d-b98f-e99669db0d16
Package id5d485183-501b-4217-96a7-73819c583718
Position1
Revision idc95d5c7c-4b48-47f6-b5bd-b3305dada06e
Stateactive
Tablehelsinki_tilinpaatos_2017_xlsx__raportti_1__history