Medicare Durable Medical Equipment, Devices & Supplies - By Geography And Service
U.S. Department of Health & Human Services
@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_dd6bb3cd
U.S. Department of Health & Human Services
@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_dd6bb3cd
The Medicare Durable Medical Equipment, Devices & Supplies by Geography and Service dataset contains information on usage, payments, and submitted charges organized by geography, Healthcare Common Procedure Coding System (HCPCS) code, and supplier rental indicator.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:30:37.532846
Tags: health-care-use-payments, health-equity, medicare, national, original-medicare, physicians-practitioners, states-territories
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_08825fde (
"rfrg_prvdr_geo_lvl" VARCHAR,
"rfrg_prvdr_geo_cd" VARCHAR,
"rfrg_prvdr_geo_desc" VARCHAR,
"rbcs_lvl" VARCHAR,
"rbcs_id" VARCHAR,
"rbcs_desc" VARCHAR,
"hcpcs_cd" VARCHAR,
"hcpcs_desc" VARCHAR,
"suplr_rentl_ind" VARCHAR,
"tot_rfrg_prvdrs" BIGINT,
"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
);CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_0dc0e74a (
"rfrg_prvdr_geo_lvl" VARCHAR,
"rfrg_prvdr_geo_cd" VARCHAR,
"rfrg_prvdr_geo_desc" VARCHAR,
"rbcs_lvl" VARCHAR,
"rbcs_id" VARCHAR,
"rbcs_desc" VARCHAR,
"hcpcs_cd" VARCHAR,
"hcpcs_desc" VARCHAR,
"suplr_rentl_ind" VARCHAR,
"tot_rfrg_prvdrs" BIGINT,
"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
);CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_15a76767 (
"rfrg_prvdr_geo_lvl" VARCHAR,
"rfrg_prvdr_geo_cd" VARCHAR,
"rfrg_prvdr_geo_desc" VARCHAR,
"rbcs_lvl" VARCHAR,
"rbcs_id" VARCHAR,
"rbcs_desc" VARCHAR,
"hcpcs_cd" VARCHAR,
"hcpcs_desc" VARCHAR,
"suplr_rentl_ind" VARCHAR,
"tot_rfrg_prvdrs" BIGINT,
"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
);CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_1768a336 (
"rfrg_prvdr_geo_lvl" VARCHAR,
"rfrg_prvdr_geo_cd" VARCHAR,
"rfrg_prvdr_geo_desc" VARCHAR,
"rbcs_lvl" VARCHAR,
"rbcs_id" VARCHAR,
"rbcs_desc" VARCHAR,
"hcpcs_cd" VARCHAR,
"hcpcs_desc" VARCHAR,
"suplr_rentl_ind" VARCHAR,
"tot_rfrg_prvdrs" BIGINT,
"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
);CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_575d3d72 (
"rfrg_prvdr_geo_lvl" VARCHAR,
"rfrg_prvdr_geo_cd" VARCHAR,
"rfrg_prvdr_geo_desc" VARCHAR,
"rbcs_lvl" VARCHAR,
"rbcs_id" VARCHAR,
"rbcs_desc" VARCHAR,
"hcpcs_cd" VARCHAR,
"hcpcs_desc" VARCHAR,
"suplr_rentl_ind" VARCHAR,
"tot_rfrg_prvdrs" BIGINT,
"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
);CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_5c6430c6 (
"rfrg_prvdr_geo_lvl" VARCHAR,
"rfrg_prvdr_geo_cd" VARCHAR,
"rfrg_prvdr_geo_desc" VARCHAR,
"rbcs_lvl" VARCHAR,
"rbcs_id" VARCHAR,
"rbcs_desc" VARCHAR,
"hcpcs_cd" VARCHAR,
"hcpcs_desc" VARCHAR,
"suplr_rentl_ind" VARCHAR,
"tot_rfrg_prvdrs" BIGINT,
"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
);CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_86a194e7 (
"rfrg_prvdr_geo_lvl" VARCHAR,
"rfrg_prvdr_geo_cd" VARCHAR,
"rfrg_prvdr_geo_desc" VARCHAR,
"rbcs_lvl" VARCHAR,
"rbcs_id" VARCHAR,
"rbcs_desc" VARCHAR,
"hcpcs_cd" VARCHAR,
"hcpcs_desc" VARCHAR,
"suplr_rentl_ind" VARCHAR,
"tot_rfrg_prvdrs" BIGINT,
"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
);CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_9a816df5 (
"rfrg_prvdr_geo_lvl" VARCHAR,
"rfrg_prvdr_geo_cd" VARCHAR,
"rfrg_prvdr_geo_desc" VARCHAR,
"rbcs_lvl" VARCHAR,
"rbcs_id" VARCHAR,
"rbcs_desc" VARCHAR,
"hcpcs_cd" VARCHAR,
"hcpcs_desc" VARCHAR,
"suplr_rentl_ind" VARCHAR,
"tot_rfrg_prvdrs" BIGINT,
"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
);CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_dad61488 (
"rfrg_prvdr_geo_lvl" VARCHAR,
"rfrg_prvdr_geo_cd" VARCHAR,
"rfrg_prvdr_geo_desc" VARCHAR,
"rbcs_lvl" VARCHAR,
"rbcs_id" VARCHAR,
"rbcs_desc" VARCHAR,
"hcpcs_cd" VARCHAR,
"hcpcs_desc" VARCHAR,
"suplr_rentl_ind" VARCHAR,
"tot_rfrg_prvdrs" BIGINT,
"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
);CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_ef5895f4 (
"rfrg_prvdr_geo_lvl" VARCHAR,
"rfrg_prvdr_geo_cd" VARCHAR,
"rfrg_prvdr_geo_desc" VARCHAR,
"rbcs_lvl" VARCHAR,
"rbcs_id" VARCHAR,
"rbcs_desc" VARCHAR,
"hcpcs_cd" VARCHAR,
"hcpcs_desc" VARCHAR,
"suplr_rentl_ind" VARCHAR,
"tot_rfrg_prvdrs" BIGINT,
"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
);Anyone who has the link will be able to view this.