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-06-30 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1470300 | 1470300 | 2021-06-30 | Alcona | Michigan | 26001 | 739 | 33 |
1470301 | 1470301 | 2021-06-30 | Alger | Michigan | 26003 | 670 | 7 |
1470302 | 1470302 | 2021-06-30 | Allegan | Michigan | 26005 | 11186 | 161 |
1470303 | 1470303 | 2021-06-30 | Alpena | Michigan | 26007 | 2270 | 63 |
1470304 | 1470304 | 2021-06-30 | Antrim | Michigan | 26009 | 1636 | 30 |
1470305 | 1470305 | 2021-06-30 | Arenac | Michigan | 26011 | 1209 | 29 |
1470306 | 1470306 | 2021-06-30 | Baraga | Michigan | 26013 | 994 | 39 |
1470307 | 1470307 | 2021-06-30 | Barry | Michigan | 26015 | 5964 | 69 |
1470308 | 1470308 | 2021-06-30 | Bay | Michigan | 26017 | 11264 | 355 |
1470309 | 1470309 | 2021-06-30 | Benzie | Michigan | 26019 | 1281 | 36 |
1470310 | 1470310 | 2021-06-30 | Berrien | Michigan | 26021 | 15596 | 292 |
1470311 | 1470311 | 2021-06-30 | Branch | Michigan | 26023 | 5767 | 121 |
1470312 | 1470312 | 2021-06-30 | Calhoun | Michigan | 26025 | 14566 | 318 |
1470313 | 1470313 | 2021-06-30 | Cass | Michigan | 26027 | 5501 | 77 |
1470314 | 1470314 | 2021-06-30 | Charlevoix | Michigan | 26029 | 1681 | 22 |
1470315 | 1470315 | 2021-06-30 | Cheboygan | Michigan | 26031 | 1931 | 46 |
1470316 | 1470316 | 2021-06-30 | Chippewa | Michigan | 26033 | 5631 | 50 |
1470317 | 1470317 | 2021-06-30 | Clare | Michigan | 26035 | 2481 | 85 |
1470318 | 1470318 | 2021-06-30 | Clinton | Michigan | 26037 | 7656 | 92 |
1470319 | 1470319 | 2021-06-30 | Crawford | Michigan | 26039 | 995 | 14 |
1470320 | 1470320 | 2021-06-30 | Delta | Michigan | 26041 | 4057 | 95 |
1470321 | 1470321 | 2021-06-30 | Dickinson | Michigan | 26043 | 2755 | 74 |
1470322 | 1470322 | 2021-06-30 | Eaton | Michigan | 26045 | 10153 | 212 |
1470323 | 1470323 | 2021-06-30 | Emmet | Michigan | 26047 | 2384 | 43 |
1470324 | 1470324 | 2021-06-30 | Genesee | Michigan | 26049 | 41756 | 970 |
1470325 | 1470325 | 2021-06-30 | Gladwin | Michigan | 26051 | 2305 | 61 |
1470326 | 1470326 | 2021-06-30 | Gogebic | Michigan | 26053 | 1406 | 52 |
1470327 | 1470327 | 2021-06-30 | Grand Traverse | Michigan | 26055 | 6478 | 99 |
1470328 | 1470328 | 2021-06-30 | Gratiot | Michigan | 26057 | 6986 | 125 |
1470329 | 1470329 | 2021-06-30 | Hillsdale | Michigan | 26059 | 4406 | 93 |
1470330 | 1470330 | 2021-06-30 | Houghton | Michigan | 26061 | 3141 | 43 |
1470331 | 1470331 | 2021-06-30 | Huron | Michigan | 26063 | 4093 | 82 |
1470332 | 1470332 | 2021-06-30 | Ingham | Michigan | 26065 | 24909 | 391 |
1470333 | 1470333 | 2021-06-30 | Ionia | Michigan | 26067 | 9349 | 85 |
1470334 | 1470334 | 2021-06-30 | Iosco | Michigan | 26069 | 2007 | 74 |
1470335 | 1470335 | 2021-06-30 | Iron | Michigan | 26071 | 1054 | 53 |
1470336 | 1470336 | 2021-06-30 | Isabella | Michigan | 26073 | 6339 | 100 |
1470337 | 1470337 | 2021-06-30 | Jackson | Michigan | 26075 | 21051 | 324 |
1470338 | 1470338 | 2021-06-30 | Kalamazoo | Michigan | 26077 | 23188 | 402 |
1470339 | 1470339 | 2021-06-30 | Kalkaska | Michigan | 26079 | 1143 | 26 |
1470340 | 1470340 | 2021-06-30 | Kent | Michigan | 26081 | 73774 | 866 |
1470341 | 1470341 | 2021-06-30 | Keweenaw | Michigan | 26083 | 174 | 2 |
1470342 | 1470342 | 2021-06-30 | Lake | Michigan | 26085 | 638 | 17 |
1470343 | 1470343 | 2021-06-30 | Lapeer | Michigan | 26087 | 9767 | 215 |
1470344 | 1470344 | 2021-06-30 | Leelanau | Michigan | 26089 | 1243 | 19 |
1470345 | 1470345 | 2021-06-30 | Lenawee | Michigan | 26091 | 10853 | 177 |
1470346 | 1470346 | 2021-06-30 | Livingston | Michigan | 26093 | 16804 | 196 |
1470347 | 1470347 | 2021-06-30 | Luce | Michigan | 26095 | 1338 | 6 |
1470348 | 1470348 | 2021-06-30 | Mackinac | Michigan | 26097 | 715 | 3 |
1470349 | 1470349 | 2021-06-30 | Macomb | Michigan | 26099 | 100655 | 2497 |
1470350 | 1470350 | 2021-06-30 | Manistee | Michigan | 26101 | 1981 | 24 |
1470351 | 1470351 | 2021-06-30 | Marquette | Michigan | 26103 | 5938 | 64 |
1470352 | 1470352 | 2021-06-30 | Mason | Michigan | 26105 | 2140 | 37 |
1470353 | 1470353 | 2021-06-30 | Mecosta | Michigan | 26107 | 3215 | 36 |
1470354 | 1470354 | 2021-06-30 | Menominee | Michigan | 26109 | 2130 | 43 |
1470355 | 1470355 | 2021-06-30 | Midland | Michigan | 26111 | 7577 | 94 |
1470356 | 1470356 | 2021-06-30 | Missaukee | Michigan | 26113 | 1513 | 27 |
1470357 | 1470357 | 2021-06-30 | Monroe | Michigan | 26115 | 15419 | 264 |
1470358 | 1470358 | 2021-06-30 | Montcalm | Michigan | 26117 | 8211 | 119 |
1470359 | 1470359 | 2021-06-30 | Montmorency | Michigan | 26119 | 618 | 20 |
1470360 | 1470360 | 2021-06-30 | Muskegon | Michigan | 26121 | 18429 | 383 |
1470361 | 1470361 | 2021-06-30 | Newaygo | Michigan | 26123 | 4897 | 68 |
1470362 | 1470362 | 2021-06-30 | Oakland | Michigan | 26125 | 118738 | 2444 |
1470363 | 1470363 | 2021-06-30 | Oceana | Michigan | 26127 | 2769 | 60 |
1470364 | 1470364 | 2021-06-30 | Ogemaw | Michigan | 26129 | 1745 | 43 |
1470365 | 1470365 | 2021-06-30 | Ontonagon | Michigan | 26131 | 482 | 21 |
1470366 | 1470366 | 2021-06-30 | Osceola | Michigan | 26133 | 1962 | 31 |
1470367 | 1470367 | 2021-06-30 | Oscoda | Michigan | 26135 | 691 | 31 |
1470368 | 1470368 | 2021-06-30 | Otsego | Michigan | 26137 | 2362 | 41 |
1470369 | 1470369 | 2021-06-30 | Ottawa | Michigan | 26139 | 32938 | 440 |
1470370 | 1470370 | 2021-06-30 | Presque Isle | Michigan | 26141 | 1057 | 34 |
1470371 | 1470371 | 2021-06-30 | Roscommon | Michigan | 26143 | 1900 | 55 |
1470372 | 1470372 | 2021-06-30 | Saginaw | Michigan | 26145 | 22525 | 634 |
1470373 | 1470373 | 2021-06-30 | Sanilac | Michigan | 26151 | 4261 | 125 |
1470374 | 1470374 | 2021-06-30 | Schoolcraft | Michigan | 26153 | 438 | 5 |
1470375 | 1470375 | 2021-06-30 | Shiawassee | Michigan | 26155 | 6436 | 107 |
1470376 | 1470376 | 2021-06-30 | St. Clair | Michigan | 26147 | 18501 | 448 |
1470377 | 1470377 | 2021-06-30 | St. Joseph | Michigan | 26149 | 6262 | 101 |
1470378 | 1470378 | 2021-06-30 | Tuscola | Michigan | 26157 | 5668 | 174 |
1470379 | 1470379 | 2021-06-30 | Unknown | Michigan | 735 | 15 | |
1470380 | 1470380 | 2021-06-30 | Van Buren | Michigan | 26159 | 7145 | 130 |
1470381 | 1470381 | 2021-06-30 | Washtenaw | Michigan | 26161 | 27140 | 310 |
1470382 | 1470382 | 2021-06-30 | Wayne | Michigan | 26163 | 165942 | 5167 |
1470383 | 1470383 | 2021-06-30 | Wexford | Michigan | 26165 | 2902 | 48 |
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);