us_daily

Table actions

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

9 rows where states = 51

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospitalizedCumulative, hospitalized, deathIncrease, hospitalizedIncrease, dateChecked (date), lastModified (date)

states ✖

Link rowid ▼ date states positive negative pending hospitalizedCurrently hospitalizedCumulative inIcuCurrently inIcuCumulative onVentilatorCurrently onVentilatorCumulative recovered dateChecked death hospitalized totalTestResults lastModified total posNeg deathIncrease hospitalizedIncrease negativeIncrease positiveIncrease totalTestResultsIncrease hash
196 196 20200315 51 6022 34661 2242   36           2020-03-15T00:00:00Z 79 36 50315 2020-03-15T00:00:00Z 0 0 15 10 6553 1291 8300 f2116e781a933964b1686990c60ec902c85bb35b
197 197 20200314 51 4731 28108 1236   26           2020-03-14T00:00:00Z 64 26 42015 2020-03-14T00:00:00Z 0 0 9 4 3852 924 5722 31730b999cbe5aa48accc2635322b0da691522a4
198 198 20200313 51 3807 24256 1130   22           2020-03-13T00:00:00Z 55 22 36293 2020-03-13T00:00:00Z 0 0 4 6 8318 1072 10334 6aef71d10e553aa5c487a8ad2c2fa438bf271d4d
199 199 20200312 51 2735 15938 673   16           2020-03-12T00:00:00Z 51 16 25959 2020-03-12T00:00:00Z 0 0 8 5 4750 671 5793 8f74948e15795425a8ada260a0485c7c16643003
200 200 20200311 51 2064 11188 563   11           2020-03-11T00:00:00Z 43 11 20166 2020-03-11T00:00:00Z 0 0 6 3 3421 509 4028 884dfdceeb275b5123ffd77c797676d8bca323c1
201 201 20200310 51 1555 7767 469   8           2020-03-10T00:00:00Z 37 8 16138 2020-03-10T00:00:00Z 0 0 2 0 2184 387 2676 1380c1a775812ed78a9fe97f1dde9434303dc4af
202 202 20200309 51 1168 5583 313   8           2020-03-09T00:00:00Z 35 8 13462 2020-03-09T00:00:00Z 0 0 4 2 1534 292 1894 99e63e1d64701a2395977269e9998a2118249bc9
203 203 20200308 51 876 4049 347   6           2020-03-08T00:00:00Z 31 6 11568 2020-03-08T00:00:00Z 0 0 4 0 716 198 935 c1456b253c0021edfbeecaad122219c80d63b26b
204 204 20200307 51 678 3333 602   6           2020-03-07T00:00:00Z 27 6 10633 2020-03-07T00:00:00Z 0 0 1 0 661 178 919 f5a3205f9f4185d62c37212e131733c6a8baf9e2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us_daily] (
   [date] INTEGER,
   [states] INTEGER,
   [positive] INTEGER,
   [negative] INTEGER,
   [pending] INTEGER,
   [hospitalizedCurrently] INTEGER,
   [hospitalizedCumulative] INTEGER,
   [inIcuCurrently] INTEGER,
   [inIcuCumulative] INTEGER,
   [onVentilatorCurrently] INTEGER,
   [onVentilatorCumulative] INTEGER,
   [recovered] INTEGER,
   [dateChecked] TEXT,
   [death] INTEGER,
   [hospitalized] INTEGER,
   [totalTestResults] INTEGER,
   [lastModified] TEXT,
   [total] INTEGER,
   [posNeg] INTEGER,
   [deathIncrease] INTEGER,
   [hospitalizedIncrease] INTEGER,
   [negativeIncrease] INTEGER,
   [positiveIncrease] INTEGER,
   [totalTestResultsIncrease] INTEGER,
   [hash] TEXT
);