Helsinki Financial Statements since 2012

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

Tables

Financial Statements for Helsinki from 2012 to 2014TSV
This table contains financial data from the 'Helsinki City Office' sourced from their website. The data pertains to the financial statements starting from the year 2012 up to 2014. The table provides information on various financial aspects such as the extract date, row number, company name, main category number and name, chapter number and name, section number and name, result unit number and name, total result in foreign currencies, budget account group, main account name and number, and the year. The data in this table can be used for data analytics to analyze and monitor the financial performance of companies in Helsinki, conduct trend analysis based on different financial parameters, compare the financial performance across different sectors and categories, assess the budgeting and...
Version History of Helsinki Financial Statements from 2012-2014 sourced from Helsingin kaupunginkanslia, FinlandTSV
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...

Column Descriptions

Financial Statements for Helsinki from 2012 to 2014

Column	Type	Comment
_extract_date	date	The date when the data was extracted from the source
_row_number	long	The row number of the data entry
yritys__nimi	string	The name of the company
paaluokka_nro	int	The main category number
paaluokka_nimi	string	The name of the main category
luku_nro	int	The chapter number
luku_nimi	string	The name of the chapter
kohta_nro	int	The item number
kohta_nimi	string	The name of the item
tulosyksikko_nro	int	The result unit number
tulosyksikko_nimi	string	The name of the result unit
toteuma_yht_uls	float	The actual outcome in total currency units
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 of the data entry

Version History of Helsinki Financial Statements from 2012-2014 sourced from Helsingin kaupunginkanslia, Finland

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

Additional Info

Last Updated	April 23, 2024
Created	April 23, 2024