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 "dateChecked" = :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	positiveCasesViral	deathConfirmed	deathProbable	totalTestEncountersViral	totalTestsPeopleViral	totalTestsAntibody	positiveTestsAntibody	totalTestsAntigen	fips	positiveIncrease	negativeIncrease	total	totalTestResultsSource	totalTestResultsIncrease	posNeg	deathIncrease	hash
9	20200926	DC	15215	362764	377979	101		25	17	12029	A+	9/25/2020 00:00	2020-09-25T00:00:00Z	09/24 20:00	624		2020-09-25T00:00:00Z					377979	211599				11	52	4341	377979	posNeg	4393	377979	1	5dd3065a746eea8ae0e9a70d3218cd0129db3054
28	20200926	MP	69	14776	14845		4			29	D	9/25/2020 00:00	2020-09-25T00:00:00Z	09/24 20:00	2	4	2020-09-25T00:00:00Z	19835	69	2			14845				69	0	0	14845	posNeg	0	14845	0	6fdb4898ec2dbbb6eafe41b19ae56eff50411718
29	20200926	MS	96677	634036	730713	601	5607	147	68	85327	A+	9/25/2020 00:00	2020-09-25T00:00:00Z	09/24 20:00	2911	5607	2020-09-25T00:00:00Z	723389	89353	2686	225			38425	95	55557	28	645	3682	730713	posNeg	4327	730713	17	25c406301ef686539186978256312931e29136fe