Opioid Seizures and Arrests CY 2013 - Current Quarterly County State Police

This dataset contains summary information on opioid drug seizures and arrests made by Pennsylvania State Police (PSP) personnel, stationed statewide, on a quarterly basis. Every effort is made to collect and record all opioid drug seizures and arrests however, the information provided may not represent the totality of all seizures and opioid arrests made by PSP personnel.

Data is currently available from January 1, 2013 through most current data available.

Seizure

Opioids seized as a result of undercover buys, search warrants, traffic stops and other investigative encounters.

An incident is a Pennsylvania State Police (PSP) recorded violation of the Controlled Substance Act and an entry into the PSP Statistical Narcotics System.

By regulation, entry is made by the PSP as stated in PSP Administrative Regulation 9-6:

When violations of The Controlled Substance, Drug, Device and Cosmetic Act are reported, the required statistical information concerning the incident shall be entered into the Statistical Narcotic Reporting System (SNRS).

Incidents may include undercover buys, search warrants, traffic stops and other investigative encounters

So, an “incident” is not based on any arrest, but on a reported violation, though it often can include arrests.

The incidents that are selected and forwarded to the portal are those that include a record of one or more seizures of the opioid drugs. In turn, a subset of those selected incidents also contains a record of one or more arrests.

This is PSP data only, it would not include any Federal case/incident data.

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/opioid-seizures-and-arrests-cy-2013-current-wmgc-6qvd\".\"opioid_seizures_and_arrests_cy_2013_current\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.