Medicare Advantage, Part D, Medicaid

Medicare Advantage Star Ratings (summary)

medicare_silver.stars_ratings_summary·live·silver·Medicare Advantage Star Ratings

Rows

29,282

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The contract's CMS Star rating (summary_star, 1.0-5.0).
24+ stars => a 5% benchmark bonus AND a higher rebate share — the single biggest swing in MA plan economics.
3Powers the Stars-trajectory analyses (Wolfe sell-side).

Grain

Key	Grain
N/A	1One row per (contract_id, part, payment_year) on is_current — CMS Star ratings summary. 2CERTIFIED 2026-06-03.

Columns (23)

Column	Type	Meaning
`contract_id`	string
`part`	string
`summary_star`	double
`star_rating_source`	string
`recompute_status`	string
`summary_text`	string
`summary_message_code`	string
`effective_period_start`	date
`effective_period_end`	date
`calculation_epoch`	string
`restatement_of`	string
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`bronze_publication_id`	string
`asserted_at`	timestamp
`rating_year`	int
`performance_year`	int
`payment_year`	int
`is_current`	boolean
`cms_vintage_sequence`	int
`qbp_payment_year`	int

Query it

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

Item	Value
Typed tools that read it	get_county_view, get_quality_bonus, get_star_benchmark, get_star_decomposition, get_star_risk, get_stars, get_stars_rollup
Identity key	`contract_id`
Join	`how_to_join(source_fqn="medicare_silver.stars_ratings_summary")`
Raw door	Athena (read-only via query_substrate): medicare_silver.stars_ratings_summary (filter is_current = true)
Note	CERTIFIED (product1-cert-ma-stars-v1). 14 payment years; summary_star range 1.5-5.0.

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