COVID_COVID19Tracker

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

Custom SQL query returning 2 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 "dateChecked" = :p0 order by rowid limit 101

Query parameters

This data as json, copyable, CSV

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
6	20200926	CA	798237	13384493		14182730	3203		862					B	9/26/2020 02:59	2020-09-26T02:59:00Z	09/25 22:59	15532		2020-09-26T02:59:00Z	14182730			798237															6	4197	126286	14182730	posNeg	130483	14182730	134	0	bc22d39302ce5646a61aef19adbfa503f5de5e76	0	0	0	0	0
37	20200926	NV	78355	607323		685678	442		125		64		2075	A+	9/26/2020 02:59	2020-09-26T02:59:00Z	09/25 22:59	1582		2020-09-26T02:59:00Z	1026486			78355				684796											32	602	3740	685678	posNeg	4342	685678	9	0	6562d5250f6a1ba7ad8affc64c3a68a2b09dd5cd	0	0	0	0	0