Insurer negotiated rates

Marketplace premiums by plan, rating area and age (vw_hix_plan_premium_v1)

medicare_semantic.vw_hix_plan_premium_v1·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1List premiums from each source's own rate table; source names the file (CMS Exchange PUF, CMS state-run package, state rate file 2027, CMS rate review file 2027).

Grain

Key	Grain
N/A	1One row per plan x rating area x age x tobacco status x plan year, with family tiers where filed. 2All 51 jurisdictions: HealthCare.gov states 2014-2027, state-run exchanges 2016-2027.

Columns (18)

Column	Type	Meaning
`plan_year`	int
`state_code`	string
`plan_id`	string
`rating_area_id`	string
`age`	string
`tobacco`	string
`individual_rate`	double
`individual_tobacco_rate`	double
`couple`	double
`primary_plus_one_dependent`	double
`primary_plus_two_dependents`	double
`primary_plus_three_or_more_dependents`	double
`couple_plus_one_dependent`	double
`couple_plus_two_dependents`	double
`couple_plus_three_or_more_dependents`	double
`rate_effective_date`	string
`source`	varchar(41)
`basis`	string

Query it

describe_data_source(source_fqn="medicare_semantic.vw_hix_plan_premium_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_hix_plan_premium_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_premium_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_hix_plan_premium_v1 (filter plan_year, state_code and plan_id; read source and rate_effective_date)

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