ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-09-12" 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 |
---|---|---|---|---|---|---|---|
525955 | 525955 | 2020-09-12 | Alcona | Michigan | 26001 | 40 | 2 |
525956 | 525956 | 2020-09-12 | Alger | Michigan | 26003 | 17 | 0 |
525957 | 525957 | 2020-09-12 | Allegan | Michigan | 26005 | 694 | 7 |
525958 | 525958 | 2020-09-12 | Alpena | Michigan | 26007 | 132 | 14 |
525959 | 525959 | 2020-09-12 | Antrim | Michigan | 26009 | 64 | 0 |
525960 | 525960 | 2020-09-12 | Arenac | Michigan | 26011 | 66 | 3 |
525961 | 525961 | 2020-09-12 | Baraga | Michigan | 26013 | 11 | 0 |
525962 | 525962 | 2020-09-12 | Barry | Michigan | 26015 | 257 | 2 |
525963 | 525963 | 2020-09-12 | Bay | Michigan | 26017 | 903 | 46 |
525964 | 525964 | 2020-09-12 | Benzie | Michigan | 26019 | 63 | 2 |
525965 | 525965 | 2020-09-12 | Berrien | Michigan | 26021 | 1808 | 72 |
525966 | 525966 | 2020-09-12 | Branch | Michigan | 26023 | 1360 | 27 |
525967 | 525967 | 2020-09-12 | Calhoun | Michigan | 26025 | 1130 | 44 |
525968 | 525968 | 2020-09-12 | Cass | Michigan | 26027 | 466 | 16 |
525969 | 525969 | 2020-09-12 | Charlevoix | Michigan | 26029 | 93 | 3 |
525970 | 525970 | 2020-09-12 | Cheboygan | Michigan | 26031 | 86 | 2 |
525971 | 525971 | 2020-09-12 | Chippewa | Michigan | 26033 | 67 | 0 |
525972 | 525972 | 2020-09-12 | Clare | Michigan | 26035 | 107 | 4 |
525973 | 525973 | 2020-09-12 | Clinton | Michigan | 26037 | 591 | 13 |
525974 | 525974 | 2020-09-12 | Crawford | Michigan | 26039 | 116 | 5 |
525975 | 525975 | 2020-09-12 | Delta | Michigan | 26041 | 211 | 4 |
525976 | 525976 | 2020-09-12 | Dickinson | Michigan | 26043 | 73 | 2 |
525977 | 525977 | 2020-09-12 | Eaton | Michigan | 26045 | 569 | 10 |
525978 | 525978 | 2020-09-12 | Emmet | Michigan | 26047 | 136 | 4 |
525979 | 525979 | 2020-09-12 | Genesee | Michigan | 26049 | 4104 | 306 |
525980 | 525980 | 2020-09-12 | Gladwin | Michigan | 26051 | 84 | 2 |
525981 | 525981 | 2020-09-12 | Gogebic | Michigan | 26053 | 149 | 1 |
525982 | 525982 | 2020-09-12 | Grand Traverse | Michigan | 26055 | 432 | 7 |
525983 | 525983 | 2020-09-12 | Gratiot | Michigan | 26057 | 222 | 15 |
525984 | 525984 | 2020-09-12 | Hillsdale | Michigan | 26059 | 313 | 27 |
525985 | 525985 | 2020-09-12 | Houghton | Michigan | 26061 | 210 | 1 |
525986 | 525986 | 2020-09-12 | Huron | Michigan | 26063 | 205 | 5 |
525987 | 525987 | 2020-09-12 | Ingham | Michigan | 26065 | 2525 | 42 |
525988 | 525988 | 2020-09-12 | Ionia | Michigan | 26067 | 366 | 7 |
525989 | 525989 | 2020-09-12 | Iosco | Michigan | 26069 | 167 | 12 |
525990 | 525990 | 2020-09-12 | Iron | Michigan | 26071 | 48 | 1 |
525991 | 525991 | 2020-09-12 | Isabella | Michigan | 26073 | 606 | 10 |
525992 | 525992 | 2020-09-12 | Jackson | Michigan | 26075 | 2665 | 64 |
525993 | 525993 | 2020-09-12 | Kalamazoo | Michigan | 26077 | 2276 | 91 |
525994 | 525994 | 2020-09-12 | Kalkaska | Michigan | 26079 | 76 | 4 |
525995 | 525995 | 2020-09-12 | Kent | Michigan | 26081 | 9015 | 172 |
525996 | 525996 | 2020-09-12 | Keweenaw | Michigan | 26083 | 7 | 0 |
525997 | 525997 | 2020-09-12 | Lake | Michigan | 26085 | 32 | 0 |
525998 | 525998 | 2020-09-12 | Lapeer | Michigan | 26087 | 872 | 44 |
525999 | 525999 | 2020-09-12 | Leelanau | Michigan | 26089 | 103 | 1 |
526000 | 526000 | 2020-09-12 | Lenawee | Michigan | 26091 | 1460 | 18 |
526001 | 526001 | 2020-09-12 | Livingston | Michigan | 26093 | 1291 | 30 |
526002 | 526002 | 2020-09-12 | Luce | Michigan | 26095 | 215 | 0 |
526003 | 526003 | 2020-09-12 | Mackinac | Michigan | 26097 | 51 | 0 |
526004 | 526004 | 2020-09-12 | Macomb | Michigan | 26099 | 13917 | 1007 |
526005 | 526005 | 2020-09-12 | Manistee | Michigan | 26101 | 79 | 2 |
526006 | 526006 | 2020-09-12 | Marquette | Michigan | 26103 | 285 | 11 |
526007 | 526007 | 2020-09-12 | Mason | Michigan | 26105 | 130 | 0 |
526008 | 526008 | 2020-09-12 | Mecosta | Michigan | 26107 | 163 | 2 |
526009 | 526009 | 2020-09-12 | Menominee | Michigan | 26109 | 267 | 0 |
526010 | 526010 | 2020-09-12 | Midland | Michigan | 26111 | 508 | 11 |
526011 | 526011 | 2020-09-12 | Missaukee | Michigan | 26113 | 54 | 1 |
526012 | 526012 | 2020-09-12 | Monroe | Michigan | 26115 | 1427 | 29 |
526013 | 526013 | 2020-09-12 | Montcalm | Michigan | 26117 | 259 | 4 |
526014 | 526014 | 2020-09-12 | Montmorency | Michigan | 26119 | 13 | 0 |
526015 | 526015 | 2020-09-12 | Muskegon | Michigan | 26121 | 2321 | 70 |
526016 | 526016 | 2020-09-12 | Newaygo | Michigan | 26123 | 310 | 1 |
526017 | 526017 | 2020-09-12 | Oakland | Michigan | 26125 | 19348 | 1184 |
526018 | 526018 | 2020-09-12 | Oceana | Michigan | 26127 | 501 | 6 |
526019 | 526019 | 2020-09-12 | Ogemaw | Michigan | 26129 | 60 | 5 |
526020 | 526020 | 2020-09-12 | Ontonagon | Michigan | 26131 | 37 | 0 |
526021 | 526021 | 2020-09-12 | Osceola | Michigan | 26133 | 86 | 0 |
526022 | 526022 | 2020-09-12 | Oscoda | Michigan | 26135 | 29 | 1 |
526023 | 526023 | 2020-09-12 | Otsego | Michigan | 26137 | 168 | 11 |
526024 | 526024 | 2020-09-12 | Ottawa | Michigan | 26139 | 2898 | 65 |
526025 | 526025 | 2020-09-12 | Presque Isle | Michigan | 26141 | 23 | 1 |
526026 | 526026 | 2020-09-12 | Roscommon | Michigan | 26143 | 83 | 4 |
526027 | 526027 | 2020-09-12 | Saginaw | Michigan | 26145 | 2761 | 134 |
526028 | 526028 | 2020-09-12 | Sanilac | Michigan | 26151 | 132 | 7 |
526029 | 526029 | 2020-09-12 | Schoolcraft | Michigan | 26153 | 17 | 0 |
526030 | 526030 | 2020-09-12 | Shiawassee | Michigan | 26155 | 472 | 30 |
526031 | 526031 | 2020-09-12 | St. Clair | Michigan | 26147 | 958 | 53 |
526032 | 526032 | 2020-09-12 | St. Joseph | Michigan | 26149 | 708 | 11 |
526033 | 526033 | 2020-09-12 | Tuscola | Michigan | 26157 | 471 | 29 |
526034 | 526034 | 2020-09-12 | Unknown | Michigan | 258 | 3 | |
526035 | 526035 | 2020-09-12 | Van Buren | Michigan | 26159 | 700 | 17 |
526036 | 526036 | 2020-09-12 | Washtenaw | Michigan | 26161 | 3657 | 124 |
526037 | 526037 | 2020-09-12 | Wayne | Michigan | 26163 | 33276 | 2943 |
526038 | 526038 | 2020-09-12 | Wexford | Michigan | 26165 | 118 | 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);