QCEW County High-Level Layouts

The tables below describe the field layouts for the County high-level Excel Workbooks. There are two formats, one for workbooks with quarterly data, and one for workbooks with annual data. These Excel files are available from the historical NAICS-Based Data Files Table. Data for Puerto Rico and the Virgin Islands is stored on a second worksheet within each workbook. Data for the U.S. is repeated on the second worksheet as a convenience to users.


County High-Level Quarterly Layout

This table describes the field layout for county high-level workbooks containing quarterly data. The table 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
Column
Letter
Field
Name
Column
Display
Field
Description
1 A Area Code hidden 5-character FIPS code
2 B St hidden 2-character State FIPS code
3 C Cnty hidden 3-character County FIPS code
4 D Own hidden 1-character Ownership code
5 E NAICS hidden 4-character Industry code (SuperSector)
6 F Year visible 4-digit year
7 G Qtr visible 1-character quarter (always A for annual)
8 H Area Type visible Category of the given area. (State, County,Nation, etc…)
9 I St Name visible Multi-character State name
10 J Area visible Area title associated with the area's FIPS code
11 K Ownership visible Ownership title associated with the ownership code
12 L Industry visible Industry title associated with the industry code
13 M Status Code visible Status code, or disclosure code ('N' for not disclosed)
14 N Establishment Count visible Quarterly establishment counts for a given quarter
15 O Month 1 Employment visible Employment level for the first month of the quarter. The name of the month is displayed. (EX: January)
16 P Month 2 Employment visible Employment level for the second month of the quarter. The name of the month is displayed. (EX: February)
17 Q Month 3 Employment visible Employment level for the third month of the quarter. The name of the month is displayed. (EX: March)
18 R Total Quarterly Wages visible Total quarterly wage level for the given quarter
19 S Average Weekly Wage visible Average weekly wage based on the 12-monthly employment levels and total annual wage levels
20 T Employment Location Quotient Relative to U.S. visible Employment Location Quotent Relative to U.S. (more...)
21 U Total Wage Location Quotient Relative to U.S. visible Total Wage Location Quotient Relative to U.S. (more...)


County High-Level Annual Layout

This table describes the field layout for county high-level workbooks containing annual averages. The table 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.

DOWNLOAD: XLSX CSV TXT

QCEW CSV Quarterly Files Field Table
Field
Number
Column
Letter
Field
Name
Column
Display
Field
Description
1 A Area Code hidden 5-character FIPS code
2 B St hidden 2-character State FIPS code
3 C Cnty hidden 3-character County FIPS code
4 D Own hidden 1-character Ownership code
5 E NAICS hidden 4-character Industry code (SuperSector)
6 F Year visible 4-digit year
7 G Qtr visible 1-character quarter (always A for annual)
8 H Area Type visible Category of the given area. (State, County,Nation, etc…)
9 I St Name visible Multi-character State name
10 J Area visible Area title associated with the area's FIPS code
11 K Ownership visible Ownership title associated with the ownership code.
12 L Industry visible Industry title associated with the industry code.
13 M Annual Average Status Code visible Status code, or disclosure code ('N' for not disclosed)
14 N Annual Average Establishment Count visible Annual average of quarterly establishment counts for a given year
15 O Annual Average Employment visible Annual average of monthly employment levels for a given year
16 P Annual Total Wages visible Sum of the four quarterly total wage levels for a given year
17 Q Annual Average Weekly Wage visible Average weekly wage based on the 12-monthly employment levels and total annual wage levels
18 R Annual Average Pay visible Average annual pay based on employment and wage levels for a given year
19 S Employment Location Quotient Relative to U.S. visible Employment Location Quotent Relative to U.S. (more...)
20 T Total Wage Location Quotient Relative to U.S. visible Total Wage Location Quotient Relative to U.S. (more...)

 

Last Modified Date: December 2, 2014