Tuesday, September 12, 2017

2011 and 2014 Public Service Employees Survey (PSES)

Is it possible to get the Public Service Employees Survey (PSES) files for 2011 and 2014? At the moment the PSES files up to 2008 are available in CHASS.

Thank you for contacting the Data Liberation Initiative (DLI). Public use files for the 2011 and 2014 PSES were not created. The 2008 cycle is the last reference period for which a PUMF was produced: http://www5.statcan.gc.ca/olc-cel/olc.action?ObjId=71M0016X&ObjType=2&lang=en&limit=0.

Public Service Employee Survey, 2014
Aggregate tables presenting the 2014 Public Service Employee Survey results for the entire public service and federal departments are now available upon request. Contact:
(toll-free)1-800-263-1136; or 514-283-8300

The tables are also available on the DLI EFT’s collection to DLI Contacts. They are found here: /MAD_DLI_IDD_DAM/Root/other_autres/4438_PSES_SAFF

Friday, September 8, 2017


A researcher has expressed interest in the CanCHEC (Canadian Census Health and Environment Cohort) data. She would like to consult the documentation before deciding whether to submit a proposal to the RDC. When I look at the CRDCN website, I am not able to locate any documentation such as the data dictionary, codebook, etc. Any assistance you can provide is most appreciated.

Apparently, there is no codebook for CanCHEC 2001. However, there are currently zero codebook available for CanCHEC 1991 which are usually provided to researchers interested in CanCHEC 2001. As per the SFP variables are roughly the same, except for the CCR – cancer information is not available in the 2001 dataset. However, the user guide is not part of the non-confidential tools located on the social surveys drive so, to my knowledge, it hasn’t been approved for release from the RDC.

Alternatively, researchers can get a comprehensive overview of the 2001 CanCHEC in the Health Analysis Division’s publication found here: http://www.statcan.gc.ca/pub/11-633-x/11-633-x2016003-eng.htm. I would recommend reviewing this in the meantime as it outlines almost everything that is found in the user guide. For variable information, they can use the 1991 CanCHEC non-confidential codebooks (attached to this email).

Friday, September 1, 2017

Data Wealth Distribution in Canada

I have a question from a professor who would like the most recent data for wealth distribution in Canada - she is having trouble finding anything. All I've found is a reference to Survey of Financial Security from StatsCan and some reports.

She also said she would prefer decile although quantile will do if not available.

The Survey of Financial Security would be your best bet. The CANSIM numbers are 205-0002 and 205-0003.

Survey of Financial Security (SFS), composition of assets (including Employer Pension Plans valued on a termination basis) and debts held by all family units, by age group, Canada and provinces, occasional (2012 constant dollars), 1999 to 2012:
Description http://www5.statcan.gc.ca/cansim/a34?lang=eng&mode=tableSummary&id=2050002&stByVal=1&&p1=1&p2=50
Table 205-0002 http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=2050002&tabMode=dataTable&p1=1&p2=50&srchLan=-1

Survey of Financial Security (SFS), composition of assets (including Employer Pension Plans valued on a termination basis) and debts held by all family units, by net worth quintiles, Canada and provinces, occasional (2012 constant dollars), 1999 to 2012:
Description http://www5.statcan.gc.ca/cansim/a34?lang=eng&mode=tableSummary&id=2050003&stByVal=1&&p1=1&p2=50
Table 205-0003 http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=2050003&tabMode=dataTable&p1=1&p2=50&srchLan=-1

There could also be analytical reports or articles pertaining to wealth:

The National Economic Accounts Division produces CANSIM 378-0121, 380-0072: http://www.statcan.gc.ca/daily-quotidien/161214/dq161214c-eng.htm

Tuesday, August 29, 2017

Health Canada CUBE

We have Human Kinetics researchers who have a lead on a new database which I can’t track down. Any tips on this would be appreciated.

They attended a Health Canada presentation last year and were told that 7-8 large health related surveys, including Canadian Health Measures / biometric data, would be made available this calendar year for extracting via a CUBE(S) at an aggregate data level. I have checked the Health Canada web site and do not see new CUBE datasets.

Would my colleagues or the Statistics Canada Health Division know whether this new initiative has been implemented and is available?

I am not aware of such an initiative unfortunately, so I have reached out to colleagues in Health Statistics to inquire if they know of something. I was able, however, to find on the Public Health Agency of Canada (PHAC) website data cubes: Data Cubes http://infobase.phac-aspc.gc.ca/cubes/index-eng.html

Data Cubes are interactive databases that quickly allow users to create tables and graphs using their web browser. These online analytical processing cubes, or OLAP cubes, produce output displayed in a table format with a corresponding graph.

Chronic Disease Infobase Data Cubes contain many different types of Chronic Disease health indicator information. The hope is to make available Data Cubes containing data such as mortality, morbidity and risk factor information for chronic diseases, as well as their associated demographic variables (such as age group, gender, and geography).

Followup (Sept 1, 2017)
In follow up, here is the response I received through my contacts in Health Statistics division:

"No one up here has any knowledge of any HC CUBE plans. I do know that HC has the intention of making their most recent biomonitoring data available through the Open Data Portal. However, PHAC (Public Health Agency of Canada) has a public data cube on health inequality that contains aggregate data from a variety of STC (mainly HSD) surveys. This might be what the researcher is referencing. The cube and related information can be found here: http://infobase.phac-aspc.gc.ca/health-inequalities/."

Thursday, August 24, 2017

Survey of Emergency Preparedness and Resilience in Canada (SEPR)

One of our researchers is looking for the 2014 Survey of Emergency Preparedness and Resilience (SEPR) data. All I was able to find is the report. Is the data available? How can we obtain it?

The SEPR was developed in partnership with Defence Research and Development Canada's Centre for Security Science and Public Safety Canada. Unfortunately, a public use microdata file (PUMF) was not created, nor were tables produced for CANSIM. The following article as noted was made available:

The Juristat article "Emergency preparedness in Canada, 2014" (Catalogue number85-002-X) http://www5.statcan.gc.ca/olc-cel/olc.action?ObjId=85-002-X201500114234&ObjType=47&lang=en&limit=0, is now available.

[To access the above], from the Browse by key resource module of our website under Publications, choose All subjects, then Crime and justice and then Juristat.

And there are a few tables available through the data release announcement in the Daily: http://www.statcan.gc.ca/daily-quotidien/151028/dq151028a-eng.htm.

Custom tabulations, which are cost recovery, may be available. And the masterfile is available through the Research Data Centre program, see http://www.statcan.gc.ca/eng/rdc/data.

Tuesday, August 22, 2017

Greenhouse gas emissions by province

I’m helping a user who is interested in finding data similar to CANSIM table 153-0114, but at the provincial level – specifically for Ontario 2013. Is this available or could it be produced as a custom request?

Subject matter has confirmed that unfortunately greenhouse gas emissions 153-0114 is not yet available by province. That is on their work plan for this upcoming year. Energy use by province will be available as a custom tabulation following our PFA release in September.

Canadian Business Count by Revenue & non-academic patron

I have had a request today from a member of the public (non-academic) looking for Canadian Business Count by Revenue. The closest publicly available data set that was located was the Business Counts by Employee Size: http://www.statcan.gc.ca/daily-quotidien/170814/dq170814b-eng.htm

Would our non-academic client be able to request a custom tab for the “Business Counts by Revenue” through Statistics Canada? (He is happy to pay to get this data). Since this would be a non-DLI request, is there another Statistics Canada department or staff I can refer him to? Many thanks for your help!

For custom request, I would advise them to contact Advisory services. They are able to determine if the request can be completed from a regional office or from subject matter division. Below is their contact information:

General inquiries: Our agents are available Monday to Friday (except holidays) from 8:30 am to 4:30 pm.

Online request form:
Email STATCAN.infostats-infostats.STATCAN@canada.ca

(toll free) 1-800-263-1136
(international) 1-514-283-8300