states_daily_4pm_et

Table actions

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

11,578 rows sorted by totalTestEncountersViral 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
7959 7959 20200507 CO 17830 73517   99827 798 2986         2869 B 5/5/2020 00:00 2020-05-05T00:00:00Z 05/04 20:00 921 2986 2020-05-05T00:00:00Z       16012     99827 89529                     8 466 4905 91347 totalTestEncountersViral 3161 91347 18 67 6190c1ca7eebd8f20bc92b7e47b7ece3593d5b91 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  
1519 1519 20200830 CO 57041 648168   994951 239 6993         5933 A+ 8/29/2020 01:59 2020-08-29T01:59:00Z 08/28 21:59 1843 6993 2020-08-29T01:59:00Z       53209     994951 701377 157120 10882 146238               8 268 5557 705209 totalTestEncountersViral 9329 705209 0 48 e5ac0280a617a0532af59c8d147ff863f73b6545 0 0 0 0 0  
7772 7772 20200511 RI 11788 69365   99373 276 1280 73   52   841 A+ 5/11/2020 03:00 2020-05-11T03:00:00Z 05/10 23:00 430 1280 2020-05-11T03:00:00Z 101331 14067 87264 11788     99373 81153                     44 175 1259 81153 totalTestEncountersViral 2397 81153 8 29 99b424ec583b2e8b649dd1a27d7b8fc307b9b5cf 0 0 0 0 0  
3330 3330 20200729 MN 52947 940144   993091 310 5077 143 1484     46636 A 7/28/2020 17:00 2020-07-28T17:00:00Z 07/28 13:00 1629 5077 2020-07-28T17:00:00Z       52947 1589 40 993091                       27 666 12437 993091 posNeg 13103 993091 9 49 f42dc60861fc17b2e1567e32737e005449a80d4d 0 0 0 0 0  
374 374 20200920 NY 449900 9472546   9922446 468 89995 132   60   76179 A 9/19/2020 23:59 2020-09-19T23:59:00Z 09/19 19:59 25427 89995 2020-09-19T23:59:00Z       449900     9922446                       36 862 99493 9922446 posNeg 100355 9922446 2 0 b9792dc99d6549db085101b4cec82e1ef562405f 0 0 0 0 0  
6472 6472 20200603 ND 2678 71823   99073 34 172         2169 C 6/3/2020 00:00 2020-06-03T00:00:00Z 06/02 20:00 54 172 2020-06-03T00:00:00Z 101258     2678 51 3 99073 72294 2921 97 2824               38 33 825 74501 totalTestEncountersViral 2568 74501 0 2 e1259e0d30decd60cbdcb1b82bd1faed600561d6 0 0 0 0 0  
10578 10578 20200322 VA 219 3118   9895   32             3/21/2020 17:00 2020-03-21T17:00:00Z 03/21 13:00 3 32 2020-03-21T17:00:00Z   2375         9895                       51 67 480 3337 posNeg 907 3337 1 7 83da8136e6139224695c83503fb2021179b408a3 0 0 0 0 0  
8562 8562 20200427 VA 13535 67144 542 98928 1455 3298 389   217   1843 B 4/27/2020 00:00 2020-04-27T00:00:00Z 04/26 20:00 458 3298 2020-04-27T00:00:00Z   17974   13036 454 4 98928                       51 565 3514 81221 posNeg 3742 80679 10 1284 10dc1a9eb527f992ad449d4649793c250d9b5350 0 0 0 0 0  
3693 3693 20200723 WA 54177 934358   988535 385 5211     55     B 7/22/2020 02:59 2020-07-22T02:59:00Z 07/21 22:59 1468 5211 2020-07-22T02:59:00Z       54177 1468   988535 855152                     53 871 13582 988535 posNeg 14453 988535 3 50 c55f60b07012c451f8964d10e2a807e26501e130 0 0 0 0 0  
3634 3634 20200724 VA 82364 907935 451 987188 1250 11826 274   142   10576 A+ 7/23/2020 17:00 2020-07-23T17:00:00Z 07/23 13:00 2067 11826 2020-07-23T17:00:00Z   98175   79253 1964 103 987188                       51 1127 16972 990750 posNeg 18043 990299 13 129 d8071a3699779310ee2e5c982b3f2e23d2b9c382 0 0 0 0 0  
1575 1575 20200829 CO 56773 642611   985622 225 6945         5921 A+ 8/28/2020 01:59 2020-08-28T01:59:00Z 08/27 21:59 1843 6945 2020-08-28T01:59:00Z       52958     985622 695569 156499 10834 145665               8 430 7643 699384 totalTestEncountersViral 12632 699384 8 17 77d202ba63f72195e772d3aa76037d4e12deaf0f 0 0 0 0 0  
9965 9965 20200402 WA 7796 90749   98545               A 4/2/2020 00:00 2020-04-02T00:00:00Z 04/01 20:00 310   2020-04-02T00:00:00Z       7796     98545 95017                     53 397 4774 98545 posNeg 5171 98545 28 0 b7d4cce613edde1c99f15ccf4bc10558ce0cf307 0 0 0 0 0  
430 430 20200919 NY 449038 9373053   9822091 467 89995 144   60   76101 A 9/18/2020 23:59 2020-09-18T23:59:00Z 09/18 19:59 25425 89995 2020-09-18T23:59:00Z       449038     9822091                       36 986 109458 9822091 posNeg 110444 9822091 2 0 6428fa42a0444dfe549a7a14c8e0e10ffbb91404 0 0 0 0 0  
3386 3386 20200728 MN 52281 927707   979988 294 5028 138 1474     45987 A 7/27/2020 17:00 2020-07-27T17:00:00Z 07/27 13:00 1620 5028 2020-07-27T17:00:00Z       52281 1580 40 979988                       27 478 8784 979988 posNeg 9262 979988 4 67 4f8c5d37266d3bbe2e9babc9b18f3c5692f34fef 0 0 0 0 0  
3749 3749 20200722 WA 53306 920776   974082 392 5161     51     B 7/21/2020 02:59 2020-07-21T02:59:00Z 07/20 22:59 1465 5161 2020-07-21T02:59:00Z       53306 1465   974082 841184                     53 1016 14751 974082 posNeg 15767 974082 12 59 142654f6b354c6b3e8eda6d6c9366cf41ef278bd 0 0 0 0 0  
1631 1631 20200828 CO 56343 634968   972990 213 6928         5907 A 8/27/2020 01:59 2020-08-27T01:59:00Z 08/26 21:59 1835 6928 2020-08-27T01:59:00Z       52562     972990 687530 155517 10757 144760               8 350 4858 691311 totalTestEncountersViral 10236 691311 0 26 d42fbbb94da073687ca2fa8883121b1c73020c12 0 0 0 0 0  
4937 4937 20200630 DC 10327 86968   97295 126   33   22   1270 A+ 6/29/2020 00:00 2020-06-29T00:00:00Z 06/28 20:00 551   2020-06-29T00:00:00Z             97295 76112                     11 35 1900 97295 posNeg 1935 97295 0 0 e5ab05f9693bf73313b327129ca7ddc456900138 0 0 0 0 0  
486 486 20200918 NY 448052 9263595   9711647 478 89995 141   62   76036 A 9/17/2020 23:59 2020-09-17T23:59:00Z 09/17 19:59 25423 89995 2020-09-17T23:59:00Z       448052     9711647                       36 790 88937 9711647 posNeg 89727 9711647 10 0 484099c5cadb392fbd9a1cdd91d0dfbb3d880cf9 0 0 0 0 0  
3442 3442 20200727 MN 51803 918923   970726 257 4961 126 1458     45198 A 7/26/2020 17:00 2020-07-26T17:00:00Z 07/26 13:00 1616 4961 2020-07-26T17:00:00Z       51803 1576 40 970726                       27 650 12702 970726 posNeg 13352 970726 2 41 a7a1badc7b874996021d8bf8767f51af18833b95 0 0 0 0 0  
7828 7828 20200510 RI 11613 68106   96976 283 1251 70   52   809 A+ 5/10/2020 03:00 2020-05-10T03:00:00Z 05/09 23:00 422 1251 2020-05-10T03:00:00Z 99293 13826 85467 11613     96976 79719                     44 186 1502 79719 totalTestEncountersViral 3800 79719 4 33 5d91ffef9526b1b918d88f34cfd75bc14c35e19e 0 0 0 0 0  
3690 3690 20200723 VA 81237 890963 417 969145 1218 11697 257   136   10479 A+ 7/22/2020 17:00 2020-07-22T17:00:00Z 07/22 13:00 2054 11697 2020-07-22T17:00:00Z   96887   78182 1951 103 969145                       51 844 17169 972617 posNeg 17971 972200 3 209 a063762f955854840bc164f2be78268bf470ab63 0 0 0 0 0  
8146 8146 20200504 MN 10235 86677   96912 396 1271 166 444     3784 A 5/4/2020 00:00 2020-05-04T00:00:00Z 05/03 20:00 428 1271 2020-05-04T00:00:00Z       10235 428   96912                       27 824 3244 96912 posNeg 4068 96912 9 72 e027b42edec1a1eaa56d9c1f3b18e9384dc5d3c0 0 0 0 0 0  
8015 8015 20200506 CO 17364 68612   96666 792 2919         2801 B 5/5/2020 00:00 2020-05-05T00:00:00Z 05/04 20:00 903 2919 2020-05-05T00:00:00Z       15600     96666 85976                     8 457 515 85976 totalTestEncountersViral 3010 85976 52 81 a640e380163f3a73be01f433002575988e71af65 0 0 0 0 0  
6528 6528 20200602 ND 2645 70998   96505 34 170         2127 C 6/2/2020 00:00 2020-06-02T00:00:00Z 06/01 20:00 54 170 2020-06-02T00:00:00Z 98637     2645 51 3 96505 71365 2842 95 2747               38 22 322 73643 totalTestEncountersViral 1538 73643 4 1 24b4cc8b48ee531122cb0e7e5484f38ec4e8eaf9 0 0 0 0 0  
1687 1687 20200827 CO 55993 630110   962754 253 6902         5881 A 8/26/2020 01:59 2020-08-26T01:59:00Z 08/25 21:59 1835 6902 2020-08-26T01:59:00Z       52228     962754 682339 154903 10697 144206               8 193 3849 686103 totalTestEncountersViral 7113 686103 9 8 807f778fba9150d75a45305ea475a914c77d6444 0 0 0 0 0  
542 542 20200917 NY 447262 9174658   9621920 486 89995 135   68   75962 A 9/16/2020 23:59 2020-09-16T23:59:00Z 09/16 19:59 25413 89995 2020-09-16T23:59:00Z       447262     9621920                       36 896 90608 9621920 posNeg 91504 9621920 3 0 5e44bc2c7424a256603012991c84a330c2f41244 0 0 0 0 0  
10896 10896 20200316 ND 1 123 0 96                 3/16/2020 15:45 2020-03-16T15:45:00Z 03/16 11:45 0   2020-03-16T15:45:00Z 109     1     96 93                     38 0 28 124 totalTestEncountersViral 22 124 0 0 76b281300638f0a0a4191ef65be40784ea384fc4 0 0 0 0 0  
3805 3805 20200721 WA 52290 906025   958315 365 5102     43     B 7/20/2020 02:59 2020-07-20T02:59:00Z 07/19 22:59 1453 5102 2020-07-20T02:59:00Z       52290 1453   958315 826354                     53 1084 15973 958315 posNeg 17057 958315 6 39 71e476903b2273f8949c074904baf417d4f226d1 0 0 0 0 0  
3498 3498 20200726 MN 51153 906221   957374 273 4920 115 1448     44431 A 7/25/2020 17:00 2020-07-25T17:00:00Z 07/25 13:00 1614 4920 2020-07-25T17:00:00Z       51153 1574 40 957374                       27 862 15816 957374 posNeg 16678 957374 3 31 c245d2fa7b04cc5f3565c3872bc12d18114001ad 0 0 0 0 0  
1743 1743 20200826 CO 55800 626261   955641 243 6894         5867 A 8/25/2020 01:59 2020-08-25T01:59:00Z 08/24 21:59 1826 6894 2020-08-25T01:59:00Z       52074     955641 678335 154497 10671 143826               8 459 31404 682061 totalTestEncountersViral 7996 682061 2 49 baca648956c04f8b1c7003ba3d756f41afe24fd0 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  
598 598 20200916 NY 446366 9084050   9530416 483 89995 138   67   75903 A 9/15/2020 23:59 2020-09-15T23:59:00Z 09/15 19:59 25410 89995 2020-09-15T23:59:00Z       446366     9530416                       36 652 74435 9530416 posNeg 75087 9530416 5 0 247d677a0fea26706b310e8053dd5198afd55927 0 0 0 0 0  
8618 8618 20200426 VA 12970 63630 539 95186 1436 2014 387   217   1815 B 4/26/2020 00:00 2020-04-26T00:00:00Z 04/25 20:00 448 2014 2020-04-26T00:00:00Z   17180   12488 444 4 95186                       51 604 3354 77139 posNeg 4061 76600 12 72 84bbcd7e2b6c29d38c08d8caad20154f795522be 0 0 0 0 0  
3746 3746 20200722 VA 80393 873794 385 951174 1157 11488 253   136   10331 A+ 7/21/2020 17:00 2020-07-21T17:00:00Z 07/21 13:00 2051 11488 2020-07-21T17:00:00Z   94379   77380 1948 103 951174                       51 1022 13073 954572 posNeg 14026 954187 3 64 5302163d1d242d265c70243f5ef2620cfbf456e9 0 0 0 0 0  
10928 10928 20200315 DC 16 79 20 95                 3/14/2020 19:30 2020-03-14T19:30:00Z 03/14 15:30     2020-03-14T19:30:00Z             95                       11 6 30 115 posNeg 36 95 0 0 d7cd2f4a7de509734a09d8d47ed72d36130b6090 0 0 0 0 0  
6584 6584 20200601 ND 2623 70676   94967 35 169         2078 C 6/1/2020 13:00 2020-06-01T13:00:00Z 06/01 09:00 50 169 2020-06-01T13:00:00Z 97028     2623 47 3 94967 70849 2772 91 2681               38 47 1213 73299 totalTestEncountersViral 2308 73299 2 2 829594fd492872edb1b2c5e60581b11dc669134b 0 0 0 0 0  
1799 1799 20200825 CO 55341 594857   947645 243 6845         5841 A 8/24/2020 01:59 2020-08-24T01:59:00Z 08/23 21:59 1824 6845 2020-08-24T01:59:00Z       51676     947645 673913 154075 10639 143436               8 198 0 650198 totalTestEncountersViral 9049 650198 9 4 c25d9a93e3b1b03b5e83b75d55ad152570db376c 0 0 0 0 0  
654 654 20200915 NY 445714 9009615   9455329 481 89995 144   60   75847 A 9/14/2020 23:59 2020-09-14T23:59:00Z 09/14 19:59 25405 89995 2020-09-14T23:59:00Z       445714     9455329                       36 766 72912 9455329 posNeg 73678 9455329 11 0 dff1d805592ccd3c7f86828c445b52061d34bd97 0 0 0 0 0  
3861 3861 20200720 WA 51206 890052   941258 354 5063     42     B 7/19/2020 02:59 2020-07-19T02:59:00Z 07/18 22:59 1447 5063 2020-07-19T02:59:00Z       51206 1447   941258 809339                     53 990 16737 941258 posNeg 17727 941258 3 30 998e2ee5c1fd0aff52f08b58d37978501d4799e3 0 0 0 0 0  
3554 3554 20200725 MN 50291 890405   940696 287 4889 115 1440     43625 A 7/24/2020 17:00 2020-07-24T17:00:00Z 07/24 13:00 1611 4889 2020-07-24T17:00:00Z       50291 1571 40 940696                       27 803 17017 940696 posNeg 17820 940696 5 37 0e9acde367fdb73988d494fa5f9e4c90596486f4 0 0 0 0 0  
9496 9496 20200410 ND 278 9330   9401 13 36         105 B 4/10/2020 13:00 2020-04-10T13:00:00Z 04/10 09:00 6 36 2020-04-10T13:00:00Z 9478     278     9401 8956                     38 9 609 9608 totalTestEncountersViral 427 9608 1 2 927256df09e2d5483818c1eaefa0f19e0030ebb5 0 0 0 0 0  
1855 1855 20200824 CO 55143 594857   938596 225 6841         5823 A 8/23/2020 01:59 2020-08-23T01:59:00Z 08/22 21:59 1815 6841 2020-08-23T01:59:00Z       51505     938596 668994 153659 10612 143047               8 260 0 650000 totalTestEncountersViral 8444 650000 0 10 2aa9117da60673fe8bd8fe2c706779f426a741fc 0 0 0 0 0  
710 710 20200914 NY 444948 8936703   9381651 464 89995 143   59   75814 A 9/13/2020 23:59 2020-09-13T23:59:00Z 09/13 19:59 25394 89995 2020-09-13T23:59:00Z       444948     9381651                       36 583 62775 9381651 posNeg 63358 9381651 4 0 6a2fb762bc87056f5df959d1f8988e03ed4f2e95 0 0 0 0 0  
3802 3802 20200721 VA 79371 860721 427 937148 1189 11424 258   127   10235 A+ 7/20/2020 17:00 2020-07-20T17:00:00Z 07/20 13:00 2048 11424 2020-07-20T17:00:00Z   94379   76427 1945 103 937148                       51 996 18635 940519 posNeg 19647 940092 17 159 e796b9161ac1541e4d8fd6d110862166fb4e1431 0 0 0 0 0  
10995 10995 20200314 MN 90 847   937                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00     2020-03-14T00:00:00Z       90     937                       27 28 306 937 posNeg 334 937 0 0 c02746e369dbb613d6847e6e5525b6ef9c62b151 0 0 0 0 0  
8071 8071 20200505 CO 16907 68097   93656 834 2838         2743 B 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 851 2838 2020-05-03T00:00:00Z       15169     93656 83266                     8 272 1642 85004 totalTestEncountersViral 2232 85004 9 39 8d6f6f7d2e3dd7709377b61c9c5d8c66d8b33720 0 0 0 0 0  
9473 9473 20200410 DC 1660 7695   9355             426 A 4/10/2020 10:00 2020-04-10T10:00:00Z 04/10 06:00 38   2020-04-10T10:00:00Z             9355                       11 137 494 9355 posNeg 631 9355 6 0 0d5ee8165d4d4b4241c7d21afc4ea97a1e655ea3 0 0 0 0 0  
10021 10021 20200401 WA 7399 85975   93374               A 4/1/2020 00:00 2020-04-01T00:00:00Z 03/31 20:00 282   2020-04-01T00:00:00Z       7399     93374 90110                     53 450 4512 93374 posNeg 4962 93374 20 0 557d92ac9d0b5b7d3693a33ef5fe284cfd540699 0 0 0 0 0  
766 766 20200913 NY 444365 8873928   9318293 464 89995 131   54   75767 A 9/12/2020 23:59 2020-09-12T23:59:00Z 09/12 19:59 25390 89995 2020-09-12T23:59:00Z       444365     9318293                       36 725 71943 9318293 posNeg 72668 9318293 6 0 610a4052d28f86b5f307476f7ee7dfe297d0d413 0 0 0 0 0  
7884 7884 20200509 RI 11427 66604   93176 292 1218 77   56   772 A+ 5/9/2020 03:00 2020-05-09T03:00:00Z 05/08 23:00 418 1218 2020-05-09T03:00:00Z 96926 13549 83377 11427     93176 78031                     44 286 2266 78031 totalTestEncountersViral 2957 78031 19 31 bed1daa2bab1b57e2b550c008c3f22a03bb9245e 0 0 0 0 0  
5049 5049 20200628 DC 10248 82884   93132 126   34   27   1199 A+ 6/27/2020 00:00 2020-06-27T00:00:00Z 06/26 20:00 550   2020-06-27T00:00:00Z             93132 72783                     11 32 3829 93132 posNeg 3861 93132 2 0 2f070e45d0f8096b82523307e8eb477cfe41febf 0 0 0 0 0  
1911 1911 20200823 CO 54883 594857   930152 258 6831         5804 A 8/22/2020 01:59 2020-08-22T01:59:00Z 08/21 21:59 1815 6831 2020-08-22T01:59:00Z       51258     930152 663781 153148 10575 142573               8 297 0 649740 totalTestEncountersViral 11226 649740 0 23 a8e1b7ff95369b44fe35a5306e5ec55b570b205a 0 0 0 0 0  
8202 8202 20200503 MN 9411 83433   92844 373 1199 155 426     2596 A 5/2/2020 17:00 2020-05-02T17:00:00Z 05/02 13:00 419 1199 2020-05-02T17:00:00Z       9411 419   92844                       27 340 2824 92844 posNeg 3164 92844 24 40 9b54e156822dad7e51f4f6e104871653d759ec63 0 0 0 0 0  
6640 6640 20200531 ND 2576 69463   92659 36 167         1959 C 5/31/2020 00:00 2020-05-31T00:00:00Z 05/30 20:00 48 167 2020-05-31T00:00:00Z 94652     2576 45 3 92659 69719 2688 89 2599               38 23 1036 72039 totalTestEncountersViral 2032 72039 0 2 d85d2107850d9e76702001e205dbeb52c0291e1d 0 0 0 0 0  
822 822 20200912 NY 443640 8801985   9245625 467 89995 127   51   75707 A 9/11/2020 23:59 2020-09-11T23:59:00Z 09/11 19:59 25384 89995 2020-09-11T23:59:00Z       443640     9245625                       36 849 102076 9245625 posNeg 102925 9245625 2 0 0cf0f61afa5b762948ea7155234f87dd4687c02d 0 0 0 0 0  
3917 3917 20200719 WA 50216 873315   923531 364 5033     62     B 7/18/2020 02:59 2020-07-18T02:59:00Z 07/17 22:59 1444 5033 2020-07-18T02:59:00Z       50216 1444   923531 791786                     53 334 4877 923531 posNeg 5211 923531 10 49 78a02678ad12a6d6da60368810e2dff4da9d79de 0 0 0 0 0  
3610 3610 20200724 MN 49488 873388   922876 278 4852 108 1437     42882 A 7/23/2020 17:00 2020-07-23T17:00:00Z 07/23 13:00 1606 4852 2020-07-23T17:00:00Z       49488 1566 40 922876                       27 767 16794 922876 posNeg 17561 922876 5 34 b7c2888ef3fbbd8c34e6e3828e7a8184a3b66d45 0 0 0 0 0  
1967 1967 20200822 CO 54586 594857   918926 236 6808         5791 A 8/21/2020 01:59 2020-08-21T01:59:00Z 08/20 21:59 1815 6808 2020-08-21T01:59:00Z       50967     918926 657852 152413 10514 141899               8 356 0 649443 totalTestEncountersViral 12233 649443 0 11 d3ed50e06dd7d49de759ebdc3ed86fe26edd9a92 0 0 0 0 0  
3973 3973 20200718 WA 49882 868438   918320 348 4984     46     B 7/17/2020 02:59 2020-07-17T02:59:00Z 07/16 22:59 1434 4984 2020-07-17T02:59:00Z       49882 1434   918320 767657                     53 524 9163 918320 posNeg 9687 918320 7 40 545b9a770bb3fc73bf89388fccc6ab21be1377ed 0 0 0 0 0  
3858 3858 20200720 VA 78375 842086 415 917501 1158 11265 265   125   10107 A+ 7/19/2020 17:00 2020-07-19T17:00:00Z 07/19 13:00 2031 11265 2020-07-19T17:00:00Z   93228   75415 1927 104 917501                       51 945 12153 920876 posNeg 7498 920461 4 62 e892b0bc7b4b3fbbf275d8bf43f4d263923443a5 0 0 0 0 0  
878 878 20200911 NY 442791 8699909   9142700 474 89995 120   54   75649 A 9/10/2020 23:59 2020-09-10T23:59:00Z 09/10 19:59 25382 89995 2020-09-10T23:59:00Z       442791     9142700                       36 880 88842 9142700 posNeg 89722 9142700 5 0 63317d552d6e6d7a3c8b5ad3d31be983619285c7 0 0 0 0 0  
8127 8127 20200504 CO 16635 66455   91424 883 2799         2650 B 5/3/2020 18:00 2020-05-03T18:00:00Z 05/03 14:00 842 2799 2020-05-03T18:00:00Z       14897     91424 81352                     8 410 2774 83090 totalTestEncountersViral 3582 83090 10 6 814d4db30f1c487c3f9a1ee854d7d73ed0cdfc7a 0 0 0 0 0  
8674 8674 20200425 VA 12366 60276 1405 91125 1405 1942 357   223   1717 B 4/25/2020 00:00 2020-04-25T00:00:00Z 04/24 20:00 436 1942 2020-04-25T00:00:00Z   16409   11902 432 4 91125                       51 772 2430 74047 posNeg 3529 72642 26 105 a461e2112598ae123c9d171aa20f1473d7851f47 0 0 0 0 0  
3914 3914 20200719 VA 77430 829933 453 910003 1186 11203 249   127   10017 A+ 7/18/2020 17:00 2020-07-18T17:00:00Z 07/18 13:00 2027 11203 2020-07-18T17:00:00Z   92712   74490 1923 104 910003                       51 1057 16605 907816 posNeg 12739 907363 2 61 cb579cc22766c8213d050dd1bf636c92ab58cc42 0 0 0 0 0  
4029 4029 20200717 WA 49358 859275   908633 379 4944     45     B 7/16/2020 02:59 2020-07-16T02:59:00Z 07/15 22:59 1427 4944 2020-07-16T02:59:00Z       49358 1427   908633 753174                     53 878 15519 908633 posNeg 16397 908633 6 115 5ad0bdb94454c60f5797cc4f29d724a434bb6743 0 0 0 0 0  
10311 10311 20200326 CO 1086 6978   9078 230 148           A 3/25/2020 18:00 2020-03-25T18:00:00Z 03/25 14:00 19 148 2020-03-25T18:00:00Z             9078 8064                     8 174 189 8064 totalTestEncountersViral 1134 8064 8 64 e081e65a375ac6f8910b303e8792faff63b89b25 0 0 0 0 0  
2023 2023 20200821 CO 54230 594857   906693 238 6797         5759 A 8/20/2020 01:59 2020-08-20T01:59:00Z 08/19 21:59 1815 6797 2020-08-20T01:59:00Z       50627     906693 651250 151642 10454 141188               8 329 0 649087 totalTestEncountersViral 11486 649087 15 13 176f6e51d688672d78a5409d5925aecf0148f3e7 0 0 0 0 0  
6696 6696 20200530 ND 2553 68427   90627 34 165         1943 C 5/30/2020 15:11 2020-05-30T15:11:00Z 05/30 11:11 48 165 2020-05-30T15:11:00Z 92568     2553 45 3 90627 68749                     38 34 1494 70980 totalTestEncountersViral 2956 70980 0 1 ee4b7552d094b144b43d9c79d62d4471ef84b469 0 0 0 0 0  
3666 3666 20200723 MN 48721 856594   905315 282 4818 107 1431     42524 A 7/22/2020 17:00 2020-07-22T17:00:00Z 07/22 13:00 1601 4818 2020-07-22T17:00:00Z       48721 1561 40 905315                       27 760 16004 905315 posNeg 16764 905315 9 47 5d236c942b7a419f66aefeec856f4cfd43e0aef7 0 0 0 0 0  
934 934 20200910 NY 441911 8611067   9052978 482 89995 120   55   75584 A 9/9/2020 23:59 2020-09-09T23:59:00Z 09/09 19:59 25377 89995 2020-09-09T23:59:00Z       441911     9052978                       36 757 76056 9052978 posNeg 76813 9052978 7 0 50388c162469103edd8aa989376183428edf4d5a 0 0 0 0 0  
7940 7940 20200508 RI 11141 64338   90219 312 1187 71   52   730 A+ 5/8/2020 03:00 2020-05-08T03:00:00Z 05/07 23:00 399 1187 2020-05-08T03:00:00Z 93190 13103 80087 11141     90219 75479                     44 231 1691 75479 totalTestEncountersViral 3394 75479 11 34 3256d5d05e70cf6dc17006c549262ca0a407a27e 0 0 0 0 0  
11153 11153 20200311 ND 0 7 6 9                             14     0     9 8                     38 0 1 13 totalTestEncountersViral 2 7 0 0 d0da2fae56a4d7ddf7bc53ba412868e78cae171d 0 0 0 0 0  
10634 10634 20200321 VA 152 2638   8988   25             3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00 2 25 2020-03-21T00:00:00Z   2302         8988                       51 38 427 2790 posNeg 595 2790 0 25 3efd33beb0052ea88aa9456a69f456cb3e80a0ff 0 0 0 0 0  
990 990 20200909 NY 441154 8535011   8976165 463 89995 121   59   75539 A 9/8/2020 23:59 2020-09-08T23:59:00Z 09/08 19:59 25370 89995 2020-09-08T23:59:00Z       441154     8976165                       36 576 62654 8976165 posNeg 63230 8976165 3 0 55a83ddf98544f94f43247f3f2b867ddc267d31b 0 0 0 0 0  
9552 9552 20200409 ND 269 8721   8974 14 34         101 B 4/9/2020 13:00 2020-04-09T13:00:00Z 04/09 09:00 5 34 2020-04-09T13:00:00Z 9046     269     8974 8557                     38 18 420 8990 totalTestEncountersViral 543 8990 1 0 0f61f19f5e1977311f0c4a79bb830317271eb43e 0 0 0 0 0  
3970 3970 20200718 VA 76373 813328 421 897264 1166 11142 254   108   9976 A+ 7/17/2020 17:00 2020-07-17T17:00:00Z 07/17 13:00 2025 11142 2020-07-17T17:00:00Z   91652   73420 1921 104 897264                       51 940 12057 890122 posNeg 16938 889701 12 88 2e3cb58d3b34d7eb949f286aef1fd005f5912d2f 0 0 0 0 0  
8258 8258 20200502 MN 9071 80609   89680 389 1159 135 404     2002 A 5/1/2020 17:00 2020-05-01T17:00:00Z 05/01 13:00 395 1159 2020-05-01T17:00:00Z       9071     89680                       27 335 3395 89680 posNeg 3730 89680 24 63 c01b0d67304845e28247b2305d22dba040b1862d 0 0 0 0 0  
2079 2079 20200820 CO 53901 594857   895207 238 6784         5759 A 8/19/2020 01:59 2020-08-19T01:59:00Z 08/18 21:59 1800 6784 2020-08-19T01:59:00Z       50313     895207 645170 150931 10406 140525               8 270 4657 648758 totalTestEncountersViral 7348 648758 12 3 ea586ffed9dc3cb217a40114e55923a9663f559a 0 0 0 0 0  
5105 5105 20200627 DC 10216 79055   89271 136   43   26   1194 A+ 6/26/2020 00:00 2020-06-26T00:00:00Z 06/25 20:00 548   2020-06-26T00:00:00Z             89271 69699                     11 31 1117 89271 posNeg 1148 89271 2 0 27627b871fec96871754c72dc64f75a062eebbf3 0 0 0 0 0  
4085 4085 20200716 WA 48480 843756   892236 372 4829     53     B 7/15/2020 02:59 2020-07-15T02:59:00Z 07/14 22:59 1421 4829 2020-07-15T02:59:00Z       48480 1421   892236 733886                     53 825 14586 892236 posNeg 15411 892236 17 41 83388ac0abe8de1b3f4d39155f6095d524215f54 0 0 0 0 0  
1046 1046 20200908 NY 440578 8472357   8912935 445 89995 114   52   75503 A 9/7/2020 23:59 2020-09-07T23:59:00Z 09/07 19:59 25367 89995 2020-09-07T23:59:00Z       440578     8912935                       36 557 57269 8912935 posNeg 57826 8912935 6 0 ddf12ebad36c51d7af4583850933a3651b9c84de 0 0 0 0 0  
11215 11215 20200310 RI 5 105 6 89                 3/10/2020 03:00 2020-03-10T03:00:00Z 03/09 23:00     2020-03-10T03:00:00Z 116 6 110 5     89 110                     44 1 23 116 totalTestEncountersViral 16 110 0 0 36f0410528af0ac3a9c2dc41a5354ca7bc9e670b 0 0 0 0 0  
3722 3722 20200722 MN 47961 840590   888551 273 4771 119 1423     42234 A 7/21/2020 17:00 2020-07-21T17:00:00Z 07/21 13:00 1592 4771 2020-07-21T17:00:00Z       47961 1552 40 888551                       27 504 11188 888551 posNeg 11692 888551 4 48 1625551874cb278cb04e7c2219517045409c85b1 0 0 0 0 0  
2135 2135 20200819 CO 53631 590200   887859 262 6781         5729 A 8/18/2020 01:59 2020-08-18T01:59:00Z 08/17 21:59 1788 6781 2020-08-18T01:59:00Z       50050     887859 640250 150520 10372 140148               8 261 3920 643831 totalTestEncountersViral 6607 643831 10 42 3f9692fb0902fc39c84d0ce6bf776ee4b7d6eec3 0 0 0 0 0  
1102 1102 20200907 NY 440021 8415088   8855109 413 89995 115   57   75471 A 9/6/2020 23:59 2020-09-06T23:59:00Z 09/06 19:59 25361 89995 2020-09-06T23:59:00Z       440021     8855109                       36 520 58345 8855109 posNeg 58865 8855109 2 0 7e62930bca20ae62a1151493d16c77b25b554aca 0 0 0 0 0  
10077 10077 20200331 WA 6949 81463   88412               A 3/31/2020 00:00 2020-03-31T00:00:00Z 03/30 20:00 262   2020-03-31T00:00:00Z       6949     88412 85393                     53 465 4416 88412 posNeg 4881 88412 14 0 820a21f5bb12f9f8db4d8de0f3c79ca107e0f2a0 0 0 0 0 0  
2191 2191 20200818 CO 53370 586280   881252 245 6739         5712 A 8/17/2020 01:59 2020-08-17T01:59:00Z 08/16 21:59 1778 6739 2020-08-17T01:59:00Z       49801     881252 636081 150080 10349 139731               8 194 4883 639650 totalTestEncountersViral 8201 639650 10 4 adc9957cbc7a74b6ee1547af7291bd029471a05f 0 0 0 0 0  
5161 5161 20200626 DC 10185 77938   88123 147   48   29   1186 A+ 6/25/2020 00:00 2020-06-25T00:00:00Z 06/24 20:00 546   2020-06-25T00:00:00Z             88123 68668                     11 26 1366 88123 posNeg 1392 88123 3 0 b7dd5792178c5b68b64c76d496a7de270e568617 0 0 0 0 0  
4026 4026 20200717 VA 75433 801271 470 880326 1171 11054 247   118   9883 A+ 7/16/2020 17:00 2020-07-16T17:00:00Z 07/16 13:00 2013 11054 2020-07-16T17:00:00Z   90256   72516 1909 104 880326                       51 1002 14529 877174 posNeg 12395 876704 6 276 1265577f6edf06bc84b77180cd3f984e0136db55 0 0 0 0 0  
1158 1158 20200906 NY 439501 8356743   8796244 410 89995 119   56   75425 A 9/5/2020 23:59 2020-09-05T23:59:00Z 09/05 19:59 25359 89995 2020-09-05T23:59:00Z       439501     8796244                       36 729 84901 8796244 posNeg 85630 8796244 9 0 3bf75f818e8b5651e2001768273bbdbdd9cb4b80 0 0 0 0 0  
8183 8183 20200503 CO 16225 63681   87842 883 2793         2607 B 5/1/2020 00:00 2020-05-01T00:00:00Z 04/30 20:00 832 2793 2020-05-01T00:00:00Z       14498     87842 78179                     8 457 2500 79906 totalTestEncountersViral 3335 79906 12 46 8350c250eaeb27177e0aa1124ba035679054402c 0 0 0 0 0  
3778 3778 20200721 MN 47457 829402   876859 266 4723 112 1412     41511 A 7/20/2020 17:00 2020-07-20T17:00:00Z 07/20 13:00 1588 4723 2020-07-20T17:00:00Z       47457 1548 40 876859                       27 350 9099 876859 posNeg 9449 876859 3 45 3785bcaef0efdc6a747dc7459c9529a8c2a578f0 0 0 0 0 0  
4141 4141 20200715 WA 47655 829170   876825 353 4788     55     B 7/14/2020 02:59 2020-07-14T02:59:00Z 07/13 22:59 1404 4788 2020-07-14T02:59:00Z       47655 1404   876825 718234                     53 962 15888 876825 posNeg 16850 876825 5 10 d2509daeb3d05fafb05907d77c2c81d69c75442b 0 0 0 0 0  
6752 6752 20200529 ND 2519 66933   87671 36 164         1882 C 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 48 164 2020-05-29T00:00:00Z 89526     2519 45 3 87671 67336                     38 40 1160 69452 totalTestEncountersViral 2787 69452 0 3 874e6297c1a506366446285af671adf4534e25cd 0 0 0 0 0  
8730 8730 20200424 VA 11594 57846 487 87596 1399 1837 379   220   1672 A 4/24/2020 00:00 2020-04-24T00:00:00Z 04/23 20:00 410 1837 2020-04-24T00:00:00Z   15704   11169 407 3 87596                       51 596 3955 69927 posNeg 4990 69440 38 84 ce707ce88e362f4d714d4a4eebd3b0666ecb6444 0 0 0 0 0  
2247 2247 20200817 CO 53176 581397   873051 240 6735         5695 A 8/16/2020 01:59 2020-08-16T01:59:00Z 08/15 21:59 1768 6735 2020-08-16T01:59:00Z       49611     873051 631008 149571 10304 139267               8 338 7930 634573 totalTestEncountersViral 13317 634573 0 8 487054c0f4e0813c744a2367583d04b972e7ccef 0 0 0 0 0  
9529 9529 20200409 DC 1523 7201   8724             393 A 4/8/2020 00:00 2020-04-08T00:00:00Z 04/07 20:00 32   2020-04-08T00:00:00Z             8724                       11 83 358 8724 posNeg 441 8724 5 0 d868f7f6d1a98b6882eb1613af41a94aa6a635d6 0 0 0 0 0  
1214 1214 20200905 NY 438772 8271842   8710614 425 89995 115   61   75366 A 9/4/2020 23:59 2020-09-04T23:59:00Z 09/04 19:59 25350 89995 2020-09-04T23:59:00Z       438772     8710614                       36 801 98960 8710614 posNeg 99761 8710614 2 0 3203352b567beff063498834de2f7f01c331486a 0 0 0 0 0  
9732 9732 20200406 RI 1356 8609   8691 109   37   26   35 B 4/6/2020 03:00 2020-04-06T03:00:00Z 04/05 23:00 27   2020-04-06T03:00:00Z 10654 1362 9292 1356     8691 9965                     44 206 1577 9965 totalTestEncountersViral 1343 9965 2 0 09833e1691359eca7f5b03c26191198c7ff29535 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
);