117 b -- Private sector hourly wages by classification of Occupations, 2017

Tables

Dim classification of occupations 2010, Statfin ystp pxt 117b px, Full historyTSV
Dimension Classification_of_Occupations_2010 (Ammattiluokitus 2010)
Dim classification of occupations 2010, Statfin ystp pxt 117b px, LatestTSV
Dimension Classification_of_Occupations_2010 (Ammattiluokitus 2010)
Dim gender, Statfin ystp pxt 117b px, Full historyTSV
Dimension Gender (Sukupuoli)
Dim gender, Statfin ystp pxt 117b px, LatestTSV
Dimension Gender (Sukupuoli)
Fact, Statfin ystp pxt 117b px, Full historyTSV
Private sector hourly wages by classification of Occupations year 2017 by Classification of Occupations 2010, Gender, Year and Information
Fact, Statfin ystp pxt 117b px, LatestTSV
Private sector hourly wages by classification of Occupations year 2017 by Classification of Occupations 2010, Gender, Year and Information

Column Descriptions

Fact, Statfin ystp pxt 117b px, Latest

Column	Type	Comment
classification_of_occupations_2010	int	Classification of Occupations 2010 . Column classification_of_occupations_2010 has 1131 rows, out of which 18 are empty, making the null percent 1.59. Minimum value is 2 and maximum value is 91129.
gender	int	Gender . Column gender has 1131 rows, out of which 377 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 1131 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2017.
number_of_employees	int	Number of employees . Column number_of_employees has 1131 rows, out of which 22 are empty, making the null percent 1.95. Minimum value is 1 and maximum value is 325922.
average_regular_earnings	int	Average regular earnings . Column average_regular_earnings has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 8 and maximum value is 53.
average_regular_earnings_1st_decile	int	Average regular earnings 1st decile . Column average_regular_earnings_1st_decile has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 5 and maximum value is 30.
average_regular_earnings_median	int	Average regular earnings median . Column average_regular_earnings_median has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 8 and maximum value is 53.
average_regular_earnings_9th_decile	int	Average regular earnings 9th decile . Column average_regular_earnings_9th_decile has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 10 and maximum value is 95.
average_regular_earnings_9th_decile_1st_decile	int	Average regular earnings 9th decile / 1st decile . Column average_regular_earnings_9th_decile_1st_decile has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 1 and maximum value is 10.
average_total_earnings	int	Average total earnings . Column average_total_earnings has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 8 and maximum value is 53.
average_total_earnings_1st_decile	int	Average total earnings 1st decile . Column average_total_earnings_1st_decile has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 5 and maximum value is 30.
average_total_earnings_median	int	Average total earnings median . Column average_total_earnings_median has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 8 and maximum value is 53.
average_total_earnings_9th_decile	int	Average total earnings 9th decile . Column average_total_earnings_9th_decile has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 10 and maximum value is 95.
average_total_earnings_9th_decile_1st_decile	int	Average total earnings 9th decile / 1st decile . Column average_total_earnings_9th_decile_1st_decile has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 1 and maximum value is 10.

Fact, Statfin ystp pxt 117b px, Full history

Column	Type	Comment
classification_of_occupations_2010	int	Classification of Occupations 2010 . Column classification_of_occupations_2010 has 1131 rows, out of which 18 are empty, making the null percent 1.59. Minimum value is 2 and maximum value is 91129.
gender	int	Gender . Column gender has 1131 rows, out of which 377 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 1131 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2017.
number_of_employees	int	Number of employees . Column number_of_employees has 1131 rows, out of which 22 are empty, making the null percent 1.95. Minimum value is 1 and maximum value is 325922.
average_regular_earnings	int	Average regular earnings . Column average_regular_earnings has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 8 and maximum value is 53.
average_regular_earnings_1st_decile	int	Average regular earnings 1st decile . Column average_regular_earnings_1st_decile has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 5 and maximum value is 30.
average_regular_earnings_median	int	Average regular earnings median . Column average_regular_earnings_median has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 8 and maximum value is 53.
average_regular_earnings_9th_decile	int	Average regular earnings 9th decile . Column average_regular_earnings_9th_decile has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 10 and maximum value is 95.
average_regular_earnings_9th_decile_1st_decile	int	Average regular earnings 9th decile / 1st decile . Column average_regular_earnings_9th_decile_1st_decile has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 1 and maximum value is 10.
average_total_earnings	int	Average total earnings . Column average_total_earnings has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 8 and maximum value is 53.
average_total_earnings_1st_decile	int	Average total earnings 1st decile . Column average_total_earnings_1st_decile has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 5 and maximum value is 30.
average_total_earnings_median	int	Average total earnings median . Column average_total_earnings_median has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 8 and maximum value is 53.
average_total_earnings_9th_decile	int	Average total earnings 9th decile . Column average_total_earnings_9th_decile has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 10 and maximum value is 95.
average_total_earnings_9th_decile_1st_decile	int	Average total earnings 9th decile / 1st decile . Column average_total_earnings_9th_decile_1st_decile has 1131 rows, out of which 355 are empty, making the null percent 31.39. Minimum value is 1 and maximum value is 10.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim classification of occupations 2010, Statfin ystp pxt 117b px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 377 rows, out of which 6 are empty, making the null percent 1.59. Minimum value is 2 and maximum value is 91129.
label	string	The label for the dimension value. Column label has 377 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2142 Civil engineers and maximum string is XXXXX Unknown.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim classification of occupations 2010, Statfin ystp pxt 117b px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 377 rows, out of which 6 are empty, making the null percent 1.59. Minimum value is 2 and maximum value is 91129.
label	string	The label for the dimension value. Column label has 377 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2142 Civil engineers and maximum string is XXXXX Unknown.

Dim gender, Statfin ystp pxt 117b 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 gender, Statfin ystp pxt 117b 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 12, 2019
Created	July 12, 2019