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 "hospitalizedIncrease" = :p0 order by score limit 101

Query parameters

This data as json, copyable, CSV

rowid	date	state	positive	negative	totalTestResults	hospitalizedCurrently	hospitalizedCumulative	inIcuCurrently	inIcuCumulative	onVentilatorCurrently	onVentilatorCumulative	recovered	dataQualityGrade	lastUpdateEt	dateModified	checkTimeEt	death	hospitalized	dateChecked	totalTestsViral	positiveTestsViral	negativeTestsViral	positiveCasesViral	deathConfirmed	deathProbable	totalTestsPeopleViral	totalTestsAntibody	positiveTestsAntibody	negativeTestsAntibody	totalTestsPeopleAntigen	positiveTestsPeopleAntigen	totalTestsAntigen	positiveTestsAntigen	fips	positiveIncrease	negativeIncrease	total	totalTestResultsSource	totalTestResultsIncrease	posNeg	deathIncrease	hospitalizedIncrease	hash
45	20200926	SC	145273	1097524	1242797	727	9028	186		99		69629	A+	9/25/2020 11:59	2020-09-25T11:59:00Z	09/25 07:59	3323	9028	2020-09-25T11:59:00Z	1238862	181055	1057807	141338	3141	182		70491	6831	63660			39995	9972	45	1371	14959	1242797	posNeg	16330	1242797	26	34	f961ffe6bba29cf00c45195b6b3d192e8cd6b734
46	20200926	SD	21133	165001	186134	213	1434					17173	A	9/25/2020 14:00	2020-09-25T14:00:00Z	09/25 10:00	218	1434	2020-09-25T14:00:00Z	260219						186134								46	579	1608	186134	posNeg	2187	186134	2	34	ca6a7392a4ed3947a93b80040d2c4fffc4abcbe2
49	20200926	UT	69547	735532	805079	191	3702	77	890		358	53806	A+	9/26/2020 11:02	2020-09-26T11:02:00Z	09/26 07:02	448	3702	2020-09-26T11:02:00Z	1037414			69547			805079				13698	1793	23618	1900	49	1017	8845	805079	posNeg	9862	805079	0	34	3670fa0d15d16f24a5287b6b4adede4295b71342