Skip to main content
Thirdwatchthirdwatch
Business & local data

Analyze CMS Research Payments

Separate research payments from general transfers of value and preserve recipient and manufacturer context.

Jul 21, 2026 · 2 min read · 354 words
See the scraper →

Separate research payments from general transfers of value and preserve recipient and manufacturer context. The CMS Open Payments Scraper provides a bounded connector to the authoritative publisher while preserving stable identifiers and source URLs on every row.

Start with a small, reviewable query

{"paymentType":"general","year":2025,"offset":0,"maxResults":1000}

Run a small sample before expanding the result limit. Inspect identifiers, dates, null values, units, qualifiers, and source fields in the Apify Dataset. Export as JSON for nested fields or CSV and Excel for review. For recurring ingestion, upsert on the publisher stable record dimensions instead of assuming every run is append-only.

Build a reliable data pipeline

The Actor uses direct HTTP requests, bounded inputs, transient-error retries, and explicit empty-result failures. It does not require a browser or paid proxy, so scheduled runs remain inexpensive. Keep the input in an Apify Task, send completion through a webhook, and load the dataset into a warehouse or dashboard. Store collection time downstream so source revisions can be distinguished from newly published records.

Interpret the source responsibly

Official publication does not remove the need for context. Preserve footnotes, status fields, dataset type, reporting period, and source attribution. A missing value is not zero, and a revised record is not necessarily a new event. For legal, medical, financial, safety, protection, or public-policy decisions, confirm material findings with the publisher and a qualified specialist.

This workflow is designed for healthcare transparency teams, journalists, and compliance researchers. It is an independent integration and is not affiliated with or endorsed by the source institution.

Separate direct and associated research payments

Research disclosures can involve a principal investigator, an institution, associated researchers, and a product or study context. Preserve those roles instead of assigning the full amount to every named professional. Analyze payment dates, submitting manufacturers, recipient institutions, study names, and product categories, while keeping the CMS record identifier for verification. Compare like program years because publication rules and coverage can change. Large values deserve contextual review, not an automatic risk label. When joining with trials or publications, document that name matching is probabilistic unless stable identifiers support the link.

Frequently asked questions

Does this workflow require a source API key?

No. It uses the source publisher public keyless interface.

Can I schedule the export?

Yes. Save the input as an Apify Task and attach a schedule or webhook.

Related

Try it yourself

100 free credits, no credit card.

About 30 real searches. Add the MCP to Claude or Cursor in two minutes.