8. Main type of activity 2016
Tables
-
Dim Data, T8 Main Type Of Activity 2016TSV
Dimension Data (Tiedot)
-
Dim Postal Code Area, T8 Main Type Of Activity 2016TSV
Dimension Postal_code_area (Postinumeroalue)
-
Fact, T8 Main Type Of Activity 2016TSV
Fact table of 8_main_type_of_activity_2016
Column Descriptions
Dim Postal Code Area, T8 Main Type Of Activity 2016
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 Data, T8 Main Type Of Activity 2016
Column | Type | Comment |
---|---|---|
code | string | The code for the dimension value. Column code has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Pt_0_14 and maximum string is Pt_muut. |
label | string | The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Children aged 0 to 14, 20... and first 25 characters of maximum string: Others, 2016 (PT)... |
orig_extractdate | string | The date when the data was originally fetched from the source. |
Fact, T8 Main Type Of Activity 2016
Column | Type | Comment |
---|---|---|
postal_code_area | int | 2019 postal code areas . Column postal_code_area has 21189 rows, out of which 7 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 21189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Pt_0_14 and maximum string is Pt_muut. |
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 21189 rows, out of which 348 are empty, making the null percent 1.64. Minimum value is 0 and maximum value is 5503297. |
orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
Last Updated | April 16, 2019 |
---|---|
Created | April 13, 2019 |