states_daily_4pm_et

Table actions

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

61 rows where "dateChecked" is on date 2020-07-31

✎ 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, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-07-31 · 61 ✖
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
3093 3093 20200802 GU 367 21685   22052 2   2       304 B 7/31/2020 21:30 2020-07-31T21:30:00Z 07/31 17:30 5   2020-07-31T21:30:00Z 21873     359       22044 145 2                 66 0 0 22052 posNeg 0 22052 0 0 cb7577050ceb959b5e51bf60baad0e7554fb5e30 0 0 0 0 0  
3099 3099 20200802 KS 27812 264695   292507 366 1751 98 494 26 179 1178 A+ 7/31/2020 10:00 2020-07-31T10:00:00Z 07/31 06:00 358 1751 2020-07-31T10:00:00Z               292507                     20 0 0 292507 posNeg 0 292507 0 0 6b49b4c3e78c568e04d8514e87ab72926db0c87e 0 0 0 0 0  
3109 3109 20200802 MS 60553 401592   462145 1172 4314 302   172   35071 A+ 7/31/2020 19:00 2020-07-31T19:00:00Z 07/31 15:00 1703 4314 2020-07-31T19:00:00Z 460594     59637 1657 46     16566 95                 28 672 0 462145 posNeg 672 462145 10 0 6d33b4b84662d3298198c987c9ef6c26de10316c 0 0 0 0 0  
3124 3124 20200802 RI 19022 186994   373276 76 2211 15   5   1823 A+ 7/31/2020 12:00 2020-07-31T12:00:00Z 07/31 08:00 1007 2211 2020-07-31T12:00:00Z 365066 27600 337466 19022     373276 206016                     44 0 0 206016 totalTestEncountersViral 3974 206016 0 0 4ea2c17a22a6990ef718519a4ae7167a163cc946 0 0 0 0 0  
3142 3142 20200801 CA 500130 7386457   7886587 7754   2120         B 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 9224   2020-07-31T00:00:00Z 7886587     500130                             6 6542 69004 7886587 posNeg 75546 7886587 219 0 508ca3cd8b105c801aab8f1b9d52e6acb4a19c7d 0 0 0 0 0  
3145 3145 20200801 DC 12205 181576   193781 100   26   13   9816 A+ 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 585   2020-07-31T00:00:00Z             193781 131031                     11 79 4961 193781 posNeg 5040 193781 0 0 775894e6012ab7a380072be67e2f4503813682c0 0 0 0 0 0  
3146 3146 20200801 DE 14877 168019   182896 45   18       8212 A+ 7/31/2020 18:00 2020-07-31T18:00:00Z 07/31 14:00 585   2020-07-31T18:00:00Z       13880 515 70   182896                     10 89 1760 182896 posNeg 1849 182896 0 0 2844f2eb09314864e222a7c8d2b226844a947252 0 0 0 0 0  
3147 3147 20200801 FL 480028 3199415 3409 3679443 8072 27344           A 7/31/2020 23:59 2020-07-31T23:59:00Z 07/31 19:59 7144 27344 2020-07-31T23:59:00Z 4793361 605946 4166771 480028 7144     3684875 358283 19175 339059 353026 18780 334221         12 9642 41713 3682852 posNeg 51355 3679443 178 439 774402daf0d1db26dc99c0492abaee1a0276df8a 0 0 0 0 0  
3149 3149 20200801 GU 367 21685   22052 2   2       304 B 7/31/2020 21:25 2020-07-31T21:25:00Z 07/31 17:25 5   2020-07-31T21:25:00Z 21873     359       22044 145 2                 66 11 159 22052 posNeg 170 22052 0 0 2e41c14772f975762924ada65ddff55530bebfc7 0 0 0 0 0  
3150 3150 20200801 HI 2111 121140   123251 75 179 15   10   1243 C 7/31/2020 23:31 2020-07-31T23:31:00Z 07/31 19:31 26 179 2020-07-31T23:31:00Z 152976             123251                     15 122 1761 123251 posNeg 1883 123251 0 2 a28914e1b8ffd873ade73e16be21fa62536c181e 0 0 0 0 0  
3152 3152 20200801 ID 20721 161152   180615 239 850 54 249     6998 A 7/31/2020 19:15 2020-07-31T19:15:00Z 07/31 15:15 189 850 2020-07-31T19:15:00Z 180615     19463 155 22                         16 475 2288 181873 posNeg 2731 181873 12 15 12ea038fb5d63c555ea1c031f8de56c55a9ce022 0 0 0 0 0  
3154 3154 20200801 IN 67122 691484   758606 977 8781 322 1836 81   46955 A+ 7/31/2020 23:59 2020-07-31T23:59:00Z 07/31 19:59 2971 8781 2020-07-31T23:59:00Z 942105       2771 200   758606                     18 968 10255 758606 posNeg 11223 758606 6 54 3a277d3a8af8647c7ba282f70694ed8dffe58de0 0 0 0 0 0  
3155 3155 20200801 KS 27812 264695   292507 366 1751 98 494 26 179 1178 A+ 7/31/2020 10:00 2020-07-31T10:00:00Z 07/31 06:00 358 1751 2020-07-31T10:00:00Z               292507                     20 0 0 292507 posNeg 0 292507 0 0 2991f627bdec916a8ca37c83b18aceac4d01c22a 0 0 0 0 0  
3157 3157 20200801 LA 116280 1225963   1342243 1546       222   74246 A 7/31/2020 13:00 2020-07-31T13:00:00Z 07/31 09:00 3949   2020-07-31T13:00:00Z       116280 3835 114   1342243                     22 0 0 1342243 posNeg 0 1342243 0 0 6fc3d8825283b838d7e59f5c9e8dffd8b0a548dc 0 0 0 0 0  
3158 3158 20200801 MA 118040 1083123   1613551 369 11930 53   26   97595 A+ 7/31/2020 10:00 2020-07-31T10:00:00Z 07/31 06:00 8626 11930 2020-07-31T10:00:00Z 1613551 146945   110077 8406 220   1193200       96964             25 428 12305 1201163 totalTestsViral 11055 1201163 17 22 190a9c8cec92d477f66258291f5701c390a7e665 0 0 0 0 0  
3160 3160 20200801 ME 3937 165809   169746 10 388 5   1   3377 A+ 7/31/2020 23:59 2020-07-31T23:59:00Z 07/31 19:59 123 388 2020-07-31T23:59:00Z 169325 4905 164215 3516 122 1     8854 417 8425               23 25 2554 169746 posNeg 2579 169746 0 0 ffbcd38dd4a8140c76b1cd558d1faa8e2fe413c0 0 0 0 0 0  
3162 3162 20200801 MN 55188 791080   1040317 317 5208 149 1520     48119 A 7/31/2020 17:00 2020-07-31T17:00:00Z 07/31 13:00 1646 5208 2020-07-31T17:00:00Z       55188 1606 40 1040317 846268                     27 725 11189 846268 posNeg 15401 846268 6 53 ad8672ffdf917ab981ad0d53a92f1ead3b1606b1 0 0 0 0 0  
3165 3165 20200801 MS 59881 401592   461473 1172 4314 302   172   35071 A+ 7/31/2020 19:00 2020-07-31T19:00:00Z 07/31 15:00 1693 4314 2020-07-31T19:00:00Z 460594     59002 1648 45     16566 95                 28 1134 5834 461473 posNeg 6968 461473 30 38 8f4d57146c136f7c444a06ddbe2ad42fd3c038b2 0 0 0 0 0  
3169 3169 20200801 NE 26211 249048   275259 152 1622         19172 A 7/31/2020 20:10 2020-07-31T20:10:00Z 07/31 16:10 332 1622 2020-07-31T20:10:00Z       26211       275544                     31 445 3858 275259 posNeg 4303 275259 4 12 3c5e13f6c58dc948183d249b2ee14f0eee4089f0 0 0 0 0 0  
3172 3172 20200801 NM 20600 537412   558012 152 2686         8139 B 7/31/2020 17:50 2020-07-31T17:50:00Z 07/31 13:50 642 2686 2020-07-31T17:50:00Z 558012     20600                             35 212 6163 558012 posNeg 6375 558012 7 19 5064227550275dda6c531303d1e5c54118542aac 0 0 0 0 0  
3174 3174 20200801 NY 415767 5556207   5971974 581 89995 147   72   73134 A 7/31/2020 15:35 2020-07-31T15:35:00Z 07/31 11:35 25164 89995 2020-07-31T15:35:00Z       415767     5971974                       36 753 81984 5971974 posNeg 82737 5971974 14 0 cfb8fd3245d8f5c82e53fdf3e77825bfc3e9f3f9 0 0 0 0 0  
3180 3180 20200801 RI 19022 186994   369302 76 2211 15   5   1823 A+ 7/31/2020 12:00 2020-07-31T12:00:00Z 07/31 08:00 1007 2211 2020-07-31T12:00:00Z 365066 27600 337466 19022     369302 206016                     44 0 0 206016 totalTestEncountersViral 5176 206016 0 0 bd68d36b3018900994e405bb006d00f4cca4dece 0 0 0 0 0  
3181 3181 20200801 SC 90599 621270   711869 1453 5527 359   235   32859 A+ 7/31/2020 23:59 2020-07-31T23:59:00Z 07/31 19:59 1751 5527 2020-07-31T23:59:00Z 711346 114251 597095 90076 1683 68     53233 3557 49676               45 1583 17451 711869 posNeg 19034 711869 39 410 96bed9ac5f6b04e72ecf85c5d466ffdde7d191e3 0 0 0 0 0  
3182 3182 20200801 SD 8867 104065   112932 36 832         7820 B 7/31/2020 18:00 2020-07-31T18:00:00Z 07/31 14:00 134 832 2020-07-31T18:00:00Z               112932                     46 103 1194 112932 posNeg 1297 112932 4 8 9867ce5961ffc4156478030d5b724cef516df2f1 0 0 0 0 0  
3186 3186 20200801 VA 90801 1036560 352 1123927 1256 13263 275   150   12007 A+ 7/31/2020 17:00 2020-07-31T17:00:00Z 07/31 13:00 2215 13263 2020-07-31T17:00:00Z   107823   87367 2105 110 1123927                       51 913 15701 1127713 posNeg 16567 1127361 41 -8 f118a69d753a8efb2e5229887468fa2df322872d 0 0 0 0 0  
3193 3193 20200731 AK 3677 229429   233106 40       3   898 A 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 23   2020-07-31T00:00:00Z 233106     3677 23                           2 118 7931 233106 posNeg 8049 233106 0 0 061dbd607d6dc83981c9d4f65ce38d9c3fd04714 0 0 0 0 0  
3194 3194 20200731 AL 87723 601744   687022 1596 10521   1144   613 35401 B 7/31/2020 11:00 2020-07-31T11:00:00Z 07/31 07:00 1580 10521 2020-07-31T11:00:00Z 687022     85278 1531 49                         1 1961 7398 689467 posNeg 9181 689467 15 451 4c194d2de2fef83417180863ea3fc37b8d019ff0 0 0 0 0 0  
3195 3195 20200731 AR 42511 460958   502717 507 2852     100 395 35413 A 7/31/2020 14:40 2020-07-31T14:40:00Z 07/31 10:40 453 2852 2020-07-31T14:40:00Z 502717     42511                         7090 1085 5 752 0 503469 posNeg 0 503469 11 105 11bf0b6092c522c0bed3770d6f603a8f297d2d6b 0 0 0 0 0  
3197 3197 20200731 AZ 174010 759733   933743 2302 11260 719   505   22714 A+ 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 3694 11260 2020-07-31T00:00:00Z       137710 2431 152   933743 227897                   4 3212 17265 933743 posNeg 20477 933743 68 88 62e3a64f227c6ec4bd0732fc9ddef5f4ce8c11a6 0 0 0 0 0  
3198 3198 20200731 CA 493588 7317453   7811041 7999   2163         B 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 9005   2020-07-31T00:00:00Z 7811041     493588                             6 8086 169115 7811041 posNeg 177201 7811041 96 0 7120aada3e21e93383f857d4827d8f6402c2b913 0 0 0 0 0  
3199 3199 20200731 CO 46204 480142   678823 350 6413         5309 A 7/31/2020 01:59 2020-07-31T01:59:00Z 07/30 21:59 1691 6413 2020-07-31T01:59:00Z       43032     678823 523174 136714 9293 127421               8 408 6266 526346 totalTestEncountersViral 10578 526346 3 15 4147c7602aafe161a6ccbeee8a6592f9a8df83cf 0 0 0 0 0  
3204 3204 20200731 GA 186352 1388335   1574687 3155 18689   3414       A 7/31/2020 14:50 2020-07-31T14:50:00Z 07/31 10:50 3752 18689 2020-07-31T14:50:00Z 1574687 171306 1403381 186352         222213 14138                 13 4066 29232 1574687 posNeg 33298 1574687 81 386 1ff562388caa2cf363e9c4e8c4db804a0f4624e6 0 0 0 0 0  
3207 3207 20200731 IA 44582 429830   474412 225   71   29   32578 A+ 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 867   2020-07-31T00:00:00Z       44582       476322       39222 2744 36439         19 544 4770 474412 posNeg 5314 474412 10 0 d8892edf77c318f72ed10069800c1083f09a37a7 0 0 0 0 0  
3209 3209 20200731 IL 180118 2520731   2700849 1369   346   148     A 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 7692   2020-07-31T00:00:00Z 2699568     178837 7495 197                         17 1980 47841 2700849 posNeg 49821 2700849 22 0 489a3298d72534f97237a5295c97c89b36eb173a 0 0 0 0 0  
3211 3211 20200731 KS 27812 264695   292507 366 1751 98 494 26 179 1178 A+ 7/31/2020 10:00 2020-07-31T10:00:00Z 07/31 06:00 358 1751 2020-07-31T10:00:00Z               292507                     20 942 6616 292507 posNeg 7558 292507 9 51 8e73abfd4988d50c73a96e43e35203b34f72e715 0 0 0 0 0  
3212 3212 20200731 KY 30151 557672   586076 597 3314 150 1133     7481 B 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 735 3314 2020-07-31T00:00:00Z 586076     28404 731 4     43408               222   21 765 7752 587823 posNeg 8440 587823 4 10 3e89373f5e4e84ff26037c6cb80063de33d6d9aa 0 0 0 0 0  
3213 3213 20200731 LA 116280 1225963   1342243 1546       222   74246 A 7/31/2020 13:00 2020-07-31T13:00:00Z 07/31 09:00 3949   2020-07-31T13:00:00Z       116280 3835 114   1342243                     22 1799 23054 1342243 posNeg 24853 1342243 24 0 08dc0ba785207d3ee64150fa6f462c284fdfd04d 0 0 0 0 0  
3214 3214 20200731 MA 117612 1070818   1602496 347 11908 58   28   97595 A+ 7/31/2020 10:00 2020-07-31T10:00:00Z 07/31 06:00 8609 11908 2020-07-31T10:00:00Z 1602496 146758   109787 8389 220   1180605       96180             25 514 18764 1188430 totalTestsViral 21526 1188430 14 15 f5ab8508f56906807ba553762a83a6fcdd9138ac 0 0 0 0 0  
3215 3215 20200731 MD 88346 822845   911191 590 12593 128       5689 A 7/31/2020 10:00 2020-07-31T10:00:00Z 07/31 06:00 3493 12593 2020-07-31T10:00:00Z 1209223 103840   88346 3362 131   911191                     24 1169 16057 911191 posNeg 17226 911191 5 93 b3cc1a81881200edf4732cc750a78eba3703760e 0 0 0 0 0  
3217 3217 20200731 MI 90574 1753873   1844447 727   238   144   57502 A+ 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 6450   2020-07-31T00:00:00Z 1868156 114283 1753873 81621 6199 251     214923                   26 793 30476 1844447 posNeg 31269 1844447 7 0 72cb17b989cd84db0710041c9a3d3e933b57abf0 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  
3222 3222 20200731 MT 3965 166005   169970 71 230         2331 C 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 60 230 2020-07-31T00:00:00Z 169970     3965                             30 151 1203 169970 posNeg 1354 169970 5 9 497454692e71ad8c7e6d10c7112c2348725fa319 0 0 0 0 0  
3223 3223 20200731 NC 122148 1634954   1757102 1229   363       92302 A+ 7/31/2020 11:55 2020-07-31T11:55:00Z 07/31 07:55 1924   2020-07-31T11:55:00Z 1757102     122148 1924                           37 1954 30224 1757102 posNeg 32178 1757102 21 0 59663663ce1a7fda7cb40c46a54167d2bda791c2 0 0 0 0 0  
3224 3224 20200731 ND 6461 147495   301509 47 364         5289 C 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 95 364 2020-07-31T00:00:00Z 310230     6461 91 4 301509 151245 7354 261 7093               38 167 1935 153956 totalTestEncountersViral 5031 153956 0 8 954a82329de633ddb061383fcb0ce9fec55ab7b0 0 0 0 0 0  
3227 3227 20200731 NJ 181660 1914669   2096329 695 21565 113   45   32475 A+ 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 15728 21565 2020-07-31T00:00:00Z 2096329     181660 13944 1784                         34 690 36075 2096329 posNeg 36765 2096329 11 0 d429c7ed83fe6295973f34065af57174d3825a2f 0 0 0 0 0  
3229 3229 20200731 NV 48088 421815   469903 1159   333   191   1127 A+ 7/31/2020 02:59 2020-07-31T02:59:00Z 07/30 22:59 830   2020-07-31T02:59:00Z 616731     48088       468967                     32 1264 4994 469903 posNeg 6258 469903 29 0 7fb96fc7e90a614938c36a179745872031d83378 0 0 0 0 0  
3231 3231 20200731 OH 91159 1377175   1468334 1024 10790 330 2552 185   65788 B 7/31/2020 14:00 2020-07-31T14:00:00Z 07/31 10:00 3489 10790 2020-07-31T14:00:00Z 1463508     86333 3222 267                         39 1533 20329 1468334 posNeg 21862 1468334 47 112 840f706b145150d69f2f49bf5585fe2421641402 0 0 0 0 0  
3232 3232 20200731 OK 36487 589091   625578 621 3161 253       29187 A+ 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 541 3161 2020-07-31T00:00:00Z 632535 42245 589091 36487         57683 2071                 40 747 9815 625578 posNeg 10562 625578 5 57 b2362d885a897a091aaf1b650b6bfef521f9582e 0 0 0 0 0  
3233 3233 20200731 OR 18492 385701   404193 208 1607 65   32   3872 A+ 7/31/2020 03:01 2020-07-31T03:01:00Z 07/30 23:01 322 1607 2020-07-31T03:01:00Z     385701 17540       403241                     41 361 5193 404193 posNeg 5554 404193 6 20 43b894b00ff8f52b0a6eff54f260b44029a6d0d3 0 0 0 0 0  
3234 3234 20200731 PA 112048 1104824   1216872 522       89   84036 A+ 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 7189   2020-07-31T00:00:00Z       108907       1213731                     42 970 15965 1216872 posNeg 16935 1216872 13 0 8912619276b65c4ff5f6562c5901c3b25ac85444 0 0 0 0 0  
3235 3235 20200731 PR 16781 305972   322753 488   62   39     B 7/31/2020 06:30 2020-07-31T06:30:00Z 07/31 02:30 219   2020-07-31T06:30:00Z 310546 7002 303412 5997 113 106       10784                 72 209 0 322753 posNeg 209 322753 5 0 4385e1a5582d72002d8b9ac840333b48df1347d6 0 0 0 0 0  
3236 3236 20200731 RI 19022 186994   364126 76 2211 15   5   1823 A+ 7/31/2020 12:00 2020-07-31T12:00:00Z 07/31 08:00 1007 2211 2020-07-31T12:00:00Z 365066 27600 337466 19022     364126 206016                     44 72 1425 206016 totalTestEncountersViral 4031 206016 0 9 40d935653ce7c7098d8a65b125e2752392431104 0 0 0 0 0  
3237 3237 20200731 SC 89016 603819   692835 1516 5117 373   237   32859 A+ 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 1712 5117 2020-07-31T00:00:00Z 690936 110168 580768 88523 1647 65     52407 3430 48977               45 1444 0 692835 posNeg 1444 692835 45 0 98e601770ea6f2f27b410b3ee0542517077189b5 0 0 0 0 0  
3239 3239 20200731 TN 105959 1407446   1513405 1494 4661         66357 A 7/31/2020 15:00 2020-07-31T15:00:00Z 07/31 11:00 1060 4661 2020-07-31T15:00:00Z 1512224 124910 1387314 104778 1023 37                         47 3088 29505 1513405 posNeg 32593 1513405 27 89 d9da33169c7131b3cacc9c18d2b6859391407cd4 0 0 0 0 0  
3240 3240 20200731 TX 420946 3248806   3669752 9336   3117       273191 A 7/31/2020 17:10 2020-07-31T17:10:00Z 07/31 13:10 6569   2020-07-31T17:10:00Z 3669752     420946         241518 11712                 48 8839 51439 3669752 posNeg 60278 3669752 295 0 acdf3efc45c8021d072f3c67d77bb6194f9b75ef 0 0 0 0 0  
3241 3241 20200731 UT 40196 488714   528910 258 2377 81 618   250 28130 A+ 7/31/2020 10:58 2020-07-31T10:58:00Z 07/31 06:58 304 2377 2020-07-31T10:58:00Z 631309     40196       528910             1166 489 1402 518 49 500 4043 528910 posNeg 4543 528910 4 31 124c8daf9b74c6bc11b0c79b5bd401a9aaa5b5a7 0 0 0 0 0  
3243 3243 20200731 VI 406 8775 12 9181             338 C 7/31/2020 06:53 2020-07-31T06:53:00Z 07/31 02:53 8   2020-07-31T06:53:00Z 9193       8                           78 21 356 9193 posNeg 377 9181 0 0 af60eedca6f7b5e2ee12c1cdc5cd1bba6e97fc3e 0 0 0 0 0  
3244 3244 20200731 VT 1414 92954   94368 16           1211 B 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 57   2020-07-31T00:00:00Z       1414 57     94368                     50 7 1077 94368 posNeg 1084 94368 0 0 b000d6499b949e01437283a5f66918d0d3834f7c 0 0 0 0 0  
3246 3246 20200731 WI 56934 882149 132 939083 308 4637 108 900     42317 A+ 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 941 4637 2020-07-31T00:00:00Z       52940 934 7   935089                     55 855 14547 939215 posNeg 15402 939083 15 47 9ea54aef82549d4f26b45906748fe2fa32a83ee9 0 0 0 0 0  
3247 3247 20200731 WV 6642 277346   283988 108   39   18   4815 B 7/31/2020 17:00 2020-07-31T17:00:00Z 07/31 13:00 116   2020-07-31T17:00:00Z 283848     6502         14221                   54 220 6287 283988 posNeg 6507 283988 1 0 5dabd8e078bbac32903ff29f1da3f5ebba8450f7 0 0 0 0 0  
3248 3248 20200731 WY 2726 50573   53299 18 166         2123 B 7/31/2020 17:26 2020-07-31T17:26:00Z 07/31 13:26 26 166 2020-07-31T17:26:00Z 75767 2348 73418 2254       52827                     56 40 618 53299 posNeg 658 53299 0 0 7174a2f9b1b166d783b26b0138cce86f7231b5ab 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
);