states_daily_4pm_et

Table actions

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

61 rows where "dateChecked" is on date 2020-07-03

✎ 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, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-07-03 · 61 ✖
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
4661 4661 20200705 GU 288 14666   14954 3           179 B 7/3/2020 22:30 2020-07-03T22:30:00Z 07/03 18:30 5   2020-07-03T22:30:00Z 13925     280       14946 128 2                 66 0 0 14954 posNeg 0 14954 0 0 d4f238eaf745b92a77eae4ceeba274ea4c44148d 0 0 0 0 0  
4664 4664 20200705 ID 7370 96896   103675 71 359 19 122     2858 A 7/3/2020 19:00 2020-07-03T19:00:00Z 07/03 15:00 93 359 2020-07-03T19:00:00Z 103675     6779 73 20                         16 376 2823 104266 posNeg 3201 104266 0 4 f03f00a07d725066d2237c9977a96229f8d8f240 0 0 0 0 0  
4667 4667 20200705 KS 15919 175642   191561   1219   377   156 842 A 7/3/2020 10:00 2020-07-03T10:00:00Z 07/03 06:00 277 1219 2020-07-03T10:00:00Z               191561                     20 0 0 191561 posNeg 0 191561 0 0 b54d75aaf0b238b4506ae8addef722221a5610d0 0 0 0 0 0  
4668 4668 20200705 KY 16376 379271   395052 455 2685 99 996     4747 B 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 585 2685 2020-07-03T00:00:00Z 395052     15781 581 4     35019                   21 0 0 395647 posNeg 0 395647 0 0 c43c6e0f4cdff49f0c28f7d886b5baf055dabe8b 0 0 0 0 0  
4677 4677 20200705 MS 30900 279241   310141 872 3268 175   88   19388 A 7/3/2020 19:00 2020-07-03T19:00:00Z 07/03 15:00 1111 3268 2020-07-03T19:00:00Z 309699     30671 1093 18     12522 95                 28 226 0 310141 posNeg 226 310141 4 0 2dc4756f8477c7c407c436930d8b77ce4e8883dd 0 0 0 0 0  
4682 4682 20200705 NH 5857 117892   164672 25 569   163     4597 B 7/3/2020 09:00 2020-07-03T09:00:00Z 07/03 05:00 376 569 2020-07-03T09:00:00Z 164672     5857       123749 23261     20057             33 0 0 123749 posNeg 3366 123749 0 0 20cc5440c7bfc0b5a26d49d087d01cde3c34fcb3 0 0 0 0 0  
4699 4699 20200705 VI 111 3060 2 3171             76 C 7/3/2020 19:39 2020-07-03T19:39:00Z 07/03 15:39 6   2020-07-03T19:39:00Z 3173       6                           78 0 0 3173 posNeg 0 3171 0 0 0ec62105a210ea8eededdd32f0fd669f2f9621e5 0 0 0 0 0  
4713 4713 20200704 DC 10447 94107   104554 95   28   21   1523 A+ 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 557   2020-07-03T00:00:00Z             104554 81330                     11 12 1733 104554 posNeg 1745 104554 2 0 943624fee5f58d8b1a29402a110d325ff2cab9f9 0 0 0 0 0  
4714 4714 20200704 DE 11996 108697   120693 54   13       6711 A+ 7/3/2020 18:00 2020-07-03T18:00:00Z 07/03 14:00 512   2020-07-03T18:00:00Z       10952 455 57   120693                     10 73 2277 120693 posNeg 2350 120693 0 0 1e6410ac548f7974f3770db37418ccf6bbca7b64 0 0 0 0 0  
4715 4715 20200704 FL 190052 1956445 1672 2146497   16040           A 7/3/2020 23:59 2020-07-03T23:59:00Z 07/03 19:59 3803 16040 2020-07-03T23:59:00Z 2595006 242571 2347444 190052 3803     2148327       236304 9575 226699         12 11458 53679 2148169 posNeg 65137 2146497 18 245 cd78af8df7ec00071c8f0b72de4e7dbeea860441 0 0 0 0 0  
4717 4717 20200704 GU 288 14666   14954 3           179 B 7/3/2020 22:30 2020-07-03T22:30:00Z 07/03 18:30 5   2020-07-03T22:30:00Z 13925     280       14946 128 2                 66 2 403 14954 posNeg 405 14954 0 0 62f49228ce24b249005e394904bd0898535754fd 0 0 0 0 0  
4718 4718 20200704 HI 975 82501   83476   118         754 D 7/3/2020 18:00 2020-07-03T18:00:00Z 07/03 14:00 19 118 2020-07-03T18:00:00Z 98278             83476                     15 29 1829 83476 posNeg 1858 83476 1 2 111200aa06b98082ee5997578f406a1ad69754fc 0 0 0 0 0  
4720 4720 20200704 ID 6994 94073   100474 67 355 23 121     2831 A 7/3/2020 19:00 2020-07-03T19:00:00Z 07/03 15:00 93 355 2020-07-03T19:00:00Z 100474     6401 73 20                         16 401 1957 101067 posNeg 2355 101067 1 5 f128f4daf26ceaab0e2f864a90d15340a228228c 0 0 0 0 0  
4722 4722 20200704 IN 47432 464856   512288 632 7216 218 1516 87   36076 A+ 7/3/2020 23:59 2020-07-03T23:59:00Z 07/03 19:59 2687 7216 2020-07-03T23:59:00Z         2494 193   512288                     18 517 7618 512288 posNeg 8135 512288 6 41 204ef2df69c149b04e953e2ea4067fc2885ae883 0 0 0 0 0  
4723 4723 20200704 KS 15919 175642   191561   1219   377   156 842 A 7/3/2020 10:00 2020-07-03T10:00:00Z 07/03 06:00 277 1219 2020-07-03T10:00:00Z               191561                     20 0 0 191561 posNeg 0 191561 0 0 85fae0ceb24a7c2f3c7e477ff7ba8e1e121a7a96 0 0 0 0 0  
4724 4724 20200704 KY 16376 379271   395052 455 2685 99 996     4747 B 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 585 2685 2020-07-03T00:00:00Z 395052     15781 581 4     35019                   21 0 0 395647 posNeg 0 395647 0 0 9c1e3689e9a44fc0c60d067f4560b202570763f8 0 0 0 0 0  
4725 4725 20200704 LA 63289 720853   784142 852       93   43026 B 7/3/2020 13:00 2020-07-03T13:00:00Z 07/03 09:00 3278   2020-07-03T13:00:00Z       63289 3170 108   784142                     22 0 0 784142 posNeg 0 784142 0 0 6f7088613461f5972e24a7335bd2b9c10ad63f5b 0 0 0 0 0  
4728 4728 20200704 ME 3397 102548   105945 27 358 9   3   2751 A+ 7/3/2020 23:59 2020-07-03T23:59:00Z 07/03 19:59 107 358 2020-07-03T23:59:00Z 105560 4151 101249 3012 106 1     7700 353 7338               23 24 2472 105945 posNeg 2496 105945 2 0 520a8176ee468a7a9e5bc047128e60a1faeeb97c 0 0 0 0 0  
4733 4733 20200704 MS 30674 279241   309915 872 3268 175   88   19388 A 7/3/2020 19:00 2020-07-03T19:00:00Z 07/03 15:00 1107 3268 2020-07-03T19:00:00Z 309699     30458 1089 18     12522 95                 28 1904 8972 309915 posNeg 10876 309915 15 60 1bd35c17674f125dfb1cd7982a1c2fd3de42314c 0 0 0 0 0  
4737 4737 20200704 NE 19660 167928   187588 111 1365         14200 B 7/3/2020 20:00 2020-07-03T20:00:00Z 07/03 16:00 284 1365 2020-07-03T20:00:00Z       19660       187808                     31 208 3246 187588 posNeg 3454 187588 2 12 84124d952c0afa2c11b4eb71657cc1b4776d86ee 0 0 0 0 0  
4738 4738 20200704 NH 5857 117892   161306 25 569   163     4597 B 7/3/2020 09:00 2020-07-03T09:00:00Z 07/03 05:00 376 569 2020-07-03T09:00:00Z 161306     5857       123749 23085     20057             33 35 1527 123749 posNeg 2386 123749 1 2 e83c104eb521153bd624d0d85c6dfecd28080747 0 0 0 0 0  
4740 4740 20200704 NM 12776 350598   363374 130 1970         5802 B 7/3/2020 19:30 2020-07-03T19:30:00Z 07/03 15:30 511 1970 2020-07-03T19:30:00Z 363374     12776                             35 256 6481 363374 posNeg 6737 363374 8 25 69c69be5372be4ed001c689efee054cba9afd5be 0 0 0 0 0  
4742 4742 20200704 NY 396598 3773790   4170388 844 89995 190   119   70877 A 7/3/2020 23:59 2020-07-03T23:59:00Z 07/03 19:59 24896 89995 2020-07-03T23:59:00Z       396598     4170388                       36 726 61677 4170388 posNeg 62403 4170388 11 0 9ac51413a7d4cebce0bf409e2afb0bedab3ddd4c 0 0 0 0 0  
4749 4749 20200704 SC 43386 377307   420693 1190 2882         16994 A 7/3/2020 23:59 2020-07-03T23:59:00Z 07/03 19:59 813 2882 2020-07-03T23:59:00Z 420567 54851 365716 43260 806 7     41221 1908 39313               45 1854 9807 420693 posNeg 11661 420693 20 0 488a229ee0856a90fb38af9bb6fcf0be110d6adf 0 0 0 0 0  
4750 4750 20200704 SD 7028 76802   83830 54 689         6062 B 7/3/2020 18:00 2020-07-03T18:00:00Z 07/03 14:00 97 689 2020-07-03T18:00:00Z               83830                     46 50 787 83830 posNeg 837 83830 0 2 0f7769c9aa0502be9abf8dfe09a96248e1ebd89a 0 0 0 0 0  
4754 4754 20200704 VA 65109 634120 280 707750 808 9549 207   99   8741 A+ 7/3/2020 17:00 2020-07-03T17:00:00Z 07/03 13:00 1849 9549 2020-07-03T17:00:00Z   77536   62400 1745 104 707750                       51 716 10153 699509 posNeg 11709 699229 4 20 97aac4bdaed98c4d2a363116fb995ac84689e8a4 0 0 0 0 0  
4755 4755 20200704 VI 111 3060 2 3171             76 C 7/3/2020 19:39 2020-07-03T19:39:00Z 07/03 15:39 6   2020-07-03T19:39:00Z 3173       6                           78 13 97 3173 posNeg 110 3171 0 0 f2c87edd4075785958f7bac83060c9cc2ce11225 0 0 0 0 0  
4757 4757 20200704 WA 38863 686583   725446 315 4463     58     B 7/3/2020 02:59 2020-07-03T02:59:00Z 07/02 22:59 1352 4463 2020-07-03T02:59:00Z       38863 1352   725446 599975                     53 231 4403 725446 posNeg 4634 725446 10 21 32846286fca477773d41537ce879c1e5afaab99d 0 0 0 0 0  
4761 4761 20200703 AK 1063 119145   120208 25       3   539 A 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 15   2020-07-03T00:00:00Z 120208     1063 15                           2 46 4253 120208 posNeg 4299 120208 1 0 05c21fb27b83953f611108b6d7c2dbb8a8a9621e 0 0 0 0 0  
4762 4762 20200703 AL 41865 388766   430128 838 2883   838   474 22082 B 7/3/2020 11:00 2020-07-03T11:00:00Z 07/03 07:00 1006 2883 2020-07-03T11:00:00Z 430128     41362 983 23                         1 1754 9149 430631 posNeg 10907 430631 21 48 86bd55fd2d38a7566edb06d9ed7a9472f6812807 0 0 0 0 0  
4763 4763 20200703 AR 22622 308615   331237 285 1517     70 236 16164 A 7/3/2020 15:16 2020-07-03T15:16:00Z 07/03 11:16 281 1517 2020-07-03T15:16:00Z 331237     22622                             5 547 6703 331237 posNeg 7250 331237 2 40 ab71c0a32c0c039dfe3b1d7a26e678c5c6ed180a 0 0 0 0 0  
4765 4765 20200703 AZ 91858 486523   577919 3013 5018 741   489   10478 A+ 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 1788 5018 2020-07-03T00:00:00Z       91396 1673 115   577919 177849                   4 4433 13109 578381 posNeg 17535 578381 31 102 8d9034205671c685e69391e72baa874996e86cb7 0 0 0 0 0  
4766 4766 20200703 CA 248235 4199941   4448176 7024   1871         B 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 6263   2020-07-03T00:00:00Z 4448176     248235                             6 5688 103770 4448176 posNeg 109458 4448176 100 0 9e5d2232e91c8a0e8b8e984f2f43184ed585a3fa 0 0 0 0 0  
4772 4772 20200703 GA 90493 810724   901217 1671 11653   2413       A 7/3/2020 15:22 2020-07-03T15:22:00Z 07/03 11:22 2856 11653 2020-07-03T15:22:00Z 901217 82421 818796 90493         164412 8717                 13 2784 15194 901217 posNeg 17978 901217 7 153 4f9141fbcba881a63b10b19ab23ced40475969c9 0 0 0 0 0  
4773 4773 20200703 GU 286 14263   14549 2           179 B 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 5   2020-07-03T00:00:00Z 13925     278       14541 128 2                 66 6 610 14549 posNeg 616 14549 0 0 f23ab981596ce481d8a7840286fb038530520a5d 0 0 0 0 0  
4775 4775 20200703 IA 30429 291032   321461 146   40   20   24338 A+ 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 720   2020-07-03T00:00:00Z       30429       321958       33421 2347 31041         19 220 3703 321461 posNeg 3923 321461 2 0 33f55ef2277a9245530475ab21a790db792b89de 0 0 0 0 0  
4777 4777 20200703 IL 146872 1554885   1701757 1349   334   164     A 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 7215   2020-07-03T00:00:00Z 1700635     145750 7005 210                         17 937 33450 1701757 posNeg 34387 1701757 27 0 572335e909150d861136c8100247dadf8a45aaab 0 0 0 0 0  
4779 4779 20200703 KS 15919 175642   191561   1219   377   156 842 A 7/3/2020 10:00 2020-07-03T10:00:00Z 07/03 06:00 277 1219 2020-07-03T10:00:00Z               191561                     20 929 7459 191561 posNeg 8388 191561 5 24 35f890663f86b8340583209c8bf8d4487886023d 0 0 0 0 0  
4780 4780 20200703 KY 16376 379271   395052 455 2685 99 996     4747 B 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 585 2685 2020-07-03T00:00:00Z 395052     15781 581 4     35019                   21 297 9556 395647 posNeg 9829 395647 4 23 796d2ce90fdefb2b6dcd01ee37b88461cc56a3fe 0 0 0 0 0  
4781 4781 20200703 LA 63289 720853   784142 852       93   43026 B 7/3/2020 13:00 2020-07-03T13:00:00Z 07/03 09:00 3278   2020-07-03T13:00:00Z       63289 3170 108   784142                     22 1728 15040 784142 posNeg 16768 784142 23 0 43ee513f09b5dbd87c9689024310077e7226892e 0 0 0 0 0  
4782 4782 20200703 MA 109628 768152   1140333 656 11436 106   55   93157 A+ 7/3/2020 16:00 2020-07-03T16:00:00Z 07/03 12:00 8149 11436 2020-07-03T16:00:00Z 1140333 138420   104228 7935 214   872380       74598             25 290 11232 877780 totalTestsViral 8339 877780 17 44 5f17adb53eae169a29f79ab70efa31a1d75634fe 0 0 0 0 0  
4783 4783 20200703 MD 68961 494873   563834 422 10973 143       5023 A 7/3/2020 10:00 2020-07-03T10:00:00Z 07/03 06:00 3223 10973 2020-07-03T10:00:00Z 685813 80684   68961 3099 124   563834                     24 538 10121 563834 posNeg 10659 563834 11 34 f3f94e26dbd08b1dc395cbbd0fcfcd10649ea3d9 0 0 0 0 0  
4785 4785 20200703 MI 72175 1036090   1108265 548   193   92   51099 A+ 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 6215   2020-07-03T00:00:00Z 1125738 89648 1036090 65135 5969 246     168588                   26 497 22631 1108265 posNeg 23128 1108265 3 0 299552952495d72413fbd466b8fa1430e19bf18f 0 0 0 0 0  
4787 4787 20200703 MO 22830 382129   404959 716       78     B 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 1026   2020-07-03T00:00:00Z 424214 23527 399926 22830       404959       45079 1581 43498         29 547 7094 404959 posNeg 7641 404959 4 0 eaee802fd6d3c56d999f41ffb1088efbd19127fa 0 0 0 0 0  
4790 4790 20200703 MT 1128 96375   97503 17 109         678 C 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 23 109 2020-07-03T00:00:00Z 97503     1128                             30 45 2309 97503 posNeg 2354 97503 1 3 859011b6a5fd9f2df25c9691a0d39070b2fc596b 0 0 0 0 0  
4791 4791 20200703 NC 70241 929052   999293 951           45538 A 7/3/2020 12:00 2020-07-03T12:00:00Z 07/03 08:00 1392   2020-07-03T12:00:00Z 999293     70241 1392                           37 2099 26074 999293 posNeg 28173 999293 1 0 161c7e8254252542bd07f0cb0c404034e48dc5ff 0 0 0 0 0  
4792 4792 20200703 ND 3719 106852   189006 20 237         3266 D 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 78 237 2020-07-03T00:00:00Z 193035     3719 69 9 189006 108168 5051 192 4859               38 63 2314 110571 totalTestEncountersViral 4576 110571 0 3 9a30d61f025672a83dd0562adb0e71c8a958c95c 0 0 0 0 0  
4795 4795 20200703 NJ 172742 1312759   1485501 1028 20214 216   167   30464 A+ 7/3/2020 13:00 2020-07-03T13:00:00Z 07/03 09:00 15081 20214 2020-07-03T13:00:00Z 1485501     172742 13308 1773                         34 386 21202 1485501 posNeg 21588 1485501 58 73 cc1b4fcc4a9b9288a1c6ba35250a1a87ff8a1862 0 0 0 0 0  
4797 4797 20200703 NV 20718 272967   293685 704   219   87   727 A+ 7/3/2020 11:00 2020-07-03T11:00:00Z 07/03 07:00 528   2020-07-03T11:00:00Z 353255     20718       292132                     32 985 7972 293685 posNeg 8957 293685 3 0 b95c2da25b1e01f1b8f26d43122c2355e8a110eb 0 0 0 0 0  
4799 4799 20200703 OH 55257 772900   828157 740 8084 233 2044 100   39423 B 7/3/2020 14:00 2020-07-03T14:00:00Z 07/03 10:00 2903 8084 2020-07-03T14:00:00Z 824481     51581 2653 250                         39 1091 33760 828157 posNeg 34851 828157 0 46 6ea288c8573609cfc594456ef5b2ca1e152776d7 0 0 0 0 0  
4800 4800 20200703 OK 15065 348789   363854 391 1661 165       11519 A+ 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 398 1661 2020-07-03T00:00:00Z 366289 16721 348789 15065         34490 1171                 40 526 10278 363854 posNeg 10804 363854 3 46 bb958a2c907c9536c8ae0cd5122f0650f552ad8b 0 0 0 0 0  
4802 4802 20200703 PA 88741 715403   804144 598       105   69217 A+ 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 6746   2020-07-03T00:00:00Z       86205       801608                     42 667 13204 804144 posNeg 13871 804144 34 0 68812dbc33feb64ddb66489800dcd210038b2b9d 0 0 0 0 0  
4803 4803 20200703 PR 7683 192686   200369 104   11   6     C 7/3/2020 06:30 2020-07-03T06:30:00Z 07/03 02:30 154   2020-07-03T06:30:00Z 194324 2627 191601 1791 60 94       5892                 72 75 0 200369 posNeg 75 200369 1 0 a04d5dd412028baf403667924c0c3d15e97e6a5f 0 0 0 0 0  
4804 4804 20200703 RI 17057 140721   264265 61 2019 9   7   1657 A+ 7/3/2020 03:00 2020-07-03T03:00:00Z 07/02 23:00 960 2019 2020-07-03T03:00:00Z 260333 24425 235908 17057     264265 157778                     44 22 673 157778 totalTestEncountersViral 2876 157778 1 8 41ae925b44cb8f6364d83da5acce12baef9647c7 0 0 0 0 0  
4807 4807 20200703 TN 48712 813777   862489 949 2825         29591 B 7/3/2020 15:00 2020-07-03T15:00:00Z 07/03 11:00 633 2825 2020-07-03T15:00:00Z 862121 56644 805477 48344 608 25                         47 1822 22213 862489 posNeg 24035 862489 13 50 622dd20232286ff5c7fec6c7097619d1a8c52963 0 0 0 0 0  
4808 4808 20200703 TX 183532 1830374   2013906 7652           93572 B 7/3/2020 16:25 2020-07-03T16:25:00Z 07/03 12:25 2575   2020-07-03T16:25:00Z 2013906     183532         199041 7255                 48 7555 30548 2013906 posNeg 38103 2013906 50 0 f10ea7cb7f51ee8aa93c219ccfe8517806dcc265 0 0 0 0 0  
4809 4809 20200703 UT 23866 332770   356636 232 1529 85 434   193 13408 A+ 7/3/2020 11:46 2020-07-03T11:46:00Z 07/03 07:46 181 1529 2020-07-03T11:46:00Z       23866       356636             222 52 258 55 49 596 9654 356636 posNeg 10250 356636 5 24 c9cfef86aff00c66291b3a68e03e6dacc8b8b6b9 0 0 0 0 0  
4812 4812 20200703 VT 1236 67159   68395 16           967 B 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 56   2020-07-03T00:00:00Z       1236 56     68395                     50 9 1045 68395 posNeg 1054 68395 0 0 834bac8609916082b377f08f30a506153974cf9f 0 0 0 0 0  
4814 4814 20200703 WI 33431 573553 134 606984 244 3555 75 768     24043 A+ 7/3/2020 16:00 2020-07-03T16:00:00Z 07/03 12:00 803 3555 2020-07-03T16:00:00Z       30317 796 7   603870                     55 622 9607 607118 posNeg 10229 606984 3 36 35ba8aebc99fdc1afa7056cb4646c3547b5c573e 0 0 0 0 0  
4815 4815 20200703 WV 3126 177576   180702 25   11   4   2396 B 7/3/2020 17:00 2020-07-03T17:00:00Z 07/03 13:00 93   2020-07-03T17:00:00Z 180597     3021         10413                   54 73 2288 180702 posNeg 2361 180702 0 0 8d7dd48dab078a77ee833bda8fb44d6c72b199d6 0 0 0 0 0  
4816 4816 20200703 WY 1582 33693   35275 8 119         1154 B 7/3/2020 11:24 2020-07-03T11:24:00Z 07/03 07:24 20 119 2020-07-03T11:24:00Z 47932 1342 46589 1267       34926                     56 32 0 35275 posNeg 32 35275 0 0 fa54695cf699c306be4fe31e715aa074ec1d0f5d 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
);