Friday, February 27, 2015

Help Wanted Index 2003-2005

Question

I have a researcher using the Help Wanted Index, and there’s a gap in coverage between the data available from Statistics Canada (table 277-0002 terminated in 2003) and data available from the Conference Board of Canada (2005-present). Any chance someone can confirm that whether or not the data exists somewhere else for the missing 16 months? (May 2003-August 2005)

Answer

I confirmed with the previous author division and unfortunately we have no data for these years.Try contacting the Conference Board of Canada.

1921 Census Population of Prince George

Question
I have a student who would like the population of Prince George from the 1921 Census by racial origin (he didn't say, but country of birth might also work). I found Table 28 in Vol. 1 of the 1921 census publication, which is "Population of cities and towns of 2,500 and over, classified according to racial origin, 1921". Unfortunately, the population of Prince George in 1921 was 2,053. So, I'm assuming this student is out of luck?

I've suggested that he could use the advanced search to search the 1921 census at <http://search.ancestry.ca/search/db.aspx?dbid=8991&path=>, but I'm not sure how practical or useful this will be for him.

Answer

The StatCan library verified tables in the census pubs, and they confirm that they assume as well that this information for Prince George is unavailable in the pubs.

The microdata for the 1921 census seems to be available in the RDCs. Dataset available:
<http://www.statcan.gc.ca/eng/rdc/data>.

I noted the following on the Canadian Century Research Infrastructure site:
Accessing and Using

As of the release date of the 1921 CCRI microdata, users may access the database in one of the Statistics Canada Research Data Centres (RDCs) located on certain university campuses throughout Canada. The RDCs provide researchers with access to the CCRI database in a secure setting under the provisions of the Statistics Act and in accordance with the confidentiality rules that apply. The centres are staffed by Statistics Canada personnel.

The microdata captured by the CCRI data entry centres was stored in a central CCRI DB2 database for cleaning and coding tasks. Once these processes were complete, it was necessary to extract a subset of the data from the central database for use in the RDCs according to the applicable Statistics Canada rules and regulations. The extract is a CSV formatted file designed to be imported into SPSS, SAS or Stata programs at the RDCs. A separate extract file was created for each of the census years from 1911 through 1951. Each extract file contains the coded micro data for the individuals that were captured for the corresponding census. These files are described in more detail in the Data Extract section.

Note: that the RDC houses the data for the census enumerations of 1921 to 1951. The census of 1911 is public. <https://ccri.library.ualberta.ca/endatabase/accessing/index.html>

Thursday, February 26, 2015

Canada Federal Election 1921

Question

I've been asked to find election results for the 1921 election and I was successful.

I have found the results for the specific riding as requested, but the patron wants to have a finer level of granularity, i.e., he would like to get results from three of the polling stations within the riding.

Is there any way to locate this information?

Answer
You can find Polling Division results for the 1921 General Election in the Sessional Papers of the Dominion of Canada. The 1921 Election results are in Volume 5 of the 1922 set, which can be found on the Internet Archive. The years 1901 to 1925 are listed year and volume at URL: <http://library.queensu.ca/gov/sessional-papers>.

The direct link to the Quebec section of the 1921 Election report (page 186) is:<https://archive.org/stream/n05sessionalpaper58canauoft#page/186/mode/2up>

If you have any way to access a local historical newspaper for the riding in question, that may be your best bet. As just one example: <http://historicalnewspapers.library.ubc.ca/view /collection/enderby/date/1921-12-08/query/election+results/mode/any/in/all/result/1#1! election+results>.

Please see linked the Library of Parliament’s database History of Federal Electoral Ridings (HFER). <http://www.parl.gc.ca/About/Parliament/FederalRidingsHistory/hfer.asp?Language=E&Search=G>.

We are able to provide the total of votes cast for each candidate by riding, but the data by riding does not further subdivide. The results of the 1921 Election which formed the 14th Parliament are detailed here:<http://www.parl.gc.ca/About/Parliament/FederalRidings History/hfer.asp?Language=E&Search=Gres&genElection=14&ridProvince=0&submit1 =Search>.

Re. Information Management at Elections Canada: the material returned to EC from each riding is protected and governed by a retention period. My contact there did not think that the kind of data in question from the 1921 general election would be available, but if it is available, Library and Archives would have it – EC transfers content to LAC at the end of their retention period. So indeed – they are your next stop.

Community Noise & Health Survey (CHNS)

Question

Will a PUMF be produced for the Community Noise and Health Survey?

Answer

Unfortunately there is no PUMF. The Special Surveys Division confirmed that: "The Master file is in the RDCs and there is no PUMF."

General Social Survey 2005 Episode File

Question

I’m trying to clean up weight variable declarations in Equinox, and have encountered a problem. There are two weight variables released for the episode file for GSS cycle 19 – WGHT_EPI and WGHT_PER. However, the documentation for the episode file indicates that WGHT_EPI is the appropriate weight variable for each variable in the episode file. There also isn’t any note in section 7 (Estimation) specifically about the episode file. What is WGHT_PER (on the episode file) to be used for? (Should it be listed as a weight variable for all variables for which WGHT_EPI is indicated?)

Answer

Response from subject matter:

"If the client is looking at each episode, then WGHT_EPI is the correct weight. If they are looking at each respondent, then WGHT_PER is used.

The episode is one-to-many. Therefore, each respondent has many episodes, each episode gets a record. The main file, each respondent has a record.

So if the client is looking at the number of episodes, then use WGHT_EPI, otherwise, use WGHT_PER."

GSS 2005 Main File Weight Question

Question

Can WGHT_HSD be only used to create household estimates for variables which are normally weighted by WGHT_PER? (i.e., would they generate inaccurate estimates for variables in sections 10A, 10B, or 11 (the variables for which WGHT_CSP and WGHT_SNT were created?)

Answer


Response from Methodology:

The person is considered the basic unit of analysis and many steps have been taken to ensure that the person weight is consistent with external references. It’s the reason why all variables in the data dictionary of General Social Survey 2005 suggest using WGHT_PER, WGHT_CSP or WGHT_SNT for weighting. These are the preferred weights. Sometimes, however, estimates of the number of households will be required, so an approximation of a household weight (WGHT_HSD) has been included on the Main File. It is simply the person weight (WGHT_PER) divided by the number of household members eligible for selection in the survey, i.e. those aged 15 or over. The general recommendation is that GSS household weight be used only for estimate of household characteristics. For example, to estimate the number of households that live in low-rise apartments, WGHT_HSD should be summed over all records with this characteristic.

No household weight was derived for the corresponding person weights WGHT_CSP and WGHT_SNT. As consequence no household estimates can be generated for variables in sections 10A, 10B, or 11.

CANSIM Table 228-0034 (Domestic Exports)

Question

A researcher is looking for earlier years, specifically for 1980-1989, equivalent to that found in CANSIM Table 228-0034 (now terminated and replaced by another table): Domestic exports, customs-based, by province of origin, monthly. She only needs data for Canada and Quebec and on an annual basis.

I have asked her to look at the various Merchandise Exports tables (90 of them in this theme!) to see if any of these might provide what she needs should her original request not be able to be fulfilled, but would appreciate confirmation.

Answer

The subject matter confirmed that:

"The CIMT database contains data from 1988 and on. Any data that was collected prior to 1988 is archived and, if it is available for dissemination, would be more costly to produce for a client."

New Updates to the DLI Training Repository: DLI Webinar on Three Mental Health Surveys

New content has been added: Recent Mental Health Surveys at Statistics Canada [2015] <https://cudo.carleton.ca/dli-training/3751>

2012 Canadian Community Health Survey – Mental Health (CCHS - MH), which provides a comprehensive look at mental health with respect to who is affected by selected mental disorders, as well as positive mental health of Canadians. It also examines access to and utilization of formal and informal mental health care services and supports, and how people are functioning regardless of whether they have a mental health problem.
2013 Canadian Forces Mental Health Survey (CFMHS), which collected information about the mental health status and the need for mental health services in the Canadian Forces. It also examines the mental health impact of the Canadian Forces work environment and deployment in support of the mission in Afghanistan.

2014 Survey of Living with Chronic Diseases in Canada (SLCDC), which provides information related to the experiences of Canadians with mood and anxiety disorders, including care received from health professionals, medication use and self-management of their condition.

The DLI Training Repository is a valuable resource, containing training sessions and workshop presentations from the DLI, and from other national and international conferences over the years <http://cudo.carleton.ca/>.

Wednesday, February 25, 2015

New ICS study

Senior care: Differences by type of housing
by Carole Sawaya and Martin Turcotte, Social and Aboriginal Statistics Division (SASD)

Insights on Canadian Society

This article provides information on the care provided by caregivers to seniors with a long-term health condition, a disability or problems related to aging. It focuses on how the intensity and nature of the care vary depending on seniors’ type of housing. Four types of housing are examined: care facilities, supportive housing, private households separate from the caregiver, and private households shared with the caregiver.

To access the study released today:

Monday, February 23, 2015

Financial Performance Indicators for Canadian Business

Statistics Canada is no longer producing the Financial Performance Indicators for Canadian Businesses [catalogues 61-224 and 61C0030]. This decision came as the result of a thorough review of the Agency’s activities to manage its resources while maintaining a balanced national statistical program that accurately measures the economy and society.

The Agency continues to provide high-quality and reliable information on Canadian businesses through alternative data sources. Information on specific financial ratios will continue to be available through the annual Financial and Taxation Statistics for Enterprises program: CANSIM table 180-0003 <http://www5.statcan.gc.ca/cansim/pick-choisir?lang=eng&p2=33&id=1800003>; the Quarterly Survey of Financial Statements: CANSIM tables 187-0001 <http://www5.statcan.gc.ca/cansim/pick-choisir?lang=eng&p2=33&id=1870001%C3%A8> and 187-0002 <http://www5.statcan.gc.ca/cansim/pick-choisir?lang=eng&p2=33&id=1870002>; and the Small Business Profiles, which present financial data for small businesses in Canada, available on Industry Canada’s website: Financial Performance Data <http://www.ic.gc.ca/eic/site/pp-pp.nsf/eng/home>.

Friday, February 20, 2015

Corporate Charitable Donations Microdata

Question

A researcher at Concordia is looking for a database that would provide microdata about corporate charitable donations for all SMEs (small and medium enterprises) in Canada (or if it is not possible to limit to SMEs, all companies in Canada). He is not interested in aggregated data, only in firm-level figures. At this point, he is only exploring the availability of such a dataset, so he has not specified a date range yet.

Since we are talking about business microdata, I suppose that the only option would be CDER, am I right? Can this information (presumably collected from T2 Corporation Income Tax returns or similar sources) be accessed through CDER or otherwise?

Answer

In response to your request for firm level figures, I followed up with a contact from CDER – see the response below:

"If the client is referring to what appears on Schedule 2 Charitable Donations and Gifts, then yes, it would be available on CDER. If he wants to work with the micro data, CDER would be his only alternative."

For more information on the confidentiality and security of data in CDER, the following information is available on the FAQ site <http://www.statcan.gc.ca/eng/cder/questions#q2>:

CDER is located within Statistics Canada's Ottawa headquarters. Researchers work alongside full-time Statistics Canada employees who will screen the results that will be released and ensure compliance with confidentiality policies and procedures.

Researchers access data on a dedicated server through computers with no links outside Statistics Canada. They are only provided with the minimum amount of information necessary to complete their research projects. The data that the researchers do use are stripped of identifying information, such as names, contact information, business numbers, detailed geography and industry. Moreover, a combination of measures – user agreements and synthetics databases – are in place to prevent researchers from perusing the individual observations in their data bases.

Thursday, February 19, 2015

Criminal Records

Question

Can anyone suggest where I can find information on the number of people with criminal records, specifically by ethnicity?

I'm not sure whether criminal records ever disappear on their own but I do know that people can sometimes apply to have them removed after a certain period of time. 

Answer

The Canadian Centre for Justice Statistics informed me that this information is not available and suggested Contacting Corrections Canada.

'Dollars' in CANSIM tables

Question

A researcher has a question about the ‘dollars’ mentioned in two CANSIM tables, and is asking for more details. Specifically, he writes:

“I'm interested in Table 153-0074 and 153-0075 (water acquisition costs for manufacturing industries)​. It doesn't specify if these are simple prices, constant dollars etc. Many related tables are in Chained 2002 dollars (i.e. inflation adjusted) - are these available with chained dollars?”

There are no footnotes or other information about these ‘dollar’ figures. I could suggest that he apply an inflation correction, but don’t know which one I would use (Consumer Price Index, Producer Price Index). What would you suggest?

Answer

The author division explained that: "These tables report data in current dollar so there is no adjustment for inflation. In this case, the fact that the survey has a short time frame and that water acquisition costs area pretty stable over time make the adjustment for inflation having less of an impact. All of this also depends on what the researcher wants to do."

Monday, February 16, 2015

Canadian Business Patterns, Dec 2014

Canadian business patterns data are now available for December 2014.
Canadian business patterns data provide counts of active locations by industry classification and employment size categories for Canada and the provinces/territories. Data are compiled from the Business Register, which is a repository of information on the Canadian business population.

Nationally, there were 1,244,694 active locations with employees, and 2,516,161 active locations without employees with a business revenue greater than $30,000 on the Business Register in December.

Note to readers:

With the December 2014 issue, Canadian business patterns have undergone three major changes.

1. The data appear in two separate series, one covering locations with employees, the other covering locations without employees. The second series corresponds to locations previously coded to the employment category called "indeterminate."

2. A new North American Industrial Classification System (NAICS) category has been added to include locations that have not yet received a NAICS code: unclassified. It represents an additional 78,718 locations with employees and 313,107 locations without employees.

3. The second series, locations without employees, also includes locations that were not previously included in tables but that meet the criteria used to define the Business Register coverage. The impact of the change will be the inclusion of approximately 600,000 additional locations.

Changes in methodology or in business industrial classification strategies used by Statistics Canada's Business Register can create increases or decreases in the number of active businesses reported in the data on Canadian business patterns. As a result, these data do not represent changes in the business population over time. Statistics Canada recommends users not to use these data as a time series.

EFT: /MAD_DLI/Root/other-products/Canadian Business Patterns - cbp/2014/cbp2014-dec

Also updated on the DLI Beyond 20/20 Web Data Server (WDS) <https://dli-idd.statcan.gc.ca/wds/

Friday, February 13, 2015

CANSIM for Teaching in 2015

Question

Do we have an approximate date when CANSIM will no longer be accessible? Further to this, may I please ask what we should do when teaching on CANSIM? Should I mention the upcoming changes?

Answer

The goal of the new website is to make sure that Statistics Canada products are user friendly and easy to find on the agency's website. The tables in CANSIM are not disappearing essentially, they are being served up a new and more user friendly way.

As noted in the official Daily announcement the launch of Statistics Canada's new website is slated for fall 2015. Nothing more specific at this time.

CANSIM tables have been replaced by data tables with the same or similar content that have a consistent presentation and will in the future be dynamically updated upon the release of new results. The beta site allows users to find a former CANSIM table number using the “Filter by keyword” search in order to access the corresponding data table. However, the beta site may not still be available: <http://www.statcan.gc.ca/daily-quotidien/141112/tdq141112-eng.htm>

More info:

As part of a multi-year project to develop a new dissemination model, the agency is inviting users to visit its beta site and provide feedback. The information obtained will be used to develop a more dynamic online presence that is easier to navigate and makes information more readily accessible to a wide range of data users.<http://www.statcan.gc.ca/beta/n1/en>

Survey of Financial Security Release (SFS)

Question

We have users again asking when the Survey of Financial Security PUMF will be released. The pending surveys page says Fall 2014.

I am pleased to see that they have released 3 CanSim tables from the survey. Can we get an update on when the PUMF might get released ?

Answer

I was informed that there were changes to be made. The survey division is presenting to an internal committee on February 16th to approve it release. If approved it should be shortly after that.

Food Disappearance Quarterly Statistics

Question

I have a researcher who is looking for quarterly statistics on Food disappearance in Canada. The only available data we have been able to locate is annual (such as the tables linked to from this survey page: <http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=3475>). There are published articles, however, that do use quarterly Canadian data. One of them is:

Reynolds, A. and E. Goddard. 1991. “Structural Change in Canadian Meat Demand.” Canadian Journal of Agricultural Economics 39(2):211–222.

Unfortunately, there is no specific citation of their data source other than “Meat disappearance data are obtained from Agriculture Canada and Statistics Canada.”

Is there any way of obtaining quarterly numbers?

Answer

Unfortunately, the data is not available quarterly. The only data we can provide are annual data as seen in CANSIM table 002-0010.

Thursday, February 12, 2015

Irrigation Statistics

Question

I have a question from a grad student who’s looking into irrigation practices in SK. She asks: "what portion of livestock producers are irrigators and if possible how large their operations are and what they produce with respect to livestock variety. I am also interested in gaining insight into productivity, for example how much more cattle can be supported by irrigated farms over dry land farms?"

Answer

As a starting point you may want to have a look at this site <http://www.irrigationsaskatchewan.com/>.

The subject matter explained that: "the Agriculture Water Survey does not collect livestock information from operations, only what type of crop is grown. Farms that irrigate for forage crops could possibly be providing this for their own use (i.e. livestock) or other operations. Table 3-1 in the 2012 Agriculture Water Use report (see attached) gives the Total area by province of irrigation by crop type."


PCCF+ Guide and Video Tutorial

I have put together a guide and accompanying video showing one approach to using PCCF+ Version 6A1. The video can be found on YouTube at:

<https://www.youtube.com/watch?v=ECoGzP26NbE>

The guide is on our ‘How-to Guides’ page at: <http://library.queensu.ca/madgic/guides/PCCFplus_Guide.pdf>

While there are several ways of approaching the PCCF+, the video and guide propose a two-step process as follows:

1. Getting Postal Codes into SAS dataset format, so the PCCF+ program can read them.

2. Running the PCCF+ program to match your Postal Codes to Census geography.

On the Queen’s Data Services ‘How-to Guides’ page (http://library.queensu.ca/data/how_to_guides), I have put links to a guide, this video, and a sample SAS program (that you would use to bring a text file containing Postal Codes into SAS).


Within the PCCF+ zipped package from DLI, Statistics Canada provides sample PCCF+ SAS programs to do the subsequent matching.

Your comments/suggestions to improve the guide/video are welcome.

Public Links to DLI Updates

Question

The "public" links to the DLI Update do not seem to work. I have checked the URLs and I get an "Access Forbidden" -- to cite one example, this link does not work: <http://www.statcan.gc.ca/dli-ild/doc/update2004-miseajour2004-eng.pdf>.

I've also checked the URL from the Stat Can Library catalogue and get the same result when I try to access the link found in the catalogue record at: <http://statcan.egcatalogue.ca/eg/opac/record/66391>

Answer

As part of a redesign of the DLI website, certain content was removed. In order to meet accessibility standards, documents that were not in an accessible format were removed, such as the PDF versions of the DLI update. These are now archived on the DLI EFT site. These changes were brought forth and discussed with the community over a two year period at DLI Regional Training Sessions. At this time, they are only available through the EFT site.

We can investigate alternative access modes, such as the new DLI Training Repository to host these documents.

Updated Products: General Social Survey (PUMF) 2012

Please note that the documentation for the GSS PUMF Cycle 26 was updated.
The following changes were made to the codebook text for LANHSDC:

1) ‘Only’ added to the description in category 3 (Seulement in French).

2) Category 4 changed to: Multiple languages (Langues multiples in French) from English and French.

3) The note was removed because it was not applicable to the variable.

The updated products listed below and the path to access them via the EFT site.
gss-esg2012c26family-sas-v2.zip
gss-esg2012c26family-spss-v2.zip

gss-c26-gid-E_v2.pdf
esg-c26-gid-F_v2

/MAD_DLI/Root/other-products/General Social Survey - gss/cycle26-2012

Wednesday, February 11, 2015

CCHS 2013 PUMF

Question

When can we expect a PUMF for the 2013 CCHS? Will it be available on its own or will it be combined with 2014?

Answer

The 2013/2014 PUMF will be released this fall and will be mostly unchanged from the previous PUMFS.

In 2015, the CCHS is undergoing a redesign. The 2015/2016 PUMF is not going to be released for over 2 years and therefore we [Health Statistics Division] cannot say at this time what those changes will be. There are changes to the content and we will need to look at new content and decide what will be included. That will not be done until January/February of 2017 most likely.

Monday, February 9, 2015

Historical crime data for Prince George

Question

I have a student who is looking for Incident-based crime statistics, by detailed violations for Prince George from 1950-1965. What he would want would be comparable to the data found in CANSIM Table 252-0081 <http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=2520081&tabMode=dataTable&srchLan=-1&p1=-1&p2=9>, which only goes back to 1998. There is a similar table in the WDS (Crime Statistics, All Police Services, 1977 to 2003), which provides earlier data, but it still doesn't go back as far as this student needs. Is it possible to find earlier data?

Answer

I confirmed with subject matter that earlier data for this jurisdiction is not available.

Inter-provincial Workforce Database

Question

I see “Inter-provincial workforce database” referenced in a couple of reports. Do we have access and if so/not, what is its availability?

Answer

The Canadian Employer-employee Dynamics data base (CEEDD) has now replaced the Inter-Provincial Workforce Data base as the file being used for research on inter-provincial employment.

The CEEDD is available through the Centre for Data Development and Economic Research (CDER) here in Ottawa.

Information on CDER access is available at <http://www.statcan.gc.ca/eng/cder/index>.

Updated Products: International Merchandise Trade Data

International Merchandise Trade Data by Commodity Classification

Revised data is now available on from the DLI. The International Merchandise Trade Data by Commodity Classification provides a Canadian perspective of imports and exports in a globally accepted format, the Harmonized Commodity Description and Coding System (HS).

DLI EFT site:

2014-12 Annual Data
/MAD_DLI/Root/trade_commerce/international-merchandise-data-by-commodity-classification/2014

2013-12 Annual Revised Data
/MAD_DLI/Root/trade_commerce/international-merchandise-data-by-commodity-classification/2013-revised/data/B465_201312_ver2.zip

2012-12 Annual Revised Data
/MAD_DLI/Root/trade_commerce/international-merchandise-data-by-commodity-classification/2012-revised/data/B465_201212_ver3.zip

Also updated on the DLI Beyond 20/20 Web Data Server (WDS)<https://dli-idd.statcan.gc.ca/wds/>

Reference Map Link Issues

Question

The PDF reference maps are supposed to contain embedded links (for inset and CT maps), but they don't seem to work:

<http://www12.statcan.gc.ca/census-recensement/2011/geo/map-carte/ref/cma_ca_ct-rmr_ar_sr/index-eng.cfm>.

Answer

Try clicking on the Insert/Carton 1 hyperlink. I tried a few reference maps myself (eg: Belleville, Toronto and Québec) and they work, but you actually have to click on the Insert/Carton.

Canadian Survey on Disability 2012 PUMF

Question

After the decision to have no PUMF from the 2012 Canadian Survey on Disability, we're wondering if there is a way to demonstrate that the 2001 and 2006 PALS PUMFS are widely used in the academic community. Is there anyway that we could we get some sense of the use of these surveys through odesi, equinox and/or any other server that has counts for individual surveys?

Answer

I included HALS in the list. Any of these downloads could have been used by groups or classes.

Amount of Equinox and/or IDLS Usage, by File Name

Generated 2/10/2015 1:26:57 PM : 459 records

11        HALS_1986_ADULTS_HOU
24        HALS_1986_ADULTS_HOUSEHOLD
4          HALS_1986_ADULTS_INSTITUTION
10        HALS_1986_CHILDREN
199      HALS_1991_ADULTS_HOU
81        PALS2001
130      PALS2006

As a side note, I think that all of the Equinox/IDLS usage stats up to October last year were sent to DLI already. I anticipate sending them final usage figures after the system shuts down.





Friday, February 6, 2015

Updated Products - Labour Force Survey (LFS)

Labour Force Survey (LFS) – January 2015

LFS data for January 2015 are now available on the EFT site.

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.

The LFS guide:

<http://www.statcan.gc.ca/pub/71-543-g/71-543-g2014001-eng.htm>

Eft: /MAD_DLI/Root/other-products/Labour Force Survey - lfs/1976-2013/data/micro2015-01.zip

Wednesday, February 4, 2015

Electric Power Thermal Generating Station Fuel Consumption

Question

We have a student looking for data from the following survey: <http://www23.statcan.gc.ca/imdb/p3Instr.pl?Function=assembleInstr&LI=202712&lang=en&Item_Id=202712>.

He located a few tables in CANSIM, but they don’t provide what he needs. Do we have access to this data?

Answer

The data that is available is through CANSIM. We do not have any other tables from the Annual Survey of Electric Power Thermal Generating Station Fuel Consumption. If the student would like more precise data, I would need to inquire if a custom tab is possible. Note that confidentiality analysis includes the detection of possible direct disclosure, which occurs when the value in a tabulation cell is composed of a few respondents or when the cell is dominated by a few companies.

Updated Products: CTADS 2013

Canadian Tobacco, Alcohol and Drugs Survey - CTADS

The public use microdata file for the 2013 Canadian Tobacco, Alcohol and Drugs Survey is now available on the DLI EFT site.

As of 2013, new content, covering alcohol use as well as prescription and non-prescription drug use, was added to the Canadian Tobacco Use Monitoring Survey. Therefore, the survey is now entitled Canadian Tobacco, Alcohol and Drugs Survey (CTADS).

The overall objective of CTADS is to provide regular and reliable data on tobacco, alcohol and drug use and related issues, with the primary focus on 15- to 24-year-olds.

DLI EFT
/MAD_DLI/Root/other-products/Canadian Tobacco, Alcohol and Drugs Survey - ctads

*please note that the French user guide will not be available until the last week of February.

Monday, February 2, 2015

Birth or Fertility Rate for French-Speaking Women From 1950 to 2005

Question

I am looking for a historical table that would provide birth or fertility rates for French-speaking women in Quebec from 1950 to 2005. This is surprisingly difficult to find. Other than some research articles or books that address specific parts of the period, I did not find comprehensive data. If, as I suspect, there is no existing table, would it be possible to obtain a custom tabulation?

I have also contacted the Institut de la Statistique du Québec to see if they would have the data.

Answer

I confirmed with Health Statistics Division who informed me that:

"We do not have this information here in HSD\Vital stats –birth database. The Institut de la Statistique du Québec may be the better option."

Job Vacancy Statistics (JVS)

Question

A student has looked at the CANSIM tables for the JVS and writes: “unfortunately there are so few observations that I can't get what I need from their summarized information, since most of the data at a province level is just marked as F for having too few observations.”

She needs the NAICS breakdown and the province level. Might it be possible to get this information somehow (custom tab or otherwise)?

Answer

The author division has confirmed that the information is not available: "There is no special tabulation for the JVS. All data available is already on CANSIM."

'Capital Cost' in CANSIM

Question

I have a researcher asking the following question regarding the Cost of Capital:

“Table 383-0026 gives capital cost ($), annually, for manufacturing by province for 2005-2008. But for 2009 and 2010 it says "data not available". It's not suppressed for confidentiality, just not available. However, the same data for all of Canada is available in Table 383-0021, so obviously the underlying data does exist. Can I get the provincial data for 2009 and later?”

Any suggestions?

Answer

The subject matter analyst confirmed that the ‘table will be updated to 2013 in March 2015.’

Release date for GSS 27, 2013 GVP

Question

Is there a release date for the PUMF for the ESG/GSS 27, (2013) DBP/GVP? I was looking at the release dates page <http://www.statcan.gc.ca/eng/dli/prod_date> and couldn’t see the General Social Survey cycle 27 (2013)

Answer

They are 2 separate surveys done in the same year. Every year in GSS is a cycle. 2013 being the 27th cycle, both surveys in Cycle 27 will have that in their title.

There will be 2 PUMFs. The tentative release date for SI is May 2015 while GVP is June 2015.

Pre-University ESL Youth In and Near Waterloo

Question

One number I'm looking for is the number of second-language Canadians (i.e., English not first language), 17 or 18 years old (i.e., pre-university), within 150 km of Waterloo.

Even better: as above + who haven't completed 4 years of high school in Canada (and therefore have to write a test like TOEFL or IELTS).

Can you help me find those numbers? Or something similar?

I know the NHS has much of this information, but I haven’t seen a way to get everything cross-tabulated at the granularity requested. It might have to be the “something similar” but I wanted to doublecheck. They could be interested in pursuing a custom tab. If that’s a possibility, can you provide contact information?

Answer

Try consulting the NHS profile at the DA level on the DLI’s EFT site.