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

009 -- Employed labour force in area (workplaces) by area, employer sector, sex and year 1987-2016

009 -- Employed labour force in area (workplaces) by area, employer sector, sex and year 1987-2016

Tables

Column Descriptions

Dim area workplace, Statfinpas tyokay pxt 009 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 employer sector, Statfinpas tyokay pxt 009 201600 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 9.
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 Entrepreneurs and maximum string is Unknown.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas tyokay pxt 009 201600 px, Full history

Column Type Comment
area_workplace int Datasource did not contain a description for Area_workplace. Column area_workplace has 196560 rows, out of which 630 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
employer_sector int Datasource did not contain a description for Employer_sector. Column employer_sector has 196560 rows, out of which 28080 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 9.
sex string Datasource did not contain a description for Sex. Column sex has 196560 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.
year int Datasource did not contain a description for Year. Column year has 196560 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_in_area_workplaces int Datasource did not contain a description for Employed_labour_force_in_area_workplaces. Column employed_labour_force_in_area_workplaces has 196560 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 area workplace, Statfinpas tyokay pxt 009 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.

Fact, Statfinpas tyokay pxt 009 201600 px, Latest

Column Type Comment
area_workplace int Datasource did not contain a description for Area_workplace. Column area_workplace has 196560 rows, out of which 630 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
employer_sector int Datasource did not contain a description for Employer_sector. Column employer_sector has 196560 rows, out of which 28080 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 9.
sex string Datasource did not contain a description for Sex. Column sex has 196560 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.
year int Datasource did not contain a description for Year. Column year has 196560 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_in_area_workplaces int Datasource did not contain a description for Employed_labour_force_in_area_workplaces. Column employed_labour_force_in_area_workplaces has 196560 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 employer sector, Statfinpas tyokay pxt 009 201600 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 9.
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 Entrepreneurs and maximum string is Unknown.

Dim sex, Statfinpas tyokay pxt 009 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 sex, Statfinpas tyokay pxt 009 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.

Additional Info

Last Updated July 20, 2019
Created July 19, 2019