# Medicaid managed care capitation rates by rate cell, 28 jurisdictions (cross-state layer v1), PMPM, rating periods 2018-2027

`medicare_silver.medicaid_capitation_rate_cell_v1` · State programs · status partial · 54,981 rows

The capitation rates themselves: the per-member-per-month (PMPM) amount a state Medicaid agency pays its managed care organizations for an enrollee in each rate cell, as each state publishes it (rate certification exhibits, contract rate exhibits, rate schedules, the DHCS rate CSVs). rate_pmpm is dollars per member per month at the publisher's printed precision unless unit_raw says otherwise (kick payments are per event, e.g. per delivery). rate_kind separates final (contracted) rates from CA's actuarially sound ranges (lower_bound, midpoint, upper_bound), base rates before a named add-on or risk adjustment, and kick payments. plan, rate cell, population, region and age/sex are the publisher's own labels. Jurisdictions with cells: AZ CA DC FL GA IA ID IN LA MA MS NC NE NH NJ NV OH OK OR PA PR SC TX UT VA VT WI WV; CA is 29,409 of the rows. Every row cites document_url, SHA-256 and a page/line evidence_locator; join its cycle on (state_code, program_name_raw, rating_period_start, rating_period_end, amendment_seq), where a cell may carry a sub-period of its cycle.

**Grain.** One row per published rate: the cycle key x plan_name_raw x rate_cell_raw x population_raw x region_raw x age_sex_raw x rate_kind x unit_raw; 54,981 rows in 28 jurisdictions, rating periods 2018-01-01 to 2027-09-30, 0 duplicate keys, 0 NULL rate_pmpm (Athena c54592ae; key and lineage checks verify_tracker_loads --lane CAP, cloud run 20261007T004245Z-dedf4193).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| program_name_raw | string |  |
| rating_period_start | date |  |
| rating_period_end | date |  |
| amendment_seq | int |  |
| plan_name_raw | string |  |
| rate_cell_raw | string |  |
| population_raw | string |  |
| region_raw | string |  |
| age_sex_raw | string |  |
| rate_pmpm | double |  |
| rate_kind | string |  |
| unit_raw | string |  |
| document_url | string |  |
| sha256_content_hash | string |  |
| evidence_locator | string |  |

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