Friday, January 29, 2016

International Merchandise Trade Data

Question

Can you tell me if the International Merchandise Trade Data (HS 8 level) is available under the Open Licence now?

Answer

International Merchandise Trade Data is available on the EFT here:

/MAD_DLI/Root/trade_commerce/international-merchandise-data-by-commodity-classification

Thursday, January 28, 2016

Historic immigration data

Question

I have a researcher looking to obtain immigration data including immigrant status, place of birth, and period of immigration (by decade). Basically, they need the equivalent of this table, but they would like this information back to the 1940s, whereas this table groups everything "before 1971" together.

Going back through basic summary tabulations from much older census years, I did find similar tables that went back further in time, but place of birth is by very broad geographies (13 categories).

Is this data available through any table that I am missing, or through custom tabulation?

Answer

The following tables go back to 1961.

http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=89425&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=72&VID=0&VNAMEE=&VNAMEF=

http://www.statcan.gc.ca/c1996-r1996/nov4-4nov/imm1-eng.htm

http://www.statcan.gc.ca/c1996-r1996/nov4-4nov/imm2a-eng.htm

We only have documentation back to 1971 here at the Help Desk and the ability to produce custom tabulations is only as far back as 1971.

That being said, I found a few resources that may be of use to them.

A few of this CANSIM tables could be of interest to them:

http://www5.statcan.gc.ca/subject-sujet/result-resultat?pid=30000&id=30004&lang=eng&type=ARRAY&pageNum=1&more=0

The following historical Census table (does not however, include Place of Birth)

http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=89423&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=72&VID=0&VNAMEE=&VNAMEF=

Also the following publication:

Canadian Social Trends – 100 years of immigration in Canada

http://www.statcan.gc.ca/pub/11-008-x/2000002/article/5164-eng.pdf

They can also check out the Canada yearbooks for the historical years here and look under the Immigration and Colonization section.

As an example, this is 1941.

http://www66.statcan.gc.ca/eng/acyb_c1941-eng.aspx?opt=/eng/1941/194101730115_p. 115.pdf

The rest are here:

http://www66.statcan.gc.ca/acyb_000-eng.htm

Or the following years are available for quick access (there are a list of tables available in each year).

http://www65.statcan.gc.ca/acyb02/acyb02_0000-eng.htm

Population by age groups for CDS and CSDs

Question

I have given a researcher links to census tables that provide population figures by age group down to the CD and CSD level back to 1991, and CANSIM tables that provide data at the provincial level back to 1971, but I wondered if there was any compilation at the lower levels of geography prior to 1991, or even provincial data prior to 1971 without having to laboriously transcribe it from the printed census volumes

Answer

For provincial/territorial population estimates by age and sex before 1971, this information is not publicly accessible on Cansim but we can provide an Excel data file on demand.There are however 3 important differences between those estimates and subsequent estimates. As stated in the note tab, population estimates are as of June 1 (rather than as of July 1), they are not adjusted for census net undercoverage and non-permanent residents are not included in the population estimates. More generally, user should also be aware of differences between Statistics Canada's census counts and population estimates.

For subprovincial areas such as CDs, it is more complicated because of boundary changes that may prevent historical comparisons. However, you could still refer the user to some Cansim tables. First, CANSIM table 051-0030 provides total population estimates for CDs and CMAs as of July 1, 1976 to 1986, according to the SCG 1981. Second, Cansim table 051-0036 provides population estimates by age and sex for CDs and CMAs as of July 1, 1986 to 2007, according to the SGC 2001. Users must be aware that from one SGC to another, borders may shift and geographical units may not be comparable.

Monday, January 25, 2016

Gasoline Sales by Volume

Question

I'm looking for data on gasoline sales by volume for Ontario in 2007, either monthly or quarterly. It can be wholesale or retail, either gasoline in general or regular, unleaded. I haven't been able to come up with anything at that level of geography.


Answer

I’ve received the following response from subject matter:

“We have on the Statcan website CAMSIM table 326-0009 the average retail prices for gasoline and fuel oil, not the sales of volume, available by urban center.”
Table 326-009 – Average retail prices for gasoline and fuel oil, by urban centre Monthly (cents per litre)



Geography
Ottawa-Gatineau, Ontario part, Ontario/Quebec5
Toronto, Ontario
Thunder Bay, Ontario 3
Type of fuel
Regular unleaded gasoline at self service filling stations
Premium unleaded gasoline at self service filling stations
Diesel fuel at self service filling stations
Regular unleaded gasoline at self service filling stations
Premium unleaded gasoline at self service filling stations
Diesel fuel at self service filling stations
Regular unleaded gasoline at self service filling stations
Premium unleaded gasoline at self service filling stations
2007 January
82.5
93.6
88.5
80.1
91.4
89.8
95.5
105.8
2007 February
89.3
99.8
89.8
89.3
100.1
90.1
92.8
103.2
2007 March
99.5
110.4
95.0
101.1
112.4
98.3
103.1
113.4
2007 April
101.8
112.7
95.3
101.1
112.2
96.7
108.0
118.3
2007 May
106.6
117.7
93.8
105.5
115.9
94.0
111.8
122.3
2007 June
103.3
114.0
92.3
102.3
112.2
92.0
113.6
124.2
2007 July
101.2
112.8
93.0
101.0
110.6
94.3
114.2
124.9
2007 August
96.3
107.4
93.5
95.8
105.2
94.7
109.8
120.3
2007 September
97.3
108.2
96.3
97.2
106.4
96.3
111.9
122.6
2007 October
95.1
106.1
96.8
94.4
106.1
96.3
102.2
113.1
2007 November
101.5
112.5
99.5
99.9
111.0
100.0
104.6
115.3
2007 December
102.3
112.9
107.3
100.6
111.7
107.3
107.3
117.4
Footnotes:
2. For concepts and definitions, see publication Your Guide to the Consumer Price Index, catalogue no. 62-557-X, or publication The Canadian Consumer Price Index Reference Paper, catalogue no. 62-553-X. Additional information can also be obtained from the Consumer Prices Division at 1-866-230-2248 (toll-free) or by email at cpd-info-dpc@statcan.gc.ca.
3. No average retail price for diesel fuel at full service filling stations is published for Thunder Bay because it is not applicable.
4. No average retail price for fuel oil is published for Edmonton and Calgary because it is not applicable.
5. Formerly Ottawa (Ottawa-Hull, Ontario part).
6. Due to a lack of data availability, the average prices for Regular unleaded gasoline at full service filling stations, Premium unleaded gasoline at full service filling stations and Diesel fuel at full service filling stations will no longer be published after February 22, 2013, with the release of the January 2013 Consumer Price Index. Historical information for these series will continue to be available.
Source:  Statistics Canada. Table  326-0009 -  Average retail prices for gasoline and fuel oil, by urban centre, monthly (cents per litre),  CANSIM (database). 

Friday, January 22, 2016

Vital Statistics - Death Database

Question

A student is looking for the number of deaths, ages 0-74, both sexes, most recent data available, for all health regions in Canada from the Vital Statistics – Death Database. I found a CANSIM table that had this by province but there doesn’t seem to be anything for health regions. Is this data available by health region?

Answer

CANSIM table 102-4311 has 2009/2011 "premature mortality" (click on "Add/Remove data" or download the entire dataset) by health regions, by gender, and by rates or counts. The footnote for premature mortality explains that "Premature deaths are those of individuals who are younger than age 75."

I found the table by following footnotes in the Health Profiles. I look there first when I am trying to find health data available by health region, followed by loading up all the CANSIM tables from the health subject page and then using "Ctrl-F" (Command-F with a Mac) to quickly find all tables that have "health regions" in their titles.

Tuesday, January 19, 2016

Survey of Labour and Income Dynamics 2012

Question

Is the next SLID PUMF expected to be out in June 2016?

Answer

We’ve located the following announcement regarding the 2011 SLID:
This is the last release from the Survey of Labour and Income Dynamics and contains cross-sectional estimates only. Effective with the 2012 reference year, cross-sectional income esitmates will be available from the Canadian Income Survey (record number 5200).Longitudinal estimates are available up to and including 2010.For detailed information related to previous SLID releases, please click on the 'Other reference periods' sidebar.
I’ve contacted the subject matter area for the Canadian Income Survey and have received the following response:
“Our plans as of now are to try and release the CIS PUMFs in the Fall of 2016. At that time we are hoping to release 2012 and 2013. And hopefully 2014 shortly after.”

Offender self-reports

Question

A researcher is looking for data on “offender self-reports” based on offender surveys. Are any of these data collected in Canada and are they available?

Answer

We have received the following response from subject matter regarding this request:

“Unfortunately, with regards to out incident-based statistics, we do not collect data on self-reporting, either from the offender or victim perspective.”

Wednesday, January 13, 2016

Survey of Innovation and Business Strategy

Question

A researcher is working on marketing-related constructs such as strategy, marketing expenditures, performance, governance etc. for North American companies (including Canadian) - most of these constructs are used in SIBS (Survey of Innovation and Business Strategy). The researcher is interested in “firm-level” data and wondering if SIBS provides that access at all. He has looked into annual reports and other business resources that we subscribe to but, according to him, the strategy choice as measured in SIBS is very rare. Is it possible to get access to firm-level data from SIBS?

Answer

The SIBS data may be accessed by researchers through the Canadian Centre for Data Development and Economic Research (CDER): http://www.statcan.gc.ca/eng/cder/index. They would need to submit a research proposal to use CDER’s cost recoverable secure access to business microdata for analytical research.

Monday, January 11, 2016

Aboriginal Labour Stats

Question

I have a student who’s trying to compare employment / unemployment among aboriginals living on-reserve or off-reserve.

Are numbers for on-reserve employment available anywhere?

Answer

I have received the following response from subject matter:

“Please find below table at the Canada and province and territory level of geography. You can select whether you would like the data narrowed down by on-reserve or off-reserve population and by which aboriginal identity. Any other level of geography would need to be ordered on a custom basis at the nearest regional office. 
Secondary (High) School Diploma or Equivalent (14), Labour Force Status (8), Aboriginal Identity (8), Area of Residence: On Reserve (3), Registered or Treaty Indian Status (3), Age Groups (13B) and Sex (3) for the Population Aged 15 Years and Over, in Private Households of Canada, Provinces and Territories, 2011 National Household Survey

Friday, January 8, 2016

Postal Code Conversion File - current representation order of federal ridings

Question

A researcher wants to match postal codes to the current federal ridings using the Postal Codes by Federal Ridings File, (psfrf).

As you know, the latest November 2014 pcfrf contains the old Federal electoral districts 2003 Representation Order (as does the pccf), so we wondered if new files are in the works giving the latest ridings from the 2012 federal redistribution process? If so, is there a release date yet?

Answer

I’ve received the following response from subject matter regarding this:
“There are two versions of the PCFRF with November 2014 date currently available, one with the 2003 Representation Order (released on 2015 April 14), and the second with the 2013 Representation Order, released on 2015 September 2. As noted on the PCFRF product page, http://www5.statcan.gc.ca/olc-cel/olc.action?ObjId=92-178-X&ObjType=2&lang=en&limit=0, the most recent release of the PCFRF DOES in fact use the 2013 Representation Order.”

Tuesday, January 5, 2016

Survey of Emergency Preparedness and Resilience (SEPR)

Question

Will there be a PUMF for the Survey of Emergency Preparedness and Resilience (SEPR)?

Answer

We checked with subject matter on this and verified that there is NOT a PUMF available for the SEPR but data should be available through the NDR.

PALS 2006 Children

Question

I need to download the data from the PALS survey conducted by Statistics Canada in 2006. The only data available in the Odesi dataset is the adult dataset. Do you know where I can download the data for participants who were children <15 years of age?

Answer

I have received a response back from subject matter, and unfortunately there was no PUMF created for the <15 year population.

Monday, January 4, 2016

Government Financial Stats


Question

I have a researcher who’s working with government revenue and expenditure stats (Table 385-0002). It covers 1989 to 2009, and she’d like to know if comparable stats are available for earlier years, ideally back to 1971.

Answer

Here is the response from subject matter regarding this request:
“The historical data for government revenue and expenditure is as such: 
384-0022 Federal government 1961-1980
384-0023 Provincial government 1961-1980
384-0024 Local government 1961-1980 
http://www5.statcan.gc.ca/cansim/a33?RT=TABLE&themeID=3059&spMode=tables&lang=eng 
There seems to be a break between 1980 and 1989 (where data begin in 385-0002)”