Helsinki Financial Statements 2016
Tables
-
Financial Statements Report 2016TSV
This table contains financial data from the 'Helsinki City Office' for the year 2016. It provides information about various aspects of the financial performance of different entities. The table includes columns such as 'Extract Date', 'Row Number', 'Company Name', 'Main Category Number', 'Main Category Name', 'Figure Number', 'Figure Name', 'Item Number', 'Item Name', 'Operating Unit Number', 'Operating Unit Name', 'Actual Cumulative Amount in Foreign Currency', 'Budget Account Group', 'Main Account Name in Finnish', 'Main Account Number', and 'Year'. The data can be utilized for data analytics purposes, such as analyzing the financial performance of different companies or entities, comparing actual results to budgeted amounts, identifying trends or patterns in financial data, and...
-
Version History of Financial Statements for Helsinki City Council 2016TSV
This table contains the version history of the rows extracted from the 'Helsingin kaupunginkanslia' website. It is derived from the base table 'helsinki_tilinpaatos_2016_xlsxraportti_1'. The table has additional columns '_start_date' and '_end_date', indicating the extraction dates of each row version. The rows in this table represent different versions of data entries. The data is related to financial statements of various companies in Helsinki for the year 2016. The table includes columns such as 'yritysnimi', 'paaluokka_nro', 'paaluokka_nimi', 'luku_nro', 'luku_nimi', 'kohta_nro', 'kohta_nimi', 'tulosyksikko_nro', 'tulosyksikko_nimi', 'toteuma_yht_uls', 'talousarvion_tiliryhma', 'paakirjatili_nimi_fi', 'paakirjatili_nro', and 'vuosi'. The data in this table can be utilized for...
Column Descriptions
Financial Statements Report 2016
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data was extracted. |
_row_number | long | The sequential number of the row. |
yritys__nimi | string | The name of the company. |
paaluokka_nro | int | The primary category number. |
paaluokka_nimi | string | The name of the primary category. |
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 total result for the year in 1000 ule. |
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 of the main ledger account. |
vuosi | int | The year. |
Version History of Financial Statements for Helsinki City Council 2016
Column | Type | Comment |
---|---|---|
_start_date | date | The validity period start date of the row version. |
_end_date | date | The validity period end date of the row version. |
_row_number | long | The row number of the version history. |
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 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 total amount in local currency. |
talousarvion_tiliryhma | string | The budget account group. |
paakirjatili_nimi_fi | string | The name of the main account in Finnish. |
paakirjatili_nro | int | The main account number. |
vuosi | int | The year. |
Additional Info
Last Updated | April 23, 2024 |
---|---|
Created | April 23, 2024 |