states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
64 rows where "dateModified" is on date 2020-05-10 sorted by deathProbable
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7340 | 7340 | 20200518 | AS | 0 | 105 | 105 | C | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 0 | 2020-05-10T00:00:00Z | 105 | 0 | 60 | 0 | 0 | 105 | posNeg | 0 | 105 | 0 | 0 | 1f7a3cb43830728937dc0e91b6db625b70cf5588 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7396 | 7396 | 20200517 | AS | 0 | 105 | 105 | C | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 0 | 2020-05-10T00:00:00Z | 105 | 0 | 60 | 0 | 0 | 105 | posNeg | 0 | 105 | 0 | 0 | 020836e5fb50cde3c552630e0cbf2191b3bccd87 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7452 | 7452 | 20200516 | AS | 0 | 105 | 105 | C | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 0 | 2020-05-10T00:00:00Z | 105 | 0 | 60 | 0 | 0 | 105 | posNeg | 0 | 105 | 0 | 0 | 7069251db5676fb72665afbd480c8fc613078093 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7508 | 7508 | 20200515 | AS | 0 | 105 | 105 | C | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 0 | 2020-05-10T00:00:00Z | 105 | 0 | 60 | 0 | 0 | 105 | posNeg | 0 | 105 | 0 | 0 | fa795e738f72c67e45c2a94a3db0baa86aced01f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7564 | 7564 | 20200514 | AS | 0 | 105 | 105 | C | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 0 | 2020-05-10T00:00:00Z | 105 | 0 | 60 | 0 | 0 | 105 | posNeg | 0 | 105 | 0 | 0 | 3d82e3f4d61e82736abc20134a299e9341c79019 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7620 | 7620 | 20200513 | AS | 0 | 105 | 105 | C | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 0 | 2020-05-10T00:00:00Z | 105 | 0 | 60 | 0 | 0 | 105 | posNeg | 0 | 105 | 0 | 0 | 006575e6d026e32a2e782a1c7eae8a54847e9131 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7676 | 7676 | 20200512 | AS | 0 | 105 | 105 | C | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 0 | 2020-05-10T00:00:00Z | 105 | 0 | 60 | 0 | 0 | 105 | posNeg | 0 | 105 | 0 | 0 | 6be29f6f539054b74f9ddc73db928a23324a3919 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7679 | 7679 | 20200512 | CO | 19879 | 88778 | 120284 | 738 | 3663 | 3114 | A | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 987 | 3663 | 2020-05-10T00:00:00Z | 17983 | 120284 | 106761 | 21174 | 1956 | 19218 | 8 | 176 | -113 | 108657 | totalTestEncountersViral | 3071 | 108657 | 6 | -26 | af4445f1e639285765a0431ac33e8e55e6b78e73 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7731 | 7731 | 20200511 | AR | 4034 | 64996 | 69030 | 61 | 480 | 11 | 98 | 3149 | A | 5/10/2020 19:05 | 2020-05-10T19:05:00Z | 05/10 15:05 | 94 | 480 | 2020-05-10T19:05:00Z | 69030 | 4034 | 5 | 287 | 3215 | 69030 | posNeg | 3502 | 69030 | 6 | 9 | 956b438cb2482f9acd33bc8ac0f935a1144c23a4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7732 | 7732 | 20200511 | AS | 0 | 105 | 105 | D | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 0 | 2020-05-10T00:00:00Z | 105 | 0 | 60 | 0 | 22 | 105 | posNeg | 22 | 105 | 0 | 0 | c12b63a186ec36381823e55b53355d602355c4f9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7737 | 7737 | 20200511 | DC | 6389 | 23872 | 30261 | 416 | 82 | 881 | A | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 328 | 2020-05-10T00:00:00Z | 30261 | 11 | 117 | 574 | 30261 | posNeg | 691 | 30261 | 5 | 0 | 639052996b94553eabce4b3b2e0e43cd92074fdb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7742 | 7742 | 20200511 | HI | 632 | 37051 | 37683 | 81 | 561 | B | 5/10/2020 18:00 | 2020-05-10T18:00:00Z | 05/10 14:00 | 17 | 81 | 2020-05-10T18:00:00Z | 15 | 1 | 412 | 37683 | posNeg | 413 | 37683 | 0 | 0 | 68c91f71db828e37ddfd2b8ef07ff2a3227e4701 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
7746 | 7746 | 20200511 | IN | 24627 | 122061 | 146688 | 1346 | 4389 | 452 | 990 | 213 | A+ | 5/10/2020 23:59 | 2020-05-10T23:59:00Z | 05/10 19:59 | 1540 | 4389 | 2020-05-10T23:59:00Z | 1411 | 18 | 501 | 6158 | 146688 | posNeg | 6659 | 146688 | 32 | 0 | 77ec3b9aa192fcf0161267d8524b0bd6242e230a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7754 | 7754 | 20200511 | MN | 14379 | 115585 | 129964 | 452 | 1716 | 194 | 600 | 6945 | A | 5/10/2020 17:00 | 2020-05-10T17:00:00Z | 05/10 13:00 | 591 | 1716 | 2020-05-10T17:00:00Z | 14379 | 591 | 129964 | 27 | 827 | 4476 | 129964 | posNeg | 5303 | 129964 | 13 | 59 | 2870da85f53b6c6d5f7b1ff3938340cd2e1d379b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7757 | 7757 | 20200511 | MS | 9674 | 86211 | 95885 | 507 | 1546 | 132 | 68 | 6268 | A | 5/10/2020 19:00 | 2020-05-10T19:00:00Z | 05/10 15:00 | 435 | 1546 | 2020-05-10T19:00:00Z | 95885 | 28 | 173 | 14110 | 95885 | posNeg | 14283 | 95885 | 5 | 15 | 943f5731a9d8e7852d6050ec3d1124693d0569ac | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7758 | 7758 | 20200511 | MT | 459 | 22113 | 22572 | 4 | 62 | 423 | C | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 16 | 62 | 2020-05-10T00:00:00Z | 22572 | 459 | 30 | 1 | 867 | 22572 | posNeg | 868 | 22572 | 0 | 0 | 5d7be75f633f1d6dbd11c3a3ee5b203ccd9f21c4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7761 | 7761 | 20200511 | NE | 8315 | 37924 | 46239 | D | 5/10/2020 19:45 | 2020-05-10T19:45:00Z | 05/10 15:45 | 98 | 2020-05-10T19:45:00Z | 8315 | 46314 | 31 | 81 | 589 | 46239 | posNeg | 670 | 46239 | 2 | 0 | e9438b2ae90472bf1ee69791a8807aae481e27bb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7762 | 7762 | 20200511 | NH | 3160 | 31723 | 261 | 37116 | 113 | 318 | 97 | 1229 | B | 5/10/2020 09:00 | 2020-05-10T09:00:00Z | 05/10 05:00 | 133 | 318 | 2020-05-10T09:00:00Z | 37116 | 3059 | 33 | 149 | 1281 | 35144 | posNeg | 1270 | 34883 | 2 | 5 | 1e01ff28109187f9ea76b0a2e1740bddc450b40b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7764 | 7764 | 20200511 | NM | 4863 | 97635 | 102498 | 194 | 789 | 1285 | C | 5/10/2020 17:50 | 2020-05-10T17:50:00Z | 05/10 13:50 | 200 | 789 | 2020-05-10T17:50:00Z | 4863 | 35 | 85 | 5360 | 102498 | posNeg | 5445 | 102498 | 9 | 0 | 8e547ef06dcb935fa306259196a56dc792e73b2e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7766 | 7766 | 20200511 | NY | 337055 | 867596 | 1204651 | 7226 | 84194 | 2450 | 2020 | 58363 | A | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 21640 | 84194 | 2020-05-10T00:00:00Z | 337055 | 36 | 1660 | 19993 | 1204651 | posNeg | 21653 | 1204651 | 162 | 433 | ed1caee29dc70599e8663867880d9305696d16d4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7773 | 7773 | 20200511 | SC | 7653 | 76804 | 84457 | 1252 | 4120 | B | 5/10/2020 16:30 | 2020-05-10T16:30:00Z | 05/10 12:30 | 331 | 1252 | 2020-05-10T16:30:00Z | 7653 | 331 | 45 | 0 | 0 | 84457 | posNeg | 0 | 84457 | 0 | 0 | f47a579d2da5523a57dc23bda694142ef002f7c1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7774 | 7774 | 20200511 | SD | 3614 | 20964 | 24578 | 78 | 263 | 2187 | C | 5/10/2020 18:00 | 2020-05-10T18:00:00Z | 05/10 14:00 | 34 | 263 | 2020-05-10T18:00:00Z | 24578 | 46 | 97 | 587 | 24578 | posNeg | 684 | 24578 | 0 | 2 | 0b312128e1d964fdf9f1f43228a61c89acce30a8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7776 | 7776 | 20200511 | TX | 39869 | 485828 | 525697 | 1525 | 21713 | B | 5/10/2020 16:35 | 2020-05-10T16:35:00Z | 05/10 12:35 | 1100 | 2020-05-10T16:35:00Z | 39869 | 483 | 48 | 1000 | 22921 | 525697 | posNeg | 23921 | 525697 | 12 | 0 | 012bd598214c27571158b17c22534fa1b5395a31 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7784 | 7784 | 20200511 | WY | 662 | 11403 | 12065 | 12 | 66 | 443 | C | 5/10/2020 17:38 | 2020-05-10T17:38:00Z | 05/10 13:38 | 7 | 66 | 2020-05-10T17:38:00Z | 13416 | 504 | 56 | 1 | 0 | 12065 | posNeg | 1 | 12065 | 0 | 1 | c2124d770dbeddf2e5bf52aaebb79adb2feacb2b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7785 | 7785 | 20200510 | AK | 379 | 26985 | 27364 | 8 | 324 | C | 5/10/2020 14:00 | 2020-05-10T14:00:00Z | 05/10 10:00 | 10 | 2020-05-10T14:00:00Z | 27364 | 379 | 10 | 2 | 1 | 914 | 27364 | posNeg | 915 | 27364 | 0 | 0 | 1f635a38c6a5961315093701828e8180170f6566 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7786 | 7786 | 20200510 | AL | 9777 | 117644 | 127421 | 424 | 1240 | 460 | 274 | B | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 393 | 1240 | 2020-05-10T00:00:00Z | 127421 | 9777 | 393 | 1 | 210 | 1717 | 127421 | posNeg | 1927 | 127421 | 5 | 12 | 3466d88837fd9a35a389d31297a6f493e442a1ef | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7787 | 7787 | 20200510 | AR | 3747 | 61781 | 65528 | 64 | 471 | 14 | 96 | 2968 | B | 5/10/2020 10:15 | 2020-05-10T10:15:00Z | 05/10 06:15 | 88 | 471 | 2020-05-10T10:15:00Z | 65528 | 3747 | 5 | 0 | 0 | 65528 | posNeg | 0 | 65528 | 0 | 0 | 41aeef2e48005db728ad4b3cfd59e08ba046d63b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7789 | 7789 | 20200510 | AZ | 11119 | 99258 | 110377 | 713 | 2421 | 300 | 195 | 2775 | A+ | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 536 | 2421 | 2020-05-10T00:00:00Z | 110377 | 27362 | 4 | 159 | 4408 | 110377 | posNeg | 4567 | 110377 | 4 | 35 | 14948c8f834e962583d27bd9664df12ce54e5986 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7790 | 7790 | 20200510 | CA | 66680 | 888984 | 955664 | 4555 | 1328 | B | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 2745 | 2020-05-10T00:00:00Z | 955664 | 66680 | 6 | 2119 | 40975 | 955664 | posNeg | 43094 | 955664 | 67 | 0 | 478f85c8a2861ab9ab5392fe8db562033c517006 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7792 | 7792 | 20200510 | CT | 33554 | 96638 | 130192 | 1242 | 9389 | 5413 | B | 5/10/2020 14:00 | 2020-05-10T14:00:00Z | 05/10 10:00 | 2967 | 9389 | 2020-05-10T14:00:00Z | 132508 | 2633 | 9 | 570 | 6053 | 130192 | posNeg | 6623 | 130192 | 35 | 0 | 4a179a274ed1ff44c87e641a926d4a7af5c0cd0b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7795 | 7795 | 20200510 | FL | 40596 | 498352 | 1265 | 538948 | 7404 | B | 5/10/2020 11:52 | 2020-05-10T11:52:00Z | 05/10 07:52 | 1791 | 7404 | 2020-05-10T11:52:00Z | 40596 | 1791 | 12 | 595 | 10622 | 540213 | posNeg | 11217 | 538948 | 6 | 79 | 6f2afecde23e001fc5085f76553f12b585915207 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7796 | 7796 | 20200510 | GA | 33441 | 210106 | 243547 | 1144 | 5997 | 1412 | A | 5/10/2020 15:25 | 2020-05-10T15:25:00Z | 05/10 11:25 | 1405 | 5997 | 2020-05-10T15:25:00Z | 243547 | 33441 | 13 | 909 | 7314 | 243547 | posNeg | 8223 | 243547 | 5 | 10 | 6b3a4807bd943b58dc9c6e51eb6d8c1b68ebc939 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7799 | 7799 | 20200510 | IA | 11959 | 62215 | 74174 | 413 | 157 | 105 | 5154 | A+ | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 265 | 2020-05-10T00:00:00Z | 11959 | 19 | 288 | 2410 | 74174 | posNeg | 2698 | 74174 | 13 | 0 | 91ba67f91627e25a80977cd7a32d6cec56562b3f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7801 | 7801 | 20200510 | IL | 77741 | 352243 | 429984 | 4293 | 1232 | 709 | A | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 3406 | 2020-05-10T00:00:00Z | 77741 | 17 | 1656 | 11997 | 429984 | posNeg | 13653 | 429984 | 57 | 0 | 6dfaa4a7cc09b86664d0bb2f1754f60d521c28c5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7803 | 7803 | 20200510 | KS | 6948 | 45557 | 52505 | 657 | 231 | 101 | 371 | A | 5/10/2020 10:00 | 2020-05-10T10:00:00Z | 05/10 06:00 | 157 | 657 | 2020-05-10T10:00:00Z | 20 | 197 | 2375 | 52505 | posNeg | 2572 | 52505 | 0 | 22 | 0944abc09606a8b48f3ab369f24c32c453c68902 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7805 | 7805 | 20200510 | LA | 31600 | 184272 | 215872 | 1324 | 161 | 20316 | B | 5/10/2020 13:00 | 2020-05-10T13:00:00Z | 05/10 09:00 | 2286 | 2020-05-10T13:00:00Z | 31600 | 2213 | 22 | 183 | 3532 | 215872 | posNeg | 3715 | 215872 | 19 | 0 | cb32f259899f295aaa970471e8045e8b58ab8200 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7806 | 7806 | 20200510 | MA | 77793 | 310596 | 481105 | 3128 | 7617 | 810 | A | 5/10/2020 10:00 | 2020-05-10T10:00:00Z | 05/10 06:00 | 4979 | 7617 | 2020-05-10T10:00:00Z | 481105 | 96540 | 77793 | 4979 | 25 | 1050 | 10802 | 388389 | totalTestsViral | 4559 | 388389 | 139 | 66 | 5c353c46d0eec922102c5723a9589f9e924a31d4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7808 | 7808 | 20200510 | ME | 1436 | 22092 | 23528 | 36 | 199 | 17 | 10 | 861 | B | 5/10/2020 11:30 | 2020-05-10T11:30:00Z | 05/10 07:30 | 64 | 199 | 2020-05-10T11:30:00Z | 1312 | 64 | 587 | 23 | 28 | 0 | 23528 | posNeg | 28 | 23528 | 0 | 1 | 8e8a7d0b3cab923297653a0f1cb4d0e6e689b4c2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7811 | 7811 | 20200510 | MO | 9844 | 105702 | 115546 | 824 | 137 | B | 5/10/2020 15:00 | 2020-05-10T15:00:00Z | 05/10 11:00 | 482 | 2020-05-10T15:00:00Z | 121559 | 11659 | 109674 | 9844 | 5533 | 251 | 5273 | 29 | 178 | 6470 | 115546 | posNeg | 6648 | 115546 | 10 | 0 | 824020de7a74f8c3f1ebc5b83503a9bef77797e3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7815 | 7815 | 20200510 | NC | 14764 | 177371 | 192135 | 442 | B | 5/10/2020 11:00 | 2020-05-10T11:00:00Z | 05/10 07:00 | 547 | 2020-05-10T11:00:00Z | 14764 | 547 | 37 | 404 | 5369 | 192135 | posNeg | 5773 | 192135 | 3 | 0 | 4f3b2e9c4ac6f34cd5306c2a0ae63139ed15a8b2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
7816 | 7816 | 20200510 | ND | 1490 | 43378 | 48661 | 29 | 110 | 792 | C | 5/10/2020 12:10 | 2020-05-10T12:10:00Z | 05/10 08:10 | 24 | 110 | 2020-05-10T12:10:00Z | 49459 | 1490 | 24 | 48661 | 43267 | 38 | 26 | 909 | 44868 | totalTestEncountersViral | 1346 | 44868 | 0 | 0 | 9b79927ec9e1ab98157c0750142ba5e91b515e43 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7821 | 7821 | 20200510 | NV | 6098 | 52711 | 58809 | 444 | 116 | 65 | 182 | C | 5/10/2020 12:30 | 2020-05-10T12:30:00Z | 05/10 08:30 | 339 | 2020-05-10T12:30:00Z | 71603 | 6098 | 32 | 70 | 2628 | 58809 | posNeg | 2698 | 58809 | 5 | 0 | fd62566be2df861e2cbbcb29af94d8e36420a145 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7822 | 7822 | 20200510 | NY | 335395 | 847603 | 1182998 | 7262 | 83761 | 2488 | 2073 | 58006 | A | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 21478 | 83761 | 2020-05-10T00:00:00Z | 335395 | 36 | 2273 | 26957 | 1182998 | posNeg | 29230 | 1182998 | 207 | 476 | 2ead3bccbf08581935df78cd2fe9f0342f332d45 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7824 | 7824 | 20200510 | OK | 4589 | 91379 | 95968 | 177 | 826 | 93 | 3204 | A+ | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 272 | 826 | 2020-05-10T00:00:00Z | 95869 | 4923 | 90721 | 4589 | 40 | 99 | 0 | 95968 | posNeg | 99 | 95968 | 2 | 4 | b449141a71867eb3e25e812e8e2e34cff4aa8ebe | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7825 | 7825 | 20200510 | OR | 3228 | 72279 | 75507 | 164 | 670 | 45 | 22 | 1125 | A+ | 5/10/2020 11:00 | 2020-05-10T11:00:00Z | 05/10 07:00 | 127 | 670 | 2020-05-10T11:00:00Z | 3171 | 41 | 68 | 819 | 75507 | posNeg | 887 | 75507 | 0 | 8 | fbc42c526db07fb46a301afadb95319912aa2692 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7826 | 7826 | 20200510 | PA | 56611 | 227772 | 284383 | 2230 | 501 | C | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 3707 | 2020-05-10T00:00:00Z | 284383 | 42 | 1295 | 5981 | 284383 | posNeg | 7276 | 284383 | 19 | 0 | 1a9bce399b5df620712db91c7b1ba607cf8f3f06 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
7827 | 7827 | 20200510 | PR | 2198 | 2198 | 143 | D | 5/10/2020 05:51 | 2020-05-10T05:51:00Z | 05/10 01:51 | 111 | 2020-05-10T05:51:00Z | 1040 | 57 | 1158 | 72 | 25 | 0 | 2198 | posNeg | 25 | 2198 | 3 | 0 | f2cfb681616e4d0bf5c42d57d000e6f19846ff05 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
7828 | 7828 | 20200510 | RI | 11613 | 68106 | 96976 | 283 | 1251 | 70 | 52 | 809 | A+ | 5/10/2020 03:00 | 2020-05-10T03:00:00Z | 05/09 23:00 | 422 | 1251 | 2020-05-10T03:00:00Z | 99293 | 13826 | 85467 | 11613 | 96976 | 79719 | 44 | 186 | 1502 | 79719 | totalTestEncountersViral | 3800 | 79719 | 4 | 33 | 5d91ffef9526b1b918d88f34cfd75bc14c35e19e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
7829 | 7829 | 20200510 | SC | 7653 | 76804 | 84457 | 1252 | 4120 | B | 5/10/2020 16:30 | 2020-05-10T16:30:00Z | 05/10 12:30 | 331 | 1252 | 2020-05-10T16:30:00Z | 7653 | 331 | 45 | 122 | 3372 | 84457 | posNeg | 3494 | 84457 | 1 | 0 | f5a69ab8027f53d0062a06e415b33af874b0a8c1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7831 | 7831 | 20200510 | TN | 14985 | 246884 | 261869 | 484 | 1325 | 7528 | B | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 243 | 1325 | 2020-05-10T00:00:00Z | 14985 | 243 | 47 | 217 | 8904 | 261869 | posNeg | 9121 | 261869 | 1 | 6 | 9d052b49ad1b42c5a70639881f2d3c3ac027bdb3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7832 | 7832 | 20200510 | TX | 38869 | 462907 | 501776 | 1626 | 21022 | B | 5/10/2020 16:35 | 2020-05-10T16:35:00Z | 05/10 12:35 | 1088 | 2020-05-10T16:35:00Z | 38869 | 481 | 48 | 1009 | 11473 | 501776 | posNeg | 12482 | 501776 | 39 | 0 | 07bb600c4bfaea99afc54863984351e980b000c7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7833 | 7833 | 20200510 | UT | 6251 | 140259 | 146510 | 144 | 512 | 168 | 76 | 3033 | B | 5/10/2020 10:31 | 2020-05-10T10:31:00Z | 05/10 06:31 | 67 | 512 | 2020-05-10T10:31:00Z | 6251 | 49 | 148 | 3068 | 146510 | posNeg | 3216 | 146510 | 1 | 14 | abec2461f2ca2cfbde5fcdf4a3359c1a4a0ebdb0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7836 | 7836 | 20200510 | VT | 926 | 18167 | 19093 | 21 | 777 | B | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 53 | 2020-05-10T00:00:00Z | 927 | 53 | 50 | 0 | 477 | 19093 | posNeg | 477 | 19093 | 0 | 0 | 6d40f15a3daa8e66910e350b48658cbcc45977ea | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7837 | 7837 | 20200510 | WA | 17773 | 246823 | 264596 | 335 | 101 | B | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 921 | 2020-05-10T00:00:00Z | 17773 | 921 | 264596 | 242722 | 53 | 62 | 1714 | 264596 | posNeg | 1776 | 264596 | 16 | 0 | 720f5c32f7c2798525c16910d5c86129c07c6705 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7838 | 7838 | 20200510 | WI | 11694 | 105163 | 182 | 116857 | 332 | 1820 | 113 | 456 | 5014 | A+ | 5/10/2020 00:00 | 2020-05-10T00:00:00Z | 05/09 20:00 | 400 | 1820 | 2020-05-10T00:00:00Z | 10219 | 400 | 55 | 292 | 3228 | 117039 | posNeg | 3520 | 116857 | 2 | 14 | 83f826bbee306c63ba535019173f154811284da4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7839 | 7839 | 20200510 | WV | 1360 | 61284 | 62644 | 49 | 10 | 6 | 775 | C | 5/10/2020 10:00 | 2020-05-10T10:00:00Z | 05/10 06:00 | 54 | 2020-05-10T10:00:00Z | 62644 | 1360 | 54 | 54 | 25 | 1622 | 62644 | posNeg | 1647 | 62644 | 1 | 0 | 523261d8ac889952f3e2e73759289ea5321f7b58 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7840 | 7840 | 20200510 | WY | 661 | 11403 | 12064 | 12 | 65 | 443 | C | 5/10/2020 16:00 | 2020-05-10T16:00:00Z | 05/10 12:00 | 7 | 65 | 2020-05-10T16:00:00Z | 13416 | 503 | 56 | 17 | 0 | 12064 | posNeg | 17 | 12064 | 0 | 1 | acbe5dfc14a538de5947972f85a3539cfd108f07 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7823 | 7823 | 20200510 | OH | 24081 | 180781 | 204862 | 962 | 4351 | 381 | 1205 | 254 | B | 5/10/2020 14:00 | 2020-05-10T14:00:00Z | 05/10 10:00 | 1341 | 4351 | 2020-05-10T14:00:00Z | 195533 | 22891 | 1220 | 121 | 39 | 384 | 7808 | 204862 | posNeg | 8192 | 204862 | 10 | 51 | 3d6a1bdfc252f7df42ebdb81769ad3ce6fd6a45f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7819 | 7819 | 20200510 | NJ | 138532 | 173915 | 591 | 312447 | 4308 | 1338 | 994 | 15642 | A+ | 5/10/2020 13:00 | 2020-05-10T13:00:00Z | 05/10 09:00 | 10872 | 2020-05-10T13:00:00Z | 138532 | 9255 | 1617 | 312447 | 34 | 1447 | 5794 | 313038 | posNeg | 7241 | 312447 | 151 | 0 | abeae687db40c58ebac3bbb93aa606df6be6651c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7809 | 7809 | 20200510 | MI | 53033 | 267417 | 320450 | 1437 | 674 | 536 | 22686 | A+ | 5/10/2020 11:00 | 2020-05-10T11:00:00Z | 05/10 07:00 | 5081 | 2020-05-10T11:00:00Z | 328334 | 60917 | 267417 | 50129 | 4911 | 228 | 26 | 301 | 8152 | 320450 | posNeg | 8453 | 320450 | 45 | 0 | 120697f2a58f1bf1191b8aed7b643e375d5264bb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7778 | 7778 | 20200511 | VA | 25070 | 125547 | 432 | 182211 | 1504 | 4777 | 362 | 194 | 3273 | A+ | 5/10/2020 17:00 | 2020-05-10T17:00:00Z | 05/10 13:00 | 850 | 4777 | 2020-05-10T17:00:00Z | 31982 | 23889 | 823 | 27 | 182211 | 51 | 989 | 6573 | 151049 | posNeg | 5553 | 150617 | 11 | 21 | a41f394a2b652985fd6a5fbb187b092eae081c63 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
7794 | 7794 | 20200510 | DE | 6447 | 24592 | 31039 | 285 | 2537 | B | 5/10/2020 12:03 | 2020-05-10T12:03:00Z | 05/10 08:03 | 312 | 2020-05-10T12:03:00Z | 277 | 35 | 10 | 170 | 1573 | 31039 | posNeg | 1743 | 31039 | 11 | 0 | 5bf83d48c658730a4b5034d5216341ae11f0e21f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7738 | 7738 | 20200511 | DE | 6565 | 25363 | 31928 | 275 | 2619 | B | 5/10/2020 18:00 | 2020-05-10T18:00:00Z | 05/10 14:00 | 324 | 2020-05-10T18:00:00Z | 288 | 36 | 10 | 118 | 771 | 31928 | posNeg | 889 | 31928 | 12 | 0 | 16970a1f8c59ad8aac6df4012e514a3e15458779 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7807 | 7807 | 20200510 | MD | 32587 | 127344 | 159931 | 1640 | 5955 | 611 | 2293 | A | 5/10/2020 10:00 | 2020-05-10T10:00:00Z | 05/10 06:00 | 1739 | 5955 | 2020-05-10T10:00:00Z | 171458 | 37984 | 32587 | 1652 | 87 | 24 | 1053 | 2850 | 159931 | posNeg | 3903 | 159931 | 47 | 23 | cc3b4727d8ee68d05e16ea1407339476965e6b38 | 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 );