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

 

CansimT#s 079-0003/079-0004

Question:
Instead of BC and the Territories lumped together in CansimT#s 079-0003/079-0004, could i/we have just BC and combine the Territories? To not have BC separate, as Canada’s 3rd most populous province, is highly unusual.

Answer:
A while back the Territories did not have the economy to support major dealership networks and most automobiles were purchased from either BC or Alberta.  Today there are some dealerships in the territories and their values are very small and would be confidential.  This would then mean we would have to suppress a larger province to hide the confidential units.  We combine BC with the territories as most of the sales came from BC when there were fewer dealers in the Territories.


Other major Canadian automotive data sources outside of Statistics Canada also combine sales of vehicles from the territories in the provinces.

Job counts by 5-digit NAICS codes for CMAs

Question:
A student is looking for job counts by CMAs, but at a precision of 5 digit codes for the two following codes:

541515
511212

The best table I could find so far is CANSIM 282-0131 which only provides 2-digit codes.

In the past we had data table that had 4-digit NAICS job counts for DLI based on the Annual Estimates of Employment, Earnings and Hours but that stopped with 2007 data. Also it only provide data at the provincial level I believe.

 Is there something better available? Or is it a case of custom tabulation?

Answer:
To start, that is correct, Survey of Employment, Payrolls and Hours (SEPH) does not publish data any more detailed than at the provincial and at the 4-digit NAICS level.

You are also correct that 2-digit NAICS is as detailed as it gets for the Labour Force Survey (LFS) on CANSIM.

Alternatively, a custom LFS cross-tabulation can be purchased at the 4-digit NAICS level and by CMA geography. However, a data extraction exercise at those levels has shown that 87.9 % of cells are suppressed for NAICS code 5112 and  33% for NAICS code 5415, rendering the data of following CMAs unpublishable as per the confidentiality requirements of the Statistics Act:

- Saguenay
- Trois-Rivières
- Kingston
- Greater Sudbury
- St. Catharines - Niagara
- Thunder Bay
- Abbotsford-Mission
- Peterborough
- Brantford
- Guelph
- Kelowna

If the student insists in pursuing a custom tabulation alternative, regardless of suppression levels, there would be a cost associated with production and turnaround would be less than a week.

Police Administration Survey

Question:
I have a researcher looking for the educational attainment of new recruits for the Toronto Police Service for the last 12 years. The data appears to be collected by the Supplemental Police Administration Survey. Does anyone have any advice on where I can find this? Would this be a custom tabulation?

Answer:
Indeed, the data would have to be acquired through a custom tabulation.

A few clarifications:

*Although the researcher is looking for data for the last 12 years, the data for education only started to be collected in 2012, and for the Toronto Police Service, data is only available from 2014 onward (2014 – 2016).

*If the researcher is interested, the concept of “new recruits” should be clarified; from what I’ve gathered, the survey collected information on recruit graduates (paid personnel engaged in a training program); it does not include recruits not getting paid for their training (which happens).

*There are some small numbers, which would result in a moderate amount of suppression. Therefore, data for 2014, 2015 and 2016 could be provided with these suppressions.

Teacher's Guide to Data Discovery 12-593

Question:

Re:  http://www5.statcan.gc.ca/olc-cel/olc?ObjId=12-593-X2010001&ObjType=46&lang=en

It seems odd that this publication is on the web and it indicates that it is archived.  In fact, there is no longer any link to an archive.

I have a paper copy of the publication and I think it may be at the U of A but I haven't had a chance to look for it yet.  It's not an urgent matter, but it is curious.

Answer:
There is a link to this publication in the following catalogue:

pubs.gc.ca page in our catalogue, with link to archived-content page: http://publications.gc.ca/site/archivee-archived.html?url=http://publications.gc.ca/collections/collection_2010/statcan/12-593-X/12-593-x2010001-eng.pdf

PDF of the document itself: http://publications.gc.ca/collections/collection_2010/statcan/12-593-X/12-593-x2010001-eng.pdf

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

Missing Values in NHS Individuals PUMF

Question:
For the WAGES variable in the NHS individuals PUMF, why are "not available" and "not applicable" not declared as missing values? The codebook states that:

"The value 8,888,888 stands for not available. The value 9,999,999 stands for not applicable and is applied to all persons aged less than 15 years"

Leaving those values (which constitute over 17% of the cases) subject to calculation would seem to skew the results rather significantly, would they not?


Answer:

B Estimation
Note: Users must refrain from publishing unweighted estimates and from conducting analyses based on unweighted data from the file because the unweighted results do not represent the population but
only describe the sample. They must also make sure to exclude values of study variables that are not applicable or not available from their calculations because those values might be considered as valid observed values by the statistical software when they are not. For example, values such as 9,999,999 or 8,888,888 for a numeric (or quantitative) variable would be interpreted as valid observed values but should be considered as nominal values indicating these values are not usable in estimation.

Example 4:
We want to estimate the average total income of women aged 15 years and over living in Ontario who
have an income. In the calculation of the numerator, WEIGHT is multiplied by the value of the 'total income' variable for individuals with an income (where TOTINC ^= 8,888,888, TOTINC ^= 9,999,999, TOTINC ^= 0) whose gender is female (SEX = 1) and who are aged 15 or over (AGEGRP ≥ 6, AGEGRP ^= 88) in the province of Ontario (PR = 35); the results are then totalled. To estimate the average, the numerator (or estimated total income) is divided by the sum of WEIGHT for individuals satisfying the same conditions on TOTINC, SEX, AGEGRP and PR.
The result obtained is: $179,154,359,345 / 5,072,260 = $35,320, which means the average total income of women aged 15 and over living in Ontario who have an income is around $35,320.
B.2.b.3 Estimator of a ratio
A ratio can be defined as the division of two amounts, which could be two totals or two averages

Example these counts are included
8888 Not available (unweighted) 13,676 - (Weighted) 483,013
9999 Not applicable Canadian citizens by birth and non-permanent residents (unweighted) 697,600 – (Weighted) 26,060,226