US quarterly employment, hires, separations, job creation and earnings by state, industry and demographics (LEHD QWI)
Quarterly Workforce Indicators from the Census Bureau's LEHD program: beginning- and end-of-quarter employment, full-quarter (stable) employment, hires, separations, hires and separations of stable jobs, firm job gains and losses (job creation and destruction), net job flows, turnover, and average monthly earnings for new hires, stable jobs and separations, plus the matching rates. Every value is a full tabulation of state unemployment-insurance wage records for private employers (ownership code A05), so there is no sampling error; missing quarters are suppressed for disclosure protection and must not be interpolated. Geography: United States (sum of reporting states), all 50 states, DC and Puerto Rico; states join the series in different years (California 1991, Texas 1995, New York 2000, DC 2005, Puerto Rico 2010; Alaska stops in 2016). Industry: all private industries and every NAICS sector (2-digit). Demographics: sex by age group, sex by education (age 25+), race by ethnicity. National series also by firm age and firm size. Series ids: qwi.<indicator>_<geo>_<naics>_<demographic>[_<firm>], for example qwi.emp_us_00_s0aa00 (national beginning-of-quarter employment, all workers), qwi.hira_ca_51_s0aa00 (California hires in Information), qwi.earns_us_31_33_s2aa04 (national monthly earnings of women aged 25-34 in manufacturing). Counts of jobs, ratios for rates, nominal dollars per month for earnings, quarterly, not seasonally adjusted, 1990 to the latest quarter. QWI is industry-based, not occupation-based; use cps_basic for occupations and the BLS payroll survey for seasonally adjusted employment levels.
In SQL, this dataset is the rows of census.series with dataset_code = 'qwi'.
Series
Beginning-of-Quarter Employment: all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
Hires (All Accessions): all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
Separations (All): all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
Average Monthly Earnings (Full-Quarter Employment): all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Nominal dollars per month · Quarterly · Not seasonally adjusted · 1993 to 2025
Firm Job Gains (Job Creation): all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
Firm Job Loss (Job Destruction): all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
New Hires: all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1994 to 2025
Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Nominal dollars per month · Quarterly · Not seasonally adjusted · 1993 to 2025
Average Monthly Earnings (New Hires into Full-Quarter Employment): all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Nominal dollars per month · Quarterly · Not seasonally adjusted · 1994 to 2025
Firm Job Change (Net Change): all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
End-of-Quarter Hiring Rate: all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Ratio (share of (Emp + EmpEnd)/2) · Quarterly · Not seasonally adjusted · 1993 to 2025
Beginning-of-Quarter Separation Rate: all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Ratio (share of (Emp + EmpEnd)/2) · Quarterly · Not seasonally adjusted · 1993 to 2025
End-of-Quarter Employment: all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
Full-Quarter Employment (Stable): all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
Recall Hires: all private industries, all workers, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1994 to 2025
Beginning-of-Quarter Employment: all private industries, men, all ages, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
Beginning-of-Quarter Employment: all private industries, women, all ages, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
Average Monthly Earnings (Full-Quarter Employment): all private industries, men, all ages, United States (QWI, quarterly, not seasonally adjusted)
Nominal dollars per month · Quarterly · Not seasonally adjusted · 1993 to 2025
Average Monthly Earnings (Full-Quarter Employment): all private industries, women, all ages, United States (QWI, quarterly, not seasonally adjusted)
Nominal dollars per month · Quarterly · Not seasonally adjusted · 1993 to 2025
Beginning-of-Quarter Employment: all private industries, all workers aged 25-34, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
Beginning-of-Quarter Employment: all private industries, all workers aged 65-99, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
Beginning-of-Quarter Employment: Construction (NAICS 23), all workers, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
Beginning-of-Quarter Employment: Manufacturing (NAICS 31-33), all workers, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025
Beginning-of-Quarter Employment: Retail Trade (NAICS 44-45), all workers, United States (QWI, quarterly, not seasonally adjusted)
Jobs or workers (count) · Quarterly · Not seasonally adjusted · 1993 to 2025