About this Dataset

Medi-Cal Annual Renewals By County

This dataset includes information regarding annual Medi-Cal eligibility renewals conducted for beneficiaries by counties each month. The data is from the Statewide Automated Welfare System (SAWS), which determines Medi-Cal eligibility and conducts ongoing case management. The SAWS reports the number of renewals due and the renewals completed by the due date and within the renewals processing timeframe. This dataset is part of the public reporting requirements set forth in California Welfare and Institutions Code 14102.5(3) et seq.
Organization: State of California
Last updated: 2025-10-23T12:53:10.823260
Tags: abx1, california-department-of-health-care-services, california-eligibility-and-enrollment-report, dhcs, iap, insurance-affordability-programs, medi-cal, medi-cal-eligibility, medi-cal-renewals, renewals

Tables

Medi-Cal Annual Renewals By County

@usgov.ca_gov_medi_cal_annual_renewals_by_county_18fe2.medi_cal_annual_renewals_by_county

271.72 kB
10,208 rows
18 columns

CREATE TABLE medi_cal_annual_renewals_by_county (
  "year" BIGINT,
  "renewal_due_month" VARCHAR,
  "renewal_processing_timeframe" VARCHAR,
  "county" VARCHAR,
  "saws" VARCHAR,
  "eligibility_financial_method" VARCHAR,
  "renewals_due" DOUBLE,
  "renewals_completed" DOUBLE,
  "renewals_completed_by_due_date" DOUBLE,
  "continued_medi_cal_eligibility" DOUBLE,
  "n__auto_ex_parte" DOUBLE  -- Auto Ex-Parte,
  "n__manual_ex_parte" DOUBLE  -- Manual Ex-Parte,
  "discontinued_failure_to_respond" DOUBLE  -- Discontinued - Failure To Respond,
  "discontinued_over_income_magi_over_property_non_magi" DOUBLE  -- Discontinued - Over Income (MAGI) / Over Property (Non-MAGI),
  "discontinued_other_reasons" DOUBLE  -- Discontinued - Other Reasons,
  "reinstated" DOUBLE,
  "annotation_code" VARCHAR,
  "annotation_code_description" VARCHAR
);