docs/us_immigration/dol_lca_h1b_case

dol_lca_h1b_case

DOL H-1B LCA disclosure data — case-level. One row per H-1B LCA case filing (CASE_NUMBER). Covers all visa classes in the LCA system (H-1B, H-1B1, E-3); filter on visa_class = 'H-1B' for H-1B only. Includes canonical employer name, FEIN, NAICS, staffing firm flag, wage, worksite county, and case status. Use dol_lca_h1b_county_year for pre-aggregated metrics.

tier aTier A: official DOL OFLC disclosure data. LCA certification is a prerequisite for H-1B petition; certified cases represent employer intent, not guaranteed approvals.

grain

case (case_number)

years

2021 – 2025

cadence

Quarterly (DOL OFLC disclosure releases)

overview

~2.4M H-1B LCA case records FY2022–Q1 FY2025. Full case-level detail including employer, wage, worksite county, visa class, and case status.

current vintage — Q1 FY2025

history — Yes — FY2022–Q1 FY2025 in current load

provenance

source & licensing

authority

U.S. Department of Labor

dataset

DOL OFLC H-1B Labor Condition Application Disclosure Data

source url

https://www.dol.gov/agencies/eta/foreign-labor/performance

methodology

https://www.dol.gov/agencies/eta/foreign-labor/performance

license

Public domain (U.S. Federal Government work)

citation

U.S. Department of Labor, Employment and Training Administration (2025). OFLC Performance Data.

schema

fields

name	type	definition
amended_petition	integer	Number of amended petition workers.
begin_date	string	Requested employment start date.
canonical_employer_name	string	Standardized employer name after normalization.
case_numberkey	string	Unique DOL case identifier. Primary key.
case_status	string	Certification status (CERTIFIED, DENIED, WITHDRAWN, CERTIFIED-WITHDRAWN).
change_employer	integer	Number of employer-change petitions.
continued_employment	integer	Number of continuation workers.
country_id	string	ISO 3166 alpha-2 country code. Always "US".
county_id	string	5-character county FIPS code of the primary worksite.
decision_date	string	Date DOL made the certification decision.
employer_fein	string	Federal Employer Identification Number.
employer_name	string	Raw employer name as reported on the LCA.
end_date	string	Requested employment end date.
fips_resolution_method	string	Method used to resolve worksite ZIP to county FIPS.
fiscal_yearkey	integer	Federal fiscal year (October–September) of the decision date. Partition key.
full_time_position	string	Whether the position is full-time (Y/N).
h1b_dependent	string	Whether the employer is H-1B-dependent (>15% of workforce on H-1B).
is_staffing_firm	boolean	True if the employer is classified as a staffing or consulting firm.
job_title	string	Employer-reported job title.
naics_code	string	NAICS industry code of the employer.
new_employment	integer	Number of new H-1B workers requested.
prevailing_wage	float	DOL-determined prevailing wage for the position.
pw_unit_of_pay	string	Unit of prevailing wage.
pw_wage_level	string	Prevailing wage level (I–IV).
soc_code	string	Standard Occupational Classification (SOC) code.
soc_title	string	SOC occupation title.
state_id	string	2-character state FIPS code of the primary worksite.
statutory_basis	string	Statutory basis for the LCA (H-1B, H-1B1 Chile/Singapore, E-3 Australia).
total_worker_positions	integer	Number of workers covered by this LCA filing.
visa_class	string	Visa class (H-1B, H-1B1, E-3). Filter to H-1B for H-1B-only analysis.
wage_rate_of_pay_from	float	Offered wage rate (lower bound if range).
wage_unit_of_pay	string	Unit of offered wage (Year, Hour, Week, Month, Bi-Weekly).
willful_violator	string	Whether the employer has been found a willful violator of H-1B rules.
worksite_county	string	Employer-reported worksite county name.
worksite_postal_code	string	Employer-reported worksite ZIP code.
worksite_state	string	Employer-reported worksite state abbreviation.
year	integer	Calendar year of the decision date.

relationships

joins

primary key

case_number, (canonical_employer_name, fiscal_year), (naics_code, fiscal_year

common joins

dol_lca_h1b_county_year on (county_id, year)

uscis_h1b_employer on (canonical_employer_name, fiscal_year)

usage

how to use this table

method

Case-level extract from DOL OFLC quarterly LCA disclosure files, enriched with FIPS resolution for worksite county.

do not use for

Approval counts — LCA certification does not equal USCIS approval. Use uscis_h1b_employer for approval-side data.

← previousus_housing.housing_vacancy_county_year next →us_immigration.dol_lca_h1b_county_year

last updated · Jul 7, 2026