ct-gov/accidental-drug-related-deaths-20122022-rybz-nyjw
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 7 months ago
Indexed 11 hours ago

Accidental Drug Related Deaths 2012-2022

A listing of each accidental death associated with drug overdose in Connecticut from 2012 to 2022. A "Y" value under the different substance columns indicates that particular substance was detected.

Data are derived from an investigation by the Office of the Chief Medical Examiner which includes the toxicity report, death certificate, as well as a scene investigation.

The “Morphine (Not Heroin)” values are related to the differences between how Morphine and Heroin are metabolized and therefor detected in the toxicity results. Heroin metabolizes to 6-MAM which then metabolizes to morphine. 6-MAM is unique to heroin, and has a short half-life (as does heroin itself). Thus, in some heroin deaths, the toxicity results will not indicate whether the morphine is from heroin or prescription morphine. In these cases the Medical Examiner may be able to determine the cause based on the scene investigation (such as finding heroin needles). If they find prescription morphine at the scene it is certified as “Morphine (not heroin).” Therefor, the Cause of Death may indicate Morphine, but the Heroin or Morphine (Not Heroin) may not be indicated.

“Any Opioid” – If the Medical Examiner cannot conclude whether it’s RX Morphine or heroin based morphine in the toxicity results, that column may be checked

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 \"ct-gov/accidental-drug-related-deaths-20122022-rybz-nyjw\".\"accidental_drug_related_deaths_20122022\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • accidental_drug_related_deaths_20122022
     
     
     
     
     
Upstream Metadata