Baselight

Drug Overdose Deaths

Accidental drug related deaths during 2012-2018

@kaggle.ruchi798_drug_overdose_deaths

Loading...
Loading...

About this Dataset

Drug Overdose Deaths

Context

The rate of overdose deaths in Connecticut increased from 9.9 per 100,000 residents in 2012 to 28.5 per 100,000 residents in 2018-a 221 % increase-with the majority occurring among persons aged 35-64 (65.3 %), men (73.9 %), and non-Hispanic whites (78.5 %). Among deaths involving fentanyl, the overall deaths escalated from 5.2 deaths per 100,000 residents in 2015 to 21.3 deaths per 100,000 residents in 2018 and more than 50% of these fentanyl-related deaths involved polysubstance use.

Inspiration

  • To examine trends in polysubstance detection associated with drug-related overdose deaths

Tables

Drug Deaths

@kaggle.ruchi798_drug_overdose_deaths.drug_deaths
  • 297.89 KB
  • 5105 rows
  • 42 columns
Loading...

CREATE TABLE drug_deaths (
  "unnamed_0" BIGINT,
  "id" VARCHAR,
  "date" VARCHAR,
  "datetype" DOUBLE,
  "age" DOUBLE,
  "sex" VARCHAR,
  "race" VARCHAR,
  "residencecity" VARCHAR,
  "residencecounty" VARCHAR,
  "residencestate" VARCHAR,
  "deathcity" VARCHAR,
  "deathcounty" VARCHAR,
  "location" VARCHAR,
  "locationifother" VARCHAR,
  "descriptionofinjury" VARCHAR,
  "injuryplace" VARCHAR,
  "injurycity" VARCHAR,
  "injurycounty" VARCHAR,
  "injurystate" VARCHAR,
  "cod" VARCHAR,
  "othersignifican" VARCHAR,
  "heroin" BIGINT,
  "cocaine" BIGINT,
  "fentanyl" VARCHAR,
  "fentanyl_analogue" DOUBLE,
  "oxycodone" BIGINT,
  "oxymorphone" BIGINT,
  "ethanol" BIGINT,
  "hydrocodone" BIGINT,
  "benzodiazepine" BIGINT,
  "methadone" BIGINT,
  "amphet" BIGINT,
  "tramad" BIGINT,
  "morphine_notheroin" VARCHAR,
  "hydromorphone" BIGINT,
  "other" VARCHAR,
  "opiatenos" BIGINT,
  "anyopioid" VARCHAR,
  "mannerofdeath" VARCHAR,
  "deathcitygeo" VARCHAR,
  "residencecitygeo" VARCHAR,
  "injurycitygeo" VARCHAR
);

Share link

Anyone who has the link will be able to view this.