states_daily_4pm_et

Table actions

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

11,578 rows sorted by positiveIncrease

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
1148 1148 20200906 MP 58 13484   13542   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     58 2     13540                     69 0 0 13542 posNeg 0 13542 0 0 27b844b60ca92a40925110b9427cbf144ff71f17 0 0 0 0 0  
1180 1180 20200905 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 78615189f736f50add2170e1fb8468820dba264a 0 0 0 0 0  
1184 1184 20200905 CT 53365 1184293   1237658 58 11275         9049 B 9/3/2020 20:30 2020-09-03T20:30:00Z 09/03 16:30 4468 11275 2020-09-03T20:30:00Z 1235514     51221 3583 885                         9 0 0 1237658 posNeg 0 1237658 0 0 9b4609ad40b70405024dcda98d00feb702573920 0 0 0 0 0  
1195 1195 20200905 KS 45220 381985   427205 314 2415 101 661 36 211 1785 A+ 9/4/2020 10:00 2020-09-04T10:00:00Z 09/04 06:00 481 2415 2020-09-04T10:00:00Z               427205                     20 0 0 427205 posNeg 0 427205 0 0 522b631bace6f0d1224d5afb2e2846e55104ae0f 0 0 0 0 0  
1197 1197 20200905 LA 152369 1780275   1932644 808       96   134432 A 9/4/2020 13:00 2020-09-04T13:00:00Z 09/04 09:00 5035   2020-09-04T13:00:00Z       151473 4872 163   1931748                     22 0 0 1932644 posNeg 0 1932644 0 0 86e15cf7139495893aae50ed3c2eab9fc8587bad 0 0 0 0 0  
1236 1236 20200904 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 f60826de4e95b3f4a2a0f00c53e1bde01483b6c9 0 0 0 0 0  
1260 1260 20200904 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 0 0 13541 posNeg 0 13541 0 0 6a5775dfc03759ee10f326a446c010dc219d4e3b 0 0 0 0 0  
1292 1292 20200903 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 56dee75bc9943e7392a15213f148aadf8d45c564 0 0 0 0 0  
1307 1307 20200903 KS 43940 375307   419247 336 2361 94 649 35 210 1730 A+ 9/2/2020 10:00 2020-09-02T10:00:00Z 09/02 06:00 458 2361 2020-09-02T10:00:00Z               419247                     20 0 0 419247 posNeg 0 419247 0 0 3547179e1328a598ffafd493c32d36c7e7c5c031 0 0 0 0 0  
1316 1316 20200903 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 0 0 13541 posNeg 0 13541 0 0 6d3fbada05132b8f400b437dbc810b415fc98952 0 0 0 0 0  
1340 1340 20200903 VT 1637 139244   140881 3           1436 B 9/2/2020 23:39 2020-09-02T23:39:00Z 09/02 19:39 58   2020-09-02T23:39:00Z       1637 58     140881                     50 0 1785 140881 posNeg 1785 140881 0 0 678efd5c3bad50ae541c56626fd55c9728866619 0 0 0 0 0  
1348 1348 20200902 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 48ebb399ca7a84fe4e65df7be64d01c2adde9b27 0 0 0 0 0  
1372 1372 20200902 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 0 0 13541 posNeg 0 13541 0 0 a431b7eb0449131837e1789a13858652ace850cf 0 0 0 0 0  
1378 1378 20200902 NH 7297 203984   329116 8 715   221     6634 B 9/1/2020 09:00 2020-09-01T09:00:00Z 09/01 05:00 432 715 2020-09-01T09:00:00Z 329116     7297       211281 30385     29761             33 0 0 211281 posNeg 0 211281 0 0 3395348e8655ae62da6779299352168bc0f27eb1 0 0 0 0 0  
1404 1404 20200901 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 9cd47401a2852789f2ffe4df905e7afe7ba9b228 0 0 0 0 0  
1419 1419 20200901 KS 42612 370637   413249 211 2304 55 628 21 209 1673 A+ 8/31/2020 10:00 2020-08-31T10:00:00Z 08/31 06:00 446 2304 2020-08-31T10:00:00Z               413249                     20 0 0 413249 posNeg 0 413249 0 0 d41b9e59e3d58be3c25670467ad605537a59f08d 0 0 0 0 0  
1460 1460 20200831 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 cc53fe6dbb4b1014666071c8137e9ff61190de7f 0 0 0 0 0  
1484 1484 20200831 MP 56 13484   13540   4         29 C 8/26/2020 23:49 2020-08-26T23:49:00Z 08/26 19:49 2 4 2020-08-26T23:49:00Z 17626     56 2     13540                     69 0 0 13540 posNeg 0 13540 0 0 956be80c3da302194d3265e03df8add973ddfdd0 0 0 0 0 0  
1509 1509 20200831 WA 74320 1387034   1461354 340 6740     51     B 8/30/2020 02:59 2020-08-30T02:59:00Z 08/29 22:59 1905 6740 2020-08-30T02:59:00Z       74320 1905   1461354                       53 0 0 1461354 posNeg 0 1461354 0 0 f41220bd18446de28a1cd1ae260590f686f1b410 0 0 0 0 0  
1516 1516 20200830 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 ce7b74310cafa44752eb4f0e5b23a30c760ffe5d 0 0 0 0 0  
1520 1520 20200830 CT 52495 1075011   1127506 60 11180         8967 B 8/27/2020 18:30 2020-08-27T18:30:00Z 08/27 14:30 4465 11180 2020-08-27T18:30:00Z 1125398     50387 3579 886                         9 0 0 1127506 posNeg 0 1127506 0 0 9113f428caccd38cf1ca3b0234072849914b409b 0 0 0 0 0  
1525 1525 20200830 GU 1347 36113   37460 36   4       488 A+ 8/29/2020 05:15 2020-08-29T05:15:00Z 08/29 01:15 10   2020-08-29T05:15:00Z 36916     1339       37452 158 2                 66 0 0 37460 posNeg 0 37460 0 0 f7e4dbecc14b41a70e44ed66ed8c11c680fb632f 0 0 0 0 0  
1531 1531 20200830 KS 41048 362099   403147 328 2278 96 616 31 206 1658 A+ 8/28/2020 10:00 2020-08-28T10:00:00Z 08/28 06:00 443 2278 2020-08-28T10:00:00Z               403147                     20 0 0 403147 posNeg 0 403147 0 0 958a86e345846dfe76d20c19140fc0c4dadc64e8 0 0 0 0 0  
1540 1540 20200830 MP 56 13484   13540   4         29 C 8/26/2020 23:49 2020-08-26T23:49:00Z 08/26 19:49 2 4 2020-08-26T23:49:00Z 17626     56 2     13540                     69 0 -2 13540 posNeg -2 13540 0 0 f8c04684349d07833d867dd635271de1c27b7a80 0 0 0 0 0  
1572 1572 20200829 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 ace3adead0e717a1908206d95a6a168ac0c5208b 0 0 0 0 0  
1576 1576 20200829 CT 52495 1075011   1127506 60 11180         8967 B 8/27/2020 20:30 2020-08-27T20:30:00Z 08/27 16:30 4465 11180 2020-08-27T20:30:00Z 1125398     50387 3579 886                         9 0 0 1127506 posNeg 0 1127506 0 0 42eabfed932c25c9a9f7729425b87a592b6c2520 0 0 0 0 0  
1587 1587 20200829 KS 41048 362099   403147 328 2278 96 616 31 206 1658 A+ 8/28/2020 10:00 2020-08-28T10:00:00Z 08/28 06:00 443 2278 2020-08-28T10:00:00Z               403147                     20 0 0 403147 posNeg 0 403147 0 0 ae5ab9fbbd052a441bacc2be6fefb4349fd09ee0 0 0 0 0 0  
1589 1589 20200829 LA 146944 1682235   1829179 900       141   127918 A 8/28/2020 13:00 2020-08-28T13:00:00Z 08/28 09:00 4904   2020-08-28T13:00:00Z       146243 4741 163   1828478                     22 0 0 1829179 posNeg 0 1829179 0 0 d96e71efa08dd9d74213e01fb5174a918cbc71d7 0 0 0 0 0  
1593 1593 20200829 MI 111136 2572738   2683874 669   184   93   76151 A+ 8/29/2020 00:00 2020-08-29T00:00:00Z 08/28 20:00 6712   2020-08-29T00:00:00Z 2749406 142390 2572738 100699 6446 266     256585                   26 0 0 2683874 posNeg 0 2683874 0 0 a5e25e87942949c0706b2fb7fd9221ec591032da 0 0 0 0 0  
1628 1628 20200828 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 bd007bf503cf21da89c9fd0e523fe8e68ef9e187 0 0 0 0 0  
1652 1652 20200828 MP 54 13486   13540   4         29 D 8/26/2020 23:49 2020-08-26T23:49:00Z 08/26 19:49 2 4 2020-08-26T23:49:00Z 17626     54 2     13540                     69 0 0 13540 posNeg 0 13540 0 0 ff1a8404afb984304eb95c1436e2d07c75e6c5bf 0 0 0 0 0  
1684 1684 20200827 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 c6b2cab54df3e413abedb75e185c329fb41c667b 0 0 0 0 0  
1699 1699 20200827 KS 39937 355160   395097 262 2226 76 603 25 206 1624 A+ 8/26/2020 10:00 2020-08-26T10:00:00Z 08/26 06:00 437 2226 2020-08-26T10:00:00Z               395097                     20 0 0 395097 posNeg 0 395097 0 0 f877d7f0b9f58b25814816de71e3aa8dd54ab0de 0 0 0 0 0  
1708 1708 20200827 MP 54 13486   13540   4         29 D 8/26/2020 23:49 2020-08-26T23:49:00Z 08/26 19:49 2 4 2020-08-26T23:49:00Z 17626     54 2     13540                     69 0 619 13540 posNeg 619 13540 0 0 10819467d4a425b3d387570a2513bdaeeb25207a 0 0 0 0 0  
1730 1730 20200827 VA 115458 1392084 349 1502521 1174 15938 264   148   14764 A+ 8/26/2020 17:00 2020-08-26T17:00:00Z 08/26 13:00 2515 15938 2020-08-26T17:00:00Z   134326   110437 2382 133 1502521                       51 0 0 1507891 posNeg 0 1507542 0 86 ecf8dbcafcbc63e22390bbcc22b3a62ca4079666 0 0 0 0 0  
1740 1740 20200826 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 aac13db6ec3c1cfe1cf1996b28556c8c7987084f 0 0 0 0 0  
1750 1750 20200826 HI 6984 176173   183157 270 419 50   19   2236 C 8/25/2020 05:59 2020-08-25T05:59:00Z 08/25 01:59 49 419 2020-08-25T05:59:00Z 239269             183157                     15 0 2307 183157 posNeg 2307 183157 0 0 dff290915a01e73e6ccabb86854eb3060988ab64 0 0 0 0 0  
1764 1764 20200826 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 0bf683fc6f56b4f97f9ae354bf75743a9a8319fa 0 0 0 0 0  
1796 1796 20200825 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 17628746dfe619ea73b6c7ebdea57a4cea7b032d 0 0 0 0 0  
1811 1811 20200825 KS 38401 348556   386957 189 2183 64 590 22 205 1535 A+ 8/24/2020 10:00 2020-08-24T10:00:00Z 08/24 06:00 426 2183 2020-08-24T10:00:00Z               386957                     20 0 0 386957 posNeg 0 386957 0 0 eb965d33638fe6336d4e26520de83737d8fc0699 0 0 0 0 0  
1820 1820 20200825 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 ed246f0f20ccdce0111fb372bcfeae07550195a8 0 0 0 0 0  
1845 1845 20200825 WA 71681 1308369   1380050 354 6542     37     B 8/24/2020 02:59 2020-08-24T02:59:00Z 08/23 22:59 1867 6542 2020-08-24T02:59:00Z       71681 1867   1380050                       53 0 0 1380050 posNeg 0 1380050 4 12 303de170333be5fbbb263e525562f3a9f1b467ae 0 0 0 0 0  
1852 1852 20200824 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 4f0106743bce29e4b2be1e0ed425a249b04eac22 0 0 0 0 0  
1876 1876 20200824 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 8ddda8a06e3cf9b36b6724bdb97f35971d13f7be 0 0 0 0 0  
1908 1908 20200823 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 cab50c36423df76c89e980f16a7e67f16f338caf 0 0 0 0 0  
1912 1912 20200823 CT 51519 970851   1022370 54 11087         8893 B 8/20/2020 20:30 2020-08-20T20:30:00Z 08/20 16:30 4460 11087 2020-08-20T20:30:00Z 1020328     49477 3574 886                         9 0 0 1022370 posNeg 0 1022370 0 0 18a08f7fde299d67e91e973fdba34e910b46e0c4 0 0 0 0 0  
1923 1923 20200823 KS 36856 329459   366315 296 2159 89 584 24 203 1520 A+ 8/21/2020 10:00 2020-08-21T10:00:00Z 08/21 06:00 419 2159 2020-08-21T10:00:00Z               366315                     20 0 0 366315 posNeg 0 366315 0 0 5aa3efe9379675bc966f1d90d691cc5500a421ed 0 0 0 0 0  
1926 1926 20200823 MA 125360 1428313   2064529 315 12256 50   20   102205 A+ 8/22/2020 10:00 2020-08-22T10:00:00Z 08/22 06:00 8921 12256 2020-08-22T10:00:00Z 2064529 152852   115850 8690 231   1544163       108343     74606       25 0 0 1553673 totalTestsViral 0 1553673 0 0 86c764f78937d52c58de3331e9fa1a9fb0145680 0 0 0 0 0  
1932 1932 20200823 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 b5fefa2da2987cc3665ab46349aa00b74f5c7519 0 0 0 0 0  
1955 1955 20200823 VI 960 13358 101 14318             655 C 8/21/2020 22:18 2020-08-21T22:18:00Z 08/21 18:18 10   2020-08-21T22:18:00Z 14419       10                           78 0 0 14419 posNeg 0 14318 0 0 41c0b3743465038311df5f092507ef824afe7118 0 0 0 0 0  
1964 1964 20200822 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 f640c36732d354d6976e889445d31dbd7f1c03dc 0 0 0 0 0  
1968 1968 20200822 CT 51519 970851   1022370 54 11087         8893 B 8/20/2020 20:30 2020-08-20T20:30:00Z 08/20 16:30 4460 11087 2020-08-20T20:30:00Z 1020328     49477 3574 886                         9 0 0 1022370 posNeg 0 1022370 0 0 0158e4aa7d1e65db98a063e7b8f0aa7c39f2cf60 0 0 0 0 0  
1973 1973 20200822 GU 767 30749   31516 14   3       394 A 8/21/2020 08:15 2020-08-21T08:15:00Z 08/21 04:15 7   2020-08-21T08:15:00Z 31506     759       31508 155 2                 66 0 0 31516 posNeg 0 31516 0 0 40cddf3fbda192445c8778d3ee2db2d85a66e1c9 0 0 0 0 0  
1979 1979 20200822 KS 36856 329459   366315 296 2159 89 584 24 203 1520 A+ 8/21/2020 10:00 2020-08-21T10:00:00Z 08/21 06:00 419 2159 2020-08-21T10:00:00Z               366315                     20 0 0 366315 posNeg 0 366315 0 0 2a6137e9881ace0cd62300fdd8edbfe57424a025 0 0 0 0 0  
1980 1980 20200822 KY 42265 706202   745270 590 4362 166 1340     9448 B 8/21/2020 00:00 2020-08-21T00:00:00Z 08/20 20:00 864 4362 2020-08-21T00:00:00Z 745270     39068 858 6     45988               11940   21 0 0 748467 posNeg 0 748467 0 0 2897e20e4eb2912ed2b0bf4ceb0798ed2adb34b2 0 0 0 0 0  
1981 1981 20200822 LA 141720 1597087   1738807 1051       172   118120 A 8/21/2020 13:00 2020-08-21T13:00:00Z 08/21 09:00 4687   2020-08-21T13:00:00Z       141720 4546 141   1738807                     22 0 0 1738807 posNeg 0 1738807 0 0 42af208aaab721a0cbdbadcfdad94071053be1ed 0 0 0 0 0  
1988 1988 20200822 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 821f9beeecb7d6c39079ca0da688becebb3bf69e 0 0 0 0 0  
2020 2020 20200821 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 442f7b8d2753c777a4c1efd773f4ea05ebed9b9b 0 0 0 0 0  
2030 2030 20200821 HI 5844 162828   168672 165 317 29   19   2031 C 8/20/2020 23:24 2020-08-20T23:24:00Z 08/20 19:24 45 317 2020-08-20T23:24:00Z 219986             171184                     15 0 0 168672 posNeg 0 168672 0 0 32cd9e6735e1e6971870a9763b8f54a74e1fda63 0 0 0 0 0  
2041 2041 20200821 MI 104618 2321084   2425702 646   173   95   67778 A+ 8/20/2020 00:00 2020-08-20T00:00:00Z 08/19 20:00 6634   2020-08-20T00:00:00Z 2455187 134103 2321084 94697 6368 266     243222                   26 0 0 2425702 posNeg 0 2425702 0 0 6f0c2452627fb74ce268abcb445926b607f29719 0 0 0 0 0  
2044 2044 20200821 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 3edfec6d35750f0d2ee8d31d829606dab1dd0e1b 0 0 0 0 0  
2050 2050 20200821 NH 7050 182632   290010 11 710   220     6367 B 8/20/2020 09:00 2020-08-20T09:00:00Z 08/20 05:00 428 710 2020-08-20T09:00:00Z 290010     7050       189682 29490     28924             33 0 0 189682 posNeg 0 189682 0 0 b084aa4e38930ed3120fce2fcc9584c7b3b7e74f 0 0 0 0 0  
2076 2076 20200820 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 253eb739540d6dbaf16c30e7466db850d97a06ee 0 0 0 0 0  
2091 2091 20200820 KS 35890 323950   359840 300 2090 88 567 26 202 1472 A+ 8/19/2020 10:00 2020-08-19T10:00:00Z 08/19 06:00 411 2090 2020-08-19T10:00:00Z               359840                     20 0 0 359840 posNeg 0 359840 0 0 2eb6b6b4ad755aa63d7035e1ec079e68a5c10b32 0 0 0 0 0  
2100 2100 20200820 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 1 12921 posNeg 1 12921 0 0 8e06fa27b11574d06b3200cffd77705b51cc91d0 0 0 0 0 0  
2132 2132 20200819 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 1225ed95030e2d45094d43c0baec361e076bae4b 0 0 0 0 0  
2156 2156 20200819 MP 54 12866   12920   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12920 posNeg 0 12920 0 0 6a24ee889d9d9d0b7758a111995fa1eff8b893f1 0 0 0 0 0  
2188 2188 20200818 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 e15cbe743620ba84d77003b1c7a5b6cc567aadb9 0 0 0 0 0  
2203 2203 20200818 KS 35167 319095   354262 229 2034 62 560 24 200 1409 A+ 8/17/2020 10:00 2020-08-17T10:00:00Z 08/17 06:00 405 2034 2020-08-17T10:00:00Z               354262                     20 0 0 354262 posNeg 0 354262 0 0 c271d074611aa55e2bbfbb43fbabf4ea4867a319 0 0 0 0 0  
2244 2244 20200817 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 d838330cd9e50683afbbc69c0eb84837d96ee231 0 0 0 0 0  
2300 2300 20200816 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 posNeg 0 1514 0 0 b2f3a955ecb58143d87cd4ccda3518f56268799a 0 0 0 0 0  
2304 2304 20200816 CT 50897 886793   937690 56 11015         8809 B 8/14/2020 16:00 2020-08-14T16:00:00Z 08/14 12:00 4453 11015 2020-08-14T16:00:00Z 935680     48887 3569 884                         9 0 0 937690 posNeg 0 937690 0 0 2c111324f880b1102584ebd288ffb56db1c31fa8 0 0 0 0 0  
2315 2315 20200816 KS 33885 309158   343043 311 2020 98 554 33 198 1399 A+ 8/14/2020 10:00 2020-08-14T10:00:00Z 08/14 06:00 402 2020 2020-08-14T10:00:00Z               343043                     20 0 0 343043 posNeg 0 343043 0 0 4f4c7c097a9d7a1082eb3d3da218ef519a3ab13f 0 0 0 0 0  
2324 2324 20200816 MP 50 12252   12302   4         29 D 8/14/2020 04:04 2020-08-14T04:04:00Z 08/14 00:04 2 4 2020-08-14T04:04:00Z 14419     50       12301                     69 0 0 12302 posNeg 0 12302 0 0 e29785632491865005d223c8b32dbaa71785877d 0 0 0 0 0  
2356 2356 20200815 AS 0 1514   1514               C 8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0   2020-08-15T00:00:00Z 1514     0                             60 0 118 1514 posNeg 118 1514 0 0 250992829fdc1c50f85105908daf8b8da0f9f9b6 0 0 0 0 0  
2360 2360 20200815 CT 50897 886793   937690 56 11015         8809 B 8/14/2020 16:00 2020-08-14T16:00:00Z 08/14 12:00 4453 11015 2020-08-14T16:00:00Z 935680     48887 3569 884                         9 0 0 937690 posNeg 0 937690 0 0 61a5657784db87a3e598c1d8515c26a62f192b0a 0 0 0 0 0  
2365 2365 20200815 GU 502 26594   27096 8   2       345 A 8/14/2020 05:05 2020-08-14T05:05:00Z 08/14 01:05 5   2020-08-14T05:05:00Z 27086     494       27088 153 2                 66 0 0 27096 posNeg 0 27096 0 0 1dd3d41f4b11dccf09dc72d8b8a1161052ef7d68 0 0 0 0 0  
2371 2371 20200815 KS 33885 309158   343043 311 2020 98 554 33 198 1399 A+ 8/14/2020 10:00 2020-08-14T10:00:00Z 08/14 06:00 402 2020 2020-08-14T10:00:00Z               343043                     20 0 0 343043 posNeg 0 343043 0 0 404eb5f59e6ed884d3fd902d9167bd49c542c921 0 0 0 0 0  
2373 2373 20200815 LA 136737 1500275   1637012 1243       197   103512 A 8/14/2020 13:00 2020-08-14T13:00:00Z 08/14 09:00 4430   2020-08-14T13:00:00Z       136737 4307 123   1637012                     22 0 0 1637012 posNeg 0 1637012 0 0 0a73bb5d1ae86d212e8ed3f40f177c6ae7a68c98 0 0 0 0 0  
2380 2380 20200815 MP 50 12252   12302   4         29 D 8/14/2020 04:04 2020-08-14T04:04:00Z 08/14 00:04 2 4 2020-08-14T04:04:00Z 14419     50       12301                     69 0 0 12302 posNeg 0 12302 0 0 9a091737f61ec37dbcb01bc4004246941f7efa3a 0 0 0 0 0  
2412 2412 20200814 AS 0 1396   1396               C 8/5/2020 00:00 2020-08-05T00:00:00Z 08/04 20:00 0   2020-08-05T00:00:00Z 1396     0                             60 0 0 1396 posNeg 0 1396 0 0 3619e4eedab2725d08cf721f0966393bd0de0cfd 0 0 0 0 0  
2422 2422 20200814 HI 4312 149305   153617 146 267 29   22   1716 C 8/13/2020 23:15 2020-08-13T23:15:00Z 08/13 19:15 40 267 2020-08-13T23:15:00Z 194351             153617                     15 0 3030 153617 posNeg 3030 153617 0 0 6109a4b50c951c1fce17949526764fdc1c62ccf9 0 0 0 0 0  
2442 2442 20200814 NH 6921 174695   275503 15 705   214     6190 B 8/13/2020 09:00 2020-08-13T09:00:00Z 08/13 05:00 422 705 2020-08-13T09:00:00Z 275503     6921       181616 29016     28351             33 0 0 181616 posNeg 3452 181616 0 0 efae3b4d1d91ecbc3c5dab21a0c515c1484b9178 0 0 0 0 0  
2468 2468 20200813 AS 0 1396   1396               C 8/5/2020 00:00 2020-08-05T00:00:00Z 08/04 20:00 0   2020-08-05T00:00:00Z 1396     0                             60 0 0 1396 posNeg 0 1396 0 0 c884b659809032d4be79a294af09edc261647bc3 0 0 0 0 0  
2483 2483 20200813 KS 32547 302016   334563 357 1975 95 548 29 195 1367 A+ 8/12/2020 10:00 2020-08-12T10:00:00Z 08/12 06:00 395 1975 2020-08-12T10:00:00Z               334563                     20 0 0 334563 posNeg 0 334563 0 0 4064ab44360ee1f3b401ed2d66b467ea7c559776 0 0 0 0 0  
2492 2492 20200813 MP 49 12252   12301   4         29 D 8/10/2020 17:54 2020-08-10T17:54:00Z 08/10 13:54 2 4 2020-08-10T17:54:00Z 14419     49       12301                     69 0 0 12301 posNeg 0 12301 0 0 cac86151805935a672b87aae8045c4ffc7e41ef0 0 0 0 0 0  
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  
2530 2530 20200812 DE 15699 186501   202200 35   13       8519 A+ 8/11/2020 18:00 2020-08-11T18:00:00Z 08/11 14:00 591   2020-08-11T18:00:00Z       14700 521 70   202200                     10 0 0 202200 posNeg 0 202200 0 0 bda8bb1cfa255dc3822960d2d4f85f6e00feff5d 0 0 0 0 0  
2548 2548 20200812 MP 49 12252   12301   4         29 D 8/10/2020 17:54 2020-08-10T17:54:00Z 08/10 13:54 2 4 2020-08-10T17:54:00Z 14419     49       12301                     69 0 0 12301 posNeg 0 12301 0 0 06a65d88f3baf55a9c98b97c3c0ab3d2d7ada48b 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  
2595 2595 20200811 KS 31730 294939   326669 216 1911 60 534 19 194 1319 A+ 8/10/2020 10:00 2020-08-10T10:00:00Z 08/10 06:00 387 1911 2020-08-10T10:00:00Z               326669                     20 0 0 326669 posNeg 0 326669 0 0 d8e2bc8bc8b12af48e80bde6b8b738870ebfa341 0 0 0 0 0  
2604 2604 20200811 MP 49 12252   12301   4         29 D 8/10/2020 17:54 2020-08-10T17:54:00Z 08/10 13:54 2 4 2020-08-10T17:54:00Z 14419     49       12301                     69 0 0 12301 posNeg 0 12301 0 0 66b9604f22297d7f375321b2d453f9239874521b 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  
2683 2683 20200810 VI 547 10357 1 10904             410 C 8/10/2020 09:31 2020-08-10T09:31:00Z 08/10 05:31 9   2020-08-10T09:31:00Z 10905       9                           78 0 25 10905 posNeg 25 10904 0 0 908a2e9cf64dc8bb9979594b4caab51a84ee9c23 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  
2696 2696 20200809 CT 50320 814313   864633 65 10920         8721 B 8/6/2020 20:30 2020-08-06T20:30:00Z 08/06 16:30 4441 10920 2020-08-06T20:30:00Z 862658     48345 3558 883                         9 0 0 864633 posNeg 0 864633 0 0 88f13405552e8e025c77ecd543a78af927933473 0 0 0 0 0  
2701 2701 20200809 GU 412 24117   24529 3           321 B 8/8/2020 01:45 2020-08-08T01:45:00Z 08/07 21:45 5   2020-08-08T01:45:00Z 24354     404       24521 147 2                 66 0 0 24529 posNeg 0 24529 0 0 320b387955748a72bdcaa32abdd18f703ab27c22 0 0 0 0 0  
2707 2707 20200809 KS 30638 285874   316512 333 1875 88 526 26 193 1293 A+ 8/7/2020 10:00 2020-08-07T10:00:00Z 08/07 06:00 380 1875 2020-08-07T10:00:00Z               316512                     20 0 0 316512 posNeg 0 316512 0 0 744e26f0d28110bca73eb152a51690b2e9374d68 0 0 0 0 0  
2715 2715 20200809 MO 57379 695361   752740 895       105     B 8/7/2020 00:00 2020-08-07T00:00:00Z 08/06 20:00 1301   2020-08-07T00:00:00Z 996617 66665 928188 57379       752740       61708 2324 59384         29 0 0 752740 posNeg 0 752740 0 0 a46ccaf79d03d2e70e362148e16c8eb867da1ba1 0 0 0 0 0  
2716 2716 20200809 MP 48 12253   12301   4         29 D 8/9/2020 00:59 2020-08-09T00:59:00Z 08/08 20:59 2 4 2020-08-09T00:59:00Z 14419     48       12301                     69 0 0 12301 posNeg 0 12301 0 0 21095d9a1975380327dd636f642ebcdb54c36178 0 0 0 0 0  

Next page

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