ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2022-01-01" 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 |
---|---|---|---|---|---|---|---|
2071356 | 2071356 | 2022-01-01 | Alcona | Michigan | 26001 | 1413 | 56 |
2071357 | 2071357 | 2022-01-01 | Alger | Michigan | 26003 | 1247 | 11 |
2071358 | 2071358 | 2022-01-01 | Allegan | Michigan | 26005 | 20295 | 279 |
2071359 | 2071359 | 2022-01-01 | Alpena | Michigan | 26007 | 4545 | 114 |
2071360 | 2071360 | 2022-01-01 | Antrim | Michigan | 26009 | 3153 | 51 |
2071361 | 2071361 | 2022-01-01 | Arenac | Michigan | 26011 | 2358 | 51 |
2071362 | 2071362 | 2022-01-01 | Baraga | Michigan | 26013 | 1665 | 49 |
2071363 | 2071363 | 2022-01-01 | Barry | Michigan | 26015 | 10746 | 131 |
2071364 | 2071364 | 2022-01-01 | Bay | Michigan | 26017 | 19169 | 471 |
2071365 | 2071365 | 2022-01-01 | Benzie | Michigan | 26019 | 2407 | 54 |
2071366 | 2071366 | 2022-01-01 | Berrien | Michigan | 26021 | 25487 | 396 |
2071367 | 2071367 | 2022-01-01 | Branch | Michigan | 26023 | 9402 | 167 |
2071368 | 2071368 | 2022-01-01 | Calhoun | Michigan | 26025 | 24824 | 462 |
2071369 | 2071369 | 2022-01-01 | Cass | Michigan | 26027 | 9046 | 111 |
2071370 | 2071370 | 2022-01-01 | Charlevoix | Michigan | 26029 | 3412 | 52 |
2071371 | 2071371 | 2022-01-01 | Cheboygan | Michigan | 26031 | 3676 | 80 |
2071372 | 2071372 | 2022-01-01 | Chippewa | Michigan | 26033 | 8251 | 80 |
2071373 | 2071373 | 2022-01-01 | Clare | Michigan | 26035 | 5127 | 131 |
2071374 | 2071374 | 2022-01-01 | Clinton | Michigan | 26037 | 14241 | 163 |
2071375 | 2071375 | 2022-01-01 | Crawford | Michigan | 26039 | 1932 | 21 |
2071376 | 2071376 | 2022-01-01 | Delta | Michigan | 26041 | 7154 | 135 |
2071377 | 2071377 | 2022-01-01 | Dickinson | Michigan | 26043 | 5119 | 93 |
2071378 | 2071378 | 2022-01-01 | Eaton | Michigan | 26045 | 18365 | 326 |
2071379 | 2071379 | 2022-01-01 | Emmet | Michigan | 26047 | 4549 | 60 |
2071380 | 2071380 | 2022-01-01 | Genesee | Michigan | 26049 | 72131 | 1343 |
2071381 | 2071381 | 2022-01-01 | Gladwin | Michigan | 26051 | 4148 | 95 |
2071382 | 2071382 | 2022-01-01 | Gogebic | Michigan | 26053 | 2330 | 62 |
2071383 | 2071383 | 2022-01-01 | Grand Traverse | Michigan | 26055 | 12257 | 180 |
2071384 | 2071384 | 2022-01-01 | Gratiot | Michigan | 26057 | 10850 | 164 |
2071385 | 2071385 | 2022-01-01 | Hillsdale | Michigan | 26059 | 8229 | 173 |
2071386 | 2071386 | 2022-01-01 | Houghton | Michigan | 26061 | 5668 | 73 |
2071387 | 2071387 | 2022-01-01 | Huron | Michigan | 26063 | 6322 | 122 |
2071388 | 2071388 | 2022-01-01 | Ingham | Michigan | 26065 | 42204 | 581 |
2071389 | 2071389 | 2022-01-01 | Ionia | Michigan | 26067 | 15189 | 148 |
2071390 | 2071390 | 2022-01-01 | Iosco | Michigan | 26069 | 3801 | 112 |
2071391 | 2071391 | 2022-01-01 | Iron | Michigan | 26071 | 1873 | 71 |
2071392 | 2071392 | 2022-01-01 | Isabella | Michigan | 26073 | 11410 | 161 |
2071393 | 2071393 | 2022-01-01 | Jackson | Michigan | 26075 | 34079 | 467 |
2071394 | 2071394 | 2022-01-01 | Kalamazoo | Michigan | 26077 | 40210 | 548 |
2071395 | 2071395 | 2022-01-01 | Kalkaska | Michigan | 26079 | 2527 | 48 |
2071396 | 2071396 | 2022-01-01 | Kent | Michigan | 26081 | 122995 | 1246 |
2071397 | 2071397 | 2022-01-01 | Keweenaw | Michigan | 26083 | 391 | 11 |
2071398 | 2071398 | 2022-01-01 | Lake | Michigan | 26085 | 1403 | 31 |
2071399 | 2071399 | 2022-01-01 | Lapeer | Michigan | 26087 | 16093 | 338 |
2071400 | 2071400 | 2022-01-01 | Leelanau | Michigan | 26089 | 2509 | 41 |
2071401 | 2071401 | 2022-01-01 | Lenawee | Michigan | 26091 | 19188 | 261 |
2071402 | 2071402 | 2022-01-01 | Livingston | Michigan | 26093 | 33150 | 357 |
2071403 | 2071403 | 2022-01-01 | Luce | Michigan | 26095 | 1898 | 6 |
2071404 | 2071404 | 2022-01-01 | Mackinac | Michigan | 26097 | 1702 | 19 |
2071405 | 2071405 | 2022-01-01 | Macomb | Michigan | 26099 | 166010 | 3220 |
2071406 | 2071406 | 2022-01-01 | Manistee | Michigan | 26101 | 3304 | 64 |
2071407 | 2071407 | 2022-01-01 | Marquette | Michigan | 26103 | 10098 | 98 |
2071408 | 2071408 | 2022-01-01 | Mason | Michigan | 26105 | 4767 | 66 |
2071409 | 2071409 | 2022-01-01 | Mecosta | Michigan | 26107 | 6390 | 85 |
2071410 | 2071410 | 2022-01-01 | Menominee | Michigan | 26109 | 4216 | 60 |
2071411 | 2071411 | 2022-01-01 | Midland | Michigan | 26111 | 13531 | 182 |
2071412 | 2071412 | 2022-01-01 | Missaukee | Michigan | 26113 | 2241 | 46 |
2071413 | 2071413 | 2022-01-01 | Monroe | Michigan | 26115 | 27232 | 372 |
2071414 | 2071414 | 2022-01-01 | Montcalm | Michigan | 26117 | 13737 | 171 |
2071415 | 2071415 | 2022-01-01 | Montmorency | Michigan | 26119 | 1342 | 41 |
2071416 | 2071416 | 2022-01-01 | Muskegon | Michigan | 26121 | 31612 | 528 |
2071417 | 2071417 | 2022-01-01 | Newaygo | Michigan | 26123 | 8839 | 129 |
2071418 | 2071418 | 2022-01-01 | Oakland | Michigan | 26125 | 199302 | 3116 |
2071419 | 2071419 | 2022-01-01 | Oceana | Michigan | 26127 | 4925 | 84 |
2071420 | 2071420 | 2022-01-01 | Ogemaw | Michigan | 26129 | 3327 | 81 |
2071421 | 2071421 | 2022-01-01 | Ontonagon | Michigan | 26131 | 752 | 27 |
2071422 | 2071422 | 2022-01-01 | Osceola | Michigan | 26133 | 3886 | 62 |
2071423 | 2071423 | 2022-01-01 | Oscoda | Michigan | 26135 | 1172 | 51 |
2071424 | 2071424 | 2022-01-01 | Otsego | Michigan | 26137 | 4301 | 81 |
2071425 | 2071425 | 2022-01-01 | Ottawa | Michigan | 26139 | 55516 | 646 |
2071426 | 2071426 | 2022-01-01 | Presque Isle | Michigan | 26141 | 1738 | 51 |
2071427 | 2071427 | 2022-01-01 | Roscommon | Michigan | 26143 | 3646 | 101 |
2071428 | 2071428 | 2022-01-01 | Saginaw | Michigan | 26145 | 37159 | 792 |
2071429 | 2071429 | 2022-01-01 | Sanilac | Michigan | 26151 | 6819 | 167 |
2071430 | 2071430 | 2022-01-01 | Schoolcraft | Michigan | 26153 | 1203 | 8 |
2071431 | 2071431 | 2022-01-01 | Shiawassee | Michigan | 26155 | 12724 | 183 |
2071432 | 2071432 | 2022-01-01 | St. Clair | Michigan | 26147 | 31062 | 663 |
2071433 | 2071433 | 2022-01-01 | St. Joseph | Michigan | 26149 | 10890 | 160 |
2071434 | 2071434 | 2022-01-01 | Tuscola | Michigan | 26157 | 9978 | 238 |
2071435 | 2071435 | 2022-01-01 | Unknown | Michigan | 1554 | 16 | |
2071436 | 2071436 | 2022-01-01 | Van Buren | Michigan | 26159 | 12731 | 211 |
2071437 | 2071437 | 2022-01-01 | Washtenaw | Michigan | 26161 | 47433 | 413 |
2071438 | 2071438 | 2022-01-01 | Wayne | Michigan | 26163 | 277722 | 6484 |
2071439 | 2071439 | 2022-01-01 | Wexford | Michigan | 26165 | 5056 | 85 |
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);