COVID_COVID19Tracker

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

Custom SQL query returning 10 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 positiveCasesViral limit 101

Query parameters

This data as json, copyable, CSV

rowid	date	state	positive	negative	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	totalTestsAntigen	fips	positiveIncrease	negativeIncrease	total	totalTestResultsSource	totalTestResultsIncrease	posNeg	deathIncrease	hospitalizedIncrease	hash
14	20200926	HI	11891	278076	289967	150	787	55		30	5397	B	9/25/2020 18:00	2020-09-25T18:00:00Z	09/25 14:00	127	787	2020-09-25T18:00:00Z	402010							289967								15	112	2980	289967	posNeg	3092	289967	3	8	6244d9b33b4882c0c4fd80e6a666219eab29ae6e
27	20200926	MO	122014	1167155	1289169	1101						B	9/26/2020 00:00	2020-09-26T00:00:00Z	09/25 20:00	2063		2020-09-26T00:00:00Z	1687509	128009	1556710	122014				1289169				74093	3508	70585		29	1716	14288	1289169	posNeg	16004	1289169	69	0	de543358a328e51d3abdbaecc32041460021841e
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
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	0	20	774fda32838bbbdd408f7f2df9a95d38e10e2829
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	0	2	9c1be43cf5db286c8a903c0b3ed654e3d5b588c2
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	0	597a6f3bd03d5e8297830e769c3da2cb90e767e7
20	20200926	KY	66036	1216560	1274688	538	5193	129	1511		11750	B	9/26/2020 00:00	2020-09-26T00:00:00Z	09/25 20:00	1154	5193	2020-09-26T00:00:00Z	1274688			58128	1144	10			55724						24514	21	970	29298	1282596	posNeg	30060	1282596	5	46	bbc51488b99291f0d9e247a91056b3ddc5af5618
6	20200926	CA	798237	13384493	14182730	3203		862				B	9/26/2020 02:59	2020-09-26T02:59:00Z	09/25 22:59	15532		2020-09-26T02:59:00Z	14182730			798237												6	4197	126286	14182730	posNeg	130483	14182730	134	0	bc22d39302ce5646a61aef19adbfa503f5de5e76
34	20200926	NH	8121	257257	422591	18	734		232		7379	B	9/26/2020 09:00	2020-09-26T09:00:00Z	09/26 05:00	439	734	2020-09-26T09:00:00Z	422591			8121				265378	31666			30983				33	77	18150	265378	posNeg	4902	265378	1	2	55a064dd09da123029c8d41638a6b22a33f1173c
53	20200926	WA	85226	1715795	1801021	264	7412			28		B	9/25/2020 02:59	2020-09-25T02:59:00Z	09/24 22:59	2100	7412	2020-09-25T02:59:00Z				85226	2100		1801021									53	988	16754	1801021	posNeg	17742	1801021	20	55	fd6ce507d03586f2b0ac32e299f88b85d7393013