QCEW Field Layouts for NAICS-Based, Annual CSV Files

This table describes the file layout for NAICS-based, CSV files containing annual averages. There are three types of annual CSV files. There are annual files by area, by industry, and as a singlefiles. These files are available from the historical NAICS-Based Data Files Table. The annual 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 annual_avg_estabs Numeric 8 Annual average of quarterly establishment counts for a given year
15 annual_avg_emplvl Numeric 9 Annual average of monthly employment levels for a given year
16 total_annual_wages Numeric 15 Sum of the four quarterly total wage levels for a given year
17 taxable_annual_wages Numeric 15 Sum of the four quarterly total taxable wage totals for a given year
18 annual_contributions Numeric 13 Sum of the four quarterly contribution totals for a given year
19 annual_avg_wkly_wage Numeric 8 Average weekly wage based on the 12-monthly employment levels and total annual wage levels.
20 avg_annual_pay Numeric 8 Average annual pay based on employment and wage levels for a given year.
21 lq_disclosure_code Text 1 1-character location-quotient disclosure code (either '' (blank) or 'N' not disclosed)
22 lq_annual_avg_estabs Numeric 8 Location quotient of annual average establishment count relative to the U.S. (Rounded to the hundredths place)
23 lq_annual_avg_emplvl Numeric 8 Location quotient of annual average employment relative to the U.S. (Rounded to the hundredths place)
24 lq_total_annual_wages Numeric 8 Location quotient of total annual wages relative to the U.S. (Rounded to the hundredths place)
25 lq_taxable_annual_wages Numeric 8 Location quotient of taxable annual wages relative to the U.S. (Rounded to the hundredths place)
26 lq_annual_contributions Numeric 8 Location quotient of total annual contributions relative to the U.S. (Rounded to the hundredths place)
27 lq_annual_avg_wkly_wage Numeric 8 Location quotient of annual average weekly wage relative to the U.S. (Rounded to the hundredths place)
28 lq_avg_annual_pay Numeric 8 Location quotient of annual average pay relative to the U.S. (Rounded to the hundredths place)
29 oty_disclosure_code Text 1 1-character over-the-year disclosure code (either ' '(blank) or 'N' not disclosed)
30 oty_annual_avg_estabs_chg Numeric 8 Over-the-year change in annual average establishments for a given year
31 oty_annual_avg_estabs_pct_chg Numeric 8 Over-the-year percent change in annual average establishments for a given year (Rounded to the tenths place)
32 oty_annual_avg_emplvl_chg Numeric 9 Over-the-year change in annual average employment for a given year
33 oty_annual_avg_emplvl_pct_chg Numeric 8 Over-the-year percent change in annual average employment for a given year (Rounded to the tenths place)
34 oty_total_annual_wages_chg Numeric 15 Over-the-year change in the total annual wages for a given year
35 oty_total_annual_wages_pct_chg Numeric 8 Over-the-year percent change in total annual wages for a given year (Rounded to the tenths place)
36 oty_taxable_annual_wages_chg Numeric 15 Over-the-year change in taxable annual wages for a given year
37 oty_taxable_annual_wages_pct_chg Numeric 8 Over-the-year percent change in taxable annual wages for a given year (Rounded to the tenths place)
38 oty_annual_contributions_chg Numeric 13 Over-the-year change in annual contributions for a given year
39 oty_annual_contributions_pct_chg Numeric 8 Over-the-year percent change in annual contributions for a given year (Rounded to the tenths place)
40 oty_annual_avg_wkly_wage_chg Numeric 8 Over-the-year change in annual average weekly wage for a given year
41 oty_annual_avg_wkly_wage_pct_chg Numeric 8 Over-the-year percent change in annual average weekly wage for a given year (Rounded to the tenths place)
42 oty_avg_annual_pay_chg Numeric 8 Over-the-year change in average annual pay for a given year
43 oty_avg_annual_pay_pct_chg Numeric 8 Over-the-year percent change in average annual pay for a given year (Rounded to the tenths place)

 

Last Modified Date: April 27, 2015