Icon for Socrata external plugin
Open repository in Console
Updated 3 years ago
Indexed 4 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:

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"pa-gov/count-and-rate-of-court-cases-and-drug-court-e4tx-vmn6\".\"count_and_rate_of_court_cases_and_drug_court\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • count_and_rate_of_court_cases_and_drug_court
Upstream Metadata