Medicare Advantage, Part D, Medicaid

PDP Contract Service Area by State/County, 2007-2026

medicare_silver.pdp_contract_service_area·live·silver

Rows

47,691,967

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Every county each stand-alone PDP (S) and employer direct PDP (E) contract is approved to serve, monthly since 2007-01, with the employer-group-only and partial-county flags.
22026-09: 151,719 rows, 48 contracts, eghp TRUE on 134,095.

Grain

Key	Grain
N/A	1One row per (contract_id, county_fips, county_ssa, county_name_raw, state_code, report_month).

Columns (21)

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

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id,county_fips,county_ssa,county_name_raw,state_code,report_month`
Join	`how_to_join(source_fqn="medicare_silver.pdp_contract_service_area")`
Raw door	Athena (read-only via query_substrate): medicare_silver.pdp_contract_service_area
Company names	`organization_name_raw` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Register source cms_pdp_contract_service_area (w3, serve raw). RAW. Loaded 2026-09-29 (verify_tracker_loads PASS 2026-09-30: 47,691,967 rows, 234 months, 0 duplicate keys, 0 lineage nulls; Athena 91e03c49, 0599e4b1, 2fad6b1f). Cell reconciliation PASS 2007-01, 2025-01 (CT regions), 2026-09. Registered 2026-09-30.

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