Question:
I’m looking for historical information regarding hospital staffing/expenditures by province and the Annual Return of Health Care Facilities—Hospitals seems to fit the bill. This survey was run by Statistics Canada from 1932 to the mid 1990s when CIHI took over but I can’t find it. I see only the summary stub here: http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=3208
Any ideas as to where I can access the historical data (which CIHI doesn’t have) or if there’s anything else that might fit the bill?
It appears this may be a print publication. Publications Canada only has one digitized although they have several iterations of the instructions available.
See http://publications.gc.ca/collections/collection_2017/statcan/83-233/CS83-233-1985.pdf
Does Statistics Canada have the print run of this available—hopefully in electronic format? Was this part of the StatsCan Library collection that was digitized?
Answer:
The Library has been able to provide us with the following:
PDFs of Annual return of hospitals, hospital indicators (82-233) from 1976-1983 can be found here:
http://publications.gc.ca/site/eng/9.811526/publication.html
Regarding Annual Return of Health Care Facilities, I could only find Selected tables from annual return of special care facilities within our catalogue. The digitized versions are available here:
http://publications.gc.ca/site/eng/9.863145/publication.html
However, an earlier version of this publication is Mental health statistics. Volume III, Institutional facilities, services and finances:
http://publications.gc.ca/site/eng/9.862004/publication.html
Later publications (into the 1990s), under the name Residential care facilities can be found here:
http://publications.gc.ca/site/eng/search/search.html?st=1&ssti=&e=0&f=0&adoof=0&ast=Residential+care+facilities&cnst=
In the catalogue records for these publications, “Continued by” and “Continues” can be useful in determining how the publications have changed names over time. Also, there is not always a direct link in the StatCan Library catalogue to the PDF, so it is worth it to search Publications.gc.ca for the digital version.
Wednesday, November 7, 2018
2016 Census Master File
Question:
Has a synthetic file been created for the 2016 Census master file? If not, is there a date for it?
I can't access the DLI Nesstar right now but I don't recall seeing it there last week. However, I don't see anything for the 2016 Census through the variable search at https://www120.statcan.gc.ca/dli/e1/stu?fq= either.
Answer:
Unfortunately Census does not create synthetic files, however the PUMF will be available this winter!
Has a synthetic file been created for the 2016 Census master file? If not, is there a date for it?
I can't access the DLI Nesstar right now but I don't recall seeing it there last week. However, I don't see anything for the 2016 Census through the variable search at https://www120.statcan.gc.ca/dli/e1/stu?fq= either.
Answer:
Unfortunately Census does not create synthetic files, however the PUMF will be available this winter!
Uniform Crime Reporting Survey PUMF
Question:
I’ve been asked if there is a PUMF for the Uniform Crime Reporting Survey. I don’t think so, as I’ve been through the EFT and Nesstar and don’t see anything, but figured I should double-check with the experts.
Answer:
You are correct – unfortunately a PUMF has not been created for the Uniform Crime Reporting Survey.
I’ve been asked if there is a PUMF for the Uniform Crime Reporting Survey. I don’t think so, as I’ve been through the EFT and Nesstar and don’t see anything, but figured I should double-check with the experts.
Answer:
You are correct – unfortunately a PUMF has not been created for the Uniform Crime Reporting Survey.
Tuesday, November 6, 2018
Housing for Adults with Developmental Disabilities
Question:
Can anyone help me with this request?
“I initially wanted to find some data sets pertaining to the housing situation of adults who are disabled, particularly for those who have developmental disabilities, but have yet to find any relevant literature or surveys. If there were to be any code books or other resources that you could suggest, that would be greatly appreciated.”
Answer from DLI List:
CMHC published a Research Insight: Housing Conditions of Persons with Disabilities [https://www.cmhc-schl.gc.ca/en/data-and-research/publications-and-reports/research-insight-housing-conditions-persons-disabilities] which references the Canadian Survey on Disability and provides some summary statistics. The associated data tables I was able to find are from 2012 and don’t reference housing specifically. This is a survey run on behalf of Employment and Social Development Canada—not sure if that means anything regarding access.
Answer from Subject Matter:
“CSD 2012 does have some housing variables included:
DDIS_FL (disability status) and DDEV_FL (Developmental disability indicator); type of in-residence aids used or needed and reasons for unmet needs (such as walk-in bath/shower, access ramp, widened doorways/hallways, lowered counters, etc. (AAD variables series); and Census linked housing variables (BEDRM-number of bedrooms; BUILT-period of construction of dwelling; GROSRT-gross rent; OMP-owner’s major payment; RCOND-tenure-condominium; Rooms-number of rooms; RPAIR-condition of dwelling; SUBSIDY-subsidized housing; TENUR-Tenure (owned or rented).)
CSD 2017 will be released at the end of the month and will include many more housing indicators. Including core housing needs and shelter-cost-to-income ratio. Codebooks will be available in the new year.
I found one Statistics Canada study on our website that may be of interest:
82-003 - Health reports
Needs for mobility devices, home modifications and personal assistance among Canadians with disabilities
by Edward M. Giesbrecht, Emma M. Smith, W. Ben Mortenson and William C. Miller”
Can anyone help me with this request?
“I initially wanted to find some data sets pertaining to the housing situation of adults who are disabled, particularly for those who have developmental disabilities, but have yet to find any relevant literature or surveys. If there were to be any code books or other resources that you could suggest, that would be greatly appreciated.”
Answer from DLI List:
CMHC published a Research Insight: Housing Conditions of Persons with Disabilities [https://www.cmhc-schl.gc.ca/en/data-and-research/publications-and-reports/research-insight-housing-conditions-persons-disabilities] which references the Canadian Survey on Disability and provides some summary statistics. The associated data tables I was able to find are from 2012 and don’t reference housing specifically. This is a survey run on behalf of Employment and Social Development Canada—not sure if that means anything regarding access.
Answer from Subject Matter:
“CSD 2012 does have some housing variables included:
DDIS_FL (disability status) and DDEV_FL (Developmental disability indicator); type of in-residence aids used or needed and reasons for unmet needs (such as walk-in bath/shower, access ramp, widened doorways/hallways, lowered counters, etc. (AAD variables series); and Census linked housing variables (BEDRM-number of bedrooms; BUILT-period of construction of dwelling; GROSRT-gross rent; OMP-owner’s major payment; RCOND-tenure-condominium; Rooms-number of rooms; RPAIR-condition of dwelling; SUBSIDY-subsidized housing; TENUR-Tenure (owned or rented).)
CSD 2017 will be released at the end of the month and will include many more housing indicators. Including core housing needs and shelter-cost-to-income ratio. Codebooks will be available in the new year.
I found one Statistics Canada study on our website that may be of interest:
82-003 - Health reports
Needs for mobility devices, home modifications and personal assistance among Canadians with disabilities
by Edward M. Giesbrecht, Emma M. Smith, W. Ben Mortenson and William C. Miller”
Monday, November 5, 2018
Census Microdata
Question:
I notice that Census of Populations PUMFs are no longer being produced and that the DLI Nesstar site has no metadata for Census of Population Master Files since 2006.
For 2011 and 2016 are there any Census products available to the DLI that aren't also available through the public-facing StatCan site? In other words, are paid, custom tabs the only way for DLI members to access Census data that isn't on the StatCan site?
Answer from DLI:
If I’m understanding your question correctly, I think you got caught as I did – the 2011 Census variables are with the NHS PUMF. In, you’ll the NHS under Social Surveys. I learned my lesson a couple of years ago!
PUMFs for 2016 are forthcoming in 2019 (see https://www.statcan.gc.ca/eng/dli/prod_date).
Can’t speak to the Master File documentation, though.
Answer from Subject Matter:
Unfortunately the Census 2011 and 2016 Masterfiles are unavailable at the moment, however we are evaluating how to make them accessible.
I notice that Census of Populations PUMFs are no longer being produced and that the DLI Nesstar site has no metadata for Census of Population Master Files since 2006.
For 2011 and 2016 are there any Census products available to the DLI that aren't also available through the public-facing StatCan site? In other words, are paid, custom tabs the only way for DLI members to access Census data that isn't on the StatCan site?
Answer from DLI:
If I’m understanding your question correctly, I think you got caught as I did – the 2011 Census variables are with the NHS PUMF. In
PUMFs for 2016 are forthcoming in 2019 (see https://www.statcan.gc.ca/eng/dli/prod_date).
Can’t speak to the Master File documentation, though.
Answer from Subject Matter:
Unfortunately the Census 2011 and 2016 Masterfiles are unavailable at the moment, however we are evaluating how to make them accessible.
Friday, November 2, 2018
Location of Work Question + Journey to Work Question
Question:
QUESTION 1
One of our researchers would like the number of jobs (including for workers who work at home) by census tract by location of work for all of Canada. They were told that they might be able to get this through the DLI. Because the researcher needs the location of work and not the location of the residence of the worker, the publicly available census data is no help.
I remember that a subject matter division shared a spreadsheet containing jobs by NAICS for DAs with us (and we were all very happy and grateful). But I can't seem to find a count of jobs by census tract by location of work. Am I missing something?
QUESTION 2
The same researcher would also love to have a table of distance from work to home by Census Tract, with extra bonus points if the "mode of commuting" variable is in there. Essentially, something like the default view of this data table (with no need for the "commuting duration", "time leaving for work", "age", or "sex" variables), but by CT instead of by CMA.
I don't suppose there's a table out there that I've missed that the researcher could use? The "Distance from home to work" variable isn't available in the census profiles.
Answer from DLI List:
Looks like there are some Census, Place of Work custom tabs available through the Map and Data Library, UofT: https://dataverse.scholarsportal.info/dataverse/MDL?q=place+of+work
Not sure if that covers what you need though.
And, in ODESI there are commuting flows for 2006 CTs here: http://odesi2.scholarsportal.info/documentation/CENSUS/2006/TBT/B2020/DOCS/cenb06customtab.html
Recently, I think someone in the community asked about this data for 2016 because it was heavily written about in the media. It would be great to get a hold of the custom data if it exists or could be made.
Answer from Subject Matter:
I’ve spoken with subject matter and unfortunately information at the CT level is not publicly available (in standard products) for many variables, including journey to work given its precision. Because of this, the information will only be obtainable through a custom tabulation.
QUESTION 1
One of our researchers would like the number of jobs (including for workers who work at home) by census tract by location of work for all of Canada. They were told that they might be able to get this through the DLI. Because the researcher needs the location of work and not the location of the residence of the worker, the publicly available census data is no help.
I remember that a subject matter division shared a spreadsheet containing jobs by NAICS for DAs with us (and we were all very happy and grateful). But I can't seem to find a count of jobs by census tract by location of work. Am I missing something?
QUESTION 2
The same researcher would also love to have a table of distance from work to home by Census Tract, with extra bonus points if the "mode of commuting" variable is in there. Essentially, something like the default view of this data table (with no need for the "commuting duration", "time leaving for work", "age", or "sex" variables), but by CT instead of by CMA.
I don't suppose there's a table out there that I've missed that the researcher could use? The "Distance from home to work" variable isn't available in the census profiles.
Answer from DLI List:
Looks like there are some Census, Place of Work custom tabs available through the Map and Data Library, UofT: https://dataverse.scholarsportal.info/dataverse/MDL?q=place+of+work
Not sure if that covers what you need though.
And, in ODESI there are commuting flows for 2006 CTs here: http://odesi2.scholarsportal.info/documentation/CENSUS/2006/TBT/B2020/DOCS/cenb06customtab.html
Recently, I think someone in the community asked about this data for 2016 because it was heavily written about in the media. It would be great to get a hold of the custom data if it exists or could be made.
Answer from Subject Matter:
I’ve spoken with subject matter and unfortunately information at the CT level is not publicly available (in standard products) for many variables, including journey to work given its precision. Because of this, the information will only be obtainable through a custom tabulation.
Historical Cause of Death Stats for NS and ON
Question:
I recently received this from a faculty member:
___
"I am looking for aggregated cause of death statistics for Nova Scotia
and Ontario. I am interested in the number of homicides (each year) for
both Nova Scotia and Ontario, which is recorded as a type of cause of
death (among other causes). I am trying to collect the data on an annual
basis for every available year (i.e. likely sometime in the early 1900s
until the most recent year available).
For Nova Scotia, I was given data collected by a local historian for
1749-1908. I was told by him that the data should be available beginning
in 1909. I have found the following site, which suggests that data are
available for select Canadian provinces beginning in 1920
(http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=3233).
However, I don’t know how/where to access these data, and I still
require data from 1909-1919.
Although my current focus is Nova Scotia, I will eventually also collect
the same data for Ontario."
___
Would an extracts from the Vital Statistics - Death database he refers
to be a custom tab? if so, could you give me the necessary contact
information so that he can negotiate the order?
Answer:
Here is the response we've received from subject matter:
"I can say for certain we don't have anything in our databases that go back that far. I'm attaching a PDF [https://www150.statcan.gc.ca/n1/pub/11-516-x/sectionz/4147446-eng.htm] that has a table on homicide charges and dispositions (not incidents that way we count them nowadays), though I don't know if it will be of much utility since the counts don't break down by Province. That said, if the DLI could use with Canada level data, please consult page 33 of this document."
I recently received this from a faculty member:
___
"I am looking for aggregated cause of death statistics for Nova Scotia
and Ontario. I am interested in the number of homicides (each year) for
both Nova Scotia and Ontario, which is recorded as a type of cause of
death (among other causes). I am trying to collect the data on an annual
basis for every available year (i.e. likely sometime in the early 1900s
until the most recent year available).
For Nova Scotia, I was given data collected by a local historian for
1749-1908. I was told by him that the data should be available beginning
in 1909. I have found the following site, which suggests that data are
available for select Canadian provinces beginning in 1920
(http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=3233).
However, I don’t know how/where to access these data, and I still
require data from 1909-1919.
Although my current focus is Nova Scotia, I will eventually also collect
the same data for Ontario."
___
Would an extracts from the Vital Statistics - Death database he refers
to be a custom tab? if so, could you give me the necessary contact
information so that he can negotiate the order?
Answer:
Here is the response we've received from subject matter:
"I can say for certain we don't have anything in our databases that go back that far. I'm attaching a PDF [https://www150.statcan.gc.ca/n1/pub/11-516-x/sectionz/4147446-eng.htm] that has a table on homicide charges and dispositions (not incidents that way we count them nowadays), though I don't know if it will be of much utility since the counts don't break down by Province. That said, if the DLI could use with Canada level data, please consult page 33 of this document."
Subscribe to:
Posts (Atom)