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

Query parameters

This data as json, copyable, CSV

rowid	date	state	positive	negative	totalTestResults	hospitalizedCurrently	hospitalizedCumulative	inIcuCurrently	inIcuCumulative	onVentilatorCurrently	recovered	dataQualityGrade	lastUpdateEt	dateModified	checkTimeEt	death	hospitalized	dateChecked	totalTestsViral	positiveTestsViral	negativeTestsViral	positiveCasesViral	deathConfirmed	deathProbable	totalTestEncountersViral	totalTestsPeopleViral	totalTestsAntibody	positiveTestsAntibody	negativeTestsAntibody	fips	positiveIncrease	negativeIncrease	total	totalTestResultsSource	totalTestResultsIncrease	posNeg	deathIncrease	hospitalizedIncrease	hash
7	20200926	CO	67926	804806	1277613	248	7479				6404	A	9/25/2020 01:59	2020-09-25T01:59:00Z	09/24 21:59	1940	7479	2020-09-25T01:59:00Z				63137			1277613	867943	166415	11592	154823	8	709	9218	872732	totalTestEncountersViral	16752	872732	5	25	e66aa724278acdbfea40842a634bf1ac4a32fa77
32	20200926	ND	20380	215849	594628	104	809	22	201		16481	B	9/26/2020 01:59	2020-09-26T01:59:00Z	09/25 21:59	156	809	2020-09-26T01:59:00Z	616642			20380	153	3	594628	236229	9344	421	8923	38	495	1100	236229	totalTestEncountersViral	7064	236229	0	20	774fda32838bbbdd408f7f2df9a95d38e10e2829
44	20200926	RI	24181	305853	727469	94	2725	8		4	2278	A+	9/25/2020 12:00	2020-09-25T12:00:00Z	09/25 08:00	1107	2725	2020-09-25T12:00:00Z		34299	693170	24181			727469	330034				44	0	0	330034	totalTestEncountersViral	0	330034	0	0	e5a147d241db0ad3830218c1038dc29b79d42bcc