Medicare Advantage, Part D, Medicaid

MA network intelligence: hospitals in each plan's published network, with evidence (CCN)

medicare_silver.ma_network_plan_hospital_v1·partial·mart

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Which hospitals each plan's directory puts in network: the hospital's own NPI listed (CMS hospital enrollment NPI = CCN), or how many of the clinicians CMS records as affiliated with it the plan lists (CMS Doctors and Clinicians, 2026-05-29), with the health system.
2Typed door get_plan_hospitals.

Grain

Key	Grain
N/A	1One row per plan_year x plan_key x hospital CCN with any evidence: facility_npi_listed, clinicians_listed, clinicians_affiliated, clinician_share, signal (hospital_npi_listed \| many_affiliated_clinicians \| few_affiliated_clinicians), hospital name, state, county, system_id, system_name, in_service_area, carried. 2Partitioned by dataset_id, plan_year.

Columns (15)

Column	Type	Meaning
`plan_key`	string
`contract_id`	string
`ccn`	string
`hospital_name`	string
`hospital_state`	string
`hospital_county_fips`	string
`system_id`	string
`system_name`	string
`facility_npi_listed`	boolean
`clinicians_listed`	bigint
`clinicians_affiliated`	bigint
`clinician_share`	double
`signal`	string
`in_service_area`	boolean
`carried`	boolean

Query it

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

Item	Value
Typed tools that read it	get_plan_hospitals
Identity key	`ccn`
Join	`how_to_join(source_fqn="medicare_silver.ma_network_plan_hospital_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ma_network_plan_hospital_v1 (pin dataset_id and plan_year; read signal before calling a hospital in network)

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