|
心血来潮,从网站上把最新的美国新冠数据(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个集中在佛罗里达州周边,这说明了什么呢?佛州旁边有啥?德堡?好吧...点到为止
Archiver|手机版|科学网 ( 京ICP备07017567号-12 )
GMT+8, 2024-10-20 05:00
Powered by ScienceNet.cn
Copyright © 2007- 中国科学报社