states_daily_4pm_et

Table actions

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

11,578 rows sorted by totalTestsPeopleViral

✎ 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
398 398 20200919 CA 774135 12569751   13343886 3510   970         B 9/19/2020 02:59 2020-09-19T02:59:00Z 09/18 22:59 14912   2020-09-19T02:59:00Z 13343886     774135                             6 4304 162396 13343886 posNeg 166700 13343886 100 0 522bb98bd268b5cf7c3ed74cc7553f1850b8a02a 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  
404 404 20200919 GA 305021 2430368   2735389 1944 27338   4992       A 9/19/2020 14:50 2020-09-19T14:50:00Z 09/19 10:50 6599 27338 2020-09-19T14:50:00Z 2735389 281373 2454016 305021         294470 23959                 13 2284 31153 2735389 posNeg 33437 2735389 62 135 bc6049abca56d6c1a77e29517ecd8032626464c2 0 0 0 0 0  
408 408 20200919 ID 36959 251236   285137 146 1701 51 441     19915 A 9/18/2020 19:00 2020-09-18T19:00:00Z 09/18 15:00 438 1701 2020-09-18T19:00:00Z 285137     33901 400 38                         16 470 2173 288195 posNeg 2615 288195 4 19 872e39ba1f6f6ad7e2a7797252896aa750c164ce 0 0 0 0 0  
409 409 20200919 IL 275054 4784286   5059340 1469   326   141     A 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 8672   2020-09-19T00:00:00Z 5057142     272856 8436 236                         17 2529 71757 5059340 posNeg 74286 5059340 25 0 32550bb10c4afce614d8a9dffbd0406a4096c53b 0 0 0 0 0  
412 412 20200919 KY 61106 993670   1047995 496 5026 114 1483     11237 B 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 1108 5026 2020-09-19T00:00:00Z 1047995     54325 1099 9     51457               19403   21 978 1947 1054776 posNeg 2763 1054776 7 24 c55f8f020c349d3c084aaf2269cb53da0471e537 0 0 0 0 0  
416 416 20200919 ME 5035 366152   371187 14 439 5   1   4346 A+ 9/18/2020 23:59 2020-09-18T23:59:00Z 09/18 19:59 139 439 2020-09-18T23:59:00Z 370674 6280 364115 4522 138 1     10164 509 9641               23 30 6733 371187 posNeg 6763 371187 1 2 52b9998e4feffc614daf11c017a0db96c7b6f592 0 0 0 0 0  
417 417 20200919 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 587 32852 3318469 posNeg 33439 3318469 15 0 953602ddfb868cd34b3fc0502112f9a0cbe31348 0 0 0 0 0  
421 421 20200919 MS 93087 609799   702886 630 5499 171   87   78971 A+ 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 2809 5499 2020-09-18T00:00:00Z 696618     86819 2593 216     36912 95             48844   28 1152 68302 702886 posNeg 69454 702886 29 0 2e50c49b381fa4b226d6da81dccba0ccce742a87 0 0 0 0 0  
422 422 20200919 MT 10163 290677   300840 104 567         7553 C 9/19/2020 01:59 2020-09-19T01:59:00Z 09/18 21:59 156 567 2020-09-19T01:59:00Z 300840     10163                             30 292 1993 300840 posNeg 2285 300840 10 12 f279cf883c4db8092733380a61400b05c5b9665c 0 0 0 0 0  
423 423 20200919 NC 192248 2578772   2771020 882   293       167257 A+ 9/19/2020 11:45 2020-09-19T11:45:00Z 09/19 07:45 3235   2020-09-19T11:45:00Z 2771020     192248 3235                           37 1229 20771 2771020 posNeg 22000 2771020 28 0 e0abf639217232e70b3bb6bf6f5c2a8b614d3420 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  
428 428 20200919 NM 27350 823613   850963 72 3320         15256 B 9/18/2020 17:50 2020-09-18T17:50:00Z 09/18 13:50 841 3320 2020-09-18T17:50:00Z 850963     27350                             35 151 5645 850963 posNeg 5796 850963 5 7 fdccba78b19787857d1c56254d5e10a703d80e5e 0 0 0 0 0  
430 430 20200919 NY 449038 9373053   9822091 467 89995 144   60   76101 A 9/18/2020 23:59 2020-09-18T23:59:00Z 09/18 19:59 25425 89995 2020-09-18T23:59:00Z       449038     9822091                       36 986 109458 9822091 posNeg 110444 9822091 2 0 6428fa42a0444dfe549a7a14c8e0e10ffbb91404 0 0 0 0 0  
431 431 20200919 OH 143547 2645148   2788695 585 14750 199 3175 115   121911 A+ 9/19/2020 14:00 2020-09-19T14:00:00Z 09/19 10:00 4612 14750 2020-09-19T14:00:00Z 2780948     135800 4316 296                         39 951 34639 2788695 posNeg 35590 2788695 4 63 371765734725b75ad7f7c3c95cb90f58a8aed53b 0 0 0 0 0  
432 432 20200919 OK 75804 995697 8878 1071501 522 5843 222       63960 A+ 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 943 5843 2020-09-19T00:00:00Z 1084302 86886 995697 75804         76497 3764                 40 1237 16047 1080379 posNeg 17284 1071501 4 88 63b070b8e209d37c8d6654d5371393def392dadd 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  
437 437 20200919 SC 137240 986025   1123265 826 8708 203   121   51431 A+ 9/18/2020 23:59 2020-09-18T23:59:00Z 09/18 19:59 3188 8708 2020-09-18T23:59:00Z 1120077 170413 949664 134052 3017 171     67865 6232 61633           27959 8621 45 922 10939 1123265 posNeg 11861 1123265 11 39 ef57906d9fd338cf55d8b791caae16772ef96043 0 0 0 0 0  
439 439 20200919 TN 181439 2445648   2627087 837 8116 271   123   164982 A+ 9/19/2020 15:00 2020-09-19T15:00:00Z 09/19 11:00 2216 8116 2020-09-19T15:00:00Z 2621091 213848 2407243 175443 2135 81                         47 942 22803 2627087 posNeg 23745 2627087 20 53 29de2f2694ee4f1fe8f772a47bfe2f0b943c5fb4 0 0 0 0 0  
440 440 20200919 TX 686068 4877108   5563176 3124   1083       605522 A 9/19/2020 17:05 2020-09-19T17:05:00Z 09/19 13:05 14848   2020-09-19T17:05:00Z 5563176     686068         383876 34415             62291 7637 48 3827 114548 5563176 posNeg 118375 5563176 135 0 6abf1f916bb035d7b3b65674f2a272034880d0b7 0 0 0 0 0  
442 442 20200919 VA 139655 1733700 299 1866666 960 17808 219   108   16848 A+ 9/18/2020 17:00 2020-09-18T17:00:00Z 09/18 13:00 2990 17808 2020-09-18T17:00:00Z   158898   132966 2787 203 1866666                       51 953 34167 1873654 posNeg 35043 1873355 41 71 675f51fa15bf451d894fa189a47c40f1da0abe4b 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  
447 447 20200919 WV 13874 495612   509486 169   58   32   10155 C 9/18/2020 23:59 2020-09-18T23:59:00Z 09/18 19:59 308   2020-09-18T23:59:00Z 509154     13542 306 2     16842                   54 191 6162 509486 posNeg 6353 509486 11 0 900beb20e05dbcf7c11d2d367c625da81cf247dd 0 0 0 0 0  
449 449 20200918 AK 7587 410706   418293 36       13   2422 A 9/18/2020 03:59 2020-09-18T03:59:00Z 09/17 23:59 45   2020-09-18T03:59:00Z 418293 6865 411148 7587 45                           2 116 2314 418293 posNeg 2430 418293 1 0 cc5fc47f4be842f963af84b7fcd10209b229c2b9 0 0 0 0 0  
450 450 20200918 AL 142863 910192   1039010 744 16227   1638   904 61232 A 9/18/2020 11:00 2020-09-18T11:00:00Z 09/18 07:00 2428 16227 2020-09-18T11:00:00Z 1039010     128818 2284 144           56411             1 1106 7036 1053055 posNeg 7757 1053055 27 148 1d80c9982122b8a5e07be65d84c08ac3b4d4e74e 0 0 0 0 0  
451 451 20200918 AR 74082 794097   866435 381 4932 193   77 624 65542 A+ 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 1173 4932 2020-09-18T00:00:00Z 866435   794097 72338 1025 148                 9587 2010 21856 3300 5 871 10390 868179 posNeg 11114 868179 7 36 84f27f59f565ab699ac09b88e327dd176560f2e3 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  
454 454 20200918 CA 769831 12407355   13177186 3570   965         B 9/18/2020 02:59 2020-09-18T02:59:00Z 09/17 22:59 14812   2020-09-18T02:59:00Z 13177186     769831                             6 3630 93519 13177186 posNeg 97149 13177186 91 0 0b265eaae7709a2b3f25d312886050c3ef489db2 0 0 0 0 0  
456 456 20200918 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 141 13734 1422148 posNeg 13875 1422148 4 0 8028fe295ada8c0981715ffc32e44a4ea74e2a01 0 0 0 0 0  
460 460 20200918 GA 302737 2399215   2701952 1975 27203   4966       A 9/18/2020 14:50 2020-09-18T14:50:00Z 09/18 10:50 6537 27203 2020-09-18T14:50:00Z 2701952 276778 2425174 302737         293358 23742                 13 1834 20227 2701952 posNeg 22061 2701952 63 149 793303809173dcce4631ea6afb2f04ca775ff408 0 0 0 0 0  
464 464 20200918 ID 36489 249063   282522 123 1682 54 438     19691 A 9/17/2020 19:00 2020-09-17T19:00:00Z 09/17 15:00 434 1682 2020-09-17T19:00:00Z 282522     33489 396 38                         16 396 1791 285552 posNeg 2096 285552 5 24 3f6e318d2808a0d59d93fdb43dde97df5692ae7f 0 0 0 0 0  
465 465 20200918 IL 272525 4712529   4985054 1481   329   149     A 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 8647   2020-09-18T00:00:00Z 4982856     270327 8411 236                         17 2223 59798 4985054 posNeg 62021 4985054 23 0 af55c41602ff46bc3ee72471de976cc506bdf854 0 0 0 0 0  
468 468 20200918 KY 60128 991723   1045232 500 5002 144 1478     11168 B 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 1101 5002 2020-09-18T00:00:00Z 1045232     53509 1092 9     50995               18878   21 758 12408 1051851 posNeg 13030 1051851 8 26 c288802bfd53de247b14af3c2729a60310146907 0 0 0 0 0  
472 472 20200918 ME 5005 359419   364424 11 437 5   1   4335 A+ 9/17/2020 23:59 2020-09-17T23:59:00Z 09/17 19:59 138 437 2020-09-17T23:59:00Z 363911 6240 357397 4492 137 1     10147 509 9624               23 43 13003 364424 posNeg 13046 364424 0 1 2965245260ac2f3e4b1ca2508e1d4a4facca2c2f 0 0 0 0 0  
473 473 20200918 MI 127500 3157530   3285030 557   150   64   85513 A+ 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 6954   2020-09-18T00:00:00Z 3319787 162257 3157530 115387 6638 316     282669                   26 778 32521 3285030 posNeg 33299 3285030 -1 0 a7d9fa1e5fd4b1b2d91b07a77b131ec7a31d6beb 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  
478 478 20200918 MT 9871 288684   298555 105 555         7500 C 9/18/2020 01:59 2020-09-18T01:59:00Z 09/17 21:59 146 555 2020-09-18T01:59:00Z 298555     9871                             30 224 3032 298555 posNeg 3256 298555 3 6 4bdfeea49b12f3891160e88a463c8c251858f294 0 0 0 0 0  
479 479 20200918 NC 191019 2558001   2749020 904   283       167257 A+ 9/18/2020 11:00 2020-09-18T11:00:00Z 09/18 07:00 3207   2020-09-18T11:00:00Z 2749020     191019 3207                           37 1443 33402 2749020 posNeg 34845 2749020 27 0 da3afb8b233d4478bba2ba6f6bf8974aa86a43c1 0 0 0 0 0  
483 483 20200918 NJ 198848 3093068   3291916 413 23096 73   36   34572 A+ 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 16061 23096 2020-09-18T00:00:00Z 3291916     198848 14270 1791                         34 487 25611 3291916 posNeg 26098 3291916 4 25 691f7443eb5c45ad48a7a0aa14fdf1d25778344a 0 0 0 0 0  
484 484 20200918 NM 27199 817968   845167 69 3313         15106 B 9/16/2020 17:52 2020-09-16T17:52:00Z 09/16 13:52 836 3313 2020-09-16T17:52:00Z 845167     27199                             35 158 7609 845167 posNeg 7767 845167 4 19 db0a33afe08b1a9c866c0b252d331ccb0155d116 0 0 0 0 0  
486 486 20200918 NY 448052 9263595   9711647 478 89995 141   62   76036 A 9/17/2020 23:59 2020-09-17T23:59:00Z 09/17 19:59 25423 89995 2020-09-17T23:59:00Z       448052     9711647                       36 790 88937 9711647 posNeg 89727 9711647 10 0 484099c5cadb392fbd9a1cdd91d0dfbb3d880cf9 0 0 0 0 0  
487 487 20200918 OH 142596 2610509   2753105 634 14687 223 3161 118   120858 A+ 9/18/2020 14:00 2020-09-18T14:00:00Z 09/18 10:00 4608 14687 2020-09-18T14:00:00Z 2745431     134922 4312 296                         39 1011 33761 2753105 posNeg 34772 2753105 28 62 3e8e48cbe31d86cb37520d9926a3f237d764b8dc 0 0 0 0 0  
488 488 20200918 OK 74567 979650 7491 1054217 516 5755 223       63135 A+ 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 939 5755 2020-09-18T00:00:00Z 1066896 85471 979650 74567         74483 3581                 40 1249 13131 1061708 posNeg 14380 1054217 9 57 7dc4bad3bf741eb44ffad2a5b3d6d0c8615f16f6 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  
493 493 20200918 SC 136318 975086   1111404 798 8669 217   125   51431 A+ 9/17/2020 23:59 2020-09-17T23:59:00Z 09/17 19:59 3177 8669 2020-09-17T23:59:00Z 1108396 169306 939090 133310 3010 167     67459 6153 61306           26886 8291 45 872 22945 1111404 posNeg 23817 1111404 19 58 bfeaa2f1fd46cdcd0f2125c34519a05a7d5dc2a0 0 0 0 0 0  
495 495 20200918 TN 180497 2422845   2603342 871 8063 275   124   163181 A+ 9/18/2020 15:00 2020-09-18T15:00:00Z 09/18 11:00 2196 8063 2020-09-18T15:00:00Z 2597482 212799 2384683 174637 2116 80                         47 2357 36106 2603342 posNeg 38463 2603342 32 84 0a928daac04c925356b6ee4143822e86c4fdfa7f 0 0 0 0 0  
496 496 20200918 TX 682241 4762560   5444801 3172   1107       600662 A 9/18/2020 16:25 2020-09-18T16:25:00Z 09/18 12:25 14713   2020-09-18T16:25:00Z 5444801     682241         381430 34084             59051 7439 48 3422 96203 5444801 posNeg 99625 5444801 123 0 01ae553b738298729e92c53cb9456c4aedf80ecf 0 0 0 0 0  
498 498 20200918 VA 138702 1699533 297 1831623 945 17737 212   102   16762 A+ 9/17/2020 17:00 2020-09-17T17:00:00Z 09/17 13:00 2949 17737 2020-09-17T17:00:00Z   157605   132090 2755 194 1831623                       51 1242 8481 1838532 posNeg 9611 1838235 29 71 12f9481bc692f822148b81d495ad680ead68327c 0 0 0 0 0  
499 499 20200918 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 4 171 18980 posNeg 175 18954 0 0 61df3960b89edff6f3730beb2cc3165b5a7afcb7 0 0 0 0 0  
501 501 20200918 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 404 13219 1704670 posNeg 13623 1704670 6 19 f6d5abdbe1cab27405187ffc7aff1a8d7e027961 0 0 0 0 0  
503 503 20200918 WV 13683 489450   503133 175   63   40   10011 C 9/17/2020 23:59 2020-09-17T23:59:00Z 09/17 19:59 297   2020-09-17T23:59:00Z 502803     13353 295 2     16737                   54 253 4597 503133 posNeg 4850 503133 3 0 501f00a1d28e795f3e2d6f9b72449076df2c5365 0 0 0 0 0  
505 505 20200917 AK 7471 408392   415863 41       13   2408 A 9/17/2020 03:59 2020-09-17T03:59:00Z 09/16 23:59 44   2020-09-17T03:59:00Z 415863 6814 408769 7471 44                           2 106 7193 415863 posNeg 7299 415863 0 0 c987aced59fdca527be184aea95007bda92c8e6c 0 0 0 0 0  
506 506 20200917 AL 141757 903156   1031253 740 16079   1631   900 61232 A 9/17/2020 11:00 2020-09-17T11:00:00Z 09/17 07:00 2401 16079 2020-09-17T11:00:00Z 1031253     128097 2264 137           56181             1 670 3472 1044913 posNeg 4046 1044913 9 137 d341c5071b10d5c26014930058cee8087a90240e 0 0 0 0 0  
507 507 20200917 AR 73211 783707   855321 389 4896 206   72 619 64145 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 1166 4896 2020-09-17T00:00:00Z 855321   783707 71614 1018 148                     21856 3300 5 992 9749 856918 posNeg 10632 856918 9 56 13b8b79ad42797a1532c6ca471edab3c6a77f7ca 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  
510 510 20200917 CA 766201 12313836   13080037 3621   997         B 9/17/2020 02:59 2020-09-17T02:59:00Z 09/16 22:59 14721   2020-09-17T02:59:00Z 13080037     766201                             6 3238 76277 13080037 posNeg 79515 13080037 106 0 89879e61e98e2a49fd2a0ec480230d8094767e5b 0 0 0 0 0  
512 512 20200917 CT 55386 1352887   1408273 75 11447         9204 B 9/16/2020 20:30 2020-09-16T20:30:00Z 09/16 16:30 4488 11447 2020-09-16T20:30:00Z 1405974     53087 3593 895                         9 220 13648 1408273 posNeg 13868 1408273 1 90 64e4c149f4d39d8ae2177683e0e886f4853df0a6 0 0 0 0 0  
516 516 20200917 GA 300903 2378988   2679891 1977 27054   4945       A 9/17/2020 14:50 2020-09-17T14:50:00Z 09/17 10:50 6474 27054 2020-09-17T14:50:00Z 2679891 275551 2404340 300903         292125 23551                 13 1847 23923 2679891 posNeg 25770 2679891 55 170 21ade400b731cf4c9e0ff26cdce8ece6b58269d2 0 0 0 0 0  
520 520 20200917 ID 36093 247272   280426 123 1658 54 433     19405 A 9/17/2020 15:44 2020-09-17T15:44:00Z 09/17 11:44 429 1658 2020-09-17T15:44:00Z 280426     33154 391 38                         16 283 1440 283365 posNeg 1647 283365 6 27 5739dc6c5294fa1f977cded5cf60d4a5a5f48647 0 0 0 0 0  
521 521 20200917 IL 270302 4652731   4923033 1558   359   144     A 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 8624   2020-09-17T00:00:00Z 4920938     268207 8392 232                         17 2056 55744 4923033 posNeg 57800 4923033 25 0 76170a264f86a509343cf7aba2fd5505594c615e 0 0 0 0 0  
524 524 20200917 KY 59370 979315   1032202 515 4976 113 1471     11109 B 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 1093 4976 2020-09-17T00:00:00Z 1032202     52887 1084 9     50342               18735   21 606 10300 1038685 posNeg 10750 1038685 11 49 b8959d0ca54c1e66274ebd17bf8416abb5159cc2 0 0 0 0 0  
528 528 20200917 ME 4962 346416   351378 12 436 5   0   4317 A+ 9/16/2020 23:59 2020-09-16T23:59:00Z 09/16 19:59 138 436 2020-09-16T23:59:00Z 350874 6190 344419 4458 137 1     10133 509 9610               23 21 9170 351378 posNeg 9191 351378 0 3 9ba888362fd04c26119be39b950d8945437a9df6 0 0 0 0 0  
529 529 20200917 MI 126722 3125009   3251731 590   152   67   85513 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 6955   2020-09-17T00:00:00Z 3286221 161212 3125009 114692 6632 323     279980                   26 980 32290 3251731 posNeg 33270 3251731 12 0 65eb59487c8597e39712ad7ac0f0eb7ec0641bad 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  
534 534 20200917 MT 9647 285652   295299 107 549         7401 C 9/17/2020 01:59 2020-09-17T01:59:00Z 09/16 21:59 143 549 2020-09-17T01:59:00Z 295299     9647                             30 216 2682 295299 posNeg 2898 295299 2 6 78ae7caa8470c0c7c41ec09c04e3ff915793a6f7 0 0 0 0 0  
535 535 20200917 NC 189576 2524599   2714175 894   286       167257 A+ 9/17/2020 11:00 2020-09-17T11:00:00Z 09/17 07:00 3180   2020-09-17T11:00:00Z 2714175     189576 3180                           37 1552 29239 2714175 posNeg 30791 2714175 31 0 f54997dddab844113b34f8b2f37f25d7905c02e8 0 0 0 0 0  
539 539 20200917 NJ 198361 3067457   3265818 431 23071 85   40   34546 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 16057 23071 2020-09-17T00:00:00Z 3265818     198361 14266 1791                         34 569 30277 3265818 posNeg 30846 3265818 3 39 01f236b39a0a95f41fa63a1a29b559c393ee292b 0 0 0 0 0  
540 540 20200917 NM 27041 810359   837400 59 3294         14842 B 9/16/2020 17:52 2020-09-16T17:52:00Z 09/16 13:52 832 3294 2020-09-16T17:52:00Z 837400     27041                             35 118 5287 837400 posNeg 5405 837400 2 10 1e1bc377f1bbd56688b3fd6991d58a15ac6f5582 0 0 0 0 0  
542 542 20200917 NY 447262 9174658   9621920 486 89995 135   68   75962 A 9/16/2020 23:59 2020-09-16T23:59:00Z 09/16 19:59 25413 89995 2020-09-16T23:59:00Z       447262     9621920                       36 896 90608 9621920 posNeg 91504 9621920 3 0 5e44bc2c7424a256603012991c84a330c2f41244 0 0 0 0 0  
543 543 20200917 OH 141585 2576748   2718333 638 14625 214 3149 127   119690 A+ 9/17/2020 14:00 2020-09-17T14:00:00Z 09/17 10:00 4580 14625 2020-09-17T14:00:00Z 2710749     134001 4282 298                         39 1067 27786 2718333 posNeg 28853 2718333 25 65 8f30690ba41f95199518745abe74e7bcb3b52cf3 0 0 0 0 0  
544 544 20200917 OK 73318 966519 7456 1039837 516 5698 221       62144 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 930 5698 2020-09-17T00:00:00Z 1052756 84029 966519 73318         74483 3581                 40 1034 11207 1047293 posNeg 12241 1039837 6 88 009dfcc303fe0ff8ac204938dbaf9ada9b8d12c8 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  
549 549 20200917 SC 135446 952141   1087587 733 8611 203   123   51431 A+ 9/16/2020 23:59 2020-09-16T23:59:00Z 09/16 19:59 3158 8611 2020-09-16T23:59:00Z 1084706 166907 917799 132565 2992 166     66921 6020 60901           25086 8017 45 1324 5341 1087587 posNeg 6665 1087587 26 59 e4e13d6053fe5ed583572b1ef9006be557171708 0 0 0 0 0  
551 551 20200917 TN 178140 2386739   2564879 999 7979 294   141   161707 A+ 9/17/2020 15:00 2020-09-17T15:00:00Z 09/17 11:00 2164 7979 2020-09-17T15:00:00Z 2559192 210203 2348989 172453 2084 80                         47 1053 20590 2564879 posNeg 21643 2564879 13 57 1dee7b157194556c69372cbe000851c2d349e96d 0 0 0 0 0  
552 552 20200917 TX 678819 4666357   5345176 3246   1140       594817 A 9/17/2020 17:25 2020-09-17T17:25:00Z 09/17 13:25 14590   2020-09-17T17:25:00Z 5345176     678819         378541 33718             56707 7280 48 4047 41509 5345176 posNeg 45556 5345176 112 0 b47684ef5e164c1819d27f02a2f475aecb3fbdf3 0 0 0 0 0  
554 554 20200917 VA 137460 1691052 326 1822012 995 17666 225   109   16671 A+ 9/16/2020 17:00 2020-09-16T17:00:00Z 09/16 13:00 2920 17666 2020-09-16T17:00:00Z   156565   130960 2734 186 1822012                       51 1101 21164 1828838 posNeg 22161 1828512 36 103 33916f3bfcf2b2776200d373449be7034c462068 0 0 0 0 0  
555 555 20200917 VI 1238 17541 21 18779             1172 D 9/17/2020 06:24 2020-09-17T06:24:00Z 09/17 02:24 19   2020-09-17T06:24:00Z 18800       19                           78 6 101 18800 posNeg 107 18779 0 0 d9073f442e2c6aa5d3f1718b6b3df2237c2b9e6b 0 0 0 0 0  
557 557 20200917 WA 81198 1609849   1691047 248 7196     36     B 9/17/2020 02:59 2020-09-17T02:59:00Z 09/16 22:59 2031 7196 2020-09-17T02:59:00Z       81198 2031   1691047                       53 386 13959 1691047 posNeg 14345 1691047 11 34 1e2f79583b37963862253e9dffe4e8e70009c5f4 0 0 0 0 0  
559 559 20200917 WV 13430 484853   498283 170   58   32   9804 C 9/16/2020 23:59 2020-09-16T23:59:00Z 09/16 19:59 294   2020-09-16T23:59:00Z 497962     13109 292 2     16614                   54 234 4166 498283 posNeg 4400 498283 4 0 a91204a31ea82bc12d420b570e211c5eafc42d0d 0 0 0 0 0  
561 561 20200916 AK 7365 401199   408564 45       9   2407 A 9/16/2020 03:59 2020-09-16T03:59:00Z 09/15 23:59 44   2020-09-16T03:59:00Z 408564 6669 401615 7365 44                           2 52 1388 408564 posNeg 1440 408564 0 0 ad1f0e91a77746e4f6d9ba6cc959464870a19357 0 0 0 0 0  
562 562 20200916 AL 141087 899684   1027207 722 15942   1629   901 61232 A 9/16/2020 11:00 2020-09-16T11:00:00Z 09/16 07:00 2392 15942 2020-09-16T11:00:00Z 1027207     127523 2257 135           55976             1 927 6874 1040771 posNeg 7584 1040771 5 186 5ab1a87b72bdf1330a2ddc4309642ce1956411c0 0 0 0 0 0  
563 563 20200916 AR 72219 773958   844689 387 4840 189   65 616 64145 A+ 9/16/2020 14:37 2020-09-16T14:37:00Z 09/16 10:37 1157 4840 2020-09-16T14:37:00Z 844689   773958 70731 1010 147                     20007 3067 5 862 -26801 846177 posNeg -26195 846177 147 38 1f65d079f5386867bb7d41d96a3103b187d8c09c 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  
566 566 20200916 CA 762963 12237559   13000522 3685   1032         B 9/16/2020 02:59 2020-09-16T02:59:00Z 09/15 22:59 14615   2020-09-16T02:59:00Z 13000522     762963                             6 2950 69402 13000522 posNeg 72352 13000522 164 0 9ac5f7449cd7fadb6db00407b669e5202f4157f7 0 0 0 0 0  
568 568 20200916 CT 55166 1339239   1394405 70 11357         9142 B 9/15/2020 20:30 2020-09-15T20:30:00Z 09/15 16:30 4487 11357 2020-09-15T20:30:00Z 1392117     52878 3592 895                         9 135 3499 1394405 posNeg 3634 1394405 2 0 5f602d980e08344850faef32e5c845842fc7fb03 0 0 0 0 0  
572 572 20200916 GA 299056 2355065   2654121 2030 26884   4912       A 9/16/2020 14:50 2020-09-16T14:50:00Z 09/16 10:50 6419 26884 2020-09-16T14:50:00Z 2654121 273177 2380944 299056         291168 23408                 13 2223 22808 2654121 posNeg 25031 2654121 21 219 e4ffb923fdc3e0b0ad438603f2e40fd43e1953e8 0 0 0 0 0  
576 576 20200916 ID 35810 245832   278779 105 1631 34 426     19075 A 9/15/2020 19:00 2020-09-15T19:00:00Z 09/15 15:00 423 1631 2020-09-15T19:00:00Z 278779     32947 385 38                         16 278 1194 281642 posNeg 1411 281642 4 19 d601a422a562ec23cbf71550d8c81198cd3e9e91 0 0 0 0 0  
577 577 20200916 IL 268246 4596987   4865233 1565   345   143     A 9/16/2020 00:00 2020-09-16T00:00:00Z 09/15 20:00 8599   2020-09-16T00:00:00Z 4863138     266151 8367 232                         17 1941 50370 4865233 posNeg 52311 4865233 35 0 618ff575fa8a73bf568da2e3299baf3a066d44df 0 0 0 0 0  
580 580 20200916 KY 58764 969015   1021452 565 4927 125 1466     11043 B 9/16/2020 00:00 2020-09-16T00:00:00Z 09/15 20:00 1082 4927 2020-09-16T00:00:00Z 1021452     52437 1073 9     50206               18502   21 764 20576 1027779 posNeg 21151 1027779 8 3 25f347b9deace7ef1faf6262cc4b228c4d6b5261 0 0 0 0 0  
584 584 20200916 ME 4941 337246   342187 10 433 5   0   4307 A+ 9/15/2020 23:59 2020-09-15T23:59:00Z 09/15 19:59 138 433 2020-09-15T23:59:00Z 341680 6161 335257 4434 137 1     10060 504 9542               23 23 5675 342187 posNeg 5698 342187 1 1 7c059fd6cd172fb358a91b29aea55b78c81b1ef2 0 0 0 0 0  
585 585 20200916 MI 125742 3092719   3218461 590   152   65   85513 A+ 9/16/2020 00:00 2020-09-16T00:00:00Z 09/15 20:00 6943   2020-09-16T00:00:00Z 3252947 160228 3092719 113863 6623 320     270746                   26 773 30067 3218461 posNeg 30840 3218461 11 0 98222aaea3b29b809e382f8112846efa461ae4bb 0 0 0 0 0  
589 589 20200916 MS 91234 541497   632731 632 5499 168   98   78971 A+ 9/15/2020 00:00 2020-09-15T00:00:00Z 09/14 20:00 2756 5499 2020-09-15T00:00:00Z 626881     85384 2562 194     29016 95             40904   28 711 5709 632731 posNeg 6420 632731 22 0 16471a11868dfcfece7bd53454451adb95369a5c 0 0 0 0 0  
590 590 20200916 MT 9431 282970   292401 106 543         7186 C 9/16/2020 01:59 2020-09-16T01:59:00Z 09/15 21:59 141 543 2020-09-16T01:59:00Z 292401     9431                             30 187 2846 292401 posNeg 3033 292401 1 4 558b661e4e28c8b47ddfb0c35fbee5d39e2b7cb3 0 0 0 0 0  
591 591 20200916 NC 188024 2495360   2683384 918   297       167257 A+ 9/16/2020 11:15 2020-09-16T11:15:00Z 09/16 07:15 3149   2020-09-16T11:15:00Z 2683384     188024 3149                           37 1137 29807 2683384 posNeg 30944 2683384 38 0 8792e5555ea0279cb9f384650f4dc648fc318897 0 0 0 0 0  
595 595 20200916 NJ 197792 3037180   3234972 462 23032 100   38   34503 A+ 9/16/2020 00:00 2020-09-16T00:00:00Z 09/15 20:00 16054 23032 2020-09-16T00:00:00Z 3234972     197792 14263 1791                         34 388 22273 3234972 posNeg 22661 3234972 9 29 de129e85e1f5facc959c38c71fc3f9dde9cfc3a7 0 0 0 0 0  
596 596 20200916 NM 26923 805072   831995 59 3284         14634 B 9/15/2020 17:50 2020-09-15T17:50:00Z 09/15 13:50 830 3284 2020-09-15T17:50:00Z 831995     26923                             35 81 5295 831995 posNeg 5376 831995 7 10 0a412029f9baceb1993165de41dc2cbd9ed99904 0 0 0 0 0  
598 598 20200916 NY 446366 9084050   9530416 483 89995 138   67   75903 A 9/15/2020 23:59 2020-09-15T23:59:00Z 09/15 19:59 25410 89995 2020-09-15T23:59:00Z       446366     9530416                       36 652 74435 9530416 posNeg 75087 9530416 5 0 247d677a0fea26706b310e8053dd5198afd55927 0 0 0 0 0  
599 599 20200916 OH 140518 2548962   2689480 651 14560 222 3134 133   118443 A+ 9/16/2020 14:00 2020-09-16T14:00:00Z 09/16 10:00 4555 14560 2020-09-16T14:00:00Z 2682008     133046 4256 299                         39 1033 28916 2689480 posNeg 29949 2689480 49 79 4790260132d3703f9bd61ad3170fc4d87c6175f7 0 0 0 0 0  
600 600 20200916 OK 72284 955312 6260 1027596 528 5610 213       61026 A+ 9/16/2020 00:00 2020-09-16T00:00:00Z 09/15 20:00 924 5610 2020-09-16T00:00:00Z 1040699 83065 955312 72284         74483 3581                 40 970 10118 1033856 posNeg 11088 1027596 12 48 a77efa9a2130377b8a74616dfe3be136c755b503 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
);