ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where cases = 24 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Manistee 18
- Oscoda 16
- Mecosta 12
- Missaukee 11
- Alcona 7
- Roscommon 7
- Antrim 4
- Clare 4
- Presque Isle 4
- Chippewa 3
- Montcalm 3
- Alger 2
- Benzie 2
- Kalamazoo 2
- Lenawee 2
- Montmorency 2
- Schoolcraft 2
- Shiawassee 2
- Arenac 1
- Bay 1
- Branch 1
- Clinton 1
- Delta 1
- Hillsdale 1
- Huron 1
- Ionia 1
- Iron 1
- Keweenaw 1
- Leelanau 1
- Mackinac 1
- …
state 1
- Michigan · 125 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
701052 | 701052 | 2020-11-05 | Keweenaw | Michigan | 26083 | 24 | 1 |
665394 | 665394 | 2020-10-25 | Montmorency | Michigan | 26119 | 24 | 0 |
662149 | 662149 | 2020-10-24 | Montmorency | Michigan | 26119 | 24 | 0 |
597213 | 597213 | 2020-10-04 | Alger | Michigan | 26003 | 24 | 0 |
593972 | 593972 | 2020-10-03 | Alger | Michigan | 26003 | 24 | 0 |
564875 | 564875 | 2020-09-24 | Schoolcraft | Michigan | 26153 | 24 | 0 |
561635 | 561635 | 2020-09-23 | Schoolcraft | Michigan | 26153 | 24 | 0 |
542205 | 542205 | 2020-09-17 | Presque Isle | Michigan | 26141 | 24 | 1 |
538969 | 538969 | 2020-09-16 | Presque Isle | Michigan | 26141 | 24 | 1 |
535732 | 535732 | 2020-09-15 | Presque Isle | Michigan | 26141 | 24 | 1 |
532497 | 532497 | 2020-09-14 | Presque Isle | Michigan | 26141 | 24 | 1 |
441963 | 441963 | 2020-08-17 | Iron | Michigan | 26071 | 24 | 1 |
429090 | 429090 | 2020-08-13 | Oscoda | Michigan | 26135 | 24 | 1 |
425866 | 425866 | 2020-08-12 | Oscoda | Michigan | 26135 | 24 | 1 |
422644 | 422644 | 2020-08-11 | Oscoda | Michigan | 26135 | 24 | 1 |
419422 | 419422 | 2020-08-10 | Oscoda | Michigan | 26135 | 24 | 1 |
416201 | 416201 | 2020-08-09 | Oscoda | Michigan | 26135 | 24 | 1 |
412981 | 412981 | 2020-08-08 | Oscoda | Michigan | 26135 | 24 | 1 |
409761 | 409761 | 2020-08-07 | Oscoda | Michigan | 26135 | 24 | 1 |
406522 | 406522 | 2020-08-06 | Mackinac | Michigan | 26097 | 24 | 0 |
406541 | 406541 | 2020-08-06 | Oscoda | Michigan | 26135 | 24 | 1 |
403323 | 403323 | 2020-08-05 | Oscoda | Michigan | 26135 | 24 | 1 |
400106 | 400106 | 2020-08-04 | Oscoda | Michigan | 26135 | 24 | 1 |
396892 | 396892 | 2020-08-03 | Oscoda | Michigan | 26135 | 24 | 1 |
393676 | 393676 | 2020-08-02 | Oscoda | Michigan | 26135 | 24 | 1 |
390459 | 390459 | 2020-08-01 | Oscoda | Michigan | 26135 | 24 | 1 |
387242 | 387242 | 2020-07-31 | Oscoda | Michigan | 26135 | 24 | 1 |
384024 | 384024 | 2020-07-30 | Oscoda | Michigan | 26135 | 24 | 1 |
380807 | 380807 | 2020-07-29 | Oscoda | Michigan | 26135 | 24 | 1 |
358276 | 358276 | 2020-07-22 | Benzie | Michigan | 26019 | 24 | 1 |
355073 | 355073 | 2020-07-21 | Benzie | Michigan | 26019 | 24 | 1 |
342277 | 342277 | 2020-07-17 | Chippewa | Michigan | 26033 | 24 | 0 |
339065 | 339065 | 2020-07-16 | Alcona | Michigan | 26001 | 24 | 1 |
339081 | 339081 | 2020-07-16 | Chippewa | Michigan | 26033 | 24 | 0 |
335885 | 335885 | 2020-07-15 | Chippewa | Michigan | 26033 | 24 | 0 |
332676 | 332676 | 2020-07-14 | Alcona | Michigan | 26001 | 24 | 1 |
329489 | 329489 | 2020-07-13 | Alcona | Michigan | 26001 | 24 | 1 |
326303 | 326303 | 2020-07-12 | Alcona | Michigan | 26001 | 24 | 1 |
323120 | 323120 | 2020-07-11 | Alcona | Michigan | 26001 | 24 | 1 |
323124 | 323124 | 2020-07-11 | Antrim | Michigan | 26009 | 24 | 0 |
319941 | 319941 | 2020-07-10 | Alcona | Michigan | 26001 | 24 | 1 |
319945 | 319945 | 2020-07-10 | Antrim | Michigan | 26009 | 24 | 0 |
316766 | 316766 | 2020-07-09 | Alcona | Michigan | 26001 | 24 | 1 |
316770 | 316770 | 2020-07-09 | Antrim | Michigan | 26009 | 24 | 0 |
313596 | 313596 | 2020-07-08 | Antrim | Michigan | 26009 | 24 | 0 |
307308 | 307308 | 2020-07-06 | Menominee | Michigan | 26109 | 24 | 0 |
300967 | 300967 | 2020-07-04 | Leelanau | Michigan | 26089 | 24 | 0 |
291469 | 291469 | 2020-07-01 | Delta | Michigan | 26041 | 24 | 3 |
278937 | 278937 | 2020-06-27 | Wexford | Michigan | 26165 | 24 | 3 |
272620 | 272620 | 2020-06-25 | Missaukee | Michigan | 26113 | 24 | 1 |
269483 | 269483 | 2020-06-24 | Missaukee | Michigan | 26113 | 24 | 1 |
266350 | 266350 | 2020-06-23 | Missaukee | Michigan | 26113 | 24 | 1 |
263224 | 263224 | 2020-06-22 | Missaukee | Michigan | 26113 | 24 | 1 |
260095 | 260095 | 2020-06-21 | Missaukee | Michigan | 26113 | 24 | 1 |
256969 | 256969 | 2020-06-20 | Missaukee | Michigan | 26113 | 24 | 1 |
253849 | 253849 | 2020-06-19 | Missaukee | Michigan | 26113 | 24 | 1 |
250728 | 250728 | 2020-06-18 | Manistee | Michigan | 26101 | 24 | 1 |
250734 | 250734 | 2020-06-18 | Missaukee | Michigan | 26113 | 24 | 1 |
247616 | 247616 | 2020-06-17 | Manistee | Michigan | 26101 | 24 | 1 |
247622 | 247622 | 2020-06-17 | Missaukee | Michigan | 26113 | 24 | 1 |
244503 | 244503 | 2020-06-16 | Manistee | Michigan | 26101 | 24 | 1 |
244509 | 244509 | 2020-06-16 | Missaukee | Michigan | 26113 | 24 | 1 |
241392 | 241392 | 2020-06-15 | Manistee | Michigan | 26101 | 24 | 1 |
241398 | 241398 | 2020-06-15 | Missaukee | Michigan | 26113 | 24 | 1 |
238283 | 238283 | 2020-06-14 | Manistee | Michigan | 26101 | 24 | 1 |
235143 | 235143 | 2020-06-13 | Clare | Michigan | 26035 | 24 | 2 |
235176 | 235176 | 2020-06-13 | Manistee | Michigan | 26101 | 24 | 1 |
232038 | 232038 | 2020-06-12 | Clare | Michigan | 26035 | 24 | 2 |
232071 | 232071 | 2020-06-12 | Manistee | Michigan | 26101 | 24 | 1 |
232074 | 232074 | 2020-06-12 | Mecosta | Michigan | 26107 | 24 | 2 |
228934 | 228934 | 2020-06-11 | Clare | Michigan | 26035 | 24 | 2 |
228967 | 228967 | 2020-06-11 | Manistee | Michigan | 26101 | 24 | 1 |
228970 | 228970 | 2020-06-11 | Mecosta | Michigan | 26107 | 24 | 2 |
228987 | 228987 | 2020-06-11 | Roscommon | Michigan | 26143 | 24 | 0 |
225832 | 225832 | 2020-06-10 | Clare | Michigan | 26035 | 24 | 2 |
225865 | 225865 | 2020-06-10 | Manistee | Michigan | 26101 | 24 | 1 |
225868 | 225868 | 2020-06-10 | Mecosta | Michigan | 26107 | 24 | 2 |
225885 | 225885 | 2020-06-10 | Roscommon | Michigan | 26143 | 24 | 0 |
222767 | 222767 | 2020-06-09 | Manistee | Michigan | 26101 | 24 | 1 |
222770 | 222770 | 2020-06-09 | Mecosta | Michigan | 26107 | 24 | 2 |
222787 | 222787 | 2020-06-09 | Roscommon | Michigan | 26143 | 24 | 0 |
219672 | 219672 | 2020-06-08 | Manistee | Michigan | 26101 | 24 | 1 |
219675 | 219675 | 2020-06-08 | Mecosta | Michigan | 26107 | 24 | 2 |
219692 | 219692 | 2020-06-08 | Roscommon | Michigan | 26143 | 24 | 0 |
216580 | 216580 | 2020-06-07 | Manistee | Michigan | 26101 | 24 | 1 |
216583 | 216583 | 2020-06-07 | Mecosta | Michigan | 26107 | 24 | 2 |
216600 | 216600 | 2020-06-07 | Roscommon | Michigan | 26143 | 24 | 0 |
213492 | 213492 | 2020-06-06 | Manistee | Michigan | 26101 | 24 | 1 |
213495 | 213495 | 2020-06-06 | Mecosta | Michigan | 26107 | 24 | 2 |
213512 | 213512 | 2020-06-06 | Roscommon | Michigan | 26143 | 24 | 0 |
210408 | 210408 | 2020-06-05 | Manistee | Michigan | 26101 | 24 | 1 |
210411 | 210411 | 2020-06-05 | Mecosta | Michigan | 26107 | 24 | 2 |
210428 | 210428 | 2020-06-05 | Roscommon | Michigan | 26143 | 24 | 0 |
207327 | 207327 | 2020-06-04 | Manistee | Michigan | 26101 | 24 | 0 |
207330 | 207330 | 2020-06-04 | Mecosta | Michigan | 26107 | 24 | 2 |
204246 | 204246 | 2020-06-03 | Manistee | Michigan | 26101 | 24 | 0 |
204249 | 204249 | 2020-06-03 | Mecosta | Michigan | 26107 | 24 | 2 |
201169 | 201169 | 2020-06-02 | Manistee | Michigan | 26101 | 24 | 0 |
201172 | 201172 | 2020-06-02 | Mecosta | Michigan | 26107 | 24 | 2 |
198096 | 198096 | 2020-06-01 | Manistee | Michigan | 26101 | 24 | 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);