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.
