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

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, probableCases, totalTestResultsSource, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, lastUpdateEt, dateModified, checkTimeEt, hospitalizedDischarged, dateChecked, positiveTestsViral, negativeTestsViral, deathConfirmed, deathProbable, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, deathIncrease, hospitalizedIncrease, dateModified (date), dateChecked (date)

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
11260 11260 20200812 AS 0   1396   totalTestsViral 1396               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 0 1396   0.0 0.0 8b455d9717f440041539f9af6f012348d70d87a7 0 0 0 0 0  
11316 11316 20200811 AS 0   1396   totalTestsViral 1396               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 0 1396   0.0 0.0 acbd5d31cc0f32bc0d66f77b2334b57f235b244a 0 0 0 0 0  
11372 11372 20200810 AS 0   1396   totalTestsViral 1396               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 0 1396   0.0 0.0 da8614f5a9f1e76b469d39917d5d69fb80602a3d 0 0 0 0 0  
11428 11428 20200809 AS 0   1396   totalTestsViral 1396               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 0 1396   0.0 0.0 5877494b091c17093bbf40f32b47ab54ec6f9429 0 0 0 0 0  
11484 11484 20200808 AS 0   1396   totalTestsViral 1396               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 0 1396   0.0 0.0 35253ca21eeb117e241c27917d96762e7b70b6fb 0 0 0 0 0  
11540 11540 20200807 AS 0   1396   totalTestsViral 1396               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 0 1396   0.0 0.0 506dcba1452f0ad430c684a9fa56ae2bfd3a8e76 0 0 0 0 0  
11596 11596 20200806 AS 0   1396   totalTestsViral 1396               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 0 1396   0.0 0.0 5705aff1fdae45dd9b48411c6a0c133da4510d12 0 0 0 0 0  
11652 11652 20200805 AS 0   1396   totalTestsViral 1396               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 129 1396   0.0 0.0 17f518c0cd06f13d2d5a0e3973c0cd7dca35374d 0 0 0 0 0  
12221 12221 20200726 GU 337 8 19695   posNeg 20032 1           244 7/24/2020 20:40 2020-07-24T20:40:00Z 07/24 16:40 5     2020-07-24T20:40:00Z 19791     329         145 2                 66 0 0 20032 0 20032   0.0 0.0 769e79f5cab4e1676b9a62f8fa041c37dfa75420 0 0 0 0 0  
12227 12227 20200726 KS 25109   252858   posNeg 277967 315 1596 98 459 24 166   7/24/2020 10:00 2020-07-24T10:00:00Z 07/24 06:00 326 1596 1077 2020-07-24T10:00:00Z               277967                     20 0 0 277967 0 277967   0.0 0.0 1f75cfe9e2d1cbd0b8cb8c4ba2560b9c0c5651ee 0 0 0 0 0  
12237 12237 20200726 MS 52304 665 370789   posNeg 423093 1172 3982 295   159   30315 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                   28 1207 0 423093 1207 423093   15.0 0.0 a460f3ed7a600b471e61907759744d1fff0cec46 0 0 0 0 0  
12252 12252 20200726 RI 18224   171804   totalTestEncountersViral 344434 66 2146 6   5     7/24/2020 12:00 2020-07-24T12:00:00Z 07/24 08:00 1002 2146 1769 2020-07-24T12:00:00Z 329556 26593 302963       344434 190028                     44 0 0 190028 4371 190028   0.0 0.0 63aed51fbaca8556a6ad97869aad00efa4272b35 0 0 0 0 0  
12273 12273 20200725 DC 11717       totalTestEncountersViral 169009 97   28   9   9603 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 581     2020-07-24T00:00:00Z             169009 119013                     11 68 0 11717 3749 11717   0.0 0.0 0c45b28d0e9f0c9cdeaeb754c06d4ed199668e19 0 0 0 0 0  
12274 12274 20200725 DE 14175 996 152747   totalTestEncountersViral 232034 55   11       7961 7/24/2020 18:00 2020-07-24T18:00:00Z 07/24 14:00 579     2020-07-24T18:00:00Z   17693   13179 509 70 232034 166922                     10 -27 2623 166922 3115 166922   1.0 0.0 f7a1197d787d2255874b72741917ae463f3a6237 0 0 0 0 0  
12275 12275 20200725 FL 408114   2921866 2850 totalTestEncountersViral 4023711 9035 24086           7/24/2020 23:59 2020-07-24T23:59:00Z 07/24 19:59 5894 24086   2020-07-24T23:59:00Z 4263177 519405 3728507   5894   4023711 3340929       353026 18780 334221         12 12045 47542 3332830 102503 3329980   126.0 511.0 91f02da56e12eae52db363e386b848d2bc71514c 0 0 0 0 0  
12277 12277 20200725 GU 337 8 19695   posNeg 20032 1           244 7/24/2020 20:40 2020-07-24T20:40:00Z 07/24 16:40 5     2020-07-24T20:40:00Z 19791     329         145 2                 66 0 563 20032 563 20032   0.0 0.0 d374da7252fb5244ea68b55e06c0208383f5f31f 0 0 0 0 0  
12278 12278 20200725 HI 1549   111241   totalTestEncountersViral 137103 29 156         1148 7/24/2020 18:00 2020-07-24T18:00:00Z 07/24 14:00 26 156   2020-07-24T18:00:00Z 138354 1502     26   137103 112790                     15 59 1440 112790 1951 112790   0.0 1.0 8c3f45ff745a7138fadbc392a2d2a01da09e43e1 0 0 0 0 0  
12280 12280 20200725 ID 17264 1056 146176   totalTestsPeopleViral 162384 204 709 45 210     5251 7/24/2020 19:00 2020-07-24T19:00:00Z 07/24 15:00 144 709   2020-07-24T19:00:00Z       16208 123 21   162384                     16 528 2719 163440 3221 163440   6.0 12.0 f4b0128c7431d6924060d797e3546f8083e97b46 0 0 0 0 0  
12282 12282 20200725 IN 61520   628754   totalTestsViral 917369 824 8180 281 1736 63     7/24/2020 23:59 2020-07-24T23:59:00Z 07/24 19:59 2895 8180 43535 2020-07-24T23:59:00Z 917369 66239     2698 197   690274                     18 922 10603 690274 17350 690274   11.0 52.0 129b80bbb4566c177aa5ac8f0638d05c9909dfdd 0 0 0 0 0  
12283 12283 20200725 KS 25109   252858   posNeg 277967 315 1596 98 459 24 166   7/24/2020 10:00 2020-07-24T10:00:00Z 07/24 06:00 326 1596 1077 2020-07-24T10:00:00Z               277967                     20 0 0 277967 0 277967   0.0 0.0 f80f76deb1665694ef36cafd4173c36357abb77c 0 0 0 0 0  
12285 12285 20200725 LA 103734   1095992   posNeg 1199726 1600       197   61456 7/24/2020 13:00 2020-07-24T13:00:00Z 07/24 09:00 3715     2020-07-24T13:00:00Z 1199726     103734 3603 112                         22 0 0 1199726 0 1199726   0.0 0.0 87bac44d9548aa6d005645583b30db2db1dbb4ad 0 0 0 0 0  
12288 12288 20200725 ME 3790 403 149583   posNeg 153373 11 379 8   2   3281 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 2753 153373   1.0 1.0 1ebfc5c33ec4d47b0572e8207d385890b1222178 0 0 0 0 0  
12289 12289 20200725 MI 85072 8531 1529574   posNeg 1614646 751   215   113   55162 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 0 1614646   0.0 0.0 89f8ae277ca7a1760d9099deb54766c40af3d7c6 0 0 0 0 0  
12290 12290 20200725 MN 50291   890405   totalTestEncountersViral 940696 287 4889 115 1440     43625 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 17820 940696   5.0 37.0 b42a185ca7a91b753fc57f8b98f333a7c5596872 0 0 0 0 0  
12293 12293 20200725 MS 51097 653 370789   posNeg 421886 1172 3982 295   159   30315 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                   28 1434 8972 421886 10406 421886   17.0 59.0 0decaba2670d5b4eb34b27ab5e512b897efa78d9 0 0 0 0 0  
12297 12297 20200725 NE 24174   228431   totalTestsViral 321996 122 1548         17999 7/24/2020 20:05 2020-07-24T20:05:00Z 07/24 16:05 316 1548   2020-07-24T20:05:00Z 321996 29657 291539         252881                     31 356 3175 252605 5844 252605   0.0 0.0 de19f3cee67b0f9fd6c6d3dedca764271826ca66 0 0 0 0 0  
12302 12302 20200725 NY 411200       totalTestEncountersViral 5516311 646 89995 149   94     7/24/2020 23:59 2020-07-24T23:59:00Z 07/24 19:59 25103 89995 72632 2020-07-24T23:59:00Z             5516311                       36 750 0 411200 71466 411200   13.0 0.0 70ce7372e1cb7b44b5391a5b138205c1c746afd6 0 0 0 0 0  
12305 12305 20200725 OR 16104   350463   totalTestsViral 577308 233 1474 58   30   3541 7/24/2020 15:01 2020-07-24T15:01:00Z 07/24 11:01 282 1474   2020-07-24T15:01:00Z 577308 29275 548033         365736                     41 391 7685 366567 10461 366567   9.0 9.0 038ae192fc9ad268c1e807c446199dfee48b01c1 0 0 0 0 0  
12308 12308 20200725 RI 18224   171804   totalTestEncountersViral 340063 66 2146 6   5     7/24/2020 12:00 2020-07-24T12:00:00Z 07/24 08:00 1002 2146 1769 2020-07-24T12:00:00Z 329556 26593 302963       340063 190028                     44 0 0 190028 5825 190028   0.0 0.0 61cb31019f6af34c6401128a3948aee800f41078 0 0 0 0 0  
12309 12309 20200725 SC 80008   558482   posNeg 638490 1668 4827     263   29378 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 9118 638490   80.0 0.0 cede37b2e66dd44ba15ebf68af9a52c515de203b 0 0 0 0 0  
12310 12310 20200725 SD 8305   97608   totalTestsPeopleViral 105913 46 798         7307 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 2423 105913   0.0 2.0 a73d771435e097401c37982b35adb8bddb670a60 0 0 0 0 0  
12314 12314 20200725 VA 83609 3129   416 totalTestEncountersViral 1007314 1201 7570 266   138     7/24/2020 17:00 2020-07-24T17:00:00Z 07/24 13:00 2075 7570 10800 2020-07-24T17:00:00Z   99636   80480 1972 103 1007314   107085 6550             859 605 51 1245 0 84025 20126 83609   8.0 55.0 a3c3dec0ff43cfe83c3277d1675a5cd6c7f36f02 0 0 0 0 0  
12315 12315 20200725 VI 352   7901 20 posNeg 8253             236 7/24/2020 20:42 2020-07-24T20:42:00Z 07/24 16:42 7     2020-07-24T20:42:00Z         7     8273                     78 16 401 8273 417 8253   0.0 0.0 f3fa3509ea5cd1302a9f57f1976a54365dade72c 0 0 0 0 0  
12317 12317 20200725 WA 54716 108     totalTestEncountersViral 1013279 520 5301     52     7/24/2020 02:59 2020-07-24T02:59:00Z 07/23 22:59 1495 5301   2020-07-24T02:59:00Z       54608 1495   1013279 883982                     53 907 0 54716 9569 54716   13.0 25.0 cdae5ac0b1fdcc457e4c0db063cfeb518d437d34 0 0 0 0 0  
12321 12321 20200724 AK 2260       totalTestsViral 200572 37 126     1   800 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 19 126   2020-07-24T00:00:00Z 200572       19                           2 57 0 2260 11063 2260   0.0 2.0 1b935d2d33b0368ff00fd44b4250b0f998f84508 0 0 0 0 0  
12322 12322 20200724 AL 76005 1640 552979   totalTestsPeopleViral 627344 1536 9157   1058   565 32510 7/24/2020 11:00 2020-07-24T11:00:00Z 07/24 07:00 1438 9157   2020-07-24T11:00:00Z       74365 1395 43   627344                     1 1793 7664 628984 9333 628984   41.0 162.0 ce20e600f4a71b5bfeabb975099709a1115fb732 0 0 0 0 0  
12323 12323 20200724 AR 37249   424215   totalTestsViral 461464 497 2361     109 329 29827 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 15997 461464   8.0 0.0 a32a7cf8f9d6c1807e56c52f61fb9fb715baaea3 0 0 0 0 0  
12325 12325 20200724 AZ 156301 813 680516   totalTestsViral 1224884 2844 7461 837   575     7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 3142 7461 20171 2020-07-24T00:00:00Z 1224884     137710 2431 152   836817 217015                   4 3357 10747 836817 16189 836817   79.0 225.0 f7e8a1311b6ccd33a1261a319fcd1b2234432393 0 0 0 0 0  
12326 12326 20200724 CA 435334       totalTestsViral 6915876 8820   2284         7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 8186     2020-07-24T00:00:00Z 6915876     435334                             6 9718 0 435334 137572 435334   159.0 0.0 6609d8a6870d327546175a168c796036cafa85d6 0 0 0 0 0  
12332 12332 20200724 GA 161401       totalTestsViral 1400793 3135 16752   3119       7/24/2020 14:50 2020-07-24T14:50:00Z 07/24 10:50 3442 16752   2020-07-24T14:50:00Z 1400793 147362   161401         208597 12547                 13 4813 0 161401 46886 161401   82.0 399.0 3e51973df4438fbfcbee0a32ffef91ce079d421f 0 0 0 0 0  
12333 12333 20200724 GU 337 8 19132   posNeg 19469 0           244 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 5     2020-07-24T00:00:00Z 19791     329         145 2                 66 5 0 19469 5 19469   0.0 0.0 cc7606d99fef86dc2f7677e7ebac0e8d558f4ae2 0 0 0 0 0  
12335 12335 20200724 IA 41271   400602   posNeg 441873 230   72   27   29216 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 5587 441873   5.0 0.0 85b09216037916a4d4cb236b556f245ca74dfdd2 0 0 0 0 0  
12337 12337 20200724 IL 169699 1242 2264066   posNeg 2433765 1471   325   115     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 44397 2433765   17.0 0.0 faffddb0f34d002bc9313962cf42b5ea10dce8a5 0 0 0 0 0  
12339 12339 20200724 KS 25109   252858   posNeg 277967   1596 98 459 24 166   7/24/2020 10:00 2020-07-24T10:00:00Z 07/24 06:00 326 1596 1077 2020-07-24T10:00:00Z               277967                     20 1005 8276 277967 9281 277967   18.0 51.0 566abe985673667a0923d45c430ab1eb9a8d5a1e 0 0 0 0 0  
12340 12340 20200724 KY 25931 1316     totalTestsViral 532160 618 3248 130 1125     7396 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 0 25931 8630 25931   7.0 327.0 730c1dbdfffd54e2c5295e6ebcaa68fa7c9185c9 0 0 0 0 0  
12341 12341 20200724 LA 103734   1095992   posNeg 1199726 1600       197   61456 7/24/2020 13:00 2020-07-24T13:00:00Z 07/24 09:00 3715     2020-07-24T13:00:00Z 1199726     103734 3603 112                         22 2084 22774 1199726 24858 1199726   29.0 0.0 addeef02897a42e672c15857b62fb2538d5673dd 0 0 0 0 0  
12343 12343 20200724 MD 81766   722584   totalTestsViral 1034901 533 12119 143       5434 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 24220 804350   13.0 82.0 86985760662facf24e9ea5f1c6187a9aa8f1280a 0 0 0 0 0  
12345 12345 20200724 MI 85072 8531 1529574   posNeg 1614646 751   215   113   55162 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 27922 1614646   5.0 0.0 a40b46fff2d12717038bce8b9a6ed19ab7210818 0 0 0 0 0  
12347 12347 20200724 MO 39352   573263   totalTestsViral 784770 1057       159     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 15154 612615   -1.0 0.0 a1e50ec33e8f8b52aecf81c1a052e65f898074bf 0 0 0 0 0  
12348 12348 20200724 MP 38   11300   posNeg 11338   4         29 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 0 11338   0.0 0.0 12e3f7fa8bb4f84fd68099f4c9f70214271384b0 0 0 0 0 0  
12350 12350 20200724 MT 3039   146161   posNeg 149200 56 191         1815 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 46 191   2020-07-24T00:00:00Z 149200                                   30 129 2853 149200 2982 149200   3.0 8.0 9502f27e8412ac27ee26f2db76fa4104f224781f 0 0 0 0 0  
12351 12351 20200724 NC 108995   1441302   posNeg 1550297 1182   363         7/24/2020 11:45 2020-07-24T11:45:00Z 07/24 07:45 1746   78707 2020-07-24T11:45:00Z 1550297     108995 1746                           37 2102 24520 1550297 26622 1550297   20.0 0.0 55989c58e6cbebb1e3e7e967e63119c811cdd1ed 0 0 0 0 0  
12352 12352 20200724 ND 5603 0 137094   totalTestEncountersViral 272538 37 325         4545 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 103 325   2020-07-24T00:00:00Z 279953     5603     272538 139886 6604 240 6364               38 122 1771 142697 4305 142697   2.0 3.0 8cee6799a2854f9a4d678654beaa74e54371dee9 0 0 0 0 0  
12355 12355 20200724 NJ 180315 1970 1709299   posNeg 1889614 800 21184 138   62     7/24/2020 13:00 2020-07-24T13:00:00Z 07/24 09:00 15616 21184 32001 2020-07-24T13:00:00Z 1887644     178345 13845 1771                         34 502 27548 1889614 28050 1889614   35.0 0.0 689b53d58956b8fe91fccff9fcfe6e46a64b0e7a 0 0 0 0 0  
12356 12356 20200724 NM 18475   486702   posNeg 505177 161 2525         7156 7/24/2020 17:30 2020-07-24T17:30:00Z 07/24 13:30 601 2525   2020-07-24T17:30:00Z 505177                                   35 312 7880 505177 8192 505177   5.0 25.0 28ed9b7206d64f743c52b6582058b8e4536b09a5 0 0 0 0 0  
12357 12357 20200724 NV 40885   380986   totalTestEncountersViral 589823 1160   315   165     7/24/2020 13:00 2020-07-24T13:00:00Z 07/24 09:00 722     2020-07-24T13:00:00Z 537720     40885     589823 419810                     32 966 6769 421871 10581 421871   13.0 0.0 ac6d3147d6ecd2a75a863886e074b783ae00bd0f 0 0 0 0 0  
12359 12359 20200724 OH 81746 4437     totalTestsViral 1356995 1085 10072 354 2419 169   56823 7/24/2020 14:00 2020-07-24T14:00:00Z 07/24 10:00 3297 10072   2020-07-24T14:00:00Z 1356995 89332   77309 3039 258                         39 1560 0 81746 24089 81746   41.0 104.0 1343580548de986785debbd3151fe52d650c7290 0 0 0 0 0  
12360 12360 20200724 OK 29116   493926   posNeg 523042 628 2687 260       23277 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 9867 523042   7.0 91.0 fd19d474ea08db8bf376f20077a8741cc870ac62 0 0 0 0 0  
12362 12362 20200724 PA 105571 2969 999377   totalTestEncountersViral 1407415 736       96   79178 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 7101     2020-07-24T00:00:00Z       102602     1407415 1101979                     42 1213 18118 1104948 27811 1104948   22.0 0.0 7ae0cee0996aa7714f7546aa2950507c86299195 0 0 0 0 0  
12363 12363 20200724 PR 4794   305972   posNeg 310766 460   58   31     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 220 0 310766 220 310766   3.0 0.0 77f41974a7cb8cb8d3af91662956fc6d3e500f8b 0 0 0 0 0  
12364 12364 20200724 RI 18224   171804   totalTestEncountersViral 334238 66 2146 6   5     7/24/2020 12:00 2020-07-24T12:00:00Z 07/24 08:00 1002 2146 1769 2020-07-24T12:00:00Z 329556 26593 302963       334238 190028                     44 76 613 190028 4166 190028   1.0 9.0 fd9e1dc9ecfefdbeb5c15dbfc49c6991016fd361 0 0 0 0 0  
12367 12367 20200724 TN 89078 906     totalTestsViral 1321707 1460 4120         52983 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 0 89078 26592 89078   13.0 104.0 b40e155d1816d6cf8357e055692dc0e35f9bd965 0 0 0 0 0  
12368 12368 20200724 TX 369826       totalTestsViral 4055305 10893   3281       212216 7/24/2020 16:45 2020-07-24T16:45:00Z 07/24 12:45 4717     2020-07-24T16:45:00Z 4055305 577854   369826         233139 10565             44448 8098 48 8701 0 369826 65759 369826   196.0 0.0 ea82b3d8cd002fbb804bc0c4be2e4c551f124205 0 0 0 0 0  
12369 12369 20200724 UT 36962   459400   totalTestsViral 594612 250 2188 97 574   237 23715 7/24/2020 10:19 2020-07-24T10:19:00Z 07/24 06:19 273 2188   2020-07-24T10:19:00Z 594612 41181 553431         496399             933 404 1115 427 49 863 5517 496362 7982 496362   6.0 38.0 c1b8b501af75e1fe0a03ecd38019acbccd9d3b15 0 0 0 0 0  
12372 12372 20200724 VT 1384 0 85177   totalTestsViral 109744 12           1177 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 56     2020-07-24T00:00:00Z 109744     1384 56     86561                     50 5 1064 86561 1614 86561   0.0 0.0 a7509b8a19d94d30ee98e2b063474c556fe4358d 0 0 0 0 0  
12374 12374 20200724 WI 50727 3810 795280 177 totalTestEncountersViral 1118188 312 4327 60 861     36333 7/24/2020 00:00 2020-07-24T00:00:00Z 07/23 20:00 885 4327   2020-07-24T00:00:00Z       46917 878 7 1118188 842197                     55 1058 16438 846184 23660 846007   0.0 54.0 32284c229b8a02cf1ee4e2049b48aef12ddd4404 0 0 0 0 0  
12375 12375 20200724 WV 5695 133 247478   posNeg 253173 76   37   15   4013 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 2101 253173   0.0 0.0 d1929b75e29595a721b72bb16f5f44abedb3b398 0 0 0 0 0  
12376 12376 20200724 WY 2405 433 45823   totalTestsViral 74829 14 155         1857 7/24/2020 18:18 2020-07-24T18:18:00Z 07/24 14:18 25 155   2020-07-24T18:18:00Z 74829 2256 72573 1972       47745                     56 58 0 48228 765 48228   0.0 2.0 9c3b36e1c537e7fab29aa80e5d763a5a953a47b5 0 0 0 0 0  
12383 12383 20200723 CO 42314 3151 428563   totalTestEncountersViral 594731 356 6149           7/24/2020 01:59 2020-07-24T01:59:00Z 07/23 21:59 1786 6149 5122 2020-07-24T01:59:00Z       39163 1450 336 594731 467726 130158 8889 121269               8 616 4850 470877 9180 470877   15.0 16.0 0d47f2b05238522cc6325f3efe23ce816edd110e 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
);