Answer:
The Job Vacancy Rate (JVR) survey only began in early 2015. There wasn’t any JVR prior to this data.
Thursday, April 26, 2018
Job Vacancy Rates
Question:A faculty member is looking for job vacancy rates from 2001 to 2017 for nursing care facilities, community care facilities for the elderly, and home health care facilities based on their respective NAICS codes. The closest CANSIM table I have come across is 285-0002, but it doesn’t go earlier than 2015. Is it possible to get access to quarterly data from this table earlier than 2015 and perhaps at a more detailed NAICS level?
Tuesday, April 24, 2018
National Ambulatory Care Reporting System (NACRS) database
Question:
I just received the following request and was wondering if anyone knew if there is free access to this database.
“My students need to access data from the National Ambulatory Care Reporting System (NACRS) database that is maintained by the Canadian Institute for Health Information.”
I just received the following request and was wondering if anyone knew if there is free access to this database.
“My students need to access data from the National Ambulatory Care Reporting System (NACRS) database that is maintained by the Canadian Institute for Health Information.”
Answer:
Some NACRS reports are available for free at https://apps.cihi.ca/mstrapp/asp/Main.aspx. I believe some of them can be customized a bit via the web app.
Otherwise, grad students can request access via the special grad student data access program - unsure if there's an equivalent program for staff/faculty-level researchers. I was told in an earlier request that more detailed, customized data requests would have to go through data request program at https://www.cihi.ca/en/access-data-and-reports/make-a-data-request (cost-recovery).
Monday, April 16, 2018
Canadian university tuition fees for international students
Question:
I'm now doing a project analyzing Canadian university tuition fees for international students, I already got some data from CANSIM Table 477-0023 and 477-0024 while I`m still not able to retrieve data in year 2000 & 2005. Just wondering, if possible, could you please guide me to find those missing data? (To be more specific, I need data for these two years describing weighted average tuition fees for international students, by province, and including undergraduate & graduate levels separately).
Answer 1:
You might want to try the CAUT almanacs:
https://www.caut.ca/latest/publications/almanac
They do have provincial averages for both undergraduate and graduate students, though I haven’t checked all of the years.
Unfortunately, though, the online statistics begin at 2002 (although they may have earlier years in the 2002 edition).
Answer 2:
Table 9 in TLAC includes weighted average tuition fees for full-time undergrad and grad students, domestic and international, from 1972 forward.
Answer from Subject Matter:
There are two templates of products that have weighted average tuition. Each file is $150, or $350 total. I think they should have all the information that the client wants. Please let me know if the client is interested and I will send you the catalogue number and the actual products.
I'm now doing a project analyzing Canadian university tuition fees for international students, I already got some data from CANSIM Table 477-0023 and 477-0024 while I`m still not able to retrieve data in year 2000 & 2005. Just wondering, if possible, could you please guide me to find those missing data? (To be more specific, I need data for these two years describing weighted average tuition fees for international students, by province, and including undergraduate & graduate levels separately).
Answer 1:
You might want to try the CAUT almanacs:
https://www.caut.ca/latest/publications/almanac
They do have provincial averages for both undergraduate and graduate students, though I haven’t checked all of the years.
Unfortunately, though, the online statistics begin at 2002 (although they may have earlier years in the 2002 edition).
Answer 2:
Table 9 in TLAC includes weighted average tuition fees for full-time undergrad and grad students, domestic and international, from 1972 forward.
Answer from Subject Matter:
There are two templates of products that have weighted average tuition. Each file is $150, or $350 total. I think they should have all the information that the client wants. Please let me know if the client is interested and I will send you the catalogue number and the actual products.
Tuesday, April 10, 2018
"Welfare" Expenditures -- Public Accounts?
Question:
A researcher is interested in learning more about confirmed “welfare” expenditures in Canada, however it might be defined/normalized by StatCan.
We have located CANSIM 380-0079 (Current and capital accounts - General governments) as a means to get some numbers. This is looking at government transfers. The idea of using 380-0079 is based loosely on the context offered in the User Guide: Canadian System of Macroeconomic Accounts, where 380-0079’s row labelled “Less: Transfers paid to households” equates to “Old Age Security, Guaranteed Income Supplement, welfare, etcetera.” (n.b. text is listed directly from the user guide). My hunch, though, is that this might exclude the operating costs for social programs themselves.
I don’t know gov’t finances in CANSIM like others. Is there a better way to look at this issue? Another table or product to consider? E.g, is there a consolidated “Public Accounts of Canada + Provinces”? At the least, I’d like to get some certainty on what these values – transfers to households – mean in the table. E.g., do they just reflect gov’t spending to the HH for such social programs? Getting the fuller picture (spend to HH and operating costs) in tabular format would be amazing if at all possible, too.
Answer:
CANSIM Table 380-0081 is the table that the client can use to extract the “welfare” estimates that we have available. In that table the variable is called Income Maintenance.
The estimates found in this series are strictly the amounts transferred from governments to qualifying households, and do not include amounts related to the administration of these programs. Public Sector Statistics Division does publish a functional breakdown of government expenditures, but our understanding is that it is only available at a high level of aggregation.
A researcher is interested in learning more about confirmed “welfare” expenditures in Canada, however it might be defined/normalized by StatCan.
We have located CANSIM 380-0079 (Current and capital accounts - General governments) as a means to get some numbers. This is looking at government transfers. The idea of using 380-0079 is based loosely on the context offered in the User Guide: Canadian System of Macroeconomic Accounts, where 380-0079’s row labelled “Less: Transfers paid to households” equates to “Old Age Security, Guaranteed Income Supplement, welfare, etcetera.” (n.b. text is listed directly from the user guide). My hunch, though, is that this might exclude the operating costs for social programs themselves.
I don’t know gov’t finances in CANSIM like others. Is there a better way to look at this issue? Another table or product to consider? E.g, is there a consolidated “Public Accounts of Canada + Provinces”? At the least, I’d like to get some certainty on what these values – transfers to households – mean in the table. E.g., do they just reflect gov’t spending to the HH for such social programs? Getting the fuller picture (spend to HH and operating costs) in tabular format would be amazing if at all possible, too.
Answer:
CANSIM Table 380-0081 is the table that the client can use to extract the “welfare” estimates that we have available. In that table the variable is called Income Maintenance.
The estimates found in this series are strictly the amounts transferred from governments to qualifying households, and do not include amounts related to the administration of these programs. Public Sector Statistics Division does publish a functional breakdown of government expenditures, but our understanding is that it is only available at a high level of aggregation.
Monday, March 26, 2018
New dedicated mailboxes
Good day DLI / RTRA /PUMF Collection users,
In an effort to better track and manage our client requests the (DLI team / RTRA team / PUMF collection team) is changing the way we communicate with our community. We have created a new dedicated mailbox for all future communications and requests.
MAD DLI / DAM IDD (STATCAN) statcan.maddli-damidd.statcan@canada.ca
MAD RTRA / DAM ADTR ( STATCAN) statcan.madrtra-damadtr.statcan@canada.ca
MAD PUMF / DAM FMGD (STATCAN) statcan.madpumf-damfmgd.statcan@canada.ca
MAD-TravelDLI/DAM-VoyageIDD(STATCAN):statcan.mad-traveldli-dam-voyageidd.statcan@canada.ca
MAD-Invoice-DLI/DAM-Facture-IDD (STATCAN): statcan.mad-invoice-dlidam-facture-idd.statcan@canada.ca
Our team respectfully requests our clients withstand from writing to individual team members. The new mailbox is monitored by all team members and will help coverage in the advent of absences and vacations. These changes will be reflected on the website shortly.
**To DLI Only. Please note this does not replace the DLI Listserv.: DLILIST@IDD-DLI.STATCAN.GC.CA Please continue to ask questions and share your research.
** To PUMF only. Please note this does not replace the PUMF Listserv : PUMF-FMGD@IDD-DLI.STATCAN.GC.CA
Best,
Data Liberation Initiative (DLI)
Thursday, March 22, 2018
ADA linkage in the PCCF
Question:
I've been using the PCCF[2017] and don't see a field for the ADA in the record layout in the Reference Guide. So, is there a linkage for the ADA in the 2017 PCCF?
Answer:
The DA boundary file does have an ADA field containing the corresponding ADA. So, you can use that table to add the matching ADAs to your records that have been geocoded to the DA level by the PCCF. Hope that makes sense.
I've been using the PCCF[2017] and don't see a field for the ADA in the record layout in the Reference Guide. So, is there a linkage for the ADA in the 2017 PCCF?
Answer:
The DA boundary file does have an ADA field containing the corresponding ADA. So, you can use that table to add the matching ADAs to your records that have been geocoded to the DA level by the PCCF. Hope that makes sense.
Friday, March 16, 2018
Data Brokerage Firm, information retrievals services database & information products
Question:
I have a student seeking information about data brokerage and credit scoring companies in Canada.
He has been able to find some information via the Canadian Contract History Database, the codes he is examining there are D317B, D317E, T001 group,
He would like to find a list of the companies, and statistic information about these companies in Canada. By data brokerage firms he means, database companies, list companies, survey companies, credit scoring companies, industry research companies and so on.
How would you go about finding the NAICS codes that best describe this kind of company and/or related companies that compile data and resel as products. The Classic companies are Environics Analytics in Canada, internally Axciom, Oracle, etc.
Answer from DLI member:
A significant number would, I think, fall under 541910 - Marketing research and public opinion polling (of course the 6-digit is Canadian industry only, so maybe better to go with 5-digit).
From the NAICS 2012 definition, this includes:
- broadcast media rating services
- market analysis or research services
- political and public opinion polling services
- public opinion research services
- sampling services, statistical
http://www23.statcan.gc.ca/imdb/p3VD.pl?Function=getVD&TVD=118464&CVD=118471&CPV=541910&CST=01012012&CLV=5&MLV=5
Answer from subject matter:
“Is this client a federal or provincial government? If they are not, then we will be unable to provide them with any specific microdata information about these companies. We could only give them aggregate information based on the NAICS they are looking for. ISED and other websites do have some information on registered and incorporated businesses but they would not be able to get this information from StatCan.
As for the NAICS for these businesses, the website is the best way for clients to look up NAICS. From the information the client has given you, I would estimate that they are looking at businesses in NAICS 541910 – Marketing research and public opinion polling, however, depending on the business, you could see other NAICS in the 541 subsector.”
This is the link on the STC website: http://www.statcan.gc.ca/eng/subjects/standard/naics/2017v2/index
Subscribe to:
Posts (Atom)