Question:
I’m help a graduate-level class that is working on a feasibility study for a new downtown grocery store. The instructor would like to find things like market share, customer numbers, sales by industry, and so on.
Apart from location counts by NAICS code and employee size at the CMA-level, everything we’ve located is national or provincial.
Are there sources for more detailed information, apart from CDER or custom tabs?
Answer:
You may find some of the publications from the Centre for the Study of Commercial Activity at Ryerson useful.
I don’t know if this helps, but for sales data, employee counts and other company/industry data one place we refer students to is the D&B Million Dollar Database. You can search by SIC (e.g., 54110000 for grocery stores) and limit by geography (e.g., Manitoba / Winnipeg). Doesn’t provide all the data you want in your case, of course.
Thursday, October 26, 2017
Area of 2006 Dissemination Area
Question:
I am assisting a researcher who is looking to determine the area of 2006 Dissemination Areas. Does this exist as a statistical product?
I noticed that the shapefiles have a generated “shape_area” field and am wondering if anyone knows if this field is reliable, or if it poses a Modifiable Areal Units Problem (MAUP)?
Answer:
If you don't want to use GIS software, I'm pleased to say that, once again, GeoSuite comes to the rescue. There's a DAarea field in GeoSuite that gives area in km2. According to the help file "Land area data are unofficial and are provided for the sole purpose of calculating population density."
I am assisting a researcher who is looking to determine the area of 2006 Dissemination Areas. Does this exist as a statistical product?
I noticed that the shapefiles have a generated “shape_area” field and am wondering if anyone knows if this field is reliable, or if it poses a Modifiable Areal Units Problem (MAUP)?
Answer:
If you don't want to use GIS software, I'm pleased to say that, once again, GeoSuite comes to the rescue. There's a DAarea field in GeoSuite that gives area in km2. According to the help file "Land area data are unofficial and are provided for the sole purpose of calculating population density."
Thursday, October 12, 2017
Tuition Costs by Institution
Question:
A researcher is looking for recent (2016/17 and 2017/18) data from Tuition and Living Accommodation Costs (TLAC). Stats Can has released summary tables from the latest survey, but they only list costs by province, and she needs it by institution. I was able to locate data from 1993-2015 in Odesi but nothing from the past two years. Are there plans to release a PUMF for the latest years, and if so, when?
Answer 1:
You might check out: https://www.univcan.ca/universities/facts-and-stats/tuition-fees-by-university/ … I noted that the source is Statistics Canada.
Answer 2:
there are no PUMFs planned for TLAC data. From subject matter: “We don’t produce any PUMF for TLAC, only standard tables.”
Now, the years your request caught my eye. I just released the 2017/18 data* last week and sent a notification to the list. Odesi are able to extract the tables for their users and release through their channels. The data has been available since October 5th 2017 on the FTP site.
*Tuition and Living Accommodation Costs (TLAC) for 2017-18 (ver09) are now available on the EFT site.
EFT: /MAD_DLI_IDD_DAM/root/other_autres/3123_TLAC_FSS/
A researcher is looking for recent (2016/17 and 2017/18) data from Tuition and Living Accommodation Costs (TLAC). Stats Can has released summary tables from the latest survey, but they only list costs by province, and she needs it by institution. I was able to locate data from 1993-2015 in Odesi but nothing from the past two years. Are there plans to release a PUMF for the latest years, and if so, when?
Answer 1:
You might check out: https://www.univcan.ca/universities/facts-and-stats/tuition-fees-by-university/ … I noted that the source is Statistics Canada.
Answer 2:
there are no PUMFs planned for TLAC data. From subject matter: “We don’t produce any PUMF for TLAC, only standard tables.”
Now, the years your request caught my eye. I just released the 2017/18 data* last week and sent a notification to the list. Odesi are able to extract the tables for their users and release through their channels. The data has been available since October 5th 2017 on the FTP site.
*Tuition and Living Accommodation Costs (TLAC) for 2017-18 (ver09) are now available on the EFT site.
EFT: /MAD_DLI_IDD_DAM/root/other_autres/3123_TLAC_FSS/
Wednesday, October 11, 2017
CCHS Documentation for 2014
Question
I have received a request for the following Canadian Community Health Survey documents:
CCHS 2014 Derived Variables Documentation
Canadian Community Health Survey – Errata (updated June 2015)
These are both listed on this page: http://www23.statcan.gc.ca/imdb-bmdi/document/3226_D75_T1-V4-eng.htm
I am presuming that the Derived Variables Documentation is the same as the Derived Variable (DV) Specifications document that I found on the EFT and, but would like confirmation of that.
Answer
You are correct, the Derived Variable specs you found on the EFT is the correct document. As for the errata, I am placing the CCHS 2015 errata on the EFT site under the documentation folder.
As per subject matter: “Please note that this errata does not replace the existing errata for the 2000-2014 CCHS, rather it is an additional errata. Going forward, all errata items for 2015 onward will appear in this second document. This document will be updated on an ongoing basis. Please be sure to keep both the 2000-2014 and 2015+ documents.”
I have received a request for the following Canadian Community Health Survey documents:
CCHS 2014 Derived Variables Documentation
Canadian Community Health Survey – Errata (updated June 2015)
These are both listed on this page: http://www23.statcan.gc.ca/imdb-bmdi/document/3226_D75_T1-V4-eng.htm
I am presuming that the Derived Variables Documentation is the same as the Derived Variable (DV) Specifications document that I found on the EFT and
Answer
You are correct, the Derived Variable specs you found on the EFT is the correct document. As for the errata, I am placing the CCHS 2015 errata on the EFT site under the documentation folder.
As per subject matter: “Please note that this errata does not replace the existing errata for the 2000-2014 CCHS, rather it is an additional errata. Going forward, all errata items for 2015 onward will appear in this second document. This document will be updated on an ongoing basis. Please be sure to keep both the 2000-2014 and 2015+ documents.”
Friday, September 15, 2017
NHS 2011 - Commuter Flow Question
Question:
A couple of years ago I asked a question about some place of work information from the NHS that seemed to indicate a coding error. People whose residence did not seem to make sense were seen to be working in the Village of Gagetown. Of course, it turned out that there was a coding error based on respondents entries, and that the place of work was actually [CFB] Gagetown. I have another such question from the same researcher.
In looking through the 2011 commuter flow table (99-012-x2011032) for the Chipman/Minto area, he noticed that 45 people are listed as having their place of residence in Red Bank First Nation (Red Bank 4) and their place of work in Chipman Parish. Given that Red Bank First Nation is more than an hour's drive to Chipman Parish, and given that there's also an area in Chipman Parish called Redbank, he's wondering what he can count on with respect to this data. He's aware that "place of residence" is the location where respondents are enumerated and does not necessarily represent where respondents were at the time of the NHS; however, given his knowledge of the area he thought the numbers didn't seem realistic and that it might be possible that an error had occurred. He's not sure, though, so he wanted to see if we could double check on this.
A couple of years ago I asked a question about some place of work information from the NHS that seemed to indicate a coding error. People whose residence did not seem to make sense were seen to be working in the Village of Gagetown. Of course, it turned out that there was a coding error based on respondents entries, and that the place of work was actually [CFB] Gagetown. I have another such question from the same researcher.
In looking through the 2011 commuter flow table (99-012-x2011032) for the Chipman/Minto area, he noticed that 45 people are listed as having their place of residence in Red Bank First Nation (Red Bank 4) and their place of work in Chipman Parish. Given that Red Bank First Nation is more than an hour's drive to Chipman Parish, and given that there's also an area in Chipman Parish called Redbank, he's wondering what he can count on with respect to this data. He's aware that "place of residence" is the location where respondents are enumerated and does not necessarily represent where respondents were at the time of the NHS; however, given his knowledge of the area he thought the numbers didn't seem realistic and that it might be possible that an error had occurred. He's not sure, though, so he wanted to see if we could double check on this.
Answer:
Thank you for your feedback and observations of the 2011 National Household Survey (NHS) data on place of work (commuting flows).
Aboriginal reserves and settlements have always been a challenge for the automated and manual coding processes in place of work. Some have names that are similar, or identical except for numbers associated with them. We are also dependent on the respondent to fill out their place of work information as completely and accurately as possible. We try to do the best we can at getting them coded correctly.
After investigating the data, it appears as if the records in question should probably have been associated with Red Bank 4 and not Chipman. Unfortunately the processes in place for that cycle did not catch this particular issue.
We continue to work on improving our POW coding and verification processes, and hopefully for 2016 and future cycles you will see such improvements reflected in the data.
Questions about CIHI Discharge Abstract Database Coding
Question:
I was reviewing the 2015-2016 Status variables (ST_AT_1 through _20) on the clinical file, checking frequencies from before and after recoding those variables. I discovered that there were a large number of status codes which were missed by my recode syntax. I’ve looked at the online Canadian Coding Standards for ICD-10-CA and CCI (https://secure.cihi.ca/estore/productFamily.htm?pf=PFC2785&lang=en&media=0), the DAD abstracting manual (and for that matter, all of the other documentation files received with DAD), and haven’t been able to find a list of the possible field contents.
Is there a complete list of status attribute codes (I hope that I’ve not simply missed it)?
I’m not sure where to find explanations of codes FE, FY, JU, LY, ML, MR, PI, RY, SC, and UN.
Answer:
A CCI status code list that was provided by CIHI. They have indicated it was pulled from Appendix C of the v2015 CCI folio product.
The Folios are essentially electronic, interactive versions of the Manuals so the information contained in them should be the same. Unfortunately we cannot provide the client with a copy of the CCI Folio as it’s a paid product and there are licencing agreements etc. Hospital medical record departments may have a copy they can borrow.
Follow-Up Question:
Would it be possible to put a copy of the Word document that you received from CIHI in the documentation folder for the DAD? It could (should) be annotated to indicate that:
I was reviewing the 2015-2016 Status variables (ST_AT_1 through _20) on the clinical file, checking frequencies from before and after recoding those variables. I discovered that there were a large number of status codes which were missed by my recode syntax. I’ve looked at the online Canadian Coding Standards for ICD-10-CA and CCI (https://secure.cihi.ca/estore/productFamily.htm?pf=PFC2785&lang=en&media=0), the DAD abstracting manual (and for that matter, all of the other documentation files received with DAD), and haven’t been able to find a list of the possible field contents.
Is there a complete list of status attribute codes (I hope that I’ve not simply missed it)?
- I’m missing meanings for codes: D1, DX, PA, PB, PC, RA, RB, RC, and UN.
- I have meanings for codes: 0, B, C, CR, D, DP, DS, E, I , M1, M3, M4, N, N2, N3, N4, N5, N6, P, Q, R, S, S2, TM, U, UR, V, and Z. (e.g., U – Initial consultation)
- Are there still more status attribute codes that I haven’t encountered yet?
I’m not sure where to find explanations of codes FE, FY, JU, LY, ML, MR, PI, RY, SC, and UN.
Answer:
A CCI status code list that was provided by CIHI. They have indicated it was pulled from Appendix C of the v2015 CCI folio product.
The Folios are essentially electronic, interactive versions of the Manuals so the information contained in them should be the same. Unfortunately we cannot provide the client with a copy of the CCI Folio as it’s a paid product and there are licencing agreements etc. Hospital medical record departments may have a copy they can borrow.
Follow-Up Question:
Would it be possible to put a copy of the Word document that you received from CIHI in the documentation folder for the DAD? It could (should) be annotated to indicate that:
- the Status list corresponds to variables ST_AT_1, ST_AT_2, …, ST_AT_20 in the DAD excerpt files
- the Location list corresponds to variables LC_AT_1, LC_AT_2, …, LC_AT_20 in the DAD excerpt files
- the Extent list does not correspond to any variables in the DAD excerpt files
Follow-Up Answer:
I’ve looked into this further and the ICD-10-CA/CCI has four volumes in total:
- Volume 1—International Statistical Classification of Diseases and Related Health Problems, Tenth Revision, Canada (ICD-10-CA) - Tabular List
- Volume 2—International Statistical Classification of Diseases and Related Health Problems, Tenth Revision, Canada (ICD-10-CA) - Alphabetical Index
- Volume 3—Canadian Classification of Health Interventions (CCI) - Tabular List
- Volume 4—Canadian Classification of Health Interventions (CCI) – Alphabetical Index
Typically, for the DLI data cuts, we only include the Tabular lists (Volumes 1 & 3). As to why we only release the Tabular lists, I can’t say - only that this is what was being done since I’ve been with the team.
Appendix C is provided in Volume 4, as well as appearing in the electronic Folio mentioned earlier, which is why it didn’t turn up in your search.
I just received volume 2 and 4 of the CCI/ICD documentation. They have been placed in the CIHI safe located here: /MAD_CIHI_ICIS_DAM/Root/discharge-abstract-database-2015-16/Other_documents/ICD10CA CCI v2015/EN/
Tuesday, September 12, 2017
2011 and 2014 Public Service Employees Survey (PSES)
Question
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.
Response
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
infostats@statcan.gc.ca
http://www.statcan.gc.ca/daily-quotidien/150205/dq150205f-eng.htm
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
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.
Response
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
infostats@statcan.gc.ca
http://www.statcan.gc.ca/daily-quotidien/150205/dq150205f-eng.htm
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
Subscribe to:
Posts (Atom)