ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2020-11-17 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
739935 | 739935 | 2020-11-17 | Alcona | Michigan | 26001 | 109 | 3 |
739936 | 739936 | 2020-11-17 | Alger | Michigan | 26003 | 195 | 2 |
739937 | 739937 | 2020-11-17 | Allegan | Michigan | 26005 | 2945 | 17 |
739938 | 739938 | 2020-11-17 | Alpena | Michigan | 26007 | 362 | 16 |
739939 | 739939 | 2020-11-17 | Antrim | Michigan | 26009 | 286 | 3 |
739940 | 739940 | 2020-11-17 | Arenac | Michigan | 26011 | 256 | 6 |
739941 | 739941 | 2020-11-17 | Baraga | Michigan | 26013 | 346 | 5 |
739942 | 739942 | 2020-11-17 | Barry | Michigan | 26015 | 1508 | 10 |
739943 | 739943 | 2020-11-17 | Bay | Michigan | 26017 | 3186 | 79 |
739944 | 739944 | 2020-11-17 | Benzie | Michigan | 26019 | 242 | 3 |
739945 | 739945 | 2020-11-17 | Berrien | Michigan | 26021 | 4979 | 103 |
739946 | 739946 | 2020-11-17 | Branch | Michigan | 26023 | 2545 | 44 |
739947 | 739947 | 2020-11-17 | Calhoun | Michigan | 26025 | 4974 | 105 |
739948 | 739948 | 2020-11-17 | Cass | Michigan | 26027 | 1733 | 27 |
739949 | 739949 | 2020-11-17 | Charlevoix | Michigan | 26029 | 393 | 5 |
739950 | 739950 | 2020-11-17 | Cheboygan | Michigan | 26031 | 344 | 15 |
739951 | 739951 | 2020-11-17 | Chippewa | Michigan | 26033 | 590 | 2 |
739952 | 739952 | 2020-11-17 | Clare | Michigan | 26035 | 564 | 22 |
739953 | 739953 | 2020-11-17 | Clinton | Michigan | 26037 | 2193 | 18 |
739954 | 739954 | 2020-11-17 | Crawford | Michigan | 26039 | 247 | 5 |
739955 | 739955 | 2020-11-17 | Delta | Michigan | 26041 | 2108 | 55 |
739956 | 739956 | 2020-11-17 | Dickinson | Michigan | 26043 | 1391 | 30 |
739957 | 739957 | 2020-11-17 | Eaton | Michigan | 26045 | 2270 | 24 |
739958 | 739958 | 2020-11-17 | Emmet | Michigan | 26047 | 772 | 22 |
739959 | 739959 | 2020-11-17 | Genesee | Michigan | 26049 | 11179 | 378 |
739960 | 739960 | 2020-11-17 | Gladwin | Michigan | 26051 | 538 | 7 |
739961 | 739961 | 2020-11-17 | Gogebic | Michigan | 26053 | 664 | 19 |
739962 | 739962 | 2020-11-17 | Grand Traverse | Michigan | 26055 | 1389 | 17 |
739963 | 739963 | 2020-11-17 | Gratiot | Michigan | 26057 | 1182 | 21 |
739964 | 739964 | 2020-11-17 | Hillsdale | Michigan | 26059 | 1141 | 32 |
739965 | 739965 | 2020-11-17 | Houghton | Michigan | 26061 | 1326 | 10 |
739966 | 739966 | 2020-11-17 | Huron | Michigan | 26063 | 499 | 11 |
739967 | 739967 | 2020-11-17 | Ingham | Michigan | 26065 | 7038 | 90 |
739968 | 739968 | 2020-11-17 | Ionia | Michigan | 26067 | 2396 | 13 |
739969 | 739969 | 2020-11-17 | Iosco | Michigan | 26069 | 522 | 19 |
739970 | 739970 | 2020-11-17 | Iron | Michigan | 26071 | 633 | 32 |
739971 | 739971 | 2020-11-17 | Isabella | Michigan | 26073 | 1922 | 17 |
739972 | 739972 | 2020-11-17 | Jackson | Michigan | 26075 | 5343 | 106 |
739973 | 739973 | 2020-11-17 | Kalamazoo | Michigan | 26077 | 7654 | 147 |
739974 | 739974 | 2020-11-17 | Kalkaska | Michigan | 26079 | 264 | 4 |
739975 | 739975 | 2020-11-17 | Kent | Michigan | 26081 | 25705 | 257 |
739976 | 739976 | 2020-11-17 | Keweenaw | Michigan | 26083 | 47 | 1 |
739977 | 739977 | 2020-11-17 | Lake | Michigan | 26085 | 142 | 1 |
739978 | 739978 | 2020-11-17 | Lapeer | Michigan | 26087 | 2008 | 52 |
739979 | 739979 | 2020-11-17 | Leelanau | Michigan | 26089 | 282 | 2 |
739980 | 739980 | 2020-11-17 | Lenawee | Michigan | 26091 | 2565 | 26 |
739981 | 739981 | 2020-11-17 | Livingston | Michigan | 26093 | 3979 | 38 |
739982 | 739982 | 2020-11-17 | Luce | Michigan | 26095 | 562 | 0 |
739983 | 739983 | 2020-11-17 | Mackinac | Michigan | 26097 | 228 | 0 |
739984 | 739984 | 2020-11-17 | Macomb | Michigan | 26099 | 29309 | 1179 |
739985 | 739985 | 2020-11-17 | Manistee | Michigan | 26101 | 277 | 5 |
739986 | 739986 | 2020-11-17 | Marquette | Michigan | 26103 | 3091 | 23 |
739987 | 739987 | 2020-11-17 | Mason | Michigan | 26105 | 472 | 8 |
739988 | 739988 | 2020-11-17 | Mecosta | Michigan | 26107 | 972 | 7 |
739989 | 739989 | 2020-11-17 | Menominee | Michigan | 26109 | 1096 | 11 |
739990 | 739990 | 2020-11-17 | Midland | Michigan | 26111 | 2297 | 18 |
739991 | 739991 | 2020-11-17 | Missaukee | Michigan | 26113 | 213 | 2 |
739992 | 739992 | 2020-11-17 | Monroe | Michigan | 26115 | 3754 | 55 |
739993 | 739993 | 2020-11-17 | Montcalm | Michigan | 26117 | 1379 | 19 |
739994 | 739994 | 2020-11-17 | Montmorency | Michigan | 26119 | 94 | 1 |
739995 | 739995 | 2020-11-17 | Muskegon | Michigan | 26121 | 6512 | 126 |
739996 | 739996 | 2020-11-17 | Newaygo | Michigan | 26123 | 1203 | 10 |
739997 | 739997 | 2020-11-17 | Oakland | Michigan | 26125 | 36983 | 1285 |
739998 | 739998 | 2020-11-17 | Oceana | Michigan | 26127 | 970 | 9 |
739999 | 739999 | 2020-11-17 | Ogemaw | Michigan | 26129 | 322 | 9 |
740000 | 740000 | 2020-11-17 | Ontonagon | Michigan | 26131 | 246 | 7 |
740001 | 740001 | 2020-11-17 | Osceola | Michigan | 26133 | 368 | 2 |
740002 | 740002 | 2020-11-17 | Oscoda | Michigan | 26135 | 100 | 2 |
740003 | 740003 | 2020-11-17 | Otsego | Michigan | 26137 | 584 | 15 |
740004 | 740004 | 2020-11-17 | Ottawa | Michigan | 26139 | 10394 | 107 |
740005 | 740005 | 2020-11-17 | Presque Isle | Michigan | 26141 | 168 | 2 |
740006 | 740006 | 2020-11-17 | Roscommon | Michigan | 26143 | 399 | 7 |
740007 | 740007 | 2020-11-17 | Saginaw | Michigan | 26145 | 6693 | 182 |
740008 | 740008 | 2020-11-17 | Sanilac | Michigan | 26151 | 448 | 10 |
740009 | 740009 | 2020-11-17 | Schoolcraft | Michigan | 26153 | 156 | 2 |
740010 | 740010 | 2020-11-17 | Shiawassee | Michigan | 26155 | 1429 | 35 |
740011 | 740011 | 2020-11-17 | St. Clair | Michigan | 26147 | 3140 | 74 |
740012 | 740012 | 2020-11-17 | St. Joseph | Michigan | 26149 | 2095 | 28 |
740013 | 740013 | 2020-11-17 | Tuscola | Michigan | 26157 | 1286 | 43 |
740014 | 740014 | 2020-11-17 | Unknown | Michigan | 2322 | 4 | |
740015 | 740015 | 2020-11-17 | Van Buren | Michigan | 26159 | 2085 | 25 |
740016 | 740016 | 2020-11-17 | Washtenaw | Michigan | 26161 | 8428 | 135 |
740017 | 740017 | 2020-11-17 | Wayne | Michigan | 26163 | 52984 | 3134 |
740018 | 740018 | 2020-11-17 | Wexford | Michigan | 26165 | 421 | 11 |
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);