ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where date = "2020-06-25" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
272564 | 272564 | 2020-06-25 | Alcona | Michigan | 26001 | 21 | 1 |
272565 | 272565 | 2020-06-25 | Alger | Michigan | 26003 | 2 | 0 |
272566 | 272566 | 2020-06-25 | Allegan | Michigan | 26005 | 301 | 6 |
272567 | 272567 | 2020-06-25 | Alpena | Michigan | 26007 | 117 | 12 |
272568 | 272568 | 2020-06-25 | Antrim | Michigan | 26009 | 18 | 0 |
272569 | 272569 | 2020-06-25 | Arenac | Michigan | 26011 | 38 | 2 |
272570 | 272570 | 2020-06-25 | Baraga | Michigan | 26013 | 1 | 0 |
272571 | 272571 | 2020-06-25 | Barry | Michigan | 26015 | 95 | 2 |
272572 | 272572 | 2020-06-25 | Bay | Michigan | 26017 | 383 | 30 |
272573 | 272573 | 2020-06-25 | Benzie | Michigan | 26019 | 6 | 0 |
272574 | 272574 | 2020-06-25 | Berrien | Michigan | 26021 | 922 | 60 |
272575 | 272575 | 2020-06-25 | Branch | Michigan | 26023 | 1047 | 25 |
272576 | 272576 | 2020-06-25 | Calhoun | Michigan | 26025 | 517 | 32 |
272577 | 272577 | 2020-06-25 | Cass | Michigan | 26027 | 131 | 4 |
272578 | 272578 | 2020-06-25 | Charlevoix | Michigan | 26029 | 29 | 2 |
272579 | 272579 | 2020-06-25 | Cheboygan | Michigan | 26031 | 27 | 2 |
272580 | 272580 | 2020-06-25 | Chippewa | Michigan | 26033 | 4 | 0 |
272581 | 272581 | 2020-06-25 | Clare | Michigan | 26035 | 27 | 3 |
272582 | 272582 | 2020-06-25 | Clinton | Michigan | 26037 | 207 | 12 |
272583 | 272583 | 2020-06-25 | Crawford | Michigan | 26039 | 68 | 5 |
272584 | 272584 | 2020-06-25 | Delta | Michigan | 26041 | 22 | 2 |
272585 | 272585 | 2020-06-25 | Dickinson | Michigan | 26043 | 7 | 2 |
272586 | 272586 | 2020-06-25 | Eaton | Michigan | 26045 | 297 | 7 |
272587 | 272587 | 2020-06-25 | Emmet | Michigan | 26047 | 27 | 2 |
272588 | 272588 | 2020-06-25 | Genesee | Michigan | 26049 | 2669 | 285 |
272589 | 272589 | 2020-06-25 | Gladwin | Michigan | 26051 | 26 | 1 |
272590 | 272590 | 2020-06-25 | Gogebic | Michigan | 26053 | 6 | 1 |
272591 | 272591 | 2020-06-25 | Grand Traverse | Michigan | 26055 | 44 | 5 |
272592 | 272592 | 2020-06-25 | Gratiot | Michigan | 26057 | 98 | 13 |
272593 | 272593 | 2020-06-25 | Hillsdale | Michigan | 26059 | 192 | 25 |
272594 | 272594 | 2020-06-25 | Houghton | Michigan | 26061 | 11 | 0 |
272595 | 272595 | 2020-06-25 | Huron | Michigan | 26063 | 64 | 3 |
272596 | 272596 | 2020-06-25 | Ingham | Michigan | 26065 | 916 | 29 |
272597 | 272597 | 2020-06-25 | Ionia | Michigan | 26067 | 197 | 4 |
272598 | 272598 | 2020-06-25 | Iosco | Michigan | 26069 | 112 | 10 |
272599 | 272599 | 2020-06-25 | Iron | Michigan | 26071 | 5 | 0 |
272600 | 272600 | 2020-06-25 | Isabella | Michigan | 26073 | 120 | 8 |
272601 | 272601 | 2020-06-25 | Jackson | Michigan | 26075 | 2056 | 52 |
272602 | 272602 | 2020-06-25 | Kalamazoo | Michigan | 26077 | 1042 | 67 |
272603 | 272603 | 2020-06-25 | Kalkaska | Michigan | 26079 | 31 | 2 |
272604 | 272604 | 2020-06-25 | Kent | Michigan | 26081 | 4723 | 130 |
272605 | 272605 | 2020-06-25 | Keweenaw | Michigan | 26083 | 1 | 0 |
272606 | 272606 | 2020-06-25 | Lake | Michigan | 26085 | 7 | 0 |
272607 | 272607 | 2020-06-25 | Lapeer | Michigan | 26087 | 567 | 38 |
272608 | 272608 | 2020-06-25 | Leelanau | Michigan | 26089 | 20 | 0 |
272609 | 272609 | 2020-06-25 | Lenawee | Michigan | 26091 | 933 | 10 |
272610 | 272610 | 2020-06-25 | Livingston | Michigan | 26093 | 599 | 29 |
272611 | 272611 | 2020-06-25 | Luce | Michigan | 26095 | 4 | 0 |
272612 | 272612 | 2020-06-25 | Mackinac | Michigan | 26097 | 8 | 0 |
272613 | 272613 | 2020-06-25 | Macomb | Michigan | 26099 | 7464 | 905 |
272614 | 272614 | 2020-06-25 | Manistee | Michigan | 26101 | 28 | 0 |
272615 | 272615 | 2020-06-25 | Marquette | Michigan | 26103 | 63 | 11 |
272616 | 272616 | 2020-06-25 | Mason | Michigan | 26105 | 43 | 0 |
272617 | 272617 | 2020-06-25 | Mecosta | Michigan | 26107 | 29 | 2 |
272618 | 272618 | 2020-06-25 | Menominee | Michigan | 26109 | 14 | 0 |
272619 | 272619 | 2020-06-25 | Midland | Michigan | 26111 | 161 | 9 |
272620 | 272620 | 2020-06-25 | Missaukee | Michigan | 26113 | 24 | 1 |
272621 | 272621 | 2020-06-25 | Monroe | Michigan | 26115 | 591 | 21 |
272622 | 272622 | 2020-06-25 | Montcalm | Michigan | 26117 | 85 | 1 |
272623 | 272623 | 2020-06-25 | Montmorency | Michigan | 26119 | 5 | 0 |
272624 | 272624 | 2020-06-25 | Muskegon | Michigan | 26121 | 796 | 49 |
272625 | 272625 | 2020-06-25 | Newaygo | Michigan | 26123 | 162 | 0 |
272626 | 272626 | 2020-06-25 | Oakland | Michigan | 26125 | 11826 | 1084 |
272627 | 272627 | 2020-06-25 | Oceana | Michigan | 26127 | 222 | 3 |
272628 | 272628 | 2020-06-25 | Ogemaw | Michigan | 26129 | 32 | 2 |
272629 | 272629 | 2020-06-25 | Osceola | Michigan | 26133 | 25 | 0 |
272630 | 272630 | 2020-06-25 | Oscoda | Michigan | 26135 | 14 | 1 |
272631 | 272631 | 2020-06-25 | Otsego | Michigan | 26137 | 133 | 10 |
272632 | 272632 | 2020-06-25 | Ottawa | Michigan | 26139 | 996 | 51 |
272633 | 272633 | 2020-06-25 | Presque Isle | Michigan | 26141 | 12 | 0 |
272634 | 272634 | 2020-06-25 | Roscommon | Michigan | 26143 | 26 | 0 |
272635 | 272635 | 2020-06-25 | Saginaw | Michigan | 26145 | 1248 | 123 |
272636 | 272636 | 2020-06-25 | Sanilac | Michigan | 26151 | 44 | 6 |
272637 | 272637 | 2020-06-25 | Schoolcraft | Michigan | 26153 | 4 | 0 |
272638 | 272638 | 2020-06-25 | Shiawassee | Michigan | 26155 | 268 | 27 |
272639 | 272639 | 2020-06-25 | St. Clair | Michigan | 26147 | 538 | 49 |
272640 | 272640 | 2020-06-25 | St. Joseph | Michigan | 26149 | 255 | 3 |
272641 | 272641 | 2020-06-25 | Tuscola | Michigan | 26157 | 229 | 26 |
272642 | 272642 | 2020-06-25 | Unknown | Michigan | 192 | 2 | |
272643 | 272643 | 2020-06-25 | Van Buren | Michigan | 26159 | 224 | 7 |
272644 | 272644 | 2020-06-25 | Washtenaw | Michigan | 26161 | 2142 | 113 |
272645 | 272645 | 2020-06-25 | Wayne | Michigan | 26163 | 22476 | 2705 |
272646 | 272646 | 2020-06-25 | Wexford | Michigan | 26165 | 23 | 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);