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_Asian

descending

This data as json, copyable, CSV (advanced)

Link	rowid	Date	State	Cases_Total	Cases_White	Cases_Black	Cases_Latinx	Cases_Multiracial	Cases_Other	Cases_Unknown	Cases_Ethnicity_Hispanic	Cases_Ethnicity_NonHispanic	Cases_Ethnicity_Unknown	Deaths_Total	Deaths_White	Deaths_Black	Deaths_Latinx	Deaths_Asian	Deaths_Multiracial	Deaths_Other	Deaths_Unknown	Deaths_Ethnicity_Hispanic	Deaths_Ethnicity_NonHispanic	Deaths_Ethnicity_Unknown	Hosp_Total	Hosp_White	Hosp_Black	Hosp_Latinx	Hosp_Asian	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
783	783	20210113	WV	104392	57644	2162		23	1330	43233				1671	1112	23			0	17	519
788	788	20210110	AS
795	795	20210110	FL	1477010	480682	179582	454691		101309	260746	454691	670806	351513	23261	12093	3729	5522			967	950	5522	15790	1949	66533	29780	13449	17314		3458	2532	17314	44884	4335

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