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 2022-02-25 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2250235 | 2250235 | 2022-02-25 | Alcona | Michigan | 26001 | 1699 | 67 |
2250236 | 2250236 | 2022-02-25 | Alger | Michigan | 26003 | 1837 | 13 |
2250237 | 2250237 | 2022-02-25 | Allegan | Michigan | 26005 | 26822 | 330 |
2250238 | 2250238 | 2022-02-25 | Alpena | Michigan | 26007 | 5503 | 133 |
2250239 | 2250239 | 2022-02-25 | Antrim | Michigan | 26009 | 4253 | 58 |
2250240 | 2250240 | 2022-02-25 | Arenac | Michigan | 26011 | 3169 | 62 |
2250241 | 2250241 | 2022-02-25 | Baraga | Michigan | 26013 | 2183 | 54 |
2250242 | 2250242 | 2022-02-25 | Barry | Michigan | 26015 | 14156 | 158 |
2250243 | 2250243 | 2022-02-25 | Bay | Michigan | 26017 | 26795 | 562 |
2250244 | 2250244 | 2022-02-25 | Benzie | Michigan | 26019 | 3385 | 64 |
2250245 | 2250245 | 2022-02-25 | Berrien | Michigan | 26021 | 34354 | 521 |
2250246 | 2250246 | 2022-02-25 | Branch | Michigan | 26023 | 12041 | 194 |
2250247 | 2250247 | 2022-02-25 | Calhoun | Michigan | 26025 | 33675 | 550 |
2250248 | 2250248 | 2022-02-25 | Cass | Michigan | 26027 | 11024 | 135 |
2250249 | 2250249 | 2022-02-25 | Charlevoix | Michigan | 26029 | 4861 | 58 |
2250250 | 2250250 | 2022-02-25 | Cheboygan | Michigan | 26031 | 4540 | 100 |
2250251 | 2250251 | 2022-02-25 | Chippewa | Michigan | 26033 | 11427 | 110 |
2250252 | 2250252 | 2022-02-25 | Clare | Michigan | 26035 | 6667 | 153 |
2250253 | 2250253 | 2022-02-25 | Clinton | Michigan | 26037 | 20774 | 195 |
2250254 | 2250254 | 2022-02-25 | Crawford | Michigan | 26039 | 2520 | 29 |
2250255 | 2250255 | 2022-02-25 | Delta | Michigan | 26041 | 9861 | 153 |
2250256 | 2250256 | 2022-02-25 | Dickinson | Michigan | 26043 | 7338 | 106 |
2250257 | 2250257 | 2022-02-25 | Eaton | Michigan | 26045 | 26347 | 382 |
2250258 | 2250258 | 2022-02-25 | Emmet | Michigan | 26047 | 6307 | 81 |
2250259 | 2250259 | 2022-02-25 | Genesee | Michigan | 26049 | 99972 | 1655 |
2250260 | 2250260 | 2022-02-25 | Gladwin | Michigan | 26051 | 5533 | 107 |
2250261 | 2250261 | 2022-02-25 | Gogebic | Michigan | 26053 | 3227 | 67 |
2250262 | 2250262 | 2022-02-25 | Grand Traverse | Michigan | 26055 | 16904 | 213 |
2250263 | 2250263 | 2022-02-25 | Gratiot | Michigan | 26057 | 13448 | 180 |
2250264 | 2250264 | 2022-02-25 | Hillsdale | Michigan | 26059 | 10244 | 189 |
2250265 | 2250265 | 2022-02-25 | Houghton | Michigan | 26061 | 7684 | 88 |
2250266 | 2250266 | 2022-02-25 | Huron | Michigan | 26063 | 7981 | 144 |
2250267 | 2250267 | 2022-02-25 | Ingham | Michigan | 26065 | 62979 | 719 |
2250268 | 2250268 | 2022-02-25 | Ionia | Michigan | 26067 | 19314 | 172 |
2250269 | 2250269 | 2022-02-25 | Iosco | Michigan | 26069 | 4750 | 133 |
2250270 | 2250270 | 2022-02-25 | Iron | Michigan | 26071 | 2622 | 83 |
2250271 | 2250271 | 2022-02-25 | Isabella | Michigan | 26073 | 15412 | 194 |
2250272 | 2250272 | 2022-02-25 | Jackson | Michigan | 26075 | 44215 | 552 |
2250273 | 2250273 | 2022-02-25 | Kalamazoo | Michigan | 26077 | 58233 | 646 |
2250274 | 2250274 | 2022-02-25 | Kalkaska | Michigan | 26079 | 3480 | 53 |
2250275 | 2250275 | 2022-02-25 | Kent | Michigan | 26081 | 164816 | 1467 |
2250276 | 2250276 | 2022-02-25 | Keweenaw | Michigan | 26083 | 504 | 13 |
2250277 | 2250277 | 2022-02-25 | Lake | Michigan | 26085 | 1816 | 35 |
2250278 | 2250278 | 2022-02-25 | Lapeer | Michigan | 26087 | 20614 | 414 |
2250279 | 2250279 | 2022-02-25 | Leelanau | Michigan | 26089 | 3519 | 50 |
2250280 | 2250280 | 2022-02-25 | Lenawee | Michigan | 26091 | 25658 | 314 |
2250281 | 2250281 | 2022-02-25 | Livingston | Michigan | 26093 | 45331 | 432 |
2250282 | 2250282 | 2022-02-25 | Luce | Michigan | 26095 | 2260 | 10 |
2250283 | 2250283 | 2022-02-25 | Mackinac | Michigan | 26097 | 2352 | 28 |
2250284 | 2250284 | 2022-02-25 | Macomb | Michigan | 26099 | 224824 | 3808 |
2250285 | 2250285 | 2022-02-25 | Manistee | Michigan | 26101 | 4404 | 83 |
2250286 | 2250286 | 2022-02-25 | Marquette | Michigan | 26103 | 15640 | 120 |
2250287 | 2250287 | 2022-02-25 | Mason | Michigan | 26105 | 6587 | 86 |
2250288 | 2250288 | 2022-02-25 | Mecosta | Michigan | 26107 | 8554 | 102 |
2250289 | 2250289 | 2022-02-25 | Menominee | Michigan | 26109 | 5534 | 69 |
2250290 | 2250290 | 2022-02-25 | Midland | Michigan | 26111 | 18857 | 219 |
2250291 | 2250291 | 2022-02-25 | Missaukee | Michigan | 26113 | 2870 | 59 |
2250292 | 2250292 | 2022-02-25 | Monroe | Michigan | 26115 | 37511 | 451 |
2250293 | 2250293 | 2022-02-25 | Montcalm | Michigan | 26117 | 17010 | 204 |
2250294 | 2250294 | 2022-02-25 | Montmorency | Michigan | 26119 | 1691 | 46 |
2250295 | 2250295 | 2022-02-25 | Muskegon | Michigan | 26121 | 41257 | 622 |
2250296 | 2250296 | 2022-02-25 | Newaygo | Michigan | 26123 | 11351 | 153 |
2250297 | 2250297 | 2022-02-25 | Oakland | Michigan | 26125 | 281836 | 3681 |
2250298 | 2250298 | 2022-02-25 | Oceana | Michigan | 26127 | 6227 | 89 |
2250299 | 2250299 | 2022-02-25 | Ogemaw | Michigan | 26129 | 4282 | 99 |
2250300 | 2250300 | 2022-02-25 | Ontonagon | Michigan | 26131 | 966 | 36 |
2250301 | 2250301 | 2022-02-25 | Osceola | Michigan | 26133 | 4930 | 77 |
2250302 | 2250302 | 2022-02-25 | Oscoda | Michigan | 26135 | 1422 | 53 |
2250303 | 2250303 | 2022-02-25 | Otsego | Michigan | 26137 | 5546 | 96 |
2250304 | 2250304 | 2022-02-25 | Ottawa | Michigan | 26139 | 73937 | 768 |
2250305 | 2250305 | 2022-02-25 | Presque Isle | Michigan | 26141 | 2057 | 55 |
2250306 | 2250306 | 2022-02-25 | Roscommon | Michigan | 26143 | 4558 | 110 |
2250307 | 2250307 | 2022-02-25 | Saginaw | Michigan | 26145 | 50008 | 913 |
2250308 | 2250308 | 2022-02-25 | Sanilac | Michigan | 26151 | 8601 | 183 |
2250309 | 2250309 | 2022-02-25 | Schoolcraft | Michigan | 26153 | 1742 | 13 |
2250310 | 2250310 | 2022-02-25 | Shiawassee | Michigan | 26155 | 17583 | 223 |
2250311 | 2250311 | 2022-02-25 | St. Clair | Michigan | 26147 | 40026 | 801 |
2250312 | 2250312 | 2022-02-25 | St. Joseph | Michigan | 26149 | 13572 | 196 |
2250313 | 2250313 | 2022-02-25 | Tuscola | Michigan | 26157 | 13132 | 271 |
2250314 | 2250314 | 2022-02-25 | Unknown | Michigan | 11854 | 33 | |
2250315 | 2250315 | 2022-02-25 | Van Buren | Michigan | 26159 | 16818 | 258 |
2250316 | 2250316 | 2022-02-25 | Washtenaw | Michigan | 26161 | 73294 | 507 |
2250317 | 2250317 | 2022-02-25 | Wayne | Michigan | 26163 | 392476 | 7627 |
2250318 | 2250318 | 2022-02-25 | Wexford | Michigan | 26165 | 6955 | 102 |
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);