# MA network intelligence: plan x NPI x listed ZIP with normalized specialty and county (2026, 2027)

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

The directory table reduced to members and normalized: one specialty per NPI from NPPES (99.96% mapped; the printed label is blank on 87% of rows), the listed ZIP's county, the best source, and whether the row is the plan's own-year list or a labelled stand-in from the other year.

**Grain.** One row per plan_year x cms_plan_id x npi x listed zip5, members only (api, printed, mpf, matched grade A/B): contract_id, plan_key (H1234-001), key_level (plan or contract), state, county_fips, NPPES entity_type and taxonomy, provider_class, specialty, adequacy_type, best_basis, year_basis (own_year | carried), plan_key_bases, sources, listings. Partitioned by dataset_id, plan_year.

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| cms_plan_id | string |  |
| plan_key | string |  |
| key_level | string |  |
| npi | string |  |
| zip5 | string |  |
| state | string |  |
| county_fips | string |  |
| entity_type | string |  |
| taxonomy_code | string |  |
| provider_class | string |  |
| specialty | string |  |
| adequacy_type | boolean |  |
| best_basis | string |  |
| year_basis | string |  |
| plan_key_bases | string |  |
| sources | string |  |
| listings | bigint |  |

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