< Return to Datasets Menu

Quarterly Census Employment and Wage (CEW)

Quarterly Census Employment and Wage (CEW) V1

https://api.dol.gov/V1/Statistics/CEW

The Quarterly Census of Employment and Wages (QCEW) program publishes a quarterly count of employment and wages reported by employers covering 98 percent of U.S. jobs, available at the county, MSA, state and national levels by industry.

More information and details about the data provided can be found at https://www.bls.gov/cew

Browse Metadata

Dataset Tables

EN_AREA

Area
Column Name Data Type Column Description
Column Name AREA_CODE Data Type varchar (5) Column Description Area Code
Column Name AREA_TITLE Data Type varchar (60) Column Description Area Name
Column Name DISPLAY_LEVEL Data Type varchar (2) Column Description Display Indent Level For Query Tool
Column Name SELECTABLE Data Type varchar (1) Column Description Code To Allow/Disallow Query Tool Selection
Column Name SORT_SEQUENCE Data Type varchar (5) Column Description Data Query Tool Widget Sorting

EN_FOOTNOTE

Footnote
Column Name Data Type Column Description
Column Name FOOTNOTE_CODE Data Type varchar (2) Column Description Footnote Code
Column Name FOOTNOTE_TEXT Data Type varchar (150) Column Description Footnote Code Description

EN_INDUSTRY

Industry
Column Name Data Type Column Description
Column Name INDUSTRY_CODE Data Type varchar (6) Column Description Industry Code
Column Name INDUSTRY_TITLE Data Type varchar (60) Column Description Industry Code Description
Column Name DISPLAY_LEVEL Data Type varchar (2) Column Description Display Indent Level For Query Tool
Column Name SELECTABLE Data Type varchar (1) Column Description Code To Allow/Disallow Query Tool Selection
Column Name SORT_SEQUENCE Data Type varchar (5) Column Description Data Query Tool Widget Sorting

EN_LQAREA

Location Quotient Area
Column Name Data Type Column Description
Column Name AREA_CODE Data Type varchar (5) Column Description Location Quotient Application Area Code
Column Name AREA_TITLE Data Type varchar (60) Column Description Location Quotient Application Area Name
Column Name DISPLAY_LEVEL Data Type varchar (2) Column Description Location Quotient Application Area Code
Column Name SELECTABLE Data Type varchar (1) Column Description Code To Allow/Disallow Query Tool Selection
Column Name SORT_SEQUENCE Data Type varchar (5) Column Description Data Query Tool Widget Sorting

EN_OWNER

Owner
Column Name Data Type Column Description
Column Name OWNER_CODE Data Type varchar (1) Column Description Establishment Ownership Code
Column Name OWNER_TITLE Data Type varchar (30) Column Description Establishment Ownership Code Description
Column Name DISPLAY_LEVEL Data Type varchar (2) Column Description Display Indent Level For Query Tool
Column Name SELECTABLE Data Type varchar (1) Column Description Code To Allow/Disallow Query Tool Selection
Column Name SORT_SEQUENCE Data Type varchar (5) Column Description Data Query Tool Widget Sorting

EN_STATE

State
Column Name Data Type Column Description
Column Name STATE_CODE Data Type varchar (2) Column Description State Code / FIPS
Column Name STATE_TITLE Data Type varchar (60) Column Description State Name
Column Name DISPLAY_LEVEL Data Type varchar (2) Column Description Display Indent Level For Query Tool
Column Name SELECTABLE Data Type varchar (1) Column Description Code To Allow/Disallow Query Tool Selection
Column Name SORT_SEQUENCE Data Type varchar (5) Column Description Data Query Tool Widget Sorting

EN_TYPE

Type
Column Name Data Type Column Description
Column Name TYPE_CODE Data Type varchar (1) Column Description Data Type Code
Column Name TYPE_TITLE Data Type varchar (30) Column Description Data Type Code Description
Column Name DISPLAY_LEVEL Data Type varchar (2) Column Description Display Indent Level For Query Tool
Column Name SELECTABLE Data Type varchar (1) Column Description Code To Allow/Disallow Query Tool Selection
Column Name SORT_SEQUENCE Data Type varchar (5) Column Description Data Query Tool Widget Sorting