# Marketplace products, published CSV behind vw_hix_plan_county_v1 (hix_plan_county_v1)

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

The S3 CSV table that medicare_semantic.vw_hix_plan_county_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 plan x county 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 |  |
| plan_id | string |  |
| issuer_id | string |  |
| parent | string |  |
| metal | string |  |
| premium_age40 | string |  |
| premium_ehb_age40 | string |  |
| source | string |  |

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