states_daily_4pm_et

Table actions

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

20 rows where dataQualityGrade = "B" and "dateModified" is on date 2020-06-11

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, state, positive, negative, totalTestResults, hospitalizedCurrently, hospitalizedCumulative, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, recovered, 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, total, posNeg, 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
5944 5944 20200612 CT 44689 300443   345132 244 9912         7611 B 6/11/2020 20:30 2020-06-11T20:30:00Z 06/11 16:30 4159 9912 2020-06-11T20:30:00Z 342338     41895 3321 838                         9 228 13833 345132 posNeg 14061 345132 13 0 280ed8d179a3723f2d06e8830e37782382edae42 0 0 0 0 0  
5956 5956 20200612 KY 11945 269149   280786 514 2406 81 967     3379 B 6/11/2020 00:00 2020-06-11T00:00:00Z 06/10 20:00 493 2406 2020-06-11T00:00:00Z 280786     11637 491 2     28319                   21 0 0 281094 posNeg 0 281094 0 0 ff757a1688fd691f02f9fec85225e3634747be8e 0 0 0 0 0  
5982 5982 20200612 SD 5742 57263   63005 87 525         4755 B 6/11/2020 18:00 2020-06-11T18:00:00Z 06/11 14:00 74 525 2020-06-11T18:00:00Z               63005                     46 77 1184 63005 posNeg 1261 63005 1 11 f43817818b8886ab5c8a2073e7995765ee4ce1c4 0 0 0 0 0  
5988 5988 20200612 VT 1119 47515   48634 16           907 B 6/11/2020 00:00 2020-06-11T00:00:00Z 06/10 20:00 55   2020-06-11T00:00:00Z       1119 55     48634                     50 9 1416 48634 posNeg 1425 48634 0 0 a285c4bafd69b11cd71fe4f5a8e715ac6c8b51c8 0 0 0 0 0  
5994 5994 20200611 AL 22845 255981   278455 647 2165   650   380 13508 B 6/11/2020 11:00 2020-06-11T11:00:00Z 06/11 07:00 755 2165 2020-06-11T11:00:00Z 278455     22474 750 5                         1 856 4913 278826 posNeg 5761 278826 11 36 3ac56865f4f68f7331657895cdb4372d2863b4b5 0 0 0 0 0  
5998 5998 20200611 CA 139281 2458366   2597647 4534   1325         B 6/11/2020 00:00 2020-06-11T00:00:00Z 06/10 20:00 4881   2020-06-11T00:00:00Z 2597647     139281                             6 3090 53759 2597647 posNeg 56849 2597647 105 0 a0d8ead9736db8f0256b6aa1eae9f706c1fdf443 0 0 0 0 0  
6005 6005 20200611 GU 183 8197   8380             168 B 6/11/2020 08:00 2020-06-11T08:00:00Z 06/11 04:00 5   2020-06-11T08:00:00Z 8366 175 8191 175         109 2                 66 1 97 8380 posNeg 98 8380 0 0 714d818c2be1e50f02e61f49d5cf70c11fa21bc7 0 0 0 0 0  
6009 6009 20200611 IL 131327 991724   1123051 2365   638   379     B 6/11/2020 00:00 2020-06-11T00:00:00Z 06/10 20:00 6363   2020-06-11T00:00:00Z 1122327     130603 6185 178   1122327                     17 766 21559 1123051 posNeg 22325 1123051 90 0 cb120af00c120c372b74743d9d9b109bd888df79 0 0 0 0 0  
6012 6012 20200611 KY 11945 269149   280786 514 2406 81 967     3379 B 6/11/2020 00:00 2020-06-11T00:00:00Z 06/10 20:00 493 2406 2020-06-11T00:00:00Z 280786     11637 491 2     28319                   21 62 6618 281094 posNeg 6679 281094 9 10 64055546c0f2e75e71783112dce8bdd66064365c 0 0 0 0 0  
6013 6013 20200611 LA 44472 425201   469673 553       77   33904 B 6/11/2020 13:00 2020-06-11T13:00:00Z 06/11 09:00 2987   2020-06-11T13:00:00Z       44472 2874 113   469673                     22 442 9111 469673 posNeg 9553 469673 19 0 e0ff3b5671faed5c0e663b9e97e3ccba5978bc48 0 0 0 0 0  
6015 6015 20200611 MD 60197 332173   392370 902 9789 358       4365 B 6/11/2020 10:00 2020-06-11T10:00:00Z 06/11 06:00 2875 9789 2020-06-11T10:00:00Z 457816 69087   60197 2750 125   392370                     24 732 6996 392370 posNeg 7728 392370 31 34 0f0b0fb397f2c3eb53f3825c42122808ed27d6f6 0 0 0 0 0  
6016 6016 20200611 ME 2667 62790   65457 29 308 12   5   2062 B 6/11/2020 12:15 2020-06-11T12:15:00Z 06/11 08:15 100 308 2020-06-11T12:15:00Z 66146 3248 62790 2380 100       5340 261 5071               23 30 1487 65457 posNeg 1517 65457 0 5 40badee45e11d3d8e52f62e737e6b41f96fd0e30 0 0 0 0 0  
6019 6019 20200611 MO 15390 243650   259040 537       59     B 6/11/2020 15:00 2020-06-11T15:00:00Z 06/11 11:00 860   2020-06-11T15:00:00Z 270232 17275 252506 15390       259040       31470 1195 30275         29 203 7208 259040 posNeg 7411 259040 12 0 4ad3928fd34dcdee1f660af9f00b31f28ad2e3c0 0 0 0 0 0  
6031 6031 20200611 OH 40004 472579   512583 563 6753 225 1732 155     B 6/11/2020 14:00 2020-06-11T14:00:00Z 06/11 10:00 2490 6753 2020-06-11T14:00:00Z 509699     37120 2263 227                         39 429 10270 512583 posNeg 10699 512583 33 60 00a3b632d1d80c9a6efb87aae90ac446ab5cbd08 0 0 0 0 0  
6039 6039 20200611 TN 28538 506756   535294 606 2011         18992 B 6/11/2020 15:00 2020-06-11T15:00:00Z 06/11 11:00 441 2011 2020-06-11T15:00:00Z       28340 441     528635                     47 477 5990 535294 posNeg 6467 535294 5 21 0d5edd5a25bd7f18f0b91cb72f74ca01fbc1c3a5 0 0 0 0 0  
6040 6040 20200611 TX 81583 1124737   1206320 2008           54096 B 6/11/2020 21:30 2020-06-11T21:30:00Z 06/11 17:30 1920   2020-06-11T21:30:00Z 1206320     81583         142573 5906                 48 1826 43407 1206320 posNeg 45233 1206320 35 0 cd3ced05ec76bd1f680fe941e3606ff80ef91748 0 0 0 0 0  
6041 6041 20200611 UT 13252 241416   254668 188 968   282   123 7745 B 6/11/2020 10:16 2020-06-11T10:16:00Z 06/11 06:16 131 968 2020-06-11T10:16:00Z       13252       254668             3 3 3 3 49 388 4520 254668 posNeg 4908 254668 3 14 1a90bbc6cc18791b69ff9293054799fdda241ef8 0 0 0 0 0  
6044 6044 20200611 VT 1110 46099   47209 12           905 B 6/11/2020 00:00 2020-06-11T00:00:00Z 06/10 20:00 55   2020-06-11T00:00:00Z       1110 55     47209                     50 15 1452 47209 posNeg 1467 47209 0 0 6bc82a19261cb96470f026ee4df7bb1a58b06e02 0 0 0 0 0  
6045 6045 20200611 WA 26767 449982   476749 226 3773     63     B 6/11/2020 02:59 2020-06-11T02:59:00Z 06/10 22:59 1190 3773 2020-06-11T02:59:00Z       26767 1190   476749 413579                     53 400 11570 476749 posNeg 11970 476749 14 26 c8832438b914f95742b187878de1e0a5150ebf3c 0 0 0 0 0  
6047 6047 20200611 WV 2212 118908   121120 38   8   2   1516 B 6/11/2020 10:00 2020-06-11T10:00:00Z 06/11 06:00 85   2020-06-11T10:00:00Z 122691     2136         7173                   54 24 3106 121120 posNeg 3130 121120 0 0 dfedc036dfdd97a6428f146d17098506f075314a 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
);