states_daily_4pm_et

Table actions

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

11,578 rows sorted by recovered

✎ 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
689 689 20200914 IL 264839 4509052   4773891 1431   335   131     A 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 8546   2020-09-14T00:00:00Z 4771796     262744 8314 232                         17 1373 34557 4773891 posNeg 35930 4773891 5 0 c321e21d9843e535c081526ea341e0648738d361 0 0 0 0 0  
699 699 20200914 MO 104079 1041128   1145207 1010             A 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 1714   2020-09-14T00:00:00Z 1495313 112317 1380372 104079       1145207       71452 3221 68231         29 1332 15175 1145207 posNeg 16507 1145207 9 0 bf1297e8be676cead131d281f3e4682d05085f1e 0 0 0 0 0  
715 715 20200914 PR 37750 305972   343722 414   63   37     C 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 542   2020-09-14T00:00:00Z 310546 7002 303412 17977 376 166       19773                 72 370 0 343722 posNeg 370 343722 3 0 29509b55aba939cf106f0cead8697cb43d3cc8b9 0 0 0 0 0  
725 725 20200914 WA 80138 1573829   1653967 247 7098     26     B 9/14/2020 02:59 2020-09-14T02:59:00Z 09/13 22:59 2006 7098 2020-09-14T02:59:00Z       80138 2006   1653967                       53 312 9070 1653967 posNeg 9382 1653967 15 17 5ea4cb27dfe4cc0f74ba6251eb0b89cd259b8d1d 0 0 0 0 0  
732 732 20200913 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 3ae357e9638017e50197c3bf2bd193a2569941a7 0 0 0 0 0  
734 734 20200913 CA 754923 11935093   12690016 3741   1056         B 9/13/2020 02:59 2020-09-13T02:59:00Z 09/12 22:59 14329   2020-09-13T02:59:00Z 12690016     754923                             6 4625 128424 12690016 posNeg 133049 12690016 78 0 859c28aefef80eb5c5fd7f042024d17aa52879a1 0 0 0 0 0  
739 739 20200913 FL 663994 4259936 3696 4923930 2631 41769           A+ 9/12/2020 23:59 2020-09-12T23:59:00Z 09/12 19:59 12764 41769 2020-09-12T23:59:00Z 6855793 854899 5961411 663994 12764     4930974 446669 34738 411877 437913 34017 403867   12659     12 2423 19827 4927626 posNeg 22250 4923930 8 82 033818892ed13dc9c9aa656b3121a155a436a978 0 0 0 0 0  
740 740 20200913 GA 294314 2307888   2602202 2138 26369   4827       A+ 9/13/2020 14:50 2020-09-13T14:50:00Z 09/13 10:50 6333 26369 2020-09-13T14:50:00Z 2602202 268347 2333855 294314         289794 23194                 13 1409 -9378 2602202 posNeg 17945 2602202 46 42 4e84c088015fc84c50b8708e1de97ac319ee06ab 0 0 0 0 0  
745 745 20200913 IL 263466 4474495   4737961 1422   328   136     A 9/13/2020 00:00 2020-09-13T00:00:00Z 09/12 20:00 8541   2020-09-13T00:00:00Z 4735866     261371 8309 232                         17 1462 45428 4737961 posNeg 46890 4737961 14 0 b7ca6d0c69303edebfcf74d375a84322ecd728d7 0 0 0 0 0  
755 755 20200913 MO 102747 1025953   1128700 971             A 9/13/2020 00:00 2020-09-13T00:00:00Z 09/12 20:00 1705   2020-09-13T00:00:00Z 1475583 110962 1362014 102747       1128700       71148 3196 67952         29 1613 13714 1128700 posNeg 15327 1128700 1 0 02e263d5599cb0f5a01250bfe53991ed610dda9a 0 0 0 0 0  
771 771 20200913 PR 37380 305972   343352 396   67   50     C 9/13/2020 00:00 2020-09-13T00:00:00Z 09/12 20:00 539   2020-09-13T00:00:00Z 310546 7002 303412 17769 373 166       19611                 72 288 0 343352 posNeg 288 343352 4 0 81f3dd8fc9d87963ce3c80775767a142fd2664b2 0 0 0 0 0  
781 781 20200913 WA 79826 1564759   1644585 254 7081     29     B 9/13/2020 02:59 2020-09-13T02:59:00Z 09/12 22:59 1991 7081 2020-09-13T02:59:00Z       79826 1991   1644585                       53 350 13073 1644585 posNeg 13423 1644585 0 33 80db4830a5d03b29165e5720a40f50a15214a576 0 0 0 0 0  
788 788 20200912 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 ca96fa86c9a0c4210a96c86ab92800701dce88ad 0 0 0 0 0  
790 790 20200912 CA 750298 11806669   12556967 3848   1120         B 9/12/2020 02:59 2020-09-12T02:59:00Z 09/11 22:59 14251   2020-09-12T02:59:00Z 12556967     750298                             6 4107 101200 12556967 posNeg 105307 12556967 162 0 acc205e35bf0b160647dcb0e8d5ff8e8510b5d48 0 0 0 0 0  
795 795 20200912 FL 661571 4240109 3676 4901680 2683 41687           A+ 9/11/2020 23:59 2020-09-11T23:59:00Z 09/11 19:59 12756 41687 2020-09-11T23:59:00Z 6818027 851937 5926779 661571 12756     4908723 446669 34738 411877 437913 34017 403867   12579     12 3190 21734 4905356 posNeg 24924 4901680 98 193 188d0335691f616fdf912e127c0f9d4568a73973 0 0 0 0 0  
796 796 20200912 GA 292905 2317266   2584257 2114 26327   4818       A+ 9/12/2020 02:50 2020-09-12T02:50:00Z 09/11 22:50 6287 26327 2020-09-12T02:50:00Z 2584257 266991 2317266 292905         288667 23016                 13 2124 49728 2610171 posNeg 25938 2610171 41 164 1660527380afa71db4b3b38787bf182206944bb9 0 0 0 0 0  
801 801 20200912 IL 262004 4429067   4691071 1509   344   170     A 9/12/2020 00:00 2020-09-12T00:00:00Z 09/11 20:00 8527   2020-09-12T00:00:00Z 4688976     259909 8295 232                         17 2121 54473 4691071 posNeg 56594 4691071 22 0 bd634d3d1c5fc18bbe42b547082075acc74dbd1f 0 0 0 0 0  
811 811 20200912 MO 101134 1012239   1113373 1040             A 9/12/2020 00:00 2020-09-12T00:00:00Z 09/11 20:00 1704   2020-09-12T00:00:00Z 1456844 109562 1344724 101134       1113373       70997 3188 67809         29 1974 14827 1113373 posNeg 16801 1113373 3 0 7a79f40398cb83ea96e47496585d7c1d0be0a2a9 0 0 0 0 0  
827 827 20200912 PR 37092 305972   343064 420   71   54     C 9/12/2020 00:00 2020-09-12T00:00:00Z 09/11 20:00 535   2020-09-12T00:00:00Z 310546 7002 303412 17598 370 165       19494                 72 511 0 343064 posNeg 511 343064 12 0 8d367ef4c3a5f83204365b19423c8398b3a13ec5 0 0 0 0 0  
837 837 20200912 WA 79476 1551686   1631162 269 7048     19     B 9/11/2020 02:59 2020-09-11T02:59:00Z 09/10 22:59 1991 7048 2020-09-11T02:59:00Z       79476 1991   1631162                       53 465 15949 1631162 posNeg 16414 1631162 0 30 04905c7bc2499c4a8103c5c98e96035d7713c9c5 0 0 0 0 0  
844 844 20200911 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 af92759401b47f8c1b3777fde5b06c65b773a25a 0 0 0 0 0  
846 846 20200911 CA 746191 11705469   12451660 4023   1172         B 9/11/2020 02:59 2020-09-11T02:59:00Z 09/10 22:59 14089   2020-09-11T02:59:00Z 12451660     746191                             6 3326 58343 12451660 posNeg 61669 12451660 111 0 711a528c1e9e5ccd9a5bab8e18df6a3e1894e1fd 0 0 0 0 0  
851 851 20200911 FL 658381 4218375 3617 4876756 2815 41494           A+ 9/10/2020 23:59 2020-09-10T23:59:00Z 09/10 19:59 12658 41494 2020-09-10T23:59:00Z 6775044 847950 5888216 658381 12658     4883780 446669 34738 411877 437913 34017 403867   12144     12 3650 22847 4880373 posNeg 26497 4876756 176 215 5ccc37cb27f6408e589f33a1f27725429ee88ea1 0 0 0 0 0  
852 852 20200911 GA 290781 2267538   2558319 2152 26163   4794       A+ 9/11/2020 14:50 2020-09-11T14:50:00Z 09/11 10:50 6246 26163 2020-09-11T14:50:00Z 2558319 265022 2293297 290781         287173 22769                 13 1658 14067 2558319 posNeg 15725 2558319 42 101 34a23d011eb71609eac4844af598429ec0bc7096 0 0 0 0 0  
857 857 20200911 IL 259883 4374594   4634477 1619   359   155     A 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 8505   2020-09-11T00:00:00Z 4632382     257788 8273 232                         17 2312 54516 4634477 posNeg 56828 4634477 44 0 96264885e3c4b77ab4a24d9d57cdc263cb016b9a 0 0 0 0 0  
867 867 20200911 MO 99160 997412   1096572 934       113     A 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 1701   2020-09-11T00:00:00Z 1437730 107727 1327482 99160       1096572       70812 3157 67655         29 1569 11079 1096572 posNeg 12648 1096572 10 0 4e22fbe33ddea3bd2f24c4cd0f1e6c04db56d733 0 0 0 0 0  
883 883 20200911 PR 36581 305972   342553 401   68   52     C 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 523   2020-09-11T00:00:00Z 310546 7002 303412 17357 359 164       19224                 72 302 0 342553 posNeg 302 342553 11 0 7ac233925abe87e974af7b03d23e1028daae47ac 0 0 0 0 0  
893 893 20200911 WA 79011 1535737   1614748 269 7018     19     B 9/11/2020 02:59 2020-09-11T02:59:00Z 09/10 22:59 1991 7018 2020-09-11T02:59:00Z       79011 1991   1614748                       53 544 16217 1614748 posNeg 16761 1614748 6 25 ce88d99a428baca0fb30bceae336d84e2af1d1c6 0 0 0 0 0  
900 900 20200910 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 aafe07069b99c5cb6e3a433727b4d1233cba2abd 0 0 0 0 0  
902 902 20200910 CA 742865 11647126   12389991 4225   1184         B 9/10/2020 02:59 2020-09-10T02:59:00Z 09/09 22:59 13978   2020-09-10T02:59:00Z 12389991     742865                             6 3338 42856 12389991 posNeg 46194 12389991 137 0 70bd888e8109152c7b9e305e5459098fd677ab2d 0 0 0 0 0  
907 907 20200910 FL 654731 4195528 3570 4850259 2896 41279           A+ 9/9/2020 23:59 2020-09-09T23:59:00Z 09/09 19:59 12482 41279 2020-09-09T23:59:00Z 6730958 843542 5848754 654731 12482     4857274 446669 34738 411877 437913 34017 403867   11749     12 2583 16428 4853829 posNeg 19011 4850259 213 294 0008f4b953e1db194777ca326540a93e665f00da 0 0 0 0 0  
908 908 20200910 GA 289123 2253471   2542594 2169 26062   4776       A+ 9/10/2020 14:50 2020-09-10T14:50:00Z 09/10 10:50 6204 26062 2020-09-10T14:50:00Z 2542594 263704 2278890 289123         286202 22628                 13 1836 12979 2542594 posNeg 14815 2542594 76 217 e783ef08cd75b9b1152adde0df3ffe2d33f7be33 0 0 0 0 0  
913 913 20200910 IL 257571 4320078   4577649 1609   346   141     A 9/10/2020 00:00 2020-09-10T00:00:00Z 09/09 20:00 8461   2020-09-10T00:00:00Z 4575721     255643 8242 219                         17 1953 47029 4577649 posNeg 48982 4577649 28 0 d0130350c9771ffd65c9b5eb6bff1ebcf50ed047 0 0 0 0 0  
923 923 20200910 MO 97591 986333   1083924 934       113     A 9/10/2020 00:00 2020-09-10T00:00:00Z 09/09 20:00 1691   2020-09-10T00:00:00Z 1419455 106440 1310509 97591       1083924       70634 3136 67498         29 1116 11899 1083924 posNeg 13015 1083924 18 0 57f6bdd6f92555a9cf3a0d1395eb59e1b0ff3df2 0 0 0 0 0  
939 939 20200910 PR 36279 305972   342251 421   70   57     C 9/10/2020 00:00 2020-09-10T00:00:00Z 09/09 20:00 512   2020-09-10T00:00:00Z 310546 7002 303412 17248 349 163       19031                 72 772 0 342251 posNeg 772 342251 12 0 fd1b5c7b431ebec99719aebb59b9fdfdfc148c2a 0 0 0 0 0  
949 949 20200910 WA 78467 1519520   1597987 284 6993     29     B 9/10/2020 02:59 2020-09-10T02:59:00Z 09/09 22:59 1985 6993 2020-09-10T02:59:00Z       78467 1985   1597987                       53 458 13626 1597987 posNeg 14084 1597987 7 27 8881396361b748fb79fcf045dabad9010208e843 0 0 0 0 0  
956 956 20200909 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 b568d4827408ce320e19f678e9d3d4da52b89bf1 0 0 0 0 0  
958 958 20200909 CA 739527 11604270   12343797 4425   1233         B 9/9/2020 02:59 2020-09-09T02:59:00Z 09/08 22:59 13841   2020-09-09T02:59:00Z 12343797     739527                             6 1616 74233 12343797 posNeg 75849 12343797 83 0 dffe4b9b0b80083c25bfd3e7be98fca98ee07ed2 0 0 0 0 0  
963 963 20200909 FL 652148 4179100 3557 4831248 3077 40985           A+ 9/8/2020 23:59 2020-09-08T23:59:00Z 09/08 19:59 12269 40985 2020-09-08T23:59:00Z 6697687 840250 5818991 652148 12269     4838264 446669 34738 411877 437913 34017 403867   11324     12 2056 12319 4834805 posNeg 14375 4831248 202 324 3bae7335c0fa4c7c624e19a3390078d87f37afdb 0 0 0 0 0  
964 964 20200909 GA 287287 2240492   2527779 2099 25845   4736       A+ 9/9/2020 14:50 2020-09-09T14:50:00Z 09/09 10:50 6128 25845 2020-09-09T14:50:00Z 2527779 262647 2265132 287287         285881 22584                 13 1937 14016 2527779 posNeg 15953 2527779 58 256 446270c22ffb1b89dbfea7edb2743317ca7b968d 0 0 0 0 0  
969 969 20200909 IL 255618 4273049   4528667 1580   357   133     A 9/9/2020 00:00 2020-09-09T00:00:00Z 09/08 20:00 8433   2020-09-09T00:00:00Z 4526739     253690 8214 219                         17 1337 46692 4528667 posNeg 48029 4528667 28 0 1c11fbf40e495a7ace2a8d665b07ada36a9b19af 0 0 0 0 0  
979 979 20200909 MO 96475 974434   1070909 934       113     A 9/9/2020 00:00 2020-09-09T00:00:00Z 09/08 20:00 1673   2020-09-09T00:00:00Z 1399957 105700 1291761 96475       1070909       70267 3112 67155         29 1362 8317 1070909 posNeg 9679 1070909 12 0 40009545c4401dc17cd3a12f069caf4521a36622 0 0 0 0 0  
995 995 20200909 PR 35507 305972   341479 400   71   56     C 9/9/2020 00:00 2020-09-09T00:00:00Z 09/08 20:00 500   2020-09-09T00:00:00Z 310546 7002 303412 16789 337 163       18718                 72 3 0 341479 posNeg 3 341479 18 0 eaf36c5da3ff7023c9c12fe55dbf25a62f9a5000 0 0 0 0 0  
1005 1005 20200909 WA 78009 1505894   1583903 290 6966     34     B 9/9/2020 02:59 2020-09-09T02:59:00Z 09/08 22:59 1978 6966 2020-09-09T02:59:00Z       78009 1978   1583903                       53 774 20076 1583903 posNeg 20850 1583903 25 106 a39686437fcfae40f1278399add12a06330b281a 0 0 0 0 0  
1012 1012 20200908 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 57 1571 posNeg 57 1571 0 0 8b4aa9d198cf888bb19a9c536401d3ee1ff86512 0 0 0 0 0  
1014 1014 20200908 CA 737911 11530037   12267948 4297   1217         B 9/8/2020 02:59 2020-09-08T02:59:00Z 09/07 22:59 13758   2020-09-08T02:59:00Z 12267948     737911                             6 2676 106980 12267948 posNeg 109656 12267948 32 0 f928882d5fdc32e6dca86ff19138dcc793687fbf 0 0 0 0 0  
1019 1019 20200908 FL 650092 4166781 3526 4816873 3155 40661           A+ 9/7/2020 23:59 2020-09-07T23:59:00Z 09/07 19:59 12067 40661 2020-09-07T23:59:00Z 6667691 837246 5792121 650092 12067     4823952 446669 34738 411877 437913 34017 403867   10947     12 1823 13366 4820399 posNeg 15189 4816873 44 114 aa91f2aeed7a5ed90ab33b85ba4ee13c55eab0aa 0 0 0 0 0  
1020 1020 20200908 GA 285350 2226476   2511826 2215 25589   4698       A+ 9/8/2020 14:50 2020-09-08T14:50:00Z 09/08 10:50 6070 25589 2020-09-08T14:50:00Z 2511826 261567 2250259 285350         285478 22532                 13 1543 21442 2511826 posNeg 22985 2511826 26 51 92943e9aff98cab22518e8e2d93d7be3d9db8608 0 0 0 0 0  
1025 1025 20200908 IL 254281 4226357   4480638 1504   343   133     A 9/8/2020 00:00 2020-09-08T00:00:00Z 09/07 20:00 8405   2020-09-08T00:00:00Z 4478710     252353 8186 219                         17 1392 29971 4480638 posNeg 31363 4480638 7 0 a34480203acf8f27e3c7134dbc7812e264121ddf 0 0 0 0 0  
1035 1035 20200908 MO 95113 966117   1061230 934       113     A 9/8/2020 00:00 2020-09-08T00:00:00Z 09/07 20:00 1661   2020-09-08T00:00:00Z 1387279 104695 1280117 95113       1061230       70177 3102 67075         29 773 6072 1061230 posNeg 6845 1061230 2 0 5166d4afe0cb64166083f93b896ff3e45b56c111 0 0 0 0 0  
1051 1051 20200908 PR 35504 305972   341476 380   81   66     C 9/8/2020 00:00 2020-09-08T00:00:00Z 09/07 20:00 482   2020-09-08T00:00:00Z 310546 7002 303412 16788 319 163       18716                 72 129 0 341476 posNeg 129 341476 5 0 cfebefb39ec0523abe1314f74278b053395bda64 0 0 0 0 0  
1061 1061 20200908 WA 77235 1485818   1563053 277 6860     37     B 9/6/2020 02:59 2020-09-06T02:59:00Z 09/05 22:59 1953 6860 2020-09-06T02:59:00Z       77235 1953   1563053                       53 0 0 1563053 posNeg 0 1563053 0 0 6ba255671b79e34e2ea3be606ee6fc0cedb4c0d3 0 0 0 0 0  
1068 1068 20200907 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 5085675dfa58821863ab561c420b108feb82868d 0 0 0 0 0  
1070 1070 20200907 CA 735235 11423057   12158292 4285   1244         B 9/6/2020 02:59 2020-09-06T02:59:00Z 09/05 22:59 13726   2020-09-06T02:59:00Z 12158292     735235                             6 3091 108010 12158292 posNeg 111101 12158292 17 0 5aaa984c0a0d57eb1ce497b3605faea9adfef7f8 0 0 0 0 0  
1075 1075 20200907 FL 648269 4153415 3538 4801684 3157 40547           A+ 9/6/2020 23:59 2020-09-06T23:59:00Z 09/06 19:59 12023 40547 2020-09-06T23:59:00Z 6642061 834866 5769019 648269 12023     4808756 446669 34738 411877 437913 34017 403867   10833     12 1838 15076 4805222 posNeg 16914 4801684 22 60 23fa515abdf4a51e084eba4a6fa7e2008b628b71 0 0 0 0 0  
1076 1076 20200907 GA 283807 2205034   2488841 2214 25538   4687       A+ 9/7/2020 14:50 2020-09-07T14:50:00Z 09/07 10:50 6044 25538 2020-09-07T14:50:00Z 2488841 259641 2229200 283807         284452 22365                 13 608 8665 2488841 posNeg 9273 2488841 7 15 ed2cea873deebc8ed74cedd812a62ff1fd52892a 0 0 0 0 0  
1081 1081 20200907 IL 252889 4196386   4449275 1484   352   137     A 9/7/2020 00:00 2020-09-07T00:00:00Z 09/06 20:00 8398   2020-09-07T00:00:00Z 4447347     250961 8179 219                         17 1381 27594 4449275 posNeg 28975 4449275 8 0 0c15222af81b6e038f2671f6a72ac9b8a0a4a8e7 0 0 0 0 0  
1091 1091 20200907 MO 94340 960045   1054385 934       113     A 9/7/2020 00:00 2020-09-07T00:00:00Z 09/06 20:00 1659   2020-09-07T00:00:00Z 1378643 103847 1272326 94340       1054385       70158 3087 67071         29 906 7636 1054385 posNeg 8542 1054385 1 0 a5e8fe8af1cbadbe25fa0b3636465c57ab9d52e0 0 0 0 0 0  
1107 1107 20200907 PR 35375 305972   341347 372   81   72     C 9/7/2020 00:00 2020-09-07T00:00:00Z 09/06 20:00 477   2020-09-07T00:00:00Z 310546 7002 303412 16692 317 160       18683                 72 842 0 341347 posNeg 842 341347 0 0 5ce38c2a9c7e04f7562acfaf8b2e7cadf097a315 0 0 0 0 0  
1117 1117 20200907 WA 77235 1485818   1563053 277 6860     37     B 9/6/2020 02:59 2020-09-06T02:59:00Z 09/05 22:59 1953 6860 2020-09-06T02:59:00Z       77235 1953   1563053                       53 399 12177 1563053 posNeg 12576 1563053 0 18 4183fd993e88d30f38b0eb19a7a3ab58cc1ac5f0 0 0 0 0 0  
1124 1124 20200906 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 8e9a58f72785fb83c490d6b168f1467bd6c2e8f8 0 0 0 0 0  
1126 1126 20200906 CA 732144 11315047   12047191 4226   1201         B 9/6/2020 02:59 2020-09-06T02:59:00Z 09/05 22:59 13709   2020-09-06T02:59:00Z 12047191     732144                             6 4905 125963 12047191 posNeg 130868 12047191 66 0 5f23f328eef045f751f7adb12260a64df1fc30e4 0 0 0 0 0  
1131 1131 20200906 FL 646431 4138339 3524 4784770 3167 40487           A+ 9/5/2020 23:59 2020-09-05T23:59:00Z 09/05 19:59 12001 40487 2020-09-05T23:59:00Z 6612703 832459 5742293 646431 12001     4791823 446669 34738 411877 437913 34017 403867   10766     12 2564 18399 4788294 posNeg 20963 4784770 38 114 ded5afc68dad7811f2a9a39f6ce92a2e7a85c726 0 0 0 0 0  
1132 1132 20200906 GA 283199 2196369   2479568 2202 25523   4684       A+ 9/6/2020 14:50 2020-09-06T14:50:00Z 09/06 10:50 6037 25523 2020-09-06T14:50:00Z 2479568 259039 2220529 283199         284452 22365                 13 1651 17188 2479568 posNeg 18839 2479568 60 22 05000df095129ecc62d0ae28a7a5ff4a70fd08be 0 0 0 0 0  
1137 1137 20200906 IL 251508 4168792   4420300 1504   356   134     A 9/6/2020 00:00 2020-09-06T00:00:00Z 09/05 20:00 8390   2020-09-06T00:00:00Z 4418372     249580 8171 219                         17 1403 45093 4420300 posNeg 46496 4420300 5 0 8e94a671a61a66d8328f538424b11a2dd4270695 0 0 0 0 0  
1147 1147 20200906 MO 93434 952409   1045843 934       113     A 9/6/2020 00:00 2020-09-06T00:00:00Z 09/05 20:00 1658   2020-09-06T00:00:00Z 1368585 102766 1263356 93434       1045843       70006 3085 66921         29 1232 6310 1045843 posNeg 7542 1045843 19 0 504c8c1467d77bb8cae5cd784b89eea0e5da8b9b 0 0 0 0 0  
1163 1163 20200906 PR 34533 305972   340505 377   73   67     C 9/6/2020 00:00 2020-09-06T00:00:00Z 09/05 20:00 477   2020-09-06T00:00:00Z 310546 7002 303412 16269 317 160       18264                 72 41 0 340505 posNeg 41 340505 13 0 4e513133ec6ce9da11615d3b9d92702ee5e6a5c8 0 0 0 0 0  
1173 1173 20200906 WA 76836 1473641   1550477 282 6842     34     B 9/5/2020 02:59 2020-09-05T02:59:00Z 09/04 22:59 1953 6842 2020-09-05T02:59:00Z       76836 1953   1550477                       53 501 15886 1550477 posNeg 16387 1550477 0 -6 343893e7c52cbc7cb000d8d93c223c989c2473f2 0 0 0 0 0  
1180 1180 20200905 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 78615189f736f50add2170e1fb8468820dba264a 0 0 0 0 0  
1182 1182 20200905 CA 727239 11189084   11916323 4242   1242         B 9/5/2020 02:59 2020-09-05T02:59:00Z 09/04 22:59 13643   2020-09-05T02:59:00Z 11916323     727239                             6 4956 114397 11916323 posNeg 119353 11916323 153 0 630bf2ead0844d01ca0fc324633d61475a9f315a 0 0 0 0 0  
1187 1187 20200905 FL 643867 4119940 3577 4763807 3229 40373           A+ 9/4/2020 23:59 2020-09-04T23:59:00Z 09/04 19:59 11963 40373 2020-09-04T23:59:00Z 6579765 829243 5712716 643867 11963     4770876 446669 34738 411877 437913 34017 403867   10603     12 3656 20144 4767384 posNeg 23800 4763807 60 246 1e8c07f02d77f4d6d2df37f238c73c1452920377 0 0 0 0 0  
1188 1188 20200905 GA 281548 2179181   2460729 2740 25501   4681       A+ 9/5/2020 02:50 2020-09-05T02:50:00Z 09/04 22:50 5977 25501 2020-09-05T02:50:00Z 2460729 257428 2203301 281548         283277 22155                 13 2194 26410 2460729 posNeg 28604 2460729 46 99 07c6206525b90fe9c5f676794a9fb73b4823f8f8 0 0 0 0 0  
1193 1193 20200905 IL 250105 4123699   4373804 1550   363   151     A 9/5/2020 00:00 2020-09-05T00:00:00Z 09/04 20:00 8385   2020-09-05T00:00:00Z 4371876     248177 8166 219                         17 2806 59129 4373804 posNeg 61935 4373804 23 0 8edafa0c570a485547cd48b721eb79899f606ad3 0 0 0 0 0  
1203 1203 20200905 MO 92202 946099   1038301 934       113     A 9/5/2020 00:00 2020-09-05T00:00:00Z 09/04 20:00 1639   2020-09-05T00:00:00Z 1360462 101521 1256574 92202       1038301       69847 3040 66807         29 1987 14584 1038301 posNeg 16571 1038301 77 0 b2003fbc69977916e7ff6339c8852d766f21341f 0 0 0 0 0  
1219 1219 20200905 PR 34492 305972   340464 369   76   67     C 9/5/2020 00:00 2020-09-05T00:00:00Z 09/04 20:00 464   2020-09-05T00:00:00Z 310546 7002 303412 16243 309 155       18249                 72 251 0 340464 posNeg 251 340464 9 0 bd424757482add7bb555b28f4012dc10a0c54342 0 0 0 0 0  
1229 1229 20200905 WA 76335 1457755   1534090 293 6848     48     B 9/4/2020 02:59 2020-09-04T02:59:00Z 09/03 22:59 1953 6848 2020-09-04T02:59:00Z       76335 1953   1534090                       53 479 15522 1534090 posNeg 16001 1534090 8 14 44041f5fdbd74a75d6ee8a7133a11b0285e306ab 0 0 0 0 0  
1236 1236 20200904 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 f60826de4e95b3f4a2a0f00c53e1bde01483b6c9 0 0 0 0 0  
1238 1238 20200904 CA 722283 11074687   11796970 4401   1235         B 9/4/2020 02:59 2020-09-04T02:59:00Z 09/03 22:59 13490   2020-09-04T02:59:00Z 11796970     722283                             6 5106 127940 11796970 posNeg 133046 11796970 163 0 49735117d21bdd3611a6b354865cf374d74d5011 0 0 0 0 0  
1243 1243 20200904 FL 640211 4099796 3557 4740007 3360 40127           A+ 9/3/2020 23:59 2020-09-03T23:59:00Z 09/03 19:59 11903 40127 2020-09-03T23:59:00Z 6538991 824418 5677015 640211 11903     4747072 446669 34738 411877 437913 34017 403867   10218     12 3198 19113 4743564 posNeg 22311 4740007 103 243 d1d7433479fb88de04f07503ca528b387df1924d 0 0 0 0 0  
1244 1244 20200904 GA 279354 2152771   2432125 2295 25402   4664       A+ 9/4/2020 14:50 2020-09-04T14:50:00Z 09/04 10:50 5931 25402 2020-09-04T14:50:00Z 2432125 254680 2177445 279354         282093 21947                 13 2066 19394 2432125 posNeg 21460 2432125 63 143 2f966bfb6dd84cd9dfccc14c0b1443adcf26749d 0 0 0 0 0  
1249 1249 20200904 IL 247299 4064570   4311869 1621   360   155     A 9/4/2020 00:00 2020-09-04T00:00:00Z 09/03 20:00 8362   2020-09-04T00:00:00Z 4309941     245371 8143 219                         17 5594 143905 4311869 posNeg 149499 4311869 38 0 5019540a24a7f535ee50962812b8809ac9d433a1 0 0 0 0 0  
1259 1259 20200904 MO 90215 931515   1021730 934       113     A 9/4/2020 00:00 2020-09-04T00:00:00Z 09/03 20:00 1562   2020-09-04T00:00:00Z 1339671 99995 1237342 90215       1021730       69634 3017 66617         29 1605 12047 1021730 posNeg 13652 1021730 17 0 b339283eb38e22feb472c09464930831a764a13d 0 0 0 0 0  
1275 1275 20200904 PR 34241 305972   340213 382   78   60     C 9/4/2020 00:00 2020-09-04T00:00:00Z 09/03 20:00 455   2020-09-04T00:00:00Z 310546 7002 303412 16101 302 153       18140                 72 43 0 340213 posNeg 43 340213 7 0 e208268e278221b8a0081c8728d83a71174a9d03 0 0 0 0 0  
1285 1285 20200904 WA 75856 1442233   1518089 309 6834     50     B 9/3/2020 02:59 2020-09-03T02:59:00Z 09/02 22:59 1945 6834 2020-09-03T02:59:00Z       75856 1945   1518089                       53 479 21257 1518089 posNeg 21736 1518089 10 39 c8db8603b17559c43d74d5d521e7616e753986da 0 0 0 0 0  
1292 1292 20200903 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 56dee75bc9943e7392a15213f148aadf8d45c564 0 0 0 0 0  
1294 1294 20200903 CA 717177 10946747   11663924 4571   1270         B 9/3/2020 02:59 2020-09-03T02:59:00Z 09/02 22:59 13327   2020-09-03T02:59:00Z 11663924     717177                             6 5125 78429 11663924 posNeg 83554 11663924 164 0 b1412a711c1f5bd1f51e9cd58ce3c301af90c719 0 0 0 0 0  
1299 1299 20200903 FL 637013 4080683 3509 4717696 3438 39884           A+ 9/2/2020 23:59 2020-09-02T23:59:00Z 09/02 19:59 11800 39884 2020-09-02T23:59:00Z 6499749 820290 5642186 637013 11800     4724739 446669 34738 411877 437913 34017 403867   9889     12 3571 20323 4721205 posNeg 23894 4717696 149 273 0fb972a9fe5fab2cdfe677389ee19cb64debc63f 0 0 0 0 0  
1300 1300 20200903 GA 277288 2133377   2410665 2365 25259   4628       A+ 9/3/2020 14:50 2020-09-03T14:50:00Z 09/03 10:50 5868 25259 2020-09-03T14:50:00Z 2410665 252857 2157808 277288         280702 21730                 13 2675 26353 2410665 posNeg 29028 2410665 73 234 268574468a1f67f7c369758a9885c50180d7c881 0 0 0 0 0  
1305 1305 20200903 IL 241705 3920665   4162370 1620   360   144     A 9/3/2020 00:00 2020-09-03T00:00:00Z 09/02 20:00 8324   2020-09-03T00:00:00Z 4160668     240003 8115 209                         17 1360 39435 4162370 posNeg 40795 4162370 24 0 fc9df670e72a2b66365dadd143a9039e83cb7cb6 0 0 0 0 0  
1315 1315 20200903 MO 88610 919468   1008078 934       113     A 9/3/2020 00:00 2020-09-03T00:00:00Z 09/02 20:00 1545   2020-09-03T00:00:00Z 1323249 98525 1222406 88610       1008078       69430 2982 66448         29 1397 8584 1008078 posNeg 9981 1008078 3 0 2570fd97374ebe62aa21553c265ad7ed7fe41537 0 0 0 0 0  
1331 1331 20200903 PR 34198 305972   340170 349   73   57     C 9/3/2020 00:00 2020-09-03T00:00:00Z 09/02 20:00 448   2020-09-03T00:00:00Z 310546 7002 303412 16069 296 152       18129                 72 195 0 340170 posNeg 195 340170 5 0 85b099cbff70fe17a4b62c6a86ed74e33005664b 0 0 0 0 0  
1341 1341 20200903 WA 75377 1420976   1496353 311 6795     65     B 9/2/2020 02:59 2020-09-02T02:59:00Z 09/01 22:59 1935 6795 2020-09-02T02:59:00Z       75377 1935   1496353                       53 438 15876 1496353 posNeg 16314 1496353 4 8 7c88afe1fafea3676c2ab564d5603bac18ac7d06 0 0 0 0 0  
1348 1348 20200902 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 48ebb399ca7a84fe4e65df7be64d01c2adde9b27 0 0 0 0 0  
1350 1350 20200902 CA 712052 10868318   11580370 4851   1339         B 9/2/2020 02:59 2020-09-02T02:59:00Z 09/01 22:59 13163   2020-09-02T02:59:00Z 11580370     712052                             6 4255 105419 11580370 posNeg 109674 11580370 145 0 61ce2c9982d886c3da71512bb44db09f2bd735a6 0 0 0 0 0  
1355 1355 20200902 FL 633442 4060360 3515 4693802 3511 39611           A+ 9/1/2020 23:59 2020-09-01T23:59:00Z 09/01 19:59 11651 39611 2020-09-01T23:59:00Z 6461035 815752 5608276 633442 11651     4700822 446669 34738 411877 437913 34017 403867   9489     12 2402 15534 4697317 posNeg 17936 4693802 130 300 1d3a0eb59cf90c76cb7f2bd307324bee0e49f4f9 0 0 0 0 0  
1356 1356 20200902 GA 274613 2107024   2381637 2469 25025   4588       A+ 9/2/2020 14:50 2020-09-02T14:50:00Z 09/02 10:50 5795 25025 2020-09-02T14:50:00Z 2381637 250612 2131025 274613         278683 21440                 13 1916 11223 2381637 posNeg 13139 2381637 62 178 f0b119d1023c46cc465e24a6f82777f5a0182530 0 0 0 0 0  
1361 1361 20200902 IL 240345 3881230   4121575 1596   347   142     A 9/2/2020 00:00 2020-09-02T00:00:00Z 09/01 20:00 8300   2020-09-02T00:00:00Z 4119873     238643 8091 209                         17 2128 30623 4121575 posNeg 32751 4121575 27 0 b08d33d07aeebb0d03915410efb9e6dd9782f122 0 0 0 0 0  
1371 1371 20200902 MO 87213 910884   998097 934       113     A 9/2/2020 00:00 2020-09-02T00:00:00Z 09/01 20:00 1542   2020-09-02T00:00:00Z 1311023 96924 1211811 87213       998097       69257 2952 66305         29 1458 5395 998097 posNeg 6853 998097 4 0 c15c67360e3a79539b19b6f7222a96976d8f81c4 0 0 0 0 0  
1387 1387 20200902 PR 34003 305972   339975 373   71   53     C 9/2/2020 00:00 2020-09-02T00:00:00Z 09/01 20:00 443   2020-09-02T00:00:00Z 310546 7002 303412 15942 293 150       18061                 72 582 0 339975 posNeg 582 339975 8 0 cce409963061dd365612c154ebac2b510fc5f1e8 0 0 0 0 0  
1397 1397 20200902 WA 74939 1405100   1480039 328 6787     48     B 9/1/2020 02:59 2020-09-01T02:59:00Z 08/31 22:59 1931 6787 2020-09-01T02:59:00Z       74939 1931   1480039                       53 304 6490 1480039 posNeg 6794 1480039 16 24 cc7e7d883eee90615748714463203cdad2465dc6 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
);