states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
66 rows where "dateModified" is on date 2020-08-17 sorted by negativeIncrease
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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2212 | 2212 | 20200818 | MP | 54 | 12866 | 12920 | 4 | 29 | D | 8/17/2020 19:35 | 2020-08-17T19:35:00Z | 08/17 15:35 | 2 | 4 | 2020-08-17T19:35:00Z | 16453 | 54 | 12920 | 69 | 1 | -1 | 12920 | posNeg | 0 | 12920 | 0 | 0 | a63741bea14a2c854485327bedad895bef6d14bb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
1764 | 1764 | 20200826 | MP | 54 | 12867 | 12921 | 4 | 29 | D | 8/17/2020 19:35 | 2020-08-17T19:35:00Z | 08/17 15:35 | 2 | 4 | 2020-08-17T19:35:00Z | 16453 | 54 | 2 | 12920 | 69 | 0 | 0 | 12921 | posNeg | 0 | 12921 | 0 | 0 | 0bf683fc6f56b4f97f9ae354bf75743a9a8319fa | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
1820 | 1820 | 20200825 | MP | 54 | 12867 | 12921 | 4 | 29 | D | 8/17/2020 19:35 | 2020-08-17T19:35:00Z | 08/17 15:35 | 2 | 4 | 2020-08-17T19:35:00Z | 16453 | 54 | 2 | 12920 | 69 | 0 | 0 | 12921 | posNeg | 0 | 12921 | 0 | 0 | ed246f0f20ccdce0111fb372bcfeae07550195a8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
1876 | 1876 | 20200824 | MP | 54 | 12867 | 12921 | 4 | 29 | D | 8/17/2020 19:35 | 2020-08-17T19:35:00Z | 08/17 15:35 | 2 | 4 | 2020-08-17T19:35:00Z | 16453 | 54 | 2 | 12920 | 69 | 0 | 0 | 12921 | posNeg | 0 | 12921 | 0 | 0 | 8ddda8a06e3cf9b36b6724bdb97f35971d13f7be | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
1932 | 1932 | 20200823 | MP | 54 | 12867 | 12921 | 4 | 29 | D | 8/17/2020 19:35 | 2020-08-17T19:35:00Z | 08/17 15:35 | 2 | 4 | 2020-08-17T19:35:00Z | 16453 | 54 | 2 | 12920 | 69 | 0 | 0 | 12921 | posNeg | 0 | 12921 | 0 | 0 | b5fefa2da2987cc3665ab46349aa00b74f5c7519 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
1988 | 1988 | 20200822 | MP | 54 | 12867 | 12921 | 4 | 29 | D | 8/17/2020 19:35 | 2020-08-17T19:35:00Z | 08/17 15:35 | 2 | 4 | 2020-08-17T19:35:00Z | 16453 | 54 | 2 | 12920 | 69 | 0 | 0 | 12921 | posNeg | 0 | 12921 | 0 | 0 | 821f9beeecb7d6c39079ca0da688becebb3bf69e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
2044 | 2044 | 20200821 | MP | 54 | 12867 | 12921 | 4 | 29 | D | 8/17/2020 19:35 | 2020-08-17T19:35:00Z | 08/17 15:35 | 2 | 4 | 2020-08-17T19:35:00Z | 16453 | 54 | 2 | 12920 | 69 | 0 | 0 | 12921 | posNeg | 0 | 12921 | 0 | 0 | 3edfec6d35750f0d2ee8d31d829606dab1dd0e1b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
2156 | 2156 | 20200819 | MP | 54 | 12866 | 12920 | 4 | 29 | D | 8/17/2020 19:35 | 2020-08-17T19:35:00Z | 08/17 15:35 | 2 | 4 | 2020-08-17T19:35:00Z | 16453 | 54 | 2 | 12920 | 69 | 0 | 0 | 12920 | posNeg | 0 | 12920 | 0 | 0 | 6a24ee889d9d9d0b7758a111995fa1eff8b893f1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
2203 | 2203 | 20200818 | KS | 35167 | 319095 | 354262 | 229 | 2034 | 62 | 560 | 24 | 200 | 1409 | A+ | 8/17/2020 10:00 | 2020-08-17T10:00:00Z | 08/17 06:00 | 405 | 2034 | 2020-08-17T10:00:00Z | 354262 | 20 | 0 | 0 | 354262 | posNeg | 0 | 354262 | 0 | 0 | c271d074611aa55e2bbfbb43fbabf4ea4867a319 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
2213 | 2213 | 20200818 | MS | 73207 | 452177 | 525384 | 1090 | 5025 | 284 | 163 | 56577 | A+ | 8/17/2020 19:00 | 2020-08-17T19:00:00Z | 08/17 15:00 | 2128 | 5025 | 2020-08-17T19:00:00Z | 522738 | 71254 | 2046 | 82 | 18516 | 95 | 28 | 795 | 0 | 525384 | posNeg | 795 | 525384 | 33 | 36 | 37ddf3d26cec733a111898825873585298f28816 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
2243 | 2243 | 20200817 | AR | 53077 | 569385 | 622050 | 486 | 3621 | 120 | 472 | 46133 | A | 8/17/2020 15:43 | 2020-08-17T15:43:00Z | 08/17 11:43 | 603 | 3621 | 2020-08-17T15:43:00Z | 622050 | 569385 | 53077 | 7090 | 1085 | 5 | 412 | 0 | 622462 | posNeg | 0 | 622462 | 4 | 51 | 2e3e00c631848358279934b3d13ef8c89d24bc5e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2280 | 2280 | 20200817 | OK | 48711 | 706619 | 755330 | 506 | 4021 | 236 | 40531 | A+ | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 665 | 4021 | 2020-08-17T00:00:00Z | 762899 | 54870 | 706619 | 48711 | 65475 | 2649 | 40 | 369 | 0 | 755330 | posNeg | 369 | 755330 | 4 | 8 | d83f3e08727d44517562d448f9f32c71320833f2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2283 | 2283 | 20200817 | PR | 26760 | 305972 | 332732 | 400 | 55 | 44 | B | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 335 | 2020-08-17T00:00:00Z | 310546 | 7002 | 303412 | 11723 | 206 | 129 | 15037 | 72 | 754 | 0 | 332732 | posNeg | 754 | 332732 | 0 | 0 | b0b990eccf513f386632102872fa035ed3491123 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2100 | 2100 | 20200820 | MP | 54 | 12867 | 12921 | 4 | 29 | D | 8/17/2020 19:35 | 2020-08-17T19:35:00Z | 08/17 15:35 | 2 | 4 | 2020-08-17T19:35:00Z | 16453 | 54 | 2 | 12920 | 69 | 0 | 1 | 12921 | posNeg | 1 | 12921 | 0 | 0 | 8e06fa27b11574d06b3200cffd77705b51cc91d0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
2291 | 2291 | 20200817 | VI | 760 | 11658 | 11 | 12418 | 525 | C | 8/17/2020 07:14 | 2020-08-17T07:14:00Z | 08/17 03:14 | 9 | 2020-08-17T07:14:00Z | 12429 | 9 | 78 | 19 | 228 | 12429 | posNeg | 247 | 12418 | 0 | 0 | baa2458078570b88f6180b1c65da1bdaacecced1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
2197 | 2197 | 20200818 | GU | 577 | 28649 | 29226 | 14 | 4 | 353 | A | 8/17/2020 23:40 | 2020-08-17T23:40:00Z | 08/17 19:40 | 5 | 2020-08-17T23:40:00Z | 29216 | 569 | 29218 | 155 | 2 | 66 | 19 | 434 | 29226 | posNeg | 453 | 29226 | 0 | 0 | 425343df51cd1c6d339405e0f90c91755326ee9c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
2272 | 2272 | 20200817 | ND | 8641 | 171772 | 387834 | 55 | 461 | 7343 | C | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 105 | 461 | 2020-08-17T00:00:00Z | 400035 | 8641 | 101 | 4 | 387834 | 178013 | 8027 | 293 | 7734 | 38 | 59 | 559 | 180413 | totalTestEncountersViral | 2603 | 180413 | 0 | 2 | 9b795f2e2b4e8c8ded28b287fbbcb0e3b892e104 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
2268 | 2268 | 20200817 | MP | 53 | 12867 | 12920 | 4 | 29 | D | 8/17/2020 04:04 | 2020-08-17T04:04:00Z | 08/17 00:04 | 2 | 4 | 2020-08-17T04:04:00Z | 16453 | 53 | 12920 | 69 | 3 | 615 | 12920 | posNeg | 618 | 12920 | 0 | 0 | bc6c175e5cb73add0628a192468ee34e6fd453bc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
2230 | 2230 | 20200818 | SD | 10443 | 119570 | 130013 | 68 | 927 | 9126 | A | 8/17/2020 14:00 | 2020-08-17T14:00:00Z | 08/17 10:00 | 154 | 927 | 2020-08-17T14:00:00Z | 166304 | 130013 | 46 | 83 | 637 | 130013 | posNeg | 720 | 130013 | 1 | 6 | 7bbfc7ec7bf332c0dfbbdedf69f7861474a2a2e3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
2284 | 2284 | 20200817 | RI | 20572 | 213250 | 431005 | 80 | 2380 | 11 | 3 | 1982 | A+ | 8/17/2020 12:00 | 2020-08-17T12:00:00Z | 08/17 08:00 | 1023 | 2380 | 2020-08-17T12:00:00Z | 29317 | 401688 | 20572 | 431005 | 233822 | 44 | 58 | 686 | 233822 | totalTestEncountersViral | 2028 | 233822 | 1 | 0 | 1425eae20f8c3bf389882f0a2925687a9465b244 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2296 | 2296 | 20200817 | WY | 3331 | 57567 | 60898 | 13 | 195 | 2699 | B | 8/17/2020 16:57 | 2020-08-17T16:57:00Z | 08/17 12:57 | 33 | 195 | 2020-08-17T16:57:00Z | 87365 | 2708 | 84656 | 2829 | 60396 | 56 | 45 | 758 | 60898 | posNeg | 803 | 60898 | 3 | 4 | 91495e13add9a2d613cff6046f0b2a13cb624999 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
2253 | 2253 | 20200817 | GU | 558 | 28215 | 28773 | 13 | 4 | 352 | A | 8/17/2020 01:30 | 2020-08-17T01:30:00Z | 08/16 21:30 | 5 | 2020-08-17T01:30:00Z | 28763 | 550 | 28765 | 155 | 2 | 66 | 42 | 958 | 28773 | posNeg | 1000 | 28773 | 0 | 0 | 3ab1fbd33a83f022c94e2f7d6de7085a1f73f79d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
2274 | 2274 | 20200817 | NH | 7004 | 178967 | 283133 | 15 | 709 | 218 | 6302 | B | 8/17/2020 09:00 | 2020-08-17T09:00:00Z | 08/17 05:00 | 423 | 709 | 2020-08-17T09:00:00Z | 283133 | 7004 | 185971 | 29241 | 28699 | 33 | 16 | 1026 | 185971 | posNeg | 2123 | 185971 | 0 | 1 | 58104d18e731a272b7b40d603ce10e467ec281e8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2194 | 2194 | 20200818 | DE | 16593 | 197252 | 213845 | 32 | 7 | 8749 | A+ | 8/17/2020 18:00 | 2020-08-17T18:00:00Z | 08/17 14:00 | 593 | 2020-08-17T18:00:00Z | 15589 | 524 | 69 | 213845 | 10 | 57 | 1150 | 213845 | posNeg | 1207 | 213845 | 0 | 0 | 9eb152cb93bc2b272c06ee6396e9bca28c485393 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
2208 | 2208 | 20200818 | ME | 4213 | 210113 | 214326 | 10 | 401 | 5 | 1 | 3649 | A+ | 8/17/2020 23:59 | 2020-08-17T23:59:00Z | 08/17 19:59 | 127 | 401 | 2020-08-17T23:59:00Z | 213894 | 5283 | 208383 | 3781 | 126 | 1 | 9268 | 456 | 8799 | 23 | 16 | 1756 | 214326 | posNeg | 1772 | 214326 | 0 | 2 | 1da898a5ba515243b9f625fa16a35c9b78c8c77c | 0 | 0 | 0 | 0 | 0 | |||||||||||||
2292 | 2292 | 20200817 | VT | 1527 | 111696 | 113223 | 18 | 1343 | B | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 58 | 2020-08-17T00:00:00Z | 1527 | 58 | 113223 | 50 | 12 | 1876 | 113223 | posNeg | 1888 | 113223 | 0 | 0 | e11b5aa58e4b52314e27f4e5386365e63e7e8ba2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
2198 | 2198 | 20200818 | HI | 5215 | 158984 | 164199 | 175 | 288 | 35 | 25 | 1868 | C | 8/17/2020 22:55 | 2020-08-17T22:55:00Z | 08/17 18:55 | 40 | 288 | 2020-08-17T22:55:00Z | 209529 | 164199 | 15 | 173 | 2078 | 164199 | posNeg | 2251 | 164199 | 0 | 5 | 30ee747c863156cbdb87e5a23f039bdd48dc3568 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
2200 | 2200 | 20200818 | ID | 27942 | 198927 | 225018 | 167 | 1129 | 37 | 316 | 11093 | A | 8/17/2020 19:00 | 2020-08-17T19:00:00Z | 08/17 15:00 | 273 | 1129 | 2020-08-17T19:00:00Z | 225018 | 26091 | 245 | 28 | 16 | 282 | 2100 | 226869 | posNeg | 2350 | 226869 | 4 | 19 | 74f63b17c1aa286abcc427415dd296f5d3e49f3b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2281 | 2281 | 20200817 | OR | 23451 | 467766 | 491217 | 206 | 1913 | 47 | 19 | 4419 | A+ | 8/17/2020 03:01 | 2020-08-17T03:01:00Z | 08/16 23:01 | 388 | 1913 | 2020-08-17T03:01:00Z | 467766 | 22234 | 490000 | 41 | 189 | 2231 | 491217 | posNeg | 2420 | 491217 | 0 | 50 | ac95f7f05a9ed3c77ace512080c809ced3f60d4b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
2217 | 2217 | 20200818 | NE | 30563 | 294924 | 325487 | 158 | 1883 | 22647 | A | 8/17/2020 20:20 | 2020-08-17T20:20:00Z | 08/17 16:20 | 362 | 1883 | 2020-08-17T20:20:00Z | 30563 | 325782 | 31 | 191 | 2305 | 325487 | posNeg | 2496 | 325487 | 1 | 0 | d76e527b75e502dbff10185edd4506067f2e1bd7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
2255 | 2255 | 20200817 | IA | 52722 | 501262 | 553984 | 283 | 85 | 33 | 40788 | A+ | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 981 | 2020-08-17T00:00:00Z | 52722 | 561762 | 44376 | 2919 | 41418 | 19 | 294 | 2497 | 553984 | posNeg | 2791 | 553984 | 6 | 0 | 0279503112bedc15a21c306ca69f8c9d2cb55fee | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
2270 | 2270 | 20200817 | MT | 5792 | 198933 | 204725 | 94 | 330 | 4162 | C | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 82 | 330 | 2020-08-17T00:00:00Z | 204725 | 5792 | 30 | 42 | 2759 | 204725 | posNeg | 2801 | 204725 | 0 | 4 | 1343b7d48fe878f4e6b9e796aab6ddbb40cf5cd1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
2210 | 2210 | 20200818 | MN | 66061 | 937245 | 1273397 | 304 | 5932 | 154 | 1722 | 59568 | A | 8/17/2020 17:00 | 2020-08-17T17:00:00Z | 08/17 13:00 | 1767 | 5932 | 2020-08-17T17:00:00Z | 66061 | 1721 | 46 | 1273397 | 1003306 | 27 | 345 | 2938 | 1003306 | posNeg | 6836 | 1003306 | 9 | 46 | 947b6cc75db77650849e6fad3d1f7e3e9b38f158 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2289 | 2289 | 20200817 | UT | 46894 | 554901 | 601795 | 156 | 2782 | 64 | 708 | 286 | 38132 | A+ | 8/17/2020 10:24 | 2020-08-17T10:24:00Z | 08/17 06:24 | 364 | 2782 | 2020-08-17T10:24:00Z | 734332 | 46894 | 601795 | 2300 | 696 | 2777 | 747 | 49 | 242 | 3026 | 601795 | posNeg | 3268 | 601795 | 1 | 11 | 5795ea890fb2d61de3aa7dc9ee8953ebbed97614 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
2277 | 2277 | 20200817 | NV | 61967 | 489456 | 551423 | 869 | 256 | 150 | 1498 | A+ | 8/17/2020 02:59 | 2020-08-17T02:59:00Z | 08/16 22:59 | 1077 | 2020-08-17T02:59:00Z | 759112 | 61967 | 551770 | 32 | 662 | 3298 | 551423 | posNeg | 3960 | 551423 | 5 | 0 | 192889d444e48d7a410beb18c96fb1f37074ecec | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
2193 | 2193 | 20200818 | DC | 13325 | 236153 | 249478 | 79 | 27 | 14 | 10595 | A+ | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 599 | 2020-08-17T00:00:00Z | 249478 | 159943 | 11 | 52 | 3771 | 249478 | posNeg | 3823 | 249478 | 2 | 0 | 60b86928d0b7085b7d64da291873f9ce839896fa | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
2260 | 2260 | 20200817 | KY | 39691 | 677125 | 713949 | 563 | 4215 | 136 | 1310 | 9158 | B | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 818 | 4215 | 2020-08-17T00:00:00Z | 713949 | 36824 | 813 | 5 | 45353 | 720 | 21 | 376 | 4079 | 716816 | posNeg | 4786 | 716816 | 5 | 22 | 0d3a6104d55a7ea928100482f25e2678605d4fa2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
2241 | 2241 | 20200817 | AK | 5110 | 300538 | 305648 | 33 | 4 | 1432 | A | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 28 | 2020-08-17T00:00:00Z | 305648 | 4838 | 300493 | 5110 | 28 | 2 | 50 | 4083 | 305648 | posNeg | 4133 | 305648 | 0 | 0 | 1f061811cb893bd447aa24b54caa076b568a38a0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
2229 | 2229 | 20200818 | SC | 107672 | 770809 | 878481 | 1116 | 7146 | 294 | 173 | 45205 | A+ | 8/17/2020 23:59 | 2020-08-17T23:59:00Z | 08/17 19:59 | 2343 | 7146 | 2020-08-17T23:59:00Z | 877383 | 141827 | 735556 | 106574 | 2230 | 113 | 61311 | 4738 | 56573 | 45 | 719 | 4215 | 878481 | posNeg | 4934 | 878481 | 55 | 294 | bfee6f60cceae99c3732855d05b67c563704b779 | 0 | 0 | 0 | 0 | 0 | |||||||||||||
2191 | 2191 | 20200818 | CO | 53370 | 586280 | 881252 | 245 | 6739 | 5712 | A | 8/17/2020 01:59 | 2020-08-17T01:59:00Z | 08/16 21:59 | 1778 | 6739 | 2020-08-17T01:59:00Z | 49801 | 881252 | 636081 | 150080 | 10349 | 139731 | 8 | 194 | 4883 | 639650 | totalTestEncountersViral | 8201 | 639650 | 10 | 4 | adc9957cbc7a74b6ee1547af7291bd029471a05f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2295 | 2295 | 20200817 | WV | 8632 | 352207 | 360839 | 134 | 50 | 19 | 6531 | B | 8/17/2020 10:00 | 2020-08-17T10:00:00Z | 08/17 06:00 | 160 | 2020-08-17T10:00:00Z | 360669 | 8462 | 159 | 1 | 15208 | 54 | 68 | 5432 | 360839 | posNeg | 5500 | 360839 | 0 | 0 | d7c7b1830ad0101991e87fb3320d377d61a3f643 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
2294 | 2294 | 20200817 | WI | 70715 | 1066040 | 172 | 1136755 | 365 | 5327 | 124 | 961 | 56602 | A+ | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 1046 | 5327 | 2020-08-17T00:00:00Z | 66196 | 1039 | 7 | 1132236 | 55 | 469 | 5507 | 1136927 | posNeg | 5976 | 1136755 | 0 | 23 | ae2f181f9e9f5a049821b656d62f346428b2757f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2242 | 2242 | 20200817 | AL | 109004 | 743919 | 848514 | 1301 | 12958 | 1319 | 720 | 41523 | B | 8/17/2020 11:00 | 2020-08-17T11:00:00Z | 08/17 07:00 | 1925 | 12958 | 2020-08-17T11:00:00Z | 848514 | 104595 | 1855 | 70 | 1 | 571 | 5928 | 852923 | posNeg | 6444 | 852923 | 27 | 351 | 9a38a9f09dbf0e9603e20f95a8ac01a4e78083fe | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2245 | 2245 | 20200817 | AZ | 194005 | 904383 | 1096897 | 1182 | 20756 | 430 | 266 | 27800 | A+ | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 4506 | 20756 | 2020-08-17T00:00:00Z | 192514 | 4252 | 254 | 1096897 | 252860 | 4 | 468 | 5946 | 1098388 | posNeg | 6398 | 1098388 | 0 | 1 | 4960dda7e889c381abb92e19704e91986aae35f5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2220 | 2220 | 20200818 | NM | 23500 | 653650 | 677150 | 119 | 2984 | 10602 | B | 8/17/2020 17:50 | 2020-08-17T17:50:00Z | 08/17 13:50 | 718 | 2984 | 2020-08-17T17:50:00Z | 677150 | 23500 | 35 | 92 | 6485 | 677150 | posNeg | 6577 | 677150 | 4 | 19 | 6c075270ac8012ffb209452f09a71e410067e126 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
2259 | 2259 | 20200817 | KS | 35167 | 319095 | 354262 | 229 | 2034 | 62 | 560 | 24 | 200 | 1409 | A+ | 8/17/2020 10:00 | 2020-08-17T10:00:00Z | 08/17 06:00 | 405 | 2034 | 2020-08-17T10:00:00Z | 354262 | 20 | 1282 | 9937 | 354262 | posNeg | 11219 | 354262 | 3 | 14 | 595976c4df4f7cf86af970c07fd819fb4a58da09 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
2282 | 2282 | 20200817 | PA | 124844 | 1342475 | 1467319 | 560 | 95 | 98626 | A+ | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 7468 | 2020-08-17T00:00:00Z | 121354 | 1463829 | 42 | 384 | 10072 | 1467319 | posNeg | 10456 | 1467319 | 0 | 0 | 010fd18e127552e89ec0f0234fad775607d7de8e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
2271 | 2271 | 20200817 | NC | 145516 | 1789956 | 1935472 | 980 | 290 | 127749 | A+ | 8/17/2020 12:20 | 2020-08-17T12:20:00Z | 08/17 08:20 | 2348 | 2020-08-17T12:20:00Z | 1935472 | 145516 | 2348 | 37 | 564 | 10262 | 1935472 | posNeg | 10826 | 1935472 | 1 | 0 | 75fddc10963dc5924bfa25cf61bbf779637ae07c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
2192 | 2192 | 20200818 | CT | 51255 | 941476 | 992731 | 47 | 11015 | 8809 | B | 8/17/2020 20:30 | 2020-08-17T20:30:00Z | 08/17 16:30 | 4456 | 11015 | 2020-08-17T20:30:00Z | 990712 | 49236 | 3571 | 885 | 9 | -12 | 10775 | 992731 | posNeg | 10763 | 992731 | 0 | 0 | b423852a101e885ec1dfa6e920a26543fbfcd638 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
2267 | 2267 | 20200817 | MO | 68623 | 789994 | 858617 | 853 | 119 | A | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 1396 | 2020-08-17T00:00:00Z | 1138890 | 79618 | 1057293 | 68623 | 858617 | 64968 | 2549 | 62419 | 29 | 1148 | 11851 | 858617 | posNeg | 12999 | 858617 | 29 | 0 | 45e0b73eae8d871911a6533b183a5a3f11994fdc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2287 | 2287 | 20200817 | TN | 134744 | 1736364 | 1871108 | 1139 | 5881 | 374 | 173 | 94812 | A+ | 8/17/2020 15:00 | 2020-08-17T15:00:00Z | 08/17 11:00 | 1387 | 5881 | 2020-08-17T15:00:00Z | 1868761 | 159582 | 1709179 | 132397 | 1345 | 42 | 47 | 1036 | 12732 | 1871108 | posNeg | 13768 | 1871108 | 21 | 34 | 7dc198f2b9f3a6c57f09c921d37fc780d1ded753 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
2202 | 2202 | 20200818 | IN | 81847 | 846767 | 928614 | 849 | 10037 | 251 | 2052 | 94 | 61518 | A+ | 8/17/2020 23:59 | 2020-08-17T23:59:00Z | 08/17 19:59 | 3165 | 10037 | 2020-08-17T23:59:00Z | 1192986 | 2954 | 211 | 928614 | 18 | 841 | 13140 | 928614 | posNeg | 13981 | 928614 | 30 | 64 | 691c13b8c629881e036a30c08990fe35c4a68b6c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2237 | 2237 | 20200818 | WA | 69967 | 1259249 | 1329216 | 394 | 6296 | 39 | B | 8/17/2020 02:59 | 2020-08-17T02:59:00Z | 08/16 22:59 | 1785 | 6296 | 2020-08-17T02:59:00Z | 69967 | 1785 | 1329216 | 53 | 598 | 14503 | 1329216 | posNeg | 15101 | 1329216 | 4 | 41 | 14c3d2255cad0efe945a2f53ac088d8341e59758 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
2263 | 2263 | 20200817 | MD | 100715 | 1056897 | 1157612 | 435 | 13658 | 106 | 6008 | A | 8/17/2020 10:00 | 2020-08-17T10:00:00Z | 08/17 06:00 | 3641 | 13658 | 2020-08-17T10:00:00Z | 1645642 | 118601 | 100715 | 3504 | 137 | 1157612 | 24 | 503 | 14699 | 1157612 | posNeg | 15202 | 1157612 | 2 | 44 | fc8f7db099de7885d5e11a6d5d4d0b162f2c4e57 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2262 | 2262 | 20200817 | MA | 123413 | 1341501 | 1929891 | 367 | 12178 | 59 | 22 | 100486 | A+ | 8/17/2020 10:00 | 2020-08-17T10:00:00Z | 08/17 06:00 | 8833 | 12178 | 2020-08-17T10:00:00Z | 1929891 | 151327 | 114611 | 8611 | 222 | 1456112 | 105540 | 69018 | 25 | 213 | 14733 | 1464914 | totalTestsViral | 21416 | 1464914 | 4 | 5 | f68ba2f3746e00ef1925ec9f7bec747dfae6aeff | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
2261 | 2261 | 20200817 | LA | 138485 | 1535804 | 1674289 | 1226 | 184 | 103512 | A | 8/17/2020 13:00 | 2020-08-17T13:00:00Z | 08/17 09:00 | 4526 | 2020-08-17T13:00:00Z | 138485 | 4403 | 123 | 1674289 | 22 | 567 | 15635 | 1674289 | posNeg | 16202 | 1674289 | 19 | 0 | b083652781cfad497bba558d1bfa71c85d45ba00 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
2234 | 2234 | 20200818 | VA | 108282 | 1282023 | 381 | 1385832 | 1253 | 15163 | 300 | 163 | 13910 | A+ | 8/17/2020 17:00 | 2020-08-17T17:00:00Z | 08/17 13:00 | 2396 | 15163 | 2020-08-17T17:00:00Z | 125049 | 103809 | 2278 | 118 | 1385832 | 51 | 861 | 16002 | 1390686 | posNeg | 16795 | 1390305 | 11 | 163 | 400d192989208ae4792fda6b2cd3a2b61b7a793e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
2279 | 2279 | 20200817 | OH | 109062 | 1739954 | 1849016 | 933 | 12319 | 316 | 2786 | 175 | 87764 | A+ | 8/17/2020 14:00 | 2020-08-17T14:00:00Z | 08/17 10:00 | 3832 | 12319 | 2020-08-17T14:00:00Z | 1843274 | 103320 | 3554 | 278 | 39 | 775 | 18596 | 1849016 | posNeg | 19371 | 1849016 | 6 | 83 | 6766dd68c49961e43a1833be580df539df85d36c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2265 | 2265 | 20200817 | MI | 102749 | 2237458 | 2340207 | 653 | 169 | 89 | 67778 | A+ | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 6592 | 2020-08-17T00:00:00Z | 2368782 | 131324 | 2237458 | 93185 | 6325 | 267 | 238946 | 26 | 490 | 18667 | 2340207 | posNeg | 19157 | 2340207 | 0 | 0 | 693c061e2dca1e96ba79a7f06c8185b2de2447a4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2252 | 2252 | 20200817 | GA | 238861 | 1788556 | 2027417 | 2626 | 22133 | 4061 | A | 8/17/2020 14:50 | 2020-08-17T14:50:00Z | 08/17 10:50 | 4727 | 22133 | 2020-08-17T14:50:00Z | 2027417 | 221905 | 1805512 | 238861 | 257747 | 18393 | 13 | 1831 | 20313 | 2027417 | posNeg | 22144 | 2027417 | 25 | 46 | 7c3b4ce8e8ae6c6d4fd5e8ae9456d7c39d42cad7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2275 | 2275 | 20200817 | NJ | 187767 | 2323303 | 2511070 | 472 | 22218 | 91 | 38 | 33381 | A+ | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 15866 | 22218 | 2020-08-17T00:00:00Z | 2511070 | 187767 | 14077 | 1789 | 34 | 312 | 20572 | 2511070 | posNeg | 20884 | 2511070 | 4 | 12 | 870e2711305d30e2c9fcfdb647b83b4034528aac | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2195 | 2195 | 20200818 | FL | 579932 | 3699108 | 3814 | 4279040 | 5484 | 35112 | B | 8/17/2020 23:59 | 2020-08-17T23:59:00Z | 08/17 19:59 | 9893 | 35112 | 2020-08-17T23:59:00Z | 5757074 | 741276 | 4984524 | 579932 | 9893 | 4285720 | 408950 | 27323 | 381574 | 401862 | 26788 | 375046 | 5884 | 12 | 3838 | 22326 | 4282854 | posNeg | 26164 | 4279040 | 219 | 505 | 218bb5df07e4670d4ceea9fa777de712bf9e29b9 | 0 | 0 | 0 | 0 | 0 | |||||||||||
2288 | 2288 | 20200817 | TX | 542950 | 3933217 | 4476167 | 6200 | 2240 | 405817 | A | 8/17/2020 16:55 | 2020-08-17T16:55:00Z | 08/17 12:55 | 10034 | 2020-08-17T16:55:00Z | 4476167 | 542950 | 322433 | 23797 | 17887 | 2694 | 48 | 7368 | 29758 | 4476167 | posNeg | 37126 | 4476167 | 51 | 0 | 11bc01cfa95559e83eaa288c86435ef5a0ed3536 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
2257 | 2257 | 20200817 | IL | 209186 | 3197243 | 3406429 | 1544 | 340 | 126 | A | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 7967 | 2020-08-17T00:00:00Z | 3405097 | 207854 | 7756 | 211 | 17 | 1773 | 36473 | 3406429 | posNeg | 38246 | 3406429 | 12 | 0 | 7bf9392f8f51a9bafa222c3cd51db906c6d4689f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
2222 | 2222 | 20200818 | NY | 426571 | 6765407 | 7191978 | 537 | 89995 | 126 | 60 | 74258 | A | 8/17/2020 23:59 | 2020-08-17T23:59:00Z | 08/17 19:59 | 25264 | 89995 | 2020-08-17T23:59:00Z | 426571 | 7191978 | 36 | 655 | 66236 | 7191978 | posNeg | 66891 | 7191978 | 8 | 0 | 68ae0c502bc8dee13dcda9651eb2a1366b558b57 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
2246 | 2246 | 20200817 | CA | 628031 | 9305749 | 9933780 | 6332 | 1811 | B | 8/17/2020 00:00 | 2020-08-17T00:00:00Z | 08/16 20:00 | 11242 | 2020-08-17T00:00:00Z | 9933780 | 628031 | 6 | 6469 | 129176 | 9933780 | posNeg | 135645 | 9933780 | 18 | 0 | d2a8eb52fa329853459959ccc6d782253c5d23bb | 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 );