About this Dataset

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider And Service

The Medicare Durable Medical Equipment, Devices & Supplies by Referring Provider and Service dataset contains information on usage, payments and submitted charges organized by National Provider Identifier (NPI), Healthcare Common Procedure Coding System (HCPCS) code, and supplier rental indicator.

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-06-27T13:37:42.356628
Tags: health-care-use-payments, medical-suppliers-equipment, medicare, original-medicare, physicians-practitioners

Tables

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider And Service : 2023-01-01

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_d5737d25.medicare_durable_medical_equipment_devices_supplies_by_52e4d827

75.49 MB
1439587 rows
33 columns


CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_52e4d827 (
  "rfrg_npi" BIGINT,
  "rfrg_prvdr_last_name_org" VARCHAR,
  "rfrg_prvdr_first_name" VARCHAR,
  "rfrg_prvdr_mi" VARCHAR,
  "rfrg_prvdr_crdntls" VARCHAR,
  "rfrg_prvdr_ent_cd" VARCHAR,
  "rfrg_prvdr_st1" VARCHAR,
  "rfrg_prvdr_st2" VARCHAR,
  "rfrg_prvdr_city" VARCHAR,
  "rfrg_prvdr_state_abrvtn" VARCHAR,
  "rfrg_prvdr_state_fips" VARCHAR,
  "rfrg_prvdr_zip5" VARCHAR,
  "rfrg_prvdr_ruca_cat" VARCHAR,
  "rfrg_prvdr_ruca" DOUBLE,
  "rfrg_prvdr_ruca_desc" VARCHAR,
  "rfrg_prvdr_cntry" VARCHAR,
  "rfrg_prvdr_spclty_cd" VARCHAR,
  "rfrg_prvdr_spclty_desc" VARCHAR,
  "rfrg_prvdr_spclty_srce" VARCHAR,
  "rbcs_lvl" VARCHAR,
  "rbcs_id" VARCHAR,
  "rbcs_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "suplr_rentl_ind" VARCHAR,
  "tot_suplrs" BIGINT,
  "tot_suplr_benes" DOUBLE,
  "tot_suplr_clms" BIGINT,
  "tot_suplr_srvcs" BIGINT,
  "avg_suplr_sbmtd_chrg" DOUBLE,
  "avg_suplr_mdcr_alowd_amt" DOUBLE,
  "avg_suplr_mdcr_pymt_amt" DOUBLE,
  "avg_suplr_mdcr_stdzd_amt" DOUBLE
);