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_Total

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_White	Deaths_AIAN	Deaths_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
4204	4204	20200610	AS																0
4260	4260	20200607	AS																0
4316	4316	20200603	AS																0
4372	4372	20200531	AS
4428	4428	20200527	AS
4484	4484	20200524	AS
4540	4540	20200520	AS
4596	4596	20200517	AS
4652	4652	20200513	AS
4708	4708	20200510	AS
4761	4761	20200506	AK	372	225	9		44	22	13	11	9	39	32	277	63
4764	4764	20200506	AS
4773	4773	20200506	GU
4774	4774	20200506	HI	656	178	5		189		80	149	11	44
4784	4784	20200506	ME	1254	829	73		20	2		2	26	302	32	781	441
4788	4788	20200506	MP
4790	4790	20200506	MT	456	421	2		1	24			2	6	8	427	21	12	4
4792	4792	20200506	ND
4793	4793	20200506	NE
4796	4796	20200506	NM	4291	659	135	898	42	2394				133	898	3230	133
4797	4797	20200506	NV
4803	4803	20200506	PR
4806	4806	20200506	SD	2779	932	511	504	309	157			366		504	2275
4809	4809	20200506	UT	5595	2299	141	2069	131	150	143		582	616	2069	2910	616
4811	4811	20200506	VI

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