Exploratory Data Analysis and Data Visualization on Accidental Drug Related Deaths

The drug overdose epidemic in the United States is rapidly getting worse with substantial associated public health effects. Covering 10,654 cases over a decade (2012–2022), this study analyses an extensive dataset of accidental drug-related deaths in Connecticut. We process and analyze this data using Python and Tableau, we then use LSTM to predict how many people will show up in the designated intervals. The ages of individuals were stated as a mean value 43.52 (SD =12.60) years with a range between 13 and 87 years, bimodally distributed around the mid-30s to mid-50's. Overall, 74.14% were male and 85.48 % white in race/ethnicity. Significant increases were seen in accidental drug-related deaths. The most implicated substances were any opioids, fentanyl (alone or in combination), cocaine alone, heroin and ethanol. Crucially, some 89.05% of the cases had co-abuse with multiple drugs by one person who showed evidence that poly-substance use is commonplace in this community. Most deaths involved fentanyl (309, with a mode at 36 years (229 out of 309 deaths) and r (0.51) associated with ‘any opioid’, the primary cause of death). New Haven, Hartford and Fairfield counties stood out as hotspots for overdoses in geographic analysis. The LSTM model achieved a Root Mean Square Error (RMSE) of 7.25 and a Mean Absolute Error (MAE) of 5.62, predicting a sustained annual increase in deaths over the next three years. This federal and state partnership provides a model for using existing surveillance resources to inform targeted overdose intervention strategies, with an emphasis on the rise of fentanyl positivity among decedents.