About this Dataset

Medicare Part D Prescribers - By Provider

The Medicare Part D Prescribers by Provider dataset contains information on prescription drugs prescribed by individual physicians and other health care providers and paid for under the Medicare Part D Prescription Drug Program. The dataset identifies providers by their National Provider Identifier (NPI) and summarizes for each prescriber the total number of prescriptions that were dispensed, which include original prescriptions and any refills, and the total drug cost.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:26:47.910849
Tags: drugs, health-equity, medicare, medicare-prescription-drug, physicians-practitioners

Tables

Medicare Part D Prescribers - By Provider : 2023-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_provider_62d8d.medicare_part_d_prescribers_by_provider_2023_12_31

247.79 MB
1,380,665 rows
84 columns

CREATE TABLE medicare_part_d_prescribers_by_provider_2023_12_31 (
  "prscrbr_npi" BIGINT,
  "prscrbr_last_org_name" VARCHAR,
  "prscrbr_first_name" VARCHAR,
  "prscrbr_mi" VARCHAR,
  "prscrbr_crdntls" VARCHAR,
  "prscrbr_ent_cd" VARCHAR,
  "prscrbr_st1" VARCHAR,
  "prscrbr_st2" VARCHAR,
  "prscrbr_city" VARCHAR,
  "prscrbr_state_abrvtn" VARCHAR,
  "prscrbr_state_fips" DOUBLE,
  "prscrbr_zip5" DOUBLE,
  "prscrbr_ruca" DOUBLE,
  "prscrbr_ruca_desc" VARCHAR,
  "prscrbr_cntry" VARCHAR,
  "prscrbr_type" VARCHAR,
  "prscrbr_type_src" VARCHAR,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "tot_drug_cst" DOUBLE,
  "tot_day_suply" BIGINT,
  "tot_benes" DOUBLE,
  "ge65_sprsn_flag" VARCHAR,
  "ge65_tot_clms" DOUBLE,
  "ge65_tot_30day_fills" DOUBLE,
  "ge65_tot_drug_cst" DOUBLE,
  "ge65_tot_day_suply" DOUBLE,
  "ge65_bene_sprsn_flag" VARCHAR,
  "ge65_tot_benes" DOUBLE,
  "brnd_sprsn_flag" VARCHAR,
  "brnd_tot_clms" DOUBLE,
  "brnd_tot_drug_cst" DOUBLE,
  "gnrc_sprsn_flag" VARCHAR,
  "gnrc_tot_clms" DOUBLE,
  "gnrc_tot_drug_cst" DOUBLE,
  "othr_sprsn_flag" VARCHAR,
  "othr_tot_clms" DOUBLE,
  "othr_tot_drug_cst" DOUBLE,
  "mapd_sprsn_flag" VARCHAR,
  "mapd_tot_clms" DOUBLE,
  "mapd_tot_drug_cst" DOUBLE,
  "pdp_sprsn_flag" VARCHAR,
  "pdp_tot_clms" DOUBLE,
  "pdp_tot_drug_cst" DOUBLE,
  "lis_sprsn_flag" VARCHAR,
  "lis_tot_clms" DOUBLE,
  "lis_drug_cst" DOUBLE,
  "nonlis_sprsn_flag" VARCHAR,
  "nonlis_tot_clms" DOUBLE,
  "nonlis_drug_cst" DOUBLE,
  "opioid_tot_clms" DOUBLE,
  "opioid_tot_drug_cst" DOUBLE,
  "opioid_tot_suply" DOUBLE,
  "opioid_tot_benes" DOUBLE,
  "opioid_prscrbr_rate" DOUBLE,
  "opioid_la_tot_clms" DOUBLE,
  "opioid_la_tot_drug_cst" DOUBLE,
  "opioid_la_tot_suply" DOUBLE,
  "opioid_la_tot_benes" DOUBLE,
  "opioid_la_prscrbr_rate" DOUBLE,
  "antbtc_tot_clms" DOUBLE,
  "antbtc_tot_drug_cst" DOUBLE,
  "antbtc_tot_benes" DOUBLE,
  "antpsyct_ge65_sprsn_flag" VARCHAR,
  "antpsyct_ge65_tot_clms" DOUBLE,
  "antpsyct_ge65_tot_drug_cst" DOUBLE,
  "antpsyct_ge65_bene_suprsn_flag" VARCHAR,
  "antpsyct_ge65_tot_benes" 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_dual_cnt" DOUBLE,
  "bene_ndual_cnt" DOUBLE,
  "bene_avg_risk_scre" DOUBLE
);