COVID_COVID19Tracker

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

Custom SQL query returning 4 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 rowid limit 101

Query parameters

This data as json, copyable, CSV

rowid	date	state	positive	negative	totalTestResults	hospitalizedCurrently	hospitalizedCumulative	inIcuCurrently	onVentilatorCurrently	recovered	dataQualityGrade	lastUpdateEt	dateModified	checkTimeEt	death	hospitalized	dateChecked	totalTestsViral	positiveTestsViral	negativeTestsViral	positiveCasesViral	deathConfirmed	deathProbable	totalTestsAntibody	positiveTestsAntibody	fips	positiveIncrease	negativeIncrease	total	totalTestResultsSource	totalTestResultsIncrease	posNeg	deathIncrease	hospitalizedIncrease	hash
30	20200926	MT	11907	317378	329285	147	684			8749	C	9/26/2020 01:59	2020-09-26T01:59:00Z	09/25 21:59	171	684	2020-09-26T01:59:00Z	329285			11907					30	343	2826	329285	posNeg	3169	329285	1	9	2b25a5d9191b4d38560392a23353c41e646042be
36	20200926	NM	28487	865002	893489	75	3420			16020	C	9/25/2020 17:50	2020-09-25T17:50:00Z	09/25 13:50	865	3420	2020-09-25T17:50:00Z	893489			28487					35	263	7853	893489	posNeg	8116	893489	6	18	ca61662b5c3adb6ac3a1bd588dfa0ca45978ca5b
43	20200926	PR	45413	305972	351385	342		59	33		C	9/26/2020 00:00	2020-09-26T00:00:00Z	09/25 20:00	642		2020-09-26T00:00:00Z	310546	7002	303412	22164	471	171		23249	72	508	0	351385	posNeg	508	351385	7	0	347836cd67621b97708a39d1a47689f42650b1b1
55	20200926	WV	15158	527133	542291	174		56	31	11121	C	9/25/2020 23:59	2020-09-25T23:59:00Z	09/25 19:59	332		2020-09-25T23:59:00Z	541883			14750	329	3	17205		54	205	6692	542291	posNeg	6897	542291	2	0	a4823873f7e477ab8b531c7edd4b61423f7dbfdb