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

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 PosRes_nh 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	PosResStaff_other	DeathResStaff_other	OutbrkFac_other
4652	4652	20200528	CA		Aggregate	9,183		1725		5437		45																					2143	305	83
4654	4654	20200528	CT		Aggregate	8,322		1884							1007		240
1055	1055	20200723	MI		Cumulative	7,582		1986		3697		21		365
831	831	20200709	MI		Cumulative	7,358		1979		3384		28		340
5077	5077	20200716	OH		Aggregate	6,956				3308				548	755				466				154	1777	262				213						59
1028	1028	20200723	FL		Outbreak	6,925				4758				634	2303				1967				867		225				256						57
4938	4938	20200702	GA		Aggregate	6,365		1094		2762				306											794		179		488						197
4985	4985	20200730	TX		Outbreak	5,775								723	817								357
41	41	20200521	LA		Cumulative	4,084		987		1737				278											526		65								86
4388	4388	20210218	FL	20210216	Outbreak	3,406				649				389	1551				360				421		52				60						29
2220	2220	20201001	TN	20201001	Outbreak	2,918		341		2677				200	142		17		119				38
2888	2888	20201112	SC	20201110	Outbreak	2,408		540		1210		5		63	415		76		261		2		43
3398	3398	20201217	KY	20201216	Outbreak	2,324				1120				215	165				65				44		101				54						24
3519	3519	20201224	MI	20201221	Cumulative	15,570		3261		11758		31		438											2505		739		2415		4				274
3295	3295	20201210	MI	20201208	Cumulative	13,725		2791		9877		26		437											2212		623		2112		3				258
3485	3485	20201224	CT	20201217	Cumulative	12,091		3406		2992		3		212	1554		426		878		1		135
5101	5101	20200723	CO		Aggregate	1,581	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
4653	4653	20200528	CO		Aggregate	1,308	422	329	104	891	515	2		75	395	84	110	16	225	125			47		405	73	145	18	256	122					29
4597	4597	20200521	CO		Aggregate	1,205	420	311	102	840	505	1		72	348	68	101	15	188	119			45		381	73	141	15	251	114					29
6094	6094	20210225	TX	20210225	Cumulative	79066		8808						1222	9998		1522						1085
6878	6878	20210225	TX		Aggregate	79066		8808						1222	9998		1522						1085
6049	6049	20210218	TX	20210218	Cumulative	78036		8720						1222	9970		1519						1080
6861	6861	20210218	TX		Aggregate	78036		8720						1222	9970		1519						1080
6021	6021	20210211	TX	20210211	Cumulative	76982		8671						1222	9935		1514						1077
6833	6833	20210211	TX		Aggregate	76982		8671						1222	9935		1514						1077
5982	5982	20210204	TX	20210204	Cumulative	76135		8511						1222	9780		1473						1069
6822	6822	20210204	TX		Aggregate	76135		8511						1222	9780		1473						1069
5937	5937	20210128	TX	20210128	Cumulative	74112		8238						1222	9455		1424						1055
6805	6805	20210128	TX		Aggregate	74112		8238						1222	9455		1424						1055
5909	5909	20210121	TX	20210121	Cumulative	71272		7940						1222	8967		1329						1038
6777	6777	20210121	TX		Aggregate	71272		7940						1222	8967		1329						1038
5870	5870	20210114	TX	20210114	Cumulative	68072		7596						1219	8326		1238						1017
6766	6766	20210114	TX		Aggregate	68072		7596						1219	8326		1238						1017
5825	5825	20210107	TX	20210107	Cumulative	66183		7150						1216	7632		1125						988
6749	6749	20210107	TX		Aggregate	66183		7150						1216	7632		1125						988
5797	5797	20201231	TX	20201231	Cumulative	61926		6698						1213	6778		1023						940
6721	6721	20201231	TX		Aggregate	61926		6698						1213	6778		1023						940
4489	4489	20210225	CA	20210225	Cumulative	60785		8950		49953		225		1198																			42057	3628	987
6836	6836	20210225	CA		Aggregate	60785		8950		49953		225		1198																			42057	3628	987
4377	4377	20210218	CA	20210216	Cumulative	60666		8897		49782		223		1198																			41756	3533	983
6780	6780	20210218	CA		Aggregate	60666		8897		49782		223		1198																			41756	3533	983
4265	4265	20210211	CA	20210210	Cumulative	60498		8827		49621		219		1198																			41406	3463	977
6724	6724	20210211	CA		Aggregate	60498		8827		49621		219		1198																			41406	3463	977
4153	4153	20210204	CA	20210204	Cumulative	60093		8713		49211		215		1198																			40405	3313	966
6668	6668	20210204	CA		Aggregate	60093		8713		49211		215		1198																			40405	3313	966
4041	4041	20210128	CA	20210128	Cumulative	59362		8541		48709		204		1198																			38864	3144	948
6612	6612	20210128	CA		Aggregate	59362		8541		48709		204		1198																			38864	3144	948
3929	3929	20210121	CA	20210121	Cumulative	58167		8251		47777		202		1198																			36583	2885	927
6556	6556	20210121	CA		Aggregate	58167		8251		47777		202		1198																			36583	2885	927
5758	5758	20201224	TX	20201223	Cumulative	56857		6361						1208	6242		961						924
6710	6710	20201224	TX		Aggregate	56857		6361						1208	6242		961						924
3817	3817	20210114	CA	20210112	Cumulative	55911		7854		46241		196		1198																			34028	2643	886
6500	6500	20210114	CA		Aggregate	55911		7854		46241		196		1198																			34028	2643	886
5713	5713	20201217	TX	20201217	Cumulative	54121		6100						1206	5818		913						905
6693	6693	20201217	TX		Aggregate	54121		6100						1206	5818		913						905
3705	3705	20210107	CA	20210105	Cumulative	52343		7172		43218		191		1196																			30123	2329	826
6444	6444	20210107	CA		Aggregate	52343		7172		43218		191		1196																			30123	2329	826
5685	5685	20201210	TX	20201210	Cumulative	50627		5833						1203	5278		869						884
6665	6665	20201210	TX		Aggregate	50627		5833						1203	5278		869						884
3593	3593	20201231	CA	20201229	Cumulative	48658		6628		39,846		174		1196																			26692	2025	751
6388	6388	20201231	CA		Aggregate	48658		6628		39846		174		1196																			26692	2025	751
5646	5646	20201203	TX	20201203	Cumulative	47320		5539						1197	4909		801						855
6654	6654	20201203	TX		Aggregate	47320		5539						1197	4909		801						855
3481	3481	20201224	CA	20201221	Cumulative	44495		6109		36429		169		1193																			22963	1745	677
6332	6332	20201224	CA		Aggregate	44495		6109		36429		169		1193																			22963	1745	677
5601	5601	20201126	TX	20201124	Cumulative	43828		5237						1187	4512		743						833
6637	6637	20201126	TX		Aggregate	43828		5237						1187	4512		743						833
5573	5573	20201119	TX	20201119	Cumulative	41920		5110						1183	4246		720						801
6609	6609	20201119	TX		Aggregate	41920		5110						1183	4246		720						801
3369	3369	20201217	CA	202012015	Cumulative	40572		5703		33047		167		1192																			20463	1621	626
6276	6276	20201217	CA		Aggregate	40572		5703		33047		167		1192																			20463	1621	626
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
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
5534	5534	20201112	TX	20201112	Cumulative	39272		4909						1174	3862		678						773
6598	6598	20201112	TX		Aggregate	39272		4909						1174	3862		678						773
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
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
5489	5489	20201105	TX	20201105	Cumulative	37369		4722						1160	3525		627						752
6581	6581	20201105	TX		Aggregate	37369		4722						1160	3525		627						752
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
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
3257	3257	20201210	CA	20201201	Cumulative	35648		5317		28571		163		1189																			16855	1465	549
6220	6220	20201210	CA		Aggregate	35648		5317		28571		163		1189																			16855	1465	549
5461	5461	20201029	TX	20201028	Cumulative	35061		4494						1144	3359		594						723
6553	6553	20201029	TX		Aggregate	35061		4494						1144	3359		594						723
5422	5422	20201022	TX	20201022	Cumulative	33437		4373						1131	3164		569						694
6542	6542	20201022	TX		Aggregate	33437		4373						1131	3164		569						694
3145	3145	20201203	CA	20201201	Cumulative	32857		5098		25923		160		1177																			14864	1376	499
6164	6164	20201203	CA		Aggregate	32857		5098		25923		160		1177																			14864	1376	499
5377	5377	20201015	TX	20201015	Cumulative	31964		4251						1119	3008		533						677

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