ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where cases = 28 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
714025 | 714025 | 2020-11-09 | Keweenaw | Michigan | 26083 | 28 | 1 |
607010 | 607010 | 2020-10-07 | Presque Isle | Michigan | 26141 | 28 | 1 |
603767 | 603767 | 2020-10-06 | Presque Isle | Michigan | 26141 | 28 | 1 |
480713 | 480713 | 2020-08-29 | Iron | Michigan | 26071 | 28 | 1 |
448428 | 448428 | 2020-08-19 | Mackinac | Michigan | 26097 | 28 | 0 |
445202 | 445202 | 2020-08-18 | Mackinac | Michigan | 26097 | 28 | 0 |
435518 | 435518 | 2020-08-15 | Lake | Michigan | 26085 | 28 | 0 |
432292 | 432292 | 2020-08-14 | Lake | Michigan | 26085 | 28 | 0 |
416143 | 416143 | 2020-08-09 | Benzie | Michigan | 26019 | 28 | 1 |
412914 | 412914 | 2020-08-08 | Alcona | Michigan | 26001 | 28 | 1 |
412923 | 412923 | 2020-08-08 | Benzie | Michigan | 26019 | 28 | 1 |
409694 | 409694 | 2020-08-07 | Alcona | Michigan | 26001 | 28 | 1 |
406474 | 406474 | 2020-08-06 | Alcona | Michigan | 26001 | 28 | 1 |
406483 | 406483 | 2020-08-06 | Benzie | Michigan | 26019 | 28 | 1 |
403256 | 403256 | 2020-08-05 | Alcona | Michigan | 26001 | 28 | 1 |
400039 | 400039 | 2020-08-04 | Alcona | Michigan | 26001 | 28 | 1 |
400048 | 400048 | 2020-08-04 | Benzie | Michigan | 26019 | 28 | 1 |
396825 | 396825 | 2020-08-03 | Alcona | Michigan | 26001 | 28 | 1 |
396834 | 396834 | 2020-08-03 | Benzie | Michigan | 26019 | 28 | 1 |
393609 | 393609 | 2020-08-02 | Alcona | Michigan | 26001 | 28 | 1 |
393618 | 393618 | 2020-08-02 | Benzie | Michigan | 26019 | 28 | 1 |
390392 | 390392 | 2020-08-01 | Alcona | Michigan | 26001 | 28 | 1 |
390401 | 390401 | 2020-08-01 | Benzie | Michigan | 26019 | 28 | 1 |
387175 | 387175 | 2020-07-31 | Alcona | Michigan | 26001 | 28 | 1 |
383957 | 383957 | 2020-07-30 | Alcona | Michigan | 26001 | 28 | 1 |
383966 | 383966 | 2020-07-30 | Benzie | Michigan | 26019 | 28 | 1 |
383973 | 383973 | 2020-07-30 | Chippewa | Michigan | 26033 | 28 | 0 |
380740 | 380740 | 2020-07-29 | Alcona | Michigan | 26001 | 28 | 1 |
380756 | 380756 | 2020-07-29 | Chippewa | Michigan | 26033 | 28 | 0 |
377539 | 377539 | 2020-07-28 | Chippewa | Michigan | 26033 | 28 | 0 |
371096 | 371096 | 2020-07-26 | Alcona | Michigan | 26001 | 28 | 1 |
371105 | 371105 | 2020-07-26 | Benzie | Michigan | 26019 | 28 | 1 |
367895 | 367895 | 2020-07-25 | Benzie | Michigan | 26019 | 28 | 1 |
361481 | 361481 | 2020-07-23 | Benzie | Michigan | 26019 | 28 | 1 |
332701 | 332701 | 2020-07-14 | Gladwin | Michigan | 26051 | 28 | 1 |
329514 | 329514 | 2020-07-13 | Gladwin | Michigan | 26051 | 28 | 1 |
323135 | 323135 | 2020-07-11 | Cheboygan | Michigan | 26031 | 28 | 2 |
313617 | 313617 | 2020-07-08 | Gladwin | Michigan | 26051 | 28 | 1 |
310437 | 310437 | 2020-07-07 | Cheboygan | Michigan | 26031 | 28 | 2 |
307269 | 307269 | 2020-07-06 | Cheboygan | Michigan | 26031 | 28 | 2 |
307325 | 307325 | 2020-07-06 | Roscommon | Michigan | 26143 | 28 | 0 |
304158 | 304158 | 2020-07-05 | Roscommon | Michigan | 26143 | 28 | 0 |
300994 | 300994 | 2020-07-04 | Roscommon | Michigan | 26143 | 28 | 0 |
297831 | 297831 | 2020-07-03 | Roscommon | Michigan | 26143 | 28 | 0 |
294673 | 294673 | 2020-07-02 | Roscommon | Michigan | 26143 | 28 | 0 |
291466 | 291466 | 2020-07-01 | Clare | Michigan | 26035 | 28 | 3 |
291519 | 291519 | 2020-07-01 | Roscommon | Michigan | 26143 | 28 | 0 |
288315 | 288315 | 2020-06-30 | Clare | Michigan | 26035 | 28 | 3 |
282053 | 282053 | 2020-06-28 | Manistee | Michigan | 26101 | 28 | 0 |
282059 | 282059 | 2020-06-28 | Missaukee | Michigan | 26113 | 28 | 1 |
278870 | 278870 | 2020-06-27 | Cheboygan | Michigan | 26031 | 28 | 2 |
278905 | 278905 | 2020-06-27 | Manistee | Michigan | 26101 | 28 | 0 |
278911 | 278911 | 2020-06-27 | Missaukee | Michigan | 26113 | 28 | 1 |
275757 | 275757 | 2020-06-26 | Manistee | Michigan | 26101 | 28 | 0 |
272614 | 272614 | 2020-06-25 | Manistee | Michigan | 26101 | 28 | 0 |
269450 | 269450 | 2020-06-24 | Emmet | Michigan | 26047 | 28 | 2 |
269477 | 269477 | 2020-06-24 | Manistee | Michigan | 26101 | 28 | 1 |
269480 | 269480 | 2020-06-24 | Mecosta | Michigan | 26107 | 28 | 2 |
266344 | 266344 | 2020-06-23 | Manistee | Michigan | 26101 | 28 | 1 |
266347 | 266347 | 2020-06-23 | Mecosta | Michigan | 26107 | 28 | 2 |
256966 | 256966 | 2020-06-20 | Mecosta | Michigan | 26107 | 28 | 2 |
250701 | 250701 | 2020-06-18 | Emmet | Michigan | 26047 | 28 | 2 |
179762 | 179762 | 2020-05-26 | Unknown | Michigan | 28 | 6 | |
161505 | 161505 | 2020-05-20 | Mason | Michigan | 26105 | 28 | 0 |
140391 | 140391 | 2020-05-13 | Arenac | Michigan | 26011 | 28 | 1 |
137397 | 137397 | 2020-05-12 | Arenac | Michigan | 26011 | 28 | 1 |
131472 | 131472 | 2020-05-10 | Oceana | Michigan | 26127 | 28 | 1 |
119511 | 119511 | 2020-05-06 | Huron | Michigan | 26063 | 28 | 1 |
113643 | 113643 | 2020-05-04 | Arenac | Michigan | 26011 | 28 | 1 |
113697 | 113697 | 2020-05-04 | Newaygo | Michigan | 26123 | 28 | 0 |
110765 | 110765 | 2020-05-03 | Arenac | Michigan | 26011 | 28 | 1 |
90884 | 90884 | 2020-04-26 | St. Joseph | Michigan | 26149 | 28 | 1 |
88001 | 88001 | 2020-04-25 | Barry | Michigan | 26015 | 28 | 1 |
85240 | 85240 | 2020-04-24 | Montcalm | Michigan | 26117 | 28 | 1 |
82387 | 82387 | 2020-04-23 | Barry | Michigan | 26015 | 28 | 1 |
82436 | 82436 | 2020-04-23 | Montcalm | Michigan | 26117 | 28 | 1 |
79592 | 79592 | 2020-04-22 | Barry | Michigan | 26015 | 28 | 1 |
76832 | 76832 | 2020-04-21 | Ionia | Michigan | 26067 | 28 | 2 |
65809 | 65809 | 2020-04-17 | Van Buren | Michigan | 26159 | 28 | 2 |
46922 | 46922 | 2020-04-10 | Midland | Michigan | 26111 | 28 | 1 |
44297 | 44297 | 2020-04-09 | Isabella | Michigan | 26073 | 28 | 2 |
44313 | 44313 | 2020-04-09 | Midland | Michigan | 26111 | 28 | 1 |
39196 | 39196 | 2020-04-07 | Otsego | Michigan | 26137 | 28 | 2 |
20562 | 20562 | 2020-03-30 | Ottawa | Michigan | 26139 | 28 | 0 |
18520 | 18520 | 2020-03-29 | Jackson | Michigan | 26075 | 28 | 1 |
14798 | 14798 | 2020-03-27 | Monroe | Michigan | 26115 | 28 | 0 |
14813 | 14813 | 2020-03-27 | Unknown | Michigan | 28 | 0 | |
8787 | 8787 | 2020-03-23 | Kent | Michigan | 26081 | 28 | 1 |
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);