states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
11,578 rows sorted by totalTestResults
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
11073 | 11073 | 20200313 | WY | 1 | 1 | 3/12/2020 00:00 | 2020-03-12T00:00:00Z | 03/11 20:00 | 2020-03-12T00:00:00Z | 1 | 56 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 6e7d1185225390d1726c126c8bb1869b8f72fb0b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11124 | 11124 | 20200312 | WY | 1 | 1 | 3/11/2020 00:00 | 2020-03-11T00:00:00Z | 03/10 20:00 | 2020-03-11T00:00:00Z | 56 | 1 | 0 | 1 | posNeg | 1 | 1 | 0 | 0 | 060fd182cd332032dff4ea72cecabdff543e2191 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11149 | 11149 | 20200311 | MO | 1 | 1 | 54 | 8 | 46 | 1 | 29 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 64e2151d9578ec0cd38a504e1f8e6b0ec98f40c2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11200 | 11200 | 20200310 | MO | 1 | 1 | 42 | 8 | 34 | 1 | 29 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | e8ce6bdb81792852d024e4e7423ff5867e872524 | 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 | |||||||||||||||||||||||||||||||||
11251 | 11251 | 20200309 | MO | 1 | 1 | 36 | 7 | 29 | 1 | 29 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 1a079fbedfc8d7a374c7de179459b5f80f1430f4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11271 | 11271 | 20200309 | UT | 1 | 1 | 1 | 49 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | fd93e289f042fae8dbafd8e636e48969b3516227 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11289 | 11289 | 20200308 | HI | 1 | 1 | 15 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | fce32ebadc808697f80252996d531a82e417dc07 | 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 | |||||||||||||||||||||||||||||||||
11302 | 11302 | 20200308 | MO | 1 | 1 | 31 | 7 | 24 | 1 | 29 | 1 | 0 | 1 | posNeg | 1 | 1 | 0 | 0 | a9675ed0fffa1d3032f7ec9be2fcbdc716b9522e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11322 | 11322 | 20200308 | UT | 1 | 1 | 1 | 49 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | df00cbca051e0e1dc323cc91af54c88361a9c4ad | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11340 | 11340 | 20200307 | HI | 1 | 1 | 15 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | ff4edd0e286c634864c3eaab6d4b695fa101bb9b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11344 | 11344 | 20200307 | IN | 1 | 1 | 18 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | e1af49982396e125f2dcb4b363a37403c91cf63d | 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 | |||||||||||||||||||||||||||||||||
11365 | 11365 | 20200307 | OK | 1 | 1 | 40 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | e315b089218101b4843627f834a260bd57cf1d91 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11371 | 11371 | 20200307 | TN | 1 | 1 | 47 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 94e1a0026eb007f88d231f68e297fa084f14cc55 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11373 | 11373 | 20200307 | UT | 1 | 1 | 1 | 49 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | d9688c4b336cdf2d620852cadf1e462417d2a030 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11391 | 11391 | 20200306 | IN | 1 | 1 | 18 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 48879bb87fc6d7f888ad73cf855f11578aa51ad0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11401 | 11401 | 20200306 | NJ | 1 | 1 | 0 | 4 | 0 | 1 | 34 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | d102d32355139886ec0279ef7e8f8c2edfda0aa6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11410 | 11410 | 20200306 | TN | 1 | 1 | 47 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 7a49afb734c07d6d2218079f31202689c4f5cb75 | 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 | ||||||||||||||||||||||||||||||||
11427 | 11427 | 20200305 | NC | 1 | 1 | 37 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 473807abe52be5725eaf2be038a408c589d97a1c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11430 | 11430 | 20200305 | NJ | 1 | 1 | 0 | 2 | 0 | 1 | 34 | 1 | 0 | 1 | posNeg | 1 | 1 | 0 | 0 | 684c48748966f7f3221e7a5150a1fda9fc49b037 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11437 | 11437 | 20200305 | TN | 1 | 1 | 47 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | e0c627b4f17cfed2252487b1cea86a069800fcbd | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11438 | 11438 | 20200305 | TX | 1 | 1 | 1 | 48 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | b6c2d2da54bf32da455dc064c25b46362e2c5249 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11449 | 11449 | 20200304 | NC | 1 | 1 | 37 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 4d1b2fa487067a2fcbf1f564cbb7aee6d90f48e3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11456 | 11456 | 20200304 | TX | 1 | 1 | 1 | 48 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | ac3e4cd42d64afbbf5c925dc09ff26549fc509bc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11577 | 11577 | 20200122 | MA | 1 | 1 | 0 | 25 | 0 | 0 | 0 | totalTestsViral | 0 | 0 | 0 | 0 | 0f3eebd5c4a00d0aaa235b0534bd4243794652b6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
10052 | 10052 | 20200331 | MP | 2 | 2 | 3/30/2020 18:30 | 2020-03-30T18:30:00Z | 03/30 14:30 | 2020-03-30T18:30:00Z | 69 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | dbbaa90d13abe787feca37e2927d9037e8d75027 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10108 | 10108 | 20200330 | MP | 2 | 2 | 3/30/2020 01:30 | 2020-03-30T01:30:00Z | 03/29 21:30 | 2020-03-30T01:30:00Z | 69 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 6ffdffde1257371ad982b7061de5df8345fc225c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10164 | 10164 | 20200329 | MP | 2 | 2 | 3/29/2020 01:30 | 2020-03-29T01:30:00Z | 03/28 21:30 | 2020-03-29T01:30:00Z | 69 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | dc2d00e4a18f32239ba79a28efbe39ea80e9b2bc | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10220 | 10220 | 20200328 | MP | 2 | 2 | 3/28/2020 04:30 | 2020-03-28T04:30:00Z | 03/28 00:30 | 2020-03-28T04:30:00Z | 69 | 2 | 0 | 2 | posNeg | 2 | 2 | 0 | 0 | 297e77914ec5de16d3030e074b27c768410edbaf | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10803 | 10803 | 20200318 | VI | 2 | 2 | 3/18/2020 00:00 | 2020-03-18T00:00:00Z | 03/17 20:00 | 2020-03-18T00:00:00Z | 78 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 905df4c8bc271b530ea36adf28c76b7f51183365 | 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 | |||||||||||||||||||||||||||||||
10932 | 10932 | 20200315 | HI | 2 | 2 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 15 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 09cbd692b373de9e0881bf7960a749433d5a1887 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10983 | 10983 | 20200314 | HI | 2 | 2 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 15 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 105086157d7987b9e53ef719f5d160541fc58600 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11022 | 11022 | 20200314 | WY | 2 | 2 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 2 | 56 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | 8d9d3ca4720cc8639b78c55ddcf27eb1b3337f3e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11034 | 11034 | 20200313 | HI | 2 | 2 | 3/12/2020 00:00 | 2020-03-12T00:00:00Z | 03/11 20:00 | 2020-03-12T00:00:00Z | 15 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | fc90a073776bbb2fb0909ca8ded9cf41bc51e98c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11085 | 11085 | 20200312 | HI | 2 | 2 | 3/11/2020 00:00 | 2020-03-11T00:00:00Z | 03/10 20:00 | 2020-03-11T00:00:00Z | 15 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 356b68f539ad15e806c6936b6be3c58aef9da8d1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11136 | 11136 | 20200311 | HI | 2 | 2 | 15 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 1090e54dad5c1669a493d5d9c73d1ad665b753ac | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11169 | 11169 | 20200311 | UT | 2 | 2 | 2 | 49 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 653cf8d22908dc9f4a924f5d8c626b0802666ff7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11187 | 11187 | 20200310 | HI | 2 | 2 | 15 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | dc4c46fcfaa7c3964ed0d96500d7b867d9335a7e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11220 | 11220 | 20200310 | UT | 2 | 2 | 2 | 49 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | 54d3a125fe6d0bc8002f0ed7e2261af5084b6b69 | 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 | ||||||||||||||||||||||||||||||||
11238 | 11238 | 20200309 | HI | 2 | 2 | 15 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | 8ee289ff9078e8033d2c7d9c46923f9418b544a5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11242 | 11242 | 20200309 | IN | 2 | 2 | 18 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | d8eecf48ba3c86aafcc5a09a39ccb3f2dc81f9b2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11254 | 11254 | 20200309 | NC | 2 | 2 | 37 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 024fa80c3564c92b1a1c9bd6fde8eedbb6ca12ab | 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 | ||||||||||||||||||||||||||||||||
11293 | 11293 | 20200308 | IN | 2 | 2 | 18 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | f1a024c9493ca5c13fa1400447fdc64cb4fa13c8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11305 | 11305 | 20200308 | NC | 2 | 2 | 37 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 2db7cf8e77c62d6f4dd1ec027d8a60e26f50323f | 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 | ||||||||||||||||||||||||||||||||
11356 | 11356 | 20200307 | NC | 2 | 2 | 37 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | ded978542c169d9580bff5dc4cc649ec22a30f43 | 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 | ||||||||||||||||||||||||||||||||
11388 | 11388 | 20200306 | GA | 2 | 2 | 2 | 13 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | cec1802d5dfc5229646abf26fec428e1481db1e3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11398 | 11398 | 20200306 | NC | 2 | 2 | 37 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | a4aed27dbdb2f9ff71c0f348fc90c564f2210717 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11407 | 11407 | 20200306 | PA | 2 | 2 | 42 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | e74dee4abf0f448eb5615b7c32b274c90d5cf773 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11422 | 11422 | 20200305 | GA | 2 | 2 | 2 | 13 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | d4d80e64fc6aaa79af0a071cf69fca98219493f5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11445 | 11445 | 20200304 | GA | 2 | 2 | 2 | 13 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 05981c7c64c1a7574528bd621b73ca93c88c3a53 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11569 | 11569 | 20200126 | MA | 2 | 2 | 0 | 25 | 0 | 0 | 0 | totalTestsViral | 0 | 0 | 0 | 0 | 564fae1c160074f0d252f9cf03b31e9bd259f162 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11571 | 11571 | 20200125 | MA | 2 | 2 | 0 | 25 | 0 | 0 | 0 | totalTestsViral | 0 | 0 | 0 | 0 | 664363707eec6db537d3ef5b0a6a948e94a6a10b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11573 | 11573 | 20200124 | MA | 2 | 2 | 0 | 25 | 0 | 0 | 0 | totalTestsViral | 0 | 0 | 0 | 0 | 6fb5cd338a16b013604fd09024f0d09006bd6d89 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11575 | 11575 | 20200123 | MA | 2 | 2 | 0 | 25 | 0 | 0 | 0 | totalTestsViral | 1 | 0 | 0 | 0 | 885628de5b5c6da109b79adb7faad55e4815624a | 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 |
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 );