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 "hospitalizedIncrease" = :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
34	20200926	NH	8121	257257		422591	18	734		232			7379	B	9/26/2020 09:00	2020-09-26T09:00:00Z	09/26 05:00	439	734	2020-09-26T09:00:00Z	422591			8121				265378	31666			30983							33	77	18150	265378	posNeg	4902	265378	1	2	55a064dd09da123029c8d41638a6b22a33f1173c	0	0	0	0	0
56	20200926	WY	5465	92406		97871	22	258					4479	B	9/26/2020 11:55	2020-09-26T11:55:00Z	09/26 07:55	50	258	2020-09-26T11:55:00Z	155082	4497	150584	4618				96991											56	45	0	97871	posNeg	45	97871	0	2	9c1be43cf5db286c8a903c0b3ed654e3d5b588c2	0	0	0	0	0