ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-09-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 |
---|---|---|---|---|---|---|---|
584249 | 584249 | 2020-09-30 | Alcona | Michigan | 26001 | 47 | 2 |
584250 | 584250 | 2020-09-30 | Alger | Michigan | 26003 | 19 | 0 |
584251 | 584251 | 2020-09-30 | Allegan | Michigan | 26005 | 785 | 7 |
584252 | 584252 | 2020-09-30 | Alpena | Michigan | 26007 | 148 | 14 |
584253 | 584253 | 2020-09-30 | Antrim | Michigan | 26009 | 72 | 0 |
584254 | 584254 | 2020-09-30 | Arenac | Michigan | 26011 | 71 | 3 |
584255 | 584255 | 2020-09-30 | Baraga | Michigan | 26013 | 37 | 2 |
584256 | 584256 | 2020-09-30 | Barry | Michigan | 26015 | 326 | 4 |
584257 | 584257 | 2020-09-30 | Bay | Michigan | 26017 | 1027 | 52 |
584258 | 584258 | 2020-09-30 | Benzie | Michigan | 26019 | 84 | 2 |
584259 | 584259 | 2020-09-30 | Berrien | Michigan | 26021 | 1981 | 74 |
584260 | 584260 | 2020-09-30 | Branch | Michigan | 26023 | 1455 | 28 |
584261 | 584261 | 2020-09-30 | Calhoun | Michigan | 26025 | 1492 | 46 |
584262 | 584262 | 2020-09-30 | Cass | Michigan | 26027 | 611 | 17 |
584263 | 584263 | 2020-09-30 | Charlevoix | Michigan | 26029 | 112 | 3 |
584264 | 584264 | 2020-09-30 | Cheboygan | Michigan | 26031 | 93 | 2 |
584265 | 584265 | 2020-09-30 | Chippewa | Michigan | 26033 | 81 | 0 |
584266 | 584266 | 2020-09-30 | Clare | Michigan | 26035 | 113 | 4 |
584267 | 584267 | 2020-09-30 | Clinton | Michigan | 26037 | 699 | 14 |
584268 | 584268 | 2020-09-30 | Crawford | Michigan | 26039 | 127 | 5 |
584269 | 584269 | 2020-09-30 | Delta | Michigan | 26041 | 560 | 8 |
584270 | 584270 | 2020-09-30 | Dickinson | Michigan | 26043 | 174 | 2 |
584271 | 584271 | 2020-09-30 | Eaton | Michigan | 26045 | 694 | 10 |
584272 | 584272 | 2020-09-30 | Emmet | Michigan | 26047 | 162 | 4 |
584273 | 584273 | 2020-09-30 | Genesee | Michigan | 26049 | 4727 | 309 |
584274 | 584274 | 2020-09-30 | Gladwin | Michigan | 26051 | 105 | 2 |
584275 | 584275 | 2020-09-30 | Gogebic | Michigan | 26053 | 167 | 2 |
584276 | 584276 | 2020-09-30 | Grand Traverse | Michigan | 26055 | 496 | 9 |
584277 | 584277 | 2020-09-30 | Gratiot | Michigan | 26057 | 298 | 15 |
584278 | 584278 | 2020-09-30 | Hillsdale | Michigan | 26059 | 358 | 27 |
584279 | 584279 | 2020-09-30 | Houghton | Michigan | 26061 | 562 | 2 |
584280 | 584280 | 2020-09-30 | Huron | Michigan | 26063 | 227 | 5 |
584281 | 584281 | 2020-09-30 | Ingham | Michigan | 26065 | 3607 | 49 |
584282 | 584282 | 2020-09-30 | Ionia | Michigan | 26067 | 535 | 7 |
584283 | 584283 | 2020-09-30 | Iosco | Michigan | 26069 | 228 | 12 |
584284 | 584284 | 2020-09-30 | Iron | Michigan | 26071 | 203 | 4 |
584285 | 584285 | 2020-09-30 | Isabella | Michigan | 26073 | 724 | 14 |
584286 | 584286 | 2020-09-30 | Jackson | Michigan | 26075 | 2864 | 67 |
584287 | 584287 | 2020-09-30 | Kalamazoo | Michigan | 26077 | 3053 | 96 |
584288 | 584288 | 2020-09-30 | Kalkaska | Michigan | 26079 | 90 | 4 |
584289 | 584289 | 2020-09-30 | Kent | Michigan | 26081 | 10193 | 176 |
584290 | 584290 | 2020-09-30 | Keweenaw | Michigan | 26083 | 11 | 0 |
584291 | 584291 | 2020-09-30 | Lake | Michigan | 26085 | 35 | 0 |
584292 | 584292 | 2020-09-30 | Lapeer | Michigan | 26087 | 943 | 43 |
584293 | 584293 | 2020-09-30 | Leelanau | Michigan | 26089 | 115 | 1 |
584294 | 584294 | 2020-09-30 | Lenawee | Michigan | 26091 | 1572 | 22 |
584295 | 584295 | 2020-09-30 | Livingston | Michigan | 26093 | 1471 | 33 |
584296 | 584296 | 2020-09-30 | Luce | Michigan | 26095 | 238 | 0 |
584297 | 584297 | 2020-09-30 | Mackinac | Michigan | 26097 | 68 | 0 |
584298 | 584298 | 2020-09-30 | Macomb | Michigan | 26099 | 15063 | 1029 |
584299 | 584299 | 2020-09-30 | Manistee | Michigan | 26101 | 93 | 3 |
584300 | 584300 | 2020-09-30 | Marquette | Michigan | 26103 | 397 | 12 |
584301 | 584301 | 2020-09-30 | Mason | Michigan | 26105 | 137 | 0 |
584302 | 584302 | 2020-09-30 | Mecosta | Michigan | 26107 | 228 | 3 |
584303 | 584303 | 2020-09-30 | Menominee | Michigan | 26109 | 419 | 2 |
584304 | 584304 | 2020-09-30 | Midland | Michigan | 26111 | 629 | 11 |
584305 | 584305 | 2020-09-30 | Missaukee | Michigan | 26113 | 64 | 1 |
584306 | 584306 | 2020-09-30 | Monroe | Michigan | 26115 | 1548 | 28 |
584307 | 584307 | 2020-09-30 | Montcalm | Michigan | 26117 | 344 | 6 |
584308 | 584308 | 2020-09-30 | Montmorency | Michigan | 26119 | 16 | 0 |
584309 | 584309 | 2020-09-30 | Muskegon | Michigan | 26121 | 2493 | 72 |
584310 | 584310 | 2020-09-30 | Newaygo | Michigan | 26123 | 390 | 2 |
584311 | 584311 | 2020-09-30 | Oakland | Michigan | 26125 | 20854 | 1203 |
584312 | 584312 | 2020-09-30 | Oceana | Michigan | 26127 | 528 | 6 |
584313 | 584313 | 2020-09-30 | Ogemaw | Michigan | 26129 | 68 | 5 |
584314 | 584314 | 2020-09-30 | Ontonagon | Michigan | 26131 | 43 | 0 |
584315 | 584315 | 2020-09-30 | Osceola | Michigan | 26133 | 99 | 0 |
584316 | 584316 | 2020-09-30 | Oscoda | Michigan | 26135 | 31 | 1 |
584317 | 584317 | 2020-09-30 | Otsego | Michigan | 26137 | 182 | 11 |
584318 | 584318 | 2020-09-30 | Ottawa | Michigan | 26139 | 3533 | 66 |
584319 | 584319 | 2020-09-30 | Presque Isle | Michigan | 26141 | 27 | 1 |
584320 | 584320 | 2020-09-30 | Roscommon | Michigan | 26143 | 102 | 4 |
584321 | 584321 | 2020-09-30 | Saginaw | Michigan | 26145 | 3007 | 140 |
584322 | 584322 | 2020-09-30 | Sanilac | Michigan | 26151 | 151 | 7 |
584323 | 584323 | 2020-09-30 | Schoolcraft | Michigan | 26153 | 29 | 0 |
584324 | 584324 | 2020-09-30 | Shiawassee | Michigan | 26155 | 525 | 32 |
584325 | 584325 | 2020-09-30 | St. Clair | Michigan | 26147 | 1036 | 57 |
584326 | 584326 | 2020-09-30 | St. Joseph | Michigan | 26149 | 807 | 11 |
584327 | 584327 | 2020-09-30 | Tuscola | Michigan | 26157 | 514 | 31 |
584328 | 584328 | 2020-09-30 | Unknown | Michigan | 167 | 5 | |
584329 | 584329 | 2020-09-30 | Van Buren | Michigan | 26159 | 776 | 17 |
584330 | 584330 | 2020-09-30 | Washtenaw | Michigan | 26161 | 4300 | 126 |
584331 | 584331 | 2020-09-30 | Wayne | Michigan | 26163 | 35481 | 2986 |
584332 | 584332 | 2020-09-30 | Wexford | Michigan | 26165 | 133 | 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);