1. Home
  2. Datasets
  3. 019 -- Population by ...
To download the data set, please sign up or log in

019 -- Population by socio-economic status, area, main type of activity, sex and year 2010-2016

019 -- Population by socio-economic status, area, main type of activity, sex and year 2010-2016

Tables

Column Descriptions

Dim sex, Statfinpas tyokay pxt 019 201600 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Both sexes and maximum string is Females.
orig_extractdate string The date when the data was originally fetched from the source.

Dim area, Statfinpas tyokay pxt 019 201600 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 20 rows, out of which 1 are empty, making the null percent 5.00. Minimum value is 1 and maximum value is 21.
label string The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahvenanmaa - Åland and maximum string is Lappi.

Dim main type of activity, Statfinpas tyokay pxt 019 201600 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 11.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Employed... and first 25 characters of maximum string: Unemployed and persons ou...
orig_extractdate string The date when the data was originally fetched from the source.

Dim socioeconomic status, Statfinpas tyokay pxt 019 201600 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 11 rows, out of which 1 are empty, making the null percent 9.09. Minimum value is 1 and maximum value is 20.
label string The label for the dimension value. Column label has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 10 Farmer etc. entrepeneu... and first 25 characters of maximum string: 9 Unknown...
orig_extractdate string The date when the data was originally fetched from the source.

Dim socioeconomic status, Statfinpas tyokay pxt 019 201600 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 11 rows, out of which 1 are empty, making the null percent 9.09. Minimum value is 1 and maximum value is 20.
label string The label for the dimension value. Column label has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 10 Farmer etc. entrepeneu... and first 25 characters of maximum string: 9 Unknown...

Fact, Statfinpas tyokay pxt 019 201600 px, Full history

Column Type Comment
socioeconomic_status int Datasource did not contain a description for Socioeconomic_status. Column socioeconomic_status has 13860 rows, out of which 1260 are empty, making the null percent 9.09. Minimum value is 1 and maximum value is 20.
area int Datasource did not contain a description for Area. Column area has 13860 rows, out of which 693 are empty, making the null percent 5.00. Minimum value is 1 and maximum value is 21.
main_type_of_activity string Datasource did not contain a description for Main_type_of_activity. Column main_type_of_activity has 13860 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 11 and maximum string is 12-99.
sex int Datasource did not contain a description for Sex. Column sex has 13860 rows, out of which 4620 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
year int Datasource did not contain a description for Year. Column year has 13860 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2016.
population int Datasource did not contain a description for Population. Column population has 13860 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 5503297.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas tyokay pxt 019 201600 px, Latest

Column Type Comment
socioeconomic_status int Datasource did not contain a description for Socioeconomic_status. Column socioeconomic_status has 13860 rows, out of which 1260 are empty, making the null percent 9.09. Minimum value is 1 and maximum value is 20.
area int Datasource did not contain a description for Area. Column area has 13860 rows, out of which 693 are empty, making the null percent 5.00. Minimum value is 1 and maximum value is 21.
main_type_of_activity string Datasource did not contain a description for Main_type_of_activity. Column main_type_of_activity has 13860 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 11 and maximum string is 12-99.
sex int Datasource did not contain a description for Sex. Column sex has 13860 rows, out of which 4620 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
year int Datasource did not contain a description for Year. Column year has 13860 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2016.
population int Datasource did not contain a description for Population. Column population has 13860 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 5503297.

Dim sex, Statfinpas tyokay pxt 019 201600 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Both sexes and maximum string is Females.

Dim main type of activity, Statfinpas tyokay pxt 019 201600 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 11.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Employed... and first 25 characters of maximum string: Unemployed and persons ou...

Dim year, Statfinpas tyokay pxt 019 201600 px, Latest

Column Type Comment
code int 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 value is 2010 and maximum value is 2016.
label int 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. Minimum value is 2010 and maximum value is 2016.

Dim area, Statfinpas tyokay pxt 019 201600 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 20 rows, out of which 1 are empty, making the null percent 5.00. Minimum value is 1 and maximum value is 21.
label string The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahvenanmaa - Åland and maximum string is Lappi.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas tyokay pxt 019 201600 px, Full history

Column Type Comment
code int 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 value is 2010 and maximum value is 2016.
label int 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. Minimum value is 2010 and maximum value is 2016.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 22, 2019
Created July 19, 2019