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 "deathIncrease" = :p0 order by totalTestResultsIncrease 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
2	20200926	AL	151591	970048		1104932	709	16852		1791		1007	64583	A	9/26/2020 11:00	2020-09-26T11:00:00Z	09/26 07:00	2501	16852	2020-09-26T11:00:00Z	1104932			134884	2364	137						57800							1	933	6684	1121639	posNeg	7337	1121639	10	0	88370a431af70a13b1499a5cd6afe94a14fc9fb3	0	0	0	0	0
26	20200926	MN	95659	1273023		1954715	340	7443	120	2085			85259	A	9/25/2020 17:00	2020-09-25T17:00:00Z	09/25 13:00	2056	7443	2020-09-25T17:00:00Z				95659	2004	52	1954715	1368682											27	1470	16056	1368682	posNeg	30695	1368682	10	52	9be7f926e01b9ff59c4df68144853a139533f186	0	0	0	0	0