About this Dataset

Medicare Part D Prescribers - By Geography And Drug

The Medicare Part D Prescribers by Geography and Drug 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. For each drug, the dataset includes the total number of prescriptions that were dispensed, which include original prescriptions and any refills, and the total drug cost. The total drug cost includes the ingredient cost of the medication, dispensing fees, sales tax, and any applicable administration fees and is based on the amount paid by the Part D plan, Medicare beneficiary, government subsidies, and any other third-party payers.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:28:42.376678
Tags: drugs, health-equity, medicare, medicare-prescription-drug, national, physicians-practitioners, states-territories

Tables

Medicare Part D Prescribers - By Geography And Drug : 2013-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_d1df1.medicare_part_d_prescribers_by_geography_and_drug_2013_12_31

5.55 MB
106,757 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_geography_and_drug_2013_12_31 (
  "prscrbr_geo_lvl" VARCHAR,
  "prscrbr_geo_cd" VARCHAR,
  "prscrbr_geo_desc" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_prscrbrs" BIGINT,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "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_bene_sprsn_flag" VARCHAR,
  "ge65_tot_benes" DOUBLE,
  "lis_bene_cst_shr" DOUBLE,
  "nonlis_bene_cst_shr" DOUBLE,
  "opioid_drug_flag" VARCHAR,
  "opioid_la_drug_flag" VARCHAR,
  "antbtc_drug_flag" VARCHAR,
  "antpsyct_drug_flag" VARCHAR
);

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

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_d1df1.medicare_part_d_prescribers_by_geography_and_drug_2014_12_31

5.61 MB
107,432 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_geography_and_drug_2014_12_31 (
  "prscrbr_geo_lvl" VARCHAR,
  "prscrbr_geo_cd" VARCHAR,
  "prscrbr_geo_desc" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_prscrbrs" BIGINT,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "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_bene_sprsn_flag" VARCHAR,
  "ge65_tot_benes" DOUBLE,
  "lis_bene_cst_shr" DOUBLE,
  "nonlis_bene_cst_shr" DOUBLE,
  "opioid_drug_flag" VARCHAR,
  "opioid_la_drug_flag" VARCHAR,
  "antbtc_drug_flag" VARCHAR,
  "antpsyct_drug_flag" VARCHAR
);

Medicare Part D Prescribers - By Geography And Drug : 2015-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_d1df1.medicare_part_d_prescribers_by_geography_and_drug_2015_12_31

5.67 MB
109,032 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_geography_and_drug_2015_12_31 (
  "prscrbr_geo_lvl" VARCHAR,
  "prscrbr_geo_cd" VARCHAR,
  "prscrbr_geo_desc" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_prscrbrs" BIGINT,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "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_bene_sprsn_flag" VARCHAR,
  "ge65_tot_benes" DOUBLE,
  "lis_bene_cst_shr" DOUBLE,
  "nonlis_bene_cst_shr" DOUBLE,
  "opioid_drug_flag" VARCHAR,
  "opioid_la_drug_flag" VARCHAR,
  "antbtc_drug_flag" VARCHAR,
  "antpsyct_drug_flag" VARCHAR
);

Medicare Part D Prescribers - By Geography And Drug : 2016-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_d1df1.medicare_part_d_prescribers_by_geography_and_drug_2016_12_31

5.72 MB
109,640 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_geography_and_drug_2016_12_31 (
  "prscrbr_geo_lvl" VARCHAR,
  "prscrbr_geo_cd" VARCHAR,
  "prscrbr_geo_desc" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_prscrbrs" BIGINT,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "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_bene_sprsn_flag" VARCHAR,
  "ge65_tot_benes" DOUBLE,
  "lis_bene_cst_shr" DOUBLE,
  "nonlis_bene_cst_shr" DOUBLE,
  "opioid_drug_flag" VARCHAR,
  "opioid_la_drug_flag" VARCHAR,
  "antbtc_drug_flag" VARCHAR,
  "antpsyct_drug_flag" VARCHAR
);

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

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_d1df1.medicare_part_d_prescribers_by_geography_and_drug_2017_12_31

5.78 MB
110,802 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_geography_and_drug_2017_12_31 (
  "prscrbr_geo_lvl" VARCHAR,
  "prscrbr_geo_cd" VARCHAR,
  "prscrbr_geo_desc" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_prscrbrs" BIGINT,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "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_bene_sprsn_flag" VARCHAR,
  "ge65_tot_benes" DOUBLE,
  "lis_bene_cst_shr" DOUBLE,
  "nonlis_bene_cst_shr" DOUBLE,
  "opioid_drug_flag" VARCHAR,
  "opioid_la_drug_flag" VARCHAR,
  "antbtc_drug_flag" VARCHAR,
  "antpsyct_drug_flag" VARCHAR
);

Medicare Part D Prescribers - By Geography And Drug : 2018-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_d1df1.medicare_part_d_prescribers_by_geography_and_drug_2018_12_31

5.92 MB
113,607 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_geography_and_drug_2018_12_31 (
  "prscrbr_geo_lvl" VARCHAR,
  "prscrbr_geo_cd" VARCHAR,
  "prscrbr_geo_desc" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_prscrbrs" BIGINT,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "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_bene_sprsn_flag" VARCHAR,
  "ge65_tot_benes" DOUBLE,
  "lis_bene_cst_shr" DOUBLE,
  "nonlis_bene_cst_shr" DOUBLE,
  "opioid_drug_flag" VARCHAR,
  "opioid_la_drug_flag" VARCHAR,
  "antbtc_drug_flag" VARCHAR,
  "antpsyct_drug_flag" VARCHAR
);

Medicare Part D Prescribers - By Geography And Drug : 2019-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_d1df1.medicare_part_d_prescribers_by_geography_and_drug_2019_12_31

5.98 MB
114,645 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_geography_and_drug_2019_12_31 (
  "prscrbr_geo_lvl" VARCHAR,
  "prscrbr_geo_cd" VARCHAR,
  "prscrbr_geo_desc" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_prscrbrs" BIGINT,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "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_bene_sprsn_flag" VARCHAR,
  "ge65_tot_benes" DOUBLE,
  "lis_bene_cst_shr" DOUBLE,
  "nonlis_bene_cst_shr" DOUBLE,
  "opioid_drug_flag" VARCHAR,
  "opioid_la_drug_flag" VARCHAR,
  "antbtc_drug_flag" VARCHAR,
  "antpsyct_drug_flag" VARCHAR
);

Medicare Part D Prescribers - By Geography And Drug : 2020-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_d1df1.medicare_part_d_prescribers_by_geography_and_drug_2020_12_31

6.03 MB
115,410 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_geography_and_drug_2020_12_31 (
  "prscrbr_geo_lvl" VARCHAR,
  "prscrbr_geo_cd" VARCHAR,
  "prscrbr_geo_desc" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_prscrbrs" BIGINT,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "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_bene_sprsn_flag" VARCHAR,
  "ge65_tot_benes" DOUBLE,
  "lis_bene_cst_shr" DOUBLE,
  "nonlis_bene_cst_shr" DOUBLE,
  "opioid_drug_flag" VARCHAR,
  "opioid_la_drug_flag" VARCHAR,
  "antbtc_drug_flag" VARCHAR,
  "antpsyct_drug_flag" VARCHAR
);

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

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_d1df1.medicare_part_d_prescribers_by_geography_and_drug_2021_12_31

5.97 MB
114,891 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_geography_and_drug_2021_12_31 (
  "prscrbr_geo_lvl" VARCHAR,
  "prscrbr_geo_cd" VARCHAR,
  "prscrbr_geo_desc" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_prscrbrs" BIGINT,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "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_bene_sprsn_flag" VARCHAR,
  "ge65_tot_benes" DOUBLE,
  "lis_bene_cst_shr" DOUBLE,
  "nonlis_bene_cst_shr" DOUBLE,
  "opioid_drug_flag" VARCHAR,
  "opioid_la_drug_flag" VARCHAR,
  "antbtc_drug_flag" VARCHAR,
  "antpsyct_drug_flag" VARCHAR
);

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

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_d1df1.medicare_part_d_prescribers_by_geography_and_drug_2022_12_30

6.04 MB
115,396 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_geography_and_drug_2022_12_30 (
  "prscrbr_geo_lvl" VARCHAR,
  "prscrbr_geo_cd" VARCHAR,
  "prscrbr_geo_desc" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_prscrbrs" BIGINT,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "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_bene_sprsn_flag" VARCHAR,
  "ge65_tot_benes" DOUBLE,
  "lis_bene_cst_shr" DOUBLE,
  "nonlis_bene_cst_shr" DOUBLE,
  "opioid_drug_flag" VARCHAR,
  "opioid_la_drug_flag" VARCHAR,
  "antbtc_drug_flag" VARCHAR,
  "antpsyct_drug_flag" VARCHAR
);

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

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_d1df1.medicare_part_d_prescribers_by_geography_and_drug_2023_12_31

6.05 MB
115,936 rows
22 columns

CREATE TABLE medicare_part_d_prescribers_by_geography_and_drug_2023_12_31 (
  "prscrbr_geo_lvl" VARCHAR,
  "prscrbr_geo_cd" VARCHAR,
  "prscrbr_geo_desc" VARCHAR,
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_prscrbrs" BIGINT,
  "tot_clms" BIGINT,
  "tot_30day_fills" DOUBLE,
  "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_bene_sprsn_flag" VARCHAR,
  "ge65_tot_benes" DOUBLE,
  "lis_bene_cst_shr" DOUBLE,
  "nonlis_bene_cst_shr" DOUBLE,
  "opioid_drug_flag" VARCHAR,
  "opioid_la_drug_flag" VARCHAR,
  "antbtc_drug_flag" VARCHAR,
  "antpsyct_drug_flag" VARCHAR
);