Insurer negotiated rates

Marketplace benchmark change, every year pair (vw_hix_benchmark_change_v1)

medicare_semantic.vw_hix_benchmark_change_v1·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The benchmark move split into repricing (last year's benchmark plan's successor: CMS's crosswalk in HealthCare.gov states, the same plan id in state-run exchanges) and re-ranking, with who held it each year and why it changed.

Grain

Key	Grain
N/A	1One row per county x (year - 1, year): 39,705 rows, 2015-2027.

Columns (34)

Column	Type	Meaning
`year`	int
`prior_year`	int
`state`	string
`county`	string
`rating_area`	string
`slcsp_prior`	double
`slcsp`	double
`chg_usd`	double
`chg_pct`	double
`bench_plan_prior`	string
`bench_parent_prior`	string
`bench_plan`	string
`bench_parent`	string
`successor_plan`	string
`successor_basis`	string
`successor_reason`	string
`successor_metal`	string
`successor_premium`	double
`successor_type`	string
`repricing_usd`	double
`reranking_usd`	double
`holder_change`	string
`lcsp_prior`	double
`lcsp`	double
`low_bronze_prior`	double
`low_bronze`	double
`low_gold_prior`	double
`low_gold`	double
`n_silver_prior`	int
`n_silver`	int
`n_parents_prior`	int
`n_parents`	int
`rating_area_changed`	boolean
`source`	string

Query it

describe_data_source(source_fqn="medicare_semantic.vw_hix_benchmark_change_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_hix_benchmark_change_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_benchmark_change_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_hix_benchmark_change_v1 (filter year and state; repricing_usd + reranking_usd = chg_usd where a successor exists)

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