About this Dataset

Physician/Supplier Procedure Summary

The Physician/Supplier Procedure Summary (PSPS) data provides a summary of calendar year Medicare Part B carrier and durable medical equipment fee-for-service (FFS) claims. The file is organized by carrier, pricing locality, Healthcare Common Procedure Coding System (HCPCS) code, HCPCS modifier, provider specialty, type of service, and place of service. The summarized fields are total submitted services and charges, total allowed services and charges, total denied services and charges, and total payment amounts. This dataset is produced annually and is typically available in July (i.e., data for CY2015 is usually available in July 2016).
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:18:53.371843
Tags: health-care-use-payments, medicare, original-medicare

Tables

Physician/Supplier Procedure Summary : 2010-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2010_12_31

350.25 MB
18,040,704 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2010_12_31 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" BIGINT,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" BIGINT,
  "hcpcs_second_modifier_cd" VARCHAR,
  "submitted_service_cnt" DOUBLE,
  "submitted_charge_amt" DOUBLE,
  "allowed_charge_amt" DOUBLE,
  "denied_services_cnt" DOUBLE,
  "denied_charge_amt" DOUBLE,
  "assigned_services_cnt" DOUBLE,
  "nch_payment_amt" DOUBLE,
  "hcpcs_asc_ind_cd" VARCHAR,
  "error_ind_cd" BIGINT,
  "betos_cd" VARCHAR
);

Physician/Supplier Procedure Summary : 2011-11-09

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2011_11_09

273.71 MB
13,841,780 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2011_11_09 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" BIGINT,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" BIGINT,
  "hcpcs_second_modifier_cd" VARCHAR,
  "submitted_service_cnt" DOUBLE,
  "submitted_charge_amt" DOUBLE,
  "allowed_charge_amt" DOUBLE,
  "denied_services_cnt" DOUBLE,
  "denied_charge_amt" DOUBLE,
  "assigned_services_cnt" DOUBLE,
  "nch_payment_amt" DOUBLE,
  "hcpcs_asc_ind_cd" VARCHAR,
  "error_ind_cd" BIGINT,
  "betos_cd" VARCHAR
);

Physician/Supplier Procedure Summary : 2012-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2012_12_31

284.57 MB
14,383,393 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2012_12_31 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" BIGINT,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" BIGINT,
  "hcpcs_second_modifier_cd" VARCHAR,
  "submitted_service_cnt" DOUBLE,
  "submitted_charge_amt" DOUBLE,
  "allowed_charge_amt" DOUBLE,
  "denied_services_cnt" DOUBLE,
  "denied_charge_amt" DOUBLE,
  "assigned_services_cnt" DOUBLE,
  "nch_payment_amt" DOUBLE,
  "hcpcs_asc_ind_cd" VARCHAR,
  "error_ind_cd" BIGINT,
  "betos_cd" VARCHAR
);

Physician/Supplier Procedure Summary : 2013-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2013_12_31

292.12 MB
14,741,617 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2013_12_31 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" BIGINT,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" BIGINT,
  "hcpcs_second_modifier_cd" VARCHAR,
  "submitted_service_cnt" DOUBLE,
  "submitted_charge_amt" DOUBLE,
  "allowed_charge_amt" DOUBLE,
  "denied_services_cnt" DOUBLE,
  "denied_charge_amt" DOUBLE,
  "assigned_services_cnt" DOUBLE,
  "nch_payment_amt" DOUBLE,
  "hcpcs_asc_ind_cd" VARCHAR,
  "error_ind_cd" BIGINT,
  "betos_cd" VARCHAR
);

Physician/Supplier Procedure Summary : 2014-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2014_12_31

268.01 MB
13,552,449 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2014_12_31 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" BIGINT,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" BIGINT,
  "hcpcs_second_modifier_cd" VARCHAR,
  "submitted_service_cnt" DOUBLE,
  "submitted_charge_amt" DOUBLE,
  "allowed_charge_amt" DOUBLE,
  "denied_services_cnt" DOUBLE,
  "denied_charge_amt" DOUBLE,
  "assigned_services_cnt" DOUBLE,
  "nch_payment_amt" DOUBLE,
  "hcpcs_asc_ind_cd" VARCHAR,
  "error_ind_cd" BIGINT,
  "betos_cd" VARCHAR
);

Physician/Supplier Procedure Summary : 2016-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2016_12_31

284.93 MB
14,404,770 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2016_12_31 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" BIGINT,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" DOUBLE,
  "hcpcs_second_modifier_cd" VARCHAR,
  "submitted_service_cnt" DOUBLE,
  "submitted_charge_amt" DOUBLE,
  "allowed_charge_amt" DOUBLE,
  "denied_services_cnt" DOUBLE,
  "denied_charge_amt" DOUBLE,
  "assigned_services_cnt" DOUBLE,
  "nch_payment_amt" DOUBLE,
  "hcpcs_asc_ind_cd" VARCHAR,
  "error_ind_cd" BIGINT,
  "betos_cd" VARCHAR
);

Physician/Supplier Procedure Summary : 2017-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2017_12_31

285.95 MB
14,484,046 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2017_12_31 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" BIGINT,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" BIGINT,
  "hcpcs_second_modifier_cd" VARCHAR,
  "submitted_service_cnt" DOUBLE,
  "submitted_charge_amt" DOUBLE,
  "allowed_charge_amt" DOUBLE,
  "denied_services_cnt" DOUBLE,
  "denied_charge_amt" DOUBLE,
  "assigned_services_cnt" DOUBLE,
  "nch_payment_amt" DOUBLE,
  "hcpcs_asc_ind_cd" VARCHAR,
  "error_ind_cd" BIGINT,
  "betos_cd" VARCHAR
);

Physician/Supplier Procedure Summary : 2018-03-16

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2018_03_16

285.51 MB
14,422,961 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2018_03_16 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" BIGINT,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" BIGINT,
  "hcpcs_second_modifier_cd" VARCHAR,
  "submitted_service_cnt" DOUBLE,
  "submitted_charge_amt" DOUBLE,
  "allowed_charge_amt" DOUBLE,
  "denied_services_cnt" DOUBLE,
  "denied_charge_amt" DOUBLE,
  "assigned_services_cnt" DOUBLE,
  "nch_payment_amt" DOUBLE,
  "hcpcs_asc_ind_cd" VARCHAR,
  "error_ind_cd" BIGINT,
  "betos_cd" VARCHAR
);

Physician/Supplier Procedure Summary : 2019-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2019_12_31

281.8 MB
14,174,975 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2019_12_31 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" BIGINT,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" BIGINT,
  "hcpcs_second_modifier_cd" VARCHAR,
  "submitted_service_cnt" DOUBLE,
  "submitted_charge_amt" DOUBLE,
  "allowed_charge_amt" DOUBLE,
  "denied_services_cnt" DOUBLE,
  "denied_charge_amt" DOUBLE,
  "assigned_services_cnt" DOUBLE,
  "nch_payment_amt" DOUBLE,
  "hcpcs_asc_ind_cd" VARCHAR,
  "error_ind_cd" BIGINT,
  "betos_cd" VARCHAR
);

Physician/Supplier Procedure Summary : 2020-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2020_12_31

293.89 MB
14,876,125 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2020_12_31 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" BIGINT,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" BIGINT,
  "hcpcs_second_modifier_cd" VARCHAR,
  "psps_submitted_service_cnt" DOUBLE,
  "psps_submitted_charge_amt" DOUBLE,
  "psps_allowed_charge_amt" DOUBLE,
  "psps_denied_services_cnt" DOUBLE,
  "psps_denied_charge_amt" DOUBLE,
  "psps_assigned_services_cnt" DOUBLE,
  "psps_nch_payment_amt" DOUBLE,
  "psps_hcpcs_asc_ind_cd" VARCHAR,
  "psps_error_ind_cd" BIGINT,
  "hcpcs_betos_cd" VARCHAR
);

Physician/Supplier Procedure Summary : 2021-01-01

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2021_01_01

329.61 MB
14,633,043 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2021_01_01 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" BIGINT,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" BIGINT,
  "hcpcs_second_modifier_cd" VARCHAR,
  "psps_submitted_service_cnt" VARCHAR,
  "psps_submitted_charge_amt" VARCHAR,
  "psps_allowed_charge_amt" VARCHAR,
  "psps_denied_services_cnt" VARCHAR,
  "psps_denied_charge_amt" VARCHAR,
  "psps_assigned_services_cnt" VARCHAR,
  "psps_nch_payment_amt" DOUBLE,
  "psps_hcpcs_asc_ind_cd" VARCHAR,
  "psps_error_ind_cd" BIGINT,
  "hcpcs_betos_cd" VARCHAR
);

Physician/Supplier Procedure Summary : 2022-01-01

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2022_01_01

332.66 MB
14,816,637 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2022_01_01 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" DOUBLE,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" DOUBLE,
  "hcpcs_second_modifier_cd" VARCHAR,
  "psps_submitted_service_cnt" VARCHAR,
  "psps_submitted_charge_amt" VARCHAR,
  "psps_allowed_charge_amt" VARCHAR,
  "psps_denied_services_cnt" VARCHAR,
  "psps_denied_charge_amt" VARCHAR,
  "psps_assigned_services_cnt" VARCHAR,
  "psps_nch_payment_amt" DOUBLE,
  "psps_hcpcs_asc_ind_cd" VARCHAR,
  "psps_error_ind_cd" DOUBLE,
  "hcpcs_betos_cd" VARCHAR
);

Physician/Supplier Procedure Summary : 2023-01-01

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2023_01_01

309.08 MB
14,502,413 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2023_01_01 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" BIGINT,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" BIGINT,
  "hcpcs_second_modifier_cd" VARCHAR,
  "psps_submitted_service_cnt" VARCHAR,
  "psps_submitted_charge_amt" VARCHAR,
  "psps_allowed_charge_amt" VARCHAR,
  "psps_denied_services_cnt" VARCHAR,
  "psps_denied_charge_amt" VARCHAR,
  "psps_assigned_services_cnt" VARCHAR,
  "psps_nch_payment_amt" DOUBLE,
  "psps_hcpcs_asc_ind_cd" VARCHAR,
  "psps_error_ind_cd" BIGINT,
  "hcpcs_betos_cd" VARCHAR
);

Physician/Supplier Procedure Summary : 2024-01-01

@usgov.hhs_gov_physician_supplier_procedure_summary_56efd.physician_supplier_procedure_summary_2024_01_01

308.89 MB
14,377,293 rows
18 columns

CREATE TABLE physician_supplier_procedure_summary_2024_01_01 (
  "hcpcs_cd" VARCHAR,
  "hcpcs_initial_modifier_cd" VARCHAR,
  "provider_spec_cd" VARCHAR,
  "carrier_num" BIGINT,
  "pricing_locality_cd" VARCHAR,
  "type_of_service_cd" VARCHAR,
  "place_of_service_cd" BIGINT,
  "hcpcs_second_modifier_cd" VARCHAR,
  "psps_submitted_service_cnt" VARCHAR,
  "psps_submitted_charge_amt" VARCHAR,
  "psps_allowed_charge_amt" VARCHAR,
  "psps_denied_services_cnt" VARCHAR,
  "psps_denied_charge_amt" VARCHAR,
  "psps_assigned_services_cnt" VARCHAR,
  "psps_nch_payment_amt" DOUBLE,
  "psps_hcpcs_asc_ind_cd" VARCHAR,
  "psps_error_ind_cd" BIGINT,
  "hcpcs_betos_cd" VARCHAR
);