states_daily_4pm_et

Table actions

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

11,578 rows sorted by deathProbable

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

dataQualityGrade ✖

  • A 3,202
  • B 2,904
  • A+ 2,891
  • - 1,182
  • C 997
  • D 372
  • F 30
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
1 1 20200926 AK 8315 434554   442869 43       14   3267 A 9/26/2020 03:59 2020-09-26T03:59:00Z 09/25 23:59 52   2020-09-26T03:59:00Z 442869 7411 435171 8315 52                           2 113 1424 442869 posNeg 1537 442869 1 0 bf7518dcc571d23d1d8206a95e1a1c12173bcb0a 0 0 0 0 0  
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  
9 9 20200926 DC 15215 362764   377979 101   25   17   12029 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 624   2020-09-25T00:00:00Z             377979 211599                     11 52 4341 377979 posNeg 4393 377979 1 0 5dd3065a746eea8ae0e9a70d3218cd0129db3054 0 0 0 0 0  
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  
14 14 20200926 HI 11891 278076   289967 150 787 55   30   5397 B 9/25/2020 18:00 2020-09-25T18:00:00Z 09/25 14:00 127 787 2020-09-25T18:00:00Z 402010             289967                     15 112 2980 289967 posNeg 3092 289967 3 8 6244d9b33b4882c0c4fd80e6a666219eab29ae6e 0 0 0 0 0  
15 15 20200926 IA 82944 667954   750898 334   84   29   65490 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 1311   2020-09-26T00:00:00Z       82944       752449       57997 3389 54568 20350 2645     19 899 5018 750898 posNeg 5917 750898 4 0 47decf503735f781b057e655041ca39b2b4fb714 0 0 0 0 0  
19 19 20200926 KS 56592 446178   502770 343 2816 121 768 34 250 2039 A+ 9/25/2020 10:00 2020-09-25T10:00:00Z 09/25 06:00 632 2816 2020-09-25T10:00:00Z               502770                     20 0 0 502770 posNeg 0 502770 0 0 1468f023cf5cebe6e0d2f0752a5b054eecc06b87 0 0 0 0 0  
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  
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  
37 37 20200926 NV 78355 607323   685678 442   125   64   2075 A+ 9/26/2020 02:59 2020-09-26T02:59:00Z 09/25 22:59 1582   2020-09-26T02:59:00Z 1026486     78355       684796                     32 602 3740 685678 posNeg 4342 685678 9 0 6562d5250f6a1ba7ad8affc64c3a68a2b09dd5cd 0 0 0 0 0  
38 38 20200926 NY 454760 9968656   10423416 527 89995 164   75   76528 A 9/25/2020 23:59 2020-09-25T23:59:00Z 09/25 19:59 25450 89995 2020-09-25T23:59:00Z       454760     10423416                       36 1005 98948 10423416 posNeg 99953 10423416 4 0 bb7957fb78d761d4366fb1503123856475c70689 0 0 0 0 0  
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  
41 41 20200926 OR 32581 636090   668671 199 2496 40   14   5490 A+ 9/26/2020 03:01 2020-09-26T03:01:00Z 09/25 23:01 546 2496 2020-09-26T03:01:00Z     636090 30742       661334                     41 267 5498 668671 posNeg 5765 668671 4 0 76f49d2ef6b4e575aed9232f25aefd8711244bf3 0 0 0 0 0  
42 42 20200926 PA 155232 1830292   1985524 444       60   127290 A+ 9/26/2020 12:00 2020-09-26T12:00:00Z 09/26 08:00 8103   2020-09-26T12:00:00Z 2898629     150393       1980685                     42 1029 13895 1985524 posNeg 14924 1985524 22 0 95db3b8c62ccc9249c12e799648a8351f5b7337f 0 0 0 0 0  
44 44 20200926 RI 24181 305853   727469 94 2725 8   4   2278 A+ 9/25/2020 12:00 2020-09-25T12:00:00Z 09/25 08:00 1107 2725 2020-09-25T12:00:00Z   34299 693170 24181     727469 330034                     44 0 0 330034 totalTestEncountersViral 0 330034 0 0 e5a147d241db0ad3830218c1038dc29b79d42bcc 0 0 0 0 0  
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  
53 53 20200926 WA 85226 1715795   1801021 264 7412     28     B 9/25/2020 02:59 2020-09-25T02:59:00Z 09/24 22:59 2100 7412 2020-09-25T02:59:00Z       85226 2100   1801021                       53 988 16754 1801021 posNeg 17742 1801021 20 55 fd6ce507d03586f2b0ac32e299f88b85d7393013 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  
57 57 20200925 AK 8202 433130   441332 43       14   3042 A 9/25/2020 03:59 2020-09-25T03:59:00Z 09/24 23:59 51   2020-09-25T03:59:00Z 441332 7357 433688 8202 51                           2 261 7873 441332 posNeg 8134 441332 6 0 0271fcc794329b2dd035402cb74aad56124c446b 0 0 0 0 0  
60 60 20200925 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 84c6296997b54d1474da9d9c51e33d48fda7fb5b 0 0 0 0 0  
62 62 20200925 CA 794040 13258207   14052247 3307   899         B 9/24/2020 02:59 2020-09-24T02:59:00Z 09/23 22:59 15398   2020-09-24T02:59:00Z 14052247     794040                             6 3400 95990 14052247 posNeg 99390 14052247 84 0 dc1ad4cec70e3f611d3c3453330d057af15b2802 0 0 0 0 0  
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  
65 65 20200925 DC 15163 358423   373586 101   29   17   11990 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 623   2020-09-24T00:00:00Z             373586 210143                     11 57 5662 373586 posNeg 5719 373586 2 0 fa43d123c3d8a81e9ca093ade7dd2b5bd84f2e46 0 0 0 0 0  
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  
70 70 20200925 HI 11779 275096   286875 150 779 55   30   5265 B 9/24/2020 18:00 2020-09-24T18:00:00Z 09/24 14:00 124 779 2020-09-24T18:00:00Z 398945             286785                     15 90 0 286875 posNeg 90 286875 2 16 3486c616f8dc9fe588d846e6b7ba3c2c3578c244 0 0 0 0 0  
71 71 20200925 IA 82045 662936   744981 330   87   35   62648 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 1307   2020-09-25T00:00:00Z       82045       746536       57499 3371 54088 20262 2640     19 974 5427 744981 posNeg 6401 744981 5 0 8b946f1a4d28145fbe7ed6ca8f9fb3b2a6cced4b 0 0 0 0 0  
75 75 20200925 KS 56592 446178   502770 343 2816 121 768 34 250 2039 A+ 9/25/2020 10:00 2020-09-25T10:00:00Z 09/25 06:00 632 2816 2020-09-25T10:00:00Z               502770                     20 1366 9123 502770 posNeg 10489 502770 11 50 01571a6c7aa99492ea181c9242d32a1e32c9344c 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  
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  
93 93 20200925 NV 77753 603583   681336 460   130   62   2075 A+ 9/25/2020 02:59 2020-09-25T02:59:00Z 09/24 22:59 1573   2020-09-25T02:59:00Z 1017333     77753       680480                     32 556 5292 681336 posNeg 5848 681336 9 0 62f7a3e3f028dadfbe75a49f66bd4eff913333aa 0 0 0 0 0  
94 94 20200925 NY 453755 9869708   10323463 511 89995 154   76   76456 A 9/24/2020 23:59 2020-09-24T23:59:00Z 09/24 19:59 25446 89995 2020-09-24T23:59:00Z       453755     10323463                       36 908 93910 10323463 posNeg 94818 10323463 7 0 3368f209738993fd91a59f668c9e4097259271ad 0 0 0 0 0  
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  
97 97 20200925 OR 32314 630592   662906 199 2496 40   14   5490 A+ 9/25/2020 03:01 2020-09-25T03:01:00Z 09/24 23:01 542 2496 2020-09-25T03:01:00Z     630592 30742       661334                     41 449 11959 662906 posNeg 12408 662906 3 28 fee078b065b8d17acc4fd7936dd744ca882709ed 0 0 0 0 0  
98 98 20200925 PA 154203 1816397   1970600 435       58   126446 A+ 9/25/2020 12:00 2020-09-25T12:00:00Z 09/25 08:00 8081   2020-09-25T12:00:00Z 2868166     149410       1965807                     42 806 12927 1970600 posNeg 13733 1970600 2 0 fd570e979c470b48c693b0fc8042e50c95be796a 0 0 0 0 0  
100 100 20200925 RI 24181 305853   727469 94 2725 8   4   2278 A+ 9/25/2020 12:00 2020-09-25T12:00:00Z 09/25 08:00 1107 2725 2020-09-25T12:00:00Z   34299 693170 24181     727469 330034                     44 -130 2581 330034 totalTestEncountersViral 10422 330034 1 0 93a877812623e1750b2c506f59e53ecfc693fb8e 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  
109 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  
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  
113 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  
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  
121 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  
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  
126 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 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  
131 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  
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  
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  
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  
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  
153 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 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  
156 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  
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  
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  
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  
169 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  
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  
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  
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  

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