Baselight
Sign In

Medicare Durable Medical Equipment, Devices & Supplies - By Supplier

U.S. Department of Health & Human Services

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e51dbace

Loading...
Loading...

About this Dataset

Medicare Durable Medical Equipment, Devices & Supplies - By Supplier

The Medicare Durable Medical Equipment, Devices & Supplies by Supplier dataset contains information on usage, payments, submitted charges and beneficiary demographic and health characteristics organized by supplier National Provider Identifier (NPI).
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:20:32.415425
Tags: health-care-use-payments, health-equity, medical-suppliers-equipment, medicare, original-medicare, physicians-practitioners

Tables

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

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e51dbace.medicare_durable_medical_equipment_devices_supplies_by_337b79e6
  • 13.39 MB
  • 63,988 rows
  • 93 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_337b79e6 (
  "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" DOUBLE,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "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_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_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_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 Supplier : 2020-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e51dbace.medicare_durable_medical_equipment_devices_supplies_by_46c2ed8c
  • 17.94 MB
  • 69,398 rows
  • 93 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_46c2ed8c (
  "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" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "tot_suplr_hcpcs_cds" BIGINT,
  "tot_suplr_benes" VARCHAR,
  "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_suplr_hcpcs_cds" VARCHAR,
  "dme_tot_suplr_benes" VARCHAR,
  "dme_tot_suplr_clms" VARCHAR,
  "dme_tot_suplr_srvcs" VARCHAR,
  "dme_suplr_sbmtd_chrgs" VARCHAR,
  "dme_suplr_mdcr_alowd_amt" VARCHAR,
  "dme_suplr_mdcr_pymt_amt" VARCHAR,
  "dme_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "pos_sprsn_ind" VARCHAR,
  "pos_tot_suplr_hcpcs_cds" VARCHAR,
  "pos_tot_suplr_benes" VARCHAR,
  "pos_tot_suplr_clms" VARCHAR,
  "pos_tot_suplr_srvcs" VARCHAR,
  "pos_suplr_sbmtd_chrgs" VARCHAR,
  "pos_suplr_mdcr_alowd_amt" VARCHAR,
  "pos_suplr_mdcr_pymt_amt" VARCHAR,
  "pos_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "drug_sprsn_ind" VARCHAR,
  "drug_tot_suplr_hcpcs_cds" VARCHAR,
  "drug_tot_suplr_benes" VARCHAR,
  "drug_tot_suplr_clms" VARCHAR,
  "drug_tot_suplr_srvcs" VARCHAR,
  "drug_suplr_sbmtd_chrgs" VARCHAR,
  "drug_suplr_mdcr_alowd_amt" VARCHAR,
  "drug_suplr_mdcr_pymt_amt" VARCHAR,
  "drug_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "bene_avg_age" VARCHAR,
  "bene_age_lt_65_cnt" VARCHAR,
  "bene_age_65_74_cnt" VARCHAR,
  "bene_age_75_84_cnt" VARCHAR,
  "bene_age_gt_84_cnt" VARCHAR,
  "bene_feml_cnt" VARCHAR,
  "bene_male_cnt" VARCHAR,
  "bene_race_wht_cnt" VARCHAR,
  "bene_race_black_cnt" VARCHAR,
  "bene_race_api_cnt" VARCHAR,
  "bene_race_hspnc_cnt" VARCHAR,
  "bene_race_natind_cnt" VARCHAR,
  "bene_race_othr_cnt" VARCHAR,
  "bene_ndual_cnt" VARCHAR,
  "bene_dual_cnt" VARCHAR,
  "bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
  "bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
  "bene_cc_bh_tobacco_v1_pct" VARCHAR,
  "bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
  "bene_cc_bh_anxiety_v1_pct" VARCHAR,
  "bene_cc_bh_bipolar_v1_pct" VARCHAR,
  "bene_cc_bh_mood_v2_pct" VARCHAR,
  "bene_cc_bh_depress_v1_pct" VARCHAR,
  "bene_cc_bh_pd_v1_pct" VARCHAR,
  "bene_cc_bh_ptsd_v1_pct" VARCHAR,
  "bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
  "bene_cc_ph_asthma_v2_pct" VARCHAR,
  "bene_cc_ph_afib_v2_pct" VARCHAR,
  "bene_cc_ph_cancer6_v2_pct" VARCHAR,
  "bene_cc_ph_ckd_v2_pct" VARCHAR,
  "bene_cc_ph_copd_v2_pct" VARCHAR,
  "bene_cc_ph_diabetes_v2_pct" VARCHAR,
  "bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
  "bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
  "bene_cc_ph_hypertension_v2_pct" VARCHAR,
  "bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
  "bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
  "bene_cc_ph_parkinson_v2_pct" VARCHAR,
  "bene_cc_ph_arthritis_v2_pct" VARCHAR,
  "bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
  "bene_avg_risk_scre" VARCHAR
);

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

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e51dbace.medicare_durable_medical_equipment_devices_supplies_by_4b5275be
  • 19.68 MB
  • 75,805 rows
  • 93 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_4b5275be (
  "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" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "tot_suplr_hcpcs_cds" BIGINT,
  "tot_suplr_benes" VARCHAR,
  "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_suplr_hcpcs_cds" VARCHAR,
  "dme_tot_suplr_benes" VARCHAR,
  "dme_tot_suplr_clms" VARCHAR,
  "dme_tot_suplr_srvcs" VARCHAR,
  "dme_suplr_sbmtd_chrgs" VARCHAR,
  "dme_suplr_mdcr_alowd_amt" VARCHAR,
  "dme_suplr_mdcr_pymt_amt" VARCHAR,
  "dme_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "pos_sprsn_ind" VARCHAR,
  "pos_tot_suplr_hcpcs_cds" VARCHAR,
  "pos_tot_suplr_benes" VARCHAR,
  "pos_tot_suplr_clms" VARCHAR,
  "pos_tot_suplr_srvcs" VARCHAR,
  "pos_suplr_sbmtd_chrgs" VARCHAR,
  "pos_suplr_mdcr_alowd_amt" VARCHAR,
  "pos_suplr_mdcr_pymt_amt" VARCHAR,
  "pos_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "drug_sprsn_ind" VARCHAR,
  "drug_tot_suplr_hcpcs_cds" VARCHAR,
  "drug_tot_suplr_benes" VARCHAR,
  "drug_tot_suplr_clms" VARCHAR,
  "drug_tot_suplr_srvcs" VARCHAR,
  "drug_suplr_sbmtd_chrgs" VARCHAR,
  "drug_suplr_mdcr_alowd_amt" VARCHAR,
  "drug_suplr_mdcr_pymt_amt" VARCHAR,
  "drug_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "bene_avg_age" VARCHAR,
  "bene_age_lt_65_cnt" VARCHAR,
  "bene_age_65_74_cnt" VARCHAR,
  "bene_age_75_84_cnt" VARCHAR,
  "bene_age_gt_84_cnt" VARCHAR,
  "bene_feml_cnt" VARCHAR,
  "bene_male_cnt" VARCHAR,
  "bene_race_wht_cnt" VARCHAR,
  "bene_race_black_cnt" VARCHAR,
  "bene_race_api_cnt" VARCHAR,
  "bene_race_hspnc_cnt" VARCHAR,
  "bene_race_natind_cnt" VARCHAR,
  "bene_race_othr_cnt" VARCHAR,
  "bene_ndual_cnt" VARCHAR,
  "bene_dual_cnt" VARCHAR,
  "bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
  "bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
  "bene_cc_bh_tobacco_v1_pct" VARCHAR,
  "bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
  "bene_cc_bh_anxiety_v1_pct" VARCHAR,
  "bene_cc_bh_bipolar_v1_pct" VARCHAR,
  "bene_cc_bh_mood_v2_pct" VARCHAR,
  "bene_cc_bh_depress_v1_pct" VARCHAR,
  "bene_cc_bh_pd_v1_pct" VARCHAR,
  "bene_cc_bh_ptsd_v1_pct" VARCHAR,
  "bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
  "bene_cc_ph_asthma_v2_pct" VARCHAR,
  "bene_cc_ph_afib_v2_pct" VARCHAR,
  "bene_cc_ph_cancer6_v2_pct" VARCHAR,
  "bene_cc_ph_ckd_v2_pct" VARCHAR,
  "bene_cc_ph_copd_v2_pct" VARCHAR,
  "bene_cc_ph_diabetes_v2_pct" VARCHAR,
  "bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
  "bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
  "bene_cc_ph_hypertension_v2_pct" VARCHAR,
  "bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
  "bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
  "bene_cc_ph_parkinson_v2_pct" VARCHAR,
  "bene_cc_ph_arthritis_v2_pct" VARCHAR,
  "bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
  "bene_avg_risk_scre" VARCHAR
);

Medicare Durable Medical Equipment, Devices & Supplies - By Supplier : 2022-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e51dbace.medicare_durable_medical_equipment_devices_supplies_by_4c7fbf63
  • 16.53 MB
  • 66,406 rows
  • 93 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_4c7fbf63 (
  "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" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "tot_suplr_hcpcs_cds" BIGINT,
  "tot_suplr_benes" VARCHAR,
  "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_suplr_hcpcs_cds" VARCHAR,
  "dme_tot_suplr_benes" VARCHAR,
  "dme_tot_suplr_clms" VARCHAR,
  "dme_tot_suplr_srvcs" VARCHAR,
  "dme_suplr_sbmtd_chrgs" VARCHAR,
  "dme_suplr_mdcr_alowd_amt" VARCHAR,
  "dme_suplr_mdcr_pymt_amt" VARCHAR,
  "dme_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "pos_sprsn_ind" VARCHAR,
  "pos_tot_suplr_hcpcs_cds" VARCHAR,
  "pos_tot_suplr_benes" VARCHAR,
  "pos_tot_suplr_clms" VARCHAR,
  "pos_tot_suplr_srvcs" VARCHAR,
  "pos_suplr_sbmtd_chrgs" VARCHAR,
  "pos_suplr_mdcr_alowd_amt" VARCHAR,
  "pos_suplr_mdcr_pymt_amt" VARCHAR,
  "pos_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "drug_sprsn_ind" VARCHAR,
  "drug_tot_suplr_hcpcs_cds" VARCHAR,
  "drug_tot_suplr_benes" VARCHAR,
  "drug_tot_suplr_clms" VARCHAR,
  "drug_tot_suplr_srvcs" VARCHAR,
  "drug_suplr_sbmtd_chrgs" VARCHAR,
  "drug_suplr_mdcr_alowd_amt" VARCHAR,
  "drug_suplr_mdcr_pymt_amt" VARCHAR,
  "drug_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "bene_avg_age" VARCHAR,
  "bene_age_lt_65_cnt" VARCHAR,
  "bene_age_65_74_cnt" VARCHAR,
  "bene_age_75_84_cnt" VARCHAR,
  "bene_age_gt_84_cnt" VARCHAR,
  "bene_feml_cnt" VARCHAR,
  "bene_male_cnt" VARCHAR,
  "bene_race_wht_cnt" VARCHAR,
  "bene_race_black_cnt" VARCHAR,
  "bene_race_api_cnt" VARCHAR,
  "bene_race_hspnc_cnt" VARCHAR,
  "bene_race_natind_cnt" VARCHAR,
  "bene_race_othr_cnt" VARCHAR,
  "bene_ndual_cnt" VARCHAR,
  "bene_dual_cnt" VARCHAR,
  "bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
  "bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
  "bene_cc_bh_tobacco_v1_pct" VARCHAR,
  "bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
  "bene_cc_bh_anxiety_v1_pct" VARCHAR,
  "bene_cc_bh_bipolar_v1_pct" VARCHAR,
  "bene_cc_bh_mood_v2_pct" VARCHAR,
  "bene_cc_bh_depress_v1_pct" VARCHAR,
  "bene_cc_bh_pd_v1_pct" VARCHAR,
  "bene_cc_bh_ptsd_v1_pct" VARCHAR,
  "bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
  "bene_cc_ph_asthma_v2_pct" VARCHAR,
  "bene_cc_ph_afib_v2_pct" VARCHAR,
  "bene_cc_ph_cancer6_v2_pct" VARCHAR,
  "bene_cc_ph_ckd_v2_pct" VARCHAR,
  "bene_cc_ph_copd_v2_pct" VARCHAR,
  "bene_cc_ph_diabetes_v2_pct" VARCHAR,
  "bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
  "bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
  "bene_cc_ph_hypertension_v2_pct" VARCHAR,
  "bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
  "bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
  "bene_cc_ph_parkinson_v2_pct" VARCHAR,
  "bene_cc_ph_arthritis_v2_pct" VARCHAR,
  "bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
  "bene_avg_risk_scre" VARCHAR
);

Medicare Durable Medical Equipment, Devices & Supplies - By Supplier : 2021-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e51dbace.medicare_durable_medical_equipment_devices_supplies_by_730c73ac
  • 17.31 MB
  • 68,227 rows
  • 93 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_730c73ac (
  "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" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "tot_suplr_hcpcs_cds" BIGINT,
  "tot_suplr_benes" VARCHAR,
  "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_suplr_hcpcs_cds" VARCHAR,
  "dme_tot_suplr_benes" VARCHAR,
  "dme_tot_suplr_clms" VARCHAR,
  "dme_tot_suplr_srvcs" VARCHAR,
  "dme_suplr_sbmtd_chrgs" VARCHAR,
  "dme_suplr_mdcr_alowd_amt" VARCHAR,
  "dme_suplr_mdcr_pymt_amt" VARCHAR,
  "dme_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "pos_sprsn_ind" VARCHAR,
  "pos_tot_suplr_hcpcs_cds" VARCHAR,
  "pos_tot_suplr_benes" VARCHAR,
  "pos_tot_suplr_clms" VARCHAR,
  "pos_tot_suplr_srvcs" VARCHAR,
  "pos_suplr_sbmtd_chrgs" VARCHAR,
  "pos_suplr_mdcr_alowd_amt" VARCHAR,
  "pos_suplr_mdcr_pymt_amt" VARCHAR,
  "pos_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "drug_sprsn_ind" VARCHAR,
  "drug_tot_suplr_hcpcs_cds" VARCHAR,
  "drug_tot_suplr_benes" VARCHAR,
  "drug_tot_suplr_clms" VARCHAR,
  "drug_tot_suplr_srvcs" VARCHAR,
  "drug_suplr_sbmtd_chrgs" VARCHAR,
  "drug_suplr_mdcr_alowd_amt" VARCHAR,
  "drug_suplr_mdcr_pymt_amt" VARCHAR,
  "drug_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "bene_avg_age" VARCHAR,
  "bene_age_lt_65_cnt" VARCHAR,
  "bene_age_65_74_cnt" VARCHAR,
  "bene_age_75_84_cnt" VARCHAR,
  "bene_age_gt_84_cnt" VARCHAR,
  "bene_feml_cnt" VARCHAR,
  "bene_male_cnt" VARCHAR,
  "bene_race_wht_cnt" VARCHAR,
  "bene_race_black_cnt" VARCHAR,
  "bene_race_api_cnt" VARCHAR,
  "bene_race_hspnc_cnt" VARCHAR,
  "bene_race_natind_cnt" VARCHAR,
  "bene_race_othr_cnt" VARCHAR,
  "bene_ndual_cnt" VARCHAR,
  "bene_dual_cnt" VARCHAR,
  "bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
  "bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
  "bene_cc_bh_tobacco_v1_pct" VARCHAR,
  "bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
  "bene_cc_bh_anxiety_v1_pct" VARCHAR,
  "bene_cc_bh_bipolar_v1_pct" VARCHAR,
  "bene_cc_bh_mood_v2_pct" VARCHAR,
  "bene_cc_bh_depress_v1_pct" VARCHAR,
  "bene_cc_bh_pd_v1_pct" VARCHAR,
  "bene_cc_bh_ptsd_v1_pct" VARCHAR,
  "bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
  "bene_cc_ph_asthma_v2_pct" VARCHAR,
  "bene_cc_ph_afib_v2_pct" VARCHAR,
  "bene_cc_ph_cancer6_v2_pct" VARCHAR,
  "bene_cc_ph_ckd_v2_pct" VARCHAR,
  "bene_cc_ph_copd_v2_pct" VARCHAR,
  "bene_cc_ph_diabetes_v2_pct" VARCHAR,
  "bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
  "bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
  "bene_cc_ph_hypertension_v2_pct" VARCHAR,
  "bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
  "bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
  "bene_cc_ph_parkinson_v2_pct" VARCHAR,
  "bene_cc_ph_arthritis_v2_pct" VARCHAR,
  "bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
  "bene_avg_risk_scre" VARCHAR
);

Medicare Durable Medical Equipment, Devices & Supplies - By Supplier : 2017-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e51dbace.medicare_durable_medical_equipment_devices_supplies_by_7e708f65
  • 19.62 MB
  • 75,343 rows
  • 93 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_7e708f65 (
  "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" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "tot_suplr_hcpcs_cds" BIGINT,
  "tot_suplr_benes" VARCHAR,
  "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_suplr_hcpcs_cds" VARCHAR,
  "dme_tot_suplr_benes" VARCHAR,
  "dme_tot_suplr_clms" VARCHAR,
  "dme_tot_suplr_srvcs" VARCHAR,
  "dme_suplr_sbmtd_chrgs" VARCHAR,
  "dme_suplr_mdcr_alowd_amt" VARCHAR,
  "dme_suplr_mdcr_pymt_amt" VARCHAR,
  "dme_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "pos_sprsn_ind" VARCHAR,
  "pos_tot_suplr_hcpcs_cds" VARCHAR,
  "pos_tot_suplr_benes" VARCHAR,
  "pos_tot_suplr_clms" VARCHAR,
  "pos_tot_suplr_srvcs" VARCHAR,
  "pos_suplr_sbmtd_chrgs" VARCHAR,
  "pos_suplr_mdcr_alowd_amt" VARCHAR,
  "pos_suplr_mdcr_pymt_amt" VARCHAR,
  "pos_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "drug_sprsn_ind" VARCHAR,
  "drug_tot_suplr_hcpcs_cds" VARCHAR,
  "drug_tot_suplr_benes" VARCHAR,
  "drug_tot_suplr_clms" VARCHAR,
  "drug_tot_suplr_srvcs" VARCHAR,
  "drug_suplr_sbmtd_chrgs" VARCHAR,
  "drug_suplr_mdcr_alowd_amt" VARCHAR,
  "drug_suplr_mdcr_pymt_amt" VARCHAR,
  "drug_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "bene_avg_age" VARCHAR,
  "bene_age_lt_65_cnt" VARCHAR,
  "bene_age_65_74_cnt" VARCHAR,
  "bene_age_75_84_cnt" VARCHAR,
  "bene_age_gt_84_cnt" VARCHAR,
  "bene_feml_cnt" VARCHAR,
  "bene_male_cnt" VARCHAR,
  "bene_race_wht_cnt" VARCHAR,
  "bene_race_black_cnt" VARCHAR,
  "bene_race_api_cnt" VARCHAR,
  "bene_race_hspnc_cnt" VARCHAR,
  "bene_race_natind_cnt" VARCHAR,
  "bene_race_othr_cnt" VARCHAR,
  "bene_ndual_cnt" VARCHAR,
  "bene_dual_cnt" VARCHAR,
  "bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
  "bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
  "bene_cc_bh_tobacco_v1_pct" VARCHAR,
  "bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
  "bene_cc_bh_anxiety_v1_pct" VARCHAR,
  "bene_cc_bh_bipolar_v1_pct" VARCHAR,
  "bene_cc_bh_mood_v2_pct" VARCHAR,
  "bene_cc_bh_depress_v1_pct" VARCHAR,
  "bene_cc_bh_pd_v1_pct" VARCHAR,
  "bene_cc_bh_ptsd_v1_pct" VARCHAR,
  "bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
  "bene_cc_ph_asthma_v2_pct" VARCHAR,
  "bene_cc_ph_afib_v2_pct" VARCHAR,
  "bene_cc_ph_cancer6_v2_pct" VARCHAR,
  "bene_cc_ph_ckd_v2_pct" VARCHAR,
  "bene_cc_ph_copd_v2_pct" VARCHAR,
  "bene_cc_ph_diabetes_v2_pct" VARCHAR,
  "bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
  "bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
  "bene_cc_ph_hypertension_v2_pct" VARCHAR,
  "bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
  "bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
  "bene_cc_ph_parkinson_v2_pct" VARCHAR,
  "bene_cc_ph_arthritis_v2_pct" VARCHAR,
  "bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
  "bene_avg_risk_scre" VARCHAR
);

Medicare Durable Medical Equipment, Devices & Supplies - By Supplier : 2016-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e51dbace.medicare_durable_medical_equipment_devices_supplies_by_87fbd799
  • 14.68 MB
  • 76,586 rows
  • 68 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_87fbd799 (
  "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" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "tot_suplr_hcpcs_cds" BIGINT,
  "tot_suplr_benes" VARCHAR,
  "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_suplr_hcpcs_cds" VARCHAR,
  "dme_tot_suplr_benes" VARCHAR,
  "dme_tot_suplr_clms" VARCHAR,
  "dme_tot_suplr_srvcs" VARCHAR,
  "dme_suplr_sbmtd_chrgs" VARCHAR,
  "dme_suplr_mdcr_alowd_amt" VARCHAR,
  "dme_suplr_mdcr_pymt_amt" VARCHAR,
  "dme_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "pos_sprsn_ind" VARCHAR,
  "pos_tot_suplr_hcpcs_cds" VARCHAR,
  "pos_tot_suplr_benes" VARCHAR,
  "pos_tot_suplr_clms" VARCHAR,
  "pos_tot_suplr_srvcs" VARCHAR,
  "pos_suplr_sbmtd_chrgs" VARCHAR,
  "pos_suplr_mdcr_alowd_amt" VARCHAR,
  "pos_suplr_mdcr_pymt_amt" VARCHAR,
  "pos_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "drug_sprsn_ind" VARCHAR,
  "drug_tot_suplr_hcpcs_cds" VARCHAR,
  "drug_tot_suplr_benes" VARCHAR,
  "drug_tot_suplr_clms" VARCHAR,
  "drug_tot_suplr_srvcs" VARCHAR,
  "drug_suplr_sbmtd_chrgs" VARCHAR,
  "drug_suplr_mdcr_alowd_amt" VARCHAR,
  "drug_suplr_mdcr_pymt_amt" VARCHAR,
  "drug_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "bene_avg_age" VARCHAR,
  "bene_age_lt_65_cnt" VARCHAR,
  "bene_age_65_74_cnt" VARCHAR,
  "bene_age_75_84_cnt" VARCHAR,
  "bene_age_gt_84_cnt" VARCHAR,
  "bene_feml_cnt" VARCHAR,
  "bene_male_cnt" VARCHAR,
  "bene_race_wht_cnt" VARCHAR,
  "bene_race_black_cnt" VARCHAR,
  "bene_race_api_cnt" VARCHAR,
  "bene_race_hspnc_cnt" VARCHAR,
  "bene_race_natind_cnt" VARCHAR,
  "bene_race_othr_cnt" VARCHAR,
  "bene_ndual_cnt" VARCHAR,
  "bene_dual_cnt" VARCHAR,
  "bene_avg_risk_scre" VARCHAR
);

Medicare Durable Medical Equipment, Devices & Supplies - By Supplier : 2014-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e51dbace.medicare_durable_medical_equipment_devices_supplies_by_b6bb44b3
  • 14.78 MB
  • 78,831 rows
  • 68 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_b6bb44b3 (
  "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" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "tot_suplr_hcpcs_cds" BIGINT,
  "tot_suplr_benes" VARCHAR,
  "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_suplr_hcpcs_cds" VARCHAR,
  "dme_tot_suplr_benes" VARCHAR,
  "dme_tot_suplr_clms" VARCHAR,
  "dme_tot_suplr_srvcs" VARCHAR,
  "dme_suplr_sbmtd_chrgs" VARCHAR,
  "dme_suplr_mdcr_alowd_amt" VARCHAR,
  "dme_suplr_mdcr_pymt_amt" VARCHAR,
  "dme_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "pos_sprsn_ind" VARCHAR,
  "pos_tot_suplr_hcpcs_cds" VARCHAR,
  "pos_tot_suplr_benes" VARCHAR,
  "pos_tot_suplr_clms" VARCHAR,
  "pos_tot_suplr_srvcs" VARCHAR,
  "pos_suplr_sbmtd_chrgs" VARCHAR,
  "pos_suplr_mdcr_alowd_amt" VARCHAR,
  "pos_suplr_mdcr_pymt_amt" VARCHAR,
  "pos_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "drug_sprsn_ind" VARCHAR,
  "drug_tot_suplr_hcpcs_cds" VARCHAR,
  "drug_tot_suplr_benes" VARCHAR,
  "drug_tot_suplr_clms" VARCHAR,
  "drug_tot_suplr_srvcs" VARCHAR,
  "drug_suplr_sbmtd_chrgs" VARCHAR,
  "drug_suplr_mdcr_alowd_amt" VARCHAR,
  "drug_suplr_mdcr_pymt_amt" VARCHAR,
  "drug_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "bene_avg_age" VARCHAR,
  "bene_age_lt_65_cnt" VARCHAR,
  "bene_age_65_74_cnt" VARCHAR,
  "bene_age_75_84_cnt" VARCHAR,
  "bene_age_gt_84_cnt" VARCHAR,
  "bene_feml_cnt" VARCHAR,
  "bene_male_cnt" VARCHAR,
  "bene_race_wht_cnt" VARCHAR,
  "bene_race_black_cnt" VARCHAR,
  "bene_race_api_cnt" VARCHAR,
  "bene_race_hspnc_cnt" VARCHAR,
  "bene_race_natind_cnt" VARCHAR,
  "bene_race_othr_cnt" VARCHAR,
  "bene_ndual_cnt" VARCHAR,
  "bene_dual_cnt" VARCHAR,
  "bene_avg_risk_scre" VARCHAR
);

Medicare Durable Medical Equipment, Devices & Supplies - By Supplier : 2019-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e51dbace.medicare_durable_medical_equipment_devices_supplies_by_ceab47dd
  • 19.03 MB
  • 72,775 rows
  • 93 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_ceab47dd (
  "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" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "tot_suplr_hcpcs_cds" BIGINT,
  "tot_suplr_benes" VARCHAR,
  "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_suplr_hcpcs_cds" VARCHAR,
  "dme_tot_suplr_benes" VARCHAR,
  "dme_tot_suplr_clms" VARCHAR,
  "dme_tot_suplr_srvcs" VARCHAR,
  "dme_suplr_sbmtd_chrgs" VARCHAR,
  "dme_suplr_mdcr_alowd_amt" VARCHAR,
  "dme_suplr_mdcr_pymt_amt" VARCHAR,
  "dme_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "pos_sprsn_ind" VARCHAR,
  "pos_tot_suplr_hcpcs_cds" VARCHAR,
  "pos_tot_suplr_benes" VARCHAR,
  "pos_tot_suplr_clms" VARCHAR,
  "pos_tot_suplr_srvcs" VARCHAR,
  "pos_suplr_sbmtd_chrgs" VARCHAR,
  "pos_suplr_mdcr_alowd_amt" VARCHAR,
  "pos_suplr_mdcr_pymt_amt" VARCHAR,
  "pos_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "drug_sprsn_ind" VARCHAR,
  "drug_tot_suplr_hcpcs_cds" VARCHAR,
  "drug_tot_suplr_benes" VARCHAR,
  "drug_tot_suplr_clms" VARCHAR,
  "drug_tot_suplr_srvcs" VARCHAR,
  "drug_suplr_sbmtd_chrgs" VARCHAR,
  "drug_suplr_mdcr_alowd_amt" VARCHAR,
  "drug_suplr_mdcr_pymt_amt" VARCHAR,
  "drug_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "bene_avg_age" VARCHAR,
  "bene_age_lt_65_cnt" VARCHAR,
  "bene_age_65_74_cnt" VARCHAR,
  "bene_age_75_84_cnt" VARCHAR,
  "bene_age_gt_84_cnt" VARCHAR,
  "bene_feml_cnt" VARCHAR,
  "bene_male_cnt" VARCHAR,
  "bene_race_wht_cnt" VARCHAR,
  "bene_race_black_cnt" VARCHAR,
  "bene_race_api_cnt" VARCHAR,
  "bene_race_hspnc_cnt" VARCHAR,
  "bene_race_natind_cnt" VARCHAR,
  "bene_race_othr_cnt" VARCHAR,
  "bene_ndual_cnt" VARCHAR,
  "bene_dual_cnt" VARCHAR,
  "bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
  "bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
  "bene_cc_bh_tobacco_v1_pct" VARCHAR,
  "bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
  "bene_cc_bh_anxiety_v1_pct" VARCHAR,
  "bene_cc_bh_bipolar_v1_pct" VARCHAR,
  "bene_cc_bh_mood_v2_pct" VARCHAR,
  "bene_cc_bh_depress_v1_pct" VARCHAR,
  "bene_cc_bh_pd_v1_pct" VARCHAR,
  "bene_cc_bh_ptsd_v1_pct" VARCHAR,
  "bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
  "bene_cc_ph_asthma_v2_pct" VARCHAR,
  "bene_cc_ph_afib_v2_pct" VARCHAR,
  "bene_cc_ph_cancer6_v2_pct" VARCHAR,
  "bene_cc_ph_ckd_v2_pct" VARCHAR,
  "bene_cc_ph_copd_v2_pct" VARCHAR,
  "bene_cc_ph_diabetes_v2_pct" VARCHAR,
  "bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
  "bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
  "bene_cc_ph_hypertension_v2_pct" VARCHAR,
  "bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
  "bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
  "bene_cc_ph_parkinson_v2_pct" VARCHAR,
  "bene_cc_ph_arthritis_v2_pct" VARCHAR,
  "bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
  "bene_avg_risk_scre" VARCHAR
);

Medicare Durable Medical Equipment, Devices & Supplies - By Supplier : 2015-03-26

@usgov.hhs_gov_medicare_durable_medical_equipment_devices_sup_e51dbace.medicare_durable_medical_equipment_devices_supplies_by_d9b26fcb
  • 14.52 MB
  • 77,319 rows
  • 68 columns
Loading... 
CREATE TABLE medicare_durable_medical_equipment_devices_supplies_by_d9b26fcb (
  "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" VARCHAR,
  "suplr_prvdr_ruca_desc" VARCHAR,
  "suplr_prvdr_cntry" VARCHAR,
  "suplr_prvdr_spclty_desc" VARCHAR,
  "suplr_prvdr_spclty_srce" VARCHAR,
  "tot_suplr_hcpcs_cds" BIGINT,
  "tot_suplr_benes" VARCHAR,
  "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_suplr_hcpcs_cds" VARCHAR,
  "dme_tot_suplr_benes" VARCHAR,
  "dme_tot_suplr_clms" VARCHAR,
  "dme_tot_suplr_srvcs" VARCHAR,
  "dme_suplr_sbmtd_chrgs" VARCHAR,
  "dme_suplr_mdcr_alowd_amt" VARCHAR,
  "dme_suplr_mdcr_pymt_amt" VARCHAR,
  "dme_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "pos_sprsn_ind" VARCHAR,
  "pos_tot_suplr_hcpcs_cds" VARCHAR,
  "pos_tot_suplr_benes" VARCHAR,
  "pos_tot_suplr_clms" VARCHAR,
  "pos_tot_suplr_srvcs" VARCHAR,
  "pos_suplr_sbmtd_chrgs" VARCHAR,
  "pos_suplr_mdcr_alowd_amt" VARCHAR,
  "pos_suplr_mdcr_pymt_amt" VARCHAR,
  "pos_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "drug_sprsn_ind" VARCHAR,
  "drug_tot_suplr_hcpcs_cds" VARCHAR,
  "drug_tot_suplr_benes" VARCHAR,
  "drug_tot_suplr_clms" VARCHAR,
  "drug_tot_suplr_srvcs" VARCHAR,
  "drug_suplr_sbmtd_chrgs" VARCHAR,
  "drug_suplr_mdcr_alowd_amt" VARCHAR,
  "drug_suplr_mdcr_pymt_amt" VARCHAR,
  "drug_suplr_mdcr_stdzd_pymt_amt" VARCHAR,
  "bene_avg_age" VARCHAR,
  "bene_age_lt_65_cnt" VARCHAR,
  "bene_age_65_74_cnt" VARCHAR,
  "bene_age_75_84_cnt" VARCHAR,
  "bene_age_gt_84_cnt" VARCHAR,
  "bene_feml_cnt" VARCHAR,
  "bene_male_cnt" VARCHAR,
  "bene_race_wht_cnt" VARCHAR,
  "bene_race_black_cnt" VARCHAR,
  "bene_race_api_cnt" VARCHAR,
  "bene_race_hspnc_cnt" VARCHAR,
  "bene_race_natind_cnt" VARCHAR,
  "bene_race_othr_cnt" VARCHAR,
  "bene_ndual_cnt" VARCHAR,
  "bene_dual_cnt" VARCHAR,
  "bene_avg_risk_scre" VARCHAR
);

Share link

Anyone who has the link will be able to view this.