states_daily_4pm_et

Table actions

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

73 rows where "dateChecked" is on date 2020-04-06

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCumulative, recovered, dataQualityGrade, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, totalTestEncountersViral, totalTestsPeopleViral, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestResultsSource, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-04-06 · 73 ✖
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
8740 8740 20200423 AS 0 3 17 3                 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00     2020-04-06T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 3799a1b2fa51e61cb9ed3b9ced8015dd3cbd92e7 0 0 0 0 0  
8796 8796 20200422 AS 0 3 17 3                 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00     2020-04-06T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 4d821f24592a2b4fc912f1a5054783df6c2d97d9 0 0 0 0 0  
8852 8852 20200421 AS 0 3 17 3                 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00     2020-04-06T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 8bac2457f5f74d9379d838feabe2e22495624093 0 0 0 0 0  
8908 8908 20200420 AS 0 3 17 3                 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00     2020-04-06T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 c1a6c2e8b637d5326443a6561f775a278319e23e 0 0 0 0 0  
8964 8964 20200419 AS 0 3 17 3                 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00     2020-04-06T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 f2ef55f3ce6734c57fca5d41aa24464bceb71e03 0 0 0 0 0  
9020 9020 20200418 AS 0 3 17 3                 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00     2020-04-06T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 e6978ab2e52457866a99aa0d129e7901d74a12d9 0 0 0 0 0  
9076 9076 20200417 AS 0 3 17 3                 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00     2020-04-06T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 72cf69d5c70f144df44cb3ee7ed3c154192f287f 0 0 0 0 0  
9132 9132 20200416 AS 0 3 17 3                 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00     2020-04-06T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 24e7d4aa437160db1e5addeef1e95796925ad5ec 0 0 0 0 0  
9188 9188 20200415 AS 0 3 17 3                 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00     2020-04-06T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 00914dbfdcb2378c155dfb4eed1ce33ee7951ae4 0 0 0 0 0  
9244 9244 20200414 AS 0 3 17 3                 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00     2020-04-06T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 7af318448a5847451ffc9469743cd67de3af9eaf 0 0 0 0 0  
9300 9300 20200413 AS 0 3   3                 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00     2020-04-06T00:00:00Z 3     0                             60 0 0 3 posNeg 0 3 0 0 c6b06661f3819320dd6c55a3bd69ed8d000abbb4 0 0 0 0 0  
9468 9468 20200410 AS 0 3 2 3                 4/6/2020 16:00 2020-04-06T16:00:00Z 04/06 12:00 0   2020-04-06T16:00:00Z 3     0                             60 0 0 5 posNeg 0 3 0 0 4179f6ea0485f707e82fe3b47b570f690b034e24 0 0 0 0 0  
9524 9524 20200409 AS 0 3 2 3                 4/6/2020 16:00 2020-04-06T16:00:00Z 04/06 12:00 0   2020-04-06T16:00:00Z 3     0                             60 0 0 5 posNeg 0 3 0 0 b5d66885a54804cb22be1a11efc44efcc3095644 0 0 0 0 0  
9580 9580 20200408 AS 0 3 2 3                 4/6/2020 16:00 2020-04-06T16:00:00Z 04/06 12:00 0   2020-04-06T16:00:00Z 3     0                             60 0 0 5 posNeg 0 3 0 0 94df3e7e7c82359763e0c807d9f719611d845e93 0 0 0 0 0  
9636 9636 20200407 AS 0 3 2 3                 4/6/2020 16:00 2020-04-06T16:00:00Z 04/06 12:00 0   2020-04-06T16:00:00Z 3     0                             60 0 0 5 posNeg 0 3 0 0 74dc82a8afe625724b7b3b3b6c65d1d023544269 0 0 0 0 0  
9639 9639 20200407 CO 5172 21703   28901 786 994           A 4/6/2020 18:00 2020-04-06T18:00:00Z 04/06 14:00 150 994 2020-04-06T18:00:00Z             28901 26875                     8 222 880 26875 totalTestEncountersViral 1202 26875 10 70 b04c936ba6186a389fd61279f0fd67ed857f9be5 0 0 0 0 0  
9641 9641 20200407 DC 1211 6612   7823             318 A 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00 22   2020-04-06T00:00:00Z             7823                       11 114 256 7823 posNeg 370 7823 -2 0 c2a3d07db2711f8cac048547c605958c4fcc5c0f 0 0 0 0 0  
9646 9646 20200407 HI 387 13155   13542   26   6     89 A 4/6/2020 18:00 2020-04-06T18:00:00Z 04/06 14:00 5 26 2020-04-06T18:00:00Z                                     15 16 0 13542 posNeg 16 13542 1 5 ee804d0132561aae71143e2e92290e97728e8b51 0 0 0 0 0  
9648 9648 20200407 ID 1170 10076   11246 67 83   21       A 4/6/2020 19:00 2020-04-06T19:00:00Z 04/06 15:00 13 83 2020-04-06T19:00:00Z 11246                                   16 69 182 11246 posNeg 251 11246 3 6 8c89b6a5b4165962423c99fa77100190b9f1f36a 0 0 0 0 0  
9650 9650 20200407 IN 5507 23257   28764     924   507     B 4/6/2020 23:59 2020-04-06T23:59:00Z 04/06 19:59 173   2020-04-06T23:59:00Z                                     18 563 2010 28764 posNeg 2573 28764 34 0 7cdcbe147d2a3cacfd3b6d68a4aada11bf4e408f 0 0 0 0 0  
9652 9652 20200407 KY 1008 18947   19955               A 4/6/2020 17:00 2020-04-06T17:00:00Z 04/06 13:00 59   2020-04-06T17:00:00Z 19955                                   21 53 1135 19955 posNeg 1188 19955 14 0 4511fd6a5d4b490cd068b8f379d751162fe6e4b9 0 0 0 0 0  
9658 9658 20200407 MN 1432 30603   32035 120 242 64 100     515 A 4/6/2020 17:00 2020-04-06T17:00:00Z 04/06 13:00 34 242 2020-04-06T17:00:00Z       1432     32035                       27 102 1448 32035 posNeg 1550 32035 4 19 2314b0f857cd939f1a38e3cdeea9a32a43c3cd1f 0 0 0 0 0  
9666 9666 20200407 NH 715 8019 49 9457   103         151 B 4/6/2020 09:00 2020-04-06T09:00:00Z 04/06 05:00 9 103 2020-04-06T09:00:00Z 9457                                   33 46 318 8783 posNeg 360 8734 0 11 6d8e46e0a64ad966a40330121258e724f9fac78c 0 0 0 0 0  
9668 9668 20200407 NM 686 21139   21825 48       18   133 A 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00 12   2020-04-06T00:00:00Z                                     35 62 2627 21825 posNeg 2689 21825 0 0 45c05907cd53e664c42066d7bb8a4c9cdacade18 0 0 0 0 0  
9670 9670 20200407 NY 138863 201195   340058 17493 36932 4539       14590 A 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00 5489 36932 2020-04-06T00:00:00Z                                     36 8174 11073 340058 posNeg 19247 340058 731 2555 5d0b2add92c1cbdd6b03f5b591b6f985edd9379a 0 0 0 0 0  
9673 9673 20200407 OR 1181 21826   23007   324     69     A 4/6/2020 11:00 2020-04-06T11:00:00Z 04/06 07:00 33 324 2020-04-06T11:00:00Z                                     41 49 1157 23007 posNeg 1206 23007 6 66 bb73140c612d842aa874fb592c5e59c71d60b6bc 0 0 0 0 0  
9678 9678 20200407 SD 320 5948 2 6268   23         98 A 4/6/2020 18:00 2020-04-06T18:00:00Z 04/06 14:00 6 23 2020-04-06T18:00:00Z               6268                     46 32 216 6270 posNeg 248 6268 2 0 c83a9bfd04eb1523e5f7d821895cd2dc07698756 0 0 0 0 0  
9680 9680 20200407 TX 8262 80387   88649 1252           38 A 4/6/2020 21:00 2020-04-06T21:00:00Z 04/06 17:00 154   2020-04-06T21:00:00Z       8262                             48 986 2306 88649 posNeg 3292 88649 14 0 627be0529d19577c69a021877dc1622dc1aa31ef 0 0 0 0 0  
9682 9682 20200407 VA 3333 25312   39319   563   145   108   A 4/6/2020 17:00 2020-04-06T17:00:00Z 04/06 13:00 63 563 2020-04-06T17:00:00Z   6533         39319                       51 455 3669 28645 posNeg 2962 28645 9 66 6adcc862ab8975ae1c7841e3f59b5253ffc5175f 0 0 0 0 0  
9683 9683 20200407 VI 43 222 20 265             36   4/6/2020 21:50 2020-04-06T21:50:00Z 04/06 17:50 1   2020-04-06T21:50:00Z                                     78 0 0 285 posNeg 0 265 0 0 c0550c8f57bfeda2464a64dd12d255d8890bb0df 0 0 0 0 0  
9689 9689 20200406 AK 191 6692   6883   23           A 4/6/2020 14:45 2020-04-06T14:45:00Z 04/06 10:45 6 23 2020-04-06T14:45:00Z 6883     191                             2 6 593 6883 posNeg 599 6883 0 3 52a151687cac19c75619e73f464e608e03bf8570 0 0 0 0 0  
9690 9690 20200406 AL 1968 12797   14765 297 240           B 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00 50 240 2020-04-06T00:00:00Z 14765     1968                             1 172 1515 14765 posNeg 1687 14765 5 9 553875d7d594ebfa948fe65a268a118bf55127ba 0 0 0 0 0  
9691 9691 20200406 AR 875 11970   12845 74 137     22 39 102 A 4/6/2020 14:35 2020-04-06T14:35:00Z 04/06 10:35 16 137 2020-04-06T14:35:00Z 12845     875                             5 45 1558 12845 posNeg 1603 12845 0 7 c1a20ec880c10833168a57803517d881e0a7db84 0 0 0 0 0  
9692 9692 20200406 AS 0 3 2 3                 4/6/2020 16:00 2020-04-06T16:00:00Z 04/06 12:00 0   2020-04-06T16:00:00Z 3     0                             60 0 0 5 posNeg 0 3 0 0 f27aaf8008b12ddd3f887f9c1fd4f69f706d9881 0 0 0 0 0  
9693 9693 20200406 AZ 2456 30078   32534   819           B 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00 65 819 2020-04-06T00:00:00Z               32534                     4 187 4937 32534 posNeg 5124 32534 1 59 37565bd63c7229b27e88b85c67b4a6494a3f4146 0 0 0 0 0  
9694 9694 20200406 CA 14336 103095 15000 117431 2509   1085         B 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00 343   2020-04-06T00:00:00Z 117431                                   6 898 0 132431 posNeg 898 117431 24 0 04ff2dc4dce6a30fc9a998902f13f2806ee2cacc 0 0 0 0 0  
9696 9696 20200406 CT 6906 19780   26686 1221             A 4/6/2020 15:15 2020-04-06T15:15:00Z 04/06 11:15 206   2020-04-06T15:15:00Z 26686       85                           9 1231 2185 26686 posNeg 3416 26686 17 0 359282bec3c8cd039f2a7d21df8d2f5e72a526f8 0 0 0 0 0  
9699 9699 20200406 FL 13324 109950 1142 123274   1682           A 4/6/2020 12:17 2020-04-06T12:17:00Z 04/06 08:17 236 1682 2020-04-06T12:17:00Z                                     12 1173 8697 124416 posNeg 9870 123274 18 110 e1ff125c2b0f7e3889ee69f811a908b5c213dea6 0 0 0 0 0  
9700 9700 20200406 GA 7314 23960   31274   1332           A 4/6/2020 11:28 2020-04-06T11:28:00Z 04/06 07:28 229 1332 2020-04-06T11:28:00Z 31274                                   13 667 2775 31274 posNeg 3442 31274 18 49 cc409f882d6bfe4f2ad30a2a8311dbea0fed76e4 0 0 0 0 0  
9701 9701 20200406 GU 113 505   618 21   2       25   4/6/2020 06:00 2020-04-06T06:00:00Z 04/06 02:00 4   2020-04-06T06:00:00Z                                     66 1 12 618 posNeg 13 618 0 0 5dcd4d1d86006579e52f838b3d1caca4ee460e7f 0 0 0 0 0  
9703 9703 20200406 IA 946 10653   11599 99 179         284 A 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00 25 179 2020-04-06T00:00:00Z       946                             19 78 680 11599 posNeg 758 11599 3 14 723be82b5173f043443056ea3d3323a855515970 0 0 0 0 0  
9705 9705 20200406 IL 12262 50680   62942               A 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00 307   2020-04-06T00:00:00Z                                     17 1006 2953 62942 posNeg 3959 62942 33 0 12969db5ed2c47bab8ecce33478006b3678f0377 0 0 0 0 0  
9706 9706 20200406 IN 4944 21247   26191     924   507     B 4/6/2020 14:00 2020-04-06T14:00:00Z 04/06 10:00 139   2020-04-06T14:00:00Z                                     18 533 3006 26191 posNeg 3539 26191 12 0 4e6813a1847225f70285569c16378fa5f00c861e 0 0 0 0 0  
9707 9707 20200406 KS 845 8239   9084   198           B 4/6/2020 12:00 2020-04-06T12:00:00Z 04/06 08:00 25 198 2020-04-06T12:00:00Z                                     20 98 763 9084 posNeg 861 9084 3 15 c834086e9d1326400ac2e753b94b1b60c0368641 0 0 0 0 0  
9709 9709 20200406 LA 14867 54299   69166 1981       552     A 4/6/2020 13:00 2020-04-06T13:00:00Z 04/06 09:00 512   2020-04-06T13:00:00Z       14867                             22 1857 6984 69166 posNeg 8841 69166 35 0 98993b3cef8a12d26832cfa7dd931a7f98eb0937 0 0 0 0 0  
9710 9710 20200406 MA 13739 62720   98567 1667 1667           B 4/6/2020 12:30 2020-04-06T12:30:00Z 04/06 08:30 448 1667 2020-04-06T12:30:00Z 98567 19472                                 25 1337 3155 76459 totalTestsViral 7580 76459 78 35 4a24ee0b171e8746c033bdfb10fc049b8e828ae0 0 0 0 0 0  
9711 9711 20200406 MD 4045 25572   29617   1059         184 A 4/6/2020 10:00 2020-04-06T10:00:00Z 04/06 06:00 138 1059 2020-04-06T10:00:00Z 32438 5070   4045 131 7                         24 436 844 29617 posNeg 1280 29617 16 123 cb8f7e6c0208e132cc392c870e12aa3ca3179727 0 0 0 0 0  
9712 9712 20200406 ME 499 6088   6587   92         158 A 4/6/2020 11:00 2020-04-06T11:00:00Z 04/06 07:00 10 92 2020-04-06T11:00:00Z       499                             23 29 0 6587 posNeg 29 6587 0 6 4202bba526abd0c5b490ee8391b84bc527f5c887 0 0 0 0 0  
9713 9713 20200406 MI 25785 47262   73047             56 B 4/6/2020 11:00 2020-04-06T11:00:00Z 04/06 07:00 1291   2020-04-06T11:00:00Z 72281 25019 47262 25186 1377 66                         26 1327 3108 73047 posNeg 4435 73047 141 0 1d4478a8443ef9a8a3cb9b9a939a4e3a71e4c998 0 0 0 0 0  
9714 9714 20200406 MN 1330 29155   30485 115 223 57 90     440 A 4/6/2020 17:11 2020-04-06T17:11:00Z 04/06 13:11 30 223 2020-04-06T17:11:00Z       1330     30485                       27 113 1065 30485 posNeg 1178 30485 1 21 19523769bc0fe114f970201760fafbf72055b45e 0 0 0 0 0  
9715 9715 20200406 MO 2722 27113   29835 439             A 4/6/2020 16:28 2020-04-06T16:28:00Z 04/06 12:28 39   2020-04-06T16:28:00Z 31954 3673 28257 2722               2 0 2         29 355 2231 29835 posNeg 2586 29835 5 0 599bd1c377d5799809c872d7b2ef8036d28ae665 0 0 0 0 0  
9716 9716 20200406 MP 8 13 10 21                 4/6/2020 02:57 2020-04-06T02:57:00Z 04/05 22:57 1   2020-04-06T02:57:00Z                                     69 0 0 31 posNeg 0 21 0 0 4a375bba82f8b1054acd42e4e09d1b72b81fbac2 0 0 0 0 0  
9717 9717 20200406 MS 1738 18632   20370   475           A 4/6/2020 16:33 2020-04-06T16:33:00Z 04/06 12:33 51 475 2020-04-06T16:33:00Z                                     28 100 13052 20370 posNeg 13152 20370 8 0 47eb5ac61115552e9436a9d2e021cae15e3860c6 0 0 0 0 0  
9718 9718 20200406 MT 299 6491   6790   24           A 4/6/2020 10:00 2020-04-06T10:00:00Z 04/06 06:00 6 24 2020-04-06T10:00:00Z 6789                                   30 13 174 6790 posNeg 187 6790 0 0 1c12040f8d81c248dbef9296b5905ba30dcaaf38 0 0 0 0 0  
9719 9719 20200406 NC 2870 37856   40726 270             A 4/6/2020 11:00 2020-04-06T11:00:00Z 04/06 07:00 33   2020-04-06T11:00:00Z                                     37 285 396 40726 posNeg 681 40726 2 0 d47532c7e9cf025cb8b3c9d66b344fd7ddc8f487 0 0 0 0 0  
9720 9720 20200406 ND 225 6988   7117 19 32         74 B 4/6/2020 13:05 2020-04-06T13:05:00Z 04/06 09:05 3 32 2020-04-06T13:05:00Z 7169     225     7117 6815                     38 18 408 7213 totalTestEncountersViral 357 7213 0 1 0739bef19dd62f78fdb7b01f92721d36d8454ffd 0 0 0 0 0  
9721 9721 20200406 NE 409 6378 8 6787               A 4/6/2020 13:38 2020-04-06T13:38:00Z 04/06 09:38 8   2020-04-06T13:38:00Z               6796                     31 46 820 6795 posNeg 866 6787 0 0 5a7102f309e6e017f4c7bafc1475be93491b5b8b 0 0 0 0 0  
9723 9723 20200406 NJ 41090 47942   89032 6390       1263     A 4/6/2020 13:00 2020-04-06T13:00:00Z 04/06 09:00 1334   2020-04-06T13:00:00Z       41090 1003 331   89032                     34 3585 3281 89032 posNeg 6866 89032 150 0 9a920d0629bc059ab0e7fe69857288d8eda666fa 0 0 0 0 0  
9724 9724 20200406 NM 624 18512   19136 45       18   130 A 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00 12   2020-04-06T00:00:00Z                                     35 81 2227 19136 posNeg 2308 19136 1 0 01229f89eb6ca1a7484c83d0110027d6ecb760fc 0 0 0 0 0  
9725 9725 20200406 NV 1953 15676   17629               A 4/6/2020 10:00 2020-04-06T10:00:00Z 04/06 06:00 79   2020-04-06T10:00:00Z 20756     1953                             32 117 681 17629 posNeg 798 17629 3 0 5e2d2c953710316715d2e40c1532863506892e85 0 0 0 0 0  
9726 9726 20200406 NY 130689 190122   320811 16837 34377 4504       13366 A 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00 4758 34377 2020-04-06T00:00:00Z                                     36 8658 9873 320811 posNeg 18531 320811 599 2084 e64aac0c40444783360cb8fd4ad6eeeb4beb57e8 0 0 0 0 0  
9727 9727 20200406 OH 4450 43928   48378   1214   371       B 4/6/2020 14:00 2020-04-06T14:00:00Z 04/06 10:00 142 1214 2020-04-06T14:00:00Z       4450                             39 407 4215 48378 posNeg 4622 48378 23 110 0a5b4b72697420e6d83eb85f626f61f4480fa7fa 0 0 0 0 0  
9728 9728 20200406 OK 1327 1422   2749 161 340 143       522 B 4/6/2020 08:00 2020-04-06T08:00:00Z 04/06 04:00 51 340 2020-04-06T08:00:00Z                                     40 75 21 2749 posNeg 96 2749 5 10 f93b39ad36cf4fbe089ee2f120c7d68374a6954a 0 0 0 0 0  
9730 9730 20200406 PA 12980 70874   83854   1145     533     A 4/6/2020 12:00 2020-04-06T12:00:00Z 04/06 08:00 162 1145 2020-04-06T12:00:00Z               83854                     42 1470 4613 83854 posNeg 6083 83854 12 73 95e2c8e2d5cbc4ff52ddb322d046799fefc617ec 0 0 0 0 0  
9731 9731 20200406 PR 513 3432 1000 3945               A 4/6/2020 07:00 2020-04-06T07:00:00Z 04/06 03:00 21   2020-04-06T07:00:00Z                                     72 38 359 4945 posNeg 397 3945 1 0 5d4c443e8b142e175c8d7069dc777785287ac649 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  
9734 9734 20200406 SD 288 5732 0 6020   23         91 A 4/6/2020 12:30 2020-04-06T12:30:00Z 04/06 08:30 4 23 2020-04-06T12:30:00Z               6020                     46 48 379 6020 posNeg 427 6020 2 1 9ce3961ea917fe637f9af4165e467f72f9db7a9c 0 0 0 0 0  
9735 9735 20200406 TN 3802 43548   47350 834 352         356 A 4/6/2020 15:00 2020-04-06T15:00:00Z 04/06 11:00 65 352 2020-04-06T15:00:00Z                                     47 169 1881 47350 posNeg 2050 47350 21 24 122886a8e3f87484fbaeb039661cd81476a51e69 0 0 0 0 0  
9740 9740 20200406 VT 575 6161   6736 28 45         15 A 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00 23 45 2020-04-06T00:00:00Z       575                             50 32 331 6736 posNeg 363 6736 1 0 785fa843f0cdbaebb3a817a5f0157d6b49bd93ec 0 0 0 0 0  
9741 9741 20200406 WA 8983 104793   113776 638   191         A 4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00 407   2020-04-06T00:00:00Z       8983     113776 109573                     53 394 4989 113776 posNeg 5383 113776 21 0 0ff8fdcc56f52234091637acc0331256ac4e7e98 0 0 0 0 0  
9742 9742 20200406 WI 2866 26574   29440 300 668 136 186       A 4/6/2020 16:00 2020-04-06T16:00:00Z 04/06 12:00 77 668 2020-04-06T16:00:00Z       2440                             55 223 1405 29440 posNeg 1628 29440 9 44 517bc11189bc880a6068b48fd7c88030fa35c91c 0 0 0 0 0  
9743 9743 20200406 WV 345 9595   9940               B 4/6/2020 10:00 2020-04-06T10:00:00Z 04/06 06:00 4   2020-04-06T10:00:00Z       345                             54 21 1081 9940 posNeg 1102 9940 1 0 6c8dd9b6e59b1e177316d3467a83f68f89aed6a7 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  

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