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

`medicare_silver.medicaid_capitation_rate_cell_v2` · State programs · status partial · 53,651 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. v2 restates v1 whole with the served defects CAP-1..21 fixed (#3243): FL budgetary rates dropped, TX, SC, WV, MA, PA, LA, MS, NJ, NH labels and values as printed.

**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; 53,651 rows in 28 jurisdictions, rating periods 2018-01-01 to 2027-09-30 (Athena d6771896); 0 duplicate keys (verify_tracker_loads --lane CAP, gates run 20261007T092022Z-92425b52).

| 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_v2 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.medicaid_capitation_rate_cell_v2")` first.
