COVIDtracking_data_archive: ltc: 6,886 rows

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

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	DeathResStaff_alf	ProbDeathResStaff_alf	OutbrkFac_alf	PosRes_ltc	DeathRes_ltc	PosStaff_ltc	DeathStaff_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
101	101	20200521	VI	Cumulative
102	102	20200521	VI	Outbreak
103	103	20200521	VT	Cumulative																							27
104	104	20200521	VT	Outbreak
105	105	20200521	WA	Cumulative																										2894		507
106	106	20200521	WA	Outbreak
107	107	20200521	WI	Cumulative											64											825	205							101
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
117	117	20200611	AR	Cumulative																						502	68	283						92
118	118	20200611	AR	Outbreak
119	119	20200528	AS	Cumulative
120	120	20200528	AS	Outbreak
121	121	20200528	AZ	Cumulative																					116									65
122	122	20200528	AZ	Outbreak
123	123	20200528	CA	Cumulative	9183		1725		5437		45																															2143	305
124	124	20200528	CA	Outbreak																																								83
125	125	20200528	CO	Cumulative	1308	422	329	104	891	515	2				75	395	84	110	16	225	125				47										405	73	145	18	256	122				29
126	126	20200528	CO	Outbreak	1252	368	311	90	825	471	2				68	290	45	71	9	173	95				31										385	70	134	18	248	119				24
127	127	20200528	CT	Cumulative	8322		1884									1007		240
128	128	20200528	CT	Outbreak
129	129	20200528	DC	Cumulative	652		152		194		5				17
130	130	20200528	DC	Outbreak
131	131	20200528	DE	Cumulative																						607	208							30
132	132	20200528	DE	Outbreak
133	133	20200528	FL	Cumulative																										8,625		1,163		236
134	134	20200528	FL	Outbreak	3377				1692						319	713				349					231										46				61					14
135	135	20200528	GA	Cumulative	5023		795		2027						243																				650		164		355					146
136	136	20200528	GA	Outbreak
137	137	20200528	GU	Cumulative
138	138	20200528	GU	Outbreak
139	139	20200528	HI	Cumulative
140	140	20200528	HI	Outbreak
141	141	20200528	IA	Cumulative									227
142	142	20200528	IA	Outbreak								1477			37
143	143	20200528	ID	Cumulative	183		150				32				29
144	144	20200528	ID	Outbreak
145	145	20200528	IL	Cumulative																										14,882		2,402		503
146	146	20200528	IL	Outbreak
147	147	20200528	IN	Cumulative																						4,086	876							224
148	148	20200528	IN	Outbreak
149	149	20200528	KS	Cumulative																										685		107		30
150	150	20200528	KS	Outbreak																														16
151	151	20200528	KY	Cumulative																						1185	239	563	2					120
152	152	20200528	KY	Outbreak
153	153	20200528	LA	Cumulative	4381		1075		1859						277																				607		91							108
154	154	20200528	LA	Outbreak
155	155	20200528	MA	Cumulative																											20607		4123	349
156	156	20200528	MA	Outbreak
157	157	20200528	MD	Cumulative
158	158	20200528	MD	Outbreak																															6402		1276		2921		14			220
159	159	20200528	ME	Cumulative
160	160	20200528	ME	Outbreak
161	161	20200528	MI	Cumulative	2826										169
162	162	20200528	MI	Outbreak
163	163	20200528	MN	Cumulative																						2771	787							238
164	164	20200528	MN	Outbreak
165	165	20200528	MO	Cumulative																						840	148							177
166	166	20200528	MO	Outbreak
167	167	20200528	MP	Cumulative
168	168	20200528	MP	Outbreak
169	169	20200528	MS	Cumulative																						1795	352
170	170	20200528	MS	Outbreak																														127
171	171	20200528	MT	Cumulative
172	172	20200528	MT	Outbreak
173	173	20200618	AR	Cumulative																						543	79	368						110
174	174	20200618	AR	Outbreak
175	175	20200528	ND	Cumulative
176	176	20200528	ND	Outbreak
177	177	20200528	NE	Cumulative																						478	87	356						107
178	178	20200528	NE	Outbreak
179	179	20200528	NH	Cumulative																										2,011		214
180	180	20200528	NH	Outbreak
181	181	20200528	NJ	Cumulative																						21058	5751	10254	104					537
182	182	20200528	NJ	Outbreak
183	183	20200528	NM	Cumulative																						453	129	316	3
184	184	20200528	NM	Outbreak
185	185	20200528	NV	Cumulative	531		79		368		1				38	131		17		42		1			27
186	186	20200528	NV	Outbreak
187	187	20200528	NY	Cumulative									3282	2646	384								115	52	56
188	188	20200528	NY	Outbreak
189	189	20200528	OH	Cumulative	4753				2079						346	470				247					78		1073								100				113					30
190	190	20200528	OH	Outbreak	1318				493						201	131				59					32										38				22					13
191	191	20200528	OK	Cumulative																						779	151	466	2
192	192	20200528	OK	Outbreak
193	193	20200528	OR	Cumulative
194	194	20200528	OR	Outbreak																																						356	56	19
195	195	20200528	PA	Cumulative																						15158		2563				3501		600
196	196	20200528	PA	Outbreak
197	197	20200528	PR	Cumulative																							6
198	198	20200528	PR	Outbreak
199	199	20200528	RI	Cumulative												150		30							9	2455	520							50
200	200	20200528	RI	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
);