COVID_COVID19Tracker

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

Custom SQL query returning 12 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 pending 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	totalTestsPeopleAntigen	positiveTestsPeopleAntigen	totalTestsAntigen	positiveTestsAntigen	fips	positiveIncrease	negativeIncrease	total	totalTestResultsSource	totalTestResultsIncrease	posNeg	hospitalizedIncrease	hash
4	20200926	AS	0	1571		1571								D	9/1/2020 00:00	2020-09-01T00:00:00Z	08/31 20:00	0		2020-09-01T00:00:00Z	1571			0												60	0	0	1571	posNeg	0	1571	0	b9eccb7369bdc4ee75708c7a892c5437ab915d83
8	20200926	CT	56587	1462564		1519151	76	11560					9310	B	9/24/2020 20:30	2020-09-24T20:30:00Z	09/24 16:30	4501	11560	2020-09-24T20:30:00Z	1516780			54216	3604	897										9	0	0	1519151	posNeg	0	1519151	0	597a6f3bd03d5e8297830e769c3da2cb90e767e7
19	20200926	KS	56592	446178		502770	343	2816	121	768	34	250	2039	A+	9/25/2020 10:00	2020-09-25T10:00:00Z	09/25 06:00	632	2816	2020-09-25T10:00:00Z								502770								20	0	0	502770	posNeg	0	502770	0	1468f023cf5cebe6e0d2f0752a5b054eecc06b87
21	20200926	LA	165152	2090913		2256065	570				86		149640	A	9/25/2020 13:00	2020-09-25T13:00:00Z	09/25 09:00	5444		2020-09-25T13:00:00Z				163928	5262	182		2254841								22	0	0	2256065	posNeg	0	2256065	0	bda77e8fe6fd07aa1abd19dfbcfc5e00573b8f1f
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	1	7ed34c8487da7bfb9b9473f129d8e5a25a1c0056
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
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	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	e5a147d241db0ad3830218c1038dc29b79d42bcc
49	20200926	UT	69547	735532		805079	191	3702	77	890		358	53806	A+	9/26/2020 11:02	2020-09-26T11:02:00Z	09/26 07:02	448	3702	2020-09-26T11:02:00Z	1037414			69547				805079				13698	1793	23618	1900	49	1017	8845	805079	posNeg	9862	805079	34	3670fa0d15d16f24a5287b6b4adede4295b71342
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	21dc4138bae65a1c22e9f7756f9fd545cb820bea
56	20200926	WY	5465	92406		97871	22	258					4479	B	9/26/2020 11:55	2020-09-26T11:55:00Z	09/26 07:55	50	258	2020-09-26T11:55:00Z	155082	4497	150584	4618				96991								56	45	0	97871	posNeg	45	97871	2	9c1be43cf5db286c8a903c0b3ed654e3d5b588c2
51	20200926	VI	1296	18676	8	19972							1209	D	9/25/2020 09:30	2020-09-25T09:30:00Z	09/25 05:30	19		2020-09-25T09:30:00Z	19980				19											78	0	0	19980	posNeg	0	19972	0	61739fb2efab7827062ca9cc633984208f34bc24