Question
I have a researcher who is in need of an LAD because he needs RRSP and Tax Free Savings Account contributions and withdrawals along with income. From his understanding, the TFSA variables recently added to the LAD after agreements with CRA were finalized. Is this the case?
Answer
Yes, the LAD has both TFSA and RRSP contributions and withdrawals. There is no variable for the size of RRSP holdings.
Regarding your request for LAD data. Due to the highly confidential nature of the LAD data, and given our agreement with the Canada Revenue Agency (CRA) regarding which persons may gain direct access to the LAD data, we do not supply LAD data outside of Statistics Canada, either through the DLI (data liberation initiative) or through the RDCs (Research Data Centres) at this time.
Regarding the cost for obtaining data results from the LAD, all of the prices for custom tables and other output of LAD data are based on a cost-recovery basis. This cost covers the cost of a Statistics Canada analyst performing the necessary functions to obtain any custom requests. There are two possible avenues for a client to obtain the custom output information for their work.
In the first option, a client may choose to send to Statistics Canada custom statistical program(s) written using SAS or STATA software, which we will then submit on our computer system to manipulate the LAD data. Following a check for confidentiality, we will provide then to the client checked custom output. The cost associated with this choice covers the cost of a Statistics Canada analyst submitting the client's programs and also the cost of checking the custom output to ensure the results meet Statistics Canada's confidentiality requirements for data release. The costs associated with this option are generally cheaper than those for the second option since the client would be doing most of the work writing the programs. However, this option generally requires that a client will have some facility with SAS or STATA and knowledge of the LAD, as the data are quite complex to work with.
The second option would be for the client to have a Statistics Canada analyst familiar with the LAD, perform the work of writing and submitting the statistical programs necessary to generate the output and results from the LAD. This could be more expensive since the Statistics Canada analyst would be writing the statistical programs as well as submitting them and providing a confidentiality check of the results. However, it can sometimes save time since the analyst will be familiar with the complex nature of the LAD data.
In both these options, there is a cost for the analyst's time. Most of our clients using these options budget about $5,000 for a smaller project, with some of the more complex projects exceeding $20,000. Again, these costs can vary depending on the researcher's knowledge of LAD, facility with SAS or STATA, their research questions, and whether they choose the first or the second option.
Unfortunately, there is very little information provided in the request regarding what you wish to investigate or what the main research question(s) is(are).
It would be somewhat helpful to know what you wish to investigate because it may be that the LAD is not the best source of information for you and there may be other sources of data that could potentially serve the same purpose.
Thursday, March 6, 2014
Wednesday, March 5, 2014
2011 Farm Receipts
Question
I'm looking for 2011 farm receipts by individual product in Niagara (CD). On the StatCan site, the data by crop is numbers of farms/acres/hectares/head, and the farm receipts are given for categories of total gross only. Am I overlooking something, or is it available as a custom tab?
Answer
According to the Agriculture Division, we do not ask for gross farm receipts by individual products on the census questionnaire; only total gross farm receipts of the operation. You can see how the question is asked in Step 31, page 14, of the census questionnaire at: http://www.statcan.gc.ca/ca-ra2011/201108/q11-eng.pdf
FIPS explained that, the lowest level of geography produced for the Farm Cash Receipts series is at the provincial leveI--in this case for Ontario. Unfortunately, we do not have data for the Niagara region.
Farm Cash Receipts data is available by commodity. Below are links to the related Cansim Tables. The quarterly table includes data for the first three quarters of 2013. To obtain data for Ontario, click on the Add/Remove Data button and then select the required detail (province, commodity, time frame etc…)
CANSIM tables
002-0001 Farm cash receipts, annual <http://www5.statcan.gc.ca/cansim/a03?&lang=eng&pattern=002-0001>
002-0002 Farm cash receipts, quarterly <http://www5.statcan.gc.ca/cansim/a03?&lang=eng&pattern=002-0002>
I'm looking for 2011 farm receipts by individual product in Niagara (CD). On the StatCan site, the data by crop is numbers of farms/acres/hectares/head, and the farm receipts are given for categories of total gross only. Am I overlooking something, or is it available as a custom tab?
Answer
According to the Agriculture Division, we do not ask for gross farm receipts by individual products on the census questionnaire; only total gross farm receipts of the operation. You can see how the question is asked in Step 31, page 14, of the census questionnaire at: http://www.statcan.gc.ca/ca-ra2011/201108/q11-eng.pdf
FIPS explained that, the lowest level of geography produced for the Farm Cash Receipts series is at the provincial leveI--in this case for Ontario. Unfortunately, we do not have data for the Niagara region.
Farm Cash Receipts data is available by commodity. Below are links to the related Cansim Tables. The quarterly table includes data for the first three quarters of 2013. To obtain data for Ontario, click on the Add/Remove Data button and then select the required detail (province, commodity, time frame etc…)
CANSIM tables
002-0001 Farm cash receipts, annual <http://www5.statcan.gc.ca/cansim/a03?&lang=eng&pattern=002-0001>
002-0002 Farm cash receipts, quarterly <http://www5.statcan.gc.ca/cansim/a03?&lang=eng&pattern=002-0002>
CHS 2012 PUMF
Question
The Canadian Community Health Survey 2012 Pumf is listed as to be released in the Fall of 2013. Is there anymore information on when this PUMF might be available ?
Answer
There is no specific release date yet, but it will be later in the Fall.
The Canadian Community Health Survey 2012 Pumf is listed as to be released in the Fall of 2013. Is there anymore information on when this PUMF might be available ?
Answer
There is no specific release date yet, but it will be later in the Fall.
2012 SFS PUMF Release
Question
A researcher is looking for the Nov. 2012 Survey of Financial Security. I can only see the SFS for 1983, 1999 and 2005 listed in the DLI Collection and no mention of it on the soon-to-be-released list. Can you tell me its status?
Answer
They are planning for an SFS PUMF to be released sometime in the Spring of 2014. I will update the Tentative release dates of DLI products accordingly.
A researcher is looking for the Nov. 2012 Survey of Financial Security. I can only see the SFS for 1983, 1999 and 2005 listed in the DLI Collection and no mention of it on the soon-to-be-released list. Can you tell me its status?
Answer
They are planning for an SFS PUMF to be released sometime in the Spring of 2014. I will update the Tentative release dates of DLI products accordingly.
2006 Work Tables
Question
I am trying to locate the following tables in the DLI collection:
Place of Work Status (7), Occupation - National Occupational Classification for Statistics 2006 (11) and Work Activity (4) for the Employed Labour Force 15 Years and Over
Canada, Provinces, Territories, Census Divisions and
Census Subdivisions - Cat. No. 97C0056.
Census Metropolitan Areas, Tracted Census Agglomerations
and Census Tracts - Cat. No. 97C0073.
Both of them have "contact us" next to them, but I assumed I would find them on the FTP site; however, there is nothing that corresponds to the given catalogue numbers in the 2006/Topic-based-tabulations/place-of-work-and-commuting-to-work folder. Am I looking in the wrong place? Are they, in fact, not a DLI product?
Answer
You'll find these tables at the following locations on EFT site:
Cat. No. 97C0056: /MAD_DLI/Root/census_pop_recens/2006/pow_consortium/csds_static_and_flows/canada
Cat. No. 97C0073: /MAD_DLI/Root/census_pop_recens/2006/pow_consortium/cts_static/canada
I am trying to locate the following tables in the DLI collection:
Place of Work Status (7), Occupation - National Occupational Classification for Statistics 2006 (11) and Work Activity (4) for the Employed Labour Force 15 Years and Over
Canada, Provinces, Territories, Census Divisions and
Census Subdivisions - Cat. No. 97C0056.
Census Metropolitan Areas, Tracted Census Agglomerations
and Census Tracts - Cat. No. 97C0073.
Both of them have "contact us" next to them, but I assumed I would find them on the FTP site; however, there is nothing that corresponds to the given catalogue numbers in the 2006/Topic-based-tabulations/place-of-work-and-commuting-to-work folder. Am I looking in the wrong place? Are they, in fact, not a DLI product?
Answer
You'll find these tables at the following locations on EFT site:
Cat. No. 97C0056: /MAD_DLI/Root/census_pop_recens/2006/pow_consortium/csds_static_and_flows/canada
Cat. No. 97C0073: /MAD_DLI/Root/census_pop_recens/2006/pow_consortium/cts_static/canada
Tuesday, March 4, 2014
GDP by CMA
Question
I have a student looking for GDP by CMAs going back to 1991. The Conference Board of Canada's e-Data has this available for a fee. My questions are: has anyone obtained a membership/account for the e-Data? Second - is this data available anywhere else that I may have missed? CANSIM has Canada and Provincial level data.
Answer
We subscribe to the e-Data from CBC as well and get asked this a lot. The documentation is lacking from them. According to an economist at UofT there is potentially manual calculation work-around if a researcher is inclined I believe:
"If they are really only using the CMA employment data to do this, and we
already get it, then really the only thing that your money will be doing
is getting stats that could be computed from what we have. What they are
basically doing is the following: take gdp at the provincial level in each industry (mining, manufacturing etc...probably at the finest level of detail they have that matches the
employment breakdown). Then multiply the GDP in the industry by the fraction of employment in this industry and in the province that is employed in the region (say Toronto or the CMA region). Next they sum up across all of the GDP CMA industry values to get a total...that simple…"
I have a student looking for GDP by CMAs going back to 1991. The Conference Board of Canada's e-Data has this available for a fee. My questions are: has anyone obtained a membership/account for the e-Data? Second - is this data available anywhere else that I may have missed? CANSIM has Canada and Provincial level data.
Answer
We subscribe to the e-Data from CBC as well and get asked this a lot. The documentation is lacking from them. According to an economist at UofT there is potentially manual calculation work-around if a researcher is inclined I believe:
"If they are really only using the CMA employment data to do this, and we
already get it, then really the only thing that your money will be doing
is getting stats that could be computed from what we have. What they are
basically doing is the following: take gdp at the provincial level in each industry (mining, manufacturing etc...probably at the finest level of detail they have that matches the
employment breakdown). Then multiply the GDP in the industry by the fraction of employment in this industry and in the province that is employed in the region (say Toronto or the CMA region). Next they sum up across all of the GDP CMA industry values to get a total...that simple…"
Monday, March 3, 2014
Sibling Deaths
Question
I'm looking for information on data on sibling deaths - accidents vs illnesses, responses to the event, etc. Where can I find information on this?
Answer
The cause of death data was just updated last month to include 2010 and 2011. Searching under “Mortality” might also help.
Deaths (please see the links in the Daily announcement for more information on tables and analysis available):
Daily: <http://www.statcan.gc.ca/dai-quo/index-eng.htm?HPA>
Death: <http://www.statcan.gc.ca/daily-quotidien/130925/dq130925a-eng.htm>
Causes of death (please see the links in the Daily announcement for more information on tables and analysis available) <http://www.statcan.gc.ca/daily-quotidien/140128/dq140128b-eng.htm>
The Canadian GSS Cycle 5 also asked about total number of siblings – including any who had died. Looking at the questionnaire, there are additional questions: “how many brothers do you have still living” and “how many sisters do you have still living”. So, if it doesn’t need to be a PUMF, GSS Cycle 5 (1990) might be considered.
Here's the Masterfile metadata for GSS Cycle 5 available in Nesstar: <http://www62.statcan.ca/webview/> You can view down to the variable level metadata for the Masterfiles.
If it doesn’t have to be Canadian data, it was included in at least one wave of the General Social Survey of the United States. The APS 2001 adults off-reserve asked how many siblings died before age 2. Those are the only ones that I can quickly spot in Equinox using search string (death/died) & (sibling*/brother*/sister*).
I'm looking for information on data on sibling deaths - accidents vs illnesses, responses to the event, etc. Where can I find information on this?
Answer
The cause of death data was just updated last month to include 2010 and 2011. Searching under “Mortality” might also help.
Deaths (please see the links in the Daily announcement for more information on tables and analysis available):
Daily: <http://www.statcan.gc.ca/dai-quo/index-eng.htm?HPA>
Death: <http://www.statcan.gc.ca/daily-quotidien/130925/dq130925a-eng.htm>
Causes of death (please see the links in the Daily announcement for more information on tables and analysis available) <http://www.statcan.gc.ca/daily-quotidien/140128/dq140128b-eng.htm>
The Canadian GSS Cycle 5 also asked about total number of siblings – including any who had died. Looking at the questionnaire, there are additional questions: “how many brothers do you have still living” and “how many sisters do you have still living”. So, if it doesn’t need to be a PUMF, GSS Cycle 5 (1990) might be considered.
Here's the Masterfile metadata for GSS Cycle 5 available in Nesstar: <http://www62.statcan.ca/webview/> You can view down to the variable level metadata for the Masterfiles.
If it doesn’t have to be Canadian data, it was included in at least one wave of the General Social Survey of the United States. The APS 2001 adults off-reserve asked how many siblings died before age 2. Those are the only ones that I can quickly spot in Equinox using search string (death/died) & (sibling*/brother*/sister*).
Subscribe to:
Posts (Atom)