us_daily
Data source: Big Local News · About: big-local-datasette
3 rows where states = 4
This data as json, copyable, CSV (advanced)
Suggested facets: positive, negative, negativeIncrease, positiveIncrease, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
211 | 211 | 20200229 | 4 | 18 | 24 | 2020-02-29T00:00:00Z | 5 | 6508 | 2020-02-29T00:00:00Z | 0 | 0 | 1 | 0 | 24 | 18 | 45 | f277bd581cd1b950ed31fc1329f419d07789bfb3 | |||||||||
212 | 212 | 20200228 | 4 | 0 | 0 | 2020-02-28T00:00:00Z | 4 | 6463 | 2020-02-28T00:00:00Z | 0 | 0 | 2 | 0 | 0 | 0 | 2 | fc71284176ff3c9afe91eb6b38ec2bcb4f6d9b00 | |||||||||
213 | 213 | 20200227 | 4 | 0 | 0 | 2020-02-27T00:00:00Z | 2 | 6461 | 2020-02-27T00:00:00Z | 0 | 0 | 0 | 0 | 0 | 0 | 6445 | f4ceecb04650071da461a78b3ee71d2db0d9f1d1 |
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 );