states_daily_4pm_et

Table actions

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

62 rows where "dateModified" is on date 2020-03-20

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, hospitalizedCurrently, hospitalizedCumulative, death, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, deathIncrease, dateChecked (date)

dateModified (date) ✖

  • 2020-03-20 · 62 ✖
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
10567 10567 20200322 OH 351 140   491   83             3/20/2020 14:00 2020-03-20T14:00:00Z 03/20 10:00 3 83 2020-03-20T14:00:00Z       351                             39 104 0 491 posNeg 104 491 0 25 d3d34ac0322a3216b1d53d33e58df3ba05e73bb0 0 0 0 0 0  
10591 10591 20200321 CO 363 3317   3535   44             3/20/2020 18:00 2020-03-20T18:00:00Z 03/20 14:00 4 44 2020-03-20T18:00:00Z             3535 3680                     8 86 642 3680 totalTestEncountersViral 807 3680 1 44 521bb727a0cf6194cb5df986c7a6412dc0ac3bf7 0 0 0 0 0  
10592 10592 20200321 CT 194 2106   2300                 3/20/2020 20:44 2020-03-20T20:44:00Z 03/20 16:44 4   2020-03-20T20:44:00Z                                     9 0 1502 2300 posNeg 1502 2300 1 0 06e879ac3e5055fe439b919ba88fa8ae752839ba 0 0 0 0 0  
10593 10593 20200321 DC 77 506 0 583                 3/20/2020 20:00 2020-03-20T20:00:00Z 03/20 16:00 1   2020-03-20T20:00:00Z             583                       11 6 5 583 posNeg 11 583 0 0 0023aa1bdc5d8b8a6a25d57e156f434bc2d02007 0 0 0 0 0  
10598 10598 20200321 HI 37 124   161                 3/20/2020 18:00 2020-03-20T18:00:00Z 03/20 14:00     2020-03-20T18:00:00Z                                     15 11 0 161 posNeg 11 161 0 0 6cf7dc14da605486b10ca57a688140c22951f612 0 0 0 0 0  
10600 10600 20200321 ID 31 880   911                 3/20/2020 19:00 2020-03-20T19:00:00Z 03/20 15:00     2020-03-20T19:00:00Z 911                                   16 8 290 911 posNeg 298 911 0 0 20fa49375ce9b3acce822242b27a1305e482841a 0 0 0 0 0  
10611 10611 20200321 MO 73 369   442                 3/20/2020 22:00 2020-03-20T22:00:00Z 03/20 18:00 3   2020-03-20T22:00:00Z 3455 250 3201 73                             29 26 0 442 posNeg 26 442 2 0 5fc053af6b0fc733cc4a583bf4e145290523dd1c 0 0 0 0 0  
10613 10613 20200321 MS 140 695   835                 3/20/2020 19:00 2020-03-20T19:00:00Z 03/20 15:00 1   2020-03-20T19:00:00Z                                     28 60 0 835 posNeg 60 835 0 0 e221be9f6909727ed5d11f58a72d8e1382a28486 0 0 0 0 0  
10614 10614 20200321 MT 20 1146   1166                 3/20/2020 21:24 2020-03-20T21:24:00Z 03/20 17:24     2020-03-20T21:24:00Z                                     30 4 215 1166 posNeg 219 1166 0 0 11425c8083d8e85e8d14378bbc9d9cad8e9213df 0 0 0 0 0  
10617 10617 20200321 NE 38 356   394                 3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00 0   2020-03-20T00:00:00Z                                     31 6 116 394 posNeg 122 394 0 0 7bc82e4df13171c5b754f941b21cdf05d77b8f96 0 0 0 0 0  
10618 10618 20200321 NH 55 973 942 1623                 3/20/2020 09:00 2020-03-20T09:00:00Z 03/20 05:00     2020-03-20T09:00:00Z 1623                                   33 11 228 1970 posNeg 311 1028 0 0 ec1391fe455474b806100a3d6af7c1589a69cacf 0 0 0 0 0  
10622 10622 20200321 NY 10356 35081   45437 1436 1531             3/20/2020 21:22 2020-03-20T21:22:00Z 03/20 17:22 44 1531 2020-03-20T21:22:00Z                                     36 3254 9756 45437 posNeg 13010 45437 9 1531 375c9bd3f3fad6afc7e8bb21f5ac8ef4b8739a4a 0 0 0 0 0  
10625 10625 20200321 OR 114 2003 433 2117                 3/20/2020 11:00 2020-03-20T11:00:00Z 03/20 07:00 3   2020-03-20T11:00:00Z                                     41 0 0 2550 posNeg 0 2117 0 0 9b5160c43ad8eeb51f35b40becf4510d6ea6370a 0 0 0 0 0  
10629 10629 20200321 SC 152 1255   1407                 3/20/2020 16:45 2020-03-20T16:45:00Z 03/20 12:45 1   2020-03-20T16:45:00Z       152                             45 71 422 1407 posNeg 493 1407 0 0 5baeaf94f0817ee2fb6cc84947248a8997360952 0 0 0 0 0  
10631 10631 20200321 TN 371 3272   3643                 3/20/2020 22:48 2020-03-20T22:48:00Z 03/20 18:48     2020-03-20T22:48:00Z                                     47 143 2709 3643 posNeg 2852 3643 0 0 e6961761d43c8536462695858fa95992f94130e0 0 0 0 0 0  
10635 10635 20200321 VI 6     6                 3/20/2020 20:30 2020-03-20T20:30:00Z 03/20 16:30     2020-03-20T20:30:00Z                                     78 3 0 6 posNeg 3 6 0 0 74deacd22056ad300bc35e9009f3091f29eea219 0 0 0 0 0  
10641 10641 20200320 AK 12 686   698                 3/20/2020 16:30 2020-03-20T16:30:00Z 03/20 12:30 0   2020-03-20T16:30:00Z 698     12                             2 6 254 698 posNeg 260 698 0 0 bdcea434c0c29a5950f6e2ffb9ade590506f4e06 0 0 0 0 0  
10642 10642 20200320 AL 81 28   109                 3/20/2020 11:00 2020-03-20T11:00:00Z 03/20 07:00 0   2020-03-20T11:00:00Z 109     81                             1 13 0 109 posNeg 13 109 0 0 5c4c4c3d660ee47148459c3e914140ffecdfdad6 0 0 0 0 0  
10643 10643 20200320 AR 96 351 203 447                 3/20/2020 14:19 2020-03-20T14:19:00Z 03/20 10:19     2020-03-20T14:19:00Z 447     96                             5 50 41 650 posNeg 91 447 0 0 0433b7888ed4dcef90a4e8079a39641cc37d723a 0 0 0 0 0  
10645 10645 20200320 AZ 65 211 101 276   108             3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00 0 108 2020-03-20T00:00:00Z               276                     4 21 36 377 posNeg 57 276 0 23 453429d0fcc9721be354fd7113419580d3121e1c 0 0 0 0 0  
10646 10646 20200320 CA 1063 10424   11487                 3/20/2020 14:41 2020-03-20T14:41:00Z 03/20 10:41 20   2020-03-20T14:41:00Z 11487                                   6 139 1637 11487 posNeg 1776 11487 2 0 6e10fe6f0f4e748fc78cd48526b7e833d1024c43 0 0 0 0 0  
10647 10647 20200320 CO 277 2675   2728                 3/20/2020 14:42 2020-03-20T14:42:00Z 03/20 10:42 3   2020-03-20T14:42:00Z             2728 2952                     8 61 563 2952 totalTestEncountersViral 524 2952 1 0 4518e1ff9333158286183cbd1a97a51dbe2d09ca 0 0 0 0 0  
10648 10648 20200320 CT 194 604   798                 3/20/2020 15:30 2020-03-20T15:30:00Z 03/20 11:30 3   2020-03-20T15:30:00Z                                     9 98 0 798 posNeg 98 798 2 0 fe430da5aa23c0665713f7f2b9cf7ad3c4444050 0 0 0 0 0  
10649 10649 20200320 DC 71 501 1 572                 3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00 1   2020-03-20T00:00:00Z             572                       11 32 348 573 posNeg 380 572 1 0 4c2271c2915396340e2d2ddb72b03821011116c0 0 0 0 0 0  
10650 10650 20200320 DE 38 36   74                 3/20/2020 10:00 2020-03-20T10:00:00Z 03/20 06:00 0   2020-03-20T10:00:00Z         0 0                         10 8 0 74 posNeg 8 74 0 0 5f7e98cabb13401330531f58dcf047964a16e752 0 0 0 0 0  
10651 10651 20200320 FL 520 1870 1026 2390                 3/20/2020 11:00 2020-03-20T11:00:00Z 03/20 07:00 10   2020-03-20T11:00:00Z                                     12 130 337 3416 posNeg 467 2390 2 0 0efca2b71dcaa299b859b601fa42571eaaabe11a 0 0 0 0 0  
10652 10652 20200320 GA 420 1966   2386                 3/20/2020 12:00 2020-03-20T12:00:00Z 03/20 08:00 13   2020-03-20T12:00:00Z 2386                                   13 133 422 2386 posNeg 555 2386 3 0 d2a7b5bd4c4e0a3008a3974d184f5031b5cd03f2 0 0 0 0 0  
10653 10653 20200320 GU 14 86   100                 3/20/2020 05:15 2020-03-20T05:15:00Z 03/20 01:15     2020-03-20T05:15:00Z                                     66 2 17 100 posNeg 19 100 0 0 fb736c9abb111f61b69e07167dda3b27727c0655 0 0 0 0 0  
10655 10655 20200320 IA 45 642   687                 3/20/2020 16:15 2020-03-20T16:15:00Z 03/20 12:15     2020-03-20T16:15:00Z       45                             19 7 559 687 posNeg 566 687 0 0 508ecb49acde9cc5c7f009d5109d1d11ec7da6a8 0 0 0 0 0  
10657 10657 20200320 IL 585 3696   4281                 3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00 5   2020-03-20T00:00:00Z                                     17 163 971 4281 posNeg 1134 4281 1 0 ec8f0a2a688cc75de5d5b19d60a97d078d0f94cb 0 0 0 0 0  
10658 10658 20200320 IN 79 475   554                 3/20/2020 00:59 2020-03-20T00:59:00Z 03/19 20:59 2   2020-03-20T00:59:00Z                                     18 23 151 554 posNeg 174 554 0 0 1b6c51c4ef62888d89a438937560808f629b2883 0 0 0 0 0  
10659 10659 20200320 KS 44 417   461                 3/20/2020 11:00 2020-03-20T11:00:00Z 03/20 07:00 1   2020-03-20T11:00:00Z                                     20 10 0 461 posNeg 10 461 0 0 05f4ae3a8db8ddb93801b90b5aa7d7465b1f9d47 0 0 0 0 0  
10661 10661 20200320 LA 473 568   1041                 3/20/2020 15:30 2020-03-20T15:30:00Z 03/20 11:30 12   2020-03-20T15:30:00Z       473                             22 126 110 1041 posNeg 236 1041 4 0 194066c800460347a9e6c754058217074af6c37d 0 0 0 0 0  
10662 10662 20200320 MA 314 3795   19384                 3/20/2020 16:00 2020-03-20T16:00:00Z 03/20 12:00 5   2020-03-20T16:00:00Z 19384 1730                                 25 85 877 4109 totalTestsViral 3875 4109 2 0 01191a56b6effc266a13d972f92360149d36a934 0 0 0 0 0  
10663 10663 20200320 MD 149 94   243                 3/20/2020 10:00 2020-03-20T10:00:00Z 03/20 06:00 3   2020-03-20T10:00:00Z       149 3                           24 42 0 243 posNeg 42 243 1 0 99bba0675f32f4b7c85e289c143f57dd1268ea87 0 0 0 0 0  
10664 10664 20200320 ME 57 2264   2321                 3/20/2020 11:00 2020-03-20T11:00:00Z 03/20 07:00     2020-03-20T11:00:00Z       57                             23 4 260 2321 posNeg 264 2321 0 0 4b2967c0c269a15b877f78b4dc3703c37c359864 0 0 0 0 0  
10665 10665 20200320 MI 6219 3041   9260                 3/20/2020 15:00 2020-03-20T15:00:00Z 03/20 11:00 13   2020-03-20T15:00:00Z 3845 804 3041 6150 20 2                         26 943 990 9260 posNeg 1933 9260 3 0 c6c0b30d85ffbefe317a09e9b08d7c653476148c 0 0 0 0 0  
10666 10666 20200320 MN 303 3741   4044                 3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00     2020-03-20T00:00:00Z       303     4044                       27 16 792 4044 posNeg 808 4044 0 0 481d503fb91296c21cb9c89a04d4600c8c165ac1 0 0 0 0 0  
10668 10668 20200320 MP 0     0                 3/20/2020 01:30 2020-03-20T01:30:00Z 03/19 21:30 0   2020-03-20T01:30:00Z                                     69 0 0 0 posNeg 0 0 0 0 131b0e810467954035aa570d229b3508496040cb 0 0 0 0 0  
10669 10669 20200320 MS 80 695   775                 3/20/2020 11:35 2020-03-20T11:35:00Z 03/20 07:35 1   2020-03-20T11:35:00Z                                     28 30 143 775 posNeg 173 775 1 0 a528ffb582429e181f185af6f1f3721b34dc7a94 0 0 0 0 0  
10671 10671 20200320 NC 137 3096   3233                 3/20/2020 09:35 2020-03-20T09:35:00Z 03/20 05:35 0   2020-03-20T09:35:00Z                                     37 40 688 3233 posNeg 728 3233 0 0 944ef25eed28e15ae1451fac91f41c2f43d91664 0 0 0 0 0  
10672 10672 20200320 ND 20 800   764                 3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00 0   2020-03-20T00:00:00Z 778     20     764 748                     38 5 307 820 totalTestEncountersViral 293 820 0 0 d305b1ed76462d6bf8a1bc88f33f5cd2954e8968 0 0 0 0 0  
10675 10675 20200320 NJ 890 264 86 1154                 3/20/2020 13:30 2020-03-20T13:30:00Z 03/20 09:30 16   2020-03-20T13:30:00Z       890 11 5   1154                     34 148 54 1240 posNeg 202 1154 3 0 ee688413da20a1a8c2f5c7e84c07e8d5a2215064 0 0 0 0 0  
10676 10676 20200320 NM 43 3771   3814                 3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00     2020-03-20T00:00:00Z                                     35 8 1009 3814 posNeg 1017 3814 0 0 cbbb0ab17a8c0ec4cbde3544e9a366a21f5f8e21 0 0 0 0 0  
10677 10677 20200320 NV 109 1992   2101                 3/20/2020 02:59 2020-03-20T02:59:00Z 03/19 22:59 3   2020-03-20T02:59:00Z       109                             32 8 366 2101 posNeg 374 2101 0 0 afcf22a98a2222957e4b9ea4aa8e944d57c4c47c 0 0 0 0 0  
10678 10678 20200320 NY 7102 25325   32427 1042               3/20/2020 13:20 2020-03-20T13:20:00Z 03/20 09:20 35   2020-03-20T13:20:00Z                                     36 2950 7193 32427 posNeg 10143 32427 23 0 e7aafebcdde573c97faef6c2afab2c374cc29334 0 0 0 0 0  
10679 10679 20200320 OH 169 140   309                 3/20/2020 14:00 2020-03-20T14:00:00Z 03/20 10:00 1   2020-03-20T14:00:00Z       169                             39 50 0 309 posNeg 50 309 1 0 1f084055603752d6349d245e648244ad4dbd536b 0 0 0 0 0  
10680 10680 20200320 OK 49 538 374 587                 3/20/2020 08:00 2020-03-20T08:00:00Z 03/20 04:00 1   2020-03-20T08:00:00Z                                     40 5 72 961 posNeg 77 587 0 0 28497777984f2c7598336066b047ff66fb101c7b 0 0 0 0 0  
10681 10681 20200320 OR 114 2003 433 2117                 3/20/2020 11:00 2020-03-20T11:00:00Z 03/20 07:00 3   2020-03-20T11:00:00Z                                     41 26 674 2550 posNeg 700 2117 0 0 f45043cbec7094b1043c5991a130c12576d8223c 0 0 0 0 0  
10682 10682 20200320 PA 268 2574   2842                 3/20/2020 12:00 2020-03-20T12:00:00Z 03/20 08:00 1   2020-03-20T12:00:00Z               2842                     42 83 966 2842 posNeg 1049 2842 0 0 fa131d2aa084370fc7bf6649091cbf189b1fc8ba 0 0 0 0 0  
10683 10683 20200320 PR 14 114 52 128                 3/20/2020 13:00 2020-03-20T13:00:00Z 03/20 09:00     2020-03-20T13:00:00Z                                     72 9 58 180 posNeg 67 128 0 0 75664e2552d353ea1498a0b765ae0a19674ff8ab 0 0 0 0 0  
10684 10684 20200320 RI 74 1161 140 1075                 3/20/2020 03:00 2020-03-20T03:00:00Z 03/19 23:00     2020-03-20T03:00:00Z 1296 84 1212 74     1075 1235                     44 13 193 1375 totalTestEncountersViral 277 1235 0 0 bd4f28aed4b0d0e88b7810e11a4b6d92e7a5dfd6 0 0 0 0 0  
10686 10686 20200320 SD 14 663 270 677                 3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00 1   2020-03-20T00:00:00Z               677                     46 3 112 947 posNeg 115 677 0 0 50d5b4be4079db3452cd22f0d7039ffc918cf82a 0 0 0 0 0  
10687 10687 20200320 TN 228 563   791                 3/20/2020 15:00 2020-03-20T15:00:00Z 03/20 11:00     2020-03-20T15:00:00Z                                     47 74 214 791 posNeg 288 791 0 0 51316144367603c1dee2e21141cd20c9ae4522f4 0 0 0 0 0  
10688 10688 20200320 TX 194 5083   5277                 3/20/2020 13:00 2020-03-20T13:00:00Z 03/20 09:00 5   2020-03-20T13:00:00Z       194                             48 51 2871 5277 posNeg 2922 5277 2 0 d45cdcfcefc5181bb7e93bb2fe55508a231e2532 0 0 0 0 0  
10689 10689 20200320 UT 112 2035   2147                 3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00 0   2020-03-20T00:00:00Z       112                             49 34 587 2147 posNeg 621 2147 0 0 f44486499e87adee02168dae14c559abde792d3e 0 0 0 0 0  
10690 10690 20200320 VA 114 2211   8393                 3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00 2   2020-03-20T00:00:00Z   2253         8393                       51 20 382 2325 posNeg 593 2325 0 0 3ddd4b719d989fa4f1e34b21b6a0783fbe6cd405 0 0 0 0 0  
10692 10692 20200320 VT 44 957   1001                 3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00 2   2020-03-20T00:00:00Z                                     50 16 193 1001 posNeg 209 1001 2 0 fed98e402621da72b8abda016dc7799a556edaed 0 0 0 0 0  
10693 10693 20200320 WA 2771 40505   43276                 3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00 104   2020-03-20T00:00:00Z       2771     43276 42505                     53 303 3817 43276 posNeg 4120 43276 12 0 c052f4053e524f71575e97a7aa75f35b6fc976b2 0 0 0 0 0  
10694 10694 20200320 WI 235 3455   3690                 3/20/2020 16:00 2020-03-20T16:00:00Z 03/20 12:00 3   2020-03-20T16:00:00Z       206                             55 61 1263 3690 posNeg 1324 3690 3 0 999191d9ba6b641df2a7e9165ddbf2ee2b72dcfe 0 0 0 0 0  
10695 10695 20200320 WV 7 219 13 226                 3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00 0   2020-03-20T00:00:00Z       7                             54 5 76 239 posNeg 81 226 0 0 d78fb38b09caae0f0d410080d06d80c3364f273c 0 0 0 0 0  
10696 10696 20200320 WY 19 331   350                 3/20/2020 13:30 2020-03-20T13:30:00Z 03/20 09:30     2020-03-20T13:30:00Z       18                             56 1 60 350 posNeg 61 350 0 0 64a2c611bbb72e6fb978ab46ce3b449c9bc3559d 0 0 0 0 0  

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