Drugs and formularies

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

medicare_silver.fact_part_d_spending_by_drug_quarterly·live·silver

Rows

27,748

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Preliminary 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.
22025 (Q1-Q4): $350.87B over Overall rows;
3Eliquis $24.05B.

Grain

Key	Grain
N/A	1One row per (brnd_name, gnrc_name, mftr_name, period_label) per quarterly release.

Columns (31)

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

describe_data_source(source_fqn="medicare_silver.fact_part_d_spending_by_drug_quarterly")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_part_d_spending_by_drug_quarterly WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`brnd_name,gnrc_name,mftr_name,period_label`
Join	`how_to_join(source_fqn="medicare_silver.fact_part_d_spending_by_drug_quarterly")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_part_d_spending_by_drug_quarterly
Note	Register source cms_quarterly_part_d_spending_by_drug (w3, serve raw). RAW. Loaded 2026-09-29 (verify_tracker_loads PASS 2026-09-30: 27,748 rows, 7,025 Overall rows, Overall spend by period equals the publisher; Athena 36f45f70, 5e7cb5aa, 679a2d74). Cell reconciliation PASS (row count, claims, beneficiaries and manufacturer sums over the whole file). Registered 2026-09-30 in W3 beside the annual Part D spending source.

This page as markdown: /docs-md/data/medicare_silver_fact_part_d_spending_by_drug_quarterly.md · every page in one file: /llms-full.txt