ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-09-02" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
493614 | 493614 | 2020-09-02 | Alcona | Michigan | 26001 | 36 | 2 |
493615 | 493615 | 2020-09-02 | Alger | Michigan | 26003 | 17 | 0 |
493616 | 493616 | 2020-09-02 | Allegan | Michigan | 26005 | 648 | 6 |
493617 | 493617 | 2020-09-02 | Alpena | Michigan | 26007 | 133 | 14 |
493618 | 493618 | 2020-09-02 | Antrim | Michigan | 26009 | 60 | 0 |
493619 | 493619 | 2020-09-02 | Arenac | Michigan | 26011 | 59 | 3 |
493620 | 493620 | 2020-09-02 | Baraga | Michigan | 26013 | 8 | 0 |
493621 | 493621 | 2020-09-02 | Barry | Michigan | 26015 | 216 | 2 |
493622 | 493622 | 2020-09-02 | Bay | Michigan | 26017 | 837 | 42 |
493623 | 493623 | 2020-09-02 | Benzie | Michigan | 26019 | 50 | 2 |
493624 | 493624 | 2020-09-02 | Berrien | Michigan | 26021 | 1693 | 70 |
493625 | 493625 | 2020-09-02 | Branch | Michigan | 26023 | 1313 | 26 |
493626 | 493626 | 2020-09-02 | Calhoun | Michigan | 26025 | 1018 | 44 |
493627 | 493627 | 2020-09-02 | Cass | Michigan | 26027 | 415 | 16 |
493628 | 493628 | 2020-09-02 | Charlevoix | Michigan | 26029 | 77 | 3 |
493629 | 493629 | 2020-09-02 | Cheboygan | Michigan | 26031 | 80 | 2 |
493630 | 493630 | 2020-09-02 | Chippewa | Michigan | 26033 | 63 | 0 |
493631 | 493631 | 2020-09-02 | Clare | Michigan | 26035 | 103 | 4 |
493632 | 493632 | 2020-09-02 | Clinton | Michigan | 26037 | 505 | 13 |
493633 | 493633 | 2020-09-02 | Crawford | Michigan | 26039 | 113 | 5 |
493634 | 493634 | 2020-09-02 | Delta | Michigan | 26041 | 167 | 3 |
493635 | 493635 | 2020-09-02 | Dickinson | Michigan | 26043 | 66 | 2 |
493636 | 493636 | 2020-09-02 | Eaton | Michigan | 26045 | 522 | 9 |
493637 | 493637 | 2020-09-02 | Emmet | Michigan | 26047 | 128 | 3 |
493638 | 493638 | 2020-09-02 | Genesee | Michigan | 26049 | 3994 | 305 |
493639 | 493639 | 2020-09-02 | Gladwin | Michigan | 26051 | 79 | 2 |
493640 | 493640 | 2020-09-02 | Gogebic | Michigan | 26053 | 144 | 1 |
493641 | 493641 | 2020-09-02 | Grand Traverse | Michigan | 26055 | 367 | 7 |
493642 | 493642 | 2020-09-02 | Gratiot | Michigan | 26057 | 196 | 15 |
493643 | 493643 | 2020-09-02 | Hillsdale | Michigan | 26059 | 303 | 26 |
493644 | 493644 | 2020-09-02 | Houghton | Michigan | 26061 | 85 | 1 |
493645 | 493645 | 2020-09-02 | Huron | Michigan | 26063 | 203 | 4 |
493646 | 493646 | 2020-09-02 | Ingham | Michigan | 26065 | 1814 | 40 |
493647 | 493647 | 2020-09-02 | Ionia | Michigan | 26067 | 306 | 7 |
493648 | 493648 | 2020-09-02 | Iosco | Michigan | 26069 | 143 | 12 |
493649 | 493649 | 2020-09-02 | Iron | Michigan | 26071 | 35 | 1 |
493650 | 493650 | 2020-09-02 | Isabella | Michigan | 26073 | 530 | 10 |
493651 | 493651 | 2020-09-02 | Jackson | Michigan | 26075 | 2580 | 62 |
493652 | 493652 | 2020-09-02 | Kalamazoo | Michigan | 26077 | 1979 | 88 |
493653 | 493653 | 2020-09-02 | Kalkaska | Michigan | 26079 | 67 | 4 |
493654 | 493654 | 2020-09-02 | Kent | Michigan | 26081 | 8568 | 168 |
493655 | 493655 | 2020-09-02 | Keweenaw | Michigan | 26083 | 2 | 0 |
493656 | 493656 | 2020-09-02 | Lake | Michigan | 26085 | 29 | 0 |
493657 | 493657 | 2020-09-02 | Lapeer | Michigan | 26087 | 851 | 42 |
493658 | 493658 | 2020-09-02 | Leelanau | Michigan | 26089 | 95 | 1 |
493659 | 493659 | 2020-09-02 | Lenawee | Michigan | 26091 | 1365 | 17 |
493660 | 493660 | 2020-09-02 | Livingston | Michigan | 26093 | 1184 | 30 |
493661 | 493661 | 2020-09-02 | Luce | Michigan | 26095 | 121 | 0 |
493662 | 493662 | 2020-09-02 | Mackinac | Michigan | 26097 | 37 | 0 |
493663 | 493663 | 2020-09-02 | Macomb | Michigan | 26099 | 13179 | 984 |
493664 | 493664 | 2020-09-02 | Manistee | Michigan | 26101 | 69 | 1 |
493665 | 493665 | 2020-09-02 | Marquette | Michigan | 26103 | 254 | 11 |
493666 | 493666 | 2020-09-02 | Mason | Michigan | 26105 | 121 | 0 |
493667 | 493667 | 2020-09-02 | Mecosta | Michigan | 26107 | 92 | 2 |
493668 | 493668 | 2020-09-02 | Menominee | Michigan | 26109 | 256 | 0 |
493669 | 493669 | 2020-09-02 | Midland | Michigan | 26111 | 428 | 11 |
493670 | 493670 | 2020-09-02 | Missaukee | Michigan | 26113 | 49 | 1 |
493671 | 493671 | 2020-09-02 | Monroe | Michigan | 26115 | 1340 | 28 |
493672 | 493672 | 2020-09-02 | Montcalm | Michigan | 26117 | 230 | 4 |
493673 | 493673 | 2020-09-02 | Montmorency | Michigan | 26119 | 12 | 0 |
493674 | 493674 | 2020-09-02 | Muskegon | Michigan | 26121 | 1958 | 68 |
493675 | 493675 | 2020-09-02 | Newaygo | Michigan | 26123 | 302 | 1 |
493676 | 493676 | 2020-09-02 | Oakland | Michigan | 26125 | 18247 | 1165 |
493677 | 493677 | 2020-09-02 | Oceana | Michigan | 26127 | 501 | 6 |
493678 | 493678 | 2020-09-02 | Ogemaw | Michigan | 26129 | 58 | 5 |
493679 | 493679 | 2020-09-02 | Ontonagon | Michigan | 26131 | 34 | 0 |
493680 | 493680 | 2020-09-02 | Osceola | Michigan | 26133 | 79 | 0 |
493681 | 493681 | 2020-09-02 | Oscoda | Michigan | 26135 | 29 | 1 |
493682 | 493682 | 2020-09-02 | Otsego | Michigan | 26137 | 158 | 11 |
493683 | 493683 | 2020-09-02 | Ottawa | Michigan | 26139 | 2300 | 63 |
493684 | 493684 | 2020-09-02 | Presque Isle | Michigan | 26141 | 21 | 1 |
493685 | 493685 | 2020-09-02 | Roscommon | Michigan | 26143 | 76 | 4 |
493686 | 493686 | 2020-09-02 | Saginaw | Michigan | 26145 | 2562 | 132 |
493687 | 493687 | 2020-09-02 | Sanilac | Michigan | 26151 | 125 | 7 |
493688 | 493688 | 2020-09-02 | Schoolcraft | Michigan | 26153 | 15 | 0 |
493689 | 493689 | 2020-09-02 | Shiawassee | Michigan | 26155 | 436 | 30 |
493690 | 493690 | 2020-09-02 | St. Clair | Michigan | 26147 | 935 | 53 |
493691 | 493691 | 2020-09-02 | St. Joseph | Michigan | 26149 | 684 | 11 |
493692 | 493692 | 2020-09-02 | Tuscola | Michigan | 26157 | 459 | 29 |
493693 | 493693 | 2020-09-02 | Unknown | Michigan | 461 | 5 | |
493694 | 493694 | 2020-09-02 | Van Buren | Michigan | 26159 | 643 | 16 |
493695 | 493695 | 2020-09-02 | Washtenaw | Michigan | 26161 | 3466 | 124 |
493696 | 493696 | 2020-09-02 | Wayne | Michigan | 26163 | 31508 | 2891 |
493697 | 493697 | 2020-09-02 | Wexford | Michigan | 26165 | 112 | 4 |
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);