us_current

Table actions
Data provided by Big Local News and snapshotted daily from the COVID19 Tracker, https://covidtracking.com/.

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

1 row

✎ 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 dateChecked death hospitalized totalTestResults lastModified recovered total posNeg deathIncrease hospitalizedIncrease negativeIncrease positiveIncrease totalTestResultsIncrease hash
1 1 20210301 56 28399281 116726735 11748 46738 869030 9595 44956 3171 4252 2021-03-01T24:00:00Z 504488 869030 355718749 2021-03-01T24:00:00Z   0 0 1241 1024 312729 48092 1224297 9fa2cf8612e1dbef200b5e52c0756db7a7dbc3db

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us_current] (
   [date] INTEGER,
   [states] INTEGER,
   [positive] INTEGER,
   [negative] INTEGER,
   [pending] INTEGER,
   [hospitalizedCurrently] INTEGER,
   [hospitalizedCumulative] INTEGER,
   [inIcuCurrently] INTEGER,
   [inIcuCumulative] INTEGER,
   [onVentilatorCurrently] INTEGER,
   [onVentilatorCumulative] INTEGER,
   [dateChecked] TEXT,
   [death] INTEGER,
   [hospitalized] INTEGER,
   [totalTestResults] INTEGER,
   [lastModified] TEXT,
   [recovered] TEXT,
   [total] INTEGER,
   [posNeg] INTEGER,
   [deathIncrease] INTEGER,
   [hospitalizedIncrease] INTEGER,
   [negativeIncrease] INTEGER,
   [positiveIncrease] INTEGER,
   [totalTestResultsIncrease] INTEGER,
   [hash] TEXT
);