COVIDtracking_data_archive: crdt: 5,208 rows where sorted by Deaths_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 Deaths_Ethnicity_Unknown

descending

This data as json, copyable, CSV (advanced)

Link	rowid	Date	State	Cases_Total	Cases_White	Cases_Black	Cases_Asian	Cases_AIAN	Cases_NHPI	Cases_Multiracial	Cases_Other	Cases_Unknown	Cases_Ethnicity_Hispanic	Cases_Ethnicity_NonHispanic	Cases_Ethnicity_Unknown	Deaths_Total	Deaths_White	Deaths_Black	Deaths_Asian	Deaths_AIAN	Deaths_NHPI	Deaths_Multiracial	Deaths_Other	Deaths_Unknown	Hosp_Total	Hosp_White	Hosp_Black	Hosp_AIAN	Hosp_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
590	590	20210124	MT	91652	55790	397	297	7722			6383	21063	2031	54032	35589	1151	617			200			76	258	3846	2592	22	498	734
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
644	644	20210120	MP	129								129				2								2
646	646	20210120	MT	90255	54533	388	289	7622			6321	21102	1971	52761	35523	1094	617			200			76	201	3846	2592	22	498	734
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
700	700	20210117	MP	128								128				2								2
702	702	20210117	MT	89393	53653	379	284	7545			6228	21304	1948	51936	35509	1092	617			200			76	199	3846	2592	22	498	734
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
756	756	20210113	MP	128								128				2								2
758	758	20210113	MT	87653	52770	378	275	7469			6115	20646	1923	51180	34550	1069	617			200			76	176	3846	2592	22	498	734
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
812	812	20210110	MP	125								125				2								2
814	814	20210110	MT	86324	51915	374	265	7379			5953	20438	1897	50328	34099	1056	548			181			62	265	3462	2389	21	482	570
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
868	868	20210106	MP	125								125				2								2
870	870	20210106	MT	84060	50465	366	256	7240			5798	19935	1856	49069	33135	1015	548			181			62	224	3462	2389	21	482	570
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
924	924	20210103	MP	122								122				2								2
926	926	20210103	MT	82381	49540	364	253	7150			5671	19403	1829	48265	32287	972	548			181			62	181	3462	2389	21	482	570
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
980	980	20201230	MP	122								122				2								2
982	982	20201230	MT	81300	48801	363	253	7110			5603	19170	1809	47649	31842	950	548			181			62	159	3462	2389	21	482	570
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
1036	1036	20201227	MP	122								122				2								2
1038	1038	20201227	MT	79780	47740	353	249	7023			5519	18896	1768	46612	31400	924	499			174			32	219	3082	2233	23	453	373
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
1092	1092	20201223	MP	118								118				2								2
1094	1094	20201223	MT	78522	46974	348	246	7029			5420	18505	1755	45922	30845	914	499			174			32	209	3082	2233	23	453	373
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
1148	1148	20201220	MP	116								116				2								2
1150	1150	20201220	MT	77170	45965	343	241	6967			5379	18275	1728	44940	30502	865	499			174			32	160	3082	2233	23	453	373
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
1204	1204	20201216	MP	113								113				2								2
1206	1206	20201216	MT	74644	44383	336	235	6853			5181	17656	1676	43471	29497	836	499			174			32	131	3082	2233	23	453	373
1219	1219	20201216	PR	63686								63686				1312								1312
1231	1231	20201216	WV	66849	42230	1797					913	21909				1039	724	19					10	286
1236	1236	20201213	AS
1260	1260	20201213	MP	113								113				2								2
1262	1262	20201213	MT	73303	43502	332	231	6706			5050	17482	1639	42592	29072	818	392			155			31	240	2572	1858	20	409	285
1275	1275	20201213	PR	62431								62431				1272								1272
1287	1287	20201213	WV	63217	39938	1727					868	20684				968	686	18					9	255

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
);