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

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_Black

descending

This data as json, copyable, CSV (advanced)

Link	rowid	Date	State	Cases_Total	Cases_White	Cases_Asian	Cases_NHPI	Cases_Other	Cases_Unknown	Cases_Ethnicity_Unknown	Deaths_Total	Deaths_White	Deaths_Black	Deaths_Latinx	Deaths_Asian	Deaths_NHPI	Deaths_Other	Deaths_Unknown	Deaths_Ethnicity_Hispanic	Deaths_Ethnicity_NonHispanic	Deaths_Ethnicity_Unknown	Hosp_Total	Hosp_White	Hosp_Black	Hosp_Latinx	Hosp_Asian	Hosp_Unknown	Hosp_Ethnicity_Hispanic	Hosp_Ethnicity_NonHispanic	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
28	28	20210228	MP	143					143		2							2
38	38	20210228	NY	1630445					1630445	1630445	47873	16920	9448	9816	2942		2681	6066	9816	31991	6066	89995	21134	23063	27786	7903	10109	27786	52100	10109
43	43	20210228	PR	100297					100297		2036							2036
51	51	20210228	VI	2646					2646	2646	25							25			25
60	60	20210224	AS
69	69	20210224	GU	7729	412	2272	3976	430	639	7715	130	3			33	76	4	14			130
84	84	20210224	MP	143					143		2							2
94	94	20210224	NY	1597774					1597774	1597774	47405	16709	9352	9714	2898		2671	6061	9714	31630	6061	89995	20685	22611	27198	7690	11811	27198	50986	11811
99	99	20210224	PR	99519					99519		2007							2007
107	107	20210224	VI	2613					2613	2613	25							25			25
116	116	20210221	AS
125	125	20210221	GU	7720	412	2272	3976	430	630	7715	130	3			33	76	4	14			130
140	140	20210221	MP	143					143		2							2
150	150	20210221	NY	1578785					1578785	1578785	47068	16562	9283	9627	2846		2728	6022	9627	31419	6022	89995	20490	22389	26892	7557	12667	26892	50436	12667
155	155	20210221	PR	99084					99084		1979							1979
163	163	20210221	VI	2575					2575	2575	25							25			25
172	172	20210217	AS
181	181	20210217	GU	7703	411	2269	3959	427	637	7689	130	3			32	75	4	16			130
196	196	20210217	MP	135					135		2							2
206	206	20210217	NY	1548979					1548979	1548979	46527	16297	9202	9513	2793		2702	6020	9513	30994	6020	89995	20006	21972	26321	7309	14387	26321	49287	14387
211	211	20210217	PR	98428					98428		1930							1930
219	219	20210217	VI	2545					2545	2545	25							25			25
228	228	20210214	AS
237	237	20210214	GU	7695	411	2269	3959	427	629	7689	130	3			32	75	4	16			130
252	252	20210214	MP	134					134		2							2
262	262	20210214	NY	1521453					1521453	1521453	46150	16134	9149	9448	2755		2678	5986	9448	30716	5986	89995	19691	21702	25986	7189	15427	25986	48582	15427
267	267	20210214	PR	97609					97609		1919							1919
275	275	20210214	VI	2524					2524	2524	25							25			25
284	284	20210210	AS
293	293	20210210	GU	7683	405	2261	3933	423	661	7636	130	3			32	74	4	17			130
308	308	20210210	MP	133					133		2							2
318	318	20210210	NY	1494187					1494187	1494187	45567	15843	9039	9328	2715		2670	5972	9328	30267	5972	89995	19149	21229	25288	6937	17392	25288	47315	17392
323	323	20210210	PR	96494					96494		1897							1897
331	331	20210210	VI	2485					2485	2485	24							24			24
340	340	20210207	AS
349	349	20210207	GU	7649	405	2261	3933	423	627	7636	130	3			32	74	4	17			130
364	364	20210207	MP	133					133		2							2
374	374	20210207	NY	1470772					1470772	1470772	45101	15631	8968	9244	2682		2640	5936	9244	29921	5936	89995	18837	20974	24955	6832	18397	24955	46643	18397
379	379	20210207	PR	95839					95839		1883							1883
387	387	20210207	VI	2466					2466	2466	24							24			24
396	396	20210203	AS
405	405	20210203	GU	7618	389	2251	3914	416	648	7579	129	3			32	74	4	16			129
420	420	20210203	MP	133					133		2							2
430	430	20210203	NY	1433304					1433304	1433304	44397	15272	8856	9132	2625		2638	5874	9132	29391	5874	89995	18248	20304	24199	6529	20715	24199	45081	20715
435	435	20210203	PR	94662					94662		1853							1853
443	443	20210203	VI	2430					2430	2430	24							24			24
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
486	486	20210131	NY	1410656					1410656	1410656	43889	15049	8817	9075	2592		2582	5774	9075	29040	5774	89995	18207	20267	24153	6509	20859	24153	44983	20859
491	491	20210131	PR	93624					93624		1829							1829
499	499	20210131	VI	2398					2398	2398	24							24			24
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
542	542	20210127	NY	1361082					1361082	1361082	43144	14707	8725	8972	2534		2540	5666	8972	28506	5666	89995	17812	19888	23760	6344	22191	23760	44044	22191
547	547	20210127	PR	92244					92244		1794							1794
555	555	20210127	VI	2373					2373	2373	24							24			24
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
598	598	20210124	NY	1326987					1326987	1326987	42598	14446	8664	8913	2509		2505	5561	8913	28124	5561	89995	17648	19708	23513	6237	22889	23513	43593	22889
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
654	654	20210120	NY	1271451					1271451	1271451	41849	14061	8587	8839	2454		2469	5439	8839	27571	5439	89995	17248	19325	23024	6054	24344	23024	42627	24344
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
710	710	20210117	NY	1233390					1233390	1233390	41268	13763	8540	8780	2431		2445	5309	8780	27179	5309	89995	16874	19045	22677	5928	25471	22677	41847	25471
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
766	766	20210113	NY	1169947					1169947	1169947	40458	13374	8453	8710	2374		2416	5131	8710	26617	5131	89995	16383	18695	22241	5731	26945	22241	40809	26945
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
822	822	20210110	NY	1126442					1126442	1126442	39899	13125	8393	8673	2355		2374	4979	8673	26247	4979	89995	16172	18529	22072	5644	27578	22072	40345	27578
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
878	878	20210106	NY	1057676					1057676	1057676	39168	12730	8320	8608	2319		2362	4829	8608	25731	4829	89995	15715	18209	21628	5450	28993	21628	39374	28993
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
934	934	20210103	NY	1017153					1017153	1017153	38680	12566	8289	8578	2303		2341	4603	8578	25499	4603	89995	15569	18115	21491	5390	29430	21491	39074	29430

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