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

61 rows where "dateChecked" is on date 2020-03-30

View and edit SQL

Suggested facets: date, pending, hospitalizedCurrently, hospitalizedCumulative, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, recovered, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, hospitalized, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date)

dateChecked (date)

  • 2020-03-30 · 61
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
9748 20200405 AS 0 3 2 3                 3/30/2020 23:00 2020-03-30T23:00:00Z 03/30 19:00 0   2020-03-30T23:00:00Z 3     0                             60 0 0 5 posNeg 0 3 0 0 50b0bf581bf52acb2f058136f521846cd6d93af2 0 0 0 0 0  
9804 20200404 AS 0 3 2 3                 3/30/2020 23:00 2020-03-30T23:00:00Z 03/30 19:00 0   2020-03-30T23:00:00Z 3     0                             60 0 0 5 posNeg 0 3 0 0 45297872049fc2bc64ae664b1ffcd484db810b9f 0 0 0 0 0  
9860 20200403 AS 0 3 2 3                 3/30/2020 23:00 2020-03-30T23:00:00Z 03/30 19:00 0   2020-03-30T23:00:00Z 3     0                             60 0 0 5 posNeg 0 3 0 0 d0ff9647302f774881b902572c312f142af3e56f 0 0 0 0 0  
9916 20200402 AS 0 3 2 3                 3/30/2020 23:00 2020-03-30T23:00:00Z 03/30 19:00 0   2020-03-30T23:00:00Z 3     0                             60 0 0 5 posNeg 0 3 0 0 cccc2f8f22906b58a34ea2dacde38a8d2a318c96 0 0 0 0 0  
9972 20200401 AS 0 3 2 3                 3/30/2020 23:00 2020-03-30T23:00:00Z 03/30 19:00 0   2020-03-30T23:00:00Z 3     0                             60 0 0 5 posNeg 0 3 0 0 d3e447c2aa5e4107ee614da8de801a5d0a3105a9 0 0 0 0 0  
10025 20200331 AK 119 3594   3713   7           A 3/30/2020 19:00 2020-03-30T19:00:00Z 03/30 15:00 3 7 2020-03-30T19:00:00Z 3713     119                             2 5 54 3713 posNeg 59 3713 0 0 905a33815e32c4645e4cfa40909151ef3b5086f8 0 0 0 0 0  
10028 20200331 AS 0 3 2 3                 3/30/2020 00:00 2020-03-30T00:00:00Z 03/29 20:00 0   2020-03-30T00:00:00Z 3     0                             60 0 3 5 posNeg 3 3 0 0 1aa73b4235d97ea1e7c69f21a3cce6807b07fb59 0 0 0 0 0  
10031 20200331 CO 2627 12737   17107 503 414           A 3/30/2020 18:00 2020-03-30T18:00:00Z 03/30 14:00 51 414 2020-03-30T18:00:00Z             17107 15364                     8 0 0 15364 totalTestEncountersViral 1633 15364 0 0 bc99ee8c7f6dc958bd4b54570110af56d6f31601 0 0 0 0 0  
10033 20200331 DC 495 3262 2 3757             121 A 3/30/2020 00:00 2020-03-30T00:00:00Z 03/29 20:00 9   2020-03-30T00:00:00Z             3757                       11 94 580 3759 posNeg 674 3757 0 0 143b12eb5157016f78ec8ba8d79d06423e42936b 0 0 0 0 0  
10038 20200331 HI 204 8471   8675   12   6     49 A 3/30/2020 18:00 2020-03-30T18:00:00Z 03/30 14:00   12 2020-03-30T18:00:00Z                                     15 29 646 8675 posNeg 675 8675 0 0 00d460f4d453510f32d4be9b42616db69ce8e694 0 0 0 0 0  
10040 20200331 ID 415 5297   5712 45 45   6       A 3/30/2020 19:00 2020-03-30T19:00:00Z 03/30 15:00 7 45 2020-03-30T19:00:00Z 5712                                   16 105 901 5712 posNeg 1006 5712 1 6 9b9c84da628727306d61aacd3349dc0ea617149f 0 0 0 0 0  
10042 20200331 IN 2159 11214   13373               B 3/30/2020 12:59 2020-03-30T12:59:00Z 03/30 08:59 49   2020-03-30T12:59:00Z                                     18 373 1342 13373 posNeg 1715 13373 14 0 28c79e87e40c2f383d39d1a409491d0882b4bacb 0 0 0 0 0  
10044 20200331 KY 480 6330   6810               A 3/30/2020 17:00 2020-03-30T17:00:00Z 03/30 13:00 11   2020-03-30T17:00:00Z 6810                                   21 41 751 6810 posNeg 792 6810 2 0 210f317b71e198ff8f761c0eaeefed3c08dbe692 0 0 0 0 0  
10052 20200331 MP 2     2                 3/30/2020 18:30 2020-03-30T18:30:00Z 03/30 14:30     2020-03-30T18:30:00Z                                     69 0 0 2 posNeg 0 2 0 0 dbbaa90d13abe787feca37e2927d9037e8d75027 0 0 0 0 0  
10053 20200331 MS 937 3537   4474   211           B 3/30/2020 19:00 2020-03-30T19:00:00Z 03/30 15:00 20 211 2020-03-30T19:00:00Z                                     28 90 548 4474 posNeg 638 4474 4 16 61a67082103a06b265cf4912321ef39c5e1f60d5 0 0 0 0 0  
10058 20200331 NH 314 5413 65 6240   45           B 3/30/2020 09:00 2020-03-30T09:00:00Z 03/30 05:00 3 45 2020-03-30T09:00:00Z 6240                                   33 0 27 5792 posNeg 250 5727 0 0 0531660af4d1814ad46545ceaa3453689c4967c5 0 0 0 0 0  
10067 20200331 PR 239 1195 854 1434               A 3/30/2020 07:00 2020-03-30T07:00:00Z 03/30 03:00 8   2020-03-30T07:00:00Z                                     72 65 264 2288 posNeg 329 1434 2 0 3ddaa0a96149b3f8d28224622e11be3631f0fa99 0 0 0 0 0  
10075 20200331 VI 30 126 24 156             21   3/30/2020 17:00 2020-03-30T17:00:00Z 03/30 13:00     2020-03-30T17:00:00Z                                     78 0 0 180 posNeg 0 156 0 0 0e9c61cbce62c1aeae970340105d7cd5de406c50 0 0 0 0 0  
10083 20200330 AR 473 5262   5735 62       21   29 A 3/30/2020 15:42 2020-03-30T15:42:00Z 03/30 11:42 7   2020-03-30T15:42:00Z 5735     473                             5 47 2235 5735 posNeg 2282 5735 1 0 e6ccb74dba98f14e6fd9ec41f5666479d976a7c1 0 0 0 0 0  
10084 20200330 AS       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 posNeg 0 0 0 0 c49b358f37e9f829975f04b2f83c70581fd3a503 0 0 0 0 0  
10085 20200330 AZ 1157 15602   16759   478           B 3/30/2020 00:00 2020-03-30T00:00:00Z 03/29 20:00 20 478 2020-03-30T00:00:00Z               16759                     4 238 2649 16759 posNeg 2887 16759 3 51 7deab55382f30912abd1024fb527ba346162b159 0 0 0 0 0  
10086 20200330 CA 6447 20549 64400 26996 1432   597         B 3/30/2020 00:00 2020-03-30T00:00:00Z 03/29 20:00 133   2020-03-30T00:00:00Z 26996                                   6 739 0 91396 posNeg 739 26996 10 0 91974451ba9ca5788549dd50e578e8fb2253da3e 0 0 0 0 0  
10087 20200330 CO 2627 12737   15474 358 414           A 3/30/2020 17:00 2020-03-30T17:00:00Z 03/30 13:00 51 414 2020-03-30T17:00:00Z             15474 14470                     8 566 1522 15364 totalTestEncountersViral 1283 15364 7 140 7e065a3286986b529b4f46f11ebe461311a4e2bd 0 0 0 0 0  
10088 20200330 CT 2571 12029   14600 517             A 3/30/2020 11:30 2020-03-30T11:30:00Z 03/30 07:30 36   2020-03-30T11:30:00Z 14600       19                           9 578 2122 14600 posNeg 2700 14600 2 0 99bad43dcd006c7cdd6c2439a2379aca95dd03f3 0 0 0 0 0  
10090 20200330 DE 264 2216   2480 45           9 C 3/30/2020 00:00 2020-03-30T00:00:00Z 03/29 20:00 11   2020-03-30T00:00:00Z         11 0                         10 32 2180 2480 posNeg 2212 2480 1 0 13a76336f57d6262a375e081bca1fdaee6b4bd8c 0 0 0 0 0  
10091 20200330 FL 5473 48225   53698   652           A 3/30/2020 11:30 2020-03-30T11:30:00Z 03/30 07:30 63 652 2020-03-30T11:30:00Z                                     12 1227 9155 53698 posNeg 10382 53698 7 58 3cf80b2362aefc960f8b7fb8e2ec10e4359bf685 0 0 0 0 0  
10092 20200330 GA 2809 9915   12724   707           A 3/30/2020 11:28 2020-03-30T11:28:00Z 03/30 07:28 87 707 2020-03-30T11:28:00Z 12724                                   13 158 2 12724 posNeg 160 12724 7 41 33363e74ee45f8741e4df205cc9f57feae182382 0 0 0 0 0  
10093 20200330 GU 58 352   410 19   2       7   3/30/2020 04:30 2020-03-30T04:30:00Z 03/30 00:30 1   2020-03-30T04:30:00Z                                     66 2 18 410 posNeg 20 410 0 0 7e5e7b14454c455dd2c6a6e23c39a63a23d59157 0 0 0 0 0  
10095 20200330 IA 424 6162   6586 51 74         23 C 3/30/2020 00:00 2020-03-30T00:00:00Z 03/29 20:00 6 74 2020-03-30T00:00:00Z       424                             19 88 1149 6586 posNeg 1237 6586 2 6 b5ecf3da502eab44484d9f5caada6a2671ae8ebf 0 0 0 0 0  
10099 20200330 KS 368 4554   4922   66           B 3/30/2020 11:00 2020-03-30T11:00:00Z 03/30 07:00 8 66 2020-03-30T11:00:00Z                                     20 49 360 4922 posNeg 409 4922 2 11 c56f0a6656acb354c82dccce62d80893ced422f3 0 0 0 0 0  
10101 20200330 LA 4025 30008   34033 1185       385     A 3/30/2020 13:00 2020-03-30T13:00:00Z 03/30 09:00 185   2020-03-30T13:00:00Z       4025                             22 485 5677 34033 posNeg 6162 34033 34 0 926facbb164ca72b15e8e332443a32237516580f 0 0 0 0 0  
10102 20200330 MA 5653 37166   58064   453           B 3/30/2020 16:15 2020-03-30T16:15:00Z 03/30 12:15 124 453 2020-03-30T16:15:00Z 58064 9117                                 25 797 2932 42819 totalTestsViral 5581 42819 25 54 47baf105b140bc2b64ca6a8b21f6b0493add42b1 0 0 0 0 0  
10103 20200330 MD 1413 13316   14729   353           A 3/30/2020 10:00 2020-03-30T10:00:00Z 03/30 06:00 35 353 2020-03-30T10:00:00Z 13204 1537   1413 34 1                         24 174 962 14729 posNeg 1136 14729 11 76 81d3e1d2ef85c5bad3ec6b21dc7b615178e2fe7e 0 0 0 0 0  
10104 20200330 ME 275 3394   3669   49         41 A 3/30/2020 12:00 2020-03-30T12:00:00Z 03/30 08:00 3 49 2020-03-30T12:00:00Z       275                             23 22 0 3669 posNeg 22 3669 0 49 7c6a8f84d8931ec456ea2c1e2eb0bb918cf5b113 0 0 0 0 0  
10105 20200330 MI 17363 23263   40626               B 3/30/2020 16:00 2020-03-30T16:00:00Z 03/30 12:00 437   2020-03-30T16:00:00Z 32172 8909 23263 17058 518 29                         26 1579 5846 40626 posNeg 7425 40626 86 0 349800c122ab3392fa9a11e39275a49889c44d14 0 0 0 0 0  
10106 20200330 MN 823 19512   20335 56 92 24 24       A 3/30/2020 00:00 2020-03-30T00:00:00Z 03/29 20:00 10 92 2020-03-30T00:00:00Z       823     20335                       27 98 946 20335 posNeg 1044 20335 1 17 e6ea27d08ca9b9822914ff94c26e73fed795d68e 0 0 0 0 0  
10107 20200330 MO 1031 13204   14235               C 3/30/2020 16:00 2020-03-30T16:00:00Z 03/30 12:00 13   2020-03-30T16:00:00Z 18299 1898 16387 1031                             29 193 1657 14235 posNeg 1850 14235 3 0 700f6f143d67c0e709caad7d19242910b798576e 0 0 0 0 0  
10108 20200330 MP 2     2                 3/30/2020 01:30 2020-03-30T01:30:00Z 03/29 21:30     2020-03-30T01:30:00Z                                     69 0 0 2 posNeg 0 2 0 0 6ffdffde1257371ad982b7061de5df8345fc225c 0 0 0 0 0  
10110 20200330 MT 171 4143   4314   10           A 3/30/2020 10:00 2020-03-30T10:00:00Z 03/30 06:00 4 10 2020-03-30T10:00:00Z 3885                                   30 17 0 4314 posNeg 17 4314 3 2 76133602f3bfea6f5d00a8a9d3b1d5b4039d9fd9 0 0 0 0 0  
10111 20200330 NC 1307 19557   20864 137             A 3/30/2020 11:00 2020-03-30T11:00:00Z 03/30 07:00 6   2020-03-30T11:00:00Z                                     37 267 1652 20864 posNeg 1919 20864 2 0 d23fb6e92aff3cdc0c77e8575e1d2f9eca213b11 0 0 0 0 0  
10112 20200330 ND 107 3728   3868   19         19 B 3/30/2020 12:00 2020-03-30T12:00:00Z 03/30 08:00 2 19 2020-03-30T12:00:00Z 3892     107     3868 3743                     38 10 373 3835 totalTestEncountersViral 294 3835 1 2 5e6c20c3a848abd62b2687cc1f28e1d867a56fa6 0 0 0 0 0  
10113 20200330 NE 145 2584 5 2729               A 3/30/2020 14:30 2020-03-30T14:30:00Z 03/30 10:30 2   2020-03-30T14:30:00Z               2734                     31 37 616 2734 posNeg 653 2729 0 0 7e957680c836c5762343c239214626d83d6a5a18 0 0 0 0 0  
10117 20200330 NV 996 10207   11203               A 3/30/2020 12:00 2020-03-30T12:00:00Z 03/30 08:00 32   2020-03-30T12:00:00Z 13349     996                             32 258 1795 11203 posNeg 2053 11203 4 0 98d2fbfc18d5f7feeb8f7bf9e7dd0835a8cbe170 0 0 0 0 0  
10119 20200330 OH 1933 25342   27275   475   163       B 3/30/2020 14:00 2020-03-30T14:00:00Z 03/30 10:00 39 475 2020-03-30T14:00:00Z       1933                             39 280 6330 27275 posNeg 6610 27275 10 72 cc34ca508f108a9c54a59523c56304175ec6a0f8 0 0 0 0 0  
10120 20200330 OK 481 1207   1688   153 103         B 3/30/2020 08:00 2020-03-30T08:00:00Z 03/30 04:00 17 153 2020-03-30T08:00:00Z                                     40 52 2 1688 posNeg 54 1688 1 13 405bc10c4a5a9b52ad33a715006473b5be86b9af 0 0 0 0 0  
10121 20200330 OR 606 12277   12883 132 140     39     A 3/30/2020 11:00 2020-03-30T11:00:00Z 03/30 07:00 16 140 2020-03-30T11:00:00Z                                     41 58 1399 12883 posNeg 1457 12883 3 11 3a4b8e7ef2fc6ed651434fab880f4941b2e44c00 0 0 0 0 0  
10122 20200330 PA 4087 33777   37864   386           A 3/30/2020 12:00 2020-03-30T12:00:00Z 03/30 08:00 49 386 2020-03-30T12:00:00Z               37864                     42 693 3716 37864 posNeg 4409 37864 11 33 432cfc467aaa022a92745f9dcfdcec45791f73ab 0 0 0 0 0  
10123 20200330 PR 174 931 794 1105               A 3/30/2020 07:00 2020-03-30T07:00:00Z 03/30 03:00 6   2020-03-30T07:00:00Z                                     72 47 90 1899 posNeg 137 1105 1 0 7c293601a5d8b51f2a4bc5e73e79f51a49c59c55 0 0 0 0 0  
10124 20200330 RI 495 3246   3613 41   9   6     B 3/30/2020 03:00 2020-03-30T03:00:00Z 03/29 23:00 4   2020-03-30T03:00:00Z 3933 484 3449 495     3613 3741                     44 78 190 3741 totalTestEncountersViral 450 3741 1 0 c3635901cfdc15ad7006fb61d2866ac538599a60 0 0 0 0 0  
10125 20200330 SC 925 4160   5085   102           B 3/30/2020 16:00 2020-03-30T16:00:00Z 03/30 12:00 18 102 2020-03-30T16:00:00Z       925                             45 151 1145 5085 posNeg 1296 5085 2 0 8222bb4aa469657003fa0e4e5809479ae1196d60 0 0 0 0 0  
10126 20200330 SD 101 3478 0 3579             34 A 3/30/2020 12:30 2020-03-30T12:30:00Z 03/30 08:30 1   2020-03-30T12:30:00Z               3579                     46 11 351 3579 posNeg 362 3579 0 0 3b99fe44d0fbf10566fc0b8dd321e33744c4d751 0 0 0 0 0  
10127 20200330 TN 1834 21470   23304   148           A 3/30/2020 15:00 2020-03-30T15:00:00Z 03/30 11:00 13 148 2020-03-30T15:00:00Z                                     47 297 2433 23304 posNeg 2730 23304 6 15 4df4fab4340f6daab5f4125d83061cbaf5f632b4 0 0 0 0 0  
10128 20200330 TX 2877 33003   35880             38 A 3/30/2020 12:45 2020-03-30T12:45:00Z 03/30 08:45 34   2020-03-30T12:45:00Z       2877                             48 325 9795 35880 posNeg 10120 35880 0 0 617d02733d60699547d971ceb681de58963336d6 0 0 0 0 0  
10129 20200330 UT 806 15197   16003               A 3/30/2020 15:00 2020-03-30T15:00:00Z 03/30 11:00 4   2020-03-30T15:00:00Z       806                             49 87 1923 16003 posNeg 2010 16003 2 0 b4fc20abfe884d22c68fb7e0559caafad291169e 0 0 0 0 0  
10130 20200330 VA 1020 11018   19708   136           A 3/30/2020 00:00 2020-03-30T00:00:00Z 03/29 20:00 25 136 2020-03-30T00:00:00Z   3613         19708                       51 130 1299 12038 posNeg 1386 12038 3 24 f4662d0203413e7ed39b21a4afd5ebed2aef0a02 0 0 0 0 0  
10131 20200330 VI 30 126 24 156                 3/30/2020 11:00 2020-03-30T11:00:00Z 03/30 07:00     2020-03-30T11:00:00Z                                     78 7 3 180 posNeg 10 156 0 0 a60a10a532d97dc76143af465e60e8612183efce 0 0 0 0 0  
10132 20200330 VT 293 3718   4011   18           A 3/30/2020 00:00 2020-03-30T00:00:00Z 03/29 20:00 12 18 2020-03-30T00:00:00Z       293                             50 37 235 4011 posNeg 272 4011 0 0 16cc44766d4240fdc47056aca64fee06c0a694b9 0 0 0 0 0  
10133 20200330 WA 6484 77047   83531               A 3/30/2020 00:00 2020-03-30T00:00:00Z 03/29 20:00 248   2020-03-30T00:00:00Z       6484     83531 80687                     53 563 4887 83531 posNeg 5450 83531 11 0 1803a5560bf9e6d72b9e6b9f473c2a2ca066cf14 0 0 0 0 0  
10134 20200330 WI 1422 15856   17278               A 3/30/2020 16:00 2020-03-30T16:00:00Z 03/30 12:00 14   2020-03-30T16:00:00Z       1221                             55 146 -694 17278 posNeg -548 17278 1 0 63cc9b10a51a4e91a14af125188942da51998d96 0 0 0 0 0  
10135 20200330 WV 126 2984 0 3110   1           B 3/30/2020 14:10 2020-03-30T14:10:00Z 03/30 10:10 1 1 2020-03-30T14:10:00Z       126                             54 13 279 3110 posNeg 292 3110 1 0 5f8ac5e1685384f03374dfe2ce528cabd8511332 0 0 0 0 0  
10136 20200330 WY 94 1840   1934   17         24 A 3/30/2020 00:00 2020-03-30T00:00:00Z 03/29 20:00 0 17 2020-03-30T00:00:00Z       87                             56 8 286 1934 posNeg 294 1934 0 2 801e151b2494908fa8d772721975cff4fe9d05ef 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
);