states_daily_4pm_et

Table actions

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

11,578 rows sorted by hospitalizedIncrease

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: dateModified (date), dateChecked (date)

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
6392 6392 20200604 CT 43239 238286   281525 373 9669         7284 B 6/4/2020 16:00 2020-06-04T16:00:00Z 06/04 12:00 4007 9669 2020-06-04T16:00:00Z 285314       3171 836   279457                     9 148 4941 281525 posNeg 5089 281525 18 -4124 5f63822065801a585dad1fad7c3a652daf7c6d89 0 0 0 0 0  
9674 9674 20200407 PA 14559 76719   91278 1665       548     A 4/7/2020 13:00 2020-04-07T13:00:00Z 04/07 09:00 240   2020-04-07T13:00:00Z               91278                     42 1579 5845 91278 posNeg 7424 91278 78 -1145 e75cf76583fff888e0a09d92546bfd050b76906a 0 0 0 0 0  
9458 9458 20200411 VA 5077 32922 517 50191 1252   426   283     A 4/10/2020 17:00 2020-04-10T17:00:00Z 04/10 13:00 130   2020-04-10T17:00:00Z   8351         50191                       51 568 1972 38516 posNeg 2799 37999 9 -772 89059861388d77ba48e01b59b78eec3ec61145f0 0 0 0 0 0  
8515 8515 20200427 AR 3017 37440   40457 109       25   987 B 4/27/2020 15:00 2020-04-27T15:00:00Z 04/27 11:00 50   2020-04-27T15:00:00Z 40457     3017                             5 76 912 40457 posNeg 988 40457 1 -291 f7a31c654d79332a104df49691888bb24d51171d 0 0 0 0 0  
9535 9535 20200409 IA 1270 13703   14973 122           476 A 4/9/2020 00:00 2020-04-09T00:00:00Z 04/08 20:00 29   2020-04-09T00:00:00Z       1270                             19 125 882 14973 posNeg 1007 14973 2 -193 a5f11ef6adb0a31dcce71f92d2ec7c28a4724de7 0 0 0 0 0  
8724 8724 20200424 RI 7188 39071   48990 267 576 77   48   377 B 4/24/2020 03:00 2020-04-24T03:00:00Z 04/23 23:00 202 576 2020-04-24T03:00:00Z 52909 7757 45152 7188     48990 46259                     44 415 2648 46259 totalTestEncountersViral 2949 46259 -11 -181 4c6360020de212a1acb451c137ff6c7b3b808543 0 0 0 0 0  
9183 9183 20200416 WV 739 17567   18306 85   34   24   223 B 4/16/2020 16:30 2020-04-16T16:30:00Z 04/16 12:30 13   2020-04-16T16:30:00Z       739                             54 37 613 18306 posNeg 650 18306 3 -164 9985f25f03989388a9a5a420dd375c88d1d37131 0 0 0 0 0  
9131 9131 20200416 AR 1620 21055   22675 85       21   548 A 4/16/2020 14:45 2020-04-16T14:45:00Z 04/16 10:45 37   2020-04-16T14:45:00Z 22675     1620                             5 51 790 22675 posNeg 841 22675 4 -130 34380d8c4450cf5cb5981843c5edd2a6777fdded 0 0 0 0 0  
9661 9661 20200407 MS 1915 18632   20547   377           A 4/7/2020 19:00 2020-04-07T19:00:00Z 04/07 15:00 59 377 2020-04-07T19:00:00Z                                     28 177 0 20547 posNeg 177 20547 8 -98 5a040af03186ccb04c070c780aac6f7061c3e646 0 0 0 0 0  
1366 1366 20200902 MA 121131 1650575   2478482 308 12295 58   29   103920 A+ 9/2/2020 08:00 2020-09-02T08:00:00Z 09/02 04:00 9060 12295 2020-09-02T08:00:00Z 2478482 157208   119426 8853 207   1770001       113667     89417       25 -7757 15291 1771706 totalTestsViral 30141 1771706 -4 -91 84c59dc2860aa46378b075c0e29e522e52214058 0 0 0 0 0  
784 784 20200913 WY 4346 82091   86437 12 228         3768 B 9/13/2020 12:02 2020-09-13T12:02:00Z 09/13 08:02 42 228 2020-09-13T12:02:00Z 126331 3663 122667 3679       85696                     56 49 0 86437 posNeg 49 86437 0 -59 6fe306e430cfdb62e238995887fc1a8a7fa7756e 0 0 0 0 0  
9572 9572 20200409 VT 680 7218   7898 33           15 A 4/9/2020 00:00 2020-04-09T00:00:00Z 04/08 20:00 23   2020-04-09T00:00:00Z       680                             50 49 217 7898 posNeg 266 7898 0 -50 6cbcecbc92068547ecbe76573638dae3d4f6ca1a 0 0 0 0 0  
2161 2161 20200819 NE 30825 297553   328378 160 1835         22798 A 8/18/2020 21:05 2020-08-18T21:05:00Z 08/18 17:05 368 1835 2020-08-18T21:05:00Z       30825       328673                     31 262 2629 328378 posNeg 2891 328378 6 -48 b0fa828fa7c4f1417ca1282ab90448f6cc4c8e80 0 0 0 0 0  
6217 6217 20200607 AK 544 64360   64904 7       1   382 B 6/7/2020 00:00 2020-06-07T00:00:00Z 06/06 20:00 10   2020-06-07T00:00:00Z 64904     544 10                           2 8 995 64904 posNeg 1003 64904 0 -48 3c7612e7fd58980f568e4c98d9aec0607bbf9fab 0 0 0 0 0  
6322 6322 20200606 VA 49397 321734 350 414775 1171 7553 324   169   6382 A+ 6/5/2020 17:00 2020-06-05T17:00:00Z 06/05 13:00 1460 7553 2020-06-05T17:00:00Z   59020   47123 1357 103 414775                       51 865 6496 371481 posNeg 9893 371131 7 -44 302ce8d5d6dd0b6ebb679d49237a5980c7f09708 0 0 0 0 0  
2301 2301 20200816 AZ 193537 898437   1090499 1208 20755 417   267   27582 A+ 8/16/2020 00:00 2020-08-16T00:00:00Z 08/15 20:00 4506 20755 2020-08-16T00:00:00Z       192062 4252 254   1090499 251782                   4 883 13900 1091974 posNeg 14751 1091974 14 -40 0ddc8b4f2f3f817918da2901f20265fc65052b0f 0 0 0 0 0  
10109 10109 20200330 MS 847 2989   3836   195           B 3/29/2020 19:00 2020-03-29T19:00:00Z 03/29 15:00 16 195 2020-03-29T19:00:00Z                                     28 89 429 3836 posNeg 518 3836 2 -40 2a5235e9c14e337eafd27a97c829c1561c9b5344 0 0 0 0 0  
8737 8737 20200423 AK 337 11824   12161 42           209 A 4/23/2020 14:00 2020-04-23T14:00:00Z 04/23 10:00 9   2020-04-23T14:00:00Z 12161     337                             2 2 0 12161 posNeg 2 12161 0 -36 733e3a7bde4639309603bb06f41815ff43c68698 0 0 0 0 0  
1909 1909 20200823 AZ 198103 952766   1149287 969 21241 329   191   29147 A+ 8/23/2020 00:00 2020-08-23T00:00:00Z 08/22 20:00 4771 21241 2020-08-23T00:00:00Z       196521 4515 256   1149287 259529                   4 208 6527 1150869 posNeg 6730 1150869 15 -30 c160aa0c7d2445ac721c7f563abd9a835697ab1d 0 0 0 0 0  
9038 9038 20200418 MA 37527 124604   201692 3728 3728 987         B 4/17/2020 16:00 2020-04-17T16:00:00Z 04/17 12:00 1983 3728 2020-04-17T16:00:00Z 201692 47174                                 25 2402 7409 162131 totalTestsViral 7478 162131 161 -28 4f6964a7cc768741da9d249b84f2f4634f7e5a14 0 0 0 0 0  
7679 7679 20200512 CO 19879 88778   120284 738 3663         3114 A 5/10/2020 00:00 2020-05-10T00:00:00Z 05/09 20:00 987 3663 2020-05-10T00:00:00Z       17983     120284 106761 21174 1956 19218               8 176 -113 108657 totalTestEncountersViral 3071 108657 6 -26 af4445f1e639285765a0431ac33e8e55e6b78e73 0 0 0 0 0  
1853 1853 20200824 AZ 198414 958808   1155629 908 21219 345   176   29341 A+ 8/24/2020 00:00 2020-08-24T00:00:00Z 08/23 20:00 4771 21219 2020-08-24T00:00:00Z       196821 4514 257   1155629 260739                   4 311 6042 1157222 posNeg 6342 1157222 0 -22 776494ac189e8d9af1a5fba61ffbd3ee5a197e64 0 0 0 0 0  
9579 9579 20200408 AR 1000 13530   14530 76 130   43 30 39 208 A 4/8/2020 14:35 2020-04-08T14:35:00Z 04/08 10:35 18 130 2020-04-08T14:35:00Z 14530     1000                             5 54 838 14530 posNeg 892 14530 2 -18 ec4ca5bfea70bda7f0dae78d61db35ae2db0e847 0 0 0 0 0  
5650 5650 20200618 VA 56238 445830 259 531435 857 8350 241   129   7493 A+ 6/17/2020 17:00 2020-06-17T17:00:00Z 06/17 13:00 1586 8350 2020-06-17T17:00:00Z   66774   53769 1482 104 531435                       51 463 7264 502327 posNeg 11335 502068 3 -17 105d0bd2f72e7f5bb705f506f0af06388881033a 0 0 0 0 0  
6042 6042 20200611 VA 52647 354750 358 463688 1069 7964 273   138   6895 A+ 6/10/2020 17:00 2020-06-10T17:00:00Z 06/10 13:00 1520 7964 2020-06-10T17:00:00Z   62434   50275 1413 107 463688                       51 470 8563 407755 posNeg 12100 407397 6 -17 4be7f63e8139d65d42563ae14e75f054084c783d 0 0 0 0 0  
1461 1461 20200831 AZ 201835 1002594   1202698 768 21405 256   152   30682 A+ 8/31/2020 00:00 2020-08-31T00:00:00Z 08/30 20:00 5029 21405 2020-08-31T00:00:00Z       200104 4762 267   1202698 267557                   4 174 4814 1204429 posNeg 4970 1204429 -1 -16 f0b2356b9d0d7440137fdf1062b5e3833bd193a9 0 0 0 0 0  
1273 1273 20200904 OR 27601 549328   576929 147 2161 45   23   5198 A+ 9/4/2020 03:01 2020-09-04T03:01:00Z 09/03 23:01 475 2161 2020-09-04T03:01:00Z     549328 26268       575596                     41 265 5539 576929 posNeg 5804 576929 5 -14 b9e9a62a7886b722bcfb48304e0fe4473214228a 0 0 0 0 0  
2034 2034 20200821 IN 84317 874115   958432 860 10132 252 2051 81   64131 A+ 8/20/2020 23:59 2020-08-20T23:59:00Z 08/20 19:59 3208 10132 2020-08-20T23:59:00Z 1240082       2992 216   958432                     18 1040 11921 958432 posNeg 12961 958432 17 -13 5d99ae53caf6b13e672ef59b209167d1b4e31e3f 0 0 0 0 0  
4039 4039 20200716 CO 38155 378061   514742 389 5950         4880 A 7/16/2020 01:59 2020-07-16T01:59:00Z 07/15 21:59 1601 5950 2020-07-16T01:59:00Z       35126     514742 413187 121619 7961 113658               8 469 5757 416216 totalTestEncountersViral 8614 416216 7 -13 071211fd21170ad2762857c60559eaef5254d872 0 0 0 0 0  
1517 1517 20200830 AZ 201661 997780   1197728 757 21421 263   161   30539 A+ 8/30/2020 00:00 2020-08-30T00:00:00Z 08/29 20:00 5030 21421 2020-08-30T00:00:00Z       199948 4762 268   1197728 266656                   4 374 6691 1199441 posNeg 7060 1199441 23 -12 cda429bc2a3332dffc9af1acd4e2d33c9c01e8cf 0 0 0 0 0  
3186 3186 20200801 VA 90801 1036560 352 1123927 1256 13263 275   150   12007 A+ 7/31/2020 17:00 2020-07-31T17:00:00Z 07/31 13:00 2215 13263 2020-07-31T17:00:00Z   107823   87367 2105 110 1123927                       51 913 15701 1127713 posNeg 16567 1127361 41 -8 f118a69d753a8efb2e5229887468fa2df322872d 0 0 0 0 0  
4950 4950 20200630 MA 108882 739259   1103550 733 11337 120   63   93157 A+ 6/30/2020 10:00 2020-06-30T10:00:00Z 06/30 06:00 8054 11337 2020-06-30T10:00:00Z 1103550 137597   103701 7874 180   842960       71686             25 114 5740 848141 totalTestsViral 16112 848141 -41 -8 d83342876f694c63a793115f88bd88098a0bf3c4 0 0 0 0 0  
341 341 20200920 AZ 214018 1169906   1379607 472 21876 120   57   33835 A+ 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 5476 21876 2020-09-20T00:00:00Z       209701 5184 292   1379607 282714                   4 467 10298 1383924 posNeg 10701 1383924 9 -6 8300203f2296278fd40e408628b2867ec41d7e2c 0 0 0 0 0  
1173 1173 20200906 WA 76836 1473641   1550477 282 6842     34     B 9/5/2020 02:59 2020-09-05T02:59:00Z 09/04 22:59 1953 6842 2020-09-05T02:59:00Z       76836 1953   1550477                       53 501 15886 1550477 posNeg 16387 1550477 0 -6 343893e7c52cbc7cb000d8d93c223c989c2473f2 0 0 0 0 0  
3843 3843 20200720 NJ 176963 1625911   1802874 798 21058 146   72   31448 A+ 7/20/2020 13:00 2020-07-20T13:00:00Z 07/20 09:00 15519 21058 2020-07-20T13:00:00Z 1802874     176963 13741 1778                         34 180 11557 1802874 posNeg 11737 1802874 10 -6 a5873508b77f42947d1f8cd28df557ce5b23a0a8 0 0 0 0 0  
509 509 20200917 AZ 211660 1141222   1350116 594 21821 119   65   33381 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 5409 21821 2020-09-17T00:00:00Z       208894 5135 274   1350116 280184                   4 1753 22668 1352882 posNeg 23844 1352882 38 -4 3a5c768154706b52e7d4daa51006bf64b4bca18a 0 0 0 0 0  
1176 1176 20200906 WY 4032 74312   78344 15 219         3416 A 9/6/2020 11:25 2020-09-06T11:25:00Z 09/06 07:25 42 219 2020-09-06T11:25:00Z 111391 3230 108160 3425       77685                     56 26 0 78344 posNeg 26 78344 0 -4 092d026e4ef2380530b7cf7ebe939ab6621841dd 0 0 0 0 0  
2355 2355 20200815 AR 51992 536268   588660 464 3562     108 460 44905 A 8/15/2020 16:31 2020-08-15T16:31:00Z 08/15 12:31 600 3562 2020-08-15T16:31:00Z 588660   536268 51992                         7090 1085 5 -400 0 588260 posNeg 0 588260 13 -4 7073efb6076ddc4526493942dff0937f8e77e138 0 0 0 0 0  
5818 5818 20200615 VA 54886 424113 259 502392 902 8132 269   130   7230 A+ 6/14/2020 17:00 2020-06-14T17:00:00Z 06/14 13:00 1552 8132 2020-06-14T17:00:00Z   64951   52460 1444 108 502392                       51 380 9619 479258 posNeg 8677 478999 6 -4 ffc7684284775c23d96a6575db7f00e8ad6bd0d7 0 0 0 0 0  
1013 1013 20200908 AZ 206045 1060554   1264793 657 21522 212   112   32003 A+ 9/8/2020 00:00 2020-09-08T00:00:00Z 09/07 20:00 5221 21522 2020-09-08T00:00:00Z       204239 4947 274   1264793 273717                   4 81 3121 1266599 posNeg 3203 1266599 2 -3 6ef578ed9a2967008e9effddf4c283def1864432 0 0 0 0 0  
4365 4365 20200711 WA 44341 773779   818120 326 4662     57     B 7/10/2020 02:59 2020-07-10T02:59:00Z 07/09 22:59 1424 4662 2020-07-10T02:59:00Z       44341 1424   818120 668466                     53 526 9817 818120 posNeg 10343 818120 15 -3 db57d56483794efefc04447a1ac0a8b1f901d4f2 0 0 0 0 0  
1069 1069 20200907 AZ 205964 1057433   1261590 658 21525 221   119   31866 A+ 9/7/2020 00:00 2020-09-07T00:00:00Z 09/06 20:00 5219 21525 2020-09-07T00:00:00Z       204157 4945 274   1261590 273150                   4 198 4181 1263397 posNeg 4369 1263397 -2 -2 e0ef11af5350fc2636938b12b6d9848b37d349c5 0 0 0 0 0  
1332 1332 20200903 RI 22143 259490   547593 68 2540 7   4   2137 A+ 9/3/2020 12:00 2020-09-03T12:00:00Z 09/03 08:00 1055 2540 2020-09-03T12:00:00Z   31447 516146 22143     547593 281633                     44 65 2927 281633 totalTestEncountersViral 11454 281633 4 -2 dce08fcb375cf7df05f7638c3505ad5da516b6eb 0 0 0 0 0  
2106 2106 20200820 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 14 1659 189682 posNeg 2936 189682 1 -2 8d2b58027feeb29dc9f5ec92d33eb9935b2f64c4 0 0 0 0 0  
2240 2240 20200818 WY 3363 59078   62441 12 193         2759 B 8/18/2020 16:42 2020-08-18T16:42:00Z 08/18 12:42 34 193 2020-08-18T16:42:00Z 89532 2865 86666 2850       61928                     56 32 1511 62441 posNeg 1543 62441 1 -2 1f4b598e187e85341342e6b9d0763d3b38dd6486 0 0 0 0 0  
6464 6464 20200603 ME 2418 50591   53009 44 285 14   10   1699 B 6/2/2020 23:59 2020-06-02T23:59:00Z 06/02 19:59 95 285 2020-06-02T23:59:00Z 55237 2903 52234 2152 95       4446 226 4212               23 41 0 53009 posNeg 41 53009 1 -2 d7204a39a94dce55933981995a4fe89bf50c9769 0 0 0 0 0  
7576 7576 20200514 ID 2324 31430   33556 19 212   88     1557 B 5/13/2020 19:00 2020-05-13T19:00:00Z 05/13 15:00 69 212 2020-05-13T19:00:00Z 33556     2126                             16 31 595 33754 posNeg 622 33754 0 -2 cc127f3ab7bbe7e4fe7a185506f995e558e901e4 0 0 0 0 0  
192 192 20200923 ME 5171 380864   386035 14 441 2   0   4445 A+ 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 140 441 2020-09-22T23:59:00Z 391331 6426 384620 4643 139 1     10218 515 9689               23 25 10578 386035 posNeg 10603 386035 0 -1 2eacf50f526cd8664bd872418aec4ed2f4cc7d5b 0 0 0 0 0  
808 808 20200912 ME 4834 320169   325003 10 431 6   4   4211 A+ 9/11/2020 23:59 2020-09-11T23:59:00Z 09/11 19:59 135 431 2020-09-11T23:59:00Z 324518 6048 318215 4349 134 1     9957 503 9440               23 42 4953 325003 posNeg 4995 325003 1 -1 4daa684fbe00a12fbd7f0bb798ebf3da42ae2222 0 0 0 0 0  
1256 1256 20200904 ME 4632 281971   286603 9 423 5   2   4006 A+ 9/3/2020 23:59 2020-09-03T23:59:00Z 09/03 19:59 134 423 2020-09-03T23:59:00Z 286135 5800 280089 4164 133 1     9722 484 9225               23 15 5535 286603 posNeg 5550 286603 1 -1 5b1610bf561074936c885e6a3929be5b46fb2b31 0 0 0 0 0  
2264 2264 20200817 ME 4197 208357   212554 10 399 3   1   3638 A+ 8/16/2020 23:59 2020-08-16T23:59:00Z 08/16 19:59 127 399 2020-08-16T23:59:00Z 212124 5261 206635 3767 126 1     9260 456 8791               23 29 2302 212554 posNeg 2331 212554 0 -1 82fd3d1a6f88dda77049cc2917b110e052877d8b 0 0 0 0 0  
2992 2992 20200804 ME 3975 171786   175761 12 388 1   1   3424 A+ 8/3/2020 23:59 2020-08-03T23:59:00Z 08/03 19:59 123 388 2020-08-03T23:59:00Z 175334 4961 170162 3548 122 1     8930 424 8494               23 5 1611 175761 posNeg 1616 175761 -1 -1 b67673b55b7dea6135f1e5ed440ad4a3f99b8ccd 0 0 0 0 0  
5152 5152 20200627 WY 1392 30406   31798 5 111         1054 B 6/27/2020 12:25 2020-06-27T12:25:00Z 06/27 08:25 20 111 2020-06-27T12:25:00Z 42402 1229 41172 1097       31485                     56 24 0 31798 posNeg 24 31798 0 -1 0c214076bb4a5aaa45bd2c6bb68e80edc0f90342 0 0 0 0 0  
5686 5686 20200617 MT 630 64885   65515 5 78         538 C 6/17/2020 00:00 2020-06-17T00:00:00Z 06/16 20:00 20 78 2020-06-17T00:00:00Z 65515     630                             30 16 1922 65515 posNeg 1938 65515 1 -1 2c6509b7755efcab57c32121e12f4759862416c1 0 0 0 0 0  
5914 5914 20200613 NH 5251 88705   112141 76 503   149     3843 B 6/12/2020 09:00 2020-06-12T09:00:00Z 06/12 05:00 315 503 2020-06-12T09:00:00Z 112141     5251       93956 17720     15236             33 42 1997 93956 posNeg 2639 93956 7 -1 33318d0d6238eb4b0018cacb589f7789c01dc357 0 0 0 0 0  
5989 5989 20200612 WA 27155 459231   486386 226 3772     8     B 6/12/2020 02:59 2020-06-12T02:59:00Z 06/11 22:59 1194 3772 2020-06-12T02:59:00Z       27155 1194   486386 422770                     53 388 9249 486386 posNeg 9637 486386 4 -1 fcc11d3b62382d36640a8bfe67b5111eb8a8797a 0 0 0 0 0  
6846 6846 20200527 HI 643 50559   51202   83         593 D 5/26/2020 00:00 2020-05-26T00:00:00Z 05/25 20:00 17 83 2020-05-26T00:00:00Z 51202                                   15 0 831 51202 posNeg 831 51202 0 -1 ff7a654a60f693a890d62314f5a72ba09fe067d9 0 0 0 0 0  
8008 8008 20200507 WY 631 11403   12034 11 59         416 C 5/6/2020 15:27 2020-05-06T15:27:00Z 05/06 11:27 7 59 2020-05-06T15:27:00Z 12569     479                             56 27 0 12034 posNeg 27 12034 0 -1 592ca84a7b533a66c8f529f15550e40c714a973a 0 0 0 0 0  
9855 9855 20200404 WV 282 7404   7686               B 4/4/2020 10:00 2020-04-04T10:00:00Z 04/04 06:00 2   2020-04-04T10:00:00Z       282                             54 45 1274 7686 posNeg 1319 7686 0 -1 bf5509bf97c0d68e234adde570086520682c501c 0 0 0 0 0  
10318 10318 20200326 HI 95 4357   4452   5           A 3/25/2020 18:00 2020-03-25T18:00:00Z 03/25 14:00   5 2020-03-25T18:00:00Z                                     15 5 0 4452 posNeg 5 4452 0 -1 6288808d7061b75b0b7aea8a6b4102ac1e3ddd65 0 0 0 0 0  
10322 10322 20200326 IN 645 4006   4651               B 3/25/2020 12:59 2020-03-25T12:59:00Z 03/25 08:59 17   2020-03-25T12:59:00Z                                     18 168 1127 4651 posNeg 1295 4651 3 -1 2dde49eaaca1e19306c4bfa257ce133b72630ab0 0 0 0 0 0  
1 1 20200926 AK 8315 434554   442869 43       14   3267 A 9/26/2020 03:59 2020-09-26T03:59:00Z 09/25 23:59 52   2020-09-26T03:59:00Z 442869 7411 435171 8315 52                           2 113 1424 442869 posNeg 1537 442869 1 0 bf7518dcc571d23d1d8206a95e1a1c12173bcb0a 0 0 0 0 0  
2 2 20200926 AL 151591 970048   1104932 709 16852   1791   1007 64583 A 9/26/2020 11:00 2020-09-26T11:00:00Z 09/26 07:00 2501 16852 2020-09-26T11:00:00Z 1104932     134884 2364 137           57800             1 933 6684 1121639 posNeg 7337 1121639 10 0 88370a431af70a13b1499a5cd6afe94a14fc9fb3 0 0 0 0 0  
3 3 20200926 AR 80755 855635   933895 447 5202 213   91 657 72051 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 1285 5202 2020-09-26T00:00:00Z 933895   855635 78260 1137 148                 10264 2706 21856 3300 5 809 6813 936390 posNeg 7601 936390 19 0 1177f6d15b81adb770caebd6b66b47189c93f198 0 0 0 0 0  
4 4 20200926 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 b9eccb7369bdc4ee75708c7a892c5437ab915d83 0 0 0 0 0  
6 6 20200926 CA 798237 13384493   14182730 3203   862         B 9/26/2020 02:59 2020-09-26T02:59:00Z 09/25 22:59 15532   2020-09-26T02:59:00Z 14182730     798237                             6 4197 126286 14182730 posNeg 130483 14182730 134 0 bc22d39302ce5646a61aef19adbfa503f5de5e76 0 0 0 0 0  
8 8 20200926 CT 56587 1462564   1519151 76 11560         9310 B 9/24/2020 20:30 2020-09-24T20:30:00Z 09/24 16:30 4501 11560 2020-09-24T20:30:00Z 1516780     54216 3604 897                         9 0 0 1519151 posNeg 0 1519151 0 0 597a6f3bd03d5e8297830e769c3da2cb90e767e7 0 0 0 0 0  
9 9 20200926 DC 15215 362764   377979 101   25   17   12029 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 624   2020-09-25T00:00:00Z             377979 211599                     11 52 4341 377979 posNeg 4393 377979 1 0 5dd3065a746eea8ae0e9a70d3218cd0129db3054 0 0 0 0 0  
10 10 20200926 DE 20156 260243   280399 57   10       10541 A+ 9/25/2020 18:00 2020-09-25T18:00:00Z 09/25 14:00 633   2020-09-25T18:00:00Z       19103 556 77   280399                     10 71 954 280399 posNeg 1025 280399 2 0 e3e0fc4116a2a29665fe6bffd51a89a13780977a 0 0 0 0 0  
13 13 20200926 GU 2354 46365   48719 30   9       1668 A 9/26/2020 09:45 2020-09-26T09:45:00Z 09/26 05:45 43   2020-09-26T09:45:00Z 48254     2354       48719 179 3                 66 68 395 48719 posNeg 463 48719 2 0 7185eba890dd8a1d9ad81f1a7efd70101c32b967 0 0 0 0 0  
15 15 20200926 IA 82944 667954   750898 334   84   29   65490 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 1311   2020-09-26T00:00:00Z       82944       752449       57997 3389 54568 20350 2645     19 899 5018 750898 posNeg 5917 750898 4 0 47decf503735f781b057e655041ca39b2b4fb714 0 0 0 0 0  
17 17 20200926 IL 288815 5142362   5431177 1597   355   141     A 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 8832   2020-09-26T00:00:00Z 5428688     286326 8588 244                         17 2441 62776 5431177 posNeg 65217 5431177 25 0 2620e4472a6793bd94436e1e6a2f1efbe8f39315 0 0 0 0 0  
19 19 20200926 KS 56592 446178   502770 343 2816 121 768 34 250 2039 A+ 9/25/2020 10:00 2020-09-25T10:00:00Z 09/25 06:00 632 2816 2020-09-25T10:00:00Z               502770                     20 0 0 502770 posNeg 0 502770 0 0 1468f023cf5cebe6e0d2f0752a5b054eecc06b87 0 0 0 0 0  
21 21 20200926 LA 165152 2090913   2256065 570       86   149640 A 9/25/2020 13:00 2020-09-25T13:00:00Z 09/25 09:00 5444   2020-09-25T13:00:00Z       163928 5262 182   2254841                     22 0 0 2256065 posNeg 0 2256065 0 0 bda77e8fe6fd07aa1abd19dfbcfc5e00573b8f1f 0 0 0 0 0  
25 25 20200926 MI 134373 3408684   3543057 558   139   52   95051 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 7044   2020-09-26T00:00:00Z 3578584 169900 3408684 121427 6723 321     291180                   26 996 39749 3543057 posNeg 40745 3543057 17 0 2e49e36255f6a6daef66f967af21b911b45c97ad 0 0 0 0 0  
27 27 20200926 MO 122014 1167155   1289169 1101             B 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 2063   2020-09-26T00:00:00Z 1687509 128009 1556710 122014       1289169       74093 3508 70585         29 1716 14288 1289169 posNeg 16004 1289169 69 0 de543358a328e51d3abdbaecc32041460021841e 0 0 0 0 0  
28 28 20200926 MP 69 14776   14845   4         29 D 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 2 4 2020-09-25T00:00:00Z 19835     69 2     14845                     69 0 0 14845 posNeg 0 14845 0 0 6fdb4898ec2dbbb6eafe41b19ae56eff50411718 0 0 0 0 0  
29 29 20200926 MS 96677 634036   730713 601 5607 147   68   85327 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 2911 5607 2020-09-25T00:00:00Z 723389     89353 2686 225     38425 95             55557   28 645 3682 730713 posNeg 4327 730713 17 0 25c406301ef686539186978256312931e29136fe 0 0 0 0 0  
31 31 20200926 NC 206090 2741713   2947803 914   272       176422 A+ 9/26/2020 12:00 2020-09-26T12:00:00Z 09/26 08:00 3440   2020-09-26T12:00:00Z 2943144     201431 3440                           37 1759 38427 2947803 posNeg 40186 2947803 31 0 20a1b19461a3df0fea54c6dfb6ffc967453a835b 0 0 0 0 0  
37 37 20200926 NV 78355 607323   685678 442   125   64   2075 A+ 9/26/2020 02:59 2020-09-26T02:59:00Z 09/25 22:59 1582   2020-09-26T02:59:00Z 1026486     78355       684796                     32 602 3740 685678 posNeg 4342 685678 9 0 6562d5250f6a1ba7ad8affc64c3a68a2b09dd5cd 0 0 0 0 0  
38 38 20200926 NY 454760 9968656   10423416 527 89995 164   75   76528 A 9/25/2020 23:59 2020-09-25T23:59:00Z 09/25 19:59 25450 89995 2020-09-25T23:59:00Z       454760     10423416                       36 1005 98948 10423416 posNeg 99953 10423416 4 0 bb7957fb78d761d4366fb1503123856475c70689 0 0 0 0 0  
41 41 20200926 OR 32581 636090   668671 199 2496 40   14   5490 A+ 9/26/2020 03:01 2020-09-26T03:01:00Z 09/25 23:01 546 2496 2020-09-26T03:01:00Z     636090 30742       661334                     41 267 5498 668671 posNeg 5765 668671 4 0 76f49d2ef6b4e575aed9232f25aefd8711244bf3 0 0 0 0 0  
42 42 20200926 PA 155232 1830292   1985524 444       60   127290 A+ 9/26/2020 12:00 2020-09-26T12:00:00Z 09/26 08:00 8103   2020-09-26T12:00:00Z 2898629     150393       1980685                     42 1029 13895 1985524 posNeg 14924 1985524 22 0 95db3b8c62ccc9249c12e799648a8351f5b7337f 0 0 0 0 0  
43 43 20200926 PR 45413 305972   351385 342   59   33     C 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 642   2020-09-26T00:00:00Z 310546 7002 303412 22164 471 171       23249                 72 508 0 351385 posNeg 508 351385 7 0 347836cd67621b97708a39d1a47689f42650b1b1 0 0 0 0 0  
44 44 20200926 RI 24181 305853   727469 94 2725 8   4   2278 A+ 9/25/2020 12:00 2020-09-25T12:00:00Z 09/25 08:00 1107 2725 2020-09-25T12:00:00Z   34299 693170 24181     727469 330034                     44 0 0 330034 totalTestEncountersViral 0 330034 0 0 e5a147d241db0ad3830218c1038dc29b79d42bcc 0 0 0 0 0  
48 48 20200926 TX 733438 5261375   5994813 3209   1056       649580 A 9/26/2020 16:20 2020-09-26T16:20:00Z 09/26 12:20 15485   2020-09-26T16:20:00Z 5994813     733438         399337 35847             80294 9297 48 4886 76478 5994813 posNeg 81364 5994813 121 0 118422653c167fc9d3ed0bd4ad4d2a32d4f6a49a 0 0 0 0 0  
51 51 20200926 VI 1296 18676 8 19972             1209 D 9/25/2020 09:30 2020-09-25T09:30:00Z 09/25 05:30 19   2020-09-25T09:30:00Z 19980       19                           78 0 0 19980 posNeg 0 19972 0 0 61739fb2efab7827062ca9cc633984208f34bc24 0 0 0 0 0  
52 52 20200926 VT 1739 158537   160276 1           1580 B 9/25/2020 23:59 2020-09-25T23:59:00Z 09/25 19:59 58   2020-09-25T23:59:00Z       1739 58     160276                     50 8 989 160276 posNeg 997 160276 0 0 21dc4138bae65a1c22e9f7756f9fd545cb820bea 0 0 0 0 0  
55 55 20200926 WV 15158 527133   542291 174   56   31   11121 C 9/25/2020 23:59 2020-09-25T23:59:00Z 09/25 19:59 332   2020-09-25T23:59:00Z 541883     14750 329 3     17205                   54 205 6692 542291 posNeg 6897 542291 2 0 a4823873f7e477ab8b531c7edd4b61423f7dbfdb 0 0 0 0 0  
57 57 20200925 AK 8202 433130   441332 43       14   3042 A 9/25/2020 03:59 2020-09-25T03:59:00Z 09/24 23:59 51   2020-09-25T03:59:00Z 441332 7357 433688 8202 51                           2 261 7873 441332 posNeg 8134 441332 6 0 0271fcc794329b2dd035402cb74aad56124c446b 0 0 0 0 0  
60 60 20200925 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 84c6296997b54d1474da9d9c51e33d48fda7fb5b 0 0 0 0 0  
62 62 20200925 CA 794040 13258207   14052247 3307   899         B 9/24/2020 02:59 2020-09-24T02:59:00Z 09/23 22:59 15398   2020-09-24T02:59:00Z 14052247     794040                             6 3400 95990 14052247 posNeg 99390 14052247 84 0 dc1ad4cec70e3f611d3c3453330d057af15b2802 0 0 0 0 0  
64 64 20200925 CT 56587 1462564   1519151 76 11560         9310 B 9/24/2020 20:30 2020-09-24T20:30:00Z 09/24 16:30 4501 11560 2020-09-24T20:30:00Z 1516780     54216 3604 897                         9 115 13563 1519151 posNeg 13678 1519151 2 0 7bba4f44da52bffe3a760b5e91631916a9d12741 0 0 0 0 0  
65 65 20200925 DC 15163 358423   373586 101   29   17   11990 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 623   2020-09-24T00:00:00Z             373586 210143                     11 57 5662 373586 posNeg 5719 373586 2 0 fa43d123c3d8a81e9ca093ade7dd2b5bd84f2e46 0 0 0 0 0  
66 66 20200925 DE 20085 259289   279374 53   11       10517 A+ 9/24/2020 18:00 2020-09-24T18:00:00Z 09/24 14:00 631   2020-09-24T18:00:00Z       19044 554 77   279374                     10 138 1320 279374 posNeg 1458 279374 1 0 0cb6cfa23b27978fc86ee02a2be8fc6824f50d2e 0 0 0 0 0  
69 69 20200925 GU 2286 45970   48256 31   11       1668 A 9/25/2020 08:00 2020-09-25T08:00:00Z 09/25 04:00 41   2020-09-25T08:00:00Z 48254     2286       48256 179 3                 66 23 546 48256 posNeg 569 48256 3 0 fb3e86409c30ee1985da66f84ce87e1407f9609a 0 0 0 0 0  
71 71 20200925 IA 82045 662936   744981 330   87   35   62648 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 1307   2020-09-25T00:00:00Z       82045       746536       57499 3371 54088 20262 2640     19 974 5427 744981 posNeg 6401 744981 5 0 8b946f1a4d28145fbe7ed6ca8f9fb3b2a6cced4b 0 0 0 0 0  
73 73 20200925 IL 286374 5079586   5365960 1637   371   124     A 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 8807   2020-09-25T00:00:00Z 5363471     283885 8563 244                         17 2805 67279 5365960 posNeg 70084 5365960 33 0 eba0b8805427a5e5e03fefdff222976f3e0158c6 0 0 0 0 0  
77 77 20200925 LA 165152 2090913   2256065 570       86   149640 A 9/25/2020 13:00 2020-09-25T13:00:00Z 09/25 09:00 5444   2020-09-25T13:00:00Z       163928 5262 182   2254841                     22 706 17825 2256065 posNeg 18531 2256065 21 0 25e0ee29f19c5ee29b7147d637fdc6eabccbdd0d 0 0 0 0 0  
80 80 20200925 ME 5235 401159   406394 10 442 2   0   4507 A+ 9/24/2020 23:59 2020-09-24T23:59:00Z 09/24 19:59 140 442 2020-09-24T23:59:00Z 405850 6490 399070 4691 139 1     10270 516 9740               23 20 6408 406394 posNeg 6428 406394 0 0 b94fc4f00af403146c6cbf490ee10259bf57ba28 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
);