ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,544 rows where county = "Davis" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
167121 | 167121 | 2020-05-22 | Davis | Iowa | 19051 | 17 | 0 |
169012 | 169012 | 2020-05-22 | Davis | Utah | 49011 | 401 | 2 |
170158 | 170158 | 2020-05-23 | Davis | Iowa | 19051 | 17 | 0 |
172053 | 172053 | 2020-05-23 | Davis | Utah | 49011 | 407 | 2 |
173199 | 173199 | 2020-05-24 | Davis | Iowa | 19051 | 20 | 0 |
175096 | 175096 | 2020-05-24 | Davis | Utah | 49011 | 410 | 2 |
176243 | 176243 | 2020-05-25 | Davis | Iowa | 19051 | 20 | 0 |
178141 | 178141 | 2020-05-25 | Davis | Utah | 49011 | 414 | 2 |
179287 | 179287 | 2020-05-26 | Davis | Iowa | 19051 | 20 | 0 |
181185 | 181185 | 2020-05-26 | Davis | Utah | 49011 | 419 | 2 |
182331 | 182331 | 2020-05-27 | Davis | Iowa | 19051 | 20 | 0 |
184236 | 184236 | 2020-05-27 | Davis | Utah | 49011 | 424 | 2 |
185385 | 185385 | 2020-05-28 | Davis | Iowa | 19051 | 20 | 0 |
187293 | 187293 | 2020-05-28 | Davis | Utah | 49011 | 435 | 2 |
188443 | 188443 | 2020-05-29 | Davis | Iowa | 19051 | 21 | 0 |
190357 | 190357 | 2020-05-29 | Davis | Utah | 49011 | 447 | 2 |
191508 | 191508 | 2020-05-30 | Davis | Iowa | 19051 | 21 | 0 |
193423 | 193423 | 2020-05-30 | Davis | Utah | 49011 | 458 | 2 |
194575 | 194575 | 2020-05-31 | Davis | Iowa | 19051 | 22 | 0 |
196493 | 196493 | 2020-05-31 | Davis | Utah | 49011 | 465 | 2 |
197645 | 197645 | 2020-06-01 | Davis | Iowa | 19051 | 24 | 0 |
199566 | 199566 | 2020-06-01 | Davis | Utah | 49011 | 472 | 2 |
200718 | 200718 | 2020-06-02 | Davis | Iowa | 19051 | 25 | 0 |
202642 | 202642 | 2020-06-02 | Davis | Utah | 49011 | 476 | 2 |
203794 | 203794 | 2020-06-03 | Davis | Iowa | 19051 | 27 | 0 |
205721 | 205721 | 2020-06-03 | Davis | Utah | 49011 | 494 | 2 |
206874 | 206874 | 2020-06-04 | Davis | Iowa | 19051 | 28 | 0 |
208803 | 208803 | 2020-06-04 | Davis | Utah | 49011 | 513 | 2 |
209955 | 209955 | 2020-06-05 | Davis | Iowa | 19051 | 28 | 0 |
211888 | 211888 | 2020-06-05 | Davis | Utah | 49011 | 525 | 2 |
213040 | 213040 | 2020-06-06 | Davis | Iowa | 19051 | 28 | 0 |
214975 | 214975 | 2020-06-06 | Davis | Utah | 49011 | 541 | 2 |
216127 | 216127 | 2020-06-07 | Davis | Iowa | 19051 | 29 | 0 |
218065 | 218065 | 2020-06-07 | Davis | Utah | 49011 | 549 | 2 |
219219 | 219219 | 2020-06-08 | Davis | Iowa | 19051 | 29 | 1 |
221157 | 221157 | 2020-06-08 | Davis | Utah | 49011 | 564 | 3 |
222314 | 222314 | 2020-06-09 | Davis | Iowa | 19051 | 29 | 1 |
224253 | 224253 | 2020-06-09 | Davis | Utah | 49011 | 580 | 3 |
225409 | 225409 | 2020-06-10 | Davis | Iowa | 19051 | 30 | 1 |
227353 | 227353 | 2020-06-10 | Davis | Utah | 49011 | 593 | 4 |
228511 | 228511 | 2020-06-11 | Davis | Iowa | 19051 | 31 | 1 |
230457 | 230457 | 2020-06-11 | Davis | Utah | 49011 | 620 | 4 |
231614 | 231614 | 2020-06-12 | Davis | Iowa | 19051 | 33 | 1 |
233561 | 233561 | 2020-06-12 | Davis | Utah | 49011 | 628 | 4 |
234720 | 234720 | 2020-06-13 | Davis | Iowa | 19051 | 33 | 1 |
236668 | 236668 | 2020-06-13 | Davis | Utah | 49011 | 646 | 4 |
237827 | 237827 | 2020-06-14 | Davis | Iowa | 19051 | 34 | 1 |
239776 | 239776 | 2020-06-14 | Davis | Utah | 49011 | 660 | 4 |
240935 | 240935 | 2020-06-15 | Davis | Iowa | 19051 | 34 | 1 |
242887 | 242887 | 2020-06-15 | Davis | Utah | 49011 | 672 | 4 |
244046 | 244046 | 2020-06-16 | Davis | Iowa | 19051 | 34 | 1 |
245999 | 245999 | 2020-06-16 | Davis | Utah | 49011 | 691 | 4 |
247159 | 247159 | 2020-06-17 | Davis | Iowa | 19051 | 34 | 1 |
249112 | 249112 | 2020-06-17 | Davis | Utah | 49011 | 715 | 4 |
250271 | 250271 | 2020-06-18 | Davis | Iowa | 19051 | 36 | 1 |
252227 | 252227 | 2020-06-18 | Davis | Utah | 49011 | 739 | 4 |
253386 | 253386 | 2020-06-19 | Davis | Iowa | 19051 | 36 | 1 |
255344 | 255344 | 2020-06-19 | Davis | Utah | 49011 | 775 | 4 |
256506 | 256506 | 2020-06-20 | Davis | Iowa | 19051 | 36 | 1 |
258471 | 258471 | 2020-06-20 | Davis | Utah | 49011 | 822 | 4 |
259632 | 259632 | 2020-06-21 | Davis | Iowa | 19051 | 36 | 1 |
261598 | 261598 | 2020-06-21 | Davis | Utah | 49011 | 856 | 4 |
262759 | 262759 | 2020-06-22 | Davis | Iowa | 19051 | 36 | 1 |
264727 | 264727 | 2020-06-22 | Davis | Utah | 49011 | 877 | 4 |
265887 | 265887 | 2020-06-23 | Davis | Iowa | 19051 | 36 | 1 |
267856 | 267856 | 2020-06-23 | Davis | Utah | 49011 | 905 | 4 |
269017 | 269017 | 2020-06-24 | Davis | Iowa | 19051 | 36 | 1 |
270990 | 270990 | 2020-06-24 | Davis | Utah | 49011 | 938 | 4 |
272154 | 272154 | 2020-06-25 | Davis | Iowa | 19051 | 36 | 1 |
274130 | 274130 | 2020-06-25 | Davis | Utah | 49011 | 989 | 4 |
275296 | 275296 | 2020-06-26 | Davis | Iowa | 19051 | 36 | 1 |
277278 | 277278 | 2020-06-26 | Davis | Utah | 49011 | 1036 | 4 |
278444 | 278444 | 2020-06-27 | Davis | Iowa | 19051 | 37 | 1 |
280426 | 280426 | 2020-06-27 | Davis | Utah | 49011 | 1080 | 4 |
281592 | 281592 | 2020-06-28 | Davis | Iowa | 19051 | 37 | 1 |
283572 | 283572 | 2020-06-28 | Davis | Utah | 49011 | 1113 | 4 |
284737 | 284737 | 2020-06-29 | Davis | Iowa | 19051 | 37 | 1 |
286718 | 286718 | 2020-06-29 | Davis | Utah | 49011 | 1155 | 5 |
287886 | 287886 | 2020-06-30 | Davis | Iowa | 19051 | 37 | 1 |
289868 | 289868 | 2020-06-30 | Davis | Utah | 49011 | 1179 | 5 |
291036 | 291036 | 2020-07-01 | Davis | Iowa | 19051 | 38 | 1 |
293021 | 293021 | 2020-07-01 | Davis | Utah | 49011 | 1218 | 5 |
294190 | 294190 | 2020-07-02 | Davis | Iowa | 19051 | 39 | 1 |
296176 | 296176 | 2020-07-02 | Davis | Utah | 49011 | 1268 | 5 |
297348 | 297348 | 2020-07-03 | Davis | Iowa | 19051 | 39 | 1 |
299338 | 299338 | 2020-07-03 | Davis | Utah | 49011 | 1322 | 5 |
300510 | 300510 | 2020-07-04 | Davis | Iowa | 19051 | 40 | 1 |
302502 | 302502 | 2020-07-04 | Davis | Utah | 49011 | 1379 | 5 |
303674 | 303674 | 2020-07-05 | Davis | Iowa | 19051 | 40 | 1 |
305666 | 305666 | 2020-07-05 | Davis | Utah | 49011 | 1422 | 5 |
306839 | 306839 | 2020-07-06 | Davis | Iowa | 19051 | 41 | 1 |
308834 | 308834 | 2020-07-06 | Davis | Utah | 49011 | 1470 | 6 |
310007 | 310007 | 2020-07-07 | Davis | Iowa | 19051 | 41 | 1 |
312003 | 312003 | 2020-07-07 | Davis | Utah | 49011 | 1522 | 6 |
313177 | 313177 | 2020-07-08 | Davis | Iowa | 19051 | 42 | 1 |
315177 | 315177 | 2020-07-08 | Davis | Utah | 49011 | 1575 | 6 |
316351 | 316351 | 2020-07-09 | Davis | Iowa | 19051 | 42 | 1 |
318350 | 318350 | 2020-07-09 | Davis | Utah | 49011 | 1644 | 6 |
319524 | 319524 | 2020-07-10 | Davis | Iowa | 19051 | 42 | 1 |
321529 | 321529 | 2020-07-10 | Davis | Utah | 49011 | 1723 | 6 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);