Wednesday, May 25, 2016

Canadian Community Health Survey (2007-2008) and rapid response component


A researcher wants access to the rapid response data in the 2007-2008 Canadian Community Health Survey (CCHS). Is this available through a public use file that gets requested or is it through the RDCs?

The codebook states: “The rapid response component is offered on a cost-recovery basis to organizations interested in obtaining national estimates on an emerging or specific topic related to the health of the population.” I am assuming public use here?


There are no PUMFs for the rapid response components of the CCHS. The data files are in the RDCs. Custom tabs are also available and all work is done on a cost recovery basis. Each request has to be reviewed individually and the cost assessed according to the detail requested and the level of complexity of the request.

Education in Census 2006 by Census Tract


I have a researcher interested in looking at the ‘No certificate, diploma or degree’ variable in Education for both sexes ages 20-24 (custom range) for specific Census Tracts from the 2006 Census.


The client should be able to download the following 2006 Census table. They will need to download the entire table in IVT format so will have to install the Beyond 20/20 table browser (see instructions within the download tab).

They can then find the CTs within the table.

Topic-based tabulation: Highest Certificate, Diploma or Degree (14), Age Groups (10A) and Sex (3) for the Population 15 Years and Over of Census Metropolitan Areas, Tracted Census Agglomerations and Census Tracts, 2006 Census - 20% Sample Data,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=75&VID=0&VNAMEE=&VNAMEF=

Teachers' Salaries


I have a grad student who’s looking for average salary information for primary and secondary school teachers.

I can find current information using the salary grids published by the various teachers’ federations / unions, but he’d like some historical information as well. Survey of Employment Payrolls and Hours (SEPH) contains employee and salary figures for elementary and secondary education but only at the 4-digit level, which means it could include teacher’s aides, etc.


CANSIM table 281-0026 provides average weekly earnings for the NAICS 6111 and by categories of employees: ‘salaried employees paid a fixed salary’ (teaching) and ‘employees paid by the hours’ (non-teaching). The teaching category should exclude substitutes, but respondents may include them. Unfortunately we have nothing below NAICS4.

Thursday, May 19, 2016

Survey of Financial Security 2012 - expenses


I have a patron who is interested in using the Survey of Financial Security to run a multi-year analysis (1999, 2005, 2012). However, she needs to use the expense variables, and while these are present in 1999 and 2005, the derived variables aren’t present in the 2012 PUMF and I’ve been unable to find if they were even asked in 2012. I’m referring to the questions that in the 2005 PUMF were used to create ECFEXCHR (child-related expenses), ECFEXHMR (home related expenses), and ECFEXVHR (vehicle related expenses.

Was the entire block of questions used to create these variables dropped in 2012, or are they still on the master file?

Also, I’ve found references to a Survey of Financial Security 1983, which someone seems to have had a PUMF of at one point (Princeton seems to have). Is this available anywhere?


Subject matter has confirmed that -

1- The section on expenses is no longer on the 2012 Survey of Financial Security; and nor will it be available for the 2016 SFS, even on the Master File.

2- Concerning references to a Survey of Financial Security 1983, which someone seems to have had a PUMF of at one point (Princeton seems to have).

There is a PUMF for 1983/1984 Survey of Consumer Finance(SCF), asset and debt survey(not Survey of Financial Security) available on the EFT:

Unfortunately there seem to be little supporting documentation.

Canadian / American survey equivalents


I have been asked what the closest equivalent Statistics Canada survey would be compared to the U.S. Panel Study of Income Dynamics. The user used to use Survey of Labour and Income Dynamics (SLID), but eventually stopped as it was available only in RDCs. (I think SLID is the closest equivalent.)


A few other data sources to consider would be the LAD (Longitudinal Administrative Databank) and LISA (Longitudinal and International Study of Adults). As well, you could look into the CIS (Canadian Income Survey) which is the official survey that followed SLID, however it is not longitudinal, but cross-sectional.

Postal Code Conversion File (PCCF)


Is the Postal Code Conversion File (PCCF) free or is that something we need to pay for?


The postal code conversion file, is part of the DLI Annual licence, as long as your institution signs the yearly renewal of the PCCF licence Appendix II. The PCCF signed licence agreement in regards to this year’s renewal is valid until Dec 21 ,2016.

If an institution has chosen not the sign the Postal Code licence agreement, the researcher at that institution would need to sign the agreement and would be subjected to the annual licensing administration fee ($892), which is required to access any or all of the Postal CodeOM Conversion File, Postal CodesOM by Federal Ridings File, or Postal CodeOM Conversion File Plus product(s).

Access to the PCCF files is being managed under separate EFT safes. DLI Contacts, whose institution has signed the agreement, would be able to access MAD_DLI_PCCF to retrieve the files.

Poverty index/income level across Canada


I am looking for postal code and poverty index/income level across Canada. I have found some low income data but is there anything else?


Data from the T1 Tax File uses LIM (low income measure), specifically Family, tables 17 (before-tax) and table 18 (after-tax). Postal code data is available, but only as a custom request, which can be costly. There are very strict rules governing the use of postal code data and if your client goes that route then I could send you the guidelines for the client to produce a conversion file.

Another possibility are FSA’s (forward sortation areas), which are the first three characters of an urban postal code, i.e. K1E, K2B etc. The client could receive Family, tables 17 and 18 for all FSA’s and Rural Postal Codes in Canada, cost would be $151.26 + taxes for the most current reference year, 2013. If the client adds more tables or years, then the cost will rise. Adding geography does not impact on the cost for standard tables.

It’s very important that the client understand what an FSA means, therefore I copied the definition right out of the user’s guide.

Definition of FSA:

The urban Forward Sortation Area (FSA, identified by the first three characters of the Postal Code) includes residential addresses covered by the first three characters of a Postal Code in a particular urban area. Only residential FSAs are considered for these databanks. Postal Codes within urban FSAs for which the mail delivery is based on Suburban Service delivery or on Rural Route delivery(level of geography 05 and 04) are excluded from these FSAs, but are included in the City Total (level of geography 08). Non-residential postal codes defined as Other Urban Area (level of geography 08) are also excluded from Urban FSAs, but are included in the City Total (level of geography 08).

Only urban residential FSAs are considered for these databanks. One FSA can be split in different parts if it is associated with more than one postal city.

Custom tabulations can be produced on a cost recovery basis for data based on complete urban and rural FSAs.

Another possibility for low income statistics is from the Canadian Income Survey. Data can be found within CANSIM series 206. FSA’s are not available from CIS.

Teachers in Universities


I have a faculty member looking for the Teachers in Universities data series. He wants 2007-08 to the last year it's available. I'm not familiar with this survey, is it available in the DLI? If not is there another way he can get what he needs?


We have the University and College Academic Staff System (UCASS), you can find all information regarding this survey at the following link :

The last year of data available are for 2010-2011. The tables will be added to the DLI for future requests.

Aboriginal labour force stats 1996


I am looking for labour force statistics ie. unemployment rate, participation rate, & employment rate for Canada's Aboriginal Identified population for 1996. I would like these 3 statistics for the following groups:
Total Aboriginal identified populationFirst Nation/Status IndianMetisInuitNon-Aboriginal population
I have found these statistics for 2001 & 2006 in the Census Data & for 2011 in the 2011NHS, but am not able to find comparable data for the 1996 Census year.


I don’t a see anything available specifically in our standard products but it is something that could be done via a custom request.

That being said, searching online, I did find a publication that may be useful to them.

Produced by INAC using 1996 Census data.

Monday, May 16, 2016

Immigration data for Mirabel airport


I have a researcher who is looking for immigration data at the port of entry level, specifically for the Mirabel Airport in Montreal, from 1975 to 2004.

She would like to obtain the following info:

· Total number of landed immigrants who went through the airport. These numbers are available for the 1966 to 1996 period from the Immigration Statistics Archive ( but we are missing the 1997 to 2004 period. Is that available anywhere? And it would be nice to obtain a table summarizing this information for the whole period(1975 to 2004) as the Immigration Statistics Archive is composed of individual pdf documents for each year.

· Country of origin of immigrants going through Mirabel, per year (1975 to 2004)

· Type of immigrant category (family, economic, refugee, other), also per year (1975 to 2004)

Finally, she would also like to know the percentage of successful immigration requests for immigrants landed through that same airport. I’m not sure if that question makes sense as my impression is that one has to apply for immigration from outside of Canada and cannot apply upon arrival at the airport, but I would like to confirm that.


This data should be available from CIC’s Immigrant Landing File. It contains a variable for point of entry, for country of origin and immigration category.

SASD does have access to a data source called the Longitudinal Immigration Database (IMDB), which is a record linkage between the Immigrant Landing File and T1FF tax data. However, it has a linkage rate of approximately 87% and its intended use is for analysing the economic performance of immigrants, via the tax data. If none of the tax file data is of interest, the IMDB should not be used. Furthermore, this data source only includes immigrants who obtained their landed immigrant status since 1980 and who have filed at least one tax return since 1982. Due to these limitations, our data source would not be appropriate.

A landed immigrant could have been living in Canada for multiple years before obtaining their landed immigrant status. So it may be possible to obtain data relating to successful applications for immigrants who entered Canada via Mirabel Airport. Unfortunately, I cannot say this with certainty and you will have to contact CIC for a more thorough answer.

Finally, to contact CIC about a potential data request, you can try this

Tuesday, May 3, 2016

CCHS - 1 and 2 year files


We’re wondering if there is any way to merge / combine the annual release of the Canadian Community Health Survey with the two-year merged file.

Is there any way to merge the 2012 annual CCHS PUMF file with the 2011-12 two year PUMF? I am working with a student who is interested in the variable named CHP_03 on both files. There are many more valid cases on the 2012 file than on the 2011-12 file, however, for other variables she needs it is the reverse, so if it were possible to merge that would greatly help her analysis.

More generally, why does the two-year file, while having twice as many cases overall as the one-year file, sometimes have far fewer valid responses on certain variables? For the above variable, the one-year file (annual component) has 61607 cases while the two year file has only 6943, or about a tenth as many. This seems odd.


CHP was optional content for 2011 and only MB chose it, while in 2012 it was Core content. The optional selection of the module in 2011 will mean more valid cases on the 2012 file because the two year file only has data for those provinces that selected the module in both years.

The 2011-2012 file is already the combination of the two individual years, so trying to append on the 2012 cases again would duplicate those respondents. It would not give you any more cases to analyse. If there is some correlate variable that you want to look at against CHP_03, it should be on the 2012 file. Anything on the two-year file is necessarily on the one year files. There will be more records on the two-year, but they will be the respondents from 2011, which as you know only had data for CHP_03 in Manitoba.

Any pooling of years should be done where the content is common across the same geographies over those years. Maybe consider looking at the 2013-2014 PUMF. CHP was still core for the latest release, so maybe it would support the analysis (and give more recent results).