About this Dataset

Health & Human Services Program Counts - Dashboard & Record Reconciliation

Introduction

California Health and Human Services (CalHHS) single and multi-program participation counts with demographics by year and geography, both the Annual (cumulative) and July (point in time) files. The data dictionary for each file is loaded as a resource within the CSV preview page.

Background

The CalHHS Program Data and Dashboard contain participation data related to seven California Health & Human Services agency programs: CalWORKs, CalFresh, In-Home Supportive Services, Foster Care, Medi-Cal (California Medicaid), Women, Infants, & Children, and Developmental Services. Users are able to view these data at the county level or by legislative district level (U.S. Congress, State Assembly, State Senate). Statistics on persons served, persons per case, average grant amount, and basic demographics are presented in both tabular spreadsheets and customizable visualizations by program. In addition to presenting statistics for each program separately, the dashboard also provides data on the number of individuals participating in more than one program at the same time in a given district or county.

Methodology

The Children's Data Network has prepared a methodology document for the process involved in creating this data. If you would like to review the methodology used, please click the link below to visit the CalHHS Records Reconciliation Methodology. https://data.chhs.ca.gov/pages/calhhs-program-counts-methodology

Organization: State of California
Last updated: 2025-07-23T21:40:55.274483
Tags: aca, affordable-care-act-expansion, calfresh, california-health-and-human-services-agency, calworks, child-protective-services, child-welfare, dds, developmental-services, family-pact, familyplanning-access-care-and-treatment, foster-care, ihss, in-home-supportive-services, medi-cal, medicaid, snap, tanf, wic, woman-infants-and-children

Tables

Data Dictionary - Record Reconciliation 2015-2021: Annual Data File

@usgov.ca_gov_health_human_services_program_counts_dashboard__c67eb299.n__dictionary_reconciliation_2015_2021_annual

6.99 kB
63 rows
4 columns

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

Data Dictionary - Record Reconciliation 2015-2021: Annual Masking Key

@usgov.ca_gov_health_human_services_program_counts_dashboard__c67eb299.n__dictionary_reconciliation_2015_2021_annual_masking_key

3.93 kB
63 rows
4 columns

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

Data Dictionary - Record Reconciliation 2015-2021: July Data File

@usgov.ca_gov_health_human_services_program_counts_dashboard__c67eb299.n__dictionary_reconciliation_2015_2021_july

7.03 kB
63 rows
4 columns

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

Data Dictionary - Record Reconciliation 2015-2021: July Masking Key

@usgov.ca_gov_health_human_services_program_counts_dashboard__c67eb299.n__dictionary_reconciliation_2015_2021_july_masking_key

3.93 kB
63 rows
4 columns

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

Record Reconciliation 2015-2021: Annual Data File

@usgov.ca_gov_health_human_services_program_counts_dashboard__c67eb299.record_reconciliation_2015_2021_annual_data_file

2 MB
14,797 rows
63 columns

CREATE TABLE record_reconciliation_2015_2021_annual_data_file (
  "fileyear" BIGINT,
  "program" VARCHAR,
  "level" VARCHAR,
  "number" VARCHAR,
  "person" VARCHAR,
  "cases" VARCHAR,
  "medi_cal" VARCHAR,
  "aca" VARCHAR,
  "fpact" VARCHAR,
  "calfresh" VARCHAR,
  "calworks" VARCHAR,
  "ihss" VARCHAR,
  "child_welfare" VARCHAR,
  "foster_care" VARCHAR,
  "dds" VARCHAR,
  "wic" VARCHAR,
  "black" VARCHAR,
  "white" VARCHAR,
  "hispanic" VARCHAR,
  "asian_pi" VARCHAR,
  "native_american" VARCHAR,
  "other_missing" VARCHAR,
  "female" VARCHAR,
  "male" VARCHAR,
  "unknown_other_gender" VARCHAR,
  "age1_missing" VARCHAR,
  "n_17_and_under" VARCHAR  -- 17 And Under,
  "n_18_and_over" VARCHAR  -- 18 And Over,
  "n_18_64" VARCHAR  -- 18-64,
  "n_65_and_over" VARCHAR  -- 65 And Over,
  "n_18_to_59" VARCHAR  -- 18 To 59,
  "n_60_and_over" VARCHAR  -- 60 And Over,
  "n_1_program" VARCHAR  -- 1 Program,
  "n_2_programs" VARCHAR  -- 2 Programs,
  "n_3_programs" VARCHAR  -- 3 Programs,
  "n_4_programs" VARCHAR  -- 4 Programs,
  "n_5_programs" VARCHAR  -- 5+ Programs,
  "n_1_department" VARCHAR  -- 1 Department,
  "n_2_departments" VARCHAR  -- 2 Departments,
  "n_3_departments" VARCHAR  -- 3 Departments,
  "n_4_departments" VARCHAR  -- 4 Departments,
  "fc_age_missing" VARCHAR,
  "age_0" VARCHAR,
  "n_1_to_2" VARCHAR  -- 1 To 2,
  "n_3_to_5" VARCHAR  -- 3 To 5,
  "n_6_to_10" VARCHAR  -- 6 To 10,
  "n_11_to_15" VARCHAR  -- 11 To 15,
  "n_16_to_17" VARCHAR  -- 16 To 17,
  "n_18_to_20" VARCHAR  -- 18 To 20,
  "wic_age_adult_missing" VARCHAR,
  "less_than_19" VARCHAR,
  "n_20_to_24" VARCHAR  -- 20 To 24,
  "n_25_to_29" VARCHAR  -- 25 To 29,
  "n_30_to_34" VARCHAR  -- 30 To 34,
  "n_35_and_over" VARCHAR  -- 35 And Over,
  "wic_age_child_missing" VARCHAR,
  "wic_age_0" VARCHAR,
  "wic_age_1" VARCHAR,
  "wic_age_2" VARCHAR,
  "wic_age_3" VARCHAR,
  "wic_age_4" VARCHAR,
  "wic_age_5_to_19" VARCHAR,
  "wic_age_20_and_over" VARCHAR
);

Record Reconciliation 2015-2021: Annual Masking Key

@usgov.ca_gov_health_human_services_program_counts_dashboard__c67eb299.record_reconciliation_2015_2021_annual_masking_key

78.1 kB
14,797 rows
63 columns

CREATE TABLE record_reconciliation_2015_2021_annual_masking_key (
  "fileyear" BIGINT,
  "program" VARCHAR,
  "level" VARCHAR,
  "number" VARCHAR,
  "person" VARCHAR,
  "cases" VARCHAR,
  "medi_cal" VARCHAR,
  "aca" VARCHAR,
  "fpact" VARCHAR,
  "calfresh" VARCHAR,
  "calworks" VARCHAR,
  "ihss" VARCHAR,
  "child_welfare" VARCHAR,
  "foster_care" VARCHAR,
  "dds" VARCHAR,
  "wic" VARCHAR,
  "black" VARCHAR,
  "white" VARCHAR,
  "hispanic" VARCHAR,
  "asian_pi" VARCHAR,
  "native_american" VARCHAR,
  "other_missing" VARCHAR,
  "female" VARCHAR,
  "male" VARCHAR,
  "unknown_other_gender" VARCHAR,
  "age1_missing" VARCHAR,
  "n_17_and_under" VARCHAR  -- 17 And Under,
  "n_18_and_over" VARCHAR  -- 18 And Over,
  "n_18_64" VARCHAR  -- 18-64,
  "n_65_and_over" VARCHAR  -- 65 And Over,
  "n_18_to_59" VARCHAR  -- 18 To 59,
  "n_60_and_over" VARCHAR  -- 60 And Over,
  "n_1_program" VARCHAR  -- 1 Program,
  "n_2_programs" VARCHAR  -- 2 Programs,
  "n_3_programs" VARCHAR  -- 3 Programs,
  "n_4_programs" VARCHAR  -- 4 Programs,
  "n_5_programs" VARCHAR  -- 5+ Programs,
  "n_1_department" VARCHAR  -- 1 Department,
  "n_2_departments" VARCHAR  -- 2 Departments,
  "n_3_departments" VARCHAR  -- 3 Departments,
  "n_4_departments" VARCHAR  -- 4 Departments,
  "fc_age_missing" VARCHAR,
  "age_0" VARCHAR,
  "n_1_to_2" VARCHAR  -- 1 To 2,
  "n_3_to_5" VARCHAR  -- 3 To 5,
  "n_6_to_10" VARCHAR  -- 6 To 10,
  "n_11_to_15" VARCHAR  -- 11 To 15,
  "n_16_to_17" VARCHAR  -- 16 To 17,
  "n_18_to_20" VARCHAR  -- 18 To 20,
  "wic_age_adult_missing" VARCHAR,
  "less_than_19" VARCHAR,
  "n_20_to_24" VARCHAR  -- 20 To 24,
  "n_25_to_29" VARCHAR  -- 25 To 29,
  "n_30_to_34" VARCHAR  -- 30 To 34,
  "n_35_and_over" VARCHAR  -- 35 And Over,
  "wic_age_child_missing" VARCHAR,
  "wic_age_0" VARCHAR,
  "wic_age_1" VARCHAR,
  "wic_age_2" VARCHAR,
  "wic_age_3" VARCHAR,
  "wic_age_4" VARCHAR,
  "wic_age_5_to_19" VARCHAR,
  "wic_age_20_and_over" VARCHAR
);

Record Reconciliation 2015-2021: July Data File

@usgov.ca_gov_health_human_services_program_counts_dashboard__c67eb299.record_reconciliation_2015_2021_july_data_file

1.86 MB
14,788 rows
63 columns

CREATE TABLE record_reconciliation_2015_2021_july_data_file (
  "fileyear" BIGINT,
  "program" VARCHAR,
  "level" VARCHAR,
  "number" VARCHAR,
  "person" VARCHAR,
  "cases" VARCHAR,
  "medi_cal" VARCHAR,
  "aca" VARCHAR,
  "fpact" VARCHAR,
  "calfresh" VARCHAR,
  "calworks" VARCHAR,
  "ihss" VARCHAR,
  "child_welfare" VARCHAR,
  "foster_care" VARCHAR,
  "dds" VARCHAR,
  "wic" VARCHAR,
  "black" VARCHAR,
  "white" VARCHAR,
  "hispanic" VARCHAR,
  "asian_pi" VARCHAR,
  "native_american" VARCHAR,
  "other_missing" VARCHAR,
  "female" VARCHAR,
  "male" VARCHAR,
  "unknown_other_gender" VARCHAR,
  "age1_missing" VARCHAR,
  "n_17_and_under" VARCHAR  -- 17 And Under,
  "n_18_and_over" VARCHAR  -- 18 And Over,
  "n_18_64" VARCHAR  -- 18-64,
  "n_65_and_over" VARCHAR  -- 65 And Over,
  "n_18_to_59" VARCHAR  -- 18 To 59,
  "n_60_and_over" VARCHAR  -- 60 And Over,
  "n_1_program" VARCHAR  -- 1 Program,
  "n_2_programs" VARCHAR  -- 2 Programs,
  "n_3_programs" VARCHAR  -- 3 Programs,
  "n_4_programs" VARCHAR  -- 4 Programs,
  "n_5_programs" VARCHAR  -- 5+ Programs,
  "n_1_department" VARCHAR  -- 1 Department,
  "n_2_departments" VARCHAR  -- 2 Departments,
  "n_3_departments" VARCHAR  -- 3 Departments,
  "n_4_departments" VARCHAR  -- 4 Departments,
  "fc_age_missing" VARCHAR,
  "age_0" VARCHAR,
  "n_1_to_2" VARCHAR  -- 1 To 2,
  "n_3_to_5" VARCHAR  -- 3 To 5,
  "n_6_to_10" VARCHAR  -- 6 To 10,
  "n_11_to_15" VARCHAR  -- 11 To 15,
  "n_16_to_17" VARCHAR  -- 16 To 17,
  "n_18_to_20" VARCHAR  -- 18 To 20,
  "wic_age_adult_missing" VARCHAR,
  "less_than_19" VARCHAR,
  "n_20_to_24" VARCHAR  -- 20 To 24,
  "n_25_to_29" VARCHAR  -- 25 To 29,
  "n_30_to_34" VARCHAR  -- 30 To 34,
  "n_35_and_over" VARCHAR  -- 35 And Over,
  "wic_age_child_missing" VARCHAR,
  "wic_age_0" VARCHAR,
  "wic_age_1" VARCHAR,
  "wic_age_2" VARCHAR,
  "wic_age_3" VARCHAR,
  "wic_age_4" VARCHAR,
  "wic_age_5_to_19" VARCHAR,
  "wic_age_20_and_over" VARCHAR
);

Record Reconciliation 2015-2021: July Masking Key

@usgov.ca_gov_health_human_services_program_counts_dashboard__c67eb299.record_reconciliation_2015_2021_july_masking_key

84.99 kB
14,788 rows
63 columns

CREATE TABLE record_reconciliation_2015_2021_july_masking_key (
  "fileyear" BIGINT,
  "program" VARCHAR,
  "level" VARCHAR,
  "number" VARCHAR,
  "person" VARCHAR,
  "cases" VARCHAR,
  "medi_cal" VARCHAR,
  "aca" VARCHAR,
  "fpact" VARCHAR,
  "calfresh" VARCHAR,
  "calworks" VARCHAR,
  "ihss" VARCHAR,
  "child_welfare" VARCHAR,
  "foster_care" VARCHAR,
  "dds" VARCHAR,
  "wic" VARCHAR,
  "black" VARCHAR,
  "white" VARCHAR,
  "hispanic" VARCHAR,
  "asian_pi" VARCHAR,
  "native_american" VARCHAR,
  "other_missing" VARCHAR,
  "female" VARCHAR,
  "male" VARCHAR,
  "unknown_other_gender" VARCHAR,
  "age1_missing" VARCHAR,
  "n_17_and_under" VARCHAR  -- 17 And Under,
  "n_18_and_over" VARCHAR  -- 18 And Over,
  "n_18_64" VARCHAR  -- 18-64,
  "n_65_and_over" VARCHAR  -- 65 And Over,
  "n_18_to_59" VARCHAR  -- 18 To 59,
  "n_60_and_over" VARCHAR  -- 60 And Over,
  "n_1_program" VARCHAR  -- 1 Program,
  "n_2_programs" VARCHAR  -- 2 Programs,
  "n_3_programs" VARCHAR  -- 3 Programs,
  "n_4_programs" VARCHAR  -- 4 Programs,
  "n_5_programs" VARCHAR  -- 5+ Programs,
  "n_1_department" VARCHAR  -- 1 Department,
  "n_2_departments" VARCHAR  -- 2 Departments,
  "n_3_departments" VARCHAR  -- 3 Departments,
  "n_4_departments" VARCHAR  -- 4 Departments,
  "fc_age_missing" VARCHAR,
  "age_0" VARCHAR,
  "n_1_to_2" VARCHAR  -- 1 To 2,
  "n_3_to_5" VARCHAR  -- 3 To 5,
  "n_6_to_10" VARCHAR  -- 6 To 10,
  "n_11_to_15" VARCHAR  -- 11 To 15,
  "n_16_to_17" VARCHAR  -- 16 To 17,
  "n_18_to_20" VARCHAR  -- 18 To 20,
  "wic_age_adult_missing" VARCHAR,
  "less_than_19" VARCHAR,
  "n_20_to_24" VARCHAR  -- 20 To 24,
  "n_25_to_29" VARCHAR  -- 25 To 29,
  "n_30_to_34" VARCHAR  -- 30 To 34,
  "n_35_and_over" VARCHAR  -- 35 And Over,
  "wic_age_child_missing" VARCHAR,
  "wic_age_0" VARCHAR,
  "wic_age_1" VARCHAR,
  "wic_age_2" VARCHAR,
  "wic_age_3" VARCHAR,
  "wic_age_4" VARCHAR,
  "wic_age_5_to_19" VARCHAR,
  "wic_age_20_and_over" VARCHAR
);