COVID_COVID19Tracker

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

Custom SQL query returning 24 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 rowid 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	totalTestsPeopleAntigen	positiveTestsPeopleAntigen	totalTestsAntigen	positiveTestsAntigen	fips	positiveIncrease	negativeIncrease	total	totalTestResultsSource	totalTestResultsIncrease	posNeg	deathIncrease	hospitalizedIncrease	hash
3	20200926	AR	80755	855635		933895	447	5202	213		91	657	72051	A+	9/26/2020 00:00	2020-09-26T00:00:00Z	09/25 20:00	1285	5202	2020-09-26T00:00:00Z	933895		855635	78260	1137	148									10264	2706	21856	3300	5	809	6813	936390	posNeg	7601	936390	19	0	1177f6d15b81adb770caebd6b66b47189c93f198
5	20200926	AZ	216826	1221851		1434227	509	22005	115		56		34730	A+	9/26/2020 00:00	2020-09-26T00:00:00Z	09/25 20:00	5622	22005	2020-09-26T00:00:00Z				212376	5355	267		1434227	290470										4	459	10194	1438677	posNeg	10624	1438677	35	33	130636fd317b3160d4644679abe3501863463881
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	0	5dd3065a746eea8ae0e9a70d3218cd0129db3054
10	20200926	DE	20156	260243		280399	57		10				10541	A+	9/25/2020 18:00	2020-09-25T18:00:00Z	09/25 14:00	633		2020-09-25T18:00:00Z				19103	556	77		280399											10	71	954	280399	posNeg	1025	280399	2	0	e3e0fc4116a2a29665fe6bffd51a89a13780977a
15	20200926	IA	82944	667954		750898	334		84		29		65490	A+	9/26/2020 00:00	2020-09-26T00:00:00Z	09/25 20:00	1311		2020-09-26T00:00:00Z				82944				752449				57997	3389	54568	20350	2645			19	899	5018	750898	posNeg	5917	750898	4	0	47decf503735f781b057e655041ca39b2b4fb714
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
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	0	1468f023cf5cebe6e0d2f0752a5b054eecc06b87
22	20200926	MA	130050	2046728		3780020	354	12637	77		28		111479	A+	9/26/2020 08:00	2020-09-26T08:00:00Z	09/26 04:00	9391	12637	2020-09-26T08:00:00Z	3780020	167823		127832	9178	213		2174560				119693			126039				25	569	13795	2176778	totalTestsViral	73292	2176778	18	18	6b3d0a05572af2a2470ddc16f5fda3df4be4692c
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
25	20200926	MI	134373	3408684		3543057	558		139		52		95051	A+	9/26/2020 00:00	2020-09-26T00:00:00Z	09/25 20:00	7044		2020-09-26T00:00:00Z	3578584	169900	3408684	121427	6723	321			291180										26	996	39749	3543057	posNeg	40745	3543057	17	0	2e49e36255f6a6daef66f967af21b911b45c97ad
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	0	25c406301ef686539186978256312931e29136fe
31	20200926	NC	206090	2741713		2947803	914		272				176422	A+	9/26/2020 12:00	2020-09-26T12:00:00Z	09/26 08:00	3440		2020-09-26T12:00:00Z	2943144			201431	3440														37	1759	38427	2947803	posNeg	40186	2947803	31	0	20a1b19461a3df0fea54c6dfb6ffc967453a835b
35	20200926	NJ	202850	3309718		3512568	426	23324	88		38		34650	A+	9/26/2020 00:00	2020-09-26T00:00:00Z	09/25 20:00	16103	23324	2020-09-26T00:00:00Z	3512568			202850	14312	1791													34	750	33107	3512568	posNeg	33857	3512568	6	39	cd73d3de8c388876eca2bfe00d66d734af82857f
37	20200926	NV	78355	607323		685678	442		125		64		2075	A+	9/26/2020 02:59	2020-09-26T02:59:00Z	09/25 22:59	1582		2020-09-26T02:59:00Z	1026486			78355				684796											32	602	3740	685678	posNeg	4342	685678	9	0	6562d5250f6a1ba7ad8affc64c3a68a2b09dd5cd
39	20200926	OH	150009	2883978		3033987	625	15185	205	3247	95		129498	A+	9/26/2020 14:00	2020-09-26T14:00:00Z	09/26 10:00	4740	15185	2020-09-26T14:00:00Z	3025649			141671	4439	301													39	1115	37279	3033987	posNeg	38394	3033987	6	58	bc6ac50a6f9a24d96bc3280b69d405cfab1f7ca9
40	20200926	OK	83510	1075475	6653	1158985	579	6252	223				69754	A+	9/26/2020 00:00	2020-09-26T00:00:00Z	09/25 20:00	1004	6252	2020-09-26T00:00:00Z	1172554	94741	1075475	83510					78836	3997									40	990	17331	1165638	posNeg	18321	1158985	11	60	832a286352d7b6c33cd6f7c2aca41c1e843e62b5
41	20200926	OR	32581	636090		668671	199	2496	40		14		5490	A+	9/26/2020 03:01	2020-09-26T03:01:00Z	09/25 23:01	546	2496	2020-09-26T03:01:00Z			636090	30742				661334											41	267	5498	668671	posNeg	5765	668671	4	0	76f49d2ef6b4e575aed9232f25aefd8711244bf3
42	20200926	PA	155232	1830292		1985524	444				60		127290	A+	9/26/2020 12:00	2020-09-26T12:00:00Z	09/26 08:00	8103		2020-09-26T12:00:00Z	2898629			150393				1980685											42	1029	13895	1985524	posNeg	14924	1985524	22	0	95db3b8c62ccc9249c12e799648a8351f5b7337f
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	0	e5a147d241db0ad3830218c1038dc29b79d42bcc
45	20200926	SC	145273	1097524		1242797	727	9028	186		99		69629	A+	9/25/2020 11:59	2020-09-25T11:59:00Z	09/25 07:59	3323	9028	2020-09-25T11:59:00Z	1238862	181055	1057807	141338	3141	182			70491	6831	63660						39995	9972	45	1371	14959	1242797	posNeg	16330	1242797	26	34	f961ffe6bba29cf00c45195b6b3d192e8cd6b734
47	20200926	TN	190891	2598988		2789879	855	8528	267		119		174044	A+	9/26/2020 15:00	2020-09-26T15:00:00Z	09/26 11:00	2374	8528	2020-09-26T15:00:00Z	2782844	224629	2558215	183856	2281	93													47	1437	25597	2789879	posNeg	27034	2789879	22	51	053b3f4cd24a0ce9d35d93dfa59a783a7b6091cb
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	0	34	3670fa0d15d16f24a5287b6b4adede4295b71342
50	20200926	VA	145408	1855171	310	1993344	924	18179	202		111		17255	A+	9/25/2020 17:00	2020-09-25T17:00:00Z	09/25 13:00	3144	18179	2020-09-25T17:00:00Z		165048		138173	2937	207	1993344												51	975	18955	2000889	posNeg	19845	2000579	8	29	5f2f6648c9200ea7be7a0d221a8b6dffb911ae4c
54	20200926	WI	120231	1393412	211	1513643	574	7041	161	1153			94094	A+	9/26/2020 00:00	2020-09-26T00:00:00Z	09/25 20:00	1291	7041	2020-09-26T00:00:00Z				113645	1281	10		1507057											55	2902	9767	1513854	posNeg	12669	1513643	7	79	fb3c2ebb10eddd0158608674af0e708a51da7173