Dataset

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

115 r -- Employed persons by occupation group (Classification of Occupations 2010, levels 1 to 5), sex, age and year, 2010-2016

115 r -- Employed persons by occupation group (Classification of Occupations 2010, levels 1 to 5), sex, age and year, 2010-2016

Tables

Dim age, Statfin tyokay pxt 115r px, Full historyTSV
Dimension Age (Ikä)
Dim age, Statfin tyokay pxt 115r px, LatestTSV
Dimension Age (Ikä)
Dim occupational group, Statfin tyokay pxt 115r px, Full historyTSV
Dimension Occupational_group (Ammattiryhmä)
Dim occupational group, Statfin tyokay pxt 115r px, LatestTSV
Dimension Occupational_group (Ammattiryhmä)
Dim sex, Statfin tyokay pxt 115r px, Full historyTSV
Dimension Sex (Sukupuoli)
Dim sex, Statfin tyokay pxt 115r px, LatestTSV
Dimension Sex (Sukupuoli)
Dim year, Statfin tyokay pxt 115r px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin tyokay pxt 115r px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin tyokay pxt 115r px, Full historyTSV
Employed by Occupational group, Sex, Age, Year and Information
Fact, Statfin tyokay pxt 115r px, LatestTSV
Employed by Occupational group, Sex, Age, Year and Information

Column Descriptions

Dim age, Statfin tyokay pxt 115r 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 year, Statfin tyokay pxt 115r 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.

Dim year, Statfin tyokay pxt 115r 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.

Fact, Statfin tyokay pxt 115r px, Latest

Column	Type	Comment
occupational_group	int	Datasource did not contain a description for Occupational_group. Column occupational_group has 173901 rows, out of which 7350 are empty, making the null percent 4.23. Minimum value is 0 and maximum value is 91129.
sex	string	Datasource did not contain a description for Sex. Column sex has 173901 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 173901 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.
year	int	Datasource did not contain a description for Year. Column year has 173901 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.
employed	int	Datasource did not contain a description for Employed. Column employed has 173901 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 2354422.

Dim age, Statfin tyokay pxt 115r 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 sex, Statfin tyokay pxt 115r 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 Females and maximum string is Total.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim sex, Statfin tyokay pxt 115r 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 Females and maximum string is Total.

Fact, Statfin tyokay pxt 115r px, Full history

Column	Type	Comment
occupational_group	int	Datasource did not contain a description for Occupational_group. Column occupational_group has 173901 rows, out of which 7350 are empty, making the null percent 4.23. Minimum value is 0 and maximum value is 91129.
sex	string	Datasource did not contain a description for Sex. Column sex has 173901 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 173901 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.
year	int	Datasource did not contain a description for Year. Column year has 173901 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.
employed	int	Datasource did not contain a description for Employed. Column employed has 173901 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 2354422.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim occupational group, Statfin tyokay pxt 115r px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 1183 rows, out of which 50 are empty, making the null percent 4.23. Minimum value is 0 and maximum value is 91129.
label	string	The label for the dimension value. Column label has 1183 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0110. Commissioned armed ... and first 25 characters of maximum string: XXXXX Unknown (Level 5)...

Dim occupational group, Statfin tyokay pxt 115r px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 1183 rows, out of which 50 are empty, making the null percent 4.23. Minimum value is 0 and maximum value is 91129.
label	string	The label for the dimension value. Column label has 1183 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0110. Commissioned armed ... and first 25 characters of maximum string: XXXXX Unknown (Level 5)...
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	September 20, 2019
Created	August 3, 2019