states_daily_4pm_et

Table actions

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

72 rows where "dateChecked" is on date 2020-08-15 sorted by totalTestsPeopleViral

✎ 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, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-08-15 · 72 ✖
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
1068 1068 20200907 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 5085675dfa58821863ab561c420b108feb82868d 0 0 0 0 0  
1124 1124 20200906 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 8e9a58f72785fb83c490d6b168f1467bd6c2e8f8 0 0 0 0 0  
1180 1180 20200905 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 78615189f736f50add2170e1fb8468820dba264a 0 0 0 0 0  
1236 1236 20200904 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 f60826de4e95b3f4a2a0f00c53e1bde01483b6c9 0 0 0 0 0  
1292 1292 20200903 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 56dee75bc9943e7392a15213f148aadf8d45c564 0 0 0 0 0  
1348 1348 20200902 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 48ebb399ca7a84fe4e65df7be64d01c2adde9b27 0 0 0 0 0  
1404 1404 20200901 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 9cd47401a2852789f2ffe4df905e7afe7ba9b228 0 0 0 0 0  
1460 1460 20200831 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 cc53fe6dbb4b1014666071c8137e9ff61190de7f 0 0 0 0 0  
1516 1516 20200830 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 ce7b74310cafa44752eb4f0e5b23a30c760ffe5d 0 0 0 0 0  
1572 1572 20200829 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 ace3adead0e717a1908206d95a6a168ac0c5208b 0 0 0 0 0  
1628 1628 20200828 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 bd007bf503cf21da89c9fd0e523fe8e68ef9e187 0 0 0 0 0  
1684 1684 20200827 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 c6b2cab54df3e413abedb75e185c329fb41c667b 0 0 0 0 0  
1740 1740 20200826 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 aac13db6ec3c1cfe1cf1996b28556c8c7987084f 0 0 0 0 0  
1796 1796 20200825 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 17628746dfe619ea73b6c7ebdea57a4cea7b032d 0 0 0 0 0  
1852 1852 20200824 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 4f0106743bce29e4b2be1e0ed425a249b04eac22 0 0 0 0 0  
1908 1908 20200823 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 cab50c36423df76c89e980f16a7e67f16f338caf 0 0 0 0 0  
1964 1964 20200822 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 f640c36732d354d6976e889445d31dbd7f1c03dc 0 0 0 0 0  
2020 2020 20200821 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 442f7b8d2753c777a4c1efd773f4ea05ebed9b9b 0 0 0 0 0  
2076 2076 20200820 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 253eb739540d6dbaf16c30e7466db850d97a06ee 0 0 0 0 0  
2132 2132 20200819 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 1225ed95030e2d45094d43c0baec361e076bae4b 0 0 0 0 0  
2188 2188 20200818 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 e15cbe743620ba84d77003b1c7a5b6cc567aadb9 0 0 0 0 0  
2244 2244 20200817 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 d838330cd9e50683afbbc69c0eb84837d96ee231 0 0 0 0 0  
2300 2300 20200816 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 b2f3a955ecb58143d87cd4ccda3518f56268799a 0 0 0 0 0  
2312 2312 20200816 ID 27477 195745   221406 206 1103 38 312     10616 A 8/15/2020 19:00 2020-08-15T19:00:00Z 08/15 15:00 269 1103 2020-08-15T19:00:00Z 221406     25661 241 28                         16 304 1906 223222 posNeg 2182 223222 4 12 123cbe3ca0a88d8127c12f715eb08698d09dd4d7 0 0 0 0 0  
2320 2320 20200816 ME 4168 206055   210223 9 400 2   1   3624 A+ 8/15/2020 23:59 2020-08-15T23:59:00Z 08/15 19:59 127 400 2020-08-15T23:59:00Z 209802 5241 204335 3747 126 1     9254 454 8787               23 24 2845 210223 posNeg 2869 210223 0 1 9d3a7b4b9c4249a705e8f0d27d2a16ed47d36f1c 0 0 0 0 0  
2332 2332 20200816 NM 23302 641989   665291 113 2957         10391 B 8/15/2020 17:50 2020-08-15T17:50:00Z 08/15 13:50 711 2957 2020-08-15T17:50:00Z 665291     23302                             35 142 6107 665291 posNeg 6249 665291 8 11 05a18102e926976f001dc432c9080770492f4a6c 0 0 0 0 0  
2334 2334 20200816 NY 425508 6642688   7068196 527 89995 128   59   74154 A 8/15/2020 23:59 2020-08-15T23:59:00Z 08/15 19:59 25250 89995 2020-08-15T23:59:00Z       425508     7068196                       36 607 77085 7068196 posNeg 77692 7068196 6 0 de87641fe8ec35e31a507f8dceb5b5a89d1fcef4 0 0 0 0 0  
2341 2341 20200816 SC 106497 761104   867601 1161 6852 290   188   42730 A+ 8/15/2020 23:59 2020-08-15T23:59:00Z 08/15 19:59 2269 6852 2020-08-15T23:59:00Z 866570 140201 726369 105466 2165 104     61005 4700 56305               45 615 6586 867601 posNeg 7201 867601 9 0 48edfea5a5c22e9c4d66d55f5abbc72e805814bb 0 0 0 0 0  
2346 2346 20200816 VA 106687 1247161 341 1349460 1184 14967 283   165   13783 A+ 8/15/2020 17:00 2020-08-15T17:00:00Z 08/15 13:00 2381 14967 2020-08-15T17:00:00Z   123419   102299 2266 115 1349460                       51 937 15671 1354189 posNeg 16522 1353848 0 2 6d81e0bbf69c44c229d628944dfd69814144bd55 0 0 0 0 0  
2349 2349 20200816 WA 68729 1229199   1297928 395 6230     55     B 8/15/2020 02:59 2020-08-15T02:59:00Z 08/14 22:59 1766 6230 2020-08-15T02:59:00Z       68729 1766   1297928                       53 150 4801 1297928 posNeg 4951 1297928 11 24 38a1b8bc903021c2967c993326b6f8da57e3a3b8 0 0 0 0 0  
2353 2353 20200815 AK 4954 291723   296677 36       4   1384 A 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 28   2020-08-15T00:00:00Z 296677 4706 291666 4954 28                           2 85 663 296677 posNeg 748 296677 1 0 75625a6848e00bb0b5c31019ec1a68cdf14d6eed 0 0 0 0 0  
2354 2354 20200815 AL 107580 729437   832794 1259 12607   1313   719 41523 B 8/15/2020 11:00 2020-08-15T11:00:00Z 08/15 07:00 1896 12607 2020-08-15T11:00:00Z 832794     103357 1828 68                         1 1271 10762 837017 posNeg 11923 837017 3 151 97b64a5b235fc93fea605d61901e7268cc137ca2 0 0 0 0 0  
2355 2355 20200815 AR 51992 536268   588660 464 3562     108 460 44905 A 8/15/2020 16:31 2020-08-15T16:31:00Z 08/15 12:31 600 3562 2020-08-15T16:31:00Z 588660   536268 51992                         7090 1085 5 -400 0 588260 posNeg 0 588260 13 -4 7073efb6076ddc4526493942dff0937f8e77e138 0 0 0 0 0  
2356 2356 20200815 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 118 1514 posNeg 118 1514 0 0 250992829fdc1c50f85105908daf8b8da0f9f9b6 0 0 0 0 0  
2358 2358 20200815 CA 613689 9067422   9681111 6327   1812         B 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 11147   2020-08-15T00:00:00Z 9681111     613689                             6 12614 111899 9681111 posNeg 124513 9681111 151 0 8b7c090cadb57ecda1d063479100c5a88eee2e75 0 0 0 0 0  
2364 2364 20200815 GA 235168 1752898   1988066 2586 22028   4042       A 8/15/2020 14:50 2020-08-15T14:50:00Z 08/15 10:50 4669 22028 2020-08-15T14:50:00Z 1988066 213697 1774369 235168         251604 17676                 13 3273 14740 1988066 posNeg 18013 1988066 96 210 a4fc2865c036ba0fc361d39f0b3b9bf829ce4434 0 0 0 0 0  
2369 2369 20200815 IL 205851 3125243   3331094 1538   330   127     A 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 7937   2020-08-15T00:00:00Z 3329762     204519 7726 211                         17 1828 42586 3331094 posNeg 44414 3331094 5 0 39c3b6114f6f1b3f847515728e0d59e794226efe 0 0 0 0 0  
2372 2372 20200815 KY 38930 673046   709163 618 4193 131 1304     9091 B 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 810 4193 2020-08-15T00:00:00Z 709163     36117 805 5     45157               665   21 632 10702 711976 posNeg 11254 711976 6 35 1c0153cc5d7f80b6659b7d5b90128c91792bc7b5 0 0 0 0 0  
2377 2377 20200815 MI 101782 2189997   2291779 713   184   87   67778 A+ 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 6586   2020-08-15T00:00:00Z 2319557 129560 2189997 92155 6318 268     237323                   26 1058 29570 2291779 posNeg 30628 2291779 20 0 7b2ca3e51432df23eeb43276113d73b22f037033 0 0 0 0 0  
2382 2382 20200815 MT 5659 195277   200936 90 324         4123 C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 82 324 2020-08-15T00:00:00Z 200936     5659                             30 118 957 200936 posNeg 1075 200936 1 5 a405ded6c017d2444c382fca9120d19d59f8091a 0 0 0 0 0  
2383 2383 20200815 NC 143706 1759695   1903401 1032   320       116969 A+ 8/15/2020 12:30 2020-08-15T12:30:00Z 08/15 08:30 2343   2020-08-15T12:30:00Z 1903401     143706 2343                           37 1536 24463 1903401 posNeg 25999 1903401 30 0 44d3c72c2c74fb799347ead944ed730f238e962a 0 0 0 0 0  
2387 2387 20200815 NJ 187442 2273941   2461383 520 22197 99   43   33264 A+ 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 15860 22197 2020-08-15T00:00:00Z 2461383     187442 14071 1789                         34 278 31264 2461383 posNeg 31542 2461383 9 36 7fd1e88d5d1477aee119e478e0ccf6f25e0b76aa 0 0 0 0 0  
2391 2391 20200815 OH 107674 1694676   1802350 899 12210 318 2767 166   86018 A+ 8/15/2020 14:00 2020-08-15T14:00:00Z 08/15 10:00 3824 12210 2020-08-15T14:00:00Z 1796692     102016 3546 278                         39 1117 21824 1802350 posNeg 22941 1802350 40 82 99d5a5206f48a51709b6d8a5fe0d2e727d0b3380 0 0 0 0 0  
2392 2392 20200815 OK 47798 706619   754417 506 3998 236       39907 A+ 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 657 3998 2020-08-15T00:00:00Z 762899 54870 706619 47798         65475 2649                 40 901 10274 754417 posNeg 11175 754417 13 45 da85f89d625aba01c2035525aae1400804fed3c8 0 0 0 0 0  
2395 2395 20200815 PR 25695 305972   331667 406   66   46     B 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 329   2020-08-15T00:00:00Z 310546 7002 303412 11069 201 128       14626                 72 567 0 331667 posNeg 567 331667 12 0 929a0c87bc8738480f1dd7cfac5925565e48c538 0 0 0 0 0  
2399 2399 20200815 TN 131747 1698011   1829758 1307 5813 392   187   92100 A+ 8/15/2020 15:00 2020-08-15T15:00:00Z 08/15 11:00 1345 5813 2020-08-15T15:00:00Z 1827520 155633 1671887 129509 1304 41                         47 1289 16426 1829758 posNeg 17715 1829758 19 88 b361b923236ab0267a3e3b651bafba1bfaaafe04 0 0 0 0 0  
2400 2400 20200815 TX 528838 3792838   4321676 6481   2306       393266 A 8/15/2020 16:00 2020-08-15T16:00:00Z 08/15 12:00 9840   2020-08-15T16:00:00Z 4321676     528838         318938 23192             17011 2591 48 8245 31390 4321676 posNeg 39635 4321676 238 0 98fcde62dbc7ca6c35e8cc74a4e83014cd29c265 0 0 0 0 0  
2407 2407 20200815 WV 8457 341787   350244 132   54   21   6298 B 8/15/2020 10:00 2020-08-15T10:00:00Z 08/15 06:00 160   2020-08-15T10:00:00Z 350076     8289 159 1     15072                   54 183 5361 350244 posNeg 5544 350244 3 0 d06b507eee9c4235c49f1bb6fc8c3f528d993855 0 0 0 0 0  
2357 2357 20200815 AZ 192654 884537   1075748 1282 20795 442   284   27339 A+ 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 4492 20795 2020-08-15T00:00:00Z       191211 4238 254   1075748 250030                   4 933 8683 1077191 posNeg 9602 1077191 69 280 9b5cd28903e3877ce86cc1283b2a8d07c2413004 0 0 0 0 0  
2404 2404 20200815 VT 1509 108788   110297 14           1332 B 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 58   2020-08-15T00:00:00Z       1509 58     110297                     50 8 2872 110297 posNeg 2880 110297 0 0 2d33152bfd9fc62e00e698e2c1d388c863328644 0 0 0 0 0  
2406 2406 20200815 WI 69547 1055119 239 1124666 337 5275 96 954     55172 A+ 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 1045 5275 2020-08-15T00:00:00Z       65056 1038 7   1120175                     55 866 10506 1124905 posNeg 11372 1124666 13 40 6044f631692909d8c15c124d03a807b62e63b394 0 0 0 0 0  
2375 2375 20200815 MD 99693 1027959   1127652 460 13556 107       5995 A 8/15/2020 10:00 2020-08-15T10:00:00Z 08/15 06:00 3636 13556 2020-08-15T10:00:00Z 1585670 117306   99693 3499 137   1127652                     24 818 16561 1127652 posNeg 17379 1127652 5 48 947e1a776bddffd9a605959fa5d874c60c9ae7b3 0 0 0 0 0  
2342 2342 20200816 SD 10274 118500   128774 66 916         8939 A 8/15/2020 14:00 2020-08-15T14:00:00Z 08/15 10:00 153 916 2020-08-15T14:00:00Z 164103             128774                     46 156 1169 128774 posNeg 1325 128774 1 3 9a75dc3134a4feb4670daf75b9ed94add992f414 0 0 0 0 0  
2374 2374 20200815 MA 122897 1311604   1886299 375 12170 65   27   100486 A+ 8/15/2020 10:00 2020-08-15T10:00:00Z 08/15 06:00 8818 12170 2020-08-15T10:00:00Z 1886299 150687   114095 8596 222   1425699       104872     66513       25 366 22603 1434501 totalTestsViral 33267 1434501 14 20 52b6a7945175be0a23f25ed493a1b8d2295a2ff2 0 0 0 0 0  
2394 2394 20200815 PA 123800 1319884   1443684 572       99   96564 A+ 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 7465   2020-08-15T00:00:00Z       120346       1440230                     42 850 15145 1443684 posNeg 15995 1443684 20 0 c5e00f84194e039c66ba532f43eead48ec5e6954 0 0 0 0 0  
2305 2305 20200816 DC 13220 229632   242852 79   28   9   10493 A+ 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 597   2020-08-15T00:00:00Z             242852 156592                     11 61 3575 242852 posNeg 3636 242852 0 0 60d4a83be47253bc0791d570334644ceb802fcb1 0 0 0 0 0  
2384 2384 20200815 ND 8439 169701   379816 55 457         7161 C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 105 457 2020-08-15T00:00:00Z 391750     8439 101 4 379816 175603 8007 293 7714               38 123 1420 178140 totalTestEncountersViral 6266 178140 0 2 ed950e27f88f29c57f09a354098d24c56ebc4464 0 0 0 0 0  
2386 2386 20200815 NH 6980 176397   278912 15 706   218     6264 B 8/15/2020 09:00 2020-08-15T09:00:00Z 08/15 05:00 423 706 2020-08-15T09:00:00Z 278912     6980       183377 29130     28528             33 59 1702 183377 posNeg 3409 183377 1 1 3351f2e05275452b800c5514a0e9716b78ec923f 0 0 0 0 0  
2306 2306 20200816 DE 16451 193934   210385 30   8       8671 A+ 8/15/2020 18:00 2020-08-15T18:00:00Z 08/15 14:00 593   2020-08-15T18:00:00Z       15448 524 69   210385                     10 55 1569 210385 posNeg 1624 210385 0 0 60a2cda9d782dc1d963420a518c091d9f6859206 0 0 0 0 0  
2396 2396 20200815 RI 20439 211327   425315 85 2375 11   2   1972 A+ 8/15/2020 12:00 2020-08-15T12:00:00Z 08/15 08:00 1022 2375 2020-08-15T12:00:00Z   29154 396161 20439     425315 231766                     44 104 1797 231766 totalTestEncountersViral 4582 231766 1 25 11d0facde1c11fe07d1f515d506072be1b9afdce 0 0 0 0 0  
2309 2309 20200816 GU 516 27257   27773 12   3       345 A 8/15/2020 20:00 2020-08-15T20:00:00Z 08/15 16:00 5   2020-08-15T20:00:00Z 27086     508       27765 153 2                 66 14 663 27773 posNeg 677 27773 0 0 fafac0f79f01f79129f259d297c2ea1563e78c04 0 0 0 0 0  
2329 2329 20200816 NE 30241 290635   320876 144 1883         22251 A 8/15/2020 20:20 2020-08-15T20:20:00Z 08/15 16:20 361 1883 2020-08-15T20:20:00Z       30241       321172                     31 253 2940 320876 posNeg 3193 320876 0 3 49885f3b66a9bcdd4648e4b89bb6615875a629b6 0 0 0 0 0  
2307 2307 20200816 FL 573416 3659212 3791 4232628 5690 34341           A 8/15/2020 23:59 2020-08-15T23:59:00Z 08/15 19:59 9587 34341 2020-08-15T23:59:00Z 5679906 732039 4917254 573416 9587     4239309 408950 27323 381574 401862 26788 375046   5703     12 3779 26124 4236419 posNeg 29903 4232628 107 267 2d6992b003852cdc46b349a4b735c19b63ee62f9 0 0 0 0 0  
2393 2393 20200815 OR 23018 461861   484879 224 1863 57   16   4355 A+ 8/15/2020 03:01 2020-08-15T03:01:00Z 08/14 23:01 386 1863 2020-08-15T03:01:00Z     461861 21441       471935                     41 405 11367 484879 posNeg 11772 484879 1 0 5b35228b3b7b8358db1283b2616cbe0a86f02baa 0 0 0 0 0  
2389 2389 20200815 NV 60608 482242   542850 941   258   166   1423 A+ 8/15/2020 02:59 2020-08-15T02:59:00Z 08/14 22:59 1069   2020-08-15T02:59:00Z 743871     60608       538202                     32 859 3787 542850 posNeg 4646 542850 24 0 770b91785d5ff65f5d9a42c71d0c851d44ac2538 0 0 0 0 0  
2367 2367 20200815 IA 51793 494281   546074 261   82   35   40381 A+ 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 973   2020-08-15T00:00:00Z       51793       553559       43996 2911 41046         19 861 4976 546074 posNeg 5837 546074 7 0 86b88a5c1de2d6dd46cbbfd56e88fbf056fea37a 0 0 0 0 0  
2401 2401 20200815 UT 46321 548580   594901 186 2760 64 707   286 37346 A+ 8/15/2020 10:28 2020-08-15T10:28:00Z 08/15 06:28 363 2760 2020-08-15T10:28:00Z 724237     46321       594901             2215 690 2672 740 49 345 4739 594901 posNeg 5084 594901 3 16 30da9704be850c6708fc9796022b3c1ada9af853 0 0 0 0 0  
2408 2408 20200815 WY 3227 56809   60036 13 191         2659 B 8/15/2020 12:11 2020-08-15T12:11:00Z 08/15 08:11 30 191 2020-08-15T12:11:00Z 85877 2748 83128 2730       59503                     56 44 0 60036 posNeg 44 60036 0 0 d5a022404f4289e8a93b01c00e5a772428747b9c 0 0 0 0 0  
2303 2303 20200816 CO 52838 573467   859734 236 6727         5660 A 8/15/2020 01:59 2020-08-15T01:59:00Z 08/14 21:59 1768 6727 2020-08-15T01:59:00Z       49278     859734 622745 148571 10222 138349               8 300 5680 626305 totalTestEncountersViral 10939 626305 0 9 63767717fbd8c2ac9530c72449abee54a0eed714 0 0 0 0 0  
2379 2379 20200815 MO 66397 769044   835441 871       113     A 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 1346   2020-08-15T00:00:00Z 1106583 77152 1027492 66397       835441       64229 2492 61737         29 1127 9445 835441 posNeg 10572 835441 11 0 70c6b7c7eb6a4a68eeac1d79443e95ec3be9aebb 0 0 0 0 0  
2314 2314 20200816 IN 80415 826436   906851 944 9935 265 2035 92   59801 A+ 8/15/2020 23:59 2020-08-15T23:59:00Z 08/15 19:59 3133 9935 2020-08-15T23:59:00Z 1162594       2924 209   906851                     18 739 8497 906851 posNeg 9236 906851 5 63 ac9e7d2e5a1cbb4323ed2bf86893144048ca7673 0 0 0 0 0  
2322 2322 20200816 MN 65152 928902   1254208 290 5851 152 1700     58196 A 8/15/2020 17:00 2020-08-15T17:00:00Z 08/15 13:00 1752 5851 2020-08-15T17:00:00Z       65152 1706 46 1254208 994054                     27 739 8842 994054 posNeg 17290 994054 7 29 f9d8a410d5b1c8562ae1653f64515e11f9d21e38 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
);