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

`medicare_silver.ma_network_plan_hospital_v1` · Medicare Advantage, Part D, Medicaid · status partial

Which 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. Typed door get_plan_hospitals.

**Grain.** One 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. Partitioned by dataset_id, plan_year.

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

Tools that read it: get_plan_hospitals

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