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 "deathIncrease" = :p0 order by negativeTestsViral 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
42	20200926	PA	155232	1830292		1985524	444				60		127290	A+	9/26/2020 12:00	2020-09-26T12:00:00Z	09/26 08:00	8103		2020-09-26T12:00:00Z	2898629			150393				1980685											42	1029	13895	1985524	posNeg	14924	1985524	22	0	95db3b8c62ccc9249c12e799648a8351f5b7337f	0	0	0	0	0
47	20200926	TN	190891	2598988		2789879	855	8528	267		119		174044	A+	9/26/2020 15:00	2020-09-26T15:00:00Z	09/26 11:00	2374	8528	2020-09-26T15:00:00Z	2782844	224629	2558215	183856	2281	93													47	1437	25597	2789879	posNeg	27034	2789879	22	51	053b3f4cd24a0ce9d35d93dfa59a783a7b6091cb	0	0	0	0	0