To download the data set, please sign up or log in

014 -- Employed labour force in area by area, commuting, level of education, age and year 1987-2016

014 -- Employed labour force in area by area, commuting, level of education, age and year 1987-2016

Tables

Column Descriptions

Fact, Statfinpas tyokay pxt 014 201600 px, Latest

Column Type Comment
area_workplace int Datasource did not contain a description for Area_workplace. Column area_workplace has 1263600 rows, out of which 4050 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
commuting int Datasource did not contain a description for Commuting. Column commuting has 1263600 rows, out of which 421200 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
level_of_education int Datasource did not contain a description for Level_of_education. Column level_of_education has 1263600 rows, out of which 1010880 are empty, making the null percent 80.00. Constant value is 9.
age string Datasource did not contain a description for Age. Column age has 1263600 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 75-.
year int Datasource did not contain a description for Year. Column year has 1263600 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 2016.
employed_labour_force int Datasource did not contain a description for Employed_labour_force. Column employed_labour_force has 1263600 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 2377181.

Dim area workplace, Statfinpas tyokay pxt 014 201600 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 312 rows, out of which 1 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski.

Dim area workplace, Statfinpas tyokay pxt 014 201600 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 312 rows, out of which 1 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski.
orig_extractdate string The date when the data was originally fetched from the source.

Dim commuting, Statfinpas tyokay pxt 014 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. First 25 characters of minimum string: Commuters... and first 25 characters of maximum string: Persons working in their ...

Dim commuting, Statfinpas tyokay pxt 014 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. First 25 characters of minimum string: Commuters... and first 25 characters of maximum string: Persons working in their ...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas tyokay pxt 014 201600 px, Full history

Column Type Comment
area_workplace int Datasource did not contain a description for Area_workplace. Column area_workplace has 1263600 rows, out of which 4050 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
commuting int Datasource did not contain a description for Commuting. Column commuting has 1263600 rows, out of which 421200 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
level_of_education int Datasource did not contain a description for Level_of_education. Column level_of_education has 1263600 rows, out of which 1010880 are empty, making the null percent 80.00. Constant value is 9.
age string Datasource did not contain a description for Age. Column age has 1263600 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 75-.
year int Datasource did not contain a description for Year. Column year has 1263600 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 2016.
employed_labour_force int Datasource did not contain a description for Employed_labour_force. Column employed_labour_force has 1263600 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 2377181.
orig_extractdate string The date when the data was originally fetched from the source.

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

Column Type Comment
code int The code for the dimension value. Column code has 30 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 2016.
label int The label for the dimension value. Column label has 30 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 2016.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas tyokay pxt 014 201600 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 30 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 2016.
label int The label for the dimension value. Column label has 30 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 2016.

Dim age, Statfinpas tyokay pxt 014 201600 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 9 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 75-.
label string The label for the dimension value. Column label has 9 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 75 -.
orig_extractdate string The date when the data was originally fetched from the source.

Dim age, Statfinpas tyokay pxt 014 201600 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 9 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 75-.
label string The label for the dimension value. Column label has 9 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 75 -.

Dim level of education, Statfinpas tyokay pxt 014 201600 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...

Dim level of education, Statfinpas tyokay pxt 014 201600 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.

Additional Info

Last Updated July 20, 2019
Created July 12, 2019