states_daily_4pm_et

Table actions

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

68 rows where "dateChecked" is on date 2020-06-26

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

dateChecked (date) ✖

  • 2020-06-26 · 68 ✖
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
4844 4844 20200702 MP 30 8187   8217             19 D 6/26/2020 00:22 2020-06-26T00:22:00Z 06/25 20:22 2   2020-06-26T00:22:00Z 8217     30                             69 0 0 8217 posNeg 0 8217 0 0 0a07278410cf979de943d245732003ea63522a04 0 0 0 0 0  
4900 4900 20200701 MP 30 8187   8217             19 D 6/26/2020 00:22 2020-06-26T00:22:00Z 06/25 20:22 2   2020-06-26T00:22:00Z 8217     30                             69 0 0 8217 posNeg 0 8217 0 0 08fd73a3ce6cf7200d6d24bb8e83a8958ae4e3ae 0 0 0 0 0  
4956 4956 20200630 MP 30 8187   8217             19 D 6/26/2020 00:22 2020-06-26T00:22:00Z 06/25 20:22 2   2020-06-26T00:22:00Z 8217     30                             69 0 0 8217 posNeg 0 8217 0 0 17861351a03e38f3e6050ca200dfa144a26fd83b 0 0 0 0 0  
5012 5012 20200629 MP 30 8187   8217             19 D 6/26/2020 00:22 2020-06-26T00:22:00Z 06/25 20:22 2   2020-06-26T00:22:00Z 8217     30                             69 0 0 8217 posNeg 0 8217 0 0 b63c1f4fda5e933df6e3642b0de6e8dd08e43774 0 0 0 0 0  
5059 5059 20200628 KS 13538 154321   167859   1128   356   152 779 A 6/26/2020 10:00 2020-06-26T10:00:00Z 06/26 06:00 264 1128 2020-06-26T10:00:00Z               167548                     20 0 0 167859 posNeg 0 167859 0 0 6e4f077357586c7efea8851e8c642604cce2a78b 0 0 0 0 0  
5068 5068 20200628 MP 30 8187   8217             19 D 6/26/2020 00:22 2020-06-26T00:22:00Z 06/25 20:22 2   2020-06-26T00:22:00Z 8217     30                             69 0 0 8217 posNeg 0 8217 0 0 c55491cf5bebbfe7a708d9bf8f612d650dd2a2e7 0 0 0 0 0  
5091 5091 20200628 VI 81 2746 31 2827             71 C 6/26/2020 18:49 2020-06-26T18:49:00Z 06/26 14:49 6   2020-06-26T18:49:00Z 2858       6                           78 0 0 2858 posNeg 0 2827 0 0 ef01c91bc3d73764c7b32150b930dec309eb7b8a 0 0 0 0 0  
5099 5099 20200627 AR 18740 265225   283965 284 1337     63 206 12784 A 6/26/2020 14:40 2020-06-26T14:40:00Z 06/26 10:40 249 1337 2020-06-26T14:40:00Z 283965     18740                             5 678 5907 283965 posNeg 6585 283965 9 37 88c18ffd82f84902ac72d14b043c44631e125aba 0 0 0 0 0  
5103 5103 20200627 CO 31796 275787   367175 226 5392         4430 A 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 1482 5392 2020-06-26T00:00:00Z       28972     367175 304759 102493 6800 95693               8 317 4689 307583 totalTestEncountersViral 7238 307583 7 6 62b201e6bf77dcf20a227d2ee815a8dbc7a64914 0 0 0 0 0  
5104 5104 20200627 CT 46206 392824   439030 106 10268         8053 B 6/26/2020 20:30 2020-06-26T20:30:00Z 06/26 16:30 4311 10268 2020-06-26T20:30:00Z 436644     43820 3443 868                         9 147 9059 439030 posNeg 9206 439030 4 0 797f23df2a17ea636c642fb5326b8a309d203728 0 0 0 0 0  
5105 5105 20200627 DC 10216 79055   89271 136   43   26   1194 A+ 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 548   2020-06-26T00:00:00Z             89271 69699                     11 31 1117 89271 posNeg 1148 89271 2 0 27627b871fec96871754c72dc64f75a062eebbf3 0 0 0 0 0  
5107 5107 20200627 FL 132545 1696980 1731 1829525   14432           A 6/26/2020 23:59 2020-06-26T23:59:00Z 06/26 19:59 3489 14432 2020-06-26T23:59:00Z 2186400 171768 2010839 132545 3489     1830791       236304 9575 226699         12 9585 51055 1831256 posNeg 60640 1829525 25 151 bbbe3d48b429da7062b04d349636c955e2233f34 0 0 0 0 0  
5110 5110 20200627 HI 866 73435   74301   109         705 D 6/26/2020 18:00 2020-06-26T18:00:00Z 06/26 14:00 17 109 2020-06-26T18:00:00Z 86464             74301                     15 16 1280 74301 posNeg 1296 74301 0 0 ce24cb8fe808defb94ba9aa4b6cc0da064f2e671 0 0 0 0 0  
5112 5112 20200627 ID 5148 78908   83537 42 309 19 108     3827 A 6/26/2020 19:00 2020-06-26T19:00:00Z 06/26 15:00 90 309 2020-06-26T19:00:00Z 83537     4629 70 20                         16 283 1403 84056 posNeg 1666 84056 0 6 817a1ad1f9078860210c482071dcb5abe0a4f3e8 0 0 0 0 0  
5114 5114 20200627 IN 44575 418442   463017 595 6982 257 1461 82   33725 A+ 6/26/2020 23:59 2020-06-26T23:59:00Z 06/26 19:59 2616 6982 2020-06-26T23:59:00Z         2424 192   463017                     18 435 8692 463017 posNeg 9127 463017 21 38 1c647a4fdafeebb07a1f7f8a0db3573b9a2b4f45 0 0 0 0 0  
5115 5115 20200627 KS 13538 154321   167859   1128   356   152 779 A 6/26/2020 10:00 2020-06-26T10:00:00Z 06/26 06:00 264 1128 2020-06-26T10:00:00Z               167548                     20 0 0 167859 posNeg 0 167859 0 0 ccc29de8c9e355a40021ac697b1f8ed4679b7dcc 0 0 0 0 0  
5116 5116 20200627 KY 14859 335895   350296 387 2589 74 996     3730 B 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 553 2589 2020-06-26T00:00:00Z 350296     14401 550 3     33340                   21 0 0 350754 posNeg 0 350754 0 0 8db0fbeab8d06f6e059a7061f7983e89142fb001 0 0 0 0 0  
5117 5117 20200627 LA 54769 623237   678006 700       73   39792 B 6/26/2020 13:00 2020-06-26T13:00:00Z 06/26 09:00 3190   2020-06-26T13:00:00Z       54769 3077 113   678006                     22 0 0 678006 posNeg 0 678006 0 0 0e0bfc71ddfe238ab858fd1c349cdc8c787b56eb 0 0 0 0 0  
5120 5120 20200627 ME 3154 88778   91932 24 345 7   5   2566 A 6/26/2020 23:59 2020-06-26T23:59:00Z 06/26 19:59 104 345 2020-06-26T23:59:00Z 91587 3848 87604 2809 103 1     7271 320 6943               23 52 2026 91932 posNeg 2078 91932 1 2 b974e773151234067c3b7ac8a38c078c8b435b06 0 0 0 0 0  
5122 5122 20200627 MN 35033 533874   568907 300 3986 155 1233     30401 A 6/26/2020 17:00 2020-06-26T17:00:00Z 06/26 13:00 1452 3986 2020-06-26T17:00:00Z       35033 1417 35 568907                       27 417 11212 568907 posNeg 11629 568907 6 20 e08eca02d9a5402a39591e4522f44666836053d5 0 0 0 0 0  
5124 5124 20200627 MP 30 8187   8217             19 D 6/26/2020 00:22 2020-06-26T00:22:00Z 06/25 20:22 2   2020-06-26T00:22:00Z 8217     30                             69 0 0 8217 posNeg 0 8217 0 0 5ac610599ef6e3aed3a682e796e159edc2cf2af0 0 0 0 0 0  
5125 5125 20200627 MS 25531 251790   277321 731 3078 169   90   17242 A 6/26/2020 19:00 2020-06-26T19:00:00Z 06/26 15:00 1035 3078 2020-06-26T19:00:00Z 277158     25368 1018 17     11652 95                 28 465 4962 277321 posNeg 5427 277321 13 34 df9dd7746cc5666603ced95f33fd67f6178c88de 0 0 0 0 0  
5129 5129 20200627 NE 18524 150074   168598 125 1312         12698 B 6/26/2020 20:05 2020-06-26T20:05:00Z 06/26 16:05 266 1312 2020-06-26T20:05:00Z       18524       168800                     31 178 3418 168598 posNeg 3596 168598 6 18 3fb8f7a1e5c5fb87f513745c323a90fbf718e2d5 0 0 0 0 0  
5130 5130 20200627 NH 5671 109097   144924 32 561   161     4381 B 6/26/2020 09:00 2020-06-26T09:00:00Z 06/26 05:00 365 561 2020-06-26T09:00:00Z 144924     5671       114768 21336     18518             33 0 0 114768 posNeg 2979 114768 0 0 3760b11801a0e803ab4aeb7e329ee3f79ca6690c 0 0 0 0 0  
5132 5132 20200627 NM 11408 309230   320638 128 1828         5149 B 6/26/2020 17:50 2020-06-26T17:50:00Z 06/26 13:50 489 1828 2020-06-26T17:50:00Z 320638     11408                             35 216 5752 320638 posNeg 5968 320638 4 17 e68cc9ae129d2f179a4fe998737884529579f5e5 0 0 0 0 0  
5134 5134 20200627 NY 391923 3362656   3754579 908 89995 230   167   70010 A 6/26/2020 23:59 2020-06-26T23:59:00Z 06/26 19:59 24830 89995 2020-06-26T23:59:00Z       391923     3754579                       36 703 72559 3754579 posNeg 73262 3754579 16 0 4ce45bd582f26b538d170dc4e79be5e514c07300 0 0 0 0 0  
5138 5138 20200627 PA 84370 634711   719081 651       126   65808 A+ 6/26/2020 12:00 2020-06-26T12:00:00Z 06/26 08:00 6579   2020-06-26T12:00:00Z       81956       716667                     42 0 0 719081 posNeg 0 719081 0 0 660d99daa9716a16a72e7768d6ffd6eb07689d57 0 0 0 0 0  
5141 5141 20200627 SC 31939 319225   351164 908 2622         13456 A 6/26/2020 23:59 2020-06-26T23:59:00Z 06/26 19:59 711 2622 2020-06-26T23:59:00Z 351075 40970 310105 31850 707 4     36533 1734 34799               45 1604 14889 351164 posNeg 16493 351164 17 0 c5e00fd248b5de47b710c13a849738b9d65a0bd7 0 0 0 0 0  
5142 5142 20200627 SD 6626 71474   78100 73 645         5717 B 6/26/2020 18:00 2020-06-26T18:00:00Z 06/26 14:00 91 645 2020-06-26T18:00:00Z               78100                     46 91 994 78100 posNeg 1085 78100 3 6 a2711cadb315b8e846ac7378022e66c014b289ff 0 0 0 0 0  
5146 5146 20200627 VA 61247 556679 284 626022 819 8787 234   103   7968 A+ 6/26/2020 17:00 2020-06-26T17:00:00Z 06/26 13:00 1724 8787 2020-06-26T17:00:00Z   72567   58611 1620 104 626022                       51 677 10786 618210 posNeg 10518 617926 24 65 7a6887b78c5bc87d6773cfd8d9f2cf86a880027c 0 0 0 0 0  
5147 5147 20200627 VI 81 2746 31 2827             71 C 6/26/2020 18:49 2020-06-26T18:49:00Z 06/26 14:49 6   2020-06-26T18:49:00Z 2858       6                           78 0 41 2858 posNeg 41 2827 0 0 5f0e225f06c0ecbb03a7149d7ec8d366c66edb61 0 0 0 0 0  
5149 5149 20200627 WA 34292 605293   639585 305 4194     50     B 6/26/2020 02:59 2020-06-26T02:59:00Z 06/25 22:59 1304 4194 2020-06-26T02:59:00Z       34292 1304   639585 514428                     53 489 8189 639585 posNeg 8678 639585 4 88 db432e547944bdf9b0c30689dcb5e48f721d6302 0 0 0 0 0  
5153 5153 20200626 AK 836 100956   101792 12       2   519 A 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 14   2020-06-26T00:00:00Z 101792     836 14                           2 20 2320 101792 posNeg 2340 101792 2 0 f9aae215d32d4dcfb343e6bf7dba18d5bf2d06f4 0 0 0 0 0  
5154 5154 20200626 AL 34183 344140   377857 668 2653   772   450 18866 B 6/26/2020 11:00 2020-06-26T11:00:00Z 06/26 07:00 907 2653 2020-06-26T11:00:00Z 377857     33717 887 20                         1 977 7888 378323 posNeg 8852 378323 11 41 a49fcfbc1e1d3f7c20cb72c0126a2e7674e6ce0a 0 0 0 0 0  
5155 5155 20200626 AR 18062 259318   277380 284 1300     61 203 12127 A 6/26/2020 14:40 2020-06-26T14:40:00Z 06/26 10:40 240 1300 2020-06-26T14:40:00Z 277380     18740                             5 0 0 277380 posNeg 0 277380 0 55 b93896a2c378b017acbf65f128b663522f91d931 0 0 0 0 0  
5157 5157 20200626 AZ 66548 413275   479330 2110 4514 581   312   8389 A+ 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 1535 4514 2020-06-26T00:00:00Z       66055 1435 100   479330 157620                   4 3518 12109 479823 posNeg 15530 479823 45 108 51d30879d51895bcf10bf1262b323ad25140e55f 0 0 0 0 0  
5158 5158 20200626 CA 200461 3570853   3771314 5639   1570         B 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 5812   2020-06-26T00:00:00Z 3771314     200461                             6 4890 72079 3771314 posNeg 76969 3771314 79 0 741843aadf42442c6f79812551c6d732b0c4a08d 0 0 0 0 0  
5164 5164 20200626 GA 72995 698033   771028 1184 10605   2244       A 6/26/2020 14:50 2020-06-26T14:50:00Z 06/26 10:50 2770 10605 2020-06-26T14:50:00Z 771028 66510 704518 72995         149086 8275                 13 1900 11204 771028 posNeg 13104 771028 25 148 56be45fa757631593309873c0ea3de264a849c9a 0 0 0 0 0  
5165 5165 20200626 GU 248 11644   11892 1           179 B 6/26/2020 07:30 2020-06-26T07:30:00Z 06/26 03:30 5   2020-06-26T07:30:00Z 11523 239 11284 240       11884 125 2                 66 3 471 11892 posNeg 474 11892 0 0 f8dce8cf27d00a069e151409f3cb6472773859b1 0 0 0 0 0  
5167 5167 20200626 IA 27686 255957   283643 141   42   24   17313 A+ 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 704   2020-06-26T00:00:00Z       27686       284046       31185 2255 28898         19 489 6100 283643 posNeg 6589 283643 9 0 ce86a3ceca48dec967a6fd90e8a8ef3d00118d6d 0 0 0 0 0  
5169 5169 20200626 IL 141344 1350661   1492005 1516   400   225     A 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 7048   2020-06-26T00:00:00Z 1490952     140291 6847 201                         17 910 29568 1492005 posNeg 30478 1492005 34 0 178c43fde7777c708930605d0e646bc5896da9fc 0 0 0 0 0  
5171 5171 20200626 KS 13538 154321   167859   1128   356   152 779 A 6/26/2020 10:00 2020-06-26T10:00:00Z 06/26 06:00 264 1128 2020-06-26T10:00:00Z               167548                     20 568 5586 167859 posNeg 6154 167859 3 46 9eb303e6bb6bc1e835aa00d8bcc280205bde5e49 0 0 0 0 0  
5172 5172 20200626 KY 14859 335895   350296 387 2589 74 996     3730 B 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 553 2589 2020-06-26T00:00:00Z 350296     14401 550 3     33340                   21 242 7630 350754 posNeg 7849 350754 7 5 057b3908796f731a4ee889ee16b72bd5e4578cce 0 0 0 0 0  
5173 5173 20200626 LA 54769 623237   678006 700       73   39792 B 6/26/2020 13:00 2020-06-26T13:00:00Z 06/26 09:00 3190   2020-06-26T13:00:00Z       54769 3077 113   678006                     22 1354 15987 678006 posNeg 17341 678006 26 0 b9bd96080eadce9cc670bb55730093ea9c39e7e1 0 0 0 0 0  
5174 5174 20200626 MA 108070 706015   1057242 791 11291 156   99   93157 A+ 6/26/2020 10:00 2020-06-26T10:00:00Z 06/26 06:00 8013 11291 2020-06-26T10:00:00Z 1057242 136627   103071 7815 198   809086       68259             25 233 8396 814085 totalTestsViral 13231 814085 50 39 94b214a2492fbe51ab346aa690ec05c40756ad05 0 0 0 0 0  
5175 5175 20200626 MD 66115 440282   506397 487 10725 190       4903 A 6/26/2020 10:00 2020-06-26T10:00:00Z 06/26 06:00 3142 10725 2020-06-26T10:00:00Z 607823 76821   66115 3015 127   506397                     24 338 7100 506397 posNeg 7438 506397 13 42 c25abff09c54853b1ff927d8084dc20faf2e71db 0 0 0 0 0  
5177 5177 20200626 MI 69329 912377   981706 557   193   106   49290 A+ 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 6134   2020-06-26T00:00:00Z 998490 86113 912377 62695 5888 246     151973                   26 340 18527 981706 posNeg 18867 981706 1 0 b2606652b86415f55d56ab7427726970f5209e6f 0 0 0 0 0  
5179 5179 20200626 MO 19914 328704   348618 600       66     B 6/26/2020 15:00 2020-06-26T15:00:00Z 06/26 11:00 990   2020-06-26T15:00:00Z 424214 23527 399926 19914       348618       40812 1497 39315         29 493 6477 348618 posNeg 6970 348618 8 0 345a7821d09212c000752039f6e1335467eb7bac 0 0 0 0 0  
5180 5180 20200626 MP 30 8187   8217             19 D 6/26/2020 00:22 2020-06-26T00:22:00Z 06/25 20:22 2   2020-06-26T00:22:00Z 8217     30                             69 0 0 8217 posNeg 0 8217 0 0 8d8937576104284da7f8b37f25c1ece050b4d92c 0 0 0 0 0  
5182 5182 20200626 MT 829 79332   80161 14 95         589 C 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 22 95 2020-06-26T00:00:00Z 80161     829                             30 26 1803 80161 posNeg 1829 80161 1 2 9ad6b216dd301792a5edd8a14829d8a206a3460d 0 0 0 0 0  
5183 5183 20200626 NC 58818 777907   836725 892           36921 A 6/26/2020 11:55 2020-06-26T11:55:00Z 06/26 07:55 1303   2020-06-26T11:55:00Z 836725     58818 1303                           37 1635 23812 836725 posNeg 25447 836725 19 0 0450b618b553a0627304466a405d4e0d1be8e85c 0 0 0 0 0  
5184 5184 20200626 ND 3418 97465   166289 23 222         3090 D 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 77 222 2020-06-26T00:00:00Z 169814     3418 68 9 166289 98527 4819 182 4637               38 28 1414 100883 totalTestEncountersViral 4343 100883 1 0 a4b4914580a0fd21b0b19bc6cbfdd40cf631a8c1 0 0 0 0 0  
5186 5186 20200626 NH 5671 109097   141945 32 561   161     4381 B 6/26/2020 09:00 2020-06-26T09:00:00Z 06/26 05:00 365 561 2020-06-26T09:00:00Z 141945     5671       114768 21049     18518             33 73 3129 114768 posNeg 2509 114768 18 3 49b5ce6e57dba9a66f0f392b6bb1622d8a1848c9 0 0 0 0 0  
5187 5187 20200626 NJ 170584 1176088   1346672 1118 19752 234   206   29855 A+ 6/26/2020 13:00 2020-06-26T13:00:00Z 06/26 09:00 14828 19752 2020-06-26T13:00:00Z 1346672     170584 13060 1768                         34 388 25374 1346672 posNeg 25762 1346672 43 84 15beb9fc2355695cb75d2ce91d2befa1792219dd 0 0 0 0 0  
5189 5189 20200626 NV 15860 243422   259282 471   118   59   684 A+ 6/26/2020 11:40 2020-06-26T11:40:00Z 06/26 07:40 498   2020-06-26T11:40:00Z 297635     15860       257931                     32 381 2731 259282 posNeg 3112 259282 3 0 75cfaa9bd7961aaf1a9295d7b46022724d03ae1d 0 0 0 0 0  
5191 5191 20200626 OH 48638 672914   721552 624 7570 205 1904 116     B 6/26/2020 14:00 2020-06-26T14:00:00Z 06/26 10:00 2788 7570 2020-06-26T14:00:00Z 718086     45172 2545 243                         39 987 20935 721552 posNeg 21922 721552 16 68 8b08c16a895e128148c49db5742969b517a13cd9 0 0 0 0 0  
5192 5192 20200626 OK 12343 298434   310777 308 1393 126       8817 A+ 6/26/2020 08:00 2020-06-26T08:00:00Z 06/26 04:00 377 1393 2020-06-26T08:00:00Z 312454 13338 298434 12343         30021 1058                 40 395 5417 310777 posNeg 5812 310777 2 57 a617141a80aa4cdeb3eed0d2e617b02c06da75e3 0 0 0 0 0  
5194 5194 20200626 PA 84370 634711   719081 661       131   65808 A+ 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 6579   2020-06-26T00:00:00Z       81956       716667                     42 600 13680 719081 posNeg 14280 719081 22 0 e876dc342d763d0463473521aca42c6ecd5d0034 0 0 0 0 0  
5195 5195 20200626 PR 6922 113280   120202 89   9   7     C 6/26/2020 06:30 2020-06-26T06:30:00Z 06/26 02:30 151   2020-06-26T06:30:00Z 114723 2326 112331 1583 57 94       5339                 72 45 0 120202 posNeg 45 120202 0 0 fa175ef6f0f528e9d8a2ced44e14e1516247dce8 0 0 0 0 0  
5196 5196 20200626 RI 16777 133102   244091 91 1984 16   15   1600 A+ 6/26/2020 03:00 2020-06-26T03:00:00Z 06/25 23:00 927 1984 2020-06-26T03:00:00Z 241245 23877 217368 16777     244091 149879                     44 69 1314 149879 totalTestEncountersViral 2971 149879 7 3 25a95ac494b7721f28899d01bcb7e836904d9a1d 0 0 0 0 0  
5197 5197 20200626 SC 30335 304336   334671 906 2622         13456 A 6/26/2020 16:43 2020-06-26T16:43:00Z 06/26 12:43 694 2622 2020-06-26T16:43:00Z 334198 37673 296525 30263 692 2     35242 1706 33536               45 1313 0 334671 posNeg 1313 334671 1 245 eb0d1081e652fbbf1944490707c77234d78894f4 0 0 0 0 0  
5199 5199 20200626 TN 39444 702588   742032 741 2498         25753 B 6/26/2020 15:00 2020-06-26T15:00:00Z 06/26 11:00 577 2498 2020-06-26T15:00:00Z 741737 45734 696003 39149 552 25                         47 1410 13073 742032 posNeg 14483 742032 10 67 14d802dc7775a3df2d7833b293b364ee1de0fc2b 0 0 0 0 0  
5200 5200 20200626 TX 137624 1559710   1697334 5102           76282 B 6/26/2020 16:50 2020-06-26T16:50:00Z 06/26 12:50 2324   2020-06-26T16:50:00Z 1697334     137624         177863 6871                 48 5707 32287 1697334 posNeg 37994 1697334 28 0 6204d246b4c7c476bf4c90cdfc4c0e043526ca9c 0 0 0 0 0  
5201 5201 20200626 UT 20050 297518   317568 238 1321 80 375   161 11097 A+ 6/26/2020 10:23 2020-06-26T10:23:00Z 06/26 06:23 166 1321 2020-06-26T10:23:00Z       20050       317568             128 25 145 26 49 676 4838 317568 posNeg 5514 317568 2 31 d65153b5c83cdb5805c81ddd2bebf2dc0a7686be 0 0 0 0 0  
5204 5204 20200626 VT 1198 60391   61589 14           941 B 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 56   2020-06-26T00:00:00Z       1198 56     61589                     50 7 873 61589 posNeg 880 61589 0 0 467ba449ee84a2a073c7497c465aae8df4ac2ca5 0 0 0 0 0  
5206 5206 20200626 WI 29668 507168 142 536836 262 3351 95 741     21174 A+ 6/26/2020 16:00 2020-06-26T16:00:00Z 06/26 12:00 766 3351 2020-06-26T16:00:00Z       26747 766     533915                     55 563 8607 536978 posNeg 9170 536836 0 25 ce07f3797a0dd9fd991e53a537e8b6ced725a00e 0 0 0 0 0  
5207 5207 20200626 WV 2712 159245   161957 33   10   4   1907 B 6/26/2020 10:00 2020-06-26T10:00:00Z 06/26 06:00 92   2020-06-26T10:00:00Z 161867     2622         9210                   54 51 3202 161957 posNeg 3253 161957 0 0 6bff00b7d67ac424b2ad504245c4e6632fe36af7 0 0 0 0 0  
5208 5208 20200626 WY 1368 30406   31774 5 112         1033 B 6/26/2020 18:15 2020-06-26T18:15:00Z 06/26 14:15 20 112 2020-06-26T18:15:00Z 42402 1229 41172 1079       31485                     56 42 1537 31774 posNeg 1579 31774 0 1 5d5131dedb3fc39e86de21209d2f312fcde3ac58 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
);