dol_lca_h1b_county_year
H-1B Labor Condition Application (LCA) activity aggregated to county and year. One row per county per year. Source is DOL OFLC case-level LCA disclosure data filtered to H-1B visa class only. Wage and staffing metrics use certified cases only; application and certification counts include all statuses.
overview
~10,406 county-year rows (county x fiscal_year, only county-years with H-1B activity).
current vintage — FY2026 Q1
history — FY2009-present (matches base table)
source & licensing
fields
| name | type | definition |
|---|---|---|
| country_idkey | string | ISO 3166 alpha-2 country code. Always "US". |
| county_idkey | string | 5-character county FIPS code of the primary worksite. |
| h1b_applications | int64 | Total number of H-1B LCA applications filed (all statuses). |
| h1b_certification_rate | float64 | Share of applications that were certified (h1b_certified / h1b_applications). |
| h1b_certified | int64 | Number of H-1B LCA applications certified. |
| h1b_dependent_employer_pct | float64 | Share of certified applications from H-1B-dependent employers (>15% of workforce on H-1B). |
| h1b_median_wage | float64 | Median offered annual wage (USD) across certified H-1B applications. |
| h1b_positions | int64 | Total number of H-1B positions requested across certified applications. |
| h1b_staffing_firm_pct | float64 | Share of certified applications filed by staffing or consulting firms. |
| h1b_wage_above_prevailing_pct | float64 | Share of certified applications where offered wage exceeds the prevailing wage level. |
| state_idkey | string | 2-character state FIPS code. |
| yearkey | int64 | Calendar year of the LCA decision date. |
joins
how to use this table
Aggregated from dol_lca_h1b filtered to visa_class='H-1B'. Wage and staffing metrics computed on certified cases only; application and certification counts include all statuses.
Same caveats as base table; FY2020 schema break still applies; non-H-1B visa classes (E-3, H-1B1) excluded.
Inherits FY2020 schema break from base. County-year cells with no H-1B activity are absent (not zero).