us_daily
Data source: Big Local News · About: big-local-datasette
1 row where "dateChecked" is on date 2020-04-11 and states = 56
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
169 | 169 | 20200411 | 56 | 532800 | 2198468 | 16593 | 55573 | 67591 | 13285 | 1405 | 5978 | 154 | 31567 | 2020-04-11T00:00:00Z | 22162 | 67591 | 2773770 | 2020-04-11T00:00:00Z | 0 | 0 | 2055 | 2825 | 106592 | 30506 | 139037 | 4bca98ab3fe04d3f459c918244fed0a1c58b72e4 |
Advanced export
JSON shape: default, array, newline-delimited
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 );