states_daily_4pm_et

Table actions

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

11,578 rows sorted by negativeTestsViral

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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  
5 5 20200926 AZ 216826 1221851   1434227 509 22005 115   56   34730 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 5622 22005 2020-09-26T00:00:00Z       212376 5355 267   1434227 290470                   4 459 10194 1438677 posNeg 10624 1438677 35 33 130636fd317b3160d4644679abe3501863463881 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  
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  
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  
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  
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  
17 17 20200926 IL 288815 5142362   5431177 1597   355   141     A 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 8832   2020-09-26T00:00:00Z 5428688     286326 8588 244                         17 2441 62776 5431177 posNeg 65217 5431177 25 0 2620e4472a6793bd94436e1e6a2f1efbe8f39315 0 0 0 0 0  
18 18 20200926 IN 116549 1233841   1350390 910 12521 259 2497 92   92306 A+ 9/25/2020 23:59 2020-09-25T23:59:00Z 09/25 19:59 3577 12521 2020-09-25T23:59:00Z 1989928       3351 226   1350390                     18 1142 7786 1350390 posNeg 8928 1350390 11 58 c434c8dc087571d7e42607998e7613c3f97def2f 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  
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  
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  
22 22 20200926 MA 130050 2046728   3780020 354 12637 77   28   111479 A+ 9/26/2020 08:00 2020-09-26T08:00:00Z 09/26 04:00 9391 12637 2020-09-26T08:00:00Z 3780020 167823   127832 9178 213   2174560       119693     126039       25 569 13795 2176778 totalTestsViral 73292 2176778 18 18 6b3d0a05572af2a2470ddc16f5fda3df4be4692c 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  
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  
29 29 20200926 MS 96677 634036   730713 601 5607 147   68   85327 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 2911 5607 2020-09-25T00:00:00Z 723389     89353 2686 225     38425 95             55557   28 645 3682 730713 posNeg 4327 730713 17 0 25c406301ef686539186978256312931e29136fe 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  
35 35 20200926 NJ 202850 3309718   3512568 426 23324 88   38   34650 A+ 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 16103 23324 2020-09-26T00:00:00Z 3512568     202850 14312 1791                         34 750 33107 3512568 posNeg 33857 3512568 6 39 cd73d3de8c388876eca2bfe00d66d734af82857f 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  
39 39 20200926 OH 150009 2883978   3033987 625 15185 205 3247 95   129498 A+ 9/26/2020 14:00 2020-09-26T14:00:00Z 09/26 10:00 4740 15185 2020-09-26T14:00:00Z 3025649     141671 4439 301                         39 1115 37279 3033987 posNeg 38394 3033987 6 58 bc6ac50a6f9a24d96bc3280b69d405cfab1f7ca9 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  
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  
50 50 20200926 VA 145408 1855171 310 1993344 924 18179 202   111   17255 A+ 9/25/2020 17:00 2020-09-25T17:00:00Z 09/25 13:00 3144 18179 2020-09-25T17:00:00Z   165048   138173 2937 207 1993344                       51 975 18955 2000889 posNeg 19845 2000579 8 29 5f2f6648c9200ea7be7a0d221a8b6dffb911ae4c 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  
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  
55 55 20200926 WV 15158 527133   542291 174   56   31   11121 C 9/25/2020 23:59 2020-09-25T23:59:00Z 09/25 19:59 332   2020-09-25T23:59:00Z 541883     14750 329 3     17205                   54 205 6692 542291 posNeg 6897 542291 2 0 a4823873f7e477ab8b531c7edd4b61423f7dbfdb 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  
61 61 20200925 AZ 216367 1211657   1423603 521 21972 119   65   34564 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 5587 21972 2020-09-25T00:00:00Z       211946 5319 268   1423603 289802                   4 515 7092 1428024 posNeg 7612 1428024 28 30 a7a38e5509bf8d1ebfe03d1d9acd5febad3546d0 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  
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  
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  
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  
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  
73 73 20200925 IL 286374 5079586   5365960 1637   371   124     A 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 8807   2020-09-25T00:00:00Z 5363471     283885 8563 244                         17 2805 67279 5365960 posNeg 70084 5365960 33 0 eba0b8805427a5e5e03fefdff222976f3e0158c6 0 0 0 0 0  
74 74 20200925 IN 115407 1226055   1341462 856 12463 258 2484 83   91866 A+ 9/24/2020 23:59 2020-09-24T23:59:00Z 09/24 19:59 3566 12463 2020-09-24T23:59:00Z 1963006       3340 226   1341462                     18 1171 8683 1341462 posNeg 9854 1341462 18 75 5dcfed6931f9331d3b127a4bbfbf2916180d7ab8 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  
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  
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  
78 78 20200925 MA 129481 2032933   3706728 389 12619 78   31   111479 A+ 9/25/2020 08:00 2020-09-25T08:00:00Z 09/25 04:00 9373 12619 2020-09-25T08:00:00Z 3706728 167221   127317 9160 213   2160250       119449     124547       25 488 15400 2162414 totalTestsViral 64012 2162414 11 13 9077f61d902aedaaaa7ef16e71949bd3f105bcb1 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  
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  
85 85 20200925 MS 96032 630354   726386 609 5607 143   73   85327 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 2894 5607 2020-09-24T00:00:00Z 719222     88868 2671 223     38109 95             54718   28 722 3905 726386 posNeg 4627 726386 20 0 6471d1eda0db1007834208b806142b89f1a1d0e5 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  
91 91 20200925 NJ 202100 3276611   3478711 405 23285 75   32   34650 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 16097 23285 2020-09-25T00:00:00Z 3478711     202100 14306 1791                         34 548 26359 3478711 posNeg 26907 3478711 6 33 4637fb73c31e7264c355883b441eae77ca71d808 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  
95 95 20200925 OH 148894 2846699   2995593 595 15127 194 3243 98   128369 A+ 9/25/2020 14:00 2020-09-25T14:00:00Z 09/25 10:00 4734 15127 2020-09-25T14:00:00Z 2987382     140683 4433 301                         39 1150 38728 2995593 posNeg 39878 2995593 19 76 c1a8e2775766670e3de1f763b92a3f2b8411e097 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  
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  
106 106 20200925 VA 144433 1836216 348 1973499 965 18150 221   117   17185 A+ 9/24/2020 17:00 2020-09-24T17:00:00Z 09/24 13:00 3136 18150 2020-09-24T17:00:00Z   163973   137283 2930 206 1973499                       51 941 19699 1980997 posNeg 20534 1980649 23 69 abf66257fc88aa4f57dbd6a79f558fc52f693911 0 0 0 0 0  
107 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  
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  
111 111 20200925 WV 14953 520441   535394 177   59   31   10968 C 9/24/2020 23:59 2020-09-24T23:59:00Z 09/24 19:59 330   2020-09-24T23:59:00Z 535018     14577 327 3     17164                   54 247 6122 535394 posNeg 6369 535394 5 0 bba94c76334f9ad4813ce60d939fcf03baefc731 0 0 0 0 0  
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  
117 117 20200924 AZ 215852 1204565   1415991 565 21942 122   64   34393 A+ 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 5559 21942 2020-09-24T00:00:00Z       211426 5291 268   1415991 289012                   4 568 9983 1420417 posNeg 10489 1420417 34 17 a7df3bcd951a8954fb14b1f779be78d2dc804761 0 0 0 0 0  
118 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  
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  
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  
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  
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  
129 129 20200924 IL 283569 5012307   5295876 1713   400   155     A 9/24/2020 00:00 2020-09-24T00:00:00Z 09/23 20:00 8774   2020-09-24T00:00:00Z 5293678     281371 8538 236                         17 2257 59814 5295876 posNeg 62071 5295876 30 0 76fe84d28caa2298ab73216cc104309da8e32b0d 0 0 0 0 0  
130 130 20200924 IN 114236 1217372   1331608 840 12388 261 2462 83   90979 A+ 9/23/2020 23:59 2020-09-23T23:59:00Z 09/23 19:59 3548 12388 2020-09-23T23:59:00Z 1937499       3322 226   1331608                     18 899 7890 1331608 posNeg 8789 1331608 18 76 bc498fabfcaf85bf45eaebc655d606fba2c3a068 0 0 0 0 0  
131 131 20200924 KS 55226 437055   492281 313 2766 93 753 27 240 2008 A+ 9/23/2020 10:00 2020-09-23T10:00:00Z 09/23 06:00 621 2766 2020-09-23T10:00:00Z               492281                     20 0 0 492281 posNeg 0 492281 0 0 d7488a6af979bbb0b91f27f95ecee42279eafe8d 0 0 0 0 0  
132 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  

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