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

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 PosStaff_alf 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	DeathRes_ltc	PosRes_other	ProbPosRes_other	DeathRes_other	ProbDeathRes_other	PosStaff_other	ProbPosStaff_other	DeathStaff_other	ProbDeathStaff_other	OutbrkFac_other
4555	4555	20210225	OH	20210225	Cumulative	40437				27107				994	6720				5518				468	7093	1202				1335				147
6869	6869	20210225	OH		Aggregate	40437				27107				994	6720				5518				468	7093	1202				1335				147
4331	4331	20210211	OH	20210211	Cumulative	39807				26753				992	6567				5316				464	5582	1273				1314				145
6757	6757	20210211	OH		Aggregate	39807				26753				992	6567				5316				464	5582	1273				1314				145
4219	4219	20210204	OH	20210204	Cumulative	38965				26326				984	6622				5280				464	5428	1195				1306				144
6701	6701	20210204	OH		Aggregate	38965				26326				984	6622				5280				464	5428	1195				1306				144
4443	4443	20210218	OH	20210217	Cumulative	40440				27147				1002	6329				5220				459	6876	1221				1291				143
6813	6813	20210218	OH		Aggregate	40440				27147				1002	6329				5220				459	6876	1221				1291				143
4107	4107	20210128	OH	20210128	Cumulative	38350				25721				980	6351				5057				460	5256	1109				1260				135
6645	6645	20210128	OH		Aggregate	38350				25721				980	6351				5057				460	5256	1109				1260				135
3771	3771	20210107	OH	20210107	Cumulative	36413				24640				985	5770				4941				429	4690	1438				1595				123
6477	6477	20210107	OH		Aggregate	36413				24640				985	5770				4941				429	4690	1438				1595				123
3883	3883	20210114	OH	20210114	Cumulative	36979				24681				985	5775				4584				443	4896	1056				1222				130
3995	3995	20210121	OH	20210121	Cumulative	36979				24681				985	5775				4584				443	5079	1056				1222				130
6533	6533	20210114	OH		Aggregate	36979				24681				985	5775				4584				443	4896	1056				1222				130
6589	6589	20210121	OH		Aggregate	36979				24681				985	5775				4584				443	5079	1056				1222				130
3659	3659	20201231	OH	20201231	Cumulative	31859				21574				974	4998				4061				416	4487	1,014				1,102				117
6421	6421	20201231	OH		Aggregate	31859				21574				974	4998				4061				416	4487	1014				1102				117
3435	3435	20201217	OH	20201217	Cumulative	29426				19430				976	4202				3316				406	3992	793				843				113
3547	3547	20201224	OH	20201217	Cumulative	29426				19430				976	4202				3316				406	4253	793				843				113
6309	6309	20201217	OH		Aggregate	29426				19430				976	4202				3316				406	3992	793				843				113
6365	6365	20201224	OH		Aggregate	29426				19430				976	4202				3316				406	4253	793				843				113
4379	4379	20210218	CO	20210217	Cumulative	7752		1610		6968		8		313	3977		600		3099		18		337		1028		176		853		3		63
6781	6781	20210218	CO		Aggregate	7752		1610		6968		8		313	3977		600		3099		18		337		1028		176		853		3		63
4491	4491	20210225	CO	20210224	Cumulative	7886		1668		7067		8		321	4030		609		3090		18		339		1033		177		849		0		63
6837	6837	20210225	CO		Aggregate	7886		1668		7067		8		321	4030		609		3090		18		339		1033		177		849		0		63
4267	4267	20210211	CO	20210210	Cumulative	7761		1600		6966		13		312	3920		586		3063		6		333		1024		179		844		3		62
6725	6725	20210211	CO		Aggregate	7761		1600		6966		13		312	3920		586		3063		6		333		1024		179		844		3		62
4155	4155	20210204	CO	20210203	Cumulative	7698		1573		6931		13		309	3887		564		3001		10		327		1018		179		862		0		61
6669	6669	20210204	CO		Aggregate	7698		1573		6931		13		309	3887		564		3001		10		327		1018		179		862		0		61
4043	4043	20210128	CO	20210127	Cumulative	7447		1515		6707		9		307	3770		546		2920		10		323		1042		176		886		0		62
6613	6613	20210128	CO		Aggregate	7447		1515		6707		9		307	3770		546		2920		10		323		1042		176		886		0		62
3931	3931	20210121	CO	20210120	Cumulative	7302		1441		6568		8		301	3694		535		2828		4		308		1044		174		874		0		60
6557	6557	20210121	CO		Aggregate	7302		1441		6568		8		301	3694		535		2828		4		308		1044		174		874		0		60
3323	3323	20201210	OH	20201209	Cumulative	25994				17208				956	3496				2825				394	3706	743				788				109
6253	6253	20201210	OH		Aggregate	25994				17208				956	3496				2825				394	3706	743				788				109
3819	3819	20210114	CO	20210113	Cumulative	7139		1387		6363		8		292	3587		510		2737		5		300		936		162		801		0		60
6501	6501	20210114	CO		Aggregate	7139		1387		6363		8		292	3587		510		2737		5		300		936		162		801		0		60
3707	3707	20210107	CO	20210106	Cumulative	6901		1359		5989		8		284	3385		450		2537		5		289		906		162		755		0		59
6445	6445	20210107	CO		Aggregate	6901		1359		5989		8		284	3385		450		2537		5		289		906		162		755		0		59
3595	3595	20201231	CO	20201230	Cumulative	6694		1283		5692		8		274	3211		406		2395		4		270		799		155		647		0		57
6389	6389	20201231	CO		Aggregate	6694		1283		5692		8		274	3211		406		2395		4		270		799		155		647		0		57
3211	3211	20201203	OH	20201203	Cumulative	23017				14355				948	2874				2272				369	3494	640				634				97
6197	6197	20201203	OH		Aggregate	23017				14355				948	2874				2272				369	3494	640				634				97
3099	3099	20201126	OH	20201125	Cumulative	20422				13364				924	2639				2162				360	3339	638				655				95
6141	6141	20201126	OH		Aggregate	20422				13364				924	2639				2162				360	3339	638				655				95
916	916	20200716	FL		Outbreak	5587				4369				633	1942				1999				816		191				243				54
1028	1028	20200723	FL		Outbreak	6,925				4758				634	2303				1967				867		225				256				57
3483	3483	20201224	CO	20201223	Cumulative	5781	716	1085	140	4589	807	7	0	265	2838	200	367	22	1965	257	2	1	260		627	103	143	12	440	183	0	0	54
6333	6333	20201224	CO		Aggregate	5781	716	1085	140	4589	807	7	0	265	2838	200	367	22	1965	257	2	1	260		627	103	143	12	440	183	0	0	54
2987	2987	20201119	OH	20201119	Cumulative	17958				11578				898	2527				1948				362	3154	590				597				92
6085	6085	20201119	OH		Aggregate	17958				11578				898	2527				1948				362	3154	590				597				92
1140	1140	20200730	FL		Outbreak	8089				4357				611	2509				1870				832		216				238				59
4567	4567	20210225	SC	20210221	Cumulative	8051		1450		4664		18		183	2903		381		1796		5		286
6875	6875	20210225	SC		Aggregate	8051		1450		4664		18		183	2903		381		1796		5		286
4455	4455	20210218	SC	20210214	Cumulative	7880		1435		4579		18		182	2836		380		1748		5		285
6819	6819	20210218	SC		Aggregate	7880		1435		4579		18		182	2836		380		1748		5		285
4343	4343	20210211	SC	20210207	Cumulative	7741		1418		4487		18		182	2747		376		1702		5		282
6763	6763	20210211	SC		Aggregate	7741		1418		4487		18		182	2747		376		1702		5		282
3371	3371	20201217	CO	20201216	Cumulative	5378	671	985	141	4150	772	7	0	245	2498	206	353	22	1694	255	2	1	227		580	101	134	12	383	187	0	0	48
6277	6277	20201217	CO		Aggregate	5378	671	985	141	4150	772	7	0	245	2498	206	353	22	1694	255	2	1	227		580	101	134	12	383	187	0	0	48
2875	2875	20201112	OH	20201105	Cumulative	16375				10206				892	2211				1656				347	3056	495				491				87
6029	6029	20201112	OH		Aggregate	16375				10206				892	2211				1656				347	3056	495				491				87
4231	4231	20210204	SC	20210131	Cumulative	7591		1389		4362		18		182	2593		360		1627		5		277
6707	6707	20210204	SC		Aggregate	7591		1389		4362		18		182	2593		360		1627		5		277
1252	1252	20200806	FL	20200805	Outbreak	8390				4042				598	2360				1580				778		200				259				58
4119	4119	20210128	SC	20210124	Cumulative	7332		1361		4163		17		182	2438		348		1526		5		268
6651	6651	20210128	SC		Aggregate	7332		1361		4163		17		182	2438		348		1526		5		268
3820	3820	20210114	CO	20210113	Outbreak	3357		480		3308		3		136	1907		202		1511		2		137		367		20		333		0		23
3596	3596	20201231	CO	20201230	Outbreak	3451		479		3053		3		138	1933		137		1501		2		150		342		27		243		0		24
3708	3708	20210107	CO	20210106	Outbreak	3495		530		3192		3		141	1903		159		1462		2		147		426		33		328		0		24
1364	1364	20200813	FL	20200813	Outbreak	8221				3628				581	2250				1455				765		197				299				54
2763	2763	20201105	OH	20201105	Cumulative	14998				9205				864	1791				1441				316	2975	447				429				87
5973	5973	20201105	OH		Aggregate	14998				9205				864	1791				1441				316	2975	447				429				87
3259	3259	20201210	CO	20201209	Cumulative	4926	685	902	140	3634	114	7	0	224	2124	212	317	20	1434	58	2	0	199		518	101	132	12	358	28	0	0	46
6221	6221	20201210	CO		Aggregate	4926	685	902	140	3634	114	7	0	224	2124	212	317	20	1434	58	2	0	199		518	101	132	12	358	28	0	0	46
3932	3932	20210121	CO	20210120	Outbreak	2954		428		3061		2		129	1749		196		1408		1		115		482		32		409		0		24
4493	4493	20210225	CT	20210225	Cumulative	13901		3856		4526		4		212	1957		472		1404		2		134
6838	6838	20210225	CT		Aggregate	13901		3856		4526		4		212	1957		472		1404		2		134
4007	4007	20210121	SC	20210117	Cumulative	7039		1344		3961		17		182	2262		333		1403		5		259
6595	6595	20210121	SC		Aggregate	7039		1344		3961		17		182	2262		333		1403		5		259
804	804	20200709	FL		Outbreak	4502				3523				588	1549				1399				653		174				221				52
4381	4381	20210218	CT	20210212	Cumulative	13833		3890		4457		4		212	1935		470		1374		2		134
6782	6782	20210218	CT		Aggregate	13833		3890		4457		4		212	1935		470		1374		2		134
3895	3895	20210114	SC	20210112	Cumulative	6823		1336		3791		17		182	2143		329		1353		5		255
6539	6539	20210114	SC		Aggregate	6823		1336		3791		17		182	2143		329		1353		5		255
4157	4157	20210204	CT	20210204	Cumulative	13782		3873		4400		4		212	1911		471		1347		2		134
4269	4269	20210211	CT	20210204	Cumulative	13782		3873		4400		4		212	1911		471		1347		2		134
6670	6670	20210204	CT		Aggregate	13782		3873		4400		4		212	1911		471		1347		2		134
6726	6726	20210211	CT		Aggregate	13782		3873		4400		4		212	1911		471		1347		2		134
4045	4045	20210128	CT	20210128	Cumulative	13681		3838		4313		4		212	1884		466		1321		2		134
6614	6614	20210128	CT		Aggregate	13681		3838		4313		4		212	1884		466		1321		2		134
1476	1476	20200820	FL	20200819	Outbreak	7712				3326				586	2122				1315				711		151				290				54
3147	3147	20201203	CO	20201202	Cumulative	4184	681	792	140	3041	780	7	0	202	1920	218	302	20	1313	246	2	1	177		463	81	120	12	298	183	0	0	43
6165	6165	20201203	CO		Aggregate	4184	681	792	140	3041	780	7	0	202	1920	218	302	20	1313	246	2	1	177		463	81	120	12	298	183	0	0	43
3484	3484	20201224	CO	20201223	Outbreak	3170	155	431	5	2689	138	2	0	131	1777	69	119	3	1307	86	0	1	148		253	20	27	0	193	26	0	0	21
4044	4044	20210128	CO	20210127	Outbreak	2436		369		2600		3		110	1543		180		1302		7		106		360		25		338		0		21
4012	4012	20210121	TN	20210121	Outbreak	9102		1058		7489				248	1933		227		1258				144		23		1		14				4
3933	3933	20210121	CT	20210121	Cumulative	13515		3841		4160		4		213	1836		457		1255		1		134
6558	6558	20210121	CT		Aggregate	13515		3841		4160		4		213	1836		457		1255		1		134

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