us_daily
Data source: Big Local News · About: big-local-datasette
17 rows where states = 3 sorted by hospitalizedCurrently
This data as json, copyable, CSV (advanced)
Suggested facets: death, totalTestResults, deathIncrease, totalTestResultsIncrease, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 |
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 );