CMS Medicare Provider and DME Data Refresh Case Study
FastHSR used Medicare claims and exact CMS public-use file methods to create recent-year, rolling 12-month, and quarterly provider-service and DME files for a client's data product.
Home / Medicare & Medicaid Claims Data Analytics / CMS Medicare Provider and DME Data Refresh Case Study
Client question
A client found that two CMS public data products were especially useful in building their own healthcare data product:
- Medicare Physician & Other Practitioners - by Provider and Service.
- Medicare Durable Medical Equipment, Devices & Supplies - by Referring Provider and Service.
The challenge was timing. The public CMS releases were useful, but too old for several product use cases. The client needed a recent-year version, rolling 12-month versions, and quarterly versions delivered quickly and at the same kind of grain as the CMS files.
FastHSR approach
FastHSR recreated the exact CMS methods using Medicare claims. We followed the CMS provider, service, and referring-provider aggregation logic so the output aligned with the public data products while adding more current time windows.
- Physician and other practitioner file: provider-by-service tables based on Medicare claims.
- DME file: referring-provider-by-service tables for durable medical equipment, devices, and supplies.
- Recent-year view: a full-year file built from the latest available claims period.
- Rolling 12-month view: data refreshed around the most recent 12 months available.
- Quarterly view: provider-service and referring-provider-service outputs by quarter.
CMS-style data engineering
The work required claims-scale programming rather than a small analytic extract. FastHSR mapped raw claims into CMS-style public-file fields, applied provider and service definitions, generated the required aggregation levels, validated record counts and payment/utilization totals, and packaged the outputs for product ingestion.
The resulting files were very large, with long tables containing tens of millions of records. The output needed to be consistent, repeatable, and ready for downstream data-product workflows.
Deliverables
- Recent-year Medicare Physician & Other Practitioners by provider and service file.
- Recent-year Medicare Durable Medical Equipment, Devices & Supplies by referring provider and service file.
- Rolling 12-month provider-service and referring-provider-service files.
- Quarterly provider-service and referring-provider-service files.
- Large-format tables with tens of millions of records for data-product integration.
- Documentation of the CMS-style logic used to create the files.
Impact
The client was able to enhance its product with fresher Medicare provider-service and DME intelligence while retaining the familiar CMS public-data structure. FastHSR delivered the large outputs in a short time, allowing the client to improve product timeliness without building the full claims-processing pipeline internally.
Use cases
- Healthcare provider market intelligence.
- Procedure and service line volume analysis.
- DME and supplies market analysis.
- Referral-source analytics for DME products.
- Data-product enhancement with recent Medicare claims-derived files.
- Quarterly monitoring of provider-service activity.
Frequently asked questions
Why recreate CMS Medicare public data files?
CMS public data products are widely understood and useful, but they can lag current market activity. Recreating the same methods from recent Medicare claims allows clients to preserve a familiar structure while adding more current time periods.
What makes this hard?
The files are not small summaries. They require detailed claims processing, provider attribution, service classification, time-window construction, validation, and delivery of long tables with tens of millions of rows.
Can the output support data-product workflows?
Yes. FastHSR can deliver flat files or other structured outputs designed for ingestion into a client's product, analytics platform, or internal data pipeline.
For CMS-style Medicare public data refreshes, provider-service analytics, DME analytics, or recent Medicare claims-derived data products, please email us.