states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
61 rows where "dateModified" is on date 2020-07-31
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, dateChecked, positiveTestsViral, negativeTestsViral, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, totalTestResultsSource, hospitalizedIncrease
dateChecked (date) ✖
- 2020-07-31 61
Link | rowid ▼ | date | state | positive | negative | pending | totalTestResults | hospitalizedCurrently | hospitalizedCumulative | inIcuCurrently | inIcuCumulative | onVentilatorCurrently | onVentilatorCumulative | recovered | dataQualityGrade | lastUpdateEt | dateModified | checkTimeEt | death | hospitalized | dateChecked | totalTestsViral | positiveTestsViral | negativeTestsViral | positiveCasesViral | deathConfirmed | deathProbable | totalTestEncountersViral | totalTestsPeopleViral | totalTestsAntibody | positiveTestsAntibody | negativeTestsAntibody | totalTestsPeopleAntibody | positiveTestsPeopleAntibody | negativeTestsPeopleAntibody | totalTestsPeopleAntigen | positiveTestsPeopleAntigen | totalTestsAntigen | positiveTestsAntigen | fips | positiveIncrease | negativeIncrease | total | totalTestResultsSource | totalTestResultsIncrease | posNeg | deathIncrease | hospitalizedIncrease | hash | commercialScore | negativeRegularScore | negativeScore | positiveScore | score | grade |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3093 | 3093 | 20200802 | GU | 367 | 21685 | 22052 | 2 | 2 | 304 | B | 7/31/2020 21:30 | 2020-07-31T21:30:00Z | 07/31 17:30 | 5 | 2020-07-31T21:30:00Z | 21873 | 359 | 22044 | 145 | 2 | 66 | 0 | 0 | 22052 | posNeg | 0 | 22052 | 0 | 0 | cb7577050ceb959b5e51bf60baad0e7554fb5e30 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
3099 | 3099 | 20200802 | KS | 27812 | 264695 | 292507 | 366 | 1751 | 98 | 494 | 26 | 179 | 1178 | A+ | 7/31/2020 10:00 | 2020-07-31T10:00:00Z | 07/31 06:00 | 358 | 1751 | 2020-07-31T10:00:00Z | 292507 | 20 | 0 | 0 | 292507 | posNeg | 0 | 292507 | 0 | 0 | 6b49b4c3e78c568e04d8514e87ab72926db0c87e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
3109 | 3109 | 20200802 | MS | 60553 | 401592 | 462145 | 1172 | 4314 | 302 | 172 | 35071 | A+ | 7/31/2020 19:00 | 2020-07-31T19:00:00Z | 07/31 15:00 | 1703 | 4314 | 2020-07-31T19:00:00Z | 460594 | 59637 | 1657 | 46 | 16566 | 95 | 28 | 672 | 0 | 462145 | posNeg | 672 | 462145 | 10 | 0 | 6d33b4b84662d3298198c987c9ef6c26de10316c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
3124 | 3124 | 20200802 | RI | 19022 | 186994 | 373276 | 76 | 2211 | 15 | 5 | 1823 | A+ | 7/31/2020 12:00 | 2020-07-31T12:00:00Z | 07/31 08:00 | 1007 | 2211 | 2020-07-31T12:00:00Z | 365066 | 27600 | 337466 | 19022 | 373276 | 206016 | 44 | 0 | 0 | 206016 | totalTestEncountersViral | 3974 | 206016 | 0 | 0 | 4ea2c17a22a6990ef718519a4ae7167a163cc946 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
3142 | 3142 | 20200801 | CA | 500130 | 7386457 | 7886587 | 7754 | 2120 | B | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 9224 | 2020-07-31T00:00:00Z | 7886587 | 500130 | 6 | 6542 | 69004 | 7886587 | posNeg | 75546 | 7886587 | 219 | 0 | 508ca3cd8b105c801aab8f1b9d52e6acb4a19c7d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
3145 | 3145 | 20200801 | DC | 12205 | 181576 | 193781 | 100 | 26 | 13 | 9816 | A+ | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 585 | 2020-07-31T00:00:00Z | 193781 | 131031 | 11 | 79 | 4961 | 193781 | posNeg | 5040 | 193781 | 0 | 0 | 775894e6012ab7a380072be67e2f4503813682c0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
3146 | 3146 | 20200801 | DE | 14877 | 168019 | 182896 | 45 | 18 | 8212 | A+ | 7/31/2020 18:00 | 2020-07-31T18:00:00Z | 07/31 14:00 | 585 | 2020-07-31T18:00:00Z | 13880 | 515 | 70 | 182896 | 10 | 89 | 1760 | 182896 | posNeg | 1849 | 182896 | 0 | 0 | 2844f2eb09314864e222a7c8d2b226844a947252 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
3147 | 3147 | 20200801 | FL | 480028 | 3199415 | 3409 | 3679443 | 8072 | 27344 | A | 7/31/2020 23:59 | 2020-07-31T23:59:00Z | 07/31 19:59 | 7144 | 27344 | 2020-07-31T23:59:00Z | 4793361 | 605946 | 4166771 | 480028 | 7144 | 3684875 | 358283 | 19175 | 339059 | 353026 | 18780 | 334221 | 12 | 9642 | 41713 | 3682852 | posNeg | 51355 | 3679443 | 178 | 439 | 774402daf0d1db26dc99c0492abaee1a0276df8a | 0 | 0 | 0 | 0 | 0 | ||||||||||||
3149 | 3149 | 20200801 | GU | 367 | 21685 | 22052 | 2 | 2 | 304 | B | 7/31/2020 21:25 | 2020-07-31T21:25:00Z | 07/31 17:25 | 5 | 2020-07-31T21:25:00Z | 21873 | 359 | 22044 | 145 | 2 | 66 | 11 | 159 | 22052 | posNeg | 170 | 22052 | 0 | 0 | 2e41c14772f975762924ada65ddff55530bebfc7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
3150 | 3150 | 20200801 | HI | 2111 | 121140 | 123251 | 75 | 179 | 15 | 10 | 1243 | C | 7/31/2020 23:31 | 2020-07-31T23:31:00Z | 07/31 19:31 | 26 | 179 | 2020-07-31T23:31:00Z | 152976 | 123251 | 15 | 122 | 1761 | 123251 | posNeg | 1883 | 123251 | 0 | 2 | a28914e1b8ffd873ade73e16be21fa62536c181e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
3152 | 3152 | 20200801 | ID | 20721 | 161152 | 180615 | 239 | 850 | 54 | 249 | 6998 | A | 7/31/2020 19:15 | 2020-07-31T19:15:00Z | 07/31 15:15 | 189 | 850 | 2020-07-31T19:15:00Z | 180615 | 19463 | 155 | 22 | 16 | 475 | 2288 | 181873 | posNeg | 2731 | 181873 | 12 | 15 | 12ea038fb5d63c555ea1c031f8de56c55a9ce022 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
3154 | 3154 | 20200801 | IN | 67122 | 691484 | 758606 | 977 | 8781 | 322 | 1836 | 81 | 46955 | A+ | 7/31/2020 23:59 | 2020-07-31T23:59:00Z | 07/31 19:59 | 2971 | 8781 | 2020-07-31T23:59:00Z | 942105 | 2771 | 200 | 758606 | 18 | 968 | 10255 | 758606 | posNeg | 11223 | 758606 | 6 | 54 | 3a277d3a8af8647c7ba282f70694ed8dffe58de0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
3155 | 3155 | 20200801 | KS | 27812 | 264695 | 292507 | 366 | 1751 | 98 | 494 | 26 | 179 | 1178 | A+ | 7/31/2020 10:00 | 2020-07-31T10:00:00Z | 07/31 06:00 | 358 | 1751 | 2020-07-31T10:00:00Z | 292507 | 20 | 0 | 0 | 292507 | posNeg | 0 | 292507 | 0 | 0 | 2991f627bdec916a8ca37c83b18aceac4d01c22a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
3157 | 3157 | 20200801 | LA | 116280 | 1225963 | 1342243 | 1546 | 222 | 74246 | A | 7/31/2020 13:00 | 2020-07-31T13:00:00Z | 07/31 09:00 | 3949 | 2020-07-31T13:00:00Z | 116280 | 3835 | 114 | 1342243 | 22 | 0 | 0 | 1342243 | posNeg | 0 | 1342243 | 0 | 0 | 6fc3d8825283b838d7e59f5c9e8dffd8b0a548dc | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
3158 | 3158 | 20200801 | MA | 118040 | 1083123 | 1613551 | 369 | 11930 | 53 | 26 | 97595 | A+ | 7/31/2020 10:00 | 2020-07-31T10:00:00Z | 07/31 06:00 | 8626 | 11930 | 2020-07-31T10:00:00Z | 1613551 | 146945 | 110077 | 8406 | 220 | 1193200 | 96964 | 25 | 428 | 12305 | 1201163 | totalTestsViral | 11055 | 1201163 | 17 | 22 | 190a9c8cec92d477f66258291f5701c390a7e665 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
3160 | 3160 | 20200801 | ME | 3937 | 165809 | 169746 | 10 | 388 | 5 | 1 | 3377 | A+ | 7/31/2020 23:59 | 2020-07-31T23:59:00Z | 07/31 19:59 | 123 | 388 | 2020-07-31T23:59:00Z | 169325 | 4905 | 164215 | 3516 | 122 | 1 | 8854 | 417 | 8425 | 23 | 25 | 2554 | 169746 | posNeg | 2579 | 169746 | 0 | 0 | ffbcd38dd4a8140c76b1cd558d1faa8e2fe413c0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||
3162 | 3162 | 20200801 | MN | 55188 | 791080 | 1040317 | 317 | 5208 | 149 | 1520 | 48119 | A | 7/31/2020 17:00 | 2020-07-31T17:00:00Z | 07/31 13:00 | 1646 | 5208 | 2020-07-31T17:00:00Z | 55188 | 1606 | 40 | 1040317 | 846268 | 27 | 725 | 11189 | 846268 | posNeg | 15401 | 846268 | 6 | 53 | ad8672ffdf917ab981ad0d53a92f1ead3b1606b1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
3165 | 3165 | 20200801 | MS | 59881 | 401592 | 461473 | 1172 | 4314 | 302 | 172 | 35071 | A+ | 7/31/2020 19:00 | 2020-07-31T19:00:00Z | 07/31 15:00 | 1693 | 4314 | 2020-07-31T19:00:00Z | 460594 | 59002 | 1648 | 45 | 16566 | 95 | 28 | 1134 | 5834 | 461473 | posNeg | 6968 | 461473 | 30 | 38 | 8f4d57146c136f7c444a06ddbe2ad42fd3c038b2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
3169 | 3169 | 20200801 | NE | 26211 | 249048 | 275259 | 152 | 1622 | 19172 | A | 7/31/2020 20:10 | 2020-07-31T20:10:00Z | 07/31 16:10 | 332 | 1622 | 2020-07-31T20:10:00Z | 26211 | 275544 | 31 | 445 | 3858 | 275259 | posNeg | 4303 | 275259 | 4 | 12 | 3c5e13f6c58dc948183d249b2ee14f0eee4089f0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
3172 | 3172 | 20200801 | NM | 20600 | 537412 | 558012 | 152 | 2686 | 8139 | B | 7/31/2020 17:50 | 2020-07-31T17:50:00Z | 07/31 13:50 | 642 | 2686 | 2020-07-31T17:50:00Z | 558012 | 20600 | 35 | 212 | 6163 | 558012 | posNeg | 6375 | 558012 | 7 | 19 | 5064227550275dda6c531303d1e5c54118542aac | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
3174 | 3174 | 20200801 | NY | 415767 | 5556207 | 5971974 | 581 | 89995 | 147 | 72 | 73134 | A | 7/31/2020 15:35 | 2020-07-31T15:35:00Z | 07/31 11:35 | 25164 | 89995 | 2020-07-31T15:35:00Z | 415767 | 5971974 | 36 | 753 | 81984 | 5971974 | posNeg | 82737 | 5971974 | 14 | 0 | cfb8fd3245d8f5c82e53fdf3e77825bfc3e9f3f9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
3180 | 3180 | 20200801 | RI | 19022 | 186994 | 369302 | 76 | 2211 | 15 | 5 | 1823 | A+ | 7/31/2020 12:00 | 2020-07-31T12:00:00Z | 07/31 08:00 | 1007 | 2211 | 2020-07-31T12:00:00Z | 365066 | 27600 | 337466 | 19022 | 369302 | 206016 | 44 | 0 | 0 | 206016 | totalTestEncountersViral | 5176 | 206016 | 0 | 0 | bd68d36b3018900994e405bb006d00f4cca4dece | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
3181 | 3181 | 20200801 | SC | 90599 | 621270 | 711869 | 1453 | 5527 | 359 | 235 | 32859 | A+ | 7/31/2020 23:59 | 2020-07-31T23:59:00Z | 07/31 19:59 | 1751 | 5527 | 2020-07-31T23:59:00Z | 711346 | 114251 | 597095 | 90076 | 1683 | 68 | 53233 | 3557 | 49676 | 45 | 1583 | 17451 | 711869 | posNeg | 19034 | 711869 | 39 | 410 | 96bed9ac5f6b04e72ecf85c5d466ffdde7d191e3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||
3182 | 3182 | 20200801 | SD | 8867 | 104065 | 112932 | 36 | 832 | 7820 | B | 7/31/2020 18:00 | 2020-07-31T18:00:00Z | 07/31 14:00 | 134 | 832 | 2020-07-31T18:00:00Z | 112932 | 46 | 103 | 1194 | 112932 | posNeg | 1297 | 112932 | 4 | 8 | 9867ce5961ffc4156478030d5b724cef516df2f1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
3186 | 3186 | 20200801 | VA | 90801 | 1036560 | 352 | 1123927 | 1256 | 13263 | 275 | 150 | 12007 | A+ | 7/31/2020 17:00 | 2020-07-31T17:00:00Z | 07/31 13:00 | 2215 | 13263 | 2020-07-31T17:00:00Z | 107823 | 87367 | 2105 | 110 | 1123927 | 51 | 913 | 15701 | 1127713 | posNeg | 16567 | 1127361 | 41 | -8 | f118a69d753a8efb2e5229887468fa2df322872d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
3193 | 3193 | 20200731 | AK | 3677 | 229429 | 233106 | 40 | 3 | 898 | A | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 23 | 2020-07-31T00:00:00Z | 233106 | 3677 | 23 | 2 | 118 | 7931 | 233106 | posNeg | 8049 | 233106 | 0 | 0 | 061dbd607d6dc83981c9d4f65ce38d9c3fd04714 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
3194 | 3194 | 20200731 | AL | 87723 | 601744 | 687022 | 1596 | 10521 | 1144 | 613 | 35401 | B | 7/31/2020 11:00 | 2020-07-31T11:00:00Z | 07/31 07:00 | 1580 | 10521 | 2020-07-31T11:00:00Z | 687022 | 85278 | 1531 | 49 | 1 | 1961 | 7398 | 689467 | posNeg | 9181 | 689467 | 15 | 451 | 4c194d2de2fef83417180863ea3fc37b8d019ff0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
3195 | 3195 | 20200731 | AR | 42511 | 460958 | 502717 | 507 | 2852 | 100 | 395 | 35413 | A | 7/31/2020 14:40 | 2020-07-31T14:40:00Z | 07/31 10:40 | 453 | 2852 | 2020-07-31T14:40:00Z | 502717 | 42511 | 7090 | 1085 | 5 | 752 | 0 | 503469 | posNeg | 0 | 503469 | 11 | 105 | 11bf0b6092c522c0bed3770d6f603a8f297d2d6b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
3197 | 3197 | 20200731 | AZ | 174010 | 759733 | 933743 | 2302 | 11260 | 719 | 505 | 22714 | A+ | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 3694 | 11260 | 2020-07-31T00:00:00Z | 137710 | 2431 | 152 | 933743 | 227897 | 4 | 3212 | 17265 | 933743 | posNeg | 20477 | 933743 | 68 | 88 | 62e3a64f227c6ec4bd0732fc9ddef5f4ce8c11a6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
3198 | 3198 | 20200731 | CA | 493588 | 7317453 | 7811041 | 7999 | 2163 | B | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 9005 | 2020-07-31T00:00:00Z | 7811041 | 493588 | 6 | 8086 | 169115 | 7811041 | posNeg | 177201 | 7811041 | 96 | 0 | 7120aada3e21e93383f857d4827d8f6402c2b913 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
3199 | 3199 | 20200731 | CO | 46204 | 480142 | 678823 | 350 | 6413 | 5309 | A | 7/31/2020 01:59 | 2020-07-31T01:59:00Z | 07/30 21:59 | 1691 | 6413 | 2020-07-31T01:59:00Z | 43032 | 678823 | 523174 | 136714 | 9293 | 127421 | 8 | 408 | 6266 | 526346 | totalTestEncountersViral | 10578 | 526346 | 3 | 15 | 4147c7602aafe161a6ccbeee8a6592f9a8df83cf | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
3204 | 3204 | 20200731 | GA | 186352 | 1388335 | 1574687 | 3155 | 18689 | 3414 | A | 7/31/2020 14:50 | 2020-07-31T14:50:00Z | 07/31 10:50 | 3752 | 18689 | 2020-07-31T14:50:00Z | 1574687 | 171306 | 1403381 | 186352 | 222213 | 14138 | 13 | 4066 | 29232 | 1574687 | posNeg | 33298 | 1574687 | 81 | 386 | 1ff562388caa2cf363e9c4e8c4db804a0f4624e6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
3207 | 3207 | 20200731 | IA | 44582 | 429830 | 474412 | 225 | 71 | 29 | 32578 | A+ | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 867 | 2020-07-31T00:00:00Z | 44582 | 476322 | 39222 | 2744 | 36439 | 19 | 544 | 4770 | 474412 | posNeg | 5314 | 474412 | 10 | 0 | d8892edf77c318f72ed10069800c1083f09a37a7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
3209 | 3209 | 20200731 | IL | 180118 | 2520731 | 2700849 | 1369 | 346 | 148 | A | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 7692 | 2020-07-31T00:00:00Z | 2699568 | 178837 | 7495 | 197 | 17 | 1980 | 47841 | 2700849 | posNeg | 49821 | 2700849 | 22 | 0 | 489a3298d72534f97237a5295c97c89b36eb173a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
3211 | 3211 | 20200731 | KS | 27812 | 264695 | 292507 | 366 | 1751 | 98 | 494 | 26 | 179 | 1178 | A+ | 7/31/2020 10:00 | 2020-07-31T10:00:00Z | 07/31 06:00 | 358 | 1751 | 2020-07-31T10:00:00Z | 292507 | 20 | 942 | 6616 | 292507 | posNeg | 7558 | 292507 | 9 | 51 | 8e73abfd4988d50c73a96e43e35203b34f72e715 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
3212 | 3212 | 20200731 | KY | 30151 | 557672 | 586076 | 597 | 3314 | 150 | 1133 | 7481 | B | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 735 | 3314 | 2020-07-31T00:00:00Z | 586076 | 28404 | 731 | 4 | 43408 | 222 | 21 | 765 | 7752 | 587823 | posNeg | 8440 | 587823 | 4 | 10 | 3e89373f5e4e84ff26037c6cb80063de33d6d9aa | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
3213 | 3213 | 20200731 | LA | 116280 | 1225963 | 1342243 | 1546 | 222 | 74246 | A | 7/31/2020 13:00 | 2020-07-31T13:00:00Z | 07/31 09:00 | 3949 | 2020-07-31T13:00:00Z | 116280 | 3835 | 114 | 1342243 | 22 | 1799 | 23054 | 1342243 | posNeg | 24853 | 1342243 | 24 | 0 | 08dc0ba785207d3ee64150fa6f462c284fdfd04d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
3214 | 3214 | 20200731 | MA | 117612 | 1070818 | 1602496 | 347 | 11908 | 58 | 28 | 97595 | A+ | 7/31/2020 10:00 | 2020-07-31T10:00:00Z | 07/31 06:00 | 8609 | 11908 | 2020-07-31T10:00:00Z | 1602496 | 146758 | 109787 | 8389 | 220 | 1180605 | 96180 | 25 | 514 | 18764 | 1188430 | totalTestsViral | 21526 | 1188430 | 14 | 15 | f5ab8508f56906807ba553762a83a6fcdd9138ac | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
3215 | 3215 | 20200731 | MD | 88346 | 822845 | 911191 | 590 | 12593 | 128 | 5689 | A | 7/31/2020 10:00 | 2020-07-31T10:00:00Z | 07/31 06:00 | 3493 | 12593 | 2020-07-31T10:00:00Z | 1209223 | 103840 | 88346 | 3362 | 131 | 911191 | 24 | 1169 | 16057 | 911191 | posNeg | 17226 | 911191 | 5 | 93 | b3cc1a81881200edf4732cc750a78eba3703760e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
3217 | 3217 | 20200731 | MI | 90574 | 1753873 | 1844447 | 727 | 238 | 144 | 57502 | A+ | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 6450 | 2020-07-31T00:00:00Z | 1868156 | 114283 | 1753873 | 81621 | 6199 | 251 | 214923 | 26 | 793 | 30476 | 1844447 | posNeg | 31269 | 1844447 | 7 | 0 | 72cb17b989cd84db0710041c9a3d3e933b57abf0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
3219 | 3219 | 20200731 | MO | 50323 | 636450 | 686773 | 869 | 108 | B | 7/31/2020 15:00 | 2020-07-31T15:00:00Z | 07/31 11:00 | 1243 | 2020-07-31T15:00:00Z | 895691 | 57753 | 836423 | 50323 | 686773 | 59610 | 2178 | 57432 | 29 | 1489 | 10151 | 686773 | posNeg | 11640 | 686773 | 10 | 0 | 8f4f70b1ae36471f5368fb1754b60b1fc00a9e16 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
3222 | 3222 | 20200731 | MT | 3965 | 166005 | 169970 | 71 | 230 | 2331 | C | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 60 | 230 | 2020-07-31T00:00:00Z | 169970 | 3965 | 30 | 151 | 1203 | 169970 | posNeg | 1354 | 169970 | 5 | 9 | 497454692e71ad8c7e6d10c7112c2348725fa319 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
3223 | 3223 | 20200731 | NC | 122148 | 1634954 | 1757102 | 1229 | 363 | 92302 | A+ | 7/31/2020 11:55 | 2020-07-31T11:55:00Z | 07/31 07:55 | 1924 | 2020-07-31T11:55:00Z | 1757102 | 122148 | 1924 | 37 | 1954 | 30224 | 1757102 | posNeg | 32178 | 1757102 | 21 | 0 | 59663663ce1a7fda7cb40c46a54167d2bda791c2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
3224 | 3224 | 20200731 | ND | 6461 | 147495 | 301509 | 47 | 364 | 5289 | C | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 95 | 364 | 2020-07-31T00:00:00Z | 310230 | 6461 | 91 | 4 | 301509 | 151245 | 7354 | 261 | 7093 | 38 | 167 | 1935 | 153956 | totalTestEncountersViral | 5031 | 153956 | 0 | 8 | 954a82329de633ddb061383fcb0ce9fec55ab7b0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
3227 | 3227 | 20200731 | NJ | 181660 | 1914669 | 2096329 | 695 | 21565 | 113 | 45 | 32475 | A+ | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 15728 | 21565 | 2020-07-31T00:00:00Z | 2096329 | 181660 | 13944 | 1784 | 34 | 690 | 36075 | 2096329 | posNeg | 36765 | 2096329 | 11 | 0 | d429c7ed83fe6295973f34065af57174d3825a2f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
3229 | 3229 | 20200731 | NV | 48088 | 421815 | 469903 | 1159 | 333 | 191 | 1127 | A+ | 7/31/2020 02:59 | 2020-07-31T02:59:00Z | 07/30 22:59 | 830 | 2020-07-31T02:59:00Z | 616731 | 48088 | 468967 | 32 | 1264 | 4994 | 469903 | posNeg | 6258 | 469903 | 29 | 0 | 7fb96fc7e90a614938c36a179745872031d83378 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
3231 | 3231 | 20200731 | OH | 91159 | 1377175 | 1468334 | 1024 | 10790 | 330 | 2552 | 185 | 65788 | B | 7/31/2020 14:00 | 2020-07-31T14:00:00Z | 07/31 10:00 | 3489 | 10790 | 2020-07-31T14:00:00Z | 1463508 | 86333 | 3222 | 267 | 39 | 1533 | 20329 | 1468334 | posNeg | 21862 | 1468334 | 47 | 112 | 840f706b145150d69f2f49bf5585fe2421641402 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
3232 | 3232 | 20200731 | OK | 36487 | 589091 | 625578 | 621 | 3161 | 253 | 29187 | A+ | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 541 | 3161 | 2020-07-31T00:00:00Z | 632535 | 42245 | 589091 | 36487 | 57683 | 2071 | 40 | 747 | 9815 | 625578 | posNeg | 10562 | 625578 | 5 | 57 | b2362d885a897a091aaf1b650b6bfef521f9582e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
3233 | 3233 | 20200731 | OR | 18492 | 385701 | 404193 | 208 | 1607 | 65 | 32 | 3872 | A+ | 7/31/2020 03:01 | 2020-07-31T03:01:00Z | 07/30 23:01 | 322 | 1607 | 2020-07-31T03:01:00Z | 385701 | 17540 | 403241 | 41 | 361 | 5193 | 404193 | posNeg | 5554 | 404193 | 6 | 20 | 43b894b00ff8f52b0a6eff54f260b44029a6d0d3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
3234 | 3234 | 20200731 | PA | 112048 | 1104824 | 1216872 | 522 | 89 | 84036 | A+ | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 7189 | 2020-07-31T00:00:00Z | 108907 | 1213731 | 42 | 970 | 15965 | 1216872 | posNeg | 16935 | 1216872 | 13 | 0 | 8912619276b65c4ff5f6562c5901c3b25ac85444 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
3235 | 3235 | 20200731 | PR | 16781 | 305972 | 322753 | 488 | 62 | 39 | B | 7/31/2020 06:30 | 2020-07-31T06:30:00Z | 07/31 02:30 | 219 | 2020-07-31T06:30:00Z | 310546 | 7002 | 303412 | 5997 | 113 | 106 | 10784 | 72 | 209 | 0 | 322753 | posNeg | 209 | 322753 | 5 | 0 | 4385e1a5582d72002d8b9ac840333b48df1347d6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
3236 | 3236 | 20200731 | RI | 19022 | 186994 | 364126 | 76 | 2211 | 15 | 5 | 1823 | A+ | 7/31/2020 12:00 | 2020-07-31T12:00:00Z | 07/31 08:00 | 1007 | 2211 | 2020-07-31T12:00:00Z | 365066 | 27600 | 337466 | 19022 | 364126 | 206016 | 44 | 72 | 1425 | 206016 | totalTestEncountersViral | 4031 | 206016 | 0 | 9 | 40d935653ce7c7098d8a65b125e2752392431104 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
3237 | 3237 | 20200731 | SC | 89016 | 603819 | 692835 | 1516 | 5117 | 373 | 237 | 32859 | A+ | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 1712 | 5117 | 2020-07-31T00:00:00Z | 690936 | 110168 | 580768 | 88523 | 1647 | 65 | 52407 | 3430 | 48977 | 45 | 1444 | 0 | 692835 | posNeg | 1444 | 692835 | 45 | 0 | 98e601770ea6f2f27b410b3ee0542517077189b5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||
3239 | 3239 | 20200731 | TN | 105959 | 1407446 | 1513405 | 1494 | 4661 | 66357 | A | 7/31/2020 15:00 | 2020-07-31T15:00:00Z | 07/31 11:00 | 1060 | 4661 | 2020-07-31T15:00:00Z | 1512224 | 124910 | 1387314 | 104778 | 1023 | 37 | 47 | 3088 | 29505 | 1513405 | posNeg | 32593 | 1513405 | 27 | 89 | d9da33169c7131b3cacc9c18d2b6859391407cd4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
3240 | 3240 | 20200731 | TX | 420946 | 3248806 | 3669752 | 9336 | 3117 | 273191 | A | 7/31/2020 17:10 | 2020-07-31T17:10:00Z | 07/31 13:10 | 6569 | 2020-07-31T17:10:00Z | 3669752 | 420946 | 241518 | 11712 | 48 | 8839 | 51439 | 3669752 | posNeg | 60278 | 3669752 | 295 | 0 | acdf3efc45c8021d072f3c67d77bb6194f9b75ef | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
3241 | 3241 | 20200731 | UT | 40196 | 488714 | 528910 | 258 | 2377 | 81 | 618 | 250 | 28130 | A+ | 7/31/2020 10:58 | 2020-07-31T10:58:00Z | 07/31 06:58 | 304 | 2377 | 2020-07-31T10:58:00Z | 631309 | 40196 | 528910 | 1166 | 489 | 1402 | 518 | 49 | 500 | 4043 | 528910 | posNeg | 4543 | 528910 | 4 | 31 | 124c8daf9b74c6bc11b0c79b5bd401a9aaa5b5a7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
3243 | 3243 | 20200731 | VI | 406 | 8775 | 12 | 9181 | 338 | C | 7/31/2020 06:53 | 2020-07-31T06:53:00Z | 07/31 02:53 | 8 | 2020-07-31T06:53:00Z | 9193 | 8 | 78 | 21 | 356 | 9193 | posNeg | 377 | 9181 | 0 | 0 | af60eedca6f7b5e2ee12c1cdc5cd1bba6e97fc3e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
3244 | 3244 | 20200731 | VT | 1414 | 92954 | 94368 | 16 | 1211 | B | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 57 | 2020-07-31T00:00:00Z | 1414 | 57 | 94368 | 50 | 7 | 1077 | 94368 | posNeg | 1084 | 94368 | 0 | 0 | b000d6499b949e01437283a5f66918d0d3834f7c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
3246 | 3246 | 20200731 | WI | 56934 | 882149 | 132 | 939083 | 308 | 4637 | 108 | 900 | 42317 | A+ | 7/31/2020 00:00 | 2020-07-31T00:00:00Z | 07/30 20:00 | 941 | 4637 | 2020-07-31T00:00:00Z | 52940 | 934 | 7 | 935089 | 55 | 855 | 14547 | 939215 | posNeg | 15402 | 939083 | 15 | 47 | 9ea54aef82549d4f26b45906748fe2fa32a83ee9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
3247 | 3247 | 20200731 | WV | 6642 | 277346 | 283988 | 108 | 39 | 18 | 4815 | B | 7/31/2020 17:00 | 2020-07-31T17:00:00Z | 07/31 13:00 | 116 | 2020-07-31T17:00:00Z | 283848 | 6502 | 14221 | 54 | 220 | 6287 | 283988 | posNeg | 6507 | 283988 | 1 | 0 | 5dabd8e078bbac32903ff29f1da3f5ebba8450f7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
3248 | 3248 | 20200731 | WY | 2726 | 50573 | 53299 | 18 | 166 | 2123 | B | 7/31/2020 17:26 | 2020-07-31T17:26:00Z | 07/31 13:26 | 26 | 166 | 2020-07-31T17:26:00Z | 75767 | 2348 | 73418 | 2254 | 52827 | 56 | 40 | 618 | 53299 | posNeg | 658 | 53299 | 0 | 0 | 7174a2f9b1b166d783b26b0138cce86f7231b5ab | 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 );