states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
11,578 rows sorted by negative
This data as json, copyable, CSV (advanced)
Suggested facets: dateModified (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11177 | 11177 | 20200310 | AL | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 91a6e3fe17d281044857ddf1129082f5f42ef049 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11226 | 11226 | 20200310 | WY | 0 | 0 | 0 | 0 | 56 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 8de32dd8b1ba290c617cb76e05f8090e25ffa11e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11255 | 11255 | 20200309 | ND | 0 | 38 | 0 | 0 | 0 | totalTestEncountersViral | 0 | 0 | 0 | 0 | 4ad41844d2b76f5c0eb62e557a7831850a11d41e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
11306 | 11306 | 20200308 | ND | 0 | 38 | 0 | 0 | 0 | totalTestEncountersViral | 0 | 0 | 0 | 0 | b684c79b81d30d754ad2c80fa62ec200090b516c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
11357 | 11357 | 20200307 | ND | 0 | 38 | 0 | 0 | 0 | totalTestEncountersViral | 0 | 0 | 0 | 0 | a52d66548fd69febf84d120f54256caf4fd95b9a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
11413 | 11413 | 20200306 | VT | 0 | 0 | 0 | 3/6/2020 00:00 | 2020-03-06T00:00:00Z | 03/05 19:00 | 2020-03-06T00:00:00Z | 50 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 7007a9ae12fcf966fd1dfa485e055f1c22231ac4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11485 | 11485 | 20200228 | WA | 0 | 0 | 0 | 4 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 2 | 0 | 33783fc55fe8724ad3f28c003905252e64c14205 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11489 | 11489 | 20200227 | WA | 0 | 0 | 0 | 2 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | d47667bb5e3c371486ca9d76d4846e77ddc826e9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11492 | 11492 | 20200226 | WA | 0 | 0 | 0 | 2 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 2 | 0 | dfacd1905c976c4fcbce13562b7e7fdc66715093 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11495 | 11495 | 20200225 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 356dd220ebd006a5e8fbf0d90e088f1d23be30aa | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11498 | 11498 | 20200224 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 2527ffbcac123486d39060a643ee042685444040 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11501 | 11501 | 20200223 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | db8c4705e59839721e50b7b884698c445548659c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11504 | 11504 | 20200222 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | f5897499c174863a0bfd8111123172cbf4f31d3d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11507 | 11507 | 20200221 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 999cc43348f38608d7e748db24121d6a96eaa042 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11510 | 11510 | 20200220 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 04455407d63f594b20ad6a42511a8e5e3c505e94 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11513 | 11513 | 20200219 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 4de13ed97776e91b872ccd196ca963ea838e63f0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11516 | 11516 | 20200218 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | b9f2477edf96e4bf6695b83dc203a2e01c283bbd | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11519 | 11519 | 20200217 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 6c29293358450c27b194e2234ad0eba6b212ba3b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11522 | 11522 | 20200216 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 3426c1cf143d5b80508c615b5c54556d4db74be3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11525 | 11525 | 20200215 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 7983deb48e8cfa38ce6ad2ccd8ce829b4c00e386 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11528 | 11528 | 20200214 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 591f5dc76d194660b201697ba8687c16e478c5e9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11531 | 11531 | 20200213 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | e92d97f8ce05a6a9f8becc5b10a34f8ec61b27f1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11534 | 11534 | 20200212 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | a0c60ef498021c84c70868dc8f5bf4348d231183 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11537 | 11537 | 20200211 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | ff0cb7c50f42126410e0e2a3959a1415c450d6ce | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11540 | 11540 | 20200210 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | c90f9558f2984b8565c534ec076d5cf757407af3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11542 | 11542 | 20200209 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 428c54e0a7392260add9160a215ef1eaa3abbc8c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11544 | 11544 | 20200208 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 69f6c69ce71c22a9afe35a3b885b951b07dc9ac2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11546 | 11546 | 20200207 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 2b9f17998378d4c584a95afd798c91ca8d7d3f1b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11548 | 11548 | 20200206 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 776627308e5120419ceb0439a2f2e33e2123bf8d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11550 | 11550 | 20200205 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | c046f5f2d01538c648a4143cc2483c46733afcec | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11552 | 11552 | 20200204 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | d5a76e6a18fa1b96755146417ac948a9171616a0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11554 | 11554 | 20200203 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | d526468a75e5d8d6398391f7374827c75da63c76 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11556 | 11556 | 20200202 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | f689cc8700bdd9301157ac42fa9c55eb3150262d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11558 | 11558 | 20200201 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 826ada8fe828c859bd601b3219737b8310342f1b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11560 | 11560 | 20200131 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | fba5d5a98fb5fd10b50f860b8df2177f618a8b0a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11562 | 11562 | 20200130 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 54780ea7215216a912a9def2e2781a3e0b441b1b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11564 | 11564 | 20200129 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 6f0046d8d9448fad739742129ffe61dffd546658 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11566 | 11566 | 20200128 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 7b90966b6545d98ee954eb8af98720dbdd3e72e1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11568 | 11568 | 20200127 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 97c4e999c9d9a053210188434ae2c1d5a6e84395 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11570 | 11570 | 20200126 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | d071f52c7b741eb47e42b29ec43d1fd5e5669698 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11572 | 11572 | 20200125 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 626988ec4dfe62f38d72dc25126a264411769056 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11574 | 11574 | 20200124 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 6f40087f42d06db4121e09b184785b4110cd4df8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11576 | 11576 | 20200123 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 978c05d8a7a9d46e9fa826d83215f5b9732f2c6d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11578 | 11578 | 20200122 | WA | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 06e7ce37c84a602f9b8704eb4a4e8d3bb9726026 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11248 | 11248 | 20200309 | ME | 0 | 1 | 1 | 0 | 23 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 151049d836a370c678897ad29c326c5c564a2748 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11299 | 11299 | 20200308 | ME | 0 | 1 | 1 | 0 | 23 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | cb22017cc43ff01b5997c50e8f5be05c5d342bd2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11350 | 11350 | 20200307 | ME | 0 | 1 | 1 | 0 | 23 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | b84d745a34253a870502ef71a4109b8027b35459 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11416 | 11416 | 20200306 | WV | 0 | 1 | 4 | 1 | 0 | 54 | 0 | 0 | 5 | posNeg | 0 | 1 | 0 | 0 | 72a7abd8de92bd9baf3046acd3ea566699d21e31 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11225 | 11225 | 20200310 | WV | 0 | 2 | 3 | 2 | 0 | 54 | 0 | 0 | 5 | posNeg | 0 | 2 | 0 | 0 | 33a85c29696e8c58f9eebd1d7a43e440e762cf2b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11276 | 11276 | 20200309 | WV | 0 | 2 | 3 | 2 | 0 | 54 | 0 | 0 | 5 | posNeg | 0 | 2 | 0 | 0 | a621da63913b2294614db788f9ffaa61cea7dce9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11327 | 11327 | 20200308 | WV | 0 | 2 | 3 | 2 | 0 | 54 | 0 | 0 | 5 | posNeg | 0 | 2 | 0 | 0 | a88a2c3fac00ba8ad7b58dcdac4ef6e995725c07 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11378 | 11378 | 20200307 | WV | 0 | 2 | 3 | 2 | 0 | 54 | 0 | 1 | 5 | posNeg | 1 | 2 | 0 | 0 | 449fa27717fa512952dc566da7ea1b434afb3836 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11475 | 11475 | 20200301 | RI | 2 | 2 | 3/1/2020 03:00 | 2020-03-01T03:00:00Z | 02/29 22:00 | 2020-03-01T03:00:00Z | 4 | 2 | 2 | 2 | 4 | 44 | 0 | 0 | 4 | totalTestEncountersViral | 0 | 4 | 0 | 0 | 008b0080959373e1f9483cf91a55ae015b5b31af | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8348 | 8348 | 20200430 | AS | 0 | 3 | 17 | 3 | F | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 0 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | c1a6f2573d586d2f3df990eeb447fa0d07b5af9a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8404 | 8404 | 20200429 | AS | 0 | 3 | 17 | 3 | F | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 0 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | f9a5ef42aad60ea58048469affccfb21a0262fab | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8460 | 8460 | 20200428 | AS | 0 | 3 | 17 | 3 | F | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 0 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 2b6a7a6ded23ac7189ccf983ce335e5b5dd3fa34 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8516 | 8516 | 20200427 | AS | 0 | 3 | 17 | 3 | F | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 0 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 5c3294ac17a9c944bbbd0e606dccfe5d6974ab79 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8572 | 8572 | 20200426 | AS | 0 | 3 | 17 | 3 | F | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 0 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | ab3f599f5e6ae04418fa318ab0b07e7a0e35f1f9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8628 | 8628 | 20200425 | AS | 0 | 3 | 17 | 3 | F | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 0 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 0567a4c733d322eb79264f00446f0bd37d4619a8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8684 | 8684 | 20200424 | AS | 0 | 3 | 17 | 3 | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 658893a7d3d87219411073fcaccfe66d7d51cb62 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
8740 | 8740 | 20200423 | AS | 0 | 3 | 17 | 3 | 4/6/2020 00:00 | 2020-04-06T00:00:00Z | 04/05 20:00 | 2020-04-06T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 3799a1b2fa51e61cb9ed3b9ced8015dd3cbd92e7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
8796 | 8796 | 20200422 | AS | 0 | 3 | 17 | 3 | 4/6/2020 00:00 | 2020-04-06T00:00:00Z | 04/05 20:00 | 2020-04-06T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 4d821f24592a2b4fc912f1a5054783df6c2d97d9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
8852 | 8852 | 20200421 | AS | 0 | 3 | 17 | 3 | 4/6/2020 00:00 | 2020-04-06T00:00:00Z | 04/05 20:00 | 2020-04-06T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 8bac2457f5f74d9379d838feabe2e22495624093 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
8908 | 8908 | 20200420 | AS | 0 | 3 | 17 | 3 | 4/6/2020 00:00 | 2020-04-06T00:00:00Z | 04/05 20:00 | 2020-04-06T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | c1a6c2e8b637d5326443a6561f775a278319e23e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
8964 | 8964 | 20200419 | AS | 0 | 3 | 17 | 3 | 4/6/2020 00:00 | 2020-04-06T00:00:00Z | 04/05 20:00 | 2020-04-06T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | f2ef55f3ce6734c57fca5d41aa24464bceb71e03 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9020 | 9020 | 20200418 | AS | 0 | 3 | 17 | 3 | 4/6/2020 00:00 | 2020-04-06T00:00:00Z | 04/05 20:00 | 2020-04-06T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | e6978ab2e52457866a99aa0d129e7901d74a12d9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9076 | 9076 | 20200417 | AS | 0 | 3 | 17 | 3 | 4/6/2020 00:00 | 2020-04-06T00:00:00Z | 04/05 20:00 | 2020-04-06T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 72cf69d5c70f144df44cb3ee7ed3c154192f287f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9132 | 9132 | 20200416 | AS | 0 | 3 | 17 | 3 | 4/6/2020 00:00 | 2020-04-06T00:00:00Z | 04/05 20:00 | 2020-04-06T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 24e7d4aa437160db1e5addeef1e95796925ad5ec | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9188 | 9188 | 20200415 | AS | 0 | 3 | 17 | 3 | 4/6/2020 00:00 | 2020-04-06T00:00:00Z | 04/05 20:00 | 2020-04-06T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 00914dbfdcb2378c155dfb4eed1ce33ee7951ae4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9244 | 9244 | 20200414 | AS | 0 | 3 | 17 | 3 | 4/6/2020 00:00 | 2020-04-06T00:00:00Z | 04/05 20:00 | 2020-04-06T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 7af318448a5847451ffc9469743cd67de3af9eaf | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9300 | 9300 | 20200413 | AS | 0 | 3 | 3 | 4/6/2020 00:00 | 2020-04-06T00:00:00Z | 04/05 20:00 | 2020-04-06T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 3 | posNeg | 0 | 3 | 0 | 0 | c6b06661f3819320dd6c55a3bd69ed8d000abbb4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
9356 | 9356 | 20200412 | AS | 0 | 3 | 2 | 3 | 3/31/2020 19:16 | 2020-03-31T19:16:00Z | 03/31 15:16 | 2020-03-31T19:16:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 147c1fce41443f82aadf764929d63cf93573241d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9412 | 9412 | 20200411 | AS | 0 | 3 | 2 | 3 | 3/31/2020 19:16 | 2020-03-31T19:16:00Z | 03/31 15:16 | 2020-03-31T19:16:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | bab88ce6e3fdd121ed14f0e87c9366e396382477 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9468 | 9468 | 20200410 | AS | 0 | 3 | 2 | 3 | 4/6/2020 16:00 | 2020-04-06T16:00:00Z | 04/06 12:00 | 0 | 2020-04-06T16:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 4179f6ea0485f707e82fe3b47b570f690b034e24 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9524 | 9524 | 20200409 | AS | 0 | 3 | 2 | 3 | 4/6/2020 16:00 | 2020-04-06T16:00:00Z | 04/06 12:00 | 0 | 2020-04-06T16:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | b5d66885a54804cb22be1a11efc44efcc3095644 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9580 | 9580 | 20200408 | AS | 0 | 3 | 2 | 3 | 4/6/2020 16:00 | 2020-04-06T16:00:00Z | 04/06 12:00 | 0 | 2020-04-06T16:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 94df3e7e7c82359763e0c807d9f719611d845e93 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9636 | 9636 | 20200407 | AS | 0 | 3 | 2 | 3 | 4/6/2020 16:00 | 2020-04-06T16:00:00Z | 04/06 12:00 | 0 | 2020-04-06T16:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 74dc82a8afe625724b7b3b3b6c65d1d023544269 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9692 | 9692 | 20200406 | AS | 0 | 3 | 2 | 3 | 4/6/2020 16:00 | 2020-04-06T16:00:00Z | 04/06 12:00 | 0 | 2020-04-06T16:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | f27aaf8008b12ddd3f887f9c1fd4f69f706d9881 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9748 | 9748 | 20200405 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 50b0bf581bf52acb2f058136f521846cd6d93af2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9804 | 9804 | 20200404 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 45297872049fc2bc64ae664b1ffcd484db810b9f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9860 | 9860 | 20200403 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | d0ff9647302f774881b902572c312f142af3e56f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9916 | 9916 | 20200402 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | cccc2f8f22906b58a34ea2dacde38a8d2a318c96 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9972 | 9972 | 20200401 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | d3e447c2aa5e4107ee614da8de801a5d0a3105a9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10028 | 10028 | 20200331 | AS | 0 | 3 | 2 | 3 | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 0 | 2020-03-30T00:00:00Z | 3 | 0 | 60 | 0 | 3 | 5 | posNeg | 3 | 3 | 0 | 0 | 1aa73b4235d97ea1e7c69f21a3cce6807b07fb59 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
11174 | 11174 | 20200311 | WV | 0 | 3 | 2 | 3 | 0 | 54 | 0 | 1 | 5 | posNeg | 1 | 3 | 0 | 0 | add6e2eeafdb29275118506c96f9149c58be0b40 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11469 | 11469 | 20200302 | RI | 2 | 3 | 4 | 3/2/2020 03:00 | 2020-03-02T03:00:00Z | 03/01 22:00 | 2020-03-02T03:00:00Z | 5 | 2 | 3 | 2 | 4 | 5 | 44 | 0 | 1 | 5 | totalTestEncountersViral | 4 | 5 | 0 | 0 | b5b45c6219dace9942c021bc2c7b0114fff7eb3f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
11392 | 11392 | 20200306 | KS | 0 | 4 | 0 | 4 | 20 | 0 | 0 | 4 | posNeg | 0 | 4 | 0 | 0 | 869916ef064b6274b1c4d30feee19fe80e419f3c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11245 | 11245 | 20200309 | LA | 1 | 5 | 6 | 1 | 22 | 1 | 0 | 6 | posNeg | 1 | 6 | 0 | 0 | be423464762f6e54b8e900805a923bdb76f313e5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11268 | 11268 | 20200309 | SD | 0 | 5 | 0 | 5 | 5 | 46 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | fd69eda5746c616093059afe31b23b3f20293319 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11296 | 11296 | 20200308 | LA | 0 | 5 | 5 | 0 | 22 | 0 | 5 | 5 | posNeg | 5 | 5 | 0 | 0 | b2f8598087a737fc9a845252abe3223ffee9ba51 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11319 | 11319 | 20200308 | SD | 0 | 5 | 0 | 5 | 5 | 46 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | 41976be1e052bda9301ee0e94670725da3ea87eb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11370 | 11370 | 20200307 | SD | 0 | 5 | 0 | 5 | 5 | 46 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | ce0dea081cda6a54b84abe98d7b02b1d4aa7bb8a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11409 | 11409 | 20200306 | SC | 0 | 5 | 5 | 0 | 45 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | 3de143faa1d246d3569a4d73c92ce18796435321 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11436 | 11436 | 20200305 | SC | 0 | 5 | 5 | 0 | 45 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | d1b9c8d019f752b3382e9e77b37ca59d1446c88a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11455 | 11455 | 20200304 | SC | 0 | 5 | 5 | 0 | 45 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | cebf83dff216f187b0b9d36b2b7859294acd9e75 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11463 | 11463 | 20200303 | RI | 2 | 5 | 5 | 3/3/2020 03:00 | 2020-03-03T03:00:00Z | 03/02 22:00 | 2020-03-03T03:00:00Z | 7 | 2 | 5 | 2 | 5 | 7 | 44 | 0 | 2 | 7 | totalTestEncountersViral | 1 | 7 | 0 | 0 | 4f5646cf6f957ccf8cc678537a1f9034095dd5bb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
11204 | 11204 | 20200310 | ND | 0 | 6 | 2 | 7 | 12 | 7 | 7 | 38 | 0 | 6 | 8 | totalTestEncountersViral | 7 | 6 | 0 | 0 | b253186b79d4e92b4a350b6f287a2f85990d5afe | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11280 | 11280 | 20200308 | AR | 0 | 6 | 0 | 6 | 6 | 0 | 5 | 0 | 0 | 6 | posNeg | 0 | 6 | 0 | 0 | f279c3c9df7df0e71ad32775ff46df28a5524a4a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11331 | 11331 | 20200307 | AR | 0 | 6 | 0 | 6 | 6 | 0 | 5 | 0 | 0 | 6 | posNeg | 0 | 6 | 0 | 0 | 1ece7893cfeed3ae7d761db447cb080f14977c61 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11381 | 11381 | 20200306 | AR | 0 | 6 | 0 | 6 | 6 | 0 | 5 | 0 | 0 | 6 | posNeg | 0 | 6 | 0 | 0 | d2ee5fcc83ed0c711dcd518c7cc9cdf86ba7acc7 | 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 );