Prescription Drug Take-Back Box Locations County Drug and Alcohol Programs

This dataset reports the site name, street address, city, county, zip code, telephone number, hours of availability, latitude, and longitude of Pennsylvania prescription drug take-back boxes as of May 2018. These monitored locations include police departments, courthouses, pharmacies, and hospitals/medical centers.

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/prescription-drug-takeback-box-locations-county-vjk8-em4w\".\"prescription_drug_takeback_box_locations_county\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.