Jump to content

User:Timeshifter/Sandbox179

From Wikipedia, the free encyclopedia

Column of state abbreviations copied from tables below

[edit]
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

[edit]
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

[edit]
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

[edit]
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

[edit]
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