states_daily_4pm_et

Table actions

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

11,578 rows sorted by recovered descending

✎ 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
4756 4756 20200704 VT 1238 68159   69397 16           999 B 7/4/2020 00:00 2020-07-04T00:00:00Z 07/03 20:00 56   2020-07-04T00:00:00Z       1238 56     69397                     50 2 1000 69397 posNeg 1002 69397 0 0 98ad2fc159c654bbe95c8c347bb10d70f491da4a 0 0 0 0 0  
8672 8672 20200425 TX 23773 239043   262816 1597           9986 B 4/25/2020 13:00 2020-04-25T13:00:00Z 04/25 09:00 623   2020-04-25T13:00:00Z       23773                             48 967 19302 262816 posNeg 20269 262816 30 0 ddaeaff7c84eecea03cc3a565c407a3cf50b4654 0 0 0 0 0  
2444 2444 20200814 NM 22987 627504   650491 128 2928         9980 B 8/13/2020 17:30 2020-08-13T17:30:00Z 08/13 13:30 697 2928 2020-08-13T17:30:00Z 650491     22987                             35 171 5497 650491 posNeg 5668 650491 2 21 cf7adaa9256cc36768dd2d894992fea81600c124 0 0 0 0 0  
1395 1395 20200902 VI 1143 15343 19 16486             998 C 9/1/2020 19:17 2020-09-01T19:17:00Z 09/01 15:17 15   2020-09-01T19:17:00Z 16505       15                           78 4 95 16505 posNeg 99 16486 0 0 3b8ca2af404e5b1fec4fb5016cc008a266cb524b 0 0 0 0 0  
7457 7457 20200516 DC 7042 28490   35532 382       79   998 A 5/15/2020 00:00 2020-05-15T00:00:00Z 05/14 20:00 375   2020-05-15T00:00:00Z             35532                       11 171 1022 35532 posNeg 1193 35532 7 0 c180f30cf02a641be8c25f504331497ae74c5072 0 0 0 0 0  
3970 3970 20200718 VA 76373 813328 421 897264 1166 11142 254   108   9976 A+ 7/17/2020 17:00 2020-07-17T17:00:00Z 07/17 13:00 2025 11142 2020-07-17T17:00:00Z   91652   73420 1921 104 897264                       51 940 12057 890122 posNeg 16938 889701 12 88 2e3cb58d3b34d7eb949f286aef1fd005f5912d2f 0 0 0 0 0  
9042 9042 20200418 MN 2788 45182   47970 239 561 111 215     997 A 4/17/2020 17:00 2020-04-17T17:00:00Z 04/17 13:00 121 561 2020-04-17T17:00:00Z       2788     47970                       27 120 1362 47970 posNeg 1482 47970 10 43 058dbece31d60295bf927ae2ea4ba87ce80702f2 0 0 0 0 0  
2170 2170 20200819 PA 126149 1368318   1494467 548       94   99657 A+ 8/19/2020 00:00 2020-08-19T00:00:00Z 08/18 20:00 7523   2020-08-19T00:00:00Z       122605       1490923                     42 570 14331 1494467 posNeg 14901 1494467 24 0 c5a589717c1696e4164ec4a9fce2ff8fa1f49a9c 0 0 0 0 0  
5264 5264 20200625 WY 1326 28869   30195 7 111         996 B 6/25/2020 17:19 2020-06-25T17:19:00Z 06/25 13:19 20 111 2020-06-25T17:19:00Z 40154 1164 38989 1052       29885                     56 47 0 30195 posNeg 47 30195 0 2 a4afa7c013438f8ed9451f21b343cc2d27b54173 0 0 0 0 0  
8522 8522 20200427 DE 4162 15454   19616 325           996 B 4/26/2020 18:00 2020-04-26T18:00:00Z 04/26 14:00 181   2020-04-26T18:00:00Z         159 22                         10 128 239 19616 posNeg 367 19616 13 0 bce4e4590be24cf3485f4a67594f1246a0f3b26a 0 0 0 0 0  
2977 2977 20200804 DC 12398 187729   200127 100   17   10   9959 A+ 8/3/2020 00:00 2020-08-03T00:00:00Z 08/02 20:00 587   2020-08-03T00:00:00Z             200127 135741                     11 85 1227 200127 posNeg 1312 200127 1 0 b88d95e6b6b7fecdc3827358dfc51d1492147220 0 0 0 0 0  
3509 3509 20200726 NV 42834 396088   438922 1147   314   180   994 A+ 7/26/2020 02:59 2020-07-26T02:59:00Z 07/25 22:59 734   2020-07-26T02:59:00Z 566376     42834       437808                     32 1018 7383 438922 posNeg 8401 438922 2 0 2361018ec1e79a5d2a119ec69c6d90b555a05bd2 0 0 0 0 0  
3565 3565 20200725 NV 41816 388705   430521 1147   314   180   994 A+ 7/25/2020 12:15 2020-07-25T12:15:00Z 07/25 08:15 732   2020-07-25T12:15:00Z 552481     41816       429047                     32 931 7719 430521 posNeg 8650 430521 10 0 9b48b1ed03d11eb244a3dd9816c0f7e11c84f966 0 0 0 0 0  
3621 3621 20200724 NV 40885 380986   421871 1160   315   165   994 A+ 7/24/2020 13:00 2020-07-24T13:00:00Z 07/24 09:00 722   2020-07-24T13:00:00Z 537720     40885       419810                     32 966 6769 421871 posNeg 7735 421871 13 0 c58bf703b829115bdf9b8e9c12b66adb2118dc04 0 0 0 0 0  
3934 3934 20200718 HI 1334 101661   102995 39 139         994 D 7/17/2020 18:00 2020-07-17T18:00:00Z 07/17 14:00 23 139 2020-07-17T18:00:00Z 124068             102995                     15 23 1768 102995 posNeg 1791 102995 1 1 c54a1deb4d1b12b5e3a27da087b676ae5a864cb3 0 0 0 0 0  
8965 8965 20200419 AZ 4929 48061   52990 631 1387 283   187   994 B 4/19/2020 00:00 2020-04-19T00:00:00Z 04/18 20:00 184 1387 2020-04-19T00:00:00Z               52990                     4 210 1735 52990 posNeg 1945 52990 7 46 73ebf1373faf4c93b33ec49bace7adb8b54ac779 0 0 0 0 0  
7528 7528 20200515 ME 1603 22092   23695 35 211 16   8   993 B 5/15/2020 12:00 2020-05-15T12:00:00Z 05/15 08:00 69 211 2020-05-15T12:00:00Z 33035     1437 69     28357     587               23 38 0 23695 posNeg 38 23695 0 4 1f8728b2a5e5dbab10343813273b3770ca848549 0 0 0 0 0  
2226 2226 20200818 PA 125579 1353987   1479566 548       94   99207 A+ 8/18/2020 00:00 2020-08-18T00:00:00Z 08/17 20:00 7499   2020-08-18T00:00:00Z       122050       1476037                     42 735 11512 1479566 posNeg 12247 1479566 31 0 e1b560a453ac01f13f96486b7986c7802f6c5a4f 0 0 0 0 0  
962 962 20200909 DE 18308 235662   253970 53   12       9920 A+ 9/7/2020 18:00 2020-09-07T18:00:00Z 09/07 14:00 609   2020-09-07T18:00:00Z       17317 537 72   253970                     10 0 0 253970 posNeg 0 253970 0 0 6efd148cf24ef6a330d3d56b42db563c8d67f356 0 0 0 0 0  
1018 1018 20200908 DE 18308 235662   253970 53   12       9920 A+ 9/7/2020 18:00 2020-09-07T18:00:00Z 09/07 14:00 609   2020-09-07T18:00:00Z       17317 537 72   253970                     10 59 1309 253970 posNeg 1368 253970 0 0 17bc7e69fbc3b0c325642bab8bbbc5a0a14f7de4 0 0 0 0 0  
4006 4006 20200717 MT 2366 128038   130404 45 159         992 C 7/17/2020 00:00 2020-07-17T00:00:00Z 07/16 20:00 37 159 2020-07-17T00:00:00Z 130404     2366                             30 135 2429 130404 posNeg 2564 130404 2 9 9fef5776800338fff1011004d23058b52fb21daf 0 0 0 0 0  
2175 2175 20200819 TN 137800 1791154   1928954 1230 6069 375   171   99085 A+ 8/19/2020 15:00 2020-08-19T15:00:00Z 08/19 11:00 1452 6069 2020-08-19T15:00:00Z 1926357 163288 1763069 135203 1412 40                         47 2022 32560 1928954 posNeg 34582 1928954 26 88 249f56f5ffe372edb98ac09bbee3e108972d62ff 0 0 0 0 0  
1719 1719 20200827 OH 118828 1997461   2116289 787 13150 257 2929 150   99035 A+ 8/27/2020 14:00 2020-08-27T14:00:00Z 08/27 10:00 4076 13150 2020-08-27T14:00:00Z 2109950     112489 3791 285                         39 1244 67139 2116289 posNeg 68383 2116289 32 107 500fad2da64a588485fa4d863cb8d4c4bdcfb0b8 0 0 0 0 0  
2598 2598 20200811 MA 121707 1224637   1781520 387 12089 70   33   99021 A+ 8/11/2020 10:00 2020-08-11T10:00:00Z 08/11 06:00 8751 12089 2020-08-11T10:00:00Z 1781520 149568   112969 8529 222   1337606       102208             25 392 14676 1346344 totalTestsViral 3418 1346344 10 27 bde9cf2d10fcda3a1c2a04cc6b6e9f281bbf99ac 0 0 0 0 0  
2654 2654 20200810 MA 121315 1209961   1778102 380 12062 60   25   99021 A+ 8/10/2020 10:00 2020-08-10T10:00:00Z 08/10 06:00 8741 12062 2020-08-10T10:00:00Z 1778102 149527   112673 8519 222   1322634       101714             25 275 11062 1331276 totalTestsViral 14941 1331276 6 8 c944641d55c5bd2964b4dcb36ba7fb9babc0e7a2 0 0 0 0 0  
2710 2710 20200809 MA 121040 1198899   1763161 375 12054 60   26   99021 A+ 8/9/2020 10:00 2020-08-09T10:00:00Z 08/09 06:00 8735 12054 2020-08-09T10:00:00Z 1763161 149301   112459 8514 221   1311358       101485             25 329 16866 1319939 totalTestsViral 7683 1319939 14 10 5533b1058cabe12f988c2d817f46e2e2bbfa82a4 0 0 0 0 0  
2766 2766 20200808 MA 120711 1182033   1755478 386 12044 68   30   99021 A+ 8/8/2020 10:00 2020-08-08T10:00:00Z 08/08 06:00 8721 12044 2020-08-08T10:00:00Z 1755478 149234   112173 8500 221   1294206       101139             25 420 16269 1302744 totalTestsViral 12031 1302744 12 22 c685cd9ee244fe8c803a90bbafc7f95254642ef7 0 0 0 0 0  
2822 2822 20200807 MA 120291 1165764   1743447 390 12022 69   30   99021 A+ 8/7/2020 10:00 2020-08-07T10:00:00Z 08/07 06:00 8709 12022 2020-08-07T10:00:00Z 1743447 149046   111853 8488 221   1277617       100383             25 417 14420 1286055 totalTestsViral 21888 1286055 18 15 28f879eee64778435a7e4fed81b3b09de3ae507d 0 0 0 0 0  
2878 2878 20200806 MA 119874 1151344   1721559 403 12007 73   32   99021 A+ 8/6/2020 10:00 2020-08-06T10:00:00Z 08/06 06:00 8691 12007 2020-08-06T10:00:00Z 1721559 148701   111533 8470 221   1262877       99768             25 231 11393 1271218 totalTestsViral 23143 1271218 32 14 936c9950093db99d6e8352a284ca723355bf51dd 0 0 0 0 0  
2934 2934 20200805 MA 119643 1139951   1698416 396 11993 57   21   99021 A+ 8/4/2020 10:00 2020-08-04T10:00:00Z 08/04 06:00 8659 11993 2020-08-04T10:00:00Z 1698416 148290   111371 8438 221   1251322       99170             25 440 16878 1259594 totalTestsViral 25338 1259594 2 20 b14244b642e30e8520c9e32361792b5423bba070 0 0 0 0 0  
1782 1782 20200826 SD 11851 126194   138045 58 981         9896 A 8/25/2020 14:00 2020-08-25T14:00:00Z 08/25 10:00 162 981 2020-08-25T14:00:00Z 181267             138045                     46 292 20 138045 posNeg 312 138045 1 7 c6c23225c7c2be20b5e40e750c6e5117717e4774 0 0 0 0 0  
3033 3033 20200803 DC 12313 186502   198815 104   24   12   9893 A+ 8/2/2020 00:00 2020-08-02T00:00:00Z 08/01 20:00 586   2020-08-02T00:00:00Z             198815 134793                     11 39 1584 198815 posNeg 1623 198815 0 0 3d52bf3b432744c4ac720d4d7983024855e43d09 0 0 0 0 0  
7383 7383 20200518 TN 18011 319417   337428 638 1489         9886 A 5/18/2020 15:00 2020-05-18T15:00:00Z 05/18 11:00 301 1489 2020-05-18T15:00:00Z       18011 301     337428                     47 623 11525 337428 posNeg 12148 337428 3 7 1ad52fa80c135f79b1ccda3aa700cfb4810922d9 0 0 0 0 0  
4026 4026 20200717 VA 75433 801271 470 880326 1171 11054 247   118   9883 A+ 7/16/2020 17:00 2020-07-16T17:00:00Z 07/16 13:00 2013 11054 2020-07-16T17:00:00Z   90256   72516 1909 104 880326                       51 1002 14529 877174 posNeg 12395 876704 6 276 1265577f6edf06bc84b77180cd3f984e0136db55 0 0 0 0 0  
5857 5857 20200614 NE 16633 119482   136115 156 1070         9879 D 6/13/2020 20:00 2020-06-13T20:00:00Z 06/13 16:00 216 1070 2020-06-13T20:00:00Z       16633       136277                     31 120 1618 136115 posNeg 1738 136115 0 3 384ad9223972d4a78ab1da0933f07448d6e86439 0 0 0 0 0  
3089 3089 20200802 DC 12274 184918   197192 102   24   12   9870 A+ 8/1/2020 00:00 2020-08-01T00:00:00Z 07/31 20:00 586   2020-08-01T00:00:00Z             197192 133808                     11 69 3342 197192 posNeg 3411 197192 1 0 115df9ccea2f33dfe1474cecf695cdf8813c7185 0 0 0 0 0  
2969 2969 20200804 AK 4125 248524   252649 33       2   987 A 8/4/2020 00:00 2020-08-04T00:00:00Z 08/03 20:00 25   2020-08-04T00:00:00Z 252649     4125 25                           2 61 6781 252649 posNeg 6842 252649 0 0 9c70ba6428fd0fadd165342c5b780616f6599d6c 0 0 0 0 0  
8515 8515 20200427 AR 3017 37440   40457 109       25   987 B 4/27/2020 15:00 2020-04-27T15:00:00Z 04/27 11:00 50   2020-04-27T15:00:00Z 40457     3017                             5 76 912 40457 posNeg 988 40457 1 -291 f7a31c654d79332a104df49691888bb24d51171d 0 0 0 0 0  
9143 9143 20200416 IA 2141 18534   20675 175   84   48   987 A 4/15/2020 12:00 2020-04-15T12:00:00Z 04/15 08:00 60   2020-04-15T12:00:00Z       2141                             19 146 660 20675 posNeg 806 20675 7 0 11368424ec4b1228a5085628b5722afbbecdd37f 0 0 0 0 0  
5425 5425 20200622 UT 17906 281406   299312 198 1192 67 338   150 9863 A 6/22/2020 12:23 2020-06-22T12:23:00Z 06/22 08:23 158 1192 2020-06-22T12:23:00Z       17906       299312             58 18 69 19 49 444 2473 299312 posNeg 2917 299312 0 8 40b87b100103d012ad5beabb91dbbd840fa10c4c 0 0 0 0 0  
2282 2282 20200817 PA 124844 1342475   1467319 560       95   98626 A+ 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 7468   2020-08-17T00:00:00Z       121354       1463829                     42 384 10072 1467319 posNeg 10456 1467319 0 0 010fd18e127552e89ec0f0234fad775607d7de8e 0 0 0 0 0  
2480 2480 20200813 ID 26133 188480   212898 216 1051 36 296     9850 A 8/12/2020 18:52 2020-08-12T18:52:00Z 08/12 14:52 246 1051 2020-08-12T18:52:00Z 212898     24418 221 25                         16 538 1831 214613 posNeg 2299 214613 0 14 7029838b15673117d5893fd0dc178d66f50a8c9c 0 0 0 0 0  
8571 8571 20200426 AR 2941 36528   39469 104 291     25 57 985 B 4/26/2020 10:00 2020-04-26T10:00:00Z 04/26 06:00 49 291 2020-04-26T10:00:00Z 39469     2941                             5 112 1304 39469 posNeg 1416 39469 2 0 b6ce0b0c784129be74d21ee70dc253e4766ea67a 0 0 0 0 0  
1074 1074 20200907 DE 18249 234353   252602 53   14       9847 A+ 9/6/2020 18:00 2020-09-06T18:00:00Z 09/06 14:00 609   2020-09-06T18:00:00Z       17259 537 72   252602                     10 206 1613 252602 posNeg 1819 252602 0 0 15b967b836bd79b141b3f1b2a4ee22644becc701 0 0 0 0 0  
6886 6886 20200527 WI 18513 210605 335 229118 413 2411 139 550     9846 A+ 5/27/2020 16:00 2020-05-27T16:00:00Z 05/27 12:00 539 2411 2020-05-27T16:00:00Z       16462 539     227067                     55 646 9731 229453 posNeg 10377 229118 22 49 ad4479d85c17859a2fc4c57e3f4feeb4daa0ab33 0 0 0 0 0  
1376 1376 20200902 ND 12270 191830   464111 66 575 16 153     9834 A 9/2/2020 01:59 2020-09-02T01:59:00Z 09/01 21:59 122 575 2020-09-02T01:59:00Z 479537     12270 118 4 464111 203229 8655 342 8313               38 266 1412 204100 totalTestEncountersViral 5525 204100 0 11 9c29e4138e4a913fba50dab6ade095479a0f1836 0 0 0 0 0  
2338 2338 20200816 PA 124460 1332403   1456863 559       99   98323 A+ 8/16/2020 00:00 2020-08-16T00:00:00Z 08/15 20:00 7468   2020-08-16T00:00:00Z       120986       1453389                     42 660 12519 1456863 posNeg 13179 1456863 3 0 4a0f1d1a8202bebd3f6f75809f06c60cb8e8d3c7 0 0 0 0 0  
3883 3883 20200719 KS 21965 227388   249353   1453 58 427 14 161 983 A 7/17/2020 10:00 2020-07-17T10:00:00Z 07/17 06:00 299 1453 2020-07-17T10:00:00Z               249353                     20 0 0 249353 posNeg 0 249353 0 0 c2f8d767a1a9c370c9831bc3f82227462febc68e 0 0 0 0 0  
3939 3939 20200718 KS 21965 227388   249353   1453 58 427 14 161 983 A 7/17/2020 10:00 2020-07-17T10:00:00Z 07/17 06:00 299 1453 2020-07-17T10:00:00Z               249353                     20 0 0 249353 posNeg 0 249353 0 0 5d3544d368e2424564b7939e6c0f2de1b8118aa4 0 0 0 0 0  
3995 3995 20200717 KS 21965 227388   249353   1453 58 427 14 161 983 A 7/17/2020 10:00 2020-07-17T10:00:00Z 07/17 06:00 299 1453 2020-07-17T10:00:00Z               249353                     20 1032 8947 249353 posNeg 9979 249353 0 60 0f9dd05b20c3e6fc0a6bd2d68569197edcbe4588 0 0 0 0 0  
7167 7167 20200522 WV 1616 83213   84829 47   13   9   983 B 5/22/2020 10:00 2020-05-22T10:00:00Z 05/22 06:00 71   2020-05-22T10:00:00Z 84829     1593                             54 23 1665 84829 posNeg 1688 84829 1 0 bfd765a1d0b82d6155cfe4d0b76147367d08ced6 0 0 0 0 0  
7223 7223 20200521 WV 1593 81548   83141 46   12   9   983 B 5/21/2020 10:00 2020-05-21T10:00:00Z 05/21 06:00 70   2020-05-21T10:00:00Z 83141     1593                             54 48 2452 83141 posNeg 2500 83141 1 0 878cb0cb9dd743c3735f3505d86558c8fb210464 0 0 0 0 0  
8528 8528 20200427 ID 1897 18127   20024 36 169   71     983 C 4/26/2020 19:00 2020-04-26T19:00:00Z 04/26 15:00 56 169 2020-04-26T19:00:00Z 20024                                   16 10 516 20024 posNeg 526 20024 0 0 8cef4c3eaf994b1847c27a4bb2c625f674cee0f3 0 0 0 0 0  
3145 3145 20200801 DC 12205 181576   193781 100   26   13   9816 A+ 7/31/2020 00:00 2020-07-31T00:00:00Z 07/30 20:00 585   2020-07-31T00:00:00Z             193781 131031                     11 79 4961 193781 posNeg 5040 193781 0 0 775894e6012ab7a380072be67e2f4503813682c0 0 0 0 0 0  
3201 3201 20200731 DC 12126 176615   188741 86   17   9   9816 A+ 7/30/2020 00:00 2020-07-30T00:00:00Z 07/29 20:00 585   2020-07-30T00:00:00Z             188741 126874                     11 69 5682 188741 posNeg 5751 188741 1 0 293bbdee2175163e071b4e452668af02a9afb483 0 0 0 0 0  
1838 1838 20200825 SD 11559 126174   137733 53 974         9814 A 8/24/2020 14:00 2020-08-24T14:00:00Z 08/24 10:00 161 974 2020-08-24T14:00:00Z 179039             137733                     46 134 136 137733 posNeg 270 137733 0 9 20066650515b0cd77338103d59cfdd02eadc97df 0 0 0 0 0  
8815 8815 20200422 MD 14775 61754   76529 1432 3325 527       981 A 4/21/2020 10:00 2020-04-21T10:00:00Z 04/21 06:00 779 3325 2020-04-21T10:00:00Z 85427 18054   14775 738 41                         24 582 2312 76529 posNeg 2894 76529 47 167 623dd41dc314db255d779af7d8441a58a1fbe765 0 0 0 0 0  
559 559 20200917 WV 13430 484853   498283 170   58   32   9804 C 9/16/2020 23:59 2020-09-16T23:59:00Z 09/16 19:59 294   2020-09-16T23:59:00Z 497962     13109 292 2     16614                   54 234 4166 498283 posNeg 4400 498283 4 0 a91204a31ea82bc12d420b570e211c5eafc42d0d 0 0 0 0 0  
8266 8266 20200502 NH 2310 22039 159 26262 103 270         980 C 5/1/2020 09:00 2020-05-01T09:00:00Z 05/01 05:00 81 270 2020-05-01T09:00:00Z 26262     2310         1047                   33 164 2136 24508 posNeg 1120 24349 9 8 97e263b2592beff6bf5b11c51bb83fffc42f185e 0 0 0 0 0  
8322 8322 20200501 NH 2146 19903 302 25142 112 262         980 C 4/30/2020 09:00 2020-04-30T09:00:00Z 04/30 05:00 72 262 2020-04-30T09:00:00Z 25142     2146         816                   33 92 36 22351 posNeg 1279 22049 6 3 3a6be4e4a909d61e28b67220e89e7a40330be5d8 0 0 0 0 0  
8378 8378 20200430 NH 2054 19867 272 23863 107 259         980 C 4/29/2020 09:00 2020-04-29T09:00:00Z 04/29 05:00 66 259 2020-04-29T09:00:00Z 23863     2054         589                   33 44 1131 22193 posNeg 1605 21921 6 10 50a63e5639346b8df5a6d21a58d4eabcf4da014c 0 0 0 0 0  
9241 9241 20200414 AK 285 8063   8348   32         98 A 4/14/2020 14:15 2020-04-14T14:15:00Z 04/14 10:15 9 32 2020-04-14T14:15:00Z 8348     285                             2 8 510 8348 posNeg 518 8348 1 0 c40f6cdede1ff652304218f53d925bc593dc58a8 0 0 0 0 0  
9608 9608 20200408 ND 251 8301   8431 16 34         98 B 4/8/2020 13:54 2020-04-08T13:54:00Z 04/08 09:54 4 34 2020-04-08T13:54:00Z 8496     251     8431 8059                     38 14 835 8552 totalTestEncountersViral 877 8552 0 1 361e5c043e5402e6af2770877f0367b7509ddb4f 0 0 0 0 0  
9678 9678 20200407 SD 320 5948 2 6268   23         98 A 4/6/2020 18:00 2020-04-06T18:00:00Z 04/06 14:00 6 23 2020-04-06T18:00:00Z               6268                     46 32 216 6270 posNeg 248 6268 2 0 c83a9bfd04eb1523e5f7d821895cd2dc07698756 0 0 0 0 0  
6903 6903 20200526 IA 17703 117301   135004 379   115   65   9791 A+ 5/26/2020 00:00 2020-05-26T00:00:00Z 05/25 20:00 478   2020-05-26T00:00:00Z       17703       135307       15597 1787 13806         19 126 2163 135004 posNeg 2289 135004 19 0 13e11b0d6a2709fe59dbefde40d84ede3e9976f7 0 0 0 0 0  
9036 9036 20200418 KY 2522 28074   30596 360 1008 227 514     979 A 4/17/2020 17:00 2020-04-17T17:00:00Z 04/17 13:00 137 1008 2020-04-17T17:00:00Z 30596                                   21 93 756 30596 posNeg 849 30596 8 37 d36eb749aaadaa4f9aac8e02f8b03d024056e3ad 0 0 0 0 0  
1775 1775 20200826 OH 117584 1930322   2047906 771 13043 259 2920 144   97823 A+ 8/26/2020 14:00 2020-08-26T14:00:00Z 08/26 10:00 4044 13043 2020-08-26T14:00:00Z 2041653     111331 3761 283                         39 1089 18943 2047906 posNeg 20032 2047906 48 87 fb5bbf35b20af4bfee3531ff0e06499b11504cd8 0 0 0 0 0  
3257 3257 20200730 DC 12057 170933   182990 87   17   7   9777 A+ 7/29/2020 00:00 2020-07-29T00:00:00Z 07/28 20:00 584   2020-07-29T00:00:00Z             182990 126874                     11 58 2883 182990 posNeg 2941 182990 0 0 bf4f1009dd968f862dfe7588d2e6ee0d13bbfb3b 0 0 0 0 0  
2990 2990 20200804 MA 119203 1123073   1673078 354 11973 56   29   97595 A+ 8/4/2020 10:00 2020-08-04T10:00:00Z 08/04 06:00 8657 11973 2020-08-04T10:00:00Z 1673078 147889   111033 8436 221   1234106       98298             25 546 14878 1242276 totalTestsViral 24389 1242276 9 31 fe5ece7bd3428ef887c43696d743c4ef46912772 0 0 0 0 0  
3046 3046 20200803 MA 118657 1108195   1648689 375 11942 64   24   97595 A+ 8/3/2020 10:00 2020-08-03T10:00:00Z 08/03 06:00 8648 11942 2020-08-03T10:00:00Z 1648689 147503   110595 8427 221   1218790       97515             25 199 12113 1226852 totalTestsViral 26960 1226852 10 6 a82f0f145e9c1412f21fa9c8467a5f40210a5dc7 0 0 0 0 0  
3102 3102 20200802 MA 118458 1096082   1621729 406 11936 68   33   97595 A+ 8/2/2020 10:00 2020-08-02T10:00:00Z 08/02 06:00 8638 11936 2020-08-02T10:00:00Z 1621729 147080   110430 8417 221   1206512       97293             25 418 12959 1214540 totalTestsViral 8178 1214540 12 6 aa764cbea165a34ee67be65a816a2eb964ef4ba2 0 0 0 0 0  
3158 3158 20200801 MA 118040 1083123   1613551 369 11930 53   26   97595 A+ 7/31/2020 10:00 2020-07-31T10:00:00Z 07/31 06:00 8626 11930 2020-07-31T10:00:00Z 1613551 146945   110077 8406 220   1193200       96964             25 428 12305 1201163 totalTestsViral 11055 1201163 17 22 190a9c8cec92d477f66258291f5701c390a7e665 0 0 0 0 0  
3214 3214 20200731 MA 117612 1070818   1602496 347 11908 58   28   97595 A+ 7/31/2020 10:00 2020-07-31T10:00:00Z 07/31 06:00 8609 11908 2020-07-31T10:00:00Z 1602496 146758   109787 8389 220   1180605       96180             25 514 18764 1188430 totalTestsViral 21526 1188430 14 15 f5ab8508f56906807ba553762a83a6fcdd9138ac 0 0 0 0 0  
3270 3270 20200730 MA 117098 1052054   1580970 367 11893 55   29   97595 A+ 7/30/2020 10:00 2020-07-30T10:00:00Z 07/30 06:00 8595 11893 2020-07-30T10:00:00Z 1580970 146308   109400 8375 220   1161454       95217             25 414 11920 1169152 totalTestsViral 22921 1169152 15 17 d5d81324d2d2103b2d68f43b99dc0f008909f51f 0 0 0 0 0  
3326 3326 20200729 MA 116684 1040134   1558049 390 11876 62   23   97595 A+ 7/29/2020 10:00 2020-07-29T10:00:00Z 07/29 06:00 8580 11876 2020-07-29T10:00:00Z 1558049 145779   109096 8360 220   1149230       94348             25 502 15200 1156818 totalTestsViral 22042 1156818 29 21 c47f4815b8d5c928eb297117e5b12c6992817f95 0 0 0 0 0  
3677 3677 20200723 NV 39919 374217   414136 1136   306   156   975 A+ 7/23/2020 14:50 2020-07-23T14:50:00Z 07/23 10:50 709   2020-07-23T14:50:00Z 526275     39919       411695                     32 1262 8566 414136 posNeg 9828 414136 5 0 41e9501216a16495bf4ad6d02f1100eb1ab1705b 0 0 0 0 0  
3990 3990 20200717 HI 1311 99893   101204 39 138         975 D 7/16/2020 18:00 2020-07-16T18:00:00Z 07/16 14:00 22 138 2020-07-16T18:00:00Z 121512             101204                     15 19 1798 101204 posNeg 1817 101204 0 1 b9a368af20b88a6337634ede365017da085003ad 0 0 0 0 0  
7513 7513 20200515 DC 6871 27468   34339 393       90   975 A 5/14/2020 00:00 2020-05-14T00:00:00Z 05/13 20:00 368   2020-05-14T00:00:00Z             34339                       11 135 1205 34339 posNeg 2681 34339 10 0 9ac28b7cf950a04dd5a9136d7af16c1247374a97 0 0 0 0 0  
2500 2500 20200813 NM 22816 622007   644823 119 2907         9744 B 8/12/2020 17:50 2020-08-12T17:50:00Z 08/12 13:50 695 2907 2020-08-12T17:50:00Z 644823     22816                             35 173 4313 644823 posNeg 4486 644823 2 10 71ffe4e3b07291a2e593f692c3798a07b4aaeaa1 0 0 0 0 0  
4752 4752 20200704 TX 191790 1880019   2071809 7890           97430 B 7/4/2020 16:15 2020-07-04T16:15:00Z 07/04 12:15 2608   2020-07-04T16:15:00Z 2071809     191790         201782 7274                 48 8258 49645 2071809 posNeg 57903 2071809 33 0 f3e4ce7e51e5662dc087b74d3b93a2f95db480af 0 0 0 0 0  
5645 5645 20200618 SC 21548 258975   280523 626 2055         9734 A 6/17/2020 23:59 2020-06-17T23:59:00Z 06/17 19:59 621 2055 2020-06-17T23:59:00Z 280523 28983 251540 21533 621 0     31376 1538 29838               45 992 6777 280523 posNeg 7769 280523 4 0 a085e0269587691eeed24eef0102e4ab510e703a 0 0 0 0 0  
5701 5701 20200617 SC 20556 252198   272754 607 2055         9734 A 6/16/2020 23:59 2020-06-16T23:59:00Z 06/16 19:59 617 2055 2020-06-16T23:59:00Z 272749 27792 244957 20551 617 0     30378 1500 28878               45 566 4509 272754 posNeg 5075 272754 10 0 4def0a6aad63656561aa7ed89b076e654844e048 0 0 0 0 0  
5757 5757 20200616 SC 19990 247689   267679 571 2055         9734 A 6/15/2020 23:59 2020-06-15T23:59:00Z 06/15 19:59 607 2055 2020-06-15T23:59:00Z 267679 27086 240593 19990 607       30056 1483 28573               45 612 11510 267679 posNeg 12122 267679 5 67 521071007f2aec5a1155313ff91c951332ff9479 0 0 0 0 0  
1700 1700 20200827 KY 45978 746907   789076 573 4501 154 1368     9731 B 8/27/2020 00:00 2020-08-27T00:00:00Z 08/26 20:00 910 4501 2020-08-27T00:00:00Z 789076     42169 904 6     46538               13323   21 748 8748 792885 posNeg 9350 792885 8 55 67a882a32936691f759564ecafb3788b4f455341 0 0 0 0 0  
3313 3313 20200729 DC 11999 168050   180049 83   17   8   9723 A+ 7/28/2020 00:00 2020-07-28T00:00:00Z 07/27 20:00 584   2020-07-28T00:00:00Z             180049 125267                     11 54 1973 180049 posNeg 2027 180049 1 0 8f23132152e719f948c14bc1469e1cc45baa8974 0 0 0 0 0  
7436 7436 20200517 RI 13040 79768   120632 260 1418 64   45   972 A+ 5/17/2020 03:00 2020-05-17T03:00:00Z 05/16 23:00 499 1418 2020-05-17T03:00:00Z 122492 16095 106397 13040     120632 92808                     44 125 1537 92808 totalTestEncountersViral 4590 92808 10 15 24463a09c065e2d661bfe1652e82a53502ea0433 0 0 0 0 0  
4877 4877 20200701 AZ 84092 465504   549149 2876 4837 675   466   9715 A+ 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 1720 4837 2020-07-01T00:00:00Z       83645 1607 113   549149 172836                   4 4877 12363 549596 posNeg 17227 549596 88 101 79d92ece340b2d9e14a123a36f994798dede8330 0 0 0 0 0  
5547 5547 20200619 AR 14631 220141   234772 224 1100     53 175 9712 B 6/19/2020 15:40 2020-06-19T15:40:00Z 06/19 11:40 214 1100 2020-06-19T15:40:00Z 234772     14631                             5 703 5635 234772 posNeg 6338 234772 6 26 492f0c4972fafed9445770bba88d7e63ea459fb1 0 0 0 0 0  
4062 4062 20200716 MT 2231 125609   127840 37 150         970 C 7/16/2020 00:00 2020-07-16T00:00:00Z 07/15 20:00 35 150 2020-07-16T00:00:00Z 127840     2231                             30 135 3947 127840 posNeg 4082 127840 1 5 e0784ccdf1c34c6476470d11d9ef10d153690d0b 0 0 0 0 0  
8841 8841 20200422 UT 3445 73015   76460   288         970 A 4/22/2020 15:00 2020-04-22T15:00:00Z 04/22 11:00 34 288 2020-04-22T15:00:00Z       3445                             49 149 3953 76460 posNeg 4102 76460 2 11 99edae4c7180a88e2f4c90860f80a0a881b00192 0 0 0 0 0  
9085 9085 20200417 GU 133 940   1073 6   2       97   4/17/2020 07:00 2020-04-17T07:00:00Z 04/17 03:00 5   2020-04-17T07:00:00Z                                     66 0 70 1073 posNeg 70 1073 0 0 03032c101771aad6f0b013315eaee93b5748f980 0 0 0 0 0  
9747 9747 20200405 AR 830 10412   11242 67 130     27 39 97 A 4/5/2020 14:34 2020-04-05T14:34:00Z 04/05 10:34 16 130 2020-04-05T14:34:00Z 11242     830                             5 87 785 11242 posNeg 872 11242 2 24 78e3d5788eba6c7fc5d5447e522b2ee4c34017b1 0 0 0 0 0  
1130 1130 20200906 DE 18043 232740   250783 62   13       9696 A+ 9/5/2020 18:00 2020-09-05T18:00:00Z 09/05 14:00 609   2020-09-05T18:00:00Z       17053 537 72   250783                     10 151 2000 250783 posNeg 2151 250783 1 0 aeb78323c759b7b539233cec0aee53c29ae3a5a4 0 0 0 0 0  
1894 1894 20200824 SD 11425 126038   137463 65 965         9694 A 8/23/2020 14:00 2020-08-23T14:00:00Z 08/23 10:00 161 965 2020-08-23T14:00:00Z 178534             137463                     46 149 554 137463 posNeg 703 137463 0 6 66c3508794392fb3391c638c008a3bc72edfe9d2 0 0 0 0 0  
7648 7648 20200513 ND 1642 47298   54093 37 127         969 C 5/13/2020 13:00 2020-05-13T13:00:00Z 05/13 09:00 29 127 2020-05-13T13:00:00Z 55037     1642 29   54093 47144                     38 74 1037 48940 totalTestEncountersViral 1703 48940 4 5 338a537b6a0464e84709713a98009a7ef6ca2d85 0 0 0 0 0  
2231 2231 20200818 TN 135778 1758594   1894372 1231 5981 384   183   96896 A+ 8/18/2020 15:00 2020-08-18T15:00:00Z 08/18 11:00 1426 5981 2020-08-18T15:00:00Z 1891875 160792 1731083 133281 1386 40                         47 1034 22230 1894372 posNeg 23264 1894372 39 100 0e7a858a1cdbf95cf95642cacf3d59c03c2f96e2 0 0 0 0 0  
1831 1831 20200825 OH 116495 1911379   2027874 783 12956 250 2903 150   96728 A+ 8/25/2020 14:00 2020-08-25T14:00:00Z 08/25 10:00 3996 12956 2020-08-25T14:00:00Z 2021722     110343 3716 280                         39 844 22830 2027874 posNeg 23674 2027874 10 97 c1188d2d7502d3d8f227cbed938423aba35024d1 0 0 0 0 0  
615 615 20200916 WV 13196 480687   493883 156   61   30   9670 C 9/15/2020 23:59 2020-09-15T23:59:00Z 09/15 19:59 290   2020-09-15T23:59:00Z 493568     12881 288 2     16483                   54 220 3017 493883 posNeg 3237 493883 10 0 6b4718a07b9273d4a622ad7841cabc8bac01961a 0 0 0 0 0  
4812 4812 20200703 VT 1236 67159   68395 16           967 B 7/3/2020 00:00 2020-07-03T00:00:00Z 07/02 20:00 56   2020-07-03T00:00:00Z       1236 56     68395                     50 9 1045 68395 posNeg 1054 68395 0 0 834bac8609916082b377f08f30a506153974cf9f 0 0 0 0 0  
3369 3369 20200728 DC 11945 166077   178022 106   20   9   9664 A+ 7/27/2020 00:00 2020-07-27T00:00:00Z 07/26 20:00 583   2020-07-27T00:00:00Z             178022 124027                     11 87 3787 178022 posNeg 3874 178022 1 0 78cd54a555a3f5e691115e24d9d872a1f5a7fd52 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
);