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

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 DeathRes_ltc

descending

This data as json, copyable, CSV (advanced)

Link	rowid	Date	State_Abbr	Data_Type	PosRes_nh	ProbPosRes_nh	DeathRes_nh	ProbDeathRes_nh	PosStaff_nh	ProbPosStaff_nh	DeathStaff_nh	PosResStaff_nh	DeathResStaff_nh	ProbDeathResStaff_nh	OutbrkFac_nh	PosRes_alf	ProbPosRes_alf	DeathRes_alf	ProbDeathRes_alf	PosStaff_alf	ProbPosStaff_alf	DeathStaff_alf	PosResStaff_alf	DeathResStaff_alf	ProbDeathResStaff_alf	OutbrkFac_alf	PosRes_ltc	PosStaff_ltc	PosResStaff_ltc	ProbPosResStaff_ltc	DeathResStaff_ltc	ProbDeathResStaff_ltc	OutbrkFac_ltc	PosRes_other	ProbPosRes_other	DeathRes_other	ProbDeathRes_other	PosStaff_other	ProbPosStaff_other	DeathStaff_other	PosResStaff_other	DeathResStaff_other	OutbrkFac_other
1	1	20200521	AK	Cumulative
2	2	20200521	AK	Outbreak
3	3	20200521	AL	Cumulative																							1,285	828
4	4	20200521	AL	Outbreak
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
20	20	20200521	DE	Outbreak
21	21	20200521	FL	Cumulative																											1001		211
22	22	20200521	FL	Outbreak	3540				1616						305	690				269						220								57				86					12
23	23	20200521	GA	Cumulative	4701		709		1882						239																			639		159		344					142
24	24	20200521	GA	Outbreak
25	25	20200521	GU	Cumulative
26	26	20200521	GU	Outbreak
27	27	20200521	HI	Cumulative
28	28	20200521	HI	Outbreak
29	29	20200521	IA	Cumulative									227
30	30	20200521	IA	Outbreak								1543			37
31	31	20200521	ID	Cumulative	183		150				32				29
32	32	20200521	ID	Outbreak
33	33	20200521	IL	Cumulative																									13,216		1,959		383
34	34	20200521	IL	Outbreak
36	36	20200521	IN	Outbreak
37	37	20200521	KS	Cumulative																									611		102		25
38	38	20200521	KS	Outbreak																													13
40	40	20200521	KY	Outbreak
41	41	20200521	LA	Cumulative	4,084		987		1737						278																			526		65							86
42	42	20200521	LA	Outbreak
43	43	20200521	MA	Cumulative																										19106		3755	344
44	44	20200521	MA	Outbreak
45	45	20200521	MD	Cumulative
46	46	20200521	MD	Outbreak																														5939		1131		2519		12			222
47	47	20200521	ME	Cumulative
48	48	20200521	ME	Outbreak
49	49	20200521	MI	Cumulative	2826										169
50	50	20200521	MI	Outbreak
52	52	20200521	MN	Outbreak
54	54	20200521	MO	Outbreak
55	55	20200521	MP	Cumulative
56	56	20200521	MP	Outbreak
58	58	20200521	MS	Outbreak																													98
59	59	20200521	MT	Cumulative
60	60	20200521	MT	Outbreak
62	62	20200528	AR	Outbreak
63	63	20200521	ND	Cumulative
64	64	20200521	ND	Outbreak
66	66	20200521	NE	Outbreak
67	67	20200521	NH	Cumulative																									1769		186
68	68	20200521	NH	Outbreak
70	70	20200521	NJ	Outbreak
72	72	20200521	NM	Outbreak
73	73	20200521	NV	Cumulative	457		75		316		1					80		12		41		1				26
74	74	20200521	NV	Outbreak
75	75	20200521	NY	Cumulative									3118	2646										115	52
76	76	20200521	NY	Outbreak
78	78	20200521	OH	Outbreak	1206				530						199	169				90						46								39				28					11
80	80	20200521	OK	Outbreak
81	81	20200521	OR	Cumulative
82	82	20200521	OR	Outbreak																																					356	56	19
83	83	20200521	PA	Cumulative																							14113	2306			3234		570
84	84	20200521	PA	Outbreak
86	86	20200521	PR	Outbreak
88	88	20200521	RI	Outbreak
89	89	20200521	SC	Cumulative	975		141		398		2				74	79		11		41						28
90	90	20200521	SC	Outbreak	690		80		289		2				58	53		9		31						17
91	91	20200521	SD	Cumulative
92	92	20200521	SD	Outbreak
93	93	20200521	TN	Cumulative
94	94	20200521	TN	Outbreak			81					810			33			27					174			17															2		1
96	96	20200604	AR	Outbreak
98	98	20200521	UT	Outbreak
99	99	20200521	VA	Cumulative																									4304		654		186
100	100	20200521	VA	Outbreak
101	101	20200521	VI	Cumulative
102	102	20200521	VI	Outbreak
104	104	20200521	VT	Outbreak
105	105	20200521	WA	Cumulative																									2894		507
106	106	20200521	WA	Outbreak
108	108	20200521	WI	Outbreak											53
109	109	20200521	WV	Cumulative																							183	153					10
110	110	20200521	WV	Outbreak
111	111	20200521	WY	Cumulative	6		1		5
112	112	20200521	WY	Outbreak
113	113	20200528	AK	Cumulative
114	114	20200528	AK	Outbreak
115	115	20200528	AL	Cumulative																							1614	949
116	116	20200528	AL	Outbreak
118	118	20200611	AR	Outbreak
119	119	20200528	AS	Cumulative
120	120	20200528	AS	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
);