Physician and Other Supplier Payment National HCPCS Aggregate Report

$447.50 / year

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 national 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 Chronic Condition Data Warehouse.


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. 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.

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, National HCPCS Aggregate Table

Other Titles

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

YearYear of national HCPCS aggregate datadate-
HCPCS_CodeHCPCS code used to identify 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_DescriptionDescription of the HCPCS code for the specific medical service furnished by the provider. HCPCS 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) File.boolean-
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 in the country with HCPCS code and place of service.integerlevel : Ratio
Number_of_ServicesTotal provider services.numberlevel : Ratio
Number_of_Unique_Beneficiary_Or_Provider_InteractionsTotal Medicare beneficiaries receiving the provider services.integerlevel : Ratio
Number_of_Distinct_Medicare_Beneficiary_Or_Per_Day_ServicesSince 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 Medicare Standardized Amount which is the average 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-
YearHCPCS 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
20160008MOnc breast risk scoreFalseO52011941997908.153419.43351.013351.03
2016100Anesthesia for procedure on salivary gland with biopsyFalseF97351221612187122131709.57233.89181.3182.48
2016100Anesthesia for procedure on salivary gland with biopsyFalseO597272721145.43145.35110.99113.16
2016102Anesthesia for procedure to repair lip defect present at birthFalseF657070701308.12178.69137.86140.33
2016103Anesthesia for procedure on eyelidFalseO1008393539123934915.08126.6597.1897.27
2016103Anesthesia for procedure on eyelidFalseF214601233311215091232251000.69150.95116.27117.41
2016104Anesthesia for electric shock treatmentFalseO12517019741701636.0179.3760.9262.85
2016104Anesthesia for electric shock treatmentFalseF12625190539103340190491618.6285.3965.8466.14
20160010MOncology (high-grade prostate cancer), biochemical assay of four proteins (total psa, free psa, intact psa and human kallidrein 2 (hk2)) plus patient age, digital rectal examination status, and no history of positive prostate biopsy, utilizing plasma, progFalseO41346713233134661900.05333.54260.38260.38
2016120Anesthesia for biopsy of external middle and inner earFalseF130562378323402237781456.79198.86153.8154.89