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 Field Layouts for SIC-Based, Quarterly CSV Files
This table describes the file layout for SIC-based, quarterly CSV files. There are four types of quarterly CSV files. There are by-area, by-industry, singlefile, and size files. These files are available from the historical SIC-Based Data Files Table. The quarterly CSV files have several title fields. These fields, fields #9 through #13, are excluded from the singlefiles. The SIC codes are stored in these files with an "SIC_" prefix. This prefix extends the length of the industry_code field to 10 characters.
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.
Related Documentation: QCEW Data Guide; Documentation Guide;
| Field Number | Field Name | Data Type | Maximum Length | Field Description |
|---|---|---|---|---|
| 1 | area_fips | Text | 5 | 5-character FIPS code |
| 2 | own_code | Numeric | 1 | 1-digit Ownership code |
| 3 | industry_code | Text | 10 | 10-character Industry Code (SIC) |
| 4 | agglvl_code | Numeric | 2 | 2-digit aggregation level code |
| 5 | size_code | Numeric | 1 | 1-digit size code |
| 6 | year | Numeric | 4 | 4-digit year |
| 7 | qtr | Text | 1 | 1-character quarter (always A for annual) |
| 8 | disclosure_code | Text | 1 | 1-character disclosure code (either ' '(blank) or 'N' not disclosed) |
| 9 | area_title | Text | 80 | Multi-character area title associated with the area's FIPS (Excluded from singlefile) |
| 10 | own_title | Text | 80 | Multi-character ownership title associated with the ownership code (Excluded from singlefile) |
| 11 | industry_title | Text | 80 | Multi-character industry title associated with the industry code (Excluded from singlefile) |
| 12 | agglvl_title | Text | 80 | Multi-character aggregation title associated with the agglvl code (Excluded from singlefile) |
| 13 | size_title | Text | 80 | Multi-character size title associated with the size code (Excluded from singlefile) |
| 14 | qtrly_estabs_count | Numeric | 8 | Count of establishments for a given quarter |
| 15 | month1_emplvl | Numeric | 9 | Employment level for the first month of a given quarter |
| 16 | month2_emplvl | Numeric | 9 | Employment level for the second month of a given quarter |
| 17 | month3_emplvl | Numeric | 9 | Employment level for the third month of a given quarter |
| 18 | total_qtrly_wages | Numeric | 15 | Total wages for a given quarter |
| 19 | taxable_qtrly_wages | Numeric | 15 | Taxable wages for a given quarter |
| 20 | qtrly_contributions | Numeric | 13 | Quarterly contributions for a given quarter |
| 21 | avg_wkly_wage | Numeric | 8 | Average weekly wage for a given quarter |
Last Modified Date: April 5, 2022