# Marketplace benchmark change, every year pair (vw_hix_benchmark_change_v1)

`medicare_semantic.vw_hix_benchmark_change_v1` · Insurer negotiated rates · status partial

The benchmark move split into repricing (last year's benchmark plan's successor: CMS's crosswalk in HealthCare.gov states, the same plan id in state-run exchanges) and re-ranking, with who held it each year and why it changed.

**Grain.** One row per county x (year - 1, year): 39,705 rows, 2015-2027.

| column | type | meaning |
|---|---|---|
| year | int |  |
| prior_year | int |  |
| state | string |  |
| county | string |  |
| rating_area | string |  |
| slcsp_prior | double |  |
| slcsp | double |  |
| chg_usd | double |  |
| chg_pct | double |  |
| bench_plan_prior | string |  |
| bench_parent_prior | string |  |
| bench_plan | string |  |
| bench_parent | string |  |
| successor_plan | string |  |
| successor_basis | string |  |
| successor_reason | string |  |
| successor_metal | string |  |
| successor_premium | double |  |
| successor_type | string |  |
| repricing_usd | double |  |
| reranking_usd | double |  |
| holder_change | string |  |
| lcsp_prior | double |  |
| lcsp | double |  |
| low_bronze_prior | double |  |
| low_bronze | double |  |
| low_gold_prior | double |  |
| low_gold | double |  |
| n_silver_prior | int |  |
| n_silver | int |  |
| n_parents_prior | int |  |
| n_parents | int |  |
| rating_area_changed | boolean |  |
| source | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_hix_benchmark_change_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_hix_benchmark_change_v1")` first.