States M1T State-published totals: medicaid_state_monthly_total_recent_v1

What it is

1. 1Medicaid 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.
2. 2THE 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.
3. 3Never splice a state month into the CMS monthly series; quote it as that state's own total, labeled.
4. 4Filter 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.
5. 5A state or month absent is not published or not read yet, never zero.
6. 639 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

Columns (15)

Query it

describe_data_source(source_fqn="medicare_silver.medicaid_state_monthly_total_recent_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.medicaid_state_monthly_total_recent_v1 WHERE <filter> LIMIT 100")