Medi-Cal Managed Care Capitation Rates – Regional Model/Rural Expansion
State of California
@usgov.ca_gov_medi_cal_managed_care_capitation_rates_regional_0637f406
State of California
@usgov.ca_gov_medi_cal_managed_care_capitation_rates_regional_0637f406
This dataset displays reimbursement rates paid to Medi-Cal Managed Care health plans in the Regional model, by State Fiscal Year. The Regional Model serves beneficiaries in 28 rural counties: Alpine, Amador, Butte, Calaveras, Colusa, Del Norte, El Dorado, Glenn, Humboldt, Inyo, Imperial, Lake, Lassen, Mariposa, Mendocino, Modoc, Mono, Nevada, Placer, Plumas, San Benito, Sierra, Siskiyou, Sutter, Tehama, Trinity, Tuolumne, and Yuba. The Department of Health Care Services (DHCS) contracts with two Commercial plans to provide services in each county. San Benito is the only exception where beneficiaries can choose either the managed care plan or (fee-for-service) Medi-Cal.
Organization: State of California
Last updated: 2023-08-25T21:30:44.672156
Tags: california-department-of-health-care-services, dhcs, managed-care-rates, medi-cal-managed-care, medi-cal-managed-care-capitation-rates, regional-model, regional-model-rates, rm, rural-expansion, rural-expansion-rate
CREATE TABLE bridge_period_2019_20_regional_model_rates (
"rating_period" VARCHAR,
"fiscal_year_bp" VARCHAR,
"model" VARCHAR,
"county" VARCHAR,
"health_plan" VARCHAR,
"category_of_aid" VARCHAR,
"lower_bound" DOUBLE,
"midpoint" DOUBLE,
"upper_bound" DOUBLE
);CREATE TABLE cy_2021_regional_model_rates (
"rating_period" VARCHAR,
"calendar_year" BIGINT,
"model" VARCHAR,
"county" VARCHAR,
"health_plan" VARCHAR,
"category_of_aid" VARCHAR,
"n__lower_bound" DOUBLE -- Lower Bound,
"n__midpoint" DOUBLE -- Midpoint,
"n__upper_bound" DOUBLE -- Upper Bound
);CREATE TABLE cy_2022_regional_model_rates (
"rating_period" VARCHAR,
"calendar_year" DOUBLE,
"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 cy_2023_regional_model_rates (
"rating_period" VARCHAR,
"calendar_year" BIGINT,
"model" VARCHAR,
"county" VARCHAR,
"health_plan_name" VARCHAR,
"category_of_aid" VARCHAR,
"lower_bound" VARCHAR,
"midpoint" VARCHAR,
"upper_bound" VARCHAR
);CREATE TABLE state_fiscal_year_2015_16_regional_model_rates (
"rating_period" VARCHAR,
"state_fiscal_year" VARCHAR,
"model" VARCHAR,
"county" VARCHAR,
"health_plan" VARCHAR,
"category_of_aid" VARCHAR,
"lower_bound" DOUBLE,
"midpoint" DOUBLE,
"upper_bound" DOUBLE,
"unnamed_9" VARCHAR -- Unnamed: 9
);CREATE TABLE state_fiscal_year_2016_17_regional_model_rates (
"rating_period" VARCHAR,
"state_fiscal_year" VARCHAR,
"model" VARCHAR,
"county" VARCHAR,
"health_plan" VARCHAR,
"category_of_aid" VARCHAR,
"lower_bound" DOUBLE,
"midpoint" DOUBLE,
"upper_bound" DOUBLE,
"unnamed_9" VARCHAR -- Unnamed: 9
);CREATE TABLE state_fiscal_year_2017_18_regional_model_rates (
"rating_period" VARCHAR,
"state_fiscal_year" VARCHAR,
"model" VARCHAR,
"county" VARCHAR,
"health_plan" VARCHAR,
"category_of_aid" VARCHAR,
"lower_bound" VARCHAR,
"midpoint" VARCHAR,
"upper_bound" VARCHAR,
"unnamed_9" VARCHAR -- Unnamed: 9
);CREATE TABLE state_fiscal_year_2018_19_regional_model_rates (
"rating_period" VARCHAR,
"state_fiscal_year" VARCHAR,
"model" VARCHAR,
"county" VARCHAR,
"health_plan" VARCHAR,
"category_of_aid" VARCHAR,
"lower_bound" VARCHAR,
"midpoint" VARCHAR,
"upper_bound" VARCHAR
);Anyone who has the link will be able to view this.