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-02-08 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1009311 | 1009311 | 2021-02-08 | Alcona | Michigan | 26001 | 418 | 23 |
1009312 | 1009312 | 2021-02-08 | Alger | Michigan | 26003 | 577 | 3 |
1009313 | 1009313 | 2021-02-08 | Allegan | Michigan | 26005 | 7072 | 109 |
1009314 | 1009314 | 2021-02-08 | Alpena | Michigan | 26007 | 1437 | 45 |
1009315 | 1009315 | 2021-02-08 | Antrim | Michigan | 26009 | 881 | 18 |
1009316 | 1009316 | 2021-02-08 | Arenac | Michigan | 26011 | 730 | 24 |
1009317 | 1009317 | 2021-02-08 | Baraga | Michigan | 26013 | 762 | 32 |
1009318 | 1009318 | 2021-02-08 | Barry | Michigan | 26015 | 3610 | 41 |
1009319 | 1009319 | 2021-02-08 | Bay | Michigan | 26017 | 7214 | 274 |
1009320 | 1009320 | 2021-02-08 | Benzie | Michigan | 26019 | 881 | 31 |
1009321 | 1009321 | 2021-02-08 | Berrien | Michigan | 26021 | 11151 | 227 |
1009322 | 1009322 | 2021-02-08 | Branch | Michigan | 26023 | 4527 | 107 |
1009323 | 1009323 | 2021-02-08 | Calhoun | Michigan | 26025 | 9141 | 225 |
1009324 | 1009324 | 2021-02-08 | Cass | Michigan | 26027 | 3830 | 58 |
1009325 | 1009325 | 2021-02-08 | Charlevoix | Michigan | 26029 | 1016 | 12 |
1009326 | 1009326 | 2021-02-08 | Cheboygan | Michigan | 26031 | 871 | 35 |
1009327 | 1009327 | 2021-02-08 | Chippewa | Michigan | 26033 | 4664 | 40 |
1009328 | 1009328 | 2021-02-08 | Clare | Michigan | 26035 | 1565 | 69 |
1009329 | 1009329 | 2021-02-08 | Clinton | Michigan | 26037 | 4857 | 68 |
1009330 | 1009330 | 2021-02-08 | Crawford | Michigan | 26039 | 567 | 5 |
1009331 | 1009331 | 2021-02-08 | Delta | Michigan | 26041 | 3083 | 84 |
1009332 | 1009332 | 2021-02-08 | Dickinson | Michigan | 26043 | 2349 | 69 |
1009333 | 1009333 | 2021-02-08 | Eaton | Michigan | 26045 | 5971 | 142 |
1009334 | 1009334 | 2021-02-08 | Emmet | Michigan | 26047 | 1441 | 36 |
1009335 | 1009335 | 2021-02-08 | Genesee | Michigan | 26049 | 24720 | 733 |
1009336 | 1009336 | 2021-02-08 | Gladwin | Michigan | 26051 | 1448 | 42 |
1009337 | 1009337 | 2021-02-08 | Gogebic | Michigan | 26053 | 1206 | 45 |
1009338 | 1009338 | 2021-02-08 | Grand Traverse | Michigan | 26055 | 4059 | 64 |
1009339 | 1009339 | 2021-02-08 | Gratiot | Michigan | 26057 | 5617 | 100 |
1009340 | 1009340 | 2021-02-08 | Hillsdale | Michigan | 26059 | 3209 | 70 |
1009341 | 1009341 | 2021-02-08 | Houghton | Michigan | 26061 | 2508 | 39 |
1009342 | 1009342 | 2021-02-08 | Huron | Michigan | 26063 | 2040 | 54 |
1009343 | 1009343 | 2021-02-08 | Ingham | Michigan | 26065 | 15588 | 264 |
1009344 | 1009344 | 2021-02-08 | Ionia | Michigan | 26067 | 6424 | 70 |
1009345 | 1009345 | 2021-02-08 | Iosco | Michigan | 26069 | 1260 | 64 |
1009346 | 1009346 | 2021-02-08 | Iron | Michigan | 26071 | 921 | 48 |
1009347 | 1009347 | 2021-02-08 | Isabella | Michigan | 26073 | 3896 | 71 |
1009348 | 1009348 | 2021-02-08 | Jackson | Michigan | 26075 | 13740 | 233 |
1009349 | 1009349 | 2021-02-08 | Kalamazoo | Michigan | 26077 | 14468 | 315 |
1009350 | 1009350 | 2021-02-08 | Kalkaska | Michigan | 26079 | 569 | 14 |
1009351 | 1009351 | 2021-02-08 | Kent | Michigan | 26081 | 50100 | 673 |
1009352 | 1009352 | 2021-02-08 | Keweenaw | Michigan | 26083 | 130 | 2 |
1009353 | 1009353 | 2021-02-08 | Lake | Michigan | 26085 | 353 | 11 |
1009354 | 1009354 | 2021-02-08 | Lapeer | Michigan | 26087 | 5232 | 125 |
1009355 | 1009355 | 2021-02-08 | Leelanau | Michigan | 26089 | 835 | 14 |
1009356 | 1009356 | 2021-02-08 | Lenawee | Michigan | 26091 | 7389 | 113 |
1009357 | 1009357 | 2021-02-08 | Livingston | Michigan | 26093 | 9939 | 124 |
1009358 | 1009358 | 2021-02-08 | Luce | Michigan | 26095 | 1065 | 2 |
1009359 | 1009359 | 2021-02-08 | Mackinac | Michigan | 26097 | 428 | 3 |
1009360 | 1009360 | 2021-02-08 | Macomb | Michigan | 26099 | 57326 | 1908 |
1009361 | 1009361 | 2021-02-08 | Manistee | Michigan | 26101 | 1384 | 20 |
1009362 | 1009362 | 2021-02-08 | Marquette | Michigan | 26103 | 4765 | 54 |
1009363 | 1009363 | 2021-02-08 | Mason | Michigan | 26105 | 1210 | 26 |
1009364 | 1009364 | 2021-02-08 | Mecosta | Michigan | 26107 | 1922 | 19 |
1009365 | 1009365 | 2021-02-08 | Menominee | Michigan | 26109 | 1856 | 36 |
1009366 | 1009366 | 2021-02-08 | Midland | Michigan | 26111 | 4849 | 61 |
1009367 | 1009367 | 2021-02-08 | Missaukee | Michigan | 26113 | 710 | 17 |
1009368 | 1009368 | 2021-02-08 | Monroe | Michigan | 26115 | 9384 | 187 |
1009369 | 1009369 | 2021-02-08 | Montcalm | Michigan | 26117 | 5495 | 90 |
1009370 | 1009370 | 2021-02-08 | Montmorency | Michigan | 26119 | 351 | 17 |
1009371 | 1009371 | 2021-02-08 | Muskegon | Michigan | 26121 | 12511 | 314 |
1009372 | 1009372 | 2021-02-08 | Newaygo | Michigan | 26123 | 2688 | 46 |
1009373 | 1009373 | 2021-02-08 | Oakland | Michigan | 26125 | 72077 | 1926 |
1009374 | 1009374 | 2021-02-08 | Oceana | Michigan | 26127 | 1831 | 49 |
1009375 | 1009375 | 2021-02-08 | Ogemaw | Michigan | 26129 | 1092 | 32 |
1009376 | 1009376 | 2021-02-08 | Ontonagon | Michigan | 26131 | 397 | 19 |
1009377 | 1009377 | 2021-02-08 | Osceola | Michigan | 26133 | 1014 | 22 |
1009378 | 1009378 | 2021-02-08 | Oscoda | Michigan | 26135 | 388 | 18 |
1009379 | 1009379 | 2021-02-08 | Otsego | Michigan | 26137 | 1126 | 25 |
1009380 | 1009380 | 2021-02-08 | Ottawa | Michigan | 26139 | 21633 | 338 |
1009381 | 1009381 | 2021-02-08 | Presque Isle | Michigan | 26141 | 636 | 25 |
1009382 | 1009382 | 2021-02-08 | Roscommon | Michigan | 26143 | 1112 | 31 |
1009383 | 1009383 | 2021-02-08 | Saginaw | Michigan | 26145 | 15565 | 487 |
1009384 | 1009384 | 2021-02-08 | Sanilac | Michigan | 26151 | 1911 | 73 |
1009385 | 1009385 | 2021-02-08 | Schoolcraft | Michigan | 26153 | 257 | 5 |
1009386 | 1009386 | 2021-02-08 | Shiawassee | Michigan | 26155 | 3647 | 74 |
1009387 | 1009387 | 2021-02-08 | St. Clair | Michigan | 26147 | 8375 | 240 |
1009388 | 1009388 | 2021-02-08 | St. Joseph | Michigan | 26149 | 4513 | 78 |
1009389 | 1009389 | 2021-02-08 | Tuscola | Michigan | 26157 | 3065 | 131 |
1009390 | 1009390 | 2021-02-08 | Unknown | Michigan | 0 | 15 | |
1009391 | 1009391 | 2021-02-08 | Van Buren | Michigan | 26159 | 4830 | 94 |
1009392 | 1009392 | 2021-02-08 | Washtenaw | Michigan | 26161 | 18157 | 240 |
1009393 | 1009393 | 2021-02-08 | Wayne | Michigan | 26163 | 98551 | 4047 |
1009394 | 1009394 | 2021-02-08 | Wexford | Michigan | 26165 | 1350 | 20 |
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);