2021 Federal Census Employment by Community

The Employment data from the 2021 Federal Census covers labour force status, employment status, labour force participation rate, industry, and occupation. For questions, please contact socialresearch@calgary.ca. Please visit <a href="https://www.calgary.ca/research/population-profile.html">Data about Calgary's population</a> for more information.

Labour force status refers to whether a person was employed, unemployed or not in the labour force during the reference period. Not in the labour force refers to persons who were neither employed nor unemployed during the reference period. This includes persons who, during the reference period were either unable to work or unavailable for work. It also includes persons who were without work and who had neither actively looked for work in the past four weeks nor had a job to start within four weeks of the reference period.

Employment status refers to the employment status of a person during the period of Sunday, May 2 to Saturday, May 8, 2021. An employed person is one who did any work at all at a job or business, that is, paid work in the context of an employer-employee relationship, or self-employment. This category excludes persons not at work because they were on layoff or between casual jobs, and those who did not then have a job (even if they had a job to start at a future date). While an unemployed person is one who was without paid work or without self-employment work and was available for work. An unemployed person either: had actively looked for paid work in the past four weeks; was on temporary lay-off and expected to return to his or her job; or had definite arrangements to start a new job in four weeks or less.

Labour force participation rate refers to the total labour force in that group, expressed as a percentage of the total population in that group.

Industry refers to the general nature of the business carried out in the establishment where the person worked. The industry data are produced according to the North American Industry Classification System (NAICS).

Occupation refers to the kind of work performed in a job, a job being all the tasks carried out by a particular worker to complete their duties. An occupation is a set of jobs that are sufficiently similar in work performed. The occupation data are produced according to the National Occupational Classification (NOC) 2021.

This is a one-time load of Statistics Canada federal census data from 2021 applied to the Communities, Wards, and City geographical boundaries current as of 2022 (so they will likely not match the current year's boundaries). Update frequency is every 5 years. Data Steward: Business Unit Community Strategies (Demographics and Evaluation). This dataset is for general public and internal City business groups.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"calgary-ca/2021-federal-census-employment-by-community-isek-k4ja\".\"2021_federal_census_employment_by_community\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.