Vlada County Volatility Index v4 by plan and county: each MA plan's September members and what happened to them the next plan year (plan ended, moved, material cut, stable), 2016-2027

What it is

1. 1The County Volatility Index (Report 2) at its own grain, the rows medicare_semantic.cvi_county_v4 sums: 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.
2. 2Each member counts once, in the first bucket that applies (plan ended > moved > material cut > stable); gains are counted beside, never netted.
3. 3One row per plan in a county with its September members, its bucket, which benefit was cut (cut_premium, cut_moop, cut_dental), the ceiling-to-ceiling MOOP flag, any_gain, the two years' premium, MOOP and dental values (prem_old/new, moop_old/new, dent_old/new), the plan name and CMS's parent the September before (parent_raw).
4. 4The read layer of get_volatility_index and get_county_view sections=volatility.
5. 5The index of a group = 100 x sum(members where bucket IN ('plan_ended','moved','material_cut')) / sum(members).

Grain

Columns (26)

Query it

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