states_daily_4pm_et

Table actions

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

42 rows where "dateModified" is on date 2020-03-14

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, hospitalizedCumulative, lastUpdateEt, dateModified, checkTimeEt, death, hospitalized, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, positiveIncrease, negativeIncrease, totalTestResultsSource, deathIncrease, hospitalizedIncrease, 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
10700 10700 20200319 AS       0                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00 0   2020-03-14T00:00:00Z 0     0                             60 0 0 0 posNeg 0 0 0 0 ee978d82333b52c69c28ab15558c64a90716e9f7 0 0 0 0 0  
10756 10756 20200318 AS       0                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00 0   2020-03-14T00:00:00Z 0     0                             60 0 0 0 posNeg 0 0 0 0 85dde723a0ea8428498b88bfe3ce9d1a10add115 0 0 0 0 0  
10812 10812 20200317 AS       0                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00     2020-03-14T00:00:00Z 0     0                             60 0 0 0 posNeg 0 0 0 0 866e05d9a716e95bba31b9b00cff84c78ee79a3b 0 0 0 0 0  
10925 10925 20200315 CA 293 916   1209                 3/14/2020 11:00 2020-03-14T11:00:00Z 03/14 07:00 5   2020-03-14T11:00:00Z 1209                                   6 41 0 1209 posNeg 41 1209 0 0 ccb7245f7066e1d6369d2955c077234e94eb6500 0 0 0 0 0  
10927 10927 20200315 CT 20 125   145                 3/14/2020 17:00 2020-03-14T17:00:00Z 03/14 13:00     2020-03-14T17:00:00Z                                     9 9 0 145 posNeg 9 145 0 0 fd0a1ec5d80c73883da94a3b98fa594763fa5e95 0 0 0 0 0  
10928 10928 20200315 DC 16 79 20 95                 3/14/2020 19:30 2020-03-14T19:30:00Z 03/14 15:30     2020-03-14T19:30:00Z             95                       11 6 30 115 posNeg 36 95 0 0 d7cd2f4a7de509734a09d8d47ed72d36130b6090 0 0 0 0 0  
10929 10929 20200315 DE 6 36 32 42                 3/14/2020 13:00 2020-03-14T13:00:00Z 03/14 09:00 0   2020-03-14T13:00:00Z         0 0                         10 0 0 74 posNeg 0 42 0 0 2f1cb8b45a911081d916f5142dc3548e6ead7005 0 0 0 0 0  
10933 10933 20200315 IA 18 83   101                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00     2020-03-14T00:00:00Z       18                             19 1 0 101 posNeg 1 101 0 0 e89bd63a2397dd7b2e0e7cb66b24a53113133619 0 0 0 0 0  
10935 10935 20200315 IL 64 449 195 513                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00     2020-03-14T00:00:00Z                                     17 18 133 708 posNeg 151 513 0 0 77c59b3cdca3d7801992234c81a6abc0e5ad5e35 0 0 0 0 0  
10937 10937 20200315 KS 8 135   143                 3/14/2020 13:00 2020-03-14T13:00:00Z 03/14 09:00 1   2020-03-14T13:00:00Z                                     20 2 42 143 posNeg 44 143 0 0 2729a9f63fae4f5a67f5b1c2c8806dd4a3293d52 0 0 0 0 0  
10938 10938 20200315 KY 16 139   155                 3/14/2020 16:00 2020-03-14T16:00:00Z 03/14 12:00 1   2020-03-14T16:00:00Z 155                                   21 2 0 155 posNeg 2 155 0 0 10a7d4eea7c04bc7d33ae3a89321e8ee72bb464f 0 0 0 0 0  
10940 10940 20200315 MA 64 584   4120                 3/14/2020 16:00 2020-03-14T16:00:00Z 03/14 12:00     2020-03-14T16:00:00Z 4120 380                                 25 26 584 648 totalTestsViral 1084 648 0 0 d8392e695deec5357e71e3e123bd09f9087f6537 0 0 0 0 0  
10943 10943 20200315 MI 2188 205 26 2393                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00     2020-03-14T00:00:00Z       2175 0 1                         26 460 0 2419 posNeg 460 2393 0 0 7acf2e74d3729bce742c5375f63488d383d6890d 0 0 0 0 0  
10945 10945 20200315 MO 5 122   127                 3/14/2020 22:00 2020-03-14T22:00:00Z 03/14 18:00 0   2020-03-14T22:00:00Z 188 19 168 5                             29 1 32 127 posNeg 33 127 0 0 dce50eeb6c14bdba6b89c8edf21cbf637627057a 0 0 0 0 0  
10946 10946 20200315 MS 10 84   94                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00     2020-03-14T00:00:00Z                                     28 4 0 94 posNeg 4 94 0 0 0cf0c76bc690baaa4d0ff2d3ea8ffaa438aed279 0 0 0 0 0  
10947 10947 20200315 MT 7 103 57 110                 3/14/2020 17:52 2020-03-14T17:52:00Z 03/14 13:52     2020-03-14T17:52:00Z                                     30 2 0 167 posNeg 2 110 0 0 27dce4fe7e83919e534c545caf603502d265dc81 0 0 0 0 0  
10954 10954 20200315 NV 45 168 164 213                 3/14/2020 17:05 2020-03-14T17:05:00Z 03/14 13:05 1   2020-03-14T17:05:00Z       45                             32 11 0 377 posNeg 11 213 1 0 8d9b2953631ad96a2f328e7465e93340a670e3e5 0 0 0 0 0  
10958 10958 20200315 OR 36 420 225 456                 3/14/2020 14:00 2020-03-14T14:00:00Z 03/14 10:00     2020-03-14T14:00:00Z                                     41 6 83 681 posNeg 89 456 0 0 0f4c2eed08449f9b66b43001d9007a52524e1ee0 0 0 0 0 0  
10961 10961 20200315 SC 19 154   173                 3/14/2020 16:18 2020-03-14T16:18:00Z 03/14 12:18     2020-03-14T16:18:00Z       19                             45 6 44 173 posNeg 50 173 0 0 dcaaf78ea1e8e6cfe20b776c56ce8c7f5b262697 0 0 0 0 0  
10969 10969 20200315 WI 37 313   350                 3/14/2020 15:00 2020-03-14T15:00:00Z 03/14 11:00     2020-03-14T15:00:00Z       33                             55 14 144 350 posNeg 158 350 0 0 5fb0d8438d4af1bf818ab8f018dabf7ff23b5c1b 0 0 0 0 0  
10970 10970 20200315 WV 0 38 1 38                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00 0   2020-03-14T00:00:00Z       0                             54 0 12 39 posNeg 12 38 0 0 16164c27666671775230f02a942171831e6c4e33 0 0 0 0 0  
10971 10971 20200315 WY 3     3                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00     2020-03-14T00:00:00Z       2                             56 1 0 3 posNeg 1 3 0 0 3efc0c35fd5b11255cc0db412b0aa8cc735c9d33 0 0 0 0 0  
10975 10975 20200314 AZ 12 121 50 133   26             3/14/2020 12:01 2020-03-14T12:01:00Z 03/14 08:01 0 26 2020-03-14T12:01:00Z               133                     4 3 27 183 posNeg 30 133 0 4 b3bc527ea6af4a674cb08a4ac721eeca017e1710 0 0 0 0 0  
10977 10977 20200314 CO 101 610   333                 3/14/2020 14:00 2020-03-14T14:00:00Z 03/14 10:00 1   2020-03-14T14:00:00Z             333                       8 29 86 711 totalTestEncountersViral 135 711 1 0 663b7777b262c133e7a7bcb8e9ae898eaf8a5453 0 0 0 0 0  
10980 10980 20200314 DE 6 36 32 42                 3/14/2020 13:00 2020-03-14T13:00:00Z 03/14 09:00 0   2020-03-14T13:00:00Z         0 0                         10 2 6 74 posNeg 8 42 0 0 96f5e17e7d3c065c88c36433411f991d739896e0 0 0 0 0 0  
10981 10981 20200314 FL 77 478 221 555                 3/14/2020 00:54 2020-03-14T00:54:00Z 03/13 20:54 3   2020-03-14T00:54:00Z                                     12 27 0 776 posNeg 27 555 1 0 30e0673b83a6335878df508cadb086279d1cce50 0 0 0 0 0  
10982 10982 20200314 GA 66     66                 3/14/2020 12:00 2020-03-14T12:00:00Z 03/14 08:00 1   2020-03-14T12:00:00Z 66                                   13 24 0 66 posNeg 24 66 0 0 7cdaaffe0387cb3e75a49467c92695bae52b7493 0 0 0 0 0  
10990 10990 20200314 LA 51 109   160                 3/14/2020 12:15 2020-03-14T12:15:00Z 03/14 08:15     2020-03-14T12:15:00Z       51                             22 15 72 160 posNeg 87 160 0 0 d77bd95500876c0129ae65b78b85cef5db2f8894 0 0 0 0 0  
10991 10991 20200314 MA 38     3036                 3/14/2020 16:00 2020-03-14T16:00:00Z 03/14 12:00     2020-03-14T16:00:00Z 3036 308                                 25 15 0 38 totalTestsViral 935 38 0 0 8830304b5133a6666836dc49570feb00de0db53a 0 0 0 0 0  
10992 10992 20200314 MD 26 94   120                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00     2020-03-14T00:00:00Z       26                             24 9 0 120 posNeg 9 120 0 0 19976007b55996a7806cb10b07600b6556037091 0 0 0 0 0  
10995 10995 20200314 MN 90 847   937                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00     2020-03-14T00:00:00Z       90     937                       27 28 306 937 posNeg 334 937 0 0 c02746e369dbb613d6847e6e5525b6ef9c62b151 0 0 0 0 0  
10999 10999 20200314 NC 23 137   160                 3/14/2020 12:00 2020-03-14T12:00:00Z 03/14 08:00     2020-03-14T12:00:00Z                                     37 8 51 160 posNeg 59 160 0 0 63a606d4e7f6899ae5d04579fd51201e4c03dcea 0 0 0 0 0  
11002 11002 20200314 NH 7 212 31 319                 3/14/2020 09:00 2020-03-14T09:00:00Z 03/14 05:00     2020-03-14T09:00:00Z 319                                   33 1 118 250 posNeg 70 219 0 0 c7ba1fb4035cf982276d8d7dadbabe169919102b 0 0 0 0 0  
11005 11005 20200314 NV 34 168   202                 3/14/2020 12:33 2020-03-14T12:33:00Z 03/14 08:33 0   2020-03-14T12:33:00Z       34                             32 12 0 202 posNeg 12 202 0 0 f3267d83534e457be2bed81d5444d24410141d7e 0 0 0 0 0  
11006 11006 20200314 NY 524 2779   3303                 3/14/2020 12:30 2020-03-14T12:30:00Z 03/14 08:30     2020-03-14T12:30:00Z                                     36 103 0 3303 posNeg 103 3303 0 0 a12739d8c83e471e0ba7d12ef9bae20fa6db782a 0 0 0 0 0  
11010 11010 20200314 PA 47 205 150 252                 3/14/2020 14:00 2020-03-14T14:00:00Z 03/14 10:00     2020-03-14T14:00:00Z               252                     42 6 65 402 posNeg 71 252 0 0 6bef17c55611f2e37c03f526679a0317f960c6f1 0 0 0 0 0  
11011 11011 20200314 RI 19 310 57 257                 3/14/2020 03:00 2020-03-14T03:00:00Z 03/13 23:00     2020-03-14T03:00:00Z 347 21 326 19     257 329                     44 0 86 386 totalTestEncountersViral 56 329 0 0 991a3cdc667bbe4e289b86050ada55db47a81d1d 0 0 0 0 0  
11013 11013 20200314 SD 9 182 3 191                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00     2020-03-14T00:00:00Z               191                     46 0 109 194 posNeg 109 191 0 0 26126166a8a522d6dedf96ba873443dcc8db530a 0 0 0 0 0  
11014 11014 20200314 TN 32 130   162                 3/14/2020 15:00 2020-03-14T15:00:00Z 03/14 11:00     2020-03-14T15:00:00Z                                     47 6 14 162 posNeg 20 162 0 0 645124e2635f6eccbdb52316934d7ec63f89428e 0 0 0 0 0  
11015 11015 20200314 TX 51     51                 3/14/2020 13:00 2020-03-14T13:00:00Z 03/14 09:00     2020-03-14T13:00:00Z       51                             48 12 0 51 posNeg 12 51 0 0 2177af42c69e5598339f0e89709f43fa7819824f 0 0 0 0 0  
11018 11018 20200314 VT 8 332   340                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00     2020-03-14T00:00:00Z                                     50 3 109 340 posNeg 112 340 0 0 3ef111477f1ee9299ea56e37627dae2bb7c963f5 0 0 0 0 0  
11019 11019 20200314 WA 1174 17142   18316                 3/14/2020 00:00 2020-03-14T00:00:00Z 03/13 20:00 51   2020-03-14T00:00:00Z       1174     18316 17932                     53 156 2220 18316 posNeg 2376 18316 4 0 9e92d33a9536fc7f676ad24efa4ca5bb29b33023 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
);