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

1 row where states = 18 sorted by hospitalizedCurrently

View and edit SQL

Suggested facets: 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
207 20200304 18 281 1417 103   4           2020-03-04T00:00:00Z 16 4 8200 2020-03-04T00:00:00Z 0 0 2 4 971 139 1119 14b59f214bb410a2e0bd7cba0d06477f89a7c09d

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