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
356 356 20200920 KY 61542 993670   1047995 496 5026 114 1483     11237 B 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 1111 5026 2020-09-20T00:00:00Z 1047995     54695 1102 9     51457               19403   21 436 0 1055212 posNeg 0 1055212 3 0 02d95d8d51afa2b993ec89f17642f42fd54edbfd 0 0 0 0 0  
361 361 20200920 MI 128087 3190382   3318469 557   150   64   90216 A+ 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 6969   2020-09-19T00:00:00Z 3353686 163304 3190382 115870 6653 316     283882                   26 0 0 3318469 posNeg 0 3318469 0 0 696c50a64c4e55f0a730a5edf8659e1159f2ed4a 0 0 0 0 0  
364 364 20200920 MP 68 14316   14384   4         29 D 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 2 4 2020-09-20T00:00:00Z 18915     68 2     14375                     69 6 0 14384 posNeg 6 14384 0 0 03ba5cc13165089a665479e9cf4b938d0355bf05 0 0 0 0 0  
365 365 20200920 MS 93364 609799   703163 630 5499 171   87   78971 A+ 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 2810 5499 2020-09-19T00:00:00Z 696618     87045 2591 219     36912 95             48844   28 277 0 703163 posNeg 277 703163 1 0 54d1c5ca176831bd9a292257c1fed2ac0e4a2071 0 0 0 0 0  
376 376 20200920 OK 76807 995697 8878 1072504 522 5843 222       64467 A+ 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 946 5843 2020-09-20T00:00:00Z 1084302 86886 995697 76807         76497 3764                 40 1003 0 1081382 posNeg 1003 1072504 3 0 436754c426827aa1a4613bda2c292e1679a2323a 0 0 0 0 0  
379 379 20200920 PR 41838 305972   347810 384   64   43     C 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 608   2020-09-20T00:00:00Z 310546 7002 303412 20069 438 170       21769                 72 845 0 347810 posNeg 845 347810 3 0 8731a0ba2ca2d07b1a744a979429e312de5d6ada 0 0 0 0 0  
392 392 20200920 WY 4871 87560   92431 16 243         4111 B 9/20/2020 11:36 2020-09-20T11:36:00Z 09/20 07:36 49 243 2020-09-20T11:36:00Z 141795 4112 137682 4124       91569                     56 91 0 92431 posNeg 91 92431 0 1 9cb70b4c22b37559f6d01bbea1fcfd6677e8e770 0 0 0 0 0  
395 395 20200919 AR 75160 794097   866435 372 4963 193   74 628 66003 A+ 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 1173 4963 2020-09-19T00:00:00Z 866435   794097 73141 1025 148                 9587 2010 21856 3300 5 1078 0 869257 posNeg 0 869257 0 31 9c340c3ac95d033197a7ca71e0b0f17b064f0327 0 0 0 0 0  
396 396 20200919 AS 0 1571   1571               D 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 678ba0c96c17a95db48c29d3e95785ec49852061 0 0 0 0 0  
400 400 20200919 CT 55527 1366621   1422148 77 11447         9204 B 9/17/2020 20:30 2020-09-17T20:30:00Z 09/17 16:30 4492 11447 2020-09-17T20:30:00Z 1419839     53218 3597 895                         9 0 0 1422148 posNeg 0 1422148 0 0 37f86cb35187ab8b462bed2e12880222ce795933 0 0 0 0 0  
411 411 20200919 KS 52285 422464   474749 286 2671 79 734 23 230 1950 A+ 9/18/2020 10:00 2020-09-18T10:00:00Z 09/18 06:00 596 2671 2020-09-18T10:00:00Z               474749                     20 0 0 474749 posNeg 0 474749 0 0 fbece70742f3b6402b0b82185e763bf4c9ad12e3 0 0 0 0 0  
413 413 20200919 LA 161322 1985664   2146986 647       104   145570 A 9/18/2020 13:00 2020-09-18T13:00:00Z 09/18 09:00 5340   2020-09-18T13:00:00Z       160283 5172 168   2145947                     22 0 0 2146986 posNeg 0 2146986 0 0 391142daaa1979e017147041a56a46a716e7789a 0 0 0 0 0  
420 420 20200919 MP 62 14316   14378   4         29 D 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 2 4 2020-09-17T00:00:00Z 18915     62 2     14375                     69 0 0 14378 posNeg 0 14378 0 0 c16dbd331a66d39667dae005b93458d850cf470c 0 0 0 0 0  
427 427 20200919 NJ 199309 3093068   3292377 412 23120 89   27   34601 A+ 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 16064 23120 2020-09-19T00:00:00Z 3291916     199309 14273 1791                         34 461 0 3292377 posNeg 461 3292377 3 24 0183b3e185422ff4f1275cee19945352d05c217f 0 0 0 0 0  
435 435 20200919 PR 40993 305972   346965 403   61   39     C 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 605   2020-09-19T00:00:00Z 310546 7002 303412 19807 435 170       21186                 72 1309 0 346965 posNeg 1309 346965 6 0 9ba5f0db56b32a2dfbb3654cd47cbf472fc47e9d 0 0 0 0 0  
443 443 20200919 VI 1242 17712 26 18954             1174 D 9/18/2020 09:31 2020-09-18T09:31:00Z 09/18 05:31 19   2020-09-18T09:31:00Z 18980       19                           78 0 0 18980 posNeg 0 18954 0 0 74c3ad4b5e0bdde6cc102509080792f9d6835342 0 0 0 0 0  
445 445 20200919 WA 81602 1623068   1704670 248 7215     34     B 9/18/2020 02:59 2020-09-18T02:59:00Z 09/17 22:59 2037 7215 2020-09-18T02:59:00Z       81602 2037   1704670                       53 0 0 1704670 posNeg 0 1704670 0 0 09a5a1ca1ac431f57b4278c1cce4978ed0610be0 0 0 0 0 0  
448 448 20200919 WY 4780 87560   92340 16 242         4092 B 9/19/2020 12:08 2020-09-19T12:08:00Z 09/19 08:08 49 242 2020-09-19T12:08:00Z 141795 4112 137682 4039       91569                     56 33 0 92340 posNeg 33 92340 0 2 8ae20c9ed8247904e507a53d7cec0fa4b906a90c 0 0 0 0 0  
452 452 20200918 AS 0 1571   1571               D 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 4953337207aa6ea9f70d3e91b93db3bd67bd2589 0 0 0 0 0  
476 476 20200918 MP 62 14316   14378   4         29 D 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 2 4 2020-09-17T00:00:00Z 18915     62 2     14375                     69 0 0 14378 posNeg 0 14378 0 0 dc26aece47e039aa4d08d4c62a1527bcf0ab05f1 0 0 0 0 0  
477 477 20200918 MS 91935 541497   633432 630 5499 171   87   78971 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 2780 5499 2020-09-17T00:00:00Z 626881     85944 2572 208     29016 95             40904   28 0 0 633432 posNeg 0 633432 0 0 ad1225256fe52935c13c6f76ac4beafd2c39d99f 0 0 0 0 0  
491 491 20200918 PR 39684 305972   345656 435   70   41     C 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 599   2020-09-18T00:00:00Z 310546 7002 303412 19113 430 169       20571                 72 817 0 345656 posNeg 817 345656 11 0 89b44d189958d59156aeb7c469b0cf8758fb99df 0 0 0 0 0  
508 508 20200917 AS 0 1571   1571               D 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 54f9bc2755f89f45c7a1fa08c2b1a68d14fdc849 0 0 0 0 0  
523 523 20200917 KS 50870 413356   464226 278 2616 83 713 21 225 1920 A+ 9/16/2020 10:00 2020-09-16T10:00:00Z 09/16 06:00 586 2616 2020-09-16T10:00:00Z               464226                     20 0 0 464226 posNeg 0 464226 0 0 9774767ad4c7b3cc6016f5b12265f2a8c7df86a6 0 0 0 0 0  
532 532 20200917 MP 62 14316   14378   4         29 D 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 2 4 2020-09-17T00:00:00Z 18915     62 2     14375                     69 1 0 14378 posNeg 1 14378 0 0 9167731bc47435785ac4fa474b8694e9d95c08c8 0 0 0 0 0  
533 533 20200917 MS 91935 541497   633432 622 5499 169   95   78971 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 2780 5499 2020-09-17T00:00:00Z 626881     85944 2572 208     29016 95             40904   28 701 0 633432 posNeg 701 633432 24 0 6b0913ff52f03b1f43bbeb0a9bf94c0cc514456a 0 0 0 0 0  
547 547 20200917 PR 38867 305972   344839 444   68   41     C 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 588   2020-09-17T00:00:00Z 310546 7002 303412 18634 420 168       20233                 72 583 0 344839 posNeg 583 344839 18 0 e0e0cc691f1ab2859ca5e147a3fa79c4b79128f8 0 0 0 0 0  
564 564 20200916 AS 0 1571   1571               D 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 1e432dfcc52e27d75970f4b590b1e74ec5a025a5 0 0 0 0 0  
588 588 20200916 MP 61 14316   14377   4         29 D 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 2 4 2020-09-14T00:00:00Z 18915     61 2     14375                     69 0 0 14377 posNeg 0 14377 0 0 a1fe38f57df76cbef46c807705b1b50386037548 0 0 0 0 0  
603 603 20200916 PR 38284 305972   344256 434   68   40     C 9/16/2020 00:00 2020-09-16T00:00:00Z 09/15 20:00 570   2020-09-16T00:00:00Z 310546 7002 303412 18252 403 167       20032                 72 112 0 344256 posNeg 112 344256 19 0 b5411ffa8e63dcf8a24d01675f9d84ef85706732 0 0 0 0 0  
620 620 20200915 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 2b445be74daf156f41869a55052b390e3d37ee0e 0 0 0 0 0  
635 635 20200915 KS 49899 408482   458381 192 2572 50 703 15 221 1887 A+ 9/14/2020 10:00 2020-09-14T10:00:00Z 09/14 06:00 534 2572 2020-09-14T10:00:00Z               458381                     20 0 0 458381 posNeg 0 458381 0 0 f2f2ff46eba821dc5c314d7e7dbf7ae2764b34b7 0 0 0 0 0  
644 644 20200915 MP 61 14316   14377   4         29 C 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 2 4 2020-09-14T00:00:00Z 18915     61 2     14375                     69 0 0 14377 posNeg 0 14377 0 0 9387a4a66c395a13d58ed5029432aec261f9a217 0 0 0 0 0  
645 645 20200915 MS 90523 535788   626311 667 5499 177   88   78971 A+ 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 2734 5499 2020-09-14T00:00:00Z 620345     84912 2543 191     28852 95             38649   28 505 0 626311 posNeg 505 626311 28 0 9b1a4db4ae97e3a79a70189e1bcea7723ccca9df 0 0 0 0 0  
659 659 20200915 PR 38172 305972   344144 408   65   44     C 9/15/2020 00:00 2020-09-15T00:00:00Z 09/14 20:00 551   2020-09-15T00:00:00Z 310546 7002 303412 18206 385 166       19966                 72 422 0 344144 posNeg 422 344144 9 0 3d765becb06b3749d7c18155f11a32e638b84330 0 0 0 0 0  
676 676 20200914 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 174cf78dc9ab5615d074020dde4ce99fcd28e6de 0 0 0 0 0  
700 700 20200914 MP 61 14316   14377   4         29 C 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 2 4 2020-09-14T00:00:00Z 18915     61 2     14375                     69 1 0 14377 posNeg 1 14377 0 0 01f1be4800c5c7e83e0c006770b49abe9bf4968f 0 0 0 0 0  
712 712 20200914 OK 70223 920176 6306 990399 499 5466 186       59007 A+ 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 905 5466 2020-09-14T00:00:00Z 1000912 79689 920176 70223         74483 3581                 40 869 0 996705 posNeg 869 990399 0 15 b89e6b17d5c03e752a040530e2d46728d06e656b 0 0 0 0 0  
715 715 20200914 PR 37750 305972   343722 414   63   37     C 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 542   2020-09-14T00:00:00Z 310546 7002 303412 17977 376 166       19773                 72 370 0 343722 posNeg 370 343722 3 0 29509b55aba939cf106f0cead8697cb43d3cc8b9 0 0 0 0 0  
732 732 20200913 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 3ae357e9638017e50197c3bf2bd193a2569941a7 0 0 0 0 0  
736 736 20200913 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 ed78ceded1a937ba41234faf6058ae23f55cec18 0 0 0 0 0  
741 741 20200913 GU 1891 41472   43363 50   11       1118 A+ 9/13/2020 03:15 2020-09-13T03:15:00Z 09/12 23:15 26   2020-09-13T03:15:00Z 43011     1891       43363 158 2                 66 0 0 43363 posNeg 0 43363 1 0 b717b6ffe69ebec8ceb54b7ea86a115fe81c77bb 0 0 0 0 0  
747 747 20200913 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 5562750d6f8e4885550c4cbf5520fabab6edfefb 0 0 0 0 0  
748 748 20200913 KY 56945 873807   924342 587 4886 148 1454     10872 B 9/13/2020 00:00 2020-09-13T00:00:00Z 09/12 20:00 1060 4886 2020-09-13T00:00:00Z 924342     51018 1051 9     49234               17381   21 530 0 930752 posNeg 0 930752 3 0 4b8bebff277eb66b8bc8ed52c5dee31df8e48485 0 0 0 0 0  
753 753 20200913 MI 123058 2987552   3110610 627   172   77   85513 A+ 9/12/2020 00:00 2020-09-12T00:00:00Z 09/11 20:00 6911   2020-09-12T00:00:00Z 3144491 156939 2987552 111524 6591 320     268368                   26 0 0 3110610 posNeg 0 3110610 0 0 3b119610e6f62cfa044bd7fb4a7021a53161d0ba 0 0 0 0 0  
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  
757 757 20200913 MS 89874 532919   622793 542 5410 179       74098 A+ 9/12/2020 00:00 2020-09-12T00:00:00Z 09/11 20:00 2697 5410 2020-09-12T00:00:00Z 617161     84451 2514 183     28693 95             38257   28 254 0 622793 posNeg 254 622793 12 0 b7f54ddbbebadca36ff8f2dcdb990c7f4bdf4504 0 0 0 0 0  
768 768 20200913 OK 69354 920176 6306 989530 499 5451 186       58560 A+ 9/13/2020 00:00 2020-09-13T00:00:00Z 09/12 20:00 905 5451 2020-09-13T00:00:00Z 1000912 79689 920176 69354         74483 3581                 40 695 0 995836 posNeg 695 989530 6 27 5eddb6504b6413941413c9b479648a92efedbc59 0 0 0 0 0  
770 770 20200913 PA 143881 1664000   1807881 463       60   117920 A+ 9/13/2020 16:00 2020-09-13T16:00:00Z 09/13 12:00 7837   2020-09-13T16:00:00Z 2535965     139699       1803699                     42 76 0 1807881 posNeg 76 1807881 0 0 f238c580ca547a85b748fac2dbe2751fc1bc3fda 0 0 0 0 0  
771 771 20200913 PR 37380 305972   343352 396   67   50     C 9/13/2020 00:00 2020-09-13T00:00:00Z 09/12 20:00 539   2020-09-13T00:00:00Z 310546 7002 303412 17769 373 166       19611                 72 288 0 343352 posNeg 288 343352 4 0 81f3dd8fc9d87963ce3c80775767a142fd2664b2 0 0 0 0 0  
784 784 20200913 WY 4346 82091   86437 12 228         3768 B 9/13/2020 12:02 2020-09-13T12:02:00Z 09/13 08:02 42 228 2020-09-13T12:02:00Z 126331 3663 122667 3679       85696                     56 49 0 86437 posNeg 49 86437 0 -59 6fe306e430cfdb62e238995887fc1a8a7fa7756e 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  
812 812 20200912 MP 60 14316   14376   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     60 2     14375                     69 1 0 14376 posNeg 1 14376 0 0 262f1490a1ac8cc5d6e7c77c3005c4fd61de9cb7 0 0 0 0 0  
819 819 20200912 NJ 196337 2944898   3141235 462 22950 84   35   34397 A+ 9/12/2020 00:00 2020-09-12T00:00:00Z 09/11 20:00 16028 22950 2020-09-12T00:00:00Z 3140786     196337 14238 1790                         34 449 0 3141235 posNeg 449 3141235 4 32 800e1a024c5f258b6cb0f2567628c8809c402867 0 0 0 0 0  
827 827 20200912 PR 37092 305972   343064 420   71   54     C 9/12/2020 00:00 2020-09-12T00:00:00Z 09/11 20:00 535   2020-09-12T00:00:00Z 310546 7002 303412 17598 370 165       19494                 72 511 0 343064 posNeg 511 343064 12 0 8d367ef4c3a5f83204365b19423c8398b3a13ec5 0 0 0 0 0  
840 840 20200912 WY 4297 82091   86388 12 287         3740 B 9/12/2020 12:22 2020-09-12T12:22:00Z 09/12 08:22 42 287 2020-09-12T12:22:00Z 126331 3663 122667 3635       85696                     56 33 0 86388 posNeg 33 86388 0 60 c11a6c8972311591b03b75d277130b3190882090 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  
883 883 20200911 PR 36581 305972   342553 401   68   52     C 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 523   2020-09-11T00:00:00Z 310546 7002 303412 17357 359 164       19224                 72 302 0 342553 posNeg 302 342553 11 0 7ac233925abe87e974af7b03d23e1028daae47ac 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  
939 939 20200910 PR 36279 305972   342251 421   70   57     C 9/10/2020 00:00 2020-09-10T00:00:00Z 09/09 20:00 512   2020-09-10T00:00:00Z 310546 7002 303412 17248 349 163       19031                 72 772 0 342251 posNeg 772 342251 12 0 fd1b5c7b431ebec99719aebb59b9fdfdfc148c2a 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  
995 995 20200909 PR 35507 305972   341479 400   71   56     C 9/9/2020 00:00 2020-09-09T00:00:00Z 09/08 20:00 500   2020-09-09T00:00:00Z 310546 7002 303412 16789 337 163       18718                 72 3 0 341479 posNeg 3 341479 18 0 eaf36c5da3ff7023c9c12fe55dbf25a62f9a5000 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  
1036 1036 20200908 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 1 0 13543 posNeg 1 13543 0 0 53b32a99df9b81349f8c9e7f038fa5b72c7bc572 0 0 0 0 0  
1048 1048 20200908 OK 65053 860086 5021 925139 472 5137 208       54269 A+ 9/8/2020 00:00 2020-09-08T00:00:00Z 09/07 20:00 854 5137 2020-09-08T00:00:00Z 939500 73487 860086 65053         73173 3453                 40 833 0 930160 posNeg 833 925139 1 24 15120f393bacb22c003c4e27430051e623214ea7 0 0 0 0 0  
1051 1051 20200908 PR 35504 305972   341476 380   81   66     C 9/8/2020 00:00 2020-09-08T00:00:00Z 09/07 20:00 482   2020-09-08T00:00:00Z 310546 7002 303412 16788 319 163       18716                 72 129 0 341476 posNeg 129 341476 5 0 cfebefb39ec0523abe1314f74278b053395bda64 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  
1093 1093 20200907 MS 87130 510921   598051 758 5326 186   111   67918 A+ 9/6/2020 00:00 2020-09-06T00:00:00Z 09/05 20:00 2585 5326 2020-09-06T00:00:00Z 592831     82457 2417 168     27468 95             33480   28 242 0 598051 posNeg 242 598051 1 0 bee906ee60c500c0abe4cae600b62aef7b450f80 0 0 0 0 0  
1104 1104 20200907 OK 64220 860086 5021 924306 472 5113 208       53414 A+ 9/7/2020 00:00 2020-09-07T00:00:00Z 09/06 20:00 853 5113 2020-09-07T00:00:00Z 939500 73487 860086 64220         73173 3453                 40 613 0 929327 posNeg 613 924306 0 8 641f2573eae54393c5c3b7dc28fdc55723d169c6 0 0 0 0 0  
1107 1107 20200907 PR 35375 305972   341347 372   81   72     C 9/7/2020 00:00 2020-09-07T00:00:00Z 09/06 20:00 477   2020-09-07T00:00:00Z 310546 7002 303412 16692 317 160       18683                 72 842 0 341347 posNeg 842 341347 0 0 5ce38c2a9c7e04f7562acfaf8b2e7cadf097a315 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  
1149 1149 20200906 MS 86888 510921   597809 758 5326 186   111   67918 A+ 9/5/2020 00:00 2020-09-05T00:00:00Z 09/04 20:00 2584 5326 2020-09-05T00:00:00Z 592831     82235 2416 168     27468 95             33480   28 410 0 597809 posNeg 410 597809 15 0 0ae4ca9f4bc961e51715822d3e0f12b7d4356bed 0 0 0 0 0  
1160 1160 20200906 OK 63607 860086 5021 923693 472 5105 208       53059 A+ 9/6/2020 00:00 2020-09-06T00:00:00Z 09/05 20:00 853 5105 2020-09-06T00:00:00Z 939500 73487 860086 63607         73173 3453                 40 420 0 928714 posNeg 420 923693 3 0 f9b2fea1d9996881bcba1a6124189ede3933dc80 0 0 0 0 0  
1163 1163 20200906 PR 34533 305972   340505 377   73   67     C 9/6/2020 00:00 2020-09-06T00:00:00Z 09/05 20:00 477   2020-09-06T00:00:00Z 310546 7002 303412 16269 317 160       18264                 72 41 0 340505 posNeg 41 340505 13 0 4e513133ec6ce9da11615d3b9d92702ee5e6a5c8 0 0 0 0 0  
1176 1176 20200906 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 26 0 78344 posNeg 26 78344 0 -4 092d026e4ef2380530b7cf7ebe939ab6621841dd 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  

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