Thursday, October 31, 2013

2001 Census DA Profile, Education Variables


I'm helping a researcher who is working with the 2001 census profile at the DA level, particularly with education variables re highest level of attainment (p491_29 to p491_42). This is my first time working with these variables. Nearly half the observations are marked invalid (valid:29277; invalid:25025). The researcher wants to know why there are so many invalid observations, if it has to do with suppression, and if the data might be available in an RDC.


I took a look in PCensus and found the following category of ‘education’ statistics for 2001.

I extracted the DA-level statistics for this, and the other education-related categories, limiting results to Kingston, and did not encounter suppression.

The other education categories are:


Market Research Handbook


Is there another publication produced at Statcan (or elsewhere) that addresses the same information as the Market Research Handbook (Catalogue no. 63-224-X) (terminated after 2008)? I know that most of the data is available to be derived, but our marketing students found this to be a well-rounded one-stop-shop for Canadian market data, so I’m wondering if any similar product has been produced.


It does not seem that there is anything published similar to that. I noted in the handbook, that many of the data tables in the Market Research Handbook are derived from CANSIM.

Wednesday, October 30, 2013

Internet Use by Immigrant Status


I'm looking for data on internet use (by province, ideally) by immigrant status? Preferably on people who've not become Canadian citizens, but I'll make do with whatever is available. It would appear that the 2007 CIUS master file might be useful, but I'm wondering if the more recent versions might have also produced some good results. Do you have any suggestions besides the RDC?


I checked the userguide of GSS22, variables on the internet (and other characteristics place of birth and visible minority status) and thought these could be of potential interest:
Socio-demographic factors influencing use of the Internet - Internet use among new Canadians <> (data from the 2003 General Social Survey on social engagement). For more recent data, consider 2008 - Cycle 22 Social Networks <>
Selected activities of home Internet users1, by immigration status, Canada, 2007
Data source: Statistics Canada, Canadian Internet Use Survey, 2007.

Tuesday, October 29, 2013

National Input-Output Data


Are the National Input-Output Data Tables available through DLI? If so, where?


For National Input-Output data at the National level is available here: <>.

National Symmetric Input-Output Tables - Aggregation Level L

The Industry Accounts Division of Statistics Canada publishes annual symmetric industry-by-industry I-O tables at the L level. The symmetric industry by industry table shows the inter-industry transactions, that is, all purchases of an industry from all other industries including expenditures on imports and inventory withdrawals as well as all expenditures on primary inputs. Similarly, the symmetric final demand table shows all purchases by a final demand category from all other industries, including expenditures on imports and inventory withdrawals as well as all expenditures on indirect taxes.

Or on the EFT site:


Health Care Expenditures


Has there ever been a longitudinal analysis on health care expenditures prior to patient death in Canada. I have found the metric used in a Swiss research paper cited in PubMed, but is there any comparable data in Canada?


Have you considered looking at CIHI data?
National Health Expenditure Trends, 1975 to 2013

Find out how much is spent on health care every year, what and whom that money is used for, and where it comes from. Our analyses of Canadian health care spending include: overall spending at national, provincial and territorial levels; details of health facility and regional health authority spending; cost estimates of services provided to patients in hospitals.

Variables to Measure Socio-Economic Status


I'm researching which variables are used to measure socio-economic status (SES). I don't need the data, just which questions are being asked and what variables are being used in dealing with SES. Do you have any suggestions of where I could find this information?


Hi, Monica Boyd is an expert in this field. You might want to have a look at "A Socioeconomic Scale for Canada: Measuring Occupational Status from the Census, Canadian Review of Sociology, Feb 1, 2008.

Union Memberships Among Visible Minorites


A researcher is looking for union memberships for Aboriginal and visible minority populations. Union memberships shows up in the Labour Force Historical Review and the Labour Force Survey PUMF, but neither seems to include anything about Aboriginal or visible minorities. The LFS questionnaire does ask about Aboriginal status, so I would guess that the researcher might access this tabulation via a Research Data Centre. But, is there any way to get information on memberships by visible minority status?


The Labour Force Survey (LFS) does have custom tabulations with union coverage for aboriginals living off reserves, but it does not collect data on visible minorities.

Friday, October 25, 2013

PIAAC Release Date


We have a user looking for data from the Programme for the International Assessment of Adult Competencies (PIAAC). It's release date is listed as October 8, 2013: Is there/will there be a public use microdata file available?


The information is available in a publication, which was released on Oct 8th –Programme for the International Assessment of Adult Competencies Series

On the OECD website the first results of and key findings of PIAAC have been made available ; the report can be downloaded there. A PUMF has also been created and we are taking requests from the website.

That said, we were just informed that the PIAAC PUMF has been temporally suspended due to a couple of small problems. We hope to have it fixed in the very near future.

Thursday, October 24, 2013

Class of 86 Revisited tables


I have a StatsCan publication, The Class of 86 Revisited: A Compendium of findings of the 1991 Follow-up of the 1986 Graduate Survey with comparisons to the 1988 National Graduate Survey, that has a list of Supplementary Tables (Appendix C) in the back (Groups A – H). We have a disk with tables from Group A and the publication has the tables from Group B. Do you know if we can get our hands on any of the other tables (Groups C – H)?

I believe that a PUMF was not produced for the 1991 Follow-up Survey but would the tables have been made public? There is a note in Appendix C that says the tables can be ordered from Human Resources Development Canada.


We have one file that could work, otherwise HRSDC would need to be contacted.

NHS Data


I have a researcher who would like to download NHS data for a complete geographic level ( for the DA level. Would this be available as a custom tab?


That is correct, DA level data is not being disseminated as a standard product, and is available as a custom tab, which is cost recoverable.

CIP Codes


We have a researcher who wants a CIP code (Classification of Instructional Programs) that is more granular than the Primary Codes given in CANSIM Table 477-0019.

Specifically, 45.1099 ( for specific Ontario universities – i.e. York, Ryerson and UofT - cross-tabulated by enrollment and also graduation.

Do you know if this is possible to obtain through Statistics Canada or should the researcher contact the universities, directly?


I did a quick run for you based on the 6 digit CIP (45.1099), and there are too many suppression issues making the data pretty useless. We would not sell your client the table for this reason. In fact we really try to discourage using data at the 6 digit CIP for PSIS, and if the client is insistent we advise caution. I did a run at the 4 digit CIP (45.10) and it yields far more consistent results.

If your client is OK with the data at the 4 digit (45.10), we could produce tables for graduate and enrollment, for Ontario, and by institution, for most current year for a cost of $145.36. The turnaround would be about 5 days.

Wednesday, October 23, 2013

Child Care Québec

A researcher is looking at family time use for child care of children ages 0-4 before and after day care policy changes in Québec.

Before the day care policy changes is not a problem. e.g., for 1986 and 1992, we know families with children ages 0-4, and the number of the children in this age range. And only for 1986, we know the activity codes between 22 and 25 cover kids ages 0-4 only. However, for 2005 and 2010 is it possible to find out:

1. The number of children in the samples ages 0-4?

2. For codes higher than 200, do these include ages 0-4? If they do, do they also include ages 5-15?

3. If these codes cover children ages 0 up to 15, is there a variable (e.g., 1992: RESC0004: Number of respondents single children aged 0-4) or combination of variables we could use to identify families with children ages 0-4?


After some discussion with the subject matter specialist, it seems what they are trying to do would be impossible.

The only codes that are meant for 0-4 are 200. Anything above 200 is a mixture of any child within the household. There are variables to verify if there is a child of 0-4 within the household, however, there is no way of knowing if the time used was for the child 0-4 years of age (unless it’s an only child).

Tuesday, October 22, 2013

Provincial PCCF Files


Are we still able to get PCCF files for specific provinces?


File specifications
The current version of the Postal CodeOM Conversion File (PCCF) includes five files: the PCCF, three name files (CD_DR.txt, FED03_CEF03.txt, SAC_CSS.txt), and a special file, Retired 2010 (R2010.txt). Postal codesOM retired before January 1, 2011 are included in the Retired 2010 file. This reduces the size of the PCCF. These are ASCII files and do not include any software nor instructions on how to use the product within specific Geographical Information Systems (GIS) or mapping packages.

File naming convention
The naming convention for Postal CodeOM Conversion Files (PCCF) is bilingual and reflects the reference date (June 2013) of the Canada Post Corporation (CPC) data used in the release. The file name for this release is

Monday, October 21, 2013

Suppression from 2006 Census


I looked at the 2006 community profile , since the 2011 census doesn’t have data for the Indian reserve of Pikangikum 14). Total population for 2006 is given as 2100. However, no characteristics other than total population and dwelling counts are given. Why is the rest of the data for 2006 suppressed?


Geographic areas with a non-response rate higher than or equal to 25% are suppressed from tabulations. In the case of Pikangikum 14, Indian reserve:

--Data quality index showing, for the short census questionnaire (100% data), a global non response rate higher than or equal to 25% (suppressed).

--Data quality index showing, for the long census questionnaire (20% sample data), a global non-response rate higher than or equal to 25% (suppressed).

Therefore, two of the 8 criteria for suppression were met for Pikangikum 14

Friday, October 18, 2013

GSS Cycle 26


Is GSS Cycle 26 currently available in the RDCs? If not, when might it be?


GSS C26 has now been staged in the RDCs, which means it should be available now.

Tuesday, October 15, 2013

Wait Times for Medical Specialists

A researcher would like to compare two separate years of CCHS microdata on wait times to see a medical specialist by province. The years the researcher is looking for are 2007 and 2009 (uncoupled from the 2008 data as per: the 2007-2008 and 2008-2009 PUMFs).

The Health Services and Access subsamples in 2007 and 2009 covered all provinces for modules ACC: Access to health care services, and WTM: Wait times. In the grouped files 2007-2008 and 2008-2009, these modules are optional, providing poor provincial coverage. The researcher would like to work with these Canada-wide subsamples. Can she do so and if so, what would her options be?

Yes, it is possible to assess the subsample files through a RDC proposal.

Friday, October 11, 2013

Canadian Health Measures Survey Cycle 2 Documentation

A researcher here is looking for the data dictionaries for the CHMS cycle 2. CHMS isn’t on the Nesstar Master File list thus far, but is there another way to access this information?


Cycle 2 of the CHMS actually has multiple dictionaries, and not just one. Right now, we cannot make them available outside the RDC. I’m going to ask subject-matter to remove the reference to them from the list of available documentation until the issue of whether or not we can distribute them is resolved.

Immigrant Entrepreneurship


I have a student who’s looking for information about immigrant entrepreneurship and immigrant-owned businesses. I’ve contacted the agency that processes business registries in SK to see if they keep such stats, but I’d like to find out if there’s a national source as well.

There are a few different Sources to look at:

-Feng Hou and Shunji Wang's article "Immigrants in self-employment" may be of use. This study uses the 20% sample files of the 1981, 1986, 1991, 1996, 2001 and 2006 censuses, and the combined May and November files of the 2006 to 2010 Labour Force Survey (LFS) to calculate the share of the self-employed among all employed workers. The selected sample consists of individuals who were employed in the week prior to the census or in the LFS reference week. Institutional residents and persons living in the Northwest Territories, Yukon and Nunavut were excluded. Immigrants who arrived in the census or survey year and individuals whose immigration status were not identified in the LFS were also excluded....

- "The Immigrant Labour Force Analysis Series" - This series of analytical reports provides an overview of the Canadian labour market experiences of immigrants to Canada, based on data from the Labour Force Survey. These reports examine the labour force characteristics of immigrants, by reporting on employment and unemployment at the Canada level, for the provinces and large metropolitan areas. They also provide more detailed analysis by region of birth, as well as in-depth analysis of other specific aspects of the immigrant labour market.

SME Business Owner Characteristics from Industry Canada


Thursday, October 10, 2013

Aboriginal Data and the NHS

A brief 4-page article appeared recently about aboriginal data and the NHS.

It is accessible at: <>

There are many parts of the text that are unclear to us, and we’ve outlined a few of them below. If you have time to read the article, we’d be interested in your comments.

The article sets out to address the impact of the NHS on the quality of data relating to aboriginal people. It compares the response rate of the NHS to the 2006 census, taking into consideration the reserves and Inuit communities.
On page 3, there is a bar graph, that seems to contradict what appears in the text. For instance, the response rate for Inuit communities is given as 92% in the text but as 76% in the graph.How did the author arrive at 76%?

Figure 1 does not represent response rate for communities but rather community level data published by STC.

A similar contradiction between text and graph seems to appear for the reserves. How did he arrive at 72%?

And what does the 3rd bar below represent? In what way does it meaningfully compare with the two preceding bars?

Wednesday, October 9, 2013

National Household Survey


Are there any published response rates by age groups for the 2011 National Household Survey?


The published response rates for NHS – are available here:

National Household Survey: Final response rates

National Household Survey: Final response rates, census subdivisions (CSDs)

Global non-response rate of the 2011 National Household Survey, Canada, provinces and territories

National Graduates Survey


Will there will be a new National Graduates Survey, one that will cover our “post- recession” era? The status of the IMDB record indicates that this is an active survey.


The last NGS was in 2007 (class of 2005), we had a PUMF, no FOG (follow up graduate class). The next NGS will be in 2013 (class of 2009/2010), no PUMF, no FOG. We are aiming for the end of March 2014. The NGS is a survey that looks to see what graduates are doing 2 years after graduation (i.e. class of 2000, surveyed in 2002). The Follow-up of graduates survey (FOG) is a survey that looks to see what NGS respondents are doing 5 years after graduation (i.e. class of 2000, surveyed in 2005)

We will have NGS 2013 (class of 2009/2010) but there will not be a FOG and the master will be in the RDC.

Sex Workers in Census


Yesterday, while I was presenting a class, one of the Masters students asked about the availability of data about sex workers. In a sign that I’ve been doing this far too long, I wondered out loud what the National Occupational Classification System coding would be. The class of suggested some possible (typically euphemistic) job categories. Today, I searched the HRSDC site to try to find a definitive answer, since the student asked in all seriousness, and would like data for her project.

I’m not sure if I was surprised to find that there were no results for either “Prostitute” or “Sex worker” (but was DEFINITELY amused to see the list of suggested words for prostitute:

The closest I could locate (and, sadly, VERY close to what I suggested) was “6564 Other personal service occupations” , which includes (under view all titles) Escort. (*)

Since there doesn’t appear to be a “Not elsewhere classified” category in the NOC (or at least none on the HRSDC site), where are sex workers or prostitutes classified by Statistics Canada when using the detailed National Occupational Classification coding?


You are correct - 6564 is correct



Why is there no 1995 SLID PUMF? Does it have to do survey changes (as I understand this to have happened) in 1998? Is there any data for 1995 (e.g., in an RDC), or does my researcher have only the 93-94 file and then the 1996 file to work with?


SLID was a pilot test to SCF for the period of 1993 to 1997, SLID became official in 1998; public files were available from SCF until 1997. The SLID panel had only one panel from 1993 to 1995; the SLID panels doubled in 1996, so 1996 was a good starting point for producing a public SLID file.

Tuesday, October 8, 2013

CCHS - Mental Health


Will there will be a PUMF available for the CCHS Mental Health (2012)?


Data from the CCHS – Mental health are available in CANSIM tables : CANSIM table105-1101. If you're interested in the PUMF, Canadian Community Health Survey: Mental Health, it will anticipated to be released “Spring 2014”.

Monday, October 7, 2013

Woodstock Ontario Population


The data for NHS and Census 2011 for Woodstock, Ontario shows that the Census Agglomeration has about 400 more people than does the Population Centre, and they are mapped differently. Since the CA was larger (in terms of geography), it’s easy to accept that the population is higher. But, since I didn’t know what the Population Centre was, I went to the Illustrated Glossary ( and found that “Population centre population includes all population living in the cores, secondary cores and fringes of census metropolitan areas (CMAs) and census agglomerations (CAs), as well as the population living in population centres outside CMAs and CAs.”

Why are there more people in the Woodstock Ontario census agglomeration than in the Woodstock Ontario population centre, and why aren’t the boundaries the same?


The census explains that – we are looking for a more detailed comparison between the two, but population centres are based on contiguous (connected) blocks, whereas CMAs and CAs are based on Census Subdivisions (CSDs) which are much larger and can include both urban and rural areas.

So Woodstock, Ontario Census Agglomeration has a higher count as it can include one or more rural areas in it, while Population Centre is “urban” only.

Thursday, October 3, 2013

Saskatchewan Population Projection Data


I have a request from a grad student for population projection data for Saskatchewan at the CMA/CA level. Is this info available without resorting to a custom tabulation?


We have the Population Projections for Canada, Provinces and Territories : <>. For sub-provincial level, you are looking at Annual Demographic Estimates: Subprovincial Areas <>.

Customized assumptions and scenarios are always available on request. Those interested should contact the client services unit of Statistics Canada's Demography Division.

NHS Suppressed Data


I have a researcher looking for data on “The Narrows 49, IRI” (Manitoba 19 065). [Incidentally for librarians, you have to search for “The Narrows”, as a search for “Narrows” will not find it.] The user would like to know if “not available” is the final answer, or if Statistics Canada might consider custom data for specific topics or variables? Would this depend on whether it is a confidentiality issue, or a data quality issue? Is there someone that users should contact directly to inquire about such possibilities?


if an area is not released in the standard product line, it is still be possible to request it via custom tabulation, of course that is cost recoverable. The custom tab would include, as I understood, areas that were suppressed, with detailed notes.

Custom tabulations from the 100% database are available for census years 1971 to 2011 and from the 20% database for census years 1971 to 2006. They are produced to meet the needs of individual users, according to their exact requirements in terms of content, geography, format and output medium. This includes the derivation of new variables and the creation of custom geographies.

Wednesday, October 2, 2013

2011 Survey of Household Spending


The 2011 Survey of Household Spending tables that were recently released have household characteristic information but no expenditure information. Will we be getting tables with the expenditure information?


The standard tables are no longer produced starting with SHS-R 2011, only CANSIM numbers will be offered.

Imputation Rates vs. Global Non-Response Rates


What is the relationship between global non-response rates and imputation rates for specific sets of variables?

To quote the 2011 NHS Ethnic Origin Reference Guide:
"The imputation rates for the NHS Ethnic origin variable are similar to those of the 2006 Census (see Table 1). The NHS imputation rate for Ethnic origin at the national level is 5.8% which compares with the 2006 Census imputation rate for ethnic origin of 5.9%."

Does this suggest that the NHS data and 2006 Census data are of comparable quality at the national level for ethnic origin? If the global non-response rate (again, at the national level) is higher that the imputation rate for a given set of variables (and it was for all the groups of variables in the Reference Guides), what exactly does that mean?


Yes, the NHS data and 2006 Census data are of comparable quality at the national level for ethnic origin - as the client quoted directly from the Ethnic Origin Reference Guide below.

The GNR global non-response rate is an important measure of the quality of NHS estimates. It combines household and item non-response. This measure is used for the 2011 Census, just as it was in 2006 for dissemination of the Census, including the long form. In the specific case of the NHS, the global non-response rate is weighted to take account of the initial sample and the subsample used in non-response follow-up. It is calculated and presented for each geographic area.

The National Household Survey User Guide provides more detail - Chapter 6 would be of particular interest.

Imputation replaces missing, invalid or inconsistent responses with plausible values after non-response follow-up has occurred. The National Household Survey User Guide provides more information on data processing:

Irish Immigration Statistics


I am working with a PhD student who is looking for long time series for Irish immigration to Canada, going back as far as possible (even back to the 19th Century) and I have a few questions.

The 1966 to 1996 period is well covered by the Citizenship and Immigration statistics archives ( When looking for older statistics, I went to Historical Statistics of Canada which referred me to the Immigration statisticsannual publication by the CIC which provided me with the stats for the 1956 to 1966 period

This leaves me with 3 main questions:

1) After 1996 things are not that clear (at least not to me). CANSIM does provide a table (Immigrants to Canada, by country of last permanent residence #051-0006) but that table does not provide stats for Irish immigrants as those would be lumped under “Other Europe”. IS there another source to obtain that breakdown? I looked at the CIC website and more specifically at their Canada Facts and Figures 2012 document. That document presents data for the 2002 to 2012 period for “Permanent Residents by source country” and Ireland is listed as one of the countries. Would that number be equivalent to the number of immigrants by country of last residence? Even it that is the same number, that still leaves the 1997 to 2002 period uncovered, how can we obtain those stats?

2) For pre 1956 stats, I saw that the Canada Year Book would present tables going back to 1906 and I did find those numbers in the publication. However, the first edition of Historical Statistics of Canada seems to imply that, before 1956, immigrants were asked about their ethnic origin (or racial origin even earlier) rather than their country of last residence or country of origin. Can someone confirm this? The Canada Year Book tables do not have any explanatory notes and the language that they use for immigrant origins seems to change every so often.

3) And finally, for pre 1906 statistics, the essay in Historical Statistics of Canada (first edition) mentions various sources including, for the 1852 to 1959 period, the Annual Report 1959-60 of the Department of Citizenship and Immigration. Does anyone know if that report actually has immigration statistics for the whole period and, if so, does it provide statistics by country of origin or ethnic origin?


For historical data

Table 075-0022  offers Historical statistics, country of birth of other British-born and foreign-born population, *Terminated* every 10 years (foreign-born persons unless otherwise noted): < 07500 22&searchTypeByValue=1&p2=35> (Data from the Census of Pop) Immigrant population by place of birth and period of immigration (2006 Census) <>

For the early period (1867-1920s or so). You and your researcher may not like the answer although I am truly surprised these figures have not been compiled *somewhere.*

The CIC or its equivalent would be found in the documentation generated via administrative processes. For the early period, your information should be contained in the annual reports of the departments responsible for immigration and those reports will be found in the Sessional Papers of the Parliament of Canada. The Department of Agriculture was responsible for immigration from 1869-1892; the Department of the Interior was responsible for immigration from 1892 until 1917 when a Department of Immigration and Colonization was established.

The Sessional Papers were published as a discrete set from 1867-1925. You have to go to the series for each year and, using the Table of Contents/Index, find the SP number for the department you seek and then grab the appropriate volume. The Table of Contents/Index will give you a SP number and should also tell you the volume in which it will be found. From 1925-1929, only the Annual Reports were published (in a discrete series entitled "Departmental Annual Reports" with, however, the same binding and they are usually found on the shelves right after the earlier run of SPs). Thereafter, you need to look at departmental publications. A couple of years ago, I had my gov doc students find 1940s and 1950s immigration stats by country of origin and seem to recall it was an easy task as the department produced them in an annual report of some sort.

Note that many of the SPs have been digitized and can be found in, I think, Canadiana and the Internet Archive but, as the tools of discovery are not really that good, it might actually be easier to use the paper.

I checked the 1896 SPs at random and found the figures for 1895 in Annexes to the Dept. of the Interior’s Annual Report. It is Sessional Paper 13 and the report is a long one. Appended to the report are Annexes, which include reports of immigration agents from the principal ports (I saw one for Halifax and one for Quebec during my 10 minute perusal). Annex No. 2, for instance, is the report of the Halifax Agent of the ‘Dominion Government Immigration Agency’ and I found tables there, most of them broken down by origin (‘English,’ ‘Scotch,’ “Irish,’ and ‘other’).

You should consider, however, that the dates sought will impact upon the search and, possibly, the quality of the information. Prior to 1921, there was one Ireland and it was a part of the UK. Figures from that period tend to break down UK immigration and group the rest into “other.” If you need Irish immigration from, say, 1924, you may find one figure for “Ireland” (what we know as Northern Ireland) and another, either lumped in with “other” or, if you're lucky, found separately under “Ireland” (what we would call today Eire). You may also have problems with the accuracy of the figures as they pertain to intended destination -- attempts seem to have been made to clarify and to classify but a great many immigrants passed through Canada on their way to the US and the Agents made mention of this.

Tuesday, October 1, 2013

GDP Deflator Data


I have a researcher looking for GDP deflator data for provinces and territories from 1976 (or later, if 1976 is not available) to present.
I believe data at the national level is available from 1981-present in table 383-0008 under the metric "implicit price deflator"; however, I have not been able to find provincial-level data through CANSIM or the EFT. Does any such data exist?


The implicit price deflator is equal to current-dollar output, divided by real output. The output measure is consistent with the Quarterly Income and Expenditure Accounts, prepared by the Income and Expenditure Accounts Division.

GDP information is available from the National Economics account here

Below are the tables available