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
PRINT:Print
QCEW HOME QCEW PROGRAM HOMEPAGE

QCEW Field Layouts for NAICS-Based, Quarterly CSV Files

This table describes the file layout for NAICS-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 NAICS-Based Data Files Table. The quarterly CSV files have several title fields. These fields, fields #9 through #13, are excluded from the singlefiles.

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 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 Text 1 1-character ownership code
3 industry_code Text 6 6-character industry code (NAICS, SuperSector)
4 agglvl_code Text 2 2-character aggregation level code
5 size_code Text 1 1-character size code
6 year Text 4 4-character 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 code (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 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
22 lq_disclosure_code Text 1 1-character location-quotient disclosure code (either ' '(blank) or 'N' not disclosed
23 lq_qtrly_estabs Numeric 8 Location quotient of the quarterly establishment count relative to the U.S. (Rounded to the hundredths place)
24 lq_month1_emplvl Numeric 8 Location quotient of the emloyment level for the first month of a given quarter relative to the U.S. (Rounded to the hundredths place)
25 lq_month2_emplvl Numeric 8 Location quotient of the emloyment level for the second month of a given quarter relative to the U.S. (Rounded to the hundredths place)
26 lq_month3_emplvl Numeric 8 Location quotient of the emloyment level for the third month of a given quarter relative to the U.S. (Rounded to the hundredths place)
27 lq_total_qtrly_wages Numeric 8 Location quotient of the total wages for a given quarter relative to the U.S. (Rounded to the hundredths place)
28 lq_taxable_qtrly_wages Numeric 8 Location quotient of the total taxable wages for a given quarter relative to the U.S. (Rounded to the hundredths place)
29 lq_qtrly_contributions Numeric 8 Location quotient of the total contributions for a given quarter relative to the U.S. (Rounded to the hundredths place)
30 lq_avg_wkly_wage Numeric 8 Location quotient of the average weekly wage for a given quarter relative to the U.S. (Rounded to the hundredths place)
31 oty_disclosure_code Text 1 1-character over-the-year disclosure code (either ' '(blank) or 'N' not disclosed)
32 oty_qtrly_estabs_chg Numeric 8 Over-the-year change in the count of establishments for a given quarter
33 oty_qtrly_estabs_pct_chg Numeric 8 Over-the-year percent change in the count of establishments for a given quarter (Rounded to the tenths place)
34 oty_month1_emplvl_chg Numeric 9 Over-the-year change in the first month's employment level of a given quarter
35 oty_month1_emplvl_pct_chg Numeric 8 Over-the-year percent change in the first month's employment level of a given quarter (Rounded to the tenths place)
36 oty_month2_emplvl_chg Numeric 9 Over-the-year change in the second month's employment level of a given quarter
37 oty_month2_emplvl_pct_chg Numeric 8 Over-the-year percent change in the second month's employment level of a given quarter (Rounded to the tenths place)
38 oty_month3_emplvl_chg Numeric 9 Over-the-year change in the third month's employment level of a given quarter
39 oty_month3_emplvl_pct_chg Numeric 8 Over-the-year percent change in the third month's employment level of a given quarter (Rounded to the tenths place)
40 oty_total_qtrly_wages_chg Numeric 15 Over-the-year change in total quarterly wages for a given quarter
41 oty_total_qtrly_wages_pct_chg Numeric 8 Over-the-year percent change in total quarterly wages for a given quarter (Rounded to the tenths place)
42 oty_taxable_qtrly_wages_chg Numeric 15 Over-the-year change in taxable quarterly wages for a given quarter
43 oty_taxable_qtrly_wages_pct_chg Numeric 8 Over-the-year percent change in taxable quarterly wages for a given quarter (Rounded to the tenths place)
44 oty_qtrly_contributions_chg Numeric 13 Over-the-year change in quarterly contributions for a given quarter
45 oty_qtrly_contributions_pct_chg Numeric 8 Over-the-year percent change in quarterly contributions for a given quarter (Rounded to the tenths place)
46 oty_avg_wkly_wage_chg Numeric 8 Over-the-year change in average weekly wage for a given quarter
47 oty_avg_wkly_wage_pct_chg Numeric 8 Over-the-year percent change in average weekly wage for a given quarter (Rounded to the tenths place)

 

Last Modified Date: April 27, 2015