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_Other

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_Unknown	Cases_Ethnicity_Hispanic	Cases_Ethnicity_NonHispanic	Cases_Ethnicity_Unknown	Deaths_Total	Deaths_White	Deaths_Black	Deaths_Latinx	Deaths_Asian	Deaths_AIAN	Deaths_NHPI	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_AIAN	Hosp_NHPI	Hosp_Other	Hosp_Unknown	Hosp_Ethnicity_Hispanic	Hosp_Ethnicity_NonHispanic	Hosp_Ethnicity_Unknown
4	4	20210228	AS
20	20	20210228	KY	404622	262754	26247		3603	813	369	15733	95103	17185	294780	92657	4637	3776	364		22	4	2	112		357	71	4051	515
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
76	76	20210224	KY	400307	261743	26161		3590	809	369	15655	91980	16990	291102	92215	4527	3684	355		22	4	2	110		350	69	3951	507
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
132	132	20210221	KY	396997	259646	25922		3555	803	364	15455	91252	16838	287899	92260	4447	3620	346		22	4	1	106		348	68	3878	501
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
188	188	20210217	KY	391772	256350	25594		3513	789	359	15214	89953	16608	283398	91766	4336	3521	336		22	4	1	106		346	67	3774	495
196	196	20210217	MP	135								135				2									2
204	204	20210217	NM	181332	30010	2230	80402	1559	29647			37484	80402	63446	37484	3562	1042	48	1385	26	1014				47	1385	2130	47	12790	2321	135	4598	112	3846	22	179	1577	4598	6615	1577
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
244	244	20210214	KY	388798	253424	25306		3486	751	355	14954	90522	16452	279690	92656	4282	3475	331		22	4	1	106		343	66	3722	494
252	252	20210214	MP	134								134				2									2
260	260	20210214	NM	180571	29776	2202	79992	1552	29505			37544	79992	63035	37544	3529	999	47	1329	26	988				140	1329	2060	140	12679	2182	128	4321	106	3693	21	181	2047	4321	6311	2047
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
300	300	20210210	KY	383032	249944	24919		3420	742	347	14677	88983	16231	274077	92724	4175	3387	323		22	4	1	105		333	66	3632	477
308	308	20210210	MP	133								133				2									2
316	316	20210210	NM	178790	29267	2181	79329	1519	29321			37173	79329	62288	37173	3461	999	47	1329	26	988				72	1329	2060	72	12557	2182	128	4321	106	3693	21	181	1925	4321	6311	1925
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
356	356	20210207	KY	377790	246596	24631		3375	735	341	14502	87610	16095	269836	91859	4051	3275	317		21	4	1	103		330	66	3512	473
364	364	20210207	MP	133								133				2									2
372	372	20210207	NM	177556	28977	2166	78728	1509	29172			37004	78728	61824	37004	3399	964	45	1277	26	952				135	1277	1987	135	12408	2182	128	4321	106	3693	21	181	1776	4321	6311	1776
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
412	412	20210203	KY	369519	241550	24141		3304	716	333	14239	85236	15880	262834	90805	3863	3115	308		20	3	1	97		319	65	3341	457
420	420	20210203	MP	133								133				2									2
428	428	20210203	NM	175652	28561	2142	77989	1493	28947			36520	77989	61143	36520	3338	964	45	1277	26	952				74	1277	1987	74	12247	2182	128	4321	106	3693	21	181	1615	4321	6311	1615
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
468	468	20210131	KY	362890	237091	23733		3241	702	323	13938	83862	15642	256353	90895	3745	3013	302		20	3	1	91		315	61	3232	452
476	476	20210131	MP	132								132				2									2
484	484	20210131	NM	174064	27589	2071	74708	1444	28581			39671	74708	59685	39671	3283	927	45	1211	25	916				159	1211	1913	159	12075	2063	121	4086	101	3540	20	182	1962	4086	6027	1962
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
524	524	20210127	KY	352943	231094	23093		3147	674	310	13498	81127	15273	246572	91098	3542	2849	287		20	3	1	86		296	58	3061	423
532	532	20210127	MP	132								132				2									2
540	540	20210127	NM	171047	26854	2035	72677	1419	28137			39925	72677	58445	39925	3198	927	45	1211	25	916				74	1211	1913	74	11824	2063	121	4086	101	3540	20	182	1711	4086	6027	1711
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
580	580	20210124	KY	346586	227161	22781		3109	661	304	13282	79288	15092	241983	89511	3421	2749	278		19	3	1	85		286	56	2953	412
588	588	20210124	MP	129								129				2									2
596	596	20210124	NM	169205	26497	2013	71658	1387	27817			39833	71658	57714	39833	3145	867	42	1125	23	859				229	1125	1791	229	11523	1951	116	3893	107	3437	19	194	1806	3893	5824	1806
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
636	636	20210120	KY	334321	220641	22268		3055	642	282	12872	74561	14806	233934	85581	3243	2605	265		19	2	1	79		272	55	2802	386
644	644	20210120	MP	129								129				2									2
652	652	20210120	NM	165835	25886	1956	70214	1359	27263			39157	70214	56464	39157	3009	867	42	1125	23	859				93	1125	1791	93	11280	1951	116	3893	107	3437	19	194	1563	3893	5824	1563
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
692	692	20210117	KY	326675	215945	21842		3000	626	275	12571	72416	14576	227922	84177	3127	2509	259		19	2	1	77		260	54	2708	365
700	700	20210117	MP	128								128				2									2
704	704	20210117	ND	95864	51947	2755		1280	4103		1203	34576			95864	1395									1395			1395
708	708	20210117	NM	163637	25412	1947	69152	1341	26983			38802	69152	55683	38802	2932	805	37	1033	19	808				230	1033	1669	230	11106	1879	112	3739	93	3309	19	187	1768	3739	5599	1768
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
748	748	20210113	KY	313282	208490	21146		2898	601	261	12145	67741	14218	218151	80913	2991	2399	250		18	2	1	75		246	53	2588	350
756	756	20210113	MP	128								128				2									2
764	764	20210113	NM	159119	24615	1909	67323	1304	26397			37571	67323	54225	37571	2807	805	37	1033	19	808				105	1033	1669	105	10872	1879	112	3739	93	3309	19	187	1534	3739	5599	1534
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
804	804	20210110	KY	303625	202750	20565		2823	590	243	11687	64967	13811	210580	79234	2901	2328	245		17	2	1	69		239	53	2501	347
812	812	20210110	MP	125								125				2									2
820	820	20210110	NM	156157	24079	1858	66179	1264	25953			36824	66179	53154	36824	2749	770	36	945	19	770				209	945	1595	209	10659	1733	106	3528	88	3132	18	185	1869	3528	5262	1869

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