About this Dataset

Annual California Children’s Services Whole Child Model Summary Data

These datasets contain summary data about the Annual California Children’s Services (CCS) Whole Child Model (WCM) program. These summary files are intended to accompany the CCS Power BI Dashboard which is posted on the DHCS internet. The CCS and WCM Programs provide diagnostic and treatment services, case management, and physical and occupational therapy services to children under age 21 with CCS-eligible medical conditions. Examples of CCS-eligible conditions include, but are not limited to, chronic medical conditions such as cystic fibrosis, hemophilia, cerebral palsy, heart disease, cancer, traumatic injuries, and infectious diseases producing major sequelae.
Organization: State of California
Last updated: 2025-07-23T21:15:54.695127
Tags: age, california-childrens-service, california-department-of-health-care-services, caloptima, ccs, ccs-county, ccs-type, cencal-health, central-california-alliance-for-health, classic-ccs, dhcs, ethnicity, geography, health-plan-of-san-mateo, kaiser, medi-cal, partnership-health-plan-of-california, plan, race, sex, wcm, whole-child-model

Tables

2023 CCS WCM Summary Data, County Enrollment

@usgov.ca_gov_annual_california_childrens_services_whole_chil_e42a16ab.n_2023_ccs_wcm_summary_data_county_enrollment

51.24 kB
4,296 rows
13 columns

CREATE TABLE n_2023_ccs_wcm_summary_data_county_enrollment (
  "reporting_year" BIGINT,
  "reporting_month" VARCHAR,
  "elig_dt" TIMESTAMP,
  "month_year" VARCHAR,
  "ccs_cnty_cd_desc" VARCHAR,
  "plan_desc" VARCHAR,
  "ccs_type" VARCHAR,
  "county_status" VARCHAR,
  "non_suppressed_val" DOUBLE,
  "suppressed_val" DOUBLE,
  "data_type" VARCHAR,
  "annotation" DOUBLE,
  "annotation_desc" VARCHAR
);

2023 CCS WCM Summary Data, Demographics

@usgov.ca_gov_annual_california_childrens_services_whole_chil_e42a16ab.n_2023_ccs_wcm_summary_data_demographics

47.7 kB
2,422 rows
12 columns

CREATE TABLE n_2023_ccs_wcm_summary_data_demographics (
  "reporting_year" BIGINT,
  "reporting_month" VARCHAR,
  "elig_dt" TIMESTAMP,
  "month_year" VARCHAR,
  "ccs_type" VARCHAR,
  "dimension" VARCHAR,
  "dimension_detail" VARCHAR,
  "non_suppressed_val" DOUBLE,
  "suppressed_value" DOUBLE,
  "data_type" VARCHAR,
  "annotation" DOUBLE,
  "annotation_desc" VARCHAR
);

2023 CCS WCM Summary Data, Enrollment Trends

@usgov.ca_gov_annual_california_childrens_services_whole_chil_e42a16ab.n_2023_ccs_wcm_summary_data_enrollment_trends

28.46 kB
3,105 rows
12 columns

CREATE TABLE n_2023_ccs_wcm_summary_data_enrollment_trends (
  "reporting_year" DOUBLE,
  "reporting_month" VARCHAR,
  "elig_dt" TIMESTAMP,
  "month_year" VARCHAR,
  "plan_desc" VARCHAR,
  "ccs_cnty_cd_desc" VARCHAR,
  "ccs_type" VARCHAR,
  "distinct_cin_count" DOUBLE,
  "data_type" VARCHAR,
  "suppressed_value" DOUBLE,
  "annotation" DOUBLE,
  "annotation_desc" VARCHAR
);

2024 CCS WCM Summary Data, County Enrollment

@usgov.ca_gov_annual_california_childrens_services_whole_chil_e42a16ab.n_2024_ccs_wcm_summary_data_county_enrollment

32.52 kB
2,316 rows
13 columns

CREATE TABLE n_2024_ccs_wcm_summary_data_county_enrollment (
  "reporting_year" BIGINT,
  "reporting_month" VARCHAR,
  "elig_dt" TIMESTAMP,
  "month_year" VARCHAR,
  "ccs_cnty_cd_desc" VARCHAR,
  "plan_desc" VARCHAR,
  "ccs_type" VARCHAR,
  "county_status" VARCHAR,
  "non_suppressed_val" DOUBLE,
  "suppressed_val" DOUBLE,
  "data_type" VARCHAR,
  "annotation" DOUBLE,
  "annotation_desc" VARCHAR
);

2024 CCS WCM Summary Data, Demographics

@usgov.ca_gov_annual_california_childrens_services_whole_chil_e42a16ab.n_2024_ccs_wcm_summary_data_demographics

27.98 kB
1,212 rows
12 columns

CREATE TABLE n_2024_ccs_wcm_summary_data_demographics (
  "reporting_year" BIGINT,
  "reporting_month" VARCHAR,
  "elig_dt" TIMESTAMP,
  "month_year" VARCHAR,
  "ccs_type" VARCHAR,
  "dimension" VARCHAR,
  "dimension_detail" VARCHAR,
  "non_suppressed_val" DOUBLE,
  "suppressed_value" DOUBLE,
  "data_type" VARCHAR,
  "annotation" DOUBLE,
  "annotation_desc" VARCHAR
);

2024 CCS WCM Summary Data, Enrollment Trends

@usgov.ca_gov_annual_california_childrens_services_whole_chil_e42a16ab.n_2024_ccs_wcm_summary_data_enrollment_trends

20.37 kB
1,680 rows
12 columns

CREATE TABLE n_2024_ccs_wcm_summary_data_enrollment_trends (
  "reporting_year" DOUBLE,
  "reporting_month" VARCHAR,
  "elig_dt" TIMESTAMP,
  "month_year" VARCHAR,
  "plan_desc" VARCHAR,
  "ccs_cnty_cd_desc" VARCHAR,
  "ccs_type" VARCHAR,
  "distinct_cin_count" DOUBLE,
  "data_type" VARCHAR,
  "suppressed_value" DOUBLE,
  "annotation" DOUBLE,
  "annotation_desc" VARCHAR
);