Where can I find Medicare provider utilization data?
Quick Answer
Medicare provider utilization data is publicly available through the CMS Medicare Physician & Other Practitioners dataset at data.cms.gov. This dataset contains billing records for 1,175,281 Medicare-enrolled providers, detailing every CPT/HCPCS code billed, service frequency, average Medicare payment per service, and total Medicare allowed amounts. The data is published annually, typically with an 18-24 month lag. You can download the raw tab-delimited files (approximately 2GB+ per year) directly from data.cms.gov, or use tools like NPIxray that process the data into actionable benchmarking reports. The dataset covers individual providers (by NPI number) and includes specialty classification, geographic location (state and RUCA rural/urban designation), average beneficiary demographics, and service-level detail across 8,153,253 billing line items. For quick lookups without downloading the full dataset, NPIxray offers free instant analysis of any provider's Medicare utilization patterns, E&M coding distribution, and revenue gap versus specialty peers.
CMS Public Use Files: The Primary Source
The CMS Medicare Physician & Other Practitioners dataset is the definitive source for provider utilization data. Published by the Centers for Medicare & Medicaid Services, it contains one row per provider per HCPCS/CPT code, showing exactly how many times each service was billed and total Medicare payments received. Key fields include: Rndrng_NPI (provider NPI number), Rndrng_Prvdr_Type (specialty), HCPCS_Cd (CPT/HCPCS code), Tot_Srvcs (total services), Tot_Benes (total beneficiaries), Avg_Mdcr_Pymt_Amt (average Medicare payment), and Tot_Mdcr_Pymt_Amt (total Medicare payment). The dataset uses a suppression threshold: any code billed to fewer than 11 beneficiaries is excluded to protect patient privacy. This means low-volume services may not appear. The data is available as downloadable CSV/tab-delimited files at data.cms.gov/provider-summary-by-type-of-service. Each annual release covers approximately 1.17 million providers and 8.15 million billing line items.
How to Download and Process the Data
To download the raw CMS data, visit data.cms.gov and navigate to the Medicare Physician & Other Practitioners section. Select the most recent data year and download the Provider and Service file (approximately 2-4 GB compressed). The file is tab-delimited and can be opened in tools like Python/pandas, R, PostgreSQL, or even Excel for smaller subsets. For practical analysis, most users filter by provider NPI, specialty, state, or specific CPT codes. Important processing considerations: handle the 11-beneficiary suppression threshold, normalize specialty names (CMS uses over 100 taxonomy categories), and account for Medicare-only data (this excludes commercial insurance, Medicaid, and Medicare Advantage in many cases). NPIxray has pre-processed the entire dataset covering all 1,175,281 providers and 8,153,253 billing records, making instant lookups possible without any data download or processing.
What Utilization Data Reveals About Revenue Gaps
Provider utilization data is the foundation for identifying revenue gaps. By comparing an individual provider's billing patterns against specialty benchmarks, you can identify: E&M coding distribution imbalances (e.g., a provider billing 65% at 99213 when peers average 45%), underutilization of care management programs (only 4.2% of eligible providers bill CCM code 99490), missed preventive services like Annual Wellness Visits (AWV adoption averages just 38% of eligible Medicare beneficiaries), and RPM opportunities where only 2.1% of qualifying providers currently bill 99457/99458. NPIxray's analysis of CMS data shows that the average internal medicine practice leaves approximately $94,000 in annual revenue uncaptured across E&M optimization, CCM, RPM, and AWV programs combined. Family medicine practices average $67,500 in missed revenue. Cardiology practices can miss over $167,000 annually, primarily from RPM and CCM underadoption. These revenue gaps are invisible without utilization data analysis.
Other Sources of Medicare Provider Data
Beyond the primary utilization dataset, CMS publishes several complementary data files. The NPPES NPI Registry provides real-time provider demographic lookups (name, address, specialty, taxonomy) but no billing data. The Medicare Provider Enrollment file shows enrollment status and reassignment relationships. The MIPS Performance dataset shows quality measure scores and payment adjustments. The Part D Prescriber file covers prescription drug utilization. The Referring/Ordering Provider file shows referral network patterns. For hospital-level data, the Medicare Inpatient and Outpatient PUFs provide facility-level utilization statistics. All these datasets use NPI as the linking key, enabling comprehensive provider profiling when combined. NPIxray integrates multiple CMS datasets to provide a unified view of provider practice patterns, making it unnecessary to manually cross-reference separate files.
Frequently Asked Questions
Is Medicare utilization data free?
Yes. All CMS Medicare Physician & Other Practitioners data is free and publicly available at data.cms.gov. No registration or payment is required to download the full dataset.
How current is the CMS utilization data?
CMS typically publishes utilization data with an 18-24 month lag. The most recent release generally covers data from two calendar years prior.
Does the data include commercial insurance?
No. CMS utilization data covers Medicare Fee-for-Service claims only. It excludes commercial insurance, Medicaid, Medicare Advantage, and self-pay services.
Can I look up a specific doctor's billing?
Yes. The dataset is indexed by NPI number. NPIxray provides free instant lookups for any of the 1,175,281 providers in the dataset without downloading the raw files.
See Your Practice's Specific Numbers
Enter any NPI number to instantly see missed revenue from E&M coding gaps, CCM, RPM, BHI, and AWV programs — based on real CMS Medicare data.
Scan Your NPI