COVIDtracking_data_archive: ltc: 6,886 rows where sorted by DeathStaff

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

6,886 rows sorted by DeathStaff_other descending

descending

This data as json, copyable, CSV (advanced)

Link	rowid	Date	State_Abbr	data_timestamp	Data_Type	PosRes_nh	ProbPosRes_nh	DeathRes_nh	ProbDeathRes_nh	PosStaff_nh	ProbPosStaff_nh	DeathStaff_nh	ProbDeathStaff_nh	OutbrkFac_nh	PosRes_alf	ProbPosRes_alf	DeathRes_alf	ProbDeathRes_alf	PosStaff_alf	ProbPosStaff_alf	DeathStaff_alf	ProbDeathStaff_alf	OutbrkFac_alf	PosRes_other	ProbPosRes_other	DeathRes_other	ProbDeathRes_other	PosStaff_other	ProbPosStaff_other	DeathStaff_other ▲	ProbDeathStaff_other	OutbrkFac_other
2396	2396	20201015	MD	20201014	Outbreak																			3549		774		2535		9		112
2508	2508	20201022	MD	20201021	Outbreak																			3564		798		2657		9		121
3755	3755	20210211	NC	20210209	Outbreak	12099		1510		7938		8		358										4633		295		2375		8		334
2060	2060	20200924	MD	20200923	Outbreak																			3703		753		2614		7		118
2172	2172	20201001	MD	20200930	Outbreak																			3,292		680		2,172		7		102
2284	2284	20201008	MD	20201007	Outbreak																			3249		677		2164		7		97
3967	3967	20210121	MI	20210119	Cumulative	17356		3881		13577		36		438										3219		876		2932		5		287
4079	4079	20210128	MI	20210125	Cumulative	17628		3961		13833		38		436										3282		888		3060		5		272
4191	4191	20210204	MI	20210201	Cumulative	17872		4007		14053		39		435										3337		924		3122		5		282
4303	4303	20210211	MI	20210208	Cumulative	17976		4050		14191		41		436										3361		931		3181		5		287
4415	4415	20210218	MI	20210216	Cumulative	18043		4079		14292		44		437										3405		942		3221		5		295
4527	4527	20210225	MI	20210222	Cumulative	18097		4100		14372		46		435										3414		951		3243		5		290
6575	6575	20210121	MI		Aggregate	17356		3881		13577		36		438										3219		876		2932		5		287
6631	6631	20210128	MI		Aggregate	17628		3961		13833		38		436										3282		888		3060		5		272
6687	6687	20210204	MI		Aggregate	17872		4007		14053		39		435										3337		924		3122		5		282
6743	6743	20210211	MI		Aggregate	17976		4050		14191		41		436										3361		931		3181		5		287
6799	6799	20210218	MI		Aggregate	18043		4079		14292		44		437										3405		942		3221		5		295
6855	6855	20210225	MI		Aggregate	18097		4100		14372		46		435										3414		951		3243		5		290
3565	3565	20210107	NC	20210107	Outbreak	7923		832		5560		9		337										1850		194		1029		483		273
3407	3407	20201217	MI	20201214	Cumulative	14816		3021		10870		28		438										2378		682		2254		4		272
3519	3519	20201224	MI	20201221	Cumulative	15,570		3261		11758		31		438										2505		739		2415		4		274
3631	3631	20201231	MI	20201228	Cumulative	16084		3492		12247		32		435										2701		786		2575		4		270
3743	3743	20210107	MI	20210104	Cumulative	16499		3683		12702		34		433										2862		826		2750		4		270
3855	3855	20210114	MI	20210111	Cumulative	16971		3784		13175		35		439										2964		817		2804		4		279
6295	6295	20201217	MI		Aggregate	14816		3021		10870		28		438										2378		682		2254		4		272
6351	6351	20201224	MI		Aggregate	15570		3261		11758		31		438										2505		739		2415		4		274
6407	6407	20201231	MI		Aggregate	16084		3492		12247		32		435										2701		786		2575		4		270
6463	6463	20210107	MI		Aggregate	16499		3683		12702		34		433										2862		826		2750		4		270
6519	6519	20210114	MI		Aggregate	16971		3784		13175		35		439										2964		817		2804		4		279
3852	3852	20210114	MD	20210113	Outbreak																			13346		2523		10635		34		306
3404	3404	20201217	MD	20201216	Outbreak																			11733		2221		8733		33		320
3964	3964	20210121	MD	20210120	Outbreak																			13286		2519		10741		33		298
3740	3740	20210107	MD	20210106	Outbreak																			12672		2482		9826		32		304
3292	3292	20201210	MD	20201202	Outbreak																			10336		1910		7742		31		285
3516	3516	20201224	MD	20201223	Outbreak																			12265		2397		9324		31		308
939	939	20200716	MD		Cumulative																			8574		1948		4593		30
1051	1051	20200723	MD		Cumulative																			8727		1971		4788		30
1163	1163	20200730	MD		Cumulative																			8883		2003		4975		30
3628	3628	20201231	MD	20201230	Outbreak																			12077		2368		9240		30		302
4076	4076	20210128	MD	20210127	Outbreak																			12800		2403		10288		30		276
5061	5061	20200716	MD		Aggregate																			8574		1948		4593		30		227
5117	5117	20200723	MD		Aggregate																			8727		1971		4788		30		227
5173	5173	20200730	MD		Aggregate																			8883		2003		4975		30		227
1131	1131	20200730	CO		Cumulative	1607	461	434	125	1102	542	5	0	86	545	90	163	16	342	134	0	0	59	573	87	188	19	345	196	3	0	33
1243	1243	20200806	CO	20200805	Cumulative	1633	461	438	124	1118	542	5	0	88	571	90	169	16	355	133	0	0	60	587	86	193	19	357	201	3	0	33
1355	1355	20200813	CO	20200812	Cumulative	1659	466	439	124	1158	545	5	0	91	574	91	173	16	358	136	0	0	61	592	86	194	18	359	193	3	0	34
2893	2893	20200903	NC	20200901	Outbreak	3585		504		2025		3		200										711		58		426		3		106
3071	3071	20201126	MI	20201123	Cumulative	11464		2501		8018		24		437										1242		445		948		3		240
3183	3183	20201203	MI	20201203	Cumulative	12587		2630		8980		25		435										1985		571		1928		3		245
3295	3295	20201210	MI	20201208	Cumulative	13,725		2791		9877		26		437										2212		623		2112		3		258
3419	3419	20201210	NC	20201208	Outbreak	5247		596		3502		6		272										1412		104		826		3		165
3789	3789	20210218	NC	20210216	Outbreak	11818		1588		8125		8		347										4687		323		2399		3		316
4267	4267	20210211	CO	20210210	Cumulative	7761		1600		6966		13		312	3920		586		3063		6		333	1024		179		844		3		62
4268	4268	20210211	CO	20210210	Outbreak	1520		234		1577		0		71	926		117		852		2		68	214		16		182		3		13
4379	4379	20210218	CO	20210217	Cumulative	7752		1610		6968		8		313	3977		600		3099		18		337	1028		176		853		3		63
4380	4380	20210218	CO	20210217	Outbreak	1067		153		1103		0		49	796		101		685		2		53	144		12		125		3		10
5157	5157	20200730	CO		Aggregate	1607	461	434	125	1102	542	5	0	86	545	90	163	16	342	134	0	0	59	573	87	188	19	345	196	3	0	33
5213	5213	20200806	CO		Aggregate	1633	461	438	124	1118	542	5	0	88	571	90	169	16	355	133	0	0	60	587	86	193	19	357	201	3	0	33
5269	5269	20200813	CO		Aggregate	1659	466	439	124	1158	545	5	0	91	574	91	173	16	358	136	0	0	61	592	86	194	18	359	193	3	0	34
6127	6127	20201126	MI		Aggregate	11464		2501		8018		24		437										1242		445		948		3		240
6183	6183	20201203	MI		Aggregate	12587		2630		8980		25		435										1985		571		1928		3		245
6239	6239	20201210	MI		Aggregate	13725		2791		9877		26		437										2212		623		2112		3		258
6725	6725	20210211	CO		Aggregate	7761		1600		6966		13		312	3920		586		3063		6		333	1024		179		844		3		62
6781	6781	20210218	CO		Aggregate	7752		1610		6968		8		313	3977		600		3099		18		337	1028		176		853		3		63
827	827	20200709	MD		Cumulative																			8464		1932		4470		29
5005	5005	20200709	MD		Aggregate																			8464		1932		4470		29		227
603	603	20200625	MD		Cumulative																			8223		1852		4239		28
715	715	20200702	MD		Cumulative																			8320		1892		4338		28
4188	4188	20210204	MD	20210203	Outbreak																			11814		2253		9607		28		254
4893	4893	20200625	MD		Aggregate																			8223		1852		4239		28		227
4949	4949	20200702	MD		Aggregate																			8320		1892		4338		28		227
491	491	20200618	MD		Cumulative																			8042		1804		4123		26
2956	2956	20201119	MD	20201118	Outbreak																			7008		1337		5045		26		227
4837	4837	20200618	MD		Aggregate																			8042		1804		4123		26		227
3068	3068	20201126	MD	20201125	Outbreak																			8779		1622		6338		25		230
3180	3180	20201203	MD	20201202	Outbreak																			9589		1806		7087		25		285
379	379	20200611	MD		Cumulative																			7967		1743		4032		23
4781	4781	20200611	MD		Aggregate																			7967		1743		4032		23		227
492	492	20200618	MD		Outbreak																			5632		1279		2836		21		160
604	604	20200625	MD		Outbreak																			4445		1017		2229		21		120
347	347	20200611	CO		Cumulative	1445	434	380	111	984	515	2		76	444	82	129	17	267	128			51	494	78	154	19	307	123	2		29
459	459	20200618	CO		Cumulative	1497	449	397	117	1018	602	2		77	448	83	136	17	275	128			51	511	78	168	19	320	121	2		30
571	571	20200625	CO		Cumulative	1521	458	409	120	1031	529	4		78	459	85	146	18	287	133			52	517	84	169	19	321	123	2		30
683	683	20200702	CO		Cumulative	1542	462	415	117	1043	534	4		78	476	87	149	16	295	130			54	525	85	171	19	334	187	2		30
795	795	20200709	CO		Cumulative	1559	468	418	120	1063	539	4	0	79	491	88	150	16	303	132			56	535	80	172	20	321	170	2		30
907	907	20200716	CO		Cumulative	1569	469	431	121	1072	548	4	0	81	512	90	156	16	311	135	0	0	59	539	78	174	19	323	173	2	0	30
1019	1019	20200723	CO		Cumulative	1581	471	433	120	1090	554	4	0	84	545	91	159	16	334	134	0	0	59	545	78	176	19	324	178	2	0	31
1467	1467	20200820	CO	20200820	Cumulative	1692	471	446	126	1172	550	5	0	95	575	91	173	16	358	136	0	0	61	591	86	195	18	357	201	2	0	34
1579	1579	20200827	CO	20200827	Cumulative	1731	476	451	126	1167	545	5	0	96	578	95	176	16	360	136	0	0	62	591	86	195	18	357	201	2	0	34
1691	1691	20200903	CO	20200902	Cumulative	1887	508	494	128	1267	584	5	0	100	590	95	176	16	366	138	0	0	64	478	78	163	18	286	180	2	0	32
1803	1803	20200910	CO	20200909	Cumulative	1902	485	495	127	1274	582	5	0	100	605	95	181	16	371	138	0	0	64	478	78	163	18	286	180	2	0	32
1915	1915	20200917	CO	20200916	Cumulative	1922	479	505	124	1288	588	5	0	103	616	96	181	18	380	143	0	0	65	478	78	163	18	286	180	2	0	32
2027	2027	20200924	CO	20200923	Cumulative	1934	478	506	124	1295	585	5	0	103	634	97	187	16	387	145	0	0	65	478	78	163	18	286	180	2	0	32
2139	2139	20201001	CO	20200930	Cumulative	1961	485	514	124	1306	587	5	0	106	641	97	188	16	394	145	0	0	67	480	78	163	18	286	181	2	0	32
2251	2251	20201008	CO	20201007	Cumulative	1991	487	521	124	1332	589	5	0	108	669	100	193	16	416	149	0	0	71	480	78	163	18	286	181	2	0	32
2363	2363	20201015	CO	20201014	Cumulative	2022	494	524	124	1363	594	5	0	112	736	108	194	17	443	158	0	0	77	485	80	163	18	291	181	2	0	34
2475	2475	20201022	CO	20201021	Cumulative	2066	494	532	125	1401	611	5	0	118	776	103	199	17	459	164	0	0	81	485	79	163	18	293	181	2	0	33
2587	2587	20201029	CO	20201028	Cumulative	2089	490	519	122	1415	605	6	0	125	864	104	209	17	501	165	0	0	84	486	79	164	18	293	181	2	0	33
2669	2669	20200723	NC		Outbreak	2057		361		1168		2		147										662		68		355		2		72
2691	2691	20200730	NC		Outbreak	2264		385		1293		2		162										628		66		336		2		70

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE [ltc] (
   [Date] INTEGER,
   [State_Abbr] TEXT,
   [data_timestamp] TEXT,
   [Data_Type] TEXT,
   [PosRes_nh] INTEGER,
   [ProbPosRes_nh] INTEGER,
   [DeathRes_nh] INTEGER,
   [ProbDeathRes_nh] INTEGER,
   [PosStaff_nh] INTEGER,
   [ProbPosStaff_nh] INTEGER,
   [DeathStaff_nh] INTEGER,
   [ProbDeathStaff_nh] TEXT,
   [PosResStaff_nh] TEXT,
   [ProbPosResStaff_nh] TEXT,
   [DeathResStaff_nh] TEXT,
   [ProbDeathResStaff_nh] TEXT,
   [OutbrkFac_nh] INTEGER,
   [TestedFac_nh] TEXT,
   [OutrkFacTestsConducted_nh] TEXT,
   [TestedRes_nh] TEXT,
   [TestedStaff_nh] TEXT,
   [PosRes_alf] INTEGER,
   [ProbPosRes_alf] INTEGER,
   [DeathRes_alf] INTEGER,
   [ProbDeathRes_alf] INTEGER,
   [PosStaff_alf] INTEGER,
   [ProbPosStaff_alf] INTEGER,
   [DeathStaff_alf] TEXT,
   [ProbDeathStaff_alf] TEXT,
   [PosResStaff_alf] TEXT,
   [ProbPosResStaff_alf] TEXT,
   [DeathResStaff_alf] TEXT,
   [ProbDeathResStaff_alf] TEXT,
   [OutbrkFac_alf] INTEGER,
   [TestedFac_alf] TEXT,
   [OutrkFacTestsConducted_alf] TEXT,
   [TestedRes_alf] TEXT,
   [TestedStaff_alf] TEXT,
   [PosRes_ltc] TEXT,
   [ProbPosRes_ltc] TEXT,
   [DeathRes_ltc] INTEGER,
   [ProbDeathRes_ltc] TEXT,
   [PosStaff_ltc] INTEGER,
   [ProbPosStaff_ltc] TEXT,
   [DeathStaff_ltc] TEXT,
   [ProbDeathStaff_ltc] TEXT,
   [PosResStaff_ltc] TEXT,
   [ProbPosResStaff_ltc] TEXT,
   [DeathResStaff_ltc] TEXT,
   [ProbDeathResStaff_ltc] TEXT,
   [OutbrkFac_ltc] INTEGER,
   [TestedFac_ltc] TEXT,
   [OutrkFacTestsConducted_ltc] TEXT,
   [TestedRes_ltc] TEXT,
   [TestedStaff_ltc] TEXT,
   [PosRes_other] INTEGER,
   [ProbPosRes_other] INTEGER,
   [DeathRes_other] INTEGER,
   [ProbDeathRes_other] INTEGER,
   [PosStaff_other] INTEGER,
   [ProbPosStaff_other] INTEGER,
   [DeathStaff_other] TEXT,
   [ProbDeathStaff_other] TEXT,
   [PosResStaff_other] INTEGER,
   [ProbPosResStaff_other] TEXT,
   [DeathResStaff_other] INTEGER,
   [ProbDeathResStaff_other] TEXT,
   [OutbrkFac_other] INTEGER,
   [TestedFac_other] TEXT,
   [OutrkFacTestsConducted_other] TEXT,
   [TestedRes_other] TEXT,
   [TestedStaff_other] TEXT,
   [] TEXT
);