# States M1T State-published totals: medicaid_state_monthly_total_recent_v1

`medicare_silver.medicaid_state_monthly_total_recent_v1` · State programs · status partial · 494 rows

Medicaid product M1T (State-published totals) of the States lane: each state's own published monthly Medicaid total (and its managed care total where published), read from the state's dashboards and reports. THE STATE'S OWN TOTAL, NOT CMS's: state totals run 0-22% above CMS's Medicaid + CHIP figure because they count limited-benefit groups CMS excludes (Medicare savings only, family planning, emergency); population_includes says which. Never splice a state month into the CMS monthly series; quote it as that state's own total, labeled. Filter measure (total_medicaid, total_medicaid_chip, managed_care_total): states publish different ones, so never compare two states on different measures. count_basis differs by state (first of month, month end, mid month, ever enrolled in the month); ever enrolled runs above a point-in-time count. A state or month absent is not published or not read yet, never zero. 39 state(s): AR AZ CO DC DE FL HI IA ID IL IN KS KY LA MA MD MI MN MO MS NC NH NJ NM NV NY OK OR PA RI SC TN TX UT VA VT WA WI WV.

**Grain.** Each state's own published monthly Medicaid total (and its managed care total where published), read from the state's dashboards and reports. 494 rows (Athena, 2026-10-31). Period 2026-01 to 2026-10 (observation_month).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| observation_month | string |  |
| month_start | timestamp |  |
| measure | string |  |
| enrollment_value | bigint |  |
| count_basis | string |  |
| population_includes | string |  |
| source_url | string |  |
| source_sha256 | string |  |
| source_locator | string |  |
| read_route | varchar(35) |  |
| checked_at | string |  |
| register_csv_sha256 | varchar(64) |  |
| register_path | varchar(45) |  |
| build_stamp | varchar(16) |  |

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