us_daily

Table actions

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

19 rows where states = 2

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: totalTestResults, 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
231 231 20200209 2 0 0                 2020-02-09T00:00:00Z     11 2020-02-09T00:00:00Z 0 0 0 0 0 0 0 3cd6db9881e503d5f56df0b20b114bc07c602d7f
232 232 20200208 2 0 0                 2020-02-08T00:00:00Z     11 2020-02-08T00:00:00Z 0 0 0 0 0 0 1 614ea49113ebac5abaf9408f948fc849f9c70ca9
233 233 20200207 2 0 0                 2020-02-07T00:00:00Z     10 2020-02-07T00:00:00Z 0 0 0 0 0 0 0 c2e376cf883b35c951ceeb16b0950532e3d6d4b3
234 234 20200206 2 0 0                 2020-02-06T00:00:00Z     10 2020-02-06T00:00:00Z 0 0 0 0 0 0 1 675efe97a6bbdc1cbbf2d07a78869481ccc91daa
235 235 20200205 2 0 0                 2020-02-05T00:00:00Z     9 2020-02-05T00:00:00Z 0 0 0 0 0 0 0 0156573a9e67c0a0127c84e7a094d57fca91182a
236 236 20200204 2 0 0                 2020-02-04T00:00:00Z     9 2020-02-04T00:00:00Z 0 0 0 0 0 0 2 061686c272d049577f4d20c53e03ed212517f994
237 237 20200203 2 0 0                 2020-02-03T00:00:00Z     7 2020-02-03T00:00:00Z 0 0 0 0 0 0 3 0a85d8c8694207b9adbea434e950988211be5b25
238 238 20200202 2 0 0                 2020-02-02T00:00:00Z     4 2020-02-02T00:00:00Z 0 0 0 0 0 0 0 4996e59b354b0913737e706b4360305a8acbbbc5
239 239 20200201 2 0 0                 2020-02-01T00:00:00Z     4 2020-02-01T00:00:00Z 0 0 0 0 0 0 0 8ddc6cf512521d01bc91178fbcb8eeb151978492
240 240 20200131 2 0 0                 2020-01-31T00:00:00Z     4 2020-01-31T00:00:00Z 0 0 0 0 0 0 0 d5e75081f4684362d22cf8e4d8f4dab2ca930b83
241 241 20200130 2 0 0                 2020-01-30T00:00:00Z     4 2020-01-30T00:00:00Z 0 0 0 0 0 0 0 7a9cd0ffa1ed65192288e0d65aa0b829d6243844
242 242 20200129 2 0 0                 2020-01-29T00:00:00Z     4 2020-01-29T00:00:00Z 0 0 0 0 0 0 1 a0807cb808af38b0ddba71d5c6b65bf38d30c599
243 243 20200128 2 0 0                 2020-01-28T00:00:00Z     3 2020-01-28T00:00:00Z 0 0 0 0 0 0 0 7783c06052a95f70ad183329db05a77d5bed4053
244 244 20200127 2 0 0                 2020-01-27T00:00:00Z     3 2020-01-27T00:00:00Z 0 0 0 0 0 0 1 339527d6e5b13e593aebf71cf8a51791389e651f
245 245 20200126 2 0 0                 2020-01-26T00:00:00Z     2 2020-01-26T00:00:00Z 0 0 0 0 0 0 0 88a196879207bd090a61fb515beb301e84377977
246 246 20200125 2 0 0                 2020-01-25T00:00:00Z     2 2020-01-25T00:00:00Z 0 0 0 0 0 0 0 43330e2f11d476ebcdd85e1a47551958e4c1e7ea
247 247 20200124 2 0 0                 2020-01-24T00:00:00Z     2 2020-01-24T00:00:00Z 0 0 0 0 0 0 0 5f7a0cce04041596513629d55777a16f3aa65e8b
248 248 20200123 2 0 0                 2020-01-23T00:00:00Z     2 2020-01-23T00:00:00Z 0 0 0 0 0 0 1 53f6a5e3985cebdead7ca275b0890ef975f0ccdd
249 249 20200122 2 0 0                 2020-01-22T00:00:00Z     1 2020-01-22T00:00:00Z 0 0 0 0 0 0 0 c4b5f0c9f5749c849b8a27d48be5c7619d1a3cb2

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