About this Dataset

ACT Baseline Characteristics Summary: 5 Year Window

This dataset contains the number of ACT participants within each demographic, risk, and service utilization category at admission to ACT. Data are aggregated by admission year (past 5 years), OMH region and statewide, and AOT status at admission.
Organization: State of New York
Last updated: 2020-11-12T04:00:17.607548
Tags: assertive-community-treatment, mental-health

Tables

Table 1

@usgov.state_of_new_york_act_baseline_characteristics_summary_c9dfc856.table_1

52.79 KB
108 rows
48 columns


CREATE TABLE table_1 (
  "date_created" TIMESTAMP,
  "admission_year" BIGINT,
  "region_name" VARCHAR,
  "aot_status_at_admission" VARCHAR,
  "census" BIGINT,
  "length_of_stay_0_to_6_months" BIGINT,
  "length_of_stay_6_to_12_months" BIGINT,
  "length_of_stay_1_to_3_years" BIGINT,
  "length_of_stay_3_to_5_years" BIGINT,
  "length_of_stay_more_than_5_years" BIGINT,
  "age_24_years_or_less" BIGINT,
  "age_25_to_44_years" BIGINT,
  "age_45_to_64_years" BIGINT,
  "age_more_than_65_years" BIGINT,
  "gender_male" BIGINT,
  "gender_female" BIGINT,
  "race_white" BIGINT,
  "race_black" BIGINT,
  "race_other" BIGINT,
  "race_unknown" BIGINT,
  "ethnicity_hispanic" BIGINT,
  "ethnicity_non_hispanic" BIGINT,
  "ethnicity_unknown" BIGINT,
  "living_situation_private_residence" BIGINT,
  "living_situation_supported_housing" BIGINT,
  "living_situation_unstably_housed" BIGINT,
  "living_situation_institution" BIGINT,
  "living_situation_homeless" BIGINT,
  "living_situation_other" BIGINT,
  "living_situation_unknown" BIGINT,
  "education_less_than_high_school" BIGINT,
  "education_high_school" BIGINT,
  "education_some_college" BIGINT,
  "education_other" BIGINT,
  "education_unknown" BIGINT,
  "employed" BIGINT,
  "diagnosis_schizophrenia" BIGINT,
  "diagnosis_bipolar_disorder" BIGINT,
  "diagnosis_depression" BIGINT,
  "diagnosis_other" BIGINT,
  "psychiatric_hospitalization" BIGINT,
  "psychiatric_er" BIGINT,
  "psychiatric_medication" BIGINT,
  "any_substance_use" BIGINT,
  "forensic_involvement" BIGINT,
  "harm_to_self" BIGINT,
  "harm_to_others" BIGINT,
  "property_damage" BIGINT
);