Baselight
Sign In

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

U.S. Department of Health & Human Services

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e448670f

Loading...
Loading...

About this Dataset

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

The Medicare Durable Medical Equipment, Devices & Supplies by Supplier and Service dataset contains information on usage, payments and submitted charges organized by supplier 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:28:54.125311
Tags: health-care-use-payments, health-equity, medical-suppliers-equipment, medicare, original-medicare, physicians-practitioners

Tables

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

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e448670f.medicare_durable_medical_equipment_devices_supplies_by_0830ce1a
  • 28.43 MB
  • 577,865 rows
  • 32 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_0830ce1a (
  "suplr_npi" BIGINT,
  "suplr_prvdr_last_name_org" VARCHAR,
  "suplr_prvdr_first_name" VARCHAR,
  "suplr_prvdr_mi" VARCHAR,
  "suplr_prvdr_crdntls" VARCHAR,
  "suplr_prvdr_ent_cd" VARCHAR,
  "suplr_prvdr_st1" VARCHAR,
  "suplr_prvdr_st2" VARCHAR,
  "suplr_prvdr_city" VARCHAR,
  "suplr_prvdr_state_abrvtn" VARCHAR,
  "suplr_prvdr_state_fips" BIGINT,
  "suplr_prvdr_zip5" BIGINT,
  "suplr_prvdr_ruca_cat" VARCHAR,
  "suplr_prvdr_ruca" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_cd" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "rbcs_lvl" VARCHAR,
  "rbcs_id" VARCHAR,
  "rbcs_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "suplr_rentl_ind" VARCHAR,
  "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 Supplier And Service : 2019-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e448670f.medicare_durable_medical_equipment_devices_supplies_by_1ddb24b9
  • 28.15 MB
  • 575,223 rows
  • 32 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_1ddb24b9 (
  "suplr_npi" BIGINT,
  "suplr_prvdr_last_name_org" VARCHAR,
  "suplr_prvdr_first_name" VARCHAR,
  "suplr_prvdr_mi" VARCHAR,
  "suplr_prvdr_crdntls" VARCHAR,
  "suplr_prvdr_ent_cd" VARCHAR,
  "suplr_prvdr_st1" VARCHAR,
  "suplr_prvdr_st2" VARCHAR,
  "suplr_prvdr_city" VARCHAR,
  "suplr_prvdr_state_abrvtn" VARCHAR,
  "suplr_prvdr_state_fips" VARCHAR,
  "suplr_prvdr_zip5" BIGINT,
  "suplr_prvdr_ruca_cat" VARCHAR,
  "suplr_prvdr_ruca" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_cd" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "rbcs_lvl" VARCHAR,
  "rbcs_id" VARCHAR,
  "rbcs_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "suplr_rentl_ind" VARCHAR,
  "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 Supplier And Service : 2017-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e448670f.medicare_durable_medical_equipment_devices_supplies_by_1e01b871
  • 29.02 MB
  • 587,993 rows
  • 32 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_1e01b871 (
  "suplr_npi" BIGINT,
  "suplr_prvdr_last_name_org" VARCHAR,
  "suplr_prvdr_first_name" VARCHAR,
  "suplr_prvdr_mi" VARCHAR,
  "suplr_prvdr_crdntls" VARCHAR,
  "suplr_prvdr_ent_cd" VARCHAR,
  "suplr_prvdr_st1" VARCHAR,
  "suplr_prvdr_st2" VARCHAR,
  "suplr_prvdr_city" VARCHAR,
  "suplr_prvdr_state_abrvtn" VARCHAR,
  "suplr_prvdr_state_fips" BIGINT,
  "suplr_prvdr_zip5" BIGINT,
  "suplr_prvdr_ruca_cat" VARCHAR,
  "suplr_prvdr_ruca" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_cd" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "rbcs_lvl" VARCHAR,
  "rbcs_id" VARCHAR,
  "rbcs_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "suplr_rentl_ind" VARCHAR,
  "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 Supplier And Service : 2014-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e448670f.medicare_durable_medical_equipment_devices_supplies_by_32f3ac72
  • 29.89 MB
  • 613,872 rows
  • 32 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_32f3ac72 (
  "suplr_npi" BIGINT,
  "suplr_prvdr_last_name_org" VARCHAR,
  "suplr_prvdr_first_name" VARCHAR,
  "suplr_prvdr_mi" VARCHAR,
  "suplr_prvdr_crdntls" VARCHAR,
  "suplr_prvdr_ent_cd" VARCHAR,
  "suplr_prvdr_st1" VARCHAR,
  "suplr_prvdr_st2" VARCHAR,
  "suplr_prvdr_city" VARCHAR,
  "suplr_prvdr_state_abrvtn" VARCHAR,
  "suplr_prvdr_state_fips" BIGINT,
  "suplr_prvdr_zip5" BIGINT,
  "suplr_prvdr_ruca_cat" VARCHAR,
  "suplr_prvdr_ruca" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_cd" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "rbcs_lvl" VARCHAR,
  "rbcs_id" VARCHAR,
  "rbcs_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "suplr_rentl_ind" VARCHAR,
  "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 Supplier And Service : 2023-01-01

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e448670f.medicare_durable_medical_equipment_devices_supplies_by_54cdd3f8
  • 22.68 MB
  • 463,784 rows
  • 32 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_54cdd3f8 (
  "suplr_npi" BIGINT,
  "suplr_prvdr_last_name_org" VARCHAR,
  "suplr_prvdr_first_name" VARCHAR,
  "suplr_prvdr_mi" VARCHAR,
  "suplr_prvdr_crdntls" VARCHAR,
  "suplr_prvdr_ent_cd" VARCHAR,
  "suplr_prvdr_st1" VARCHAR,
  "suplr_prvdr_st2" VARCHAR,
  "suplr_prvdr_city" VARCHAR,
  "suplr_prvdr_state_abrvtn" VARCHAR,
  "suplr_prvdr_state_fips" BIGINT,
  "suplr_prvdr_zip5" BIGINT,
  "suplr_prvdr_ruca_cat" VARCHAR,
  "suplr_prvdr_ruca" DOUBLE,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_cd" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "rbcs_lvl" VARCHAR,
  "rbcs_id" VARCHAR,
  "rbcs_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "suplr_rentl_ind" VARCHAR,
  "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 Supplier And Service : 2022-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e448670f.medicare_durable_medical_equipment_devices_supplies_by_61057a45
  • 24.21 MB
  • 482,638 rows
  • 32 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_61057a45 (
  "suplr_npi" BIGINT,
  "suplr_prvdr_last_name_org" VARCHAR,
  "suplr_prvdr_first_name" VARCHAR,
  "suplr_prvdr_mi" VARCHAR,
  "suplr_prvdr_crdntls" VARCHAR,
  "suplr_prvdr_ent_cd" VARCHAR,
  "suplr_prvdr_st1" VARCHAR,
  "suplr_prvdr_st2" VARCHAR,
  "suplr_prvdr_city" VARCHAR,
  "suplr_prvdr_state_abrvtn" VARCHAR,
  "suplr_prvdr_state_fips" BIGINT,
  "suplr_prvdr_zip5" BIGINT,
  "suplr_prvdr_ruca_cat" VARCHAR,
  "suplr_prvdr_ruca" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_cd" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "rbcs_lvl" VARCHAR,
  "rbcs_id" VARCHAR,
  "rbcs_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "suplr_rentl_ind" VARCHAR,
  "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 Supplier And Service : 2015-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e448670f.medicare_durable_medical_equipment_devices_supplies_by_624a64b2
  • 29.1 MB
  • 595,546 rows
  • 32 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_624a64b2 (
  "suplr_npi" BIGINT,
  "suplr_prvdr_last_name_org" VARCHAR,
  "suplr_prvdr_first_name" VARCHAR,
  "suplr_prvdr_mi" VARCHAR,
  "suplr_prvdr_crdntls" VARCHAR,
  "suplr_prvdr_ent_cd" VARCHAR,
  "suplr_prvdr_st1" VARCHAR,
  "suplr_prvdr_st2" VARCHAR,
  "suplr_prvdr_city" VARCHAR,
  "suplr_prvdr_state_abrvtn" VARCHAR,
  "suplr_prvdr_state_fips" BIGINT,
  "suplr_prvdr_zip5" BIGINT,
  "suplr_prvdr_ruca_cat" VARCHAR,
  "suplr_prvdr_ruca" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_cd" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "rbcs_lvl" VARCHAR,
  "rbcs_id" VARCHAR,
  "rbcs_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "suplr_rentl_ind" VARCHAR,
  "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 Supplier And Service : 2016-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e448670f.medicare_durable_medical_equipment_devices_supplies_by_6dcccfa4
  • 30.12 MB
  • 594,991 rows
  • 32 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_6dcccfa4 (
  "suplr_npi" BIGINT,
  "suplr_prvdr_last_name_org" VARCHAR,
  "suplr_prvdr_first_name" VARCHAR,
  "suplr_prvdr_mi" VARCHAR,
  "suplr_prvdr_crdntls" VARCHAR,
  "suplr_prvdr_ent_cd" VARCHAR,
  "suplr_prvdr_st1" VARCHAR,
  "suplr_prvdr_st2" VARCHAR,
  "suplr_prvdr_city" VARCHAR,
  "suplr_prvdr_state_abrvtn" VARCHAR,
  "suplr_prvdr_state_fips" BIGINT,
  "suplr_prvdr_zip5" BIGINT,
  "suplr_prvdr_ruca_cat" VARCHAR,
  "suplr_prvdr_ruca" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_cd" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "rbcs_lvl" VARCHAR,
  "rbcs_id" VARCHAR,
  "rbcs_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "suplr_rentl_ind" VARCHAR,
  "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 Supplier And Service : 2021-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e448670f.medicare_durable_medical_equipment_devices_supplies_by_ac29a436
  • 25.17 MB
  • 508,052 rows
  • 32 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_ac29a436 (
  "suplr_npi" BIGINT,
  "suplr_prvdr_last_name_org" VARCHAR,
  "suplr_prvdr_first_name" VARCHAR,
  "suplr_prvdr_mi" VARCHAR,
  "suplr_prvdr_crdntls" VARCHAR,
  "suplr_prvdr_ent_cd" VARCHAR,
  "suplr_prvdr_st1" VARCHAR,
  "suplr_prvdr_st2" VARCHAR,
  "suplr_prvdr_city" VARCHAR,
  "suplr_prvdr_state_abrvtn" VARCHAR,
  "suplr_prvdr_state_fips" BIGINT,
  "suplr_prvdr_zip5" BIGINT,
  "suplr_prvdr_ruca_cat" VARCHAR,
  "suplr_prvdr_ruca" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_cd" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "rbcs_lvl" VARCHAR,
  "rbcs_id" VARCHAR,
  "rbcs_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "suplr_rentl_ind" VARCHAR,
  "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 Supplier And Service : 2020-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e448670f.medicare_durable_medical_equipment_devices_supplies_by_d59c2c35
  • 27.02 MB
  • 542,090 rows
  • 32 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_d59c2c35 (
  "suplr_npi" BIGINT,
  "suplr_prvdr_last_name_org" VARCHAR,
  "suplr_prvdr_first_name" VARCHAR,
  "suplr_prvdr_mi" VARCHAR,
  "suplr_prvdr_crdntls" VARCHAR,
  "suplr_prvdr_ent_cd" VARCHAR,
  "suplr_prvdr_st1" VARCHAR,
  "suplr_prvdr_st2" VARCHAR,
  "suplr_prvdr_city" VARCHAR,
  "suplr_prvdr_state_abrvtn" VARCHAR,
  "suplr_prvdr_state_fips" BIGINT,
  "suplr_prvdr_zip5" BIGINT,
  "suplr_prvdr_ruca_cat" VARCHAR,
  "suplr_prvdr_ruca" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_cd" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "rbcs_lvl" VARCHAR,
  "rbcs_id" VARCHAR,
  "rbcs_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "suplr_rentl_ind" VARCHAR,
  "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.