User:Timeshifter/Sandbox179

• United States drug overdose death rates and totals over time#Overdose death rates by state. Map and timeline
• United States drug overdose death rates and totals over time#Overdose death counts by state over time.
• Help:Table#Converting rows to columns and columns to rows

Column of state abbreviations copied from tables below

STATE

AK

AL

AR

AZ

CA

CO

CT

DE

FL

GA

HI

IA

ID

IL

IN

KS

KY

LA

MA

MD

ME

MI

MN

MO

MS

MT

NC

ND

NE

NH

NJ

NM

NV

NY

OH

OK

OR

PA

RI

SC

SD

TN

TX

UT

VA

VT

WA

WI

WV

WY

Yearly death counts

States	1999	2005	2014	2015
Deaths	16,801	29,736	46,959	52,279

States	2016	2017	2018	2019	2020
Deaths	63,363	69,927	67,113	70,319	91,375

Pivot table results. Death counts

STATE	1999	2005	2014	2015	2016	2017	2018	2019	2020
AK	46	79	124	122	128	147	110	132	160
AL	169	283	723	736	756	835	775	768	1029
AR	113	269	1211	392	401	446	444	388	546
AZ	511	794	356	1274	1382	1532	1670	1907	2550
CA	2662	3214	4521	4659	4654	4868	5348	6198	8908
CO	349	608	899	869	942	1015	995	1079	1492
CT	310	295	623	800	971	1072	1069	1214	1371
DE	50	62	189	198	282	338	401	435	444
FL	997	2371	2634	3228	4728	5088	4698	5268	7231
GA	283	738	1206	1302	1394	1537	1404	1408	1916
HI	80	126	157	169	191	203	213	242	274
IA	53	141	264	309	314	341	287	352	432
ID	64	109	212	218	243	236	250	265	287
IL	825	1067	1705	1835	2411	2778	2722	2790	3549
IN	191	610	1172	1245	1526	1852	1629	1699	2321
KS	89	241	332	329	313	333	345	403	490
KY	197	638	1077	1273	1419	1566	1315	1380	2083
LA	188	661	777	861	996	1108	1140	1267	1896
MA	488	780	1289	1724	2227	2168	2241	2210	2302
MD	629	656	1070	1285	2044	2247	2324	2369	2771
ME	67	163	216	269	353	424	345	371	496
MI	460	985	1762	1980	2347	2694	2591	2385	2759
MN	136	282	517	581	672	733	636	792	1050
MO	276	608	1067	1066	1371	1367	1610	1583	1875
MS	87	248	336	351	352	354	310	394	586
MT	41	96	125	138	119	119	125	143	162
NC	366	1000	1358	1567	1956	2414	2259	2266	3146
ND	12	12	43	61	77	68	70	82	114
NE	39	86	125	126	120	152	138	161	214
NH	54	142	334	422	481	467	452	407	393
NJ	557	823	1253	1454	2056	2685	2900	2805	2840
NM	266	373	547	501	500	493	537	599	784
NV	227	457	545	619	665	676	688	647	832
NY	959	944	2300	2754	3638	3921	3697	3617	4965
OH	467	1243	2744	3310	4329	5111	3980	4251	5204
OK	178	478	777	725	813	775	716	645	762
OR	210	386	522	505	506	530	547	615	803
PA	990	1613	2732	3264	4627	5388	4415	4377	5168
RI	58	156	247	310	326	320	317	307	397
SC	147	427	701	761	879	1008	1125	1127	1739
SD	17	40	63	65	69	73	57	86	83
TN	344	872	1269	1457	1630	1776	1823	2089	3034
TX	1087	1910	2601	2588	2831	2989	3005	3136	4172
UT	205	438	603	646	635	650	624	571	622
VA	366	581	980	1039	1405	1507	1448	1547	2240
VT	29	53	83	99	125	134	153	133	190
WA	555	850	979	1094	1102	1169	1164	1259	1733
WI	212	518	853	878	1074	1177	1079	1201	1531
WV	75	184	627	725	884	974	856	870	1330
WY	20	26	109	96	99	69	66	79	99
Total Result	16801	29736	46959	52279	63363	69927	67113	70319	91375

Pivot table results. Death rates

STATE	1999	2005	2014	2015	2016	2017	2018	2019	2020
AK	7.5	11.4	16.8	16	16.8	20.2	14.6	17.8	22
AL	3.9	6.3	15.2	15.7	16.2	18	16.6	16.3	22.3
AR	4.4	10.1	18.2	13.8	14	15.5	15.7	13.5	19.1
AZ	10.6	14.1	12.6	19	20.3	22.2	23.8	26.8	35.8
CA	8.1	9	11.1	11.3	11.2	11.7	12.8	15	21.8
CO	8	12.7	16.3	15.4	16.6	17.6	16.8	18	24.9
CT	9	8.5	17.6	22.1	27.4	30.9	30.7	34.7	39.1
DE	6.4	7.5	20.9	22	30.8	37	43.8	48	47.3
FL	6.4	13.5	13.2	16.2	23.7	25.1	22.8	25.5	35
GA	3.5	8.2	11.9	12.7	13.3	14.7	13.2	13.1	18
HI	6.5	9.4	10.9	11.3	12.8	13.8	14.3	15.9	18.3
IA	1.9	4.8	8.8	10.3	10.6	11.5	9.6	11.5	14.3
ID	5.3	8.1	13.7	14.2	15.2	14.4	14.6	15.1	15.9
IL	6.7	8.4	13.1	14.1	18.9	21.6	21.3	21.9	28.1
IN	3.2	9.8	18.2	19.5	24	29.4	25.6	26.6	36.7
KS	3.4	9.1	11.7	11.8	11.1	11.8	12.4	14.3	17.4
KY	4.9	15.3	24.7	29.9	33.5	37.2	30.9	32.5	49.2
LA	4.3	14.7	16.9	19	21.8	24.5	25.4	28.3	42.7
MA	7.5	12	19	25.7	33	31.8	32.8	32.1	33.9
MD	11.4	11.4	17.4	20.9	33.2	36.3	37.2	38.2	44.6
ME	5.3	12.4	16.8	21.2	28.7	34.4	27.9	29.9	39.7
MI	4.6	9.8	18	20.4	24.4	27.8	26.6	24.4	28.6
MN	2.8	5.4	9.6	10.6	12.5	13.3	11.5	14.2	19
MO	5	10.7	18.2	17.9	23.6	23.4	27.5	26.9	32.1
MS	3.2	8.8	11.6	12.3	12.1	12.2	10.8	13.6	21.1
MT	4.6	10.1	12.4	13.8	11.7	11.7	12.2	14.1	15.6
NC	4.6	11.4	13.8	15.8	19.7	24.1	22.4	22.3	30.9
ND	0	0	6.3	8.6	10.6	9.2	10.2	11.4	15.6
NE	2.3	5	7.2	6.9	6.4	8.1	7.4	8.7	11.3
NH	4.3	10.7	26.2	34.3	39	37	35.8	32	30.3
NJ	6.5	9.4	14	16.3	23.2	30	33.1	31.7	32.1
NM	15	20.1	27.3	25.3	25.2	24.8	26.7	30.2	39
NV	11.5	18.7	18.4	20.4	21.7	21.6	21.2	20.1	26
NY	5	4.8	11.3	13.6	18	19.4	18.4	18.2	25.4
OH	4.2	10.9	24.6	29.9	39.1	46.3	35.9	38.3	47.2
OK	5.4	13.8	20.3	19	21.5	20.1	18.4	16.7	19.4
OR	6.1	10.4	12.8	12	11.9	12.4	12.6	14	18.7
PA	8.1	13.2	21.9	26.3	37.9	44.3	36.1	35.6	42.4
RI	5.5	14.3	23.4	28.2	30.8	31	30.1	29.5	38.2
SC	3.7	9.9	14.4	15.7	18.1	20.5	22.6	22.7	34.9
SD	0	5.5	7.8	8.4	8.4	8.5	6.9	10.5	10.3
TN	6.1	14.5	19.5	22.2	24.5	26.6	27.5	31.2	45.6
TX	5.4	8.5	9.7	9.4	10.1	10.5	10.4	10.8	14.1
UT	10.6	19.3	22.4	23.4	22.4	22.3	21.2	18.9	20.5
VA	5	7.5	11.7	12.4	16.7	17.9	17.1	18.3	26.6
VT	4.7	8.5	13.9	16.7	22.2	23.2	26.6	23.8	32.9
WA	9.3	13	13.3	14.7	14.5	15.2	14.8	15.8	22
WI	4	9.3	15.1	15.5	19.3	21.2	19.2	21.1	27.7
WV	4.1	10.5	35.5	41.5	52	57.8	51.5	52.8	81.4
WY	4.1	4.9	19.4	16.4	17.6	12.2	11.1	14.1	17.4

From CSV file

• https://www.cdc.gov/nchs/pressroom/sosmap/drug_poisoning_mortality/drug_poisoning.htm

YEAR	STATE	RATE	DEATHS
2020	AL	22.3	1029
2020	AK	22	160
2020	AZ	35.8	2550
2020	AR	19.1	546
2020	CA	21.8	8908
2020	CO	24.9	1492
2020	CT	39.1	1371
2020	DE	47.3	444
2020	FL	35	7231
2020	GA	18	1916
2020	HI	18.3	274
2020	ID	15.9	287
2020	IL	28.1	3549
2020	IN	36.7	2321
2020	IA	14.3	432
2020	KS	17.4	490
2020	KY	49.2	2083
2020	LA	42.7	1896
2020	ME	39.7	496
2020	MD	44.6	2771
2020	MA	33.9	2302
2020	MI	28.6	2759
2020	MN	19	1050
2020	MS	21.1	586
2020	MO	32.1	1875
2020	MT	15.6	162
2020	NE	11.3	214
2020	NV	26	832
2020	NH	30.3	393
2020	NJ	32.1	2840
2020	NM	39	784
2020	NY	25.4	4965
2020	NC	30.9	3146
2020	ND	15.6	114
2020	OH	47.2	5204
2020	OK	19.4	762
2020	OR	18.7	803
2020	PA	42.4	5168
2020	RI	38.2	397
2020	SC	34.9	1739
2020	SD	10.3	83
2020	TN	45.6	3034
2020	TX	14.1	4172
2020	UT	20.5	622
2020	VT	32.9	190
2020	VA	26.6	2240
2020	WA	22	1733
2020	WV	81.4	1330
2020	WI	27.7	1531
2020	WY	17.4	99
2019	AL	16.3	768
2019	AK	17.8	132
2019	AZ	26.8	1907
2019	AR	13.5	388
2019	CA	15	6198
2019	CO	18	1079
2019	CT	34.7	1214
2019	DE	48	435
2019	FL	25.5	5268
2019	GA	13.1	1408
2019	HI	15.9	242
2019	ID	15.1	265
2019	IL	21.9	2790
2019	IN	26.6	1699
2019	IA	11.5	352
2019	KS	14.3	403
2019	KY	32.5	1380
2019	LA	28.3	1267
2019	ME	29.9	371
2019	MD	38.2	2369
2019	MA	32.1	2210
2019	MI	24.4	2385
2019	MN	14.2	792
2019	MS	13.6	394
2019	MO	26.9	1583
2019	MT	14.1	143
2019	NE	8.7	161
2019	NV	20.1	647
2019	NH	32	407
2019	NJ	31.7	2805
2019	NM	30.2	599
2019	NY	18.2	3617
2019	NC	22.3	2266
2019	ND	11.4	82
2019	OH	38.3	4251
2019	OK	16.7	645
2019	OR	14	615
2019	PA	35.6	4377
2019	RI	29.5	307
2019	SC	22.7	1127
2019	SD	10.5	86
2019	TN	31.2	2089
2019	TX	10.8	3136
2019	UT	18.9	571
2019	VT	23.8	133
2019	VA	18.3	1547
2019	WA	15.8	1259
2019	WV	52.8	870
2019	WI	21.1	1201
2019	WY	14.1	79
2018	AL	16.6	775
2018	AK	14.6	110
2018	AZ	23.8	1670
2018	AR	15.7	444
2018	CA	12.8	5348
2018	CO	16.8	995
2018	CT	30.7	1069
2018	DE	43.8	401
2018	FL	22.8	4698
2018	GA	13.2	1404
2018	HI	14.3	213
2018	ID	14.6	250
2018	IL	21.3	2722
2018	IN	25.6	1629
2018	IA	9.6	287
2018	KS	12.4	345
2018	KY	30.9	1315
2018	LA	25.4	1140
2018	ME	27.9	345
2018	MD	37.2	2324
2018	MA	32.8	2241
2018	MI	26.6	2591
2018	MN	11.5	636
2018	MS	10.8	310
2018	MO	27.5	1610
2018	MT	12.2	125
2018	NE	7.4	138
2018	NV	21.2	688
2018	NH	35.8	452
2018	NJ	33.1	2900
2018	NM	26.7	537
2018	NY	18.4	3697
2018	NC	22.4	2259
2018	ND	10.2	70
2018	OH	35.9	3980
2018	OK	18.4	716
2018	OR	12.6	547
2018	PA	36.1	4415
2018	RI	30.1	317
2018	SC	22.6	1125
2018	SD	6.9	57
2018	TN	27.5	1823
2018	TX	10.4	3005
2018	UT	21.2	624
2018	VT	26.6	153
2018	VA	17.1	1448
2018	WA	14.8	1164
2018	WV	51.5	856
2018	WI	19.2	1079
2018	WY	11.1	66
2017	AL	18	835
2017	AK	20.2	147
2017	AZ	22.2	1532
2017	AR	15.5	446
2017	CA	11.7	4868
2017	CO	17.6	1015
2017	CT	30.9	1072
2017	DE	37	338
2017	FL	25.1	5088
2017	GA	14.7	1537
2017	HI	13.8	203
2017	ID	14.4	236
2017	IL	21.6	2778
2017	IN	29.4	1852
2017	IA	11.5	341
2017	KS	11.8	333
2017	KY	37.2	1566
2017	LA	24.5	1108
2017	ME	34.4	424
2017	MD	36.3	2247
2017	MA	31.8	2168
2017	MI	27.8	2694
2017	MN	13.3	733
2017	MS	12.2	354
2017	MO	23.4	1367
2017	MT	11.7	119
2017	NE	8.1	152
2017	NV	21.6	676
2017	NH	37	467
2017	NJ	30	2685
2017	NM	24.8	493
2017	NY	19.4	3921
2017	NC	24.1	2414
2017	ND	9.2	68
2017	OH	46.3	5111
2017	OK	20.1	775
2017	OR	12.4	530
2017	PA	44.3	5388
2017	RI	31	320
2017	SC	20.5	1008
2017	SD	8.5	73
2017	TN	26.6	1776
2017	TX	10.5	2989
2017	UT	22.3	650
2017	VT	23.2	134
2017	VA	17.9	1507
2017	WA	15.2	1169
2017	WV	57.8	974
2017	WI	21.2	1177
2017	WY	12.2	69
2016	AL	16.2	756
2016	AK	16.8	128
2016	AZ	20.3	1382
2016	AR	14	401
2016	CA	11.2	4654
2016	CO	16.6	942
2016	CT	27.4	971
2016	DE	30.8	282
2016	FL	23.7	4728
2016	GA	13.3	1394
2016	HI	12.8	191
2016	ID	15.2	243
2016	IL	18.9	2411
2016	IN	24	1526
2016	IA	10.6	314
2016	KS	11.1	313
2016	KY	33.5	1419
2016	LA	21.8	996
2016	ME	28.7	353
2016	MD	33.2	2044
2016	MA	33	2227
2016	MI	24.4	2347
2016	MN	12.5	672
2016	MS	12.1	352
2016	MO	23.6	1371
2016	MT	11.7	119
2016	NE	6.4	120
2016	NV	21.7	665
2016	NH	39	481
2016	NJ	23.2	2056
2016	NM	25.2	500
2016	NY	18	3638
2016	NC	19.7	1956
2016	ND	10.6	77
2016	OH	39.1	4329
2016	OK	21.5	813
2016	OR	11.9	506
2016	PA	37.9	4627
2016	RI	30.8	326
2016	SC	18.1	879
2016	SD	8.4	69
2016	TN	24.5	1630
2016	TX	10.1	2831
2016	UT	22.4	635
2016	VT	22.2	125
2016	VA	16.7	1405
2016	WA	14.5	1102
2016	WV	52	884
2016	WI	19.3	1074
2016	WY	17.6	99
2015	AL	15.7	736
2015	AK	16	122
2015	AZ	19	1274
2015	AR	13.8	392
2015	CA	11.3	4659
2015	CO	15.4	869
2015	CT	22.1	800
2015	DE	22	198
2015	FL	16.2	3228
2015	GA	12.7	1302
2015	HI	11.3	169
2015	ID	14.2	218
2015	IL	14.1	1835
2015	IN	19.5	1245
2015	IA	10.3	309
2015	KS	11.8	329
2015	KY	29.9	1273
2015	LA	19	861
2015	ME	21.2	269
2015	MD	20.9	1285
2015	MA	25.7	1724
2015	MI	20.4	1980
2015	MN	10.6	581
2015	MS	12.3	351
2015	MO	17.9	1066
2015	MT	13.8	138
2015	NE	6.9	126
2015	NV	20.4	619
2015	NH	34.3	422
2015	NJ	16.3	1454
2015	NM	25.3	501
2015	NY	13.6	2754
2015	NC	15.8	1567
2015	ND	8.6	61
2015	OH	29.9	3310
2015	OK	19	725
2015	OR	12	505
2015	PA	26.3	3264
2015	RI	28.2	310
2015	SC	15.7	761
2015	SD	8.4	65
2015	TN	22.2	1457
2015	TX	9.4	2588
2015	UT	23.4	646
2015	VT	16.7	99
2015	VA	12.4	1039
2015	WA	14.7	1094
2015	WV	41.5	725
2015	WI	15.5	878
2015	WY	16.4	96
2014	AL	15.2	723
2014	AK	16.8	124
2014	AZ	12.6	356
2014	AR	18.2	1211
2014	CA	11.1	4521
2014	CO	16.3	899
2014	CT	17.6	623
2014	DE	20.9	189
2014	FL	13.2	2634
2014	GA	11.9	1206
2014	HI	10.9	157
2014	ID	13.7	212
2014	IL	13.1	1705
2014	IN	18.2	1172
2014	IA	8.8	264
2014	KS	11.7	332
2014	KY	24.7	1077
2014	LA	16.9	777
2014	ME	16.8	216
2014	MD	17.4	1070
2014	MA	19	1289
2014	MI	18	1762
2014	MN	9.6	517
2014	MS	11.6	336
2014	MO	18.2	1067
2014	MT	12.4	125
2014	NE	7.2	125
2014	NV	18.4	545
2014	NH	26.2	334
2014	NJ	14	1253
2014	NM	27.3	547
2014	NY	11.3	2300
2014	NC	13.8	1358
2014	ND	6.3	43
2014	OH	24.6	2744
2014	OK	20.3	777
2014	OR	12.8	522
2014	PA	21.9	2732
2014	RI	23.4	247
2014	SC	14.4	701
2014	SD	7.8	63
2014	TN	19.5	1269
2014	TX	9.7	2601
2014	UT	22.4	603
2014	VT	13.9	83
2014	VA	11.7	980
2014	WA	13.3	979
2014	WV	35.5	627
2014	WI	15.1	853
2014	WY	19.4	109
2005	AL	6.3	283
2005	AK	11.4	79
2005	AZ	14.1	794
2005	AR	10.1	269
2005	CA	9	3214
2005	CO	12.7	608
2005	CT	8.5	295
2005	DE	7.5	62
2005	FL	13.5	2371
2005	GA	8.2	738
2005	HI	9.4	126
2005	ID	8.1	109
2005	IL	8.4	1067
2005	IN	9.8	610
2005	IA	4.8	141
2005	KS	9.1	241
2005	KY	15.3	638
2005	LA	14.7	661
2005	ME	12.4	163
2005	MD	11.4	656
2005	MA	12	780
2005	MI	9.8	985
2005	MN	5.4	282
2005	MS	8.8	248
2005	MO	10.7	608
2005	MT	10.1	96
2005	NE	5	86
2005	NV	18.7	457
2005	NH	10.7	142
2005	NJ	9.4	823
2005	NM	20.1	373
2005	NY	4.8	944
2005	NC	11.4	1000
2005	ND	0	12
2005	OH	10.9	1243
2005	OK	13.8	478
2005	OR	10.4	386
2005	PA	13.2	1613
2005	RI	14.3	156
2005	SC	9.9	427
2005	SD	5.5	40
2005	TN	14.5	872
2005	TX	8.5	1910
2005	UT	19.3	438
2005	VT	8.5	53
2005	VA	7.5	581
2005	WA	13	850
2005	WV	10.5	184
2005	WI	9.3	518
2005	WY	4.9	26
1999	AL	3.9	169
1999	AK	7.5	46
1999	AZ	10.6	511
1999	AR	4.4	113
1999	CA	8.1	2662
1999	CO	8	349
1999	CT	9	310
1999	DE	6.4	50
1999	FL	6.4	997
1999	GA	3.5	283
1999	HI	6.5	80
1999	ID	5.3	64
1999	IL	6.7	825
1999	IN	3.2	191
1999	IA	1.9	53
1999	KS	3.4	89
1999	KY	4.9	197
1999	LA	4.3	188
1999	ME	5.3	67
1999	MD	11.4	629
1999	MA	7.5	488
1999	MI	4.6	460
1999	MN	2.8	136
1999	MS	3.2	87
1999	MO	5	276
1999	MT	4.6	41
1999	NE	2.3	39
1999	NV	11.5	227
1999	NH	4.3	54
1999	NJ	6.5	557
1999	NM	15	266
1999	NY	5	959
1999	NC	4.6	366
1999	ND	0	12
1999	OH	4.2	467
1999	OK	5.4	178
1999	OR	6.1	210
1999	PA	8.1	990
1999	RI	5.5	58
1999	SC	3.7	147
1999	SD	0	17
1999	TN	6.1	344
1999	TX	5.4	1087
1999	UT	10.6	205
1999	VT	4.7	29
1999	VA	5	366
1999	WA	9.3	555
1999	WV	4.1	75
1999	WI	4	212
1999	WY	4.1	20