# Marketplace county benchmark at every age (vw_hix_county_benchmark_ages_v1)

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

The same plans as vw_hix_county_benchmark_v1 (one age curve per state, so the plans do not change by age), priced at every age; materialized as medicare_silver.hix_county_benchmark_ages_v1 (materialize_ages.py) so one county answers in seconds.

**Grain.** One row per county x age x plan year: 2,085,501 rows, 42,896 county-years. The benchmark, lowest silver, bronze and gold plans at each age in the plan's own rate table.

| column | type | meaning |
|---|---|---|
| year | int |  |
| state | string |  |
| county | string |  |
| rating_area | string |  |
| age | string |  |
| slcsp_plan | string |  |
| slcsp | double |  |
| slcsp_ehb | double |  |
| lcsp_plan | string |  |
| lcsp | double |  |
| low_bronze_plan | string |  |
| low_bronze | double |  |
| low_gold_plan | string |  |
| low_gold | double |  |
| slcsp_age40 | double |  |
| source | string |  |
| premium_source | string |  |

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