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-11-11T15:40:38.713125
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 : 2017-03-27

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_1bf053b8.medicare_durable_medical_equipment_devices_supplies_by_14b55103

64.45 MB
381,443 rows
97 columns

CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_14b55103 (
  "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
);

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider : 2021-03-27

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_1bf053b8.medicare_durable_medical_equipment_devices_supplies_by_15f2f508

62.58 MB
384,264 rows
97 columns

CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_15f2f508 (
  "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
);

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider : 2018-03-27

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_1bf053b8.medicare_durable_medical_equipment_devices_supplies_by_4149c025

65.24 MB
386,039 rows
97 columns

CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_4149c025 (
  "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
);

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider : 2019-03-27

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_1bf053b8.medicare_durable_medical_equipment_devices_supplies_by_67f6ba7f

65.46 MB
389,310 rows
97 columns

CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_67f6ba7f (
  "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
);

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider : 2022-03-27

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_1bf053b8.medicare_durable_medical_equipment_devices_supplies_by_825b76de

62.02 MB
385,637 rows
97 columns

CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_825b76de (
  "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
);

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider : 2020-03-27

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_1bf053b8.medicare_durable_medical_equipment_devices_supplies_by_eb3a8e05

63.49 MB
383,488 rows
97 columns

CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_eb3a8e05 (
  "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
);

Medicare Durable Medical Equipment, Devices & Supplies - By Referring Provider : 2016-03-27

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_1bf053b8.medicare_durable_medical_equipment_devices_supplies_by_edb8d3a1

57.03 MB
376,884 rows
72 columns

CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_edb8d3a1 (
  "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_avg_risk_scre" DOUBLE
);