# Medicare Quarterly Part D Spending by Drug (preliminary), 2025-2026

`medicare_silver.fact_part_d_spending_by_drug_quarterly` · Drugs and formularies · status live · 27,748 rows

Preliminary Part D gross spending per drug (brand x generic x manufacturer, plus an Overall row) for the prior full year and the current year to date: beneficiaries, claims, spending and per-claim / per-beneficiary averages. 2025 (Q1-Q4): $350.87B over Overall rows; Eliquis $24.05B.

**Grain.** One row per (brnd_name, gnrc_name, mftr_name, period_label) per quarterly release.

| column | type | meaning |
|---|---|---|
| publisher_version | string |  |
| brnd_name | string |  |
| gnrc_name | string |  |
| mftr_name | string |  |
| is_overall_row | boolean |  |
| tot_mftr | int |  |
| period_label | string |  |
| year | int |  |
| ytd_through_quarter | int |  |
| tot_benes | bigint |  |
| tot_clms | bigint |  |
| tot_spndng | double |  |
| avg_spnd_per_bene | double |  |
| avg_spnd_per_clm | double |  |
| benes_status | string |  |
| drug_uses | string |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.fact_part_d_spending_by_drug_quarterly WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_part_d_spending_by_drug_quarterly")` first.