states_daily_4pm_et

Table actions

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

61 rows where "dateChecked" is on date 2020-07-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, 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-10 · 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
4269 4269 20200712 GU 312 16667   16979 3           202 B 7/10/2020 23:15 2020-07-10T23:15:00Z 07/10 19:15 5   2020-07-10T23:15:00Z 16858     304       16971 142 2                 66 0 0 16979 posNeg 0 16979 0 0 a2fe3e0c32a8db9110491ed3923d0b19f6c98c7c 0 0 0 0 0  
4275 4275 20200712 KS 18611 199168   217779   1304   405   160 905 A 7/10/2020 10:00 2020-07-10T10:00:00Z 07/10 06:00 284 1304 2020-07-10T10:00:00Z               217779                     20 0 0 217779 posNeg 0 217779 0 0 8bb91d91e6b146f9118cbfb9708954fcbf03a9e6 0 0 0 0 0  
4300 4300 20200712 RI 17312 149343   292723 61 2051 4   5   1685 A+ 7/10/2020 12:00 2020-07-10T12:00:00Z 07/10 08:00 976 2051 2020-07-10T12:00:00Z 278357 24885 253472 17312     292723 166655                     44 0 0 166655 totalTestEncountersViral 2934 166655 0 0 45e060efd3d08b26edb88de8af5bfd27b5f810e3 0 0 0 0 0  
4301 4301 20200712 SC 56648 435860   492508 1472 3398         20957 A 7/10/2020 23:59 2020-07-10T23:59:00Z 07/10 19:59 961 3398 2020-07-10T23:59:00Z 492345 69920 422425 56485 950 11     44173 2086 42087               45 1949 2469 492508 posNeg 4418 492508 10 0 95ab9b250ec479da7c92f79d1f660df23e4ba335 0 0 0 0 0  
4309 4309 20200712 WA 44675 778827   823502 326 4662     57     B 7/10/2020 02:59 2020-07-10T02:59:00Z 07/09 22:59 1424 4662 2020-07-10T02:59:00Z       44675 1424   823502 668466                     53 334 5048 823502 posNeg 5382 823502 0 0 d2e44ecf2902b0223b8872d422a1cb8bc08f3115 0 0 0 0 0  
4314 4314 20200711 AL 51947 450073   501367 1093 6745   904   496 25783 B 7/10/2020 11:00 2020-07-10T11:00:00Z 07/10 07:00 1114 6745 2020-07-10T11:00:00Z 501367     51294 1086 28                         1 1439 8365 502020 posNeg 9767 502020 10 3656 c1a6a7493f4f4341ac48c81aad7ac2d97ae8a24d 0 0 0 0 0  
4315 4315 20200711 AR 26803 342846   369649 402 1780     84 265 20642 A 7/10/2020 19:46 2020-07-10T19:46:00Z 07/10 15:46 313 1780 2020-07-10T19:46:00Z 369649     26803                             5 0 4237 369649 posNeg 4988 369649 0 37 8b21be22ee34bf74872b7ea4ac72c23acb892c7f 0 0 0 0 0  
4321 4321 20200711 DC 10801 113249   124050 92   29   17   1717 A+ 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 568   2020-07-10T00:00:00Z             124050 93312                     11 58 3108 124050 posNeg 3166 124050 0 0 c7632c0a6b8f446494bda6d9d7953ca1f748d2a7 0 0 0 0 0  
4322 4322 20200711 DE 12743 121372   134115 65   13       7002 A+ 7/10/2020 18:00 2020-07-10T18:00:00Z 07/10 14:00 517   2020-07-10T18:00:00Z       11699 460 57   134115                     10 91 1316 134115 posNeg 1407 134115 0 0 71e9eba615752d54db23391148196a80e9e6ee93 0 0 0 0 0  
4325 4325 20200711 GU 312 16667   16979 3           202 B 7/10/2020 23:15 2020-07-10T23:15:00Z 07/10 19:15 5   2020-07-10T23:15:00Z 16858     304       16971 142 2                 66 2 111 16979 posNeg 113 16979 0 0 eec2050de7d18dd7f92ff4d2d96120294781d894 0 0 0 0 0  
4326 4326 20200711 HI 1158 91076   92234   125         847 D 7/10/2020 18:00 2020-07-10T18:00:00Z 07/10 14:00 19 125 2020-07-10T18:00:00Z 109096             92234                     15 28 1611 92234 posNeg 1639 92234 0 2 00d5c962b5a864f24fdb9a941e7e88ace4e20a2f 0 0 0 0 0  
4328 4328 20200711 ID 9928 112421   121640 122 449 33 138     3066 A 7/10/2020 19:00 2020-07-10T19:00:00Z 07/10 15:00 101 449 2020-07-10T19:00:00Z 121640     9219 81 20                         16 500 3771 122349 posNeg 4250 122349 1 17 0699732beaeed77eb04dcb199f21ee0afdc225e3 0 0 0 0 0  
4330 4330 20200711 IN 51079 507067   558146 714 7458 237 1577 72   38441 A+ 7/10/2020 23:59 2020-07-10T23:59:00Z 07/10 19:59 2756 7458 2020-07-10T23:59:00Z         2563 193   558146                     18 779 6805 558146 posNeg 7584 558146 8 0 3e42490116b42f413d0a01840cd98c2162305aaa 0 0 0 0 0  
4331 4331 20200711 KS 18611 199168   217779   1304   405   160 905 A 7/10/2020 10:00 2020-07-10T10:00:00Z 07/10 06:00 284 1304 2020-07-10T10:00:00Z               217779                     20 0 0 217779 posNeg 0 217779 0 0 60358464e8c97868876e837a6667a2364cacca03 0 0 0 0 0  
4336 4336 20200711 ME 3520 116370   119890 16 368 7   4   2972 A+ 7/10/2020 23:59 2020-07-10T23:59:00Z 07/10 19:59 112 368 2020-07-10T23:59:00Z 119501 4322 115011 3131 111 1     8035 369 7658               23 21 1463 119890 posNeg 1484 119890 1 2 b6559af027340f97ebc858b23b5b8244b20aa250 0 0 0 0 0  
4338 4338 20200711 MN 41571 700524   742095 241 4366 121 1325     36012 A 7/10/2020 17:00 2020-07-10T17:00:00Z 07/10 13:00 1537 4366 2020-07-10T17:00:00Z       41571 1499 38 742095                       27 804 15466 742095 posNeg 16270 742095 4 37 6fd2ece78cbf7b5505c113077b6dd8bdd42b947d 0 0 0 0 0  
4341 4341 20200711 MS 35419 298924   334343 963 3495 202   107   22167 A 7/10/2020 19:00 2020-07-10T19:00:00Z 07/10 15:00 1230 3495 2020-07-10T19:00:00Z 334029     35105 1208 22     13123 95                 28 797 3234 334343 posNeg 4031 334343 15 40 63f1ef523728bb7672a2c458fe4acf33265968c1 0 0 0 0 0  
4344 4344 20200711 ND 4240 116608   218947 31 263         3533 D 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 78 263 2020-07-10T00:00:00Z 224033     4240 74 4 218947 118316 5716 203 5513               38 88 1166 120848 totalTestEncountersViral 4058 120848 0 3 348317f6aae790994b682147f776f021dc2accc9 0 0 0 0 0  
4345 4345 20200711 NE 20777 183077   203854 95 1419         15499 B 7/10/2020 20:00 2020-07-10T20:00:00Z 07/10 16:00 286 1419 2020-07-10T20:00:00Z       20777       204091                     31 154 2686 203854 posNeg 2840 203854 2 0 9925eeb2d31172232f4c4be820bc66ccea58c5df 0 0 0 0 0  
4346 4346 20200711 NH 5991 126311   177819 20 585   190     4897 B 7/10/2020 09:00 2020-07-10T09:00:00Z 07/10 05:00 390 585 2020-07-10T09:00:00Z 177819     5991       132302 24425     21186             33 18 1233 132302 posNeg 2727 132302 3 4 819d07d3c4cf320b9fdec2e332a7be1f7e68150a 0 0 0 0 0  
4348 4348 20200711 NM 14549 389032   403581 151 2161         6181 B 7/10/2020 18:17 2020-07-10T18:17:00Z 07/10 14:17 539 2161 2020-07-10T18:17:00Z 403581     14549                             35 298 7402 403581 posNeg 7700 403581 6 24 457a443b8879a5e4387599f5a3a26c0b27e64aa5 0 0 0 0 0  
4349 4349 20200711 NV 26838 314395   341233 918   241   122   764 A+ 7/10/2020 12:00 2020-07-10T12:00:00Z 07/10 08:00 592   2020-07-10T12:00:00Z 425027     26838       340338                     32 930 4812 341233 posNeg 5742 341233 13 0 3bfdfa1d75b676be5f220a6ef2554947ce303d26 0 0 0 0 0  
4350 4350 20200711 NY 401029 4209748   4610777 799 89995 177   100   71477 A 7/10/2020 23:59 2020-07-10T23:59:00Z 07/10 19:59 24974 89995 2020-07-10T23:59:00Z       401029     4610777                       36 730 68473 4610777 posNeg 69203 4610777 6 0 ad13b028eb1c5d8650267075e3609a852ae2de99 0 0 0 0 0  
4356 4356 20200711 RI 17312 149343   289789 61 2051 4   5   1685 A+ 7/10/2020 12:00 2020-07-10T12:00:00Z 07/10 08:00 976 2051 2020-07-10T12:00:00Z 278357 24885 253472 17312     289789 166655                     44 0 0 166655 totalTestEncountersViral 4507 166655 0 0 d778052aa886da27ba56cb8dc2cfa6fb991e57d1 0 0 0 0 0  
4357 4357 20200711 SC 54699 433391   488090 1396 3398         20956 A 7/10/2020 23:59 2020-07-10T23:59:00Z 07/10 19:59 951 3398 2020-07-10T23:59:00Z 487929 68604 419325 54538 940 11     44312 2055 42257               45 2280 10575 488090 posNeg 12855 488090 22 0 a6b85fc4b6f6f65fba9aaf5c5476a602b03f58d3 0 0 0 0 0  
4362 4362 20200711 VA 69782 716553 365 797916 1020 10291 230   97   9271 A+ 7/10/2020 17:00 2020-07-10T17:00:00Z 07/10 13:00 1962 10291 2020-07-10T17:00:00Z   83832   66963 1857 105 797916                       51 851 16759 786700 posNeg 16539 786335 4 96 936d4a638eac147e00ffb21c08f65e713cd54826 0 0 0 0 0  
4363 4363 20200711 VI 167 3640 58 3807             92 C 7/10/2020 20:30 2020-07-10T20:30:00Z 07/10 16:30 6   2020-07-10T20:30:00Z 3865       6                           78 14 167 3865 posNeg 181 3807 0 0 3e82e660904c4fffeee3946ae4abc8e0b3b74f33 0 0 0 0 0  
4365 4365 20200711 WA 44341 773779   818120 326 4662     57     B 7/10/2020 02:59 2020-07-10T02:59:00Z 07/09 22:59 1424 4662 2020-07-10T02:59:00Z       44341 1424   818120 668466                     53 526 9817 818120 posNeg 10343 818120 15 -3 db57d56483794efefc04447a1ac0a8b1f901d4f2 0 0 0 0 0  
4369 4369 20200710 AK 1323 140608   141931 30       0   588 A 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 17   2020-07-10T00:00:00Z 141931     1323 17                           2 51 6136 141931 posNeg 6187 141931 0 0 34676751af121b48a66675a8accf9024fb26327c 0 0 0 0 0  
4370 4370 20200710 AL 50508 441708   491600 1201 3089   888   493 25783 B 7/10/2020 11:00 2020-07-10T11:00:00Z 07/10 07:00 1104 3089 2020-07-10T11:00:00Z 491600     49892 1077 27                         1 1334 20378 492216 posNeg 23846 492216 36 50 1cc6a77fd63150a8aa9fc31ac10e94e4f46e4786 0 0 0 0 0  
4371 4371 20200710 AR 26803 338609   364661 402 1743     84 260 20642 A 7/10/2020 14:46 2020-07-10T14:46:00Z 07/10 10:46 313 1743 2020-07-10T14:46:00Z 364661     26803                             5 751 0 365412 posNeg 0 365412 4 38 18d8b0f56adcdd957e15921022d10b21ab3ab62a 0 0 0 0 0  
4373 4373 20200710 AZ 116892 552319   668528 3432 5659 876   615   13853 A+ 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 2082 5659 2020-07-10T00:00:00Z       116209 1961 121   668528 191767                   4 4221 11929 669211 posNeg 16110 669211 44 133 c8867976b33e57384e5dbfa81cd74a28943b03b6 0 0 0 0 0  
4374 4374 20200710 CA 304297 4871440   5175737 7896   2005         B 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 6851   2020-07-10T00:00:00Z 5175737     304297                             6 7798 89505 5175737 posNeg 97303 5175737 140 0 6e00557d29fab8b55dabd2b0e519c80ba548e17f 0 0 0 0 0  
4375 4375 20200710 CO 35525 341615   460925 318 5831         4691 A 7/10/2020 01:59 2020-07-10T01:59:00Z 07/09 21:59 1581 5831 2020-07-10T01:59:00Z       32546     460925 374161 115504 7668 107836               8 409 6029 377140 totalTestEncountersViral 9332 377140 37 11 968038024ff979636effccdf0d1ab9d88b524011 0 0 0 0 0  
4380 4380 20200710 GA 111211 935137   1046348 2443 12937   2565       A 7/10/2020 14:50 2020-07-10T14:50:00Z 07/10 10:50 2965 12937 2020-07-10T14:50:00Z 1046348 101057 945291 111211         177244 9169                 13 4484 22442 1046348 posNeg 26926 1046348 35 331 163e081c55e6e94c02a061fce63f5fc49493b413 0 0 0 0 0  
4383 4383 20200710 IA 33984 328264   362248 169   54   26   25891 A+ 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 743   2020-07-10T00:00:00Z       33984       362997       34982 2410 32537         19 744 6845 362248 posNeg 7589 362248 4 0 cae0c5646548ce4829fe2a98f6feade638912831 0 0 0 0 0  
4385 4385 20200710 IL 152899 1759976   1912875 1436   306   155     A 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 7345   2020-07-10T00:00:00Z 1911743     151767 7144 201                         17 1327 31670 1912875 posNeg 32997 1912875 16 0 6aacb6c3794103eea3f32e349dc3a5eaba75a006 0 0 0 0 0  
4387 4387 20200710 KS 18611 199168   217779   1304   405   160 905 A 7/10/2020 10:00 2020-07-10T10:00:00Z 07/10 06:00 284 1304 2020-07-10T10:00:00Z               217779                     20 993 8304 217779 posNeg 9297 217779 2 35 8aa6a7f128c5a2c17e568bb145061b0e835cadab 0 0 0 0 0  
4388 4388 20200710 KY 18670 414020   431910 409 2763 70 1012     5258 B 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 620 2763 2020-07-10T00:00:00Z 431910     17890 616 4     38638                   21 425 8252 432690 posNeg 8651 432690 8 16 4a027244edb9f8b49128e29ddbad282f19477882 0 0 0 0 0  
4389 4389 20200710 LA 74636 830612   905248 1117       122   46334 B 7/10/2020 13:00 2020-07-10T13:00:00Z 07/10 09:00 3380   2020-07-10T13:00:00Z       74636 3272 108   905248                     22 2642 22466 905248 posNeg 25108 905248 25 0 2be5386f3778dee9f17be1a53e02d4cc5529ec0b 0 0 0 0 0  
4390 4390 20200710 MA 111110 827506   1243451 632 11582 98   47   94347 A+ 7/10/2020 10:00 2020-07-10T10:00:00Z 07/10 06:00 8296 11582 2020-07-10T10:00:00Z 1243451 140318   105290 8081 215   932796       79073             25 213 12642 938616 totalTestsViral 18260 938616 28 23 2bf87857ac85435edeab1bb17a7793cd80bafe25 0 0 0 0 0  
4391 4391 20200710 MD 71910 549153   621063 385 11300 122       5157 A 7/10/2020 10:00 2020-07-10T10:00:00Z 07/10 06:00 3303 11300 2020-07-10T10:00:00Z 769011 84290   71910 3172 131   621063                     24 463 8019 621063 posNeg 8482 621063 15 79 7dacecf40c93dcc465d5d587707ecefa3f4302ec 0 0 0 0 0  
4393 4393 20200710 MI 75685 1171120   1246805 505   174   92   52841 A+ 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 6285   2020-07-10T00:00:00Z 1265344 94224 1171120 68295 6039 246     179789                   26 622 22630 1246805 posNeg 23252 1246805 14 0 505f77331a8284a343020c287d0d9511200b3cb2 0 0 0 0 0  
4395 4395 20200710 MO 25999 428826   454825 886       79     B 7/10/2020 15:00 2020-07-10T15:00:00Z 07/10 11:00 1051   2020-07-10T15:00:00Z 576537 31075 544522 25999       454825       48179 1670 46509         29 0 0 454825 posNeg 0 454825 0 0 87cf7eefd813b1ef45548898607c988bcf76d4c8 0 0 0 0 0  
4398 4398 20200710 MT 1593 110585   112178 21 123         855 C 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 28 123 2020-07-10T00:00:00Z 112178     1593                             30 127 3286 112178 posNeg 3413 112178 3 3 09663ed5d5ad98d0c547a67a1b809159073ec7a0 0 0 0 0 0  
4399 4399 20200710 NC 81331 1069281   1150612 1046           55318 A 7/10/2020 12:00 2020-07-10T12:00:00Z 07/10 08:00 1479   2020-07-10T12:00:00Z 1150612     81331 1479                           37 1982 26819 1150612 posNeg 28801 1150612 18 0 e560aa6e81de69008d472004dbf1d86d39b2cb38 0 0 0 0 0  
4400 4400 20200710 ND 4152 115442   214889 33 260         3496 D 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 78 260 2020-07-10T00:00:00Z 219708     4152 74 4 214889 117060 5586 201 5385               38 84 1663 119594 totalTestEncountersViral 5338 119594 0 3 b12a1508e60cbbe71c191e064c5ee53b003b86a9 0 0 0 0 0  
4403 4403 20200710 NJ 174628 1448530   1623158 904 20567 162   94   31014 A+ 7/10/2020 13:00 2020-07-10T13:00:00Z 07/10 09:00 15308 20567 2020-07-10T13:00:00Z 1623158     174628 13532 1776                         34 388 23353 1623158 posNeg 23741 1623158 31 62 bcb36ff9e83434dbd3bc8d323ed09bf64d98ebee 0 0 0 0 0  
4405 4405 20200710 NV 25908 309583   335491 924   248   111   764 A+ 7/10/2020 12:00 2020-07-10T12:00:00Z 07/10 08:00 579   2020-07-10T12:00:00Z 416707     25908       334447                     32 1004 4709 335491 posNeg 5713 335491 8 0 4f882af5e05afc72219c54403025f3420ddae898 0 0 0 0 0  
4407 4407 20200710 OH 62856 896697   959553 928 8701 289 2161 151   43435 B 7/10/2020 14:00 2020-07-10T14:00:00Z 07/10 10:00 3032 8701 2020-07-10T14:00:00Z 955697     59000 2776 256                         39 1525 41626 959553 posNeg 43151 959553 26 131 24a69b80f3ae829104a61b11d3becf5b81fda6a7 0 0 0 0 0  
4408 4408 20200710 OK 19092 391982   411074 487 1949 217       14648 A+ 7/10/2020 08:00 2020-07-10T08:00:00Z 07/10 04:00 416 1949 2020-07-10T08:00:00Z 414197 21345 391982 19092         45013 1465                 40 596 8724 411074 posNeg 9320 411074 6 56 83196059d57d3ece4bac76a09538ae5f8949ff35 0 0 0 0 0  
4409 4409 20200710 OR 11454 275316   286770 208 1180 56   30   3009 A+ 7/10/2020 03:01 2020-07-10T03:01:00Z 07/09 23:01 232 1180 2020-07-10T03:01:00Z     275316 10881       286197                     41 266 4429 286770 posNeg 4695 286770 2 18 ad1124d7b2e3df5f66f32d72ff72e802b2371c73 0 0 0 0 0  
4410 4410 20200710 PA 93876 804764   898640 653       103   72284 A+ 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 6880   2020-07-10T00:00:00Z       91206       895970                     42 1009 17608 898640 posNeg 18617 898640 32 0 1eb1c64ba4860b673b83f9694fe3260ba665003c 0 0 0 0 0  
4412 4412 20200710 RI 17312 149343   285282 61 2051 4   5   1685 A+ 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 976 2051 2020-07-10T00:00:00Z 278357 24885 253472 17312     285282 166655                     44 69 1449 166655 totalTestEncountersViral 3747 166655 2 8 fee53718f10f1395128af0ff1cbd158b377add41 0 0 0 0 0  
4415 4415 20200710 TN 59546 935029   994575 1184 3146         34740 A 7/10/2020 15:00 2020-07-10T15:00:00Z 07/10 11:00 723 3146 2020-07-10T15:00:00Z 994114 69283 924831 59085 697 26                         47 1955 19906 994575 posNeg 21861 994575 13 58 22d2b3dd74c7fd8bdab86e28c338067927856f41 0 0 0 0 0  
4416 4416 20200710 TX 240111 2149678   2389789 10002           122996 B 7/10/2020 16:50 2020-07-10T16:50:00Z 07/10 12:50 3013   2020-07-10T16:50:00Z 2389789     240111         214114 7480                 48 9765 66812 2389789 posNeg 76577 2389789 95 0 207ccff8781e84ebf50711e3e570a857b873387c 0 0 0 0 0  
4417 4417 20200710 UT 28223 367751   395974 229 1748 79 477   205 16261 A+ 7/10/2020 10:27 2020-07-10T10:27:00Z 07/10 06:27 207 1748 2020-07-10T10:27:00Z       28223       395974             428 150 500 158 49 867 6374 395974 posNeg 7241 395974 2 48 beb6305fc13981f010e7e8fee861fb5cfa14051f 0 0 0 0 0  
4420 4420 20200710 VT 1277 72821   74098 11           1066 B 7/10/2020 00:00 2020-07-10T00:00:00Z 07/09 20:00 56   2020-07-10T00:00:00Z       1277 56     74098                     50 5 1344 74098 posNeg 1349 74098 0 0 c11518582dcb385ff77a4ab117769d580acc4c4c 0 0 0 0 0  
4422 4422 20200710 WI 38099 635411 151 673510 278 3766 77 792     27329 A+ 7/10/2020 16:00 2020-07-10T16:00:00Z 07/10 12:00 821 3766 2020-07-10T16:00:00Z       34753 814 7   670164                     55 889 11857 673661 posNeg 12746 673510 5 40 76d4e7ba75eb5eaf96ebc07b89433c0cb853468e 0 0 0 0 0  
4423 4423 20200710 WV 3983 197220   201203 56   16   7   2756 B 7/10/2020 17:00 2020-07-10T17:00:00Z 07/10 13:00 95   2020-07-10T17:00:00Z 201092     3872         11695                   54 157 3857 201203 posNeg 4014 201203 0 0 f84d2f16d620cc5031f888811ce5baba45ac6997 0 0 0 0 0  
4424 4424 20200710 WY 1790 38077   39867 12 121         1327 B 7/10/2020 13:50 2020-07-10T13:50:00Z 07/10 09:50 21 121 2020-07-10T13:50:00Z 54917 1592 53324 1445       39552                     56 16 806 39867 posNeg 822 39867 0 0 4abeba664f49e076280c61be1f6b9184f229487b 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
);