us_daily
Data source: Big Local News · About: big-local-datasette
9 rows where states = 51 sorted by hospitalizedCurrently
This data as json, copyable, CSV (advanced)
Suggested facets: hospitalizedCumulative, deathIncrease, hospitalizedIncrease, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
196 | 196 | 20200315 | 51 | 6022 | 34661 | 2242 | 36 | 2020-03-15T00:00:00Z | 79 | 36 | 50315 | 2020-03-15T00:00:00Z | 0 | 0 | 15 | 10 | 6553 | 1291 | 8300 | f2116e781a933964b1686990c60ec902c85bb35b | ||||||
197 | 197 | 20200314 | 51 | 4731 | 28108 | 1236 | 26 | 2020-03-14T00:00:00Z | 64 | 26 | 42015 | 2020-03-14T00:00:00Z | 0 | 0 | 9 | 4 | 3852 | 924 | 5722 | 31730b999cbe5aa48accc2635322b0da691522a4 | ||||||
198 | 198 | 20200313 | 51 | 3807 | 24256 | 1130 | 22 | 2020-03-13T00:00:00Z | 55 | 22 | 36293 | 2020-03-13T00:00:00Z | 0 | 0 | 4 | 6 | 8318 | 1072 | 10334 | 6aef71d10e553aa5c487a8ad2c2fa438bf271d4d | ||||||
199 | 199 | 20200312 | 51 | 2735 | 15938 | 673 | 16 | 2020-03-12T00:00:00Z | 51 | 16 | 25959 | 2020-03-12T00:00:00Z | 0 | 0 | 8 | 5 | 4750 | 671 | 5793 | 8f74948e15795425a8ada260a0485c7c16643003 | ||||||
200 | 200 | 20200311 | 51 | 2064 | 11188 | 563 | 11 | 2020-03-11T00:00:00Z | 43 | 11 | 20166 | 2020-03-11T00:00:00Z | 0 | 0 | 6 | 3 | 3421 | 509 | 4028 | 884dfdceeb275b5123ffd77c797676d8bca323c1 | ||||||
201 | 201 | 20200310 | 51 | 1555 | 7767 | 469 | 8 | 2020-03-10T00:00:00Z | 37 | 8 | 16138 | 2020-03-10T00:00:00Z | 0 | 0 | 2 | 0 | 2184 | 387 | 2676 | 1380c1a775812ed78a9fe97f1dde9434303dc4af | ||||||
202 | 202 | 20200309 | 51 | 1168 | 5583 | 313 | 8 | 2020-03-09T00:00:00Z | 35 | 8 | 13462 | 2020-03-09T00:00:00Z | 0 | 0 | 4 | 2 | 1534 | 292 | 1894 | 99e63e1d64701a2395977269e9998a2118249bc9 | ||||||
203 | 203 | 20200308 | 51 | 876 | 4049 | 347 | 6 | 2020-03-08T00:00:00Z | 31 | 6 | 11568 | 2020-03-08T00:00:00Z | 0 | 0 | 4 | 0 | 716 | 198 | 935 | c1456b253c0021edfbeecaad122219c80d63b26b | ||||||
204 | 204 | 20200307 | 51 | 678 | 3333 | 602 | 6 | 2020-03-07T00:00:00Z | 27 | 6 | 10633 | 2020-03-07T00:00:00Z | 0 | 0 | 1 | 0 | 661 | 178 | 919 | f5a3205f9f4185d62c37212e131733c6a8baf9e2 |
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 );