Thursday, August 29, 2019

Is the International Travel Survey 2017 available?

Question:
According to the StatsCan website, 2017 was released in July, 2018 but doesn’t appear on the Nesstar server. Will this be uploaded at some point or am I missing something?

Answer:
Unfortunately you’re not missing anything. We’ve followed up numerous times now.  Unfortunately the website is not accurate and subject matter has hit delays. As soon as it is actually released, we will make it available for our clients.

Census Data at Dissemination Block Level

Question:
I have a researcher really wanting to get ahold of Census data (2011 & 2016) for NS at the Dissemination Block level. Do we have access to this level of geography (if so – any guidance for grabbing it would be amazing) or should I refer to the local RDC?

Answer:
Subject matter had the following to relay:

“Data for dissemination blocks is not available as part as standard products, besides for population and dwelling counts through our GeoSuite tool.

Other data is available through custom tabulations (additional  suppression is applied). The RDC file only goes down to the Dissemination Area (DA) level.”

Wednesday, August 28, 2019

PCCF/PCCF+ LibGuide

Queen's University Library has developed a PCCF/PCCF+ LibGuide, available at: https://guides.library.queensu.ca/PCCF

PCCF Terms of Use Question

Question:
I have a question regarding the restrictions outlined in the PCCF end-use license agreement.

Here is the question, in the researcher’s own words:

“I am inquiring in relation to end-use license agreement, and how much we would be able to expand the analysis geographically. We have done some organizing of the data according to PC, and then explored via geonames.org in order to get an approximate location just so we can get a sense of what size of town/small city is defined within urban and rural. However, I do not want to violate terms of use bullet #2. What we would like to be able to do is to separate into large urban/small urban and rural, which we think we can do with the information we have. Our research team is also wondering if there is a possibility to split north and south province. Can you provide any clarification to us on the agreement and what we can and cannot do?”


My understanding is that the researchers are worried that manipulating the data as outlined might count as “disassembling” or “decompiling” the data, as restricted by point 2 of the agreement. Do they have cause for concern?

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

“It seems that your client is using the PCCF only to correspond the postal codes to different geographies. That is the purpose of the product.

Using geonames.org to find locations, or other methods may not be necessary; that information is readily available at StatCan. Using the PCCF, most of the postal codes are linked to a dissemination block (DB), or perhaps a dissemination area (DA). There will be a representative point for those, with xy coordinates for more accurate location finding. Census Subdivision (CSD) is also provided, which is the postal code legal municipality.

Linking our Geographic Attribute File (GAF, https://www12.statcan.gc.ca/census-recensement/2011/geo/ref/att-eng.cfm) to the PCCF provides links to higher level census geographies like population centres (PopCtr, https://www12.statcan.gc.ca/census-recensement/2016/ref/dict/geo049a-eng.cfm) and Census Divisions (CD). Using PopCtr, the client can determine rural/urban. Using CDs the client can determine north/south (http://www23.statcan.gc.ca/imdb/pUtil.pl?Function=getNote&Id=792561&NT=04).


We can provide an Excel file of the CDs in North/South, rather than the client having to get it from the website.”

Tuesday, August 27, 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.

  • Canadian Travel Survey (CTS) 1982 - 1999 PUMF (English only)
  • Survey of Financial Security (SFS) 1999 PUMF (French only)
  • Travel Survey of Residents of Canada: Trip File (TSRC) 2016 PUMF (French only)

Time Series for Labour Force Characteristics

Question:
A researcher would like to know why Table 14-10-0095-01 (Labour force characteristics by census metropolitan area, three-month moving average, unadjusted for seasonality) only go back as far as 2001; he'd like to go back as var as the mid-80s, if possible.

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

"Comparable seasonally adjusted data by Census Metropolitan Areas is only available since 2001. We can produce unadjusted data back to March 1987. Please specify which characteristics you are requesting."

Tuesday, August 20, 2019

Canadian Data on Disability and Mental Health Services

Question:
I am looking for information, data, and statistics on disparity to mental health services for the following Canadian populations: rural folks, people classified has having disabilities (blind, physical disability, cognitive disability, brain injury etc).

I'm also looking for any types of statistics on internet accessibility across Canada, more specifically related to rural areas.

Answer:
I’ve checked with the team from CIHI and they’re provided us with the following response:

In response to your interest relating to mental health data, based on your specific data of interest, our Hospital Mental Health Database (HMHDB) team does not unfortunately have any sources that are readily available to be able to provide to you.

Customised data is typically obtainable through the submission of a formal data request. However, with that being said, even if you were interested in exploring this option, the data we have available, would only address the use of inpatient mental health services, and not access disparities. In terms of disabilities, we likely will not be able to capture historical diagnoses, rather would be able to identify only those that are captured on that episode of care.

Lastly for your interest regarding “any types of statistics on internet accessibility across Canada, more specifically related to rural areas”- such data is not a part of our data collection.

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