Dataset: Medicare Part D Prescribers - By Geography And Drug

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-04-26T03:01:40.590278
Tags: drugs, medicare, medicare-prescription-drug, national, physicians-practitioners, states-territories

Tables

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

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_67fb0.medicare_part_d_prescribers_by_geography_and_drug_2023_12_31

5.77 MB
115936 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
);

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

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_67fb0.medicare_part_d_prescribers_by_geography_and_drug_2022_12_30

5.76 MB
115396 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 : 2021-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_67fb0.medicare_part_d_prescribers_by_geography_and_drug_2021_12_31

5.69 MB
114891 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 : 2020-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_67fb0.medicare_part_d_prescribers_by_geography_and_drug_2020_12_31

5.75 MB
115410 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 : 2019-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_67fb0.medicare_part_d_prescribers_by_geography_and_drug_2019_12_31

5.7 MB
114645 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 : 2018-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_67fb0.medicare_part_d_prescribers_by_geography_and_drug_2018_12_31

5.64 MB
113607 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 : 2017-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_67fb0.medicare_part_d_prescribers_by_geography_and_drug_2017_12_31

5.51 MB
110802 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 : 2016-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_67fb0.medicare_part_d_prescribers_by_geography_and_drug_2016_12_31

5.45 MB
109640 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 : 2015-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_67fb0.medicare_part_d_prescribers_by_geography_and_drug_2015_12_31

5.41 MB
109032 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 : 2014-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_67fb0.medicare_part_d_prescribers_by_geography_and_drug_2014_12_31

5.35 MB
107432 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 : 2013-12-31

@usgov.hhs_gov_medicare_part_d_prescribers_by_geography_and_drug_67fb0.medicare_part_d_prescribers_by_geography_and_drug_2013_12_31

5.29 MB
106757 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
);