State programs

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

medicare_silver.medicaid_capitation_rate_cycle_v2·partial·silver

Rows

347

Columns

History

N/A

Card

nocolumns only

Typed tools

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_v2.
4A Vlada cross-state layer read from 44 jurisdictions' own rate certifications, contract rate exhibits, rate schedules and CMS approval letters; for FL, NC, OH and CA it re-reads the same documents as the state's own table. v2 restates v1 whole with the served defects CAP-1..21 fixed (#3243).

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; 2347 rows in 44 jurisdictions (42 states, DC and PR), rating periods 2018-01-01 to 2027-09-30 (Athena 36a441e4); 30 duplicate keys (verify_tracker_loads --lane CAP, gates run 20261007T092022Z-92425b52).

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_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.medicaid_capitation_rate_cycle_v2 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_v2")`
Raw door	Athena (read-only via query_substrate): medicare_silver.medicaid_capitation_rate_cycle_v2 (pin state_code and the rating period; take the highest amendment_seq)
Note	Register source medicaid_capitation_v1 (w8, serve raw), repointed to v2 on 2026-10-07 after Data Tracker accepted it (#3243, 0ee0a68568: "ship it as partial"). status partial: the two source limits above. Supersedes medicare_silver.medicaid_capitation_rate_cycle_v1, kept as the rollback.

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