Opioid Deaths by Year (Drug Overdose Deaths)

Data come from Minnesota death certificates, with cause and manner of death information provided by a medical examiner or coroner. A drug overdose death is defined as having an underlying cause of death within the following range of ICD-10 codes: X40-X44, X60-X64, X85, Y10-Y14. Note that an opioid-involved death may also be counted as a cocaine-involved death if both drugs were listed on the death certificate as contributory causes. The seven non-exclusive categories of drug overdose deaths are defined as having a contributory cause of death: All opioid-involved deaths, Prescription opioids, Synthetic opioids, Heroin, Cocaine, Benzodiazepines, and Psychostimulants with abuse potential (includes methamphetamine).

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 \"ramseycounty-us/opioid-deaths-by-year-drug-overdose-deaths-ezu7-uqui\".\"opioid_deaths_by_year_drug_overdose_deaths\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.