COVIDtracking_data_archive: crdt: 5,208 rows where sorted by rowid descending

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 rowid descending

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_Other	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	Tests_Total	Tests_White	Tests_Black	Tests_Latinx	Tests_Asian	Tests_AIAN	Tests_NHPI	Tests_Multiracial	Tests_Other	Tests_Unknown	Tests_Ethnicity_Hispanic	Tests_Ethnicity_NonHispanic	Tests_Ethnicity_Unknown
5208	5208	20200412	WY
5207	5207	20200412	WV
5206	5206	20200412	WI	3341	1680	857		81	28			74	621	361	2261	718	144	77	61		4	1		0	0	1	4	138	2
5205	5205	20200412	WA	10411	2903	289	1180	451	41	61	112	104	5270	1180	3961	5270	508	290	9	24	36	5	1	3	7	133	24	351	133
5204	5204	20200412	VT
5203	5203	20200412	VI
5202	5202	20200412	VA	5274	1528	841						503	2402
5201	5201	20200412	UT
5200	5200	20200412	TX	2021	787	223	518	91				15	387
5199	5199	20200412	TN	5308	2504	922		73				266	1543	269	3291	1748
5198	5198	20200412	SD
5197	5197	20200412	SC	2010	1108	780						61	61	103	1507	454	61	25	28							8
5196	5196	20200412	RI
5195	5195	20200412	PR
5194	5194	20200412	PA
5193	5193	20200412	OR
5192	5192	20200412	OK
5191	5191	20200412	OH	6604	3524	1328		124	4	2	137	226	1259	174	4268	2162	253	161	33					4	3	52	2	161	90
5190	5190	20200412	NY														6723	3440	2333		576				374		2656
5189	5189	20200412	NV
5188	5188	20200412	NM
5187	5187	20200412	NJ														726	435	175		36				80
5186	5186	20200412	NH
5185	5185	20200412	NE
5184	5184	20200412	ND
5183	5183	20200412	NC	4520	1768	1245		54	16	8		114	1315	239	2487	1794	81	46	29		1					5	2	68	11
5182	5182	20200412	MT	387	305	1		1	13			1	66
5181	5181	20200412	MS	2780	1001	1529						250					95	32	63
5180	5180	20200412	MP
5179	5179	20200412	MO	4158	1414	1123					166	83	1372	166	2246	1747	108	37	28					2	2	39	4	62	42
5178	5178	20200412	MN	1642	1086	145		64	16	8		48	275	81	1231	307	70	58	1		1		1			9	2	58	9
5177	5177	20200412	MI	24635	6652	8130		246	246		985	739	7637	492	12811	11333	1483	535	594		14			14	29	297	14	951	520
5176	5176	20200412	ME
5175	5175	20200412	MD	8251	2300	3200		190				861	1700				235	83	104		8				12	28
5174	5174	20200412	MA	25475	4271	1358	1885	331				733	16897	1885	6693	16897	756	199	20	28	13				16	480	28	49	480
5173	5173	20200412	LA
5172	5172	20200412	KY	1959	1123	159		34	1		54		588				1942	1225	342		2					373
5171	5171	20200412	KS
5170	5170	20200412	IN	7928	3734	1331		55				919	1889	3068	269	4591	343	219	68		1				24	31	5	200	138	7928	3734	1331	0	55	0	0	0	919	1889	3068	269	4591
5169	5169	20200412	IL	20852	5214	5458	2513	691	24	28		988	5936				720	259	308	70	27	2	1		12	41				121587	28794	18691	6932	2780	106	90	0	5851	58343	0	0	0
5168	5168	20200412	ID
5167	5167	20200412	IA
5166	5166	20200412	HI
5165	5165	20200412	GU
5164	5164	20200412	GA	12922	1887	2723	372	86	9	6	3	64	8144	372	4299	7879
5163	5163	20200412	FL
5162	5162	20200412	DE														35	16							19
5161	5161	20200412	DC	1874	354	852		26		6	242		394	241	1146	488	50	6	36	6	2
5160	5160	20200412	CT	11510	3030	993	1277	124				73	6013				494	343	65	45	6				6	29
5159	5159	20200412	CO
5158	5158	20200412	CA	21794	4323	945	4729	1756	27	270		1216	8528				651	224	54	147	92	2	4		10	118
5157	5157	20200412	AZ	3539	661	65	286	61	223			27	2216				114	28	2	8	3	18				55
5156	5156	20200412	AS
5155	5155	20200412	AR	1280	814	324		20	4	3	3	35	77
5154	5154	20200412	AL	3582	1657	1279		37				66	543	100	2695	788
5153	5153	20200412	AK
5152	5152	20200415	WY
5151	5151	20200415	WV
5150	5150	20200415	WI	3721	1881	916		90	34			98	702	443	2490	788	182	104	71		4	2		0	0	1	9	171	2
5149	5149	20200415	WA	10783	3396	400	1532	601	84	78	1	113	4578	1532	4673	4578	567	378	15	33	54	5	2	6	10	64	33	470	64
5148	5148	20200415	VT
5147	5147	20200415	VI
5146	5146	20200415	VA	6889	2214	1278						788	2609
5145	5145	20200415	UT
5144	5144	20200415	TX	2182	838	250	552	98				16	428
5143	5143	20200415	TN	6079	2972	1218		88				350	1451	346	3873	1860
5142	5142	20200415	SD
5141	5141	20200415	SC	3114	1573	1265						153	123	147	2336	473	91	36	45							10
5140	5140	20200415	RI
5139	5139	20200415	PR
5138	5138	20200415	PA
5137	5137	20200415	OR
5136	5136	20200415	OK
5135	5135	20200415	OH	7791	4198	1598		141	4	3	210	324	1313	218	5201	2372	361	261	48		1			6	6	39	7	284	70
5134	5134	20200415	NY														10578	2824	1862	2091	457				304	3040
5133	5133	20200415	NV
5132	5132	20200415	NM	1467	348	46	382	25	544				122
5131	5131	20200415	NJ														726	435	175		36				80
5130	5130	20200415	NH
5129	5129	20200415	NE
5128	5128	20200415	ND
5127	5127	20200415	NC	5123	2177	1507		71	19	10		148	1191	289	3007	1827	117	62	40		1				3	11	3	91	23
5126	5126	20200415	MT	404	319	1		1	14			1	68
5125	5125	20200415	MS	3360	1243	1881						236					96	32	63							1
5124	5124	20200415	MP
5123	5123	20200415	MO	4895	1762	1419					146	97	1471	195	2839	1861	147	54	48					1	2	42	5	92	50
5122	5122	20200415	MN	1815	1212	180		72	18	8		36	289	90	1392	325	86	73	1		1	1				10	2	73	11
5121	5121	20200415	MI	28059	7856	9259		280	280		1402	841	8141	561	14871	12627	1921	768	768		19			38	38	290	19	1306	596
5120	5120	20200415	ME
5119	5119	20200415	MD	10032	2425	3724	1075	230				357	2221	1075	6736	2221	349	109	139	13	10				7	71	13	265	71
5118	5118	20200415	MA	29918	5437	1749	2537	397				916	18882	2537	8499	18882	1108	306	40	50	16				21	675	50	383	675
5117	5117	20200415	LA														1103	333	653		9		1		7	100	11	808	284
5116	5116	20200415	KY	2291	1348	194		43	1		82		623				122	77	22		1					22
5115	5115	20200415	KS
5114	5114	20200415	IN	8953	4468	1576		71				1137	1701	322	3465	5167	439	280	91		2				34	27	5	255	174	8953	4468	1576	0	71	0	0	0	1137	1701	322	3465	5167
5113	5113	20200415	IL	24593	6127	6331	3357	847	34	33		1117	6747				948	355	397	89	33	1	2		16	55				141522	33474	21835	9046	3272	129	103	0	6772	66891	0	0	0
5112	5112	20200415	ID
5111	5111	20200415	IA	2337	1492	183		65				29	223	345	1480	167
5110	5110	20200415	HI
5109	5109	20200415	GU

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