ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where cases = 55 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips >30
county >30
- Kalkaska 5
- Iosco 4
- Alcona 3
- Antrim 3
- Isabella 3
- Manistee 3
- Ogemaw 3
- Dickinson 2
- Houghton 2
- Lake 2
- Mecosta 2
- Oscoda 2
- Sanilac 2
- Wexford 2
- Arenac 1
- Benzie 1
- Charlevoix 1
- Clinton 1
- Delta 1
- Eaton 1
- Emmet 1
- Gladwin 1
- Grand Traverse 1
- Gratiot 1
- Hillsdale 1
- Ionia 1
- Keweenaw 1
- Leelanau 1
- Macomb 1
- Marquette 1
- …
state 1
- Michigan · 59 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1259383 | 1259383 | 2021-04-26 | Unknown | Michigan | 55 | 17 | |
743223 | 743223 | 2020-11-18 | Keweenaw | Michigan | 26083 | 55 | 1 |
688037 | 688037 | 2020-11-01 | Alcona | Michigan | 26001 | 55 | 3 |
684793 | 684793 | 2020-10-31 | Alcona | Michigan | 26001 | 55 | 3 |
681550 | 681550 | 2020-10-30 | Alcona | Michigan | 26001 | 55 | 3 |
665402 | 665402 | 2020-10-25 | Oscoda | Michigan | 26135 | 55 | 1 |
662157 | 662157 | 2020-10-24 | Oscoda | Michigan | 26135 | 55 | 1 |
652398 | 652398 | 2020-10-21 | Lake | Michigan | 26085 | 55 | 0 |
649153 | 649153 | 2020-10-20 | Lake | Michigan | 26085 | 55 | 0 |
535718 | 535718 | 2020-09-15 | Missaukee | Michigan | 26113 | 55 | 1 |
496856 | 496856 | 2020-09-03 | Benzie | Michigan | 26019 | 55 | 2 |
483918 | 483918 | 2020-08-30 | Arenac | Michigan | 26011 | 55 | 3 |
477450 | 477450 | 2020-08-28 | Antrim | Michigan | 26009 | 55 | 0 |
474217 | 474217 | 2020-08-27 | Antrim | Michigan | 26009 | 55 | 0 |
470985 | 470985 | 2020-08-26 | Antrim | Michigan | 26009 | 55 | 0 |
467815 | 467815 | 2020-08-25 | Ogemaw | Michigan | 26129 | 55 | 3 |
464586 | 464586 | 2020-08-24 | Ogemaw | Michigan | 26129 | 55 | 3 |
448430 | 448430 | 2020-08-19 | Manistee | Michigan | 26101 | 55 | 1 |
445184 | 445184 | 2020-08-18 | Houghton | Michigan | 26061 | 55 | 0 |
445204 | 445204 | 2020-08-18 | Manistee | Michigan | 26101 | 55 | 1 |
441958 | 441958 | 2020-08-17 | Houghton | Michigan | 26061 | 55 | 0 |
441978 | 441978 | 2020-08-17 | Manistee | Michigan | 26101 | 55 | 1 |
441992 | 441992 | 2020-08-17 | Ogemaw | Michigan | 26129 | 55 | 3 |
432289 | 432289 | 2020-08-14 | Kalkaska | Michigan | 26079 | 55 | 4 |
429037 | 429037 | 2020-08-13 | Charlevoix | Michigan | 26029 | 55 | 2 |
429062 | 429062 | 2020-08-13 | Kalkaska | Michigan | 26079 | 55 | 4 |
425838 | 425838 | 2020-08-12 | Kalkaska | Michigan | 26079 | 55 | 4 |
425870 | 425870 | 2020-08-12 | Roscommon | Michigan | 26143 | 55 | 2 |
422616 | 422616 | 2020-08-11 | Kalkaska | Michigan | 26079 | 55 | 4 |
419376 | 419376 | 2020-08-10 | Dickinson | Michigan | 26043 | 55 | 2 |
419394 | 419394 | 2020-08-10 | Kalkaska | Michigan | 26079 | 55 | 4 |
416155 | 416155 | 2020-08-09 | Dickinson | Michigan | 26043 | 55 | 2 |
400064 | 400064 | 2020-08-04 | Gladwin | Michigan | 26051 | 55 | 2 |
387228 | 387228 | 2020-07-31 | Mecosta | Michigan | 26107 | 55 | 2 |
384010 | 384010 | 2020-07-30 | Mecosta | Michigan | 26107 | 55 | 2 |
377546 | 377546 | 2020-07-28 | Emmet | Michigan | 26047 | 55 | 2 |
358287 | 358287 | 2020-07-22 | Delta | Michigan | 26041 | 55 | 3 |
355108 | 355108 | 2020-07-21 | Leelanau | Michigan | 26089 | 55 | 0 |
348716 | 348716 | 2020-07-19 | Menominee | Michigan | 26109 | 55 | 0 |
316839 | 316839 | 2020-07-09 | Sanilac | Michigan | 26151 | 55 | 6 |
316849 | 316849 | 2020-07-09 | Wexford | Michigan | 26165 | 55 | 4 |
313665 | 313665 | 2020-07-08 | Sanilac | Michigan | 26151 | 55 | 6 |
313675 | 313675 | 2020-07-08 | Wexford | Michigan | 26165 | 55 | 4 |
297788 | 297788 | 2020-07-03 | Grand Traverse | Michigan | 26055 | 55 | 5 |
191958 | 191958 | 2020-05-30 | Marquette | Michigan | 26103 | 55 | 11 |
158457 | 158457 | 2020-05-19 | Gratiot | Michigan | 26057 | 55 | 4 |
140420 | 140420 | 2020-05-13 | Iosco | Michigan | 26069 | 55 | 8 |
137426 | 137426 | 2020-05-12 | Iosco | Michigan | 26069 | 55 | 8 |
134436 | 134436 | 2020-05-11 | Iosco | Michigan | 26069 | 55 | 8 |
131445 | 131445 | 2020-05-10 | Iosco | Michigan | 26069 | 55 | 8 |
96499 | 96499 | 2020-04-28 | Ionia | Michigan | 26067 | 55 | 2 |
90845 | 90845 | 2020-04-26 | Isabella | Michigan | 26073 | 55 | 7 |
88029 | 88029 | 2020-04-25 | Isabella | Michigan | 26073 | 55 | 7 |
85219 | 85219 | 2020-04-24 | Isabella | Michigan | 26073 | 55 | 7 |
41749 | 41749 | 2020-04-08 | Ottawa | Michigan | 26139 | 55 | 0 |
39163 | 39163 | 2020-04-07 | Hillsdale | Michigan | 26059 | 55 | 4 |
34185 | 34185 | 2020-04-05 | Clinton | Michigan | 26037 | 55 | 1 |
34189 | 34189 | 2020-04-05 | Eaton | Michigan | 26045 | 55 | 2 |
4752 | 4752 | 2020-03-19 | Macomb | Michigan | 26099 | 55 | 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);