Search DOL Foreign Labor Disclosure Data
foreign_labor_searchSearch and normalize DOL OFLC disclosure records for foreign labor certification data across LCA, PERM, H-2A, H-2B, and CW visa programs.
Instructions
Stream-search and normalize DOL OFLC disclosure XLSX records across LCA, PERM, H-2A, H-2B, and CW programs. ROUTE BY VISA PROGRAM: H-2A is AGRICULTURAL seasonal labor (farms, ranches, NAICS 11) — never use H-2B for farms. H-2B is NON-AGRICULTURAL seasonal labor (landscaping, hospitality, construction, seafood processing) — never use H-2A here. LCA covers H-1B / H-1B1 / E-3 specialty occupations (tech, healthcare, engineering, academics) and is wrong for ag or seasonal labor. PERM is permanent labor certification (green-card sponsorship). CW is CNMI-only. DO NOT call this tool for general restaurant or business research — restaurants almost never sponsor visa workers; use places_search instead. The first call for a given (visaProgram, fiscalYear, fiscalQuarter) downloads the official disclosure workbook and builds a gzipped JSONL cache (slow, can take 30-90s for big LCA quarters); subsequent calls hit the cache in 1-3 seconds. To avoid first-call timeouts, narrow with maxItems and one or more of employerName, worksiteState, socCode, or caseStatus.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| socCode | No | SOC code prefix filter. | |
| jobTitle | No | Case-insensitive job-title substring filter. | |
| maxItems | No | Maximum matching records to return. Use 0 for no cap. | |
| localFile | No | Optional path to an already-downloaded official disclosure XLSX file. | |
| caseStatus | No | Case status, such as Certified, Denied, Withdrawn, or Certified - Withdrawn. | |
| fiscalYear | No | DOL fiscal year, 2020 through 2030. | |
| visaProgram | No | Foreign labor program: LCA, PERM, H-2A, H-2B, or CW. | |
| employerName | No | Case-insensitive employer legal-name substring filter. | |
| fiscalQuarter | No | Fiscal quarter: Q1, Q2, Q3, or Q4. | |
| minAnnualWage | No | Minimum offered wage after annualization. | |
| worksiteState | No | Two-letter worksite state code. |