About this Dataset

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

The Medicare Durable Medical Equipment, Devices & Supplies by Referring Provider dataset contains information on usage, payments, submitted charges and beneficiary demographic and health characteristics organized by National Provider Identifier (NPI).
Organization: U.S. Department of Health & Human Services
Last updated: 2025-06-27T13:38:15.217097
Tags: health-care-use-payments, medical-suppliers-equipment, medicare, original-medicare, physicians-practitioners

Tables

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

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_b67ce02a.medicare_durable_medical_equipment_devices_supplies_by_880c5ec6

56.41 MB
387352 rows
97 columns


CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_880c5ec6 (
  "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" DOUBLE,
  "rfrg_prvdr_ruca_desc" VARCHAR,
  "rfrg_prvdr_cntry" VARCHAR,
  "rfrg_prvdr_spclty_desc" VARCHAR,
  "rfrg_prvdr_spclty_srce" VARCHAR,
  "tot_suplrs" BIGINT,
  "tot_suplr_hcpcs_cds" BIGINT,
  "tot_suplr_benes" DOUBLE,
  "tot_suplr_clms" BIGINT,
  "tot_suplr_srvcs" BIGINT,
  "suplr_sbmtd_chrgs" DOUBLE,
  "suplr_mdcr_alowd_amt" DOUBLE,
  "suplr_mdcr_pymt_amt" DOUBLE,
  "suplr_mdcr_stdzd_pymt_amt" DOUBLE,
  "dme_sprsn_ind" VARCHAR,
  "dme_tot_suplrs" DOUBLE,
  "dme_tot_suplr_hcpcs_cds" DOUBLE,
  "dme_tot_suplr_benes" DOUBLE,
  "dme_tot_suplr_clms" DOUBLE,
  "dme_tot_suplr_srvcs" DOUBLE,
  "dme_suplr_sbmtd_chrgs" DOUBLE,
  "dme_suplr_mdcr_alowd_amt" DOUBLE,
  "dme_suplr_mdcr_pymt_amt" DOUBLE,
  "dme_suplr_mdcr_stdzd_pymt_amt" DOUBLE,
  "pos_sprsn_ind" VARCHAR,
  "pos_tot_suplrs" DOUBLE,
  "pos_tot_suplr_hcpcs_cds" DOUBLE,
  "pos_tot_suplr_benes" DOUBLE,
  "pos_tot_suplr_clms" DOUBLE,
  "pos_tot_suplr_srvcs" DOUBLE,
  "pos_suplr_sbmtd_chrgs" DOUBLE,
  "pos_suplr_mdcr_alowd_amt" DOUBLE,
  "pos_suplr_mdcr_pymt_amt" DOUBLE,
  "pos_suplr_mdcr_stdzd_pymt_amt" DOUBLE,
  "drug_sprsn_ind" VARCHAR,
  "drug_tot_suplrs" DOUBLE,
  "drug_tot_suplr_hcpcs_cds" DOUBLE,
  "drug_tot_suplr_benes" DOUBLE,
  "drug_tot_suplr_clms" DOUBLE,
  "drug_tot_suplr_srvcs" DOUBLE,
  "drug_suplr_sbmtd_chrgs" DOUBLE,
  "drug_suplr_mdcr_alowd_amt" DOUBLE,
  "drug_suplr_mdcr_pymt_amt" DOUBLE,
  "drug_suplr_mdcr_stdzd_pymt_amt" DOUBLE,
  "bene_avg_age" DOUBLE,
  "bene_age_lt_65_cnt" DOUBLE,
  "bene_age_65_74_cnt" DOUBLE,
  "bene_age_75_84_cnt" DOUBLE,
  "bene_age_gt_84_cnt" DOUBLE,
  "bene_feml_cnt" DOUBLE,
  "bene_male_cnt" DOUBLE,
  "bene_race_wht_cnt" DOUBLE,
  "bene_race_black_cnt" DOUBLE,
  "bene_race_api_cnt" DOUBLE,
  "bene_race_hspnc_cnt" DOUBLE,
  "bene_race_natind_cnt" DOUBLE,
  "bene_race_othr_cnt" DOUBLE,
  "bene_ndual_cnt" DOUBLE,
  "bene_dual_cnt" DOUBLE,
  "bene_cc_bh_adhd_othcd_v1_pct" DOUBLE,
  "bene_cc_bh_alcohol_drug_v1_pct" DOUBLE,
  "bene_cc_bh_tobacco_v1_pct" DOUBLE,
  "bene_cc_bh_alz_nonalzdem_v2_pct" DOUBLE,
  "bene_cc_bh_anxiety_v1_pct" DOUBLE,
  "bene_cc_bh_bipolar_v1_pct" DOUBLE,
  "bene_cc_bh_mood_v2_pct" DOUBLE,
  "bene_cc_bh_depress_v1_pct" DOUBLE,
  "bene_cc_bh_pd_v1_pct" DOUBLE,
  "bene_cc_bh_ptsd_v1_pct" DOUBLE,
  "bene_cc_bh_schizo_othpsy_v1_pct" DOUBLE,
  "bene_cc_ph_asthma_v2_pct" DOUBLE,
  "bene_cc_ph_afib_v2_pct" DOUBLE,
  "bene_cc_ph_cancer6_v2_pct" DOUBLE,
  "bene_cc_ph_ckd_v2_pct" DOUBLE,
  "bene_cc_ph_copd_v2_pct" DOUBLE,
  "bene_cc_ph_diabetes_v2_pct" DOUBLE,
  "bene_cc_ph_hf_nonihd_v2_pct" DOUBLE,
  "bene_cc_ph_hyperlipidemia_v2_pct" DOUBLE,
  "bene_cc_ph_hypertension_v2_pct" DOUBLE,
  "bene_cc_ph_ischemicheart_v2_pct" DOUBLE,
  "bene_cc_ph_osteoporosis_v2_pct" DOUBLE,
  "bene_cc_ph_parkinson_v2_pct" DOUBLE,
  "bene_cc_ph_arthritis_v2_pct" DOUBLE,
  "bene_cc_ph_stroke_tia_v2_pct" DOUBLE,
  "bene_avg_risk_scre" DOUBLE
);