Medi-Cal Managed Care Capitation Rates By Managed Care Plan Models
State of California
@usgov.ca_gov_medi_cal_managed_care_capitation_rates_by_manag_8b8d23b3
State of California
@usgov.ca_gov_medi_cal_managed_care_capitation_rates_by_manag_8b8d23b3
The datasets contain reimbursement rates paid to participating County Organized Health Systems, Geographic Managed Care, Regional, Senior Care Act (SCAN), Single Plan, and Two-Plan model counties as well as Program of All-Inclusive Care for the Elderly (PACE) organizations for calendar years 2021-2024.
Organization: State of California
Last updated: 2025-09-23T12:40:26.947134
Tags: california-department-of-health-care-services, capitation-rates, cohs, dhcs, gmc-rates, managed-care, pace-rates, plan-models, regional-model-rates, scan, single-plan, two-plan-rates
CREATE TABLE county_organized_health_systems_cohs_model (
"rating_period" VARCHAR,
"calendar_year" BIGINT,
"model" VARCHAR,
"county" VARCHAR,
"health_plan" VARCHAR,
"category_of_aid" VARCHAR,
"lower_bound" VARCHAR,
"midpoint" VARCHAR,
"upper_bound" VARCHAR
);CREATE TABLE data_dictionary_county_organized_health_systems_cohs_model (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);CREATE TABLE data_dictionary_geographic_managed_care_gmc (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);CREATE TABLE data_dictionary_regional_model_rural_expansion (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);CREATE TABLE data_dictionary_senior_care_action_network_scan (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);CREATE TABLE data_dictionary_single_plan_model (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);CREATE TABLE data_dictionary_two_plan_model (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);CREATE TABLE geographic_managed_care_gmc (
"rate_period" VARCHAR,
"calendar" BIGINT,
"model" VARCHAR,
"county" VARCHAR,
"health_plan" VARCHAR,
"category_of_aid" VARCHAR,
"lower_bound" VARCHAR,
"midpoint" VARCHAR,
"upper_bound" VARCHAR
);CREATE TABLE n__dictionary_program_of_all_inclusive_care_for_the_el_072cd073 (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);CREATE TABLE program_of_all_inclusive_care_for_the_elderly_pace_rates (
"rating_period" VARCHAR,
"calendar_year" BIGINT,
"model" VARCHAR,
"county" VARCHAR,
"pace_organization" VARCHAR,
"category_of_aid" VARCHAR,
"lower_bound" VARCHAR,
"midpoint" VARCHAR,
"upper_bound" VARCHAR,
"awop" VARCHAR
);CREATE TABLE regional_model_rural_expansion (
"rating_period" VARCHAR,
"calendar_year" BIGINT,
"model" VARCHAR,
"county" VARCHAR,
"health_plan" VARCHAR,
"category_of_aid" VARCHAR,
"n__lower_bound" VARCHAR -- Lower Bound,
"n__midpoint" VARCHAR -- Midpoint,
"n__upper_bound" VARCHAR -- Upper Bound
);CREATE TABLE senior_care_action_network_scan (
"rating_period" VARCHAR,
"calendar_year" BIGINT,
"model" VARCHAR,
"county" VARCHAR,
"category_of_aid" VARCHAR,
"lower_bound" VARCHAR,
"midpoint" VARCHAR,
"upper_bound" VARCHAR
);CREATE TABLE single_plan_model (
"rating_period" VARCHAR,
"calendar_year" BIGINT,
"model" VARCHAR,
"county" VARCHAR,
"health_plan_name" VARCHAR,
"category_of_aid" VARCHAR,
"n__lower_bound" VARCHAR -- Lower Bound,
"n__upper_bound" VARCHAR -- Upper Bound
);CREATE TABLE two_plan_model (
"rating_period" VARCHAR,
"calendar_year" BIGINT,
"model" VARCHAR,
"county" VARCHAR,
"health_plan" VARCHAR,
"category_of_aid" VARCHAR,
"n__lower_bound" VARCHAR -- Lower Bound,
"n__midpoint" VARCHAR -- Midpoint,
"n__upper_bound" VARCHAR -- Upper Bound
);Anyone who has the link will be able to view this.