Question:
I have a graduate student who would like access to the Input-Output Model Simulations (National Model) – 15F0004X (https://www150.statcan.gc.ca/n1/en/catalogue/15F0004X). I do not see this particular product on the FTP site or odesi, so I am wondering if this is something that can be obtained via the DLI. If not, how might the student go about getting it?
Answer:
Unfortunately on our end, this is only available via custom tabulation. Please see below for the response from subject matter:
“The Input-Output model is not available for distribution. We offer input-output modeling service on a cost recovery basis.”
If the student happens to be interested in going this route, please let me know and I will put you in touch with them directly.
Showing posts with label Business and Consumer and Property Services. Show all posts
Showing posts with label Business and Consumer and Property Services. Show all posts
Thursday, June 6, 2019
Monday, March 18, 2019
Number of Patents Issued by City
Question:
I have a student who is looking to find out what the patent density of Canadian cities is. Basically, he wants to know how many patents are issued within a city for the time period 2006 – 2016 (if possible).
Answer:
Apparently, the European Patent Office collects international patent data and they have a database that was used by the University of Aalborg in Denmark to create patent data visualization.
The tricky thing about analyzing Canadian patent data is that a substantial number of Canadian inventors file first in the U.S. For example, in 2017, Canadian inventors filed 4,053 patent applications in Canada and 19,861 abroad, mostly in the U.S. So any analysis should probably include both US and CA patent applications filed by CA inventors.
For Canadian city-level raw data, the best source is probably the European Patent Office’s PATSTAT database. PATSTAT contains bibliographical data relating to more than 100 million patent documents from leading industrialised and developing countries. It also includes the legal status data from more than 40 patent authorities contained in the EPO worldwide legal status database (INPADOC). It is used by many organizations and academics for patent analysis. Knowledge of SQL is required in order to retrieve data. Training materials are provided. PATSTAT is not free but it does offer a free one-month trial.
Using PATSTAT data, a team at the University of Aalborg in Denmark has created Global Patent Explorer, a patent data analysis and visualization tool that allows you to drill-down to the city level for numerous countries including Canada.
The CIPO publishes province-level data in its annual reports. See 2017-18, for example.
The WIPO’s IP country profile database is useful but does not have province- or city-level data.
The USPTO publishes a number of statistical reports including geographic origin (country, state and US metropolitan area). See https://www.uspto.gov/web/offices/ac/ido/oeip/taf/reports.htm . Unfortunately, these reports tend to be several years behind and only US metropolitan areas are available.
This may also be of use: http://www.ic.gc.ca/eic/site/cipointernet-internetopic.nsf/eng/h_wr01933.html
I have a student who is looking to find out what the patent density of Canadian cities is. Basically, he wants to know how many patents are issued within a city for the time period 2006 – 2016 (if possible).
Answer:
Apparently, the European Patent Office collects international patent data and they have a database that was used by the University of Aalborg in Denmark to create patent data visualization.
The tricky thing about analyzing Canadian patent data is that a substantial number of Canadian inventors file first in the U.S. For example, in 2017, Canadian inventors filed 4,053 patent applications in Canada and 19,861 abroad, mostly in the U.S. So any analysis should probably include both US and CA patent applications filed by CA inventors.
For Canadian city-level raw data, the best source is probably the European Patent Office’s PATSTAT database. PATSTAT contains bibliographical data relating to more than 100 million patent documents from leading industrialised and developing countries. It also includes the legal status data from more than 40 patent authorities contained in the EPO worldwide legal status database (INPADOC). It is used by many organizations and academics for patent analysis. Knowledge of SQL is required in order to retrieve data. Training materials are provided. PATSTAT is not free but it does offer a free one-month trial.
Using PATSTAT data, a team at the University of Aalborg in Denmark has created Global Patent Explorer, a patent data analysis and visualization tool that allows you to drill-down to the city level for numerous countries including Canada.
The CIPO publishes province-level data in its annual reports. See 2017-18, for example.
The WIPO’s IP country profile database is useful but does not have province- or city-level data.
The USPTO publishes a number of statistical reports including geographic origin (country, state and US metropolitan area). See https://www.uspto.gov/web/offices/ac/ido/oeip/taf/reports.htm . Unfortunately, these reports tend to be several years behind and only US metropolitan areas are available.
This may also be of use: http://www.ic.gc.ca/eic/site/cipointernet-internetopic.nsf/eng/h_wr01933.html
Friday, October 5, 2018
Commercial Real Estate
Question:
I have a researcher looking for a dataset which gives the the value or rent of commercial properties by CMA or Census Subdivision from 2006 to present. An example would be annual average rent of office space per sqf. From Statistics Canada I think that the Commercial Rents Services Price Index may work, but I can only find data for Canada and not by any smaller geographies (ex. Table 18-10-0065-02). Would it be possible to get this data by CMA or Subdivision? Would any one from the community be able to suggest any alternative data sources?
Answers from DLI List:
I hope the Commercial Rents Services Price Index works for your data question. If not, we might to look at CREA or BOMA[http://bomacanada.ca/] for this?
You might have the researcher contact the Toronto Real Estate Board to see if they can provide some data: http://www.trebhome.com/
I occasionally wander over to this site, to try some of the non-government sources within, for questions such as these:
"Global Property Guide: Financial Information for Residential Property Buyers"
< https://www.globalpropertyguide.com/North-America/Canada/Useful-Links/Economics,-Statistics,-Property-Price-History;1 >
** Can't vouch for the veracity of the hosted sites and/or the comprehensiveness of the list, but it does give lots of places to explore! **
Answer from Subject Matter:
“The Commercial Rents Services Price Index (CRSPI) measures price changes of commercial rents over time.
It is published at the national level for all buildings combined (Office buildings, Retail buildings, and Industrial buildings and warehouses).
Prices per square foot are not published at the CMA level.
However, to meet you data needs (CMA level price per square foot for office space), please refer to CBRE (www.CBRE.ca, under research centre) or Collier International (www.collierscanada.com, under research section).”
I have a researcher looking for a dataset which gives the the value or rent of commercial properties by CMA or Census Subdivision from 2006 to present. An example would be annual average rent of office space per sqf. From Statistics Canada I think that the Commercial Rents Services Price Index may work, but I can only find data for Canada and not by any smaller geographies (ex. Table 18-10-0065-02). Would it be possible to get this data by CMA or Subdivision? Would any one from the community be able to suggest any alternative data sources?
Answers from DLI List:
I hope the Commercial Rents Services Price Index works for your data question. If not, we might to look at CREA or BOMA[http://bomacanada.ca/] for this?
You might have the researcher contact the Toronto Real Estate Board to see if they can provide some data: http://www.trebhome.com/
I occasionally wander over to this site, to try some of the non-government sources within, for questions such as these:
"Global Property Guide: Financial Information for Residential Property Buyers"
< https://www.globalpropertyguide.com/North-America/Canada/Useful-Links/Economics,-Statistics,-Property-Price-History;1 >
** Can't vouch for the veracity of the hosted sites and/or the comprehensiveness of the list, but it does give lots of places to explore! **
Answer from Subject Matter:
“The Commercial Rents Services Price Index (CRSPI) measures price changes of commercial rents over time.
It is published at the national level for all buildings combined (Office buildings, Retail buildings, and Industrial buildings and warehouses).
Prices per square foot are not published at the CMA level.
However, to meet you data needs (CMA level price per square foot for office space), please refer to CBRE (www.CBRE.ca, under research centre) or Collier International (www.collierscanada.com, under research section).”
Wednesday, October 3, 2018
Commercial Real Estate
Question:
I have a researcher looking for a dataset which gives the the value or rent of commercial properties by CMA or Census Subdivision from 2006 to present. An example would be annual average rent of office space per sqf. From Statistics Canada I think that the Commercial Rents Services Price Index may work, but I can only find data for Canada and not by any smaller geographies (ex. Table 18-10-0065-02). Would it be possible to get this data by CMA or Subdivision? Would any one from the community be able to suggest any alternative data sources?
Answers from the DLI List:
- Try BOMA Canada (http://bomacanada.ca/). A quick check of the website didn’t reveal any actual numbers, but they do say that they collect statistics!
- I hope the Commercial Rents Services Price Index works for your data question. If not, we might to look at CREA or BOMA for this?
- You might have the researcher contact the Toronto Real Estate Board to see if they can provide some data: http://www.trebhome.com/
Answer from Subject Matter:
“The Commercial Rents Services Price Index (CRSPI) measures price changes of commercial rents over time.
It is published at the national level for all buildings combined (Office buildings, Retail buildings, and Industrial buildings and warehouses).
Prices per square foot are not published at the CMA level.
However, to meet you data needs (CMA level price per square foot for office space), please refer to CBRE (www.CBRE.ca, under research centre) or Collier International (www.collierscanada.com, under research section).”
I have a researcher looking for a dataset which gives the the value or rent of commercial properties by CMA or Census Subdivision from 2006 to present. An example would be annual average rent of office space per sqf. From Statistics Canada I think that the Commercial Rents Services Price Index may work, but I can only find data for Canada and not by any smaller geographies (ex. Table 18-10-0065-02). Would it be possible to get this data by CMA or Subdivision? Would any one from the community be able to suggest any alternative data sources?
Answers from the DLI List:
- Try BOMA Canada (http://bomacanada.ca/). A quick check of the website didn’t reveal any actual numbers, but they do say that they collect statistics!
- I hope the Commercial Rents Services Price Index works for your data question. If not, we might to look at CREA or BOMA for this?
- You might have the researcher contact the Toronto Real Estate Board to see if they can provide some data: http://www.trebhome.com/
Answer from Subject Matter:
“The Commercial Rents Services Price Index (CRSPI) measures price changes of commercial rents over time.
It is published at the national level for all buildings combined (Office buildings, Retail buildings, and Industrial buildings and warehouses).
Prices per square foot are not published at the CMA level.
However, to meet you data needs (CMA level price per square foot for office space), please refer to CBRE (www.CBRE.ca, under research centre) or Collier International (www.collierscanada.com, under research section).”
Unsuppressed BERD data by province
Question:
I have a researcher looking for unsuppressed data from the Annual Survey of Research and Development in Canadian Industry, and the Survey of Innovation and Business Strategy. Specifically, they are looking at business expenditure on R&D by industry for Canada and the provinces (similar to table 27-10-0341-01 / CANSIM table 358-0518), in hopes of comparing BERD within each industry across provinces and territories. Ideally they are hoping for the most recent 5 years of data, but if necessary they would sacrifice recent-ness for complete/unsuppressed data. I’m wondering if access to this data is possible, and via what channels. If I can provide any more details please let me know.
Answer from Subject Matter:
“The most recent year of data available for table 27-10-0341-01 / CANSIM table 358-0518 is for reference year 2016. This data has been published and is currently available in the referenced table. If the client requires 5 years of data, they can reference the archived CANSIM table 3580161 which contains similar information for years 2013 and prior. It should be noted that the industry groupings were changed from 46 unique groups to 57 unique groups in 2014, so there may be some mapping required. However, all the information required for that mapping is available in the disseminated tables. We are unable to provide estimates that have not been run through our confidentiality system.”
I have a researcher looking for unsuppressed data from the Annual Survey of Research and Development in Canadian Industry, and the Survey of Innovation and Business Strategy. Specifically, they are looking at business expenditure on R&D by industry for Canada and the provinces (similar to table 27-10-0341-01 / CANSIM table 358-0518), in hopes of comparing BERD within each industry across provinces and territories. Ideally they are hoping for the most recent 5 years of data, but if necessary they would sacrifice recent-ness for complete/unsuppressed data. I’m wondering if access to this data is possible, and via what channels. If I can provide any more details please let me know.
Answer from Subject Matter:
“The most recent year of data available for table 27-10-0341-01 / CANSIM table 358-0518 is for reference year 2016. This data has been published and is currently available in the referenced table. If the client requires 5 years of data, they can reference the archived CANSIM table 3580161 which contains similar information for years 2013 and prior. It should be noted that the industry groupings were changed from 46 unique groups to 57 unique groups in 2014, so there may be some mapping required. However, all the information required for that mapping is available in the disseminated tables. We are unable to provide estimates that have not been run through our confidentiality system.”
Friday, March 16, 2018
Data Brokerage Firm, information retrievals services database & information products
Question:
I have a student seeking information about data brokerage and credit scoring companies in Canada.
He has been able to find some information via the Canadian Contract History Database, the codes he is examining there are D317B, D317E, T001 group,
He would like to find a list of the companies, and statistic information about these companies in Canada. By data brokerage firms he means, database companies, list companies, survey companies, credit scoring companies, industry research companies and so on.
How would you go about finding the NAICS codes that best describe this kind of company and/or related companies that compile data and resel as products. The Classic companies are Environics Analytics in Canada, internally Axciom, Oracle, etc.
Answer from DLI member:
A significant number would, I think, fall under 541910 - Marketing research and public opinion polling (of course the 6-digit is Canadian industry only, so maybe better to go with 5-digit).
From the NAICS 2012 definition, this includes:
- broadcast media rating services
- market analysis or research services
- political and public opinion polling services
- public opinion research services
- sampling services, statistical
http://www23.statcan.gc.ca/imdb/p3VD.pl?Function=getVD&TVD=118464&CVD=118471&CPV=541910&CST=01012012&CLV=5&MLV=5
Answer from subject matter:
“Is this client a federal or provincial government? If they are not, then we will be unable to provide them with any specific microdata information about these companies. We could only give them aggregate information based on the NAICS they are looking for. ISED and other websites do have some information on registered and incorporated businesses but they would not be able to get this information from StatCan.
As for the NAICS for these businesses, the website is the best way for clients to look up NAICS. From the information the client has given you, I would estimate that they are looking at businesses in NAICS 541910 – Marketing research and public opinion polling, however, depending on the business, you could see other NAICS in the 541 subsector.”
This is the link on the STC website: http://www.statcan.gc.ca/eng/subjects/standard/naics/2017v2/index
Thursday, October 26, 2017
Business Stats at Sub-provincial Level
Question:
I’m help a graduate-level class that is working on a feasibility study for a new downtown grocery store. The instructor would like to find things like market share, customer numbers, sales by industry, and so on.
Apart from location counts by NAICS code and employee size at the CMA-level, everything we’ve located is national or provincial.
Are there sources for more detailed information, apart from CDER or custom tabs?
Answer:
You may find some of the publications from the Centre for the Study of Commercial Activity at Ryerson useful.
I don’t know if this helps, but for sales data, employee counts and other company/industry data one place we refer students to is the D&B Million Dollar Database. You can search by SIC (e.g., 54110000 for grocery stores) and limit by geography (e.g., Manitoba / Winnipeg). Doesn’t provide all the data you want in your case, of course.
I’m help a graduate-level class that is working on a feasibility study for a new downtown grocery store. The instructor would like to find things like market share, customer numbers, sales by industry, and so on.
Apart from location counts by NAICS code and employee size at the CMA-level, everything we’ve located is national or provincial.
Are there sources for more detailed information, apart from CDER or custom tabs?
Answer:
You may find some of the publications from the Centre for the Study of Commercial Activity at Ryerson useful.
I don’t know if this helps, but for sales data, employee counts and other company/industry data one place we refer students to is the D&B Million Dollar Database. You can search by SIC (e.g., 54110000 for grocery stores) and limit by geography (e.g., Manitoba / Winnipeg). Doesn’t provide all the data you want in your case, of course.
Monday, September 29, 2014
CPI Geography
Question
A researcher would like to access Consumer Price Index data, but at the Census Division or Subdivision level of geography. The lowest level of geography I see is larger urban areas, for Statistics Canada as well as other statistical agencies. However, I thought it wouldn’t hurt to check with the DLI, in case I have missed something or in case this data may be available as a custom product?
Answer
Unfortunately, the CPI estimate is not produced for any CD or CSD, not even in a cost recovery basis. The CPI is available for some major urban centres at available at no cost in our web site:
<http://www.statcan.gc.ca/pub/62-001-x/2014008/t048-eng.htm>
A researcher would like to access Consumer Price Index data, but at the Census Division or Subdivision level of geography. The lowest level of geography I see is larger urban areas, for Statistics Canada as well as other statistical agencies. However, I thought it wouldn’t hurt to check with the DLI, in case I have missed something or in case this data may be available as a custom product?
Answer
Unfortunately, the CPI estimate is not produced for any CD or CSD, not even in a cost recovery basis. The CPI is available for some major urban centres at available at no cost in our web site:
<http://www.statcan.gc.ca/pub/62-001-x/2014008/t048-eng.htm>
Friday, September 26, 2014
Consumer Price Index
Question
I have a researcher here who is looking for detailed documentation on the commodities in the current CPI basket of goods. In particular, he would like to know what commodities are being used for the two following categories: Telephone Services (v41691070) and Internet Access Services (v41693216).
The researcher is trying understand a huge jump in the price index for those two components from July 2014 to August 2014. As there was no obvious market reason for this jump, he thinks it may have been caused by a change in either the composition of the basket or the weighting of these categories over this time frame. We checked the available documentation but could not find anything related.
Would you be able to check this with the division that oversees the CPI?
Answer
The Author Divison Explained that: "Our release on the August CPI said prices for telephone services rose 7.6 per cent, year-to-year. Yes, prices for telephone services went up the most year-over-year this past August since March 1983.
(CANSIM Table 326-0020, http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=3260020&paSer=&pattern=&stByVal=1&p1=1&p2=50&tabMode=dataTable&csid=)
The telephone services index is comprised of three components: local telephone services, long distance rates, and cellular services. The aggregate telephone services index is a weighted average of its three components, using weights provided by the Survey of Household Spending (SHS). Data on these sub-indexes is not disseminated. The internet access services index rose 11.3% year over year in August. This is the highest year-over-year rate of change in the time series. The internet access services index posted a 3.5% month-to-month increase in August 2014, which was the highest monthly increase since November 2013 when it increased 4.8%. The internet access services index has been published since December 2002. The spreadsheet containing historical data for this index is attached (extracted from CANSIM Table 326-0020)."
I have a researcher here who is looking for detailed documentation on the commodities in the current CPI basket of goods. In particular, he would like to know what commodities are being used for the two following categories: Telephone Services (v41691070) and Internet Access Services (v41693216).
The researcher is trying understand a huge jump in the price index for those two components from July 2014 to August 2014. As there was no obvious market reason for this jump, he thinks it may have been caused by a change in either the composition of the basket or the weighting of these categories over this time frame. We checked the available documentation but could not find anything related.
Would you be able to check this with the division that oversees the CPI?
Answer
The Author Divison Explained that: "Our release on the August CPI said prices for telephone services rose 7.6 per cent, year-to-year. Yes, prices for telephone services went up the most year-over-year this past August since March 1983.
(CANSIM Table 326-0020, http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=3260020&paSer=&pattern=&stByVal=1&p1=1&p2=50&tabMode=dataTable&csid=)
The telephone services index is comprised of three components: local telephone services, long distance rates, and cellular services. The aggregate telephone services index is a weighted average of its three components, using weights provided by the Survey of Household Spending (SHS). Data on these sub-indexes is not disseminated. The internet access services index rose 11.3% year over year in August. This is the highest year-over-year rate of change in the time series. The internet access services index posted a 3.5% month-to-month increase in August 2014, which was the highest monthly increase since November 2013 when it increased 4.8%. The internet access services index has been published since December 2002. The spreadsheet containing historical data for this index is attached (extracted from CANSIM Table 326-0020)."
Tuesday, February 18, 2014
Company Level Data from Canadian Business Patterns
Question
A student here is looking for the numbers of employees by province for companies listed on the TSX; would this be possible from CBP as a custom tabulation, or is company-level data impossible under any circumstances?
Answer
You are correct - Business data such as operating or legal names are confidential and are not available in any custom data tabulation.
A student here is looking for the numbers of employees by province for companies listed on the TSX; would this be possible from CBP as a custom tabulation, or is company-level data impossible under any circumstances?
Answer
You are correct - Business data such as operating or legal names are confidential and are not available in any custom data tabulation.
Monday, December 9, 2013
Franchise Information
Question
I'm trying to measure the impact of franchise businesses/locations across the economy. I'm interested in knowing the number, what industry they are in, how many people they employ, their financial information, etc. It looks like this information is available in the various Annual Survey of Service Industries (food services, travel arrangement services, etc), but these don’t seem to be available via the DLI, how can I access this information?
Answer
Try the Canadian Franchise Association: http://cfa.ca/Publications_Research/FastFacts.aspx
There's also a Daily release for an Annual Survey of Service Industries, contact Client Services (toll-free 1-877-801-3282; 613-951-4612; servicesind@statcan.gc.ca).
I'm trying to measure the impact of franchise businesses/locations across the economy. I'm interested in knowing the number, what industry they are in, how many people they employ, their financial information, etc. It looks like this information is available in the various Annual Survey of Service Industries (food services, travel arrangement services, etc), but these don’t seem to be available via the DLI, how can I access this information?
Answer
Try the Canadian Franchise Association: http://cfa.ca/Publications_Research/FastFacts.aspx
There's also a Daily release for an Annual Survey of Service Industries, contact Client Services (toll-free 1-877-801-3282; 613-951-4612; servicesind@statcan.gc.ca).
Monday, January 28, 2013
Survey of Innovation and Business Strategy
Question
Is there a PUMF or any other information available for the “Survey of Innovation and Business Strategy,” which was last released in 2010. I have a researcher looking for any data she can get on business innovation. There are a few tables on the Statcan, but is there anything else?
Answer
We typically only have access to aggregate data for Business Surveys. It is accessible through The Canadian Centre for Data Development and Economic Research (CDER). CDER is located within Statistics Canada's Ottawa facilities on the 18th Floor of the R.H. Coats Building. Access to Statistics Canada's holdings of business microdata is available only at this facility. A prospective researcher must submit a project proposal to CDER following the process outlined in the CDER application process and guidelines. Only research-oriented projects can be undertaken at CDER. Alternative access to the data would be to request a custom tab from the subject matter divisions.
Is there a PUMF or any other information available for the “Survey of Innovation and Business Strategy,” which was last released in 2010. I have a researcher looking for any data she can get on business innovation. There are a few tables on the Statcan, but is there anything else?
Answer
We typically only have access to aggregate data for Business Surveys. It is accessible through The Canadian Centre for Data Development and Economic Research (CDER). CDER is located within Statistics Canada's Ottawa facilities on the 18th Floor of the R.H. Coats Building. Access to Statistics Canada's holdings of business microdata is available only at this facility. A prospective researcher must submit a project proposal to CDER following the process outlined in the CDER application process and guidelines. Only research-oriented projects can be undertaken at CDER. Alternative access to the data would be to request a custom tab from the subject matter divisions.
Monday, October 20, 2008
Canadian Business Patterns Question
Question
A researcher is interested in the following information:
1. Number of retail food outlets in British Columbia, by the smallest area unit possible (e.g. by Census Division, Census Consolidated Subdivision, whatever is available).
2. The above data broken into types of food outlets (e.g. grocery stores, at the same area unit.
The researcher sent her request directly to infostat@statcan.gc.ca and they redirected the researcher to me, with the following accompanying information:
Problem #2: I am not sure where to find the second product "Canadian business patterns - revenue ranges" on the DLI FTP site. Is this product part of the DLI Collection?
Answer
As far as the Canadian business patterns - revenue ranges is concerned, this product was last released in 2002 as the Canadian Business Pattern is released frequently. I am not sure of the relevance of using this one while using the last CBP.
I did check with Subject-matter and the latest version released was the 2000 issue released in 2002. That copy is on the FTP site at the following link:
A researcher is interested in the following information:
1. Number of retail food outlets in British Columbia, by the smallest area unit possible (e.g. by Census Division, Census Consolidated Subdivision, whatever is available).
2. The above data broken into types of food outlets (e.g. grocery stores, at the same area unit.
The researcher sent her request directly to infostat@statcan.gc.ca and they redirected the researcher to me, with the following accompanying information:
To obtain the information you have requested, it is available from the
Canadian Business Patterns (Catalogue No.: 61F0040XCB).
The Canadian Business Patterns (CBP) contains data that reflect counts of
business establishments for nine (9) employment size ranges, including
"indeterminate", for Canada, the provinces/territories, census divisions,
census subdivisions, census metropolitan areas and census agglomerations.
The establishment counts are divided by industry based on the North
American Industry Classification System (NAICS 2, 3, 4 and 6-digit level)
and the Standard Industrial Classification (SIC 1, 2, 3 and 4-digit
level).
A second product called "Canadian business patterns - revenue ranges"
(catalogue no.: 61F0102XCB) expands the basis of CBP. This product
provides a count of businesses based on revenue ranges. Users can thus
analyze businesses on the basis of industry, revenue and geographic area.
Data are provided at the three-digit level of the North American Industry
Classification System, encompassing about 99 industries, or sub-sectors,
and by six revenue ranges.
These products are available for free to Canadian educational institutions
participating in the Data Liberation Initiative. Please note, however,
that the DLI is limited to students, faculty and administration for
academic research and teaching purposes.
Problem #1: I had already downloaded the Canadian Business Patterns (CBP) data from the FTP site but I have never tried to use this product. I have now installed it on my PC, using the install instructions at http://www.statcan.ca/english/Dli/Data/Ftp/cbp/cbp2008.htm but I am getting an error. (The error message tells me to install the CDROM in the appropriate drive. Both the NAICS and CBP folders are on my C drive, in their respective folders, as installed.) I phoned the folks at infostat@statcan.gc.ca and apparently someone will help me troubleshoot this on Monday. Unless, you can help troubleshoot?
Problem #2: I am not sure where to find the second product "Canadian business patterns - revenue ranges" on the DLI FTP site. Is this product part of the DLI Collection?
Answer
As far as the Canadian business patterns - revenue ranges is concerned, this product was last released in 2002 as the Canadian Business Pattern is released frequently. I am not sure of the relevance of using this one while using the last CBP.
I did check with Subject-matter and the latest version released was the 2000 issue released in 2002. That copy is on the FTP site at the following link:
http://www.statcan.ca/english/Dli/Data/Ftp/cbp/cbp2000.htm
As mentioned, it may not be relevant to the latest copy of the CBP that you will be using.
As mentioned, it may not be relevant to the latest copy of the CBP that you will be using.
Tuesday, February 12, 2008
Companies that bottle BC water
Question
I have a student here wanting to find all companies that export bottled water out of BC (i.e., the actual water comes from BC). Anyone have any ideas?
I can use the NAICS code 312112 (Bottled Water Manufacturing) to search several products to find companies that bottle water, but that doesn't
help us determine which of these use BC water.
Answer
Industry Canada's Canadian Company Capabilities may help in part, since some of the British Columbia-based companies listed state that their water is bottled either in B.C. or at source.
http://www.ic.gc.ca/epic/site/ccc-rec.nsf/en/Home
I have a student here wanting to find all companies that export bottled water out of BC (i.e., the actual water comes from BC). Anyone have any ideas?
I can use the NAICS code 312112 (Bottled Water Manufacturing) to search several products to find companies that bottle water, but that doesn't
help us determine which of these use BC water.
Answer
Industry Canada's Canadian Company Capabilities may help in part, since some of the British Columbia-based companies listed state that their water is bottled either in B.C. or at source.
http://www.ic.gc.ca/epic/site/ccc-rec.nsf/en/Home
Tuesday, February 27, 2007
SLID 2003 Documentation
Users of the latest version of SLID 2003 should be aware that there is a conflicting information in the documentation.
Eg page 2 of the record layout (slid2003cbk.pdf) claims variable rcvcmp28 is in column 110 of the person file, while page 29 of the same document claims it is in column 111.
At least reading it from 110 gives the appropriate frequencies. But all column locations for the person file, beyond column 110 appear to be correct in one place, and incorrect in another place.
Eg page 2 of the record layout (slid2003cbk.pdf) claims variable rcvcmp28 is in column 110 of the person file, while page 29 of the same document claims it is in column 111.
At least reading it from 110 gives the appropriate frequencies. But all column locations for the person file, beyond column 110 appear to be correct in one place, and incorrect in another place.
Friday, December 8, 2006
Seafood Consumption by Ethnic Group
Question
Can someone help me to find data on fish and/or seafood consumption (in Canada) by ethnic groups?
Answer
The Family food expenditure surveys 1992 and 1996 - summary files don't have much, but they do have:
- country of birth (more like continent of birth) and mother tongue (English, French, and other)
- weekly food expenditure on fish and other marine products
Unfortunately, the country of birth variable is no longer included in the 2001 pumf.
There is also the pdf file:
Influence of Immigration on The Ethnic Food Market in Canada / Agriculture and Agri-Food Canada in the November 2005 edition of Canada food stats (23F0001XCB)
I checked the Canada health survey (1978-79) and the Nutrition Canada survey (1970-1972) without success - but then, these are quite old by now and there have been substantial changes to the ethnic composition of Canada since then.
You may need to send the user the RDC-route, since the CCHS 2.2 nutrition component should include other foods than just the fruits and vegetables that are in the pumf, as well as ethnicity variables in the common and optional content file.
Can someone help me to find data on fish and/or seafood consumption (in Canada) by ethnic groups?
Answer
The Family food expenditure surveys 1992 and 1996 - summary files don't have much, but they do have:
- country of birth (more like continent of birth) and mother tongue (English, French, and other)
- weekly food expenditure on fish and other marine products
Unfortunately, the country of birth variable is no longer included in the 2001 pumf.
There is also the pdf file:
Influence of Immigration on The Ethnic Food Market in Canada / Agriculture and Agri-Food Canada in the November 2005 edition of Canada food stats (23F0001XCB)
I checked the Canada health survey (1978-79) and the Nutrition Canada survey (1970-1972) without success - but then, these are quite old by now and there have been substantial changes to the ethnic composition of Canada since then.
You may need to send the user the RDC-route, since the CCHS 2.2 nutrition component should include other foods than just the fruits and vegetables that are in the pumf, as well as ethnicity variables in the common and optional content file.
Friday, November 24, 2006
SLID 2000 Immigrant Variable
Question
In the 2000 Survey of Labour and Income Dynamics there is a variable "immst15" (immigrant flag). Marginals are as follows:
1 yes 3,641
2 no 11,608
7 don't know 42,192
We're assuming that the "don't know" category should actually be "not applicable" and also that it refers to persons born in Canada. Is that a valid assumption?
Answer
Immigration status is available only for persons living in urban size of 500,000 and higher all other individuals are set to don't know for confidentiality reasons.
Follow up
Is there not some way that another code could be used that could be specifically for "confidentiality protection"? A code of "don't know" should be reserved for persons who indicate that as their response. This undermines confidence in coding.
In the 2000 Survey of Labour and Income Dynamics there is a variable "immst15" (immigrant flag). Marginals are as follows:
1 yes 3,641
2 no 11,608
7 don't know 42,192
We're assuming that the "don't know" category should actually be "not applicable" and also that it refers to persons born in Canada. Is that a valid assumption?
Answer
Immigration status is available only for persons living in urban size of 500,000 and higher all other individuals are set to don't know for confidentiality reasons.
Follow up
Is there not some way that another code could be used that could be specifically for "confidentiality protection"? A code of "don't know" should be reserved for persons who indicate that as their response. This undermines confidence in coding.
Friday, November 10, 2006
Amount collected by restaurant workers in tips
Question
How much is collected in income tax for tips by restaurant / bar workers and how much do they actually collect from the folks leaving the tips?
Answer
That is a very tough question! The last time Statistics Canada looked at "The Underground Economy" was in 1994...
I did find a handy paragraph that could perhaps be of help:
3.5 Tips
Tips are calculated in the national accounts as a fixed percentage of gross business receipts, varying by industry and type of service provided (3% for accommodation, 10% for meals in restaurants, alcoholic beverages and hairdressing and 15% for taxi). The upper limit of tips missing from GDP due to underground transactions can be calculated directly by applying the same percentages to the estimates skimming of receipts...
Source: The Size of the Underground Economy in Canada, catalogue 13-602E, No. 2, Statistics Canada, p.30. (Gaëtan - don't look at my citation format!)
I would take some time to review the entire document - it has many components which are very helpful.
Although this will not meet your exact needs, it may hold some information to help guide you in your search.
How much is collected in income tax for tips by restaurant / bar workers and how much do they actually collect from the folks leaving the tips?
Answer
That is a very tough question! The last time Statistics Canada looked at "The Underground Economy" was in 1994...
I did find a handy paragraph that could perhaps be of help:
3.5 Tips
Tips are calculated in the national accounts as a fixed percentage of gross business receipts, varying by industry and type of service provided (3% for accommodation, 10% for meals in restaurants, alcoholic beverages and hairdressing and 15% for taxi). The upper limit of tips missing from GDP due to underground transactions can be calculated directly by applying the same percentages to the estimates skimming of receipts...
Source: The Size of the Underground Economy in Canada, catalogue 13-602E, No. 2, Statistics Canada, p.30. (Gaëtan - don't look at my citation format!)
I would take some time to review the entire document - it has many components which are very helpful.
Although this will not meet your exact needs, it may hold some information to help guide you in your search.
Wednesday, November 8, 2006
Expenditures on antidepressants
Question
Is there any data available on how much Canadians spend on antidepressants in a year?
Answers
Answer 1:
I am not sure Statistics Canada is the best source for this sort of data... I did perform a few searches, but the results are far from
impressive.
Result # 1)
CANSIM Table 203-0008 -- Survey of household spending (SHS), household spending on health care, by province and territory, annual
One section is called: Medicinal and pharmaceutical products (Prescription medicines _and_ Other non-prescription medicines and pharmaceutical products).
As you can see, this is a very broad category and may be a poor indication of antidepressant expenditure.
Result # 2)
CANSIM Table 301-0006 - Principal statistics for manufacturing industries, by North American Industry Classification System (NAICS), annual (dollars unless otherwise noted)
Pharmaceutical and medicine manufacturing [3254]
Pharmaceutical and medicine manufacturing [32541]
Pharmaceutical and medicine manufacturing [325410]
Although you can get revenues from this table, extreme caution should be used.
1) This is for a broad category of pharmeceuticals and medicine - antidepressants is only one part
2) The manufacture's price may not be the retail price and could under estimate the revenues/sales.
3) Some of the product could be exported and would not be reflective of the Canadian consumption model.
4) There may be additional issues with this proposed option....
Answer 2:
CIHI has a Drug Spending Database:
http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=spend_e#drug
Who is authorized to access?
Drug Expenditure in Canada: including very aggregate data.
http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=AR_80_E
Drug expenditure data in this report are obtained from the National Health Expenditure Database (NHEX) maintained by the Canadian Institute for Health Information (CIHI). Drug expenditure data in NHEX are macro-level data and do not allow for decomposition of prescription costs or drug classes.
For a general overview:
http://secure.cihi.ca/cihiweb/products/Drug_Expenditure_in_Canada_2006_final_web.pdf
Answer 3:
STC does not have that detailed information on antidepressant. CIHI collects the information on prescription but I don't think that you will get from them the details on antidepressant (unless they would do this request as a custom request).
Is there any data available on how much Canadians spend on antidepressants in a year?
Answers
Answer 1:
I am not sure Statistics Canada is the best source for this sort of data... I did perform a few searches, but the results are far from
impressive.
Result # 1)
CANSIM Table 203-0008 -- Survey of household spending (SHS), household spending on health care, by province and territory, annual
One section is called: Medicinal and pharmaceutical products (Prescription medicines _and_ Other non-prescription medicines and pharmaceutical products).
As you can see, this is a very broad category and may be a poor indication of antidepressant expenditure.
Result # 2)
CANSIM Table 301-0006 - Principal statistics for manufacturing industries, by North American Industry Classification System (NAICS), annual (dollars unless otherwise noted)
Pharmaceutical and medicine manufacturing [3254]
Pharmaceutical and medicine manufacturing [32541]
Pharmaceutical and medicine manufacturing [325410]
Although you can get revenues from this table, extreme caution should be used.
1) This is for a broad category of pharmeceuticals and medicine - antidepressants is only one part
2) The manufacture's price may not be the retail price and could under estimate the revenues/sales.
3) Some of the product could be exported and would not be reflective of the Canadian consumption model.
4) There may be additional issues with this proposed option....
Answer 2:
CIHI has a Drug Spending Database:
http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=spend_e#drug
Who is authorized to access?
Drug Expenditure in Canada: including very aggregate data.
http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=AR_80_E
Drug expenditure data in this report are obtained from the National Health Expenditure Database (NHEX) maintained by the Canadian Institute for Health Information (CIHI). Drug expenditure data in NHEX are macro-level data and do not allow for decomposition of prescription costs or drug classes.
For a general overview:
http://secure.cihi.ca/cihiweb/products/Drug_Expenditure_in_Canada_2006_final_web.pdf
Answer 3:
STC does not have that detailed information on antidepressant. CIHI collects the information on prescription but I don't think that you will get from them the details on antidepressant (unless they would do this request as a custom request).
Friday, September 29, 2006
Updated Products - CBP
Canadian Business Patterns - June 2006
The Canadian Business Patterns contains data that reflect counts of business establishments by: 9 employment size ranges, including "indeterminate" (as of December 1997); geography groupings: province/territory, census division, census subdivision, census metropolitan area and census agglomeration; and Standard Industrial Classification which classifies each establishment in Canada into a specific industry (tables at the 1, 2, 3 and 4-digit level). Since the
December 1998 reference period, these data are also presented using the North American Industry Classification System (tables at the 2, 3, 4 and 6-digit level). A concordance table showing the relationships between both classification systems is included with the product.
WEB: http://www.statcan.ca/english/Dli/Data/Ftp/cbp.htm
FTP: dli/cbp/2006
Question & Answer
Q: Why on the web version is there just a small file stating that it has to be downloaded by DLI contacts? This really doesn't allow us to download it from the web using a password. There is no way of downloading it from there, you have to go to the DLI FTP site to actually get it. I went to the FTP site and got the file, but it seems that the web link is actually misleading.
A: When you click on a file with a little lock next to it (data files), it brings you to another web page explaining the restricted access. There is a link at the bottom of the explanation page to access the collection. When you click on the link, a pop-up screen appears and requests your user name and password - just enter your contact info - same as the FTP site.
The Canadian Business Patterns contains data that reflect counts of business establishments by: 9 employment size ranges, including "indeterminate" (as of December 1997); geography groupings: province/territory, census division, census subdivision, census metropolitan area and census agglomeration; and Standard Industrial Classification which classifies each establishment in Canada into a specific industry (tables at the 1, 2, 3 and 4-digit level). Since the
December 1998 reference period, these data are also presented using the North American Industry Classification System (tables at the 2, 3, 4 and 6-digit level). A concordance table showing the relationships between both classification systems is included with the product.
WEB: http://www.statcan.ca/english/Dli/Data/Ftp/cbp.htm
FTP: dli/cbp/2006
Question & Answer
Q: Why on the web version is there just a small file stating that it has to be downloaded by DLI contacts? This really doesn't allow us to download it from the web using a password. There is no way of downloading it from there, you have to go to the DLI FTP site to actually get it. I went to the FTP site and got the file, but it seems that the web link is actually misleading.
A: When you click on a file with a little lock next to it (data files), it brings you to another web page explaining the restricted access. There is a link at the bottom of the explanation page to access the collection. When you click on the link, a pop-up screen appears and requests your user name and password - just enter your contact info - same as the FTP site.
Subscribe to:
Posts (Atom)