states_daily_4pm_et

Table actions
Data provided by Big Local News and snapshotted daily from the COVID19 Tracker, https://covidtracking.com/.

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, probableCases, pending, totalTestResultsSource, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, lastUpdateEt, dateModified, checkTimeEt, dateChecked, positiveCasesViral, deathIncrease, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-04-19 · 70 ✖
Link rowid ▼ date state positive probableCases negative pending totalTestResultsSource totalTestResults hospitalizedCurrently hospitalizedCumulative inIcuCurrently inIcuCumulative onVentilatorCurrently onVentilatorCumulative recovered lastUpdateEt dateModified checkTimeEt death hospitalized hospitalizedDischarged dateChecked totalTestsViral positiveTestsViral negativeTestsViral positiveCasesViral deathConfirmed deathProbable totalTestEncountersViral totalTestsPeopleViral totalTestsAntibody positiveTestsAntibody negativeTestsAntibody totalTestsPeopleAntibody positiveTestsPeopleAntibody negativeTestsPeopleAntibody totalTestsPeopleAntigen positiveTestsPeopleAntigen totalTestsAntigen positiveTestsAntigen fips positiveIncrease negativeIncrease total totalTestResultsIncrease posNeg dataQualityGrade deathIncrease hospitalizedIncrease hash commercialScore negativeRegularScore negativeScore positiveScore score grade
17084 17084 20200430 AS 0   3 17 totalTestsViral 3               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 0 3   0.0 0.0 4a97f0ce011ab533037e1655cc48201fb8456f32 0 0 0 0 0  
17140 17140 20200429 AS 0   3 17 totalTestsViral 3               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 0 3   0.0 0.0 eff6fc0ba332ebced86c5f777894d28f13cd13c2 0 0 0 0 0  
17196 17196 20200428 AS 0   3 17 totalTestsViral 3               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 0 3   0.0 0.0 a5c34e19a748184e75a094342c03308e23489822 0 0 0 0 0  
17252 17252 20200427 AS 0   3 17 totalTestsViral 3               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 0 3   0.0 0.0 759d80f33dffd92272221e19b6668024f5d74b99 0 0 0 0 0  
17308 17308 20200426 AS 0   3 17 totalTestsViral 3               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 0 3   0.0 0.0 16c33f530cb6fee8a0569ae246f91f318c17fbd6 0 0 0 0 0  
17364 17364 20200425 AS 0   3 17 totalTestsViral 3               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 0 3   0.0 0.0 844ac67426b666d27fc436856840c2f83fb63c8a 0 0 0 0 0  
17420 17420 20200424 AS 0   3 17 totalTestsViral 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 0 3   0.0 0.0 fd5544c528465c614e10602961e994b1378038e1 0 0 0 0 0  
17646 17646 20200420 CA 30978   259522   totalTestsViral 290500 4674   1480         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 9600 290500   42.0 0.0 758c3c638fae088c9289a3d037c9045c05852008 0 0 0 0 0  
17649 17649 20200420 DC 2927       totalTestEncountersViral 14113 402   120   69   630 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 105     2020-04-19T00:00:00Z             14113                       11 134 0 2927 414 2927   9.0 0.0 65ea1d5b7ab7379bb9a8cf74372164a5289f9c8e 0 0 0 0 0  
17654 17654 20200420 HI 580   23595   totalTestEncountersViral 25009   52         414 4/19/2020 18:00 2020-04-19T18:00:00Z 04/19 14:00 10 52   2020-04-19T18:00:00Z   523     10   25009                       15 6 699 24175 913 24175   1.0 1.0 c0c6a5e93d75b8bafc3fd9b0ace5a1ff70663614 0 0 0 0 0  
17655 17655 20200420 IA 3159   22661   posNeg 25820 214   91   58   1235 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 1270 25820   4.0 0.0 da052e959ec0d52e102fce126d29b0e61aa8356b 0 0 0 0 0  
17656 17656 20200420 ID 1672   15773   totalTestsPeopleViral 17445 53 151   53     585 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 4 17445   1.0 0.0 257250ce29a7f0b6c7d742a8ff95afc74cee1d15 0 0 0 0 0  
17658 17658 20200420 IN 11686   52953   totalTestsViral 80838     669   353     4/19/2020 23:59 2020-04-19T23:59:00Z 04/19 19:59 569     2020-04-19T23:59:00Z 80838 11648                                 18 476 3021 64639 1338 64639   7.0 0.0 5d5a1a1125b3a619a3eaafc1ce133bedf92c1259 0 0 0 0 0  
17660 17660 20200420 KY 2960       totalTestsViral 32572 274 1059 155 534     1174 4/19/2020 17:00 2020-04-19T17:00:00Z 04/19 13:00 148 1059   2020-04-19T17:00:00Z 32572                                   21 253 0 2960 347 2960   4.0 0.0 996df4d69e097d32db7a5dcb7cd7996a404a7910 0 0 0 0 0  
17662 17662 20200420 MA 41416   136046   totalTestsViral 220251 3872 3872 987         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 12963 177462   157.0 83.0 072a1932b62e5591fa09ec56181905a375e881c1 0 0 0 0 0  
17669 17669 20200420 MS 4512   46922   posNeg 51434 548 819 146   89     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 12369 51434   10.0 11.0 28314ea4e09df7596e5dac730107b8b49d4f1d06 0 0 0 0 0  
17673 17673 20200420 NE 1474   14206   totalTestsViral 17191               4/19/2020 19:45 2020-04-19T19:45:00Z 04/19 15:45 28     2020-04-19T19:45:00Z 17191 1583 15483         15756                     31 187 918 15680 1125 15680   0.0 0.0 0d4946980dc9a376d95319ebf7d4b4df762d7c6e 0 0 0 0 0  
17674 17674 20200420 NH 1392   12726 298 totalTestsViral 15354 79 198         521 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 653 14118   3.0 6.0 7da12ee6f902f04da5106c04de5f21602ee77280 0 0 0 0 0  
17681 17681 20200420 OR 1910   37128   totalTestsViral 42029 290 456 74   37     4/19/2020 11:00 2020-04-19T11:00:00Z 04/19 07:00 74 456   2020-04-19T11:00:00Z 42029 5326 36703                               41 66 1389 39038 2388 39038   2.0 7.0 3aa73c9672d94d8604183c244c65b94981a155fb 0 0 0 0 0  
17685 17685 20200420 SC 4377   36103   posNeg 40480   776         2063 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 0 40480   0.0 0.0 e7811ff9e0b966716c5e84063cd51acb8d221178 0 0 0 0 0  
17686 17686 20200420 SD 1685   10641 0 totalTestsPeopleViral 12326   87         709 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 264 12326   0.0 13.0 09382fb9d9acbc8be8772d1446b260a160f894a5 0 0 0 0 0  
17691 17691 20200420 VI 53   554 18 posNeg 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 6 607   0.0 0.0 2bbda2380ea23b2d16bf5c14ed05e3a1d0f91623 0 0 0 0 0  
17696 17696 20200420 WY 428 111 7073   totalTestsViral 8083 19 51         233 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 2 51   2020-04-19T00:00:00Z 8083 347 7736 317                             56 2 101 7501 299 7501   0.0 1.0 9272943e8880e9ce798e2350580a1fa84c1e1e33 0 0 0 0 0  
17698 17698 20200419 AL 4837   40875   totalTestsPeopleViral 45712 360 641   260   157   4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 154 641   2020-04-19T00:00:00Z       4837       45712                     1 182 2992 45712 3174 45712   8.0 21.0 ee19fc7d7e32158da4d583959c69dcf20d924dc9 0 0 0 0 0  
17699 17699 20200419 AR 1781   22428   totalTestsViral 24209 88 291     25 57 721 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 68 24209   2.0 0.0 2f2c5364861d8dff1ce6238c74e2d739d1631b9d 0 0 0 0 0  
17701 17701 20200419 AZ 4929   48061   totalTestsViral 65652 631 1387 283   187     4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 184 1387 994 2020-04-19T00:00:00Z 65652             52990                     4 210 1735 52990 981 52990   7.0 46.0 0672159148df7c454da62d395fdfc9c944a922de 0 0 0 0 0  
17704 17704 20200419 CT 17550       totalTestsViral 69891 1938             4/19/2020 17:00 2020-04-19T17:00:00Z 04/19 13:00 1086     2020-04-19T17:00:00Z 69891 24060 45754   671                           9 741 0 17550 2227 17550   50.0 0.0 9f80a5ffe0d3fbc67ec28f489477c5a519bcaa30 0 0 0 0 0  
17707 17707 20200419 FL 24647   230083 1179 totalTestEncountersViral 248903   3930           4/19/2020 16:12 2020-04-19T16:12:00Z 04/19 12:12 781 3930   2020-04-19T16:12:00Z             248903                       12 741 8825 255909 9158 254730   27.0 88.0 27f18cfb507e09a2670116eac0721f08633d9497 0 0 0 0 0  
17708 17708 20200419 GA 18301       totalTestsViral 83327   3464           4/19/2020 21:34 2020-04-19T21:34:00Z 04/19 17:34 687 3464   2020-04-19T21:34:00Z 83327 14613                                 13 632 0 18301 3977 18301   14.0 44.0 5dde713311f6556e77af990bab00b01318f553e2 0 0 0 0 0  
17709 17709 20200419 GU 133 3 943   posNeg 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 0 1076   0.0 0.0 36ee3544848482eb4153230e2ec61e212f954620 0 0 0 0 0  
17710 17710 20200419 HI 574   22896   totalTestEncountersViral 24096   51         410 4/19/2020 18:00 2020-04-19T18:00:00Z 04/19 14:00 9 51   2020-04-19T18:00:00Z   516     9   24096                       15 21 1106 23470 942 23470   0.0 3.0 e2d29fc3281a61d4077db630a11bc00a1f9d6a5c 0 0 0 0 0  
17712 17712 20200419 ID 1668   15773   totalTestsPeopleViral 17441 43 151   53     520 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 494 17441   1.0 0.0 414dd1b79eb31ef161601276561cd0938cead46d 0 0 0 0 0  
17713 17713 20200419 IL 30357   112961   posNeg 143318 4314   1196   749     4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 1290     2020-04-19T00:00:00Z                                     17 1197 4717 143318 5914 143318   31.0 0.0 5d49a77f8c08ec9aae618592875e0c9b5345076a 0 0 0 0 0  
17715 17715 20200419 KS 1849   16281   posNeg 18130   390           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 454 18130   6.0 7.0 1f54de867e46ac5abb22c492711323c8c14accc8 0 0 0 0 0  
17716 17716 20200419 KY 2707       totalTestsViral 32225 274 1059 155 534     1174 4/19/2020 17:00 2020-04-19T17:00:00Z 04/19 13:00 144 1059   2020-04-19T17:00:00Z 32225                                   21 185 0 2707 1629 2707   7.0 51.0 d7ba889f508e624e313e70593fbd06c5db21b7e2 0 0 0 0 0  
17717 17717 20200419 LA 23928   111420   posNeg 135348 1748       349     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 -2651 135348   29.0 0.0 45db5443a5f326c20f3f6ec61a96bc34d6d82099 0 0 0 0 0  
17718 17718 20200419 MA 39820   129295   totalTestsViral 207288 3789 3789 987         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 5596 169115   163.0 61.0 01422c72869b29a95c5e409f337c74d157c30b42 0 0 0 0 0  
17719 17719 20200419 MD 12830   55061   totalTestsViral 75989   2886         914 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 2739 67891   44.0 129.0 109528fc45a9e9166744fc43b97592fa1877a200 0 0 0 0 0  
17720 17720 20200419 ME 867   14076   posNeg 14943 46 136 18   9   393 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 20 14943   2.0 0.0 0b867f994412e226936c983ccc13bbcbc077c59e 0 0 0 0 0  
17721 17721 20200419 MI 37557 1264 89758   posNeg 127315 3403   1344   1115   3237 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 3172 127315   129.0 0.0 f30c08090ee7059c97cac8d385631941578a6030 0 0 0 0 0  
17722 17722 20200419 MN 2914   46288   totalTestEncountersViral 49202 228 574 116 226     1026 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 1232 49202   13.0 13.0 d8218c46c97acb05dfe87c30598a84493b034dcf 0 0 0 0 0  
17723 17723 20200419 MO 5667   48242   totalTestsViral 56834 875             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 2327 53909   1.0 0.0 7e50bdfd5369d713348eee8e68d2fc1e11a68fe4 0 0 0 0 0  
17724 17724 20200419 MP 14   42 4 posNeg 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 0 56   0.0 0.0 b31613d9abcd9d6ce9d7b12adad7e3ada73ef93d 0 0 0 0 0  
17726 17726 20200419 MT 433   10465   posNeg 10898 18 55         243 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 329 10898   0.0 0.0 96d73e6c3a81fb459cc24646446e3b1528e38dad 0 0 0 0 0  
17727 17727 20200419 NC 6493   72279   posNeg 78772 465             4/19/2020 11:00 2020-04-19T11:00:00Z 04/19 07:00 172     2020-04-19T11:00:00Z                                     37 353 2208 78772 2561 78772   8.0 0.0 fd82bc65e23a6a3515903fb1ab3d69f297f6be17 0 0 0 0 0  
17728 17728 20200419 ND 584 0 13045   totalTestEncountersViral 14257 15 51         189 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 932 13629   1.0 4.0 7d1283485068b45ce96eff423c326561d14e63de 0 0 0 0 0  
17729 17729 20200419 NE 1287   13288   totalTestsViral 16066               4/19/2020 19:45 2020-04-19T19:45:00Z 04/19 15:45 28     2020-04-19T19:45:00Z 16066 1385 14558         14652                     31 149 749 14575 1064 14575   4.0 0.0 e6ee4cadb7c4f8b16e16b21dffcee6bf4f70e250 0 0 0 0 0  
17730 17730 20200419 NH 1342   12082 316 totalTestsViral 14701 85 192         513 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 601 13424   1.0 2.0 0d25b69db7454d68393993715e63795f45d9ae71 0 0 0 0 0  
17731 17731 20200419 NJ 85301   85387   posNeg 170688 7494   1940   1628     4/19/2020 13:00 2020-04-19T13:00:00Z 04/19 09:00 5310   682 2020-04-19T13:00:00Z       85301 4202 1108   170688                     34 3881 4271 170688 8152 170688   171.0 0.0 ed99a866a106122217d4dad0a2f0c2ab30d12ff5 0 0 0 0 0  
17732 17732 20200419 NM 1845   35197   posNeg 37042 103 274         487 4/19/2020 18:46 2020-04-19T18:46:00Z 04/19 14:46 55 274   2020-04-19T18:46:00Z 37042                                   35 47 363 37042 410 37042   2.0 16.0 862379620201db30bce7aec1dce38e4f824b5758 0 0 0 0 0  
17733 17733 20200419 NV 3728   27870   totalTestEncountersViral 36007               4/19/2020 11:00 2020-04-19T11:00:00Z 04/19 07:00 172     2020-04-19T11:00:00Z 38668     3728     36007                       32 102 745 31598 810 31598   4.0 0.0 3fb2c0e7fa68dd53fc00b43ee3efedf2abb7a55d 0 0 0 0 0  
17734 17734 20200419 NY 242786       totalTestEncountersViral 617555 16213 64550 4878         4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 13869 64550 37596 2020-04-19T00:00:00Z             617555                       36 6054 0 242786 21023 242786   507.0 1447.0 c38729f89f7d05e6ac67e04b81a0394b9a859b9a 0 0 0 0 0  
17735 17735 20200419 OH 11602 310     totalTestsViral 88242   2565   765       4/19/2020 14:00 2020-04-19T14:00:00Z 04/19 10:00 471 2565   2020-04-19T14:00:00Z 88242 11198   11292 453 18                         39 1380 0 11602 4418 11602   20.0 46.0 9428bed8163b061b6d0e3961c6d0b3a9c2598f7d 0 0 0 0 0  
17736 17736 20200419 OK 2599   32966   posNeg 35565 307 541 136       1575 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 29 35565   1.0 0.0 f94f96a8a7a5bd9002cf72a668535db480b26970 0 0 0 0 0  
17738 17738 20200419 PA 32284   126570   totalTestEncountersViral 166548 2634       657     4/19/2020 13:00 2020-04-19T13:00:00Z 04/19 09:00 1112     2020-04-19T13:00:00Z             166548 158854                     42 1215 3674 158854 5317 158854   276.0 0.0 e7602190c432dbb753d72998109f64d9694cf896 0 0 0 0 0  
17739 17739 20200419 PR 1213   8280 1839 posNeg 9493 160             4/19/2020 07:00 2020-04-19T07:00:00Z 04/19 03:00 62     2020-04-19T07:00:00Z                                     72 95 225 11332 320 9493   2.0 0.0 5b8eeab930838af900925d8b3fb20287c0425d67 0 0 0 0 0  
17740 17740 20200419 RI 5207   29289   totalTestEncountersViral 35950 298 605 66   37     4/19/2020 03:00 2020-04-19T03:00:00Z 04/18 23:00 164 605 244 2020-04-19T03:00:00Z 38488 5520 32968       35950 34496                     44 339 1762 34496 2046 34496   14.0 27.0 9e846efc20ac908e860592f6266a27ba96cc821d 0 0 0 0 0  
17741 17741 20200419 SC 4377   36103   posNeg 40480   776         2633 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 1647 40480   1.0 0.0 770b7f22f4345baa46560e827fe7b2d2329e8c81 0 0 0 0 0  
17742 17742 20200419 SD 1635   10427 0 totalTestsPeopleViral 12062   74         646 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 402 12062   0.0 6.0 afb15607657fb360783ed47a9111c496a19bd041 0 0 0 0 0  
17743 17743 20200419 TN 7070       totalTestsViral 97098 393 724         3344 4/19/2020 15:00 2020-04-19T15:00:00Z 04/19 11:00 148 724   2020-04-19T15:00:00Z 97098 7070 90028                               47 308 0 7070 6512 7070   3.0 5.0 437af89eeb20e6522afe80ae9927932c0603dd61 0 0 0 0 0  
17744 17744 20200419 TX 18923       totalTestsViral 245830 1471           5334 4/19/2020 13:00 2020-04-19T13:00:00Z 04/19 09:00 477     2020-04-19T13:00:00Z 245830 25049   18923                             48 663 0 18923 6314 18923   24.0 0.0 b2399d97c165c8289b5fc57a68a867ed5aad6c0f 0 0 0 0 0  
17745 17745 20200419 UT 3069   65537   totalTestsViral 71179   259         679 4/19/2020 15:00 2020-04-19T15:00:00Z 04/19 11:00 27 259   2020-04-19T15:00:00Z 71179 3398 67781         68736                     49 138 4038 68606 4364 68606   2.0 8.0 00237f986b4c58303d48ada6ad3ebac68d1cea28 0 0 0 0 0  
17746 17746 20200419 VA 8537     499 totalTestEncountersViral 70666 1319 1296 388   231     4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 277 1296 1267 2020-04-19T00:00:00Z   12352         70666   27 4             26 8 51 484 0 9036 2706 8537   19.0 75.0 5b7f0b75fe8bcc78fec192d2e5a197254079191f 0 0 0 0 0  
17747 17747 20200419 VI 53   548 22 posNeg 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 158 601   0.0 0.0 2b6f54206a444f0c5002665e61a52f775cf40d69 0 0 0 0 0  
17748 17748 20200419 VT 813 0 10514   totalTestsViral 12481 53           15 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 38     2020-04-19T00:00:00Z 12481     813       11327                     50 11 168 11327 295 11327   0.0 0.0 5979917b6fb0dd7ec60ec37b8a6c4e281002137a 0 0 0 0 0  
17749 17749 20200419 WA 12361       totalTestEncountersViral 165059 586   193         4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 615     2020-04-19T00:00:00Z       12361     165059 157116                     53 347 0 12361 1967 12361   17.0 0.0 6b2ab60285912637a63c90657e85a36bc128656d 0 0 0 0 0  
17750 17750 20200419 WI 5176 830 45323 248 totalTestEncountersViral 54081 357 1190 137 307       4/19/2020 12:57 2020-04-19T12:57:00Z 04/19 08:57 220 1190   2020-04-19T12:57:00Z       4346     54081                       55 163 1361 50747 1990 50499   9.0 14.0 800365a66ea5f69905f857730af197812e369ed2 0 0 0 0 0  
17751 17751 20200419 WV 863   19168   posNeg 20031 72   37   25   265 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 591 20031   2.0 0.0 97c7da579e0848beeafd8f52b8ca325490ac4b1c 0 0 0 0 0  
17752 17752 20200419 WY 426 113 6972   totalTestsViral 7784 19 50         227 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 2 50   2020-04-19T00:00:00Z 7784 338 7446 313                             56 4 755 7398 83 7398   0.0 0.0 af685f3c8a4927c9cc02f0793a1e4a583e71c72a 0 0 0 0 0  
17788 17788 20200418 NM 1798   34834   posNeg 36632 92 258         465 4/19/2020 19:46 2020-04-19T19:46:00Z 04/19 15:46 53 258   2020-04-19T19:46:00Z 36632                                   35 87 932 36632 1019 36632   2.0 16.0 95e30cd25a84be9ddb14df806b9ad11af1286ce4 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,
   [probableCases] INTEGER,
   [negative] INTEGER,
   [pending] INTEGER,
   [totalTestResultsSource] TEXT,
   [totalTestResults] INTEGER,
   [hospitalizedCurrently] INTEGER,
   [hospitalizedCumulative] INTEGER,
   [inIcuCurrently] INTEGER,
   [inIcuCumulative] INTEGER,
   [onVentilatorCurrently] INTEGER,
   [onVentilatorCumulative] INTEGER,
   [recovered] INTEGER,
   [lastUpdateEt] TEXT,
   [dateModified] TEXT,
   [checkTimeEt] TEXT,
   [death] INTEGER,
   [hospitalized] INTEGER,
   [hospitalizedDischarged] INTEGER,
   [dateChecked] TEXT,
   [totalTestsViral] INTEGER,
   [positiveTestsViral] INTEGER,
   [negativeTestsViral] INTEGER,
   [positiveCasesViral] INTEGER,
   [deathConfirmed] INTEGER,
   [deathProbable] INTEGER,
   [totalTestEncountersViral] INTEGER,
   [totalTestsPeopleViral] INTEGER,
   [totalTestsAntibody] INTEGER,
   [positiveTestsAntibody] INTEGER,
   [negativeTestsAntibody] INTEGER,
   [totalTestsPeopleAntibody] INTEGER,
   [positiveTestsPeopleAntibody] INTEGER,
   [negativeTestsPeopleAntibody] INTEGER,
   [totalTestsPeopleAntigen] INTEGER,
   [positiveTestsPeopleAntigen] INTEGER,
   [totalTestsAntigen] INTEGER,
   [positiveTestsAntigen] INTEGER,
   [fips] INTEGER,
   [positiveIncrease] INTEGER,
   [negativeIncrease] INTEGER,
   [total] INTEGER,
   [totalTestResultsIncrease] INTEGER,
   [posNeg] INTEGER,
   [dataQualityGrade] TEXT,
   [deathIncrease] FLOAT,
   [hospitalizedIncrease] FLOAT,
   [hash] TEXT,
   [commercialScore] INTEGER,
   [negativeRegularScore] INTEGER,
   [negativeScore] INTEGER,
   [positiveScore] INTEGER,
   [score] INTEGER,
   [grade] TEXT
);