us_daily

Table actions

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

1 row where "dateChecked" is on date 2020-04-03 and states = 56

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: dateChecked (date), lastModified (date)

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
177 177 20200403 56 284222 1176560 61976 25729 36682 4928 486 605 147 10861 2020-04-03T00:00:00Z 7782 36682 1490168 2020-04-03T00:00:00Z 0 0 1286 4554 101013 32076 133020 2a79d9f9d02632c8d558fdb2fe3172522aaa5fff

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