states_daily_4pm_et

Table actions

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

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

dateChecked (date) ✖

  • 2020-07-17 · 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
3872 3872 20200719 CT 47893 609238   657131 66 10654         8466 B 7/17/2020 20:30 2020-07-17T20:30:00Z 07/17 16:30 4396 10654 2020-07-17T20:30:00Z 655309     46071 3519 877                         9 0 27162 657131 posNeg 27162 657131 0 0 4a60a8ddcd8ecd82de3c1eb24dbf01915d5ccabe 0 0 0 0 0  
3877 3877 20200719 GU 315 17938   18253 4           222 B 7/17/2020 20:50 2020-07-17T20:50:00Z 07/17 16:50 5   2020-07-17T20:50:00Z 18244     307       18245 145 2                 66 0 0 18253 posNeg 0 18253 0 0 d3c11ad73edc69cb5daecf889bc64970b604343c 0 0 0 0 0  
3883 3883 20200719 KS 21965 227388   249353   1453 58 427 14 161 983 A 7/17/2020 10:00 2020-07-17T10:00:00Z 07/17 06:00 299 1453 2020-07-17T10:00:00Z               249353                     20 0 0 249353 posNeg 0 249353 0 0 c2f8d767a1a9c370c9831bc3f82227462febc68e 0 0 0 0 0  
3893 3893 20200719 MS 42638 335439   378077 1129 3727 278   132   25932 A 7/17/2020 19:00 2020-07-17T19:00:00Z 07/17 15:00 1355 3727 2020-07-17T19:00:00Z 376793     42130 1324 31     14559 95                 28 792 0 378077 posNeg 792 378077 9 0 e45b674463f940f52ee83bd2bbd59a1894e2df11 0 0 0 0 0  
3908 3908 20200719 RI 17793 161408   316540 62 2088 4   2   1717 A+ 7/17/2020 12:00 2020-07-17T12:00:00Z 07/17 08:00 990 2088 2020-07-17T12:00:00Z 304770 25966 278804 17793     316540 179201                     44 0 0 179201 totalTestEncountersViral 3213 179201 0 0 487985d4ffe2e9a6c0bf1b86382a195ee87c9195 0 0 0 0 0  
3923 3923 20200718 AR 31762 381243   413005 464 2135     97 304 24776 A+ 7/17/2020 19:56 2020-07-17T19:56:00Z 07/17 15:56 353 2135 2020-07-17T19:56:00Z 413005     31762                             5 0 5508 413005 posNeg 6156 413005 0 65 2658b425d9e1c8c653ec6131547b2b9751e3f37f 0 0 0 0 0  
3929 3929 20200718 DC 11194 133761   144955 88   17   12   1877 A+ 7/17/2020 00:00 2020-07-17T00:00:00Z 07/16 20:00 578   2020-07-17T00:00:00Z             144955 105271                     11 79 3269 144955 posNeg 3348 144955 1 0 3a7b508962f1316c621dff4165888ee77d2c9ef6 0 0 0 0 0  
3930 3930 20200718 DE 13429 137328   150757 51   8       7362 A+ 7/17/2020 18:00 2020-07-17T18:00:00Z 07/17 14:00 523   2020-07-17T18:00:00Z       12447 465 58   150757                     10 92 2055 150757 posNeg 2147 150757 2 0 85ea15e47f20e998dbeb2edaf40797ddf45c8f86 0 0 0 0 0  
3931 3931 20200718 FL 337569 2594419 2320 2931988 9144 20969           A 7/17/2020 23:59 2020-07-17T23:59:00Z 07/17 19:59 5002 20969 2020-07-17T23:59:00Z 3677144 420156 3246327 337569 5002     2935521       297009 12002 284980         12 10328 40892 2934308 posNeg 51220 2931988 90 443 f0a8d97da0676682c6efe02b00664b8d29943165 0 0 0 0 0  
3933 3933 20200718 GU 315 17938   18253 4           222 B 7/17/2020 20:50 2020-07-17T20:50:00Z 07/17 16:50 5   2020-07-17T20:50:00Z 18244     307       18245 145 2                 66 1 0 18253 posNeg 1 18253 0 0 302ff2bf079d457f9fe1f4ef5be73fce7130608b 0 0 0 0 0  
3934 3934 20200718 HI 1334 101661   102995 39 139         994 D 7/17/2020 18:00 2020-07-17T18:00:00Z 07/17 14:00 23 139 2020-07-17T18:00:00Z 124068             102995                     15 23 1768 102995 posNeg 1791 102995 1 1 c54a1deb4d1b12b5e3a27da087b676ae5a864cb3 0 0 0 0 0  
3936 3936 20200718 ID 13752 128753   141636 224 570 33 170     3827 A 7/17/2020 19:00 2020-07-17T19:00:00Z 07/17 15:00 118 570 2020-07-17T19:00:00Z 141636     12883 96 22                         16 619 1567 142505 posNeg 2155 142505 4 16 c2c9e83f2f6252704dacb9c3de16db5c07c157e6 0 0 0 0 0  
3938 3938 20200718 IN 55654 558801   614455 798 7861 245 1667 84   40722 A+ 7/17/2020 23:59 2020-07-17T23:59:00Z 07/17 19:59 2820 7861 2020-07-17T23:59:00Z         2627 193   614455                     18 841 8979 614455 posNeg 9820 614455 17 47 ee2ade33d57bce342ae9c3f30b77c5c06ec9ddcc 0 0 0 0 0  
3939 3939 20200718 KS 21965 227388   249353   1453 58 427 14 161 983 A 7/17/2020 10:00 2020-07-17T10:00:00Z 07/17 06:00 299 1453 2020-07-17T10:00:00Z               249353                     20 0 0 249353 posNeg 0 249353 0 0 5d3544d368e2424564b7939e6c0f2de1b8118aa4 0 0 0 0 0  
3941 3941 20200718 LA 88590 955350   1043940 1413       161   53288 B 7/17/2020 13:00 2020-07-17T13:00:00Z 07/17 09:00 3509   2020-07-17T13:00:00Z       88590 3399 110   1043940                     22 0 0 1043940 posNeg 0 1043940 0 0 26ebd80cafeca15e7f02e1a0e8647bfacd723fe2 0 0 0 0 0  
3944 3944 20200718 ME 3646 131283   134929 9 375 8   5   3136 A+ 7/17/2020 23:59 2020-07-17T23:59:00Z 07/17 19:59 117 375 2020-07-17T23:59:00Z 134535 4510 129845 3252 116 1     8378 380 7989               23 10 1474 134929 posNeg 1484 134929 2 0 d46a3bd502e376c9ed1e3fbaff38eee734ea9dda 0 0 0 0 0  
3946 3946 20200718 MN 45470 790492   835962 265 4602 117 1377     39310 A 7/17/2020 17:00 2020-07-17T17:00:00Z 07/17 13:00 1578 4602 2020-07-17T17:00:00Z       45470 1538 40 835962                       27 457 15994 835962 posNeg 16451 835962 5 39 37d90d629b79c2608eb2ad890f6ea0fcc55f4daf 0 0 0 0 0  
3949 3949 20200718 MS 41846 335439   377285 1076 3727 253   129   25932 A 7/17/2020 19:00 2020-07-17T19:00:00Z 07/17 15:00 1346 3727 2020-07-17T19:00:00Z 376793     41354 1316 30     14559 95                 28 1017 4804 377285 posNeg 5821 377285 14 15 8d3e8860509935835df70bbb8b881ba6b9019167 0 0 0 0 0  
3953 3953 20200718 NE 22361 208790   231151 105 1480         16665 B 7/17/2020 20:00 2020-07-17T20:00:00Z 07/17 16:00 301 1480 2020-07-17T20:00:00Z       22361       231407                     31 227 4728 231151 posNeg 4955 231151 2 27 08c2642db0471108d50efa76f27682201a8c8564 0 0 0 0 0  
3954 3954 20200718 NH 6165 135621   197057 24 670   192     5188 B 7/17/2020 09:00 2020-07-17T09:00:00Z 07/17 05:00 395 670 2020-07-17T09:00:00Z 197057     6165       141786 25659     25093             33 0 0 141786 posNeg 2205 141786 0 0 74f9eeb90f21a1fc1841bdd4e0b3c18c3aab7e8a 0 0 0 0 0  
3956 3956 20200718 NM 16456 435842   452298 166 2337         6654 B 7/17/2020 17:50 2020-07-17T17:50:00Z 07/17 13:50 565 2337 2020-07-17T17:50:00Z 452298     16456                             35 318 8612 452298 posNeg 8930 452298 3 25 65d93a2877271c83641041acb56fcf22ffb30991 0 0 0 0 0  
3958 3958 20200718 NY 406305 4662961   5069266 743 89995 172   100   72064 A 7/17/2020 23:59 2020-07-17T23:59:00Z 07/17 19:59 25035 89995 2020-07-17T23:59:00Z       406305     5069266                       36 754 69063 5069266 posNeg 69817 5069266 11 0 5e7eeb577f4d1b6eaa43c3ed15364fb1323a717d 0 0 0 0 0  
3964 3964 20200718 RI 17793 161408   313327 62 2088 4   2   1717 A+ 7/17/2020 12:00 2020-07-17T12:00:00Z 07/17 08:00 990 2088 2020-07-17T12:00:00Z 304770 25966 278804 17793     313327 179201                     44 0 0 179201 totalTestEncountersViral 4259 179201 0 0 e2a07734b221b9ec538a66febea9d5fae2235126 0 0 0 0 0  
3965 3965 20200718 SC 67612 494381   561993 1593 4182         23849 A 7/17/2020 23:59 2020-07-17T23:59:00Z 07/17 19:59 1135 4182 2020-07-17T23:59:00Z 561777 84547 477230 67396 1117 18     47084 2398 44686               45 1552 7066 561993 posNeg 8618 561993 39 0 19659916587359dd4fa6469be4aa0976b9b948b9 0 0 0 0 0  
3966 3966 20200718 SD 7862 89385   97247 70 771         6891 B 7/17/2020 18:00 2020-07-17T18:00:00Z 07/17 14:00 116 771 2020-07-17T18:00:00Z               97247                     46 73 1201 97247 posNeg 1274 97247 0 8 bb4e48857e14936f393fd2f0a89d6f4983542bed 0 0 0 0 0  
3970 3970 20200718 VA 76373 813328 421 897264 1166 11142 254   108   9976 A+ 7/17/2020 17:00 2020-07-17T17:00:00Z 07/17 13:00 2025 11142 2020-07-17T17:00:00Z   91652   73420 1921 104 897264                       51 940 12057 890122 posNeg 16938 889701 12 88 2e3cb58d3b34d7eb949f286aef1fd005f5912d2f 0 0 0 0 0  
3971 3971 20200718 VI 283 6239 132 6522             133 C 7/17/2020 20:36 2020-07-17T20:36:00Z 07/17 16:36 6   2020-07-17T20:36:00Z 6654       6                           78 20 449 6654 posNeg 469 6522 0 0 77cfcc3a7dccde76737b29b0ec88b349a83a90b4 0 0 0 0 0  
3973 3973 20200718 WA 49882 868438   918320 348 4984     46     B 7/17/2020 02:59 2020-07-17T02:59:00Z 07/16 22:59 1434 4984 2020-07-17T02:59:00Z       49882 1434   918320 767657                     53 524 9163 918320 posNeg 9687 918320 7 40 545b9a770bb3fc73bf89388fccc6ab21be1377ed 0 0 0 0 0  
3977 3977 20200717 AK 2081 163333   165414 32       0   697 A 7/17/2020 00:00 2020-07-17T00:00:00Z 07/16 20:00 17   2020-07-17T00:00:00Z 165414     2081 17                           2 49 2343 165414 posNeg 2392 165414 0 0 b0721523cc9ddc7722f4b0f4c29e1bbbee9c5fd7 0 0 0 0 0  
3978 3978 20200717 AL 63091 500024   562135 1433 7584   967   521 29736 B 7/17/2020 11:00 2020-07-17T11:00:00Z 07/17 07:00 1265 7584 2020-07-17T11:00:00Z 562135     62111 1232 33                         1 2003 10003 563115 posNeg 11956 563115 35 0 c204e495f80e16801ff563dac4c1a4977793ac9c 0 0 0 0 0  
3979 3979 20200717 AR 31762 375735   406849 464 2070     97 298 24776 A 7/17/2020 14:36 2020-07-17T14:36:00Z 07/17 10:36 353 2070 2020-07-17T14:36:00Z 406849     31762                             5 648 5888 407497 posNeg 6705 407497 12 76 087c377b76d56ba5183caf1ef4254a17a1e3998a 0 0 0 0 0  
3981 3981 20200717 AZ 138523 626445   764155 3466 6402 944   687   17184 A+ 7/17/2020 00:00 2020-07-17T00:00:00Z 07/16 20:00 2583 6402 2020-07-17T00:00:00Z       137710 2431 152   764155 205682                   4 3910 11792 764968 posNeg 15664 764968 91 106 af14a4787a67c8125d1b5eb24759fbfb6db8beca 0 0 0 0 0  
3982 3982 20200717 CA 366164 5677935   6044099 8450   2153         B 7/17/2020 00:00 2020-07-17T00:00:00Z 07/16 20:00 7475   2020-07-17T00:00:00Z 6044099     366164                             6 9986 118605 6044099 posNeg 128591 6044099 130 0 d431e3ebd200c49aae58478794b6e8b5eb0d7c7a 0 0 0 0 0  
3983 3983 20200717 CO 38726 385623   525680 412 5966         4909 A 7/17/2020 01:59 2020-07-17T01:59:00Z 07/16 21:59 1615 5966 2020-07-17T01:59:00Z       35690     525680 421313 123305 8094 115211               8 571 7562 424349 totalTestEncountersViral 10938 424349 14 16 ea7811f37045e417039194d24ed3912f310033c3 0 0 0 0 0  
3988 3988 20200717 GA 135183 1063495   1198678 2902 14647   2781       A 7/17/2020 14:50 2020-07-17T14:50:00Z 07/17 10:50 3132 14647 2020-07-17T14:50:00Z 1198678 123040 1075638 135183         193476 10253                 13 3908 16548 1198678 posNeg 20456 1198678 28 301 7009190bfe29f3885a9ef917e43f186eda80e6fe 0 0 0 0 0  
3991 3991 20200717 IA 37722 364731   402453 210   70   32   27609 A+ 7/17/2020 00:00 2020-07-17T00:00:00Z 07/16 20:00 784   2020-07-17T00:00:00Z       37722       403691       36654 2514 34104         19 590 5412 402453 posNeg 6002 402453 6 0 6a7523b1efbc3ff93f8aecb2feac0e32e58fdef9 0 0 0 0 0  
3995 3995 20200717 KS 21965 227388   249353   1453 58 427 14 161 983 A 7/17/2020 10:00 2020-07-17T10:00:00Z 07/17 06:00 299 1453 2020-07-17T10:00:00Z               249353                     20 1032 8947 249353 posNeg 9979 249353 0 60 0f9dd05b20c3e6fc0a6bd2d68569197edcbe4588 0 0 0 0 0  
3996 3996 20200717 KY 21605 461457   482064 452 2864 89 1031     6772 B 7/17/2020 00:00 2020-07-17T00:00:00Z 07/16 20:00 658 2864 2020-07-17T00:00:00Z 482064     20607 653 5     40203                   21 522 14536 483062 posNeg 15025 483062 8 22 b6ac4e376424158c1b4b93d691dea2b013725662 0 0 0 0 0  
3997 3997 20200717 LA 88590 955350   1043940 1413       161   53288 B 7/17/2020 13:00 2020-07-17T13:00:00Z 07/17 09:00 3509   2020-07-17T13:00:00Z       88590 3399 110   1043940                     22 2179 17624 1043940 posNeg 19803 1043940 24 0 8930ac1738f3b7ef096e6f75d846654735d221a4 0 0 0 0 0  
3998 3998 20200717 MA 112879 901708   1358139 515 11691 76   34   95390 A+ 7/17/2020 10:00 2020-07-17T10:00:00Z 07/17 06:00 8402 11691 2020-07-17T10:00:00Z 1358139 142262   106487 8184 218   1008195       84539             25 298 12605 1014587 totalTestsViral 17990 1014587 22 28 c8c4ff3297bd7a5e37a53a016a059a77f2c25f65 0 0 0 0 0  
3999 3999 20200717 MD 76371 631845   708216 434 11728 128       5286 A 7/17/2020 10:00 2020-07-17T10:00:00Z 07/17 06:00 3359 11728 2020-07-17T10:00:00Z 891359 89541   76371 3227 132   708216                     24 707 14980 708216 posNeg 15687 708216 12 41 20c906832f007e2163aa122c3f80481a0015516c 0 0 0 0 0  
4001 4001 20200717 MI 80593 1344913   1425506 680   201   88   53867 A+ 7/17/2020 00:00 2020-07-17T00:00:00Z 07/16 20:00 6355   2020-07-17T00:00:00Z 1445361 100448 1344913 72502 6108 247     192929                   26 754 29598 1425506 posNeg 30352 1425506 7 0 9f3f5db2e918579edf0095a83ab07eb92ab08135 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  
4006 4006 20200717 MT 2366 128038   130404 45 159         992 C 7/17/2020 00:00 2020-07-17T00:00:00Z 07/16 20:00 37 159 2020-07-17T00:00:00Z 130404     2366                             30 135 2429 130404 posNeg 2564 130404 2 9 9fef5776800338fff1011004d23058b52fb21daf 0 0 0 0 0  
4007 4007 20200717 NC 95477 1248497   1343974 1180           67124 A 7/17/2020 11:45 2020-07-17T11:45:00Z 07/17 07:45 1606   2020-07-17T11:45:00Z 1343974     95477 1606                           37 2051 29166 1343974 posNeg 31217 1343974 18 0 30bf68f547f611dacb7ee0f819768169e6451e22 0 0 0 0 0  
4008 4008 20200717 ND 4784 124683   240870 36 290         3903 D 7/17/2020 00:00 2020-07-17T00:00:00Z 07/16 20:00 82 290 2020-07-17T00:00:00Z 246923     4784 78 4 240870 127021 6171 225 5946               38 122 1295 129467 totalTestEncountersViral 4021 129467 0 5 d06dfe10b78f3f420be9e105591ed83e40683452 0 0 0 0 0  
4010 4010 20200717 NH 6165 135621   194852 24 670   192     5188 B 7/17/2020 09:00 2020-07-17T09:00:00Z 07/17 05:00 395 670 2020-07-17T09:00:00Z 194852     6165       141786 25450     25093             33 52 3462 141786 posNeg 3498 141786 1 2 714f3fbfe76ed6109f614f380ff50a43b584d15a 0 0 0 0 0  
4011 4011 20200717 NJ 176551 1592377   1768928 868 21003 141   66   31400 A+ 7/17/2020 13:00 2020-07-17T13:00:00Z 07/17 09:00 15486 21003 2020-07-17T13:00:00Z 1768928     176551 13710 1776                         34 50 8974 1768928 posNeg 9024 1768928 19 229 888ce4924de9be562e8f007df47e8e6bb8f26233 0 0 0 0 0  
4013 4013 20200717 NV 33295 343712   377007 1000   269   134   842 A+ 7/17/2020 13:20 2020-07-17T13:20:00Z 07/17 09:20 637   2020-07-17T13:20:00Z 472989     33295       374547                     32 1380 4784 377007 posNeg 6164 377007 11 0 4b7a2293cad28cb928e1ef580f88a9fb8b33fb1d 0 0 0 0 0  
4015 4015 20200717 OH 72280 1043844   1116124 1016 9445 319 2305 161   49302 B 7/17/2020 14:00 2020-07-17T14:00:00Z 07/17 10:00 3112 9445 2020-07-17T14:00:00Z 1112019     68175 2858 254                         39 1679 25652 1116124 posNeg 27331 1116124 9 121 ebdc947bc6b210a5e9e9ef021be5e5695e4d92b0 0 0 0 0 0  
4016 4016 20200717 OK 24140 440904   465044 604 2289 247       18766 A+ 7/17/2020 08:00 2020-07-17T08:00:00Z 07/17 04:00 445 2289 2020-07-17T08:00:00Z 468644 26785 440904 24140         49472 1592                 40 699 7528 465044 posNeg 8227 465044 7 71 5671ee4527865e945689a9d0b08ce27aadcd383a 0 0 0 0 0  
4018 4018 20200717 PA 99478 899912   999390 680       98   75603 A+ 7/17/2020 00:00 2020-07-17T00:00:00Z 07/16 20:00 6992   2020-07-17T00:00:00Z       96651       996563                     42 1032 14717 999390 posNeg 15749 999390 19 0 2c96cdcdeb87158898ddd16583567a970334f6d8 0 0 0 0 0  
4019 4019 20200717 PR 11120 255766   266886 302   34   27     B 7/17/2020 06:30 2020-07-17T06:30:00Z 07/17 02:30 177   2020-07-17T06:30:00Z 258001 3966 253922 3272 80 97       7848                 72 546 0 266886 posNeg 546 266886 5 0 c0fa69dba770facef3c34045e748b92f46b7ad5f 0 0 0 0 0  
4020 4020 20200717 RI 17793 161408   309068 62 2088 4   2   1717 A+ 7/17/2020 12:00 2020-07-17T12:00:00Z 07/17 08:00 990 2088 2020-07-17T12:00:00Z 304770 25966 278804 17793     309068 179201                     44 82 1731 179201 totalTestEncountersViral 3774 179201 2 4 4ee4ed608e4c757ebd7dbf82643370980d00feed 0 0 0 0 0  
4023 4023 20200717 TN 73819 1076853   1150672 1436 3562         42734 A 7/17/2020 15:00 2020-07-17T15:00:00Z 07/17 11:00 815 3562 2020-07-17T15:00:00Z 1149991 86064 1063927 73138 785 30                         47 2279 24696 1150672 posNeg 26975 1150672 19 65 ac156364f46d9ed3b598af2365e67b6e0932b7c5 0 0 0 0 0  
4024 4024 20200717 TX 307572 2459749   2767321 10632           162191 B 7/17/2020 17:15 2020-07-17T17:15:00Z 07/17 13:15 3735   2020-07-17T17:15:00Z 2767321     307572         224781 7811                 48 14916 52550 2767321 posNeg 67466 2767321 174 0 3fab4eb453fee4faab6624d48c4bd299c652f9b6 0 0 0 0 0  
4025 4025 20200717 UT 32572 415234   447806 256 1984 96 532   220 19862 A+ 7/17/2020 09:43 2020-07-17T09:43:00Z 07/17 05:43 235 1984 2020-07-17T09:43:00Z 526288     32572       447806             716 311 845 327 49 727 7551 447806 posNeg 8278 447806 1 28 6141ad08f5f58f7bc8e99966b5981a31b4c5a8ad 0 0 0 0 0  
4028 4028 20200717 VT 1334 78032   79366 33           1121 B 7/17/2020 00:00 2020-07-17T00:00:00Z 07/16 20:00 56   2020-07-17T00:00:00Z       1334 56     79366                     50 9 317 79366 posNeg 326 79366 0 0 255586fa04e375293b33455e2fbbc333a8f2125b 0 0 0 0 0  
4030 4030 20200717 WI 44068 712197 170 756265 331 4031 96 816     31258 A+ 7/17/2020 16:00 2020-07-17T16:00:00Z 07/17 12:00 840 4031 2020-07-17T16:00:00Z       40507 833 7   752704                     55 929 12527 756435 posNeg 13456 756265 2 63 c9a1773a352be33385d35c63390ef613ecf96a8f 0 0 0 0 0  
4031 4031 20200717 WV 4783 217769   222552 69   37   15   3267 B 7/17/2020 17:00 2020-07-17T17:00:00Z 07/17 13:00 100   2020-07-17T17:00:00Z 222427     4658         12633                   54 126 3252 222552 posNeg 3378 222552 1 0 a57331a6ab64e8ab49d29aafa5d7ccb1d45f0b14 0 0 0 0 0  
4032 4032 20200717 WY 2069 41927   43996 19 140         1590 B 7/17/2020 17:49 2020-07-17T17:49:00Z 07/17 13:49 24 140 2020-07-17T17:49:00Z 61032 1769 59262 1678       43605                     56 43 501 43996 posNeg 544 43996 0 9 21e171ae073a04f52cb75caef417a941b1ed5ab8 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
);