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_d5737d25

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. 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-03-27T20:25:01.430569
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 : 2022-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_d5737d25.medicare_durable_medical_equipment_devices_supplies_by_b85ffdd1
  • 78.01 MB
  • 1457378 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 : 2021-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_d5737d25.medicare_durable_medical_equipment_devices_supplies_by_7421b7d2
  • 81.89 MB
  • 1516153 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 : 2020-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_d5737d25.medicare_durable_medical_equipment_devices_supplies_by_7033d227
  • 85.96 MB
  • 1607435 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 : 2019-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_d5737d25.medicare_durable_medical_equipment_devices_supplies_by_5ed227b1
  • 85.28 MB
  • 1656449 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 : 2018-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_d5737d25.medicare_durable_medical_equipment_devices_supplies_by_8b7ff30a
  • 84.48 MB
  • 1656180 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 : 2017-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_d5737d25.medicare_durable_medical_equipment_devices_supplies_by_7ce30a09
  • 84.41 MB
  • 1644505 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 : 2016-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_d5737d25.medicare_durable_medical_equipment_devices_supplies_by_37e37039
  • 92.16 MB
  • 1735818 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 : 2015-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_d5737d25.medicare_durable_medical_equipment_devices_supplies_by_d61d6ab3
  • 87.05 MB
  • 1763952 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
);

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

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_d5737d25.medicare_durable_medical_equipment_devices_supplies_by_85e1f20d
  • 87.67 MB
  • 1790489 rows
  • 33 columns
Loading... 

CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_85e1f20d (
  "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.