states_daily_4pm_et

Table actions

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

11,578 rows sorted by negativeTestsViral

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid date state positive negative pending totalTestResults hospitalizedCurrently hospitalizedCumulative inIcuCurrently inIcuCumulative onVentilatorCurrently onVentilatorCumulative recovered dataQualityGrade lastUpdateEt dateModified checkTimeEt death hospitalized dateChecked totalTestsViral positiveTestsViral negativeTestsViral ▼ positiveCasesViral deathConfirmed deathProbable totalTestEncountersViral totalTestsPeopleViral totalTestsAntibody positiveTestsAntibody negativeTestsAntibody totalTestsPeopleAntibody positiveTestsPeopleAntibody negativeTestsPeopleAntibody totalTestsPeopleAntigen positiveTestsPeopleAntigen totalTestsAntigen positiveTestsAntigen fips positiveIncrease negativeIncrease total totalTestResultsSource totalTestResultsIncrease posNeg deathIncrease hospitalizedIncrease hash commercialScore negativeRegularScore negativeScore positiveScore score grade
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  
134 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 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  
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  
140 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 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 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 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 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 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 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 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 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 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 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 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  
154 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  
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  
161 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 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 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 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 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 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 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  
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  
172 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 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 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 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 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 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 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  
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  
182 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 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 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  
186 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 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 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 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 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 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  
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  
196 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 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 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 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 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  
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  
202 202 20200923 NH 8007 236482   413391 17 728   230     7303 B 9/23/2020 09:00 2020-09-23T09:00:00Z 09/23 05:00 438 728 2020-09-23T09:00:00Z 413391     8007       244489 31557     30839             33 17 945 244489 posNeg 2925 244489 0 1 bdc274f7dd8d090cd62cec3f98303151a89c9f37 0 0 0 0 0  
203 203 20200923 NJ 200988 3221759   3422747 459 23215 90   31   34729 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 16082 23215 2020-09-23T00:00:00Z 3422747     200988 14291 1791                         34 408 24690 3422747 posNeg 25098 3422747 6 45 92c8ee2bfc81236413a9d6a9bdd8bf803bd15e3e 0 0 0 0 0  
204 204 20200923 NM 27790 844541   872331 69 3371         15586 C 9/22/2020 17:12 2020-09-22T17:12:00Z 09/22 13:12 854 3371 2020-09-22T17:12:00Z 872331     27790                             35 107 5541 872331 posNeg 5648 872331 3 13 ec22d7acf556db7867dc9b91942a0a7e6199b12d 0 0 0 0 0  
205 205 20200923 NV 76807 595117   671924 479   134   69   2059 A+ 9/23/2020 02:59 2020-09-23T02:59:00Z 09/22 22:59 1556   2020-09-23T02:59:00Z 996307     76807       670908                     32 509 2341 671924 posNeg 2850 671924 10 0 47d7118e5f6b480397adba20fe0cdaeb0d36e6d5 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  
207 207 20200923 OH 146753 2784446   2931199 593 14977 200 3218 113   126023 A+ 9/23/2020 14:00 2020-09-23T14:00:00Z 09/23 10:00 4687 14977 2020-09-23T14:00:00Z 2923158     138712 4387 300                         39 903 41509 2931199 posNeg 42412 2931199 52 78 2d9e1a6bf4a2598b57f9a3d554613fc62cfc0ac1 0 0 0 0 0  
210 210 20200923 PA 152544 1790412   1942956 421       54   123560 A+ 9/23/2020 12:00 2020-09-23T12:00:00Z 09/23 08:00 8062   2020-09-23T12:00:00Z 2809305     147862       1938274                     42 898 12496 1942956 posNeg 13394 1942956 39 0 3f5a6abc7bba96c41e5b1bec3d83c98576cc6d95 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  
217 217 20200923 UT 65921 709937   775858 190 3584 65 876   354 52357 A+ 9/23/2020 10:39 2020-09-23T10:39:00Z 09/23 06:39 444 3584 2020-09-23T10:39:00Z 993246     65921       775858             11768 1661 19120 1760 49 877 6022 775858 posNeg 6899 775858 1 34 533f79e51b72a89e18727bcef40b18d08ed5fda6 0 0 0 0 0  
218 218 20200923 VA 142590 1786980 298 1922606 916 17954 215   113   17038 A+ 9/22/2020 17:00 2020-09-22T17:00:00Z 09/22 13:00 3089 17954 2020-09-22T17:00:00Z   161672   135626 2882 207 1922606                       51 580 10501 1929868 posNeg 11026 1929570 29 35 96e4c34c318a0aca652c7411d5e196245393ff5a 0 0 0 0 0  
219 219 20200923 VI 1278 18340 7 19618             1198 D 9/22/2020 20:33 2020-09-22T20:33:00Z 09/22 16:33 19   2020-09-22T20:33:00Z 19625       19                           78 2 152 19625 posNeg 154 19618 0 0 7012dc1e4b73977908c498ce51625ee7d0f9f788 0 0 0 0 0  
220 220 20200923 VT 1722 155541   157263 2           1565 B 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 58   2020-09-22T23:59:00Z       1722 58     157263                     50 1 -79 157263 posNeg -78 157263 0 0 1fa2a67f67ae200bdf335fa8f4ff5f99f677857c 0 0 0 0 0  
221 221 20200923 WA 83193 1657706   1740899 277 7314     32     B 9/22/2020 02:59 2020-09-22T02:59:00Z 09/21 22:59 2070 7314 2020-09-22T02:59:00Z       83193 2070   1740899                       53 0 0 1740899 posNeg 0 1740899 0 0 7970bca4445cb328bfd49535798ea65bac25b905 0 0 0 0 0  
222 222 20200923 WI 112222 1360183 198 1472405 509 6821 140 998     89393 A+ 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 1268 6821 2020-09-23T00:00:00Z       105932 1259 9   1466115                     55 1895 11691 1472603 posNeg 13586 1472405 9 56 8ab0368173942bcf4e1563bd6cb1dc36e26b74e1 0 0 0 0 0  
223 223 20200923 WV 14504 511076   525580 163   61   31   10721 C 9/22/2020 23:59 2020-09-22T23:59:00Z 09/22 19:59 319   2020-09-22T23:59:00Z 525236     14160 317 2     17036                   54 120 2791 525580 posNeg 2911 525580 2 0 6914ad52b6f6531fce35b2bfcace63f8b93e3347 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  
228 228 20200922 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 1fbce7d9c6b9b287e0974b92a27198573fb8ecdf 0 0 0 0 0  
229 229 20200922 AZ 214846 1185808   1396418 527 21900 122   47   34053 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 5498 21900 2020-09-22T00:00:00Z       210610 5230 268   1396418 284225                   4 595 9097 1400654 posNeg 9791 1400654 20 22 105d76a8129766df7ef555a53810ba8ef0dc8f4a 0 0 0 0 0  
230 230 20200922 CA 784324 13019731   13804055 3520   923         B 9/22/2020 02:59 2020-09-22T02:59:00Z 09/21 22:59 15071   2020-09-22T02:59:00Z 13804055     784324                             6 2630 128643 13804055 posNeg 131273 13804055 53 0 0997db487384449fe22a0cf5bfe0fea7cfe83c58 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  
232 232 20200922 CT 56160 1423664   1479824 70 11447         9204 B 9/21/2020 20:30 2020-09-21T20:30:00Z 09/21 16:30 4496 11447 2020-09-21T20:30:00Z 1477478     53814 3601 895                         9 136 11922 1479824 posNeg 12058 1479824 1 0 b8dd2fbc5a87443d589427bb8b6b1a8d1f407112 0 0 0 0 0  
233 233 20200922 DC 15021 346612   361633 95   22   19   11886 A+ 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 621   2020-09-21T00:00:00Z             361633 206165                     11 43 3846 361633 posNeg 3889 361633 0 0 1b8393e382202f7c98f35792436e9a7e0bee0e5c 0 0 0 0 0  
234 234 20200922 DE 19761 255076   274837 62   14       10411 A+ 9/21/2020 18:00 2020-09-21T18:00:00Z 09/21 14:00 628   2020-09-21T18:00:00Z       18733 551 77   274837                     10 94 1530 274837 posNeg 1624 274837 1 0 5adfc831fe103379582c1d7147434ebda54e5eeb 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  
238 238 20200922 HI 11459 271121   282580 185 735 51   40   4888 B 9/21/2020 18:00 2020-09-21T18:00:00Z 09/21 14:00 120 735 2020-09-21T18:00:00Z 387200             282580                     15 56 1106 282580 posNeg 1162 282580 0 5 5d5a472d13f94d80f482a071d5f0bac22bc77458 0 0 0 0 0  
239 239 20200922 IA 78887 646195   725082 285   72   34   59216 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 1286   2020-09-22T00:00:00Z       78887       726620       56190 3339 52811 18946 2416     19 548 2939 725082 posNeg 3487 725082 12 0 85b8765176c3738dde4329e336257ca667ee04e9 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  
242 242 20200922 IN 112626 1202814   1315440 759 12265 254 2439 79   89072 A+ 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 3520 12265 2020-09-21T23:59:00Z 1898563       3295 225   1315440                     18 599 6196 1315440 posNeg 6795 1315440 8 81 4ce08e401d4c61d1d124d2701ad73082342661bf 0 0 0 0 0  
243 243 20200922 KS 53959 430732   484691 216 2706 60 741 23 230 1970 A+ 9/21/2020 10:00 2020-09-21T10:00:00Z 09/21 06:00 600 2706 2020-09-21T10:00:00Z               484691                     20 0 0 484691 posNeg 0 484691 0 0 1cb8188417c637e2d2fb55352f83395bab168be2 0 0 0 0 0  
244 244 20200922 KY 62731 1012889   1068466 511 5075 133 1494     11361 B 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 1119 5075 2020-09-22T00:00:00Z 1068466     55577 1110 9     52158               21407   21 814 9402 1075620 posNeg 9983 1075620 7 24 10b41b6eb13fe4b0c1e4f9e880cfaf5be7cfae20 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  
246 246 20200922 MA 127969 1979312   3476679 371 12571 67   27   109397 A+ 9/22/2020 08:00 2020-09-22T08:00:00Z 09/22 04:00 9328 12571 2020-09-22T08:00:00Z 3476679 165412   125866 9118 210   2105178       118447     120496       25 173 8992 2107281 totalTestsViral 40518 2107281 11 18 f30290af9e5b34d854f95446862ead2c55efefb1 0 0 0 0 0  
247 247 20200922 MD 120912 1423102   1544014 309 15237 77       7394 A 9/22/2020 10:00 2020-09-22T10:00:00Z 09/22 06:00 3895 15237 2020-09-22T10:00:00Z 2422067 144660   120912 3748 147   1544014                     24 344 6041 1544014 posNeg 6385 1544014 12 66 bedcf99b6c22f302a374143fc9d1850ef21305dd 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  
252 252 20200922 MP 69 14316   14385   4         29 D 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 2 4 2020-09-21T00:00:00Z 18915     69 2     14375                     69 0 0 14385 posNeg 0 14385 0 0 b2b70beaa641ee9432bb4e9d068498aa2482c650 0 0 0 0 0  
253 253 20200922 MS 94021 618480   712501 642 5607 147   74   85327 A+ 9/21/2020 00:00 2020-09-21T00:00:00Z 09/20 20:00 2846 5607 2020-09-21T00:00:00Z 706009     87529 2625 221     37439 95             50385   28 465 5130 712501 posNeg 5595 712501 36 0 ad7f4d4ef8a803de50c303999260e6d7f99a76ee 0 0 0 0 0  
254 254 20200922 MT 10700 303309   314009 111 584         7937 C 9/22/2020 01:59 2020-09-22T01:59:00Z 09/21 21:59 163 584 2020-09-22T01:59:00Z 314009     10700                             30 271 2476 314009 posNeg 2747 314009 3 8 508e06d3fbff288cfb26b77bfeba4391db991668 0 0 0 0 0  
255 255 20200922 NC 195549 2629380   2824929 905   277       176422 A+ 9/22/2020 12:05 2020-09-22T12:05:00Z 09/22 08:05 3286   2020-09-22T12:05:00Z 2824929     195549 3286                           37 1168 6222 2824929 posNeg 7390 2824929 39 0 f4ca81f0e678845338f669e8adc6ea0615b0d98d 0 0 0 0 0  
256 256 20200922 ND 18508 211562   568540 92 752 26 192     15220 B 9/22/2020 01:59 2020-09-22T01:59:00Z 09/21 21:59 156 752 2020-09-22T01:59:00Z 588751     18508 153 3 568540 230070 9240 407 8833               38 264 295 230070 totalTestEncountersViral 2697 230070 5 22 3a3b0330f7731f0d57f1b38bebdc780c85a7c225 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  
258 258 20200922 NH 7990 235537   410466 11 727   230     7259 B 9/22/2020 09:00 2020-09-22T09:00:00Z 09/22 05:00 438 727 2020-09-22T09:00:00Z 410466     7990       243527 31505     30781             33 38 1247 243527 posNeg 3133 243527 0 1 5675ff846845212d122d51d8a7363f8681124fcd 0 0 0 0 0  
259 259 20200922 NJ 200580 3197069   3397649 417 23170 80   34   34697 A+ 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 16076 23170 2020-09-22T00:00:00Z 3397649     200580 14285 1791                         34 426 44040 3397649 posNeg 44466 3397649 7 35 bcc1a2c6975fbd7ce5c822ebbfb99bcff138e2e7 0 0 0 0 0  
260 260 20200922 NM 27683 839000   866683 71 3358         15518 B 9/21/2020 17:50 2020-09-21T17:50:00Z 09/21 13:50 851 3358 2020-09-21T17:50:00Z 866683     27683                             35 104 3680 866683 posNeg 3784 866683 2 17 47b8ae8162027de32de85ee9156cbf12e7cb5080 0 0 0 0 0  
261 261 20200922 NV 76298 592776   669074 441   140   75   2052 A+ 9/22/2020 02:59 2020-09-22T02:59:00Z 09/21 22:59 1546   2020-09-22T02:59:00Z 991960     76298       668264                     32 262 2020 669074 posNeg 2282 669074 15 0 68eee99de2c89aa2fb5c5d3859ef96b306977c76 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  
263 263 20200922 OH 145850 2742937   2888787 593 14899 196 3210 115   124774 A+ 9/22/2020 14:00 2020-09-22T14:00:00Z 09/22 10:00 4635 14899 2020-09-22T14:00:00Z 2880825     137888 4338 297                         39 685 31941 2888787 posNeg 32626 2888787 12 70 45791eaab07cd3164210f78f027d54812f0a9c8d 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
);