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

11,578 rows

View and edit SQL

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
101 20200925 SC 143902 1082565   1226467 773 8994 191   101   68854 A+ 9/24/2020 11:59 2020-09-24T11:59:00Z 09/24 07:59 3297 8994 2020-09-24T11:59:00Z 1222621 179372 1043249 140056 3114 183     70135 6666 63469           38650 9856 45 1195 18166 1226467 posNeg 19361 1226467 18 49 dac30dba064927944a34105b6119a298f4fc93eb 0 0 0 0 0  
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  
103 20200925 TN 189454 2573391   2762845 838 8477 250   119   172618 A+ 9/25/2020 15:00 2020-09-25T15:00:00Z 09/25 11:00 2352 8477 2020-09-25T15:00:00Z 2755933 222922 2533011 182542 2262 90                         47 1910 31547 2762845 posNeg 33457 2762845 42 64 6e5bd30f8591d29e868d2f3384695c4a34f99ed2 0 0 0 0 0  
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  
105 20200925 UT 68530 726687   795217 190 3668 76 886   357 53360 A+ 9/25/2020 10:00 2020-09-25T10:00:00Z 09/25 06:00 448 3668 2020-09-25T10:00:00Z 1022373     68530       795217             13019 1744 22051 1849 49 1411 8831 795217 posNeg 10242 795217 4 49 64de267e9efce24d685811bca126261a456578c5 0 0 0 0 0  
106 20200925 VA 144433 1836216 348 1973499 965 18150 221   117   17185 A+ 9/24/2020 17:00 2020-09-24T17:00:00Z 09/24 13:00 3136 18150 2020-09-24T17:00:00Z   163973   137283 2930 206 1973499                       51 941 19699 1980997 posNeg 20534 1980649 23 69 abf66257fc88aa4f57dbd6a79f558fc52f693911 0 0 0 0 0  
107 20200925 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 6 142 19980 posNeg 148 19972 0 0 fae7c9c388a0a44bc2800e78f8691ac3df144574 0 0 0 0 0  
108 20200925 VT 1731 157548   159279 2           1576 B 9/24/2020 23:59 2020-09-24T23:59:00Z 09/24 19:59 58   2020-09-24T23:59:00Z       1731 58     159279                     50 7 1083 159279 posNeg 1090 159279 0 0 35ade9c048124510cd07e6d14c9e8b135013a5b5 0 0 0 0 0  
109 20200925 WA 84238 1699041   1783279 269 7357     27     B 9/24/2020 02:59 2020-09-24T02:59:00Z 09/23 22:59 2080 7357 2020-09-24T02:59:00Z       84238 2080   1783279                       53 536 39447 1783279 posNeg 39983 1783279 -1 8 b20315f05b02137d7784fd47a15207d79a2b7a72 0 0 0 0 0  
110 20200925 WI 117329 1383645 194 1500974 543 6962 147 1150     92366 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 1284 6962 2020-09-25T00:00:00Z       110828 1274 10   1494473                     55 2629 12575 1501168 posNeg 15204 1500974 9 65 9bde6a037be3166d9009d957523328c97e057c9a 0 0 0 0 0  
111 20200925 WV 14953 520441   535394 177   59   31   10968 C 9/24/2020 23:59 2020-09-24T23:59:00Z 09/24 19:59 330   2020-09-24T23:59:00Z 535018     14577 327 3     17164                   54 247 6122 535394 posNeg 6369 535394 5 0 bba94c76334f9ad4813ce60d939fcf03baefc731 0 0 0 0 0  
112 20200925 WY 5420 92406   97826 22 256         4450 B 9/25/2020 17:57 2020-09-25T17:57:00Z 09/25 13:57 50 256 2020-09-25T17:57:00Z 155082 4497 150584 4585       96991                     56 115 1071 97826 posNeg 1186 97826 0 1 7350ff7f9a9be2f541c3b57336f447df2bb18f2b 0 0 0 0 0  
113 20200924 AK 7941 425257   433198 43       14   2731 A 9/23/2020 03:59 2020-09-23T03:59:00Z 09/22 23:59 45   2020-09-23T03:59:00Z 433198 7180 425736 7941 45                           2 0 0 433198 posNeg 0 433198 0 0 b83363bdfb4b0d19318d00489c44e906270412f1 0 0 0 0 0  
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  
115 20200924 AR 79049 840737   917413 450 5160 216   97 650 70737 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 1246 5160 2020-09-24T00:00:00Z 917413   840737 76676 1097 149                 10922 2566 21856 3300 5 1086 9436 919786 posNeg 10466 919786 17 62 3bb6b474a294e70889229d31b3d1615e78236173 0 0 0 0 0  
116 20200924 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 f949dd0d4f1a5cc85607dc1e308d0088f67199bd 0 0 0 0 0  
117 20200924 AZ 215852 1204565   1415991 565 21942 122   64   34393 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 5559 21942 2020-09-24T00:00:00Z       211426 5291 268   1415991 289012                   4 568 9983 1420417 posNeg 10489 1420417 34 17 a7df3bcd951a8954fb14b1f779be78d2dc804761 0 0 0 0 0  
118 20200924 CA 790640 13162217   13952857 3484   914         B 9/24/2020 02:59 2020-09-24T02:59:00Z 09/23 22:59 15314   2020-09-24T02:59:00Z 13952857     790640                             6 3170 70264 13952857 posNeg 73434 13952857 110 0 87788642c4d9f1deb4ce4c35adb758e1c0e423f1 0 0 0 0 0  
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  
120 20200924 CT 56472 1449001   1505473 72 11560         9310 B 9/23/2020 20:30 2020-09-23T20:30:00Z 09/23 16:30 4499 11560 2020-09-23T20:30:00Z 1503114     54113 3603 896                         9 157 15418 1505473 posNeg 15575 1505473 2 113 5ac1bb9f7c4c52c57a96185001fa5c67510a5d7d 0 0 0 0 0  
121 20200924 DC 15106 352761   367867 97   29   21   11956 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 621   2020-09-23T00:00:00Z             367867 208447                     11 56 4363 367867 posNeg 4419 367867 0 0 cfa83b179fdc03e18f7806a851999d383d6a1e27 0 0 0 0 0  
122 20200924 DE 19947 257969   277916 57   12       10487 A+ 9/23/2020 18:00 2020-09-23T18:00:00Z 09/23 14:00 630   2020-09-23T18:00:00Z       18916 553 77   277916                     10 117 1755 277916 posNeg 1872 277916 1 0 eccf8936aa2afa0f79741776f2ae077e230321be 0 0 0 0 0  
123 20200924 FL 693040 4486459 4001 5179499 2169 43621           A 9/23/2020 23:59 2020-09-23T23:59:00Z 09/23 19:59 13961 43621 2020-09-23T23:59:00Z 7289544 892098 6356072 693040 13961     5186646 505164 45080 460024 493810 44075 449702   15805     12 2541 20978 5183500 posNeg 23519 5179499 179 188 9ad7ae44516fdc7743bd1f78c65ed3eec272f913 0 0 0 0 0  
124 20200924 GA 311046 2535146   2824816 1932 27903   5120       A 9/24/2020 14:50 2020-09-24T14:50:00Z 09/24 10:50 6822 27903 2020-09-24T14:50:00Z 2824816 289670 2535146 311046         297531 24436                 13 1368 41609 2846192 posNeg 21601 2846192 49 154 0f933d959819f7f840599ea74b82abe82c0da401 0 0 0 0 0  
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  
126 20200924 HI 11689 275096   286785 162 763 54   34   5125 B 9/23/2020 18:00 2020-09-23T18:00:00Z 09/23 14:00 122 763 2020-09-23T18:00:00Z 395503             286785                     15 167 2549 286785 posNeg 2716 286785 2 14 efaf756afea8e54e975894c70e461405d9657fc7 0 0 0 0 0  
127 20200924 IA 81071 657509   738580 305   79   37   61509 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 1302   2020-09-24T00:00:00Z       81071       740125       57067 3357 53670 19784 2511     19 1148 5579 738580 posNeg 6727 738580 8 0 153ba1e54208eacf18c27936aab903279e5bd037 0 0 0 0 0  
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 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  
130 20200924 IN 114236 1217372   1331608 840 12388 261 2462 83   90979 A+ 9/23/2020 23:59 2020-09-23T23:59:00Z 09/23 19:59 3548 12388 2020-09-23T23:59:00Z 1937499       3322 226   1331608                     18 899 7890 1331608 posNeg 8789 1331608 18 76 bc498fabfcaf85bf45eaebc655d606fba2c3a068 0 0 0 0 0  
131 20200924 KS 55226 437055   492281 313 2766 93 753 27 240 2008 A+ 9/23/2020 10:00 2020-09-23T10:00:00Z 09/23 06:00 621 2766 2020-09-23T10:00:00Z               492281                     20 0 0 492281 posNeg 0 492281 0 0 d7488a6af979bbb0b91f27f95ecee42279eafe8d 0 0 0 0 0  
132 20200924 KY 64158 1169777   1226385 543 5119 122 1499     11570 B 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 1137 5119 2020-09-24T00:00:00Z 1226385     56608 1128 9     52994               22028   21 641 9152 1233935 posNeg 9606 1233935 13 24 cb22d5c189e58bd2c0469f552c2494549bdec7c0 0 0 0 0 0  
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  
134 20200924 MA 128993 2017533   3642716 375 12606 75   29   111479 A+ 9/24/2020 08:00 2020-09-24T08:00:00Z 09/24 04:00 9362 12606 2020-09-24T08:00:00Z 3642716 166664   126863 9150 212   2144396       119164     122954       25 481 18101 2146526 totalTestsViral 85168 2146526 15 14 23ad52c2cf714d2f53dfac5f1a7457f950036192 0 0 0 0 0  
135 20200924 MD 121800 1439779   1561579 349 15299 81       7416 A 9/24/2020 10:00 2020-09-24T10:00:00Z 09/24 06:00 3909 15299 2020-09-24T10:00:00Z 2464927 145786   121800 3765 144   1561579                     24 503 8971 1561579 posNeg 9474 1561579 7 31 3050a0b1c013bd177ff328e1c1d10b21f0972678 0 0 0 0 0  
136 20200924 ME 5215 394751   399966 14 442 1   0   4478 A+ 9/23/2020 23:59 2020-09-23T23:59:00Z 09/23 19:59 140 442 2020-09-23T23:59:00Z 399428 6470 392670 4677 139 1     10241 515 9712               23 44 13887 399966 posNeg 13931 399966 0 1 eccdb79332de9cd17c8655993f0694760e22be40 0 0 0 0 0  
137 20200924 MI 132337 3330487   3462824 558   139   50   90216 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 7019   2020-09-24T00:00:00Z 3498071 167584 3330487 119597 6700 319     288257                   26 1078 36639 3462824 posNeg 37717 3462824 6 0 bc6e3bf41679912f9b2784c2d9f309da47a99bb4 0 0 0 0 0  
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  
139 20200924 MO 118311 1141220   1259531 1056             B 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 1952   2020-09-24T00:00:00Z 1649352 124668 1521891 118311       1259531       73592 3462 70130         29 1365 13603 1259531 posNeg 14968 1259531 5 0 58f4538f1ae9ca884270e304aa3c24304c774a76 0 0 0 0 0  
140 20200924 MP 69 14776   14845   4         29 D 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 2 4 2020-09-23T00:00:00Z 19835     69 2     14845                     69 0 0 14845 posNeg 0 14845 0 0 6983d1e4b087aa16fbd32a6e21c9c17323b5690b 0 0 0 0 0  
141 20200924 MS 95310 626449   721759 631 5607 149   84   85327 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 2874 5607 2020-09-23T00:00:00Z 714852     88403 2651 223     37921 95             53678   28 737 4311 721759 posNeg 5048 721759 4 0 71ba7e57a4f3a3ebea2a9cccc5977b7c348ae2fc 0 0 0 0 0  
142 20200924 MT 11242 310276   321518 128 650         8634 C 9/24/2020 01:59 2020-09-24T01:59:00Z 09/23 21:59 165 650 2020-09-24T01:59:00Z 321518     11242                             30 330 4028 321518 posNeg 4358 321518 0 49 29f6da8c066b6aa586d59872f08c36388bd58b3c 0 0 0 0 0  
143 20200924 NC 198189 2672002   2870191 902   279       176422 A+ 9/24/2020 11:50 2020-09-24T11:50:00Z 09/24 07:50 3356   2020-09-24T11:50:00Z 2870191     198189 3356                           37 1688 26076 2870191 posNeg 27764 2870191 40 0 bd48aeb2d64854f81b295b3e8c2e220849c5da68 0 0 0 0 0  
144 20200924 ND 19451 213662   582104 89 777 26 194     15757 B 9/24/2020 01:59 2020-09-24T01:59:00Z 09/23 21:59 156 777 2020-09-24T01:59:00Z 603207     19451 153 3 582104 233113 9259 412 8847               38 470 791 233113 totalTestEncountersViral 6625 233113 0 14 6fbb7a9c0e426dd94de8a322f661e93048ddb9e0 0 0 0 0 0  
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  
146 20200924 NH 8044 239107   417689 16 732   233     7325 B 9/24/2020 09:00 2020-09-24T09:00:00Z 09/24 05:00 438 732 2020-09-24T09:00:00Z 417689     8044       247151 31620     30901             33 37 2625 247151 posNeg 4298 247151 0 4 e462cbe416038e04426aa32cebd62ba86e43c2dd 0 0 0 0 0  
147 20200924 NJ 201552 3250252   3451804 433 23252 88   34   34650 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 16091 23252 2020-09-24T00:00:00Z 3451804     201552 14300 1791                         34 564 28493 3451804 posNeg 29057 3451804 9 37 35ee2617aec17b486b9705e1ad0a8b07995e09ec 0 0 0 0 0  
148 20200924 NM 27987 850419   878406 72 3388         15669 C 9/23/2020 17:51 2020-09-23T17:51:00Z 09/23 13:51 857 3388 2020-09-23T17:51:00Z 878406     27987                             35 197 5878 878406 posNeg 6075 878406 3 17 c987f1ef96fb1d36dee1a9e947c0b90ee731661b 0 0 0 0 0  
149 20200924 NV 77197 598291   675488 468   137   67   2062 A+ 9/24/2020 02:59 2020-09-24T02:59:00Z 09/23 22:59 1564   2020-09-24T02:59:00Z 1004215     77197       674482                     32 390 3174 675488 posNeg 3564 675488 8 0 2e52f008a9142237b60a1bfa2d1d8bb66a9879b4 0 0 0 0 0  
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  
151 20200924 OH 147744 2807971   2955715 586 15051 199 3228 105   127239 A+ 9/24/2020 14:00 2020-09-24T14:00:00Z 09/24 10:00 4715 15051 2020-09-24T14:00:00Z 2947603     139632 4414 301                         39 991 23525 2955715 posNeg 24516 2955715 28 74 09764de1026355412517c78f5a5355c9d8155622 0 0 0 0 0  
152 20200924 OK 81244 1045682 7430 1126926 593 6130 227       67807 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 981 6130 2020-09-24T00:00:00Z 1140178 92217 1045682 81244         76497 3764                 40 1083 11517 1134356 posNeg 12600 1126926 11 73 be0cd9d314ecd6133fa6c070aa4b544baaaab717 0 0 0 0 0  
153 20200924 OR 31865 618633   650498 187 2468 40   16   5484 A+ 9/24/2020 03:01 2020-09-24T03:01:00Z 09/23 23:01 539 2468 2020-09-24T03:01:00Z     618633 30316       648949                     41 362 4011 650498 posNeg 4373 650498 1 30 0bded36f05ebff8614600e10197fa9578b8dc623 0 0 0 0 0  
154 20200924 PA 153397 1803470   1956867 422       53   125785 A+ 9/24/2020 12:30 2020-09-24T12:30:00Z 09/24 08:30 8079   2020-09-24T12:30:00Z 2837537     148658       1952128                     42 853 13058 1956867 posNeg 13911 1956867 17 0 8ccf789695938e13170869897f83ca1be1317115 0 0 0 0 0  
155 20200924 PR 43842 305972   349814 364   65   33     C 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 627   2020-09-24T00:00:00Z 310546 7002 303412 21156 456 171       22686                 72 1182 0 349814 posNeg 1182 349814 10 0 3d20930a4ea5673184a533a4882fd441ec7e5d63 0 0 0 0 0  
156 20200924 RI 24311 303272   717047 94 2725 8   4   2278 A+ 9/24/2020 12:00 2020-09-24T12:00:00Z 09/24 08:00 1106 2725 2020-09-24T12:00:00Z   34111 682936 24311     717047 327583                     44 134 2329 327583 totalTestEncountersViral 10469 327583 4 12 8163bebdcf0bf1d5914944de06cb338a5392078e 0 0 0 0 0  
157 20200924 SC 142707 1064399   1207106 804 8945 194   106   68079 A+ 9/23/2020 16:25 2020-09-23T16:25:00Z 09/23 12:25 3279 8945 2020-09-23T16:25:00Z 1203420 178064 1025356 139021 3097 182     69862 6603 63259           36799 9726 45 1021 15501 1207106 posNeg 16522 1207106 17 39 f2d22087450aa5aabeb69dd24b93403ea70e0eb0 0 0 0 0 0  
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  
159 20200924 TN 187544 2541844   2729388 813 8413 260   114   171153 A+ 9/24/2020 15:00 2020-09-24T15:00:00Z 09/24 11:00 2310 8413 2020-09-24T15:00:00Z 2722637 220826 2501811 180793 2221 89                         47 835 15210 2729388 posNeg 16045 2729388 35 75 37381b8d841ad0d8c6ee8968fabf30144a77a287 0 0 0 0 0  
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  
161 20200924 UT 67119 717856   784975 216 3619 76 884   356 52860 A+ 9/24/2020 10:27 2020-09-24T10:27:00Z 09/24 06:27 444 3619 2020-09-24T10:27:00Z 1006493     67119       784975             12236 1716 20139 1818 49 1198 7919 784975 posNeg 9117 784975 0 35 1623fe48290c12821e3b1f127762f4e12ff4773a 0 0 0 0 0  
162 20200924 VA 143492 1816517 358 1952965 982 18081 219   112   17099 A+ 9/23/2020 17:00 2020-09-23T17:00:00Z 09/23 13:00 3113 18081 2020-09-23T17:00:00Z   163164   136448 2907 206 1952965                       51 902 29537 1960367 posNeg 30359 1960009 24 127 7d06b1a5b91697bfe65f4e36d3f0ff87acbdeef6 0 0 0 0 0  
163 20200924 VI 1290 18534 11 19824             1208 D 9/23/2020 18:43 2020-09-23T18:43:00Z 09/23 14:43 19   2020-09-23T18:43:00Z 19835       19                           78 12 194 19835 posNeg 206 19824 0 0 8b7638a28177fb9962b7b9184d719e608ce1b89f 0 0 0 0 0  
164 20200924 VT 1724 156465   158189 3           1566 B 9/23/2020 23:59 2020-09-23T23:59:00Z 09/23 19:59 58   2020-09-23T23:59:00Z       1724 58     158189                     50 2 924 158189 posNeg 926 158189 0 0 cd8aaac17eae4e4fa4d4c13c289ef9740c7a6860 0 0 0 0 0  
165 20200924 WA 83702 1659594   1743296 262 7349     27     B 9/23/2020 02:59 2020-09-23T02:59:00Z 09/22 22:59 2081 7349 2020-09-23T02:59:00Z       83702 2081   1743296                       53 509 1888 1743296 posNeg 2397 1743296 11 35 2d37896ce11d6bedecea95a4c9b0a0a06ea7c6da 0 0 0 0 0  
166 20200924 WI 114700 1371070 208 1485770 530 6897 151 1006     90726 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 1275 6897 2020-09-24T00:00:00Z       108324 1265 10   1479394                     55 2478 10887 1485978 posNeg 13365 1485770 7 76 c4fb4ded5d396fadfdb11552b1757251b1dff2b3 0 0 0 0 0  
167 20200924 WV 14706 514319   529025 173   57   30   10831 C 9/23/2020 23:59 2020-09-23T23:59:00Z 09/23 19:59 325   2020-09-23T23:59:00Z 528658     14339 323 2     17097                   54 202 3243 529025 posNeg 3445 529025 6 0 0d92e7d4a39de0e0558a4a587e700f03926d1e7a 0 0 0 0 0  
168 20200924 WY 5305 91335   96640 19 255         4364 B 9/24/2020 16:19 2020-09-24T16:19:00Z 09/24 12:19 50 255 2020-09-24T16:19:00Z 152846 4432 148413 4488       95823                     56 136 1511 96640 posNeg 1647 96640 0 2 430cb1f0bc658819345a258248c3f0238a26f889 0 0 0 0 0  
169 20200923 AK 7941 425257   433198 43       14   2731 A 9/23/2020 03:59 2020-09-23T03:59:00Z 09/22 23:59 45   2020-09-23T03:59:00Z 433198 7180 425736 7941 45                           2 55 1952 433198 posNeg 2007 433198 0 0 77a29837bdfd97f18040622b1984ee7b87e863b8 0 0 0 0 0  
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  
171 20200923 AR 77963 831301   906947 460 5098 221   89 640 69952 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 1229 5098 2020-09-23T00:00:00Z 906947   831301 75646 1080 149                 9453 2506 21856 3300 5 982 8076 909264 posNeg 8950 909264 20 43 052de2d72685a74636cebc28c54f51ef7a5c0bcb 0 0 0 0 0  
172 20200923 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 2c46457ee4f802b1f3f14dabbca92ccfbf5670d7 0 0 0 0 0  
173 20200923 AZ 215284 1194582   1405502 583 21925 114   62   34227 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 5525 21925 2020-09-23T00:00:00Z       210920 5258 267   1405502 287909                   4 438 8774 1409866 posNeg 9084 1409866 27 25 ea71577096578d1196ae3215a89eae372024a0f4 0 0 0 0 0  
174 20200923 CA 787470 13091953   13879423 3557   905         B 9/23/2020 02:59 2020-09-23T02:59:00Z 09/22 22:59 15204   2020-09-23T02:59:00Z 13879423     787470                             6 3146 72222 13879423 posNeg 75368 13879423 133 0 1463ec67a916e845ebd2cb9dcf143e860239b742 0 0 0 0 0  
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  
176 20200923 CT 56315 1433583   1489898 73 11447         9204 B 9/22/2020 20:30 2020-09-22T20:30:00Z 09/22 16:30 4497 11447 2020-09-22T20:30:00Z 1487552     53969 3601 896                         9 155 9919 1489898 posNeg 10074 1489898 1 0 fd801265d4129d464fc9360a20f5f415955c3023 0 0 0 0 0  
177 20200923 DC 15050 348398   363448 92   26   17   11929 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 621   2020-09-22T00:00:00Z             363448 206817                     11 29 1786 363448 posNeg 1815 363448 0 0 65567b387778c44895844720fe46362562407b0f 0 0 0 0 0  
178 20200923 DE 19830 256214   276044 61   12       10443 A+ 9/22/2020 18:00 2020-09-22T18:00:00Z 09/22 14:00 629   2020-09-22T18:00:00Z       18798 552 77   276044                     10 69 1138 276044 posNeg 1207 276044 1 0 cf27820b82a5ad385c931a4f1e49b1ae5d46c8ca 0 0 0 0 0  
179 20200923 FL 690499 4465481 3965 5155980 2254 43433           A 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 13782 43433 2020-09-22T23:59:00Z 7248950 888751 6318956 690499 13782     5163125 505164 45080 460024 493810 44075 449702   15438     12 2590 21048 5159945 posNeg 23638 5155980 203 172 77b163b303728ed31e5db5b7532b16a7bc5f6135 0 0 0 0 0  
180 20200923 GA 309678 2493537   2803215 1924 27749   5077       A 9/23/2020 14:50 2020-09-23T14:50:00Z 09/23 10:50 6773 27749 2020-09-23T14:50:00Z 2803215 287839 2515376 309678         296466 24258                 13 1457 18331 2803215 posNeg 19788 2803215 96 259 d9c14076295aafc160770ae7d6d217db1d6058ec 0 0 0 0 0  
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  
182 20200923 HI 11522 272547   284069 181 749 61   39   4992 B 9/22/2020 18:00 2020-09-22T18:00:00Z 09/22 14:00 120 749 2020-09-22T18:00:00Z 390003             284069                     15 63 1426 284069 posNeg 1489 284069 0 14 b17cb70b8c587e5a87507a57031b3b68b8a67511 0 0 0 0 0  
183 20200923 IA 79923 651930   731853 301   77   37   60350 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 1294   2020-09-23T00:00:00Z       79923       733400       56600 3345 53215 19021 2434     19 1036 5735 731853 posNeg 6771 731853 8 0 589e06e6feba425c24644cfff19a64e3b3ddc24a 0 0 0 0 0  
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 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  
186 20200923 IN 113337 1209482   1322819 815 12312 272 2448 78   90069 A+ 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 3530 12312 2020-09-22T23:59:00Z 1916433       3305 225   1322819                     18 711 6668 1322819 posNeg 7379 1322819 10 47 5249d8f9262b919348fe82470e9825e3ebd51ae4 0 0 0 0 0  
187 20200923 KS 55226 437055   492281 313 2766 93 753 27 240 2008 A+ 9/23/2020 10:00 2020-09-23T10:00:00Z 09/23 06:00 621 2766 2020-09-23T10:00:00Z               492281                     20 1267 6323 492281 posNeg 7590 492281 21 60 5489dc0b63fcb8091cf4bbc01fcb3a856ae9454c 0 0 0 0 0  
188 20200923 KY 63517 1160625   1216779 530 5095 123 1499     11480 B 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 1124 5095 2020-09-23T00:00:00Z 1216779     56154 1115 9     52939               21830   21 786 147736 1224142 posNeg 148313 1224142 5 20 f5ee5fea36480b454e9600c0ebf3aac3ee59d3d9 0 0 0 0 0  
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  
190 20200923 MA 128512 1999432   3557548 361 12592 71   26   111479 A+ 9/23/2020 08:00 2020-09-23T08:00:00Z 09/23 04:00 9347 12592 2020-09-23T08:00:00Z 3557548 166112   126408 9135 212   2125840       118843     121231       25 543 20120 2127944 totalTestsViral 80869 2127944 19 21 33bab77b286c693bcf962e8b65fda6c72e0e5917 0 0 0 0 0  
191 20200923 MD 121297 1430808   1552105 332 15268 79       7396 A 9/23/2020 10:00 2020-09-23T10:00:00Z 09/23 06:00 3902 15268 2020-09-23T10:00:00Z 2441225 145163   121297 3756 146   1552105                     24 385 7706 1552105 posNeg 8091 1552105 7 31 48a2c82225048377c10de20449a6238b97a224f4 0 0 0 0 0  
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  
193 20200923 MI 131259 3293848   3425107 501   146   58   90216 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 7013   2020-09-23T00:00:00Z 3460290 166442 3293848 118615 6692 321     287162                   26 902 33327 3425107 posNeg 34229 3425107 16 0 31f3951f689d05d3416dabd37842d31d1ba026b8 0 0 0 0 0  
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  
195 20200923 MO 116946 1127617   1244563 989             B 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 1947   2020-09-23T00:00:00Z 1633863 122803 1508256 116946       1244563       73234 3388 69846         29 1580 1234 1244563 posNeg 2814 1244563 83 0 3fe64a1c1b142ce9ad56681b8a79b81d26bb9f89 0 0 0 0 0  
196 20200923 MP 69 14776   14845   4         29 D 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 2 4 2020-09-22T00:00:00Z 19835     69 2     14845                     69 0 460 14845 posNeg 460 14845 0 0 8884c28f22aea04c24f174e0569788e75c824853 0 0 0 0 0  
197 20200923 MS 94573 622138   716711 620 5607 148   74   85327 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 2870 5607 2020-09-22T00:00:00Z 710040     87902 2647 223     37700 95             51862   28 552 3658 716711 posNeg 4210 716711 24 0 8e028eb9f3dd8f021d2b011b3b023bbc8ac7f5e2 0 0 0 0 0  
198 20200923 MT 10912 306248   317160 124 601         8510 C 9/23/2020 01:59 2020-09-23T01:59:00Z 09/22 21:59 165 601 2020-09-23T01:59:00Z 317160     10912                             30 212 2939 317160 posNeg 3151 317160 2 17 5a92332dd4f07d8b2e3b3d7cfb119a64e4184f55 0 0 0 0 0  
199 20200923 NC 196501 2645926   2842427 912   281       176422 A+ 9/23/2020 12:10 2020-09-23T12:10:00Z 09/23 08:10 3316   2020-09-23T12:10:00Z 2842427     196501 3316                           37 952 16546 2842427 posNeg 17498 2842427 30 0 eab415093f779d66efff5142a1c27684e8b8e044 0 0 0 0 0  
200 20200923 ND 18981 212871   575479 89 763 25 192     15476 B 9/23/2020 01:59 2020-09-23T01:59:00Z 09/22 21:59 156 763 2020-09-23T01:59:00Z 596181     18981 153 3 575479 231852 9259 412 8847               38 473 1309 231852 totalTestEncountersViral 6939 231852 0 11 0408d7c5efa7b614f87f1c92524aca20f1dc2f81 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
);