COVID_COVID19Tracker

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

Custom SQL query returning 3 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 "dataQualityGrade" = :p0 order by fips limit 101

Query parameters

This data as json, copyable, CSV

rowid	date	state	positive	negative	pending	totalTestResults	hospitalizedCumulative	recovered	dataQualityGrade	lastUpdateEt	dateModified	checkTimeEt	death	hospitalized	dateChecked	totalTestsViral	positiveCasesViral	deathConfirmed	totalTestsPeopleViral	fips	total	totalTestResultsSource	posNeg	hash
4	20200926	AS	0	1571		1571			D	9/1/2020 00:00	2020-09-01T00:00:00Z	08/31 20:00	0		2020-09-01T00:00:00Z	1571	0			60	1571	posNeg	1571	b9eccb7369bdc4ee75708c7a892c5437ab915d83
28	20200926	MP	69	14776		14845	4	29	D	9/25/2020 00:00	2020-09-25T00:00:00Z	09/24 20:00	2	4	2020-09-25T00:00:00Z	19835	69	2	14845	69	14845	posNeg	14845	6fdb4898ec2dbbb6eafe41b19ae56eff50411718
51	20200926	VI	1296	18676	8	19972		1209	D	9/25/2020 09:30	2020-09-25T09:30:00Z	09/25 05:30	19		2020-09-25T09:30:00Z	19980		19		78	19980	posNeg	19972	61739fb2efab7827062ca9cc633984208f34bc24