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 year specific collection of NAICS-Based Data Files. Data for Puerto Rico and the Virgin Islands are 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 (.xls), 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: XLS 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 (.xls), a comma separated values file (.csv), and as a flat, text file (.txt). Click the links below to download.

DOWNLOAD: XLS 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: March 24, 2014