states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
61 rows where "dateModified" is on date 2020-07-17
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, dateChecked (date)
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
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 );