Question
Does anyone know where I could find number of deaths by age category for CMA geography? I've found death rates by cause of death by province and health region, and death by age for the provinces, already. Would this be a custom tabulation?
Answer
Annual demographic statistics - which you should have received on a cd-rom via the DSP. In the 2003 edition, files ascm9601.xls and ascm0103.xls. The 2003 edition contains estimates for 1996-2001, and 2001-2003. The 1998 edition contains 1991-1996.
Friday, March 4, 2005
Thursday, March 3, 2005
Farm Operators
Question
I have a user who wants to find age breakdown of farm operators at the **sub-provincial** level. It looks as if this might have been compiled in subsequent years through the linked files of Census of Agriculture and Census of Population. Though we can get a breakdown for 1996 and 2001, we cannot find subprovincial age groups of farm operators in the Census of Agriculture for 1991. Can anyone help?
Answer
I've found the following information for your client. Table 4 (Farm operators by age and number of farms...) was not produced at the sub-provincial level in 1991. The information however is available on a cost-recovery basis. The basic price is $125 + ($1.25/geography * number of tables requested).
I have a user who wants to find age breakdown of farm operators at the **sub-provincial** level. It looks as if this might have been compiled in subsequent years through the linked files of Census of Agriculture and Census of Population. Though we can get a breakdown for 1996 and 2001, we cannot find subprovincial age groups of farm operators in the Census of Agriculture for 1991. Can anyone help?
Answer
I've found the following information for your client. Table 4 (Farm operators by age and number of farms...) was not produced at the sub-provincial level in 1991. The information however is available on a cost-recovery basis. The basic price is $125 + ($1.25/geography * number of tables requested).
Working from home involuntarily
Question
I have a student looking for data on the number of people who are being forced by their employers to work from home. The Survey of Workplace Arrangements 1995 had a question regarding this, but unfortunately, it has been discontinued. Does anyone know of another survey or source that would provide this information? I've done a cursory check of the LFS and WES and neither appears to cover the reasons people work from home.
Answer
General Social Survey of Canada, 1998 - Cycle 12: Time use main file - variable F32 (main reason do some of work at home) has a response that it "is a condition of the job".
I have a student looking for data on the number of people who are being forced by their employers to work from home. The Survey of Workplace Arrangements 1995 had a question regarding this, but unfortunately, it has been discontinued. Does anyone know of another survey or source that would provide this information? I've done a cursory check of the LFS and WES and neither appears to cover the reasons people work from home.
Answer
General Social Survey of Canada, 1998 - Cycle 12: Time use main file - variable F32 (main reason do some of work at home) has a response that it "is a condition of the job".
Canadian professionals moving from and returning to Canada
Question
I've got a student who is looking for data on the number of Canadians professionals who move back to Canada after moving away. He would be interested in figures for Canadians who have moved anywhere in the world and also Canadians who have moved to the U.S.
Another thing he is interested in is how many exchange students (all of them combined -- at the high school level and at the post secondary level) go out of Canada to anywhere in the world on any given year.
For the first, so far the only thing I have found is a Statistics Canada study entitled _South of the border: graduates from the class of '95 who moved to the United States_ (81-587-XPB). According to this, 18 percent of the graduates had moved back between the summer of 1997 and March 1999. I also found a couple of articles describing the results of this study.
The student may use the 2001 Census PUMF to determine how many professionals moved back to Canada who were Canadian born citizens, but that doesn't really give him exactly what he is looking for, as he will be making assumptions about these people (as to when and why they moved in the first place).
For the second request, the only thing I have found so far is an HRDC report
(http://www11.hrdc-drhc.gc.ca/pls/edd/SPAH194_06_02.lhtml),
in which there is the following statement:
"For example, during the 1997/98 academic year, institutions reported 5,058 Canadian students studying abroad as part of an exchange. However, even this level of participation means that less than one percent of Canadian university students (full-time graduate and undergraduate students) were studying abroad in an exchange program during the 1997/98 academic year."
A note clarifies that "Knight notes that institutions are not systematically keeping this data, so this is an estimate."
Can anyone help?
Answer
I had a similar question from a patron on the number of Canadians living abroad by foreign country, and I had to go the Canadian Consul for this information. They have a database with all this information and may be able to help you.
I've got a student who is looking for data on the number of Canadians professionals who move back to Canada after moving away. He would be interested in figures for Canadians who have moved anywhere in the world and also Canadians who have moved to the U.S.
Another thing he is interested in is how many exchange students (all of them combined -- at the high school level and at the post secondary level) go out of Canada to anywhere in the world on any given year.
For the first, so far the only thing I have found is a Statistics Canada study entitled _South of the border: graduates from the class of '95 who moved to the United States_ (81-587-XPB). According to this, 18 percent of the graduates had moved back between the summer of 1997 and March 1999. I also found a couple of articles describing the results of this study.
The student may use the 2001 Census PUMF to determine how many professionals moved back to Canada who were Canadian born citizens, but that doesn't really give him exactly what he is looking for, as he will be making assumptions about these people (as to when and why they moved in the first place).
For the second request, the only thing I have found so far is an HRDC report
(http://www11.hrdc-drhc.gc.ca/pls/edd/SPAH194_06_02.lhtml),
in which there is the following statement:
"For example, during the 1997/98 academic year, institutions reported 5,058 Canadian students studying abroad as part of an exchange. However, even this level of participation means that less than one percent of Canadian university students (full-time graduate and undergraduate students) were studying abroad in an exchange program during the 1997/98 academic year."
A note clarifies that "Knight notes that institutions are not systematically keeping this data, so this is an estimate."
Can anyone help?
Answer
I had a similar question from a patron on the number of Canadians living abroad by foreign country, and I had to go the Canadian Consul for this information. They have a database with all this information and may be able to help you.
Friday, February 25, 2005
Trade by Industry
Question
A UBC doctoral student is doing research on industries and wants summary information on Canadian bilateral trade with different countries by industry classification, not by the usual commodity classification.
The Statistics Canada-supplied data on Strategis' Trade Data Online has this for recent years using the NAICS classification and back to 1990 with the SIC classification. She needs further statistics for the period 1980-1989 to match some other work she is doing. She recognizes that she may have to do some manual work of matching commodities with industries. A note on the Trade Data Online site notes that the matching represents "a crude estimation of industry trade and is susceptible to errors." It also states the following:
"In an effort to quantify industry trade, Statistics Canada associates the exported commodity's Harmonized System (HS) code with a NAICS code using internal concordances."
CANSIM and every other source I have checked present import and export data by commodity, not by industry.
Since the data are originally from Statistics Canada I volunteered to put the question to the source. Is there anywhere to find this industry-related trade data, or to get access to the internal concordances noted above?
Answer
Trade data is available from 1980 to 1989 using the SIC classification system. However, it is only available as a custom request.
The US versions of the NAICS-HS concordances, for exports and for imports, can be downloaded from:
http://www.census.gov/foreign-trade/reference/codes/index.html#concordance
A UBC doctoral student is doing research on industries and wants summary information on Canadian bilateral trade with different countries by industry classification, not by the usual commodity classification.
The Statistics Canada-supplied data on Strategis' Trade Data Online has this for recent years using the NAICS classification and back to 1990 with the SIC classification. She needs further statistics for the period 1980-1989 to match some other work she is doing. She recognizes that she may have to do some manual work of matching commodities with industries. A note on the Trade Data Online site notes that the matching represents "a crude estimation of industry trade and is susceptible to errors." It also states the following:
"In an effort to quantify industry trade, Statistics Canada associates the exported commodity's Harmonized System (HS) code with a NAICS code using internal concordances."
CANSIM and every other source I have checked present import and export data by commodity, not by industry.
Since the data are originally from Statistics Canada I volunteered to put the question to the source. Is there anywhere to find this industry-related trade data, or to get access to the internal concordances noted above?
Answer
Trade data is available from 1980 to 1989 using the SIC classification system. However, it is only available as a custom request.
The US versions of the NAICS-HS concordances, for exports and for imports, can be downloaded from:
http://www.census.gov/foreign-trade/reference/codes/index.html#concordance
Wednesday, February 16, 2005
Using Beyond 20/20 to Convert to SPSS
Question
I'm looking for highest level of education by CSD for Newfoundland. It needs to be in raw data format (It's for an SPSS based stats course). Is this data, from either from 1996 or 2001 census, available as a PUMF? I can only find B2020 tables.
Answers
1) Your initial question sounded like you want CSD to be the unit of analysis: "I'm looking for highest level of education by CSD for Newfoundland." If this is the case, you were very close to solving your own question using the 2001 Census table, 95F0491XCB01002.IVT.
Here is an example of what a raw data format of this table for just CSD's from Newfoundland would look like using only the
first eight CSD's and first four Census characteristics:
Portugal Cove South (1001105) T 00000 60 20 35 0
Biscay Bay (1001109) T 00000 0 0 0 0
Trepassey (1001113) T 00000 135 25105 0
St. Shott's (1001120) T 00000 40 0 35 0
Division No. 1, Subd. U (1001124) SUN 190 40145 0
Cape Broyle (1001126) T 00000 70 60 10 0
Renews (1001131) T 00000 80 65 20 10
Fermeuse (1001136) T 00000 50 10 25 15
The columns of numbers represent, respectively, Total population 15 to 24 years by school attendance, Not attending school,
Attending school full time, and Attending school part time. These are just the first four Census characteristics of 42 contained in 95F0491XCB01002.IVT.
How to get this into SPSS quickly? Use B2020 to create the data structure by reorganizing the table so that Geography is
in the rows, Census characteristics are in the columns, and you've selected just CSD's in Newfoundland. Then do a File / Save As and output the data using the Excel Worksheet format.
Open this file in Excel and remove the first four rows in the spreadsheet, which contain stub headings from the B2020 table,
and re-save this file.
Next, start an SPSS session and use File / Open / Data and select Excel as the file type to open. In the "Opening Excel Data Source" dialogue box, uncheck the box for "Read variable names from the first row of data."
2) If I understand what you are looking for correctly, you are looking for the ascii version of table 95f0418xcb01006.ivt, yes?
That's the BST for highest degree, certificate or diploma, by age groups and sex, for census subdivisions.
You will find it in ascii format on the DLI ftp site, in
census/2001/Ascii/Topic-Based-Tabulations/education-in-canada-attendance-ascii/
There are no SPSS commands, but they could be created from the accompanying documentation. You will need to write a data list statement for a number of records per case (ie CSD).
The alternative to using the ascii file would be to use the Beyond 20/20 file to structure the rows the way you want them, then write the file out as a .csv or .xls file, and read that in to SPSS. It would be rather easier than working with the ascii file, at least while we can still read .ivt files.
I'm looking for highest level of education by CSD for Newfoundland. It needs to be in raw data format (It's for an SPSS based stats course). Is this data, from either from 1996 or 2001 census, available as a PUMF? I can only find B2020 tables.
Answers
1) Your initial question sounded like you want CSD to be the unit of analysis: "I'm looking for highest level of education by CSD for Newfoundland." If this is the case, you were very close to solving your own question using the 2001 Census table, 95F0491XCB01002.IVT.
Here is an example of what a raw data format of this table for just CSD's from Newfoundland would look like using only the
first eight CSD's and first four Census characteristics:
Portugal Cove South (1001105) T 00000 60 20 35 0
Biscay Bay (1001109) T 00000 0 0 0 0
Trepassey (1001113) T 00000 135 25105 0
St. Shott's (1001120) T 00000 40 0 35 0
Division No. 1, Subd. U (1001124) SUN 190 40145 0
Cape Broyle (1001126) T 00000 70 60 10 0
Renews (1001131) T 00000 80 65 20 10
Fermeuse (1001136) T 00000 50 10 25 15
The columns of numbers represent, respectively, Total population 15 to 24 years by school attendance, Not attending school,
Attending school full time, and Attending school part time. These are just the first four Census characteristics of 42 contained in 95F0491XCB01002.IVT.
How to get this into SPSS quickly? Use B2020 to create the data structure by reorganizing the table so that Geography is
in the rows, Census characteristics are in the columns, and you've selected just CSD's in Newfoundland. Then do a File / Save As and output the data using the Excel Worksheet format.
Open this file in Excel and remove the first four rows in the spreadsheet, which contain stub headings from the B2020 table,
and re-save this file.
Next, start an SPSS session and use File / Open / Data and select Excel as the file type to open. In the "Opening Excel Data Source" dialogue box, uncheck the box for "Read variable names from the first row of data."
2) If I understand what you are looking for correctly, you are looking for the ascii version of table 95f0418xcb01006.ivt, yes?
That's the BST for highest degree, certificate or diploma, by age groups and sex, for census subdivisions.
You will find it in ascii format on the DLI ftp site, in
census/2001/Ascii/Topic-Based-Tabulations/education-in-canada-attendance-ascii/
There are no SPSS commands, but they could be created from the accompanying documentation. You will need to write a data list statement for a number of records per case (ie CSD).
The alternative to using the ascii file would be to use the Beyond 20/20 file to structure the rows the way you want them, then write the file out as a .csv or .xls file, and read that in to SPSS. It would be rather easier than working with the ascii file, at least while we can still read .ivt files.
Market Trends in Deli and Processed Meat Industry
Question
I have a student looking for information on market trends in the deli and processed meat industry but I am coming up relatively empty handed. Any suggestions?
Answer
There are a couple of CANSIM tables that come close. CANSIM Table 080-0010 - Retail commodity survey, quarterly (Dollars) is in E-STAT and provides quarterly figures from 1998 to 2003. The geographic coverage is only for all of Canada, though. This table includes an entry for "Deli (excluding cheese), salad bars and prepared foods for take-out."
Table 80-0013 provides annual sales instead of quarterly from 1999-2001 using the same retail commodity classification
as 80-0010.
The NAICS code for delicatessens is 44521. And while I could find three more related tables, they didn't provide stats at this level of detail provided in 80-0010. Table 80-0014, however, groups 44512, 44521, 44522, 44523, 44529 together into a Convenience and Specialty Food Stores category. This table provides monthly sales data from January 1991 to April 2004 (in E-STAT). The geographic coverage includes provinces.
CANSIM Table 080-0014 - Retail trade, sales by trade group based on the North American Industry Classification System (NAICS), monthly (147 series).
Table 080-0015 provides the coverage of 80-0014 but quarterly rather than monthly.
Another possibility is Table 80-0011 - Annual retail store survey, financial estimates by store type and trade group based on the North American Industry Classification System (NAICS), which covers 1999 to 2001 (in E-STAT) again using the same NAICS groupings as in 080-0014.
I didn't have any luck with Strategis.
PMB (Print Measurement Bureau) is a good source but when I searched for deli or delicatessen, I only found entries for cheese and not meats. The two 'cheese' entries were under the Groceries Section where a number of chains were identified. There are also entries for types of meat consumed.
I have a student looking for information on market trends in the deli and processed meat industry but I am coming up relatively empty handed. Any suggestions?
Answer
There are a couple of CANSIM tables that come close. CANSIM Table 080-0010 - Retail commodity survey, quarterly (Dollars) is in E-STAT and provides quarterly figures from 1998 to 2003. The geographic coverage is only for all of Canada, though. This table includes an entry for "Deli (excluding cheese), salad bars and prepared foods for take-out."
Table 80-0013 provides annual sales instead of quarterly from 1999-2001 using the same retail commodity classification
as 80-0010.
The NAICS code for delicatessens is 44521. And while I could find three more related tables, they didn't provide stats at this level of detail provided in 80-0010. Table 80-0014, however, groups 44512, 44521, 44522, 44523, 44529 together into a Convenience and Specialty Food Stores category. This table provides monthly sales data from January 1991 to April 2004 (in E-STAT). The geographic coverage includes provinces.
CANSIM Table 080-0014 - Retail trade, sales by trade group based on the North American Industry Classification System (NAICS), monthly (147 series).
Table 080-0015 provides the coverage of 80-0014 but quarterly rather than monthly.
Another possibility is Table 80-0011 - Annual retail store survey, financial estimates by store type and trade group based on the North American Industry Classification System (NAICS), which covers 1999 to 2001 (in E-STAT) again using the same NAICS groupings as in 080-0014.
I didn't have any luck with Strategis.
PMB (Print Measurement Bureau) is a good source but when I searched for deli or delicatessen, I only found entries for cheese and not meats. The two 'cheese' entries were under the Groceries Section where a number of chains were identified. There are also entries for types of meat consumed.
Subscribe to:
Posts (Atom)