states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
73 rows where "dateChecked" is on date 2020-07-16 sorted by negativeTestsAntibody
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, dateChecked, negativeTestsViral, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3196 | 3196 | 20200731 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | f8438af652f6e593542c605b427745bddbcb19c6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3252 | 3252 | 20200730 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | 0d822a908c5b259a0ebbc02fae6aeb4fc3e466a1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3308 | 3308 | 20200729 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | 0564aa9bb6aa9ef9f7a1ec0e814bb2247f6af5d8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3364 | 3364 | 20200728 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | 7e242daf6352307905db28bd15fc388dfe897b92 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3420 | 3420 | 20200727 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | 4152bbe9f7b61f118fbb1b2f6d671683cad06e15 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3476 | 3476 | 20200726 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | 43464e286af2177811b5c6a8819a24526bca478c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3532 | 3532 | 20200725 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | a2a4d5d0111a4a0852760cf7649f84270ffb5c71 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3588 | 3588 | 20200724 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | 6c1f867643f449fe63cb941b9c04f6f2e257027a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3644 | 3644 | 20200723 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | 40361838d8402276ac00060e602ec48543dfeccc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3700 | 3700 | 20200722 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | 8e73af1cc70b1d09c0daca2570b09c32f4238e16 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3756 | 3756 | 20200721 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | 8574f9136aa284e92a35b7074ffbd49d4121d5f7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3812 | 3812 | 20200720 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | fdfa63feba7c83b98a71fa85af9fcf686eb299e7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3868 | 3868 | 20200719 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | 80e2c75686d394f2316949af87bf18659355c48e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3892 | 3892 | 20200719 | MP | 37 | 10664 | 10701 | 4 | 29 | D | 7/16/2020 19:06 | 2020-07-16T19:06:00Z | 07/16 15:06 | 2 | 4 | 2020-07-16T19:06:00Z | 11335 | 37 | 10697 | 69 | 0 | 0 | 10701 | posNeg | 0 | 10701 | 0 | 0 | bd4f94361289895d2ae39b79aa2402be801c9256 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
3924 | 3924 | 20200718 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | 65b6d063d650cf02681db34d463ad929b11d0b75 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3928 | 3928 | 20200718 | CT | 47893 | 582076 | 629969 | 66 | 10654 | 8466 | B | 7/16/2020 20:30 | 2020-07-16T20:30:00Z | 07/16 16:30 | 4396 | 10654 | 2020-07-16T20:30:00Z | 627986 | 45910 | 3519 | 877 | 9 | 0 | -139 | 629969 | posNeg | -139 | 629969 | 0 | 0 | 38c3a931ce76effed71dd2e78f1407a1b83395bc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
3948 | 3948 | 20200718 | MP | 37 | 10664 | 10701 | 4 | 29 | D | 7/16/2020 19:06 | 2020-07-16T19:06:00Z | 07/16 15:06 | 2 | 4 | 2020-07-16T19:06:00Z | 11335 | 37 | 10697 | 69 | 0 | 0 | 10701 | posNeg | 0 | 10701 | 0 | 0 | 0c41e8889d377e71d5f59d0f56bc915e4311b0d6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
3980 | 3980 | 20200717 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 0 | 1037 | posNeg | 0 | 1037 | 0 | 0 | 92b5b8663421a5e713eae43663212b475978ac4b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
3984 | 3984 | 20200717 | CT | 47893 | 582215 | 630108 | 66 | 10654 | 8466 | B | 7/16/2020 20:30 | 2020-07-16T20:30:00Z | 07/16 16:30 | 4396 | 10654 | 2020-07-16T20:30:00Z | 627986 | 45771 | 3519 | 877 | 9 | 143 | -118 | 630108 | posNeg | 25 | 630108 | 7 | 0 | d249a3b3806fcb8e41fd125213203043b332037c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
3985 | 3985 | 20200717 | DC | 11115 | 130492 | 141607 | 87 | 17 | 14 | 1863 | A+ | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 577 | 2020-07-16T00:00:00Z | 141607 | 103849 | 11 | 39 | 1326 | 141607 | posNeg | 1365 | 141607 | 3 | 0 | 873b29839180bb2bbf394d58add519da31f55020 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
3986 | 3986 | 20200717 | DE | 13337 | 135273 | 148610 | 55 | 7 | 7315 | A+ | 7/16/2020 18:00 | 2020-07-16T18:00:00Z | 07/16 14:00 | 521 | 2020-07-16T18:00:00Z | 12355 | 463 | 58 | 148610 | 10 | 223 | 3517 | 148610 | posNeg | 3740 | 148610 | 0 | 0 | 8a9175089eeaae58371a7ba90f75a196d3edda4b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
3987 | 3987 | 20200717 | FL | 327241 | 2553527 | 2250 | 2880768 | 8961 | 20526 | A | 7/16/2020 23:59 | 2020-07-16T23:59:00Z | 07/16 19:59 | 4912 | 20526 | 2020-07-16T23:59:00Z | 3600738 | 407133 | 3183379 | 327241 | 4912 | 2884245 | 297009 | 12002 | 284980 | 12 | 11466 | 53684 | 2883018 | posNeg | 65150 | 2880768 | 130 | 372 | 379d4d4b2dd8f981f54fb51ae47b55db815da7ef | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
3989 | 3989 | 20200717 | GU | 314 | 17938 | 18252 | 4 | 214 | B | 7/16/2020 21:40 | 2020-07-16T21:40:00Z | 07/16 17:40 | 5 | 2020-07-16T21:40:00Z | 18224 | 306 | 18244 | 145 | 2 | 66 | 0 | 241 | 18252 | posNeg | 241 | 18252 | 0 | 0 | 01d5d2cacb09eb304030fa5d09221f105857bdd4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
3990 | 3990 | 20200717 | HI | 1311 | 99893 | 101204 | 39 | 138 | 975 | D | 7/16/2020 18:00 | 2020-07-16T18:00:00Z | 07/16 14:00 | 22 | 138 | 2020-07-16T18:00:00Z | 121512 | 101204 | 15 | 19 | 1798 | 101204 | posNeg | 1817 | 101204 | 0 | 1 | b9a368af20b88a6337634ede365017da085003ad | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
3992 | 3992 | 20200717 | ID | 13133 | 127186 | 139481 | 153 | 554 | 35 | 165 | 3676 | A | 7/16/2020 19:00 | 2020-07-16T19:00:00Z | 07/16 15:00 | 114 | 554 | 2020-07-16T19:00:00Z | 139481 | 12295 | 93 | 21 | 16 | 688 | 2768 | 140319 | posNeg | 3426 | 140319 | 4 | 28 | 6fe93e9975bd6b61c198e47d1c42498be1c3238b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
3993 | 3993 | 20200717 | IL | 160509 | 2006965 | 2167474 | 1431 | 309 | 128 | A | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 7465 | 2020-07-16T00:00:00Z | 2166299 | 159334 | 7272 | 193 | 17 | 1427 | 42308 | 2167474 | posNeg | 43735 | 2167474 | 13 | 0 | f58c6bf329f7564e2dc51800a1adf80b7d48e82c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
3994 | 3994 | 20200717 | IN | 54813 | 549822 | 604635 | 815 | 7814 | 258 | 1658 | 80 | 40421 | A+ | 7/16/2020 23:59 | 2020-07-16T23:59:00Z | 07/16 19:59 | 2803 | 7814 | 2020-07-16T23:59:00Z | 2610 | 193 | 604635 | 18 | 733 | 8344 | 604635 | posNeg | 9077 | 604635 | 8 | 67 | 1268bb18f34f1ebd12c728b4679aababa62e85c4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4002 | 4002 | 20200717 | MN | 45013 | 774498 | 819511 | 252 | 4563 | 110 | 1369 | 38568 | A | 7/16/2020 17:00 | 2020-07-16T17:00:00Z | 07/16 13:00 | 1573 | 4563 | 2020-07-16T17:00:00Z | 45013 | 1533 | 40 | 819511 | 27 | 666 | 13633 | 819511 | posNeg | 14299 | 819511 | 7 | 37 | fdbe8120831e31d658f6b233ad8527a5956cc6e4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4004 | 4004 | 20200717 | MP | 37 | 10664 | 10701 | 4 | 29 | D | 7/16/2020 19:06 | 2020-07-16T19:06:00Z | 07/16 15:06 | 2 | 4 | 2020-07-16T19:06:00Z | 11335 | 37 | 10697 | 69 | 1 | 0 | 10701 | posNeg | 1 | 10701 | 0 | 0 | 5cd6e4a5cf622af8dedd9a05ea6ecfe29983b98f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4005 | 4005 | 20200717 | MS | 40829 | 330635 | 371464 | 1076 | 3712 | 253 | 129 | 25932 | A | 7/16/2020 19:00 | 2020-07-16T19:00:00Z | 07/16 15:00 | 1332 | 3712 | 2020-07-16T19:00:00Z | 370993 | 40358 | 1303 | 29 | 14384 | 95 | 28 | 1032 | 6532 | 371464 | posNeg | 7564 | 371464 | 24 | 37 | a0d7873678c515385bb109bca9306011d40167b4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
4009 | 4009 | 20200717 | NE | 22134 | 204062 | 226196 | 96 | 1453 | 16501 | B | 7/16/2020 20:30 | 2020-07-16T20:30:00Z | 07/16 16:30 | 299 | 1453 | 2020-07-16T20:30:00Z | 22134 | 226452 | 31 | 155 | 2812 | 226196 | posNeg | 2967 | 226196 | 8 | 0 | e683f6de621db90da2892d7b22a59d1ad54d1e7b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4012 | 4012 | 20200717 | NM | 16138 | 427230 | 443368 | 170 | 2312 | 6578 | B | 7/16/2020 18:06 | 2020-07-16T18:06:00Z | 07/16 14:06 | 562 | 2312 | 2020-07-16T18:06:00Z | 443368 | 16138 | 35 | 297 | 6066 | 443368 | posNeg | 6363 | 443368 | 5 | 28 | 0d93d6908b0f99b28b3cba70c07690ad5e897212 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4014 | 4014 | 20200717 | NY | 405551 | 4593898 | 4999449 | 765 | 89995 | 179 | 98 | 71970 | A | 7/16/2020 23:59 | 2020-07-16T23:59:00Z | 07/16 19:59 | 25024 | 89995 | 2020-07-16T23:59:00Z | 405551 | 4999449 | 36 | 776 | 77463 | 4999449 | posNeg | 78239 | 4999449 | 10 | 0 | 80b6f9c0c93e8c679b3f7658c718a257a7991546 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
4017 | 4017 | 20200717 | OR | 13802 | 310393 | 324195 | 242 | 1327 | 64 | 34 | 3199 | A+ | 7/16/2020 03:01 | 2020-07-16T03:01:00Z | 07/15 23:01 | 254 | 1327 | 2020-07-16T03:01:00Z | 310393 | 13085 | 323478 | 41 | 293 | 4956 | 324195 | posNeg | 5249 | 324195 | 5 | 16 | b7b62504e46d1fe7e86db4d7dac8f5ae17a375d3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
4022 | 4022 | 20200717 | SD | 7789 | 88184 | 95973 | 61 | 763 | 6808 | B | 7/16/2020 18:00 | 2020-07-16T18:00:00Z | 07/16 14:00 | 116 | 763 | 2020-07-16T18:00:00Z | 95973 | 46 | 95 | 1842 | 95973 | posNeg | 1937 | 95973 | 1 | 6 | 5576a5250376ee57ecd71ab1d6e8d50c4cb6e4d8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
4026 | 4026 | 20200717 | VA | 75433 | 801271 | 470 | 880326 | 1171 | 11054 | 247 | 118 | 9883 | A+ | 7/16/2020 17:00 | 2020-07-16T17:00:00Z | 07/16 13:00 | 2013 | 11054 | 2020-07-16T17:00:00Z | 90256 | 72516 | 1909 | 104 | 880326 | 51 | 1002 | 14529 | 877174 | posNeg | 12395 | 876704 | 6 | 276 | 1265577f6edf06bc84b77180cd3f984e0136db55 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
4027 | 4027 | 20200717 | VI | 263 | 5790 | 112 | 6053 | 126 | C | 7/16/2020 21:18 | 2020-07-16T21:18:00Z | 07/16 17:18 | 6 | 2020-07-16T21:18:00Z | 6165 | 6 | 78 | 14 | 754 | 6165 | posNeg | 768 | 6053 | 0 | 0 | ce9317fbad918c50b434983a5cbec1d35a6344ba | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
4029 | 4029 | 20200717 | WA | 49358 | 859275 | 908633 | 379 | 4944 | 45 | B | 7/16/2020 02:59 | 2020-07-16T02:59:00Z | 07/15 22:59 | 1427 | 4944 | 2020-07-16T02:59:00Z | 49358 | 1427 | 908633 | 753174 | 53 | 878 | 15519 | 908633 | posNeg | 16397 | 908633 | 6 | 115 | 5ad0bdb94454c60f5797cc4f29d724a434bb6743 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
4033 | 4033 | 20200716 | AK | 2032 | 160990 | 163022 | 32 | 0 | 688 | A | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 17 | 2020-07-16T00:00:00Z | 163022 | 2032 | 17 | 2 | 401 | 6528 | 163022 | posNeg | 6929 | 163022 | 0 | 0 | 0ee4b6e4c7aa637a0a0cce742968414d6c921a2f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4034 | 4034 | 20200716 | AL | 61088 | 490021 | 550179 | 1395 | 7584 | 950 | 516 | 29736 | B | 7/16/2020 11:00 | 2020-07-16T11:00:00Z | 07/16 07:00 | 1230 | 7584 | 2020-07-16T11:00:00Z | 550179 | 60158 | 1200 | 30 | 1 | 2021 | 8039 | 551109 | posNeg | 9972 | 551109 | 19 | 293 | fed6c54ff978566f4a73f0f60f117c88fe1f720d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4035 | 4035 | 20200716 | AR | 31114 | 369847 | 400144 | 470 | 1994 | 101 | 286 | 24195 | A | 7/16/2020 14:36 | 2020-07-16T14:36:00Z | 07/16 10:36 | 341 | 1994 | 2020-07-16T14:36:00Z | 400144 | 31114 | 5 | 817 | 4368 | 400961 | posNeg | 4932 | 400961 | 6 | 46 | 21df27c9acbacc8df91b052564602aac8c6ac4c0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
4036 | 4036 | 20200716 | AS | 0 | 1037 | 1037 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 0 | 2020-07-16T00:00:00Z | 1037 | 0 | 60 | 0 | 221 | 1037 | posNeg | 221 | 1037 | 0 | 0 | 65cf05131efa19c37bf7e74c0a54f7b8dee6b9bb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
4037 | 4037 | 20200716 | AZ | 134613 | 614653 | 748491 | 3454 | 6296 | 918 | 657 | 16684 | A+ | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 2492 | 6296 | 2020-07-16T00:00:00Z | 133838 | 2353 | 139 | 748491 | 203318 | 4 | 3259 | 10045 | 749266 | posNeg | 13307 | 749266 | 58 | 193 | 3da4dd8837f54626fb5c802f6315a2fadd38319b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4038 | 4038 | 20200716 | CA | 356178 | 5559330 | 5915508 | 8363 | 2120 | B | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 7345 | 2020-07-16T00:00:00Z | 5915508 | 356178 | 6 | 8544 | 113688 | 5915508 | posNeg | 122232 | 5915508 | 118 | 0 | 02f714b65e5c5d8de05222db9f7a3f65ee785696 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
4044 | 4044 | 20200716 | GA | 131275 | 1046947 | 1178222 | 2841 | 14346 | 2736 | A | 7/16/2020 14:50 | 2020-07-16T14:50:00Z | 07/16 10:50 | 3104 | 14346 | 2020-07-16T14:50:00Z | 1178222 | 119761 | 1058461 | 131275 | 191262 | 10071 | 13 | 3441 | 19798 | 1178222 | posNeg | 23239 | 1178222 | 13 | 244 | 78fc2dad320188f87006d6c37eb7a24c5ff8cf0f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4047 | 4047 | 20200716 | IA | 37132 | 359319 | 396451 | 195 | 65 | 34 | 27404 | A+ | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 778 | 2020-07-16T00:00:00Z | 37132 | 397678 | 36397 | 2499 | 33862 | 19 | 841 | 8298 | 396451 | posNeg | 9139 | 396451 | 16 | 0 | 16cb3cf1546fc61a0a7d40a3dbf0bc113ca0e53a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
4049 | 4049 | 20200716 | IL | 159082 | 1964657 | 2123739 | 1434 | 311 | 127 | A | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 7452 | 2020-07-16T00:00:00Z | 2122607 | 157950 | 7251 | 201 | 17 | 1257 | 41749 | 2123739 | posNeg | 43006 | 2123739 | 25 | 0 | 90cf6f79fa537c0cf5e3883609ffff0b6678ae7b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
4052 | 4052 | 20200716 | KY | 21083 | 446921 | 467039 | 418 | 2842 | 92 | 1030 | 5500 | B | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 650 | 2842 | 2020-07-16T00:00:00Z | 467039 | 20118 | 646 | 4 | 40158 | 21 | 406 | 8411 | 468004 | posNeg | 8792 | 468004 | 5 | 19 | 0bed8b0b254e3d5fd7f869450c3130a8f5721ca2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4053 | 4053 | 20200716 | LA | 86411 | 937726 | 1024137 | 1401 | 162 | 53288 | B | 7/16/2020 13:00 | 2020-07-16T13:00:00Z | 07/16 09:00 | 3485 | 2020-07-16T13:00:00Z | 86411 | 3375 | 110 | 1024137 | 22 | 2280 | 20657 | 1024137 | posNeg | 22937 | 1024137 | 24 | 0 | f0b01179a5cc4a61d41de361d41d03b1e096f5ef | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
4054 | 4054 | 20200716 | MA | 112581 | 889103 | 1340149 | 557 | 11663 | 77 | 38 | 95390 | A+ | 7/16/2020 10:00 | 2020-07-16T10:00:00Z | 07/16 06:00 | 8380 | 11663 | 2020-07-16T10:00:00Z | 1340149 | 141964 | 106271 | 8163 | 217 | 995374 | 83598 | 25 | 234 | 12737 | 1001684 | totalTestsViral | 17586 | 1001684 | 12 | 12 | de8e9843c7f42a7ba5ca48fe05bd60098148b921 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
4055 | 4055 | 20200716 | MD | 75664 | 616865 | 692529 | 436 | 11687 | 137 | 5286 | A | 7/16/2020 10:00 | 2020-07-16T10:00:00Z | 07/16 06:00 | 3347 | 11687 | 2020-07-16T10:00:00Z | 867188 | 88713 | 75664 | 3215 | 132 | 692529 | 24 | 648 | 11793 | 692529 | posNeg | 12441 | 692529 | 6 | 62 | 8a1af8d8d06176ea69fda3885e3d175eb6155392 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4057 | 4057 | 20200716 | MI | 79839 | 1315315 | 1395154 | 680 | 201 | 107 | 53867 | A+ | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 6348 | 2020-07-16T00:00:00Z | 1414802 | 99487 | 1315315 | 71842 | 6101 | 247 | 190043 | 26 | 926 | 26309 | 1395154 | posNeg | 27235 | 1395154 | 18 | 0 | 3ff271f791d1f96d8beba0cb513d89017d606cca | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4059 | 4059 | 20200716 | MO | 30422 | 498879 | 529301 | 875 | 86 | B | 7/16/2020 15:00 | 2020-07-16T15:00:00Z | 07/16 11:00 | 1113 | 2020-07-16T15:00:00Z | 664810 | 35179 | 628610 | 30422 | 529301 | 52063 | 1789 | 50274 | 29 | 708 | 10646 | 529301 | posNeg | 11354 | 529301 | 11 | 0 | fd4d51034b9617bc092fe6443ee9d99e2502c649 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4062 | 4062 | 20200716 | MT | 2231 | 125609 | 127840 | 37 | 150 | 970 | C | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 35 | 150 | 2020-07-16T00:00:00Z | 127840 | 2231 | 30 | 135 | 3947 | 127840 | posNeg | 4082 | 127840 | 1 | 5 | e0784ccdf1c34c6476470d11d9ef10d153690d0b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4063 | 4063 | 20200716 | NC | 93426 | 1219331 | 1312757 | 1134 | 67124 | A | 7/16/2020 11:25 | 2020-07-16T11:25:00Z | 07/16 07:25 | 1588 | 2020-07-16T11:25:00Z | 1312757 | 93426 | 1588 | 37 | 2160 | 25960 | 1312757 | posNeg | 28120 | 1312757 | 20 | 0 | b8d6fae17729a72e4a22227b2726aeed46802f5a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
4067 | 4067 | 20200716 | NJ | 176501 | 1583403 | 1759904 | 862 | 20774 | 146 | 64 | 31400 | A+ | 7/16/2020 13:00 | 2020-07-16T13:00:00Z | 07/16 09:00 | 15467 | 20774 | 2020-07-16T13:00:00Z | 1759904 | 176501 | 13691 | 1776 | 34 | 223 | 17334 | 1759904 | posNeg | 17557 | 1759904 | 31 | 0 | eb2b8c48c5b89bec6f34e1c9e94037c7d61c9a2b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4069 | 4069 | 20200716 | NV | 31915 | 338928 | 370843 | 1051 | 251 | 124 | 834 | A+ | 7/16/2020 13:30 | 2020-07-16T13:30:00Z | 07/16 09:30 | 626 | 2020-07-16T13:30:00Z | 465682 | 31915 | 369204 | 32 | 1447 | 4971 | 370843 | posNeg | 6418 | 370843 | 8 | 0 | 5ab3b261696fa70a20540d41215c8586eae8a0fa | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
4071 | 4071 | 20200716 | OH | 70601 | 1018192 | 1088793 | 1024 | 9324 | 310 | 2280 | 150 | 48330 | B | 7/16/2020 14:00 | 2020-07-16T14:00:00Z | 07/16 10:00 | 3103 | 9324 | 2020-07-16T14:00:00Z | 1084732 | 66540 | 2849 | 254 | 39 | 1290 | 24880 | 1088793 | posNeg | 26170 | 1088793 | 28 | 115 | 36b3e1ec91c7dfd41da9768eb189f3334227e783 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4072 | 4072 | 20200716 | OK | 23441 | 433376 | 456817 | 638 | 2218 | 235 | 18095 | A+ | 7/16/2020 08:00 | 2020-07-16T08:00:00Z | 07/16 04:00 | 438 | 2218 | 2020-07-16T08:00:00Z | 460246 | 25931 | 433376 | 23441 | 49472 | 1592 | 40 | 628 | 8864 | 456817 | posNeg | 9492 | 456817 | 6 | 48 | a4f2b9648795bf1173486540ee56716d5510aea5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4073 | 4073 | 20200716 | OR | 13509 | 305437 | 318946 | 219 | 1311 | 63 | 33 | 3199 | A+ | 7/16/2020 03:01 | 2020-07-16T03:01:00Z | 07/15 23:01 | 249 | 1311 | 2020-07-16T03:01:00Z | 305437 | 12807 | 318244 | 41 | 428 | 6732 | 318946 | posNeg | 7160 | 318946 | 2 | 21 | 7a135780414f9944676363a07620ebac9e33ff26 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
4074 | 4074 | 20200716 | PA | 98446 | 885195 | 983641 | 652 | 95 | 74818 | A+ | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 6973 | 2020-07-16T00:00:00Z | 95632 | 980827 | 42 | 781 | 14211 | 983641 | posNeg | 14992 | 983641 | 16 | 0 | 2c4383f27c524ec86d80a26d5e232ff2f51f3db6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
4075 | 4075 | 20200716 | PR | 10574 | 255766 | 266340 | 280 | 25 | 14 | B | 7/16/2020 06:30 | 2020-07-16T06:30:00Z | 07/16 02:30 | 172 | 2020-07-16T06:30:00Z | 258001 | 3966 | 253922 | 3119 | 75 | 97 | 7455 | 72 | 195 | 0 | 266340 | posNeg | 195 | 266340 | 1 | 0 | 73564a113232f44b5a77e30fcdfbce4a371c4835 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4076 | 4076 | 20200716 | RI | 17711 | 159677 | 305294 | 64 | 2084 | 4 | 3 | 1711 | A+ | 7/16/2020 12:00 | 2020-07-16T12:00:00Z | 07/16 08:00 | 988 | 2084 | 2020-07-16T12:00:00Z | 300801 | 25850 | 274951 | 17711 | 305294 | 177388 | 44 | 71 | 1442 | 177388 | totalTestEncountersViral | 4232 | 177388 | 1 | 9 | e6829978319f79f305af63a2c4d2ca0132632699 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
4079 | 4079 | 20200716 | TN | 71540 | 1052157 | 1123697 | 1416 | 3497 | 41250 | A | 7/16/2020 15:00 | 2020-07-16T15:00:00Z | 07/16 11:00 | 796 | 3497 | 2020-07-16T15:00:00Z | 1123038 | 83227 | 1039811 | 70881 | 767 | 29 | 47 | 2479 | 23545 | 1123697 | posNeg | 26024 | 1123697 | 13 | 63 | f89b507def19db317a9e85562697ff0e16c26cf2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4081 | 4081 | 20200716 | UT | 31845 | 407683 | 439528 | 236 | 1956 | 89 | 523 | 214 | 19214 | A+ | 7/16/2020 10:58 | 2020-07-16T10:58:00Z | 07/16 06:58 | 234 | 1956 | 2020-07-16T10:58:00Z | 516003 | 31845 | 439528 | 694 | 300 | 817 | 315 | 49 | 954 | 6494 | 439528 | posNeg | 7448 | 439528 | 1 | 43 | 83b7955fbbf0065a9fa628fcfa136371da5fa8d4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
4084 | 4084 | 20200716 | VT | 1325 | 77715 | 79040 | 25 | 1111 | B | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 56 | 2020-07-16T00:00:00Z | 1325 | 56 | 79040 | 50 | 7 | 675 | 79040 | posNeg | 682 | 79040 | 0 | 0 | c6051f601ae85f16d81087d000ce6426731a5535 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
4086 | 4086 | 20200716 | WI | 43139 | 699670 | 154 | 742809 | 308 | 3968 | 88 | 811 | 30555 | A+ | 7/16/2020 16:00 | 2020-07-16T16:00:00Z | 07/16 12:00 | 838 | 3968 | 2020-07-16T16:00:00Z | 39627 | 831 | 7 | 739297 | 55 | 942 | 13371 | 742963 | posNeg | 14313 | 742809 | 4 | 45 | aefdf029a0e8958c0d191a2c99a8072d4ba76e45 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4087 | 4087 | 20200716 | WV | 4657 | 214517 | 219174 | 65 | 29 | 13 | 3128 | B | 7/16/2020 10:00 | 2020-07-16T10:00:00Z | 07/16 06:00 | 99 | 2020-07-16T10:00:00Z | 219052 | 4535 | 12503 | 54 | 100 | 1170 | 219174 | posNeg | 1270 | 219174 | 2 | 0 | da3500c4b1b9705321798172772c54429f6654ff | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
4088 | 4088 | 20200716 | WY | 2026 | 41426 | 43452 | 18 | 131 | 1540 | B | 7/16/2020 17:23 | 2020-07-16T17:23:00Z | 07/16 13:23 | 24 | 131 | 2020-07-16T17:23:00Z | 60203 | 1745 | 58457 | 1644 | 43070 | 56 | 41 | 497 | 43452 | posNeg | 538 | 43452 | 2 | 0 | e18d3d4227efceddfe439ead089926a717c76046 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
4039 | 4039 | 20200716 | CO | 38155 | 378061 | 514742 | 389 | 5950 | 4880 | A | 7/16/2020 01:59 | 2020-07-16T01:59:00Z | 07/15 21:59 | 1601 | 5950 | 2020-07-16T01:59:00Z | 35126 | 514742 | 413187 | 121619 | 7961 | 113658 | 8 | 469 | 5757 | 416216 | totalTestEncountersViral | 8614 | 416216 | 7 | -13 | 071211fd21170ad2762857c60559eaef5254d872 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4021 | 4021 | 20200717 | SC | 66060 | 487315 | 553375 | 1593 | 4182 | 23849 | A | 7/16/2020 23:59 | 2020-07-16T23:59:00Z | 07/16 19:59 | 1096 | 4182 | 2020-07-16T23:59:00Z | 553172 | 82636 | 470536 | 65857 | 1078 | 18 | 46882 | 2358 | 44524 | 45 | 1977 | 11434 | 553375 | posNeg | 13411 | 553375 | 26 | 438 | df02840b16793687b2ecebda7dadaa9de78f8898 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
4064 | 4064 | 20200716 | ND | 4662 | 123388 | 236849 | 38 | 285 | 3796 | D | 7/16/2020 00:00 | 2020-07-16T00:00:00Z | 07/15 20:00 | 82 | 285 | 2020-07-16T00:00:00Z | 242783 | 4662 | 78 | 4 | 236849 | 125515 | 6109 | 217 | 5892 | 38 | 103 | 1389 | 128050 | totalTestEncountersViral | 3971 | 128050 | 1 | 1 | 0eaa51221352f21e631184c18e8bb211b23d84b4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
4000 | 4000 | 20200717 | ME | 3636 | 129809 | 133445 | 12 | 375 | 11 | 5 | 3114 | A+ | 7/16/2020 23:59 | 2020-07-16T23:59:00Z | 07/16 19:59 | 115 | 375 | 2020-07-16T23:59:00Z | 133048 | 4491 | 128380 | 3239 | 114 | 1 | 8346 | 377 | 7960 | 23 | 38 | 2945 | 133445 | posNeg | 2983 | 133445 | 1 | 1 | 05c9db4500efeb9b75fb78b7b7f3286bc2de9fd8 | 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 );