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 EWB Files (SIC-Based)

This table describes the file layout for SIC-based EWB(.ewb) files. These files are available from the historical SIC-Based Data Files table. QCEW provides formatting tools which help format these 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.

Related Documentation:   QCEW Data Guide;   Documentation Guide;  

DOWNLOAD: XLSX CSV TXT

QCEW Field Layouts for EWB Files (For SIC Coded Data)

Field
Number
Field
Title
Field
Name
Data
Type
Start
Position
End
Position
Field
Length
1 Survey Prefix prefix Text 1 3 3
2 Area Code area_fips Text 4 8 5
3 Datatype Code datatype Text 9 9 1
4 Size Code size_code Numeric 10 10 1
5 Ownership Code own_code Text 11 11 1
6 Industry Code industry_code Text 12 17 6
7 Year year Numeric 18 21 4
8 Aggregation Level agglvl_code Numeric 22 23 2
9 First Quarter Disclosure Code q1_disclosure_code Text 24 24 1
10 First Quarter Quarterly Number of Establishments q1_estabs_count Numeric 25 32 8
11 First Quarter January Employment q1_jan_emplvl Numeric 33 41 9
12 First Quarter February Employment q1_feb_emplvl Numeric 42 50 9
13 First Quarter March Employment q1_mar_emplvl Numeric 51 59 9
14 First Quarter Total Quarterly Wages q1_total_qtrly_wages Numeric 60 74 15
15 First Quarter Taxable Quarterly Wages q1_taxable_qtrly_wages Numeric 75 89 15
16 First Quarter Quarterly Contributions q1_contributions Numeric 90 102 13
17 First Quarter Average Weekly Wage q1_avg_wkly_wage Numeric 103 110 8
18 Second Quarter Disclosure Code q2_disclosure_code Text 111 111 1
19 Second Quarter Quarterly Number of Establishments q2_estabs_count Numeric 112 119 8
20 Second Quarter April Employment q2_apr_emplvl Numeric 120 128 9
21 Second Quarter May Employment q2_may_emplvl Numeric 129 137 9
22 Second Quarter June Employment q2_jun_emplvl Numeric 138 146 9
23 Second Quarter Total Quarterly Wages q2_total_qtrly_wages Numeric 147 161 15
24 Second Quarter Taxable Quarterly Wages q2_taxable_qtrly_wages Numeric 162 176 15
25 Second Quarter Quarterly Contributions q2_contributions Numeric 177 189 13
26 Second Quarter Average Weekly Wage q2_avg_wkly_wage Numeric 190 197 8
27 Third Quarter Disclosure Code q3_disclosure_code Text 198 198 1
28 Third Quarter Quarterly Number of Establishments q3_estabs_count Numeric 199 206 8
29 Third Quarter July Employment q3_jul_emplvl Numeric 207 215 9
30 Third Quarter August Employment q3_aug_emplvl Numeric 216 224 9
31 Third Quarter September Employment q3_sep_emplvl Numeric 225 233 9
32 Third Quarter Total Quarterly Wages q3_total_qtrly_wages Numeric 234 248 15
33 Third Quarter Taxable Quarterly Wages q3_taxable_qtrly_wages Numeric 249 263 15
34 Third Quarter Quarterly Contributions q3_contributions Numeric 264 276 13
35 Third Quarter Average Weekly Wage q3_avg_wkly_wage Numeric 277 284 8
36 Fourth Quarter Disclosure Code q4_disclosure_code Text 285 285 1
37 Fourth Quarter Quarterly Number of Establishments q4_estabs_count Numeric 286 293 8
38 Fourth Quarter October Employment q4_oct_emplvl Numeric 294 302 9
39 Fourth Quarter November Employment q4_nov_emplvl Numeric 303 311 9
40 Fourth Quarter December Employment q4_dec_emplvl Numeric 312 320 9
41 Fourth Quarter Total Quarterly Wages q4_total_qtrly_wages Numeric 321 335 15
42 Fourth Quarter Taxable Quarterly Wages q4_taxable_qtrly_wages Numeric 336 350 15
43 Fourth Quarter Quarterly Contributions q4_contributions Numeric 351 363 13
44 Fourth Quarter Average Weekly Wage q4_avg_wkly_wage Numeric 364 371 8
45 Annual Disclosure Code annual_disclosure_code Text 372 372 1
46 Annual Average Number of Establishments annual_avg_estabs_count Numeric 373 380 8
47 Annual Average Employment annual_avg_emplvl Numeric 381 389 9
48 Total Annual Wages total_annual_wages Numeric 390 404 15
49 Taxable Annual Wages taxable_annual_wages Numeric 405 419 15
50 Annual Contributions annual_contributions Numeric 420 432 13
51 Annual Average Weekly Wage annual_avg_wkly_wage Numeric 433 440 8
52 Average Annual Pay avg_annual_pay Numeric 441 449 9

 

Last Modified Date: April 5th, 2022