# Marketplace market structure by parent and county (vw_hix_market_structure_v1)

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

Plans by metal, cheapest silver and its rank among parents, whether the parent holds the lowest or the benchmark silver, and status against the year before (entered, continuing, exited; exited rows carry zero plans).

**Grain.** One row per county x parent x plan year: 133,433 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 |  |
| parent | string |  |
| issuers | int |  |
| plans | int |  |
| silver_plans | int |  |
| bronze_plans | int |  |
| gold_plans | int |  |
| cheapest_silver_age40 | double |  |
| cheapest_silver_rank | int |  |
| parents_with_silver | int |  |
| holds_lcsp | boolean |  |
| holds_benchmark | boolean |  |
| status | string |  |
| source | string |  |

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