Physician and Other Supplier Data CY 2012
The Physician and Other Supplier Public Use File (Physician and Other Supplier PUF) provides information on services and procedures provided to Medicare beneficiaries by physicians and other healthcare professionals. The Physician and Other Supplier PUF contains information on utilization, payment (allowed amount and Medicare payment), and submitted charges organized by National Provider Identifier (NPI), Healthcare Common Procedure Coding System (HCPCS) code, and place of service. This PUF is based on information from CMS’s National Claims History Standard Analytic Files. The data in the Physician and Other Supplier PUF covers calendar year 2012 and contains 100% final-action physician/supplier Part B non-institutional line items for the Medicare fee-for-service population.
While the Physician and Other Supplier PUF has a wealth of information on payment and utilization for Medicare Part B services, the dataset has a number of limitations. Of particular importance is the fact that the data may not be representative of a physician’s entire practice as it only includes information on Medicare fee-for-service beneficiaries. In addition, the data are not intended to indicate the quality of care provided and are not risk-adjusted to account for differences in underlying severity of disease of patient populations. For additional limitations, please review the methodology document available below.
Data are available in two formats:
- An online interactive dataset (allows users to sort and filter data directly without downloading).
- Tab delimited file format (requires importing into database or statistical software; SAS® read-in language is included in the download ZIP package)
CMS has also created two summary tables: 1) aggregated information by physician or other supplier and 2) aggregated information by State and HCPCS code. A detailed methodology document can be found in the Downloads section below which contains important information regarding the limitations of data usage.
10/05/15 UPDATE: Original CY 2012 Medicare Physician and Other Supplier Aggregate table has been updated to include demographic and health information associated with the provider’s beneficiary panel. This provider-level summary now includes aggregated information on beneficiary age, sex, race, Medicare and Medicaid entitlement, sixteen (16) chronic conditions and risk scores.
Interactive Dataset: Medicare Physician and Other Supplier PUF, CY2012, Interactive Dataset
Downloadable Tab Delimited Format: Medicare Physician and Other Supplier PUF, CY2012, Tab Delimited format
[Note: This Compressed ZIP package contains the tab delimited data file (Medicare_Provider_Util_Payment_PUF_CY2012.txt) which is 1.7GB uncompressed and contains more than 9 million records, thus importing this file into Microsoft Excel will result in an incomplete loading of data. Use of database or statistical software is required; a SAS® read-in statement is supplied. Additionally, this ZIP package contains the following supporting documents: CMS_AMA_CPT_license_agreement.pdf, and Medicare-Provider-Util-Payment-PUF-SAS-Infile.sas]
Provider Summary Table:
Interactive Dataset: Medicare Physician and Other Supplier Aggregate table, CY2012, Interactive Dataset
Procedure Summary Tables:
Interactive Dataset: Medicare National/HCPCS Aggregate table, CY2012, Interactive Dataset
Downloadable Excel: Medicare National/HCPCS Aggregate table, CY2012, Microsoft Excel (.xlsx)
Interactive Dataset: Medicare State/HCPCS Aggregate table, CY2012, Interactive Dataset
Downloadable Excel: Medicare State/HCPCS Aggregate table, CY2012, Microsoft Excel (.xlsx)
Inquiries regarding this data can be sent to MedicareProviderData@cms.hhs.gov.
To receive email notifications, please sign up for the Medicare Provider Data GovDelivery subscription here.