Medicare Advantage, Part D, Medicaid

Vlada Plan Value (Method Lock 1.0 + PV-55, signed 2026-10-17; served build v19e) market cells, national / state / county x product type x plan type x parent, 2026 and 2027 levels

medicare_semantic.vw_plan_value_cells·live·semantic_view

Rows

129,363

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Vlada Plan Value member-weighted: each value is the signed sum over September 2026 members divided by the members valued (plan_value_cells_v19e at base_year 2026, recommended fixcard3_design_on, read straight).
2Served build v19e = Method Lock 1.0 (v19d, signed by Ben 2026-10-15, final 2026-10-16) + PV-55 (the ER copay charged on every visit, CMS's convention), signed by Ben 2026-10-17 on docs/ma-value-engine/lock/v19/GATE-RECEIPT-v19e.json as the Plan Value for launch (docs/ma-value-engine/V19-2025-2027.md): the v16 method plus the v18c / v18d / v18e fixes, the SSBCI eligibility rule, U3, D3 and the extras read through one reader on benefit edition v20261015d;
32027 Part D FINAL on CMS's CY2027 formulary;
4CY2025 built (not in this view; the table carries base_year 2025 too).
52026 = every 2026 member in their 2026 plan;
62027 = the same members followed to their 2027 plan (same plan or CMS's crosswalk), priced on the 2026 cohort, statute and dollars.
7Columns: the headline and its five legs, the minimum-end and maximum-end values, the card bounds, the headline without Part D, the filed design with its legs, ends and bounds, the valued shares, and for D-SNP the full-dual column and the share of members in $0-cost-sharing segments.
8Pinned version: medicare_semantic.vw_plan_value_cells_v19e (served build v19e).
9Owner 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 (129,363 rows = 129,363 distinct keys, measured 2026-10-08 on vw_plan_value_cells_v16, _v17b, _v18 (2026-10-09), _v19d (2026-10-16) and _v19e (2026-10-17); 2792 national, 3,834 state, 124,737 county; 352 states and territories, 3,116 counties, 166 parents + ALL). plan_type 'ALL' = every plan type of the product type; parent_organization 'ALL' = the whole market. product_type is never pooled ('ALL' is not served).

Key

Grain

N/A

1One row per geography_level x state x county_ssa x product_type x plan_type x parent_organization (129,363 rows = 129,363 distinct keys, measured 2026-10-08 on vw_plan_value_cells_v16, _v17b, _v18 (2026-10-09), _v19d (2026-10-16) and _v19e (2026-10-17);
2792 national, 3,834 state, 124,737 county;
352 states and territories, 3,116 counties, 166 parents + ALL). plan_type 'ALL' = every plan type of the product type; parent_organization 'ALL' = the whole market. product_type is never pooled ('ALL' is not served).

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_2026`	double
`members_2027_followed`	double
`valued_share_2026`	double
`valued_share_2027`	double
`plan_value_2026`	double
`plan_value_min_end_2026`	double
`plan_value_max_end_2026`	double
`plan_value_card_low_2026`	double
`plan_value_card_high_2026`	double
`plan_value_2027`	double
`plan_value_min_end_2027`	double
`plan_value_max_end_2027`	double
`plan_value_card_low_2027`	double
`plan_value_card_high_2027`	double
`medical_cost_sharing_value_2026`	double
`extras_value_2026`	double
`part_d_value_2026`	double
`part_b_buydown_value_2026`	double
`member_premium_2026`	double
`medical_cost_sharing_value_min_end_2026`	double
`medical_cost_sharing_value_max_end_2026`	double
`medical_cost_sharing_value_2027`	double
`extras_value_2027`	double
`part_d_value_2027`	double
`part_b_buydown_value_2027`	double
`member_premium_2027`	double
`medical_cost_sharing_value_min_end_2027`	double
`medical_cost_sharing_value_max_end_2027`	double
`plan_value_excl_part_d_2026`	double
`plan_value_excl_part_d_2027`	double
`filed_design_plan_value_2026`	double
`filed_design_min_end_2026`	double
`filed_design_max_end_2026`	double
`filed_design_card_low_2026`	double
`filed_design_card_high_2026`	double
`filed_design_medical_value_2026`	double
`filed_design_extras_value_2026`	double
`filed_design_part_d_value_2026`	double
`filed_design_part_b_buydown_value_2026`	double
`filed_design_member_premium_2026`	double
`filed_design_valued_share_2026`	double
`filed_design_plan_value_2027`	double
`filed_design_min_end_2027`	double
`filed_design_max_end_2027`	double
`filed_design_card_low_2027`	double
`filed_design_card_high_2027`	double
`filed_design_medical_value_2027`	double
`filed_design_extras_value_2027`	double
`filed_design_part_d_value_2027`	double
`filed_design_part_b_buydown_value_2027`	double
`filed_design_member_premium_2027`	double
`filed_design_valued_share_2027`	double
`dsnp_full_dual_plan_value_2026`	double
`dsnp_zero_dollar_cost_sharing_share_2026`	double
`dsnp_full_dual_plan_value_2027`	double
`dsnp_zero_dollar_cost_sharing_share_2027`	double
`part_d_2027_filed_share`	double
`part_d_2027_carried_share`	double
`part_d_2027_refused_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_cells")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_plan_value_cells 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_cells")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_plan_value_cells
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_cells.md · every page in one file: /llms-full.txt