states_daily_4pm_et

Table actions

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

64 rows where "dateChecked" is on date 2020-05-10

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

dateChecked (date) ✖

  • 2020-05-10 · 64 ✖
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
7340 7340 20200518 AS 0 105   105               C 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 0   2020-05-10T00:00:00Z 105     0                             60 0 0 105 posNeg 0 105 0 0 1f7a3cb43830728937dc0e91b6db625b70cf5588 0 0 0 0 0  
7396 7396 20200517 AS 0 105   105               C 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 0   2020-05-10T00:00:00Z 105     0                             60 0 0 105 posNeg 0 105 0 0 020836e5fb50cde3c552630e0cbf2191b3bccd87 0 0 0 0 0  
7452 7452 20200516 AS 0 105   105               C 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 0   2020-05-10T00:00:00Z 105     0                             60 0 0 105 posNeg 0 105 0 0 7069251db5676fb72665afbd480c8fc613078093 0 0 0 0 0  
7508 7508 20200515 AS 0 105   105               C 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 0   2020-05-10T00:00:00Z 105     0                             60 0 0 105 posNeg 0 105 0 0 fa795e738f72c67e45c2a94a3db0baa86aced01f 0 0 0 0 0  
7564 7564 20200514 AS 0 105   105               C 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 0   2020-05-10T00:00:00Z 105     0                             60 0 0 105 posNeg 0 105 0 0 3d82e3f4d61e82736abc20134a299e9341c79019 0 0 0 0 0  
7620 7620 20200513 AS 0 105   105               C 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 0   2020-05-10T00:00:00Z 105     0                             60 0 0 105 posNeg 0 105 0 0 006575e6d026e32a2e782a1c7eae8a54847e9131 0 0 0 0 0  
7676 7676 20200512 AS 0 105   105               C 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 0   2020-05-10T00:00:00Z 105     0                             60 0 0 105 posNeg 0 105 0 0 6be29f6f539054b74f9ddc73db928a23324a3919 0 0 0 0 0  
7679 7679 20200512 CO 19879 88778   120284 738 3663         3114 A 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 987 3663 2020-05-10T00:00:00Z       17983     120284 106761 21174 1956 19218               8 176 -113 108657 totalTestEncountersViral 3071 108657 6 -26 af4445f1e639285765a0431ac33e8e55e6b78e73 0 0 0 0 0  
7731 7731 20200511 AR 4034 64996   69030 61 480     11 98 3149 A 5/10/2020 19:05 2020-05-10T19:05:00Z 05/10 15:05 94 480 2020-05-10T19:05:00Z 69030     4034                             5 287 3215 69030 posNeg 3502 69030 6 9 956b438cb2482f9acd33bc8ac0f935a1144c23a4 0 0 0 0 0  
7732 7732 20200511 AS 0 105   105               D 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 0   2020-05-10T00:00:00Z 105     0                             60 0 22 105 posNeg 22 105 0 0 c12b63a186ec36381823e55b53355d602355c4f9 0 0 0 0 0  
7737 7737 20200511 DC 6389 23872   30261 416       82   881 A 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 328   2020-05-10T00:00:00Z             30261                       11 117 574 30261 posNeg 691 30261 5 0 639052996b94553eabce4b3b2e0e43cd92074fdb 0 0 0 0 0  
7738 7738 20200511 DE 6565 25363   31928 275           2619 B 5/10/2020 18:00 2020-05-10T18:00:00Z 05/10 14:00 324   2020-05-10T18:00:00Z         288 36                         10 118 771 31928 posNeg 889 31928 12 0 16970a1f8c59ad8aac6df4012e514a3e15458779 0 0 0 0 0  
7742 7742 20200511 HI 632 37051   37683   81         561 B 5/10/2020 18:00 2020-05-10T18:00:00Z 05/10 14:00 17 81 2020-05-10T18:00:00Z                                     15 1 412 37683 posNeg 413 37683 0 0 68c91f71db828e37ddfd2b8ef07ff2a3227e4701 0 0 0 0 0  
7746 7746 20200511 IN 24627 122061   146688 1346 4389 452 990 213     A+ 5/10/2020 23:59 2020-05-10T23:59:00Z 05/10 19:59 1540 4389 2020-05-10T23:59:00Z         1411                           18 501 6158 146688 posNeg 6659 146688 32 0 77ec3b9aa192fcf0161267d8524b0bd6242e230a 0 0 0 0 0  
7754 7754 20200511 MN 14379 115585   129964 452 1716 194 600     6945 A 5/10/2020 17:00 2020-05-10T17:00:00Z 05/10 13:00 591 1716 2020-05-10T17:00:00Z       14379 591   129964                       27 827 4476 129964 posNeg 5303 129964 13 59 2870da85f53b6c6d5f7b1ff3938340cd2e1d379b 0 0 0 0 0  
7757 7757 20200511 MS 9674 86211   95885 507 1546 132   68   6268 A 5/10/2020 19:00 2020-05-10T19:00:00Z 05/10 15:00 435 1546 2020-05-10T19:00:00Z 95885                                   28 173 14110 95885 posNeg 14283 95885 5 15 943f5731a9d8e7852d6050ec3d1124693d0569ac 0 0 0 0 0  
7758 7758 20200511 MT 459 22113   22572 4 62         423 C 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 16 62 2020-05-10T00:00:00Z 22572     459                             30 1 867 22572 posNeg 868 22572 0 0 5d7be75f633f1d6dbd11c3a3ee5b203ccd9f21c4 0 0 0 0 0  
7761 7761 20200511 NE 8315 37924   46239               D 5/10/2020 19:45 2020-05-10T19:45:00Z 05/10 15:45 98   2020-05-10T19:45:00Z       8315       46314                     31 81 589 46239 posNeg 670 46239 2 0 e9438b2ae90472bf1ee69791a8807aae481e27bb 0 0 0 0 0  
7762 7762 20200511 NH 3160 31723 261 37116 113 318   97     1229 B 5/10/2020 09:00 2020-05-10T09:00:00Z 05/10 05:00 133 318 2020-05-10T09:00:00Z 37116               3059                   33 149 1281 35144 posNeg 1270 34883 2 5 1e01ff28109187f9ea76b0a2e1740bddc450b40b 0 0 0 0 0  
7764 7764 20200511 NM 4863 97635   102498 194 789         1285 C 5/10/2020 17:50 2020-05-10T17:50:00Z 05/10 13:50 200 789 2020-05-10T17:50:00Z       4863                             35 85 5360 102498 posNeg 5445 102498 9 0 8e547ef06dcb935fa306259196a56dc792e73b2e 0 0 0 0 0  
7766 7766 20200511 NY 337055 867596   1204651 7226 84194 2450   2020   58363 A 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 21640 84194 2020-05-10T00:00:00Z       337055                             36 1660 19993 1204651 posNeg 21653 1204651 162 433 ed1caee29dc70599e8663867880d9305696d16d4 0 0 0 0 0  
7773 7773 20200511 SC 7653 76804   84457   1252         4120 B 5/10/2020 16:30 2020-05-10T16:30:00Z 05/10 12:30 331 1252 2020-05-10T16:30:00Z       7653 331                           45 0 0 84457 posNeg 0 84457 0 0 f47a579d2da5523a57dc23bda694142ef002f7c1 0 0 0 0 0  
7774 7774 20200511 SD 3614 20964   24578 78 263         2187 C 5/10/2020 18:00 2020-05-10T18:00:00Z 05/10 14:00 34 263 2020-05-10T18:00:00Z               24578                     46 97 587 24578 posNeg 684 24578 0 2 0b312128e1d964fdf9f1f43228a61c89acce30a8 0 0 0 0 0  
7776 7776 20200511 TX 39869 485828   525697 1525           21713 B 5/10/2020 16:35 2020-05-10T16:35:00Z 05/10 12:35 1100   2020-05-10T16:35:00Z       39869 483                           48 1000 22921 525697 posNeg 23921 525697 12 0 012bd598214c27571158b17c22534fa1b5395a31 0 0 0 0 0  
7778 7778 20200511 VA 25070 125547 432 182211 1504 4777 362   194   3273 A+ 5/10/2020 17:00 2020-05-10T17:00:00Z 05/10 13:00 850 4777 2020-05-10T17:00:00Z   31982   23889 823 27 182211                       51 989 6573 151049 posNeg 5553 150617 11 21 a41f394a2b652985fd6a5fbb187b092eae081c63 0 0 0 0 0  
7784 7784 20200511 WY 662 11403   12065 12 66         443 C 5/10/2020 17:38 2020-05-10T17:38:00Z 05/10 13:38 7 66 2020-05-10T17:38:00Z 13416     504                             56 1 0 12065 posNeg 1 12065 0 1 c2124d770dbeddf2e5bf52aaebb79adb2feacb2b 0 0 0 0 0  
7785 7785 20200510 AK 379 26985   27364 8           324 C 5/10/2020 14:00 2020-05-10T14:00:00Z 05/10 10:00 10   2020-05-10T14:00:00Z 27364     379 10                           2 1 914 27364 posNeg 915 27364 0 0 1f635a38c6a5961315093701828e8180170f6566 0 0 0 0 0  
7786 7786 20200510 AL 9777 117644   127421 424 1240   460   274   B 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 393 1240 2020-05-10T00:00:00Z 127421     9777 393                           1 210 1717 127421 posNeg 1927 127421 5 12 3466d88837fd9a35a389d31297a6f493e442a1ef 0 0 0 0 0  
7787 7787 20200510 AR 3747 61781   65528 64 471     14 96 2968 B 5/10/2020 10:15 2020-05-10T10:15:00Z 05/10 06:15 88 471 2020-05-10T10:15:00Z 65528     3747                             5 0 0 65528 posNeg 0 65528 0 0 41aeef2e48005db728ad4b3cfd59e08ba046d63b 0 0 0 0 0  
7789 7789 20200510 AZ 11119 99258   110377 713 2421 300   195   2775 A+ 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 536 2421 2020-05-10T00:00:00Z               110377 27362                   4 159 4408 110377 posNeg 4567 110377 4 35 14948c8f834e962583d27bd9664df12ce54e5986 0 0 0 0 0  
7790 7790 20200510 CA 66680 888984   955664 4555   1328         B 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 2745   2020-05-10T00:00:00Z 955664     66680                             6 2119 40975 955664 posNeg 43094 955664 67 0 478f85c8a2861ab9ab5392fe8db562033c517006 0 0 0 0 0  
7792 7792 20200510 CT 33554 96638   130192 1242 9389         5413 B 5/10/2020 14:00 2020-05-10T14:00:00Z 05/10 10:00 2967 9389 2020-05-10T14:00:00Z 132508       2633                           9 570 6053 130192 posNeg 6623 130192 35 0 4a179a274ed1ff44c87e641a926d4a7af5c0cd0b 0 0 0 0 0  
7794 7794 20200510 DE 6447 24592   31039 285           2537 B 5/10/2020 12:03 2020-05-10T12:03:00Z 05/10 08:03 312   2020-05-10T12:03:00Z         277 35                         10 170 1573 31039 posNeg 1743 31039 11 0 5bf83d48c658730a4b5034d5216341ae11f0e21f 0 0 0 0 0  
7795 7795 20200510 FL 40596 498352 1265 538948   7404           B 5/10/2020 11:52 2020-05-10T11:52:00Z 05/10 07:52 1791 7404 2020-05-10T11:52:00Z       40596 1791                           12 595 10622 540213 posNeg 11217 538948 6 79 6f2afecde23e001fc5085f76553f12b585915207 0 0 0 0 0  
7796 7796 20200510 GA 33441 210106   243547 1144 5997   1412       A 5/10/2020 15:25 2020-05-10T15:25:00Z 05/10 11:25 1405 5997 2020-05-10T15:25:00Z 243547     33441                             13 909 7314 243547 posNeg 8223 243547 5 10 6b3a4807bd943b58dc9c6e51eb6d8c1b68ebc939 0 0 0 0 0  
7799 7799 20200510 IA 11959 62215   74174 413   157   105   5154 A+ 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 265   2020-05-10T00:00:00Z       11959                             19 288 2410 74174 posNeg 2698 74174 13 0 91ba67f91627e25a80977cd7a32d6cec56562b3f 0 0 0 0 0  
7801 7801 20200510 IL 77741 352243   429984 4293   1232   709     A 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 3406   2020-05-10T00:00:00Z       77741                             17 1656 11997 429984 posNeg 13653 429984 57 0 6dfaa4a7cc09b86664d0bb2f1754f60d521c28c5 0 0 0 0 0  
7803 7803 20200510 KS 6948 45557   52505   657   231   101 371 A 5/10/2020 10:00 2020-05-10T10:00:00Z 05/10 06:00 157 657 2020-05-10T10:00:00Z                                     20 197 2375 52505 posNeg 2572 52505 0 22 0944abc09606a8b48f3ab369f24c32c453c68902 0 0 0 0 0  
7805 7805 20200510 LA 31600 184272   215872 1324       161   20316 B 5/10/2020 13:00 2020-05-10T13:00:00Z 05/10 09:00 2286   2020-05-10T13:00:00Z       31600 2213                           22 183 3532 215872 posNeg 3715 215872 19 0 cb32f259899f295aaa970471e8045e8b58ab8200 0 0 0 0 0  
7806 7806 20200510 MA 77793 310596   481105 3128 7617 810         A 5/10/2020 10:00 2020-05-10T10:00:00Z 05/10 06:00 4979 7617 2020-05-10T10:00:00Z 481105 96540   77793 4979                           25 1050 10802 388389 totalTestsViral 4559 388389 139 66 5c353c46d0eec922102c5723a9589f9e924a31d4 0 0 0 0 0  
7807 7807 20200510 MD 32587 127344   159931 1640 5955 611       2293 A 5/10/2020 10:00 2020-05-10T10:00:00Z 05/10 06:00 1739 5955 2020-05-10T10:00:00Z 171458 37984   32587 1652 87                         24 1053 2850 159931 posNeg 3903 159931 47 23 cc3b4727d8ee68d05e16ea1407339476965e6b38 0 0 0 0 0  
7808 7808 20200510 ME 1436 22092   23528 36 199 17   10   861 B 5/10/2020 11:30 2020-05-10T11:30:00Z 05/10 07:30 64 199 2020-05-10T11:30:00Z       1312 64           587               23 28 0 23528 posNeg 28 23528 0 1 8e8a7d0b3cab923297653a0f1cb4d0e6e689b4c2 0 0 0 0 0  
7809 7809 20200510 MI 53033 267417   320450 1437   674   536   22686 A+ 5/10/2020 11:00 2020-05-10T11:00:00Z 05/10 07:00 5081   2020-05-10T11:00:00Z 328334 60917 267417 50129 4911 228                         26 301 8152 320450 posNeg 8453 320450 45 0 120697f2a58f1bf1191b8aed7b643e375d5264bb 0 0 0 0 0  
7811 7811 20200510 MO 9844 105702   115546 824       137     B 5/10/2020 15:00 2020-05-10T15:00:00Z 05/10 11:00 482   2020-05-10T15:00:00Z 121559 11659 109674 9844               5533 251 5273         29 178 6470 115546 posNeg 6648 115546 10 0 824020de7a74f8c3f1ebc5b83503a9bef77797e3 0 0 0 0 0  
7815 7815 20200510 NC 14764 177371   192135 442             B 5/10/2020 11:00 2020-05-10T11:00:00Z 05/10 07:00 547   2020-05-10T11:00:00Z       14764 547                           37 404 5369 192135 posNeg 5773 192135 3 0 4f3b2e9c4ac6f34cd5306c2a0ae63139ed15a8b2 0 0 0 0 0  
7816 7816 20200510 ND 1490 43378   48661 29 110         792 C 5/10/2020 12:10 2020-05-10T12:10:00Z 05/10 08:10 24 110 2020-05-10T12:10:00Z 49459     1490 24   48661 43267                     38 26 909 44868 totalTestEncountersViral 1346 44868 0 0 9b79927ec9e1ab98157c0750142ba5e91b515e43 0 0 0 0 0  
7819 7819 20200510 NJ 138532 173915 591 312447 4308   1338   994   15642 A+ 5/10/2020 13:00 2020-05-10T13:00:00Z 05/10 09:00 10872   2020-05-10T13:00:00Z       138532 9255 1617   312447                     34 1447 5794 313038 posNeg 7241 312447 151 0 abeae687db40c58ebac3bbb93aa606df6be6651c 0 0 0 0 0  
7821 7821 20200510 NV 6098 52711   58809 444   116   65   182 C 5/10/2020 12:30 2020-05-10T12:30:00Z 05/10 08:30 339   2020-05-10T12:30:00Z 71603     6098                             32 70 2628 58809 posNeg 2698 58809 5 0 fd62566be2df861e2cbbcb29af94d8e36420a145 0 0 0 0 0  
7822 7822 20200510 NY 335395 847603   1182998 7262 83761 2488   2073   58006 A 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 21478 83761 2020-05-10T00:00:00Z       335395                             36 2273 26957 1182998 posNeg 29230 1182998 207 476 2ead3bccbf08581935df78cd2fe9f0342f332d45 0 0 0 0 0  
7823 7823 20200510 OH 24081 180781   204862 962 4351 381 1205 254     B 5/10/2020 14:00 2020-05-10T14:00:00Z 05/10 10:00 1341 4351 2020-05-10T14:00:00Z 195533     22891 1220 121                         39 384 7808 204862 posNeg 8192 204862 10 51 3d6a1bdfc252f7df42ebdb81769ad3ce6fd6a45f 0 0 0 0 0  
7824 7824 20200510 OK 4589 91379   95968 177 826 93       3204 A+ 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 272 826 2020-05-10T00:00:00Z 95869 4923 90721 4589                             40 99 0 95968 posNeg 99 95968 2 4 b449141a71867eb3e25e812e8e2e34cff4aa8ebe 0 0 0 0 0  
7825 7825 20200510 OR 3228 72279   75507 164 670 45   22   1125 A+ 5/10/2020 11:00 2020-05-10T11:00:00Z 05/10 07:00 127 670 2020-05-10T11:00:00Z       3171                             41 68 819 75507 posNeg 887 75507 0 8 fbc42c526db07fb46a301afadb95319912aa2692 0 0 0 0 0  
7826 7826 20200510 PA 56611 227772   284383 2230       501     C 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 3707   2020-05-10T00:00:00Z               284383                     42 1295 5981 284383 posNeg 7276 284383 19 0 1a9bce399b5df620712db91c7b1ba607cf8f3f06 0 0 0 0 0  
7827 7827 20200510 PR 2198     2198 143             D 5/10/2020 05:51 2020-05-10T05:51:00Z 05/10 01:51 111   2020-05-10T05:51:00Z       1040 57         1158                 72 25 0 2198 posNeg 25 2198 3 0 f2cfb681616e4d0bf5c42d57d000e6f19846ff05 0 0 0 0 0  
7828 7828 20200510 RI 11613 68106   96976 283 1251 70   52   809 A+ 5/10/2020 03:00 2020-05-10T03:00:00Z 05/09 23:00 422 1251 2020-05-10T03:00:00Z 99293 13826 85467 11613     96976 79719                     44 186 1502 79719 totalTestEncountersViral 3800 79719 4 33 5d91ffef9526b1b918d88f34cfd75bc14c35e19e 0 0 0 0 0  
7829 7829 20200510 SC 7653 76804   84457   1252         4120 B 5/10/2020 16:30 2020-05-10T16:30:00Z 05/10 12:30 331 1252 2020-05-10T16:30:00Z       7653 331                           45 122 3372 84457 posNeg 3494 84457 1 0 f5a69ab8027f53d0062a06e415b33af874b0a8c1 0 0 0 0 0  
7831 7831 20200510 TN 14985 246884   261869 484 1325         7528 B 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 243 1325 2020-05-10T00:00:00Z       14985 243                           47 217 8904 261869 posNeg 9121 261869 1 6 9d052b49ad1b42c5a70639881f2d3c3ac027bdb3 0 0 0 0 0  
7832 7832 20200510 TX 38869 462907   501776 1626           21022 B 5/10/2020 16:35 2020-05-10T16:35:00Z 05/10 12:35 1088   2020-05-10T16:35:00Z       38869 481                           48 1009 11473 501776 posNeg 12482 501776 39 0 07bb600c4bfaea99afc54863984351e980b000c7 0 0 0 0 0  
7833 7833 20200510 UT 6251 140259   146510 144 512   168   76 3033 B 5/10/2020 10:31 2020-05-10T10:31:00Z 05/10 06:31 67 512 2020-05-10T10:31:00Z       6251                             49 148 3068 146510 posNeg 3216 146510 1 14 abec2461f2ca2cfbde5fcdf4a3359c1a4a0ebdb0 0 0 0 0 0  
7836 7836 20200510 VT 926 18167   19093 21           777 B 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 53   2020-05-10T00:00:00Z       927 53                           50 0 477 19093 posNeg 477 19093 0 0 6d40f15a3daa8e66910e350b48658cbcc45977ea 0 0 0 0 0  
7837 7837 20200510 WA 17773 246823   264596 335   101         B 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 921   2020-05-10T00:00:00Z       17773 921   264596 242722                     53 62 1714 264596 posNeg 1776 264596 16 0 720f5c32f7c2798525c16910d5c86129c07c6705 0 0 0 0 0  
7838 7838 20200510 WI 11694 105163 182 116857 332 1820 113 456     5014 A+ 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 400 1820 2020-05-10T00:00:00Z       10219 400                           55 292 3228 117039 posNeg 3520 116857 2 14 83f826bbee306c63ba535019173f154811284da4 0 0 0 0 0  
7839 7839 20200510 WV 1360 61284   62644 49   10   6   775 C 5/10/2020 10:00 2020-05-10T10:00:00Z 05/10 06:00 54   2020-05-10T10:00:00Z 62644     1360 54                           54 25 1622 62644 posNeg 1647 62644 1 0 523261d8ac889952f3e2e73759289ea5321f7b58 0 0 0 0 0  
7840 7840 20200510 WY 661 11403   12064 12 65         443 C 5/10/2020 16:00 2020-05-10T16:00:00Z 05/10 12:00 7 65 2020-05-10T16:00:00Z 13416     503                             56 17 0 12064 posNeg 17 12064 0 1 acbe5dfc14a538de5947972f85a3539cfd108f07 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
);