# Marketplace issuer-to-parent bridge (effective-dated, as-was and as-now)

`medicare_silver.marketplace_issuer_parent_bridge_v1` · Insurer negotiated rates · status live · 8,676 rows

HIOS issuer -> legal entity (NAIC company code, EIN) -> NAIC group -> canonical parent id, from exact MLR/PA identity joins plus a reviewed year-ranged seed (never fuzzy); dated M&A (Aetna/CVS, Health Net, WellCare, Meridian, Fidelis -> Centene, Point32Health, AvMed -> Sentara) in two views, as it was and restated to today.

**Grain.** One row per (business_year, state_code, hios_issuer_id) seen in the Marketplace enrollment, Plan Attributes, risk-adjustment or rate-review sources; BY2014-2026, 8,676 rows when built.

| column | type | meaning |
|---|---|---|
| business_year | int |  |
| state_code | string |  |
| hios_issuer_id | string |  |
| valid_from | date |  |
| valid_to | date |  |
| exchange_platform | string |  |
| in_enrollment | boolean |  |
| seen_in_sources | string |  |
| entity_tier | string |  |
| identity_source_year | int |  |
| identity_year_distance | int |  |
| naic_company_code | string |  |
| federal_ein | string |  |
| legal_entity_name | string |  |
| dba_marketing_name | string |  |
| naic_group_code | string |  |
| naic_group_name_as_filed | string |  |
| mlr_template_id | string |  |
| mlr_templates_for_hios_year | bigint |  |
| pa_tin | string |  |
| issuer_display_name | string |  |
| parent_rule | string |  |
| resolution_status | string |  |
| parent_id_as_was | string |  |
| parent_name_as_was | string |  |
| parent_id_as_now | string |  |
| parent_name_as_now | string |  |
| parent_kind | string |  |
| brand_family | string |  |
| parent_id_in_ma_alias | boolean |  |
| seed_key_type | string |  |
| seed_key_value | string |  |
| seed_valid_from_year | int |  |
| seed_valid_to_year | int |  |
| evidence_method | string |  |
| evidence | string |  |
| confidence | string |  |
| bridge_version | string |  |
| seed_sha256 | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.marketplace_issuer_parent_bridge_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.marketplace_issuer_parent_bridge_v1")` first.