DOL OFLC Foreign Labor Disclosure Scraper avatar

DOL OFLC Foreign Labor Disclosure Scraper

Pricing

from $0.80 / 1,000 record scrapeds

Go to Apify Store
DOL OFLC Foreign Labor Disclosure Scraper

DOL OFLC Foreign Labor Disclosure Scraper

Extract H-2A, H-2B, PERM, Prevailing Wage, and CW-1 disclosure data from DOL OFLC quarterly XLSX files. Covers all non-H-1B foreign labor programs in one normalized schema with per-program filtering.

Pricing

from $0.80 / 1,000 record scrapeds

Rating

0.0

(0)

Developer

BowTiedRaccoon

BowTiedRaccoon

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

0

Monthly active users

22 days ago

Last modified

Categories

Share

Scrapes the U.S. Department of Labor OFLC quarterly disclosure datasets for H-2A (agricultural), H-2B (seasonal), PERM (permanent labor certification), Prevailing Wage, and CW-1 programs. The only actor covering all five non-H-1B OFLC programs in one normalized schema.

What This Actor Does

The DOL publishes quarterly XLSX disclosure files at the OFLC performance disclosure index. This actor:

  1. Fetches the index page to auto-discover all available quarterly files per program
  2. Filters by your requested programs, fiscal year, and quarter
  3. Downloads each XLSX directly from dol.gov (0.5 MB CW-1 to ~120 MB Prevailing Wage)
  4. Stream-parses every row with per-program column mapping
  5. Outputs a flat normalized dataset

No authentication required — all data is publicly available.

Use Cases

  • Immigration attorneys: track petition outcomes across H-2A/H-2B/PERM by employer or state
  • Agricultural staffing: monitor seasonal H-2A approvals by region
  • Wage benchmarking: compare offered wages against prevailing wage determinations
  • Compliance research: analyze denial patterns by program, industry, or state
  • Policy research: longitudinal trends across OFLC programs and fiscal years

Programs

ProgramDescriptionFile size
H-2AAgricultural temporary workers~16 MB/quarter
H-2BNon-agricultural seasonal workers~66 MB/quarter
PERMPermanent labor certification~36 MB/quarter
PWPrevailing Wage determinations~120 MB/quarter
CW-1CNMI transitional workers~0.5 MB/quarter

Input

FieldTypeDescription
programsarrayPrograms: H-2A, H-2B, PERM, PW, CW-1. Empty = all.
fiscalYearintegerFiscal year (e.g. 2026). 0 = auto-detect latest.
fiscalQuarterstringQ1/Q2/Q3/Q4. Empty = auto-detect latest.
worksiteStatestringFilter by worksite state (e.g. CA).
employerNamestringFilter by employer name substring.
caseStatusstringFilter by case status (Certified, Denied, Withdrawn).
maxItemsintegerMax records (0 = no limit).

Output

Each record includes: program, case_number, case_status, received_date, decision_date, employer_name, employer_city, employer_state, employer_fein, job_title, soc_code, soc_title, worksite_city, worksite_state, num_workers_requested, num_workers_certified, wage_offer, wage_unit, prevailing_wage, period_of_employment_start, period_of_employment_end, attorney_agent_name, fiscal_year, fiscal_quarter, source_file.

Notes on Large Files

The Prevailing Wage (PW) file is ~120 MB with ~1 million rows. Use state/employer filters or maxItems to manage volume. The actor streams rows without loading the full file into memory. Default memory: 2048 MB.

DOL publishes new data quarterly: Q1 (Oct-Dec) around February, Q2 (Jan-Mar) around May, Q3 (Apr-Jun) around August, Q4 (Jul-Sep) around November.