Question
A researcher is studying the village of Wilcox, SK. He thinks that there may be an error with the number reported in the 1991 Census pertaining to the religion question.
In 1991, there were 75 Catholics and 165 Protestants (and no other groups).
In 2001, there 215 Catholics and 75 Protestants.
(Looking down the road to 2011, I am expecting there won't be a number to compare.)
Because Wilcox is home of Notre Dame College, it would be easy to think that he is correct in his hypothesis. Is it possible that the numbers in 1991 were flipped?
Answer
Subject matter experts have looked into the researcher's question about the religion data for Wilcox, SK for 1991 and have provided the following response:
"We have compared the religion data for Wilcox, SK for 1981, 1991 and 2001 and found no indication of any errors made during processing. No change was made to the data from the load stage to the unimpute stage to the final disseminated Religion data.
One possible explanation for the difference between the 1991 and 2001 data is the fact that the 2001 Census was conducted in mid-May, three weeks earlier than it was done in 1991. It is possible that by early June, school residences (i.e. Notre Dame College) would essentially be empty but in mid-May there would still be students in the school residence as well as in private dwellings. So many years after collection, there is no way we can confirm this for sure."
If you or the researcher have any other questions, please not hesitate to contact us.
Friday, November 19, 2010
Farm Workers
Question
A researcher is trying to estimate the exposure of farm workers in Canada to pesticides. That is the big question and we have been trying to figure out what data would help to provide some answers. So far she is stymied by the lack of appropriate data even on the number of farm or agricultural workers.
The Census of Canada has the most detail about occupations. The Census of Agriculture has the most information about farm operations . Files provided by the DLI are helpful, particularly 2006 CEAG Farm Data as it has information on the numbers of farms using herbicides, insecticides, and fungicides; but neither census gets to the heart of the question at the level of detail the researchers would like.
She is wondering whether it is possible to find the following from any source, including a custom tabulation (this is one part of a larger research project with funding):
- Number of farm workers (farm operators plus paid workers)
- By province, or even better by region within each province
- By type of farming operation (livestock, field crops, fruits, berries, hay, etc.)
Her further question is why it is easy to find a CANSIM table with information about the greenhouse, nursery and sod industries but so hard to find information about employees in the other types of agricultural operations.
Answer
The Census of Agriculture unfortunately does not collect data on farm workers or the number of farm workers on an agricultural operation. Our agriculture contacts described the closest data they could offer as follows:
"Unfortunately the Census of Agriculture does not collect data about farm workers, or even the number of farm workers on an agricultural operation. Our questionnaire really focuses only on Operations and Operators.
The only data we could offer is the number of weeks of paid work – yearly and seasonal - by region, and by farm types.
The following link to our released data shows the number of weeks by region: http://www.statcan.gc.ca/pub/95-629-x/2007000/4182411-eng.htm#paid
If you are interested in having the data classified by farm types, this would be a custom request. Our custom tabulation start at $300, and vary according to the level of complexity of the request."
The CEAG Farm Data file in the DLI collection also appears to include variables on paid work.
Additional Information
Another agriculture contact sent me some additional information a few minutes ago explaining that it is easier to find information about workers in the greenhouse, nursery and sod industries because these labour data are collected through the Annual Greenhouse, Sod and Nursery Survey which includes the following questions:
"Please include owners and family workers in the following labour questions:
25. How many seasonal workers did your greenhouse employ (less than 8 months) in 2009?
26. How many permanent workers (full-time and part-time) did your greenhouse employ (8 months and more) in 2009?
27. What was your total payroll (including owners' salaries) in 2009?"
A researcher is trying to estimate the exposure of farm workers in Canada to pesticides. That is the big question and we have been trying to figure out what data would help to provide some answers. So far she is stymied by the lack of appropriate data even on the number of farm or agricultural workers.
The Census of Canada has the most detail about occupations. The Census of Agriculture has the most information about farm operations . Files provided by the DLI are helpful, particularly 2006 CEAG Farm Data as it has information on the numbers of farms using herbicides, insecticides, and fungicides; but neither census gets to the heart of the question at the level of detail the researchers would like.
She is wondering whether it is possible to find the following from any source, including a custom tabulation (this is one part of a larger research project with funding):
- Number of farm workers (farm operators plus paid workers)
- By province, or even better by region within each province
- By type of farming operation (livestock, field crops, fruits, berries, hay, etc.)
Her further question is why it is easy to find a CANSIM table with information about the greenhouse, nursery and sod industries but so hard to find information about employees in the other types of agricultural operations.
Answer
The Census of Agriculture unfortunately does not collect data on farm workers or the number of farm workers on an agricultural operation. Our agriculture contacts described the closest data they could offer as follows:
"Unfortunately the Census of Agriculture does not collect data about farm workers, or even the number of farm workers on an agricultural operation. Our questionnaire really focuses only on Operations and Operators.
The only data we could offer is the number of weeks of paid work – yearly and seasonal - by region, and by farm types.
The following link to our released data shows the number of weeks by region: http://www.statcan.gc.ca/pub/95-629-x/2007000/4182411-eng.htm#paid
If you are interested in having the data classified by farm types, this would be a custom request. Our custom tabulation start at $300, and vary according to the level of complexity of the request."
The CEAG Farm Data file in the DLI collection also appears to include variables on paid work.
Additional Information
Another agriculture contact sent me some additional information a few minutes ago explaining that it is easier to find information about workers in the greenhouse, nursery and sod industries because these labour data are collected through the Annual Greenhouse, Sod and Nursery Survey which includes the following questions:
"Please include owners and family workers in the following labour questions:
25. How many seasonal workers did your greenhouse employ (less than 8 months) in 2009?
26. How many permanent workers (full-time and part-time) did your greenhouse employ (8 months and more) in 2009?
27. What was your total payroll (including owners' salaries) in 2009?"
Number of Students by Subject of Study Broken Down by Actual Universities in Canada
Question
I have a researcher looking for the number of students (headcount) in individual Universities in Canada (e.g. St. Mary's, Dalhousie, University of Toronto, St. FX, etc, etc.). The researcher is also looking for number of students in these Universities broken down by the faculty they are studying in (e.g. Biology, History, Medicine, etc, etc.).
If anyone knows where I can find this information, please let me know.
Thank-you,
Answer
The FTE enrolments by university figures that are in the publications on the Canadian Association of University Teachers website (see their Almanac) may be of interest to the researcher.
We have university enrolments by province in the Postsecondary Student Information System (PSIS) tables in the DLI collection (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/psis-siep-eng.htm) and StatCan can produce university enrolments by institution as a custom tabulation. I have asked our education consultants to confirm if enrolments by field and by university are also available and will let you know as soon as this is confirmed.
Additional Information
We have a Postsecondary Student Information System (PSIS) table in the DLI collection that provides University enrolments, by province of study and by field of study, annual (number), 1992-1993 to 2008-2009 (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/psis-siep-eng.htm). It doesn't include data by institution however.
University enrolments by institution and by field of study can be produced on a custom basis. The minimum cost for one year of data (2008-2009) would be $150. If this is of interest to your client, I will refer you to an Account-Executive in the Western region who can provide an official quote for these custom data.
I hope that these sources and the ones suggested below are helpful.
I have a researcher looking for the number of students (headcount) in individual Universities in Canada (e.g. St. Mary's, Dalhousie, University of Toronto, St. FX, etc, etc.). The researcher is also looking for number of students in these Universities broken down by the faculty they are studying in (e.g. Biology, History, Medicine, etc, etc.).
If anyone knows where I can find this information, please let me know.
Thank-you,
Answer
The FTE enrolments by university figures that are in the publications on the Canadian Association of University Teachers website (see their Almanac) may be of interest to the researcher.
We have university enrolments by province in the Postsecondary Student Information System (PSIS) tables in the DLI collection (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/psis-siep-eng.htm) and StatCan can produce university enrolments by institution as a custom tabulation. I have asked our education consultants to confirm if enrolments by field and by university are also available and will let you know as soon as this is confirmed.
Additional Information
We have a Postsecondary Student Information System (PSIS) table in the DLI collection that provides University enrolments, by province of study and by field of study, annual (number), 1992-1993 to 2008-2009 (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/psis-siep-eng.htm). It doesn't include data by institution however.
University enrolments by institution and by field of study can be produced on a custom basis. The minimum cost for one year of data (2008-2009) would be $150. If this is of interest to your client, I will refer you to an Account-Executive in the Western region who can provide an official quote for these custom data.
I hope that these sources and the ones suggested below are helpful.
Census Tract Maps with Information on Neighbourhoods
Question
I am trying to locate a map of Saskatoon at the census tract level that includes information on neighbourhoods for Census 2006. See attached file for an example from Census 1996. I have been unable to locate one. The reference map at the census tract level available at http://geodepot.statcan.gc.ca/2006/13011619/03130120_05-eng.jsp has census tract codes but does not have matching information on neighbourhoods.
Answer
Our geography contacts have confirmed that similar CT level maps weren't produced for 2006. It may be possible to produce similar maps for 2006 as a custom products on request but there would be a cost to produce them.
Our contacts directed us to the following neighbourhood maps in Saskatoon(available free) and indicated that they may help your users determine on their own which Census Tracts are within each neighbourhood:
Generalized map:
http://www.saskatoon.ca/DEPARTMENTS/Community%20Services/PlanningDevelopment/Documents/Mapping/Wall_maps/index_nhoods_key_map.pdf
Detailed map:
http://www.saskatoon.ca/DEPARTMENTS/Community%20Services/PlanningDevelopment/Documents/Mapping/Wall_maps/index_nhoods_map.pdf
I hope that this is helpful.
I am trying to locate a map of Saskatoon at the census tract level that includes information on neighbourhoods for Census 2006. See attached file for an example from Census 1996. I have been unable to locate one. The reference map at the census tract level available at http://geodepot.statcan.gc.ca/2006/13011619/03130120_05-eng.jsp has census tract codes but does not have matching information on neighbourhoods.
Answer
Our geography contacts have confirmed that similar CT level maps weren't produced for 2006. It may be possible to produce similar maps for 2006 as a custom products on request but there would be a cost to produce them.
Our contacts directed us to the following neighbourhood maps in Saskatoon(available free) and indicated that they may help your users determine on their own which Census Tracts are within each neighbourhood:
Generalized map:
http://www.saskatoon.ca/DEPARTMENTS/Community%20Services/PlanningDevelopment/Documents/Mapping/Wall_maps/index_nhoods_key_map.pdf
Detailed map:
http://www.saskatoon.ca/DEPARTMENTS/Community%20Services/PlanningDevelopment/Documents/Mapping/Wall_maps/index_nhoods_map.pdf
I hope that this is helpful.
Type 2 Diabetes in Children since 1970’s
Question
I have a student looking for the prevalence of Type 2 diabetes in children going back to the 1970's to date or whatever she can find. Anything we are finding is not specific to type 2. Thanks in advance for your help.
Answer
This information doesn't appear to be readily available in CANSIM, on the StatCan website or in the DLI collection. I have therefore asked our health contacts to advise. I will be sure to get back to you through the dlilist as soon as I receive their recommendations.
The third reference in the Diabetes section of Healthy People, Healthy Places (82-229-XWE; http://www.statcan.gc.ca/pub/82-229-x/2009001/status/dia-eng.htm#n3) refers to a non-StatCan publication on Type 2 diabetes in children and may also be of interest to the student:
American Diabetes Association. Type 2 diabetes in children and adolescents. Diabetes Care 2000;23(3)381-389.
Additional Information
Some data on diabetes by type for the 12-19 age group may be available as a custom tabulation from the Canadian Community Health Survey (CCHS). They unfortunately aren't available for children under 12.
Our contacts provided the following information about the custom CCHS data that may be available:
"We don't ask diabetes type to respondents and also our target population is 12+. We did create a derived variable in the CCHS for 2009 to derive the type of diabetes a respondent has. It is based on the series of questions in the chronic conditions module that we ask respondents who answer yes to having diabetes. It's called CCCDDIA. (...) Any tabulation by age group would be a custom tabulation. Unfortunately given that the national estimates for 2009 for the age group 12-19 are suppressed, this tabulation would not be feasible. It might be possible to use the two year data (...)." The division can look into the feasibility of producing this if these data are of interest to the student.
Our contacts also directed us to the following article from Health Reports http://www.statcan.gc.ca/pub/82-003-x/2008001/article/10533-eng.htm which may be of interest.
Please let me know if the student is interested in the custom tables and I will refer you to an Account-Executive who can work with the author division to investigate this further and confirm what tables could be produced, for what years and at what cost.
I have a student looking for the prevalence of Type 2 diabetes in children going back to the 1970's to date or whatever she can find. Anything we are finding is not specific to type 2. Thanks in advance for your help.
Answer
This information doesn't appear to be readily available in CANSIM, on the StatCan website or in the DLI collection. I have therefore asked our health contacts to advise. I will be sure to get back to you through the dlilist as soon as I receive their recommendations.
The third reference in the Diabetes section of Healthy People, Healthy Places (82-229-XWE; http://www.statcan.gc.ca/pub/82-229-x/2009001/status/dia-eng.htm#n3) refers to a non-StatCan publication on Type 2 diabetes in children and may also be of interest to the student:
American Diabetes Association. Type 2 diabetes in children and adolescents. Diabetes Care 2000;23(3)381-389.
Additional Information
Some data on diabetes by type for the 12-19 age group may be available as a custom tabulation from the Canadian Community Health Survey (CCHS). They unfortunately aren't available for children under 12.
Our contacts provided the following information about the custom CCHS data that may be available:
"We don't ask diabetes type to respondents and also our target population is 12+. We did create a derived variable in the CCHS for 2009 to derive the type of diabetes a respondent has. It is based on the series of questions in the chronic conditions module that we ask respondents who answer yes to having diabetes. It's called CCCDDIA. (...) Any tabulation by age group would be a custom tabulation. Unfortunately given that the national estimates for 2009 for the age group 12-19 are suppressed, this tabulation would not be feasible. It might be possible to use the two year data (...)." The division can look into the feasibility of producing this if these data are of interest to the student.
Our contacts also directed us to the following article from Health Reports http://www.statcan.gc.ca/pub/82-003-x/2008001/article/10533-eng.htm which may be of interest.
Please let me know if the student is interested in the custom tables and I will refer you to an Account-Executive who can work with the author division to investigate this further and confirm what tables could be produced, for what years and at what cost.
GSS Cycle 23 PUMF: Release Date
The General Social Survey (GSS) cycle 23 public use microdata file (PUMF) is scheduled to be released in December 2010.
Data for GSS cycle 23 were released on September 28th 2010 (see: http://www.statcan.gc.ca/daily-quotidien/100928/dq100928a-eng.htm) but the PUMF is scheduled to be released in December.
Please don't hesitate to contact us if you have any other questions.
Data for GSS cycle 23 were released on September 28th 2010 (see: http://www.statcan.gc.ca/daily-quotidien/100928/dq100928a-eng.htm) but the PUMF is scheduled to be released in December.
Please don't hesitate to contact us if you have any other questions.
Financial Performance Indicators
Question
The FPI product - on the main product page http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=61-224-XCB&lang=eng it states at the bottom:
"Free access
This product may also be accessible for free at these libraries.
These data are available at no additional charge to Canadian educational institutions participating in the Data Liberation Initiative."
Does this mean that I can hand over this product to someone outside of the University community?
What has happened - an employee of a company not associated in any way with the University called StatCan talked to a representative who in turn gave them my name and contact information. I'm a little confused - can I give it to her or not?
Answer
External clients may use the DSP copy of Financial Performance Indicators but they are not authorised to use the DLI copy of this product. The DSP copy has national level data whereas the DLI copy also includes lower levels of geography. The DLI copy is covered under the DLI licence and may therefore only be used by authorised users.
Thank you for letting us know that an external user was referred to you by the National Contact Centre, we will look into this. Generally, only members of the academic community would be referred to the DLI Contact in a member institution for information about a DLI product. I suspect that in this case the intention was to refer the user to a DSP library.
The FPI product - on the main product page http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=61-224-XCB&lang=eng it states at the bottom:
"Free access
This product may also be accessible for free at these libraries.
These data are available at no additional charge to Canadian educational institutions participating in the Data Liberation Initiative."
Does this mean that I can hand over this product to someone outside of the University community?
What has happened - an employee of a company not associated in any way with the University called StatCan talked to a representative who in turn gave them my name and contact information. I'm a little confused - can I give it to her or not?
Answer
External clients may use the DSP copy of Financial Performance Indicators but they are not authorised to use the DLI copy of this product. The DSP copy has national level data whereas the DLI copy also includes lower levels of geography. The DLI copy is covered under the DLI licence and may therefore only be used by authorised users.
Thank you for letting us know that an external user was referred to you by the National Contact Centre, we will look into this. Generally, only members of the academic community would be referred to the DLI Contact in a member institution for information about a DLI product. I suspect that in this case the intention was to refer the user to a DSP library.
Subscribe to:
Posts (Atom)