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 (.xls), a comma separated values file (.csv), and as a flat text file (.txt). Click the links below to download.

DOWNLOAD: XLS CSV TXT

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

QCEW Aggregation Level Codes (a) for NAICS Coded Data
Level Code Aggregation Level Notes
10 National, Total Covered
11 National, Total -- by ownership sector
12 National, by Domain -- by ownership sector (b)
13 National, by Supersector -- by ownership sector (c)
14 National, by NAICS Sector -- by ownership sector (c)
15 National, by NAICS 3-digit -- by ownership sector
16 National, by NAICS 4-digit -- by ownership sector
17 National, by NAICS 5-digit -- by ownership sector
18 National, by NAICS 6-digit -- by ownership sector
21 National, Private, total, by establishment size class Private Sector Only (d)
22 National, Private, Domain, by establishment size class Private Sector Only (d)
23 National, Private, by Supersector, by establishment size class Private Sector Only (d)
24 National, Private, NAICS Sector, by establishment size class Private Sector Only (d)
25 National, Private, NAICS 3-digit, by establishment size class Private Sector Only (d)
26 National, Private, NAICS 4-digit, by establishment size class Private Sector Only (d)
27 National, Private, NAICS 5-digit, by establishment size class Private Sector Only (d)
28 National, Private, NAICS 6-digit, by establishment size class Private Sector Only (d)
30 CMSA or CSA, Total Covered (e)
40 MSA, Total Covered (f)
41 MSA, Total -- by ownership sector (f)
42 MSA,Private, by Domain Private Sector Only (b) (f)
43 MSA, Private, by Supersector Private Sector Only (c) (f)
44 MSA, Private, by NAICS Sector Private Sector Only (c) (f)
45 MSA, Private, by NAICS 3-digit Private Sector Only (f)
46 MSA, Private, by NAICS 4-digit Private Sector Only (f)
47 MSA, Private, by NAICS 5-digit Private Sector Only (f)
48 MSA, Private, by NAICS 6-digit Private Sector Only (f)
50 Statewide, Total Covered -
51 Statewide, Total -- by ownership sector -
52 Statewide, by Domain -- by ownership sector (b)
53 Statewide, by Supersector -- by ownership sector (c)
54 Statewide, NAICS Sector -- by ownership sector (c)
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 (d)
62 Statewide, Private, Domain, by establishment size class Private Sector Only (b) (d)
63 Statewide, Private, by Supersector, by establishment size class Private Sector Only (c) (d)
64 Statewide, Private, NAICS Sector, by establishment size class Private Sector Only (c) (d)
70 County, Total Covered -
71 County, Total -- by ownership sector -
72 County, by Domain -- by ownership sector (b)
73 County, by Supersector -- by ownership sector (c)
74 County, NAICS Sector -- by ownership sector (c)
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 (g)
91 Total, all U.S. MSAs
92 Total, all U.S. CMSAs or all U.S. CSAs
93 Total, all U.S. non-MSA counties
94 Total U.I. Covered (U.S.)
95 Total Government (U.S.)
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 (.xls), a comma separated values file (.csv), and as a flat, text file (.txt). Click the links below to download.

DOWNLOAD: XLS CSV TXT


QCEW Aggregation Level(a) Codes as Matrix
Geographic /
Size Level
Code Format
National National,
by size (d)
CSA (e) MSA (f) Statewide Statewide
by size
County MicroSA (g)
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 (b) ,
by Ownership
x2 12 22 - 42 52 62 72 -
SuperSector (c),
by Ownership
x3 13 23 - 43 53 63 73 -
Sector (c),
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 (.xls), a comma separated values file (.csv), and as a flat, text file (.txt). Click the links below to download.

DOWNLOAD: XLS CSV TXT


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


Notes:

(a) Many levels of aggregation provide data for one of several ownership sectors, such as Federal Government, State Government, Local Government, or the Private sector.

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

(c) 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.

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

(e) 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.

(f) Industry breakouts for MSAs are only done for private ownership cells.

(g) Micropolitan Statistical Areas (MicroSAs) are Core Based Statistical Area aggregates defined since 2003.

 

Last Modified Date: March 24, 2014