ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-09-13" 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 |
---|---|---|---|---|---|---|---|
529191 | 529191 | 2020-09-13 | Alcona | Michigan | 26001 | 40 | 2 |
529192 | 529192 | 2020-09-13 | Alger | Michigan | 26003 | 17 | 0 |
529193 | 529193 | 2020-09-13 | Allegan | Michigan | 26005 | 694 | 7 |
529194 | 529194 | 2020-09-13 | Alpena | Michigan | 26007 | 132 | 14 |
529195 | 529195 | 2020-09-13 | Antrim | Michigan | 26009 | 64 | 0 |
529196 | 529196 | 2020-09-13 | Arenac | Michigan | 26011 | 66 | 3 |
529197 | 529197 | 2020-09-13 | Baraga | Michigan | 26013 | 11 | 0 |
529198 | 529198 | 2020-09-13 | Barry | Michigan | 26015 | 257 | 2 |
529199 | 529199 | 2020-09-13 | Bay | Michigan | 26017 | 903 | 46 |
529200 | 529200 | 2020-09-13 | Benzie | Michigan | 26019 | 63 | 2 |
529201 | 529201 | 2020-09-13 | Berrien | Michigan | 26021 | 1799 | 72 |
529202 | 529202 | 2020-09-13 | Branch | Michigan | 26023 | 1360 | 27 |
529203 | 529203 | 2020-09-13 | Calhoun | Michigan | 26025 | 1130 | 44 |
529204 | 529204 | 2020-09-13 | Cass | Michigan | 26027 | 466 | 16 |
529205 | 529205 | 2020-09-13 | Charlevoix | Michigan | 26029 | 93 | 3 |
529206 | 529206 | 2020-09-13 | Cheboygan | Michigan | 26031 | 86 | 2 |
529207 | 529207 | 2020-09-13 | Chippewa | Michigan | 26033 | 67 | 0 |
529208 | 529208 | 2020-09-13 | Clare | Michigan | 26035 | 107 | 4 |
529209 | 529209 | 2020-09-13 | Clinton | Michigan | 26037 | 591 | 13 |
529210 | 529210 | 2020-09-13 | Crawford | Michigan | 26039 | 116 | 5 |
529211 | 529211 | 2020-09-13 | Delta | Michigan | 26041 | 211 | 4 |
529212 | 529212 | 2020-09-13 | Dickinson | Michigan | 26043 | 73 | 2 |
529213 | 529213 | 2020-09-13 | Eaton | Michigan | 26045 | 569 | 10 |
529214 | 529214 | 2020-09-13 | Emmet | Michigan | 26047 | 136 | 4 |
529215 | 529215 | 2020-09-13 | Genesee | Michigan | 26049 | 4104 | 306 |
529216 | 529216 | 2020-09-13 | Gladwin | Michigan | 26051 | 84 | 2 |
529217 | 529217 | 2020-09-13 | Gogebic | Michigan | 26053 | 149 | 1 |
529218 | 529218 | 2020-09-13 | Grand Traverse | Michigan | 26055 | 432 | 7 |
529219 | 529219 | 2020-09-13 | Gratiot | Michigan | 26057 | 222 | 15 |
529220 | 529220 | 2020-09-13 | Hillsdale | Michigan | 26059 | 313 | 27 |
529221 | 529221 | 2020-09-13 | Houghton | Michigan | 26061 | 210 | 1 |
529222 | 529222 | 2020-09-13 | Huron | Michigan | 26063 | 205 | 5 |
529223 | 529223 | 2020-09-13 | Ingham | Michigan | 26065 | 2525 | 42 |
529224 | 529224 | 2020-09-13 | Ionia | Michigan | 26067 | 366 | 7 |
529225 | 529225 | 2020-09-13 | Iosco | Michigan | 26069 | 167 | 12 |
529226 | 529226 | 2020-09-13 | Iron | Michigan | 26071 | 48 | 1 |
529227 | 529227 | 2020-09-13 | Isabella | Michigan | 26073 | 606 | 10 |
529228 | 529228 | 2020-09-13 | Jackson | Michigan | 26075 | 2665 | 64 |
529229 | 529229 | 2020-09-13 | Kalamazoo | Michigan | 26077 | 2276 | 91 |
529230 | 529230 | 2020-09-13 | Kalkaska | Michigan | 26079 | 76 | 4 |
529231 | 529231 | 2020-09-13 | Kent | Michigan | 26081 | 9015 | 172 |
529232 | 529232 | 2020-09-13 | Keweenaw | Michigan | 26083 | 7 | 0 |
529233 | 529233 | 2020-09-13 | Lake | Michigan | 26085 | 32 | 0 |
529234 | 529234 | 2020-09-13 | Lapeer | Michigan | 26087 | 872 | 44 |
529235 | 529235 | 2020-09-13 | Leelanau | Michigan | 26089 | 103 | 1 |
529236 | 529236 | 2020-09-13 | Lenawee | Michigan | 26091 | 1460 | 18 |
529237 | 529237 | 2020-09-13 | Livingston | Michigan | 26093 | 1291 | 30 |
529238 | 529238 | 2020-09-13 | Luce | Michigan | 26095 | 215 | 0 |
529239 | 529239 | 2020-09-13 | Mackinac | Michigan | 26097 | 51 | 0 |
529240 | 529240 | 2020-09-13 | Macomb | Michigan | 26099 | 13917 | 1007 |
529241 | 529241 | 2020-09-13 | Manistee | Michigan | 26101 | 79 | 2 |
529242 | 529242 | 2020-09-13 | Marquette | Michigan | 26103 | 285 | 11 |
529243 | 529243 | 2020-09-13 | Mason | Michigan | 26105 | 130 | 0 |
529244 | 529244 | 2020-09-13 | Mecosta | Michigan | 26107 | 163 | 2 |
529245 | 529245 | 2020-09-13 | Menominee | Michigan | 26109 | 267 | 0 |
529246 | 529246 | 2020-09-13 | Midland | Michigan | 26111 | 508 | 11 |
529247 | 529247 | 2020-09-13 | Missaukee | Michigan | 26113 | 54 | 1 |
529248 | 529248 | 2020-09-13 | Monroe | Michigan | 26115 | 1427 | 29 |
529249 | 529249 | 2020-09-13 | Montcalm | Michigan | 26117 | 259 | 4 |
529250 | 529250 | 2020-09-13 | Montmorency | Michigan | 26119 | 13 | 0 |
529251 | 529251 | 2020-09-13 | Muskegon | Michigan | 26121 | 2321 | 70 |
529252 | 529252 | 2020-09-13 | Newaygo | Michigan | 26123 | 310 | 1 |
529253 | 529253 | 2020-09-13 | Oakland | Michigan | 26125 | 19348 | 1184 |
529254 | 529254 | 2020-09-13 | Oceana | Michigan | 26127 | 501 | 6 |
529255 | 529255 | 2020-09-13 | Ogemaw | Michigan | 26129 | 60 | 5 |
529256 | 529256 | 2020-09-13 | Ontonagon | Michigan | 26131 | 37 | 0 |
529257 | 529257 | 2020-09-13 | Osceola | Michigan | 26133 | 86 | 0 |
529258 | 529258 | 2020-09-13 | Oscoda | Michigan | 26135 | 29 | 1 |
529259 | 529259 | 2020-09-13 | Otsego | Michigan | 26137 | 168 | 11 |
529260 | 529260 | 2020-09-13 | Ottawa | Michigan | 26139 | 2934 | 65 |
529261 | 529261 | 2020-09-13 | Presque Isle | Michigan | 26141 | 23 | 1 |
529262 | 529262 | 2020-09-13 | Roscommon | Michigan | 26143 | 83 | 4 |
529263 | 529263 | 2020-09-13 | Saginaw | Michigan | 26145 | 2761 | 134 |
529264 | 529264 | 2020-09-13 | Sanilac | Michigan | 26151 | 132 | 7 |
529265 | 529265 | 2020-09-13 | Schoolcraft | Michigan | 26153 | 17 | 0 |
529266 | 529266 | 2020-09-13 | Shiawassee | Michigan | 26155 | 472 | 30 |
529267 | 529267 | 2020-09-13 | St. Clair | Michigan | 26147 | 958 | 53 |
529268 | 529268 | 2020-09-13 | St. Joseph | Michigan | 26149 | 708 | 11 |
529269 | 529269 | 2020-09-13 | Tuscola | Michigan | 26157 | 471 | 29 |
529270 | 529270 | 2020-09-13 | Unknown | Michigan | 258 | 3 | |
529271 | 529271 | 2020-09-13 | Van Buren | Michigan | 26159 | 700 | 17 |
529272 | 529272 | 2020-09-13 | Washtenaw | Michigan | 26161 | 3657 | 124 |
529273 | 529273 | 2020-09-13 | Wayne | Michigan | 26163 | 33276 | 2943 |
529274 | 529274 | 2020-09-13 | Wexford | Michigan | 26165 | 118 | 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);