Hospital Price Transparency Scraper

🏥 Hospital price transparency scraper for CMS data

Hospital Price Transparency Scraper collects public CMS hospital facility data and public hospital machine-readable file (MRF) rates. Use this hospital price transparency scraper to export facility profiles, CPT or HCPCS procedure codes, gross charges, discounted cash prices, payer names, plan names, negotiated dollar rates, percentage or algorithm details, and source MRF metadata.

The Actor works with two practical target types. You can search the official CMS Provider Data hospital facility dataset by state, facility name, or CMS Certification Number. You can also paste direct public hospital MRF URLs to parse payer-rate charges. Results are saved to the default Apify dataset, where you can export CSV, JSON, Excel, XML, or call the same data through the Apify API.

For a first run, keep the prefilled CMS example MRF URL, CA in Facility state, and Maximum records at 500. Add a billing code or payer filter when you want a narrower MRF rate export.

✅ What this Actor does

• Searches CMS hospital facility profiles by state, hospital name, or CMS Certification Number.
• Parses direct public hospital MRF URLs for payer and procedure rates.
• Supports common CMS JSON, CSV, gzip JSON, and gzip CSV MRF files when the public file follows common CMS layouts.
• Filters MRF rates by billing code type, exact billing code, and payer or plan name.
• Saves one dataset item per accepted facility profile or payer-rate charge.
• Returns source-backed hospital identity, MRF provenance, billing codes, payer context, setting, methodology, and charge amounts when the source provides them.
• Works without a CMS API key, Turquoise login, hospital account, cookies, or user-provided proxy settings.
• Charges only for saved facility profiles and payer-rate charges.

This Actor does not discover a direct MRF URL for every US hospital. Use the CMS facility search when you need hospital metadata, and paste direct public MRF URLs when you need charge-rate rows.

📦 Data you can export

Each item has a recordType so you can filter facility profiles from payer-rate charges in a spreadsheet or warehouse.

Facility rows include:

• facility.ccn, facility.npi, and facility.name
• facility.address, facility.city, facility.state, facility.zipCode, and facility.county
• facility.phoneNumber
• facility.facilityType and facility.ownership
• facility.emergencyServices and facility.overallRating
• facility.profileUrl

Rate rows include:

• mrf.url, mrf.version, and mrf.lastUpdated
• billing.code, billing.codeType, and billing.description
• payer.name and payer.planName
• setting and methodology
• charges.gross, charges.discountedCash, charges.negotiatedDollar, charges.negotiatedPercentage, and charges.negotiatedAlgorithm
• charges.minimum, charges.maximum, charges.estimated, and charges.additionalNotes

Fields can be null when the CMS source or hospital MRF does not publish that value.

🎯 Common use cases

• Build a CMS hospital facility list for one state.
• Join hospital identities with MRF charge data.
• Compare negotiated rates for a CPT or HCPCS code across payers and plans.
• Pull cash prices, gross charges, and min/max rates into a pricing analysis workflow.
• Monitor public hospital price transparency files with scheduled Apify runs.
• Feed source-backed hospital price data into procurement, compliance, market research, or data warehouse pipelines.

▶️ How to run it

1. Open the Actor input.
2. Choose one or both target sections:
   • Add direct public MRF URLs in MRF file URLs.
   • Add a Facility state, Facility names, or CMS Certification Numbers for CMS facility profiles.
3. Optional: filter MRF rates by Billing code type, Billing codes, and Payer names.
4. Set Maximum records to control output size and cost.
5. Start the Actor and open the dataset.

You can run the Actor from Apify Console, the Apify API, schedules, webhooks, or integrations. The default dataset can be exported as CSV, JSON, Excel, XML, RSS, or HTML.

⚙️ Input example

Parse one public CMS example MRF for a CPT code and payer:

{
  "mrfUrls": [
    {
      "url": "https://raw.githubusercontent.com/CMSgov/hospital-price-transparency/master/examples/JSON/v3_json_format_example.json"
    }
  ],
  "billingCodeType": "CPT",
  "billingCodes": ["70551"],
  "payerNames": ["Platform"],
  "maxRecords": 50
}

Collect CMS facility profiles in one state:

{
  "facilityState": "WY",
  "maxRecords": 50
}

📊 Output example

Facility profile:

{
  "recordType": "facility",
  "facility": {
    "ccn": "530002",
    "npi": null,
    "name": "CAMPBELL COUNTY HEALTH",
    "address": "501 SOUTH BURMA AVENUE",
    "city": "GILLETTE",
    "state": "WY",
    "zipCode": "82716",
    "county": "CAMPBELL",
    "phoneNumber": "(307) 688-1000",
    "facilityType": "Acute Care Hospitals",
    "ownership": "Government - Hospital District or Authority",
    "emergencyServices": true,
    "overallRating": 3,
    "profileUrl": "https://www.medicare.gov/care-compare/details/hospital/530002"
  },
  "mrf": null,
  "billing": null,
  "payer": null,
  "setting": null,
  "methodology": null,
  "charges": null
}

MRF payer-rate charge:

{
  "recordType": "rate",
  "facility": {
    "ccn": null,
    "npi": "0000000001,0000000002,0000000003",
    "name": "West Mercy Hospital",
    "address": "12 Main Street, Fullerton, CA  92832",
    "city": null,
    "state": "CA",
    "zipCode": null,
    "county": null,
    "phoneNumber": null,
    "facilityType": null,
    "ownership": null,
    "emergencyServices": null,
    "overallRating": null,
    "profileUrl": null
  },
  "mrf": {
    "url": "https://raw.githubusercontent.com/CMSgov/hospital-price-transparency/master/examples/JSON/v3_json_format_example.json",
    "version": "3.0.0",
    "lastUpdated": "2026-04-01"
  },
  "billing": {
    "code": "70551",
    "codeType": "CPT",
    "description": "MRI of brain (no contrast)"
  },
  "payer": {
    "name": "Platform Health Insurance",
    "planName": "PPO"
  },
  "setting": "outpatient",
  "methodology": "fee schedule",
  "charges": {
    "gross": 1200,
    "discountedCash": 1080,
    "negotiatedDollar": 400,
    "negotiatedPercentage": null,
    "negotiatedAlgorithm": null,
    "minimum": 250,
    "maximum": 400,
    "estimated": null,
    "additionalNotes": null
  }
}

💳 Pricing

This Actor uses pay-per-event pricing. You pay for each saved facility profile or payer-rate charge. Empty searches, startup, skipped inputs, parse attempts, and no-result runs are not charged as result events.

⚠️ Limits and caveats

• The Actor returns data exactly as public CMS sources and hospital MRF files publish it. It does not fix missing prices, missing payer names, or incomplete MRF fields.
• Facility search uses public CMS facility data. It does not imply that a direct MRF URL is known for every facility.
• MRF parsing works for common CMS JSON and CSV layouts. Highly custom or invalid files may produce no rows.
• Private files, login-protected files, blocked downloads, and unreachable URLs are reported in logs, not as dataset rows.
• This is a data extraction tool, not medical, legal, billing, or reimbursement advice.

❓ FAQ

Can this Actor find every hospital's MRF URL?

No. It can search CMS facility profiles and parse direct public MRF URLs you provide. It does not claim universal MRF URL discovery.

Do I need a CMS API key or hospital login?

No. The Actor is built for public CMS facility data and public hospital MRF files. It does not use cookies, CMS API keys, Turquoise accounts, or private hospital credentials.

Can I filter by CPT code and payer?

Yes. Use Billing code type, Billing codes, and Payer names to keep matching MRF rate rows before they are saved.

Why are some fields null?

CMS facility records and hospital MRF files do not always publish every field. Null values mean the source did not provide that value or it does not apply to that row type.

📝 Changelog

• 1.0: Initial release.

🆘 Support

For issues, questions, or feature requests, file a ticket and I'll fix or implement it in less than 24h 🫡

🔗 Other actors

• GLEIF LEI Lookup ↗ - Enrich company and vendor records with official Legal Entity Identifier data.
• World Bank Projects Scraper ↗ - Export public World Bank project and indicator rows for research workflows.
• Business Address Scraper ↗ - Extract physical business addresses from public company websites.
• Yellow Pages Scraper ↗ - Collect public US business listings, phone numbers, addresses, and websites.
• Website Emails Scraper ↗ - Find public contact emails from a list of websites.

Made with ❤️ by Maxime Dupré