Baselight
Sign In

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

U.S. Department of Health & Human Services

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_bc6da7a4

Loading...
Loading...

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.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:22:05.199708
Tags: health-care-use-payments, health-equity, medical-suppliers-equipment, medicare, original-medicare, physicians-practitioners

Tables

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider And Service : 2016-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_bc6da7a4.medicare_durable_medical_equipment_devices_supplies_by_37e37039
  • 96.64 MB
  • 1,735,818 rows
  • 33 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_37e37039 (
  "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" VARCHAR,
  "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" VARCHAR,
  "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
);

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

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_bc6da7a4.medicare_durable_medical_equipment_devices_supplies_by_52e4d827
  • 79.18 MB
  • 1,439,587 rows
  • 33 columns
Loading... 
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
);

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider And Service : 2019-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_bc6da7a4.medicare_durable_medical_equipment_devices_supplies_by_5ed227b1
  • 89.42 MB
  • 1,656,449 rows
  • 33 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_5ed227b1 (
  "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" VARCHAR,
  "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" VARCHAR,
  "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
);

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider And Service : 2020-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_bc6da7a4.medicare_durable_medical_equipment_devices_supplies_by_7033d227
  • 90.13 MB
  • 1,607,435 rows
  • 33 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_7033d227 (
  "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" VARCHAR,
  "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" VARCHAR,
  "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
);

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider And Service : 2021-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_bc6da7a4.medicare_durable_medical_equipment_devices_supplies_by_7421b7d2
  • 85.87 MB
  • 1,516,153 rows
  • 33 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_7421b7d2 (
  "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" BIGINT,
  "rfrg_prvdr_ruca_cat" VARCHAR,
  "rfrg_prvdr_ruca" VARCHAR,
  "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" VARCHAR,
  "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
);

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider And Service : 2017-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_bc6da7a4.medicare_durable_medical_equipment_devices_supplies_by_7ce30a09
  • 88.51 MB
  • 1,644,505 rows
  • 33 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_7ce30a09 (
  "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" VARCHAR,
  "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" VARCHAR,
  "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
);

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider And Service : 2018-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_bc6da7a4.medicare_durable_medical_equipment_devices_supplies_by_8b7ff30a
  • 88.59 MB
  • 1,656,180 rows
  • 33 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_8b7ff30a (
  "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" VARCHAR,
  "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" VARCHAR,
  "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
);

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider And Service : 2022-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_bc6da7a4.medicare_durable_medical_equipment_devices_supplies_by_b85ffdd1
  • 81.8 MB
  • 1,457,378 rows
  • 33 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_b85ffdd1 (
  "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" VARCHAR,
  "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" VARCHAR,
  "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
);

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider And Service : 2015-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_bc6da7a4.medicare_durable_medical_equipment_devices_supplies_by_d61d6ab3
  • 91.28 MB
  • 1,763,952 rows
  • 33 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_d61d6ab3 (
  "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" VARCHAR,
  "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" VARCHAR,
  "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
);

Share link

Anyone who has the link will be able to view this.