Quarterly Workforce Indicators Tool
quarterly_workforce_indicators_toolGet quarterly employment, job creation, hires, separations, and earnings data by worker demographics, industry, and firm characteristics to analyze local labor markets and wage trends.
Instructions
Retrieve quarterly employment statistics from the Quarterly Workforce Indicators (QWI) program. Access 32+ economic indicators including employment levels, job creation/destruction, hires, separations, earnings, and turnover rates. Data available by worker demographics (age, sex, education, race/ethnicity), industry (NAICS), and firm characteristics (age, size). Covers 1990-present at state, county, metro area, and workforce investment board area levels. Essential for analyzing local job markets, wage trends, and employment dynamics.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| year | Yes | Year for QWI data (1990-present) | |
| quarter | Yes | Quarter (1-4) | |
| variables | No | Variables to retrieve. Common: Emp (employment), EmpS (stable employment), HirA (hires), Sep (separations), EarnS (average earnings), EarnBeg (beginning-of-quarter earnings), EarnHirAS (average earnings of hires), Payroll (total payroll), TurnOvrS (turnover rate), HirAS (hire rate), SepS (separation rate), JC (job creation), JD (job destruction), JobChngH (net job change from hires), JobChngS (net job change from separations) | |
| geography | No | Geographic level: state (state), county (county), metro (metropolitan area), wib (workforce investment board area) | state |
| state | No | State FIPS code (required for county geography) | |
| sex | No | Sex: 0 (both), 1 (male), 2 (female) | |
| agegrp | No | Age group: A00 (all), A01 (14-18), A02 (19-21), A03 (22-24), A04 (25-34), A05 (35-44), A06 (45-54), A07 (55-64), A08 (65-99) | |
| education | No | Education: E0 (all), E1 (less than high school), E2 (high school), E3 (some college), E4 (bachelor or advanced), E5 (advanced degree) | |
| race | No | Race: A0 (all), A1 (White), A2 (Black), A3 (American Indian/Alaska Native), A4 (Asian), A5 (Native Hawaiian/Pacific Islander), A6 (Two or more races), A7 (not specified), A8 (Asian and Native Hawaiian/Pacific Islander combined) | |
| ethnicity | No | Ethnicity: A0 (all), A1 (not Hispanic), A2 (Hispanic) | |
| industry | No | NAICS 2012 industry code (2-4 digits). Examples: "00" (all), "11" (agriculture), "23" (construction), "31-33" (manufacturing), "54" (professional services), "62" (healthcare) | |
| firmage | No | Firm age: 0 (all), 1 (0-1 years), 2 (2-3 years), 3 (4-5 years), 4 (6-10 years), 5 (11+ years) | |
| firmsize | No | Firm size: 0 (all), 1 (0-19 employees), 2 (20-49), 3 (50-249), 4 (250-499), 5 (500+) |