ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65,202 rows where state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Oakland 110
- Wayne 110
- Ingham 108
- Kent 108
- Montcalm 108
- St. Clair 108
- Washtenaw 108
- Leelanau 107
- Macomb 107
- Bay 106
- Charlevoix 106
- Monroe 106
- Ottawa 105
- Jackson 103
- Otsego 103
- Clinton 101
- Eaton 101
- Genesee 101
- Livingston 101
- Midland 101
- Clare 99
- Saginaw 99
- Tuscola 99
- Wexford 99
- Allegan 98
- Barry 98
- Berrien 98
- Calhoun 98
- Emmet 98
- Gladwin 98
- …
state 1
- Michigan · 7,651 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
278872 | 278872 | 2020-06-27 | Clare | Michigan | 26035 | 27 | 3 |
278873 | 278873 | 2020-06-27 | Clinton | Michigan | 26037 | 215 | 12 |
278874 | 278874 | 2020-06-27 | Crawford | Michigan | 26039 | 68 | 5 |
278875 | 278875 | 2020-06-27 | Delta | Michigan | 26041 | 21 | 3 |
278876 | 278876 | 2020-06-27 | Dickinson | Michigan | 26043 | 7 | 2 |
278877 | 278877 | 2020-06-27 | Eaton | Michigan | 26045 | 311 | 7 |
278878 | 278878 | 2020-06-27 | Emmet | Michigan | 26047 | 27 | 2 |
278879 | 278879 | 2020-06-27 | Genesee | Michigan | 26049 | 2683 | 288 |
278880 | 278880 | 2020-06-27 | Gladwin | Michigan | 26051 | 26 | 1 |
278881 | 278881 | 2020-06-27 | Gogebic | Michigan | 26053 | 7 | 1 |
278882 | 278882 | 2020-06-27 | Grand Traverse | Michigan | 26055 | 46 | 5 |
278883 | 278883 | 2020-06-27 | Gratiot | Michigan | 26057 | 98 | 13 |
278884 | 278884 | 2020-06-27 | Hillsdale | Michigan | 26059 | 192 | 25 |
278885 | 278885 | 2020-06-27 | Houghton | Michigan | 26061 | 11 | 0 |
278886 | 278886 | 2020-06-27 | Huron | Michigan | 26063 | 65 | 3 |
278887 | 278887 | 2020-06-27 | Ingham | Michigan | 26065 | 980 | 29 |
278888 | 278888 | 2020-06-27 | Ionia | Michigan | 26067 | 197 | 4 |
278889 | 278889 | 2020-06-27 | Iosco | Michigan | 26069 | 112 | 10 |
278890 | 278890 | 2020-06-27 | Iron | Michigan | 26071 | 5 | 1 |
278891 | 278891 | 2020-06-27 | Isabella | Michigan | 26073 | 121 | 8 |
278892 | 278892 | 2020-06-27 | Jackson | Michigan | 26075 | 2082 | 52 |
278893 | 278893 | 2020-06-27 | Kalamazoo | Michigan | 26077 | 1055 | 67 |
278894 | 278894 | 2020-06-27 | Kalkaska | Michigan | 26079 | 32 | 2 |
278895 | 278895 | 2020-06-27 | Kent | Michigan | 26081 | 4822 | 132 |
278896 | 278896 | 2020-06-27 | Keweenaw | Michigan | 26083 | 1 | 0 |
278897 | 278897 | 2020-06-27 | Lake | Michigan | 26085 | 7 | 0 |
278898 | 278898 | 2020-06-27 | Lapeer | Michigan | 26087 | 595 | 38 |
278899 | 278899 | 2020-06-27 | Leelanau | Michigan | 26089 | 16 | 0 |
278900 | 278900 | 2020-06-27 | Lenawee | Michigan | 26091 | 938 | 10 |
278901 | 278901 | 2020-06-27 | Livingston | Michigan | 26093 | 602 | 29 |
278902 | 278902 | 2020-06-27 | Luce | Michigan | 26095 | 4 | 0 |
278903 | 278903 | 2020-06-27 | Mackinac | Michigan | 26097 | 8 | 0 |
278904 | 278904 | 2020-06-27 | Macomb | Michigan | 26099 | 7511 | 910 |
278905 | 278905 | 2020-06-27 | Manistee | Michigan | 26101 | 28 | 0 |
278906 | 278906 | 2020-06-27 | Marquette | Michigan | 26103 | 64 | 11 |
278907 | 278907 | 2020-06-27 | Mason | Michigan | 26105 | 45 | 0 |
278908 | 278908 | 2020-06-27 | Mecosta | Michigan | 26107 | 29 | 2 |
278909 | 278909 | 2020-06-27 | Menominee | Michigan | 26109 | 15 | 0 |
278910 | 278910 | 2020-06-27 | Midland | Michigan | 26111 | 160 | 9 |
278911 | 278911 | 2020-06-27 | Missaukee | Michigan | 26113 | 28 | 1 |
278912 | 278912 | 2020-06-27 | Monroe | Michigan | 26115 | 602 | 21 |
278913 | 278913 | 2020-06-27 | Montcalm | Michigan | 26117 | 88 | 1 |
278914 | 278914 | 2020-06-27 | Montmorency | Michigan | 26119 | 5 | 0 |
278915 | 278915 | 2020-06-27 | Muskegon | Michigan | 26121 | 806 | 50 |
278916 | 278916 | 2020-06-27 | Newaygo | Michigan | 26123 | 163 | 0 |
278917 | 278917 | 2020-06-27 | Oakland | Michigan | 26125 | 11886 | 1085 |
278918 | 278918 | 2020-06-27 | Oceana | Michigan | 26127 | 249 | 3 |
278919 | 278919 | 2020-06-27 | Ogemaw | Michigan | 26129 | 32 | 2 |
278920 | 278920 | 2020-06-27 | Osceola | Michigan | 26133 | 26 | 0 |
278921 | 278921 | 2020-06-27 | Oscoda | Michigan | 26135 | 14 | 1 |
278922 | 278922 | 2020-06-27 | Otsego | Michigan | 26137 | 133 | 10 |
278923 | 278923 | 2020-06-27 | Ottawa | Michigan | 26139 | 1020 | 51 |
278924 | 278924 | 2020-06-27 | Presque Isle | Michigan | 26141 | 12 | 0 |
278925 | 278925 | 2020-06-27 | Roscommon | Michigan | 26143 | 26 | 0 |
278926 | 278926 | 2020-06-27 | Saginaw | Michigan | 26145 | 1261 | 123 |
278927 | 278927 | 2020-06-27 | Sanilac | Michigan | 26151 | 44 | 6 |
278928 | 278928 | 2020-06-27 | Schoolcraft | Michigan | 26153 | 4 | 0 |
278929 | 278929 | 2020-06-27 | Shiawassee | Michigan | 26155 | 269 | 27 |
278930 | 278930 | 2020-06-27 | St. Clair | Michigan | 26147 | 547 | 49 |
278931 | 278931 | 2020-06-27 | St. Joseph | Michigan | 26149 | 276 | 3 |
278932 | 278932 | 2020-06-27 | Tuscola | Michigan | 26157 | 233 | 26 |
278933 | 278933 | 2020-06-27 | Unknown | Michigan | 156 | 2 | |
278934 | 278934 | 2020-06-27 | Van Buren | Michigan | 26159 | 224 | 7 |
278935 | 278935 | 2020-06-27 | Washtenaw | Michigan | 26161 | 2151 | 114 |
278936 | 278936 | 2020-06-27 | Wayne | Michigan | 26163 | 22603 | 2710 |
278937 | 278937 | 2020-06-27 | Wexford | Michigan | 26165 | 24 | 3 |
275707 | 275707 | 2020-06-26 | Alcona | Michigan | 26001 | 21 | 1 |
275708 | 275708 | 2020-06-26 | Alger | Michigan | 26003 | 2 | 0 |
275709 | 275709 | 2020-06-26 | Allegan | Michigan | 26005 | 302 | 6 |
275710 | 275710 | 2020-06-26 | Alpena | Michigan | 26007 | 117 | 12 |
275711 | 275711 | 2020-06-26 | Antrim | Michigan | 26009 | 18 | 0 |
275712 | 275712 | 2020-06-26 | Arenac | Michigan | 26011 | 38 | 2 |
275713 | 275713 | 2020-06-26 | Baraga | Michigan | 26013 | 4 | 0 |
275714 | 275714 | 2020-06-26 | Barry | Michigan | 26015 | 95 | 2 |
275715 | 275715 | 2020-06-26 | Bay | Michigan | 26017 | 385 | 30 |
275716 | 275716 | 2020-06-26 | Benzie | Michigan | 26019 | 7 | 0 |
275717 | 275717 | 2020-06-26 | Berrien | Michigan | 26021 | 923 | 60 |
275718 | 275718 | 2020-06-26 | Branch | Michigan | 26023 | 1047 | 25 |
275719 | 275719 | 2020-06-26 | Calhoun | Michigan | 26025 | 523 | 32 |
275720 | 275720 | 2020-06-26 | Cass | Michigan | 26027 | 134 | 4 |
275721 | 275721 | 2020-06-26 | Charlevoix | Michigan | 26029 | 29 | 2 |
275722 | 275722 | 2020-06-26 | Cheboygan | Michigan | 26031 | 27 | 2 |
275723 | 275723 | 2020-06-26 | Chippewa | Michigan | 26033 | 4 | 0 |
275724 | 275724 | 2020-06-26 | Clare | Michigan | 26035 | 27 | 3 |
275725 | 275725 | 2020-06-26 | Clinton | Michigan | 26037 | 214 | 12 |
275726 | 275726 | 2020-06-26 | Crawford | Michigan | 26039 | 68 | 5 |
275727 | 275727 | 2020-06-26 | Delta | Michigan | 26041 | 21 | 3 |
275728 | 275728 | 2020-06-26 | Dickinson | Michigan | 26043 | 7 | 2 |
275729 | 275729 | 2020-06-26 | Eaton | Michigan | 26045 | 306 | 7 |
275730 | 275730 | 2020-06-26 | Emmet | Michigan | 26047 | 27 | 2 |
275731 | 275731 | 2020-06-26 | Genesee | Michigan | 26049 | 2682 | 285 |
275732 | 275732 | 2020-06-26 | Gladwin | Michigan | 26051 | 26 | 1 |
275733 | 275733 | 2020-06-26 | Gogebic | Michigan | 26053 | 6 | 1 |
275734 | 275734 | 2020-06-26 | Grand Traverse | Michigan | 26055 | 46 | 5 |
275735 | 275735 | 2020-06-26 | Gratiot | Michigan | 26057 | 98 | 13 |
275736 | 275736 | 2020-06-26 | Hillsdale | Michigan | 26059 | 191 | 25 |
275737 | 275737 | 2020-06-26 | Houghton | Michigan | 26061 | 11 | 0 |
275738 | 275738 | 2020-06-26 | Huron | Michigan | 26063 | 64 | 3 |
275739 | 275739 | 2020-06-26 | Ingham | Michigan | 26065 | 954 | 29 |
275740 | 275740 | 2020-06-26 | Ionia | Michigan | 26067 | 196 | 4 |
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);