Insurer negotiated rates

States K5 Ownership / affiliation / delegation: marketplace_issuer_parent_v1

medicare_silver.marketplace_issuer_parent_v1·partial·silver

Rows

8,676

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Marketplace product K5 (Ownership / affiliation / delegation) of the States lane: each Marketplace issuer's legal entity and its dated parent.
2One row per state x plan year x market x HIOS issuer.
3Pick one parent basis (canonical_parent_id_as_was or _as_now) and read parent_resolution_status; filter in_enrollment = 'true' for issuers with members.
451 state(s): AK AL AR AZ CA CO CT DC DE FL GA HI IA ID IL IN KS KY LA MA MD ME MI MN MO MS MT NC ND NE NH NJ NM NV NY OH OK OR PA RI SC SD TN TX UT VA VT WA WI WV WY.

Grain

Key	Grain
N/A	1Each Marketplace issuer's legal entity and its dated parent. 28,676 rows (Athena, 2026-10-29). 3Period 2014 to 2026 (plan_year).

Columns (42)

Column	Type	Meaning
`state_code`	string
`plan_year`	string
`market`	string
`hios_issuer_id`	string
`issuer_name_raw`	string
`in_enrollment`	string
`seen_in_sources`	string
`entity_tier`	string
`legal_entity_id`	string
`legal_entity_name`	string
`naic_company_code`	string
`domiciliary_state`	string
`state_license_number`	string
`canonical_parent_id_as_was`	string
`canonical_parent_id_as_now`	string
`parent_resolution_status`	string
`identity_effective_start`	string
`identity_effective_end`	string
`parent_effective_start`	string
`parent_effective_end`	string
`observed_as_of`	string
`date_precision`	string
`identity_source_sha256`	string
`identity_source_locator`	string
`parent_source_sha256`	string
`parent_source_locator`	string
`source_url`	string
`capture_uri`	string
`identity_s3_version_id`	string
`source_access_result`	string
`identity_edge_id`	string
`parent_edge_id`	string
`affiliation_count`	string
`delegation_count`	string
`row_sha256`	string
`parent_confidence`	string
`parent_evidence_method`	string
`parent_evidence`	string
`parent_bridge_version`	string
`naic_group_code`	string
`parent_name_as_was`	string
`parent_name_as_now`	string

Query it

describe_data_source(source_fqn="medicare_silver.marketplace_issuer_parent_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.marketplace_issuer_parent_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_silver.marketplace_issuer_parent_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.marketplace_issuer_parent_v1 (filter state_code)
Company names	`issuer_name_raw` `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

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