COVID_COVID19Tracker

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

Custom SQL query returning 15 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 "dataQualityGrade" = :p0 order by negativeTestsViral 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	positiveTestsPeopleAntigen	totalTestsAntigen	positiveTestsAntigen	fips	positiveIncrease	negativeIncrease	total	totalTestResultsSource	totalTestResultsIncrease	posNeg	deathIncrease	hospitalizedIncrease	hash
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
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
13	20200926	GU	2354	46365		48719	30		9				1668	A	9/26/2020 09:45	2020-09-26T09:45:00Z	09/26 05:45	43		2020-09-26T09:45:00Z	48254			2354				48719	179	3								66	68	395	48719	posNeg	463	48719	2	0	7185eba890dd8a1d9ad81f1a7efd70101c32b967
16	20200926	ID	39757	262420		298652	135	1795	44	451			21291	A	9/25/2020 18:55	2020-09-25T18:55:00Z	09/25 14:55	458	1795	2020-09-25T18:55:00Z	298652			36232	421	37												16	523	1772	302177	posNeg	2240	302177	1	29	71c4c31498029adf59faba29c2c940f819b1402a
17	20200926	IL	288815	5142362		5431177	1597		355		141			A	9/26/2020 00:00	2020-09-26T00:00:00Z	09/25 20:00	8832		2020-09-26T00:00:00Z	5428688			286326	8588	244												17	2441	62776	5431177	posNeg	65217	5431177	25	0	2620e4472a6793bd94436e1e6a2f1efbe8f39315
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	0	bda77e8fe6fd07aa1abd19dfbcfc5e00573b8f1f
23	20200926	MD	122972	1461328		1584300	347	15382	81				7458	A	9/26/2020 10:00	2020-09-26T10:00:00Z	09/26 06:00	3925	15382	2020-09-26T10:00:00Z	2525658	147256		122972	3780	145		1584300										24	613	11203	1584300	posNeg	11816	1584300	8	54	cf952879908e5d11013c8da79ad58cd91ef3a04b
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
33	20200926	NE	43162	397483		440645	225	2276					32238	A	9/25/2020 20:30	2020-09-25T20:30:00Z	09/25 16:30	468	2276	2020-09-25T20:30:00Z	595287			43162				440947										31	431	2910	440645	posNeg	3341	440645	6	17	dff40db61c6d6203f6a42331a30731482bfd47e3
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
46	20200926	SD	21133	165001		186134	213	1434					17173	A	9/25/2020 14:00	2020-09-25T14:00:00Z	09/25 10:00	218	1434	2020-09-25T14:00:00Z	260219							186134										46	579	1608	186134	posNeg	2187	186134	2	34	ca6a7392a4ed3947a93b80040d2c4fffc4abcbe2
48	20200926	TX	733438	5261375		5994813	3209		1056				649580	A	9/26/2020 16:20	2020-09-26T16:20:00Z	09/26 12:20	15485		2020-09-26T16:20:00Z	5994813			733438					399337	35847						80294	9297	48	4886	76478	5994813	posNeg	81364	5994813	121	0	118422653c167fc9d3ed0bd4ad4d2a32d4f6a49a
12	20200926	GA	313873	2558482		2872355	1831	28153		5176				A	9/26/2020 14:50	2020-09-26T14:50:00Z	09/26 10:50	6914	28153	2020-09-26T14:50:00Z	2872355	292318	2580037	313873					299555	24723								13	1359	23502	2872355	posNeg	24861	2872355	40	118	9ab79841fa3a6c3d058ce3f94b9671540d5a8880
1	20200926	AK	8315	434554		442869	43				14		3267	A	9/26/2020 03:59	2020-09-26T03:59:00Z	09/25 23:59	52		2020-09-26T03:59:00Z	442869	7411	435171	8315	52													2	113	1424	442869	posNeg	1537	442869	1	0	bf7518dcc571d23d1d8206a95e1a1c12173bcb0a
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