# States M8 Federal reports + payments: vw_medicaid_mcpar_pdf_source_2025_v1

`medicare_semantic.vw_medicaid_mcpar_pdf_source_2025_v1` · State programs · status partial · 120 rows

Medicaid product M8 (Federal reports + payments) of the States lane: federal Medicaid managed care reports by plan (MCPAR 2025 responses, plan MLR). vw_medicaid_mcpar_plan_pdf_2025_v1: one row per plan x MCPAR question as printed (response_raw; response_numeric when it parses); filter question_number. vw_medicaid_mcpar_pdf_source_2025_v1 is its locator: one row per state x program PDF (source_url, sha256_content_hash, source_pages); plan_table_status not_printed means the PDF prints no plan table, so that program has no plan rows, never zero plans. vw_medicaid_mlr_plan_v1: one row per plan x reporting period; adjusted_mlr_printed is the state's printed ratio, never recompute it from the numerator and denominator. 44 state(s): AL AR AZ CA CO DC FL GA HI IA ID IL IN KS KY LA MA MD MI MN MO MS MT NC ND NE NH NJ NM NV OH OK PA PR RI SC TX UT VA VT WA WI WV WY.

**Grain.** Federal Medicaid managed care reports by plan (MCPAR 2025 responses, plan MLR). 120 rows (Athena, 2026-10-30).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| program_label | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_pages | int |  |
| plan_count | int |  |
| plan_response_rows | int |  |
| prior_auth_indicator_rows | int |  |
| plan_table_status | string |  |

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