states_daily_4pm_et

Table actions

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

63 rows where "dateChecked" is on date 2020-05-22

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, dateChecked, positiveTestsViral, negativeTestsViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-05-22 · 63 ✖
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
6995 6995 20200525 VI 69 1343 45 1412             61 C 5/22/2020 07:29 2020-05-22T07:29:00Z 05/22 03:29 6   2020-05-22T07:29:00Z 1457       6                           78 0 0 1457 posNeg 0 1412 0 0 2f57190cb25c46b394495b294e120a2e8954b334 0 0 0 0 0  
7009 7009 20200524 DC 7966 44025   40803 324   110   73   1075 A+ 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 427   2020-05-22T00:00:00Z             40803 33576                     11 0 0 51991 posNeg 1875 51991 0 0 ee54fa0fac7e0731e58611ea368ab615830b462b 0 0 0 0 0  
7019 7019 20200524 KS 8958 67476   76434   787   269   120 485 A+ 5/22/2020 10:00 2020-05-22T10:00:00Z 05/22 06:00 185 787 2020-05-22T10:00:00Z               76280                     20 0 0 76434 posNeg 0 76434 0 0 f941cb902ed9db6a88ff0a878299ae203db32e3b 0 0 0 0 0  
7051 7051 20200524 VI 69 1343 45 1412             61 C 5/22/2020 07:29 2020-05-22T07:29:00Z 05/22 03:29 6   2020-05-22T07:29:00Z 1457       6                           78 0 0 1457 posNeg 0 1412 0 0 47ec158c14c612a7e43ad9cb7c331d4c7cea0f81 0 0 0 0 0  
7063 7063 20200523 CO 23487 121465   162468 571 4082         3612 A 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 1088 4082 2020-05-22T00:00:00Z       21202     162468 142667 44103 3448 40655               8 296 2431 144952 totalTestEncountersViral 3550 144952 26 45 36b54cb4a0444d31c342519cc4edf316bf5ae04a 0 0 0 0 0  
7064 7064 20200523 CT 40022 168345   208367 724 12538         7127 B 5/22/2020 20:30 2020-05-22T20:30:00Z 05/22 16:30 3675 12538 2020-05-22T20:30:00Z 214136             208367                     9 382 5657 208367 posNeg 6039 208367 38 0 2cc9fb0ffbc5e88bc4e3c6b8dff30d60f44965f6 0 0 0 0 0  
7065 7065 20200523 DC 7966 44025   38928 324   110   73   1075 A+ 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 427   2020-05-22T00:00:00Z             38928 32735                     11 73 8925 51991 posNeg -4065 51991 9 0 8985fb064dc58328bc6671e18fdc82a6ef87c387 0 0 0 0 0  
7066 7066 20200523 DE 8690 41844   50534 210           4454 B 5/22/2020 18:00 2020-05-22T18:00:00Z 05/22 14:00 425   2020-05-22T18:00:00Z         371 54   50534                     10 161 1387 50534 posNeg 1548 50534 5 0 c43adc27750d72b3e40dc55d20f1fbdd5f48b2a6 0 0 0 0 0  
7070 7070 20200523 HI 642 48179   48821   84         585 C 5/22/2020 18:00 2020-05-22T18:00:00Z 05/22 14:00 17 84 2020-05-22T18:00:00Z 48821                                   15 -5 841 48821 posNeg 836 48821 0 1 08bf679383709f862912db1d208e170341c7dca3 0 0 0 0 0  
7072 7072 20200523 ID 2595 38014   40370 19 225   94     1735 A 5/22/2020 19:00 2020-05-22T19:00:00Z 05/22 15:00 79 225 2020-05-22T19:00:00Z 40370     2356 59 20                         16 61 953 40609 posNeg 1008 40609 2 2 607608f29120e93748a6d2ffbcbc8e1f5fb92cfa 0 0 0 0 0  
7073 7073 20200523 IL 107796 614451   722247 3753   1027   607     A 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 4790   2020-05-22T00:00:00Z       107796 4790     722247                     17 2352 22762 722247 posNeg 25114 722247 75 0 55b642e48d789570bc3e4a3397812c57e4422937 0 0 0 0 0  
7074 7074 20200523 IN 30901 184032   214933 1138 5285 403 1166 173     A+ 5/22/2020 23:59 2020-05-22T23:59:00Z 05/22 19:59 1943 5285 2020-05-22T23:59:00Z         1812 152   214933                     18 492 5880 214933 posNeg 6372 214933 2 0 ffe9925bd2e12d4ee2743bcfc91802bd3610f8cb 0 0 0 0 0  
7075 7075 20200523 KS 8958 67476   76434   787   269   120 485 A+ 5/22/2020 10:00 2020-05-22T10:00:00Z 05/22 06:00 185 787 2020-05-22T10:00:00Z               76280                     20 0 0 76434 posNeg 0 76434 0 0 17cce5d954a4f7b9646f5b80a94e8da0d1a6c80b 0 0 0 0 0  
7076 7076 20200523 KY 8426 163033   171338 477 2076 90 889     3069 A 5/22/2020 17:00 2020-05-22T17:00:00Z 05/22 13:00 391 2076 2020-05-22T17:00:00Z 171338     8305 390 1                         21 140 5079 171459 posNeg 5098 171459 5 35 a5fe0aaac0d47961d32f90e9cbf6bd87eb20e349 0 0 0 0 0  
7081 7081 20200523 MI 61293 455556   516849 953   449   319   33168 A+ 5/22/2020 11:00 2020-05-22T11:00:00Z 05/22 07:00 5612   2020-05-22T11:00:00Z 527621 72065 455556 56612 5402 237     61973                   26 218 14274 516849 posNeg 14492 516849 26 0 f59dd01a3442760056b87220e5fbef33b671fb40 0 0 0 0 0  
7082 7082 20200523 MN 22765 194941   217706 568 2534 215 832     13485 A 5/22/2020 17:00 2020-05-22T17:00:00Z 05/22 13:00 861 2534 2020-05-22T17:00:00Z       22765 852 9 217706                       27 391 8505 217706 posNeg 8896 217706 10 102 b406a5ec715eb714a9d07404a819ff148c6a4d21 0 0 0 0 0  
7084 7084 20200523 MP 22 4296   4318             13 D 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 2   2020-05-22T00:00:00Z 4318     22                             69 0 0 4318 posNeg 0 4318 0 0 067206a8163c59163af260353992b0261315540f 0 0 0 0 0  
7085 7085 20200523 MS 13005 121215   134220 590 1996 154   93   7681 A 5/22/2020 19:00 2020-05-22T19:00:00Z 05/22 15:00 616 1996 2020-05-22T19:00:00Z 134220               8813 80                 28 381 -4134 134220 posNeg -3753 134220 20 30 49491cbfb4a5a44fb0c5a5c850b5676b044cf79a 0 0 0 0 0  
7089 7089 20200523 NE 11662 68320   79982               D 5/22/2020 19:45 2020-05-22T19:45:00Z 05/22 15:45 147   2020-05-22T19:45:00Z       11662       80475                     31 237 1326 79982 posNeg 1563 79982 4 0 21735036451b7772ee36b01ff7c3017780d5d553 0 0 0 0 0  
7092 7092 20200523 NM 6625 151758   158383 206 1139         2149 C 5/22/2020 17:58 2020-05-22T17:58:00Z 05/22 13:58 302 1139 2020-05-22T17:58:00Z 158383     6625                             35 153 5463 158383 posNeg 5616 158383 8 0 b8f23616beb787cca73969cd91999b8cfaca3dac 0 0 0 0 0  
7094 7094 20200523 NY 359926 1292135   1652061 4642 88083 1502   1254   63292 A 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 23282 88083 2020-05-22T00:00:00Z       359926     1652061                       36 1772 49496 1652061 posNeg 51268 1652061 87 240 ba333020bd7851eff068c6b2bc1cc46db0e19b64 0 0 0 0 0  
7102 7102 20200523 SD 4468 29060   33528 90 358         3336 C 5/22/2020 18:00 2020-05-22T18:00:00Z 05/22 14:00 50 358 2020-05-22T18:00:00Z               33528                     46 112 1072 33528 posNeg 1184 33528 0 7 b9faf951a8705d00e6b6f13052952471c6abeb27 0 0 0 0 0  
7104 7104 20200523 TX 54509 708197   762706 1688           32277 B 5/22/2020 17:00 2020-05-22T17:00:00Z 05/22 13:00 1506   2020-05-22T17:00:00Z 762706     54509         60252 2463                 48 1060 20284 762706 posNeg 21344 762706 26 0 99f33878612ab98288d56ee3a73dc13774ab893a 0 0 0 0 0  
7106 7106 20200523 VA 35749 196721 409 276297 1384 6431 330   213   5047 A+ 5/22/2020 17:00 2020-05-22T17:00:00Z 05/22 13:00 1159 6431 2020-05-22T17:00:00Z   45359   33962 1123 36 276297                       51 799 6496 232879 posNeg 10630 232470 23 9 bd76677ba9b979c04e7b52ca0f5146076662704e 0 0 0 0 0  
7107 7107 20200523 VI 69 1343 45 1412             61 C 5/22/2020 07:29 2020-05-22T07:29:00Z 05/22 03:29 6   2020-05-22T07:29:00Z 1457       6                           78 0 0 1457 posNeg 0 1412 0 0 3d4a0de54c6f960c147e3ec8c9fa22ffb2212cba 0 0 0 0 0  
7109 7109 20200523 WA 20986 320020   341006 332 3230     96     B 5/22/2020 02:59 2020-05-22T02:59:00Z 05/21 22:59 1050 3230 2020-05-22T02:59:00Z       20986 1050   341006 304123                     53 149 3201 341006 posNeg 3350 341006 6 74 fc7f3efc74e70d607514b2db600169a7c426442b 0 0 0 0 0  
7113 7113 20200522 AK 404 41042   41446 15           356 C 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 10   2020-05-22T00:00:00Z 41446     404 10                           2 2 1899 41446 posNeg 1901 41446 0 0 2386d42b882a13c7c4a1d893d3af92caaea4a635 0 0 0 0 0  
7114 7114 20200522 AL 13563 164205   177768 598 1561   531   315 7951 B 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 537 1561 2020-05-22T00:00:00Z 177768     13563 537                           1 444 6585 177768 posNeg 7029 177768 8 33 0f832eb95e0a8cef7d787ec7382fcdf7c4adcc8a 0 0 0 0 0  
7115 7115 20200522 AR 5612 97435   103047 86 584     14 110 4029 A 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 113 584 2020-05-22T00:00:00Z 103047     5612                             5 154 3617 103047 posNeg 3771 103047 3 49 673ddc95d69193d3d77eb3244e8765e2dc42cc03 0 0 0 0 0  
7117 7117 20200522 AZ 15608 160395   176003 796 2943 311   203   3949 A+ 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 775 2943 2020-05-22T00:00:00Z               176003 69483                   4 293 4083 176003 posNeg 4376 176003 12 58 10fd128b5645600b7b8e5edc0744e1068a2510bb 0 0 0 0 0  
7119 7119 20200522 CO 23191 119034   158918 620 4037         3580 A 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 1062 4037 2020-05-22T00:00:00Z       20903     158918 139937 41457 3315 38142               8 394 6220 142225 totalTestEncountersViral 5121 142225 61 47 b0b95e8a0346f9453dda5a048c5c1bdc16543581 0 0 0 0 0  
7123 7123 20200522 FL 49451 786045 1487 835496   9372           A 5/22/2020 09:39 2020-05-22T09:39:00Z 05/22 05:39 2268 9372 2020-05-22T09:39:00Z 940758 66424 871876 49451 2268     837172                     12 776 20791 836983 posNeg 21567 835496 46 172 b80d3da000829ca57f3312d00a396966aac85de0 0 0 0 0 0  
7124 7124 20200522 GA 41218 386031   427249 889 7313   1658       A 5/22/2020 13:00 2020-05-22T13:00:00Z 05/22 09:00 1785 7313 2020-05-22T13:00:00Z 427249     41218                             13 813 18705 427249 posNeg 19518 427249 31 78 6d2f50cd95a0678953f0faebde75029e281af851 0 0 0 0 0  
7125 7125 20200522 GU 165 5114   5279             125 C 5/22/2020 05:35 2020-05-22T05:35:00Z 05/22 01:35 5   2020-05-22T05:35:00Z 5331   5037 160       5279                     66 0 215 5279 posNeg 215 5279 0 0 f26f74608ea996e606d7f8a6db67da026b485c1b 0 0 0 0 0  
7127 7127 20200522 IA 16504 103746   120250 362   123   79   9079 A+ 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 425   2020-05-22T00:00:00Z       16504       120514       13818 1725 12090         19 334 3351 120250 posNeg 3685 120250 19 0 ac9c52764eb40a12a28de886f49c97add151983c 0 0 0 0 0  
7129 7129 20200522 IL 105444 591689   697133 3928   1060   589     A 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 4715   2020-05-22T00:00:00Z       105444 4715     697133                     17 2758 22355 697133 posNeg 25113 697133 108 0 263224211fa870b08f27909ef13a31a4ef93b914 0 0 0 0 0  
7131 7131 20200522 KS 8958 67476   76434   787   269   120 485 A+ 5/22/2020 10:00 2020-05-22T10:00:00Z 05/22 06:00 185 787 2020-05-22T10:00:00Z               76280                     20 419 4812 76434 posNeg 5231 76434 7 27 565cec5545e6c6e6edd0dc41c9a13820966f19e2 0 0 0 0 0  
7133 7133 20200522 LA 36925 274883   311808 867       104   26249 B 5/22/2020 13:00 2020-05-22T13:00:00Z 05/22 09:00 2668   2020-05-22T13:00:00Z       36925 2545 123   311808                     22 421 6006 311808 posNeg 6427 311808 39 0 d313861f63d0af35c6386d613f6015a9923c767c 0 0 0 0 0  
7134 7134 20200522 MA 90889 420755   664312 2323 9162 628         A 5/22/2020 10:00 2020-05-22T10:00:00Z 05/22 06:00 6228 9162 2020-05-22T10:00:00Z 664312 117464   90889 6228     511644                     25 805 9353 511644 totalTestsViral 14811 511644 80 122 a5f85f5dc23df0e62708f5f372bc074c12bc92e5 0 0 0 0 0  
7135 7135 20200522 MD 44424 183478   227902 1329 7634 506       3243 B 5/22/2020 10:00 2020-05-22T10:00:00Z 05/22 06:00 2274 7634 2020-05-22T10:00:00Z 251847 50019   44424 2169 105   227902                     24 893 6776 227902 posNeg 7669 227902 53 149 b5c434324c34741a683d0c09b61aa0b4190041c5 0 0 0 0 0  
7136 7136 20200522 ME 1948 35450   37398 45 240 21   12   1192 B 5/22/2020 12:30 2020-05-22T12:30:00Z 05/22 08:30 75 240 2020-05-22T12:30:00Z 37725 2201 35450 1749 75     28357 2884 177 2704               23 71 0 37398 posNeg 71 37398 2 5 0129110807dd7d869dbea9bed19ddadbd0a4a299 0 0 0 0 0  
7137 7137 20200522 MI 61075 441282   502357 955   470   348   28234 A+ 5/22/2020 11:00 2020-05-22T11:00:00Z 05/22 07:00 5586   2020-05-22T11:00:00Z 512752 71470 441282 56445 5375 237                         26 465 19494 502357 posNeg 19959 502357 31 0 a547738afbdb6340fc225d9e8d1022bc2e2789c5 0 0 0 0 0  
7139 7139 20200522 MO 11558 161388   172946 711       93     B 5/22/2020 15:00 2020-05-22T15:00:00Z 05/22 11:00 671   2020-05-22T15:00:00Z 167199 14046 152883 11558       172946       16192 647 15520         29 218 10636 172946 posNeg 10854 172946 10 0 bd7409cf53d57beab625ad37cde617d790ee2315 0 0 0 0 0  
7140 7140 20200522 MP 22 4296   4318             13 D 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 2   2020-05-22T00:00:00Z 4318     22                             69 0 229 4318 posNeg 229 4318 0 0 15f3f42c050f1679f00b226d893ad2c579c20976 0 0 0 0 0  
7142 7142 20200522 MT 479 31378   31857 3 65         441 C 5/22/2020 12:05 2020-05-22T12:05:00Z 05/22 08:05 16 65 2020-05-22T12:05:00Z 31857     479                             30 0 1333 31857 posNeg 1333 31857 0 0 b3920710920141064e882bd7ce6d9c9320dd5190 0 0 0 0 0  
7143 7143 20200522 NC 21618 281606   303224 568           11637 A 5/22/2020 10:51 2020-05-22T10:51:00Z 05/22 06:51 728   2020-05-22T10:51:00Z 303224     21618 728                           37 758 11821 303224 posNeg 12579 303224 12 0 056543c1285887e76d916fb659e70b1a4b3f86ba 0 0 0 0 0  
7144 7144 20200522 ND 2235 60513   74611 39 147         1405 C 5/22/2020 13:00 2020-05-22T13:00:00Z 05/22 09:00 39 147 2020-05-22T13:00:00Z 76017     2235 39   74611 60764                     38 70 1463 62748 totalTestEncountersViral 2491 62748 1 3 c06f22c3510c7d01cc779f39608e8affaae1237b 0 0 0 0 0  
7147 7147 20200522 NJ 152719 402595   555314 3049   846   674   24491 A+ 5/22/2020 13:00 2020-05-22T13:00:00Z 05/22 09:00 12675   2020-05-22T13:00:00Z 555314     152719 10985 1690                         34 1247 9793 555314 posNeg 11040 555314 148 0 3556aa96b1dca62b987b2ce82741d9e4f0e5450a 0 0 0 0 0  
7149 7149 20200522 NV 7401 92540   99941 404   90   51   339 A+ 5/22/2020 09:30 2020-05-22T09:30:00Z 05/22 05:30 400   2020-05-22T09:30:00Z 117606     7401       99941                     32 146 5413 99941 posNeg 5559 99941 3 0 ce83242ba12109ad6f457e68af171d975344b0f0 0 0 0 0 0  
7150 7150 20200522 NY 358154 1242639   1600793 4844 87843 1581   1254   63292 A 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 23195 87843 2020-05-22T00:00:00Z       358154     1600793                       36 1696 44042 1600793 posNeg 45738 1600793 112 205 b77ebe13f6fade632f14183a564158d80a000db5 0 0 0 0 0  
7151 7151 20200522 OH 30794 277006   307800 879 5379 362 1416 232     B 5/22/2020 14:00 2020-05-22T14:00:00Z 05/22 10:00 1872 5379 2020-05-22T14:00:00Z 305764     28758 1691 181                         39 627 8095 307800 posNeg 8722 307800 36 84 a1c03586051d46718c56c3ab10442c47120e15a2 0 0 0 0 0  
7152 7152 20200522 OK 5849 147318   153167 190 926 94       4533 A+ 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 307 926 2020-05-22T00:00:00Z 152998 6589 146409 5849         13642 459                 40 169 3403 153167 posNeg 3572 153167 3 9 00db2bf5e3b208725599822c5bb5497710dda39d 0 0 0 0 0  
7153 7153 20200522 OR 3864 103975   107839 146 737 47   16   1376 A+ 5/22/2020 11:00 2020-05-22T11:00:00Z 05/22 07:00 147 737 2020-05-22T11:00:00Z       3770       107745                     41 47 2568 107839 posNeg 2615 107839 2 5 82d57aebbe5c29728c78cd59de49f0e110254c89 0 0 0 0 0  
7154 7154 20200522 PA 66258 312743   379001 1580       368   37767 A 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 4984   2020-05-22T00:00:00Z       64551       379001   481                 42 866 9229 379001 posNeg 10095 379001 115 0 04fd96b2575bd38b3576107366621bb053b0d2da 0 0 0 0 0  
7155 7155 20200522 PR 3030 40488   43518 96   12   6     B 5/22/2020 05:51 2020-05-22T05:51:00Z 05/22 01:51 126   2020-05-22T05:51:00Z 41701 1572 40095 1221 60 66       1809                 72 117 0 43518 posNeg 117 43518 0 0 3a37c15a29a8178632ea7741c71f7676525e6ec7 0 0 0 0 0  
7156 7156 20200522 RI 13949 87850   136692 242 1537 56   40   1084 A+ 5/22/2020 03:00 2020-05-22T03:00:00Z 05/21 23:00 579 1537 2020-05-22T03:00:00Z 138609 17749 120860 13949     136692 101799                     44 201 1451 101799 totalTestEncountersViral 4131 101799 23 31 714c7c136eadd874bf5b1c7cf53c7c40d35267f3 0 0 0 0 0  
7157 7157 20200522 SC 9638 140385   150023 429 1534         5743 A+ 5/22/2020 16:00 2020-05-22T16:00:00Z 05/22 12:00 419 1534 2020-05-22T16:00:00Z 154746 14361 140385 9638 419                           45 463 11322 150023 posNeg 11785 150023 12 90 182874edf9a4ff4517f86c336b04cc891c0a196e 0 0 0 0 0  
7159 7159 20200522 TN 19394 348776   368170 570 1560         12566 B 5/22/2020 15:00 2020-05-22T15:00:00Z 05/22 11:00 315 1560 2020-05-22T15:00:00Z       19394 315     368170                     47 433 7154 368170 posNeg 7587 368170 2 21 383ba635c8b6cbb1273e57ec5944471a6b92b60d 0 0 0 0 0  
7161 7161 20200522 UT 8057 178777   186834 163 660   210   88 4748 B 5/22/2020 15:00 2020-05-22T15:00:00Z 05/22 11:00 93 660 2020-05-22T15:00:00Z       8057       186834                     49 183 3777 186834 posNeg 3960 186834 1 13 efacc3e49302b47cfd91f62e07026ab19bac4234 0 0 0 0 0  
7163 7163 20200522 VI 69 1343 45 1412             61 C 5/22/2020 07:29 2020-05-22T07:29:00Z 05/22 03:29 6   2020-05-22T07:29:00Z 1457       6                           78 0 29 1457 posNeg 29 1412 0 0 0df76d065665793373491bf5ce08d4dda4c83b6f 0 0 0 0 0  
7164 7164 20200522 VT 952 24781   25733 16           834 B 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 54   2020-05-22T00:00:00Z       952 54     25733                     50 2 30 25733 posNeg 32 25733 0 0 7bc717a2b1f2d31e1afa8b680103d8a57e532380 0 0 0 0 0  
7166 7166 20200522 WI 16340 172703 187 189043 416 2259 134 535     8362 A+ 5/22/2020 00:00 2020-05-22T00:00:00Z 05/21 20:00 496 2259 2020-05-22T00:00:00Z       14396 496     187099                     55 548 9465 189230 posNeg 10013 189043 9 41 b8b6e9eb39b03ec23e0f91d6f9c0718c54dbfd9e 0 0 0 0 0  
7167 7167 20200522 WV 1616 83213   84829 47   13   9   983 B 5/22/2020 10:00 2020-05-22T10:00:00Z 05/22 06:00 71   2020-05-22T10:00:00Z 84829     1593                             54 23 1665 84829 posNeg 1688 84829 1 0 bfd765a1d0b82d6155cfe4d0b76147367d08ced6 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
);