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_White

descending

This data as json, copyable, CSV (advanced)

Link	rowid	Date	State	Cases_Total	Cases_Unknown	Cases_Ethnicity_Unknown	Deaths_Total	Deaths_White	Deaths_Black	Deaths_Latinx	Deaths_Asian	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
939	939	20210103	PR	78169	78169		1545						1545
947	947	20210103	VI	2042	2042	2042	23						23			23
956	956	20201230	AS
980	980	20201230	MP	122	122		2						2
990	990	20201230	NY	957412	957412	957412	38092	12184	8242	8526	2275	2325	4540	8526	25026	4540	89995	15238	17826	21084	5195	30652	21084	38259	30652
995	995	20201230	PR	75888	75888		1484						1484
1003	1003	20201230	VI	2010	2010	2010	23						23			23
1012	1012	20201227	AS
1036	1036	20201227	MP	122	122		2						2
1046	1046	20201227	NY	922145	922145	922145	37758	12031	8218	8514	2261	2316	4418	8514	24826	4418	89995	15158	17768	21020	5164	30885	21020	38090	30885
1051	1051	20201227	PR	73227	73227		1445						1445
1059	1059	20201227	VI	1979	1979	1979	23						23			23
1068	1068	20201223	AS
1092	1092	20201223	MP	118	118		2						2
1102	1102	20201223	NY	878702	878702	878702	37122	11736	8149	8437	2237	2310	4253	8437	24432	4253	89995	14609	17348	20232	4880	32926	20232	36837	32926
1107	1107	20201223	PR	70488	70488		1408						1408
1115	1115	20201223	VI	1950	1950	1950	23						23			23

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