Friday, December 20, 2013

Income Data

I have a graduate student who has her own survey data with postal codes, and would like to match income data to it. Since we've been advised that the 2011 NHS income data is not to be relied on, is there another source from which we can get household income data at the FSA level?


I can provide data by FSA for Census Families, lone-parent families and Persons not in a Census family--household usually refers to an economic family. I copied the definition of an economic family from the internet and a separate definition of census family from the user's guide enclosed above.

I'm going to suggest two different tables:

Family, table 1, Summary, which provides median income data Family, table 4, distribution of Total Income by all Family types.

The most current year is 2011 and the source of this data is from the T1 Tax File (TIFF), Administrative Data. I can only provide a cost quote once you choose one or more of the tables attached. For example, one table for all FSAs in Canada will cost $145.36 + taxes. If you choose more than two tables and more years then the cost will rise accordingly. I have data going back from 1990 to 2011--not all tables are available historically. If cost is an issue,you can download data from CANSIM for free from 2000 to 2011 by CMA and CA.

CANSIM numbers that may be helpful:
1110009 FAM 1 Family characteristics, summary
1110010 FAM 2 Family characteristics, by family type and age group
1110011 FAM 3 Families by type, composition, and parent characteristics
1110012 FAM 4 Family characteristics, by age of older adult, family type and family income
1110013 FAM 5 Families by family type, composition and total income
1110014 FAM 6 Sources of income by family type
1110015 FAM 17-18 Low Income Measures, by family type and family type composition
1110016 Fam 7 - 8 Economic dependency profile, by family type and source of income
1110017 Fam 9 - 10 Family characteristics, labour income profile, by family type
1110018 Fam 11 Labour characteristics, by sex and age group
1110019 Fam 12 Persons receiving Employment Insurance, by sex and age group
1110020 Fam 13 Single-earner and dual-earner families, by number of children
1110021 Fam 14 Husband-wife families, by wife's contrubution to husband-wife employment income
1110022 Fam 15 Family characteristics, families with children, by age of children

Definition of Economic Family:

Family structure refers to the combination of relatives that comprise a family. Classification on this variable considers the presence or absence of: legally married spouses or common law partners; children; and, in the case of economic families, other relatives.

Economic family refers to a group of two or more persons who live in the same dwelling and are related to each other by blood, marriage, common-law or adoption. A couple may be of opposite or same sex. Foster children are included.

By definition, all persons who are members of a census family are also members of an economic family. Examples of the broader concept of economic family include the following: two co-resident census families who are related to one another are considered one economic family; co-resident siblings who are not members of a census family are considered as one economic family; and, nieces or nephews living with aunts or uncles are considered one economic family.

Definition of Census Family:

Census family classifies people in the following manner: 1) couples(married or common-law) living in the same dwelling, with or without children; and 2) lone-parents (male or female) with one or more children. The residual population is called "persons not in census families" and is made up of persons living alone and of persons living in a household but who are not part of a couple family or lone-parent family.

Wednesday, December 18, 2013

Households and Environment Survey Release


When will the Households and Environment Survey be released?

The full 2013 microdata will be available in about 15 months time (i.e. March or April of 2015). There may be a few select variables available as early as August 2014, but that is dependent on resources, and in any event would be aggregate results rather than microdata.

Monday, December 16, 2013



Where can I find information on how many people are living with HIV/AIDS in PEI?


A lot of information on HIV/AIDS is on PHAC. You can also use STC, for mortality and cause of death (Table 102-4310).

Pregnant Women in PEI


Where can I find information on how many pregnant women there are in PEI per year?


In 1995, the collection of the data for this survey was transferred from Statistics Canada to the Canadian Institute for Health Information (CIHI). Once the data was collected, it was transferred to Statistics Canada to be released in The Daily. This process has caused some confusion with the users of the data. Statistics Canada has decided, in consultation with CIHI that the responsibility for disseminating these data should reside with CIHI. I would recommend viewing CIHI’s website for more information.

For Pregnancy and birth related tables, see:
<>I did find some tables from Statistics Canada, however, they were terminated in 2005.Pregnancy outcomes by province or territory of residence (Total Pregnancies)

Monday, December 9, 2013

Farm Financial Statistics


A researcher is looking for Farm Financial Statistics from the Census of Agriculture at the sub-watershed level around Lake Simcoe.We have found information at the Consolidated Census Subdivision (CCS) level via the Census of Agriculture website, which provides some granularity in the area but it's not a great match for the researcher's needs.

What are the options for getting Farm Financial Statistics that more closely matches the desired geography? If we sent a boundary file to StatCan, could we have a custom tab made? Or would we have to use the PCCF? Or something else entirely?


I confirmed with the author division that unfortunately this request would not be feasible because we do not release financial statistics at the watershed level. The database we use for these types of projects is not designed for these type of variables -- it is developed for "production" variables only.

Franchise Information


I'm trying to measure the impact of franchise businesses/locations across the economy. I'm interested in knowing the number, what industry they are in, how many people they employ, their financial information, etc. It looks like this information is available in the various Annual Survey of Service Industries (food services, travel arrangement services, etc), but these don’t seem to be available via the DLI, how can I access this information?


Try the Canadian Franchise Association:
There's also a Daily release for an Annual Survey of Service Industries, contact Client Services (toll-free 1-877-801-3282; 613-951-4612;

Thursday, December 5, 2013

Developing Math Skills Among Students


One of our researchers has been working with a multi-wave EQAO (Education Quality and Accountablility Office) dataset (100,000 students' responses) to look at students' developing ability in mathematics. The EQAO dataset provides a full-census snapshot for Ontario but the questions used are tied to the Ontario curriculum (this limits interpretation). Thus, he is looking for a dataset that would give him another way to look at how people learn new things. He has gone over Statistics Canada's YITS data codesheet in some detail. This data, however, mostly reflects questionnaire responses and derived data and he needs more detail. For example, does StatCan data include children's responses to each of the Peabody test questions? (the YITS only shows frequencies of the number of correct responses).


There are questions about the Peabody test on the NLSCY. The NLSCY master file includes the raw score and standard score for the PPVT-R. We do not release the results for individual items. Information about the scores can be found in the NLSCY User Guide.

Tuesday, December 3, 2013

Survey of Giving, Volunteering and Participating


Do the master files for the Canada Survey of Giving, Volunteering and Participating - 1997 to 2000, 2004, 2007, 2010 contain the full 6-digit postal codes?


They do not.

201 Census and NHS Data with 2006 Boundaries


A researcher would like to obtain the complete 2011 census and NHS profiles at the CSD level, but with the 2006 CSD boundaries.

I know that Statistics Canada can reconstruct the 2006 CSD boundaries from the 2011 dissemination blocks as explained here: < /pub/92-195-x/2011001/geo/csd-sdr/previous/pc-rp-eng.htm>

But since the profiles are not publicly available at that geography level, I suppose this would require a custom tabulation. Am I right?

Can you tell me what it would cost to get all the CSD cumulative profiles (for both the census and the NHS) with the 2006 boundaries?


Yes I would believe this is a custom tabulation.

Epidemiology Dataset


Wondering if anyone could suggest a data source for the following request. I initially thought of CIHI but cannot find anything that would help out this student:

"I'm a graduate student, and I'm looking for a dataset containing the times that individuals became infectious during an epidemic (or at least the time they were first observed to be infectious)."


Try McMaster, they have an epidemiology department.

Monday, December 2, 2013

CCHS Rapid Response Tables


It was announced in The Daily on October 9th, 2013 that these tables are available: "CCHS - Rapid Response on access to health care services & waiting times, 2013", but I haven't been able to find them. Where can I access these tables?


The summary tables are no longer confidential and may be sent to anyone who requests them. They are however, not currently posted anywhere. I will send them to you and add them to the EFT site.

Business Tables Announced Recently


I can't seem to remember, let alone locate, the announcement re the 1500 business tables which were added to the DLI a couple of months ago.

There's the the Survey of Innovation and Business Strategy? = There are 1450+ tables that make up that product.

DLI EFT - /MAD_DLI/Root/other-products/Survey of Innovation and Business Strategy - sibs

And there's also these tables:

"Survey of Innovation and Business Strategy (SIBS) - The survey was conducted by Statistics Canada in 2009 and sponsored by Industry Canada and Foreign Affairs and International Trade Canada. The survey, which covered manufacturing, most service industries, and other industries, was designed to address gaps in the understanding of factors that drive and impede business innovation and the adoption of technology in Canada. It provides information on the strategic and tactical decisions of Canadian businesses, as well as their innovation and operational activities."

DLI EFT - /MAD_DLI/Root/other-products/Survey of Innovation and Business Strategy – sibs