Physician and Other Supplier Payment State HCPCS Aggregate Report

$447.50 / year

The dataset contains information on utilization and payments (Average submitted charges, Average Medicare allowed amount, Average Medicare Payment amount, Medicare standardized payment amount) on HCPCS codes on the state level. This Public Use File is based on information from CMS administrative claims data for Medicare beneficiaries enrolled in the fee-for-service program available from the CMS Chronic Condition Data Warehouse. 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 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 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.

Date Created


Last Modified




Update Frequency


Temporal Coverage


Spatial Coverage

United States


John Snow Labs => Centers for Medicare and Medicaid Services

Source License URL

John Snow Labs Standard License

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

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). CPT codes, descriptions and other data only are copyright 2014 American Medical Association. All rights reserved. CPT is a registered trademark of the American Medical Association (AMA).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-
Minimum_Submitted_Charge_AmountThe minimum submitted charge for the service.number-
Maximum_Submitted_Charge_AmountThe maximum submitted charge for the service.number-
Standard_Deviation_Of_Submitted_Charge_AmountStandard deviation of the charge amounts submitted by providers. The standard deviation indicates the amount of variation from the average submitted charge amount that exists within HCPCS code and place of 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-
Minimum_Medicare_Allowed_AmountThe minimum Medicare allowed amount for the service.number-
Maximum_Medicare_Allowed_AmountThe maximum Medicare allowed amount for the service.number-
Standard_Deviation_Of_Medicare_Allowed_AmountStandard deviation of the Medicare allowed amount. The standard deviation indicates the amount of variation from the average Medicare allowed amount that exists within HCPCS code and place of service.number-
Average_Medicare_Payment_AmountAverage amount that Medicare paid after deductible and coinsurance amounts have been deducted for the line item service.number-
Minimum_Medicare_Payment_AmountThe minimum Medicare payment amount for the service.number-
Maximum_Medicare_Payment_AmountThe maximum Medicare payment amount for the service.number-
Standard_Deviation_Of_Medicare_Payment_AmountStandard deviation of the Medicare payment amount. The standard deviation indicates the amount of variation from the average Medicare payment amount that exists within HCPCS code and place of 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-
2014Kansas76497CT scanfalseFacility61111115049.9339.1439.14
2014Utah76498MRI scanfalseFacility215141535073.0157.2457.24
2014Nebraska88177Pap testfalseFacility97733337721.416.7811.98
2014Hawaii70030X-ray of eyefalseFacility1222202027.88.75.926.2