uscis_h1b_employer
USCIS H-1B Employer Data Hub — employer-worksite-fiscal_year grain. One row per employer name x NAICS x worksite city x worksite state x fiscal year. Covers initial and continuing H-1B petition approvals and denials FY2009-2023. Geocoded from worksite city/state to county via ZIP crosswalk.
tier aTier A: official USCIS administrative data. Covers approvals only; denials not included in all years. Employer names are unstandardized.
overview
overview
~832,000 employer-worksite-fiscal_year rows. USCIS approved H-1B petitions by employer, NAICS, worksite city/state, and fiscal year.
current vintage — FY2023
history — Yes — FY2009–FY2023
provenance
source & licensing
authority
U.S. Citizenship and Immigration Services
dataset
USCIS H-1B Employer Data Hub
license
Public domain (U.S. Federal Government work)
citation
U.S. Citizenship and Immigration Services (2024). H-1B Employer Data Hub.
schema
fields
| name | type | definition |
|---|---|---|
| continuing_approvals | integer | Extension petitions approved for existing H-1B workers. |
| continuing_denials | integer | Extension petitions denied. |
| country_id | string | ISO 3166 alpha-2 country code. Always "US". |
| county_id | string | 5-character county FIPS code, geocoded from worksite city/state. |
| employer_fein | string | Federal Employer Identification Number. |
| employer_namekey | string | Employer name as reported to USCIS (unstandardized). |
| fiscal_yearkey | integer | Federal fiscal year (October–September) of the petition decision. Partition key. |
| geo_resolution_method | string | Method used to resolve worksite city/state to county FIPS. |
| initial_approvals | integer | New H-1B petitions approved (first-time and cap-exempt). |
| initial_denials | integer | New H-1B petitions denied. |
| naics_codekey | string | NAICS industry code of the employer. |
| state_id | string | 2-character state FIPS code of the employer worksite. |
| worksite_citykey | string | Employer-reported worksite city. |
| worksite_statekey | string | Employer-reported worksite state abbreviation. |
| worksite_zip | string | Employer-reported worksite ZIP code. |
relationships
joins
primary key
employer_name, naics_code, worksite_city, worksite_state, fiscal_year
common joins
dol_lca_h1b_case on (canonical_employer_name, fiscal_year)
uscis_h1b_county_year on (county_id, fiscal_year)
usage
how to use this table
method
Initial and continuing H-1B approval and denial counts by employer, NAICS, worksite city/state, and fiscal year from USCIS data hub.
do not use for
Case-level analysis — use dol_lca_h1b_case for individual LCA case records with wage data.
← previousus_immigration.uscis_h1b_county_yearnext →us_social_context.social_context_incarceration_county_year
last updated · Jul 7, 2026