ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,446 rows where county = "Deuel" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
308444 | 308444 | 2020-07-06 | Deuel | South Dakota | 46039 | 4 | 0 |
311613 | 311613 | 2020-07-07 | Deuel | South Dakota | 46039 | 4 | 0 |
314786 | 314786 | 2020-07-08 | Deuel | South Dakota | 46039 | 4 | 0 |
317959 | 317959 | 2020-07-09 | Deuel | South Dakota | 46039 | 4 | 0 |
321137 | 321137 | 2020-07-10 | Deuel | South Dakota | 46039 | 4 | 0 |
324317 | 324317 | 2020-07-11 | Deuel | South Dakota | 46039 | 5 | 0 |
327502 | 327502 | 2020-07-12 | Deuel | South Dakota | 46039 | 5 | 0 |
330688 | 330688 | 2020-07-13 | Deuel | South Dakota | 46039 | 5 | 0 |
333110 | 333110 | 2020-07-14 | Deuel | Nebraska | 31049 | 1 | 0 |
333880 | 333880 | 2020-07-14 | Deuel | South Dakota | 46039 | 5 | 0 |
336304 | 336304 | 2020-07-15 | Deuel | Nebraska | 31049 | 2 | 0 |
337074 | 337074 | 2020-07-15 | Deuel | South Dakota | 46039 | 5 | 0 |
339501 | 339501 | 2020-07-16 | Deuel | Nebraska | 31049 | 2 | 0 |
340271 | 340271 | 2020-07-16 | Deuel | South Dakota | 46039 | 5 | 0 |
342697 | 342697 | 2020-07-17 | Deuel | Nebraska | 31049 | 2 | 0 |
343469 | 343469 | 2020-07-17 | Deuel | South Dakota | 46039 | 5 | 0 |
345897 | 345897 | 2020-07-18 | Deuel | Nebraska | 31049 | 2 | 0 |
346669 | 346669 | 2020-07-18 | Deuel | South Dakota | 46039 | 5 | 0 |
349098 | 349098 | 2020-07-19 | Deuel | Nebraska | 31049 | 2 | 0 |
349869 | 349869 | 2020-07-19 | Deuel | South Dakota | 46039 | 5 | 0 |
352299 | 352299 | 2020-07-20 | Deuel | Nebraska | 31049 | 1 | 0 |
353072 | 353072 | 2020-07-20 | Deuel | South Dakota | 46039 | 5 | 0 |
355502 | 355502 | 2020-07-21 | Deuel | Nebraska | 31049 | 1 | 0 |
356275 | 356275 | 2020-07-21 | Deuel | South Dakota | 46039 | 5 | 0 |
358706 | 358706 | 2020-07-22 | Deuel | Nebraska | 31049 | 1 | 0 |
359479 | 359479 | 2020-07-22 | Deuel | South Dakota | 46039 | 5 | 0 |
361912 | 361912 | 2020-07-23 | Deuel | Nebraska | 31049 | 1 | 0 |
362685 | 362685 | 2020-07-23 | Deuel | South Dakota | 46039 | 6 | 0 |
365119 | 365119 | 2020-07-24 | Deuel | Nebraska | 31049 | 1 | 0 |
365891 | 365891 | 2020-07-24 | Deuel | South Dakota | 46039 | 6 | 0 |
368328 | 368328 | 2020-07-25 | Deuel | Nebraska | 31049 | 1 | 0 |
369100 | 369100 | 2020-07-25 | Deuel | South Dakota | 46039 | 7 | 0 |
371539 | 371539 | 2020-07-26 | Deuel | Nebraska | 31049 | 1 | 0 |
372312 | 372312 | 2020-07-26 | Deuel | South Dakota | 46039 | 7 | 0 |
374751 | 374751 | 2020-07-27 | Deuel | Nebraska | 31049 | 1 | 0 |
375525 | 375525 | 2020-07-27 | Deuel | South Dakota | 46039 | 8 | 0 |
377966 | 377966 | 2020-07-28 | Deuel | Nebraska | 31049 | 1 | 0 |
378741 | 378741 | 2020-07-28 | Deuel | South Dakota | 46039 | 8 | 0 |
381184 | 381184 | 2020-07-29 | Deuel | Nebraska | 31049 | 1 | 0 |
381958 | 381958 | 2020-07-29 | Deuel | South Dakota | 46039 | 9 | 0 |
384400 | 384400 | 2020-07-30 | Deuel | Nebraska | 31049 | 1 | 0 |
385176 | 385176 | 2020-07-30 | Deuel | South Dakota | 46039 | 9 | 0 |
387618 | 387618 | 2020-07-31 | Deuel | Nebraska | 31049 | 1 | 0 |
388393 | 388393 | 2020-07-31 | Deuel | South Dakota | 46039 | 9 | 0 |
390835 | 390835 | 2020-08-01 | Deuel | Nebraska | 31049 | 1 | 0 |
391610 | 391610 | 2020-08-01 | Deuel | South Dakota | 46039 | 8 | 0 |
394052 | 394052 | 2020-08-02 | Deuel | Nebraska | 31049 | 1 | 0 |
394826 | 394826 | 2020-08-02 | Deuel | South Dakota | 46039 | 8 | 0 |
397268 | 397268 | 2020-08-03 | Deuel | Nebraska | 31049 | 1 | 0 |
398043 | 398043 | 2020-08-03 | Deuel | South Dakota | 46039 | 8 | 0 |
400483 | 400483 | 2020-08-04 | Deuel | Nebraska | 31049 | 1 | 0 |
401258 | 401258 | 2020-08-04 | Deuel | South Dakota | 46039 | 9 | 0 |
403701 | 403701 | 2020-08-05 | Deuel | Nebraska | 31049 | 2 | 0 |
404476 | 404476 | 2020-08-05 | Deuel | South Dakota | 46039 | 9 | 0 |
406920 | 406920 | 2020-08-06 | Deuel | Nebraska | 31049 | 2 | 0 |
407696 | 407696 | 2020-08-06 | Deuel | South Dakota | 46039 | 9 | 0 |
410140 | 410140 | 2020-08-07 | Deuel | Nebraska | 31049 | 2 | 0 |
410915 | 410915 | 2020-08-07 | Deuel | South Dakota | 46039 | 10 | 0 |
413360 | 413360 | 2020-08-08 | Deuel | Nebraska | 31049 | 2 | 0 |
414135 | 414135 | 2020-08-08 | Deuel | South Dakota | 46039 | 10 | 0 |
416580 | 416580 | 2020-08-09 | Deuel | Nebraska | 31049 | 2 | 0 |
417356 | 417356 | 2020-08-09 | Deuel | South Dakota | 46039 | 11 | 0 |
419801 | 419801 | 2020-08-10 | Deuel | Nebraska | 31049 | 2 | 0 |
420577 | 420577 | 2020-08-10 | Deuel | South Dakota | 46039 | 11 | 0 |
423024 | 423024 | 2020-08-11 | Deuel | Nebraska | 31049 | 2 | 0 |
423799 | 423799 | 2020-08-11 | Deuel | South Dakota | 46039 | 11 | 0 |
426246 | 426246 | 2020-08-12 | Deuel | Nebraska | 31049 | 2 | 0 |
427022 | 427022 | 2020-08-12 | Deuel | South Dakota | 46039 | 11 | 0 |
429471 | 429471 | 2020-08-13 | Deuel | Nebraska | 31049 | 2 | 0 |
430248 | 430248 | 2020-08-13 | Deuel | South Dakota | 46039 | 13 | 0 |
432698 | 432698 | 2020-08-14 | Deuel | Nebraska | 31049 | 2 | 0 |
433473 | 433473 | 2020-08-14 | Deuel | South Dakota | 46039 | 13 | 0 |
435924 | 435924 | 2020-08-15 | Deuel | Nebraska | 31049 | 2 | 0 |
436700 | 436700 | 2020-08-15 | Deuel | South Dakota | 46039 | 15 | 0 |
439149 | 439149 | 2020-08-16 | Deuel | Nebraska | 31049 | 2 | 0 |
439925 | 439925 | 2020-08-16 | Deuel | South Dakota | 46039 | 19 | 0 |
442376 | 442376 | 2020-08-17 | Deuel | Nebraska | 31049 | 2 | 0 |
443152 | 443152 | 2020-08-17 | Deuel | South Dakota | 46039 | 24 | 0 |
445602 | 445602 | 2020-08-18 | Deuel | Nebraska | 31049 | 4 | 0 |
446378 | 446378 | 2020-08-18 | Deuel | South Dakota | 46039 | 24 | 0 |
448828 | 448828 | 2020-08-19 | Deuel | Nebraska | 31049 | 2 | 0 |
449606 | 449606 | 2020-08-19 | Deuel | South Dakota | 46039 | 26 | 0 |
452056 | 452056 | 2020-08-20 | Deuel | Nebraska | 31049 | 2 | 0 |
452834 | 452834 | 2020-08-20 | Deuel | South Dakota | 46039 | 26 | 0 |
455284 | 455284 | 2020-08-21 | Deuel | Nebraska | 31049 | 2 | 0 |
456062 | 456062 | 2020-08-21 | Deuel | South Dakota | 46039 | 27 | 0 |
458512 | 458512 | 2020-08-22 | Deuel | Nebraska | 31049 | 2 | 0 |
459290 | 459290 | 2020-08-22 | Deuel | South Dakota | 46039 | 28 | 0 |
461739 | 461739 | 2020-08-23 | Deuel | Nebraska | 31049 | 3 | 0 |
462518 | 462518 | 2020-08-23 | Deuel | South Dakota | 46039 | 33 | 0 |
464970 | 464970 | 2020-08-24 | Deuel | Nebraska | 31049 | 2 | 0 |
465747 | 465747 | 2020-08-24 | Deuel | South Dakota | 46039 | 34 | 0 |
468199 | 468199 | 2020-08-25 | Deuel | Nebraska | 31049 | 2 | 0 |
468975 | 468975 | 2020-08-25 | Deuel | South Dakota | 46039 | 34 | 0 |
471429 | 471429 | 2020-08-26 | Deuel | Nebraska | 31049 | 2 | 0 |
472207 | 472207 | 2020-08-26 | Deuel | South Dakota | 46039 | 34 | 0 |
474661 | 474661 | 2020-08-27 | Deuel | Nebraska | 31049 | 2 | 0 |
475441 | 475441 | 2020-08-27 | Deuel | South Dakota | 46039 | 38 | 0 |
477894 | 477894 | 2020-08-28 | Deuel | Nebraska | 31049 | 2 | 0 |
478674 | 478674 | 2020-08-28 | Deuel | South Dakota | 46039 | 38 | 0 |
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);