us_daily

Table actions

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

1 row where "dateChecked" is on date 2020-04-04 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
176 176 20200404 56 317434 1372626 15569 30266 41768 5500 554 656 147 12816 2020-04-04T00:00:00Z 9264 41768 1718965 2020-04-04T00:00:00Z 0 0 1482 5086 196066 33212 228797 512b09ab573545a623f900b5bc40379340199fda

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