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 order by date limit 101

This data as json, copyable, CSV

rowid	date	state	positive	negative	totalTestResults	lastUpdateEt	dateModified	checkTimeEt	death	dateChecked	totalTestsViral	positiveTestsViral	positiveCasesViral	deathProbable	totalTestEncountersViral	totalTestsPeopleViral	fips	positiveIncrease	negativeIncrease	total	totalTestResultsSource	totalTestResultsIncrease	posNeg	deathIncrease	hash
11577	20200122	MA			1						1	0					25	0	0	0	totalTestsViral	0	0	0	0f3eebd5c4a00d0aaa235b0534bd4243794652b6
11578	20200122	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	06e7ce37c84a602f9b8704eb4a4e8d3bb9726026
11575	20200123	MA			2						2	0					25	0	0	0	totalTestsViral	1	0	0	885628de5b5c6da109b79adb7faad55e4815624a
11576	20200123	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	978c05d8a7a9d46e9fa826d83215f5b9732f2c6d
11573	20200124	MA			2						2	0					25	0	0	0	totalTestsViral	0	0	0	6fb5cd338a16b013604fd09024f0d09006bd6d89
11574	20200124	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	6f40087f42d06db4121e09b184785b4110cd4df8
11571	20200125	MA			2						2	0					25	0	0	0	totalTestsViral	0	0	0	664363707eec6db537d3ef5b0a6a948e94a6a10b
11572	20200125	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	626988ec4dfe62f38d72dc25126a264411769056
11569	20200126	MA			2						2	0					25	0	0	0	totalTestsViral	0	0	0	564fae1c160074f0d252f9cf03b31e9bd259f162
11570	20200126	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	d071f52c7b741eb47e42b29ec43d1fd5e5669698
11567	20200127	MA			3						3	0					25	0	0	0	totalTestsViral	1	0	0	2969c99b5818b3f1fcf1ff7c718eaa610a3be740
11568	20200127	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	97c4e999c9d9a053210188434ae2c1d5a6e84395
11565	20200128	MA			3						3	0					25	0	0	0	totalTestsViral	0	0	0	1e8908f7c85e2427efc01aead597fd395a684db6
11566	20200128	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	7b90966b6545d98ee954eb8af98720dbdd3e72e1
11563	20200129	MA			4						4	1					25	0	0	0	totalTestsViral	1	0	0	3e0347e93bc42378a2626ae60228d200d442647a
11564	20200129	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	6f0046d8d9448fad739742129ffe61dffd546658
11561	20200130	MA			4						4	1					25	0	0	0	totalTestsViral	0	0	0	70ad04426637815a0bdae40c568aa8c4480b8003
11562	20200130	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	54780ea7215216a912a9def2e2781a3e0b441b1b
11559	20200131	MA			4						4	1					25	0	0	0	totalTestsViral	0	0	0	5c5c4f56046f0b63b235c7b7669e60a069d49233
11560	20200131	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	fba5d5a98fb5fd10b50f860b8df2177f618a8b0a
11557	20200201	MA			4						4	1					25	0	0	0	totalTestsViral	0	0	0	c5d588edf0b213f848e833169f09557c02c85cca
11558	20200201	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	826ada8fe828c859bd601b3219737b8310342f1b
11555	20200202	MA			4						4	1					25	0	0	0	totalTestsViral	0	0	0	5c6bcd72027a52a11d22637ec3817c983152278e
11556	20200202	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	f689cc8700bdd9301157ac42fa9c55eb3150262d
11553	20200203	MA			7						7	1					25	0	0	0	totalTestsViral	3	0	0	ceb40934b5ab974376d53e94813829d5219a4d11
11554	20200203	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	d526468a75e5d8d6398391f7374827c75da63c76
11551	20200204	MA			9						9	1					25	0	0	0	totalTestsViral	2	0	0	6ba896859e82f8493b6c3c8926068a6401f3aae8
11552	20200204	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	d5a76e6a18fa1b96755146417ac948a9171616a0
11549	20200205	MA			9						9	1					25	0	0	0	totalTestsViral	0	0	0	7857039c39fbde1edf690d7d40ef4f6a6dcf5c1f
11550	20200205	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	c046f5f2d01538c648a4143cc2483c46733afcec
11547	20200206	MA			10						10	2					25	0	0	0	totalTestsViral	1	0	0	56c88c2a221fa7e33a8c6dd74418e15ef1ae90e4
11548	20200206	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	776627308e5120419ceb0439a2f2e33e2123bf8d
11545	20200207	MA			10						10	2					25	0	0	0	totalTestsViral	0	0	0	47fb70739742538fcd9996ae1ba493d2966964ab
11546	20200207	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	2b9f17998378d4c584a95afd798c91ca8d7d3f1b
11543	20200208	MA			11						11	2					25	0	0	0	totalTestsViral	1	0	0	6e82c90de703416c99e25c91d0129be6ddafa4a4
11544	20200208	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	69f6c69ce71c22a9afe35a3b885b951b07dc9ac2
11541	20200209	MA			11						11	2					25	0	0	0	totalTestsViral	0	0	0	788dc34009b70da245a65558dfee001f5f02adae
11542	20200209	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	428c54e0a7392260add9160a215ef1eaa3abbc8c
11538	20200210	MA			12						12	3					25	0	0	0	totalTestsViral	1	0	0	edb72dcc2c025fee6f5fda2077146b515106419c
11539	20200210	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	5f39d85d1822bc611fb1b9606671951c4104fb2e
11540	20200210	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	c90f9558f2984b8565c534ec076d5cf757407af3
11535	20200211	MA			12						12	3					25	0	0	0	totalTestsViral	0	0	0	abc48e6a80ce71e0028c50b24bbe257d51d27736
11536	20200211	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	64663da144753078ae652920a63807a894a418bd
11537	20200211	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	ff0cb7c50f42126410e0e2a3959a1415c450d6ce
11532	20200212	MA			13						13	3					25	0	0	0	totalTestsViral	1	0	0	0ad7d892894ff707d32fb6dbc5508fca48997c0b
11533	20200212	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	b8bc1fc897f2102c74525c381335a6ea65e3fa79
11534	20200212	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	a0c60ef498021c84c70868dc8f5bf4348d231183
11529	20200213	MA			13						13	3					25	0	0	0	totalTestsViral	0	0	0	6cc2928cc2d5ff21a16e3ed6500cf87e7f538e97
11530	20200213	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	6458612ad578b310c7fcdd7d736abef616f7ca46
11531	20200213	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	e92d97f8ce05a6a9f8becc5b10a34f8ec61b27f1
11526	20200214	MA			13						13	3					25	0	0	0	totalTestsViral	0	0	0	9380a7951898b89449efb4998f810b1278c1e384
11527	20200214	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	5b891ca9720d66e02aaee57078397d55730d6517
11528	20200214	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	591f5dc76d194660b201697ba8687c16e478c5e9
11523	20200215	MA			13						13	3					25	0	0	0	totalTestsViral	0	0	0	ad4e60da5a3b8d9b2467c244a253b644ede4bec5
11524	20200215	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	51dbdb4b4be7ba7edb5fb28295df787ea18dbb75
11525	20200215	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	7983deb48e8cfa38ce6ad2ccd8ce829b4c00e386
11520	20200216	MA			13						13	3					25	0	0	0	totalTestsViral	0	0	0	c04bd0b85b03544eb760f53f649fdacf4271437d
11521	20200216	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	7b2be10826f4c2dad5d856e2df50be6a2888c309
11522	20200216	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	3426c1cf143d5b80508c615b5c54556d4db74be3
11517	20200217	MA			13						13	3					25	0	0	0	totalTestsViral	0	0	0	5cebd2e6e229d1b72f113c84fcd8d5f7bb663df6
11518	20200217	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	a0be14cc41cd70138c5d922fb381da668d56f394
11519	20200217	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	6c29293358450c27b194e2234ad0eba6b212ba3b
11514	20200218	MA			13						13	3					25	0	0	0	totalTestsViral	0	0	0	52129661709702a457b71ba8cfa402275bccdcd6
11515	20200218	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	063370b2a9dc6f1f24be77c828c62aef51112228
11516	20200218	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	b9f2477edf96e4bf6695b83dc203a2e01c283bbd
11511	20200219	MA			13						13	3					25	0	0	0	totalTestsViral	0	0	0	c64227c8466a27bfb13d3da3811874ef8606a9ae
11512	20200219	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	db870a6899a0967b04c2cbffd194a56beeb8e0d0
11513	20200219	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	4de13ed97776e91b872ccd196ca963ea838e63f0
11508	20200220	MA			14						14	4					25	0	0	0	totalTestsViral	1	0	0	f0c5b92a47420e4e4abeeac2a6cf1986184e1472
11509	20200220	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	9b42e6a29e5a7980059868ef08360f56074c3a61
11510	20200220	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	04455407d63f594b20ad6a42511a8e5e3c505e94
11505	20200221	MA			14						14	4					25	0	0	0	totalTestsViral	0	0	0	98804659b5d0a8638d7711283f6bdff6035e3247
11506	20200221	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	a92e3e3879fc600acb34c5d2121ed00c4ef68952
11507	20200221	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	999cc43348f38608d7e748db24121d6a96eaa042
11502	20200222	MA			14						14	4					25	0	0	0	totalTestsViral	0	0	0	a75b45aa34bcadf344994c6fe54462cd13ea2b65
11503	20200222	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	bb55f3a41c2eac2466faf5be4822324ed6405e9a
11504	20200222	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	f5897499c174863a0bfd8111123172cbf4f31d3d
11499	20200223	MA			14						14	4					25	0	0	0	totalTestsViral	0	0	0	9e23cd9633087903faa20721f6543241e5f20978
11500	20200223	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	3b1a9f4913eed0e787d09ae6381daabbd0ea2624
11501	20200223	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	db8c4705e59839721e50b7b884698c445548659c
11496	20200224	MA			16						16	5					25	0	0	0	totalTestsViral	2	0	0	61aac302b5dd6453004894dfca532377c75ea4bb
11497	20200224	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	4529c6da98f160f7387a8c16dc6dfc0c6f9c4c53
11498	20200224	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	2527ffbcac123486d39060a643ee042685444040
11493	20200225	MA			16						16	5					25	0	0	0	totalTestsViral	0	0	0	de869e1cdaceada120b2120c1021257115e178fd
11494	20200225	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	32d52aa91a6b4a79a5fe671c2215763db6709b67
11495	20200225	WA	0	0	0								0		0		53	0	0	0	posNeg	0	0	0	356dd220ebd006a5e8fbf0d90e088f1d23be30aa
11490	20200226	MA			16						16	5					25	0	0	0	totalTestsViral	0	0	0	cf22e081311af409887646c034a523a2397b59e2
11491	20200226	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	19ee38acc47c4148538116e19fbfe38e83c87de6
11492	20200226	WA	0	0	0				2				0		0		53	0	0	0	posNeg	0	0	2	dfacd1905c976c4fcbce13562b7e7fdc66715093
11486	20200227	MA			16						16	5					25	0	0	0	totalTestsViral	0	0	0	9f41108b0d67f48a1c07e8e15fd38374b9f0c414
11487	20200227	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	4389103fa8c0a3711b3e059555cda12c0e9cd08d
11488	20200227	VA			6445										6445		51	0	0	0	posNeg	0	0	0	d6ec33dd0aec6f3ce1b29148c059a480a95436ce
11489	20200227	WA	0	0	0				2				0		0		53	0	0	0	posNeg	0	0	0	d47667bb5e3c371486ca9d76d4846e77ddc826e9
11482	20200228	MA			18						18	6					25	0	0	0	totalTestsViral	2	0	0	6681c3e2fc9dc15ece5bf6986a40bb9b4578a5a3
11483	20200228	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	b375c0930abd40eb3ca31251d6a9dfc11a06fca1
11484	20200228	VA			6445							2090			6445		51	0	0	0	posNeg	0	0	0	c430318e1a246f3899874a4c5d6f9c3746c40d8d
11485	20200228	WA	0	0	0				4				0		0		53	0	0	0	posNeg	0	0	2	33783fc55fe8724ad3f28c003905252e64c14205
11478	20200229	MA			19						19	6					25	0	0	0	totalTestsViral	1	0	0	339121bc011eade545c2cd76026e876b87ccd067
11479	20200229	NJ			0				0					0			34	0	0	0	posNeg	0	0	0	fe2cc9ac6d33a316fa56c5ec5e74f8914e72185f
11480	20200229	VA			6447							2090			6447		51	0	0	0	posNeg	2	0	0	70c517a6d5558200ecef56caf2a2c6a38919f4b1
11481	20200229	WA	18	24	42	2/29/2020 00:00	2020-02-29T00:00:00Z	02/28 19:00	5	2020-02-29T00:00:00Z			18		42	41	53	18	24	42	posNeg	42	42	1	8972c1ea9ca75f42476706b212482111eb222a95