states_daily_4pm_et

Table actions

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

11,578 rows sorted by hash descending

✎ 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
4397 4397 20200710 MS 34622 295690   330312 981 3455 205   103   22167 A 7/9/2020 19:00 2020-07-09T19:00:00Z 07/09 15:00 1215 3455 2020-07-09T19:00:00Z 330011     34321 1195 20     13024 95                 28 1031 4477 330312 posNeg 5508 330312 11 41 fffe384636e658a4415ac639b7ca9cef38212502 0 0 0 0 0  
6594 6594 20200601 PA 72898 389431   462329 1302       287   48428 A+ 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 5567   2020-06-01T00:00:00Z       70278       459709   616                 42 352 6320 462329 posNeg 6672 462329 12 0 fff337eae297970a1e206abffadfe24260fc7934 0 0 0 0 0  
4974 4974 20200630 SD 6764 73324   80088 62 666         5872 B 6/30/2020 12:39 2020-06-30T12:39:00Z 06/30 08:39 91 666 2020-06-30T12:39:00Z               80088                     46 48 583 80088 posNeg 631 80088 0 9 fff0bc0128259e4221845f3683708a840eeb396c 0 0 0 0 0  
11379 11379 20200307 WY 0     0                                                                 56 0 0 0 posNeg 0 0 0 0 ffee52181b4952cfd716e9120a0e7366ea56125e 0 0 0 0 0  
11183 11183 20200310 DC 5 17 2 22                                         22                       11 4 3 24 posNeg 7 22 0 0 ffed480a147765c6e3fb2b249f049a840f4e0711 0 0 0 0 0  
9995 9995 20200401 MO 1581 15846   17427               C 4/1/2020 15:00 2020-04-01T15:00:00Z 04/01 11:00 18   2020-04-01T15:00:00Z 21956 2402 19540 1581                             29 254 1232 17427 posNeg 1486 17427 4 0 ffec91bec69cc398c5b136ee7be7f37790b0dffa 0 0 0 0 0  
7074 7074 20200523 IN 30901 184032   214933 1138 5285 403 1166 173     A+ 5/22/2020 23:59 2020-05-22T23:59:00Z 05/22 19:59 1943 5285 2020-05-22T23:59:00Z         1812 152   214933                     18 492 5880 214933 posNeg 6372 214933 2 0 ffe9925bd2e12d4ee2743bcfc91802bd3610f8cb 0 0 0 0 0  
5892 5892 20200613 GA 56801 542879   599680 810 9224   2029       A 6/13/2020 14:00 2020-06-13T14:00:00Z 06/13 10:00 2446 9224 2020-06-13T14:00:00Z 599680 51203 548477 56801         113405 6631                 13 1018 6704 599680 posNeg 13254 599680 28 43 ffe928d7ad54a77034731daecb5b57db99b4dfee 0 0 0 0 0  
2526 2526 20200812 CA 586056 8717411   9303467 6647   1873         B 8/11/2020 00:00 2020-08-11T00:00:00Z 08/10 20:00 10648   2020-08-11T00:00:00Z 9303467     586056                             6 11645 105543 9303467 posNeg 117188 9303467 180 0 ffe924583c8cca6911baa2112469181c6d0020e8 0 0 0 0 0  
7594 7594 20200514 NH 3299 35876 735 42287 126 326   97     1236 B 5/13/2020 09:00 2020-05-13T09:00:00Z 05/13 05:00 150 326 2020-05-13T09:00:00Z 42287     2588       35840 5168                   33 60 1899 39910 posNeg 2669 39175 8 7 ffddb013a8902c379608dac279251c2ccca83ed9 0 0 0 0 0  
7361 7361 20200518 MI 58812 376115   434927 1075   473   418   28234 A+ 5/18/2020 11:00 2020-05-18T11:00:00Z 05/18 07:00 5427   2020-05-18T11:00:00Z 444305 68190 376115 54872 5237 233                         26 534 12567 434927 posNeg 13101 434927 31 0 ffdbdef4dbe72b7ea0b9b57415df0ef536056592 0 0 0 0 0  
9744 9744 20200406 WY 210 3719   3929   23         52 A 4/6/2020 11:32 2020-04-06T11:32:00Z 04/06 07:32 0 23 2020-04-06T11:32:00Z       201                             56 13 679 3929 posNeg 692 3929 0 0 ffda18b48fc87279f99bf2fa58d63b5df4e7f97c 0 0 0 0 0  
7449 7449 20200516 AK 392 32889   33281 10           344 B 5/16/2020 00:00 2020-05-16T00:00:00Z 05/15 20:00 10   2020-05-16T00:00:00Z 33281     392 10                           2 4 859 33281 posNeg 863 33281 0 0 ffd0638063aeba8595093f3e2a1d87f40f00b7ea 0 0 0 0 0  
922 922 20200910 MN 82249 1123252   1646961 257 6830 138 1927     75425 A+ 9/9/2020 17:00 2020-09-09T17:00:00Z 09/09 13:00 1936 6830 2020-09-09T17:00:00Z       82249 1884 52 1646961 1205501                     27 381 927 1205501 posNeg 25787 1205501 15 38 ffc780ba88f05d57f665a249a6d4b938f465dd4b 0 0 0 0 0  
5818 5818 20200615 VA 54886 424113 259 502392 902 8132 269   130   7230 A+ 6/14/2020 17:00 2020-06-14T17:00:00Z 06/14 13:00 1552 8132 2020-06-14T17:00:00Z   64951   52460 1444 108 502392                       51 380 9619 479258 posNeg 8677 478999 6 -4 ffc7684284775c23d96a6575db7f00e8ad6bd0d7 0 0 0 0 0  
8112 8112 20200505 TX 33369 393841   427210 1888           16791 B 5/5/2020 13:15 2020-05-05T13:15:00Z 05/05 09:15 906   2020-05-05T13:15:00Z       33369 433                           48 1037 18775 427210 posNeg 19812 427210 22 0 ffc235ab1ebcd008c69dfb2d305c76ce91674180 0 0 0 0 0  
3160 3160 20200801 ME 3937 165809   169746 10 388 5   1   3377 A+ 7/31/2020 23:59 2020-07-31T23:59:00Z 07/31 19:59 123 388 2020-07-31T23:59:00Z 169325 4905 164215 3516 122 1     8854 417 8425               23 25 2554 169746 posNeg 2579 169746 0 0 ffbcd38dd4a8140c76b1cd558d1faa8e2fe413c0 0 0 0 0 0  
1657 1657 20200828 NE 33101 319318   352419 174 1968         25009 A 8/27/2020 20:25 2020-08-27T20:25:00Z 08/27 16:25 391 1968 2020-08-27T20:25:00Z       33101       352922                     31 374 3470 352419 posNeg 3844 352419 5 14 ffb9c20e84752b50b01ff5b445ed656b56191976 0 0 0 0 0  
9043 9043 20200418 MO 5517 48242   53759 875             A 4/18/2020 15:00 2020-04-18T15:00:00Z 04/18 11:00 175   2020-04-18T15:00:00Z 54507 6260 48182 5517               8 1 7         29 234 1808 53759 posNeg 2042 53759 10 0 ffa808fb89e20483e5ca8cc8470262ff1d18e33f 0 0 0 0 0  
1934 1934 20200823 MT 6429 204320   210749 111 379         4816 C 8/23/2020 01:59 2020-08-23T01:59:00Z 08/22 21:59 90 379 2020-08-23T01:59:00Z 210749     6429                             30 53 980 210749 posNeg 1033 210749 0 1 ffa1dffb572d264a41c213ddd0d69e7613723b54 0 0 0 0 0  
6075 6075 20200610 MO 15187 236442   251629 533       59     B 6/10/2020 15:00 2020-06-10T15:00:00Z 06/10 11:00 848   2020-06-10T15:00:00Z 270232 17275 252506 15187       251629       30893 1175 29718         29 274 5660 251629 posNeg 5934 251629 8 0 ff97f1f7cd4d748a29ca08d833ff5b795ebfd484 0 0 0 0 0  
8346 8346 20200430 AL 7019 80177   87196 479 978   335   195   B 4/30/2020 00:00 2020-04-30T00:00:00Z 04/29 20:00 269 978 2020-04-30T00:00:00Z 87196     7019                             1 177 6570 87196 posNeg 6747 87196 24 33 ff946b18a1a43dea29c20328ddbd69d2ab03047e 0 0 0 0 0  
11377 11377 20200307 WI 1 31 12 32                                   1                             55 0 0 44 posNeg 0 32 0 0 ff911df2918ff9b2c0eceb8859546b9205e5be93 0 0 0 0 0  
5537 5537 20200620 UT 17068 275809   292877 232 1161 66 333   149 9390 A 6/20/2020 11:33 2020-06-20T11:33:00Z 06/20 07:33 155 1161 2020-06-20T11:33:00Z       17068       292877             57 17 67 17 49 643 4876 292877 posNeg 5519 292877 0 16 ff8e12840c12c1413c4485aa907b6b0ce430d992 0 0 0 0 0  
3739 3739 20200722 PR 13038 255766   268804 415   49   31     B 7/22/2020 06:30 2020-07-22T06:30:00Z 07/22 02:30 185   2020-07-22T06:30:00Z 258001 3966 253922 4330 84 101       8708                 72 98 0 268804 posNeg 98 268804 5 0 ff8936a74fb217a3fc63340fcf218f0b2f97c500 0 0 0 0 0  
4386 4386 20200710 IN 50300 500262   550562 667 7458 217 1577 87   38120 A+ 7/9/2020 23:59 2020-07-09T23:59:00Z 07/09 19:59 2748 7458 2020-07-09T23:59:00Z         2555 193   550562                     18 725 7545 550562 posNeg 8270 550562 9 72 ff881fbc8e3dcbcc56b6ed9dfadca902d67f42ca 0 0 0 0 0  
2227 2227 20200818 PR 27713 305972   333685 392   62   45     B 8/18/2020 00:00 2020-08-18T00:00:00Z 08/17 20:00 346   2020-08-18T00:00:00Z 310546 7002 303412 12371 216 130       15342                 72 953 0 333685 posNeg 953 333685 11 0 ff867e81d2e5eed2c5737f5782831a5d3e42a119 0 0 0 0 0  
5290 5290 20200624 MN 33763 495880   529643 340 3897 160 1203     29707 A 6/23/2020 17:00 2020-06-23T17:00:00Z 06/23 13:00 1432 3897 2020-06-23T17:00:00Z       33763 1397 35 529643                       27 294 9304 529643 posNeg 9598 529643 7 37 ff8017205871f68cd0160394c00d49ca5602623b 0 0 0 0 0  
3891 3891 20200719 MO 33094 525985   559079 875       86     B 7/19/2020 15:00 2020-07-19T15:00:00Z 07/19 11:00 1129   2020-07-19T15:00:00Z 709043 37936 670037 33094       559079       53533 1829 51704         29 846 7357 559079 posNeg 8203 559079 -1 0 ff7b4449f60b1b13a5b37999bd5f7302f2971519 0 0 0 0 0  
4534 4534 20200708 WI 36410 611150 152 647560 274 3683 74 787     26305 A+ 7/8/2020 16:00 2020-07-08T16:00:00Z 07/08 12:00 814 3683 2020-07-08T16:00:00Z       33154 807 7   644304                     55 645 10138 647712 posNeg 10783 647560 2 44 ff7b0facbecb5d26878fa95a5d0e61c2a09ddc15 0 0 0 0 0  
6846 6846 20200527 HI 643 50559   51202   83         593 D 5/26/2020 00:00 2020-05-26T00:00:00Z 05/25 20:00 17 83 2020-05-26T00:00:00Z 51202                                   15 0 831 51202 posNeg 831 51202 0 -1 ff7a654a60f693a890d62314f5a72ba09fe067d9 0 0 0 0 0  
8413 8413 20200429 GU 145 1702   1847             130 D 4/29/2020 09:35 2020-04-29T09:35:00Z 04/29 05:35 5   2020-04-29T09:35:00Z       141                             66 1 164 1847 posNeg 165 1847 0 0 ff7a4c747c57fe85880f25fece0db94954a06763 0 0 0 0 0  
5956 5956 20200612 KY 11945 269149   280786 514 2406 81 967     3379 B 6/11/2020 00:00 2020-06-11T00:00:00Z 06/10 20:00 493 2406 2020-06-11T00:00:00Z 280786     11637 491 2     28319                   21 0 0 281094 posNeg 0 281094 0 0 ff757a1688fd691f02f9fec85225e3634747be8e 0 0 0 0 0  
4993 4993 20200629 DC 10292 85068   95360 121   34   23   1200 A+ 6/28/2020 00:00 2020-06-28T00:00:00Z 06/27 20:00 551   2020-06-28T00:00:00Z             95360 74575                     11 44 2184 95360 posNeg 2228 95360 1 0 ff71eed26b95e565ef7c10909a3a3041a746b655 0 0 0 0 0  
5178 5178 20200626 MN 34616 522662   557278 335 3966 157 1221     30008 A 6/25/2020 17:00 2020-06-25T17:00:00Z 06/25 13:00 1446 3966 2020-06-25T17:00:00Z       34616 1411 35 557278                       27 493 14089 557278 posNeg 14582 557278 5 23 ff6658f5bbff420c6d6dfd936440f1175c5e27ef 0 0 0 0 0  
11340 11340 20200307 HI 1     1                                                                 15 0 0 1 posNeg 0 1 0 0 ff4edd0e286c634864c3eaab6d4b695fa101bb9b 0 0 0 0 0  
9981 9981 20200401 GU 77 406   483 19   2       9   4/1/2020 08:30 2020-04-01T08:30:00Z 04/01 04:30 3   2020-04-01T08:30:00Z                                     66 8 35 483 posNeg 43 483 1 0 ff4c1ecd6fa44c98347c9af10ddd7e3538142daa 0 0 0 0 0  
8267 8267 20200502 NJ 123717 138595 676 262312 5713   1715   1230   15642 A+ 5/2/2020 13:00 2020-05-02T13:00:00Z 05/02 09:00 9230   2020-05-02T13:00:00Z       123717 7742 1488   262312                     34 2527 3240 262988 posNeg 5767 262312 227 0 ff4759dc77c4e0f9ddcae62dd1c67aa1f6229560 0 0 0 0 0  
8339 8339 20200501 VI 66 811 68 877             51 C 4/30/2020 20:37 2020-04-30T20:37:00Z 04/30 16:37 4   2020-04-30T20:37:00Z                                     78 0 4 945 posNeg 4 877 0 0 ff46b38f0b5ef21ec5a0768454a2522dd98937af 0 0 0 0 0  
769 769 20200913 OR 29337 583283   612620 161 2235 43   19   5310 A+ 9/13/2020 03:01 2020-09-13T03:01:00Z 09/12 23:01 509 2235 2020-09-13T03:01:00Z     583283 27460       604334                     41 181 2335 612620 posNeg 2516 612620 4 0 ff43fd420fcd3b571f813ce0d1326bd80930588a 0 0 0 0 0  
2874 2874 20200806 IN 71015 733330   804345 1009 9267 301 1923 82   53301 A+ 8/5/2020 23:59 2020-08-05T23:59:00Z 08/05 19:59 3013 9267 2020-08-05T23:59:00Z 1004353       2811 202   804345                     18 1040 11080 804345 posNeg 12120 804345 6 119 ff2b679980289a24a60b861d838447aa871a8449 0 0 0 0 0  
8334 8334 20200501 SD 2525 14838   17363 69 179         1686 C 5/1/2020 11:28 2020-05-01T11:28:00Z 05/01 07:28 21 179 2020-05-01T11:28:00Z               17363                     46 76 259 17363 posNeg 335 17363 4 6 ff2711e6be72fb9c0532da66901a5c6d71a10e21 0 0 0 0 0  
1373 1373 20200902 MS 84365 497221   581586 856 5326 190   111   67918 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2526 5326 2020-09-01T00:00:00Z 577414     80193 2364 162     26774 95             31722   28 781 3288 581586 posNeg 4069 581586 33 0 ff1e002516a9e9fc5f444324946ae8fb38dcb84f 0 0 0 0 0  
1652 1652 20200828 MP 54 13486   13540   4         29 D 8/26/2020 23:49 2020-08-26T23:49:00Z 08/26 19:49 2 4 2020-08-26T23:49:00Z 17626     54 2     13540                     69 0 0 13540 posNeg 0 13540 0 0 ff1a8404afb984304eb95c1436e2d07c75e6c5bf 0 0 0 0 0  
5424 5424 20200622 TX 114881 1434128   1549009 3711           69190 B 6/22/2020 16:40 2020-06-22T16:40:00Z 06/22 12:40 2192   2020-06-22T16:40:00Z 1549009     114881         166168 6527                 48 3280 19549 1549009 posNeg 22829 1549009 10 0 ff0fb634b71b3dd434da64c9cf8b4515509843ed 0 0 0 0 0  
10228 10228 20200328 NM 191 9196   9387 17             A 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 1   2020-03-27T00:00:00Z                                     35 55 819 9387 posNeg 874 9387 0 0 ff0f18617c6f578e7216b0033fe7d7605896c520 0 0 0 0 0  
3296 3296 20200730 TX 412107 3197367   3609474 9296   3087       260542 A 7/30/2020 17:55 2020-07-30T17:55:00Z 07/30 13:55 6274   2020-07-30T17:55:00Z 3609474     412107         239566 11430                 48 8800 61306 3609474 posNeg 70106 3609474 84 0 ff0d8c165b9c4a322872e8f1c8f9b44ea13141dc 0 0 0 0 0  
11537 11537 20200211 WA 0 0   0                                   0     0                       53 0 0 0 posNeg 0 0 0 0 ff0cb7c50f42126410e0e2a3959a1415c450d6ce 0 0 0 0 0  
1596 1596 20200829 MP 56 13486   13542   4         29 C 8/26/2020 23:49 2020-08-26T23:49:00Z 08/26 19:49 2 4 2020-08-26T23:49:00Z 17626     56 2     13540                     69 2 0 13542 posNeg 2 13542 0 0 ff05f1c1c990a501fb5325c94904199d66c8a716 0 0 0 0 0  
11205 11205 20200310 NE 3 47 16 50                                                                 31 0 11 66 posNeg 11 50 0 0 ff00636736ded39a5039c1cf8a201b64ee70b817 0 0 0 0 0  
6025 6025 20200611 NE 16025 111637   127662 175 1000         8946 D 6/10/2020 20:00 2020-06-10T20:00:00Z 06/10 16:00 195 1000 2020-06-10T20:00:00Z       16025       127830                     31 142 2358 127662 posNeg 2500 127662 4 11 fefcbc07c7fcd8dcab2bb5f7c1b847cc9fa2d56b 0 0 0 0 0  
1215 1215 20200905 OH 129785 2248125   2377910 717 13808 253 3032 136   107972 A+ 9/5/2020 14:00 2020-09-05T14:00:00Z 09/05 10:00 4256 13808 2020-09-05T14:00:00Z 2371204     123079 3969 287                         39 1341 26984 2377910 posNeg 28325 2377910 8 77 fee829cb6384a764a8d590175d5d5c91cb53becb 0 0 0 0 0  
4412 4412 20200710 RI 17312 149343   285282 61 2051 4   5   1685 A+ 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 976 2051 2020-07-10T00:00:00Z 278357 24885 253472 17312     285282 166655                     44 69 1449 166655 totalTestEncountersViral 3747 166655 2 8 fee53718f10f1395128af0ff1cbd158b377add41 0 0 0 0 0  
2810 2810 20200807 DE 15445 179339   194784 37   15       8392 A+ 8/6/2020 18:00 2020-08-06T18:00:00Z 08/06 14:00 588   2020-08-06T18:00:00Z       14447 518 70   194784                     10 80 2001 194784 posNeg 2081 194784 1 0 fee29f22a87da384050aa3fdc48bb442a2db59fb 0 0 0 0 0  
97 97 20200925 OR 32314 630592   662906 199 2496 40   14   5490 A+ 9/25/2020 03:01 2020-09-25T03:01:00Z 09/24 23:01 542 2496 2020-09-25T03:01:00Z     630592 30742       661334                     41 449 11959 662906 posNeg 12408 662906 3 28 fee078b065b8d17acc4fd7936dd744ca882709ed 0 0 0 0 0  
728 728 20200914 WY 4392 84614   89006 13 230         3884 B 9/14/2020 17:29 2020-09-14T17:29:00Z 09/14 13:29 46 230 2020-09-14T17:29:00Z 133083 3726 129356 3723       88337                     56 46 2523 89006 posNeg 2569 89006 4 2 fedb39be0007bb63a67ab0d2090260814b97c39f 0 0 0 0 0  
7191 7191 20200521 MD 43531 176702   220233 1374 7485 526       3099 B 5/21/2020 10:00 2020-05-21T10:00:00Z 05/21 06:00 2221 7485 2020-05-21T10:00:00Z 245385 49129   43531 2116 105   220233                     24 1208 3695 220233 posNeg 4903 220233 23 92 feda5feabf7124d81a8ad9c546ad66f6d65978ea 0 0 0 0 0  
10692 10692 20200320 VT 44 957   1001                 3/20/2020 00:00 2020-03-20T00:00:00Z 03/19 20:00 2   2020-03-20T00:00:00Z                                     50 16 193 1001 posNeg 209 1001 2 0 fed98e402621da72b8abda016dc7799a556edaed 0 0 0 0 0  
5144 5144 20200627 TX 143371 1579455   1722826 5523           78248 B 6/27/2020 15:50 2020-06-27T15:50:00Z 06/27 11:50 2366   2020-06-27T15:50:00Z 1722826     143371         180835 6918                 48 5747 19745 1722826 posNeg 25492 1722826 42 0 fed767756d8b40b72b18269c9b6b2ba566f0c3ba 0 0 0 0 0  
4034 4034 20200716 AL 61088 490021   550179 1395 7584   950   516 29736 B 7/16/2020 11:00 2020-07-16T11:00:00Z 07/16 07:00 1230 7584 2020-07-16T11:00:00Z 550179     60158 1200 30                         1 2021 8039 551109 posNeg 9972 551109 19 293 fed6c54ff978566f4a73f0f60f117c88fe1f720d 0 0 0 0 0  
4731 4731 20200704 MO 23215 389046   412261 740       73     B 7/4/2020 15:00 2020-07-04T15:00:00Z 07/04 11:00 1027   2020-07-04T15:00:00Z 424214 23527 399926 23215       412261       46053 1614 44439         29 385 6917 412261 posNeg 7302 412261 1 0 fec32cca8f34a5f69b1ef89832c0a66b40e0211a 0 0 0 0 0  
6148 6148 20200609 RI 15751 110588   190419 144 1815 31   19   1398 A+ 6/9/2020 03:00 2020-06-09T03:00:00Z 06/08 23:00 808 1815 2020-06-09T03:00:00Z 191076 21735 169341 15751     190419 126339                     44 68 1164 126339 totalTestEncountersViral 1966 126339 9 8 fec1f8666b2cfb8f79e2efdc6b541d34f1aedc9a 0 0 0 0 0  
3925 3925 20200718 AZ 141265 630726   771991 3238 6567 894   657   17661 A+ 7/18/2020 00:00 2020-07-18T00:00:00Z 07/17 20:00 2730 6567 2020-07-18T00:00:00Z       137710 2431 152   771991 206872                   4 2742 4281 771991 posNeg 7836 771991 147 165 fec0dbb43e0034086dba730ed6a8844c9e94e09f 0 0 0 0 0  
2807 2807 20200807 CO 49436 521927   766473 317 6572         5490 A 8/6/2020 01:59 2020-08-06T01:59:00Z 08/05 21:59 1729 6572 2020-08-06T01:59:00Z       46200     766473 568127 142116 9726 132390               8 448 5596 571363 totalTestEncountersViral 11829 571363 12 36 febcb94fb036b5a546b864b029717c9547a9db3a 0 0 0 0 0  
6291 6291 20200606 KS 10393 103260   113653   917   306   135 612 A 6/5/2020 10:00 2020-06-05T10:00:00Z 06/05 06:00 232 917 2020-06-05T10:00:00Z                                     20 0 0 113653 posNeg 0 113653 0 0 feb92ac0c47f83dde05696b11aa61ec1a2189dc1 0 0 0 0 0  
10201 10201 20200328 DC 304 2211 1 2515             51 A 3/27/2020 20:30 2020-03-27T20:30:00Z 03/27 16:30 4   2020-03-27T20:30:00Z             2515                       11 37 314 2516 posNeg 351 2515 1 0 feb029fd0c4bb392eb162e8c13860090d5623723 0 0 0 0 0  
9404 9404 20200412 VT 754 8724   9478 34           15 A 4/12/2020 00:00 2020-04-12T00:00:00Z 04/11 20:00 27   2020-04-12T00:00:00Z       754                             50 21 661 9478 posNeg 682 9478 2 0 feaaba142251bf0ca145fdaddb7e16f40330b8dc 0 0 0 0 0  
11231 11231 20200309 CA 114 690   804                             804                                   6 26 228 804 posNeg 254 804 0 0 fea9c289449ce22906ed82fbc8684d83583936be 0 0 0 0 0  
4760 4760 20200704 WY 1606 33693   35299 8 119         1169 B 7/4/2020 12:20 2020-07-04T12:20:00Z 07/04 08:20 20 119 2020-07-04T12:20:00Z 47932 1342 46589 1289       34926                     56 24 0 35299 posNeg 24 35299 0 0 fea698f330e1c7364af739260e16c9cbc073faab 0 0 0 0 0  
4964 4964 20200630 NM 11982 325738   337720 119 1876         5296 B 6/29/2020 17:30 2020-06-29T17:30:00Z 06/29 13:30 493 1876 2020-06-29T17:30:00Z 337720     11982                             35 173 6499 337720 posNeg 6672 337720 1 11 fe9cd903bc36e813b1fd2210851d7099ab72a45c 0 0 0 0 0  
10369 10369 20200325 DC 183 1423 3 1606               A 3/24/2020 19:30 2020-03-24T19:30:00Z 03/24 15:30 2   2020-03-24T19:30:00Z             1606                       11 46 228 1609 posNeg 274 1606 0 0 fe8ce83e92c79aba0c934e9a6a826157880333a0 0 0 0 0 0  
6626 6626 20200531 IN 34574 226972   261546 1050 5285 372 1248 143   21704 A+ 5/30/2020 23:59 2020-05-30T23:59:00Z 05/30 19:59 2134 5285 2020-05-30T23:59:00Z         1967 167   261546                     18 363 4788 261546 posNeg 5151 261546 9 0 fe8a5168d242d4a242aa1be6476fbf0e9567980c 0 0 0 0 0  
5209 5209 20200625 AK 816 98636   99452 14       2   513 A 6/25/2020 00:00 2020-06-25T00:00:00Z 06/24 20:00 12   2020-06-25T00:00:00Z 99452     816 12                           2 24 3332 99452 posNeg 3356 99452 0 0 fe83c47fcddea5fcb2ebf4f61993ee4f01027ae4 0 0 0 0 0  
3920 3920 20200719 WY 2126 41927   44053 17 143         1615 B 7/19/2020 14:29 2020-07-19T14:29:00Z 07/19 10:29 24 143 2020-07-19T14:29:00Z 61032 1769 59262 1728       43605                     56 18 0 44053 posNeg 18 44053 0 1 fe7ee88a207081fdfc376a1a3777701168dae5f3 0 0 0 0 0  
2774 2774 20200808 MT 4889 183957   188846 81 268         3255 C 8/8/2020 00:00 2020-08-08T00:00:00Z 08/07 20:00 75 268 2020-08-08T00:00:00Z 188846     4889                             30 132 958 188846 posNeg 1090 188846 5 4 fe7c983b17a21a5b3212490ad3ee75a588e62cc9 0 0 0 0 0  
4335 4335 20200711 MD 72467 556810   629277 390 11353 120       5190 A 7/11/2020 10:00 2020-07-11T10:00:00Z 07/11 06:00 3310 11353 2020-07-11T10:00:00Z 781140 84938   72467 3179 131   629277                     24 557 7657 629277 posNeg 8214 629277 7 53 fe7ba5cd7abfab1c2dd9b540b4ffe61414d0fc0e 0 0 0 0 0  
9827 9827 20200404 MO 2291 22614   24905 413             C 4/4/2020 15:00 2020-04-04T15:00:00Z 04/04 11:00 24   2020-04-04T15:00:00Z 28877 3277 25580 2291                             29 178 3257 24905 posNeg 3435 24905 5 0 fe7587f76be587e41eab7ec6158c0f33d93b41e3 0 0 0 0 0  
8636 8636 20200425 GA 22695 96319   119014   4326           B 4/25/2020 11:28 2020-04-25T11:28:00Z 04/25 07:28 904 4326 2020-04-25T11:28:00Z 119014                                   13 548 11290 119014 posNeg 11838 119014 12 105 fe7015a9875434868a2d552487ce9a0845ec5ae7 0 0 0 0 0  
9942 9942 20200402 MT 227 5093   5320   20           A 4/2/2020 10:00 2020-04-02T10:00:00Z 04/02 06:00 5 20 2020-04-02T10:00:00Z 5188                                   30 19 383 5320 posNeg 402 5320 0 3 fe691f63cbaa2c10f4a9a07bdae74dbb90fb3ac4 0 0 0 0 0  
1116 1116 20200907 VT 1651 144342   145993 2           1465 B 9/6/2020 23:39 2020-09-06T23:39:00Z 09/06 19:39 58   2020-09-06T23:39:00Z       1651 58     145993                     50 3 1927 145993 posNeg 1930 145993 0 0 fe62de8863890f8bbcc98c07bbaa83cfca9f800a 0 0 0 0 0  
2853 2853 20200807 WA 64357 1124308   1188665 405 5874     50     B 8/6/2020 02:59 2020-08-06T02:59:00Z 08/05 22:59 1653 5874 2020-08-06T02:59:00Z       64357 1653   1188665                       53 659 14356 1188665 posNeg 15015 1188665 29 34 fe61d5a917eb61b690518d7fd4c3707ab94d4c9c 0 0 0 0 0  
2990 2990 20200804 MA 119203 1123073   1673078 354 11973 56   29   97595 A+ 8/4/2020 10:00 2020-08-04T10:00:00Z 08/04 06:00 8657 11973 2020-08-04T10:00:00Z 1673078 147889   111033 8436 221   1234106       98298             25 546 14878 1242276 totalTestsViral 24389 1242276 9 31 fe5ece7bd3428ef887c43696d743c4ef46912772 0 0 0 0 0  
5548 5548 20200619 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 fe53ede43c21446e227174fb121bfa4808368a82 0 0 0 0 0  
5377 5377 20200622 AK 761 90063   90824 13       1   491 A 6/22/2020 00:00 2020-06-22T00:00:00Z 06/21 20:00 12   2020-06-22T00:00:00Z 90824     761 12                           2 6 2767 90824 posNeg 2773 90824 0 0 fe4d3ece041b26790129b46b62648e06f42f2f3c 0 0 0 0 0  
9807 9807 20200404 CO 4173 17898   23611 777 823           A 4/3/2020 18:00 2020-04-03T18:00:00Z 04/03 14:00 111 823 2020-04-03T18:00:00Z             23611 22071                     8 445 1215 22071 totalTestEncountersViral 1816 22071 14 113 fe4a6d0d04d2c32d51c9912ce4f8d9a061f98ff7 0 0 0 0 0  
10648 10648 20200320 CT 194 604   798                 3/20/2020 15:30 2020-03-20T15:30:00Z 03/20 11:30 3   2020-03-20T15:30:00Z                                     9 98 0 798 posNeg 98 798 2 0 fe430da5aa23c0665713f7f2b9cf7ad3c4444050 0 0 0 0 0  
7078 7078 20200523 MA 91662 429324   671024 2237 9260 610         A 5/23/2020 10:00 2020-05-23T10:00:00Z 05/23 06:00 6304 9260 2020-05-23T10:00:00Z 671024 118092   91662 6304     520986                     25 773 8569 520986 totalTestsViral 6712 520986 76 98 fe3bb2c3151116d7133087f25fa0440af0768e09 0 0 0 0 0  
4182 4182 20200714 NY 403175 4381752   4784927 820 89995 167   101   71692 A 7/13/2020 23:59 2020-07-13T23:59:00Z 07/13 19:59 24994 89995 2020-07-13T23:59:00Z       403175     4784927                       36 912 59133 4784927 posNeg 60045 4784927 5 0 fe35ffe51d7e32292e58ee301694ea16a465756a 0 0 0 0 0  
4839 4839 20200702 MD 68423 484752   553175 441 10939 149       5013 A 7/2/2020 10:00 2020-07-02T10:00:00Z 07/02 06:00 3212 10939 2020-07-02T10:00:00Z 670249 79758   68423 3086 126   553175                     24 505 10066 553175 posNeg 10571 553175 7 37 fe354bad6447df94e024242f4b5eed89676a4b71 0 0 0 0 0  
8411 8411 20200429 FL 33193 340295 1252 373488   5624           C 4/29/2020 09:51 2020-04-29T09:51:00Z 04/29 05:51 1240 5624 2020-04-29T09:51:00Z       33193                             12 347 6266 374740 posNeg 6613 373488 86 358 fe2d21fd2b5909bf6fa02931ad630f614cf7e7e2 0 0 0 0 0  
11479 11479 20200229 NJ       0                       0               0                         34 0 0 0 posNeg 0 0 0 0 fe2cc9ac6d33a316fa56c5ec5e74f8914e72185f 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  
3678 3678 20200723 NY 409697 4958641   5368338 706 89995 160   93   72466 A 7/22/2020 23:59 2020-07-22T23:59:00Z 07/22 19:59 25081 89995 2020-07-22T23:59:00Z       409697     5368338                       36 811 68887 5368338 posNeg 69698 5368338 13 0 fe2940d509adb667677ce29530b3855cdbf9cfc7 0 0 0 0 0  
3041 3041 20200803 IL 184522 2623556   2808078 1418   347   132     A 8/3/2020 00:00 2020-08-03T00:00:00Z 08/02 20:00 7723   2020-08-03T00:00:00Z 2806797     183241 7526 197                         17 1298 27177 2808078 posNeg 28475 2808078 9 0 fe2727a025e2ffb26ced66331bed72c30a41b89c 0 0 0 0 0  
10878 10878 20200316 HI 7     7                 3/16/2020 15:39 2020-03-16T15:39:00Z 03/16 11:39     2020-03-16T15:39:00Z                                     15 5 0 7 posNeg 5 7 0 0 fe247926163e19c6b5dcb3137e6fb2e5f534a19f 0 0 0 0 0  
6610 6610 20200531 AL 17903 199650   221307 527 1844   589   355 9355 B 5/31/2020 00:00 2020-05-31T00:00:00Z 05/30 20:00 631 1844 2020-05-31T00:00:00Z 221307     17614 629 2                         1 544 4808 217553 posNeg 9106 217553 13 18 fe22ff26ae268384d56f3903477d1d86e6a7afac 0 0 0 0 0  
3452 3452 20200727 NM 19042 501676   520718 144 2560         7349 B 7/26/2020 17:30 2020-07-26T17:30:00Z 07/26 13:30 614 2560 2020-07-26T17:30:00Z 520718     19042                             35 254 8039 520718 posNeg 8293 520718 7 18 fe0de6de009793bdb182755b9e2477a489f02aa0 0 0 0 0 0  
10022 10022 20200401 WI 1821 18819   20640   398           A 4/1/2020 16:00 2020-04-01T16:00:00Z 04/01 12:00 24 398 2020-04-01T16:00:00Z       1550                             55 236 1444 20640 posNeg 1680 20640 8 61 fe032233d24b53515c5d810d28b52783684f7eb6 0 0 0 0 0  
10559 10559 20200322 NC 255 6183   6438                 3/22/2020 10:16 2020-03-22T10:16:00Z 03/22 06:16 0   2020-03-22T10:16:00Z                                     37 71 1091 6438 posNeg 1162 6438 0 0 fe027787d4d6f31cbca7321be5d0c731ef8979b6 0 0 0 0 0  
8174 8174 20200504 WI 9538 80467 226 90005 348 1621 116 404     3973 A 5/4/2020 00:00 2020-05-04T00:00:00Z 05/03 20:00 340 1621 2020-05-04T00:00:00Z       8236 340                           55 311 2470 90231 posNeg 2781 90005 1 13 fdfedcd9a1a4c725a7fdcfb3726dfa62fd1a704d 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
);