states_daily_4pm_et

Table actions
Data provided by Big Local News and snapshotted daily from the COVID19 Tracker, https://covidtracking.com/.

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

20,444 rows sorted by hash

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid date state positive probableCases negative pending totalTestResultsSource totalTestResults hospitalizedCurrently hospitalizedCumulative inIcuCurrently inIcuCumulative onVentilatorCurrently onVentilatorCumulative recovered lastUpdateEt dateModified checkTimeEt death hospitalized hospitalizedDischarged dateChecked totalTestsViral positiveTestsViral negativeTestsViral positiveCasesViral deathConfirmed deathProbable totalTestEncountersViral totalTestsPeopleViral totalTestsAntibody positiveTestsAntibody negativeTestsAntibody totalTestsPeopleAntibody positiveTestsPeopleAntibody negativeTestsPeopleAntibody totalTestsPeopleAntigen positiveTestsPeopleAntigen totalTestsAntigen positiveTestsAntigen fips positiveIncrease negativeIncrease total totalTestResultsIncrease posNeg dataQualityGrade deathIncrease hospitalizedIncrease hash ▼ commercialScore negativeRegularScore negativeScore positiveScore score grade
16963 16963 20200503 VI 66   951 29 posNeg 1017             51 5/3/2020 08:04 2020-05-03T08:04:00Z 05/03 04:04 4     2020-05-03T08:04:00Z                                     78 0 29 1046 29 1017   0.0 0.0 0002e858cde922aae936458e5551304140881927 0 0 0 0 0  
5827 5827 20201117 AR 135902 14749 1404126   totalTestsViral 1525279 902 8050 346   133 909 117068 11/17/2020 00:00 2020-11-17T00:00:00Z 11/16 19:00 2245 8050   2020-11-17T00:00:00Z 1525279   1404126 121153 2057 188                 101145 17252     5 1554 7268 1540028 8413 1540028   20.0 101.0 0008e12b98fe7a23504a85f854a616796cec998c 0 0 0 0 0  
17307 17307 20200426 AR 2941   36528   totalTestsViral 39469 104 291     25 57 985 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 1416 39469   2.0 0.0 001238be19c7954235390afe70d512ee8d705462 0 0 0 0 0  
11920 11920 20200801 TX 430485       totalTestsViral 4425640 8969   3117       282604 8/1/2020 16:20 2020-08-01T16:20:00Z 08/01 12:20 6837     2020-08-01T16:20:00Z 4425640 634076   430485         242251 11812             57141 9462 48 9539 0 430485 46798 430485   268.0 0.0 0015c9a7901902b04cf50801d405eb9e06317218 0 0 0 0 0  
2220 2220 20210121 NM 166823   2032027   posNeg 2198850 644 11340         91096 1/21/2021 17:55 2021-01-21T17:55:00Z 01/21 12:55 3044 11340   2021-01-21T17:55:00Z 2198850                                   35 988 12853 2198850 13841 2198850   35.0 60.0 001c613c1a3f66b086f6d48e2dd463c3c3ad18ae 0 0 0 0 0  
18371 18371 20200407 AR 946   12692   totalTestsViral 13638 74 148     26 43 142 4/7/2020 14:41 2020-04-07T14:41:00Z 04/07 10:41 16 148   2020-04-07T14:41:00Z 13638     946                             5 71 722 13638 793 13638   0.0 11.0 001cd20c15a6ca41d5951182c5ed0c7c34b5be99 0 0 0 0 0  
17745 17745 20200419 UT 3069   65537   totalTestsViral 71179   259         679 4/19/2020 15:00 2020-04-19T15:00:00Z 04/19 11:00 27 259   2020-04-19T15:00:00Z 71179 3398 67781         68736                     49 138 4038 68606 4364 68606   2.0 8.0 00237f986b4c58303d48ada6ad3ebac68d1cea28 0 0 0 0 0  
274 274 20210225 VA 570982 120594   217 totalTestEncountersViral 5830467 1488 23871 303   183     2/24/2021 17:00 2021-02-24T17:00:00Z 02/24 12:00 7963 23871 46430 2021-02-24T17:00:00Z   550195   450388 6848 1115 5830467   219906 27322             1349150 120290 51 2036 0 571199 30668 570982   156.0 73.0 002515b5f1bb35d76977beaf9edf7d7c19c54680 0 0 0 0 0  
16927 16927 20200503 IA 9169   44017   posNeg 53186 378   133   93   3325 5/2/2020 12:00 2020-05-02T12:00:00Z 05/02 08:00 184     2020-05-02T12:00:00Z       9169                             19 528 6309 53186 6837 53186   9.0 0.0 002ac28c4035431beafe2706854d93dc0de5c973 0 0 0 0 0  
387 387 20210223 VI 2589   43897 117 posNeg 46486             2483 2/23/2021 09:57 2021-02-23T09:57:00Z 02/23 04:57 25     2021-02-23T09:57:00Z         25     46603                     78 10 204 46603 214 46486   0.0 0.0 002c383e09ef1a3fceab879710ea3d803c01e3f6 0 0 0 0 0  
20233 20233 20200302 MA         totalTestsViral 29                             29 8                                 25 0 0 0 6 0   0.0 0.0 002dae63c049dcae94e695918ad35aeb6659a406 0 0 0 0 0  
13850 13850 20200627 IN 44575   418442   totalTestsViral 593997 595 6982 257 1461 82     6/26/2020 23:59 2020-06-26T23:59:00Z 06/26 19:59 2616 6982 33725 2020-06-26T23:59:00Z 593997 46660     2424 192   463017                     18 435 8692 463017 12788 463017   21.0 38.0 002e5365af9b70eb96ae9d10656561cd41edaf71 0 0 0 0 0  
15606 15606 20200527 NY 364965       totalTestEncountersViral 1811544 4208 88866 1261   988     5/27/2020 00:00 2020-05-27T00:00:00Z 05/26 20:00 23643 88866 64632 2020-05-27T00:00:00Z             1811544                       36 1129 0 364965 37416 364965   79.0 180.0 0034f9e416fc944b8ba0398d21589038bd87767d 0 0 0 0 0  
9581 9581 20200911 AZ 207523 1881 1071901   totalTestsViral 1909700 577 21747 171   100     9/11/2020 00:00 2020-09-11T00:00:00Z 09/10 20:00 5288 21747 32472 2020-09-11T00:00:00Z 1909700     205642 5014 274   1277543 275536                   4 521 6169 1279424 14977 1279424   15.0 136.0 003544c6cea1fb72bebcd0a0682ec9f82a6b74d7 0 0 0 0 0  
19367 19367 20200321 TN 371       totalTestsViral                 3/20/2020 22:48 2020-03-20T22:48:00Z 03/20 18:48       2020-03-20T22:48:00Z                                     47 143 0 371 0 371   0.0 0.0 00372aedf2263f2243b08c2cfbb074cfe8c8c0ba 0 0 0 0 0  
15909 15909 20200521 AZ 15315   156312   totalTestsViral 235548 812 2885 299   197     5/21/2020 00:00 2020-05-21T00:00:00Z 05/20 20:00 763 2885 3872 2020-05-21T00:00:00Z 235548             171627 65790                   4 418 5774 171627 6829 171627   16.0 49.0 003788eff40e5938cca6433e107c014a8ce828e1 0 0 0 0 0  
8624 8624 20200929 WY 5821 873 94722   totalTestsViral 174686 22 267         4702 9/29/2020 17:54 2020-09-29T17:54:00Z 09/29 13:54 50 267   2020-09-29T17:54:00Z 174686 5417 169269 4948       99670                     56 67 360 100543 5236 100543   0.0 3.0 003d682fea85a6ea9d6687e0628bb31fe5aab000 0 0 0 0 0  
14180 14180 20200621 GA 64701       totalTestsViral 697841 960 9837   2140       6/21/2020 14:50 2020-06-21T14:50:00Z 06/21 10:50 2643 9837   2020-06-21T14:50:00Z 697841 58871   64701       688588 140694 8017                 13 892 0 64701 9707 64701   1.0 0.0 00414b551f73210dd5567ca5d87e9a6082e99e9f 0 0 0 0 0  
16469 16469 20200511 AZ 11380   105084   totalTestsViral 155246 717 2462 297   201     5/11/2020 00:00 2020-05-11T00:00:00Z 05/10 20:00 542 2462 2852 2020-05-11T00:00:00Z 155246             116464 33777                   4 261 5826 116464 2156 116464   6.0 41.0 0043fa9eb4ed896738c64392b24bfe690a62581b 0 0 0 0 0  
13183 13183 20200709 MD 71447   541134   totalTestsViral 755713 406 11221 139       5132 7/9/2020 10:00 2020-07-09T10:00:00Z 07/09 06:00 3288 11221   2020-07-09T10:00:00Z 755713 83673   71447 3160 128   612581                     24 586 8887 612581 15119 612581   13.0 37.0 00479822034691821c3ebaeb96ee0987c7940877 0 0 0 0 0  
1040 1040 20210211 ND 98353 4721 301078   totalTestEncountersViral 1372588 39 3827 5 556     96127 2/11/2021 01:59 2021-02-11T01:59:00Z 02/10 20:59 1460 3827   2021-02-11T01:59:00Z 1464863     93632     1372588 399431 13395 1442 11953           114136   38 139 518 399431 4697 399431   1.0 7.0 00491bf64f73b3a6ebf375f8376d5507c8855f39 0 0 0 0 0  
886 886 20210214 SD 110315 12107 303133   totalTestsPeopleViral 413448 87 6438 12   16   106398 2/13/2021 14:00 2021-02-13T14:00:00Z 02/13 09:00 1844 6438   2021-02-13T14:00:00Z 931503     98208       413448                     46 110 490 413448 600 413448   6.0 7.0 004b3662cfacb54eb188771ade262189822f6e4c 0 0 0 0 0  
18820 18820 20200330 AS         totalTestsViral 0               3/30/2020 00:00 2020-03-30T00:00:00Z 03/29 20:00 0     2020-03-30T00:00:00Z 0     0                             60 0 0 0 0 0   0.0 0.0 004b816ef91f35a4f320acec34f4ffce5b0209e7 0 0 0 0 0  
16897 16897 20200504 OR 2680   59374   totalTestsViral 81009 205 598 46   21   860 5/3/2020 11:00 2020-05-03T11:00:00Z 05/03 07:00 109 598   2020-05-03T11:00:00Z 81009 7723 73286                               41 45 1873 62054 3492 62054   0.0 3.0 0052cf09838a1c27c4e6ec817e3b4954f4312535 0 0 0 0 0  
2718 2718 20210112 MT 87077   764517   posNeg 851594 187 3883 36   21   81183 1/12/2021 01:59 2021-01-12T01:59:00Z 01/11 20:59 1067 3883   2021-01-12T01:59:00Z 851594                                   30 424 5731 851594 6155 851594   10.0 30.0 005843256d41dd789e3e3d4aca33bb7dd9d97b95 0 0 0 0 0  
19151 19151 20200325 WV 39   759 6 posNeg 798   1           3/24/2020 00:00 2020-03-24T00:00:00Z 03/23 20:00 0 1   2020-03-24T00:00:00Z       39                             54 19 149 804 168 798   0.0 0.0 005a1201559ff000902070cd01de9c5f65f899ff 0 0 0 0 0  
19475 19475 20200319 PR 5   56 29 posNeg 61               3/19/2020 07:50 2020-03-19T07:50:00Z 03/19 03:50       2020-03-19T07:50:00Z                                     72 0 25 90 25 61   0.0 0.0 005a47d8ca0a899ab22464416066d91708ddfd56 0 0 0 0 0  
4649 4649 20201208 AK 36758       totalTestsViral 1088978 159 827     21     12/8/2020 03:59 2020-12-08T03:59:00Z 12/07 22:59 146 827   2020-12-08T03:59:00Z 1088978 44423 1043338   146                           2 562 0 36758 6838 36758   0.0 22.0 005c10fc8e34d3ecb4306fe8a9258f39a2f93755 0 0 0 0 0  
948 948 20210213 VT 13561 342 303219   totalTestsViral 958666 49   8       10547 2/12/2021 23:59 2021-02-12T23:59:00Z 02/12 18:59 189     2021-02-12T23:59:00Z 958666     13219       316438                     50 146 442 316780 -2876 316780   0.0 0.0 00600d7a926d5b1000520a05efd4c6660db9a6a8 0 0 0 0 0  
17518 17518 20200423 SD 1956   12109   totalTestsPeopleViral 14065 58 119         1064 4/22/2020 18:00 2020-04-22T18:00:00Z 04/22 14:00 9 119   2020-04-22T18:00:00Z               14065                     46 98 521 14065 619 14065   1.0 8.0 0060e3d0f09e66cf7ce75feb512f226fa2db2c8e 0 0 0 0 0  
12468 12468 20200722 NM 17828   471506   posNeg 489334 178 2470         6974 7/22/2020 17:32 2020-07-22T17:32:00Z 07/22 13:32 591 2470   2020-07-22T17:32:00Z 489334                                   35 311 7492 489334 7803 489334   3.0 37.0 0062574438cd8f55514725c45471c2e9e7a4339b 0 0 0 0 0  
15093 15093 20200605 MS 16759 105 176354   posNeg 193113 604 2475 149   84   11203 6/4/2020 19:00 2020-06-04T19:00:00Z 06/04 15:00 803 2475   2020-06-04T19:00:00Z 193008     16654 787 16     8662                   28 199 7929 193113 8128 193113   9.0 135.0 0066cdfa9056a20a94e89e913bb918ac5559702a 0 0 0 0 0  
16413 16413 20200512 AZ 11736   111106   totalTestsViral 163441 765 2504 318   204     5/12/2020 00:00 2020-05-12T00:00:00Z 05/11 20:00 562 2504 2909 2020-05-12T00:00:00Z 163441             122842 36209                   4 356 6022 122842 8195 122842   20.0 42.0 006fd507be4e612021b358ec85e9c9e3d6ea12fd 0 0 0 0 0  
5451 5451 20201124 KS 142059   642229   posNeg 784288 896 4777 240 1294 89 377   11/23/2020 10:00 2020-11-23T10:00:00Z 11/23 05:00 1456 4777 3189 2020-11-23T10:00:00Z               784288                     20 0 0 784288 0 784288   0.0 0.0 00721a88e8739d9d06ef68d578fd55d75ffdb806 0 0 0 0 0  
11337 11337 20200811 MI 98213 9457 2048341   posNeg 2146554 640   185   85   63636 8/11/2020 00:00 2020-08-11T00:00:00Z 08/10 20:00 6533     2020-08-11T00:00:00Z 2172898 124557 2048341 88756 6264 269     230011                   26 907 23058 2146554 23965 2146554   7.0 0.0 0072fe529c76c5d62e02eb508d44f64ea442129e 0 0 0 0 0  
9040 9040 20200921 ME 5106 520 370286   posNeg 375392 17 440 6   1   4384 9/20/2020 23:59 2020-09-20T23:59:00Z 09/20 19:59 140 440   2020-09-20T23:59:00Z 374872 6327 368266 4586 139 1     10192 513 9665               23 27 1227 375392 1254 375392   1.0 1.0 00736c3dbc789661268187cdb9fa7056b4c5abfa 0 0 0 0 0  
7042 7042 20201027 PA 198446 8797 2254523   totalTestEncountersViral 3958256 1170       110   152803 10/27/2020 16:00 2020-10-27T16:00:00Z 10/27 12:00 8696     2020-10-27T16:00:00Z       189649     3958256 2444172                     42 2751 13093 2452969 38899 2452969   23.0 0.0 00795c7b2ff00d8876e746bfc61c02a3d9fb20af 0 0 0 0 0  
10477 10477 20200826 AZ 199459 1615 967451   totalTestsViral 1693858 967 21376 305   180     8/26/2020 00:00 2020-08-26T00:00:00Z 08/25 20:00 4896 21376 29734 2020-08-26T00:00:00Z 1693858     197844 4640 256   1165295 261865                   4 186 4520 1166910 17290 1166910   104.0 11.0 0081828dcca4aefe5053931d0b885895084d2838 0 0 0 0 0  
17300 17300 20200427 VT 855 0 12146   totalTestsViral 16137 33             4/27/2020 00:00 2020-04-27T00:00:00Z 04/26 20:00 47     2020-04-27T00:00:00Z 16137     855       13001                     50 3 221 13001 571 13001   1.0 0.0 0086a9653fb96be421b1a42d84e67b75b35514a6 0 0 0 0 0  
2329 2329 20210119 NE 182418   704113   totalTestsViral 1944011 429 5590         127221 1/18/2021 21:30 2021-01-18T21:30:00Z 01/18 16:30 1842 5590   2021-01-18T21:30:00Z 1944011 209752 1732116         886764                     31 440 335 886531 2267 886531   5.0 15.0 0087baa6ee234925ef8a33d7c0a8626573a3ce7e 0 0 0 0 0  
16605 16605 20200509 MS 9378   72101   posNeg 81479 607 1512 133   76   4421 5/8/2020 19:00 2020-05-08T19:00:00Z 05/08 15:00 421 1512   2020-05-08T19:00:00Z 90472                                   28 288 0 81479 288 81479   12.0 34.0 0089063d08340cc66b1539e00406e07775d3326a 0 0 0 0 0  
9159 9159 20200919 NC 192248   2578772   posNeg 2771020 882   293         9/19/2020 11:45 2020-09-19T11:45:00Z 09/19 07:45 3235   167257 2020-09-19T11:45:00Z 2771020     192248 3235                           37 1229 20771 2771020 22000 2771020   28.0 0.0 008d1a4d618cbea8d220c69eac04b002b325b4a3 0 0 0 0 0  
2536 2536 20210115 ID 153358 27607 446062   totalTestsPeopleViral 571813 338 6225 88 1091     69460 1/14/2021 19:00 2021-01-14T19:00:00Z 01/14 14:00 1591 6225   2021-01-14T19:00:00Z 917901     125751 1401 190   571813                 78973   16 994 1899 599420 2614 599420   27.0 47.0 008f7ec8310e0653ee14d4a94660f69fcf31eb13 0 0 0 0 0  
1508 1508 20210203 VT 12329 311 294835   totalTestsViral 894557 54   8       8759 2/2/2021 23:59 2021-02-02T23:59:00Z 02/02 18:59 179     2021-02-02T23:59:00Z 894557     12018       306853                     50 133 937 307164 8436 307164   3.0 0.0 00909c20b1f6586321132b0c01ae2a79b962b62a 0 0 0 0 0  
5 5 20210301 AZ 817821 55169 3002212   totalTestsViral 7682489 1241 57589 382   196     3/1/2021 00:00 2021-03-01T00:00:00Z 02/28 19:00 15979 57589 117157 2021-03-01T00:00:00Z 7682489     762652 14100 1879   3764864 439644                   4 1039 5381 3820033 19066 3820033   -1.0 -10.0 00931ed76bc21263290b7d8c325385f5ad6c73d2 0 0 0 0 0  
4875 4875 20201204 AR 167137 22227 1589776   totalTestsViral 1734686 1041 9329 373   191 1034 146496 12/4/2020 00:00 2020-12-04T00:00:00Z 12/03 19:00 2586 9329   2020-12-04T00:00:00Z 1734686   1589776 144910 2370 216                 152332 26989     5 2827 13097 1756913 15285 1756913   31.0 123.0 00936f4ebc6d872b671ebfe2bd408ae190d56d3c 0 0 0 0 0  
2115 2115 20210123 PR 90073 6403 305972   posNeg 396045 325   54   46   73760 1/23/2021 00:00 2021-01-23T00:00:00Z 01/22 19:00 1771     2021-01-23T00:00:00Z 415664 20103 395291 83670 1483 288       64390                 72 791 0 396045 791 396045   10.0 0.0 00982a1c736fdf8fff75ba3b1baa5913d150c45e 0 0 0 0 0  
11710 11710 20200804 CA 519427       totalTestsViral 8305713 7630   2082         8/4/2020 00:00 2020-08-04T00:00:00Z 08/03 20:00 9501     2020-08-04T00:00:00Z 8305713     519427                             6 4526 0 519427 121017 519427   113.0 0.0 009a914a2c309e99e178e32570606af5607b3fe0 0 0 0 0 0  
5724 5724 20201119 GA 437156 40515     totalTestsViral 4010676 2142 33778   6327       11/19/2020 14:50 2020-11-19T14:50:00Z 11/19 09:50 9102 33778   2020-11-19T14:50:00Z 4010676 371101   396641 8569 533     350070 33421                 13 3514 0 437156 35607 437156   37.0 111.0 009b59e03eb79e53c51e6291570122ffb3f4d36f 0 0 0 0 0  
10246 10246 20200831 WI 80568 4965 1172854 157 totalTestEncountersViral 1739813 290 5817 96 1020     67234 8/31/2020 00:00 2020-08-31T00:00:00Z 08/30 20:00 1130 5817   2020-08-31T00:00:00Z       75603 1122 8 1739813 1248457                     55 268 3552 1253579 11302 1253422   0.0 13.0 009e8dc2ac4d940c72076f1cac9496643912543e 0 0 0 0 0  
4646 4646 20201209 WI 452180 30115 2216057 115 totalTestEncountersViral 4708409 1535 18715 326 1897     363504 12/9/2020 00:00 2020-12-09T00:00:00Z 12/08 19:00 4142 18715   2020-12-09T00:00:00Z       422065 3887 255 4708409 2638122                     55 4171 8107 2668352 31660 2668237   88.0 215.0 00a4b6b3931824905bfd6c5a24d9924b0b27df06 0 0 0 0 0  
19972 19972 20200309 FL 13   140 115 totalTestEncountersViral 179                                         179                       12 1 22 268 36 153   0.0 0.0 00a90a234b613ed8183dd8f488067f0abe4c405e 0 0 0 0 0  
10364 10364 20200828 AS 0   1514   totalTestsViral 1514               8/15/2020 00:00 2020-08-15T00:00:00Z 08/14 20:00 0     2020-08-15T00:00:00Z 1514     0                             60 0 0 1514 0 1514   0.0 0.0 00aa893fef18e3fb46fc1b9c41c4bf7b7e035073 0 0 0 0 0  
3455 3455 20201230 OH 690748 70567     totalTestsViral 7625641 4409 38002 1087 5837 693   546305 12/30/2020 14:00 2020-12-30T14:00:00Z 12/30 09:00 8855 38002   2020-12-30T14:00:00Z 7625641 645879   620181 8009 846                     828903 43499 39 8178 0 690748 24563 690748   133.0 366.0 00ab9b655c1059f9da291b5a5640406637bb3820 0 0 0 0 0  
4313 4313 20201214 AK 40160       totalTestsViral 1147560 140 889     12     12/14/2020 03:59 2020-12-14T03:59:00Z 12/13 22:59 176 889   2020-12-14T03:59:00Z 1147560 47796 1098479   176                           2 422 0 40160 4462 40160   0.0 3.0 00b0106ce663fed58467e4436cc8e4bb04c8bdef 0 0 0 0 0  
16505 16505 20200511 OR 3228   72279   totalTestsViral 103775 164 670 45   22   1125 5/10/2020 11:00 2020-05-10T11:00:00Z 05/10 07:00 127 670   2020-05-10T11:00:00Z 103775 8663 95112                               41 68 819 75507 3187 75507   0.0 8.0 00b4611d6e636a003b0c8565797a3a0a26868a6d 0 0 0 0 0  
19832 19832 20200312 MI 997 1 91 27 posNeg 1088               3/11/2020 19:00 2020-03-11T19:00:00Z 03/11 15:00       2020-03-11T19:00:00Z       996 0 1                         26 270 34 1115 304 1088   0.0 0.0 00b51732aec08b3c9bb234d03ae06e2414865896 0 0 0 0 0  
1616 1616 20210201 TX 2392443 305273     totalTestsViral 17504358 11074   3111       1974572 2/1/2021 14:40 2021-02-01T14:40:00Z 02/01 09:40 36539     2021-02-01T14:40:00Z 17504358 2362669   2087170         924087 124863             1819443 167830 48 31811 0 2392443 105238 2392443   48.0 0.0 00b62b70f07a11e8bffd2d68fdd3b777f82e44b2 0 0 0 0 0  
19032 19032 20200327 TX 1731       totalTestsViral 55851               3/27/2020 13:00 2020-03-27T13:00:00Z 03/27 09:00 23     2020-03-27T13:00:00Z 55851 5586   1731                             48 337 0 1731 7205 1731   5.0 0.0 00c195592c7f356827d3faa6852e1d8613c44495 0 0 0 0 0  
15603 15603 20200527 NJ 156926 298 503697   posNeg 660623 2761 16597 768   583     5/27/2020 13:00 2020-05-27T13:00:00Z 05/27 09:00 13037 16597 25552 2020-05-27T13:00:00Z 660325     156628 11339 1698                         34 880 23569 660623 24449 660623   151.0 224.0 00c386d40cbbe41c45874ea49381e990696100f2 0 0 0 0 0  
14140 14140 20200622 MP 30   8139   posNeg 8169             19 6/21/2020 19:46 2020-06-21T19:46:00Z 06/21 15:46 2     2020-06-21T19:46:00Z 8169     30                             69 0 0 8169 0 8169   0.0 0.0 00c99bc2dedd72a815bd29e6c7a4f1fc08251e4c 0 0 0 0 0  
2093 2093 20210123 LA 380255 45486 4395697   posNeg 4775952 1747       216   320025 1/22/2021 13:00 2021-01-22T13:00:00Z 01/22 08:00 8483     2021-01-22T13:00:00Z 4730466     334769 7964 519                     317521   22 0 0 4775952 0 4775952   0.0 0.0 00ceea700f05fae56c4c87fe6292e07c41631b79 0 0 0 0 0  
11457 11457 20200809 NE 28245   271429   totalTestsViral 385560 147 1715         20746 8/8/2020 22:45 2020-08-08T22:45:00Z 08/08 18:45 345 1715   2020-08-08T22:45:00Z 385560 34649 350003         299967                     31 141 1995 299674 2859 299674   0.0 11.0 00d01a84affcaf652120096ed69b80d5c40cac04 0 0 0 0 0  
1416 1416 20210204 ID 164163 30532 475265   totalTestsPeopleViral 608896 203 6749 47 1181     84159 2/3/2021 19:00 2021-02-03T19:00:00Z 02/03 14:00 1748 6749   2021-02-03T19:00:00Z 1002998     133631 1534 214   608896                 78973   16 507 1388 639428 1781 639428   7.0 17.0 00d0efc1fc2f8a68037a435bfb6d3062ddaf007d 0 0 0 0 0  
10531 10531 20200825 AR 57374   616810   totalTestsViral 673704 442 4013     108 514 51351 8/25/2020 14:36 2020-08-25T14:36:00Z 08/25 10:36 711 4013   2020-08-25T14:36:00Z 673704   616810 57374                         7090 1085 5 480 0 674184 0 674184   15.0 51.0 00d0f4e94ebfeadcf3e29e3dec5bba5db14b9a63 0 0 0 0 0  
4694 4694 20201208 SD 87038 6539 255385   totalTestsPeopleViral 342423 491 4921 94   63   69144 12/7/2020 14:00 2020-12-07T14:00:00Z 12/07 09:00 1111 4921   2020-12-07T14:00:00Z 653277     80499       342423                     46 538 690 342423 1228 342423   1.0 49.0 00d13c449f89b5f80d9ca63beca39ab00b6ed9d6 0 0 0 0 0  
17868 17868 20200416 AS 0   3 17 totalTestsViral 3               4/6/2020 00:00 2020-04-06T00:00:00Z 04/05 20:00       2020-04-06T00:00:00Z 3     0                             60 0 0 20 0 3   0.0 0.0 00d77fa05c811f5fde4230e067748c04d1798dde 0 0 0 0 0  
1899 1899 20210127 VI 2373   38308 100 posNeg 40681             2260 1/26/2021 20:11 2021-01-26T20:11:00Z 01/26 15:11 24     2021-01-26T20:11:00Z         24     40781                     78 23 193 40781 216 40681   0.0 0.0 00dcd0e73386c3cb18672d2b10b43a2dfe4628cf 0 0 0 0 0  
7886 7886 20201012 SD 28925 636 190319   totalTestsPeopleViral 219244 278 1886         22575 10/11/2020 14:00 2020-10-11T14:00:00Z 10/11 10:00 288 1886   2020-10-11T14:00:00Z 335530     28289       219244                     46 361 772 219244 1133 219244   2.0 20.0 00e6b652c4d9fd2f88a48dd774aa411f69694f97 0 0 0 0 0  
2682 2682 20210113 VA 412545 73077   400 totalTestEncountersViral 4674630 3209 19470 587   362     1/12/2021 17:00 2021-01-12T17:00:00Z 01/12 12:00 5552 19470 33798 2021-01-12T17:00:00Z   424808   339468 4892 660 4674630   195642 19128             808831 76731 51 4598 0 412945 33663 412545   75.0 144.0 00ea24c298715f8b31073e12e7008bb589e7b364 0 0 0 0 0  
19662 19662 20200315 CO 131   627   totalTestEncountersViral 704               3/16/2020 15:35 2020-03-16T15:35:00Z 03/16 11:35 1     2020-03-16T15:35:00Z             704                       8 0 0 758 179 758   0.0 0.0 00ec2351c62bbf7110ecb3a5e99bb240bb7e779f 0 0 0 0 0  
4724 4724 20201207 KY 202592 35215     totalTestsViral 2771777 1700 10736 410 2587 210   30239 12/7/2020 00:00 2020-12-07T00:00:00Z 12/06 19:00 2082 10736   2020-12-07T00:00:00Z 2771777     167377 1980 102     96708               123834   21 1960 0 202592 39772 202592   10.0 58.0 00f197fa37cd2cd5c7db8f12f0adcf288d711468 0 0 0 0 0  
936 936 20210213 OK 412276   2957605 3273 posNeg 3369881 755 23150 229       386420       3994 23150     3343102 376862 2957605           142681 19845                 40 1458 9971 3373154 11429 3369881   35.0 65.0 00f4bb3f2c6c5ecad435122dcf14ce137c17a5b8 0 0 0 0 0  
10048 10048 20200903 ME 4617 472 276436   posNeg 281053 9 424 4   1   3988 9/2/2020 23:59 2020-09-02T23:59:00Z 09/02 19:59 133 424   2020-09-02T23:59:00Z 280581 5771 274564 4145 132 1     9700 482 9205               23 50 7971 281053 8021 281053   0.0 1.0 00f55d05bc483f41f363540e7bd2900365cd51f5 0 0 0 0 0  
11566 11566 20200807 MT 4757   182999   posNeg 187756 84 264         3122 8/7/2020 00:00 2020-08-07T00:00:00Z 08/06 20:00 70 264   2020-08-07T00:00:00Z 187756                                   30 155 1786 187756 1941 187756   5.0 5.0 00f792365e215cb5371f2d6582f681f433012649 0 0 0 0 0  
19165 19165 20200324 GU 32   201   posNeg 233 5             3/24/2020 06:45 2020-03-24T06:45:00Z 03/24 02:45 1     2020-03-24T06:45:00Z                                     66 3 40 233 43 233   0.0 0.0 00fdde84c87d9a28f7d95d540aeff3d031981ab9 0 0 0 0 0  
14857 14857 20200609 IL 129936 724 949970   posNeg 1079906 2573   726   437     6/9/2020 00:59 2020-06-09T00:59:00Z 06/08 20:59 6196     2020-06-09T00:59:00Z 1079182     129212 6018 178   1079182                     17 797 19512 1079906 20309 1079906   94.0 0.0 0103ca9ac3a99e53b1480520129389e60f552676 0 0 0 0 0  
14375 14375 20200618 OH 43122 3149     totalTestsViral 629892 547 7104 219 1807 149     6/18/2020 14:00 2020-06-18T14:00:00Z 06/18 10:00 2633 7104   2020-06-18T14:00:00Z 629892 47260   39973 2401 232                         39 700 0 43122 16653 43122   22.0 53.0 01052048035eaf8ab1c6ed41676e08c4b7f82e2e 0 0 0 0 0  
19438 19438 20200319 CA 924   8787   totalTestsViral 9711               3/19/2020 14:25 2020-03-19T14:25:00Z 03/19 10:25 18     2020-03-19T14:25:00Z 9711                                   6 313 806 9711 1119 9711   5.0 0.0 010a90e39fc545c7ff7bc997643920b099c62357 0 0 0 0 0  
12900 12900 20200714 KY 20223 874     totalTestsViral 454682 449 2802 84 1019     5389 7/14/2020 00:00 2020-07-14T00:00:00Z 07/13 20:00 635 2802   2020-07-14T00:00:00Z 454682     19349 631 4     39661                   21 570 0 20223 13626 20223   6.0 11.0 010cf30bbc6ee746ef660eaf12ed79ef7e23107a 0 0 0 0 0  
14107 14107 20200623 VI 76   2544 33 posNeg 2620             64 6/22/2020 19:35 2020-06-22T19:35:00Z 06/22 15:35 6     2020-06-22T19:35:00Z         6     2653                     78 0 42 2653 42 2620   0.0 0.0 010ea21a65bbbdb9beda865a2ad2140a95e55242 0 0 0 0 0  
20363 20363 20200211 MA         totalTestsViral 12                             12 3                                 25 0 0 0 0 0   0.0 0.0 010f0ec2ed558d331e7051ad38f59450cb9f0eb9 0 0 0 0 0  
7574 7574 20201017 HI 14047 194     totalTestEncountersViral 469684 100 988 25   14   10947 10/16/2020 18:00 2020-10-16T18:00:00Z 10/16 14:00 185 988   2020-10-16T18:00:00Z   13794   13853 185   469684                       15 85 0 14047 3654 14047   1.0 10.0 011457a3cb6417e5679db6c65f9e27b74ae8c65f 0 0 0 0 0  
18196 18196 20200411 VT 713 0 7774   totalTestsViral 9061 77           15 4/11/2020 00:00 2020-04-11T00:00:00Z 04/10 20:00 25     2020-04-11T00:00:00Z 9061     713       8487                     50 33 525 8487 589 8487   1.0 0.0 01147a87eaedb4a46208163116867084b1815f08 0 0 0 0 0  
18318 18318 20200408 CA 16957   127307 14600 totalTestsViral 144264 2714   1154         4/7/2020 18:00 2020-04-07T18:00:00Z 04/07 14:00 442     2020-04-07T18:00:00Z 144264                                   6 1092 11943 158864 13035 144264   68.0 0.0 011ac89d20d9c30601db38ee697d50f183326efe 0 0 0 0 0  
1538 1538 20210202 MN 463132 20262 2828288   totalTestEncountersViral 6264836 394 24447 84 5056     448595 2/1/2021 17:00 2021-02-01T17:00:00Z 02/01 12:00 6210 24447   2021-02-01T17:00:00Z       442870 5961 249 6264836 3271158                 343096   27 604 -217 3291420 8980 3291420   8.0 95.0 011af3a759e9a4a882f6cd968cbc5ec47a51a8e1 0 0 0 0 0  
1163 1163 20210209 PR 96402 7160 305972   posNeg 402374 249   39   38   85365 2/9/2021 00:00 2021-02-09T00:00:00Z 02/08 19:00 1893     2021-02-09T00:00:00Z 415664 20103 395291 89242 1599 294       72667                 72 241 0 402374 241 402374   5.0 0.0 011b1d4f0f18b7202758073c5cc460ec18f30cb3 0 0 0 0 0  
14997 14997 20200607 SC 14286   223573   posNeg 237859 477 1814         7347 6/7/2020 13:30 2020-06-07T13:30:00Z 06/07 09:30 546 1814   2020-06-07T13:30:00Z 246331 22758 223573 14286 546                           45 370 4745 237859 5115 237859   1.0 0.0 011bd665731474abc64cf2edfe0c73b137ff6bc5 0 0 0 0 0  
4033 4033 20201219 AK 42235       totalTestsViral 1193118 146 935     13     12/19/2020 03:59 2020-12-19T03:59:00Z 12/18 22:59 184 935   2020-12-19T03:59:00Z 1193118 50438 1141344   184                           2 330 0 42235 8196 42235   1.0 7.0 011c8097a1d872f24db36569ad7529d7179e38fc 0 0 0 0 0  
1215 1215 20210208 OH 922143 122698     totalTestsViral 9374405 2012 47672 521 6847 351   828455 2/8/2021 14:00 2021-02-08T14:00:00Z 02/08 09:00 11695 47672   2021-02-08T14:00:00Z 9374405 827649   799445 10384 1311                     1399691 75344 39 1926 0 922143 26509 922143   36.0 134.0 0122dfacdcbccb85885d821b0aad5e2648439b90 0 0 0 0 0  
10598 10598 20200824 HI 6600   172224   totalTestEncountersViral 227288 192 396 35   19   2143 8/23/2020 18:00 2020-08-23T18:00:00Z 08/23 14:00 47 396   2020-08-23T18:00:00Z 232334 6615     47   227288 178824                     15 244 2396 178824 3841 178824   0.0 19.0 0123da95c9a4ad6f15e2061d05d32d767ec91a56 0 0 0 0 0  
3615 3615 20201227 NC 516828 41559 6262595   posNeg 6779423 3123   721         12/27/2020 12:55 2020-12-27T12:55:00Z 12/27 07:55 6549   403488 2020-12-27T12:55:00Z 6737864     475269 6176 373                     245762   37 2898 26995 6779423 29893 6779423   23.0 0.0 012ad99aa34eb8b1ecde06bd32b6a078fb6a683f 0 0 0 0 0  
9562 9562 20200912 PA 143805 4182 1664000   totalTestEncountersViral 2582989 470       63   117920 9/12/2020 12:00 2020-09-12T12:00:00Z 09/12 08:00 7837     2020-09-12T12:00:00Z       139623     2582989 1803623                     42 920 11972 1807805 29784 1807805   0.0 0.0 0135f51ce8198d4c9dd3316dd4d497d1192ad631 0 0 0 0 0  
15563 15563 20200528 VI 69   1617 22 posNeg 1686             61 5/28/2020 08:14 2020-05-28T08:14:00Z 05/28 04:14 6     2020-05-28T08:14:00Z         6     1708                     78 0 175 1708 175 1686   0.0 0.0 013704cb2c39c80f0d71af033f9014c7f096aa6f 0 0 0 0 0  
18679 18679 20200402 NC 1857   26822   posNeg 28679 184             4/2/2020 14:00 2020-04-02T14:00:00Z 04/02 10:00 16     2020-04-02T14:00:00Z                                     37 273 2163 28679 2436 28679   6.0 0.0 013a35b520e7069cc455423be28b66fe42b89935 0 0 0 0 0  
4753 4753 20201207 UT 217638   1185465   totalTestsViral 1933554 592 8896 215 1552   558 154983 12/7/2020 09:54 2020-12-07T09:54:00Z 12/07 04:54 949 8896   2020-12-07T09:54:00Z 1933554 215842 1717712         1385303             117599 19158 264453 19925 49 2231 5144 1403103 11318 1403103   10.0 74.0 013eae410b656e2e65c539e5594fcbf877f6fe25 0 0 0 0 0  
5198 5198 20201129 SD 79900 5382 247844   totalTestsPeopleViral 327744 544 4468 91   51   62027 11/28/2020 14:00 2020-11-28T14:00:00Z 11/28 09:00 943 4468   2020-11-28T14:00:00Z 607007     74518       327744                     46 801 1567 327744 2368 327744   1.0 68.0 013fdf8b716a8be70d373f74d95b0f50693e9cf2 0 0 0 0 0  
17718 17718 20200419 MA 39820   129295   totalTestsViral 207288 3789 3789 987         4/19/2020 16:00 2020-04-19T16:00:00Z 04/19 12:00 2146 3789   2020-04-19T16:00:00Z 207288 48441                                 25 2293 4691 169115 5596 169115   163.0 61.0 01422c72869b29a95c5e409f337c74d157c30b42 0 0 0 0 0  
5618 5618 20201121 IN 289183   1763960   totalTestsViral 3846380 3168 22874 925 4227 291     11/20/2020 23:59 2020-11-20T23:59:00Z 11/20 18:59 5246 22874 163741 2020-11-20T23:59:00Z 3846380 265477     4992 254   2053143                     18 6872 15333 2053143 60958 2053143   40.0 362.0 014598f7636fb8f59353fb7bff125cf6ee7ac1bd 0 0 0 0 0  
3111 3111 20210105 NC 575396 49583 6624775   posNeg 7200171 3781   813         1/5/2021 12:55 2021-01-05T12:55:00Z 01/05 07:55 6996   487090 2021-01-05T12:55:00Z 7150588     525813 6552 444                     278875   37 5285 27000 7200171 32285 7200171   55.0 0.0 01462e17332cff71d39ee47085e88d53cf0df116 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,
   [probableCases] INTEGER,
   [negative] INTEGER,
   [pending] INTEGER,
   [totalTestResultsSource] TEXT,
   [totalTestResults] INTEGER,
   [hospitalizedCurrently] INTEGER,
   [hospitalizedCumulative] INTEGER,
   [inIcuCurrently] INTEGER,
   [inIcuCumulative] INTEGER,
   [onVentilatorCurrently] INTEGER,
   [onVentilatorCumulative] INTEGER,
   [recovered] INTEGER,
   [lastUpdateEt] TEXT,
   [dateModified] TEXT,
   [checkTimeEt] TEXT,
   [death] INTEGER,
   [hospitalized] INTEGER,
   [hospitalizedDischarged] INTEGER,
   [dateChecked] TEXT,
   [totalTestsViral] INTEGER,
   [positiveTestsViral] INTEGER,
   [negativeTestsViral] INTEGER,
   [positiveCasesViral] INTEGER,
   [deathConfirmed] INTEGER,
   [deathProbable] INTEGER,
   [totalTestEncountersViral] INTEGER,
   [totalTestsPeopleViral] INTEGER,
   [totalTestsAntibody] INTEGER,
   [positiveTestsAntibody] INTEGER,
   [negativeTestsAntibody] INTEGER,
   [totalTestsPeopleAntibody] INTEGER,
   [positiveTestsPeopleAntibody] INTEGER,
   [negativeTestsPeopleAntibody] INTEGER,
   [totalTestsPeopleAntigen] INTEGER,
   [positiveTestsPeopleAntigen] INTEGER,
   [totalTestsAntigen] INTEGER,
   [positiveTestsAntigen] INTEGER,
   [fips] INTEGER,
   [positiveIncrease] INTEGER,
   [negativeIncrease] INTEGER,
   [total] INTEGER,
   [totalTestResultsIncrease] INTEGER,
   [posNeg] INTEGER,
   [dataQualityGrade] TEXT,
   [deathIncrease] FLOAT,
   [hospitalizedIncrease] FLOAT,
   [hash] TEXT,
   [commercialScore] INTEGER,
   [negativeRegularScore] INTEGER,
   [negativeScore] INTEGER,
   [positiveScore] INTEGER,
   [score] INTEGER,
   [grade] TEXT
);