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 "onVentilatorCurrently" = :p0 order by positiveCasesViral 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
41	20200926	OR	32581	636090		668671	199	2496	40		14		5490	A+	9/26/2020 03:01	2020-09-26T03:01:00Z	09/25 23:01	546	2496	2020-09-26T03:01:00Z			636090	30742				661334											41	267	5498	668671	posNeg	5765	668671	4	0	76f49d2ef6b4e575aed9232f25aefd8711244bf3	0	0	0	0	0
1	20200926	AK	8315	434554		442869	43				14		3267	A	9/26/2020 03:59	2020-09-26T03:59:00Z	09/25 23:59	52		2020-09-26T03:59:00Z	442869	7411	435171	8315	52														2	113	1424	442869	posNeg	1537	442869	1	0	bf7518dcc571d23d1d8206a95e1a1c12173bcb0a	0	0	0	0	0