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

012 -- Employed labour force by area, industry (TOL 2008), occupational status, age, sex and year 2007-2016

012 -- Employed labour force by area, industry (TOL 2008), occupational status, age, sex and year 2007-2016

Tables

Column Descriptions

Dim occupational status, Statfinpas tyokay pxt 012 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 Entrepreneurs and maximum string is Wage and salary earners.
orig_extractdate string The date when the data was originally fetched from the source.

Dim age, Statfinpas tyokay pxt 012 201600 px, Latest

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 18-24 and maximum string is 65-74.
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. Minimum string is 18 - 24 and maximum string is 65 - 74.

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

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 18-24 and maximum string is 65-74.
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. Minimum string is 18 - 24 and maximum string is 65 - 74.
orig_extractdate string The date when the data was originally fetched from the source.

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

Dim industry, Statfinpas tyokay pxt 012 201600 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 23 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is X.
label string The label for the dimension value. Column label has 23 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...

Dim occupational status, Statfinpas tyokay pxt 012 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 Entrepreneurs and maximum string is Wage and salary earners.

Fact, Statfinpas tyokay pxt 012 201600 px, Full history

Column Type Comment
area string Datasource did not contain a description for Area. Column area has 289800 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.
industry string Datasource did not contain a description for Industry. Column industry has 289800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is X.
occupational_status string Datasource did not contain a description for Occupational_status. Column occupational_status has 289800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2.
age string Datasource did not contain a description for Age. Column age has 289800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 18-24 and maximum string is 65-74.
sex int Datasource did not contain a description for Sex. Column sex has 289800 rows, out of which 96600 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 289800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2007 and maximum value is 2016.
employed_labour_force int Datasource did not contain a description for Employed_labour_force. Column employed_labour_force has 289800 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 012 201600 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2007 and maximum value is 2016.
label int 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. Minimum value is 2007 and maximum value is 2016.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas tyokay pxt 012 201600 px, Latest

Column Type Comment
area string Datasource did not contain a description for Area. Column area has 289800 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.
industry string Datasource did not contain a description for Industry. Column industry has 289800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is X.
occupational_status string Datasource did not contain a description for Occupational_status. Column occupational_status has 289800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2.
age string Datasource did not contain a description for Age. Column age has 289800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 18-24 and maximum string is 65-74.
sex int Datasource did not contain a description for Sex. Column sex has 289800 rows, out of which 96600 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 289800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2007 and maximum value is 2016.
employed_labour_force int Datasource did not contain a description for Employed_labour_force. Column employed_labour_force has 289800 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 sex, Statfinpas tyokay pxt 012 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 industry, Statfinpas tyokay pxt 012 201600 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 23 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is X.
label string The label for the dimension value. Column label has 23 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...
orig_extractdate string The date when the data was originally fetched from the source.

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

Dim sex, Statfinpas tyokay pxt 012 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 year, Statfinpas tyokay pxt 012 201600 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2007 and maximum value is 2016.
label int 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. Minimum value is 2007 and maximum value is 2016.

Additional Info

Last Updated September 22, 2019
Created August 5, 2019