states_daily_4pm_et

Table actions

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

70 rows where "dateChecked" is on date 2020-04-19

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-04-19 · 70 ✖
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
8348 8348 20200430 AS 0 3 17 3               F 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 0   2020-04-19T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 c1a6f2573d586d2f3df990eeb447fa0d07b5af9a 0 0 0 0 0  
8404 8404 20200429 AS 0 3 17 3               F 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 0   2020-04-19T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 f9a5ef42aad60ea58048469affccfb21a0262fab 0 0 0 0 0  
8460 8460 20200428 AS 0 3 17 3               F 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 0   2020-04-19T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 2b6a7a6ded23ac7189ccf983ce335e5b5dd3fa34 0 0 0 0 0  
8516 8516 20200427 AS 0 3 17 3               F 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 0   2020-04-19T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 5c3294ac17a9c944bbbd0e606dccfe5d6974ab79 0 0 0 0 0  
8572 8572 20200426 AS 0 3 17 3               F 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 0   2020-04-19T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 ab3f599f5e6ae04418fa318ab0b07e7a0e35f1f9 0 0 0 0 0  
8628 8628 20200425 AS 0 3 17 3               F 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 0   2020-04-19T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 0567a4c733d322eb79264f00446f0bd37d4619a8 0 0 0 0 0  
8684 8684 20200424 AS 0 3 17 3                 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00     2020-04-19T00:00:00Z 3     0                             60 0 0 20 posNeg 0 3 0 0 658893a7d3d87219411073fcaccfe66d7d51cb62 0 0 0 0 0  
8910 8910 20200420 CA 30978 259522   290500 4674   1480         B 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 1208   2020-04-19T00:00:00Z 290500                                   6 645 8955 290500 posNeg 9600 290500 42 0 2c5e388cfe93451ae84d71d05ed96bd3e7771255 0 0 0 0 0  
8913 8913 20200420 DC 2927 11186   14113 402   120   69   630 A 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 105   2020-04-19T00:00:00Z             14113                       11 134 280 14113 posNeg 414 14113 9 0 0a3c51edd8707186790404a258b6a08f6fe84824 0 0 0 0 0  
8918 8918 20200420 HI 580 23595   24175   52         414 A 4/19/2020 18:00 2020-04-19T18:00:00Z 04/19 14:00 10 52 2020-04-19T18:00:00Z                                     15 6 699 24175 posNeg 705 24175 1 1 07e3c31c25c6aaf87ece82fa287f9f1d39804111 0 0 0 0 0  
8919 8919 20200420 IA 3159 22661   25820 214   91   58   1235 A 4/19/2020 12:00 2020-04-19T12:00:00Z 04/19 08:00 79   2020-04-19T12:00:00Z       3159                             19 257 1013 25820 posNeg 1270 25820 4 0 cfae49febf3e2bd4fe6c5b8cacd8fcf89d35225a 0 0 0 0 0  
8920 8920 20200420 ID 1672 15773   17445 53 151   53     585 A 4/19/2020 19:00 2020-04-19T19:00:00Z 04/19 15:00 45 151 2020-04-19T19:00:00Z 17445                                   16 4 0 17445 posNeg 4 17445 1 0 aaa32cfb146bdf1edbf3e296567571ed6d3a76b0 0 0 0 0 0  
8922 8922 20200420 IN 11686 52953   64639     669   353     B 4/19/2020 23:59 2020-04-19T23:59:00Z 04/19 19:59 569   2020-04-19T23:59:00Z                                     18 476 3021 64639 posNeg 3497 64639 7 0 2b43a5cd0a66279fcf0b3b1e1702e1e757cb8437 0 0 0 0 0  
8924 8924 20200420 KY 2960 29612   32572 274 1059 155 534     1174 A 4/19/2020 17:00 2020-04-19T17:00:00Z 04/19 13:00 148 1059 2020-04-19T17:00:00Z 32572                                   21 253 94 32572 posNeg 347 32572 4 0 3add042e588c1c4d9e1b5216eb8f82440e7ed08a 0 0 0 0 0  
8926 8926 20200420 MA 41416 136046   220251 3872 3872 987         B 4/19/2020 16:00 2020-04-19T16:00:00Z 04/19 12:00 2303 3872 2020-04-19T16:00:00Z 220251 51550                                 25 1596 6751 177462 totalTestsViral 12963 177462 157 83 136775c5d3e677e431c2e6b185bb90c396998c4b 0 0 0 0 0  
8933 8933 20200420 MS 4512 46922   51434 548 819 146   89     A 4/19/2020 19:00 2020-04-19T19:00:00Z 04/19 15:00 169 819 2020-04-19T19:00:00Z                                     28 238 12131 51434 posNeg 12369 51434 10 11 ad237861fa95f0ae697cb1d28245753042fb5ced 0 0 0 0 0  
8937 8937 20200420 NE 1474 14206   15680               A 4/19/2020 19:45 2020-04-19T19:45:00Z 04/19 15:45 28   2020-04-19T19:45:00Z               15756                     31 187 918 15680 posNeg 1105 15680 0 0 774fd0bbb3315869c6549bfa7cebb7af8a6ced58 0 0 0 0 0  
8938 8938 20200420 NH 1392 12726 298 15354 79 198         521 B 4/19/2020 09:00 2020-04-19T09:00:00Z 04/19 05:00 41 198 2020-04-19T09:00:00Z 15354                                   33 50 644 14416 posNeg 653 14118 3 6 0ae9ffc1b936c8bbc2f3681b868f2bce83aa08ee 0 0 0 0 0  
8940 8940 20200420 NM 1845 35197   37042 103 274         487 A 4/19/2020 18:46 2020-04-19T18:46:00Z 04/19 14:46 55 274 2020-04-19T18:46:00Z                                     35 47 363 37042 posNeg 410 37042 2 16 c7bbc845b929d4baa6ea486c3cff83e623ffa1c1 0 0 0 0 0  
8949 8949 20200420 SC 4377 36103   40480   776         2063 B 4/19/2020 15:30 2020-04-19T15:30:00Z 04/19 11:30 120 776 2020-04-19T15:30:00Z       4377                             45 0 0 40480 posNeg 0 40480 0 0 ab30e06ef7673b6875e55f08020429fd9a985608 0 0 0 0 0  
8950 8950 20200420 SD 1685 10641 0 12326   87         709 A 4/19/2020 18:00 2020-04-19T18:00:00Z 04/19 14:00 7 87 2020-04-19T18:00:00Z               12326                     46 50 214 12326 posNeg 264 12326 0 13 494885f226f3b50372a3f796c21d7b831b0f3736 0 0 0 0 0  
8955 8955 20200420 VI 53 554 18 607             48   4/19/2020 20:30 2020-04-19T20:30:00Z 04/19 16:30 3   2020-04-19T20:30:00Z                                     78 0 6 625 posNeg 6 607 0 0 355bb9fc91c1e70863c4bece1f4d3068bfa8d276 0 0 0 0 0  
8960 8960 20200420 WY 313 7073   7386 19 51         233 A 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 2 51 2020-04-19T00:00:00Z       313                             56 4 101 7386 posNeg 105 7386 0 1 ec7a55bbc2552b4bc293dd87f71475985262927c 0 0 0 0 0  
8962 8962 20200419 AL 4837 40875   45712 360 641   260   157   B 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 154 641 2020-04-19T00:00:00Z 45712     4837                             1 182 2992 45712 posNeg 3174 45712 8 21 8f22f1dca82d968f25138a352ae33a9053720007 0 0 0 0 0  
8963 8963 20200419 AR 1781 22428   24209 88 291     25 57 721 A 4/19/2020 18:47 2020-04-19T18:47:00Z 04/19 14:47 40 291 2020-04-19T18:47:00Z 24209     1781                             5 42 26 24209 posNeg 68 24209 2 0 cf34383bbb20d454d380d29d402c82baca0323e2 0 0 0 0 0  
8965 8965 20200419 AZ 4929 48061   52990 631 1387 283   187   994 B 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 184 1387 2020-04-19T00:00:00Z               52990                     4 210 1735 52990 posNeg 1945 52990 7 46 73ebf1373faf4c93b33ec49bace7adb8b54ac779 0 0 0 0 0  
8968 8968 20200419 CT 17550 40663   58213 1938             A 4/19/2020 17:00 2020-04-19T17:00:00Z 04/19 13:00 1086   2020-04-19T17:00:00Z 59759       671                           9 741 2010 58213 posNeg 2751 58213 50 0 a95bcf6504c6f97d409a1d8323aae7c75c7d3e3d 0 0 0 0 0  
8971 8971 20200419 FL 25996 230083 1179 256079   3930           A 4/19/2020 16:12 2020-04-19T16:12:00Z 04/19 12:12 781 3930 2020-04-19T16:12:00Z                                     12 727 8825 257258 posNeg 9552 256079 27 88 abd36f3b199b775b4e69b8eec704b021c07527eb 0 0 0 0 0  
8972 8972 20200419 GA 18301 61632   79933   3464           A 4/19/2020 21:34 2020-04-19T21:34:00Z 04/19 17:34 687 3464 2020-04-19T21:34:00Z 79933                                   13 632 5093 79933 posNeg 5725 79933 14 44 068aab9c2685732c84aff2c09f3e36898407b12b 0 0 0 0 0  
8973 8973 20200419 GU 133 943   1076 6   2       112   4/19/2020 05:00 2020-04-19T05:00:00Z 04/19 01:00 5   2020-04-19T05:00:00Z       133                             66 0 0 1076 posNeg 0 1076 0 0 58b79f8eda272899805deee0340d95e46d972268 0 0 0 0 0  
8974 8974 20200419 HI 574 22896   23470   51         410 A 4/19/2020 18:00 2020-04-19T18:00:00Z 04/19 14:00 9 51 2020-04-19T18:00:00Z                                     15 21 1106 23470 posNeg 1127 23470 0 3 98983f2e956366b81c6dab69e8d6136714a2109a 0 0 0 0 0  
8976 8976 20200419 ID 1668 15773   17441 43 151   53     520 A 4/19/2020 19:00 2020-04-19T19:00:00Z 04/19 15:00 44 151 2020-04-19T19:00:00Z 17441                                   16 13 481 17441 posNeg 494 17441 1 0 2af053829727ccfedd6c61c8a900efdb5cb1e843 0 0 0 0 0  
8977 8977 20200419 IL 30357 112961   143318 4314   1196   749     A 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 1290   2020-04-19T00:00:00Z                                     17 1197 4717 143318 posNeg 5914 143318 31 0 f5e276e018ef28cae9f1f44a4a0ff38f9c06fc82 0 0 0 0 0  
8979 8979 20200419 KS 1849 16281   18130   390           B 4/19/2020 12:00 2020-04-19T12:00:00Z 04/19 08:00 92 390 2020-04-19T12:00:00Z                                     20 59 395 18130 posNeg 454 18130 6 7 f6a533c13c6aa4a7e988180e402ad8dc04044a54 0 0 0 0 0  
8980 8980 20200419 KY 2707 29518   32225 274 1059 155 534     1174 A 4/19/2020 17:00 2020-04-19T17:00:00Z 04/19 13:00 144 1059 2020-04-19T17:00:00Z 32225                                   21 185 1444 32225 posNeg 1629 32225 7 51 24a9dc5a7987e0e9f8ac72fe3b72830bfd2e67b9 0 0 0 0 0  
8981 8981 20200419 LA 23928 111420   135348 1748       349     A 4/19/2020 13:00 2020-04-19T13:00:00Z 04/19 09:00 1296   2020-04-19T13:00:00Z       23928                             22 348 -2999 135348 posNeg -2651 135348 29 0 646f35fc8741b0f22b014a34a5a6b9155fe59690 0 0 0 0 0  
8982 8982 20200419 MA 39820 129295   207288 3789 3789 987         B 4/19/2020 16:00 2020-04-19T16:00:00Z 04/19 12:00 2146 3789 2020-04-19T16:00:00Z 207288 48441                                 25 2293 4691 169115 totalTestsViral 5596 169115 163 61 7b5d697282eff6449d622e3bcdb41d164a6a8270 0 0 0 0 0  
8983 8983 20200419 MD 12830 55061   67891   2886         914 A 4/19/2020 10:00 2020-04-19T10:00:00Z 04/19 06:00 626 2886 2020-04-19T10:00:00Z 75989 15669   12830 592 34                         24 522 1999 67891 posNeg 2521 67891 44 129 a4da0950bb6e6ddd1923c952b760c9308b10c7d2 0 0 0 0 0  
8984 8984 20200419 ME 867 14076   14943 46 136 18   9   393 A 4/19/2020 11:15 2020-04-19T11:15:00Z 04/19 07:15 34 136 2020-04-19T11:15:00Z       867                             23 20 0 14943 posNeg 20 14943 2 0 3fe023000a2d6a63ba46e2835cb5231bbcfb8827 0 0 0 0 0  
8985 8985 20200419 MI 37557 89758   127315 3403   1344   1115   3237 B 4/19/2020 11:00 2020-04-19T11:00:00Z 04/19 07:00 3236   2020-04-19T11:00:00Z 130677 40919 89758 36293 3178 160                         26 528 2644 127315 posNeg 3172 127315 129 0 728a80747f8c71d0a8a0cb57094922ae203d67cf 0 0 0 0 0  
8986 8986 20200419 MN 2914 46288   49202 228 574 116 226     1026 A 4/19/2020 12:00 2020-04-19T12:00:00Z 04/19 08:00 134 574 2020-04-19T12:00:00Z       2914     49202                       27 126 1106 49202 posNeg 1232 49202 13 13 3f63abec83761b545e5c87f168bcad48978aa30b 0 0 0 0 0  
8987 8987 20200419 MO 5667 48242   53909 875             A 4/19/2020 15:00 2020-04-19T15:00:00Z 04/19 11:00 176   2020-04-19T15:00:00Z 56834 6457 50308 5667               11 2 9         29 150 0 53909 posNeg 150 53909 1 0 acf03091066cbdae2a6fa618eef817e21683cb2b 0 0 0 0 0  
8988 8988 20200419 MP 14 42 4 56             9   4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 2   2020-04-19T00:00:00Z                                     69 0 0 60 posNeg 0 56 0 0 59dcf2c4e86e01978c41e4beb9beb5689fcf7958 0 0 0 0 0  
8990 8990 20200419 MT 433 10465   10898 18 55         243 A 4/19/2020 11:40 2020-04-19T11:40:00Z 04/19 07:40 10 55 2020-04-19T11:40:00Z 10898                                   30 7 322 10898 posNeg 329 10898 0 0 c41f28d6a4ce2a37e40744f2f07a7d4a88e72bc3 0 0 0 0 0  
8991 8991 20200419 NC 6493 72279   78772 465             A 4/19/2020 11:00 2020-04-19T11:00:00Z 04/19 07:00 172   2020-04-19T11:00:00Z                                     37 353 2208 78772 posNeg 2561 78772 8 0 1d68b2a7f2ad2b78db5955b972ed8ade9ac5199d 0 0 0 0 0  
8992 8992 20200419 ND 584 13045   14257 15 51         189 B 4/19/2020 13:00 2020-04-19T13:00:00Z 04/19 09:00 10 51 2020-04-19T13:00:00Z 14458     584     14257 13277                     38 56 610 13629 totalTestEncountersViral 932 13629 1 4 7dcab45ab2036f14b13a31d8df5e0d4381d5b8a9 0 0 0 0 0  
8993 8993 20200419 NE 1287 13288   14575               A 4/19/2020 19:45 2020-04-19T19:45:00Z 04/19 15:45 28   2020-04-19T19:45:00Z               14652                     31 149 749 14575 posNeg 898 14575 4 0 d67ba0ef6bfcb677ccd2818b00464ea396114d13 0 0 0 0 0  
8994 8994 20200419 NH 1342 12082 316 14701 85 192         513 B 4/19/2020 09:00 2020-04-19T09:00:00Z 04/19 05:00 38 192 2020-04-19T09:00:00Z 14701                                   33 55 517 13740 posNeg 601 13424 1 2 f6f420893052123c7452ab412ef7d6fb84b055db 0 0 0 0 0  
8995 8995 20200419 NJ 85301 85387   170688 7494   1940   1628     A 4/19/2020 13:00 2020-04-19T13:00:00Z 04/19 09:00 5313   2020-04-19T13:00:00Z       85301 4202 1111   170688                     34 3881 4271 170688 posNeg 8152 170688 171 0 fb6935f130ab034cb443a963ebc8012c4ad8ad07 0 0 0 0 0  
8996 8996 20200419 NM 1798 34834   36632 92 258         465 A 4/19/2020 19:46 2020-04-19T19:46:00Z 04/19 15:46 53 258 2020-04-19T19:46:00Z                                     35 87 932 36632 posNeg 1019 36632 2 16 305991033c8a948c10367141e6002ddfde074de9 0 0 0 0 0  
8997 8997 20200419 NV 3728 27870   31598               A 4/19/2020 11:00 2020-04-19T11:00:00Z 04/19 07:00 172   2020-04-19T11:00:00Z 38668     3728                             32 102 745 31598 posNeg 847 31598 4 0 0df3d60641e71638fe3d3e27078630965d6219d8 0 0 0 0 0  
8998 8998 20200419 NY 242786 374769   617555 16213 64550 4878       37596 A 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 13869 64550 2020-04-19T00:00:00Z                                     36 6054 14969 617555 posNeg 21023 617555 507 1447 cbbe74a92cf809bb2ce41fe8f96275a33462a840 0 0 0 0 0  
8999 8999 20200419 OH 11602 75697   87299   2565   765       B 4/19/2020 14:00 2020-04-19T14:00:00Z 04/19 10:00 471 2565 2020-04-19T14:00:00Z       11292 453 18                         39 1380 6878 87299 posNeg 8258 87299 20 46 e8893c23eca3a270151372346a16c8aad4b83b66 0 0 0 0 0  
9000 9000 20200419 OK 2599 32966   35565 307 541 136       1575 B 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 140 541 2020-04-19T00:00:00Z       2599                             40 29 0 35565 posNeg 29 35565 1 0 c9086ad8b3ecc97a788b1a9776d17aadf26b2647 0 0 0 0 0  
9001 9001 20200419 OR 1910 37128   39038 290 456 74   37     A 4/19/2020 11:00 2020-04-19T11:00:00Z 04/19 07:00 74 456 2020-04-19T11:00:00Z                                     41 66 1389 39038 posNeg 1455 39038 2 7 07fd6a364b8f86c377fcb6108c44958197ce292e 0 0 0 0 0  
9002 9002 20200419 PA 32284 126570   158854 2634       657     A 4/19/2020 13:00 2020-04-19T13:00:00Z 04/19 09:00 1112   2020-04-19T13:00:00Z               158854                     42 1215 3674 158854 posNeg 4889 158854 276 0 bdd0d17a52cacb6e7fdccc2fd1cd209dccc7ca12 0 0 0 0 0  
9003 9003 20200419 PR 1213 8280 1839 9493 160             A 4/19/2020 07:00 2020-04-19T07:00:00Z 04/19 03:00 62   2020-04-19T07:00:00Z                                     72 95 225 11332 posNeg 320 9493 2 0 03705cc04203bb49b111309b808c4d8500b97a8c 0 0 0 0 0  
9004 9004 20200419 RI 5207 29289   35950 298 605 66   37   244 B 4/19/2020 03:00 2020-04-19T03:00:00Z 04/18 23:00 164 605 2020-04-19T03:00:00Z 38488 5520 32968 5207     35950 34496                     44 339 1762 34496 totalTestEncountersViral 2046 34496 14 27 b1e6c57c6c3242f0d9816210d19343844b1b7a6a 0 0 0 0 0  
9005 9005 20200419 SC 4377 36103   40480   776         2633 B 4/19/2020 15:30 2020-04-19T15:30:00Z 04/19 11:30 120 776 2020-04-19T15:30:00Z       4377                             45 131 1516 40480 posNeg 1647 40480 1 0 0cc0bb0b0d08c11c4ee143b6a3e6165d0d05d8a7 0 0 0 0 0  
9006 9006 20200419 SD 1635 10427 0 12062   74         646 A 4/19/2020 12:30 2020-04-19T12:30:00Z 04/19 08:30 7 74 2020-04-19T12:30:00Z               12062                     46 93 309 12062 posNeg 402 12062 0 6 7bd7cc151539a0a7bc78fc4b81821c2fd9e27517 0 0 0 0 0  
9007 9007 20200419 TN 7070 90028   97098 393 724         3344 A 4/19/2020 15:00 2020-04-19T15:00:00Z 04/19 11:00 148 724 2020-04-19T15:00:00Z                                     47 308 6204 97098 posNeg 6512 97098 3 5 54148829668bc2a369127c73d8cbe6c617179d8d 0 0 0 0 0  
9008 9008 20200419 TX 18923 163787   182710 1471           5334 A 4/19/2020 13:00 2020-04-19T13:00:00Z 04/19 09:00 477   2020-04-19T13:00:00Z       18923                             48 663 5808 182710 posNeg 6471 182710 24 0 72bde9e1080880aea67ac17123ff6be218cde65b 0 0 0 0 0  
9009 9009 20200419 UT 3069 60486   63555   259         679 A 4/19/2020 15:00 2020-04-19T15:00:00Z 04/19 11:00 27 259 2020-04-19T15:00:00Z       3069                             49 138 3473 63555 posNeg 3611 63555 2 8 95470cd7f76f013d12049d5a9ecdaa2987419d95 0 0 0 0 0  
9010 9010 20200419 VA 8537 46196 499 70666 1319 1422 388   231   1267 A 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 277 1422 2020-04-19T00:00:00Z   12352         70666                       51 484 2318 55232 posNeg 2706 54733 19 126 55033dfeeb6a2c825b5b09b56992a42ad93361bc 0 0 0 0 0  
9011 9011 20200419 VI 53 548 22 601             48   4/19/2020 20:30 2020-04-19T20:30:00Z 04/19 16:30 3   2020-04-19T20:30:00Z                                     78 0 158 623 posNeg 158 601 0 0 e2d8cd024889ef228a904cb95210d5249763f878 0 0 0 0 0  
9012 9012 20200419 VT 817 11450   12267 53           15 A 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 38   2020-04-19T00:00:00Z       817                             50 4 238 12267 posNeg 242 12267 0 0 9fcd20ae1f9e4e4313dea666b205e0d9e556cfcd 0 0 0 0 0  
9013 9013 20200419 WA 12589 152470   165059 586   193         C 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 615   2020-04-19T00:00:00Z       12589     165059 157116                     53 96 1871 165059 posNeg 1967 165059 17 0 9abc7cebbec9f3d89755f6f16a76e5daffa60a6a 0 0 0 0 0  
9014 9014 20200419 WI 5176 45323 248 50499 357 1190 137 307       A 4/19/2020 12:57 2020-04-19T12:57:00Z 04/19 08:57 220 1190 2020-04-19T12:57:00Z       4346                             55 163 1361 50747 posNeg 1524 50499 9 14 5c1afcc1775dd09568f7fe9c35d193129a27dc6f 0 0 0 0 0  
9015 9015 20200419 WV 863 19168   20031 72   37   25   265 B 4/19/2020 17:00 2020-04-19T17:00:00Z 04/19 13:00 18   2020-04-19T17:00:00Z       863                             54 78 513 20031 posNeg 591 20031 2 0 e376597fd4935898ccd046efc5720a27632f3553 0 0 0 0 0  
9016 9016 20200419 WY 309 6972   7281 19 50         227 A 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 2 50 2020-04-19T00:00:00Z       309                             56 4 755 7281 posNeg 759 7281 0 0 cf048399c533e2b08e39cd14a3245d7f08be38fc 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
);