About this Dataset

MHS Dashboard Adult Demographic Datasets

The following datasets are based on the adult (age 21 and over) beneficiary population and consist of aggregate MHS 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-08-25T21:27:20.597975
Tags: ab470, adult, california-department-of-health-care-services, dhcs, icd10, mhs

Tables

Adult Demographics By Age Group (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_demographics_by_age_group_suppressed

126.4 kB
12,740 rows
11 columns

CREATE TABLE adult_demographics_by_age_group_suppressed (
  "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
);

Adult Demographics By Race Group (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_demographics_by_race_group_suppressed

146.52 kB
18,366 rows
11 columns

CREATE TABLE adult_demographics_by_race_group_suppressed (
  "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
);

Adult Demographics By Sex (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_demographics_by_sex_suppressed

75.95 kB
5,352 rows
11 columns

CREATE TABLE adult_demographics_by_sex_suppressed (
  "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
);

Adult Demographics By Written Language (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_demographics_by_written_language_suppressed

210.49 kB
45,307 rows
11 columns

CREATE TABLE adult_demographics_by_written_language_suppressed (
  "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
);

Adult Mental Health Services Utilization By Age Group (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_mental_health_services_utilization_by_age_group__fb5568b7

1.18 MB
420,922 rows
9 columns

CREATE TABLE adult_mental_health_services_utilization_by_age_group__fb5568b7 (
  "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
);

Adult Mental Health Services Utilization By Race Group (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_mental_health_services_utilization_by_race_group_d67434a7

1.35 MB
509,628 rows
9 columns

CREATE TABLE adult_mental_health_services_utilization_by_race_group_d67434a7 (
  "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
);

Adult Mental Health Services Utilization By Sex (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_mental_health_services_utilization_by_sex_suppressed

644.91 kB
217,622 rows
9 columns

CREATE TABLE adult_mental_health_services_utilization_by_sex_suppressed (
  "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
);

Adult Mental Health Services Utilization By Written Language (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_mental_health_services_utilization_by_written_la_6c079c9e

1.03 MB
411,906 rows
9 columns

CREATE TABLE adult_mental_health_services_utilization_by_written_la_6c079c9e (
  "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
);

Adult Snapshot Report By Age Group (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_snapshot_report_by_age_group_suppressed

164.84 kB
12,338 rows
19 columns

CREATE TABLE adult_snapshot_report_by_age_group_suppressed (
  "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
);

Adult Snapshot Report By Sex (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_snapshot_report_by_sex_suppressed

106.52 kB
5,228 rows
19 columns

CREATE TABLE adult_snapshot_report_by_sex_suppressed (
  "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
);

Adult Snapshot Report By Written Language (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_snapshot_report_by_written_language_suppressed

208.59 kB
21,580 rows
19 columns

CREATE TABLE adult_snapshot_report_by_written_language_suppressed (
  "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
);

Adult Time To Step Down By Age Group (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_time_to_step_down_by_age_group_suppressed

79.42 kB
4,083 rows
18 columns

CREATE TABLE adult_time_to_step_down_by_age_group_suppressed (
  "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
);

Adult Time To Step Down By Race Group (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_time_to_step_down_by_race_group_suppressed

90.23 kB
5,214 rows
18 columns

CREATE TABLE adult_time_to_step_down_by_race_group_suppressed (
  "population_name" VARCHAR,
  "population_type" VARCHAR,
  "fiscal_year" BIGINT,
  "race_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
);

Adult Time To Step Down By Sex (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_time_to_step_down_by_sex_suppressed

58.11 kB
2,073 rows
18 columns

CREATE TABLE adult_time_to_step_down_by_sex_suppressed (
  "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
);

Adult Time To Step Down By Written Language (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.adult_time_to_step_down_by_written_language_suppressed

68.52 kB
3,421 rows
18 columns

CREATE TABLE adult_time_to_step_down_by_written_language_suppressed (
  "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 Adults By Written Language (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.statewide_top_10_icd10_diagnosis_code_categories_for_a_0000819b

20.3 kB
2,086 rows
8 columns

CREATE TABLE statewide_top_10_icd10_diagnosis_code_categories_for_a_0000819b (
  "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
);

Statewide Top 10 ICD10 Diagnosis Code Categories For Adults By Age Group (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.statewide_top_10_icd10_diagnosis_code_categories_for_a_8babc45c

12.23 kB
400 rows
8 columns

CREATE TABLE statewide_top_10_icd10_diagnosis_code_categories_for_a_8babc45c (
  "fiscal_year" BIGINT,
  "age_grp" 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 Adults By Race Group (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.statewide_top_10_icd10_diagnosis_code_categories_for_a_9dec8159

14.1 kB
560 rows
8 columns

CREATE TABLE statewide_top_10_icd10_diagnosis_code_categories_for_a_9dec8159 (
  "fiscal_year" BIGINT,
  "race_grp" 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 Adults By Sex (Suppressed)

@usgov.ca_gov_mhs_dashboard_adult_demographic_datasets_4de54.statewide_top_10_icd10_diagnosis_code_categories_for_a_f634fdee

8.89 kB
160 rows
8 columns

CREATE TABLE statewide_top_10_icd10_diagnosis_code_categories_for_a_f634fdee (
  "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
);