states_daily_4pm_et

Table actions

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

61 rows where "dateChecked" is on date 2020-08-14

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, 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-08-14 · 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
2304 2304 20200816 CT 50897 886793   937690 56 11015         8809 B 8/14/2020 16:00 2020-08-14T16:00:00Z 08/14 12:00 4453 11015 2020-08-14T16:00:00Z 935680     48887 3569 884                         9 0 0 937690 posNeg 0 937690 0 0 2c111324f880b1102584ebd288ffb56db1c31fa8 0 0 0 0 0  
2310 2310 20200816 HI 4825 154474   159299 143 279 35   25   1808 C 8/14/2020 22:38 2020-08-14T22:38:00Z 08/14 18:38 40 279 2020-08-14T22:38:00Z 202753             159299                     15 282 2751 159299 posNeg 3033 159299 0 2 c8b0fa4a600eed413b4a84b433d4222d71b616bb 0 0 0 0 0  
2315 2315 20200816 KS 33885 309158   343043 311 2020 98 554 33 198 1399 A+ 8/14/2020 10:00 2020-08-14T10:00:00Z 08/14 06:00 402 2020 2020-08-14T10:00:00Z               343043                     20 0 0 343043 posNeg 0 343043 0 0 4f4c7c097a9d7a1082eb3d3da218ef519a3ab13f 0 0 0 0 0  
2324 2324 20200816 MP 50 12252   12302   4         29 D 8/14/2020 04:04 2020-08-14T04:04:00Z 08/14 00:04 2 4 2020-08-14T04:04:00Z 14419     50       12301                     69 0 0 12302 posNeg 0 12302 0 0 e29785632491865005d223c8b32dbaa71785877d 0 0 0 0 0  
2359 2359 20200815 CO 52538 567787   848795 236 6718         5660 A 8/14/2020 01:59 2020-08-14T01:59:00Z 08/13 21:59 1768 6718 2020-08-14T01:59:00Z       48985     848795 616772 148122 10189 137933               8 319 6640 620325 totalTestEncountersViral 11505 620325 5 18 61412eaaa7a7e03e2fc7430ac3e1584274a59c68 0 0 0 0 0  
2360 2360 20200815 CT 50897 886793   937690 56 11015         8809 B 8/14/2020 16:00 2020-08-14T16:00:00Z 08/14 12:00 4453 11015 2020-08-14T16:00:00Z 935680     48887 3569 884                         9 0 0 937690 posNeg 0 937690 0 0 61a5657784db87a3e598c1d8515c26a62f192b0a 0 0 0 0 0  
2361 2361 20200815 DC 13159 226057   239216 81   28   14   10452 A+ 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 597   2020-08-14T00:00:00Z             239216 155182                     11 41 2870 239216 posNeg 2911 239216 3 0 5386968db49dd6a4dc2fd12432367d6c8085ef0b 0 0 0 0 0  
2362 2362 20200815 DE 16396 192365   208761 32   10       8649 A+ 8/14/2020 18:00 2020-08-14T18:00:00Z 08/14 14:00 593   2020-08-14T18:00:00Z       15392 524 69   208761                     10 56 1230 208761 posNeg 1286 208761 0 0 e4e8d055003cf935094e645857bdb5b1c4e95930 0 0 0 0 0  
2363 2363 20200815 FL 569637 3633088 3790 4202725 5721 34074           A 8/14/2020 23:59 2020-08-14T23:59:00Z 08/14 19:59 9480 34074 2020-08-14T23:59:00Z 5632204 726846 4875096 569637 9480     4209375 408950 27323 381574 401862 26788 375046   5683     12 6352 35808 4206515 posNeg 42160 4202725 204 506 55732bb1f70fe14ca41bafccc8bc3510b3b4efe8 0 0 0 0 0  
2365 2365 20200815 GU 502 26594   27096 8   2       345 A 8/14/2020 05:05 2020-08-14T05:05:00Z 08/14 01:05 5   2020-08-14T05:05:00Z 27086     494       27088 153 2                 66 0 0 27096 posNeg 0 27096 0 0 1dd3d41f4b11dccf09dc72d8b8a1161052ef7d68 0 0 0 0 0  
2366 2366 20200815 HI 4543 151723   156266 173 277 41   22   1756 C 8/14/2020 22:38 2020-08-14T22:38:00Z 08/14 18:38 40 277 2020-08-14T22:38:00Z 198152             156266                     15 231 2418 156266 posNeg 2649 156266 0 10 849a41c27b8a227622ba8a35dfc0aafecc7d502d 0 0 0 0 0  
2368 2368 20200815 ID 27173 193839   219224 206 1091 38 309     10369 A 8/14/2020 19:00 2020-08-14T19:00:00Z 08/14 15:00 265 1091 2020-08-14T19:00:00Z 219224     25385 239 26                         16 542 2249 221012 posNeg 2751 221012 14 23 71e71bd35cf46e71b4856a1c003e05a16569483f 0 0 0 0 0  
2370 2370 20200815 IN 79676 817939   897615 922 9872 267 2032 88   59488 A+ 8/14/2020 23:59 2020-08-14T23:59:00Z 08/14 19:59 3128 9872 2020-08-14T23:59:00Z 1149279       2921 207   897615                     18 1044 10082 897615 posNeg 11126 897615 15 71 afaa7cad17051ad94e115a28c92756ba08c1870d 0 0 0 0 0  
2371 2371 20200815 KS 33885 309158   343043 311 2020 98 554 33 198 1399 A+ 8/14/2020 10:00 2020-08-14T10:00:00Z 08/14 06:00 402 2020 2020-08-14T10:00:00Z               343043                     20 0 0 343043 posNeg 0 343043 0 0 404eb5f59e6ed884d3fd902d9167bd49c542c921 0 0 0 0 0  
2373 2373 20200815 LA 136737 1500275   1637012 1243       197   103512 A 8/14/2020 13:00 2020-08-14T13:00:00Z 08/14 09:00 4430   2020-08-14T13:00:00Z       136737 4307 123   1637012                     22 0 0 1637012 posNeg 0 1637012 0 0 0a73bb5d1ae86d212e8ed3f40f177c6ae7a68c98 0 0 0 0 0  
2376 2376 20200815 ME 4144 203210   207354 5 399 2   1   3616 A+ 8/14/2020 23:59 2020-08-14T23:59:00Z 08/14 19:59 127 399 2020-08-14T23:59:00Z 206936 5215 201496 3726 126 1     9208 454 8741               23 29 2282 207354 posNeg 2311 207354 1 0 7f2d8ecad1a4417e424e4065d27e08388ccc0403 0 0 0 0 0  
2378 2378 20200815 MN 64413 920060   1236918 307 5822 140 1691     57457 A 8/14/2020 17:00 2020-08-14T17:00:00Z 08/14 13:00 1745 5822 2020-08-14T17:00:00Z       64413 1699 46 1236918 984473                     27 690 10237 984473 posNeg 17102 984473 6 39 7458546eb8f0792bc52a4e6992578536770b1157 0 0 0 0 0  
2380 2380 20200815 MP 50 12252   12302   4         29 D 8/14/2020 04:04 2020-08-14T04:04:00Z 08/14 00:04 2 4 2020-08-14T04:04:00Z 14419     50       12301                     69 0 0 12302 posNeg 0 12302 0 0 9a091737f61ec37dbcb01bc4004246941f7efa3a 0 0 0 0 0  
2381 2381 20200815 MS 71755 448010   519765 1126 4916 321   176   49836 A+ 8/14/2020 19:00 2020-08-14T19:00:00Z 08/14 15:00 2080 4916 2020-08-14T19:00:00Z 518057     70047 2000 80     18253 95                 28 825 7898 519765 posNeg 8723 519765 37 43 c76b8cb36f19da7f11051764c790e91a29e8d683 0 0 0 0 0  
2385 2385 20200815 NE 29988 287695   317683 145 1880         22004 A 8/14/2020 20:23 2020-08-14T20:23:00Z 08/14 16:23 361 1880 2020-08-14T20:23:00Z       29988       317977                     31 328 3131 317683 posNeg 3459 317683 1 0 29483881eba0dd2291a55b77b802a3f679f2958e 0 0 0 0 0  
2388 2388 20200815 NM 23160 635882   659042 125 2946         10182 B 8/14/2020 17:50 2020-08-14T17:50:00Z 08/14 13:50 703 2946 2020-08-14T17:50:00Z 659042     23160                             35 173 8378 659042 posNeg 8551 659042 6 18 ac77c719e0583315f34bfcdbd0a7762b8014adaf 0 0 0 0 0  
2390 2390 20200815 NY 424901 6565603   6990504 523 89995 120   58   74081 A 8/14/2020 23:59 2020-08-14T23:59:00Z 08/14 19:59 25244 89995 2020-08-14T23:59:00Z       424901     6990504                       36 734 87934 6990504 posNeg 88668 6990504 12 0 016cbb11300325b9924c191d8ac6f566d5abcc30 0 0 0 0 0  
2397 2397 20200815 SC 105882 754518   860400 1246 6852 311   181   42730 A+ 8/14/2020 23:59 2020-08-14T23:59:00Z 08/14 19:59 2260 6852 2020-08-14T23:59:00Z 859392 139470 719922 104874 2156 104     60532 4640 55892               45 1041 7575 860400 posNeg 8616 860400 56 0 a0c74ef14b0df5a1c57df9fabd6e88646fc5bee1 0 0 0 0 0  
2398 2398 20200815 SD 10118 117331   127449 63 913         8884 A 8/14/2020 14:00 2020-08-14T14:00:00Z 08/14 10:00 152 913 2020-08-14T14:00:00Z 162315             127449                     46 94 1341 127449 posNeg 1435 127449 2 10 cf76c10139f5ad01283323dabbddb93180fb558a 0 0 0 0 0  
2402 2402 20200815 VA 105750 1231490 407 1332938 1271 14965 279   167   13694 A+ 8/14/2020 17:00 2020-08-14T17:00:00Z 08/14 13:00 2381 14965 2020-08-14T17:00:00Z   122373   101448 2265 116 1332938                       51 912 16056 1337647 posNeg 16901 1337240 11 189 ec7c4c062d16cb819487aafe9350dbc0b763e539 0 0 0 0 0  
2403 2403 20200815 VI 734 11383 16 12117             519 C 8/14/2020 22:56 2020-08-14T22:56:00Z 08/14 18:56 9   2020-08-14T22:56:00Z 12133       9                           78 30 88 12133 posNeg 118 12117 0 0 304118e34df3a6b2a135a88b60c4687806004598 0 0 0 0 0  
2409 2409 20200814 AK 4869 291060   295929 38       3   1371 A 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 27   2020-08-14T00:00:00Z 295929 4698 290927 4869 27                           2 119 1757 295929 posNeg 1876 295929 0 0 db5df391c1971a4902e514667c0bbd2ecfab6d6a 0 0 0 0 0  
2410 2410 20200814 AL 106309 718675   820871 1326 12456   1305   716 41523 B 8/14/2020 11:00 2020-08-14T11:00:00Z 08/14 07:00 1893 12456 2020-08-14T11:00:00Z 820871     102196 1825 68                         1 752 21670 824984 posNeg 22370 824984 3 0 1936f2a333b1db027ed7f1067acb6107d5ad5979 0 0 0 0 0  
2411 2411 20200814 AR 52392 536268   588660 466 3566     113 466 45446 A 8/14/2020 14:34 2020-08-14T14:34:00Z 08/14 10:34 587 3566 2020-08-14T14:34:00Z 588660   536268 52392                         7090 1085 5 626 4554 588660 posNeg 5180 588660 5 0 474a2a04ea202296757274ff81c5e80bb0bdfe40 0 0 0 0 0  
2413 2413 20200814 AZ 191721 875854   1066146 1359 20515 473   324   27029 A+ 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 4423 20515 2020-08-14T00:00:00Z       190292 4169 254   1066146 248666                   4 927 8470 1067575 posNeg 9376 1067575 40 12 76ababf8eb2103c0b1d0978120aa4c3c348615bc 0 0 0 0 0  
2414 2414 20200814 CA 601075 8955523   9556598 6364   1850         B 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 10996   2020-08-14T00:00:00Z 9556598     601075                             6 7934 103171 9556598 posNeg 111105 9556598 188 0 6fb6325ad26b871b5e35147dceaf14acb3892665 0 0 0 0 0  
2420 2420 20200814 GA 231895 1738158   1970053 2691 21818   3999       A 8/14/2020 14:50 2020-08-14T14:50:00Z 08/14 10:50 4573 21818 2020-08-14T14:50:00Z 1970053 212140 1757913 231895         249475 17442                 13 3227 24216 1970053 posNeg 27443 1970053 35 237 a24007a496917190edb5a5db5af4f75eb9726f4a 0 0 0 0 0  
2421 2421 20200814 GU 502 26594   27096 8   2       345 A 8/14/2020 05:05 2020-08-14T05:05:00Z 08/14 01:05 5   2020-08-14T05:05:00Z 27086     494       27088 153 2                 66 25 391 27096 posNeg 416 27096 0 0 837605b3f92aed1c65ad211ce770f562c91f6286 0 0 0 0 0  
2423 2423 20200814 IA 50932 489305   540237 258   75   28   39879 A+ 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 966   2020-08-14T00:00:00Z       50932       543482       43518 2901 40578         19 596 4828 540237 posNeg 5424 540237 7 0 63c8212a0ea7feebb7846d9753c66c04b7f9448c 0 0 0 0 0  
2425 2425 20200814 IL 204023 3082657   3286680 1612   345   126     A 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 7932   2020-08-14T00:00:00Z 3285348     202691 7721 211                         17 2296 47277 3286680 posNeg 49573 3286680 27 0 7f60e7c2e4a3b968a3112f3c4224d153de965263 0 0 0 0 0  
2427 2427 20200814 KS 33885 309158   343043 311 2020 98 554 33 198 1399 A+ 8/14/2020 10:00 2020-08-14T10:00:00Z 08/14 06:00 402 2020 2020-08-14T10:00:00Z               343043                     20 1338 7142 343043 posNeg 8480 343043 7 45 d9eb0e1f7d19edb5461b9af4d820f62cf269d5e0 0 0 0 0 0  
2428 2428 20200814 KY 38298 662344   697909 656 4158 147 1296     9021 B 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 804 4158 2020-08-14T00:00:00Z 697909     35565 799 5     44926               665   21 612 12410 700642 posNeg 12939 700642 8 42 7495847567f40faf48a7062ef550bd9975e2e6c3 0 0 0 0 0  
2429 2429 20200814 LA 136737 1500275   1637012 1243       197   103512 A 8/14/2020 13:00 2020-08-14T13:00:00Z 08/14 09:00 4430   2020-08-14T13:00:00Z       136737 4307 123   1637012                     22 1298 19734 1637012 posNeg 21032 1637012 28 0 ea8b0d66c52400ef1385f81663380db5d096eec2 0 0 0 0 0  
2430 2430 20200814 MA 122531 1289001   1853032 398 12150 58   31   100486 A+ 8/14/2020 10:00 2020-08-14T10:00:00Z 08/14 06:00 8804 12150 2020-08-14T10:00:00Z 1853032 150223   113729 8582 222   1402730       104191     64773       25 212 21340 1411532 totalTestsViral 32001 1411532 14 19 93895650ee8df919b1a721235f9e1399349d2cef 0 0 0 0 0  
2431 2431 20200814 MD 98875 1011398   1110273 457 13508 107       5986 A 8/14/2020 10:00 2020-08-14T10:00:00Z 08/14 06:00 3631 13508 2020-08-14T10:00:00Z 1552070 116321   98875 3495 136   1110273                     24 715 14464 1110273 posNeg 15179 1110273 11 45 82404f2d70b9d9503988caa1d2283ac451e51d93 0 0 0 0 0  
2433 2433 20200814 MI 100724 2160427   2261151 713   184   87   63636 A+ 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 6566   2020-08-14T00:00:00Z 2288733 128306 2160427 91140 6300 266     235572                   26 868 37897 2261151 posNeg 38765 2261151 11 0 898b30ac0ab7f03e45a59672505cbf19c2617aac 0 0 0 0 0  
2435 2435 20200814 MO 65270 759599   824869 882       107     A 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 1335   2020-08-14T00:00:00Z 1093970 75959 1016099 65270       824869       63781 2460 61321         29 1473 12039 824869 posNeg 13512 824869 10 0 41563e3967551a518d3528067519b864d52a09ba 0 0 0 0 0  
2436 2436 20200814 MP 50 12252   12302   4         29 D 8/14/2020 04:04 2020-08-14T04:04:00Z 08/14 00:04 2 4 2020-08-14T04:04:00Z 14419     50       12301                     69 1 0 12302 posNeg 1 12302 0 0 dc9d6207fc769c5c706064a69c1aeb74ae721781 0 0 0 0 0  
2438 2438 20200814 MT 5541 194320   199861 86 319         4011 C 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 81 319 2020-08-14T00:00:00Z 199861     5541                             30 134 1907 199861 posNeg 2041 199861 0 4 1220a229c6c2173ed1792e05bed842f9c7cf7007 0 0 0 0 0  
2439 2439 20200814 NC 142170 1735232   1877402 1049   308       116969 A+ 8/14/2020 11:50 2020-08-14T11:50:00Z 08/14 07:50 2313   2020-08-14T11:50:00Z 1877402     142170 2313                           37 1346 25367 1877402 posNeg 26713 1877402 26 0 ddb8f711eaaa2e84d7d84294c6b85ffd89681fb6 0 0 0 0 0  
2440 2440 20200814 ND 8316 168281   373550 65 455         7066 C 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 105 455 2020-08-14T00:00:00Z 385271     8316 101 4 373550 174087 7975 292 7683               38 152 1412 176597 totalTestEncountersViral 5241 176597 0 10 6dc8d3b375c64731dd865baf850aef4d8ac57632 0 0 0 0 0  
2443 2443 20200814 NJ 187164 2242677   2429841 514 22161 91   40   33223 A+ 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 15851 22161 2020-08-14T00:00:00Z 2429841     187164 14064 1787                         34 570 25581 2429841 posNeg 26151 2429841 10 36 881a70cf7595c6fb283e8f8ab2f53216f0076915 0 0 0 0 0  
2445 2445 20200814 NV 59749 478455   538204 948   260   166   1423 A+ 8/14/2020 02:59 2020-08-14T02:59:00Z 08/13 22:59 1045   2020-08-14T02:59:00Z 735891     59749       538202                     32 1099 3961 538204 posNeg 5060 538204 15 0 6069951aba79da750647feb89383c61789e62d55 0 0 0 0 0  
2447 2447 20200814 OH 106557 1672852   1779409 925 12128 319 2755 170   84904 A+ 8/14/2020 14:00 2020-08-14T14:00:00Z 08/14 10:00 3784 12128 2020-08-14T14:00:00Z 1773797     100945 3510 274                         39 1131 24971 1779409 posNeg 26102 1779409 29 105 45f22e02852a7240a2415553118042a9a5dfa806 0 0 0 0 0  
2448 2448 20200814 OK 46897 696345   743242 567 3953 240       39282 A+ 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 644 3953 2020-08-14T00:00:00Z 751437 53700 696345 46897         65475 2649                 40 794 11176 743242 posNeg 11970 743242 6 52 8688262724ff79ffc6d72a8b6f8f3db0813afc63 0 0 0 0 0  
2449 2449 20200814 OR 22613 450494   473107 224 1863 57   16   4355 A+ 8/14/2020 03:01 2020-08-14T03:01:00Z 08/13 23:01 385 1863 2020-08-14T03:01:00Z     450494 21441       471935                     41 313 5531 473107 posNeg 5844 473107 2 10 e20ea5161989f532a08c2a483bba1c325e9475d6 0 0 0 0 0  
2450 2450 20200814 PA 122950 1304739   1427689 585       103   95901 A+ 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 7445   2020-08-14T00:00:00Z       119512       1424251                     42 829 15866 1427689 posNeg 16695 1427689 36 0 34c67031813e0f906d5247aaf490cffa3bce8b0a 0 0 0 0 0  
2451 2451 20200814 PR 25128 305972   331100 428   70   49     B 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 317   2020-08-14T00:00:00Z 310546 7002 303412 10730 192 125       14398                 72 682 0 331100 posNeg 682 331100 11 0 ac91f993ca3b202049abb906538fce57198e0fbd 0 0 0 0 0  
2452 2452 20200814 RI 20335 209530   420733 79 2350 8   3   1953 A+ 8/14/2020 12:00 2020-08-14T12:00:00Z 08/14 08:00 1021 2350 2020-08-14T12:00:00Z   29007 390466 20335     420733 229865                     44 95 1296 229865 totalTestEncountersViral 4530 229865 2 9 40ba17df6052a2a45eb8e5ba3c7794c5c0a687ed 0 0 0 0 0  
2455 2455 20200814 TN 130458 1681585   1812043 1264 5725 398   176   91323 A+ 8/14/2020 15:00 2020-08-14T15:00:00Z 08/14 11:00 1326 5725 2020-08-14T15:00:00Z 1809900 154266 1655634 128315 1285 41                         47 1947 22375 1812043 posNeg 24322 1812043 13 77 f8c47f3c3fbb1b1ac246408b6138e3a97b7a4156 0 0 0 0 0  
2456 2456 20200814 TX 520593 3761448   4282041 6632   2380       383717 A 8/14/2020 16:05 2020-08-14T16:05:00Z 08/14 12:05 9602   2020-08-14T16:05:00Z 4282041     520593         312727 22100             17009 2591 48 7018 44260 4282041 posNeg 51278 4282041 313 0 9120cd1b4847d89b81271c41c8bab53ac3798ab1 0 0 0 0 0  
2457 2457 20200814 UT 45976 543841   589817 190 2744 69 702   285 36679 A+ 8/14/2020 10:32 2020-08-14T10:32:00Z 08/14 06:32 360 2744 2020-08-14T10:32:00Z 716883     45976       589817             2086 671 2521 720 49 552 4609 589817 posNeg 5161 589817 7 23 3942502304938c26469e05910eb512ec3bf15a22 0 0 0 0 0  
2460 2460 20200814 VT 1501 105916   107417 13           1321 B 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 58   2020-08-14T00:00:00Z       1501 58     107417                     50 17 1493 107417 posNeg 1510 107417 0 0 6fe98dc7120922224f3bbafc1720b88e48a5118f 0 0 0 0 0  
2462 2462 20200814 WI 68681 1044613 239 1113294 336 5235 110 951     54181 A+ 8/14/2020 00:00 2020-08-14T00:00:00Z 08/13 20:00 1032 5235 2020-08-14T00:00:00Z       64227 1025 7   1108840                     55 1059 9418 1113533 posNeg 10477 1113294 7 65 e59ed598da2b688cd277bc7a97f475407bcbc801 0 0 0 0 0  
2463 2463 20200814 WV 8274 336426   344700 135   52   18   6144 B 8/14/2020 10:00 2020-08-14T10:00:00Z 08/14 06:00 157   2020-08-14T10:00:00Z 344530     8104 156 1     14999                   54 123 5062 344700 posNeg 5185 344700 4 0 18533e53d3633cc09d00c528f63ca0a01f07a1fc 0 0 0 0 0  
2464 2464 20200814 WY 3183 56809   59992 13 191         2641 B 8/14/2020 18:08 2020-08-14T18:08:00Z 08/14 14:08 30 191 2020-08-14T18:08:00Z 85877 2748 83128 2694       59503                     56 64 357 59992 posNeg 421 59992 0 2 b8bbd1b9749abc7d32ea8076f5b2bafce621f120 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
);