ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-12-08" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1993347 | 1993347 | 2021-12-08 | Alcona | Michigan | 26001 | 1363 | 51 |
1993348 | 1993348 | 2021-12-08 | Alger | Michigan | 26003 | 1169 | 9 |
1993349 | 1993349 | 2021-12-08 | Allegan | Michigan | 26005 | 18988 | 241 |
1993350 | 1993350 | 2021-12-08 | Alpena | Michigan | 26007 | 4229 | 95 |
1993351 | 1993351 | 2021-12-08 | Antrim | Michigan | 26009 | 2975 | 45 |
1993352 | 1993352 | 2021-12-08 | Arenac | Michigan | 26011 | 2201 | 47 |
1993353 | 1993353 | 2021-12-08 | Baraga | Michigan | 26013 | 1594 | 47 |
1993354 | 1993354 | 2021-12-08 | Barry | Michigan | 26015 | 10092 | 113 |
1993355 | 1993355 | 2021-12-08 | Bay | Michigan | 26017 | 18033 | 444 |
1993356 | 1993356 | 2021-12-08 | Benzie | Michigan | 26019 | 2232 | 44 |
1993357 | 1993357 | 2021-12-08 | Berrien | Michigan | 26021 | 23033 | 354 |
1993358 | 1993358 | 2021-12-08 | Branch | Michigan | 26023 | 8889 | 152 |
1993359 | 1993359 | 2021-12-08 | Calhoun | Michigan | 26025 | 23161 | 419 |
1993360 | 1993360 | 2021-12-08 | Cass | Michigan | 26027 | 8370 | 108 |
1993361 | 1993361 | 2021-12-08 | Charlevoix | Michigan | 26029 | 3180 | 45 |
1993362 | 1993362 | 2021-12-08 | Cheboygan | Michigan | 26031 | 3406 | 78 |
1993363 | 1993363 | 2021-12-08 | Chippewa | Michigan | 26033 | 7859 | 76 |
1993364 | 1993364 | 2021-12-08 | Clare | Michigan | 26035 | 4790 | 121 |
1993365 | 1993365 | 2021-12-08 | Clinton | Michigan | 26037 | 13078 | 140 |
1993366 | 1993366 | 2021-12-08 | Crawford | Michigan | 26039 | 1833 | 20 |
1993367 | 1993367 | 2021-12-08 | Delta | Michigan | 26041 | 6809 | 128 |
1993368 | 1993368 | 2021-12-08 | Dickinson | Michigan | 26043 | 4809 | 88 |
1993369 | 1993369 | 2021-12-08 | Eaton | Michigan | 26045 | 16940 | 291 |
1993370 | 1993370 | 2021-12-08 | Emmet | Michigan | 26047 | 4198 | 55 |
1993371 | 1993371 | 2021-12-08 | Genesee | Michigan | 26049 | 65350 | 1223 |
1993372 | 1993372 | 2021-12-08 | Gladwin | Michigan | 26051 | 3865 | 85 |
1993373 | 1993373 | 2021-12-08 | Gogebic | Michigan | 26053 | 2194 | 57 |
1993374 | 1993374 | 2021-12-08 | Grand Traverse | Michigan | 26055 | 11434 | 154 |
1993375 | 1993375 | 2021-12-08 | Gratiot | Michigan | 26057 | 10195 | 151 |
1993376 | 1993376 | 2021-12-08 | Hillsdale | Michigan | 26059 | 7767 | 153 |
1993377 | 1993377 | 2021-12-08 | Houghton | Michigan | 26061 | 5432 | 62 |
1993378 | 1993378 | 2021-12-08 | Huron | Michigan | 26063 | 5966 | 111 |
1993379 | 1993379 | 2021-12-08 | Ingham | Michigan | 26065 | 38405 | 527 |
1993380 | 1993380 | 2021-12-08 | Ionia | Michigan | 26067 | 14384 | 132 |
1993381 | 1993381 | 2021-12-08 | Iosco | Michigan | 26069 | 3637 | 106 |
1993382 | 1993382 | 2021-12-08 | Iron | Michigan | 26071 | 1779 | 70 |
1993383 | 1993383 | 2021-12-08 | Isabella | Michigan | 26073 | 10712 | 145 |
1993384 | 1993384 | 2021-12-08 | Jackson | Michigan | 26075 | 32264 | 421 |
1993385 | 1993385 | 2021-12-08 | Kalamazoo | Michigan | 26077 | 36425 | 503 |
1993386 | 1993386 | 2021-12-08 | Kalkaska | Michigan | 26079 | 2298 | 43 |
1993387 | 1993387 | 2021-12-08 | Kent | Michigan | 26081 | 114279 | 1162 |
1993388 | 1993388 | 2021-12-08 | Keweenaw | Michigan | 26083 | 386 | 9 |
1993389 | 1993389 | 2021-12-08 | Lake | Michigan | 26085 | 1279 | 28 |
1993390 | 1993390 | 2021-12-08 | Lapeer | Michigan | 26087 | 14936 | 298 |
1993391 | 1993391 | 2021-12-08 | Leelanau | Michigan | 26089 | 2301 | 36 |
1993392 | 1993392 | 2021-12-08 | Lenawee | Michigan | 26091 | 18053 | 234 |
1993393 | 1993393 | 2021-12-08 | Livingston | Michigan | 26093 | 30300 | 311 |
1993394 | 1993394 | 2021-12-08 | Luce | Michigan | 26095 | 1787 | 6 |
1993395 | 1993395 | 2021-12-08 | Mackinac | Michigan | 26097 | 1587 | 17 |
1993396 | 1993396 | 2021-12-08 | Macomb | Michigan | 26099 | 148217 | 2971 |
1993397 | 1993397 | 2021-12-08 | Manistee | Michigan | 26101 | 3051 | 52 |
1993398 | 1993398 | 2021-12-08 | Marquette | Michigan | 26103 | 9447 | 93 |
1993399 | 1993399 | 2021-12-08 | Mason | Michigan | 26105 | 4388 | 60 |
1993400 | 1993400 | 2021-12-08 | Mecosta | Michigan | 26107 | 6000 | 75 |
1993401 | 1993401 | 2021-12-08 | Menominee | Michigan | 26109 | 3987 | 58 |
1993402 | 1993402 | 2021-12-08 | Midland | Michigan | 26111 | 12607 | 167 |
1993403 | 1993403 | 2021-12-08 | Missaukee | Michigan | 26113 | 2137 | 44 |
1993404 | 1993404 | 2021-12-08 | Monroe | Michigan | 26115 | 24962 | 342 |
1993405 | 1993405 | 2021-12-08 | Montcalm | Michigan | 26117 | 12987 | 156 |
1993406 | 1993406 | 2021-12-08 | Montmorency | Michigan | 26119 | 1297 | 39 |
1993407 | 1993407 | 2021-12-08 | Muskegon | Michigan | 26121 | 29648 | 485 |
1993408 | 1993408 | 2021-12-08 | Newaygo | Michigan | 26123 | 8276 | 116 |
1993409 | 1993409 | 2021-12-08 | Oakland | Michigan | 26125 | 177385 | 2898 |
1993410 | 1993410 | 2021-12-08 | Oceana | Michigan | 26127 | 4697 | 77 |
1993411 | 1993411 | 2021-12-08 | Ogemaw | Michigan | 26129 | 3166 | 76 |
1993412 | 1993412 | 2021-12-08 | Ontonagon | Michigan | 26131 | 706 | 25 |
1993413 | 1993413 | 2021-12-08 | Osceola | Michigan | 26133 | 3682 | 52 |
1993414 | 1993414 | 2021-12-08 | Oscoda | Michigan | 26135 | 1130 | 47 |
1993415 | 1993415 | 2021-12-08 | Otsego | Michigan | 26137 | 4069 | 72 |
1993416 | 1993416 | 2021-12-08 | Ottawa | Michigan | 26139 | 52064 | 595 |
1993417 | 1993417 | 2021-12-08 | Presque Isle | Michigan | 26141 | 1657 | 49 |
1993418 | 1993418 | 2021-12-08 | Roscommon | Michigan | 26143 | 3429 | 90 |
1993419 | 1993419 | 2021-12-08 | Saginaw | Michigan | 26145 | 34451 | 741 |
1993420 | 1993420 | 2021-12-08 | Sanilac | Michigan | 26151 | 6343 | 154 |
1993421 | 1993421 | 2021-12-08 | Schoolcraft | Michigan | 26153 | 1114 | 7 |
1993422 | 1993422 | 2021-12-08 | Shiawassee | Michigan | 26155 | 11804 | 157 |
1993423 | 1993423 | 2021-12-08 | St. Clair | Michigan | 26147 | 27902 | 577 |
1993424 | 1993424 | 2021-12-08 | St. Joseph | Michigan | 26149 | 10263 | 139 |
1993425 | 1993425 | 2021-12-08 | Tuscola | Michigan | 26157 | 9324 | 226 |
1993426 | 1993426 | 2021-12-08 | Unknown | Michigan | 2213 | 20 | |
1993427 | 1993427 | 2021-12-08 | Van Buren | Michigan | 26159 | 11677 | 191 |
1993428 | 1993428 | 2021-12-08 | Washtenaw | Michigan | 26161 | 41318 | 366 |
1993429 | 1993429 | 2021-12-08 | Wayne | Michigan | 26163 | 240454 | 6063 |
1993430 | 1993430 | 2021-12-08 | Wexford | Michigan | 26165 | 4754 | 79 |
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);