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.
Thursday, September 16, 2010
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.
Subscribe to:
Posts (Atom)