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.