us_daily
Data source: Big Local News · About: big-local-datasette
3 rows where states = 6
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 208 | 208 | 20200303 | 6 | 142 | 446 | 2020-03-03T00:00:00Z | 14 | 7081 | 2020-03-03T00:00:00Z | 0 | 0 | 3 | 0 | 203 | 48 | 266 | 0e8c1af100ae67bb89dbe9e005aaa1bcd6109dcf | |||||||||
| 209 | 209 | 20200302 | 6 | 94 | 243 | 2020-03-02T00:00:00Z | 11 | 6815 | 2020-03-02T00:00:00Z | 0 | 0 | 3 | 0 | 158 | 44 | 212 | 960d118b365aeb9ca36e7ec4f1fc03dc27477b42 | |||||||||
| 210 | 210 | 20200301 | 6 | 50 | 85 | 2020-03-01T00:00:00Z | 8 | 6603 | 2020-03-01T00:00:00Z | 0 | 0 | 3 | 0 | 61 | 32 | 95 | 0a8489cd64cba2a58e40cbaf08fe85fc39b7ed7a |
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 );