Insurer negotiated rates

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

medicare_silver.marketplace_issuer_parent_bridge_v1·live·dim

Rows

8,676

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1HIOS 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

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

Columns (39)

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

describe_data_source(source_fqn="medicare_silver.marketplace_issuer_parent_bridge_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.marketplace_issuer_parent_bridge_v1 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`business_year,state_code,hios_issuer_id`
Join	`how_to_join(source_fqn="medicare_silver.marketplace_issuer_parent_bridge_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.marketplace_issuer_parent_bridge_v1
Company names	`issuer_display_name` `parent_name_as_now` `parent_name_as_was` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Built 2026-10-13 by the coordinator from pipelines/medicare/silver/marketplace_issuer_parent_bridge_v1.sql: 8,676 rows, BY2014-2026 (Athena c7481313). Registered 2026-10-13 by the Data Tracker registration lane (PR claude/tracker-registration-2026-10-13). Door RAW, World W4.

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