Talk:United States drug overdose death rates and totals over time

	United States portal This article is within the scope of WikiProject United States, a collaborative effort to improve the coverage of topics relating to the United States of America on Wikipedia. If you would like to participate, please visit the project page, where you can join the ongoing discussions. Template Usage Articles Requested! Become a Member Project Talk Alerts United StatesWikipedia:WikiProject United StatesTemplate:WikiProject United StatesUnited States articles
Low	This article has been rated as Low-importance on the project's importance scale.

Pharmacology Low‑importance

	This article is within the scope of WikiProject Pharmacology, a collaborative effort to improve the coverage of Pharmacology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.PharmacologyWikipedia:WikiProject PharmacologyTemplate:WikiProject Pharmacologypharmacology articles
Low	This article has been rated as Low-importance on the project's importance scale.

Death Low‑importance

	This article is within the scope of WikiProject Death, a collaborative effort to improve the coverage of Death on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.DeathWikipedia:WikiProject DeathTemplate:WikiProject DeathDeath articles
Low	This article has been rated as Low-importance on the project's importance scale.

Main table updated. 1968-2019[edit]

For more info see:

User:Timeshifter/Sandbox138

--Timeshifter (talk) 02:24, 14 March 2021 (UTC)[reply]

Updated overdose death rates and counts by state[edit]

Pivot table function (from LibreOffice Calc) made this full update of all years possible. See the rates sandbox for how-to info. See also:

https://elearn.ellak.gr/mod/page/view.php?id=3015

State rates:

User:Timeshifter/Sandbox141

State death counts:

User:Timeshifter/Sandbox142

The most time-consuming problem was dealing with the 2-letter state abbreviations in the source file. See:

List of U.S. state and territory abbreviations.

LibreOffice Calc put the pivot table in alphabetical order of those 2-letter abbreviations. But that is not the same order as the full state names.

So I had to manually move the rows around in the Visual Editor. Then I could paste just the data next to the column of full state names. --Timeshifter (talk) 12:56, 9 April 2021 (UTC)[reply]

2020 columns added to state tables[edit]

See: User:Timeshifter/Sandbox179.

Looking for help to quickly convert the state abbreviations to full names. See:

Wikipedia:Village pump (technical)#Convert column of US state abbreviations to full names.

Please don't do it manually one-by-one. At least not until we see how the village pump discussion goes. --Timeshifter (talk) 08:01, 5 September 2022 (UTC)[reply]

Solution has been created. See: User:Qwerfjkl/scripts/convertAbbreviations. --Timeshifter (talk) 10:36, 12 September 2022 (UTC)[reply]

Tables and map updated[edit]

See: User:Timeshifter/Sandbox216 and User:Timeshifter/Sandbox215.

See Help:Table section on changing abbreviated state names to full names. --Timeshifter (talk) 23:39, 21 July 2023 (UTC)[reply]

Why is the picture of the penny there? Needs context[edit]

There may or may not be any relevance to the penny but as written it appears out of the blue. It seems to be comparing a lethal quantity (2 milligrams) of fentanyl to the diameter of a penny. This should be either deleted or whoever put the penny in should explain it. As it is it makes no sense. — Preceding unsigned comment added by 76.113.29.12 (talk) 16:54, 30 July 2023 (UTC)[reply]

I clarified the image caption. Hopefully that helps. --Timeshifter (talk) 23:37, 30 July 2023 (UTC)[reply]