Medicare Advantage, Part D, Medicaid

Vlada Plan Value (Method Lock 1.0 + PV-55, signed 2026-10-17; served build v19e) same-member change 2026 -> 2027, national / state / county x product type x plan type x parent

medicare_semantic.vw_plan_value_pairs·live·semantic_view

Rows

117,836

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Vlada Plan Value (served build v19e, Method Lock 1.0 + PV-55), the same-member change: each 2026 member followed to their 2027 plan, counted only when the plan is valued in both years; *_2026 and *_2027 are levels on those members, *_change = 2027 - 2026.
2Every leg, the minimum-end and maximum-end values, the card bounds, the headline without Part D, the filed design and the D-SNP full-dual column, each with 2026 / 2027 / change.
3Ratios of the signed sums in plan_value_pairs_v19e at base_year 2026 (recommended fixcard3_design_on).
4Pinned name: medicare_semantic.vw_plan_value_pairs_v19e (served build v19e).
5Owner source: register w3 vlada_w3_benvat.

Grain

Key	Grain
N/A	1One row per geography_level x state x county_ssa x product_type x plan_type x parent_organization (117,836 rows = 117,836 distinct keys, measured 2026-10-08 on vw_plan_value_pairs_v16, _v17b, _v18 (2026-10-09), _v19d (2026-10-16) and _v19e (2026-10-17)). 2Same keys as vw_plan_value_cells.

Columns (74)

Column	Type	Meaning
`geography_level`	varchar(8)
`state`	string
`county_ssa`	string
`county_name`	string
`product_type`	string
`snp_type`	varchar(5)
`plan_type`	string
`parent_organization`	string
`headline_definition`	varchar(9)
`members_followed`	double
`members_valued_both_years`	double
`valued_both_years_share`	double
`plan_value_2026`	double
`plan_value_2027`	double
`plan_value_change`	double
`plan_value_min_end_2026`	double
`plan_value_min_end_2027`	double
`plan_value_min_end_change`	double
`plan_value_max_end_2026`	double
`plan_value_max_end_2027`	double
`plan_value_max_end_change`	double
`plan_value_card_low_2026`	double
`plan_value_card_low_2027`	double
`plan_value_card_low_change`	double
`plan_value_card_high_2026`	double
`plan_value_card_high_2027`	double
`plan_value_card_high_change`	double
`medical_cost_sharing_value_2026`	double
`medical_cost_sharing_value_2027`	double
`medical_cost_sharing_value_change`	double
`extras_value_2026`	double
`extras_value_2027`	double
`extras_value_change`	double
`part_d_value_2026`	double
`part_d_value_2027`	double
`part_d_value_change`	double
`part_b_buydown_value_2026`	double
`part_b_buydown_value_2027`	double
`part_b_buydown_value_change`	double
`member_premium_2026`	double
`member_premium_2027`	double
`member_premium_change`	double
`members_valued_both_years_excl_part_d`	double
`plan_value_excl_part_d_2026`	double
`plan_value_excl_part_d_2027`	double
`plan_value_excl_part_d_change`	double
`filed_design_members_valued_both_years`	double
`filed_design_plan_value_2026`	double
`filed_design_plan_value_2027`	double
`filed_design_plan_value_change`	double
`filed_design_min_end_2026`	double
`filed_design_min_end_2027`	double
`filed_design_min_end_change`	double
`filed_design_max_end_2026`	double
`filed_design_max_end_2027`	double
`filed_design_max_end_change`	double
`filed_design_card_low_2026`	double
`filed_design_card_low_2027`	double
`filed_design_card_low_change`	double
`filed_design_card_high_2026`	double
`filed_design_card_high_2027`	double
`filed_design_card_high_change`	double
`dsnp_full_dual_members_valued_both_years`	double
`dsnp_full_dual_plan_value_2026`	double
`dsnp_full_dual_plan_value_2027`	double
`dsnp_full_dual_plan_value_change`	double
`part_d_2027_filed_share`	double
`part_d_2027_carried_share`	double
`range_basis`	varchar(23)
`card_rule`	varchar(33)
`build`	varchar(14)
`variant`	varchar(18)
`atoms`	varchar(26)
`value_label`	varchar(7)

Query it

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

Item	Value
Typed tools that read it	get_plan_value
Identity key	`geography_level,state,county_ssa,product_type,plan_type,parent_organization`
Join	`how_to_join(source_fqn="medicare_semantic.vw_plan_value_pairs")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_plan_value_pairs
Company names	`parent_organization` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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