states_daily_4pm_et

Table actions

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

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

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

dateChecked (date) ✖

  • 2020-05-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
7455 7455 20200516 CO 21232 100608   135313 671 3842         3312 A 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 878 3842 2020-05-14T00:00:00Z       19151     135313 119759 30029 2538 27491               8 394 3416 121840 totalTestEncountersViral 4262 121840 -213 53 2dfee3c90be923002acd96c91f5820b92cd56830 0 0 0 0 0  
7499 7499 20200516 VI 69 1194 37 1263             61 C 5/14/2020 19:04 2020-05-14T19:04:00Z 05/14 15:04 6   2020-05-14T19:04:00Z 1300       6                           78 0 0 1300 posNeg 0 1263 0 0 2267023c0d4f87e56cb47ea04dc74752b4110195 0 0 0 0 0  
7505 7505 20200515 AK 388 32030   32418 8           343 B 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 10   2020-05-14T00:00:00Z 32418     388 10                           2 1 655 32418 posNeg 656 32418 0 0 8c2e9834e962d20d82c878e11b1becc0c5944246 0 0 0 0 0  
7510 7510 20200515 CA 74936 1058970   1133906 4519   1324         B 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 3108   2020-05-14T00:00:00Z 1133906     74936                             6 1772 27483 1133906 posNeg 29255 1133906 76 0 a6f1c4bf1b4b7abb30f65fe0e263827a4c2d2e56 0 0 0 0 0  
7512 7512 20200515 CT 36085 119823   155908 1033 10946         6264 B 5/14/2020 20:30 2020-05-14T20:30:00Z 05/14 16:30 3285 10946 2020-05-14T20:30:00Z 164755             155908                     9 621 5725 155908 posNeg 6346 155908 66 0 8021056a602056fa293d6571e5a223c4a11aba95 0 0 0 0 0  
7513 7513 20200515 DC 6871 27468   34339 393       90   975 A 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 368   2020-05-14T00:00:00Z             34339                       11 135 1205 34339 posNeg 2681 34339 10 0 9ac28b7cf950a04dd5a9136d7af16c1247374a97 0 0 0 0 0  
7514 7514 20200515 DE 7373 30905   38278 269           3210 B 5/14/2020 18:00 2020-05-14T18:00:00Z 05/14 14:00 373   2020-05-14T18:00:00Z         327 46   38278                     10 150 1271 38278 posNeg 1421 38278 11 0 7fc114ed9210a7e155b76775fdd0abdcb0560e62 0 0 0 0 0  
7515 7515 20200515 FL 43210 565627 1228 608837   7993           A+ 5/14/2020 12:33 2020-05-14T12:33:00Z 05/14 08:33 1991 7993 2020-05-14T12:33:00Z       43210 1991     609574                     12 0 0 610065 posNeg 0 608837 43 0 745389b066da4cdf8d48b65534b11cb78c358713 0 0 0 0 0  
7518 7518 20200515 HI 637 38139   38776   81         564 B 5/14/2020 18:00 2020-05-14T18:00:00Z 05/14 14:00 17 81 2020-05-14T18:00:00Z               39767                     15 -1 -104 38776 posNeg -105 38776 0 0 f6d3fba5d67d3df82afcf4cee396637a41d194ac 0 0 0 0 0  
7519 7519 20200515 IA 14049 79517   93566 387   130   87   6561 A+ 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 336   2020-05-14T00:00:00Z       14049       93566                     19 374 3898 93566 posNeg 4272 93566 18 0 b25fbd9867ead14da10e510c995a5e51448ecd27 0 0 0 0 0  
7520 7520 20200515 ID 2351 32394   34546 26 212   89     1573 B 5/14/2020 19:00 2020-05-14T19:00:00Z 05/14 15:00 72 212 2020-05-14T19:00:00Z 34546     2152                             16 27 964 34745 posNeg 990 34745 3 0 717edf60f44a5a1c46614331f65214664d65dc14 0 0 0 0 0  
7522 7522 20200515 IN 26655 138793   165448 1294 4389 492 990 213     A+ 5/14/2020 23:59 2020-05-14T23:59:00Z 05/14 19:59 1691 4389 2020-05-14T23:59:00Z         1550 138   165448                     18 602 4607 165448 posNeg 5209 165448 45 0 a5ab68638a0012043a57f6571af29ed73f3e6a7e 0 0 0 0 0  
7524 7524 20200515 KY 7225 114053   121246 385 1887 220 794     2712 A+ 5/14/2020 17:00 2020-05-14T17:00:00Z 05/14 13:00 328 1887 2020-05-14T17:00:00Z 121246     7193 328                           21 145 3738 121278 posNeg 10637 121278 2 52 5cbadce9caca1271bbcbc4eca2d23ee23df7751e 0 0 0 0 0  
7526 7526 20200515 MA 83421 352258   567173 2767 8314 749         A+ 5/14/2020 10:00 2020-05-14T10:00:00Z 05/14 06:00 5592 8314 2020-05-14T10:00:00Z 567173 106978   83421 5592     435679                     25 1239 10079 435679 totalTestsViral 17768 435679 110 107 96ccca90f1f424ef2a0a9e9161fad163ab7aeb58 0 0 0 0 0  
7529 7529 20200515 MI 57687 341827   399514 1256   532   440   22686 A+ 5/14/2020 11:00 2020-05-14T11:00:00Z 05/14 07:00 5325   2020-05-14T11:00:00Z 407180 65353 341827 53956 5124 233                         26 651 15170 399514 posNeg 15821 399514 47 0 f0dacc4f03492a27b7d67b534f48141af9a210a2 0 0 0 0 0  
7530 7530 20200515 MN 17363 139773   157136 498 1985 200 679     8820 A+ 5/14/2020 17:00 2020-05-14T17:00:00Z 05/14 13:00 692 1985 2020-05-14T17:00:00Z       17363 683 9 157136                       27 798 8330 157136 posNeg 9128 157136 29 70 95b15f87b842a995213bda70de322f81d2bb148a 0 0 0 0 0  
7533 7533 20200515 MS 10801 96022   106823 573 1712 172   81   6268 A 5/14/2020 19:00 2020-05-14T19:00:00Z 05/14 15:00 493 1712 2020-05-14T19:00:00Z 106823                                   28 318 1179 106823 posNeg 1497 106823 13 45 7d26bf2f80977a8f6cf21f2fde326a8052131e18 0 0 0 0 0  
7537 7537 20200515 NE 9416 47799   57215               C 5/14/2020 15:45 2020-05-14T15:45:00Z 05/14 11:45 113   2020-05-14T15:45:00Z       9416       57315                     31 341 3533 57215 posNeg 3874 57215 6 0 d78a552e018ede5d4ec40c970e9ab1665eb9ff7d 0 0 0 0 0  
7538 7538 20200515 NH 3464 39148 543 44206 115 335   109     1247 B 5/14/2020 09:00 2020-05-14T09:00:00Z 05/14 05:00 159 335 2020-05-14T09:00:00Z 44206     3158       42306 5870                   33 165 3272 43155 posNeg 1919 42612 9 9 cb3398c44388a8fa23e0dbda69737b3367ddafd8 0 0 0 0 0  
7540 7540 20200515 NM 5503 114098   119601 209 886         1576 C 5/14/2020 17:55 2020-05-14T17:55:00Z 05/14 13:55 242 886 2020-05-14T17:55:00Z 119601     5503                             35 139 4451 119601 posNeg 4590 119601 11 0 e10094de7f68cfb9d85a4db91f49555c89e5afaf 0 0 0 0 0  
7542 7542 20200515 NY 345813 992235   1338048 6394 85782 2156   1774   60302 A 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 22304 85782 2020-05-14T00:00:00Z       345813     1338048                       36 2762 36529 1338048 posNeg 39291 1338048 134 328 da8f270b2b38896ea3bc46a218e8ac3404580ff3 0 0 0 0 0  
7550 7550 20200515 SD 3887 23527   27414 80 296         2574 B 5/14/2020 18:00 2020-05-14T18:00:00Z 05/14 14:00 44 296 2020-05-14T18:00:00Z               27414                     46 95 846 27414 posNeg 941 27414 1 6 d54925c19031d293080698d6ead3be77a2d761af 0 0 0 0 0  
7554 7554 20200515 VA 28672 149342 458 209111 1511 5316 362   195   3805 A+ 5/14/2020 17:00 2020-05-14T17:00:00Z 05/14 13:00 977 5316 2020-05-14T17:00:00Z   35912   27293 944 33 209111                       51 859 10325 178472 posNeg 7952 178014 22 105 fd532b04773a852a8d0d5c133f0d2ead3a36fcdd 0 0 0 0 0  
7555 7555 20200515 VI 69 1194 37 1263             61 C 5/14/2020 19:04 2020-05-14T19:04:00Z 05/14 15:04 6   2020-05-14T19:04:00Z 1278       6                           78 0 30 1300 posNeg 30 1263 0 0 aa805ae0900904960e7710cff9c57a0d1e843c7a 0 0 0 0 0  
7560 7560 20200515 WY 715 15307   16022 8 68         487 B 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 7 68 2020-05-14T00:00:00Z 15848 607 14957 541                             56 14 578 16022 posNeg 592 16022 0 1 844a4c0d59f9a173a80d6bfc7b0d90a0c76d9a61 0 0 0 0 0  
7561 7561 20200514 AK 387 31375   31762 12           339 B 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 10   2020-05-14T00:00:00Z 31762     387 10                           2 4 1109 31762 posNeg 1113 31762 0 0 707e0f5d6806c7524d672690914635a99bdbf4c0 0 0 0 0 0  
7562 7562 20200514 AL 10968 131017   136372 509 1350   489   291   B 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 467 1350 2020-05-14T00:00:00Z 136372     10968 467                           1 351 5262 141985 posNeg 3154 141985 18 33 ca604f83540a44bd732cd25898ce35126cd2aed7 0 0 0 0 0  
7563 7563 20200514 AR 4236 71582   75818 64 509     13 100 3277 A 5/14/2020 08:20 2020-05-14T08:20:00Z 05/14 04:20 97 509 2020-05-14T08:20:00Z 75818     4236                             5 72 2531 75818 posNeg 2603 75818 2 12 944b8aefb36cca2b1027f7b871d23a26337402c7 0 0 0 0 0  
7565 7565 20200514 AZ 12674 121664   134338 781 2595 323   201   3074 A+ 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 624 2595 2020-05-14T00:00:00Z               134338 41117                   4 498 6090 134338 posNeg 6588 134338 30 52 e132f36fa8935aa77d6dff442c0b655fac56e44a 0 0 0 0 0  
7566 7566 20200514 CA 73164 1031487   1104651 4655   1324         B 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 3032   2020-05-14T00:00:00Z 1104651     73164                             6 2023 37036 1104651 posNeg 39059 1104651 98 0 4810ef2ccc7465e52ea90e229711128e5abb1658 0 0 0 0 0  
7571 7571 20200514 FL 43210 565627 1228 608837   7993           A+ 5/14/2020 12:33 2020-05-14T12:33:00Z 05/14 08:33 1948 7993 2020-05-14T12:33:00Z       43210 1948     595478                     12 808 13266 610065 posNeg 14074 608837 50 158 95f598d6c399f9e9f808392b223f3d3179d9a7ba 0 0 0 0 0  
7572 7572 20200514 GA 35858 250023   285881 1060 6345   1513       A+ 5/14/2020 13:30 2020-05-14T13:30:00Z 05/14 09:30 1527 6345 2020-05-14T13:30:00Z 285881     35858                             13 526 11451 285881 posNeg 11977 285881 22 86 3f854634753b9ac20de858a9952dccd2dac6b31a 0 0 0 0 0  
7573 7573 20200514 GU 153 4226   4379             124 C 5/14/2020 05:45 2020-05-14T05:45:00Z 05/14 01:45 5   2020-05-14T05:45:00Z       149       4258                     66 1 116 4379 posNeg 117 4379 0 0 22fcab771f547a5ab4dfe3bfdb32fa4a890d645d 0 0 0 0 0  
7577 7577 20200514 IL 87937 424100   512037 4473   1132   689     A 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 3928   2020-05-14T00:00:00Z       87937 3928     489359                     17 3239 19439 512037 posNeg 22678 512037 136 0 a3cc5149590a41101f9e5edd244e096dfad5827a 0 0 0 0 0  
7581 7581 20200514 LA 33489 214099   247588 1193       140   22608 B 5/14/2020 13:00 2020-05-14T13:00:00Z 05/14 09:00 2417   2020-05-14T13:00:00Z       33489 2351 66   237904                     22 827 8857 247588 posNeg 9684 247588 36 0 6f3c7553e26b211098a4ee01d21dbbefd9b8bf0b 0 0 0 0 0  
7583 7583 20200514 MD 35903 142551   178454 1538 6553 569       2569 B 5/14/2020 10:00 2020-05-14T10:00:00Z 05/14 06:00 1935 6553 2020-05-14T10:00:00Z 194595 41635   35903 1840 95   173574                     24 1091 3789 178454 posNeg 4880 178454 54 149 3b78326ea52e0e63a6faf55e67120b13b71f09a9 0 0 0 0 0  
7584 7584 20200514 ME 1565 22092   23657 37 207 18   7   958 B 5/14/2020 12:30 2020-05-14T12:30:00Z 05/14 08:30 69 207 2020-05-14T12:30:00Z 33035     1405 69     28357     587               23 50 0 23657 posNeg 50 23657 3 3 f3c518b02a57b53240c7351a583bed10b9b23ff8 0 0 0 0 0  
7585 7585 20200514 MI 57036 326657   383693 1330   653   515   22686 A+ 5/14/2020 11:00 2020-05-14T11:00:00Z 05/14 07:00 5278   2020-05-14T11:00:00Z 391176 64519 326657 53451 5092 232                         26 578 16415 383693 posNeg 16993 383693 46 0 8022a2b9b62ef0aa391ee02a77fc5e2f8d56ffb6 0 0 0 0 0  
7587 7587 20200514 MO 10317 116793   127110 796       115     B 5/14/2020 15:00 2020-05-14T15:00:00Z 05/14 11:00 562   2020-05-14T15:00:00Z 134975 12346 122388 10317       124006       7644 328 7307         29 175 2793 127110 posNeg 2968 127110 20 0 a2b865e74ad9ccb47de7072ef48c1ac8eb9f6b2e 0 0 0 0 0  
7588 7588 20200514 MP 19 3306   3325             12 D 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 2   2020-05-14T00:00:00Z 3325     19                             69 0 285 3325 posNeg 285 3325 0 0 9fbef1e480eb88a49e54b26b9d4a554f5de33232 0 0 0 0 0  
7590 7590 20200514 MT 462 24087   24549 3 63         431 B 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 16 63 2020-05-14T00:00:00Z 24549     462                             30 0 697 24549 posNeg 697 24549 0 0 210db5c4fb318c0576e8d92a4df5ed076f7a9a6a 0 0 0 0 0  
7591 7591 20200514 NC 16507 202761   219268 507           9115 A 5/14/2020 11:00 2020-05-14T11:00:00Z 05/14 07:00 615   2020-05-14T11:00:00Z 210457     16507 615                           37 691 8120 219268 posNeg 8811 219268 18 0 039ed77bbbecc5499878ce90040621209eb938f9 0 0 0 0 0  
7592 7592 20200514 ND 1709 48599   56410 38 129         1007 C 5/14/2020 13:00 2020-05-14T13:00:00Z 05/14 09:00 31 129 2020-05-14T13:00:00Z 57421     1709 31   56410 48533                     38 67 1301 50308 totalTestEncountersViral 2317 50308 2 2 220bf645bdfe60acdf085f5ddaeddcd5da0f676c 0 0 0 0 0  
7595 7595 20200514 NJ 142704 308992   451696 3958   1157   898   15642 A+ 5/14/2020 13:00 2020-05-14T13:00:00Z 05/14 09:00 11600   2020-05-14T13:00:00Z 451696     142704 9946 1654                         34 1144 9102 451696 posNeg 10246 451696 253 0 56a02504245b5a2d060f6e22fe9519d4c031ebeb 0 0 0 0 0  
7597 7597 20200514 NV 6499 62985   69484 515   126   75   244 B 5/14/2020 12:00 2020-05-14T12:00:00Z 05/14 08:00 358   2020-05-14T12:00:00Z 82993     6499       66672                     32 105 2707 69484 posNeg 2812 69484 3 0 eeb678f81b31624ec8d1349067b17af5f0152383 0 0 0 0 0  
7598 7598 20200514 NY 343051 955706   1298757 6706 85454 2223   1846   59758 A 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 22170 85454 2020-05-14T00:00:00Z       343051     1258907                       36 2390 37460 1298757 posNeg 39850 1298757 157 446 1d9ab9279f31fb29233bce7e03bbbedaee1eb899 0 0 0 0 0  
7599 7599 20200514 OH 26357 206995   233352 953 4718 360 1268 253     B 5/14/2020 14:00 2020-05-14T14:00:00Z 05/14 10:00 1534 4718 2020-05-14T14:00:00Z 224378     24800 1388 146                         39 636 6862 233352 posNeg 7498 233352 51 100 0b28911d61a5601e4233215e039ef7c02f694a54 0 0 0 0 0  
7600 7600 20200514 OK 4962 107221   112183 217 858 102       3660 A+ 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 284 858 2020-05-14T00:00:00Z 112647 5426 107221 4962                             40 110 2946 112183 posNeg 3056 112183 6 10 cf4a1b263792cea9f4b89119c2664b8f7bbc53b8 0 0 0 0 0  
7601 7601 20200514 OR 3479 80571   84050 163 685 38   17   1406 A+ 5/14/2020 11:00 2020-05-14T11:00:00Z 05/14 07:00 137 685 2020-05-14T11:00:00Z       3407       83909                     41 63 0 84050 posNeg 63 84050 3 7 aa4bcf2c33a5654e7d413f11bbea355bae8c1c78 0 0 0 0 0  
7602 7602 20200514 PA 59636 251559   311195 1983       446     C 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 4218   2020-05-14T00:00:00Z               311195                     42 938 7388 311195 posNeg 8326 311195 275 0 5c510600b5206d2228463dc8ce94ac222dd8726f 0 0 0 0 0  
7603 7603 20200514 PR 2427     2427 159   18   5     B 5/14/2020 06:30 2020-05-14T06:30:00Z 05/14 02:30 117   2020-05-14T06:30:00Z       1073 58         1354                 72 98 0 2427 posNeg 98 2427 2 0 a1ec436b42655b00f20f2f367d45851c5886879d 0 0 0 0 0  
7604 7604 20200514 RI 12431 74767   108466 271 1351 65   42   903 A+ 5/14/2020 03:00 2020-05-14T03:00:00Z 05/13 23:00 468 1351 2020-05-14T03:00:00Z 111593 15089 96504 12431     108466 87198                     44 228 1927 87198 totalTestEncountersViral 3981 87198 6 23 53944a80f38a5aab5e01ed70f28bc35ae63fd5f8 0 0 0 0 0  
7605 7605 20200514 SC 8189 94346   102535   1338         4914 A 5/14/2020 15:34 2020-05-14T15:34:00Z 05/14 11:34 371 1338 2020-05-14T15:34:00Z       8189 371     93140                     45 262 9133 102535 posNeg 9395 102535 16 0 ab645142528f0a5499dce5c340e96879645094d4 0 0 0 0 0  
7607 7607 20200514 TN 16699 285618   302317 599 1435         8881 A 5/14/2020 15:00 2020-05-14T15:00:00Z 05/14 11:00 287 1435 2020-05-14T15:00:00Z       16699 287     292917                     47 329 9071 302317 posNeg 9400 302317 14 47 000b6a3c99d89e42ff3e591e8750a8d641be9f8a 0 0 0 0 0  
7608 7608 20200514 TX 43851 543462   587313 1648           24487 A 5/14/2020 16:30 2020-05-14T16:30:00Z 05/14 12:30 1216   2020-05-14T16:30:00Z 587313     43851         35971                   48 1448 29089 587313 posNeg 30537 587313 58 0 bb3cf947985c9c338bee354cadb38ce54c2765a5 0 0 0 0 0  
7609 7609 20200514 UT 6749 153370   160119 142 558   187   83 3566 B 5/14/2020 10:07 2020-05-14T10:07:00Z 05/14 06:07 75 558 2020-05-14T10:07:00Z       6749       156786                     49 129 3204 160119 posNeg 3333 160119 0 5 a34844970261a3f12aa1afe8f65004ddf35de46d 0 0 0 0 0  
7612 7612 20200514 VT 931 20497   21428 18           792 B 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 53   2020-05-14T00:00:00Z       932 53     21676                     50 1 789 21428 posNeg 790 21428 0 0 1b677a4186916a41756cea0856d628aad31bd55b 0 0 0 0 0  
7613 7613 20200514 WA 18898 270519   289417 365   111         A 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 975   2020-05-14T00:00:00Z       18898 975   289417 262293                     53 271 6102 289417 posNeg 6373 289417 13 0 dda9199eca6f7370b053590ab87698b3bd4cc274 0 0 0 0 0  
7614 7614 20200514 WI 12869 122598 169 135467 352 1939 120 478     5994 A+ 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 434 1939 2020-05-14T00:00:00Z       11275 434     128013                     55 420 5487 135636 posNeg 5907 135467 13 31 b0067ae2f72bb7ed552875f50fe46c91e7099ce3 0 0 0 0 0  
7615 7615 20200514 WV 1427 67286   68713 52   9   5   870 B 5/14/2020 10:00 2020-05-14T10:00:00Z 05/14 06:00 60   2020-05-14T10:00:00Z 66680     1427                             54 29 2004 68713 posNeg 2033 68713 2 0 fa63240093a45deea387fa0241a1f1a554dbcf77 0 0 0 0 0  
7616 7616 20200514 WY 701 14729   15430 8 67         480 B 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 7 67 2020-05-14T00:00:00Z 15417     529                             56 26 345 15430 posNeg 371 15430 0 0 7526bb515b4611741179e663137914692b21e880 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
);