Open repository in Console
Readme
Updated almost 2 years ago
‧ Indexed 4 hours ago
Drug Interdiction Measures 2017-Current Monthly Corrections
This dataset is quarterly Department of Corrections department-wide data including inmate drug finds per 1,000, percent of random positive drug tests, inmate on staff assaults per 1,000, inmate on inmate assaults per 1,000, number of written drug misconduct charges per 1,000, violence per 1,000, inmate ER trips per 1,000, inmate drug overdoses per 1,000, and number of drug exposure Emergency Room trips for staff.
Null field signifies the data was not available yet.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"pa-gov/drug-interdiction-measures-2017current-monthly-eius-xt4t\".\"drug_interdiction_measures_2017current_monthly\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.
Upstream Metadata