2026

Data

API

ETL

H-1B Salary API

9,172,091 US visa salary records, one REST API with MCP.

h1bapi.com

The challenge

17 years of raw DOL Excel files

4 file eras that renamed every column

Excel turning job codes into calendar dates

9 million rows of human-entered text

Column alias convergence

Every historical name gets rewritten to one canonical column before any downstream logic runs. Four file eras, one language.

CASE_NO

LCA_CASE_NUMBER

CASE_NUMBER

case_number

NAME

LCA_CASE_EMPLOYER_NAME

EMPLOYER_NAME

employer_name

OCCUPATIONAL_TITLE

LCA_CASE_SOC_NAME

SOC_TITLE

soc_title

WAGE_RATE_1

LCA_CASE_WAGE_RATE_FROM

WAGE_RATE_OF_PAY_FROM_1

wage_rate_from

17 files, none alike

Column count per fiscal year. FY2019 jumps to 260 columns because the DOL added up to 10 worksite slots per case.

FY2008

33 cols291k rows

FY2009

33 cols364k rows

FY2010

39 cols375k rows

FY2011

39 cols415k rows

FY2012

39 cols489k rows

FY2013

39 cols562k rows

FY2014

39 cols612k rows

FY2015

40 cols619k rows

FY2016

40 cols648k rows

FY2017

52 cols625k rows

FY2018

52 cols654k rows

FY2019

260 cols401k rows

FY2020

93 cols577k rows

FY2021

93 cols558k rows

FY2022

93 cols620k rows

FY2023

93 cols644k rows

FY2024

93 cols719k rows

What it actually answers

Ask by company, role, city or year. Get the salary ranges that were actually filed with the government, pulled from 9 million real filings.

Example question

How much does Google pay a Software Engineer?

Google LLC

Software Engineer · Mountain View, CA · 2024

$165,000 – $240,000

Amazon.com Services

Data Scientist II · Seattle, WA · 2024

$125,000 – $180,000

Meta Platforms

Software Engineer, ML · Menlo Park, CA · 2024

$190,000 – $260,000

Apple Inc

Software Engineer, Systems · Cupertino, CA · 2024

$175,000 – $225,000

Sample rows from FY2024 filings. Also plugs into any AI — ChatGPT, Claude, Cursor — through MCP, so they can pull salaries on request.

Have a similar challenge?

Let's figure out what your project needs.