states_daily_4pm_et

Table actions

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

11,578 rows

✎ 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
201 201 20200923 NE 41785 389317   431102 197 2214         31212 A 9/22/2020 20:10 2020-09-22T20:10:00Z 09/22 16:10 461 2214 2020-09-22T20:10:00Z 580140     41785       431401                     31 397 2659 431102 posNeg 3056 431102 9 6 0e13b9b23a5d3735181e9d4e91f3dd5c38b0d61a 0 0 0 0 0  
202 202 20200923 NH 8007 236482   413391 17 728   230     7303 B 9/23/2020 09:00 2020-09-23T09:00:00Z 09/23 05:00 438 728 2020-09-23T09:00:00Z 413391     8007       244489 31557     30839             33 17 945 244489 posNeg 2925 244489 0 1 bdc274f7dd8d090cd62cec3f98303151a89c9f37 0 0 0 0 0  
203 203 20200923 NJ 200988 3221759   3422747 459 23215 90   31   34729 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 16082 23215 2020-09-23T00:00:00Z 3422747     200988 14291 1791                         34 408 24690 3422747 posNeg 25098 3422747 6 45 92c8ee2bfc81236413a9d6a9bdd8bf803bd15e3e 0 0 0 0 0  
204 204 20200923 NM 27790 844541   872331 69 3371         15586 C 9/22/2020 17:12 2020-09-22T17:12:00Z 09/22 13:12 854 3371 2020-09-22T17:12:00Z 872331     27790                             35 107 5541 872331 posNeg 5648 872331 3 13 ec22d7acf556db7867dc9b91942a0a7e6199b12d 0 0 0 0 0  
205 205 20200923 NV 76807 595117   671924 479   134   69   2059 A+ 9/23/2020 02:59 2020-09-23T02:59:00Z 09/22 22:59 1556   2020-09-23T02:59:00Z 996307     76807       670908                     32 509 2341 671924 posNeg 2850 671924 10 0 47d7118e5f6b480397adba20fe0cdaeb0d36e6d5 0 0 0 0 0  
206 206 20200923 NY 451892 9683800   10135692 490 89995 141   68   76306 A 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 25437 89995 2020-09-22T23:59:00Z       451892     10135692                       36 665 70265 10135692 posNeg 70930 10135692 5 0 73a23ab7c0b6b78e67d67b6925fc08a799485733 0 0 0 0 0  
207 207 20200923 OH 146753 2784446   2931199 593 14977 200 3218 113   126023 A+ 9/23/2020 14:00 2020-09-23T14:00:00Z 09/23 10:00 4687 14977 2020-09-23T14:00:00Z 2923158     138712 4387 300                         39 903 41509 2931199 posNeg 42412 2931199 52 78 2d9e1a6bf4a2598b57f9a3d554613fc62cfc0ac1 0 0 0 0 0  
208 208 20200923 OK 80161 1034165 6067 1114326 612 6057 226       66779 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 970 6057 2020-09-23T00:00:00Z 1127633 91214 1034165 80161         76497 3764                 40 1089 11398 1120393 posNeg 12487 1114326 8 61 7dba4d79cd71bc996f8f50153d1fc4d8a407f53e 0 0 0 0 0  
209 209 20200923 OR 31503 614622   646125 188 2438 45   16   5475 A+ 9/23/2020 03:01 2020-09-23T03:01:00Z 09/22 23:01 538 2438 2020-09-23T03:01:00Z     614622 29948       644570                     41 190 3354 646125 posNeg 3544 646125 6 19 23b1d6c09988cb0f3b5d89fa439ffbc615e1e40a 0 0 0 0 0  
210 210 20200923 PA 152544 1790412   1942956 421       54   123560 A+ 9/23/2020 12:00 2020-09-23T12:00:00Z 09/23 08:00 8062   2020-09-23T12:00:00Z 2809305     147862       1938274                     42 898 12496 1942956 posNeg 13394 1942956 39 0 3f5a6abc7bba96c41e5b1bec3d83c98576cc6d95 0 0 0 0 0  
211 211 20200923 PR 42660 305972   348632 376   63   36     C 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 617   2020-09-23T00:00:00Z 310546 7002 303412 20439 447 170       22221                 72 64 0 348632 posNeg 64 348632 4 0 6c1a0e3b87f8748333302c3a12211220b41bee6e 0 0 0 0 0  
212 212 20200923 RI 24177 300943   706578 86 2713 9   5   2275 A+ 9/23/2020 12:00 2020-09-23T12:00:00Z 09/23 08:00 1102 2713 2020-09-23T12:00:00Z   33952 672626 24177     706578 325120                     44 133 2596 325120 totalTestEncountersViral 9770 325120 3 9 619de2d19bf56b44041c7b6d6fbed07b54816f4c 0 0 0 0 0  
213 213 20200923 SC 141686 1048898   1190584 786 8906 190   103   67491 A+ 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 3262 8906 2020-09-22T23:59:00Z 1187069 176559 1010510 138171 3085 177     69484 6470 63014           34200 9523 45 897 17203 1190584 posNeg 18100 1190584 19 55 a2413f171c4771da291c2b1a9c024c46392d5454 0 0 0 0 0  
214 214 20200923 SD 19634 160498   180132 192 1367         16324 A 9/22/2020 14:00 2020-09-22T14:00:00Z 09/22 10:00 202 1367 2020-09-22T14:00:00Z 250393             180132                     46 445 1341 180132 posNeg 1786 180132 0 44 0b9b24e3e38af8930d497fead940060bba18ffa9 0 0 0 0 0  
215 215 20200923 TN 186709 2526634   2713343 919 8338 286   114   169649 A+ 9/23/2020 15:00 2020-09-23T15:00:00Z 09/23 11:00 2275 8338 2020-09-23T15:00:00Z 2706717 219892 2486825 180083 2192 83                         47 1561 20378 2713343 posNeg 21939 2713343 14 75 f1d4ec7e99211a7a99ff77c068a85a26d56bdb07 0 0 0 0 0  
216 216 20200923 TX 719599 5021075   5740674 3195   1041       618054 A 9/23/2020 18:15 2020-09-23T18:15:00Z 09/23 14:15 15129   2020-09-23T18:15:00Z 5740674     719599         390538 35217             76275 9003 48 3392 69550 5740674 posNeg 72942 5740674 135 0 b782ae3cef51213c4192af8df10043e5459198fc 0 0 0 0 0  
217 217 20200923 UT 65921 709937   775858 190 3584 65 876   354 52357 A+ 9/23/2020 10:39 2020-09-23T10:39:00Z 09/23 06:39 444 3584 2020-09-23T10:39:00Z 993246     65921       775858             11768 1661 19120 1760 49 877 6022 775858 posNeg 6899 775858 1 34 533f79e51b72a89e18727bcef40b18d08ed5fda6 0 0 0 0 0  
218 218 20200923 VA 142590 1786980 298 1922606 916 17954 215   113   17038 A+ 9/22/2020 17:00 2020-09-22T17:00:00Z 09/22 13:00 3089 17954 2020-09-22T17:00:00Z   161672   135626 2882 207 1922606                       51 580 10501 1929868 posNeg 11026 1929570 29 35 96e4c34c318a0aca652c7411d5e196245393ff5a 0 0 0 0 0  
219 219 20200923 VI 1278 18340 7 19618             1198 D 9/22/2020 20:33 2020-09-22T20:33:00Z 09/22 16:33 19   2020-09-22T20:33:00Z 19625       19                           78 2 152 19625 posNeg 154 19618 0 0 7012dc1e4b73977908c498ce51625ee7d0f9f788 0 0 0 0 0  
220 220 20200923 VT 1722 155541   157263 2           1565 B 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 58   2020-09-22T23:59:00Z       1722 58     157263                     50 1 -79 157263 posNeg -78 157263 0 0 1fa2a67f67ae200bdf335fa8f4ff5f99f677857c 0 0 0 0 0  
221 221 20200923 WA 83193 1657706   1740899 277 7314     32     B 9/22/2020 02:59 2020-09-22T02:59:00Z 09/21 22:59 2070 7314 2020-09-22T02:59:00Z       83193 2070   1740899                       53 0 0 1740899 posNeg 0 1740899 0 0 7970bca4445cb328bfd49535798ea65bac25b905 0 0 0 0 0  
222 222 20200923 WI 112222 1360183 198 1472405 509 6821 140 998     89393 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 1268 6821 2020-09-23T00:00:00Z       105932 1259 9   1466115                     55 1895 11691 1472603 posNeg 13586 1472405 9 56 8ab0368173942bcf4e1563bd6cb1dc36e26b74e1 0 0 0 0 0  
223 223 20200923 WV 14504 511076   525580 163   61   31   10721 C 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 319   2020-09-22T23:59:00Z 525236     14160 317 2     17036                   54 120 2791 525580 posNeg 2911 525580 2 0 6914ad52b6f6531fce35b2bfcace63f8b93e3347 0 0 0 0 0  
224 224 20200923 WY 5169 89824   94993 21 253         4277 B 9/23/2020 17:25 2020-09-23T17:25:00Z 09/23 13:25 50 253 2020-09-23T17:25:00Z 149060 4322 144737 4368       94055                     56 153 0 94993 posNeg 153 94993 1 0 16decf14600a8fdba04b4b8d6953934532cfc927 0 0 0 0 0  
225 225 20200922 AK 7886 423305   431191 43       14   2668 A 9/22/2020 03:59 2020-09-22T03:59:00Z 09/21 23:59 45   2020-09-22T03:59:00Z 431191 7147 423762 7886 45                           2 48 2498 431191 posNeg 2546 431191 0 0 24135b606b72e9c822c662be4c07b364d622accd 0 0 0 0 0  
226 226 20200922 AL 146584 933565   1065553 796 16604   1659   910 61232 A 9/22/2020 11:00 2020-09-22T11:00:00Z 09/22 07:00 2457 16604 2020-09-22T11:00:00Z 1065553     131988 2304 153           57042             1 804 5453 1080149 posNeg 6036 1080149 18 117 536eaa13e29a33e56ab8f49589c94d7bd8cd3164 0 0 0 0 0  
227 227 20200922 AR 76981 823225   897997 453 5055 234   87 638 69184 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 1209 5055 2020-09-22T00:00:00Z 897997   823225 74772 1060 149                 10427 2387 21856 3300 5 617 5987 900206 posNeg 6473 900206 12 69 23ebdd8ed12a95784875ca7899fc5d37df6a2fb3 0 0 0 0 0  
228 228 20200922 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 1fbce7d9c6b9b287e0974b92a27198573fb8ecdf 0 0 0 0 0  
229 229 20200922 AZ 214846 1185808   1396418 527 21900 122   47   34053 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 5498 21900 2020-09-22T00:00:00Z       210610 5230 268   1396418 284225                   4 595 9097 1400654 posNeg 9791 1400654 20 22 105d76a8129766df7ef555a53810ba8ef0dc8f4a 0 0 0 0 0  
230 230 20200922 CA 784324 13019731   13804055 3520   923         B 9/22/2020 02:59 2020-09-22T02:59:00Z 09/21 22:59 15071   2020-09-22T02:59:00Z 13804055     784324                             6 2630 128643 13804055 posNeg 131273 13804055 53 0 0997db487384449fe22a0cf5bfe0fea7cfe83c58 0 0 0 0 0  
231 231 20200922 CO 65399 773485   1219137 239 7373         6306 A 9/21/2020 01:59 2020-09-21T01:59:00Z 09/20 21:59 1914 7373 2020-09-21T01:59:00Z       60792     1219137 834277 166809 11624 155187               8 542 5633 838884 totalTestEncountersViral 10712 838884 1 10 acbe7e6b873d2efee74c91deb30171e27b8cb2ff 0 0 0 0 0  
232 232 20200922 CT 56160 1423664   1479824 70 11447         9204 B 9/21/2020 20:30 2020-09-21T20:30:00Z 09/21 16:30 4496 11447 2020-09-21T20:30:00Z 1477478     53814 3601 895                         9 136 11922 1479824 posNeg 12058 1479824 1 0 b8dd2fbc5a87443d589427bb8b6b1a8d1f407112 0 0 0 0 0  
233 233 20200922 DC 15021 346612   361633 95   22   19   11886 A+ 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 621   2020-09-21T00:00:00Z             361633 206165                     11 43 3846 361633 posNeg 3889 361633 0 0 1b8393e382202f7c98f35792436e9a7e0bee0e5c 0 0 0 0 0  
234 234 20200922 DE 19761 255076   274837 62   14       10411 A+ 9/21/2020 18:00 2020-09-21T18:00:00Z 09/21 14:00 628   2020-09-21T18:00:00Z       18733 551 77   274837                     10 94 1530 274837 posNeg 1624 274837 1 0 5adfc831fe103379582c1d7147434ebda54e5eeb 0 0 0 0 0  
235 235 20200922 FL 687909 4444433 3950 5132342 2319 43261           A 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 13579 43261 2020-09-21T23:59:00Z 7209122 885350 6282680 687909 13579     5139472 505164 45080 460024 493810 44075 449702   14977     12 2470 16612 5136292 posNeg 19082 5132342 99 228 1af196871ff34e868be4d56f373a83a08660462c 0 0 0 0 0  
236 236 20200922 GA 308221 2475206   2783427 1960 27490   5026       A 9/22/2020 14:50 2020-09-22T14:50:00Z 09/22 10:50 6677 27490 2020-09-22T14:50:00Z 2783427 286876 2496551 308221         296044 24217                 13 882 11682 2783427 posNeg 12564 2783427 73 96 9ea1088e3046540b8d86a05ad9eb053272185613 0 0 0 0 0  
237 237 20200922 GU 2190 44638   46828 39   15       1507 A 9/22/2020 05:00 2020-09-22T05:00:00Z 09/22 01:00 37   2020-09-22T05:00:00Z 46826     2190       46828 175 3                 66 43 431 46828 posNeg 474 46828 2 0 523d2166c95d1ed8aa2277f30ce21a4bccd1d7ea 0 0 0 0 0  
238 238 20200922 HI 11459 271121   282580 185 735 51   40   4888 B 9/21/2020 18:00 2020-09-21T18:00:00Z 09/21 14:00 120 735 2020-09-21T18:00:00Z 387200             282580                     15 56 1106 282580 posNeg 1162 282580 0 5 5d5a472d13f94d80f482a071d5f0bac22bc77458 0 0 0 0 0  
239 239 20200922 IA 78887 646195   725082 285   72   34   59216 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 1286   2020-09-22T00:00:00Z       78887       726620       56190 3339 52811 18946 2416     19 548 2939 725082 posNeg 3487 725082 12 0 85b8765176c3738dde4329e336257ca667ee04e9 0 0 0 0 0  
240 240 20200922 ID 37901 256170   290911 130 1726 39 446     20485 A 9/21/2020 19:00 2020-09-21T19:00:00Z 09/21 15:00 447 1726 2020-09-21T19:00:00Z 290911     34741 409 38                         16 410 1375 294071 posNeg 1748 294071 4 8 1a603f1797ebcd309b94a231012b903983916480 0 0 0 0 0  
241 241 20200922 IL 279464 4907950   5187414 1455   367   153     A 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 8722   2020-09-22T00:00:00Z 5185216     277266 8486 236                         17 1531 40298 5187414 posNeg 41829 5187414 29 0 b6f9bcb423a5a7b482e8705c7adb5902253e03f2 0 0 0 0 0  
242 242 20200922 IN 112626 1202814   1315440 759 12265 254 2439 79   89072 A+ 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 3520 12265 2020-09-21T23:59:00Z 1898563       3295 225   1315440                     18 599 6196 1315440 posNeg 6795 1315440 8 81 4ce08e401d4c61d1d124d2701ad73082342661bf 0 0 0 0 0  
243 243 20200922 KS 53959 430732   484691 216 2706 60 741 23 230 1970 A+ 9/21/2020 10:00 2020-09-21T10:00:00Z 09/21 06:00 600 2706 2020-09-21T10:00:00Z               484691                     20 0 0 484691 posNeg 0 484691 0 0 1cb8188417c637e2d2fb55352f83395bab168be2 0 0 0 0 0  
244 244 20200922 KY 62731 1012889   1068466 511 5075 133 1494     11361 B 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 1119 5075 2020-09-22T00:00:00Z 1068466     55577 1110 9     52158               21407   21 814 9402 1075620 posNeg 9983 1075620 7 24 10b41b6eb13fe4b0c1e4f9e880cfaf5be7cfae20 0 0 0 0 0  
245 245 20200922 LA 163253 2043721   2206974 571       96   145570 A 9/22/2020 13:00 2020-09-22T13:00:00Z 09/22 09:00 5386   2020-09-22T13:00:00Z       162214 5218 168   2205935                     22 752 20430 2206974 posNeg 21182 2206974 11 0 baf9e173a10d54222f081d7fc06de8be1125960e 0 0 0 0 0  
246 246 20200922 MA 127969 1979312   3476679 371 12571 67   27   109397 A+ 9/22/2020 08:00 2020-09-22T08:00:00Z 09/22 04:00 9328 12571 2020-09-22T08:00:00Z 3476679 165412   125866 9118 210   2105178       118447     120496       25 173 8992 2107281 totalTestsViral 40518 2107281 11 18 f30290af9e5b34d854f95446862ead2c55efefb1 0 0 0 0 0  
247 247 20200922 MD 120912 1423102   1544014 309 15237 77       7394 A 9/22/2020 10:00 2020-09-22T10:00:00Z 09/22 06:00 3895 15237 2020-09-22T10:00:00Z 2422067 144660   120912 3748 147   1544014                     24 344 6041 1544014 posNeg 6385 1544014 12 66 bedcf99b6c22f302a374143fc9d1850ef21305dd 0 0 0 0 0  
248 248 20200922 ME 5146 370286   375432 17 442 4   0   4407 A+ 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 140 442 2020-09-21T23:59:00Z 385507 6396 378826 4617 139 1     10205 515 9676               23 40 0 375432 posNeg 40 375432 0 2 e31a828b33a25b7e12de2ed6a09c651802c5b9bc 0 0 0 0 0  
249 249 20200922 MI 130357 3260521   3390878 501   146   56   90216 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 6997   2020-09-22T00:00:00Z 3425958 165437 3260521 117910 6680 317     285455                   26 695 19516 3390878 posNeg 20211 3390878 16 0 d9ea925bffd34bd7ae8bc315c33a56167d99ea05 0 0 0 0 0  
250 250 20200922 MN 91422 1226011   1863694 290 7253 136 2027     82833 A 9/21/2020 17:00 2020-09-21T17:00:00Z 09/21 13:00 2031 7253 2020-09-21T17:00:00Z       91422 1979 52 1863694 1317433                     27 480 4016 1317433 posNeg 8386 1317433 10 54 56118ea7ee0df16bc167138e94e47ef52f3c1ed7 0 0 0 0 0  
251 251 20200922 MO 115366 1126383   1241749 981             B 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 1864   2020-09-22T00:00:00Z 1628323 122668 1502893 115366       1241749       73015 3368 69647         29 1059 21131 1241749 posNeg 22190 1241749 57 0 0a1cdcf2a179b4f4e291517c73786fa067ed6be9 0 0 0 0 0  
252 252 20200922 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 0 0 14385 posNeg 0 14385 0 0 b2b70beaa641ee9432bb4e9d068498aa2482c650 0 0 0 0 0  
253 253 20200922 MS 94021 618480   712501 642 5607 147   74   85327 A+ 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 2846 5607 2020-09-21T00:00:00Z 706009     87529 2625 221     37439 95             50385   28 465 5130 712501 posNeg 5595 712501 36 0 ad7f4d4ef8a803de50c303999260e6d7f99a76ee 0 0 0 0 0  
254 254 20200922 MT 10700 303309   314009 111 584         7937 C 9/22/2020 01:59 2020-09-22T01:59:00Z 09/21 21:59 163 584 2020-09-22T01:59:00Z 314009     10700                             30 271 2476 314009 posNeg 2747 314009 3 8 508e06d3fbff288cfb26b77bfeba4391db991668 0 0 0 0 0  
255 255 20200922 NC 195549 2629380   2824929 905   277       176422 A+ 9/22/2020 12:05 2020-09-22T12:05:00Z 09/22 08:05 3286   2020-09-22T12:05:00Z 2824929     195549 3286                           37 1168 6222 2824929 posNeg 7390 2824929 39 0 f4ca81f0e678845338f669e8adc6ea0615b0d98d 0 0 0 0 0  
256 256 20200922 ND 18508 211562   568540 92 752 26 192     15220 B 9/22/2020 01:59 2020-09-22T01:59:00Z 09/21 21:59 156 752 2020-09-22T01:59:00Z 588751     18508 153 3 568540 230070 9240 407 8833               38 264 295 230070 totalTestEncountersViral 2697 230070 5 22 3a3b0330f7731f0d57f1b38bebdc780c85a7c225 0 0 0 0 0  
257 257 20200922 NE 41388 386658   428046 185 2208         31047 A 9/21/2020 20:15 2020-09-21T20:15:00Z 09/21 16:15 452 2208 2020-09-21T20:15:00Z 575663     41388       428341                     31 305 1925 428046 posNeg 2230 428046 10 14 c615677353b2deb442433568311259aa4a254500 0 0 0 0 0  
258 258 20200922 NH 7990 235537   410466 11 727   230     7259 B 9/22/2020 09:00 2020-09-22T09:00:00Z 09/22 05:00 438 727 2020-09-22T09:00:00Z 410466     7990       243527 31505     30781             33 38 1247 243527 posNeg 3133 243527 0 1 5675ff846845212d122d51d8a7363f8681124fcd 0 0 0 0 0  
259 259 20200922 NJ 200580 3197069   3397649 417 23170 80   34   34697 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 16076 23170 2020-09-22T00:00:00Z 3397649     200580 14285 1791                         34 426 44040 3397649 posNeg 44466 3397649 7 35 bcc1a2c6975fbd7ce5c822ebbfb99bcff138e2e7 0 0 0 0 0  
260 260 20200922 NM 27683 839000   866683 71 3358         15518 B 9/21/2020 17:50 2020-09-21T17:50:00Z 09/21 13:50 851 3358 2020-09-21T17:50:00Z 866683     27683                             35 104 3680 866683 posNeg 3784 866683 2 17 47b8ae8162027de32de85ee9156cbf12e7cb5080 0 0 0 0 0  
261 261 20200922 NV 76298 592776   669074 441   140   75   2052 A+ 9/22/2020 02:59 2020-09-22T02:59:00Z 09/21 22:59 1546   2020-09-22T02:59:00Z 991960     76298       668264                     32 262 2020 669074 posNeg 2282 669074 15 0 68eee99de2c89aa2fb5c5d3859ef96b306977c76 0 0 0 0 0  
262 262 20200922 NY 451227 9613535   10064762 470 89995 133   67   76246 A 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 25432 89995 2020-09-21T23:59:00Z       451227     10064762                       36 754 83243 10064762 posNeg 83997 10064762 4 0 acfffc57985c0dd288e364f084a74119a9415495 0 0 0 0 0  
263 263 20200922 OH 145850 2742937   2888787 593 14899 196 3210 115   124774 A+ 9/22/2020 14:00 2020-09-22T14:00:00Z 09/22 10:00 4635 14899 2020-09-22T14:00:00Z 2880825     137888 4338 297                         39 685 31941 2888787 posNeg 32626 2888787 12 70 45791eaab07cd3164210f78f027d54812f0a9c8d 0 0 0 0 0  
264 264 20200922 OK 79072 1022767 3536 1101839 628 5996 244       65482 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 962 5996 2020-09-22T00:00:00Z 1114878 90327 1022767 79072         76497 3764                 40 1164 27070 1105375 posNeg 28234 1101839 14 100 dc68354813025b931403f23e5e319714167994fd 0 0 0 0 0  
265 265 20200922 OR 31313 611268   642581 182 2419 42   17   5431 A+ 9/22/2020 03:01 2020-09-22T03:01:00Z 09/21 23:01 532 2419 2020-09-22T03:01:00Z     611268 29780       641048                     41 318 3465 642581 posNeg 3783 642581 3 24 3cd61f2e8b2a2624fdedb5623741094f7e7d1ce9 0 0 0 0 0  
266 266 20200922 PA 151646 1777916   1929562 429       58   122833 A+ 9/22/2020 12:00 2020-09-22T12:00:00Z 09/22 08:00 8023   2020-09-22T12:00:00Z 2782233     147070       1924986                     42 834 10735 1929562 posNeg 11569 1929562 19 0 4f7d0da29c5892d52a810e5507aa86ca4689e92b 0 0 0 0 0  
267 267 20200922 PR 42596 305972   348568 369   63   42     C 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 613   2020-09-22T00:00:00Z 310546 7002 303412 20399 443 170       22197                 72 120 0 348568 posNeg 120 348568 4 0 f088e68408cd71bc8d9be1e2e896a99cca04ca73 0 0 0 0 0  
268 268 20200922 RI 24044 298347   696808 82 2704 10   7   2272 A+ 9/22/2020 12:00 2020-09-22T12:00:00Z 09/22 08:00 1099 2704 2020-09-22T12:00:00Z   33791 663017 24044     696808 322391                     44 112 1713 322391 totalTestEncountersViral 6527 322391 2 11 76d8f25c0656b7455fece1ef2e92a773d79df2bf 0 0 0 0 0  
269 269 20200922 SC 140789 1031695   1172484 768 8851 187   105   68748 A+ 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 3243 8851 2020-09-21T23:59:00Z 1169101 175236 993865 137406 3067 176     68926 6349 62577           30106 8954 45 2665 25701 1172484 posNeg 28366 1172484 31 72 561844125f91fc3e719c8be3661e3c9c132196b3 0 0 0 0 0  
270 270 20200922 SD 19189 159157   178346 178 1323         16170 A 9/21/2020 14:00 2020-09-21T14:00:00Z 09/21 10:00 202 1323 2020-09-21T14:00:00Z 247705             178346                     46 320 1003 178346 posNeg 1323 178346 0 26 02e039c062b3c1abf1d36f6dfbc56777cc891c9b 0 0 0 0 0  
271 271 20200922 TN 185148 2506256   2691404 914 8263 297   120   167778 A+ 9/22/2020 15:00 2020-09-22T15:00:00Z 09/22 11:00 2261 8263 2020-09-22T15:00:00Z 2685015 218102 2466913 178759 2178 83                         47 739 11259 2691404 posNeg 11998 2691404 28 64 d07fb3ad0c51db6c8101cc45250928b3e637e799 0 0 0 0 0  
272 272 20200922 TX 716207 4951525   5667732 3207   1065       613896 A 9/22/2020 17:40 2020-09-22T17:40:00Z 09/22 13:40 14994   2020-09-22T17:40:00Z 5667732     716207         389207 35026             71209 8712 48 17820 27414 5667732 posNeg 45234 5667732 77 0 ec32538028149c4d87f0cba67742d94fbd369fb5 0 0 0 0 0  
273 273 20200922 UT 65044 703915   768959 183 3550 63 869   352 51945 A+ 9/22/2020 10:33 2020-09-22T10:33:00Z 09/22 06:33 443 3550 2020-09-22T10:33:00Z 982545     65044       768959             11206 1588 17730 1686 49 650 6258 768959 posNeg 6908 768959 2 30 fd0c9d57200a01d725eb96efe92d9cc6b5978592 0 0 0 0 0  
274 274 20200922 VA 142010 1776479 308 1911580 940 17919 213   113   16979 A+ 9/21/2020 17:00 2020-09-21T17:00:00Z 09/21 13:00 3060 17919 2020-09-21T17:00:00Z   161087   135101 2853 207 1911580                       51 872 12143 1918797 posNeg 12943 1918489 39 21 14b0ae71928f9233275d8f06efb49b5a48d95219 0 0 0 0 0  
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  
277 277 20200922 WA 83193 1657706   1740899 277 7314     32     B 9/20/2020 02:59 2020-09-20T02:59:00Z 09/19 22:59 2070 7314 2020-09-20T02:59:00Z       83193 2070   1740899                       53 645 3698 1740899 posNeg 4343 1740899 33 52 fbb72d0ce8868069829ba1891bd21b88275f635c 0 0 0 0 0  
278 278 20200922 WI 110327 1348492 190 1458819 474 6765 134 991     88131 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 1259 6765 2020-09-22T00:00:00Z       104170 1251 8   1452662                     55 1739 10865 1459009 posNeg 12604 1458819 7 73 ebdce1683cd8d9610fcf4cf73f77ed6277d1e99b 0 0 0 0 0  
279 279 20200922 WV 14384 508285   522669 164   58   28   10524 C 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 317   2020-09-21T23:59:00Z 522329     14044 315 2     17008                   54 213 2940 522669 posNeg 3153 522669 5 0 4e81cd95c248b3dfe12b7a6b4d147e1ae1a6ad00 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  
282 282 20200921 AL 145780 928112   1059517 802 16487   1645   904 61232 A 9/21/2020 11:00 2020-09-21T11:00:00Z 09/21 07:00 2439 16487 2020-09-21T11:00:00Z 1059517     131405 2292 147           56961             1 818 4746 1073892 posNeg 5500 1073892 2 260 7570e181bedab66c64605b577126d7e6c27c0be7 0 0 0 0 0  
283 283 20200921 AR 76364 817238   891524 439 4986 228   95 632 66934 A+ 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 1197 4986 2020-09-21T00:00:00Z 891524   817238 74286 1048 149                 10101 2242 21856 3300 5 641 6944 893602 posNeg 7540 893602 16 19 587b536e6faa93fe497751a7fe36885ecaffac9f 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  
285 285 20200921 AZ 214251 1176711   1386627 472 21878 119   57   33946 A+ 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 5478 21878 2020-09-21T00:00:00Z       209916 5186 292   1386627 283791                   4 233 6805 1390962 posNeg 7020 1390962 2 2 4c6d03ddc7c7ffccf6c670665dc85d7ce72b1223 0 0 0 0 0  
286 286 20200921 CA 781694 12891088   13672782 3459   960         B 9/21/2020 02:59 2020-09-21T02:59:00Z 09/20 22:59 15018   2020-09-21T02:59:00Z 13672782     781694                             6 3294 146330 13672782 posNeg 149624 13672782 31 0 b690b9d123b355bc7c82db4025a3843fa608be9a 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  
288 288 20200921 CT 56024 1411742   1467766 68 11447         9204 B 9/20/2020 20:30 2020-09-20T20:30:00Z 09/20 16:30 4495 11447 2020-09-20T20:30:00Z 1465434     53692 3600 895                         9 497 45121 1467766 posNeg 45618 1467766 3 0 15b77f990ac85529153e7f22466cdfe08f8c07e9 0 0 0 0 0  
289 289 20200921 DC 14978 342766   357744 88   26   17   11856 A+ 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 621   2020-09-20T00:00:00Z             357744 204781                     11 23 2577 357744 posNeg 2600 357744 1 0 00488a9e4c3eb06b78810b5b34ecc30f8bcbf043 0 0 0 0 0  
290 290 20200921 DE 19667 253546   273213 53   17       10376 A+ 9/20/2020 18:00 2020-09-20T18:00:00Z 09/20 14:00 627   2020-09-20T18:00:00Z       18648 550 77   273213                     10 101 1691 273213 posNeg 1792 273213 6 0 b3b704c9d5d98c5a8219aafd2030bee39d569f71 0 0 0 0 0  
291 291 20200921 FL 685439 4427821 3865 5113260 2266 43033           A 9/19/2020 23:59 2020-09-19T23:59:00Z 09/19 19:59 13480 43033 2020-09-19T23:59:00Z 7175080 882212 6251909 685439 13480     5120391 505164 45080 460024 493810 44075 449702   14570     12 1685 16486 5117125 posNeg 18171 5113260 21 94 3fb3d7b71d3a44d19438c63485f2c0d96460e93a 0 0 0 0 0  
292 292 20200921 GA 307339 2463524   2770863 1970 27394   5005       A 9/21/2020 14:50 2020-09-21T14:50:00Z 09/21 10:50 6604 27394 2020-09-21T14:50:00Z 2770863 285951 2484912 307339         295904 24197                 13 1184 18857 2770863 posNeg 20041 2770863 2 17 8c2d67ae667b2076113fd851c6f1503c35258359 0 0 0 0 0  
293 293 20200921 GU 2147 44207   46354 38   18       1505 A 9/21/2020 09:00 2020-09-21T09:00:00Z 09/21 05:00 35   2020-09-21T09:00:00Z 46352     2147       46354 175 3                 66 30 366 46354 posNeg 396 46354 1 0 b64988c77058946a81407403f79ac72214ba9a4f 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  
295 295 20200921 IA 78339 643256   721595 271   74   35   57942 A+ 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 1274   2020-09-21T00:00:00Z       78339       723128       55948 3326 52582 18817 2401     19 660 2656 721595 posNeg 3316 721595 9 0 2910df862f5131002adf9961ba0daa43c9c88ff2 0 0 0 0 0  
296 296 20200921 ID 37491 254795   289163 146 1718 51 443     20304 A 9/20/2020 19:00 2020-09-20T19:00:00Z 09/20 15:00 443 1718 2020-09-20T19:00:00Z 289163     34368 405 38                         16 244 2114 292286 posNeg 2333 292286 2 7 7970b84c1239db78b3ab6042de39562ba29b2baf 0 0 0 0 0  
297 297 20200921 IL 277933 4867652   5145585 1436   364   153     A 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 8693   2020-09-21T00:00:00Z 5143387     275735 8457 236                         17 1477 36757 5145585 posNeg 38234 5145585 7 0 7eabde416f68cefad780ba3a7055efee30a84a5f 0 0 0 0 0  
298 298 20200921 IN 112027 1196618   1308645 766 12184 228 2428 72   88173 A+ 9/20/2020 23:59 2020-09-20T23:59:00Z 09/20 19:59 3512 12184 2020-09-20T23:59:00Z 1882248       3287 225   1308645                     18 522 6183 1308645 posNeg 6705 1308645 6 41 624611a7410eb1f17ee008111ebcd6e1651ae6a7 0 0 0 0 0  
299 299 20200921 KS 53959 430732   484691 216 2706 60 741 23 230 1970 A+ 9/21/2020 10:00 2020-09-21T10:00:00Z 09/21 06:00 600 2706 2020-09-21T10:00:00Z               484691                     20 1674 8268 484691 posNeg 9942 484691 4 35 4c985aa59230672b21f97f4077756440c35c04e0 0 0 0 0 0  
300 300 20200921 KY 61917 1003487   1058483 496 5051 114 1488     11283 B 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 1112 5051 2020-09-21T00:00:00Z 1058483     54996 1103 9     51575               21017   21 375 9817 1065404 posNeg 10488 1065404 1 25 78288e432390a113113ed4912d7bd7a37ca9e0f4 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
);