Medicare Advantage, Part D, Medicaid

Vlada County Volatility Index v4 by county and product type (Report 2's audited table): members, plan ended, moved, material cut, stable and gains, 2016-2027

medicare_semantic.cvi_county_v4·live·mart

Rows

140,775

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Report 2's audited County Volatility Index table: Of the members in a county's individual Medicare Advantage plans the September before a plan year, those whose plan ended (no successor sold in the county), who were moved by the insurer into another plan ID, or whose plan stayed and made a material cut (premium up $10+ a month, in-network MOOP up $500+ outside CMS's ceiling-to-ceiling move, comprehensive dental max down $500+ or dropped), per 100.
2Each member counts once, in the first bucket that applies (plan ended > moved > material cut > stable); gains are counted beside, never netted.
3Per county x product type x plan year: members, plans, must_pick (plan ended), moved, cut, stable, no_benefit_row, benefit_any_unknown, gain_any, gain_only, the cut by benefit (cut_premium, cut_moop, cut_dental; cut_moop_raw = the raw rise before the ceiling rule), moop_ceiling_to_ceiling, the OTC and Part B giveback side columns, benefit_part_locked and thin.
4Index = 100 x (must_pick + moved + cut) / members, from 2021.

Grain

Key	Grain
N/A	1One row per plan_year x state x county_ssa x product (unique: 140,775 rows = 140,775 keys, Athena 45461f1a); nine product types, 3,164 SSA counties. 2Rows by plan_year: 2016 8,930; 32017 8,957; 42018 9,052; 52019 9,710; 62020 10,393; 72021 11,097; 82022 11,734; 92023 12,632; 102024 13,587; 112025 14,380; 122026 15,013; 132027 15,290 (Athena 2b51c797). 14No FIPS column (cvi_plan_county_v4 carries it).

Key

Grain

N/A

1One row per plan_year x state x county_ssa x product (unique: 140,775 rows = 140,775 keys, Athena 45461f1a); nine product types, 3,164 SSA counties.
2Rows by plan_year: 2016 8,930;
32017 8,957;
42018 9,052;
52019 9,710;
62020 10,393;
72021 11,097;
82022 11,734;
92023 12,632;
102024 13,587;
112025 14,380;
122026 15,013;
132027 15,290 (Athena 2b51c797).
14No FIPS column (cvi_plan_county_v4 carries it).

Columns (26)

Column	Type	Meaning
`plan_year`	int
`state`	string
`county_ssa`	string
`county_name`	string
`product`	varchar(13)
`members`	bigint
`plans`	bigint
`must_pick`	bigint
`moved`	bigint
`cut`	bigint
`stable`	bigint
`no_benefit_row`	bigint
`benefit_any_unknown`	bigint
`gain_any`	bigint
`gain_only`	bigint
`cut_premium`	bigint
`cut_moop`	bigint
`cut_moop_raw`	bigint
`moop_ceiling_to_ceiling`	bigint
`cut_otc_side`	bigint
`cut_dental`	bigint
`cut_giveback_side`	bigint
`benefit_part_locked`	boolean
`thin`	boolean
`version`	varchar(2)
`reading`	varchar(296)

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`plan_year,state,county_ssa,product`
Join	`how_to_join(source_fqn="medicare_semantic.cvi_county_v4")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.cvi_county_v4 (pin plan_year; SUM the member columns and divide; filter NOT thin to rank)
Note	Registered 2026-10-26 under register w3 vlada_w3_county_volatility_index, door BOTH, World W3 (PR claude/cvi-release (#4329)). Unversioned (no is_current). The tools read cvi_plan_county_v4 (FIPS, plans, parents); this is the report's table of record. Check value, Hennepin MN (FIPS 27053) 2027: 123,564 members in 32 plans, index 91.7 = 54.2 plan ended + 16.6 moved + 20.8 material cut per 100 (Athena 7686b1c2), rank 140 of 2,785 ranked counties nationally and 50 of 82 in Minnesota (the tool's rank query, db35c895).

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