# States M8 Federal reports + payments: vw_medicaid_mcpar_plan_pdf_2025_v1

`medicare_semantic.vw_medicaid_mcpar_plan_pdf_2025_v1` · State programs · status partial · 40,590 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. 42 state(s): AR AZ CA CO DC FL GA HI IA ID IL IN KS KY LA MA MD MI MN MO MS 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). 40,590 rows (Athena, 2026-10-30). Period 2025 to 2025 ('2025').

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| program_label | string |  |
| question_number | string |  |
| plan_name_raw | string |  |
| response_raw | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_page | int |  |
| response_x0 | double |  |
| response_top | double |  |
| response_bottom | double |  |
| position_unit | string |  |
| extraction_method | string |  |
| response_numeric | double |  |
| source_locator | string |  |

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