Race Data Entry - Google Drive


1	20210622				0	0	Positives															Deaths															Tests (totals as of 9/9)															Hospitalizations															Notes	DASHBOARD CONTROL PANEL - Please ask AFG or AGS to doublecheck any changes
2	20210622			CURRENT TIME: 6/22 8:20			5	Race										Ethnicity				73,462	Race										Ethnicity					Race										Ethnicity					Race										Ethnicity					Cases					Deaths					Cases				Deaths
3	Date	State	Update Time	Last Check	Checker	Doublechecker	Total Positives	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Deaths	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknown	Total N. Tests	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Hosp.	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown		Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Reports any case data?	Reports combined race/ethnicity?	Reports race alone?	Reports ethnicity alone?	Reports any deaths data?	Reports combined race/ethnicity?	Reports race alone?	Reports ethnicity alone?

4	20210622	AK	3/04 23:59	3/7/21 21:17	BML	TRW	59332	18300	1499		2447	12238	1508	4453	7130	11757	20%	3197	29625	26510	45%	305	127	9		29	111	17	4	1	7	2%	13	280	12	4%																1293	423	45		116	336	126	67	54	126	0	66	939	288	0		59,332	47,575	80%	32,822	55%	305	298	98%	293	96%
5	20210622	AL	3/07 10:00	3/7/21 21:12	TMB	BML	499819	160347	82790		2273				38000	216409	43%	12312	167064	320443	64%	10148	4730	2223		24				300	2871	28%	137	6083	3928	39%																															(TMB 1/17) Unknown Ethnicity deaths needs to be updated to respond to percentages, not exact counts. (TMB 1/24) Per dashboard: "We are experiencing issues with the data for the Last 14 Days Cases indicator and Tab 5, Number of Cases by County reported in the Last 14 Days. We are working to correct the issue. Thank you for your patience." (TMB 1/24) Hispanic/Latino Death % is significantly rounded. Record state reported percentage to right of death count. (CLM 2/21) Demographic data not updated due to error in dashboard	499,819	283,410	57%	179,376	36%	10,148	7,277	72%	6,220	61%
6	20210622	AR	3/07 00:00	3/7/21 21:16	EPC	BML	324818	207596	50842		2913	1070	3358	1804	16491	40744	13%	34332	290486	0	0%	5319	4171	784		36	18	56	13	203	38	1%	186	5133	0	0%																															(CLM 02/28) Total deaths decreased by 174 due to data clean-up and deduplication on AR's end.	324,818	284,074	87%	284,074	87%	5,319	5,281	99%	5,319	100%
7	20210622	AS	12/01 17:00	3/7/21 21:18	TMB	BML											100%				100%											100%				100%
8	20210622	AZ	3/07 00:00	3/7/21 21:13	SPA	AFG	826454	308453	25775	244539	11921	40707			46964	148095	18%	244539	433820	148095	18%	16328	8066	433	4684	220	1361			465	1099	7%	4684	10545	1099	7%																57907	26710	2479	18730	1015	4496			2562	1915	0	18730	37262	1915	0		826,454	678,359	82%	678,359	82%	16,328	15,229	93%	15,229	93%
9	20210622	CA	3/07 14:00	3/7/21 21:14	IKP	CLM	3501394	546630	111279	1509103	186562	9025	15281	42824	304477	776213	22%	1509103	1216078	776213	22%	54124	16586	3275	24402	6105	184	322	693	1103	1454	3%	24402	28268	1454	3%	49646014	9172498	1730660	9444459	3980518	98894	222513	74171	6354689	18567612	0	9444459	21633943	18567612																	Checkers: Enter testing total. DCers: Double check prepopulated cases and deaths totals and testing total.	3,501,394	2,725,181	78%	2,725,181	78%	54,124	52,670	97%	52,670	97%
10	20210622	CO	3/06 23:59	3/7/21 21:18	SPA	CLM	435762	181669	12637	119224	6406	2527	1264	6580	3312	102143	23%	119224	214395	102143	23%	5986	3869	191	1204	115	37	9	186	38	337	6%	1204	4445	337	6%																															None	435,762	333,619	77%	333,619	77%	5,986	5,649	94%	5,649	94%
11	20210622	CT	3/04 00:00	3/7/21 21:17	TMB	TRW	285330	85469	19651	41523	3019	393		17642	15284	102349	36%	41523	141458	102349	36%	7704	5413	906	782	83	3		353	38	126	2%	782	6796	126	2%																															#REF!	285,330	182,981	64%	182,981	64%	7,704	7,578	98%	7,578	98%
12	20210622	DC	3/06 00:00	3/7/21 21:22	EPC	PK	41419	10708	20164		914	86	82		9148	317	1%	8455	30131	2833	7%	1030	105	773	119	14				0	19	2%	119	892	19	2%																															https://coronavirus.dc.gov/page/coronavirus-data	41,419	41,102	99%	38,586	93%	1,030	1,011	98%	1,011	98%
13	20210622	DE	3/07 12:19	3/7/21 21:20	IKP	BML	88354	42730	19768	14532	1842				5190	4292	5%	14532	69530	4292	5%	1473	1036	329	80	11				15	2	0%	80	1391	2	0%	633424	311489	118013	55204	16091				58282	74345	0	55204	503875	74345	0																https://myhealthycommunity.dhss.delaware.gov/locations/state	88,354	84,062	95%	84,062	95%	1,473	1,471	100%	1,471	100%
14	20210622	FL	3/06 23:59	3/7/21 21:11	RSG	CLM	1944995	664121	237772	608165					141809	293128	15%	608165	917573	419257	22%	32266	17316	4812	7325					1427	1386	4%	7325	22180	2761	9%																82237	38131	16138	20583					4284	3101	0	20583	56406	5248	0		1,944,995	1,651,867	85%	1,525,738	78%	32,266	30,880	96%	29,505	91%
15	20210622	GA	3/07 14:50	3/7/21 21:24	TMB	PK	1023487	319208	216068	85460	17888	504	746		36133	347480	34%	85460	501639	436388	43%	17906	8939	5282	852	298	10	10		78	2437	14%	852	14534	2520	14%																56797	24335	22046	6155	1029	20	69		1076	2067	0	6155	46118	4524	0		1,023,487	676,007	66%	587,099	57%	17,906	15,469	86%	15,386	86%
16	20210622	GU	3/05 11:34	3/7/21 21:26	TMB	PK	7749	418			2276		3993		435	627	8%			7748	100%	133	3			33		79		4	14	11%			133	100%																															(TMB 1/27)	7,749	7,122	92%	0	0%	133	119	89%	0	0%
17	20210622	HI	3/01 00:00	3/7/21 21:19	RSG	CLM	27891	3646	580		6068		8008		1035	8554	31%			27891	100%	445	40	4		244		137		6	14	3%			445	100%																2226	151	15		521		660		38	841	0			841	1		27,891	19,337	69%	0	0%	445	431	97%	0	0%
18	20210622	IA	3/07 00:00	3/7/21 22:09	ATD	BML	339671	200406	10190		3397	888	824		2379	121587	36%	20380	190216	129075	38%	5558	5154	134		61	19	16		47	127	2%	138	5420	0	0%																															Other includes invididuals who report multiple races.	339,671	218,084	64%	210,596	62%	5,558	5,431	98%	5,558	100%
19	20210622	ID	3/06 16:57	3/7/21 21:25	EPC	RSG	172931	99914	1008		1219	2054	409		13191	55136	32%	17344	73958	81629	47%	1879	1761	9		17	35			41	16	1%	186	1682	11	1%																															notes	172,931	117,795	68%	91,302	53%	1,879	1,863	99%	1,868	99%
20	20210622	IL	3/07 00:00	3/7/21 21:31	EPC	CLM	1198335	470333	110701	219967	27074	1492	1125		41054	326589	27%	219967	651779	326589	27%	23014	12202	3668	3291	737	26	20		120	2950	13%	3291	16773	2950	13%	18640190	6066122	1362411	1263482	720684	15305	18976		534214	8658996	0	1263482	8717712	8658996	0																Illinois' reported tests by race and ethnicity are in units of specimens.	1,198,335	871,746	73%	871,746	73%	23,014	20,064	87%	20,064	87%
21	20210622	IN	3/06 11:59	3/7/21 21:30	TMB	BML	667262	452265	44471		8987				72744	88795	13%	38378	350560	278324	42%	12737	9096	939		70				1591	1041	8%	275	6823	5639	44%	3150418	2172766	239719		59652				381330	296951	0	121315	1536679	1492424	0																Indiana's reported tests by race and ethnicity are in units of people. Race is only reported for confirmed deaths, probable are included in "Unknown"	667,262	578,467	87%	388,938	58%	12,737	11,696	92%	7,098	56%
22	20210622	KS	3/05 09:00	3/7/21 21:27	SPA	TRW	295861	209752	14330		5525	2074			12197	51983	18%	39177	182461	74,223	25%	4812	3721	235		64	38			245	509	11%	310	3795	707	15%	1270547	806291	61246		24634	8140			45244	324992	0	95804	699286	475457	0	9387	7118	752		173	67			623	654	0	1350	7167	870	0	Kansas' reported tests by race and ethnicity are in units of people.	295,861	243,878	82%	221,638	75%	4,812	4,303	89%	4,105	85%
23	20210622	KY	3/07 00:00	3/7/21 21:33	TMB	CLM	410709	286431	26883		3680	833	374	16253		76255	19%	17452	300330	92,927	23%	4819	3981	371		23	4	2	118		320	7%	73	4219	527	11%																																410,709	334,454	81%	317,782	77%	4,819	4,499	93%	4,292	89%
24	20210622	LA	3/01 00:00	3/7/21 21:11	BML	PK	433785	218332	136460		16684	1527	492		34552	25738	6%			433,785	100%	9748	5798	3723		75	15	13		39	85	1%	238	8966	544	6%																																433,785	408,047	94%	0	0%	9,748	9,663	99%	9,204	94%
25	20210622	MA	3/06 23:59	3/7/21 22:03	ATD	CB-M	591356	219467	35342	125873	16039	504	156		47605	146370	25%	125873	319113	146370	25%	16417	12022	1069	1289	414	11	5		1373	234	1%	1289	14894	234	1%																19713	10414	1900	3041	709	10	7		1957	1675	0	3041	14997	1675	0		591,356	444,986	75%	444,986	75%	16,417	16,183	99%	16,183	99%
26	20210622	MD	3/07 11:00	3/7/21 21:34	TMB	PK	387319	134697	112033	62261	8867				18321	51140	13%	62261	273918	51140	13%	7955	4078	2736	727	277				80	57	1%	727	7171	57	1%																																387,319	336,179	87%	336,179	87%	7,955	7,898	99%	7,898	99%
27	20210622	ME	2/28 00:00	3/7/21 21:38	EPC	PK	45794	36271	2252		502	139	26	178	907	5519	12%	695	31103	13996	31%	706	602	10		3	5	0	1	6	79	11%	6	491	209	30%																1570	1359	63		22	7	0	3	30	86	0	22	1354	194	0	Death and hospitalization data lags the cases, currently updating 2 days behind	45,794	40,275	88%	31,798	69%	706	627	89%	497	70%
28	20210622	MI	3/06 00:00	3/7/21 21:39	SPA	PK	656072	378135	74321		10362	3596		25954	35465	128239	20%	33855	421946	200271	31%	16658	11205	3634		179	79		270	425	866	5%	480	13206	2972	18%																															Thanks to communication with Michigan's public health department on Aug. 24, we learned that the ethnicity charts below the state dashboard refer to confirmed cases and deaths only. We had previously been calculating our ethnicity counts based on total cases and deaths, and our correction to use the confirmed values caused our ethnicity counts to drop. On Oct. 28, Michigan specified that deaths data are suppressed when the number of deaths is five or below, in order to protect the confidentiality of individuals. For this reason, the sum of probable deaths by race does not add up to Michigan's reported total probable deaths.	656,072	527,833	80%	455,801	69%	16,658	15,792	95%	13,686	82%
29	20210622	MN	3/06 16:00	3/7/21 21:45	TMB	BML	490011	327714	39044	43792	21470	4634	556	8424	6470	37907	8%	43792	408312	37907	8%	6550	5440	319	203	259	90	6	101	23	109	2%	203	6238	109	2%																25978	16798	3007	2202	1470	457	31	665	237	1111	0	2202	22665	1111	0	MN reports race and ethnicity data for hospitalizations only once a week on Thursdays. As of 8/20, MN incorporated ethnicity data into race categories, differences from before and after this point may reflect differences in reporting	490,011	452,104	92%	452,104	92%	6,550	6,441	98%	6,441	98%
30	20210622	MO	3/06 23:59	3/7/21 21:49	EPC	PK	480643	252254	42276		4317	942	22	108	63952	116772	24%	17167	259531	203945	42%	8161	5162	1069		67	12	1	0	1295	555	7%	170	6395	1596	20%	4565866	1781880	355094		44514	6838	40	192	1602892	774416	0	81100	2166194	2318572	1																Missouri's figures for tests by race and ethnicity are reported in units specimens, not people.	480,643	363,871	76%	276,698	58%	8,161	7,606	93%	6,565	80%
31	20210622	MP	3/07 00:00	3/7/21 22:23	ATD	PK	145									145	100%					2									2	100%																																				145	0	0%	0	0%	2	0	0%	0	0%
32	20210622	MS	3/06 15:00	3/7/21 21:45	ATD	BML	297581	140893	97848	6525	1415	2215			10036	38649	13%	6525	202316	88740	30%	6808	3670	2671	60	18	114			103	172	3%	60	5599	1149	17%																															Other includes races other than those specifically defined plus Multiracial if a person has identified as multiple races.	297,581	258,932	87%	208,841	70%	6,808	6,636	97%	5,659	83%
33	20210622	MT	3/06 23:59	3/7/21 21:36	RSG	PK	100914	63627	460		342	8156	114		6782	21433	21%	2323	62230	36361	36%	1381	856	1		1	205	1		121	196	14%	25	905	451	33%																4630	2233	23			453				1921	0					Demographic data for hospitalizations lag other updates, often by several weeks.	100,914	79,481	79%	64,553	64%	1,381	1,185	86%	0	0%
34	20210622	NC	3/06 11:35	3/7/21 21:35	TR	CLM	872176	442322	146993		13620	11199			98470	159572	18%	118914	441831	311431	36%	11502	7160	2662		120	126			716	718	6%	803	8916	1783	16%																															NC is currently combining Native Hawaiian or Other Pacific Islander (NHOPI) and Asian into a single race demographic.	872,176	712,604	82%	560,745	64%	11,502	10,784	94%	9,719	84%
35	20210622	ND	3/06 23:59	3/7/21 22:11	RSG	CB-M	100391	55720	2881		1317	4376		1377	28	34692	35%			100391	100%	1478									1478	100%			1478	100%																																100,391	65,699	65%	0	0%	1,478	0	0%	0	0%
36	20210622	NE	3/07 09:15	3/7/21 21:53	ATD	TRW	203026	55120	2259		1483	818	75		2170	141101	69%	13366	37882	151778	75%	2113	1359	58		30	25	1		27	613	29%	163	1094	856	41%																6237	3281	225		120	78	7		151	2375	0	870	2618	2749	0		203,026	61,925	31%	51,248	25%	2,113	1,500	71%	1,257	59%
37	20210622	NH	3/07 00:00	3/7/21 21:58	EPC	NJR	76861	39457	1025	4157	1036	87	0	394	2066	28639	37%	4157	44065	28639	37%	1184	1110	13	30	12	1	0	2	12	4	0%	30	1150	4	0%																1131	865	38	99	40				25	64	0	99	968	64	0		76,861	48,222	63%	48,222	63%	1,184	1,180	100%	1,180	100%
38	20210622	NJ	3/07 15:00	3/7/21 21:28	CB-M	PK	812609	268537	69860	161066	30370				107239	175537	22%	161066	476006	175537	22%	23574	12932	3743	4338	1178				912	471	2%	4338	18765	471	2%																64396	26086	11312	15832	2843				4241	4082	0	15832	44482	4082	0	NJ updates demographics for mortality data once a week As of 1/6/2021, New Jersey's Case counts include both Confirmed and Probable numbers for demographics. This results in a 50k case count bump.	812,609	637,072	78%	637,072	78%	23,574	23,103	98%	23,103	98%
39	20210622	NM	3/07 15:37	3/7/21 21:12	CLM	PK	186922	32321	2360	87747	1688	30459	288		4912	27147	15%	87747	72028	27147	15%	3808	1097	49	1471	27	1064				100	3%	1471	2237	100	3%																13252	2460	141	4885	118	3966	24		177	1481	0	4885	6886	1481	0		186,922	159,775	85%	159,775	85%	3,808	3,708	97%	0	0%
40	20210622	NV	3/06 00:00	3/7/21 21:29	TR	MBL	296190	108109	22510	106628	24287	1480			33173	3	0%	106628	189559	3	0%	5037	2719	468	1203	594	45			5	3	0%	1203	3831	3	0%	1427948	675419	137083	249890	99956	11423			254174	3	0	249890	1178055	3	0																Nevada's reported tests by race and ethnicity are in units of people.	296,190	296,187	100%	296,187	100%	5,037	5,034	100%	5,034	100%
41	20210622	NY	3/07 00:00	3/7/21 21:21	AFG	PK	1681169									1681169	100%			1681169	100%	48591	17007	9812	9968	3011				2834	5959	12%	9968	32664	5959	12%																89995	21649	23650	28494	8213					7989	0	28494	53512	7989	0	NYC combines Fatality reporting for Asian and Pacific Islander. Data presented for NYC is reported by NYC.	1,681,169	0	0%	0	0%	48,591	42,632	88%	42,632	88%
42	20210622	OH	3/07 14:00	3/7/21 22:06	TR	RSG	978471	579544	101785		13511	1055	693	23359	53199	205325	21%	30674	618476	329321	34%	17656	15026	2157		139	16	3	26	129	160	1%	302	17199	155	1%																50881	35458	9272		631	65	55	1691	1290	2419	0	1710	42785	6386	0	Ohio included 'as many as 4,000 COVID-19 deaths' which 'may have been underreported' in mid-February, 2021. (https://odh.ohio.gov/wps/portal/gov/odh/media-center/odh-news-releases/odh-news-release-02-10-20) As of March 2, 2021, Ohio updates their mortality figures twice a week as death certificate information is received and verified from the National Center for Health Statistics. This change caused a decrease in total deaths and their website no longer includes a breakdown of confirmed and probable deaths.	978,471	773,146	79%	649,150	66%	17,656	17,496	99%	17,501	99%
43	20210622	OK	3/06 00:00	3/7/21 22:05	IKP	CB-M/BML	428997	244180	23119		7852	41839			14388	97619	23%	42955	267383	118659	28%	4534	3255	271		57	399			119	433	10%	232	3635	667	15%																															Case and death counts by ethnicity are updated weekly on Fridays; this data is delayed by one week from demographic case data.	428,997	331,378	77%	310,338	72%	4,534	4,101	90%	3,867	85%
44	20210622	OR	3/05 00:01	3/7/21 21:17	TRW	CLM	157285	76447	3791		4850	2769	1404	2534	36783	28707	18%	40965	78492	37828	24%	2296	1531	46		58	41	20	47	183	370	16%	211	1475	610	27%																8714	5270	273		311	220	146	160	1585	749	0	1765	5410	1539	0	press releases in Data Reports/Projections have "refused/unknown" category labeled as "unavailable"	157,285	128,578	82%	119,457	76%	2,296	1,926	84%	1,686	73%
45	20210622	PA	3/07 12:00	3/7/21 21:10	EPC	PK	948643	487131	81180		16176				12096	352060	37%	59427	252700	636516	67%	24349	19497	2829		379				1	1643	7%	982	23280	87	0%																															Current update is for demographic data on cases, data on deaths often delayed. PA began reporting not rounded (nearest hundred) data end of July. PA updates demographic death data only once a week on Fridays, so only Sunday updates will have this reflected. PA updates demographic case data regularly.	948,643	596,583	63%	312,127	33%	24,349	22,706	93%	4,493	94%
46	20210622	PR	3/06 00:00	3/7/21 21:49	CKC	PK	101327									101327	100%					2059									2059	100%																																				101,327	0	0%	0	0%	2,059	0	0%	0	0%
47	20210622	RI	3/03 00:00	3/7/21 21:49	NJR	BML	128121	59389	7780	31023	2342	309	0	1200	2332	23746	19%	31023	73352	23746	19%	2541	1816	104	207	37	1	0	1	1	374	15%	207	1960	374	15%	802636	219702	18349	54284	8702	4717	521	3660	20203	472498	1	54284	275854	472498	1	9020	4280	593	1886	167	20	0	39	203	1832	0	1886	5302	1832	0	Since the week of July 12, demographic data on tests, cases, deaths, and hospitalizations has been updated weekly RI does not consistently report the same demographic categories, which may cause discrepancies in the historical data Race categories can be people who responded non-hispanic, unknown ethnicity, or declined response to ethnicity Some race deaths or hospitalization counts labeled as less than 5. RI's reported tests by race and ethnicity are in units of people. According to RI: The testing data and case data are compiled as separate datasets. The discrepancy where certain racial/ethnic groups may have a greater # of cases than the # of tests is related to the large quantity of missing race/ethnicity data for tests.	128,121	104,375	81%	104,375	81%	2,541	2,167	85%	2,167	85%
48	20210622	SC	3/05 23:59	3/7/21 22:24	KVP	TRW	525865	238659	107296		5178				57311	117421	22%	29233	307580	189052	36%	8754	4727	2408		54				389	1176	13%	211	6437	2106	24%																20725	10646	7383		166				1166	1364	0	998	16674	3053	0	SC combines reporting of Asian / American Indian / Alaskan Native / Pacific Islander	525,865	408,444	78%	336,813	64%	8,754	7,578	87%	6,648	76%
49	20210622	SD	3/06 13:00	3/7/21 21:17	KVP	MBL	113589	84776	2519	4145	1468	13518			1662	5501	5%	4145	103943	5501	5%	1900	1499	7	23	16	265			14	76	4%	23	1801	76	4%																6705	4785	134	170	72	1305			71	168	0	170	6367	168	0		113,589	108,088	95%	108,088	95%	1,900	1,824	96%	1,824	96%
50	20210622	TN	3/07 14:00	3/7/21 21:24	TR	MBL	783484	489782	102220		6937	1032	564		61751	121198	15%	48832	522046	212606	27%	11547	8730	1994		67	9	6		385	356	3%	303	10314	930	8%																																783,484	662,286	85%	570,878	73%	11,547	11,191	97%	10,617	92%
51	20210622	TX	3/07 00:00	3/7/21 21:49	IKP	NJR	2686818	25581	12672	27728	933				428	2619476	97%	27728	39614	2619476	97%	44451	18276	4252	20453	898				231	341	1%	20453	23657	341	1%																															Race-Ethnicity data has not been updated since February 12; data notes from the state dashboard indicate that "winter weather is affecting the reporting of new COVID-19 cases and fatalities across many jurisdictions.". Other includes Pacific Islander, Native Hawaiian, Native American, Multiracial, or another race than listed. Unknown includes people who chose not to respond.	2,686,818	67,342	3%	67,342	3%	44,451	44,110	99%	44,110	99%
52	20210622	UT	3/07 13:00	3/7/21 21:31	CKC	NJR	374850	238411	5001	77215	7107	5016	8931		26238	34321	9%	77215	263314	34321	9%	1976	1329	18	282	59	72	57		119	119	6%	282	1575	119	6%	2248121	1508818	29013	282286	42053	23644	32491		131519	268832	0	282286	1697003	268832	0	14891	9312	246	3268	349	459	765		1114	360	0	3268	11263	360	0	UT reports people in non-mutally exclusive categories, so the total reported is currently for 107% of the cases and 104% of the deaths. UT's reported tests by race and ethnicity are in units of people.	374,850	340,529	91%	340,529	91%	1,976	1,857	94%	1,857	94%
53	20210622	VA	3/06 17:00	3/7/21 21:08	CKC	PK	585700	235269	99166	76875	19984	756		5823	15947	131880	23%	76875	376945	131880	23%	9596	6002	2262	640	337	24		62	66	203	2%	640	8753	203	2%																24661	10858	6760	4376	1087	36		194	494	856	0	4376	19429	856	0		585,700	453,820	0.7748335325	453,820	0.7748335325	9,596	9,393	0.9788453522	9,393	0.9788453522
54	20210622	VI	3/05 11:18	3/7/21 21:38	TR	MBL	2714									2714	100%			2714	100%	25									25	100%			25	100%																																2,714	0	0%	0	0%	25	0	0%	0	0%
55	20210622	VT	3/06 23:59	3/7/21 21:17	TR	NJR	16083	12735	613		746	20			414	1555	10%	368	13160	2555	16%	208	185	2		5	1			2	13	6%	0	179	29	14%																															For number counts greater than 1000, VT reports numbers rounded to the nearest hundred.	16,083	14,528	90%	13,528	84%	208	195	94%	179	86%
56	20210622	WA	3/05 23:59	3/7/21 21:10	TR	MBL	344532	96572	10932	62537	12525	3231	3691	5823	3133	146088	42%	62537	135907	146088	42%	5041	3571	161	596	383	107	81	59	71	12	0%	596	4433	12	0%																19599	6056	623	2621	871	236	355	239	220	8378	0	2621	8600	8378	0	Deaths reported does not always match the number of Total Deaths by Race/Ethnicity. When it is larger, we use the Total Deaths by Race/Ethnicity. On December 13, Washington removed 227 deaths from its counts. The note on WA's dashboard for deaths indicates that "as of December 10, death counts on the dashboard relfect those in the official records database where the cause of death was confirmed or suspected to have been COVID-19. If COVID-19 is later ruled out as the official cause of death, we will remove these deaths from our dashboard." On July 14, Washington removed 39 deaths from its counts where, though the individual who died tested positive, COVID was not a contributing cause in their death. Total deaths reported on the Demographics dashboard decreased from 1424 to 1421.	344,532	198,444	58%	198,444	58%	5,041	5,029	100%	5,029	100%
57	20210622	WI	3/07 00:00	3/7/21 21:12	MBL	NJR	621654	481041	40549		15553	7580			34002	42929	7%	63651	470050	87953	14%	7106	6144	478		127	97			106	154	2%	389	6404	313	4%																26457	18668	3023	2491	563	410			312	990	0	2491	22976	990	0		621,654	578,725	93%	533,701	86%	7,106	6,952	98%	6,793	96%
58	20210622	WV	3/06 23:59	3/7/21 21:32	NJR	MBL	133445	111202	4623						3092	14528	11%			133445	100%	2325	2049	57						34	185	8%			2325	100%																																133,445	118,917	89%	0	0%	2,325	2,140	92%	0	0%
59	20210622	WY	3/07 00:00	3/7/21 21:39	NJR	CB-M	54764	28117	425	4134	281	2250	134		1726	21292	36%	4134	32933	21292	36%	682	606	2	58	6	51	1		8	11	1%	58	613	11	2%																															WY reports people in each category they select, resulting in the double counting of some people. Currently the state reports demographics for 0% of the confirmed cases, and demographics for 0% of the population. Began collecting cases counts exactly on 11/22, before this counts were estimated based on the percent WY reported. Similarly on 11/25 began collecting exact death counts. Began reporting Reported Unknowns instead of calculating from total since WY double counts.	54,764	33,472	61%	33,472	61%	682	671	98%	671	98%


1	Alaska			AK	Positives															Deaths															Total Tests															Hospitalizations
2	Alaska			Worksheet2	Race											Ethnicity					Race										Ethnicity				Race											Ethnicity				Race											Ethnicity					Cases					Deaths
3	Update Time	Last Check	Checker	DC	Total Positives	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Deaths	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknown	Total N. Tests	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Hosp.	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Notes	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Questions
4	03/04 23:59	03/07 21:17	BML	TRW	59,332	18,300	1,499		2,447	12,238	1,508	4,453	7,130	11,757	20%	3,197	29,625	26,510	45%	305	127	9		29	111	17	4	1	7	2%	13	280	12	3.93%																1,293	423	45		116	336	126	67	54	126	10%	66	939	288	22%		59,332	47,575	80%	32,822	55%	305	298	98%	293	96%
5	FILL IN ANY GREEN CELL		Current time EDT:	6/22 8:20	59,332	#	#		#	#	#	#	#	#		#	#	#	59,332	305	#	#		#	#	#	#	#	#		#	#	#	305																1,293	#	#		#	#	#	#	#	#		#	#	#
6	Data Type	Totals, Cases Demographics	Hosp and Deaths Demographics	Old dash link										772	[API]			1,329											1	[API]			2												[API]															[API]
7	Format	ArcGIS Dashboard	ArcGIS Table
8	Interaction	Tabs and Hovering	None																	Previous Shift Data
9	Link	https://alaska-coronavirus-vaccine-outreach-alaska-dhss.hub.arcgis.com/app/6a5932d709ef4ab1b868188a4c757b4f	https://coronavirus-response-alaska-dhss.hub.arcgis.com/datasets/table-3-demographic-distribution-of-confirmed-cases/data	https://coronavirus-response-alaska-dhss.hub.arcgis.com/																59030	18188	1494		2437	12212	1506	4445	7109	11639	19.72%	3188	29540	26302	44.56%
10	Process	Checker: Record Total & Total (Residents) Cases, Deaths & Hospitalizations under "Select residence,"select All" and "Residents" and wait for the dashboard to refresh for each value. Total case number should match https://covidtracking.com/data/state/alaska For Case demographics, use the bar chart next to "Total Cases" to get Case demographics. Select "All" before using the bar chart to include cases for non-residents. DC: Verify Case, Hosp. and Deaths under "Select Residence," select "All" and "Residents" and wait for the dashboard to refresh for each value. Total case number should match https://covidtracking.com/data/state/alaska Use the bar chart next to "Total Cases" to get Case demographics. Select "All" before using the bar chart to include cases for non-residents.	Checkers: this data has been prepopulated. Follow the process notes in K18 DC: Use this source to get hosp/death demographics only. (The All_Cases column is residents only. The totals will be smaller than what's in the dash bar charts when "All" is selected, and will match when "Resident" is selected.) Check that the online table is the same as the downloaded CSV, and if not, use whichever has been updated most recently (i.e. the categories are bigger and sum up to the current totals)																	303	127	9		29	111	17	4	1	5	2%	13	280	10	3%
11	Update Time	Date from the hosps/deaths table, minus one day + 23:59 (note on the dashboard says 'Data is through previous day'). This displays in local time, so adjust if that affects the date.			Public Notes	Alaska reports case data for both residents and nonresidents; we collect the total number of cases.
12	Notes																			1,285	423	45		116	336	126	67	54	118	0	66	939	280	0
13
14
15											This DATA is auto-populated pre-shift.
16		Total	59,332	1,293	1,293	305	305	comparison (all)		Paste Date:
17		Total (among residents)	56,886		1,253	301				03/07	Hosp. and Deaths in the Lavender cells to the left (E:F) reference the table below. No need to enter any data. To check, make sure that the values match
18		comparison (residents)	56,886
19										AK Hospitalization & Death Demographics (Residents Only)
20		Race	Cases (Total)		Hosp.	Deaths				Demographic	Hospitalizations	Deaths
21		AIAN	12,238	White	423	127				Hispanic	66	13
22		Asian	2,447	Black	45	9				Non-Hispanic	939	280
23		Black	1,499	AI/AN	336	111				UI Ethnicity	229	6
24		Multiple	4,453	Asian	116	29				Unknown Ethnicity	19	2
25		NHOPI	1,508	NHOPI	126	17				White	423	127
26		Other	7,130	Multiple	67	4				Black	45	9
27		Unknown	772	Other	54	1				AI/AN	336	111
28		White	18,300	UI Race	77	2				Asian	116	29
29		Under Investigation	10,985	Unknown Race	9	1				NHOPI	126	17
30		Total	59,332	Total	1253	301				Multiple	67	4
31		unknown	11,757	unknown	126	7				Other	54	1
32										UI Race	77	2
33		Ethnicity	Cases		Hosp.	Deaths				Unknown Race	9	1
34		Hispanic	3,197	Hispanic	66	13
35		Non-Hispanic	29,625	Non-Hispanic	939	280
36		Unknown	1,329	UI Ethnicity	229	6
37		Under Investigation	25,181	Unknown Ethnicity	19	2
38		Total	59,332	Total	1253	301
39		unknown	26,510	unknown	288	12
40


1	Alabama			AL	Positives															Deaths															Total Tests															Hospitalizations
2	Alabama			Worksheet2	Race											Ethnicity					Race										Ethnicity				Race											Ethnicity				Race											Ethnicity					Cases					Deaths
3	Update Time	Last Check	Checker	DC	Total Positives	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Deaths	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknown	Total N. Tests	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Hosp.	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Notes	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Questions
4	03/07 10:00	3/7 9:12:00 PM	TMB	BML	499,819	160,347	82,790		2,273				38,000	216,409	43%	12,312	167,064	320,443	64.11%	10,148	4,730	2,223		24				300	2,871	28.29%	137	6,083	3,928	38.71%																															(TMB 1/17) Unknown Ethnicity deaths needs to be updated to respond to percentages, not exact counts. (TMB 1/24) Per dashboard: "We are experiencing issues with the data for the Last 14 Days Cases indicator and Tab 5, Number of Cases by County reported in the Last 14 Days. We are working to correct the issue. Thank you for your patience." (TMB 1/24) Hispanic/Latino Death % is significantly rounded. Record state reported percentage to right of death count. (CLM 2/21) Demographic data not updated due to error in dashboard	499,819	283,410	57%	179,376	36%	10,148	7,277	72%	6,220	61%
5	FILL IN ANY GREEN CELL		Current time EDT:	6/22 8:20	499,819	#	#		#				#	#		#	#	#	499,819	10,148	#	#		#				#	#		#	#	#	10,148
6	Data Type		Deaths by Race	Deaths by Ethnicity	Cases by Race	Cases by Ethnicity							107,742	108,667	[API]		107,742	212,701										2,185	686	[API]		2,185	1,743
7	Format	ArcGIS Dashboard	ArcGIS	ArcGIS	ArcGIS	ArcGIS							probable	Unknown (reported)			probable	Unknown (reported)										probable	Unknown (reported)			probable	Unknown (reported)
8	Interaction	Tabs & Hovering	Table	Table	Table	Table														Previous Shift Data
9	Link	https://alpublichealth.maps.arcgis.com/apps/opsdashboard/index.html#/6d2771faa9da4a2786a509d82c8cf0f7	https://alpublichealth.maps.arcgis.com/home/item.html?id=015fd1e0d8074840ab624243a74c54c9&sublayer=1#data	https://alpublichealth.maps.arcgis.com/home/item.html?id=015fd1e0d8074840ab624243a74c54c9&sublayer=0#data	https://alpublichealth.maps.arcgis.com/home/item.html?id=0c2185b8174646979f4abb5a45ef05c3&sublayer=3#data	https://alpublichealth.maps.arcgis.com/home/item.html?id=0c2185b8174646979f4abb5a45ef05c3&sublayer=1#data														497154	160347	82790		2273				38000	213744	42.99%	12312	167064	317778	63.92%
10	Process	Checkers: Record Confirmed & Probable Cases and Deaths on the dash. Be sure to record the Update Time and verify that the lavender cells match the pink download cells and that the paste date is today. DC: Use the first link to verify totals for cases and deaths. Use the data tables in the Deaths by Race, Deaths by Ethnicity, Cases by Race and Cases by Ethnicity links to DC the demographics.																		10029	4730	2223		24				300	2752	27%	137	6083	3809	38%
11	Update Time	Dash says "Updates Daily at 10:00 a.m." so use current day + 10:00			Public Notes	AL reports both percentages and numerical values on their dashboard; for numerical values greater than 1000, AL presents rounded numbers. Starting on 02/14/2021, we report un-rounded numbers extracted from their ArcGIS data. Race categories included as Other on the ADPH dashboard are American Indian, Native Hawaiian or Pacific Islander, Other Race, and Multiple Races if persons identify as mixed or other race.
12	Notes	(TMB 1/17) Unknown Ethnicity deaths needs to be updated to respond to percentages, not exact counts. (TMB 1/24) Per dashboard: "We are experiencing issues with the data for the Last 14 Days Cases indicator and Tab 5, Number of Cases by County reported in the Last 14 Days. We are working to correct the issue. Thank you for your patience." (TMB 1/24) Hispanic/Latino Death % is significantly rounded. Record state reported percentage to right of death count. (CLM 2/21) Demographic data not updated due to error in dashboard
13
14	Total Cases, today	Confirmed	Probable		Deaths	Confirmed	Probable
15	499,819	392,077	107,742		10,148	7,963	2,185
16		392,077	107,742			7,963	2,185
17	499,819	392,077	107,742	Comparison	10,148	7,963	2,185
18
19	Ethnicity	Cases			Ethnicity	Deaths
20	Hispanic/Latino	12,312			Hispanic/Latino	137
21	Not Hispanic/Latino	167,064			Not Hispanic/Latino	6,083
22	Unknown	212,701	107,742		Unknown	1,743	2,185
23	Unknown Calculated	320,443			Unknown Calculated	3,928
24	Total Cases by Ethnicity	392,077			Total Deaths by Ethnicity	7,963
25
26	Race	Cases			Race	Deaths
27	Asian	2,273			Asian	24
28	Black	82,790			Black	2,223
29	Other	38,000			Other	300
30	Unknown	108,667	107,742		Unknown	686	2,185
31	White	160,347			White	4,730
32	Total Cases by Race	392,077			Total Deaths by Race	7,963
33
34	Unknown Calculated	216,409			Unknown Calculated	2,871
35
36	Paste Date:	03/07
37
38	Ethnicity Cases				Ethnicity Deaths
39	Ethnicity	Ethnicity_Counts			EthnicityCat	DiedFromCovid19
40	Hispanic/Latino	12312			Hispanic/Latino	137
41	Not Hispanic/Latino	167064			Not Hispanic/Latino	6083
42	Unknown	212701			Unknown	1743
43	Race Cases				Race Deaths
44	Racecat	Race_Counts			Racecat	DiedFromCovid19
45	Asian	2273			Asian	24
46	Black	82790			Black	2223
47	Other	38000			Other	300
48	Unknown	108667			Unknown	686
49	White	160347			White	4730


1	Arkansas			AR	Positives															Deaths															Total Tests															Hospitalizations
2	Arkansas			Worksheet2												Ethnicity					Race										Ethnicity				Race											Ethnicity				Race											Ethnicity					Cases					Deaths
3	Update Time	Last Check	Checker	DC	Total Positives	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Deaths	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknown	Total N. Tests	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Hosp.	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Notes	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Questions
4	3/7 0:00	03/07 21:16	EPC	BML	324,818	207,596	50,842		2,913	1,070	3,358	1,804	16,491	40,744	13%	34,332	290,486	0	0.00%	5,319	4,171	784		36	18	56	13	203	38	0.71%	186	5,133	0	0.00%																															(CLM 02/28) Total deaths decreased by 174 due to data clean-up and deduplication on AR's end.	324,818	284,074	87%	284,074	87%	5,319	5,281	99%	5,319	100%
5	FILL IN ANY GREEN CELL		Current time EDT:	6/22 8:20	324,818	#	#		#	#	#	#	#	#		#	#		324,818	5,319	#	#		#	#	#	#	#	#		%			5,319
6	Data Type	Source (Desktop Version)	Demographics, Totals for Cases & Deaths	Old Source Link (backup)									69,092	40,744	[API]		69,092											1,011	34	[API]		1,011													[API]															[API]
7	Format	ArcGIS Dashboard	ArcGIS Table
8	Interaction	Tabs & Hovering	None																	Previous Shift Data
9	Link	https://adem.maps.arcgis.com/apps/opsdashboard/index.html#/fd6874664d404993814de4d5a65d5cfd	https://services.arcgis.com/PwY9ZuZRDiI5nXUB/ArcGIS/rest/services/UPDATED_ADH_COVID19_STATE_METRICS/FeatureServer/0/query?where=1%3D1&objectIds=&time=&resultType=none&outFields=positives%2C+white%2C+black%2C+unk_race%2C+other_race%2C+pi%2C+asian%2C+na%2C+multi_race%2C+hispanic%2C+nonhispanic%2C+deaths%2C+d_white%2C+d_black%2C+d_unk_race%2C+d_other_race%2C+d_pi%2C+d_asian%2C+d_na%2C+d_multi_race&returnIdsOnly=false&returnUniqueIdsOnly=false&returnCountOnly=false&returnDistinctValues=false&cacheHint=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&having=&resultOffset=&resultRecordCount=&sqlFormat=none&f=html&token=	https://experience.arcgis.com/experience/c2ef4a4fcbe5458fbf2e48a21e4fece9																324818	207596	50842		2913	1070	3358	1804	16491	40744	12.54%	34332	290486	0	0.00%
10	Process	For Checkers: Record Confirmed & Probable Cases & Deaths. For Both: For death by ethnicity: look for the note underneath the demographics chart.	For DC: Use this link to DC demographic data for cases & deaths as well as Total Cases & Deaths																	5319	4171	784		36	18	56	13	203	38	1%	180	5139	0	0%
11	Update Time	Use today + 0:00 if data gotten from the dashboard. If from the Backup, see "Updated as of".			Public Notes	On 02/28/21, total deaths decreased due to AR conducting data clean-up.
12	Notes	(CLM 02/28) Total deaths decreased by 174 due to data clean-up and deduplication on AR's end.
13				Comparison*			Comparison*	* Occasionally, AR's dash does not update prior to the end of pub shift. In this case, it's expected that the Comparison cells will not match our Totals.
14		Total COVID-19 Cases	324,818	324,818	Total Deaths	5,319	5,319
15		Probable Cases	69,092	69,092	Probable Deaths	1,011	1,011
16		Confirmed Cases	255,726	255,726	Confirmed Deaths	4,308	4,308
17			Race
18			Black	50,842		Black	784
19			White	207,596		White	4,171
20			American Indian/Alaskan	1,070		American Indian/Alaskan	18
21			Asian	2,913		Asian	36
22			Native Hawaiian/Pacific Islander	3,358		Native Hawaiian/Pacific Islander	56
23			Other race	16,491		Other Race	203
24			Unknown	40,744		Unknown Race	34
25			Multi Race	1,804		Multi Race	13
26			Total Reported	324,818			5,315
27			Calculated unknown	40,744			38
28			Ethnicity					Percentage:
29			Nonhispanic	290,486		Unknown	4
30			Hispanic	34,332		Hispanic	186	3.5%
31			Total Reported	290,486		Non-Hispanic	5,133
32			Unknown	0			0
33	Paste Date	03/07
34	Case Demographics
35	type	geometry	positives	black	white	na	asian	pi	other_race	unk_race	multi_race	nonhispanic	hispanic
36	Feature		324818	50842	207,596	1070	2,913	3358	16491	40744	1804	290486	34332
37	Death Demographics
38	type	geometry	deaths	d_black	d_white	d_na	d_asian	d_pi	d_other_race	d_unk_race	d_multi_race
39	Feature		5319	784	4,171	18	36	56	203	34	13


1	Arizona			AZ	Positives															Deaths															Total Tests															Hospitalizations
2	Arizona			Worksheet2	Race											Ethnicity					Race										Ethnicity				Race											Ethnicity				Race											Ethnicity					Cases					Deaths
3	Update Time	Last Check	Checker	DC	Total Positives	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Deaths	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknown	Total N. Tests	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Hosp.	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Notes	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Questions
4	3/7 0:00	03/07 21:13	SPA	AFG	826,454	308,453	25,775	244,539	11,921	40,707			46,964	148,095	18%	244,539	433,820	148,095	18%	16,328	8066	433	4,684	220	1,361			465	1,099	7%	4,684	10,545	1,099	7%																57,907	26,710	2,479	18,730	1,015	4,496			2,562	1,915	3.31%	18,730	37,262	1,915	3.31%		826,454	678,359	82%	678,359	82%	16,328	15,229	93%	15,229	93%
5	FILL IN ANY GREEN CELL		Current time EDT:	6/22 8:20	826,454	#	#	#		#			#	#	#				826,454	16328	#	#	#		#			#	#	#				16,328																57,907	#	#	#		#			#	#	#
8	Interaction	Tabs & Hovering																		Previous Shift Data
9	Link	https://www.azdhs.gov/preparedness/epidemiology-disease-control/infectious-disease-epidemiology/covid-19/dashboards/index.php																		819954	305803	25554	243201	11798	40371			46776	146451	17.86%	243201	430302	146451	17.86%
10	Process	- On the "Summary" tab, hover over "Number of Cases/Deaths #" > "confirmed", "probable" - Case Demographics come from the Demographics tab, Deaths from the Deaths tab and Hospitalization total & demographics from the Hospitalization tab. Hover over the bars to get the values (not the %).																		16089	7917	423	4619	217	1341			460	1112	7%	4619	10358	1112	7%
11	Update Time	Use "Date Updated:" at bottom of main dashboard +0:00			Public Notes	Laboratories and healthcare providers report data to AZDHS in the current format; AZDHS is unable to further delineate race/ethnicity categories at this time.
12	Notes																			57,697	26,575	2,466	18,695	1,007	4,474			2,551	1,929	0	18,695	37,073	1,929	0
13
14					Comparison		Comparison
15			Confirmed	769,935	769,935	14,403	14,403
16			Probable	56,519	56,519	1,925	1,925		Comparison
17			Total	826,454	826,454	16,328	16,328	57,907	57,907
18
19
20				Cases		Deaths		Hospitalizations
21			White, Non-Hispanic	308,453		8,066		26,710
22			Hispanic or Latino	244,539		4,684		18,730
23			Native American	40,707		1,361		4,496
24			Black, Non-Hispanic	25,775		433		2,479
25			Asian/Pacific Islander	11,921		220		1,015
26			Other, Non-Hispanic	46,964		465		2,562
27			Unknown	148,095		1,099		1,915
28			Total (calc)	826,454		16,328		57,907
29			Unknown (calc)	148,095		1,099		1,915
30
31			Non-Hispanic	433,820		10,545		37,262


1	California			CA	Positives															Deaths															Total Tests															Hospitalizations
2	California			Worksheet2	Race											Ethnicity					Race										Ethnicity				Race											Ethnicity				Race											Ethnicity					Cases					Deaths
3	Update TIme	Last Check	Checker	DC	Total Positives	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Deaths	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknown	Total N. Tests	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Hosp.	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Notes	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Questions
4	3/7 14:00	3/7/2021 21:14	IKP	CLM	3,501,394	546,630	111,279	1,509,103	186,562	9,025	15,281	42,824	304,477	776,213	22%	1,509,103	1,216,078	776,213	22%	54,124	16,586	3,275	24,402	6,105	184	322	693	1,103	1,454	3%	24,402	28,268	1,454	3%	49,646,014	9,172,498	1,730,660	9,444,459	3,980,518	98,894	222,513	74,171	6,354,689	18,567,612	37.40%	9,444,459	21,633,943	18,567,612																	Checkers: Enter testing total. DCers: Double check prepopulated cases and deaths totals and testing total.	3,501,394	2,725,181	78%	2,725,181	78%	54,124	52,670	97%	52,670	97%	#REF!
5	FILL IN ANY GREEN CELL		Current time EDT:	6/22 8:20	3,501,394	#	#	#	#	#	#	#	#	#					3,501,394	54,124	#	#	#	#	#	#	#	#	#					54,124	49,646,014	%	%	%	%	%	%	%	%	%
6	Data Type	Totals	Tests	Cases + deaths download	Cases + deaths tables										[API]															[API]														18,567,609	[API]															[API]
9	Link	https://covid19.ca.gov/	https://covid19.ca.gov/equity/	https://data.ca.gov/dataset/590188d5-8545-4c93-a9a0-e230f0db7290/resource/7e477adb-d7ab-4d4b-a198-dc4c6dc634c9/download/case_demographics_ethnicity.csv	https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/Race-Ethnicity.aspx#															3501394	546630	111279	1509103	186562	9025	15281	42824	304477	776213	22.17%	1509103	1216078	776213	22.17%
10	Process	Checkers: Enter testing total. DCers: Double check prepopulated cases and deaths totals and testing total.	Scroll to "COVID-19 impact by race and ethnicity" and select "Testing." Enter the "% of testing statewide" percentages (the second/yellow bar in each category).	Checkers: verify that downloaded data in pink cells and lavender cells match each other DCers: Sort the download by date and double check against the numbers from the date of "Demographic Download Date" (below pink area)	Not used															54124	16586	3275	24402	6105	184	322	693	1103	1454	3%	24402	28268	1454	3%
11	Update Time	Use dates from below pink pre-populated cells. For the downloaded demographic data, use corresponding date +0:00			Public Notes															49028048	9058324	1709117	9326899	3930970	97663	219743	73247	6275590	18336495	0.374000103	9326899	21364654	18336495
12	Notes	(1/10 CB-M) CA's demographics are lagging their Datastore by 3 days. Have made an ask to see if they will align with the datastore going forward or if there is a better source. For tonight - all calculations will be made from the total Case number at the top.
13
14		Tests		Cases	Deaths
15		49,646,014		3,501,394	54,124	Paste Date:
16		49,646,014		3,501,394	54,124	03/07	This DATA is auto-populated pre-shift.
17	Total for named categories	24,723,715					↓↓↓↓
18					Cases	Deaths	Case & Death Totals
19	Native Hawaiian and other Pacific Islander (NHPI)	0.9%	222,513	Latino	1,509,103	24,402	totalcountconfirmed	totalcountdeaths
20	Latino	38.2%	9,444,459	White	546,630	16,586	3501394	54124
21	Black	7.0%	1,730,660	Asian	186,562	6,105
22	Asian American	16.1%	3,980,518	Black	111,279	3,275
23	White	37.1%	9,172,498	Multi-Race	42,824	693	CA Race and Ethnicity Totals
24	American Indian or Alaska Native (AI/AN)	0.4%	98,894	American Indian or Alaska Native	9,025	184	race_ethnicity	cases	case_percentage	deaths	death_percentage	percent_ca_population	date
25	Multi-Race	0.3%	74,171	Native Hawaiian and other Pacific Islander	15,281	322	Latino	1509103	55.4	24402	46.3	38.9	2021-03-06
26	Other	12.8%	6,354,689	Other	304,477	1,103	White	546630	20.1	16586	31.5	36.6	2021-03-06
27	Unknown	37.4%	18,567,609				Asian	186562	6.8	6105	11.6	15.4	2021-03-06
28	Total w/ known race	100.0%	31,078,402	Unknown (calc)	776,213	1,454	Black	111279	4.1	3275	6.2	6	2021-03-06
29	Unknown (calculated)		18,567,612	Total with data (calc)	2,725,181	52,670	Multi-Race	42824	1.6	693	1.3	2.2	2021-03-06
30				Total (calc)	3,501,394	54,124	American Indian or Alaska Native	9025	0.3	184	0.3	0.5	2021-03-06
31	Hispanic		9,444,459	Non-Latino (calc)	1,216,078	28,268	Native Hawaiian and other Pacific Islander	15281	0.6	322	0.6	0.3	2021-03-06
32	Non-Hispanic (calc)		21,633,943				Other	304477	11.2	1103	2.1	0	2021-03-06
33	Unknown ethnicity (calc)		18,567,612
34							Demographic Download Date:	2021-03-06
35
36
37
38
39
40
41


1	Colorado			CO	Positives															Deaths															Total Tests															Hospitalizations
2	Colorado			Worksheet2	Race											Ethnicity					Race										Ethnicity				Race											Ethnicity				Race											Ethnicity					Cases					Deaths
3	Update Time	Last Check	Checker	DC	Total Positives	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Deaths	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknown	Total N. Tests	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Hosp.	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Notes	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Questions
4	03/06 23:59	03/07 21:18	SPA	CLM	435,762	181,669	12,637	119,224	6,406	2,527	1,264	6,580	3,312	102,143	23%	119,224	214,395	102,143	23%	5,986	3869	191	1204	115	37	9	186	38	337	5.63%	1204	4445	337	5.63%																															None	435,762	333,619	77%	333,619	77%	5,986	5,649	94%	5,649	94%
5	FILL IN ANY GREEN CELL		Current time EDT:	6/22 8:20	435,762	%	%	%	%	%	%	%	%	%					435,762	5986	%	%	%	%	%	%	%	%	%					5986
6	Data Type	All	Backup										24,786	102,143	[API]													735	337	[API]															[API]															[API]
9	Link	https://covid19.colorado.gov/data	https://covid19.colorado.gov/data/case-data																	431670	179488	12562	118537	6302	2504	1252	6475	3281	101269	23.46%	118537	211864	101269	23.46%
10	Process	- Capture total cases and Deaths Among Cases from the top of the dashboard and enter those totals in line 17 - From the Case Summary Snapshot at the bottom of the dashboard, record Confirmed cases, Probable cases, Confirmed deaths among cases, and Probable deaths among cases, and enter those values in the confirmed and probable rows (15 and 16) - For race/ethnicity figures: click "Demographics" in the menu beneath the top bar of the dashboard. Click "Race & Ethnicity" and toggle between Cases and Deaths.																		5970	3851	192	1205	114	37	9	184	38	340	6%	1205	4425	340	6%
11	Update Time	Dash reads "Data is updated daily by about 4 p.m. and includes cases reported through the previous day." so use previous day + 23:59			Public Notes	Data presented by state represent > 80% of reported COVID-19 cases; Cases with an unknown race or ethnicity are excluded from calculations.
12	Notes
13		(totals, from grey boxes at the top of the Case Summary)
14		Cases	Comparison Cases	Comparison Deaths	Deaths
15	Confirmed	410,976	410,976	5,251	5,251	Confirmed Deaths Among Cases
16	Probable	24,786	24,786	735	735	Probable Deaths Among Cases
17	Total	435,762	436,602	5,989	5,986	All deaths among cases
18
19	(as a percent)	Cases (%)	Count		Death %	Count
20	American Indian or Alaska Native	0.58%	2,527		0.62%	37
21	Asian	1.47%	6,406		1.92%	115
22	Multiple Races - Non Hispanic	1.51%	6,580		3.11%	186
23	Native Hawaiian or Other Pacific Islander	0.29%	1,264		0.15%	9
24	Other	0.76%	3,312		0.63%	38
25	Black or African American	2.90%	12,637		3.19%	191
26	White - Non Hispanic	41.69%	181,669		64.64%	3,869
27	Hispanic, All Races	27.36%	119,224		20.12%	1,204
28	Unknown	23.44%	102,143		5.63%	337
29	Unknown (calc)		102,143			337
30
31	Totals (calc)	100.00%	435,762		100.01%	5,986
32
33
34	Hispanic		119,224			1,204
35	NonHispanic (calc)		214,395			4,445
36	Unknown		102,143			337


1	American Samoa			AS	Positives															Deaths															Total Tests															Hospitalizations
2	American Samoa			Worksheet2												Ethnicity					Race										Ethnicity				Race											Ethnicity				Race											Ethnicity					Cases					Deaths
3	Update Time	Last Check	Checker	DC	Total Positives	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Deaths	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknown	Total N. Tests	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Hosp.	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Notes	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Questions
4	12/1 17:00	3/7 21:18	TMB	BML											100%				100%											100.00%				100.00%
5	FILL IN ANY GREEN CELL		Current time EDT:	6/22 8:20															0	0														0
6	Data Type														[API]															[API]															[API]															[API]
7	Format	CTP
8	Interaction	None																		Previous Shift Data
9	Link	https://covidtracking.com/data/state/american-samoa																												100.00%				100.00%
10	Process	Record totals from the dash.																												100%				100%
11	Update Time	Update Time: Use "Last updated:" Adjust for AS time (+17h from ET).			Public Notes
12	Notes	Has not updated since 12/01/2020.
13
14
15			Total Cases	0	Comparison	0
16			Total Deaths	0		0


1	Connecticut			CT	Positives															Deaths															Total Tests															Hospitalizations
2	Connecticut			Worksheet2	Race											Ethnicity					Race										Ethnicity				Race											Ethnicity				Race											Ethnicity					Cases					Deaths
3	Update Time	Last Check	Checker	DC	Total Positives	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Deaths	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknown	Total N. Tests	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Total Hosp.	White	Black	Latinx/Hispanic	Asian	AIAN	NHPI	Multiple	Other	Unknown	%_Unknown	Hispanic	Non-Hispanic	Unknown	%_Unknkown	Notes	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Total	Race Known	% Race Known	Ethnicity Known	% Ethnicity Known	Questions
4	3/4 0:00	3/7 21:17	TMB	TRW	285,330	85,469	19,651	41,523	3,019	393		17,642	15,284	102,349	36%	41,523	141,458	102,349	36%	7,704	5,413	906	782	83	3		353	38	126	2%	782	6,796	126	2%																										</