State Planner

QCEW Quarterly Employment and Wages

How many people worked in each Ohio county and industry, how many workplaces employed them and what they were paid, every quarter since 1990, from the near-complete count of jobs that employers report for unemployment insurance. Use it to see which industries a county's jobs and payroll depend on, where an industry such as warehousing or manufacturing is growing, and how a local economy moved through a plant opening or a recession, down to individual industries.

Published by
U.S. Bureau of Labor Statistics
Source
QCEW (BLS employment and wages)
Original data
www.bls.gov
Terms of use
Public domain
On the map
No shapes of its own

Ask State Planner a question about this data in plain language, and get the answer as a written explanation and a map.

Sign up to ask

From the publisher

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

QCEW monthly employment data represent the number of covered workers who worked during, or received pay for, the pay period that included the 12th day of the month.

BLS withholds the publication of UI-covered employment and wage data for any industry level when necessary to protect the identity of employers. Totals at the industry level for the states and the nation include the undisclosed data suppressed within the detailed tables without revealing those data.

Fields

What each record holds, as the publisher describes it: 14 fields.

FieldDescription
area_fips
'39000' statewide, a county's FIPS code, or '39999' unknown county
own_code
Ownership: 0 all, 1 federal, 2 state, 3 local government, 5 private, 8 all government
industry_code
10 all industries, a domain, supersector or NAICS code; joins us_naics_codes.code
agglvl_code
BLS's aggregation level: area type and industry depth
year
Calendar year
qtr
Quarter, 1–4
disclosure_code
True where BLS withheld the figures (N, or a row it published with none)
qtrly_estabs
Establishments in the quarter; kept on a suppressed row
month1_emplvl
Jobs in the quarter's first month; null when suppressed
month2_emplvl
Jobs in the second month
month3_emplvl
Jobs in the third month
total_qtrly_wages
Total pay in the quarter, dollars
avg_wkly_wage
Average weekly wage, dollars
lq_month3_emplvl
Location quotient of the third month's employment relative to the U.S.

More from QCEW (BLS employment and wages)

Every Ohio data set

HomePricingAboutTerms of ServicePrivacy Policy