To download the data set, please sign up or log in
7. Workplace structure 2016
Tables
-
Dim data, Paavo 7 tp 2019 px, Full historyTSV
Dimension Data (Tiedot)
-
Dim data, Paavo 7 tp 2019 px, LatestTSV
Dimension Data (Tiedot)
-
Dim postal code area, Paavo 7 tp 2019 px, Full historyTSV
Dimension Postal_code_area (Postinumeroalue)
-
Dim postal code area, Paavo 7 tp 2019 px, LatestTSV
Dimension Postal_code_area (Postinumeroalue)
-
Fact, Paavo 7 tp 2019 px, Full historyTSV
Fact table of paavo_7_tp_2019_px
-
Fact, Paavo 7 tp 2019 px, LatestTSV
Fact table of paavo_7_tp_2019_px
Column Descriptions
Dim data, Paavo 7 tp 2019 px, Latest
| Column | Type | Comment |
|---|---|---|
| code | string | The code for the dimension value. Column code has 26 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Tp_a_maat and maximum string is Tp_x_tunt. |
| label | string | The label for the dimension value. Column label has 26 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: A Agriculture, forestry a... and first 25 characters of maximum string: X Industry unknown, 2016 ... |
Fact, Paavo 7 tp 2019 px, Latest
| Column | Type | Comment |
|---|---|---|
| postal_code_area | int | 2019 postal code areas . Column postal_code_area has 78702 rows, out of which 26 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 78702 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Tp_a_maat and maximum string is Tp_x_tunt. |
| 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 78702 rows, out of which 7425 are empty, making the null percent 9.43. Minimum value is 0 and maximum value is 2094313. |
Fact, Paavo 7 tp 2019 px, Full history
| Column | Type | Comment |
|---|---|---|
| postal_code_area | int | 2019 postal code areas . Column postal_code_area has 78702 rows, out of which 26 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 78702 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Tp_a_maat and maximum string is Tp_x_tunt. |
| 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 78702 rows, out of which 7425 are empty, making the null percent 9.43. Minimum value is 0 and maximum value is 2094313. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Dim postal code area, Paavo 7 tp 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 7 tp 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 ... |
Dim data, Paavo 7 tp 2019 px, Full history
| Column | Type | Comment |
|---|---|---|
| code | string | The code for the dimension value. Column code has 26 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Tp_a_maat and maximum string is Tp_x_tunt. |
| label | string | The label for the dimension value. Column label has 26 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: A Agriculture, forestry a... and first 25 characters of maximum string: X Industry unknown, 2016 ... |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | July 20, 2019 |
|---|---|
| Created | July 13, 2019 |