About this Dataset

Medicare Part D Prescribers - By Provider And Drug

The Medicare Part D Prescribers by Provider and Drug dataset provides information on prescription drugs prescribed to Medicare beneficiaries enrolled in Part D by physicians and other health care providers. This dataset contains the total number of prescription fills that were dispensed and the total drug cost paid organized by prescribing National Provider Identifier (NPI), drug brand name (if applicable) and drug generic name.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:22:25.547073
Tags: drugs, health-equity, medicare, medicare-prescription-drug, physicians-practitioners

Tables

Medicare Part D Prescribers - By Provider And Drug : 2014-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_provider_and_drug_8b766.medicare_part_d_prescribers_by_provider_and_drug_2014_12_31

599.86 MB
24,120,618 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_provider_and_drug_2014_12_31 (
  "prscrbr_npi" BIGINT,
  "prscrbr_last_org_name" VARCHAR,
  "prscrbr_first_name" VARCHAR,
  "prscrbr_city" VARCHAR,
  "prscrbr_state_abrvtn" VARCHAR,
  "prscrbr_state_fips" VARCHAR,
  "prscrbr_type" VARCHAR,
  "prscrbr_type_src" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "tot_day_suply" BIGINT,
  "tot_drug_cst" DOUBLE,
  "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
);

Medicare Part D Prescribers - By Provider And Drug : 2017-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_provider_and_drug_8b766.medicare_part_d_prescribers_by_provider_and_drug_2017_12_31

628.64 MB
25,209,130 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_provider_and_drug_2017_12_31 (
  "prscrbr_npi" BIGINT,
  "prscrbr_last_org_name" VARCHAR,
  "prscrbr_first_name" VARCHAR,
  "prscrbr_city" VARCHAR,
  "prscrbr_state_abrvtn" VARCHAR,
  "prscrbr_state_fips" VARCHAR,
  "prscrbr_type" VARCHAR,
  "prscrbr_type_src" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "tot_day_suply" BIGINT,
  "tot_drug_cst" DOUBLE,
  "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
);

Medicare Part D Prescribers - By Provider And Drug : 2021-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_provider_and_drug_8b766.medicare_part_d_prescribers_by_provider_and_drug_2021_12_31

640 MB
25,231,862 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_provider_and_drug_2021_12_31 (
  "prscrbr_npi" BIGINT,
  "prscrbr_last_org_name" VARCHAR,
  "prscrbr_first_name" VARCHAR,
  "prscrbr_city" VARCHAR,
  "prscrbr_state_abrvtn" VARCHAR,
  "prscrbr_state_fips" VARCHAR,
  "prscrbr_type" VARCHAR,
  "prscrbr_type_src" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "tot_day_suply" BIGINT,
  "tot_drug_cst" DOUBLE,
  "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
);

Medicare Part D Prescribers - By Provider And Drug : 2022-12-30

@usgov.hhs_gov_medicare_part_d_prescribers_by_provider_and_drug_8b766.medicare_part_d_prescribers_by_provider_and_drug_2022_12_30

657.9 MB
25,869,521 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_provider_and_drug_2022_12_30 (
  "prscrbr_npi" BIGINT,
  "prscrbr_last_org_name" VARCHAR,
  "prscrbr_first_name" VARCHAR,
  "prscrbr_city" VARCHAR,
  "prscrbr_state_abrvtn" VARCHAR,
  "prscrbr_state_fips" VARCHAR,
  "prscrbr_type" VARCHAR,
  "prscrbr_type_src" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "tot_day_suply" BIGINT,
  "tot_drug_cst" DOUBLE,
  "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
);

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

@usgov.hhs_gov_medicare_part_d_prescribers_by_provider_and_drug_8b766.medicare_part_d_prescribers_by_provider_and_drug_2023_12_31

684.86 MB
26,794,878 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_provider_and_drug_2023_12_31 (
  "prscrbr_npi" BIGINT,
  "prscrbr_last_org_name" VARCHAR,
  "prscrbr_first_name" VARCHAR,
  "prscrbr_city" VARCHAR,
  "prscrbr_state_abrvtn" VARCHAR,
  "prscrbr_state_fips" VARCHAR,
  "prscrbr_type" VARCHAR,
  "prscrbr_type_src" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "tot_day_suply" BIGINT,
  "tot_drug_cst" DOUBLE,
  "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
);