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-07-12 and state = "Michigan" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
326303 | 326303 | 2020-07-12 | Alcona | Michigan | 26001 | 24 | 1 |
326304 | 326304 | 2020-07-12 | Alger | Michigan | 26003 | 4 | 0 |
326305 | 326305 | 2020-07-12 | Allegan | Michigan | 26005 | 373 | 7 |
326306 | 326306 | 2020-07-12 | Alpena | Michigan | 26007 | 123 | 12 |
326307 | 326307 | 2020-07-12 | Antrim | Michigan | 26009 | 25 | 0 |
326308 | 326308 | 2020-07-12 | Arenac | Michigan | 26011 | 38 | 2 |
326309 | 326309 | 2020-07-12 | Baraga | Michigan | 26013 | 5 | 0 |
326310 | 326310 | 2020-07-12 | Barry | Michigan | 26015 | 134 | 2 |
326311 | 326311 | 2020-07-12 | Bay | Michigan | 26017 | 431 | 31 |
326312 | 326312 | 2020-07-12 | Benzie | Michigan | 26019 | 14 | 0 |
326313 | 326313 | 2020-07-12 | Berrien | Michigan | 26021 | 1069 | 60 |
326314 | 326314 | 2020-07-12 | Branch | Michigan | 26023 | 1062 | 25 |
326315 | 326315 | 2020-07-12 | Calhoun | Michigan | 26025 | 608 | 39 |
326316 | 326316 | 2020-07-12 | Cass | Michigan | 26027 | 187 | 6 |
326317 | 326317 | 2020-07-12 | Charlevoix | Michigan | 26029 | 34 | 2 |
326318 | 326318 | 2020-07-12 | Cheboygan | Michigan | 26031 | 30 | 2 |
326319 | 326319 | 2020-07-12 | Chippewa | Michigan | 26033 | 19 | 0 |
326320 | 326320 | 2020-07-12 | Clare | Michigan | 26035 | 32 | 3 |
326321 | 326321 | 2020-07-12 | Clinton | Michigan | 26037 | 291 | 12 |
326322 | 326322 | 2020-07-12 | Crawford | Michigan | 26039 | 86 | 5 |
326323 | 326323 | 2020-07-12 | Delta | Michigan | 26041 | 32 | 3 |
326324 | 326324 | 2020-07-12 | Dickinson | Michigan | 26043 | 17 | 2 |
326325 | 326325 | 2020-07-12 | Eaton | Michigan | 26045 | 356 | 7 |
326326 | 326326 | 2020-07-12 | Emmet | Michigan | 26047 | 39 | 2 |
326327 | 326327 | 2020-07-12 | Genesee | Michigan | 26049 | 2910 | 291 |
326328 | 326328 | 2020-07-12 | Gladwin | Michigan | 26051 | 27 | 1 |
326329 | 326329 | 2020-07-12 | Gogebic | Michigan | 26053 | 12 | 1 |
326330 | 326330 | 2020-07-12 | Grand Traverse | Michigan | 26055 | 94 | 5 |
326331 | 326331 | 2020-07-12 | Gratiot | Michigan | 26057 | 111 | 14 |
326332 | 326332 | 2020-07-12 | Hillsdale | Michigan | 26059 | 205 | 25 |
326333 | 326333 | 2020-07-12 | Houghton | Michigan | 26061 | 27 | 0 |
326334 | 326334 | 2020-07-12 | Huron | Michigan | 26063 | 77 | 3 |
326335 | 326335 | 2020-07-12 | Ingham | Michigan | 26065 | 1174 | 30 |
326336 | 326336 | 2020-07-12 | Ionia | Michigan | 26067 | 213 | 5 |
326337 | 326337 | 2020-07-12 | Iosco | Michigan | 26069 | 122 | 11 |
326338 | 326338 | 2020-07-12 | Iron | Michigan | 26071 | 7 | 1 |
326339 | 326339 | 2020-07-12 | Isabella | Michigan | 26073 | 159 | 8 |
326340 | 326340 | 2020-07-12 | Jackson | Michigan | 26075 | 2159 | 54 |
326341 | 326341 | 2020-07-12 | Kalamazoo | Michigan | 26077 | 1234 | 70 |
326342 | 326342 | 2020-07-12 | Kalkaska | Michigan | 26079 | 43 | 2 |
326343 | 326343 | 2020-07-12 | Kent | Michigan | 26081 | 5857 | 144 |
326344 | 326344 | 2020-07-12 | Keweenaw | Michigan | 26083 | 1 | 0 |
326345 | 326345 | 2020-07-12 | Lake | Michigan | 26085 | 12 | 0 |
326346 | 326346 | 2020-07-12 | Lapeer | Michigan | 26087 | 628 | 38 |
326347 | 326347 | 2020-07-12 | Leelanau | Michigan | 26089 | 42 | 0 |
326348 | 326348 | 2020-07-12 | Lenawee | Michigan | 26091 | 1008 | 15 |
326349 | 326349 | 2020-07-12 | Livingston | Michigan | 26093 | 663 | 29 |
326350 | 326350 | 2020-07-12 | Luce | Michigan | 26095 | 4 | 0 |
326351 | 326351 | 2020-07-12 | Mackinac | Michigan | 26097 | 9 | 0 |
326352 | 326352 | 2020-07-12 | Macomb | Michigan | 26099 | 8070 | 933 |
326353 | 326353 | 2020-07-12 | Manistee | Michigan | 26101 | 38 | 0 |
326354 | 326354 | 2020-07-12 | Marquette | Michigan | 26103 | 88 | 11 |
326355 | 326355 | 2020-07-12 | Mason | Michigan | 26105 | 76 | 0 |
326356 | 326356 | 2020-07-12 | Mecosta | Michigan | 26107 | 39 | 2 |
326357 | 326357 | 2020-07-12 | Menominee | Michigan | 26109 | 43 | 0 |
326358 | 326358 | 2020-07-12 | Midland | Michigan | 26111 | 183 | 9 |
326359 | 326359 | 2020-07-12 | Missaukee | Michigan | 26113 | 36 | 1 |
326360 | 326360 | 2020-07-12 | Monroe | Michigan | 26115 | 661 | 21 |
326361 | 326361 | 2020-07-12 | Montcalm | Michigan | 26117 | 127 | 1 |
326362 | 326362 | 2020-07-12 | Montmorency | Michigan | 26119 | 7 | 0 |
326363 | 326363 | 2020-07-12 | Muskegon | Michigan | 26121 | 927 | 54 |
326364 | 326364 | 2020-07-12 | Newaygo | Michigan | 26123 | 197 | 0 |
326365 | 326365 | 2020-07-12 | Oakland | Michigan | 26125 | 12700 | 1108 |
326366 | 326366 | 2020-07-12 | Oceana | Michigan | 26127 | 405 | 5 |
326367 | 326367 | 2020-07-12 | Ogemaw | Michigan | 26129 | 46 | 2 |
326368 | 326368 | 2020-07-12 | Ontonagon | Michigan | 26131 | 1 | 0 |
326369 | 326369 | 2020-07-12 | Osceola | Michigan | 26133 | 46 | 0 |
326370 | 326370 | 2020-07-12 | Oscoda | Michigan | 26135 | 23 | 1 |
326371 | 326371 | 2020-07-12 | Otsego | Michigan | 26137 | 135 | 10 |
326372 | 326372 | 2020-07-12 | Ottawa | Michigan | 26139 | 1306 | 52 |
326373 | 326373 | 2020-07-12 | Presque Isle | Michigan | 26141 | 13 | 0 |
326374 | 326374 | 2020-07-12 | Roscommon | Michigan | 26143 | 33 | 0 |
326375 | 326375 | 2020-07-12 | Saginaw | Michigan | 26145 | 1404 | 124 |
326376 | 326376 | 2020-07-12 | Sanilac | Michigan | 26151 | 57 | 6 |
326377 | 326377 | 2020-07-12 | Schoolcraft | Michigan | 26153 | 7 | 0 |
326378 | 326378 | 2020-07-12 | Shiawassee | Michigan | 26155 | 285 | 28 |
326379 | 326379 | 2020-07-12 | St. Clair | Michigan | 26147 | 611 | 53 |
326380 | 326380 | 2020-07-12 | St. Joseph | Michigan | 26149 | 382 | 5 |
326381 | 326381 | 2020-07-12 | Tuscola | Michigan | 26157 | 247 | 27 |
326382 | 326382 | 2020-07-12 | Unknown | Michigan | 149 | 2 | |
326383 | 326383 | 2020-07-12 | Van Buren | Michigan | 26159 | 273 | 9 |
326384 | 326384 | 2020-07-12 | Washtenaw | Michigan | 26161 | 2413 | 118 |
326385 | 326385 | 2020-07-12 | Wayne | Michigan | 26163 | 24020 | 2761 |
326386 | 326386 | 2020-07-12 | Wexford | Michigan | 26165 | 57 | 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);