us_daily

Table actions

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

1 row where "dateChecked" is on date 2020-03-16 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
195 195 20200316 56 7770 51186 1691   42           2020-03-16T00:00:00Z 100 42 70438 2020-03-16T00:00:00Z 0 0 21 6 16525 1748 20123 0284a2b8cab2e0e76ca54012b98de73c02afb45a

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