states_daily_4pm_et

Table actions

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

11,578 rows sorted by totalTestResultsIncrease

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link 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
756 756 20200913 MP 60 14316   14376   4         29 C 9/12/2020 00:00 2020-09-12T00:00:00Z 09/11 20:00 2 4 2020-09-12T00:00:00Z 18915     60 2     14375                     69 0 0 14376 posNeg 0 14376 0 0 6d0fd1b1a822d1b152febe3364cbc69c22ca324e 0 0 0 0 0  
788 788 20200912 AS 0 1571   1571               C 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 0 ca96fa86c9a0c4210a96c86ab92800701dce88ad 0 0 0 0 0  
792 792 20200912 CT 54326 1276658   1330984 51 11357         9142 B 9/10/2020 20:30 2020-09-10T20:30:00Z 09/10 16:30 4480 11357 2020-09-10T20:30:00Z 1328753     52095 3595 885                         9 0 0 1330984 posNeg 0 1330984 0 0 5d1caef4558d54c252bb89a98ec83c654656b62e 0 0 0 0 0  
803 803 20200912 KS 48386 400544   448930 140 2537 40 690 10 219 1859 A+ 9/11/2020 10:00 2020-09-11T10:00:00Z 09/11 06:00 511 2537 2020-09-11T10:00:00Z               448930                     20 0 0 448930 posNeg 0 448930 0 0 35d7ce6cf7bf9d30d0feb2960da36d3140ea08ae 0 0 0 0 0  
805 805 20200912 LA 157109 1880644   2037753 723       117   140440 A 9/11/2020 13:00 2020-09-11T13:00:00Z 09/11 09:00 5202   2020-09-11T13:00:00Z       156174 5032 170   2036818                     22 0 0 2037753 posNeg 0 2037753 0 0 3add26a8e3d061aad50f1595e2ed87b3bb0def9a 0 0 0 0 0  
843 843 20200911 AR 68983 729375   796179 392 4678     76 597 61245 A 9/11/2020 14:35 2020-09-11T14:35:00Z 09/11 10:35 953 4678 2020-09-11T14:35:00Z 796179   729375 67911                         17549 2709 5 1180 0 798358 posNeg 0 798358 13 72 2348f9a7b8b46f7301b5aa6a35b72ae97760da85 0 0 0 0 0  
844 844 20200911 AS 0 1571   1571               C 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 0 af92759401b47f8c1b3777fde5b06c65b773a25a 0 0 0 0 0  
850 850 20200911 DE 18466 238232   256698 66   14       10027 A+ 9/10/2020 18:00 2020-09-10T18:00:00Z 09/10 14:00 613   2020-09-10T18:00:00Z       17475 541 72   256698                     10 0 0 256698 posNeg 0 256698 0 0 d5f5554fc831c6f3f948b05bc60214ff1b65d4ea 0 0 0 0 0  
868 868 20200911 MP 59 14316   14375   4         29 C 9/8/2020 00:00 2020-09-08T00:00:00Z 09/07 20:00 2 4 2020-09-08T00:00:00Z 18915     59 2     14375                     69 0 0 14375 posNeg 0 14375 0 0 2fe4a94252b2d399ea4beedaf2fefdf86e6e16e3 0 0 0 0 0  
900 900 20200910 AS 0 1571   1571               C 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 0 aafe07069b99c5cb6e3a433727b4d1233cba2abd 0 0 0 0 0  
915 915 20200910 KS 47410 394004   441414 319 2470 92 677 41 218 1817 A+ 9/9/2020 10:00 2020-09-09T10:00:00Z 09/09 06:00 495 2470 2020-09-09T10:00:00Z               441414                     20 0 0 441414 posNeg 0 441414 0 0 a91beae2007bee85ad1070f7515aad4b5f8a4431 0 0 0 0 0  
955 955 20200909 AR 67255 716973   782994 411 4574     82 586 59920 A 9/9/2020 14:50 2020-09-09T14:50:00Z 09/09 10:50 928 4574 2020-09-09T14:50:00Z 782994   716973 66406                         16591 2556 5 498 0 784228 posNeg 0 784228 11 50 edfa5b5c3a56c15c873019a76381cd7e64d2d434 0 0 0 0 0  
956 956 20200909 AS 0 1571   1571               C 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 0 b568d4827408ce320e19f678e9d3d4da52b89bf1 0 0 0 0 0  
962 962 20200909 DE 18308 235662   253970 53   12       9920 A+ 9/7/2020 18:00 2020-09-07T18:00:00Z 09/07 14:00 609   2020-09-07T18:00:00Z       17317 537 72   253970                     10 0 0 253970 posNeg 0 253970 0 0 6efd148cf24ef6a330d3d56b42db563c8d67f356 0 0 0 0 0  
980 980 20200909 MP 59 13484   13543   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     59 2     13540                     69 0 0 13543 posNeg 0 13543 0 0 03d6e521defdae0ad99269ea3876502901160d28 0 0 0 0 0  
986 986 20200909 NH 7494 215469   356180 7 718   227     6825 B 9/8/2020 09:00 2020-09-08T09:00:00Z 09/08 05:00 433 718 2020-09-08T09:00:00Z 356180     7494       222963 30824     30164             33 0 0 222963 posNeg 0 222963 0 0 c5edef6898ba86a8bebb3fcee895efb40b41e262 0 0 0 0 0  
1003 1003 20200909 VI 1191 16253 15 17444             1070 C 9/8/2020 06:03 2020-09-08T06:03:00Z 09/08 02:03 18   2020-09-08T06:03:00Z 17459       18                           78 0 0 17459 posNeg 0 17444 0 0 de5c19a159a708163d9148528f39a5a97d9e79fa 0 0 0 0 0  
1027 1027 20200908 KS 46914 389772   436686 177 2441 51 669 25 214 1796 A+ 9/7/2020 10:00 2020-09-07T10:00:00Z 09/07 06:00 485 2441 2020-09-07T10:00:00Z               436686                     20 0 0 436686 posNeg 0 436686 0 0 15cc8c4ad5d63cb73df8254edf90fb3734938d45 0 0 0 0 0  
1061 1061 20200908 WA 77235 1485818   1563053 277 6860     37     B 9/6/2020 02:59 2020-09-06T02:59:00Z 09/05 22:59 1953 6860 2020-09-06T02:59:00Z       77235 1953   1563053                       53 0 0 1563053 posNeg 0 1563053 0 0 6ba255671b79e34e2ea3be606ee6fc0cedb4c0d3 0 0 0 0 0  
1068 1068 20200907 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 5085675dfa58821863ab561c420b108feb82868d 0 0 0 0 0  
1072 1072 20200907 CT 53365 1184293   1237658 58 11275         9049 B 9/4/2020 20:30 2020-09-04T20:30:00Z 09/04 16:30 4468 11275 2020-09-04T20:30:00Z 1235514     51221 3583 885                         9 0 0 1237658 posNeg 0 1237658 0 0 4adf6d49af72c25ef07427f7c4e31b0a6e3f475a 0 0 0 0 0  
1077 1077 20200907 GU 1671 39070   40741 57   14       744 A+ 9/6/2020 22:45 2020-09-06T22:45:00Z 09/06 18:45 18   2020-09-06T22:45:00Z 40110     1671       40741 158 2                 66 0 0 40741 posNeg 0 40741 2 0 9f5c3096cd3265488258532a041898e473f67b1c 0 0 0 0 0  
1092 1092 20200907 MP 58 13484   13542   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     58 2     13540                     69 0 0 13542 posNeg 0 13542 0 0 775d656966bf522797679c0f5ef1cd8d8ae1faa5 0 0 0 0 0  
1120 1120 20200907 WY 4032 74312   78344 15 219         3416 A 9/6/2020 11:25 2020-09-06T11:25:00Z 09/06 07:25 42 219 2020-09-06T11:25:00Z 111391 3230 108160 3425       77685                     56 0 0 78344 posNeg 0 78344 0 0 04a792543a58c1cc36bba4564882ef188bb61190 0 0 0 0 0  
1123 1123 20200906 AR 65226 700721   765411 389 4462     78 568 58295 A 9/6/2020 17:30 2020-09-06T17:30:00Z 09/06 13:30 894 4462 2020-09-06T17:30:00Z 765411   700721 64690                         14859 2311 5 0 0 765947 posNeg 0 765947 12 6 d065f2bed86d6d38f3759cebc256396577446cb6 0 0 0 0 0  
1124 1124 20200906 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 8e9a58f72785fb83c490d6b168f1467bd6c2e8f8 0 0 0 0 0  
1128 1128 20200906 CT 53365 1184293   1237658 58 11275         9049 B 9/3/2020 20:30 2020-09-03T20:30:00Z 09/03 16:30 4468 11275 2020-09-03T20:30:00Z 1235514     51221 3583 885                         9 0 0 1237658 posNeg 0 1237658 0 0 136e22546af269f199486eb79c977a2c2ca41531 0 0 0 0 0  
1133 1133 20200906 GU 1671 39070   40741 57   14       744 A+ 9/5/2020 12:50 2020-09-05T12:50:00Z 09/05 08:50 16   2020-09-05T12:50:00Z 40110     1671       40741 158 2                 66 0 0 40741 posNeg 0 40741 1 0 286857542ef6a71bcbd6baef1e647fca426d8600 0 0 0 0 0  
1139 1139 20200906 KS 45220 381985   427205 314 2415 101 661 36 211 1785 A+ 9/4/2020 10:00 2020-09-04T10:00:00Z 09/04 06:00 481 2415 2020-09-04T10:00:00Z               427205                     20 0 0 427205 posNeg 0 427205 0 0 ae08ff8f436cb20b22353384be116a7c3def7f95 0 0 0 0 0  
1140 1140 20200906 KY 52774 819355   866842 535 4713 128 1414     10613 B 9/6/2020 00:00 2020-09-06T00:00:00Z 09/05 20:00 996 4713 2020-09-06T00:00:00Z 866842     47741 987 9     47702               15830   21 310 0 872129 posNeg 0 872129 3 0 3783823c6af0b1cd186b37e42e28cdb373cf16ce 0 0 0 0 0  
1145 1145 20200906 MI 117191 2801811   2919002 616   158   71   80678 A+ 9/5/2020 00:00 2020-09-05T00:00:00Z 09/04 20:00 6806   2020-09-05T00:00:00Z 2951815 150004 2801811 106215 6534 272     263721                   26 0 0 2919002 posNeg 0 2919002 0 0 f1437d5a6117d5b7364470917e6d6b5310f319fe 0 0 0 0 0  
1148 1148 20200906 MP 58 13484   13542   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     58 2     13540                     69 0 0 13542 posNeg 0 13542 0 0 27b844b60ca92a40925110b9427cbf144ff71f17 0 0 0 0 0  
1180 1180 20200905 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 78615189f736f50add2170e1fb8468820dba264a 0 0 0 0 0  
1184 1184 20200905 CT 53365 1184293   1237658 58 11275         9049 B 9/3/2020 20:30 2020-09-03T20:30:00Z 09/03 16:30 4468 11275 2020-09-03T20:30:00Z 1235514     51221 3583 885                         9 0 0 1237658 posNeg 0 1237658 0 0 9b4609ad40b70405024dcda98d00feb702573920 0 0 0 0 0  
1195 1195 20200905 KS 45220 381985   427205 314 2415 101 661 36 211 1785 A+ 9/4/2020 10:00 2020-09-04T10:00:00Z 09/04 06:00 481 2415 2020-09-04T10:00:00Z               427205                     20 0 0 427205 posNeg 0 427205 0 0 522b631bace6f0d1224d5afb2e2846e55104ae0f 0 0 0 0 0  
1197 1197 20200905 LA 152369 1780275   1932644 808       96   134432 A 9/4/2020 13:00 2020-09-04T13:00:00Z 09/04 09:00 5035   2020-09-04T13:00:00Z       151473 4872 163   1931748                     22 0 0 1932644 posNeg 0 1932644 0 0 86e15cf7139495893aae50ed3c2eab9fc8587bad 0 0 0 0 0  
1236 1236 20200904 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 f60826de4e95b3f4a2a0f00c53e1bde01483b6c9 0 0 0 0 0  
1260 1260 20200904 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 0 0 13541 posNeg 0 13541 0 0 6a5775dfc03759ee10f326a446c010dc219d4e3b 0 0 0 0 0  
1291 1291 20200903 AR 63504 675337   737449 425 4386     91 562 56889 A 9/3/2020 14:40 2020-09-03T14:40:00Z 09/03 10:40 861 4386 2020-09-03T14:40:00Z 737449   675337 63081                         13631 2109 5 1392 0 738841 posNeg 0 738841 20 45 419fc70b216ad8578621a78a2321ef33fde413ae 0 0 0 0 0  
1292 1292 20200903 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 56dee75bc9943e7392a15213f148aadf8d45c564 0 0 0 0 0  
1307 1307 20200903 KS 43940 375307   419247 336 2361 94 649 35 210 1730 A+ 9/2/2020 10:00 2020-09-02T10:00:00Z 09/02 06:00 458 2361 2020-09-02T10:00:00Z               419247                     20 0 0 419247 posNeg 0 419247 0 0 3547179e1328a598ffafd493c32d36c7e7c5c031 0 0 0 0 0  
1316 1316 20200903 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 0 0 13541 posNeg 0 13541 0 0 6d3fbada05132b8f400b437dbc810b415fc98952 0 0 0 0 0  
1348 1348 20200902 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 48ebb399ca7a84fe4e65df7be64d01c2adde9b27 0 0 0 0 0  
1372 1372 20200902 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 0 0 13541 posNeg 0 13541 0 0 a431b7eb0449131837e1789a13858652ace850cf 0 0 0 0 0  
1378 1378 20200902 NH 7297 203984   329116 8 715   221     6634 B 9/1/2020 09:00 2020-09-01T09:00:00Z 09/01 05:00 432 715 2020-09-01T09:00:00Z 329116     7297       211281 30385     29761             33 0 0 211281 posNeg 0 211281 0 0 3395348e8655ae62da6779299352168bc0f27eb1 0 0 0 0 0  
1404 1404 20200901 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 9cd47401a2852789f2ffe4df905e7afe7ba9b228 0 0 0 0 0  
1419 1419 20200901 KS 42612 370637   413249 211 2304 55 628 21 209 1673 A+ 8/31/2020 10:00 2020-08-31T10:00:00Z 08/31 06:00 446 2304 2020-08-31T10:00:00Z               413249                     20 0 0 413249 posNeg 0 413249 0 0 d41b9e59e3d58be3c25670467ad605537a59f08d 0 0 0 0 0  
1460 1460 20200831 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 cc53fe6dbb4b1014666071c8137e9ff61190de7f 0 0 0 0 0  
1484 1484 20200831 MP 56 13484   13540   4         29 C 8/26/2020 23:49 2020-08-26T23:49:00Z 08/26 19:49 2 4 2020-08-26T23:49:00Z 17626     56 2     13540                     69 0 0 13540 posNeg 0 13540 0 0 956be80c3da302194d3265e03df8add973ddfdd0 0 0 0 0 0  
1509 1509 20200831 WA 74320 1387034   1461354 340 6740     51     B 8/30/2020 02:59 2020-08-30T02:59:00Z 08/29 22:59 1905 6740 2020-08-30T02:59:00Z       74320 1905   1461354                       53 0 0 1461354 posNeg 0 1461354 0 0 f41220bd18446de28a1cd1ae260590f686f1b410 0 0 0 0 0  
1516 1516 20200830 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 ce7b74310cafa44752eb4f0e5b23a30c760ffe5d 0 0 0 0 0  
1520 1520 20200830 CT 52495 1075011   1127506 60 11180         8967 B 8/27/2020 18:30 2020-08-27T18:30:00Z 08/27 14:30 4465 11180 2020-08-27T18:30:00Z 1125398     50387 3579 886                         9 0 0 1127506 posNeg 0 1127506 0 0 9113f428caccd38cf1ca3b0234072849914b409b 0 0 0 0 0  
1525 1525 20200830 GU 1347 36113   37460 36   4       488 A+ 8/29/2020 05:15 2020-08-29T05:15:00Z 08/29 01:15 10   2020-08-29T05:15:00Z 36916     1339       37452 158 2                 66 0 0 37460 posNeg 0 37460 0 0 f7e4dbecc14b41a70e44ed66ed8c11c680fb632f 0 0 0 0 0  
1531 1531 20200830 KS 41048 362099   403147 328 2278 96 616 31 206 1658 A+ 8/28/2020 10:00 2020-08-28T10:00:00Z 08/28 06:00 443 2278 2020-08-28T10:00:00Z               403147                     20 0 0 403147 posNeg 0 403147 0 0 958a86e345846dfe76d20c19140fc0c4dadc64e8 0 0 0 0 0  
1532 1532 20200830 KY 48032 768082   811589 570 4560 149 1379     10328 B 8/30/2020 00:00 2020-08-30T00:00:00Z 08/29 20:00 930 4560 2020-08-30T00:00:00Z 811589     43901 921 9     46781               13441   21 455 0 816114 posNeg 0 816114 9 0 a33bfdaf0089fd975b30e155b934cf58c5ce1ab7 0 0 0 0 0  
1572 1572 20200829 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 ace3adead0e717a1908206d95a6a168ac0c5208b 0 0 0 0 0  
1576 1576 20200829 CT 52495 1075011   1127506 60 11180         8967 B 8/27/2020 20:30 2020-08-27T20:30:00Z 08/27 16:30 4465 11180 2020-08-27T20:30:00Z 1125398     50387 3579 886                         9 0 0 1127506 posNeg 0 1127506 0 0 42eabfed932c25c9a9f7729425b87a592b6c2520 0 0 0 0 0  
1587 1587 20200829 KS 41048 362099   403147 328 2278 96 616 31 206 1658 A+ 8/28/2020 10:00 2020-08-28T10:00:00Z 08/28 06:00 443 2278 2020-08-28T10:00:00Z               403147                     20 0 0 403147 posNeg 0 403147 0 0 ae5ab9fbbd052a441bacc2be6fefb4349fd09ee0 0 0 0 0 0  
1589 1589 20200829 LA 146944 1682235   1829179 900       141   127918 A 8/28/2020 13:00 2020-08-28T13:00:00Z 08/28 09:00 4904   2020-08-28T13:00:00Z       146243 4741 163   1828478                     22 0 0 1829179 posNeg 0 1829179 0 0 d96e71efa08dd9d74213e01fb5174a918cbc71d7 0 0 0 0 0  
1593 1593 20200829 MI 111136 2572738   2683874 669   184   93   76151 A+ 8/29/2020 00:00 2020-08-29T00:00:00Z 08/28 20:00 6712   2020-08-29T00:00:00Z 2749406 142390 2572738 100699 6446 266     256585                   26 0 0 2683874 posNeg 0 2683874 0 0 a5e25e87942949c0706b2fb7fd9221ec591032da 0 0 0 0 0  
1628 1628 20200828 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 bd007bf503cf21da89c9fd0e523fe8e68ef9e187 0 0 0 0 0  
1652 1652 20200828 MP 54 13486   13540   4         29 D 8/26/2020 23:49 2020-08-26T23:49:00Z 08/26 19:49 2 4 2020-08-26T23:49:00Z 17626     54 2     13540                     69 0 0 13540 posNeg 0 13540 0 0 ff1a8404afb984304eb95c1436e2d07c75e6c5bf 0 0 0 0 0  
1684 1684 20200827 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 c6b2cab54df3e413abedb75e185c329fb41c667b 0 0 0 0 0  
1699 1699 20200827 KS 39937 355160   395097 262 2226 76 603 25 206 1624 A+ 8/26/2020 10:00 2020-08-26T10:00:00Z 08/26 06:00 437 2226 2020-08-26T10:00:00Z               395097                     20 0 0 395097 posNeg 0 395097 0 0 f877d7f0b9f58b25814816de71e3aa8dd54ab0de 0 0 0 0 0  
1730 1730 20200827 VA 115458 1392084 349 1502521 1174 15938 264   148   14764 A+ 8/26/2020 17:00 2020-08-26T17:00:00Z 08/26 13:00 2515 15938 2020-08-26T17:00:00Z   134326   110437 2382 133 1502521                       51 0 0 1507891 posNeg 0 1507542 0 86 ecf8dbcafcbc63e22390bbcc22b3a62ca4079666 0 0 0 0 0  
1740 1740 20200826 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 aac13db6ec3c1cfe1cf1996b28556c8c7987084f 0 0 0 0 0  
1764 1764 20200826 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 0bf683fc6f56b4f97f9ae354bf75743a9a8319fa 0 0 0 0 0  
1795 1795 20200825 AR 57374 616810   673704 442 4013     108 514 51351 A 8/25/2020 14:36 2020-08-25T14:36:00Z 08/25 10:36 711 4013 2020-08-25T14:36:00Z 673704   616810 57374                         7090 1085 5 480 0 674184 posNeg 0 674184 15 51 36f01300cc76ad3dde005f10d61d0eae176f675d 0 0 0 0 0  
1796 1796 20200825 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 17628746dfe619ea73b6c7ebdea57a4cea7b032d 0 0 0 0 0  
1811 1811 20200825 KS 38401 348556   386957 189 2183 64 590 22 205 1535 A+ 8/24/2020 10:00 2020-08-24T10:00:00Z 08/24 06:00 426 2183 2020-08-24T10:00:00Z               386957                     20 0 0 386957 posNeg 0 386957 0 0 eb965d33638fe6336d4e26520de83737d8fc0699 0 0 0 0 0  
1820 1820 20200825 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 ed246f0f20ccdce0111fb372bcfeae07550195a8 0 0 0 0 0  
1845 1845 20200825 WA 71681 1308369   1380050 354 6542     37     B 8/24/2020 02:59 2020-08-24T02:59:00Z 08/23 22:59 1867 6542 2020-08-24T02:59:00Z       71681 1867   1380050                       53 0 0 1380050 posNeg 0 1380050 4 12 303de170333be5fbbb263e525562f3a9f1b467ae 0 0 0 0 0  
1852 1852 20200824 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 4f0106743bce29e4b2be1e0ed425a249b04eac22 0 0 0 0 0  
1876 1876 20200824 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 8ddda8a06e3cf9b36b6724bdb97f35971d13f7be 0 0 0 0 0  
1908 1908 20200823 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 cab50c36423df76c89e980f16a7e67f16f338caf 0 0 0 0 0  
1912 1912 20200823 CT 51519 970851   1022370 54 11087         8893 B 8/20/2020 20:30 2020-08-20T20:30:00Z 08/20 16:30 4460 11087 2020-08-20T20:30:00Z 1020328     49477 3574 886                         9 0 0 1022370 posNeg 0 1022370 0 0 18a08f7fde299d67e91e973fdba34e910b46e0c4 0 0 0 0 0  
1923 1923 20200823 KS 36856 329459   366315 296 2159 89 584 24 203 1520 A+ 8/21/2020 10:00 2020-08-21T10:00:00Z 08/21 06:00 419 2159 2020-08-21T10:00:00Z               366315                     20 0 0 366315 posNeg 0 366315 0 0 5aa3efe9379675bc966f1d90d691cc5500a421ed 0 0 0 0 0  
1924 1924 20200823 KY 43529 706202   745270 590 4362 166 1340     9448 B 8/23/2020 00:00 2020-08-23T00:00:00Z 08/22 20:00 881 4362 2020-08-23T00:00:00Z 745270     40181 875 6     45988               11940   21 1264 0 749731 posNeg 0 749731 17 0 4e379ff102e7f4985c4cf0502d3fdd2c280ed567 0 0 0 0 0  
1926 1926 20200823 MA 125360 1428313   2064529 315 12256 50   20   102205 A+ 8/22/2020 10:00 2020-08-22T10:00:00Z 08/22 06:00 8921 12256 2020-08-22T10:00:00Z 2064529 152852   115850 8690 231   1544163       108343     74606       25 0 0 1553673 totalTestsViral 0 1553673 0 0 86c764f78937d52c58de3331e9fa1a9fb0145680 0 0 0 0 0  
1932 1932 20200823 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 b5fefa2da2987cc3665ab46349aa00b74f5c7519 0 0 0 0 0  
1955 1955 20200823 VI 960 13358 101 14318             655 C 8/21/2020 22:18 2020-08-21T22:18:00Z 08/21 18:18 10   2020-08-21T22:18:00Z 14419       10                           78 0 0 14419 posNeg 0 14318 0 0 41c0b3743465038311df5f092507ef824afe7118 0 0 0 0 0  
1963 1963 20200822 AR 56199 602939   658591 492 3908     108 502 49764 A 8/22/2020 00:00 2020-08-22T00:00:00Z 08/21 20:00 674 3908 2020-08-22T00:00:00Z 658591   602939 56199                         7090 1085 5 547 0 659138 posNeg 0 659138 11 52 839104f38af1c28b21c0ef1e2998891fd32999dc 0 0 0 0 0  
1964 1964 20200822 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 f640c36732d354d6976e889445d31dbd7f1c03dc 0 0 0 0 0  
1968 1968 20200822 CT 51519 970851   1022370 54 11087         8893 B 8/20/2020 20:30 2020-08-20T20:30:00Z 08/20 16:30 4460 11087 2020-08-20T20:30:00Z 1020328     49477 3574 886                         9 0 0 1022370 posNeg 0 1022370 0 0 0158e4aa7d1e65db98a063e7b8f0aa7c39f2cf60 0 0 0 0 0  
1973 1973 20200822 GU 767 30749   31516 14   3       394 A 8/21/2020 08:15 2020-08-21T08:15:00Z 08/21 04:15 7   2020-08-21T08:15:00Z 31506     759       31508 155 2                 66 0 0 31516 posNeg 0 31516 0 0 40cddf3fbda192445c8778d3ee2db2d85a66e1c9 0 0 0 0 0  
1979 1979 20200822 KS 36856 329459   366315 296 2159 89 584 24 203 1520 A+ 8/21/2020 10:00 2020-08-21T10:00:00Z 08/21 06:00 419 2159 2020-08-21T10:00:00Z               366315                     20 0 0 366315 posNeg 0 366315 0 0 2a6137e9881ace0cd62300fdd8edbfe57424a025 0 0 0 0 0  
1980 1980 20200822 KY 42265 706202   745270 590 4362 166 1340     9448 B 8/21/2020 00:00 2020-08-21T00:00:00Z 08/20 20:00 864 4362 2020-08-21T00:00:00Z 745270     39068 858 6     45988               11940   21 0 0 748467 posNeg 0 748467 0 0 2897e20e4eb2912ed2b0bf4ceb0798ed2adb34b2 0 0 0 0 0  
1981 1981 20200822 LA 141720 1597087   1738807 1051       172   118120 A 8/21/2020 13:00 2020-08-21T13:00:00Z 08/21 09:00 4687   2020-08-21T13:00:00Z       141720 4546 141   1738807                     22 0 0 1738807 posNeg 0 1738807 0 0 42af208aaab721a0cbdbadcfdad94071053be1ed 0 0 0 0 0  
1988 1988 20200822 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 821f9beeecb7d6c39079ca0da688becebb3bf69e 0 0 0 0 0  
2018 2018 20200821 AL 112770 784330   891813 1168 13330   1348   734 44684 B 8/21/2020 11:00 2020-08-21T11:00:00Z 08/21 07:00 1990 13330 2020-08-21T11:00:00Z 891813     107804 1921 69                         1 321 0 897100 posNeg 0 897100 16 0 7d1844b6611006e86a7a392290b0bac9def5c3ff 0 0 0 0 0  
2020 2020 20200821 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 442f7b8d2753c777a4c1efd773f4ea05ebed9b9b 0 0 0 0 0  
2030 2030 20200821 HI 5844 162828   168672 165 317 29   19   2031 C 8/20/2020 23:24 2020-08-20T23:24:00Z 08/20 19:24 45 317 2020-08-20T23:24:00Z 219986             171184                     15 0 0 168672 posNeg 0 168672 0 0 32cd9e6735e1e6971870a9763b8f54a74e1fda63 0 0 0 0 0  
2041 2041 20200821 MI 104618 2321084   2425702 646   173   95   67778 A+ 8/20/2020 00:00 2020-08-20T00:00:00Z 08/19 20:00 6634   2020-08-20T00:00:00Z 2455187 134103 2321084 94697 6368 266     243222                   26 0 0 2425702 posNeg 0 2425702 0 0 6f0c2452627fb74ce268abcb445926b607f29719 0 0 0 0 0  
2044 2044 20200821 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 3edfec6d35750f0d2ee8d31d829606dab1dd0e1b 0 0 0 0 0  
2050 2050 20200821 NH 7050 182632   290010 11 710   220     6367 B 8/20/2020 09:00 2020-08-20T09:00:00Z 08/20 05:00 428 710 2020-08-20T09:00:00Z 290010     7050       189682 29490     28924             33 0 0 189682 posNeg 0 189682 0 0 b084aa4e38930ed3120fce2fcc9584c7b3b7e74f 0 0 0 0 0  
2076 2076 20200820 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 253eb739540d6dbaf16c30e7466db850d97a06ee 0 0 0 0 0  
2091 2091 20200820 KS 35890 323950   359840 300 2090 88 567 26 202 1472 A+ 8/19/2020 10:00 2020-08-19T10:00:00Z 08/19 06:00 411 2090 2020-08-19T10:00:00Z               359840                     20 0 0 359840 posNeg 0 359840 0 0 2eb6b6b4ad755aa63d7035e1ec079e68a5c10b32 0 0 0 0 0  
2132 2132 20200819 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 1225ed95030e2d45094d43c0baec361e076bae4b 0 0 0 0 0  
2156 2156 20200819 MP 54 12866   12920   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12920 posNeg 0 12920 0 0 6a24ee889d9d9d0b7758a111995fa1eff8b893f1 0 0 0 0 0  
2188 2188 20200818 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 e15cbe743620ba84d77003b1c7a5b6cc567aadb9 0 0 0 0 0  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [states_daily_4pm_et] (
   [date] INTEGER,
   [state] TEXT,
   [positive] INTEGER,
   [negative] INTEGER,
   [pending] TEXT,
   [totalTestResults] INTEGER,
   [hospitalizedCurrently] TEXT,
   [hospitalizedCumulative] TEXT,
   [inIcuCurrently] TEXT,
   [inIcuCumulative] TEXT,
   [onVentilatorCurrently] TEXT,
   [onVentilatorCumulative] TEXT,
   [recovered] TEXT,
   [dataQualityGrade] TEXT,
   [lastUpdateEt] TEXT,
   [dateModified] TEXT,
   [checkTimeEt] TEXT,
   [death] INTEGER,
   [hospitalized] TEXT,
   [dateChecked] TEXT,
   [totalTestsViral] TEXT,
   [positiveTestsViral] TEXT,
   [negativeTestsViral] TEXT,
   [positiveCasesViral] TEXT,
   [deathConfirmed] TEXT,
   [deathProbable] TEXT,
   [totalTestEncountersViral] TEXT,
   [totalTestsPeopleViral] TEXT,
   [totalTestsAntibody] TEXT,
   [positiveTestsAntibody] TEXT,
   [negativeTestsAntibody] TEXT,
   [totalTestsPeopleAntibody] TEXT,
   [positiveTestsPeopleAntibody] TEXT,
   [negativeTestsPeopleAntibody] TEXT,
   [totalTestsPeopleAntigen] TEXT,
   [positiveTestsPeopleAntigen] TEXT,
   [totalTestsAntigen] TEXT,
   [positiveTestsAntigen] TEXT,
   [fips] INTEGER,
   [positiveIncrease] INTEGER,
   [negativeIncrease] INTEGER,
   [total] INTEGER,
   [totalTestResultsSource] TEXT,
   [totalTestResultsIncrease] INTEGER,
   [posNeg] INTEGER,
   [deathIncrease] INTEGER,
   [hospitalizedIncrease] INTEGER,
   [hash] TEXT,
   [commercialScore] INTEGER,
   [negativeRegularScore] INTEGER,
   [negativeScore] INTEGER,
   [positiveScore] INTEGER,
   [score] INTEGER,
   [grade] TEXT
);