states_daily_4pm_et

Table actions

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

60 rows where "dateChecked" is on date 2020-03-21

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, hospitalizedCurrently, hospitalizedCumulative, dataQualityGrade, death, hospitalized, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-03-21 · 60 ✖
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
10473 10473 20200323 AK 22 946   968   0           A 3/21/2020 16:30 2020-03-21T16:30:00Z 03/21 12:30 0 0 2020-03-21T16:30:00Z 968     22                             2 0 0 968 posNeg 0 968 0 0 1383afaa087534c31207a9448bf20c655fa44380 0 0 0 0 0  
10505 10505 20200323 NE 50 356   406               A 3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00 0   2020-03-21T00:00:00Z                                     31 2 0 406 posNeg 2 406 0 0 8b901556973e90fc7a34394c9ca84dfd4394249a 0 0 0 0 0  
10529 10529 20200322 AK 22 946   968   0             3/21/2020 16:30 2020-03-21T16:30:00Z 03/21 12:30 0 0 2020-03-21T16:30:00Z 968     22                             2 8 188 968 posNeg 196 968 0 0 9bbffa8ce22200305f40cd2de504b00499509581 0 0 0 0 0  
10535 10535 20200322 CO 475 4075   4367 56 49             3/21/2020 18:00 2020-03-21T18:00:00Z 03/21 14:00 5 49 2020-03-21T18:00:00Z             4367 4550                     8 112 758 4550 totalTestEncountersViral 832 4550 1 5 349604142851d7750fb73b7f4dd096876882995b 0 0 0 0 0  
10536 10536 20200322 CT 223 2877   3100 43               3/21/2020 19:30 2020-03-21T19:30:00Z 03/21 15:30 5   2020-03-21T19:30:00Z                                     9 29 771 3100 posNeg 800 3100 1 0 44dd05d34a2b9606492eed40272ac34bff957b25 0 0 0 0 0  
10537 10537 20200322 DC 98 957   1055                 3/21/2020 19:30 2020-03-21T19:30:00Z 03/21 15:30 1   2020-03-21T19:30:00Z             1055                       11 21 451 1055 posNeg 472 1055 0 0 1024a3779a6cda87ae0f9a53de273814edadef30 0 0 0 0 0  
10542 10542 20200322 HI 48 263   311                 3/21/2020 18:00 2020-03-21T18:00:00Z 03/21 14:00     2020-03-21T18:00:00Z                                     15 11 139 311 posNeg 150 311 0 0 b1f23047a71eb0e40b904ae78206364bce9ccc8a 0 0 0 0 0  
10544 10544 20200322 ID 42 1175   1217                 3/21/2020 19:55 2020-03-21T19:55:00Z 03/21 15:55 0   2020-03-21T19:55:00Z 1217                                   16 11 295 1217 posNeg 306 1217 0 0 a9af92c3f1e3e6530ae94b5600b98f1ef5bfdc55 0 0 0 0 0  
10547 10547 20200322 KS 64 417   481                 3/21/2020 11:00 2020-03-21T11:00:00Z 03/21 07:00 2   2020-03-21T11:00:00Z                                     20 9 0 481 posNeg 9 481 0 0 b74d91802d89f07bc8bc66aff2b852ce2003e46e 0 0 0 0 0  
10554 10554 20200322 MN 349 4511   4860   12             3/21/2020 12:10 2020-03-21T12:10:00Z 03/21 08:10 1 12 2020-03-21T12:10:00Z       349     4860                       27 22 559 4860 posNeg 581 4860 0 12 5cd8cfa62f099b6b06dd487626098d54ac9f5e3d 0 0 0 0 0  
10555 10555 20200322 MO 90 369   459                 3/21/2020 22:00 2020-03-21T22:00:00Z 03/21 18:00 3   2020-03-21T22:00:00Z 4642 358 4278 90                             29 17 0 459 posNeg 17 459 0 0 3da65a36c83fca1958412145fd3af7f23a3d8a48 0 0 0 0 0  
10561 10561 20200322 NE 48 356   404                 3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00 0   2020-03-21T00:00:00Z                                     31 10 0 404 posNeg 10 404 0 0 076a8226ac04b1ba42a548cd3a8275e853c1178c 0 0 0 0 0  
10562 10562 20200322 NH 65 1188 959 1981                 3/21/2020 09:00 2020-03-21T09:00:00Z 03/21 05:00     2020-03-21T09:00:00Z 1981                                   33 10 215 2212 posNeg 358 1253 0 0 d5d04faf16439418f214560240eaf3164bc314e3 0 0 0 0 0  
10564 10564 20200322 NM 57 4722   4779                 3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00     2020-03-21T00:00:00Z                                     35 0 951 4779 posNeg 951 4779 0 0 c9f380edf8dd53c9f580e256db793de1baf58279 0 0 0 0 0  
10565 10565 20200322 NV 154 2448   2602                 3/21/2020 14:00 2020-03-21T14:00:00Z 03/21 10:00 7   2020-03-21T14:00:00Z 2878     154                             32 30 64 2602 posNeg 94 2602 2 0 f51cef56893f7a68c98e19f918e94a0b04d12771 0 0 0 0 0  
10576 10576 20200322 TX 334 8422   8756                 3/21/2020 21:00 2020-03-21T21:00:00Z 03/21 17:00 5   2020-03-21T21:00:00Z       334                             48 30 2204 8756 posNeg 2234 8756 0 0 d611a9a0321aa72513a4e736adbf4ae5eb447858 0 0 0 0 0  
10578 10578 20200322 VA 219 3118   9895   32             3/21/2020 17:00 2020-03-21T17:00:00Z 03/21 13:00 3 32 2020-03-21T17:00:00Z   2375         9895                       51 67 480 3337 posNeg 907 3337 1 7 83da8136e6139224695c83503fb2021179b408a3 0 0 0 0 0  
10579 10579 20200322 VI 6     6                 3/21/2020 20:30 2020-03-21T20:30:00Z 03/21 16:30     2020-03-21T20:30:00Z                                     78 0 0 6 posNeg 0 6 0 0 b70c96abc83090c55d6a00268b7278fda0aee532 0 0 0 0 0  
10583 10583 20200322 WV 12 385 1 397   1             3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00 0 1 2020-03-21T00:00:00Z       12                             54 1 55 398 posNeg 56 397 0 0 794b61a0fc97be6a1eaa3be4f152a2f1b71df0a5 0 0 0 0 0  
10584 10584 20200322 WY 24 438   462                 3/21/2020 23:00 2020-03-21T23:00:00Z 03/21 19:00     2020-03-21T23:00:00Z       23                             56 1 0 462 posNeg 1 462 0 0 aa3e07aa73933043c4db4c7fbde2afdbd2d31dd8 0 0 0 0 0  
10585 10585 20200321 AK 14 758   772   0             3/21/2020 16:30 2020-03-21T16:30:00Z 03/21 12:30 0 0 2020-03-21T16:30:00Z 772     14                             2 2 72 772 posNeg 74 772 0 0 70ec7fb73d86b6e08cb85c205f5b57bfbbdfd920 0 0 0 0 0  
10586 10586 20200321 AL 124 28   152                 3/21/2020 11:20 2020-03-21T11:20:00Z 03/21 07:20 0   2020-03-21T11:20:00Z 152     124                             1 43 0 152 posNeg 43 152 0 0 b5edd338940da2060e0e35a608b1a5ed2f32f38f 0 0 0 0 0  
10587 10587 20200321 AR 118 567 154 685                 3/21/2020 13:47 2020-03-21T13:47:00Z 03/21 09:47     2020-03-21T13:47:00Z 685     118                             5 22 216 839 posNeg 238 685 0 0 4affd60a9d29a9c6a50c3f0757c57ca11676ee8a 0 0 0 0 0  
10589 10589 20200321 AZ 104 240 122 344   128             3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00 1 128 2020-03-21T00:00:00Z               344                     4 39 29 466 posNeg 68 344 1 20 213944efc4738ef73d81cf376e0e1e1b28e61eb2 0 0 0 0 0  
10590 10590 20200321 CA 1279 11249   12528                 3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00 24   2020-03-21T00:00:00Z 12528                                   6 216 825 12528 posNeg 1041 12528 4 0 ae427014416cf808aeba1732082a19285750ea2b 0 0 0 0 0  
10594 10594 20200321 DE 45 36   81                 3/21/2020 15:15 2020-03-21T15:15:00Z 03/21 11:15 0   2020-03-21T15:15:00Z         0 0                         10 7 0 81 posNeg 7 81 0 0 101bf25db01c69cdd003c0c60ada84f211d99319 0 0 0 0 0  
10595 10595 20200321 FL 658 6579 1002 7237   158             3/21/2020 11:00 2020-03-21T11:00:00Z 03/21 07:00 12 158 2020-03-21T11:00:00Z                                     12 138 4709 8239 posNeg 4847 7237 2 158 ab44fbea7cb475ccff57f028eeed64c83656c7c1 0 0 0 0 0  
10596 10596 20200321 GA 507 2557   3064                 3/21/2020 12:00 2020-03-21T12:00:00Z 03/21 08:00 14   2020-03-21T12:00:00Z 3064                                   13 87 591 3064 posNeg 678 3064 1 0 b5e11386ececa6dbe3578b7104fec08bf3b6d7d4 0 0 0 0 0  
10597 10597 20200321 GU 15 108   123                 3/21/2020 07:15 2020-03-21T07:15:00Z 03/21 03:15     2020-03-21T07:15:00Z                                     66 1 22 123 posNeg 23 123 0 0 df211e2ef1faea9d68d396a3c23c4ec457b5ab54 0 0 0 0 0  
10599 10599 20200321 IA 68 1049   1117                 3/21/2020 14:20 2020-03-21T14:20:00Z 03/21 10:20     2020-03-21T14:20:00Z       68                             19 23 407 1117 posNeg 430 1117 0 0 1f8eac470a427c5df50bc3aa3a7075921d8f577b 0 0 0 0 0  
10601 10601 20200321 IL 753 5488   6241                 3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00 6   2020-03-21T00:00:00Z                                     17 168 1792 6241 posNeg 1960 6241 1 0 b88cf0c32fe7c532fcc73afad2306094136a9760 0 0 0 0 0  
10602 10602 20200321 IN 126 707   833   1             3/21/2020 00:59 2020-03-21T00:59:00Z 03/20 20:59 4 1 2020-03-21T00:59:00Z                                     18 47 232 833 posNeg 279 833 2 1 17393cc9628cae6cd8c464e35f1c39a64aaef2ab 0 0 0 0 0  
10603 10603 20200321 KS 55 417   472                 3/21/2020 11:00 2020-03-21T11:00:00Z 03/21 07:00 2   2020-03-21T11:00:00Z                                     20 11 0 472 posNeg 11 472 1 0 85aaf7006b856c0742f1addd075cf74990f1f4b8 0 0 0 0 0  
10604 10604 20200321 KY 54 714   768                 3/21/2020 09:00 2020-03-21T09:00:00Z 03/21 05:00 2   2020-03-21T09:00:00Z 768                                   21 7 122 768 posNeg 129 768 1 0 a7b19e94445e4aa1830033305e70b085e3dd6899 0 0 0 0 0  
10605 10605 20200321 LA 580 2180   2760                 3/21/2020 10:30 2020-03-21T10:30:00Z 03/21 06:30 16   2020-03-21T10:30:00Z       580                             22 107 1612 2760 posNeg 1719 2760 4 0 6c092862e89e176deb10993592b165e10c4eea79 0 0 0 0 0  
10606 10606 20200321 MA 426 4799   22155   61             3/21/2020 16:00 2020-03-21T16:00:00Z 03/21 12:00 7 61 2020-03-21T16:00:00Z 22155 2069                                 25 112 1004 5225 totalTestsViral 2771 5225 2 61 f717e29ebed93c34be7408ff36d3ac0fe1e3692c 0 0 0 0 0  
10607 10607 20200321 MD 190 94   284                 3/21/2020 10:00 2020-03-21T10:00:00Z 03/21 06:00 3   2020-03-21T10:00:00Z       190 3                           24 41 0 284 posNeg 41 284 0 0 440cbd800dc3215404a87d0d370463e4a930a51a 0 0 0 0 0  
10608 10608 20200321 ME 73 2264   2337                 3/21/2020 13:30 2020-03-21T13:30:00Z 03/21 09:30     2020-03-21T13:30:00Z       73                             23 16 0 2337 posNeg 16 2337 0 0 747a700e0adfba27fc8e288d77d220902589d067 0 0 0 0 0  
10609 10609 20200321 MI 7023 4086   11109                 3/21/2020 13:44 2020-03-21T13:44:00Z 03/21 09:44 23   2020-03-21T13:44:00Z 5203 1117 4086 6938 33 3                         26 804 1045 11109 posNeg 1849 11109 10 0 f784cb8271fc2700cdce5af009123d1f0a5bc2e7 0 0 0 0 0  
10610 10610 20200321 MN 327 3952   4279                 3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00 1   2020-03-21T00:00:00Z       327     4279                       27 24 211 4279 posNeg 235 4279 1 0 988d5c97df21b627d398e415c5908f9dee9ad447 0 0 0 0 0  
10612 10612 20200321 MP 0     0                 3/21/2020 02:30 2020-03-21T02:30:00Z 03/20 22:30 0   2020-03-21T02:30:00Z                                     69 0 0 0 posNeg 0 0 0 0 7b4806fac769cf40900d179f2b20b952f4b60c29 0 0 0 0 0  
10615 10615 20200321 NC 184 5092   5276                 3/21/2020 10:30 2020-03-21T10:30:00Z 03/21 06:30 0   2020-03-21T10:30:00Z                                     37 47 1996 5276 posNeg 2043 5276 0 0 344a3726240269f17c77f906860805cb50b26fd8 0 0 0 0 0  
10616 10616 20200321 ND 28 1141   1096   3             3/21/2020 11:56 2020-03-21T11:56:00Z 03/21 07:56 0 3 2020-03-21T11:56:00Z 1113     28     1096 1075                     38 8 341 1169 totalTestEncountersViral 332 1169 0 3 de8b026d256d4182863ccd96e1cbbe98c41093e6 0 0 0 0 0  
10619 10619 20200321 NJ 1327 294 40 1621                 3/21/2020 13:00 2020-03-21T13:00:00Z 03/21 09:00 22   2020-03-21T13:00:00Z       1327 16 6   1621                     34 437 30 1661 posNeg 467 1621 6 0 57b105e747ffdc7a3da7ef59c6dcb5957725e7a1 0 0 0 0 0  
10620 10620 20200321 NM 57 3771   3828                 3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00     2020-03-21T00:00:00Z                                     35 14 0 3828 posNeg 14 3828 0 0 ec1a376b72cac6953a39a4373351b8be0fc17a19 0 0 0 0 0  
10621 10621 20200321 NV 124 2384   2508                 3/21/2020 02:59 2020-03-21T02:59:00Z 03/20 22:59 5   2020-03-21T02:59:00Z       124                             32 15 392 2508 posNeg 407 2508 2 0 30de2375cbc820cafbb7a6be44778f33fa3163f6 0 0 0 0 0  
10623 10623 20200321 OH 247 140   387   58             3/21/2020 14:00 2020-03-21T14:00:00Z 03/21 10:00 3 58 2020-03-21T14:00:00Z       247                             39 78 0 387 posNeg 78 387 2 58 1d0e9a0b943d44f95e5507a925028e475b2c1365 0 0 0 0 0  
10624 10624 20200321 OK 53 560 144 613   10             3/21/2020 08:00 2020-03-21T08:00:00Z 03/21 04:00 1 10 2020-03-21T08:00:00Z                                     40 4 22 757 posNeg 26 613 0 10 71691e0eb3ef14fa60ee7270e9b8bc4bed47491b 0 0 0 0 0  
10626 10626 20200321 PA 371 3766   4137                 3/21/2020 12:00 2020-03-21T12:00:00Z 03/21 08:00 2   2020-03-21T12:00:00Z               4137                     42 103 1192 4137 posNeg 1295 4137 1 0 df0ed8ec0a55ed3ef168ab51d15dfc579ec73531 0 0 0 0 0  
10627 10627 20200321 PR 21 143 71 164                 3/21/2020 13:00 2020-03-21T13:00:00Z 03/21 09:00     2020-03-21T13:00:00Z                                     72 7 29 235 posNeg 36 164 0 0 4699baa0038fd628c46561ec40d87b6ba16fde65 0 0 0 0 0  
10628 10628 20200321 RI 88 1284 290 1286                 3/21/2020 03:00 2020-03-21T03:00:00Z 03/20 23:00     2020-03-21T03:00:00Z 1443 105 1338 88     1286 1372                     44 14 123 1662 totalTestEncountersViral 211 1372 0 0 a788b1c6353e52c9b48ba362a0d25d1b57fe2550 0 0 0 0 0  
10630 10630 20200321 SD 14 691 268 705                 3/21/2020 13:00 2020-03-21T13:00:00Z 03/21 09:00 1   2020-03-21T13:00:00Z               705                     46 0 28 973 posNeg 28 705 0 0 f22adc71e374f13237a46da5802d65a9518450a5 0 0 0 0 0  
10632 10632 20200321 TX 304 6218   6522                 3/21/2020 13:00 2020-03-21T13:00:00Z 03/21 09:00 5   2020-03-21T13:00:00Z       304                             48 110 1135 6522 posNeg 1245 6522 0 0 b305bfa413816f78a6840f11940e581669ba19f0 0 0 0 0 0  
10633 10633 20200321 UT 136 2424   2560                 3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00 0   2020-03-21T00:00:00Z       136                             49 24 389 2560 posNeg 413 2560 0 0 ccedcff7095abe15409c22473cea9fbaf1ea5db5 0 0 0 0 0  
10634 10634 20200321 VA 152 2638   8988   25             3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00 2 25 2020-03-21T00:00:00Z   2302         8988                       51 38 427 2790 posNeg 595 2790 0 25 3efd33beb0052ea88aa9456a69f456cb3e80a0ff 0 0 0 0 0  
10636 10636 20200321 VT 52 1080   1132                 3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00 2   2020-03-21T00:00:00Z       52                             50 8 123 1132 posNeg 131 1132 0 0 202e4828e0a865aa375ff2aa92c5c1aa07242901 0 0 0 0 0  
10637 10637 20200321 WA 2965 42741   45706                 3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00 111   2020-03-21T00:00:00Z       2965     45706 44847                     53 194 2236 45706 posNeg 2430 45706 7 0 17aadc2d72edad1230ed9bfb2b59f69d78d5dd3f 0 0 0 0 0  
10638 10638 20200321 WI 315 4628   4943                 3/21/2020 16:00 2020-03-21T16:00:00Z 03/21 12:00 4   2020-03-21T16:00:00Z       281                             55 80 1173 4943 posNeg 1253 4943 1 0 0f9f352cd9d72c6ae1069118943d70f5f88c95ad 0 0 0 0 0  
10639 10639 20200321 WV 11 330 2 341   1             3/21/2020 00:00 2020-03-21T00:00:00Z 03/20 20:00 0 1 2020-03-21T00:00:00Z       11                             54 4 111 343 posNeg 115 341 0 1 014c20c4c92bc1e3ceae21ffd637d258a174afd9 0 0 0 0 0  
10640 10640 20200321 WY 23 438   461                 3/21/2020 12:30 2020-03-21T12:30:00Z 03/21 08:30     2020-03-21T12:30:00Z       20                             56 4 107 461 posNeg 111 461 0 0 398571388967e64ec915bdc50b8ff22e39df3046 0 0 0 0 0  

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