Financial Statements of Helsinki for 2015

This dataset collection consists of tables sourced from the web site of Helsingin kaupunginkanslia in Finland. It contains one or more dataset tables.

Tables

Financial Statements 2015 ReportTSV
This table contains financial data from the 'Helsinki City Administration' for the year 2015. It is sourced from the website of the Helsinki City Administration in Finland. The table provides comprehensive information on various financial metrics and categories. The data can be utilized for conducting data analytics and financial analysis, such as monitoring and comparing the actual expenses against the budgeted expenses, identifying main financial categories, analyzing the performance of different organizational units, and understanding the financial structure of the administration. The table includes columns for the extract date, row number, and various identifiers and names related to different financial categories, units, and accounts, along with the corresponding numerical data for...
Version History of Helsinki Financial Statement 2015 - Report 1TSV
This table contains the version history of the rows extracted from the 'Helsingin kaupunginkanslia' website for the base table 'helsinki_tilinpaatos_2015_xlsx__raportti_1'. Each row in this table represents a version of a row in the base table, with additional columns '_start_date' and '_end_date' indicating the extraction dates. The data in this table can be utilized for data analytics purposes, such as analyzing the changes in financial figures over time or performing trend analysis for different entities. The table is sourced from the website of Helsingin kaupunginkanslia which originates from Finland (ISO country code: 'fi').

Column Descriptions

Financial Statements 2015 Report

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The sequential number of the row in the table.
column_0	string	The value in column 0.
yritys__nimi	string	The name of the company.
paaluokka_nro	int	The number of the main category.
paaluokka_nimi	string	The name of the main category.
luku_nro	int	The number of the chapter.
luku_nimi	string	The name of the chapter.
kohta_nro	int	The number of the section.
kohta_nimi	string	The name of the section.
tulosyksikko_nro	int	The number of the performance unit.
tulosyksikko_nimi	string	The name of the performance unit.
toteuma_yht_uls	float	The total implementation of the result in ULS.
talousarvion_tiliryhma	string	The budget accounting group.
paakirjatili_nimi_fi	string	The name of the main ledger account in Finnish.
paakirjatili_nro	int	The number of the main ledger account.
vuosi	int	The year of the data.

Version History of Helsinki Financial Statement 2015 - Report 1

Column	Type	Comment
_start_date	date	Indicates the start date of the validity period for the row version.
_end_date	date	Indicates the end date of the validity period for the row version.
_row_number	long	The row number of the version in the table.
column_0	string	The value of this column.
yritys__nimi	string	The name of the company associated with the row version.
paaluokka_nro	int	The main class number for the row version.
paaluokka_nimi	string	The main class name for the row version.
luku_nro	int	The chapter number for the row version.
luku_nimi	string	The chapter name for the row version.
kohta_nro	int	The section number for the row version.
kohta_nimi	string	The section name for the row version.
tulosyksikko_nro	int	The result unit number for the row version.
tulosyksikko_nimi	string	The result unit name for the row version.
toteuma_yht_uls	float	The total achievement in the local currency for the row version.
talousarvion_tiliryhma	string	The budget account group for the row version.
paakirjatili_nimi_fi	string	The name of the main ledger account in Finnish for the row version.
paakirjatili_nro	int	The number of the main ledger account for the row version.
vuosi	int	The year associated with the row version.

Additional Info

Last Updated	April 23, 2024
Created	April 23, 2024