Medicare Advantage, Part D, Medicaid

MA network intelligence: 2026 -> 2027 network change per contract x health system / specialty

medicare_silver.ma_network_change_v1·partial·mart

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Who joined and left each contract's published network between 2026 and 2027, like for like (own-year lists only, ZIP3 areas listed in both years, members only), rolled to health systems through CMS's hospital affiliation and the system map, with exit / join signals where a system's listing collapsed while the rest of the network held.
2Typed door get_network_system_change.

Grain

Key	Grain
N/A	1One row per contract_id x rollup_level (all \| specialty \| system) x rollup_key: listed_2026, listed_2027, stayed, left_network, joined, keep_rate, contract_keep_rate, contract_keep_rate_2027, zip3_both_years, source_changed, signal (exit_signal \| join_signal). 2Partitioned by dataset_id.

Columns (15)

Column	Type	Meaning
`contract_id`	string
`rollup_level`	string
`rollup_key`	string
`rollup_name`	string
`listed_2026`	bigint
`listed_2027`	bigint
`stayed`	bigint
`left_network`	bigint
`joined`	bigint
`keep_rate`	double
`contract_keep_rate`	double
`contract_keep_rate_2027`	double
`zip3_both_years`	bigint
`source_changed`	boolean
`signal`	string

Query it

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

Item	Value
Typed tools that read it	get_network_system_change
Identity key	`contract_id`
Join	`how_to_join(source_fqn="medicare_silver.ma_network_change_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ma_network_change_v1 (pin dataset_id; filter rollup_level and contract_id; read source_changed before a signal)

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