Medicare Advantage, Part D, Medicaid

MA contract service area (revision 2)

medicare_silver.ma_contract_service_area_v2·live·silver

Rows

89,865,222

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Which counties each MA contract serves each month, from CMS's monthly contract service area file, with organization_name, plan_type, the EGHP (employer-only) flag and the partial-county flag as CMS prints them, and national_service_area for nationwide contracts (National PACE and similar).

Grain

Key	Grain
N/A	1One row per (contract_id, county, flag variant) per month: 89,865,222 rows in 239 months. 2A contract-county CMS splits across flag values appears on more than one row (3,788 split rows); national service-area rows have no county or state.

Columns (22)

Column	Type	Meaning
`contract_id`	string
`county_fips`	string
`county_ssa`	string
`state_code`	string
`report_month`	date
`organization_name_raw`	string
`organization_type`	string
`plan_type`	string
`partial_county`	boolean
`eghp`	boolean
`county_name_raw`	string
`notes_raw`	string
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`national_service_area`	boolean

Query it

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

Item	Value
Typed tools that read it	get_contract_service_area
Identity key	`contract_id`
Join	`how_to_join(source_fqn="medicare_silver.ma_contract_service_area_v2")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ma_contract_service_area_v2
Company names	`organization_name_raw` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Restated v2 (Data Tracker parse-loss lane, 2026-10-06); supersedes medicare_silver.ma_contract_service_area. Served by get_contract_service_area 0.2.0 (registered 2026-10-06; vlada.supersedes_revision_1 set 2026-10-06). Never overwritten; a changed schema is a new version.

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