states_daily_4pm_et

Table actions

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

72 rows where "dateModified" is on date 2020-08-15

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

dateModified (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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  

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