# MA/Part D enrollment — CPSC county grain

`medicare_silver.enrollment_monthly_county` · Medicare Advantage, Part D, Medicaid · status live

CMS CPSC (Contract/Plan/State/County) monthly MA + Part D enrollment at county grain. The substrate behind get_enrollment_trend and the MA enrollment-trend proof rail. Includes EGHP (flagged); excludes Original Medicare (FFS). County cells with <=10 enrollees are CMS-suppressed (`*`) and carried as bounds [1,10] via enrollment_lower_bound/upper_bound + suppression_reason_code='redacted_small_cell'.

**Grain.** One row per (contract_id, plan_id, state_code, county_fips, month) enrollment count.

| 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 |  |

Tools that read it: get_landscape_benefit_change, get_landscape_exits, get_stars_rollup, prove_ma_enrollment_trend

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