HEADER: If you love Medicare Part B utilization data, the agency has released its summary 2024 data files in Excel.
###
CMS releases Part B data annual in two different forms. Sometime in the fall, it releases Part B data for the prior year (for us, CY2024) in Excel spreadsheets. Find these here:
https://www.cms.gov/data-research/statistics-trends-and-reports/part-b-national-summary-data-file
(I believe they've belatedly released the 2023 data along with 2024.)
This is simple data - CPT code, volume of national utilization, volume of dollars paid per code.
##
At a longer delay, CMS releases an awesome cloud database of CPT code utilization by provider. (E.g. Dr. Alvin Smith had 1,100 92114 office visits and 800 92115 office visits.) Find that here, for CY2023:
##
Quick Look - PLA Codes
In Cy2024 data, there are PLA codes up to 0503U. Together with"M" codes, these PLA codes were paid $682M dollars. But the distribution among the 500 codes was highly skewed, with the top 15 codes paid 86% of the money, and the top 4 codes paid 52% of the money. Click to enlarge.
##
Thanks to Jack Meehan at Nephron for flagging the data release.
##
The CPT utilization files provide code numbers, but not descriptors. Skilled Excel jockeys should be able to merge the code + descriptor tables found in the CLFS itself, with the CPT codes of the annual data, and get a spreadsheet with code + descriptor + dollars paid.
##
If you're still reading, you might enjoy an article about using Excel "PivotCharts" rather than "PivotTables" - at MakeUseOf here. And you might enjoy a detailed automatic AI anaysis (via Chat GPT 5) of CMS new test pricing data - here.