states_daily_4pm_et

Table actions

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

73 rows where "dateModified" is on date 2020-04-06 sorted by totalTestsPeopleViral

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, hospitalizedCurrently, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, recovered, dataQualityGrade, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateChecked (date)

dateModified (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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  

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