COVID_COVID19Tracker

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

Custom SQL query returning 6 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	pending	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	totalTestsPeopleAntibody	positiveTestsPeopleAntibody	negativeTestsPeopleAntibody	positiveTestsPeopleAntigen	fips	positiveIncrease	negativeIncrease	total	totalTestResultsSource	totalTestResultsIncrease	posNeg	deathIncrease	hospitalizedIncrease	hash
11	20200926	FL	698682	4536325	4001	5235007	2099	43964					A	9/25/2020 23:59	2020-09-25T23:59:00Z	09/25 19:59	14190	43964	2020-09-25T23:59:00Z	7383930	899158	6443064	698682	14190			5242163	505164	45080	460024	493810	44075	449702	16485	12	2795	26218	5239008	posNeg	29013	5235007	107	171	dc9d1e1af52716f018602f6f32d66d5e9c263c88
18	20200926	IN	116549	1233841		1350390	910	12521	259	2497	92	92306	A+	9/25/2020 23:59	2020-09-25T23:59:00Z	09/25 19:59	3577	12521	2020-09-25T23:59:00Z	1989928				3351	226		1350390								18	1142	7786	1350390	posNeg	8928	1350390	11	58	c434c8dc087571d7e42607998e7613c3f97def2f
24	20200926	ME	5260	401159		406419	8	443	1		0	4538	A+	9/25/2020 23:59	2020-09-25T23:59:00Z	09/25 19:59	140	443	2020-09-25T23:59:00Z	405850	6490	399070	4713	139	1			10270	516	9740					23	25	0	406419	posNeg	25	406419	0	1	7ed34c8487da7bfb9b9473f129d8e5a25a1c0056
38	20200926	NY	454760	9968656		10423416	527	89995	164		75	76528	A	9/25/2020 23:59	2020-09-25T23:59:00Z	09/25 19:59	25450	89995	2020-09-25T23:59:00Z				454760			10423416									36	1005	98948	10423416	posNeg	99953	10423416	4	0	bb7957fb78d761d4366fb1503123856475c70689
52	20200926	VT	1739	158537		160276	1					1580	B	9/25/2020 23:59	2020-09-25T23:59:00Z	09/25 19:59	58		2020-09-25T23:59:00Z				1739	58			160276								50	8	989	160276	posNeg	997	160276	0	0	21dc4138bae65a1c22e9f7756f9fd545cb820bea
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