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

003 -- Job vacancies by employer sector of the establishment

003 -- Job vacancies by employer sector of the establishment

Tables

Column Descriptions

Dim employer, Statfinpas atp pxt 003 2018q3 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 6 rows, out of which 1 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 6.
label string The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Central Government and maximum string is Other.

Dim employer, Statfinpas atp pxt 003 2018q3 px, Full history

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

Fact, Statfinpas atp pxt 003 2018q3 px, Latest

Column Type Comment
data string Datasource did not contain a description for Data. Column data has 180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Atp_lkm.
employer int Datasource did not contain a description for Employer. Column employer has 180 rows, out of which 30 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 6.
year int Datasource did not contain a description for Year. Column year has 180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2013 and maximum value is 2018.
quarterly_data_and_annual_average int Datasource did not contain a description for Quarterly_data_and_annual_average. Column quarterly_data_and_annual_average has 180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 5.
003_job_vacancies_by_employer_sector_of_the_establishment int Datasource did not contain a description for 003_Job_vacancies_by_employer_sector_of_the_establishment. Column 003_job_vacancies_by_employer_sector_of_the_establishment has 180 rows, out of which 12 are empty, making the null percent 6.67. Minimum value is 100 and maximum value is 60100.

Dim data, Statfinpas atp pxt 003 2018q3 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Atp_lkm.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Job vacancies.
orig_extractdate string The date when the data was originally fetched from the source.

Dim data, Statfinpas atp pxt 003 2018q3 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Atp_lkm.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Job vacancies.

Fact, Statfinpas atp pxt 003 2018q3 px, Full history

Column Type Comment
data string Datasource did not contain a description for Data. Column data has 180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Atp_lkm.
employer int Datasource did not contain a description for Employer. Column employer has 180 rows, out of which 30 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 6.
year int Datasource did not contain a description for Year. Column year has 180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2013 and maximum value is 2018.
quarterly_data_and_annual_average int Datasource did not contain a description for Quarterly_data_and_annual_average. Column quarterly_data_and_annual_average has 180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 5.
003_job_vacancies_by_employer_sector_of_the_establishment int Datasource did not contain a description for 003_Job_vacancies_by_employer_sector_of_the_establishment. Column 003_job_vacancies_by_employer_sector_of_the_establishment has 180 rows, out of which 12 are empty, making the null percent 6.67. Minimum value is 100 and maximum value is 60100.
orig_extractdate string The date when the data was originally fetched from the source.

Dim quarterly data and annual average, Statfinpas atp pxt 003 2018q3 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 5.
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 1st quarter and maximum string is Year.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas atp pxt 003 2018q3 px, Latest

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

Dim quarterly data and annual average, Statfinpas atp pxt 003 2018q3 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 5.
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 1st quarter and maximum string is Year.

Dim year, Statfinpas atp pxt 003 2018q3 px, Full history

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

Additional Info

Last Updated September 20, 2019
Created August 2, 2019