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_Total

descending

This data as json, copyable, CSV (advanced)

Link	rowid	Date	State	Deaths_Total	Deaths_White	Deaths_Black	Deaths_Latinx	Deaths_Asian	Deaths_AIAN	Deaths_NHPI	Deaths_Other	Deaths_Unknown	Deaths_Ethnicity_Hispanic	Deaths_Ethnicity_NonHispanic	Deaths_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
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
4764	4764	20200506	AS
4773	4773	20200506	GU
4781	4781	20200506	LA	2064	833	1184		16	0	4	16	8	36	1647	379
4788	4788	20200506	MP
4792	4792	20200506	ND
4793	4793	20200506	NE
4795	4795	20200506	NJ	8549	3420	1282	1125	347			340	2035	1125	5389	2035
4797	4797	20200506	NV
4798	4798	20200506	NY	20597	5200	3262	3595	815			553	7170	3595	5668	5044
4803	4803	20200506	PR
4811	4811	20200506	VI
4820	4820	20200503	AS
4829	4829	20200503	GU
4832	4832	20200503	ID	64	60	1		2				1	5	58	1
4837	4837	20200503	LA	1670	638	973		13	0	4	14	24	27	1269	372

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