Insurer negotiated rates

Marketplace plans, every jurisdiction and year (vw_hix_plan_v1)

medicare_semantic.vw_hix_plan_v1·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Metal, plan type, network, service area, deductibles and MOOP (integrated, medical, drug), EHB share, HSA, child-only flag and the parent (parent_basis: the reviewed issuer-parent bridge, else the issuer name).

Grain

Key	Grain
N/A	1One row per plan variant x plan year (standard and cost-sharing variants), individual market, medical. 2All 51 jurisdictions: HealthCare.gov states 2014-2027, state-run exchanges 2016-2027.

Columns (28)

Column	Type	Meaning
`plan_year`	int
`state_code`	string
`issuer_id`	string
`parent_name`	string
`parent_basis`	varchar(32)
`issuer_name`	string
`plan_id`	string
`plan_variant_id`	string
`csr_variation`	string
`variant_kind`	varchar(22)
`metal_level`	string
`plan_type`	string
`plan_name`	string
`network_id`	string
`service_area_id`	string
`child_only_offering`	string
`hsa_eligible`	string
`ehb_share`	double
`deductible_integrated`	double
`deductible_medical`	double
`deductible_drug`	double
`moop_integrated`	double
`moop_medical`	double
`moop_drug`	double
`deductible_integrated_raw`	string
`moop_integrated_raw`	string
`formulary_url`	string
`source`	varchar(41)

Query it

describe_data_source(source_fqn="medicare_semantic.vw_hix_plan_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_hix_plan_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_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_hix_plan_v1 (filter plan_year and state_code; variant_kind separates standard plans from cost-sharing variants)
Company names	`issuer_name` `parent_name` 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_semantic_vw_hix_plan_v1.md · every page in one file: /llms-full.txt