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

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_Ethnicity_Hispanic

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_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_NHPI	Hosp_Other	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
14	14	20210228	HI	27559	3547	566	5962		7814		1019	8651	27559	439	37	4		233		130		6	29			439	2214	149	14		514	649	35	853			853
21	21	20210228	LA	430100	215019	134591	16558	1494	489		34062	27887	430100	9608	5697	3684		73	14	13		39	88	238	8966	404
28	28	20210228	MP	143								143		2									2
32	32	20210228	ND	99809	55202	2863	1314	4344		1344	28	34714	99809	1472									1472			1472
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
69	69	20210224	GU	7729	412		2272		3976		430	639	7715	130	3			33		76		4	14			130
70	70	20210224	HI	27320	3547	566	5962		7814		1019	8412	27320	435	37	4		233		130		6	25			435	2204	149	14		514	649	35	843			843
77	77	20210224	LA	426925	215019	134591	16558	1494	489		34062	24712	426925	9528	5697	3684		73	14	13		39	8	238	8966	324
84	84	20210224	MP	143								143		2									2
88	88	20210224	ND	99531	54919	2853	1312	4331		1324	27	34765	99531	1470									1470			1470
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
125	125	20210221	GU	7720	412		2272		3976		430	630	7715	130	3			33		76		4	14			130
126	126	20210221	HI	27174	3505	561	5900		7690		1008	8510	27174	431	37	5		233		130		6	20			431	2182	147	14		510	637	33	841			841
133	133	20210221	LA	424176	212551	133455	16452	1479	485		33741	26013	424176	9466	5619	3637		70	12	12		38	78	217	8149	1100
140	140	20210221	MP	143								143		2									2
144	144	20210221	ND	99277	54719	2842	1310	4317		1313	26	34750	99277	1465									1465			1465
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
181	181	20210217	GU	7703	411		2269		3959		427	637	7689	130	3			32		75		4	16			130
182	182	20210217	HI	26935	3505	561	5900		7690		1008	8271	26935	427	37	1		233		130		6	20			427	2174	147	14		510	637	33	833			833
189	189	20210217	LA	421018	212551	133455	16452	1479	485		33741	22855	421018	9391	5619	3637		70	12	12		38	3	217	8149	1025
196	196	20210217	MP	135								135		2									2
200	200	20210217	ND	98901	54385	2837	1308	4305		1293	26	34747	98901	1461									1461			1461
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
237	237	20210214	GU	7695	411		2269		3959		427	629	7689	130	3			32		75		4	16			130
238	238	20210214	HI	26856	3422	538	5802		7578		954	8562	26856	426	36	5		229		129		6	21			426	2149	140	11		504	618	34	842			842
245	245	20210214	LA	419891	208107	130870	16290	1434	476		33108	29606	419891	9292	5504	3567		68	11	10		36	96	217	8149	926
252	252	20210214	MP	134								134		2									2
256	256	20210214	ND	98597	54128	2824	1311	4287		1282	26	34739	98597	1461									1461			1461
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
293	293	20210210	GU	7683	405		2261		3933		423	661	7636	130	3			32		74		4	17			130
294	294	20210210	HI	26584	3422	538	5802		7578		954	8290	26584	423	36	5		229		129		6	18			423	2140	140	11		504	618	34	833			833
301	301	20210210	LA	414687	208107	130870	16290	1434	476		33108	24402	414687	9212	5504	3567		68	11	10		36	16	217	8149	846
308	308	20210210	MP	133								133		2									2
312	312	20210210	ND	98214	53795	2812	1307	4260		1271	25	34744	98214	1459									1459			1459
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
349	349	20210207	GU	7649	405		2261		3933		423	627	7636	130	3			32		74		4	17			130
350	350	20210207	HI	26468	3310	506	5651		7412		923	8666	26468	418	36	5		223		128		5	21			418	2106	136	11		494	598	33	834			834
357	357	20210207	LA	411812	201219	127645	16033	1370	457		32257	32831	411812	9119	5342	3478		64	10	10		36	179	217	8149	753
364	364	20210207	MP	133								133		2									2
368	368	20210207	ND	98155	53694	2809	1310	4245		1265	25	34807	98155	1451									1451			1451
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
405	405	20210203	GU	7618	389		2251		3914		416	648	7579	129	3			32		74		4	16			129
406	406	20210203	HI	26081	3310	506	5651		7412		923	8279	26081	414	36	5		223		128		5	17			414	2096	136	11		494	598	33	824			824
413	413	20210203	LA	406235	201219	127645	16033	1370	457		32257	27254	406235	9006	5342	3478		64	10	10		36	66	217	8149	640
420	420	20210203	MP	133								133		2									2
424	424	20210203	ND	97936	53445	2805	1313	4223		1255	25	34870	97936	1447									1447			1447
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
461	461	20210131	GU	7587	389		2251		3914		416	617		129	3			32		74		4	16
462	462	20210131	HI	25853	3150	462	5494		7245		876	8626	25853	410	32	5		181		103		5	84			410	2067	133	12		495	593	32	802			802
469	469	20210131	LA	400626	192326	123060	15730	1291	446		31080	36693	400626	8859	5135	3391		59	10	10		34	220	217	8149	493
476	476	20210131	MP	132								132		2									2
480	480	20210131	ND	97630	53207	2796	1310	4199		1244	25	34849	97630	1442									1442			1442
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
517	517	20210127	GU	7568	382		2247		3901		410	628		129	3			32		73		4	17
518	518	20210127	HI	25442	3150	462	5494		7245		876	8215	25442	404	32	5		181		103		5	78			404	2057	133	12		495	593	32	792			792
525	525	20210127	LA	392416	192326	123060	15730	1291	446		31080	28483	392416	8688	5135	3391		59	10	10		34	49	217	8149	322
532	532	20210127	MP	132								132		2									2
536	536	20210127	ND	97160	52843	2787	1298	4181		1232	25	34794	97160	1441									1441			1441
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

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