# Marketplace products, published CSV behind vw_hix_market_structure_v1 (hix_market_structure_v1)

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

The S3 CSV table that medicare_semantic.vw_hix_market_structure_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 parent x plan year; every column a string (the CSV as published to S3 by products.py / materialize_ages.py).

| column | type | meaning |
|---|---|---|
| year | string |  |
| state | string |  |
| county | string |  |
| rating_area | string |  |
| parent | string |  |
| issuers | string |  |
| plans | string |  |
| silver_plans | string |  |
| bronze_plans | string |  |
| gold_plans | string |  |
| cheapest_silver_age40 | string |  |
| cheapest_silver_rank | string |  |
| parents_with_silver | string |  |
| holds_lcsp | string |  |
| holds_benchmark | string |  |
| status | string |  |
| source | string |  |

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