Others titles

  • HCPCS Code and Place of Service Aggregate Report By State
  • HCPCS Aggregate Report By State
  • Medicare Providers Utilization and Payment Data State Aggregate Report
  • Physicians And Other Suppliers State Aggregate Report


  • HCPCS Code
  • Place of Service
  • Aggregate HCPCS table
  • Physician and Other Supplier
  • Utilization and Payment
  • State HCPCS aggregate table

Physician and Other Supplier Payment State HCPCS Aggregate Report

The dataset contains information on average utilization and payments (submitted charges, Medicare allowed amount, Medicare Payment amount, Medicare standardized payment amount) on Healthcare Common Procedure Coding System (HCPCS) codes on the state level. This Public Use File is based on information from Centers for Medicare and Medicaid Services administrative claims data for Medicare beneficiaries enrolled in the fee-for-service program available from the CMS Chronic Condition Data Warehouse.

Log in to download

Get The Data

  • The data in CSV format DOWNLOAD
  • Metadata in Human Readable format (PDF) DOWNLOAD
  • Metadata in Machine Readable format (JSON) DOWNLOAD
Your Data License
  • Research
    Non-Commercial, Share-Alike, Attribution Free Forever
  • Commercial
    Commercial Use, Remix & Adapt, White Label Buy Subscription


The data in the Physician and Other Supplier PUF covers the calendar year 2012 to 2015 and contains 100% final-action physician/supplier Part B non-institutional line items for the Medicare fee-for-service population. Each year, in the United States, health care insurers process over 5 billion claims for payment. The Healthcare Common Procedure Coding System (HCPCS) code is a standardized coding system that helps Medicare and other health insurance programs ensure the claims are processed in an orderly and consistent manner. The HCPCS Level II Code Set is one of the standard code sets used for this purpose. The HCPCS is divided into two principal subsystems, referred to as level I and level II of the HCPCS. Level I of the HCPCS is comprised of CPT (Current Procedural Terminology), a numeric coding system maintained by the American Medical Association (AMA).

The CPT, on the other hand, is a uniform coding system consisting of descriptive terms and identifying codes that are used primarily to identify medical services and procedures furnished by physicians and other healthcare professionals. Level II of the HCPCS is a standardized coding system that is used primarily to identify products, supplies, and services not included in the CPT codes, such as ambulance services and durable medical equipment, prosthetics, orthotics, and supplies (DMEPOS) when used outside a physician’s office. The Physician and Other Supplier PUF and the supplemental summary tables including the “Medicare State/National HCPCS Aggregate Tables” have been updated to include Medicare standardized payment amounts.

About this Dataset

Data Info

Date Created


Last Modified




Update Frequency


Temporal Coverage


Spatial Coverage

United States


John Snow Labs; Centers for Medicare and Medicaid Services;

Source License URL

Source License Requirements


Source Citation



HCPCS Code, Place of Service, Aggregate HCPCS table, Physician and Other Supplier, Utilization and Payment, State HCPCS aggregate table

Other Titles

HCPCS Code and Place of Service Aggregate Report By State, HCPCS Aggregate Report By State, Medicare Providers Utilization and Payment Data State Aggregate Report, Physicians And Other Suppliers State Aggregate Report

Data Fields

Name Description Type Constraints
YearYear of State HCPCS aggregate datadate-
NPPES_Provider_State_DescriptionThe state where the provider is located, as reported in National Plan and Provider Enumeration System (NPPES). The values include the 50 United States, District of Columbia, U.S. territories, Armed Forces areas, Unknown and Foreign Country.string-
HCPCS_CodeHCPCS code used to identify for the specific medical service furnished by the provider. HCPCS codes include two levels. Level I codes are the Current Procedural Terminology (CPT) codes that are maintained by the American Medical Association and Level II codes are created by CMS to identify products, supplies and services not covered by the CPT codes (such as ambulance services).string-
HCPCS_DescriptionHCPCS descriptions associated with CPT codes are consumer friendly descriptions provided by the AMA. All other descriptions are CMS Level II descriptions provided in the long form. Due to variable length restrictions, the CMS Level II descriptions have been truncated to 256 bytes. As a result, the same HCPCS description can be associated with more than one HCPCS code.string-
Is_HCPCS_Drug_IndicatorIdentifies whether the HCPCS code for the specific service furnished by the provider is an HCPCS listed on the Medicare Part B Drug Average Sales Price (ASP) Files. Yes = true, No = falseboolean-
Place_of_ServiceIdentifies whether the place of service submitted on the claims is a facility (value of ‘F’) or non-facility (value of ‘O’). Non-facility is generally an office setting; however other entities are included in non-facility.string-
Number_of_ProvidersNumber of providers within provider state, HCPCS code and place of service.integerlevel : Ratio
Number_of_ServicesNumber of services provided; note that the metrics used to count the number provided can vary from service to service.numberlevel : Ratio
Number_of_Unique_Beneficiary_Or_Provider_InteractionsNumber of unique beneficiary/provider interactions (e.g., if a single beneficiary sees two different providers for a given HCPCS code this value would be two).integerlevel : Ratio
Number_of_Distinct_Medicare_Beneficiary_Or_Per_Day_ServicesNumber of distinct Medicare beneficiary/per day services. Since a given beneficiary may receive multiple services of the same type (e.g., single vs. multiple cardiac stents) on a single day, this metric removes double-counting from the line service count to identify whether a unique service occurred.integerlevel : Ratio
Average_Submitted_Charge_AmountAverage of the charges that providers submit for the service.number-
Average_Medicare_Allowed_AmountAverage of the Medicare allowed amount for the service. Medicare allowed amounts includes the amount Medicare pays, the deductible and coinsurance amounts that the beneficiary is responsible for paying, and any amounts that a third party is responsible for paying.number-
Average_Medicare_Payment_AmountAverage amount that Medicare paid after deductible and coinsurance amounts have been deducted for the line item service.number-
Average_Medicare_Standardized_Payment_AmountAverage amount that Medicare paid after beneficiary deductible and coinsurance amounts have been deducted for the line item service and after standardization of the Medicare payment has been applied.number-

Data Preview

YearNPPES Provider State DescriptionHCPCS CodeHCPCS DescriptionIs HCPCS Drug IndicatorPlace of ServiceNumber of ProvidersNumber of ServicesNumber of Unique Beneficiary Or Provider InteractionsNumber of Distinct Medicare Beneficiary Or Per Day ServicesAverage Submitted Charge AmountAverage Medicare Allowed AmountAverage Medicare Payment AmountAverage Medicare Standardized Payment Amount
2016Alabama100Anesthesia for procedure on salivary gland with biopsyFalseF2102962942961284.57164.64126.17134.33
2016Alabama103Anesthesia for procedure on eyelidFalseF465301830053015792.098.6975.9481.19
2016Alabama104Anesthesia for electric shock treatmentFalseF265246016292457372.7872.5255.8759.37
2016Alabama120Anesthesia for biopsy of external middle and inner earFalseF297819807819771.79122.1592.88100.95
2016Alabama124Anesthesia for examination and biopsy of external middle and inner ear using an endoscopeFalseF29414141391.2159.9745.9650.14
2016Alabama126Anesthesia for incision of ear drumFalseF275615613615465.1475.0457.4262.06
2016Alabama140Anesthesia for procedure on eyeFalseF455369034623690803.4599.4276.1480.71
2016Alabama142Anesthesia for lens surgeryFalseF886491804302049179483.4572.8456.059.88
2016Alabama144Anesthesia for procedure on eye for corneal transplantFalseF1566636546631037.82129.9399.71106.0
2016Alabama145Anesthesia for retinal surgeryFalseF364375336603753988.08127.5198.5104.6