ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-07-08" 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 |
---|---|---|---|---|---|---|---|
1496272 | 1496272 | 2021-07-08 | Alcona | Michigan | 26001 | 741 | 33 |
1496273 | 1496273 | 2021-07-08 | Alger | Michigan | 26003 | 670 | 7 |
1496274 | 1496274 | 2021-07-08 | Allegan | Michigan | 26005 | 11200 | 161 |
1496275 | 1496275 | 2021-07-08 | Alpena | Michigan | 26007 | 2273 | 63 |
1496276 | 1496276 | 2021-07-08 | Antrim | Michigan | 26009 | 1638 | 30 |
1496277 | 1496277 | 2021-07-08 | Arenac | Michigan | 26011 | 1212 | 29 |
1496278 | 1496278 | 2021-07-08 | Baraga | Michigan | 26013 | 994 | 40 |
1496279 | 1496279 | 2021-07-08 | Barry | Michigan | 26015 | 5969 | 69 |
1496280 | 1496280 | 2021-07-08 | Bay | Michigan | 26017 | 11266 | 355 |
1496281 | 1496281 | 2021-07-08 | Benzie | Michigan | 26019 | 1283 | 36 |
1496282 | 1496282 | 2021-07-08 | Berrien | Michigan | 26021 | 15629 | 294 |
1496283 | 1496283 | 2021-07-08 | Branch | Michigan | 26023 | 5773 | 121 |
1496284 | 1496284 | 2021-07-08 | Calhoun | Michigan | 26025 | 14589 | 319 |
1496285 | 1496285 | 2021-07-08 | Cass | Michigan | 26027 | 5507 | 77 |
1496286 | 1496286 | 2021-07-08 | Charlevoix | Michigan | 26029 | 1683 | 22 |
1496287 | 1496287 | 2021-07-08 | Cheboygan | Michigan | 26031 | 1931 | 46 |
1496288 | 1496288 | 2021-07-08 | Chippewa | Michigan | 26033 | 5633 | 50 |
1496289 | 1496289 | 2021-07-08 | Clare | Michigan | 26035 | 2483 | 86 |
1496290 | 1496290 | 2021-07-08 | Clinton | Michigan | 26037 | 7663 | 93 |
1496291 | 1496291 | 2021-07-08 | Crawford | Michigan | 26039 | 995 | 14 |
1496292 | 1496292 | 2021-07-08 | Delta | Michigan | 26041 | 4057 | 95 |
1496293 | 1496293 | 2021-07-08 | Dickinson | Michigan | 26043 | 2758 | 74 |
1496294 | 1496294 | 2021-07-08 | Eaton | Michigan | 26045 | 10161 | 212 |
1496295 | 1496295 | 2021-07-08 | Emmet | Michigan | 26047 | 2386 | 43 |
1496296 | 1496296 | 2021-07-08 | Genesee | Michigan | 26049 | 41776 | 972 |
1496297 | 1496297 | 2021-07-08 | Gladwin | Michigan | 26051 | 2305 | 61 |
1496298 | 1496298 | 2021-07-08 | Gogebic | Michigan | 26053 | 1411 | 52 |
1496299 | 1496299 | 2021-07-08 | Grand Traverse | Michigan | 26055 | 6480 | 100 |
1496300 | 1496300 | 2021-07-08 | Gratiot | Michigan | 26057 | 6987 | 125 |
1496301 | 1496301 | 2021-07-08 | Hillsdale | Michigan | 26059 | 4404 | 94 |
1496302 | 1496302 | 2021-07-08 | Houghton | Michigan | 26061 | 3143 | 43 |
1496303 | 1496303 | 2021-07-08 | Huron | Michigan | 26063 | 4094 | 82 |
1496304 | 1496304 | 2021-07-08 | Ingham | Michigan | 26065 | 24927 | 393 |
1496305 | 1496305 | 2021-07-08 | Ionia | Michigan | 26067 | 9354 | 85 |
1496306 | 1496306 | 2021-07-08 | Iosco | Michigan | 26069 | 2007 | 74 |
1496307 | 1496307 | 2021-07-08 | Iron | Michigan | 26071 | 1054 | 53 |
1496308 | 1496308 | 2021-07-08 | Isabella | Michigan | 26073 | 6343 | 100 |
1496309 | 1496309 | 2021-07-08 | Jackson | Michigan | 26075 | 21070 | 324 |
1496310 | 1496310 | 2021-07-08 | Kalamazoo | Michigan | 26077 | 23210 | 402 |
1496311 | 1496311 | 2021-07-08 | Kalkaska | Michigan | 26079 | 1144 | 27 |
1496312 | 1496312 | 2021-07-08 | Kent | Michigan | 26081 | 73776 | 860 |
1496313 | 1496313 | 2021-07-08 | Keweenaw | Michigan | 26083 | 174 | 2 |
1496314 | 1496314 | 2021-07-08 | Lake | Michigan | 26085 | 639 | 16 |
1496315 | 1496315 | 2021-07-08 | Lapeer | Michigan | 26087 | 9773 | 215 |
1496316 | 1496316 | 2021-07-08 | Leelanau | Michigan | 26089 | 1244 | 19 |
1496317 | 1496317 | 2021-07-08 | Lenawee | Michigan | 26091 | 10857 | 178 |
1496318 | 1496318 | 2021-07-08 | Livingston | Michigan | 26093 | 16820 | 198 |
1496319 | 1496319 | 2021-07-08 | Luce | Michigan | 26095 | 1338 | 6 |
1496320 | 1496320 | 2021-07-08 | Mackinac | Michigan | 26097 | 714 | 3 |
1496321 | 1496321 | 2021-07-08 | Macomb | Michigan | 26099 | 100713 | 2500 |
1496322 | 1496322 | 2021-07-08 | Manistee | Michigan | 26101 | 1981 | 24 |
1496323 | 1496323 | 2021-07-08 | Marquette | Michigan | 26103 | 5941 | 65 |
1496324 | 1496324 | 2021-07-08 | Mason | Michigan | 26105 | 2141 | 37 |
1496325 | 1496325 | 2021-07-08 | Mecosta | Michigan | 26107 | 3220 | 36 |
1496326 | 1496326 | 2021-07-08 | Menominee | Michigan | 26109 | 2132 | 44 |
1496327 | 1496327 | 2021-07-08 | Midland | Michigan | 26111 | 7581 | 94 |
1496328 | 1496328 | 2021-07-08 | Missaukee | Michigan | 26113 | 1515 | 27 |
1496329 | 1496329 | 2021-07-08 | Monroe | Michigan | 26115 | 15442 | 264 |
1496330 | 1496330 | 2021-07-08 | Montcalm | Michigan | 26117 | 8211 | 120 |
1496331 | 1496331 | 2021-07-08 | Montmorency | Michigan | 26119 | 618 | 20 |
1496332 | 1496332 | 2021-07-08 | Muskegon | Michigan | 26121 | 18444 | 382 |
1496333 | 1496333 | 2021-07-08 | Newaygo | Michigan | 26123 | 4904 | 69 |
1496334 | 1496334 | 2021-07-08 | Oakland | Michigan | 26125 | 118859 | 2450 |
1496335 | 1496335 | 2021-07-08 | Oceana | Michigan | 26127 | 2771 | 60 |
1496336 | 1496336 | 2021-07-08 | Ogemaw | Michigan | 26129 | 1747 | 43 |
1496337 | 1496337 | 2021-07-08 | Ontonagon | Michigan | 26131 | 482 | 21 |
1496338 | 1496338 | 2021-07-08 | Osceola | Michigan | 26133 | 1962 | 31 |
1496339 | 1496339 | 2021-07-08 | Oscoda | Michigan | 26135 | 692 | 31 |
1496340 | 1496340 | 2021-07-08 | Otsego | Michigan | 26137 | 2368 | 41 |
1496341 | 1496341 | 2021-07-08 | Ottawa | Michigan | 26139 | 32966 | 441 |
1496342 | 1496342 | 2021-07-08 | Presque Isle | Michigan | 26141 | 1057 | 34 |
1496343 | 1496343 | 2021-07-08 | Roscommon | Michigan | 26143 | 1901 | 55 |
1496344 | 1496344 | 2021-07-08 | Saginaw | Michigan | 26145 | 22535 | 634 |
1496345 | 1496345 | 2021-07-08 | Sanilac | Michigan | 26151 | 4261 | 125 |
1496346 | 1496346 | 2021-07-08 | Schoolcraft | Michigan | 26153 | 438 | 5 |
1496347 | 1496347 | 2021-07-08 | Shiawassee | Michigan | 26155 | 6441 | 108 |
1496348 | 1496348 | 2021-07-08 | St. Clair | Michigan | 26147 | 18520 | 449 |
1496349 | 1496349 | 2021-07-08 | St. Joseph | Michigan | 26149 | 6259 | 101 |
1496350 | 1496350 | 2021-07-08 | Tuscola | Michigan | 26157 | 5670 | 174 |
1496351 | 1496351 | 2021-07-08 | Unknown | Michigan | 736 | 15 | |
1496352 | 1496352 | 2021-07-08 | Van Buren | Michigan | 26159 | 7153 | 131 |
1496353 | 1496353 | 2021-07-08 | Washtenaw | Michigan | 26161 | 27175 | 311 |
1496354 | 1496354 | 2021-07-08 | Wayne | Michigan | 26163 | 166249 | 5174 |
1496355 | 1496355 | 2021-07-08 | Wexford | Michigan | 26165 | 2903 | 48 |
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);