Medicare Advantage, Part D, Medicaid

MA and PDP Plan Directories (contract roster), 2007-2026

medicare_silver.fact_plan_directory_contract·live·silver

Rows

59,963

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS's monthly contract roster: every MA, cost, PACE, MSA, PFFS, demo and LI NET contract (directory 'ma') and every PDP contract ('pdp'), with legal entity, parent organization, org and plan type, tax status, region, enrollment, address and directory contact.
22026-09: 923 MA and 48 PDP contracts.

Grain

Key	Grain
N/A	1One row per contract per edition (an edition = one distinct data member, by SHA-256, of one directory for one report month).

Columns (55)

Column	Type	Meaning
`directory`	string
`report_month`	date
`edition`	string
`row_seq`	int
`contract_id`	string
`enrollment_count`	int
`contract_effective_date`	date
`source_member`	string
`source_member_sha256`	string
`capture_origin`	string
`captured_at`	string
`wayback_raw_url`	string
`legal_entity_name`	string
`organization_marketing_name`	string
`organization_type`	string
`plan_type`	string
`contract_effective_date_raw`	string
`tax_status`	string
`parent_organization`	string
`cms_region_responsible`	string
`enrollment_raw`	string
`legal_entity_street`	string
`legal_entity_street2`	string
`legal_entity_city`	string
`legal_entity_state_code`	string
`legal_entity_zip`	string
`directory_contact_title`	string
`directory_contact_last_name`	string
`directory_contact_first_name`	string
`directory_contact_middle_initial`	string
`directory_contact_phone`	string
`directory_contact_phone_ext`	string
`directory_contact_fax`	string
`directory_contact_email`	string
`directory_contact_street_address`	string
`directory_contact_street_address2`	string
`directory_contact_city`	string
`directory_contact_state`	string
`directory_contact_zip`	string
`directory_contact_last_update_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
`source_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`edition,row_seq`
Join	`how_to_join(source_fqn="medicare_silver.fact_plan_directory_contract")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_plan_directory_contract
Company names	`organization_marketing_name` `parent_organization` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Register source cms_ma_plan_directory (w3, serve raw). RAW. Loaded 2026-09-29 (verify_tracker_loads PASS 2026-09-30: 59,963 rows = 148 editions, 0 duplicate (edition, row_seq), one current edition per (directory, report_month); Athena b8dae91c, 5b483a4c, ef7be724). Cell reconciliation PASS on the oldest and newest MA and PDP editions and the 2008-09 era. The PDP directory is registered here (one table cannot have two register owners); its record cms_pdp_plan_directory points to this source. Registered 2026-09-30.

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