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_Other

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_Unknown	Deaths_Ethnicity_Hispanic	Deaths_Ethnicity_NonHispanic	Deaths_Ethnicity_Unknown	Hosp_Total	Hosp_White	Hosp_Black	Hosp_Latinx	Hosp_Asian	Hosp_AIAN	Hosp_NHPI	Hosp_Other	Hosp_Unknown	Hosp_Ethnicity_Hispanic	Hosp_Ethnicity_NonHispanic	Hosp_Ethnicity_Unknown
4	4	20210228	AS
20	20	20210228	KY	404622	262754	26247		3603	813	369	15733		95103	17185	294780	92657	4637	3776	364		22	4	2	112	357	71	4051	515
28	28	20210228	MP	143									143				2								2
32	32	20210228	ND	99809	55202	2863		1314	4344		1344	28	34714			99809	1472								1472			1472
36	36	20210228	NM	185132	31742	2322	86227	1654	30265	285		4892	27745	86227	71160	27745	3716	1075	49	1426	26	1038			102	1426	2188	102	13108	2333	137	4529	114	4128	23	172	1672	4529	6907	1672
43	43	20210228	PR	100297									100297				2036								2036
51	51	20210228	VI	2646									2646			2646	25								25			25
60	60	20210224	AS
76	76	20210224	KY	400307	261743	26161		3590	809	369	15655		91980	16990	291102	92215	4527	3684	355		22	4	2	110	350	69	3951	507
84	84	20210224	MP	143									143				2								2
88	88	20210224	ND	99531	54919	2853		1312	4331		1324	27	34765			99531	1470								1470			1470
92	92	20210224	NM	183781	30688	2261	81956	1597	29998	273		5010	31998	81956	69827	31998	3658	1075	49	1426	26	1038			44	1426	2188	44	13024	2333	137	4529	114	4128	23	172	1588	4529	6907	1588
99	99	20210224	PR	99519									99519				2007								2007
107	107	20210224	VI	2613									2613			2613	25								25			25
116	116	20210221	AS
132	132	20210221	KY	396997	259646	25922		3555	803	364	15455		91252	16838	287899	92260	4447	3620	346		22	4	1	106	348	68	3878	501
140	140	20210221	MP	143									143				2								2
144	144	20210221	ND	99277	54719	2842		1310	4317		1313	26	34750			99277	1465								1465			1465
148	148	20210221	NM	182789	30308	2242	80933	1586	29890	271		5011	32548	80933	69308	32548	3624	1042	48	1385	26	1014			109	1385	2130	109	12916	2321	135	4598	112	3846	22	179	1703	4598	6615	1703
155	155	20210221	PR	99084									99084				1979								1979
163	163	20210221	VI	2575									2575			2575	25								25			25
172	172	20210217	AS
188	188	20210217	KY	391772	256350	25594		3513	789	359	15214		89953	16608	283398	91766	4336	3521	336		22	4	1	106	346	67	3774	495
196	196	20210217	MP	135									135				2								2
200	200	20210217	ND	98901	54385	2837		1308	4305		1293	26	34747			98901	1461								1461			1461
204	204	20210217	NM	181332	30010	2230	80402	1559	29647				37484	80402	63446	37484	3562	1042	48	1385	26	1014			47	1385	2130	47	12790	2321	135	4598	112	3846	22	179	1577	4598	6615	1577
211	211	20210217	PR	98428									98428				1930								1930
219	219	20210217	VI	2545									2545			2545	25								25			25
228	228	20210214	AS
244	244	20210214	KY	388798	253424	25306		3486	751	355	14954		90522	16452	279690	92656	4282	3475	331		22	4	1	106	343	66	3722	494
252	252	20210214	MP	134									134				2								2
256	256	20210214	ND	98597	54128	2824		1311	4287		1282	26	34739			98597	1461								1461			1461
260	260	20210214	NM	180571	29776	2202	79992	1552	29505				37544	79992	63035	37544	3529	999	47	1329	26	988			140	1329	2060	140	12679	2182	128	4321	106	3693	21	181	2047	4321	6311	2047
267	267	20210214	PR	97609									97609				1919								1919
275	275	20210214	VI	2524									2524			2524	25								25			25
284	284	20210210	AS
300	300	20210210	KY	383032	249944	24919		3420	742	347	14677		88983	16231	274077	92724	4175	3387	323		22	4	1	105	333	66	3632	477
308	308	20210210	MP	133									133				2								2
312	312	20210210	ND	98214	53795	2812		1307	4260		1271	25	34744			98214	1459								1459			1459
316	316	20210210	NM	178790	29267	2181	79329	1519	29321				37173	79329	62288	37173	3461	999	47	1329	26	988			72	1329	2060	72	12557	2182	128	4321	106	3693	21	181	1925	4321	6311	1925
323	323	20210210	PR	96494									96494				1897								1897
331	331	20210210	VI	2485									2485			2485	24								24			24
340	340	20210207	AS
356	356	20210207	KY	377790	246596	24631		3375	735	341	14502		87610	16095	269836	91859	4051	3275	317		21	4	1	103	330	66	3512	473
364	364	20210207	MP	133									133				2								2
368	368	20210207	ND	98155	53694	2809		1310	4245		1265	25	34807			98155	1451								1451			1451
372	372	20210207	NM	177556	28977	2166	78728	1509	29172				37004	78728	61824	37004	3399	964	45	1277	26	952			135	1277	1987	135	12408	2182	128	4321	106	3693	21	181	1776	4321	6311	1776
379	379	20210207	PR	95839									95839				1883								1883
387	387	20210207	VI	2466									2466			2466	24								24			24
396	396	20210203	AS
412	412	20210203	KY	369519	241550	24141		3304	716	333	14239		85236	15880	262834	90805	3863	3115	308		20	3	1	97	319	65	3341	457
420	420	20210203	MP	133									133				2								2
424	424	20210203	ND	97936	53445	2805		1313	4223		1255	25	34870			97936	1447								1447			1447
428	428	20210203	NM	175652	28561	2142	77989	1493	28947				36520	77989	61143	36520	3338	964	45	1277	26	952			74	1277	1987	74	12247	2182	128	4321	106	3693	21	181	1615	4321	6311	1615
435	435	20210203	PR	94662									94662				1853								1853
443	443	20210203	VI	2430									2430			2430	24								24			24
452	452	20210131	AS
468	468	20210131	KY	362890	237091	23733		3241	702	323	13938		83862	15642	256353	90895	3745	3013	302		20	3	1	91	315	61	3232	452
476	476	20210131	MP	132									132				2								2
480	480	20210131	ND	97630	53207	2796		1310	4199		1244	25	34849			97630	1442								1442			1442
484	484	20210131	NM	174064	27589	2071	74708	1444	28581				39671	74708	59685	39671	3283	927	45	1211	25	916			159	1211	1913	159	12075	2063	121	4086	101	3540	20	182	1962	4086	6027	1962
491	491	20210131	PR	93624									93624				1829								1829
499	499	20210131	VI	2398									2398			2398	24								24			24
508	508	20210127	AS
524	524	20210127	KY	352943	231094	23093		3147	674	310	13498		81127	15273	246572	91098	3542	2849	287		20	3	1	86	296	58	3061	423
532	532	20210127	MP	132									132				2								2
536	536	20210127	ND	97160	52843	2787		1298	4181		1232	25	34794			97160	1441								1441			1441
540	540	20210127	NM	171047	26854	2035	72677	1419	28137				39925	72677	58445	39925	3198	927	45	1211	25	916			74	1211	1913	74	11824	2063	121	4086	101	3540	20	182	1711	4086	6027	1711
547	547	20210127	PR	92244									92244				1794								1794
555	555	20210127	VI	2373									2373			2373	24								24			24
564	564	20210124	AS
580	580	20210124	KY	346586	227161	22781		3109	661	304	13282		79288	15092	241983	89511	3421	2749	278		19	3	1	85	286	56	2953	412
588	588	20210124	MP	129									129				2								2
592	592	20210124	ND	96817	52610	2782		1287	4152		1226	25	34735			96817	1428								1428			1428
596	596	20210124	NM	169205	26497	2013	71658	1387	27817				39833	71658	57714	39833	3145	867	42	1125	23	859			229	1125	1791	229	11523	1951	116	3893	107	3437	19	194	1806	3893	5824	1806
603	603	20210124	PR	91028									91028				1773								1773
611	611	20210124	VI	2341									2341			2341	24								24			24
620	620	20210120	AS
629	629	20210120	GU	7521	364			2241		3861		406	649				128								128			128
636	636	20210120	KY	334321	220641	22268		3055	642	282	12872		74561	14806	233934	85581	3243	2605	265		19	2	1	79	272	55	2802	386
644	644	20210120	MP	129									129				2								2
648	648	20210120	ND	96222	52206	2763		1284	4118		1206	25	34620			96222	1409								1409			1409
652	652	20210120	NM	165835	25886	1956	70214	1359	27263				39157	70214	56464	39157	3009	867	42	1125	23	859			93	1125	1791	93	11280	1951	116	3893	107	3437	19	194	1563	3893	5824	1563
659	659	20210120	PR	88513									88513				1717								1717
667	667	20210120	VI	2283									2283			2283	24								24			24
676	676	20210117	AS
685	685	20210117	GU	7484	364			2241		3861		406	612				127								127			127
692	692	20210117	KY	326675	215945	21842		3000	626	275	12571		72416	14576	227922	84177	3127	2509	259		19	2	1	77	260	54	2708	365
700	700	20210117	MP	128									128				2								2
704	704	20210117	ND	95864	51947	2755		1280	4103		1203		34576			95864	1395								1395			1395
708	708	20210117	NM	163637	25412	1947	69152	1341	26983				38802	69152	55683	38802	2932	805	37	1033	19	808			230	1033	1669	230	11106	1879	112	3739	93	3309	19	187	1768	3739	5599	1768
715	715	20210117	PR	87381									87381				1703								1703
723	723	20210117	VI	2260									2260			2260	24								24			24
732	732	20210113	AS
741	741	20210113	GU	7444	354			2234		3814		400	642				124								124			124
748	748	20210113	KY	313282	208490	21146		2898	601	261	12145		67741	14218	218151	80913	2991	2399	250		18	2	1	75	246	53	2588	350
756	756	20210113	MP	128									128				2								2
760	760	20210113	ND	95135	51431	2736		1271	4071		1187	23	34416			95135	1364								1364			1364
764	764	20210113	NM	159119	24615	1909	67323	1304	26397				37571	67323	54225	37571	2807	805	37	1033	19	808			105	1033	1669	105	10872	1879	112	3739	93	3309	19	187	1534	3739	5599	1534
771	771	20210113	PR	84639									84639				1659								1659

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