# MA/Part D enrollment, CPSC county grain, every row CMS publishes (parse revision 4)

`medicare_silver.enrollment_monthly_county_v4` · Medicare Advantage, Part D, Medicaid · status live · 630,792,948 rows

CMS CPSC (Contract/Plan/State/County) monthly MA and Part D enrollment, re-parsed from the bronze bytes the served table was built from (parse revision 4, defects CPSC-1/2/3). It keeps every row CMS publishes for a contract: blank FIPS with only an SSA code (county_code_system 'ssa'), blank State, no county code ('none'), blank Plan ID; an SSA code is never written into county_fips. Same columns as medicare_silver.enrollment_monthly_county plus county_code_system. Read it through medicare_semantic.vw_enrollment_monthly_county_v3, which adds in_revision3_table and the corrected parent names.

**Grain.** One row per (contract_id, plan_id, state_code, county_fips, county_ssa, report_month) as CMS publishes it: 630,792,948 rows in 243 months, 2006-07..2026-09, 0 duplicate native keys in every month (Tracker run 20261007T010009Z-cd1f8a6d). plan_id is '' where CMS left Plan ID blank; state_code and county_fips are NULL where CMS left them blank.

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| plan_id | string |  |
| state_code | string |  |
| county_fips | string |  |
| report_month | date |  |
| enrollment_count | int |  |
| enrollment_lower_bound | int |  |
| enrollment_upper_bound | int |  |
| suppression_reason_code | string |  |
| parent_org_raw | string |  |
| enrollment_grain_era | 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 |  |
| county_ssa | string |  |
| county_name_raw | string |  |
| county_code_system | string |  |

Tools that read it: get_county_view, get_market_share

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.enrollment_monthly_county_v4 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.enrollment_monthly_county_v4")` first.