states_daily_4pm_et

Table actions

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

11,578 rows sorted by deathIncrease

✎ 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
275 275 20200922 VI 1276 18188 15 19464             1195 D 9/22/2020 12:42 2020-09-22T12:42:00Z 09/22 08:42 19   2020-09-22T12:42:00Z 19479       19                           78 7 145 19479 posNeg 152 19464 0 0 191a687d009f07d86fd52430b0fdc8be9f99f7c2 0 0 0 0 0  
276 276 20200922 VT 1721 155620   157341 1           1557 B 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 58   2020-09-21T23:59:00Z       1721 58     157341                     50 2 600 157341 posNeg 602 157341 0 0 e9fac8ed601d3958f6472d13994781286dc67a5b 0 0 0 0 0  
280 280 20200922 WY 5016 89824   94840 21 253         4230 B 9/22/2020 17:10 2020-09-22T17:10:00Z 09/22 13:10 49 253 2020-09-22T17:10:00Z 149060 4322 144737 4231       94055                     56 72 637 94840 posNeg 709 94840 0 6 07edd1d4539f3f8700e4a569517653f3ae0e9490 0 0 0 0 0  
281 281 20200921 AK 7838 420807   428645 47       13   2439 A 9/21/2020 03:59 2020-09-21T03:59:00Z 09/20 23:59 45   2020-09-21T03:59:00Z 428645 7089 421275 7838 45                           2 71 1649 428645 posNeg 1720 428645 0 0 2ec1459d557a0a9f8c65f1d11f0e2ac4bdf025f3 0 0 0 0 0  
284 284 20200921 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 fe2ac904fb66e75d6ba49697cef3e44e5eee9332 0 0 0 0 0  
287 287 20200921 CO 64857 767852   1208425 239 7363         6291 A 9/20/2020 01:59 2020-09-20T01:59:00Z 09/19 21:59 1913 7363 2020-09-20T01:59:00Z       60256     1208425 828108 166546 11600 154948               8 501 6506 832709 totalTestEncountersViral 13046 832709 0 6 dfa726f7daf8d6b4a08ccf6210e93e7c20ea0fd4 0 0 0 0 0  
294 294 20200921 HI 11403 270015   281418 185 730 51   40   4759 B 9/20/2020 18:00 2020-09-20T18:00:00Z 09/20 14:00 120 730 2020-09-20T18:00:00Z 385103             281418                     15 77 1492 281418 posNeg 1569 281418 0 4 972930490df7727b3f0708d0d559f9478939e8a4 0 0 0 0 0  
308 308 20200921 MP 69 14316   14385   4         29 D 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 2 4 2020-09-21T00:00:00Z 18915     69 2     14375                     69 1 0 14385 posNeg 1 14385 0 0 99470fe591f97a5a0ea49b7b3a360e1367716668 0 0 0 0 0  
309 309 20200921 MS 93556 613350   706906 621 5607 162   77   85327 A+ 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 2810 5607 2020-09-20T00:00:00Z 700510     87160 2591 219     37165 95             49300   28 192 3551 706906 posNeg 3743 706906 0 108 c8776ce318204a09e82d5332c2b2b55a889d93d5 0 0 0 0 0  
313 313 20200921 NE 41083 384733   425816 170 2194         30509 A 9/20/2020 20:15 2020-09-20T20:15:00Z 09/20 16:15 442 2194 2020-09-20T20:15:00Z 562886     41083       426110                     31 286 2170 425816 posNeg 2456 425816 0 0 b8f0be6057e416e8420936ad54493d4b03355818 0 0 0 0 0  
314 314 20200921 NH 7952 234290   407333 11 726   230     7226 B 9/20/2020 09:00 2020-09-20T09:00:00Z 09/20 05:00 438 726 2020-09-20T09:00:00Z 407333     7952       242242 31475     30754             33 5 1836 242242 posNeg 5644 242242 0 1 79428293c38fb378b300135e4d08a2a0155bc9cd 0 0 0 0 0  
317 317 20200921 NV 76036 590756   666792 449   130   81   2026 A+ 9/21/2020 02:59 2020-09-21T02:59:00Z 09/20 22:59 1531   2020-09-21T02:59:00Z 988019     76036       666062                     32 232 1376 666792 posNeg 1608 666792 0 0 8d418c4347de957ff1ef8b136a726fb6bcf35620 0 0 0 0 0  
326 326 20200921 SD 18869 158154   177023 161 1297         15777 A 9/20/2020 14:00 2020-09-20T14:00:00Z 09/20 10:00 202 1297 2020-09-20T14:00:00Z 245387             177023                     46 173 497 177023 posNeg 670 177023 0 9 de8ce40f2ca507606ebfad5913ea49564ff9fe7c 0 0 0 0 0  
331 331 20200921 VI 1269 18043 2 19312             1186 D 9/20/2020 11:16 2020-09-20T11:16:00Z 09/20 07:16 19   2020-09-20T11:16:00Z 19314       19                           78 0 0 19314 posNeg 0 19312 0 0 d6b14de23445b4ec73bcf3ab0f7b006d626cece5 0 0 0 0 0  
332 332 20200921 VT 1719 155020   156739 3           1557 B 9/20/2020 23:59 2020-09-20T23:59:00Z 09/20 19:59 58   2020-09-20T23:59:00Z       1719 58     156739                     50 4 840 156739 posNeg 844 156739 0 0 e0918eb00b093d9db0cac5b171724ce0427c09e2 0 0 0 0 0  
333 333 20200921 WA 82548 1654008   1736556 266 7262     21     B 9/20/2020 02:59 2020-09-20T02:59:00Z 09/19 22:59 2037 7262 2020-09-20T02:59:00Z       82548 2037   1736556                       53 349 13167 1736556 posNeg 13516 1736556 0 14 1ec9cb24edb05172778970744d37350c347da8eb 0 0 0 0 0  
336 336 20200921 WY 4944 89187   94131 23 247         4172 B 9/21/2020 16:47 2020-09-21T16:47:00Z 09/21 12:47 49 247 2020-09-21T16:47:00Z 145231 4211 141019 4189       93376                     56 73 1627 94131 posNeg 1700 94131 0 4 29fade3cb82b3f5a982e66deeb63e9064a93cac9 0 0 0 0 0  
337 337 20200920 AK 7767 419158   426925 43       13   2438 A 9/20/2020 03:59 2020-09-20T03:59:00Z 09/19 23:59 45   2020-09-20T03:59:00Z 426925 7061 419584 7767 45                           2 93 3982 426925 posNeg 4075 426925 0 0 d939ccbfc0a45044ede4b81384f1a41520b50f87 0 0 0 0 0  
338 338 20200920 AL 144962 923366   1054017 780 16227   1643   904 61232 A 9/19/2020 11:00 2020-09-19T11:00:00Z 09/19 07:00 2437 16227 2020-09-19T11:00:00Z 1054017     130651 2290 147           56887             1 798 4918 1068328 posNeg 5595 1068328 0 0 1068eacf936cf84dc1349d453d2454fa7e85ffa1 0 0 0 0 0  
340 340 20200920 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 3e8d4473820fe86e6e0d374bbcf084d1a4283566 0 0 0 0 0  
343 343 20200920 CO 64356 761346   1195379 237 7357         6274 A 9/20/2020 01:59 2020-09-20T01:59:00Z 09/19 21:59 1913 7357 2020-09-20T01:59:00Z       59782     1195379 821128 166196 11568 154630               8 606 7227 825702 totalTestEncountersViral 13550 825702 0 10 53538ff2d6fb07c9a2a5be3d98b592c35770bf7b 0 0 0 0 0  
344 344 20200920 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 c23b8f09fd8aeea712d8e464d7f2456f8097e929 0 0 0 0 0  
346 346 20200920 DE 19566 251855   271421 60   14       10299 A+ 9/19/2020 18:00 2020-09-19T18:00:00Z 09/19 14:00 621   2020-09-19T18:00:00Z       18547 548 73   271421                     10 117 1593 271421 posNeg 1710 271421 0 0 a7697ebb4a222e020c6d40a7b15fcd80eafacfcc 0 0 0 0 0  
349 349 20200920 GU 2117 43841   45958 36   19       1450 A 9/19/2020 04:15 2020-09-19T04:15:00Z 09/19 00:15 34   2020-09-19T04:15:00Z 45651     2117       45958 172 3                 66 0 0 45958 posNeg 0 45958 0 0 3bfc034531cffc78d480c081bb28d9a8b2c7b492 0 0 0 0 0  
350 350 20200920 HI 11326 268523   279849 185 726 51   40   4622 B 9/19/2020 18:00 2020-09-19T18:00:00Z 09/19 14:00 120 726 2020-09-19T18:00:00Z 381571             279740                     15 109 0 279849 posNeg 109 279849 0 26 38a3be6d93c57e4008714676d7a19cd972faf2d8 0 0 0 0 0  
355 355 20200920 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 c3b90f2255d2333d62ea9e0b7046c08b7748c885 0 0 0 0 0  
360 360 20200920 ME 5079 369059   374138 16 439 4   1   4364 A+ 9/19/2020 23:59 2020-09-19T23:59:00Z 09/19 19:59 139 439 2020-09-19T23:59:00Z 373621 6301 367041 4562 138 1     10190 512 9664               23 44 2907 374138 posNeg 2951 374138 0 0 b5949e50fae75e98ba13075ec50301ae4c72985e 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  
368 368 20200920 ND 17958 210297   562599 81 723 22 185     14558 B 9/20/2020 01:59 2020-09-20T01:59:00Z 09/19 21:59 142 723 2020-09-20T01:59:00Z 582629     17958 139 3 562599 228255 9164 400 8764               38 351 1402 228255 totalTestEncountersViral 5737 228255 0 7 fd547903281d387d9445dbc1233b2224e93e3635 0 0 0 0 0  
369 369 20200920 NE 40797 382563   423360 174 2194         30509 A 9/19/2020 20:15 2020-09-19T20:15:00Z 09/19 16:15 442 2194 2020-09-19T20:15:00Z       40797       423653                     31 410 2955 423360 posNeg 3365 423360 0 0 4324820c2c1ca25ea8d669e12254eaa0da5926c8 0 0 0 0 0  
370 370 20200920 NH 7947 232454   401689 10 725   230     7201 B 9/20/2020 09:00 2020-09-20T09:00:00Z 09/20 05:00 438 725 2020-09-20T09:00:00Z 401689     7947       240401 31457     30737             33 27 1642 240401 posNeg 8523 240401 0 0 1c22ad794a219e6e8da915c8efb421dfcb02b3fd 0 0 0 0 0  
385 385 20200920 UT 63772 694393   758165 187 3494 59 853   350 51410 A+ 9/20/2020 11:00 2020-09-20T11:00:00Z 09/20 07:00 440 3494 2020-09-20T11:00:00Z 966382     63772       758165             10465 1508 16189 1604 49 920 5295 758165 posNeg 6215 758165 0 17 e32944fbfa955a9f063edf30341db0e02f289999 0 0 0 0 0  
387 387 20200920 VI 1269 18043 2 19312             1186 D 9/20/2020 11:16 2020-09-20T11:16:00Z 09/20 07:16 19   2020-09-20T11:16:00Z 19314       19                           78 27 331 19314 posNeg 358 19312 0 0 be003cbf815c110eb91b2469e88ea1b5f5873bb7 0 0 0 0 0  
388 388 20200920 VT 1715 154180   155895 2           1548 B 9/19/2020 23:59 2020-09-19T23:59:00Z 09/19 19:59 58   2020-09-19T23:59:00Z       1715 58     155895                     50 5 1090 155895 posNeg 1095 155895 0 0 bd99708f326996fbfa7ce99054babfcbd044f68d 0 0 0 0 0  
389 389 20200920 WA 82199 1640841   1723040 262 7248     26     B 9/19/2020 02:59 2020-09-19T02:59:00Z 09/18 22:59 2037 7248 2020-09-19T02:59:00Z       82199 2037   1723040                       53 597 17773 1723040 posNeg 18370 1723040 0 33 6ad1b5012368d8905d746d13224a1a9fa8d71887 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  
393 393 20200919 AK 7674 415176   422850 41       13   2438 A 9/19/2020 03:59 2020-09-19T03:59:00Z 09/18 23:59 45   2020-09-19T03:59:00Z 422850 6970 415600 7674 45                           2 87 4470 422850 posNeg 4557 422850 0 0 934611e27c6c701c808cf53976fe9a48c80fd513 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  
401 401 20200919 DC 14902 335975   350877 85   23   14   11823 A+ 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 619   2020-09-18T00:00:00Z             350877 202618                     11 50 3709 350877 posNeg 3759 350877 0 0 4f3655146b46326135d58634878269b61c4beb96 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  
424 424 20200919 ND 17607 208895   556862 78 716 22 184     14319 B 9/19/2020 01:59 2020-09-19T01:59:00Z 09/18 21:59 142 716 2020-09-19T01:59:00Z 576672     17607 139 3 556862 226502 9164 400 8764               38 377 932 226502 totalTestEncountersViral 6538 226502 0 11 e862b6b6bedaa268a3f38b22cf09b9276279a79d 0 0 0 0 0  
425 425 20200919 NE 40387 379608   419995 185 2194         30509 A 9/18/2020 20:15 2020-09-18T20:15:00Z 09/18 16:15 442 2194 2020-09-18T20:15:00Z       40387       420291                     31 466 2954 419995 posNeg 3420 419995 0 13 2d4c032f39cb806a0f4c8bcbec431096100f0dd5 0 0 0 0 0  
426 426 20200919 NH 7920 230812   393166 8 725   230     7164 B 9/19/2020 09:00 2020-09-19T09:00:00Z 09/19 05:00 438 725 2020-09-19T09:00:00Z 393166     7920       238732 31344     30704             33 59 1155 238732 posNeg 0 238732 0 0 7b0d4bc0ad2f867a33aae0a5611ac7ba18915646 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  
444 444 20200919 VT 1710 153090   154800 3           1541 B 9/18/2020 23:59 2020-09-18T23:59:00Z 09/18 19:59 58   2020-09-18T23:59:00Z       1710 58     154800                     50 4 697 154800 posNeg 701 154800 0 0 d0b35c04784e2e162d57021fb7d47ab5ab1e275f 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  
457 457 20200918 DC 14852 332266   347118 91   24   13   11802 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 619   2020-09-17T00:00:00Z             347118 201379                     11 62 5738 347118 posNeg 5800 347118 0 0 5b5d54794bb52ea6dea82f9789c0a4b1736483ee 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  
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  
480 480 20200918 ND 17230 207963   550324 77 705 24 183     14060 B 9/18/2020 01:59 2020-09-18T01:59:00Z 09/17 21:59 142 705 2020-09-18T01:59:00Z 569913     17230 139 3 550324 225193 9164 400 8764               38 507 1516 225193 totalTestEncountersViral 9699 225193 0 14 056173ae37279c33d1df14cf27638b88e7958a5c 0 0 0 0 0  
482 482 20200918 NH 7861 229657   393166 7 725   230     7117 B 9/18/2020 09:00 2020-09-18T09:00:00Z 09/18 05:00 438 725 2020-09-18T09:00:00Z 393166     7861       237518 31344     30635             33 47 1961 237518 posNeg 9615 237518 0 0 5b1a5b8b89cecb26bf103e756f2cd913b48fbc8a 0 0 0 0 0  
489 489 20200918 OR 30342 599080   629422 145 2356 32   11   5376 A+ 9/18/2020 03:01 2020-09-18T03:01:00Z 09/17 23:01 521 2356 2020-09-18T03:01:00Z     599080 28871       627951                     41 492 3506 629422 posNeg 3998 629422 0 15 89132cc4df3967f105a8ea26c1067ea66a120410 0 0 0 0 0  
497 497 20200918 UT 61775 681962   743737 184 3444 52 848   349 50492 A+ 9/18/2020 10:05 2020-09-18T10:05:00Z 09/18 06:05 437 3444 2020-09-18T10:05:00Z 943866     61775       743737             9599 1396 13893 1486 49 1117 7442 743737 posNeg 8559 743737 0 43 0aa2780cfb4fa0d666aeaf8e3ea0e3b7e18a29ec 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  
500 500 20200918 VT 1706 152393   154099 6           1536 B 9/17/2020 23:59 2020-09-17T23:59:00Z 09/17 19:59 58   2020-09-17T23:59:00Z       1706 58     154099                     50 1 903 154099 posNeg 904 154099 0 0 6b8ab95cb171fed140875c476935ce1aaed34539 0 0 0 0 0  
504 504 20200918 WY 4747 87560   92307 16 240         4044 B 9/18/2020 16:51 2020-09-18T16:51:00Z 09/18 12:51 49 240 2020-09-18T16:51:00Z 141795 4112 137682 4009       91569                     56 95 760 92307 posNeg 855 92307 0 4 aa382d85846954b1f30212d75ea6b92d966327f8 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  
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  
511 511 20200917 CO 62686 739236   1153853 248 7288         6220 A 9/17/2020 01:59 2020-09-17T01:59:00Z 09/16 21:59 1905 7288 2020-09-17T01:59:00Z       58257     1153853 797493 164320 11393 152929               8 587 5602 801922 totalTestEncountersViral 9912 801922 0 26 6b8e92972209044359cb116a1ac8170e282d2b18 0 0 0 0 0  
514 514 20200917 DE 19318 247850   267168 66   18       10193 A+ 9/16/2020 18:00 2020-09-16T18:00:00Z 09/16 14:00 619   2020-09-16T18:00:00Z       18319 547 72   267168                     10 84 1179 267168 posNeg 1263 267168 0 0 ae64986f521647ff42e83472add3161e17297c2e 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  
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  
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  
538 538 20200917 NH 7814 227696   383551 7 725   230     7104 B 9/17/2020 09:00 2020-09-17T09:00:00Z 09/17 05:00 438 725 2020-09-17T09:00:00Z 383551     7814       235510 31215     30576             33 34 1745 235510 posNeg 0 235510 0 2 348ffc85166f5eeea7d398ec7db4dcb6107de187 0 0 0 0 0  
545 545 20200917 OR 29850 595574   625424 144 2341 32   11   5376 A+ 9/17/2020 15:01 2020-09-17T15:01:00Z 09/17 11:01 521 2341 2020-09-17T15:01:00Z     595574 28590       624164                     41 0 4151 625424 posNeg 4151 625424 0 22 b02bf38aff4a26d83319f1278dc5c29b8b17fded 0 0 0 0 0  
553 553 20200917 UT 60658 674520   735178 170 3401 54 843   348 50108 A+ 9/17/2020 10:16 2020-09-17T10:16:00Z 09/17 06:16 437 3401 2020-09-17T10:16:00Z 931331     60658       735178             9495 1377 13684 1464 49 911 4536 735178 posNeg 5447 735178 0 20 fd340e0ad1576f0ac755cf89daf67ba5004f0c5e 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  
556 556 20200917 VT 1705 151490   153195 2           1533 B 9/16/2020 23:59 2020-09-16T23:59:00Z 09/16 19:59 58   2020-09-16T23:59:00Z       1705 58     153195                     50 3 1128 153195 posNeg 1131 153195 0 0 958ccc14d1318e2550adb521c973a8bcfd17eac1 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  
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  
594 594 20200916 NH 7780 225951   383551 8 723   230     7083 B 9/16/2020 09:00 2020-09-16T09:00:00Z 09/16 05:00 438 723 2020-09-16T09:00:00Z 383551     7780       233731 31215     30515             33 32 1241 233731 posNeg 3158 233731 0 1 5599da4f9e5457d4af0ecb3d358d9c505f2fa776 0 0 0 0 0  
611 611 20200916 VI 1232 17440 10 18672             1170 D 9/15/2020 20:04 2020-09-15T20:04:00Z 09/15 16:04 19   2020-09-15T20:04:00Z 18682       19                           78 7 120 18682 posNeg 127 18672 0 0 b3f664e4ae88d35d0a896a9ac5de9a8703951f92 0 0 0 0 0  
612 612 20200916 VT 1702 150362   152064 6           1530 B 9/15/2020 23:59 2020-09-15T23:59:00Z 09/15 19:59 58   2020-09-15T23:59:00Z       1702 58     152064                     50 0 472 152064 posNeg 472 152064 0 0 34dada47f9c2d9f8389703f9ed9c28d276e01a6f 0 0 0 0 0  
616 616 20200916 WY 4566 85403   89969 16 235         3971 B 9/16/2020 18:17 2020-09-16T18:17:00Z 09/16 14:17 46 235 2020-09-16T18:17:00Z 136931 3834 133096 3866       89269                     56 128 96 89969 posNeg 224 89969 0 5 5129dc37b55ebafca36b4006811e137c2129b202 0 0 0 0 0  
617 617 20200915 AK 7313 399811   407124 44       8   2402 A 9/15/2020 03:59 2020-09-15T03:59:00Z 09/14 23:59 44   2020-09-15T03:59:00Z 407124 6637 400207 7313 44                           2 43 3668 407124 posNeg 3711 407124 0 0 b7d286bbeacaeef7cbaed188fba49cfe43c44450 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  
624 624 20200915 CT 55031 1335740   1390771 71 11357         9142 B 9/14/2020 20:30 2020-09-14T20:30:00Z 09/14 16:30 4485 11357 2020-09-14T20:30:00Z 1388507     52767 3590 895                         9 136 10647 1390771 posNeg 10783 1390771 0 0 ec1f8e01e3577ac183d756b88d61c5dc220ec1f6 0 0 0 0 0  
625 625 20200915 DC 14687 321593   336280 89   23   11   11630 A+ 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 616   2020-09-14T00:00:00Z             336280 197726                     11 65 4067 336280 posNeg 4132 336280 0 0 d272bf60dd6eb64ff7bc2ff72e66bcc7edcd720c 0 0 0 0 0  
630 630 20200915 HI 10779 251128   261907 225 638 53   31   3693 C 9/14/2020 18:00 2020-09-14T18:00:00Z 09/14 14:00 99 638 2020-09-14T18:00:00Z 352137             261907                     15 79 2297 261907 posNeg 2376 261907 0 2 dffecba6d8d1f7334a3c96781405632fa14e6a3a 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  
652 652 20200915 NM 26842 799777   826619 60 3274         14470 B 9/14/2020 17:50 2020-09-14T17:50:00Z 09/14 13:50 823 3274 2020-09-14T17:50:00Z 826619     26842                             35 81 3393 826619 posNeg 3474 826619 0 7 8fc507e9fcc68fad3ee7056d4bdb8dac5bdc6fe1 0 0 0 0 0  
662 662 20200915 SD 16994 149102   166096 133 1195         14424 A+ 9/14/2020 14:00 2020-09-14T14:00:00Z 09/14 10:00 184 1195 2020-09-14T14:00:00Z 226171             166096                     46 193 764 166096 posNeg 957 166096 0 24 b4cb662641903cdc310a652fae654db81bfff2b8 0 0 0 0 0  
665 665 20200915 UT 59000 666612   725612 178 3361 50 833   346 49327 A+ 9/15/2020 11:28 2020-09-15T11:28:00Z 09/15 07:28 436 3361 2020-09-15T11:28:00Z 915832     59000       725612             8913 1320 12385 1403 49 562 3368 725612 posNeg 3930 725612 0 23 3c2f341d30da14e05772fca09f213af2a34ce521 0 0 0 0 0  
667 667 20200915 VI 1225 17320 17 18545             1159 C 9/15/2020 06:34 2020-09-15T06:34:00Z 09/15 02:34 19   2020-09-15T06:34:00Z 18562       19                           78 4 190 18562 posNeg 194 18545 0 0 3379b5f26b9605fbd4e055aea96586ebdcbfb8d3 0 0 0 0 0  
668 668 20200915 VT 1702 149890   151592 7           1524 B 9/14/2020 23:59 2020-09-14T23:59:00Z 09/14 19:59 58   2020-09-14T23:59:00Z       1702 58     151592                     50 6 108 151592 posNeg 114 151592 0 0 b5129eef41e16a13c476631bc59b12adb5f1216a 0 0 0 0 0  
672 672 20200915 WY 4438 85307   89745 16 230         3925 B 9/15/2020 17:45 2020-09-15T17:45:00Z 09/15 13:45 46 230 2020-09-15T17:45:00Z 135476 3793 131682 3762       89069                     56 46 693 89745 posNeg 739 89745 0 0 f3014e331389a8bd82da118f1709fcfdc6722f97 0 0 0 0 0  
673 673 20200914 AK 7270 396143   403413 37       8   2377 A 9/14/2020 03:59 2020-09-14T03:59:00Z 09/13 23:59 44   2020-09-14T03:59:00Z 403413 6533 396600 7270 44                           2 77 2123 403413 posNeg 2200 403413 0 0 c47ba6fdd7b2d5856a69b861c773b64ba0dfcb76 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  
677 677 20200914 AZ 208725 1091939   1300664 489 21774 168   81   32975 A+ 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 5322 21774 2020-09-14T00:00:00Z       206775 5049 273   1300664 278029                   4 213 4314 1300664 posNeg 4527 1300664 0 1 35fb73fdb9859876cc70fb071b3ee7feba28a1d1 0 0 0 0 0  
679 679 20200914 CO 61324 723206   1124181 228 7227         6162 A+ 9/13/2020 01:59 2020-09-13T01:59:00Z 09/12 21:59 1889 7227 2020-09-13T01:59:00Z       57099     1124181 780305 163290 11326 151964               8 417 6625 784530 totalTestEncountersViral 12609 784530 0 4 5499f96fe8290a616f0bee7910a002eb68554cad 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
);