Thursday, July 31, 2014

SLID 2011 Release

Question

I am helping a PhD student who would like the most recent version (2011) release of the SLID PUMF. The latest info on the website calls for a Spring 2014 release. This information was last updated on October 2013, is there now more precise information a release date?

Answer

The SLID was released on the EFT on July 31, 2014.

Wednesday, July 30, 2014

Manipulating NESSTAR Data

Question

What was said at ACCOLEDS as to who can get a password and user ID to manipulate the NESSTAR data -- is it only the DLI contacts and designates?

Answer

You are correct, these are in the plans and we are working with our IT services to put it in place. At the moment, only DLI Contacts and Designates are provided with a username and password, but our plans are to open it by restricting to IP for DLI Institutions.

In regards to linking to specific entries, see: <http://www.statcan.gc.ca/dli-ild/products-eng.htm>

Tuesday, July 29, 2014

2011 Census PUMF

Question

When will there be a PUMF produced based on 2011 Census data?

Answer

The Individuals File, 2011 NHS PUMF is to be released today. We are still waiting to receive the file, but the PUMF will soon be available on the DLI EFT.

Monday, July 28, 2014

PUMF Access to Foreign-Based Researchers

Question

I have received a request from a foreign-based researcher to access PUMF. I wanted to know if Stat Can has developed any arrangement for foreign-based researchers to access PUMFs. If there’s such an arrangement, could you please direct me to the web page or other source of information on the application process.

Answer

They can contact Statistics Canada to acquire a PUMF. If you know the exact PUMF they are looking for, we can direct them to the appropriate PUMF page where there is an order form. If they are interested in accessing multiple PUMFs, there is the Public Use Microdata File (PUMF) Collection program: <http://www.statcan.gc.ca/pub/11-625-x/11-625-x2010000-eng.htm>

Alternatively, they can contact Advisory services: <http://www.statcan.gc.ca/eng/reference /refcentre-centreref/index-eng?MM>

Sunday, July 27, 2014

Alcohol/Drug Use and Crime Stats at the CSD Level or Lower

Question

I have a researcher who’s looking for alcohol/drug use and crime stats at the CSD level or lower. Do the RDC files contain data at that level?

Answer


For Alcohol/Drug use alone, you might want to contact the Health Division. 

For accused of criminal charges by offenders under the influence of Alcohol/Drug, I can refer you to two specific crimes:

1) Homicide: In the Juristat Homicide in Canada, 2012, there is a chapter named Alcohol and/or drug consumption common in homicide <http://www.statcan.gc.ca/pub/85-002-x/2013001/article/11882-eng.htm#a14>. It includes the following tables:

Table 1a Number of homicides, by province or territory, 1982 to 2012
Table 1b Rate of homicides, by province or territory, 1982 to 2012
Table 3 Homicides, by census metropolitan area, 2011 and 2012
Table 4 Homicides, by type of method, Canada, 2002 to 2012
Table 5 Homicides, by shootings and stabbings, by selected census metropolitan areas, 2012
Table 7 Number of gang-related homicides, by region, 2002 to 2012
Table 8 Gang-related homicides, by selected census metropolitan areas, 2012

2) Impaired Driving: In CANSIM table 252-0051 Incident-based crime statistics, by detailed violations, annual (Number), 1998 to 2012, there are several offences involving alcohol/drug use:
- Offences related to Impaired driving: Total impaired driving, Impaired operation causing death, Impaired operation (drugs) causing death, Impaired operation causing bodily harm, Impaired operation (drugs) causing bodily harm, Impaired operation of motor vehicle, vessel or aircraft, Impaired operation (drugs) vehicle, vessel, aircraft, Failure to provide breath sample, Failure to comply or refusal (drugs), Failure to provide blood sample.

- Offences related to drugs (but not “use of drug” in case you are interested): Total drug violations, Possession cannabis, Possession cocaine, Total possession other Controlled Drugs and Substances Act drugs, Heroin possession, Other Controlled Drugs and Substances Act possession, Methamphetamines (crystal meth) possession, Methylenedioxyamphetamine (ecstasy) possession, Total cannabis trafficking, production or distribution Cannabis, trafficking Cannabis, importation and exportation Cannabis, production, Total cocaine trafficking, production or distribution, Cocaine trafficking Cocaine importation and exportation, Cocaine production, Total other Controlled Drugs and Substances Act drugs, trafficking, production or distribution, Heroin trafficking, Other Controlled Drugs and Substances Act trafficking, Methamphetamines (crystal meth), trafficking, Methylenedioxyamphetamine (ecstasy) trafficking, Heroin importation and exportation, Other Controlled Drugs and Substances Act, importation and exportation, Methamphetamines (crystal meth) importation and exportation, Methylenedioxyamphetamine (ecstasy) importation and exportation, Heroin production, Other Controlled Drugs and Substances Act production, Methamphetamines (crystal meth), production, Methylenedioxyamphetamine (ecstasy) production, Precursor or equipment (crystal meth, ecstasy)

****************************************

In regards to the RDC files, the minimum level of geography available for urban areas will be the census tract (CT) and the census subdivision (CSD) is the minimum level for rural areas.

The RDC data files have geography at the CT or CSD level where CT is not available (e.g., rural areas)

Friday, July 25, 2014

Landfills

Question

I am trying to help someone find the number of landfills in Canada, Nova Scotia, Ontario and Quebec. I think I may have found numbers for NS and Ontario but not  Quebec. Incidentally, I have found that SK has more than 700 but she doesn't need that number. This seems to become quite complicated. There are large landfills and there are small landfills. Some are public and some are private. I am thinking that maybe they are in one of the DMTI layers (Enhanced point of interest?) but I haven't managed to locate the information there, yet, either. If you can help point me in the right directions, I would be very grateful.

Answer

Infostats  responded: "Information about the waste management industry is available in the CANSIM tables listed on this page of our website.

- Tables 153-0044 and 153-0045 may be of particular interest to the client.

- Table 153-0044 shows the total number of businesses in the waste management industry, by province. The same information is however not available for the public sector (153-0045).

Furthermore, information on business location counts by industry, by employment size and by province is available in CANSIM table 551-0005.

Data for the following industries can be found in this table:
Waste collection [562110]
Waste treatment and disposal [562210]
All other waste management services [562990]

The number of landfills by province is not available as a standard product on our website, but may be available through a custom request.

The client can send Infostats an e-mail with her detailed data requirements (variables, time frame, geography, etc.) as well as his/her complete contact information and Infostats will forward her request to the Advisory Services.

An agent will contact him/her back to inform him/her if the data he is seeking is available and to provide him/her with a free time and cost estimate, would any charges apply.

Finally, the client may want to contact Environment Canada as they might have more information on this subject: <www.ec.gc.ca or http://ec.gc.ca/gdd-mw/default.asp?lang=En&n=6F92E701-1>

Population Used to Calculate Income Deciles for the NHS

Question
A researcher is analysing income decile distribution by Census Tracts across Canada, and wants to know what the population is that was used to classify people by income deciles? Is it just one population as we think: anada, or some other level of geography?

We found this definition:
All people have been classified into 10 equal income groups according to the adjusted after-tax income of their economic family. In the first decile group the median individuals' total income was $7,400, in the fifth decile group it was $33,000, and in the top decile group it was $80,600. … in the analytic document on Income composition in Canada <http://www12.statcan.gc.ca/nhs-enm/2011/as-sa/99-014-x/99-014-x2011001-eng.pdf>

Answer

In consultation with the author division, please see response below:

Income deciles can be calculated for different geographic areas. In the analytical document mentioned below Income Composition in Canada <http://www12.statcan.gc.ca/nhs-enm/2011/as-sa/99-014-x/99-014-x2011001-eng.cfm#a2> the decile information provided is at the Canada level.

We have these data tables from the 2011 NHS have the decile breakdowns for Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations:

For example, for Ontario:

- Selected Demographic, Income and Sociocultural Characteristics (109), Income Statistics in 2010 (3) and Income Sources (16) for the Population Aged 15 Years and Over in Private Households of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2011 National Household Survey <http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/dt-td/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM =0&FL=A&FREE=0&GC=0&GID=1118302&GK=0&GRP=0&O=D&PID=106736&PRID=0&PTYPE=105277&S=0&SHOWALL=0&SUB=0&Temporal=2013&THEME=98&VID=0&VNAMEE=&VNAMEF=&D1=2&D2=0&D3=0&D4=0&D5=0&D6=0>

- Selected Economic Family and Persons not in Economic Family Characteristics (55), Income Statistics in 2010 (4A) and Income Sources (16) for the Economic Families and Persons not in Economic Families Aged 15 Years and Over in Private Households of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2011 National Household Survey <http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/dt-td/Rp-eng.cfmLANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FRE=0&GC=0&GID =0&GK=0&GRP=0& PID= 107004&PRID=0&PTYPE=105277&S=0&SHOWALL =0&SUB=0&Temporal=2013&THEME=98&VID=0&VNAMEE=&VNAMEF=>

- Selected Demographic, Income and Sociocultural Characteristics (109) and Number Reporting and Aggregate Amount Reported from Each Source in 2010 (35) for the Population Aged 15 Years and Over in Private Households of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2011 National Household Survey <http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/dt-td/Rp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=0&PID=106732&PRID=0&PTYPE=105277&S=0&SHOWALL=0&SUB=0&Temporal=2013&THEME=98&VID=0&VNAMEE=&VNAMEF=>

For the Census Tract level data the only standard product that has the decile breakdown is the NHS Profile:

For example, for the CT 9150001.00 here is the NHS Profile which gives Total population by decile of adjusted after-tax family income: NHS Profile, 0001.00, British Columbia, 2011 <http://www12.statcan.gc.ca /nhs-enm/2011/dp-pd/prof/details/page.cfm?Lang=E&Geo1=CT&Code1=3826&Data=Count&SearchText=9150001.00&SearchType=Begins&SearchPR=01&A1=All&B1=All&Custom=&TABID=3>

If you would like any other decile breakdowns for the CT level of geography then a custom data tabulation would need to be ordered through the nearest regional office.

Thursday, July 24, 2014

NHS Individual PUMF

Question

What is the latest information on the release date for the NHS/ENM Individuals?

Answer

The Individuals File, 2011 National Household Survey (Public Use Microdata Files), will be released on July 29, 2014.

Wednesday, July 23, 2014

Census Tract Conversion Table

Question

I have a researcher who is seeking access to the census tract conversion table mentioned on this page: <http://www12.statcan.gc.ca/census-recensement/2011/ref/dict/geo013-eng.cfm>

It states: “A conversion table showing the relationship between the current and previous census tracts for each tracted centre is available upon request from the Geography Division, Statistics Canada.”


His request to StatCan was forwarded to me as DLI contact. I cannot locate this file, but perhaps someone could steer me in the right direction? He is looking at 1996-2011.

Answer
These files are available on the gate census site: <http://ivt.crepuq.qc.ca/recensements/recensement2011/recensPop2011.html>

For each edition census, there is a page for the geographic products, which includes a link "Documentation" that provides access to all correspondence files of a specific issue:

R-2011: http://ivt.crepuq.qc.ca/recensements/recensement2011/fichiersGeo2011documentation.html

R-2006 : http://ivt.crepuq.qc.ca/recensements/recensement2006/fichiersGeo2006documentation.html

R-2001 : http://ivt.crepuq.qc.ca/recensements/recensement2001/fichiersGeo2001documentation.html


The Geography Division also confirmed that there is not a single conversion table from 1996-2011 but three conversion tables. There is one correspondence file for each Census year: 2011-2006, 2006-2001 and 2001-1996. Each file is accompanied by a data quality statement (DQS).

Please note that the conversion tables are available on the EFT site:

/MAD_DLI/Root/geo/2001/concordance-files

/MAD_DLI/Root/geo/2006/correspondence

/MAD_DLI/Root/geo/2011/concordance-file-btw-2006-to-2011

Cultural Group Funding

Question

Is anyone aware of any databases that would allow one to search funding to cultural groups by area code?

Answer

- <Ajah.ca> has an extensive and comprehensive database of funding in Canada. It does look for subscribers, but I think there is room for the DLI/Research Libraries to discuss an arrangement with them. They have the most robust and comprehensive database on this topic in the country.

Guide to Managing Statistics Canada Publications in Libraries

Question

As recommend by some of my fellow data/gov docs librarians, I have started using this publication (Guide to Managing Statistics Canada Publications in Libraries (11-208)) to assess our collection at Concordia. According to the online  catalogue, Statistics Canada has an electronic version of this document (E-RESOURCE 000588). Would it be possible to get a copy?

Answer

I confirmed with the Library that the guide is not available electronically-- it has never been available in electronic format. In light of the high level of interest, this document, as well as all the old catalogs of publications, should be placed fairly high on the list of items to be digitized.

Tuesday, July 22, 2014

Payment Data

Question

I have a student who is looking for data related to the use and prices of payment systems such as cash, debit, and credit cards. I couldn't find it in CANSIM do you know where, or if this is available?

Answer
The Financial Consumer Agency of Canada has considerable amount of payment data: <http://www.fcac-acfc.gc.ca/Eng/Pages/home-accueil.aspx>

Infostats also responded:

“Data from the Canadian Internet Use Survey on electronic orders by type of payment is available on CANSIM table 358-0158 <http://www5.statcan.gc.ca/cansim/pick-choisir?lang=eng&p2=33&id=3580158>

Unfortunately, there is no additional data related to the use and prices of different payments system available as a standard product on our website. The student may be able to obtain more information on this subject through a custom order.

S/he can send us an e-mail with his/her detailed data requirements (variables, time frame, geography, etc.) as well as his/her complete contact information and we will forward his/her request to our Advisory Services. An agent will contact him/her back to inform him/her if the data s/he is seeking is available and to provide him/her with a free time and cost estimate, would any charges apply.”

Monday, July 21, 2014

International Travel Survey (ITS) 2012

Questions

1) Looking at the CMA/CA coding, the documentation refers us to the 2001 Standard Geographical Classification. However, there are 5 codes used in the 1st quarter “co” file which aren’t in the 2001 classification (http://stds.statcan.gc.ca/sgc-cgt/2001/ss-rs1-eng.asp?criteria=35, etc.): 531/533/329/820/920. These codes do appear in the 2006 SGC. Has the documentation lagged behind the classification used, or do the codes on the ITS refer to some other areas?

2) I’ve begun working on the CO (Canadians travelling overseas) file (1st quarter), and have some questions, which I think will help with the other files in the set. First, I have a basic question about the structure of the quarterly files: I presume that when applied the weights create quarterly estimates, which can then be added together for annual estimates (and that therefore the four quarters could be combined into a single file for analysis)?

3) 
Accommodation variables - (ACCVS1, ACCVS2, ... ACCVS15)

o Each of these variables appear to record up to 6 different accommodation types, with spaces accepted in the field (“123456”, “1 3 56”) Correct

o The documentation states "The accommodation used in each location visited: Hotel, Motel, Home of friends or relatives, Camping, Cottage or cabin and Other." How is this applied?
- column 1 is either "1" or blank - is this hotel?
- column 2 is either "2" or blank - is this motel?
- column 3 is either "3" or blank - is this home of friends or relatives?
- column 4 is either "4" or blank - is this camping?
- column 5 is either "5" or blank - is this cottage or cabin?
- column 6 is either "6" or blank - is this other? 

o if a column is blank, does that mean that the accommodation type was not used, or that the accommodation type was not reported, or both? 

Carrier codes - (CARRC1, CARRC2, ... CARRC12)

o Is the coding on this to append three zeros to the national code (e.g., United Kingdom is coded 90077000)?

o Assuming that that is the normal coding, how are United States carriers specified beyond the 97433000 (e.g., 97433085, in the 1st quarter file for 2012)

- are the first 7 characters the US Destination code (e.g., in the case above, California)?

- what is the last column?

o Does a zero in this field indicate that there was no carrier, or that the carrier was not reported, or both?

Place of travel codes - (PLVSC1, PLVSC2, ..., PLVSC15)

o Is the coding on this to append two zeros to the national code (e.g., United Kingdom is coded 9007700)?

o Does a zero in this field indicate that there was no place of travel, or that the place of travel was not reported, or both? 

Various expense variables/person nights, etc. (fare1 to fare12, spvs1 through spsv15,

o Does a zero in this field indicate that there was no expense/nights, or that the field was not applicable (e.g., travel 8 didn’t occur, so expense8/nights8 is 0), or not reported, or any or all of the above?

RSCMA

o Does a 0 in this field indicate that the person did not live in a CMA/CA? 

Answers

1) Our mistake on that one. Yes, 2012 data is based on 2006 SGC. Good catch.
2) Yes, applying the weights as described in the Microdata User Guide will establish quarterly estimates, which can then be added together to create annual estimates, or yes combine all 4 files.

3) (Answers in italic red for this section)

Accommodation variables - (ACCVS1, ACCVS2, ... ACCVS15)

o Each of these variables appear to record up to 6 different accommodation types, with spaces accepted in the field (“123456”, “1 3 56”) Correct

o The documentation states "The accommodation used in each location visited: Hotel, Motel, Home of friends or relatives, Camping, Cottage or cabin and Other." How is this applied?
- column 1 is either "1" or blank - is this hotel? Yes
- column 2 is either "2" or blank - is this motel? Yes
- column 3 is either "3" or blank - is this home of friends or relatives? Yes
- column 4 is either "4" or blank - is this camping? Yes
- column 5 is either "5" or blank - is this cottage or cabin? Yes
- column 6 is either "6" or blank - is this other? Yes. Note: visits 1 to 15 can be multiple days per visit and thus any visit can have more than one type of accommodation during those days.
o if a column is blank, does that mean that the accommodation type was not used, or that the accommodation type was not reported, or both? Well, what we know is that a blank indicates that the accommodation type was not reported, which can be interpreted as not being used or as a response error (they used that type of accommodation but did not tell us!)

Carrier codes - (CARRC1, CARRC2, ... CARRC12)

o Is the coding on this to append three zeros to the national code (e.g., United Kingdom is coded 90077000)? Yes the carrier code should represent just a country code of the commercial carrier.

o Assuming that that is the normal coding, how are United States carriers specified beyond the 97433000 (e.g., 97433085, in the 1st quarter file for 2012) Seems to me like you have moved on to the variables PLVSC1 (places visited ) (7 digits posn 582-588) where for travel to US it represents the country//state codes and the 5 would be the first digit of 2 digits of the US Region Code (posn 589-590)
- are the first 7 characters the US Destination code (e.g., in the case above, California)? Yes, the appending of the US Country Code and State Code

- what is the last column? As above

o Does a zero in this field indicate that there was no carrier, or that the carrier was not reported, or both? Yes both. As above, there may not have been a commercial carrier (eg.Transport may have been by car) or the respondent indicated a plane but not a carrier name for us to code to a country.

Place of travel codes - (PLVSC1, PLVSC2, ..., PLVSC15)

o Is the coding on this to append two zeros to the national code (e.g., United Kingdom is coded 9007700)? For non-US, yes. For travel to US you will often see a state code if data was provided.

o Does a zero in this field indicate that there was no place of travel, or that the place of travel was not reported, or both? As above
Various expense variables/person nights, etc. (fare1 to fare12, spvs1 through spsv15,

o Does a zero in this field indicate that there was no expense/nights, or that the field was not applicable (e.g., travel 8 didn’t occur, so expense8/nights8 is 0), or not reported, or any or all of the above? Yes anything is possible at that point, there may not have been expenses, depending on type of transport, type of accommodation, etc.

RSCMA

o Does a 0 in this field indicate that the person did not live in a CMA/CA? Yes


Thursday, July 17, 2014

Inter-Census Municipal Profiles for Ontario for 2000, 2003 and 2010

Question

A researcher needs Inter-Census municipal profiles for Ontario for 2000, 2003 and 2010. Specifically:“census data at the municipal level on basic variables, like population, average age, average home value, median income, home ownership etc . . .  data would be used to help understand the effects of Internet voting on the voting behaviour of municipal electors by providing important socio-demographic controls. Without this information the model will be missing a critical component that has been shown in the scholarly literature. to explain and account for motivations to take part in elections.”


Is this data available as a standard product or as a custom tab?

Answer

- At the municipal level (census subdivisions - CSD), we can offer for free a data file which includes year estimates of the population by CSD from July 1st from 2001 to 2013. Estimates of the population for CSD are also available by age, sex at a cost of $146.04. If your researcher wishes to obtain those estimates, You will have to give me his coordinates so that I can pass them on to the author division.

The Income Division explained that (in regards to the other variables: home value, median income, home ownership):

"The NHS profile <http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/prof/index.cfm?Lang=E> has average home value, home ownership, median income and many other housing, shelter costs and income statistics at the CSD level. On the NHS profile landing page, users can type in the name of the municipality (option 1) or browse through the geographic hierarchy (option 2).  Once a geography is selected, users can select a topic using the “Select a view” drop-down” menu.  Here is the an example of income of individuals for Durham, ON: <http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/prof/details/page. cfmLang=E&Geo1=CD&Code1=3518&Data=Count&SearchText=Durham&SearchType= Begins&SearchPR=01&A1=Income%20of%20individuals&B1=All&Custom=&amp;TABID=1>

Tuesday, July 15, 2014

Finding and Using Statistics 11-533-x -- Temporary vs. Permanent Link

Question

Our library has a catalogue record for the microfiche version of this publication, a form I would rather not have to use. I have found the HTML version archived by Statistics Canada: <http://www.statcan.gc.ca/pub/11-533-x/finding-trouver/4155245-eng.htm>. Is this a permanent link? I don't see anything that looks like DOI?

Answer

It is quite uncommon to find truly "permanent" links on Statistics Canada, particularly since this one isn't even offered as a PDF file. We do not have DOIs at Statistics Canada. Instead the client should be pointed to our online catalogue which has the most current information about this product and where the links are stable:<http://www5.statcan.gc.ca/olc-cel/olc. action?ObjId=11-533-X&ObjType=2&lang=en &limit=0>

Monday, July 14, 2014

Applying Census Definitions to Seniors

Question

A researcher is inquiring about Census definitions and how they apply to seniors. In particular, s/he is asking:

"1) I need to know whether or not living alone includes individuals living in institutions or seniors housing.


2) Do they live in isolated units?

3) Does the term private dwelling include people living in institutions?”

4) When I look at the 2011 Census Profile data, for example Winnipeg, I see “Detailed mother tongue – Total population excluding institutional residents”. There is a “note” to this that gives additional information regarding citizenship. There is also an “Institutional resident” entry in the Census Dictionary at: <http://www12.statcan.gc.ca/census-recensement/2011/ref/dict/pop053-eng.cfm> which gives more clarification, for example that institutional includes nursing homes. However, the entry in the Census dictionary has a note at the bottom which reads: “In 2011 and 2006, institutional residents exclude people living in seniors' residences.” How does this work?

5) It would seem that those living in “seniors residences” are included in the Census, but those seniors in a “nursing home” are not included." Is that correct?

In the 2011 Census dictionary, page 55 of 166, it does give a bit more detail under “collective dwellings”, clarifying between “nursing homes” and “residences for seniors”. Is there additional information anywhere, or perhaps someone the researcher can contact with the Census, to help distinguish the differences between these two categories? It would seem to me that the key element is the level of independence.

The researcher is also asking about “living alone”. In general, to me this means one person, by themselves. However, the researcher is questioning whether, in regards to the Census, living alone could include a spouse or partner. The Census dictionary does not seem to have a separate entry for “living alone” but the term does occur on four occasions.
The last, on page 52 of 166, states “one person living alone.” 

6) Is there ever a situation where there could be a couple or more than one person “living alone”? “

Answer- 
Direct Responses to the Questions Followed by a General Explanation from the Author Division

Direct Responses

1) All standard Census data tables publishing statistics on “living alone” (a category of ‘Household living arrangement’) is based on persons in private households. Therefore, it does not include individuals living in collective dwellings (institutional and non-institutional). However, the publication referenced below does have some information on living arrangements of people in seniors’ residence collectives.

2) For living arrangements of people in seniors’ residence collective dwellings, the living arrangement is based on the people in the same unit and not based on all persons in the seniors’ residence collective dwelling.

3) No, the term “private dwelling” does not include people living in institutions.

4) In the 2011 and 2006 Census, residences for senior citizens were considered non-institutional collective dwellings. This was a change from earlier censuses where residences for senior citizens were considered institutional collective dwellings.

5) Usual residents in seniors’ residences, as well as nursing homes, are included in the Census. What is different is the specific questions that are collected. One difference is that, for people in seniors’ residences, the living arrangements (based on the people in the unit) were collected; while it was not collected for people in nursing homes. However, this information is not included in standard tabulations of the variable “Household Living Arrangements”. A data table is available in the publication referenced.

6) No, based on the definitions explained above.

General Explanation

The Census concept of “living alone” can be found under the definition for “Household living arrangements”:

*********************************
Household living arrangements
Part A - Short definition: Refers to the classification of persons as members of a family household or of a non-family household, and whether they are family persons or persons not in a census family.
Part B - Detailed definition: Refers to the classification of persons as members of a family household or of a non-family household, that is, whether or not they are living in a household that contains at least one census family, and whether they are members of a census family or not in a census family. Persons not in census families are further classified as living with relatives, living with non-relatives (only) or living alone.
Census years: 2011, 2006, 2001, 1996, 1991, 1986, 1981
Reported for: Population in private households
*********************************
The concept of “living alone” applies only for populations in private households;
thus it does not apply to people in collective dwellings (whether institutional collectives such as nursing homes, or non-institutional collectives such as residences for senior citizens).
This is the concept used in all standard Census data tables.

However, in the 2011 Census, collective living arrangements of people in seniors’ residences was identified as an important data need. These results are published in the article: “Living Arrangements of Seniors” <http://www12.statcan.gc.ca/census-recensement/2011/as-sa/98-312-x/98-312-x2011003_4-eng.cfm>.

The article has a specific section on people in seniors’ residences. In this section, the living arrangement is based on the people living in the same unit and not based on all persons in the seniors’ residence collective dwelling. However, please note that all other 2011 standard Census data tables for the variable ‘Household living arrangement’ are for persons in private households; thus, data for people in seniors’ residences are not included in these tabulations.

Friday, July 11, 2014

Prices for Corn and Hay Used for Silage in Canada

Question

A researcher would like to find statistics on prices for both corn and hay used for silage in Canada. A Statcan rep suggested that she contact me about the availability of data from the “Tame Hay and Straw Prices Received by Producers [in] Ontario” survey which is not available through CANSIM or other standard data products. I do not see data from this survey in the DLI collection, nor listed in the RDC Master File metadata list.

- Brief description of survey: <http://www.statcan.gc.ca/eng/survey/agriculture/3436>

- Link to questionnaire: <http://www23.statcan.gc.ca/imdb/p3Instr.pl?Function=getInstrumentList&Item_Id=119741&UL=1V>

I have found some other sources of useful statistics (mostly provincial), but I just wanted to check that I hadn’t overlooked anything from Statcan.


Answer

The Author Divison explained that: "We don’t have any information in regards to prices of corn or hay used for silage. However, we do have some price/metric tonne data for tame hay in Ontario, Quebec and Alberta, as well as price/metric tonne data for grain corn, for various provinces. Our Price Book, includes this information, for the years 2009 to May 2014.

Here are also some links to CANSIM tables that they may use to find data on hay and/or fodder corn. Both tables contain values on seeded area, harvested area, production and yields:

- Table 001-0017 (metric values): <http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0010010&paSer=&pattern=&stByVal=1&p1=1&p2=-1&tabMode=dataTable&csid=#customizeTab>

and here is another link with the same data available in imperial values:

- Table 001-0010: <http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0010017&paSer=&pattern=&stByVal=1&p1=1&p2=-1&tabMode=dataTable&csid=#customizeTab>."

Thursday, July 10, 2014

2001 Aboriginal Peoples Survey Community Profiles Access

Question

The links to the 2001 Aboriginal Peoples Survey Community Profiles are broken and, judging from the information I was able to retrieve from the listserv this product is no longer available. Is there any chance these databases will be reinstated? The APS Community profiles are a very useful source of information for our users. I know that we can request data through the DLI, but that is not nearly as useful as having those tools -- for 1996 and 2001-- directly available to our users. Alternatively, is there anything similar planned for the 2012 APS?

Answer

The 2001 Aboriginal Peoples Survey Community Profiles is no longer available due to the security risks or vulnerabilities of the database that is used, as well the database software can no longer be updated. We had similar issues with the 1996 Community Profiles in which we had to take this off line as well.

The Subject Matter Division has informed that while the profile information is no longer available, they will attempt to transfer the data onto a CD for the DLI – I can then place it on the EFT site.

Tuesday, July 8, 2014

DLI Survival Guide & Licensing

Question

I am having problems accessing the DLI Survival Guide and the DLI licensing from this page: <http://www.statcan.gc.ca/dli-ild/dli-ild-calend-eng.htm>. It returns a 'File Not Found'.

Answer

The information was moved into the public facing, and I realize now that the quicklinks are still pointing to the old pages.These quick links will be removed as we are migrating to a new content management system. During this migration period I cannot submit website changes. I apologize for the inconvenience. You can find the information that you are looking for here: <http://www.statcan.gc.ca/dli-idd/reports-rapports-eng.htm>

Monday, July 7, 2014

Suppressed CCHS Variable

Question

I've got a researcher looking for a data point that doesn't appear to be in the 2012 CCHS PUMF - "HCU_01AC: Do you and this doctor speak in English, French or other?" I presume this variable was suppressed to preserve anonymity? Is it possible for the researcher to get access to this data?


Answer

That is correct that the HCU_1AC variable is not available on the PUMF.

The master files contain all variables and all records from the survey collected during a collection period. These files are accessible at Statistics Canada for internal use and in Statistics Canada’s Research Data Centres (RDC), and are also subject to custom tabulation requests. The RDC Program enables researchers to use the survey data in the master files in a secure environment in several universities across Canada. Researchers must submit research proposals that, once approved, give them access to the RDC. For more information, please consult the following web page: <http://www.statcan.ca/english /rdc/index.htm>

Another way to access data in the master files is to purchase a custom tabulations. This service is offered on a cost-recovery basis. The results are screened for confidentiality and reliability concerns before release. For more information, please contact Client Services.

Finally, the remote access service to the survey master files is another way to have access to these data if, for some reason, the user cannot access a Research Data Centre. Each purchaser of the microdata product can be supplied with a synthetic or ‘dummy’ master file and a corresponding record layout. With these tools, the researcher can develop his own set of analytical computer programs. There is no charge for this service.

Wednesday, July 2, 2014

2013 PCCF

Question

A request has come in for the 2013 PCCF file (we will make sure he is aware of the license and obtain appropriate signature.) I took a look at the DLI EFTP site, the latest year shown is 2011 PCCF. Do you know when the 2013 PCCF file will be available to the DLI community? According to <http://www.library.carleton.ca/sites/default/files/help/data-centre/PCCF-ReferenceGuide-92-154-g2013001-eng.pdf>, 2013 PCCF is the first release with the 2011 census geography, hence it would good to know when 2013 PCCF will be available.

Answer

The files you are looking for are found in the 2011 folder. The PCCF files in the EFT were released in October 2013 with the 2011 census geography.

The PCCF folders are broken down by Census year. Hence the 2011 folder representing the 2011 census geography.