us_daily

Table actions

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

9 rows where states = 51 sorted by hospitalizedCurrently

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