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

11 ca -- Population by labour force status, persons in disguised unemployment and underemployed persons by sex and age, quarterly data, 1997 Q 1-2019 Q 1

11 ca -- Population by labour force status, persons in disguised unemployment and underemployed persons by sex and age, quarterly data, 1997 Q 1-2019 Q 1

Tables

Column Descriptions

Dim sex, Statfin tyti pxt 11ca 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.

Fact, Statfin tyti pxt 11ca px, Full history

Column Type Comment
quarter string Datasource did not contain a description for Quarter. Column quarter has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1997Q1 and maximum string is 2019Q1.
sex int Datasource did not contain a description for Sex. Column sex has 1869 rows, out of which 623 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age_group string Datasource did not contain a description for Age_group. Column age_group has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 15-24 and maximum string is 55-64.
population_1000_persons int Datasource did not contain a description for Population_1000_persons. Column population_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 252 and maximum value is 4127.
active_population_1000_persons int Datasource did not contain a description for Active_population_1000_persons. Column active_population_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 103 and maximum value is 2802.
employed_1000_persons int Datasource did not contain a description for Employed_1000_persons. Column employed_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 86 and maximum value is 2577.
unemployed_1000_persons int Datasource did not contain a description for Unemployed_1000_persons. Column unemployed_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 369.
inactive_population_1000_persons int Datasource did not contain a description for Inactive_population_1000_persons. Column inactive_population_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21 and maximum value is 1470.
underemployed_persons_of_the_employed_1000_persons int Datasource did not contain a description for Underemployed_persons_of_the_employed_1000_persons. Column underemployed_persons_of_the_employed_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 146.
persons_in_disguised_unemployment_of_the_inactive_population_1000_persons int Datasource did not contain a description for Persons_in_disguised_unemployment_of_the_inactive_population_1000_persons. Column persons_in_disguised_unemployment_of_the_inactive_population_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 167.
population int Datasource did not contain a description for Population. Column population has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 100.
unemployed_share_of_the_population int Datasource did not contain a description for Unemployed_share_of_the_population. Column unemployed_share_of_the_population has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 20.
employed_share_of_the_population int Datasource did not contain a description for Employed_share_of_the_population. Column employed_share_of_the_population has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 26 and maximum value is 90.
inactive_population_share_of_the_population int Datasource did not contain a description for Inactive_population_share_of_the_population. Column inactive_population_share_of_the_population has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 64.
share_of_underemployed_persons_of_the_population int Datasource did not contain a description for Share_of_underemployed_persons_of_the_population. Column share_of_underemployed_persons_of_the_population has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 8.
share_of_persons_in_disguised_unemployment_of_the_population int Datasource did not contain a description for Share_of_persons_in_disguised_unemployment_of_the_population. Column share_of_persons_in_disguised_unemployment_of_the_population has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 9.
orig_extractdate string The date when the data was originally fetched from the source.

Dim sex, Statfin tyti pxt 11ca 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.

Dim age group, Statfin tyti pxt 11ca px, Full history

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

Dim quarter, Statfin tyti pxt 11ca px, Full history

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

Fact, Statfin tyti pxt 11ca px, Latest

Column Type Comment
quarter string Datasource did not contain a description for Quarter. Column quarter has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1997Q1 and maximum string is 2019Q1.
sex int Datasource did not contain a description for Sex. Column sex has 1869 rows, out of which 623 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age_group string Datasource did not contain a description for Age_group. Column age_group has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 15-24 and maximum string is 55-64.
population_1000_persons int Datasource did not contain a description for Population_1000_persons. Column population_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 252 and maximum value is 4127.
active_population_1000_persons int Datasource did not contain a description for Active_population_1000_persons. Column active_population_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 103 and maximum value is 2802.
employed_1000_persons int Datasource did not contain a description for Employed_1000_persons. Column employed_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 86 and maximum value is 2577.
unemployed_1000_persons int Datasource did not contain a description for Unemployed_1000_persons. Column unemployed_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 369.
inactive_population_1000_persons int Datasource did not contain a description for Inactive_population_1000_persons. Column inactive_population_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21 and maximum value is 1470.
underemployed_persons_of_the_employed_1000_persons int Datasource did not contain a description for Underemployed_persons_of_the_employed_1000_persons. Column underemployed_persons_of_the_employed_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 146.
persons_in_disguised_unemployment_of_the_inactive_population_1000_persons int Datasource did not contain a description for Persons_in_disguised_unemployment_of_the_inactive_population_1000_persons. Column persons_in_disguised_unemployment_of_the_inactive_population_1000_persons has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 167.
population int Datasource did not contain a description for Population. Column population has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 100.
unemployed_share_of_the_population int Datasource did not contain a description for Unemployed_share_of_the_population. Column unemployed_share_of_the_population has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 20.
employed_share_of_the_population int Datasource did not contain a description for Employed_share_of_the_population. Column employed_share_of_the_population has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 26 and maximum value is 90.
inactive_population_share_of_the_population int Datasource did not contain a description for Inactive_population_share_of_the_population. Column inactive_population_share_of_the_population has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 64.
share_of_underemployed_persons_of_the_population int Datasource did not contain a description for Share_of_underemployed_persons_of_the_population. Column share_of_underemployed_persons_of_the_population has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 8.
share_of_persons_in_disguised_unemployment_of_the_population int Datasource did not contain a description for Share_of_persons_in_disguised_unemployment_of_the_population. Column share_of_persons_in_disguised_unemployment_of_the_population has 1869 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 9.

Dim age group, Statfin tyti pxt 11ca px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 15-24 and maximum string is 55-64.
label string The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 15 - 24 and maximum string is 55 - 64.

Dim quarter, Statfin tyti pxt 11ca px, Latest

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

Additional Info

Last Updated July 21, 2019
Created July 18, 2019