Using the data below do an analysis of which state is doing the best job of treating patients. You must do at least the following: 1. Draw a color map showing only the US (not including Alaska) of the total number of COVID cases. You should pick a color scheme that highlights the differences. 2. Draw a symbol map showing only the US (not including Alaska) of the # of Deaths from COVID. This map should have an population overlay. 3. Draw figures illustrating which states have the best and worst COVID care as defined the % of COVID patients that die. This should look at total #s. a. What are the 3 best and 3 worst states? 4. Do the same analysis for the last 7 days? a. What are the 3 best and worst states for the last 7 days.

State/Territory	Total Cases	Confirmed Cases	Probable Cases	Cases in Last 7 Days	Case Rate per 100000	Total Deaths	Confirmed Deaths	Probable Deaths	Deaths in Last 7 Days	Death Rate per 100000	Case Rate per 100000 in Last 7 Days	Death Rate per 100K in Last 7 Days
Alaska	44406	null	null	1843	6070	199	null	null	16	27	36	0.3
Alabama	347897	281919	65978	23065	7095	4712	4120	592	323	96	67.2	0.9
Arkansas	216528	null	null	13421	7175	3537	null	null	242	117	63.5	1.2
American Samoa	3	null	null	0	5	0	null	null	0	0	0	0
Arizona	504423	481423	23000	43078	6930	8469	7693	776	497	116	84.6	1
California	2155976	null	null	263628	5456	24284	null	null	1608	61	95.3	0.6
Colorado	326668	313318	13350	15632	5673	4631	4001	630	262	80	38.8	0.7
Connecticut	181200	170642	10558	13823	5082	5904	4773	1131	228	165	55.4	0.9
District of Columbia	28342	null	null	1602	4016	771	null	null	29	109	32.4	0.6
Delaware	56189	53919	2270	5133	5770	898	798	100	27	92	75.3	0.4
Florida	1258315	null	null	65859	5859	21308	null	null	628	99	43.8	0.4
Federated States of Micronesia	0	0	0	0	0	0	null	null	0	0	0	0
Georgia	636240	546859	89381	44802	5992	10696	9719	977	297	100	60.3	0.4
Guam	7293	null	null	55	4400	121	null	null	0	72	4.7	0
Hawaii	20676	null	null	651	1460	283	null	null	3	19	6.6	0
Iowa	275883	null	null	7756	8744	3745	null	null	156	118	35.1	0.7
Idaho	137010	113735	23275	6133	7667	1377	1216	161	76	77	49	0.6
Illinois	942362	942362	0	37293	7437	17470	16074	1396	943	137	42	1.1
Indiana	496306	null	null	28087	7372	7886	7539	347	448	117	59.6	1
Kansas	216062	183192	32870	11462	7416	2548	null	null	100	87	56.2	0.5
Kentucky	258517	208615	49902	14220	5786	2563	2398	165	151	57	45.5	0.5
Louisiana	300539	null	null	13278	6465	7336	6980	356	229	157	40.8	0.7
Massachusetts	352660	342764	9896	27914	5117	12108	11900	208	394	175	57.9	0.8
Maryland	271061	null	null	15664	4484	5803	5636	167	284	95	37	0.7
Maine	22909	19582	3327	3624	1704	333	328	5	41	24	38.5	0.4
Michigan	519876	480508	39368	18761	5206	12754	12089	665	601	127	26.8	0.9
Minnesota	410138	null	null	10827	7272	5219	5003	216	288	92	27.4	0.7
Missouri	383616	null	null	15300	6250	5316	null	null	369	86	35.6	0.9
Northern Mariana Islands	122	122	0	6	0	2	2	0	0	3	1.5	0
Mississippi	210032	145829	64203	12341	7057	4719	3790	929	229	158	59.2	1.1
Montana	79999	79999	0	2675	7485	927	927	0	46	86	35.8	0.6
North Carolina	520716	478714	42002	37069	4965	6561	6186	375	321	62	50.5	0.4
North Dakota	91829	89041	2788	1376	12050	1276	null	null	38	167	25.8	0.7
Nebraska	162849	null	null	5746	8418	1587	null	null	86	82	42.4	0.6
New Hampshire	41670	null	null	4282	3065	715	null	null	59	52	45	0.6
New Jersey	463965	null	null	28202	5224	18651	16706	1945	428	209	45.4	0.7
New Mexico	138659	null	null	7851	6613	2380	null	null	200	113	53.5	1.4
Nevada	218377	null	null	12493	7090	2973	null	null	186	96	57.9	0.9
New York	521765	null	null	48527	4720	12263	null	null	704	110	62.7	0.9
New York City	423772	375114	48658	30787	5046	25057	20257	4800	289	298	52.4	0.5
Ohio	675044	608429	66615	45690	5775	8571	7791	780	449	73	55.8	0.6
Oklahoma	290319	235077	55242	17941	7337	2413	2260	153	162	60	64.8	0.6
Oregon	110545	108825	1720	6790	2621	1433	1418	15	86	33	23	0.3
Pennsylvania	613804	554904	58900	50215	4795	15086	null	null	1105	117	56	1.2
Puerto Rico	75790	71262	4528	5878	2373	1460	1209	251	69	45	26.3	0.3
Palau	0	null	null	0	0	0	null	null	0	0	0	0
Rhode Island	85602	null	null	5371	8080	1742	null	null	72	164	72.4	1
Republic of Marshall Islands	4	4	0	0	7	0	null	null	0	0	0	0
South Carolina	298050	275285	22765	22317	5789	5173	4782	391	211	100	61.9	0.6
South Dakota	97657	null	null	2583	11039	1446	1175	271	65	163	41.7	1.1
Tennessee	567792	502070	65722	38214	8314	6588	5766	822	452	96	79.9	1
Texas	1683426	null	null	91478	5806	26521	null	null	1106	91	45.1	0.5
Utah	266590	266590	0	13807	8316	1219	1197	22	58	38	61.5	0.3
Virginia	340297	287216	53081	25815	3987	4920	4340	580	215	57	43.2	0.4
Virgin Islands	2004	null	null	83	1914	23	null	null	0	21	11.3	0
Vermont	7120	null	null	586	1141	129	null	null	18	20	13.4	0.4
Washington	238672	null	null	12037	3134	3195	null	null	89	41	22.6	0.2
Wisconsin	510137	472153	37984	15784	8762	5060	4711	349	309	86	38.7	0.8
West Virginia	81436	66631	14805	8099	4544	1263	null	null	134	70	64.6	1.1
Wyoming	43704	37623	6081	1586	7551	405	405	0	54	69	39.2	1.3