To download the data set, please sign up or log in
1. Population structure 2017
Tables
-
Dim data, Paavo 1 he 2019 px, Full historyTSV
Dimension Data (Tiedot)
-
Dim data, Paavo 1 he 2019 px, LatestTSV
Dimension Data (Tiedot)
-
Dim postal code area, Paavo 1 he 2019 px, Full historyTSV
Dimension Postal_code_area (Postinumeroalue)
-
Dim postal code area, Paavo 1 he 2019 px, LatestTSV
Dimension Postal_code_area (Postinumeroalue)
-
Fact, Paavo 1 he 2019 px, Full historyTSV
Fact table of paavo_1_he_2019_px
-
Fact, Paavo 1 he 2019 px, LatestTSV
Fact table of paavo_1_he_2019_px
Column Descriptions
Fact, Paavo 1 he 2019 px, Latest
| Column | Type | Comment |
|---|---|---|
| postal_code_area | int | 2019 postal code areas . Column postal_code_area has 72648 rows, out of which 24 are empty, making the null percent 0.03. Minimum value is 100 and maximum value is 99990. |
| data | string | Datasource did not contain a description for Data. Column data has 72648 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is He_0_2 and maximum string is He_85_. |
| paavo_open_data_by_postal_code_area_2019 | int | Datasource did not contain a description for Paavo_Open_data_by_postal_code_area_2019. Column paavo_open_data_by_postal_code_area_2019 has 72648 rows, out of which 1357 are empty, making the null percent 1.87. Minimum value is 0 and maximum value is 5513130. |
Dim data, Paavo 1 he 2019 px, Latest
| Column | Type | Comment |
|---|---|---|
| code | string | The code for the dimension value. Column code has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is He_0_2 and maximum string is He_85_. |
| label | string | The label for the dimension value. Column label has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0-2 years, 2017 (HE)... and first 25 characters of maximum string: 85 years or over, 2017 (H... |
Dim data, Paavo 1 he 2019 px, Full history
| Column | Type | Comment |
|---|---|---|
| code | string | The code for the dimension value. Column code has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is He_0_2 and maximum string is He_85_. |
| label | string | The label for the dimension value. Column label has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0-2 years, 2017 (HE)... and first 25 characters of maximum string: 85 years or over, 2017 (H... |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Dim postal code area, Paavo 1 he 2019 px, Full history
| Column | Type | Comment |
|---|---|---|
| code | int | The code for the dimension value. Column code has 3027 rows, out of which 1 are empty, making the null percent 0.03. Minimum value is 100 and maximum value is 99990. |
| label | string | The label for the dimension value. Column label has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 00100 Helsinki Keskusta -... and first 25 characters of maximum string: 99990 Nuorgam (Utsjoki ... |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Dim postal code area, Paavo 1 he 2019 px, Latest
| Column | Type | Comment |
|---|---|---|
| code | int | The code for the dimension value. Column code has 3027 rows, out of which 1 are empty, making the null percent 0.03. Minimum value is 100 and maximum value is 99990. |
| label | string | The label for the dimension value. Column label has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 00100 Helsinki Keskusta -... and first 25 characters of maximum string: 99990 Nuorgam (Utsjoki ... |
Fact, Paavo 1 he 2019 px, Full history
| Column | Type | Comment |
|---|---|---|
| postal_code_area | int | 2019 postal code areas . Column postal_code_area has 72648 rows, out of which 24 are empty, making the null percent 0.03. Minimum value is 100 and maximum value is 99990. |
| data | string | Datasource did not contain a description for Data. Column data has 72648 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is He_0_2 and maximum string is He_85_. |
| paavo_open_data_by_postal_code_area_2019 | int | Datasource did not contain a description for Paavo_Open_data_by_postal_code_area_2019. Column paavo_open_data_by_postal_code_area_2019 has 72648 rows, out of which 1357 are empty, making the null percent 1.87. Minimum value is 0 and maximum value is 5513130. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | September 20, 2019 |
|---|---|
| Created | August 5, 2019 |