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.
Economic Regions
Question
We would like to request descriptions please for the Economic Regions in the Postal Code Conversion File, if available. For your information, please find below* background geography documentation on Economic Regions.
If there are no descriptions per se for the (18) Economic Regions, are there are characteristics that distinguish the 18 Economic Regions from each other at the provincial level and at the national level, e.g., do the 13,592 Economic Regions designated as “10” in Nfld/Labrador resemble each other and the other 198,216 in the rest of Canada, and if so, how?
*background documentation from STC:
The PCCF reference guide (p.20) indicates:
Economic Regions: This identifies an economic region within a province/territory. This field must be combined with the province/territory code to uniquely identify an economic region.
From the Census Dictionary: An economic region (ER) is a grouping of complete census divisions (CDs) (with one exception in Ontario) created as a standard geographic unit for analysis of regional economic activity.
Within the province of Quebec, economic regions (régions administratives) are designated by law. In all other provinces and territories, economic regions are created by agreement between Statistics Canada and the province/territory concerned. Prince Edward Island and the three territories each consist of one economic region. In Ontario, there is one exception where the economic region boundary does not respect census division boundaries: the census division of Halton is split between the ER of Hamilton - Niagara Peninsula and the ER of Toronto.
Answer
Our geography contacts have provided us with the following information in response to your questions about the Economic Region codes in the Postal Code Conversion File (PCCF):
Question:
We would like to request descriptions please for the Economic Regions in the Postal Code Conversion File, if available.
Answer:
"Economic region code
An economic region (ER) is a grouping of complete census divisions (CDs) (with one exception in Ontario) created as a standard geographic unit for analysis of regional economic activity.
Source: December 2009 Postal codes Postal Code Conversion File (PCCF), Reference Guide p. 28)
Each economic region is assigned a two-digit code. In order to uniquely identify each economic region in Canada, the two-digit province/territory code must precede the ER code.
Source: 2006 Census Dictionary http://www12.statcan.gc.ca/census-recensement/2006/ref/dict/geo022a-eng.cfm
An Economic Region is a standard unit created in response to the requirement for a geographical unit suitable for the presentation and analysis of regional economic activity. Such a unit is small enough to permit regional analysis, yet large enough to include enough respondents that, after data are screened for confidentiality, a broad range of statistics can still be released.
The regions are based upon work by Camu, Weeks and Sametz in the 1950s. At the outset, boundaries of regions were drawn in such a way that similarities of socio-economic features within regions were maximized while those among regions were minimized. Later, the regions were modified to consist of counties which define the zone of influence of a major urban centre or metropolitan area. Finally, the regions were adjusted to accommodate changes in CD boundaries and to satisfy provincial needs.
Source: Standard geographical classification, 2006 http://www.statcan.gc.ca/subjects-sujets/standard-norme/sgc-cgt/2006/2006-intro-fin-eng.htm"
Question:
If there are no descriptions per se for the (18) Economic Regions, are there are characteristics that distinguish the 18 Economic Regions from each other at the provincial level and at the national level, e.g., do the 13,592 Economic Regions designated as "10" in Nfld/Labrador resemble each other and the other 198,216 in the rest of Canada, and if so, how?
Answer:
"No, there are no characteristics that distinguish one ERcode from another ERcode.
An ER is a geographical unit, smaller than a province, except in the case of Prince Edward Island and the Territories. The ER is made up by grouping whole census divisions, except for one case in Ontario, where the city of Burlington, a component of Halton (CD 35 24), is excluded from the ER of Toronto and is included in the Hamilton–Niagara Peninsula ER, which encompasses the entire CMA of Hamilton.
There were 76 ERs in 2006.
Source: Standard geographical classification, 2006 http://www.statcan.gc.ca/subjects-sujets/standard-norme/sgc-cgt/2006/2006-intro-fin-eng.htm"
Question:
Do provinces and territories all assign these numbers independently of each other?
Answer:
"ERs may be economic, administrative or development regions. Within the province of Quebec, economic regions are designated by law ("les régions administratives"). In all other provinces, economic regions are created by agreement between Statistics Canada and the provinces concerned.
Source: Standard geographical classification, 2006 http://www.statcan.gc.ca/subjects-sujets/standard-norme/sgc-cgt/2006/2006-intro-fin-eng.htm"
Question:
Is there any kind of common reason why the provinces and territories use "10" and in decreasing numbers "20", "30", etc.? Does 3510 (Ontario) have any relation to 2410 (Québec) or "3590" and "2490"?
Answer:
"No, there is no methodological reason why the provinces and territories use the numbers that they do, there is no relation between 3510 (Ontario) and 2410 (Québec) or 3590 and 2490. They are simply sequential numbers, no relationship between numbers and provinces."
We would like to request descriptions please for the Economic Regions in the Postal Code Conversion File, if available. For your information, please find below* background geography documentation on Economic Regions.
If there are no descriptions per se for the (18) Economic Regions, are there are characteristics that distinguish the 18 Economic Regions from each other at the provincial level and at the national level, e.g., do the 13,592 Economic Regions designated as “10” in Nfld/Labrador resemble each other and the other 198,216 in the rest of Canada, and if so, how?
*background documentation from STC:
The PCCF reference guide (p.20) indicates:
Economic Regions: This identifies an economic region within a province/territory. This field must be combined with the province/territory code to uniquely identify an economic region.
From the Census Dictionary: An economic region (ER) is a grouping of complete census divisions (CDs) (with one exception in Ontario) created as a standard geographic unit for analysis of regional economic activity.
Within the province of Quebec, economic regions (régions administratives) are designated by law. In all other provinces and territories, economic regions are created by agreement between Statistics Canada and the province/territory concerned. Prince Edward Island and the three territories each consist of one economic region. In Ontario, there is one exception where the economic region boundary does not respect census division boundaries: the census division of Halton is split between the ER of Hamilton - Niagara Peninsula and the ER of Toronto.
Answer
Our geography contacts have provided us with the following information in response to your questions about the Economic Region codes in the Postal Code Conversion File (PCCF):
Question:
We would like to request descriptions please for the Economic Regions in the Postal Code Conversion File, if available.
Answer:
"Economic region code
An economic region (ER) is a grouping of complete census divisions (CDs) (with one exception in Ontario) created as a standard geographic unit for analysis of regional economic activity.
Source: December 2009 Postal codes Postal Code Conversion File (PCCF), Reference Guide p. 28)
Each economic region is assigned a two-digit code. In order to uniquely identify each economic region in Canada, the two-digit province/territory code must precede the ER code.
Source: 2006 Census Dictionary http://www12.statcan.gc.ca/census-recensement/2006/ref/dict/geo022a-eng.cfm
An Economic Region is a standard unit created in response to the requirement for a geographical unit suitable for the presentation and analysis of regional economic activity. Such a unit is small enough to permit regional analysis, yet large enough to include enough respondents that, after data are screened for confidentiality, a broad range of statistics can still be released.
The regions are based upon work by Camu, Weeks and Sametz in the 1950s. At the outset, boundaries of regions were drawn in such a way that similarities of socio-economic features within regions were maximized while those among regions were minimized. Later, the regions were modified to consist of counties which define the zone of influence of a major urban centre or metropolitan area. Finally, the regions were adjusted to accommodate changes in CD boundaries and to satisfy provincial needs.
Source: Standard geographical classification, 2006 http://www.statcan.gc.ca/subjects-sujets/standard-norme/sgc-cgt/2006/2006-intro-fin-eng.htm"
Question:
If there are no descriptions per se for the (18) Economic Regions, are there are characteristics that distinguish the 18 Economic Regions from each other at the provincial level and at the national level, e.g., do the 13,592 Economic Regions designated as "10" in Nfld/Labrador resemble each other and the other 198,216 in the rest of Canada, and if so, how?
Answer:
"No, there are no characteristics that distinguish one ERcode from another ERcode.
An ER is a geographical unit, smaller than a province, except in the case of Prince Edward Island and the Territories. The ER is made up by grouping whole census divisions, except for one case in Ontario, where the city of Burlington, a component of Halton (CD 35 24), is excluded from the ER of Toronto and is included in the Hamilton–Niagara Peninsula ER, which encompasses the entire CMA of Hamilton.
There were 76 ERs in 2006.
Source: Standard geographical classification, 2006 http://www.statcan.gc.ca/subjects-sujets/standard-norme/sgc-cgt/2006/2006-intro-fin-eng.htm"
Question:
Do provinces and territories all assign these numbers independently of each other?
Answer:
"ERs may be economic, administrative or development regions. Within the province of Quebec, economic regions are designated by law ("les régions administratives"). In all other provinces, economic regions are created by agreement between Statistics Canada and the provinces concerned.
Source: Standard geographical classification, 2006 http://www.statcan.gc.ca/subjects-sujets/standard-norme/sgc-cgt/2006/2006-intro-fin-eng.htm"
Question:
Is there any kind of common reason why the provinces and territories use "10" and in decreasing numbers "20", "30", etc.? Does 3510 (Ontario) have any relation to 2410 (Québec) or "3590" and "2490"?
Answer:
"No, there is no methodological reason why the provinces and territories use the numbers that they do, there is no relation between 3510 (Ontario) and 2410 (Québec) or 3590 and 2490. They are simply sequential numbers, no relationship between numbers and provinces."
Thursday, November 18, 2010
Place of Work Statistics
Question
I have a question from a team of graduate students and faculty member. These patrons are looking to do some modelling based on place of work information (DA level); however, rather than household-based statistics, they're hoping for something which is industry-based. That is, they do not want to know how many people who live in DA1 work in retail vs. manufacturing occupations, but what the concentration of retail companies or manufacturing companies is in DA1 (for example). Similarly, they don't care how many residents of DA2 take the bus to work, but are interested in how many people who work in DA2 took the bus to get there.
I have explained to them that the Census is household based, but they wanted to know if anyone might know of another way of obtaining information about DAs from the perspective of businesses (up to and including custom files). In fact, I think they want to try to link to link DAs if they can (ie, connect commuters from their home DAs to their work DAs). As you can see from the list of variables they require, about half of them are easily answered by the profile series. Alas it is the latter half which is problematic (at least as the team would like it).
Total Population
Total Private Dwellings
Total Private Dwellings occupied by usual residents
Land Area (km²)
Total Population Density/km²
Total Number of Households
Average Household Size (HH)
Median HH Income ($)
Auto Ownership (Average Autos per HH)
Total Employment
Total Employment by Industry
Retail Trade Employment
Non-Retail Trade Employment
Place of Work (POW) Status
Mode of transportation to work
Average Trip Length for Home Based Work (HBW) Trip
Average Trip Length for Home Based Non-Work (HBNW) Trip
Average Trip Length for Non-Home Based (NHB) Trip
Does anyone have any suggestions? Is this something that could even be requested as a custom table (or tables)? To add to the interesting situation, this team is also working with the RDC, so there are questions floating around about whether or not the RDC might be able to get this dream file in the long run.
Thank you for any help you can provide (even if it's verifying that it is not possible to get the data in the form they'd like).
Answer
I have received a description of a DA level place of work based custom product that could be produced for the students. I will send you the description of the product off-list and the contact details of an Account-Executive in Halifax who is available to discuss this product with you or the students.
I have a question from a team of graduate students and faculty member. These patrons are looking to do some modelling based on place of work information (DA level); however, rather than household-based statistics, they're hoping for something which is industry-based. That is, they do not want to know how many people who live in DA1 work in retail vs. manufacturing occupations, but what the concentration of retail companies or manufacturing companies is in DA1 (for example). Similarly, they don't care how many residents of DA2 take the bus to work, but are interested in how many people who work in DA2 took the bus to get there.
I have explained to them that the Census is household based, but they wanted to know if anyone might know of another way of obtaining information about DAs from the perspective of businesses (up to and including custom files). In fact, I think they want to try to link to link DAs if they can (ie, connect commuters from their home DAs to their work DAs). As you can see from the list of variables they require, about half of them are easily answered by the profile series. Alas it is the latter half which is problematic (at least as the team would like it).
Total Population
Total Private Dwellings
Total Private Dwellings occupied by usual residents
Land Area (km²)
Total Population Density/km²
Total Number of Households
Average Household Size (HH)
Median HH Income ($)
Auto Ownership (Average Autos per HH)
Total Employment
Total Employment by Industry
Retail Trade Employment
Non-Retail Trade Employment
Place of Work (POW) Status
Mode of transportation to work
Average Trip Length for Home Based Work (HBW) Trip
Average Trip Length for Home Based Non-Work (HBNW) Trip
Average Trip Length for Non-Home Based (NHB) Trip
Does anyone have any suggestions? Is this something that could even be requested as a custom table (or tables)? To add to the interesting situation, this team is also working with the RDC, so there are questions floating around about whether or not the RDC might be able to get this dream file in the long run.
Thank you for any help you can provide (even if it's verifying that it is not possible to get the data in the form they'd like).
Answer
I have received a description of a DA level place of work based custom product that could be produced for the students. I will send you the description of the product off-list and the contact details of an Account-Executive in Halifax who is available to discuss this product with you or the students.
DLI National Training Day
Dear DLI Contacts,
We are pleased to inform all DLI Contacts that the following DLI training events are being planned for May 2011. Mark your calendars!
DLI National Training Day 2011 - Monday, May 30, 2011
Simon Fraser University, Vancouver, BC
DLI Bootcamp - Tuesday, May 31, 2011
Simon Fraser University, Vancouver, BC
Please visit the official DLI 2011 website for registration and program information.
These DLI training events are taking place before the start of IASSIST 2011 main conference which is being in Vancouver BC from June 1st to 3rd, 2011. IASSIST pre-conference workshops are also being held on Tuesday May 31, 2011.
Additional information regarding the DLI National Training Day and the DLI Bootcamp will be sent out in the near future. Should you have any questions regarding these DLI training events, please do not hesitate to contact us.
We are pleased to inform all DLI Contacts that the following DLI training events are being planned for May 2011. Mark your calendars!
DLI National Training Day 2011 - Monday, May 30, 2011
Simon Fraser University, Vancouver, BC
DLI Bootcamp - Tuesday, May 31, 2011
Simon Fraser University, Vancouver, BC
Please visit the official DLI 2011 website for registration and program information.
These DLI training events are taking place before the start of IASSIST 2011 main conference which is being in Vancouver BC from June 1st to 3rd, 2011. IASSIST pre-conference workshops are also being held on Tuesday May 31, 2011.
Additional information regarding the DLI National Training Day and the DLI Bootcamp will be sent out in the near future. Should you have any questions regarding these DLI training events, please do not hesitate to contact us.
Canadian Tobacco Use Monitoring Survey (CTUMS) 2009 - Cycle 2 and Annual
The Canadian Tobacco Use Monitoring Survey (CTUMS) 2009 - cycle 2 and annual public use microdata file (PUMF) is now available on the DLI FTP and website.
"This survey tracks changes in smoking status, especially for populations most at risk such as the 15- to 24-year-olds. It allows Health Canada to estimate smoking prevalence for the 15- to 24-year-old and the 25-and-older groups by province and by gender on a semi-annual basis." (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=82M0020X&lang=eng)
FTP:
/DissFTP/dli/DLI Coll._Other prod/Canadian Tobacco Use Monitoring Survey - ctums/2009/annual /Diss
FTP/dli/DLI Coll._Other prod/Canadian Tobacco Use Monitoring Survey - ctums/2009/cycle2
WEB:
http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/ctums-esutc/2009survey-tobacco-enquete-tabac-eng.htm
http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/ctums-esutc/2009c2survey-tobacco-enquete-tabac-eng.htm
"This survey tracks changes in smoking status, especially for populations most at risk such as the 15- to 24-year-olds. It allows Health Canada to estimate smoking prevalence for the 15- to 24-year-old and the 25-and-older groups by province and by gender on a semi-annual basis." (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=82M0020X&lang=eng)
FTP:
/DissFTP/dli/DLI Coll._Other prod/Canadian Tobacco Use Monitoring Survey - ctums/2009/annual /Diss
FTP/dli/DLI Coll._Other prod/Canadian Tobacco Use Monitoring Survey - ctums/2009/cycle2
WEB:
http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/ctums-esutc/2009survey-tobacco-enquete-tabac-eng.htm
http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/ctums-esutc/2009c2survey-tobacco-enquete-tabac-eng.htm
Staged Versus Unstaged
Question
I wonder if someone can help me with some terminology. I have a student who is interested in analyzing Canadian Health Measures Survey data at an RDC. I asked one of our regional RDC analysts when this data would be available. He said that the unstaged wave 4 data will be available sometime in November, with a staged version released to the RDCs a week or two after that.
Can anyone please explain staged vs. unstaged?
Also, I am not getting a clear answer about the availability of this data. Are Waves 1 and 2 already available to the RDCs if they have an approved researcher waiting for that data? Or are all four waves being made available to the RDCs at the same time?
Answer
We consulted our RDC colleagues about your questions they described "staging" as follows:
"Staging involves preparing the SAS, SPSS and STATA files as well as the metadata to adhere to certain standards. We reduce the workload of the RDC Analysts by minimizing the multiple reproductions of data files and associated applications at each RDC. We also improve data quality by minimizing the number of reproductions of data files and associated applications; and by verifying the data files produced by the Survey Focal Point (SFP,. A.k.a. the Subject Matter areas responsible for each survey) before data are released for use at the RDCs."
The DLI unit tends to use "author division" or "subject matter division" when referring to the "Survey Focal Point".
Our RDC colleagues also confirmed that:
"CHMS Cycle 1 Wave 1 and Cycle 1 Wave 2 are available in the RDCs. CHMS Cycle 1 Wave 3 is currently being staged."
I wonder if someone can help me with some terminology. I have a student who is interested in analyzing Canadian Health Measures Survey data at an RDC. I asked one of our regional RDC analysts when this data would be available. He said that the unstaged wave 4 data will be available sometime in November, with a staged version released to the RDCs a week or two after that.
Can anyone please explain staged vs. unstaged?
Also, I am not getting a clear answer about the availability of this data. Are Waves 1 and 2 already available to the RDCs if they have an approved researcher waiting for that data? Or are all four waves being made available to the RDCs at the same time?
Answer
We consulted our RDC colleagues about your questions they described "staging" as follows:
"Staging involves preparing the SAS, SPSS and STATA files as well as the metadata to adhere to certain standards. We reduce the workload of the RDC Analysts by minimizing the multiple reproductions of data files and associated applications at each RDC. We also improve data quality by minimizing the number of reproductions of data files and associated applications; and by verifying the data files produced by the Survey Focal Point (SFP,. A.k.a. the Subject Matter areas responsible for each survey) before data are released for use at the RDCs."
The DLI unit tends to use "author division" or "subject matter division" when referring to the "Survey Focal Point".
Our RDC colleagues also confirmed that:
"CHMS Cycle 1 Wave 1 and Cycle 1 Wave 2 are available in the RDCs. CHMS Cycle 1 Wave 3 is currently being staged."
Census Tables by Occupation
Question
In the 2001 Census the following table was released by Census tract:
Occupation - 2001 National Occupational Classification for Statistics (60), Age Groups (10) and Sex (3) for Labour Force 15 Years and Over (20% sample data) 95F0384XCB01002.
Am I correct that NO tables that include occupation were released for 2006 at the Census Tract level? If you have a handy explanation I can pass on to the student, it would be nice. It does seem odd, as it would appear this would be a popular table.
Answer
The 2006 Census topic-based tabulations on occupation don't seem to include tables with data at the Census Tract level but labour force by sex by occupation at the Census Tract level are available in the 2006 Census complete cumulative profile: http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/prof/rel/Lp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=89103&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=81&VID=0&VNAMEE=&VNAMEF=
For 2006 these data would unfortunately only be available as a custom table. If this is of interest to the student, I will refer you to an Account-Executive in our Montreal Regional Office who can give you a cost estimate for such a table.
Our census contacts have looked into why this table wasn't produced for 2006 and sent us this explanation: "There are a few reasons why this table was not reproduced for 2006. First, a cross-tabulation this size at the CT level had a lot of empty cells, so this table would have come under review from a data perspective. Also the content for the entire 2006 Census dissemination cycle was reviewed and streamlined across all topics. It was decided not to apply the standard geographic hierarchies to the basic cross-tabulations and so the CT level was not applied to all tables."
I hope that this information is helpful. If you have any other questions, please do not hesitate to contact us.
In the 2001 Census the following table was released by Census tract:
Occupation - 2001 National Occupational Classification for Statistics (60), Age Groups (10) and Sex (3) for Labour Force 15 Years and Over (20% sample data) 95F0384XCB01002.
Am I correct that NO tables that include occupation were released for 2006 at the Census Tract level? If you have a handy explanation I can pass on to the student, it would be nice. It does seem odd, as it would appear this would be a popular table.
Answer
The 2006 Census topic-based tabulations on occupation don't seem to include tables with data at the Census Tract level but labour force by sex by occupation at the Census Tract level are available in the 2006 Census complete cumulative profile: http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/prof/rel/Lp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=89103&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=81&VID=0&VNAMEE=&VNAMEF=
For 2006 these data would unfortunately only be available as a custom table. If this is of interest to the student, I will refer you to an Account-Executive in our Montreal Regional Office who can give you a cost estimate for such a table.
Our census contacts have looked into why this table wasn't produced for 2006 and sent us this explanation: "There are a few reasons why this table was not reproduced for 2006. First, a cross-tabulation this size at the CT level had a lot of empty cells, so this table would have come under review from a data perspective. Also the content for the entire 2006 Census dissemination cycle was reviewed and streamlined across all topics. It was decided not to apply the standard geographic hierarchies to the basic cross-tabulations and so the CT level was not applied to all tables."
I hope that this information is helpful. If you have any other questions, please do not hesitate to contact us.
1953 Canadian Weight Height Survey
Question
We have had a request from a researcher here for the data from the 1953 Canadian Weight Height Survey. This survey was conducted by the Dominion Bureau of Statistics (Statistics Canada's predecessor) and one of the articles we found stated that the tables and the report were issued by the Department of National Health and Welfare. The records were apparently transcribed to punch cards. I know this is a real long shot, but by any chance does anyone know if the data is available in a digital medium?
Answer
I would be surprised if this is available on digital media as this was well before the DBS had much in the way of computing power. The first major survey processed on the computer was the 1958 Survey of Farm Income and Expenditures. Those tapes have not been preserved although we did migrate them a few times, but they rusted out and were abandoned.
Additional Information
Our health contacts have confirmed that, as was suspected, these data unfortunately no longer exist here at Statistics Canada. They thought that the following articles about the 1953 survey could be of interest to your researcher:
http://www.nature.com/oby/journal/v10/n7/full/oby200290a.html
http://www.cdc.gov/nchs/data/series/sr_11/sr11_008.pdf
As I mentioned off list earlier this week, I consulted the UofT Data Library website and the 1953 survey doesn't appear to be listed there either.
I hope that this confirmation is helpful.
We have had a request from a researcher here for the data from the 1953 Canadian Weight Height Survey. This survey was conducted by the Dominion Bureau of Statistics (Statistics Canada's predecessor) and one of the articles we found stated that the tables and the report were issued by the Department of National Health and Welfare. The records were apparently transcribed to punch cards. I know this is a real long shot, but by any chance does anyone know if the data is available in a digital medium?
Answer
I would be surprised if this is available on digital media as this was well before the DBS had much in the way of computing power. The first major survey processed on the computer was the 1958 Survey of Farm Income and Expenditures. Those tapes have not been preserved although we did migrate them a few times, but they rusted out and were abandoned.
Additional Information
Our health contacts have confirmed that, as was suspected, these data unfortunately no longer exist here at Statistics Canada. They thought that the following articles about the 1953 survey could be of interest to your researcher:
http://www.nature.com/oby/journal/v10/n7/full/oby200290a.html
http://www.cdc.gov/nchs/data/series/sr_11/sr11_008.pdf
As I mentioned off list earlier this week, I consulted the UofT Data Library website and the 1953 survey doesn't appear to be listed there either.
I hope that this confirmation is helpful.
Portrait of Official-Language Minorities in Canada: Anglophones in Quebec
A Portrait of Official-Language Minorities in Canada: Anglophones in Quebec is being released today. This study paints a general statistical portrait of the official-language minority in Quebec based on data from the Census of Population and the Survey on the Vitality of Official-language Minorities in Canada, conducted in 2006. The purpose of such a portrait is to present a set of characteristics, behaviours and perceptions of the official-language minority population, exploiting the analytical opportunities contained in the data.
This demolinguistic portrait of the English-speaking population in Quebec was undertaken with the financial support of Canadian Heritage's Official Languages Secretariat, Human Resources and Social Development Canada and Justice Canada. It is one of eleven such portraits of official-language minorities in Canada, prepared by the Statistics Canada's Language Statistics Section.
Enclosed is the link to the Spotlight on the Census web page http://www12.statcan.ca/census-recensement/index-eng.cfm
This demolinguistic portrait of the English-speaking population in Quebec was undertaken with the financial support of Canadian Heritage's Official Languages Secretariat, Human Resources and Social Development Canada and Justice Canada. It is one of eleven such portraits of official-language minorities in Canada, prepared by the Statistics Canada's Language Statistics Section.
Enclosed is the link to the Spotlight on the Census web page http://www12.statcan.ca/census-recensement/index-eng.cfm
Thursday, October 28, 2010
Tuition and Living Accomodation Costs for Full-Time Students (TLAC) Survey
Question
I will be providing this survey data to a researcher at my institution, but first I have a few questions about the information itself.
1. Table 3 in the xls file entitled Tables 1-8 2009-2010 Prelim.xls contains the information about tuition fees for foreign students that I am looking for. However, I notice that the questionnaire itself asks respondents to indicate whether they are reporting tuition fees at their institution per academic year, semester, per credit or other. It appears as if the $ values reported in the spreadsheet represent tuition fees per academic year, but I would like to confirm whether this is correct.
2. Based on the title of this excel spreadsheet, I am assuming that this is preliminary data and that a final report will be available at some point? When will this be available? Also, when will the data for 2010-2011 be available?
3. This is just a comment: Being a new DLI rep, I have much to learn. I was not expecting to find the results of this survey in an excel spreadsheet. (I assumed that the survey data was usually made available for SPSS).
Answer
Thank you for your questions about TLAC. We couldn't locate a file titled Tables 1-8 2009-2010 Prelim.xls. but suspect that you were referring to the file Tables 1-7 2009-2010Prelim.xls.
I spoke with our contacts for TLAC and they confirmed that:
1) The reference period for the data in the TLAC tables is the academic year. (After speaking with our contact I noticed that additional explanatory notes which may be of interest are available in the Footnotes tab of the spreadsheet.)
2) The DLI should be receiving final 2009-2010 and preliminary 2010-2011 TLAC data at the beginning of October. I will be sending out an announcement as soon as they are available on our FTP and website. Some final 2009-2010 and preliminary 2010-2011 TLAC data are scheduled to be released on Sept. 16 (there will be an announcement in The Daily) but we won't be receiving our tables until a few weeks later as we receive a wider set of tables that won't all be ready until the beginning of October.
3) You are correct that many of the data files in the DLI collection need to be consulted with statistical analysis applications such as SPSS. This applies to the public use microdata files (PUMFs) in our collection. The DLI collection also includes a large number of aggregate data files, many of which are in the areas of justice and education. Most of these aggregate data products are available in Excel format or Beyond 20/20 format. For additional information on aggregate data and microdata, you may be interested in the following section of the DLI Survival Guide which discusses different types of data (http://www.statcan.gc.ca/dli-ild/guide-trousse/guide-trousse/toc-tdm/3000276-eng.htm#diffagg).
I hope that this information is helpful. Please don't hesitate to contact us if you have any other questions.
I will be providing this survey data to a researcher at my institution, but first I have a few questions about the information itself.
1. Table 3 in the xls file entitled Tables 1-8 2009-2010 Prelim.xls contains the information about tuition fees for foreign students that I am looking for. However, I notice that the questionnaire itself asks respondents to indicate whether they are reporting tuition fees at their institution per academic year, semester, per credit or other. It appears as if the $ values reported in the spreadsheet represent tuition fees per academic year, but I would like to confirm whether this is correct.
2. Based on the title of this excel spreadsheet, I am assuming that this is preliminary data and that a final report will be available at some point? When will this be available? Also, when will the data for 2010-2011 be available?
3. This is just a comment: Being a new DLI rep, I have much to learn. I was not expecting to find the results of this survey in an excel spreadsheet. (I assumed that the survey data was usually made available for SPSS).
Answer
Thank you for your questions about TLAC. We couldn't locate a file titled Tables 1-8 2009-2010 Prelim.xls. but suspect that you were referring to the file Tables 1-7 2009-2010Prelim.xls.
I spoke with our contacts for TLAC and they confirmed that:
1) The reference period for the data in the TLAC tables is the academic year. (After speaking with our contact I noticed that additional explanatory notes which may be of interest are available in the Footnotes tab of the spreadsheet.)
2) The DLI should be receiving final 2009-2010 and preliminary 2010-2011 TLAC data at the beginning of October. I will be sending out an announcement as soon as they are available on our FTP and website. Some final 2009-2010 and preliminary 2010-2011 TLAC data are scheduled to be released on Sept. 16 (there will be an announcement in The Daily) but we won't be receiving our tables until a few weeks later as we receive a wider set of tables that won't all be ready until the beginning of October.
3) You are correct that many of the data files in the DLI collection need to be consulted with statistical analysis applications such as SPSS. This applies to the public use microdata files (PUMFs) in our collection. The DLI collection also includes a large number of aggregate data files, many of which are in the areas of justice and education. Most of these aggregate data products are available in Excel format or Beyond 20/20 format. For additional information on aggregate data and microdata, you may be interested in the following section of the DLI Survival Guide which discusses different types of data (http://www.statcan.gc.ca/dli-ild/guide-trousse/guide-trousse/toc-tdm/3000276-eng.htm#diffagg).
I hope that this information is helpful. Please don't hesitate to contact us if you have any other questions.
Dairy Quotas
Question
Is there a public source indicating the value of dairy quotas - amount needed to purchase, value of current quotas, etc.?
The student is most interested in Ontario, if this information differs by province.
Thanks in advance.
Answer
Data on quotas are also available through the Canadian Farm Financial Database and E-Stat. Detailed instructions from our agriculture contacts on how to locate these follow:
1. Canadian Farm Financial Database at http://cansim2.statcan.gc.ca/cgi-win/cnsmcgi.pgm?Lang=E&CANSIMFile=CFFD-BDFEAC/ESAS_SESA-eng.htm
Click Taxation Data Program (left menu)
In the box Data Type, select Revenues and Expenses of Farms, select year(s), geographical area(s), farm type (Dairy cattle and milk production) and revenue class. On the resulting table, the variable 'R458 Quota sale income - dollars' gives total amount, averages, farms reporting etc.
2. E-Stat
The student can access E-Stat for free at http://www.statcan.gc.ca/estat/licence-eng.htm.
In 'Search CANSIM in E-Stat', enter 'quota' in the search field. In the 3 tables, you will find variables like 'Quota, long-term assets', 'Current asset - quota', 'Quota -investment' and 'Quota - sales', by year and province. However, it is not broken down by farm type and does not precise what type of quota it refers to.
Additional data can also be extracted on a cost-recovery basis.
I hope that that these suggestions are helpful.
Additional Advice
This document may help http://www.milk.org/corporate/pdf/AboutUs-MilkPricing.pdf it is the DFO MILK PRICING REGULATION 11/10 MILK ACT, R.S.O. 1990, CHAPTER M-12, AS AMENDED that went into force on Sept. 1, 2010.
It gets a bit more complicated when determining the cost of milk see http://www.milk.org/corporate/pdf/AboutUs-FeesRegs.pdf
There is more information pertaining to the Ontario Dairy Farmers at http://www.milk.org/corporate/view.aspx?content=AboutUs/Regulations
Is there a public source indicating the value of dairy quotas - amount needed to purchase, value of current quotas, etc.?
The student is most interested in Ontario, if this information differs by province.
Thanks in advance.
Answer
Data on quotas are also available through the Canadian Farm Financial Database and E-Stat. Detailed instructions from our agriculture contacts on how to locate these follow:
1. Canadian Farm Financial Database at http://cansim2.statcan.gc.ca/cgi-win/cnsmcgi.pgm?Lang=E&CANSIMFile=CFFD-BDFEAC/ESAS_SESA-eng.htm
Click Taxation Data Program (left menu)
In the box Data Type, select Revenues and Expenses of Farms, select year(s), geographical area(s), farm type (Dairy cattle and milk production) and revenue class. On the resulting table, the variable 'R458 Quota sale income - dollars' gives total amount, averages, farms reporting etc.
2. E-Stat
The student can access E-Stat for free at http://www.statcan.gc.ca/estat/licence-eng.htm.
In 'Search CANSIM in E-Stat', enter 'quota' in the search field. In the 3 tables, you will find variables like 'Quota, long-term assets', 'Current asset - quota', 'Quota -investment' and 'Quota - sales', by year and province. However, it is not broken down by farm type and does not precise what type of quota it refers to.
Additional data can also be extracted on a cost-recovery basis.
I hope that that these suggestions are helpful.
Additional Advice
This document may help http://www.milk.org/corporate/pdf/AboutUs-MilkPricing.pdf it is the DFO MILK PRICING REGULATION 11/10 MILK ACT, R.S.O. 1990, CHAPTER M-12, AS AMENDED that went into force on Sept. 1, 2010.
It gets a bit more complicated when determining the cost of milk see http://www.milk.org/corporate/pdf/AboutUs-FeesRegs.pdf
There is more information pertaining to the Ontario Dairy Farmers at http://www.milk.org/corporate/view.aspx?content=AboutUs/Regulations
Credit Counselling Information
Question
Hello all. Not sure if anyone here can help, but if there is an answer, I'm sure I won't find a more-knowledgeable group to ask. Cheers and thanks.
Here’s the situation: from the mid-1960s until March 31, 1992, the province subsidized the operating expenses of non-profit credit counselling agencies in Ontario. Ideally, I’d like to know how much each agency received from the province in each year over this period. The annual Report of the Minister of Community and Social Services usually had a paragraph saying how many credit counselling agencies received funding; our library has these reports for 1973-1975 and 1978-82. The publication called Expenditures by Municipality shows how much each municipality received for credit counselling and we have the volumes for the three fiscal years ending in March 1975- March 1977. However, it’s not clear that there was only one credit counselling agency in each municipality (though this seems likely).
So one question is whether the other volumes of these two publications are available elsewhere (I assume the answer is ...yes.). The more difficult question is whether there is a list somewhere of which agency got how much money as opposed to which municipality got how much money.
A further question is how much money each agency got from the United Way over this period since the United Way was another major source of funds.
Answer
The Annual Report of the Minister of Community and Social Services appears to be available at the University of Windsor and Wilfrid Laurier University libraries:
AMICUS No. 19637618 2 Location(s) Ontario. Ministry of Community and Social Services. ANNUAL REPORT OF THE MINISTRY OF COMMUNITY AND SOCIAL SERVICES.
OWA 1972/1973-1983/1984 CA2ON SM.... ..A56 ENG (University of Windsor, Leddy Library)
OWTL PAPER: 1982/1983-1983/1984 : MICROFICHE: 1972/1973 -1981/1982 CA2ON SM A56 (Wilfrid Laurier University, Library)
The University of Waterloo and Wilfrid Laurier University seem to have a number of volumes of Expenditures by municipalities in their collection:
AMICUS No. 30018419 1 Location(s) Expenditures by municipality, Ontario Ministry of Community and Social Services. -- 1990
OWTL PAPER: 1975/1976-1977/1978; 1979/1980; 1981/1982; 1983 /1984 : MICROFICHE: 1974/1975; 1978/1979; 1980/1981; 1982/1983 CA2ON SM E85 (Wilfrid Laurier University, Library)
AMICUS No. 30377920 1 Location(s) EXPENDITURES BY MUNICIPALITY, ONTARIO.
OWTU 1969/70-1983/84 CA2ONSF E85 (Waterloo)
Lists of groups/organizations that have received United Way funding and grants and in some case the amount they received are included in some current local United Way publications. The researcher may wish to contact the United Way of Canada (http://www2.unitedway.ca/uwcanada/content.aspx?id=102&langtype=1033) to see if they have a national historical database with funding information. If they don't, the researcher could consider contacting the local United Ways directly to confirm what historical information they could provide.
This may be a bit of a long shot but the Archives of Ontario (http://www.archives.gov.on.ca/english/index.aspx; reference@ontario.ca) may have sources that detail how much money each non-profit credit counselling agency received from the government of Ontario during the period that interests the researcher. One could contact them as well to see what sources they would recommend.
I hope that these suggestions are helpful.
Hello all. Not sure if anyone here can help, but if there is an answer, I'm sure I won't find a more-knowledgeable group to ask. Cheers and thanks.
Here’s the situation: from the mid-1960s until March 31, 1992, the province subsidized the operating expenses of non-profit credit counselling agencies in Ontario. Ideally, I’d like to know how much each agency received from the province in each year over this period. The annual Report of the Minister of Community and Social Services usually had a paragraph saying how many credit counselling agencies received funding; our library has these reports for 1973-1975 and 1978-82. The publication called Expenditures by Municipality shows how much each municipality received for credit counselling and we have the volumes for the three fiscal years ending in March 1975- March 1977. However, it’s not clear that there was only one credit counselling agency in each municipality (though this seems likely).
So one question is whether the other volumes of these two publications are available elsewhere (I assume the answer is ...yes.). The more difficult question is whether there is a list somewhere of which agency got how much money as opposed to which municipality got how much money.
A further question is how much money each agency got from the United Way over this period since the United Way was another major source of funds.
Answer
The Annual Report of the Minister of Community and Social Services appears to be available at the University of Windsor and Wilfrid Laurier University libraries:
AMICUS No. 19637618 2 Location(s) Ontario. Ministry of Community and Social Services. ANNUAL REPORT OF THE MINISTRY OF COMMUNITY AND SOCIAL SERVICES.
OWA 1972/1973-1983/1984 CA2ON SM.... ..A56 ENG (University of Windsor, Leddy Library)
OWTL PAPER: 1982/1983-1983/1984 : MICROFICHE: 1972/1973 -1981/1982 CA2ON SM A56 (Wilfrid Laurier University, Library)
The University of Waterloo and Wilfrid Laurier University seem to have a number of volumes of Expenditures by municipalities in their collection:
AMICUS No. 30018419 1 Location(s) Expenditures by municipality, Ontario Ministry of Community and Social Services. -- 1990
OWTL PAPER: 1975/1976-1977/1978; 1979/1980; 1981/1982; 1983 /1984 : MICROFICHE: 1974/1975; 1978/1979; 1980/1981; 1982/1983 CA2ON SM E85 (Wilfrid Laurier University, Library)
AMICUS No. 30377920 1 Location(s) EXPENDITURES BY MUNICIPALITY, ONTARIO.
OWTU 1969/70-1983/84 CA2ONSF E85 (Waterloo)
Lists of groups/organizations that have received United Way funding and grants and in some case the amount they received are included in some current local United Way publications. The researcher may wish to contact the United Way of Canada (http://www2.unitedway.ca/uwcanada/content.aspx?id=102&langtype=1033) to see if they have a national historical database with funding information. If they don't, the researcher could consider contacting the local United Ways directly to confirm what historical information they could provide.
This may be a bit of a long shot but the Archives of Ontario (http://www.archives.gov.on.ca/english/index.aspx; reference@ontario.ca) may have sources that detail how much money each non-profit credit counselling agency received from the government of Ontario during the period that interests the researcher. One could contact them as well to see what sources they would recommend.
I hope that these suggestions are helpful.
Annual Estimates for Census Families and Individuals (T1 Family File)
Question
I have a researcher asking for Annual Estimates for Census Families and Individuals (T1 Family File). Statistics Canada web site indicates that the file supposed to be released on June 17, 2010. If it has been released, would you please let us know where we can locate it?
Answer
Products based on the Annual Estimates for Census Families and Individuals (T1 Family File) are available through CANSIM (see the CANSIM tables listed under Links to related products at http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4105&lang=en&db=imdb&adm=8&dis=2), through the DLI collection (see http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/saad-dra-eng.htm; these tables are at the Canada and province-level) and as custom products. The division that publishes these products creates them using data from administrative files from the T1 tax form they receive from the Canada Customs and Revenue Agency (CCRA) once a year. They have indicated that a microdata file with these data unfortunately isn't available.
The division expects to release 2008 data for the Small Area and Administrative Data Families spreadsheet that is in the DLI collection in late September (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/saad-dra-eng.htm).
I hope that this information is helpful. If you have any other questions, please do not hesitate to let me know.
I have a researcher asking for Annual Estimates for Census Families and Individuals (T1 Family File). Statistics Canada web site indicates that the file supposed to be released on June 17, 2010. If it has been released, would you please let us know where we can locate it?
Answer
Products based on the Annual Estimates for Census Families and Individuals (T1 Family File) are available through CANSIM (see the CANSIM tables listed under Links to related products at http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4105&lang=en&db=imdb&adm=8&dis=2), through the DLI collection (see http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/saad-dra-eng.htm; these tables are at the Canada and province-level) and as custom products. The division that publishes these products creates them using data from administrative files from the T1 tax form they receive from the Canada Customs and Revenue Agency (CCRA) once a year. They have indicated that a microdata file with these data unfortunately isn't available.
The division expects to release 2008 data for the Small Area and Administrative Data Families spreadsheet that is in the DLI collection in late September (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/saad-dra-eng.htm).
I hope that this information is helpful. If you have any other questions, please do not hesitate to let me know.
National Survey of Nonprofit and Voluntary Organizations
Question
A professor has asked about a raw data file for the National Survey of Nonprofit and Voluntary Organizations (2003).
This survey is not listed as being in the DLI collection. I mentioned that the surveys for which pumfs end up in the DLI collection tend to be household surveys and not surveys of institutions or businesses. I would appreciate a definitive answer to his request though.
Answer
A public use microdata file (PUMF) could not be produced for the National Survey of Nonprofit and Voluntary Organizations (2003) due to confidentiality related requirements. The DLI will therefore not be receiving a microdata file for this survey.
The following publication is based on this survey and may be of interest to the professor:
Cornerstones of Community: Highlights from the National Survey of Nonprofit and Voluntary Organizations (61-533-XWE)
"This publication provides the first national portrait of the many thousands of nonprofit and voluntary organizations found in every Canadian community. The data, from the National Survey of Nonprofit and Voluntary Organizations, reveal a set of organizations that are widely diverse in nature, touching virtually every aspect of Canadians' lives." (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=61-533-X&lang=eng)
A professor has asked about a raw data file for the National Survey of Nonprofit and Voluntary Organizations (2003).
This survey is not listed as being in the DLI collection. I mentioned that the surveys for which pumfs end up in the DLI collection tend to be household surveys and not surveys of institutions or businesses. I would appreciate a definitive answer to his request though.
Answer
A public use microdata file (PUMF) could not be produced for the National Survey of Nonprofit and Voluntary Organizations (2003) due to confidentiality related requirements. The DLI will therefore not be receiving a microdata file for this survey.
The following publication is based on this survey and may be of interest to the professor:
Cornerstones of Community: Highlights from the National Survey of Nonprofit and Voluntary Organizations (61-533-XWE)
"This publication provides the first national portrait of the many thousands of nonprofit and voluntary organizations found in every Canadian community. The data, from the National Survey of Nonprofit and Voluntary Organizations, reveal a set of organizations that are widely diverse in nature, touching virtually every aspect of Canadians' lives." (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=61-533-X&lang=eng)
Wednesday, October 27, 2010
Labour Market Activity Among Seniors
An article entitled Labour market activity among seniors is being released today. This article uses census data to study labour market activity among senior men and women. Trends in seniors’ employment rates and occupational and industrial profiles are outlined. In addition, 2006 data are used to study factors associated with employment and work intensity.
Enclosed is the link to the Spotlight on the Census web page http://www12.statcan.ca/census-recensement/index-eng.cfm
Enclosed is the link to the Spotlight on the Census web page http://www12.statcan.ca/census-recensement/index-eng.cfm
Thursday, October 21, 2010
Data on Aboriginal Graduates and Aboriginal Faculty
Question
I was wondering whether any one has suggestions on possible sources for the following:
1. Number of Aboriginal Graduates by year [2005 - 2010] across universities in Canada. At the minimum, looking for figures for Medical/ Doctoral universities.
2. Number of faculty who identified themselves as Aboriginal by university. Would like to have the most recent data. At the minimum, looking for figures for Medical/ Doctoral universities.
I have looked at the Pan-Canadian Education Indicators Program (PCEIP) tables but these do not contain the desired breakdowns. I suspect that nothing beyond the information recorded in the Aboriginal Peoples Survey (2006) is likely to be available.
Answer
Our education contacts have indicated that, as you suspected, their surveys unfortunately wouldn't answer these questions. They have suggested that we look into what data are available through the Census.
You may wish to have a look at the following 2006 Census topic based tabulations some of which include data on Aboriginal Identity and Highest Certificate, Diploma or Degree (but not annually, nor by institution or type of institution unfortunately).
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Lp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=738&Temporal=2006&THEME=73&VID=0&VNAMEE=&VNAMEF=
The 2006 Census Individuals File PUMF includes an Aboriginal identity variable and an Occupation variable based on the 2006 National Occupational Classification for Statistics [NOC-S 2006] but the occupation breakdown is quite general (ex. Teachers and professors (E1)).
More detailed occupation related Census data by Aboriginal identity may be available as custom tables. If your client wishes to look into what tables could be produced on a custom basis, I would be happy to refer you to an Account Executive who could confirm what tables could be produced and at what cost.
The Aboriginal Peoples Survey 2006 (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/aps-eapa/aps-eapa-2006-eng.htm) appears to have collected education related data including the year in which the most recent certificate, diploma or degree was obtained and year when post-secondary education was last taken but not by institution however.
I was wondering whether any one has suggestions on possible sources for the following:
1. Number of Aboriginal Graduates by year [2005 - 2010] across universities in Canada. At the minimum, looking for figures for Medical/ Doctoral universities.
2. Number of faculty who identified themselves as Aboriginal by university. Would like to have the most recent data. At the minimum, looking for figures for Medical/ Doctoral universities.
I have looked at the Pan-Canadian Education Indicators Program (PCEIP) tables but these do not contain the desired breakdowns. I suspect that nothing beyond the information recorded in the Aboriginal Peoples Survey (2006) is likely to be available.
Answer
Our education contacts have indicated that, as you suspected, their surveys unfortunately wouldn't answer these questions. They have suggested that we look into what data are available through the Census.
You may wish to have a look at the following 2006 Census topic based tabulations some of which include data on Aboriginal Identity and Highest Certificate, Diploma or Degree (but not annually, nor by institution or type of institution unfortunately).
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Lp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=738&Temporal=2006&THEME=73&VID=0&VNAMEE=&VNAMEF=
The 2006 Census Individuals File PUMF includes an Aboriginal identity variable and an Occupation variable based on the 2006 National Occupational Classification for Statistics [NOC-S 2006] but the occupation breakdown is quite general (ex. Teachers and professors (E1)).
More detailed occupation related Census data by Aboriginal identity may be available as custom tables. If your client wishes to look into what tables could be produced on a custom basis, I would be happy to refer you to an Account Executive who could confirm what tables could be produced and at what cost.
The Aboriginal Peoples Survey 2006 (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/aps-eapa/aps-eapa-2006-eng.htm) appears to have collected education related data including the year in which the most recent certificate, diploma or degree was obtained and year when post-secondary education was last taken but not by institution however.
Generate Map (or Stats) on Students' Transit Access Using Postal Codes
Question
A Student Association is trying to determine how many students do not have convenient access to transit, which it defines as being more than a 15-minute walk from a transit station or bus stop. It is in negotiations with the local transit company about a proposed student transit pass. I have a couple of questions:
Would the Student Association be eligible to use DLI resources for this purpose (assuming they will be of help)? I suspect not since it is a separate organization from the university. This issue is of interest to the university’s planning office as well, however, and it has provided the Student Association with a list of the number of students living in each 6-digit postal code.
Could any of you with GIS experience suggest how to best approach this, with or without DLI resources? Unfortunately, our Library does not subscribe to DMTI Spatial’s Platinum Postal Suite (or any DMTI products), nor do we have PCensus. We do have ArcGIS installed on some workstations.
I’m afraid that I have very little experience – aside from some excellent DLI training sessions and the National Summer Institute last year – on using mapping software. I have spent a bit of time thinking about various approaches I might recommend to the Student Association with the limited resources we have available, and could probably spend all day bumbling around trying them out. I actually wouldn’t mind this, in order to get some experience using the tools, but the Student Association needs the info fairly urgently.
The transit company provides PDF route maps on its website and has also made route data available in Google Transit Feed Specification (GTSF) format. The Student Association has generated a PDF map showing its rough boundaries of ‘convenient access.’
Any help will be appreciated.
Answer
Here is how I would basically approach this request.
The first step would be to geocode the student list using their postal codes. Using the PCCF (if use allowed) you would assign each student latitude and longitude coordinates based on the postal code they live at. You would then add these students as x/y points to the map.
The second step would be to obtain a point shapefile of all the bus stops and SkyTrain stations. I had a quick look at the Google Transit Feed Specification and I think this could probably be created from one of the files if you don't have access to the actual shapefile from TransLink.
The third step would be to create buffers around each bus stop and SkyTrain station using some distance that would approximate a 15-minute walk (500-1000 meters).
The fourth step would be to select by location all the students that fall outside those buffers. This would give you the number of students without convenient access to transit.
Additional information
We consulted the DLI Executive and they confirmed that the Student Association and/or the university's planning office would be allowed to use DLI products (such as the PCCF) for this specific project. As students and staff, they are authorised users and this project can be considered academic planning and is therefore allowed according to the DLI licence. The students would of course need to be made aware of the licence and its restrictions (e.g. the DLI products can't be used by the transit company).
I hope that this is helpful. If you have any other questions, please don't hesitate to let us know.
A Student Association is trying to determine how many students do not have convenient access to transit, which it defines as being more than a 15-minute walk from a transit station or bus stop. It is in negotiations with the local transit company about a proposed student transit pass. I have a couple of questions:
Would the Student Association be eligible to use DLI resources for this purpose (assuming they will be of help)? I suspect not since it is a separate organization from the university. This issue is of interest to the university’s planning office as well, however, and it has provided the Student Association with a list of the number of students living in each 6-digit postal code.
Could any of you with GIS experience suggest how to best approach this, with or without DLI resources? Unfortunately, our Library does not subscribe to DMTI Spatial’s Platinum Postal Suite (or any DMTI products), nor do we have PCensus. We do have ArcGIS installed on some workstations.
I’m afraid that I have very little experience – aside from some excellent DLI training sessions and the National Summer Institute last year – on using mapping software. I have spent a bit of time thinking about various approaches I might recommend to the Student Association with the limited resources we have available, and could probably spend all day bumbling around trying them out. I actually wouldn’t mind this, in order to get some experience using the tools, but the Student Association needs the info fairly urgently.
The transit company provides PDF route maps on its website and has also made route data available in Google Transit Feed Specification (GTSF) format. The Student Association has generated a PDF map showing its rough boundaries of ‘convenient access.’
Any help will be appreciated.
Answer
Here is how I would basically approach this request.
The first step would be to geocode the student list using their postal codes. Using the PCCF (if use allowed) you would assign each student latitude and longitude coordinates based on the postal code they live at. You would then add these students as x/y points to the map.
The second step would be to obtain a point shapefile of all the bus stops and SkyTrain stations. I had a quick look at the Google Transit Feed Specification and I think this could probably be created from one of the files if you don't have access to the actual shapefile from TransLink.
The third step would be to create buffers around each bus stop and SkyTrain station using some distance that would approximate a 15-minute walk (500-1000 meters).
The fourth step would be to select by location all the students that fall outside those buffers. This would give you the number of students without convenient access to transit.
Additional information
We consulted the DLI Executive and they confirmed that the Student Association and/or the university's planning office would be allowed to use DLI products (such as the PCCF) for this specific project. As students and staff, they are authorised users and this project can be considered academic planning and is therefore allowed according to the DLI licence. The students would of course need to be made aware of the licence and its restrictions (e.g. the DLI products can't be used by the transit company).
I hope that this is helpful. If you have any other questions, please don't hesitate to let us know.
Friday, October 15, 2010
Immigration Canada Facts and Figures
Question
I have a researcher asking for historical immigration data. Is the historical data available for inclusion in the DLI Collection?
Immigration Canada Facts and Figures publication.
I am looking for historical time series for:
Preferably starting from 1980.
The historical series are not available on the Citizenship and Immigration website or from Stats Can...
Answer
We have a copy of the Citizenship and Immigration Canada 2006 Facts and Figures Digital Library on the DLI mirror site at the University of Alberta (please see: http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/cic-cic-eng.htm). I had a quick look at this product and while some of the tables go back to 1980, others only back into the '90s. The researcher may wish to approach CIC (Research-Recherche@cic.gc.ca) directly to see if they can provide additional historical data if the Digital Library product doesn't contain all of the data he/she needs. They can also provide the 2008 edition of the Facts and Figures Digital Library on request.
Facts and Figures 2008 Digital Library
The Facts and Figures 2008 Digital Library is a bilingual collection of statistical tables describing Canada’s permanent and temporary residents. The tables are available in Excel and are easily accessible through a built-in search engine.
The collection includes annual statistics for both permanent and temporary residents for calendar years 1984 to 2008 along with a series of tables describing additional selected characteristics for the ten-year period from 1999 to 2008. Tables are provided for Canada, the provinces and territories, and selected urban areas. The temporary resident section includes information for foreign workers, foreign students, refugee claimants and other humanitarian cases.
Annual statistics are provided for new permanent residents, total entries of temporary residents and temporary residents present on December 1st as well as for transitions from one temporary resident status to another and from temporary resident to permanent resident status. Please contact Research-Recherche@cic.gc.ca to request copies of the Facts and Figures 2008 Digital Library." (http://www.cic.gc.ca/english/resources/statistics/menu-fact.asp)
StatCan has a Longitudinal Immigration Database (IMDB, http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=5057&lang=en&db=imdb&adm=8&dis=2) that covers 1980 to 2007. This database isn't available through the DLI but custom data extractions from this database are available for a fee. If this would be of interest to your researcher, I can consult the division that oversees the Longitudinal Immigration Database (IMDB) to confirm if the tables your researcher requires could be produced on a custom basis.
The researcher may also wish to look into the files held by the Metropolis project in BC (http://mbc.metropolis.net/). Their data holdings are described at: http://web.uvic.ca/~baer/MBC/
The following Postsecondary Student Information System (PSIS) table only goes back to 1992/1993 but may still be of interest to the researcher: University enrolments, by province of study and immigration status, annual (number), 1992/1993 to 2007/2008 (xls) at http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/psis-siep-eng.htm
I hope that this is helpful.
I have a researcher asking for historical immigration data. Is the historical data available for inclusion in the DLI Collection?
Immigration Canada Facts and Figures publication.
I am looking for historical time series for:
- Canada – Transition of temporary residents to permanent resident status
- Canada – Transition of temporary residents by previous yearly status
- Canada – Total entries of foreign students by province or territory and urban are
- Canada – Foreign students present on December 1st by province or territory and urban area
Preferably starting from 1980.
The historical series are not available on the Citizenship and Immigration website or from Stats Can...
Answer
We have a copy of the Citizenship and Immigration Canada 2006 Facts and Figures Digital Library on the DLI mirror site at the University of Alberta (please see: http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/cic-cic-eng.htm). I had a quick look at this product and while some of the tables go back to 1980, others only back into the '90s. The researcher may wish to approach CIC (Research-Recherche@cic.gc.ca) directly to see if they can provide additional historical data if the Digital Library product doesn't contain all of the data he/she needs. They can also provide the 2008 edition of the Facts and Figures Digital Library on request.
Facts and Figures 2008 Digital Library
The Facts and Figures 2008 Digital Library is a bilingual collection of statistical tables describing Canada’s permanent and temporary residents. The tables are available in Excel and are easily accessible through a built-in search engine.
The collection includes annual statistics for both permanent and temporary residents for calendar years 1984 to 2008 along with a series of tables describing additional selected characteristics for the ten-year period from 1999 to 2008. Tables are provided for Canada, the provinces and territories, and selected urban areas. The temporary resident section includes information for foreign workers, foreign students, refugee claimants and other humanitarian cases.
Annual statistics are provided for new permanent residents, total entries of temporary residents and temporary residents present on December 1st as well as for transitions from one temporary resident status to another and from temporary resident to permanent resident status. Please contact Research-Recherche@cic.gc.ca to request copies of the Facts and Figures 2008 Digital Library." (http://www.cic.gc.ca/english/resources/statistics/menu-fact.asp)
StatCan has a Longitudinal Immigration Database (IMDB, http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=5057&lang=en&db=imdb&adm=8&dis=2) that covers 1980 to 2007. This database isn't available through the DLI but custom data extractions from this database are available for a fee. If this would be of interest to your researcher, I can consult the division that oversees the Longitudinal Immigration Database (IMDB) to confirm if the tables your researcher requires could be produced on a custom basis.
The researcher may also wish to look into the files held by the Metropolis project in BC (http://mbc.metropolis.net/). Their data holdings are described at: http://web.uvic.ca/~baer/MBC/
The following Postsecondary Student Information System (PSIS) table only goes back to 1992/1993 but may still be of interest to the researcher: University enrolments, by province of study and immigration status, annual (number), 1992/1993 to 2007/2008 (xls) at http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/psis-siep-eng.htm
I hope that this is helpful.
Levels of Access to Data
Question
Could someone please remind me of the levels of access to data on the STC website? I know (or think I know) there are essentially three (open and unrestricted, DLI, and STC only) but I forget how to tell, while on campus, which tables will not be accessible from off-campus if not logged in to our proxy server. I think it's the level of geographic detail that is the deciding factor, but I can never remember what that is (nor can I find such an explanation anywhere on the STC website). Could someone please enlighten me?
Answer
If you go to the 2006 topic-based tabulations (ex. http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Lp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=73&VID=0&VNAMEE=&VNAMEF=) and click on Detailed results link, the access level for each table on the page will appear.
I hope that this answers your question. Please don't hesitate to let me know if you need further clarification.
Could someone please remind me of the levels of access to data on the STC website? I know (or think I know) there are essentially three (open and unrestricted, DLI, and STC only) but I forget how to tell, while on campus, which tables will not be accessible from off-campus if not logged in to our proxy server. I think it's the level of geographic detail that is the deciding factor, but I can never remember what that is (nor can I find such an explanation anywhere on the STC website). Could someone please enlighten me?
Answer
If you go to the 2006 topic-based tabulations (ex. http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Lp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=73&VID=0&VNAMEE=&VNAMEF=) and click on Detailed results link, the access level for each table on the page will appear.
- Tables labelled Level=Public are freely accessible to everyone on the StatCan website
- Tables labelled Level=Partner are available through the DSP and the DLI via the StatCan website (IP recognition is used to grant access)
- Tables labelled Level=Restricted are available through the DLI and stored on our FTP site (these include Dissemination Area level tables and Commutting flow tables)
I hope that this answers your question. Please don't hesitate to let me know if you need further clarification.
Information About Second-Generation Canadians
Question
A researcher is trying to find information on the amount of first-generation Canadians and their composition percentage of Canadian population as first generation immigrants. If possible, she would also like to see if we can find a percentage for Alberta and Edmonton (i.e. percentage of people in Alberta who are 1st generation Canadian and percentage of people in Edmonton who are first generation Canadian).
In the 2006 Canadian census, she found there were 24% of Canada's population is 15+ years of age.
Are there any resources or any places that would be able to shed some light on this question?
Any pointers would be greatly appreciated.
Answer
The following 2006 Census topic based tabulation may be of interest to the researcher. The first can provide statistics on generation status for Canada and the provinces and the second one includes statistics for Edmonton.
Generation Status (4), Age Groups (9) and Sex (3) for the Population 15 Years and Over of Canada, Provinces and Territories, 1971, 2001 and 2006 Censuses - 20% Sample Data (97-557-XCB2006010)
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=01&GID=614135&GK=1&GRP=1&O=D&PID=89431&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=725&Temporal=2006&THEME=72&VID=0&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0
Place of Birth of Father (35), Place of Birth of Mother (35) and Generation Status (4) for the Population 15 Years and Over of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2006 Census - 20% Sample Data (97-557-XCB2006009)
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=01&GID=837928&GK=1&GRP=1&O=D&PID=89426&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=725&Temporal=2006&THEME=72&VID=0&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0
I located them through the following steps: www.statcan.gc.ca --> clicked on Census on top right--> clicked on Data products on left --> clicked on Topic-based tabulations --> clicked on Immigration and citizenship --> clicked on Generation status
Additional 2006 Census tables on generation status are available at http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Lp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=725&Temporal=2006&THEME=72&VID=0&VNAMEE=&VNAMEF=
I hope that this is helpful.
A researcher is trying to find information on the amount of first-generation Canadians and their composition percentage of Canadian population as first generation immigrants. If possible, she would also like to see if we can find a percentage for Alberta and Edmonton (i.e. percentage of people in Alberta who are 1st generation Canadian and percentage of people in Edmonton who are first generation Canadian).
In the 2006 Canadian census, she found there were 24% of Canada's population is 15+ years of age.
Are there any resources or any places that would be able to shed some light on this question?
Any pointers would be greatly appreciated.
Answer
The following 2006 Census topic based tabulation may be of interest to the researcher. The first can provide statistics on generation status for Canada and the provinces and the second one includes statistics for Edmonton.
Generation Status (4), Age Groups (9) and Sex (3) for the Population 15 Years and Over of Canada, Provinces and Territories, 1971, 2001 and 2006 Censuses - 20% Sample Data (97-557-XCB2006010)
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=01&GID=614135&GK=1&GRP=1&O=D&PID=89431&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=725&Temporal=2006&THEME=72&VID=0&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0
Place of Birth of Father (35), Place of Birth of Mother (35) and Generation Status (4) for the Population 15 Years and Over of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2006 Census - 20% Sample Data (97-557-XCB2006009)
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=01&GID=837928&GK=1&GRP=1&O=D&PID=89426&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=725&Temporal=2006&THEME=72&VID=0&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0
I located them through the following steps: www.statcan.gc.ca --> clicked on Census on top right--> clicked on Data products on left --> clicked on Topic-based tabulations --> clicked on Immigration and citizenship --> clicked on Generation status
Additional 2006 Census tables on generation status are available at http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Lp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=725&Temporal=2006&THEME=72&VID=0&VNAMEE=&VNAMEF=
I hope that this is helpful.
2001 Census Individuals PUMF Additional Methodology Questions
Question
A researcher has sent me a few more questions concerning the 2001 Census Individuals PUMF methodology. I have appended the entire text of the message below. The document referred to is the 2001 Census Public Use Microdata File: Individuals File: User Documentation, 2nd revision. The pages referred to are page 173-176 of 292 (page 168-171 in the document). I am quite confident that your census staff can answer these questions much better that I can. Thanks in advance for any information or advice that might be sent back.
"The canvasser area stratum is mentioned in the first phase of sampling in Chapter III Sampling Method and Data Quality (page 173 of the pdf file attached).
In part (b) Second Phase of Sampling, the strata used for selection of the individuals to be part of the public use microdata file (pumf) on individuals Canada Census 2001 are defined. One limitation of this stratification is mentioned that uses canvasser area stratum. However, canvasser area stratum is not defined as one of the strata available for stratification in phase two. This contradicts in my opinion the procedure used for defining each stratum in phase two of sampling (on page 176 of the pdf).
Was the canvasser area stratum used for stratification in phase two of the selection of pumf on individuals in Canada Census 2001? Is canvasser area stratum identifiable by any variable in the pumf on individuals in Canada Census 2001? Where does canvasser area stratum rank in importance compared to the rest of the variables used for stratification in phase two of sampling?"
Answer
The methodologists our census contacts consulted provided the following information in response to the researcher's questions:
"The file was sorted first by canvasser stratum and then by geography, and the other variables. By doing so, we were ensuring that these people (people living in a canvasser area) were well represented in the sample.
We limit the number of strata in these areas because the number of people within a given geography was already small (stratifying more would not do anything in these circumstances). It was not possible to identify them in the file for confidentiality reasons (canvasser areas have low population counts). However, we felt that, since those people are different characteristics than the other people, it was important to ensure their representation. In that sense, this stratum is very important."
I hope that this information is helpful. Please do not hesitate to let us know if you have any other questions.
A researcher has sent me a few more questions concerning the 2001 Census Individuals PUMF methodology. I have appended the entire text of the message below. The document referred to is the 2001 Census Public Use Microdata File: Individuals File: User Documentation, 2nd revision. The pages referred to are page 173-176 of 292 (page 168-171 in the document). I am quite confident that your census staff can answer these questions much better that I can. Thanks in advance for any information or advice that might be sent back.
"The canvasser area stratum is mentioned in the first phase of sampling in Chapter III Sampling Method and Data Quality (page 173 of the pdf file attached).
In part (b) Second Phase of Sampling, the strata used for selection of the individuals to be part of the public use microdata file (pumf) on individuals Canada Census 2001 are defined. One limitation of this stratification is mentioned that uses canvasser area stratum. However, canvasser area stratum is not defined as one of the strata available for stratification in phase two. This contradicts in my opinion the procedure used for defining each stratum in phase two of sampling (on page 176 of the pdf).
Was the canvasser area stratum used for stratification in phase two of the selection of pumf on individuals in Canada Census 2001? Is canvasser area stratum identifiable by any variable in the pumf on individuals in Canada Census 2001? Where does canvasser area stratum rank in importance compared to the rest of the variables used for stratification in phase two of sampling?"
Answer
The methodologists our census contacts consulted provided the following information in response to the researcher's questions:
"The file was sorted first by canvasser stratum and then by geography, and the other variables. By doing so, we were ensuring that these people (people living in a canvasser area) were well represented in the sample.
We limit the number of strata in these areas because the number of people within a given geography was already small (stratifying more would not do anything in these circumstances). It was not possible to identify them in the file for confidentiality reasons (canvasser areas have low population counts). However, we felt that, since those people are different characteristics than the other people, it was important to ensure their representation. In that sense, this stratum is very important."
I hope that this information is helpful. Please do not hesitate to let us know if you have any other questions.
Thursday, October 14, 2010
Bed-Sharing Info (Co-Sleeping)
Question
A researcher would like to know the percentage of mothers in Canada who bed-share with their infants (co-sleep).
Answer
The following (non-StatCan) literature review on the Public Health Agency of Canada website may be of interest to the researcher. It includes references to a few studies on this topic:
The Practice of Bed Sharing: A Systematic Literature and Policy Review
http://www.phac-aspc.gc.ca/dca-dea/prenatal/pbs-ppl-eng.php
The closest match I could find in the DLI collection is the variable BBEC6PP1 : Doesn't want to sleep alone? in the National Longitudinal Survey of Children and Youth, 1996-1997 [Canada]: Cycle 2, Primary File.
I hope that this information is helpful.
A researcher would like to know the percentage of mothers in Canada who bed-share with their infants (co-sleep).
Answer
The following (non-StatCan) literature review on the Public Health Agency of Canada website may be of interest to the researcher. It includes references to a few studies on this topic:
The Practice of Bed Sharing: A Systematic Literature and Policy Review
http://www.phac-aspc.gc.ca/dca-dea/prenatal/pbs-ppl-eng.php
The closest match I could find in the DLI collection is the variable BBEC6PP1 : Doesn't want to sleep alone? in the National Longitudinal Survey of Children and Youth, 1996-1997 [Canada]: Cycle 2, Primary File.
I hope that this information is helpful.
Cost of Inmates
Question
I can't seem to put my finger on numbers indicating Correctional Services Canada costs for inmates (minimum, medium, and maximum security as well as community corrections).
Any suggestions?
Answer
You may be interested in the content under "The cost of keeping an inmate incarcerated has increased" in the document Corrections and Conditional Release Statistical Overview that is available on the Public Safety Canada website. It includes annual average costs per offender (current $) by category.
http://www.securitepublique.gc.ca/res/cor/rep/2008-04-ccrso-eng.aspx#b3
StatCan has CANSIM Table 251-0007 Adult correctional services, operating expenditures for provincial, territorial and federal programs, annual (http://cansim2.statcan.gc.ca/cgi-win/cnsmcgi.pgm) which includes average daily inmate cost (current dollars) and average daily inmate cost (2002/2003 constant dollars) under Operating expenditures.
We are also consulting with the Subject-Matter Division to see if there are other sources and will get back to you.
Additional information
The best suggestion is CANSIM Table 251-0007 for StatCan data. The CCJS can not differentiate expenditures based on minimum, medium, and maximum security.
And keep in mind that the information in Section B: 'Corrections Administration' in the CCRSO (the report on the Public Safety web-site) is sourced to CSC, the Office of the Correctional Investigator and the National Parole Board, not CCJS.
I can't seem to put my finger on numbers indicating Correctional Services Canada costs for inmates (minimum, medium, and maximum security as well as community corrections).
Any suggestions?
Answer
You may be interested in the content under "The cost of keeping an inmate incarcerated has increased" in the document Corrections and Conditional Release Statistical Overview that is available on the Public Safety Canada website. It includes annual average costs per offender (current $) by category.
http://www.securitepublique.gc.ca/res/cor/rep/2008-04-ccrso-eng.aspx#b3
StatCan has CANSIM Table 251-0007 Adult correctional services, operating expenditures for provincial, territorial and federal programs, annual (http://cansim2.statcan.gc.ca/cgi-win/cnsmcgi.pgm) which includes average daily inmate cost (current dollars) and average daily inmate cost (2002/2003 constant dollars) under Operating expenditures.
We are also consulting with the Subject-Matter Division to see if there are other sources and will get back to you.
Additional information
The best suggestion is CANSIM Table 251-0007 for StatCan data. The CCJS can not differentiate expenditures based on minimum, medium, and maximum security.
And keep in mind that the information in Section B: 'Corrections Administration' in the CCRSO (the report on the Public Safety web-site) is sourced to CSC, the Office of the Correctional Investigator and the National Parole Board, not CCJS.
Population Projections for Canada, Provinces and Territories
The following product is now available on the DLI FTP and website.
Population Projections for Canada, Provinces and Territories, with Detailed Electronic Tables (91-520-SCB)
"This CD-ROM contains the English and French versions of the report on Population Projections for Canada, Provinces and Territories (in PDF format) as well as tables (in the form of spreadsheets) presenting data by sex, single year of age, province/territory and projection year for projection scenarios. Based on the July 2009 population estimate, these projections present a detailed picture of the Canadian population for the provinces/territories until 2036, and for all of Canada until 2061, subject to certain hypotheses related to components of population growth." (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=91-520-S)
WEB: http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/pp-pd-eng.htm
FTP: /DissFTP/dli/DLI Collection-except Census-Geography and Trade/Population Projections for Canada Provinces and Territories - pp
Population Projections for Canada, Provinces and Territories, with Detailed Electronic Tables (91-520-SCB)
"This CD-ROM contains the English and French versions of the report on Population Projections for Canada, Provinces and Territories (in PDF format) as well as tables (in the form of spreadsheets) presenting data by sex, single year of age, province/territory and projection year for projection scenarios. Based on the July 2009 population estimate, these projections present a detailed picture of the Canadian population for the provinces/territories until 2036, and for all of Canada until 2061, subject to certain hypotheses related to components of population growth." (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=91-520-S)
WEB: http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/pp-pd-eng.htm
FTP: /DissFTP/dli/DLI Collection-except Census-Geography and Trade/Population Projections for Canada Provinces and Territories - pp
Thursday, September 23, 2010
Justice Stats and Religious Affiliation
Question
We have a student who wonders if there is anything (survey) identifying religious affiliation, i.e., Muslim, of prisoners in Canada?
Answer
Our justice contacts have confirmed that they do not collect data on religious affiliation of prisoners in Canada.
The student may be interested in the data Correctional Services Canada seems to collect. They appear to have offender counts by religion from a system called the Offender Management System (see information and basic counts at: http://www.csc-scc.gc.ca/text/prgrm/chap/rsa/doc-eng.shtml).
We have a student who wonders if there is anything (survey) identifying religious affiliation, i.e., Muslim, of prisoners in Canada?
Answer
Our justice contacts have confirmed that they do not collect data on religious affiliation of prisoners in Canada.
The student may be interested in the data Correctional Services Canada seems to collect. They appear to have offender counts by religion from a system called the Offender Management System (see information and basic counts at: http://www.csc-scc.gc.ca/text/prgrm/chap/rsa/doc-eng.shtml).
Census PUMF Methodology Question
Question
I have received the following question regarding a few older Census Individuals PUMF methodology:
"The Canadian Census documentation mentions non-sampling errors. One of the sources of non-sampling errors being imputation for non-response. However, I could not find any info regarding imputation methods used for any of the variables in the documentation for Canada census in 1981, 1991, 2001.
Can one identify the observations for which data were imputed, and the imputation method used in Canadian census 1981, 1991 or 2001? How?"
I checked the 2001 Census Individuals PUMF users guide (second revision), page 197 (202 of 292), where it does briefly discuss Imputation Methodology. (A similar note shows up in the 1991 documentation, Wordperfect format). The example given is a geography variable, but there are no details of other possible affected variables, and nothing about identifying the affected observations. Any advice or explanation which I can pass on to the user will be greatly appreciated.
Answer
I consulted our census contacts and they indicated that it "is impossible to identify specific Census data that were imputed. The main reason is confidentiality and the fact that imputed data are incorporated in larger groups of data". They also indicated that "We have no way of knowing the number of variable affected by imputation. All of them could be affected or only a limited number. The impacts are generally greater when we look at income and less important when it comes to minor aspect like age." "After the imputation has been done initially on the census, no further imputation is done on the PUMF."
They directed us to the following general overview which may be of interest to your client: http://www.statcan.gc.ca/edu/power-pouvoir/ch3/imputation/5214784-eng.htm
While looking into your question, I also came across references to imputation in the 2001 Census technical reports (ex. http://www12.statcan.gc.ca/english/census01/Products/Reference/tech_rep/age_sex/processing.cfm#edit) and in the 1991 census dictionary (I searched the online version on the site at the University of Toronto).
I hope that this information is helpful.
I have received the following question regarding a few older Census Individuals PUMF methodology:
"The Canadian Census documentation mentions non-sampling errors. One of the sources of non-sampling errors being imputation for non-response. However, I could not find any info regarding imputation methods used for any of the variables in the documentation for Canada census in 1981, 1991, 2001.
Can one identify the observations for which data were imputed, and the imputation method used in Canadian census 1981, 1991 or 2001? How?"
I checked the 2001 Census Individuals PUMF users guide (second revision), page 197 (202 of 292), where it does briefly discuss Imputation Methodology. (A similar note shows up in the 1991 documentation, Wordperfect format). The example given is a geography variable, but there are no details of other possible affected variables, and nothing about identifying the affected observations. Any advice or explanation which I can pass on to the user will be greatly appreciated.
Answer
I consulted our census contacts and they indicated that it "is impossible to identify specific Census data that were imputed. The main reason is confidentiality and the fact that imputed data are incorporated in larger groups of data". They also indicated that "We have no way of knowing the number of variable affected by imputation. All of them could be affected or only a limited number. The impacts are generally greater when we look at income and less important when it comes to minor aspect like age." "After the imputation has been done initially on the census, no further imputation is done on the PUMF."
They directed us to the following general overview which may be of interest to your client: http://www.statcan.gc.ca/edu/power-pouvoir/ch3/imputation/5214784-eng.htm
While looking into your question, I also came across references to imputation in the 2001 Census technical reports (ex. http://www12.statcan.gc.ca/english/census01/Products/Reference/tech_rep/age_sex/processing.cfm#edit) and in the 1991 census dictionary (I searched the online version on the site at the University of Toronto).
I hope that this information is helpful.
Wednesday, September 22, 2010
Survey Data Related to Risks of Early Motherhood
Question
A researcher here at York is interested in information on experiences of motherhood among adolescent girls in child welfare and or youth justice. Specifically, she is interested in recent survey data dealing with risks and health outcomes of early motherhood for this vulnerable population. We spent some time searching this morning, looking for these kinds of data, and managed to find some elements of it in the CCHS and NPHS, but nothing quite like what she really wants. Since it's entirely possible we missed something, is there someone in STC with whom she could discuss this in greater detail?
Answer
To the best of my knowledge, StatCan hasn't published or collected data on this specific topic. We have a number of publications on teenage pregnancy and its outcomes but these aren't specifically on adolescent girls in child welfare and youth services. The following articles and reference guide are the closest matches as I know of and may be of interest to the researcher. If she has specific questions about these publications and the data on which they are based, I would be pleased to consult the authors and divisions that published these products to obtain additional information for her or refer her to them directly if this would be more helpful.
Teenage pregnancy: Guide to the latest information
http://www.statcan.gc.ca/search-recherche/bb/info/3000020-eng.htm
The reference guide includes links to these publications:
Life after teenage motherhood
Perspectives on Labour and Income, May 2008, Catalogue no. 75-001-XWE, Vol. 9, No. 5.
Second or subsequent births to teenagers
Health Reports, February 2007, Catalogue no. 82-003-XWE, Vol. 18, No. 1.
Teenage pregnancy
Health Reports, Winter 2000, Catalogue no. 82-003-XIE, Vol. 12, No. 1.
I will have a closer look at the documentation for a few more surveys to see if I can locate sources that would cover this specific topic and will follow up with more information shortly.
A researcher here at York is interested in information on experiences of motherhood among adolescent girls in child welfare and or youth justice. Specifically, she is interested in recent survey data dealing with risks and health outcomes of early motherhood for this vulnerable population. We spent some time searching this morning, looking for these kinds of data, and managed to find some elements of it in the CCHS and NPHS, but nothing quite like what she really wants. Since it's entirely possible we missed something, is there someone in STC with whom she could discuss this in greater detail?
Answer
To the best of my knowledge, StatCan hasn't published or collected data on this specific topic. We have a number of publications on teenage pregnancy and its outcomes but these aren't specifically on adolescent girls in child welfare and youth services. The following articles and reference guide are the closest matches as I know of and may be of interest to the researcher. If she has specific questions about these publications and the data on which they are based, I would be pleased to consult the authors and divisions that published these products to obtain additional information for her or refer her to them directly if this would be more helpful.
Teenage pregnancy: Guide to the latest information
http://www.statcan.gc.ca/search-recherche/bb/info/3000020-eng.htm
The reference guide includes links to these publications:
Life after teenage motherhood
Perspectives on Labour and Income, May 2008, Catalogue no. 75-001-XWE, Vol. 9, No. 5.
Second or subsequent births to teenagers
Health Reports, February 2007, Catalogue no. 82-003-XWE, Vol. 18, No. 1.
Teenage pregnancy
Health Reports, Winter 2000, Catalogue no. 82-003-XIE, Vol. 12, No. 1.
I will have a closer look at the documentation for a few more surveys to see if I can locate sources that would cover this specific topic and will follow up with more information shortly.
Educational Attainment
Question
I have a request from a grad student who wants educational attainment data for Saskatoon. I've shown him how to use the community profiles to extract data for the entire city, but he'd like to find data at the CT or neighbourhood level. Is education data available at that geographic level without his resorting to a custom tabulation?
Answer
The following topic-based tabulations on Highest certificate, level or degree may meet the student's needs. They are available at the Census Tract (CT) level online and at the Dissemination Area (DA) level on the DLI FTP site.
• Highest Certificate, Diploma or Degree (14), Location of Study (5), Major Field of Study - Classification of Instructional Programs, 2000 (14), Age Groups (10A) and Sex (3) for the Population 15 Years and Over of Census Metropolitan Areas, Tracted Census Agglomerations and Census Tracts, 2006 Census - 20% Sample Data 97-560-XCB2006016
(http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=001&GID=759344&GK=10&GRP=1&O=D&PID=93620&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=755&Temporal=2006&THEME=75&VID=0&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0)
• Highest Certificate, Diploma or Degree (7), Location of Study (5), Major Field of Study - Classification of Instructional Programs, 2000 (14) and Sex (3) for the Population 15 Years and Over of Canada, Provinces, Territories, Census Divisions, Census Subdivisions and Dissemination Areas, 2006 Census - 20% Sample Data - 97-560-XCB2006015
(http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=97-560-X2006015&lang=eng - available on the DLI FTP)
• Attendance at School (3), Highest Certificate, Diploma or Degree (13), Age Groups (10A) and Sex (3) for the Population 15 Years and Over of Census Metropolitan Areas, Tracted Census Agglomerations and Census Tracts, 2006 Census - 20% Sample Data 97-560-XCB2006037
(http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=001&GID=759344&GK=10&GRP=1&O=D&PID=97687&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=755&Temporal=2006&THEME=75&VID=0&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0)
Other education-related topic based tabulations are available at:
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/St-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=75&VID=0&VNAMEE=&VNAMEF= (any DA level files described in this section are available on the DLI FTP site).
The education data in the 2006 Census CT and DA level cumulative profiles may also be of interest to the student:
• Profile for Census Metropolitan Areas, Tracted Census Agglomerations and Census Tracts, 2006 Census 94-581-XCB2006005
(http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/prof/rel/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=001&GID=759344&GK=10&GRP=1&O=D&PID=94537&PRID=0&PTYPE=89103&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=81&VID=0&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0)
• Profile for Canada, Provinces, Territories, Census Divisions, Census Subdivisions and Dissemination Areas, 2006 Census 94-581-XCB2006002 (available on the DLI FTP - http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=94-581-X2006002&lang=eng)
The student may also wish to refer to the Education Reference Guide, 2006 Census
(http://www12.statcan.gc.ca/census-recensement/2006/ref/rp-guides/education-eng.cfm) which discusses changes to education-related concepts in the 2006 Census. These underwent important changes in 2006.
Education concepts are also defined in the 2006 Census dictionary: http://www12.statcan.gc.ca/census-recensement/2006/ref/dict/index-eng.cfm
I have a request from a grad student who wants educational attainment data for Saskatoon. I've shown him how to use the community profiles to extract data for the entire city, but he'd like to find data at the CT or neighbourhood level. Is education data available at that geographic level without his resorting to a custom tabulation?
Answer
The following topic-based tabulations on Highest certificate, level or degree may meet the student's needs. They are available at the Census Tract (CT) level online and at the Dissemination Area (DA) level on the DLI FTP site.
• Highest Certificate, Diploma or Degree (14), Location of Study (5), Major Field of Study - Classification of Instructional Programs, 2000 (14), Age Groups (10A) and Sex (3) for the Population 15 Years and Over of Census Metropolitan Areas, Tracted Census Agglomerations and Census Tracts, 2006 Census - 20% Sample Data 97-560-XCB2006016
(http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=001&GID=759344&GK=10&GRP=1&O=D&PID=93620&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=755&Temporal=2006&THEME=75&VID=0&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0)
• Highest Certificate, Diploma or Degree (7), Location of Study (5), Major Field of Study - Classification of Instructional Programs, 2000 (14) and Sex (3) for the Population 15 Years and Over of Canada, Provinces, Territories, Census Divisions, Census Subdivisions and Dissemination Areas, 2006 Census - 20% Sample Data - 97-560-XCB2006015
(http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=97-560-X2006015&lang=eng - available on the DLI FTP)
• Attendance at School (3), Highest Certificate, Diploma or Degree (13), Age Groups (10A) and Sex (3) for the Population 15 Years and Over of Census Metropolitan Areas, Tracted Census Agglomerations and Census Tracts, 2006 Census - 20% Sample Data 97-560-XCB2006037
(http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=001&GID=759344&GK=10&GRP=1&O=D&PID=97687&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=755&Temporal=2006&THEME=75&VID=0&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0)
Other education-related topic based tabulations are available at:
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/St-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=75&VID=0&VNAMEE=&VNAMEF= (any DA level files described in this section are available on the DLI FTP site).
The education data in the 2006 Census CT and DA level cumulative profiles may also be of interest to the student:
• Profile for Census Metropolitan Areas, Tracted Census Agglomerations and Census Tracts, 2006 Census 94-581-XCB2006005
(http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/prof/rel/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=001&GID=759344&GK=10&GRP=1&O=D&PID=94537&PRID=0&PTYPE=89103&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=81&VID=0&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0)
• Profile for Canada, Provinces, Territories, Census Divisions, Census Subdivisions and Dissemination Areas, 2006 Census 94-581-XCB2006002 (available on the DLI FTP - http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=94-581-X2006002&lang=eng)
The student may also wish to refer to the Education Reference Guide, 2006 Census
(http://www12.statcan.gc.ca/census-recensement/2006/ref/rp-guides/education-eng.cfm) which discusses changes to education-related concepts in the 2006 Census. These underwent important changes in 2006.
Education concepts are also defined in the 2006 Census dictionary: http://www12.statcan.gc.ca/census-recensement/2006/ref/dict/index-eng.cfm
Friday, September 17, 2010
Release of the Health Profile, June 2010 (Internet Application)
Statistics Canada is pleased to announce the release of the Health Profile, June 2010 Internet application.
Health Statistics Division and the Census Internet Development team have updated the online product Health Profile, June 2010 (which was initially released in June of 2009) with the latest health data available, including the addition of the following indicators:
• Chronic obstructive pulmonary disease;
• Injuries within the past 12 months causing limitation of normal activities;
• Injuries in the past 12 months, sought medical attention;
• Hospitalized stroke event rate;
• Hospitalized acute myocardial infarction event rate;
• Injury hospitalization;
• Bike helmet use;
• Functional health;
• Life satisfaction.
As well, changes and enhancements have been made to the presentation of the updated Internet application, which includes the removal of the left-hand side bar from the data presentation page. The functionality that was stored within the left-hand side bar has been moved into 'tabs', which are located at the top of the data table, thus maximizing the presentation view.
Other changes/enhancements include:
• Re-ordering the results that are presented following the selection of a Province/Territory or Peer Group from the product main page. The results are now presented at the top of the page instead of at the bottom;
• A new 'Previous issues' link has been added within the left-hand side bar on the main page to provide the comprehensive download file for previous vintage versions of the Health Profile data (i.e., June 2009).
This Internet application features updated health region level data from a number of sources. The application is designed to give quick access to the latest health-related data available for a selected health region, provides the corresponding provincial data by default, and users can easily select any region of choice for comparison.
There are different ways to access the Health Profile, June 2010 (Internet Application) from the Statistics Canada home page. Users can either click on the Health in Canada module or click on the 'Census' button in the right-hand navigation bar and enter through the 'Features' or 'Spotlight' section.
Health Statistics Division and the Census Internet Development team have updated the online product Health Profile, June 2010 (which was initially released in June of 2009) with the latest health data available, including the addition of the following indicators:
• Chronic obstructive pulmonary disease;
• Injuries within the past 12 months causing limitation of normal activities;
• Injuries in the past 12 months, sought medical attention;
• Hospitalized stroke event rate;
• Hospitalized acute myocardial infarction event rate;
• Injury hospitalization;
• Bike helmet use;
• Functional health;
• Life satisfaction.
As well, changes and enhancements have been made to the presentation of the updated Internet application, which includes the removal of the left-hand side bar from the data presentation page. The functionality that was stored within the left-hand side bar has been moved into 'tabs', which are located at the top of the data table, thus maximizing the presentation view.
Other changes/enhancements include:
• Re-ordering the results that are presented following the selection of a Province/Territory or Peer Group from the product main page. The results are now presented at the top of the page instead of at the bottom;
• A new 'Previous issues' link has been added within the left-hand side bar on the main page to provide the comprehensive download file for previous vintage versions of the Health Profile data (i.e., June 2009).
This Internet application features updated health region level data from a number of sources. The application is designed to give quick access to the latest health-related data available for a selected health region, provides the corresponding provincial data by default, and users can easily select any region of choice for comparison.
There are different ways to access the Health Profile, June 2010 (Internet Application) from the Statistics Canada home page. Users can either click on the Health in Canada module or click on the 'Census' button in the right-hand navigation bar and enter through the 'Features' or 'Spotlight' section.
New Search Feautures
The Statistics Canada search team is continuing to make enhancements to the search function on the www.statcan.gc.ca internet site. Here are three examples of changes that will be made soon:
• The title link to search results will go directly to the html page. To access the catalogue page, select the Description link. To extend your search to a full text search of PDF documents, select the More results
• You can search within free Census cross-tabulations to find terms that are not found in the catalogue record.
• You can narrow your search by geographic level.
Please see http://www.statcan.gc.ca/search-recherche/nf-eng.htm for more detail.
Please let us know if you or your clients have any concerns when using these new features.
• The title link to search results will go directly to the html page. To access the catalogue page, select the Description link. To extend your search to a full text search of PDF documents, select the More results
• You can search within free Census cross-tabulations to find terms that are not found in the catalogue record.
• You can narrow your search by geographic level.
Please see http://www.statcan.gc.ca/search-recherche/nf-eng.htm for more detail.
Please let us know if you or your clients have any concerns when using these new features.
Dissemination Areas (DAs) Representative Points
Question
There is a researcher here who is looking for the Dissemination Area Representative Point File (2006). Is this a file that is available to us through DLI? I have not been successful in locating it on the Statistics Canada website. (I think the file might be in GIS shapefile format, but perhaps it's an ASCII file.)
Answer
Our geography consultants have indicated that the dissemination area representative points are available in GeoSuite 2006 (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=92-150-X -- available through the DLI). Here are the detailed instructions they provided:
"The DA Rep Points can be extracted using GeoSuite 2006.
Select Name Search
Select Level: CAN (Canada)
Click Next
Select DA (Dissemination Area)
Choose DAuid, DAlat, DAlong
Click Next - table will appear
Tools > Export"
I hope that this information is helpful. Please don't hesitate to contact me if you have any questions or if this isn't what the researcher needs.
There is a researcher here who is looking for the Dissemination Area Representative Point File (2006). Is this a file that is available to us through DLI? I have not been successful in locating it on the Statistics Canada website. (I think the file might be in GIS shapefile format, but perhaps it's an ASCII file.)
Answer
Our geography consultants have indicated that the dissemination area representative points are available in GeoSuite 2006 (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=92-150-X -- available through the DLI). Here are the detailed instructions they provided:
"The DA Rep Points can be extracted using GeoSuite 2006.
Select Name Search
Select Level: CAN (Canada)
Click Next
Select DA (Dissemination Area)
Choose DAuid, DAlat, DAlong
Click Next - table will appear
Tools > Export"
I hope that this information is helpful. Please don't hesitate to contact me if you have any questions or if this isn't what the researcher needs.
Release of Two Articles in CST
An article entitled Migration from Central to Surrounding Municipalities in Toronto, Montréal and Vancouver which looks at movements of persons aged 25 to 44 years between central municipalities and suburban municipalities in the country’s three largest metropolitan areas - Toronto, Montréal and Vancouver is released today in the Canadian Social Trends. The article presents socio-economic characteristics of persons most and least likely to leave the central municipality for a neighbouring municipality.
An article entitled Foreign Nationals Working Temporarily in Canada is also released today. This study examines the growing number of non-permanent residents who work temporarily in Canada. They are compared with permanent residents in terms of demographic characteristics, location, occupations and earnings. Census data show that while the numbers destined to skilled work has been increasing, most non-permanent residents are found in relatively unskilled occupations. Reflecting the occupations in which they work, foreign nationals working temporarily in Canada tend to be paid less than are comparable Canadian born and established immigrant workers.
Enclosed is the link to the Spotlight on the Census web page http://www12.statcan.ca/census-recensement/index-eng.cfm
An article entitled Foreign Nationals Working Temporarily in Canada is also released today. This study examines the growing number of non-permanent residents who work temporarily in Canada. They are compared with permanent residents in terms of demographic characteristics, location, occupations and earnings. Census data show that while the numbers destined to skilled work has been increasing, most non-permanent residents are found in relatively unskilled occupations. Reflecting the occupations in which they work, foreign nationals working temporarily in Canada tend to be paid less than are comparable Canadian born and established immigrant workers.
Enclosed is the link to the Spotlight on the Census web page http://www12.statcan.ca/census-recensement/index-eng.cfm
Use of Input-Output Multiplier in Research Analysis
Question
I have a researcher who has used provincial input-output multipliers as part of the analysis in a paper. The researcher wants to know if it's possible to have the multipliers in the paper as part of the equation to show that how the value is derived in the analysis. My understanding of the DLI license is that this would constitute raw data and couldn't directly be included in the paper. I've looked through the licensing cases on the web site and I don't find anything that exactly fits this case. The researcher would like a definite answer for this.
Answer
If like with most academic publications, the researcher needs to include a few figures from a provincial input-output multiplier Excel table to support his/her analysis and cites these, this is fine. The researcher couldn't include an entire table however as this would be redistributing the product.
I hope that this is helpful. Please don't hesitate to contact us if you have any other questions.
I have a researcher who has used provincial input-output multipliers as part of the analysis in a paper. The researcher wants to know if it's possible to have the multipliers in the paper as part of the equation to show that how the value is derived in the analysis. My understanding of the DLI license is that this would constitute raw data and couldn't directly be included in the paper. I've looked through the licensing cases on the web site and I don't find anything that exactly fits this case. The researcher would like a definite answer for this.
Answer
If like with most academic publications, the researcher needs to include a few figures from a provincial input-output multiplier Excel table to support his/her analysis and cites these, this is fine. The researcher couldn't include an entire table however as this would be redistributing the product.
I hope that this is helpful. Please don't hesitate to contact us if you have any other questions.
Shopping Mall Data
Question
A researcher here at the U of S is looking for the number of shopping centres/malls in each province, preferably at the level of CSD or CMA. I know the Annual Retail Store Survey lets users extract the number of stores by individual category at the provincial level, but I haven't found a product focused on malls. I'm sure that retail/trade associations keep such data, but I thought I'd see if StatsCan does too.
Answer
I consulted the division that manages our retail store surveys and they unfortunately do not have data on the number of shopping malls by province.
I also consulted the division that manages our Business Register and they provided the following information: "Unfortunately, we are unable to provide the number of shopping centres or malls as we only maintain counts of business locations, establishments or enterprises, and we do not keep track of whether a particular retail store or service belongs to a mall. The Business Register is able to provide counts of business locations for NAICS 531120 at either the CSD or CMA level. (...) However, I would like to point out that this NAICS is not exclusive to malls or shopping centres and also includes other commercial and industrial buildings (ex. office buildings, meeting halls, reception hall, etc). Therefore, the counts would also reflect these types of businesses."
For your reference, a description of NAICS 531120, Lessors of Non-Residential Buildings (except Mini-Warehouses), is available at: http://stds.statcan.gc.ca/naics-scian/2007/cs-rc-eng.asp?criteria=531120&keyword=shopping&table=2&code_level=
Canadian Business Patterns (available through the DLI - http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/cbp-sic-eng.htm) contains Business Register data and could provide counts of business locations for NAICS code 531120 (http://www.statcan.gc.ca/concepts/industry-industrie-eng.htm) at the CMA level if your researcher decides that this would be of interest. Similar Business Register data at the CSD level would be available as a custom extraction (approximate cost of $760). I would be happy to refer you to an Account-Executive who can provide an official quote if your researcher wishes to look into this type of product.
I hope that this information is helpful. Should you have any other questions, please do not hesitate to let me know.
A researcher here at the U of S is looking for the number of shopping centres/malls in each province, preferably at the level of CSD or CMA. I know the Annual Retail Store Survey lets users extract the number of stores by individual category at the provincial level, but I haven't found a product focused on malls. I'm sure that retail/trade associations keep such data, but I thought I'd see if StatsCan does too.
Answer
I consulted the division that manages our retail store surveys and they unfortunately do not have data on the number of shopping malls by province.
I also consulted the division that manages our Business Register and they provided the following information: "Unfortunately, we are unable to provide the number of shopping centres or malls as we only maintain counts of business locations, establishments or enterprises, and we do not keep track of whether a particular retail store or service belongs to a mall. The Business Register is able to provide counts of business locations for NAICS 531120 at either the CSD or CMA level. (...) However, I would like to point out that this NAICS is not exclusive to malls or shopping centres and also includes other commercial and industrial buildings (ex. office buildings, meeting halls, reception hall, etc). Therefore, the counts would also reflect these types of businesses."
For your reference, a description of NAICS 531120, Lessors of Non-Residential Buildings (except Mini-Warehouses), is available at: http://stds.statcan.gc.ca/naics-scian/2007/cs-rc-eng.asp?criteria=531120&keyword=shopping&table=2&code_level=
Canadian Business Patterns (available through the DLI - http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/cbp-sic-eng.htm) contains Business Register data and could provide counts of business locations for NAICS code 531120 (http://www.statcan.gc.ca/concepts/industry-industrie-eng.htm) at the CMA level if your researcher decides that this would be of interest. Similar Business Register data at the CSD level would be available as a custom extraction (approximate cost of $760). I would be happy to refer you to an Account-Executive who can provide an official quote if your researcher wishes to look into this type of product.
I hope that this information is helpful. Should you have any other questions, please do not hesitate to let me know.
Provincial Government Revenue and Expenditure
Question
A researcher here is looking at revenues and expenditures of individual provincial governments back to 1961. This used to be nicely covered by the old CANSIM I, with one matrix for each province (NFDL=6769, PEI=6770 .... BC=6778, and Yukon/NWT=6779) and covering the years 1961-1995. Similar data is available in CANSIM II, however, it is now split into three separate tables (384-0023, 384-0004, and 385-0001) , which do not seem to be compatible. The first and third table are terminated, but I don't think the second is terminated.
To complicate matters, it appears Statistics Canada is now adopting an IMF accounting standard. Would it be possible for someone to confirm our conclusions on this situation and to advise on any means to look at this subject area over time or alternate sources that might have continuous series? I have appended the main body of the researchers last communication with me.
------------------------------------------------------------------------------------------
Well, as I now understand it, there are (at least) three series:
(1) 384-0023 from 1961 to 1980
(2) 384-0004 from 1981 to 2006
(3) 385-0001 from 1989 to 2009 (now terminated as well according to the website).
These series are not compatible, i.e. 1989 revenues for Manitoba for (2) are considerably less that 1989 MB revenues for (3) and it doesn't look like 1980 for (1) and 1981 for (2) are compatible either (the growth rate would be very high). So there must have been accounting changes such that earlier series are not compatible. For the 385-0001 series there is a statement: " 2007/2008 revised estimates and 2008/2009 estimates are the final reference years for which government revenues and expenditures statistics are available on a Financial Management System (FMS) basis. Statistics Canada will be adopting the International Monetary Fund accounting standard for government, called Government Finance Statistics, in 2012 starting with the reference year 2008/2009"
Can you confirm that this is correct, i.e. that there is no compatibility between the three series (and that there is no other series that is compatible over time). In particular, that the FMS series cannot be extended by before 1989? I looked through the documentation online at some length, but I can't find anything on this. I don't know who might know this at StatCan, but someone must. Thanks.
Answer
Our contacts in the divisions that produce these CANSIM tables have provided the following answer in response to your question:
"The 3 Cansim matrices that you mentioned cover two different things. Matrices 384-0004 and 384-0023 provide data based on the System of National Accounts while the matrix 385-0001 is on the Financial Management System basis, which used other accounting conventions. While both accounting systems used the provincial Public Accounts and other financial statements at the base for the statistics, conceptual differences exist between the two accounting systems of which:
- the SNA are on a calendar year basis while the FMS is on a fiscal year basis;
- in the SNA, Sales of Goods and Services are netted against expenses (ie, goods and services expenses are shown net) while in the FMS they are shown on a gross basis (they are included in the revenues); this explains in part why the revenues are less in the SNA than in the FMS;
- the SNA is on an accrual basis and shows "Current expenditure", ie, only depreciation expenses are shown in expenditure while capital expenditures are shown separately while the FMS is on a modified cash basis and shows total expenditures, ie, both current and capital are included in the expenditures.
Also, the matrix 385-0001 includes different levels of consolidation; For Manitoba, for example, series extracted under "Provincial and Territorial Governments" or "Local and Provincial and Territorial Governments" will yield to be very different results, as one include the Local level of government with the Provincial/Territorial while the other only shows the Provincial/Territorial level of government.
The matrix 384-0023 is the Provincial Economic Accounts as published in the SNA prior to the 1997 Historical Revision. 384-0004 is the PEA after that revision. While it is certainly true that there are series in the two tables that are congruent, e.g. personal income tax, in many other ways the two tables are fundamentally inconsistent. The most important reason for this incompatibility is universe changes. In the provincial government, for example, the post-1997 includes universities, colleges and health institutions, which were excluded before.
As for data back to 1961, we don't have this. With the historical revision in 1997, the PEA in the SNA went back to 1981 while we went back to only 1988/89 on a FMS basis."
A researcher here is looking at revenues and expenditures of individual provincial governments back to 1961. This used to be nicely covered by the old CANSIM I, with one matrix for each province (NFDL=6769, PEI=6770 .... BC=6778, and Yukon/NWT=6779) and covering the years 1961-1995. Similar data is available in CANSIM II, however, it is now split into three separate tables (384-0023, 384-0004, and 385-0001) , which do not seem to be compatible. The first and third table are terminated, but I don't think the second is terminated.
To complicate matters, it appears Statistics Canada is now adopting an IMF accounting standard. Would it be possible for someone to confirm our conclusions on this situation and to advise on any means to look at this subject area over time or alternate sources that might have continuous series? I have appended the main body of the researchers last communication with me.
------------------------------------------------------------------------------------------
Well, as I now understand it, there are (at least) three series:
(1) 384-0023 from 1961 to 1980
(2) 384-0004 from 1981 to 2006
(3) 385-0001 from 1989 to 2009 (now terminated as well according to the website).
These series are not compatible, i.e. 1989 revenues for Manitoba for (2) are considerably less that 1989 MB revenues for (3) and it doesn't look like 1980 for (1) and 1981 for (2) are compatible either (the growth rate would be very high). So there must have been accounting changes such that earlier series are not compatible. For the 385-0001 series there is a statement: " 2007/2008 revised estimates and 2008/2009 estimates are the final reference years for which government revenues and expenditures statistics are available on a Financial Management System (FMS) basis. Statistics Canada will be adopting the International Monetary Fund accounting standard for government, called Government Finance Statistics, in 2012 starting with the reference year 2008/2009"
Can you confirm that this is correct, i.e. that there is no compatibility between the three series (and that there is no other series that is compatible over time). In particular, that the FMS series cannot be extended by before 1989? I looked through the documentation online at some length, but I can't find anything on this. I don't know who might know this at StatCan, but someone must. Thanks.
Answer
Our contacts in the divisions that produce these CANSIM tables have provided the following answer in response to your question:
"The 3 Cansim matrices that you mentioned cover two different things. Matrices 384-0004 and 384-0023 provide data based on the System of National Accounts while the matrix 385-0001 is on the Financial Management System basis, which used other accounting conventions. While both accounting systems used the provincial Public Accounts and other financial statements at the base for the statistics, conceptual differences exist between the two accounting systems of which:
- the SNA are on a calendar year basis while the FMS is on a fiscal year basis;
- in the SNA, Sales of Goods and Services are netted against expenses (ie, goods and services expenses are shown net) while in the FMS they are shown on a gross basis (they are included in the revenues); this explains in part why the revenues are less in the SNA than in the FMS;
- the SNA is on an accrual basis and shows "Current expenditure", ie, only depreciation expenses are shown in expenditure while capital expenditures are shown separately while the FMS is on a modified cash basis and shows total expenditures, ie, both current and capital are included in the expenditures.
Also, the matrix 385-0001 includes different levels of consolidation; For Manitoba, for example, series extracted under "Provincial and Territorial Governments" or "Local and Provincial and Territorial Governments" will yield to be very different results, as one include the Local level of government with the Provincial/Territorial while the other only shows the Provincial/Territorial level of government.
The matrix 384-0023 is the Provincial Economic Accounts as published in the SNA prior to the 1997 Historical Revision. 384-0004 is the PEA after that revision. While it is certainly true that there are series in the two tables that are congruent, e.g. personal income tax, in many other ways the two tables are fundamentally inconsistent. The most important reason for this incompatibility is universe changes. In the provincial government, for example, the post-1997 includes universities, colleges and health institutions, which were excluded before.
As for data back to 1961, we don't have this. With the historical revision in 1997, the PEA in the SNA went back to 1981 while we went back to only 1988/89 on a FMS basis."
Stat Can Fruit & Vegetable Survey Methods Question
Question
A Researcher is asking:
"I´m trying to gather detailed information on the Stat Can Fruit & Vegetable Survey. I have found sources stating that: Within each province, farms are stratified based into those which produce only fruit, only vegetables, or both products. A size threshold of fruit and vegetable farmland is defined; farms below the threshold ("small" farms) are randomly sampled, and a census is taken from farms above the threshold. I can´t find any information on what this "size threshold" is or how it is determined. My source of this information is here:
http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=3407&lang=en&db=imdb&adm=8&dis=2 Do you have any ideas on where else to look for this info?"
The info on Sampling, from the above web page, reads as follows. I expect the researcher is interested in the specific threshold & methodology, as applied to BC, over the years:
Sampling
This is a sample survey with a cross-sectional design.
For each province, three strata were defined based on the type of operation i.e. fruit only operation, vegetable only operation or fruit and vegetable operation. In each stratum, a threshold based on the total fruit acreage and on the total vegetable acreage was defined. A random sample was selected among the operations below the threshold. A census of all operations above the threshold was taken as well. Thresholds went from 2 to 10 acres depending on the province. For each stratum, the minimum sample size was 10 and the maximum design weight was two.
Overall, the sample size was determined in order to achieve a target CV of 0.01 (1%) for total fruit area and total vegetable area at the provincial level. The final sample size for this fall survey was 9,614 operations. We excluded small farms having only two acres or less in vegetables.
Answer
Our agriculture contacts have provided the following information in response to your question below:
"The size thresholds are:
- 2 acres for Newfoundland, Prince Edward Island, Nova Scotia, and New Brunswick
- 5 acres for Alberta
- 10 acres for Quebec, Ontario, Manitoba, Saskatchewan, and British Columbia
In BC, farms with less than 10 acres of fruit and less than 10 acres of vegetables are placed in one of three sampling strata: fruit-only, vegetables-only, or both. A simple random sample is taken within each stratum, with the constraints that the sampling fraction can be no less than 0.5 and the minimum sample size is 10. A census is taken among all other farms.
The size thresholds were implemented as part of the 2008 redesign, with the goal of reducing the number of farms sent to collection while maintaining data quality. For each province, the threshold was determined so that the farms below that threshold are small enough to not contribute significantly to the estimates. Rather than sampling all of the "small" farms in a province, we sample 50% of them and assign each farm a weight of 2."
A Researcher is asking:
"I´m trying to gather detailed information on the Stat Can Fruit & Vegetable Survey. I have found sources stating that: Within each province, farms are stratified based into those which produce only fruit, only vegetables, or both products. A size threshold of fruit and vegetable farmland is defined; farms below the threshold ("small" farms) are randomly sampled, and a census is taken from farms above the threshold. I can´t find any information on what this "size threshold" is or how it is determined. My source of this information is here:
http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=3407&lang=en&db=imdb&adm=8&dis=2 Do you have any ideas on where else to look for this info?"
The info on Sampling, from the above web page, reads as follows. I expect the researcher is interested in the specific threshold & methodology, as applied to BC, over the years:
Sampling
This is a sample survey with a cross-sectional design.
For each province, three strata were defined based on the type of operation i.e. fruit only operation, vegetable only operation or fruit and vegetable operation. In each stratum, a threshold based on the total fruit acreage and on the total vegetable acreage was defined. A random sample was selected among the operations below the threshold. A census of all operations above the threshold was taken as well. Thresholds went from 2 to 10 acres depending on the province. For each stratum, the minimum sample size was 10 and the maximum design weight was two.
Overall, the sample size was determined in order to achieve a target CV of 0.01 (1%) for total fruit area and total vegetable area at the provincial level. The final sample size for this fall survey was 9,614 operations. We excluded small farms having only two acres or less in vegetables.
Answer
Our agriculture contacts have provided the following information in response to your question below:
"The size thresholds are:
- 2 acres for Newfoundland, Prince Edward Island, Nova Scotia, and New Brunswick
- 5 acres for Alberta
- 10 acres for Quebec, Ontario, Manitoba, Saskatchewan, and British Columbia
In BC, farms with less than 10 acres of fruit and less than 10 acres of vegetables are placed in one of three sampling strata: fruit-only, vegetables-only, or both. A simple random sample is taken within each stratum, with the constraints that the sampling fraction can be no less than 0.5 and the minimum sample size is 10. A census is taken among all other farms.
The size thresholds were implemented as part of the 2008 redesign, with the goal of reducing the number of farms sent to collection while maintaining data quality. For each province, the threshold was determined so that the farms below that threshold are small enough to not contribute significantly to the estimates. Rather than sampling all of the "small" farms in a province, we sample 50% of them and assign each farm a weight of 2."
University Enrolments
Question
I have a researcher looking for the most recent university enrolment statistics- by province as well as by institution. Is this available through the DLI?
Answer
We have university enrolment figures by province in the DLI collection through the Postsecondary Student Information System (PSIS). You can download the latest figures from our website (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/psis-siep-eng.htm) or through the FTP site. Tables 7 to 12 are for universities. When you open the Excel files, use the tabs at the bottom of the sheets to view all of the data. University enrolment data by institution would be available for a fee as a custom request. If this is of interest to your client, please let me know and I will be happy to refer you to an Account-Executive who can help you define the custom tables' specifications and give you an official quote. You may also wish to have a look at the publications that are available on the Canadian Association of University Teachers (http://www.caut.ca/) website under Publications and research. They may have enrolments by university in their publications.
I have a researcher looking for the most recent university enrolment statistics- by province as well as by institution. Is this available through the DLI?
Answer
We have university enrolment figures by province in the DLI collection through the Postsecondary Student Information System (PSIS). You can download the latest figures from our website (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/psis-siep-eng.htm) or through the FTP site. Tables 7 to 12 are for universities. When you open the Excel files, use the tabs at the bottom of the sheets to view all of the data. University enrolment data by institution would be available for a fee as a custom request. If this is of interest to your client, please let me know and I will be happy to refer you to an Account-Executive who can help you define the custom tables' specifications and give you an official quote. You may also wish to have a look at the publications that are available on the Canadian Association of University Teachers (http://www.caut.ca/) website under Publications and research. They may have enrolments by university in their publications.
More Aboriginal Population Profile vs. INAC Questions
Question
I have another couple of questions related to what I asked back in December re: geography on the INAC site vs. Statistics Canada.
INAC seems to have a new interactive map at http://fnpim-cippn.inac-ainc.gc.ca/index-eng.asp. The points represented on the map seem to be Bands. I notice that many of these Bands are included in the 2006 Aboriginal Population Profiles at http://www.census2006.com/census-recensement/2006/dp-pd/prof/92-594/index.cfm?Lang=E. However, they are not all included. For instance, the Lake Babine Nation is included in the INAC map but is not included in the Profiles. It seems that anything on the INAC site that has the attribute “Act Electoral System” is included in the Profiles, whereas anything with the attribute “Custom Electoral System” is not included. Could we get an explanation as to why this is so?
Also, when I compare the populations given for the bands on the INAC map with the populations for bands in the Profiles, they seem to totally disagree. The INAC figures are consistently inflated. For instance, the “Registered Population” for the Moricetown Band on the INAC site is 1889, whereas the population given in the profiles is 592. Why would that be?
Answer
Our Census contacts have provided the following details about the 2006 Aboriginal Population Profiles in response to your question:
"I can’t speak to the INAC figures, but I can give you some information on the Aboriginal Population profile. In this product, data are available for areas where the Aboriginal identity population count is 250 or more. This means that areas where the census enumerated fewer than 250 persons with an Aboriginal Identity are not included in this product. The Aboriginal identity population comprises those persons who reported identifying with at least one Aboriginal group, that is, North American Indian, Métis or Inuit, and/or those who reported being a Treaty Indian or a Registered Indian, as defined by the Indian Act of Canada, and/or those who reported they were members of an Indian band or First Nation.
Additionally, the Indian band areas are included within this profile and are defined using census subdivisions. The data for the Indian band areas are for the total Aboriginal population living in the communities. People who live in the communities do not all belong to the specific Indian band/First Nation. The list does not include Indian band areas for communities (census subdivisions) which are associated with more than one Indian band/First Nation.
For more information on the concepts I mentioned, such as Aboriginal Identity and Census Subdivision, please consult the 2006 Census Dictionary at the following link http://www12.statcan.gc.ca/census-recensement/2006/ref/dict/azindex-eng.cfm or from the Statistics Canada home page by selecting Census > Reference materials > 2006 Census Dictionary > Complete A to Z. For more information on the Aboriginal population profile, please consult the Help/FAQs section in the left column of any web page of the product."
As a next step, you may wish to ask INAC for similar details about the "Registered Population" figures on their site. According to this Definitions page (http://pse5-esd5.ainc-inac.gc.ca/fnp/Main/Definitions.aspx?lang=eng) on the INAC site, registered population seems to be from a source called the Indian Registry System. The following table from the INAC site seems to further break down the registered population for Moricetown may also help: http://pse5-esd5.ainc-inac.gc.ca/fnp/Main/Search/FNRegPopulation.aspx?BAND_NUMBER=530&lang=eng The First Nations and Northern Statistics Section at INAC can be reached at: 1-800-567-9604 or INSTAT@ainc-inac.gc.ca (contact details as listed on INAc website).
I hope that this information is helpful. Please let me know if you have any other questions as you continue to research this.
I have another couple of questions related to what I asked back in December re: geography on the INAC site vs. Statistics Canada.
INAC seems to have a new interactive map at http://fnpim-cippn.inac-ainc.gc.ca/index-eng.asp. The points represented on the map seem to be Bands. I notice that many of these Bands are included in the 2006 Aboriginal Population Profiles at http://www.census2006.com/census-recensement/2006/dp-pd/prof/92-594/index.cfm?Lang=E. However, they are not all included. For instance, the Lake Babine Nation is included in the INAC map but is not included in the Profiles. It seems that anything on the INAC site that has the attribute “Act Electoral System” is included in the Profiles, whereas anything with the attribute “Custom Electoral System” is not included. Could we get an explanation as to why this is so?
Also, when I compare the populations given for the bands on the INAC map with the populations for bands in the Profiles, they seem to totally disagree. The INAC figures are consistently inflated. For instance, the “Registered Population” for the Moricetown Band on the INAC site is 1889, whereas the population given in the profiles is 592. Why would that be?
Answer
Our Census contacts have provided the following details about the 2006 Aboriginal Population Profiles in response to your question:
"I can’t speak to the INAC figures, but I can give you some information on the Aboriginal Population profile. In this product, data are available for areas where the Aboriginal identity population count is 250 or more. This means that areas where the census enumerated fewer than 250 persons with an Aboriginal Identity are not included in this product. The Aboriginal identity population comprises those persons who reported identifying with at least one Aboriginal group, that is, North American Indian, Métis or Inuit, and/or those who reported being a Treaty Indian or a Registered Indian, as defined by the Indian Act of Canada, and/or those who reported they were members of an Indian band or First Nation.
Additionally, the Indian band areas are included within this profile and are defined using census subdivisions. The data for the Indian band areas are for the total Aboriginal population living in the communities. People who live in the communities do not all belong to the specific Indian band/First Nation. The list does not include Indian band areas for communities (census subdivisions) which are associated with more than one Indian band/First Nation.
For more information on the concepts I mentioned, such as Aboriginal Identity and Census Subdivision, please consult the 2006 Census Dictionary at the following link http://www12.statcan.gc.ca/census-recensement/2006/ref/dict/azindex-eng.cfm or from the Statistics Canada home page by selecting Census > Reference materials > 2006 Census Dictionary > Complete A to Z. For more information on the Aboriginal population profile, please consult the Help/FAQs section in the left column of any web page of the product."
As a next step, you may wish to ask INAC for similar details about the "Registered Population" figures on their site. According to this Definitions page (http://pse5-esd5.ainc-inac.gc.ca/fnp/Main/Definitions.aspx?lang=eng) on the INAC site, registered population seems to be from a source called the Indian Registry System. The following table from the INAC site seems to further break down the registered population for Moricetown may also help: http://pse5-esd5.ainc-inac.gc.ca/fnp/Main/Search/FNRegPopulation.aspx?BAND_NUMBER=530&lang=eng The First Nations and Northern Statistics Section at INAC can be reached at: 1-800-567-9604 or INSTAT@ainc-inac.gc.ca (contact details as listed on INAc website).
I hope that this information is helpful. Please let me know if you have any other questions as you continue to research this.
Population by Language
Question
I've received a request from a prof here at the U of S for population data for the NWT that's broken down by age and language(s). That is, how many in each age group speak English or French or both? For simplicity's sake, he's not looking at non-official languages. We've found population by age group; and we've found language data, but not categorized by age.
Answer
The following topic based tabulation from the 2006 Census may meet your user's needs. If you go to the Download tab, you can download the table and work with it in Beyond 20/20 to display the data for all of the age ranges.
Knowledge of Official Languages (5), Number of Non-official Languages Known (5), Age Groups (17A) and Sex (3) for the Population of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2006 Census - 20% Sample Data (97-555-XCB2006009)
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=89188&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=704&Temporal=2006&THEME=70&VID=0&VNAMEE=&VNAMEF=
The user may also be interested in the other 2006 Census language related topic-based tabulations that are available under: http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/St-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=70&VID=0&VNAMEE=&VNAMEF=
Should these not meet the user's needs, please don't hesitate to let me know and I will be happy to locate other products.
I've received a request from a prof here at the U of S for population data for the NWT that's broken down by age and language(s). That is, how many in each age group speak English or French or both? For simplicity's sake, he's not looking at non-official languages. We've found population by age group; and we've found language data, but not categorized by age.
Answer
The following topic based tabulation from the 2006 Census may meet your user's needs. If you go to the Download tab, you can download the table and work with it in Beyond 20/20 to display the data for all of the age ranges.
Knowledge of Official Languages (5), Number of Non-official Languages Known (5), Age Groups (17A) and Sex (3) for the Population of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2006 Census - 20% Sample Data (97-555-XCB2006009)
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=89188&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=704&Temporal=2006&THEME=70&VID=0&VNAMEE=&VNAMEF=
The user may also be interested in the other 2006 Census language related topic-based tabulations that are available under: http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/St-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=70&VID=0&VNAMEE=&VNAMEF=
Should these not meet the user's needs, please don't hesitate to let me know and I will be happy to locate other products.
Enrolment in Online Courses (Particularly Teachers)
Question
I have a researcher who is looking for the number of people (particularly teachers) who are enrolled in on-line courses across Canada (and, if possible for urban vs rural areas).
So far, I have found the following:
Canadian Internet Use Survey (CIUS) – Has variables for use of the Internet at home for educational purposes and for urban/rural. Does not seem to capture Internet use at work or occupation.
Access and Support to Education and Training Survey (ASETS) – Publication based on this survey seems to indicate variables for distance education use, including delivery by Internet, and occupation.
Adult Education and Training Survey (AETS) – The Training File has variables for mode of delivery, and the Main File has occupation variables.
Some specific questions:
1. A message on the DLI list indicated that work on the ASETS PUMF would start April 2010. Is there an anticipated release date? It is not included in the DLI product release dates list on the DLI site…
2. For AETS, there are two files: the Training File and the Main File. The Training File population seems to be a subset of the Main file population, and there are CASEIDs. I am assuming that the CASEIDs can be used to link between the two files to allow for analysis of variables between files. Can this please be confirmed?
3. Is there anything that I may have missed (as up to date as possible) that can answer this researcher’s question?
Answer
Our contacts for CIUS have provided the following information about data on use of the Internet for educational purposes that were collected via the Canadian Internet Use Survey (CIUS) 2005. If these data are of interest to your client, I would be pleased to refer you to an Account-Executive who can provide additional information on the tables that could be produced, a cost estimate and a production timeline.
"Please note that the Canadian Internet Use Survey (CIUS) is a biennial measure first conducted in 2005. The 2005 CIUS included a questionnaire module on using the Internet for education, training or school work. Please see EU (Education Use) questions on page 18 of the questionnaire: http://www.statcan.gc.ca/imdb-bmdi/instrument/4432_Q1_V6-eng.pdf
Only those survey respondents who answered yes to the filter question ...SU_Q06 During the past 12 months, have you used the Internet at home? ... for education, training or school work ... were asked the more detailed EU module questions. Based on these responses, the following analytic work was prepared: http://www.statcan.gc.ca/pub/81-004-x/2007004/10375-eng.htm
For the 2007 and 2009 surveys, the EU module was not asked but the filter question remains and it is on the 2007 PUMF. Another limitation is that only home Internet users are asked questions about their personal Internet activities. As such, a school teacher using the Internet to take course either to upgrade skills or required for terms of employment are not technically using it for personal reasons. That said, we have the occupation of survey respondents as the CIUS is a Labour Force Supplement."
I have also asked our education contacts to advise with respect to questions #1 and #2 below and will follow up with more information as soon as possible. Please don't hesitate to contact me if you have any other questions or if you would like me to put you in touch with an Account-Executive for additional information on custom CIUS tables.
I have a researcher who is looking for the number of people (particularly teachers) who are enrolled in on-line courses across Canada (and, if possible for urban vs rural areas).
So far, I have found the following:
Canadian Internet Use Survey (CIUS) – Has variables for use of the Internet at home for educational purposes and for urban/rural. Does not seem to capture Internet use at work or occupation.
Access and Support to Education and Training Survey (ASETS) – Publication based on this survey seems to indicate variables for distance education use, including delivery by Internet, and occupation.
Adult Education and Training Survey (AETS) – The Training File has variables for mode of delivery, and the Main File has occupation variables.
Some specific questions:
1. A message on the DLI list indicated that work on the ASETS PUMF would start April 2010. Is there an anticipated release date? It is not included in the DLI product release dates list on the DLI site…
2. For AETS, there are two files: the Training File and the Main File. The Training File population seems to be a subset of the Main file population, and there are CASEIDs. I am assuming that the CASEIDs can be used to link between the two files to allow for analysis of variables between files. Can this please be confirmed?
3. Is there anything that I may have missed (as up to date as possible) that can answer this researcher’s question?
Answer
Our contacts for CIUS have provided the following information about data on use of the Internet for educational purposes that were collected via the Canadian Internet Use Survey (CIUS) 2005. If these data are of interest to your client, I would be pleased to refer you to an Account-Executive who can provide additional information on the tables that could be produced, a cost estimate and a production timeline.
"Please note that the Canadian Internet Use Survey (CIUS) is a biennial measure first conducted in 2005. The 2005 CIUS included a questionnaire module on using the Internet for education, training or school work. Please see EU (Education Use) questions on page 18 of the questionnaire: http://www.statcan.gc.ca/imdb-bmdi/instrument/4432_Q1_V6-eng.pdf
Only those survey respondents who answered yes to the filter question ...SU_Q06 During the past 12 months, have you used the Internet at home? ... for education, training or school work ... were asked the more detailed EU module questions. Based on these responses, the following analytic work was prepared: http://www.statcan.gc.ca/pub/81-004-x/2007004/10375-eng.htm
For the 2007 and 2009 surveys, the EU module was not asked but the filter question remains and it is on the 2007 PUMF. Another limitation is that only home Internet users are asked questions about their personal Internet activities. As such, a school teacher using the Internet to take course either to upgrade skills or required for terms of employment are not technically using it for personal reasons. That said, we have the occupation of survey respondents as the CIUS is a Labour Force Supplement."
I have also asked our education contacts to advise with respect to questions #1 and #2 below and will follow up with more information as soon as possible. Please don't hesitate to contact me if you have any other questions or if you would like me to put you in touch with an Account-Executive for additional information on custom CIUS tables.
Subscribe to:
Posts (Atom)