states_daily_4pm_et

Table actions

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

82 rows where "dateModified" is on date 2020-06-01 sorted by totalTestsPeopleViral

✎ 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, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateChecked (date)

dateModified (date) ✖

  • 2020-06-01 · 82 ✖
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
5268 5268 20200624 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 fb063bc2a190825408f9fb42ad7bc5a16c4681fd 0 0 0 0 0  
5324 5324 20200623 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 b93dc121a8c67fa5c7b318f8d4d4af4784422e94 0 0 0 0 0  
5380 5380 20200622 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 da8874e00bd4bc384fb0471c2fcf497621e4ae3f 0 0 0 0 0  
5436 5436 20200621 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 1f7d5993e181d62b0959dc927657a09d4a97c276 0 0 0 0 0  
5492 5492 20200620 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 ce7ded00f11d0f59e53c961dcf347b0d97aaed47 0 0 0 0 0  
5548 5548 20200619 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 fe53ede43c21446e227174fb121bfa4808368a82 0 0 0 0 0  
5604 5604 20200618 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 1d3fae5111c9907c51d8be29f26f1c46f6cf1a5f 0 0 0 0 0  
5660 5660 20200617 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 b4f89f251b4b7500e0ce305936df403c9d330170 0 0 0 0 0  
5716 5716 20200616 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 3d647bc2c3ea8ac6e393d541d696df8619dd3b1c 0 0 0 0 0  
5772 5772 20200615 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 7e417d071929d909c041ecbebe65827f65381f75 0 0 0 0 0  
5828 5828 20200614 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 f9bfd2a90bedd4e2af74b5dbc48b08be272dcf8a 0 0 0 0 0  
5884 5884 20200613 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 1ee2c48e0f28674695c7ebcc053c45c0f78f1da7 0 0 0 0 0  
5940 5940 20200612 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 82f714bdc45ff7ad0579a29fa557fd90bf4c76f9 0 0 0 0 0  
5996 5996 20200611 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 69dfacea0911bd3002f3c251cf88a036bcb943c1 0 0 0 0 0  
6052 6052 20200610 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 60483119d780d7405d09498ca522692ae6f5d425 0 0 0 0 0  
6108 6108 20200609 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 01e3a252b835ae30597c5eaf9a6dea24e9d18816 0 0 0 0 0  
6164 6164 20200608 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 b0a82a02a3f8de9f1d5ec38422eeeda2c49c2d6b 0 0 0 0 0  
6220 6220 20200607 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 b4003533a1b3bd1ae7e3df93e4a88d0de5963b3b 0 0 0 0 0  
6276 6276 20200606 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 8be0d1f6e21d2adc9d1302d622f452ea2333a765 0 0 0 0 0  
6332 6332 20200605 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 ab8bc4d742b66f5b19243ae16a7806752bc528ff 0 0 0 0 0  
6388 6388 20200604 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 faeb3cbea6d73880c1907d17000929508f7b6649 0 0 0 0 0  
6444 6444 20200603 AS 0 174   174               C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 0   2020-06-01T00:00:00Z 174     0                             60 0 0 174 posNeg 0 174 0 0 35f59ce017000185a8a2b11d7564c5eb54cafadb 0 0 0 0 0  
6498 6498 20200602 AL 18642 205160   223802 606 1879   591   355 9355 B 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 651 1879 2020-06-01T00:00:00Z 223802     18354 649 2                         1 279 0 223802 posNeg 567 223802 5 23 f7e45c18ac45579c4a37e3cb660838d6fab6374a 0 0 0 0 0  
6510 6510 20200602 HI 652 48269   48921   83         608 D 6/1/2020 18:00 2020-06-01T18:00:00Z 06/01 14:00 17 83 2020-06-01T18:00:00Z 55719                                   15 0 434 48921 posNeg 434 48921 0 0 dfd0aaaf24eed4f0f88ec8bddc0b1e188d54714b 0 0 0 0 0  
6512 6512 20200602 ID 2906 45227   47870 34 247 4 98     2266 A 6/1/2020 19:00 2020-06-01T19:00:00Z 06/01 15:00 83 247 2020-06-01T19:00:00Z 47870     2643 63 20                         16 67 1369 48133 posNeg 1434 48133 1 5 87688d141ed49ad6baf193147bd2224859d1f14c 0 0 0 0 0  
6515 6515 20200602 KS 10011 93301   103312   862   290   127 555 A 6/1/2020 10:00 2020-06-01T10:00:00Z 06/01 06:00 217 862 2020-06-01T10:00:00Z                                     20 0 8071 103312 posNeg 8071 103312 0 20 5e541167d63632d7549ffb88ce572ddb5c8c4591 0 0 0 0 0  
6520 6520 20200602 ME 2377 50591   52968 48 287 16   10   1646 B 6/1/2020 23:59 2020-06-01T23:59:00Z 06/01 19:59 94 287 2020-06-01T23:59:00Z 53536 2848 50591 2118 94       4328 219 4101               23 28 3307 52968 posNeg 3335 52968 5 3 bfd3c0c34812a4c5b16cf373d8c99e06503371af 0 0 0 0 0  
6522 6522 20200602 MN 27376 267931   295307 537 3134 248 1003     20381 A 6/1/2020 17:00 2020-06-01T17:00:00Z 06/01 13:00 1082 3134 2020-06-01T17:00:00Z       27376 1072 10 295307                       27 479 7192 295307 posNeg 7671 295307 22 48 7ed3beb663936f3a30a84c5a2a32727e5bf76af0 0 0 0 0 0  
6525 6525 20200602 MS 16020 163478   179498 584 2296 146   97   11203 A 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 767 2296 2020-06-01T00:00:00Z 179388     15910 752 15     7882 95                 28 268 2976 179498 posNeg 3244 179498 28 0 5863bd8c21b249df7f3b4bd81fd720c890fb473d 0 0 0 0 0  
6532 6532 20200602 NM 7800 195315   203115 191 1317         2888 C 6/1/2020 18:00 2020-06-01T18:00:00Z 06/01 14:00 362 1317 2020-06-01T18:00:00Z 203115     7800                             35 111 3400 203115 posNeg 3511 203115 6 0 29fc9a35d7a6e50eb72ac023570571192b4e8a19 0 0 0 0 0  
6546 6546 20200602 VA 46239 282650 450 369281 1362 7373 336   186   6011 A+ 6/1/2020 17:00 2020-06-01T17:00:00Z 06/01 13:00 1407 7373 2020-06-01T17:00:00Z   55298   44069 1300 107 369281                       51 841 3329 329339 posNeg 7484 328889 15 47 48d98135eec697f67942a3e1db1641dcd144a164 0 0 0 0 0  
6552 6552 20200602 WY 910 24832   25742 7 86         667 C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 17 86 2020-06-01T00:00:00Z 25532 817 24714 700                             56 0 595 25742 posNeg 595 25742 0 0 a188cecdee31b9b0c311fb997248a738629fd932 0 0 0 0 0  
6553 6553 20200601 AK 467 53723   54190 10       1   368 A 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 10   2020-06-01T00:00:00Z 54190     467 10                           2 33 2462 54190 posNeg 2495 54190 0 0 1baf779181ac94b972b70ab258a66fdee1280ff1 0 0 0 0 0  
6554 6554 20200601 AL 18363 205160   223235 596 1856   591   355 9355 B 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 646 1856 2020-06-01T00:00:00Z 223235     18075 644 2                         1 460 5510 223523 posNeg 1928 223523 15 12 4701ebe7db2329d01a10df2a0e1047b5d9309a77 0 0 0 0 0  
6555 6555 20200601 AR 7443 125793   133236 115 711     27 123 5401 A 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 133 711 2020-06-01T00:00:00Z 133236     7443                             5 190 3531 133236 posNeg 3721 133236 0 0 3e5d86ebd670e75bccdbd7d3d83179e360cd5be1 0 0 0 0 0  
6558 6558 20200601 CA 113006 1899577   2012583 4258   1273         B 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 4251   2020-06-01T00:00:00Z 2012583     113006                             6 2423 65312 2012583 posNeg 67735 2012583 38 0 6e1fd425e782881ed9663febc8686ad1003340a2 0 0 0 0 0  
6564 6564 20200601 GA 47618 424013   471631 841 8127   1800       A 6/1/2020 13:00 2020-06-01T13:00:00Z 06/01 09:00 2074 8127 2020-06-01T13:00:00Z 471631     47618         91184                   13 632 5474 471631 posNeg 6106 471631 32 181 79ce2a56762cf53180a612e2260c3cf03978d6c8 0 0 0 0 0  
6565 6565 20200601 GU 175 6141   6316             145 B 6/1/2020 06:35 2020-06-01T06:35:00Z 06/01 02:35 5   2020-06-01T06:35:00Z 6281     167         85 2                 66 2 212 6316 posNeg 214 6316 0 0 eb66abbc391396f1a96baf22f702be9b61561f92 0 0 0 0 0  
6571 6571 20200601 KS 10011 85230   95241   842   284   124 547 A 6/1/2020 10:00 2020-06-01T10:00:00Z 06/01 06:00 217 842 2020-06-01T10:00:00Z                                     20 292 0 95241 posNeg 292 95241 9 0 db70de73887a832a6532d0cbcb031f63e19115fb 0 0 0 0 0  
6572 6572 20200601 KY 10046 206000   215853 457 2274 90 940     3232 A 6/1/2020 17:00 2020-06-01T17:00:00Z 06/01 13:00 439 2274 2020-06-01T17:00:00Z 215853     9853 438 1     20563                   21 342 1951 216046 posNeg 2267 216046 8 2 15d31370bbd567c425fbb56b4e19ab7c2147ce87 0 0 0 0 0  
6577 6577 20200601 MI 63813 581424   645237 674   346   240   38099 A+ 6/1/2020 11:00 2020-06-01T11:00:00Z 06/01 07:00 5843   2020-06-01T11:00:00Z 659153 77729 581424 58417 5627 242     67783                   26 245 14232 645237 posNeg 14477 645237 25 0 28652d491024e715c0297a049d239682e9cc38fa 0 0 0 0 0  
6580 6580 20200601 MP 22 6312   6334             16 D 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 2   2020-06-01T00:00:00Z 6334     22                             69 0 161 6334 posNeg 161 6334 0 0 c40dc6a14f098a8aa93c423641ab74374d1ca4f5 0 0 0 0 0  
6582 6582 20200601 MT 519 40138   40657 2 67         461 C 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 17 67 2020-06-01T00:00:00Z 40657     519                             30 4 855 40657 posNeg 859 40657 0 0 729bc52e911dbee5bed25fecd7ed499a8b2ff071 0 0 0 0 0  
6583 6583 20200601 NC 29263 392645   421908 650           18860 A 6/1/2020 10:50 2020-06-01T10:50:00Z 06/01 06:50 898   2020-06-01T10:50:00Z 421908     29263 898                           37 674 4945 421908 posNeg 5619 421908 12 0 f305df74c6c818e2c1aae2f757cfc2e651488db4 0 0 0 0 0  
6587 6587 20200601 NJ 160918 634682   795600 2466 17222 646   459   26703 A+ 6/1/2020 13:00 2020-06-01T13:00:00Z 06/01 09:00 13447 17222 2020-06-01T13:00:00Z 795600     160918 11721 1726                         34 473 48982 795600 posNeg 49455 795600 26 25 a6930004485b3fa4f9e9a7a642cd2371ab9c07c4 0 0 0 0 0  
6590 6590 20200601 NY 371711 1742066   2113777 3331 89703 999   746   66110 A 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 23959 89703 2020-06-01T00:00:00Z       371711     2113777                       36 941 49011 2113777 posNeg 49952 2113777 54 113 9c40476d237dc57f1f6ef494048a9018f3f62054 0 0 0 0 0  
6591 6591 20200601 OH 35984 362082   398066 761 6112 324 1569 223     B 6/1/2020 14:00 2020-06-01T14:00:00Z 06/01 10:00 2206 6112 2020-06-01T14:00:00Z 398066     33501 1993 213                         39 471 6687 398066 posNeg 7158 398066 51 63 703255fc10b3d2e77ed251fd398785439dc16821 0 0 0 0 0  
6592 6592 20200601 OK 6573 186700   193273 154 986 65       5511 A+ 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 334 986 2020-06-01T00:00:00Z 194496 7291 186700 6573         20278 746                 40 67 0 193273 posNeg 67 193273 0 1 8ba215b9017e5c3e9185715d8ced36740d60f6c5 0 0 0 0 0  
6595 6595 20200601 PR 3873 60422   64295 99   9   4     B 6/1/2020 02:51 2020-06-01T02:51:00Z 05/31 22:51 136   2020-06-01T02:51:00Z 61702 1952 59701 1304 63 73       2569                 72 97 0 64295 posNeg 97 64295 0 0 490a6aa3795a1cbac136e36ed5541f08c1b2e014 0 0 0 0 0  
6597 6597 20200601 SC 12148 192540   204688 450 1634         6459 A 6/1/2020 15:10 2020-06-01T15:10:00Z 06/01 11:10 500 1634 2020-06-01T15:10:00Z 210826 18286 192540 12148 500                           45 287 4185 204688 posNeg 4472 204688 6 0 0b1d1dfee5ed6069c749dd8f65486f929f01c31b 0 0 0 0 0  
6600 6600 20200601 TX 64880 905151   970031 1756           43338 B 6/1/2020 17:00 2020-06-01T17:00:00Z 06/01 13:00 1678   2020-06-01T17:00:00Z 970031     64880         103460 4080                 48 593 17573 970031 posNeg 18166 970031 6 0 4d8d4509304c770326976ab306e1476e74cd2da9 0 0 0 0 0  
6603 6603 20200601 VI 70 1741 4 1811             62 C 6/1/2020 08:00 2020-06-01T08:00:00Z 06/01 04:00 6   2020-06-01T08:00:00Z 1815       6                           78 1 108 1815 posNeg 109 1811 0 0 89c1f7ea3610732b86148ee834391016b6e82b05 0 0 0 0 0  
6607 6607 20200601 WV 2017 96078   98095 31   11   4   1313 B 6/1/2020 10:00 2020-06-01T10:00:00Z 06/01 06:00 75   2020-06-01T10:00:00Z 99751     1593         5650                   54 7 466 98095 posNeg 473 98095 0 0 5321d5672cb495af8d6093cba4a2dc62a0cef6e8 0 0 0 0 0  
6563 6563 20200601 FL 56830 983570 1160 1040400   10494           A 6/1/2020 09:54 2020-06-01T09:54:00Z 06/01 05:54 2543 10494 2020-06-01T09:54:00Z 1210100 77387 1130070 56830 2543     1041318       123552 5474 118053         12 667 18384 1041560 posNeg 19051 1040400 9 41 5a83f11154c22dc7356fcb6fbffe4d65c36e5993 0 0 0 0 0  
6507 6507 20200602 FL 57447 992305 1206 1049752   10678           A 6/1/2020 09:54 2020-06-01T09:54:00Z 06/01 05:54 2613 10678 2020-06-01T09:54:00Z 1210100 77387 1130070 57447 2613     1050671       123552 5474 118053         12 617 8735 1050958 posNeg 9352 1049752 70 184 8258baf04d3ee33b3dcbf7aed69d9afecd412ff7 0 0 0 0 0  
6529 6529 20200602 NE 14345 92073   106418               D 6/1/2020 20:00 2020-06-01T20:00:00Z 06/01 16:00 178   2020-06-01T20:00:00Z       14345       106570                     31 244 2509 106418 posNeg 2753 106418 8 0 795b56aae7bafb469a27a6c21c4f3dd53b9e28fb 0 0 0 0 0  
6596 6596 20200601 RI 15087 100112   165474 195 1724 46   29   1281 A+ 6/1/2020 03:00 2020-06-01T03:00:00Z 05/31 23:00 720 1724 2020-06-01T03:00:00Z 166628 20124 146504 15087     165474 115199                     44 99 1322 115199 totalTestEncountersViral 1826 115199 2 23 6707229c7927fc22771e954ec86a7c24dabd327e 0 0 0 0 0  
6593 6593 20200601 OR 4302 127316   131618 108 790 32   17   2164 A+ 6/1/2020 03:01 2020-06-01T03:01:00Z 05/31 23:01 154 790 2020-06-01T03:01:00Z       4192       131508                     41 59 2358 131618 posNeg 2417 131618 1 4 b5c7cdd7fd9481128f77a31662ca57339205a99d 0 0 0 0 0  
6589 6589 20200601 NV 8688 138095   146783 361   87   40   459 A+ 6/1/2020 11:00 2020-06-01T11:00:00Z 06/01 07:00 445   2020-06-01T11:00:00Z 169813     8688       146688                     32 95 4128 146783 posNeg 4223 146783 1 0 85a75f4c94459dfe68ae3291dd4609b978c72b83 0 0 0 0 0  
6533 6533 20200602 NV 8830 143261   152091 365   88   39   464 A+ 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 452   2020-06-01T00:00:00Z 176032     8830       151966                     32 142 5166 152091 posNeg 5308 152091 7 0 85ebcb65fbb860563a72b7e69f6476088a6f8d41 0 0 0 0 0  
6567 6567 20200601 IA 19697 139384   159081 339   125   73   11440 A+ 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 551   2020-06-01T00:00:00Z       19697       159292       19051 1869 17170         19 145 2640 159081 posNeg 2785 159081 17 0 eaddf0d29a02980f87128d967f44b4db8bab97ea 0 0 0 0 0  
6559 6559 20200601 CO 26378 159998   213020 414 4347         3919 A 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 1181 4347 2020-06-01T00:00:00Z       23949     213020 183947 61868 4570 57298               8 280 5469 186376 totalTestEncountersViral 7532 186376 0 14 4310afd764d47d4cbf747e2f25d5a6ccc1be731e 0 0 0 0 0  
6579 6579 20200601 MO 13327 186381   199708 693       78     B 6/1/2020 15:00 2020-06-01T15:00:00Z 06/01 11:00 773   2020-06-01T15:00:00Z 183650 14498 168871 13327       199435       24048 953 23095         29 180 5967 199708 posNeg 6147 199708 1 0 ced5fba714d0d37ed32392fdee16bf166c1741d1 0 0 0 0 0  
6601 6601 20200601 UT 9999 208113   218112 134 789   242   102 6251 B 6/1/2020 15:00 2020-06-01T15:00:00Z 06/01 11:00 113 789 2020-06-01T15:00:00Z       9999       218112                     49 202 3996 218112 posNeg 4198 218112 0 14 40a5af40c4aac4516f8a786c0e413676c63be090 0 0 0 0 0  
6557 6557 20200601 AZ 20123 207947   228070 968 3445 377   238   4869 A+ 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 917 3445 2020-06-01T00:00:00Z               228070 93856                   4 187 2677 228070 posNeg 2864 228070 11 66 3fd65eb1556573eb58e4e17dd43b4b408b34582b 0 0 0 0 0  
6504 6504 20200602 CT 42979 227631   270610 434 13793         7511 B 6/1/2020 20:30 2020-06-01T20:30:00Z 06/01 16:30 3972 13793 2020-06-01T20:30:00Z 274396       3139 833   268572                     9 239 8981 270610 posNeg 9220 270610 8 0 43a2433150457c0fc04c57a114f836f424c91311 0 0 0 0 0  
6514 6514 20200602 IN 35237 236682   271919 961 5902 358 1261 140   22623 A+ 6/1/2020 23:59 2020-06-01T23:59:00Z 06/01 19:59 2197 5902 2020-06-01T23:59:00Z         2022 175   271919                     18 407 5616 271919 posNeg 6023 271919 55 42 8c50ac785638c0e4fd62927b14099265bf96d646 0 0 0 0 0  
6606 6606 20200601 WI 20736 253595 211 274331 403 2603 136 586     11838 A+ 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 595 2603 2020-06-01T00:00:00Z       18543 595     272138                     55 172 3492 274542 posNeg 3664 274331 3 20 cb2d6a9bdd133bec8c00089d6af7a3b633573812 0 0 0 0 0  
6575 6575 20200601 MD 53327 255403   308730 1174 8886 479       3782 B 6/1/2020 10:00 2020-06-01T10:00:00Z 06/01 06:00 2625 8886 2020-06-01T10:00:00Z 351908 61245   53327 2505 120   308730                     24 549 6300 308730 posNeg 6849 308730 29 148 b60c21b532ccd8d9f07a4aded86da8bf9e1fc8ed 0 0 0 0 0  
6605 6605 20200601 WA 23288 368617   391905 245 3501     52     B 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 1118 3501 2020-06-01T00:00:00Z       23288 1118   391905 344050                     53 410 7613 391905 posNeg 8023 391905 0 21 4a5ae08f2cb8ef68f9f388a0b660d4fec56632a5 0 0 0 0 0  
6604 6604 20200601 VT 983 34343   35326 16           880 B 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 55   2020-06-01T00:00:00Z       983 55     35326                     50 2 1354 35326 posNeg 1356 35326 0 0 11fb25d957c99a6f7dfcfb030b184a79354a08df 0 0 0 0 0  
6573 6573 20200601 LA 40341 347029   387370 661       86   31728 B 6/1/2020 13:00 2020-06-01T13:00:00Z 06/01 09:00 2801   2020-06-01T13:00:00Z       40341 2690 111   387370                     22 425 11836 387370 posNeg 12261 387370 10 0 49b9820eab83b5bbdae99fa95769c311332cca2f 0 0 0 0 0  
6561 6561 20200601 DC 8857 38406   47263 302   108   67   1126 A+ 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 468   2020-06-01T00:00:00Z             47263 38975                     11 56 724 47263 posNeg 780 47263 2 0 e260579a3bae66fb8ca193f1abc47e6daab21592 0 0 0 0 0  
6505 6505 20200602 DC 8886 38815   47701 295   106   74   1137 A+ 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 470   2020-06-01T00:00:00Z             47701 39251                     11 29 409 47701 posNeg 438 47701 2 0 51789afb61c161616e47ff8220f302d88e8d9b47 0 0 0 0 0  
6599 6599 20200601 TN 23554 424939   448493 504 1767         15564 B 6/1/2020 15:00 2020-06-01T15:00:00Z 06/01 11:00 367 1767 2020-06-01T15:00:00Z       23554 367     448493                     47 548 11968 448493 posNeg 12516 448493 3 17 417eee99547eedaf14ee08df94841cc2edd456c3 0 0 0 0 0  
6598 6598 20200601 SD 5034 40627   45661 87 435         3903 B 6/1/2020 11:30 2020-06-01T11:30:00Z 06/01 07:30 62 435 2020-06-01T11:30:00Z               45661                     46 41 1492 45661 posNeg 1533 45661 0 3 f270a1f1c5dae862c430b4fddabacfb6644f6bfe 0 0 0 0 0  
6594 6594 20200601 PA 72898 389431   462329 1302       287   48428 A+ 6/1/2020 00:00 2020-06-01T00:00:00Z 05/31 20:00 5567   2020-06-01T00:00:00Z       70278       459709   616                 42 352 6320 462329 posNeg 6672 462329 12 0 fff337eae297970a1e206abffadfe24260fc7934 0 0 0 0 0  
6542 6542 20200602 SD 5067 41779   46846 89 443         3990 B 6/1/2020 18:00 2020-06-01T18:00:00Z 06/01 14:00 62 443 2020-06-01T18:00:00Z               46846                     46 33 1152 46846 posNeg 1185 46846 0 8 a5ff610b376a0f890beff1b2b222a0943310740b 0 0 0 0 0  
6506 6506 20200602 DE 9685 54377   64062 157           5442 A 6/1/2020 18:00 2020-06-01T18:00:00Z 06/01 14:00 471   2020-06-01T18:00:00Z         414 57   64062                     10 80 1535 64062 posNeg 1615 64062 0 0 7abadd1ece46e7b3752cebc17f0018217056c7c7 0 0 0 0 0  
6584 6584 20200601 ND 2623 70676   94967 35 169         2078 C 6/1/2020 13:00 2020-06-01T13:00:00Z 06/01 09:00 50 169 2020-06-01T13:00:00Z 97028     2623 47 3 94967 70849 2772 91 2681               38 47 1213 73299 totalTestEncountersViral 2308 73299 2 2 829594fd492872edb1b2c5e60581b11dc669134b 0 0 0 0 0  
6530 6530 20200602 NH 4685 69659 2183 82744 98 456   142     2954 B 6/1/2020 09:00 2020-06-01T09:00:00Z 06/01 05:00 245 456 2020-06-01T09:00:00Z 82744     4685       74344 13827     12046             33 34 1854 76527 posNeg 1506 74344 0 5 f0abca7a9e9b395896c8f3649d67987b95415945 0 0 0 0 0  
6569 6569 20200601 IL 121234 797039   918273 3215   902   547     A 6/1/2020 00:59 2020-06-01T00:59:00Z 05/31 20:59 5412   2020-06-01T00:59:00Z 918273     121234 5412     918273                     17 974 19040 918273 posNeg 20014 918273 22 0 82cd715c818a764bc4605021c805d44b309916d8 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
);