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

`medicare_silver.medicaid_mcpar_puf_v1` · State programs · status live · 348,338 rows

The 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. Lineage on every row (source_url, sha256_content_hash, bronze_object_key, dataset_modified, parse_revision).

**Grain.** One 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). (performance_year, source_row_number) is unique (dup_key 051f3962).

| 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: `query_substrate` with `SELECT ... FROM medicare_silver.medicaid_mcpar_puf_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.medicaid_mcpar_puf_v1")` first.