states_daily_4pm_et

Table actions

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

11,578 rows sorted by positiveIncrease

✎ View and edit SQL

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
1366 1366 20200902 MA 121131 1650575   2478482 308 12295 58   29   103920 A+ 9/2/2020 08:00 2020-09-02T08:00:00Z 09/02 04:00 9060 12295 2020-09-02T08:00:00Z 2478482 157208   119426 8853 207   1770001       113667     89417       25 -7757 15291 1771706 totalTestsViral 30141 1771706 -4 -91 84c59dc2860aa46378b075c0e29e522e52214058 0 0 0 0 0  
2355 2355 20200815 AR 51992 536268   588660 464 3562     108 460 44905 A 8/15/2020 16:31 2020-08-15T16:31:00Z 08/15 12:31 600 3562 2020-08-15T16:31:00Z 588660   536268 51992                         7090 1085 5 -400 0 588260 posNeg 0 588260 13 -4 7073efb6076ddc4526493942dff0937f8e77e138 0 0 0 0 0  
8835 8835 20200422 PR 915 8842 1954 9757 140             A 4/22/2020 06:05 2020-04-22T06:05:00Z 04/22 02:05 67   2020-04-22T06:05:00Z                                     72 -383 53 11711 posNeg -330 9757 3 0 5cc7dd1e626594f5175f45190a04d4db8d1536b3 0 0 0 0 0  
100 100 20200925 RI 24181 305853   727469 94 2725 8   4   2278 A+ 9/25/2020 12:00 2020-09-25T12:00:00Z 09/25 08:00 1107 2725 2020-09-25T12:00:00Z   34299 693170 24181     727469 330034                     44 -130 2581 330034 totalTestEncountersViral 10422 330034 1 0 93a877812623e1750b2c506f59e53ecfc693fb8e 0 0 0 0 0  
5565 5565 20200619 LA 48515 542394   590909 561       75   37017 B 6/18/2020 13:00 2020-06-18T13:00:00Z 06/18 09:00 3084   2020-06-18T13:00:00Z       48515 2972 112   590909                     22 -119 45807 590909 posNeg 45688 590909 22 0 f731ad899a947303dff3fa85679ce930611be0c6 0 0 0 0 0  
3899 3899 20200719 NJ 176783 1614354   1791137 766 21064 149   65   31405 A+ 7/19/2020 13:00 2020-07-19T13:00:00Z 07/19 09:00 15509 21064 2020-07-19T13:00:00Z 1791137     176783 13732 1777                         34 -31 9718 1791137 posNeg 9687 1791137 8 0 0319151913537f6e0621e4591833c961cc0245e9 0 0 0 0 0  
3538 3538 20200725 DE 14175 152747   166922 55   11       7961 A+ 7/24/2020 18:00 2020-07-24T18:00:00Z 07/24 14:00 579   2020-07-24T18:00:00Z       13179 509 70   166922                     10 -27 2623 166922 posNeg 2596 166922 1 0 5e14eceb2cf7ff36908b548bc0ea8fb3d4aa77e0 0 0 0 0 0  
6840 6840 20200527 CT 41288 187581   228869 684 12538         7127 B 5/25/2020 20:30 2020-05-25T20:30:00Z 05/25 16:30 3803 12538 2020-05-25T20:30:00Z 235525                                   9 -15 3522 228869 posNeg 3507 228869 34 0 5162e634bff6c643ba9a8cab522d7cacc5531746 0 0 0 0 0  
2192 2192 20200818 CT 51255 941476   992731 47 11015         8809 B 8/17/2020 20:30 2020-08-17T20:30:00Z 08/17 16:30 4456 11015 2020-08-17T20:30:00Z 990712     49236 3571 885                         9 -12 10775 992731 posNeg 10763 992731 0 0 b423852a101e885ec1dfa6e920a26543fbfcd638 0 0 0 0 0  
1690 1690 20200827 DE 16976 211083   228059 57   15       9101 A+ 8/26/2020 18:00 2020-08-26T18:00:00Z 08/26 14:00 604   2020-08-26T18:00:00Z       15987 533 71   228059                     10 -10 974 228059 posNeg 964 228059 0 0 43517c0d7f1e224e258cf37baead46d8383b6bf3 0 0 0 0 0  
2688 2688 20200810 WY 3042 54640   57682 15 179         2483 B 8/10/2020 17:39 2020-08-10T17:39:00Z 08/10 13:39 28 179 2020-08-10T17:39:00Z 82445 2638 79806 2565       57205                     56 -8 1015 57682 posNeg 1007 57682 0 2 499624fd3d426776486b5f011deb93465887a4d3 0 0 0 0 0  
1522 1522 20200830 DE 17343 217318   234661 55   16       9318 A+ 8/29/2020 18:00 2020-08-29T18:00:00Z 08/29 14:00 604   2020-08-29T18:00:00Z       16346 533 71   234661                     10 -6 1783 234661 posNeg 1777 234661 0 0 7ec97974cb146bf25935ace4412710bb5c4e6d09 0 0 0 0 0  
7070 7070 20200523 HI 642 48179   48821   84         585 C 5/22/2020 18:00 2020-05-22T18:00:00Z 05/22 14:00 17 84 2020-05-22T18:00:00Z 48821                                   15 -5 841 48821 posNeg 836 48821 0 1 08bf679383709f862912db1d208e170341c7dca3 0 0 0 0 0  
5708 5708 20200617 VT 1130 52533   53663 5           915 B 6/17/2020 00:00 2020-06-17T00:00:00Z 06/16 20:00 55   2020-06-17T00:00:00Z       1130 55     53663                     50 -1 774 53663 posNeg 773 53663 0 0 dac02ccfde086d7fabbb31369806779db2111f69 0 0 0 0 0  
6302 6302 20200606 MT 540 46214   46754 1 68         472 C 6/6/2020 00:00 2020-06-06T00:00:00Z 06/05 20:00 18 68 2020-06-06T00:00:00Z 46754     540                             30 -1 867 46754 posNeg 866 46754 0 0 0150e453b62ee3404f8c4c50a1ae7875278e363e 0 0 0 0 0  
7518 7518 20200515 HI 637 38139   38776   81         564 B 5/14/2020 18:00 2020-05-14T18:00:00Z 05/14 14:00 17 81 2020-05-14T18:00:00Z               39767                     15 -1 -104 38776 posNeg -105 38776 0 0 f6d3fba5d67d3df82afcf4cee396637a41d194ac 0 0 0 0 0  
8094 8094 20200505 MT 456 14816   15272 6 62         410 C 5/5/2020 00:00 2020-05-05T00:00:00Z 05/04 20:00 16 62 2020-05-05T00:00:00Z 15272     456                             30 -1 185 15272 posNeg 184 15272 0 0 00191fe89111325e1b1fc8356a3d332f465c1296 0 0 0 0 0  
8133 8133 20200504 GU 149 3242   3391             125 F 5/4/2020 07:40 2020-05-04T07:40:00Z 05/04 03:40 5   2020-05-04T07:40:00Z       145                             66 -1 90 3391 posNeg 89 3391 0 0 15b44e6e2312b6d3e103e40fd055c22a1c930fbb 0 0 0 0 0  
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  
8 8 20200926 CT 56587 1462564   1519151 76 11560         9310 B 9/24/2020 20:30 2020-09-24T20:30:00Z 09/24 16:30 4501 11560 2020-09-24T20:30:00Z 1516780     54216 3604 897                         9 0 0 1519151 posNeg 0 1519151 0 0 597a6f3bd03d5e8297830e769c3da2cb90e767e7 0 0 0 0 0  
19 19 20200926 KS 56592 446178   502770 343 2816 121 768 34 250 2039 A+ 9/25/2020 10:00 2020-09-25T10:00:00Z 09/25 06:00 632 2816 2020-09-25T10:00:00Z               502770                     20 0 0 502770 posNeg 0 502770 0 0 1468f023cf5cebe6e0d2f0752a5b054eecc06b87 0 0 0 0 0  
21 21 20200926 LA 165152 2090913   2256065 570       86   149640 A 9/25/2020 13:00 2020-09-25T13:00:00Z 09/25 09:00 5444   2020-09-25T13:00:00Z       163928 5262 182   2254841                     22 0 0 2256065 posNeg 0 2256065 0 0 bda77e8fe6fd07aa1abd19dfbcfc5e00573b8f1f 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  
44 44 20200926 RI 24181 305853   727469 94 2725 8   4   2278 A+ 9/25/2020 12:00 2020-09-25T12:00:00Z 09/25 08:00 1107 2725 2020-09-25T12:00:00Z   34299 693170 24181     727469 330034                     44 0 0 330034 totalTestEncountersViral 0 330034 0 0 e5a147d241db0ad3830218c1038dc29b79d42bcc 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  
90 90 20200925 NH 8044 239107   417689 16 732   233     7325 B 9/24/2020 09:00 2020-09-24T09:00:00Z 09/24 05:00 438 732 2020-09-24T09:00:00Z 417689     8044       247151 31620     30901             33 0 0 247151 posNeg 0 247151 0 0 3398fdda4d143fbae8189756e15b28d4a0ef5aae 0 0 0 0 0  
113 113 20200924 AK 7941 425257   433198 43       14   2731 A 9/23/2020 03:59 2020-09-23T03:59:00Z 09/22 23:59 45   2020-09-23T03:59:00Z 433198 7180 425736 7941 45                           2 0 0 433198 posNeg 0 433198 0 0 b83363bdfb4b0d19318d00489c44e906270412f1 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  
131 131 20200924 KS 55226 437055   492281 313 2766 93 753 27 240 2008 A+ 9/23/2020 10:00 2020-09-23T10:00:00Z 09/23 06:00 621 2766 2020-09-23T10:00:00Z               492281                     20 0 0 492281 posNeg 0 492281 0 0 d7488a6af979bbb0b91f27f95ecee42279eafe8d 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  
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  
221 221 20200923 WA 83193 1657706   1740899 277 7314     32     B 9/22/2020 02:59 2020-09-22T02:59:00Z 09/21 22:59 2070 7314 2020-09-22T02:59:00Z       83193 2070   1740899                       53 0 0 1740899 posNeg 0 1740899 0 0 7970bca4445cb328bfd49535798ea65bac25b905 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  
243 243 20200922 KS 53959 430732   484691 216 2706 60 741 23 230 1970 A+ 9/21/2020 10:00 2020-09-21T10:00:00Z 09/21 06:00 600 2706 2020-09-21T10:00:00Z               484691                     20 0 0 484691 posNeg 0 484691 0 0 1cb8188417c637e2d2fb55352f83395bab168be2 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  
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  
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  
344 344 20200920 CT 55527 1366621   1422148 77 11447         9204 B 9/17/2020 20:30 2020-09-17T20:30:00Z 09/17 16:30 4492 11447 2020-09-17T20:30:00Z 1419839     53218 3597 895                         9 0 0 1422148 posNeg 0 1422148 0 0 c23b8f09fd8aeea712d8e464d7f2456f8097e929 0 0 0 0 0  
349 349 20200920 GU 2117 43841   45958 36   19       1450 A 9/19/2020 04:15 2020-09-19T04:15:00Z 09/19 00:15 34   2020-09-19T04:15:00Z 45651     2117       45958 172 3                 66 0 0 45958 posNeg 0 45958 0 0 3bfc034531cffc78d480c081bb28d9a8b2c7b492 0 0 0 0 0  
355 355 20200920 KS 52285 422464   474749 286 2671 79 734 23 230 1950 A+ 9/18/2020 10:00 2020-09-18T10:00:00Z 09/18 06:00 596 2671 2020-09-18T10:00:00Z               474749                     20 0 0 474749 posNeg 0 474749 0 0 c3b90f2255d2333d62ea9e0b7046c08b7748c885 0 0 0 0 0  
361 361 20200920 MI 128087 3190382   3318469 557   150   64   90216 A+ 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 6969   2020-09-19T00:00:00Z 3353686 163304 3190382 115870 6653 316     283882                   26 0 0 3318469 posNeg 0 3318469 0 0 696c50a64c4e55f0a730a5edf8659e1159f2ed4a 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  
400 400 20200919 CT 55527 1366621   1422148 77 11447         9204 B 9/17/2020 20:30 2020-09-17T20:30:00Z 09/17 16:30 4492 11447 2020-09-17T20:30:00Z 1419839     53218 3597 895                         9 0 0 1422148 posNeg 0 1422148 0 0 37f86cb35187ab8b462bed2e12880222ce795933 0 0 0 0 0  
411 411 20200919 KS 52285 422464   474749 286 2671 79 734 23 230 1950 A+ 9/18/2020 10:00 2020-09-18T10:00:00Z 09/18 06:00 596 2671 2020-09-18T10:00:00Z               474749                     20 0 0 474749 posNeg 0 474749 0 0 fbece70742f3b6402b0b82185e763bf4c9ad12e3 0 0 0 0 0  
413 413 20200919 LA 161322 1985664   2146986 647       104   145570 A 9/18/2020 13:00 2020-09-18T13:00:00Z 09/18 09:00 5340   2020-09-18T13:00:00Z       160283 5172 168   2145947                     22 0 0 2146986 posNeg 0 2146986 0 0 391142daaa1979e017147041a56a46a716e7789a 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  
445 445 20200919 WA 81602 1623068   1704670 248 7215     34     B 9/18/2020 02:59 2020-09-18T02:59:00Z 09/17 22:59 2037 7215 2020-09-18T02:59:00Z       81602 2037   1704670                       53 0 0 1704670 posNeg 0 1704670 0 0 09a5a1ca1ac431f57b4278c1cce4978ed0610be0 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  
477 477 20200918 MS 91935 541497   633432 630 5499 171   87   78971 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 2780 5499 2020-09-17T00:00:00Z 626881     85944 2572 208     29016 95             40904   28 0 0 633432 posNeg 0 633432 0 0 ad1225256fe52935c13c6f76ac4beafd2c39d99f 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  
523 523 20200917 KS 50870 413356   464226 278 2616 83 713 21 225 1920 A+ 9/16/2020 10:00 2020-09-16T10:00:00Z 09/16 06:00 586 2616 2020-09-16T10:00:00Z               464226                     20 0 0 464226 posNeg 0 464226 0 0 9774767ad4c7b3cc6016f5b12265f2a8c7df86a6 0 0 0 0 0  
545 545 20200917 OR 29850 595574   625424 144 2341 32   11   5376 A+ 9/17/2020 15:01 2020-09-17T15:01:00Z 09/17 11:01 521 2341 2020-09-17T15:01:00Z     595574 28590       624164                     41 0 4151 625424 posNeg 4151 625424 0 22 b02bf38aff4a26d83319f1278dc5c29b8b17fded 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  
612 612 20200916 VT 1702 150362   152064 6           1530 B 9/15/2020 23:59 2020-09-15T23:59:00Z 09/15 19:59 58   2020-09-15T23:59:00Z       1702 58     152064                     50 0 472 152064 posNeg 472 152064 0 0 34dada47f9c2d9f8389703f9ed9c28d276e01a6f 0 0 0 0 0  
620 620 20200915 AS 0 1571   1571               C 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 2b445be74daf156f41869a55052b390e3d37ee0e 0 0 0 0 0  
635 635 20200915 KS 49899 408482   458381 192 2572 50 703 15 221 1887 A+ 9/14/2020 10:00 2020-09-14T10:00:00Z 09/14 06:00 534 2572 2020-09-14T10:00:00Z               458381                     20 0 0 458381 posNeg 0 458381 0 0 f2f2ff46eba821dc5c314d7e7dbf7ae2764b34b7 0 0 0 0 0  
644 644 20200915 MP 61 14316   14377   4         29 C 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 9387a4a66c395a13d58ed5029432aec261f9a217 0 0 0 0 0  
676 676 20200914 AS 0 1571   1571               C 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 174cf78dc9ab5615d074020dde4ce99fcd28e6de 0 0 0 0 0  
732 732 20200913 AS 0 1571   1571               C 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 3ae357e9638017e50197c3bf2bd193a2569941a7 0 0 0 0 0  
736 736 20200913 CT 54326 1276658   1330984 51 11357         9142 B 9/10/2020 20:30 2020-09-10T20:30:00Z 09/10 16:30 4480 11357 2020-09-10T20:30:00Z 1328753     52095 3595 885                         9 0 0 1330984 posNeg 0 1330984 0 0 ed78ceded1a937ba41234faf6058ae23f55cec18 0 0 0 0 0  
741 741 20200913 GU 1891 41472   43363 50   11       1118 A+ 9/13/2020 03:15 2020-09-13T03:15:00Z 09/12 23:15 26   2020-09-13T03:15:00Z 43011     1891       43363 158 2                 66 0 0 43363 posNeg 0 43363 1 0 b717b6ffe69ebec8ceb54b7ea86a115fe81c77bb 0 0 0 0 0  
747 747 20200913 KS 48386 400544   448930 140 2537 40 690 10 219 1859 A+ 9/11/2020 10:00 2020-09-11T10:00:00Z 09/11 06:00 511 2537 2020-09-11T10:00:00Z               448930                     20 0 0 448930 posNeg 0 448930 0 0 5562750d6f8e4885550c4cbf5520fabab6edfefb 0 0 0 0 0  
753 753 20200913 MI 123058 2987552   3110610 627   172   77   85513 A+ 9/12/2020 00:00 2020-09-12T00:00:00Z 09/11 20:00 6911   2020-09-12T00:00:00Z 3144491 156939 2987552 111524 6591 320     268368                   26 0 0 3110610 posNeg 0 3110610 0 0 3b119610e6f62cfa044bd7fb4a7021a53161d0ba 0 0 0 0 0  
756 756 20200913 MP 60 14316   14376   4         29 C 9/12/2020 00:00 2020-09-12T00:00:00Z 09/11 20:00 2 4 2020-09-12T00:00:00Z 18915     60 2     14375                     69 0 0 14376 posNeg 0 14376 0 0 6d0fd1b1a822d1b152febe3364cbc69c22ca324e 0 0 0 0 0  
788 788 20200912 AS 0 1571   1571               C 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 ca96fa86c9a0c4210a96c86ab92800701dce88ad 0 0 0 0 0  
792 792 20200912 CT 54326 1276658   1330984 51 11357         9142 B 9/10/2020 20:30 2020-09-10T20:30:00Z 09/10 16:30 4480 11357 2020-09-10T20:30:00Z 1328753     52095 3595 885                         9 0 0 1330984 posNeg 0 1330984 0 0 5d1caef4558d54c252bb89a98ec83c654656b62e 0 0 0 0 0  
803 803 20200912 KS 48386 400544   448930 140 2537 40 690 10 219 1859 A+ 9/11/2020 10:00 2020-09-11T10:00:00Z 09/11 06:00 511 2537 2020-09-11T10:00:00Z               448930                     20 0 0 448930 posNeg 0 448930 0 0 35d7ce6cf7bf9d30d0feb2960da36d3140ea08ae 0 0 0 0 0  
805 805 20200912 LA 157109 1880644   2037753 723       117   140440 A 9/11/2020 13:00 2020-09-11T13:00:00Z 09/11 09:00 5202   2020-09-11T13:00:00Z       156174 5032 170   2036818                     22 0 0 2037753 posNeg 0 2037753 0 0 3add26a8e3d061aad50f1595e2ed87b3bb0def9a 0 0 0 0 0  
844 844 20200911 AS 0 1571   1571               C 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 af92759401b47f8c1b3777fde5b06c65b773a25a 0 0 0 0 0  
850 850 20200911 DE 18466 238232   256698 66   14       10027 A+ 9/10/2020 18:00 2020-09-10T18:00:00Z 09/10 14:00 613   2020-09-10T18:00:00Z       17475 541 72   256698                     10 0 0 256698 posNeg 0 256698 0 0 d5f5554fc831c6f3f948b05bc60214ff1b65d4ea 0 0 0 0 0  
868 868 20200911 MP 59 14316   14375   4         29 C 9/8/2020 00:00 2020-09-08T00:00:00Z 09/07 20:00 2 4 2020-09-08T00:00:00Z 18915     59 2     14375                     69 0 0 14375 posNeg 0 14375 0 0 2fe4a94252b2d399ea4beedaf2fefdf86e6e16e3 0 0 0 0 0  
900 900 20200910 AS 0 1571   1571               C 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 aafe07069b99c5cb6e3a433727b4d1233cba2abd 0 0 0 0 0  
915 915 20200910 KS 47410 394004   441414 319 2470 92 677 41 218 1817 A+ 9/9/2020 10:00 2020-09-09T10:00:00Z 09/09 06:00 495 2470 2020-09-09T10:00:00Z               441414                     20 0 0 441414 posNeg 0 441414 0 0 a91beae2007bee85ad1070f7515aad4b5f8a4431 0 0 0 0 0  
924 924 20200910 MP 59 14316   14375   4         29 C 9/8/2020 00:00 2020-09-08T00:00:00Z 09/07 20:00 2 4 2020-09-08T00:00:00Z 18915     59 2     14375                     69 0 832 14375 posNeg 832 14375 0 0 4badedf4735de175ab23851ff1f842d78f08abc3 0 0 0 0 0  
956 956 20200909 AS 0 1571   1571               C 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 b568d4827408ce320e19f678e9d3d4da52b89bf1 0 0 0 0 0  
962 962 20200909 DE 18308 235662   253970 53   12       9920 A+ 9/7/2020 18:00 2020-09-07T18:00:00Z 09/07 14:00 609   2020-09-07T18:00:00Z       17317 537 72   253970                     10 0 0 253970 posNeg 0 253970 0 0 6efd148cf24ef6a330d3d56b42db563c8d67f356 0 0 0 0 0  
980 980 20200909 MP 59 13484   13543   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     59 2     13540                     69 0 0 13543 posNeg 0 13543 0 0 03d6e521defdae0ad99269ea3876502901160d28 0 0 0 0 0  
986 986 20200909 NH 7494 215469   356180 7 718   227     6825 B 9/8/2020 09:00 2020-09-08T09:00:00Z 09/08 05:00 433 718 2020-09-08T09:00:00Z 356180     7494       222963 30824     30164             33 0 0 222963 posNeg 0 222963 0 0 c5edef6898ba86a8bebb3fcee895efb40b41e262 0 0 0 0 0  
1003 1003 20200909 VI 1191 16253 15 17444             1070 C 9/8/2020 06:03 2020-09-08T06:03:00Z 09/08 02:03 18   2020-09-08T06:03:00Z 17459       18                           78 0 0 17459 posNeg 0 17444 0 0 de5c19a159a708163d9148528f39a5a97d9e79fa 0 0 0 0 0  
1012 1012 20200908 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 57 1571 posNeg 57 1571 0 0 8b4aa9d198cf888bb19a9c536401d3ee1ff86512 0 0 0 0 0  
1027 1027 20200908 KS 46914 389772   436686 177 2441 51 669 25 214 1796 A+ 9/7/2020 10:00 2020-09-07T10:00:00Z 09/07 06:00 485 2441 2020-09-07T10:00:00Z               436686                     20 0 0 436686 posNeg 0 436686 0 0 15cc8c4ad5d63cb73df8254edf90fb3734938d45 0 0 0 0 0  
1061 1061 20200908 WA 77235 1485818   1563053 277 6860     37     B 9/6/2020 02:59 2020-09-06T02:59:00Z 09/05 22:59 1953 6860 2020-09-06T02:59:00Z       77235 1953   1563053                       53 0 0 1563053 posNeg 0 1563053 0 0 6ba255671b79e34e2ea3be606ee6fc0cedb4c0d3 0 0 0 0 0  
1068 1068 20200907 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 5085675dfa58821863ab561c420b108feb82868d 0 0 0 0 0  
1072 1072 20200907 CT 53365 1184293   1237658 58 11275         9049 B 9/4/2020 20:30 2020-09-04T20:30:00Z 09/04 16:30 4468 11275 2020-09-04T20:30:00Z 1235514     51221 3583 885                         9 0 0 1237658 posNeg 0 1237658 0 0 4adf6d49af72c25ef07427f7c4e31b0a6e3f475a 0 0 0 0 0  
1077 1077 20200907 GU 1671 39070   40741 57   14       744 A+ 9/6/2020 22:45 2020-09-06T22:45:00Z 09/06 18:45 18   2020-09-06T22:45:00Z 40110     1671       40741 158 2                 66 0 0 40741 posNeg 0 40741 2 0 9f5c3096cd3265488258532a041898e473f67b1c 0 0 0 0 0  
1092 1092 20200907 MP 58 13484   13542   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     58 2     13540                     69 0 0 13542 posNeg 0 13542 0 0 775d656966bf522797679c0f5ef1cd8d8ae1faa5 0 0 0 0 0  
1120 1120 20200907 WY 4032 74312   78344 15 219         3416 A 9/6/2020 11:25 2020-09-06T11:25:00Z 09/06 07:25 42 219 2020-09-06T11:25:00Z 111391 3230 108160 3425       77685                     56 0 0 78344 posNeg 0 78344 0 0 04a792543a58c1cc36bba4564882ef188bb61190 0 0 0 0 0  
1123 1123 20200906 AR 65226 700721   765411 389 4462     78 568 58295 A 9/6/2020 17:30 2020-09-06T17:30:00Z 09/06 13:30 894 4462 2020-09-06T17:30:00Z 765411   700721 64690                         14859 2311 5 0 0 765947 posNeg 0 765947 12 6 d065f2bed86d6d38f3759cebc256396577446cb6 0 0 0 0 0  
1124 1124 20200906 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 8e9a58f72785fb83c490d6b168f1467bd6c2e8f8 0 0 0 0 0  
1128 1128 20200906 CT 53365 1184293   1237658 58 11275         9049 B 9/3/2020 20:30 2020-09-03T20:30:00Z 09/03 16:30 4468 11275 2020-09-03T20:30:00Z 1235514     51221 3583 885                         9 0 0 1237658 posNeg 0 1237658 0 0 136e22546af269f199486eb79c977a2c2ca41531 0 0 0 0 0  
1133 1133 20200906 GU 1671 39070   40741 57   14       744 A+ 9/5/2020 12:50 2020-09-05T12:50:00Z 09/05 08:50 16   2020-09-05T12:50:00Z 40110     1671       40741 158 2                 66 0 0 40741 posNeg 0 40741 1 0 286857542ef6a71bcbd6baef1e647fca426d8600 0 0 0 0 0  
1139 1139 20200906 KS 45220 381985   427205 314 2415 101 661 36 211 1785 A+ 9/4/2020 10:00 2020-09-04T10:00:00Z 09/04 06:00 481 2415 2020-09-04T10:00:00Z               427205                     20 0 0 427205 posNeg 0 427205 0 0 ae08ff8f436cb20b22353384be116a7c3def7f95 0 0 0 0 0  
1145 1145 20200906 MI 117191 2801811   2919002 616   158   71   80678 A+ 9/5/2020 00:00 2020-09-05T00:00:00Z 09/04 20:00 6806   2020-09-05T00:00:00Z 2951815 150004 2801811 106215 6534 272     263721                   26 0 0 2919002 posNeg 0 2919002 0 0 f1437d5a6117d5b7364470917e6d6b5310f319fe 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
);