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_Hispanic

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	Deaths_Ethnicity_Unknown	Hosp_Total	Hosp_White	Hosp_Black	Hosp_Asian	Hosp_AIAN	Hosp_NHPI	Hosp_Other	Hosp_Unknown	Hosp_Ethnicity_Unknown
4	4	20210228	AS
13	13	20210228	GU	7736	417		2273		3986		431	629			7734	131	3		33		76		4	15	131
14	14	20210228	HI	27559	3547	566	5962		7814		1019	8651			27559	439	37	4	233		130		6	29	439	2214	149	14	514		649	35	853	853
28	28	20210228	MP	143								143				2								2
32	32	20210228	ND	99809	55202	2863	1314	4344		1344	28	34714			99809	1472								1472	1472
43	43	20210228	PR	100297								100297				2036								2036
51	51	20210228	VI	2646								2646			2646	25								25	25
55	55	20210228	WV	131855	86958	3487					2565	38845			131855	2300	1653	38					30	579	2300
60	60	20210224	AS
69	69	20210224	GU	7729	412		2272		3976		430	639			7715	130	3		33		76		4	14	130
70	70	20210224	HI	27320	3547	566	5962		7814		1019	8412			27320	435	37	4	233		130		6	25	435	2204	149	14	514		649	35	843	843
84	84	20210224	MP	143								143				2								2
88	88	20210224	ND	99531	54919	2853	1312	4331		1324	27	34765			99531	1470								1470	1470
99	99	20210224	PR	99519								99519				2007								2007
107	107	20210224	VI	2613								2613			2613	25								25	25
111	111	20210224	WV	130382	85861	3427					2477	38617			130382	2285	1639	38					30	578	2285
116	116	20210221	AS
125	125	20210221	GU	7720	412		2272		3976		430	630			7715	130	3		33		76		4	14	130
126	126	20210221	HI	27174	3505	561	5900		7690		1008	8510			27174	431	37	5	233		130		6	20	431	2182	147	14	510		637	33	841	841
140	140	20210221	MP	143								143				2								2
144	144	20210221	ND	99277	54719	2842	1310	4317		1313	26	34750			99277	1465								1465	1465
155	155	20210221	PR	99084								99084				1979								1979
163	163	20210221	VI	2575								2575			2575	25								25	25
167	167	20210221	WV	129616	85011	3387					2485	38733			129616	2261	1622	36					28	575	2261
172	172	20210217	AS
181	181	20210217	GU	7703	411		2269		3959		427	637			7689	130	3		32		75		4	16	130
182	182	20210217	HI	26935	3505	561	5900		7690		1008	8271			26935	427	37	1	233		130		6	20	427	2174	147	14	510		637	33	833	833
196	196	20210217	MP	135								135				2								2
200	200	20210217	ND	98901	54385	2837	1308	4305		1293	26	34747			98901	1461								1461	1461
211	211	20210217	PR	98428								98428				1930								1930
219	219	20210217	VI	2545								2545			2545	25								25	25
223	223	20210217	WV	128405	83849	3317					2435	38804			128405	2225	1588	36					27	574	2225
228	228	20210214	AS
237	237	20210214	GU	7695	411		2269		3959		427	629			7689	130	3		32		75		4	16	130
238	238	20210214	HI	26856	3422	538	5802		7578		954	8562			26856	426	36	5	229		129		6	21	426	2149	140	11	504		618	34	842	842
252	252	20210214	MP	134								134				2								2
256	256	20210214	ND	98597	54128	2824	1311	4287		1282	26	34739			98597	1461								1461	1461
267	267	20210214	PR	97609								97609				1919								1919
275	275	20210214	VI	2524								2524			2524	25								25	25
279	279	20210214	WV	127588	83104	3284					2421	38779			127588	2210	1571	36					27	576	2210
284	284	20210210	AS
293	293	20210210	GU	7683	405		2261		3933		423	661			7636	130	3		32		74		4	17	130
294	294	20210210	HI	26584	3422	538	5802		7578		954	8290			26584	423	36	5	229		129		6	18	423	2140	140	11	504		618	34	833	833
308	308	20210210	MP	133								133				2								2
312	312	20210210	ND	98214	53795	2812	1307	4260		1271	25	34744			98214	1459								1459	1459
323	323	20210210	PR	96494								96494				1897								1897
331	331	20210210	VI	2485								2485			2485	24								24	24
335	335	20210210	WV	125951	81807	3214				191	2159	38580			125951	2175	1540	36				2	24	573	2175
340	340	20210207	AS
349	349	20210207	GU	7649	405		2261		3933		423	627			7636	130	3		32		74		4	17	130
350	350	20210207	HI	26468	3310	506	5651		7412		923	8666			26468	418	36	5	223		128		5	21	418	2106	136	11	494		598	33	834	834
364	364	20210207	MP	133								133				2								2
368	368	20210207	ND	98155	53694	2809	1310	4245		1265	25	34807			98155	1451								1451	1451
379	379	20210207	PR	95839								95839				1883								1883
387	387	20210207	VI	2466								2466			2466	24								24	24
391	391	20210207	WV	124708	80454	3145				181	2136	38792			124708	2129	1501	34				2	23	569	2129
396	396	20210203	AS
405	405	20210203	GU	7618	389		2251		3914		416	648			7579	129	3		32		74		4	16	129
406	406	20210203	HI	26081	3310	506	5651		7412		923	8279			26081	414	36	5	223		128		5	17	414	2096	136	11	494		598	33	824	824
420	420	20210203	MP	133								133				2								2
424	424	20210203	ND	97936	53445	2805	1313	4223		1255	25	34870			97936	1447								1447	1447
435	435	20210203	PR	94662								94662				1853								1853
443	443	20210203	VI	2430								2430			2430	24								24	24
447	447	20210203	WV	122470	78220	2997				174	2071	39008			122470	2058	1435	32				2	22	567	2058
452	452	20210131	AS
461	461	20210131	GU	7587	389		2251		3914		416	617				129	3		32		74		4	16
462	462	20210131	HI	25853	3150	462	5494		7245		876	8626			25853	410	32	5	181		103		5	84	410	2067	133	12	495		593	32	802	802
476	476	20210131	MP	132								132				2								2
480	480	20210131	ND	97630	53207	2796	1310	4199		1244	25	34849			97630	1442								1442	1442
491	491	20210131	PR	93624								93624				1829								1829
499	499	20210131	VI	2398								2398			2398	24								24	24
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
518	518	20210127	HI	25442	3150	462	5494		7245		876	8215			25442	404	32	5	181		103		5	78	404	2057	133	12	495		593	32	792	792
532	532	20210127	MP	132								132				2								2
536	536	20210127	ND	97160	52843	2787	1298	4181		1232	25	34794			97160	1441								1441	1441
547	547	20210127	PR	92244								92244				1794								1794
555	555	20210127	VI	2373								2373			2373	24								24	24
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
574	574	20210124	HI	25154	3023	441	5345		7073		840	8432			25154	342	30	5	174		95		5	33	342	2014	126	11	484		587	30	776	776
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
592	592	20210124	ND	96817	52610	2782	1287	4152		1226	25	34735			96817	1428								1428	1428
603	603	20210124	PR	91028								91028				1773								1773
611	611	20210124	VI	2341								2341			2341	24								24	24
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
630	630	20210120	HI	24620	3023	441	5345		7073		840	7898			24620	325	30	5	174		95		5	16	325	1996	126	11	484		587	30	758	758
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
648	648	20210120	ND	96222	52206	2763	1284	4118		1206	25	34620			96222	1409								1409	1409
659	659	20210120	PR	88513								88513				1717								1717
667	667	20210120	VI	2283								2283			2283	24								24	24
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

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