Drug Overdose Death

Annual number of deaths in the United States from drug overdose per 100,000.

@kaggle.willianoliveiragibin_drug_overdose_death

Table List

1 table(7.74 KB)

Drug Overdose Death Rates New

@kaggle.willianoliveiragibin_drug_overdose_death.drug_overdose_death_rates_new

7.74 KB
22 rows
8 columns

entity Entity	code Code	year Year	any_opioid_death_rates_cdc_wonder Any Opioid Death Rates (CDC WONDER)	cocaine_overdose_death_rates_cdc_wonder Cocaine Overdose Death Rates (CDC WONDER)	heroin_overdose_death_rates_cdc_wonder Heroin Overdose Death Rates (CDC WONDER)	synthetic_opioids_death_rates_cdc_wonder Synthetic Opioids Death Rates (CDC WONDER)	prescription_opioids_death_rates_us_cdc_wonder Prescription Opioids Death Rates (US CDC WONDER)
United States	USA	1999	2.9	1.4	0.7	0.3	1.2
United States	USA	2000	3	1.3	0.7	0.3	1.3
United States	USA	2001	3.3	1.3	0.6	0.3	1.7
United States	USA	2002	4.1	1.6	0.7	0.4	2.3
United States	USA	2003	4.5	1.8	0.7	0.5	2.6
United States	USA	2004	4.7	1.9	0.6	0.6	2.9
United States	USA	2005	5.1	2.1	0.7	0.6	3.2
United States	USA	2006	5.9	2.5	0.7	0.9	3.9
United States	USA	2007	6.1	2.2	0.8	0.7	4.2
United States	USA	2008	6.4	1.7	1	0.8	4.3


CREATE TABLE drug_overdose_death_rates_new (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "any_opioid_death_rates_cdc_wonder" DOUBLE,
  "cocaine_overdose_death_rates_cdc_wonder" DOUBLE,
  "heroin_overdose_death_rates_cdc_wonder" DOUBLE,
  "synthetic_opioids_death_rates_cdc_wonder" DOUBLE,
  "prescription_opioids_death_rates_us_cdc_wonder" DOUBLE
);