Readme
Updated 1 year ago
‧ Indexed 2 hours ago
Count and Rate of Court Cases and Drug Court Participants Specifying Opioids in Pennsylvania CY 2016 - Current County Administrative Office of Pennsylvania Courts (AOPC)
This indicator includes the count and rate of the Courts of Common Pleas cases and PHILADELPHIA MUNICIPAL COURT cases with a conviction of offense code 35 P.S. § 780-113(a)(30) and a specified opioid drug per 1,000 court cases in the state of Pennsylvania as well as its counties. This offense code charges defendants with the manufacture or delivery or possession with intent to manufacture or delivery of unlawful substances. Other break downs include by gender and age group along with percentages where rate is not available.
This indicator also includes the count and percentage of adult drug court participants with self-reported use of opioids from the Administrative Office of Pennsylvania Courts (AOPC) online dashboard. Participants were counted as opioid related if the participant self-reported an opioid (heroin or opiates) as their drug of choice. Adult drug court data is aggregated to annual counts by state and county of jurisdiction as well as percentage of participants that successfully completed the program. The year displayed corresponds to the year the participant completed the program. It should be noted that it can take between one to two years to complete the program. Additional data on adult drug court participants for all drugs can be found on AOPC's Data Dashboard at: http://www.pacourts.us/news-and-statistics/research-and-statistics/dashboard-table-of-contents/adult-drug-court-data
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| County_FIPS_Code | county_fips_code | county_fips_code | Text | Last 3 digits of the 5-digit Federal Information Processing Standard (FIPS) code that designate the county 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. |
| Percent of Adult Drug Court Participants Self-Reporting Opioid Use Description | percent_of_drug_court_cases_1 | percent_of_drug_court_cases_1 | Text | Describes percent of adult drug court participants self-reporting opioid use. |
| Adult Drug Court Participants Self-Reporting Opioid Use Successfully Graduating | successfully_completed_opioid | successfully_completed_opioid | Number | Adult drug court participants self-reporting opioids (heroin or opiates) as their drug of choice and graduated successfully from the program. |
| Adult Drug Court Participants Description | drug_court_cases_description | drug_court_cases_description | Text | Describes adult drug court participants. |
| Percent of Court of Common Pleas Cases with Opioid Use | percent_of_court_of_common | percent_of_court_of_common | Number | Percent of Court of Common Pleas cases with opioid use for a given time period and group (sex, age). |
| Rate of Court of Common Pleas Opioid Cases | rate_of_court_of_common_pleas | rate_of_court_of_common_pleas | Number | Rate of annual Court of Common Pleas cases specifying opioids per 1,000 cases in the state or the county. |
| Time Period | time_period | time_period | Text | Period of Court of Common Pleas disposition dates (annual or quarterly) or adult drug court discharge dates (annual only). |
| Georeferenced Latitude & Longitude | geocoded_column | geocoded_column | Point | Georeferenced latitude and longitude point which can be used to create a map. |
| Longitude | longitude | longitude | Number | Longitude coordinates in degrees for a centroid point for geographic area. |
| Latitude | latitude | latitude | Number | Latitude coordinates in degrees for a centroid point for geographic area. |
| County_Code_Text | county_code_text | county_code_text | Text | Pennsylvania county code provided as text (1-67 for counties sorted alphabetically, 0 for Commonwealth). |
| County_Code_Number | county_code_number | county_code_number | Number | Pennsylvania county code provided as a number (1-67 for counties, 0 for Commonwealth). |
| Percent of Adult Drug Court Participants Successfully Graduating | percent_of_drug_court_cases_2 | percent_of_drug_court_cases_2 | Number | Percent of adult drug court participants discharged and successfully graduated from the program. |
| Percent of Adult Drug Court Participants Self-Reporting Opioid Use | percent_of_drug_court_cases | percent_of_drug_court_cases | Number | Percent of adult drug court participants discharged that self-reported opioids (heroin or opiates) as their drug of choice. |
| Adult Drug Court Participants Self-Reporting Opioid Use | opioid_drug_court_cases | opioid_drug_court_cases | Number | Adult drug court participants discharged and self-reporting opioids (heroin or opiates) as their drug of choice. |
| Adult Drug Court Participants Successfully Graduating Description | successfully_completed_drug_1 | successfully_completed_drug_1 | Text | Describes adult drug court participants successfully graduating. |
| Adult Drug Court Participants | drug_court_cases | drug_court_cases | Number | Number of discharged adult drug court participants exiting a problem-solving court. |
| Court of Common Pleas Cases | court_of_common_pleas_cases | court_of_common_pleas_cases | Number | Total number of Court of Common Pleas criminal cases disposed; used to calculate the rate (total cases for the geographic area and time period) or the percentage (total opioid cases for the geographic area and time period). |
| Geographic Name | geographic_name | geographic_name | Text | Name of geographic area. |
| Geographic Area | geographic_area | geographic_area | Text | Region for measure, either total for Commonwealth or individual county. |
| Adult Drug Court Participants Successfully Graduating | successfully_completed_drug | successfully_completed_drug | Number | Adult drug court participants discharged and successfully graduated from program. |
| Percent of Court of Common Pleas Cases with Opioid Use Description | percent_of_court_of_common_1 | percent_of_court_of_common_1 | Text | Describes percent of Court of Common Pleas cases with opioid use. |
| Type of Rate | type_of_rate | type_of_rate | Text | Describes the rate of Court of Common Pleas opioid cases. |
| Court of Common Pleas Opioid Cases | court_of_common_pleas_opioid | court_of_common_pleas_opioid | Number | Number of Court of Common Pleas cases with a specified opioid drug. |
| Time Period Dates | time_period_dates | time_period_dates | Text | Start and end dates of time period. |
| Age | age | age | Text | Age group of defendant (18 years and above). |
| Court of Common Pleas Cases Description | court_of_common_pleas_cases_1 | court_of_common_pleas_cases_1 | Text | Describes Court of Common Pleas cases. |
| Percent of Adult Drug Court Participants Self-Reporting Opioid Use Successfully Graduating Description | percent_of_drug_court_cases_5 | percent_of_drug_court_cases_5 | Text | Describes percent of adult drug court participants self-reporting opioid use successfully graduating. |
| Percent of Adult Drug Court Participants Self-Reporting Opioid Use Successfully Graduating | percent_of_drug_court_cases_4 | percent_of_drug_court_cases_4 | Number | Percent of adult drug court participants self-reporting opioids (heroin or opiates) as their drug of choice and graduated successfully from the program. |
| Percent of Adult Drug Court Participants Successfully Graduating Description | percent_of_drug_court_cases_3 | percent_of_drug_court_cases_3 | Text | Describes percent of adult drug court participants successfully graduating. |
| Adult Drug Court Participants Self-Reporting Opioid Use Successfully Graduating Description. | successfully_completed_opioid_1 | successfully_completed_opioid_1 | Text | Describes adult drug court participants self-reporting opioid use successfully graduating. |
| Adult Drug Court Participants Self-Reporting Opioid Use Description | opioid_drug_court_cases_1 | opioid_drug_court_cases_1 | Text | Describes adult drug participants self-reporting opioid use. |
| Gender | gender | gender | Text | Gender of defendant. |
| Court of Common Pleas Opioid Cases Description | court_of_common_pleas_opioid_1 | court_of_common_pleas_opioid_1 | Text | Describes Court of Common Pleas opioid cases. |
| Year | year | year | Text | Calendar year of Court of Common Pleas disposition date or adult drug court discharge date (January 1–December 31). |
| Pa School Districts (2019-06) | :@computed_region_rayf_jjgk | :@computed_region_rayf_jjgk | Number | |
| Pa House Districts (2020-01) | :@computed_region_r6rf_p9et | :@computed_region_r6rf_p9et | Number | |
| Municipality Boundary | :@computed_region_amqz_jbr4 | :@computed_region_amqz_jbr4 | Number | |
| Pa Senatorial Districts (2020-01) | :@computed_region_d3gw_znnf | :@computed_region_d3gw_znnf | Number | |
| Pennsylvania County Boundaries | :@computed_region_nmsq_hqvv | :@computed_region_nmsq_hqvv | Number | |
| State_FIPS_Code | state_fips_code | state_fips_code | Text | 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. |
Upstream Metadata