ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2020-11-01 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
688037 | 688037 | 2020-11-01 | Alcona | Michigan | 26001 | 55 | 3 |
688038 | 688038 | 2020-11-01 | Alger | Michigan | 26003 | 122 | 1 |
688039 | 688039 | 2020-11-01 | Allegan | Michigan | 26005 | 1503 | 7 |
688040 | 688040 | 2020-11-01 | Alpena | Michigan | 26007 | 180 | 14 |
688041 | 688041 | 2020-11-01 | Antrim | Michigan | 26009 | 143 | 0 |
688042 | 688042 | 2020-11-01 | Arenac | Michigan | 26011 | 111 | 3 |
688043 | 688043 | 2020-11-01 | Baraga | Michigan | 26013 | 126 | 4 |
688044 | 688044 | 2020-11-01 | Barry | Michigan | 26015 | 803 | 6 |
688045 | 688045 | 2020-11-01 | Bay | Michigan | 26017 | 1602 | 65 |
688046 | 688046 | 2020-11-01 | Benzie | Michigan | 26019 | 145 | 2 |
688047 | 688047 | 2020-11-01 | Berrien | Michigan | 26021 | 3157 | 86 |
688048 | 688048 | 2020-11-01 | Branch | Michigan | 26023 | 1788 | 34 |
688049 | 688049 | 2020-11-01 | Calhoun | Michigan | 26025 | 3275 | 70 |
688050 | 688050 | 2020-11-01 | Cass | Michigan | 26027 | 1103 | 24 |
688051 | 688051 | 2020-11-01 | Charlevoix | Michigan | 26029 | 220 | 4 |
688052 | 688052 | 2020-11-01 | Cheboygan | Michigan | 26031 | 187 | 2 |
688053 | 688053 | 2020-11-01 | Chippewa | Michigan | 26033 | 188 | 0 |
688054 | 688054 | 2020-11-01 | Clare | Michigan | 26035 | 319 | 14 |
688055 | 688055 | 2020-11-01 | Clinton | Michigan | 26037 | 1297 | 16 |
688056 | 688056 | 2020-11-01 | Crawford | Michigan | 26039 | 157 | 5 |
688057 | 688057 | 2020-11-01 | Delta | Michigan | 26041 | 1397 | 38 |
688058 | 688058 | 2020-11-01 | Dickinson | Michigan | 26043 | 760 | 21 |
688059 | 688059 | 2020-11-01 | Eaton | Michigan | 26045 | 1304 | 11 |
688060 | 688060 | 2020-11-01 | Emmet | Michigan | 26047 | 332 | 4 |
688061 | 688061 | 2020-11-01 | Genesee | Michigan | 26049 | 7352 | 343 |
688062 | 688062 | 2020-11-01 | Gladwin | Michigan | 26051 | 240 | 2 |
688063 | 688063 | 2020-11-01 | Gogebic | Michigan | 26053 | 462 | 11 |
688064 | 688064 | 2020-11-01 | Grand Traverse | Michigan | 26055 | 874 | 14 |
688065 | 688065 | 2020-11-01 | Gratiot | Michigan | 26057 | 600 | 17 |
688066 | 688066 | 2020-11-01 | Hillsdale | Michigan | 26059 | 579 | 29 |
688067 | 688067 | 2020-11-01 | Houghton | Michigan | 26061 | 986 | 9 |
688068 | 688068 | 2020-11-01 | Huron | Michigan | 26063 | 292 | 7 |
688069 | 688069 | 2020-11-01 | Ingham | Michigan | 26065 | 4928 | 69 |
688070 | 688070 | 2020-11-01 | Ionia | Michigan | 26067 | 1015 | 9 |
688071 | 688071 | 2020-11-01 | Iosco | Michigan | 26069 | 314 | 16 |
688072 | 688072 | 2020-11-01 | Iron | Michigan | 26071 | 475 | 26 |
688073 | 688073 | 2020-11-01 | Isabella | Michigan | 26073 | 1142 | 15 |
688074 | 688074 | 2020-11-01 | Jackson | Michigan | 26075 | 3692 | 92 |
688075 | 688075 | 2020-11-01 | Kalamazoo | Michigan | 26077 | 5237 | 114 |
688076 | 688076 | 2020-11-01 | Kalkaska | Michigan | 26079 | 145 | 4 |
688077 | 688077 | 2020-11-01 | Kent | Michigan | 26081 | 15956 | 188 |
688078 | 688078 | 2020-11-01 | Keweenaw | Michigan | 26083 | 23 | 0 |
688079 | 688079 | 2020-11-01 | Lake | Michigan | 26085 | 68 | 1 |
688080 | 688080 | 2020-11-01 | Lapeer | Michigan | 26087 | 1300 | 45 |
688081 | 688081 | 2020-11-01 | Leelanau | Michigan | 26089 | 163 | 2 |
688082 | 688082 | 2020-11-01 | Lenawee | Michigan | 26091 | 1953 | 24 |
688083 | 688083 | 2020-11-01 | Livingston | Michigan | 26093 | 2345 | 36 |
688084 | 688084 | 2020-11-01 | Luce | Michigan | 26095 | 325 | 1 |
688085 | 688085 | 2020-11-01 | Mackinac | Michigan | 26097 | 171 | 0 |
688086 | 688086 | 2020-11-01 | Macomb | Michigan | 26099 | 19975 | 1103 |
688087 | 688087 | 2020-11-01 | Manistee | Michigan | 26101 | 163 | 3 |
688088 | 688088 | 2020-11-01 | Marquette | Michigan | 26103 | 1246 | 16 |
688089 | 688089 | 2020-11-01 | Mason | Michigan | 26105 | 280 | 2 |
688090 | 688090 | 2020-11-01 | Mecosta | Michigan | 26107 | 615 | 4 |
688091 | 688091 | 2020-11-01 | Menominee | Michigan | 26109 | 776 | 6 |
688092 | 688092 | 2020-11-01 | Midland | Michigan | 26111 | 1179 | 14 |
688093 | 688093 | 2020-11-01 | Missaukee | Michigan | 26113 | 104 | 1 |
688094 | 688094 | 2020-11-01 | Monroe | Michigan | 26115 | 2206 | 42 |
688095 | 688095 | 2020-11-01 | Montcalm | Michigan | 26117 | 792 | 12 |
688096 | 688096 | 2020-11-01 | Montmorency | Michigan | 26119 | 37 | 0 |
688097 | 688097 | 2020-11-01 | Muskegon | Michigan | 26121 | 3570 | 88 |
688098 | 688098 | 2020-11-01 | Newaygo | Michigan | 26123 | 712 | 4 |
688099 | 688099 | 2020-11-01 | Oakland | Michigan | 26125 | 26579 | 1241 |
688100 | 688100 | 2020-11-01 | Oceana | Michigan | 26127 | 676 | 6 |
688101 | 688101 | 2020-11-01 | Ogemaw | Michigan | 26129 | 135 | 5 |
688102 | 688102 | 2020-11-01 | Ontonagon | Michigan | 26131 | 127 | 1 |
688103 | 688103 | 2020-11-01 | Osceola | Michigan | 26133 | 201 | 1 |
688104 | 688104 | 2020-11-01 | Oscoda | Michigan | 26135 | 60 | 2 |
688105 | 688105 | 2020-11-01 | Otsego | Michigan | 26137 | 297 | 12 |
688106 | 688106 | 2020-11-01 | Ottawa | Michigan | 26139 | 5979 | 79 |
688107 | 688107 | 2020-11-01 | Presque Isle | Michigan | 26141 | 81 | 1 |
688108 | 688108 | 2020-11-01 | Roscommon | Michigan | 26143 | 217 | 6 |
688109 | 688109 | 2020-11-01 | Saginaw | Michigan | 26145 | 4234 | 157 |
688110 | 688110 | 2020-11-01 | Sanilac | Michigan | 26151 | 232 | 7 |
688111 | 688111 | 2020-11-01 | Schoolcraft | Michigan | 26153 | 102 | 1 |
688112 | 688112 | 2020-11-01 | Shiawassee | Michigan | 26155 | 787 | 34 |
688113 | 688113 | 2020-11-01 | St. Clair | Michigan | 26147 | 1764 | 65 |
688114 | 688114 | 2020-11-01 | St. Joseph | Michigan | 26149 | 1371 | 24 |
688115 | 688115 | 2020-11-01 | Tuscola | Michigan | 26157 | 729 | 36 |
688116 | 688116 | 2020-11-01 | Unknown | Michigan | 1512 | 4 | |
688117 | 688117 | 2020-11-01 | Van Buren | Michigan | 26159 | 1222 | 20 |
688118 | 688118 | 2020-11-01 | Washtenaw | Michigan | 26161 | 6240 | 129 |
688119 | 688119 | 2020-11-01 | Wayne | Michigan | 26163 | 42198 | 3062 |
688120 | 688120 | 2020-11-01 | Wexford | Michigan | 26165 | 192 | 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);