# H-1B Sponsor Profiles – Company-Level LCA Stats (Official DOL) (`knobby_woodworker_aig/h1b-lca-employer-profiles`) Actor

Every H-1B, H-1B1 and E-3 sponsor rolled up from official DOL LCA disclosure files: filings, approval rate, median/percentile wages vs prevailing, wage levels, top roles, worksites, end clients, staffing-firm signal. Multi-quarter, deduped, FEIN-grouped, no personal contact data.

- **URL**: https://apify.com/knobby_woodworker_aig/h1b-lca-employer-profiles.md
- **Developed by:** [Reval](https://apify.com/knobby_woodworker_aig) (community)
- **Categories:** Jobs, Business
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

from $3.00 / 1,000 h-1b employer profiles

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.

Learn more: https://docs.apify.com/actors/running/actors-in-store.md#pay-per-event

## What's an Apify Actor?

An Actor is a serverless cloud program that runs on the Apify platform. It has two run modes.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.

Apify vocabulary and the platform model are defined once, in the agent quickstart at https://apify.com/agents.md.

## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.

Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run.

For examples already wired to this Actor's own input schema, see the [API](#api) section below.

Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`).

# README

## H-1B Sponsor Profiles – Company-Level LCA Stats (Official DOL)

Turn the U.S. Department of Labor's **LCA disclosure files** (H-1B, H-1B1, E-3) into **one clean profile per sponsoring company** – or into PII-free filing rows – straight from dol.gov. No API key, no proxies, no third-party H-1B websites.

### Why this Actor

| Common complaint with existing H-1B scrapers | What this Actor does |
|---|---|
| You get 1M raw rows, one per filing – you still have to pivot in Excel to learn anything about a company | **Employers mode**: one row per sponsor with filings, positions, approval rate, wage percentiles, top roles & worksites |
| One quarterly workbook per run; quarterly files overlap, so combining them double-counts | **Multi-period** (`FY2025`, `FY2026_Q3`, `latest_full_year`…) with **dedupe by case number** |
| Same company appears as "Google LLC", "GOOGLE LLC", "Google Inc." | **Grouped by FEIN**, all name variants listed |
| Wages in mixed units (hourly/weekly/monthly) and typos like $200,000/hour | **Annualized wages** with unit-error correction |
| Outputs attorney names, emails and phone numbers | **No personal contact data** – PoC, attorney, preparer and phone fields are stripped |
| "Trends/analytics" sold as paid add-ons | Included: wage premium vs prevailing wage, wage-level mix, filings by month |

### Enrichment

- **Approval rate**, new vs continuing vs transfer petitions, full-time share
- **Median / P25 / P75 offered wage** and **median premium over prevailing wage**
- **Wage level mix (I–IV)**
- **End clients** (secondary entity) and **% placed at client sites** → `likelyStaffingOrConsulting` flag
- **H-1B dependent** and **willful violator** flags
- **NAICS industry title** for every employer
- Filings by month, first/last filing dates, source file links

### Example inputs

- Profiles for a few companies: `{"employerNames":["Stripe","Google"]}`
- Top 500 sponsors in Texas IT services: `{"employerStates":["TX"],"naicsCodes":["5415"]}`
- Data-scientist filings in Seattle (rows): `{"mode":"filings","worksiteCities":["Seattle"],"jobTitleKeywords":["data scientist"]}`
- Full fiscal year 2025: `{"fiscalPeriods":["FY2025"]}`

### Output (employers mode, abridged)

```json
{"employerName":"Stripe, LLC","otherNames":["Stripe, Inc."],"employerFein":"270465600","totalFilings":264,"approvalRatePct":100,"medianAnnualWage":162200,"medianWagePremiumVsPrevailingPct":3.9,"topWorksiteCities":[{"value":"SEATTLE, WA","count":92}],"likelyStaffingOrConsulting":false}
```

### Data source & notes

- Source: [DOL OFLC Performance Data](https://www.dol.gov/agencies/eta/foreign-labor/performance) – LCA Disclosure Data (public, updated quarterly). DOL sometimes publishes cumulative year-to-date files and sometimes quarter-only files; asking for `FY2025` loads every quarter of that year and dedupes by case number, so you never double-count or miss a quarter. `latest` = the newest file.
- An LCA is filed before an H-1B petition; certified LCAs ≠ approved visas.
- Each run downloads the official workbook (≈80–250 MB) and parses it in-stream; typical run 1–3 minutes.
- Pricing: $3.00 per 1,000 employer profiles (pay per result). Every profile already includes approval rate, wage percentiles vs prevailing wage, top roles, worksites, end clients and the staffing-firm signal, so one row replaces dozens of raw LCA rows.

# Actor input Schema

## `mode` (type: `string`):

Company-level profiles or individual filings.

## `fiscalPeriods` (type: `array`):

'latest', 'latest_full_year', 'FY2025' (all quarters of a fiscal year, deduped) or 'FY2026_Q3'. Several allowed; filings are deduped by case number.

## `employerNames` (type: `array`):

Case-insensitive; also matches trade/DBA names. Empty = all sponsors.

## `feins` (type: `array`):

9-digit federal employer IDs.

## `employerStates` (type: `array`):

2-letter codes, e.g. CA, TX.

## `worksiteStates` (type: `array`):

2-letter codes.

## `worksiteCities` (type: `array`):

e.g. Austin, Seattle.

## `socCodes` (type: `array`):

e.g. 15-1252 (software developers) or 15- (all computer/math).

## `jobTitleKeywords` (type: `array`):

Job title contains any, e.g. data scientist.

## `naicsCodes` (type: `array`):

e.g. 5415 (IT services), 52 (finance).

## `caseStatuses` (type: `array`):

Certified, Certified - Withdrawn, Withdrawn, Denied. Empty = all.

## `visaClasses` (type: `array`):

H-1B, E-3 Australian, H-1B1 Singapore, H-1B1 Chile.

## `wageLevels` (type: `array`):

I, II, III, IV.

## `minAnnualWage` (type: `integer`):

Offered wage, annualized.

## `maxAnnualWage` (type: `integer`):

Offered wage, annualized.

## `receivedFrom` (type: `string`):

YYYY-MM-DD

## `receivedTo` (type: `string`):

YYYY-MM-DD

## `minFilings` (type: `integer`):

Employers mode only.

## `sortBy` (type: `string`):

Employers mode only.

## `topN` (type: `integer`):

Length of top job titles / worksites / end clients lists.

## `maxItems` (type: `integer`):

Stop after this many rows.

## Actor input object example

```json
{
  "mode": "employers",
  "fiscalPeriods": [
    "latest"
  ],
  "employerNames": [
    "Stripe"
  ],
  "minFilings": 1,
  "sortBy": "filings",
  "topN": 5,
  "maxItems": 500
}
```

# Actor output Schema

## `overview` (type: `string`):

No description

## `all` (type: `string`):

No description

## `summary` (type: `string`):

No description

# API

You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.

## JavaScript example

```javascript
import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with your Apify API token
// Replace the '<YOUR_API_TOKEN>' with your token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {
    "fiscalPeriods": [
        "latest"
    ],
    "employerNames": [
        "Stripe"
    ]
};

// Run the Actor and wait for it to finish
const run = await client.actor("knobby_woodworker_aig/h1b-lca-employer-profiles").call(input);

// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
    console.dir(item);
});

// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

```

## Python example

```python
from apify_client import ApifyClient

# Initialize the ApifyClient with your Apify API token
# Replace '<YOUR_API_TOKEN>' with your token.
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = {
    "fiscalPeriods": ["latest"],
    "employerNames": ["Stripe"],
}

# Run the Actor and wait for it to finish
run = client.actor("knobby_woodworker_aig/h1b-lca-employer-profiles").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
for item in client.dataset(run.default_dataset_id).iterate_items():
    print(item)

# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

```

## CLI example

```bash
echo '{
  "fiscalPeriods": [
    "latest"
  ],
  "employerNames": [
    "Stripe"
  ]
}' |
apify call knobby_woodworker_aig/h1b-lca-employer-profiles --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "type": "http",
            "url": "https://mcp.apify.com/?tools=fetch-actor-details,knobby_woodworker_aig/h1b-lca-employer-profiles"
        }
    }
}
```

The hosted server signs you in with OAuth on first connect, so no API token belongs in this config. Clients without OAuth support can send an `Authorization: Bearer <APIFY_API_TOKEN>` header instead, using a token from API & Integrations in Apify Console (https://console.apify.com/settings/integrations).

## OpenAPI specification

Download the OpenAPI definition: https://api.apify.com/v2/actors/irlUmm54JeyR6DMaY/builds/dPg5PCdlvjTAnT0Fl/openapi.json