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 (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
22 lq_disclosure_code Text 1 1-character location-quotient disclosure code (either ' '(blank) or 'N' not disclosed
23 lq_qtrly_estabs_count 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)

 

Last Modified Date: December 2, 2014