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-27 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
374308 | 374308 | 2020-07-27 | Alcona | Michigan | 26001 | 27 | 1 |
374309 | 374309 | 2020-07-27 | Alger | Michigan | 26003 | 5 | 0 |
374310 | 374310 | 2020-07-27 | Allegan | Michigan | 26005 | 472 | 7 |
374311 | 374311 | 2020-07-27 | Alpena | Michigan | 26007 | 125 | 13 |
374312 | 374312 | 2020-07-27 | Antrim | Michigan | 26009 | 35 | 0 |
374313 | 374313 | 2020-07-27 | Arenac | Michigan | 26011 | 41 | 2 |
374314 | 374314 | 2020-07-27 | Baraga | Michigan | 26013 | 5 | 0 |
374315 | 374315 | 2020-07-27 | Barry | Michigan | 26015 | 170 | 2 |
374316 | 374316 | 2020-07-27 | Bay | Michigan | 26017 | 524 | 31 |
374317 | 374317 | 2020-07-27 | Benzie | Michigan | 26019 | 30 | 1 |
374318 | 374318 | 2020-07-27 | Berrien | Michigan | 26021 | 1297 | 63 |
374319 | 374319 | 2020-07-27 | Branch | Michigan | 26023 | 1121 | 25 |
374320 | 374320 | 2020-07-27 | Calhoun | Michigan | 26025 | 699 | 39 |
374321 | 374321 | 2020-07-27 | Cass | Michigan | 26027 | 263 | 8 |
374322 | 374322 | 2020-07-27 | Charlevoix | Michigan | 26029 | 44 | 2 |
374323 | 374323 | 2020-07-27 | Cheboygan | Michigan | 26031 | 34 | 2 |
374324 | 374324 | 2020-07-27 | Chippewa | Michigan | 26033 | 29 | 0 |
374325 | 374325 | 2020-07-27 | Clare | Michigan | 26035 | 52 | 3 |
374326 | 374326 | 2020-07-27 | Clinton | Michigan | 26037 | 367 | 12 |
374327 | 374327 | 2020-07-27 | Crawford | Michigan | 26039 | 94 | 5 |
374328 | 374328 | 2020-07-27 | Delta | Michigan | 26041 | 60 | 3 |
374329 | 374329 | 2020-07-27 | Dickinson | Michigan | 26043 | 42 | 2 |
374330 | 374330 | 2020-07-27 | Eaton | Michigan | 26045 | 421 | 7 |
374331 | 374331 | 2020-07-27 | Emmet | Michigan | 26047 | 53 | 2 |
374332 | 374332 | 2020-07-27 | Genesee | Michigan | 26049 | 3327 | 294 |
374333 | 374333 | 2020-07-27 | Gladwin | Michigan | 26051 | 37 | 2 |
374334 | 374334 | 2020-07-27 | Gogebic | Michigan | 26053 | 62 | 1 |
374335 | 374335 | 2020-07-27 | Grand Traverse | Michigan | 26055 | 168 | 5 |
374336 | 374336 | 2020-07-27 | Gratiot | Michigan | 26057 | 140 | 15 |
374337 | 374337 | 2020-07-27 | Hillsdale | Michigan | 26059 | 230 | 25 |
374338 | 374338 | 2020-07-27 | Houghton | Michigan | 26061 | 43 | 0 |
374339 | 374339 | 2020-07-27 | Huron | Michigan | 26063 | 133 | 3 |
374340 | 374340 | 2020-07-27 | Ingham | Michigan | 26065 | 1398 | 29 |
374341 | 374341 | 2020-07-27 | Ionia | Michigan | 26067 | 260 | 5 |
374342 | 374342 | 2020-07-27 | Iosco | Michigan | 26069 | 124 | 11 |
374343 | 374343 | 2020-07-27 | Iron | Michigan | 26071 | 13 | 1 |
374344 | 374344 | 2020-07-27 | Isabella | Michigan | 26073 | 194 | 8 |
374345 | 374345 | 2020-07-27 | Jackson | Michigan | 26075 | 2351 | 54 |
374346 | 374346 | 2020-07-27 | Kalamazoo | Michigan | 26077 | 1449 | 78 |
374347 | 374347 | 2020-07-27 | Kalkaska | Michigan | 26079 | 49 | 4 |
374348 | 374348 | 2020-07-27 | Kent | Michigan | 26081 | 6829 | 152 |
374349 | 374349 | 2020-07-27 | Keweenaw | Michigan | 26083 | 2 | 0 |
374350 | 374350 | 2020-07-27 | Lake | Michigan | 26085 | 16 | 0 |
374351 | 374351 | 2020-07-27 | Lapeer | Michigan | 26087 | 697 | 39 |
374352 | 374352 | 2020-07-27 | Leelanau | Michigan | 26089 | 63 | 0 |
374353 | 374353 | 2020-07-27 | Lenawee | Michigan | 26091 | 1096 | 15 |
374354 | 374354 | 2020-07-27 | Livingston | Michigan | 26093 | 767 | 29 |
374355 | 374355 | 2020-07-27 | Luce | Michigan | 26095 | 4 | 0 |
374356 | 374356 | 2020-07-27 | Mackinac | Michigan | 26097 | 16 | 0 |
374357 | 374357 | 2020-07-27 | Macomb | Michigan | 26099 | 9224 | 942 |
374358 | 374358 | 2020-07-27 | Manistee | Michigan | 26101 | 43 | 0 |
374359 | 374359 | 2020-07-27 | Marquette | Michigan | 26103 | 115 | 11 |
374360 | 374360 | 2020-07-27 | Mason | Michigan | 26105 | 94 | 0 |
374361 | 374361 | 2020-07-27 | Mecosta | Michigan | 26107 | 50 | 2 |
374362 | 374362 | 2020-07-27 | Menominee | Michigan | 26109 | 73 | 0 |
374363 | 374363 | 2020-07-27 | Midland | Michigan | 26111 | 270 | 9 |
374364 | 374364 | 2020-07-27 | Missaukee | Michigan | 26113 | 40 | 1 |
374365 | 374365 | 2020-07-27 | Monroe | Michigan | 26115 | 803 | 21 |
374366 | 374366 | 2020-07-27 | Montcalm | Michigan | 26117 | 174 | 1 |
374367 | 374367 | 2020-07-27 | Montmorency | Michigan | 26119 | 7 | 0 |
374368 | 374368 | 2020-07-27 | Muskegon | Michigan | 26121 | 1089 | 56 |
374369 | 374369 | 2020-07-27 | Newaygo | Michigan | 26123 | 243 | 0 |
374370 | 374370 | 2020-07-27 | Oakland | Michigan | 26125 | 14111 | 1127 |
374371 | 374371 | 2020-07-27 | Oceana | Michigan | 26127 | 459 | 5 |
374372 | 374372 | 2020-07-27 | Ogemaw | Michigan | 26129 | 50 | 2 |
374373 | 374373 | 2020-07-27 | Ontonagon | Michigan | 26131 | 3 | 0 |
374374 | 374374 | 2020-07-27 | Osceola | Michigan | 26133 | 64 | 0 |
374375 | 374375 | 2020-07-27 | Oscoda | Michigan | 26135 | 23 | 1 |
374376 | 374376 | 2020-07-27 | Otsego | Michigan | 26137 | 140 | 10 |
374377 | 374377 | 2020-07-27 | Ottawa | Michigan | 26139 | 1622 | 53 |
374378 | 374378 | 2020-07-27 | Presque Isle | Michigan | 26141 | 14 | 1 |
374379 | 374379 | 2020-07-27 | Roscommon | Michigan | 26143 | 45 | 0 |
374380 | 374380 | 2020-07-27 | Saginaw | Michigan | 26145 | 1759 | 124 |
374381 | 374381 | 2020-07-27 | Sanilac | Michigan | 26151 | 88 | 6 |
374382 | 374382 | 2020-07-27 | Schoolcraft | Michigan | 26153 | 8 | 0 |
374383 | 374383 | 2020-07-27 | Shiawassee | Michigan | 26155 | 301 | 28 |
374384 | 374384 | 2020-07-27 | St. Clair | Michigan | 26147 | 710 | 53 |
374385 | 374385 | 2020-07-27 | St. Joseph | Michigan | 26149 | 528 | 6 |
374386 | 374386 | 2020-07-27 | Tuscola | Michigan | 26157 | 276 | 27 |
374387 | 374387 | 2020-07-27 | Unknown | Michigan | 13 | 2 | |
374388 | 374388 | 2020-07-27 | Van Buren | Michigan | 26159 | 364 | 11 |
374389 | 374389 | 2020-07-27 | Washtenaw | Michigan | 26161 | 2797 | 119 |
374390 | 374390 | 2020-07-27 | Wayne | Michigan | 26163 | 26186 | 2785 |
374391 | 374391 | 2020-07-27 | Wexford | Michigan | 26165 | 65 | 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);