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.