ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-01-06" 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 |
---|---|---|---|---|---|---|---|
902209 | 902209 | 2021-01-06 | Alcona | Michigan | 26001 | 360 | 17 |
902210 | 902210 | 2021-01-06 | Alger | Michigan | 26003 | 461 | 2 |
902211 | 902211 | 2021-01-06 | Allegan | Michigan | 26005 | 6029 | 76 |
902212 | 902212 | 2021-01-06 | Alpena | Michigan | 26007 | 1220 | 32 |
902213 | 902213 | 2021-01-06 | Antrim | Michigan | 26009 | 701 | 11 |
902214 | 902214 | 2021-01-06 | Arenac | Michigan | 26011 | 625 | 25 |
902215 | 902215 | 2021-01-06 | Baraga | Michigan | 26013 | 627 | 29 |
902216 | 902216 | 2021-01-06 | Barry | Michigan | 26015 | 3110 | 38 |
902217 | 902217 | 2021-01-06 | Bay | Michigan | 26017 | 6503 | 201 |
902218 | 902218 | 2021-01-06 | Benzie | Michigan | 26019 | 719 | 27 |
902219 | 902219 | 2021-01-06 | Berrien | Michigan | 26021 | 9678 | 204 |
902220 | 902220 | 2021-01-06 | Branch | Michigan | 26023 | 4037 | 95 |
902221 | 902221 | 2021-01-06 | Calhoun | Michigan | 26025 | 8016 | 202 |
902222 | 902222 | 2021-01-06 | Cass | Michigan | 26027 | 3306 | 48 |
902223 | 902223 | 2021-01-06 | Charlevoix | Michigan | 26029 | 872 | 10 |
902224 | 902224 | 2021-01-06 | Cheboygan | Michigan | 26031 | 763 | 33 |
902225 | 902225 | 2021-01-06 | Chippewa | Michigan | 26033 | 2937 | 21 |
902226 | 902226 | 2021-01-06 | Clare | Michigan | 26035 | 1271 | 45 |
902227 | 902227 | 2021-01-06 | Clinton | Michigan | 26037 | 4209 | 44 |
902228 | 902228 | 2021-01-06 | Crawford | Michigan | 26039 | 491 | 5 |
902229 | 902229 | 2021-01-06 | Delta | Michigan | 26041 | 2953 | 78 |
902230 | 902230 | 2021-01-06 | Dickinson | Michigan | 26043 | 2235 | 70 |
902231 | 902231 | 2021-01-06 | Eaton | Michigan | 26045 | 4997 | 100 |
902232 | 902232 | 2021-01-06 | Emmet | Michigan | 26047 | 1264 | 33 |
902233 | 902233 | 2021-01-06 | Genesee | Michigan | 26049 | 22270 | 637 |
902234 | 902234 | 2021-01-06 | Gladwin | Michigan | 26051 | 1262 | 34 |
902235 | 902235 | 2021-01-06 | Gogebic | Michigan | 26053 | 1021 | 39 |
902236 | 902236 | 2021-01-06 | Grand Traverse | Michigan | 26055 | 3267 | 49 |
902237 | 902237 | 2021-01-06 | Gratiot | Michigan | 26057 | 4176 | 82 |
902238 | 902238 | 2021-01-06 | Hillsdale | Michigan | 26059 | 2744 | 58 |
902239 | 902239 | 2021-01-06 | Houghton | Michigan | 26061 | 2079 | 34 |
902240 | 902240 | 2021-01-06 | Huron | Michigan | 26063 | 1641 | 49 |
902241 | 902241 | 2021-01-06 | Ingham | Michigan | 26065 | 13212 | 196 |
902242 | 902242 | 2021-01-06 | Ionia | Michigan | 26067 | 5064 | 52 |
902243 | 902243 | 2021-01-06 | Iosco | Michigan | 26069 | 1144 | 53 |
902244 | 902244 | 2021-01-06 | Iron | Michigan | 26071 | 838 | 37 |
902245 | 902245 | 2021-01-06 | Isabella | Michigan | 26073 | 3561 | 51 |
902246 | 902246 | 2021-01-06 | Jackson | Michigan | 26075 | 10769 | 190 |
902247 | 902247 | 2021-01-06 | Kalamazoo | Michigan | 26077 | 12837 | 268 |
902248 | 902248 | 2021-01-06 | Kalkaska | Michigan | 26079 | 508 | 14 |
902249 | 902249 | 2021-01-06 | Kent | Michigan | 26081 | 45031 | 572 |
902250 | 902250 | 2021-01-06 | Keweenaw | Michigan | 26083 | 93 | 2 |
902251 | 902251 | 2021-01-06 | Lake | Michigan | 26085 | 310 | 10 |
902252 | 902252 | 2021-01-06 | Lapeer | Michigan | 26087 | 4483 | 109 |
902253 | 902253 | 2021-01-06 | Leelanau | Michigan | 26089 | 664 | 8 |
902254 | 902254 | 2021-01-06 | Lenawee | Michigan | 26091 | 5728 | 73 |
902255 | 902255 | 2021-01-06 | Livingston | Michigan | 26093 | 8385 | 82 |
902256 | 902256 | 2021-01-06 | Luce | Michigan | 26095 | 979 | 0 |
902257 | 902257 | 2021-01-06 | Mackinac | Michigan | 26097 | 391 | 3 |
902258 | 902258 | 2021-01-06 | Macomb | Michigan | 26099 | 51470 | 1663 |
902259 | 902259 | 2021-01-06 | Manistee | Michigan | 26101 | 652 | 18 |
902260 | 902260 | 2021-01-06 | Marquette | Michigan | 26103 | 4487 | 52 |
902261 | 902261 | 2021-01-06 | Mason | Michigan | 26105 | 1031 | 21 |
902262 | 902262 | 2021-01-06 | Mecosta | Michigan | 26107 | 1720 | 14 |
902263 | 902263 | 2021-01-06 | Menominee | Michigan | 26109 | 1745 | 27 |
902264 | 902264 | 2021-01-06 | Midland | Michigan | 26111 | 4235 | 49 |
902265 | 902265 | 2021-01-06 | Missaukee | Michigan | 26113 | 529 | 12 |
902266 | 902266 | 2021-01-06 | Monroe | Michigan | 26115 | 8099 | 159 |
902267 | 902267 | 2021-01-06 | Montcalm | Michigan | 26117 | 3347 | 71 |
902268 | 902268 | 2021-01-06 | Montmorency | Michigan | 26119 | 325 | 11 |
902269 | 902269 | 2021-01-06 | Muskegon | Michigan | 26121 | 11346 | 277 |
902270 | 902270 | 2021-01-06 | Newaygo | Michigan | 26123 | 2355 | 35 |
902271 | 902271 | 2021-01-06 | Oakland | Michigan | 26125 | 63751 | 1680 |
902272 | 902272 | 2021-01-06 | Oceana | Michigan | 26127 | 1666 | 43 |
902273 | 902273 | 2021-01-06 | Ogemaw | Michigan | 26129 | 959 | 29 |
902274 | 902274 | 2021-01-06 | Ontonagon | Michigan | 26131 | 309 | 16 |
902275 | 902275 | 2021-01-06 | Osceola | Michigan | 26133 | 876 | 18 |
902276 | 902276 | 2021-01-06 | Oscoda | Michigan | 26135 | 327 | 16 |
902277 | 902277 | 2021-01-06 | Otsego | Michigan | 26137 | 1042 | 24 |
902278 | 902278 | 2021-01-06 | Ottawa | Michigan | 26139 | 19160 | 287 |
902279 | 902279 | 2021-01-06 | Presque Isle | Michigan | 26141 | 555 | 16 |
902280 | 902280 | 2021-01-06 | Roscommon | Michigan | 26143 | 998 | 27 |
902281 | 902281 | 2021-01-06 | Saginaw | Michigan | 26145 | 12762 | 414 |
902282 | 902282 | 2021-01-06 | Sanilac | Michigan | 26151 | 1567 | 65 |
902283 | 902283 | 2021-01-06 | Schoolcraft | Michigan | 26153 | 237 | 4 |
902284 | 902284 | 2021-01-06 | Shiawassee | Michigan | 26155 | 3088 | 59 |
902285 | 902285 | 2021-01-06 | St. Clair | Michigan | 26147 | 7406 | 176 |
902286 | 902286 | 2021-01-06 | St. Joseph | Michigan | 26149 | 3774 | 59 |
902287 | 902287 | 2021-01-06 | Tuscola | Michigan | 26157 | 2769 | 101 |
902288 | 902288 | 2021-01-06 | Unknown | Michigan | 8180 | 43 | |
902289 | 902289 | 2021-01-06 | Van Buren | Michigan | 26159 | 4274 | 80 |
902290 | 902290 | 2021-01-06 | Washtenaw | Michigan | 26161 | 14875 | 212 |
902291 | 902291 | 2021-01-06 | Wayne | Michigan | 26163 | 88055 | 3711 |
902292 | 902292 | 2021-01-06 | Wexford | Michigan | 26165 | 1063 | 20 |
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);