states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
11,578 rows sorted by negative descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7267 | 7267 | 20200520 | PR | 2866 | 2866 | 110 | 20 | 5 | C | 5/20/2020 06:30 | 2020-05-20T06:30:00Z | 05/20 02:30 | 125 | 2020-05-20T06:30:00Z | 1206 | 66 | 1660 | 72 | 61 | 0 | 2866 | posNeg | 61 | 2866 | 1 | 0 | 8789d2418fbb9b5ba1868e8f16b57fbd86994024 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7323 | 7323 | 20200519 | PR | 2805 | 2805 | 121 | 20 | 8 | C | 5/19/2020 05:52 | 2020-05-19T05:52:00Z | 05/19 01:52 | 124 | 2020-05-19T05:52:00Z | 1207 | 60 | 1598 | 72 | 95 | 0 | 2805 | posNeg | 95 | 2805 | 0 | 0 | 201e8a8bef79dcecad957343341f78d1f71ce93f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7379 | 7379 | 20200518 | PR | 2710 | 2710 | 147 | 17 | 4 | C | 5/18/2020 06:30 | 2020-05-18T06:30:00Z | 05/18 02:30 | 124 | 2020-05-18T06:30:00Z | 1195 | 60 | 1515 | 72 | 64 | 0 | 2710 | posNeg | 64 | 2710 | 1 | 0 | fc8ca68ddf33d66faecb509d7ea80927a35c7bae | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7435 | 7435 | 20200517 | PR | 2646 | 2646 | 150 | 24 | 5 | C | 5/17/2020 05:51 | 2020-05-17T05:51:00Z | 05/17 01:51 | 123 | 2020-05-17T05:51:00Z | 1147 | 60 | 1499 | 72 | 57 | 0 | 2646 | posNeg | 57 | 2646 | 1 | 0 | fa233024fb59e4e70442f7fec556c7a058fd9cbe | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7491 | 7491 | 20200516 | PR | 2589 | 2589 | 144 | 15 | 5 | B | 5/16/2020 04:59 | 2020-05-16T04:59:00Z | 05/16 00:59 | 122 | 2020-05-16T04:59:00Z | 1114 | 59 | 1475 | 72 | 47 | 0 | 2589 | posNeg | 47 | 2589 | 0 | 0 | 25b0cc5359a0f6c74bfd702ddd348147c06b54cb | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7547 | 7547 | 20200515 | PR | 2542 | 2542 | 147 | 18 | 3 | B | 5/15/2020 05:51 | 2020-05-15T05:51:00Z | 05/15 01:51 | 122 | 2020-05-15T05:51:00Z | 1088 | 63 | 1454 | 72 | 115 | 0 | 2542 | posNeg | 115 | 2542 | 5 | 0 | 51eef1ba921da22f33c08cd43ec375d859a18774 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7603 | 7603 | 20200514 | PR | 2427 | 2427 | 159 | 18 | 5 | B | 5/14/2020 06:30 | 2020-05-14T06:30:00Z | 05/14 02:30 | 117 | 2020-05-14T06:30:00Z | 1073 | 58 | 1354 | 72 | 98 | 0 | 2427 | posNeg | 98 | 2427 | 2 | 0 | a1ec436b42655b00f20f2f367d45851c5886879d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7659 | 7659 | 20200513 | PR | 2329 | 2329 | 142 | 10 | 6 | C | 5/12/2020 06:30 | 2020-05-12T06:30:00Z | 05/12 02:30 | 115 | 2020-05-12T06:30:00Z | 1064 | 58 | 1265 | 72 | 30 | 0 | 2329 | posNeg | 30 | 2329 | 1 | 0 | 332361bfbed01a39d20e119b7a7c85068749c66d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7715 | 7715 | 20200512 | PR | 2299 | 2299 | 127 | C | 5/12/2020 06:30 | 2020-05-12T06:30:00Z | 05/12 02:30 | 114 | 2020-05-12T06:30:00Z | 1062 | 58 | 1237 | 72 | 43 | 0 | 2299 | posNeg | 43 | 2299 | 1 | 0 | 6ec3adb15de32c0dff51a07df1d284bdf630de3e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
7771 | 7771 | 20200511 | PR | 2256 | 2256 | 159 | D | 5/11/2020 05:57 | 2020-05-11T05:57:00Z | 05/11 01:57 | 113 | 2020-05-11T05:57:00Z | 1054 | 57 | 1202 | 72 | 58 | 0 | 2256 | posNeg | 58 | 2256 | 2 | 0 | 9008d41bcb412e7a979add318ae815f93b23dc53 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
7827 | 7827 | 20200510 | PR | 2198 | 2198 | 143 | D | 5/10/2020 05:51 | 2020-05-10T05:51:00Z | 05/10 01:51 | 111 | 2020-05-10T05:51:00Z | 1040 | 57 | 1158 | 72 | 25 | 0 | 2198 | posNeg | 25 | 2198 | 3 | 0 | f2cfb681616e4d0bf5c42d57d000e6f19846ff05 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
7883 | 7883 | 20200509 | PR | 2173 | 2173 | 148 | 7 | C | 5/9/2020 05:51 | 2020-05-09T05:51:00Z | 05/09 01:51 | 108 | 2020-05-09T05:51:00Z | 1034 | 57 | 1139 | 72 | 17 | 0 | 2173 | posNeg | 17 | 2173 | 1 | 0 | 18b6697d5a4b403c33e17bf2c7d74f173f5e430b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7939 | 7939 | 20200508 | PR | 2156 | 2156 | 161 | 10 | C | 5/8/2020 06:00 | 2020-05-08T06:00:00Z | 05/08 02:00 | 107 | 2020-05-08T06:00:00Z | 1029 | 56 | 1127 | 72 | 125 | 0 | 2156 | posNeg | 125 | 2156 | 5 | 0 | 192e478cb97b69539bfacbf26caa203e4a35fa05 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7995 | 7995 | 20200507 | PR | 2031 | 2031 | 164 | D | 5/7/2020 06:00 | 2020-05-07T06:00:00Z | 05/07 02:00 | 102 | 2020-05-07T06:00:00Z | 1013 | 56 | 1018 | 72 | 63 | 0 | 2031 | posNeg | 63 | 2031 | 3 | 0 | 7cabf5e2c686d2dc9e98f8398c404cd4760c8de2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8051 | 8051 | 20200506 | PR | 1968 | 1968 | 144 | D | 5/6/2020 06:00 | 2020-05-06T06:00:00Z | 05/06 02:00 | 99 | 2020-05-06T06:00:00Z | 1006 | 56 | 962 | 72 | 44 | -9313 | 1968 | posNeg | -9269 | 1968 | 0 | 0 | 537e261dee94e72a337ff8e8ae454e00be35ac85 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9996 | 9996 | 20200401 | MP | 6 | 6 | 3/31/2020 21:50 | 2020-03-31T21:50:00Z | 03/31 17:50 | 2020-03-31T21:50:00Z | 69 | 4 | 0 | 6 | posNeg | 4 | 6 | 0 | 0 | bd8aeb9eb37bcc9caaf1f27773bb957d7f925968 | 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 | |||||||||||||||||||||||||||||||
10084 | 10084 | 20200330 | AS | 0 | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 0 | 2020-03-30T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | c49b358f37e9f829975f04b2f83c70581fd3a503 | 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 | |||||||||||||||||||||||||||||||
10140 | 10140 | 20200329 | AS | 0 | 3/27/2020 00:00 | 2020-03-27T00:00:00Z | 03/26 20:00 | 0 | 2020-03-27T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 4f077407c270312266c25ae3eb34b51dfe3bfc79 | 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 | |||||||||||||||||||||||||||||||
10196 | 10196 | 20200328 | AS | 0 | 3/27/2020 00:00 | 2020-03-27T00:00:00Z | 03/26 20:00 | 0 | 2020-03-27T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 1f2264c644cfc97a4110d286bf8fb9c306304cdd | 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 | |||||||||||||||||||||||||||||||
10252 | 10252 | 20200327 | AS | 0 | 3/27/2020 00:00 | 2020-03-27T00:00:00Z | 03/26 20:00 | 0 | 2020-03-27T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 99727726922a66fd40f1d0f077032f44ef5ed5ce | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10276 | 10276 | 20200327 | MP | 0 | 0 | 3/26/2020 13:30 | 2020-03-26T13:30:00Z | 03/26 09:30 | 0 | 2020-03-26T13:30:00Z | 69 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 0fecde57a41b9eeed33366c395cdcc0dffcb9bb9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10308 | 10308 | 20200326 | AS | 0 | 3/25/2020 00:00 | 2020-03-25T00:00:00Z | 03/24 20:00 | 0 | 2020-03-25T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | e56d723c3a957f33a3622d171ce93accebbbc184 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10332 | 10332 | 20200326 | MP | 0 | 0 | 3/26/2020 01:30 | 2020-03-26T01:30:00Z | 03/25 21:30 | 0 | 2020-03-26T01:30:00Z | 69 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 0cd81ae36160c9ca6d20a89cbe49d26d5fb17e45 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10364 | 10364 | 20200325 | AS | 0 | 3/25/2020 00:00 | 2020-03-25T00:00:00Z | 03/24 20:00 | 0 | 2020-03-25T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 033e30813946da57ff893b61ce92c2ec40d41188 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10388 | 10388 | 20200325 | MP | 0 | 0 | 3/24/2020 18:30 | 2020-03-24T18:30:00Z | 03/24 14:30 | 0 | 2020-03-24T18:30:00Z | 69 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | ed81d11d25c9016b13314137ee1942c82309f7f1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10420 | 10420 | 20200324 | AS | 0 | 3/24/2020 00:00 | 2020-03-24T00:00:00Z | 03/23 20:00 | 0 | 2020-03-24T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 47ff0dccdabc1e380839453c56b257c06cf27bc0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10444 | 10444 | 20200324 | MP | 0 | 0 | 3/23/2020 01:30 | 2020-03-23T01:30:00Z | 03/22 21:30 | 0 | 2020-03-23T01:30:00Z | 69 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | dcc8031567246eed42a817aab55de0a81769f37b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10467 | 10467 | 20200324 | VI | 17 | 17 | 3/23/2020 20:30 | 2020-03-23T20:30:00Z | 03/23 16:30 | 2020-03-23T20:30:00Z | 78 | 0 | 0 | 17 | posNeg | 0 | 17 | 0 | 0 | 5fc3108f189f2609e6778d290afcb0bf2f68874e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10476 | 10476 | 20200323 | AS | 0 | 3/19/2020 00:00 | 2020-03-19T00:00:00Z | 03/18 20:00 | 0 | 2020-03-19T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | b9070f3d47d54f3b2c1cefc299501e9f2da84803 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10500 | 10500 | 20200323 | MP | 0 | 0 | 3/23/2020 01:30 | 2020-03-23T01:30:00Z | 03/22 21:30 | 0 | 2020-03-23T01:30:00Z | 69 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | dfd65a52554a96535369f30ba5ac07ad67e286c5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10523 | 10523 | 20200323 | VI | 17 | 17 | 3/22/2020 20:30 | 2020-03-22T20:30:00Z | 03/22 16:30 | 2020-03-22T20:30:00Z | 78 | 11 | 0 | 17 | posNeg | 11 | 17 | 0 | 0 | dc7d636b03eab6b2a033169717dc7420874ca40f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10532 | 10532 | 20200322 | AS | 0 | 3/19/2020 00:00 | 2020-03-19T00:00:00Z | 03/18 20:00 | 0 | 2020-03-19T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | e0edbb17cb764117177ba0b76739879fa94b2a6f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10556 | 10556 | 20200322 | MP | 0 | 0 | 3/22/2020 01:30 | 2020-03-22T01:30:00Z | 03/21 21:30 | 0 | 2020-03-22T01:30:00Z | 69 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | dc5bb88739fa51fb329804b0e7a1264e4e8a049e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10579 | 10579 | 20200322 | VI | 6 | 6 | 3/21/2020 20:30 | 2020-03-21T20:30:00Z | 03/21 16:30 | 2020-03-21T20:30:00Z | 78 | 0 | 0 | 6 | posNeg | 0 | 6 | 0 | 0 | b70c96abc83090c55d6a00268b7278fda0aee532 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10588 | 10588 | 20200321 | AS | 0 | 3/19/2020 00:00 | 2020-03-19T00:00:00Z | 03/18 20:00 | 0 | 2020-03-19T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 56bc9dd7f9a89e2f572fdf7f860e79aed7c624dc | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10612 | 10612 | 20200321 | MP | 0 | 0 | 3/21/2020 02:30 | 2020-03-21T02:30:00Z | 03/20 22:30 | 0 | 2020-03-21T02:30:00Z | 69 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 7b4806fac769cf40900d179f2b20b952f4b60c29 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10635 | 10635 | 20200321 | VI | 6 | 6 | 3/20/2020 20:30 | 2020-03-20T20:30:00Z | 03/20 16:30 | 2020-03-20T20:30:00Z | 78 | 3 | 0 | 6 | posNeg | 3 | 6 | 0 | 0 | 74deacd22056ad300bc35e9009f3091f29eea219 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10644 | 10644 | 20200320 | AS | 0 | 3/19/2020 00:00 | 2020-03-19T00:00:00Z | 03/18 20:00 | 0 | 2020-03-19T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 5444833c0b79c2524133be999e8554a11f70e2ba | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10668 | 10668 | 20200320 | MP | 0 | 0 | 3/20/2020 01:30 | 2020-03-20T01:30:00Z | 03/19 21:30 | 0 | 2020-03-20T01:30:00Z | 69 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 131b0e810467954035aa570d229b3508496040cb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10691 | 10691 | 20200320 | VI | 3 | 3 | 3/19/2020 17:30 | 2020-03-19T17:30:00Z | 03/19 13:30 | 2020-03-19T17:30:00Z | 78 | 0 | 0 | 3 | posNeg | 0 | 3 | 0 | 0 | 2150999f5784b00971a0f42301b75de1faeda9ce | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10700 | 10700 | 20200319 | AS | 0 | 3/14/2020 00:00 | 2020-03-14T00:00:00Z | 03/13 20:00 | 0 | 2020-03-14T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | ee978d82333b52c69c28ab15558c64a90716e9f7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10724 | 10724 | 20200319 | MP | 0 | 0 | 3/19/2020 01:30 | 2020-03-19T01:30:00Z | 03/18 21:30 | 0 | 2020-03-19T01:30:00Z | 69 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 06ba43805e5a2737b831497cefd079d395ea9ccd | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10747 | 10747 | 20200319 | VI | 3 | 3 | 3/18/2020 07:30 | 2020-03-18T07:30:00Z | 03/18 03:30 | 2020-03-18T07:30:00Z | 78 | 1 | 0 | 3 | posNeg | 1 | 3 | 0 | 0 | 42d5262802dd8d90bebd4940712c571bb4c782c5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10756 | 10756 | 20200318 | AS | 0 | 3/14/2020 00:00 | 2020-03-14T00:00:00Z | 03/13 20:00 | 0 | 2020-03-14T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 85dde723a0ea8428498b88bfe3ce9d1a10add115 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10780 | 10780 | 20200318 | MP | 0 | 0 | 3/18/2020 03:30 | 2020-03-18T03:30:00Z | 03/17 23:30 | 0 | 2020-03-18T03:30:00Z | 69 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | a45da79bd9ca163c368e899e9cd7a8446d501a8a | 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 | |||||||||||||||||||||||||||||||
10812 | 10812 | 20200317 | AS | 0 | 3/14/2020 00:00 | 2020-03-14T00:00:00Z | 03/13 20:00 | 2020-03-14T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 866e05d9a716e95bba31b9b00cff84c78ee79a3b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10820 | 10820 | 20200317 | GA | 146 | 146 | 3/17/2020 12:00 | 2020-03-17T12:00:00Z | 03/17 08:00 | 1 | 2020-03-17T12:00:00Z | 146 | 13 | 25 | 0 | 146 | posNeg | 25 | 146 | 0 | 0 | 7d15e412b9033dc8d634938fa01af32c8cc7f297 | 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 | |||||||||||||||||||||||||||||||
10836 | 10836 | 20200317 | MP | 0 | 0 | 3/17/2020 01:30 | 2020-03-17T01:30:00Z | 03/16 21:30 | 2020-03-17T01:30:00Z | 69 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 86e2ad6d15b64284670910ea1c8c689c582d6c29 | 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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
10931 | 10931 | 20200315 | GA | 99 | 99 | 3/15/2020 11:43 | 2020-03-15T11:43:00Z | 03/15 07:43 | 1 | 2020-03-15T11:43:00Z | 99 | 13 | 33 | 0 | 99 | posNeg | 33 | 99 | 0 | 0 | f6c0a3f5a39a9f7d39288253f513c70a299b556f | 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 | |||||||||||||||||||||||||||||||
10964 | 10964 | 20200315 | TX | 56 | 56 | 3/15/2020 13:00 | 2020-03-15T13:00:00Z | 03/15 09:00 | 2020-03-15T13:00:00Z | 56 | 48 | 5 | 0 | 56 | posNeg | 5 | 56 | 0 | 0 | ab3616f3e81056e339ae4968f7ad29a5d215a3d4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10971 | 10971 | 20200315 | WY | 3 | 3 | 3/14/2020 00:00 | 2020-03-14T00:00:00Z | 03/13 20:00 | 2020-03-14T00:00:00Z | 2 | 56 | 1 | 0 | 3 | posNeg | 1 | 3 | 0 | 0 | 3efc0c35fd5b11255cc0db412b0aa8cc735c9d33 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10982 | 10982 | 20200314 | GA | 66 | 66 | 3/14/2020 12:00 | 2020-03-14T12:00:00Z | 03/14 08:00 | 1 | 2020-03-14T12:00:00Z | 66 | 13 | 24 | 0 | 66 | posNeg | 24 | 66 | 0 | 0 | 7cdaaffe0387cb3e75a49467c92695bae52b7493 | 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 | |||||||||||||||||||||||||||||||
10991 | 10991 | 20200314 | MA | 38 | 3036 | 3/14/2020 16:00 | 2020-03-14T16:00:00Z | 03/14 12:00 | 2020-03-14T16:00:00Z | 3036 | 308 | 25 | 15 | 0 | 38 | totalTestsViral | 935 | 38 | 0 | 0 | 8830304b5133a6666836dc49570feb00de0db53a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11015 | 11015 | 20200314 | TX | 51 | 51 | 3/14/2020 13:00 | 2020-03-14T13:00:00Z | 03/14 09:00 | 2020-03-14T13:00:00Z | 51 | 48 | 12 | 0 | 51 | posNeg | 12 | 51 | 0 | 0 | 2177af42c69e5598339f0e89709f43fa7819824f | 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 | ||||||||||||||||||||||||||||||
11033 | 11033 | 20200313 | GA | 42 | 42 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 1 | 2020-03-13T00:00:00Z | 42 | 13 | 11 | 0 | 42 | posNeg | 11 | 42 | 1 | 0 | 929ebe15aebea765312e0303b6d64f2aaec252b4 | 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 | |||||||||||||||||||||||||||||||
11042 | 11042 | 20200313 | MA | 23 | 2101 | 3/13/2020 16:00 | 2020-03-13T16:00:00Z | 03/13 12:00 | 2020-03-13T16:00:00Z | 2101 | 234 | 25 | 15 | 0 | 23 | totalTestsViral | 985 | 23 | 0 | 0 | dba1a4f4df634716856b361ccca691eca066ce31 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11066 | 11066 | 20200313 | TX | 39 | 39 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 39 | 48 | 16 | 0 | 39 | posNeg | 16 | 39 | 0 | 0 | 89daff6981d900f5eb3da22dbc1d3e7aa7995235 | 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 | ||||||||||||||||||||||||||||||
11084 | 11084 | 20200312 | GA | 31 | 31 | 3/11/2020 20:00 | 2020-03-11T20:00:00Z | 03/11 16:00 | 2020-03-11T20:00:00Z | 31 | 13 | 9 | 0 | 31 | posNeg | 9 | 31 | 0 | 0 | 9901a43d1039d014a12e52012a3e728698be29fd | 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 | |||||||||||||||||||||||||||||||
11093 | 11093 | 20200312 | MA | 8 | 1116 | 3/11/2020 00:00 | 2020-03-11T00:00:00Z | 03/10 20:00 | 2020-03-11T00:00:00Z | 1116 | 170 | 25 | 8 | 0 | 8 | totalTestsViral | 432 | 8 | 0 | 0 | e1aec5853d616b5b50cc8939867e4dc78b498a4e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11117 | 11117 | 20200312 | TX | 23 | 23 | 3/12/2020 11:00 | 2020-03-12T11:00:00Z | 03/12 07:00 | 2020-03-12T11:00:00Z | 23 | 48 | 2 | 0 | 23 | posNeg | 2 | 23 | 0 | 0 | caf5767b30633c81c427d655e0dcb01eb37339a6 | 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 | |||||||||||||||||||||||||||||||
11135 | 11135 | 20200311 | GA | 22 | 22 | 22 | 13 | 5 | 0 | 22 | posNeg | 5 | 22 | 0 | 0 | 6a8eb005e89ebe7da40630c3642fbc521d173c56 | 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 | |||||||||||||||||||||||||||||||||||
11144 | 11144 | 20200311 | MA | 684 | 684 | 141 | 25 | 0 | 0 | 0 | totalTestsViral | 182 | 0 | 0 | 0 | 00f59454c2a60b2b5bafc97f9ef7ef926ac933ad | 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 | |||||||||||||||||||||||||||||||
11152 | 11152 | 20200311 | NC | 7 | 7 | 37 | 0 | 0 | 7 | posNeg | 0 | 7 | 0 | 0 | f08f3575b2389f5750a6482b9e396fff8e5b77e8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11168 | 11168 | 20200311 | TX | 21 | 21 | 21 | 48 | 8 | 0 | 21 | posNeg | 8 | 21 | 0 | 0 | b56b728a444a78c2539037abe371c46b98dc75ef | 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 | ||||||||||||||||||||||||||||||||||
11175 | 11175 | 20200311 | WY | 0 | 0 | 56 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | c0cd25bf9e8ddb116a8abd288754efb0622c957a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11186 | 11186 | 20200310 | GA | 17 | 17 | 17 | 13 | 5 | 0 | 17 | posNeg | 5 | 17 | 0 | 0 | cb1578a7d62286b6b4a39d4005b1e78b73288fe2 | 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 | |||||||||||||||||||||||||||||||||||
11195 | 11195 | 20200310 | MA | 502 | 502 | 118 | 25 | 0 | 0 | 0 | totalTestsViral | 109 | 0 | 0 | 0 | c61340dfc640f0353f757001c94ddd70f2e1a36b | 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 | |||||||||||||||||||||||||||||||
11201 | 11201 | 20200310 | MS | 0 | 0 | 28 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 871b4a3ed094a83045fa927b0ea473d2a961c590 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11203 | 11203 | 20200310 | NC | 7 | 7 | 37 | 5 | 0 | 7 | posNeg | 5 | 7 | 0 | 0 | 5ca8052a4e856770ed70c15e9958fc5f3d3fbdac | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11214 | 11214 | 20200310 | PA | 12 | 12 | 42 | 2 | 0 | 12 | posNeg | 2 | 12 | 0 | 0 | 5306c4c8ab63553e58483df8c2542c1c46d9131b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11218 | 11218 | 20200310 | TN | 7 | 7 | 47 | 4 | 0 | 7 | posNeg | 4 | 7 | 0 | 0 | 832ea8e2093dbc3ddbebcd241580dfd3ac10ed7b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11219 | 11219 | 20200310 | TX | 13 | 13 | 13 | 48 | 1 | 0 | 13 | posNeg | 1 | 13 | 0 | 0 | 04564a14da022e174796d98935bed685227bc5de | 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 | ||||||||||||||||||||||||||||||||||
11228 | 11228 | 20200309 | AL | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | c8b981d2d519258ae7dcbd645dd8adcc77cda02c | 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 );