states_daily_4pm_et

Table actions

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

61 rows where "dateChecked" is on date 2020-09-11

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, inIcuCumulative, onVentilatorCurrently, dataQualityGrade, lastUpdateEt, checkTimeEt, positiveTestsViral, negativeTestsViral, deathProbable, totalTestEncountersViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, totalTestResultsSource, deathIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-09-11 · 61 ✖
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
747 747 20200913 KS 48386 400544   448930 140 2537 40 690 10 219 1859 A+ 9/11/2020 10:00 2020-09-11T10:00:00Z 09/11 06:00 511 2537 2020-09-11T10:00:00Z               448930                     20 0 0 448930 posNeg 0 448930 0 0 5562750d6f8e4885550c4cbf5520fabab6edfefb 0 0 0 0 0  
787 787 20200912 AR 69710 750290   820354 392 4678 170   76 597 61245 A+ 9/11/2020 14:35 2020-09-11T14:35:00Z 09/11 10:35 969 4678 2020-09-11T14:35:00Z 820354   750290 68542 964 5                     17549 2709 5 727 20915 820000 posNeg 24175 820000 16 0 e1d5d689c3de02083ff13fdea155bd6c6b7a3912 0 0 0 0 0  
791 791 20200912 CO 60492 709735   1097985 232 7208         6139 A+ 9/11/2020 01:59 2020-09-11T01:59:00Z 09/10 21:59 1889 7208 2020-09-11T01:59:00Z       56378     1097985 766113 162325 11252 151073               8 307 5238 770227 totalTestEncountersViral 10786 770227 0 22 0d3f7ad5f13df8e0bc26f4346262fcb370d5ff97 0 0 0 0 0  
793 793 20200912 DC 14552 312885   327437 98   24   12   11561 A+ 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 616   2020-09-11T00:00:00Z             327437 194043                     11 59 5942 327437 posNeg 6001 327437 0 0 90d76f789c7f39088d2fbfc6efe030a4e0a1e04d 0 0 0 0 0  
794 794 20200912 DE 18726 240859   259585 66   15       10063 A+ 9/11/2020 18:00 2020-09-11T18:00:00Z 09/11 14:00 613   2020-09-11T18:00:00Z       17734 541 72   259585                     10 260 2627 259585 posNeg 2887 259585 0 0 6f34f6a51ad60ef179aaeb8d678da35a120494e9 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  
798 798 20200912 HI 10459 239580   250039 220 622 51   41   3334 C 9/11/2020 18:00 2020-09-11T18:00:00Z 09/11 14:00 96 622 2020-09-11T18:00:00Z 334756             250039                     15 167 3389 250039 posNeg 3556 250039 2 12 11703774c0e6eaa40ebaf08f66ff18d10ba22a5e 0 0 0 0 0  
800 800 20200912 ID 34950 240660   272888 165 1569 46 412     18052 A+ 9/11/2020 19:00 2020-09-11T19:00:00Z 09/11 15:00 412 1569 2020-09-11T19:00:00Z 272888     32228 375 37                         16 333 1461 275610 posNeg 1746 275610 5 18 d1819b1690fd76c18267755f390b6107decc4f3a 0 0 0 0 0  
802 802 20200912 IN 104561 1102419   1206980 807 11710 234 2327 70   81089 A+ 9/11/2020 23:59 2020-09-11T23:59:00Z 09/11 19:59 3437 11710 2020-09-11T23:59:00Z 1666889       3213 224   1206980                     18 1056 22820 1206980 posNeg 23876 1206980 17 59 dee45ad9fc39d28edcbbfea55a2668f905678d66 0 0 0 0 0  
803 803 20200912 KS 48386 400544   448930 140 2537 40 690 10 219 1859 A+ 9/11/2020 10:00 2020-09-11T10:00:00Z 09/11 06:00 511 2537 2020-09-11T10:00:00Z               448930                     20 0 0 448930 posNeg 0 448930 0 0 35d7ce6cf7bf9d30d0feb2960da36d3140ea08ae 0 0 0 0 0  
805 805 20200912 LA 157109 1880644   2037753 723       117   140440 A 9/11/2020 13:00 2020-09-11T13:00:00Z 09/11 09:00 5202   2020-09-11T13:00:00Z       156174 5032 170   2036818                     22 0 0 2037753 posNeg 0 2037753 0 0 3add26a8e3d061aad50f1595e2ed87b3bb0def9a 0 0 0 0 0  
808 808 20200912 ME 4834 320169   325003 10 431 6   4   4211 A+ 9/11/2020 23:59 2020-09-11T23:59:00Z 09/11 19:59 135 431 2020-09-11T23:59:00Z 324518 6048 318215 4349 134 1     9957 503 9440               23 42 4953 325003 posNeg 4995 325003 1 -1 4daa684fbe00a12fbd7f0bb798ebf3da42ae2222 0 0 0 0 0  
810 810 20200912 MN 83588 1138934   1684520 247 6899 140 1949     76650 A+ 9/11/2020 17:00 2020-09-11T17:00:00Z 09/11 13:00 1958 6899 2020-09-11T17:00:00Z       83588 1906 52 1684520 1222522                     27 872 9090 1222522 posNeg 19192 1222522 9 36 3a24ccc1b088bd8994b92892e63a45b9104da69c 0 0 0 0 0  
813 813 20200912 MS 89620 532919   622539 542 5410 179       74098 A+ 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 2685 5410 2020-09-11T00:00:00Z 617161     84242 2502 183     28693 95             38257   28 445 3715 622539 posNeg 4160 622539 15 0 1ab4ca1a6a3942a68d2467e04481f77e42c1a30f 0 0 0 0 0  
817 817 20200912 NE 37841 359513   397354 166 2131         28816 A+ 9/11/2020 20:30 2020-09-11T20:30:00Z 09/11 16:30 434 2131 2020-09-11T20:30:00Z       37841       397904                     31 468 3074 397354 posNeg 3542 397354 4 12 da1a439c90fbd20727e8beda684df95598679e08 0 0 0 0 0  
818 818 20200912 NH 7652 221372   369691 6 721   228     6920 B 9/11/2020 09:00 2020-09-11T09:00:00Z 09/11 05:00 435 721 2020-09-11T09:00:00Z 369691     7652       229024 31079     30329             33 32 1701 229024 posNeg 4046 229024 1 1 4bc7077257fb9ee0df1ccd1520ec42e80275a94d 0 0 0 0 0  
820 820 20200912 NM 26563 785487   812050 73 3247         14276 B 9/11/2020 17:50 2020-09-11T17:50:00Z 09/11 13:50 818 3247 2020-09-11T17:50:00Z 812050     26563                             35 134 4917 812050 posNeg 5051 812050 2 9 be4a660ffa6e223a40df7be40f253894beec384b 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  
828 828 20200912 RI 22999 283137   628091 80 2639 8   4   2220 A+ 9/11/2020 12:00 2020-09-11T12:00:00Z 09/11 08:00 1072 2639 2020-09-11T12:00:00Z   32558 595533 22999     628091 306136                     44 94 3019 306136 totalTestEncountersViral 12408 306136 1 19 f6a4985fde4dc3ee5a091b4f1554b0a2c2d32fe3 0 0 0 0 0  
829 829 20200912 SC 129978 924894   1054872 806 8402 220   131   51431 A+ 9/11/2020 23:59 2020-09-11T23:59:00Z 09/11 19:59 3040 8402 2020-09-11T23:59:00Z 1052540 168092 884448 127646 2891 149     65834 5799 60035               45 932 9464 1054872 posNeg 10396 1054872 12 49 56d70a33cc067170e29258b1b5bfccc410169a3d 0 0 0 0 0  
830 830 20200912 SD 16437 146172   162609 109 1152         13739 A+ 9/11/2020 14:00 2020-09-11T14:00:00Z 09/11 10:00 183 1152 2020-09-11T14:00:00Z 219227             162609                     46 320 1326 162609 posNeg 1646 162609 6 14 8200d254cf41ddf718ee22d91a3c4361fbeca00b 0 0 0 0 0  
832 832 20200912 TX 657589 4862052   5519641 3371   1174       573670 A+ 9/11/2020 16:25 2020-09-11T16:25:00Z 09/11 12:25 14143   2020-09-11T16:25:00Z 5519641     657589         383596 33571             44740 6299 48 4233 61367 5519641 posNeg 65600 5519641 146 0 c7d89c318abcf68ccd415afb9ad8e524cfa4604e 0 0 0 0 0  
834 834 20200912 VA 132940 1617170 272 1744020 995 17271 228   113   16276 A+ 9/11/2020 17:00 2020-09-11T17:00:00Z 09/11 13:00 2722 17271 2020-09-11T17:00:00Z   151825   126850 2589 133 1744020                       51 1300 14763 1750382 posNeg 15910 1750110 11 8 c6bf7225f0e0be9b18a53606d9906f42b79133c1 0 0 0 0 0  
836 836 20200912 VT 1677 147984   149661 4           1496 B 9/11/2020 23:59 2020-09-11T23:59:00Z 09/11 19:59 58   2020-09-11T23:59:00Z       1677 58     149661                     50 9 1077 149661 posNeg 1086 149661 0 0 119a4a94705da4511a864a34bcd0fb6f9f620011 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  
839 839 20200912 WV 12521 466355   478876 145   59   26   9225 C 9/11/2020 23:59 2020-09-11T23:59:00Z 09/11 19:59 265   2020-09-11T23:59:00Z 478580     12225 263 2     16292                   54 347 6738 478876 posNeg 7085 478876 2 0 747d75121a393bb8299b0b523bad771b58160e59 0 0 0 0 0  
841 841 20200911 AK 7024 387562   394586 44       7   2359 A 9/11/2020 03:59 2020-09-11T03:59:00Z 09/10 23:59 43   2020-09-11T03:59:00Z 394586 6340 387966 7024 43                           2 109 1400 394586 posNeg 1509 394586 1 0 7362921fa69c20bc82d18bd257382ca0197025c1 0 0 0 0 0  
842 842 20200911 AL 136703 874219   998316 811 15527   1593   877 54223 B 9/11/2020 11:00 2020-09-11T11:00:00Z 09/11 07:00 2333 15527 2020-09-11T11:00:00Z 998316     124097 2204 129           55157             1 1138 4046 1010922 posNeg 4876 1010922 32 188 4f5d424289ac00a717c8a75de272cd53028db436 0 0 0 0 0  
843 843 20200911 AR 68983 729375   796179 392 4678     76 597 61245 A 9/11/2020 14:35 2020-09-11T14:35:00Z 09/11 10:35 953 4678 2020-09-11T14:35:00Z 796179   729375 67911                         17549 2709 5 1180 0 798358 posNeg 0 798358 13 72 2348f9a7b8b46f7301b5aa6a35b72ae97760da85 0 0 0 0 0  
845 845 20200911 AZ 207523 1071901   1277543 577 21747 171   100   32472 A+ 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 5288 21747 2020-09-11T00:00:00Z       205642 5014 274   1277543 275536                   4 521 6169 1279424 posNeg 6670 1279424 15 136 ec55d92b4868082a5b2968208cdd51fb1722fe32 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  
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  
853 853 20200911 GU 1863 41150   43013 52   13       1118 A+ 9/11/2020 03:15 2020-09-11T03:15:00Z 09/10 23:15 23   2020-09-11T03:15:00Z 43011     1863       43013 158 2                 66 17 378 43013 posNeg 395 43013 2 0 28d8908cf66217d2f94fa983ecc93de9ea678af2 0 0 0 0 0  
855 855 20200911 IA 71133 602464   673597 281   83   36   52370 A+ 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 1211   2020-09-11T00:00:00Z       71133       675126       52493 3177 49276 15171 1895     19 728 5000 673597 posNeg 5728 673597 4 0 6e5d14c0dafd035ceb3784622fc7ca8b4fb18f3f 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  
859 859 20200911 KS 48386 400544   448930 140 2537 40 690 10 219 1859 A+ 9/11/2020 10:00 2020-09-11T10:00:00Z 09/11 06:00 511 2537 2020-09-11T10:00:00Z               448930                     20 976 6540 448930 posNeg 7516 448930 16 67 e463072e88b3bfdb16c9d73d71b7dcd753929943 0 0 0 0 0  
860 860 20200911 KY 55704 844986   894965 549 4862 124 1443     10822 B 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 1044 4862 2020-09-11T00:00:00Z 894965     49979 1035 9     48463               17002   21 932 15267 900690 posNeg 16048 900690 9 27 ef8249a670ea721ca92637b74d82d373dfbb296c 0 0 0 0 0  
861 861 20200911 LA 157109 1880644   2037753 723       117   140440 A 9/11/2020 13:00 2020-09-11T13:00:00Z 09/11 09:00 5202   2020-09-11T13:00:00Z       156174 5032 170   2036818                     22 755 26479 2037753 posNeg 27234 2037753 41 0 190da0080fb36a8221b24e38be29019ab1aa8bdc 0 0 0 0 0  
862 862 20200911 MA 123986 1803416   2905353 330 12411 60   22   107501 A+ 9/11/2020 08:00 2020-09-11T08:00:00Z 09/11 04:00 9180 12411 2020-09-11T08:00:00Z 2905353 160811   122202 8971 209   1925618       115893     100148       25 440 18963 1927402 totalTestsViral 52803 1927402 14 10 07b61a4c16cec3f5c68d503f803965e569ef09b5 0 0 0 0 0  
863 863 20200911 MD 114724 1318152   1432876 369 14756 89       7186 A+ 9/11/2020 10:00 2020-09-11T10:00:00Z 09/11 06:00 3828 14756 2020-09-11T10:00:00Z 2150638 136897   114724 3685 143   1432876                     24 646 8503 1432876 posNeg 9149 1432876 4 50 434b45a7d1d56097ffc2c4ef205fb01b68a32394 0 0 0 0 0  
865 865 20200911 MI 122251 2950535   3072786 627   172   77   80678 A+ 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 6900   2020-09-11T00:00:00Z 3106168 155633 2950535 110832 6578 322     267328                   26 1405 34933 3072786 posNeg 36338 3072786 6 0 c85cd0b7af30f1f41ae020b12b670768e0686817 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  
870 870 20200911 MT 8785 265873   274658 142 518         6795 B 9/11/2020 01:59 2020-09-11T01:59:00Z 09/10 21:59 131 518 2020-09-11T01:59:00Z 274658     8785                             30 122 1183 274658 posNeg 1305 274658 8 6 c2751196e8a9a0499110a9bb696138535ffd75a4 0 0 0 0 0  
871 871 20200911 NC 182286 2376368   2558654 938   292       156652 A+ 9/11/2020 12:50 2020-09-11T12:50:00Z 09/11 08:50 3023   2020-09-11T12:50:00Z 2558654     182286 3023                           37 1532 35283 2558654 posNeg 36815 2558654 33 0 55a80ab13fd22bbe495453d1204b9bbf630e1cac 0 0 0 0 0  
872 872 20200911 ND 14684 200392   506398 64 630 22 169     12177 A 9/11/2020 01:59 2020-09-11T01:59:00Z 09/10 21:59 133 630 2020-09-11T01:59:00Z 523783     14684 130 3 506398 215076 8978 367 8611               38 241 543 215076 totalTestEncountersViral 5474 215076 2 6 0344ebabd4a8a047d2490c0482be43e5070ea275 0 0 0 0 0  
874 874 20200911 NH 7620 219671   365645 7 720   228     6870 B 9/11/2020 09:00 2020-09-11T09:00:00Z 09/11 05:00 434 720 2020-09-11T09:00:00Z 365645     7620       227291 31004     30325             33 47 1585 227291 posNeg 3677 227291 0 1 5f603efaaca716e725a56f9715bcc3904c71cc04 0 0 0 0 0  
875 875 20200911 NJ 195888 2944898   3140786 483 22918 81   36   34345 A+ 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 16024 22918 2020-09-11T00:00:00Z 3140786     195888 14234 1790                         34 474 26658 3140786 posNeg 27132 3140786 9 30 a51e330aaf245911d7e147654e07aefc2734c8e4 0 0 0 0 0  
877 877 20200911 NV 72806 560476   633282 476   165   102   1930 A+ 9/11/2020 02:59 2020-09-11T02:59:00Z 09/10 22:59 1439   2020-09-11T02:59:00Z 922480     72806       632668                     32 260 5703 633282 posNeg 5963 633282 10 0 ebe95e00e6f3ae225ee25b8dd58753c2972c64c8 0 0 0 0 0  
879 879 20200911 OH 135326 2383887   2519213 650 14236 222 3081 131   113053 A+ 9/11/2020 14:00 2020-09-11T14:00:00Z 09/11 10:00 4403 14236 2020-09-11T14:00:00Z 2512184     128297 4110 293                         39 1240 27622 2519213 posNeg 28862 2519213 49 72 41e9a0a1d5723a4053bc00b4c02c38c6ffde3379 0 0 0 0 0  
880 880 20200911 OK 67642 907109 6696 974751 509 5369 208       57383 A+ 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 888 5369 2020-09-11T00:00:00Z 987322 78255 907109 67642         73173 3453                 40 942 12099 981447 posNeg 13041 974751 12 51 5c82a90b9cae9fd9718b3d1144292c1725c655e8 0 0 0 0 0  
881 881 20200911 OR 28865 576874   605739 161 2235 43   19   5310 A+ 9/11/2020 03:01 2020-09-11T03:01:00Z 09/10 23:01 499 2235 2020-09-11T03:01:00Z     576874 27460       604334                     41 211 8540 605739 posNeg 8751 605739 2 13 960d73e1e15c62a34e563958e2d8b907c86007a7 0 0 0 0 0  
882 882 20200911 PA 142885 1652028   1794913 491       64   117165 A+ 9/11/2020 12:00 2020-09-11T12:00:00Z 09/11 08:00 7837   2020-09-11T12:00:00Z 2474523     138759       1790787                     42 1008 12679 1794913 posNeg 13687 1794913 17 0 d97bf7929b588c557f9aadb78a561691b4a61f7f 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  
884 884 20200911 RI 22905 280118   615683 80 2620 8   3   2201 A+ 9/11/2020 12:00 2020-09-11T12:00:00Z 09/11 08:00 1071 2620 2020-09-11T12:00:00Z   32589 583094 22905     615683 303023                     44 123 1587 303023 totalTestEncountersViral 8777 303023 4 9 aedf60c2b75751dc16bb3653b109986e87862d0f 0 0 0 0 0  
887 887 20200911 TN 169859 2250520   2420379 965 7624 305   141   152674 A+ 9/11/2020 15:00 2020-09-11T15:00:00Z 09/11 11:00 2025 7624 2020-09-11T15:00:00Z 2415529 200561 2214968 165009 1957 68                         47 1622 25717 2420379 posNeg 27339 2420379 37 75 d229c70ebf99a74005fa5a2a474e7dc413a2b7e1 0 0 0 0 0  
888 888 20200911 TX 653356 4800685   5454041 3465   1198       568067 A+ 9/11/2020 16:25 2020-09-11T16:25:00Z 09/11 12:25 13997   2020-09-11T16:25:00Z 5454041     653356         380352 33010             43841 6163 48 3547 45237 5454041 posNeg 48784 5454041 144 0 974f3e0dcda3886d8aac8415e75d839aac67c634 0 0 0 0 0  
889 889 20200911 UT 56675 651132   707807 170 3288 48 817   338 48021 A+ 9/11/2020 11:02 2020-09-11T11:02:00Z 09/11 07:02 431 3288 2020-09-11T11:02:00Z 887314     56675       707807             7681 1192 10170 1267 49 656 3385 707807 posNeg 4041 707807 1 15 054a8c9828f40edd610795bbe83dfb02e9d63870 0 0 0 0 0  
891 891 20200911 VI 1201 16849 16 18050             1124 C 9/11/2020 06:29 2020-09-11T06:29:00Z 09/11 02:29 18   2020-09-11T06:29:00Z 18066       18                           78 4 181 18066 posNeg 185 18050 0 0 051ea5e6a1fa414809a0ca43bf8d566e13315a5d 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  
894 894 20200911 WI 91625 1254034 144 1345659 326 6263 97 1074     75878 A+ 9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 1205 6263 2020-09-11T00:00:00Z       86250 1197 8   1340284                     55 1443 8586 1345803 posNeg 10029 1345659 4 41 00ce3fef4945c53a88a4fe76c7f0897cf4a38ccb 0 0 0 0 0  
896 896 20200911 WY 4264 82091   86355 12 227         3724 B 9/11/2020 17:31 2020-09-11T17:31:00Z 09/11 13:31 42 227 2020-09-11T17:31:00Z 126331 3663 122667 3605       85696                     56 65 991 86355 posNeg 1056 86355 0 3 6d4c991baa79c7f8edc4cd5fde61fdcf8567eb18 0 0 0 0 0  

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
);