states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
67 rows where "dateModified" is on date 2020-05-03
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7788 | 7788 | 20200510 | AS | 0 | 83 | 83 | D | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 0 | 2020-05-03T00:00:00Z | 83 | 0 | 60 | 0 | 0 | 83 | posNeg | 0 | 83 | 0 | 0 | 543b2b629c50dde48ffb7a4af41967de7e6c4628 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7844 | 7844 | 20200509 | AS | 0 | 83 | 83 | D | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 0 | 2020-05-03T00:00:00Z | 83 | 0 | 60 | 0 | 0 | 83 | posNeg | 0 | 83 | 0 | 0 | 181e10ded2dd368a627e73ac90a09ee84623409b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7900 | 7900 | 20200508 | AS | 0 | 83 | 83 | F | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 0 | 2020-05-03T00:00:00Z | 83 | 0 | 60 | 0 | 0 | 83 | posNeg | 0 | 83 | 0 | 0 | ae69a856b0ae36a0af9fdbe71cae63f7640c410d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7956 | 7956 | 20200507 | AS | 0 | 83 | 83 | F | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 0 | 2020-05-03T00:00:00Z | 83 | 0 | 60 | 0 | 0 | 83 | posNeg | 0 | 83 | 0 | 0 | 9885bea25e2daf9f4b2b79d283832360f41b2852 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8012 | 8012 | 20200506 | AS | 0 | 83 | 83 | F | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 0 | 2020-05-03T00:00:00Z | 83 | 0 | 60 | 0 | 0 | 83 | posNeg | 0 | 83 | 0 | 0 | 0ac7a83b06d8c35477261f819b8f161cbd3cf0d4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8068 | 8068 | 20200505 | AS | 0 | 83 | 83 | F | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 0 | 2020-05-03T00:00:00Z | 83 | 0 | 60 | 0 | 0 | 83 | posNeg | 0 | 83 | 0 | 0 | 835bc2833de00a4e9bd06cc3039c3b2f541017e2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8071 | 8071 | 20200505 | CO | 16907 | 68097 | 93656 | 834 | 2838 | 2743 | B | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 851 | 2838 | 2020-05-03T00:00:00Z | 15169 | 93656 | 83266 | 8 | 272 | 1642 | 85004 | totalTestEncountersViral | 2232 | 85004 | 9 | 39 | 8d6f6f7d2e3dd7709377b61c9c5d8c66d8b33720 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
8080 | 8080 | 20200505 | ID | 2106 | 28202 | 30146 | 27 | 201 | 83 | 1358 | C | 5/3/2020 19:00 | 2020-05-03T19:00:00Z | 05/03 15:00 | 64 | 201 | 2020-05-03T19:00:00Z | 30146 | 1944 | 16 | 45 | 456 | 30308 | posNeg | 495 | 30308 | 0 | 1 | 2334640921b27ef3ea6e4f466f22d8f3e817db1b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
8097 | 8097 | 20200505 | NE | 6083 | 28526 | 34609 | D | 5/3/2020 20:45 | 2020-05-03T20:45:00Z | 05/03 16:45 | 78 | 2020-05-03T20:45:00Z | 6083 | 34675 | 31 | 173 | 682 | 34609 | posNeg | 855 | 34609 | 0 | 0 | ebc07120f8f7da59c49187eed47c2e9bfc55a130 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8123 | 8123 | 20200504 | AR | 3458 | 50984 | 54442 | 91 | 438 | 16 | 88 | 2016 | B | 5/3/2020 15:40 | 2020-05-03T15:40:00Z | 05/03 11:40 | 81 | 438 | 2020-05-03T15:40:00Z | 54442 | 3458 | 5 | 27 | 1525 | 54442 | posNeg | 1552 | 54442 | 5 | 11 | 41c382e4072510c5702cb4bde2df3566e3c04807 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
8124 | 8124 | 20200504 | AS | 0 | 83 | 83 | F | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 0 | 2020-05-03T00:00:00Z | 83 | 0 | 60 | 0 | 26 | 83 | posNeg | 26 | 83 | 0 | 0 | cdf6493ed40a0dd1eeacd85c2d3ab5775f5ac920 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8127 | 8127 | 20200504 | CO | 16635 | 66455 | 91424 | 883 | 2799 | 2650 | B | 5/3/2020 18:00 | 2020-05-03T18:00:00Z | 05/03 14:00 | 842 | 2799 | 2020-05-03T18:00:00Z | 14897 | 91424 | 81352 | 8 | 410 | 2774 | 83090 | totalTestEncountersViral | 3582 | 83090 | 10 | 6 | 814d4db30f1c487c3f9a1ee854d7d73ed0cdfc7a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
8128 | 8128 | 20200504 | CT | 29287 | 73206 | 102493 | 1488 | 7758 | 4346 | B | 5/3/2020 16:00 | 2020-05-03T16:00:00Z | 05/03 12:00 | 2495 | 7758 | 2020-05-03T16:00:00Z | 108643 | 2168 | 9 | 0 | 0 | 102493 | posNeg | 0 | 102493 | 59 | 0 | ad90d6ba56516a4729217c4b004a4767d17b9835 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
8129 | 8129 | 20200504 | DC | 5170 | 18625 | 23795 | 447 | 130 | 91 | 666 | A+ | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 258 | 2020-05-03T00:00:00Z | 23795 | 11 | 154 | 539 | 23795 | posNeg | 693 | 23795 | 7 | 0 | d9c293d8a1fa557116407f97b2e0e31c9348900a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8130 | 8130 | 20200504 | DE | 5288 | 18822 | 24110 | 281 | 1716 | B | 5/3/2020 18:00 | 2020-05-03T18:00:00Z | 05/03 14:00 | 255 | 2020-05-03T18:00:00Z | 226 | 29 | 10 | 80 | 293 | 24110 | posNeg | 373 | 24110 | 9 | 0 | ae531d5d37fd913b706fbaf439691271d7c4cbb1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
8134 | 8134 | 20200504 | HI | 620 | 33246 | 33866 | 73 | 544 | B | 5/3/2020 18:00 | 2020-05-03T18:00:00Z | 05/03 14:00 | 17 | 73 | 2020-05-03T18:00:00Z | 15 | 0 | 916 | 33866 | posNeg | 916 | 33866 | 1 | 1 | dbb2c6cc2cf3ffebb33f8bceb807a7fb8f06002f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8135 | 8135 | 20200504 | IA | 9703 | 47458 | 57161 | 389 | 143 | 93 | 3486 | B | 5/3/2020 12:00 | 2020-05-03T12:00:00Z | 05/03 08:00 | 188 | 2020-05-03T12:00:00Z | 9703 | 19 | 534 | 3441 | 57161 | posNeg | 3975 | 57161 | 4 | 0 | 81c70c5a53fa81c8eec79e51b981e058a8754e88 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8138 | 8138 | 20200504 | IN | 20507 | 92790 | 113297 | 1449 | 483 | 249 | A+ | 5/3/2020 23:59 | 2020-05-03T23:59:00Z | 05/03 19:59 | 1264 | 2020-05-03T23:59:00Z | 1151 | 18 | 574 | 3864 | 113297 | posNeg | 4438 | 113297 | 18 | 0 | bf9351363ff23201d4b9c44ef75de7d258d8515f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
8139 | 8139 | 20200504 | KS | 5245 | 33358 | 38603 | 553 | 209 | 95 | 291 | A | 5/3/2020 10:00 | 2020-05-03T10:00:00Z | 05/03 06:00 | 136 | 553 | 2020-05-03T10:00:00Z | 20 | 215 | 1610 | 38603 | posNeg | 1825 | 38603 | 2 | 6 | 3d89e573c197d60f04031466acab60d07233ed8f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8140 | 8140 | 20200504 | KY | 5130 | 53279 | 58408 | 329 | 1519 | 170 | 654 | 1892 | A | 5/3/2020 17:00 | 2020-05-03T17:00:00Z | 05/03 13:00 | 253 | 1519 | 2020-05-03T17:00:00Z | 58408 | 5129 | 252 | 21 | 251 | 509 | 58409 | posNeg | 760 | 58409 | 5 | 108 | f4243b316e5f93d80af0678d97f196470c3ad01f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
8144 | 8144 | 20200504 | ME | 1205 | 19546 | 20751 | 37 | 186 | 18 | 11 | 720 | B | 5/3/2020 11:59 | 2020-05-03T11:59:00Z | 05/03 07:59 | 57 | 186 | 2020-05-03T11:59:00Z | 1136 | 57 | 23 | 20 | 0 | 20751 | posNeg | 20 | 20751 | 0 | 3 | 5ce05d9ecc4a025fdca67bec4995822b87526aa6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
8145 | 8145 | 20200504 | MI | 49809 | 202671 | 252480 | 1948 | 839 | 670 | 15659 | A+ | 5/3/2020 11:00 | 2020-05-03T11:00:00Z | 05/03 07:00 | 4722 | 2020-05-03T11:00:00Z | 258536 | 55865 | 202671 | 47451 | 4573 | 206 | 26 | 780 | 7310 | 252480 | posNeg | 8090 | 252480 | 81 | 0 | 7c450f7cc7ec8cc2dbb7959c14e6594fd84792e3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
8149 | 8149 | 20200504 | MS | 7877 | 71800 | 79677 | 646 | 1316 | 145 | 78 | 4421 | B | 5/3/2020 19:00 | 2020-05-03T19:00:00Z | 05/03 15:00 | 310 | 1316 | 2020-05-03T19:00:00Z | 28 | 327 | 1757 | 79677 | posNeg | 2084 | 79677 | 7 | 18 | cf5b8b1f8041fb1f4c350320013ccdd24de54f31 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
8153 | 8153 | 20200504 | NE | 5910 | 27844 | 33754 | D | 5/3/2020 20:45 | 2020-05-03T20:45:00Z | 05/03 16:45 | 78 | 2020-05-03T20:45:00Z | 5910 | 33819 | 31 | 584 | 1908 | 33754 | posNeg | 2492 | 33754 | 2 | 0 | 7f04093a6bfca1d2064e3a594c13a2831f78b71a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8154 | 8154 | 20200504 | NH | 2588 | 24282 | 244 | 27910 | 103 | 286 | 1017 | C | 5/3/2020 09:00 | 2020-05-03T09:00:00Z | 05/03 05:00 | 86 | 286 | 2020-05-03T09:00:00Z | 27910 | 2588 | 1351 | 33 | 159 | -1682 | 27114 | posNeg | 426 | 26870 | 2 | 9 | 86ccb0ef937a131a9ce8fe8648a05f9adbdf687d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
8156 | 8156 | 20200504 | NM | 3850 | 74127 | 77977 | 164 | 587 | 832 | C | 5/3/2020 17:58 | 2020-05-03T17:58:00Z | 05/03 13:58 | 151 | 587 | 2020-05-03T17:58:00Z | 3850 | 35 | 118 | 2915 | 77977 | posNeg | 3033 | 77977 | 12 | 0 | d89e2c31cada1bfba07dadf95cba29935bdba2a8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8160 | 8160 | 20200504 | OK | 4044 | 59804 | 63848 | 236 | 753 | 92 | 2682 | A | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 238 | 753 | 2020-05-03T00:00:00Z | 70368 | 4150 | 66084 | 4044 | 40 | 72 | 0 | 63848 | posNeg | 72 | 63848 | 0 | 10 | 94a25be0f282c747be9141a238418857fc16e384 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
8165 | 8165 | 20200504 | SC | 6626 | 57562 | 64188 | 1110 | 3622 | B | 5/3/2020 15:30 | 2020-05-03T15:30:00Z | 05/03 11:30 | 275 | 1110 | 2020-05-03T15:30:00Z | 6626 | 275 | 45 | 0 | 0 | 64188 | posNeg | 0 | 64188 | 0 | 0 | de777a5efb92849d2a3eaf59af449b1853b9d5bd | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8166 | 8166 | 20200504 | SD | 2668 | 16045 | 18713 | 69 | 211 | 1830 | C | 5/3/2020 18:00 | 2020-05-03T18:00:00Z | 05/03 14:00 | 21 | 211 | 2020-05-03T18:00:00Z | 18713 | 46 | 37 | 259 | 18713 | posNeg | 296 | 18713 | 0 | 14 | 60a13fe04c55d4fe1d13239ebe7c461550e98654 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8169 | 8169 | 20200504 | UT | 5317 | 119344 | 124661 | 441 | 2342 | C | 5/3/2020 15:00 | 2020-05-03T15:00:00Z | 05/03 11:00 | 50 | 441 | 2020-05-03T15:00:00Z | 5317 | 49 | 142 | 2417 | 124661 | posNeg | 2559 | 124661 | 0 | 5 | bdef3b5b19e68247cc8bceee13b80b5a37cedf98 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
8170 | 8170 | 20200504 | VA | 19492 | 92801 | 478 | 135641 | 1463 | 4010 | 348 | 192 | 2547 | A+ | 5/3/2020 17:00 | 2020-05-03T17:00:00Z | 05/03 13:00 | 684 | 4010 | 2020-05-03T17:00:00Z | 24539 | 18640 | 662 | 22 | 135641 | 51 | 821 | 3470 | 112771 | posNeg | 4821 | 112293 | 24 | 100 | f602be0d25543a11b930021025e0edeec2c9a936 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
8171 | 8171 | 20200504 | VI | 66 | 965 | 15 | 1031 | 51 | C | 5/3/2020 20:30 | 2020-05-03T20:30:00Z | 05/03 16:30 | 4 | 2020-05-03T20:30:00Z | 4 | 78 | 0 | 14 | 1046 | posNeg | 14 | 1031 | 0 | 0 | 75224559fd7d59618fae954070179e524f1fb23d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8177 | 8177 | 20200503 | AK | 368 | 21210 | 21578 | 12 | 262 | C | 5/3/2020 14:15 | 2020-05-03T14:15:00Z | 05/03 10:15 | 9 | 2020-05-03T14:15:00Z | 21578 | 368 | 9 | 2 | 3 | 176 | 21578 | posNeg | 179 | 21578 | 0 | 0 | e8608bf6a68990f37e526edd75f88e73d9e057cf | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8178 | 8178 | 20200503 | AL | 7725 | 84775 | 92500 | 427 | 1035 | 403 | 242 | B | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 290 | 1035 | 2020-05-03T00:00:00Z | 92500 | 7725 | 290 | 1 | 291 | 0 | 92500 | posNeg | 291 | 92500 | 2 | 12 | c12a951677090426a3f7121665ac75d7abebd01a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
8179 | 8179 | 20200503 | AR | 3431 | 49459 | 52890 | 100 | 427 | 20 | 88 | 1999 | B | 5/3/2020 13:30 | 2020-05-03T13:30:00Z | 05/03 09:30 | 76 | 427 | 2020-05-03T13:30:00Z | 52890 | 3431 | 5 | 59 | 1249 | 52890 | posNeg | 1308 | 52890 | 3 | 13 | 38169c4478088effd5632f0afe442423954a7ed5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
8181 | 8181 | 20200503 | AZ | 8640 | 72479 | 81119 | 732 | 2089 | 282 | 192 | 1597 | A+ | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 362 | 2089 | 2020-05-03T00:00:00Z | 81119 | 4 | 276 | 2846 | 81119 | posNeg | 3122 | 81119 | 14 | 56 | 798468bf25bcf74e7981936a299cfb4e66543af0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
8182 | 8182 | 20200503 | CA | 53616 | 662135 | 715751 | 4734 | 1468 | B | 5/3/2020 14:00 | 2020-05-03T14:00:00Z | 05/03 10:00 | 2215 | 2020-05-03T14:00:00Z | 715751 | 53616 | 6 | 1419 | 27529 | 715751 | posNeg | 30703 | 715751 | 44 | 0 | 668fb4bb75ff78beb807f16f823ab8838f54c97b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
8188 | 8188 | 20200503 | GA | 28602 | 146494 | 174800 | 1410 | 5393 | 1249 | A | 5/3/2020 10:25 | 2020-05-03T10:25:00Z | 05/03 06:25 | 1177 | 5393 | 2020-05-03T10:25:00Z | 174800 | 28602 | 13 | 296 | 0 | 175096 | posNeg | 0 | 175096 | 3 | 6 | 0bfd0beb05040533c2ed190692c1f156ec33debe | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
8189 | 8189 | 20200503 | GU | 150 | 3152 | 3302 | 126 | F | 5/3/2020 06:20 | 2020-05-03T06:20:00Z | 05/03 02:20 | 5 | 2020-05-03T06:20:00Z | 146 | 66 | 2 | 112 | 3302 | posNeg | 114 | 3302 | 0 | 0 | e28e1db0b1fa1dd0099a1ceabb40118d79a38a27 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8195 | 8195 | 20200503 | KS | 5030 | 31748 | 36778 | 547 | 209 | 95 | 286 | A | 5/3/2020 10:00 | 2020-05-03T10:00:00Z | 05/03 06:00 | 134 | 547 | 2020-05-03T10:00:00Z | 20 | 284 | 1552 | 36778 | posNeg | 1836 | 36778 | 3 | 6 | f7ba9f52521c5bd92b71ae853ff3e645094bc78e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8197 | 8197 | 20200503 | LA | 29340 | 146820 | 176160 | 1530 | 213 | 17303 | B | 5/3/2020 13:00 | 2020-05-03T13:00:00Z | 05/03 09:00 | 1969 | 2020-05-03T13:00:00Z | 29340 | 1845 | 22 | 200 | 3102 | 176160 | posNeg | 3302 | 176160 | 19 | 0 | 05b1edfcad540fd05302c87b2cc744774b775f71 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8198 | 8198 | 20200503 | MA | 68087 | 246559 | 386680 | 3617 | 6507 | 904 | A | 5/3/2020 16:00 | 2020-05-03T16:00:00Z | 05/03 12:00 | 4004 | 6507 | 2020-05-03T16:00:00Z | 386680 | 82450 | 68087 | 4004 | 25 | 1824 | 13828 | 314646 | totalTestsViral | 6462 | 314646 | 158 | 129 | f1dc03b65a0c1d303a5e5a2f0a25d2b08d3216a2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
8199 | 8199 | 20200503 | MD | 25462 | 107332 | 132794 | 1635 | 5051 | 565 | 1666 | A | 5/3/2020 10:00 | 2020-05-03T10:00:00Z | 05/03 06:00 | 1372 | 5051 | 2020-05-03T10:00:00Z | 133367 | 29716 | 25462 | 1302 | 70 | 24 | 989 | 6283 | 132794 | posNeg | 7272 | 132794 | 49 | 141 | a2e1f45e9dc857956f33eb19a88b8daccce071f1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
8200 | 8200 | 20200503 | ME | 1185 | 19546 | 20731 | 33 | 183 | 18 | 12 | 706 | B | 5/3/2020 11:45 | 2020-05-03T11:45:00Z | 05/03 07:45 | 57 | 183 | 2020-05-03T11:45:00Z | 1185 | 57 | 23 | 33 | 0 | 20731 | posNeg | 33 | 20731 | 1 | 2 | e6ff02088bfe36007d0925273a0bd92b45657abf | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
8201 | 8201 | 20200503 | MI | 49029 | 195361 | 244390 | 2100 | 850 | 713 | 15659 | A+ | 5/3/2020 11:00 | 2020-05-03T11:00:00Z | 05/03 07:00 | 4641 | 2020-05-03T11:00:00Z | 250589 | 55228 | 195361 | 46783 | 4516 | 205 | 26 | 357 | 6648 | 244390 | posNeg | 7005 | 244390 | 62 | 0 | 2bf3843af08b971fde5f9385a65275e578aaa3cb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
8203 | 8203 | 20200503 | MO | 8386 | 74590 | 82976 | 896 | 141 | A | 5/3/2020 15:00 | 2020-05-03T15:00:00Z | 05/03 11:00 | 352 | 2020-05-03T15:00:00Z | 97614 | 10227 | 87215 | 8386 | 2443 | 105 | 2337 | 29 | 232 | 0 | 82976 | posNeg | 232 | 82976 | 1 | 0 | f17d953a637eac21474528c482e39041c6e1fd35 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
8204 | 8204 | 20200503 | MP | 14 | 1321 | 1335 | 12 | D | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 2 | 2020-05-03T00:00:00Z | 14 | 69 | 0 | 387 | 1335 | posNeg | 387 | 1335 | 0 | 0 | d818bd3dc0da8c6d07fbcc4984d1589b0d08539c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8206 | 8206 | 20200503 | MT | 455 | 14552 | 15007 | 5 | 61 | 404 | C | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 16 | 61 | 2020-05-03T00:00:00Z | 15007 | 455 | 30 | 0 | 372 | 15007 | posNeg | 372 | 15007 | 0 | 0 | f73c9ef207f3bcd32e320a275e5355de90601140 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
8207 | 8207 | 20200503 | NC | 11664 | 132171 | 143835 | 475 | B | 5/3/2020 11:00 | 2020-05-03T11:00:00Z | 05/03 07:00 | 422 | 2020-05-03T11:00:00Z | 11664 | 422 | 37 | 155 | 4205 | 143835 | posNeg | 4360 | 143835 | 2 | 0 | 815955c42b54c9b3d718fd5b55c7c94705d471da | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8208 | 8208 | 20200503 | ND | 1191 | 32162 | 35095 | 31 | 90 | 517 | C | 5/3/2020 13:00 | 2020-05-03T13:00:00Z | 05/03 09:00 | 16 | 90 | 2020-05-03T13:00:00Z | 35636 | 1191 | 16 | 35095 | 32083 | 38 | 38 | 1768 | 33353 | totalTestEncountersViral | 1889 | 33353 | -8 | 0 | 9190c04dfc9bcbb42049e4a50451cd62e84612aa | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
8211 | 8211 | 20200503 | NJ | 126744 | 148322 | 641 | 275066 | 5317 | 1623 | 1198 | 15642 | A+ | 5/3/2020 13:00 | 2020-05-03T13:00:00Z | 05/03 09:00 | 9384 | 2020-05-03T13:00:00Z | 126744 | 7871 | 1513 | 275066 | 34 | 3027 | 9727 | 275707 | posNeg | 12754 | 275066 | 154 | 0 | 0c77c4a13af18448b9887f3707c17b0388facfc7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
8213 | 8213 | 20200503 | NV | 5423 | 39843 | 45266 | 182 | D | 5/3/2020 10:00 | 2020-05-03T10:00:00Z | 05/03 06:00 | 287 | 2020-05-03T10:00:00Z | 56107 | 5423 | 32 | 112 | 767 | 45266 | posNeg | 879 | 45266 | 6 | 0 | 7b426a58bc25f672729eac50a7af60362c5dd1e7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8214 | 8214 | 20200503 | NY | 316415 | 669496 | 985911 | 9786 | 79768 | 3430 | 58950 | B | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 19189 | 79768 | 2020-05-03T00:00:00Z | 316415 | 36 | 3438 | 23402 | 985911 | posNeg | 26840 | 985911 | 280 | 826 | 01f40b3df25c608a9aab347e5c141aac6518d573 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
8215 | 8215 | 20200503 | OH | 19914 | 130252 | 150166 | 931 | 3769 | 393 | 1078 | 255 | B | 5/3/2020 14:00 | 2020-05-03T14:00:00Z | 05/03 10:00 | 1038 | 3769 | 2020-05-03T14:00:00Z | 145021 | 19094 | 957 | 81 | 39 | 579 | 3768 | 150166 | posNeg | 4347 | 150166 | 17 | 57 | 675c6915111d17723bfc245da2433ff62225a338 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
8216 | 8216 | 20200503 | OK | 3972 | 59804 | 63776 | 236 | 743 | 92 | 2635 | A | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 238 | 743 | 2020-05-03T00:00:00Z | 70368 | 4150 | 66084 | 3972 | 40 | 121 | 0 | 63776 | posNeg | 121 | 63776 | 0 | 0 | 2cb74d001c83ecf541da217c28179d69c31dccaa | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
8217 | 8217 | 20200503 | OR | 2680 | 59374 | 62054 | 205 | 598 | 46 | 21 | 860 | A+ | 5/3/2020 11:00 | 2020-05-03T11:00:00Z | 05/03 07:00 | 109 | 598 | 2020-05-03T11:00:00Z | 41 | 45 | 1873 | 62054 | posNeg | 1918 | 62054 | 0 | 3 | ca7bd76b6981dc61747d2529e16ae9cbe56af4cd | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
8218 | 8218 | 20200503 | PA | 49267 | 191374 | 240641 | 2645 | 562 | B | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 2444 | 2020-05-03T00:00:00Z | 240641 | 42 | 962 | 4303 | 240641 | posNeg | 5265 | 240641 | 26 | 0 | 6232ba332e8fc27602bcffb31fb967cc731a08c3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8219 | 8219 | 20200503 | PR | 1808 | 9313 | 11121 | 171 | D | 5/3/2020 06:00 | 2020-05-03T06:00:00Z | 05/03 02:00 | 97 | 2020-05-03T06:00:00Z | 988 | 53 | 820 | 72 | 51 | 0 | 11121 | posNeg | 51 | 11121 | 2 | 0 | d50c85910af01a7c65aa3095921d0f565e67cf8c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
8220 | 8220 | 20200503 | RI | 9703 | 55233 | 75274 | 330 | 1013 | 83 | 59 | 565 | A+ | 5/3/2020 03:00 | 2020-05-03T03:00:00Z | 05/02 23:00 | 320 | 1013 | 2020-05-03T03:00:00Z | 77910 | 11036 | 66874 | 9703 | 75274 | 64936 | 44 | 181 | 1610 | 64936 | totalTestEncountersViral | 2183 | 64936 | 24 | 36 | 2802926f258152aa86ed0c28b5b57e91b42802d6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
8221 | 8221 | 20200503 | SC | 6626 | 57562 | 64188 | 1110 | 3622 | B | 5/3/2020 15:30 | 2020-05-03T15:30:00Z | 05/03 11:30 | 275 | 1110 | 2020-05-03T15:30:00Z | 6626 | 45 | 137 | 2435 | 64188 | posNeg | 2572 | 64188 | 8 | 0 | 0df4ab5359e7ce38b17a57bc43c3151d9e3c7489 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
8223 | 8223 | 20200503 | TN | 13177 | 191430 | 204607 | 510 | 1135 | 5814 | B | 5/3/2020 15:00 | 2020-05-03T15:00:00Z | 05/03 11:00 | 210 | 1135 | 2020-05-03T15:00:00Z | 13177 | 47 | 516 | 7815 | 204607 | posNeg | 8331 | 204607 | 1 | 10 | 76a3dd46683630c76fbc86e4bb0e20ae874c8e70 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8225 | 8225 | 20200503 | UT | 5175 | 116927 | 122102 | 436 | 2238 | C | 5/3/2020 15:00 | 2020-05-03T15:00:00Z | 05/03 11:00 | 50 | 436 | 2020-05-03T15:00:00Z | 5175 | 49 | 194 | 4104 | 122102 | posNeg | 4298 | 122102 | 1 | 18 | 159f58007f27671126273a2e4ca34d534c4dac55 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
8227 | 8227 | 20200503 | VI | 66 | 951 | 29 | 1017 | 51 | C | 5/3/2020 08:04 | 2020-05-03T08:04:00Z | 05/03 04:04 | 4 | 2020-05-03T08:04:00Z | 78 | 0 | 29 | 1046 | posNeg | 29 | 1017 | 0 | 0 | 5ad65f22d26d8a3598c710f073c3078317c6418f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8228 | 8228 | 20200503 | VT | 901 | 15570 | 16471 | 19 | C | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 52 | 2020-05-03T00:00:00Z | 897 | 50 | 5 | 338 | 16471 | posNeg | 343 | 16471 | 1 | 0 | d6f558c55d88c0fdb692722fe0a326d7489d056c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8229 | 8229 | 20200503 | WA | 16132 | 213668 | 229800 | 411 | 120 | B | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 830 | 2020-05-03T00:00:00Z | 16132 | 229800 | 213630 | 53 | 84 | 1713 | 229800 | posNeg | 1797 | 229800 | 6 | 0 | 57c5479eb46c7c05ec138e6cd59dabf5fc37cebb | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8230 | 8230 | 20200503 | WI | 9227 | 77997 | 231 | 87224 | 348 | 1608 | 116 | 402 | 3723 | A+ | 5/3/2020 00:00 | 2020-05-03T00:00:00Z | 05/02 20:00 | 339 | 1608 | 2020-05-03T00:00:00Z | 7964 | 55 | 307 | 2427 | 87455 | posNeg | 2734 | 87224 | 5 | 17 | 3fe1ab67595bd179fec9fc362d351f8d6303bd5c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
8231 | 8231 | 20200503 | WV | 1191 | 50447 | 51638 | 73 | 28 | 15 | 611 | C | 5/3/2020 10:00 | 2020-05-03T10:00:00Z | 05/03 06:00 | 50 | 2020-05-03T10:00:00Z | 51638 | 1191 | 54 | 22 | 2470 | 51638 | posNeg | 2492 | 51638 | 2 | 0 | 148ab598b4810db53b1a8aebd0577daec0aada32 | 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 );