Assertive Community Treatment Outcomes

JohnSnowLabs

Files Size Format Created Updated License Source
2 196kB csv zip 2 weeks ago johnsnowlabs Data City of New York
Download

Data Files

File Description Size Last changed Download Other formats
assertive-community-treatment-outcomes-csv [csv] 13kB assertive-community-treatment-outcomes-csv [csv] assertive-community-treatment-outcomes-csv [json] (151kB)
datapackage_zip [zip] Compressed versions of dataset. Includes normalized CSV and JSON data with original data and datapackage.json. 20kB datapackage_zip [zip]

assertive-community-treatment-outcomes-csv  

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
OMH_Region 1 string Indicates whether the data represents a Region (Central NY, Hudson River, Long Island, New York City, or Western NY) or is Statewide.
Data_Level_Indicator 2 string Data level indicator indicates whether the row represents program, county, region, or statewide level data
County 3 string Name of the county
Team_County_or_Region 4 string Name of the team/program, county, region, or whether it is Statewide
Number_With_Follow_Up_Data 5 integer Number of currently enrolled ACT recipients who have at least one follow-up
Number_Employed_At_Baseline 6 integer Number of ACT recipients who are employed or hold volunteer positions at baseline
Number_Employed_At_Follow_Up 7 integer Number of ACT recipients who are employed or hold volunteer positions at most recent follow-up
Number_Competitively_Employed_At_Baseline 8 integer Number of ACT recipients who hold competitive employment, with or without formal supports, at baseline
Number_Competitively_Employed_At_Follow_Up 9 integer Number of ACT recipients who hold competitive employment, with or without formal supports, at most recent follow-up
Number_in_Educational_Activity_At_Baseline 10 integer Number of ACT recipients who engage in educational activities at baseline
Number_in_Educational_Activity_At_Follow_Up 11 integer Number of ACT recipients who engage in educational activities at most recent followup.
Number_Hospitalized_At_Baseline 12 integer Number of ACT recipients reported to have 2 or more psychiatric hospitalizations 6 months prior to baseline
Number_Hospitalized_At_Follow_Up 13 integer Number of ACT recipients reported to have 2 or more psychiatric hospitalizations 6 months prior to most recent follow-up
Number_Homeless_At_Baseline 14 integer Number of ACT recipients who were homeless or had an episode of homelessness at baseline
Number_Homeless_At_Follow_Up 15 integer Number of ACT recipients who were homeless or had an episode of homelessness at most recent follow-up
Number_With_Psych_ER_At_Baseline 16 integer Number of ACT recipients with two or more psychiatric Emergency Room visits at baseline
Number_With_Psych_ER_At_Follow_Up 17 integer Number of ACT recipients with two or more psychiatric Emergency Room visits at most recent follow-up
Number_With_Risk_Factors_At_Baseline 18 integer Number of currently enrolled ACT recipients with one or more of any of the following 12 risk factors reported at baseline: expressed suicide threat, physically harmed self and/or attempted suicide, taken property without permission, damaged or destroyed property, created a public disturbance, verbally assaulted another person, threatened assault or physical violence, been suspected of sexual abuse of a child and/or adult, physically abused and/or assaulted a child and/or adult, engaged in arson, was a victim of physical or sexual abuse, wandered or ran away
Number_With_Risk_Factors_At_Follow_Up 19 integer Number of currently enrolled ACT recipients with one or more risk factors reported at most recent follow-up
Number_Treatment_Objectives_Met_Last_Year 20 integer Number of previous year's discharges that were Treatment Objectives Met
Number_Found_Alternative_Services_Last_Year 21 integer Number of previous year's discharges that were Found Alternative Services
Number_Disch_To_Long_Term_Health_Care_Last_Year 22 integer Number of previous year's discharges that were Discharged to Long Term Health Care
Number_Not_Engaged_Last_Year 23 integer Number of previous year's discharges that were Not Engaged
Number_No_Longer_Available_For_Services_Last_Year 24 integer Number of previous year's discharges that were No Longer Available For Services
Number_Other_Discharge_Reason_Last_Year 25 integer Number of previous year's discharges that were Other
Number_Treatment_Objectives_Met_Current_Year 26 integer Number of current year's discharges that were Treatment Objectives Met
Number_Found_Alternative_Services_Current_Year 27 integer Number of current year's discharges that were Found Alternative Services
Number_Discharged_To_Long_Term_Health_Care_Current_Year 28 integer Number of current year's discharges that were Discharged to Long Term Health Care
Number_Not_Engaged_Current_Year 29 integer Number of current year's discharges that were Not Engaged
Number_No_Longer_Available_For_Services_Current_Year 30 integer Number of current year's discharges that were No Longer Available For Services
Number_Other_Discharge_Reason_Current_Year 31 integer Number of current year's discharges that were Other

datapackage_zip  

This is a preview version. There might be more data in the original version.

Read me

Import into your tool

If you are using R here's how to get the data you want quickly loaded:

install.packages("jsonlite")
library("jsonlite")

json_file <- "http://datahub.io/JohnSnowLabs/assertive-community-treatment-outcomes/datapackage.json"
json_data <- fromJSON(paste(readLines(json_file), collapse=""))

# access csv file by the index starting from 1
path_to_file = json_data$resources[[1]]$path
data <- read.csv(url(path_to_file))
print(data)

In order to work with Data Packages in Pandas you need to install the Frictionless Data data package library and the pandas extension:

pip install datapackage
pip install jsontableschema-pandas

To get the data run following code:

import datapackage

data_url = "http://datahub.io/JohnSnowLabs/assertive-community-treatment-outcomes/datapackage.json"

# to load Data Package into storage
storage = datapackage.push_datapackage(data_url, 'pandas')

# data frames available (corresponding to data files in original dataset)
storage.buckets

# you can access datasets inside storage, e.g. the first one:
storage[storage.buckets[0]]

For Python, first install the `datapackage` library (all the datasets on DataHub are Data Packages):

pip install datapackage

To get Data Package into your Python environment, run following code:

from datapackage import Package

package = Package('http://datahub.io/JohnSnowLabs/assertive-community-treatment-outcomes/datapackage.json')

# get list of resources:
resources = package.descriptor['resources']
resourceList = [resources[x]['name'] for x in range(0, len(resources))]
print(resourceList)

data = package.resources[0].read()
print(data)

If you are using JavaScript, please, follow instructions below:

Install data.js module using npm:

  $ npm install data.js

Once the package is installed, use the following code snippet:

const {Dataset} = require('data.js')

const path = 'http://datahub.io/JohnSnowLabs/assertive-community-treatment-outcomes/datapackage.json'

// We're using self-invoking function here as we want to use async-await syntax:
(async () => {
  const dataset = await Dataset.load(path)

  // Get the first data file in this dataset
  const file = dataset.resources[0]
  // Get a raw stream
  const stream = await file.stream()
  // entire file as a buffer (be careful with large files!)
  const buffer = await file.buffer
})()

Install the datapackage library created specially for Ruby language using gem:

gem install datapackage

Now get the dataset and read the data:

require 'datapackage'

path = 'http://datahub.io/JohnSnowLabs/assertive-community-treatment-outcomes/datapackage.json'

package = DataPackage::Package.new(path)
# So package variable contains metadata. You can see it:
puts package

# Read data itself:
resource = package.resources[0]
data = resource.read
puts data
Datapackage.json