# MA/Part D enrollment, CPSC county grain, every published row with the revision-3 flag

`medicare_semantic.vw_enrollment_monthly_county_v3` · Medicare Advantage, Part D, Medicaid · status live · 630,792,948 rows

CMS CPSC monthly MA and Part D enrollment at county grain over medicare_silver.enrollment_monthly_county_v4, with CMS's parent names restored as in vw_enrollment_monthly_county_v2. in_revision3_table marks the rows the revision-3 table holds (plan_id <> '', state_code present, a county code present); county_code_system says whether a row carries a FIPS code ('fips'), only an SSA code ('ssa') or none ('none').

**Grain.** One row per (contract_id, plan_id, state_code, county_fips, county_ssa, report_month): 630,792,948 rows in 243 months, 2006-07..2026-09 (2026-09: 3,398,007 rows, 3,387,662 with in_revision3_table; Athena fc666995).

| 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 |  |
| in_revision3_table | boolean |  |
| parent_org_raw_legacy | string |  |
| text_corrected | boolean |  |

Tools that read it: get_county_view, get_market_share

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