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

003 -- Population by area, main type of activity, level of education, sex, age and year 1987-2017*

003 -- Population by area, main type of activity, level of education, sex, age and year 1987-2017*

Tables

Column Descriptions

Fact, Statfinpas tyokay pxt 003 201700 px, Latest

Column Type Comment
area string Datasource did not contain a description for Area. Column area has 372000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 and maximum string is 21.
main_type_of_activity int Datasource did not contain a description for Main_type_of_activity. Column main_type_of_activity has 372000 rows, out of which 148800 are empty, making the null percent 40.00. Minimum value is 11 and maximum value is 99.
level_of_education int Datasource did not contain a description for Level_of_education. Column level_of_education has 372000 rows, out of which 297600 are empty, making the null percent 80.00. Constant value is 9.
sex int Datasource did not contain a description for Sex. Column sex has 372000 rows, out of which 124000 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age string Datasource did not contain a description for Age. Column age has 372000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-17 and maximum string is 65+.
year int Datasource did not contain a description for Year. Column year has 372000 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.
population int Datasource did not contain a description for Population. Column population has 372000 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 5513130.

Dim area, Statfinpas tyokay pxt 003 201700 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 Central Finland and maximum string is Åland.

Fact, Statfinpas tyokay pxt 003 201700 px, Full history

Column Type Comment
area string Datasource did not contain a description for Area. Column area has 372000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 and maximum string is 21.
main_type_of_activity int Datasource did not contain a description for Main_type_of_activity. Column main_type_of_activity has 372000 rows, out of which 148800 are empty, making the null percent 40.00. Minimum value is 11 and maximum value is 99.
level_of_education int Datasource did not contain a description for Level_of_education. Column level_of_education has 372000 rows, out of which 297600 are empty, making the null percent 80.00. Constant value is 9.
sex int Datasource did not contain a description for Sex. Column sex has 372000 rows, out of which 124000 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age string Datasource did not contain a description for Age. Column age has 372000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-17 and maximum string is 65+.
year int Datasource did not contain a description for Year. Column year has 372000 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.
population int Datasource did not contain a description for Population. Column population has 372000 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 5513130.
orig_extractdate string The date when the data was originally fetched from the source.

Dim age, Statfinpas tyokay pxt 003 201700 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-17 and maximum string is 65+.
label string The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-17 and maximum string is 65+.

Dim age, Statfinpas tyokay pxt 003 201700 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-17 and maximum string is 65+.
label string The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-17 and maximum string is 65+.
orig_extractdate string The date when the data was originally fetched from the source.

Dim main type of activity, Statfinpas tyokay pxt 003 201700 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 10 rows, out of which 4 are empty, making the null percent 40.00. Minimum value is 11 and maximum value is 99.
label string The label for the dimension value. Column label has 10 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-14 years old... and first 25 characters of maximum string: Other persons outside the...

Dim main type of activity, Statfinpas tyokay pxt 003 201700 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 10 rows, out of which 4 are empty, making the null percent 40.00. Minimum value is 11 and maximum value is 99.
label string The label for the dimension value. Column label has 10 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-14 years old... and first 25 characters of maximum string: Other persons outside the...
orig_extractdate string The date when the data was originally fetched from the source.

Dim area, Statfinpas tyokay pxt 003 201700 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 Central Finland and maximum string is Åland.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas tyokay pxt 003 201700 px, Latest

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.

Dim year, Statfinpas tyokay pxt 003 201700 px, Full history

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 sex, Statfinpas tyokay pxt 003 201700 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 sex, Statfinpas tyokay pxt 003 201700 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 level of education, Statfinpas tyokay pxt 003 201700 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 5 rows, out of which 4 are empty, making the null percent 80.00. Constant value is 9.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Basic education / Level o... and first 25 characters of maximum string: Higher-degree level terti...
orig_extractdate string The date when the data was originally fetched from the source.

Dim level of education, Statfinpas tyokay pxt 003 201700 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 5 rows, out of which 4 are empty, making the null percent 80.00. Constant value is 9.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Basic education / Level o... and first 25 characters of maximum string: Higher-degree level terti...

Additional Info

Last Updated September 22, 2019
Created August 6, 2019