Wednesday, August 20, 2014

Financial Performance Indicators

Question

Can you tell me what the status is of the Financial Performance Indicators. It appears to me that there was no release date in 2014. Is 2009-2011 the most recent version? Will these continue to be released?

Answer

The 2009-2011 release is the most recent version available of publication 61-224-X <http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=61-224-X>. The publication is ongoing but no release date has been announced.

For information from our Financial and Taxation Statistics for Enterprises Survey, <http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=2510>, we invite you to consult the following table: Table 180-0003 - Financial and taxation statistics for enterprises, by North American Industry Classification System (NAICS) -annual at <http://www5.statcan.gc.ca/cansim/a05?searchTypeByValue=1&lang=eng&id=180000 3&pattern=1800003>

To view/manipulate the variables and time frame available for this table:
Select the “Add/Remove Data” tab
Select at least one variable in each step and “Apply” in order to view your customized table
Select “Back to original table” if you wish to view the pre-selected data by default
To modify the data in percent changes, sums or averages:
Select the “Manipulate” tab
Select the desired option from the drop-down menu and “Apply”
To download the data:
Select the “Download” tab
Select the variables of choice from the drop-down menus and click on “Download Data”
You may, at any time, select the “Help” tab for further assistance on the CANSIM database.

Thursday, August 14, 2014

Discontinued Surveys

Question

Does anyone have a list of surveys that have been discontinued since 2006? A former StatCan employee stated this morning that only inconsequential surveys have been cut at the agency. His work focuses strictly on economic surveys. I seem to recall that social surveys took a large hit. I know that the longitudinal surveys were all cut but would like to have more information about the rest of those that have been discontinued.

Answer

We started to keep track of some surveys that had discontinued PUMFs, but because researchers use old data and discontinued data we have never thought of keeping a list. We just check IMDB if we need to know the status of a survey. We will discuss starting a list.

Wednesday, August 13, 2014

Indian Reserves

Question

Is there a newer shapefile containing reserve boundaries available? I have the file produced by Equinox, but it’s from 2006. I don’t know how much reserves have changed in the interim, but I would like to see something a little more contemporary, if possible.

Answer

It’s been a while since I have had ArcGIS at my disposal, but have you used the boundary files from statcan?

The Census Subdivision Boundary Files portray the census subdivision boundaries for which census data are disseminated. A census subdivision is a municipality or an area treated as equivalent to a municipality for statistical purposes (for example, Indian reserves and unorganized territories). 2011 Census boundary file – Census subdivision<http://www 12.statcan.gc.ca/census-recensement/2011/geo/bound-limit/bound-limit-2011-eng.cfm>.

Census subdivision types associated with 'on reserve' population. "On reserve" population is a derived census variable that is captured by using the census subdivision (CSD) type according to criteria established by Aboriginal Affairs and Northern Development Canada (AANDC; formerly Indian and Northern Affairs Canada [INAC]). On reserve population includes people living in any of the six CSD types legally affiliated with First Nations or Indian bands (described below), as well as the northern village of Sandy Bay in Saskatchewan. You can sort through CSD type (CDTYPE) in the boundary file to create another layer.

The following census subdivision types are based on the legal definition of communities affiliated with First Nations or Indian bands: Indian reserve (IRI), Indian settlement (S-É), Indian government district (IGD), Terres réservées aux Cris (TC), Terres réservées aux Naskapis (TK), Nisga'a land (NL)

For more information see: <http://www.statcan.gc.ca/pub/92-195-x/2011001/geo/csd-sdr/def-eng.htm>

Monday, August 11, 2014

Education Stats

Question

I have a student looking for post-secondary enrolment figures and the number of universities and colleges in Canada. We can extract the numbers from PSIS and UCASS up to 2011, but he’d like more current stats.

Answer

Have you looked at the CAUT Almanac of Post-secondary Education in Canada? You can find 2007 – 2013/14 online at: <http://www.caut.ca/resources/almanac>. (I've had more success downloading these using Firefox than Internet Explorer).

Wednesday, August 6, 2014

Housing Affordability in Montreal and Vancouver

Question
I am helping a graduate student who wants to use housing affordability in Vancouver and Montreal using the residual income approach. So he needs to use the Disposable income for Market Basket Measure (MBM) (variable MBINC46 in the 2010 PUMF file). The problem is that he needs data at the CMA level and the PUMF only provides data at the provincial level.

I tried to locate the documentation for the SLID Master File which is apparently available from the RDCs, but could not find it on Nesstar. Could I obtain the documentation for that file so that my student has enough information to decide if he wants to go through the application process to access the Master File. Is it possible to obtain the documentation for my researcher only (rather than posting it on Nesstar)? The more information he has, the better he will be able to make his decision on whether he needs to go through the application process.

Answer

We will not post the documentation of the Master Files through Nesstar as they would have confidential information in them. 

I followed up with the RDC’s and here is the response they provided me: "If we have any non-confidential documentation we can usually provide it to them."

In this case the focal point got back to me with the following: ‘The main RDC website, on the data sets page and from clicking SLID, can take you to the following electronic data dictionary link: <http://www.statcan.gc.ca/pub/75f0026x/75f0026x2013000-eng.htm>

Suppressed 2011 Census Tract in Vancouver

Question

I have a researcher asking why Census Tract 058 in Vancouver (Code: 59 933 0058) is suppressed in 2011, but not in 2006. You can find 2011 population, private dwellings, density, and land area for this tract, but no other statistics (age, sex, marital status, etc). With a 2011 population of 3792, shouldn’t there be enough data to produce these statistics for this Census Tract?

The only other Vancouver Census Tract that shows no 2011 statistics is 59 933 0270, but it appears the same was true in 2006. And the population in 2011 was 5, so suppression makes sense. Not so for Tract 058.

Answer

Looking in the IVT file notes under the Geography tab...they can view the data quality flag descriptions. For this CT there is a 3 in the second spot (03000).

Notes:
2011 Census – Data quality flags and descriptions
Data quality flags for place of residence
Digit Description

1st (0XXXX) Incomplete enumeration flag
2nd (X0XXX) Data quality flag
3rd (XX0XX) Population and dwelling counts error flag
4th (XXX0X) Not applicable
5th (XXXX0) 2006 adjusted population flag


Flag description
Data quality flag

0 = Default.
1 = Data quality index showing, for the short census questionnaire (100% data), a global non response rate higher than or equal to 5% but lower than 10%.
2 = Data quality index showing, for the short census questionnaire (100% data), a global non response rate higher than or equal to 10% but lower than 25%.
3 = Data quality index showing, for the short census questionnaire (100% data), a global non response rate higher than or equal to 25% (suppressed).
Global response rates

Global response rates are determined for each of the census geographic areas. These areas are flagged on the database according to the non-response rate. Geographic areas with a non-response rate higher than or equal to 25% are suppressed from tabulations. Geographic areas with a global non-response rate higher than or equal to 5% and lower than 25% are broken into two categories and are flagged according to the following ranges: falling between 5% and 10% and falling between 10% and 25%. These geographic areas are identified in tabulations, but not suppressed. In electronic products, a numeric flag is provided with the area identifier indicating low data quality.

In 2006 the following data quality notes were applied to the same CT for the 2A Census hence why there are results in 2006.

Data quality index showing, for the short census questionnaire (100% data), a global non response rate higher than or equal to 10% but lower than 25%.

For more information regarding Data quality flags, they can consult the Data Quality and Confidentiality Standards and Guidelines (Public) guide: <http://www12.statcan.gc.ca/census-recensement/2011/ref/DQ-QD/qual-eng.cfm>

Friday, August 1, 2014

Canadian Income Survey Variables

Question
I have Economists who are interested to know what Immigration variables there will be in the Canadian Income Survey PUMF.

I know that this is not slated for release until some time next year. But the Survey of Consumer Finances, and the Survey of Labour and Income Dynamics which are predecessors to this survey both had variables which identified participants who were immigrants, and how long it had been since they immigrated. They are hoping to update their work with these variables.

Can we get any information about what variables are in the new survey, and what might be included in the PUMF?

Answer

the Author Division explained that:

"No date has been set yet for the 2011 SLID PUMF. We are aiming for late spring with this PUMF too. As for the Canadian Income Survey (CIS), there are tentative plans to produce a PUMF. However, until we release the initial data from CIS (most likely in fall, 2014), we cannot even think about a timeline for a PUMF. Most likely, such a PUMF will not be until 2015."

We will update the Tentative Release dates accordingly for CIS with a tentative release date in 2015.