ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where date = "2020-06-30" 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 |
---|---|---|---|---|---|---|---|
288298 | 288298 | 2020-06-30 | Alcona | Michigan | 26001 | 22 | 1 |
288299 | 288299 | 2020-06-30 | Alger | Michigan | 26003 | 3 | 0 |
288300 | 288300 | 2020-06-30 | Allegan | Michigan | 26005 | 312 | 7 |
288301 | 288301 | 2020-06-30 | Alpena | Michigan | 26007 | 120 | 12 |
288302 | 288302 | 2020-06-30 | Antrim | Michigan | 26009 | 18 | 0 |
288303 | 288303 | 2020-06-30 | Arenac | Michigan | 26011 | 38 | 2 |
288304 | 288304 | 2020-06-30 | Baraga | Michigan | 26013 | 5 | 0 |
288305 | 288305 | 2020-06-30 | Barry | Michigan | 26015 | 102 | 2 |
288306 | 288306 | 2020-06-30 | Bay | Michigan | 26017 | 392 | 30 |
288307 | 288307 | 2020-06-30 | Benzie | Michigan | 26019 | 12 | 0 |
288308 | 288308 | 2020-06-30 | Berrien | Michigan | 26021 | 942 | 60 |
288309 | 288309 | 2020-06-30 | Branch | Michigan | 26023 | 1050 | 25 |
288310 | 288310 | 2020-06-30 | Calhoun | Michigan | 26025 | 536 | 33 |
288311 | 288311 | 2020-06-30 | Cass | Michigan | 26027 | 145 | 5 |
288312 | 288312 | 2020-06-30 | Charlevoix | Michigan | 26029 | 30 | 2 |
288313 | 288313 | 2020-06-30 | Cheboygan | Michigan | 26031 | 27 | 2 |
288314 | 288314 | 2020-06-30 | Chippewa | Michigan | 26033 | 11 | 0 |
288315 | 288315 | 2020-06-30 | Clare | Michigan | 26035 | 28 | 3 |
288316 | 288316 | 2020-06-30 | Clinton | Michigan | 26037 | 223 | 12 |
288317 | 288317 | 2020-06-30 | Crawford | Michigan | 26039 | 70 | 5 |
288318 | 288318 | 2020-06-30 | Delta | Michigan | 26041 | 23 | 3 |
288319 | 288319 | 2020-06-30 | Dickinson | Michigan | 26043 | 7 | 2 |
288320 | 288320 | 2020-06-30 | Eaton | Michigan | 26045 | 327 | 7 |
288321 | 288321 | 2020-06-30 | Emmet | Michigan | 26047 | 27 | 2 |
288322 | 288322 | 2020-06-30 | Genesee | Michigan | 26049 | 2734 | 288 |
288323 | 288323 | 2020-06-30 | Gladwin | Michigan | 26051 | 27 | 1 |
288324 | 288324 | 2020-06-30 | Gogebic | Michigan | 26053 | 7 | 1 |
288325 | 288325 | 2020-06-30 | Grand Traverse | Michigan | 26055 | 53 | 5 |
288326 | 288326 | 2020-06-30 | Gratiot | Michigan | 26057 | 98 | 13 |
288327 | 288327 | 2020-06-30 | Hillsdale | Michigan | 26059 | 194 | 25 |
288328 | 288328 | 2020-06-30 | Houghton | Michigan | 26061 | 11 | 0 |
288329 | 288329 | 2020-06-30 | Huron | Michigan | 26063 | 65 | 3 |
288330 | 288330 | 2020-06-30 | Ingham | Michigan | 26065 | 1019 | 29 |
288331 | 288331 | 2020-06-30 | Ionia | Michigan | 26067 | 199 | 4 |
288332 | 288332 | 2020-06-30 | Iosco | Michigan | 26069 | 113 | 10 |
288333 | 288333 | 2020-06-30 | Iron | Michigan | 26071 | 5 | 1 |
288334 | 288334 | 2020-06-30 | Isabella | Michigan | 26073 | 123 | 8 |
288335 | 288335 | 2020-06-30 | Jackson | Michigan | 26075 | 2093 | 52 |
288336 | 288336 | 2020-06-30 | Kalamazoo | Michigan | 26077 | 1084 | 67 |
288337 | 288337 | 2020-06-30 | Kalkaska | Michigan | 26079 | 33 | 2 |
288338 | 288338 | 2020-06-30 | Kent | Michigan | 26081 | 4906 | 134 |
288339 | 288339 | 2020-06-30 | Keweenaw | Michigan | 26083 | 1 | 0 |
288340 | 288340 | 2020-06-30 | Lake | Michigan | 26085 | 8 | 0 |
288341 | 288341 | 2020-06-30 | Lapeer | Michigan | 26087 | 599 | 38 |
288342 | 288342 | 2020-06-30 | Leelanau | Michigan | 26089 | 17 | 0 |
288343 | 288343 | 2020-06-30 | Lenawee | Michigan | 26091 | 949 | 10 |
288344 | 288344 | 2020-06-30 | Livingston | Michigan | 26093 | 620 | 29 |
288345 | 288345 | 2020-06-30 | Luce | Michigan | 26095 | 4 | 0 |
288346 | 288346 | 2020-06-30 | Mackinac | Michigan | 26097 | 9 | 0 |
288347 | 288347 | 2020-06-30 | Macomb | Michigan | 26099 | 7599 | 921 |
288348 | 288348 | 2020-06-30 | Manistee | Michigan | 26101 | 31 | 0 |
288349 | 288349 | 2020-06-30 | Marquette | Michigan | 26103 | 64 | 11 |
288350 | 288350 | 2020-06-30 | Mason | Michigan | 26105 | 51 | 0 |
288351 | 288351 | 2020-06-30 | Mecosta | Michigan | 26107 | 29 | 2 |
288352 | 288352 | 2020-06-30 | Menominee | Michigan | 26109 | 16 | 0 |
288353 | 288353 | 2020-06-30 | Midland | Michigan | 26111 | 166 | 9 |
288354 | 288354 | 2020-06-30 | Missaukee | Michigan | 26113 | 29 | 1 |
288355 | 288355 | 2020-06-30 | Monroe | Michigan | 26115 | 617 | 21 |
288356 | 288356 | 2020-06-30 | Montcalm | Michigan | 26117 | 90 | 1 |
288357 | 288357 | 2020-06-30 | Montmorency | Michigan | 26119 | 5 | 0 |
288358 | 288358 | 2020-06-30 | Muskegon | Michigan | 26121 | 815 | 51 |
288359 | 288359 | 2020-06-30 | Newaygo | Michigan | 26123 | 167 | 0 |
288360 | 288360 | 2020-06-30 | Oakland | Michigan | 26125 | 12017 | 1090 |
288361 | 288361 | 2020-06-30 | Oceana | Michigan | 26127 | 287 | 3 |
288362 | 288362 | 2020-06-30 | Ogemaw | Michigan | 26129 | 33 | 2 |
288363 | 288363 | 2020-06-30 | Osceola | Michigan | 26133 | 29 | 0 |
288364 | 288364 | 2020-06-30 | Oscoda | Michigan | 26135 | 18 | 1 |
288365 | 288365 | 2020-06-30 | Otsego | Michigan | 26137 | 133 | 10 |
288366 | 288366 | 2020-06-30 | Ottawa | Michigan | 26139 | 1048 | 51 |
288367 | 288367 | 2020-06-30 | Presque Isle | Michigan | 26141 | 12 | 0 |
288368 | 288368 | 2020-06-30 | Roscommon | Michigan | 26143 | 26 | 0 |
288369 | 288369 | 2020-06-30 | Saginaw | Michigan | 26145 | 1287 | 123 |
288370 | 288370 | 2020-06-30 | Sanilac | Michigan | 26151 | 47 | 6 |
288371 | 288371 | 2020-06-30 | Schoolcraft | Michigan | 26153 | 4 | 0 |
288372 | 288372 | 2020-06-30 | Shiawassee | Michigan | 26155 | 273 | 28 |
288373 | 288373 | 2020-06-30 | St. Clair | Michigan | 26147 | 560 | 50 |
288374 | 288374 | 2020-06-30 | St. Joseph | Michigan | 26149 | 320 | 4 |
288375 | 288375 | 2020-06-30 | Tuscola | Michigan | 26157 | 232 | 26 |
288376 | 288376 | 2020-06-30 | Unknown | Michigan | 164 | 2 | |
288377 | 288377 | 2020-06-30 | Van Buren | Michigan | 26159 | 225 | 8 |
288378 | 288378 | 2020-06-30 | Washtenaw | Michigan | 26161 | 2192 | 115 |
288379 | 288379 | 2020-06-30 | Wayne | Michigan | 26163 | 22791 | 2722 |
288380 | 288380 | 2020-06-30 | Wexford | Michigan | 26165 | 32 | 4 |
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);