States M8 Federal reports + payments: vw_medicaid_mcpar_pdf_source_2025_v1

What it is

1. 1Medicaid 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.
2. 244 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

Columns (9)

Query it

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