states_daily_4pm_et

Table actions

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

69 rows where "dateChecked" is on date 2020-07-24

✎ 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, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-07-24 · 69 ✖
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
2524 2524 20200812 AS 0 1396   1396               C 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 0   2020-07-24T00:00:00Z 1396     0                             60 0 0 1396 posNeg 0 1396 0 0 f70f31d7591d13af3ea6a26793a5c00a44eb2ee7 0 0 0 0 0  
2580 2580 20200811 AS 0 1396   1396               C 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 0   2020-07-24T00:00:00Z 1396     0                             60 0 0 1396 posNeg 0 1396 0 0 4f6198519ea1d23450aaecd88f1582582ae1d9d9 0 0 0 0 0  
2636 2636 20200810 AS 0 1396   1396               C 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 0   2020-07-24T00:00:00Z 1396     0                             60 0 0 1396 posNeg 0 1396 0 0 9a81cac9876085099db613e679de87f5f5302f09 0 0 0 0 0  
2692 2692 20200809 AS 0 1396   1396               C 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 0   2020-07-24T00:00:00Z 1396     0                             60 0 0 1396 posNeg 0 1396 0 0 55eadea9a22d461e1747b856a903bfeaa270aa3b 0 0 0 0 0  
2748 2748 20200808 AS 0 1396   1396               C 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 0   2020-07-24T00:00:00Z 1396     0                             60 0 0 1396 posNeg 0 1396 0 0 216733e44f8273f38462e5cf2f83c045acbf7292 0 0 0 0 0  
2804 2804 20200807 AS 0 1396   1396               C 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 0   2020-07-24T00:00:00Z 1396     0                             60 0 0 1396 posNeg 0 1396 0 0 9cc916ed882b4bf9151695507c4bb222bff5a1a6 0 0 0 0 0  
2860 2860 20200806 AS 0 1396   1396               C 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 0   2020-07-24T00:00:00Z 1396     0                             60 0 0 1396 posNeg 0 1396 0 0 20e74228ad58c977b5d272712278d523f59832b3 0 0 0 0 0  
2916 2916 20200805 AS 0 1396   1396               C 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 0   2020-07-24T00:00:00Z 1396     0                             60 0 129 1396 posNeg 129 1396 0 0 9345a10de7579451a9f179a1dc334e31fa316d85 0 0 0 0 0  
3485 3485 20200726 GU 337 19695   20032 1           244 B 7/24/2020 20:40 2020-07-24T20:40:00Z 07/24 16:40 5   2020-07-24T20:40:00Z 19791     329       20024 145 2                 66 0 0 20032 posNeg 0 20032 0 0 98609d56f2e8ca38aaa566ee9a0905603d84268a 0 0 0 0 0  
3491 3491 20200726 KS 25109 252858   277967 315 1596 98 459 24 166 1077 A+ 7/24/2020 10:00 2020-07-24T10:00:00Z 07/24 06:00 326 1596 2020-07-24T10:00:00Z               277967                     20 0 0 277967 posNeg 0 277967 0 0 0045cde4e3937fae394bfbfbf9d4a23d542bf1ff 0 0 0 0 0  
3501 3501 20200726 MS 52304 370789   423093 1172 3982 295   159   30315 A+ 7/24/2020 19:00 2020-07-24T19:00:00Z 07/24 15:00 1495 3982 2020-07-24T19:00:00Z 421233     51639 1458 37     15740 95                 28 1207 0 423093 posNeg 1207 423093 15 0 234690b8a6a85e0245dd4498d4a0ab7c22d2e341 0 0 0 0 0  
3516 3516 20200726 RI 18224 171804   344434 66 2146 6   5   1769 A+ 7/24/2020 12:00 2020-07-24T12:00:00Z 07/24 08:00 1002 2146 2020-07-24T12:00:00Z 329556 26593 302963 18224     344434 190028                     44 0 0 190028 totalTestEncountersViral 4371 190028 0 0 5544592f6324f7c1dd2345168bbdd72c6348be80 0 0 0 0 0  
3537 3537 20200725 DC 11717 157292   169009 97   28   9   9603 A+ 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 581   2020-07-24T00:00:00Z             169009 119013                     11 68 3681 169009 posNeg 3749 169009 0 0 7f79c851d969f60c0bb880724367fbfac13eea2c 0 0 0 0 0  
3538 3538 20200725 DE 14175 152747   166922 55   11       7961 A+ 7/24/2020 18:00 2020-07-24T18:00:00Z 07/24 14:00 579   2020-07-24T18:00:00Z       13179 509 70   166922                     10 -27 2623 166922 posNeg 2596 166922 1 0 5e14eceb2cf7ff36908b548bc0ea8fb3d4aa77e0 0 0 0 0 0  
3539 3539 20200725 FL 414511 2921866 2850 3336377 9035 24086           A 7/24/2020 23:59 2020-07-24T23:59:00Z 07/24 19:59 5894 24086 2020-07-24T23:59:00Z 4263177 519405 3728507 414511 5894     3340929       353026 18780 334221         12 12199 47542 3339227 posNeg 59741 3336377 126 511 835924193f20e464e440e93b2e1f3898ef0484d8 0 0 0 0 0  
3541 3541 20200725 GU 337 19695   20032 1           244 B 7/24/2020 20:40 2020-07-24T20:40:00Z 07/24 16:40 5   2020-07-24T20:40:00Z 19791     329       20024 145 2                 66 0 563 20032 posNeg 563 20032 0 0 94e2009444fc51b33bc5c361229d1c18cfa96fd5 0 0 0 0 0  
3542 3542 20200725 HI 1549 111241   112790 29 156         1148 D 7/24/2020 18:00 2020-07-24T18:00:00Z 07/24 14:00 26 156 2020-07-24T18:00:00Z 138354             112790                     15 59 1440 112790 posNeg 1499 112790 0 1 1b3c1b47b81810bde90d944d2a7f5a5e9035c388 0 0 0 0 0  
3544 3544 20200725 ID 17264 146176   162384 204 709 45 210     5251 A 7/24/2020 19:00 2020-07-24T19:00:00Z 07/24 15:00 144 709 2020-07-24T19:00:00Z 162384     16208 123 21                         16 528 2719 163440 posNeg 3221 163440 6 12 4d5f3045cfd3e513b771e5fb547091e1dc0d27c9 0 0 0 0 0  
3546 3546 20200725 IN 61520 628754   690274 824 8180 281 1736 63   43535 A+ 7/24/2020 23:59 2020-07-24T23:59:00Z 07/24 19:59 2895 8180 2020-07-24T23:59:00Z         2698 197   690274                     18 922 10603 690274 posNeg 11525 690274 11 52 d52a6d3a521896092d63bb33d9d41f2551e19640 0 0 0 0 0  
3547 3547 20200725 KS 25109 252858   277967 315 1596 98 459 24 166 1077 A+ 7/24/2020 10:00 2020-07-24T10:00:00Z 07/24 06:00 326 1596 2020-07-24T10:00:00Z               277967                     20 0 0 277967 posNeg 0 277967 0 0 919110885ee3dbeb12dfea357aaa8684fbababc0 0 0 0 0 0  
3549 3549 20200725 LA 103734 1095992   1199726 1600       197   61456 A 7/24/2020 13:00 2020-07-24T13:00:00Z 07/24 09:00 3715   2020-07-24T13:00:00Z       103734 3603 112   1199726                     22 0 0 1199726 posNeg 0 1199726 0 0 2f002f9eff3a422f6323e0ce0c033be50ac0c790 0 0 0 0 0  
3552 3552 20200725 ME 3790 149583   153373 11 379 8   2   3281 A+ 7/24/2020 23:59 2020-07-24T23:59:00Z 07/24 19:59 119 379 2020-07-24T23:59:00Z 152970 4715 148061 3387 118 1     8660 401 8249               23 33 2720 153373 posNeg 2753 153373 1 1 0455a284cb6a6f2052f753b2eecb9fbb24b508f1 0 0 0 0 0  
3553 3553 20200725 MI 85072 1529574   1614646 751   215   113   55162 A+ 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 6400   2020-07-24T00:00:00Z 1637017 107443 1529574 76541 6151 249     204810                   26 0 0 1614646 posNeg 0 1614646 0 0 1197f10d27a03de15068dfad82659e4de18050fe 0 0 0 0 0  
3554 3554 20200725 MN 50291 890405   940696 287 4889 115 1440     43625 A 7/24/2020 17:00 2020-07-24T17:00:00Z 07/24 13:00 1611 4889 2020-07-24T17:00:00Z       50291 1571 40 940696                       27 803 17017 940696 posNeg 17820 940696 5 37 0e9acde367fdb73988d494fa5f9e4c90596486f4 0 0 0 0 0  
3557 3557 20200725 MS 51097 370789   421886 1172 3982 295   159   30315 A+ 7/24/2020 19:00 2020-07-24T19:00:00Z 07/24 15:00 1480 3982 2020-07-24T19:00:00Z 421233     50444 1443 37     15740 95                 28 1434 8972 421886 posNeg 10406 421886 17 59 afee108e77d1cba23769b6e272c61b388cec5a2b 0 0 0 0 0  
3561 3561 20200725 NE 24174 228431   252605 122 1548         17999 A 7/24/2020 20:05 2020-07-24T20:05:00Z 07/24 16:05 316 1548 2020-07-24T20:05:00Z       24174       252881                     31 356 3175 252605 posNeg 3531 252605 0 0 666dbf6e9330572fb0550781f26df08db088578f 0 0 0 0 0  
3564 3564 20200725 NM 18475 486702   505177 161 2525         7156 B 7/24/2020 17:30 2020-07-24T17:30:00Z 07/24 13:30 601 2525 2020-07-24T17:30:00Z 505177     18475                             35 312 7880 505177 posNeg 8192 505177 5 25 cc674e3adb106bfe6ddcc5596d4bf3ed5143a987 0 0 0 0 0  
3566 3566 20200725 NY 411200 5105111   5516311 646 89995 149   94   72632 A 7/24/2020 23:59 2020-07-24T23:59:00Z 07/24 19:59 25103 89995 2020-07-24T23:59:00Z       411200     5516311                       36 750 70716 5516311 posNeg 71466 5516311 13 0 6d8098eafbb6e30ac39d99d4e29d4009c41e9cb1 0 0 0 0 0  
3572 3572 20200725 RI 18224 171804   340063 66 2146 6   5   1769 A+ 7/24/2020 12:00 2020-07-24T12:00:00Z 07/24 08:00 1002 2146 2020-07-24T12:00:00Z 329556 26593 302963 18224     340063 190028                     44 0 0 190028 totalTestEncountersViral 5825 190028 0 0 3d1406a4d6d8aa85bdc48d68b7eef0a123bcd54e 0 0 0 0 0  
3573 3573 20200725 SC 80008 558482   638490 1668 4827     263   29378 A+ 7/24/2020 23:59 2020-07-24T23:59:00Z 07/24 19:59 1465 4827 2020-07-24T23:59:00Z 638156 100090 538066 79674 1412 53     50741 3105 47636               45 1401 7717 638490 posNeg 9118 638490 80 0 43c13abc968471c1bf2ca8eeda5e7c1cfc8812b5 0 0 0 0 0  
3574 3574 20200725 SD 8305 97608   105913 46 798         7307 B 7/24/2020 18:00 2020-07-24T18:00:00Z 07/24 14:00 122 798 2020-07-24T18:00:00Z               105913                     46 105 2318 105913 posNeg 2423 105913 0 2 ab645705001466fd82d1e7c574134373d6074418 0 0 0 0 0  
3578 3578 20200725 VA 83609 926834 416 1007314 1201 12001 266   138   10800 A+ 7/24/2020 17:00 2020-07-24T17:00:00Z 07/24 13:00 2075 12001 2020-07-24T17:00:00Z   99636   80480 1972 103 1007314                       51 1245 18899 1010859 posNeg 20126 1010443 8 175 3bba1f5c5d6062f51abeb3f9ce164331f3f2193b 0 0 0 0 0  
3579 3579 20200725 VI 352 7901 20 8253             236 C 7/24/2020 20:42 2020-07-24T20:42:00Z 07/24 16:42 7   2020-07-24T20:42:00Z 8273       7                           78 16 401 8273 posNeg 417 8253 0 0 cb125629d059e158fe6c2ed8efed375037ec0247 0 0 0 0 0  
3581 3581 20200725 WA 55452 957827   1013279 407 5301     52     B 7/24/2020 02:59 2020-07-24T02:59:00Z 07/23 22:59 1495 5301 2020-07-24T02:59:00Z       55452 1495   1013279 883982                     53 482 9087 1013279 posNeg 9569 1013279 13 25 68c3bc2c9df3f8bf11a1528f87afcf8661fbffe6 0 0 0 0 0  
3585 3585 20200724 AK 2748 197824   200572 37       1   800 A 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 19   2020-07-24T00:00:00Z 200572     2748 19                           2 64 10999 200572 posNeg 11063 200572 0 0 4b533a1d5596e7346c9a537ce6123a6a87d06c71 0 0 0 0 0  
3586 3586 20200724 AL 76005 552979   627344 1536 9157   1058   565 32510 B 7/24/2020 11:00 2020-07-24T11:00:00Z 07/24 07:00 1438 9157 2020-07-24T11:00:00Z 627344     74365 1395 43                         1 1793 7664 628984 posNeg 9333 628984 41 162 f246683a45b4e9032b6fc9fa8a45e87014a15f86 0 0 0 0 0  
3587 3587 20200724 AR 37249 424215   461464 497 2361     109 329 29827 A+ 7/24/2020 14:46 2020-07-24T14:46:00Z 07/24 10:46 394 2361 2020-07-24T14:46:00Z 461464     37249                             5 990 13994 461464 posNeg 15997 461464 8 0 0c8f694dd503d6875787ffc597776f40194c23c6 0 0 0 0 0  
3589 3589 20200724 AZ 156301 680516   836817 2844 7461 837   575   20171 A+ 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 3142 7461 2020-07-24T00:00:00Z       137710 2431 152   836817 217015                   4 3357 10747 836817 posNeg 14104 836817 79 225 cdb2db4e20dfd8c9176262141e66da915a5ab93f 0 0 0 0 0  
3590 3590 20200724 CA 435334 6480542   6915876 8820   2284         B 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 8186   2020-07-24T00:00:00Z 6915876     435334                             6 9718 127854 6915876 posNeg 137572 6915876 159 0 182a2a25c85806d87b563fb4262c16528f00862a 0 0 0 0 0  
3591 3591 20200724 CO 42314 428563   594731 356 6149         5122 A 7/24/2020 01:59 2020-07-24T01:59:00Z 07/23 21:59 1645 6149 2020-07-24T01:59:00Z       39163     594731 467726 130158 8889 121269               8 616 4850 470877 totalTestEncountersViral 9180 470877 2 16 946d9c6b23263f0ca668f91ad7298d7822e3682e 0 0 0 0 0  
3596 3596 20200724 GA 161401 1221043   1382444 3135 16752   3119       A 7/24/2020 14:50 2020-07-24T14:50:00Z 07/24 10:50 3442 16752 2020-07-24T14:50:00Z 1382444 147195 1235249 161401         208597 12547                 13 4813 40693 1382444 posNeg 45506 1382444 82 399 5b93e8778e2f408676c3e67ce4c9fae482b3c473 0 0 0 0 0  
3597 3597 20200724 GU 337 19132   19469 0           244 B 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 5   2020-07-24T00:00:00Z 19791     329       19461 145 2                 66 5 0 19469 posNeg 5 19469 0 0 4621fa8c691f5234281073168f6f5050857b4583 0 0 0 0 0  
3599 3599 20200724 IA 41271 400602   441873 230   72   27   29216 A+ 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 823   2020-07-24T00:00:00Z       41271       443499       38137 2673 35425         19 637 4950 441873 posNeg 5587 441873 5 0 eba01a22ea8e39c7b433f1373683d34e135e6422 0 0 0 0 0  
3601 3601 20200724 IL 169699 2264066   2433765 1471   325   115     A 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 7577   2020-07-24T00:00:00Z 2432523     168457 7385 192                         17 1599 42798 2433765 posNeg 44397 2433765 17 0 22f5873e4acbac27b75b42f8e37cd721ecfef33f 0 0 0 0 0  
3603 3603 20200724 KS 25109 252858   277967   1596 98 459 24 166 1077 A+ 7/24/2020 10:00 2020-07-24T10:00:00Z 07/24 06:00 326 1596 2020-07-24T10:00:00Z               277967                     20 1005 8276 277967 posNeg 9281 277967 18 51 b2b526b5de3b0336612d867ab3dc4078c23ec2c3 0 0 0 0 0  
3604 3604 20200724 KY 25931 507545   532160 618 3248 130 1125     7396 B 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 691 3248 2020-07-24T00:00:00Z 532160     24615 687 4     41959                   21 784 7897 533476 posNeg 8630 533476 7 327 0c85a9b18a603591695dcf33c9834ccda64e5cfa 0 0 0 0 0  
3605 3605 20200724 LA 103734 1095992   1199726 1600       197   61456 A 7/24/2020 13:00 2020-07-24T13:00:00Z 07/24 09:00 3715   2020-07-24T13:00:00Z       103734 3603 112   1199726                     22 2084 22774 1199726 posNeg 24858 1199726 29 0 679699e476c6b909875c1a95bee6ce1dbd1c9084 0 0 0 0 0  
3607 3607 20200724 MD 81766 722584   804350 533 12119 143       5434 A 7/24/2020 10:00 2020-07-24T10:00:00Z 07/24 06:00 3422 12119 2020-07-24T10:00:00Z 1034901 96121   81766 3293 129   804350                     24 930 14379 804350 posNeg 15309 804350 13 82 181c9da20c6daeb8d6dc591da0f682eaa04448a6 0 0 0 0 0  
3609 3609 20200724 MI 85072 1529574   1614646 751   215   113   55162 A+ 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 6400   2020-07-24T00:00:00Z 1637017 107443 1529574 76541 6151 249     204810                   26 641 27281 1614646 posNeg 27922 1614646 5 0 02e7b58e70d5bdf4e809d6fbd5a9ec5fe2a19ae4 0 0 0 0 0  
3611 3611 20200724 MO 39352 573263   612615 1057       159     B 7/24/2020 15:00 2020-07-24T15:00:00Z 07/24 11:00 1178   2020-07-24T15:00:00Z 784770 43687 739825 39352       612615       56784 1935 54849         29 1652 7679 612615 posNeg 9331 612615 -1 0 834e84f627a181623e0a81c6dd768b972d394c35 0 0 0 0 0  
3612 3612 20200724 MP 38 11300   11338   4         29 D 7/24/2020 02:47 2020-07-24T02:47:00Z 07/23 22:47 2 4 2020-07-24T02:47:00Z 12745     38       11338                     69 0 0 11338 posNeg 0 11338 0 0 6ea47bcefbe09561ef3dce58616e13ceeb661eb4 0 0 0 0 0  
3614 3614 20200724 MT 3039 146161   149200 56 191         1815 C 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 46 191 2020-07-24T00:00:00Z 149200     3039                             30 129 2853 149200 posNeg 2982 149200 3 8 705cad8ddb5e6c0e7fd0fbcb3ccb6f868cc9a475 0 0 0 0 0  
3615 3615 20200724 NC 108995 1441302   1550297 1182   363       78707 A+ 7/24/2020 11:45 2020-07-24T11:45:00Z 07/24 07:45 1746   2020-07-24T11:45:00Z 1550297     108995 1746                           37 2102 24520 1550297 posNeg 26622 1550297 20 0 a88c510595f11a5f25562ae01ad17f906865ab76 0 0 0 0 0  
3616 3616 20200724 ND 5608 137094   272538 37 325         4545 C 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 88 325 2020-07-24T00:00:00Z 279953     5608 84 4 272538 139886 6604 240 6364               38 122 1771 142702 totalTestEncountersViral 4305 142702 0 3 788bcf18d10e59c1e70ecd5d136bb88c90200abc 0 0 0 0 0  
3619 3619 20200724 NJ 178345 1709299   1887644 800 21184 138   62   32001 A+ 7/24/2020 13:00 2020-07-24T13:00:00Z 07/24 09:00 15625 21184 2020-07-24T13:00:00Z 1887644     178345 13845 1780                         34 458 27548 1887644 posNeg 28006 1887644 35 0 cda6e781823d2cb55e255ef4cb82c5a8f84ed1c8 0 0 0 0 0  
3621 3621 20200724 NV 40885 380986   421871 1160   315   165   994 A+ 7/24/2020 13:00 2020-07-24T13:00:00Z 07/24 09:00 722   2020-07-24T13:00:00Z 537720     40885       419810                     32 966 6769 421871 posNeg 7735 421871 13 0 c58bf703b829115bdf9b8e9c12b66adb2118dc04 0 0 0 0 0  
3623 3623 20200724 OH 81746 1185882   1267628 1085 10072 354 2419 169   56823 B 7/24/2020 14:00 2020-07-24T14:00:00Z 07/24 10:00 3297 10072 2020-07-24T14:00:00Z 1263191     77309 3039 258                         39 1560 21042 1267628 posNeg 22602 1267628 41 104 4bd51ee8884f8497200194855c3843701537ae2c 0 0 0 0 0  
3624 3624 20200724 OK 29116 493926   523042 628 2687 260       23277 A+ 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 484 2687 2020-07-24T00:00:00Z 527895 32927 493926 29116         55185 1854                 40 1147 8720 523042 posNeg 9867 523042 7 91 82ed3b291c20ad3a46e18af2442a2d75cbb66ce3 0 0 0 0 0  
3625 3625 20200724 OR 16104 350463   366567 233 1474 58   30   3541 A+ 7/24/2020 15:01 2020-07-24T15:01:00Z 07/24 11:01 282 1474 2020-07-24T15:01:00Z     350463 15273       365736                     41 391 7685 366567 posNeg 8076 366567 9 9 8dd4f43623476414e00f39efdd6cd409f2a5d39b 0 0 0 0 0  
3626 3626 20200724 PA 105571 999377   1104948 736       96   79178 A+ 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 7101   2020-07-24T00:00:00Z       102602       1101979                     42 1213 18118 1104948 posNeg 19331 1104948 22 0 d7e70205bcab2da7a139a948f69c8611c2542bef 0 0 0 0 0  
3627 3627 20200724 PR 13967 305972   319939 460   58   31     B 7/24/2020 06:30 2020-07-24T06:30:00Z 07/24 02:30 191   2020-07-24T06:30:00Z 310546 7002 303412 4794 90 101       9173                 72 494 0 319939 posNeg 494 319939 3 0 745ceeadc9fadded951d21cfca8e52fb62fd7668 0 0 0 0 0  
3628 3628 20200724 RI 18224 171804   334238 66 2146 6   5   1769 A+ 7/24/2020 12:00 2020-07-24T12:00:00Z 07/24 08:00 1002 2146 2020-07-24T12:00:00Z 329556 26593 302963 18224     334238 190028                     44 76 613 190028 totalTestEncountersViral 4166 190028 1 9 605d380bfc3853c9398445f6a95d2eddf57566a9 0 0 0 0 0  
3631 3631 20200724 TN 89078 1233535   1322613 1460 4120         52983 A 7/24/2020 15:00 2020-07-24T15:00:00Z 07/24 11:00 938 4120 2020-07-24T15:00:00Z 1321707 104274 1217433 88172 904 34                         47 2091 24537 1322613 posNeg 26628 1322613 13 104 85c4c2a95d8b50e478c9bcb76dd67f5a5f858a9c 0 0 0 0 0  
3632 3632 20200724 TX 369826 2862105   3231931 10893   3281       212216 A 7/24/2020 16:45 2020-07-24T16:45:00Z 07/24 12:45 4717   2020-07-24T16:45:00Z 3231931     369826         233139 10565                 48 8701 58574 3231931 posNeg 67275 3231931 196 0 ee9797bbbc8396e5aff43730900a2f6d42aba41c 0 0 0 0 0  
3633 3633 20200724 UT 36962 457109   494071 250 2188 97 574   237 23715 A+ 7/24/2020 10:19 2020-07-24T10:19:00Z 07/24 06:19 273 2188 2020-07-24T10:19:00Z 585839     36962       494071             933 404 1115 427 49 863 7786 494071 posNeg 8649 494071 6 38 176c5c563797b8db4f4a9076bc558637bf073889 0 0 0 0 0  
3636 3636 20200724 VT 1385 86307   87692 12           1177 B 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 56   2020-07-24T00:00:00Z       1385 56     87692                     50 8 1102 87692 posNeg 1110 87692 0 0 92a589281ed72e82bd94e0643637254faca6711c 0 0 0 0 0  
3638 3638 20200724 WI 50727 795280 177 846007 312 4327 60 861     36333 A+ 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 885 4327 2020-07-24T00:00:00Z       46917 878 7   842197                     55 1058 16438 846184 posNeg 17496 846007 0 54 3b8455b344d260284bda28dd0b0c23a98f2acdbc 0 0 0 0 0  
3639 3639 20200724 WV 5695 247478   253173 76   37   15   4013 B 7/24/2020 17:00 2020-07-24T17:00:00Z 07/24 13:00 103   2020-07-24T17:00:00Z 253040     5562         13490                   54 145 1956 253173 posNeg 2101 253173 0 0 933894f24939b033d5baffc23bb9892e79feae96 0 0 0 0 0  
3640 3640 20200724 WY 2405 45823   48228 14 155         1857 B 7/24/2020 18:18 2020-07-24T18:18:00Z 07/24 14:18 25 155 2020-07-24T18:18:00Z 67700 2031 65669 1972       47745                     56 59 0 48228 posNeg 59 48228 0 2 98a877551a9718cea919d9b543e2053eeda7304f 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
);