Question
I have a user who is looking for the amount of GST revenue earned/generated by NAICS or SIC industry classification, in 2001, 1996, and 2001. I have checked the STC web site, CANSIM (E-stat), Financial performance indicators, and Industrial monitor.
I'm now stumped - what am I missing?
Answer
Try the Compendium of GST/HST Statistics on the CRA website.
http://www.cra-arc.gc.ca/agency/stats/gst_hst-e.html
They include tables on GST/HST collected, which they define as "This amount is based on all GST/HST charged, at 7% GST or 15% HST, on paid and unpaid invoices during the reporting period. The total of GST collected in a reporting period is based on
all GST/HST collected and collectable reported on line 105 of Form GST34, and includes adjustments from all forms filed by
GST/HST registrants."
They use SIC to classify industries.
Table 7g is the distribution of GS/HST collected by major industry group.
The time series runs from the 1994-95 fiscal year to 2003-04.
Tuesday, August 30, 2005
Tuesday, August 23, 2005
Canadian mortality microdata
Question
Yet another researcher is looking for microdata from Canadian registration of deaths records, or whatever they are called now. All years from 1984 to 2004 would be appreciated.
The variables needed (and that were available at least in the 1980s) are: year and month of death; province, county, locality of residence; marital status; sex; age; year of birth; place of birth; province, county, locality of death; ethnic origin; occupation; industry; place of death (hospital, sanatorium, etc.); autopsy; cause of death, nature of injury (International classification of disease, ICD-9); birthplace of mother, father.
I am aware that not all these variables are consistently filled in by all provincial vital statistics agencies, but for those that are, the info would be great.
The alternative, I suppose, is to use again US mortality records, which are fairly readily available.
Answer
Statistics Canada does not disseminate vital statistics information as a PUMF. Aggregated statistics at the Canadian level is all that is available for detailed tables.
Vital statistics are administrative data (meaning: they are collected by another government department and then remitted to Statistics Canada for publishing). The owners of the data (provincial ministries of vital statistics) still own the "rights" to the data and do not allow any release of the information by Statistics Canada to other users.
STC's Health Division advised that every single provincial ministry would need to be contacted in order to release the data. The rumour is that requests have been pending for over two years and the outcome is not looking favourable.
Most unfortunately, your user may need to do as you describe - use American data.
Yet another researcher is looking for microdata from Canadian registration of deaths records, or whatever they are called now. All years from 1984 to 2004 would be appreciated.
The variables needed (and that were available at least in the 1980s) are: year and month of death; province, county, locality of residence; marital status; sex; age; year of birth; place of birth; province, county, locality of death; ethnic origin; occupation; industry; place of death (hospital, sanatorium, etc.); autopsy; cause of death, nature of injury (International classification of disease, ICD-9); birthplace of mother, father.
I am aware that not all these variables are consistently filled in by all provincial vital statistics agencies, but for those that are, the info would be great.
The alternative, I suppose, is to use again US mortality records, which are fairly readily available.
Answer
Statistics Canada does not disseminate vital statistics information as a PUMF. Aggregated statistics at the Canadian level is all that is available for detailed tables.
Vital statistics are administrative data (meaning: they are collected by another government department and then remitted to Statistics Canada for publishing). The owners of the data (provincial ministries of vital statistics) still own the "rights" to the data and do not allow any release of the information by Statistics Canada to other users.
STC's Health Division advised that every single provincial ministry would need to be contacted in order to release the data. The rumour is that requests have been pending for over two years and the outcome is not looking favourable.
Most unfortunately, your user may need to do as you describe - use American data.
Thursday, August 11, 2005
Pension Plans
Question
A student working on a research projet here at Concordia is looking for the following data:
Number of pension plans (or members of those plans) by industry and by type of plans (Defined benefit and Defined contribution pension plans) at the national level. This data seems to be available from the "Pension plans in Canada" database but I could find no currently available product that would answer the question. I know custom tables could be produced at a cost, but would the information be available in any other form through DLI or DSP?
The other aspect of the research has to do with level of unionization by industry also at the national level. Those numbers are available from CANSIM (Labour force survey estimates (LFS), employees by union coverage, table 282-0077). Now, would there be any survey that would cross-index this variable (unionization by industry) with the other one (type of pension-plan per industry)? In other words, would it be possible to associate, say the "defined benefit segment" of industry X with its level of unionization?
Answer
I researched what I could for you, but came up with very similar results:
1) Pension Plans in Canada : Key Tables (74-508-XWE) has some great tables, but nothing that crosses industry with union participation. It does cross public vs. private firms, but that is not detailed enough for your patron. I think that one of the only options to you then is to explore a custom extraction for a fee.
2) The Labour Force Survey does not ask pension questions, so it would never be crossed with union participation.
A student working on a research projet here at Concordia is looking for the following data:
Number of pension plans (or members of those plans) by industry and by type of plans (Defined benefit and Defined contribution pension plans) at the national level. This data seems to be available from the "Pension plans in Canada" database but I could find no currently available product that would answer the question. I know custom tables could be produced at a cost, but would the information be available in any other form through DLI or DSP?
The other aspect of the research has to do with level of unionization by industry also at the national level. Those numbers are available from CANSIM (Labour force survey estimates (LFS), employees by union coverage, table 282-0077). Now, would there be any survey that would cross-index this variable (unionization by industry) with the other one (type of pension-plan per industry)? In other words, would it be possible to associate, say the "defined benefit segment" of industry X with its level of unionization?
Answer
I researched what I could for you, but came up with very similar results:
1) Pension Plans in Canada : Key Tables (74-508-XWE) has some great tables, but nothing that crosses industry with union participation. It does cross public vs. private firms, but that is not detailed enough for your patron. I think that one of the only options to you then is to explore a custom extraction for a fee.
2) The Labour Force Survey does not ask pension questions, so it would never be crossed with union participation.
Tuesday, July 19, 2005
Ethnicity of Doctors
Question
A faculty member is trying to look at the trends in the number of doctors by ethnic origin and/or place of birth in Canada. I haven't found any profile or topic-based tabulations which will provide both sides of the issue and unfortunately, the PUMF doesn't break out doctors (physicians) from other occupations in health.
Have I overlooked something? Can anyone offer suggestions? Perhaps a custom tabulation could be done?
Answer
I found this table (97F0012XCB2001048) which provides visible minority by detailed occupation (SOC).
http://www12.statcan.ca/english/census01/products/standard/themes/RetrieveProductTable.cfm?
Temporal=2001&PID=60932&APATH=7&GID=517770&METH=1&PTYPE=55496&THEME=46&FOCUS
=0&AID=0&PLACENAME=0&PROVINCE=0&SEARCH=0&GC=99&GK=NA&VID=1676&FL=O&RL=0&FREE=0
And this one with the same variables only for NOC : (97F0012XCB2001050)
http://www12.statcan.ca/english/census01/products/standard/themes/RetrieveProductTable.cfm?
Temporal=2001&PID=60937&APATH=7&GID=431515&METH=1&PTYPE=55496&THEME=46&FOCUS
=0&AID=0&PLACENAME=0&PROVINCE=0&SEARCH=0&GC=99&GK=NA&VID=1625&FL=O&RL=0&FREE=0
If you are looking for place of birth, and the level of detail is too aggregated with the PUMF, I know you can custom order it. Of course, it would be subject to confidentiality suppressions, etc.
A faculty member is trying to look at the trends in the number of doctors by ethnic origin and/or place of birth in Canada. I haven't found any profile or topic-based tabulations which will provide both sides of the issue and unfortunately, the PUMF doesn't break out doctors (physicians) from other occupations in health.
Have I overlooked something? Can anyone offer suggestions? Perhaps a custom tabulation could be done?
Answer
I found this table (97F0012XCB2001048) which provides visible minority by detailed occupation (SOC).
http://www12.statcan.ca/english/census01/products/standard/themes/RetrieveProductTable.cfm?
Temporal=2001&PID=60932&APATH=7&GID=517770&METH=1&PTYPE=55496&THEME=46&FOCUS
=0&AID=0&PLACENAME=0&PROVINCE=0&SEARCH=0&GC=99&GK=NA&VID=1676&FL=O&RL=0&FREE=0
And this one with the same variables only for NOC : (97F0012XCB2001050)
http://www12.statcan.ca/english/census01/products/standard/themes/RetrieveProductTable.cfm?
Temporal=2001&PID=60937&APATH=7&GID=431515&METH=1&PTYPE=55496&THEME=46&FOCUS
=0&AID=0&PLACENAME=0&PROVINCE=0&SEARCH=0&GC=99&GK=NA&VID=1625&FL=O&RL=0&FREE=0
If you are looking for place of birth, and the level of detail is too aggregated with the PUMF, I know you can custom order it. Of course, it would be subject to confidentiality suppressions, etc.
Merging 1991 Profiles
Question
I have the census 1991 enumeration profiles (short and long version) and the census tract 1991 short and long version profiles. I wanted to know if one can merge the enumeration short and long version by region code, fed and EA or if such a merge is even meaningful? Similarly, I would like to merge the CT census profile (short and long version as well) however I am not sure what the identifying variables are for such a merge....(by ct, rp, cma)?
Answer
The files could be merged on the Geography using SAS Software. The client should also consider that the 100% database suppression is based upon the total population while the 20% sample database suppression is based upon the non-institutional population.
I have the census 1991 enumeration profiles (short and long version) and the census tract 1991 short and long version profiles. I wanted to know if one can merge the enumeration short and long version by region code, fed and EA or if such a merge is even meaningful? Similarly, I would like to merge the CT census profile (short and long version as well) however I am not sure what the identifying variables are for such a merge....(by ct, rp, cma)?
Answer
The files could be merged on the Geography using SAS Software. The client should also consider that the 100% database suppression is based upon the total population while the 20% sample database suppression is based upon the non-institutional population.
Friday, July 15, 2005
NPHS 2002-2003 documentation
Question
I have a user looking for documentation pertaining to the 2002-2003 longitudinal National Population Health Survey study. Is there any way we can obtain this? Or does the user have to contact the RDCs directly?
Answer
Check here:
http://www.statcan.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS
=3225&lang=en&db=IMDB&dbg=f&adm=8&dis=2#4
I have a user looking for documentation pertaining to the 2002-2003 longitudinal National Population Health Survey study. Is there any way we can obtain this? Or does the user have to contact the RDCs directly?
Answer
Check here:
http://www.statcan.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS
=3225&lang=en&db=IMDB&dbg=f&adm=8&dis=2#4
Thursday, July 14, 2005
University and College Academic Staff System - Part-time Staff
Question
I have a researcher looking for the University and College Academic Staff System - Part-time Staff (PTUCASS) data. Can this be made available through DLI?
Answer
As it turns out, the survey no longer collects part-time information -- all we have is full-time info! This is a recent change. We stopped collecting data on part-time faculty staff since it was not well reported and there was not much demand for such data. Eventually the title will change to reflect the difference.
I have a researcher looking for the University and College Academic Staff System - Part-time Staff (PTUCASS) data. Can this be made available through DLI?
Answer
As it turns out, the survey no longer collects part-time information -- all we have is full-time info! This is a recent change. We stopped collecting data on part-time faculty staff since it was not well reported and there was not much demand for such data. Eventually the title will change to reflect the difference.
Subscribe to:
Posts (Atom)