# Marketplace county benchmark: lowest and second-lowest silver (vw_hix_county_benchmark_v1)

`medicare_semantic.vw_hix_county_benchmark_v1` · Insurer negotiated rates · status partial

The second-lowest-cost silver plan (the credit benchmark, 26 CFR 1.36B-3: ranked on the EHB premium, shown at list), the lowest silver, the lowest bronze and gold, plan ids, parents and counts.

**Grain.** One row per county x plan year at age 40: 42,896 rows. All 51 jurisdictions: HealthCare.gov states 2014-2027, state-run exchanges 2016-2027. HealthCare.gov counties match CMS's Landscape (list-ranked) 2016-2027 to the cent, 2014 within $0.01, 2015 all but 29 counties.

| column | type | meaning |
|---|---|---|
| year | int |  |
| state | string |  |
| county | string |  |
| rating_area | string |  |
| ra_mapping | string |  |
| ra_land_share | double |  |
| age | int |  |
| n_silver | int |  |
| n_issuers | int |  |
| lcsp | double |  |
| lcsp_parent | string |  |
| slcsp | double |  |
| slcsp_ehb | double |  |
| slcsp_plan | string |  |
| slcsp_parent | string |  |
| slcsp_listrank | double |  |
| lcsp_plan | string |  |
| n_parents | int |  |
| low_bronze | double |  |
| low_bronze_plan | string |  |
| low_gold | double |  |
| low_gold_plan | string |  |
| partial_plans | int |  |
| source | string |  |

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