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.
No methodology notes for this dataset.
Series
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, men aged 19-21, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, men aged 22-24, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, men aged 25-34, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, men aged 35-44, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, men aged 45-54, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, men aged 55-64, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, men aged 65-99, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, women, all ages, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, women aged 14-18, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, women aged 19-21, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, women aged 22-24, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, women aged 25-34, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, women aged 35-44, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, women aged 45-54, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, women aged 55-64, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): all private industries, women aged 65-99, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): Agriculture, Forestry, Fishing and Hunting (NAICS 11), all workers, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): Mining, Quarrying, and Oil and Gas Extraction (NAICS 21), all workers, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): Utilities (NAICS 22), all workers, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): Construction (NAICS 23), all workers, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): Manufacturing (NAICS 31-33), all workers, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): Wholesale Trade (NAICS 42), all workers, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): Retail Trade (NAICS 44-45), all workers, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016
- Average Monthly Earnings (Beginning-of-Quarter Employment): Transportation and Warehousing (NAICS 48-49), all workers, Alaska (QWI, quarterly, not seasonally adjusted)Nominal dollars per month · Quarterly · Not seasonally adjusted · 2000 to 2016