states_daily_4pm_et

Table actions

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

3,202 rows where dataQualityGrade = "A" sorted by positiveTestsViral

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestResultsSource, dateChecked (date)

dataQualityGrade ✖

  • A · 3,202 ✖
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
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  
7 7 20200926 CO 67926 804806   1277613 248 7479         6404 A 9/25/2020 01:59 2020-09-25T01:59:00Z 09/24 21:59 1940 7479 2020-09-25T01:59:00Z       63137     1277613 867943 166415 11592 154823               8 709 9218 872732 totalTestEncountersViral 16752 872732 5 25 e66aa724278acdbfea40842a634bf1ac4a32fa77 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  
16 16 20200926 ID 39757 262420   298652 135 1795 44 451     21291 A 9/25/2020 18:55 2020-09-25T18:55:00Z 09/25 14:55 458 1795 2020-09-25T18:55:00Z 298652     36232 421 37                         16 523 1772 302177 posNeg 2240 302177 1 29 71c4c31498029adf59faba29c2c940f819b1402a 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  
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  
26 26 20200926 MN 95659 1273023   1954715 340 7443 120 2085     85259 A 9/25/2020 17:00 2020-09-25T17:00:00Z 09/25 13:00 2056 7443 2020-09-25T17:00:00Z       95659 2004 52 1954715 1368682                     27 1470 16056 1368682 posNeg 30695 1368682 10 52 9be7f926e01b9ff59c4df68144853a139533f186 0 0 0 0 0  
33 33 20200926 NE 43162 397483   440645 225 2276         32238 A 9/25/2020 20:30 2020-09-25T20:30:00Z 09/25 16:30 468 2276 2020-09-25T20:30:00Z 595287     43162       440947                     31 431 2910 440645 posNeg 3341 440645 6 17 dff40db61c6d6203f6a42331a30731482bfd47e3 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  
46 46 20200926 SD 21133 165001   186134 213 1434         17173 A 9/25/2020 14:00 2020-09-25T14:00:00Z 09/25 10:00 218 1434 2020-09-25T14:00:00Z 260219             186134                     46 579 1608 186134 posNeg 2187 186134 2 34 ca6a7392a4ed3947a93b80040d2c4fffc4abcbe2 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  
58 58 20200925 AL 150658 963364   1097595 718 16852   1782   1000 64583 A 9/25/2020 11:00 2020-09-25T11:00:00Z 09/25 07:00 2491 16852 2020-09-25T11:00:00Z 1097595     134231 2357 134           57589             1 2452 18617 1114022 posNeg 19415 1114022 -15 74 08184faa52c95520b2871a34cbea8adad1c1d054 0 0 0 0 0  
63 63 20200925 CO 67217 795588   1260861 258 7454         6384 A 9/24/2020 01:59 2020-09-24T01:59:00Z 09/23 21:59 1935 7454 2020-09-24T01:59:00Z       62520     1260861 858108 165873 11561 154312               8 548 8665 862805 totalTestEncountersViral 15116 862805 9 10 45e4c07f8e584b5c055940eaa9c96cd814f2e4e5 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  
72 72 20200925 ID 39234 260648   296412 147 1766 40 449     21105 A 9/24/2020 18:54 2020-09-24T18:54:00Z 09/24 14:54 457 1766 2020-09-24T18:54:00Z 296412     35764 419 38                         16 491 1948 299882 posNeg 2349 299882 3 12 54cbd57bd945d0aff2f97042076c6ca51bdaa3e4 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  
82 82 20200925 MN 94189 1256967   1924020 303 7391 148 2067     84256 A 9/24/2020 17:00 2020-09-24T17:00:00Z 09/24 13:00 2046 7391 2020-09-24T17:00:00Z       94189 1994 52 1924020 1351156                     27 1177 13128 1351156 posNeg 28718 1351156 6 56 061aceb519ca7ddc7114b0066f922f36ff84715a 0 0 0 0 0  
89 89 20200925 NE 42731 394573   437304 231 2259         31774 A 9/24/2020 20:44 2020-09-24T20:44:00Z 09/24 16:44 462 2259 2020-09-24T20:44:00Z 590209     42731       437603                     31 453 2482 437304 posNeg 2935 437304 0 12 e40b0755a7896c25231d58ae53fbdda04d014158 0 0 0 0 0  
94 94 20200925 NY 453755 9869708   10323463 511 89995 154   76   76456 A 9/24/2020 23:59 2020-09-24T23:59:00Z 09/24 19:59 25446 89995 2020-09-24T23:59:00Z       453755     10323463                       36 908 93910 10323463 posNeg 94818 10323463 7 0 3368f209738993fd91a59f668c9e4097259271ad 0 0 0 0 0  
102 102 20200925 SD 20554 163393   183947 194 1400         16831 A 9/24/2020 14:00 2020-09-24T14:00:00Z 09/24 10:00 216 1400 2020-09-24T14:00:00Z 256264             183947                     46 457 1829 183947 posNeg 2286 183947 6 25 96b37d467b78c8e4e13a2d678e0984c56873d308 0 0 0 0 0  
104 104 20200925 TX 728552 5184897   5913449 3221   1051       646143 A 9/25/2020 17:20 2020-09-25T17:20:00Z 09/25 13:20 15364   2020-09-25T17:20:00Z 5913449     728552         394584 35656             78472 9190 48 4633 47983 5913449 posNeg 52616 5913449 97 0 fcc328aeaedb26412d3c3b30f120af65e1ed1251 0 0 0 0 0  
114 114 20200924 AL 148206 944747   1078180 744 16778   1679   931 64583 A 9/24/2020 11:00 2020-09-24T11:00:00Z 09/24 07:00 2506 16778 2020-09-24T11:00:00Z 1078180     133433 2349 157           57387             1 1053 6296 1092953 posNeg 7277 1092953 18 80 4b1b271eafc1e79991c11cae326c455bd34ae063 0 0 0 0 0  
119 119 20200924 CO 66669 786923   1245745 259 7444         6351 A 9/23/2020 01:59 2020-09-23T01:59:00Z 09/22 21:59 1926 7444 2020-09-23T01:59:00Z       61983     1245745 848906 165290 11524 153766               8 616 7865 853592 totalTestEncountersViral 13457 853592 0 28 b3f97a8d2eb9b057bcdbf2c7e5d2735bfae768b0 0 0 0 0 0  
125 125 20200924 GU 2263 45424   47687 33   11       1568 A 9/24/2020 05:55 2020-09-24T05:55:00Z 09/24 01:55 38   2020-09-24T05:55:00Z 47685     2263       47687 179 3                 66 28 408 47687 posNeg 436 47687 1 0 5eb29e4a8462d4ce4ceeebcaedda903fce88c014 0 0 0 0 0  
128 128 20200924 ID 38743 258700   294063 147 1754 40 448     20901 A 9/23/2020 19:00 2020-09-23T19:00:00Z 09/23 15:00 454 1754 2020-09-23T19:00:00Z 294063     35363 416 38                         16 396 1646 297443 posNeg 1904 297443 3 14 0e8a154feff2f4be74aa5881e5c6ee9d60645454 0 0 0 0 0  
129 129 20200924 IL 283569 5012307   5295876 1713   400   155     A 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 8774   2020-09-24T00:00:00Z 5293678     281371 8538 236                         17 2257 59814 5295876 posNeg 62071 5295876 30 0 76fe84d28caa2298ab73216cc104309da8e32b0d 0 0 0 0 0  
133 133 20200924 LA 164446 2073088   2237534 575       92   149640 A 9/24/2020 13:00 2020-09-24T13:00:00Z 09/24 09:00 5423   2020-09-24T13:00:00Z       163222 5241 182   2236310                     22 577 16948 2237534 posNeg 17525 2237534 16 0 b2014a2fdca7f1221bf7d8612791ab6d4dbbf314 0 0 0 0 0  
138 138 20200924 MN 93012 1243839   1895302 303 7335 148 2049     83862 A 9/23/2020 17:00 2020-09-23T17:00:00Z 09/23 13:00 2040 7335 2020-09-23T17:00:00Z       93012 1988 52 1895302 1336851                     27 912 11988 1336851 posNeg 21435 1336851 3 32 3ee6b1685a96dd97e9c7ed5797c7aa6d57dd24ff 0 0 0 0 0  
145 145 20200924 NE 42278 392091   434369 200 2247         31383 A 9/23/2020 20:47 2020-09-23T20:47:00Z 09/23 16:47 462 2247 2020-09-23T20:47:00Z 585096     42278       434669                     31 493 2774 434369 posNeg 3267 434369 1 33 55e28c6e57a17fe1b6e88334fcffd795fb66c606 0 0 0 0 0  
150 150 20200924 NY 452847 9775798   10228645 500 89995 145   72   76382 A 9/23/2020 23:59 2020-09-23T23:59:00Z 09/23 19:59 25439 89995 2020-09-23T23:59:00Z       452847     10228645                       36 955 91998 10228645 posNeg 92953 10228645 2 0 63ceae8617c69dd2e696b201ec2dd6059b8d0350 0 0 0 0 0  
158 158 20200924 SD 20097 161564   181661 194 1375         16596 A 9/23/2020 14:00 2020-09-23T14:00:00Z 09/23 10:00 210 1375 2020-09-23T14:00:00Z 252559             181661                     46 463 1066 181661 posNeg 1529 181661 8 8 2d80a88df96a24de6a313a047f42977d68f48e92 0 0 0 0 0  
160 160 20200924 TX 723919 5136914   5860833 3204   1051       642169 A 9/24/2020 18:05 2020-09-24T18:05:00Z 09/24 14:05 15267   2020-09-24T18:05:00Z 5860833     723919         391678 35421             77981 9120 48 4320 115839 5860833 posNeg 120159 5860833 138 0 ef731c1431ebc33082c55af4b13119e8e30dfdea 0 0 0 0 0  
170 170 20200923 AL 147153 938451   1070903 768 16698   1669   920 64583 A 9/23/2020 11:00 2020-09-23T11:00:00Z 09/23 07:00 2488 16698 2020-09-23T11:00:00Z 1070903     132452 2335 153           57192             1 569 4886 1085604 posNeg 5350 1085604 31 94 64268ac422e3a504e9b8401b29b1a739bf4ee1ba 0 0 0 0 0  
175 175 20200923 CO 66053 779058   1232288 230 7416         6332 A 9/22/2020 01:59 2020-09-22T01:59:00Z 09/21 21:59 1926 7416 2020-09-22T01:59:00Z       61394     1232288 840452 167110 11645 155465               8 654 5573 845111 totalTestEncountersViral 13151 845111 12 43 c71007212dbe9c1847499f752ccfb5aeae0193fd 0 0 0 0 0  
181 181 20200923 GU 2235 45016   47251 33   13       1543 A 9/23/2020 06:45 2020-09-23T06:45:00Z 09/23 02:45 37   2020-09-23T06:45:00Z 47249     2235       47251 175 3                 66 45 378 47251 posNeg 423 47251 0 0 1452355ca652f03a360f08ed2e26e5c6fc7778ab 0 0 0 0 0  
184 184 20200923 ID 38347 257054   292159 130 1740 39 447     20674 A 9/22/2020 19:00 2020-09-22T19:00:00Z 09/22 15:00 451 1740 2020-09-22T19:00:00Z 292159     35105 413 38                         16 446 884 295401 posNeg 1248 295401 4 14 c6021d51e1016df795f5a68a2ce2b8f879acd8d7 0 0 0 0 0  
185 185 20200923 IL 281312 4952493   5233805 1563   351   144     A 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 8744   2020-09-23T00:00:00Z 5231607     279114 8508 236                         17 1848 44543 5233805 posNeg 46391 5233805 22 0 532c422e30059be3804edb66b4ca90f36dfe007f 0 0 0 0 0  
189 189 20200923 LA 163869 2056140   2220009 592       94   149640 A 9/23/2020 13:00 2020-09-23T13:00:00Z 09/23 09:00 5407   2020-09-23T13:00:00Z       162645 5225 182   2218785                     22 616 12419 2220009 posNeg 13035 2220009 21 0 bd123e4a84ed54452f04ff5dd88a5ec51ba81375 0 0 0 0 0  
194 194 20200923 MN 92100 1231851   1873867 303 7303 148 2045     83507 A 9/22/2020 17:00 2020-09-22T17:00:00Z 09/22 13:00 2037 7303 2020-09-22T17:00:00Z       92100 1985 52 1873867 1323951                     27 678 5840 1323951 posNeg 10173 1323951 6 50 e4a6357a164b266f3ae54f792c3f00ed64cf025c 0 0 0 0 0  
201 201 20200923 NE 41785 389317   431102 197 2214         31212 A 9/22/2020 20:10 2020-09-22T20:10:00Z 09/22 16:10 461 2214 2020-09-22T20:10:00Z 580140     41785       431401                     31 397 2659 431102 posNeg 3056 431102 9 6 0e13b9b23a5d3735181e9d4e91f3dd5c38b0d61a 0 0 0 0 0  
206 206 20200923 NY 451892 9683800   10135692 490 89995 141   68   76306 A 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 25437 89995 2020-09-22T23:59:00Z       451892     10135692                       36 665 70265 10135692 posNeg 70930 10135692 5 0 73a23ab7c0b6b78e67d67b6925fc08a799485733 0 0 0 0 0  
214 214 20200923 SD 19634 160498   180132 192 1367         16324 A 9/22/2020 14:00 2020-09-22T14:00:00Z 09/22 10:00 202 1367 2020-09-22T14:00:00Z 250393             180132                     46 445 1341 180132 posNeg 1786 180132 0 44 0b9b24e3e38af8930d497fead940060bba18ffa9 0 0 0 0 0  
216 216 20200923 TX 719599 5021075   5740674 3195   1041       618054 A 9/23/2020 18:15 2020-09-23T18:15:00Z 09/23 14:15 15129   2020-09-23T18:15:00Z 5740674     719599         390538 35217             76275 9003 48 3392 69550 5740674 posNeg 72942 5740674 135 0 b782ae3cef51213c4192af8df10043e5459198fc 0 0 0 0 0  
226 226 20200922 AL 146584 933565   1065553 796 16604   1659   910 61232 A 9/22/2020 11:00 2020-09-22T11:00:00Z 09/22 07:00 2457 16604 2020-09-22T11:00:00Z 1065553     131988 2304 153           57042             1 804 5453 1080149 posNeg 6036 1080149 18 117 536eaa13e29a33e56ab8f49589c94d7bd8cd3164 0 0 0 0 0  
231 231 20200922 CO 65399 773485   1219137 239 7373         6306 A 9/21/2020 01:59 2020-09-21T01:59:00Z 09/20 21:59 1914 7373 2020-09-21T01:59:00Z       60792     1219137 834277 166809 11624 155187               8 542 5633 838884 totalTestEncountersViral 10712 838884 1 10 acbe7e6b873d2efee74c91deb30171e27b8cb2ff 0 0 0 0 0  
237 237 20200922 GU 2190 44638   46828 39   15       1507 A 9/22/2020 05:00 2020-09-22T05:00:00Z 09/22 01:00 37   2020-09-22T05:00:00Z 46826     2190       46828 175 3                 66 43 431 46828 posNeg 474 46828 2 0 523d2166c95d1ed8aa2277f30ce21a4bccd1d7ea 0 0 0 0 0  
240 240 20200922 ID 37901 256170   290911 130 1726 39 446     20485 A 9/21/2020 19:00 2020-09-21T19:00:00Z 09/21 15:00 447 1726 2020-09-21T19:00:00Z 290911     34741 409 38                         16 410 1375 294071 posNeg 1748 294071 4 8 1a603f1797ebcd309b94a231012b903983916480 0 0 0 0 0  
241 241 20200922 IL 279464 4907950   5187414 1455   367   153     A 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 8722   2020-09-22T00:00:00Z 5185216     277266 8486 236                         17 1531 40298 5187414 posNeg 41829 5187414 29 0 b6f9bcb423a5a7b482e8705c7adb5902253e03f2 0 0 0 0 0  
245 245 20200922 LA 163253 2043721   2206974 571       96   145570 A 9/22/2020 13:00 2020-09-22T13:00:00Z 09/22 09:00 5386   2020-09-22T13:00:00Z       162214 5218 168   2205935                     22 752 20430 2206974 posNeg 21182 2206974 11 0 baf9e173a10d54222f081d7fc06de8be1125960e 0 0 0 0 0  
250 250 20200922 MN 91422 1226011   1863694 290 7253 136 2027     82833 A 9/21/2020 17:00 2020-09-21T17:00:00Z 09/21 13:00 2031 7253 2020-09-21T17:00:00Z       91422 1979 52 1863694 1317433                     27 480 4016 1317433 posNeg 8386 1317433 10 54 56118ea7ee0df16bc167138e94e47ef52f3c1ed7 0 0 0 0 0  
257 257 20200922 NE 41388 386658   428046 185 2208         31047 A 9/21/2020 20:15 2020-09-21T20:15:00Z 09/21 16:15 452 2208 2020-09-21T20:15:00Z 575663     41388       428341                     31 305 1925 428046 posNeg 2230 428046 10 14 c615677353b2deb442433568311259aa4a254500 0 0 0 0 0  
262 262 20200922 NY 451227 9613535   10064762 470 89995 133   67   76246 A 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 25432 89995 2020-09-21T23:59:00Z       451227     10064762                       36 754 83243 10064762 posNeg 83997 10064762 4 0 acfffc57985c0dd288e364f084a74119a9415495 0 0 0 0 0  
270 270 20200922 SD 19189 159157   178346 178 1323         16170 A 9/21/2020 14:00 2020-09-21T14:00:00Z 09/21 10:00 202 1323 2020-09-21T14:00:00Z 247705             178346                     46 320 1003 178346 posNeg 1323 178346 0 26 02e039c062b3c1abf1d36f6dfbc56777cc891c9b 0 0 0 0 0  
272 272 20200922 TX 716207 4951525   5667732 3207   1065       613896 A 9/22/2020 17:40 2020-09-22T17:40:00Z 09/22 13:40 14994   2020-09-22T17:40:00Z 5667732     716207         389207 35026             71209 8712 48 17820 27414 5667732 posNeg 45234 5667732 77 0 ec32538028149c4d87f0cba67742d94fbd369fb5 0 0 0 0 0  
282 282 20200921 AL 145780 928112   1059517 802 16487   1645   904 61232 A 9/21/2020 11:00 2020-09-21T11:00:00Z 09/21 07:00 2439 16487 2020-09-21T11:00:00Z 1059517     131405 2292 147           56961             1 818 4746 1073892 posNeg 5500 1073892 2 260 7570e181bedab66c64605b577126d7e6c27c0be7 0 0 0 0 0  
287 287 20200921 CO 64857 767852   1208425 239 7363         6291 A 9/20/2020 01:59 2020-09-20T01:59:00Z 09/19 21:59 1913 7363 2020-09-20T01:59:00Z       60256     1208425 828108 166546 11600 154948               8 501 6506 832709 totalTestEncountersViral 13046 832709 0 6 dfa726f7daf8d6b4a08ccf6210e93e7c20ea0fd4 0 0 0 0 0  
293 293 20200921 GU 2147 44207   46354 38   18       1505 A 9/21/2020 09:00 2020-09-21T09:00:00Z 09/21 05:00 35   2020-09-21T09:00:00Z 46352     2147       46354 175 3                 66 30 366 46354 posNeg 396 46354 1 0 b64988c77058946a81407403f79ac72214ba9a4f 0 0 0 0 0  
296 296 20200921 ID 37491 254795   289163 146 1718 51 443     20304 A 9/20/2020 19:00 2020-09-20T19:00:00Z 09/20 15:00 443 1718 2020-09-20T19:00:00Z 289163     34368 405 38                         16 244 2114 292286 posNeg 2333 292286 2 7 7970b84c1239db78b3ab6042de39562ba29b2baf 0 0 0 0 0  
297 297 20200921 IL 277933 4867652   5145585 1436   364   153     A 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 8693   2020-09-21T00:00:00Z 5143387     275735 8457 236                         17 1477 36757 5145585 posNeg 38234 5145585 7 0 7eabde416f68cefad780ba3a7055efee30a84a5f 0 0 0 0 0  
301 301 20200921 LA 162501 2023291   2185792 587       93   145570 A 9/21/2020 13:00 2020-09-21T13:00:00Z 09/21 09:00 5375   2020-09-21T13:00:00Z       161462 5207 168   2184753                     22 243 6550 2185792 posNeg 6793 2185792 9 0 159fff8d9db66a9011e2387fc5fa7da5c2cf5b19 0 0 0 0 0  
306 306 20200921 MN 90942 1221995   1855308 255 7199 128 2014     82174 A 9/20/2020 17:00 2020-09-20T17:00:00Z 09/20 13:00 2021 7199 2020-09-20T17:00:00Z       90942 1969 52 1855308 1312937                     27 925 8537 1312937 posNeg 16916 1312937 4 36 db89a01668c24828b0aca9bd2b3e195ea0a7e28c 0 0 0 0 0  
313 313 20200921 NE 41083 384733   425816 170 2194         30509 A 9/20/2020 20:15 2020-09-20T20:15:00Z 09/20 16:15 442 2194 2020-09-20T20:15:00Z 562886     41083       426110                     31 286 2170 425816 posNeg 2456 425816 0 0 b8f0be6057e416e8420936ad54493d4b03355818 0 0 0 0 0  
318 318 20200921 NY 450473 9530292   9980765 468 89995 134   66   76218 A 9/20/2020 23:59 2020-09-20T23:59:00Z 09/20 19:59 25428 89995 2020-09-20T23:59:00Z       450473     9980765                       36 573 57746 9980765 posNeg 58319 9980765 1 0 6e223bb0204780c57bf975ab107522993c6290f8 0 0 0 0 0  
326 326 20200921 SD 18869 158154   177023 161 1297         15777 A 9/20/2020 14:00 2020-09-20T14:00:00Z 09/20 10:00 202 1297 2020-09-20T14:00:00Z 245387             177023                     46 173 497 177023 posNeg 670 177023 0 9 de8ce40f2ca507606ebfad5913ea49564ff9fe7c 0 0 0 0 0  
328 328 20200921 TX 698387 4924111   5622498 3132   1073       611856 A 9/21/2020 17:45 2020-09-21T17:45:00Z 09/21 13:45 14917   2020-09-21T17:45:00Z 5622498     698387         386966 34843             64302 7867 48 9853 19157 5622498 posNeg 29010 5622498 24 0 09a4609909a8385823119af6254c78b7c8391951 0 0 0 0 0  
338 338 20200920 AL 144962 923366   1054017 780 16227   1643   904 61232 A 9/19/2020 11:00 2020-09-19T11:00:00Z 09/19 07:00 2437 16227 2020-09-19T11:00:00Z 1054017     130651 2290 147           56887             1 798 4918 1068328 posNeg 5595 1068328 0 0 1068eacf936cf84dc1349d453d2454fa7e85ffa1 0 0 0 0 0  
343 343 20200920 CO 64356 761346   1195379 237 7357         6274 A 9/20/2020 01:59 2020-09-20T01:59:00Z 09/19 21:59 1913 7357 2020-09-20T01:59:00Z       59782     1195379 821128 166196 11568 154630               8 606 7227 825702 totalTestEncountersViral 13550 825702 0 10 53538ff2d6fb07c9a2a5be3d98b592c35770bf7b 0 0 0 0 0  
349 349 20200920 GU 2117 43841   45958 36   19       1450 A 9/19/2020 04:15 2020-09-19T04:15:00Z 09/19 00:15 34   2020-09-19T04:15:00Z 45651     2117       45958 172 3                 66 0 0 45958 posNeg 0 45958 0 0 3bfc034531cffc78d480c081bb28d9a8b2c7b492 0 0 0 0 0  
352 352 20200920 ID 37247 252681   286830 146 1711 51 442     20105 A 9/19/2020 19:00 2020-09-19T19:00:00Z 09/19 15:00 441 1711 2020-09-19T19:00:00Z 286830     34149 403 38                         16 288 1445 289928 posNeg 1693 289928 3 10 aee2dbb7f50bc2dc4a5028e8655b462335f3f042 0 0 0 0 0  
353 353 20200920 IL 276456 4830895   5107351 1417   357   151     A 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 8686   2020-09-20T00:00:00Z 5105153     274258 8450 236                         17 1402 46609 5107351 posNeg 48011 5107351 14 0 a3869b881ecc0914920947ed7fde97b852eb1c8c 0 0 0 0 0  
357 357 20200920 LA 162258 2016741   2178999 596       100   145570 A 9/20/2020 13:00 2020-09-20T13:00:00Z 09/20 09:00 5366   2020-09-20T13:00:00Z       161219 5198 168   2177960                     22 936 31077 2178999 posNeg 32013 2178999 26 0 82b0b98d88e3e5bfbaa0a9c96621398de54bcfef 0 0 0 0 0  
362 362 20200920 MN 90017 1213458   1838392 248 7163 123 2004     81336 A 9/19/2020 17:00 2020-09-19T17:00:00Z 09/19 13:00 2017 7163 2020-09-19T17:00:00Z       90017 1965 52 1838392 1303475                     27 1296 10784 1303475 posNeg 22618 1303475 2 39 7cfa69a9e4816c0ee53bc75297647466de402a8c 0 0 0 0 0  
369 369 20200920 NE 40797 382563   423360 174 2194         30509 A 9/19/2020 20:15 2020-09-19T20:15:00Z 09/19 16:15 442 2194 2020-09-19T20:15:00Z       40797       423653                     31 410 2955 423360 posNeg 3365 423360 0 0 4324820c2c1ca25ea8d669e12254eaa0da5926c8 0 0 0 0 0  
374 374 20200920 NY 449900 9472546   9922446 468 89995 132   60   76179 A 9/19/2020 23:59 2020-09-19T23:59:00Z 09/19 19:59 25427 89995 2020-09-19T23:59:00Z       449900     9922446                       36 862 99493 9922446 posNeg 100355 9922446 2 0 b9792dc99d6549db085101b4cec82e1ef562405f 0 0 0 0 0  
382 382 20200920 SD 18696 157657   176353 170 1288         15651 A 9/19/2020 14:00 2020-09-19T14:00:00Z 09/19 10:00 202 1288 2020-09-19T14:00:00Z 244278             176353                     46 252 880 176353 posNeg 1132 176353 2 20 7f316b59b9e5f7bcb8eced5b7ae07e78c3082b46 0 0 0 0 0  
384 384 20200920 TX 688534 4904954   5593488 3081   1057       609210 A 9/20/2020 15:50 2020-09-20T15:50:00Z 09/20 11:50 14893   2020-09-20T15:50:00Z 5593488     688534         385351 34639             63908 7793 48 2466 27846 5593488 posNeg 30312 5593488 45 0 dda19cfcd03fde717fc7185489907e372c264b25 0 0 0 0 0  
394 394 20200919 AL 144164 918448   1048422 747 16227   1642   904 61232 A 9/19/2020 11:00 2020-09-19T11:00:00Z 09/19 07:00 2437 16227 2020-09-19T11:00:00Z 1048422     129974 2290 147           56797             1 1301 8256 1062612 posNeg 9412 1062612 9 0 64c7250a6485aa99e27f2c992ccc8a1ab0711b29 0 0 0 0 0  
399 399 20200919 CO 63750 754119   1181829 230 7347         6254 A 9/19/2020 01:59 2020-09-19T01:59:00Z 09/18 21:59 1913 7347 2020-09-19T01:59:00Z       59236     1181829 813355 165511 11507 154006               8 605 8023 817869 totalTestEncountersViral 14919 817869 2 20 0af822cd69de7384f1b02c950ec6ffc747fc3ef2 0 0 0 0 0  
405 405 20200919 GU 2117 43841   45958 36   19       1450 A 9/19/2020 04:15 2020-09-19T04:15:00Z 09/19 00:15 34   2020-09-19T04:15:00Z 45651     2117       45958 172 3                 66 43 262 45958 posNeg 305 45958 1 0 b2bbb8ab5dc2c0db6321584a22ff5a81b07ddf36 0 0 0 0 0  
408 408 20200919 ID 36959 251236   285137 146 1701 51 441     19915 A 9/18/2020 19:00 2020-09-18T19:00:00Z 09/18 15:00 438 1701 2020-09-18T19:00:00Z 285137     33901 400 38                         16 470 2173 288195 posNeg 2615 288195 4 19 872e39ba1f6f6ad7e2a7797252896aa750c164ce 0 0 0 0 0  
409 409 20200919 IL 275054 4784286   5059340 1469   326   141     A 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 8672   2020-09-19T00:00:00Z 5057142     272856 8436 236                         17 2529 71757 5059340 posNeg 74286 5059340 25 0 32550bb10c4afce614d8a9dffbd0406a4096c53b 0 0 0 0 0  
413 413 20200919 LA 161322 1985664   2146986 647       104   145570 A 9/18/2020 13:00 2020-09-18T13:00:00Z 09/18 09:00 5340   2020-09-18T13:00:00Z       160283 5172 168   2145947                     22 0 0 2146986 posNeg 0 2146986 0 0 391142daaa1979e017147041a56a46a716e7789a 0 0 0 0 0  
418 418 20200919 MN 88721 1202674   1815774 241 7124 134 1998     80407 A 9/18/2020 17:00 2020-09-18T17:00:00Z 09/18 13:00 2015 7124 2020-09-18T17:00:00Z       88721 1963 52 1815774 1291395                     27 914 11644 1291395 posNeg 24094 1291395 13 33 1db0b414c0ce4669343adec103dd182202b3a92d 0 0 0 0 0  
425 425 20200919 NE 40387 379608   419995 185 2194         30509 A 9/18/2020 20:15 2020-09-18T20:15:00Z 09/18 16:15 442 2194 2020-09-18T20:15:00Z       40387       420291                     31 466 2954 419995 posNeg 3420 419995 0 13 2d4c032f39cb806a0f4c8bcbec431096100f0dd5 0 0 0 0 0  
430 430 20200919 NY 449038 9373053   9822091 467 89995 144   60   76101 A 9/18/2020 23:59 2020-09-18T23:59:00Z 09/18 19:59 25425 89995 2020-09-18T23:59:00Z       449038     9822091                       36 986 109458 9822091 posNeg 110444 9822091 2 0 6428fa42a0444dfe549a7a14c8e0e10ffbb91404 0 0 0 0 0  
438 438 20200919 SD 18444 156777   175221 153 1268         15298 A 9/18/2020 14:00 2020-09-18T14:00:00Z 09/18 10:00 200 1268 2020-09-18T14:00:00Z 241274             175221                     46 369 1148 175221 posNeg 1517 175221 2 22 5fb8bd8a59cc7428807120b134b39e0d184b288f 0 0 0 0 0  
440 440 20200919 TX 686068 4877108   5563176 3124   1083       605522 A 9/19/2020 17:05 2020-09-19T17:05:00Z 09/19 13:05 14848   2020-09-19T17:05:00Z 5563176     686068         383876 34415             62291 7637 48 3827 114548 5563176 posNeg 118375 5563176 135 0 6abf1f916bb035d7b3b65674f2a272034880d0b7 0 0 0 0 0  
450 450 20200918 AL 142863 910192   1039010 744 16227   1638   904 61232 A 9/18/2020 11:00 2020-09-18T11:00:00Z 09/18 07:00 2428 16227 2020-09-18T11:00:00Z 1039010     128818 2284 144           56411             1 1106 7036 1053055 posNeg 7757 1053055 27 148 1d80c9982122b8a5e07be65d84c08ac3b4d4e74e 0 0 0 0 0  
455 455 20200918 CO 63145 746096   1166910 213 7327         6241 A 9/18/2020 01:59 2020-09-18T01:59:00Z 09/17 21:59 1911 7327 2020-09-18T01:59:00Z       58671     1166910 804767 164905 11458 153449               8 459 6860 809241 totalTestEncountersViral 13057 809241 6 39 fd250a6a61df3496a50c9cf3a212276715207ee8 0 0 0 0 0  
461 461 20200918 GU 2074 43579   45653 41   19       1450 A 9/18/2020 07:45 2020-09-18T07:45:00Z 09/18 03:45 33   2020-09-18T07:45:00Z 45651     2074       45653 172 3                 66 29 371 45653 posNeg 400 45653 2 0 937b292bf06af47e14edfe4fcb14b3d9cd001acd 0 0 0 0 0  
464 464 20200918 ID 36489 249063   282522 123 1682 54 438     19691 A 9/17/2020 19:00 2020-09-17T19:00:00Z 09/17 15:00 434 1682 2020-09-17T19:00:00Z 282522     33489 396 38                         16 396 1791 285552 posNeg 2096 285552 5 24 3f6e318d2808a0d59d93fdb43dde97df5692ae7f 0 0 0 0 0  
465 465 20200918 IL 272525 4712529   4985054 1481   329   149     A 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 8647   2020-09-18T00:00:00Z 4982856     270327 8411 236                         17 2223 59798 4985054 posNeg 62021 4985054 23 0 af55c41602ff46bc3ee72471de976cc506bdf854 0 0 0 0 0  
469 469 20200918 LA 161322 1985664   2146986 647       104   145570 A 9/18/2020 13:00 2020-09-18T13:00:00Z 09/18 09:00 5340   2020-09-18T13:00:00Z       160283 5172 168   2145947                     22 979 21817 2146986 posNeg 22796 2146986 29 0 a240b9935efd335f467f94404a8006b6c051c52f 0 0 0 0 0  
474 474 20200918 MN 87807 1191030   1791680 250 7091 136 1990     80221 A 9/17/2020 17:00 2020-09-17T17:00:00Z 09/17 13:00 2002 7091 2020-09-17T17:00:00Z       87807 1950 52 1791680 1278837                     27 1085 14206 1278837 posNeg 27945 1278837 8 41 35f8e28594418956ee8585a44d57ac3368e380b5 0 0 0 0 0  
481 481 20200918 NE 39921 376654   416575 188 2181         30254 A 9/17/2020 20:15 2020-09-17T20:15:00Z 09/17 16:15 442 2181 2020-09-17T20:15:00Z       39921       416868                     31 502 3222 416575 posNeg 3724 416575 3 9 27013ee19c40c247efff0fea3b5530c089fe26a3 0 0 0 0 0  
486 486 20200918 NY 448052 9263595   9711647 478 89995 141   62   76036 A 9/17/2020 23:59 2020-09-17T23:59:00Z 09/17 19:59 25423 89995 2020-09-17T23:59:00Z       448052     9711647                       36 790 88937 9711647 posNeg 89727 9711647 10 0 484099c5cadb392fbd9a1cdd91d0dfbb3d880cf9 0 0 0 0 0  
494 494 20200918 SD 18075 155629   173704 144 1246         15068 A 9/17/2020 14:00 2020-09-17T14:00:00Z 09/17 10:00 198 1246 2020-09-17T14:00:00Z 238466             173704                     46 389 1792 173704 posNeg 2181 173704 5 15 1991d871203fa3a731bb11701b13dc8666d44c79 0 0 0 0 0  
496 496 20200918 TX 682241 4762560   5444801 3172   1107       600662 A 9/18/2020 16:25 2020-09-18T16:25:00Z 09/18 12:25 14713   2020-09-18T16:25:00Z 5444801     682241         381430 34084             59051 7439 48 3422 96203 5444801 posNeg 99625 5444801 123 0 01ae553b738298729e92c53cb9456c4aedf80ecf 0 0 0 0 0  
506 506 20200917 AL 141757 903156   1031253 740 16079   1631   900 61232 A 9/17/2020 11:00 2020-09-17T11:00:00Z 09/17 07:00 2401 16079 2020-09-17T11:00:00Z 1031253     128097 2264 137           56181             1 670 3472 1044913 posNeg 4046 1044913 9 137 d341c5071b10d5c26014930058cee8087a90240e 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
);