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	PosResStaff_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
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
19	19	20200521	DE	Cumulative																							542	177							27
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
35	35	20200521	IN	Cumulative																							3,625	732							212
36	36	20200521	IN	Outbreak
37	37	20200521	KS	Cumulative																											611		102		25
38	38	20200521	KS	Outbreak																															13
39	39	20200521	KY	Cumulative																							1,061	211	488	2					103
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
51	51	20200521	MN	Cumulative																							2308	663							211
52	52	20200521	MN	Outbreak
53	53	20200521	MO	Cumulative																							840	148							82
54	54	20200521	MO	Outbreak
55	55	20200521	MP	Cumulative
56	56	20200521	MP	Outbreak
57	57	20200521	MS	Cumulative																							1590	289
58	58	20200521	MS	Outbreak																															98
59	59	20200521	MT	Cumulative
60	60	20200521	MT	Outbreak
61	61	20200528	AR	Cumulative																							372	50	230						68
62	62	20200528	AR	Outbreak
63	63	20200521	ND	Cumulative
64	64	20200521	ND	Outbreak
65	65	20200521	NE	Cumulative																							292	73	223						55
66	66	20200521	NE	Outbreak
67	67	20200521	NH	Cumulative																											1769		186
68	68	20200521	NH	Outbreak
69	69	20200521	NJ	Cumulative																							19,847	5456	9029	98					530
70	70	20200521	NJ	Outbreak
71	71	20200521	NM	Cumulative																							453	129	316	3
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
77	77	20200521	OH	Cumulative	4161				1840						316	421				212						73		878								93				86					20
78	78	20200521	OH	Outbreak	1206				530						199	169				90						46										39				28					11
79	79	20200521	OK	Cumulative																							708	135	424	2
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
85	85	20200521	PR	Cumulative																								5
86	86	20200521	PR	Outbreak
87	87	20200521	RI	Cumulative												130		20								6	2105	345							47
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
95	95	20200604	AR	Cumulative																							424	64	287						77
96	96	20200604	AR	Outbreak
97	97	20200521	UT	Cumulative																							216	40	196
98	98	20200521	UT	Outbreak
99	99	20200521	VA	Cumulative																											4304		654		186
100	100	20200521	VA	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
);