About this Dataset

Behavioral Health And Workforce

The dataset contains a ratio of the number of patient encounters (i.e., Inpatient Hospitalizations and Emergency Department visits) with a behavioral health diagnosis, per healthcare provider license with a specialty in behavioral health. The ratio is categorized based on the values of the Numerator to Denominator. Larger ratios may indicate a greater need for providers specializing in behavioral health. Smaller ratios may indicate a lower need for providers specializing in behavioral health. The dataset also contains the numbers of the top ten behavioral health diagnoses, by diagnosis category, that were present during the encounters. The table is broken down by county, and it is limited to hospital Inpatient and Emergency Department settings.
Organization: State of California
Last updated: 2025-07-23T20:05:36.373752
Tags: behavioral-health, department-of-health-care-access-and-information, ed-visit, emergency-department, hcai, health-workforce, healthcare, hospitalizations, inpatient, license, mental-health, mental-health-disorder, provider, specialty, substance-use-disorder, sud

Tables

Behavioral Health And Workforce - Dataset

@usgov.ca_gov_behavioral_health_and_workforce.behavioral_health_and_workforce_dataset

10.22 KB
452 rows
8 columns


CREATE TABLE behavioral_health_and_workforce_dataset (
  "condition" VARCHAR,
  "county" VARCHAR,
  "numerator" BIGINT,
  "denominator" BIGINT,
  "binrange" VARCHAR,
  "diagnosis" VARCHAR,
  "dxsum" BIGINT,
  "rank" BIGINT
);

Data Dictionary - Behavioral Health And Workforce - Dataset

@usgov.ca_gov_behavioral_health_and_workforce.data_dictionary_behavioral_health_and_workforce_dataset

4.65 KB
8 rows
4 columns


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