Medicare Advantage, Part D, Medicaid

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

medicare_silver.ma_network_provider_v1·partial·mart

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

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

Key	Grain
N/A	1One 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. 2Partitioned by dataset_id, plan_year.

Columns (18)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`npi`
Join	`how_to_join(source_fqn="medicare_silver.ma_network_provider_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ma_network_provider_v1 (pin dataset_id and plan_year; count DISTINCT npi)

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