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).
Thursday, September 23, 2010
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.
Thursday, September 16, 2010
Provincial Economic Accounts
Question
The Provincial Economic Accounts are .wk3 files which do not open in Excel 2007. Do you know if they will be converted to excel?
Answer
I will ask the author division for versions of these older files that can be opened with more recent versions of Excel.
As you may recall, we received the last issue of these products in 2008. They were replaced by web based tables that are available in both Excel and comma separated value (CSV) formats (http://www.statcan.gc.ca/dli-ild/data-donnees/mhonarc/dli-ild-msg/msg12998.html).
For example: http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=13-018-X
You can access the new Provincial Economic Accounts (PEA) products through the Links to related products section on the left side bar of the PEA program page in the Definitions, data sources and methods section of the StatCan website: http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=1902&lang=en&db=imdb&adm=8&dis=2 or by searching for the catalogue numbers of the discontinued products in the StatCan Online Catalogue.
Please don't hesitate to let me know if you have any questions.
Additional Information
The author division has confirmed that the web based Data Tables products that replace the files that were discontinued in 2008 contain the current versions of the series in the discontinued products from start to current and that these data are also available on CANSIM. They have therefore decided that they will not be converting the discontinued .wk3 files to Excel.
The Provincial Economic Accounts are .wk3 files which do not open in Excel 2007. Do you know if they will be converted to excel?
Answer
I will ask the author division for versions of these older files that can be opened with more recent versions of Excel.
As you may recall, we received the last issue of these products in 2008. They were replaced by web based tables that are available in both Excel and comma separated value (CSV) formats (http://www.statcan.gc.ca/dli-ild/data-donnees/mhonarc/dli-ild-msg/msg12998.html).
For example: http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=13-018-X
You can access the new Provincial Economic Accounts (PEA) products through the Links to related products section on the left side bar of the PEA program page in the Definitions, data sources and methods section of the StatCan website: http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=1902&lang=en&db=imdb&adm=8&dis=2 or by searching for the catalogue numbers of the discontinued products in the StatCan Online Catalogue.
Please don't hesitate to let me know if you have any questions.
Additional Information
The author division has confirmed that the web based Data Tables products that replace the files that were discontinued in 2008 contain the current versions of the series in the discontinued products from start to current and that these data are also available on CANSIM. They have therefore decided that they will not be converting the discontinued .wk3 files to Excel.
Women in Non-Traditional Occupations and Fields of Study
An article on Women in Non-traditional Occupations and Fields of Study is being released today in the April issue of Statistics Canada’s free online publication Education Matters: Insights on Education, Learning and Training in Canada.
This article takes stock of changes that have taken place over time in the occupations held by women in the labour market and in the fields of study they are choosing at the postsecondary level. It demonstrates where changes have occurred and suggests where change may happen in future as a result of shifts in the composition of postsecondary education graduates.
Enclosed is the link to the Spotlight on the Census web page http://www12.statcan.ca/census-recensement/index-eng.cfm
Thank you.
This article takes stock of changes that have taken place over time in the occupations held by women in the labour market and in the fields of study they are choosing at the postsecondary level. It demonstrates where changes have occurred and suggests where change may happen in future as a result of shifts in the composition of postsecondary education graduates.
Enclosed is the link to the Spotlight on the Census web page http://www12.statcan.ca/census-recensement/index-eng.cfm
Thank you.
Manufacturers and Distributors in Calgary
Question
I am looking for the number of manufacturers and distributors within the city of Calgary who ship cargo, where they ship the cargo, and the dollar value of the cargo they ship... Is this available anywhere please?
Answer
You could approach this from a few different angles using StatCan products and surveys.
Canadian Business Patterns (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=61F0040X&lang=eng - available through DLI) provides counts of business locations by NAICS at various levels of geography including CMAs. This product wouldn't give you information on destination of shipments and dollar value of cargo being shipped however, only counts of budiness locations in manufacturing/distribution/shipment industries. The first step would be to locate NAICS codes ((http://www.statcan.gc.ca/concepts/industry-industrie-eng.htm) for the industries that interest your client. If you have any questions while doing this, please let me know and I will consult our contacts in the Business Register Division.
Some of StatCan's transportation surveys cover cargo shipments from a transportation perspective (air, rail, water - see general overview of transportation surveys in http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=50F0001G). These transportation surveys wouldn't provide data on the number of manufacturers and distributors however. Please let me know if this is of interest and I will recommend specific sources.
Provincial-level data on products shipped by manufacturers would be available as a custom tables from our manufacturing surveys as would counts of business engaged in manufacturing at a sub-provincial level. I would be happy to refer you to an Account-Executive who could work with you on table specifications and provide a cost estimate if these or custom tables from the Business Register are of interest to your client.
Directories of manufacturers and distributors and/or industry associations may be sources of helpful information for your user as well.
I hope that these suggestions are helpful.
I am looking for the number of manufacturers and distributors within the city of Calgary who ship cargo, where they ship the cargo, and the dollar value of the cargo they ship... Is this available anywhere please?
Answer
You could approach this from a few different angles using StatCan products and surveys.
Canadian Business Patterns (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=61F0040X&lang=eng - available through DLI) provides counts of business locations by NAICS at various levels of geography including CMAs. This product wouldn't give you information on destination of shipments and dollar value of cargo being shipped however, only counts of budiness locations in manufacturing/distribution/shipment industries. The first step would be to locate NAICS codes ((http://www.statcan.gc.ca/concepts/industry-industrie-eng.htm) for the industries that interest your client. If you have any questions while doing this, please let me know and I will consult our contacts in the Business Register Division.
Some of StatCan's transportation surveys cover cargo shipments from a transportation perspective (air, rail, water - see general overview of transportation surveys in http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=50F0001G). These transportation surveys wouldn't provide data on the number of manufacturers and distributors however. Please let me know if this is of interest and I will recommend specific sources.
Provincial-level data on products shipped by manufacturers would be available as a custom tables from our manufacturing surveys as would counts of business engaged in manufacturing at a sub-provincial level. I would be happy to refer you to an Account-Executive who could work with you on table specifications and provide a cost estimate if these or custom tables from the Business Register are of interest to your client.
Directories of manufacturers and distributors and/or industry associations may be sources of helpful information for your user as well.
I hope that these suggestions are helpful.
Changes Made to Improve Health Module in CCHS 2007/2008
Question
"Is there are a “Changes made to improve health” module in the CCHS 2007/2008 PUMF? It seems to only be available for 2000, by means of CANSIM table 105-0034."
Answer
"I have consulted the Canadian Community Health Survey (CCHS) 2007/2008 public use microdata file (PUMF) codebook (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/cchs-escc/cchs-escc2007-2008-eng.htm) and the file does seem to contain a "Theme module: Changes made to improve health - (F)" (see page 23 and onwards).
The CCHS 2007/2008 PUMF and related documentation files can be downloaded from our FTP site and website (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/cchs-escc/cchs-escc2007-2008-eng.htm).
I hope that this information is helpful. Please don't hesitate to let me know if you have any other questions."
"Is there are a “Changes made to improve health” module in the CCHS 2007/2008 PUMF? It seems to only be available for 2000, by means of CANSIM table 105-0034."
Answer
"I have consulted the Canadian Community Health Survey (CCHS) 2007/2008 public use microdata file (PUMF) codebook (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/cchs-escc/cchs-escc2007-2008-eng.htm) and the file does seem to contain a "Theme module: Changes made to improve health - (F)" (see page 23 and onwards).
The CCHS 2007/2008 PUMF and related documentation files can be downloaded from our FTP site and website (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/cchs-escc/cchs-escc2007-2008-eng.htm).
I hope that this information is helpful. Please don't hesitate to let me know if you have any other questions."
New Researcher Query Re: Aboriginal People's Survey: "Non-Inuit in the Arctic" Respnse
Question
I have a researcher here using the 2006 APS and she has asked for clarification in regards to this question about Aboriginal Ancestry, particularly with the responses “Non Inuit in Arctic” and “No Aboriginal ancestry”.
We found some information in the documentation on page 24.
http://prod.library.utoronto.ca:8090/datalib/codebooks/cstdli/aps/2006/aps2006gid_eng.pdf
Variable Name: GDANCESG Position: 8 Length: 2
Aboriginal ancestry indicator-grouped
FREQ WTD
01 North American Indian only 11,270 541,483
02 Métis only 5,202 238,707
03 Inuit only 2,660 36,340
04 Multiple ancestries 4,849 212,281
05 No Aboriginal ancestry 232 7,878
06 Non Inuit in Arctic 155 1,695
====== =========
24,368 1,038,385
Coverage: All respondents
Note: Derived from question 1(Q01).
'Non-Inuit in Arctic' refers to any response other than 'Inuit only' in the Arctic region.
From my reading of this, I believe it refers to other Aboriginal (not Inuit) peoples living in the Arctic, and "No Aboriginal Identity" would capture the rest. Could someone please clarify this for the researcher?
Answer
The Aboriginal Peoples Survey (APS) team provided the following explanation in response to your question about Aboriginal Ancestry in APS 2006:
"The target population for the 2006 APS is composed of the Aboriginal population in Canada living in private dwellings, 6 years of age and older as of October 31, 2006, excluding people living in Indian Settlements or on reserve. Reserves in the territories are included in the target population, however. The "Aboriginal population" is defined as either the Aboriginal identity population or the Aboriginal ancestry population.
The APS sample was selected based on responses to four screening questions (Q17, Q18, Q20, Q21) on the 2006 Census long form. Question 17 (What were the ethnic or cultural origins of this person's ancestors?) is used to define Aboriginal ancestry while the other three questions define Aboriginal identity. Some respondents reported Aboriginal identity but no Aboriginal ancestry - these are the respondents in category 5: No Aboriginal ancestry.
Since reserves in the territories were included in the sample population, "non-Inuit in Arctic" would include those selected from these reserves, as well as those off-reserve with non-Inuit ancestry. Note that this latter group could include persons with Inuit identity but not Inuit ancestry, or persons who have non-Inuit Aboriginal identity and/or ancestry."
Additional Question
I have just been speaking with the researcher again and she was also wondering about the variable “gdidentg” located on page 26 of the guide.
She asks the following:
“Would it be possible to ask directly if the Aboriginal Identity variable (gdidentg) response 'Non Inuit in Arctic' includes people with no Aboriginal identity in addition to those with NAI, Métis, multiple or other Aboriginal identities?”
Answer
The APS team confirms that "That's correct. The GDIDENTG variable is based on APS questions 2, 3, and 5, and as was the case for Aboriginal ancestry, the number of non-Inuit responses in the Arctic was very small. So, for the purposes of the PUMF, these responses were combined into the "Non Inuit in Arctic " category."
I have a researcher here using the 2006 APS and she has asked for clarification in regards to this question about Aboriginal Ancestry, particularly with the responses “Non Inuit in Arctic” and “No Aboriginal ancestry”.
We found some information in the documentation on page 24.
http://prod.library.utoronto.ca:8090/datalib/codebooks/cstdli/aps/2006/aps2006gid_eng.pdf
Variable Name: GDANCESG Position: 8 Length: 2
Aboriginal ancestry indicator-grouped
FREQ WTD
01 North American Indian only 11,270 541,483
02 Métis only 5,202 238,707
03 Inuit only 2,660 36,340
04 Multiple ancestries 4,849 212,281
05 No Aboriginal ancestry 232 7,878
06 Non Inuit in Arctic 155 1,695
====== =========
24,368 1,038,385
Coverage: All respondents
Note: Derived from question 1(Q01).
'Non-Inuit in Arctic' refers to any response other than 'Inuit only' in the Arctic region.
From my reading of this, I believe it refers to other Aboriginal (not Inuit) peoples living in the Arctic, and "No Aboriginal Identity" would capture the rest. Could someone please clarify this for the researcher?
Answer
The Aboriginal Peoples Survey (APS) team provided the following explanation in response to your question about Aboriginal Ancestry in APS 2006:
"The target population for the 2006 APS is composed of the Aboriginal population in Canada living in private dwellings, 6 years of age and older as of October 31, 2006, excluding people living in Indian Settlements or on reserve. Reserves in the territories are included in the target population, however. The "Aboriginal population" is defined as either the Aboriginal identity population or the Aboriginal ancestry population.
The APS sample was selected based on responses to four screening questions (Q17, Q18, Q20, Q21) on the 2006 Census long form. Question 17 (What were the ethnic or cultural origins of this person's ancestors?) is used to define Aboriginal ancestry while the other three questions define Aboriginal identity. Some respondents reported Aboriginal identity but no Aboriginal ancestry - these are the respondents in category 5: No Aboriginal ancestry.
Since reserves in the territories were included in the sample population, "non-Inuit in Arctic" would include those selected from these reserves, as well as those off-reserve with non-Inuit ancestry. Note that this latter group could include persons with Inuit identity but not Inuit ancestry, or persons who have non-Inuit Aboriginal identity and/or ancestry."
Additional Question
I have just been speaking with the researcher again and she was also wondering about the variable “gdidentg” located on page 26 of the guide.
She asks the following:
“Would it be possible to ask directly if the Aboriginal Identity variable (gdidentg) response 'Non Inuit in Arctic' includes people with no Aboriginal identity in addition to those with NAI, Métis, multiple or other Aboriginal identities?”
Answer
The APS team confirms that "That's correct. The GDIDENTG variable is based on APS questions 2, 3, and 5, and as was the case for Aboriginal ancestry, the number of non-Inuit responses in the Arctic was very small. So, for the purposes of the PUMF, these responses were combined into the "Non Inuit in Arctic " category."
2 Questions - Foreign Students & Outward Remittance by Immigrants
Question
I have a student looking for the number of foreign students who come to Canada but not just for college and university studies but also high school, private education etc. In addition, he asks if there are any figures on financial assistance given to these students.
The second question relates to the data on outward remittance i.e. how much money do immigrants send to other countries and which countries by amount.
I would appreciate your help in answering these questions.
Answer
Statistics on college and university enrolments by immigration status (Canadian students/International students/Not reported) are available in the Postsecondary Student Information System (PSIS) tables that were recently added to the DLI collection (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/psis-siep-eng.htm).
Our education contacts have confirmed that they do not collect any data for foreign students at the high school level or in private schools nor do they collect data on financial assistance for foreign students. As mentioned in an off-list message, you may also wish to look into the data on foreign students by level of study that would be available from CIC.
With respect to your second question on outward remittances, your user may be interested in the publications and sources cited in the following Daily release for the 2008 study "Remittances by recent immigrants" : http://www.statcan.gc.ca/daily-quotidien/080723/dq080723b-eng.htm (see the sources listed at the bottom of the release). If the specific information the student requires isn't included in these sources, please do not hesitate to let me know.
I hope that this information is helpful.
I have a student looking for the number of foreign students who come to Canada but not just for college and university studies but also high school, private education etc. In addition, he asks if there are any figures on financial assistance given to these students.
The second question relates to the data on outward remittance i.e. how much money do immigrants send to other countries and which countries by amount.
I would appreciate your help in answering these questions.
Answer
Statistics on college and university enrolments by immigration status (Canadian students/International students/Not reported) are available in the Postsecondary Student Information System (PSIS) tables that were recently added to the DLI collection (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/psis-siep-eng.htm).
Our education contacts have confirmed that they do not collect any data for foreign students at the high school level or in private schools nor do they collect data on financial assistance for foreign students. As mentioned in an off-list message, you may also wish to look into the data on foreign students by level of study that would be available from CIC.
With respect to your second question on outward remittances, your user may be interested in the publications and sources cited in the following Daily release for the 2008 study "Remittances by recent immigrants" : http://www.statcan.gc.ca/daily-quotidien/080723/dq080723b-eng.htm (see the sources listed at the bottom of the release). If the specific information the student requires isn't included in these sources, please do not hesitate to let me know.
I hope that this information is helpful.
World Bank Frees Up Data
A data colleague from the UK sent out a very exciting message: the World Bank is going to provide free access to a lot of its data (including World Development Indicators).
• Bank Group offers free access to more than 2,000 financial, business, health, economic and human development statistics via a new website: data.worldbank.org
• An initial 330 indicators are available in French, Spanish and Arabic
• Experts say open access policy will foster innovation, support evidence-based policymaking
April 20, 2010—The World Bank Group said today it will offer free access to more than 2,000 financial, business, health, economic and human development statistics that had mostly been available only to paying subscribers.
The decision - part of a larger effort to increase access to information at the World Bank - means that researchers, journalists, nongovernmental organizations (NGOs), entrepreneurs and school children alike will be able to tap into the World Bank's databases via a new website, data.worldbank.org.
Experts say the Bank's open data initiative has the potential to stimulate more evidence-based policymaking in developing countries by bringing more researchers and innovative analysis into the development process. The move is also likely to stimulate demand for data and increase countries' capacity to produce it, they say.
And, for the first time, data will be available in languages other than English, with an initial 330 indicators translated into French, Spanish and Arabic.
“It’s important to make the data and knowledge of the World Bank available to everyone," World Bank President Robert B. Zoellick said. "Statistics tell the story of people in developing and emerging countries and can play an important part in helping to overcome poverty.”
Quite exciting, and some costs savings for institutions which have subscribed to these data.
• Bank Group offers free access to more than 2,000 financial, business, health, economic and human development statistics via a new website: data.worldbank.org
• An initial 330 indicators are available in French, Spanish and Arabic
• Experts say open access policy will foster innovation, support evidence-based policymaking
April 20, 2010—The World Bank Group said today it will offer free access to more than 2,000 financial, business, health, economic and human development statistics that had mostly been available only to paying subscribers.
The decision - part of a larger effort to increase access to information at the World Bank - means that researchers, journalists, nongovernmental organizations (NGOs), entrepreneurs and school children alike will be able to tap into the World Bank's databases via a new website, data.worldbank.org.
Experts say the Bank's open data initiative has the potential to stimulate more evidence-based policymaking in developing countries by bringing more researchers and innovative analysis into the development process. The move is also likely to stimulate demand for data and increase countries' capacity to produce it, they say.
And, for the first time, data will be available in languages other than English, with an initial 330 indicators translated into French, Spanish and Arabic.
“It’s important to make the data and knowledge of the World Bank available to everyone," World Bank President Robert B. Zoellick said. "Statistics tell the story of people in developing and emerging countries and can play an important part in helping to overcome poverty.”
Quite exciting, and some costs savings for institutions which have subscribed to these data.
PALS 2006
Question
I had to do some deep reading to remember why the frequencies in PALS 2006 are so different between the full data set (72,167 cases) and the user guide (17,423 cases), and once again thrilled to the charming explanation of the differences between the original documented record layout and the SAS and SPSS syntax files 8-)
However, now I have a new query. On page 322 of the User guide, we find the following frequencies for variable TENURP:
-5 Not stated 0 0
1 BAND HOUSING 79 13,329
2 NOT APPLICABLE 4,573 1,184,265
3 OWNED BY MEMBER OF HHLD 12,771 2,965,102
4 RENTED 0 0
====== =========
17,423 4,162,696
Hmmmmmmmmmm - no renters anywhere in Canada! And about 26.2% of us live in not applicable housing...the mind boggles, but at least in the midst of Easter, one can think of a few explanations, although I would be sorry to see any of them in a codebook.
Unfortunately, the SAS and SPSS syntax files also contain this error, so the odesi, SDA, and Equinox implementations of this file are all wrong.
Could we get confirmation from the relevant department that value 2 should be 'rented', and 4 'not applicable'?
Thanks in advance!
Answer
Our contacts have looked into your question with a methodologist and there is an error in the PALS 2006 user guide for the variable TENURP. For your reference, the explanation I received from our contacts follows.
"It turns out that there was a system error in the dictionary database when switching from RDC to PUMF resulting in discrepancies in how categories were labeled.
The original PUMF statistics are:
79 = "Band Housing"
4,573 = "Not Applicable"
12,771 = "Owned"
0 = "Rent"
The correct PUMF statistics are:
79 = "Not Applicable"
4,573 = "Band Housing and Rented" (i.e., Rented is a not a separate category in PUMF)
12,771 = "Owned"
The "Not stated" and "Rented" should have been removed from PUMF hence why there are 0 counts for both. The corresponding weights are the same."
I have asked our contacts for a corrected version of the user guide and of any other files affected by this error. We will make them available through the DLI FTP and website as soon as we receive them.
Thank you once for bringing this to our attention.
I had to do some deep reading to remember why the frequencies in PALS 2006 are so different between the full data set (72,167 cases) and the user guide (17,423 cases), and once again thrilled to the charming explanation of the differences between the original documented record layout and the SAS and SPSS syntax files 8-)
However, now I have a new query. On page 322 of the User guide, we find the following frequencies for variable TENURP:
-5 Not stated 0 0
1 BAND HOUSING 79 13,329
2 NOT APPLICABLE 4,573 1,184,265
3 OWNED BY MEMBER OF HHLD 12,771 2,965,102
4 RENTED 0 0
====== =========
17,423 4,162,696
Hmmmmmmmmmm - no renters anywhere in Canada! And about 26.2% of us live in not applicable housing...the mind boggles, but at least in the midst of Easter, one can think of a few explanations, although I would be sorry to see any of them in a codebook.
Unfortunately, the SAS and SPSS syntax files also contain this error, so the odesi, SDA, and Equinox implementations of this file are all wrong.
Could we get confirmation from the relevant department that value 2 should be 'rented', and 4 'not applicable'?
Thanks in advance!
Answer
Our contacts have looked into your question with a methodologist and there is an error in the PALS 2006 user guide for the variable TENURP. For your reference, the explanation I received from our contacts follows.
"It turns out that there was a system error in the dictionary database when switching from RDC to PUMF resulting in discrepancies in how categories were labeled.
The original PUMF statistics are:
79 = "Band Housing"
4,573 = "Not Applicable"
12,771 = "Owned"
0 = "Rent"
The correct PUMF statistics are:
79 = "Not Applicable"
4,573 = "Band Housing and Rented" (i.e., Rented is a not a separate category in PUMF)
12,771 = "Owned"
The "Not stated" and "Rented" should have been removed from PUMF hence why there are 0 counts for both. The corresponding weights are the same."
I have asked our contacts for a corrected version of the user guide and of any other files affected by this error. We will make them available through the DLI FTP and website as soon as we receive them.
Thank you once for bringing this to our attention.
Beyond 20/20 & Windows 7
Question
We haven't been able to install Beyond 20/20 on a laptop running Windows 7. We have tried compatibility modes but no luck so far. Any solutions would be greatly appreciated.
Answer
Our contact for Beyond 20/20 here at StatCan has confirmed that Beyond 20/20 is compatible with Windows 7. He is aware of an installation issue however that has to do with difference between the Beyond 20/20 installers for 32 bit and 64 bit operating systems. His description of this issue and suggestion follow:
"There are 2 different installers for B2020 currently available on our website, one for 32 bit Operating Systems and one for 64 bit Operating Systems. It is possible that the user has tried to install the 32 bit version on the 64 bit Operating System so I would look to that as the first possible solution.
I believe both install packages are available on the DLI FTP site (note: we will make sure that both install packages are on the DLI FTP site) but I am providing the link to the 64 bit below. Please have your client try the .zip file (unzip the package and run 'setup.exe'). If the problem still occurs we would probably need a little more detail as to the error message being generated so that we can pass that along to the company.
64 bit installer (zip)
http://www2.beyond2020.com/SC/probrowser.zip"
I hope that this resolves the issue you are experiencing. Please let us know if this works.
We haven't been able to install Beyond 20/20 on a laptop running Windows 7. We have tried compatibility modes but no luck so far. Any solutions would be greatly appreciated.
Answer
Our contact for Beyond 20/20 here at StatCan has confirmed that Beyond 20/20 is compatible with Windows 7. He is aware of an installation issue however that has to do with difference between the Beyond 20/20 installers for 32 bit and 64 bit operating systems. His description of this issue and suggestion follow:
"There are 2 different installers for B2020 currently available on our website, one for 32 bit Operating Systems and one for 64 bit Operating Systems. It is possible that the user has tried to install the 32 bit version on the 64 bit Operating System so I would look to that as the first possible solution.
I believe both install packages are available on the DLI FTP site (note: we will make sure that both install packages are on the DLI FTP site) but I am providing the link to the 64 bit below. Please have your client try the .zip file (unzip the package and run 'setup.exe'). If the problem still occurs we would probably need a little more detail as to the error message being generated so that we can pass that along to the company.
64 bit installer (zip)
http://www2.beyond2020.com/SC/probrowser.zip"
I hope that this resolves the issue you are experiencing. Please let us know if this works.
A Portrait of Mixed Ethnocultural Couples
A portrait of mixed ethnocultural couples which examines the socio-demographic characteristics of mixed union couples in Canada is being released today.
As Canada’s population continues to become ethnoculturally diverse, there is greater opportunity for individuals to form conjugal relationships with someone from a different ethnocultural background. In this study, a mixed union, either marital or common-law, is based on one of two criteria: either one member of a couple belongs to a visible minority group and the other does not; or the couple belongs to different visible minority groups. Using data primarily from the 2006 Census of Population, this study examines the socio-demographic characteristics of mixed union couples in Canada. Studying mixed unions is important not only because these relationships reflect another aspect of the diversity of families today, but also for their implications in terms of social inclusion and identification with one or more visible minority groups, particularly for subsequent generations.
Enclosed is the link to the Spotlight on the Census web page http://www12.statcan.ca/census-recensement/index-eng.cfm
As Canada’s population continues to become ethnoculturally diverse, there is greater opportunity for individuals to form conjugal relationships with someone from a different ethnocultural background. In this study, a mixed union, either marital or common-law, is based on one of two criteria: either one member of a couple belongs to a visible minority group and the other does not; or the couple belongs to different visible minority groups. Using data primarily from the 2006 Census of Population, this study examines the socio-demographic characteristics of mixed union couples in Canada. Studying mixed unions is important not only because these relationships reflect another aspect of the diversity of families today, but also for their implications in terms of social inclusion and identification with one or more visible minority groups, particularly for subsequent generations.
Enclosed is the link to the Spotlight on the Census web page http://www12.statcan.ca/census-recensement/index-eng.cfm
Voter Turnout By Gender In Canadian Federal Elections
Question
I'm looking for statistics on voter turnout by gender in Canadian federal elections since 1965.
I've looked at the Elections Canada site, the Canadian Election Study (CES) site. I found some data in the collection of studies from the Royal Commission on Electoral Reform and Party Financing /Commission Royale Sur la Réforme Electorale et le Financement des Parties (1989).
I'm just wondering if there are more resources out there.
Your suggestions would be very much appreciated.
Answer
Statistics Canada doesn't collect these data but you may wish to contact Elections Canada to see if they can provide this information. StatCan disseminates little election-related statistics
(ex. summary tables:http://www40.statcan.gc.ca/l01/ind01/l3_75_79-eng.htm?hili_govt09 and Historical Statistics of Canada: http://www.statcan.gc.ca/pub/11-516-x/sectiony/4057759-eng.htm#2);
Our recent statistics on this topic are from Elections Canada.
I'm looking for statistics on voter turnout by gender in Canadian federal elections since 1965.
I've looked at the Elections Canada site, the Canadian Election Study (CES) site. I found some data in the collection of studies from the Royal Commission on Electoral Reform and Party Financing /Commission Royale Sur la Réforme Electorale et le Financement des Parties (1989).
I'm just wondering if there are more resources out there.
Your suggestions would be very much appreciated.
Answer
Statistics Canada doesn't collect these data but you may wish to contact Elections Canada to see if they can provide this information. StatCan disseminates little election-related statistics
(ex. summary tables:http://www40.statcan.gc.ca/l01/ind01/l3_75_79-eng.htm?hili_govt09 and Historical Statistics of Canada: http://www.statcan.gc.ca/pub/11-516-x/sectiony/4057759-eng.htm#2);
Our recent statistics on this topic are from Elections Canada.
Rural and Urban Spaces in CMAs
Question
Students at UBC are trying to determine the area in square kilometers of the rural and urban parts of 10 census metropolitan areas for all censuses 1986-2006. All we can find in the published tables and in Geosuite is the total land area.
According to the census dictionary the rural areas of CMAs are designated the rural fringe. Is it at all possible to find the land area for the rural fringe as well as for the urban core and urban fringe?
Thanks for helping to clarify this.
Answer
I checked with our geography consultants and they indicated that this would be very difficult to do but provided provided following steps if the students wish to proceed:
"First, you would have to find the following spatial data layers. 1986, urban core, urban fringe, rural fringe (you would have to subtract urban from total CMA for this calculation); then you would have to find a water layer which was compatible with the 1986 spatial data layers in order to calculate the land area for the areas in question.
You would have to repeat this operation for 1991, 1996, 2001 and 2006 (and you would not be comparing the same area necessarily – due to changes in boundaries, scale and projection from one census to the next).
She also suggested the students could try breaking it down by CSDs. "
Students at UBC are trying to determine the area in square kilometers of the rural and urban parts of 10 census metropolitan areas for all censuses 1986-2006. All we can find in the published tables and in Geosuite is the total land area.
According to the census dictionary the rural areas of CMAs are designated the rural fringe. Is it at all possible to find the land area for the rural fringe as well as for the urban core and urban fringe?
Thanks for helping to clarify this.
Answer
I checked with our geography consultants and they indicated that this would be very difficult to do but provided provided following steps if the students wish to proceed:
"First, you would have to find the following spatial data layers. 1986, urban core, urban fringe, rural fringe (you would have to subtract urban from total CMA for this calculation); then you would have to find a water layer which was compatible with the 1986 spatial data layers in order to calculate the land area for the areas in question.
You would have to repeat this operation for 1991, 1996, 2001 and 2006 (and you would not be comparing the same area necessarily – due to changes in boundaries, scale and projection from one census to the next).
She also suggested the students could try breaking it down by CSDs. "
Historical Census Data, Churchill, MB
Question
I have a researcher looking for Census data for the town of Churchill, Manitoba between 1901 and 1996. I can access the complete Census from 1901 and 1961-1996 through the FTP, but I was unsure if Census data were available between 1901 and 1961.
They are only, as far as I know, in print publications. I have pdf files of the tables of contents of the print publications from of all censuses between 1901 and 1961 linked from: http://www.chass.utoronto.ca/datalib/major/censusag.htm#1926
(It's the 'Content of tables' link in each respective census'. I find them useful, so that I can determine which of several volumes to look in, before actually heading out to where the print vols. are. Look for any
tables for 'cities, towns, and villages'..........those should include Churchill.
Answer
The StatCan library has the census books, the admin reports and the commissioner manuals for those years. The quinquennial censuses of 06, 16, 26, etc. are loaded with Manitoba data.
Additional Information
If needed, we have a fairly thorough collection of census materials in paper at the Elizabeth Dafoe Library, University of Manitoba. Our Government Documents stacks are open to the public to use within the Library. Not all our older Census materials are catalogued, but they are all in one location, so it is pretty easy to scan through specific Census years.
I have a researcher looking for Census data for the town of Churchill, Manitoba between 1901 and 1996. I can access the complete Census from 1901 and 1961-1996 through the FTP, but I was unsure if Census data were available between 1901 and 1961.
They are only, as far as I know, in print publications. I have pdf files of the tables of contents of the print publications from of all censuses between 1901 and 1961 linked from: http://www.chass.utoronto.ca/datalib/major/censusag.htm#1926
(It's the 'Content of tables' link in each respective census'. I find them useful, so that I can determine which of several volumes to look in, before actually heading out to where the print vols. are. Look for any
tables for 'cities, towns, and villages'..........those should include Churchill.
Answer
The StatCan library has the census books, the admin reports and the commissioner manuals for those years. The quinquennial censuses of 06, 16, 26, etc. are loaded with Manitoba data.
Additional Information
If needed, we have a fairly thorough collection of census materials in paper at the Elizabeth Dafoe Library, University of Manitoba. Our Government Documents stacks are open to the public to use within the Library. Not all our older Census materials are catalogued, but they are all in one location, so it is pretty easy to scan through specific Census years.
Mental Health Stats (BC)
Question
I received the following request for statistics/data today while I was away at a Conference. I am not sure how to find all the requested bits and pieces. The Canadian Community Health Survey, cycle 1.2, 2002 (Mental Health) has some data, but does not offer all the data requested.
"I am doing research on mental illness and parenting. Do you have any data/statistics on the following:
1) Number/percentage of people with Schizophrenia, Bipolar, or major depression in B.C. from 2005 to 2010 if available?
2) Hospitalizations in B.C. with Schizophrenia, Bipolar, or Major depression who have children from 2005-2010 if available?
3) Number of grandparents looking after grandchildren in B.C. due to their daughter/son illness (2005-2010)
4) Parental illness and loss of custody in B.C. 2005-2010
5) Parents with mental illness whose children are apprehended or in the care of the Ministry of Children and families Development.
Any information would be appreciated"
Answer
For question 1 ("Number/percentage of people with Schizophrenia, Bipolar, or major depression in B.C. from 2005 to 2010 if available?"), your client may be interested in the provincial-level CANSIM tables on mood disorders (an aggregate) that are available through StatCan's Health Indicators publication
(http://www.statcan.gc.ca/pub/82-221-x/2009001/tblstructure/1hs/1hc/hc1mdx-eng.htm).
The data in these tables are from CCHS and cover 2003, 2005, 2007, 2008. The CCHS PUMFs may also be of interest to your client. 2007, 2008 are the latest years for which data are available from this survey. The "How Healthy Are Canadians? Annual Report 2004" publication
(http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=82-003-S2004000)
focused on mental health and may also be of interest. The National Population Health Survey includes a mental health module but the most recent file is for 2006/2007. NPSH-related products can be accessed via the Links to related products section on the left side bar of
http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=3225?=en&db=imdb&adm=8&dis=2.
The survey is also available in the RDCs and data may be available on a custom basis.
For question 2 ("Hospitalizations in B.C. with Schizophrenia, Bipolar, or Major depression who have children from 2005-2010 if available?") I would recommend looking into the data available from CIHI. According to the Definitions, data sources and methods section of the StatCan website
(http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=3204?=en&db=imdb&adm=8&dis=2):
"As of the 1994/95 data year, the Canadian Institute for Health Information (CIHI) assumed the data collection and dissemination responsibilities for Mental Health Statistics. (...) The annual information presently collected by this program provides data on separation (discharges) from psychiatric hospitals and general hospitals for inpatients being treated for mental disorders." Your provincial health department and mental health-related associations may also disseminate data on these topics.
For question 3, 4 and 5, your client may wish to look into the custody-related data available in the National Longitudinal Survey of Children and Youth
(NLSCY; http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4450?=en&db=imdb&adm=8&dis=2).
We have NLSCY synthetic files in the DLI collection (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/nlscy-elnej-eng.htm) that can be used to prepare for a visit to an RDC or to request data through remote job submission (the data in these synthetic files are "synthetic/dummy" data that can't be used for analytical purposes). NLSCY data on this topic may also be available for a fee on a custom basis. If this is of interest to your client, I would be pleased to refer you to an Account-Executive in our Vancouver office who could confirm what data could be disseminated as a custom table and at what cost. You may also wish to look into what data that might be available from provincial ministries.
I hope that these suggestions are helpful. Please don't hesitate to let me know if you have any other questions.
I received the following request for statistics/data today while I was away at a Conference. I am not sure how to find all the requested bits and pieces. The Canadian Community Health Survey, cycle 1.2, 2002 (Mental Health) has some data, but does not offer all the data requested.
"I am doing research on mental illness and parenting. Do you have any data/statistics on the following:
1) Number/percentage of people with Schizophrenia, Bipolar, or major depression in B.C. from 2005 to 2010 if available?
2) Hospitalizations in B.C. with Schizophrenia, Bipolar, or Major depression who have children from 2005-2010 if available?
3) Number of grandparents looking after grandchildren in B.C. due to their daughter/son illness (2005-2010)
4) Parental illness and loss of custody in B.C. 2005-2010
5) Parents with mental illness whose children are apprehended or in the care of the Ministry of Children and families Development.
Any information would be appreciated"
Answer
For question 1 ("Number/percentage of people with Schizophrenia, Bipolar, or major depression in B.C. from 2005 to 2010 if available?"), your client may be interested in the provincial-level CANSIM tables on mood disorders (an aggregate) that are available through StatCan's Health Indicators publication
(http://www.statcan.gc.ca/pub/82-221-x/2009001/tblstructure/1hs/1hc/hc1mdx-eng.htm).
The data in these tables are from CCHS and cover 2003, 2005, 2007, 2008. The CCHS PUMFs may also be of interest to your client. 2007, 2008 are the latest years for which data are available from this survey. The "How Healthy Are Canadians? Annual Report 2004" publication
(http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=82-003-S2004000)
focused on mental health and may also be of interest. The National Population Health Survey includes a mental health module but the most recent file is for 2006/2007. NPSH-related products can be accessed via the Links to related products section on the left side bar of
http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=3225?=en&db=imdb&adm=8&dis=2.
The survey is also available in the RDCs and data may be available on a custom basis.
For question 2 ("Hospitalizations in B.C. with Schizophrenia, Bipolar, or Major depression who have children from 2005-2010 if available?") I would recommend looking into the data available from CIHI. According to the Definitions, data sources and methods section of the StatCan website
(http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=3204?=en&db=imdb&adm=8&dis=2):
"As of the 1994/95 data year, the Canadian Institute for Health Information (CIHI) assumed the data collection and dissemination responsibilities for Mental Health Statistics. (...) The annual information presently collected by this program provides data on separation (discharges) from psychiatric hospitals and general hospitals for inpatients being treated for mental disorders." Your provincial health department and mental health-related associations may also disseminate data on these topics.
For question 3, 4 and 5, your client may wish to look into the custody-related data available in the National Longitudinal Survey of Children and Youth
(NLSCY; http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4450?=en&db=imdb&adm=8&dis=2).
We have NLSCY synthetic files in the DLI collection (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/nlscy-elnej-eng.htm) that can be used to prepare for a visit to an RDC or to request data through remote job submission (the data in these synthetic files are "synthetic/dummy" data that can't be used for analytical purposes). NLSCY data on this topic may also be available for a fee on a custom basis. If this is of interest to your client, I would be pleased to refer you to an Account-Executive in our Vancouver office who could confirm what data could be disseminated as a custom table and at what cost. You may also wish to look into what data that might be available from provincial ministries.
I hope that these suggestions are helpful. Please don't hesitate to let me know if you have any other questions.
Subscribe to:
Posts (Atom)