Thursday, March 21, 2019

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

CHMS obesity data

Question:
I have a researcher who is looking for data from the CHMS on obesity.

They are hoping to have the data from this table for 2007 (this table only has data between 2009-2017)

Table  13-10-0373-01   Overweight and obesity based on measured body mass index, by age group and sex

Answer:
We’ve received the following response from subject matter:
“In the table provided, you can look at footnote 2, it reads ‘’Data from the Canadian Health Measures Survey are collected over a two-year period from a sample of approximately 5,700 respondents. Cycle 1 data collected from March 2007 to February 2009. Cycle 2 data collected from August 2009 to December 2011. Data collected from January to December of the following year for subsequent cycles.”


Unfortunately we were restricted with the naming of the columns, therefore the 2009 column includes all of Cycle 1, which was collected from March 2007 to February 2009.”

Tuesday, March 19, 2019

Does Nesstar's Master Files metadata fall under the Open Licence?

Question:
We're making some updates to address the Statistics Canada Open Licence and we've realized that we're not entirely sure if it covers the metadata for Master Files as available in Nesstar not.

Are Master File metadata covered by the Open Licence? Is there any content in Nesstar that Dal users would not be allowed to share with collaborators from outside the DLI community? We understand that PUMFs in Nesstar are covered by the Open Licence, and that access to Nesstar itself is restricted to the DLI community.

Answer:
Master Files would be covered under the Open Licence.

“From the DLI Licence: the majority of our standard and custom products will be disseminated under the terms and conditions of the Statistics Canada Open Licence Agreement. (See: Statistics Canada Open Licence Agreement).”

Zero-frequency codebooks would be included under this.


Unless there’s something in Nesstar that I’ve missed, I suspect it would all be covered. You are correct however regarding Nesstar itself being a DLI-use product only.

Monday, March 18, 2019

1971 Census Place Name Reference list[s]

Question:
Bonjour/Hello,

Is there a digital version of 1971 Census Place Name Reference list[s]?

It does not appear to be in Internet Archive.
According to WorldCat only UofA has the print;
http://www.library.ualberta.ca/permalink/opac/2120051/WUAARCHIVE

There is also the 1981
http://publications.gc.ca/collections/collection_2017/statcan/CS94-902-1981.pdf 
http://publications.gc.ca/collections/collection_2017/statcan/CS94-903-1981.pdf 
http://publications.gc.ca/collections/collection_2017/statcan/CS94-904-1981.pdf

but 1971 is needed.

Answer:
The StatCan library has volume 2, and we think we can track down volume 1 as well, however neither are digital versions. The only option would be to have them manually scanned. Before asking them to do this I just want to confirm if you’d like a scanned copy, and need both versions in their entirety? (or just a specific portion?)

I’ve placed both documents in the EFT. Please let me know when you’ve had a chance to grab them and I’ll remove the folder. Please also confirm if you require anything more than what is provided in the original document.

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

StatsCanada: Joe Anonymous: The path to confidentiality / Jean Anonyme: le parcours vers la confidentialité

We wanted to share the following YouTube video that helps describe how we protect your information. https://www.youtube.com/watch?v=lBcQ9v5jYGc&t=2s&app=desktop

SPSD/M Version 27.0.1 / BD/MSPS version 27.0.1

A new version of SPSD/M has been uploaded to the EFT at: /MAD_SPSDM_BDMSPS_DAM/Root/27.0.1. Please use this version as a replacement for version 27.0.