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

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 Data_Type

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	OutbrkFac_nh	PosRes_alf	ProbPosRes_alf	DeathRes_alf	ProbDeathRes_alf	PosStaff_alf	ProbPosStaff_alf	OutbrkFac_alf	PosRes_ltc	DeathRes_ltc	PosStaff_ltc	DeathStaff_ltc	PosResStaff_ltc	DeathResStaff_ltc	OutbrkFac_ltc	PosRes_other	ProbPosRes_other	DeathRes_other	ProbDeathRes_other	PosStaff_other	ProbPosStaff_other	DeathStaff_other	PosResStaff_other	DeathResStaff_other	OutbrkFac_other
1549	1549	20200521	AR	Aggregate																		330	45	197				57
1550	1550	20200528	AR	Aggregate																		372	50	230				68
1571	1571	20200604	AR	Aggregate																		424	64	287				77
1572	1572	20200611	AR	Aggregate																		502	68	283				92
1627	1627	20200618	AR	Aggregate																		543	79	368				110
1628	1628	20200625	AR	Aggregate																		638	91	430	1			124
1661	1661	20200702	AR	Aggregate																		751	107	490	1			146
1662	1662	20200709	AR	Aggregate																		879	120	564	1			166
1683	1683	20200716	AR	Aggregate																		923	132	658	1			171
1684	1684	20200723	AR	Aggregate																		1076	147	742	1			177
1739	1739	20200730	AR	Aggregate																		1266	159	902	1			195
1740	1740	20200806	AR	Aggregate																		1425	182	961	2			195
1773	1773	20200813	AR	Aggregate																		1627	182	1109	2			167
1774	1774	20200820	AR	Aggregate																		1794	182	1227	2			156
1795	1795	20200827	AR	Aggregate																		2051	226	1340				224
1796	1796	20200903	AR	Aggregate																		2199	226	1475	1			233
1851	1851	20200910	AR	Aggregate																		2226	300	1487	2			233
1852	1852	20200917	AR	Aggregate																		2342	320	1563	2			244
1885	1885	20200924	AR	Aggregate																		2562	371	1724	2			224
1886	1886	20201001	AR	Aggregate																		2735	415	1878	2			258
1907	1907	20201008	AR	Aggregate																		3133	502	2180	2			261
1908	1908	20201015	AR	Aggregate																		3396	562	2347	2			263
1963	1963	20201022	AR	Aggregate																		3956	630	2838	2			270
1964	1964	20201029	AR	Aggregate																		4547	674	3230	2			276
1997	1997	20201105	AR	Aggregate																		5001	815	3593	3			280
1998	1998	20201112	AR	Aggregate																		5588	890	3983	3			280
2019	2019	20201119	AR	Aggregate																		6327	961	4506	3			283
2020	2020	20201126	AR	Aggregate																		6961	1078	5033	4			285
2075	2075	20201203	AR	Aggregate																		6961	1078	5033	4			285
2076	2076	20201210	AR	Aggregate																		8179	1235	6029	6			292
2109	2109	20201217	AR	Aggregate																		8579	1285	6279	6			292
2110	2110	20201224	AR	Aggregate																		9332	1392	6911	9			294
2131	2131	20201231	AR	Aggregate																		9744	1501	7408	11			298
2132	2132	20210107	AR	Aggregate																		10318	1603	7977	11			300
2187	2187	20210114	AR	Aggregate																		10777	1651	8422	11			301
2188	2188	20210121	AR	Aggregate																		11210	1735	8887	11			305
2221	2221	20210128	AR	Aggregate																		11440	1768	9092	11			306
2222	2222	20210204	AR	Aggregate																		11883	1901	9606	11			308
2243	2243	20210211	AR	Aggregate																		12081	1953	9836	11			310
2244	2244	20210218	AR	Aggregate																		12332	2027	9998	13			311
2299	2299	20210225	AR	Aggregate																		12329	1970	10059	13			310
3812	3812	20200521	NC	Aggregate	1946		378		805		2			83															308		46		97		0			25
3867	3867	20200528	NC	Aggregate	2171		427		918		3			92															348		49		129		0			30
3868	3868	20200604	NC	Aggregate	2347		490		1018		3			90															493		57		193		0			35
3901	3901	20200611	NC	Aggregate	2536		535		1141		3			99															493		57		193		0			32
3902	3902	20200618	NC	Aggregate	2677		582		1231		3			105															493		57		215		1			38
3923	3923	20200625	NC	Aggregate								4294	646	107																						1191	108	40
3924	3924	20200702	NC	Aggregate								4385	654	124																						1220	113	44
3979	3979	20200709	NC	Aggregate								4700	688	132																						1426	120	51
3980	3980	20200716	NC	Aggregate								5144	721	136																						1649	130	61
4013	4013	20200723	NC	Aggregate								5571	744	147																						1899	148	72
4014	4014	20200730	NC	Aggregate								6112	797	162																						2168	162	72
4035	4035	20200806	NC	Aggregate								6667	870	167																						2311	177	72
4036	4036	20200813	NC	Aggregate								7389	938	174																						2,520	197	106
4091	4091	20200820	NC	Aggregate								8111	997	188																						2738	219	106
4092	4092	20200827	NC	Aggregate								8649	1043	198																						2952	241	110
4125	4125	20200903	NC	Aggregate								9252	1113	200																						3185	258	110
4126	4126	20200910	NC	Aggregate								10000	1214	200																						3405	282	110
4147	4147	20200917	NC	Aggregate								10696	1304	201																						3592	302	110
4148	4148	20200924	NC	Aggregate								11256	1388	216																						3808	321	110
4203	4203	20201001	NC	Aggregate								12050	1460	235																						4129	356	110
4204	4204	20201008	NC	Aggregate								12674	1520	235																						4514	377	110
4237	4237	20201015	NC	Aggregate								13225	1571	235																						4831	393	110
4238	4238	20201022	NC	Aggregate								13966	1644	235																						5119	420	110
4259	4259	20201029	NC	Aggregate								14617	1709	235																						5510	444	110
4260	4260	20201105	NC	Aggregate								15198	1785	235																						5823	478	119
4315	4315	20201112	NC	Aggregate								15839	1843	235																						6059	490	119
4316	4316	20201119	NC	Aggregate								16624	1915	235																						6354	511	124
4349	4349	20201126	NC	Aggregate								17369	1980	235																						6687	542	130
4350	4350	20201203	NC	Aggregate								18130	2069	250																						7048	576	141
4371	4371	20201210	NC	Aggregate								19627	2168	272																						7681	612	165
4372	4372	20201217	NC	Aggregate								20978	2280	303																						8386	641	190
4427	4427	20201224	NC	Aggregate								22279	2356	314																						9109	669	219
4428	4428	20201231	NC	Aggregate								23254	2453	319																						9629	698	230
4461	4461	20210107	NC	Aggregate								25122	2602	337																						10493	743	273
4462	4462	20210114	NC	Aggregate								26921	2795	351																						11506	788	321
4483	4483	20210121	NC	Aggregate								28165	2924	356																						12477	833	334
4484	4484	20210128	NC	Aggregate								29894	3115	363																						13446	917	340
4539	4539	20210204	NC	Aggregate								31105	3308	364																						14286	998	346
4540	4540	20210211	NC	Aggregate								32189	3469	364																						14949	1083	346
4573	4573	20210218	NC	Aggregate								32957	3622	364																						15,504	1129	346
4574	4574	20210225	NC	Aggregate								33532	3748	364																						15942	1167	346
4591	4591	20200521	AK	Aggregate
4592	4592	20200521	AL	Aggregate																		1285		828
4594	4594	20200521	AS	Aggregate
4595	4595	20200521	AZ	Aggregate																	105							61
4596	4596	20200521	CA	Aggregate	8400		1497		4824		35																									1997	290
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
4598	4598	20200521	CT	Aggregate	6947		1487								871		207
4599	4599	20200521	DC	Aggregate	584		144		172		4			17
4600	4600	20200521	DE	Aggregate																		542	177					27
4601	4601	20200521	FL	Aggregate																							1,001	211
4602	4602	20200521	GA	Aggregate	4701		709		1882					239															639		159		344					142
4603	4603	20200521	GU	Aggregate
4604	4604	20200521	HI	Aggregate
4605	4605	20200521	IA	Aggregate								1543	227	37
4606	4606	20200521	ID	Aggregate	183		150				32			29
4607	4607	20200521	IL	Aggregate																						13216	1959	383
4608	4608	20200521	IN	Aggregate																		3625	732					212
4609	4609	20200521	KS	Aggregate																						611	102	25

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