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_Unknown

descending

This data as json, copyable, CSV (advanced)

Link	rowid	Date	State	Cases_Total	Cases_White	Cases_Black	Cases_Latinx	Cases_Asian	Cases_NHPI	Cases_Multiracial	Cases_Other	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
4	4	20210228	AS
60	60	20210224	AS
116	116	20210221	AS
172	172	20210217	AS
228	228	20210214	AS
284	284	20210210	AS
340	340	20210207	AS
396	396	20210203	AS
452	452	20210131	AS
508	508	20210127	AS
564	564	20210124	AS
620	620	20210120	AS
676	676	20210117	AS
732	732	20210113	AS
788	788	20210110	AS
844	844	20210106	AS
900	900	20210103	AS
956	956	20201230	AS
1012	1012	20201227	AS
1068	1068	20201223	AS
1124	1124	20201220	AS
1180	1180	20201216	AS
1236	1236	20201213	AS
1292	1292	20201209	AS
1348	1348	20201206	AS
1404	1404	20201202	AS
1460	1460	20201129	AS
1516	1516	20201125	AS
1572	1572	20201122	AS
1628	1628	20201118	AS
1684	1684	20201115	AS
1740	1740	20201111	AS
1796	1796	20201108	AS
1852	1852	20201104	AS
1908	1908	20201101	AS
1964	1964	20201028	AS
2020	2020	20201025	AS
2076	2076	20201021	AS
2132	2132	20201018	AS
2188	2188	20201014	AS
2244	2244	20201011	AS
2300	2300	20201007	AS
2356	2356	20201004	AS
2412	2412	20200930	AS
2468	2468	20200927	AS
2524	2524	20200923	AS
2580	2580	20200920	AS
2636	2636	20200916	AS
2692	2692	20200913	AS
2748	2748	20200909	AS
2804	2804	20200906	AS
2860	2860	20200902	AS
2916	2916	20200830	AS
2972	2972	20200826	AS
3028	3028	20200823	AS
3084	3084	20200819	AS
3140	3140	20200816	AS
3196	3196	20200812	AS
3252	3252	20200809	AS
3308	3308	20200805	AS
3364	3364	20200802	AS
3420	3420	20200729	AS
3476	3476	20200726	AS
3532	3532	20200722	AS
3588	3588	20200719	AS
3644	3644	20200715	AS
3700	3700	20200712	AS
3756	3756	20200708	AS																					0
3812	3812	20200705	AS																					0
3868	3868	20200701	AS																					0
3924	3924	20200628	AS																					0
3980	3980	20200624	AS																					0
4036	4036	20200621	AS																					0
4092	4092	20200617	AS																					0
4148	4148	20200614	AS																					0
4159	4159	20200614	IA	23924	14594	2392		2153			4785	6460	13637	3828	652	515	32		32				71	2	45	528	84
4204	4204	20200610	AS																					0
4215	4215	20200610	IA	22624	13575	2488		2036			4525	6109	13123	3393	631	498	31		31				69	2	37	511	82
4260	4260	20200607	AS																					0
4271	4271	20200607	IA	21711	12810	2388		1954			4559	5862	12375	3473	605	471	30		30				72	1	36	484	84
4316	4316	20200603	AS																					0
4327	4327	20200603	IA	20373	12021	2241		1833			4278	5501	11613	3260	574	453	28		28				63	2	34	464	74
4372	4372	20200531	AS
4383	4383	20200531	IA	19619	11380	2158		1765			4316	5101	11183	3335	535	411	26		26				69	2	32	422	74
4412	4412	20200531	RI	14928	5374	1940	6717			447	597	6717	8358		716	588	43	78				0	7		78	638		15075	5374	1940	6717	0	0	0	447	597	0	6717	8358	0
4428	4428	20200527	AS
4437	4437	20200527	GU	171				75	72		24				5									5			5
4439	4439	20200527	IA	18445	10514	2213		1660			4058	4795	10514	3135	496	381	24		14	4	9			59	29	401	69
4468	4468	20200527	RI	14353	5310	1865	6315			430	574	6315	8179		654	537	39	72				0	6		72	582		14494	5310	1865	6315	0	0	0	430	574	0	6315	8179	0
4484	4484	20200524	AS
4493	4493	20200524	GU	166				72	71		23				5									5			5
4495	4495	20200524	IA	17250	9833	2070		1725			3622	4485	9833	2932	456	346	22		13	4	9			54	22	369	63
4540	4540	20200520	AS
4549	4549	20200520	GU	165				72	71		22				5									5			5
4551	4551	20200520	IA	15824	9020	1899		1582			3323	4114	9179	2532	395	304	19		11	3	7			47	19	319	55
4596	4596	20200517	AS
4605	4605	20200517	GU	154				61	70		23				5									5			5
4607	4607	20200517	IA	14651	8223	1821		1463			3144	3675	8368	2606	351	273	19		10	2	7			39	17	281	52
4652	4652	20200513	AS
4661	4661	20200513	GU	151				61	70		20				5									5			5

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