To download the data set, please sign up or log in
002 -- Preliminary financial statements, municipal groups
Tables
-
Dim financial statement item, Statfin kta pxt 002 px, Full historyTSV
Dimension Financial_statement_item (Konsernin tilinpäätöserä)
-
Dim financial statement item, Statfin kta pxt 002 px, LatestTSV
Dimension Financial_statement_item (Konsernin tilinpäätöserä)
-
Dim region, Statfin kta pxt 002 px, Full historyTSV
Dimension Region (Alue)
-
Dim region, Statfin kta pxt 002 px, LatestTSV
Dimension Region (Alue)
-
Dim year, Statfin kta pxt 002 px, Full historyTSV
Dimension Year (Vuosi)
-
Dim year, Statfin kta pxt 002 px, LatestTSV
Dimension Year (Vuosi)
-
Fact, Statfin kta pxt 002 px, Full historyTSV
Preliminary financial statements, municipal groups by Region, Financial statement item and Year
-
Fact, Statfin kta pxt 002 px, LatestTSV
Preliminary financial statements, municipal groups by Region, Financial statement item and Year
Column Descriptions
Dim financial statement item, Statfin kta pxt 002 px, Latest
| Column | Type | Comment |
|---|---|---|
| code | string | The code for the dimension value. Column code has 106 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: aineelliset_hyodykkeet... and first 25 characters of maximum string: jaljella_oleva_paaoma_muu... |
| label | string | The label for the dimension value. Column label has 106 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Adjustments to internal f... and first 25 characters of maximum string: Guarantees for others: Re... |
Dim financial statement item, Statfin kta pxt 002 px, Full history
| Column | Type | Comment |
|---|---|---|
| code | string | The code for the dimension value. Column code has 106 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: aineelliset_hyodykkeet... and first 25 characters of maximum string: jaljella_oleva_paaoma_muu... |
| label | string | The label for the dimension value. Column label has 106 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Adjustments to internal f... and first 25 characters of maximum string: Guarantees for others: Re... |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Dim year, Statfin kta pxt 002 px, Full history
| Column | Type | Comment |
|---|---|---|
| code | int | The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2015 and maximum value is 2018. |
| label | int | The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2015 and maximum value is 2018. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Dim year, Statfin kta pxt 002 px, Latest
| Column | Type | Comment |
|---|---|---|
| code | int | The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2015 and maximum value is 2018. |
| label | int | The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2015 and maximum value is 2018. |
Dim region, Statfin kta pxt 002 px, Latest
| Column | Type | Comment |
|---|---|---|
| code | int | The code for the dimension value. Column code has 21 rows, out of which 2 are empty, making the null percent 9.52. Minimum value is 1 and maximum value is 21. |
| label | string | The label for the dimension value. Column label has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Central Finland and maximum string is Åland. |
Fact, Statfin kta pxt 002 px, Full history
| Column | Type | Comment |
|---|---|---|
| region | int | Datasource did not contain a description for Region. Column region has 8904 rows, out of which 848 are empty, making the null percent 9.52. Minimum value is 1 and maximum value is 21. |
| financial_statement_item | string | Datasource did not contain a description for Financial_statement_item. Column financial_statement_item has 8904 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: aineelliset_hyodykkeet... and first 25 characters of maximum string: jaljella_oleva_paaoma_muu... |
| year | int | Datasource did not contain a description for Year. Column year has 8904 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2015 and maximum value is 2018. |
| preliminary_financial_statements_municipal_groups | int | Datasource did not contain a description for Preliminary_financial_statements_municipal_groups. Column preliminary_financial_statements_municipal_groups has 8904 rows, out of which 546 are empty, making the null percent 6.13. Minimum value is -26980355 and maximum value is 86290862. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Dim region, Statfin kta pxt 002 px, Full history
| Column | Type | Comment |
|---|---|---|
| code | int | The code for the dimension value. Column code has 21 rows, out of which 2 are empty, making the null percent 9.52. Minimum value is 1 and maximum value is 21. |
| label | string | The label for the dimension value. Column label has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Central Finland and maximum string is Åland. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Fact, Statfin kta pxt 002 px, Latest
| Column | Type | Comment |
|---|---|---|
| region | int | Datasource did not contain a description for Region. Column region has 8904 rows, out of which 848 are empty, making the null percent 9.52. Minimum value is 1 and maximum value is 21. |
| financial_statement_item | string | Datasource did not contain a description for Financial_statement_item. Column financial_statement_item has 8904 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: aineelliset_hyodykkeet... and first 25 characters of maximum string: jaljella_oleva_paaoma_muu... |
| year | int | Datasource did not contain a description for Year. Column year has 8904 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2015 and maximum value is 2018. |
| preliminary_financial_statements_municipal_groups | int | Datasource did not contain a description for Preliminary_financial_statements_municipal_groups. Column preliminary_financial_statements_municipal_groups has 8904 rows, out of which 546 are empty, making the null percent 6.13. Minimum value is -26980355 and maximum value is 86290862. |
Additional Info
| Last Updated | July 21, 2019 |
|---|---|
| Created | July 14, 2019 |