Physician/Supplier Procedure Summary by US Government | Finance and Economics

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

Note: This full dataset contains more records than most spreadsheet programs can handle, which will result in an incomplete load of data. Use of a database or statistical software is required.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-02-03T21:40:07.817044
Tags: health-care-use-payments, medicare, original-medicare

Tables

Physician/Supplier Procedure Summary : 2023-01-01

@usgov.hhs_gov_physician_supplier_procedure_summary_76dd2.physician_supplier_procedure_summary_2023_01_01

294.76 MB
14502413 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 : 2022-01-01

@usgov.hhs_gov_physician_supplier_procedure_summary_76dd2.physician_supplier_procedure_summary_2022_01_01

224.84 MB
14816637 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 : 2021-01-01

@usgov.hhs_gov_physician_supplier_procedure_summary_76dd2.physician_supplier_procedure_summary_2021_01_01

314.34 MB
14633043 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 : 2020-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_76dd2.physician_supplier_procedure_summary_2020_12_31

280.27 MB
14876125 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 : 2019-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_76dd2.physician_supplier_procedure_summary_2019_12_31

268.74 MB
14174975 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 : 2018-03-16

@usgov.hhs_gov_physician_supplier_procedure_summary_76dd2.physician_supplier_procedure_summary_2018_03_16

272.28 MB
14422961 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 : 2017-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_76dd2.physician_supplier_procedure_summary_2017_12_31

272.7 MB
14484046 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 : 2016-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_76dd2.physician_supplier_procedure_summary_2016_12_31

262.99 MB
14404770 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 : 2014-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_76dd2.physician_supplier_procedure_summary_2014_12_31

255.59 MB
13552449 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 : 2013-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_76dd2.physician_supplier_procedure_summary_2013_12_31

278.59 MB
14741617 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 : 2012-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_76dd2.physician_supplier_procedure_summary_2012_12_31

271.39 MB
14383393 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 : 2011-11-09

@usgov.hhs_gov_physician_supplier_procedure_summary_76dd2.physician_supplier_procedure_summary_2011_11_09

261.03 MB
13841780 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 : 2010-12-31

@usgov.hhs_gov_physician_supplier_procedure_summary_76dd2.physician_supplier_procedure_summary_2010_12_31

334.02 MB
18040704 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
);