Drug Overdose Deaths
Accidental drug related deaths during 2012-2018
@kaggle.ruchi798_drug_overdose_deaths
Accidental drug related deaths during 2012-2018
@kaggle.ruchi798_drug_overdose_deaths
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.
CREATE TABLE drug_deaths (
"unnamed_0" BIGINT -- Unnamed: 0,
"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
);Anyone who has the link will be able to view this.