Insurer negotiated rates

States K6 Premium + benefit book: marketplace_sbe_slcsp_county_v1

medicare_silver.marketplace_sbe_slcsp_county_v1·partial·silver

Rows

1,738

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Marketplace product K6 (Premium + benefit book) of the States lane: the second-lowest-cost silver (benchmark) premium by county for state-based exchanges.
2One row per state x plan_year x county_fips x geo_part x age_band x route.
3Pick 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.
4HealthCare.gov states are not in this table yet; absent is not built, never no benchmark.
52 state(s): CA PA.

Grain

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

Columns (46)

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

describe_data_source(source_fqn="medicare_silver.marketplace_sbe_slcsp_county_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.marketplace_sbe_slcsp_county_v1 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="medicare_silver.marketplace_sbe_slcsp_county_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.marketplace_sbe_slcsp_county_v1 (filter state_code)
Company names	`canonical_parent_name` `issuer_name_raw` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

This page as markdown: /docs-md/data/medicare_silver_marketplace_sbe_slcsp_county_v1.md · every page in one file: /llms-full.txt