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_Unknown

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_Other	Cases_Unknown	Deaths_Total	Deaths_White	Deaths_Black	Deaths_Asian	Deaths_AIAN	Deaths_NHPI	Deaths_Other	Deaths_Unknown	Deaths_Ethnicity_Unknown
1219	1219	20201216	PR	63686							63686	1312							1312
1231	1231	20201216	WV	66849	42230	1797				913	21909	1039	724	19				10	286
1236	1236	20201213	AS
1245	1245	20201213	GU	7106	337		2189		3604	382	594	118							118	118
1246	1246	20201213	HI	19235	1903	302	4208		5556	522	6744	274	24	5	146		76	5	18	18
1260	1260	20201213	MP	113							113	2							2
1275	1275	20201213	PR	62431							62431	1272							1272
1287	1287	20201213	WV	63217	39938	1727				868	20684	968	686	18				9	255
1292	1292	20201209	AS
1301	1301	20201209	GU	7039	335		2176		3513	378	637	113							113	113
1302	1302	20201209	HI	18741	1903	302	4208		5556	522	6250	266	24	5	146		76	5	10	10
1316	1316	20201209	MP	113							113	2							2
1331	1331	20201209	PR	58962							58962	1219							1219
1343	1343	20201209	WV	58462	36968	1649				819	19026	901	660	17				9	215
1348	1348	20201206	AS
1357	1357	20201206	GU	7004	335		2176		3513	378	602	113							113	113
1358	1358	20201206	HI	18527	1780	296	4020		5358	500	6573	262	20	5	137		71	5	24
1372	1372	20201206	MP	109							109	2							2
1387	1387	20201206	PR	56671							56671	1192							1192
1399	1399	20201206	WV	54997	34648	1589				777	17983	838	627	16				9	186
1404	1404	20201202	AS
1413	1413	20201202	GU	6920	330		2108		3408	367	707	112							112	112
1414	1414	20201202	HI	18044	1780	296	4020		5358	500	6090	244	20	5	137		71	5	6
1428	1428	20201202	MP	106							106	2							2
1443	1443	20201202	PR	53708							53708	1144							1144
1455	1455	20201202	WV	49905	31877	1524				732	15772	778	587	16				8	167
1460	1460	20201129	AS
1469	1469	20201129	GU	6818	330		2108		3408	367	605	112							112	112
1470	1470	20201129	HI	17840	1676	277	3867		5198	457	6365	244	19	5	132		67	5	16
1484	1484	20201129	MP	105							105	2							2
1499	1499	20201129	PR	51702							51702	1094							1094
1511	1511	20201129	WV	46997	30073	1482				15442	0	729	555	16				158	0
1516	1516	20201125	AS
1525	1525	20201125	GU	6705	328		2035		3210	350	782	109							109	109
1526	1526	20201125	HI	17501	1676	277	3867		5198	457	6026	235	19	5	132		67	5	7
1540	1540	20201125	MP	104							104	2							2
1555	1555	20201125	PR	48725							48725	1052							1052
1567	1567	20201125	WV	43050	28399	1443				13208	0	695	536	15				144	32
1572	1572	20201122	AS
1581	1581	20201122	GU	6549	328		2035		3210	350	626	106							106	106
1582	1582	20201122	HI	17220	1626	276	3809		5093	438	5978	233	19	5	128		61	5	15
1596	1596	20201122	MP	104							104	2							2
1611	1611	20201122	PR	47459							47459	1017							1017
1623	1623	20201122	WV	40478	26616	1400				12462	0	662	504	15				143	0
1628	1628	20201118	AS
1637	1637	20201118	GU	6346	315		1750		3048	334	899	100							100	100
1638	1638	20201118	HI	16734	1522	239	3677		4854	402	6040	223	19	5	128		61	5	5
1652	1652	20201118	MP	103							103	2							2
1667	1667	20201118	PR	43910							43910	971							971
1679	1679	20201118	WV	36277	24384	1279				10614	0	612	471	15				126	0
1684	1684	20201115	AS
1693	1693	20201115	GU	6121	315		1750		3048	334	674	94							94	94
1694	1694	20201115	HI	16519	1522	239	3677		4854	402	5825	222	19	5	128		61	5	4
1708	1708	20201115	MP	102							102	2							2
1723	1723	20201115	PR	42479							42479	935							935
1735	1735	20201115	WV	33659	23024	1213				9422	0	582	456	15				111	0
1740	1740	20201111	AS
1749	1749	20201111	GU	5755	312		1677		2878	312	576	91							91	91
1750	1750	20201111	HI	16205	1417	225	3463		4567	379	6154	222	19	5	124		58	5	11
1764	1764	20201111	MP	100							100	2							2
1779	1779	20201111	PR	39120							39120	901							901
1791	1791	20201111	WV	30201	21598	1164				7439	0	553	432	15				106	0
1796	1796	20201108	AS
1805	1805	20201108	GU	5233	309		1261		2744	307	612	89							89	89
1806	1806	20201108	HI	15947	1417	225	3463		4567	379	5896	221	19	5	124		58	5	10
1820	1820	20201108	MP	98							98	2							2
1835	1835	20201108	PR	38100							38100	872							872
1847	1847	20201108	WV	28404	20478	1138				6788	0	502	398	14				90	0
1852	1852	20201104	AS
1861	1861	20201104	GU	4903	306		1213		2633	304	447	83							83	83
1862	1862	20201104	HI	15473	1357	218	3335		4257	340	5966	219	19	5	124		58	5	8
1876	1876	20201104	MP	96							96	2							2
1891	1891	20201104	PR	69020							69020	850							850
1903	1903	20201104	WV	25987	19223	1101				5663	0	472	378	14				80	0
1908	1908	20201101	AS
1917	1917	20201101	GU	4690	299		1132		2481	288	490	79							79	79
1918	1918	20201101	HI	15154	1357	218	3335		4257	340	5647	219	19	5	124		58	5	8
1932	1932	20201101	MP	96							96	2							2
1947	1947	20201101	PR	66661							66661	832							832
1959	1959	20201101	WV	24883	18508	1086				5289	0	457	372	14				71	0
1964	1964	20201028	AS
1973	1973	20201028	GU	4466	293		1107		2379	275	412	77							77	77
1974	1974	20201028	HI	14834	1299	206	3170		3918	314	5927	213	20	5	119		55	5	9
1988	1988	20201028	MP	92							92	2							2
2003	2003	20201028	PR	63587							63587	813							813
2015	2015	20201028	WV	23064	17477	1057				4530	0	436	359	14				63	0
2020	2020	20201025	AS
2029	2029	20201025	GU	4216	285		1036		2194	259	442	71							71	71
2030	2030	20201025	HI	14672	1299	206	3170		3918	314	5765	212	20	5	119		55	5	8
2044	2044	20201025	MP	88							88	2							2
2059	2059	20201025	PR	62503							62503	801							801
2071	2071	20201025	WV	21906	16688	1040				4178	0	423	352	14				57	0
2076	2076	20201021	AS
2085	2085	20201021	GU	3968	278		1003		2082	248	357	69							69	69
2086	2086	20201021	HI	14233	1243	195	3012		3610	323	5850	203	17	5	104		50	5	22
2100	2100	20201021	MP	88							88	2							2
2115	2115	20201021	PR	58830							58830	774							774
2127	2127	20201021	WV	20734	15855	1028		0		3851	0	413	346	12		0		55	14
2132	2132	20201018	AS
2141	2141	20201018	GU	3675	274		899		1805	234	463	66							66	66

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