Monday, March 26, 2018

New dedicated mailboxes


Good day DLI / RTRA /PUMF Collection users,

In an effort to better track and manage our client requests the (DLI team / RTRA team / PUMF collection team) is changing the way we communicate with our community. We have created a new dedicated mailbox for all future communications and requests.

MAD DLI / DAM IDD (STATCAN) statcan.maddli-damidd.statcan@canada.ca
MAD RTRA / DAM ADTR ( STATCAN) statcan.madrtra-damadtr.statcan@canada.ca
MAD PUMF / DAM FMGD (STATCAN) statcan.madpumf-damfmgd.statcan@canada.ca
MAD-TravelDLI/DAM-VoyageIDD(STATCAN):statcan.mad-traveldli-dam-voyageidd.statcan@canada.ca
MAD-Invoice-DLI/DAM-Facture-IDD (STATCAN): statcan.mad-invoice-dlidam-facture-idd.statcan@canada.ca

Our team respectfully requests our clients withstand from writing to individual team members. The new mailbox is monitored by all team members and will help coverage in the advent of absences and vacations. These changes will be reflected on the website shortly.

**To DLI Only. Please note this does not replace the DLI Listserv.: DLILIST@IDD-DLI.STATCAN.GC.CA Please continue to ask questions and share your research.

** To PUMF only. Please note this does not replace the PUMF Listserv : PUMF-FMGD@IDD-DLI.STATCAN.GC.CA

Best,
Data Liberation Initiative (DLI)

Thursday, March 22, 2018

ADA linkage in the PCCF

Question:
I've been using the PCCF[2017] and don't see a field for the ADA in the record layout in the Reference Guide.  So, is there a linkage for the ADA in the 2017 PCCF?  

Answer:
The DA boundary file does have an ADA field containing the corresponding ADA. So, you can use that table to add the matching ADAs to your records that have been geocoded to the DA level by the PCCF. Hope that makes sense.

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, March 15, 2018

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.


Tuesday, March 13, 2018

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.



Friday, March 9, 2018

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