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-11-18 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1928337 | 1928337 | 2021-11-18 | Alcona | Michigan | 26001 | 1249 | 47 |
1928338 | 1928338 | 2021-11-18 | Alger | Michigan | 26003 | 1080 | 9 |
1928339 | 1928339 | 2021-11-18 | Allegan | Michigan | 26005 | 16728 | 210 |
1928340 | 1928340 | 2021-11-18 | Alpena | Michigan | 26007 | 3719 | 80 |
1928341 | 1928341 | 2021-11-18 | Antrim | Michigan | 26009 | 2704 | 40 |
1928342 | 1928342 | 2021-11-18 | Arenac | Michigan | 26011 | 1998 | 41 |
1928343 | 1928343 | 2021-11-18 | Baraga | Michigan | 26013 | 1505 | 47 |
1928344 | 1928344 | 2021-11-18 | Barry | Michigan | 26015 | 8892 | 95 |
1928345 | 1928345 | 2021-11-18 | Bay | Michigan | 26017 | 16298 | 413 |
1928346 | 1928346 | 2021-11-18 | Benzie | Michigan | 26019 | 1912 | 42 |
1928347 | 1928347 | 2021-11-18 | Berrien | Michigan | 26021 | 20630 | 341 |
1928348 | 1928348 | 2021-11-18 | Branch | Michigan | 26023 | 8034 | 140 |
1928349 | 1928349 | 2021-11-18 | Calhoun | Michigan | 26025 | 20487 | 370 |
1928350 | 1928350 | 2021-11-18 | Cass | Michigan | 26027 | 7632 | 97 |
1928351 | 1928351 | 2021-11-18 | Charlevoix | Michigan | 26029 | 2853 | 41 |
1928352 | 1928352 | 2021-11-18 | Cheboygan | Michigan | 26031 | 3151 | 71 |
1928353 | 1928353 | 2021-11-18 | Chippewa | Michigan | 26033 | 7362 | 69 |
1928354 | 1928354 | 2021-11-18 | Clare | Michigan | 26035 | 4296 | 112 |
1928355 | 1928355 | 2021-11-18 | Clinton | Michigan | 26037 | 11489 | 125 |
1928356 | 1928356 | 2021-11-18 | Crawford | Michigan | 26039 | 1574 | 17 |
1928357 | 1928357 | 2021-11-18 | Delta | Michigan | 26041 | 6312 | 114 |
1928358 | 1928358 | 2021-11-18 | Dickinson | Michigan | 26043 | 4373 | 85 |
1928359 | 1928359 | 2021-11-18 | Eaton | Michigan | 26045 | 14963 | 261 |
1928360 | 1928360 | 2021-11-18 | Emmet | Michigan | 26047 | 3779 | 55 |
1928361 | 1928361 | 2021-11-18 | Genesee | Michigan | 26049 | 57340 | 1140 |
1928362 | 1928362 | 2021-11-18 | Gladwin | Michigan | 26051 | 3579 | 79 |
1928363 | 1928363 | 2021-11-18 | Gogebic | Michigan | 26053 | 1957 | 55 |
1928364 | 1928364 | 2021-11-18 | Grand Traverse | Michigan | 26055 | 10103 | 123 |
1928365 | 1928365 | 2021-11-18 | Gratiot | Michigan | 26057 | 9529 | 140 |
1928366 | 1928366 | 2021-11-18 | Hillsdale | Michigan | 26059 | 6886 | 138 |
1928367 | 1928367 | 2021-11-18 | Houghton | Michigan | 26061 | 4818 | 58 |
1928368 | 1928368 | 2021-11-18 | Huron | Michigan | 26063 | 5370 | 98 |
1928369 | 1928369 | 2021-11-18 | Ingham | Michigan | 26065 | 34400 | 483 |
1928370 | 1928370 | 2021-11-18 | Ionia | Michigan | 26067 | 12948 | 113 |
1928371 | 1928371 | 2021-11-18 | Iosco | Michigan | 26069 | 3349 | 102 |
1928372 | 1928372 | 2021-11-18 | Iron | Michigan | 26071 | 1599 | 61 |
1928373 | 1928373 | 2021-11-18 | Isabella | Michigan | 26073 | 9921 | 138 |
1928374 | 1928374 | 2021-11-18 | Jackson | Michigan | 26075 | 29045 | 393 |
1928375 | 1928375 | 2021-11-18 | Kalamazoo | Michigan | 26077 | 32642 | 478 |
1928376 | 1928376 | 2021-11-18 | Kalkaska | Michigan | 26079 | 1972 | 40 |
1928377 | 1928377 | 2021-11-18 | Kent | Michigan | 26081 | 102675 | 1045 |
1928378 | 1928378 | 2021-11-18 | Keweenaw | Michigan | 26083 | 326 | 7 |
1928379 | 1928379 | 2021-11-18 | Lake | Michigan | 26085 | 1089 | 24 |
1928380 | 1928380 | 2021-11-18 | Lapeer | Michigan | 26087 | 13190 | 267 |
1928381 | 1928381 | 2021-11-18 | Leelanau | Michigan | 26089 | 1916 | 27 |
1928382 | 1928382 | 2021-11-18 | Lenawee | Michigan | 26091 | 16358 | 217 |
1928383 | 1928383 | 2021-11-18 | Livingston | Michigan | 26093 | 26409 | 262 |
1928384 | 1928384 | 2021-11-18 | Luce | Michigan | 26095 | 1668 | 6 |
1928385 | 1928385 | 2021-11-18 | Mackinac | Michigan | 26097 | 1412 | 14 |
1928386 | 1928386 | 2021-11-18 | Macomb | Michigan | 26099 | 132334 | 2799 |
1928387 | 1928387 | 2021-11-18 | Manistee | Michigan | 26101 | 2716 | 44 |
1928388 | 1928388 | 2021-11-18 | Marquette | Michigan | 26103 | 8703 | 87 |
1928389 | 1928389 | 2021-11-18 | Mason | Michigan | 26105 | 3725 | 52 |
1928390 | 1928390 | 2021-11-18 | Mecosta | Michigan | 26107 | 5351 | 55 |
1928391 | 1928391 | 2021-11-18 | Menominee | Michigan | 26109 | 3679 | 52 |
1928392 | 1928392 | 2021-11-18 | Midland | Michigan | 26111 | 11412 | 150 |
1928393 | 1928393 | 2021-11-18 | Missaukee | Michigan | 26113 | 1985 | 41 |
1928394 | 1928394 | 2021-11-18 | Monroe | Michigan | 26115 | 22636 | 319 |
1928395 | 1928395 | 2021-11-18 | Montcalm | Michigan | 26117 | 11848 | 143 |
1928396 | 1928396 | 2021-11-18 | Montmorency | Michigan | 26119 | 1174 | 33 |
1928397 | 1928397 | 2021-11-18 | Muskegon | Michigan | 26121 | 26206 | 439 |
1928398 | 1928398 | 2021-11-18 | Newaygo | Michigan | 26123 | 7325 | 88 |
1928399 | 1928399 | 2021-11-18 | Oakland | Michigan | 26125 | 158285 | 2754 |
1928400 | 1928400 | 2021-11-18 | Oceana | Michigan | 26127 | 4124 | 72 |
1928401 | 1928401 | 2021-11-18 | Ogemaw | Michigan | 26129 | 2912 | 68 |
1928402 | 1928402 | 2021-11-18 | Ontonagon | Michigan | 26131 | 677 | 23 |
1928403 | 1928403 | 2021-11-18 | Osceola | Michigan | 26133 | 3385 | 47 |
1928404 | 1928404 | 2021-11-18 | Oscoda | Michigan | 26135 | 1054 | 41 |
1928405 | 1928405 | 2021-11-18 | Otsego | Michigan | 26137 | 3768 | 63 |
1928406 | 1928406 | 2021-11-18 | Ottawa | Michigan | 26139 | 46060 | 536 |
1928407 | 1928407 | 2021-11-18 | Presque Isle | Michigan | 26141 | 1539 | 43 |
1928408 | 1928408 | 2021-11-18 | Roscommon | Michigan | 26143 | 2997 | 72 |
1928409 | 1928409 | 2021-11-18 | Saginaw | Michigan | 26145 | 31060 | 701 |
1928410 | 1928410 | 2021-11-18 | Sanilac | Michigan | 26151 | 5533 | 143 |
1928411 | 1928411 | 2021-11-18 | Schoolcraft | Michigan | 26153 | 948 | 6 |
1928412 | 1928412 | 2021-11-18 | Shiawassee | Michigan | 26155 | 10055 | 139 |
1928413 | 1928413 | 2021-11-18 | St. Clair | Michigan | 26147 | 24655 | 537 |
1928414 | 1928414 | 2021-11-18 | St. Joseph | Michigan | 26149 | 9273 | 126 |
1928415 | 1928415 | 2021-11-18 | Tuscola | Michigan | 26157 | 8233 | 210 |
1928416 | 1928416 | 2021-11-18 | Unknown | Michigan | 1132 | 17 | |
1928417 | 1928417 | 2021-11-18 | Van Buren | Michigan | 26159 | 10237 | 171 |
1928418 | 1928418 | 2021-11-18 | Washtenaw | Michigan | 26161 | 37227 | 344 |
1928419 | 1928419 | 2021-11-18 | Wayne | Michigan | 26163 | 215405 | 5752 |
1928420 | 1928420 | 2021-11-18 | Wexford | Michigan | 26165 | 4180 | 62 |
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);