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

11,578 rows sorted by totalTestsPeopleViral

View and edit SQL

Suggested facets: dateModified (date), dateChecked (date)

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
1 20200926 AK 8315 434554   442869 43       14   3267 A 9/26/2020 03:59 2020-09-26T03:59:00Z 09/25 23:59 52   2020-09-26T03:59:00Z 442869 7411 435171 8315 52                           2 113 1424 442869 posNeg 1537 442869 1 0 bf7518dcc571d23d1d8206a95e1a1c12173bcb0a 0 0 0 0 0  
2 20200926 AL 151591 970048   1104932 709 16852   1791   1007 64583 A 9/26/2020 11:00 2020-09-26T11:00:00Z 09/26 07:00 2501 16852 2020-09-26T11:00:00Z 1104932     134884 2364 137           57800             1 933 6684 1121639 posNeg 7337 1121639 10 0 88370a431af70a13b1499a5cd6afe94a14fc9fb3 0 0 0 0 0  
3 20200926 AR 80755 855635   933895 447 5202 213   91 657 72051 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 1285 5202 2020-09-26T00:00:00Z 933895   855635 78260 1137 148                 10264 2706 21856 3300 5 809 6813 936390 posNeg 7601 936390 19 0 1177f6d15b81adb770caebd6b66b47189c93f198 0 0 0 0 0  
4 20200926 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 b9eccb7369bdc4ee75708c7a892c5437ab915d83 0 0 0 0 0  
6 20200926 CA 798237 13384493   14182730 3203   862         B 9/26/2020 02:59 2020-09-26T02:59:00Z 09/25 22:59 15532   2020-09-26T02:59:00Z 14182730     798237                             6 4197 126286 14182730 posNeg 130483 14182730 134 0 bc22d39302ce5646a61aef19adbfa503f5de5e76 0 0 0 0 0  
8 20200926 CT 56587 1462564   1519151 76 11560         9310 B 9/24/2020 20:30 2020-09-24T20:30:00Z 09/24 16:30 4501 11560 2020-09-24T20:30:00Z 1516780     54216 3604 897                         9 0 0 1519151 posNeg 0 1519151 0 0 597a6f3bd03d5e8297830e769c3da2cb90e767e7 0 0 0 0 0  
12 20200926 GA 313873 2558482   2872355 1831 28153   5176       A 9/26/2020 14:50 2020-09-26T14:50:00Z 09/26 10:50 6914 28153 2020-09-26T14:50:00Z 2872355 292318 2580037 313873         299555 24723                 13 1359 23502 2872355 posNeg 24861 2872355 40 118 9ab79841fa3a6c3d058ce3f94b9671540d5a8880 0 0 0 0 0  
16 20200926 ID 39757 262420   298652 135 1795 44 451     21291 A 9/25/2020 18:55 2020-09-25T18:55:00Z 09/25 14:55 458 1795 2020-09-25T18:55:00Z 298652     36232 421 37                         16 523 1772 302177 posNeg 2240 302177 1 29 71c4c31498029adf59faba29c2c940f819b1402a 0 0 0 0 0  
17 20200926 IL 288815 5142362   5431177 1597   355   141     A 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 8832   2020-09-26T00:00:00Z 5428688     286326 8588 244                         17 2441 62776 5431177 posNeg 65217 5431177 25 0 2620e4472a6793bd94436e1e6a2f1efbe8f39315 0 0 0 0 0  
20 20200926 KY 66036 1216560   1274688 538 5193 129 1511     11750 B 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 1154 5193 2020-09-26T00:00:00Z 1274688     58128 1144 10     55724               24514   21 970 29298 1282596 posNeg 30060 1282596 5 46 bbc51488b99291f0d9e247a91056b3ddc5af5618 0 0 0 0 0  
24 20200926 ME 5260 401159   406419 8 443 1   0   4538 A+ 9/25/2020 23:59 2020-09-25T23:59:00Z 09/25 19:59 140 443 2020-09-25T23:59:00Z 405850 6490 399070 4713 139 1     10270 516 9740               23 25 0 406419 posNeg 25 406419 0 1 7ed34c8487da7bfb9b9473f129d8e5a25a1c0056 0 0 0 0 0  
25 20200926 MI 134373 3408684   3543057 558   139   52   95051 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 7044   2020-09-26T00:00:00Z 3578584 169900 3408684 121427 6723 321     291180                   26 996 39749 3543057 posNeg 40745 3543057 17 0 2e49e36255f6a6daef66f967af21b911b45c97ad 0 0 0 0 0  
29 20200926 MS 96677 634036   730713 601 5607 147   68   85327 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 2911 5607 2020-09-25T00:00:00Z 723389     89353 2686 225     38425 95             55557   28 645 3682 730713 posNeg 4327 730713 17 0 25c406301ef686539186978256312931e29136fe 0 0 0 0 0  
30 20200926 MT 11907 317378   329285 147 684         8749 C 9/26/2020 01:59 2020-09-26T01:59:00Z 09/25 21:59 171 684 2020-09-26T01:59:00Z 329285     11907                             30 343 2826 329285 posNeg 3169 329285 1 9 2b25a5d9191b4d38560392a23353c41e646042be 0 0 0 0 0  
31 20200926 NC 206090 2741713   2947803 914   272       176422 A+ 9/26/2020 12:00 2020-09-26T12:00:00Z 09/26 08:00 3440   2020-09-26T12:00:00Z 2943144     201431 3440                           37 1759 38427 2947803 posNeg 40186 2947803 31 0 20a1b19461a3df0fea54c6dfb6ffc967453a835b 0 0 0 0 0  
35 20200926 NJ 202850 3309718   3512568 426 23324 88   38   34650 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 16103 23324 2020-09-26T00:00:00Z 3512568     202850 14312 1791                         34 750 33107 3512568 posNeg 33857 3512568 6 39 cd73d3de8c388876eca2bfe00d66d734af82857f 0 0 0 0 0  
36 20200926 NM 28487 865002   893489 75 3420         16020 C 9/25/2020 17:50 2020-09-25T17:50:00Z 09/25 13:50 865 3420 2020-09-25T17:50:00Z 893489     28487                             35 263 7853 893489 posNeg 8116 893489 6 18 ca61662b5c3adb6ac3a1bd588dfa0ca45978ca5b 0 0 0 0 0  
38 20200926 NY 454760 9968656   10423416 527 89995 164   75   76528 A 9/25/2020 23:59 2020-09-25T23:59:00Z 09/25 19:59 25450 89995 2020-09-25T23:59:00Z       454760     10423416                       36 1005 98948 10423416 posNeg 99953 10423416 4 0 bb7957fb78d761d4366fb1503123856475c70689 0 0 0 0 0  
39 20200926 OH 150009 2883978   3033987 625 15185 205 3247 95   129498 A+ 9/26/2020 14:00 2020-09-26T14:00:00Z 09/26 10:00 4740 15185 2020-09-26T14:00:00Z 3025649     141671 4439 301                         39 1115 37279 3033987 posNeg 38394 3033987 6 58 bc6ac50a6f9a24d96bc3280b69d405cfab1f7ca9 0 0 0 0 0  
40 20200926 OK 83510 1075475 6653 1158985 579 6252 223       69754 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 1004 6252 2020-09-26T00:00:00Z 1172554 94741 1075475 83510         78836 3997                 40 990 17331 1165638 posNeg 18321 1158985 11 60 832a286352d7b6c33cd6f7c2aca41c1e843e62b5 0 0 0 0 0  
43 20200926 PR 45413 305972   351385 342   59   33     C 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 642   2020-09-26T00:00:00Z 310546 7002 303412 22164 471 171       23249                 72 508 0 351385 posNeg 508 351385 7 0 347836cd67621b97708a39d1a47689f42650b1b1 0 0 0 0 0  
45 20200926 SC 145273 1097524   1242797 727 9028 186   99   69629 A+ 9/25/2020 11:59 2020-09-25T11:59:00Z 09/25 07:59 3323 9028 2020-09-25T11:59:00Z 1238862 181055 1057807 141338 3141 182     70491 6831 63660           39995 9972 45 1371 14959 1242797 posNeg 16330 1242797 26 34 f961ffe6bba29cf00c45195b6b3d192e8cd6b734 0 0 0 0 0  
47 20200926 TN 190891 2598988   2789879 855 8528 267   119   174044 A+ 9/26/2020 15:00 2020-09-26T15:00:00Z 09/26 11:00 2374 8528 2020-09-26T15:00:00Z 2782844 224629 2558215 183856 2281 93                         47 1437 25597 2789879 posNeg 27034 2789879 22 51 053b3f4cd24a0ce9d35d93dfa59a783a7b6091cb 0 0 0 0 0  
48 20200926 TX 733438 5261375   5994813 3209   1056       649580 A 9/26/2020 16:20 2020-09-26T16:20:00Z 09/26 12:20 15485   2020-09-26T16:20:00Z 5994813     733438         399337 35847             80294 9297 48 4886 76478 5994813 posNeg 81364 5994813 121 0 118422653c167fc9d3ed0bd4ad4d2a32d4f6a49a 0 0 0 0 0  
50 20200926 VA 145408 1855171 310 1993344 924 18179 202   111   17255 A+ 9/25/2020 17:00 2020-09-25T17:00:00Z 09/25 13:00 3144 18179 2020-09-25T17:00:00Z   165048   138173 2937 207 1993344                       51 975 18955 2000889 posNeg 19845 2000579 8 29 5f2f6648c9200ea7be7a0d221a8b6dffb911ae4c 0 0 0 0 0  
51 20200926 VI 1296 18676 8 19972             1209 D 9/25/2020 09:30 2020-09-25T09:30:00Z 09/25 05:30 19   2020-09-25T09:30:00Z 19980       19                           78 0 0 19980 posNeg 0 19972 0 0 61739fb2efab7827062ca9cc633984208f34bc24 0 0 0 0 0  
53 20200926 WA 85226 1715795   1801021 264 7412     28     B 9/25/2020 02:59 2020-09-25T02:59:00Z 09/24 22:59 2100 7412 2020-09-25T02:59:00Z       85226 2100   1801021                       53 988 16754 1801021 posNeg 17742 1801021 20 55 fd6ce507d03586f2b0ac32e299f88b85d7393013 0 0 0 0 0  
55 20200926 WV 15158 527133   542291 174   56   31   11121 C 9/25/2020 23:59 2020-09-25T23:59:00Z 09/25 19:59 332   2020-09-25T23:59:00Z 541883     14750 329 3     17205                   54 205 6692 542291 posNeg 6897 542291 2 0 a4823873f7e477ab8b531c7edd4b61423f7dbfdb 0 0 0 0 0  
57 20200925 AK 8202 433130   441332 43       14   3042 A 9/25/2020 03:59 2020-09-25T03:59:00Z 09/24 23:59 51   2020-09-25T03:59:00Z 441332 7357 433688 8202 51                           2 261 7873 441332 posNeg 8134 441332 6 0 0271fcc794329b2dd035402cb74aad56124c446b 0 0 0 0 0  
58 20200925 AL 150658 963364   1097595 718 16852   1782   1000 64583 A 9/25/2020 11:00 2020-09-25T11:00:00Z 09/25 07:00 2491 16852 2020-09-25T11:00:00Z 1097595     134231 2357 134           57589             1 2452 18617 1114022 posNeg 19415 1114022 -15 74 08184faa52c95520b2871a34cbea8adad1c1d054 0 0 0 0 0  
59 20200925 AR 79946 848822   926294 478 5202 224   95 657 71426 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 1266 5202 2020-09-25T00:00:00Z 926294   848822 77472 1116 150                 10056 2682 21856 3300 5 897 8085 928768 posNeg 8881 928768 20 42 6d09ffffc7c9131f7489f7d8e3e4501ce55b8e1e 0 0 0 0 0  
60 20200925 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 84c6296997b54d1474da9d9c51e33d48fda7fb5b 0 0 0 0 0  
62 20200925 CA 794040 13258207   14052247 3307   899         B 9/24/2020 02:59 2020-09-24T02:59:00Z 09/23 22:59 15398   2020-09-24T02:59:00Z 14052247     794040                             6 3400 95990 14052247 posNeg 99390 14052247 84 0 dc1ad4cec70e3f611d3c3453330d057af15b2802 0 0 0 0 0  
64 20200925 CT 56587 1462564   1519151 76 11560         9310 B 9/24/2020 20:30 2020-09-24T20:30:00Z 09/24 16:30 4501 11560 2020-09-24T20:30:00Z 1516780     54216 3604 897                         9 115 13563 1519151 posNeg 13678 1519151 2 0 7bba4f44da52bffe3a760b5e91631916a9d12741 0 0 0 0 0  
68 20200925 GA 312514 2534980   2847494 1891 28035   5156       A 9/25/2020 14:50 2020-09-25T14:50:00Z 09/25 10:50 6874 28035 2020-09-25T14:50:00Z 2847494 290995 2556499 312514         298482 24566                 13 1468 -166 2847494 posNeg 22678 2847494 52 132 a6249bd4f2c3fb48f3b6f2017128b312f3fe0441 0 0 0 0 0  
72 20200925 ID 39234 260648   296412 147 1766 40 449     21105 A 9/24/2020 18:54 2020-09-24T18:54:00Z 09/24 14:54 457 1766 2020-09-24T18:54:00Z 296412     35764 419 38                         16 491 1948 299882 posNeg 2349 299882 3 12 54cbd57bd945d0aff2f97042076c6ca51bdaa3e4 0 0 0 0 0  
73 20200925 IL 286374 5079586   5365960 1637   371   124     A 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 8807   2020-09-25T00:00:00Z 5363471     283885 8563 244                         17 2805 67279 5365960 posNeg 70084 5365960 33 0 eba0b8805427a5e5e03fefdff222976f3e0158c6 0 0 0 0 0  
76 20200925 KY 65066 1187262   1244628 553 5147 130 1501     11677 B 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 1149 5147 2020-09-25T00:00:00Z 1244628     57366 1140 9     53029               24330   21 908 17485 1252328 posNeg 18243 1252328 12 28 77c25dacc4bfb618309cad6a6bbab52310394106 0 0 0 0 0  
80 20200925 ME 5235 401159   406394 10 442 2   0   4507 A+ 9/24/2020 23:59 2020-09-24T23:59:00Z 09/24 19:59 140 442 2020-09-24T23:59:00Z 405850 6490 399070 4691 139 1     10270 516 9740               23 20 6408 406394 posNeg 6428 406394 0 0 b94fc4f00af403146c6cbf490ee10259bf57ba28 0 0 0 0 0  
81 20200925 MI 133377 3368935   3502312 558   139   52   90216 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 7027   2020-09-25T00:00:00Z 3537643 168708 3368935 120526 6708 319     289151                   26 1040 38448 3502312 posNeg 39488 3502312 8 0 333b2ebfc64062c1d0e9d85ebbecd16c3e675e30 0 0 0 0 0  
85 20200925 MS 96032 630354   726386 609 5607 143   73   85327 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 2894 5607 2020-09-24T00:00:00Z 719222     88868 2671 223     38109 95             54718   28 722 3905 726386 posNeg 4627 726386 20 0 6471d1eda0db1007834208b806142b89f1a1d0e5 0 0 0 0 0  
86 20200925 MT 11564 314552   326116 140 675         8681 C 9/25/2020 01:59 2020-09-25T01:59:00Z 09/24 21:59 170 675 2020-09-25T01:59:00Z 326116     11564                             30 322 4276 326116 posNeg 4598 326116 5 25 c25f3ea5056c1bb4709b2166c937459158c4e35c 0 0 0 0 0  
87 20200925 NC 204331 2703286   2907617 903   281       176422 A+ 9/25/2020 13:30 2020-09-25T13:30:00Z 09/25 09:30 3409   2020-09-25T13:30:00Z 2903054     199768 3409                           37 6142 31284 2907617 posNeg 37426 2907617 53 0 3a1c36e50f5f0ae3074fb005c8a70ae070ce51ed 0 0 0 0 0  
91 20200925 NJ 202100 3276611   3478711 405 23285 75   32   34650 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 16097 23285 2020-09-25T00:00:00Z 3478711     202100 14306 1791                         34 548 26359 3478711 posNeg 26907 3478711 6 33 4637fb73c31e7264c355883b441eae77ca71d808 0 0 0 0 0  
92 20200925 NM 28224 857149   885373 66 3402         15825 C 9/24/2020 17:30 2020-09-24T17:30:00Z 09/24 13:30 859 3402 2020-09-24T17:30:00Z 885373     28224                             35 237 6730 885373 posNeg 6967 885373 2 14 973a492c8ab652da3c34443f7090e2f694071b6b 0 0 0 0 0  
94 20200925 NY 453755 9869708   10323463 511 89995 154   76   76456 A 9/24/2020 23:59 2020-09-24T23:59:00Z 09/24 19:59 25446 89995 2020-09-24T23:59:00Z       453755     10323463                       36 908 93910 10323463 posNeg 94818 10323463 7 0 3368f209738993fd91a59f668c9e4097259271ad 0 0 0 0 0  
95 20200925 OH 148894 2846699   2995593 595 15127 194 3243 98   128369 A+ 9/25/2020 14:00 2020-09-25T14:00:00Z 09/25 10:00 4734 15127 2020-09-25T14:00:00Z 2987382     140683 4433 301                         39 1150 38728 2995593 posNeg 39878 2995593 19 76 c1a8e2775766670e3de1f763b92a3f2b8411e097 0 0 0 0 0  
96 20200925 OK 82520 1058144 6368 1140664 590 6192 220       68911 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 993 6192 2020-09-25T00:00:00Z 1153358 92923 1058144 82520         76497 3764                 40 1276 12462 1147032 posNeg 13738 1140664 12 62 138bb7d1a73f2a2eaa42c9c9912b4c5c1fe34d34 0 0 0 0 0  
99 20200925 PR 44905 305972   350877 376   67   28     C 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 635   2020-09-25T00:00:00Z 310546 7002 303412 21868 464 171       23037                 72 1063 0 350877 posNeg 1063 350877 8 0 bda0efc404ddfa952c518d2389522acfc3623b49 0 0 0 0 0  
101 20200925 SC 143902 1082565   1226467 773 8994 191   101   68854 A+ 9/24/2020 11:59 2020-09-24T11:59:00Z 09/24 07:59 3297 8994 2020-09-24T11:59:00Z 1222621 179372 1043249 140056 3114 183     70135 6666 63469           38650 9856 45 1195 18166 1226467 posNeg 19361 1226467 18 49 dac30dba064927944a34105b6119a298f4fc93eb 0 0 0 0 0  
103 20200925 TN 189454 2573391   2762845 838 8477 250   119   172618 A+ 9/25/2020 15:00 2020-09-25T15:00:00Z 09/25 11:00 2352 8477 2020-09-25T15:00:00Z 2755933 222922 2533011 182542 2262 90                         47 1910 31547 2762845 posNeg 33457 2762845 42 64 6e5bd30f8591d29e868d2f3384695c4a34f99ed2 0 0 0 0 0  
104 20200925 TX 728552 5184897   5913449 3221   1051       646143 A 9/25/2020 17:20 2020-09-25T17:20:00Z 09/25 13:20 15364   2020-09-25T17:20:00Z 5913449     728552         394584 35656             78472 9190 48 4633 47983 5913449 posNeg 52616 5913449 97 0 fcc328aeaedb26412d3c3b30f120af65e1ed1251 0 0 0 0 0  
106 20200925 VA 144433 1836216 348 1973499 965 18150 221   117   17185 A+ 9/24/2020 17:00 2020-09-24T17:00:00Z 09/24 13:00 3136 18150 2020-09-24T17:00:00Z   163973   137283 2930 206 1973499                       51 941 19699 1980997 posNeg 20534 1980649 23 69 abf66257fc88aa4f57dbd6a79f558fc52f693911 0 0 0 0 0  
107 20200925 VI 1296 18676 8 19972             1209 D 9/25/2020 09:30 2020-09-25T09:30:00Z 09/25 05:30 19   2020-09-25T09:30:00Z 19980       19                           78 6 142 19980 posNeg 148 19972 0 0 fae7c9c388a0a44bc2800e78f8691ac3df144574 0 0 0 0 0  
109 20200925 WA 84238 1699041   1783279 269 7357     27     B 9/24/2020 02:59 2020-09-24T02:59:00Z 09/23 22:59 2080 7357 2020-09-24T02:59:00Z       84238 2080   1783279                       53 536 39447 1783279 posNeg 39983 1783279 -1 8 b20315f05b02137d7784fd47a15207d79a2b7a72 0 0 0 0 0  
111 20200925 WV 14953 520441   535394 177   59   31   10968 C 9/24/2020 23:59 2020-09-24T23:59:00Z 09/24 19:59 330   2020-09-24T23:59:00Z 535018     14577 327 3     17164                   54 247 6122 535394 posNeg 6369 535394 5 0 bba94c76334f9ad4813ce60d939fcf03baefc731 0 0 0 0 0  
113 20200924 AK 7941 425257   433198 43       14   2731 A 9/23/2020 03:59 2020-09-23T03:59:00Z 09/22 23:59 45   2020-09-23T03:59:00Z 433198 7180 425736 7941 45                           2 0 0 433198 posNeg 0 433198 0 0 b83363bdfb4b0d19318d00489c44e906270412f1 0 0 0 0 0  
114 20200924 AL 148206 944747   1078180 744 16778   1679   931 64583 A 9/24/2020 11:00 2020-09-24T11:00:00Z 09/24 07:00 2506 16778 2020-09-24T11:00:00Z 1078180     133433 2349 157           57387             1 1053 6296 1092953 posNeg 7277 1092953 18 80 4b1b271eafc1e79991c11cae326c455bd34ae063 0 0 0 0 0  
115 20200924 AR 79049 840737   917413 450 5160 216   97 650 70737 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 1246 5160 2020-09-24T00:00:00Z 917413   840737 76676 1097 149                 10922 2566 21856 3300 5 1086 9436 919786 posNeg 10466 919786 17 62 3bb6b474a294e70889229d31b3d1615e78236173 0 0 0 0 0  
116 20200924 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 f949dd0d4f1a5cc85607dc1e308d0088f67199bd 0 0 0 0 0  
118 20200924 CA 790640 13162217   13952857 3484   914         B 9/24/2020 02:59 2020-09-24T02:59:00Z 09/23 22:59 15314   2020-09-24T02:59:00Z 13952857     790640                             6 3170 70264 13952857 posNeg 73434 13952857 110 0 87788642c4d9f1deb4ce4c35adb758e1c0e423f1 0 0 0 0 0  
120 20200924 CT 56472 1449001   1505473 72 11560         9310 B 9/23/2020 20:30 2020-09-23T20:30:00Z 09/23 16:30 4499 11560 2020-09-23T20:30:00Z 1503114     54113 3603 896                         9 157 15418 1505473 posNeg 15575 1505473 2 113 5ac1bb9f7c4c52c57a96185001fa5c67510a5d7d 0 0 0 0 0  
124 20200924 GA 311046 2535146   2824816 1932 27903   5120       A 9/24/2020 14:50 2020-09-24T14:50:00Z 09/24 10:50 6822 27903 2020-09-24T14:50:00Z 2824816 289670 2535146 311046         297531 24436                 13 1368 41609 2846192 posNeg 21601 2846192 49 154 0f933d959819f7f840599ea74b82abe82c0da401 0 0 0 0 0  
128 20200924 ID 38743 258700   294063 147 1754 40 448     20901 A 9/23/2020 19:00 2020-09-23T19:00:00Z 09/23 15:00 454 1754 2020-09-23T19:00:00Z 294063     35363 416 38                         16 396 1646 297443 posNeg 1904 297443 3 14 0e8a154feff2f4be74aa5881e5c6ee9d60645454 0 0 0 0 0  
129 20200924 IL 283569 5012307   5295876 1713   400   155     A 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 8774   2020-09-24T00:00:00Z 5293678     281371 8538 236                         17 2257 59814 5295876 posNeg 62071 5295876 30 0 76fe84d28caa2298ab73216cc104309da8e32b0d 0 0 0 0 0  
132 20200924 KY 64158 1169777   1226385 543 5119 122 1499     11570 B 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 1137 5119 2020-09-24T00:00:00Z 1226385     56608 1128 9     52994               22028   21 641 9152 1233935 posNeg 9606 1233935 13 24 cb22d5c189e58bd2c0469f552c2494549bdec7c0 0 0 0 0 0  
136 20200924 ME 5215 394751   399966 14 442 1   0   4478 A+ 9/23/2020 23:59 2020-09-23T23:59:00Z 09/23 19:59 140 442 2020-09-23T23:59:00Z 399428 6470 392670 4677 139 1     10241 515 9712               23 44 13887 399966 posNeg 13931 399966 0 1 eccdb79332de9cd17c8655993f0694760e22be40 0 0 0 0 0  
137 20200924 MI 132337 3330487   3462824 558   139   50   90216 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 7019   2020-09-24T00:00:00Z 3498071 167584 3330487 119597 6700 319     288257                   26 1078 36639 3462824 posNeg 37717 3462824 6 0 bc6e3bf41679912f9b2784c2d9f309da47a99bb4 0 0 0 0 0  
141 20200924 MS 95310 626449   721759 631 5607 149   84   85327 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 2874 5607 2020-09-23T00:00:00Z 714852     88403 2651 223     37921 95             53678   28 737 4311 721759 posNeg 5048 721759 4 0 71ba7e57a4f3a3ebea2a9cccc5977b7c348ae2fc 0 0 0 0 0  
142 20200924 MT 11242 310276   321518 128 650         8634 C 9/24/2020 01:59 2020-09-24T01:59:00Z 09/23 21:59 165 650 2020-09-24T01:59:00Z 321518     11242                             30 330 4028 321518 posNeg 4358 321518 0 49 29f6da8c066b6aa586d59872f08c36388bd58b3c 0 0 0 0 0  
143 20200924 NC 198189 2672002   2870191 902   279       176422 A+ 9/24/2020 11:50 2020-09-24T11:50:00Z 09/24 07:50 3356   2020-09-24T11:50:00Z 2870191     198189 3356                           37 1688 26076 2870191 posNeg 27764 2870191 40 0 bd48aeb2d64854f81b295b3e8c2e220849c5da68 0 0 0 0 0  
147 20200924 NJ 201552 3250252   3451804 433 23252 88   34   34650 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 16091 23252 2020-09-24T00:00:00Z 3451804     201552 14300 1791                         34 564 28493 3451804 posNeg 29057 3451804 9 37 35ee2617aec17b486b9705e1ad0a8b07995e09ec 0 0 0 0 0  
148 20200924 NM 27987 850419   878406 72 3388         15669 C 9/23/2020 17:51 2020-09-23T17:51:00Z 09/23 13:51 857 3388 2020-09-23T17:51:00Z 878406     27987                             35 197 5878 878406 posNeg 6075 878406 3 17 c987f1ef96fb1d36dee1a9e947c0b90ee731661b 0 0 0 0 0  
150 20200924 NY 452847 9775798   10228645 500 89995 145   72   76382 A 9/23/2020 23:59 2020-09-23T23:59:00Z 09/23 19:59 25439 89995 2020-09-23T23:59:00Z       452847     10228645                       36 955 91998 10228645 posNeg 92953 10228645 2 0 63ceae8617c69dd2e696b201ec2dd6059b8d0350 0 0 0 0 0  
151 20200924 OH 147744 2807971   2955715 586 15051 199 3228 105   127239 A+ 9/24/2020 14:00 2020-09-24T14:00:00Z 09/24 10:00 4715 15051 2020-09-24T14:00:00Z 2947603     139632 4414 301                         39 991 23525 2955715 posNeg 24516 2955715 28 74 09764de1026355412517c78f5a5355c9d8155622 0 0 0 0 0  
152 20200924 OK 81244 1045682 7430 1126926 593 6130 227       67807 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 981 6130 2020-09-24T00:00:00Z 1140178 92217 1045682 81244         76497 3764                 40 1083 11517 1134356 posNeg 12600 1126926 11 73 be0cd9d314ecd6133fa6c070aa4b544baaaab717 0 0 0 0 0  
155 20200924 PR 43842 305972   349814 364   65   33     C 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 627   2020-09-24T00:00:00Z 310546 7002 303412 21156 456 171       22686                 72 1182 0 349814 posNeg 1182 349814 10 0 3d20930a4ea5673184a533a4882fd441ec7e5d63 0 0 0 0 0  
157 20200924 SC 142707 1064399   1207106 804 8945 194   106   68079 A+ 9/23/2020 16:25 2020-09-23T16:25:00Z 09/23 12:25 3279 8945 2020-09-23T16:25:00Z 1203420 178064 1025356 139021 3097 182     69862 6603 63259           36799 9726 45 1021 15501 1207106 posNeg 16522 1207106 17 39 f2d22087450aa5aabeb69dd24b93403ea70e0eb0 0 0 0 0 0  
159 20200924 TN 187544 2541844   2729388 813 8413 260   114   171153 A+ 9/24/2020 15:00 2020-09-24T15:00:00Z 09/24 11:00 2310 8413 2020-09-24T15:00:00Z 2722637 220826 2501811 180793 2221 89                         47 835 15210 2729388 posNeg 16045 2729388 35 75 37381b8d841ad0d8c6ee8968fabf30144a77a287 0 0 0 0 0  
160 20200924 TX 723919 5136914   5860833 3204   1051       642169 A 9/24/2020 18:05 2020-09-24T18:05:00Z 09/24 14:05 15267   2020-09-24T18:05:00Z 5860833     723919         391678 35421             77981 9120 48 4320 115839 5860833 posNeg 120159 5860833 138 0 ef731c1431ebc33082c55af4b13119e8e30dfdea 0 0 0 0 0  
162 20200924 VA 143492 1816517 358 1952965 982 18081 219   112   17099 A+ 9/23/2020 17:00 2020-09-23T17:00:00Z 09/23 13:00 3113 18081 2020-09-23T17:00:00Z   163164   136448 2907 206 1952965                       51 902 29537 1960367 posNeg 30359 1960009 24 127 7d06b1a5b91697bfe65f4e36d3f0ff87acbdeef6 0 0 0 0 0  
163 20200924 VI 1290 18534 11 19824             1208 D 9/23/2020 18:43 2020-09-23T18:43:00Z 09/23 14:43 19   2020-09-23T18:43:00Z 19835       19                           78 12 194 19835 posNeg 206 19824 0 0 8b7638a28177fb9962b7b9184d719e608ce1b89f 0 0 0 0 0  
165 20200924 WA 83702 1659594   1743296 262 7349     27     B 9/23/2020 02:59 2020-09-23T02:59:00Z 09/22 22:59 2081 7349 2020-09-23T02:59:00Z       83702 2081   1743296                       53 509 1888 1743296 posNeg 2397 1743296 11 35 2d37896ce11d6bedecea95a4c9b0a0a06ea7c6da 0 0 0 0 0  
167 20200924 WV 14706 514319   529025 173   57   30   10831 C 9/23/2020 23:59 2020-09-23T23:59:00Z 09/23 19:59 325   2020-09-23T23:59:00Z 528658     14339 323 2     17097                   54 202 3243 529025 posNeg 3445 529025 6 0 0d92e7d4a39de0e0558a4a587e700f03926d1e7a 0 0 0 0 0  
169 20200923 AK 7941 425257   433198 43       14   2731 A 9/23/2020 03:59 2020-09-23T03:59:00Z 09/22 23:59 45   2020-09-23T03:59:00Z 433198 7180 425736 7941 45                           2 55 1952 433198 posNeg 2007 433198 0 0 77a29837bdfd97f18040622b1984ee7b87e863b8 0 0 0 0 0  
170 20200923 AL 147153 938451   1070903 768 16698   1669   920 64583 A 9/23/2020 11:00 2020-09-23T11:00:00Z 09/23 07:00 2488 16698 2020-09-23T11:00:00Z 1070903     132452 2335 153           57192             1 569 4886 1085604 posNeg 5350 1085604 31 94 64268ac422e3a504e9b8401b29b1a739bf4ee1ba 0 0 0 0 0  
171 20200923 AR 77963 831301   906947 460 5098 221   89 640 69952 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 1229 5098 2020-09-23T00:00:00Z 906947   831301 75646 1080 149                 9453 2506 21856 3300 5 982 8076 909264 posNeg 8950 909264 20 43 052de2d72685a74636cebc28c54f51ef7a5c0bcb 0 0 0 0 0  
172 20200923 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 2c46457ee4f802b1f3f14dabbca92ccfbf5670d7 0 0 0 0 0  
174 20200923 CA 787470 13091953   13879423 3557   905         B 9/23/2020 02:59 2020-09-23T02:59:00Z 09/22 22:59 15204   2020-09-23T02:59:00Z 13879423     787470                             6 3146 72222 13879423 posNeg 75368 13879423 133 0 1463ec67a916e845ebd2cb9dcf143e860239b742 0 0 0 0 0  
176 20200923 CT 56315 1433583   1489898 73 11447         9204 B 9/22/2020 20:30 2020-09-22T20:30:00Z 09/22 16:30 4497 11447 2020-09-22T20:30:00Z 1487552     53969 3601 896                         9 155 9919 1489898 posNeg 10074 1489898 1 0 fd801265d4129d464fc9360a20f5f415955c3023 0 0 0 0 0  
180 20200923 GA 309678 2493537   2803215 1924 27749   5077       A 9/23/2020 14:50 2020-09-23T14:50:00Z 09/23 10:50 6773 27749 2020-09-23T14:50:00Z 2803215 287839 2515376 309678         296466 24258                 13 1457 18331 2803215 posNeg 19788 2803215 96 259 d9c14076295aafc160770ae7d6d217db1d6058ec 0 0 0 0 0  
184 20200923 ID 38347 257054   292159 130 1740 39 447     20674 A 9/22/2020 19:00 2020-09-22T19:00:00Z 09/22 15:00 451 1740 2020-09-22T19:00:00Z 292159     35105 413 38                         16 446 884 295401 posNeg 1248 295401 4 14 c6021d51e1016df795f5a68a2ce2b8f879acd8d7 0 0 0 0 0  
185 20200923 IL 281312 4952493   5233805 1563   351   144     A 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 8744   2020-09-23T00:00:00Z 5231607     279114 8508 236                         17 1848 44543 5233805 posNeg 46391 5233805 22 0 532c422e30059be3804edb66b4ca90f36dfe007f 0 0 0 0 0  
188 20200923 KY 63517 1160625   1216779 530 5095 123 1499     11480 B 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 1124 5095 2020-09-23T00:00:00Z 1216779     56154 1115 9     52939               21830   21 786 147736 1224142 posNeg 148313 1224142 5 20 f5ee5fea36480b454e9600c0ebf3aac3ee59d3d9 0 0 0 0 0  
192 20200923 ME 5171 380864   386035 14 441 2   0   4445 A+ 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 140 441 2020-09-22T23:59:00Z 391331 6426 384620 4643 139 1     10218 515 9689               23 25 10578 386035 posNeg 10603 386035 0 -1 2eacf50f526cd8664bd872418aec4ed2f4cc7d5b 0 0 0 0 0  
193 20200923 MI 131259 3293848   3425107 501   146   58   90216 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 7013   2020-09-23T00:00:00Z 3460290 166442 3293848 118615 6692 321     287162                   26 902 33327 3425107 posNeg 34229 3425107 16 0 31f3951f689d05d3416dabd37842d31d1ba026b8 0 0 0 0 0  
197 20200923 MS 94573 622138   716711 620 5607 148   74   85327 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 2870 5607 2020-09-22T00:00:00Z 710040     87902 2647 223     37700 95             51862   28 552 3658 716711 posNeg 4210 716711 24 0 8e028eb9f3dd8f021d2b011b3b023bbc8ac7f5e2 0 0 0 0 0  
198 20200923 MT 10912 306248   317160 124 601         8510 C 9/23/2020 01:59 2020-09-23T01:59:00Z 09/22 21:59 165 601 2020-09-23T01:59:00Z 317160     10912                             30 212 2939 317160 posNeg 3151 317160 2 17 5a92332dd4f07d8b2e3b3d7cfb119a64e4184f55 0 0 0 0 0  
199 20200923 NC 196501 2645926   2842427 912   281       176422 A+ 9/23/2020 12:10 2020-09-23T12:10:00Z 09/23 08:10 3316   2020-09-23T12:10:00Z 2842427     196501 3316                           37 952 16546 2842427 posNeg 17498 2842427 30 0 eab415093f779d66efff5142a1c27684e8b8e044 0 0 0 0 0  
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  

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