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

1 row where states = 25

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
206 20200305 25 388 1949 197   5           2020-03-05T00:00:00Z 20 5 8841 2020-03-05T00:00:00Z 0 0 4 1 532 107 641 16ccaf4b89ce2bf86dac0d0910744e205340c835

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