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-08-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 |
---|---|---|---|---|---|---|---|
1574204 | 1574204 | 2021-08-01 | Alcona | Michigan | 26001 | 745 | 33 |
1574205 | 1574205 | 2021-08-01 | Alger | Michigan | 26003 | 670 | 7 |
1574206 | 1574206 | 2021-08-01 | Allegan | Michigan | 26005 | 11339 | 162 |
1574207 | 1574207 | 2021-08-01 | Alpena | Michigan | 26007 | 2329 | 65 |
1574208 | 1574208 | 2021-08-01 | Antrim | Michigan | 26009 | 1650 | 30 |
1574209 | 1574209 | 2021-08-01 | Arenac | Michigan | 26011 | 1227 | 29 |
1574210 | 1574210 | 2021-08-01 | Baraga | Michigan | 26013 | 998 | 40 |
1574211 | 1574211 | 2021-08-01 | Barry | Michigan | 26015 | 6029 | 70 |
1574212 | 1574212 | 2021-08-01 | Bay | Michigan | 26017 | 11337 | 355 |
1574213 | 1574213 | 2021-08-01 | Benzie | Michigan | 26019 | 1295 | 36 |
1574214 | 1574214 | 2021-08-01 | Berrien | Michigan | 26021 | 15744 | 302 |
1574215 | 1574215 | 2021-08-01 | Branch | Michigan | 26023 | 5934 | 121 |
1574216 | 1574216 | 2021-08-01 | Calhoun | Michigan | 26025 | 14781 | 320 |
1574217 | 1574217 | 2021-08-01 | Cass | Michigan | 26027 | 5577 | 78 |
1574218 | 1574218 | 2021-08-01 | Charlevoix | Michigan | 26029 | 1721 | 22 |
1574219 | 1574219 | 2021-08-01 | Cheboygan | Michigan | 26031 | 1947 | 47 |
1574220 | 1574220 | 2021-08-01 | Chippewa | Michigan | 26033 | 5681 | 51 |
1574221 | 1574221 | 2021-08-01 | Clare | Michigan | 26035 | 2508 | 86 |
1574222 | 1574222 | 2021-08-01 | Clinton | Michigan | 26037 | 7741 | 94 |
1574223 | 1574223 | 2021-08-01 | Crawford | Michigan | 26039 | 998 | 14 |
1574224 | 1574224 | 2021-08-01 | Delta | Michigan | 26041 | 4093 | 95 |
1574225 | 1574225 | 2021-08-01 | Dickinson | Michigan | 26043 | 2782 | 74 |
1574226 | 1574226 | 2021-08-01 | Eaton | Michigan | 26045 | 10250 | 211 |
1574227 | 1574227 | 2021-08-01 | Emmet | Michigan | 26047 | 2411 | 43 |
1574228 | 1574228 | 2021-08-01 | Genesee | Michigan | 26049 | 42099 | 978 |
1574229 | 1574229 | 2021-08-01 | Gladwin | Michigan | 26051 | 2320 | 61 |
1574230 | 1574230 | 2021-08-01 | Gogebic | Michigan | 26053 | 1449 | 53 |
1574231 | 1574231 | 2021-08-01 | Grand Traverse | Michigan | 26055 | 6600 | 100 |
1574232 | 1574232 | 2021-08-01 | Gratiot | Michigan | 26057 | 6990 | 125 |
1574233 | 1574233 | 2021-08-01 | Hillsdale | Michigan | 26059 | 4448 | 95 |
1574234 | 1574234 | 2021-08-01 | Houghton | Michigan | 26061 | 3156 | 43 |
1574235 | 1574235 | 2021-08-01 | Huron | Michigan | 26063 | 4121 | 82 |
1574236 | 1574236 | 2021-08-01 | Ingham | Michigan | 26065 | 25229 | 394 |
1574237 | 1574237 | 2021-08-01 | Ionia | Michigan | 26067 | 9430 | 85 |
1574238 | 1574238 | 2021-08-01 | Iosco | Michigan | 26069 | 2023 | 75 |
1574239 | 1574239 | 2021-08-01 | Iron | Michigan | 26071 | 1077 | 53 |
1574240 | 1574240 | 2021-08-01 | Isabella | Michigan | 26073 | 6384 | 101 |
1574241 | 1574241 | 2021-08-01 | Jackson | Michigan | 26075 | 21279 | 326 |
1574242 | 1574242 | 2021-08-01 | Kalamazoo | Michigan | 26077 | 23492 | 403 |
1574243 | 1574243 | 2021-08-01 | Kalkaska | Michigan | 26079 | 1171 | 29 |
1574244 | 1574244 | 2021-08-01 | Kent | Michigan | 26081 | 74491 | 870 |
1574245 | 1574245 | 2021-08-01 | Keweenaw | Michigan | 26083 | 174 | 2 |
1574246 | 1574246 | 2021-08-01 | Lake | Michigan | 26085 | 645 | 17 |
1574247 | 1574247 | 2021-08-01 | Lapeer | Michigan | 26087 | 9825 | 215 |
1574248 | 1574248 | 2021-08-01 | Leelanau | Michigan | 26089 | 1263 | 20 |
1574249 | 1574249 | 2021-08-01 | Lenawee | Michigan | 26091 | 10943 | 179 |
1574250 | 1574250 | 2021-08-01 | Livingston | Michigan | 26093 | 17023 | 195 |
1574251 | 1574251 | 2021-08-01 | Luce | Michigan | 26095 | 1339 | 6 |
1574252 | 1574252 | 2021-08-01 | Mackinac | Michigan | 26097 | 720 | 3 |
1574253 | 1574253 | 2021-08-01 | Macomb | Michigan | 26099 | 101662 | 2511 |
1574254 | 1574254 | 2021-08-01 | Manistee | Michigan | 26101 | 1992 | 25 |
1574255 | 1574255 | 2021-08-01 | Marquette | Michigan | 26103 | 5952 | 65 |
1574256 | 1574256 | 2021-08-01 | Mason | Michigan | 26105 | 2178 | 37 |
1574257 | 1574257 | 2021-08-01 | Mecosta | Michigan | 26107 | 3228 | 37 |
1574258 | 1574258 | 2021-08-01 | Menominee | Michigan | 26109 | 2145 | 43 |
1574259 | 1574259 | 2021-08-01 | Midland | Michigan | 26111 | 7655 | 96 |
1574260 | 1574260 | 2021-08-01 | Missaukee | Michigan | 26113 | 1524 | 27 |
1574261 | 1574261 | 2021-08-01 | Monroe | Michigan | 26115 | 15603 | 267 |
1574262 | 1574262 | 2021-08-01 | Montcalm | Michigan | 26117 | 8224 | 121 |
1574263 | 1574263 | 2021-08-01 | Montmorency | Michigan | 26119 | 627 | 20 |
1574264 | 1574264 | 2021-08-01 | Muskegon | Michigan | 26121 | 18647 | 386 |
1574265 | 1574265 | 2021-08-01 | Newaygo | Michigan | 26123 | 4933 | 69 |
1574266 | 1574266 | 2021-08-01 | Oakland | Michigan | 26125 | 120330 | 2475 |
1574267 | 1574267 | 2021-08-01 | Oceana | Michigan | 26127 | 2794 | 60 |
1574268 | 1574268 | 2021-08-01 | Ogemaw | Michigan | 26129 | 1764 | 43 |
1574269 | 1574269 | 2021-08-01 | Ontonagon | Michigan | 26131 | 488 | 22 |
1574270 | 1574270 | 2021-08-01 | Osceola | Michigan | 26133 | 1972 | 31 |
1574271 | 1574271 | 2021-08-01 | Oscoda | Michigan | 26135 | 695 | 31 |
1574272 | 1574272 | 2021-08-01 | Otsego | Michigan | 26137 | 2376 | 41 |
1574273 | 1574273 | 2021-08-01 | Ottawa | Michigan | 26139 | 33193 | 444 |
1574274 | 1574274 | 2021-08-01 | Presque Isle | Michigan | 26141 | 1063 | 34 |
1574275 | 1574275 | 2021-08-01 | Roscommon | Michigan | 26143 | 1912 | 55 |
1574276 | 1574276 | 2021-08-01 | Saginaw | Michigan | 26145 | 22817 | 642 |
1574277 | 1574277 | 2021-08-01 | Sanilac | Michigan | 26151 | 4274 | 126 |
1574278 | 1574278 | 2021-08-01 | Schoolcraft | Michigan | 26153 | 441 | 5 |
1574279 | 1574279 | 2021-08-01 | Shiawassee | Michigan | 26155 | 6519 | 110 |
1574280 | 1574280 | 2021-08-01 | St. Clair | Michigan | 26147 | 18644 | 454 |
1574281 | 1574281 | 2021-08-01 | St. Joseph | Michigan | 26149 | 6327 | 103 |
1574282 | 1574282 | 2021-08-01 | Tuscola | Michigan | 26157 | 5726 | 174 |
1574283 | 1574283 | 2021-08-01 | Unknown | Michigan | 758 | 18 | |
1574284 | 1574284 | 2021-08-01 | Van Buren | Michigan | 26159 | 7260 | 135 |
1574285 | 1574285 | 2021-08-01 | Washtenaw | Michigan | 26161 | 27443 | 312 |
1574286 | 1574286 | 2021-08-01 | Wayne | Michigan | 26163 | 168054 | 5211 |
1574287 | 1574287 | 2021-08-01 | Wexford | Michigan | 26165 | 2920 | 48 |
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);