To download the data set, please sign up or log in
Municipal key figures 1987-2017
Tables
-
Dim Information, Municipal Key Figures 1987 2017TSV
Dimension Information (Tiedot)
-
Dim Region 2018, Municipal Key Figures 1987 2017TSV
Dimension Region_2018 (Alue 2018)
-
Dim Year, Municipal Key Figures 1987 2017TSV
Dimension Year (Vuosi)
-
Fact, Municipal Key Figures 1987 2017TSV
Municipal key figures by Region 2018, Information and Year
Column Descriptions
Fact, Municipal Key Figures 1987 2017
| Column | Type | Comment |
|---|---|---|
| region_2018 | int | Datasource did not contain a description for Region_2018. Column region_2018 has 470890 rows, out of which 172019 are empty, making the null percent 36.53. Minimum value is 5 and maximum value is 992. |
| information | string | Datasource did not contain a description for Information. Column information has 470890 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M106 and maximum string is M498. |
| year | int | Datasource did not contain a description for Year. Column year has 470890 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1987 and maximum value is 2017. |
| municipal_key_figures | int | Datasource did not contain a description for Municipal_key_figures. Column municipal_key_figures has 470890 rows, out of which 136710 are empty, making the null percent 29.03. Minimum value is -3401 and maximum value is 5513130. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Dim Region 2018, Municipal Key Figures 1987 2017
| Column | Type | Comment |
|---|---|---|
| code | int | The code for the dimension value. Column code has 490 rows, out of which 179 are empty, making the null percent 36.53. Minimum value is 5 and maximum value is 992. |
| label | string | The label for the dimension value. Column label has 490 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Akaa... and first 25 characters of maximum string: Ålands skärgård sub-regio... |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Dim Year, Municipal Key Figures 1987 2017
| Column | Type | Comment |
|---|---|---|
| code | int | The code for the dimension value. Column code has 31 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1987 and maximum value is 2017. |
| label | int | The label for the dimension value. Column label has 31 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1987 and maximum value is 2017. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Dim Information, Municipal Key Figures 1987 2017
| Column | Type | Comment |
|---|---|---|
| code | string | The code for the dimension value. Column code has 31 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M106 and maximum string is M498. |
| label | string | The label for the dimension value. Column label has 31 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Annual contribution margi... and first 25 characters of maximum string: Social and health care ac... |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | April 24, 2019 |
|---|---|
| Created | April 22, 2019 |