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 Data Types and Titles (For SIC Coded Data)
QCEW data in the BLS publication database makes use of datatype codes to support extract queries. The codes in the table below may be of interest to those who use the series report tool or the public API interface to access that database. In contrast, the QCEW online data files have multiple datatypes on each record, so the datatype is identified by the position within the record. However, some versions of those files contain a zero filled datatype field so that the record identifier closely matches the data identifier in the publication database. This may be helpful for users to correlate data from the publication database with corresponding data from the data files.
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; QCEW Data Files; Open Data Access Guide;
| Data Type | Title |
|---|---|
| 1 | All Employees |
| 2 | Number of Establishments |
| 3 | Total Wages (in thousands) |
| 4 | Average Weekly Wage |
| 5 | Average Annual Pay |
| 6 | Quarterly Average Monthly Employment |
Last Modified Date: September 15, 2020