Pilot Pharmaceutical Take-Back Program Medication Collection Boxes

The Pilot Pharmaceutical Take-Back Program covers the costs of consumer drug collection boxes and disposal for two years, and gives pharmacies a safe, convenient, and effective way to keep drugs out of our waters and out of the wrong hands.

Addresses of participating pharmacies, hospitals, and long-term care facilities participating in the New York State Department of Environmental Conservation’s Pilot Pharmaceutical Take-Back Program with medication collection boxes. Medication collection boxes only collect solid state controlled and non-controlled substances. Medication collection boxes do not accept sharps, liquids, personal care products, etc.

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 \"ny-gov/pilot-pharmaceutical-takeback-program-medication-5e2x-mz3d\".\"pilot_pharmaceutical_takeback_program_medication\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.