# States K6 Premium + benefit book: marketplace_sbe_slcsp_county_v1

`medicare_silver.marketplace_sbe_slcsp_county_v1` · Insurer negotiated rates · status partial · 1,738 rows

Marketplace product K6 (Premium + benefit book) of the States lane: the second-lowest-cost silver (benchmark) premium by county for state-based exchanges. One row per state x plan_year x county_fips x geo_part x age_band x route. Pick ONE route and ONE age_band before reading benchmark_premium_usd: route printed is the exchange's own printed benchmark, computed and computed_exchange are ours from its plan and rate files, and a county-year can carry two routes, so never sum or average across routes. geo_part splits a county where the exchange prices by ZIP (California; geo_zip_list). tieout_status says whether ours ties to the printed or CMS figure. HealthCare.gov states are not in this table yet; absent is not built, never no benchmark. 2 state(s): CA PA.

**Grain.** The second-lowest-cost silver (benchmark) premium by county for state-based exchanges. 1,738 rows (Athena, 2026-10-30). Period 2021 to 2027 (plan_year).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| plan_year | int |  |
| county_fips | string |  |
| county_name | string |  |
| geo_part | string |  |
| geo_zip_list | string |  |
| rating_area | string |  |
| rating_area_raw | string |  |
| age_band | string |  |
| route | string |  |
| benchmark_kind | string |  |
| premium_basis | string |  |
| ehb_pct_raw | string |  |
| ehb_basis | string |  |
| benchmark_plan_id | string |  |
| plan_id_raw | string |  |
| plan_name_raw | string |  |
| issuer_hios_id | string |  |
| issuer_name_raw | string |  |
| canonical_parent_id | string |  |
| canonical_parent_name | string |  |
| parent_valid_from | string |  |
| parent_valid_to | string |  |
| parent_review_status | string |  |
| benchmark_candidate_plan_ids | string |  |
| value_status | string |  |
| tieout_status | string |  |
| tieout_source_sha256 | string |  |
| source_id | string |  |
| document_url | string |  |
| document_sha256 | string |  |
| locator | string |  |
| fetched_at | string |  |
| not_published_locators | string |  |
| row_key | string |  |
| benchmark_premium_usd | double |  |
| benchmark_premium_low_usd | double |  |
| benchmark_premium_high_usd | double |  |
| benchmark_total_premium_usd | double |  |
| lowest_silver_premium_usd | double |  |
| tieout_value_usd | double |  |
| tieout_delta_usd | double |  |
| silver_plan_count | int |  |
| tie_count | int |  |
| includes_pediatric_dental | boolean |  |
| rank_ambiguous | boolean |  |

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