Skip to main content
v2026.11,986 entries · CC-BY 4.0

Quarterly Census of Employment and Wages (QCEW): Data, Formula and Example

The QCEW is the BLS quarterly census of employment and wages from state UI records. Learn its coverage, the location quotient formula, and a worked example.

Written and maintained by CASRAI Editorial Board

Published

On this page

The Quarterly Census of Employment and Wages (QCEW) is the U.S. Bureau of Labor Statistics (BLS) quarterly count of employment and wages reported by employers. It is built from state unemployment insurance (UI) administrative records rather than a sample, covers more than 95 percent of U.S. jobs, and is published down to county and detailed-industry level. Researchers use it to measure local labor markets and to compute indicators such as the location quotient.

What is the Quarterly Census of Employment and Wages?

BLS describes the QCEW as a quarterly count of employment and wages reported by employers. Its primary source is administrative data from state UI programs: employers covered by UI law file quarterly contribution reports, and those reports are the raw material. BLS supplements them with the Annual Refiling Survey and the Multiple Worksite Report, which add establishment-level detail such as location and industry. BLS and the state agencies then correct errors, impute for nonreporting units and annotate unusual movements before publication.

Because the program tabulates the reports of essentially all covered employers instead of a sample, it is a census of UI-covered jobs. The practical consequence for a study is that the series carries non-sampling error (reporting and processing error) but no sampling error. That is the main methodological difference from household or establishment sample surveys such as the one behind the Current Population Survey, and from the occupational estimates described in the OEWS guide, which answer a different question (occupation rather than industry and area).

What does QCEW measure? Employment, wages and establishments

Employment

QCEW employment is the number of covered workers who worked during, or received pay for, the pay period that includes the 12th of the month. It is therefore a count of jobs on a reference day, not of people employed over the whole month, and not an average over the quarter.

Total wages

Total wages are the total compensation paid during the calendar quarter. BLS lists bonuses, stock options, severance pay, tips and the value of meals and lodging among the components, and the wages are counted in the quarter they were paid, regardless of when they were earned. A large year-end bonus therefore raises fourth-quarter wages rather than the quarters in which the work was done.

Establishments and industries

The unit of observation is the establishment: a single economic unit, typically at one location, engaged in one main activity. Industry detail uses the North American Industry Classification System (NAICS); recent data use NAICS 2022. BLS describes NAICS as a system developed with Canada and Mexico that groups establishments into industries using a production-oriented framework. Self-employed workers are not part of the covered universe.

Coverage: who is in the QCEW and who is not

The universe is the 50 states, the District of Columbia, Puerto Rico and the U.S. Virgin Islands, drawn from the employers’ quarterly contribution reports; federal employees are added from the Unemployment Compensation for Federal Employees (UCFE) program. BLS states that the QCEW covers more than 95 percent of U.S. jobs. Coverage is not uniform across sectors, however: BLS notes that about 44 percent of agricultural workers are covered.

Reporting is also not perfect. BLS reports roughly 96 percent of employment and 97 percent of wages as reported by employers, with the nonreporting concentrated in small establishments, and the imputation noted above fills part of that gap. The Annual Refiling Survey contacts about one third of establishments each year, in three-year cohorts, to keep location and industry codes current.

Each quarter’s figures are also revised. According to BLS, a quarter is published several times, the first quarter of a year five times and the fourth quarter twice, and revisions are usually smaller than 0.10 percentage points. Cite the release you downloaded and the date, because the same cell can differ between releases.

Location quotient formula: using QCEW to measure local concentration

The most common derived statistic in published research that uses county QCEW data is the location quotient (LQ), which compares how concentrated an industry is in a local area with how concentrated it is nationally. BLS gives the formula as:

LQ = Local concentration / National concentration

  • Local concentration = local industry employment ÷ all-industry, all-ownerships local employment total.
  • National concentration = U.S. industry employment ÷ all-industry, all-ownerships U.S. employment total.

Both concentrations are shares between 0 and 1, so the LQ is a ratio of two shares and has no unit. The numerator and denominator must use the same ownership definitions: BLS’s own examples take private-sector industry employment over the all-ownerships, all-industry total.

Worked example with real numbers

BLS publishes two worked examples using first-quarter 2026 (March 2026) employment. The arithmetic below is recomputed from those published counts; the data table at the end of this page lays out all components side by side.

Example 1: Natural resources and mining in Los Angeles County

  1. Local concentration = 5,814 ÷ 4,548,021 = 0.001278 (about 0.13 percent of all jobs in the county).
  2. National concentration = 1,669,007 ÷ 154,771,941 = 0.010784 (about 1.08 percent of all U.S. jobs).
  3. LQ = 0.001278 ÷ 0.010784 = 0.1185, which BLS rounds to 0.12.

Example 2: Financial activities in New York County

  1. Local concentration = 419,780 ÷ 2,499,641 = 0.167936.
  2. National concentration = 8,679,481 ÷ 154,771,941 = 0.056079.
  3. LQ = 0.167936 ÷ 0.056079 = 2.9946, which BLS rounds to 2.99.

Keep full precision until the last step. Dividing the rounded concentrations (0.00128 ÷ 0.01078) would give a slightly different LQ than the unrounded calculation.

Interpretation: how to read a location quotient

BLS reads the LQ against a benchmark of 1, the case where the local area has the same industry share as the nation.

LQ value Reading Example above
Equal to 1 The local area has the same share of its employment in the industry as the nation None
Greater than 1 The industry makes up a greater share of local employment than of national employment Financial activities, New York County (2.99)
Less than 1 The industry makes up a smaller share of local employment than of national employment Natural resources and mining, Los Angeles County (0.12)

An LQ describes relative concentration only. An LQ of 0.12 for mining in Los Angeles County does not say the county has few mining jobs in absolute terms (the count is 5,814); it says mining is a much smaller part of the county’s job base than of the national one. Studies of clusters and agglomeration typically use LQs alongside absolute counts; the economic geography guide and the IMPLAN guide cover the wider regional-analysis context.

Assumptions and common mistakes

  • Treating covered employment as all employment. Self-employed workers are outside the universe and agricultural coverage is partial (about 44 percent of agricultural workers), so analyses of farm-heavy or self-employment-heavy areas understate activity.
  • Reading employment as an average. QCEW employment refers to the pay period including the 12th, so it is a point-in-time job count. Seasonal industries can look very different in other weeks of the same month.
  • Matching wages to the quarter they were earned. Wages are counted when paid, so bonuses, stock options and severance shift totals between quarters.
  • Confusing establishments with firms. The record is one establishment, usually one location. A multi-location employer appears as several establishments in different counties, which is why BLS uses the Multiple Worksite Report to obtain location detail.
  • Mixing ownership definitions in an LQ. Use the same ownership code and the same industry level for the local and national figures, and the all-industry, all-ownerships totals as denominators, as in the BLS examples.
  • Ignoring revisions. Early releases are replaced by later ones. State the release or download date in the data section of a paper.
  • Applying sampling-error formulas. Because the QCEW is a census of covered jobs, confidence intervals based on sampling error do not apply. Document the non-sampling issues above instead.

How to report QCEW data (APA example)

In the text, name the program, the geography, the industry level and the reference period, for example: “Employment in financial activities in New York County in the first quarter of 2026 was 419,780 jobs (U.S. Bureau of Labor Statistics, 2026).” In the reference list, cite the dataset using the APA 7th edition pattern for data sets, adjusting the year to the release you used:

U.S. Bureau of Labor Statistics. (2026). Quarterly Census of Employment and Wages [Data set]. U.S. Department of Labor. https://www.bls.gov/cew/

In the methods section also state the NAICS level, the ownership code (for example, private), the quarter, and the date the files were retrieved, since the data are revised.

How to calculate a location quotient in Excel, R or Python

Each snippet reproduces Example 2 above (New York County, financial activities, March 2026) from the published counts.

Excel

A1: 419780      (local industry employment)
A2: 2499641     (local all-industry total)
B1: 8679481     (U.S. industry employment)
B2: 154771941   (U.S. all-industry total)
C1: =(A1/A2)/(B1/B2)     -> 2.9946

R

local_ind = 419780; local_all = 2499641
us_ind = 8679481;   us_all = 154771941
lq = (local_ind / local_all) / (us_ind / us_all)
round(lq, 2)   # 2.99

Python

local_ind, local_all = 419_780, 2_499_641
us_ind, us_all = 8_679_481, 154_771_941
lq = (local_ind / local_all) / (us_ind / us_all)
print(round(lq, 2))   # 2.99

The Census Bureau’s Longitudinal Employer-Household Dynamics (LEHD) program is a separate source that describes its data as based on tabulated and modeled administrative data; it is a different product from the QCEW and is not interchangeable with it.

For many counties and industries, load the BLS area files into a data frame and apply the same expression to each row, with the national row held fixed.

Where to get the data

BLS publishes QCEW data as annual, quarterly and monthly series with detailed industry codes, through the data viewer, the Industry Finder and downloadable files, with a data guide and file layouts on its about-the-data pages. Pair it with other sources when your question needs occupations or people rather than jobs: the OEWS guide covers occupational employment and wages, and the Current Population Survey guide covers household labor-force measures.

Sources

Data: Location quotient components from BLS QCEW worked examples, first quarter 2026

Employment counts and derived shares behind the two BLS location quotient examples (Los Angeles County natural resources and mining; New York County financial activities), March 2026 private-sector industry employment over all-ownerships, all-industry totals. Counts are from the BLS page; shares and LQ were recomputed from them.

Period covered: 2026-03. Coverage: United States.

Location quotient components from BLS QCEW worked examples, first quarter 2026
QuantityLos Angeles County, natural resources and miningNew York County, financial activities
Local industry employment (jobs)5814419780
Local all-industry, all-ownerships total (jobs)45480212499641
Local concentration (share, computed)0.0012780.167936
U.S. industry employment (jobs)16690078679481
U.S. all-industry, all-ownerships total (jobs)154771941154771941
National concentration (share, computed)0.0107840.056079
Location quotient (computed, 2 decimals)0.122.99

Sources

Compiled by CASRAI from the sources above. Free to reuse under CC BY 4.0 with attribution.

Follow CASRAI

Research-administration guidance, standards updates and independent tool reviews.

Ask CASRAI · free to try

Ask about Quarterly Census of Employment and Wages (QCEW): Data, Formula and Example

2 free questions a day, no account.

An AI assistant for research: funder rules, compliance, methods and publishing. It links the sources behind its answers and labels answers that come from a web search.

Answers draw on CASRAI's guides and dictionary plus the federal and funder documents we index: Federal Register, Grants.gov, Regulations.gov and UKRI.

Works on this site and inside Claude, Cursor and the AI tools you already use.

Everything CASRAI publishes — this page, the dictionary, the guides and the news — stays open to read, with no account and no card.

Referenced across the research world

University of Cambridge logoColumbia University logoCrossref logoUniversity of Edinburgh logoHarvard University logoUniversity of Oxford logoPrinceton University logoStanford School of Medicine logoUniversity College London logoORCID logoUniversity of Cambridge logoColumbia University logoCrossref logoUniversity of Edinburgh logoHarvard University logoUniversity of Oxford logoPrinceton University logoStanford School of Medicine logoUniversity College London logoORCID logo
  • University of Cambridge logo
  • Columbia University logo
  • Crossref logo
  • University of Edinburgh logo
  • Harvard University logo
  • University of Oxford logo
  • Princeton University logo
  • Stanford School of Medicine logo
  • University College London logo
  • ORCID logo

View CASRAI adoption →