states_daily_4pm_et

Table actions

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

82 rows where "dateChecked" is on date 2020-06-01

✎ 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, dateModified (date)

dateChecked (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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  

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
);