states_daily_4pm_et

Table actions

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

73 rows where "dateChecked" is on date 2020-07-16

✎ 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, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-07-16 · 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
3196 3196 20200731 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 f8438af652f6e593542c605b427745bddbcb19c6 0 0 0 0 0  
3252 3252 20200730 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 0d822a908c5b259a0ebbc02fae6aeb4fc3e466a1 0 0 0 0 0  
3308 3308 20200729 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 0564aa9bb6aa9ef9f7a1ec0e814bb2247f6af5d8 0 0 0 0 0  
3364 3364 20200728 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 7e242daf6352307905db28bd15fc388dfe897b92 0 0 0 0 0  
3420 3420 20200727 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 4152bbe9f7b61f118fbb1b2f6d671683cad06e15 0 0 0 0 0  
3476 3476 20200726 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 43464e286af2177811b5c6a8819a24526bca478c 0 0 0 0 0  
3532 3532 20200725 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 a2a4d5d0111a4a0852760cf7649f84270ffb5c71 0 0 0 0 0  
3588 3588 20200724 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 6c1f867643f449fe63cb941b9c04f6f2e257027a 0 0 0 0 0  
3644 3644 20200723 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 40361838d8402276ac00060e602ec48543dfeccc 0 0 0 0 0  
3700 3700 20200722 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 8e73af1cc70b1d09c0daca2570b09c32f4238e16 0 0 0 0 0  
3756 3756 20200721 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 8574f9136aa284e92a35b7074ffbd49d4121d5f7 0 0 0 0 0  
3812 3812 20200720 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 fdfa63feba7c83b98a71fa85af9fcf686eb299e7 0 0 0 0 0  
3868 3868 20200719 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 80e2c75686d394f2316949af87bf18659355c48e 0 0 0 0 0  
3892 3892 20200719 MP 37 10664   10701   4         29 D 7/16/2020 19:06 2020-07-16T19:06:00Z 07/16 15:06 2 4 2020-07-16T19:06:00Z 11335     37       10697                     69 0 0 10701 posNeg 0 10701 0 0 bd4f94361289895d2ae39b79aa2402be801c9256 0 0 0 0 0  
3924 3924 20200718 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 65b6d063d650cf02681db34d463ad929b11d0b75 0 0 0 0 0  
3928 3928 20200718 CT 47893 582076   629969 66 10654         8466 B 7/16/2020 20:30 2020-07-16T20:30:00Z 07/16 16:30 4396 10654 2020-07-16T20:30:00Z 627986     45910 3519 877                         9 0 -139 629969 posNeg -139 629969 0 0 38c3a931ce76effed71dd2e78f1407a1b83395bc 0 0 0 0 0  
3948 3948 20200718 MP 37 10664   10701   4         29 D 7/16/2020 19:06 2020-07-16T19:06:00Z 07/16 15:06 2 4 2020-07-16T19:06:00Z 11335     37       10697                     69 0 0 10701 posNeg 0 10701 0 0 0c41e8889d377e71d5f59d0f56bc915e4311b0d6 0 0 0 0 0  
3980 3980 20200717 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 0 1037 posNeg 0 1037 0 0 92b5b8663421a5e713eae43663212b475978ac4b 0 0 0 0 0  
3984 3984 20200717 CT 47893 582215   630108 66 10654         8466 B 7/16/2020 20:30 2020-07-16T20:30:00Z 07/16 16:30 4396 10654 2020-07-16T20:30:00Z 627986     45771 3519 877                         9 143 -118 630108 posNeg 25 630108 7 0 d249a3b3806fcb8e41fd125213203043b332037c 0 0 0 0 0  
3985 3985 20200717 DC 11115 130492   141607 87   17   14   1863 A+ 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 577   2020-07-16T00:00:00Z             141607 103849                     11 39 1326 141607 posNeg 1365 141607 3 0 873b29839180bb2bbf394d58add519da31f55020 0 0 0 0 0  
3986 3986 20200717 DE 13337 135273   148610 55   7       7315 A+ 7/16/2020 18:00 2020-07-16T18:00:00Z 07/16 14:00 521   2020-07-16T18:00:00Z       12355 463 58   148610                     10 223 3517 148610 posNeg 3740 148610 0 0 8a9175089eeaae58371a7ba90f75a196d3edda4b 0 0 0 0 0  
3987 3987 20200717 FL 327241 2553527 2250 2880768 8961 20526           A 7/16/2020 23:59 2020-07-16T23:59:00Z 07/16 19:59 4912 20526 2020-07-16T23:59:00Z 3600738 407133 3183379 327241 4912     2884245       297009 12002 284980         12 11466 53684 2883018 posNeg 65150 2880768 130 372 379d4d4b2dd8f981f54fb51ae47b55db815da7ef 0 0 0 0 0  
3989 3989 20200717 GU 314 17938   18252 4           214 B 7/16/2020 21:40 2020-07-16T21:40:00Z 07/16 17:40 5   2020-07-16T21:40:00Z 18224     306       18244 145 2                 66 0 241 18252 posNeg 241 18252 0 0 01d5d2cacb09eb304030fa5d09221f105857bdd4 0 0 0 0 0  
3990 3990 20200717 HI 1311 99893   101204 39 138         975 D 7/16/2020 18:00 2020-07-16T18:00:00Z 07/16 14:00 22 138 2020-07-16T18:00:00Z 121512             101204                     15 19 1798 101204 posNeg 1817 101204 0 1 b9a368af20b88a6337634ede365017da085003ad 0 0 0 0 0  
3992 3992 20200717 ID 13133 127186   139481 153 554 35 165     3676 A 7/16/2020 19:00 2020-07-16T19:00:00Z 07/16 15:00 114 554 2020-07-16T19:00:00Z 139481     12295 93 21                         16 688 2768 140319 posNeg 3426 140319 4 28 6fe93e9975bd6b61c198e47d1c42498be1c3238b 0 0 0 0 0  
3993 3993 20200717 IL 160509 2006965   2167474 1431   309   128     A 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 7465   2020-07-16T00:00:00Z 2166299     159334 7272 193                         17 1427 42308 2167474 posNeg 43735 2167474 13 0 f58c6bf329f7564e2dc51800a1adf80b7d48e82c 0 0 0 0 0  
3994 3994 20200717 IN 54813 549822   604635 815 7814 258 1658 80   40421 A+ 7/16/2020 23:59 2020-07-16T23:59:00Z 07/16 19:59 2803 7814 2020-07-16T23:59:00Z         2610 193   604635                     18 733 8344 604635 posNeg 9077 604635 8 67 1268bb18f34f1ebd12c728b4679aababa62e85c4 0 0 0 0 0  
4000 4000 20200717 ME 3636 129809   133445 12 375 11   5   3114 A+ 7/16/2020 23:59 2020-07-16T23:59:00Z 07/16 19:59 115 375 2020-07-16T23:59:00Z 133048 4491 128380 3239 114 1     8346 377 7960               23 38 2945 133445 posNeg 2983 133445 1 1 05c9db4500efeb9b75fb78b7b7f3286bc2de9fd8 0 0 0 0 0  
4002 4002 20200717 MN 45013 774498   819511 252 4563 110 1369     38568 A 7/16/2020 17:00 2020-07-16T17:00:00Z 07/16 13:00 1573 4563 2020-07-16T17:00:00Z       45013 1533 40 819511                       27 666 13633 819511 posNeg 14299 819511 7 37 fdbe8120831e31d658f6b233ad8527a5956cc6e4 0 0 0 0 0  
4004 4004 20200717 MP 37 10664   10701   4         29 D 7/16/2020 19:06 2020-07-16T19:06:00Z 07/16 15:06 2 4 2020-07-16T19:06:00Z 11335     37       10697                     69 1 0 10701 posNeg 1 10701 0 0 5cd6e4a5cf622af8dedd9a05ea6ecfe29983b98f 0 0 0 0 0  
4005 4005 20200717 MS 40829 330635   371464 1076 3712 253   129   25932 A 7/16/2020 19:00 2020-07-16T19:00:00Z 07/16 15:00 1332 3712 2020-07-16T19:00:00Z 370993     40358 1303 29     14384 95                 28 1032 6532 371464 posNeg 7564 371464 24 37 a0d7873678c515385bb109bca9306011d40167b4 0 0 0 0 0  
4009 4009 20200717 NE 22134 204062   226196 96 1453         16501 B 7/16/2020 20:30 2020-07-16T20:30:00Z 07/16 16:30 299 1453 2020-07-16T20:30:00Z       22134       226452                     31 155 2812 226196 posNeg 2967 226196 8 0 e683f6de621db90da2892d7b22a59d1ad54d1e7b 0 0 0 0 0  
4012 4012 20200717 NM 16138 427230   443368 170 2312         6578 B 7/16/2020 18:06 2020-07-16T18:06:00Z 07/16 14:06 562 2312 2020-07-16T18:06:00Z 443368     16138                             35 297 6066 443368 posNeg 6363 443368 5 28 0d93d6908b0f99b28b3cba70c07690ad5e897212 0 0 0 0 0  
4014 4014 20200717 NY 405551 4593898   4999449 765 89995 179   98   71970 A 7/16/2020 23:59 2020-07-16T23:59:00Z 07/16 19:59 25024 89995 2020-07-16T23:59:00Z       405551     4999449                       36 776 77463 4999449 posNeg 78239 4999449 10 0 80b6f9c0c93e8c679b3f7658c718a257a7991546 0 0 0 0 0  
4017 4017 20200717 OR 13802 310393   324195 242 1327 64   34   3199 A+ 7/16/2020 03:01 2020-07-16T03:01:00Z 07/15 23:01 254 1327 2020-07-16T03:01:00Z     310393 13085       323478                     41 293 4956 324195 posNeg 5249 324195 5 16 b7b62504e46d1fe7e86db4d7dac8f5ae17a375d3 0 0 0 0 0  
4021 4021 20200717 SC 66060 487315   553375 1593 4182         23849 A 7/16/2020 23:59 2020-07-16T23:59:00Z 07/16 19:59 1096 4182 2020-07-16T23:59:00Z 553172 82636 470536 65857 1078 18     46882 2358 44524               45 1977 11434 553375 posNeg 13411 553375 26 438 df02840b16793687b2ecebda7dadaa9de78f8898 0 0 0 0 0  
4022 4022 20200717 SD 7789 88184   95973 61 763         6808 B 7/16/2020 18:00 2020-07-16T18:00:00Z 07/16 14:00 116 763 2020-07-16T18:00:00Z               95973                     46 95 1842 95973 posNeg 1937 95973 1 6 5576a5250376ee57ecd71ab1d6e8d50c4cb6e4d8 0 0 0 0 0  
4026 4026 20200717 VA 75433 801271 470 880326 1171 11054 247   118   9883 A+ 7/16/2020 17:00 2020-07-16T17:00:00Z 07/16 13:00 2013 11054 2020-07-16T17:00:00Z   90256   72516 1909 104 880326                       51 1002 14529 877174 posNeg 12395 876704 6 276 1265577f6edf06bc84b77180cd3f984e0136db55 0 0 0 0 0  
4027 4027 20200717 VI 263 5790 112 6053             126 C 7/16/2020 21:18 2020-07-16T21:18:00Z 07/16 17:18 6   2020-07-16T21:18:00Z 6165       6                           78 14 754 6165 posNeg 768 6053 0 0 ce9317fbad918c50b434983a5cbec1d35a6344ba 0 0 0 0 0  
4029 4029 20200717 WA 49358 859275   908633 379 4944     45     B 7/16/2020 02:59 2020-07-16T02:59:00Z 07/15 22:59 1427 4944 2020-07-16T02:59:00Z       49358 1427   908633 753174                     53 878 15519 908633 posNeg 16397 908633 6 115 5ad0bdb94454c60f5797cc4f29d724a434bb6743 0 0 0 0 0  
4033 4033 20200716 AK 2032 160990   163022 32       0   688 A 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 17   2020-07-16T00:00:00Z 163022     2032 17                           2 401 6528 163022 posNeg 6929 163022 0 0 0ee4b6e4c7aa637a0a0cce742968414d6c921a2f 0 0 0 0 0  
4034 4034 20200716 AL 61088 490021   550179 1395 7584   950   516 29736 B 7/16/2020 11:00 2020-07-16T11:00:00Z 07/16 07:00 1230 7584 2020-07-16T11:00:00Z 550179     60158 1200 30                         1 2021 8039 551109 posNeg 9972 551109 19 293 fed6c54ff978566f4a73f0f60f117c88fe1f720d 0 0 0 0 0  
4035 4035 20200716 AR 31114 369847   400144 470 1994     101 286 24195 A 7/16/2020 14:36 2020-07-16T14:36:00Z 07/16 10:36 341 1994 2020-07-16T14:36:00Z 400144     31114                             5 817 4368 400961 posNeg 4932 400961 6 46 21df27c9acbacc8df91b052564602aac8c6ac4c0 0 0 0 0 0  
4036 4036 20200716 AS 0 1037   1037               C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 0   2020-07-16T00:00:00Z 1037     0                             60 0 221 1037 posNeg 221 1037 0 0 65cf05131efa19c37bf7e74c0a54f7b8dee6b9bb 0 0 0 0 0  
4037 4037 20200716 AZ 134613 614653   748491 3454 6296 918   657   16684 A+ 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 2492 6296 2020-07-16T00:00:00Z       133838 2353 139   748491 203318                   4 3259 10045 749266 posNeg 13307 749266 58 193 3da4dd8837f54626fb5c802f6315a2fadd38319b 0 0 0 0 0  
4038 4038 20200716 CA 356178 5559330   5915508 8363   2120         B 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 7345   2020-07-16T00:00:00Z 5915508     356178                             6 8544 113688 5915508 posNeg 122232 5915508 118 0 02f714b65e5c5d8de05222db9f7a3f65ee785696 0 0 0 0 0  
4039 4039 20200716 CO 38155 378061   514742 389 5950         4880 A 7/16/2020 01:59 2020-07-16T01:59:00Z 07/15 21:59 1601 5950 2020-07-16T01:59:00Z       35126     514742 413187 121619 7961 113658               8 469 5757 416216 totalTestEncountersViral 8614 416216 7 -13 071211fd21170ad2762857c60559eaef5254d872 0 0 0 0 0  
4044 4044 20200716 GA 131275 1046947   1178222 2841 14346   2736       A 7/16/2020 14:50 2020-07-16T14:50:00Z 07/16 10:50 3104 14346 2020-07-16T14:50:00Z 1178222 119761 1058461 131275         191262 10071                 13 3441 19798 1178222 posNeg 23239 1178222 13 244 78fc2dad320188f87006d6c37eb7a24c5ff8cf0f 0 0 0 0 0  
4047 4047 20200716 IA 37132 359319   396451 195   65   34   27404 A+ 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 778   2020-07-16T00:00:00Z       37132       397678       36397 2499 33862         19 841 8298 396451 posNeg 9139 396451 16 0 16cb3cf1546fc61a0a7d40a3dbf0bc113ca0e53a 0 0 0 0 0  
4049 4049 20200716 IL 159082 1964657   2123739 1434   311   127     A 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 7452   2020-07-16T00:00:00Z 2122607     157950 7251 201                         17 1257 41749 2123739 posNeg 43006 2123739 25 0 90cf6f79fa537c0cf5e3883609ffff0b6678ae7b 0 0 0 0 0  
4052 4052 20200716 KY 21083 446921   467039 418 2842 92 1030     5500 B 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 650 2842 2020-07-16T00:00:00Z 467039     20118 646 4     40158                   21 406 8411 468004 posNeg 8792 468004 5 19 0bed8b0b254e3d5fd7f869450c3130a8f5721ca2 0 0 0 0 0  
4053 4053 20200716 LA 86411 937726   1024137 1401       162   53288 B 7/16/2020 13:00 2020-07-16T13:00:00Z 07/16 09:00 3485   2020-07-16T13:00:00Z       86411 3375 110   1024137                     22 2280 20657 1024137 posNeg 22937 1024137 24 0 f0b01179a5cc4a61d41de361d41d03b1e096f5ef 0 0 0 0 0  
4054 4054 20200716 MA 112581 889103   1340149 557 11663 77   38   95390 A+ 7/16/2020 10:00 2020-07-16T10:00:00Z 07/16 06:00 8380 11663 2020-07-16T10:00:00Z 1340149 141964   106271 8163 217   995374       83598             25 234 12737 1001684 totalTestsViral 17586 1001684 12 12 de8e9843c7f42a7ba5ca48fe05bd60098148b921 0 0 0 0 0  
4055 4055 20200716 MD 75664 616865   692529 436 11687 137       5286 A 7/16/2020 10:00 2020-07-16T10:00:00Z 07/16 06:00 3347 11687 2020-07-16T10:00:00Z 867188 88713   75664 3215 132   692529                     24 648 11793 692529 posNeg 12441 692529 6 62 8a1af8d8d06176ea69fda3885e3d175eb6155392 0 0 0 0 0  
4057 4057 20200716 MI 79839 1315315   1395154 680   201   107   53867 A+ 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 6348   2020-07-16T00:00:00Z 1414802 99487 1315315 71842 6101 247     190043                   26 926 26309 1395154 posNeg 27235 1395154 18 0 3ff271f791d1f96d8beba0cb513d89017d606cca 0 0 0 0 0  
4059 4059 20200716 MO 30422 498879   529301 875       86     B 7/16/2020 15:00 2020-07-16T15:00:00Z 07/16 11:00 1113   2020-07-16T15:00:00Z 664810 35179 628610 30422       529301       52063 1789 50274         29 708 10646 529301 posNeg 11354 529301 11 0 fd4d51034b9617bc092fe6443ee9d99e2502c649 0 0 0 0 0  
4062 4062 20200716 MT 2231 125609   127840 37 150         970 C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 35 150 2020-07-16T00:00:00Z 127840     2231                             30 135 3947 127840 posNeg 4082 127840 1 5 e0784ccdf1c34c6476470d11d9ef10d153690d0b 0 0 0 0 0  
4063 4063 20200716 NC 93426 1219331   1312757 1134           67124 A 7/16/2020 11:25 2020-07-16T11:25:00Z 07/16 07:25 1588   2020-07-16T11:25:00Z 1312757     93426 1588                           37 2160 25960 1312757 posNeg 28120 1312757 20 0 b8d6fae17729a72e4a22227b2726aeed46802f5a 0 0 0 0 0  
4064 4064 20200716 ND 4662 123388   236849 38 285         3796 D 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 82 285 2020-07-16T00:00:00Z 242783     4662 78 4 236849 125515 6109 217 5892               38 103 1389 128050 totalTestEncountersViral 3971 128050 1 1 0eaa51221352f21e631184c18e8bb211b23d84b4 0 0 0 0 0  
4067 4067 20200716 NJ 176501 1583403   1759904 862 20774 146   64   31400 A+ 7/16/2020 13:00 2020-07-16T13:00:00Z 07/16 09:00 15467 20774 2020-07-16T13:00:00Z 1759904     176501 13691 1776                         34 223 17334 1759904 posNeg 17557 1759904 31 0 eb2b8c48c5b89bec6f34e1c9e94037c7d61c9a2b 0 0 0 0 0  
4069 4069 20200716 NV 31915 338928   370843 1051   251   124   834 A+ 7/16/2020 13:30 2020-07-16T13:30:00Z 07/16 09:30 626   2020-07-16T13:30:00Z 465682     31915       369204                     32 1447 4971 370843 posNeg 6418 370843 8 0 5ab3b261696fa70a20540d41215c8586eae8a0fa 0 0 0 0 0  
4071 4071 20200716 OH 70601 1018192   1088793 1024 9324 310 2280 150   48330 B 7/16/2020 14:00 2020-07-16T14:00:00Z 07/16 10:00 3103 9324 2020-07-16T14:00:00Z 1084732     66540 2849 254                         39 1290 24880 1088793 posNeg 26170 1088793 28 115 36b3e1ec91c7dfd41da9768eb189f3334227e783 0 0 0 0 0  
4072 4072 20200716 OK 23441 433376   456817 638 2218 235       18095 A+ 7/16/2020 08:00 2020-07-16T08:00:00Z 07/16 04:00 438 2218 2020-07-16T08:00:00Z 460246 25931 433376 23441         49472 1592                 40 628 8864 456817 posNeg 9492 456817 6 48 a4f2b9648795bf1173486540ee56716d5510aea5 0 0 0 0 0  
4073 4073 20200716 OR 13509 305437   318946 219 1311 63   33   3199 A+ 7/16/2020 03:01 2020-07-16T03:01:00Z 07/15 23:01 249 1311 2020-07-16T03:01:00Z     305437 12807       318244                     41 428 6732 318946 posNeg 7160 318946 2 21 7a135780414f9944676363a07620ebac9e33ff26 0 0 0 0 0  
4074 4074 20200716 PA 98446 885195   983641 652       95   74818 A+ 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 6973   2020-07-16T00:00:00Z       95632       980827                     42 781 14211 983641 posNeg 14992 983641 16 0 2c4383f27c524ec86d80a26d5e232ff2f51f3db6 0 0 0 0 0  
4075 4075 20200716 PR 10574 255766   266340 280   25   14     B 7/16/2020 06:30 2020-07-16T06:30:00Z 07/16 02:30 172   2020-07-16T06:30:00Z 258001 3966 253922 3119 75 97       7455                 72 195 0 266340 posNeg 195 266340 1 0 73564a113232f44b5a77e30fcdfbce4a371c4835 0 0 0 0 0  
4076 4076 20200716 RI 17711 159677   305294 64 2084 4   3   1711 A+ 7/16/2020 12:00 2020-07-16T12:00:00Z 07/16 08:00 988 2084 2020-07-16T12:00:00Z 300801 25850 274951 17711     305294 177388                     44 71 1442 177388 totalTestEncountersViral 4232 177388 1 9 e6829978319f79f305af63a2c4d2ca0132632699 0 0 0 0 0  
4079 4079 20200716 TN 71540 1052157   1123697 1416 3497         41250 A 7/16/2020 15:00 2020-07-16T15:00:00Z 07/16 11:00 796 3497 2020-07-16T15:00:00Z 1123038 83227 1039811 70881 767 29                         47 2479 23545 1123697 posNeg 26024 1123697 13 63 f89b507def19db317a9e85562697ff0e16c26cf2 0 0 0 0 0  
4081 4081 20200716 UT 31845 407683   439528 236 1956 89 523   214 19214 A+ 7/16/2020 10:58 2020-07-16T10:58:00Z 07/16 06:58 234 1956 2020-07-16T10:58:00Z 516003     31845       439528             694 300 817 315 49 954 6494 439528 posNeg 7448 439528 1 43 83b7955fbbf0065a9fa628fcfa136371da5fa8d4 0 0 0 0 0  
4084 4084 20200716 VT 1325 77715   79040 25           1111 B 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 56   2020-07-16T00:00:00Z       1325 56     79040                     50 7 675 79040 posNeg 682 79040 0 0 c6051f601ae85f16d81087d000ce6426731a5535 0 0 0 0 0  
4086 4086 20200716 WI 43139 699670 154 742809 308 3968 88 811     30555 A+ 7/16/2020 16:00 2020-07-16T16:00:00Z 07/16 12:00 838 3968 2020-07-16T16:00:00Z       39627 831 7   739297                     55 942 13371 742963 posNeg 14313 742809 4 45 aefdf029a0e8958c0d191a2c99a8072d4ba76e45 0 0 0 0 0  
4087 4087 20200716 WV 4657 214517   219174 65   29   13   3128 B 7/16/2020 10:00 2020-07-16T10:00:00Z 07/16 06:00 99   2020-07-16T10:00:00Z 219052     4535         12503                   54 100 1170 219174 posNeg 1270 219174 2 0 da3500c4b1b9705321798172772c54429f6654ff 0 0 0 0 0  
4088 4088 20200716 WY 2026 41426   43452 18 131         1540 B 7/16/2020 17:23 2020-07-16T17:23:00Z 07/16 13:23 24 131 2020-07-16T17:23:00Z 60203 1745 58457 1644       43070                     56 41 497 43452 posNeg 538 43452 2 0 e18d3d4227efceddfe439ead089926a717c76046 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
);