states_daily_4pm_et

Table actions

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

11,578 rows sorted by negativeTestsPeopleAntibody descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
8371 8371 20200430 MO 7562 73125   80687 853       141     A 4/30/2020 15:00 2020-04-30T15:00:00Z 04/30 11:00 329   2020-04-30T15:00:00Z 84070 9201 74728 7562               1043 54 988         29 137 3391 80687 posNeg 3528 80687 11 0 fba613b4d5b8e2c7be9350cea9285a960ce9cd5a 0 0 0 0 0  
7475 7475 20200516 MO 10675 128665   139340 775       116     B 5/16/2020 15:00 2020-05-16T15:00:00Z 05/16 11:00 589   2020-05-16T15:00:00Z 143966 12943 130771 10675       139340       10238 422 9802         29 219 4663 139340 posNeg 4882 139340 13 0 a131247d05ed1d12f5a5e00689cd594c10f4aae2 0 0 0 0 0  
8987 8987 20200419 MO 5667 48242   53909 875             A 4/19/2020 15:00 2020-04-19T15:00:00Z 04/19 11:00 176   2020-04-19T15:00:00Z 56834 6457 50308 5667               11 2 9         29 150 0 53909 posNeg 150 53909 1 0 acf03091066cbdae2a6fa618eef817e21683cb2b 0 0 0 0 0  
7531 7531 20200515 MO 10456 124002   134458 812       120     B 5/15/2020 15:00 2020-05-15T15:00:00Z 05/15 11:00 576   2020-05-15T15:00:00Z 139740 12685 126806 10456       134458       8770 374 8387         29 139 7209 134458 posNeg 7348 134458 14 0 c299d2f6161322892c3a67036c2fb1def0e08898 0 0 0 0 0  
7587 7587 20200514 MO 10317 116793   127110 796       115     B 5/14/2020 15:00 2020-05-14T15:00:00Z 05/14 11:00 562   2020-05-14T15:00:00Z 134975 12346 122388 10317       124006       7644 328 7307         29 175 2793 127110 posNeg 2968 127110 20 0 a2b865e74ad9ccb47de7072ef48c1ac8eb9f6b2e 0 0 0 0 0  
27 27 20200926 MO 122014 1167155   1289169 1101             B 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 2063   2020-09-26T00:00:00Z 1687509 128009 1556710 122014       1289169       74093 3508 70585         29 1716 14288 1289169 posNeg 16004 1289169 69 0 de543358a328e51d3abdbaecc32041460021841e 0 0 0 0 0  
83 83 20200925 MO 120298 1152867   1273165 1068             B 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 1994   2020-09-25T00:00:00Z 1667432 126185 1538424 120298       1273165       73815 3475 70340         29 1987 11647 1273165 posNeg 13634 1273165 42 0 5fb1f13385562456e41e7823d1cd75d9e7aff0bc 0 0 0 0 0  
139 139 20200924 MO 118311 1141220   1259531 1056             B 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 1952   2020-09-24T00:00:00Z 1649352 124668 1521891 118311       1259531       73592 3462 70130         29 1365 13603 1259531 posNeg 14968 1259531 5 0 58f4538f1ae9ca884270e304aa3c24304c774a76 0 0 0 0 0  
9043 9043 20200418 MO 5517 48242   53759 875             A 4/18/2020 15:00 2020-04-18T15:00:00Z 04/18 11:00 175   2020-04-18T15:00:00Z 54507 6260 48182 5517               8 1 7         29 234 1808 53759 posNeg 2042 53759 10 0 ffa808fb89e20483e5ca8cc8470262ff1d18e33f 0 0 0 0 0  
195 195 20200923 MO 116946 1127617   1244563 989             B 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 1947   2020-09-23T00:00:00Z 1633863 122803 1508256 116946       1244563       73234 3388 69846         29 1580 1234 1244563 posNeg 2814 1244563 83 0 3fe64a1c1b142ce9ad56681b8a79b81d26bb9f89 0 0 0 0 0  
251 251 20200922 MO 115366 1126383   1241749 981             B 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 1864   2020-09-22T00:00:00Z 1628323 122668 1502893 115366       1241749       73015 3368 69647         29 1059 21131 1241749 posNeg 22190 1241749 57 0 0a1cdcf2a179b4f4e291517c73786fa067ed6be9 0 0 0 0 0  
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  
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  
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  
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  
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  
587 587 20200916 MO 106587 1057796   1164383 989             B 9/16/2020 00:00 2020-09-16T00:00:00Z 09/15 20:00 1739   2020-09-16T00:00:00Z 1519434 114421 1402394 106587       1164383       71668 3241 68427         29 1191 7440 1164383 posNeg 8631 1164383 7 0 c89198e393eb05385f3fff16f7afd83f009f8a7c 0 0 0 0 0  
643 643 20200915 MO 105396 1050356   1155752 1021             A 9/15/2020 00:00 2020-09-15T00:00:00Z 09/14 20:00 1732   2020-09-15T00:00:00Z 1510342 113579 1394117 105396       1155752       71476 3220 68256         29 1317 9228 1155752 posNeg 10545 1155752 18 0 fcdb33cb06cfac4d763580a92aa844883676f6a4 0 0 0 0 0  
699 699 20200914 MO 104079 1041128   1145207 1010             A 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 1714   2020-09-14T00:00:00Z 1495313 112317 1380372 104079       1145207       71452 3221 68231         29 1332 15175 1145207 posNeg 16507 1145207 9 0 bf1297e8be676cead131d281f3e4682d05085f1e 0 0 0 0 0  
755 755 20200913 MO 102747 1025953   1128700 971             A 9/13/2020 00:00 2020-09-13T00:00:00Z 09/12 20:00 1705   2020-09-13T00:00:00Z 1475583 110962 1362014 102747       1128700       71148 3196 67952         29 1613 13714 1128700 posNeg 15327 1128700 1 0 02e263d5599cb0f5a01250bfe53991ed610dda9a 0 0 0 0 0  
811 811 20200912 MO 101134 1012239   1113373 1040             A 9/12/2020 00:00 2020-09-12T00:00:00Z 09/11 20:00 1704   2020-09-12T00:00:00Z 1456844 109562 1344724 101134       1113373       70997 3188 67809         29 1974 14827 1113373 posNeg 16801 1113373 3 0 7a79f40398cb83ea96e47496585d7c1d0be0a2a9 0 0 0 0 0  
867 867 20200911 MO 99160 997412   1096572 934       113     A 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 1701   2020-09-11T00:00:00Z 1437730 107727 1327482 99160       1096572       70812 3157 67655         29 1569 11079 1096572 posNeg 12648 1096572 10 0 4e22fbe33ddea3bd2f24c4cd0f1e6c04db56d733 0 0 0 0 0  
923 923 20200910 MO 97591 986333   1083924 934       113     A 9/10/2020 00:00 2020-09-10T00:00:00Z 09/09 20:00 1691   2020-09-10T00:00:00Z 1419455 106440 1310509 97591       1083924       70634 3136 67498         29 1116 11899 1083924 posNeg 13015 1083924 18 0 57f6bdd6f92555a9cf3a0d1395eb59e1b0ff3df2 0 0 0 0 0  
979 979 20200909 MO 96475 974434   1070909 934       113     A 9/9/2020 00:00 2020-09-09T00:00:00Z 09/08 20:00 1673   2020-09-09T00:00:00Z 1399957 105700 1291761 96475       1070909       70267 3112 67155         29 1362 8317 1070909 posNeg 9679 1070909 12 0 40009545c4401dc17cd3a12f069caf4521a36622 0 0 0 0 0  
1035 1035 20200908 MO 95113 966117   1061230 934       113     A 9/8/2020 00:00 2020-09-08T00:00:00Z 09/07 20:00 1661   2020-09-08T00:00:00Z 1387279 104695 1280117 95113       1061230       70177 3102 67075         29 773 6072 1061230 posNeg 6845 1061230 2 0 5166d4afe0cb64166083f93b896ff3e45b56c111 0 0 0 0 0  
1091 1091 20200907 MO 94340 960045   1054385 934       113     A 9/7/2020 00:00 2020-09-07T00:00:00Z 09/06 20:00 1659   2020-09-07T00:00:00Z 1378643 103847 1272326 94340       1054385       70158 3087 67071         29 906 7636 1054385 posNeg 8542 1054385 1 0 a5e8fe8af1cbadbe25fa0b3636465c57ab9d52e0 0 0 0 0 0  
1147 1147 20200906 MO 93434 952409   1045843 934       113     A 9/6/2020 00:00 2020-09-06T00:00:00Z 09/05 20:00 1658   2020-09-06T00:00:00Z 1368585 102766 1263356 93434       1045843       70006 3085 66921         29 1232 6310 1045843 posNeg 7542 1045843 19 0 504c8c1467d77bb8cae5cd784b89eea0e5da8b9b 0 0 0 0 0  
1203 1203 20200905 MO 92202 946099   1038301 934       113     A 9/5/2020 00:00 2020-09-05T00:00:00Z 09/04 20:00 1639   2020-09-05T00:00:00Z 1360462 101521 1256574 92202       1038301       69847 3040 66807         29 1987 14584 1038301 posNeg 16571 1038301 77 0 b2003fbc69977916e7ff6339c8852d766f21341f 0 0 0 0 0  
1259 1259 20200904 MO 90215 931515   1021730 934       113     A 9/4/2020 00:00 2020-09-04T00:00:00Z 09/03 20:00 1562   2020-09-04T00:00:00Z 1339671 99995 1237342 90215       1021730       69634 3017 66617         29 1605 12047 1021730 posNeg 13652 1021730 17 0 b339283eb38e22feb472c09464930831a764a13d 0 0 0 0 0  
1315 1315 20200903 MO 88610 919468   1008078 934       113     A 9/3/2020 00:00 2020-09-03T00:00:00Z 09/02 20:00 1545   2020-09-03T00:00:00Z 1323249 98525 1222406 88610       1008078       69430 2982 66448         29 1397 8584 1008078 posNeg 9981 1008078 3 0 2570fd97374ebe62aa21553c265ad7ed7fe41537 0 0 0 0 0  
1371 1371 20200902 MO 87213 910884   998097 934       113     A 9/2/2020 00:00 2020-09-02T00:00:00Z 09/01 20:00 1542   2020-09-02T00:00:00Z 1311023 96924 1211811 87213       998097       69257 2952 66305         29 1458 5395 998097 posNeg 6853 998097 4 0 c15c67360e3a79539b19b6f7222a96976d8f81c4 0 0 0 0 0  
1427 1427 20200901 MO 85755 905489   991244 906       110     A 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 1538   2020-09-01T00:00:00Z 1305031 96068 1206684 85755       991244       69005 2908 66097         29 1058 7231 991244 posNeg 8289 991244 8 0 9e6cfcc0dbd5d46af287d8d89618a0598321c923 0 0 0 0 0  
1483 1483 20200831 MO 84697 898258   982955 906       110     A 8/31/2020 00:00 2020-08-31T00:00:00Z 08/30 20:00 1530   2020-08-31T00:00:00Z 1294127 95127 1196755 84697       982955       68924 2899 66025         29 1042 7676 982955 posNeg 8718 982955 22 0 a6b053cc05795e383c1c4c992c6de5c5694cc84b 0 0 0 0 0  
1539 1539 20200830 MO 83655 890582   974237 1004       111     A 8/30/2020 00:00 2020-08-30T00:00:00Z 08/29 20:00 1508   2020-08-30T00:00:00Z 1283056 93879 1186910 83655       974237       68819 2884 65935         29 1465 7446 974237 posNeg 8911 974237 12 0 813a80026722e9c5349a2bad54fba055cc45b158 0 0 0 0 0  
1595 1595 20200829 MO 82190 883136   965326 976       113     A 8/29/2020 00:00 2020-08-29T00:00:00Z 08/28 20:00 1496   2020-08-29T00:00:00Z 1271859 92544 1177080 82190       965326       68525 2851 65674         29 1198 9495 965326 posNeg 10693 965326 32 0 03bf52dee6885757509aea7f44a25c7d10f4ad85 0 0 0 0 0  
1651 1651 20200828 MO 80992 873641   954633 1007       118     A 8/28/2020 00:00 2020-08-28T00:00:00Z 08/27 20:00 1464   2020-08-28T00:00:00Z 1258585 91202 1165164 80992       954633       68113 2829 65284         29 1418 10192 954633 posNeg 11610 954633 14 0 4e90be916b504d7e69ebbd5d7afd4440534a6771 0 0 0 0 0  
1707 1707 20200827 MO 79574 863449   943023 902       110     A 8/27/2020 00:00 2020-08-27T00:00:00Z 08/26 20:00 1450   2020-08-27T00:00:00Z 1243050 89878 1150970 79574       943023       67581 2778 64803         29 1512 9371 943023 posNeg 10883 943023 1 0 25a9ac540a498a7081900696794ee5fec11892c7 0 0 0 0 0  
1763 1763 20200826 MO 78062 854078   932140 882       116     A 8/26/2020 00:00 2020-08-26T00:00:00Z 08/25 20:00 1449   2020-08-26T00:00:00Z 1230039 88500 1139402 78062       932140       67139 2737 64402         29 1426 6636 932140 posNeg 8062 932140 9 0 5d8f010a056709ad6910c0da8a975f3678e73b9d 0 0 0 0 0  
1819 1819 20200825 MO 76636 847442   924078 925       119     A 8/25/2020 00:00 2020-08-25T00:00:00Z 08/24 20:00 1440   2020-08-25T00:00:00Z 1223471 87041 1134314 76636       924078       66891 2705 64186         29 692 3674 924078 posNeg 4366 924078 14 0 8666c144494fc54b38c58e923d84d389b37747bd 0 0 0 0 0  
1875 1875 20200824 MO 75944 843768   919712 957       118     A 8/24/2020 00:00 2020-08-24T00:00:00Z 08/23 20:00 1426   2020-08-24T00:00:00Z 1214456 86924 1125404 75944       919712       66838 2714 64124         29 869 4010 919712 posNeg 4879 919712 0 0 e1f73f90a691d062287896bada147856e2ff26af 0 0 0 0 0  
1931 1931 20200823 MO 75075 839758   914833 957       118     A 8/23/2020 00:00 2020-08-23T00:00:00Z 08/22 20:00 1426   2020-08-23T00:00:00Z 1218097 87456 1128457 75075       914833       66819 2710 64109         29 818 9321 914833 posNeg 10139 914833 1 0 892d3b43d01c4751e0af528110509479a95a30e5 0 0 0 0 0  
8427 8427 20200429 MO 7425 69734   77159 891       125     A 4/29/2020 15:00 2020-04-29T15:00:00Z 04/29 11:00 318   2020-04-29T15:00:00Z 79128 8781 70219 7425               678 37 640         29 122 3534 77159 posNeg 3656 77159 4 0 ae5c64569916c26f216009a59782c4427860ab06 0 0 0 0 0  
1987 1987 20200822 MO 74257 830437   904694 913       104     A 8/22/2020 00:00 2020-08-22T00:00:00Z 08/21 20:00 1425   2020-08-22T00:00:00Z 1196542 84986 1109461 74257       904694       66401 2649 63752         29 1293 7295 904694 posNeg 8588 904694 6 0 48e6551f239d52a57e1d5e165891c74146b89d3a 0 0 0 0 0  
2043 2043 20200821 MO 72964 823142   896106 875       114     A 8/21/2020 00:00 2020-08-21T00:00:00Z 08/20 20:00 1419   2020-08-21T00:00:00Z 1185535 83699 1099769 72964       896106       66061 2633 63428         29 1231 9001 896106 posNeg 10232 896106 2 0 6db58e2cecbd8337d69a83f91a90e5f409041c73 0 0 0 0 0  
7643 7643 20200513 MO 10142 114000   124142 771       129     B 5/13/2020 15:00 2020-05-13T15:00:00Z 05/13 11:00 542   2020-05-13T15:00:00Z 130101 12117 117748 10142       121296       6632 293 6330         29 136 2710 124142 posNeg 2846 124142 18 0 be298de97fd598168d2b42161ef140a8924c712c 0 0 0 0 0  
8483 8483 20200428 MO 7303 66200   73503 655       105     B 4/28/2020 15:00 2020-04-28T15:00:00Z 04/28 11:00 314   2020-04-28T15:00:00Z 75149 8424 66603 7303               667 35 631         29 132 2265 73503 posNeg 2397 73503 26 0 fdb441f49f05bc202e0a8a52f2cecadf9dde18c6 0 0 0 0 0  
2099 2099 20200820 MO 71733 814141   885874 875       114     A 8/20/2020 00:00 2020-08-20T00:00:00Z 08/19 20:00 1417   2020-08-20T00:00:00Z 1172659 82566 1088054 71733       885874       65702 2606 63096         29 1058 10021 885874 posNeg 11079 885874 3 0 934510990e0e9b9e3af02cff65ef5ba311f4b125 0 0 0 0 0  
2155 2155 20200819 MO 70675 804120   874795 875       114     A 8/19/2020 00:00 2020-08-19T00:00:00Z 08/18 20:00 1414   2020-08-19T00:00:00Z 1158444 81200 1075226 70675       874795       65313 2576 62737         29 1258 6056 874795 posNeg 7314 874795 12 0 5e0cf35b534b7c3545ad05eed98a76712fd189c2 0 0 0 0 0  
2211 2211 20200818 MO 69417 798064   867481 891       116     A 8/18/2020 00:00 2020-08-18T00:00:00Z 08/17 20:00 1402   2020-08-18T00:00:00Z 1150637 80526 1068096 69417       867481       65068 2564 62504         29 794 8070 867481 posNeg 8864 867481 6 0 3e5ae180f5484197a4e4c89aa53811587437c5b8 0 0 0 0 0  
2267 2267 20200817 MO 68623 789994   858617 853       119     A 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 1396   2020-08-17T00:00:00Z 1138890 79618 1057293 68623       858617       64968 2549 62419         29 1148 11851 858617 posNeg 12999 858617 29 0 45e0b73eae8d871911a6533b183a5a3f11994fdc 0 0 0 0 0  
7699 7699 20200512 MO 10006 111290   121296 787       140     B 5/12/2020 15:00 2020-05-12T15:00:00Z 05/12 11:00 524   2020-05-12T15:00:00Z 125042 11865 112948 10006               6514 289 6216         29 88 5588 121296 posNeg 5676 121296 36 0 b30bbf40b84c822bf8ca4acbee99588f486d526f 0 0 0 0 0  
2323 2323 20200816 MO 67475 778143   845618 889       121     A 8/16/2020 00:00 2020-08-16T00:00:00Z 08/15 20:00 1367   2020-08-16T00:00:00Z 1119127 78458 1038713 67475       845618       64503 2521 61982         29 1078 9099 845618 posNeg 10177 845618 21 0 1369af75896ae9f99a8991a4fe45770a4b95e697 0 0 0 0 0  
2379 2379 20200815 MO 66397 769044   835441 871       113     A 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 1346   2020-08-15T00:00:00Z 1106583 77152 1027492 66397       835441       64229 2492 61737         29 1127 9445 835441 posNeg 10572 835441 11 0 70c6b7c7eb6a4a68eeac1d79443e95ec3be9aebb 0 0 0 0 0  
2435 2435 20200814 MO 65270 759599   824869 882       107     A 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 1335   2020-08-14T00:00:00Z 1093970 75959 1016099 65270       824869       63781 2460 61321         29 1473 12039 824869 posNeg 13512 824869 10 0 41563e3967551a518d3528067519b864d52a09ba 0 0 0 0 0  
8539 8539 20200427 MO 7171 63935   71106 679       109     B 4/27/2020 15:00 2020-04-27T15:00:00Z 04/27 11:00 288   2020-04-27T15:00:00Z 74013 8326 65566 7171               647 35 611         29 174 1184 71106 posNeg 1358 71106 14 0 7fddf6e36628fda4d232431371d103742886e85e 0 0 0 0 0  
2491 2491 20200813 MO 63797 747560   811357 882       111     B 8/13/2020 00:00 2020-08-13T00:00:00Z 08/12 20:00 1325   2020-08-13T00:00:00Z 1074461 74219 998356 63797       811357       63158 2412 60746         29 1267 11509 811357 posNeg 12776 811357 2 0 aef609672815a8c998e5b033caa5145aecee35fe 0 0 0 0 0  
2603 2603 20200811 MO 60935 726285   787220 923       112     B 8/11/2020 00:00 2020-08-11T00:00:00Z 08/10 20:00 1312   2020-08-11T00:00:00Z 1046810 72091 972909 60935       787220       62908 2394 60514         29 981 16321 787220 posNeg 17302 787220 5 0 b330882ad6a780d20e5a9ce4c1d00d3bd322f6d0 0 0 0 0 0  
2547 2547 20200812 MO 62530 736051   798581 861       107     B 8/12/2020 00:00 2020-08-12T00:00:00Z 08/11 20:00 1323   2020-08-12T00:00:00Z 1057708 72841 983054 62530       798581       62801 2397 60404         29 1595 9766 798581 posNeg 11361 798581 11 0 193c5872069e904d7602103f7dd98adf8853df23 0 0 0 0 0  
2659 2659 20200810 MO 59954 709964   769918 923       112     B 8/10/2020 00:00 2020-08-10T00:00:00Z 08/09 20:00 1307   2020-08-10T00:00:00Z 1028968 69115 958061 59954       769918       62414 2345 60069         29 2575 14603 769918 posNeg 17178 769918 6 0 f348b7a3c70b55a964169b9301343e31b5bab7d5 0 0 0 0 0  
7755 7755 20200511 MO 9918 105702   115620 824       137     B 5/11/2020 15:00 2020-05-11T15:00:00Z 05/11 11:00 488   2020-05-11T15:00:00Z 123746 11789 111728 9918               6234 272 5953         29 74 0 115620 posNeg 74 115620 6 0 4413b55b43942ecb4314edfd408354a7b798588a 0 0 0 0 0  
2715 2715 20200809 MO 57379 695361   752740 895       105     B 8/7/2020 00:00 2020-08-07T00:00:00Z 08/06 20:00 1301   2020-08-07T00:00:00Z 996617 66665 928188 57379       752740       61708 2324 59384         29 0 0 752740 posNeg 0 752740 0 0 a46ccaf79d03d2e70e362148e16c8eb867da1ba1 0 0 0 0 0  
2771 2771 20200808 MO 57379 695361   752740 924       108     B 8/7/2020 00:00 2020-08-07T00:00:00Z 08/06 20:00 1301   2020-08-07T00:00:00Z 996617 66665 928188 57379       752740       61708 2324 59384         29 0 0 752740 posNeg 0 752740 0 0 b4ed605982ef138862eec06a578c47d88e1e3fec 0 0 0 0 0  
2827 2827 20200807 MO 57379 695361   752740 930       113     B 8/7/2020 00:00 2020-08-07T00:00:00Z 08/06 20:00 1301   2020-08-07T00:00:00Z 996617 66665 928188 57379       752740       61708 2324 59384         29 996 9433 752740 posNeg 10429 752740 21 0 9d4466381b5cb9c5a7d4dca10f1b4cb5c216567d 0 0 0 0 0  
2883 2883 20200806 MO 56383 685928   742311 966       110     B 8/6/2020 00:00 2020-08-06T00:00:00Z 08/05 20:00 1280   2020-08-06T00:00:00Z 968131 64892 901518 56383       742311       61253 2293 58960         29 1062 10675 742311 posNeg 11737 742311 8 0 151480a65b4a5c67750fdfde623336de0a7ec552 0 0 0 0 0  
2939 2939 20200805 MO 55321 675253   730574 882       101     B 8/5/2020 00:00 2020-08-05T00:00:00Z 08/04 20:00 1272   2020-08-05T00:00:00Z 957863 63881 892311 55321       730574       60779 2265 58514         29 1241 7810 730574 posNeg 9051 730574 6 0 99f2f4ce8e72a9a6c48f97ab2a85eed1e2fb53db 0 0 0 0 0  
2995 2995 20200804 MO 54080 667443   721523 891       99     B 8/4/2020 00:00 2020-08-04T00:00:00Z 08/03 20:00 1266   2020-08-04T00:00:00Z 946923 62399 882902 54080       721523       60510 2246 58264         29 1193 7382 721523 posNeg 8575 721523 11 0 32db38e18360c29d27537fc9bff970321d074eb5 0 0 0 0 0  
3051 3051 20200803 MO 52887 660061   712948 889       99     B 8/3/2020 00:00 2020-08-03T00:00:00Z 08/02 20:00 1255   2020-08-03T00:00:00Z 936013 61559 872832 52887       712948       60381 2228 58153         29 1047 9434 712948 posNeg 10481 712948 2 0 9a010c133e54e8de66f630b7fc8b82a0c4f30b13 0 0 0 0 0  
3107 3107 20200802 MO 51840 650627   702467 889       96     B 8/2/2020 15:00 2020-08-02T15:00:00Z 08/02 11:00 1253   2020-08-02T15:00:00Z 920290 60974 858109 51840       702467       59983 2215 57768         29 582 5140 702467 posNeg 5722 702467 0 0 3212d32f9652402a1e8e9588303dd3d27a44ac4e 0 0 0 0 0  
3163 3163 20200801 MO 51258 645487   696745 812       103     B 8/1/2020 15:00 2020-08-01T15:00:00Z 08/01 11:00 1253   2020-08-01T15:00:00Z 910956 59544 849835 51258       696745       59883 2206 57677         29 935 9037 696745 posNeg 9972 696745 10 0 4ed8fa62390591d8e78bd067ba8dca01b8b84617 0 0 0 0 0  
3219 3219 20200731 MO 50323 636450   686773 869       108     B 7/31/2020 15:00 2020-07-31T15:00:00Z 07/31 11:00 1243   2020-07-31T15:00:00Z 895691 57753 836423 50323       686773       59610 2178 57432         29 1489 10151 686773 posNeg 11640 686773 10 0 8f4f70b1ae36471f5368fb1754b60b1fc00a9e16 0 0 0 0 0  
3275 3275 20200730 MO 48834 626299   675133 813       111     B 7/30/2020 15:00 2020-07-30T15:00:00Z 07/30 11:00 1233   2020-07-30T15:00:00Z 877684 54787 821441 48834       675133       59210 2137 57073         29 2084 12150 675133 posNeg 14234 675133 13 0 312d654146dcedf5ef7d45eccd76a70b5023059b 0 0 0 0 0  
3331 3331 20200729 MO 46750 614149   660899 797       112     B 7/29/2020 15:00 2020-07-29T15:00:00Z 07/29 11:00 1220   2020-07-29T15:00:00Z 856436 52623 802399 46750       660899       58833 2114 56719         29 1927 6048 660899 posNeg 7975 660899 7 0 d68c087de5c4b96724da14d62f818709642ff627 0 0 0 0 0  
3387 3387 20200728 MO 44823 608101   652924 797       112     B 7/28/2020 15:00 2020-07-28T15:00:00Z 07/28 11:00 1213   2020-07-28T15:00:00Z 846657 50511 794773 44823       652924       58467 2087 56380         29 1773 9247 652924 posNeg 11020 652924 12 0 6160dc2501c179fa331b8c6fa994e84a1ea6c7e9 0 0 0 0 0  
3443 3443 20200727 MO 43050 598854   641904 1057       159     B 7/27/2020 15:00 2020-07-27T15:00:00Z 07/27 11:00 1201   2020-07-27T15:00:00Z 830014 47812 780858 43050       641904       58069 2027 56042         29 1123 13830 641904 posNeg 14953 641904 4 0 8b0bf5229ada5a5d1756dcb2e52a8b2ac1512253 0 0 0 0 0  
3499 3499 20200726 MO 41927 585024   626951 1057       159     B 7/26/2020 15:00 2020-07-26T15:00:00Z 07/26 11:00 1197   2020-07-26T15:00:00Z 806753 47784 757625 41927       626951       57483 2027 55456         29 1218 6012 626951 posNeg 7230 626951 15 0 0a7deca2649144666b4ff9cd9d72f547578241e3 0 0 0 0 0  
3555 3555 20200725 MO 40709 579012   619721 1057       159     B 7/25/2020 15:00 2020-07-25T15:00:00Z 07/25 11:00 1182   2020-07-25T15:00:00Z 795966 45726 748933 40709       619721       57152 1994 55158         29 1357 5749 619721 posNeg 7106 619721 4 0 40fa2a2d2cc4934c8cd46c4f3dfa17c9b21c02c3 0 0 0 0 0  
3611 3611 20200724 MO 39352 573263   612615 1057       159     B 7/24/2020 15:00 2020-07-24T15:00:00Z 07/24 11:00 1178   2020-07-24T15:00:00Z 784770 43687 739825 39352       612615       56784 1935 54849         29 1652 7679 612615 posNeg 9331 612615 -1 0 834e84f627a181623e0a81c6dd768b972d394c35 0 0 0 0 0  
15 15 20200926 IA 82944 667954   750898 334   84   29   65490 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 1311   2020-09-26T00:00:00Z       82944       752449       57997 3389 54568 20350 2645     19 899 5018 750898 posNeg 5917 750898 4 0 47decf503735f781b057e655041ca39b2b4fb714 0 0 0 0 0  
3667 3667 20200723 MO 37700 565584   603284 875       86     B 7/23/2020 15:00 2020-07-23T15:00:00Z 07/23 11:00 1179   2020-07-23T15:00:00Z 769616 42073 726302 37700       603284       56303 1909 54394         29 1637 12187 603284 posNeg 13824 603284 20 0 48eee833da5bf574b17970d531f83b608282f534 0 0 0 0 0  
71 71 20200925 IA 82045 662936   744981 330   87   35   62648 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 1307   2020-09-25T00:00:00Z       82045       746536       57499 3371 54088 20262 2640     19 974 5427 744981 posNeg 6401 744981 5 0 8b946f1a4d28145fbe7ed6ca8f9fb3b2a6cced4b 0 0 0 0 0  
3723 3723 20200722 MO 36063 553397   589460 875       86     B 7/22/2020 15:00 2020-07-22T15:00:00Z 07/22 11:00 1159   2020-07-22T15:00:00Z 749051 40767 707077 36063       589460       55622 1876 53746         29 1301 7839 589460 posNeg 9140 589460 16 0 55b2758bee2a3160e248e2ce3edfc7ec81e539c6 0 0 0 0 0  
127 127 20200924 IA 81071 657509   738580 305   79   37   61509 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 1302   2020-09-24T00:00:00Z       81071       740125       57067 3357 53670 19784 2511     19 1148 5579 738580 posNeg 6727 738580 8 0 153ba1e54208eacf18c27936aab903279e5bd037 0 0 0 0 0  
183 183 20200923 IA 79923 651930   731853 301   77   37   60350 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 1294   2020-09-23T00:00:00Z       79923       733400       56600 3345 53215 19021 2434     19 1036 5735 731853 posNeg 6771 731853 8 0 589e06e6feba425c24644cfff19a64e3b3ddc24a 0 0 0 0 0  
3779 3779 20200721 MO 34762 545558   580320 875       86     B 7/21/2020 15:00 2020-07-21T15:00:00Z 07/21 11:00 1143   2020-07-21T15:00:00Z 739140 39567 698398 34762       580320       54991 1861 53130         29 1138 7270 580320 posNeg 8408 580320 11 0 4888832e0d57633f8fb75bf32387687fb29e6314 0 0 0 0 0  
3835 3835 20200720 MO 33624 538288   571912 875       86     B 7/20/2020 15:00 2020-07-20T15:00:00Z 07/20 11:00 1132   2020-07-20T15:00:00Z 728137 38855 688187 33624       571912       54765 1842 52923         29 530 12303 571912 posNeg 12833 571912 3 0 e05db5f1a213269a20783cbdbfbe4069aae8af18 0 0 0 0 0  
239 239 20200922 IA 78887 646195   725082 285   72   34   59216 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 1286   2020-09-22T00:00:00Z       78887       726620       56190 3339 52811 18946 2416     19 548 2939 725082 posNeg 3487 725082 12 0 85b8765176c3738dde4329e336257ca667ee04e9 0 0 0 0 0  
7811 7811 20200510 MO 9844 105702   115546 824       137     B 5/10/2020 15:00 2020-05-10T15:00:00Z 05/10 11:00 482   2020-05-10T15:00:00Z 121559 11659 109674 9844               5533 251 5273         29 178 6470 115546 posNeg 6648 115546 10 0 824020de7a74f8c3f1ebc5b83503a9bef77797e3 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  
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  
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  
3891 3891 20200719 MO 33094 525985   559079 875       86     B 7/19/2020 15:00 2020-07-19T15:00:00Z 07/19 11:00 1129   2020-07-19T15:00:00Z 709043 37936 670037 33094       559079       53533 1829 51704         29 846 7357 559079 posNeg 8203 559079 -1 0 ff7b4449f60b1b13a5b37999bd5f7302f2971519 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  
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  
3947 3947 20200718 MO 32248 518628   550876 875       86     B 7/18/2020 15:00 2020-07-18T15:00:00Z 07/18 11:00 1130   2020-07-18T15:00:00Z 696291 36842 658406 32248       550876       52960 1817 51143         29 960 12020 550876 posNeg 12980 550876 9 0 85ec2aa3fb07d4592cf38caa335d77bc2fd2a3af 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  
4003 4003 20200717 MO 31288 506608   537896 875       86     B 7/17/2020 15:00 2020-07-17T15:00:00Z 07/17 11:00 1121   2020-07-17T15:00:00Z 677038 36023 639989 31288       537896       52265 1798 50467         29 866 7729 537896 posNeg 8595 537896 8 0 b8be534ce888ed2cdffe56a7cfc673b466fa97d4 0 0 0 0 0  
4059 4059 20200716 MO 30422 498879   529301 875       86     B 7/16/2020 15:00 2020-07-16T15:00:00Z 07/16 11:00 1113   2020-07-16T15:00:00Z 664810 35179 628610 30422       529301       52063 1789 50274         29 708 10646 529301 posNeg 11354 529301 11 0 fd4d51034b9617bc092fe6443ee9d99e2502c649 0 0 0 0 0  
631 631 20200915 IA 73277 616335   689612 284   74   29   54352 A+ 9/15/2020 00:00 2020-09-15T00:00:00Z 09/14 20:00 1234   2020-09-15T00:00:00Z       73277       691147       53494 3224 50230 16832 2112     19 401 2575 689612 posNeg 2976 689612 10 0 415fea5ac3a1d4a08d2a8b13f51331c4c0e882dc 0 0 0 0 0  
687 687 20200914 IA 72876 613760   686636 272   75   29   53417 A+ 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 1224   2020-09-14T00:00:00Z       72876       688157       53228 3205 49983 16383 2024     19 386 2805 686636 posNeg 3191 686636 6 0 6f5ae77924c1e8810a0a3c663eabb5e892d5ad2a 0 0 0 0 0  
743 743 20200913 IA 72490 610955   683445 274   79   28   53151 A+ 9/13/2020 00:00 2020-09-13T00:00:00Z 09/12 20:00 1218   2020-09-13T00:00:00Z       72490       684959       53195 3199 49956 16319 2016     19 784 3771 683445 posNeg 4555 683445 1 0 d0365bae3bf67c36784118835173dbe811f66708 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
);