Thursday, September 29, 2016

Custom tab request: Labour force by industry, CSD level, 2006 Census

Question
I've got a researcher looking for more granular data for labour force by industry. 2006 Profiles include only two-digit NAICS codes and I'm looking for either three or four (currently waiting for the researcher to tell me which). In the meantime, could you tell me if it would be possible to produce a custom tab of labour force by industry for NAICS codes 212 and/or 2122 for each CSD in Canada?

Answer
I confirmed with Census subject matter that it is feasible to produce a custom tab of labour force by industry for NAICS codes 212 and/or 2122 for each CSD in Canada.

Wednesday, September 28, 2016

Revised and/or enhanced Discharge Abstract Database files for 2014-2015


With the kind cooperation of the DLI group, I have uploaded a zip file containing revised geographic and clinical files for the 2014-2015 CIHI DAD onto the DLI EFT site, into the /MAD_CIHI_ICIS_DAM/Root/discharge-abstract-database-2014-15/data/Revised folder. I hope that the community finds them useful.

About the revisions and/or enhancements to the 2014-2015 DAD files:

The revised data files have data transformed (where appropriate) from string variables (e.g., as received, age may be recorded as a string of "Under 1 year") to coded variables (restoring age to an ordinal variable). It also restores the proper CCI encoding, reinserting the punctuation which is omitted from the file received from CIHI, making it possible for the user to match the data stored in the file to the documentation.

As distributed by CIHI, there are 25 ICD10 variables for diagnoses, and 20 variables for type of intervention. In addition to those variables, the revised data file also contains 245 ICD10 and 190 CCI flag variables - these identify which records contain particular codes across any of the multiple ICD10 or CCI variables.

For example, consider the constructed variable

CCIF040 "Diagnostic Interventions on the Nervous System (2AA - 2BX)"

If any of the 20 CCI variables (I_CCI_1 through I_CCI_20) in a record contain a code that begins with the string 2AA through 2BX, that record will be flagged in variable CCIF040 as true: a "Diagnostic Intervention on the Nervous System" was reported in at least one of the 20 CCI variables.

Similarly, consider the constructed variable

ICDF127 "Reported K40-K46: Hernia"

If any of the 25 ICD10 diagnosis variables (D_I10_1 through D_I10_25) in a record contain an ICD10 code that begins with the string K40, K41, K42, K43, K44, K45, or K46, that record will be flagged in variable ICDF127 as true: a Hernia was reported in at least one of the 25 ICD10 variables.

Additionally, the revised data files contains counts of the number of diagnoses and interventions for each record on the file. This enables the user, for example, to distinguish "simple" cases (e.g., one diagnosis or intervention) from complex (however many the user defines as complex).

The zip file contains ASCII (.rev) and SPSS system file (.sav) versions of the revised data files. It also contains the two SPSS programs which are used to reformat the clinical file, and the SPSS program used to reformat the geographic file. It also contains the log files (in both ASCII text format and SPSS spv format) created from running the SPSS programs, and the frequencies of each variable (including the constructed flag and count variables). The frequencies of the 25 ICD10 diagnosis are contained in a single text file; the 20 CCI variables are contained in a second text file. The log files contain a write statement, which shows the record layout of the ASCII versions of the revised data files (hence the .rev extension).

Tuesday, September 27, 2016

DLI Nesstar search

DID YOU KNOW!

The Nesstar search allows users to search surveys or statistical products for both public-use microdata files (PUMF) and public master files (http://www120.statcan.gc.ca/dli/e1/stu). It also allows the search of variables(http://www120.statcan.gc.ca/dli/e2/var).

The DLI team is pleased to announce that there have been further updates to the Nesstar search!

SEARCH TIPS!

Use Boolean operators (AND, +, OR, NOT, -) to expand or narrow your search results.
Note: the default search is AND, and Boolean operators must be capitalized.

Try using phrase search “” (i.e. “users of SLID data”) in your query.

To expand your search results, use truncation (i.e. immigr* -> immigration, immigrated, immigrating)

FEEDBACK!

We are always making improvements to the Nesstar search and welcome your feedback!

2014 Canadian Income Survey (CIS) PUMF

The anticipated release date for the 2014 Canadian Income Survey (CIS) PUMF is late-November, pending approval from the Microdata Release Committee.

Monday, September 26, 2016

HPV Vaccination Rates

Question

I have doctoral student here who’s researching HPV vaccination rates, but stats are pretty thin on the ground. I’ve checked PHAC’s site and have found a few useful items. Searching CIHI was less productive. I’ve also contacted individual health regions in the province to see if they collect immunization stats and would be willing to share them.

My questions are two:

1. Is there an updated version of the National Immunization Coverage Survey (the most recent one I’ve found is 2013)?

2. Are there other sources of immunization data that I’ve overlooked/don’t know about?

Answer

I see that the frequency of collection for the Childhood National Immunization Coverage Survey (CNICS) is every two years. I can confirm with subject matter if there is a 2015 reference period.

I have been able to find the following reference that may be of use on the National Advisory Committee on Immunization (NACI):

Tables
Table 5. Summary of evidence (published and unpublished) related to HPV9 vaccine

http://www.healthycanadians.gc.ca/publications/healthy-living-vie-saine/human-papillomavirus-9-valent-vaccine-update-recommendation-mises-a-jour-recommandations-papillome-humain-vaccin-nonavalent/index-eng.php#a7

Vaccine uptake in Canadian adults: Results from the 2014 adult National Immunization Coverage Survey (aNICS)

http://www.healthycanadians.gc.ca/publications/healthy-living-vie-saine/vaccine-coverage-adults-results-2014-resultats-couverture-vaccinale-adultes/index-eng.php

The 2014 aNICS was conducted by the Environics Research Group.

CNICS was collected in 2015. For the time being, there is no date set as for the release. It will not be before 2017.

Concordance SOC 2010 and NOC 2006


Question

I am wondering if there is a concordance for Standard Occupational Classification (SOC) 2010 (used by the US) and National Occupational Classification (NOC) 2006?

Answer

I am consulting the Concordances between classifications page available on the Statcan Website, and unfortunately do not see one from SOC 2010 to NOC 2006.

http://www.statcan.gc.ca/eng/concepts/concordances-classifications

I see:
Standard Occupational Classification (SOC)

Thursday, September 22, 2016

DLI EFT

The Data Liberation Initiative (DLI) program has reorganized its collection holdings and undertaking a renaming of the folder names in the file path structure on the EFT. Public Use Microdata Files (PUMFs) are now available in the MAD_PUMF_FMGD_DAM folder (navigate to top hierarchy to access) and organized in a bilingual structure, based on the survey record number and survey acronyms, as follows:

New structure
\2620_SFS_ESF
\3107_LFS_EPA
\3217CHS_ESC
\..
A folder directory (Readme-Key_Lisezmoi-clé.xls), please see attached, identifying what the survey acronym mean, is available in the folder of the new safe.

For more information, please consult the presentation material from the webinar on the EFT restructuring available on the DLI Training Repository.
https://cudo.carleton.ca/dli-training/4019

Wednesday, September 21, 2016

Tuition and Living Accommodation Costs for Full-time Students at Canadian Degree-granting Institutions (TLAC)

TLAC data for 2015- 2016 are now available on the EFT site.

The Tuition and Living Accommodation Costs for Full-time Students at Canadian Degree-granting Institutions (TLAC) survey was administered from April to July 2015 and the data cover the 2015-2016 academic year. Data are provided for the 111 institutions that represent the survey universe.

eft: /MAD_DLI_IDD_DAM/Root/other_autres/3123_TLAC_FSS/tuition-data_tlac-ver08.zip

2001 & 2006 Census in 2011 Boundaries

Question

I have a researcher who wishes to obtain census variables from the 2001 and 2006 census, adjusted for 2011 census boundaries (dissemination area & census tract level). She wants population and dwelling type.

I see that Geosuite can provide 2001 in 2006 and 2006 in 2011 for population by census tract, but (I think) that’s it. Am I missing any other available resource, or, can her request be produced on a custom basis?

Answer

You might want to look at SimplyMap. I believe it provides “adjusted” Census Data for 2001 and 2006 at 2011 boundaries.

Approaches to Educational Planning, Survey of (SAEP) - 2013


Question

I have a request from a researcher as to whether or not we will be receiving a PUMF for the 2013 Survey of Approaches to Educational Planning. And if so (fingers crossed), when.

Answer

“Please note that no PUMFS will be produced for 2013.”

The PUMF for the SAEP was last produced in 2002.


Friday, September 16, 2016

Licensing Question

Question

I’ve received a question from a researcher who’s in the final stages of submitting a paper for publication. As part of the submission, the journal is asking that the data used (obtained through the DLI) be either included with his manuscript or archived at a repository like Dryad.

My reading of the open data license tells me this is permissible, but I’d like to confirm that.


He used the DA-level census and NHS profiles.

Answer

While most standard data products available through the DLI (eg: boundary files, ICO, CBP) fall under the Open Licence, there are exceptions which are governed under their own licence agreements:

· Public Use Microdata Files (Appendix 1)
· Postal CodeOM data products (Appendix 2)
· Discharge Abstract Database sample files (Appendix 3)

Data products under these licence agreements cannot be shared with any person outside the licensee’s institution of authenticated users.

The results of this research may be shared, but not the raw data.


The DA-level NHS profile was a semi-custom creation for the DLI, and would fall under the Open Data Licence.

Wednesday, September 14, 2016

Income by household size by FSA for either 2006 Census or 2011 NHS


Question

Were there any products that provide income by household size by forward sortation area from either the 2006 Census or the 2011 National Household Survey? I haven't been able to find one, and wonder if it would be a special tabulation request.

Alternately, does the RDC Master File from either 2006 or 2011 include forward sortation area as a variable? If it did, the information could be derived.

Answer

Unfortunately, the data you are looking for is not available in our standard product line at the FSA geographic level. This data is available as a custom data tabulation from the nearest regional office.

To answer your second question - The Masterfile for the 2011 NHS and 2006 Census both include the variable FSANAME - Forward Sortation Areas © Code.

New ICS study: Overqualification, skills and job satisfaction

Overqualification, skills and job satisfaction
by Sébastien LaRochelle-Côté and Darcy Hango

Insights on Canadian Society

Based on a self-reported measure of overqualification, this article examines the association 
between overqualification and skills among workers aged 25 to 64 with a university degree, using data from the 2012 Programme for the International Assessment of Adult Competencies (PIAAC). This article also examines the extent to which overqualified workers are dissatisfied with their jobs. Overqualified workers are defined in this study as university-educated workers who reported that they were in a job requiring no more than a high school education.

To access the study released today:

New files on Statistics Canada Nesstar

We are pleased to inform you that the following are now available on the Statistics Canada Nesstar WebView site (http://dli-idd-nesstar.statcan.gc.ca/webview).

PUMFs

Canadian Community Health Survey (CCHS), 2013-2014 - Annual Component
Labour Force Survey (LFS), 2015 – January
Labour Force Survey (LFS), 2015 – February
Labour Force Survey (LFS), 2015 – March
Labour Force Survey (LFS), 2015 – April
Labour Force Survey (LFS), 2015 – May
Labour Force Survey (LFS), 2015 – June
Labour Force Survey (LFS), 2015 – July
Labour Force Survey (LFS), 2015 – August
Labour Force Survey (LFS), 2015 – September
Labour Force Survey (LFS), 2015 – October
Labour Force Survey (LFS), 2015 – November
Labour Force Survey (LFS), 2015 – December

And more to come!

To access the microdata housed in the Research Data Centres (RDCs), researchers must submit a project proposal to the Social Sciences and Humanities Research Council (SSHRC) and Statistics Canada.





Monday, September 12, 2016

Divorce rates by year of marriage and by province

Question
A researcher found CANSIM Table 101-6510 (divorce rates by year of marriage and by province), but it is available for 2004 only. She would like the same information for 1988-1991.

I haven’t been able to track down any other years in CANSIM – was it really only done for that one year or is it possible to get it for the earlier years?

Answer 1
There are some historical tables, even though they are very difficult to find as there are no dates given in the CANSIM titles L, see:
http://www5.statcan.gc.ca/subject-sujet/result-resultat?pid=40000&id=40001&lang=eng&type=ARRAY&pageNum=1&more=0

Table 053-0002
Vital statistics, divorces, *Terminated* annual (number), 1970-2003

Table 075-0014 1
Historical statistics, population, by marital status, age group and sex, *Terminated*, 1871-1971
every 10 years (persons)

It will be interesting to see what other tables that subject matter identifies.

Answer 2
Subject matter has clarified that the information for those years (1988 to 1991) is available in the older publications on marriage. 

Followup Response
Thanks but unfortunately I’m looking for the divorce rate, not marriages.

I did find the publication Divorce – Shelf Tables (84-213) which has a lot of tables for a variety of different variables, but not year of marriage. It also states that custom tabulations are available, so maybe this will be the way to go.

Request for IMDB custom tab

Question
I have a researcher who is interested in getting some custom tabulations from the IMDB. He needs longitudinal micros level data on individual refugees older than 19 years of age for approximately 5 years since landing.

In order to assist his request, is it possible to get a list of the IMDB variables?

Answer
Below is the response we have received from subject matter:

“Unfortunately, IMDB micro-records are not released and all aggregate statistics are subject to suppression and rounding, in order to prevent the disclosure of identifiable data.

If the researcher wishes to purchase a custom tabulation of aggregate data, please put him/her in touch with us directly.

Followup Question
If the researcher proceeds with the custom tab, will that data then be made available to all DLI participants? It was my understanding that this is the case but I'm not clear on the process. Does the researcher have to release the data (to me?) for distribution? 

Followup Answer
Custom tabs fall under the Open Licence Agreement, for more information please see:


  • Statistics Canada Open Licence Agreement
  • Frequently Asked Questions
    • The Open Licence applies to both standard and custom products and services with the exception of Statistics Canada's postal products (see list) and Public Use Microdata Files (PUMFs).
However, it would be at the researcher’s discretion to share the outputs with us.

Friday, September 9, 2016

Inquiry re Longitudinal & International Survey of Adults (LISA)

Question

I have a graduate student looking to access both waves 1 & 2 of the Longitudinal & International Survey of Adults (LISA) data.

I'm not seeing where there are PUMFs available, nor anything in the RDC. Are there data available, or plans to make them accessible either in PUMF or restricted access?

Answer

At this time because it is a longitudinal survey there will not be any PUMFs. All data is accessible via the RDCs

The data is available through the RDCs:
http://www.statcan.gc.ca/eng/rdc/data

There is also a webinar on LISA that the DLI previously hosted, you may be interested in viewing the presentation materials available here
https://cudo.carleton.ca/dli-training/3746

Thursday, September 8, 2016

DLI EFT

The Data Liberation Initiative (DLI) program has reorganized its collection holdings and undertaking a renaming of the folder names in the file path structure on the EFT. Public Use Microdata Files (PUMFs) are now available in the MAD_PUMF_FMGD_DAM folder (navigate to top hierarchy to access) and organized in a bilingual structure, based on the survey record number and survey acronyms, as follows:

New structure
\2620_SFS_ESF
\3107_LFS_EPA
\3217CHS_ESC
\..
A folder directory (Readme-Key_Lisezmoi-clé.xls), identifying what the survey acronyms mean, is available in the folder of the new safe.

DLI Update: TSRC PUMF 2015


Travel Survey of Residents of Canada: Public Use Microdata File, 2015

The microdata file contains records which relate to the activities of Canadians travelling in Canada; origin and destination; volumes; nights away from home; length of stay; type of transportation; purpose of trip; accommodation used; expenditures by categories; and demographic characteristics. Included are the complete Canada microdata file on person-trips, household trips, person-nights and reallocated expenditures.

EFT File path: /MAD_PUMF_FMGD_DAM/Root/3810_TSRC_EVRC/2015

DLI Update: 2014-2015 Sample DADs files

New samples files from the Discharge Abstract Database (DAD) Research Analytic Files for 2014-2015 are now available on the DLI EFT!

Through the DAD sample files, researchers can
* Become familiar with the structure and content of DAD data;
* Explore relationships among data elements;
* Perform preliminary analyses and data mining; and
* Test hypotheses.

DLI EFT:
/MAD_DLI_CIHI/Root/discharge-abstract-database-2014-15

Prevalence and Severity of Back Pain During Pregnancy

Question:

I have a grad student whose research involves the prevalence and severity of back pain during pregnancy. We can find chronic pain / chronic conditions (Health Indicators, CCHS, etc.), but is there a combination of resources that will allow her to make that correlation?

Answer:
Have you consulted PHAC? StatCan conducted the Maternity Experiences Survey (MES) as part of the Canadian Perinatal Surveillance System of the Public Health Agency of Canada who sponsored the survey.

They have results on their website:

The Canadian Maternity Experiences Survey

http://www.phac-aspc.gc.ca/rhs-ssg/survey-eng.php

I found tables that reported back pain in postpartum, not during pregnancy unfortunately.

Maternal and Infant Health

http://www.phac-aspc.gc.ca/rhs-ssg/


Travel Survey of Residents of Canada

Question

I was looking for the PUMF files for the 2012 TSRC and they don't appear to be in the /MAD_PUMF_FMGD_DAM/Root/3810_TSRC_EVRC/2012 folder.

Also, for the 2011, 2012 and 2013 TSRC, the Standard and Non-Standard Tables are only available in French. Are they available in English?

Answer

The 2011, 2012 and 2013 TSRC English Standard and Non-Standard Tables as well as the PUMF files for the 2012 TSRC are now available.

EFT location: /MAD_PUMF_FMGD_DAM/Root/3810_TSRC_EVRC/2012