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-10-09 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1798363 | 1798363 | 2021-10-09 | Alcona | Michigan | 26001 | 986 | 39 |
1798364 | 1798364 | 2021-10-09 | Alger | Michigan | 26003 | 944 | 8 |
1798365 | 1798365 | 2021-10-09 | Allegan | Michigan | 26005 | 13729 | 180 |
1798366 | 1798366 | 2021-10-09 | Alpena | Michigan | 26007 | 2853 | 69 |
1798367 | 1798367 | 2021-10-09 | Antrim | Michigan | 26009 | 2145 | 35 |
1798368 | 1798368 | 2021-10-09 | Arenac | Michigan | 26011 | 1552 | 32 |
1798369 | 1798369 | 2021-10-09 | Baraga | Michigan | 26013 | 1195 | 46 |
1798370 | 1798370 | 2021-10-09 | Barry | Michigan | 26015 | 7263 | 78 |
1798371 | 1798371 | 2021-10-09 | Bay | Michigan | 26017 | 13664 | 373 |
1798372 | 1798372 | 2021-10-09 | Benzie | Michigan | 26019 | 1545 | 38 |
1798373 | 1798373 | 2021-10-09 | Berrien | Michigan | 26021 | 18492 | 322 |
1798374 | 1798374 | 2021-10-09 | Branch | Michigan | 26023 | 6995 | 135 |
1798375 | 1798375 | 2021-10-09 | Calhoun | Michigan | 26025 | 17645 | 339 |
1798376 | 1798376 | 2021-10-09 | Cass | Michigan | 26027 | 6764 | 86 |
1798377 | 1798377 | 2021-10-09 | Charlevoix | Michigan | 26029 | 2295 | 31 |
1798378 | 1798378 | 2021-10-09 | Cheboygan | Michigan | 26031 | 2584 | 61 |
1798379 | 1798379 | 2021-10-09 | Chippewa | Michigan | 26033 | 6550 | 56 |
1798380 | 1798380 | 2021-10-09 | Clare | Michigan | 26035 | 3327 | 95 |
1798381 | 1798381 | 2021-10-09 | Clinton | Michigan | 26037 | 9302 | 103 |
1798382 | 1798382 | 2021-10-09 | Crawford | Michigan | 26039 | 1194 | 16 |
1798383 | 1798383 | 2021-10-09 | Delta | Michigan | 26041 | 5379 | 102 |
1798384 | 1798384 | 2021-10-09 | Dickinson | Michigan | 26043 | 3725 | 78 |
1798385 | 1798385 | 2021-10-09 | Eaton | Michigan | 26045 | 12365 | 233 |
1798386 | 1798386 | 2021-10-09 | Emmet | Michigan | 26047 | 3121 | 49 |
1798387 | 1798387 | 2021-10-09 | Genesee | Michigan | 26049 | 48770 | 1045 |
1798388 | 1798388 | 2021-10-09 | Gladwin | Michigan | 26051 | 3005 | 67 |
1798389 | 1798389 | 2021-10-09 | Gogebic | Michigan | 26053 | 1718 | 53 |
1798390 | 1798390 | 2021-10-09 | Grand Traverse | Michigan | 26055 | 8268 | 113 |
1798391 | 1798391 | 2021-10-09 | Gratiot | Michigan | 26057 | 8067 | 128 |
1798392 | 1798392 | 2021-10-09 | Hillsdale | Michigan | 26059 | 5744 | 113 |
1798393 | 1798393 | 2021-10-09 | Houghton | Michigan | 26061 | 3687 | 54 |
1798394 | 1798394 | 2021-10-09 | Huron | Michigan | 26063 | 4560 | 88 |
1798395 | 1798395 | 2021-10-09 | Ingham | Michigan | 26065 | 29411 | 436 |
1798396 | 1798396 | 2021-10-09 | Ionia | Michigan | 26067 | 11115 | 95 |
1798397 | 1798397 | 2021-10-09 | Iosco | Michigan | 26069 | 2693 | 88 |
1798398 | 1798398 | 2021-10-09 | Iron | Michigan | 26071 | 1321 | 54 |
1798399 | 1798399 | 2021-10-09 | Isabella | Michigan | 26073 | 8204 | 109 |
1798400 | 1798400 | 2021-10-09 | Jackson | Michigan | 26075 | 24433 | 351 |
1798401 | 1798401 | 2021-10-09 | Kalamazoo | Michigan | 26077 | 28084 | 440 |
1798402 | 1798402 | 2021-10-09 | Kalkaska | Michigan | 26079 | 1601 | 32 |
1798403 | 1798403 | 2021-10-09 | Kent | Michigan | 26081 | 87793 | 956 |
1798404 | 1798404 | 2021-10-09 | Keweenaw | Michigan | 26083 | 227 | 4 |
1798405 | 1798405 | 2021-10-09 | Lake | Michigan | 26085 | 869 | 19 |
1798406 | 1798406 | 2021-10-09 | Lapeer | Michigan | 26087 | 11412 | 243 |
1798407 | 1798407 | 2021-10-09 | Leelanau | Michigan | 26089 | 1547 | 24 |
1798408 | 1798408 | 2021-10-09 | Lenawee | Michigan | 26091 | 13475 | 195 |
1798409 | 1798409 | 2021-10-09 | Livingston | Michigan | 26093 | 21280 | 228 |
1798410 | 1798410 | 2021-10-09 | Luce | Michigan | 26095 | 1519 | 6 |
1798411 | 1798411 | 2021-10-09 | Mackinac | Michigan | 26097 | 1145 | 7 |
1798412 | 1798412 | 2021-10-09 | Macomb | Michigan | 26099 | 115818 | 2624 |
1798413 | 1798413 | 2021-10-09 | Manistee | Michigan | 26101 | 2352 | 33 |
1798414 | 1798414 | 2021-10-09 | Marquette | Michigan | 26103 | 7462 | 72 |
1798415 | 1798415 | 2021-10-09 | Mason | Michigan | 26105 | 2853 | 44 |
1798416 | 1798416 | 2021-10-09 | Mecosta | Michigan | 26107 | 4229 | 41 |
1798417 | 1798417 | 2021-10-09 | Menominee | Michigan | 26109 | 3084 | 48 |
1798418 | 1798418 | 2021-10-09 | Midland | Michigan | 26111 | 9475 | 124 |
1798419 | 1798419 | 2021-10-09 | Missaukee | Michigan | 26113 | 1755 | 31 |
1798420 | 1798420 | 2021-10-09 | Monroe | Michigan | 26115 | 18938 | 294 |
1798421 | 1798421 | 2021-10-09 | Montcalm | Michigan | 26117 | 9870 | 128 |
1798422 | 1798422 | 2021-10-09 | Montmorency | Michigan | 26119 | 822 | 24 |
1798423 | 1798423 | 2021-10-09 | Muskegon | Michigan | 26121 | 22062 | 414 |
1798424 | 1798424 | 2021-10-09 | Newaygo | Michigan | 26123 | 6106 | 77 |
1798425 | 1798425 | 2021-10-09 | Oakland | Michigan | 26125 | 139111 | 2613 |
1798426 | 1798426 | 2021-10-09 | Oceana | Michigan | 26127 | 3463 | 67 |
1798427 | 1798427 | 2021-10-09 | Ogemaw | Michigan | 26129 | 2455 | 49 |
1798428 | 1798428 | 2021-10-09 | Ontonagon | Michigan | 26131 | 583 | 22 |
1798429 | 1798429 | 2021-10-09 | Osceola | Michigan | 26133 | 2663 | 34 |
1798430 | 1798430 | 2021-10-09 | Oscoda | Michigan | 26135 | 868 | 32 |
1798431 | 1798431 | 2021-10-09 | Otsego | Michigan | 26137 | 2979 | 49 |
1798432 | 1798432 | 2021-10-09 | Ottawa | Michigan | 26139 | 39021 | 483 |
1798433 | 1798433 | 2021-10-09 | Presque Isle | Michigan | 26141 | 1273 | 35 |
1798434 | 1798434 | 2021-10-09 | Roscommon | Michigan | 26143 | 2245 | 61 |
1798435 | 1798435 | 2021-10-09 | Saginaw | Michigan | 26145 | 26717 | 666 |
1798436 | 1798436 | 2021-10-09 | Sanilac | Michigan | 26151 | 4719 | 131 |
1798437 | 1798437 | 2021-10-09 | Schoolcraft | Michigan | 26153 | 706 | 5 |
1798438 | 1798438 | 2021-10-09 | Shiawassee | Michigan | 26155 | 8025 | 122 |
1798439 | 1798439 | 2021-10-09 | St. Clair | Michigan | 26147 | 21193 | 497 |
1798440 | 1798440 | 2021-10-09 | St. Joseph | Michigan | 26149 | 7837 | 115 |
1798441 | 1798441 | 2021-10-09 | Tuscola | Michigan | 26157 | 6921 | 186 |
1798442 | 1798442 | 2021-10-09 | Unknown | Michigan | 938 | 14 | |
1798443 | 1798443 | 2021-10-09 | Van Buren | Michigan | 26159 | 8706 | 154 |
1798444 | 1798444 | 2021-10-09 | Washtenaw | Michigan | 26161 | 32193 | 327 |
1798445 | 1798445 | 2021-10-09 | Wayne | Michigan | 26163 | 190419 | 5464 |
1798446 | 1798446 | 2021-10-09 | Wexford | Michigan | 26165 | 3377 | 51 |
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);