states_daily_4pm_et

Table actions

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

83 rows where "dateChecked" is on date 2020-09-01

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, dateChecked, positiveTestsViral, negativeTestsViral, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-09-01 · 83 ✖
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
4 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  
60 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  
116 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  
172 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  
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  
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  
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  
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  
452 452 20200918 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 4953337207aa6ea9f70d3e91b93db3bd67bd2589 0 0 0 0 0  
508 508 20200917 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 54f9bc2755f89f45c7a1fa08c2b1a68d14fdc849 0 0 0 0 0  
564 564 20200916 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 1e432dfcc52e27d75970f4b590b1e74ec5a025a5 0 0 0 0 0  
620 620 20200915 AS 0 1571   1571               C 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 2b445be74daf156f41869a55052b390e3d37ee0e 0 0 0 0 0  
676 676 20200914 AS 0 1571   1571               C 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 174cf78dc9ab5615d074020dde4ce99fcd28e6de 0 0 0 0 0  
732 732 20200913 AS 0 1571   1571               C 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 3ae357e9638017e50197c3bf2bd193a2569941a7 0 0 0 0 0  
788 788 20200912 AS 0 1571   1571               C 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 ca96fa86c9a0c4210a96c86ab92800701dce88ad 0 0 0 0 0  
844 844 20200911 AS 0 1571   1571               C 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 af92759401b47f8c1b3777fde5b06c65b773a25a 0 0 0 0 0  
900 900 20200910 AS 0 1571   1571               C 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 aafe07069b99c5cb6e3a433727b4d1233cba2abd 0 0 0 0 0  
956 956 20200909 AS 0 1571   1571               C 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 b568d4827408ce320e19f678e9d3d4da52b89bf1 0 0 0 0 0  
980 980 20200909 MP 59 13484   13543   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     59 2     13540                     69 0 0 13543 posNeg 0 13543 0 0 03d6e521defdae0ad99269ea3876502901160d28 0 0 0 0 0  
1012 1012 20200908 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 57 1571 posNeg 57 1571 0 0 8b4aa9d198cf888bb19a9c536401d3ee1ff86512 0 0 0 0 0  
1036 1036 20200908 MP 59 13484   13543   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     59 2     13540                     69 1 0 13543 posNeg 1 13543 0 0 53b32a99df9b81349f8c9e7f038fa5b72c7bc572 0 0 0 0 0  
1092 1092 20200907 MP 58 13484   13542   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     58 2     13540                     69 0 0 13542 posNeg 0 13542 0 0 775d656966bf522797679c0f5ef1cd8d8ae1faa5 0 0 0 0 0  
1148 1148 20200906 MP 58 13484   13542   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     58 2     13540                     69 0 0 13542 posNeg 0 13542 0 0 27b844b60ca92a40925110b9427cbf144ff71f17 0 0 0 0 0  
1204 1204 20200905 MP 58 13484   13542   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     58 2     13540                     69 1 0 13542 posNeg 1 13542 0 0 6b3c8da17601c70b994000e32f6a15e806c32556 0 0 0 0 0  
1260 1260 20200904 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 0 0 13541 posNeg 0 13541 0 0 6a5775dfc03759ee10f326a446c010dc219d4e3b 0 0 0 0 0  
1316 1316 20200903 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 0 0 13541 posNeg 0 13541 0 0 6d3fbada05132b8f400b437dbc810b415fc98952 0 0 0 0 0  
1351 1351 20200902 CO 57775 660623   1014642 236 7053         5979 A+ 9/1/2020 01:59 2020-09-01T01:59:00Z 08/31 21:59 1853 7053 2020-09-01T01:59:00Z       53878     1014642 714501 158224 10966 147258               8 351 3279 718398 totalTestEncountersViral 4672 718398 4 25 6390dedf19353347575ce408692f0fd3283149ef 0 0 0 0 0  
1352 1352 20200902 CT 53108 1150871   1203979 65 11180         8967 B 9/1/2020 20:30 2020-09-01T20:30:00Z 09/01 16:30 4467 11180 2020-09-01T20:30:00Z 1201849     50978 3582 885                         9 102 11539 1203979 posNeg 11641 1203979 1 0 01ab76762b7d3161278f70030767edd0184b0e60 0 0 0 0 0  
1353 1353 20200902 DC 14077 280720   294797 73   22   8   11211 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 608   2020-09-01T00:00:00Z             294797 181300                     11 28 1925 294797 posNeg 1953 294797 1 0 d1f0ef6f6401158f3fbe9c8ca784dccf764b97bc 0 0 0 0 0  
1354 1354 20200902 DE 17549 222981   240530 62   9       9467 A+ 9/1/2020 18:00 2020-09-01T18:00:00Z 09/01 14:00 606   2020-09-01T18:00:00Z       16557 534 72   240530                     10 14 2093 240530 posNeg 2107 240530 1 0 add38598290fa882e2083f84bed00763579b58a6 0 0 0 0 0  
1355 1355 20200902 FL 633442 4060360 3515 4693802 3511 39611           A+ 9/1/2020 23:59 2020-09-01T23:59:00Z 09/01 19:59 11651 39611 2020-09-01T23:59:00Z 6461035 815752 5608276 633442 11651     4700822 446669 34738 411877 437913 34017 403867   9489     12 2402 15534 4697317 posNeg 17936 4693802 130 300 1d3a0eb59cf90c76cb7f2bd307324bee0e49f4f9 0 0 0 0 0  
1358 1358 20200902 HI 8653 193533   202186 288 532 48   27   2634 C 9/1/2020 05:59 2020-09-01T05:59:00Z 09/01 01:59 74 532 2020-09-01T05:59:00Z 268461             202186                     15 181 3823 202186 posNeg 4004 202186 4 24 8724e399b3ce098fbc1c4e35b7af67f3e924986c 0 0 0 0 0  
1360 1360 20200902 ID 32368 226728   256697 162 1394 46 381     15212 A+ 9/1/2020 19:00 2020-09-01T19:00:00Z 09/01 15:00 368 1394 2020-09-01T19:00:00Z 256697     29969 333 35                         16 280 1127 259096 posNeg 1349 259096 7 0 ac6e090f2820949ec145b2e024ef8040625ea770 0 0 0 0 0  
1362 1362 20200902 IN 95750 996846   1092596 887 11143 247 2237 69   73390 A+ 9/1/2020 23:59 2020-09-01T23:59:00Z 09/01 19:59 3325 11143 2020-09-01T23:59:00Z 1457009       3106 219   1092596                     18 859 7972 1092596 posNeg 8831 1092596 13 49 1fa59c56dfc390f291cab061f6cc5eac55b378d2 0 0 0 0 0  
1368 1368 20200902 ME 4567 268465   273032 11 423 6   1   3978 A+ 9/1/2020 23:59 2020-09-01T23:59:00Z 09/01 19:59 133 423 2020-09-01T23:59:00Z 272565 5717 266604 4100 132 1     9646 480 9153               23 19 4278 273032 posNeg 4297 273032 1 2 5ee2ed8982e8321d7ef56976957862f1f2963b41 0 0 0 0 0  
1370 1370 20200902 MN 77085 1073769   1525555 297 6566 135 1854     69521 A+ 9/1/2020 17:00 2020-09-01T17:00:00Z 09/01 13:00 1882 6566 2020-09-01T17:00:00Z       77085 1830 52 1525555 1150854                     27 730 17202 1150854 posNeg 26636 1150854 10 46 93e58ce82258beca7ca6b038a968036a85ca62d8 0 0 0 0 0  
1372 1372 20200902 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 0 0 13541 posNeg 0 13541 0 0 a431b7eb0449131837e1789a13858652ace850cf 0 0 0 0 0  
1373 1373 20200902 MS 84365 497221   581586 856 5326 190   111   67918 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2526 5326 2020-09-01T00:00:00Z 577414     80193 2364 162     26774 95             31722   28 781 3288 581586 posNeg 4069 581586 33 0 ff1e002516a9e9fc5f444324946ae8fb38dcb84f 0 0 0 0 0  
1377 1377 20200902 NE 34574 331067   365641 162 2014         26363 A+ 9/1/2020 20:30 2020-09-01T20:30:00Z 09/01 16:30 399 2014 2020-09-01T20:30:00Z       34574       366056                     31 287 2279 365641 posNeg 2566 365641 2 8 a068acc2e0436c2a35fdb8b5d21e9ea747b4c118 0 0 0 0 0  
1378 1378 20200902 NH 7297 203984   329116 8 715   221     6634 B 9/1/2020 09:00 2020-09-01T09:00:00Z 09/01 05:00 432 715 2020-09-01T09:00:00Z 329116     7297       211281 30385     29761             33 0 0 211281 posNeg 0 211281 0 0 3395348e8655ae62da6779299352168bc0f27eb1 0 0 0 0 0  
1380 1380 20200902 NM 25460 739939   765399 72 3151         13073 B 9/1/2020 17:50 2020-09-01T17:50:00Z 09/01 13:50 787 3151 2020-09-01T17:50:00Z 765399     25460                             35 108 4417 765399 posNeg 4525 765399 8 17 ab8d187f8acbf2e2ed838fa238fd53d93e77acd5 0 0 0 0 0  
1382 1382 20200902 NY 436218 7992259   8428477 445 89995 117   61   75203 A 9/1/2020 23:59 2020-09-01T23:59:00Z 09/01 19:59 25336 89995 2020-09-01T23:59:00Z       436218     8428477                       36 708 87739 8428477 posNeg 88447 8428477 5 0 5ea8d5920a5729dc75a1fe74eba5f9d63e9e6f50 0 0 0 0 0  
1389 1389 20200902 SC 120503 838529   959032 892 7948 228   145   51431 A+ 9/1/2020 23:59 2020-09-01T23:59:00Z 09/01 19:59 2794 7948 2020-09-01T23:59:00Z 957228 154856 802372 118699 2652 142     63448 5313 58135               45 657 3973 959032 posNeg 4630 959032 37 78 59582a3cfdb2746c194544988cb07a0badbf0f74 0 0 0 0 0  
1390 1390 20200902 SD 14003 134922   148925 77 1043         10959 A+ 9/1/2020 14:00 2020-09-01T14:00:00Z 09/01 10:00 169 1043 2020-09-01T14:00:00Z 196300             148925                     46 254 1076 148925 posNeg 1330 148925 2 7 b52d98839e181c97da17a6b2eb17eb71c7b543a0 0 0 0 0 0  
1394 1394 20200902 VA 122542 1488149 278 1605290 1114 16433 266   134   15319 A+ 9/1/2020 17:00 2020-09-01T17:00:00Z 09/01 13:00 2641 16433 2020-09-01T17:00:00Z   140932   117141 2508 133 1605290                       51 927 11075 1610969 posNeg 11922 1610691 29 195 536d928de5c9f1057852c1f20f42ac78749de253 0 0 0 0 0  
1395 1395 20200902 VI 1143 15343 19 16486             998 C 9/1/2020 19:17 2020-09-01T19:17:00Z 09/01 15:17 15   2020-09-01T19:17:00Z 16505       15                           78 4 95 16505 posNeg 99 16486 0 0 3b8ca2af404e5b1fec4fb5016cc008a266cb524b 0 0 0 0 0  
1396 1396 20200902 VT 1637 137459   139096 2           1433 B 9/1/2020 23:39 2020-09-01T23:39:00Z 09/01 19:39 58   2020-09-01T23:39:00Z       1637 58     139096                     50 2 648 139096 posNeg 650 139096 0 0 4459e7c9ce9fe2a527e63a99e787803b1932de82 0 0 0 0 0  
1397 1397 20200902 WA 74939 1405100   1480039 328 6787     48     B 9/1/2020 02:59 2020-09-01T02:59:00Z 08/31 22:59 1931 6787 2020-09-01T02:59:00Z       74939 1931   1480039                       53 304 6490 1480039 posNeg 6794 1480039 16 24 cc7e7d883eee90615748714463203cdad2465dc6 0 0 0 0 0  
1399 1399 20200902 WV 10642 430943   441585 146   48   27   8266 C 9/1/2020 23:59 2020-09-01T23:59:00Z 09/01 19:59 230   2020-09-01T23:59:00Z 441396     10453 228 2     16019                   54 135 3009 441585 posNeg 3144 441585 8 0 26a782dbb4c7f4c54255145c75bef9be593891ad 0 0 0 0 0  
1401 1401 20200901 AK 6160 368095   374255 41       9   2246 A 9/1/2020 03:59 2020-09-01T03:59:00Z 08/31 23:59 39   2020-09-01T03:59:00Z 374255 5974 367949 6160 39                           2 35 25590 374255 posNeg 25625 374255 2 0 5bb6d9d2b71cda18e77331f3d68c177b957c13e5 0 0 0 0 0  
1402 1402 20200901 AL 127616 831304   949438 990 14538   1487   817 48028 B 9/1/2020 11:00 2020-09-01T11:00:00Z 09/01 07:00 2200 14538 2020-09-01T11:00:00Z 949438     118134 2102 98           54076             1 1558 -27925 958920 posNeg -26943 958920 18 271 c06dbcde8a46d1053003865c92d2ffafd4d16645 0 0 0 0 0  
1403 1403 20200901 AR 61497 669528   731025 423 4306     85 554 55647 A 9/1/2020 14:38 2020-09-01T14:38:00Z 09/01 10:38 814 4306 2020-09-01T14:38:00Z 731025   669528 61497                         12508 1894 5 273 3717 731025 posNeg 3990 731025 17 93 f3415132c1f902634219223bd58c97173d552a8f 0 0 0 0 0  
1405 1405 20200901 AZ 202342 1006648   1207256 729 21405 253   150   30841 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 5044 21405 2020-09-01T00:00:00Z       200608 4777 267   1207256 267953                   4 507 4054 1208990 posNeg 4558 1208990 15 0 d4b1417c32745a6bff5fd09f9933cd9aab7659b7 0 0 0 0 0  
1406 1406 20200901 CA 707797 10762899   11470696 4869   1352         B 9/1/2020 02:59 2020-09-01T02:59:00Z 08/31 22:59 13018   2020-09-01T02:59:00Z 11470696     707797                             6 3712 93679 11470696 posNeg 97391 11470696 85 0 84d8e0d2015f6b693b70c314aac4b9dfcfc40aef 0 0 0 0 0  
1412 1412 20200901 GA 272697 2095801   2368498 2488 24847   4537       A+ 9/1/2020 14:50 2020-09-01T14:50:00Z 09/01 10:50 5733 24847 2020-09-01T14:50:00Z 2368498 249498 2119000 272697         278431 21400                 13 2226 22638 2368498 posNeg 24864 2368498 101 243 0f985f8df92d34b224978140a090e788d71b1d6c 0 0 0 0 0  
1413 1413 20200901 GU 1447 36875   38322 43   4       568 A+ 9/1/2020 05:25 2020-09-01T05:25:00Z 09/01 01:25 13   2020-09-01T05:25:00Z 38312     1439       38314 158 2                 66 52 386 38322 posNeg 438 38322 3 0 6c1d8856ee1834463c1e06d0e211680206a10819 0 0 0 0 0  
1415 1415 20200901 IA 63919 559628   623547 311   88   43   47437 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 1123   2020-09-01T00:00:00Z       63919       625058       49415 3071 46304 12398 1558     19 591 2084 623547 posNeg 2675 623547 7 0 617dedf9dabc6d700ee2628bdee277f3b7800708 0 0 0 0 0  
1417 1417 20200901 IL 238217 3850607   4088824 1513   362   146     A 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 8273   2020-09-01T00:00:00Z 4087122     236515 8064 209                         17 1492 21469 4088824 posNeg 22961 4088824 38 0 7a6a2d735958657eaa860408ad6873a7b97b1408 0 0 0 0 0  
1420 1420 20200901 KY 49185 781236   826060 552 4616 138 1391     10417 B 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 948 4616 2020-09-01T00:00:00Z 826060     44824 939 9     46878               14609   21 789 8312 830421 posNeg 8924 830421 15 36 dd39a90c4a20e6331da6170bb9e8623bf2dda66e 0 0 0 0 0  
1421 1421 20200901 LA 149583 1740943   1890526 910       128   127918 A 9/1/2020 13:00 2020-09-01T13:00:00Z 09/01 09:00 4984   2020-09-01T13:00:00Z       148882 4821 163   1889825                     22 689 16347 1890526 posNeg 17036 1890526 34 0 26bc2f76c96509b5349f49498891ac763478e0f8 0 0 0 0 0  
1422 1422 20200901 MA 128888 1635284   2448341 320 12386 55   29   103920 A+ 9/1/2020 08:00 2020-09-01T08:00:00Z 09/01 04:00 9064 12386 2020-09-01T08:00:00Z 2448341 156836   119138 8831 232   1754422       112996     87251       25 355 21300 1764172 totalTestsViral 43915 1764172 4 22 23fbac77ffd06460ad5cc17dd381cb96f3a38817 0 0 0 0 0  
1423 1423 20200901 MD 108863 1230054   1338917 385 14337 112       6976 A+ 9/1/2020 10:00 2020-09-01T10:00:00Z 09/01 06:00 3761 14337 2020-09-01T10:00:00Z 1952501 129682   108863 3617 144   1338917                     24 614 7450 1338917 posNeg 8064 1338917 6 34 09ba7eb99e59e61babb72d9c0cb90d697d675bbd 0 0 0 0 0  
1425 1425 20200901 MI 113820 2675587   2789407 629   156   83   76151 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 6767   2020-09-01T00:00:00Z 2821258 145671 2675587 103186 6495 272     258577                   26 795 24181 2789407 posNeg 24976 2789407 14 0 23bde657bac2c6873e6a2743fc5f3d525236e29c 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  
1428 1428 20200901 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 1 0 13541 posNeg 1 13541 0 0 29df9ccd3c08f0f2abac3816e10084cc5a034b82 0 0 0 0 0  
1429 1429 20200901 MS 83584 493933   577517 798 5326 196   117   67918 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2493 5326 2020-09-01T00:00:00Z 573583     79650 2337 156     26337 95             31360   28 634 3018 577517 posNeg 3652 577517 20 0 eb269dba58ffd9ac5a6927dc36aacfc41f176044 0 0 0 0 0  
1430 1430 20200901 MT 7509 244787   252296 140 447         5459 B 9/1/2020 01:59 2020-09-01T01:59:00Z 08/31 21:59 105 447 2020-09-01T01:59:00Z 252296     7509                             30 88 1970 252296 posNeg 2058 252296 1 11 9b450ea667382d582afd90debb22555d5b651a08 0 0 0 0 0  
1431 1431 20200901 NC 169424 2126274   2295698 946   270       145884 A+ 9/1/2020 12:20 2020-09-01T12:20:00Z 09/01 08:20 2741   2020-09-01T12:20:00Z 2295698     169424 2741                           37 2111 37415 2295698 posNeg 39526 2295698 39 0 35b60e27ced475a9a764bcf6a5d6986a452ee240 0 0 0 0 0  
1432 1432 20200901 ND 12004 190418   458586 62 564 15 152     9610 A 9/1/2020 01:59 2020-09-01T01:59:00Z 08/31 21:59 122 564 2020-09-01T01:59:00Z 473749     12004 118 4 458586 201357 8616 338 8278               38 194 473 202422 totalTestEncountersViral 2396 202422 4 10 8166581d2e21ed24982d9b4fa86bb4909488a82a 0 0 0 0 0  
1434 1434 20200901 NH 7297 203984   329116 8 715   221     6634 B 9/1/2020 09:00 2020-09-01T09:00:00Z 09/01 05:00 432 715 2020-09-01T09:00:00Z 329116     7297       211281 30385     29761             33 22 343 211281 posNeg 1021 211281 0 1 bed06694de17f15dd5d239e76edcb7bd962127e9 0 0 0 0 0  
1435 1435 20200901 NJ 192290 2666758   2859048 463 22667 84   33   33949 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 15960 22667 2020-09-01T00:00:00Z 2857918     192290 14170 1790                         34 330 800 2859048 posNeg 1130 2859048 5 40 6c4d6881b8d20d680fa1dba9f0d4096b2ac5eb3f 0 0 0 0 0  
1437 1437 20200901 NV 69633 530716   600349 643   193   119   1798 A+ 9/1/2020 02:59 2020-09-01T02:59:00Z 08/31 22:59 1313   2020-09-01T02:59:00Z 859175     69633       599812                     32 405 2023 600349 posNeg 2428 600349 8 0 4ac829e935d0ee8dd9327c1fc95899f2ac2a8d41 0 0 0 0 0  
1439 1439 20200901 OH 124610 2145059   2269669 777 13479 241 2975 127   104024 A+ 9/1/2020 14:00 2020-09-01T14:00:00Z 09/01 10:00 4165 13479 2020-09-01T14:00:00Z 2263107     118048 3879 286                         39 1453 24112 2269669 posNeg 25565 2269669 27 103 cd8aecf1fa4bf4b3584158398cc100080fbef846 0 0 0 0 0  
1440 1440 20200901 OK 59399 827513 2776 886912 535 4903 207       49989 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 809 4903 2020-09-01T00:00:00Z 898288 69077 827513 59399         68964 3006                 40 666 20968 889688 posNeg 21634 886912 9 82 9f13e6b5899ebb0ee34a06a835d5df054da853e8 0 0 0 0 0  
1441 1441 20200901 OR 26946 534854   561800 132 2162 49   25   4938 A+ 9/1/2020 03:01 2020-09-01T03:01:00Z 08/31 23:01 465 2162 2020-09-01T03:01:00Z     534854 25639       560493                     41 233 4339 561800 posNeg 4572 561800 6 13 21741fda8f80ceedfcbdc3bd2af8aaef4308b031 0 0 0 0 0  
1442 1442 20200901 PA 134795 1539969   1674764 528       73   109183 A+ 9/1/2020 12:00 2020-09-01T12:00:00Z 09/01 08:00 7691   2020-09-01T12:00:00Z       130961       1670930                     42 770 15774 1674764 posNeg 16544 1674764 18 0 e5450e32195ed7e27d68330dc90c030c3263966c 0 0 0 0 0  
1443 1443 20200901 PR 33421 305972   339393 392   71   51     B 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 435   2020-09-01T00:00:00Z 310546 7002 303412 15584 288 147       17837                 72 222 0 339393 posNeg 222 339393 1 0 21a9ecfe1a882b2a40902a762527f29f437dd4b8 0 0 0 0 0  
1444 1444 20200901 RI 22002 254480   530488 81 2528 8   5   2113 A+ 9/1/2020 12:00 2020-09-01T12:00:00Z 09/01 08:00 1050 2528 2020-09-01T12:00:00Z   31281 499207 22002     530488 276482                     44 53 2532 276482 totalTestEncountersViral 6074 276482 2 9 214dfdf5c85fb708ca4a7f359d1b0687ebc32e61 0 0 0 0 0  
1447 1447 20200901 TN 156329 2061422   2217751 1037 6978 348   164   118885 A+ 9/1/2020 15:00 2020-09-01T15:00:00Z 09/01 11:00 1781 6978 2020-09-01T15:00:00Z 2213949 184950 2028999 152527 1729 52                         47 1396 15356 2217751 posNeg 16752 2217751 27 100 e9ee87313e3f309329f02c06b8155cdc7e9b08f9 0 0 0 0 0  
1448 1448 20200901 TX 617333 4416221   5033554 4144   1525       514861 A+ 9/1/2020 16:30 2020-09-01T16:30:00Z 09/01 12:30 12681   2020-09-01T16:30:00Z 5033554     617333         359593 30159             25577 3529 48 4364 67637 5033554 posNeg 72001 5033554 145 0 9f5bc1a8d744d0b67826563d851e730271ce700e 0 0 0 0 0  
1449 1449 20200901 UT 52403 612118   664521 145 3110 44 780   322 44338 A+ 9/1/2020 11:08 2020-09-01T11:08:00Z 09/01 07:08 409 3110 2020-09-01T11:08:00Z 823155     52403       664521             4710 981 5706 1046 49 296 4370 664521 posNeg 4666 664521 2 17 ea13ea22474fbb9ff4257cf170c33d2d7bd68bd4 0 0 0 0 0  
1454 1454 20200901 WI 81604 1183717 167 1265321 295 5878 100 1026     67902 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 1139 5878 2020-09-01T00:00:00Z       76584 1130 9   1260301                     55 1036 10863 1265488 posNeg 11899 1265321 9 61 ac18dec967f45ae62eb2811aac97da85ccfe5f93 0 0 0 0 0  
1456 1456 20200901 WY 3866 72701   76567 13 219         3206 A 9/1/2020 17:36 2020-09-01T17:36:00Z 09/01 13:36 41 219 2020-09-01T17:36:00Z 108187 3137 105049 3282       75983                     56 24 270 76567 posNeg 294 76567 4 4 7f800359a42e19161fb7291822ba50846451e076 0 0 0 0 0  

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