1. Home
  2. Datasets
  3. 11 zw -- Index of regular ...
To download the data set, please sign up or log in

11 zw -- Index of regular earnings fixed by the main category of occupations by employer sector, 2010 Q 1-2017 Q 4

11 zw -- Index of regular earnings fixed by the main category of occupations by employer sector, 2010 Q 1-2017 Q 4

Tables

Column Descriptions

Fact, Statfin ati pxt 11zw px, Latest

Column Type Comment
quarter string Datasource did not contain a description for Quarter. Column quarter has 3200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2010Q1 and maximum string is 2017Q4.
employer_sector int Datasource did not contain a description for Employer_sector. Column employer_sector has 3200 rows, out of which 640 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 7.
classification_of_occupations_2010 int Datasource did not contain a description for Classification_of_Occupations_2010. Column classification_of_occupations_2010 has 3200 rows, out of which 320 are empty, making the null percent 10.00. Minimum value is 1 and maximum value is 9.
index_of_regular_earnings_2010100_fixed_by_the_main_category_of_occupations int Datasource did not contain a description for Index_of_regular_earnings_2010100_fixed_by_the_main_category_of_occupations. Column index_of_regular_earnings_2010100_fixed_by_the_main_category_of_occupations has 3200 rows, out of which 1308 are empty, making the null percent 40.88. Minimum value is 98 and maximum value is 123.

Dim employer sector, Statfin ati pxt 11zw px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 5 rows, out of which 1 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 7.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is All sectors and maximum string is Others.
orig_extractdate string The date when the data was originally fetched from the source.

Dim quarter, Statfin ati pxt 11zw px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 32 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2010Q1 and maximum string is 2017Q4.
label string The label for the dimension value. Column label has 32 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2010Q1 and maximum string is 2017Q4.

Dim quarter, Statfin ati pxt 11zw px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 32 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2010Q1 and maximum string is 2017Q4.
label string The label for the dimension value. Column label has 32 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2010Q1 and maximum string is 2017Q4.
orig_extractdate string The date when the data was originally fetched from the source.

Dim employer sector, Statfin ati pxt 11zw px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 5 rows, out of which 1 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 7.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is All sectors and maximum string is Others.

Dim classification of occupations 2010, Statfin ati pxt 11zw px, Full history

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

Fact, Statfin ati pxt 11zw px, Full history

Column Type Comment
quarter string Datasource did not contain a description for Quarter. Column quarter has 3200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2010Q1 and maximum string is 2017Q4.
employer_sector int Datasource did not contain a description for Employer_sector. Column employer_sector has 3200 rows, out of which 640 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 7.
classification_of_occupations_2010 int Datasource did not contain a description for Classification_of_Occupations_2010. Column classification_of_occupations_2010 has 3200 rows, out of which 320 are empty, making the null percent 10.00. Minimum value is 1 and maximum value is 9.
index_of_regular_earnings_2010100_fixed_by_the_main_category_of_occupations int Datasource did not contain a description for Index_of_regular_earnings_2010100_fixed_by_the_main_category_of_occupations. Column index_of_regular_earnings_2010100_fixed_by_the_main_category_of_occupations has 3200 rows, out of which 1308 are empty, making the null percent 40.88. Minimum value is 98 and maximum value is 123.
orig_extractdate string The date when the data was originally fetched from the source.

Dim classification of occupations 2010, Statfin ati pxt 11zw px, Latest

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

Additional Info

Last Updated September 20, 2019
Created August 4, 2019