states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
73 rows where "dateModified" is on date 2020-03-16 sorted by hash
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, hospitalizedCurrently, hospitalizedCumulative, death, hospitalized, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, positiveIncrease, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10883 | 10883 | 20200316 | KS | 11 | 166 | 177 | 3/16/2020 16:17 | 2020-03-16T16:17:00Z | 03/16 12:17 | 1 | 2020-03-16T16:17:00Z | 20 | 3 | 31 | 177 | posNeg | 34 | 177 | 0 | 0 | 06627be056014d2ec679aebcd3d7b78dff45f858 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10815 | 10815 | 20200317 | CO | 160 | 1056 | 1007 | 3/16/2020 17:00 | 2020-03-16T17:00:00Z | 03/16 13:00 | 1 | 2020-03-16T17:00:00Z | 1007 | 8 | 29 | 429 | 1216 | totalTestEncountersViral | 303 | 1216 | 0 | 0 | 0918f15d41c23409f9046bc1e4813859a4da3aab | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10880 | 10880 | 20200316 | ID | 5 | 265 | 270 | 3/16/2020 15:42 | 2020-03-16T15:42:00Z | 03/16 11:42 | 2020-03-16T15:42:00Z | 270 | 16 | 0 | 91 | 270 | posNeg | 91 | 270 | 0 | 0 | 0a8954ca4324aac5da2d690a53ddcd082cc26b5b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10901 | 10901 | 20200316 | NV | 63 | 168 | 231 | 3/16/2020 15:16 | 2020-03-16T15:16:00Z | 03/16 11:16 | 1 | 2020-03-16T15:16:00Z | 63 | 32 | 18 | 0 | 231 | posNeg | 18 | 231 | 0 | 0 | 0f254b14cfca0127bdffd84a7e2a1a9f14c15e3a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10895 | 10895 | 20200316 | NC | 33 | 296 | 151 | 329 | 3/16/2020 15:33 | 2020-03-16T15:33:00Z | 03/16 11:33 | 0 | 2020-03-16T15:33:00Z | 37 | 1 | 69 | 480 | posNeg | 70 | 329 | 0 | 0 | 16b3f9d36433cacb2c4e015bb602d192d568229a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10918 | 10918 | 20200316 | WI | 56 | 504 | 560 | 3/16/2020 15:06 | 2020-03-16T15:06:00Z | 03/16 11:06 | 2020-03-16T15:06:00Z | 47 | 55 | 19 | 191 | 560 | posNeg | 210 | 560 | 0 | 0 | 17415977e57cd45e6b173711326aaae31cfc13de | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10920 | 10920 | 20200316 | WY | 3 | 3 | 3/16/2020 15:04 | 2020-03-16T15:04:00Z | 03/16 11:04 | 2020-03-16T15:04:00Z | 3 | 56 | 0 | 0 | 3 | posNeg | 0 | 3 | 0 | 0 | 1cde4691ad1dce52a1e6d88c98616f0f1e58e019 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10814 | 10814 | 20200317 | CA | 483 | 7981 | 8464 | 3/16/2020 21:00 | 2020-03-16T21:00:00Z | 03/16 17:00 | 11 | 2020-03-16T21:00:00Z | 8464 | 6 | 148 | 0 | 8464 | posNeg | 148 | 8464 | 5 | 0 | 212bc71101ae5ab554a847cb268146bed3b335c7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10909 | 10909 | 20200316 | SC | 28 | 235 | 263 | 3/16/2020 15:24 | 2020-03-16T15:24:00Z | 03/16 11:24 | 1 | 2020-03-16T15:24:00Z | 28 | 45 | 9 | 81 | 263 | posNeg | 90 | 263 | 1 | 0 | 22be8074215010bcfb570c5b4c6e5b29481582df | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10912 | 10912 | 20200316 | TX | 57 | 57 | 3/16/2020 15:21 | 2020-03-16T15:21:00Z | 03/16 11:21 | 2020-03-16T15:21:00Z | 57 | 48 | 1 | 0 | 57 | posNeg | 1 | 57 | 0 | 0 | 22d1003c0f1ab295965256b0e527d02b50728e0b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10882 | 10882 | 20200316 | IN | 24 | 115 | 139 | 3/16/2020 15:44 | 2020-03-16T15:44:00Z | 03/16 11:44 | 1 | 2020-03-16T15:44:00Z | 18 | 5 | 13 | 139 | posNeg | 18 | 139 | 1 | 0 | 243add41370094956dc427f4697358ff3f6f3ac5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10867 | 10867 | 20200316 | AR | 22 | 132 | 14 | 154 | 3/16/2020 15:08 | 2020-03-16T15:08:00Z | 03/16 11:08 | 2020-03-16T15:08:00Z | 154 | 22 | 5 | 6 | 29 | 168 | posNeg | 35 | 154 | 0 | 0 | 2e0f9078f465b5901105847f4f03cdc5712b801c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10868 | 10868 | 20200316 | AS | 0 | 3/16/2020 15:54 | 2020-03-16T15:54:00Z | 03/16 11:54 | 2020-03-16T15:54:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 2ea05f0107d5019c4f6a6ef683067a9f95cfc7b2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10919 | 10919 | 20200316 | WV | 0 | 80 | 4 | 80 | 3/16/2020 15:53 | 2020-03-16T15:53:00Z | 03/16 11:53 | 0 | 2020-03-16T15:53:00Z | 0 | 54 | 0 | 42 | 84 | posNeg | 42 | 80 | 0 | 0 | 30c216177a65cf2b6c474043239095bdada6bb2c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10873 | 10873 | 20200316 | DC | 17 | 96 | 7 | 113 | 3/16/2020 15:36 | 2020-03-16T15:36:00Z | 03/16 11:36 | 2020-03-16T15:36:00Z | 113 | 11 | 1 | 17 | 120 | posNeg | 18 | 113 | 0 | 0 | 370d2526043e88bfcb535e9bee7938d73cb730c5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10907 | 10907 | 20200316 | PR | 5 | 9 | 14 | 3/16/2020 15:44 | 2020-03-16T15:44:00Z | 03/16 11:44 | 2020-03-16T15:44:00Z | 72 | 0 | 0 | 14 | posNeg | 0 | 14 | 0 | 0 | 3ddf5bb7e91365bdaf8ce3d89de3ad5735d20229 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10830 | 10830 | 20200317 | MA | 118 | 1633 | 9145 | 3/16/2020 16:00 | 2020-03-16T16:00:00Z | 03/16 12:00 | 2020-03-16T16:00:00Z | 9145 | 787 | 25 | 21 | 434 | 1751 | totalTestsViral | 2790 | 1751 | 0 | 0 | 3e5ff6dd51d15722795a23e6d8eab78a0cbc2da1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10910 | 10910 | 20200316 | SD | 10 | 494 | 0 | 504 | 3/16/2020 15:40 | 2020-03-16T15:40:00Z | 03/16 11:40 | 2020-03-16T15:40:00Z | 504 | 46 | 1 | 167 | 504 | posNeg | 168 | 504 | 0 | 0 | 4269cc05fd70d70b5fcb593032e4457f55e28659 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10914 | 10914 | 20200316 | VA | 51 | 438 | 6827 | 3/16/2020 16:09 | 2020-03-16T16:09:00Z | 03/16 12:09 | 1 | 2020-03-16T16:09:00Z | 2107 | 6827 | 51 | 6 | 75 | 489 | posNeg | 88 | 489 | 0 | 0 | 534825270bb63e93aaa64178c03d928aaab54147 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10816 | 10816 | 20200317 | CT | 41 | 125 | 166 | 3/16/2020 17:00 | 2020-03-16T17:00:00Z | 03/16 13:00 | 2020-03-16T17:00:00Z | 9 | 15 | 0 | 166 | posNeg | 15 | 166 | 0 | 0 | 54d84204dbcf45498f63f24a12e1329e84f0134d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10902 | 10902 | 20200316 | NY | 950 | 4543 | 5493 | 3/16/2020 16:22 | 2020-03-16T16:22:00Z | 03/16 12:22 | 7 | 2020-03-16T16:22:00Z | 36 | 221 | 0 | 5493 | posNeg | 221 | 5493 | 4 | 0 | 57192425ff18a2bbdcee76572c02b2844c40fe93 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10890 | 10890 | 20200316 | MN | 179 | 1839 | 2018 | 3/16/2020 15:52 | 2020-03-16T15:52:00Z | 03/16 11:52 | 2020-03-16T15:52:00Z | 179 | 2018 | 27 | 51 | 452 | 2018 | posNeg | 503 | 2018 | 0 | 0 | 5851f8527f0d2cfc7d1736895a31049168f374be | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10911 | 10911 | 20200316 | TN | 52 | 270 | 322 | 3/16/2020 15:23 | 2020-03-16T15:23:00Z | 03/16 11:23 | 2020-03-16T15:23:00Z | 47 | 13 | 113 | 322 | posNeg | 126 | 322 | 0 | 0 | 596e09c7bc509d7b2bdff241c147cb5cd89a0e89 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10828 | 10828 | 20200317 | KY | 22 | 295 | 317 | 3/16/2020 16:00 | 2020-03-16T16:00:00Z | 03/16 12:00 | 1 | 2020-03-16T16:00:00Z | 317 | 21 | 1 | 61 | 317 | posNeg | 62 | 317 | 0 | 0 | 5db991df0fbb4eb5a33a1cb2689c901e88919b73 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10822 | 10822 | 20200317 | HI | 10 | 10 | 3/16/2020 18:00 | 2020-03-16T18:00:00Z | 03/16 14:00 | 2020-03-16T18:00:00Z | 15 | 3 | 0 | 10 | posNeg | 3 | 10 | 0 | 0 | 685cc8a7fd357cc2b366c74d93a09e0be310e15a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10870 | 10870 | 20200316 | CA | 335 | 7981 | 8316 | 3/16/2020 15:10 | 2020-03-16T15:10:00Z | 03/16 11:10 | 6 | 2020-03-16T15:10:00Z | 8316 | 6 | 42 | 7065 | 8316 | posNeg | 7107 | 8316 | 1 | 0 | 724cd08865e3af3a27d936af476abf741403accc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10859 | 10859 | 20200317 | VI | 2 | 2 | 3/16/2020 00:01 | 2020-03-16T00:01:00Z | 03/15 20:01 | 2020-03-16T00:01:00Z | 78 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | 760bd14d5188b85c2b0efd761f31c1d1e66c4bd8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10899 | 10899 | 20200316 | NJ | 178 | 120 | 20 | 298 | 3/16/2020 15:08 | 2020-03-16T15:08:00Z | 03/16 11:08 | 2 | 2020-03-16T15:08:00Z | 178 | 2 | 0 | 298 | 34 | 80 | 0 | 318 | posNeg | 80 | 298 | 0 | 0 | 76a83e8c3a6a78d4efff2e81334ad46e52026d0d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
10896 | 10896 | 20200316 | ND | 1 | 123 | 0 | 96 | 3/16/2020 15:45 | 2020-03-16T15:45:00Z | 03/16 11:45 | 0 | 2020-03-16T15:45:00Z | 109 | 1 | 96 | 93 | 38 | 0 | 28 | 124 | totalTestEncountersViral | 22 | 124 | 0 | 0 | 76b281300638f0a0a4191ef65be40784ea384fc4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
10876 | 10876 | 20200316 | GA | 121 | 121 | 3/16/2020 15:19 | 2020-03-16T15:19:00Z | 03/16 11:19 | 1 | 2020-03-16T15:19:00Z | 121 | 13 | 22 | 0 | 121 | posNeg | 22 | 121 | 0 | 0 | 790a181460ed19f4043d5e18d792314b11c25c7e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10875 | 10875 | 20200316 | FL | 141 | 684 | 514 | 825 | 3/16/2020 16:13 | 2020-03-16T16:13:00Z | 03/16 12:13 | 4 | 2020-03-16T16:13:00Z | 12 | 25 | 6 | 1339 | posNeg | 31 | 825 | 0 | 0 | 865384872b1490a145a5059168330f1d364e2169 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10906 | 10906 | 20200316 | PA | 76 | 670 | 746 | 3/16/2020 15:28 | 2020-03-16T15:28:00Z | 03/16 11:28 | 2020-03-16T15:28:00Z | 746 | 42 | 13 | 465 | 746 | posNeg | 478 | 746 | 0 | 0 | 8ef967654c6c5be4e100b2ca71dba6661a36d6ca | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10903 | 10903 | 20200316 | OH | 50 | 140 | 361 | 190 | 3/16/2020 15:36 | 2020-03-16T15:36:00Z | 03/16 11:36 | 2020-03-16T15:36:00Z | 50 | 39 | 14 | 1 | 551 | posNeg | 15 | 190 | 0 | 0 | 907a6b1a482615f185f8c6daf4be48f7ebfa8803 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10893 | 10893 | 20200316 | MS | 12 | 277 | 289 | 3/16/2020 15:52 | 2020-03-16T15:52:00Z | 03/16 11:52 | 2020-03-16T15:52:00Z | 28 | 2 | 193 | 289 | posNeg | 195 | 289 | 0 | 0 | 923c5a7cec775e4218fb3b4bc5d9b50d97d0a01d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10885 | 10885 | 20200316 | LA | 115 | 188 | 303 | 3/16/2020 15:50 | 2020-03-16T15:50:00Z | 03/16 11:50 | 2 | 2020-03-16T15:50:00Z | 115 | 22 | 25 | 32 | 303 | posNeg | 57 | 303 | 0 | 0 | 946cfc6ef7f3181a46f2c8a878b1403cb77bf0d3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10913 | 10913 | 20200316 | UT | 39 | 131 | 170 | 3/16/2020 15:17 | 2020-03-16T15:17:00Z | 03/16 11:17 | 0 | 2020-03-16T15:17:00Z | 39 | 49 | 11 | 0 | 170 | posNeg | 11 | 170 | 0 | 0 | 9554cfc0455c738754c86b7a98f0c25f671da29a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10887 | 10887 | 20200316 | MD | 37 | 94 | 131 | 3/16/2020 15:49 | 2020-03-16T15:49:00Z | 03/16 11:49 | 2 | 2020-03-16T15:49:00Z | 37 | 24 | 6 | 0 | 131 | posNeg | 6 | 131 | 2 | 0 | 9623fd2867dfa4ad52769317223ff84df347d35a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10908 | 10908 | 20200316 | RI | 22 | 455 | 149 | 402 | 3/16/2020 03:00 | 2020-03-16T03:00:00Z | 03/15 23:00 | 2020-03-16T03:00:00Z | 499 | 24 | 475 | 22 | 402 | 477 | 44 | 2 | 91 | 626 | totalTestEncountersViral | 55 | 477 | 0 | 0 | 966c0583d5e79fc97bd7c1ae4ad5b59296b02783 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
10874 | 10874 | 20200316 | DE | 8 | 36 | 32 | 44 | 3/16/2020 15:37 | 2020-03-16T15:37:00Z | 03/16 11:37 | 0 | 2020-03-16T15:37:00Z | 0 | 0 | 10 | 2 | 0 | 76 | posNeg | 2 | 44 | 0 | 0 | 99650f7ff7dab75fbc55386ab0ef190e4db04404 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10904 | 10904 | 20200316 | OK | 10 | 174 | 29 | 184 | 3/16/2020 15:37 | 2020-03-16T15:37:00Z | 03/16 11:37 | 2020-03-16T15:37:00Z | 40 | 1 | 56 | 213 | posNeg | 57 | 184 | 0 | 0 | 9d75283aedf2dec48976cfd86124fda7fd8a5ca4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10894 | 10894 | 20200316 | MT | 7 | 198 | 205 | 3/16/2020 15:51 | 2020-03-16T15:51:00Z | 03/16 11:51 | 2020-03-16T15:51:00Z | 30 | 0 | 95 | 205 | posNeg | 95 | 205 | 0 | 0 | a110b08a79c49e6a9d0318d1af1ea19666fae8aa | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10818 | 10818 | 20200317 | DE | 16 | 36 | 52 | 3/16/2020 11:40 | 2020-03-16T11:40:00Z | 03/16 07:40 | 0 | 2020-03-16T11:40:00Z | 0 | 0 | 10 | 8 | 0 | 52 | posNeg | 8 | 52 | 0 | 0 | a2bfed770df57173b48d08f56a5d993b27b1aab3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10917 | 10917 | 20200316 | WA | 1582 | 23473 | 25055 | 3/16/2020 00:00 | 2020-03-16T00:00:00Z | 03/15 20:00 | 69 | 2020-03-16T00:00:00Z | 1582 | 25055 | 24516 | 53 | 300 | 4696 | 25055 | posNeg | 4996 | 25055 | 12 | 0 | a8a54d9c9e6df5ab2780d47bfc39fbfac54cde2b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10866 | 10866 | 20200316 | AL | 28 | 28 | 40 | 56 | 3/16/2020 15:08 | 2020-03-16T15:08:00Z | 03/16 11:08 | 0 | 2020-03-16T15:08:00Z | 56 | 28 | 1 | 16 | 0 | 96 | posNeg | 16 | 56 | 0 | 0 | a91c8113692316689ad7ade23080c1adf5e36ec2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10884 | 10884 | 20200316 | KY | 21 | 234 | 255 | 3/16/2020 15:45 | 2020-03-16T15:45:00Z | 03/16 11:45 | 1 | 2020-03-16T15:45:00Z | 255 | 21 | 5 | 95 | 255 | posNeg | 100 | 255 | 0 | 0 | a9a01d3164528a06064947616a23952931cd01e1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10863 | 10863 | 20200317 | WV | 0 | 80 | 4 | 80 | 3/16/2020 00:00 | 2020-03-16T00:00:00Z | 03/15 20:00 | 0 | 2020-03-16T00:00:00Z | 0 | 54 | 0 | 0 | 84 | posNeg | 0 | 80 | 0 | 0 | b35a021f826cfcd507f0fa491f489e959956bf7e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10879 | 10879 | 20200316 | IA | 22 | 83 | 105 | 3/16/2020 15:41 | 2020-03-16T15:41:00Z | 03/16 11:41 | 2020-03-16T15:41:00Z | 22 | 19 | 4 | 0 | 105 | posNeg | 4 | 105 | 0 | 0 | b76b3e3e89d3288b478e6f15aea9eed3d4cbfed5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10891 | 10891 | 20200316 | MO | 6 | 164 | 170 | 3/16/2020 15:52 | 2020-03-16T15:52:00Z | 03/16 11:52 | 0 | 2020-03-16T15:52:00Z | 287 | 29 | 257 | 6 | 29 | 1 | 42 | 170 | posNeg | 43 | 170 | 0 | 0 | b7f45280b72e898e9323d6613b09fb1984d153b9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10886 | 10886 | 20200316 | MA | 97 | 1199 | 6355 | 3/16/2020 15:48 | 2020-03-16T15:48:00Z | 03/16 11:48 | 2020-03-16T15:48:00Z | 6355 | 532 | 25 | 33 | 615 | 1296 | totalTestsViral | 2235 | 1296 | 0 | 0 | b8513fd07b11aa68e2c83b77d982bfbb719f33d3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10888 | 10888 | 20200316 | ME | 17 | 764 | 781 | 3/16/2020 15:51 | 2020-03-16T15:51:00Z | 03/16 11:51 | 2020-03-16T15:51:00Z | 17 | 23 | 14 | 673 | 781 | posNeg | 687 | 781 | 0 | 0 | b94eb1f78ba99c4203abf05ee8ad3dc029073568 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10817 | 10817 | 20200317 | DC | 22 | 104 | 0 | 126 | 3/16/2020 19:00 | 2020-03-16T19:00:00Z | 03/16 15:00 | 2020-03-16T19:00:00Z | 126 | 11 | 5 | 8 | 126 | posNeg | 13 | 126 | 0 | 0 | b997ab3acabc7ac21d3e9adcd63b3583eb2f9988 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10849 | 10849 | 20200317 | OR | 47 | 689 | 184 | 736 | 3/16/2020 13:51 | 2020-03-16T13:51:00Z | 03/16 09:51 | 2020-03-16T13:51:00Z | 41 | 8 | 110 | 920 | posNeg | 118 | 736 | 0 | 0 | be572171fa8a41f2b5bea36f03520f103887ac4d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10835 | 10835 | 20200317 | MO | 8 | 207 | 215 | 3/16/2020 20:00 | 2020-03-16T20:00:00Z | 03/16 16:00 | 0 | 2020-03-16T20:00:00Z | 405 | 39 | 365 | 8 | 29 | 2 | 43 | 215 | posNeg | 45 | 215 | 0 | 0 | be9bd1a0ea93854d57acb364acab597f680836c3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10865 | 10865 | 20200316 | AK | 1 | 143 | 144 | 3/16/2020 15:06 | 2020-03-16T15:06:00Z | 03/16 11:06 | 0 | 2020-03-16T15:06:00Z | 144 | 1 | 2 | 0 | 0 | 144 | posNeg | 0 | 144 | 0 | 0 | c6b44fe48e853d15ca56ad89b5bd2041b881b867 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10892 | 10892 | 20200316 | MP | 0 | 0 | 3/16/2020 15:55 | 2020-03-16T15:55:00Z | 03/16 11:55 | 2020-03-16T15:55:00Z | 69 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | c79f2e8b65184b9fa4574f63eca39a5222b29cf2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10898 | 10898 | 20200316 | NH | 13 | 271 | 95 | 526 | 3/16/2020 15:12 | 2020-03-16T15:12:00Z | 03/16 11:12 | 2020-03-16T15:12:00Z | 526 | 33 | 0 | 0 | 379 | posNeg | 121 | 284 | 0 | 0 | cbc59ca1a00e07dad6796794dcb6b78d910a79d9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10846 | 10846 | 20200317 | NY | 1700 | 5506 | 7206 | 325 | 3/16/2020 15:00 | 2020-03-16T15:00:00Z | 03/16 11:00 | 7 | 2020-03-16T15:00:00Z | 36 | 750 | 963 | 7206 | posNeg | 1713 | 7206 | 0 | 0 | ccdb9c07a86d938c7491050509225e5c235b3a78 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10897 | 10897 | 20200316 | NE | 18 | 170 | 188 | 3/16/2020 15:32 | 2020-03-16T15:32:00Z | 03/16 11:32 | 2020-03-16T15:32:00Z | 31 | 1 | 90 | 188 | posNeg | 91 | 188 | 0 | 0 | d020e135dc9bc882dc473dc61362e0ea12d841ce | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10881 | 10881 | 20200316 | IL | 93 | 932 | 1025 | 3/16/2020 15:43 | 2020-03-16T15:43:00Z | 03/16 11:43 | 2020-03-16T15:43:00Z | 17 | 29 | 483 | 1025 | posNeg | 512 | 1025 | 0 | 0 | d1fb61ee5b5e92bab87664fc2188554a01511429 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10872 | 10872 | 20200316 | CT | 26 | 125 | 151 | 3/16/2020 15:36 | 2020-03-16T15:36:00Z | 03/16 11:36 | 2020-03-16T15:36:00Z | 9 | 6 | 0 | 151 | posNeg | 6 | 151 | 0 | 0 | d8f433060b37e5480a8302ef827e9753ead71526 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10842 | 10842 | 20200317 | NH | 17 | 355 | 195 | 686 | 3/16/2020 09:00 | 2020-03-16T09:00:00Z | 03/16 05:00 | 2020-03-16T09:00:00Z | 686 | 33 | 4 | 84 | 567 | posNeg | 160 | 372 | 0 | 0 | da8a77876f339c02eb92b6c7a8ca02d09616cb6f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10838 | 10838 | 20200317 | MT | 8 | 303 | 311 | 3/16/2020 21:22 | 2020-03-16T21:22:00Z | 03/16 17:22 | 2020-03-16T21:22:00Z | 30 | 1 | 105 | 311 | posNeg | 106 | 311 | 0 | 0 | dacea260c55033f7087e20e7c727e4808b4de0f7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10905 | 10905 | 20200316 | OR | 39 | 579 | 182 | 618 | 3/16/2020 15:38 | 2020-03-16T15:38:00Z | 03/16 11:38 | 2020-03-16T15:38:00Z | 41 | 3 | 159 | 800 | posNeg | 162 | 618 | 0 | 0 | dbe1a66f359bd370dc95b9f9d7a1197c3f8bf3f4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10826 | 10826 | 20200317 | IN | 30 | 129 | 159 | 3/16/2020 23:59 | 2020-03-16T23:59:00Z | 03/16 19:59 | 2 | 2020-03-16T23:59:00Z | 18 | 6 | 14 | 159 | posNeg | 20 | 159 | 1 | 0 | e1ef7ac50adc73acf7bbe7525357d76c679f5bb9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10871 | 10871 | 20200316 | CO | 131 | 627 | 704 | 3/16/2020 15:35 | 2020-03-16T15:35:00Z | 03/16 11:35 | 1 | 2020-03-16T15:35:00Z | 704 | 8 | 0 | 0 | 758 | totalTestEncountersViral | 179 | 758 | 0 | 0 | e25a0221169c9fae78e52ac4160b728ff5f3915b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10916 | 10916 | 20200316 | VT | 17 | 487 | 504 | 3/16/2020 00:00 | 2020-03-16T00:00:00Z | 03/15 20:00 | 2020-03-16T00:00:00Z | 50 | 5 | 82 | 504 | posNeg | 87 | 504 | 0 | 0 | e81b13caa12337b4f2d8fbc0af50ddb6806b40db | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10915 | 10915 | 20200316 | VI | 1 | 1 | 3/16/2020 15:58 | 2020-03-16T15:58:00Z | 03/16 11:58 | 2020-03-16T15:58:00Z | 78 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | ea65da585cbe38537348a3d600a66ab931af6e8f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10900 | 10900 | 20200316 | NM | 17 | 566 | 583 | 3/16/2020 15:11 | 2020-03-16T15:11:00Z | 03/16 11:11 | 2020-03-16T15:11:00Z | 35 | 4 | 84 | 583 | posNeg | 88 | 583 | 0 | 0 | f45e15f3a58ea8b36f498e5d3ca962bed4491a35 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10869 | 10869 | 20200316 | AZ | 18 | 125 | 63 | 143 | 42 | 3/16/2020 16:16 | 2020-03-16T16:16:00Z | 03/16 12:16 | 0 | 42 | 2020-03-16T16:16:00Z | 143 | 4 | 6 | 4 | 206 | posNeg | 10 | 143 | 0 | 6 | f7a38a766b8cb4f0d9cf6ad5f18831f0589101e6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10825 | 10825 | 20200317 | IL | 159 | 1340 | 1499 | 3/16/2020 00:00 | 2020-03-16T00:00:00Z | 03/15 20:00 | 1 | 2020-03-16T00:00:00Z | 17 | 66 | 408 | 1499 | posNeg | 474 | 1499 | 1 | 0 | f940c88541bb97850b2b366f30b904583c580a45 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10877 | 10877 | 20200316 | GU | 3 | 23 | 26 | 3/16/2020 15:58 | 2020-03-16T15:58:00Z | 03/16 11:58 | 2020-03-16T15:58:00Z | 66 | 0 | 0 | 26 | posNeg | 0 | 26 | 0 | 0 | f9be748acd7c91bf06485dc45ae82317632c1912 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10889 | 10889 | 20200316 | MI | 2895 | 272 | 30 | 3167 | 3/16/2020 15:52 | 2020-03-16T15:52:00Z | 03/16 11:52 | 2020-03-16T15:52:00Z | 2873 | 1 | 1 | 26 | 707 | 67 | 3197 | posNeg | 774 | 3167 | 0 | 0 | faa63440d38bbc5348494ce0455ea4bd79cb4164 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10878 | 10878 | 20200316 | HI | 7 | 7 | 3/16/2020 15:39 | 2020-03-16T15:39:00Z | 03/16 11:39 | 2020-03-16T15:39:00Z | 15 | 5 | 0 | 7 | posNeg | 5 | 7 | 0 | 0 | fe247926163e19c6b5dcb3137e6fb2e5f534a19f | 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 );