State programs

States M8 Federal reports + payments: vw_medicaid_mlr_plan_v1

medicare_semantic.vw_medicaid_mlr_plan_v1·partial·semantic_view

Rows

1,926

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

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.
223 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

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

Columns (21)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_mlr_plan_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_medicaid_mlr_plan_v1 (filter state_code)

This page as markdown: /docs-md/data/medicare_semantic_vw_medicaid_mlr_plan_v1.md · every page in one file: /llms-full.txt