Inmate Medication-Assisted Treatment (MAT) Quarter 1 2017 - Current Statewide Corrections

The database was constructed from using the source “Sapphire Emar”. The raw data was condensed to remove any duplicate data that expressed the following: data rows with the same inmate name who had multiple of the same medications or multiple of the same medication type. Then the data sets were sorted by admission dates. Then grouped by quarters or years or both. After that, data was sorted by various descriptor columns: Age Range, Ethnicity, Gender and Drug type.

What is the story the data is telling? The data shows a significantly higher admission rate for Caucasians and Males. The data also shows the age range of 30-34 consistently has the highest percent admission rate. The data also shows a high percentage of inmates receive Vivitrol/Revia as opposed to Suboxone.

What to realize about this data? Although Males and Caucasians have a higher admission rate it is worth noting that this does not take into the account of how many inmates based on gender or ethnicity there are/were in the DOC at a given time. Regardless of Year the Inmate age peaks at 30-34 suggesting they are the most likely to seek treatment.

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/inmate-medicationassisted-treatment-mat-quarter-1-m8cr-cygf\".\"inmate_medicationassisted_treatment_mat_quarter_1\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.