# Marketplace plans, every jurisdiction and year (vw_hix_plan_v1)

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

Metal, 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.** One row per plan variant x plan year (standard and cost-sharing variants), individual market, medical. All 51 jurisdictions: HealthCare.gov states 2014-2027, state-run exchanges 2016-2027.

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