Insurer negotiated rates

Marketplace market structure by parent and county (vw_hix_market_structure_v1)

medicare_semantic.vw_hix_market_structure_v1·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Plans by metal, cheapest silver and its rank among parents, whether the parent holds the lowest or the benchmark silver, and status against the year before (entered, continuing, exited; exited rows carry zero plans).

Grain

Key	Grain
N/A	1One row per county x parent x plan year: 133,433 rows. 2All 51 jurisdictions: HealthCare.gov states 2014-2027, state-run exchanges 2016-2027.

Columns (17)

Column	Type	Meaning
`year`	int
`state`	string
`county`	string
`rating_area`	string
`parent`	string
`issuers`	int
`plans`	int
`silver_plans`	int
`bronze_plans`	int
`gold_plans`	int
`cheapest_silver_age40`	double
`cheapest_silver_rank`	int
`parents_with_silver`	int
`holds_lcsp`	boolean
`holds_benchmark`	boolean
`status`	string
`source`	string

Query it

describe_data_source(source_fqn="medicare_semantic.vw_hix_market_structure_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_hix_market_structure_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_semantic.vw_hix_market_structure_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_hix_market_structure_v1 (filter year and state; status = 'exited' rows have no plans)

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