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 2021-06-05 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1389162 | 1389162 | 2021-06-05 | Alcona | Michigan | 26001 | 738 | 32 |
1389163 | 1389163 | 2021-06-05 | Alger | Michigan | 26003 | 666 | 7 |
1389164 | 1389164 | 2021-06-05 | Allegan | Michigan | 26005 | 11118 | 151 |
1389165 | 1389165 | 2021-06-05 | Alpena | Michigan | 26007 | 2262 | 61 |
1389166 | 1389166 | 2021-06-05 | Antrim | Michigan | 26009 | 1628 | 29 |
1389167 | 1389167 | 2021-06-05 | Arenac | Michigan | 26011 | 1205 | 29 |
1389168 | 1389168 | 2021-06-05 | Baraga | Michigan | 26013 | 986 | 38 |
1389169 | 1389169 | 2021-06-05 | Barry | Michigan | 26015 | 5938 | 68 |
1389170 | 1389170 | 2021-06-05 | Bay | Michigan | 26017 | 11228 | 348 |
1389171 | 1389171 | 2021-06-05 | Benzie | Michigan | 26019 | 1276 | 36 |
1389172 | 1389172 | 2021-06-05 | Berrien | Michigan | 26021 | 15520 | 287 |
1389173 | 1389173 | 2021-06-05 | Branch | Michigan | 26023 | 5674 | 120 |
1389174 | 1389174 | 2021-06-05 | Calhoun | Michigan | 26025 | 14458 | 308 |
1389175 | 1389175 | 2021-06-05 | Cass | Michigan | 26027 | 5460 | 76 |
1389176 | 1389176 | 2021-06-05 | Charlevoix | Michigan | 26029 | 1674 | 21 |
1389177 | 1389177 | 2021-06-05 | Cheboygan | Michigan | 26031 | 1925 | 45 |
1389178 | 1389178 | 2021-06-05 | Chippewa | Michigan | 26033 | 5593 | 49 |
1389179 | 1389179 | 2021-06-05 | Clare | Michigan | 26035 | 2464 | 82 |
1389180 | 1389180 | 2021-06-05 | Clinton | Michigan | 26037 | 7600 | 90 |
1389181 | 1389181 | 2021-06-05 | Crawford | Michigan | 26039 | 992 | 14 |
1389182 | 1389182 | 2021-06-05 | Delta | Michigan | 26041 | 4056 | 94 |
1389183 | 1389183 | 2021-06-05 | Dickinson | Michigan | 26043 | 2743 | 74 |
1389184 | 1389184 | 2021-06-05 | Eaton | Michigan | 26045 | 10122 | 207 |
1389185 | 1389185 | 2021-06-05 | Emmet | Michigan | 26047 | 2377 | 43 |
1389186 | 1389186 | 2021-06-05 | Genesee | Michigan | 26049 | 41643 | 952 |
1389187 | 1389187 | 2021-06-05 | Gladwin | Michigan | 26051 | 2299 | 59 |
1389188 | 1389188 | 2021-06-05 | Gogebic | Michigan | 26053 | 1404 | 50 |
1389189 | 1389189 | 2021-06-05 | Grand Traverse | Michigan | 26055 | 6464 | 97 |
1389190 | 1389190 | 2021-06-05 | Gratiot | Michigan | 26057 | 6960 | 124 |
1389191 | 1389191 | 2021-06-05 | Hillsdale | Michigan | 26059 | 4397 | 92 |
1389192 | 1389192 | 2021-06-05 | Houghton | Michigan | 26061 | 3135 | 42 |
1389193 | 1389193 | 2021-06-05 | Huron | Michigan | 26063 | 4084 | 81 |
1389194 | 1389194 | 2021-06-05 | Ingham | Michigan | 26065 | 24795 | 384 |
1389195 | 1389195 | 2021-06-05 | Ionia | Michigan | 26067 | 9293 | 85 |
1389196 | 1389196 | 2021-06-05 | Iosco | Michigan | 26069 | 2000 | 74 |
1389197 | 1389197 | 2021-06-05 | Iron | Michigan | 26071 | 1052 | 52 |
1389198 | 1389198 | 2021-06-05 | Isabella | Michigan | 26073 | 6315 | 98 |
1389199 | 1389199 | 2021-06-05 | Jackson | Michigan | 26075 | 20979 | 316 |
1389200 | 1389200 | 2021-06-05 | Kalamazoo | Michigan | 26077 | 23044 | 397 |
1389201 | 1389201 | 2021-06-05 | Kalkaska | Michigan | 26079 | 1123 | 23 |
1389202 | 1389202 | 2021-06-05 | Kent | Michigan | 26081 | 72973 | 847 |
1389203 | 1389203 | 2021-06-05 | Keweenaw | Michigan | 26083 | 174 | 2 |
1389204 | 1389204 | 2021-06-05 | Lake | Michigan | 26085 | 633 | 15 |
1389205 | 1389205 | 2021-06-05 | Lapeer | Michigan | 26087 | 9731 | 210 |
1389206 | 1389206 | 2021-06-05 | Leelanau | Michigan | 26089 | 1240 | 19 |
1389207 | 1389207 | 2021-06-05 | Lenawee | Michigan | 26091 | 10813 | 171 |
1389208 | 1389208 | 2021-06-05 | Livingston | Michigan | 26093 | 16719 | 192 |
1389209 | 1389209 | 2021-06-05 | Luce | Michigan | 26095 | 1337 | 6 |
1389210 | 1389210 | 2021-06-05 | Mackinac | Michigan | 26097 | 709 | 3 |
1389211 | 1389211 | 2021-06-05 | Macomb | Michigan | 26099 | 100255 | 2455 |
1389212 | 1389212 | 2021-06-05 | Manistee | Michigan | 26101 | 1970 | 24 |
1389213 | 1389213 | 2021-06-05 | Marquette | Michigan | 26103 | 5922 | 63 |
1389214 | 1389214 | 2021-06-05 | Mason | Michigan | 26105 | 2129 | 36 |
1389215 | 1389215 | 2021-06-05 | Mecosta | Michigan | 26107 | 3198 | 34 |
1389216 | 1389216 | 2021-06-05 | Menominee | Michigan | 26109 | 2120 | 43 |
1389217 | 1389217 | 2021-06-05 | Midland | Michigan | 26111 | 7541 | 91 |
1389218 | 1389218 | 2021-06-05 | Missaukee | Michigan | 26113 | 1504 | 25 |
1389219 | 1389219 | 2021-06-05 | Monroe | Michigan | 26115 | 15361 | 261 |
1389220 | 1389220 | 2021-06-05 | Montcalm | Michigan | 26117 | 8168 | 117 |
1389221 | 1389221 | 2021-06-05 | Montmorency | Michigan | 26119 | 615 | 20 |
1389222 | 1389222 | 2021-06-05 | Muskegon | Michigan | 26121 | 18298 | 375 |
1389223 | 1389223 | 2021-06-05 | Newaygo | Michigan | 26123 | 4865 | 68 |
1389224 | 1389224 | 2021-06-05 | Oakland | Michigan | 26125 | 118174 | 2383 |
1389225 | 1389225 | 2021-06-05 | Oceana | Michigan | 26127 | 2761 | 60 |
1389226 | 1389226 | 2021-06-05 | Ogemaw | Michigan | 26129 | 1737 | 43 |
1389227 | 1389227 | 2021-06-05 | Ontonagon | Michigan | 26131 | 477 | 21 |
1389228 | 1389228 | 2021-06-05 | Osceola | Michigan | 26133 | 1952 | 30 |
1389229 | 1389229 | 2021-06-05 | Oscoda | Michigan | 26135 | 686 | 31 |
1389230 | 1389230 | 2021-06-05 | Otsego | Michigan | 26137 | 2347 | 41 |
1389231 | 1389231 | 2021-06-05 | Ottawa | Michigan | 26139 | 32754 | 428 |
1389232 | 1389232 | 2021-06-05 | Presque Isle | Michigan | 26141 | 1053 | 34 |
1389233 | 1389233 | 2021-06-05 | Roscommon | Michigan | 26143 | 1893 | 53 |
1389234 | 1389234 | 2021-06-05 | Saginaw | Michigan | 26145 | 22443 | 618 |
1389235 | 1389235 | 2021-06-05 | Sanilac | Michigan | 26151 | 4251 | 121 |
1389236 | 1389236 | 2021-06-05 | Schoolcraft | Michigan | 26153 | 435 | 5 |
1389237 | 1389237 | 2021-06-05 | Shiawassee | Michigan | 26155 | 6408 | 105 |
1389238 | 1389238 | 2021-06-05 | St. Clair | Michigan | 26147 | 18419 | 441 |
1389239 | 1389239 | 2021-06-05 | St. Joseph | Michigan | 26149 | 6228 | 99 |
1389240 | 1389240 | 2021-06-05 | Tuscola | Michigan | 26157 | 5661 | 175 |
1389241 | 1389241 | 2021-06-05 | Unknown | Michigan | 665 | 15 | |
1389242 | 1389242 | 2021-06-05 | Van Buren | Michigan | 26159 | 7109 | 128 |
1389243 | 1389243 | 2021-06-05 | Washtenaw | Michigan | 26161 | 27047 | 303 |
1389244 | 1389244 | 2021-06-05 | Wayne | Michigan | 26163 | 164826 | 5080 |
1389245 | 1389245 | 2021-06-05 | Wexford | Michigan | 26165 | 2887 | 47 |
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);