Census learning centre
Census of Population web pages: Profile Part 2, Adding geographies and downloading options
Release date: July 10, 2024
Catalogue number: 982000032021033
Hello and welcome to the "Census of Population web pages: Profile Part 2, Adding geographies and downloading options" video.
This video is part of a video series on the Census of Population web pages. The purpose of this video is to explain how to add geographies in the 2021 Census Profile and to present the various downloading options to see the data.
- Subject
- Census of Population web pages
- Length
- 00:06:09
- Cost
- Free
- Links
Watch the video
Video: Census of Population web pages: Profile Part 2, Adding geographies and downloading options - Transcription
Welcome to the “Census profile – Part 2” video.
(The full title of this video is "Census of Population web pages: Profile Part 2, Adding geographies and downloading options".)
This video is part of a video series on the Census of Population web pages.
The purpose of this video is to explain how to add geographies in the 2021 Census Profile and to present the various downloading options to see the data.
Let’s quickly recap the various steps of the “Census profile – Part 1 video":
From the Census of Population main page, we went to the Census Profile main page.
We clicked on the “Canada” geography.
We removed “Men+”, "Women+”, “Rates”, "All topics."
We selected "all labour" and clicked on the “Apply” button.
(The welcome page transitions to the Census of Population main page. The "Census data" button, found on the navigation bar, underneath the previous quick link is highlighted and then clicked on. The "Data products" page opens. The "Census Profile" link is clicked on, and the “Census Profile” main page opens.)
(The "Canada" link, located in the "Browse" section is clicked on, and the census profile of Canada page opens.)
(The "Add or remove data" filter menu is highlighted and then clicked on. The list of all the census topics appear on the left side, with a "+" sign in front of each. On the right side, the title "Gender" appears with the categories "Total," "Men +" and "Women +" beneath it, with a checked box in front of each. Beneath it, the title "Statistic" appears, with the categories "Counts" and "Rates" beneath it, with a checked box in front of each. The "Apply" button appears beneath it.)
(Only the labour data now appear on the table.)
We will now continue working on our profile table by adding geographies by clicking on the “Add a geography” menu.
(The "Add a geography" filter menu is highlighted and then clicked on.)
From this menu, you can add up to five geographies to the profile table.
These geographies can be for any geographic level and may not be hierarchical.
(The hierarchy of standard geographic areas for dissemination, 2021 Census, appears.)
For example, they could be a mix of Federal electoral districts (FEDs), Census divisions (CDs), and Census metropolitan areas/Census agglomerations (CMAs/CAs).
(The “FED”, “CD”, and “CMA/CA” boxes are highlighted as they are said.)
(The hierarchy of standard geographic areas disappears and the “comprehensive download files” link is highlighted when it is said.)
To compare more than five geographies, you have access to the comprehensive download files, which will be discussed later in this video.
(The "comprehensive download files" link is highlighted.)
First, let’s add a province and a city. Please note that cities fall under the geographic level called census subdivisions.
For this example, we will type “Saskatchewan” in the search bar as our province of interest.
When you click on the magnifying glass button, you will have to choose your specific geography from the results, which are grouped by geographic level.
(When the magnifying glass button is clicked on, a “Search results” window appears. The search results for “Saskatchewan” are grouped by geographic level.)
In this case, we will select the province, Saskatchewan.
(“Saskatchewan” under the “Province / Territory” group is selected.)
Now that Saskatchewan has been added to the profile, we can quickly compare it with Canada.
(The labour force data appears with columns comparing labour data for Canada and Saskatchewan.)
Using the characteristic we had chosen in the previous video, which was Employment rate, we can easily see that Saskatchewan’s employment rate for the 2021 Census was higher than the national employment rate.
(The “Employment rate” row of the table is highlighted. The employment rate for Canada is 57.1 and the employment rate for Saskatchewan is 59.9.)
Next, for the city, we will do a search for “Moose Jaw” and we will select Census subdivision “Moose Jaw (City).”
As you can see, we can easily compare the national, provincial, and census subdivision 2021 Census employment rates all in one table.
(The “Employment rate” row of the table is highlighted. The employment rate for Moose Jaw, 55.7, has been added to the table.)
As a side note, some geographies undergo name or boundary changes between censuses. For example, if you are looking for the “Aylmer” CSD in Quebec, you will see that there is no result for “Aylmer, Quebec” under the “Census subdivision” heading.
(The "Add a geography" filter menu is clicked on. “Aylmer” is typed into the search bar and the “magnifying glass” icon is clicked on. The “Search results” window appears.)
In these situations, places are listed under their new name or under the name of a parent geography, and you may not find the geography you are looking for.
If this happens, browse the “Other place names” category to find geographies no longer available.
(The “Other place names” group is highlighted and expanded. A table with place name and their corresponding census subdivision (CSD) appears under the “Other place names” group.)
You will then see the “Aylmer” CSD in Quebec does not exist anymore and became part of the Gatineau (Ville), Quebec.
(The “Search results” window is closed and the “Profile table” reappears.)
Lastly, we will now explain the options for downloading a census profile table.
On the right side, above the “Add a geography” filter, there is a “Download” button.
(The “Download” button is highlighted and clicked on.)
On the "Download files” page, we have three options.
(The “Download files” page opens, and the three options are highlighted. The download options are “Download data as displayed in data table”, Comprehensive download files”, and “Comprehensive download files (with confidence intervals)”.)
The first option is to “Download data as displayed in data table.” As its name suggests, you can download the data table with the filters that was just created. There are two download formats available, CSV and TAB:
(The “Download data as displayed in data table” menu is highlighted and clicked on.)
CSV is an acronym for Comma-Separated Values. It can be imported into many popular spreadsheets applications, like "Excel.” Footnotes and data quality information can be found at the bottom of the table.
TAB is short for Tab-Separated Values. These files can also be imported into any spreadsheet or database application. Notes and data quality information can also be found at the bottom of the file.
(The “CSV” button, located on the right side of the screen, is highlighted, and clicked on. A “Downloads” pop-up appears at the top right of the screen. “Open file” is clicked on, and a “CSV” file is opened. When “footnotes” is said, the footnotes at the bottom of the screen under the data are highlighted. When “data quality information” is said, the data quality information found at the bottom of the spreadsheet (directly below the footnotes) is highlighted. The “CSV” spreadsheet is closed.)
(The “TAB” button is highlighted and clicked on. A “Downloads” pop-up appears at the top right of the screen. “Open file” is clicked on, and the “Notepad” program opens to display the file. The file is scrolled through to the bottom and the footnotes as well as the data quality information are highlighted. The “Notepad” program is closed.)
The second option, “Comprehensive download files,” offers tables that contain all the data for all geographies at the chosen geographic level, without filters. Therefore, these files can be quite large and may take a few extra minutes to download. There are three download formats available:
CSV
TAB
and IVT, which requires the Beyond 20/20 Browser to view these files.
(The “Comprehensive download files” drop down menu is highlighted and clicked on. When the menu is expanded, a table appears with geographic levels and corresponding file formats. “CSV”, “TAB”, and “IVT” file formats are available for each geographic level. The column for each file type is highlighted as it is mentioned. The drop-down menu is clicked on again to close the list.)
The third and final option is the “Comprehensive download files (with confidence intervals).” Contrary to the “Comprehensive download files,” these files do not contain all 2600+ characteristics. They only contain long form data characteristics since confidence intervals are not applicable to short form data. We only recommend this option for data analysts and researchers. For more information, please refer to Guide to the Census of Population, 2021: Chapter 9 – Data quality evaluation .
(The “Comprehensive download files (with confidence intervals)” menu is highlighted and clicked on. When the menu is expanded, a table appears with geographic levels and corresponding file formats. “CSV”, “TAB”, and “IVT” file formats are available for each geographic level. Above the table, there is a link to “Guide to the Census of Population, 2021: Chapter 9 – Data quality evaluation”. The link is clicked on and the “Guide to the Census of Population, 2021: Chapter 9 – Data quality evaluation” web page is opened. When the “clicking noise” is heard, the screen returns to the “Download files” page.)
One last item to mention on this page is the link to the 2021 Census Profile Web Data Service User Guide, which provides access to the 2021 Census Profile data and metadata in a variety of formats.
(The “Comprehensive download files (with confidence intervals)” menu is clicked on to close the menu. Below the “Download options” is the “Web data service” information. The link “2021 Census Profile Web Data Service (WDS) – User Guide” is clicked on. The “2021 Census Profile Web Data Service User Guide” webpage is opened.)
This concludes the “Census profile – Part 2” video.
(The full title of this video is "Census of Population web pages: Profile Part 2, Adding geographies and downloading options".)
Thank you for watching.
To view the next Census website video, go to the Census learning centre.
(The census logo appears with a link, which is also available to view here: Census learning centre. The International Standard Book Number (ISBN) 978-0-660-71565-0 appears underneath the link.)
(The "Canada" wordmark appears.)
- Date modified: