# Marketplace products, published CSV behind vw_hix_plan_county_v1 (2027 state-run rows) (hix_sbe2027_state_service_area_v1)

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

The S3 CSV table that medicare_semantic.vw_hix_plan_county_v1 (2027 state-run rows) 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, 2027 state-run exchanges from the states' files; every column a string (the CSV as published to S3 by products.py / materialize_ages.py).

| column | type | meaning |
|---|---|---|
| state | string |  |
| issuer_hios_id | string |  |
| issuer_name | string |  |
| plan_id | string |  |
| county_fips | string |  |
| zips | string |  |
| source_url | string |  |
| locator | string |  |

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