states_daily_4pm_et

Table actions

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

11,578 rows sorted by deathProbable

✎ 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
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  
182 182 20200923 HI 11522 272547   284069 181 749 61   39   4992 B 9/22/2020 18:00 2020-09-22T18:00:00Z 09/22 14:00 120 749 2020-09-22T18:00:00Z 390003             284069                     15 63 1426 284069 posNeg 1489 284069 0 14 b17cb70b8c587e5a87507a57031b3b68b8a67511 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  
187 187 20200923 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 1267 6323 492281 posNeg 7590 492281 21 60 5489dc0b63fcb8091cf4bbc01fcb3a856ae9454c 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  
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  
198 198 20200923 MT 10912 306248   317160 124 601         8510 C 9/23/2020 01:59 2020-09-23T01:59:00Z 09/22 21:59 165 601 2020-09-23T01:59:00Z 317160     10912                             30 212 2939 317160 posNeg 3151 317160 2 17 5a92332dd4f07d8b2e3b3d7cfb119a64e4184f55 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  
201 201 20200923 NE 41785 389317   431102 197 2214         31212 A 9/22/2020 20:10 2020-09-22T20:10:00Z 09/22 16:10 461 2214 2020-09-22T20:10:00Z 580140     41785       431401                     31 397 2659 431102 posNeg 3056 431102 9 6 0e13b9b23a5d3735181e9d4e91f3dd5c38b0d61a 0 0 0 0 0  
202 202 20200923 NH 8007 236482   413391 17 728   230     7303 B 9/23/2020 09:00 2020-09-23T09:00:00Z 09/23 05:00 438 728 2020-09-23T09:00:00Z 413391     8007       244489 31557     30839             33 17 945 244489 posNeg 2925 244489 0 1 bdc274f7dd8d090cd62cec3f98303151a89c9f37 0 0 0 0 0  
204 204 20200923 NM 27790 844541   872331 69 3371         15586 C 9/22/2020 17:12 2020-09-22T17:12:00Z 09/22 13:12 854 3371 2020-09-22T17:12:00Z 872331     27790                             35 107 5541 872331 posNeg 5648 872331 3 13 ec22d7acf556db7867dc9b91942a0a7e6199b12d 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  
206 206 20200923 NY 451892 9683800   10135692 490 89995 141   68   76306 A 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 25437 89995 2020-09-22T23:59:00Z       451892     10135692                       36 665 70265 10135692 posNeg 70930 10135692 5 0 73a23ab7c0b6b78e67d67b6925fc08a799485733 0 0 0 0 0  
208 208 20200923 OK 80161 1034165 6067 1114326 612 6057 226       66779 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 970 6057 2020-09-23T00:00:00Z 1127633 91214 1034165 80161         76497 3764                 40 1089 11398 1120393 posNeg 12487 1114326 8 61 7dba4d79cd71bc996f8f50153d1fc4d8a407f53e 0 0 0 0 0  
209 209 20200923 OR 31503 614622   646125 188 2438 45   16   5475 A+ 9/23/2020 03:01 2020-09-23T03:01:00Z 09/22 23:01 538 2438 2020-09-23T03:01:00Z     614622 29948       644570                     41 190 3354 646125 posNeg 3544 646125 6 19 23b1d6c09988cb0f3b5d89fa439ffbc615e1e40a 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  
212 212 20200923 RI 24177 300943   706578 86 2713 9   5   2275 A+ 9/23/2020 12:00 2020-09-23T12:00:00Z 09/23 08:00 1102 2713 2020-09-23T12:00:00Z   33952 672626 24177     706578 325120                     44 133 2596 325120 totalTestEncountersViral 9770 325120 3 9 619de2d19bf56b44041c7b6d6fbed07b54816f4c 0 0 0 0 0  
214 214 20200923 SD 19634 160498   180132 192 1367         16324 A 9/22/2020 14:00 2020-09-22T14:00:00Z 09/22 10:00 202 1367 2020-09-22T14:00:00Z 250393             180132                     46 445 1341 180132 posNeg 1786 180132 0 44 0b9b24e3e38af8930d497fead940060bba18ffa9 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  
217 217 20200923 UT 65921 709937   775858 190 3584 65 876   354 52357 A+ 9/23/2020 10:39 2020-09-23T10:39:00Z 09/23 06:39 444 3584 2020-09-23T10:39:00Z 993246     65921       775858             11768 1661 19120 1760 49 877 6022 775858 posNeg 6899 775858 1 34 533f79e51b72a89e18727bcef40b18d08ed5fda6 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  
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  
224 224 20200923 WY 5169 89824   94993 21 253         4277 B 9/23/2020 17:25 2020-09-23T17:25:00Z 09/23 13:25 50 253 2020-09-23T17:25:00Z 149060 4322 144737 4368       94055                     56 153 0 94993 posNeg 153 94993 1 0 16decf14600a8fdba04b4b8d6953934532cfc927 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  
231 231 20200922 CO 65399 773485   1219137 239 7373         6306 A 9/21/2020 01:59 2020-09-21T01:59:00Z 09/20 21:59 1914 7373 2020-09-21T01:59:00Z       60792     1219137 834277 166809 11624 155187               8 542 5633 838884 totalTestEncountersViral 10712 838884 1 10 acbe7e6b873d2efee74c91deb30171e27b8cb2ff 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  
235 235 20200922 FL 687909 4444433 3950 5132342 2319 43261           A 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 13579 43261 2020-09-21T23:59:00Z 7209122 885350 6282680 687909 13579     5139472 505164 45080 460024 493810 44075 449702   14977     12 2470 16612 5136292 posNeg 19082 5132342 99 228 1af196871ff34e868be4d56f373a83a08660462c 0 0 0 0 0  
236 236 20200922 GA 308221 2475206   2783427 1960 27490   5026       A 9/22/2020 14:50 2020-09-22T14:50:00Z 09/22 10:50 6677 27490 2020-09-22T14:50:00Z 2783427 286876 2496551 308221         296044 24217                 13 882 11682 2783427 posNeg 12564 2783427 73 96 9ea1088e3046540b8d86a05ad9eb053272185613 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  
238 238 20200922 HI 11459 271121   282580 185 735 51   40   4888 B 9/21/2020 18:00 2020-09-21T18:00:00Z 09/21 14:00 120 735 2020-09-21T18:00:00Z 387200             282580                     15 56 1106 282580 posNeg 1162 282580 0 5 5d5a472d13f94d80f482a071d5f0bac22bc77458 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  
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  
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  
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  
254 254 20200922 MT 10700 303309   314009 111 584         7937 C 9/22/2020 01:59 2020-09-22T01:59:00Z 09/21 21:59 163 584 2020-09-22T01:59:00Z 314009     10700                             30 271 2476 314009 posNeg 2747 314009 3 8 508e06d3fbff288cfb26b77bfeba4391db991668 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  
257 257 20200922 NE 41388 386658   428046 185 2208         31047 A 9/21/2020 20:15 2020-09-21T20:15:00Z 09/21 16:15 452 2208 2020-09-21T20:15:00Z 575663     41388       428341                     31 305 1925 428046 posNeg 2230 428046 10 14 c615677353b2deb442433568311259aa4a254500 0 0 0 0 0  
258 258 20200922 NH 7990 235537   410466 11 727   230     7259 B 9/22/2020 09:00 2020-09-22T09:00:00Z 09/22 05:00 438 727 2020-09-22T09:00:00Z 410466     7990       243527 31505     30781             33 38 1247 243527 posNeg 3133 243527 0 1 5675ff846845212d122d51d8a7363f8681124fcd 0 0 0 0 0  
260 260 20200922 NM 27683 839000   866683 71 3358         15518 B 9/21/2020 17:50 2020-09-21T17:50:00Z 09/21 13:50 851 3358 2020-09-21T17:50:00Z 866683     27683                             35 104 3680 866683 posNeg 3784 866683 2 17 47b8ae8162027de32de85ee9156cbf12e7cb5080 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  
262 262 20200922 NY 451227 9613535   10064762 470 89995 133   67   76246 A 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 25432 89995 2020-09-21T23:59:00Z       451227     10064762                       36 754 83243 10064762 posNeg 83997 10064762 4 0 acfffc57985c0dd288e364f084a74119a9415495 0 0 0 0 0  
264 264 20200922 OK 79072 1022767 3536 1101839 628 5996 244       65482 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 962 5996 2020-09-22T00:00:00Z 1114878 90327 1022767 79072         76497 3764                 40 1164 27070 1105375 posNeg 28234 1101839 14 100 dc68354813025b931403f23e5e319714167994fd 0 0 0 0 0  
265 265 20200922 OR 31313 611268   642581 182 2419 42   17   5431 A+ 9/22/2020 03:01 2020-09-22T03:01:00Z 09/21 23:01 532 2419 2020-09-22T03:01:00Z     611268 29780       641048                     41 318 3465 642581 posNeg 3783 642581 3 24 3cd61f2e8b2a2624fdedb5623741094f7e7d1ce9 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  
268 268 20200922 RI 24044 298347   696808 82 2704 10   7   2272 A+ 9/22/2020 12:00 2020-09-22T12:00:00Z 09/22 08:00 1099 2704 2020-09-22T12:00:00Z   33791 663017 24044     696808 322391                     44 112 1713 322391 totalTestEncountersViral 6527 322391 2 11 76d8f25c0656b7455fece1ef2e92a773d79df2bf 0 0 0 0 0  
270 270 20200922 SD 19189 159157   178346 178 1323         16170 A 9/21/2020 14:00 2020-09-21T14:00:00Z 09/21 10:00 202 1323 2020-09-21T14:00:00Z 247705             178346                     46 320 1003 178346 posNeg 1323 178346 0 26 02e039c062b3c1abf1d36f6dfbc56777cc891c9b 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  
273 273 20200922 UT 65044 703915   768959 183 3550 63 869   352 51945 A+ 9/22/2020 10:33 2020-09-22T10:33:00Z 09/22 06:33 443 3550 2020-09-22T10:33:00Z 982545     65044       768959             11206 1588 17730 1686 49 650 6258 768959 posNeg 6908 768959 2 30 fd0c9d57200a01d725eb96efe92d9cc6b5978592 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  
277 277 20200922 WA 83193 1657706   1740899 277 7314     32     B 9/20/2020 02:59 2020-09-20T02:59:00Z 09/19 22:59 2070 7314 2020-09-20T02:59:00Z       83193 2070   1740899                       53 645 3698 1740899 posNeg 4343 1740899 33 52 fbb72d0ce8868069829ba1891bd21b88275f635c 0 0 0 0 0  
280 280 20200922 WY 5016 89824   94840 21 253         4230 B 9/22/2020 17:10 2020-09-22T17:10:00Z 09/22 13:10 49 253 2020-09-22T17:10:00Z 149060 4322 144737 4231       94055                     56 72 637 94840 posNeg 709 94840 0 6 07edd1d4539f3f8700e4a569517653f3ae0e9490 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  
287 287 20200921 CO 64857 767852   1208425 239 7363         6291 A 9/20/2020 01:59 2020-09-20T01:59:00Z 09/19 21:59 1913 7363 2020-09-20T01:59:00Z       60256     1208425 828108 166546 11600 154948               8 501 6506 832709 totalTestEncountersViral 13046 832709 0 6 dfa726f7daf8d6b4a08ccf6210e93e7c20ea0fd4 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  
291 291 20200921 FL 685439 4427821 3865 5113260 2266 43033           A 9/19/2020 23:59 2020-09-19T23:59:00Z 09/19 19:59 13480 43033 2020-09-19T23:59:00Z 7175080 882212 6251909 685439 13480     5120391 505164 45080 460024 493810 44075 449702   14570     12 1685 16486 5117125 posNeg 18171 5113260 21 94 3fb3d7b71d3a44d19438c63485f2c0d96460e93a 0 0 0 0 0  
292 292 20200921 GA 307339 2463524   2770863 1970 27394   5005       A 9/21/2020 14:50 2020-09-21T14:50:00Z 09/21 10:50 6604 27394 2020-09-21T14:50:00Z 2770863 285951 2484912 307339         295904 24197                 13 1184 18857 2770863 posNeg 20041 2770863 2 17 8c2d67ae667b2076113fd851c6f1503c35258359 0 0 0 0 0  
293 293 20200921 GU 2147 44207   46354 38   18       1505 A 9/21/2020 09:00 2020-09-21T09:00:00Z 09/21 05:00 35   2020-09-21T09:00:00Z 46352     2147       46354 175 3                 66 30 366 46354 posNeg 396 46354 1 0 b64988c77058946a81407403f79ac72214ba9a4f 0 0 0 0 0  
294 294 20200921 HI 11403 270015   281418 185 730 51   40   4759 B 9/20/2020 18:00 2020-09-20T18:00:00Z 09/20 14:00 120 730 2020-09-20T18:00:00Z 385103             281418                     15 77 1492 281418 posNeg 1569 281418 0 4 972930490df7727b3f0708d0d559f9478939e8a4 0 0 0 0 0  
295 295 20200921 IA 78339 643256   721595 271   74   35   57942 A+ 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 1274   2020-09-21T00:00:00Z       78339       723128       55948 3326 52582 18817 2401     19 660 2656 721595 posNeg 3316 721595 9 0 2910df862f5131002adf9961ba0daa43c9c88ff2 0 0 0 0 0  
299 299 20200921 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 1674 8268 484691 posNeg 9942 484691 4 35 4c985aa59230672b21f97f4077756440c35c04e0 0 0 0 0 0  
307 307 20200921 MO 114307 1105252   1219559 1022             B 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 1807   2020-09-21T00:00:00Z 1592975 121430 1468805 114307       1219559       72529 3346 69183         29 1463 5588 1219559 posNeg 7051 1219559 12 0 e2805bb8f048f481f6ea89d859df8fef49f1d0e2 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  
310 310 20200921 MT 10429 300833   311262 108 576         7876 C 9/21/2020 01:59 2020-09-21T01:59:00Z 09/20 21:59 160 576 2020-09-21T01:59:00Z 311262     10429                             30 130 8319 311262 posNeg 8449 311262 3 6 e8fff4c66760ee90023904f8ffa5699f5b1c56d5 0 0 0 0 0  
311 311 20200921 NC 194381 2623158   2817539 885   277       176422 A+ 9/21/2020 12:15 2020-09-21T12:15:00Z 09/21 08:15 3247   2020-09-21T12:15:00Z 2817539     194381 3247                           37 800 11921 2817539 posNeg 12721 2817539 4 0 29618a42d9cfdbb11e88165ff3b744f1fd1a6869 0 0 0 0 0  
313 313 20200921 NE 41083 384733   425816 170 2194         30509 A 9/20/2020 20:15 2020-09-20T20:15:00Z 09/20 16:15 442 2194 2020-09-20T20:15:00Z 562886     41083       426110                     31 286 2170 425816 posNeg 2456 425816 0 0 b8f0be6057e416e8420936ad54493d4b03355818 0 0 0 0 0  
314 314 20200921 NH 7952 234290   407333 11 726   230     7226 B 9/20/2020 09:00 2020-09-20T09:00:00Z 09/20 05:00 438 726 2020-09-20T09:00:00Z 407333     7952       242242 31475     30754             33 5 1836 242242 posNeg 5644 242242 0 1 79428293c38fb378b300135e4d08a2a0155bc9cd 0 0 0 0 0  
316 316 20200921 NM 27579 835320   862899 64 3341         15412 B 9/20/2020 16:58 2020-09-20T16:58:00Z 09/20 12:58 849 3341 2020-09-20T16:58:00Z 862899     27579                             35 67 5376 862899 posNeg 5443 862899 2 6 d8b912acad2a2e01f170146fc396452eaa92b799 0 0 0 0 0  
317 317 20200921 NV 76036 590756   666792 449   130   81   2026 A+ 9/21/2020 02:59 2020-09-21T02:59:00Z 09/20 22:59 1531   2020-09-21T02:59:00Z 988019     76036       666062                     32 232 1376 666792 posNeg 1608 666792 0 0 8d418c4347de957ff1ef8b136a726fb6bcf35620 0 0 0 0 0  
318 318 20200921 NY 450473 9530292   9980765 468 89995 134   66   76218 A 9/20/2020 23:59 2020-09-20T23:59:00Z 09/20 19:59 25428 89995 2020-09-20T23:59:00Z       450473     9980765                       36 573 57746 9980765 posNeg 58319 9980765 1 0 6e223bb0204780c57bf975ab107522993c6290f8 0 0 0 0 0  
320 320 20200921 OK 77908 995697 8878 1073605 522 5896 222       64941 A+ 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 948 5896 2020-09-21T00:00:00Z 1084302 86886 995697 77908         76497 3764                 40 1101 0 1082483 posNeg 1101 1073605 2 53 310ffbbe35de348e1452bd96e868c3aafffdc6bc 0 0 0 0 0  
321 321 20200921 OR 30995 607803   638798 169 2395 34   13   5431 A+ 9/21/2020 03:01 2020-09-21T03:01:00Z 09/20 23:01 529 2395 2020-09-21T03:01:00Z     607803 29481       637284                     41 194 2535 638798 posNeg 2729 638798 3 39 a4fe87c5439a6a5dc0bf128bbc939dd0212e0377 0 0 0 0 0  
322 322 20200921 PA 150812 1767181   1917993 418       59   123665 A+ 9/21/2020 12:00 2020-09-21T12:00:00Z 09/21 08:00 8004   2020-09-21T12:00:00Z 2758758     146281       1913462                     42 234 8849 1917993 posNeg 9083 1917993 23 0 23eeb661ed83d84bebb5cae8db6ab376cec99110 0 0 0 0 0  
324 324 20200921 RI 23932 296634   690281 78 2693 10   4   2268 A+ 9/21/2020 12:00 2020-09-21T12:00:00Z 09/21 08:00 1097 2693 2020-09-21T12:00:00Z   33671 656610 23932     690281 320566                     44 52 711 320566 totalTestEncountersViral 2136 320566 3 0 def3a930acdb8fc111f370444a89b38d5622c0f4 0 0 0 0 0  
326 326 20200921 SD 18869 158154   177023 161 1297         15777 A 9/20/2020 14:00 2020-09-20T14:00:00Z 09/20 10:00 202 1297 2020-09-20T14:00:00Z 245387             177023                     46 173 497 177023 posNeg 670 177023 0 9 de8ce40f2ca507606ebfad5913ea49564ff9fe7c 0 0 0 0 0  
328 328 20200921 TX 698387 4924111   5622498 3132   1073       611856 A 9/21/2020 17:45 2020-09-21T17:45:00Z 09/21 13:45 14917   2020-09-21T17:45:00Z 5622498     698387         386966 34843             64302 7867 48 9853 19157 5622498 posNeg 29010 5622498 24 0 09a4609909a8385823119af6254c78b7c8391951 0 0 0 0 0  
329 329 20200921 UT 64394 697657   762051 154 3520 61 857   350 51660 A+ 9/21/2020 10:29 2020-09-21T10:29:00Z 09/21 06:29 441 3520 2020-09-21T10:29:00Z 973181     64394       762051             10677 1527 16873 1622 49 622 3264 762051 posNeg 3886 762051 1 26 94ebe70eb759f86226928ebb85a343414942467d 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  
332 332 20200921 VT 1719 155020   156739 3           1557 B 9/20/2020 23:59 2020-09-20T23:59:00Z 09/20 19:59 58   2020-09-20T23:59:00Z       1719 58     156739                     50 4 840 156739 posNeg 844 156739 0 0 e0918eb00b093d9db0cac5b171724ce0427c09e2 0 0 0 0 0  
333 333 20200921 WA 82548 1654008   1736556 266 7262     21     B 9/20/2020 02:59 2020-09-20T02:59:00Z 09/19 22:59 2037 7262 2020-09-20T02:59:00Z       82548 2037   1736556                       53 349 13167 1736556 posNeg 13516 1736556 0 14 1ec9cb24edb05172778970744d37350c347da8eb 0 0 0 0 0  
336 336 20200921 WY 4944 89187   94131 23 247         4172 B 9/21/2020 16:47 2020-09-21T16:47:00Z 09/21 12:47 49 247 2020-09-21T16:47:00Z 145231 4211 141019 4189       93376                     56 73 1627 94131 posNeg 1700 94131 0 4 29fade3cb82b3f5a982e66deeb63e9064a93cac9 0 0 0 0 0  
337 337 20200920 AK 7767 419158   426925 43       13   2438 A 9/20/2020 03:59 2020-09-20T03:59:00Z 09/19 23:59 45   2020-09-20T03:59:00Z 426925 7061 419584 7767 45                           2 93 3982 426925 posNeg 4075 426925 0 0 d939ccbfc0a45044ede4b81384f1a41520b50f87 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  
342 342 20200920 CA 778400 12744758   13523158 3441   925         B 9/20/2020 02:59 2020-09-20T02:59:00Z 09/19 22:59 14987   2020-09-20T02:59:00Z 13523158     778400                             6 4265 175007 13523158 posNeg 179272 13523158 75 0 fd88a82366b400053d994227a86f175bbe8112b4 0 0 0 0 0  
343 343 20200920 CO 64356 761346   1195379 237 7357         6274 A 9/20/2020 01:59 2020-09-20T01:59:00Z 09/19 21:59 1913 7357 2020-09-20T01:59:00Z       59782     1195379 821128 166196 11568 154630               8 606 7227 825702 totalTestEncountersViral 13550 825702 0 10 53538ff2d6fb07c9a2a5be3d98b592c35770bf7b 0 0 0 0 0  
345 345 20200920 DC 14955 340189   355144 86   25   14   11829 A+ 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 620   2020-09-19T00:00:00Z             355144 204099                     11 53 4214 355144 posNeg 4267 355144 1 0 64545b24e233cc19e1139412d3c0df143abd32c4 0 0 0 0 0  
347 347 20200920 FL 683754 4411335 3871 5095089 2292 42939           A 9/19/2020 23:59 2020-09-19T23:59:00Z 09/19 19:59 13459 42939 2020-09-19T23:59:00Z 7142713 879887 6222032 683754 13459     5102203 446669 34738 411877 437913 34017 403867   14565     12 2521 24014 5098960 posNeg 26535 5095089 9 81 cfb904601b096e11d34b678dd9d9abdcbf80e2c4 0 0 0 0 0  
348 348 20200920 GA 306155 2444667   2750822 1926 27377   5002       A 9/20/2020 14:50 2020-09-20T14:50:00Z 09/20 10:50 6602 27377 2020-09-20T14:50:00Z 2750822 282798 2468024 306155         295046 24046                 13 1134 14299 2750822 posNeg 15433 2750822 3 39 2432e2db740a480d7db5e0fb4a03010cc0afde1a 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  
350 350 20200920 HI 11326 268523   279849 185 726 51   40   4622 B 9/19/2020 18:00 2020-09-19T18:00:00Z 09/19 14:00 120 726 2020-09-19T18:00:00Z 381571             279740                     15 109 0 279849 posNeg 109 279849 0 26 38a3be6d93c57e4008714676d7a19cd972faf2d8 0 0 0 0 0  
351 351 20200920 IA 77679 640600   718279 269   73   38   57524 A+ 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 1265   2020-09-20T00:00:00Z       77679       719817       55887 3320 52527 18671 2368     19 621 3883 718279 posNeg 4504 718279 1 0 31ae6f0da018d9d0ec472b92b1bc0f0e709650a7 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  
363 363 20200920 MO 112844 1099664   1212508 1064             B 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 1795   2020-09-20T00:00:00Z 1583984 120142 1461128 112844       1212508       72455 3316 69139         29 1328 8556 1212508 posNeg 9884 1212508 2 0 bf8501f62ec994b3e8bf3f3d9d3894e307550e94 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  
366 366 20200920 MT 10299 292514   302813 104 570         7807 C 9/20/2020 01:59 2020-09-20T01:59:00Z 09/19 21:59 157 570 2020-09-20T01:59:00Z 302813     10299                             30 136 1837 302813 posNeg 1973 302813 1 3 d146247cf00e049be1639b161712115346631bc6 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
);