Friday, November 25, 2011
New files on Statistics Canada Nesstar: School Leavers Survey
We are pleased to inform you that the following files are now available on the Statistics Canada Nesstar Webview site (http://www62.statcan.ca).
School Leavers Survey (1995 and 1991)
Anyone can view the metadata for these files on the Statistics Canada Nesstar site. Only DLI Contacts however will be able to access the data files on the site. If you are a DLI Contact and would like to access and manipulate data files on the Statistics Canada Nesstar site, please send an email to dli-idd@statcan.gc.ca to request a password. Please note that the DLI data files available through Nesstar are subject to the DLI license agreement.
Statistics Canada to make all online data free
For more information, check out: http://embassymag.ca/dailyupdate/view/statistics_canada_to_make_all_online_data_free_11-24-2011
Tuesday, November 22, 2011
Sources of gender-desegregated data
This is something I have not been previously asked about and now I have agreed to speak to a class about gender-desgregated data sources. There are some good web pages at Health Canada and DSP and a few others but I am wondering if I am overlooking something in DLI? Any suggestions about sources of gender-desgregated data would be greatly appreciately.
Answer
Most of the data in the DLI collection can be disaggregated by sex. Even the household level surveys have some capacity for this. However, the GSS (General Social Survey) series did come to mind, as it covers a wide range of topics for which gender-based analysis might be appropriate (i.e. victimization and social networks).
http://www.statcan.gc.ca/pub/89f0115x/89f0115x2009001-eng.htm
Friday, November 18, 2011
Updated Products - Input-Output
We are pleased to inform you that the following tables have been added to the DLI FTP and website:
Interprovincial Trade Flows (15F0002XDB) - 2008
National Input-Output Tables (15F0041XDB) - 2008
Provincial Input-Output Tables (15F0042XDB) - 2008
National Symmetric Input-Output Tables (15-207-XCB) - 2008
National Symmetric Input-Output Tables (15-208-XCB) - 2008
Provincial GDP by Industry and Sector, at Basic Prices (15-209-XCB) - 2008
Provincial Gross Output by Industry and Sector (15-210-XCB) - 2008
Provincial Symmetric Input-Output Tables: (15-211-XCE) - 2008
WEB: http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/io-es-eng.htm
FTP: /dli/DLI-Collection_Other-Products/Input-Output-Tables
MARC records for DLI products
Where can I get MARC records for all the DLI products? From this message on the STC website, I’m guessing they exist: “If you are a member of the Depository Services Program (DSP) or the Data Liberation Initiative (DLI) you can download the MARC record(s) for this Statistics Canada product directly into your cataloguing database.”
Answer
On the search page for the Statistics Canada library catalogue, the right hand side bar has information on downloading Marc records in the Z39.50 format.
Z39.50 protocol enables you to search and retrieve MARC records from the Statistics Canada Library database using software connected to the Internet. This service does not require registration, simply configure your ILS Z39.50 server with the following parameters:
Database: Unicorn
IP address: 142.206.64.146
Port number: 2200Once you have configured your ILS Z39.50 server, consult your ILS documentation for how to proceed with downloading library catalogue MARC records.
http://bibliocat.statcan.ca/web2/tramp2.exe/goto/A1i5ppdn.000?screen=Para3950.html
Wednesday, November 16, 2011
Quebec Universities' Financial Information
I have a student who is looking for statistical information about equipment purchases made by Quebec universities for the following years: 1980, 1982, 1985, 1988, 1989, 1992, 1994, 1998, 2000, 2005 et 2007.
Answer:
The best place to look would be the Financial Information of Universities and Colleges Survey (http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=3121&lang=fr&db=imdb&adm=8&dis=2). The Financial Information of Universities and Colleges Survey was developed to provide financial information (income and expenditures) on all universities and degree-granting colleges in Canada. Clicking on 'other reference periods' (located in the left-side menu bar), will allow you to explore other time periods.
Tuesday, November 15, 2011
Office of Energy Efficiency: Comprehensive Energy Use Database
http://oee.nrcan.gc.ca/corporate/statistics/neud/dpa/comprehensive_tables/index.cfm
New files on Statistics Canada Nesstar
We are pleased to inform you that the following files are now available on the Statistics Canada Nesstar Webview site (http://www62.statcan.ca).
Labour Force Survey – October 2011
Adult Literacy and Life Skills Survey (2003)
Anyone can view the metadata for these files on the Statistics Canada Nesstar site. Only DLI Contacts however will be able to access the data files on the site. If you are a DLI Contact and would like to access and manipulate data files on the Statistics Canada Nesstar site, please send an email to dli-idd@statcan.gc.ca to request a password. Please note that the DLI data files available through Nesstar are subject to the DLI license agreement.
Thank you.
Updated Product: Social Policy Simulation Database and Model
The following product is now available on the DLI FTP and website.
Social Policy Simulation Database and Model (SPSD/M) 1997 to 2016 (Version 19.0, database year 2007)
The SPSD/M is a static microsimulation model designed to analyse financial interactions between governments and individuals in Canada. It can compute taxes paid to and cash transfers received from government. It is comprised of a database, a series of tax/transfer algorithms and models, analytical software and user documentation.
http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=89F0002X&lang=eng
WEB:
www.statcan.gc.ca/dli-ild/data-donnees/ftp/spsdm-bdmsps/spsdm-bdmsps19-eng.htm
Muslim Immigrants & Country of Origin
Although religion wasn’t asked in the 2006 Census, is there a way to obtain counts for the number of Muslim immigrants at the National level x country of origin?
Answer
There are a few possible sources in locating the answer to this question. You could first consult a report issues by Environics Research Group (http://www.environicsinstitute.org/PDF-MuslimsandMulticulturalisminCanada-LiftingtheVeil.pdf). Alternatively, you could do a xtab of coutry of origin and religion in the 2001 Census PUMF, or the version in the RDC, which should have more detailed country of origin values coded. The most detailed country of origin data come from Citizenship and Immigration, but they don't ask religion.
Egg Prices
I am interested in locating egg prices going back only 5-10 years. I'm also looking for the price of Omega3 eggs and any other types available. Any suggestions as to where I can locate this informtion?
Answer
The CANSIM table 326-0012 “average retail prices for food and other selected items monthly (dollars)” is the only table produced that contains egg prices. We do not, however, have any other information available for egg prices divided by sub-categories.
Tuesday, November 8, 2011
Small & Medium Manufacturing Businesses
Hello,
A student is looking for the number of small and medium manufacturing businesses in the Chaudière-Appalaches region in Québec for the past 3 years. Does anyone have any suggestions of where this information can be located?
Answer
The information you seek can be found on the Institut de la statistique du Québec's website. It has manufacturing data by region from 2004: http://www.stat.gouv.qc.ca/donstat/econm_finnc/sectr_manfc/profil_secteur/index.htm
Update: Survey of Labour and Income Dynamics 2009
The Public Use Microdata File (PUMF) for the Survey of Labour and Income Dynamics (SLID) 2009 is now available on the DLI FTP and website.
"The cross-sectional public-use microdata file for the Survey of Labour and Income Dynamics (SLID) is a collection of income, labour and family variables on persons in Canada and their families. This file includes many safeguards to prevent the identification of any one person.
Although often referred to as a single file, the SLID public-use microdata file is actually four separate files: key, person, economic family and census family.
The person file contains identifier data, which allows a researcher to group persons into households, economic families and census families, as well as link each of these files together."
(http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=75M0010XCB&lang=eng)
Friday, November 4, 2011
Alcohol consumption, 1940 - 2005
I'm looking for stats related to alcohol consumption per capital (in litres of alcohol) in Canada between 1940 and 2005 (I'm not looking for the different types of drinks). If possible, I'm also looking for stats regarding higher quantities of alcohol consumption (5 glasses or more at least once a month for the last 12 months) between 1940 and 2005). Does this information exist?
Answer
The best source found was "Canada Food Stats" (catalogue number 23F0001XBB): http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=23F0001XBB&lang=eng. This product provides access to a broad spectrum of food statistics and indicators. It contains information on per capita food availability for consumption and food prices, nutrition, supply and demand, as well as data on the food industry, processing, employment, productivity, trade and much more. The product provides users with easy access to large volumes of data, access to pre-defined tables or the ability to query the database and create unique tabulations.
Specific to your question, it contains data on alcohol consumption in litres per person since 1960. Unfortunately, there was no retrievable information regarding your query regarding high quantities of alcohol consumption.
Release of the updated version of the Health Profile and Health Trends
Statistics Canada is pleased to announce the release of the updated version of the Health Profile, October 2011 and Health Trends, October 2011 Internet applications.
Health Statistics Division and the Census Internet Development Team have updated the online Health Profile product with the latest health region boundary changes (see related What’s new for details). The online Health Trends product has also been updated with cancer incidence data from the Canadian Cancer Registry Database for 2009 as well as low birth weight and other indicators from the Vital Statistics data for 2008 (see related What's new for details).
There are different ways to access the Health Profile or Health Trends Internet applications from the Statistics Canada home page. Users can either click on the Health in Canada module, or click on the 'Latest census data' link under the 'Census' heading, in the right-hand navigation bar, and enter through the 'Features' or 'Census news' links.
To enquire about the concepts, methods and data quality of these data, please contact Health Statistics
New files on Statistics Canada Nesstar
We are pleased to inform you that the following files are now available on the Statistics Canada Nesstar Webview site (http://www62.statcan.ca).
Survey on Family Expenditures (1996, 1992, 1986, 1984, 1982, 1978 and 1969)
Anyone can view the metadata for these files on the Statistics Canada Nesstar site. Only DLI Contacts however will be able to access the data files on the site. If you are a DLI Contact and would like to access and manipulate data files on the Statistics Canada Nesstar site, please send an email to dli-idd@statcan.gc.ca to request a password. Please note that the DLI data files available through Nesstar are subject to the DLI license agreement.
Census Data on Activity Limitation
Regarding activity limitation data in the Census, Question 8 refers to mental or physical health problems which reduce the type of activity that a person is able to do. I have started a search for the tables that include the data from this question and so far I have not been able to find it. Any clues?
Answer
The 2006 Census questions 7 and 8 are filter questions used to create the survey frame for the post-censal Participation and Activity Limitation Survey. Here is a quote from the PALS 2006 PUMF User Guide (cat. no. 12M0021G):
“The PALS adult survey population consisted of all persons 15 years of age or older living in households who reported at least one limitation to the Census questions on activity limitations and who were living in Canada at the time of the Census.”
Page 13 of the 2006 Census Dictionary will provide you with more detail on those filter questions: http://www12.statcan.gc.ca/census-recensement/2006/ref/dict/pdf/92-566-eng.pdf
The Census Dictionary also advises users to look to PALS for disability data: “The PALS will be the primary source for disability data in 2006, since it provides a better identification of the population and more detailed information on its characteristics. Disability data from the 2006 Census will be available upon special request only. The 2006 Census disability data have minimum edits and should be used with caution” (p.14).
Tuesday, November 1, 2011
Motor Vehicle Deaths: Urban/ Rural
Is it possible to obtain data on deaths from motor vehicle accidents by urban/ rural?
Answer
The Canadian Motor Vehicle Traffic Collision Statistics (available from Transport Canada - <http://www.tc.gc.ca/eng/roadsafety/resources-researchstats-menu-847.htm#abc> contain "Number of Collisions by Location" tables that show the urban rural split, and indicate whether the collisions resulted in fatalities or personal injuries. The reports on the website cover 2003-2009.