ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where "date" is on date 2020-06-04 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
207279 | 207279 | 2020-06-04 | Alcona | Michigan | 26001 | 21 | 1 |
207280 | 207280 | 2020-06-04 | Allegan | Michigan | 26005 | 261 | 6 |
207281 | 207281 | 2020-06-04 | Alpena | Michigan | 26007 | 104 | 9 |
207282 | 207282 | 2020-06-04 | Antrim | Michigan | 26009 | 13 | 0 |
207283 | 207283 | 2020-06-04 | Arenac | Michigan | 26011 | 34 | 1 |
207284 | 207284 | 2020-06-04 | Baraga | Michigan | 26013 | 1 | 0 |
207285 | 207285 | 2020-06-04 | Barry | Michigan | 26015 | 65 | 2 |
207286 | 207286 | 2020-06-04 | Bay | Michigan | 26017 | 326 | 24 |
207287 | 207287 | 2020-06-04 | Benzie | Michigan | 26019 | 4 | 0 |
207288 | 207288 | 2020-06-04 | Berrien | Michigan | 26021 | 844 | 53 |
207289 | 207289 | 2020-06-04 | Branch | Michigan | 26023 | 919 | 25 |
207290 | 207290 | 2020-06-04 | Calhoun | Michigan | 26025 | 398 | 23 |
207291 | 207291 | 2020-06-04 | Cass | Michigan | 26027 | 85 | 3 |
207292 | 207292 | 2020-06-04 | Charlevoix | Michigan | 26029 | 21 | 1 |
207293 | 207293 | 2020-06-04 | Cheboygan | Michigan | 26031 | 26 | 1 |
207294 | 207294 | 2020-06-04 | Chippewa | Michigan | 26033 | 4 | 0 |
207295 | 207295 | 2020-06-04 | Clare | Michigan | 26035 | 19 | 2 |
207296 | 207296 | 2020-06-04 | Clinton | Michigan | 26037 | 142 | 11 |
207297 | 207297 | 2020-06-04 | Crawford | Michigan | 26039 | 63 | 5 |
207298 | 207298 | 2020-06-04 | Delta | Michigan | 26041 | 17 | 2 |
207299 | 207299 | 2020-06-04 | Dickinson | Michigan | 26043 | 5 | 2 |
207300 | 207300 | 2020-06-04 | Eaton | Michigan | 26045 | 192 | 6 |
207301 | 207301 | 2020-06-04 | Emmet | Michigan | 26047 | 27 | 2 |
207302 | 207302 | 2020-06-04 | Genesee | Michigan | 26049 | 2046 | 253 |
207303 | 207303 | 2020-06-04 | Gladwin | Michigan | 26051 | 18 | 1 |
207304 | 207304 | 2020-06-04 | Gogebic | Michigan | 26053 | 5 | 1 |
207305 | 207305 | 2020-06-04 | Grand Traverse | Michigan | 26055 | 34 | 5 |
207306 | 207306 | 2020-06-04 | Gratiot | Michigan | 26057 | 82 | 11 |
207307 | 207307 | 2020-06-04 | Hillsdale | Michigan | 26059 | 170 | 24 |
207308 | 207308 | 2020-06-04 | Houghton | Michigan | 26061 | 7 | 0 |
207309 | 207309 | 2020-06-04 | Huron | Michigan | 26063 | 48 | 1 |
207310 | 207310 | 2020-06-04 | Ingham | Michigan | 26065 | 755 | 27 |
207311 | 207311 | 2020-06-04 | Ionia | Michigan | 26067 | 158 | 4 |
207312 | 207312 | 2020-06-04 | Iosco | Michigan | 26069 | 111 | 9 |
207313 | 207313 | 2020-06-04 | Iron | Michigan | 26071 | 1 | 0 |
207314 | 207314 | 2020-06-04 | Isabella | Michigan | 26073 | 78 | 7 |
207315 | 207315 | 2020-06-04 | Jackson | Michigan | 26075 | 1997 | 50 |
207316 | 207316 | 2020-06-04 | Kalamazoo | Michigan | 26077 | 858 | 58 |
207317 | 207317 | 2020-06-04 | Kalkaska | Michigan | 26079 | 31 | 2 |
207318 | 207318 | 2020-06-04 | Kent | Michigan | 26081 | 3857 | 95 |
207319 | 207319 | 2020-06-04 | Lake | Michigan | 26085 | 7 | 0 |
207320 | 207320 | 2020-06-04 | Lapeer | Michigan | 26087 | 494 | 37 |
207321 | 207321 | 2020-06-04 | Leelanau | Michigan | 26089 | 11 | 0 |
207322 | 207322 | 2020-06-04 | Lenawee | Michigan | 26091 | 916 | 9 |
207323 | 207323 | 2020-06-04 | Livingston | Michigan | 26093 | 547 | 27 |
207324 | 207324 | 2020-06-04 | Luce | Michigan | 26095 | 4 | 0 |
207325 | 207325 | 2020-06-04 | Mackinac | Michigan | 26097 | 8 | 0 |
207326 | 207326 | 2020-06-04 | Macomb | Michigan | 26099 | 7026 | 833 |
207327 | 207327 | 2020-06-04 | Manistee | Michigan | 26101 | 24 | 0 |
207328 | 207328 | 2020-06-04 | Marquette | Michigan | 26103 | 56 | 11 |
207329 | 207329 | 2020-06-04 | Mason | Michigan | 26105 | 38 | 0 |
207330 | 207330 | 2020-06-04 | Mecosta | Michigan | 26107 | 24 | 2 |
207331 | 207331 | 2020-06-04 | Menominee | Michigan | 26109 | 8 | 0 |
207332 | 207332 | 2020-06-04 | Midland | Michigan | 26111 | 120 | 8 |
207333 | 207333 | 2020-06-04 | Missaukee | Michigan | 26113 | 22 | 1 |
207334 | 207334 | 2020-06-04 | Monroe | Michigan | 26115 | 474 | 20 |
207335 | 207335 | 2020-06-04 | Montcalm | Michigan | 26117 | 71 | 1 |
207336 | 207336 | 2020-06-04 | Montmorency | Michigan | 26119 | 5 | 0 |
207337 | 207337 | 2020-06-04 | Muskegon | Michigan | 26121 | 675 | 37 |
207338 | 207338 | 2020-06-04 | Newaygo | Michigan | 26123 | 118 | 0 |
207339 | 207339 | 2020-06-04 | Oakland | Michigan | 26125 | 8438 | 1006 |
207340 | 207340 | 2020-06-04 | Oceana | Michigan | 26127 | 102 | 2 |
207341 | 207341 | 2020-06-04 | Ogemaw | Michigan | 26129 | 31 | 1 |
207342 | 207342 | 2020-06-04 | Osceola | Michigan | 26133 | 12 | 0 |
207343 | 207343 | 2020-06-04 | Oscoda | Michigan | 26135 | 8 | 1 |
207344 | 207344 | 2020-06-04 | Otsego | Michigan | 26137 | 131 | 10 |
207345 | 207345 | 2020-06-04 | Ottawa | Michigan | 26139 | 889 | 44 |
207346 | 207346 | 2020-06-04 | Presque Isle | Michigan | 26141 | 11 | 0 |
207347 | 207347 | 2020-06-04 | Roscommon | Michigan | 26143 | 21 | 0 |
207348 | 207348 | 2020-06-04 | Saginaw | Michigan | 26145 | 1066 | 109 |
207349 | 207349 | 2020-06-04 | Sanilac | Michigan | 26151 | 42 | 5 |
207350 | 207350 | 2020-06-04 | Schoolcraft | Michigan | 26153 | 4 | 0 |
207351 | 207351 | 2020-06-04 | Shiawassee | Michigan | 26155 | 239 | 26 |
207352 | 207352 | 2020-06-04 | St. Clair | Michigan | 26147 | 515 | 44 |
207353 | 207353 | 2020-06-04 | St. Joseph | Michigan | 26149 | 133 | 3 |
207354 | 207354 | 2020-06-04 | Tuscola | Michigan | 26157 | 188 | 25 |
207355 | 207355 | 2020-06-04 | Unknown | Michigan | 107 | 2 | |
207356 | 207356 | 2020-06-04 | Van Buren | Michigan | 26159 | 150 | 6 |
207357 | 207357 | 2020-06-04 | Washtenaw | Michigan | 26161 | 2002 | 110 |
207358 | 207358 | 2020-06-04 | Wayne | Michigan | 26163 | 20613 | 2494 |
207359 | 207359 | 2020-06-04 | Wexford | Michigan | 26165 | 18 | 3 |
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);