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

`medicare_silver.fact_plan_directory_contract` · Medicare Advantage, Part D, Medicaid · status live · 59,963 rows

CMS'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. 2026-09: 923 MA and 48 PDP contracts.

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

| 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: `query_substrate` with `SELECT ... FROM medicare_silver.fact_plan_directory_contract WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_plan_directory_contract")` first.