states_daily_4pm_et

Table actions

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

11,578 rows sorted by totalTestsPeopleViral

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid date state positive negative pending totalTestResults hospitalizedCurrently hospitalizedCumulative inIcuCurrently inIcuCumulative onVentilatorCurrently onVentilatorCumulative recovered dataQualityGrade lastUpdateEt dateModified checkTimeEt death hospitalized dateChecked totalTestsViral positiveTestsViral negativeTestsViral positiveCasesViral deathConfirmed deathProbable totalTestEncountersViral totalTestsPeopleViral ▼ totalTestsAntibody positiveTestsAntibody negativeTestsAntibody totalTestsPeopleAntibody positiveTestsPeopleAntibody negativeTestsPeopleAntibody totalTestsPeopleAntigen positiveTestsPeopleAntigen totalTestsAntigen positiveTestsAntigen fips positiveIncrease negativeIncrease total totalTestResultsSource totalTestResultsIncrease posNeg deathIncrease hospitalizedIncrease hash commercialScore negativeRegularScore negativeScore positiveScore score grade
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
304 304 20200921 ME 5106 370286   375392 17 440 6   1   4384 A+ 9/20/2020 23:59 2020-09-20T23:59:00Z 09/20 19:59 140 440 2020-09-20T23:59:00Z 374872 6327 368266 4586 139 1     10192 513 9665               23 27 1227 375392 posNeg 1254 375392 1 1 db4f793de0fc598bda924aec22dd7d144d585d9d 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  
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  
310 310 20200921 MT 10429 300833   311262 108 576         7876 C 9/21/2020 01:59 2020-09-21T01:59:00Z 09/20 21:59 160 576 2020-09-21T01:59:00Z 311262     10429                             30 130 8319 311262 posNeg 8449 311262 3 6 e8fff4c66760ee90023904f8ffa5699f5b1c56d5 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  
315 315 20200921 NJ 200154 3153029   3353183 349 23135 87   32   34672 A+ 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 16069 23135 2020-09-21T00:00:00Z 3352791     200154 14278 1791                         34 392 0 3353183 posNeg 392 3353183 2 5 74f7601918ce989485c3fe8aa2b8123230a71383 0 0 0 0 0  
316 316 20200921 NM 27579 835320   862899 64 3341         15412 B 9/20/2020 16:58 2020-09-20T16:58:00Z 09/20 12:58 849 3341 2020-09-20T16:58:00Z 862899     27579                             35 67 5376 862899 posNeg 5443 862899 2 6 d8b912acad2a2e01f170146fc396452eaa92b799 0 0 0 0 0  
318 318 20200921 NY 450473 9530292   9980765 468 89995 134   66   76218 A 9/20/2020 23:59 2020-09-20T23:59:00Z 09/20 19:59 25428 89995 2020-09-20T23:59:00Z       450473     9980765                       36 573 57746 9980765 posNeg 58319 9980765 1 0 6e223bb0204780c57bf975ab107522993c6290f8 0 0 0 0 0  
319 319 20200921 OH 145165 2710996   2856161 592 14829 188 3199 108   123423 A+ 9/21/2020 14:00 2020-09-21T14:00:00Z 09/21 10:00 4623 14829 2020-09-21T14:00:00Z 2848305     137309 4325 298                         39 856 30008 2856161 posNeg 30864 2856161 8 56 263c1fc746b5187bfbd81c4c575138fdb33d4628 0 0 0 0 0  
320 320 20200921 OK 77908 995697 8878 1073605 522 5896 222       64941 A+ 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 948 5896 2020-09-21T00:00:00Z 1084302 86886 995697 77908         76497 3764                 40 1101 0 1082483 posNeg 1101 1073605 2 53 310ffbbe35de348e1452bd96e868c3aafffdc6bc 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  
325 325 20200921 SC 138124 1005994   1144118 764 8779 199   112   51431 A+ 9/20/2020 23:59 2020-09-20T23:59:00Z 09/20 19:59 3212 8779 2020-09-20T23:59:00Z 1140878 171879 968999 134884 3040 172     68266 6305 61961           29352 8836 45 416 11107 1144118 posNeg 11523 1144118 13 41 1861807f2fc27e42197f9777dac2e4b64bdbc025 0 0 0 0 0  
327 327 20200921 TN 184409 2494997   2679406 789 8199 272   130   166674 A+ 9/21/2020 15:00 2020-09-21T15:00:00Z 09/21 11:00 2233 8199 2020-09-21T15:00:00Z 2673187 217209 2455978 178190 2152 81                         47 895 11385 2679406 posNeg 12280 2679406 15 40 b16892e932cf1b35e44690bd6fdd79af00b2c312 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  
330 330 20200921 VA 141138 1764336 343 1898637 995 17898 217   106   16903 A+ 9/20/2020 17:00 2020-09-20T17:00:00Z 09/20 13:00 3021 17898 2020-09-20T17:00:00Z   160412   134301 2816 205 1898637                       51 627 16030 1905817 posNeg 16609 1905474 6 79 d3f77ccd9fa5277906bea7e0cf9790c76dc3d5ab 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  
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  
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  
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  
339 339 20200920 AR 75723 810294   883984 404 4967 212   83 628 66397 A+ 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 1181 4967 2020-09-20T00:00:00Z 883984   810294 73690 1033 148                 5216 2195 21856 3300 5 563 16197 886017 posNeg 17549 886017 8 4 04d4c60156c53bf02067e46c6cd413a40abc080e 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  
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  
348 348 20200920 GA 306155 2444667   2750822 1926 27377   5002       A 9/20/2020 14:50 2020-09-20T14:50:00Z 09/20 10:50 6602 27377 2020-09-20T14:50:00Z 2750822 282798 2468024 306155         295046 24046                 13 1134 14299 2750822 posNeg 15433 2750822 3 39 2432e2db740a480d7db5e0fb4a03010cc0afde1a 0 0 0 0 0  
352 352 20200920 ID 37247 252681   286830 146 1711 51 442     20105 A 9/19/2020 19:00 2020-09-19T19:00:00Z 09/19 15:00 441 1711 2020-09-19T19:00:00Z 286830     34149 403 38                         16 288 1445 289928 posNeg 1693 289928 3 10 aee2dbb7f50bc2dc4a5028e8655b462335f3f042 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  
356 356 20200920 KY 61542 993670   1047995 496 5026 114 1483     11237 B 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 1111 5026 2020-09-20T00:00:00Z 1047995     54695 1102 9     51457               19403   21 436 0 1055212 posNeg 0 1055212 3 0 02d95d8d51afa2b993ec89f17642f42fd54edbfd 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  
365 365 20200920 MS 93364 609799   703163 630 5499 171   87   78971 A+ 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 2810 5499 2020-09-19T00:00:00Z 696618     87045 2591 219     36912 95             48844   28 277 0 703163 posNeg 277 703163 1 0 54d1c5ca176831bd9a292257c1fed2ac0e4a2071 0 0 0 0 0  
366 366 20200920 MT 10299 292514   302813 104 570         7807 C 9/20/2020 01:59 2020-09-20T01:59:00Z 09/19 21:59 157 570 2020-09-20T01:59:00Z 302813     10299                             30 136 1837 302813 posNeg 1973 302813 1 3 d146247cf00e049be1639b161712115346631bc6 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  
371 371 20200920 NJ 199762 3153029   3352791 380 23130 91   39   34637 A+ 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 16067 23130 2020-09-20T00:00:00Z 3352791     199762 14276 1791                         34 453 59961 3352791 posNeg 60414 3352791 3 10 d7490d520c6b485d461c992d17bbfae5085fc96c 0 0 0 0 0  
372 372 20200920 NM 27512 829944   857456 68 3335         15342 B 9/19/2020 17:30 2020-09-19T17:30:00Z 09/19 13:30 847 3335 2020-09-19T17:30:00Z 857456     27512                             35 162 6331 857456 posNeg 6493 857456 6 15 13c15487c9ff153ea755a790c1cbb0c53f84aed3 0 0 0 0 0  
374 374 20200920 NY 449900 9472546   9922446 468 89995 132   60   76179 A 9/19/2020 23:59 2020-09-19T23:59:00Z 09/19 19:59 25427 89995 2020-09-19T23:59:00Z       449900     9922446                       36 862 99493 9922446 posNeg 100355 9922446 2 0 b9792dc99d6549db085101b4cec82e1ef562405f 0 0 0 0 0  
375 375 20200920 OH 144309 2680988   2825297 563 14773 191 3180 113   122671 A+ 9/20/2020 14:00 2020-09-20T14:00:00Z 09/20 10:00 4615 14773 2020-09-20T14:00:00Z 2817493     136505 4318 297                         39 762 35840 2825297 posNeg 36602 2825297 3 23 252eb9ce8a0cce01ebeb92046cb249e731020edb 0 0 0 0 0  
376 376 20200920 OK 76807 995697 8878 1072504 522 5843 222       64467 A+ 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 946 5843 2020-09-20T00:00:00Z 1084302 86886 995697 76807         76497 3764                 40 1003 0 1081382 posNeg 1003 1072504 3 0 436754c426827aa1a4613bda2c292e1679a2323a 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  
381 381 20200920 SC 137708 994887   1132595 733 8738 203   123   51431 A+ 9/19/2020 23:59 2020-09-19T23:59:00Z 09/19 19:59 3199 8738 2020-09-19T23:59:00Z 1129381 171027 958354 134494 3028 171     68049 6254 61795           28772 8723 45 468 8862 1132595 posNeg 9330 1132595 11 30 12e27ab17c654526b9447697c5a6abe55786234c 0 0 0 0 0  
383 383 20200920 TN 183514 2483612   2667126 772 8159 249   106   165844 A+ 9/20/2020 15:00 2020-09-20T15:00:00Z 09/20 11:00 2218 8159 2020-09-20T15:00:00Z 2661006 216225 2444781 177394 2137 81                         47 2075 37964 2667126 posNeg 40039 2667126 2 43 d79981fefc935858852ecae17993a1e9da345709 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  
386 386 20200920 VA 140511 1748306 308 1882028 939 17819 263   126   16880 A+ 9/19/2020 17:00 2020-09-19T17:00:00Z 09/19 13:00 3015 17819 2020-09-19T17:00:00Z   159604   133722 2811 204 1882028                       51 856 14606 1889125 posNeg 15362 1888817 25 11 cf83044aa61954239c786d07fa35a38697831179 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  
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  
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  
394 394 20200919 AL 144164 918448   1048422 747 16227   1642   904 61232 A 9/19/2020 11:00 2020-09-19T11:00:00Z 09/19 07:00 2437 16227 2020-09-19T11:00:00Z 1048422     129974 2290 147           56797             1 1301 8256 1062612 posNeg 9412 1062612 9 0 64c7250a6485aa99e27f2c992ccc8a1ab0711b29 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  

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