ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-12-13" 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 |
---|---|---|---|---|---|---|---|
824318 | 824318 | 2020-12-13 | Alcona | Michigan | 26001 | 295 | 9 |
824319 | 824319 | 2020-12-13 | Alger | Michigan | 26003 | 392 | 2 |
824320 | 824320 | 2020-12-13 | Allegan | Michigan | 26005 | 4955 | 43 |
824321 | 824321 | 2020-12-13 | Alpena | Michigan | 26007 | 964 | 19 |
824322 | 824322 | 2020-12-13 | Antrim | Michigan | 26009 | 532 | 8 |
824323 | 824323 | 2020-12-13 | Arenac | Michigan | 26011 | 542 | 23 |
824324 | 824324 | 2020-12-13 | Baraga | Michigan | 26013 | 615 | 26 |
824325 | 824325 | 2020-12-13 | Barry | Michigan | 26015 | 2640 | 23 |
824326 | 824326 | 2020-12-13 | Bay | Michigan | 26017 | 5409 | 141 |
824327 | 824327 | 2020-12-13 | Benzie | Michigan | 26019 | 573 | 12 |
824328 | 824328 | 2020-12-13 | Berrien | Michigan | 26021 | 8358 | 149 |
824329 | 824329 | 2020-12-13 | Branch | Michigan | 26023 | 3537 | 70 |
824330 | 824330 | 2020-12-13 | Calhoun | Michigan | 26025 | 7035 | 148 |
824331 | 824331 | 2020-12-13 | Cass | Michigan | 26027 | 2722 | 36 |
824332 | 824332 | 2020-12-13 | Charlevoix | Michigan | 26029 | 769 | 7 |
824333 | 824333 | 2020-12-13 | Cheboygan | Michigan | 26031 | 636 | 27 |
824334 | 824334 | 2020-12-13 | Chippewa | Michigan | 26033 | 2482 | 16 |
824335 | 824335 | 2020-12-13 | Clare | Michigan | 26035 | 990 | 28 |
824336 | 824336 | 2020-12-13 | Clinton | Michigan | 26037 | 3349 | 29 |
824337 | 824337 | 2020-12-13 | Crawford | Michigan | 26039 | 425 | 5 |
824338 | 824338 | 2020-12-13 | Delta | Michigan | 26041 | 2749 | 66 |
824339 | 824339 | 2020-12-13 | Dickinson | Michigan | 26043 | 1992 | 61 |
824340 | 824340 | 2020-12-13 | Eaton | Michigan | 26045 | 3978 | 67 |
824341 | 824341 | 2020-12-13 | Emmet | Michigan | 26047 | 1131 | 30 |
824342 | 824342 | 2020-12-13 | Genesee | Michigan | 26049 | 18482 | 502 |
824343 | 824343 | 2020-12-13 | Gladwin | Michigan | 26051 | 1037 | 16 |
824344 | 824344 | 2020-12-13 | Gogebic | Michigan | 26053 | 947 | 27 |
824345 | 824345 | 2020-12-13 | Grand Traverse | Michigan | 26055 | 2484 | 32 |
824346 | 824346 | 2020-12-13 | Gratiot | Michigan | 26057 | 3763 | 50 |
824347 | 824347 | 2020-12-13 | Hillsdale | Michigan | 26059 | 2145 | 49 |
824348 | 824348 | 2020-12-13 | Houghton | Michigan | 26061 | 1846 | 17 |
824349 | 824349 | 2020-12-13 | Huron | Michigan | 26063 | 1253 | 27 |
824350 | 824350 | 2020-12-13 | Ingham | Michigan | 26065 | 10920 | 146 |
824351 | 824351 | 2020-12-13 | Ionia | Michigan | 26067 | 4426 | 39 |
824352 | 824352 | 2020-12-13 | Iosco | Michigan | 26069 | 959 | 36 |
824353 | 824353 | 2020-12-13 | Iron | Michigan | 26071 | 770 | 37 |
824354 | 824354 | 2020-12-13 | Isabella | Michigan | 26073 | 2962 | 33 |
824355 | 824355 | 2020-12-13 | Jackson | Michigan | 26075 | 9256 | 147 |
824356 | 824356 | 2020-12-13 | Kalamazoo | Michigan | 26077 | 10892 | 201 |
824357 | 824357 | 2020-12-13 | Kalkaska | Michigan | 26079 | 432 | 9 |
824358 | 824358 | 2020-12-13 | Kent | Michigan | 26081 | 39038 | 452 |
824359 | 824359 | 2020-12-13 | Keweenaw | Michigan | 26083 | 82 | 2 |
824360 | 824360 | 2020-12-13 | Lake | Michigan | 26085 | 255 | 6 |
824361 | 824361 | 2020-12-13 | Lapeer | Michigan | 26087 | 3706 | 80 |
824362 | 824362 | 2020-12-13 | Leelanau | Michigan | 26089 | 500 | 4 |
824363 | 824363 | 2020-12-13 | Lenawee | Michigan | 26091 | 4541 | 50 |
824364 | 824364 | 2020-12-13 | Livingston | Michigan | 26093 | 6973 | 58 |
824365 | 824365 | 2020-12-13 | Luce | Michigan | 26095 | 967 | 0 |
824366 | 824366 | 2020-12-13 | Mackinac | Michigan | 26097 | 351 | 1 |
824367 | 824367 | 2020-12-13 | Macomb | Michigan | 26099 | 44931 | 1423 |
824368 | 824368 | 2020-12-13 | Manistee | Michigan | 26101 | 509 | 10 |
824369 | 824369 | 2020-12-13 | Marquette | Michigan | 26103 | 4148 | 43 |
824370 | 824370 | 2020-12-13 | Mason | Michigan | 26105 | 783 | 14 |
824371 | 824371 | 2020-12-13 | Mecosta | Michigan | 26107 | 1499 | 11 |
824372 | 824372 | 2020-12-13 | Menominee | Michigan | 26109 | 1493 | 22 |
824373 | 824373 | 2020-12-13 | Midland | Michigan | 26111 | 3503 | 32 |
824374 | 824374 | 2020-12-13 | Missaukee | Michigan | 26113 | 372 | 7 |
824375 | 824375 | 2020-12-13 | Monroe | Michigan | 26115 | 6645 | 116 |
824376 | 824376 | 2020-12-13 | Montcalm | Michigan | 26117 | 2846 | 40 |
824377 | 824377 | 2020-12-13 | Montmorency | Michigan | 26119 | 250 | 5 |
824378 | 824378 | 2020-12-13 | Muskegon | Michigan | 26121 | 10277 | 226 |
824379 | 824379 | 2020-12-13 | Newaygo | Michigan | 26123 | 1990 | 27 |
824380 | 824380 | 2020-12-13 | Oakland | Michigan | 26125 | 54497 | 1476 |
824381 | 824381 | 2020-12-13 | Oceana | Michigan | 26127 | 1461 | 31 |
824382 | 824382 | 2020-12-13 | Ogemaw | Michigan | 26129 | 753 | 23 |
824383 | 824383 | 2020-12-13 | Ontonagon | Michigan | 26131 | 298 | 15 |
824384 | 824384 | 2020-12-13 | Osceola | Michigan | 26133 | 700 | 14 |
824385 | 824385 | 2020-12-13 | Oscoda | Michigan | 26135 | 261 | 11 |
824386 | 824386 | 2020-12-13 | Otsego | Michigan | 26137 | 901 | 19 |
824387 | 824387 | 2020-12-13 | Ottawa | Michigan | 26139 | 16645 | 214 |
824388 | 824388 | 2020-12-13 | Presque Isle | Michigan | 26141 | 414 | 4 |
824389 | 824389 | 2020-12-13 | Roscommon | Michigan | 26143 | 809 | 25 |
824390 | 824390 | 2020-12-13 | Saginaw | Michigan | 26145 | 10767 | 311 |
824391 | 824391 | 2020-12-13 | Sanilac | Michigan | 26151 | 1231 | 43 |
824392 | 824392 | 2020-12-13 | Schoolcraft | Michigan | 26153 | 204 | 3 |
824393 | 824393 | 2020-12-13 | Shiawassee | Michigan | 26155 | 2515 | 51 |
824394 | 824394 | 2020-12-13 | St. Clair | Michigan | 26147 | 6028 | 117 |
824395 | 824395 | 2020-12-13 | St. Joseph | Michigan | 26149 | 3098 | 43 |
824396 | 824396 | 2020-12-13 | Tuscola | Michigan | 26157 | 2169 | 72 |
824397 | 824397 | 2020-12-13 | Unknown | Michigan | 3556 | 15 | |
824398 | 824398 | 2020-12-13 | Van Buren | Michigan | 26159 | 3580 | 65 |
824399 | 824399 | 2020-12-13 | Washtenaw | Michigan | 26161 | 12334 | 162 |
824400 | 824400 | 2020-12-13 | Wayne | Michigan | 26163 | 75824 | 3414 |
824401 | 824401 | 2020-12-13 | Wexford | Michigan | 26165 | 851 | 16 |
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);