# Marketplace products, published CSV behind vw_hix_county_benchmark_v1 (hix_county_benchmark_v1)

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

The S3 CSV table that medicare_semantic.vw_hix_county_benchmark_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 plan year at age 40; 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 |  |
| ra_mapping | string |  |
| ra_land_share | string |  |
| age | string |  |
| n_silver | string |  |
| n_issuers | string |  |
| lcsp | string |  |
| lcsp_parent | string |  |
| slcsp | string |  |
| slcsp_ehb | string |  |
| slcsp_plan | string |  |
| slcsp_parent | string |  |
| slcsp_listrank | string |  |
| lcsp_plan | string |  |
| n_parents | string |  |
| low_bronze | string |  |
| low_bronze_plan | string |  |
| low_gold | string |  |
| low_gold_plan | string |  |
| partial_plans | string |  |
| source | string |  |

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