Fire and Medical Opioid Overdose Incidents
Confirmed cases of opioid overdose, locations are not actual but instead rounded to approximately 1/3 mile increments. Opioid overdose confirmed by 1) patient or witness verification, 2) Opioid found on scene or 3) positive response to Narcan treatment. Incidents involving Mesa police are identified by the "PD Narcan" field. Each row in this dataset represents an MFMD unit response to a confirmed overdose incident. In a small number of cases, more than one unit responded to the same incident or the incident involved more than one patient. These cases are identified by rows with the same "Incident ID" and a Final Incident Disposition for each responding unit and/or patient.
For more information on opioid drugs see https://www.drugabuse.gov/drugs-abuse/opioids
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 \"citydata-mesaaz-gov/fire-and-medical-opioid-overdose-incidents-qufy-tzv6\".\"fire_and_medical_opioid_overdose_incidents\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.