# CMS MA and PDP Enrollment by State/County/Contract (SCC), full version

`medicare_silver.ma_pdp_enrollment_by_state_county_contract_v1` · Medicare Advantage, Part D, Medicaid · status live · 143,610,809 rows

CMS's monthly enrollment by contract and the enrollee's county of residence (the payment county, not the service area), for MA (incl. 1876 Cost, HCPP, PACE, MSA, PFFS, LI NET) and stand-alone PDP contracts, with organization type and plan type per contract-county. The full version keeps the rows of 10 or fewer as suppressed cells. Heavy: pin report_month.

**Grain.** One program (MA or PDP) x contract x county of residence x report_month, as CMS prints the full SCC file. 143,610,809 rows: MA 2006-10..2026-09, PDP 2007-01..2026-09, 240 distinct months (Athena c59eb5a8, 2026-10-13).

| column | type | meaning |
|---|---|---|
| program | string |  |
| county_name | string |  |
| state_code | string |  |
| contract_id | string |  |
| organization_name | string |  |
| organization_type | string |  |
| plan_type | string |  |
| ssa_county_code | string |  |
| fips_county_code | string |  |
| ssa_county_code_raw | string |  |
| fips_county_code_raw | string |  |
| enrolled | bigint |  |
| enrolled_suppressed | boolean |  |
| enrolled_raw | string |  |
| report_month | date |  |
| file_version | string |  |
| source_member | string |  |
| source_page_url | 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: `query_substrate` with `SELECT ... FROM medicare_silver.ma_pdp_enrollment_by_state_county_contract_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.ma_pdp_enrollment_by_state_county_contract_v1")` first.