states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
68 rows where "dateModified" is on date 2020-06-26 sorted by posNeg
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5091 | 5091 | 20200628 | VI | 81 | 2746 | 31 | 2827 | 71 | C | 6/26/2020 18:49 | 2020-06-26T18:49:00Z | 06/26 14:49 | 6 | 2020-06-26T18:49:00Z | 2858 | 6 | 78 | 0 | 0 | 2858 | posNeg | 0 | 2827 | 0 | 0 | ef01c91bc3d73764c7b32150b930dec309eb7b8a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
5147 | 5147 | 20200627 | VI | 81 | 2746 | 31 | 2827 | 71 | C | 6/26/2020 18:49 | 2020-06-26T18:49:00Z | 06/26 14:49 | 6 | 2020-06-26T18:49:00Z | 2858 | 6 | 78 | 0 | 41 | 2858 | posNeg | 41 | 2827 | 0 | 0 | 5f0e225f06c0ecbb03a7149d7ec8d366c66edb61 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
4844 | 4844 | 20200702 | MP | 30 | 8187 | 8217 | 19 | D | 6/26/2020 00:22 | 2020-06-26T00:22:00Z | 06/25 20:22 | 2 | 2020-06-26T00:22:00Z | 8217 | 30 | 69 | 0 | 0 | 8217 | posNeg | 0 | 8217 | 0 | 0 | 0a07278410cf979de943d245732003ea63522a04 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
4900 | 4900 | 20200701 | MP | 30 | 8187 | 8217 | 19 | D | 6/26/2020 00:22 | 2020-06-26T00:22:00Z | 06/25 20:22 | 2 | 2020-06-26T00:22:00Z | 8217 | 30 | 69 | 0 | 0 | 8217 | posNeg | 0 | 8217 | 0 | 0 | 08fd73a3ce6cf7200d6d24bb8e83a8958ae4e3ae | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
4956 | 4956 | 20200630 | MP | 30 | 8187 | 8217 | 19 | D | 6/26/2020 00:22 | 2020-06-26T00:22:00Z | 06/25 20:22 | 2 | 2020-06-26T00:22:00Z | 8217 | 30 | 69 | 0 | 0 | 8217 | posNeg | 0 | 8217 | 0 | 0 | 17861351a03e38f3e6050ca200dfa144a26fd83b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
5012 | 5012 | 20200629 | MP | 30 | 8187 | 8217 | 19 | D | 6/26/2020 00:22 | 2020-06-26T00:22:00Z | 06/25 20:22 | 2 | 2020-06-26T00:22:00Z | 8217 | 30 | 69 | 0 | 0 | 8217 | posNeg | 0 | 8217 | 0 | 0 | b63c1f4fda5e933df6e3642b0de6e8dd08e43774 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
5068 | 5068 | 20200628 | MP | 30 | 8187 | 8217 | 19 | D | 6/26/2020 00:22 | 2020-06-26T00:22:00Z | 06/25 20:22 | 2 | 2020-06-26T00:22:00Z | 8217 | 30 | 69 | 0 | 0 | 8217 | posNeg | 0 | 8217 | 0 | 0 | c55491cf5bebbfe7a708d9bf8f612d650dd2a2e7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
5124 | 5124 | 20200627 | MP | 30 | 8187 | 8217 | 19 | D | 6/26/2020 00:22 | 2020-06-26T00:22:00Z | 06/25 20:22 | 2 | 2020-06-26T00:22:00Z | 8217 | 30 | 69 | 0 | 0 | 8217 | posNeg | 0 | 8217 | 0 | 0 | 5ac610599ef6e3aed3a682e796e159edc2cf2af0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
5180 | 5180 | 20200626 | MP | 30 | 8187 | 8217 | 19 | D | 6/26/2020 00:22 | 2020-06-26T00:22:00Z | 06/25 20:22 | 2 | 2020-06-26T00:22:00Z | 8217 | 30 | 69 | 0 | 0 | 8217 | posNeg | 0 | 8217 | 0 | 0 | 8d8937576104284da7f8b37f25c1ece050b4d92c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
5165 | 5165 | 20200626 | GU | 248 | 11644 | 11892 | 1 | 179 | B | 6/26/2020 07:30 | 2020-06-26T07:30:00Z | 06/26 03:30 | 5 | 2020-06-26T07:30:00Z | 11523 | 239 | 11284 | 240 | 11884 | 125 | 2 | 66 | 3 | 471 | 11892 | posNeg | 474 | 11892 | 0 | 0 | f8dce8cf27d00a069e151409f3cb6472773859b1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
5208 | 5208 | 20200626 | WY | 1368 | 30406 | 31774 | 5 | 112 | 1033 | B | 6/26/2020 18:15 | 2020-06-26T18:15:00Z | 06/26 14:15 | 20 | 112 | 2020-06-26T18:15:00Z | 42402 | 1229 | 41172 | 1079 | 31485 | 56 | 42 | 1537 | 31774 | posNeg | 1579 | 31774 | 0 | 1 | 5d5131dedb3fc39e86de21209d2f312fcde3ac58 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
5204 | 5204 | 20200626 | VT | 1198 | 60391 | 61589 | 14 | 941 | B | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 56 | 2020-06-26T00:00:00Z | 1198 | 56 | 61589 | 50 | 7 | 873 | 61589 | posNeg | 880 | 61589 | 0 | 0 | 467ba449ee84a2a073c7497c465aae8df4ac2ca5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
5110 | 5110 | 20200627 | HI | 866 | 73435 | 74301 | 109 | 705 | D | 6/26/2020 18:00 | 2020-06-26T18:00:00Z | 06/26 14:00 | 17 | 109 | 2020-06-26T18:00:00Z | 86464 | 74301 | 15 | 16 | 1280 | 74301 | posNeg | 1296 | 74301 | 0 | 0 | ce24cb8fe808defb94ba9aa4b6cc0da064f2e671 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
5142 | 5142 | 20200627 | SD | 6626 | 71474 | 78100 | 73 | 645 | 5717 | B | 6/26/2020 18:00 | 2020-06-26T18:00:00Z | 06/26 14:00 | 91 | 645 | 2020-06-26T18:00:00Z | 78100 | 46 | 91 | 994 | 78100 | posNeg | 1085 | 78100 | 3 | 6 | a2711cadb315b8e846ac7378022e66c014b289ff | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
5182 | 5182 | 20200626 | MT | 829 | 79332 | 80161 | 14 | 95 | 589 | C | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 22 | 95 | 2020-06-26T00:00:00Z | 80161 | 829 | 30 | 26 | 1803 | 80161 | posNeg | 1829 | 80161 | 1 | 2 | 9ad6b216dd301792a5edd8a14829d8a206a3460d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5112 | 5112 | 20200627 | ID | 5148 | 78908 | 83537 | 42 | 309 | 19 | 108 | 3827 | A | 6/26/2020 19:00 | 2020-06-26T19:00:00Z | 06/26 15:00 | 90 | 309 | 2020-06-26T19:00:00Z | 83537 | 4629 | 70 | 20 | 16 | 283 | 1403 | 84056 | posNeg | 1666 | 84056 | 0 | 6 | 817a1ad1f9078860210c482071dcb5abe0a4f3e8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5105 | 5105 | 20200627 | DC | 10216 | 79055 | 89271 | 136 | 43 | 26 | 1194 | A+ | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 548 | 2020-06-26T00:00:00Z | 89271 | 69699 | 11 | 31 | 1117 | 89271 | posNeg | 1148 | 89271 | 2 | 0 | 27627b871fec96871754c72dc64f75a062eebbf3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5120 | 5120 | 20200627 | ME | 3154 | 88778 | 91932 | 24 | 345 | 7 | 5 | 2566 | A | 6/26/2020 23:59 | 2020-06-26T23:59:00Z | 06/26 19:59 | 104 | 345 | 2020-06-26T23:59:00Z | 91587 | 3848 | 87604 | 2809 | 103 | 1 | 7271 | 320 | 6943 | 23 | 52 | 2026 | 91932 | posNeg | 2078 | 91932 | 1 | 2 | b974e773151234067c3b7ac8a38c078c8b435b06 | 0 | 0 | 0 | 0 | 0 | |||||||||||||
5184 | 5184 | 20200626 | ND | 3418 | 97465 | 166289 | 23 | 222 | 3090 | D | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 77 | 222 | 2020-06-26T00:00:00Z | 169814 | 3418 | 68 | 9 | 166289 | 98527 | 4819 | 182 | 4637 | 38 | 28 | 1414 | 100883 | totalTestEncountersViral | 4343 | 100883 | 1 | 0 | a4b4914580a0fd21b0b19bc6cbfdd40cf631a8c1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
5153 | 5153 | 20200626 | AK | 836 | 100956 | 101792 | 12 | 2 | 519 | A | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 14 | 2020-06-26T00:00:00Z | 101792 | 836 | 14 | 2 | 20 | 2320 | 101792 | posNeg | 2340 | 101792 | 2 | 0 | f9aae215d32d4dcfb343e6bf7dba18d5bf2d06f4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5130 | 5130 | 20200627 | NH | 5671 | 109097 | 144924 | 32 | 561 | 161 | 4381 | B | 6/26/2020 09:00 | 2020-06-26T09:00:00Z | 06/26 05:00 | 365 | 561 | 2020-06-26T09:00:00Z | 144924 | 5671 | 114768 | 21336 | 18518 | 33 | 0 | 0 | 114768 | posNeg | 2979 | 114768 | 0 | 0 | 3760b11801a0e803ab4aeb7e329ee3f79ca6690c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5186 | 5186 | 20200626 | NH | 5671 | 109097 | 141945 | 32 | 561 | 161 | 4381 | B | 6/26/2020 09:00 | 2020-06-26T09:00:00Z | 06/26 05:00 | 365 | 561 | 2020-06-26T09:00:00Z | 141945 | 5671 | 114768 | 21049 | 18518 | 33 | 73 | 3129 | 114768 | posNeg | 2509 | 114768 | 18 | 3 | 49b5ce6e57dba9a66f0f392b6bb1622d8a1848c9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5195 | 5195 | 20200626 | PR | 6922 | 113280 | 120202 | 89 | 9 | 7 | C | 6/26/2020 06:30 | 2020-06-26T06:30:00Z | 06/26 02:30 | 151 | 2020-06-26T06:30:00Z | 114723 | 2326 | 112331 | 1583 | 57 | 94 | 5339 | 72 | 45 | 0 | 120202 | posNeg | 45 | 120202 | 0 | 0 | fa175ef6f0f528e9d8a2ced44e14e1516247dce8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5196 | 5196 | 20200626 | RI | 16777 | 133102 | 244091 | 91 | 1984 | 16 | 15 | 1600 | A+ | 6/26/2020 03:00 | 2020-06-26T03:00:00Z | 06/25 23:00 | 927 | 1984 | 2020-06-26T03:00:00Z | 241245 | 23877 | 217368 | 16777 | 244091 | 149879 | 44 | 69 | 1314 | 149879 | totalTestEncountersViral | 2971 | 149879 | 7 | 3 | 25a95ac494b7721f28899d01bcb7e836904d9a1d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
5207 | 5207 | 20200626 | WV | 2712 | 159245 | 161957 | 33 | 10 | 4 | 1907 | B | 6/26/2020 10:00 | 2020-06-26T10:00:00Z | 06/26 06:00 | 92 | 2020-06-26T10:00:00Z | 161867 | 2622 | 9210 | 54 | 51 | 3202 | 161957 | posNeg | 3253 | 161957 | 0 | 0 | 6bff00b7d67ac424b2ad504245c4e6632fe36af7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
5059 | 5059 | 20200628 | KS | 13538 | 154321 | 167859 | 1128 | 356 | 152 | 779 | A | 6/26/2020 10:00 | 2020-06-26T10:00:00Z | 06/26 06:00 | 264 | 1128 | 2020-06-26T10:00:00Z | 167548 | 20 | 0 | 0 | 167859 | posNeg | 0 | 167859 | 0 | 0 | 6e4f077357586c7efea8851e8c642604cce2a78b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5115 | 5115 | 20200627 | KS | 13538 | 154321 | 167859 | 1128 | 356 | 152 | 779 | A | 6/26/2020 10:00 | 2020-06-26T10:00:00Z | 06/26 06:00 | 264 | 1128 | 2020-06-26T10:00:00Z | 167548 | 20 | 0 | 0 | 167859 | posNeg | 0 | 167859 | 0 | 0 | ccc29de8c9e355a40021ac697b1f8ed4679b7dcc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5171 | 5171 | 20200626 | KS | 13538 | 154321 | 167859 | 1128 | 356 | 152 | 779 | A | 6/26/2020 10:00 | 2020-06-26T10:00:00Z | 06/26 06:00 | 264 | 1128 | 2020-06-26T10:00:00Z | 167548 | 20 | 568 | 5586 | 167859 | posNeg | 6154 | 167859 | 3 | 46 | 9eb303e6bb6bc1e835aa00d8bcc280205bde5e49 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5129 | 5129 | 20200627 | NE | 18524 | 150074 | 168598 | 125 | 1312 | 12698 | B | 6/26/2020 20:05 | 2020-06-26T20:05:00Z | 06/26 16:05 | 266 | 1312 | 2020-06-26T20:05:00Z | 18524 | 168800 | 31 | 178 | 3418 | 168598 | posNeg | 3596 | 168598 | 6 | 18 | 3fb8f7a1e5c5fb87f513745c323a90fbf718e2d5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5189 | 5189 | 20200626 | NV | 15860 | 243422 | 259282 | 471 | 118 | 59 | 684 | A+ | 6/26/2020 11:40 | 2020-06-26T11:40:00Z | 06/26 07:40 | 498 | 2020-06-26T11:40:00Z | 297635 | 15860 | 257931 | 32 | 381 | 2731 | 259282 | posNeg | 3112 | 259282 | 3 | 0 | 75cfaa9bd7961aaf1a9295d7b46022724d03ae1d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
5125 | 5125 | 20200627 | MS | 25531 | 251790 | 277321 | 731 | 3078 | 169 | 90 | 17242 | A | 6/26/2020 19:00 | 2020-06-26T19:00:00Z | 06/26 15:00 | 1035 | 3078 | 2020-06-26T19:00:00Z | 277158 | 25368 | 1018 | 17 | 11652 | 95 | 28 | 465 | 4962 | 277321 | posNeg | 5427 | 277321 | 13 | 34 | df9dd7746cc5666603ced95f33fd67f6178c88de | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
5155 | 5155 | 20200626 | AR | 18062 | 259318 | 277380 | 284 | 1300 | 61 | 203 | 12127 | A | 6/26/2020 14:40 | 2020-06-26T14:40:00Z | 06/26 10:40 | 240 | 1300 | 2020-06-26T14:40:00Z | 277380 | 18740 | 5 | 0 | 0 | 277380 | posNeg | 0 | 277380 | 0 | 55 | b93896a2c378b017acbf65f128b663522f91d931 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5167 | 5167 | 20200626 | IA | 27686 | 255957 | 283643 | 141 | 42 | 24 | 17313 | A+ | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 704 | 2020-06-26T00:00:00Z | 27686 | 284046 | 31185 | 2255 | 28898 | 19 | 489 | 6100 | 283643 | posNeg | 6589 | 283643 | 9 | 0 | ce86a3ceca48dec967a6fd90e8a8ef3d00118d6d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
5099 | 5099 | 20200627 | AR | 18740 | 265225 | 283965 | 284 | 1337 | 63 | 206 | 12784 | A | 6/26/2020 14:40 | 2020-06-26T14:40:00Z | 06/26 10:40 | 249 | 1337 | 2020-06-26T14:40:00Z | 283965 | 18740 | 5 | 678 | 5907 | 283965 | posNeg | 6585 | 283965 | 9 | 37 | 88c18ffd82f84902ac72d14b043c44631e125aba | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5103 | 5103 | 20200627 | CO | 31796 | 275787 | 367175 | 226 | 5392 | 4430 | A | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 1482 | 5392 | 2020-06-26T00:00:00Z | 28972 | 367175 | 304759 | 102493 | 6800 | 95693 | 8 | 317 | 4689 | 307583 | totalTestEncountersViral | 7238 | 307583 | 7 | 6 | 62b201e6bf77dcf20a227d2ee815a8dbc7a64914 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5192 | 5192 | 20200626 | OK | 12343 | 298434 | 310777 | 308 | 1393 | 126 | 8817 | A+ | 6/26/2020 08:00 | 2020-06-26T08:00:00Z | 06/26 04:00 | 377 | 1393 | 2020-06-26T08:00:00Z | 312454 | 13338 | 298434 | 12343 | 30021 | 1058 | 40 | 395 | 5417 | 310777 | posNeg | 5812 | 310777 | 2 | 57 | a617141a80aa4cdeb3eed0d2e617b02c06da75e3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
5201 | 5201 | 20200626 | UT | 20050 | 297518 | 317568 | 238 | 1321 | 80 | 375 | 161 | 11097 | A+ | 6/26/2020 10:23 | 2020-06-26T10:23:00Z | 06/26 06:23 | 166 | 1321 | 2020-06-26T10:23:00Z | 20050 | 317568 | 128 | 25 | 145 | 26 | 49 | 676 | 4838 | 317568 | posNeg | 5514 | 317568 | 2 | 31 | d65153b5c83cdb5805c81ddd2bebf2dc0a7686be | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
5132 | 5132 | 20200627 | NM | 11408 | 309230 | 320638 | 128 | 1828 | 5149 | B | 6/26/2020 17:50 | 2020-06-26T17:50:00Z | 06/26 13:50 | 489 | 1828 | 2020-06-26T17:50:00Z | 320638 | 11408 | 35 | 216 | 5752 | 320638 | posNeg | 5968 | 320638 | 4 | 17 | e68cc9ae129d2f179a4fe998737884529579f5e5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5197 | 5197 | 20200626 | SC | 30335 | 304336 | 334671 | 906 | 2622 | 13456 | A | 6/26/2020 16:43 | 2020-06-26T16:43:00Z | 06/26 12:43 | 694 | 2622 | 2020-06-26T16:43:00Z | 334198 | 37673 | 296525 | 30263 | 692 | 2 | 35242 | 1706 | 33536 | 45 | 1313 | 0 | 334671 | posNeg | 1313 | 334671 | 1 | 245 | eb0d1081e652fbbf1944490707c77234d78894f4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
5179 | 5179 | 20200626 | MO | 19914 | 328704 | 348618 | 600 | 66 | B | 6/26/2020 15:00 | 2020-06-26T15:00:00Z | 06/26 11:00 | 990 | 2020-06-26T15:00:00Z | 424214 | 23527 | 399926 | 19914 | 348618 | 40812 | 1497 | 39315 | 29 | 493 | 6477 | 348618 | posNeg | 6970 | 348618 | 8 | 0 | 345a7821d09212c000752039f6e1335467eb7bac | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5116 | 5116 | 20200627 | KY | 14859 | 335895 | 350296 | 387 | 2589 | 74 | 996 | 3730 | B | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 553 | 2589 | 2020-06-26T00:00:00Z | 350296 | 14401 | 550 | 3 | 33340 | 21 | 0 | 0 | 350754 | posNeg | 0 | 350754 | 0 | 0 | 8db0fbeab8d06f6e059a7061f7983e89142fb001 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
5172 | 5172 | 20200626 | KY | 14859 | 335895 | 350296 | 387 | 2589 | 74 | 996 | 3730 | B | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 553 | 2589 | 2020-06-26T00:00:00Z | 350296 | 14401 | 550 | 3 | 33340 | 21 | 242 | 7630 | 350754 | posNeg | 7849 | 350754 | 7 | 5 | 057b3908796f731a4ee889ee16b72bd5e4578cce | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
5141 | 5141 | 20200627 | SC | 31939 | 319225 | 351164 | 908 | 2622 | 13456 | A | 6/26/2020 23:59 | 2020-06-26T23:59:00Z | 06/26 19:59 | 711 | 2622 | 2020-06-26T23:59:00Z | 351075 | 40970 | 310105 | 31850 | 707 | 4 | 36533 | 1734 | 34799 | 45 | 1604 | 14889 | 351164 | posNeg | 16493 | 351164 | 17 | 0 | c5e00fd248b5de47b710c13a849738b9d65a0bd7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
5154 | 5154 | 20200626 | AL | 34183 | 344140 | 377857 | 668 | 2653 | 772 | 450 | 18866 | B | 6/26/2020 11:00 | 2020-06-26T11:00:00Z | 06/26 07:00 | 907 | 2653 | 2020-06-26T11:00:00Z | 377857 | 33717 | 887 | 20 | 1 | 977 | 7888 | 378323 | posNeg | 8852 | 378323 | 11 | 41 | a49fcfbc1e1d3f7c20cb72c0126a2e7674e6ce0a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5104 | 5104 | 20200627 | CT | 46206 | 392824 | 439030 | 106 | 10268 | 8053 | B | 6/26/2020 20:30 | 2020-06-26T20:30:00Z | 06/26 16:30 | 4311 | 10268 | 2020-06-26T20:30:00Z | 436644 | 43820 | 3443 | 868 | 9 | 147 | 9059 | 439030 | posNeg | 9206 | 439030 | 4 | 0 | 797f23df2a17ea636c642fb5326b8a309d203728 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5114 | 5114 | 20200627 | IN | 44575 | 418442 | 463017 | 595 | 6982 | 257 | 1461 | 82 | 33725 | A+ | 6/26/2020 23:59 | 2020-06-26T23:59:00Z | 06/26 19:59 | 2616 | 6982 | 2020-06-26T23:59:00Z | 2424 | 192 | 463017 | 18 | 435 | 8692 | 463017 | posNeg | 9127 | 463017 | 21 | 38 | 1c647a4fdafeebb07a1f7f8a0db3573b9a2b4f45 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5157 | 5157 | 20200626 | AZ | 66548 | 413275 | 479330 | 2110 | 4514 | 581 | 312 | 8389 | A+ | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 1535 | 4514 | 2020-06-26T00:00:00Z | 66055 | 1435 | 100 | 479330 | 157620 | 4 | 3518 | 12109 | 479823 | posNeg | 15530 | 479823 | 45 | 108 | 51d30879d51895bcf10bf1262b323ad25140e55f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
5175 | 5175 | 20200626 | MD | 66115 | 440282 | 506397 | 487 | 10725 | 190 | 4903 | A | 6/26/2020 10:00 | 2020-06-26T10:00:00Z | 06/26 06:00 | 3142 | 10725 | 2020-06-26T10:00:00Z | 607823 | 76821 | 66115 | 3015 | 127 | 506397 | 24 | 338 | 7100 | 506397 | posNeg | 7438 | 506397 | 13 | 42 | c25abff09c54853b1ff927d8084dc20faf2e71db | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
5206 | 5206 | 20200626 | WI | 29668 | 507168 | 142 | 536836 | 262 | 3351 | 95 | 741 | 21174 | A+ | 6/26/2020 16:00 | 2020-06-26T16:00:00Z | 06/26 12:00 | 766 | 3351 | 2020-06-26T16:00:00Z | 26747 | 766 | 533915 | 55 | 563 | 8607 | 536978 | posNeg | 9170 | 536836 | 0 | 25 | ce07f3797a0dd9fd991e53a537e8b6ced725a00e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5122 | 5122 | 20200627 | MN | 35033 | 533874 | 568907 | 300 | 3986 | 155 | 1233 | 30401 | A | 6/26/2020 17:00 | 2020-06-26T17:00:00Z | 06/26 13:00 | 1452 | 3986 | 2020-06-26T17:00:00Z | 35033 | 1417 | 35 | 568907 | 27 | 417 | 11212 | 568907 | posNeg | 11629 | 568907 | 6 | 20 | e08eca02d9a5402a39591e4522f44666836053d5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5146 | 5146 | 20200627 | VA | 61247 | 556679 | 284 | 626022 | 819 | 8787 | 234 | 103 | 7968 | A+ | 6/26/2020 17:00 | 2020-06-26T17:00:00Z | 06/26 13:00 | 1724 | 8787 | 2020-06-26T17:00:00Z | 72567 | 58611 | 1620 | 104 | 626022 | 51 | 677 | 10786 | 618210 | posNeg | 10518 | 617926 | 24 | 65 | 7a6887b78c5bc87d6773cfd8d9f2cf86a880027c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
5149 | 5149 | 20200627 | WA | 34292 | 605293 | 639585 | 305 | 4194 | 50 | B | 6/26/2020 02:59 | 2020-06-26T02:59:00Z | 06/25 22:59 | 1304 | 4194 | 2020-06-26T02:59:00Z | 34292 | 1304 | 639585 | 514428 | 53 | 489 | 8189 | 639585 | posNeg | 8678 | 639585 | 4 | 88 | db432e547944bdf9b0c30689dcb5e48f721d6302 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5117 | 5117 | 20200627 | LA | 54769 | 623237 | 678006 | 700 | 73 | 39792 | B | 6/26/2020 13:00 | 2020-06-26T13:00:00Z | 06/26 09:00 | 3190 | 2020-06-26T13:00:00Z | 54769 | 3077 | 113 | 678006 | 22 | 0 | 0 | 678006 | posNeg | 0 | 678006 | 0 | 0 | 0e0bfc71ddfe238ab858fd1c349cdc8c787b56eb | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
5173 | 5173 | 20200626 | LA | 54769 | 623237 | 678006 | 700 | 73 | 39792 | B | 6/26/2020 13:00 | 2020-06-26T13:00:00Z | 06/26 09:00 | 3190 | 2020-06-26T13:00:00Z | 54769 | 3077 | 113 | 678006 | 22 | 1354 | 15987 | 678006 | posNeg | 17341 | 678006 | 26 | 0 | b9bd96080eadce9cc670bb55730093ea9c39e7e1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
5138 | 5138 | 20200627 | PA | 84370 | 634711 | 719081 | 651 | 126 | 65808 | A+ | 6/26/2020 12:00 | 2020-06-26T12:00:00Z | 06/26 08:00 | 6579 | 2020-06-26T12:00:00Z | 81956 | 716667 | 42 | 0 | 0 | 719081 | posNeg | 0 | 719081 | 0 | 0 | 660d99daa9716a16a72e7768d6ffd6eb07689d57 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
5194 | 5194 | 20200626 | PA | 84370 | 634711 | 719081 | 661 | 131 | 65808 | A+ | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 6579 | 2020-06-26T00:00:00Z | 81956 | 716667 | 42 | 600 | 13680 | 719081 | posNeg | 14280 | 719081 | 22 | 0 | e876dc342d763d0463473521aca42c6ecd5d0034 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
5191 | 5191 | 20200626 | OH | 48638 | 672914 | 721552 | 624 | 7570 | 205 | 1904 | 116 | B | 6/26/2020 14:00 | 2020-06-26T14:00:00Z | 06/26 10:00 | 2788 | 7570 | 2020-06-26T14:00:00Z | 718086 | 45172 | 2545 | 243 | 39 | 987 | 20935 | 721552 | posNeg | 21922 | 721552 | 16 | 68 | 8b08c16a895e128148c49db5742969b517a13cd9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5199 | 5199 | 20200626 | TN | 39444 | 702588 | 742032 | 741 | 2498 | 25753 | B | 6/26/2020 15:00 | 2020-06-26T15:00:00Z | 06/26 11:00 | 577 | 2498 | 2020-06-26T15:00:00Z | 741737 | 45734 | 696003 | 39149 | 552 | 25 | 47 | 1410 | 13073 | 742032 | posNeg | 14483 | 742032 | 10 | 67 | 14d802dc7775a3df2d7833b293b364ee1de0fc2b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5164 | 5164 | 20200626 | GA | 72995 | 698033 | 771028 | 1184 | 10605 | 2244 | A | 6/26/2020 14:50 | 2020-06-26T14:50:00Z | 06/26 10:50 | 2770 | 10605 | 2020-06-26T14:50:00Z | 771028 | 66510 | 704518 | 72995 | 149086 | 8275 | 13 | 1900 | 11204 | 771028 | posNeg | 13104 | 771028 | 25 | 148 | 56be45fa757631593309873c0ea3de264a849c9a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5174 | 5174 | 20200626 | MA | 108070 | 706015 | 1057242 | 791 | 11291 | 156 | 99 | 93157 | A+ | 6/26/2020 10:00 | 2020-06-26T10:00:00Z | 06/26 06:00 | 8013 | 11291 | 2020-06-26T10:00:00Z | 1057242 | 136627 | 103071 | 7815 | 198 | 809086 | 68259 | 25 | 233 | 8396 | 814085 | totalTestsViral | 13231 | 814085 | 50 | 39 | 94b214a2492fbe51ab346aa690ec05c40756ad05 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
5183 | 5183 | 20200626 | NC | 58818 | 777907 | 836725 | 892 | 36921 | A | 6/26/2020 11:55 | 2020-06-26T11:55:00Z | 06/26 07:55 | 1303 | 2020-06-26T11:55:00Z | 836725 | 58818 | 1303 | 37 | 1635 | 23812 | 836725 | posNeg | 25447 | 836725 | 19 | 0 | 0450b618b553a0627304466a405d4e0d1be8e85c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
5177 | 5177 | 20200626 | MI | 69329 | 912377 | 981706 | 557 | 193 | 106 | 49290 | A+ | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 6134 | 2020-06-26T00:00:00Z | 998490 | 86113 | 912377 | 62695 | 5888 | 246 | 151973 | 26 | 340 | 18527 | 981706 | posNeg | 18867 | 981706 | 1 | 0 | b2606652b86415f55d56ab7427726970f5209e6f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
5187 | 5187 | 20200626 | NJ | 170584 | 1176088 | 1346672 | 1118 | 19752 | 234 | 206 | 29855 | A+ | 6/26/2020 13:00 | 2020-06-26T13:00:00Z | 06/26 09:00 | 14828 | 19752 | 2020-06-26T13:00:00Z | 1346672 | 170584 | 13060 | 1768 | 34 | 388 | 25374 | 1346672 | posNeg | 25762 | 1346672 | 43 | 84 | 15beb9fc2355695cb75d2ce91d2befa1792219dd | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5169 | 5169 | 20200626 | IL | 141344 | 1350661 | 1492005 | 1516 | 400 | 225 | A | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 7048 | 2020-06-26T00:00:00Z | 1490952 | 140291 | 6847 | 201 | 17 | 910 | 29568 | 1492005 | posNeg | 30478 | 1492005 | 34 | 0 | 178c43fde7777c708930605d0e646bc5896da9fc | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
5200 | 5200 | 20200626 | TX | 137624 | 1559710 | 1697334 | 5102 | 76282 | B | 6/26/2020 16:50 | 2020-06-26T16:50:00Z | 06/26 12:50 | 2324 | 2020-06-26T16:50:00Z | 1697334 | 137624 | 177863 | 6871 | 48 | 5707 | 32287 | 1697334 | posNeg | 37994 | 1697334 | 28 | 0 | 6204d246b4c7c476bf4c90cdfc4c0e043526ca9c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5107 | 5107 | 20200627 | FL | 132545 | 1696980 | 1731 | 1829525 | 14432 | A | 6/26/2020 23:59 | 2020-06-26T23:59:00Z | 06/26 19:59 | 3489 | 14432 | 2020-06-26T23:59:00Z | 2186400 | 171768 | 2010839 | 132545 | 3489 | 1830791 | 236304 | 9575 | 226699 | 12 | 9585 | 51055 | 1831256 | posNeg | 60640 | 1829525 | 25 | 151 | bbbe3d48b429da7062b04d349636c955e2233f34 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
5134 | 5134 | 20200627 | NY | 391923 | 3362656 | 3754579 | 908 | 89995 | 230 | 167 | 70010 | A | 6/26/2020 23:59 | 2020-06-26T23:59:00Z | 06/26 19:59 | 24830 | 89995 | 2020-06-26T23:59:00Z | 391923 | 3754579 | 36 | 703 | 72559 | 3754579 | posNeg | 73262 | 3754579 | 16 | 0 | 4ce45bd582f26b538d170dc4e79be5e514c07300 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5158 | 5158 | 20200626 | CA | 200461 | 3570853 | 3771314 | 5639 | 1570 | B | 6/26/2020 00:00 | 2020-06-26T00:00:00Z | 06/25 20:00 | 5812 | 2020-06-26T00:00:00Z | 3771314 | 200461 | 6 | 4890 | 72079 | 3771314 | posNeg | 76969 | 3771314 | 79 | 0 | 741843aadf42442c6f79812551c6d732b0c4a08d | 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 );