Dataset: Medicare Part D Spending By Drug

About this Dataset

Medicare Part D Spending By Drug

The Medicare Part D by Drug dataset presents information on spending for drugs prescribed to Medicare beneficiaries enrolled in Part D by physicians and other healthcare providers. Drugs prescribed in the Medicare Part D program are drugs patients generally administer themselves. The dataset focuses on average spending per dosage unit and change in average spending per dosage unit over time. It also includes spending information for manufacturer(s) of the drugs as well as consumer-friendly information of drug uses and clinical indications. Drug spending metrics for Part D drugs are based on the gross drug cost, which represents total spending for the prescription claim, including Medicare, plan, and beneficiary payments. The Part D spending metrics do not reflect any manufacturers’ rebates or other price concessions as CMS is prohibited from publicly disclosing such information.
Organization: U.S. Department of Health & Human Services
Last updated: 2024-03-15T05:03:01.781033
Tags: drugs, medical-suppliers-equipment, medicare, medicare-prescription-drug

Tables

Medicare Part D Spending By Drug : 2022-01-01

@usgov.hhs_gov_medicare_part_d_spending_by_drug_401d2.medicare_part_d_spending_by_drug_2022_01_01

3.06 MB
13889 rows
46 columns


CREATE TABLE medicare_part_d_spending_by_drug_2022_01_01 (
  "brnd_name" VARCHAR,
  "gnrc_name" VARCHAR,
  "tot_mftr" BIGINT,
  "mftr_name" VARCHAR,
  "tot_spndng_2018" DOUBLE,
  "tot_dsg_unts_2018" DOUBLE,
  "tot_clms_2018" DOUBLE,
  "tot_benes_2018" DOUBLE,
  "avg_spnd_per_dsg_unt_wghtd_2018" DOUBLE,
  "avg_spnd_per_clm_2018" DOUBLE,
  "avg_spnd_per_bene_2018" DOUBLE,
  "outlier_flag_2018" DOUBLE,
  "tot_spndng_2019" DOUBLE,
  "tot_dsg_unts_2019" DOUBLE,
  "tot_clms_2019" DOUBLE,
  "tot_benes_2019" DOUBLE,
  "avg_spnd_per_dsg_unt_wghtd_2019" DOUBLE,
  "avg_spnd_per_clm_2019" DOUBLE,
  "avg_spnd_per_bene_2019" DOUBLE,
  "outlier_flag_2019" DOUBLE,
  "tot_spndng_2020" DOUBLE,
  "tot_dsg_unts_2020" DOUBLE,
  "tot_clms_2020" DOUBLE,
  "tot_benes_2020" DOUBLE,
  "avg_spnd_per_dsg_unt_wghtd_2020" DOUBLE,
  "avg_spnd_per_clm_2020" DOUBLE,
  "avg_spnd_per_bene_2020" DOUBLE,
  "outlier_flag_2020" DOUBLE,
  "tot_spndng_2021" DOUBLE,
  "tot_dsg_unts_2021" DOUBLE,
  "tot_clms_2021" DOUBLE,
  "tot_benes_2021" DOUBLE,
  "avg_spnd_per_dsg_unt_wghtd_2021" DOUBLE,
  "avg_spnd_per_clm_2021" DOUBLE,
  "avg_spnd_per_bene_2021" DOUBLE,
  "outlier_flag_2021" DOUBLE,
  "tot_spndng_2022" DOUBLE,
  "tot_dsg_unts_2022" DOUBLE,
  "tot_clms_2022" BIGINT,
  "tot_benes_2022" DOUBLE,
  "avg_spnd_per_dsg_unt_wghtd_2022" DOUBLE,
  "avg_spnd_per_clm_2022" DOUBLE,
  "avg_spnd_per_bene_2022" DOUBLE,
  "outlier_flag_2022" DOUBLE,
  "chg_avg_spnd_per_dsg_unt_21_22" DOUBLE,
  "cagr_avg_spnd_per_dsg_unt_18_22" DOUBLE
);