states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
68 rows where "dateModified" is on date 2020-04-17 sorted by death
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestResultsSource, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9044 | 9044 | 20200418 | MP | 14 | 42 | 4 | 56 | 9 | 4/17/2020 19:15 | 2020-04-17T19:15:00Z | 04/17 15:15 | 2 | 2020-04-17T19:15:00Z | 69 | 1 | 0 | 60 | posNeg | 1 | 56 | 0 | 0 | ee5f65a9e3d7ba634aef791525702a1dd51ab866 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9072 | 9072 | 20200418 | WY | 305 | 6217 | 6522 | 19 | 50 | 206 | A | 4/17/2020 16:02 | 2020-04-17T16:02:00Z | 04/17 12:02 | 2 | 50 | 2020-04-17T16:02:00Z | 305 | 56 | 9 | 86 | 6522 | posNeg | 95 | 6522 | 0 | 7 | 97f421de86c717ec0ef036db2046a7ef20c1906b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9100 | 9100 | 20200417 | MP | 13 | 42 | 4 | 55 | 4/17/2020 19:15 | 2020-04-17T19:15:00Z | 04/17 15:15 | 2 | 2020-04-17T19:15:00Z | 69 | 0 | 15 | 59 | posNeg | 15 | 55 | 0 | 0 | 7bf3e8bc825078c2daf9c659c653c437a130301f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
9123 | 9123 | 20200417 | VI | 51 | 373 | 34 | 424 | 46 | 4/17/2020 08:30 | 2020-04-17T08:30:00Z | 04/17 04:30 | 2 | 2020-04-17T08:30:00Z | 78 | 0 | 16 | 458 | posNeg | 16 | 424 | 1 | 0 | f5eb61fee8afe8f87c32f0f2f54138fd451397c7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9128 | 9128 | 20200417 | WY | 296 | 6131 | 6427 | 19 | 43 | 148 | A | 4/17/2020 16:02 | 2020-04-17T16:02:00Z | 04/17 12:02 | 2 | 43 | 2020-04-17T16:02:00Z | 296 | 56 | 0 | 0 | 6427 | posNeg | 0 | 6427 | 0 | 0 | d4f2711320c163692c051e536990fdfe13b52abe | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9085 | 9085 | 20200417 | GU | 133 | 940 | 1073 | 6 | 2 | 97 | 4/17/2020 07:00 | 2020-04-17T07:00:00Z | 04/17 03:00 | 5 | 2020-04-17T07:00:00Z | 66 | 0 | 70 | 1073 | posNeg | 70 | 1073 | 0 | 0 | 03032c101771aad6f0b013315eaee93b5748f980 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9062 | 9062 | 20200418 | SD | 1542 | 10118 | 1 | 11660 | 68 | 552 | A | 4/17/2020 18:00 | 2020-04-17T18:00:00Z | 04/17 14:00 | 7 | 68 | 2020-04-17T18:00:00Z | 11660 | 46 | 131 | 467 | 11661 | posNeg | 598 | 11660 | 0 | 5 | d8b01460ad9534be7a37ff11332e4ff14a8b8ee1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9102 | 9102 | 20200417 | MT | 422 | 9822 | 10244 | 21 | 54 | 233 | A | 4/17/2020 10:44 | 2020-04-17T10:44:00Z | 04/17 06:44 | 8 | 54 | 2020-04-17T10:44:00Z | 10244 | 30 | 7 | 301 | 10244 | posNeg | 308 | 10244 | 1 | 2 | 5f4717b04dc98b6e27cb86776459de0c8118214a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9030 | 9030 | 20200418 | HI | 553 | 21790 | 22343 | 48 | 390 | A | 4/17/2020 18:30 | 2020-04-17T18:30:00Z | 04/17 14:30 | 9 | 48 | 2020-04-17T18:30:00Z | 15 | 12 | 474 | 22343 | posNeg | 486 | 22343 | 0 | 3 | ee997afc0be5927a1f000a8fe9fe18de4787be6f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9086 | 9086 | 20200417 | HI | 541 | 21316 | 21857 | 45 | 374 | A | 4/17/2020 18:30 | 2020-04-17T18:30:00Z | 04/17 14:30 | 9 | 45 | 2020-04-17T18:30:00Z | 15 | 11 | 1146 | 21857 | posNeg | 1157 | 21857 | 0 | 0 | 65cef10cb37c85dd60682765ba6445ff36ab8ade | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9104 | 9104 | 20200417 | ND | 438 | 11903 | 12629 | 16 | 47 | 172 | B | 4/17/2020 13:00 | 2020-04-17T13:00:00Z | 04/17 09:00 | 9 | 47 | 2020-04-17T13:00:00Z | 12790 | 438 | 12629 | 11825 | 38 | 46 | 592 | 12341 | totalTestEncountersViral | 819 | 12341 | 0 | 2 | 0188536414df766832086cf004e75829d6597ee9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
9127 | 9127 | 20200417 | WV | 754 | 17927 | 18681 | 85 | 34 | 24 | 223 | B | 4/17/2020 17:00 | 2020-04-17T17:00:00Z | 04/17 13:00 | 13 | 2020-04-17T17:00:00Z | 754 | 54 | 15 | 360 | 18681 | posNeg | 375 | 18681 | 0 | 0 | 93d6b44bb8e26ed1586a3e3f7c17af6e06df50fe | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9071 | 9071 | 20200418 | WV | 785 | 18655 | 19440 | 83 | 40 | 27 | 255 | B | 4/17/2020 17:00 | 2020-04-17T17:00:00Z | 04/17 13:00 | 16 | 2020-04-17T17:00:00Z | 785 | 54 | 31 | 728 | 19440 | posNeg | 759 | 19440 | 3 | 0 | 6e30511c29aba9e6fb8531b0858ef6dd87c9ffd2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9121 | 9121 | 20200417 | UT | 2805 | 52966 | 55771 | 244 | 443 | A | 4/17/2020 15:00 | 2020-04-17T15:00:00Z | 04/17 11:00 | 23 | 244 | 2020-04-17T15:00:00Z | 2805 | 49 | 122 | 5971 | 55771 | posNeg | 6093 | 55771 | 2 | 6 | b3bf60f93c398af29a627022bea9c938c303fd44 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
9049 | 9049 | 20200418 | NE | 1138 | 12539 | 13677 | A | 4/17/2020 19:42 | 2020-04-17T19:42:00Z | 04/17 15:42 | 24 | 2020-04-17T19:42:00Z | 13753 | 31 | 72 | 501 | 13677 | posNeg | 573 | 13677 | 0 | 0 | 4ca4b9aa50a4bf5b658bef5c1156e66e1307bee6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9105 | 9105 | 20200417 | NE | 1066 | 12038 | 13104 | A | 4/17/2020 19:42 | 2020-04-17T19:42:00Z | 04/17 15:42 | 24 | 2020-04-17T19:42:00Z | 13173 | 31 | 114 | 696 | 13104 | posNeg | 810 | 13104 | 3 | 0 | c019406cf91410ddac20f897290cc4b77fe76f30 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9096 | 9096 | 20200417 | ME | 827 | 14076 | 14903 | 55 | 133 | 28 | 8 | 352 | A | 4/17/2020 11:45 | 2020-04-17T11:45:00Z | 04/17 07:45 | 29 | 133 | 2020-04-17T11:45:00Z | 827 | 23 | 31 | 0 | 14903 | posNeg | 31 | 14903 | 2 | 3 | 025d44aa854582dba393e259bf2a781b431c4233 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
9124 | 9124 | 20200417 | VT | 802 | 10813 | 11615 | 32 | 15 | A | 4/17/2020 00:00 | 2020-04-17T00:00:00Z | 04/16 20:00 | 35 | 2020-04-17T00:00:00Z | 802 | 50 | 10 | 554 | 11615 | posNeg | 564 | 11615 | 0 | 0 | 3055dd40be3d23154e9e577937c4103b20d69e67 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9050 | 9050 | 20200418 | NH | 1287 | 11565 | 174 | 14100 | 86 | 190 | 468 | B | 4/17/2020 09:00 | 2020-04-17T09:00:00Z | 04/17 05:00 | 37 | 190 | 2020-04-17T09:00:00Z | 14100 | 33 | 0 | 144 | 13026 | posNeg | 565 | 12852 | 0 | 0 | a26f3195113fbec5693f9e01c62a7443c582b12b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
9075 | 9075 | 20200417 | AR | 1695 | 21799 | 23494 | 83 | 21 | 593 | A | 4/17/2020 19:00 | 2020-04-17T19:00:00Z | 04/17 15:00 | 37 | 2020-04-17T19:00:00Z | 23494 | 1695 | 5 | 75 | 744 | 23494 | posNeg | 819 | 23494 | 0 | 0 | 7dfb1465128b9c3ff566da89b77f1932315e250d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9106 | 9106 | 20200417 | NH | 1287 | 11421 | 174 | 13535 | 74 | 190 | 455 | B | 4/17/2020 09:00 | 2020-04-17T09:00:00Z | 04/17 05:00 | 37 | 190 | 2020-04-17T09:00:00Z | 13535 | 33 | 148 | 394 | 12882 | posNeg | 410 | 12708 | 5 | 12 | 863a70162d158eb0990ec11c96854883867f6e9e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
9019 | 9019 | 20200418 | AR | 1739 | 22402 | 24141 | 86 | 291 | 22 | 57 | 703 | A | 4/17/2020 19:00 | 2020-04-17T19:00:00Z | 04/17 15:00 | 38 | 291 | 2020-04-17T19:00:00Z | 24141 | 1739 | 5 | 44 | 603 | 24141 | posNeg | 647 | 24141 | 1 | 291 | a1f4a26ea3cdfb9e0a83bf6ef90c3cf6465a11bf | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
9088 | 9088 | 20200417 | ID | 1609 | 15043 | 16652 | 58 | 148 | 51 | 390 | A | 4/17/2020 19:00 | 2020-04-17T19:00:00Z | 04/17 15:00 | 41 | 148 | 2020-04-17T19:00:00Z | 16652 | 16 | 22 | 388 | 16652 | posNeg | 410 | 16652 | 0 | 5 | e150c33601c201623d27e15a1530825d32a63839 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
9032 | 9032 | 20200418 | ID | 1655 | 15292 | 16947 | 53 | 151 | 53 | 453 | A | 4/17/2020 19:00 | 2020-04-17T19:00:00Z | 04/17 15:00 | 43 | 151 | 2020-04-17T19:00:00Z | 16947 | 16 | 46 | 249 | 16947 | posNeg | 295 | 16947 | 2 | 3 | c1dea328d36d565d3555b6622fad3f27947b81c7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
9108 | 9108 | 20200417 | NM | 1597 | 32891 | 34488 | 90 | 230 | 353 | A | 4/17/2020 20:53 | 2020-04-17T20:53:00Z | 04/17 16:53 | 44 | 230 | 2020-04-17T20:53:00Z | 35 | 113 | 981 | 34488 | posNeg | 1094 | 34488 | 8 | 15 | 4d2a96ab240984924d413b67b38043c3508751df | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
9052 | 9052 | 20200418 | NM | 1711 | 33902 | 35613 | 96 | 242 | 382 | A | 4/17/2020 21:53 | 2020-04-17T21:53:00Z | 04/17 17:53 | 51 | 242 | 2020-04-17T21:53:00Z | 35 | 114 | 1011 | 35613 | posNeg | 1125 | 35613 | 7 | 12 | d1f93f6713a62535b13a04ee152e8c8ddc67648a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
9115 | 9115 | 20200417 | PR | 1068 | 7864 | 1478 | 8932 | A | 4/17/2020 06:00 | 2020-04-17T06:00:00Z | 04/17 02:00 | 58 | 2020-04-17T06:00:00Z | 72 | 25 | 549 | 10410 | posNeg | 574 | 8932 | 2 | 0 | 30fbb06fd9a500fc80f386007ca9288cef501153 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9113 | 9113 | 20200417 | OR | 1785 | 34536 | 36321 | 301 | 427 | 69 | 41 | A | 4/17/2020 11:00 | 2020-04-17T11:00:00Z | 04/17 07:00 | 70 | 427 | 2020-04-17T11:00:00Z | 41 | 49 | 1334 | 36321 | posNeg | 1383 | 36321 | 6 | 13 | 934d05facfd0ecba708312b44c17c72d55a8a02d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9031 | 9031 | 20200418 | IA | 2513 | 20434 | 22947 | 193 | 84 | 51 | 1095 | A | 4/17/2020 12:00 | 2020-04-17T12:00:00Z | 04/17 08:00 | 74 | 2020-04-17T12:00:00Z | 2513 | 19 | 181 | 974 | 22947 | posNeg | 1155 | 22947 | 10 | 0 | 0f0af7614c4be83939cab60ee694afc9561f1f88 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9082 | 9082 | 20200417 | DE | 2323 | 11694 | 14017 | 224 | 423 | A | 4/17/2020 17:00 | 2020-04-17T17:00:00Z | 04/17 13:00 | 76 | 2020-04-17T17:00:00Z | 67 | 9 | 10 | 248 | 419 | 14017 | posNeg | 667 | 14017 | 6 | 0 | 29152a359a07af14fda50fa73d54a4c3d3d5777d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
9091 | 9091 | 20200417 | KS | 1705 | 15196 | 16901 | 375 | B | 4/17/2020 12:00 | 2020-04-17T12:00:00Z | 04/17 08:00 | 84 | 375 | 2020-04-17T12:00:00Z | 20 | 117 | 662 | 16901 | posNeg | 779 | 16901 | 4 | 16 | efc6b3c32635dc04a361e7b81b0297d1b214b7d0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9026 | 9026 | 20200418 | DE | 2323 | 11694 | 14017 | 224 | 423 | A | 4/17/2020 17:00 | 2020-04-17T17:00:00Z | 04/17 13:00 | 86 | 2020-04-17T17:00:00Z | 77 | 9 | 10 | 0 | 0 | 14017 | posNeg | 0 | 14017 | 10 | 0 | d8c25549d1eff08836b49ac13dff26315fcf34ed | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
9025 | 9025 | 20200418 | DC | 2666 | 10602 | 13268 | 313 | 105 | 79 | 608 | A | 4/17/2020 00:00 | 2020-04-17T00:00:00Z | 04/16 20:00 | 91 | 2020-04-17T00:00:00Z | 13268 | 11 | 190 | 435 | 13268 | posNeg | 625 | 13268 | 5 | 0 | 227be6a32c3f27f9cdd2278bd45cb8a5cbda19d6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9117 | 9117 | 20200417 | SC | 3931 | 32353 | 36284 | 675 | B | 4/17/2020 16:48 | 2020-04-17T16:48:00Z | 04/17 12:48 | 109 | 675 | 2020-04-17T16:48:00Z | 3931 | 45 | 275 | 1276 | 36284 | posNeg | 1551 | 36284 | 2 | 0 | ab919b630a76f85e11175132e076c3311af66ffa | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9116 | 9116 | 20200417 | RI | 4585 | 26157 | 31779 | 252 | 331 | 62 | 43 | 196 | B | 4/17/2020 03:00 | 2020-04-17T03:00:00Z | 04/16 23:00 | 118 | 331 | 2020-04-17T03:00:00Z | 33997 | 4816 | 29181 | 4585 | 31779 | 30742 | 44 | 290 | 1500 | 30742 | totalTestEncountersViral | 2941 | 30742 | 13 | 0 | 5ab15ff9b0019527d30ab6c796ae97f57c7c4c4a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
9042 | 9042 | 20200418 | MN | 2788 | 45182 | 47970 | 239 | 561 | 111 | 215 | 997 | A | 4/17/2020 17:00 | 2020-04-17T17:00:00Z | 04/17 13:00 | 121 | 561 | 2020-04-17T17:00:00Z | 2788 | 47970 | 27 | 120 | 1362 | 47970 | posNeg | 1482 | 47970 | 10 | 43 | 058dbece31d60295bf927ae2ea4ba87ce80702f2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
9092 | 9092 | 20200417 | KY | 2429 | 27318 | 29747 | 477 | 971 | 333 | 506 | 956 | A | 4/17/2020 17:00 | 2020-04-17T17:00:00Z | 04/17 13:00 | 129 | 971 | 2020-04-17T17:00:00Z | 29747 | 21 | 138 | 1285 | 29747 | posNeg | 1423 | 29747 | 7 | 164 | 1f56c4c8920a54a80858166fc04e376e4694bd99 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
9112 | 9112 | 20200417 | OK | 2465 | 31155 | 33620 | 325 | 528 | 155 | 1331 | B | 4/17/2020 11:35 | 2020-04-17T11:35:00Z | 04/17 07:35 | 136 | 528 | 2020-04-17T11:35:00Z | 2465 | 40 | 108 | 2613 | 33620 | posNeg | 2721 | 33620 | 5 | 0 | 12d750873ebf15d46ba0f178b32a3787e8316c3a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
9036 | 9036 | 20200418 | KY | 2522 | 28074 | 30596 | 360 | 1008 | 227 | 514 | 979 | A | 4/17/2020 17:00 | 2020-04-17T17:00:00Z | 04/17 13:00 | 137 | 1008 | 2020-04-17T17:00:00Z | 30596 | 21 | 93 | 756 | 30596 | posNeg | 849 | 30596 | 8 | 37 | d36eb749aaadaa4f9aac8e02f8b03d024056e3ad | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
9119 | 9119 | 20200417 | TN | 6589 | 80684 | 87273 | 465 | 711 | 3017 | A | 4/17/2020 15:00 | 2020-04-17T15:00:00Z | 04/17 11:00 | 142 | 711 | 2020-04-17T15:00:00Z | 47 | 327 | 1897 | 87273 | posNeg | 2224 | 87273 | 1 | 20 | 6235fe4d797c925013715d9ac8d41708b51a2359 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
9074 | 9074 | 20200417 | AL | 4530 | 33318 | 37848 | 364 | 594 | 247 | 148 | B | 4/17/2020 00:00 | 2020-04-17T00:00:00Z | 04/16 20:00 | 144 | 594 | 2020-04-17T00:00:00Z | 37848 | 4530 | 1 | 185 | 1272 | 37848 | posNeg | 1457 | 37848 | 11 | 41 | 62111d65289893c2d1efa8a452184d9eb0a5bbcf | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
9045 | 9045 | 20200418 | MS | 3974 | 34791 | 38765 | 782 | 154 | 99 | A | 4/17/2020 19:00 | 2020-04-17T19:00:00Z | 04/17 15:00 | 152 | 782 | 2020-04-17T19:00:00Z | 28 | 181 | 0 | 38765 | posNeg | 181 | 38765 | 12 | 46 | 47e3909077758e2b5ec5eac58aecaba2d2652e31 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
9103 | 9103 | 20200417 | NC | 5859 | 67122 | 72981 | 429 | A | 4/17/2020 11:00 | 2020-04-17T11:00:00Z | 04/17 07:00 | 152 | 2020-04-17T11:00:00Z | 37 | 394 | 1670 | 72981 | posNeg | 2064 | 72981 | 21 | 0 | 043500592313694e2dbf7cbcfef5ec595fd26a31 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9109 | 9109 | 20200417 | NV | 3524 | 26238 | 29762 | A | 4/17/2020 10:00 | 2020-04-17T10:00:00Z | 04/17 06:00 | 162 | 2020-04-17T10:00:00Z | 35955 | 3524 | 32 | 203 | 1108 | 29762 | posNeg | 1311 | 29762 | 4 | 0 | 26a0c43226a81d875b356195a9bb89feecf0f55d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9099 | 9099 | 20200417 | MO | 5283 | 46434 | 51717 | 1043 | A | 4/17/2020 15:00 | 2020-04-17T15:00:00Z | 04/17 11:00 | 165 | 2020-04-17T15:00:00Z | 52444 | 6022 | 46360 | 5283 | 3 | 0 | 3 | 29 | 172 | 897 | 51717 | posNeg | 1069 | 51717 | 13 | 0 | 7c6acb06f20b9e91e5b4e90d42fc628e5a386621 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
9077 | 9077 | 20200417 | AZ | 4507 | 44723 | 49230 | 566 | 1289 | 285 | 178 | 539 | B | 4/17/2020 00:00 | 2020-04-17T00:00:00Z | 04/16 20:00 | 169 | 1289 | 2020-04-17T00:00:00Z | 49230 | 4 | 273 | 1559 | 49230 | posNeg | 1832 | 49230 | 19 | 31 | a29a548add28bb8f142bedae176b913eedb8c186 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
9126 | 9126 | 20200417 | WI | 4839 | 42365 | 198 | 47204 | 361 | 1153 | 141 | 306 | 348 | A | 4/17/2020 14:24 | 2020-04-17T14:24:00Z | 04/17 10:24 | 205 | 1153 | 2020-04-17T14:24:00Z | 4045 | 55 | 203 | 1391 | 47402 | posNeg | 1594 | 47204 | 8 | 32 | 3a5fbcba38f43acb05d84b829a1bebe394c0f2a5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
9066 | 9066 | 20200418 | VA | 8053 | 43878 | 486 | 67960 | 1307 | 1296 | 398 | 230 | 1228 | A | 4/17/2020 17:00 | 2020-04-17T17:00:00Z | 04/17 13:00 | 258 | 1296 | 2020-04-17T17:00:00Z | 11808 | 67960 | 51 | 562 | 2372 | 52417 | posNeg | 3305 | 51931 | 27 | 75 | f466b84530d8719a1b41249a71d5313145afff4a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
9023 | 9023 | 20200418 | CO | 9047 | 34260 | 47884 | 843 | 1755 | A | 4/17/2020 00:00 | 2020-04-17T00:00:00Z | 04/16 20:00 | 391 | 1755 | 2020-04-17T00:00:00Z | 47884 | 43307 | 8 | 372 | 1105 | 43307 | totalTestEncountersViral | 1706 | 43307 | 17 | 62 | 25970c8681808a4185dc55e32a9cf928143b6255 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8967 | 8967 | 20200419 | CO | 9433 | 35173 | 49465 | 874 | 1797 | A | 4/17/2020 00:00 | 2020-04-17T00:00:00Z | 04/16 20:00 | 411 | 1797 | 2020-04-17T00:00:00Z | 49465 | 44606 | 8 | 386 | 913 | 44606 | totalTestEncountersViral | 1581 | 44606 | 20 | 42 | d9dbd61bedab5ea5e57c4531b3b7c3fa7dbad14a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9111 | 9111 | 20200417 | OH | 9107 | 68819 | 77926 | 2424 | 740 | B | 4/17/2020 14:00 | 2020-04-17T14:00:00Z | 04/17 10:00 | 418 | 2424 | 2020-04-17T14:00:00Z | 8858 | 401 | 17 | 39 | 693 | 2393 | 77926 | posNeg | 3086 | 77926 | 29 | 93 | d4baf45ff1807f5a2192c17a516c9b4403ddcf48 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
9120 | 9120 | 20200417 | TX | 17371 | 152165 | 169536 | 1522 | 4190 | A | 4/17/2020 12:45 | 2020-04-17T12:45:00Z | 04/17 08:45 | 428 | 2020-04-17T12:45:00Z | 17371 | 48 | 916 | 10073 | 169536 | posNeg | 10989 | 169536 | 35 | 0 | 5433cb7be9ece6383e6f4675fed7d888e7426535 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9095 | 9095 | 20200417 | MD | 11572 | 50437 | 62009 | 2612 | 736 | A | 4/17/2020 10:00 | 2020-04-17T10:00:00Z | 04/17 06:00 | 541 | 2612 | 2020-04-17T10:00:00Z | 69474 | 14075 | 11572 | 512 | 29 | 24 | 788 | 2378 | 62009 | posNeg | 3166 | 62009 | 42 | 161 | accbcb126becefe718e58ff91b00e153de29abe7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
9034 | 9034 | 20200418 | IN | 10641 | 46232 | 56873 | 663 | 360 | B | 4/17/2020 23:59 | 2020-04-17T23:59:00Z | 04/17 19:59 | 545 | 2020-04-17T23:59:00Z | 18 | 487 | 1601 | 56873 | posNeg | 2088 | 56873 | 26 | 0 | ee65a539dac3c907e95f4f6dc2cc025d9543b3b9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9125 | 9125 | 20200417 | WA | 12318 | 148206 | 160524 | 622 | 195 | C | 4/17/2020 00:00 | 2020-04-17T00:00:00Z | 04/16 20:00 | 585 | 2020-04-17T00:00:00Z | 12318 | 160524 | 153193 | 53 | 351 | 4772 | 160524 | posNeg | 5123 | 160524 | 14 | 0 | c64fe60e6082d8aefc4c487d23cf35d434ac1b96 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9084 | 9084 | 20200417 | GA | 17194 | 54490 | 71684 | 3324 | A | 4/17/2020 18:28 | 2020-04-17T18:28:00Z | 04/17 14:28 | 650 | 3324 | 2020-04-17T18:28:00Z | 71684 | 13 | 1525 | 2220 | 71684 | posNeg | 3745 | 71684 | 63 | 216 | 80e1f7d17a8b28d35fabbb8f922e9eedc3f048de | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9083 | 9083 | 20200417 | FL | 24119 | 210718 | 1285 | 234837 | 3665 | A | 4/17/2020 16:21 | 2020-04-17T16:21:00Z | 04/17 12:21 | 699 | 3665 | 2020-04-17T16:21:00Z | 12 | 1222 | 14367 | 236122 | posNeg | 15589 | 234837 | 53 | 205 | f84ae67e3b3d66e4a673b262582742ba07d923db | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9114 | 9114 | 20200417 | PA | 29441 | 117932 | 147373 | 2603 | 661 | A | 4/17/2020 12:00 | 2020-04-17T12:00:00Z | 04/17 08:00 | 756 | 2020-04-17T12:00:00Z | 147373 | 42 | 1706 | 4197 | 147373 | posNeg | 5903 | 147373 | 49 | 0 | 030043a4e94a0f8ae1084e2968c4990e6fb2ef50 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9078 | 9078 | 20200417 | CA | 27528 | 224086 | 7200 | 251614 | 4892 | 1484 | B | 4/17/2020 00:00 | 2020-04-17T00:00:00Z | 04/16 20:00 | 985 | 2020-04-17T00:00:00Z | 251614 | 6 | 1346 | 3868 | 258814 | posNeg | 5214 | 251614 | 95 | 0 | 27b01a17036df6df1b452da1fa411a96339a47f1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
9024 | 9024 | 20200418 | CT | 16809 | 38653 | 55462 | 1946 | A | 4/17/2020 16:00 | 2020-04-17T16:00:00Z | 04/17 12:00 | 1036 | 2020-04-17T16:00:00Z | 58213 | 602 | 9 | 0 | 0 | 55462 | posNeg | 0 | 55462 | 0 | 0 | 4919d8d538796e4ab16dd11c546c8ea20d4c033b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9080 | 9080 | 20200417 | CT | 16809 | 38653 | 55462 | 1946 | A | 4/17/2020 16:00 | 2020-04-17T16:00:00Z | 04/17 12:00 | 1036 | 2020-04-17T16:00:00Z | 55462 | 554 | 9 | 925 | 1415 | 55462 | posNeg | 2340 | 55462 | 65 | 0 | 87c9041b207603ca43721aaedff2d855755006d9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9022 | 9022 | 20200418 | CA | 28963 | 230703 | 7200 | 259666 | 4936 | 1490 | B | 4/17/2020 00:00 | 2020-04-17T00:00:00Z | 04/16 20:00 | 1072 | 2020-04-17T00:00:00Z | 259666 | 6 | 1435 | 6617 | 266866 | posNeg | 8052 | 259666 | 87 | 0 | 9adea0514a6711a3354ff7f6c08c719a6c2270a9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
9089 | 9089 | 20200417 | IL | 27575 | 102588 | 130163 | 4454 | 1196 | 777 | A | 4/17/2020 00:00 | 2020-04-17T00:00:00Z | 04/16 20:00 | 1134 | 2020-04-17T00:00:00Z | 17 | 1842 | 5732 | 130163 | posNeg | 7574 | 130163 | 62 | 0 | 95e2eebf31994de2562e9f9439498c87e6681f1d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9093 | 9093 | 20200417 | LA | 23118 | 108869 | 131987 | 1868 | 363 | A | 4/17/2020 13:00 | 2020-04-17T13:00:00Z | 04/17 09:00 | 1213 | 2020-04-17T13:00:00Z | 23118 | 22 | 586 | 4815 | 131987 | posNeg | 5401 | 131987 | 57 | 0 | 5dda2bbb445cc02b13ab24772b7445933287ea39 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9038 | 9038 | 20200418 | MA | 37527 | 124604 | 201692 | 3728 | 3728 | 987 | B | 4/17/2020 16:00 | 2020-04-17T16:00:00Z | 04/17 12:00 | 1983 | 3728 | 2020-04-17T16:00:00Z | 201692 | 47174 | 25 | 2402 | 7409 | 162131 | totalTestsViral | 7478 | 162131 | 161 | -28 | 4f6964a7cc768741da9d249b84f2f4634f7e5a14 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
9097 | 9097 | 20200417 | MI | 36320 | 83268 | 119588 | 3674 | 1428 | 1167 | 629 | B | 4/17/2020 11:00 | 2020-04-17T11:00:00Z | 04/17 07:00 | 2984 | 2020-04-17T11:00:00Z | 122507 | 39239 | 83268 | 35118 | 2955 | 148 | 26 | 865 | 4994 | 119588 | posNeg | 5859 | 119588 | 143 | 0 | 6f8fbfad29139599b3a5e8d6ce280857022f685f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
9107 | 9107 | 20200417 | NJ | 78467 | 78982 | 157449 | 8011 | 1961 | 1594 | A | 4/17/2020 13:00 | 2020-04-17T13:00:00Z | 04/17 09:00 | 4856 | 2020-04-17T13:00:00Z | 78467 | 3840 | 1016 | 157449 | 34 | 3150 | 2469 | 157449 | posNeg | 5619 | 157449 | 365 | 0 | b2fc450b46058defbba1284ecfd0cf88f5e41aa4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
9110 | 9110 | 20200417 | NY | 229642 | 343581 | 573223 | 17316 | 61120 | 5039 | 33392 | A | 4/17/2020 14:00 | 2020-04-17T14:00:00Z | 04/17 10:00 | 12822 | 61120 | 2020-04-17T14:00:00Z | 36 | 7358 | 15286 | 573223 | posNeg | 22644 | 573223 | 630 | 2068 | 5f626642854ac25a9e6726f14695d93a7fa1a8db | 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 );