# Marketplace products, published CSV behind vw_hix_benchmark_change_v1 (hix_benchmark_change_v1)

`medicare_silver.hix_benchmark_change_v1` · Insurer negotiated rates · status partial

The S3 CSV table that medicare_semantic.vw_hix_benchmark_change_v1 types and serves. Query the view; this table exists so the products are rebuilt whole and the view can be repointed.

**Grain.** One row per county x (year - 1, year); every column a string (the CSV as published to S3 by products.py / materialize_ages.py).

| column | type | meaning |
|---|---|---|
| year | string |  |
| prior_year | string |  |
| state | string |  |
| county | string |  |
| rating_area | string |  |
| slcsp_prior | string |  |
| slcsp | string |  |
| chg_usd | string |  |
| chg_pct | string |  |
| 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 | string |  |
| successor_type | string |  |
| repricing_usd | string |  |
| reranking_usd | string |  |
| holder_change | string |  |
| lcsp_prior | string |  |
| lcsp | string |  |
| low_bronze_prior | string |  |
| low_bronze | string |  |
| low_gold_prior | string |  |
| low_gold | string |  |
| n_silver_prior | string |  |
| n_silver | string |  |
| n_parents_prior | string |  |
| n_parents | string |  |
| rating_area_changed | string |  |
| source | string |  |

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