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

11 aq -- Local government hourly wages, 2018

11 aq -- Local government hourly wages, 2018

Tables

Column Descriptions

Dim the standard industrial classification 2008, Statfin ksp pxt 11aq px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 102 rows, out of which 13 are empty, making the null percent 12.75. Minimum value is 2 and maximum value is 93190.
label string The label for the dimension value. Column label has 102 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 02100 Silviculture and ot... and first 25 characters of maximum string: 93190 Other sports activi...

Dim sex, Statfin ksp pxt 11aq 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 the standard industrial classification 2008, Statfin ksp pxt 11aq px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 102 rows, out of which 13 are empty, making the null percent 12.75. Minimum value is 2 and maximum value is 93190.
label string The label for the dimension value. Column label has 102 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 02100 Silviculture and ot... and first 25 characters of maximum string: 93190 Other sports activi...
orig_extractdate string The date when the data was originally fetched from the source.

Dim sex, Statfin ksp pxt 11aq 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 ksp pxt 11aq px, Latest

Column Type Comment
the_standard_industrial_classification_2008 int The Standard Industrial Classification 2008 is a national classification standard confirmed by Statistics Finland. . Column the_standard_industrial_classification_2008 has 306 rows, out of which 39 are empty, making the null percent 12.75. Minimum value is 2 and maximum value is 93190.
sex int Sex (sexes total/men/women) . Column sex has 306 rows, out of which 102 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
year int the statistical year of the material . Column year has 306 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2018.
total_number_of_hourlypaid_employees int (Hourly-paid) Number total. . Column total_number_of_hourlypaid_employees has 306 rows, out of which 12 are empty, making the null percent 3.92. Minimum value is 1 and maximum value is 6787.
average_of_hourly_earnings_for_regular_hours_worked_eurh int (Hourly-paid) Average of hourly earnings for regular hours worked. . Column average_of_hourly_earnings_for_regular_hours_worked_eurh has 306 rows, out of which 94 are empty, making the null percent 30.72. Minimum value is 10 and maximum value is 19.
average_of_total_hourly_earnings_eurh int (Hourly-paid) Average of total hourly earnings, EUR/h . Column average_of_total_hourly_earnings_eurh has 306 rows, out of which 94 are empty, making the null percent 30.72. Minimum value is 10 and maximum value is 19.

Fact, Statfin ksp pxt 11aq px, Full history

Column Type Comment
the_standard_industrial_classification_2008 int The Standard Industrial Classification 2008 is a national classification standard confirmed by Statistics Finland. . Column the_standard_industrial_classification_2008 has 306 rows, out of which 39 are empty, making the null percent 12.75. Minimum value is 2 and maximum value is 93190.
sex int Sex (sexes total/men/women) . Column sex has 306 rows, out of which 102 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
year int the statistical year of the material . Column year has 306 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2018.
total_number_of_hourlypaid_employees int (Hourly-paid) Number total. . Column total_number_of_hourlypaid_employees has 306 rows, out of which 12 are empty, making the null percent 3.92. Minimum value is 1 and maximum value is 6787.
average_of_hourly_earnings_for_regular_hours_worked_eurh int (Hourly-paid) Average of hourly earnings for regular hours worked. . Column average_of_hourly_earnings_for_regular_hours_worked_eurh has 306 rows, out of which 94 are empty, making the null percent 30.72. Minimum value is 10 and maximum value is 19.
average_of_total_hourly_earnings_eurh int (Hourly-paid) Average of total hourly earnings, EUR/h . Column average_of_total_hourly_earnings_eurh has 306 rows, out of which 94 are empty, making the null percent 30.72. Minimum value is 10 and maximum value is 19.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019