Tuesday, August 21, 2007

University and College Academic Staff System (UCASS)

Question

A researcher is looking at the demographic profile of teaching professionals and I came across University and College Academic Staff System (UCASS) with release date "August 2, 2007 (preliminary)". On the statcan page, it does not really tell from where this data is available - dli or custom made tabulations for fee or if its just released. What are the plans on availability?

Answer

The Culture, Tourism and the Centre for Education Statistics Division has provided the DLI with a some education standard tables, some of which appear to be from UCASS (University and College Academic Staff System). The most recent data we currently have in these tables are for 2004-2005. I have contacted the author division to see if more recent versions of these tables or a PUMF are available.

FTP: /usr2/ftp/dli/education
WEB: http://www.statcan.ca/english/Dli/Data/Ftp/education.htm

ucass.zip
Teachers-in-universities-2004_2005.xls
Table 1.1 Number of Full-Time University Teachers by Rank, Sex and Region, Selected years, 1960-1961 to 2004-2005
Table 1.2 Number of Full-Time University Teachers by Rank, Sex and Province, Selected years, 1960-1961 to 2004-2005
Table 2 Number of Full-Time University Teachers by Region, Field, Highest Earned Degree, Staff Functions, Rank, Sex and Median Age, 2004-2005
Table 3 Median Age of Full-Time University Teachers by Region, Field, Highest Earned Degree, Staff Functions, Rank and Sex, 2004-2005
Table 4 Median Age of Full-Time University Teachers by Region, Field, Highest Earned Degree, Staff Functions, Rank and Sex, 2004-2005
Table 5 Number and Median Salaries of Full-Time University Teachers by age, Sex and Field Canada, 2004-2005

According to The Daily and the Online Catalogue, the following publication also appears to have been released based on the 2006-2007 survey:
http://www.statcan.ca/bsolc/english/bsolc?catno=81-595-M2007052

Data from UCASS also appears to be available (for a fee) as a custom tabulation
http://www.statcan.ca/bsolc/english/bsolc?catno=81C0015

Friday, August 17, 2007

Religious & Civil Marriage Statistics by Province

Question

I would like to request availability and contact information please for annual provincial / territorial statistics from 1960 to the most current, for total religious and civil / non-religious marriages.

Answer

You may want to look at CANSIM table 101-1013. It seems to have data for # of marriages by province by type of officiant (ex. clergy, non-clergy) for 2000 to 2003. This table unfortunately doesn't go back to the 1960's however. Otherwise, the data might be available from the Health Statistics Division as a custom fee based retrieval.

Wednesday, August 15, 2007

Road Statistics

Question

A student here is looking for data on the % paved roads, automobile density and mean miles driven annually for:
Quebec City, 1989
City of Edmonton, 1989

Two years ago, Joel Rivard described how to use DMTI data in ArcView to get the road lengths for Ontario; what the student wants is paved roads, and for the above cities. I suspect she'd be happy with even just the overall road length.

Any ideas? I realize getting data for these exact years is likely to be problematic, to say the least, so whatever can be obtained would be appreciated.

Answer

I contacted our Geography Division to see if they had the information your student needs and they confirmed that they do not. They did however provide the following suggestions:

"Contact the respective province and their Ministry of Transportation, they should have the percentage of paved roads and arc lengths. We do not collect such attribute information.

GeoBase has a national road network file available for free download (see Natural Resources Canada NRCan website for the link)." I found the following information and link to Geobase on the NRCan website:
http://www.cits.rncan.gc.ca/cit/servlet/CIT/site_id=1&page_id=1-008-001.html

Thursday, August 2, 2007

Visits to Primary Care Physicians

Question

A student is looking for "MOST FREQUENT REASONS FOR VISITS TO THE OFFICES OF PRIMARY CARE PHYSICIANS". He has data from the US, but is looking for data from Canada.

I dug around a bit, and found the Health Services Access Survey (HSAS) (Survey number 5002). CANSIM Table 105-3041 makes use of this survey, but collapses the detail contained in the survey. It appears, as well, that this survey focuses on visits to 'specialists' rather than 'primary care physicians'.

The kinds of 'reasons for visits' the researcher found for the US data include:
(rate per 1000)
general medical examination 83.84
cough 56.16
sore throat 34.80
well baby examination 34.56
follow-up visit 29.69
fever 28.40
earache 21.80
hypertension 21.20
head cold, upper respiratory infection 19.20
skin rash 18.66
nasal congestion 17.78
back pain, ache, discomfort 17.63
blood pressure check 16.63
headache 16.10

I have checked the CCHS, and related surveys, as well as looking at CIHI and CIHR web sites, to no avail. There are a couple of articles in "Health Reports", but these lack the detail of the US data.

Does anyone have any other suggestions?

Answer

Our Special Surveys Division appears to have conducted a survey called the "Canadian Survey of Experiences with Primary Health Care (CSE-PHC)" on behalf of the Health Council of Canada
(http://www.statcan.ca/cgi-bin/imdb/p2SV.pl?
Function=getSurvey&SDDS=5138&lang=en&db=IMDB&dbg=f&adm=8&dis=2
).
The content of its questionnaire
(http://www.statcan.ca/english/sdds/instrument/5138_Q1_V1_E.pdf)
leads me to think that it doesn't have the level of detail your student requires. It is has been released as a master file through the Research Data Centres, but a PUMF will not be released.

Tuesday, July 10, 2007

Canadian Community Health Survey & Census

Question

A researcher is planning to analyze variables from CCHS and socio-economic indicators avaliable from Census data at the community level (looking at rural urban differences). As per the documentation on CCHS- PUMF, the public use file has a variable named GEOEDPMF (Grouped -Health Region) is derived from GEOEDHRA (Health Region) futher derived from Dissemination Area and Postal code (all three available in master data file). If the patron is planning to use CCHS PUMF, is there a way to go to DA level or postal code level without going through RDC (master data file) or there is any other way of looking at the community level parameters in CCHS and distinguish rural and urban areas.

Answer

The only ways of which I know that the CCHS PUMF can be linked to census results are

(i) the Census Profiles by health regions (see
http://www.statcan.ca/english/freepub/82-221-XIE/2007001/profiles.htm)
and (ii) use of the peer grouping information on health regions (see
http://www.statcan.ca/english/freepub/82-221-XIE/2007001/regions.htm).
The peer groupings differentiate health regions on some basic characteristics, including urban-rural mix (see
http://www.statcan.ca/english/freepub/82-221-XIE/2007001/hregions/hrtable5.htm).

Monday, July 9, 2007

Inter-Corporate Ownership Access

Question

Is the ICO a DSP product that can be made available to the public? It is still showing up on the StatCan website as a DLI product.

Answer

Yes, the fourth quarter (December) issue of the Inter-corporate Ownership CD-ROM is a DSP product, even if this is not currently indicated in the ICO record in the STC Online Catalogue of Products and Services.

The information in the May 14 2002 DLI List posts about the ICO is still accurate. Technically, only the fourth quarter issue is a DSP product while the issues for all four quarters are available through the DLI. However, as stated in the May 14 2002 DLI List posts, you can allow the public to consult the issues for all four quarters.

Tuesday, July 3, 2007

Quarterly GDP by Province

Question

A researcher is looking for quarterly (or monthly) expenditure-based provincial GDP data in constant prices. However CANSIM has this quarterly data only for the country as table 384-0002 OR as annual data for the provinces in table 380-0002. Does anyone know of any sources for this quarterly provincial data that they could direct me to?

Answer

The author division has confirmed that they only produce annual data for provincial GDP.