I have a researcher who is seeking to update data for a study that he has already completed. In the past he used data from Statistics Canada Census. The data was broken down by the following age groups
0 to 4 years
5 to 9 years
10 to 14
15 to 19
20 to 24
25 to 29
30 to 34
35 to 39
40 to 44
45 to 49
50 to 54
55 to 59
60 to 64
65 to 69
70 to 74
75 to 79
80 to 84
85+
He is looking for a similar age break down to make his previous data comparable to the current data.
He needs individual annual income data. He refers to as total income reported on income tax forms. I believe he is referring to Tax Filer data from CRA Income Tax Returns available from Statistics Canada.
The geography which he is seeking income data for B.C., and if possible for the Okanagan region. He indicated on the past he was able to access the data by CMA.
He has looked at Table 98-400-X2016110 https://www12.statcan.gc.ca/census-recensement/2016/dp-pd/dt-td/Rp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=110242&PRID=10&PTYPE=109445&S=0&SHOWALL=0&SUB=0&Temporal=2016&THEME=119&VID=0&VNAMEE=&VNAMEF=
He didn't find it useful because it only provided 7 age groups which is not enough comparative purposes for his research.
15 to 24 years
25 to 34 years
35 to 44 years
45 to 54 years
55 to 64 years
65 to 74 years
75 years and over
He indicated I could also use annual income data for the age groups of the primary household maintainer, but I can’t find this data either. Age groups from the 2011 census were:
Under 25 years
25 to 29 years
30 to 34 years
35 to 39 years
40 to 44 years
45 to 49 years
50 to 54 years
55 to 59 years
60 to 64 years
65 to 69 years
70 to 74 years
75 years and over
I sent him to Canada Table Tax filers and dependents 15 years of age and over with labour income https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1110002301
I have told him that the best method to get exactly what you are looking for is to pay for a custom report on Income of Individuals 13C0015 from Statistics Canada. See https://www150.statcan.gc.ca/n1/en/catalogue/13C0015 details on how to order the report. There is a similar report for Households 13C0016 see https://www150.statcan.gc.ca/n1/en/catalogue/13C0016
I indicated the report characterize the Canadian population by income and demographics. Data may be requested by gender for marital status, age groups, counts by single year of age, sources of income, income distribution by age group, taxes paid, selected deductions and benefits, median employment income, median total income and median after-tax income, plus national and provincial indices of median total income. The statistics are derived primarily from the annual tax file provided by the Canada Revenue Agency.
Data for some geographic areas are available starting from 1986. The latest data (2016) can be requested for Canada, provinces and territories, federal electoral districts, economic regions, census divisions, census metropolitan areas, census agglomerations, census tracts and certain postal geographies.
The cost of each custom product is based on the time required to produce it according to the client's requirements. The hourly rate is $75.52.
He didn’t seem to keen on the idea of paying for a custom report.
Do you have any additional ideas where he can access the needed data?
Answer from Subject Matter:
Did the researcher mention for which Census year he previously used the Statistics Canada Census data? Also, in the past did the user receive a custom table or did he use one of the standard products from the Census Program page? Finally, we received the following response back from subject matter:
“I checked Census 2006 and 2011 and Okanagan was not a CMA. We had ‘Okanagan-Similkameen’, ‘Central Okanagan’ and ‘North Okanagan’ as Census Divisions.
Also for Census 2016 Okanagan is not a CMA but ‘Okanagan-Similkameen’, ‘Central Okanagan’ and ‘North Okanagan’ are the Census Divisions.
Here are some reasons why he can’t access the data he is looking for:
1) For 2016 Census with ‘total income groups’ variable all standard tables we have is for the geographic hierarchy ‘Canada, Provinces and Territories, Census Metropolitan Areas and Census Agglomerations’. So he won’t find the geography he is looking for.
2) Individual income information was compiled for the population aged 15 years and over (Income Reference Guide, Census of Population, 2016) so for there is no age group below 15 years.
3) I checked all the standard tables for Census years 2011, 2006 and 2001 with ‘total income’ and ‘Age groups’. Please see the maximum grouping in cross tabulation below:
- For 2001: Total Income Groups (22) in Constant (2000) Dollars, Sex (3), Age Groups (9A) and Marital Status (6) for Population 15 Years and Over, for Canada, Provinces and Territories, 1995 and 2000 - 20% Sample Data - Cat. No. 97F0020XCB2001040.
2001 Census Data Products
- For 2006: Total Income Groups (23) in Constant (2005) Dollars, Age Groups (7A), Highest Certificate, Diploma or Degree (5) and Sex (3) for the Population 15 Years and Over of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2000 and 2005 - 20% Sample Data
- For 2011: Selected Demographic, Sociocultural and Labour Characteristics (168), Income Statistics in 2010 (3B) and Total Income Groups (7) for the Population Aged 15 Years and Over in Private Households of Canada, Provinces, Territories and Census Metropolitan Areas, 2011 National Household Survey (table contains Age group (9))
2011 National Household Survey: NHS Data tables
Based on his requirements a custom table is required.
The cost of each custom product is based on the time required to produce it according to the client's requirements. The hourly rate is $77.03 (http://icn-rci.statcan.ca/30/30a/30a_007-eng.html).
There is a base consultation fee of $519.95 for a minimal effort custom data request. The price is adjusted based on the specifications and degree of difficulty requested by the client.”
Follow-up Question:
Further of this email correspondence the researcher I’m working with used the following tables in his previous research:
Statistics Canada Data
2006 Census Tables
97-564-XCB2006006 (Income by industry)
97-559-XCB2006009 (Employment by industry)
94-579-XCB2006004 (Population by region)
2011 Census Tables
99-014-X2011044 (Income by industry)
99-014-X2011028 (household income)
99-012-X2011052 (Employment by industry)
Can’t seem to find the tables for income by age group.
Are there equivalent Tables from the 2016 Census?
Follow-up Answer from Subject Matter:
Statistics Canada Data
2006 Census Tables
97-564-XCB2006006 (Income by industry) AND 97-559-XCB2006009 (Employment by industry)
Industry - North American Industry Classification System (NAICS) 2012 (425), Employment Income Statistics (3), Highest Certificate, Diploma or Degree (7), Aboriginal Identity (9), Work Activity During the Reference Year (4), Age (5A) and Sex (3) for the Population Aged 15 Years and Over Who Worked in 2015 and Reported Employment Income in 2015, in Private Households of Canada, Provinces and Territories and Census Metropolitan Areas, 2016 Census - 25% Sample Data
[https://www12.statcan.gc.ca/census-recensement/2016/dp-pd/dt-td/Rp-eng.cfm?LANG=E&APATH=7&DETAIL=0&DIM=0&FL=I&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=112128&PRID=10&PTYPE=109445&S=0&SHOWALL=0&SUB=0&Temporal=2016,2017&THEME=0&VID=0&VNAMEE=Industry%20-%20North%20American%20Industry%20Classification%20System%20%28NAICS%29%202012%20%28425%29&VNAMEF=Industrie%20-%20Syst%C3%A8me%20de%20classification%20des%20industries%20de%20l%27Am%C3%A9rique%20du%20Nord%20%28SCIAN%29%202012%20%28425%29]
94-579-XCB2006004 (Population by region)
2016 Census topic: Population and dwelling counts [https://www12.statcan.gc.ca/census-recensement/2016/rt-td/population-eng.cfm]
2011 Census Tables
99-014-X2011044 (Income by industry) AND 99-012-X2011052 (Employment by industry)
See first link above
99-014-X2011028 (household income)
[https://www12.statcan.gc.ca/census-recensement/2016/dp-pd/dt-td/Rp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=110505&PRID=10&PTYPE=109445&S=0&SHOWALL=0&SUB=0&Temporal=2017&THEME=131&VID=0&VNAMEE=&VNAMEF=]
Household Income Statistics (3A), Structural Type of Dwelling (10) and Household Type Including Census Family Structure (11) for Private Households of Canada, Provinces and Territories, Census Metropolitan Areas and Census Agglomerations, 2016 Census - 25% Sample Data
Can’t seem to find the tables for income by age group.
Mother Tongue (10), Income Statistics (17), Highest Certificate, Diploma or Degree (15), Immigrant Status and Period of Immigration (10), Work Activity During the Reference Year (4A) and Sex and Age (15) for the Population Aged 15 Years and Over in Private Households of Canada, Provinces and Territories, Census Metropolitan Areas and Census Agglomerations, 2016 Census - 25% Sample Data
[https://www12.statcan.gc.ca/census-recensement/2016/dp-pd/dt-td/Rp-eng.cfm?LANG=E&APATH=7&DETAIL=0&DIM=0&FL=I&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=111821&PRID=10&PTYPE=109445&S=0&SHOWALL=0&SUB=0&Temporal=2016,2017&THEME=0&VID=0&VNAMEE=Income%20statistics%20%2817%29&VNAMEF=Statistiques%20du%20revenu%20%2817%29]
