# Marketplace plans sold in each county (vw_hix_plan_county_v1)

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

Every plan the engine found on sale in each county, from the same source as the county's benchmark.

**Grain.** One row per plan x county x plan year: rating area, issuer, parent, metal, age-40 premium at list and EHB. 1,538,783 rows. All 51 jurisdictions: HealthCare.gov states 2014-2027, state-run exchanges 2016-2027.

| column | type | meaning |
|---|---|---|
| year | int |  |
| state | string |  |
| county | string |  |
| rating_area | string |  |
| plan_id | string |  |
| issuer_id | string |  |
| parent | string |  |
| metal | string |  |
| premium_age40 | double |  |
| premium_ehb_age40 | double |  |
| source | string |  |

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