Jump to content

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

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia

Main table updated. 1968-2019

[edit]

For more info see:

--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:

State rates:

State death counts:

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

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:

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]