State programs

Medicaid managed care capitation rate cycle, every state (cross-state layer v1), rating periods 2018-2027

medicare_silver.medicaid_capitation_rate_cycle_v1·partial·silver

Rows

344

Columns

History

N/A

Card

nocolumns only

Typed tools

Superseded by medicare_silver.medicaid_capitation_rate_cycle_v2 (restated whole 2026-10-07, #3243, with the served defects CAP-1..21 fixed; 347 rows). This v1 table carries those defects (periods the cited document does not print, actuary firms not named as certifying, changes from an uncited workbook). Kept frozen as the rollback; never read it beside v2..

What it is

1Capitation is the fixed per-member-per-month (PMPM) payment a state Medicaid agency pays each managed care organization (MCO) for every enrollee, priced by rate cell (population, eligibility category, age/sex band, region), set for a rating period and certified as actuarially sound by an actuary.
2This table holds the rate CYCLE: one row per state x program x rating period x amendment, with the cycle basis (calendar_year, state_fiscal_year, other), certification_date, actuary_firm, the overall rate change the document itself states (percent points, with its basis in rate_change_basis_raw, never computed by us) and the document_url, SHA-256 and page/line evidence_locator behind the row.
3The published rates themselves are medicare_silver.medicaid_capitation_rate_cell_v1.
4A Vlada cross-state layer read from 44 jurisdictions' own rate certifications, contract rate exhibits and rate schedules; for FL, NC, OH and CA it re-reads the same documents as the state's own table.

Grain

Key	Grain
N/A	1One row per state_code x program_name_raw x rating_period_start x rating_period_end x amendment_seq; 2344 rows in 44 jurisdictions (42 states, DC and PR), rating periods 2018-01-01 to 2027-09-30, 0 duplicate keys (Athena c54592ae; key and lineage checks verify_tracker_loads --lane CAP, cloud run 20261007T004245Z-dedf4193).

Columns (16)

Column	Type	Meaning
`state_code`	string
`program_name_raw`	string
`program_class`	string
`rating_period_start`	date
`rating_period_end`	date
`cycle_basis`	string
`certification_date`	date
`actuary_firm`	string
`document_title`	string
`document_url`	string
`sha256_content_hash`	string
`cms_approval_date`	date
`overall_rate_change_pct_reported`	double
`rate_change_basis_raw`	string
`amendment_seq`	int
`evidence_locator`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`state_code,program_name_raw,rating_period_start,rating_period_end,amendment_seq`
Join	`how_to_join(source_fqn="medicare_silver.medicaid_capitation_rate_cycle_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.medicaid_capitation_rate_cycle_v1 (pin state_code and the rating period; take the highest amendment_seq)
Note	ROLLBACK ONLY. Superseded 2026-10-07 by medicare_silver.medicaid_capitation_rate_cycle_v2 when register source medicaid_capitation_v1 (w8) was repointed to v2 (#3243 accepted by Data Tracker); listed in that register source only as the rollback. The v1 cycle reconciliation passed 31 of 44 jurisdictions (#3108). Versioned (_v1), append-only, frozen.

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