March 16, 2021

Question
I have a researcher trying to find total new births, birth rate, total new deaths and death rate by year at the CSD level.  I've found some data at the Health Unit level, but thought I would ask if anyone has come across anything at CSD level or smaller geography before.

Answer

Some datasets that may be of interest - the data frequency for the first two is monthly and the rest are annual:

 

Birth registrations in Ontario (by location)

https://open.canada.ca/data/en/dataset/6a2ee0c2-b3f1-4af2-9c86-735377a961af

(municipalities / CSDs)

 

Death registrations in Ontario (by location)

https://open.canada.ca/data/en/dataset/f2d9985b-7195-4a12-8f6c-4efc9adca8d1

(municipalities / CSDs)

 

Population estimates, July 1, by census subdivision, 2016 boundaries

https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710014201

 

Population estimates on July 1st, by age and sex

https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710000501

(Provinces)

 

Fertility: Overview, 2012 to 2016

https://www150.statcan.gc.ca/n1/pub/91-209-x/2018001/article/54956-eng.htm

Labour Force and Commuting for Work Question

Question:

I’m helping a researcher sort out some travel to work data for the CSD of Houston, BC. From this table: https://www150.statcan.gc.ca/n1/en/catalogue/98-400-X2016325 looking at Houston (DM) we get a labour force of 1065 living in Houston, but the census profile of Houston (DM) gives a labour force size of 1615, and it seems to both of us the difference between the two seems much too large to be due to suppression and random rounding. I’m wondering if there is documentation I’m just missing that would account for this difference?

Answer:

On the first table, your client has given the “universe” or population captured, is people who are employed in the labour force aged 15 years and over who have a usual place of residence. Whereas, in the second table your client is looking at a universe that we would title persons in the labour force aged 15 years and over. We can find this information from looking at either the table title or the profile section title.

Here is a little explanation on why this population is so different from the total labour force that you see on the second table.

Seeing as this table is a commuting flow chart, respondents must have a usual place of work which limits the number of respondents that you see. This helps with the accuracy of the table as those with a flexible work environment are not always commuting to the same place. This table is also only showing those who are employed in the labour force. From reading this definition of both labour force and labour force status we see that those counted in the labour force may have been unemployed during the reference period which would also mean that they would not have an eligible destination to use in the commuting flow chart.

After seeing these differences I would recommend that your client look at journey to work sections of the profile for comparability instead of the labour force sections. You can find this by selecting “Journey to work” using the “Topic” toggle bar at the top of the profile.

One last consideration with this flow chart is that suppression rules do apply to protect the privacy of Canadians. Random rounding has of course been used on all of these tables however as well, there may be some respondents living in Houston ,BC who have a very unique commuting destination. The six possible commuting destinations listed on the first table may therefore not be exhaustive, which would account for the sum of these 6 answers not adding up to exactly the same total as the journey to work universe.

Correspondence of "Other place names" to CSD

Question
I'm looking for a correspondence file of "Other places names" (as they appear in Census Profiles on the StatCan website) to CSDs. I notice that this information is embedded in the Census Profile results page but I'd lofve to see the underlying data.

For example, I get two results when I look up Acadia Valley, AB in the 2016 Census Profile: one under "Designated places" and the other under "Other place names." The latter result also shows the corresponding CSD. What I'm looking for is the data for that correspondence. Unless I'm mistaken, that's not available in any of the Census geography products.

Answer
Subject matter provided this resource: http://www12.statcan.gc.ca/census-recensement/2016/ref/dict/geo033-eng.cfm

Down Syndrome Statistics

Question

I’m trying to find information about the prevalence of Downs Syndrome, average age of mother, pre-natal screening and number terminated in Canada. She’s been able to find American stats and needs Canadian figure for comparison.

Answer

I did find the following resource that may be of assistance:
Health at a Glance - Deaths from congenital anomalies in Canada, 1974 to 2012

We have received the following response from subject matter concerning your question.

“We do not have anything except from Vital (Deaths) below:
http://www.statcan.gc.ca/pub/82-624-x/2016001/article/14649-eng.htm

PHAC and CIHI have a bit of information so that might be the best place to recommend to the client.
https://www.canada.ca/en/public-health/services/publications/healthy-living/down-syndrome-surveillance-2005-2013.html

www.cihi.ca

CSD may be able to give estimates of people with Downs Syndrome (which is dependent on whether subject matter is able to provide that estimate) but it would not be able to produce the other components.”

Answer 2
CIHI - https://www.cihi.ca/sites/default/files/induced_abortion_can_2013_en_web_0.xlsx has number of abortions by age group, but not by reason for the abortion.

Looking at the ICD-10-CA (https://secure.cihi.ca/free_products/canadian_coding_standards_2012_e.pdf), there is coding for this … see page 214. However, there is some interesting phrasing in two of the examples – ”A medical abortion was performed and the reason for the medical abortion was documented” – I wonder if that implies that this is not always the case?

The stillborn’s Discharge Database Abstract would record:
Code DAD NACRS Code Title
P96.4 (M) MP Termination of Pregnancy
Q90.9 (3) OP Down’s syndrome, unspecified

1971 Census CSD placenames

Question
In the data file of the 1971 CSDs, we have geographic information like this, for St Catharines:
PROVINCE 35
ED 0
EA 0
COUNTY 28
MUNIC 5

We knew 35=Ontario and 28=Niagara (in 1971), but identifying 5 as St Catharines required matching population numbers in this file with the CSD volumes that only have place names, no codes. We can manage that for 12 municipalities in Niagara, but it’s a bit cumbersome for Ontario or Canada…

What I haven’t been able to find is a comprehensive list of CSD place names with their corresponding codes. Appendix 1 in this document has a partial list that shows the sort of reference I’m looking for:
http://data.library.utoronto.ca/datapub/codebooks/c/cc71/geog/gtf71cbk.pdf

We don’t have anything like this in our print holdings, and my attempts to figure out which census volume it might be based on the volume summaries has failed. Can anyone point me in the right direction?

Answer
You can find the documents on the DLI FTP at /MAD_DLI_IDD_DAM/Root/census_pop_recens/1971/Doc

There is a series of digitized booklets with names like cen71-official-list-03-ontario.pdf (one each for Atlantic, Quebec, Ontario and West). The notes at the beginning will tell you how to derive the CSD from the BST variables.

CSDs by MIZ classification codes

Question
Is anyone able to point me to how to find the MIZ classification code for all CSDs (those outside CMAs and CAs) in Canada (2011)? 

Before I re-install Geosuite, is this product able to attach the MIZ category codes? Or, does this require a custom tabulation request?

Answer
I just checked GeoSuite 2001, which I downloaded to answer a question, and it includes a SACType field (http://www12.statcan.gc.ca/english/census01/Products/Reference/dict/geo045.htm). 

 So, I'm assuming that the more recent GeoSuites also include this data.

Some Statcan Resources

Question

I'm working with Census data from 1986-2006, and with the NHS 2011. I am trying to calculate mortality rates using the death counts by CSD in the Vital Statistics, and with the population counts by CSD in the short form 100% population census. In order to compute these rates, I need to match the CSDs that appear in the Vital Stats and in the Censuses, and I've been having a lot of trouble with this, as it appears there are more CSDs in the Vital Stats than in the Census. The only reasons I can think of as to why this might be occurring are: 1. that the codes have changed over the years, and 2. that some CSDs have been suppressed in the Census (whether they were incompletely enumerated reserves, or of poor data quality). I am using the concordance tables on Stat Can's website to track the changes in codes over the years, but this only accounts for a few hundred of the few thousand unmatched CSDs over the period of time I'm interested in. From this I have two questions:

What I really need for each census year (for short form & long form questions) is a list of the suppressed CSDs, showing the reason for the suppression, similar to what is available for 2011 NHS (https://www12.statcan.gc.ca/nhs-enm/2011/ref/sup_CSD-SDR-eng.cfm).


Answer

Unfortunately, we did not publish online any suppression lists prior to 2006. For 2006, we only published the names (no reasons for the suppression). In 2011, for both the Census and the NHS both the names and the reasons were published. Here are the links to these lists.

NHS Census subdivisions (CSD) not released

2011 Census subdivision (CSD) suppression list

2006 Census subdivision suppression list with names - 100% data

2006 Census subdivision suppression list with names - 20% sample data

Population Projections by CSD

Question

Are population projections available at the level of CSD similar to the one at the level of province (CANSIM 0520005)? I am looking specifically for the CSD of Weyburn, SK.

Answer

Unfortunately, CSD level population projections are not available from Statistics Canada at this time. The division that produces population projections hopes to strengthen its capacity to do these projections, but these won't be possible in the near future.

Additional Information

I don't know about Saskatchewan but in British Columbia it's the provincial government that publishes population projections for municipalities and regions.

Full Time/Part Time Work by CSD

Question

I have a PhD student looking for number of hours worked for 2 CSDs for 1986 and 1991 censuses. Based on the example for later censuses here: http://www.communityaccounts.ca/communityaccounts/onlinedata/display_table.asp?_=0bfAjIydpaWrnbSTh5-FvKRsxKFjXHe6uJS8u5mBi8nAXWiP#footanch0, I'm guessing it will be one of two variables: Last week, how many hours did you work? and/or During most of the reference period, did you work full time or part time? I can't see any standard product (print or online) that provides this by CSD. Is there any alternative to a custom tab for this information?

Answer

The 1991 and 1986 2B Profiles for CSDs available through E-STAT may be of interest to the student. To access these:

1) Go to E-STAT

2) Click on Search Censuses in E-STAT

3) Select a Census, click Go

4) Select 1991 (2B) detailed questionnaire, Provinces to municipalities or 1986 (2B) detailed questionnaire, Provinces to Municipalities

5) Select the desired geographic areas and characteristics (options include: Males - Worked full year, full time (33), Males - Worked part year or part time (34), Females - Worked full year, full time (33), Females - Worked part year or part time (34))

The following Basic Summary Tables (BSTs) from the 1991 and 1986 Census may be of interest as well. They are available on the DLI FTP site. Please note that the student would need to work with the files using a statistical analysis application like SPSS.

For 1991:

N9102 Population 15 years and over by age groups (17) and sex (3), work activity in 1990 (15) (20%)

N9105 Employed labour force 15 years and over by age groups (17a) and sex (3), hours worked in reference week (10) (20%)

The University of Toronto describes these files on their site at: http://datalib.chass.utoronto.ca/cc91/cc91bsts.htm

For 1986:

LF86B07 - labour force 15 years and over by work activity in 1985 (14) (number of weeks worked in 1985 and whether these weeks were mostly full or part time) and sex (3)

This and other 1986 BSTs are described on the University of Toronto website at: http://datalib.chass.utoronto.ca/cc86/cc86bst.htm

Please don't hesitate to let me know if you have any other questions or if these don't meet the student's needs.