Wednesday, March 30, 2016

Historical time series for suicide

Question

I am helping a researcher find suicide statistics going back to 1975. The Vital Stats Death Database goes back to 1921, so I am wondering why Intentional Harm (Suicide) series only go back to 2000?

Answer

The 1999 Health Indicators has

DETAILED CAUSES OF DEATH/RATE/AGE/SEX (00060144.ivt)

with seven different types of suicide from 1991-1996. The 1997 edition has a table (00060111.ivt) on suicides, with totals by age and province (no sex), but a time series from 1961-1993.

Tuesday, March 22, 2016

Number of students who graduated by year, by city

Question

Where can I find graduation data by year and city?

Answer

The Elementary-Secondary Education Survey (ESES) is an annual survey that collects aggregate data from each provincial/territorial Ministry or Department of Education. The information on enrolments is collected by type of program (regular, upgrading, and vocational), by grade and sex and by age and sex. The information on official languages programs is collected by type of program (regular second language programs, French immersion, and programs for the linguistic minority) and by grade.

The survey also collects data on secondary school graduates by type of program (regular, upgrading, and vocational), by age and sex.

Data is only collected by province (aggregating at that level).

Detailed information for 2013-14 on the data sources, description, methodology, etc..

http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=5102

CANSIM tables by number of graduates…

http://www.statcan.gc.ca/daily-quotidien/151119/dq151119d-cansim-eng.htm


Please see the Daily announcement for this release on November 19th:

Elementary–Secondary Education Survey for Canada, the provinces and territories, 2013/2014

http://www.statcan.gc.ca/daily-quotidien/151119/dq151119d-eng.htm


It looks like the best we can do is offer the following NHS data tables. NHS 2011 Profiles There are a couple on Secondary (High) School Diploma or Equivalent but they don’t provide the level of geographic detail the client is looking for, let alone the actual number of graduates.

Monday, March 21, 2016

Level of geography in the Canadian Internet Use Survey (CIUS)

Question

I have a pair of researchers wanting to find out about Canadians’ internet use at a lower level of geography than is available in CIUS 2012 PUMF. They want information for eight communities.

Is there any way they could find out, for example, the proportion of people who use the web to shop online or read the news at a level of geography like that?

Answer

We do have CIUS 2012 data in the RDC’s if the client is interested in accessing the data please refer to the application process:http://www.statcan.gc.ca/eng/rdc/process

On the RDC files, the Census Metropolitan Areas (CMA) and Census Agglomerations (CA) are the lowest level of geography available to create reliable estimates.

Mental health component for the 2013-2014 CCHS

Question

A researcher is asking whether there will be a separate CCHS Mental health component for 2014 or 2013-14, as there was in the previous cycle?

Answer

The CCHS 2012 Mental Health was a separate survey (previously done in 2002). While the CCHS ANNUAL survey does ask some mental health questions, they are 2 separate surveys, so no, there will not be another Mental Health survey/data released with the 2013-2014 annual survey.

Mental Health Survey:

http://www.statcan.gc.ca/daily-quotidien/130918/dq130918a-eng.htm

CCHS Annual Survey:

http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getInstanceList&Id=238854

Microdata on Income and Educational Attainment

Question

Is it possible to obtain microdata on Income and Educational Attainment at a more granular level than CMAs, without going via the RDCs? I realize that Income is a really sensitive variable in geographic terms, and I’ve looked at the NHS files in Nesstar and some other CANSIM tables, but haven’t found anything below CMAs in either place.

Would the NHS pumf (or a different survey file) enable drilling down to smaller geographic units for either of these variables?

Also, can you confirm whether this *would* be possible via the RDC, for either variable?

Answer

If the client would only like Income data then CT level data would be available for download through the 2011 NHS Profile in either CSV or IVT format. If, however, the client would like both Income and Education data crossed together then this data would only be available on a custom data basis through the nearest regional office.

The RDC does have data available down to the CT and CSD geographic level. There is also DA level data available but in order to disseminate this data you would need to aggregate the DAs to a 5,000 plus population area.

Thursday, March 17, 2016

Socio-economic Rankings

Question

I am working with a researcher who is looking at immigrant integration in communities in Toronto and the Silicon Valley. She has collected data through interviews with the immigrants and want to create a socio-economic ranking with the data she has. However, she is wondering about that ranking being skewed by the education variable – if an immigrant received a University degree in their home country but after immigrating are working at a lower level job, the education variable would affect their socio-economic rank (possibly put them at a higher level). Is there a resource I can point her to that addresses this issue and how to deal with it?

Answer

The Longitudinal Immigration Database (IMDB) could serve to inform the relationship between education at landing (not published since 2010) and long-term economic outcomes (from tax files). For example, table 054-0002 shows “Income of immigrants, by world area, sex, immigrant admission category, education qualifications, knowledge of official languages, and landing year for tax year 2013”: http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0540002&&pattern=&stByVal=1&p1=1&p2=-1&tabMode=dataTable&csid=

Monday, March 14, 2016

Historic Canadian flight data

Question

I've got a researcher looking for a source of historical flight data for small Canadian carriers. He wants individual flights including departure/arrival information and cancellations.

Is this available through the Airport Activity Survey, or any other Statistics Canada data source?

If not, does anyone on this know of the source for this data in Canada? For example, where do sites like http://flightaware.com obtain/purchase their Canadian data from? Directly from individual carriers? Or Transport Canada? (I don't see anything particularly likely on their website).

Answer

Some of this is available from NavCanada’s Aircraft Movement Statistics reports. Unfortunately, it’s been discontinued; the last release was in 2015. I don’t see any information about specific carriers, though.

Here’s a list of the publications and CANSIM tables related to aircraft movement.

http://www.statcan.gc.ca/pub/51-007-x/2014010/related-connexes-eng.htm


We have information on the arrival and departure of flights from Canadian airports by carrier from two potential sources – the Aircraft Movement Statistics (AMS) program and the Airport Activity Survey (AAS). The raw AMS data are collected from NAV CANADA and some small airports. The raw data for AAS are provided to us by Transport Canada who collect them directly from the carriers.

Unfortunately, for both AMS and AAS, the level of detail that the researcher is looking for is confidential. He/she could try a couple of websites (OAG, innovata) that have this kind of information but I doubt that either of these would have much coverage of small Canadian carriers.

Monday, March 7, 2016

Postal Codes and income

Question

I have been asked for help in finding most recent income levels and related postal codes. Also, separately, can I look up education levels and postal codes in same city?

Answer

They can find Income and Education data in the 2011 NHS profile here (they just need to type in the search):

http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/prof/index.cfm?Lang=E

For postal codes, they would need to contact the closes regional office for custom data request.

As well, the following may be of use/interest:

We have the census profile at the postal code level. The profile includes characteristics such as population, age, sex, dwellings, families, marital status and language.

Home
Census Program
Data products
Census Profile

We also have NHS Profile.
Home
Census Program
Data products, 2011
NHS Profile

Questions Regarding the Survey of Household Spending (SHS)

Question

A student has been looking at the terminated CANSIM Table 203-0020 and looking for more recent information on the items therein. The footnotes indicate that it has been replaced by CANSIM table 203-0027 due to changes in the methodology of this survey.

Unfortunately, however, this new Table does not include all of the same items, e.g., household appliances, that the terminated one did. So, question 1 became: can we get those numbers? I went to the questionnaire to ensure that they were still asking about these appliances and came up with question 2: the questionnaire asks about purchases of these items, but the CANSIM Table indicates that it is ownership at time of interview “households having…”. I also checked the User Guide for the 2014 SHS and it also talks about expenditures. Should the CANSIM Table actually be stating “purchased” not “having”?

Answer

There was a redesign of the survey and the questionnaire changed. Question 1- no the numbers can’t be retrieved after 2009. Question 2- the terminated CANSIM table is correct about the ownership. From 2010 on, this type of ownership information was not collected- just amounts spent on purchases.

Provincial input-output tables

Question

I have a student looking at inter-provincial trade - specifically products in the Agrifood Industry. All the Cansim tables that cover this are terminated - the most recent data is 2011 (386-0003).
The same for the Provincial input-output tables (381-0028).
We can't find what these tables have been replaced with - (some point to tables that don't break down by province, others don't break down by industry).

Answer

The interprovincial trade flows are now incorporated in the Supply and use Tables (catalogue 15-602-X)

Vehicle Emissions

Question

I have a student who’s looking for private vehicle emissions data. She has a report on private vehicle emissions (Catalogue no. 16-001-M, no. 12) that contains data at the CMA level, but it covers only to 2007. Is there a source of more recent information?

Answer

“The Canadian Vehicle Survey (CVS), which is a primary data source for the report cited below, was discontinued in 2009. As a result, there haven’t been any updates at StatCan on the information in the study. The Physical Flow Accounts have greenhouse gas emissions estimates available up to 2013 for household use of motor fuels and lubricants, however these are national estimates only.

The best information currently available for vehicle emissions is probably from Environment and Climate Change Canada (ECCC), which continues to publish the National Inventory Report (NIR) on an annual basis as the official benchmark for greenhouse gas emissions in Canada. The 2016 NIR, covering emissions up to 2014, should be available in mid-April of this year.”