ACT Admission To Discharge Outcomes: 5 Year Window by US Government | Healthcare

About this Dataset

ACT Admission To Discharge Outcomes: 5 Year Window

This dataset contains the number of discharged ACT participants at admission to ACT and at discharge from ACT within a set of outcome indicators such as living situation, employment and risk behaviors. The data are aggregated by New York State region, year of discharge (past 5 years), AOT status at admission, and by behavioral health diagnosis at admission.
Organization: State of New York
Last updated: 2020-11-12T03:59:58.335603
Tags: assertive-community-treatment, mental-health

Tables

Table 1

@usgov.state_of_new_york_act_admission_to_discharge_outcomes__3ec80709.table_1

60.87 KB
510 rows
40 columns


CREATE TABLE table_1 (
  "date_created" TIMESTAMP,
  "discharge_year" BIGINT,
  "region_name" VARCHAR,
  "aot_status_at_admission" VARCHAR,
  "mental_health_diagnosis" VARCHAR,
  "denominator" BIGINT,
  "living_situation_private_residence_at_admission" BIGINT,
  "living_situation_private_residence_at_discharge" BIGINT,
  "living_situation_supported_housing_at_admission" BIGINT,
  "living_situation_supported_housing_at_discharge" BIGINT,
  "living_situation_institution_at_admission" BIGINT,
  "living_situation_institution_at_discharge" BIGINT,
  "living_situation_unstably_housed_at_admission" BIGINT,
  "living_situation_unstably_housed_at_discharge" BIGINT,
  "living_situation_homeless_at_admission" BIGINT,
  "living_situation_homeless_at_discharge" BIGINT,
  "education_enrollment_at_admission" BIGINT,
  "education_enrollment_at_discharge" BIGINT,
  "employed_at_admission" BIGINT,
  "employed_at_discharge" BIGINT,
  "psychiatric_hospitalization_at_admission" BIGINT,
  "psychiatric_hospitalization_at_discharge" BIGINT,
  "psychiatric_er_visit_at_admission" BIGINT,
  "psychiatric_er_visit_at_discharge" BIGINT,
  "substance_use_disorder_at_admission" BIGINT,
  "substance_use_disorder_at_discharge" BIGINT,
  "any_substance_use_at_admission" BIGINT,
  "any_substance_use_at_discharge" BIGINT,
  "homeless_at_admission" BIGINT,
  "homeless_at_discharge" BIGINT,
  "active_aot_status_at_admission" BIGINT,
  "active_aot_status_at_discharge" BIGINT,
  "forensic_involvement_at_admission" BIGINT,
  "forensic_involvement_at_discharge" BIGINT,
  "harm_to_self_at_admission" BIGINT,
  "harm_to_self_at_discharge" BIGINT,
  "harm_to_others_at_admission" BIGINT,
  "harm_to_others_at_discharge" BIGINT,
  "property_damage_at_admission" BIGINT,
  "property_damage_at_discharge" BIGINT
);