states_daily_4pm_et

Table actions

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

11,578 rows sorted by hospitalized

✎ View and edit SQL

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
1 1 20200926 AK 8315 434554   442869 43       14   3267 A 9/26/2020 03:59 2020-09-26T03:59:00Z 09/25 23:59 52   2020-09-26T03:59:00Z 442869 7411 435171 8315 52                           2 113 1424 442869 posNeg 1537 442869 1 0 bf7518dcc571d23d1d8206a95e1a1c12173bcb0a 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  
6 6 20200926 CA 798237 13384493   14182730 3203   862         B 9/26/2020 02:59 2020-09-26T02:59:00Z 09/25 22:59 15532   2020-09-26T02:59:00Z 14182730     798237                             6 4197 126286 14182730 posNeg 130483 14182730 134 0 bc22d39302ce5646a61aef19adbfa503f5de5e76 0 0 0 0 0  
9 9 20200926 DC 15215 362764   377979 101   25   17   12029 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 624   2020-09-25T00:00:00Z             377979 211599                     11 52 4341 377979 posNeg 4393 377979 1 0 5dd3065a746eea8ae0e9a70d3218cd0129db3054 0 0 0 0 0  
10 10 20200926 DE 20156 260243   280399 57   10       10541 A+ 9/25/2020 18:00 2020-09-25T18:00:00Z 09/25 14:00 633   2020-09-25T18:00:00Z       19103 556 77   280399                     10 71 954 280399 posNeg 1025 280399 2 0 e3e0fc4116a2a29665fe6bffd51a89a13780977a 0 0 0 0 0  
13 13 20200926 GU 2354 46365   48719 30   9       1668 A 9/26/2020 09:45 2020-09-26T09:45:00Z 09/26 05:45 43   2020-09-26T09:45:00Z 48254     2354       48719 179 3                 66 68 395 48719 posNeg 463 48719 2 0 7185eba890dd8a1d9ad81f1a7efd70101c32b967 0 0 0 0 0  
15 15 20200926 IA 82944 667954   750898 334   84   29   65490 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 1311   2020-09-26T00:00:00Z       82944       752449       57997 3389 54568 20350 2645     19 899 5018 750898 posNeg 5917 750898 4 0 47decf503735f781b057e655041ca39b2b4fb714 0 0 0 0 0  
17 17 20200926 IL 288815 5142362   5431177 1597   355   141     A 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 8832   2020-09-26T00:00:00Z 5428688     286326 8588 244                         17 2441 62776 5431177 posNeg 65217 5431177 25 0 2620e4472a6793bd94436e1e6a2f1efbe8f39315 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  
25 25 20200926 MI 134373 3408684   3543057 558   139   52   95051 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 7044   2020-09-26T00:00:00Z 3578584 169900 3408684 121427 6723 321     291180                   26 996 39749 3543057 posNeg 40745 3543057 17 0 2e49e36255f6a6daef66f967af21b911b45c97ad 0 0 0 0 0  
27 27 20200926 MO 122014 1167155   1289169 1101             B 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 2063   2020-09-26T00:00:00Z 1687509 128009 1556710 122014       1289169       74093 3508 70585         29 1716 14288 1289169 posNeg 16004 1289169 69 0 de543358a328e51d3abdbaecc32041460021841e 0 0 0 0 0  
31 31 20200926 NC 206090 2741713   2947803 914   272       176422 A+ 9/26/2020 12:00 2020-09-26T12:00:00Z 09/26 08:00 3440   2020-09-26T12:00:00Z 2943144     201431 3440                           37 1759 38427 2947803 posNeg 40186 2947803 31 0 20a1b19461a3df0fea54c6dfb6ffc967453a835b 0 0 0 0 0  
37 37 20200926 NV 78355 607323   685678 442   125   64   2075 A+ 9/26/2020 02:59 2020-09-26T02:59:00Z 09/25 22:59 1582   2020-09-26T02:59:00Z 1026486     78355       684796                     32 602 3740 685678 posNeg 4342 685678 9 0 6562d5250f6a1ba7ad8affc64c3a68a2b09dd5cd 0 0 0 0 0  
42 42 20200926 PA 155232 1830292   1985524 444       60   127290 A+ 9/26/2020 12:00 2020-09-26T12:00:00Z 09/26 08:00 8103   2020-09-26T12:00:00Z 2898629     150393       1980685                     42 1029 13895 1985524 posNeg 14924 1985524 22 0 95db3b8c62ccc9249c12e799648a8351f5b7337f 0 0 0 0 0  
43 43 20200926 PR 45413 305972   351385 342   59   33     C 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 642   2020-09-26T00:00:00Z 310546 7002 303412 22164 471 171       23249                 72 508 0 351385 posNeg 508 351385 7 0 347836cd67621b97708a39d1a47689f42650b1b1 0 0 0 0 0  
48 48 20200926 TX 733438 5261375   5994813 3209   1056       649580 A 9/26/2020 16:20 2020-09-26T16:20:00Z 09/26 12:20 15485   2020-09-26T16:20:00Z 5994813     733438         399337 35847             80294 9297 48 4886 76478 5994813 posNeg 81364 5994813 121 0 118422653c167fc9d3ed0bd4ad4d2a32d4f6a49a 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  
52 52 20200926 VT 1739 158537   160276 1           1580 B 9/25/2020 23:59 2020-09-25T23:59:00Z 09/25 19:59 58   2020-09-25T23:59:00Z       1739 58     160276                     50 8 989 160276 posNeg 997 160276 0 0 21dc4138bae65a1c22e9f7756f9fd545cb820bea 0 0 0 0 0  
55 55 20200926 WV 15158 527133   542291 174   56   31   11121 C 9/25/2020 23:59 2020-09-25T23:59:00Z 09/25 19:59 332   2020-09-25T23:59:00Z 541883     14750 329 3     17205                   54 205 6692 542291 posNeg 6897 542291 2 0 a4823873f7e477ab8b531c7edd4b61423f7dbfdb 0 0 0 0 0  
57 57 20200925 AK 8202 433130   441332 43       14   3042 A 9/25/2020 03:59 2020-09-25T03:59:00Z 09/24 23:59 51   2020-09-25T03:59:00Z 441332 7357 433688 8202 51                           2 261 7873 441332 posNeg 8134 441332 6 0 0271fcc794329b2dd035402cb74aad56124c446b 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  
62 62 20200925 CA 794040 13258207   14052247 3307   899         B 9/24/2020 02:59 2020-09-24T02:59:00Z 09/23 22:59 15398   2020-09-24T02:59:00Z 14052247     794040                             6 3400 95990 14052247 posNeg 99390 14052247 84 0 dc1ad4cec70e3f611d3c3453330d057af15b2802 0 0 0 0 0  
65 65 20200925 DC 15163 358423   373586 101   29   17   11990 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 623   2020-09-24T00:00:00Z             373586 210143                     11 57 5662 373586 posNeg 5719 373586 2 0 fa43d123c3d8a81e9ca093ade7dd2b5bd84f2e46 0 0 0 0 0  
66 66 20200925 DE 20085 259289   279374 53   11       10517 A+ 9/24/2020 18:00 2020-09-24T18:00:00Z 09/24 14:00 631   2020-09-24T18:00:00Z       19044 554 77   279374                     10 138 1320 279374 posNeg 1458 279374 1 0 0cb6cfa23b27978fc86ee02a2be8fc6824f50d2e 0 0 0 0 0  
69 69 20200925 GU 2286 45970   48256 31   11       1668 A 9/25/2020 08:00 2020-09-25T08:00:00Z 09/25 04:00 41   2020-09-25T08:00:00Z 48254     2286       48256 179 3                 66 23 546 48256 posNeg 569 48256 3 0 fb3e86409c30ee1985da66f84ce87e1407f9609a 0 0 0 0 0  
71 71 20200925 IA 82045 662936   744981 330   87   35   62648 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 1307   2020-09-25T00:00:00Z       82045       746536       57499 3371 54088 20262 2640     19 974 5427 744981 posNeg 6401 744981 5 0 8b946f1a4d28145fbe7ed6ca8f9fb3b2a6cced4b 0 0 0 0 0  
73 73 20200925 IL 286374 5079586   5365960 1637   371   124     A 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 8807   2020-09-25T00:00:00Z 5363471     283885 8563 244                         17 2805 67279 5365960 posNeg 70084 5365960 33 0 eba0b8805427a5e5e03fefdff222976f3e0158c6 0 0 0 0 0  
77 77 20200925 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 706 17825 2256065 posNeg 18531 2256065 21 0 25e0ee29f19c5ee29b7147d637fdc6eabccbdd0d 0 0 0 0 0  
81 81 20200925 MI 133377 3368935   3502312 558   139   52   90216 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 7027   2020-09-25T00:00:00Z 3537643 168708 3368935 120526 6708 319     289151                   26 1040 38448 3502312 posNeg 39488 3502312 8 0 333b2ebfc64062c1d0e9d85ebbecd16c3e675e30 0 0 0 0 0  
83 83 20200925 MO 120298 1152867   1273165 1068             B 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 1994   2020-09-25T00:00:00Z 1667432 126185 1538424 120298       1273165       73815 3475 70340         29 1987 11647 1273165 posNeg 13634 1273165 42 0 5fb1f13385562456e41e7823d1cd75d9e7aff0bc 0 0 0 0 0  
87 87 20200925 NC 204331 2703286   2907617 903   281       176422 A+ 9/25/2020 13:30 2020-09-25T13:30:00Z 09/25 09:30 3409   2020-09-25T13:30:00Z 2903054     199768 3409                           37 6142 31284 2907617 posNeg 37426 2907617 53 0 3a1c36e50f5f0ae3074fb005c8a70ae070ce51ed 0 0 0 0 0  
93 93 20200925 NV 77753 603583   681336 460   130   62   2075 A+ 9/25/2020 02:59 2020-09-25T02:59:00Z 09/24 22:59 1573   2020-09-25T02:59:00Z 1017333     77753       680480                     32 556 5292 681336 posNeg 5848 681336 9 0 62f7a3e3f028dadfbe75a49f66bd4eff913333aa 0 0 0 0 0  
98 98 20200925 PA 154203 1816397   1970600 435       58   126446 A+ 9/25/2020 12:00 2020-09-25T12:00:00Z 09/25 08:00 8081   2020-09-25T12:00:00Z 2868166     149410       1965807                     42 806 12927 1970600 posNeg 13733 1970600 2 0 fd570e979c470b48c693b0fc8042e50c95be796a 0 0 0 0 0  
99 99 20200925 PR 44905 305972   350877 376   67   28     C 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 635   2020-09-25T00:00:00Z 310546 7002 303412 21868 464 171       23037                 72 1063 0 350877 posNeg 1063 350877 8 0 bda0efc404ddfa952c518d2389522acfc3623b49 0 0 0 0 0  
104 104 20200925 TX 728552 5184897   5913449 3221   1051       646143 A 9/25/2020 17:20 2020-09-25T17:20:00Z 09/25 13:20 15364   2020-09-25T17:20:00Z 5913449     728552         394584 35656             78472 9190 48 4633 47983 5913449 posNeg 52616 5913449 97 0 fcc328aeaedb26412d3c3b30f120af65e1ed1251 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  
108 108 20200925 VT 1731 157548   159279 2           1576 B 9/24/2020 23:59 2020-09-24T23:59:00Z 09/24 19:59 58   2020-09-24T23:59:00Z       1731 58     159279                     50 7 1083 159279 posNeg 1090 159279 0 0 35ade9c048124510cd07e6d14c9e8b135013a5b5 0 0 0 0 0  
111 111 20200925 WV 14953 520441   535394 177   59   31   10968 C 9/24/2020 23:59 2020-09-24T23:59:00Z 09/24 19:59 330   2020-09-24T23:59:00Z 535018     14577 327 3     17164                   54 247 6122 535394 posNeg 6369 535394 5 0 bba94c76334f9ad4813ce60d939fcf03baefc731 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  
118 118 20200924 CA 790640 13162217   13952857 3484   914         B 9/24/2020 02:59 2020-09-24T02:59:00Z 09/23 22:59 15314   2020-09-24T02:59:00Z 13952857     790640                             6 3170 70264 13952857 posNeg 73434 13952857 110 0 87788642c4d9f1deb4ce4c35adb758e1c0e423f1 0 0 0 0 0  
121 121 20200924 DC 15106 352761   367867 97   29   21   11956 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 621   2020-09-23T00:00:00Z             367867 208447                     11 56 4363 367867 posNeg 4419 367867 0 0 cfa83b179fdc03e18f7806a851999d383d6a1e27 0 0 0 0 0  
122 122 20200924 DE 19947 257969   277916 57   12       10487 A+ 9/23/2020 18:00 2020-09-23T18:00:00Z 09/23 14:00 630   2020-09-23T18:00:00Z       18916 553 77   277916                     10 117 1755 277916 posNeg 1872 277916 1 0 eccf8936aa2afa0f79741776f2ae077e230321be 0 0 0 0 0  
125 125 20200924 GU 2263 45424   47687 33   11       1568 A 9/24/2020 05:55 2020-09-24T05:55:00Z 09/24 01:55 38   2020-09-24T05:55:00Z 47685     2263       47687 179 3                 66 28 408 47687 posNeg 436 47687 1 0 5eb29e4a8462d4ce4ceeebcaedda903fce88c014 0 0 0 0 0  
127 127 20200924 IA 81071 657509   738580 305   79   37   61509 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 1302   2020-09-24T00:00:00Z       81071       740125       57067 3357 53670 19784 2511     19 1148 5579 738580 posNeg 6727 738580 8 0 153ba1e54208eacf18c27936aab903279e5bd037 0 0 0 0 0  
129 129 20200924 IL 283569 5012307   5295876 1713   400   155     A 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 8774   2020-09-24T00:00:00Z 5293678     281371 8538 236                         17 2257 59814 5295876 posNeg 62071 5295876 30 0 76fe84d28caa2298ab73216cc104309da8e32b0d 0 0 0 0 0  
133 133 20200924 LA 164446 2073088   2237534 575       92   149640 A 9/24/2020 13:00 2020-09-24T13:00:00Z 09/24 09:00 5423   2020-09-24T13:00:00Z       163222 5241 182   2236310                     22 577 16948 2237534 posNeg 17525 2237534 16 0 b2014a2fdca7f1221bf7d8612791ab6d4dbbf314 0 0 0 0 0  
137 137 20200924 MI 132337 3330487   3462824 558   139   50   90216 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 7019   2020-09-24T00:00:00Z 3498071 167584 3330487 119597 6700 319     288257                   26 1078 36639 3462824 posNeg 37717 3462824 6 0 bc6e3bf41679912f9b2784c2d9f309da47a99bb4 0 0 0 0 0  
139 139 20200924 MO 118311 1141220   1259531 1056             B 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 1952   2020-09-24T00:00:00Z 1649352 124668 1521891 118311       1259531       73592 3462 70130         29 1365 13603 1259531 posNeg 14968 1259531 5 0 58f4538f1ae9ca884270e304aa3c24304c774a76 0 0 0 0 0  
143 143 20200924 NC 198189 2672002   2870191 902   279       176422 A+ 9/24/2020 11:50 2020-09-24T11:50:00Z 09/24 07:50 3356   2020-09-24T11:50:00Z 2870191     198189 3356                           37 1688 26076 2870191 posNeg 27764 2870191 40 0 bd48aeb2d64854f81b295b3e8c2e220849c5da68 0 0 0 0 0  
149 149 20200924 NV 77197 598291   675488 468   137   67   2062 A+ 9/24/2020 02:59 2020-09-24T02:59:00Z 09/23 22:59 1564   2020-09-24T02:59:00Z 1004215     77197       674482                     32 390 3174 675488 posNeg 3564 675488 8 0 2e52f008a9142237b60a1bfa2d1d8bb66a9879b4 0 0 0 0 0  
154 154 20200924 PA 153397 1803470   1956867 422       53   125785 A+ 9/24/2020 12:30 2020-09-24T12:30:00Z 09/24 08:30 8079   2020-09-24T12:30:00Z 2837537     148658       1952128                     42 853 13058 1956867 posNeg 13911 1956867 17 0 8ccf789695938e13170869897f83ca1be1317115 0 0 0 0 0  
155 155 20200924 PR 43842 305972   349814 364   65   33     C 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 627   2020-09-24T00:00:00Z 310546 7002 303412 21156 456 171       22686                 72 1182 0 349814 posNeg 1182 349814 10 0 3d20930a4ea5673184a533a4882fd441ec7e5d63 0 0 0 0 0  
160 160 20200924 TX 723919 5136914   5860833 3204   1051       642169 A 9/24/2020 18:05 2020-09-24T18:05:00Z 09/24 14:05 15267   2020-09-24T18:05:00Z 5860833     723919         391678 35421             77981 9120 48 4320 115839 5860833 posNeg 120159 5860833 138 0 ef731c1431ebc33082c55af4b13119e8e30dfdea 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  
164 164 20200924 VT 1724 156465   158189 3           1566 B 9/23/2020 23:59 2020-09-23T23:59:00Z 09/23 19:59 58   2020-09-23T23:59:00Z       1724 58     158189                     50 2 924 158189 posNeg 926 158189 0 0 cd8aaac17eae4e4fa4d4c13c289ef9740c7a6860 0 0 0 0 0  
167 167 20200924 WV 14706 514319   529025 173   57   30   10831 C 9/23/2020 23:59 2020-09-23T23:59:00Z 09/23 19:59 325   2020-09-23T23:59:00Z 528658     14339 323 2     17097                   54 202 3243 529025 posNeg 3445 529025 6 0 0d92e7d4a39de0e0558a4a587e700f03926d1e7a 0 0 0 0 0  
169 169 20200923 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 55 1952 433198 posNeg 2007 433198 0 0 77a29837bdfd97f18040622b1984ee7b87e863b8 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  
174 174 20200923 CA 787470 13091953   13879423 3557   905         B 9/23/2020 02:59 2020-09-23T02:59:00Z 09/22 22:59 15204   2020-09-23T02:59:00Z 13879423     787470                             6 3146 72222 13879423 posNeg 75368 13879423 133 0 1463ec67a916e845ebd2cb9dcf143e860239b742 0 0 0 0 0  
177 177 20200923 DC 15050 348398   363448 92   26   17   11929 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 621   2020-09-22T00:00:00Z             363448 206817                     11 29 1786 363448 posNeg 1815 363448 0 0 65567b387778c44895844720fe46362562407b0f 0 0 0 0 0  
178 178 20200923 DE 19830 256214   276044 61   12       10443 A+ 9/22/2020 18:00 2020-09-22T18:00:00Z 09/22 14:00 629   2020-09-22T18:00:00Z       18798 552 77   276044                     10 69 1138 276044 posNeg 1207 276044 1 0 cf27820b82a5ad385c931a4f1e49b1ae5d46c8ca 0 0 0 0 0  
181 181 20200923 GU 2235 45016   47251 33   13       1543 A 9/23/2020 06:45 2020-09-23T06:45:00Z 09/23 02:45 37   2020-09-23T06:45:00Z 47249     2235       47251 175 3                 66 45 378 47251 posNeg 423 47251 0 0 1452355ca652f03a360f08ed2e26e5c6fc7778ab 0 0 0 0 0  
183 183 20200923 IA 79923 651930   731853 301   77   37   60350 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 1294   2020-09-23T00:00:00Z       79923       733400       56600 3345 53215 19021 2434     19 1036 5735 731853 posNeg 6771 731853 8 0 589e06e6feba425c24644cfff19a64e3b3ddc24a 0 0 0 0 0  
185 185 20200923 IL 281312 4952493   5233805 1563   351   144     A 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 8744   2020-09-23T00:00:00Z 5231607     279114 8508 236                         17 1848 44543 5233805 posNeg 46391 5233805 22 0 532c422e30059be3804edb66b4ca90f36dfe007f 0 0 0 0 0  
189 189 20200923 LA 163869 2056140   2220009 592       94   149640 A 9/23/2020 13:00 2020-09-23T13:00:00Z 09/23 09:00 5407   2020-09-23T13:00:00Z       162645 5225 182   2218785                     22 616 12419 2220009 posNeg 13035 2220009 21 0 bd123e4a84ed54452f04ff5dd88a5ec51ba81375 0 0 0 0 0  
193 193 20200923 MI 131259 3293848   3425107 501   146   58   90216 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 7013   2020-09-23T00:00:00Z 3460290 166442 3293848 118615 6692 321     287162                   26 902 33327 3425107 posNeg 34229 3425107 16 0 31f3951f689d05d3416dabd37842d31d1ba026b8 0 0 0 0 0  
195 195 20200923 MO 116946 1127617   1244563 989             B 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 1947   2020-09-23T00:00:00Z 1633863 122803 1508256 116946       1244563       73234 3388 69846         29 1580 1234 1244563 posNeg 2814 1244563 83 0 3fe64a1c1b142ce9ad56681b8a79b81d26bb9f89 0 0 0 0 0  
199 199 20200923 NC 196501 2645926   2842427 912   281       176422 A+ 9/23/2020 12:10 2020-09-23T12:10:00Z 09/23 08:10 3316   2020-09-23T12:10:00Z 2842427     196501 3316                           37 952 16546 2842427 posNeg 17498 2842427 30 0 eab415093f779d66efff5142a1c27684e8b8e044 0 0 0 0 0  
205 205 20200923 NV 76807 595117   671924 479   134   69   2059 A+ 9/23/2020 02:59 2020-09-23T02:59:00Z 09/22 22:59 1556   2020-09-23T02:59:00Z 996307     76807       670908                     32 509 2341 671924 posNeg 2850 671924 10 0 47d7118e5f6b480397adba20fe0cdaeb0d36e6d5 0 0 0 0 0  
210 210 20200923 PA 152544 1790412   1942956 421       54   123560 A+ 9/23/2020 12:00 2020-09-23T12:00:00Z 09/23 08:00 8062   2020-09-23T12:00:00Z 2809305     147862       1938274                     42 898 12496 1942956 posNeg 13394 1942956 39 0 3f5a6abc7bba96c41e5b1bec3d83c98576cc6d95 0 0 0 0 0  
211 211 20200923 PR 42660 305972   348632 376   63   36     C 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 617   2020-09-23T00:00:00Z 310546 7002 303412 20439 447 170       22221                 72 64 0 348632 posNeg 64 348632 4 0 6c1a0e3b87f8748333302c3a12211220b41bee6e 0 0 0 0 0  
216 216 20200923 TX 719599 5021075   5740674 3195   1041       618054 A 9/23/2020 18:15 2020-09-23T18:15:00Z 09/23 14:15 15129   2020-09-23T18:15:00Z 5740674     719599         390538 35217             76275 9003 48 3392 69550 5740674 posNeg 72942 5740674 135 0 b782ae3cef51213c4192af8df10043e5459198fc 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  
220 220 20200923 VT 1722 155541   157263 2           1565 B 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 58   2020-09-22T23:59:00Z       1722 58     157263                     50 1 -79 157263 posNeg -78 157263 0 0 1fa2a67f67ae200bdf335fa8f4ff5f99f677857c 0 0 0 0 0  
223 223 20200923 WV 14504 511076   525580 163   61   31   10721 C 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 319   2020-09-22T23:59:00Z 525236     14160 317 2     17036                   54 120 2791 525580 posNeg 2911 525580 2 0 6914ad52b6f6531fce35b2bfcace63f8b93e3347 0 0 0 0 0  
225 225 20200922 AK 7886 423305   431191 43       14   2668 A 9/22/2020 03:59 2020-09-22T03:59:00Z 09/21 23:59 45   2020-09-22T03:59:00Z 431191 7147 423762 7886 45                           2 48 2498 431191 posNeg 2546 431191 0 0 24135b606b72e9c822c662be4c07b364d622accd 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  
230 230 20200922 CA 784324 13019731   13804055 3520   923         B 9/22/2020 02:59 2020-09-22T02:59:00Z 09/21 22:59 15071   2020-09-22T02:59:00Z 13804055     784324                             6 2630 128643 13804055 posNeg 131273 13804055 53 0 0997db487384449fe22a0cf5bfe0fea7cfe83c58 0 0 0 0 0  
233 233 20200922 DC 15021 346612   361633 95   22   19   11886 A+ 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 621   2020-09-21T00:00:00Z             361633 206165                     11 43 3846 361633 posNeg 3889 361633 0 0 1b8393e382202f7c98f35792436e9a7e0bee0e5c 0 0 0 0 0  
234 234 20200922 DE 19761 255076   274837 62   14       10411 A+ 9/21/2020 18:00 2020-09-21T18:00:00Z 09/21 14:00 628   2020-09-21T18:00:00Z       18733 551 77   274837                     10 94 1530 274837 posNeg 1624 274837 1 0 5adfc831fe103379582c1d7147434ebda54e5eeb 0 0 0 0 0  
237 237 20200922 GU 2190 44638   46828 39   15       1507 A 9/22/2020 05:00 2020-09-22T05:00:00Z 09/22 01:00 37   2020-09-22T05:00:00Z 46826     2190       46828 175 3                 66 43 431 46828 posNeg 474 46828 2 0 523d2166c95d1ed8aa2277f30ce21a4bccd1d7ea 0 0 0 0 0  
239 239 20200922 IA 78887 646195   725082 285   72   34   59216 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 1286   2020-09-22T00:00:00Z       78887       726620       56190 3339 52811 18946 2416     19 548 2939 725082 posNeg 3487 725082 12 0 85b8765176c3738dde4329e336257ca667ee04e9 0 0 0 0 0  
241 241 20200922 IL 279464 4907950   5187414 1455   367   153     A 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 8722   2020-09-22T00:00:00Z 5185216     277266 8486 236                         17 1531 40298 5187414 posNeg 41829 5187414 29 0 b6f9bcb423a5a7b482e8705c7adb5902253e03f2 0 0 0 0 0  
245 245 20200922 LA 163253 2043721   2206974 571       96   145570 A 9/22/2020 13:00 2020-09-22T13:00:00Z 09/22 09:00 5386   2020-09-22T13:00:00Z       162214 5218 168   2205935                     22 752 20430 2206974 posNeg 21182 2206974 11 0 baf9e173a10d54222f081d7fc06de8be1125960e 0 0 0 0 0  
249 249 20200922 MI 130357 3260521   3390878 501   146   56   90216 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 6997   2020-09-22T00:00:00Z 3425958 165437 3260521 117910 6680 317     285455                   26 695 19516 3390878 posNeg 20211 3390878 16 0 d9ea925bffd34bd7ae8bc315c33a56167d99ea05 0 0 0 0 0  
251 251 20200922 MO 115366 1126383   1241749 981             B 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 1864   2020-09-22T00:00:00Z 1628323 122668 1502893 115366       1241749       73015 3368 69647         29 1059 21131 1241749 posNeg 22190 1241749 57 0 0a1cdcf2a179b4f4e291517c73786fa067ed6be9 0 0 0 0 0  
255 255 20200922 NC 195549 2629380   2824929 905   277       176422 A+ 9/22/2020 12:05 2020-09-22T12:05:00Z 09/22 08:05 3286   2020-09-22T12:05:00Z 2824929     195549 3286                           37 1168 6222 2824929 posNeg 7390 2824929 39 0 f4ca81f0e678845338f669e8adc6ea0615b0d98d 0 0 0 0 0  
261 261 20200922 NV 76298 592776   669074 441   140   75   2052 A+ 9/22/2020 02:59 2020-09-22T02:59:00Z 09/21 22:59 1546   2020-09-22T02:59:00Z 991960     76298       668264                     32 262 2020 669074 posNeg 2282 669074 15 0 68eee99de2c89aa2fb5c5d3859ef96b306977c76 0 0 0 0 0  
266 266 20200922 PA 151646 1777916   1929562 429       58   122833 A+ 9/22/2020 12:00 2020-09-22T12:00:00Z 09/22 08:00 8023   2020-09-22T12:00:00Z 2782233     147070       1924986                     42 834 10735 1929562 posNeg 11569 1929562 19 0 4f7d0da29c5892d52a810e5507aa86ca4689e92b 0 0 0 0 0  
267 267 20200922 PR 42596 305972   348568 369   63   42     C 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 613   2020-09-22T00:00:00Z 310546 7002 303412 20399 443 170       22197                 72 120 0 348568 posNeg 120 348568 4 0 f088e68408cd71bc8d9be1e2e896a99cca04ca73 0 0 0 0 0  
272 272 20200922 TX 716207 4951525   5667732 3207   1065       613896 A 9/22/2020 17:40 2020-09-22T17:40:00Z 09/22 13:40 14994   2020-09-22T17:40:00Z 5667732     716207         389207 35026             71209 8712 48 17820 27414 5667732 posNeg 45234 5667732 77 0 ec32538028149c4d87f0cba67742d94fbd369fb5 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  
276 276 20200922 VT 1721 155620   157341 1           1557 B 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 58   2020-09-21T23:59:00Z       1721 58     157341                     50 2 600 157341 posNeg 602 157341 0 0 e9fac8ed601d3958f6472d13994781286dc67a5b 0 0 0 0 0  
279 279 20200922 WV 14384 508285   522669 164   58   28   10524 C 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 317   2020-09-21T23:59:00Z 522329     14044 315 2     17008                   54 213 2940 522669 posNeg 3153 522669 5 0 4e81cd95c248b3dfe12b7a6b4d147e1ae1a6ad00 0 0 0 0 0  
281 281 20200921 AK 7838 420807   428645 47       13   2439 A 9/21/2020 03:59 2020-09-21T03:59:00Z 09/20 23:59 45   2020-09-21T03:59:00Z 428645 7089 421275 7838 45                           2 71 1649 428645 posNeg 1720 428645 0 0 2ec1459d557a0a9f8c65f1d11f0e2ac4bdf025f3 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  
286 286 20200921 CA 781694 12891088   13672782 3459   960         B 9/21/2020 02:59 2020-09-21T02:59:00Z 09/20 22:59 15018   2020-09-21T02:59:00Z 13672782     781694                             6 3294 146330 13672782 posNeg 149624 13672782 31 0 b690b9d123b355bc7c82db4025a3843fa608be9a 0 0 0 0 0  
289 289 20200921 DC 14978 342766   357744 88   26   17   11856 A+ 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 621   2020-09-20T00:00:00Z             357744 204781                     11 23 2577 357744 posNeg 2600 357744 1 0 00488a9e4c3eb06b78810b5b34ecc30f8bcbf043 0 0 0 0 0  
290 290 20200921 DE 19667 253546   273213 53   17       10376 A+ 9/20/2020 18:00 2020-09-20T18:00:00Z 09/20 14:00 627   2020-09-20T18:00:00Z       18648 550 77   273213                     10 101 1691 273213 posNeg 1792 273213 6 0 b3b704c9d5d98c5a8219aafd2030bee39d569f71 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
);