心血来潮,从网站上把最新的美国新冠数据(2021-09-28)拷贝到Excel分析了一下,从患病率来看美国各州的分布情况,为避免统计学误差吧,仅统计300万人口以上的患病率,如下所示:
# USA Total New Total New Total Active Tot Cases/ Deaths/ Population 患病率
State Cases Cases Deaths Deaths Recovered Cases 1M pop 1M pop
10 Tennessee 1,217,394 2,061 14,952 18 1,151,165 51,277 178,264 2,189 6,829,174 0.178264
3 Florida 3,600,808 3,706 54,063
2,582,359 964,386 167,653 2,517 21,477,737 0.167653
16 South Carolina 850,188 2,270 12,213 7 600,485 237,490 165,126 2,372 5,148,714 0.165126
29 Arkansas 493,120 470 7,630 40 473,855 11,635 163,404 2,528 3,017,804 0.163404
20 Alabama 790,648 675 14,025 3 N/A N/A 161,252 2,860 4,903,185 0.161252
21 Louisiana 737,582 1,020 13,796 19 N/A N/A 158,661 2,968 4,648,794 0.158661
28 Utah 503,874 796 2,892 3 470,162 30,820 157,168 902 3,205,958 0.157168
26 Oklahoma 609,737 1,030 8,715
587,055 13,967 154,092 2,202 3,956,971 0.154092
23 Kentucky 680,454 1,721 8,579 19 N/A N/A 152,306 1,920 4,467,673 0.152306
31 Iowa 476,342
6,482
393,759 76,101 150,977 2,054 3,155,070 0.150977
13 Arizona 1,086,328 1,959 19,812
991,289 75,227 149,247 2,722 7,278,717 0.149247
6 Georgia 1,565,540 2,800 25,620 2 1,114,554 425,366 147,450 2,413 10,617,423 0.14745
14 Indiana 954,230 1,724 15,474
853,731 85,025 141,741 2,298 6,732,219 0.141741
2 Texas 4,030,693 5,995 64,659 89 3,655,012 311,022 139,009 2,230 28,995,881 0.139009
19 Wisconsin 800,507 1,532 8,813 2 N/A N/A 137,487 1,514 5,822,434 0.137487
32 Nevada 418,477 661 7,045
359,101 52,331 135,862 2,287 3,080,156 0.135862
17 Missouri 814,180 859 11,858
606,922 195,400 132,658 1,932 6,137,428 0.132658
9 North Carolina 1,382,231 2,665 16,235 43 1,297,563 68,433 131,791 1,548 10,488,084 0.131791
11 New Jersey 1,148,358 1,159 27,346 18 1,015,553 105,459 129,288 3,079 8,882,190 0.129288
4 New York 2,487,094 3,898 55,769 42 2,121,951 309,374 127,848 2,867 19,453,561 0.127848
5 Illinois 1,618,800 2,029 27,529 30 1,467,874 123,397 127,748 2,172 12,671,821 0.127748
22 Minnesota 699,966 2,784 8,191 49 672,634 19,141 124,116 1,452 5,639,632 0.124116
8 Ohio 1,393,696 3,681 21,820
1,245,186 126,690 119,230 1,867 11,689,100 0.11923
18 Massachusetts 807,182 1,451 18,555 5 N/A N/A 117,110 2,692 6,892,503 0.11711
1 California 4,610,276 5,521 68,944 54 2,434,036 2,107,296 116,680 1,745 39,512,223 0.11668
24 Colorado 665,469 1,437 7,800
549,472 108,197 115,558 1,354 5,758,736 0.115558
12 Michigan 1,141,370 2,907 22,244 10 917,827 201,299 114,287 2,227 9,986,857 0.114287
7 Pennsylvania 1,415,049 3,010 29,211 10 1,262,543 123,295 110,534 2,282 12,801,989 0.110534
34 Connecticut 389,177 1,444 8,483
357,409 23,285 109,157 2,379 3,565,287 0.109157
15 Virginia 857,852 1,997 12,592 18 N/A N/A 100,504 1,475 8,535,519 0.100504
27 Maryland 528,764 960 10,395 11 N/A N/A 87,461 1,719 6,045,680 0.087461
25 Washington 652,140 2,780 7,584 14 269,765 374,791 85,640 996 7,614,893 0.08564
35 Oregon 324,571 710 3,709 9 235,012 85,850 76,954 879 4,217,737 0.076954
52 Puerto Rico 180,720 149 3,133 1 142,193 35,394 53,358 925 3,386,941 0.053358
30 Mississippi 484,675 591 9,480 19 440,450 34,745 162,853 3,185 2,976,149 0.162853
33 Kansas 406,453 665 6,024 15 352,944 47,485 139,516 2,068 2,913,314 0.139516
38 New Mexico 250,774 662 4,764 5 221,152 24,858 119,597 2,272 2,096,829 0.119597
36 Nebraska 263,783 654 2,408 2 N/A N/A 136,364 1,245 1,934,408 0.136364
39 West Virginia 235,965 1,163 3,568 45 217,863 14,534 131,666 1,991 1,792,147 0.131666
37 Idaho 252,378 1,423 2,790 13 124,051 125,537 141,225 1,561 1,787,065 0.141225
49 Hawaii 78,404 255 757
N/A N/A 55,375 535 1,415,872 0.055375
45 New Hampshire 117,454
1,472
112,130 3,852 86,382 1,083 1,359,711 0.086382
48 Maine 87,189
1,013
N/A N/A 64,863 754 1,344,212 0.064863
41 Montana 147,287 1,252 1,973 28 134,307 11,007 137,809 1,846 1,068,778 0.137809
40 Rhode Island 171,451 191 2,832 4 N/A N/A 161,844 2,673 1,059,361 0.161844
43 Delaware 131,848 424 1,942
117,678 12,228 135,400 1,994 973,764 0.1354
42 South Dakota 143,183 383 2,129 4 133,466 7,588 161,851 2,407 884,659 0.161851
44 North Dakota 129,690 218 1,604
124,770 3,316 170,183 2,105 762,062 0.170183
46 Alaska 106,976 1,575 532
71,569 34,875 146,233 727 731,545 0.146233
50 District Of Columbia 60,772 567 1,174 2 N/A N/A 86,110 1,663 705,749 0.08611
51 Vermont 33,231 200 310
28,352 4,569 53,256 497 623,989 0.053256
47 Wyoming 88,935 1,069 955
82,763 5,217 153,665 1,650 578,759 0.153665
表格中密西西比州以下的为人口300万以下的数据,不列入讨论。
再贴一张美国的地图:
从表格中,对应地图去分析,患病率前10的州,有8个集中在佛罗里达州周边,这说明了什么呢?佛州旁边有啥?德堡?好吧...点到为止