states_daily_4pm_et

Table actions

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

11,578 rows sorted by negativeIncrease

✎ 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
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  
1204 1204 20200905 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 1 0 13542 posNeg 1 13542 0 0 6b3c8da17601c70b994000e32f6a15e806c32556 0 0 0 0 0  
1211 1211 20200905 NJ 193747 2771300   2965047 389 22790 69   31   34112 A+ 9/5/2020 00:00 2020-09-05T00:00:00Z 09/04 20:00 15992 22790 2020-09-05T00:00:00Z 2964722     193747 14202 1790                         34 325 0 2965047 posNeg 325 2965047 7 20 5fd19157348d2a22aa7874a0c71f55cd3112d49a 0 0 0 0 0  
1219 1219 20200905 PR 34492 305972   340464 369   76   67     C 9/5/2020 00:00 2020-09-05T00:00:00Z 09/04 20:00 464   2020-09-05T00:00:00Z 310546 7002 303412 16243 309 155       18249                 72 251 0 340464 posNeg 251 340464 9 0 bd424757482add7bb555b28f4012dc10a0c54342 0 0 0 0 0  
1232 1232 20200905 WY 4006 74312   78318 15 223         3404 A 9/5/2020 11:21 2020-09-05T11:21:00Z 09/05 07:21 42 223 2020-09-05T11:21:00Z 111391 3230 108160 3386       77685                     56 17 0 78318 posNeg 17 78318 0 0 a6a4f5e5244ccdb84f2b6e224dcea45e467d7f95 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  
1261 1261 20200904 MS 85939 501465   587404 789 5326 178   115   67918 A+ 9/3/2020 00:00 2020-09-03T00:00:00Z 09/02 20:00 2558 5326 2020-09-03T00:00:00Z 582297     81530 2394 164     27057 95             32271   28 823 0 587404 posNeg 823 587404 22 0 6ac01c932e1ec3af15cb6ed1bd81e4a40f870428 0 0 0 0 0  
1275 1275 20200904 PR 34241 305972   340213 382   78   60     C 9/4/2020 00:00 2020-09-04T00:00:00Z 09/03 20:00 455   2020-09-04T00:00:00Z 310546 7002 303412 16101 302 153       18140                 72 43 0 340213 posNeg 43 340213 7 0 e208268e278221b8a0081c8728d83a71174a9d03 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  
1331 1331 20200903 PR 34198 305972   340170 349   73   57     C 9/3/2020 00:00 2020-09-03T00:00:00Z 09/02 20:00 448   2020-09-03T00:00:00Z 310546 7002 303412 16069 296 152       18129                 72 195 0 340170 posNeg 195 340170 5 0 85b099cbff70fe17a4b62c6a86ed74e33005664b 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  
1387 1387 20200902 PR 34003 305972   339975 373   71   53     C 9/2/2020 00:00 2020-09-02T00:00:00Z 09/01 20:00 443   2020-09-02T00:00:00Z 310546 7002 303412 15942 293 150       18061                 72 582 0 339975 posNeg 582 339975 8 0 cce409963061dd365612c154ebac2b510fc5f1e8 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  
1428 1428 20200901 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 1 0 13541 posNeg 1 13541 0 0 29df9ccd3c08f0f2abac3816e10084cc5a034b82 0 0 0 0 0  
1443 1443 20200901 PR 33421 305972   339393 392   71   51     B 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 435   2020-09-01T00:00:00Z 310546 7002 303412 15584 288 147       17837                 72 222 0 339393 posNeg 222 339393 1 0 21a9ecfe1a882b2a40902a762527f29f437dd4b8 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  
1496 1496 20200831 OK 58733 806545 7165 865278 570 4821 214       49184 A+ 8/31/2020 00:00 2020-08-31T00:00:00Z 08/30 20:00 800 4821 2020-08-31T00:00:00Z 874676 66512 806545 58733         68964 3006                 40 713 0 872443 posNeg 713 865278 1 7 a986f0bf769c9f8f4a62152b5c719fbd2e9bf564 0 0 0 0 0  
1499 1499 20200831 PR 33199 305972   339171 383   65   50     B 8/31/2020 00:00 2020-08-31T00:00:00Z 08/30 20:00 434   2020-08-31T00:00:00Z 310546 7002 303412 15476 287 147       17723                 72 351 0 339171 posNeg 351 339171 0 0 84de08cad35156260237eb7fd8ac6060a0ee8b8d 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  
1541 1541 20200830 MS 82676 486488   569164 819 5300 215   111   62707 A+ 8/30/2020 00:00 2020-08-30T00:00:00Z 08/29 20:00 2441 5300 2020-08-30T00:00:00Z 564933     78904 2294 147     25255 95             30859   28 647 0 569164 posNeg 647 569164 14 0 7843e7cba5068f716706a9faaad00e47000026cf 0 0 0 0 0  
1544 1544 20200830 ND 11696 188263   454409 68 554 17 147     9079 A 8/30/2020 01:59 2020-08-30T01:59:00Z 08/29 21:59 118 554 2020-08-30T01:59:00Z 469333     11696 114 4 454409 199722 8565 334 8231               38 221 0 199959 totalTestEncountersViral 3551 199959 0 3 2637a2b9c4374ef21d69689fc4dd41ca3674e99f 0 0 0 0 0  
1552 1552 20200830 OK 58020 806545 7165 864565 570 4814 214       48933 A+ 8/30/2020 00:00 2020-08-30T00:00:00Z 08/29 20:00 799 4814 2020-08-30T00:00:00Z 874676 66512 806545 58020         68964 3006                 40 667 0 871730 posNeg 667 864565 2 20 e6075f01f9948e6a8e5d9140aeafdf2e2b62c4ac 0 0 0 0 0  
1555 1555 20200830 PR 32848 305972   338820 365   63   46     B 8/30/2020 00:00 2020-08-30T00:00:00Z 08/29 20:00 434   2020-08-30T00:00:00Z 310546 7002 303412 15229 287 147       17619                 72 298 0 338820 posNeg 298 338820 6 0 fab20f4a0ccc8866e6b6f19fcaf0547ab1ddfeca 0 0 0 0 0  
1568 1568 20200830 WY 3820 71473   75293 15 215         3136 A 8/30/2020 12:02 2020-08-30T12:02:00Z 08/30 08:02 37 215 2020-08-30T12:02:00Z 105845 3069 10277 3245       74669                     56 36 0 75293 posNeg 36 75293 0 0 4d489a93d7c99f00810969a87eabb0280402397b 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  
1596 1596 20200829 MP 56 13486   13542   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 2 0 13542 posNeg 2 13542 0 0 ff05f1c1c990a501fb5325c94904199d66c8a716 0 0 0 0 0  
1611 1611 20200829 PR 32550 305972   338522 365   65   44     B 8/29/2020 00:00 2020-08-29T00:00:00Z 08/28 20:00 428   2020-08-29T00:00:00Z 310546 7002 303412 14986 283 145       17564                 72 562 0 338522 posNeg 562 338522 4 0 71b1a06a94cec404ee46d7815faeeb278e1c4825 0 0 0 0 0  
1624 1624 20200829 WY 3784 71473   75257 15 215         3116 A 8/29/2020 12:59 2020-08-29T12:59:00Z 08/29 08:59 37 215 2020-08-29T12:59:00Z 105845 3069 10277 3210       74669                     56 21 0 75257 posNeg 21 75257 0 0 e564a229e25e5f2f283883e55c92e792ed9db870 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  
1659 1659 20200828 NJ 190971 2558223   2749194 436 22586 83   30   33778 A+ 8/28/2020 00:00 2020-08-28T00:00:00Z 08/27 20:00 15940 22586 2020-08-28T00:00:00Z 2748836     190971 14150 1790                         34 358 0 2749194 posNeg 358 2749194 9 26 11a8ff6e46873098fdaa8e310b475304d1676d8c 0 0 0 0 0  
1667 1667 20200828 PR 31988 305972   337960 409   72   51     B 8/28/2020 00:00 2020-08-28T00:00:00Z 08/27 20:00 424   2020-08-28T00:00:00Z 310546 7002 303412 14726 280 144       17262                 72 605 0 337960 posNeg 605 337960 12 0 41da9668f92677ca45f7519611ceb7301cc67e89 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  
1723 1723 20200827 PR 31383 305972   337355 403   74   41     B 8/27/2020 00:00 2020-08-27T00:00:00Z 08/26 20:00 412   2020-08-27T00:00:00Z 310546 7002 303412 14469 270 142       16914                 72 639 0 337355 posNeg 639 337355 8 0 5908d5ba150a6c6bd170fb45193f02e2721aabec 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  
1779 1779 20200826 PR 30744 305972   336716 397   62   44     B 8/26/2020 00:00 2020-08-26T00:00:00Z 08/25 20:00 404   2020-08-26T00:00:00Z 310546 7002 303412 14010 263 141       16734                 72 24 0 336716 posNeg 24 336716 9 0 5f16db8ea5eadf9b48db6d22334aed94ffe26102 0 0 0 0 0  
1792 1792 20200826 WY 3684 66894   70578 17 213         3028 B 8/26/2020 16:28 2020-08-26T16:28:00Z 08/26 12:28 37 213 2020-08-26T16:28:00Z 104236 3127 101108 3135       69983                     56 50 0 70578 posNeg 50 70578 0 0 e3069031c109d5218e211a77e1ebce67d572e672 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  
1799 1799 20200825 CO 55341 594857   947645 243 6845         5841 A 8/24/2020 01:59 2020-08-24T01:59:00Z 08/23 21:59 1824 6845 2020-08-24T01:59:00Z       51676     947645 673913 154075 10639 143436               8 198 0 650198 totalTestEncountersViral 9049 650198 9 4 c25d9a93e3b1b03b5e83b75d55ad152570db376c 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  
1835 1835 20200825 PR 30720 305972   336692 391   67   43     B 8/25/2020 00:00 2020-08-25T00:00:00Z 08/24 20:00 395   2020-08-25T00:00:00Z 310546 7002 303412 13992 256 139       16728                 72 102 0 336692 posNeg 102 336692 5 0 019c297579720e528cfa7b3d708f377e3a232be3 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  
1850 1850 20200824 AL 116710 806609   916364 1149 13793   1391   754 44684 B 8/24/2020 11:00 2020-08-24T11:00:00Z 08/24 07:00 2024 13793 2020-08-24T11:00:00Z 916364     110769 1950 74                         1 1650 0 923319 posNeg -339 923319 11 291 5ad13866d95b633a1e1d014037e6a4e501ce7c4a 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  
1855 1855 20200824 CO 55143 594857   938596 225 6841         5823 A 8/23/2020 01:59 2020-08-23T01:59:00Z 08/22 21:59 1815 6841 2020-08-23T01:59:00Z       51505     938596 668994 153659 10612 143047               8 260 0 650000 totalTestEncountersViral 8444 650000 0 10 2aa9117da60673fe8bd8fe2c706779f426a741fc 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  
1888 1888 20200824 OK 53522 759335   812857 578 4431 237       44660 A+ 8/24/2020 00:00 2020-08-24T00:00:00Z 08/23 20:00 730 4431 2020-08-24T00:00:00Z 821289 60433 759335 53522         67322 2856                 40 357 0 812857 posNeg 357 812857 4 9 ce4333499b87e08b2648967f76b58728a7b539d0 0 0 0 0 0  
1891 1891 20200824 PR 30618 305972   336590 363   71   42     B 8/24/2020 00:00 2020-08-24T00:00:00Z 08/23 20:00 390   2020-08-24T00:00:00Z 310546 7002 303412 13922 251 139       16696                 72 722 0 336590 posNeg 722 336590 0 0 e33ad35c6f3d2df299c1a2035c42c53f15293f78 0 0 0 0 0  
1896 1896 20200824 TX 580384 4090491   4670875 5019   1809       457182 A 8/24/2020 18:35 2020-08-24T18:35:00Z 08/24 14:35 11395   2020-08-24T18:35:00Z 4668028     580384         344218 27726             21648 3151 48 2847 0 4670875 posNeg 2847 4670875 25 0 bdf2127d6d27e01cfdca0dd2012d64fbafea54d9 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  
1911 1911 20200823 CO 54883 594857   930152 258 6831         5804 A 8/22/2020 01:59 2020-08-22T01:59:00Z 08/21 21:59 1815 6831 2020-08-22T01:59:00Z       51258     930152 663781 153148 10575 142573               8 297 0 649740 totalTestEncountersViral 11226 649740 0 23 a8e1b7ff95369b44fe35a5306e5ec55b570b205a 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  
1933 1933 20200823 MS 77894 456354   534248 982 5149 259   148   56577 A+ 8/22/2020 00:00 2020-08-22T00:00:00Z 08/21 20:00 2240 5149 2020-08-22T00:00:00Z 530974     75176 2139 101     22862 95                 28 626 0 534248 posNeg 626 534248 3 0 0e22e835a750071e95a8ab31196a08f2e4b08d11 0 0 0 0 0  
1939 1939 20200823 NJ 189494 2459504   2648998 411 22448 72   27   33615 A+ 8/23/2020 00:00 2020-08-23T00:00:00Z 08/22 20:00 15907 22448 2020-08-23T00:00:00Z 2648740     189494 14117 1790                         34 258 0 2648998 posNeg 258 2648998 3 3 12851cb3cd838916b0677a8e50e3b00e4914a764 0 0 0 0 0  
1940 1940 20200823 NM 24302 680860   705162 68 3030         11458 B 8/22/2020 17:49 2020-08-22T17:49:00Z 08/22 13:49 743 3030 2020-08-22T17:49:00Z 704955     24302                             35 207 0 705162 posNeg 207 705162 4 12 6d7045474249ac2275a5df4789d2d8746b8aab28 0 0 0 0 0  
1944 1944 20200823 OK 53165 759335   812500 578 4422 237       44409 A+ 8/23/2020 00:00 2020-08-23T00:00:00Z 08/22 20:00 726 4422 2020-08-23T00:00:00Z 821289 60433 759335 53165         67322 2856                 40 566 0 812500 posNeg 566 812500 1 54 fc51866688a7b62a177be7370b6f17992c14b6e1 0 0 0 0 0  
1947 1947 20200823 PR 29896 305972   335868 370   66   36     B 8/23/2020 00:00 2020-08-23T00:00:00Z 08/22 20:00 390   2020-08-23T00:00:00Z 310546 7002 303412 13477 251 139       16419                 72 319 0 335868 posNeg 319 335868 9 0 f29da4d10842ce4f5c2b08db023eb830a17de8ae 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  
1960 1960 20200823 WY 3579 61313   64892 19 207         2896 B 8/23/2020 11:32 2020-08-23T11:32:00Z 08/23 07:32 37 207 2020-08-23T11:32:00Z 93231 2983 90247 3046       64307                     56 36 0 64892 posNeg 36 64892 0 4 7081c2bc866845cbea02fc832d3da0a2037f255f 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  
1967 1967 20200822 CO 54586 594857   918926 236 6808         5791 A 8/21/2020 01:59 2020-08-21T01:59:00Z 08/20 21:59 1815 6808 2020-08-21T01:59:00Z       50967     918926 657852 152413 10514 141899               8 356 0 649443 totalTestEncountersViral 12233 649443 0 11 d3ed50e06dd7d49de759ebdc3ed86fe26edd9a92 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  
2003 2003 20200822 PR 29577 305972   335549 401   67   41     B 8/22/2020 00:00 2020-08-22T00:00:00Z 08/21 20:00 381   2020-08-22T00:00:00Z 310546 7002 303412 13282 246 135       16295                 72 731 0 335549 posNeg 731 335549 7 0 00dc355726a7c27ec33af0791002e134b98d08a3 0 0 0 0 0  
2016 2016 20200822 WY 3543 61313   64856 19 203         2879 B 8/22/2020 12:00 2020-08-22T12:00:00Z 08/22 08:00 37 203 2020-08-22T12:00:00Z 93231 2983 90247 3009       64307                     56 19 0 64856 posNeg 19 64856 0 0 83ae1a0d88b1e2e10f6b0cff869439c027955aec 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  

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
);