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

102.95 KB
11436 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

118.07 KB
15768 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

60.91 KB
4592 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

149.38 KB
30510 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

780.39 KB
320723 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

885.55 KB
329271 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.04 MB
431475 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

548.44 KB
188450 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

156.79 KB
15087 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

137.76 KB
10808 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

152.6 KB
14329 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

88.7 KB
4540 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

58.01 KB
2712 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

52.28 KB
2028 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

61.12 KB
3067 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.73 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.42 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

13.81 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

17.79 KB
1707 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
);