COVID_COVID19Tracker

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

Custom SQL query returning 4 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_current where "deathIncrease" = :p0 order by totalTestsPeopleAntibody limit 101

Query parameters

This data as json, copyable, CSV

rowid	date	state	positive	negative	totalTestResults	hospitalizedCurrently	hospitalizedCumulative	inIcuCurrently	onVentilatorCurrently	recovered	dataQualityGrade	lastUpdateEt	dateModified	checkTimeEt	death	hospitalized	dateChecked	totalTestsViral	positiveCasesViral	deathConfirmed	deathProbable	totalTestsPeopleViral	totalTestsAntibody	positiveTestsAntibody	fips	positiveIncrease	negativeIncrease	total	totalTestResultsSource	totalTestResultsIncrease	posNeg	deathIncrease	hospitalizedIncrease	hash
10	20200926	DE	20156	260243	280399	57		10		10541	A+	9/25/2020 18:00	2020-09-25T18:00:00Z	09/25 14:00	633		2020-09-25T18:00:00Z		19103	556	77	280399			10	71	954	280399	posNeg	1025	280399	2	0	e3e0fc4116a2a29665fe6bffd51a89a13780977a
13	20200926	GU	2354	46365	48719	30		9		1668	A	9/26/2020 09:45	2020-09-26T09:45:00Z	09/26 05:45	43		2020-09-26T09:45:00Z	48254	2354			48719	179	3	66	68	395	48719	posNeg	463	48719	2	0	7185eba890dd8a1d9ad81f1a7efd70101c32b967
46	20200926	SD	21133	165001	186134	213	1434			17173	A	9/25/2020 14:00	2020-09-25T14:00:00Z	09/25 10:00	218	1434	2020-09-25T14:00:00Z	260219				186134			46	579	1608	186134	posNeg	2187	186134	2	34	ca6a7392a4ed3947a93b80040d2c4fffc4abcbe2
55	20200926	WV	15158	527133	542291	174		56	31	11121	C	9/25/2020 23:59	2020-09-25T23:59:00Z	09/25 19:59	332		2020-09-25T23:59:00Z	541883	14750	329	3		17205		54	205	6692	542291	posNeg	6897	542291	2	0	a4823873f7e477ab8b531c7edd4b61423f7dbfdb