QCEW Aggregation Level Codes

These are the codes used on summary records produced by the Quarterly Census of Employment and Wages (QCEW) program to indicate the aggregation level of the data summarized on the record. These aggregation level codes are for QCEW records coded to the North American Industry Classification System (NAICS).

The table below is available as an Excel workbook (.xlsx), a comma separated values file (.csv), and as a flat text file (.txt). Click the links below to download.

DOWNLOAD: XLSX CSV TXT

Related Documentation:   QCEW Data Guide;   Documentation Guide;   Open Data Access Guide;   QCEW Data Files;  

QCEW Aggregation Level Codes (a) for NAICS Coded Data
Level Code Aggregation Level Notes
10 National, Total Covered (b)
11 National, Total -- by ownership sector (b)
12 National, by Domain -- by ownership sector (b,c)
13 National, by Supersector -- by ownership sector (b,d)
14 National, by NAICS Sector -- by ownership sector (b,d)
15 National, by NAICS 3-digit -- by ownership sector (b)
16 National, by NAICS 4-digit -- by ownership sector (b)
17 National, by NAICS 5-digit -- by ownership sector (b)
18 National, by NAICS 6-digit -- by ownership sector (b)
21 National, Private, total, by establishment size class Private Sector Only (b,e)
22 National, Private, Domain, by establishment size class Private Sector Only (b,e)
23 National, Private, by Supersector, by establishment size class Private Sector Only (b,e)
24 National, Private, NAICS Sector, by establishment size class Private Sector Only (b,e)
25 National, Private, NAICS 3-digit, by establishment size class Private Sector Only (b,e)
26 National, Private, NAICS 4-digit, by establishment size class Private Sector Only (b,e)
27 National, Private, NAICS 5-digit, by establishment size class Private Sector Only (b,e)
28 National, Private, NAICS 6-digit, by establishment size class Private Sector Only (b,e)
30 CMSA or CSA, Total Covered (f)
40 MSA, Total Covered (g)
41 MSA, Total -- by ownership sector (g)
42 MSA,Private, by Domain Private Sector Only (c,g)
43 MSA, Private, by Supersector Private Sector Only (d,g)
44 MSA, Private, by NAICS Sector Private Sector Only (d,g)
45 MSA, Private, by NAICS 3-digit Private Sector Only (g)
46 MSA, Private, by NAICS 4-digit Private Sector Only (g)
47 MSA, Private, by NAICS 5-digit Private Sector Only (g)
48 MSA, Private, by NAICS 6-digit Private Sector Only (g)
50 Statewide, Total Covered -
51 Statewide, Total -- by ownership sector -
52 Statewide, by Domain -- by ownership sector (c)
53 Statewide, by Supersector -- by ownership sector (d)
54 Statewide, NAICS Sector -- by ownership sector (d)
55 Statewide, NAICS 3-digit -- by ownership sector -
56 Statewide, NAICS 4-digit -- by ownership sector -
57 Statewide, NAICS 5-digit -- by ownership sector -
58 Statewide, NAICS 6-digit -- by ownership sector -
61 Statewide, Private, total, by establishment size class Private Sector Only (e)
62 Statewide, Private, Domain, by establishment size class Private Sector Only (c,e)
63 Statewide, Private, by Supersector, by establishment size class Private Sector Only (d,e)
64 Statewide, Private, NAICS Sector, by establishment size class Private Sector Only (d,e)
70 County, Total Covered -
71 County, Total -- by ownership sector -
72 County, by Domain -- by ownership sector (c)
73 County, by Supersector -- by ownership sector (d)
74 County, NAICS Sector -- by ownership sector (d)
75 County, NAICS 3-digit -- by ownership sector -
76 County, NAICS 4-digit -- by ownership sector -
77 County, NAICS 5-digit -- by ownership sector -
78 County, NAICS 6-digit -- by ownership sector -
80 MicroSA, Total Covered (h)
91 Total, all U.S. MSAs (b)
92 Total, all U.S. CMSAs or all U.S. CSAs (b)
93 Total, all U.S. non-MSA counties (b)
94 Total U.I. Covered (U.S.) (b)
95 Total Government (U.S.) (b)
96 Total Government, by State -

Aggregation Level Codes Matrix

This table shows the main aggregation level codes as a matrix. Tabular presentation may be useful to some users. This table is also available as an Excel workbook (.xlsx), a comma separated values file (.csv), and as a flat, text file (.txt). Click the links below to download.

DOWNLOAD: XLSX CSV TXT
QCEW Aggregation Level(a) Codes as Matrix
Geographic/
Size Level
Code Format
National
(b)
National (b),
by size (e)
CSA (f) MSA (g) Statewide Statewide
by size
County MicroSA (h)
Industry
Ownership Level
1x 2x 3x 4x 5x 6x 7x 8x
Total,
All Ownerships
x0 10 - 30 40 50 - 70 80
Total,
by Ownership
x1 11 21 - 41 51 61 71 -
Domain (c),
by Ownership
x2 12 22 - 42 52 62 72 -
SuperSector (d),
by Ownership
x3 13 23 - 43 53 63 73 -
Sector (d),
by Ownership
x4 14 24 - 44 54 64 74 -
3-digit,
by Ownership
x5 15 25 - 45 55 - 75 -
4-digit,
by Ownership
x6 16 26 - 46 56 - 76 -
5-digit,
by Ownership
x7 17 27 - 47 57 - 77 -
6-digit,
by Ownership
x8 18 28 - 48 58 - 78 -

Special Aggregation Levels

This table shows a small number of special aggregation levels that have only a few data cells overall. These levels are cited in various news releases and publications. This table is also available as an Excel workbook (.xlsx), a comma separated values file (.csv), and as a flat, text file (.txt). Click the links below to download.

DOWNLOAD: XLSX CSV TXT
QCEW Special Aggregation Level Codes for NAICS Coded Data
Level Code Aggregation Level Notes
91 Total, all U.S. MSAs (b)
92 Total, all U.S. CMSAs or all U.S. CSAs (b)
93 Total, all U.S. non-MSA counties (b)
94 Total U.I. Covered (U.S.) (b)
95 Total Government (U.S.) (b)
96 Total Government, by State -


Notes:

(a) Many levels of aggregation provide data for one or several ownership sectors, such as Federal Government, State Government, Local Government, or the Private sector. See www.bls.gov/cew/doc/titles/ownership/ownership_titles.htm for information on QCEW ownership coding.

(b) National level aggregations exclude Puerto Rico and Virgin Islands from the totals.

(c) Domain refers to the division of all economic activity into 2 domains, Goods-producing and Service-Producing.

(d) SuperSector refers to the 10 Alternate aggregation sectors defined by the BLS Office of Employment and Unemployment Statistics under the guidelines of the U.S. Economic Classification Policy Committee. Sector refers to the 20 standard sectors defined under NAICS.

(e) Aggregation by size of establishment is done for private ownership cells only.

(f) Combined Statistical Areas (CSAs) are Core Based Statistical Area aggregates defined since 2003. Consolidated Metropolitan Statistical Areas (CMSAs) were combinations of Metropolitan Statistical Areas (MSAs) defined under the pre-2003 area delineations. See www.bls.gov/cew/doc/titles/area/area_guide.htm for a discussion of the CSA and CBSA delineations used by the QCEW program.

(g) Industry breakouts for MSAs are only done for private ownership cells. See www.bls.gov/cew/doc/titles/area/area_guide.htm for a discussion of the MSA delineations used by the QCEW program.

(h) Micropolitan Statistical Areas (MicroSAs) are Core Based Statistical Area aggregates defined since 2003. See www.bls.gov/cew/doc/titles/area/area_guide.htm for afor a discussion of the MicroSA delineations used by the QCEW program.

 

Last Modified Date: December 2, 2014