states_daily_4pm_et

Table actions

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

11,578 rows sorted by onVentilatorCurrently

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

Link rowid date state positive negative pending totalTestResults hospitalizedCurrently hospitalizedCumulative inIcuCurrently inIcuCumulative onVentilatorCurrently ▼ onVentilatorCumulative recovered dataQualityGrade lastUpdateEt dateModified checkTimeEt death hospitalized dateChecked totalTestsViral positiveTestsViral negativeTestsViral positiveCasesViral deathConfirmed deathProbable totalTestEncountersViral totalTestsPeopleViral totalTestsAntibody positiveTestsAntibody negativeTestsAntibody totalTestsPeopleAntibody positiveTestsPeopleAntibody negativeTestsPeopleAntibody totalTestsPeopleAntigen positiveTestsPeopleAntigen totalTestsAntigen positiveTestsAntigen fips positiveIncrease negativeIncrease total totalTestResultsSource totalTestResultsIncrease posNeg deathIncrease hospitalizedIncrease hash commercialScore negativeRegularScore negativeScore positiveScore score grade
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  
4 4 20200926 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 b9eccb7369bdc4ee75708c7a892c5437ab915d83 0 0 0 0 0  
6 6 20200926 CA 798237 13384493   14182730 3203   862         B 9/26/2020 02:59 2020-09-26T02:59:00Z 09/25 22:59 15532   2020-09-26T02:59:00Z 14182730     798237                             6 4197 126286 14182730 posNeg 130483 14182730 134 0 bc22d39302ce5646a61aef19adbfa503f5de5e76 0 0 0 0 0  
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  
8 8 20200926 CT 56587 1462564   1519151 76 11560         9310 B 9/24/2020 20:30 2020-09-24T20:30:00Z 09/24 16:30 4501 11560 2020-09-24T20:30:00Z 1516780     54216 3604 897                         9 0 0 1519151 posNeg 0 1519151 0 0 597a6f3bd03d5e8297830e769c3da2cb90e767e7 0 0 0 0 0  
10 10 20200926 DE 20156 260243   280399 57   10       10541 A+ 9/25/2020 18:00 2020-09-25T18:00:00Z 09/25 14:00 633   2020-09-25T18:00:00Z       19103 556 77   280399                     10 71 954 280399 posNeg 1025 280399 2 0 e3e0fc4116a2a29665fe6bffd51a89a13780977a 0 0 0 0 0  
11 11 20200926 FL 698682 4536325 4001 5235007 2099 43964           A 9/25/2020 23:59 2020-09-25T23:59:00Z 09/25 19:59 14190 43964 2020-09-25T23:59:00Z 7383930 899158 6443064 698682 14190     5242163 505164 45080 460024 493810 44075 449702   16485     12 2795 26218 5239008 posNeg 29013 5235007 107 171 dc9d1e1af52716f018602f6f32d66d5e9c263c88 0 0 0 0 0  
12 12 20200926 GA 313873 2558482   2872355 1831 28153   5176       A 9/26/2020 14:50 2020-09-26T14:50:00Z 09/26 10:50 6914 28153 2020-09-26T14:50:00Z 2872355 292318 2580037 313873         299555 24723                 13 1359 23502 2872355 posNeg 24861 2872355 40 118 9ab79841fa3a6c3d058ce3f94b9671540d5a8880 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  
20 20 20200926 KY 66036 1216560   1274688 538 5193 129 1511     11750 B 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 1154 5193 2020-09-26T00:00:00Z 1274688     58128 1144 10     55724               24514   21 970 29298 1282596 posNeg 30060 1282596 5 46 bbc51488b99291f0d9e247a91056b3ddc5af5618 0 0 0 0 0  
23 23 20200926 MD 122972 1461328   1584300 347 15382 81       7458 A 9/26/2020 10:00 2020-09-26T10:00:00Z 09/26 06:00 3925 15382 2020-09-26T10:00:00Z 2525658 147256   122972 3780 145   1584300                     24 613 11203 1584300 posNeg 11816 1584300 8 54 cf952879908e5d11013c8da79ad58cd91ef3a04b 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  
27 27 20200926 MO 122014 1167155   1289169 1101             B 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 2063   2020-09-26T00:00:00Z 1687509 128009 1556710 122014       1289169       74093 3508 70585         29 1716 14288 1289169 posNeg 16004 1289169 69 0 de543358a328e51d3abdbaecc32041460021841e 0 0 0 0 0  
28 28 20200926 MP 69 14776   14845   4         29 D 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 2 4 2020-09-25T00:00:00Z 19835     69 2     14845                     69 0 0 14845 posNeg 0 14845 0 0 6fdb4898ec2dbbb6eafe41b19ae56eff50411718 0 0 0 0 0  
30 30 20200926 MT 11907 317378   329285 147 684         8749 C 9/26/2020 01:59 2020-09-26T01:59:00Z 09/25 21:59 171 684 2020-09-26T01:59:00Z 329285     11907                             30 343 2826 329285 posNeg 3169 329285 1 9 2b25a5d9191b4d38560392a23353c41e646042be 0 0 0 0 0  
31 31 20200926 NC 206090 2741713   2947803 914   272       176422 A+ 9/26/2020 12:00 2020-09-26T12:00:00Z 09/26 08:00 3440   2020-09-26T12:00:00Z 2943144     201431 3440                           37 1759 38427 2947803 posNeg 40186 2947803 31 0 20a1b19461a3df0fea54c6dfb6ffc967453a835b 0 0 0 0 0  
32 32 20200926 ND 20380 215849   594628 104 809 22 201     16481 B 9/26/2020 01:59 2020-09-26T01:59:00Z 09/25 21:59 156 809 2020-09-26T01:59:00Z 616642     20380 153 3 594628 236229 9344 421 8923               38 495 1100 236229 totalTestEncountersViral 7064 236229 0 20 774fda32838bbbdd408f7f2df9a95d38e10e2829 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  
34 34 20200926 NH 8121 257257   422591 18 734   232     7379 B 9/26/2020 09:00 2020-09-26T09:00:00Z 09/26 05:00 439 734 2020-09-26T09:00:00Z 422591     8121       265378 31666     30983             33 77 18150 265378 posNeg 4902 265378 1 2 55a064dd09da123029c8d41638a6b22a33f1173c 0 0 0 0 0  
36 36 20200926 NM 28487 865002   893489 75 3420         16020 C 9/25/2020 17:50 2020-09-25T17:50:00Z 09/25 13:50 865 3420 2020-09-25T17:50:00Z 893489     28487                             35 263 7853 893489 posNeg 8116 893489 6 18 ca61662b5c3adb6ac3a1bd588dfa0ca45978ca5b 0 0 0 0 0  
40 40 20200926 OK 83510 1075475 6653 1158985 579 6252 223       69754 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 1004 6252 2020-09-26T00:00:00Z 1172554 94741 1075475 83510         78836 3997                 40 990 17331 1165638 posNeg 18321 1158985 11 60 832a286352d7b6c33cd6f7c2aca41c1e843e62b5 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  
49 49 20200926 UT 69547 735532   805079 191 3702 77 890   358 53806 A+ 9/26/2020 11:02 2020-09-26T11:02:00Z 09/26 07:02 448 3702 2020-09-26T11:02:00Z 1037414     69547       805079             13698 1793 23618 1900 49 1017 8845 805079 posNeg 9862 805079 0 34 3670fa0d15d16f24a5287b6b4adede4295b71342 0 0 0 0 0  
51 51 20200926 VI 1296 18676 8 19972             1209 D 9/25/2020 09:30 2020-09-25T09:30:00Z 09/25 05:30 19   2020-09-25T09:30:00Z 19980       19                           78 0 0 19980 posNeg 0 19972 0 0 61739fb2efab7827062ca9cc633984208f34bc24 0 0 0 0 0  
52 52 20200926 VT 1739 158537   160276 1           1580 B 9/25/2020 23:59 2020-09-25T23:59:00Z 09/25 19:59 58   2020-09-25T23:59:00Z       1739 58     160276                     50 8 989 160276 posNeg 997 160276 0 0 21dc4138bae65a1c22e9f7756f9fd545cb820bea 0 0 0 0 0  
54 54 20200926 WI 120231 1393412 211 1513643 574 7041 161 1153     94094 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 1291 7041 2020-09-26T00:00:00Z       113645 1281 10   1507057                     55 2902 9767 1513854 posNeg 12669 1513643 7 79 fb3c2ebb10eddd0158608674af0e708a51da7173 0 0 0 0 0  
56 56 20200926 WY 5465 92406   97871 22 258         4479 B 9/26/2020 11:55 2020-09-26T11:55:00Z 09/26 07:55 50 258 2020-09-26T11:55:00Z 155082 4497 150584 4618       96991                     56 45 0 97871 posNeg 45 97871 0 2 9c1be43cf5db286c8a903c0b3ed654e3d5b588c2 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  
60 60 20200925 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 84c6296997b54d1474da9d9c51e33d48fda7fb5b 0 0 0 0 0  
62 62 20200925 CA 794040 13258207   14052247 3307   899         B 9/24/2020 02:59 2020-09-24T02:59:00Z 09/23 22:59 15398   2020-09-24T02:59:00Z 14052247     794040                             6 3400 95990 14052247 posNeg 99390 14052247 84 0 dc1ad4cec70e3f611d3c3453330d057af15b2802 0 0 0 0 0  
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  
64 64 20200925 CT 56587 1462564   1519151 76 11560         9310 B 9/24/2020 20:30 2020-09-24T20:30:00Z 09/24 16:30 4501 11560 2020-09-24T20:30:00Z 1516780     54216 3604 897                         9 115 13563 1519151 posNeg 13678 1519151 2 0 7bba4f44da52bffe3a760b5e91631916a9d12741 0 0 0 0 0  
66 66 20200925 DE 20085 259289   279374 53   11       10517 A+ 9/24/2020 18:00 2020-09-24T18:00:00Z 09/24 14:00 631   2020-09-24T18:00:00Z       19044 554 77   279374                     10 138 1320 279374 posNeg 1458 279374 1 0 0cb6cfa23b27978fc86ee02a2be8fc6824f50d2e 0 0 0 0 0  
67 67 20200925 FL 695887 4510107 3987 5205994 2121 43793           A 9/23/2020 23:59 2020-09-23T23:59:00Z 09/23 19:59 14083 43793 2020-09-23T23:59:00Z 7334687 895592 6397559 695887 14083     5213142 505164 45080 460024 493810 44075 449702   16164     12 2847 23648 5209981 posNeg 26495 5205994 122 172 ef546a1f3e7045e633900fb6c08ebc71468c9cc5 0 0 0 0 0  
68 68 20200925 GA 312514 2534980   2847494 1891 28035   5156       A 9/25/2020 14:50 2020-09-25T14:50:00Z 09/25 10:50 6874 28035 2020-09-25T14:50:00Z 2847494 290995 2556499 312514         298482 24566                 13 1468 -166 2847494 posNeg 22678 2847494 52 132 a6249bd4f2c3fb48f3b6f2017128b312f3fe0441 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  
76 76 20200925 KY 65066 1187262   1244628 553 5147 130 1501     11677 B 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 1149 5147 2020-09-25T00:00:00Z 1244628     57366 1140 9     53029               24330   21 908 17485 1252328 posNeg 18243 1252328 12 28 77c25dacc4bfb618309cad6a6bbab52310394106 0 0 0 0 0  
79 79 20200925 MD 122359 1450125   1572484 344 15328 79       7431 A 9/25/2020 10:00 2020-09-25T10:00:00Z 09/25 06:00 3917 15328 2020-09-25T10:00:00Z 2494019 146476   122359 3772 145   1572484                     24 559 10346 1572484 posNeg 10905 1572484 8 29 b0f22deb93c2c6a29c9a9159687e7b5fb831fcdf 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  
83 83 20200925 MO 120298 1152867   1273165 1068             B 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 1994   2020-09-25T00:00:00Z 1667432 126185 1538424 120298       1273165       73815 3475 70340         29 1987 11647 1273165 posNeg 13634 1273165 42 0 5fb1f13385562456e41e7823d1cd75d9e7aff0bc 0 0 0 0 0  
84 84 20200925 MP 69 14776   14845   4         29 D 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 2 4 2020-09-25T00:00:00Z 19835     69 2     14845                     69 0 0 14845 posNeg 0 14845 0 0 39c03ce7322961c11b761e8e31a673b6a2030e95 0 0 0 0 0  
86 86 20200925 MT 11564 314552   326116 140 675         8681 C 9/25/2020 01:59 2020-09-25T01:59:00Z 09/24 21:59 170 675 2020-09-25T01:59:00Z 326116     11564                             30 322 4276 326116 posNeg 4598 326116 5 25 c25f3ea5056c1bb4709b2166c937459158c4e35c 0 0 0 0 0  
87 87 20200925 NC 204331 2703286   2907617 903   281       176422 A+ 9/25/2020 13:30 2020-09-25T13:30:00Z 09/25 09:30 3409   2020-09-25T13:30:00Z 2903054     199768 3409                           37 6142 31284 2907617 posNeg 37426 2907617 53 0 3a1c36e50f5f0ae3074fb005c8a70ae070ce51ed 0 0 0 0 0  
88 88 20200925 ND 19885 214749   587564 89 789 25 200     16104 B 9/25/2020 01:59 2020-09-25T01:59:00Z 09/24 21:59 156 789 2020-09-25T01:59:00Z 609021     19885 153 3 587564 234634 9312 417 8895               38 434 1087 234634 totalTestEncountersViral 5460 234634 0 12 ddc992d655f3c417d4d3a1f72d70d66ad80f4ec5 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  
90 90 20200925 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 0 0 247151 posNeg 0 247151 0 0 3398fdda4d143fbae8189756e15b28d4a0ef5aae 0 0 0 0 0  
92 92 20200925 NM 28224 857149   885373 66 3402         15825 C 9/24/2020 17:30 2020-09-24T17:30:00Z 09/24 13:30 859 3402 2020-09-24T17:30:00Z 885373     28224                             35 237 6730 885373 posNeg 6967 885373 2 14 973a492c8ab652da3c34443f7090e2f694071b6b 0 0 0 0 0  
96 96 20200925 OK 82520 1058144 6368 1140664 590 6192 220       68911 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 993 6192 2020-09-25T00:00:00Z 1153358 92923 1058144 82520         76497 3764                 40 1276 12462 1147032 posNeg 13738 1140664 12 62 138bb7d1a73f2a2eaa42c9c9912b4c5c1fe34d34 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  
105 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  
107 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 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  
110 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  
112 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  
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  
116 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  
118 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 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 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  
122 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 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 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 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  
132 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  
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  
139 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 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  
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  
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  
152 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  
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  
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  
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  
168 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  
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  
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  
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  
179 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 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 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  
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  
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  

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