Insurer negotiated rates

Marketplace products, published CSV behind vw_hix_plan_premium_v1 (2027 state-run rows) (hix_sbe2027_state_rates_v1)

medicare_silver.hix_sbe2027_state_rates_v1·partial·silver

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The S3 CSV table that medicare_semantic.vw_hix_plan_premium_v1 (2027 state-run rows) types and serves.
2Query the view; this table exists so the products are rebuilt whole and the view can be repointed.

Grain

Key	Grain
N/A	1One row per plan x rating area x age, 2027 state-run exchanges from the states' files; every column a string (the CSV as published to S3 by products.py / materialize_ages.py).

Columns (16)

Column	Type	Meaning
`state`	string
`plan_year`	string
`issuer_name`	string
`issuer_hios_id`	string
`plan_id`	string
`plan_name`	string
`metal`	string
`on_exchange`	string
`rating_area`	string
`county_fips`	string
`age`	string
`premium`	string
`ehb_pct`	string
`source_url`	string
`source_sha256`	string
`locator`	string

Query it

describe_data_source(source_fqn="medicare_silver.hix_sbe2027_state_rates_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.hix_sbe2027_state_rates_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.hix_sbe2027_state_rates_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.hix_sbe2027_state_rates_v1 (prefer medicare_semantic.vw_hix_plan_premium_v1 (2027 state-run rows); here filter year and state as strings)
Company names	`issuer_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_silver_hix_sbe2027_state_rates_v1.md · every page in one file: /llms-full.txt