博文

从美国新冠各州患病率简单看到的...

已有 2021 次阅读 2021-9-28 10:32 |系统分类:观点评述

心血来潮，从网站上把最新的美国新冠数据（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	Population	患病率
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