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

11 qj -- Employed persons and employees aged 15-74 by employer sector and industry (TOL 2008), 2005-2018

11 qj -- Employed persons and employees aged 15-74 by employer sector and industry (TOL 2008), 2005-2018

Tables

Column Descriptions

Fact, Statfin tyti pxt 11qj px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 1176 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.
industry string Datasource did not contain a description for Industry. Column industry has 1176 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A_B and maximum string is RTU.
employer_sector int Datasource did not contain a description for Employer_sector. Column employer_sector has 1176 rows, out of which 784 are empty, making the null percent 66.67. Constant value is 3.
employed_1000_persons int Datasource did not contain a description for Employed_1000_persons. Column employed_1000_persons has 1176 rows, out of which 42 are empty, making the null percent 3.57. Minimum value is 2 and maximum value is 2540.

Fact, Statfin tyti pxt 11qj px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 1176 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.
industry string Datasource did not contain a description for Industry. Column industry has 1176 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A_B and maximum string is RTU.
employer_sector int Datasource did not contain a description for Employer_sector. Column employer_sector has 1176 rows, out of which 784 are empty, making the null percent 66.67. Constant value is 3.
employed_1000_persons int Datasource did not contain a description for Employed_1000_persons. Column employed_1000_persons has 1176 rows, out of which 42 are empty, making the null percent 3.57. Minimum value is 2 and maximum value is 2540.
orig_extractdate string The date when the data was originally fetched from the source.

Dim employer sector, Statfin tyti pxt 11qj px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 3.
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 Employer sector total and maximum string is Public sector.

Dim employer sector, Statfin tyti pxt 11qj px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 3.
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 Employer sector total and maximum string is Public sector.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfin tyti pxt 11qj px, Full history

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

Dim industry, Statfin tyti pxt 11qj px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A_B and maximum string is RTU.
label string The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Agriculture, forestry and... and first 25 characters of maximum string: R-U Arts, entertainment a...

Dim year, Statfin tyti pxt 11qj px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.
label int The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.

Dim industry, Statfin tyti pxt 11qj px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A_B and maximum string is RTU.
label string The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Agriculture, forestry and... and first 25 characters of maximum string: R-U Arts, entertainment a...
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 22, 2019
Created July 20, 2019