The Input-Output tables 2010

Please note the updated products listed below and the path to access them via the EFT site

Input-Output Structure of the Canadian Economy in Current Prices

The Input-Output tables are the most comprehensive and detailed statistics on transactions involving production activity and intermediate as well as final consumption of goods and services in the economy.

The input-output accounts of Canada and its provinces and territories are presented in three main data tables (matrices) for each jurisdiction.
These are the output table, input table, and the final demand table. In addition, provinces' and territories' tables are linked together through an interprovincial flows table that shows each jurisdiction's exports to, and imports from, other provinces and territories as well as abroad.

Input-Output tables cover all economic activities conducted in the market economies of each province and territory, encompassing persons, businesses, government and non-government (non-profit) organizations, and entities outside its jurisdiction that give rise to imports or exports (inter provincially or internationally.)

The Input-Output tables represent the most detailed accounting of the Canadian economy available and thus serve as benchmarks to the Canadian System of National Accounts.

National tables are produced on an annual basis (starting with the 1961 reference year) and completed in June each year with a 30 month lag from the reference year. Provincial tables are produced annually (starting with the 1997 reference year) and released together with the national tables in November of each year with a 34 month lag from the reference year.

EFT: /MAD_DLI/Root/other-products/Input-Output-Tables/2010

2008 Canadian Financial Capability Survey

Question

How can we get a copy of the 2008 Canadian Financial Capability Survey:
<http://www62.statcan.ca/webview/index/en/MyServer/Statistics-Canada-Public-Use-Microdata-Files.c.MyServer/Canadian-Financial-Capability-Survey-CFCS-.d.643/Canadian-Financial-Capability-Survey-2008/fStudy/cfcs2008>?

Answer

We do have the survey of 2008 in the DLI collection (/MAD_DLI/Root/other-products/Canadian Financial Capability Survey - cfcs/2008). The next survey will be released in November 2014 <http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=5159>.

Canadian Community Health Survey - Mental Health and Well-being - Canadian Forces (CCHS-CF)

Question

I have a graduate student who is looking for datasets related to members of the armed forces, in Canada or the US, including health and mental health.

I noticed that Cycle 1.2 of the Community Health Survey looked at a representative sample of the Canadian Forces population, Canadian Community Health Survey - Mental Health and Well-being - Canadian Forces (CCHS-CF) - <http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=5084>. When I look at CCHS Cycle 1.2 I could not find variables for Canadian Forces, and it specifically states that members of the Canadian Armed Forces are excluded from the sampling. Does anyone have any idea where or if this data is available? Or suggestions for an alternative dataset?

Answer

From the guide found at the bottom of the link you gave: (First paragraph and last paragraph of the Description section) In Cycle 1.2 of the Canadian Community Health Survey (CCHS),
an additional component was administered to a representative sample of the Canadian Forces (CF) population. This is known as the CF Component. 

One of the exclusions of the core CCHS target population is full-time members of the regular Canadian Forces.

As the Department of National Defence (DND) wanted to be able to provide reliable, comparable information for the Canadian Forces, DND contracted Statistics Canada to undertake a special survey component with a representative sample of the Canadian Forces, both regular and reservist members.

Mental Health and Well-being – CF Component has analogous objectives to those of the CCHS, against which results can be compared – to estimate the prevalence of certain mental disorders in the Canadian Forces and record members’ utilization of mental health services.

This information is intended to assist in the determination of mental health care needs in the CF and to allow DND planners the crucial data they need to ensure adequate resources.

Further, do not forget that this came out not to long ago, <http://www.statcan.gc.ca/daily-quotidien/140811/dq140811a-eng.htm>


We had a similar question in the past year. Below, you will find clues to the existence of data found in the secondary literature.

<http://epe.lac-bac.gc.ca/100/201/301/weekly_checklist/2013/internet/w13-51-U-E.html/collections/collection_2013/bdp-lop/eb/2013-91-eng.pdf>
<http://epe.lac-bac.gc.ca/100/201/301/weekly_checklist/2013/internet/w13-50-U-E.html/collections/collection_2013/bdp-lop/bp/2011-97-1-eng.pdf>
<http://publications.gc.ca/collections/collection_2011/dn-nd/D2-293-2010-eng.pdf>
<http://publications.gc.ca/collections/collection_2007/lop-bdp/prb/PRB0720-e.pdf>

In October 2013, the CAF Surgeon General’s Mental Health Strategy  was released. Based on a number of internal and external studies, the Strategy gives an assessment of the current state of mental health in the CAF, and provides guidance for the delivery of services and the prioritization of resources and research over the next five years. It is important to note that Afghanistan-related OSIs are a minority of the mental health conditions present within the CAF population. According to the Mental Health Commission of Canada, one in every five Canadians will experience a mental health condition in their life time. The Canadian Community Health Survey – Mental Health and Well-being – Canadian Forces (CCHS-CF) conducted by Statistics Canada in 2002 showed that CAF members exhibited double the risk of depression, both related and unrelated to military operations, as compared to the Canadian population.15 Therefore, CAF health services must have the ability to treat “a far greater” mental illness burden that is not related to combat or deployment operations.16 Unfortunately, the Statistics Canada survey did not capture data with respect to determining whether the OSIs suffered by CAF personnel were specifically related to deployments to Rwanda, Bosnia, or other locations. The only mission-specific OSI data the CAF holds is from its report entitled Cumulative Incidence of PTSD and Other Mental Disorders in Canadian Forces Personnel Deployed in Support of the Mission in Afghanistan, 2001–2008. The report, by David Boulos and Dr. Mark Zamorski, indicates that out of about 30,000 CAF personnel deployed to or in support of Canada’s mission in Afghanistan before 31 December 2008, 13.2% were diagnosed with an OSI in the 5 years following that deployment. This included 8% diagnosed with PTSD and more than 5% with other types of deployment-related OSIs, such as depression and anxiety disorders.17 BGen Bernier informed us that once extrapolated to approximately 9 years post-deployment, the
percentages increase to 20% for OSIs and 11.8% for PTSD. In comparison, the lifetime
prevalence of PTSD in the general population is 7% to 9%.18 The report also indicates that
when deployment and non-deployment related mental illnesses within the cohort are taken into account, the figure rises to 18.9% for PTSD. Another report by the same authors
extrapolates that those who deployed to Kandahar specifically have close to a

14 Department of National Defence, Guide to Benefits, Programs, and Services for Serving and Former
Canadian Armed Forces Members and their Families, November 2013 Edition.
15 BGen Jean-Robert Bernier, NDDN Evidence, 41st Parliament, 2nd Session, Meeting No. 19, 8 April 2014.
16 Ibid.
17 Department of National Defence, Cumulative Incidence of PTSD and Other Mental Disorders in Canadian
Forces Personnel Deployed in Support of the Mission in Afghanistan, 2001–2008, Canadian Forces Health Services , November 2011.
18 BGen Jean-Robert Bernier, NDDN Evidence, 41st Parliament, 2nd Session, Meeting No.19, 8 April 2014.

30% possibility of developing an OSI nine years post-deployment.19 The limitations of these studies include the inability to capture those who have not sought care, who have sought care outside CAF health services, or who were released shortly after their deployment.

The DND/CAF Ombudsman has also been engaged in CAF mental health issuessince 2002. He has released 5 different reports and almost 50 recommendations intended
to improve the care and treatment received by CAF members suffering from OSIs,including PTSD. The 2012 report Fortitude Under Fatigue,concluded that the CAF made considerable progress in implementing previous recommendations with respect to the identification, prevention, and treatment of OSIs. The report also identified a number of broader areas of improvements, including the evolution of the CAF’s mental health capability from an ad hoc system to one that is better structured to deliver integrated care to CAF members suffering from OSIs, including PTSD. The challenges that remain are addressed in this report.

CAF health services are the primary health care provider for all CAF personnel whether their health concerns are duty related or not. If necessary services arenot available within the CAF system, military members are reliant on civilian provincial/territorial health authorities. Every military member is insured by a third-party insurer, currently Blue Cross, which covers the cost of external health care treatments for DND. Since the closure of CAF hospitals, and given that 80% of military members and their families live off military bases, there is an increased dependence on provincial/territorial health care services and support systems than ever before. This is an overarching challenge that touches not only the care of ill and injured CAF personnel, but also the care of their family members and reservists.<http://epe.lac-bac.gc.ca/100/201/301/weekly_checklist/2014/internet/w14-25-U-E.html/collections/collection_2014/parl/xc34-1/XC34-1-1-412-4-eng.pdf>Caring for Canada’s Ill and Injured Military Personnel p. 5-6

-Unfortunately, a PUMF will not be created for the Canadian Forces Mental Health Survey, access to the masterfile will be available through the Research Data Centers (RDCs).

Wood Pellet Use on Aboriginal Reserves

Question

Just wondering if anyone would have any suggestions where I could find info on Wood Pellets use on Aboriginal Reserves. I have searched CANSIM and found some information but, my researcher would like more.

Answer

The Environment, Energy and Transportation Statistics Division does not have data on this. The Households and the Environment Survey, which has data about wood pellets, does not cover Aboriginal Reserves. 

The Aboriginal Statistics Division does not go on reserve with their surveys.The NHS includes reserve, therefore if it’s not they won’t have it.

I would recommend contacting Aboriginal Affairs.

Childhood National Immunization Coverage Survey

Question

I have a researcher interested in accessing data from the Childhood National Immunization Coverage Survey.This is not available via the DLI--is this is something that can be accessed at an RDC? Barring that, is a custom tabulation available?

Answer

There was no PUMF file created for the 2011 CNICS and we have not provided the Master file to the RDC. The 2014 CNICS survey is still being processed. I do not believe we have an official release date booked yet but a 2014 Master file could be available in early 2015.

Custom tabs are available at the cost of $73.02 per hour plus tax if applicable. The SSD requires detailed specifications before providing a cost estimate and timeline if the sample size is large enough to provide any reliable data.

Households and Environment Survey 2011

Question
I have a question about the PUMF for the 2011 HES. In the 2011 file there does not seem to be a CMA variable, the only geographic variable is Province of residence. This a bit strange a CMA variable was included in previous years of the survey (2009, 2007 and presumably 2006). Also, the User Guide for the 2011 PUMF mentions in section 7.4 (table of derived variables), page 16, that there is a CMA variable: CMA - Census Metropolitan Area (CMA) - 2006 Census Code .

Can someone confirm that this variable was not included in the PUMF and if so why did it appear in the previous years but not in 2011?

Answer

An updated file, Households and the Environment survey (Version 2), was released last spring (see attached announcement), which includes the geographic variable “Census Metropolitan Area (CMA)”.

Available here:

EFT: /MAD_DLI/Root/other-products/ Households and the Environment Survey-hes/2011

The updated version is also available on DLI’s Nesstar.

Rice Wine Imports and Consumption Data

Question

I have a student looking for information on types of wine imports and consumption in Canada,by province if at all possible. Here is a lightly edited version of what she is after:
The amount of commercially imported sake [rice wine] to Canada. At the provincial level, if possible. And for the last few decades. If it is possible, I would like to find the amount of sake consumed in each province (to see which province is consuming sake most and least) to compare these numbers with other products like grape wine. Thus, if I can get numerical data for grape wine import and its consumption in Canada, that will be great.

I'm not sure how to go about finding import and/or sales numbers for sake [rice wine].
Can I find numbers for so detailed a product type?

Answer

Please note that we do have figures on consumption or sales. The student will be able to retrieve free data at the HS06 level from our Canadian International Merchandise Database (CIMT) online:
-sake is classified within HS06 220600,
-grape wines are classified from 220410 to 220430
(see attached tariff manual for complete list of codes.

Note that if the client wishes to have a more detailed data table at the HS10 level, there will be a cost involved.

Below is the link to our Canadian International Trade Database (CIMT) to retrieve free HS06 trade data:
<http://www5.statcan.gc.ca/cimt-cicm/home-accueil?lang=eng>

1. Retrieve your data with one of the following options:
     -Option 1: Select trading partner -
      Select a trading partner and specific variables (e.g., country, province, state, year,                 month, or frequency).
     Click on the appropriate button to either "Retrieve" the data or "Save as spreadsheet            (CSV)" .
    -Option 2: Search by commodity or Harmonized System code" -
     Click on "Search" and then on "Domestic Exports", "Re-exports" or "Imports" next to the        commodity of your choice.
 Use the multiple drop-down menus to change variables.

In some instances, hyperlinks are available and enable you to drill down to lower levels of detail. For example, clicking I-Live Animals and Animal Products shows a breakdown of all the commodity chapters found in that section, offering access to more detailed information.
Use the buttons "Retrieve" to retrieve a different variable selection from the drop down menus "Save as spreadsheet (CSV)" to save in tabulation compatible document and/or "Start Over".

To obtain more information on international trade concepts, commodity classification, releases and revisions, please click on the related buttons in the left-hand side menu.