ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-12-29" 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 |
---|---|---|---|---|---|---|---|
876245 | 876245 | 2020-12-29 | Alcona | Michigan | 26001 | 333 | 14 |
876246 | 876246 | 2020-12-29 | Alger | Michigan | 26003 | 444 | 2 |
876247 | 876247 | 2020-12-29 | Allegan | Michigan | 26005 | 5703 | 66 |
876248 | 876248 | 2020-12-29 | Alpena | Michigan | 26007 | 1134 | 25 |
876249 | 876249 | 2020-12-29 | Antrim | Michigan | 26009 | 618 | 9 |
876250 | 876250 | 2020-12-29 | Arenac | Michigan | 26011 | 593 | 24 |
876251 | 876251 | 2020-12-29 | Baraga | Michigan | 26013 | 608 | 28 |
876252 | 876252 | 2020-12-29 | Barry | Michigan | 26015 | 2946 | 34 |
876253 | 876253 | 2020-12-29 | Bay | Michigan | 26017 | 6163 | 186 |
876254 | 876254 | 2020-12-29 | Benzie | Michigan | 26019 | 652 | 26 |
876255 | 876255 | 2020-12-29 | Berrien | Michigan | 26021 | 9191 | 189 |
876256 | 876256 | 2020-12-29 | Branch | Michigan | 26023 | 3864 | 91 |
876257 | 876257 | 2020-12-29 | Calhoun | Michigan | 26025 | 7750 | 189 |
876258 | 876258 | 2020-12-29 | Cass | Michigan | 26027 | 3127 | 45 |
876259 | 876259 | 2020-12-29 | Charlevoix | Michigan | 26029 | 849 | 9 |
876260 | 876260 | 2020-12-29 | Cheboygan | Michigan | 26031 | 734 | 33 |
876261 | 876261 | 2020-12-29 | Chippewa | Michigan | 26033 | 2760 | 20 |
876262 | 876262 | 2020-12-29 | Clare | Michigan | 26035 | 1219 | 41 |
876263 | 876263 | 2020-12-29 | Clinton | Michigan | 26037 | 3834 | 39 |
876264 | 876264 | 2020-12-29 | Crawford | Michigan | 26039 | 455 | 6 |
876265 | 876265 | 2020-12-29 | Delta | Michigan | 26041 | 2878 | 77 |
876266 | 876266 | 2020-12-29 | Dickinson | Michigan | 26043 | 2160 | 68 |
876267 | 876267 | 2020-12-29 | Eaton | Michigan | 26045 | 4620 | 89 |
876268 | 876268 | 2020-12-29 | Emmet | Michigan | 26047 | 1207 | 33 |
876269 | 876269 | 2020-12-29 | Genesee | Michigan | 26049 | 21479 | 591 |
876270 | 876270 | 2020-12-29 | Gladwin | Michigan | 26051 | 1179 | 33 |
876271 | 876271 | 2020-12-29 | Gogebic | Michigan | 26053 | 1000 | 38 |
876272 | 876272 | 2020-12-29 | Grand Traverse | Michigan | 26055 | 3018 | 45 |
876273 | 876273 | 2020-12-29 | Gratiot | Michigan | 26057 | 4087 | 69 |
876274 | 876274 | 2020-12-29 | Hillsdale | Michigan | 26059 | 2561 | 57 |
876275 | 876275 | 2020-12-29 | Houghton | Michigan | 26061 | 1965 | 32 |
876276 | 876276 | 2020-12-29 | Huron | Michigan | 26063 | 1519 | 42 |
876277 | 876277 | 2020-12-29 | Ingham | Michigan | 26065 | 12510 | 183 |
876278 | 876278 | 2020-12-29 | Ionia | Michigan | 26067 | 4807 | 46 |
876279 | 876279 | 2020-12-29 | Iosco | Michigan | 26069 | 1100 | 46 |
876280 | 876280 | 2020-12-29 | Iron | Michigan | 26071 | 809 | 37 |
876281 | 876281 | 2020-12-29 | Isabella | Michigan | 26073 | 3403 | 42 |
876282 | 876282 | 2020-12-29 | Jackson | Michigan | 26075 | 10287 | 176 |
876283 | 876283 | 2020-12-29 | Kalamazoo | Michigan | 26077 | 12160 | 240 |
876284 | 876284 | 2020-12-29 | Kalkaska | Michigan | 26079 | 492 | 12 |
876285 | 876285 | 2020-12-29 | Kent | Michigan | 26081 | 42942 | 539 |
876286 | 876286 | 2020-12-29 | Keweenaw | Michigan | 26083 | 81 | 2 |
876287 | 876287 | 2020-12-29 | Lake | Michigan | 26085 | 303 | 9 |
876288 | 876288 | 2020-12-29 | Lapeer | Michigan | 26087 | 4304 | 108 |
876289 | 876289 | 2020-12-29 | Leelanau | Michigan | 26089 | 623 | 6 |
876290 | 876290 | 2020-12-29 | Lenawee | Michigan | 26091 | 5314 | 66 |
876291 | 876291 | 2020-12-29 | Livingston | Michigan | 26093 | 7853 | 74 |
876292 | 876292 | 2020-12-29 | Luce | Michigan | 26095 | 976 | 0 |
876293 | 876293 | 2020-12-29 | Mackinac | Michigan | 26097 | 377 | 2 |
876294 | 876294 | 2020-12-29 | Macomb | Michigan | 26099 | 49460 | 1603 |
876295 | 876295 | 2020-12-29 | Manistee | Michigan | 26101 | 608 | 15 |
876296 | 876296 | 2020-12-29 | Marquette | Michigan | 26103 | 4386 | 52 |
876297 | 876297 | 2020-12-29 | Mason | Michigan | 26105 | 975 | 19 |
876298 | 876298 | 2020-12-29 | Mecosta | Michigan | 26107 | 1646 | 14 |
876299 | 876299 | 2020-12-29 | Menominee | Michigan | 26109 | 1671 | 25 |
876300 | 876300 | 2020-12-29 | Midland | Michigan | 26111 | 3978 | 44 |
876301 | 876301 | 2020-12-29 | Missaukee | Michigan | 26113 | 448 | 8 |
876302 | 876302 | 2020-12-29 | Monroe | Michigan | 26115 | 7535 | 147 |
876303 | 876303 | 2020-12-29 | Montcalm | Michigan | 26117 | 3187 | 65 |
876304 | 876304 | 2020-12-29 | Montmorency | Michigan | 26119 | 285 | 9 |
876305 | 876305 | 2020-12-29 | Muskegon | Michigan | 26121 | 11033 | 268 |
876306 | 876306 | 2020-12-29 | Newaygo | Michigan | 26123 | 2241 | 32 |
876307 | 876307 | 2020-12-29 | Oakland | Michigan | 26125 | 60724 | 1632 |
876308 | 876308 | 2020-12-29 | Oceana | Michigan | 26127 | 1603 | 42 |
876309 | 876309 | 2020-12-29 | Ogemaw | Michigan | 26129 | 912 | 29 |
876310 | 876310 | 2020-12-29 | Ontonagon | Michigan | 26131 | 306 | 16 |
876311 | 876311 | 2020-12-29 | Osceola | Michigan | 26133 | 835 | 17 |
876312 | 876312 | 2020-12-29 | Oscoda | Michigan | 26135 | 307 | 15 |
876313 | 876313 | 2020-12-29 | Otsego | Michigan | 26137 | 1026 | 22 |
876314 | 876314 | 2020-12-29 | Ottawa | Michigan | 26139 | 18346 | 271 |
876315 | 876315 | 2020-12-29 | Presque Isle | Michigan | 26141 | 522 | 9 |
876316 | 876316 | 2020-12-29 | Roscommon | Michigan | 26143 | 959 | 27 |
876317 | 876317 | 2020-12-29 | Saginaw | Michigan | 26145 | 12203 | 376 |
876318 | 876318 | 2020-12-29 | Sanilac | Michigan | 26151 | 1482 | 57 |
876319 | 876319 | 2020-12-29 | Schoolcraft | Michigan | 26153 | 221 | 4 |
876320 | 876320 | 2020-12-29 | Shiawassee | Michigan | 26155 | 2918 | 57 |
876321 | 876321 | 2020-12-29 | St. Clair | Michigan | 26147 | 6918 | 155 |
876322 | 876322 | 2020-12-29 | St. Joseph | Michigan | 26149 | 3556 | 50 |
876323 | 876323 | 2020-12-29 | Tuscola | Michigan | 26157 | 2618 | 89 |
876324 | 876324 | 2020-12-29 | Unknown | Michigan | 7105 | 36 | |
876325 | 876325 | 2020-12-29 | Van Buren | Michigan | 26159 | 4026 | 78 |
876326 | 876326 | 2020-12-29 | Washtenaw | Michigan | 26161 | 14064 | 199 |
876327 | 876327 | 2020-12-29 | Wayne | Michigan | 26163 | 84478 | 3618 |
876328 | 876328 | 2020-12-29 | Wexford | Michigan | 26165 | 990 | 18 |
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);