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

362.05 kB
86,025 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

312.33 kB
78,869 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

250.73 kB
45,035 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

326 kB
78,979 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

129.16 kB
21,645 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

578.01 kB
230,929 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

802.63 kB
255,182 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.45 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.52 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.78 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.57 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.59 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.18 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
);