ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
672 rows where county = "Logan" and fips = 38047 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
314339 | 314339 | 2020-07-08 | Logan | North Dakota | 38047 | 1 | 0 |
327054 | 327054 | 2020-07-12 | Logan | North Dakota | 38047 | 1 | 0 |
330241 | 330241 | 2020-07-13 | Logan | North Dakota | 38047 | 1 | 0 |
333432 | 333432 | 2020-07-14 | Logan | North Dakota | 38047 | 1 | 0 |
336626 | 336626 | 2020-07-15 | Logan | North Dakota | 38047 | 1 | 0 |
339822 | 339822 | 2020-07-16 | Logan | North Dakota | 38047 | 1 | 0 |
343020 | 343020 | 2020-07-17 | Logan | North Dakota | 38047 | 1 | 0 |
346219 | 346219 | 2020-07-18 | Logan | North Dakota | 38047 | 1 | 0 |
349420 | 349420 | 2020-07-19 | Logan | North Dakota | 38047 | 1 | 0 |
352623 | 352623 | 2020-07-20 | Logan | North Dakota | 38047 | 1 | 0 |
355826 | 355826 | 2020-07-21 | Logan | North Dakota | 38047 | 1 | 0 |
359030 | 359030 | 2020-07-22 | Logan | North Dakota | 38047 | 1 | 0 |
362236 | 362236 | 2020-07-23 | Logan | North Dakota | 38047 | 1 | 0 |
365442 | 365442 | 2020-07-24 | Logan | North Dakota | 38047 | 1 | 0 |
368651 | 368651 | 2020-07-25 | Logan | North Dakota | 38047 | 1 | 0 |
371863 | 371863 | 2020-07-26 | Logan | North Dakota | 38047 | 1 | 0 |
375075 | 375075 | 2020-07-27 | Logan | North Dakota | 38047 | 1 | 0 |
378292 | 378292 | 2020-07-28 | Logan | North Dakota | 38047 | 2 | 0 |
381509 | 381509 | 2020-07-29 | Logan | North Dakota | 38047 | 3 | 0 |
384727 | 384727 | 2020-07-30 | Logan | North Dakota | 38047 | 3 | 0 |
387944 | 387944 | 2020-07-31 | Logan | North Dakota | 38047 | 4 | 0 |
391161 | 391161 | 2020-08-01 | Logan | North Dakota | 38047 | 4 | 0 |
394377 | 394377 | 2020-08-02 | Logan | North Dakota | 38047 | 5 | 0 |
397594 | 397594 | 2020-08-03 | Logan | North Dakota | 38047 | 6 | 0 |
400809 | 400809 | 2020-08-04 | Logan | North Dakota | 38047 | 6 | 0 |
404027 | 404027 | 2020-08-05 | Logan | North Dakota | 38047 | 7 | 0 |
407246 | 407246 | 2020-08-06 | Logan | North Dakota | 38047 | 7 | 0 |
410466 | 410466 | 2020-08-07 | Logan | North Dakota | 38047 | 7 | 0 |
413686 | 413686 | 2020-08-08 | Logan | North Dakota | 38047 | 7 | 0 |
416907 | 416907 | 2020-08-09 | Logan | North Dakota | 38047 | 7 | 0 |
420127 | 420127 | 2020-08-10 | Logan | North Dakota | 38047 | 7 | 0 |
423350 | 423350 | 2020-08-11 | Logan | North Dakota | 38047 | 7 | 0 |
426573 | 426573 | 2020-08-12 | Logan | North Dakota | 38047 | 7 | 0 |
429798 | 429798 | 2020-08-13 | Logan | North Dakota | 38047 | 7 | 0 |
433024 | 433024 | 2020-08-14 | Logan | North Dakota | 38047 | 7 | 0 |
436250 | 436250 | 2020-08-15 | Logan | North Dakota | 38047 | 7 | 0 |
439475 | 439475 | 2020-08-16 | Logan | North Dakota | 38047 | 7 | 0 |
442702 | 442702 | 2020-08-17 | Logan | North Dakota | 38047 | 7 | 0 |
445928 | 445928 | 2020-08-18 | Logan | North Dakota | 38047 | 7 | 0 |
449156 | 449156 | 2020-08-19 | Logan | North Dakota | 38047 | 7 | 0 |
452384 | 452384 | 2020-08-20 | Logan | North Dakota | 38047 | 7 | 0 |
455612 | 455612 | 2020-08-21 | Logan | North Dakota | 38047 | 7 | 0 |
458840 | 458840 | 2020-08-22 | Logan | North Dakota | 38047 | 7 | 0 |
462068 | 462068 | 2020-08-23 | Logan | North Dakota | 38047 | 7 | 0 |
465297 | 465297 | 2020-08-24 | Logan | North Dakota | 38047 | 7 | 0 |
468525 | 468525 | 2020-08-25 | Logan | North Dakota | 38047 | 9 | 0 |
471757 | 471757 | 2020-08-26 | Logan | North Dakota | 38047 | 9 | 0 |
474991 | 474991 | 2020-08-27 | Logan | North Dakota | 38047 | 9 | 0 |
478224 | 478224 | 2020-08-28 | Logan | North Dakota | 38047 | 10 | 0 |
481457 | 481457 | 2020-08-29 | Logan | North Dakota | 38047 | 10 | 0 |
484692 | 484692 | 2020-08-30 | Logan | North Dakota | 38047 | 11 | 0 |
487925 | 487925 | 2020-08-31 | Logan | North Dakota | 38047 | 11 | 0 |
491158 | 491158 | 2020-09-01 | Logan | North Dakota | 38047 | 11 | 0 |
494392 | 494392 | 2020-09-02 | Logan | North Dakota | 38047 | 11 | 0 |
497625 | 497625 | 2020-09-03 | Logan | North Dakota | 38047 | 12 | 0 |
500859 | 500859 | 2020-09-04 | Logan | North Dakota | 38047 | 12 | 0 |
504093 | 504093 | 2020-09-05 | Logan | North Dakota | 38047 | 13 | 0 |
507325 | 507325 | 2020-09-06 | Logan | North Dakota | 38047 | 13 | 0 |
510558 | 510558 | 2020-09-07 | Logan | North Dakota | 38047 | 13 | 0 |
513791 | 513791 | 2020-09-08 | Logan | North Dakota | 38047 | 12 | 0 |
517026 | 517026 | 2020-09-09 | Logan | North Dakota | 38047 | 13 | 0 |
520262 | 520262 | 2020-09-10 | Logan | North Dakota | 38047 | 13 | 0 |
523498 | 523498 | 2020-09-11 | Logan | North Dakota | 38047 | 13 | 0 |
526734 | 526734 | 2020-09-12 | Logan | North Dakota | 38047 | 14 | 0 |
529971 | 529971 | 2020-09-13 | Logan | North Dakota | 38047 | 15 | 0 |
533206 | 533206 | 2020-09-14 | Logan | North Dakota | 38047 | 15 | 0 |
536442 | 536442 | 2020-09-15 | Logan | North Dakota | 38047 | 16 | 0 |
539679 | 539679 | 2020-09-16 | Logan | North Dakota | 38047 | 20 | 0 |
542915 | 542915 | 2020-09-17 | Logan | North Dakota | 38047 | 20 | 0 |
546152 | 546152 | 2020-09-18 | Logan | North Dakota | 38047 | 20 | 0 |
549391 | 549391 | 2020-09-19 | Logan | North Dakota | 38047 | 26 | 0 |
552630 | 552630 | 2020-09-20 | Logan | North Dakota | 38047 | 30 | 0 |
555867 | 555867 | 2020-09-21 | Logan | North Dakota | 38047 | 32 | 0 |
559104 | 559104 | 2020-09-22 | Logan | North Dakota | 38047 | 38 | 0 |
562341 | 562341 | 2020-09-23 | Logan | North Dakota | 38047 | 40 | 0 |
565582 | 565582 | 2020-09-24 | Logan | North Dakota | 38047 | 44 | 0 |
568823 | 568823 | 2020-09-25 | Logan | North Dakota | 38047 | 45 | 0 |
572065 | 572065 | 2020-09-26 | Logan | North Dakota | 38047 | 56 | 0 |
575309 | 575309 | 2020-09-27 | Logan | North Dakota | 38047 | 59 | 0 |
578550 | 578550 | 2020-09-28 | Logan | North Dakota | 38047 | 59 | 0 |
581790 | 581790 | 2020-09-29 | Logan | North Dakota | 38047 | 64 | 0 |
585031 | 585031 | 2020-09-30 | Logan | North Dakota | 38047 | 69 | 0 |
588271 | 588271 | 2020-10-01 | Logan | North Dakota | 38047 | 69 | 0 |
591512 | 591512 | 2020-10-02 | Logan | North Dakota | 38047 | 73 | 0 |
594753 | 594753 | 2020-10-03 | Logan | North Dakota | 38047 | 79 | 0 |
597996 | 597996 | 2020-10-04 | Logan | North Dakota | 38047 | 79 | 0 |
601239 | 601239 | 2020-10-05 | Logan | North Dakota | 38047 | 79 | 0 |
604481 | 604481 | 2020-10-06 | Logan | North Dakota | 38047 | 78 | 0 |
607724 | 607724 | 2020-10-07 | Logan | North Dakota | 38047 | 79 | 0 |
610966 | 610966 | 2020-10-08 | Logan | North Dakota | 38047 | 87 | 0 |
614207 | 614207 | 2020-10-09 | Logan | North Dakota | 38047 | 88 | 0 |
617449 | 617449 | 2020-10-10 | Logan | North Dakota | 38047 | 88 | 0 |
620691 | 620691 | 2020-10-11 | Logan | North Dakota | 38047 | 90 | 0 |
623934 | 623934 | 2020-10-12 | Logan | North Dakota | 38047 | 93 | 0 |
627176 | 627176 | 2020-10-13 | Logan | North Dakota | 38047 | 93 | 0 |
630420 | 630420 | 2020-10-14 | Logan | North Dakota | 38047 | 101 | 0 |
633665 | 633665 | 2020-10-15 | Logan | North Dakota | 38047 | 102 | 0 |
636911 | 636911 | 2020-10-16 | Logan | North Dakota | 38047 | 103 | 0 |
640157 | 640157 | 2020-10-17 | Logan | North Dakota | 38047 | 107 | 0 |
643405 | 643405 | 2020-10-18 | Logan | North Dakota | 38047 | 110 | 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);