COVIDtracking_data_archive: crdt: 5,208 rows where sorted by Cases_Ethnicity

Data provided by Big Local News and snapshotted daily from the COVID19 Tracker, https://covidtracking.com/.

Data source: Big Local News · About: big-local-datasette

5,208 rows sorted by Cases_Ethnicity_Unknown

descending

This data as json, copyable, CSV (advanced)

Link	rowid	Date	State	Cases_Total	Cases_White	Cases_Black	Cases_Asian	Cases_NHPI	Cases_Multiracial	Cases_Other	Cases_Unknown	Deaths_Total	Deaths_White	Deaths_Black	Deaths_Asian	Deaths_NHPI	Deaths_Multiracial	Deaths_Other	Deaths_Unknown	Deaths_Ethnicity_Unknown	Hosp_Total	Hosp_White	Hosp_Black	Hosp_Asian	Hosp_NHPI	Hosp_Other	Hosp_Unknown	Hosp_Ethnicity_Unknown
4	4	20210228	AS
28	28	20210228	MP	143							143	2							2
43	43	20210228	PR	100297							100297	2036							2036
60	60	20210224	AS
84	84	20210224	MP	143							143	2							2
99	99	20210224	PR	99519							99519	2007							2007
116	116	20210221	AS
140	140	20210221	MP	143							143	2							2
155	155	20210221	PR	99084							99084	1979							1979
172	172	20210217	AS
196	196	20210217	MP	135							135	2							2
211	211	20210217	PR	98428							98428	1930							1930
228	228	20210214	AS
252	252	20210214	MP	134							134	2							2
267	267	20210214	PR	97609							97609	1919							1919
284	284	20210210	AS
308	308	20210210	MP	133							133	2							2
323	323	20210210	PR	96494							96494	1897							1897
340	340	20210207	AS
364	364	20210207	MP	133							133	2							2
379	379	20210207	PR	95839							95839	1883							1883
396	396	20210203	AS
420	420	20210203	MP	133							133	2							2
435	435	20210203	PR	94662							94662	1853							1853
452	452	20210131	AS
461	461	20210131	GU	7587	389		2251	3914		416	617	129	3		32	74		4	16
476	476	20210131	MP	132							132	2							2
491	491	20210131	PR	93624							93624	1829							1829
503	503	20210131	WV	121001	76388	2888			170	2070	39485	2024	1401	31			2	20	570
508	508	20210127	AS
517	517	20210127	GU	7568	382		2247	3901		410	628	129	3		32	73		4	17
532	532	20210127	MP	132							132	2							2
547	547	20210127	PR	92244							92244	1794							1794
559	559	20210127	WV	117775	73760	2736			158	1989	39132	1953	1334	31			2	20	566
564	564	20210124	AS
573	573	20210124	GU	7547	382		2247	3901		410	607	128	3		32	73		4	16
588	588	20210124	MP	129							129	2							2
603	603	20210124	PR	91028							91028	1773							1773
615	615	20210124	WV	115307	71635	2664			152	1953	38903	1895	1293	29			2	19	552
620	620	20210120	AS
629	629	20210120	GU	7521	364		2241	3861		406	649	128							128	128
644	644	20210120	MP	129							129	2							2
659	659	20210120	PR	88513							88513	1717							1717
671	671	20210120	WV	111677	68839	2542			145	1830	38321	1836	1248	25			2	19	542
676	676	20210117	AS
685	685	20210117	GU	7484	364		2241	3861		406	612	127							127	127
700	700	20210117	MP	128							128	2							2
715	715	20210117	PR	87381							87381	1703							1703
727	727	20210117	WV	108821	66444	2451			139	1786	38001	1776	1201	23			2	19	531
732	732	20210113	AS
741	741	20210113	GU	7444	354		2234	3814		400	642	124							124	124
756	756	20210113	MP	128							128	2							2
771	771	20210113	PR	84639							84639	1659							1659
783	783	20210113	WV	104392	57644	2162			23	1330	43233	1671	1112	23			0	17	519
788	788	20210110	AS
797	797	20210110	GU	7412	354		2234	3814		400	610	124							124	124
798	798	20210110	HI	23341	2449	364	4792	6366		705	8665	309	25	5	159	87		5	28	28	1864	112	11	445	552	27	717	717
812	812	20210110	MP	125							125	2							2
827	827	20210110	PR	83119							83119	1630							1630
839	839	20210110	WV	101212	56497	2138			17	1319	41241	1582	1059	21			0	17	485
844	844	20210106	AS
853	853	20210106	GU	7378	351		2227	3755		396	649	123							123	123
854	854	20210106	HI	22310	2449	364	4792	6366		705	7634	299	25	5	159	87		5	18	18	1843	112	11	445	552	27	696	696
868	868	20210106	MP	125							125	2							2
883	883	20210106	PR	79612							79612	1570							1570
895	895	20210106	WV	94678	54973	878			5	2516	36306	1481	995	9				24	453
900	900	20210103	AS
909	909	20210103	GU	7327	351		2227	3755		396	598	123							123	123
910	910	20210103	HI	21956	2316	347	4632	6214		647	7800	289	25	5	156	84		5	14	14	1775	106	11	432	535	25	666	666
924	924	20210103	MP	122							122	2							2
939	939	20210103	PR	78169							78169	1545							1545
951	951	20210103	WV	91058	53150	837			2	2469	34600	1376	930	9				23	414
956	956	20201230	AS
965	965	20201230	GU	7308	348		2219	3726		391	624	121							121	121
966	966	20201230	HI	21209	2316	347	4632	6214		647	7053	285	25	5	156	84		5	10	10	1768	106	11	432	535	25	659	659
980	980	20201230	MP	122							122	2							2
995	995	20201230	PR	75888							75888	1484							1484
1007	1007	20201230	WV	84225	51413	2057				1098	29657	1318	896	20				11	391
1012	1012	20201227	AS
1021	1021	20201227	GU	7270	348		2219	3726		391	586	121							121	121
1022	1022	20201227	HI	20983	2185	340	4525	6032		605	7296	285	25	5	156	84		5	10	10	1711	103	10	430	519	23	626	626
1036	1036	20201227	MP	122							122	2							2
1051	1051	20201227	PR	73227							73227	1445							1445
1063	1063	20201227	WV	80710	48965	2006				1013	28726	1254	859	20				11	364
1068	1068	20201223	AS
1077	1077	20201223	GU	7257	346		2199	3682		389	641	121							121	121
1078	1078	20201223	HI	20522	2185	340	4525	6032		605	6835	285	25	5	156	84		5	10	10	1703	103	10	430	519	23	618	618
1092	1092	20201223	MP	118							118	2							2
1107	1107	20201223	PR	70488							70488	1408							1408
1119	1119	20201223	WV	75936	47413	1959				992	25572	1194	814	20				11	349
1124	1124	20201220	AS
1133	1133	20201220	GU	7202	346		2199	3682		389	586	119							119	119
1134	1134	20201220	HI	20217	2050	319	4352	5750		570	7176	282	25	5	153	79		5	15	15	1655	102	10	414	501	23	605	605
1148	1148	20201220	MP	116							116	2							2
1163	1163	20201220	PR	68433							68433	1368							1368
1175	1175	20201220	WV	72342	45119	1889				957	24377	1128	773	19				11	325
1180	1180	20201216	AS
1189	1189	20201216	GU	7168	337		2189	3604		382	656	119							119	119
1190	1190	20201216	HI	19590	2050	319	4352	5750		570	6549	278	25	5	153	79		5	11	11	1371	102	10	414	501	23	321	321
1204	1204	20201216	MP	113							113	2							2

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE [crdt] (
   [Date] INTEGER,
   [State] TEXT,
   [Cases_Total] INTEGER,
   [Cases_White] INTEGER,
   [Cases_Black] INTEGER,
   [Cases_Latinx] INTEGER,
   [Cases_Asian] INTEGER,
   [Cases_AIAN] INTEGER,
   [Cases_NHPI] INTEGER,
   [Cases_Multiracial] INTEGER,
   [Cases_Other] INTEGER,
   [Cases_Unknown] INTEGER,
   [Cases_Ethnicity_Hispanic] INTEGER,
   [Cases_Ethnicity_NonHispanic] INTEGER,
   [Cases_Ethnicity_Unknown] INTEGER,
   [Deaths_Total] INTEGER,
   [Deaths_White] INTEGER,
   [Deaths_Black] INTEGER,
   [Deaths_Latinx] INTEGER,
   [Deaths_Asian] INTEGER,
   [Deaths_AIAN] INTEGER,
   [Deaths_NHPI] INTEGER,
   [Deaths_Multiracial] INTEGER,
   [Deaths_Other] INTEGER,
   [Deaths_Unknown] INTEGER,
   [Deaths_Ethnicity_Hispanic] INTEGER,
   [Deaths_Ethnicity_NonHispanic] INTEGER,
   [Deaths_Ethnicity_Unknown] INTEGER,
   [Hosp_Total] INTEGER,
   [Hosp_White] INTEGER,
   [Hosp_Black] INTEGER,
   [Hosp_Latinx] INTEGER,
   [Hosp_Asian] INTEGER,
   [Hosp_AIAN] INTEGER,
   [Hosp_NHPI] INTEGER,
   [Hosp_Multiracial] INTEGER,
   [Hosp_Other] INTEGER,
   [Hosp_Unknown] INTEGER,
   [Hosp_Ethnicity_Hispanic] INTEGER,
   [Hosp_Ethnicity_NonHispanic] INTEGER,
   [Hosp_Ethnicity_Unknown] INTEGER,
   [Tests_Total] INTEGER,
   [Tests_White] INTEGER,
   [Tests_Black] INTEGER,
   [Tests_Latinx] INTEGER,
   [Tests_Asian] INTEGER,
   [Tests_AIAN] INTEGER,
   [Tests_NHPI] INTEGER,
   [Tests_Multiracial] INTEGER,
   [Tests_Other] INTEGER,
   [Tests_Unknown] INTEGER,
   [Tests_Ethnicity_Hispanic] INTEGER,
   [Tests_Ethnicity_NonHispanic] INTEGER,
   [Tests_Ethnicity_Unknown] INTEGER
);