ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where deaths = 5, fips = 26129 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
701075 | 701075 | 2020-11-05 | Ogemaw | Michigan | 26129 | 167 | 5 |
697831 | 697831 | 2020-11-04 | Ogemaw | Michigan | 26129 | 157 | 5 |
694588 | 694588 | 2020-11-03 | Ogemaw | Michigan | 26129 | 153 | 5 |
691346 | 691346 | 2020-11-02 | Ogemaw | Michigan | 26129 | 145 | 5 |
688101 | 688101 | 2020-11-01 | Ogemaw | Michigan | 26129 | 135 | 5 |
684857 | 684857 | 2020-10-31 | Ogemaw | Michigan | 26129 | 135 | 5 |
681614 | 681614 | 2020-10-30 | Ogemaw | Michigan | 26129 | 125 | 5 |
678370 | 678370 | 2020-10-29 | Ogemaw | Michigan | 26129 | 125 | 5 |
675128 | 675128 | 2020-10-28 | Ogemaw | Michigan | 26129 | 117 | 5 |
671885 | 671885 | 2020-10-27 | Ogemaw | Michigan | 26129 | 114 | 5 |
668643 | 668643 | 2020-10-26 | Ogemaw | Michigan | 26129 | 111 | 5 |
665399 | 665399 | 2020-10-25 | Ogemaw | Michigan | 26129 | 102 | 5 |
662154 | 662154 | 2020-10-24 | Ogemaw | Michigan | 26129 | 102 | 5 |
658910 | 658910 | 2020-10-23 | Ogemaw | Michigan | 26129 | 98 | 5 |
655665 | 655665 | 2020-10-22 | Ogemaw | Michigan | 26129 | 95 | 5 |
652420 | 652420 | 2020-10-21 | Ogemaw | Michigan | 26129 | 95 | 5 |
649175 | 649175 | 2020-10-20 | Ogemaw | Michigan | 26129 | 90 | 5 |
645931 | 645931 | 2020-10-19 | Ogemaw | Michigan | 26129 | 90 | 5 |
642684 | 642684 | 2020-10-18 | Ogemaw | Michigan | 26129 | 83 | 5 |
639437 | 639437 | 2020-10-17 | Ogemaw | Michigan | 26129 | 83 | 5 |
636191 | 636191 | 2020-10-16 | Ogemaw | Michigan | 26129 | 83 | 5 |
632945 | 632945 | 2020-10-15 | Ogemaw | Michigan | 26129 | 81 | 5 |
629700 | 629700 | 2020-10-14 | Ogemaw | Michigan | 26129 | 80 | 5 |
626456 | 626456 | 2020-10-13 | Ogemaw | Michigan | 26129 | 79 | 5 |
623214 | 623214 | 2020-10-12 | Ogemaw | Michigan | 26129 | 78 | 5 |
619971 | 619971 | 2020-10-11 | Ogemaw | Michigan | 26129 | 76 | 5 |
616729 | 616729 | 2020-10-10 | Ogemaw | Michigan | 26129 | 76 | 5 |
613488 | 613488 | 2020-10-09 | Ogemaw | Michigan | 26129 | 76 | 5 |
610246 | 610246 | 2020-10-08 | Ogemaw | Michigan | 26129 | 76 | 5 |
607004 | 607004 | 2020-10-07 | Ogemaw | Michigan | 26129 | 74 | 5 |
603761 | 603761 | 2020-10-06 | Ogemaw | Michigan | 26129 | 72 | 5 |
600519 | 600519 | 2020-10-05 | Ogemaw | Michigan | 26129 | 72 | 5 |
597276 | 597276 | 2020-10-04 | Ogemaw | Michigan | 26129 | 69 | 5 |
594035 | 594035 | 2020-10-03 | Ogemaw | Michigan | 26129 | 69 | 5 |
590794 | 590794 | 2020-10-02 | Ogemaw | Michigan | 26129 | 69 | 5 |
587553 | 587553 | 2020-10-01 | Ogemaw | Michigan | 26129 | 69 | 5 |
584313 | 584313 | 2020-09-30 | Ogemaw | Michigan | 26129 | 68 | 5 |
581072 | 581072 | 2020-09-29 | Ogemaw | Michigan | 26129 | 68 | 5 |
577831 | 577831 | 2020-09-28 | Ogemaw | Michigan | 26129 | 68 | 5 |
574590 | 574590 | 2020-09-27 | Ogemaw | Michigan | 26129 | 67 | 5 |
571347 | 571347 | 2020-09-26 | Ogemaw | Michigan | 26129 | 67 | 5 |
568105 | 568105 | 2020-09-25 | Ogemaw | Michigan | 26129 | 65 | 5 |
564865 | 564865 | 2020-09-24 | Ogemaw | Michigan | 26129 | 65 | 5 |
561625 | 561625 | 2020-09-23 | Ogemaw | Michigan | 26129 | 65 | 5 |
558388 | 558388 | 2020-09-22 | Ogemaw | Michigan | 26129 | 62 | 5 |
555151 | 555151 | 2020-09-21 | Ogemaw | Michigan | 26129 | 62 | 5 |
551913 | 551913 | 2020-09-20 | Ogemaw | Michigan | 26129 | 61 | 5 |
548674 | 548674 | 2020-09-19 | Ogemaw | Michigan | 26129 | 61 | 5 |
545436 | 545436 | 2020-09-18 | Ogemaw | Michigan | 26129 | 61 | 5 |
542199 | 542199 | 2020-09-17 | Ogemaw | Michigan | 26129 | 61 | 5 |
538963 | 538963 | 2020-09-16 | Ogemaw | Michigan | 26129 | 61 | 5 |
535726 | 535726 | 2020-09-15 | Ogemaw | Michigan | 26129 | 60 | 5 |
532491 | 532491 | 2020-09-14 | Ogemaw | Michigan | 26129 | 60 | 5 |
529255 | 529255 | 2020-09-13 | Ogemaw | Michigan | 26129 | 60 | 5 |
526019 | 526019 | 2020-09-12 | Ogemaw | Michigan | 26129 | 60 | 5 |
522783 | 522783 | 2020-09-11 | Ogemaw | Michigan | 26129 | 60 | 5 |
519546 | 519546 | 2020-09-10 | Ogemaw | Michigan | 26129 | 60 | 5 |
516311 | 516311 | 2020-09-09 | Ogemaw | Michigan | 26129 | 59 | 5 |
513077 | 513077 | 2020-09-08 | Ogemaw | Michigan | 26129 | 59 | 5 |
509845 | 509845 | 2020-09-07 | Ogemaw | Michigan | 26129 | 58 | 5 |
506612 | 506612 | 2020-09-06 | Ogemaw | Michigan | 26129 | 58 | 5 |
503379 | 503379 | 2020-09-05 | Ogemaw | Michigan | 26129 | 58 | 5 |
500145 | 500145 | 2020-09-04 | Ogemaw | Michigan | 26129 | 58 | 5 |
496911 | 496911 | 2020-09-03 | Ogemaw | Michigan | 26129 | 58 | 5 |
493678 | 493678 | 2020-09-02 | Ogemaw | Michigan | 26129 | 58 | 5 |
490444 | 490444 | 2020-09-01 | Ogemaw | Michigan | 26129 | 58 | 5 |
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);