Medicare Advantage, Part D, Medicaid

MA regional benchmarks and Part D national and LIS benchmarks, CY2006-2027

medicare_silver.ma_part_d_benchmark_figure·live·silver

Rows

3,111

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Per contract year: the MA regional benchmark components for the 26 MA regions (statutory and plan-bid), the Part D regional low-income premium subsidy amounts for the 34 PDP regions (the regional LIS benchmark), and the national Part D figures from the late-July announcement: NAMBA, base beneficiary premium, de minimis (from 2015) and the statutory / plan-bid weights.
22027: NAMBA $296.05, base beneficiary premium $41.33.

Grain

Key	Grain
N/A	1One row per published figure: (rate_year, table_kind, region_code, measure), with the verbatim source_line it was read from.

Columns (21)

Column	Type	Meaning
`rate_year`	int
`table_kind`	string
`region_code`	string
`region_states`	string
`measure`	string
`column_header`	string
`value_text`	string
`value_num`	double
`value_unit`	string
`source_line`	string
`source_note`	string
`stated_year`	int
`source_document`	string
`source_member`	string
`extraction_engine`	string
`source_url`	string
`member_sha256`	string
`sha256_content_hash`	string
`bronze_publication_id`	string
`asserted_at`	timestamp
`parser_artifact_hash`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`rate_year,table_kind,region_code,measure`
Join	`how_to_join(source_fqn="medicare_silver.ma_part_d_benchmark_figure")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ma_part_d_benchmark_figure
Note	Data Tracker lane F, loaded 2026-09-29: 3,111 figures, CY2006-2027, 0 duplicate keys, 0 lineage nulls (Athena 00a4829c-4d46-446d-b1e5-29dd3ab5ed84); rerun unchanged. Every PDF figure re-found by a second engine (0 failures). The landscape lips_amount equals the LIS subsidy amount in all 34 regions 2025-2027. Register source cms_regional_rates_part_d_benchmarks (w3).

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