Tuesday, August 20, 2019

New Files on Statistics Canada Nesstar

We are pleased to inform you that the following are now available on the Statistics Canada Nesstar WebView site.

  • Family Food Expenditure Survey (FOODEX) 1984, 1986 & 1990 PUMF
  • Labour Market Activity Survey (LMAS) 1988 - 1990 PUMF (English only)
  • Survey on the Importance of Wildlife to Canadians (SIWC) 1981, 1987 & 1991 PUMF (English only)
  • Survey of Volunteer Activity (SVA) 1987 PUMF (English only)
  • Travel to Work Survey (TWS) 1976 - 1984 PUMF (English only)

Monday, August 19, 2019

PCCF+ Header File

Question:
I would like so information on how to massage a pccf+ output (2006 census geo, version 5k). The preview in SAS is clear, but I generate a .csv which contains more variables (without any header) than the one that is being displayed in SAS (first 500 records). Could someone help me with this?

Answer:
I was given the following response:

“The CSV is output automatically when you run PCCF+. The output variables are indeed provided with variable names (at the top of the column), and the variables are all listed and explained in the documentation.

If the user wishes, they can import the CSV back into SAS and eliminate some of the columns, or rename their variables. This can also be done easily in Excel.

Alternatively, if they prefer the version that pops up automatically in SAS (which in this case seems to lack problems), they can hard-save that output as a SAS file using a DATA step, or output it as another CSV.

Without having more details, it’s hard to provide more feedback than that.

Please let the user know that there is a newer version of the PCCF+ available.”

Tuesday, August 13, 2019

New Files on Statistics Canada Nesstar August 2019

We are pleased to inform you that the following are now available on the Statistics Canada Nesstar WebView site.

  • National Graduates Survey (NGS) 1997 PUMF
  • National Graduates Survey (NGS) 2007 PUMF
  • Adult Education Survey (AES) 1984 PUMF
  • Adult Education and Training Survey (AETS) 1990 PUMF
  • Adult Education and Training Survey (AETS) 1992 PUMF
  • Adult Education and Training Survey (AETS) 1994 PUMF
  • Adult Education and Training Survey (AETS) 1998, Courses PUMF
  • Adult Education and Training Survey (AETS) 1998, Hobbies PUMF
  • Adult Education and Training Survey (AETS) 1998, Labour Force PUMF
  • Adult Education and Training Survey (AETS) 1998, Programs PUMF
  • Adult Training Survey (ATS) 1986 PUMF
  • Canadian Alcohol and Drug Use Monitoring Survey (CADUMS) 2012 PUMF
  • Canadian Health and Disability Survey (CHDS) 1983-1984, Adult PUMF
  • Canadian Health and Disability Survey  (CHDS) 1983-1984, Child PUMF
  • Survey of Family Expenditure (FAMEX) 1974 PUMF
  • Survey of Family Expenditure (FAMEX) 1990 PUMF
  • International Adults Literacy Survey (IALS) 1994-1996-1998 PUMF
  • Job Mobility Survey (JMS) 1973 PUMF
  • National Alcohol And Drug Survey (NADS) 1989 PUMF
  • National Child Care Survey (NCCS) 1988, Child Records PUMF
  • National Child Care Survey (NCCS) 1988, Designated Adult PUMF
  • National Survey on Drinking and Driving (NSDD) 1988 PUMF
  • Postsecondary Students Survey (PSS) 1983-1984 PUMF
  • Survey on Ageing and Independence (SAI) 1991 PUMF
  • Maternity Leave Survey (SML) 1985 PUMF
  • Survey of Persons Not in the Labour Force (SPNLF) 1992 PUMF
  • Survey on Smoking in Canada (SSC) 1994 PUMF
  • Survey of Volunteer Workers (SVW) 1980 PUMF
  • Survey on Work Reduction (SWR) 1985 PUMF
  • Victims of Crimes Survey Edmonton (VCSE) 1985 PUMF

PCCF+ - Neighbourhood Income Variables

Question:
In PCCF+ 7B, ten neighbourhood income quintile and deciles variables are available - BTIPPE, ATIPPE, QABTIPPE, QNBTIPPE, DABTIPPE, DNBTIPPE, QAATIPPE, QNATIPPE, DAATIPPE, and DNATIPPE ( see PCCF+ 7B Reference Guide, page 17). Prior to PCCF+ 7B, four neighbourhood income (within CMA/CA and national) quintile and decile variables are available – QAIPPE, QNIPPE, DAIPPE, and QDNIPPE (see for example PCCF+ 6D Reference Guide, page 15).

My question is which of the ten PCCF+7B correspond to the earlier definition of the neighbourhood income quintile and decile?

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

In previous versions, the quintiles were based only on After-Tax (AT) income.

So:

QAIPPE = QAATIPPE quintiles, area-based
QNIPPE = QNATIPPE quintiles, national
DAIPPE = DAATIPPE : deciles, area-based
DNIPPE = DNATIPPE : deciles, national

Deprivation Data at DA and CT Level

Question:
I am helping a professor develop a health geography assignment using Canada-wide marginalization data that allows students to explore the modifiable aerials units problem (MAUP) by comparing different geographies of the same dataset (eg. using the CT and DA level of the Canadian Marginalization index). This data exists for the 2006 Canadian Marginalization index (CAN-MARG) at the DA and CT level however, the product seems to have only been continued in 2011 and 2016 for Ontario.  As the years pass, it’s harder to rationalize using the 2006 data in order to get a national picture.

I recently discovered the “Canadian Index of Multiple Deprivation (CIMD)”. It seems like a great fit, but I am wondering if it is available at the CT level? If not, could I get an estimate on a custom tab?

I am aware the 2016 deprivation index is available for 2016 however, it also only appears to be available by DA https://open.canada.ca/data/dataset/c595f11f-5d24-421f-9d9b-d63cd5333904 -- any leads to CT level data for comparison would be helpful.

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


“Unfortunately, the CIMD is only available at the DA level. She can link the CIMD using geographic information (e.g. address, postal code). The client can consult the user guide for additional information on postal code information, specifically the postal code conversion file:  https://www150.statcan.gc.ca/n1/en/catalogue/45200001.”

Friday, August 9, 2019

New Release: Labour Force Survey July 2019

We are pleased to inform you that the following product is now available.

Labour Force Survey (LFS) - July 2019

This public use microdata file contains non-aggregated data for a wide variety of variables collected from the Labour Force Survey (LFS). The LFS collects monthly information on the labour market activities of Canada's working age population. This product is for users who prefer to do their own analysis by focusing on specific subgroups in the population or by cross-classifying variables that are not in our catalogued products. The Labour Force Survey estimates are based on a sample, and are therefore subject to sampling variability. Estimates for smaller geographic areas, industries, occupations or cross tabulations will have more variability. For an explanation of sampling variability of estimates, and how to use standard errors to assess this variability, consult the Data Quality section in the Guide to the Labour Force Survey.

EFT:  /MAD_PUMF_FMGD_DAM/Root/3701_LFS_EPA/1976-2019/data/micro2019/micro2019-07.zip 

Tuesday, August 6, 2019

New Release: 2014 Provincial Symmetric Input-Output Tables

2014 Provincial Symmetric Input-Output Tables

EFT: /MAD_DLI_IDD_DAM/Root/other_autres/1401_IO_ES/15-211-X – Provincial Symmetric Input-Output Tables 2014.zip

Friday, August 2, 2019

New Release: 2015 Provincial Symmetric Input-Output Tables

2015 Provincial Symmetric Input-Output Tables

EFT: /MAD_DLI_IDD_DAM/Root/other_autres/1401_IO_ES/15-211-X – Provincial Symmetric Input-Output Tables 2015

Wednesday, July 31, 2019

Modernization Bulletin - July 2019


The July 2019 issue of the Statistics Canada Modernization Bulletin is now available on the EFT. The bulletin aims to keep you up to date on the latest Statistics Canada initiatives and transformations.  

EFT: /MAD_DLI_IDD_DAM/Root/ModernizationBulletinModernisation

Friday, July 26, 2019

BC Provincial Electoral Districts

Question:
A PhD student is looking to compare BC provincial electoral results with socioeconomic variables from the electoral districts, such as; visible minority and income. Is someone aware of a custom census tabulation for the provincial electoral districts in BC? I look on BC provincial website and couldn’t find anything.

Answer:
Have you looked at https://elections.bc.ca/resources/statistics/

Thursday, July 25, 2019

New Release: DLI Standard Tables: FIUC-CAUBO 2017-2018

New Release:
DLI Standard Tables: FIUC-CAUBO 2017-2018
EFT: /MAD_DLI_IDD_DAM/Root/other_autres/3121_FIUC_IFUC/FIUC-IFUC 2017-2018

Wednesday, July 24, 2019

Update: CCHS 2015-2016 PUMF

Update: 
For the CCHS 2015-2016 PUMF—released in January— a new geographic classification variable (ALECLASS) based on open source data was added to the file. This variable is a categorical measure of the favourability of active living environment of each respondent based on their dissemination area and its intersection/dwelling density, as well as points of interest. Due to the addition of this variable, further data suppression was applied on the 2015-2016 PUMF to avoid disclosure risks. We are looking for any feedback you may have on the usefulness of the ALECLASS variable to help us determine if it should be added to the 2017-2018 PUMF. For the 2017-2018 PUMF there will be data on both physical activity and sedentary behaviors, so we see a potential usefulness, but would like to get a sense of how much the concept has been used so far.

Tuesday, July 23, 2019

Census data for Canadians of Bangladeshi origin

Question:
I have a faculty member looking for all census data (income, education, work, housing, etc) for people of Bangladeshi origin for Edmonton, Calgary, Alberta, and Canada. Does this require a custom tabulation?

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

“We have the following 2016 data table available. Your client can use the filters to select their desired Geography and Ethnic origin at the top of the page.”

 If this is not sufficient, we will have to go the custom tab route.

Thursday, July 18, 2019

ADAs and DAs correspondence files pre-census 2016

Question:
A researcher at Dalhousie has expressed interest in using the ADA as her unit of analysis. Since ADA is a new dissemination geography created for census 2016 and her research included pre-census 2016 time period, she would like to know if it is possible for Stat Can to provide

  • DAs and ADAs correspondence for each census year pre-census 2016.  Using GeoSuite 2016 it is possible to generate DAuid corresponding to ADAcode.  This is not possible pre-census 2016.
  • correspondence file that describe the ADAs between two censuses.  For examples
    • census 2016 ADAs  corresponding to census 2011 ADAs
    • census 2011 ADAs corresponding to census 2006 ADAs
    • and so on

Answer:

I’ve received the following response from subject matter:

“As noted, there are no ADAs prior to 2016. Correspondences could be created between different census years, since a link is maintained on the geoframe between current census and previous census, at the lowest levels of geography. So, what could be created would be: 

2011 DA — 2016 ADA
2006 DA — 2016 ADA
2001 DA — 2016 ADA
Etc.

Because there is no such thing as an ADA prior to 2016, the concept of 2011 ADA — 2016 ADA does not really exist. All that could be provided is groupings of previous DAs that are close to equivalent to the current ADAs.”

This would all need to be done through a custom tabulation however. 

We do also produce correspondence files between the DAs for each census and its previous census. Those files are available on the Geography website, or I could see about the potential of having them added to the EFT (if they are not already there).

 

Friday, July 12, 2019

a different PCCF+ question: collaboration btwn 2 institutions, each with a PCCF+ license

Question:
I’ve been contacted by a researcher at [the university] who is collaborating with the regional government on a project. Both [the university] and the government group have PCCF+ licenses that forbid access to the data by anyone outside the institution named in the license. Do they each have to work in parallel with separate copies of the PCCF+ and essentially produce two separate but equal copies of the results, or can common sense prevail here since both groups have licensed access?

Answer:
Since both parties have valid end use licences and are collaborating on the same project, they can produce the results together

PCCF+ Question about Residential Postal Code File

Question:
I’m looking at the November 2018 (V 7b) files and the file labeled ‘Residential postal code file’ does not appear to contain residential postal codes. Is this a mistake?

I don’t use PCCF+ very often and would like to know where I can find the list of national residential postal codes.  There is a file called “Unique postal codes from PCCF” which appears to be what I’m looking for but I can’t find documentation to support this. Also—why is it called ‘unique postal codes’

Answer:
I apologize but I don’t seem to see the “Residential postal code file”?

I’ve double checked with the PCCF team and they’ve said the following:

“As per our agreement with Canada Post, we are not able to share a list of all residential postal codes in Canada – the data are proprietary. The purpose of the PCCF+ is to match USER lists of postal codes with our census geography. The client needs to have their own list of postal codes in order to use PCCF+.

The file indicating “unique postal codes” is a list of unique matches to the PCCF – so it is not a full list of residential postal codes either.

I apologize, but we do not provide a master list. The client may wish to approach Canada Post for access to these data.”

Thursday, July 11, 2019

CCHS PUMFs and Sexual Orientation

Question:
I have a researcher wanting to use the CCHS PUMFs to look at the sexual identity variable, but even though the question has been asked in the Socio-Demographic portion of the questionnaire since Cycle 2.1 and reports have been published citing the data (such as https://www150.statcan.gc.ca/n1/daily-quotidien/040615/dq040615b-eng.htm) neither of us can find this variable in any file other than the 2015-16 cycle. I hope we are not just missing something, but perhaps there is a reason this information was not made part of the PUMF files?

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

“In the past, the subject matter team preparing the PUMFs for release considered the sexual orientation concept as an indirect identifier and chose not to include it with the file. In 2015-2016, our team requested to the Microdata Release Committee to allow us to add the variable to our 2015-2016 PUMF. They agreed that the risk of disclosure was low and approved the addition of the variable. We will continue to assess the risk, but I imagine we will continue with the release of that variable going forward.”

Tuesday, July 9, 2019

Financial Data for Specific Industries at the Provincial Level

Question:
A researcher here is looking for some data for specific NAICS codes. We’ve found some information at the national level, and some provincial information at higher NAICS groupings, but nothing with both the level of industry and geographic detail he wants. He’s willing to purchase a custom tabulation if necessary.

Specifically he is asking for:

Annual, (total capital expenditures) for (NAICS 22111, 22112, 23713) for each province/territory, from 2007 to the most current date;
Annual, (total federal taxes, total provincial taxes) for (NAICS 22111, 22112, 23713) for each province/territory, from 2007 to the most current date.

Table 34-10-0035-01 gives capital expenditures at the provincial level, but at the two digit level only. 33-10-0007-01 has taxation but is also at the two-digit level. Am I missing an available source? Would this level of detail be available from a custom tabulation?

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

“We have data on taxes on production and products for NAICS 2211 and 23, but the data is not broken down by level of government.  We have data on capital expenditures, but only for NAICS 221 and 23.  This data would be available from 2007 to 2015, by province and territory.”

Friday, July 5, 2019

New Release - LFS June 2019

We are pleased to inform you that the following product is now available.

Labour Force Survey (LFS) - June 2019

This public use microdata file contains non-aggregated data for a wide variety of variables collected from the Labour Force Survey (LFS). The LFS collects monthly information on the labour market activities of Canada's working age population. This product is for users who prefer to do their own analysis by focusing on specific subgroups in the population or by cross-classifying variables that are not in our catalogued products. The Labour Force Survey estimates are based on a sample, and are therefore subject to sampling variability. Estimates for smaller geographic areas, industries, occupations or cross tabulations will have more variability. For an explanation of sampling variability of estimates, and how to use standard errors to assess this variability, consult the Data Quality section in the Guide to the Labour Force Survey.

EFT: /MAD_PUMF_FMGD_DAM/Root/3701_LFS_EPA/1976-2019/data/micro2019/micro2019-06.zip 

Nesstar will be updated early next week

Wednesday, July 3, 2019

PUMF Yearly Subscription Fee

Question:
Under the Statistics Canada Open License, there is no cost to access to the PUMFs. In this link about PUMFs (updated today), it states there is a $5000 subscription fee. I'm confused, why there is still a subscription fee?

Answer:
The yearly subscription fee mentioned is for access to the PUMF collection – not for individual PUMFs. 

Friday, June 28, 2019

New Release - Census 2016 Hierarchical File

We are pleased to inform you that the following product is now available.

Census of Population, 2016 Hierarchical File

Statistics Canada conducts the Census of Population in order to develop a statistical portrait of Canada and Canadians on one specific day. The census is designed to provide information about people and housing units in Canada by their demographic, social and economic characteristics.

Statistics Canada reinstated the mandatory long-form census in time for the 2016 Census of Population. As such, a sample of approximately 25% of Canadian households received a long-form questionnaire. All other households received a short-form questionnaire.

The Census of Population is a reliable basis for the estimation of the population of the provinces, territories and municipal areas. The information collected is related to federal and provincial legislative measures and provides a basis for the distribution of federal transfer payments. The census also provides information about the characteristics of the population and its housing within small geographic areas and for small population groups to support planning, administration, policy development and evaluation activities of governments at all levels, as well as data users in the private sector.

Clients: Federal government, provincial and territorial governments, municipal governments; libraries; educational institutions; researchers and academics; private industry; business associations labour organisations; ethnic and cultural groups; private citizens; public interest groups are among the users of census data.

EFT: /MAD_PUMF_FMGD_DAM/Root/3901_Census-Pop_Recens-Pop/2016/Hierarchical-Hierarchique

Nesstar Webview: Census of Population, 2016 [http://dli-idd-nesstar.statcan.gc.ca/webview/]

*Please note: We are aware that there are issues with some of the PDF Reference files. We are working to correct these.

Thursday, June 27, 2019

Census Tract Pairs (Journey to Work)

Question:
I have a researcher looking for a dataset that would contain a list of pairs of Census tracts where one CT represents a person’s home location and the other their work location, along with the number of people who make that specific commute (based on the Census Journey to Work questions). Is this data available, perhaps as a custom tabulation?

Answer:
We’ve received the following response from the regional office:

“Yes it is possible.  It would be CT of residence by CT of work within a CMA or CA.
He is looking for specifics CMAs/CAs and for other variables?”




Wednesday, June 26, 2019

Canadian Community Health Survey PUMF 2017-2018

Question:
Given that the CCHS PUMF for 2015/2016 was only released earlier this year, the researcher realizes that the PUMF for 2017-2018 is probably not in the very near future, but would like to know if there is any estimated timeframe for its release.

Answer:
We do not have an official release date for the CCHS 2017-2018 PUMF. Last I had spoken to subject matter, they were in the collection stage and didn’t expect to have anything released for another 1-2 years.

We will be updating our list of expected releases on the website shortly!

Monday, June 24, 2019

PCCF Reference Guide

Question:
Where on the EFT is the 2019 February version of the Reference Guide? 

Answer:
It is currently being stored here: /MAD_PCCF_FCCP_DAM/Root/EnglishSASInstructionsPCCF+

Correction SPSD/M 27.1

This e-mail is to inform you a miscoding was found in SPSD/M version 27.1 and to provide you with the appropriate solutions.  Despite an extensive testing and validation system, an error was found in version 27.1 which may impact results of your studies. 
This e-mail contains the solution that you need to resolve the miscoding.  You may also download version 27.1.1 from the EFT if you would like a version of the model which has the fixes included. Version 27.1.1 will overwrite version 27.1.
Ontario Childcare Access and Relief from Expenses (CARE) Tax Credit
Years affected: 2019-2025

Issue: The Ontario CARE refundable tax credit announced in 2019 budget (April 11). Child Care Expenses and Social benefit repayments were deducted from net income when they should have been added back to net income.

Fix for users who don’t want to download 27.1.1: Ontario CARE is a refundable tax credit and therefore has no further income tax related implications in the model. Users can model this refundable tax credit easily using the User Variable Facility included with the model.

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.

Friday, June 21, 2019

Saskatchewan Self-harm Data

Question:
I have a researcher interested in a custom tab of data on Suicidal Thoughts & Attempts in SK from the 2015-16 CCHS. They’re hoping for two tabulations based on the following:

Meadow Lake and Surrounding Area

Meadow Lake (city)

Loon Lake (village)

Makwa (village)

Goodsoil (village)

Dorintosh (village)

Rapid View (village)

Green Lake (northern village)


La Ronge and Surrounding Area

La Ronge (northern town) 

Air Ronge (northern village)

Would a custom tab of data at the level of the two broad areas (not the individual communities) be possible?

Answer:
Unfortunately the number of respondents in the two requested geography groupings are too small to provide any estimates.

Follow-Up Answer:
Have you tried the Saskatchewan Coroners Service Northern Regional Office?

It could be worthwhile.  About four years ago I was able to obtain youth suicide numbers for some Ontario Indigenous communities by going to my regional supervising coroner office who then referred me to the right contact at the central office.  I am pretty sure I started out with a phone call to my regional office.  The contact I was referred to at the chief coroner’s office ran a special table for our researcher.

How to Figure out which PCCFs I need?

Question:
I have a researcher looking for the 2001, 2006, and 2011 census and corresponding PCCFs. I’ve gotten all the census data, but I’m having a heck of time figuring out which of the PCCFs I need to use (for example, in the PCCF+ folder for 2001, there is PCCF4F, PCCF4G, PCCF4H, and pccf4j). I have no idea what I’m looking at. Can anyone point me in the right direction?

Answer:
I believe the deal is that the highest alphanumeric version in any given census folder is the last version for that census. So, the 7s are for 2016, the 6s are for 2011, the 5s are for 2006, etc. and the lettering just restarts to indicate which versions have been released.

I think The odd case on the EFT might be 6D, which is still in the 2017 folder, but was created in 2015 and based on the 2011 census geo, but includes 2016 DAs.  That's a weird one.  The first official 2016 version seems to be 7A, or at least 7A's documentation says "The reference date for these geographic areas is January 1, 2016. The previous version linked to the 2011 Census of Population geographic areas."

I think the deal with the PCCF+ over the PCCF is that you can use the PCCF+ for data spanning multiple census, but I don't think you have to grab separate versions.  Someone who actually knows what they're talking about can confirm or deny, but in your case, Maggie, I think you only need to grab the latest version for 2011, which would be 6C or 6D, depending on whether or not it matters that the documentation for 6D says "Although version 6D of the PCCF+ is still based on 2011 census geography, the output includes the 2016 dissemination area (DA) based on a released intercensal correspondence file (DA16uid)."  

Thursday, June 20, 2019

Uniform Crime Reporting - Recent Files

Question:
I have a researcher looking at the Uniform Crime Reporting. They are wondering if you will be releasing an update or more current data. Or should we be looking at another dataset?

Answer:
The Masterfile will be released to the RDCs at the end of July, however there is no intention of creating a PUMF.

Wednesday, June 19, 2019

PCCF+ Licensing

Question:
We are working with a Master’s student that would like to use the PCCF+ to run postal codes to match to DAs. She will be collecting the postal codes from a survey that is being run as part of a larger project that involves Queen’s University, the City and a consulting firm in town. She is a co-investigator and the work she will be doing will contribute to her Master’s thesis and results will be shared with the City and the consulting firm.

While the survey data will be accessible to non-Queen’s members of the project team; the PCCF+ would only be available to the student researcher.  If the student uses the PCCF+ to run the collected postal codes and get associated DAs, can just the DAs be shared as a result with non-Queen’s members of the project team?

The composition of the project team (with the municipality and consultants) partnering with the University is throwing us off a little bit.

Answer:
We’ve received the following response from the PCCF team:

“Yes, just the DAs (geography) can be shared as a result with non-Queen’s members of the project team as long no postal codes are displayed in the student’s results or reports.

All end users receiving these products must abide by the requirements of the End-use Licence Agreement for these products.  We would like to point out some specific constraints on the use of these data products: 

  • to be used for the purpose of matching postal codeOM data to geography (Clause 4);
  • not to be used for mail preparation purposes (Clause 5);
  • acknowledgment of data licensed from Canada Post (Clause 7);
  • reproduction and publication of up to 1% of content (Clause 8); and
  • a disclaimer for search engine applications (Clause 10).”

Tuesday, June 18, 2019

New files on Statistics Canada Nesstar - CFCS 2014 & NCS 2018

We are pleased to inform you that the following (metadata) are now available on the Statistics Canada Nesstar WebView site.

Canadian Financial Capability Survey (CFCS) 2014
National Cannabis Survey (NCS) 2018, Wave 3
National Cannabis Survey (NCS) 2018, Wave 4


Friday, June 14, 2019

New Release: SPSD/M Version 27.1

I am pleased to inform you that version 27.1 of the Social Policy Simulation Database and Model (SPSD/M) is now available on the EFT here: /MAD_SPSDM_BDMSPS_DAM/Root/27.1.

This is a model update – the database remains unchanged and remains based on the 2015 survey data from the Canadian Income Survey (CIS). This version is capable of modeling the tax/transfer system for all years from 1997 through 2025.

The update includes the following:

  • Changes resulting from the 2019-20 budgets, announced before May 1, 2019, have been incorporated.
  • Changes resulting from the 2018 tax forms have been incorporated.
  • Changes resulting from the 2018 and 2019 TD1s have been incorporated
  • The regulatory charge on fossil fuels has been included in the commodity tax model
  • The weights have been updated to reflect changes in Statistics Canada's population estimates.
  • The most recent economic growth projections from the Parliamentary Budget Office have been incorporated. Income and expenditures are now grown on a per capita basis in order to reflect demographic changes.
  • Commodity taxes based on fuel volume are projected by provincial population growth while other commodity taxes and expenditures (including fuel expenditures) are grown at the same rate as per capita personal income.

Tuesday, June 11, 2019

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.

Monday, June 10, 2019

CCHS Master File - Chinese Immigrants

Question:
A researcher is looking at possibly submitting an application to the RDC to access the CCHS-IMDB around healthy immigrant effect on older Chinese immigrants. She is wondering if it was possible to find out what the sample size is for the variable born in China? I have checked the CCHS PUMF and this table but both only have general options of white, black, Asian, or other and not the specific country or ethnic origin she is looking for.

Answer:
I’ve spoken to one of the analysts at the RDC and although she would not be able to confirm sample sizes at the moment (as they do not have the data yet), she doesn’t anticipate there will be a problem with the proposal, given the sample size. Of course the proposal does go through institutional review, so if there are any problems anticipated for the researcher it would be flagged at that point.

New Product - Labour Force Survey May 2019

We are pleased to inform you that the following product is now available.

Labour Force Survey (LFS) - May 2019

This public use microdata file contains non-aggregated data for a wide variety of variables collected from the Labour Force Survey (LFS). The LFS collects monthly information on the labour market activities of Canada's working age population. This product is for users who prefer to do their own analysis by focusing on specific subgroups in the population or by cross-classifying variables that are not in our catalogued products. The Labour Force Survey estimates are based on a sample, and are therefore subject to sampling variability. Estimates for smaller geographic areas, industries, occupations or cross tabulations will have more variability. For an explanation of sampling variability of estimates, and how to use standard errors to assess this variability, consult the Data Quality section in the Guide to the Labour Force Survey.

EFT: /MAD_PUMF_FMGD_DAM/Root/3701_LFS_EPA/1976-2018/data/micro2019-05.zip

Nesstar Webview: Labour Force Survey (LFS), May 2019

Friday, June 7, 2019

New files on Statistics Canada Nesstar - CCHS 2015

We are pleased to inform you that the following are now available on the Statistics Canada Nesstar WebView site.

Canadian Community Health Survey (CCHS) 2015 Nutrition - PUMF
Canadian Community Health Survey (CCHS) 2015-2016 Annual - PUMF

Thursday, June 6, 2019

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.

Wednesday, June 5, 2019

Modernization Bulletin - May 2009

The May 2019 issue of the Statistics Canada Modernization Bulletin is now available on the EFT. The bulletin aims to keep you up to date on the latest Statistics Canada initiatives and transformations.  

EFT: /MAD_DLI_IDD_DAM/Root/ModernizationBulletinModernisation

Tuesday, June 4, 2019

Workplace and Employee Survey (WES) - Custom Tab Request

Question:
I am helping a researcher interested in using the employee version of the (WES) to explore “within-organization discrimination against parents who take maternity/paternity leave”, “does leave results in discrimination?” and “is the person in a leadership position” (this last question seems hardest to answer). I discovered the WES pdf reports on archived Stat Can pages and saw the synthetic files on . I am wondering if any additional tables exist? Would this be something that could be requested via a custom tab?

For the time being, I will be recommending exploration (and sub setting) of the GSS and LFS.

Answer:
In regards to the WES, the data is solely available through the RDC - custom tabulations aren’t possible.

Monday, June 3, 2019

Ways to Contact DLI

I wanted to take a moment to remind you of the different avenues available to contact us here at the DLI.

The listserv is meant to serve as a collaborative venue to a) ask questions in which other members of the community may be able to help with, b) ask questions to the DLI team at Statistics Canada which may be of interest to the entire community, and c) to share other bits of interesting information including upcoming training dates, webinars and presentations, notices, suggestions, etc.

In order to help cut down the amount of messages sent through the listserv, we are asking that if you have a question intended specifically for us here at Statistics Canada (that you don’t feel is beneficial to the entire community) or if you have a custom tabulation request, you contact us directly at statcan.maddli-damidd.statcan@canada.ca.

We also request that you limit the number of emails sent directly to our personal email addresses. While we love hearing from you, it’s always a possibility that we may not be in the office for an extended period of time and your questions may go unnoticed!

Friday, May 31, 2019

2016 Labour Force Survey - missing NOCs

Question:
A researcher is looking for NOC occupation groups for the monthly 2016 Labour Force Survey PUMFs.  Is this the way it should be represented: NOCS_01_25 STC Nesstar and NOCS_01_47 STC Nesstar when there actually are no such variables in 2016? 

Is it correct that the values are 100% missing for in 2016? It would be helpful to have NOC values for 2016.

What was the intention in 2016 when there are NOC values for the PUMF for these variables, e.g., on Odesi see January 2015: NOCS_01_25 link and NOC_01_47 link and for January 2017: NOC_10 LINK and NOC_40 LINK?  Would this be considered a problem with the data files?  

As an aside, there are SOC80_21 and SOC80_49 variables (with values) in 2015 and 2016.  Revisions to the 2015 LFS

Follow-Up Question:
I’d like to make a correction please to my question, with thanks to Scholars Portal for reviewing the occupation variables from 2015 – 2017 LFS monthly PUMFs.

Is it correct that there are supposed to be placeholders for a number of occupation variables but no data as highlighted in yellow  below?

  1. All the LFS monthly PUMFs, 1987-2015, have data for NOCS-01-25 and NOCS_01_47, but as for the variables SOC80_21 and SOC80_49, there is no data.  
  2. The monthly 2016 LFS PUMFs have  variables named NOCS_01_25, NOCS_01_47, SOC80_21 and SOC80_49 but with no data.
  3. The monthly 2017 LFS PUMFs have two occupation variables only, the new NOC_10 and NOC_40.
Answer:

The short answer to this is simply that the labels have changed from the older years to the newer ones. For example, SOC80_21 was replaced with an NOC listing instead. From what I’ve been told, the descriptions of the variables should remain the same, it’s just a matter of needing to match them up from year to year (not necessarily the answer you were looking for I’m sure!)

So yes, it is correct that there is no data.

Thursday, May 30, 2019

Where are the PCCF Files?

Question:
I was looking for the most recent version of the PCCF which is supposed to be under MAD_PCCF_FCCP_DAM/ROOT/2019 but this directory does not show up (there are folders for 1986 all the way to 2018, but no 2019). Also, if I look under /MAD_PCCF_FCCP_DAM/Root/2018/pccf-fccp for the previous version, this folder is empty!

Answer:
We moved it to reflect the most recent Census release! See attached. Sorry for the confusion!

*Original email included attachment*

PCCF Question - Rural vs Urban FSAs

Question:
I have a question from a grad student in Political Studies and, given my lack of expertise dealing with the PCCF, I thought I’d post it here for help. The problem stems largely from the fact that some FSAs are classified as both urban and rural.:

"I am using survey data to determine whether or not feelings of western alienation are higher in rural places relative to urban places in Western Canada. My survey asked respondents for the first three digits of their postal code (FSA), which I plan to code as either rural or urban. To do so, I plan on using the Postal Code Conversion File (PCCF) to code the FSAs of Western Canada as rural or urban, according to the "PopCntr_RA_size_class" variable. Unfortunately, each FSA has multiple values for the "PopCntr_RA_size_class" variable, making it difficult to code each FSA as either rural or urban. How can I effectively sort each FSA into the geographic categories?

Also, once I classify each FSA as rural or urban, how can I integrate that information into the survey data set? Is there a way to create an SPSS syntax file that sorts the respondents into geographic categories based on their reported FSA?"

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

“There is no easy way to classify the FSAs as either rural/urban. FSAs are designed as part of Canada Post Corporation’s mail delivery system, which conceptually is operational, not geographical. That makes it difficult to match it with conceptually geographic systems, like StatCan’s census geographies. The PCCF does the best it can, and at the lowest levels of geography, it’s not too bad. However, moving to higher levels of geography, like Population Centres, or higher in the delivery system, like FSAs, causes more gray areas. To facilitate the sorting of a lot of mail, they cover delivery to many different types of geography: villages, indian reserves, cities, towns, rural routes, and so on. It is not surprising that they cannot be classified as either rural or uban.

The best that can be done is some analysis of how the FSAs link up with PopCentres in the PCCF. Then, the researcher will need to make some decisions as to how to define each FSA, based on that analysis.

So, given all that, we have done the following:

— selected all non-retired FSAs from the western provinces (Manitoba to British Columbia) à 455
— found those that overlapped more than 1 PopCentreSizeClass or more than 1 PopCentreRAType à 304

and then we provided further information on those with the postal code counts. See the attached table. With that, the client can decided which way to classify each FSA.

This is only one example of the types of analysis that can be done. There are also the SAC and SACType attributes that may be useful, as they indicate whether the FSA is influenced by a CMA / CA or not. Hmm, I just took a quick look at that, and that may prove more useful. I’ve included that table in the workbook as well.

Anyway, there is no easy way to classify the FSAs are rural/urban with the PCCF. The client will have to do some sort of analysis of the attributes (PopCentre or SAC or perhaps something else that makes sense to them), then make some decisions as to how they will classify each FSA.”

Wednesday, May 29, 2019

PCCF in csv Format

Question:
Until we complete hiring a new data librarian, I’m the contact for anyone in our institution needing the PCCF and PCCF+ files and my knowledge is very limited. Usually I just provide the files and all is good, but now a grad student who has received the files sent me the following: “I am not familiar with SAS. Could you please send me a csv or Excel file which contains the postal codes and corresponding regions”.

Answer:
I’ve received the following response from the PCCF team:

“We do not provide the PCCF or PCFRF files in csv or Excel format. The files are quite large, and would take up even more room if they were provided is some application format. They are provided as a flat, fixed width, ASCII text file (.txt), which is readable/importable into a wide variety of applications. This is not a format specific to SAS. The client should be able to use it in whatever data application they are familiar with.

The record layout is provided in the Reference Guide (page 11 in the 2019 February version). That explains the format of the text file, and how the client needs to define the file in their application.

It’s not the most convenient way to provide the files. However, it is the format that is usable in the most applications, and has the smallest file size.”

Crime Data at Census Tract Level

Question:
A researcher is looking for crime data at the CT level for 2016 and 2011. As far as I know, data from the Uniform Crime Reporting Survey is only available at the provincial or CMA level. I have seen some CT tabulations for Montreal (2001) and Toronto (2006) but that’s all. Short of custom tabulation, is there any other source for this data?

Answer:
Subject matter has responded with the following:

“The Montreal and Toronto reports in question were really one off special analytical products, outside the normal geographical scope of the UCR.  


The lowest geography that the UCR is published at is the police service boundary level, then it goes to CMA, then CANPROV.”

Tuesday, May 28, 2019

Temporary Workers in Canada - StatsCan Report

Question:
Re:  Temporary Workers in Canada over a 20 year period (was reported on on May 3rd).

https://www.cbc.ca/news/business/temporary-workers-employment-1.5135310 

Does anyone know the source that the CBC reporter would have used for this story?  Labour Force? Labour Force Historical Review? (not up-to-date?)

The researcher wonders if the data is available at the occupational level for legal professionals.

At first I thought I was looking for a report but don't think so. I'll keep looking, just back after two weeks away (and the question came in almost the moment I left town.)

Answer:
On our end, we've received the following response from subject matter:

"It's outlined is the article that the source is the Labour Force Survey. 

Tell the researcher that yes, it is possible to produce a cross-tabulation of job permanency status by occupational groups as a cost recoverable product. 

The would be a small percentage of suppression due to sample size.

When asking for professionals, he is referring to the following: 

    11 Professional occupations in business and finance
    21 Professional occupations in natural and applied sciences
    30 Professional occupations in nursing
    31 Professional occupations in health (except nursing)
    40 Professional occupations in education services
    41 Professional occupations in law and social, community and government services
    51 Professional occupations in art and culture"

Please let me know if you would be interested in pursuing a custom tabulation.

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

Wednesday, May 22, 2019

PCCF Problem

Question:
A student here is using the latest edition of the PCCF, and is running into a curious problem -- she only gets results for two provinces - Newfoundland and Nova Scotia. I don't have any experience actually using the PCCF, so I'm stumped as to where the problem might be.

Any idea why this might be happening?

Answer:
The PCCF team will need a little more information in order to troubleshoot:

"If we can get further information, as in any of the following…

— complete PCCF vintage
— software tool used to do the query / analysis (MS Access, SAS, etc.)
— what the query / analysis actually is
— results anticipated
— actual results"

Questions about Housing Data

Question:
An Education researcher here wants to work with data at the DA level that describes dwelling characteristics including rental costs, housing values, tenure.

While he may find suitable data through dwelling Variables in the RDC using the 2006 and 2016 Census files, and the 2011 NHS he was wondering how he may access data from the Canadian Housing Statistics Program (CHSP).

His questions on the CHSP are as follows:

  • What reference periods are available
  • If the program does not go back earlier than 2017, did another program collect comparable data?
  • Will a PUMF be produced under this program?
  • He may wish to explore a Custom Tabulation, if so would data at the DA level on the above noted dwelling characteristics (and possibly additional variables) be available?
Answer:

I’ve received the following response from subject matter:

What reference periods are available
  • 2018
If the program does not go back earlier than 2017, did another program collect comparable data?
  • The Census is likely the best source.
Will a PUMF be produced under this program?
  • This is not planned.
He may wish to explore a Custom Tabulation, if so would data at the DA level on the above noted dwelling characteristics (and possibly additional variables) be available?

No, the CHSP provides data at the CSD level and above.

2001 to 2016 DA Correspondence File

Question:
A doctoral student is interested in comparing certain variables in the 2001 and 2016 census at the DA level.  They would like to standardize the DAs a certain year, preferably 2001.  There are correspondence files on the StatsCan website at https://www150.statcan.gc.ca/n1/en/catalogue/92-156-X for each census year relative to the previous census year for 2001 to 2016 (i.e., 2016 to 2011, 2011 to 2006, 2006 to 2001).  However, the student would like to use a correspondence file for 2016 to 2001, if it exists as one file.  Is anyone aware of such a file?  I realize the same task could likely be accomplished programmatically with the three correspondence files available, but I think for this student (and to be honest, for me) it would be easier with one file.

Alternately, is there a way to obtain data for a specific geographic region (Toronto) for the two census years aggregated to 2001 or 2016 DA levels?  For example, in Dataverse we have a semi-custom tabulation https://dataverse.scholarsportal.info/dataset.xhtml?persistentId=doi:10.5683/SP2/QNO5JG of certain census data from 1971-2011 standardized to 2016 DA geographies, but it doesn’t contain the variables the student is looking for.

Answer:
It looks as if (on our end) we’d have to go the custom tabulation route. Please let me know if you would be interested in pursuing this and I will have the proper individuals get in touch with you.

Tuesday, May 21, 2019

Estimated Release of 2017 APS PUMF

Question:
I have a researcher interested in the 2017 Aboriginal Peoples Survey data. When might the PUMF be released? It’s not listed on the tentative release dates page yet. I understand if nothing specific is known at this time, but it would be helpful to know if it won’t be in 2019, for example.

Answer:
The 2017 APS PUMF will not be disseminated until 2020 – the exact date hasn’t been determined yet however.

Friday, May 17, 2019

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*

Workplace Pension Plans WW2 and pre-WW2

Question:
I have a researcher looking for data surrounding workplace pension plans pre-WW2 and during WW2. He’s also interested in the gender share of workers in different industries and the gender share of new workers by industry, particularly during the Great Depression and WW2.

Does anyone have any suggestions?

Answer:
... have you had a look at the Historical Statistics of Canada (2nd ed.)? 

That link takes you to Section D on the Labour Force that includes a set of tables which might address part of your question ("gender share of workers in different industries"). They can be downloaded in CSV format​.

Table D8-85

Work force, by industrial category and sex, census years, 1911 to 1971 (gainfully occupied 1911 to 1941, labour force 1951 to 1971)

Your researcher will want to read the accompanying notes on the site.

Tuesday, May 14, 2019

PCCF7B / FCCP7B

The latest version of the PCCF file (PCCF7B) is now available on the EFT. It can be found at the following location:

/MAD_PCCF_FCCP_DAM/ROOT/2019/PCCF7B.zip

Monday, May 13, 2019

New Files on Statistics Canada Nesstar - CCHS 2015

We are pleased to inform you that the following (metadata) are now available on the Statistics Canada Nesstar WebView site.
 
  • Canadian Community Health Survey (CCHS) 2015 Nutrition
  • Canadian Community Health Survey (CCHS) 2015-2016 Annual

GSS Victimization - Territories and Geography

Question:
I have a question about microdata files available for the GSS (victimization) cycle 28, or previous. A researcher is interested in joining data from this survey with data from the Census and therefore requires more detailed geographic information than what is available with the DLI PUMF. In the PUMF, the geographic variables only 'go down' to the provincial level. The restricted dataset has many more geographic variables available, which would be better in this case.

However, the microdata files aren't consistent with their inclusion of data from the territories vs provinces. None of the DLI PUMFs contain data from the territories. The cycle 28 RDC dataset only contains variables for responses from the provinces, while the cycle 23 RDC dataset only contains responses from the territories.

Are there any microdata datasets (RDC/DLI) that contain responses from both the provinces and territories, that will have more specific geographic variables?

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

“It is never a good idea to ‘join data’ from two different surveys, given differences in in their populations, methodologies and time frames.

In general, the GSS is only carried out in the provinces, the exception being the Victimization cycle, last completed in 2014.

As of 2019, the GSS targets a sample size of approximately 20,000 respondents. Sometimes a cycle has a higher target sample size if funding has been received for an oversample, either in the form of a geographical sample top-up (i.e., adding more units in certain geographic areas),  a targeted oversample (e.g. focussing on immigrants, youth, or another population group), or a general oversample (i.e., increasing the raw sample size). With a final sample of 20,000 respondents, basic survey estimates are usually available for the national and regional levels, and for some provinces and census metropolitan areas. Depending on the survey topic, the sample size may be sufficient to produce estimates for certain population groups such as lone parent families, certain visible minority groups or seniors.”

Friday, May 10, 2019

New Release - LFS April 2019

We are pleased to inform you that the following product is now available.

Labour Force Survey (LFS) - April 2019

This public use microdata file contains non-aggregated data for a wide variety of variables collected from the Labour Force Survey (LFS). The LFS collects monthly information on the labour market activities of Canada's working age population. This product is for users who prefer to do their own analysis by focusing on specific subgroups in the population or by cross-classifying variables that are not in our catalogued products. The Labour Force Survey estimates are based on a sample, and are therefore subject to sampling variability. Estimates for smaller geographic areas, industries, occupations or cross tabulations will have more variability. For an explanation of sampling variability of estimates, and how to use standard errors to assess this variability, consult the Data Quality section in the Guide to the Labour Force Survey.

EFT: /MAD_PUMF_FMGD_DAM/Root/3701_LFS_EPA/1976-2018/data/micro2019-04.zip

Nesstar Webview: Labour Force Survey (LFS), April 2019

Canadian Survey on Disability 2017

Question:
I've had a request for information about this survey, and I see that it's listed as available in the RDC, but there is no metadata available on your Nesstar server. Any ideas as to where it might be? It has to exist, given that it's in the RDC. Failing getting access to the codebook, would it be possible to get some clarification on certain variables? Thanks much in advance!

Answer:
I've just put in a request to get access to the codebook for this survey in order for me to code it into Nesstar - without knowing how large it is, I won't be able to accurately give a timeline just yet, however if you're in a rush I can send any questions you may have off to subject matter (or verify the codebook myself).

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