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

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 ProbDeathResStaff_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	DeathResStaff_nh	ProbDeathResStaff_nh	OutbrkFac_nh	PosRes_alf	ProbPosRes_alf	DeathRes_alf	ProbDeathRes_alf	PosStaff_alf	ProbPosStaff_alf	DeathResStaff_alf	ProbDeathResStaff_alf ▲	OutbrkFac_alf	PosRes_ltc	DeathRes_ltc	PosStaff_ltc	OutbrkFac_ltc	PosRes_other	ProbPosRes_other	DeathRes_other	ProbDeathRes_other	PosStaff_other	ProbPosStaff_other	PosResStaff_other	DeathResStaff_other	OutbrkFac_other
4105	4105	20210128	NY	20210127	Cumulative								9867	2957	536							160	54	83
4217	4217	20210204	NY	20210203	Cumulative								10206	2957	541							165	54	83
6644	6644	20210128	NY		Aggregate								9867	2957	536							160	54	83
6700	6700	20210204	NY		Aggregate								10206	2957	541							165	54	83
75	75	20200521	NY		Cumulative								3118	2646								115	52
187	187	20200528	NY		Cumulative								3282	2646	384							115	52	56
299	299	20200604	NY		Cumulative								3350	2718	388							117	52	58
409	409	20200611	NY		Cumulative								3436	2718	392							118	52	58
521	521	20200618	NY		Cumulative								3506	2718	392							121	52	58
633	633	20200625	NY		Cumulative								3541	2718	395							121	52	58
745	745	20200702	NY		Cumulative								3563	2718	394							122	52	58
857	857	20200709	NY		Cumulative								3590	2718	394							123	52	59
969	969	20200716	NY		Cumulative								3599	2718	394							123	52	58
1081	1081	20200723	NY		Cumulative								3613	2783	395							123	52	59
1193	1193	20200730	NY		Cumulative								3620	2783	395							123	52	59
1305	1305	20200806	NY	20200805	Cumulative								3643	2783	397							124	52	60
1417	1417	20200813	NY	20200811	Cumulative								3653	2783	398							124	52	60
1529	1529	20200820	NY	20200819	Cumulative								3665	2783	399							124	52	60
1641	1641	20200827	NY	20200826	Cumulative								3676	2783	400							124	52	60
1753	1753	20200903	NY	20200903	Cumulative								3680	2783	400							125	52	60
1865	1865	20200910	NY	20200909	Cumulative								3689	2783	402							125	52	60
1977	1977	20200917	NY	20200917	Cumulative								3692	2783	403							125	52	60
2089	2089	20200924	NY	20200923	Cumulative								3696	2783	403							125	52	60
2201	2201	20201001	NY	20200930	Cumulative								3701	2783	404							126	52	61
2313	2313	20201008	NY	20201007	Cumulative								3718	2783	406							126	52	61
2425	2425	20201015	NY	20201014	Cumulative								3736	2783	407							126	52	61
2537	2537	20201022	NY	20201021	Cumulative								3747	2783	407							126	52	61
2649	2649	20201029	NY	20201028	Cumulative								3767	2783	412							127	52	61
2761	2761	20201105	NY	20201103	Cumulative								3775	2783	414							127	52	61
2873	2873	20201112	NY	20201111	Cumulative								3825	2783	415							127	52	61
2985	2985	20201119	NY	20201118	Cumulative								3879	2783	421							127	52	61
3097	3097	20201126	NY	20201124	Cumulative								3983	2783	436							127	52	61
3209	3209	20201203	NY	20201202	Cumulative								4089	2783	446							128	52	62
3321	3321	20201210	NY	20201209	Cumulative								4251	2783	456							129	52	63
3433	3433	20201217	NY	20201216	Cumulative								4462	2783	469							133	52	65
3545	3545	20201224	NY	20201222	Cumulative								4685	2783	477							134	52	65
3657	3657	20201231	NY	20201230	Cumulative								4926	2783	493							138	52	67
3769	3769	20210107	NY	20210106	Cumulative								5197	2783	503							144	52	73
3881	3881	20210114	NY	20210113	Cumulative								5497	2783	518							148	52	76
3993	3993	20210121	NY	20210120	Cumulative								5758	2783	527							151	52	77
4628	4628	20200521	NY		Aggregate								3118	2646								115	52
4684	4684	20200528	NY		Aggregate								3282	2646	384							115	52	56
4740	4740	20200604	NY		Aggregate								3350	2718	388							117	52	58
4796	4796	20200611	NY		Aggregate								3436	2718	392							118	52	58
4852	4852	20200618	NY		Aggregate								3506	2718	392							121	52	58
4908	4908	20200625	NY		Aggregate								3541	2718	395							121	52	58
4964	4964	20200702	NY		Aggregate								3563	2718	394							122	52	58
5020	5020	20200709	NY		Aggregate								3590	2718	394							123	52	59
5076	5076	20200716	NY		Aggregate								3599	2718	394							123	52	58
5132	5132	20200723	NY		Aggregate								3613	2783	395							123	52	59
5188	5188	20200730	NY		Aggregate								3620	2783	395							123	52	59
5244	5244	20200806	NY		Aggregate								3643	2783	397							124	52	60
5300	5300	20200813	NY		Aggregate								3653	2783	398							124	52	60
5356	5356	20200820	NY		Aggregate								3665	2783	399							124	52	60
5412	5412	20200827	NY		Aggregate								3676	2783	400							124	52	60
5468	5468	20200903	NY		Aggregate								3680	2783	400							125	52	60
5524	5524	20200910	NY		Aggregate								3689	2783	402							125	52	60
5580	5580	20200917	NY		Aggregate								3692	2783	403							125	52	60
5636	5636	20200924	NY		Aggregate								3696	2783	403							125	52	60
5692	5692	20201001	NY		Aggregate								3701	2783	404							126	52	61
5748	5748	20201008	NY		Aggregate								3718	2783	406							126	52	61
5804	5804	20201015	NY		Aggregate								3736	2783	407							126	52	61
5860	5860	20201022	NY		Aggregate								3747	2783	407							126	52	61
5916	5916	20201029	NY		Aggregate								3767	2783	412							127	52	61
5972	5972	20201105	NY		Aggregate								3775	2783	414							127	52	61
6028	6028	20201112	NY		Aggregate								3825	2783	415							127	52	61
6084	6084	20201119	NY		Aggregate								3879	2783	421							127	52	61
6140	6140	20201126	NY		Aggregate								3983	2783	436							127	52	61
6196	6196	20201203	NY		Aggregate								4089	2783	446							128	52	62
6252	6252	20201210	NY		Aggregate								4251	2783	456							129	52	63
6308	6308	20201217	NY		Aggregate								4462	2783	469							133	52	65
6364	6364	20201224	NY		Aggregate								4685	2783	477							134	52	65
6420	6420	20201231	NY		Aggregate								4926	2783	493							138	52	67
6476	6476	20210107	NY		Aggregate								5197	2783	503							144	52	73
6532	6532	20210114	NY		Aggregate								5497	2783	518							148	52	76
6588	6588	20210121	NY		Aggregate								5758	2783	527							151	52	77
4329	4329	20210211	NY	20210210	Cumulative								10395	2957	556							779	24	141
4441	4441	20210218	NY	20210217	Cumulative								10516	2957	556							791	24	142
4553	4553	20210225	NY	20210223	Cumulative								10608	2957	556							798	24	143
6756	6756	20210211	NY		Aggregate								10395	2957	556							779	24	141
6812	6812	20210218	NY		Aggregate								10516	2957	556							791	24	142
6868	6868	20210225	NY		Aggregate								10608	2957	556							798	24	143
1	1	20200521	AK		Cumulative
2	2	20200521	AK		Outbreak
3	3	20200521	AL		Cumulative																				1,285		828
4	4	20200521	AL		Outbreak
5	5	20200521	AR		Cumulative																				330	45	197	57
6	6	20200521	AR		Outbreak
7	7	20200521	AS		Cumulative
8	8	20200521	AS		Outbreak
9	9	20200521	AZ		Cumulative																			105				61
10	10	20200521	AZ		Outbreak
11	11	20200521	CA		Cumulative	8400		1497		4824		35																							1997	290
12	12	20200521	CA		Outbreak
13	13	20200521	CO		Cumulative	1205	420	311	102	840	505	1			72	348	68	101	15	188	119			45					381	73	141	15	251	114			29
14	14	20200521	CO		Outbreak	1175	402	303	94	819	490	1			68	277	35	72	8	148	105			31					361	70	130	15	243	111			23
15	15	20200521	CT		Cumulative	6947		1487								871		207
16	16	20200521	CT		Outbreak
17	17	20200521	DC		Cumulative	584		144		172		4			17
18	18	20200521	DC		Outbreak

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