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_White

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_Unknown	Deaths_Total	Deaths_Unknown	Deaths_Ethnicity_Unknown
4	4	20210228	AS
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
60	60	20210224	AS
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
116	116	20210221	AS
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
172	172	20210217	AS
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
228	228	20210214	AS
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
284	284	20210210	AS
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
340	340	20210207	AS
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
396	396	20210203	AS
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
452	452	20210131	AS
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
508	508	20210127	AS
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
564	564	20210124	AS
588	588	20210124	MP	129								129		2	2
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
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
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
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
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
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
760	760	20210113	ND	95135	51431	2736	1271	4071		1187	23	34416	95135	1364	1364	1364
771	771	20210113	PR	84639								84639		1659	1659
779	779	20210113	VI	2166								2166	2166	24	24	24
788	788	20210110	AS
797	797	20210110	GU	7412	354		2234		3814		400	610		124	124	124
812	812	20210110	MP	125								125		2	2
816	816	20210110	ND	94716	51191	2727	1268	4036		1181	22	34291	94716	1360	1360	1360
827	827	20210110	PR	83119								83119		1630	1630
835	835	20210110	VI	2143								2143	2143	24	24	24
844	844	20210106	AS
853	853	20210106	GU	7378	351		2227		3755		396	649		123	123	123
868	868	20210106	MP	125								125		2	2
872	872	20210106	ND	93832	50569	2701	1258	3993		1158	21	34132	93832	1341	1341	1341
883	883	20210106	PR	79612								79612		1570	1570
891	891	20210106	VI	2083								2083	2083	24	24	24
900	900	20210103	AS
909	909	20210103	GU	7327	351		2227		3755		396	598		123	123	123
924	924	20210103	MP	122								122		2	2
928	928	20210103	ND	93041	50089	2691	1256	3933		1143	21	33908	93041	1317	1317	1317
939	939	20210103	PR	78169								78169		1545	1545
947	947	20210103	VI	2042								2042	2042	23	23	23
956	956	20201230	AS
965	965	20201230	GU	7308	348		2219		3726		391	624		121	121	121
980	980	20201230	MP	122								122		2	2
984	984	20201230	ND	92202	49538	2678	1255	3896		1128	21	33686	92202	1289	1289	1289
995	995	20201230	PR	75888								75888		1484	1484
1003	1003	20201230	VI	2010								2010	2010	23	23	23
1012	1012	20201227	AS
1021	1021	20201227	GU	7270	348		2219		3726		391	586		121	121	121
1036	1036	20201227	MP	122								122		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
);