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

`medicare_semantic.vw_hix_plan_premium_v1` · Insurer negotiated rates · status partial

List 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.** One row per plan x rating area x age x tobacco status x plan year, with family tiers where filed. All 51 jurisdictions: HealthCare.gov states 2014-2027, state-run exchanges 2016-2027.

| 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: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_hix_plan_premium_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_hix_plan_premium_v1")` first.