get_h1b_filings
Returns H-1B Labor Condition Applications from the Department of Labor's quarterly disclosure files — one record per LCA with employer, job title, O*NET-SOC occupation code, offered wage vs DOL prevailing wage, worksite location, and employer risk flags (h1b_dependent, willful_violator). Covers H-1B, H-1B1 (Chile / Singapore), and E-3 (Australia) visa classes. Use this when the user asks about: a company's hiring activity or wage levels for specific roles, tech-hiring trends by state or occupation, offered vs prevailing wage gaps, or outsourcing-firm staffing patterns. IMPORTANT interpretation notes (stated so agents don't over-read): an LCA is filed BEFORE the H-1B petition and can cover multiple positions (total_worker_positions) — it signals hiring INTENT, not an approved visa or a hire. Certified ≫ actual visas issued. Wage fields are as filed; wage_unit varies (Year / Hour / Month / Week / Bi-Weekly) — normalize before comparing. Matching: employer_name is a substring over legal name + DBA (e.g., 'infosys', 'amazon'). soc_code is the precise occupation filter (e.g., '15-1252.00' Software Developers). case_status values: 'Certified', 'Certified - Withdrawn', 'Denied', 'Withdrawn'. Coverage: FY2024→present from DOL's quarterly files (fiscal_year / fiscal_quarter on each record; ~400-550K filings per quarter). Pure-publisher posture: DOL's disclosure rows as filed — no derived 'real wage' normalization or employer scoring.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum filings to return. Default 50, max 500. | |
| since | No | Decision date lower bound (YYYY-MM-DD inclusive). | |
| until | No | Decision date upper bound (YYYY-MM-DD inclusive). | |
| soc_code | No | Exact O*NET-SOC occupation code (e.g., '15-1252.00' = Software Developers). | |
| job_title | No | Case-insensitive substring against the job title (e.g., 'machine learning'). | |
| sort_order | No | Default: desc (most recent decisions first). | |
| visa_class | No | Exact: 'H-1B', 'H-1B1 Chile', 'H-1B1 Singapore', 'E-3 Australian'. | |
| case_number | No | Direct lookup by DOL case number (e.g., 'I-200-26083-726723'). | |
| case_status | No | Exact: 'Certified', 'Certified - Withdrawn', 'Denied', 'Withdrawn'. | |
| employer_name | No | Case-insensitive substring against employer legal name + DBA (e.g., 'google', 'tata'). | |
| worksite_state | No | Two-letter worksite state (e.g., 'CA', 'TX'). |