Public Dataset

Medicaid Provider Spending

This dataset contains provider-level Medicaid spending data aggregated from outpatient and professional claims with valid HCPCS codes, covering January 2018 through December 2024. It provides insights into how Medicaid dollars are distributed across providers and procedures nationwide.

storage
26.8M rows16 columns

Try asking

Data Preview

provider_org_nameprovider_last_nameprovider_first_nameprovider_cityprovider_statezip5provider_entity_typehcpcs_codeclaim_from_monthtotal_unique_beneficiariestotal_claimstotal_paidbilling_provider_npi_numservicing_provider_npi_numprovider_zipprovider_country
CENTRO CARDIOVASCULAR DE LA MONTANA,CSPADJUNTASPR006012992132024-116511410338.4815787570431376609016006012202US
LABORATORIO CLINICO SANTIAGO IRIZARRY INCADJUNTASPR006012874262024-071392169137.8114171389911417138991006012333US
LABORATORIO CLINICO SANTIAGO IRIZARRY INCADJUNTASPR006012874262022-011840235894364.114171389911417138991006012333US
AGUADILLA EYE MD PSCAGUADILLAPR006032670282021-0433385446.5415989970091518151877006035152US
DR. NELSON A. MERCADO CASTRO, CSPAGUADILLAPR006032D72402018-07211131632414776919131003812298006035643US
FRONT SIGHT ANESTHESIA, PSCAGUADILLAPR006052669842019-03242671401295711075114441466500605US
FRONT SIGHT ANESTHESIA, PSCAGUADILLAPR006052670392024-09152114004.91295711075129571107500605US
FRONT SIGHT ANESTHESIA, PSCAGUADILLAPR006052669842022-05353596731295711075114441466500605US
FRONT SIGHT ANESTHESIA, PSCAGUADILLAPR006052669842023-103838100641295711075129571107500605US
ACO DEL NORTE LLCARECIBOPR006122961602024-0570370427017.091942515440194251544000612US
ACO DEL NORTE LLCARECIBOPR006122768302023-0680805348.221942515440194251544000612US
SOCIEDAD DE SERVICIOS NEONATALES DE ARECIBOARECIBOPR006122994622023-10741705647.621609958446160995844600612US
DV LAB GROUP INCARECIBOPR006122874262021-081731907532.041932264504193226450400612US
HABLA Y ACCIONA INC.ARECIBOPR006122925072020-08251587005.711932657228193265722800612US
SOCIEDAD DE SERVICIOS NEONATALES DE ARECIBOARECIBOPR006122994682021-10171711173.251609958446123512557600612US
LABORATORIO CLINICO TOLEDO, LLCARECIBOPR006122844432023-104224557598.011447233861144723386100612US
LABORATORIO CLINICO TOLEDO, LLCARECIBOPR006122G20232020-1118381977424931447233861144723386100612US
LABORATORIO CLINICO TOLEDO, LLCARECIBOPR006122850252024-085046634986.781447233861144723386100612US
RDC INSTITUTO CARDIOLOGICO DE ARECIBOARECIBOPR006122933062021-0561658215.061255448676125544867600612US
INTEGRAL THERAPY CENTERARECIBOPR006122971292022-10854788278.011841707635184170763500612US
HABLA Y ACCIONA INC.ARECIBOPR006122925262020-11331428926.121932657228193265722800612US
EMERGENCY PHYSICIAN PROVIDERS, LLCARECIBOPR006122992842024-101611914437.081245775089188183215200612US
MEDIC MEDICAL TRANSPORT INCARECIBOPR006122A04282023-0324625423.661922208578192220857800612US
ARRAIZA RADIOLOGY PSCARECIBOPR006122770672023-0457696389.971891736070189173607000612US
PHYSICIAN HEALTHCARE ADMINISTRATION LLCARECIBOPR006122992832022-111321376761.111457730871166978294200612US
ARRAIZA RADIOLOGY PSCARECIBOPR006122766412021-1264667070.441891736070189173607000612US
SOCIEDAD DE SERVICIOS NEONATALES DE ARECIBOARECIBOPR006122994602019-07647046921609958446160995844600612US
OASIS AMBULANCEARECIBOPR006122A04292024-0812277978.081144904467114490446700612US
LABORATORIO CLINICO TOLEDO, LLCARECIBOPR006122863282021-0338842611190.211447233861144723386100612US
INTEGRAL THERAPY CENTERARECIBOPR006122925072021-1283414228041841707635184170763500612US
SERVICIO DE SALUD DEL NORTEARECIBOPR006122990502021-06164194668517706112201770611220006123112US
SERVICIO DE SALUD DEL NORTEARECIBOPR006122990502021-02142171577517706112201770611220006123112US
UROHEALTHARECIBOPR006122992132024-0962916829.4217602501611760250161006123960US
RETINA CARE PSCARECIBOPR006122921342020-081611694705.6919829587731982958773006124315US
RETINA CARE PSCARECIBOPR006122920122023-1112521214049.7719829587731982958773006124315US
INSTITUTO DEL CANCER Y ENFERMEDADES DE LA SANGRE, CSPARECIBOPR006122964152022-0544878875.6818919901231891990123006124335US
ARECIBO HEALTHCARE PSCARECIBOPR006122992222024-0463646829.211443233951144323395006124418US
IVELISSE DIAZ GARCIA DBA LABORATORIO DIAZ GARCIAARECIBOPR006122U00022022-01971095112.4416997899661699789966006124461US
HOSPITAL DR. SUSONI. INC.ARECIBOPR006122741772024-05366410415.2311048620441871799478006124526US
CENTRO RADIOLOGICO ROLON INCARECIBOPR006122770672024-0249494584.1515583520051558352005006129610US
CENTRO RADIOLOGICO ROLON INCARECIBOPR006122766412024-0850786327.1615583520051558352005006129610US
CENTRO OFTALMOLOGICO DE ARECIBO INCARECIBOPR006142669842020-023030156451801916275180191627500614US
CENTRO OFTALMOLOGICO DE ARECIBO INCARECIBOPR006142669842018-105959294691801916275180191627500614US
SERVICIOS NEONATALES GUAILIARECIBOPR006142994712022-0918259103.219221817181831158625006140879US
SERVICIOS NEONATALES GUAILIARECIBOPR006142994722023-08222222548.4219221817181831158625006140879US
SERVICIOS NEONATALES GUAILIARECIBOPR006142994712019-081718469019221817181235125576006140879US
LEARN & GROW THERAPY GROUP LLCBARCELONETAPR006172925262021-105362548139297.7612052283431205228343006172725US
LEARN & GROW THERAPY GROUP LLCBARCELONETAPR006172975302023-11491245382.0812052283431205228343006172725US
LEARN & GROW THERAPY GROUP LLCBARCELONETAPR006172925232022-0552526830.612052283431205228343006172725US
LEARN & GROW THERAPY GROUP LLCBARCELONETAPR006172925072018-11345123117699.0412052283431205228343006172725US

Showing 50 of 26,800,000 rows

What You Can Do

Rank states and cities by total Medicaid spending, claims, or beneficiaries served
Identify the highest-spending provider organizations in any state or ZIP code
Analyze monthly spending trends from 2018 to 2024
Find the most utilized HCPCS procedure codes by claims volume or total paid
Compare individual providers vs. organizations by spending and beneficiary counts

Data Dictionary

ColumnTypeDescription
billing_provider_npi_numSTRINGNational Provider Identifier (NPI) of the billing provider
servicing_provider_npi_numSTRINGNPI of the provider who performed the service
hcpcs_codeSTRINGHealthcare Common Procedure Coding System code for the service or drug
claim_from_monthSTRINGMonth the claim service began (YYYY-MM format)
total_unique_beneficiariesINTEGERNumber of unique Medicaid beneficiaries who received the service
total_claimsINTEGERTotal number of claims submitted for this provider/service combination
total_paidFLOATTotal amount paid by Medicaid for the claims (USD)
provider_entity_typeSTRINGWhether the provider is an individual (I) or organization (O)
provider_org_nameSTRINGOrganization name (for entity type O)
provider_last_nameSTRINGProvider last name (for entity type I)
provider_first_nameSTRINGProvider first name (for entity type I)
provider_citySTRINGCity of the provider practice location (from NPPES)
provider_stateSTRINGState of the provider practice location (from NPPES)
provider_zipSTRINGFull ZIP code of the provider practice location (from NPPES)
provider_countrySTRINGCountry of the provider practice location (from NPPES)
zip5STRING5-digit ZIP code derived from provider_zip for easier geographic grouping

Explore More Datasets

Discover other public datasets and live API connections you can chat with.

Federal Reserve Bank of St. Louis
Live API

FRED (Federal Reserve Economic Data) API

Access 800,000+ economic time series from the Federal Reserve — GDP, unemployment, inflation, interest rates, and more.

Federal Reserve Bank of St. Louis

U.S. Department of Labor
Live API

Bureau of Labor Statistics

U.S. employment, unemployment, inflation (CPI), wages, and productivity data from the Bureau of Labor Statistics.

U.S. Department of Labor

U.S. Securities and Exchange Commission
Live API

SEC EDGAR

10-K, 10-Q, 8-K, proxy statements, insider trades, and XBRL financial data from all SEC corporate filings.

U.S. Securities and Exchange Commission

The World Bank Group
Live API

World Bank Development Indicators

Nearly 16,000 development indicators covering GDP, population, health, education, and trade for 200+ countries.

The World Bank Group

U.S. Department of the Treasury
Live API

USA Spending Federal Government Spending

Free, comprehensive U.S. federal spending data covering contracts, grants, loans, and financial assistance across all government agencies.

U.S. Department of the Treasury

Frankfurter / European Central Bank
Live API

Frankfurter Currency Exchange Rates

Free currency exchange rates and conversion data from the European Central Bank, updated daily with 30+ currencies and historical data back to 1999.

Frankfurter / European Central Bank

U.S. Census Bureau
Live API

U.S. Census Bureau API

Over 1,700 Census datasets covering demographics, housing, income, employment, and business data at all geographic levels.

U.S. Census Bureau

Census Demographics by ZIP Code & DMA
File

Census Demographics by ZIP Code & DMA

ZIP-level population, age, race, and ethnicity data from the 2024 ACS with DMA market area mappings.

U.S. Census Bureau

IRS Income Statistics by ZIP Code (2022)
File

IRS Income Statistics by ZIP Code (2022)

ZIP-level income tax data with AGI brackets, income sources, deductions, and credits for 27,590 ZIP codes.

IRS Statistics of Income (SOI)

National Weather Service (NOAA)
Live API

National Weather Service

Current conditions, forecasts, and severe weather alerts for U.S. locations via the National Weather Service.

National Weather Service (NOAA)

NOAA National Centers for Environmental Information
Live API

NOAA Climate Data Online

Historical weather observations, climate normals, and records from global stations (some dating back to 1763).

NOAA National Centers for Environmental Information

EPA AirNow Program
Live API

EPA AirNow Air Quality

Real-time and forecast Air Quality Index (AQI) data for PM2.5, PM10, and ozone across the US, Canada, and Mexico.

EPA AirNow Program

Centers for Medicare & Medicaid Services
Live API

CMS Medicare Provider Data

U.S. Medicare provider quality ratings, hospital comparisons, nursing home inspections, physician data, and healthcare spending from CMS.gov.

Centers for Medicare & Medicaid Services

USGS Earthquake Hazards Program
Live API

USGS Earthquake Catalog

Real-time and historical earthquake data worldwide including magnitude, location, depth, and tsunami alerts from the USGS.

USGS Earthquake Hazards Program

U.S. Geological Survey
Live API

USGS Water Data

Real-time and historical U.S. water data including streamflow, water levels, water quality, and groundwater measurements from USGS monitoring stations nationwide.

U.S. Geological Survey

U.S. Department of Education
Live API

College Scorecard

Institution-level and field-of-study data for 6,500+ colleges including costs, earnings, graduation rates, and admissions.

U.S. Department of Education

County Health Rankings (2025)
File

County Health Rankings (2025)

County-level health outcomes, behaviors, clinical care, and socioeconomic factors for 3,200+ U.S. counties.

Robert Wood Johnson Foundation / University of Wisconsin

U.S. Food and Drug Administration
Live API

OpenFDA

FDA public data on drug adverse events, recalls, medical devices, food enforcement, and product labeling.

U.S. Food and Drug Administration

USDA Agricultural Research Service
Live API

USDA FoodData Central

Nutrient profiles for 300,000+ foods including branded products, foundation foods, and survey data from the USDA.

USDA Agricultural Research Service

HUD User
Live API

HUD User Housing Data

Fair Market Rents, income limits, USPS vacancy data, and geographic crosswalks from the U.S. Department of Housing and Urban Development.

HUD User

TrustMRR
Live API

TrustMRR

Verified startup revenue, MRR, growth rates, and acquisition data for hundreds startups backed by real payment provider integrations.

TrustMRR

NASA
Live API

NASA APIs

Access NASA space and Earth science data including astronomy images, asteroid tracking, Mars rover photos, and space weather.

NASA

MLB Advanced Media
Live API

MLB Statcast (Baseball Savant)

Comprehensive MLB batting and pitching data — exit velocity, launch angle, pitch velocity, spin rate, expected stats, and advanced analytics for every play since 2015 via Baseball Savant.

MLB Advanced Media

NAICS Industry Classification Codes (2022)
File

NAICS Industry Classification Codes (2022)

Complete 2022 NAICS code hierarchy with all 2,122 industry classifications across 5 levels.

U.S. Census Bureau

US ZIP Code Geographic Reference
File

US ZIP Code Geographic Reference

Geographic reference for 33,791 ZIP codes with state, county, coordinates, and land area.

U.S. Census Bureau