Canadian Dollars Spent on Plastic Surgery

Question:
Does anyone know of a table that gives the amount of Cdn dollars spent on plastic surgery?

Answer:
From our end here at Stats, unfortunately we weren’t able to come up with anything beyond a regular google search. There are no surveys that collect this information.

Follow-up Answer:
You may wish to take a look at CIHI’s National Physician Database, 2016-2017: Data Release | Supply, Distribution and Migration of Physicians in Canada, 2017 : Data Tables and Physicians in Canada, 2017: Summary Report.

National Graduates Survey - 2015 Data Availability

Question:
The National graduates survey, profile of graduates who owed money to government student loans at graduation, by province and level of study Table: 37-10-0038-01 (formerly CANSIM 477-0070) is supposed to have a frequency of being updated every 5-years. The most recent data on the Statistics Canada webpage is for 2010.

Is the 2015 data available? If it is where would one locate it?

Answer:
The 2015 PUMF is expected to be released in November.

Input-Output Model Simulations (National Model)

Question:
I have a graduate student who would like access to the Input-Output Model Simulations (National Model) – 15F0004X (https://www150.statcan.gc.ca/n1/en/catalogue/15F0004X). I do not see this particular product on the FTP site or odesi, so I am wondering if this is something that can be obtained via the DLI. If not, how might the student go about getting it?

Answer:
Unfortunately on our end, this is only available via custom tabulation. Please see below for the response from subject matter:

“The Input-Output model is not available for distribution. We offer input-output modeling service on a cost recovery basis.”

If the student happens to be interested in going this route, please let me know and I will put you in touch with them directly.

Labour Force Survey Custom Tab Questions

Question:
I have a researcher who is interested in a custom tab from the Labour Force Survey. Can you confirm that the following would be available as a custom tab?

He is looking at assessing socio-economic impacts of changes in the forest products sector – both mill closures and start-ups of new biorefinery ventures – and would like to develop a socio-economic index (or measures) that can be incorporated into Canmet ENERGY (part of Natural Resources Canada) I-BIOREF biorefinery simulation model.

Here are the specifications for the data he is interested in from the LFS. The attached excel file provides an illustration of the data output framework that he would like to see. It also includes a list of all the NAICS and NOC codes he is looking for.

• Number of total workers (all industries)
• Employment income (all workers/all industries)
• Number of workers by industry – NAICS
• Total Employment Income by industry – NAICS
• Number of Employees by Occupation – NOC
• Highest level of Education attainment
• Geographic areas – the CA’s specified will be the focus of case study examinations within my research because each exhibits particular characteristics of change / rejuvenation with respect to the forest sector. The CA’s are: Corner Brook, NL; Val d’Or, QC; Thunder Bay, ON; and Prince George, BC. Additionally, it would also be very useful to obtain the data for two Census Subdivisions in Québec – La Tuque and Matagami – as these two communities exhibit forest industry change characteristics that are not readily observable elsewhere.
• Time frame – the overall time period of focus / interest is 2000 – 2017. Monthly data is not essential – annualised or December end-of-year data would work just fine. My objective in pursuing the LFS data is to obtain more frequent tracking of changes in the communities than is achievable from the Census data.

Answer:

I’ve received the following response from subject matter:

“The level of detail requested is too high for the CA geography.

The Labour force survey is not designed for this level of granularity.”  

Data on transportation of goods (maritime, railways, etc.)

Question:
A student at M.Sc in Operations and logistics is searching for data on freight flows (volumes of consumers, industrial, material goods).

He’s starting point is the Port of Montreal. He’s looking for any data on where all those goods go, which mode of transportation is used and what is their final destination.

I have sent the information from the Port of Montreal, but it’s incomplete as to the origin of the products and where they are going.

I’ve found the table 23-10-0216-01, but it doesn’t offer the port of origin. I’ve also found the Canadian Freight Analysis Framework.

I’ve sent all these resources, but for my students, it’s incomplete.

Would you have any suggestions I might refer him to?

Answer:
I apologize for the delay – I had a meeting with the individual responsible for creating the data files for very similar subjects in the past, and he is extremely excited about the prospect of someone looking for more!

Unfortunately what IS available wouldn’t be publicly accessible… Only accessible via the RDCs. In saying that however, the data is not currently IN the RDCs (it would need to be completed before-hand). This isn’t necessarily the answer I’m sure your student is looking for, however I’ve been given a few different resources that will hopefully help some:

For starters, please check out the following NATS website: http://nats.sct.gob.mx/language/en/ (the Data Tables section offers quite a lot!)

I was given the table 6-3a to pass along that might be useful as well (see attached). This was not accessible for me via the website, but hopefully the student has better luck.

Finally, I am attaching the 2011 Marine Origin and Destination tables (Domestic and International). There is MORE information than just Montreal in these documents, and although they are a little outdated, hopefully they will be of some use.

At this point in time there isn’t much else that we could help with, however the team responsible for creating these resources are very motivated to develop new data and would love feedback if the student had any interest!

*Original Email included attachments*

Canadian Freight Analysis Framework

Question:
One of our patrons is interested in inter-regional trade, and is currently using the Canadian Freight Analysis Framework (https://www150.statcan.gc.ca/n1/pub/50-503-x/50-503-x2018001-eng.htm). I’ve checked the master spreadsheet and there doesn’t appear to be anything else available via the DLI, nor does it seem to be available via the RDD, but I thought I would check with you.

Specifically, the patron is hoping for a more disaggregated SCTGGroup, the type of commodity shipped.

Answer:
I had quite a lengthy chat with one of the subject matter experts in this area and unfortunately we were not able to come up with anything that would have met this individual's needs. I sent an email earlier this morning on a similar subject that contained a few resources that may also be helpful for your researcher, but nothing containing inter-regional trade unfortunately.

Sorry we couldn't be of more help! I was told that this may be revisited in the future however (and these types of questions/interests help get the project moving!)

Canadian International Merchandise Trade Database

Question:
Is it possible to have:

• Imports
• by Country

*by 10 digit level, specifically for 4412319013 Plywood, mahogany from the Canadian International Merchandise Trade Database?

Answer:
I’ve received the following response from subject matter:

“The request mentioned below is possible but entails more information.

We would need to know:
- The years required
- Monthly or Yearly

Other variables available for Imports are:
-          Country of Export
-          Country of Origin
-          Port of Entry/Clearance
-          Mode of Transport
-          US State of Export/Origin
-          Duty Collected
-          Freight
-          Unit of Measure
-          Quantity
-          Value
Please send the above variables to the client as well as what years they need and if its monthly/yearly.

Follow-Up Question:
Researcher replied with:

Range of Years - latest 5 complete years available;

Data: Yearly (imports of only 4412319013);

Unit of Measure - sheets of plywood (all sizes, most common measure 4'x8'/metric equivalent, all thicknesses, usually between 6mm and 18mm);

Quantity - Total number of sheets;

Value - Total $ CAN assessed and basis of value (eg, Retail Sale in Canada or other basis)

Follow-Up Answer:
I’ve received the following response from subject matter:

“I have looked into this data request and there are some issues with the requested data (please see in red),

Imports
Year: 2014-2018
Yearly
HS10: 4412319013
Unit of Measure: The unit of measure  is associated with the HS code for the commodity. Please refer the client to chapter 44 of the HS classification. I took a brief look and it looks like it’s mostly identified as 6mm in thickness size, but the unit of measure for these commodities is MTK ( Square Metre )
Quantity: The quantity doesn’t focus on number of sheets, only on square metre.
Value ($CDN) "

Follow-Up Question:
Bonjour/Hello,

Researcher would like another quote for just:
Total square meters of this marine plywood, 4412319013, imported into Canada in 2018
Quantity: square metre
Value ($CDN)

and assumes the value is wholesale, (not retail), correct ?

Follow-Up Answer:
I’ve received the following response:

“Unfortunately, I am unable to answer the clients question inquiring if the value is wholesale and not retail. If the client would like to seek further clarification on that specific subject matter, I would suggest contacting MWTD.


As for the price of a custom tabulation including the year 2018, the cost will remain [the same] (plus applicable tax).”

Provincial Electoral District Census Profiles

Question:
I am assisting an economics student on a research question based around census profiles (that include ethnic origin and place of birth questions) around provincial electoral district boundaries. This is easily do-able for federal electoral districts –but I haven’t found a consistent methodology for provincial electoral boundaries. Some provinces have posted profiles on their own portals –not sure how consistent the methods are. Perhaps there’s a collocation of that I’m unaware of.

• https://www.bcstats.gov.bc.ca/statisticsBySubject/Census/2006Census/ProvincialElectoralDistricts.aspx
• https://open.alberta.ca/publications/alberta-provincial-electoral-division-profiles-2016-2019-boundaries
• https://www.gov.mb.ca/mbs/reports/ped_profiles.html
• https://www.electionsquebec.qc.ca/english/provincial/electoral-map/socioeconomic-files.php

I have reached out to explore the researchers openness to a geospatial approach since most of the boundary files seem to be available.

Answer:
We’ve had the following information passed on:

“As long as all of the PEDs are available online via open data, we could create a national or provincial files. We don’t currently have PED boundaries other than Ontario (which we have created and have permission to use for other organizations).

I checked with one of our geographers, and she provided the following additional information:

If the files are retrieved via open data portals I don’t think we would need permission to use them.  It doesn’t seem that there is a standard methodology, other than provinces aiming to have representation by population. From the quick look I took at the BC PEDs, the boundaries do not follow any SGCs. Provinces also amend and update boundaries at different times. For example, BC updated their PEDS in 2015, Manitoba in 2018.   I would need to consult with the client to find out if they wanted the most recently updated boundaries, or the boundaries used in the last provincial elections.

All that to say is yes, we can create them.  This would be a cost-recovery activity so there would be a charge for the work.”

Spending on Child Care Services

Question:
I’m assisting a researcher who is looking to answer “how much net out of pocket spending (pretax) do individuals by gender and by household composition spend on paid child care services?”. I have recommended the 2016 Census PUMF, but the researcher is looking for 2017 data from the Survey Household Spending if possible. It’s not feasible to wait until the fall for the SHS PUMF to come out. What would the timeline and cost be for a custom tab?

Answer:
Hello, there is a new survey that was released April 10, 2019: Survey on Early Learning and Child Care Arrangements (SELCCA) that should be able to answer these questions. It is available in the RDCs and will be available in the RTRA program shortly.

This is a link to the Daily release https://www150.statcan.gc.ca/n1/daily-quotidien/190410/dq190410a-eng.htm  and to the survey information: http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=5287. We can let you know once it is in RTRA.

Follow-up Answer:
We can otherwise pursue a custom tab if the researcher wants it from the SHS instead.
We’ve received the following response:

“The table attached to this email includes data pertaining to the 2017 SHS by Gender for Child Care Services. Should they require more data than that which is provided here, we can certainly look into performing a custom tabulation.”

Input-output table in NAICS

Question:
I am working as a trade policy analyst at the OECD.

For a current research project I am looking for a Canadian input-output table (or supply and use tables) in the NAICS classification (3-digits or more) for a year before 2003. I would only need it for one year but I have been struggling to find these data in the NAICS classification.

Answer:
Would you be able to confirm the following:

“Does the individual need industry by product supply and use tables or industry by industry symmetric input-output tables?”

I should be able to get these on the EFT today or tomorrow, just let me know which they’d like!

Follow-up Response:
They would like - ‘’Industry by industry symmetric input-output tables would be ideal; in the NAICS classification (3-digits) for a year before 2003 (e.g. 2002).’’

Answer:
I’ve placed them on the EFT here: /MAD_DLI_IDD_DAM/Root/other_autres/1401_IO_ES/15-207-X - 2002 National Symmetric Input-Output Tables - L61 Level

Quarterly GDP Data for Alberta

Question:
I have a student looking for quarterly GDP for Alberta from 1999 to 2017. I have been able to find annual rates (from Open Data Alberta) and quarterly national data, but I seem to be coming up completely blank on quarterly provincial. Can anyone point me in the right direction?

Answer:
We’ve received the following response from subject matter:
“The national accounts does not produce quarterly provincial GDP estimates.”

Trade Data - SK exports

Question:
I am looking for the annual total volume (quantity) of exports (all products so all HS codes) originating from Saskatchewan broken down by destination (country). I am hoping to include as many years as possible, for this project the more data that is available the better, i.e., as far back as possible.

Answer:
We've received the following from subject matter:

"If they need data broken down by HS codes, the most efficient way to proceed is by custom tabulation. I could run a table for exports of all HS codes by Country of Destination, with Saskatchewan selected as the Province of Origin. Such data is available all the way back to 1988 and is available on a cost-recovery basis at $416.35 per bundle of 5 years of data. If they’re interested, I’d need to know which level of HS detail they need. If they need very detailed data (i.e. at the HS8 level), it might not fit in a single Excel table.

If they need data but have no funds, the only “alternative” I can think of is table 12-10-0119-01 (https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1210011901), which has data at the provincial level, but only for principal trading partners (top 25 or so) and under the North American Product Classification System (NAPCS) instead of the Harmonized System. The NAPCS uses broader product categories than the HS and can be more efficient when comparing different categories of products. The data in there is also on a monthly frequency so they would need to aggregate some data themselves."

GDP 1945 to present

Question:
I have a researcher looking for:

“So the data I need is GDP from 1945 to present - either all nominal or all 'real' (chained dollars). 

And I also need GDP broken down into the 4 categories - consumption, investment, net exports and government spending - as a percentage of total gdp. So for example it would show consumption as being 20%, investment 30%, government 40%, net exports 10% . 

Also preferably from 1945-present. “

Most GDP tables I see only go back to 1997.

There are a few tables (36-10-0239-01, 36-10-0240-01 and 36-10-0268-01)  (Cansim 380-0001, 380-0002 and 380-0030) that cover 1961 to 2012.

I identified these tables by looking in the Canadian Economic Observer Historical Statistical Supplement.

However, there do not appear to be any tables that I see which go back to 1945 and continue to the present, not to mention the four categories the researcher wants.

Am I missing anything?   I suspect that the researcher will not get exactly what they want, so is there any advice I can pass on to this researcher?

Answer from subject matter:
“For calculating percentage shares, the researcher should use estimates based on current prices (not real or chained dollars). Compatible data for earlier years—CANSIM 380-0064--are expected to be released in August.

Table: 36-10-0104-01 (formerly CANSIM  380-0064)

Geography: Canada

Prices [Current prices \/]”

Answer from DLI:
[Someone] also pointed me to an article on GDP in the Canadian Encyclopedia.   

Canada's GDP, 1870 to 2016.   https://www.thecanadianencyclopedia.ca/en/article/gross-domestic-product

This entry has a chart, which references Jorda et al., 2017.  This lead me to:

• Jordà-Schularick-Taylor Macrohistory Database   http://www.macrohistory.net/data/
• The dataset “Real Economy” includes GDP-nominal and GDP per capita.  For Canada, it covers 1870-2016 in  .xls and .dta formats.

Refugee Resettlement Data

Question:
I am working with some students who are doing a thesis project pertaining to refugees in Canada.

They have been looking at summary tables at  Immigration, Refugees and Citizenship Canada.

They are looking for more specific information that would outline actual expenses for different items, specifically:

...under Consolidated Statement of Operations and Departmental Net Financial Position, Newcomer Settlement and Integration and Refugee Protection, they would like to know if they could obtain:
1. this information for the date range of 1980 - 2015
2. further breakdown of Newcomer Settlement and Integration expense to % spent on refugees specifically v. all other newcomers.

Does anyone have any experience locating this data?

Answer:
Unfortunately it looks as if you will have to contact IRCC directly with this one: https://www.canada.ca/en/immigration-refugees-citizenship.html

Company E-commerce Data

Question:
Can anyone suggest where a student might find information about WalMart CANADA ecommerce  and retail data.  Is it possible to know which company in Canada is first in ecommerce?  I know Stats Can does provide company names.  Google searches come up with Statista which looks pretty good but we don't subscribe.  Any or all ideas are welcome.

Answer:
Here is the response from subject matter:

“Due to confidentiality, we cannot comment on specific companies.
That said, we do have a Partial list of Retail Chain Stores from our website and in relation to our Annual Retail Trade Survey table 20-10-0066-01.
He may also want to have a look at our tables on e-commerce 20-10-0065-01 (Annual) and 20-10-0072-01 (Monthly), maybe could be of use to him.
Also, from our website, you can suggest that he does a search by keyword(s) ‘’Annual Retail’’, ‘’Monthly Retail’’ and a lot more tables will show up.”

Historical Real Estate Data

Question:
A student is looking for historical prices for real estate prices in a neighbourhood in Montreal (Plateau Mont-Royal) from 1951 to this day. I do not believe this data is readily available, but I wanted to double check with the community. As far as I know, the best sources are:

MLS data (HPI tool: Monthly data from 2005 to 2018)
https://www.crea.ca/housing-market-stats/mls-home-price-index/hpi-tool/

Residential Property Values (yearly data from 2005 to 2015, by provinces and census metropolitan areas)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3410001301

Is there anything that goes further back than 2005 and that drills down to boroughs/neighbourhoods level (or at least CSD level) ?

If not I may contact the people at CREA (https://www.crea.ca/) who are in charge of the MLS data, but I wonder how far back their database goes.

Answer from DLI:
Have you tried the Royal Lepage Historical Database? It has prices for the Montreal Area (so I don’t think it goes down to neighborhood) back to the early 1970s.

If you don’t mind the approximation: “Value of dwelling (If you were to sell this dwelling now, for how much would you expect to sell it?)” and the five year jumps, you might consider Census Tract level Profile tables.

Answer from Subject Matter:
Here is our response from subject matter:


“There is nothing else available than the links below.  There is certainly no data before 2005, however there may be more details available in the future in terms of neighbourhoods in Montreal, in a few years.”

Historical Capital Gains Data

Question:
I have a researcher who is looking for historical statistics on capital gains reported by individual taxpayers. Table 11-10-0048-01 (formerly CANSIM 111-0042) contains exactly the information needed, but only goes back to 2000: https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1110004801

Is there any way of gaining access to this same data going back to 1972? I have looked in the older print catalogues and cannot find anything similar. We have located capital gains data that was published directly by CRA/Revenue Canada for the period he is looking for, however the method of representing the data is different. Statistics Canada publishes the actual amount of capital gains reported, while CRA figures show the taxable amounts of capital gains after the inclusion rate has been applied.

Answer:
Here is the response from subject matter:

“Capital Gains only begins with reference year 1998, therefore I enclosed 1998 and 1999, English version.  Please advise if you need these tables in French also.

There is no data prior to 1998.”

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.”

Cement Survey

Question:
I’m helping a researcher who is interested in the following table of data from the Cement Survey: https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1610004301. He was really hoping to obtain numbers for the row on “Clinker” (last row in the table), and we are curious whether a custom tabulation of this data aggregated by year instead of month would allow for the clinker numbers to be released?

Also, is there any way to access microdata for the Cement Survey?

Answer:
Subject matter has informed us that unfortunately, the data for clinker could not be released even if it was aggregated to annual data. The only way that a researcher could access this data is if they were to enter in a contract with STC  do some analysis through the Canadian Centre for Data Development and Economic Research (CDER). Please see the following links for CDER proposal requirements: http://www.statcan.gc.ca/eng/cder/prop and http://www.statcan.gc.ca/eng/cder/price.

Any proposal for submission must have sufficient details, so as to determine the feasibility of the project. This will include a data perspective, costs, and professional merit. Note that CDER only considers research projects that are not descriptive in nature.

CDER is run on a cost-recovery basis; as such, all researchers must be able to cover all project costs, including the cost of having their project proposals peer and committee-reviewed.

The costs of a project depend on a variety of factors such as
1. length of time required to access the CDER facilities
2. whether the data set exists or needs to be developed
3. how much output needs to be reviewed for confidentiality.

This means that there is no standard project cost. Each project will be reviewed by CDER to determine the individual cost. Here are some elements to consider for a simple project:
•whether a project makes use of an existing database
•whether the project can be completed in 3 months (66 days)
•if the expected output of the project would take no more than 2 days for a Statistics Canada analyst to review for confidentiality issues
•if there are project submission fees (see below)
•whether there is a need for housing the researcher(s) and providing them with access to CDER facilities (office workspace, workstation, server, data storage, etc.), which is the largest element affecting the cost

Based on current costs, a simple project, such as the aforementioned would cost approximately $7,200.00.

Transfer Payments

Question

I am currently working on a project related to Canadian Government's expenditures. I am trying to find annual data, preferably from 1976 to 2013, about government actual expenses on social policies, such as child related transfers to families, or public income support payments during periods of maternity and parental leave.

I found these tables from CANSIM (there is no data available from 1981-1988 or after 2009 when the series was terminated):

- Federal government and government sector revenue and expenditure, annual (Dollars), 1961 to 1980 <http://www5.statcan.gc.ca/cansim/a26lang=eng&retrLang=eng&id=3840022 &tabMode=dataTable&srchLan=-1&p1=-1&p2=9>

- Federal, provincial and territorial general government revenue and expenditures, for fiscal year ending March 31, annual (Dollars), 1989 to 2009 <http://www5.statcan.gc.ca/cansim /a26?lang=eng&retrLang=eng&id=3850002&tabMode=dataTable&srchLan=-1&p1=-1&p 2=9>

If you could advise anything further that would be great.

Answer

You may have noted in the CANSIM table 385-002 that the 385-XXXX series was compiled under the old Financial Management System framework. Statistics Canada is adopting the international standard Government Finance Statistics. More information on this can be found here:

- Moving from the Financial Management System to Government Finance Statistics - http://www.statcan.gc.ca/pub/13-605-x/2010001/article/11155-eng.htm.

See release notice of the GFS in the Daily - Canadian Government Finance Statistics, 2008 to 2012 (provisional):
<http://www.statcan.gc.ca/daily-quotidien/141119/dq141119a-eng.htm>

Note: The data sources, methods and concepts that underlie the CGFS-based data depart significantly from the Financial Management System (FMS)-based data previously published by Statistics Canada.

Available in CANSIM: tables CANSIM table385-0033 to 385-0039 <http://www5.statcan.gc.ca/cansim/a03?lang=eng&pattern=385-0033..385-0039&p2=31)>. Definitions, data sources and methods: survey number5218 <http://www.statcan.gc.ca/imdb-bmdi/5218-eng.htm>

The Add/Remove Data Tab has more options with respect to Statement of government operations and balance sheet. If the user wants more detailed information, if available, it would require a custom tabulation.