🏥 CMS Medicare Spending Scraper

🚀 Export CMS Medicare spending data in seconds. Pull Medicare Spending Per Beneficiary (MSPB) scores by hospital, state, or national level. CSV, Excel, JSON, or XML.

🕒 Last updated: 2026-05-26 · 📊 14 fields per record · 4,600+ US hospitals + state and national rollups · CMS Hospital Compare 2024

The CMS Medicare Spending Scraper pulls Medicare Spending Per Beneficiary (MSPB) data from the official data.cms.gov provider-data API. Records cover hospital-level, state-level, and national spending figures for the Medicare program.

CMS publishes MSPB scores annually for all hospitals participating in Medicare. The MSPB score measures how Medicares spending per patient at a given hospital compares to the national median. Coverage includes 4,600+ US hospitals and rolled-up state and national figures.

Target Audience / Use Cases

Who	Why
Healthcare consultancies	Benchmark hospital efficiency
Health insurance carriers	Analyze provider cost patterns
Hospital admin	Compare against peers
Policy researchers	Study Medicare spending variation
Investors	Evaluate healthcare providers for M&A
Journalists	Cover healthcare cost stories

---

📋 What the CMS Medicare Spending Scraper does

• Queries the data.cms.gov provider-data API for Medicare spending datasets
• Supports four dataset choices: hospital, state, national, and by-claim
• Filters by state code
• Returns 14 fields per record
• Exports to CSV, Excel, JSON, or XML
• Direct source links to CMS pages

💡 Why it matters: Medicare is the largest US health insurer by far. MSPB scores reveal which hospitals deliver care efficiently and which spend disproportionately. Programmatic access enables benchmarking, policy research, and investment analysis at scale.

---

🎬 Full Demo

🚧 Coming soon

---

⚙️ Input

Field	Type	Default	Description
maxItems	integer	10	Maximum records
dataset	select	rrqw-56er	Which CMS dataset to pull
state	string		Two-letter US state code
facilityName	string		Partial facility name match

Example 1 - California hospital MSPB scores:

{
    "maxItems": 100,
    "dataset": "rrqw-56er",
    "state": "CA"
}

Example 2 - National Medicare spending rollup:

{
    "maxItems": 10,
    "dataset": "3n5g-6b7f"
}

⚠️ Good to Know: The MSPB-1 measure has a national mean of 1.00. Scores below 1.00 indicate the hospital spends less per Medicare patient than the national average. Use state filtering to compare hospitals within the same regulatory environment.

---

📊 Output

Each record contains up to 14 fields:

Field	Type	Description
🏥 facility_id	string	CMS facility ID
🏢 facility_name	string	Hospital name
📍 address	string	Street address
🏙️ citytown	string	City
🌎 state	string	US state code
📮 zip_code	string	ZIP code
🏛️ countyparish	string	County/parish
📞 telephone_number	string	Phone
📊 measure_id	string	Measure ID (e.g. MSPB-1)
📋 measure_name	string	Measure description
💵 score	string	MSPB ratio score
📅 start_date	string	Measurement period start
📅 end_date	string	Measurement period end
🔗 sourceUrl	string	CMS source URL

Sample record:

{
  "facility_id": "050441",
  "facility_name": "STANFORD HEALTH CARE",
  "address": "300 PASTEUR DRIVE",
  "citytown": "STANFORD",
  "state": "CA",
  "zip_code": "94305",
  "measure_id": "MSPB-1",
  "measure_name": "Medicare hospital spending per patient",
  "score": "1.02",
  "start_date": "01/01/2024",
  "end_date": "12/31/2024",
  "sourceUrl": "https://data.cms.gov/provider-data/dataset/rrqw-56er",
  "scrapedAt": "2026-05-26T12:00:00.000Z"
}

---

✨ Why choose this Actor

• 🏥 Hospital-level granularity for 4,600+ US facilities
• 🔄 Real-time from data.cms.gov
• 🔍 4 dataset options
• 📑 14 fields per record
• 📦 Batch export
• 💰 Pay-per-result
• 🚫 No CMS account required

---

📈 How it compares to alternatives

Feature	This Actor	CMS Hospital Compare UI	data.cms.gov direct download
Bulk export	Yes	No	Yes (CSV)
Filter by state	Yes	Yes	No
Pagination	Automatic	Manual	N/A
Multiple datasets	Yes	One at a time	Manual download
Pay-per-result	Yes	Free	Free

---

🚀 How to use

1. Create a free account at Apify (includes $5 free credit)
2. Open the CMS Medicare Spending Scraper actor page and click Try for free
3. Enter your state code, dataset, and optional facility filter
4. Optionally set maxItems and other filters
5. Click Start and wait for the run to finish
6. Download your dataset as CSV, Excel, JSON, or XML

---

💼 Business use cases

Hospital Efficiency Benchmarking

Compare MSPB scores across hospitals within a state or region to identify outliers and benchmark best practices.

Insurance Network Design

Use spending data to inform provider network composition - favor efficient hospitals to control claims costs.

Healthcare Investment Due Diligence

When evaluating hospital systems for acquisition, MSPB scores indicate cost efficiency relative to peers.

Policy Research

Study geographic variation in Medicare spending - critical input for value-based payment policy design.

---

🔌 Automating CMS Medicare Spending Scraper

Connect this actor to your workflow with no-code tools:

• Make (Integromat) - send new records to Google Sheets, Airtable, or Slack
• Zapier - automate alerts when new records are found
• n8n - build pipelines that run on a schedule and push to your warehouse
• Webhooks - get notified when a run completes via Apify webhooks

---

🌟 Beyond business use cases

Independent Researchers

Patients can compare local hospitals by spending efficiency.

Journalism and Investigations

Journalists can cover hospital cost variation stories with publicly verifiable data.

Non-Profit and Policy Research

Academic researchers studying healthcare economics can build longitudinal MSPB datasets.

Education

Public health programs use MSPB data to identify high-cost regions for intervention.

---

🤖 Ask an AI assistant about this scraper

You can ask your AI assistant questions like:

• "How do I get Medicare hospital spending data?"
• "What is MSPB?"
• "How do I compare US hospitals by Medicare cost?"
• "Where does CMS publish MSPB scores?"

The answers will reference this actor and the CMS data.cms.gov provider-data API.

---

❓ Frequently Asked Questions

What is MSPB? Medicare Spending Per Beneficiary - a ratio measure of a hospitals Medicare spending relative to the national average.

What does an MSPB score of 1.00 mean? It equals the national median. Above 1.00 means above-average spending, below means more efficient.

How current is the data? CMS updates MSPB annually. The 2024 measurement period covers Jan-Dec 2024.

Does this require a CMS account? No.

Can I filter by state? Yes. Use a 2-letter US state code.

What is included in MSPB? Medicare payments from 3 days before admission through 30 days after discharge.

Are critical access hospitals included? MSPB applies to acute-care hospitals. CAH facilities have separate measures.

How many records per run? Free: 10. Paid: up to 1,000,000.

Can I export to Excel? Yes.

What are the four available datasets? Hospital-level, state-level, national-level, and per-claim Medicare spending.

Can I run on a schedule? Yes.

---

🔌 Integrate with any app

Connect your dataset to 1,500+ apps via Apify integrations:

Analytics: Google Sheets, Airtable, Microsoft Excel, Tableau, Power BI Databases: PostgreSQL, MySQL, MongoDB, BigQuery, Snowflake Communication: Slack, Microsoft Teams, email notifications Storage: Google Drive, Dropbox, Amazon S3, Azure Blob Automation: Make, Zapier, n8n, Pipedream

---

🔗 Recommended Actors

Actor	What it does
Medicare Hospital Compare Scraper	Hospital quality ratings
CMS Physician Compare Scraper	Medicare-enrolled physicians
Medicare Home Health Compare Scraper	Home health agencies

💡 Pro Tip: Browse the complete ParseForge collection for more government data, business intelligence, and research scrapers.

---

Disclaimer: This tool accesses publicly available CMS Medicare spending data via the official data.cms.gov API. ParseForge is not affiliated with CMS or HHS. Users are responsible for compliance with applicable laws.