Readme
Updated 5 days ago
‧ Indexed 1 hour ago
Inmate Admissions with Substance Use Year 2016 - Current Quarterly County Corrections
This dataset is quarterly data by county, including inmate admissions, average Texas Christian University Drug Screen II (TCU) score, number and percent of inmate admissions who identify opioids as top three drug of choice, inmates with a substance abuse problem, and number and percent who used opioids in the year prior to admission.
This data is available starting with the first Quarter of Calendar Year 2016.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Age | age | age | Text | This show the age group for the data in the row. |
| Percent of New Admissions with Opioid Use | of_total_admits_w_opioid_use | of_total_admits_w_opioid_use | Number | Percent of total new court admissions who used opiates as their top three drugs of choice. |
| County Code | county_code | county_code | Text | Two-digit code for County in text format. '00' indicates the Commonwealth of Pennsylvania. Two-digit codes will help match counties in other files. |
| Percent of Admissions with Opioid use in past 12 months | admits_w_opioid_use_in_past_12_months_before_admit_2 | admits_w_opioid_use_in_past_12_months_before_admit_2 | Number | Percent of total new court admissions who self identified as using Opiates or Heroin in the prior 12 months before admission to DOC |
| County Name | county | county | Text | County name from which the inmate was sentenced to the Pennsylvania Department of Corrections. Pennsylvania has 67 counties. |
| Year | year | year | Text | Calendar Year of Data |
| Average TCU Drug Screen Score | average_tcu_score | average_tcu_score | Number | Average score on the Texas Christian University Drug Screens (TCU) among Department of Corrections (DOC) admissions who have scores. The TCU assesses for substance abuse issues and provides a score between 0 and 9. A score of 3 or higher indicates a substance use disorder. Link: http://ibr.tcu.edu/wp-content/uploads/2016/10/TCU-Drug-Screen-II-sg-v11.pdf |
| New Admissions with Opioid Use | admits_w_reported_opioid_use | admits_w_reported_opioid_use | Number | Number of new court admissions who used opiates as their top three drugs of choice, based on the TCU assessment results. The TCU Drug Screen II is scored to produce a single total score which can range from 0 to 9. Score values of 3 or greater indicate relatively severe drug-related problems, and correspond approximately to DSM drug dependence diagnosis. Responses to Item 10 indicate which drug (or drugs) the respondent feels is primarily responsible for his or her drug-related problems. |
| Admissions with Diagnosed Substance Abuse Problem | admits_w_diagnosed_substance_abuse_problem | admits_w_diagnosed_substance_abuse_problem | Number | Number of new court admissions who had a TCU score of 3 or higher, indicating a substance abuse problem.The TCU Drug Screen II is scored to produce a single total score which can range from 0 to 9. Score values of 3 or greater indicate relatively severe drug-related problems, and correspond approximately to DSM drug dependence diagnosis. Responses to Item 10 indicate which drug (or drugs) the respondent feels is primarily responsible for his or her drug-related problems. |
| Percent of Admissions with Diagnosed Substance Abuse Problem | of_admits_w_diagnosed_substance_abuse | of_admits_w_diagnosed_substance_abuse | Number | Percent of new court admissions who had a TCU score of 3 or higher, indicating a substance abuse problem. The TCU Drug Screen II is scored to produce a single total score which can range from 0 to 9. Score values of 3 or greater indicate relatively severe drug-related problems, and correspond approximately to DSM drug dependence diagnosis. Responses to Item 10 indicate which drug (or drugs) the respondent feels is primarily responsible for his or her drug-related problems. |
| Admissions with Opioid use in past 12 months | admits_w_opioid_use_in_past_12_months_before_admit_1 | admits_w_opioid_use_in_past_12_months_before_admit_1 | Number | Number of new court admissions who self identified as using Opiates or Heroin in the prior 12 months before admission to DOC. |
| State FIPS | state_fips | state_fips | Text | These are the first 2 digits of the 5-digit Federal Information Processing Standard (FIPS) code that designate the State association. Each State has its own 2-digit number and each County within the state has its own 3-digit number which are combined into a 5-digit number to uniquely identify every US county. For more technical details : Federal Information Processing Standards Publications (FIPS PUBS) are issued by the National Institute of Standards and Technology (NIST) after approval by the Secretary of Commerce pursuant to Section 111 (d) of the Federal Property and Administrative Services Act of 1949 as amended by the Computer Security Act of 1987, Public Law 100-235. Federal Information Processing Standard (FIPS) 6-4, Counties and Equivalent Entities of the U.S., Its Possessions, and Associated Areas -- 90 Aug 31 , provides the names and codes that represent the counties and other entities treated as equivalent legal and/or statistical subdivisions of the 50 States, the District of Columbia, and the possessions and freely associated areas of the United States. Counties are considered to be the "first-order subdivisions" of each State and statistically equivalent entity, regardless of their local designations (county, parish, borough, etc.). Information gathered from census data - https://www.census.gov/geo/reference/codes/cou.html |
| County FIPS | county_fips | county_fips | Text | The FIPS county code is a five-digit Federal Information Processing Standard (FIPS) code (FIPS 6-4) which uniquely identifies counties and county equivalents in the United States, certain U.S. possessions, and certain freely associated states. This is the 3-digit part of the 5-digit county FIPS code specifically standing for the county. |
| County Code Number | county_code_number | county_code_number | Number | Code for County in number format. '0' indicates the Commonwealth of Pennsylvania. |
| Latitude | centroid | centroid | Text | A generic Latitude point within the county. A point is also provided for outside of the state (on a map it will sit to the southeast of the state). This number represents the total number for the state and this location provides a spot on a map to display the PA number without having it duplicate within a county when using in a mapping visual. |
| Longitude | longitude | longitude | Text | A generic Longitude point within the county. A point is also provided for outside of the state (on a map it will sit to the southeast of the state). This number represents the total number for the state and this location provides a spot on a map to display the PA number without having it duplicate within a county when using in a mapping visual. |
| Pa Senatorial Districts (2017-01) | :@computed_region_d3gw_znnf | :@computed_region_d3gw_znnf | Number | |
| Pa House Districts (2017-01) | :@computed_region_r6rf_p9et | :@computed_region_r6rf_p9et | Number | |
| Pa School Districts (2017) | :@computed_region_rayf_jjgk | :@computed_region_rayf_jjgk | Number | |
| Municipality Boundary | :@computed_region_amqz_jbr4 | :@computed_region_amqz_jbr4 | Number | |
| Gender | gender | gender | Text | This is All for both male and female or just male or female delineating the data in the row. |
| Year and Quarter | time_period | time_period | Text | This is the Year and Quarter of the data in the row. |
| Time Period Dates | time_period_dates | time_period_dates | Text | This is the beginning and end date of the data in the row. |
| Drug Screened Admissions | admits | admits | Number | Total number of new commit admissions with valid Texas Christian University Drug Screen II (TCU) scores |
| Georeferenced Latitude &Longitude | geocoded_column | geocoded_column | Point | A generic georeferenced Latitude & Longitude point within the county. These points can be used to create visualizations such as maps to show the data by county. A point is also provided for outside of the state (on a map it will sit to the southeast of the state). This number represents the total number for the state and this location provides a spot on a map to display the PA number without having it duplicate within a county when using in a mapping visual. |
| Geographic Area | geographic_area | geographic_area | Text | This is the name of State or County delineating the data that is shown in this row. |
| Pennsylvania County Boundaries | :@computed_region_nmsq_hqvv | :@computed_region_nmsq_hqvv | Number |
Upstream Metadata