Wednesday, October 10, 2018

Research & Development and Money Spent in Energy Efficiency Programs

Question:
I have a client who is looking for the following information: 

“I was trying to find at StatsCan if they have the numbers of how much of R&D is being spent in Energy Efficiency programs and what programs, if possible, segregated by province. I found a general expenditures table (https://www150.statcan.gc.ca/n1/daily-quotidien/180828/cg-b001-eng.htm), but I wanted to find something more specific on the provinces and programs as well. Do you think this kind of information is available?”


Answer from DLI:

Good question.  I hope StatCan is gathering this from different sources.  I noticed that the federal government reports on this, but this excludes non federal government R & D investments.

In case you run into roadblocks, Natural Resources Canada’s Office of Energy Research and Development (OERD) is the Government of Canada's co-ordinator of energy research and development (R&D) activities. [https://www.nrcan.gc.ca/energy/offices-labs/oerd/5711] Please see the reports / publications to the right.  This will exclude other funders. 


I don’t know if this next source is overly narrow I think because it includes only NRCan as a funder but it breaks down into technology areas [https://www.nrcan.gc.ca/energy/funding/21146] and by Locations (provinces).  On the other hand, I’m not sure there are other targeted energy efficiency R & D programs. 


Answer from Subject Matter:

“No – we do not provide any detail on energy-related R&D expenditures at the provincial/territorial level.

Table 27-10-0347-01 does provide a breakdown by area of technology.  This is the lowest level of detail we provide for energy-related R&D expenditure data.”

Friday, October 5, 2018

Commercial Real Estate

Question:
I have a researcher looking for a dataset which gives the the value or rent of commercial properties by CMA or Census Subdivision from 2006 to present. An example would be annual average rent of office space per sqf. From Statistics Canada I think that the Commercial Rents Services Price Index may work, but I can only find data for Canada and not by any smaller geographies (ex. Table 18-10-0065-02). Would it be possible to get this data by CMA or Subdivision? Would any one from the community be able to suggest any alternative data sources?

Answers from DLI List:
I hope the Commercial Rents Services Price Index works for your data question.  If not, we might to look at CREA or BOMA[http://bomacanada.ca/] for this?

You might have the researcher contact the Toronto Real Estate Board to see if they can provide some data: http://www.trebhome.com/

I occasionally wander over to this site, to try some of the non-government sources within, for questions such as these:

"Global Property Guide:  Financial Information for Residential Property Buyers"
< https://www.globalpropertyguide.com/North-America/Canada/Useful-Links/Economics,-Statistics,-Property-Price-History;1  >

** Can't vouch for the veracity of the hosted sites and/or the comprehensiveness of the list, but it does give lots of places to explore!  **

Answer from Subject Matter:
“The Commercial Rents Services Price Index (CRSPI) measures price changes of commercial rents over time.

It is published at the national level for all buildings combined (Office buildings, Retail buildings, and Industrial buildings and warehouses).

Prices per square foot are not published at the CMA level.

 However, to meet you data needs (CMA level price per square foot for office space), please refer to CBRE (www.CBRE.ca, under research centre) or Collier International (www.collierscanada.com, under research section).”

2016 Census Availability

Question:
I’m looking for Census data but I completely confused by the EFT, and I have no clue what’s actually available at this time. Here is my researcher’s request:

I also need the Census Data (short+long form) for 2016, if possible for all four levels (i.e. FSA (FSA), Census Tract (CT), Census Subdivision (CSD) and Dissemination Areas (DA)).

Can anyone point me in the right direction?

Answer:
Assuming that the researcher isn't looking for a PUMF or to create cross-tabulations, you can download this data fairly easily from Stat Can's website:

  • Go to the census profile for 2016.
  • Click on "Download Census Profile data".
  • You can download all the data for a given level of geography in CSV (Excel compatible) format, or TAB or XML (anyone here ever use these?), or IVT (Beyond 20/20).

If it's a researcher that will do a lot of work with census data, I recommend they use Beyond 20/20 to shape the data the way they need, and then export right back into an Excel compatible format. I have a slightly outdated slides/screen recording of Beyond 20/20 at the top of my tutorials page (I use a CANSIM table to illustrate Beyond 20/20 functions, which is no longer possible), a longer slide deck (also using a CANSIM table as an example), and a fairly up to date exercise using a census example.

Thursday, October 4, 2018

CCHS definition of "institutionalized resident"

Question:
I'm strangely stumped: I'm unable to determine what the CCHS means by "institutionalized population" (exclusion criterion). Is it the same as "Institutional resident" as defined by the Census (https://www12.statcan.gc.ca/census-recensement/2016/ref/dict/pop053-eng.cfm)?

Answer:
We received the following response from subject matter:

“Yes it is. Persons living in institutions (for example, inmates of penal institutions and patients in hospitals or nursing homes).”

Follow Up Question:
Could I get a more precise definition of institutional as it pertains to nursing homes? I'm under the impression there's a spectrum of assisted living facilities for older adults. The researcher on whose behalf I'm asking is particularly interested in older adults and long-term care so I imagine she'll be looking for more detail.

Follow Up Answer:
We received the following response from subject matter:

“We don’t have a definition for that. We don’t currently have a survey collecting data on nursing homes. The Canadian Institute for Health Information (CIHI) collects nursing home information, they may have a definition for them.” CIHI’s general inquiry email address is: help@cihi.ca.

Wednesday, October 3, 2018

Historical data on cigarette consumption

Question:
I have a researcher looking for data on cigarette consumption in Canada from 1900-1965. Would prefer individual consumption but sales number would also work if that’s all that’s available.

We’ve already found some information in the Canada year book series, but does anyone have ideas of elsewhere this information might be?

Answer from DLI:
I came across this source:

Forey, B., Hamling, J., Hamling J., Thornton, A., & Lee, P. (2006, rev. 2012). Canada. International smoking statistics: A collection of worldwide historical data (Web ed.). Retrieved from http://www.pnlee.co.uk/Downloads/ISS/ISS-Canada_120111.pdf

·         see tables 1 and 2 which have stats from 1924 - 2010 ​

·         ​seems extremely authoritative and well-documented

Not sure about earlier years.

Answer from Subject Matter:
CTADS seems to have relevant information, however the reference periods only date back to the year 2000. SHS also seems to have relevant information, however, the reference periods only date back to the year 1999. I inquired with the subject matter areas responsible and received the following responses:

“Unfortunately, none of the surveys we have conducted go back that far… I took a look at Health Canada’s site as I thought that perhaps CADUMS would have a few more years of data but I couldn’t find anything that would clearly support this researcher’s endeavours.  I would suggest that the researcher contact HC to see if perhaps they have data more readily available.  The contact listed on the CADUMS site is:

For more information about the survey and its results, please write to the Office of Drugs and Alcohol Research and Surveillance, Controlled Substances and Tobacco Directorate, Health Canada, 150 Tunney's Pasture Driveway, Address Locator 0301A, Ottawa, ON, K1A 0K9, or send an e-mail request to CADUMS-ESCCAD@hc-sc.gc.ca.”

And

“Regrettably I have no recommendation - the SHS is limited in its timeframe scope such that it doesn’t touch upon 1900-1965; and as far as I am aware, the only available information in this regarding is sourced from the Canadian Year Book Series.”

We also received the following recommendation:

“Would CAT 11-512 be more detailed than the Canada Year Book?

If you are interested in FMX sources prior 1999, enclosed is a list of publications below.
Note: Our library have scanned the STATCAN publications.


FMX HISTORICAL YEARS

CAT xx-xxx: Family Income and Expenditure in Canada, 1937-1938 (12 cities)

CAT 62-513: Canadian Non-Farm Expenditure, 1947-48 (National)

With supplementary Food Data, 1948-1949

CAT 62-509: City Family Expenditure, 1953 (5 cities)

CAT 62-510: City Family Expenditure, 1955 (7 cities)

CAT 62-517: City Family Expenditure, 1957 (9 cities)

CAT 62-523: Farm Living Expenditure, 1958 (Farm, National)

CAT 62-521: Urban Family Expenditure, 1959 (60 urban centres)

CAT 62-525: Urban Family Expenditure, 1962 (7 cities)

CAT 62-527: Urban Family Expenditure, 1964 (11 cities)

CAT 62-530: Urban Family Expenditure, 1967 (11 cities)

CAT 62-535: Family Expenditure in Canada, 1969, VOL. I (National)

CAT 62-536: Family Expenditure in Canada, 1969, VOL. II (National)

CAT 62-537: Family Expenditure in Canada, 1969, VOL. III (National)

CAT 62-541: Urban Family Expenditure, 1972 (10 cities)

CAT 62-544: Urban Family Expenditure, 1974 (14 cities)

CAT 62-547: Urban Family Expenditure, 1976 (8 cities)

CAT 62-549: Family Expenditure in Canada, 1978, VOL. I (National)

CAT 62-550: Family Expenditure in Canada, 1978, VOL. II (National)

CAT 62-551: Family Expenditure in Canada, 1978, VOL. II (National)

CAT 62-555: Family Expenditure in Canada, 1982, (National)

CAT 62-555: Family Expenditure in Canada, 1984 (17 cities)

CAT 62-555: Family Expenditure in Canada, 1990 (17 cities)

CAT 62-555: Family Expenditure in Canada, 1992 (National)

CAT 62-555: Family Expenditure in Canada, 1996 (National)

CAT 62-203: Spending Patterns in Canada, 1997, (National, Provincial)

HISTORICAL FAMILY FOOD EXPENDITURE

CAT 62-513: Canadian Non-Farm Expenditure, 1947-48 (National)

With supplementary Food Data, 1948-1949

CAT. 62-511: Urban Family Food Expenditure, 1953 (5 cities)

CAT. 62-512: Urban Family Food Expenditure, 1955 (5 cities)

CAT. 62-524: Urban Family Food Expenditure, 1962 (7 cities)

CAT. 62-531: Family Food Expenditure in Canada, 1969, (National VOL. I)

CAT. 62-532: Family Food Expenditure in Canada, 1969, (National VOL. II)

CAT. 62-542: Urban Family Food Expenditure, 1974 (14 cities)

CAT. 62-545: Urban Family Food Expenditure, 1976 (8 cities)

CAT. 62-548: Urban Family Food Expenditure, 1978 (16 cities)

CAT. 62-554: Family Food Expenditure in Canada, 1982 (National)

CAT. 62-554: Family Food Expenditure in Canada, 1984 (17 cities)

CAT. 62-554: Family Food Expenditure in Canada, 1986 (National)

CAT. 62-554: Family Food Expenditure in Canada, 1990 (17 cities)

CAT. 62-554: Family Food Expenditure in Canada, 1992 (National)

CAT. 62-554: Family Food Expenditure in Canada, 1996 (National)

CAT. 62-554: Family Food Expenditure in Canada, 2001 (National)

Tuesday, October 2, 2018

Historical unemployment rates by UI/EI region

Question:
I am helping a researcher access Historical unemployment rates by UI/EI region from 1991 to July 1996. There’s a great website on the StatCan Website showing this information http://srv129.services.gc.ca/regions_ae/eng/rates_hist.aspx from 1996 onwards. I am wondering if this data is from the LFS –there’s no source information anywhere on the page.

Wondering if anyone has tips for accessing unemployment rates based upon the employment insurance (EI) economic regions for the period 1991 and July 1996. Prior to 1996 the Economic Region was referred to as subprovincial region https://www150.statcan.gc.ca/n1/pub/92-195-x/2011001/geo/er-re/er-re-eng.htm (although I don’t know if they are equivalent). I couldn’t find any documentation online for this census 1991 and will look in the paper tomorrow.

Some questions:

1.       Are these tables prior to 1996. If so, would they be available at the subprovincial region level?

2.       I would be interested in getting a quote for a custom tab for 1991 to July 1996 based on economic region, if possible.

3.       Source of the above table http://srv129.services.gc.ca/regions_ae/eng/rates_hist.aspx (believe the user received the link from StatCan help desk, it’s an odd url with no breadcrumbs)

Answer:
We received the following response from subject matter:

“The unemployment rate in Canada by EI Economic Regions are based on the LFS data and produced for the EI program (ESDC).

We do not produce custom data by EI Economic Regions, the only available data for which the Labour Statistics Division is responsible, pertaining to the EI Economic Regions, can be found online in table: 14-10-0354-01.

I recommend contacting Employment and Social Development Canada as they are responsible for the EI program as well as the referenced webpages containing the historical rates.”

Monday, October 1, 2018