Input-Output Model Simulations (National Model)

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.

Tabulation Requested for GDP $ for Ontario by NAICS Code and Firm Size

Question:
A researcher is looking for income-based GDP $ breakdown for NAICS code 541110 for firms under 20 employees compared to firms with 20 and more employees.  Ideally she would like this for Ontario, but if this isn’t possible, Canada will do.  Basic prices are fine. 

I can’t find this, which is way I think she will need a tabulation.  May we please request on something of a rush basis?

As an aside the researcher found that for 2017 and 2018 all registered law firms in Canada contributed 25,488.6 Million dollars to the Canadian economy (via IBISworld database I think).

Answer:
I’ve received the following response:
“It is not possible to provide data for this request, at least not from Industry Accounts Division.
We only have information for NAICS 5411 and we don’t have any information on firm sizes.”

Company E-commerce Data

Question:
Can anyone suggest where a student might find information about WalMart CANADA ecommerce  and retail data.  Is it possible to know which company in Canada is first in ecommerce?  I know Stats Can does provide company names.  Google searches come up with Statista which looks pretty good but we don't subscribe.  Any or all ideas are welcome.

Answer:
Here is the response from subject matter:

“Due to confidentiality, we cannot comment on specific companies.
That said, we do have a Partial list of Retail Chain Stores from our website and in relation to our Annual Retail Trade Survey table 20-10-0066-01.
He may also want to have a look at our tables on e-commerce 20-10-0065-01 (Annual) and 20-10-0072-01 (Monthly), maybe could be of use to him.
Also, from our website, you can suggest that he does a search by keyword(s) ‘’Annual Retail’’, ‘’Monthly Retail’’ and a lot more tables will show up.”

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.”

Financial Performance by Individual Business

Question:
I have a researcher looking for financial performance information (revenue, profit) at the individual level for Bed and Breakfast operators (NAICS 721191) in NS.

Is this information available via a custom tab through the Business Register…or at all?

Answer:
We’ve received the following response from subject matter:

“As far as data from the Business Register, we would not have any revenue or profit figures available, only business counts by NAICS, geography and employment size range (or revenue ranges for 3 digit NAICS by provinces).”

Company Data for Southwestern Ontario

Question:
I have a researcher looking for financial information about Southwestern Ontario companies more specifically income, output levels and capital values for each company. Or is this available at a broader level such as by NAIC and geography (Postal Code, CSD, etc) Any ideas where this data could be?

Answer: 
Statistics Canada does not publicly publish business confidential data at any level, all identifiers are suppressed prior to publishing. This type of data would only be accessible through the Business Register (formerly the Canadian Business Patterns), which is not publicly accessible.

Nonetheless, we did come across Dalhousie University’s Business Research Guide that outlined numerous resources for company financial statements.

KLEMS

Question:
The KLEMS data is pretty historic now.  Will the database ever be updated?

Answer:
Subject matter directed me to the following CANSIM tables with the message “KLEMS is now available in CANSIM:

http://www5.statcan.gc.ca/cansim/a26?lang=eng&id=3830032&p2=33
http://www5.statcan.gc.ca/cansim/a26?lang=eng&id=3830021&p2=33

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.

Survey of Innovation and Business Strategy

Question

I have a researcher who would like to access the microdata (firm-level data) for the Survey of Innovation and Business Strategy - 5171. Can this be made available through a RDC or otherwise?

Answer

The only way to work with Business level microdata would be through the Canadian Centre for Data Development and Economic Research (CDER). See their website for more information:<http://www.statcan.gc.ca/cder-cdre/index-eng.htm>.

Inter-Corporate Ownership

Question

I have a researcher interested in using ICO data going as far back as 1985. I was reading on the DLI webpage: <http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/ico-lps-eng.htm>, which says that: "The 1985 to 2003 editions of this product can be ordered by DLI Contacts through the DLI product order form". But, under "Notes" it says "DLI Contacts can order issues of this product for 1995 to 2003 through the DLI product order form." How far back can we order the ICO data through DLI?

Answer

We only have back to 1996 in our collection holding CD-roms, so I believe it could have been an error on the DLI product page site. I even looked at the ICO product page in the StatCan catalogue, which states it goes back to 1994, and that there is the print edition. Print 61-517-XPB. History note continues the print publication with the same title commencing with the first quarter 2001. We have had publication copies prior to that.

Updated Products - ICO Q4 2011

Hello,

The Inter-corporate ownership (ICO) - Q4 2011 CD is now available for download from the DLI FTP and website.

"The Inter-corporate ownership CD is the most authoritative and comprehensive source of information available on corporate ownership; a unique directory of "who owns what" in Canada. It provides up-to-date information reflecting recent corporate takeovers and other substantial changes. Ultimate corporate control is determined through a careful study of holdings by corporations, the effects of options, insider holdings, convertible shares and interlocking directorships. The number of corporations that make up the hierarchy of structures totals approximately 45,000.

The information that is presented is based on non-confidential returns filed by Canadian corporations under the Corporations Returns Act and on research using public sources such as internet sites. The data are presented in an easy-to-read tiered format, illustrating at a glance the hierarchy of subsidiaries within each corporate structure. The entries for each corporation provide both the country of control and the country of residence.

The product covers every individual corporation that is part of a group of commonly controlled corporations with combined assets exceeding 200 million dollars or combined revenue exceeding 80 million dollars. Individual corporations with debt obligations or equity owing to non-residents exceeding a net book value of 1 million dollars are covered as well."

(http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=61-517-X)

Updated Products - ICO Q4 2010

Inter-corporate ownership (ICO) – Q4 2010

This product is now available on the DLI FTP and website. DLI Contacts will receive a copy of this CD by mail.

"The Inter-corporate ownership CD is the most authoritative and comprehensive source of information available on corporate ownership; a unique directory of "who owns what" in Canada. It provides up-to-date information reflecting recent corporate takeovers and other substantial changes. Ultimate corporate control is determined through a careful study of holdings by corporations, the effects of options, insider holdings, convertible shares and interlocking directorships. The number of corporations that make up the hierarchy of structures totals approximately 45,000.

The information that is presented is based on non-confidential returns filed by Canadian corporations under the Corporations Returns Act and on research using public sources such as internet sites. The data are presented in an easy-to-read tiered format, illustrating at a glance the hierarchy of subsidiaries within each corporate structure. The entries for each corporation provide both the country of control and the country of residence.

The product covers every individual corporation that is part of a group of commonly controlled corporations with combined assets exceeding 200 million dollars or combined revenue exceeding 80 million dollars. Individual corporations with debt obligations or equity owing to non-residents exceeding a net book value of 1 million dollars are covered as well."
(http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=61-517-X)

WEB: http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/ico-lps-eng.htm
FTP: /DissFTP/dli/DLI Coll._Other prod/Inter-corporate ownership - ico

Thank you.

Updated Product- Canadian Business Patterns (CBP)

Please note the updated products listed below and the path to access them via the DLI FTP and web sites.

Canadian Business Patterns - December 2009

"The Canadian Business Patterns contains data that reflect counts of business establishments and locations (as of December 2008) by: 9 employment size ranges, including "indeterminate" (as of December 1997); geography groupings: province/territory, census division, census subdivision (before December 2008), census metropolitan area and census agglomeration; and industry using the North American Industry Classification System (tables at the 2, 3, 4 and 6-digit level) as of December 1998. Before December 2004, these data were also presented using the Standard Industrial Classification (tables at the 1, 2, 3 and 4-digit level). A concordance table showing the relationships between both classification systems is included with the product." (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=61F0040X?=eng)

FTP: /DissFTP/dli/DLI Collection- **except Census; Geography and Trade**/Canadian Business Patterns - cbp/2009/cbp2009-dec.zip

WEB: http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/cbp-sic/cbp-sic2009-eng.htm

Equities Held by Institutional Investors

Question

A student here is interested in determining the percentage or value of Canadian equities held by institutional investors (such as pension funds) as opposed to private investors. He would like these data over time, preferably since 1980, and preferably on a monthly basis (although quarterly or annual would suffice). Any ideas?

Answer

Please refer the client to CANSIM Table 378-0007 (National balance sheet accounts, book value, by sectors, at quarter end, quarterly) and CANSIM Table 378-0009 (National balance sheet accounts, market value, by sectors, at quarter end, quarterly). These tables should provide the detail necessary.

Money Spent on Research By Firms

Question

I have a faculty member looking for data on how much Canadian firms spend on research.  She's hoping to get the data by company size and sector.

There seemed to be data of interest from Research and Development in Canadian Industry (RDCI) (http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4201&lang=en&db=imdb&adm=8&dis=2) through CANSIM 358-0024, various publications, and the Summary Table at http://www40.statcan.gc.ca/l01/cst01/econ151a-eng.htm.

The publication at http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=88-001-X200900410909&lang=eng seems to get close to what she seems to want, but she needs more granularity for the industry sectors.

Is there any chance of getting more current, detailed data through the DLI?  If not, is custom data an option, and could we get some idea of price based on number of industry sectors, company size breakdown, and geography (i.e., number of provinces).

If anyone has an idea of another place to get this data, we'd be interested.  She also seems to want the figures by company (within a sector).  I was able to search OSIRIS by country and industry sector (up to 6-digit NAICS) and get a list of companies.  I was then able to view R&D amounts for each company in the financials -- one company at a time.  Although it was possible to export a dataset for broader financials, it didn't seem possible to include the more detailed financials (i.e., R&D figures) in the export file.

Answer

Company-level R&D expenditures are available in the Financial Post Corporate database, as well as in the Compustat Canadian file.

Licensing Question

Question

A group of students is doing a project for a Business School course here at Western. The project consists of examining a business problem for an existing business, and offering data-based resolutions to the business. In this specific case, they wish to do market research.

So, working through the flow chart:

-I assume that I will be able to find them the data they need from the DLI collection (I meet with them Wednesday) >> approved

-They are authorised (students) >> approved

-To be used for academic purposes >> approved – kind of, depending on the next question

-But then what (if anything) can they give to the business (which is a requirement of the project)?

Answer

Since this is an assignment they have to do within their course, this falls within the license. They can use the data to do their work but they cannot share the data with the business. They can certainly share their analysis, this is no problem but they cannot provide the business with the data sets they used to do their analysis. The idea is that results/analysis can be shared and make public so that everyone can profit from the analysis.

I should may add one point to clarify:

The results can't be used only privately by the business unless the data are purchased. If the business doesn't want to have the analysis made public or shared, they would have to buy the data to be used from StatCan and then have the students do the analysis.

Additional Question

I’m a little unclear now as to the circumstances under which the students can give the report to the company.

How could/should the students make the report public or shared in order to give it to the company? I certainly expect that it will be given to the professor for evaluation together with the company, but suspect that that would be insufficient. Would a policy of dissemination on demand be sufficient – i.e., if they or the professor are asked for it, they would give it to other people in addition to the company? Would it need to be more active dissemination?

Answer

We had the same sort of situation here at Queen’s.  What ended up happening is that the products of the students’ work (various reports that used DLI data) were put up on a departmental ‘working paper’ site that was open to the world.  Just the reports – no data.  The local agencies that prompted these research efforts can tap into the working paper site, but so can everyone else.

CMA/CA Designation for Communities in Newfoundland and Labrador

Question

I'm not sure if you would know the answers to some of these questions but perhaps you can direct me to someone who does.

1. I was looking at the tables for CMA NAICS 6.  For 1999- June 2007, the CMAs listed for Newfoundland and Labrador were: St. John's, Gander, Grand Falls/Windsor, Corner Brook, and Lab City.  In Dec. 2007, the CMAs changed.  They are now: St. John's, Grand Falls/ Windsor, Corner Brook, and Bay Roberts.  It seems we lost Gander and Lab City.  This isn't that unusual as the population size could have dropped below the minimum level for a CMA.  However, it seems odd that a town like Bay Roberts (also on the Avalon) would meet the criteria for a CMA.  Any ideas?

2. There are some NAICS codes I was looking for that appear from 1999-2001 and then they completely disappear (i.e. they are not even listed in the tables anymore).  Any ideas on why they would disappear?  Could they have been incorporated into another code?

3. There is one NAICS code (621910) listed in a document I received from a colleague.  This code is defined as Rescue Services.  However, it has never been listed in any of the CMA tables for 1999 to 2008.  You would think this would be an important code, especially here in NL, and it would definitely apply to our oceans sector research.  On the NAICS website (http://www.census.gov/cgi-bin/sssd/naics/naicsrch?code=621910&search=2002%20NAICS%20Search), if you type in this number, it comes up as Rescue Services and implies that it is a NAICS code for 1997, 2001, 2007, etc.  Any ideas as to why it is not included in the tables?

4. Do you know of a way to examine business births and deaths over time using the CBP data (besides going through each table year by year and recording numbers for each code)?  I wondered if there is a more streamlined and efficient way to uncover this info.



Answer



I have found the answers to several of the questions below:

1.  Bay Roberts is a Census Agglomeration (CA), not a CMA.  Among other criteria, CAs require an urban core population of only 10,000, whereas CMA status requires a total population of 100,000 (with at least 50,000 in the urban core).  Gander and Labrador City would also have been CA's before their populations dropped below 10,000. Here is the definition for both CAs and CMAs from the Census web site:

http://www12.statcan.ca/english/census06/reference/dictionary/geo009.cfm

2. The missing NAICS codes post-2001 may have to do with the 2002 revision of NAICS.  For a concordance between the 1997 and 2002 NAICS please consult the following link:

http://www.statcan.gc.ca/subjects-sujets/standard-norme/concordances/naics-scian97-02-eng.htm

3.  The NAICS link you provide below is to the U.S. version of NAICS 2002.  While NAICS is mostly comparable among the 3 North American countries, there are some exceptions, particularly at the 6-digit level.  For more information, please consult the following:

http://www.statcan.gc.ca/subjects-sujets/standard-norme/manual2002-manuel2002-eng.htm

4. Here is the response from the Division regarding your 4th question on business births and deaths:

"Unfortunately we can't produce the number of births and deaths in the CBP. The CBP contains the net changes to the establishment count (deaths and births). The CBP basically provides a snapshot of our business register at a specific time. The client should also be aware that the CBP is based on establishment counts and not counts of businesses."

There are some analytical studies on the Statistics Canada website that deal with entries and exits:

http://cansim2.statcan.gc.ca/cgi-win/cnsmcgi.pgm?Lang=E&SP_Action=Sub&SP_ID=2244&SP_Mode=2

Also, Section 2.1 of the following analytical study ("A Portrait of Entrants and Exits", Cat. no. 11F0019MPE No. 121) may be of interest to your client:

http://www.statcan.gc.ca/pub/11f0019m/11f0019m1999121-eng.pdf

Survey on Financing of Small and Medium Enterprises, 2007

Question


I know this has just been released, but any possibility of getting this or previous years through the DLI? I have an SME researcher that I know will be asking.

Answer
This is another survey for which no standard data products were released. I have asked the author division if they are willing to provide the DLI with any cross-tabulations and will keep you posted.

***
The contact for this survey explained that aggregate data is available upon request, free of charge, from the division. However, it is also being made available through Industry Canada's website. I checked their site and found the following under the "SME Financing Data Initiative" section of the site:

http://www.sme-fdi.gc.ca/eic/site/sme_fdi-prf_pme.nsf/eng/h_01570.html

Anyone can request the data (free of charge, in PDF or Excel formats) for 2000, 2001, 2004 and 2007 through this site, which also contains other information on SME Financing that may be of interest to your researcher.

Survey on Financing of Co-Operatives

Question

My colleague was working with these files and made the following observation:

On the just released Survey on Financing of Co-operatives, 2007, the
data are in these two files, English and French.

efco2007dat.xls H1, H2. Caractéristiques des coopératives,
selon les valeurs moyennes de l’actif et du
passif de la coopérative, Canada, 2008

sfco2007dat.xls H1, H2. Characteristics of co-operatives, by
average assets and liabilities of
co-operatives,
Canada, 2008

If one of these files said 2008, I would assume it was a typo. However,
both say 2008, so either the title of the survey is wrong or the file
descriptions are wrong.

Answer
Since the survey was conducted in February and March of 2008, so the
2007 must refer to the reference year, and one way or another, both
years are correct.

However, the real problem with the file description is that the file
contains not only table H1, H2, but a total of about 40 tables, of which
H1, H2 is only the last sheet. I have a list of the titles of all the
English language tables (sorry, haven't checked the French file) at:
http://www.chass.utoronto.ca/datalib/inventory/3000/3816.htm
under the Notes section, should anyone find it useful.

The SME Data Warehouse

Question

I have a researcher who would like to know how to gain access to the Small and Medium Enterprise  Data Warehouse. Any possibilities through the DLI?

Answer

I looked into the SME Data Warehouse and found out the following from the main survey page:

"No SME Data Warehouse microdata are accessible by the public. All counts are aggregated"
http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=5157?=en&db=imdb&adm=8&dis=2

And, from the Daily release:

"Custom tabulations are available through Small Business and Special Surveys Division on a cost recovery basis."
http://www.statcan.gc.ca/daily-quotidien/080710/dq080710c-eng.htm

Therefore, I have asked the division whether they would be willing to provide us with some of the aggregate data that is normally only available through cost recovery. I will let you know if I receive a positive response.