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

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 Date

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
5153	5153	20200412	AK
5154	5154	20200412	AL	3582	1657	1279		37				66	543	100	2695	788
5155	5155	20200412	AR	1280	814	324		20	4	3	3	35	77
5156	5156	20200412	AS
5157	5157	20200412	AZ	3539	661	65	286	61	223			27	2216				114	28	2	8	3	18				55
5158	5158	20200412	CA	21794	4323	945	4729	1756	27	270		1216	8528				651	224	54	147	92	2	4		10	118
5159	5159	20200412	CO
5160	5160	20200412	CT	11510	3030	993	1277	124				73	6013				494	343	65	45	6				6	29
5161	5161	20200412	DC	1874	354	852		26		6	242		394	241	1146	488	50	6	36	6	2
5162	5162	20200412	DE														35	16							19
5163	5163	20200412	FL
5164	5164	20200412	GA	12922	1887	2723	372	86	9	6	3	64	8144	372	4299	7879
5165	5165	20200412	GU
5166	5166	20200412	HI
5167	5167	20200412	IA
5168	5168	20200412	ID
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
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
5171	5171	20200412	KS
5172	5172	20200412	KY	1959	1123	159		34	1		54		588				1942	1225	342		2					373
5173	5173	20200412	LA
5174	5174	20200412	MA	25475	4271	1358	1885	331				733	16897	1885	6693	16897	756	199	20	28	13				16	480	28	49	480
5175	5175	20200412	MD	8251	2300	3200		190				861	1700				235	83	104		8				12	28
5176	5176	20200412	ME
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
5178	5178	20200412	MN	1642	1086	145		64	16	8		48	275	81	1231	307	70	58	1		1		1			9	2	58	9
5179	5179	20200412	MO	4158	1414	1123					166	83	1372	166	2246	1747	108	37	28					2	2	39	4	62	42
5180	5180	20200412	MP
5181	5181	20200412	MS	2780	1001	1529						250					95	32	63
5182	5182	20200412	MT	387	305	1		1	13			1	66
5183	5183	20200412	NC	4520	1768	1245		54	16	8		114	1315	239	2487	1794	81	46	29		1					5	2	68	11
5184	5184	20200412	ND
5185	5185	20200412	NE
5186	5186	20200412	NH
5187	5187	20200412	NJ														726	435	175		36				80
5188	5188	20200412	NM
5189	5189	20200412	NV
5190	5190	20200412	NY														6723	3440	2333		576				374		2656
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
5192	5192	20200412	OK
5193	5193	20200412	OR
5194	5194	20200412	PA
5195	5195	20200412	PR
5196	5196	20200412	RI
5197	5197	20200412	SC	2010	1108	780						61	61	103	1507	454	61	25	28							8
5198	5198	20200412	SD
5199	5199	20200412	TN	5308	2504	922		73				266	1543	269	3291	1748
5200	5200	20200412	TX	2021	787	223	518	91				15	387
5201	5201	20200412	UT
5202	5202	20200412	VA	5274	1528	841						503	2402
5203	5203	20200412	VI
5204	5204	20200412	VT
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
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
5207	5207	20200412	WV
5208	5208	20200412	WY
5097	5097	20200415	AK	293	133	4		25	13	3	6	3	106	15	154	124	9	2	0		2	2	1	0	0	2	0	5	4
5098	5098	20200415	AL	4241	1996	1594		41				85	525	134	3328	779	82	34	43		3					2	3	71	8
5099	5099	20200415	AR	1569	945	441		21	4	5	5	45	103
5100	5100	20200415	AS
5101	5101	20200415	AZ	3962	785	81	366	67	266			34	2363				142	55	5	15	2	29				36
5102	5102	20200415	CA	24424	4921	1111	5873	2063	31	317	317	1270	8521				821	278	85	214	104	2	6		13	119
5103	5103	20200415	CO	8280	4738	582	2441	214	40	43	13	86	123				357	247	25	63	10	2	4	3		3
5104	5104	20200415	CT	13381	3419	1145	1447	144				85	7141				602	409	85	58	9				9	32
5105	5105	20200415	DC	2197	411	1009		31	7	2	300		437	324	1340	533	72	8	54	8	2
5106	5106	20200415	DE														35	16							19
5107	5107	20200415	FL
5108	5108	20200415	GA	15828	2433	3659	568	131	12	8	0	29	9556	568	5630	9062	596	205	297	20	8	1	0	0	1	84	20	503	73
5109	5109	20200415	GU
5110	5110	20200415	HI
5111	5111	20200415	IA	2337	1492	183		65				29	223	345	1480	167
5112	5112	20200415	ID
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
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
5115	5115	20200415	KS
5116	5116	20200415	KY	2291	1348	194		43	1		82		623				122	77	22		1					22
5117	5117	20200415	LA														1103	333	653		9		1		7	100	11	808	284
5118	5118	20200415	MA	29918	5437	1749	2537	397				916	18882	2537	8499	18882	1108	306	40	50	16				21	675	50	383	675
5119	5119	20200415	MD	10032	2425	3724	1075	230				357	2221	1075	6736	2221	349	109	139	13	10				7	71	13	265	71
5120	5120	20200415	ME
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
5122	5122	20200415	MN	1815	1212	180		72	18	8		36	289	90	1392	325	86	73	1		1	1				10	2	73	11
5123	5123	20200415	MO	4895	1762	1419					146	97	1471	195	2839	1861	147	54	48					1	2	42	5	92	50
5124	5124	20200415	MP
5125	5125	20200415	MS	3360	1243	1881						236					96	32	63							1
5126	5126	20200415	MT	404	319	1		1	14			1	68
5127	5127	20200415	NC	5123	2177	1507		71	19	10		148	1191	289	3007	1827	117	62	40		1				3	11	3	91	23
5128	5128	20200415	ND
5129	5129	20200415	NE
5130	5130	20200415	NH
5131	5131	20200415	NJ														726	435	175		36				80
5132	5132	20200415	NM	1467	348	46	382	25	544				122
5133	5133	20200415	NV
5134	5134	20200415	NY														10578	2824	1862	2091	457				304	3040
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
5136	5136	20200415	OK
5137	5137	20200415	OR
5138	5138	20200415	PA
5139	5139	20200415	PR
5140	5140	20200415	RI

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