Financial Statements of Helsinki 2017

The dataset collection contains one or more dataset tables sourced from the website of Helsingin kaupunginkanslia (Office of the City of Helsinki) in Finland.

Tables

Financial Report 2017TSV
This table contains financial data of companies from Helsinki City Administration for the year 2017. The data is sourced from the website of Helsinki City Administration in Finland. The table provides information such as the extraction date, row number, company name, main category number, main category name, indicator number, indicator name, item number, item name, financial unit number, financial unit name, total actual external result, budget account group, main account name in Finnish, main account number, and year. This table can be utilized for various data analytics purposes, such as analyzing the financial performance of companies, comparing actual results with budgeted figures, identifying trends in different financial units, or conducting industry-wide financial analysis.
Version History of Helsinki 2017 Financial Statement (XLSX Report 1)TSV
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...

Column Descriptions

Financial Report 2017

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data entry.
yritys__nimi	string	The name of the company.
paaluokka_nro	int	The number associated with the main category.
paaluokka_nimi	string	The name of the main category.
luku_nro	int	The number associated with the chapter.
luku_nimi	string	The name of the chapter.
kohta_nro	int	The number associated with the item.
kohta_nimi	string	The name of the item.
tulosyksikko_nro	int	The number associated with the result unit.
tulosyksikko_nimi	string	The name of the result unit.
toteuma_yht_uls	float	The total amount realized in the result unit.
talousarvion_tiliryhma	string	The budget account group.
paakirjatili_nimi_fi	string	The name of the main ledger account in Finnish.
paakirjatili_nro	int	The number associated with the main ledger account.
vuosi	int	The year of the data entry.

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

Column	Type	Comment
_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.

Additional Info

Last Updated	April 23, 2024
Created	April 23, 2024