Insurer negotiated rates

Marketplace plans sold in each county (vw_hix_plan_county_v1)

medicare_semantic.vw_hix_plan_county_v1·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Every plan the engine found on sale in each county, from the same source as the county's benchmark.

Grain

Key	Grain
N/A	1One row per plan x county x plan year: rating area, issuer, parent, metal, age-40 premium at list and EHB. 21,538,783 rows. 3All 51 jurisdictions: HealthCare.gov states 2014-2027, state-run exchanges 2016-2027.

Columns (11)

Column	Type	Meaning
`year`	int
`state`	string
`county`	string
`rating_area`	string
`plan_id`	string
`issuer_id`	string
`parent`	string
`metal`	string
`premium_age40`	double
`premium_ehb_age40`	double
`source`	string

Query it

describe_data_source(source_fqn="medicare_semantic.vw_hix_plan_county_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_hix_plan_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_semantic.vw_hix_plan_county_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_hix_plan_county_v1 (filter year and state; aggregate in SQL)

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