us_daily

Table actions

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

249 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
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
205 205 20200306 37 500 2672 458   6           2020-03-06T00:00:00Z 26 6 9714 2020-03-06T00:00:00Z 0 0 6 1 723 112 873 30faa3d05bdbf566a81344ccf5480bc7049aeae9
206 206 20200305 25 388 1949 197   5           2020-03-05T00:00:00Z 20 5 8841 2020-03-05T00:00:00Z 0 0 4 1 532 107 641 16ccaf4b89ce2bf86dac0d0910744e205340c835
207 207 20200304 18 281 1417 103   4           2020-03-04T00:00:00Z 16 4 8200 2020-03-04T00:00:00Z 0 0 2 4 971 139 1119 14b59f214bb410a2e0bd7cba0d06477f89a7c09d
208 208 20200303 6 142 446                 2020-03-03T00:00:00Z 14   7081 2020-03-03T00:00:00Z 0 0 3 0 203 48 266 0e8c1af100ae67bb89dbe9e005aaa1bcd6109dcf
209 209 20200302 6 94 243                 2020-03-02T00:00:00Z 11   6815 2020-03-02T00:00:00Z 0 0 3 0 158 44 212 960d118b365aeb9ca36e7ec4f1fc03dc27477b42
210 210 20200301 6 50 85                 2020-03-01T00:00:00Z 8   6603 2020-03-01T00:00:00Z 0 0 3 0 61 32 95 0a8489cd64cba2a58e40cbaf08fe85fc39b7ed7a
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
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
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
);