COVID_COVID19Tracker

Data source: Big Local News · About: big-local-datasette

Custom SQL query returning 101 rows (hide)

select rowid, date, state, positive, negative, pending, totalTestResults, hospitalizedCurrently, hospitalizedCumulative, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, recovered, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, death, hospitalized, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, fips, positiveIncrease, negativeIncrease, total, totalTestResultsSource, totalTestResultsIncrease, posNeg, deathIncrease, hospitalizedIncrease, hash, commercialScore, negativeRegularScore, negativeScore, positiveScore, score, grade from states_daily_4pm_et where (posNeg > :p1 or (posNeg = :p1 and rowid > :p0)) order by posNeg, rowid limit 101

Query parameters

This data as json, copyable, CSV

rowid	date	state	positive	negative	pending	totalTestResults	lastUpdateEt	dateModified	checkTimeEt	death	dateChecked	totalTestsViral	positiveTestsViral	negativeTestsViral	positiveCasesViral	deathProbable	totalTestEncountersViral	totalTestsPeopleViral	fips	positiveIncrease	total	totalTestResultsSource	totalTestResultsIncrease	posNeg	hash
11513	20200219	WA	0	0		0									0		0		53	0	0	posNeg	0	0	4de13ed97776e91b872ccd196ca963ea838e63f0
11514	20200218	MA				13						13	3						25	0	0	totalTestsViral	0	0	52129661709702a457b71ba8cfa402275bccdcd6
11515	20200218	NJ				0				0						0			34	0	0	posNeg	0	0	063370b2a9dc6f1f24be77c828c62aef51112228
11516	20200218	WA	0	0		0									0		0		53	0	0	posNeg	0	0	b9f2477edf96e4bf6695b83dc203a2e01c283bbd
11517	20200217	MA				13						13	3						25	0	0	totalTestsViral	0	0	5cebd2e6e229d1b72f113c84fcd8d5f7bb663df6
11518	20200217	NJ				0				0						0			34	0	0	posNeg	0	0	a0be14cc41cd70138c5d922fb381da668d56f394
11519	20200217	WA	0	0		0									0		0		53	0	0	posNeg	0	0	6c29293358450c27b194e2234ad0eba6b212ba3b
11520	20200216	MA				13						13	3						25	0	0	totalTestsViral	0	0	c04bd0b85b03544eb760f53f649fdacf4271437d
11521	20200216	NJ				0				0						0			34	0	0	posNeg	0	0	7b2be10826f4c2dad5d856e2df50be6a2888c309
11522	20200216	WA	0	0		0									0		0		53	0	0	posNeg	0	0	3426c1cf143d5b80508c615b5c54556d4db74be3
11523	20200215	MA				13						13	3						25	0	0	totalTestsViral	0	0	ad4e60da5a3b8d9b2467c244a253b644ede4bec5
11524	20200215	NJ				0				0						0			34	0	0	posNeg	0	0	51dbdb4b4be7ba7edb5fb28295df787ea18dbb75
11525	20200215	WA	0	0		0									0		0		53	0	0	posNeg	0	0	7983deb48e8cfa38ce6ad2ccd8ce829b4c00e386
11526	20200214	MA				13						13	3						25	0	0	totalTestsViral	0	0	9380a7951898b89449efb4998f810b1278c1e384
11527	20200214	NJ				0				0						0			34	0	0	posNeg	0	0	5b891ca9720d66e02aaee57078397d55730d6517
11528	20200214	WA	0	0		0									0		0		53	0	0	posNeg	0	0	591f5dc76d194660b201697ba8687c16e478c5e9
11529	20200213	MA				13						13	3						25	0	0	totalTestsViral	0	0	6cc2928cc2d5ff21a16e3ed6500cf87e7f538e97
11530	20200213	NJ				0				0						0			34	0	0	posNeg	0	0	6458612ad578b310c7fcdd7d736abef616f7ca46
11531	20200213	WA	0	0		0									0		0		53	0	0	posNeg	0	0	e92d97f8ce05a6a9f8becc5b10a34f8ec61b27f1
11532	20200212	MA				13						13	3						25	0	0	totalTestsViral	1	0	0ad7d892894ff707d32fb6dbc5508fca48997c0b
11533	20200212	NJ				0				0						0			34	0	0	posNeg	0	0	b8bc1fc897f2102c74525c381335a6ea65e3fa79
11534	20200212	WA	0	0		0									0		0		53	0	0	posNeg	0	0	a0c60ef498021c84c70868dc8f5bf4348d231183
11535	20200211	MA				12						12	3						25	0	0	totalTestsViral	0	0	abc48e6a80ce71e0028c50b24bbe257d51d27736
11536	20200211	NJ				0				0						0			34	0	0	posNeg	0	0	64663da144753078ae652920a63807a894a418bd
11537	20200211	WA	0	0		0									0		0		53	0	0	posNeg	0	0	ff0cb7c50f42126410e0e2a3959a1415c450d6ce
11538	20200210	MA				12						12	3						25	0	0	totalTestsViral	1	0	edb72dcc2c025fee6f5fda2077146b515106419c
11539	20200210	NJ				0				0						0			34	0	0	posNeg	0	0	5f39d85d1822bc611fb1b9606671951c4104fb2e
11540	20200210	WA	0	0		0									0		0		53	0	0	posNeg	0	0	c90f9558f2984b8565c534ec076d5cf757407af3
11541	20200209	MA				11						11	2						25	0	0	totalTestsViral	0	0	788dc34009b70da245a65558dfee001f5f02adae
11542	20200209	WA	0	0		0									0		0		53	0	0	posNeg	0	0	428c54e0a7392260add9160a215ef1eaa3abbc8c
11543	20200208	MA				11						11	2						25	0	0	totalTestsViral	1	0	6e82c90de703416c99e25c91d0129be6ddafa4a4
11544	20200208	WA	0	0		0									0		0		53	0	0	posNeg	0	0	69f6c69ce71c22a9afe35a3b885b951b07dc9ac2
11545	20200207	MA				10						10	2						25	0	0	totalTestsViral	0	0	47fb70739742538fcd9996ae1ba493d2966964ab
11546	20200207	WA	0	0		0									0		0		53	0	0	posNeg	0	0	2b9f17998378d4c584a95afd798c91ca8d7d3f1b
11547	20200206	MA				10						10	2						25	0	0	totalTestsViral	1	0	56c88c2a221fa7e33a8c6dd74418e15ef1ae90e4
11548	20200206	WA	0	0		0									0		0		53	0	0	posNeg	0	0	776627308e5120419ceb0439a2f2e33e2123bf8d
11549	20200205	MA				9						9	1						25	0	0	totalTestsViral	0	0	7857039c39fbde1edf690d7d40ef4f6a6dcf5c1f
11550	20200205	WA	0	0		0									0		0		53	0	0	posNeg	0	0	c046f5f2d01538c648a4143cc2483c46733afcec
11551	20200204	MA				9						9	1						25	0	0	totalTestsViral	2	0	6ba896859e82f8493b6c3c8926068a6401f3aae8
11552	20200204	WA	0	0		0									0		0		53	0	0	posNeg	0	0	d5a76e6a18fa1b96755146417ac948a9171616a0
11553	20200203	MA				7						7	1						25	0	0	totalTestsViral	3	0	ceb40934b5ab974376d53e94813829d5219a4d11
11554	20200203	WA	0	0		0									0		0		53	0	0	posNeg	0	0	d526468a75e5d8d6398391f7374827c75da63c76
11555	20200202	MA				4						4	1						25	0	0	totalTestsViral	0	0	5c6bcd72027a52a11d22637ec3817c983152278e
11556	20200202	WA	0	0		0									0		0		53	0	0	posNeg	0	0	f689cc8700bdd9301157ac42fa9c55eb3150262d
11557	20200201	MA				4						4	1						25	0	0	totalTestsViral	0	0	c5d588edf0b213f848e833169f09557c02c85cca
11558	20200201	WA	0	0		0									0		0		53	0	0	posNeg	0	0	826ada8fe828c859bd601b3219737b8310342f1b
11559	20200131	MA				4						4	1						25	0	0	totalTestsViral	0	0	5c5c4f56046f0b63b235c7b7669e60a069d49233
11560	20200131	WA	0	0		0									0		0		53	0	0	posNeg	0	0	fba5d5a98fb5fd10b50f860b8df2177f618a8b0a
11561	20200130	MA				4						4	1						25	0	0	totalTestsViral	0	0	70ad04426637815a0bdae40c568aa8c4480b8003
11562	20200130	WA	0	0		0									0		0		53	0	0	posNeg	0	0	54780ea7215216a912a9def2e2781a3e0b441b1b
11563	20200129	MA				4						4	1						25	0	0	totalTestsViral	1	0	3e0347e93bc42378a2626ae60228d200d442647a
11564	20200129	WA	0	0		0									0		0		53	0	0	posNeg	0	0	6f0046d8d9448fad739742129ffe61dffd546658
11565	20200128	MA				3						3	0						25	0	0	totalTestsViral	0	0	1e8908f7c85e2427efc01aead597fd395a684db6
11566	20200128	WA	0	0		0									0		0		53	0	0	posNeg	0	0	7b90966b6545d98ee954eb8af98720dbdd3e72e1
11567	20200127	MA				3						3	0						25	0	0	totalTestsViral	1	0	2969c99b5818b3f1fcf1ff7c718eaa610a3be740
11568	20200127	WA	0	0		0									0		0		53	0	0	posNeg	0	0	97c4e999c9d9a053210188434ae2c1d5a6e84395
11569	20200126	MA				2						2	0						25	0	0	totalTestsViral	0	0	564fae1c160074f0d252f9cf03b31e9bd259f162
11570	20200126	WA	0	0		0									0		0		53	0	0	posNeg	0	0	d071f52c7b741eb47e42b29ec43d1fd5e5669698
11571	20200125	MA				2						2	0						25	0	0	totalTestsViral	0	0	664363707eec6db537d3ef5b0a6a948e94a6a10b
11572	20200125	WA	0	0		0									0		0		53	0	0	posNeg	0	0	626988ec4dfe62f38d72dc25126a264411769056
11573	20200124	MA				2						2	0						25	0	0	totalTestsViral	0	0	6fb5cd338a16b013604fd09024f0d09006bd6d89
11574	20200124	WA	0	0		0									0		0		53	0	0	posNeg	0	0	6f40087f42d06db4121e09b184785b4110cd4df8
11575	20200123	MA				2						2	0						25	0	0	totalTestsViral	1	0	885628de5b5c6da109b79adb7faad55e4815624a
11576	20200123	WA	0	0		0									0		0		53	0	0	posNeg	0	0	978c05d8a7a9d46e9fa826d83215f5b9732f2c6d
11577	20200122	MA				1						1	0						25	0	0	totalTestsViral	0	0	0f3eebd5c4a00d0aaa235b0534bd4243794652b6
11578	20200122	WA	0	0		0									0		0		53	0	0	posNeg	0	0	06e7ce37c84a602f9b8704eb4a4e8d3bb9726026
10915	20200316	VI	1			1	3/16/2020 15:58	2020-03-16T15:58:00Z	03/16 11:58		2020-03-16T15:58:00Z								78	0	1	posNeg	0	1	ea65da585cbe38537348a3d600a66ab931af6e8f
11073	20200313	WY	1			1	3/12/2020 00:00	2020-03-12T00:00:00Z	03/11 20:00		2020-03-12T00:00:00Z				1				56	0	1	posNeg	0	1	6e7d1185225390d1726c126c8bb1869b8f72fb0b
11124	20200312	WY	1			1	3/11/2020 00:00	2020-03-11T00:00:00Z	03/10 20:00		2020-03-11T00:00:00Z								56	1	1	posNeg	1	1	060fd182cd332032dff4ea72cecabdff543e2191
11149	20200311	MO	1			1						54	8	46	1				29	0	1	posNeg	0	1	64e2151d9578ec0cd38a504e1f8e6b0ec98f40c2
11200	20200310	MO	1			1						42	8	34	1				29	0	1	posNeg	0	1	e8ce6bdb81792852d024e4e7423ff5867e872524
11248	20200309	ME	0	1		1									0				23	0	1	posNeg	0	1	151049d836a370c678897ad29c326c5c564a2748
11251	20200309	MO	1			1						36	7	29	1				29	0	1	posNeg	0	1	1a079fbedfc8d7a374c7de179459b5f80f1430f4
11271	20200309	UT	1			1									1				49	0	1	posNeg	0	1	fd93e289f042fae8dbafd8e636e48969b3516227
11289	20200308	HI	1			1													15	0	1	posNeg	0	1	fce32ebadc808697f80252996d531a82e417dc07
11299	20200308	ME	0	1		1									0				23	0	1	posNeg	0	1	cb22017cc43ff01b5997c50e8f5be05c5d342bd2
11302	20200308	MO	1			1						31	7	24	1				29	1	1	posNeg	1	1	a9675ed0fffa1d3032f7ec9be2fcbdc716b9522e
11322	20200308	UT	1			1									1				49	0	1	posNeg	0	1	df00cbca051e0e1dc323cc91af54c88361a9c4ad
11340	20200307	HI	1			1													15	0	1	posNeg	0	1	ff4edd0e286c634864c3eaab6d4b695fa101bb9b
11344	20200307	IN	1			1													18	0	1	posNeg	0	1	e1af49982396e125f2dcb4b363a37403c91cf63d
11350	20200307	ME	0	1		1									0				23	0	1	posNeg	0	1	b84d745a34253a870502ef71a4109b8027b35459
11365	20200307	OK	1			1													40	0	1	posNeg	0	1	e315b089218101b4843627f834a260bd57cf1d91
11371	20200307	TN	1			1													47	0	1	posNeg	0	1	94e1a0026eb007f88d231f68e297fa084f14cc55
11373	20200307	UT	1			1									1				49	0	1	posNeg	0	1	d9688c4b336cdf2d620852cadf1e462417d2a030
11391	20200306	IN	1			1													18	0	1	posNeg	0	1	48879bb87fc6d7f888ad73cf855f11578aa51ad0
11401	20200306	NJ	1			1				0					4	0		1	34	0	1	posNeg	0	1	d102d32355139886ec0279ef7e8f8c2edfda0aa6
11410	20200306	TN	1			1													47	0	1	posNeg	0	1	7a49afb734c07d6d2218079f31202689c4f5cb75
11416	20200306	WV	0	1	4	1									0				54	0	5	posNeg	0	1	72a7abd8de92bd9baf3046acd3ea566699d21e31
11427	20200305	NC	1			1													37	0	1	posNeg	0	1	473807abe52be5725eaf2be038a408c589d97a1c
11430	20200305	NJ	1			1				0					2	0		1	34	1	1	posNeg	1	1	684c48748966f7f3221e7a5150a1fda9fc49b037
11437	20200305	TN	1			1													47	0	1	posNeg	0	1	e0c627b4f17cfed2252487b1cea86a069800fcbd
11438	20200305	TX	1			1									1				48	0	1	posNeg	0	1	b6c2d2da54bf32da455dc064c25b46362e2c5249
11449	20200304	NC	1			1													37	0	1	posNeg	0	1	4d1b2fa487067a2fcbf1f564cbb7aee6d90f48e3
11456	20200304	TX	1			1									1				48	0	1	posNeg	0	1	ac3e4cd42d64afbbf5c925dc09ff26549fc509bc
10052	20200331	MP	2			2	3/30/2020 18:30	2020-03-30T18:30:00Z	03/30 14:30		2020-03-30T18:30:00Z								69	0	2	posNeg	0	2	dbbaa90d13abe787feca37e2927d9037e8d75027
10108	20200330	MP	2			2	3/30/2020 01:30	2020-03-30T01:30:00Z	03/29 21:30		2020-03-30T01:30:00Z								69	0	2	posNeg	0	2	6ffdffde1257371ad982b7061de5df8345fc225c
10164	20200329	MP	2			2	3/29/2020 01:30	2020-03-29T01:30:00Z	03/28 21:30		2020-03-29T01:30:00Z								69	0	2	posNeg	0	2	dc2d00e4a18f32239ba79a28efbe39ea80e9b2bc
10220	20200328	MP	2			2	3/28/2020 04:30	2020-03-28T04:30:00Z	03/28 00:30		2020-03-28T04:30:00Z								69	2	2	posNeg	2	2	297e77914ec5de16d3030e074b27c768410edbaf
10803	20200318	VI	2			2	3/18/2020 00:00	2020-03-18T00:00:00Z	03/17 20:00		2020-03-18T00:00:00Z								78	0	2	posNeg	0	2	905df4c8bc271b530ea36adf28c76b7f51183365
10859	20200317	VI	2			2	3/16/2020 00:01	2020-03-16T00:01:00Z	03/15 20:01		2020-03-16T00:01:00Z								78	1	2	posNeg	1	2	760bd14d5188b85c2b0efd761f31c1d1e66c4bd8
10932	20200315	HI	2			2	3/13/2020 00:00	2020-03-13T00:00:00Z	03/12 20:00		2020-03-13T00:00:00Z								15	0	2	posNeg	0	2	09cbd692b373de9e0881bf7960a749433d5a1887