About this Dataset

Mental And Behavioral Health Diagnoses In Emergency Department And Inpatient Discharges By Healthy Places Index Ranking

This dataset provides counts and percentages of diagnoses broken down by each patient’s Healthy Places Index percentile ranking (based on ZIP code of residence). Healthcare encounters are categorized into four diagnosis groups: mental health disorders, substance use disorders, co-occurring disorders, and all other diagnoses. To view and interact with a fully functioning version of the HPI map and data used in these HCAI analyses of behavioral health, please click the link to visit https://map.healthyplacesindex.org/.
Organization: State of California
Last updated: 2023-08-12T11:36:36.068146
Tags: department-of-health-care-access-and-information, emergency-discharges, healthcare-encounters, healthy-places-index, hospitals, inpatient-discharges, mental-health-disorder, substance-use-disorders

Tables

Healthy Places Index (HPI) Diagnosis Group By Setting And Patient Category

@usgov.ca_gov_mental_and_behavioral_health_diagnoses_in_emerg_3c9a03de.healthy_places_index_hpi_diagnosis_group_by_setting_an_c1c3faa0

13.2 kB
1,088 rows
8 columns

CREATE TABLE healthy_places_index_hpi_diagnosis_group_by_setting_an_c1c3faa0 (
  "year" BIGINT,
  "hpi_percentile_ranking" VARCHAR,
  "encounter_setting" VARCHAR,
  "category" VARCHAR,
  "category_description" VARCHAR,
  "diagnosis_group" VARCHAR,
  "residence" VARCHAR,
  "count" BIGINT
);