# States M8 Federal reports + payments: vw_medicaid_mlr_plan_v1

`medicare_semantic.vw_medicaid_mlr_plan_v1` · State programs · status partial · 1,926 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. 23 state(s): AL AZ CA DE FL GA IL IN KY LA MI MO NC NJ NY OH OR PA SC TN TX VA WA.

**Grain.** Federal Medicaid managed care reports by plan (MCPAR 2025 responses, plan MLR). 1,926 rows (Athena, 2026-10-30). Period 2017 to 2022 (report_year).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| report_year | int |  |
| program_name_raw | string |  |
| program_type_raw | string |  |
| eligibility_group_raw | string |  |
| eligibility_group_other_raw | string |  |
| plan_name_raw | string |  |
| medicaid_plan_id | string |  |
| plan_match_status | string |  |
| reporting_period_start | string |  |
| reporting_period_end | string |  |
| mlr_numerator_usd | decimal(20,4) |  |
| mlr_denominator_usd | decimal(20,4) |  |
| member_months | int |  |
| adjusted_mlr_printed | decimal(20,4) |  |
| remittance_usd | decimal(20,4) |  |
| remittance_raw | string |  |
| source_url | string |  |
| source_sha256 | string |  |
| source_locator | string |  |
| source_row_number | int |  |

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