states_daily_4pm_et

Table actions

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

11,578 rows sorted by hospitalized

✎ 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
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  
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  
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  
301 301 20200921 LA 162501 2023291   2185792 587       93   145570 A 9/21/2020 13:00 2020-09-21T13:00:00Z 09/21 09:00 5375   2020-09-21T13:00:00Z       161462 5207 168   2184753                     22 243 6550 2185792 posNeg 6793 2185792 9 0 159fff8d9db66a9011e2387fc5fa7da5c2cf5b19 0 0 0 0 0  
305 305 20200921 MI 129662 3241005   3370667 501   146   64   90216 A+ 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 6981   2020-09-21T00:00:00Z 3405774 164769 3241005 117406 6665 316     285076                   26 1575 50623 3370667 posNeg 52198 3370667 12 0 e9011c38da4499931fd6b69bc0d67a537867c520 0 0 0 0 0  
307 307 20200921 MO 114307 1105252   1219559 1022             B 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 1807   2020-09-21T00:00:00Z 1592975 121430 1468805 114307       1219559       72529 3346 69183         29 1463 5588 1219559 posNeg 7051 1219559 12 0 e2805bb8f048f481f6ea89d859df8fef49f1d0e2 0 0 0 0 0  
311 311 20200921 NC 194381 2623158   2817539 885   277       176422 A+ 9/21/2020 12:15 2020-09-21T12:15:00Z 09/21 08:15 3247   2020-09-21T12:15:00Z 2817539     194381 3247                           37 800 11921 2817539 posNeg 12721 2817539 4 0 29618a42d9cfdbb11e88165ff3b744f1fd1a6869 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  
322 322 20200921 PA 150812 1767181   1917993 418       59   123665 A+ 9/21/2020 12:00 2020-09-21T12:00:00Z 09/21 08:00 8004   2020-09-21T12:00:00Z 2758758     146281       1913462                     42 234 8849 1917993 posNeg 9083 1917993 23 0 23eeb661ed83d84bebb5cae8db6ab376cec99110 0 0 0 0 0  
323 323 20200921 PR 42476 305972   348448 386   63   41     C 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 609   2020-09-21T00:00:00Z 310546 7002 303412 20311 439 170       22165                 72 638 0 348448 posNeg 638 348448 1 0 7c399cf3db62d7c35977deb01133e1e5eacdec85 0 0 0 0 0  
328 328 20200921 TX 698387 4924111   5622498 3132   1073       611856 A 9/21/2020 17:45 2020-09-21T17:45:00Z 09/21 13:45 14917   2020-09-21T17:45:00Z 5622498     698387         386966 34843             64302 7867 48 9853 19157 5622498 posNeg 29010 5622498 24 0 09a4609909a8385823119af6254c78b7c8391951 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  
335 335 20200921 WV 14171 505345   519516 162   58   28   10317 C 9/20/2020 23:59 2020-09-20T23:59:00Z 09/20 19:59 312   2020-09-20T23:59:00Z 519175     13830 310 2     16991                   54 117 5095 519516 posNeg 5212 519516 2 0 6b81143726e5d965a55efe06470af5ce7c18b26a 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  
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  
342 342 20200920 CA 778400 12744758   13523158 3441   925         B 9/20/2020 02:59 2020-09-20T02:59:00Z 09/19 22:59 14987   2020-09-20T02:59:00Z 13523158     778400                             6 4265 175007 13523158 posNeg 179272 13523158 75 0 fd88a82366b400053d994227a86f175bbe8112b4 0 0 0 0 0  
345 345 20200920 DC 14955 340189   355144 86   25   14   11829 A+ 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 620   2020-09-19T00:00:00Z             355144 204099                     11 53 4214 355144 posNeg 4267 355144 1 0 64545b24e233cc19e1139412d3c0df143abd32c4 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  
351 351 20200920 IA 77679 640600   718279 269   73   38   57524 A+ 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 1265   2020-09-20T00:00:00Z       77679       719817       55887 3320 52527 18671 2368     19 621 3883 718279 posNeg 4504 718279 1 0 31ae6f0da018d9d0ec472b92b1bc0f0e709650a7 0 0 0 0 0  
353 353 20200920 IL 276456 4830895   5107351 1417   357   151     A 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 8686   2020-09-20T00:00:00Z 5105153     274258 8450 236                         17 1402 46609 5107351 posNeg 48011 5107351 14 0 a3869b881ecc0914920947ed7fde97b852eb1c8c 0 0 0 0 0  
357 357 20200920 LA 162258 2016741   2178999 596       100   145570 A 9/20/2020 13:00 2020-09-20T13:00:00Z 09/20 09:00 5366   2020-09-20T13:00:00Z       161219 5198 168   2177960                     22 936 31077 2178999 posNeg 32013 2178999 26 0 82b0b98d88e3e5bfbaa0a9c96621398de54bcfef 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  
363 363 20200920 MO 112844 1099664   1212508 1064             B 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 1795   2020-09-20T00:00:00Z 1583984 120142 1461128 112844       1212508       72455 3316 69139         29 1328 8556 1212508 posNeg 9884 1212508 2 0 bf8501f62ec994b3e8bf3f3d9d3894e307550e94 0 0 0 0 0  
367 367 20200920 NC 193581 2611237   2804818 889   292       167257 A+ 9/20/2020 11:50 2020-09-20T11:50:00Z 09/20 07:50 3243   2020-09-20T11:50:00Z 2804818     193581 3243                           37 1333 32465 2804818 posNeg 33798 2804818 8 0 8b618f579ade72bd8e17b5ac118820c1ff2ff735 0 0 0 0 0  
373 373 20200920 NV 75804 589380   665184 443   127   89   2012 A+ 9/20/2020 02:59 2020-09-20T02:59:00Z 09/19 22:59 1531   2020-09-20T02:59:00Z 984667     75804       664479                     32 385 4113 665184 posNeg 4498 665184 3 0 5ddabc941df1cdefe81653ec10f2243cd52970ae 0 0 0 0 0  
378 378 20200920 PA 150578 1758332   1908910 400       49   122872 A+ 9/20/2020 12:30 2020-09-20T12:30:00Z 09/20 08:30 7981   2020-09-20T12:30:00Z 2713113     146057       1904389                     42 733 12052 1908910 posNeg 12785 1908910 25 0 947f6e469ff3c149d2c6e87323daf246cda9e3f6 0 0 0 0 0  
379 379 20200920 PR 41838 305972   347810 384   64   43     C 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 608   2020-09-20T00:00:00Z 310546 7002 303412 20069 438 170       21769                 72 845 0 347810 posNeg 845 347810 3 0 8731a0ba2ca2d07b1a744a979429e312de5d6ada 0 0 0 0 0  
384 384 20200920 TX 688534 4904954   5593488 3081   1057       609210 A 9/20/2020 15:50 2020-09-20T15:50:00Z 09/20 11:50 14893   2020-09-20T15:50:00Z 5593488     688534         385351 34639             63908 7793 48 2466 27846 5593488 posNeg 30312 5593488 45 0 dda19cfcd03fde717fc7185489907e372c264b25 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  
391 391 20200920 WV 14054 500250   514304 167   55   29   10227 C 9/19/2020 23:59 2020-09-19T23:59:00Z 09/19 19:59 310   2020-09-19T23:59:00Z 513967     13717 308 2     16948                   54 180 4638 514304 posNeg 4818 514304 2 0 ba54363cba5fcb850a6549c8ad089e89608927c1 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  
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  
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  
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  
402 402 20200919 DE 19449 250262   269711 53   15       10257 A+ 9/18/2020 18:00 2020-09-18T18:00:00Z 09/18 14:00 621   2020-09-18T18:00:00Z       18429 548 73   269711                     10 83 990 269711 posNeg 1073 269711 1 0 cfbced4f64ed183e15486991059c259dbc566bc1 0 0 0 0 0  
405 405 20200919 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 43 262 45958 posNeg 305 45958 1 0 b2bbb8ab5dc2c0db6321584a22ff5a81b07ddf36 0 0 0 0 0  
407 407 20200919 IA 77058 636717   713775 282   81   40   57269 A+ 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 1264   2020-09-19T00:00:00Z       77058       715311       55107 3312 51755 18314 2326     19 847 4897 713775 posNeg 5744 713775 4 0 4d37bad5cf9f6423fa19d2acb8a1a7b17128d27c 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  
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  
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  
419 419 20200919 MO 111516 1091108   1202624 1004             B 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 1793   2020-09-19T00:00:00Z 1571002 118677 1449613 111516       1202624       72342 3287 69055         29 1387 10857 1202624 posNeg 12244 1202624 13 0 3b751b0d6def2c03f81997a760b4a1d70554e2b0 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  
429 429 20200919 NV 75419 585267   660686 443   127   89   2012 A+ 9/19/2020 02:59 2020-09-19T02:59:00Z 09/18 22:59 1528   2020-09-19T02:59:00Z 975887     75419       659972                     32 323 3762 660686 posNeg 4085 660686 4 0 4ce067a0467661641796a473a5b250e82fe993a5 0 0 0 0 0  
434 434 20200919 PA 149845 1746280   1896125 470       47   122872 A+ 9/19/2020 12:30 2020-09-19T12:30:00Z 09/19 08:30 7956   2020-09-19T12:30:00Z 2713113     145335       1891615                     42 1162 13475 1896125 posNeg 14637 1896125 22 0 52faa9f494c03ba1fcb3293fa56bb78128509b55 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  
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  
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  
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  
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  
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  
458 458 20200918 DE 19366 249272   268638 58   17       10201 A+ 9/17/2020 18:00 2020-09-17T18:00:00Z 09/17 14:00 620   2020-09-17T18:00:00Z       18363 547 73   268638                     10 48 1422 268638 posNeg 1470 268638 1 0 fde395d540d7fc1f765916fa16723c6f59b0f10b 0 0 0 0 0  
461 461 20200918 GU 2074 43579   45653 41   19       1450 A 9/18/2020 07:45 2020-09-18T07:45:00Z 09/18 03:45 33   2020-09-18T07:45:00Z 45651     2074       45653 172 3                 66 29 371 45653 posNeg 400 45653 2 0 937b292bf06af47e14edfe4fcb14b3d9cd001acd 0 0 0 0 0  
463 463 20200918 IA 76211 631820   708031 281   91   39   56546 A+ 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 1260   2020-09-18T00:00:00Z       76211       709565       54988 3289 51659 18101 2314     19 1183 5410 708031 posNeg 6593 708031 9 0 38bb2b2a915a5b2ad06f646eca9d9c76f9d8ccd0 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  
469 469 20200918 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 979 21817 2146986 posNeg 22796 2146986 29 0 a240b9935efd335f467f94404a8006b6c051c52f 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  
475 475 20200918 MO 110129 1080251   1190380 1025             B 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 1780   2020-09-18T00:00:00Z 1554625 117326 1434610 110129       1190380       72085 3266 68819         29 1795 10004 1190380 posNeg 11799 1190380 23 0 301164c2b6ff62d584b093755f4b35bb3b7e63fc 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  
485 485 20200918 NV 75096 581505   656601 461   136   85   2012 A+ 9/18/2020 02:59 2020-09-18T02:59:00Z 09/17 22:59 1524   2020-09-18T02:59:00Z 967840     75096       655860                     32 501 3517 656601 posNeg 4018 656601 18 0 39699c57dc5c4f6b884b3e95a2c1d235be43f4d6 0 0 0 0 0  
490 490 20200918 PA 148683 1732805   1881488 521       50   121920 A+ 9/18/2020 12:00 2020-09-18T12:00:00Z 09/18 08:00 7934   2020-09-18T12:00:00Z 2680238     144228       1877033                     42 760 11530 1881488 posNeg 12290 1881488 21 0 b02afcb58ea1b6844662682e47ebfc23c2ae9d1f 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  
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  
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  
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  
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  
513 513 20200917 DC 14790 326528   341318 100   22   18   11763 A+ 9/16/2020 00:00 2020-09-16T00:00:00Z 09/15 20:00 619   2020-09-16T00:00:00Z             341318 199579                     11 47 3030 341318 posNeg 3077 341318 2 0 48ffd6e6edaf60cd4a0a90fdbb9d2acc05d8f164 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  
517 517 20200917 GU 2045 43208   45253 44   19       1427 A 9/17/2020 05:40 2020-09-17T05:40:00Z 09/17 01:40 31   2020-09-17T05:40:00Z 45251     2045       45253 170 3                 66 32 370 45253 posNeg 402 45253 2 0 eb391035b8fa1b809bfc5025c0758dba4fd3a1e8 0 0 0 0 0  
519 519 20200917 IA 75028 626410   701438 271   85   36   55834 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 1251   2020-09-17T00:00:00Z       75028       702988       54504 3269 51195 17663 2250     19 948 5379 701438 posNeg 6327 701438 14 0 8fb35d2a2cb9fc221bdc9dcc65782ecb945f6553 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  
525 525 20200917 LA 160343 1963847   2124190 663       106   145570 A 9/17/2020 13:00 2020-09-17T13:00:00Z 09/17 09:00 5311   2020-09-17T13:00:00Z       159304 5143 168   2123151                     22 478 8528 2124190 posNeg 9006 2124190 17 0 996d232f6b3f66d4927f6b0b437ad9167d5c4d64 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  
531 531 20200917 MO 108334 1070247   1178581 962             B 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 1757   2020-09-17T00:00:00Z 1538232 115983 1419584 108334       1178581       71852 3250 68602         29 1747 12451 1178581 posNeg 14198 1178581 18 0 8f1e20026eaaec08f70121c09a237b778cf58008 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  
541 541 20200917 NV 74595 577988   652583 484   150   98   1997 A+ 9/17/2020 02:59 2020-09-17T02:59:00Z 09/16 22:59 1506   2020-09-17T02:59:00Z 959839     74595       651900                     32 347 2703 652583 posNeg 3050 652583 12 0 6d969a605111a6b2d765c1f6f0ccc2f951bf240b 0 0 0 0 0  
546 546 20200917 PA 147923 1721275   1869198 459       54   121296 A+ 9/17/2020 15:00 2020-09-17T15:00:00Z 09/17 11:00 7913   2020-09-17T15:00:00Z 2652463     143552       1864827                     42 933 13144 1869198 posNeg 14077 1869198 10 0 704e29e06c15e48c2a773c15734ef0d84b71dedf 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  
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  
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  
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  
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  
569 569 20200916 DC 14743 323498   338241 91   24   13   11691 A+ 9/15/2020 00:00 2020-09-15T00:00:00Z 09/14 20:00 617   2020-09-15T00:00:00Z             338241 198409                     11 56 1905 338241 posNeg 1961 338241 1 0 58073eeed1c488c2f7c48c238a3317b275047c9e 0 0 0 0 0  
570 570 20200916 DE 19234 246671   265905 58   11       10189 A+ 9/15/2020 18:00 2020-09-15T18:00:00Z 09/15 14:00 619   2020-09-15T18:00:00Z       18235 547 72   265905                     10 97 1649 265905 posNeg 1746 265905 1 0 f606baf4e4a8589b2089ad56f807f52b86cc0e26 0 0 0 0 0  
573 573 20200916 GU 2013 42838   44851 46   10       1406 A 9/16/2020 08:05 2020-09-16T08:05:00Z 09/16 04:05 29   2020-09-16T08:05:00Z 44849     2013       44851 158 2                 66 47 475 44851 posNeg 522 44851 1 0 9bc88925f6fde2c67dbbd06e17b70298a4bbb5d0 0 0 0 0 0  
575 575 20200916 IA 74080 621031   695111 291   79   32   55067 A+ 9/16/2020 00:00 2020-09-16T00:00:00Z 09/15 20:00 1237   2020-09-16T00:00:00Z       74080       696656       53963 3240 50683 17285 2201     19 803 4696 695111 posNeg 5499 695111 3 0 ada3ba706bf73d3e426a7f0c48416420b447cd6a 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  
581 581 20200916 LA 159865 1955319   2115184 678       107   145570 A 9/16/2020 13:00 2020-09-16T13:00:00Z 09/16 09:00 5294   2020-09-16T13:00:00Z       158826 5126 168   2114145                     22 612 22614 2115184 posNeg 23226 2115184 16 0 42d0a9cff3bf5abcece0770dc0eef14820fb97aa 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  

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