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 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;
| 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 employment 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 employment 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 employment 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: September 24, 2020