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

Main table updated. 1968-2019
For more info see: --Timeshifter (talk) 02:24, 14 March 2021 (UTC)
 * User:Timeshifter/Sandbox138

Updated overdose death rates and counts by state
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: State death counts:
 * User:Timeshifter/Sandbox141
 * 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)

2020 columns added to state tables
See: User:Timeshifter/Sandbox179.

Looking for help to quickly convert the state abbreviations to full names. See:
 * Village pump (technical).

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)


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

Tables and map updated
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)

Why is the picture of the penny there? Needs context
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)
 * I clarified the image caption. Hopefully that helps. --Timeshifter (talk) 23:37, 30 July 2023 (UTC)