About this Dataset

MHS Dashboard Children And Youth Demographic Datasets

The following datasets are based on the children and youth (under age 21) beneficiary population and consist of aggregate Mental Health Service data derived from Medi-Cal claims, encounter, and eligibility systems. These datasets were developed in accordance with California Welfare and Institutions Code (WIC) § 14707.5 (added as part of Assembly Bill 470 on 10/7/17). Please contact BHData@dhcs.ca.gov for any questions or to request previous years’ versions of these datasets. Note: The Performance Dashboard AB 470 Report Application Excel tool development has been discontinued. Please see the Behavioral Health reporting data hub at https://behavioralhealth-data.dhcs.ca.gov/ for access to dashboards utilizing these datasets and other behavioral health data.
Organization: State of California
Last updated: 2023-10-29T20:57:25.969711
Tags: california-department-of-health-care-services, cyouth, mhs

Tables

Children And Youth Demographics By Age Group

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_demographics_by_age_group

105.42 kB
11,436 rows
11 columns

CREATE TABLE children_and_youth_demographics_by_age_group (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "age_grp" VARCHAR,
  "total_ct" DOUBLE,
  "total_ct_annot" DOUBLE,
  "mhs1_ct" DOUBLE,
  "mhs1_ct_annot" DOUBLE,
  "mhs5_ct" DOUBLE,
  "mhs5_ct_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Children And Youth Demographics By Race Group

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_demographics_by_race_group

120.9 kB
15,768 rows
11 columns

CREATE TABLE children_and_youth_demographics_by_race_group (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "race_grp" VARCHAR,
  "total_ct" DOUBLE,
  "total_ct_annot" DOUBLE,
  "mhs1_ct" DOUBLE,
  "mhs1_ct_annot" DOUBLE,
  "mhs5_ct" DOUBLE,
  "mhs5_ct_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Children And Youth Demographics By Sex

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_demographics_by_sex

62.37 kB
4,592 rows
11 columns

CREATE TABLE children_and_youth_demographics_by_sex (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "sex" VARCHAR,
  "total_ct" DOUBLE,
  "total_ct_annot" DOUBLE,
  "mhs1_ct" DOUBLE,
  "mhs1_ct_annot" DOUBLE,
  "mhs5_ct" DOUBLE,
  "mhs5_ct_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Children And Youth Demographics By Written Language

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_demographics_by_written_language

152.96 kB
30,510 rows
11 columns

CREATE TABLE children_and_youth_demographics_by_written_language (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "wlang_desc" VARCHAR,
  "total_ct" DOUBLE,
  "total_ct_annot" DOUBLE,
  "mhs1_ct" DOUBLE,
  "mhs1_ct_annot" DOUBLE,
  "mhs5_ct" DOUBLE,
  "mhs5_ct_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Children And Youth Mental Health Services Utilization By Written Language

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_mental_health_services_utilization__31bda810

799.12 kB
320,723 rows
9 columns

CREATE TABLE children_and_youth_mental_health_services_utilization__31bda810 (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "wlang_desc" VARCHAR,
  "svc_desc" VARCHAR,
  "unit_type" VARCHAR,
  "amount" DOUBLE,
  "amount_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Children And Youth Mental Health Services Utilization By Age Group

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_mental_health_services_utilization__60d82178

906.8 kB
329,271 rows
9 columns

CREATE TABLE children_and_youth_mental_health_services_utilization__60d82178 (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "age_grp" VARCHAR,
  "svc_desc" VARCHAR,
  "unit_type" VARCHAR,
  "amount" DOUBLE,
  "amount_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Children And Youth Mental Health Services Utilization By Race Group

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_mental_health_services_utilization__9c0ddca6

1.09 MB
431,475 rows
9 columns

CREATE TABLE children_and_youth_mental_health_services_utilization__9c0ddca6 (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "race_grp" VARCHAR,
  "svc_desc" VARCHAR,
  "unit_type" VARCHAR,
  "amount" DOUBLE,
  "amount_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Children And Youth Mental Health Services Utilization By Sex

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_mental_health_services_utilization_by_sex

561.61 kB
188,450 rows
9 columns

CREATE TABLE children_and_youth_mental_health_services_utilization_by_sex (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "sex" VARCHAR,
  "svc_desc" VARCHAR,
  "unit_type" VARCHAR,
  "amount" DOUBLE,
  "amount_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Children And Youth Snapshot By Written Language

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_snapshot_by_written_language

160.56 kB
15,087 rows
19 columns

CREATE TABLE children_and_youth_snapshot_by_written_language (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "wlang_desc" VARCHAR,
  "arrivals_ct" DOUBLE,
  "arrivals_ct_annot" DOUBLE,
  "svc_cont_2yr_ct" DOUBLE,
  "svc_cont_2yr_ct_annot" DOUBLE,
  "svc_cont_ct" DOUBLE,
  "svc_cont_ct_annot" DOUBLE,
  "exiting_ct" DOUBLE,
  "exiting_ct_annot" DOUBLE,
  "arriving_and_exit_ct" DOUBLE,
  "arriving_and_exit_ct_annot" DOUBLE,
  "svc_cont_and_exit_ct" DOUBLE,
  "svc_cont_and_exit_ct_annot" DOUBLE,
  "total_ct" DOUBLE,
  "total_ct_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Children And Youth Snapshot Report By Age Group

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_snapshot_report_by_age_group

141.07 kB
10,808 rows
19 columns

CREATE TABLE children_and_youth_snapshot_report_by_age_group (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "age_grp" VARCHAR,
  "arrivals_ct" DOUBLE,
  "arrivals_ct_annot" DOUBLE,
  "svc_cont_2yr_ct" DOUBLE,
  "svc_cont_2yr_ct_annot" DOUBLE,
  "svc_cont_ct" DOUBLE,
  "svc_cont_ct_annot" DOUBLE,
  "exiting_ct" DOUBLE,
  "exiting_ct_annot" DOUBLE,
  "arriving_and_exit_ct" DOUBLE,
  "arriving_and_exit_ct_annot" DOUBLE,
  "svc_cont_and_exit_ct" DOUBLE,
  "svc_cont_and_exit_ct_annot" DOUBLE,
  "total_ct" DOUBLE,
  "total_ct_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Children And Youth Snapshot Report By Race Group

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_snapshot_report_by_race_group

156.26 kB
14,329 rows
19 columns

CREATE TABLE children_and_youth_snapshot_report_by_race_group (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "race_grp" VARCHAR,
  "arrivals_ct" DOUBLE,
  "arrivals_ct_annot" DOUBLE,
  "svc_cont_2yr_ct" DOUBLE,
  "svc_cont_2yr_ct_annot" DOUBLE,
  "svc_cont_ct" DOUBLE,
  "svc_cont_ct_annot" DOUBLE,
  "exiting_ct" DOUBLE,
  "exiting_ct_annot" DOUBLE,
  "arriving_and_exit_ct" DOUBLE,
  "arriving_and_exit_ct_annot" DOUBLE,
  "svc_cont_and_exit_ct" DOUBLE,
  "svc_cont_and_exit_ct_annot" DOUBLE,
  "total_ct" DOUBLE,
  "total_ct_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Children And Youth Snapshot Report By Sex

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_snapshot_report_by_sex

90.83 kB
4,540 rows
19 columns

CREATE TABLE children_and_youth_snapshot_report_by_sex (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "sex" VARCHAR,
  "arrivals_ct" DOUBLE,
  "arrivals_ct_annot" DOUBLE,
  "svc_cont_2yr_ct" DOUBLE,
  "svc_cont_2yr_ct_annot" DOUBLE,
  "svc_cont_ct" DOUBLE,
  "svc_cont_ct_annot" DOUBLE,
  "exiting_ct" DOUBLE,
  "exiting_ct_annot" DOUBLE,
  "arriving_and_exit_ct" DOUBLE,
  "arriving_and_exit_ct_annot" DOUBLE,
  "svc_cont_and_exit_ct" DOUBLE,
  "svc_cont_and_exit_ct_annot" DOUBLE,
  "total_ct" DOUBLE,
  "total_ct_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Children And Youth Time To Step Down By Age Group

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_time_to_step_down_by_age_group

59.41 kB
2,712 rows
18 columns

CREATE TABLE children_and_youth_time_to_step_down_by_age_group (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "age_grp" VARCHAR,
  "less7_ct" DOUBLE,
  "less7_ct_annot" DOUBLE,
  "between_8and30_ct" DOUBLE,
  "between_8and30_ct_annot" DOUBLE,
  "more30_ct" DOUBLE,
  "more30_ct_annot" DOUBLE,
  "no_step_ct" DOUBLE,
  "no_step_ct_annot" DOUBLE,
  "min_days" DOUBLE,
  "max_days" DOUBLE,
  "mean_days" DOUBLE,
  "median_days" DOUBLE,
  "bene_count" DOUBLE,
  "bene_count_annot" DOUBLE
);

Children And Youth Time To Step Down By Sex

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_time_to_step_down_by_sex

53.53 kB
2,028 rows
18 columns

CREATE TABLE children_and_youth_time_to_step_down_by_sex (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "sex" VARCHAR,
  "less7_ct" DOUBLE,
  "less7_ct_annot" DOUBLE,
  "between_8and30_ct" DOUBLE,
  "between_8and30_ct_annot" DOUBLE,
  "more30_ct" DOUBLE,
  "more30_ct_annot" DOUBLE,
  "no_step_ct" DOUBLE,
  "no_step_ct_annot" DOUBLE,
  "min_days" DOUBLE,
  "max_days" DOUBLE,
  "mean_days" DOUBLE,
  "median_days" DOUBLE,
  "bene_count" DOUBLE,
  "bene_count_annot" DOUBLE
);

Children And Youth Time To Step Down By Written Language

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.children_and_youth_time_to_step_down_by_written_language

62.59 kB
3,067 rows
18 columns

CREATE TABLE children_and_youth_time_to_step_down_by_written_language (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "wlang_desc" VARCHAR,
  "less7_ct" DOUBLE,
  "less7_ct_annot" DOUBLE,
  "between_8and30_ct" DOUBLE,
  "between_8and30_ct_annot" DOUBLE,
  "more30_ct" DOUBLE,
  "more30_ct_annot" DOUBLE,
  "no_step_ct" DOUBLE,
  "no_step_ct_annot" DOUBLE,
  "min_days" DOUBLE,
  "max_days" DOUBLE,
  "mean_days" DOUBLE,
  "median_days" DOUBLE,
  "bene_count" DOUBLE,
  "bene_count_annot" DOUBLE
);

Statewide Top 10 ICD10 Diagnosis Code Categories For Children And Youth By Sex

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.statewide_top_10_icd10_diagnosis_code_categories_for_c_1d486dc1

8.94 kB
160 rows
8 columns

CREATE TABLE statewide_top_10_icd10_diagnosis_code_categories_for_c_1d486dc1 (
  "fiscal_year" BIGINT,
  "sex" VARCHAR,
  "dx_top10_desc" VARCHAR,
  "mhs1_ct" BIGINT,
  "mhs1_ct_annot" VARCHAR,
  "mhs5_ct" BIGINT,
  "mhs5_ct_annot" VARCHAR,
  "medi_cal_delivery_system" VARCHAR
);

Statewide Top 10 ICD10 Diagnosis Code Categories For Children And Youth By Age Group.

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.statewide_top_10_icd10_diagnosis_code_categories_for_c_1e742c94

12.72 kB
400 rows
8 columns

CREATE TABLE statewide_top_10_icd10_diagnosis_code_categories_for_c_1e742c94 (
  "fiscal_year" BIGINT,
  "age_grp" VARCHAR,
  "dx_top10_desc" VARCHAR,
  "mhs1_ct" BIGINT,
  "mhs1_ct_annot" VARCHAR,
  "mhs5_ct" DOUBLE,
  "mhs5_ct_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Statewide Top 10 ICD10 Diagnosis Code Categories For Children And Youth By Race Group

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.statewide_top_10_icd10_diagnosis_code_categories_for_c_805325e2

14.14 kB
560 rows
8 columns

CREATE TABLE statewide_top_10_icd10_diagnosis_code_categories_for_c_805325e2 (
  "fiscal_year" BIGINT,
  "race_grp" VARCHAR,
  "dx_top10_desc" VARCHAR,
  "mhs1_ct" BIGINT,
  "mhs1_ct_annot" VARCHAR,
  "mhs5_ct" DOUBLE,
  "mhs5_ct_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);

Statewide Top 10 ICD10 Diagnosis Code Categories For Children And Youth By Written Language

@usgov.ca_gov_mhs_dashboard_children_and_youth_demographic_da_7878ba17.statewide_top_10_icd10_diagnosis_code_categories_for_c_9cb8f742

18.22 kB
1,707 rows
8 columns

CREATE TABLE statewide_top_10_icd10_diagnosis_code_categories_for_c_9cb8f742 (
  "fiscal_year" BIGINT,
  "wlang_desc" VARCHAR,
  "dx_top10_desc" VARCHAR,
  "mhs1_ct" DOUBLE,
  "mhs1_ct_annot" DOUBLE,
  "mhs5_ct" DOUBLE,
  "mhs5_ct_annot" DOUBLE,
  "medi_cal_delivery_system" VARCHAR
);