ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where "date" is on date 2020-04-09 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
44267 | 44267 | 2020-04-09 | Allegan | Michigan | 26005 | 18 | 0 |
44268 | 44268 | 2020-04-09 | Antrim | Michigan | 26009 | 6 | 0 |
44269 | 44269 | 2020-04-09 | Arenac | Michigan | 26011 | 4 | 0 |
44270 | 44270 | 2020-04-09 | Barry | Michigan | 26015 | 7 | 0 |
44271 | 44271 | 2020-04-09 | Bay | Michigan | 26017 | 42 | 0 |
44272 | 44272 | 2020-04-09 | Berrien | Michigan | 26021 | 80 | 2 |
44273 | 44273 | 2020-04-09 | Branch | Michigan | 26023 | 24 | 1 |
44274 | 44274 | 2020-04-09 | Calhoun | Michigan | 26025 | 57 | 1 |
44275 | 44275 | 2020-04-09 | Cass | Michigan | 26027 | 10 | 1 |
44276 | 44276 | 2020-04-09 | Charlevoix | Michigan | 26029 | 9 | 0 |
44277 | 44277 | 2020-04-09 | Cheboygan | Michigan | 26031 | 10 | 1 |
44278 | 44278 | 2020-04-09 | Chippewa | Michigan | 26033 | 1 | 0 |
44279 | 44279 | 2020-04-09 | Clare | Michigan | 26035 | 3 | 0 |
44280 | 44280 | 2020-04-09 | Clinton | Michigan | 26037 | 85 | 1 |
44281 | 44281 | 2020-04-09 | Crawford | Michigan | 26039 | 5 | 1 |
44282 | 44282 | 2020-04-09 | Delta | Michigan | 26041 | 9 | 1 |
44283 | 44283 | 2020-04-09 | Dickinson | Michigan | 26043 | 3 | 1 |
44284 | 44284 | 2020-04-09 | Eaton | Michigan | 26045 | 69 | 3 |
44285 | 44285 | 2020-04-09 | Emmet | Michigan | 26047 | 16 | 2 |
44286 | 44286 | 2020-04-09 | Genesee | Michigan | 26049 | 755 | 48 |
44287 | 44287 | 2020-04-09 | Gladwin | Michigan | 26051 | 4 | 0 |
44288 | 44288 | 2020-04-09 | Gogebic | Michigan | 26053 | 3 | 1 |
44289 | 44289 | 2020-04-09 | Grand Traverse | Michigan | 26055 | 15 | 3 |
44290 | 44290 | 2020-04-09 | Gratiot | Michigan | 26057 | 6 | 0 |
44291 | 44291 | 2020-04-09 | Hillsdale | Michigan | 26059 | 64 | 6 |
44292 | 44292 | 2020-04-09 | Houghton | Michigan | 26061 | 1 | 0 |
44293 | 44293 | 2020-04-09 | Huron | Michigan | 26063 | 5 | 0 |
44294 | 44294 | 2020-04-09 | Ingham | Michigan | 26065 | 222 | 3 |
44295 | 44295 | 2020-04-09 | Ionia | Michigan | 26067 | 13 | 1 |
44296 | 44296 | 2020-04-09 | Iosco | Michigan | 26069 | 4 | 1 |
44297 | 44297 | 2020-04-09 | Isabella | Michigan | 26073 | 28 | 2 |
44298 | 44298 | 2020-04-09 | Jackson | Michigan | 26075 | 131 | 4 |
44299 | 44299 | 2020-04-09 | Kalamazoo | Michigan | 26077 | 74 | 6 |
44300 | 44300 | 2020-04-09 | Kalkaska | Michigan | 26079 | 10 | 2 |
44301 | 44301 | 2020-04-09 | Kent | Michigan | 26081 | 233 | 10 |
44302 | 44302 | 2020-04-09 | Lapeer | Michigan | 26087 | 77 | 5 |
44303 | 44303 | 2020-04-09 | Leelanau | Michigan | 26089 | 4 | 0 |
44304 | 44304 | 2020-04-09 | Lenawee | Michigan | 26091 | 39 | 0 |
44305 | 44305 | 2020-04-09 | Livingston | Michigan | 26093 | 181 | 2 |
44306 | 44306 | 2020-04-09 | Luce | Michigan | 26095 | 1 | 0 |
44307 | 44307 | 2020-04-09 | Mackinac | Michigan | 26097 | 4 | 0 |
44308 | 44308 | 2020-04-09 | Macomb | Michigan | 26099 | 2783 | 165 |
44309 | 44309 | 2020-04-09 | Manistee | Michigan | 26101 | 9 | 0 |
44310 | 44310 | 2020-04-09 | Marquette | Michigan | 26103 | 18 | 2 |
44311 | 44311 | 2020-04-09 | Mason | Michigan | 26105 | 1 | 0 |
44312 | 44312 | 2020-04-09 | Mecosta | Michigan | 26107 | 9 | 1 |
44313 | 44313 | 2020-04-09 | Midland | Michigan | 26111 | 28 | 1 |
44314 | 44314 | 2020-04-09 | Missaukee | Michigan | 26113 | 1 | 1 |
44315 | 44315 | 2020-04-09 | Monroe | Michigan | 26115 | 165 | 1 |
44316 | 44316 | 2020-04-09 | Montcalm | Michigan | 26117 | 19 | 1 |
44317 | 44317 | 2020-04-09 | Muskegon | Michigan | 26121 | 53 | 4 |
44318 | 44318 | 2020-04-09 | Newaygo | Michigan | 26123 | 3 | 0 |
44319 | 44319 | 2020-04-09 | Oakland | Michigan | 26125 | 4247 | 246 |
44320 | 44320 | 2020-04-09 | Oceana | Michigan | 26127 | 3 | 1 |
44321 | 44321 | 2020-04-09 | Ogemaw | Michigan | 26129 | 3 | 0 |
44322 | 44322 | 2020-04-09 | Osceola | Michigan | 26133 | 3 | 0 |
44323 | 44323 | 2020-04-09 | Oscoda | Michigan | 26135 | 3 | 0 |
44324 | 44324 | 2020-04-09 | Otsego | Michigan | 26137 | 29 | 2 |
44325 | 44325 | 2020-04-09 | Ottawa | Michigan | 26139 | 59 | 1 |
44326 | 44326 | 2020-04-09 | Presque Isle | Michigan | 26141 | 1 | 0 |
44327 | 44327 | 2020-04-09 | Roscommon | Michigan | 26143 | 8 | 0 |
44328 | 44328 | 2020-04-09 | Saginaw | Michigan | 26145 | 205 | 7 |
44329 | 44329 | 2020-04-09 | Sanilac | Michigan | 26151 | 22 | 2 |
44330 | 44330 | 2020-04-09 | Schoolcraft | Michigan | 26153 | 1 | 0 |
44331 | 44331 | 2020-04-09 | Shiawassee | Michigan | 26155 | 31 | 0 |
44332 | 44332 | 2020-04-09 | St. Clair | Michigan | 26147 | 162 | 4 |
44333 | 44333 | 2020-04-09 | St. Joseph | Michigan | 26149 | 18 | 0 |
44334 | 44334 | 2020-04-09 | Tuscola | Michigan | 26157 | 36 | 3 |
44335 | 44335 | 2020-04-09 | Unknown | Michigan | 368 | 5 | |
44336 | 44336 | 2020-04-09 | Van Buren | Michigan | 26159 | 18 | 1 |
44337 | 44337 | 2020-04-09 | Washtenaw | Michigan | 26161 | 637 | 15 |
44338 | 44338 | 2020-04-09 | Wayne | Michigan | 26163 | 10093 | 504 |
44339 | 44339 | 2020-04-09 | Wexford | Michigan | 26165 | 7 | 0 |
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);