states_daily_4pm_et

Table actions

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

64 rows where "dateModified" is on date 2020-05-29

✎ 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, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestResultsSource, hospitalizedIncrease, dateChecked (date)

dateModified (date) ✖

  • 2020-05-29 · 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
6500 6500 20200602 AS 0 174   174               C 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 0   2020-05-29T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 7be87117cf976dff80d987b55d61eb76e084bd34 0 0 0 0 0  
6556 6556 20200601 AS 0 174   174               C 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 0   2020-05-29T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 4c9966042aa83ac8d772d5416f979336064dedb4 0 0 0 0 0  
6612 6612 20200531 AS 0 174   174               C 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 0   2020-05-29T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 5d1cc0597a69e38d59c98e6f5435e9dfe961db2b 0 0 0 0 0  
6627 6627 20200531 KS 9719 85230   94949   842   284   124 547 A 5/29/2020 10:00 2020-05-29T10:00:00Z 05/29 06:00 208 842 2020-05-29T10:00:00Z                                     20 0 0 94949 posNeg 0 94949 0 0 f6c2b05aa376d62f836c1d9bc401f36792465484 0 0 0 0 0  
6668 6668 20200530 AS 0 174   174               C 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 0   2020-05-29T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 6498f6d473b13505da4f2bc67ad8ec359d20ca23 0 0 0 0 0  
6672 6672 20200530 CT 42022 204913   246935 533 12538         7127 B 5/29/2020 20:30 2020-05-29T20:30:00Z 05/29 16:30 3912 12538 2020-05-29T20:30:00Z 250046                                   9 260 5282 246935 posNeg 5542 246935 44 0 eec7cce8262aa922c31f80847709bf901707c8d2 0 0 0 0 0  
6673 6673 20200530 DC 8717 36912   45629 317   109   66   1100 A+ 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 462   2020-05-29T00:00:00Z             45629 37881                     11 179 1592 45629 posNeg 1771 45629 2 0 eda4e09ac88d5b77de716ae1422073a700faafca 0 0 0 0 0  
6674 6674 20200530 DE 9422 49907   59329 174           5205 A 5/29/2020 18:00 2020-05-29T18:00:00Z 05/29 14:00 466   2020-05-29T18:00:00Z         409 57   59329                     10 186 1610 59329 posNeg 1796 59329 3 0 ace78400ee2e4c7028ffdf5acb0b73f534671b0f 0 0 0 0 0  
6678 6678 20200530 HI 649 53365   54014   83         605 D 5/29/2020 18:00 2020-05-29T18:00:00Z 05/29 14:00 17 83 2020-05-29T18:00:00Z 54014                                   15 2 1188 54014 posNeg 1190 54014 0 0 64c5743156aa2327eeb3144893375802a21752e5 0 0 0 0 0  
6680 6680 20200530 ID 2803 42621   45172 30 240   96     2225 A 5/29/2020 19:00 2020-05-29T19:00:00Z 05/29 15:00 82 240 2020-05-29T19:00:00Z 45172     2551 62 20                         16 34 629 45424 posNeg 661 45424 0 2 898222804f17036c5fc179d7a5014c98c384b526 0 0 0 0 0  
6682 6682 20200530 IN 34211 222184   256395 1149 5285 412 1166 161     A+ 5/29/2020 23:59 2020-05-29T23:59:00Z 05/29 19:59 2125 5285 2020-05-29T23:59:00Z         1958 167   256395                     18 653 7029 256395 posNeg 7682 256395 15 0 b00e15ad6cb61d9492685c70c44bf4d15c055c5f 0 0 0 0 0  
6683 6683 20200530 KS 9719 85230   94949   842   284   124 547 A 5/29/2020 10:00 2020-05-29T10:00:00Z 05/29 06:00 208 842 2020-05-29T10:00:00Z               94780                     20 0 0 94949 posNeg 0 94949 0 0 55cbe4954ada49806562402b707abb4100abfebb 0 0 0 0 0  
6684 6684 20200530 KY 9464 198731   208034 499 2266 81 940     3231 A 5/29/2020 17:00 2020-05-29T17:00:00Z 05/29 13:00 418 2266 2020-05-29T17:00:00Z 208034     9303 417 1     19910                   21 280 -13359 208195 posNeg -13084 208195 9 86 0fd1f982e64f31285fc069028181dee2d47ecec5 0 0 0 0 0  
6688 6688 20200530 ME 2282 47284   49566 46 272 18   11   1505 B 5/29/2020 23:59 2020-05-29T23:59:00Z 05/29 19:59 89 272 2020-05-29T23:59:00Z 50078 2710 47284 2025 89       3983 218 3757               23 56 3804 49566 posNeg 3860 49566 4 2 033e1aec0ffb34a121003dbd3b22acfe6d179519 0 0 0 0 0  
6690 6690 20200530 MN 26181 250392   276573 589 3011 263 960     17864 A 5/29/2020 17:00 2020-05-29T17:00:00Z 05/29 13:00 1036 3011 2020-05-29T17:00:00Z       26181 1026 10 276573                       27 168 8268 276573 posNeg 8436 276573 30 75 1cf25c4cf8ee505bb7e4f2b6dd35e7642f09a21a 0 0 0 0 0  
6692 6692 20200530 MP 22 5986   6008             15 D 5/29/2020 20:27 2020-05-29T20:27:00Z 05/29 16:27 2   2020-05-29T20:27:00Z 6008     22                             69 0 324 6008 posNeg 324 6008 0 0 9b0807d608655a695e812c7f617f1b40f89bf04b 0 0 0 0 0  
6693 6693 20200530 MS 15229 150703   165932 593 2240 145   92   9401 A 5/29/2020 19:00 2020-05-29T19:00:00Z 05/29 15:00 723 2240 2020-05-29T19:00:00Z 165932               7536 95                 28 439 -815 165932 posNeg -376 165932 13 32 03fb63403476784d9c11eaec42290375f655c5c4 0 0 0 0 0  
6697 6697 20200530 NE 13654 85354   99008               D 5/29/2020 19:45 2020-05-29T19:45:00Z 05/29 15:45 170   2020-05-29T19:45:00Z       13654       99158                     31 393 3812 99008 posNeg 4205 99008 6 0 575058f214638a0a510a42bf3ffa8e019e8c1917 0 0 0 0 0  
6698 6698 20200530 NH 4492 64468 960 77127 105 440   120     2802 B 5/29/2020 09:00 2020-05-29T09:00:00Z 05/29 05:00 238 440 2020-05-29T09:00:00Z 77127     4492       68960 12987     11169             33 106 1992 69920 posNeg 2147 68960 6 2 5d4b243a012038cfe9f0d17d651e8660335544d9 0 0 0 0 0  
6700 6700 20200530 NM 7493 180768   188261 193 1317         2728 C 5/29/2020 17:56 2020-05-29T17:56:00Z 05/29 13:56 344 1317 2020-05-29T17:56:00Z 188261     7493                             35 129 4588 188261 posNeg 4717 188261 9 0 4f77a4c14b0843cb21b05076c890d90755412bed 0 0 0 0 0  
6709 6709 20200530 SC 11394 178125   189519 387 1634         6459 A 5/29/2020 15:30 2020-05-29T15:30:00Z 05/29 11:30 487 1634 2020-05-29T15:30:00Z 199735 21610 178125 11394 487                           45 263 999 189519 posNeg 1262 189519 4 0 01148024a324ab27ade2dd0a85d92c79c81654a7 0 0 0 0 0  
6710 6710 20200530 SD 4960 37978   42938 93 427         3805 B 5/29/2020 18:00 2020-05-29T18:00:00Z 05/29 14:00 62 427 2020-05-29T18:00:00Z               42938                     46 94 2162 42938 posNeg 2256 42938 3 9 05bdd8e910f291e18204e65a656366312315d987 0 0 0 0 0  
6712 6712 20200530 TX 62338 866179   928517 1752           40068 B 5/29/2020 16:45 2020-05-29T16:45:00Z 05/29 12:45 1626   2020-05-29T16:45:00Z 928517     62338         98932 3882                 48 1332 33910 928517 posNeg 35242 928517 0 0 00afd236c37045e98fbce2b0f6ff12d81dabb4ad 0 0 0 0 0  
6714 6714 20200530 VA 43611 261901 481 344000 1471 7216 372   194   5745 A+ 5/29/2020 17:00 2020-05-29T17:00:00Z 05/29 13:00 1370 7216 2020-05-29T17:00:00Z   53077   41529 1269 101 344000                       51 1078 6057 305993 posNeg 11953 305512 12 44 6276fa217caae9f7d97ba3406e07e91fb55c263e 0 0 0 0 0  
6715 6715 20200530 VI 69 1633 19 1702             61 C 5/29/2020 16:58 2020-05-29T16:58:00Z 05/29 12:58 6   2020-05-29T16:58:00Z 1721       6                           78 0 0 1721 posNeg 0 1702 0 0 e9239ee64c6aa9517d23a7c8be25ddf176645d64 0 0 0 0 0  
6721 6721 20200529 AK 430 49009   49439 14       1   367 A 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 10   2020-05-29T00:00:00Z 49439     430 10                           2 5 1464 49439 posNeg 1469 49439 0 0 4760e134e8886adb3880f0dfe1ff9832b0494478 0 0 0 0 0  
6722 6722 20200529 AL 16823 192060   208883 590 1800   577   344 9355 B 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 605 1800 2020-05-29T00:00:00Z 208883     16823 605                           1 513 7889 208883 posNeg 8402 208883 15 35 eba71dddfea043f2de6853e980821ae984acc4c2 0 0 0 0 0  
6724 6724 20200529 AS 0 174   174               C 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 0   2020-05-29T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 42c240caaf50d7a2a878298dad9d0255715bc672 0 0 0 0 0  
6725 6725 20200529 AZ 18465 191348   209813 931 3281 378   238   4551 A+ 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 885 3281 2020-05-29T00:00:00Z               209813 87682                   4 702 6197 209813 posNeg 6899 209813 28 58 a12825a43937b691a1c80c472a44441066ae708c 0 0 0 0 0  
6726 6726 20200529 CA 103886 1731592   1835478 4414   1328         B 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 4068   2020-05-29T00:00:00Z 1835478     103886                             6 2189 42730 1835478 posNeg 44919 1835478 95 0 3a2ea01e12be634601909dc5ed3ac00c52f2431a 0 0 0 0 0  
6727 6727 20200529 CO 25121 143838   191870 464 4254         3838 A 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 1168 4254 2020-05-29T00:00:00Z       22758     191870 166596 54652 4101 50551               8 354 5482 168959 totalTestEncountersViral 7178 168959 33 58 a1d500c23fc451035a645457b8e0c140ead9243e 0 0 0 0 0  
6731 6731 20200529 FL 54497 928742 1308 983239   10243           A 5/29/2020 11:00 2020-05-29T11:00:00Z 05/29 07:00 2495 10243 2020-05-29T11:00:00Z 1103658 72521 1028579 53285 2495     984160                     12 1212 30411 984547 posNeg 31623 983239 49 187 cf75942742f576e2de29d7ad87fa45e3fbe6897c 0 0 0 0 0  
6732 6732 20200529 GA 45670 404601   450271 889 7852   1780       A 5/29/2020 13:00 2020-05-29T13:00:00Z 05/29 09:00 1974 7852 2020-05-29T13:00:00Z 450271     45670         81736                   13 600 5025 450271 posNeg 5085 450271 12 85 113732d5f639171721427db419e067fc084c8ef5 0 0 0 0 0  
6733 6733 20200529 GU 172 5923   6095             144 C 5/29/2020 05:45 2020-05-29T05:45:00Z 05/29 01:45 5   2020-05-29T05:45:00Z 6011     165       6088 54 1                 66 0 133 6095 posNeg 133 6095 0 0 36374859b64bb5f1a8b935757337cb1d77e7eb50 0 0 0 0 0  
6735 6735 20200529 IA 18926 128394   147320 376   117   78   10753 A+ 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 522   2020-05-29T00:00:00Z       18926       14748       17906 1846 16050         19 353 4034 147320 posNeg 4387 147320 18 0 3c4f740a21cced6efc297223d8b06ed6ae758144 0 0 0 0 0  
6737 6737 20200529 IL 117455 734307   851762 3599   980   593     A 5/29/2020 00:59 2020-05-29T00:59:00Z 05/28 20:59 5270   2020-05-29T00:59:00Z 851762     117455 5270                           17 1622 20174 851762 posNeg 21796 851762 84 0 d5c4f9668a385dfbc69e01b2c00eea661e7d61bb 0 0 0 0 0  
6739 6739 20200529 KS 9719 85230   94949   842   284   124 547 A 5/29/2020 10:00 2020-05-29T10:00:00Z 05/29 06:00 208 842 2020-05-29T10:00:00Z               94780                     20 382 10079 94949 posNeg 10461 94949 3 20 b62751d997defba596468a0772f80aecc1751c03 0 0 0 0 0  
6741 6741 20200529 LA 38802 316225   355027 714       90   28700 B 5/29/2020 13:00 2020-05-29T13:00:00Z 05/29 09:00 2766   2020-05-29T13:00:00Z       38802 2661 105   355027                     22 0 0 355027 posNeg 0 355027 26 0 1de328285fa9d5af6e3ee0a7e5f7984b6c30fda9 0 0 0 0 0  
6742 6742 20200529 MA 95512 476233   736817 1991 9725 485       78108 A 5/29/2020 16:00 2020-05-29T16:00:00Z 05/29 12:00 6718 9725 2020-05-29T16:00:00Z 736817 123935   95512 6718     571745                     25 617 8805 571745 totalTestsViral 13476 571745 78 107 8495bd16c8c30329d9adb267981d318610114999 0 0 0 0 0  
6743 6743 20200529 MD 50988 233530   284518 1296 8479 507       3571 B 5/29/2020 10:00 2020-05-29T10:00:00Z 05/29 06:00 2538 8479 2020-05-29T10:00:00Z 322879 58514   50988 2421 117   284518                     24 1279 8381 284518 posNeg 9660 284518 37 87 b4a4d53e6db53707f55730a7452ac0af6dcf3c9b 0 0 0 0 0  
6745 6745 20200529 MI 63116 538868   601984 774   371   250   33168 A+ 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 5778   2020-05-29T00:00:00Z 615138 76270 538868 57904 5562 240     67783                   26 319 16205 601984 posNeg 16524 601984 27 0 e65d0e5cc795e086ffe747f1e6c91546e09625cc 0 0 0 0 0  
6747 6747 20200529 MO 12795 165055   177850 650       85     B 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 738   2020-05-29T00:00:00Z 183650 14498 168871 12616       177671       22184 869 21315         29 122 6661 177850 posNeg 6783 177850 31 0 739cb736d704f4fc2bbcb07061b052c23d6e6a6b 0 0 0 0 0  
6748 6748 20200529 MP 22 5662   5684             13 D 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 2   2020-05-29T00:00:00Z 5684     22                             69 0 261 5684 posNeg 261 5684 0 0 f47a933ea50ad493284d964a1eba53ae13e8ca83 0 0 0 0 0  
6750 6750 20200529 MT 493 38036   38529 2 67         448 C 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 17 67 2020-05-29T00:00:00Z 38529     493                             30 8 1728 38529 posNeg 1736 38529 0 1 7d84d1d2086ff6f9d66d7b260cfd83c85a268694 0 0 0 0 0  
6751 6751 20200529 NC 26488 364743   391231 680           14954 A 5/29/2020 10:55 2020-05-29T10:55:00Z 05/29 06:55 859   2020-05-29T10:55:00Z 391231     26488 859                           37 1076 14963 391231 posNeg 16039 391231 32 0 bb10bf9b9ab7973f584625f16cb4cdebbc43eafb 0 0 0 0 0  
6752 6752 20200529 ND 2519 66933   87671 36 164         1882 C 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 48 164 2020-05-29T00:00:00Z 89526     2519 45 3 87671 67336                     38 40 1160 69452 totalTestEncountersViral 2787 69452 0 3 874e6297c1a506366446285af671adf4534e25cd 0 0 0 0 0  
6755 6755 20200529 NJ 158844 557567   716411 2707 16960 720   544   26084 A+ 5/29/2020 13:00 2020-05-29T13:00:00Z 05/29 09:00 13248 16960 2020-05-29T13:00:00Z 716411     158844 11531 1717                         34 1029 29525 716411 posNeg 30554 716411 135 182 0887ba6dfae047fac4aa74141ac0602bdd0f5a97 0 0 0 0 0  
6757 6757 20200529 NV 8350 126066   134416 371   92   42   428 A+ 5/29/2020 12:30 2020-05-29T12:30:00Z 05/29 08:30 435   2020-05-29T12:30:00Z 155415     8350       134356                     32 142 3084 134416 posNeg 3226 134416 10 0 c24b4513a1dfbee5070633cc5781fbb54c77a2c0 0 0 0 0 0  
6758 6758 20200529 NY 368284 1575846   1944130 3781 89194 1164   889   65289 A 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 23780 89194 2020-05-29T00:00:00Z       368284     1944130                       36 1551 65790 1944130 posNeg 67341 1944130 58 152 d4f2004fc9bb1cfe962e3308e59d9ff441876959 0 0 0 0 0  
6759 6759 20200529 OH 34566 335324   369890 833 5947 326 1533 222     B 5/29/2020 14:00 2020-05-29T14:00:00Z 05/29 10:00 2131 5947 2020-05-29T14:00:00Z 367526     32202 1921 210                         39 651 9227 369890 posNeg 9878 369890 33 136 b3b6f16de4cc508c0248798c59304b966b1ac1e9 0 0 0 0 0  
6760 6760 20200529 OK 6338 181060   187398 160 982 68       5340 A+ 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 329 982 2020-05-29T00:00:00Z 188665 7114 181060 6338         20278 746                 40 68 4924 187398 posNeg 4992 187398 3 7 044f92fc69d7b21fc8e1bd1b6a3ac5ea6083a4d9 0 0 0 0 0  
6761 6761 20200529 OR 4131 118550   122681 155 771 36   21   1981 A+ 5/29/2020 03:01 2020-05-29T03:01:00Z 05/28 23:01 151 771 2020-05-29T03:01:00Z       4029       122579                     41 45 2989 122681 posNeg 3034 122681 0 3 6e231eb46d945d0f6b6d8b2221be7bfd87f48081 0 0 0 0 0  
6762 6762 20200529 PA 71339 366970   438309 1445       313   46370 A 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 5464   2020-05-29T00:00:00Z       68765       435735   604                 42 1297 9166 438309 posNeg 10463 438309 91 0 20e398f45b379fe1846d7882a0213b7da432e870 0 0 0 0 0  
6763 6763 20200529 PR 3647 60422   64069 101   12   5     B 5/29/2020 05:51 2020-05-29T05:51:00Z 05/29 01:51 132   2020-05-29T05:51:00Z 61702 1952 59701 1293 62 70       2354                 72 161 0 64069 posNeg 161 64069 1 0 e8b58dd9582189f42ee4eafb323f190d85dabb71 0 0 0 0 0  
6764 6764 20200529 RI 14808 96112   155185 219 1660 47   33   1206 A+ 5/29/2020 03:00 2020-05-29T03:00:00Z 05/28 23:00 693 1660 2020-05-29T03:00:00Z 157650 19565 138085 14808     155185 110920                     44 178 1537 110920 totalTestEncountersViral 3716 110920 16 21 ac76029c82093479000d8ed5fe9bb04146e5a24a 0 0 0 0 0  
6765 6765 20200529 SC 11131 177126   188257 399 1634         6459 A 5/29/2020 15:30 2020-05-29T15:30:00Z 05/29 11:30 483 1634 2020-05-29T15:30:00Z 194047 16921 177126 11131 483                           45 343 5665 188257 posNeg 6008 188257 13 16 0bbf118f1f7b7e3f8008c27e4593b01caadab0e3 0 0 0 0 0  
6767 6767 20200529 TN 22085 399882   421967 507 1710         14965 B 5/29/2020 15:00 2020-05-29T15:00:00Z 05/29 11:00 360 1710 2020-05-29T15:00:00Z       22085 360     421967                     47 406 5572 421967 posNeg 5978 421967 4 21 7f240835d3c4e5a75b8667ec68179f7adf3e4eff 0 0 0 0 0  
6769 6769 20200529 UT 9264 196591   205855 135 753   237   102 5813 B 5/29/2020 10:19 2020-05-29T10:19:00Z 05/29 06:19 107 753 2020-05-29T10:19:00Z       9264       205855                     49 343 2005 205855 posNeg 2348 205855 1 19 df0143f8d3e522a4f1d3419ebfaff5da570f48c6 0 0 0 0 0  
6770 6770 20200529 VA 42533 255844 525 332047 1524 7172 373   193   5648 A+ 5/29/2020 17:00 2020-05-29T17:00:00Z 05/29 13:00 1358 7172 2020-05-29T17:00:00Z   51711   40477 1258 100 332047                       51 1132 9964 298902 posNeg 12362 298377 20 198 4469f2cc97d3c0fa3f23996f3705204c6c0f60c4 0 0 0 0 0  
6771 6771 20200529 VI 69 1633 19 1702             61 C 5/29/2020 16:58 2020-05-29T16:58:00Z 05/29 12:58 6   2020-05-29T16:58:00Z 1721       6                           78 0 16 1721 posNeg 16 1702 0 0 1b756330c86f446eeac82067a8df99e219fafc08 0 0 0 0 0  
6772 6772 20200529 VT 975 30910   31885 14           859 B 5/29/2020 10:21 2020-05-29T10:21:00Z 05/29 06:21 55   2020-05-29T10:21:00Z       975 55     31885                     50 1 732 31885 posNeg 733 31885 0 0 055640d18f61530a7d24e1e72b9b10977d070232 0 0 0 0 0  
6773 6773 20200529 WA 22630 354243   376873 317 3413     85     B 5/29/2020 02:59 2020-05-29T02:59:00Z 05/28 22:59 1106 3413 2020-05-29T02:59:00Z       22630 1106   376873 332210                     53 345 6495 376873 posNeg 6840 376873 11 19 ebe7c01911907ae89cbdadc127af2f5020da9262 0 0 0 0 0  
6774 6774 20200529 WI 19843 233588 235 253431 423 2499 144 567     10880 A+ 5/29/2020 00:00 2020-05-29T00:00:00Z 05/28 20:00 568 2499 2020-05-29T00:00:00Z       17707 568     251295                     55 766 12869 253666 posNeg 13635 253431 18 47 54ea7726ca95862b0831ae6a417ddd83eda41d9f 0 0 0 0 0  
6775 6775 20200529 WV 1951 91426   93377 33   14   8   1241 B 5/29/2020 10:00 2020-05-29T10:00:00Z 05/29 06:00 74   2020-05-29T10:00:00Z 93377     1593         4998                   54 45 3017 93377 posNeg 3062 93377 0 0 36b0099f12fad8a321ddaa327b4226c51a62335c 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
);