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.