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

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_Asian

descending

This data as json, copyable, CSV (advanced)

Link	rowid	Date	State	Cases_Total	Cases_White	Cases_Black	Cases_Latinx	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_Latinx	Deaths_AIAN	Deaths_Multiracial	Deaths_Other	Deaths_Unknown	Deaths_Ethnicity_Hispanic	Deaths_Ethnicity_NonHispanic	Deaths_Ethnicity_Unknown	Hosp_Total	Hosp_White	Hosp_Black	Hosp_Latinx	Hosp_AIAN	Hosp_Other	Hosp_Unknown	Hosp_Ethnicity_Hispanic	Hosp_Ethnicity_NonHispanic	Hosp_Ethnicity_Unknown
4	4	20210228	AS
11	11	20210228	FL	1909221	649451	233422	594679					138503	293166	594679	897293	417249	31406	16850	4697	7115			1392	1352	7115	21576	2715	80572	37347	15827	20180		4199	3019	20180	55252	5140
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
67	67	20210224	FL	1885661	640042	230333	586613					136314	292359	586613	884442	414606	30878	16565	4635	6990			1368	1320	6990	21237	2651	79675	36925	15636	19965		4156	2993	19965	54614	5096
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
123	123	20210221	FL	1868772	633358	228211	580870					134722	291611	580870	875072	412830	30434	16321	4560	6896			1349	1308	6896	20911	2627	78946	36570	15495	19790		4125	2966	19790	54079	5077
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
179	179	20210217	FL	1844627	623935	224912	572623					132673	290484	572623	861706	410298	29824	15967	4486	6778			1308	1285	6778	20461	2585	77994	36100	15299	19572		4088	2935	19572	53396	5026
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
235	235	20210214	FL	1827373	616930	222833	567024					131132	289454	567024	852372	407977	29275	15652	4419	6669			1278	1257	6669	20078	2528	77255	35689	15175	19431		4058	2902	19431	52843	4981
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
291	291	20210210	FL	1798280	605295	218927	557320					128566	288172	557320	836076	404884	28691	15323	4351	6550			1240	1227	6550	19674	2467	76286	35166	14985	19220		4013	2902	19220	52097	4969
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
347	347	20210207	FL	1777983	597163	216323	550423					126911	287163	550423	825081	402479	28161	14996	4287	6466			1211	1201	6466	19278	2417	75515	34751	14841	19093		3953	2877	19093	51497	4925
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
403	403	20210203	FL	1744619	583795	211699	539102					123630	286393	539102	806220	399297	27472	14578	4217	6325			1179	1173	6325	18776	2371	74383	34140	14627	18833		3898	2885	18833	50616	4934
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
459	459	20210131	FL	1721377	574643	208842	531795					121937	284160	531795	793849	395733	26915	14269	4130	6220			1153	1143	6220	18380	2315	73384	33585	14469	18654		3834	2842	18654	49862	4868
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
515	515	20210127	FL	1676171	556567	203080	518230					117956	280338	518230	770979	386962	26249	13874	4067	6082			1112	1114	6082	17912	2255	72215	32948	14286	18418		3762	2801	18418	48999	4798
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
571	571	20210124	FL	1649449	546306	199845	509203					115743	278352	509203	756415	383831	25693	13543	4003	5990			1087	1070	5990	17523	2180	71219	32386	14121	18263		3702	2747	18263	48246	4710
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
627	627	20210120	FL	1601011	527251	193944	494728					111708	273380	494728	731854	374429	24965	13118	3926	5848			1047	1026	5848	17005	2112	69954	31722	13926	17983		3633	2690	17983	47349	4622
629	629	20210120	GU	7521	364			2241		3861		406	649				128							128			128
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
683	683	20210117	FL	1571279	515798	190408	484754					109181	271138	484754	716653	369872	24515	12820	3885	5781			1024	1005	5781	16664	2070	68987	31187	13783	17821		3574	2622	17821	46644	4522
685	685	20210117	GU	7484	364			2241		3861		406	612				127							127			127
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
704	704	20210117	ND	95864	51947	2755		1280	4103		1203		34576			95864	1395							1395			1395
715	715	20210117	PR	87381									87381				1703							1703
723	723	20210117	VI	2260									2260			2260	24							24			24
727	727	20210117	WV	108821	66444	2451					139	1786	38001				1776	1201	23			2	19	531
732	732	20210113	AS
739	739	20210113	FL	1517472	495545	183998	467616					104606	265707	467616	689960	359896	23759	12392	3792	5624			991	960	5624	16147	1988	67598	30385	13590	17533		3512	2578	17533	45640	4425
741	741	20210113	GU	7444	354			2234		3814		400	642				124							124			124
756	756	20210113	MP	128									128				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
);