Department of Labor Logo United States Department of Labor
Dot gov

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.

Https

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

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;  

DOWNLOAD: XLSX CSV TXT

QCEW SIC-Based CSV Quarterly Files Field Table

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: September 23, 2020