states_daily_4pm_et

Table actions

Data source: Big Local News · About: big-local-datasette

372 rows where dataQualityGrade = "D"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, pending, positiveTestsViral, negativeTestsViral, deathProbable, fips, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date), dateChecked (date)

dataQualityGrade ✖

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
4 4 20200926 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 b9eccb7369bdc4ee75708c7a892c5437ab915d83 0 0 0 0 0  
28 28 20200926 MP 69 14776   14845   4         29 D 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 2 4 2020-09-25T00:00:00Z 19835     69 2     14845                     69 0 0 14845 posNeg 0 14845 0 0 6fdb4898ec2dbbb6eafe41b19ae56eff50411718 0 0 0 0 0  
51 51 20200926 VI 1296 18676 8 19972             1209 D 9/25/2020 09:30 2020-09-25T09:30:00Z 09/25 05:30 19   2020-09-25T09:30:00Z 19980       19                           78 0 0 19980 posNeg 0 19972 0 0 61739fb2efab7827062ca9cc633984208f34bc24 0 0 0 0 0  
60 60 20200925 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 84c6296997b54d1474da9d9c51e33d48fda7fb5b 0 0 0 0 0  
84 84 20200925 MP 69 14776   14845   4         29 D 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 2 4 2020-09-25T00:00:00Z 19835     69 2     14845                     69 0 0 14845 posNeg 0 14845 0 0 39c03ce7322961c11b761e8e31a673b6a2030e95 0 0 0 0 0  
107 107 20200925 VI 1296 18676 8 19972             1209 D 9/25/2020 09:30 2020-09-25T09:30:00Z 09/25 05:30 19   2020-09-25T09:30:00Z 19980       19                           78 6 142 19980 posNeg 148 19972 0 0 fae7c9c388a0a44bc2800e78f8691ac3df144574 0 0 0 0 0  
116 116 20200924 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 f949dd0d4f1a5cc85607dc1e308d0088f67199bd 0 0 0 0 0  
140 140 20200924 MP 69 14776   14845   4         29 D 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 2 4 2020-09-23T00:00:00Z 19835     69 2     14845                     69 0 0 14845 posNeg 0 14845 0 0 6983d1e4b087aa16fbd32a6e21c9c17323b5690b 0 0 0 0 0  
163 163 20200924 VI 1290 18534 11 19824             1208 D 9/23/2020 18:43 2020-09-23T18:43:00Z 09/23 14:43 19   2020-09-23T18:43:00Z 19835       19                           78 12 194 19835 posNeg 206 19824 0 0 8b7638a28177fb9962b7b9184d719e608ce1b89f 0 0 0 0 0  
172 172 20200923 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 2c46457ee4f802b1f3f14dabbca92ccfbf5670d7 0 0 0 0 0  
196 196 20200923 MP 69 14776   14845   4         29 D 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 2 4 2020-09-22T00:00:00Z 19835     69 2     14845                     69 0 460 14845 posNeg 460 14845 0 0 8884c28f22aea04c24f174e0569788e75c824853 0 0 0 0 0  
219 219 20200923 VI 1278 18340 7 19618             1198 D 9/22/2020 20:33 2020-09-22T20:33:00Z 09/22 16:33 19   2020-09-22T20:33:00Z 19625       19                           78 2 152 19625 posNeg 154 19618 0 0 7012dc1e4b73977908c498ce51625ee7d0f9f788 0 0 0 0 0  
228 228 20200922 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 1fbce7d9c6b9b287e0974b92a27198573fb8ecdf 0 0 0 0 0  
252 252 20200922 MP 69 14316   14385   4         29 D 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 2 4 2020-09-21T00:00:00Z 18915     69 2     14375                     69 0 0 14385 posNeg 0 14385 0 0 b2b70beaa641ee9432bb4e9d068498aa2482c650 0 0 0 0 0  
275 275 20200922 VI 1276 18188 15 19464             1195 D 9/22/2020 12:42 2020-09-22T12:42:00Z 09/22 08:42 19   2020-09-22T12:42:00Z 19479       19                           78 7 145 19479 posNeg 152 19464 0 0 191a687d009f07d86fd52430b0fdc8be9f99f7c2 0 0 0 0 0  
284 284 20200921 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 fe2ac904fb66e75d6ba49697cef3e44e5eee9332 0 0 0 0 0  
308 308 20200921 MP 69 14316   14385   4         29 D 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 2 4 2020-09-21T00:00:00Z 18915     69 2     14375                     69 1 0 14385 posNeg 1 14385 0 0 99470fe591f97a5a0ea49b7b3a360e1367716668 0 0 0 0 0  
331 331 20200921 VI 1269 18043 2 19312             1186 D 9/20/2020 11:16 2020-09-20T11:16:00Z 09/20 07:16 19   2020-09-20T11:16:00Z 19314       19                           78 0 0 19314 posNeg 0 19312 0 0 d6b14de23445b4ec73bcf3ab0f7b006d626cece5 0 0 0 0 0  
340 340 20200920 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 3e8d4473820fe86e6e0d374bbcf084d1a4283566 0 0 0 0 0  
364 364 20200920 MP 68 14316   14384   4         29 D 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 2 4 2020-09-20T00:00:00Z 18915     68 2     14375                     69 6 0 14384 posNeg 6 14384 0 0 03ba5cc13165089a665479e9cf4b938d0355bf05 0 0 0 0 0  
387 387 20200920 VI 1269 18043 2 19312             1186 D 9/20/2020 11:16 2020-09-20T11:16:00Z 09/20 07:16 19   2020-09-20T11:16:00Z 19314       19                           78 27 331 19314 posNeg 358 19312 0 0 be003cbf815c110eb91b2469e88ea1b5f5873bb7 0 0 0 0 0  
396 396 20200919 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 678ba0c96c17a95db48c29d3e95785ec49852061 0 0 0 0 0  
420 420 20200919 MP 62 14316   14378   4         29 D 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 2 4 2020-09-17T00:00:00Z 18915     62 2     14375                     69 0 0 14378 posNeg 0 14378 0 0 c16dbd331a66d39667dae005b93458d850cf470c 0 0 0 0 0  
443 443 20200919 VI 1242 17712 26 18954             1174 D 9/18/2020 09:31 2020-09-18T09:31:00Z 09/18 05:31 19   2020-09-18T09:31:00Z 18980       19                           78 0 0 18980 posNeg 0 18954 0 0 74c3ad4b5e0bdde6cc102509080792f9d6835342 0 0 0 0 0  
452 452 20200918 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 4953337207aa6ea9f70d3e91b93db3bd67bd2589 0 0 0 0 0  
476 476 20200918 MP 62 14316   14378   4         29 D 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 2 4 2020-09-17T00:00:00Z 18915     62 2     14375                     69 0 0 14378 posNeg 0 14378 0 0 dc26aece47e039aa4d08d4c62a1527bcf0ab05f1 0 0 0 0 0  
499 499 20200918 VI 1242 17712 26 18954             1174 D 9/18/2020 09:31 2020-09-18T09:31:00Z 09/18 05:31 19   2020-09-18T09:31:00Z 18980       19                           78 4 171 18980 posNeg 175 18954 0 0 61df3960b89edff6f3730beb2cc3165b5a7afcb7 0 0 0 0 0  
508 508 20200917 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 54f9bc2755f89f45c7a1fa08c2b1a68d14fdc849 0 0 0 0 0  
532 532 20200917 MP 62 14316   14378   4         29 D 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 2 4 2020-09-17T00:00:00Z 18915     62 2     14375                     69 1 0 14378 posNeg 1 14378 0 0 9167731bc47435785ac4fa474b8694e9d95c08c8 0 0 0 0 0  
555 555 20200917 VI 1238 17541 21 18779             1172 D 9/17/2020 06:24 2020-09-17T06:24:00Z 09/17 02:24 19   2020-09-17T06:24:00Z 18800       19                           78 6 101 18800 posNeg 107 18779 0 0 d9073f442e2c6aa5d3f1718b6b3df2237c2b9e6b 0 0 0 0 0  
564 564 20200916 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 1e432dfcc52e27d75970f4b590b1e74ec5a025a5 0 0 0 0 0  
588 588 20200916 MP 61 14316   14377   4         29 D 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 2 4 2020-09-14T00:00:00Z 18915     61 2     14375                     69 0 0 14377 posNeg 0 14377 0 0 a1fe38f57df76cbef46c807705b1b50386037548 0 0 0 0 0  
611 611 20200916 VI 1232 17440 10 18672             1170 D 9/15/2020 20:04 2020-09-15T20:04:00Z 09/15 16:04 19   2020-09-15T20:04:00Z 18682       19                           78 7 120 18682 posNeg 127 18672 0 0 b3f664e4ae88d35d0a896a9ac5de9a8703951f92 0 0 0 0 0  
1652 1652 20200828 MP 54 13486   13540   4         29 D 8/26/2020 23:49 2020-08-26T23:49:00Z 08/26 19:49 2 4 2020-08-26T23:49:00Z 17626     54 2     13540                     69 0 0 13540 posNeg 0 13540 0 0 ff1a8404afb984304eb95c1436e2d07c75e6c5bf 0 0 0 0 0  
1708 1708 20200827 MP 54 13486   13540   4         29 D 8/26/2020 23:49 2020-08-26T23:49:00Z 08/26 19:49 2 4 2020-08-26T23:49:00Z 17626     54 2     13540                     69 0 619 13540 posNeg 619 13540 0 0 10819467d4a425b3d387570a2513bdaeeb25207a 0 0 0 0 0  
1764 1764 20200826 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 0bf683fc6f56b4f97f9ae354bf75743a9a8319fa 0 0 0 0 0  
1820 1820 20200825 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 ed246f0f20ccdce0111fb372bcfeae07550195a8 0 0 0 0 0  
1876 1876 20200824 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 8ddda8a06e3cf9b36b6724bdb97f35971d13f7be 0 0 0 0 0  
1932 1932 20200823 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 b5fefa2da2987cc3665ab46349aa00b74f5c7519 0 0 0 0 0  
1988 1988 20200822 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 821f9beeecb7d6c39079ca0da688becebb3bf69e 0 0 0 0 0  
2044 2044 20200821 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 3edfec6d35750f0d2ee8d31d829606dab1dd0e1b 0 0 0 0 0  
2100 2100 20200820 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 1 12921 posNeg 1 12921 0 0 8e06fa27b11574d06b3200cffd77705b51cc91d0 0 0 0 0 0  
2156 2156 20200819 MP 54 12866   12920   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12920 posNeg 0 12920 0 0 6a24ee889d9d9d0b7758a111995fa1eff8b893f1 0 0 0 0 0  
2212 2212 20200818 MP 54 12866   12920   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54       12920                     69 1 -1 12920 posNeg 0 12920 0 0 a63741bea14a2c854485327bedad895bef6d14bb 0 0 0 0 0  
2268 2268 20200817 MP 53 12867   12920   4         29 D 8/17/2020 04:04 2020-08-17T04:04:00Z 08/17 00:04 2 4 2020-08-17T04:04:00Z 16453     53       12920                     69 3 615 12920 posNeg 618 12920 0 0 bc6c175e5cb73add0628a192468ee34e6fd453bc 0 0 0 0 0  
2324 2324 20200816 MP 50 12252   12302   4         29 D 8/14/2020 04:04 2020-08-14T04:04:00Z 08/14 00:04 2 4 2020-08-14T04:04:00Z 14419     50       12301                     69 0 0 12302 posNeg 0 12302 0 0 e29785632491865005d223c8b32dbaa71785877d 0 0 0 0 0  
2380 2380 20200815 MP 50 12252   12302   4         29 D 8/14/2020 04:04 2020-08-14T04:04:00Z 08/14 00:04 2 4 2020-08-14T04:04:00Z 14419     50       12301                     69 0 0 12302 posNeg 0 12302 0 0 9a091737f61ec37dbcb01bc4004246941f7efa3a 0 0 0 0 0  
2436 2436 20200814 MP 50 12252   12302   4         29 D 8/14/2020 04:04 2020-08-14T04:04:00Z 08/14 00:04 2 4 2020-08-14T04:04:00Z 14419     50       12301                     69 1 0 12302 posNeg 1 12302 0 0 dc9d6207fc769c5c706064a69c1aeb74ae721781 0 0 0 0 0  
2492 2492 20200813 MP 49 12252   12301   4         29 D 8/10/2020 17:54 2020-08-10T17:54:00Z 08/10 13:54 2 4 2020-08-10T17:54:00Z 14419     49       12301                     69 0 0 12301 posNeg 0 12301 0 0 cac86151805935a672b87aae8045c4ffc7e41ef0 0 0 0 0 0  
2548 2548 20200812 MP 49 12252   12301   4         29 D 8/10/2020 17:54 2020-08-10T17:54:00Z 08/10 13:54 2 4 2020-08-10T17:54:00Z 14419     49       12301                     69 0 0 12301 posNeg 0 12301 0 0 06a65d88f3baf55a9c98b97c3c0ab3d2d7ada48b 0 0 0 0 0  
2604 2604 20200811 MP 49 12252   12301   4         29 D 8/10/2020 17:54 2020-08-10T17:54:00Z 08/10 13:54 2 4 2020-08-10T17:54:00Z 14419     49       12301                     69 0 0 12301 posNeg 0 12301 0 0 66b9604f22297d7f375321b2d453f9239874521b 0 0 0 0 0  
2660 2660 20200810 MP 49 12252   12301   4         29 D 8/9/2020 00:59 2020-08-09T00:59:00Z 08/08 20:59 2 4 2020-08-09T00:59:00Z 14419     49       12301                     69 1 -1 12301 posNeg 0 12301 0 0 27537b0e77e326309a30655bd7b5264b13de3535 0 0 0 0 0  
2716 2716 20200809 MP 48 12253   12301   4         29 D 8/9/2020 00:59 2020-08-09T00:59:00Z 08/08 20:59 2 4 2020-08-09T00:59:00Z 14419     48       12301                     69 0 0 12301 posNeg 0 12301 0 0 21095d9a1975380327dd636f642ebcdb54c36178 0 0 0 0 0  
2772 2772 20200808 MP 48 12253   12301   4         29 D 8/9/2020 00:59 2020-08-09T00:59:00Z 08/08 20:59 2 4 2020-08-09T00:59:00Z 14419     48       12301                     69 1 -1 12301 posNeg 0 12301 0 0 383ebc04a9b24d77fba4ce8ac83a5b8d78120ddc 0 0 0 0 0  
2828 2828 20200807 MP 47 12254   12301   4         29 D 8/6/2020 04:01 2020-08-06T04:01:00Z 08/06 00:01 2 4 2020-08-06T04:01:00Z 14419     47       12301                     69 0 0 12301 posNeg 0 12301 0 0 0b1e8dc3177bfacf890ed3ffc424a20550d1dc88 0 0 0 0 0  
2884 2884 20200806 MP 47 12254   12301   4         29 D 8/6/2020 04:01 2020-08-06T04:01:00Z 08/06 00:01 2 4 2020-08-06T04:01:00Z 14419     47       12301                     69 1 -1 12301 posNeg 0 12301 0 0 ba1cf0aa5e02c26286e14662a5ba756c4597b1db 0 0 0 0 0  
2940 2940 20200805 MP 46 12255   12301   4         29 D 8/5/2020 00:22 2020-08-05T00:22:00Z 08/04 20:22 2 4 2020-08-05T00:22:00Z 14419     46       12301                     69 0 0 12301 posNeg 0 12301 0 0 0e57d1d306016962e8ddd3d5b64018a26da896fd 0 0 0 0 0  
2996 2996 20200804 MP 46 12255   12301   4         29 D 8/3/2020 03:26 2020-08-03T03:26:00Z 08/02 23:26 2 4 2020-08-03T03:26:00Z 14419     46       12301                     69 0 0 12301 posNeg 0 12301 0 0 efffa25e9bb5939c9b3a20e9b8f0253fb99dd115 0 0 0 0 0  
3052 3052 20200803 MP 46 12255   12301   4         29 D 8/3/2020 03:26 2020-08-03T03:26:00Z 08/02 23:26 2 4 2020-08-03T03:26:00Z 14419     46       12301                     69 1 536 12301 posNeg 537 12301 0 0 6ee0551f8b44353836a1d9eb098e071c3d6157c0 0 0 0 0 0  
3108 3108 20200802 MP 45 11719   11764   4         29 D 8/1/2020 11:33 2020-08-01T11:33:00Z 08/01 07:33 2 4 2020-08-01T11:33:00Z 12745     45       11759                     69 3 0 11764 posNeg 3 11764 0 0 77be00930f007b1d0bf9dcf3aaad6ded7b0696ae 0 0 0 0 0  
3164 3164 20200801 MP 42 11719   11761   4         29 D 7/30/2020 02:49 2020-07-30T02:49:00Z 07/29 22:49 2 4 2020-07-30T02:49:00Z 12745     42       11759                     69 0 0 11761 posNeg 0 11761 0 0 67d8c25a42346ed3ba4508574ebe7b7ebfe9c59e 0 0 0 0 0  
3220 3220 20200731 MP 42 11719   11761   4         29 D 7/29/2020 23:49 2020-07-29T23:49:00Z 07/29 19:49 2 4 2020-07-29T23:49:00Z 12745     42       11759                     69 0 0 11761 posNeg 0 11761 0 0 13866665f1938fa2d42867337b4999b670c1a3c5 0 0 0 0 0  
3276 3276 20200730 MP 42 11719   11761   4         29 D 7/29/2020 23:49 2020-07-29T23:49:00Z 07/29 19:49 2 4 2020-07-29T23:49:00Z 12745     42       11759                     69 2 0 11761 posNeg 2 11761 0 0 4490d8e196022543faef530f8e579bbfeaea6824 0 0 0 0 0  
3318 3318 20200729 HI 1757 115802   117559 47 167         1205 D 7/28/2020 23:04 2020-07-28T23:04:00Z 07/28 19:04 26 167 2020-07-28T23:04:00Z 145404             117559                     15 46 1126 117559 posNeg 1172 117559 0 2 8f7e344b9c23674aefc02ac38473c5a82a318629 0 0 0 0 0  
3332 3332 20200729 MP 40 11719   11759   4         29 D 7/29/2020 02:48 2020-07-29T02:48:00Z 07/28 22:48 2 4 2020-07-29T02:48:00Z 12745     40       11759                     69 0 0 11759 posNeg 0 11759 0 0 81558101f3f785966355cf07ed2323478a37d87d 0 0 0 0 0  
3374 3374 20200728 HI 1711 114676   116387 39 165         1191 D 7/28/2020 00:00 2020-07-28T00:00:00Z 07/27 20:00 26 165 2020-07-28T00:00:00Z 143791             116387                     15 28 2244 116387 posNeg 2272 116387 0 2 ac3c33d0521db25246d6c36cc22d2d16b558f951 0 0 0 0 0  
3388 3388 20200728 MP 40 11719   11759   4         29 D 7/28/2020 01:35 2020-07-28T01:35:00Z 07/27 21:35 2 4 2020-07-28T01:35:00Z 12745     40       11759                     69 0 0 11759 posNeg 0 11759 0 0 9b5681bc7a0f256602e75f8262bc71ef36da800f 0 0 0 0 0  
3430 3430 20200727 HI 1683 112432   114115 26 163         1179 D 7/27/2020 00:00 2020-07-27T00:00:00Z 07/26 20:00 26 163 2020-07-27T00:00:00Z 142900             114052                     15 63 0 114115 posNeg 63 114115 0 2 4254f76d491d73ab967e1831f641351585d6e374 0 0 0 0 0  
3444 3444 20200727 MP 40 11719   11759   4         29 D 7/27/2020 03:22 2020-07-27T03:22:00Z 07/26 23:22 2 4 2020-07-27T03:22:00Z 12745     40       11759                     69 0 419 11759 posNeg 419 11759 0 0 97dee1f24578ce7bc8579828a3386b51a0da722b 0 0 0 0 0  
3486 3486 20200726 HI 1620 112432   114052 29 161         1167 D 7/25/2020 18:39 2020-07-25T18:39:00Z 07/25 14:39 26 161 2020-07-25T18:39:00Z 140442             114052                     15 71 1191 114052 posNeg 1262 114052 0 5 247a167f9423d1bc58b14b9d72fc3fc407cb9d3b 0 0 0 0 0  
3500 3500 20200726 MP 40 11300   11340   4         29 D 7/25/2020 23:05 2020-07-25T23:05:00Z 07/25 19:05 2 4 2020-07-25T23:05:00Z 12745     40       11338                     69 1 0 11340 posNeg 1 11340 0 0 d06634ff51bd37c335d918710a99dc3996121908 0 0 0 0 0  
3542 3542 20200725 HI 1549 111241   112790 29 156         1148 D 7/24/2020 18:00 2020-07-24T18:00:00Z 07/24 14:00 26 156 2020-07-24T18:00:00Z 138354             112790                     15 59 1440 112790 posNeg 1499 112790 0 1 1b3c1b47b81810bde90d944d2a7f5a5e9035c388 0 0 0 0 0  
3556 3556 20200725 MP 39 11300   11339   4         29 D 7/25/2020 07:47 2020-07-25T07:47:00Z 07/25 03:47 2 4 2020-07-25T07:47:00Z 12745     39       11338                     69 1 0 11339 posNeg 1 11339 0 0 d2aae267ced40eba05e17954b61c50de1dfb6ee6 0 0 0 0 0  
3598 3598 20200724 HI 1490 109801   111291 39 155         1125 D 7/23/2020 18:00 2020-07-23T18:00:00Z 07/23 14:00 26 155 2020-07-23T18:00:00Z 136008             111291                     15 55 2423 111291 posNeg 2478 111291 1 1 6709fdc1f828152bd6af5af7090e7bd779d4990a 0 0 0 0 0  
3612 3612 20200724 MP 38 11300   11338   4         29 D 7/24/2020 02:47 2020-07-24T02:47:00Z 07/23 22:47 2 4 2020-07-24T02:47:00Z 12745     38       11338                     69 0 0 11338 posNeg 0 11338 0 0 6ea47bcefbe09561ef3dce58616e13ceeb661eb4 0 0 0 0 0  
3654 3654 20200723 HI 1435 107378   108813 39 154         1113 D 7/22/2020 18:00 2020-07-22T18:00:00Z 07/22 14:00 25 154 2020-07-22T18:00:00Z 132361             108813                     15 17 614 108813 posNeg 631 108813 1 3 d5b5bc37a136f79176881f397a2353097a069616 0 0 0 0 0  
3668 3668 20200723 MP 38 11300   11338   4         29 D 7/22/2020 19:22 2020-07-22T19:22:00Z 07/22 15:22 2 4 2020-07-22T19:22:00Z 12745     38       11338                     69 0 -1407 11338 posNeg -1407 11338 0 0 28052e9e42f7247a5415e62cf82ad2d7a620492c 0 0 0 0 0  
3710 3710 20200722 HI 1418 106764   108182 47 151         1084 D 7/21/2020 00:00 2020-07-21T00:00:00Z 07/20 20:00 24 151 2020-07-21T00:00:00Z 131371             108182                     15 25 1374 108182 posNeg 1399 108182 0 1 7c5e55803b6cc1da8d25cea3d59123acbbb2bdef 0 0 0 0 0  
3724 3724 20200722 MP 38 12707   12745   4         29 D 7/21/2020 08:46 2020-07-21T08:46:00Z 07/21 04:46 2 4 2020-07-21T08:46:00Z 12745     38       11338                     69 0 1652 12745 posNeg 1652 12745 0 0 d855c0ad9c741df31cd8af280bf62d96af366323 0 0 0 0 0  
3766 3766 20200721 HI 1393 105390   106783 46 150         1057 D 7/20/2020 00:00 2020-07-20T00:00:00Z 07/19 20:00 24 150 2020-07-20T00:00:00Z 129510             106783                     15 12 815 106783 posNeg 827 106783 0 0 651d7b0992e11704f445bceb1be314d5693491db 0 0 0 0 0  
3780 3780 20200721 MP 38 11055   11093   4         29 D 7/20/2020 19:53 2020-07-20T19:53:00Z 07/20 15:53 2 4 2020-07-20T19:53:00Z 12236     38       11092                     69 1 0 11093 posNeg 1 11093 0 0 9a78d91decb7df7f181afa452edccaee74b1a406 0 0 0 0 0  
3784 3784 20200721 ND 5202 132086   259986 46 309         4319 D 7/21/2020 00:00 2020-07-21T00:00:00Z 07/20 20:00 84 309 2020-07-21T00:00:00Z 266719     5202 80 4 259986 134658 6474 233 6241               38 82 1234 137288 totalTestEncountersViral 3573 137288 2 4 dbf953dbce4d72177bd2fca331d01b4965d42527 0 0 0 0 0  
3822 3822 20200720 HI 1381 104575   105956 33 150         1043 D 7/19/2020 00:00 2020-07-19T00:00:00Z 07/18 20:00 24 150 2020-07-19T00:00:00Z 128374             105956                     15 27 1294 105956 posNeg 1321 105956 0 10 1824b659ce49b4906d9a6090a829edae7e16c08f 0 0 0 0 0  
3836 3836 20200720 MP 37 11055   11092   4         29 D 7/19/2020 19:55 2020-07-19T19:55:00Z 07/19 15:55 2 4 2020-07-19T19:55:00Z 12236     37       11092                     69 0 391 11092 posNeg 391 11092 0 0 d43dd42ba634fce87b6162bb5d5ab705b69cabc7 0 0 0 0 0  
3840 3840 20200720 ND 5120 130852   256413 47 305         4219 D 7/20/2020 00:00 2020-07-20T00:00:00Z 07/19 20:00 82 305 2020-07-20T00:00:00Z 262974     5120 78 4 256413 133420 6359 230 6129               38 107 2017 135972 totalTestEncountersViral 5509 135972 0 3 a465cbd2445138704124644dea3c8e5e78aa1584 0 0 0 0 0  
3878 3878 20200719 HI 1354 103281   104635 39 140         1019 D 7/18/2020 18:00 2020-07-18T18:00:00Z 07/18 14:00 24 140 2020-07-18T18:00:00Z 126454             104635                     15 20 1620 104635 posNeg 1640 104635 1 1 e7be656c7d8c431f22dbbbb7078e5bb0908c2e50 0 0 0 0 0  
3892 3892 20200719 MP 37 10664   10701   4         29 D 7/16/2020 19:06 2020-07-16T19:06:00Z 07/16 15:06 2 4 2020-07-16T19:06:00Z 11335     37       10697                     69 0 0 10701 posNeg 0 10701 0 0 bd4f94361289895d2ae39b79aa2402be801c9256 0 0 0 0 0  
3896 3896 20200719 ND 5013 128835   250904 45 302         4131 D 7/19/2020 00:00 2020-07-19T00:00:00Z 07/18 20:00 82 302 2020-07-19T00:00:00Z 257256     5013 78 4 250904 131374 6353 229 6124               38 113 2227 133848 totalTestEncountersViral 5412 133848 0 7 610ddeaaedcadd1a20dd2246317651532496dd05 0 0 0 0 0  
3934 3934 20200718 HI 1334 101661   102995 39 139         994 D 7/17/2020 18:00 2020-07-17T18:00:00Z 07/17 14:00 23 139 2020-07-17T18:00:00Z 124068             102995                     15 23 1768 102995 posNeg 1791 102995 1 1 c54a1deb4d1b12b5e3a27da087b676ae5a864cb3 0 0 0 0 0  
3948 3948 20200718 MP 37 10664   10701   4         29 D 7/16/2020 19:06 2020-07-16T19:06:00Z 07/16 15:06 2 4 2020-07-16T19:06:00Z 11335     37       10697                     69 0 0 10701 posNeg 0 10701 0 0 0c41e8889d377e71d5f59d0f56bc915e4311b0d6 0 0 0 0 0  
3952 3952 20200718 ND 4900 126608   245492 38 295         4029 D 7/18/2020 00:00 2020-07-18T00:00:00Z 07/17 20:00 82 295 2020-07-18T00:00:00Z 251712     4900 78 4 245492 129022 6343 229 6114               38 116 1925 131508 totalTestEncountersViral 4622 131508 0 5 fc68c4f4292296d1b7eec3b5137cb4697dff64e0 0 0 0 0 0  
3990 3990 20200717 HI 1311 99893   101204 39 138         975 D 7/16/2020 18:00 2020-07-16T18:00:00Z 07/16 14:00 22 138 2020-07-16T18:00:00Z 121512             101204                     15 19 1798 101204 posNeg 1817 101204 0 1 b9a368af20b88a6337634ede365017da085003ad 0 0 0 0 0  
4004 4004 20200717 MP 37 10664   10701   4         29 D 7/16/2020 19:06 2020-07-16T19:06:00Z 07/16 15:06 2 4 2020-07-16T19:06:00Z 11335     37       10697                     69 1 0 10701 posNeg 1 10701 0 0 5cd6e4a5cf622af8dedd9a05ea6ecfe29983b98f 0 0 0 0 0  
4008 4008 20200717 ND 4784 124683   240870 36 290         3903 D 7/17/2020 00:00 2020-07-17T00:00:00Z 07/16 20:00 82 290 2020-07-17T00:00:00Z 246923     4784 78 4 240870 127021 6171 225 5946               38 122 1295 129467 totalTestEncountersViral 4021 129467 0 5 d06dfe10b78f3f420be9e105591ed83e40683452 0 0 0 0 0  
4046 4046 20200716 HI 1292 98095   99387 40 137         951 D 7/15/2020 18:00 2020-07-15T18:00:00Z 07/15 14:00 22 137 2020-07-15T18:00:00Z 118842             99387                     15 28 1802 99387 posNeg 1830 99387 0 4 5df103ac3ae1e7abc2d566df9a8b69ad86091280 0 0 0 0 0  
4060 4060 20200716 MP 36 10664   10700   4         29 D 7/13/2020 18:48 2020-07-13T18:48:00Z 07/13 14:48 2 4 2020-07-13T18:48:00Z 11335     36       10697                     69 0 0 10700 posNeg 0 10700 0 0 97b3dd338a5fbe8f1e3eadac9be97ca8cb1ef741 0 0 0 0 0  
4064 4064 20200716 ND 4662 123388   236849 38 285         3796 D 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 82 285 2020-07-16T00:00:00Z 242783     4662 78 4 236849 125515 6109 217 5892               38 103 1389 128050 totalTestEncountersViral 3971 128050 1 1 0eaa51221352f21e631184c18e8bb211b23d84b4 0 0 0 0 0  
4102 4102 20200715 HI 1264 96293   97557 31 133         921 D 7/14/2020 18:00 2020-07-14T18:00:00Z 07/14 14:00 22 133 2020-07-14T18:00:00Z 116275             97557                     15 21 1466 97557 posNeg 1487 97557 0 5 bd194121a8e5c2cfa41bc4762246df93c33d982f 0 0 0 0 0  
4116 4116 20200715 MP 36 10664   10700   4         29 D 7/14/2020 04:48 2020-07-14T04:48:00Z 07/14 00:48 2 4 2020-07-14T04:48:00Z 11335     36       10697                     69 3 0 10700 posNeg 3 10700 0 0 f132a86dedbb6cae9ad0e2f8603c18aed93e040d 0 0 0 0 0  
4120 4120 20200715 ND 4559 121999   232878 42 284         3760 D 7/15/2020 00:00 2020-07-15T00:00:00Z 07/14 20:00 81 284 2020-07-15T00:00:00Z 238594     4559 77 4 232878 124007 5997 211 5786               38 72 1459 126558 totalTestEncountersViral 2953 126558 3 4 8f88f665111cdbddbd117ad38ed07726a20c9820 0 0 0 0 0  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);