states_daily_4pm_et

Table actions

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

11,578 rows sorted by inIcuCurrently

✎ 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
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  
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  
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  
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  
21 21 20200926 LA 165152 2090913   2256065 570       86   149640 A 9/25/2020 13:00 2020-09-25T13:00:00Z 09/25 09:00 5444   2020-09-25T13:00:00Z       163928 5262 182   2254841                     22 0 0 2256065 posNeg 0 2256065 0 0 bda77e8fe6fd07aa1abd19dfbcfc5e00573b8f1f 0 0 0 0 0  
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  
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  
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  
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  
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  
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  
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  
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  
77 77 20200925 LA 165152 2090913   2256065 570       86   149640 A 9/25/2020 13:00 2020-09-25T13:00:00Z 09/25 09:00 5444   2020-09-25T13:00:00Z       163928 5262 182   2254841                     22 706 17825 2256065 posNeg 18531 2256065 21 0 25e0ee29f19c5ee29b7147d637fdc6eabccbdd0d 0 0 0 0 0  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
195 195 20200923 MO 116946 1127617   1244563 989             B 9/23/2020 00:00 2020-09-23T00:00:00Z 09/22 20:00 1947   2020-09-23T00:00:00Z 1633863 122803 1508256 116946       1244563       73234 3388 69846         29 1580 1234 1244563 posNeg 2814 1244563 83 0 3fe64a1c1b142ce9ad56681b8a79b81d26bb9f89 0 0 0 0 0  
196 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  
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  
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  
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  
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  
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  
224 224 20200923 WY 5169 89824   94993 21 253         4277 B 9/23/2020 17:25 2020-09-23T17:25:00Z 09/23 13:25 50 253 2020-09-23T17:25:00Z 149060 4322 144737 4368       94055                     56 153 0 94993 posNeg 153 94993 1 0 16decf14600a8fdba04b4b8d6953934532cfc927 0 0 0 0 0  
225 225 20200922 AK 7886 423305   431191 43       14   2668 A 9/22/2020 03:59 2020-09-22T03:59:00Z 09/21 23:59 45   2020-09-22T03:59:00Z 431191 7147 423762 7886 45                           2 48 2498 431191 posNeg 2546 431191 0 0 24135b606b72e9c822c662be4c07b364d622accd 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  
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  
235 235 20200922 FL 687909 4444433 3950 5132342 2319 43261           A 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 13579 43261 2020-09-21T23:59:00Z 7209122 885350 6282680 687909 13579     5139472 505164 45080 460024 493810 44075 449702   14977     12 2470 16612 5136292 posNeg 19082 5132342 99 228 1af196871ff34e868be4d56f373a83a08660462c 0 0 0 0 0  
236 236 20200922 GA 308221 2475206   2783427 1960 27490   5026       A 9/22/2020 14:50 2020-09-22T14:50:00Z 09/22 10:50 6677 27490 2020-09-22T14:50:00Z 2783427 286876 2496551 308221         296044 24217                 13 882 11682 2783427 posNeg 12564 2783427 73 96 9ea1088e3046540b8d86a05ad9eb053272185613 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  
251 251 20200922 MO 115366 1126383   1241749 981             B 9/22/2020 00:00 2020-09-22T00:00:00Z 09/21 20:00 1864   2020-09-22T00:00:00Z 1628323 122668 1502893 115366       1241749       73015 3368 69647         29 1059 21131 1241749 posNeg 22190 1241749 57 0 0a1cdcf2a179b4f4e291517c73786fa067ed6be9 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  
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  
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  
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  
266 266 20200922 PA 151646 1777916   1929562 429       58   122833 A+ 9/22/2020 12:00 2020-09-22T12:00:00Z 09/22 08:00 8023   2020-09-22T12:00:00Z 2782233     147070       1924986                     42 834 10735 1929562 posNeg 11569 1929562 19 0 4f7d0da29c5892d52a810e5507aa86ca4689e92b 0 0 0 0 0  
270 270 20200922 SD 19189 159157   178346 178 1323         16170 A 9/21/2020 14:00 2020-09-21T14:00:00Z 09/21 10:00 202 1323 2020-09-21T14:00:00Z 247705             178346                     46 320 1003 178346 posNeg 1323 178346 0 26 02e039c062b3c1abf1d36f6dfbc56777cc891c9b 0 0 0 0 0  
275 275 20200922 VI 1276 18188 15 19464             1195 D 9/22/2020 12:42 2020-09-22T12:42:00Z 09/22 08:42 19   2020-09-22T12:42:00Z 19479       19                           78 7 145 19479 posNeg 152 19464 0 0 191a687d009f07d86fd52430b0fdc8be9f99f7c2 0 0 0 0 0  
276 276 20200922 VT 1721 155620   157341 1           1557 B 9/21/2020 23:59 2020-09-21T23:59:00Z 09/21 19:59 58   2020-09-21T23:59:00Z       1721 58     157341                     50 2 600 157341 posNeg 602 157341 0 0 e9fac8ed601d3958f6472d13994781286dc67a5b 0 0 0 0 0  
277 277 20200922 WA 83193 1657706   1740899 277 7314     32     B 9/20/2020 02:59 2020-09-20T02:59:00Z 09/19 22:59 2070 7314 2020-09-20T02:59:00Z       83193 2070   1740899                       53 645 3698 1740899 posNeg 4343 1740899 33 52 fbb72d0ce8868069829ba1891bd21b88275f635c 0 0 0 0 0  
280 280 20200922 WY 5016 89824   94840 21 253         4230 B 9/22/2020 17:10 2020-09-22T17:10:00Z 09/22 13:10 49 253 2020-09-22T17:10:00Z 149060 4322 144737 4231       94055                     56 72 637 94840 posNeg 709 94840 0 6 07edd1d4539f3f8700e4a569517653f3ae0e9490 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
);