An official website of the United States government
United States Department of Labor
United States Department of Labor
The .gov means it's official.
Federal government websites often end in .gov or .mil. Before sharing sensitive information,
make sure you're on a federal government site.
The site is secure.
The
https:// ensures that you are connecting to the official website and that any
information you provide is encrypted and transmitted securely.
Quarterly Census of Employment and Wages
SHARE ON:
QCEW County High-Level Layouts
The tables below describe the field layouts for the County high-level Excel Workbooks. There are two formats, one for workbooks with quarterly data, and one for workbooks with annual data. These Excel files are available from the historical NAICS-Based Data Files Table. Data for Puerto Rico and the Virgin Islands is stored on a second worksheet within each workbook. Data for the U.S. is repeated on the second worksheet as a convenience to users.
County High-Level Quarterly Layout
This table describes the field layout for county high-level workbooks containing quarterly data. The table 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.
Related Documentation: QCEW Data Guide; Documentation Guide;
| Field Number | Column Letter | Field Name | Column Display | Field Description |
|---|---|---|---|---|
| 1 | A | Area Code | hidden | 5-character FIPS code |
| 2 | B | St | hidden | 2-character State FIPS code |
| 3 | C | Cnty | hidden | 3-character County FIPS code |
| 4 | D | Own | hidden | 1-character Ownership code |
| 5 | E | NAICS | hidden | 4-character Industry code (SuperSector) |
| 6 | F | Year | visible | 4-digit year |
| 7 | G | Qtr | visible | 1-character quarter (always A for annual) |
| 8 | H | Area Type | visible | Category of the given area. (State, County, Nation, etc.…) |
| 9 | I | St Name | visible | Multi-character State name |
| 10 | J | Area | visible | Area title associated with the area's FIPS code |
| 11 | K | Ownership | visible | Ownership title associated with the ownership code |
| 12 | L | Industry | visible | Industry title associated with the industry code |
| 13 | M | Status Code | visible | Status code, or disclosure code ('N' for not disclosed) |
| 14 | N | Establishment Count | visible | Quarterly establishment counts for a given quarter |
| 15 | O | Month 1 Employment | visible | Employment level for the first month of the quarter. The name of the month is displayed. (EX: January) |
| 16 | P | Month 2 Employment | visible | Employment level for the second month of the quarter. The name of the month is displayed. (EX: February) |
| 17 | Q | Month 3 Employment | visible | Employment level for the third month of the quarter. The name of the month is displayed. (EX: March) |
| 18 | R | Total Quarterly Wages | visible | Total quarterly wage level for the given quarter |
| 19 | S | Average Weekly Wage | visible | Average weekly wage based on the 12-monthly employment levels and total annual wage levels |
| 20 | T | Employment Location Quotient Relative to U.S. | visible | Employment Location Quotient Relative to U.S. (more...) |
| 21 | U | Total Wage Location Quotient Relative to U.S. | visible | Total Wage Location Quotient Relative to U.S. (more...) |
County High-Level Annual Layout
This table describes the field layout for county high-level workbooks containing annual averages. The table 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.
| Field Number | Column Letter | Field Name | Column Display | Field Description |
|---|---|---|---|---|
| 1 | A | Area Code | hidden | 5-character FIPS code |
| 2 | B | St | hidden | 2-character State FIPS code |
| 3 | C | Cnty | hidden | 3-character County FIPS code |
| 4 | D | Own | hidden | 1-character Ownership code |
| 5 | E | NAICS | hidden | 4-character Industry code (SuperSector) |
| 6 | F | Year | visible | 4-digit year |
| 7 | G | Qtr | visible | 1-character quarter (always A for annual) |
| 8 | H | Area Type | visible | Category of the given area. (State, County, Nation, etc.…) |
| 9 | I | St Name | visible | Multi-character State name |
| 10 | J | Area | visible | Area title associated with the area's FIPS code |
| 11 | K | Ownership | visible | Ownership title associated with the ownership code. |
| 12 | L | Industry | visible | Industry title associated with the industry code. |
| 13 | M | Annual Average Status Code | visible | Status code, or disclosure code ('N' for not disclosed) |
| 14 | N | Annual Average Establishment Count | visible | Annual average of quarterly establishment counts for a given year |
| 15 | O | Annual Average Employment | visible | Annual average of monthly employment levels for a given year |
| 16 | P | Annual Total Wages | visible | Sum of the four quarterly total wage levels for a given year |
| 17 | Q | Annual Average Weekly Wage | visible | Average weekly wage based on the 12-monthly employment levels and total annual wage levels |
| 18 | R | Annual Average Pay | visible | Average annual pay based on employment and wage levels for a given year |
| 19 | S | Employment Location Quotient Relative to U.S. | visible | Employment Location Quotient Relative to U.S. (more...) |
| 20 | T | Total Wage Location Quotient Relative to U.S. | visible | Total Wage Location Quotient Relative to U.S. (more...) |
Last Modified Date: September 23, 2020