us_daily

Table actions

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

17 rows where states = 3 sorted by totalTestResultsIncrease

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: death, totalTestResults, deathIncrease, totalTestResultsIncrease, dateChecked (date), lastModified (date)

states ✖

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
214 214 20200226 3 0 0                 2020-02-26T00:00:00Z 2   16 2020-02-26T00:00:00Z 0 0 2 0 0 0 0 88ff709458f5e570aa95d9002621ec53dd6faf15
215 215 20200225 3 0 0                 2020-02-25T00:00:00Z 0   16 2020-02-25T00:00:00Z 0 0 0 0 0 0 0 ce4b70c11134885e6f866ae953ed5ef639fec758
217 217 20200223 3 0 0                 2020-02-23T00:00:00Z 0   14 2020-02-23T00:00:00Z 0 0 0 0 0 0 0 d54558512aee04a67bee3e4fd483ff040374485e
218 218 20200222 3 0 0                 2020-02-22T00:00:00Z 0   14 2020-02-22T00:00:00Z 0 0 0 0 0 0 0 ace3be8a7a784360fee61ac90b3de1708be932c1
219 219 20200221 3 0 0                 2020-02-21T00:00:00Z 0   14 2020-02-21T00:00:00Z 0 0 0 0 0 0 0 aec622bd9cf9d4335dd1e1fbf00727387fe54313
221 221 20200219 3 0 0                 2020-02-19T00:00:00Z 0   13 2020-02-19T00:00:00Z 0 0 0 0 0 0 0 d87d16e44192f2dce7e4ace8459e75783d551ba8
222 222 20200218 3 0 0                 2020-02-18T00:00:00Z 0   13 2020-02-18T00:00:00Z 0 0 0 0 0 0 0 adfa0f4e8ddd117785a17a76d16f68c7d6652614
223 223 20200217 3 0 0                 2020-02-17T00:00:00Z 0   13 2020-02-17T00:00:00Z 0 0 0 0 0 0 0 af93e0c06093eeecb060317edfdf3f74cd8278c5
224 224 20200216 3 0 0                 2020-02-16T00:00:00Z 0   13 2020-02-16T00:00:00Z 0 0 0 0 0 0 0 8d23e941b4388412613e42677f905aa6287ae90b
225 225 20200215 3 0 0                 2020-02-15T00:00:00Z 0   13 2020-02-15T00:00:00Z 0 0 0 0 0 0 0 d7a9f97799dfc61c85407ece59477b4dbe4d5b3d
226 226 20200214 3 0 0                 2020-02-14T00:00:00Z 0   13 2020-02-14T00:00:00Z 0 0 0 0 0 0 0 159a2118506d79661b4fc35f63224f90bcb612ae
227 227 20200213 3 0 0                 2020-02-13T00:00:00Z 0   13 2020-02-13T00:00:00Z 0 0 0 0 0 0 0 1bf102314bcde1d57a2e43bb83e6b76ccbdfccf8
229 229 20200211 3 0 0                 2020-02-11T00:00:00Z 0   12 2020-02-11T00:00:00Z 0 0 0 0 0 0 0 5ca64e69947cb85e7170909c994c2b8ffd1a46c7
220 220 20200220 3 0 0                 2020-02-20T00:00:00Z 0   14 2020-02-20T00:00:00Z 0 0 0 0 0 0 1 c00eabd9b34ab3f4e56330880d48f1f26dce8c86
228 228 20200212 3 0 0                 2020-02-12T00:00:00Z 0   13 2020-02-12T00:00:00Z 0 0 0 0 0 0 1 51ce7260099393dfa67a8494f995b83ced4e60de
230 230 20200210 3 0 0                 2020-02-10T00:00:00Z 0   12 2020-02-10T00:00:00Z 0 0 0 0 0 0 1 efeb566ff660225d4993ae0e1823317ab6256946
216 216 20200224 3 0 0                 2020-02-24T00:00:00Z 0   16 2020-02-24T00:00:00Z 0 0 0 0 0 0 2 d362cf06785b2f3d30940a936ab83ea5bd3f94ad

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