CMS Medicare Provider Utilization and Payment Data: Physician and Other Supplier

For a tutorial video that walks you through the process of using the Open Data Bits library of documentation to build your own open data mashups, we have created a video that can be watched by clicking here.

Note: The data set Medicare Provider Utilization and Payment Data: Physician and Other Supplier from CMS contains CPT codes that are the intellectual property of the AMA. There is a licensing document available from CMS at the Data Source Link below which details the terms of the license.

Data Source Link

https://www.cms.gov/Research-Statistics-Data-and-Systems/Statistics-Trends-and-Reports/Medicare-Provider-Charge-Data/Physician-and-Other-Supplier.html

Available Access Formats

TXT

XLXS

Sources and Modeling

Row Color	Derived Column
Row Color	Column Not Used by Open Data Bits

Logical Model

Hierarchies

County Code > State Code > Zip Code
County Code > State Code > City Code

Calculated Columns & Calculations

Name	DAX Expression	Type
Address	=CONCATENATE([Street Address 1],CONCATENATE(“, “,CONCATENATE([City],CONCATENATE(“, “,CONCATENATE([State Code],CONCATENATE(” “,LEFT([Zip Code],5)))))))	Calculated Column
Zip Code 5 Digit Key	=LEFT([Zip Code],5)	Calculated Column
Total Number of Services	=SUM([Number of Services])	Calculation