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. Note: This full dataset contains more records than most spreadsheet programs can handle, which will result in an incomplete load of data. Use of a database or statistical software is required.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-04-26T02:59:23.341273
Tags: drugs, 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_a2fc0.medicare_part_d_prescribers_by_provider_2023_12_31

231.59 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
);