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

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 Deaths_Unknown

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_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
1234	1234	20201213	AL	295631	90818	51189		1044				27391	125189	9713	104733	181185	4102	2087	1225		14				109	91	2961	1050
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
3923	3923	20200628	AR	19818	9148	4476		224	50	1378		2698	1844	4817	15001	0	264	139	67		2		24		19	21	230	13
3979	3979	20200624	AR	17375	7964	4121		168	44	1116		2354	1608	4043	13332	1608	240	130	66		1		17		15	19	210	11
4035	4035	20200621	AR	15561	7226	3823		155	43	978		1884	1452	3634	11927	1452	225	124	65		1		13		14	18	199	8
4091	4091	20200617	AR	13606	6303	3575		123	40	806		1516	1243	3040	10566	1243	197	110	61		1		10		9	13	184	0
4104	4104	20200617	ID	3632	1897	64		48	58	12	138	410	1002	873	1637	1121	88	84	1		2				1	6	82	0
4147	4147	20200614	AR	12501	5701	3390		111	36	688		1503	1072	2648	9853	1072	179	102	54		1		9		8	10	164	5
4160	4160	20200614	ID	3399	1774	65		47	54	12	130	384	929	813	1551	1034	87	83	1		2				1	6	81	0
4174	4174	20200614	MT	601	482	2		1	78			10	28	49	504	48	0
4203	4203	20200610	AR	10368	4973	2920		93	33	561		867	921	2203	8165	921	165	96	51		1		6		8	8	154	3
4230	4230	20200610	MT	561	471	2		1	73			4	10	37	494	30	0
4259	4259	20200607	AR	9426	4469	2725		87	30	450		856	809	1831	7595	809	154	89	48		1		5		8	7	144	3
4286	4286	20200607	MT	545	462	2		1	69			4	7	30	489	26	0
4315	4315	20200603	AR	8067	3816	2515		80	27	346		628	655	1356	6711	655	142	80	46		1		3		8	5	133	4
4342	4342	20200603	MT	525	446	2		1	58			4	14	25	470	30	0
4371	4371	20200531	AR	7253	3463	2372		74	26	295		485	538	1031	6222	538	133	76	46		1		3		7	5	128	0
4372	4372	20200531	AS
4398	4398	20200531	MT	515	441	2		1	53			4	14	21	466	28	16	12				4
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
4427	4427	20200527	AR	6277	3012	2194		62	22	190		358	439	673	5604	439	120	65	45		1		3		6	3	117	0
4428	4428	20200527	AS
4454	4454	20200527	MT	481	437	2		1	32			4	5	19	443	19	16	12				4
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
4483	4483	20200524	AR	5922	2862	2110		61	22	172		321	374	544	5378	374	116	64	44		1		2		5	3	113	0
4484	4484	20200524	AS
4510	4510	20200524	MT	479	437	2		1	30			5	4	19	441	19	16	12				4
4539	4539	20200520	AR	5003	2478	1883		59	18	116		205	244	324	4679	244	107	59	41				2		5	3	104	0
4540	4540	20200520	AS
4566	4566	20200520	MT	478	429	2		1	29			5	12	18	440	20	16	12				4
4595	4595	20200517	AR	4759	2354	1781		55	13	91	32	184	249	268	4242	249	98	49	33				1		5	3	85	10
4596	4596	20200517	AS
4622	4622	20200517	MT	468	427	2		1	29			4	5	11	437	20	16	12				4
4652	4652	20200513	AS

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