State programs

Medicaid MCPAR public use file, every line of every state's Managed Care Program Annual Report (PY2023-2024)

medicare_silver.medicaid_mcpar_puf_v1·live·silver

Rows

348,338

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The MCPAR answers exactly as CMS publishes them: one line per state x program x reporting period x question x (measure number) x (plan or BSS entity) x response, across sections A (program), B (state), C1/C2 (program level), D1-D4 (plan level: enrollment, MLR, encounter data, appeals and grievances D1.IV, program integrity, prior authorization D1.XIII, quality measures, sanctions, ILOS) and E (BSS entities). response_raw is the print; response_status is number | not_applicable | optional_not_reported | not_reported | text; response_numeric only where the question is a number.
2Lineage on every row (source_url, sha256_content_hash, bronze_object_key, dataset_modified, parse_revision).

Grain

Key	Grain
N/A	1One row per publisher data line (lossless): PY2023 170,365 + PY2024 177,973 = 348,338 rows, equal to CMS's DKAN counts (Athena 572443a9; verifier row_count f142d8f1). 2(performance_year, source_row_number) is unique (dup_key 051f3962).

Columns (28)

Column	Type	Meaning
`performance_year`	int
`source_row_number`	int
`state_name`	string
`state_code`	string
`program_name_raw`	string
`reporting_period_start_raw`	string
`reporting_period_end_raw`	string
`reporting_period_start`	date
`reporting_period_end`	date
`question_number_raw`	string
`question_id`	string
`measure_number_raw`	string
`measure_number`	int
`plan_or_bss_raw`	string
`plan_or_bss_name`	string
`response_raw`	string
`response_status`	string
`response_numeric`	double
`response_seq`	int
`source_url`	string
`sha256_content_hash`	string
`bronze_object_key`	string
`s3_version_id`	string
`dataset_modified`	date
`publisher_generated_on`	date
`asserted_at`	date
`parse_revision`	int
`semantic_row_sha256`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`performance_year,source_row_number`
Join	`how_to_join(source_fqn="medicare_silver.medicaid_mcpar_puf_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.medicaid_mcpar_puf_v1 (pin performance_year, state_code and question_id)
Note	Registered 2026-10-06 with the view; the view is the customer surface for appeals, grievances and prior authorization, this table is the evidence and the door to every other MCPAR question.

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