Monday, April 24, 2017

Canadian Health Measures Survey

Question
I have a researcher who is looking to possibly use the Canadian Health Measures Survey and is looking for information on what components data is collected for.

Here is the question:
I am trying to determine if I could potentially use the Canadian Health Measures Survey for an upcoming study. I know they collect biological samples (blood, urine etc.) and I was just wondering if there is a list of which components they collected data for (e.g. creatinine, arsenic).

Does such a list exist and is it publicly available? If not, is there someone she could contact to get this information?

Answer 
Here is the response from Subject Matter, along with the corresponding attachment:

“I’m attaching the CHMS Content Summary for Cycles 1-8. Please share this with the researcher:

There are no data files available to researchers through the DLI. Access is available however to approved research studies through the RDCs. Here’s a link to the program:
http://www.statcan.gc.ca/eng/rdc/index. Custom tabulations are also available on a cost recovery basis.”

Canadian Coroners and Medical Examiners Database

For anyone interested in the accessing the Canadian Coroners and Medical Examiners Database:

“The CCMED began collecting information for deaths having occurred in 2006, however, only the data up to and including the 2010 reference year were released. Comprehensive data for all provinces and territories are not available: Manitoba and Newfoundland and Labrador have yet to provide data, and data for other provinces and territories are unavailable for some years and/or some data elements. The project lost a lot of momentum with the expiration of the data sharing agreements with the provinces and territories. The opioid crisis has renewed interest in the CCMED and most provinces and territories have signed the new agreement. We are hoping to reconvene the steering committee shortly and start looking at how we can improve the quality, coherence and timeliness of the data received across the jurisdictions. With the exception of the Public Health Agency of Canada, the CCMED microdata are not available to researchers external Statistics Canada.”

Friday, April 21, 2017

DA suppression list for 2001? EA suppression lists?

Question 1Does anyone know if there is a list of DAs from which data was suppressed or unavailable in 2001? Are there similar lists for enumeration areas for other years (1991, 1996)? If they are on the EFT, where are they all hiding? J

A student is doing historical research with census data, and she found a few DAs for which we can't find any data through the archived census profile on the EFT or from other products that share census data such as the Census Analyser. Sometimes with historical research the students fail to realize that the boundaries have changed, which requires the help of the correspondence files, but these DAs definitely exist in 2001 as shown in boundary files or reference maps.

For example, DA 12090310 is located right in Halifax. But we can't find any data on it! In the 2001 Beyond 20/20 profiles, we jump straight from 12090309 to 12090311. So where can we find some sort of explanation about why data wasn't released for that DA and other DAs, preferably with lists of suppressed DAs for 2001 and EAs for older years?

Question 2
In some cases, only some subsets of data are available for select DAs. For example, in 2006, 12090292 has the total number of census families and many other (but not all) variables, but age counts (?!) seem to be unavailable. The student would love some sort of explanation that she can quote in her thesis. When looking at the notes for the profile in Beyond 20/20, only the criteria for suppressing data about income is explained.

Answer
We have received the following response from subject matter regarding your questions:

“Unfortunately, the DA suppression list is nowhere on our website…we do have the CSD suppression list in the notes for the data quality and confidentiality of the community profiles. I compiled a list of suppressed DAs (approximately 8,909 DAs) in a spreadsheet for you (please see attached spreadsheet). This suppression list is not very accessible for previous Censuses.

To answer your questions: In your example below (question 1) of DA 12090310, this DA in Halifax is suppressed. You can see from Geosuite 2001 that this DA does not meet the population threshold for the data quality and confidentiality rules.

For question 2, the specific DA 12090292 is not suppressed for 100% data but it is suppressed for 20% data (the non-response rate for the 20% was over or equal to 25%). You can find an explanation in the Beyond 20/20 notes in the data quality flag section.

For example, in the Beyond 20/20 file in the geography row you will see the following type of description for a particular DA. There is a 5 digit code containing the data quality flags which indicate whether suppression at the data quality level has been applied. See example below with the description of the DQ flags:


2006 Census – Data quality flags and descriptions
Data quality flags for place of residence

Digit Description
1st (0XXXX) Incomplete enumeration flag
2nd (X0XXX) 100% data quality flag
3rd (XX0XX) Population and dwelling counts error flag
4th (XXX0X) 20% sample data quality flag
5th (XXXX0) 2001 adjusted population flag

Flag description
Incomplete enumeration flag
0 = Default.
1 = Incompletely enumerated Indian reserve or Indian settlement (suppressed).
2 = Excludes census data for one or more incompletely enumerated Indian reserves or Indian settlements.

100% data quality flag
0 = Default.
1 = Data quality index showing, for the short census questionnaire (100% data), a global non-response rate higher than or equal to 5% but lower than 10%.
2 = Data quality index showing, for the short census questionnaire (100% data), a global non-response rate higher than or equal to 10% but lower than 25%.
3 = Data quality index showing, for the short census questionnaire (100% data), a global non-response rate higher than or equal to 25% (suppressed).

Population and dwelling counts error flag
0 = Default.
1 = An error exists in the 2006 population and dwelling counts for this area. For further details, please refer to the population and dwelling counts data section of the 'Notes' file.
2 = In 2001, the population and/or dwelling counts for this census subdivision were found to be incorrect. Since it is not possible to make changes to the 2001 Census data presented in these tables, the 2001 data should be used with caution. For further details, please refer to the population and dwelling counts data section of the 'Notes' file.
3 = Both the 2006 and 2001 population and/or dwelling counts for this area were found to be incorrect. Since it is not possible to make changes to the census data presented in these tables, these counts should be used with caution. For further details, please refer to the population and dwelling counts data section of the 'Notes' file.

20% sample data quality flag
0 = Default.
1 = Data quality index showing, for the long census questionnaire (20% sample data), a global non-response rate higher than or equal to 5% but lower than 10%.
2 = Data quality index showing, for the long census questionnaire (20% sample data), a global non-response rate higher than or equal to 10% but lower than 25%.
3 = Data quality index showing, for the long census questionnaire (20% sample data) or the short census questionnaire (100% data), a global non-response rate higher than or equal to 25% (suppressed).

2001 adjusted population flag
0 = Default.
1 = 2001 adjusted count; most of these are the result of boundary changes.

Note:
1. The 100% and 20% sample data quality flags do not apply to the population and dwelling counts.

Data quality flag for place of work

Digit Description
4th (XXX0X) 20% sample data quality flag

Flag description
20% sample data quality flag
3 = Data quality index showing, for the long census questionnaire (20% sample data) or the short census questionnaire (100% data), a global non-response rate higher than or equal to 25% (suppressed).

More detailed information can be found here: Data quality and confidentiality standards and guidelines (public): Introduction.”

Tuesday, April 18, 2017

MBM Calculation

Question
Can anyone point me to the latest report that lists the basket of goods in the latest Market Basket Measure.

I found this report - hs28-178-2010-eng.pdf but have not been able to find a more up to date report and the actual goods used to calculate the mbm.

Answer
We have received the following response from subject matter regarding your request:

“Yes, the June 2010 First Comprehensive Review of the Market Basket Measure of Low Income, Final Report is the latest report available.

Yes, internet access services are included in the basket (in the other expenses component).”

Thursday, April 13, 2017

2016-Q4 Inter-corporate Ownership (ICO) [Catalogue no. 61-517]

This is to inform you that the fourth quarter of 2016 Inter-corporate Ownership (ICO) [Catalogue no. 61-517] was released in The Daily this morning at 8:30 a.m.
You may access these data via the EFT:
/MAD_DLI_IDD_DAM/Root/other_autres/2503_ICO_LPES

2017-Q1 Inter-corporate Ownership (ICO) [Catalogue no. 61-517]

This is to inform you that the first quarter of 2017 Inter-corporate Ownership (ICO) [Catalogue no. 61-517] was released in The Daily this morning at 8:30 a.m.
You may access these data via the EFT:
/MAD_DLI_IDD_DAM/Root/other_autres/2503_ICO_LPES

Monday, April 10, 2017

Labour Force Survey (LFS) – March 2017

Labour Force Survey (LFS) – March 2017
LFS data for March 2017 are now available on the EFT site.

This public use microdata file contains non-aggregated data for a wide variety of variables collected from the Labour Force Survey (LFS). The LFS collects monthly information on the labour market activities of Canada's working age population. This product is for users who prefer to do their own analysis by focusing on specific subgroups in the population or by cross-classifying variables that are not in our catalogued products

The Labour Force Survey estimates are based on a sample, and are therefore subject to sampling variability. Estimates for smaller geographic areas, industries, occupations or cross tabulations will have more variability. For an explanation of sampling variability of estimates, and how to use standard errors to assess this variability, consult the Data Quality section in the Guide to the Labour Force Survey.

Eft: /MAD_PUMF_FMGD_DAM/Root/3107_LFS_EPA/1976-2017/data/micro2017-03.zip