Thursday, June 26, 2014

Canadian Community Health Survey 2013 and Problem Gambling

Question

A researcher here is looking at problem gambling in Manitoba. There are a couple of CCHS surveys that have included questions on this, but Manitoba did not seem to buy into this optional content in the past. However, it seems that Manitoba is one of the provinces that did buy into this Optional Content for CCHS 2013, as per the questionnaire: <http://www23.statcan.gc.ca.proxy2.lib.umanitoba.ca/imdb-bmdi/instrument/3226_Q1_V10-eng.pdf> (logon id and password) page 223 of 373.

I know it’s probably a little early in the data life cycle, but could you please confirm that this was collected, whether there will be a PUMF that might include this, or whether it will be in the RDCs along with any projected dates?

As you can imagine, researchers are quite eager to get access to this data.

Answer

Problem Gambling was optional content for CCHS 3.1, and only NB chose it. For CCHS 2010, only NB and AB, Nunavut chose it as optional content, so that is why there are no data.
The Health Statistics Division confirmed that:

Yes, Problem Gambling was selected by Manitoba for 2013. The data is available in the RDC’s, but will not be included in the PUMF when it is created next year.



Land Areas for 2011 Census Divisions

Question

We are looking for land areas for all the CDs in Canada - I opened the Population and Dwelling Counts file for the Census Divisions (excel file) and only have 24 CDs listed. Is there a more complete file?

Answer

Geosuite 2011 should do the trick.

Wednesday, June 25, 2014

Potential Years of Life Lost data from 2000 to 2013

Question

A researcher is looking for Potential Years of Life Lost data from 2000 to 2013. She is looking for a breakdown of causes of death as presented in CANSIM tables 102-0010, 102-0211, 102-0011 but the most recent data is from 1997.

The recent PYLL figures in table 102-0110 only include suicide and unintentional injuries as causes of death. Does anyone know if it is possible to get recent PYLL data with regard to breakdown of causes of death as presented in the previous tables?

Answer

We do have a couple of tables with more recent PYLL information by those causes:

- Table 102-4309 has data for 2000/2002 and 2005/2007 down to the health region level.

- Table 102-4310 has data for 2005/2007 at the Census Metropolitan Area level.

- As mentioned 102-0110 only presents injury and suicide among the causes of death.  

There are also tables presenting PYLL by potentially avoidable, treatable or preventable causes, but they don’t break down further than that. 102-4311 is at the health region level for 2006/2008 and up, while 102-4312 is at the provincial level from 1979.

Anything beyond those would require a custom tabulation. 

If the client is looking more at the cause rather than the geography,s/he could use the various mortality by cause tables (e.g. 102-0551 or the causes by chapter tables 102-0521 through 102-0542) with some population estimates (e.g. 051-0001) and calculate the results himself/herself.  These would be at the Canada level only, however.

Monday, June 23, 2014

Survey of Intellectual Property Commercialization in the Higher Education Sector

Question

A researcher is enquiring into availability of data from this discontinued survey: <http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&lang=en&db=imdb& adm=8&dis=2&SDDS=4222>


Answer

At this time, we cannot provide any additional detail from what is available on CANSIM table
358-0025 <http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=3580025& pattern=survey+of+intellectual+property+commercialization&tabMode=dataTable&srchLan=-1&p1=1&p2=49>

However, it is of interest to know what she/he is looking for (in case we can ever reinstate this survey).

Canada Healthcare Spend Data

Question

I am looking for data about healthcare in Canada where I can see the Charges (direct cost, administrative Cost and Other) by Procedure at least for the Procedures with Higher Spend like (Total Joints, Pacemakers, Defibrillators, Spine, etc). Additionally, I am looking for details for the Direct Cost, in a way that I can disaggregate  Surgeon Costs, Implant Cost, Anesthesiologist, etc.Where would I be able to find this kind of data?


Answer

The Health Statistics Division (HSD) confirmed that they had no data on medical costs. HSD included a link to CIHI that might be helpful, though they don’t know if it includes cost by procedure: <http://www.cihi.ca/CIHI-ext-portal/internet/EN/SubTheme/spending+and+health +workforce/spending/cihi015954>.

Monday, June 16, 2014

Genealogy Question

Question

Genealogy questions are a bit beyond the scope of the service I provide, but I have a question from someone asking for clues about how to find census data about one of their relatives, born in 1880 in NFL, died in Toronto in 1976. To the best of my knowledge, the names of individuals are blocked out from Statistics Canada census data for privacy purposes, and I’m probably going to refer this person to the public library for assistance. But do you, in the DLI community, field many genealogy questions? How do you typically handle these?

Answer

The names are available (and searchable) for the early censuses. See: <http://www.bac-lac.gc.ca/eng/census/Pages/census.aspx>. Note: the summary of the legislation at the bottom of: <http://www.bac-lac.gc.ca/eng/census/Pages/census.aspx#census_lac>.

I get the occasional question from members of the public, and I do tend to refer them to the public library. This would also be a great place to refer them however: <http://www.bac-lac.gc.ca/eng/discover/genealogy/Pages/introduction.aspx>.

Thursday, June 12, 2014

2012 SFS PUMF

Question

Has the 2012 SFS public use file has been released? If not, when can we expect it?

Answer

The release plan for the SFS 2012 RDC file is in June 2014, and the release for the SFS 2012 PUMF is the Fall 2014.