MA plan networks: plan year x CMS plan x NPI x listed location (2026, 2027)

What it is

1. 1The Data Tracker's plan-network build (docs/data-tracker/SERVING-HANDOFF-PLAN-NETWORKS.md): which NPIs each Medicare Advantage plan lists, from the payer's own Plan-Net API, the printed directory, a name match to NPPES, or the Medicare Plan Finder export (npi_basis), with a grade on matched rows (A name+ZIP unique, B name+state unique, N name unique nationally: name-matched, never presented as printed) and plan_key_basis saying how the row reached its CMS plan id (the publisher's own id, a network map, or the CMS crosswalk carry-back: 2027 rows carrying plan_key_basis cy2026_directory_2027_not_yet_posted: 42 contracts / 1,132,045 members at stage 21 whose 2026 directory stands in; label or exclude them).
2. 2A contract with no rows is UNCOVERED (the handoff's open-gap list), never "no network"; absence of an NPI is a claim only for a covered contract and only "not listed in the published directory".
3. 3Typed tools (get_plan_network, is_provider_in_plan, get_network_change) are proposed and start on Ben's go.

Grain

Columns (18)

Query it

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