Updated over 1 year ago
Indexed 4 hours ago

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.


NameSocrata field nameColumn name in sgr mountData typeDescription
Drug Typedrug_typedrug_typeTextThis is based on what drug the inmate has taken when admitted into the program. An Inmate can have multiple drug admissions. Example: An inmate who takes Revia for 3 days then switches to Vivitrol will be admitted twice. Or if an inmate switches from Suboxone to Revia then to Vivitrol they would be admitted 3 times.
Time Period Datestime_period_datestime_period_datesTextBased on the Time Period Column, the date is represented by the Q’s or quarters Q1-Q4 = January-December or Q1=January to March, Q2=April to June, Q3=July to September, and Q4=October to December of any given year.
Time Periodtime_periodtime_periodTextBased on two values either each Quarter 3 months: (Q1=January to March, Q2=April to June, Q3=July to September, and Q4=October to December) or Combined Quarters Q1-Q4=January-December of the year described.
YearyearyearTextActual year of admission. An Inmate whom is prescribed a medication that is daily who rolls over to a new calendar year would be admitted twice.
AgeageageTextThe Inmate age based on the day the data is collected. Ranges include: All or age 0 to 99, 0-11years old, 12-19yo, 20-24yo, 25-29yo, 30-34yo, 35-39yo, 40-44yo, 45-49yo, 50-55yo, and 56-99yo. During collection age is not static. Example: If data is collected on 1/2/18 and if an inmate is admitted for Revia on 1/1/18 and his birthday is 1/2/86 the age will reflect his actual birth date.
GendergendergenderTextBased on Male, Female or All only.
Race & EthnicityethnicityethnicityTextBased on 4 categories: Caucasian, African American/Black,Asian, Other/Declined. It is worth noting no Hispanic ethic group was recognized.
Geographic Namegeographic_namegeographic_nameTextCommonwealth representing all areas of Pennsylvania.
Geographic Areageographic_areageographic_areaTextStatewide for Pennsylvania.
Total Admissionstotal_admissionstotal_admissionsNumberInmates whom have been prescribed any drug. In any given year. An inmate who has been prescribed multiple different drugs will have multiple admissions. Or an inmate who has been prescribed the same drug in different years would be admitted for as many years as they are in the program. This factually means there are fewer new admissions at the beginning of any given year due to roll over.
Upstream Metadata