About this Dataset

Medi-Cal Certified Eligibles Data By Month With Demographics

These files contain monthly data by county for Medi-Cal certified eligibles, by various demographics traits. The data is split out and not distributed as a single dataset for the purposes of de-identification.
Organization: State of California
Last updated: 2025-07-23T14:41:57.101224
Tags: age-groups, california-department-of-health-care-services, certified-eligible, county, delivery-system, dhcs, dual-status, enrollment, ethnicity, gender, health-care, health-plan, language, medi-cal, medicare-status, month-of-enrollment, non-dual-status, primary-language, race, sex

Tables

By Age Group And Sex, Certified Eligibles

@usgov.ca_gov_medi_cal_certified_eligibles_tables_by_county_f_6380223d.by_age_group_and_sex_certified_eligibles

353.57 KB
86025 rows
9 columns


CREATE TABLE by_age_group_and_sex_certified_eligibles (
  "month_of_eligibility" TIMESTAMP,
  "county" VARCHAR,
  "age_group" VARCHAR,
  "gender" VARCHAR,
  "total_eligibles" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR,
  "status" VARCHAR,
  "date_of_data" VARCHAR
);

By Aid Category, Certified Eligibles

@usgov.ca_gov_medi_cal_certified_eligibles_tables_by_county_f_6380223d.by_aid_category_certified_eligibles

305.01 KB
78869 rows
8 columns


CREATE TABLE by_aid_category_certified_eligibles (
  "month_of_eligibility" TIMESTAMP,
  "county" VARCHAR,
  "aid_category" VARCHAR,
  "total_eligibles" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR,
  "status" VARCHAR,
  "date_of_data" TIMESTAMP
);

By Delivery System And Plan, Certified Eligibles

@usgov.ca_gov_medi_cal_certified_eligibles_tables_by_county_f_6380223d.by_delivery_system_and_plan_certified_eligibles

244.85 KB
45035 rows
9 columns


CREATE TABLE by_delivery_system_and_plan_certified_eligibles (
  "month_of_eligibility" TIMESTAMP,
  "county" VARCHAR,
  "health_delivery_system" VARCHAR,
  "health_plan" VARCHAR,
  "total_eligibles" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR,
  "status" VARCHAR,
  "date_of_data" VARCHAR
);

By Medicare Dual Status And Age Group, Certified Eligibles

@usgov.ca_gov_medi_cal_certified_eligibles_tables_by_county_f_6380223d.by_medicare_dual_status_and_age_group_certified_eligibles

318.36 KB
78979 rows
9 columns


CREATE TABLE by_medicare_dual_status_and_age_group_certified_eligibles (
  "month_of_eligibility" TIMESTAMP,
  "county" VARCHAR,
  "dual_status" VARCHAR,
  "age_group" VARCHAR,
  "total_eligibles" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR,
  "status" VARCHAR,
  "date_of_data" VARCHAR
);

By Medicare Dual Status, Certified Eligibles

@usgov.ca_gov_medi_cal_certified_eligibles_tables_by_county_f_6380223d.by_medicare_dual_status_certified_eligibles

126.14 KB
21645 rows
8 columns


CREATE TABLE by_medicare_dual_status_certified_eligibles (
  "month_of_eligibility" TIMESTAMP,
  "county" VARCHAR,
  "dual_status" VARCHAR,
  "total_eligibles" BIGINT,
  "annotation_code" VARCHAR,
  "annotation_description" VARCHAR,
  "status" VARCHAR,
  "date_of_data" VARCHAR
);

By Primary Language, Certified Eligibles

@usgov.ca_gov_medi_cal_certified_eligibles_tables_by_county_f_6380223d.by_primary_language_certified_eligibles

564.46 KB
230929 rows
8 columns


CREATE TABLE by_primary_language_certified_eligibles (
  "month_of_eligibility" TIMESTAMP,
  "county" VARCHAR,
  "language" VARCHAR,
  "total_eligibles" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR,
  "status" VARCHAR,
  "date_of_data" VARCHAR
);

By Race/Ethnicity And Age Group, Certified Eligibles

@usgov.ca_gov_medi_cal_certified_eligibles_tables_by_county_f_6380223d.by_race_ethnicity_and_age_group_certified_eligibles

783.82 KB
255182 rows
9 columns


CREATE TABLE by_race_ethnicity_and_age_group_certified_eligibles (
  "month_of_eligibility" TIMESTAMP,
  "county" VARCHAR,
  "age_group" VARCHAR,
  "ethnicity" VARCHAR,
  "total_eligibles" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR,
  "status" VARCHAR,
  "date_of_data" VARCHAR
);

Data Dictionary - By Aid Category, Certified Eligibles

@usgov.ca_gov_medi_cal_certified_eligibles_tables_by_county_f_6380223d.data_dictionary_by_aid_category_certified_eligibles

6.29 KB
8 rows
4 columns


CREATE TABLE data_dictionary_by_aid_category_certified_eligibles (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - By Medicare Dual Status, Certified Eligibles

@usgov.ca_gov_medi_cal_certified_eligibles_tables_by_county_f_6380223d.data_dictionary_by_medicare_dual_status_certified_eligibles

6.37 KB
8 rows
4 columns


CREATE TABLE data_dictionary_by_medicare_dual_status_certified_eligibles (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - By Delivery System And Plan, Certified Eligibles

@usgov.ca_gov_medi_cal_certified_eligibles_tables_by_county_f_6380223d.n__dictionary_by_delivery_system_and_plan_certified_eligibles

5.65 KB
9 rows
4 columns


CREATE TABLE n__dictionary_by_delivery_system_and_plan_certified_eligibles (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - By Medicare Dual Status And Age Group, Certified Eligibles

@usgov.ca_gov_medi_cal_certified_eligibles_tables_by_county_f_6380223d.n__dictionary_by_medicare_dual_status_and_age_group_ce_5315e868

5.44 KB
9 rows
4 columns


CREATE TABLE n__dictionary_by_medicare_dual_status_and_age_group_ce_5315e868 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - By Race/Ethnicity And Age Group, Certified Eligibles

@usgov.ca_gov_medi_cal_certified_eligibles_tables_by_county_f_6380223d.n__dictionary_by_race_ethnicity_and_age_group_certifie_5571666e

5.46 KB
9 rows
4 columns


CREATE TABLE n__dictionary_by_race_ethnicity_and_age_group_certifie_5571666e (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

(Reference) Medi-Cal Aid Codes And Aid Code Groups

@usgov.ca_gov_medi_cal_certified_eligibles_tables_by_county_f_6380223d.n__reference_medi_cal_aid_codes_and_aid_code_groups

4.08 KB
293 rows
2 columns


CREATE TABLE n__reference_medi_cal_aid_codes_and_aid_code_groups (
  "aid_code" VARCHAR,
  "aid_code_category_desc" VARCHAR
);