About this Dataset

Accidental Drug Related Deaths 2012-2023

A listing of each accidental death associated with drug overdose in Connecticut from 2012 to 2023. 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
Organization: State of Connecticut
Last updated: 2020-11-12T14:57:34.733200
Tags: death, drug, heroin, ocme, opioid, overdose, substance-abuse

Tables

Table 1

@usgov.state_of_connecticut_accidental_drug_related_deaths_2012_2018.table_1

525.9 KB
11981 rows
48 columns


CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "date_type" VARCHAR,
  "age" DOUBLE,
  "sex" VARCHAR,
  "race" VARCHAR,
  "ethnicity" VARCHAR,
  "residence_city" VARCHAR,
  "residence_county" VARCHAR,
  "residence_state" VARCHAR,
  "injury_city" VARCHAR,
  "injury_county" VARCHAR,
  "injury_state" VARCHAR,
  "injury_place" VARCHAR,
  "description_of_injury" VARCHAR,
  "death_city" VARCHAR,
  "death_county" VARCHAR,
  "death_state" VARCHAR,
  "location" VARCHAR,
  "location_if_other" VARCHAR,
  "cause_of_death" VARCHAR,
  "manner_of_death" VARCHAR,
  "other_significant_conditions" VARCHAR,
  "heroin" VARCHAR,
  "heroin_death_certificate_dc" VARCHAR,
  "cocaine" VARCHAR,
  "fentanyl" VARCHAR,
  "fentanyl_analogue" VARCHAR,
  "oxycodone" VARCHAR,
  "oxymorphone" VARCHAR,
  "ethanol" VARCHAR,
  "hydrocodone" VARCHAR,
  "benzodiazepine" VARCHAR,
  "methadone" VARCHAR,
  "meth_amphetamine" VARCHAR,
  "amphet" VARCHAR,
  "tramad" VARCHAR,
  "hydromorphone" VARCHAR,
  "morphine_not_heroin" VARCHAR,
  "xylazine" VARCHAR,
  "gabapentin" VARCHAR,
  "opiate_nos" VARCHAR,
  "heroin_morph_codeine" VARCHAR,
  "other_opioid" VARCHAR,
  "any_opioid" VARCHAR,
  "other" VARCHAR,
  "residencecitygeo" VARCHAR,
  "injurycitygeo" VARCHAR,
  "deathcitygeo" VARCHAR
);