ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2022-03-21 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 |
---|---|---|---|---|---|---|---|
2328288 | 2328288 | 2022-03-21 | Alcona | Michigan | 26001 | 1726 | 71 |
2328289 | 2328289 | 2022-03-21 | Alger | Michigan | 26003 | 1863 | 13 |
2328290 | 2328290 | 2022-03-21 | Allegan | Michigan | 26005 | 26985 | 342 |
2328291 | 2328291 | 2022-03-21 | Alpena | Michigan | 26007 | 5574 | 134 |
2328292 | 2328292 | 2022-03-21 | Antrim | Michigan | 26009 | 4295 | 62 |
2328293 | 2328293 | 2022-03-21 | Arenac | Michigan | 26011 | 3195 | 67 |
2328294 | 2328294 | 2022-03-21 | Baraga | Michigan | 26013 | 2203 | 54 |
2328295 | 2328295 | 2022-03-21 | Barry | Michigan | 26015 | 14247 | 166 |
2328296 | 2328296 | 2022-03-21 | Bay | Michigan | 26017 | 26958 | 573 |
2328297 | 2328297 | 2022-03-21 | Benzie | Michigan | 26019 | 3416 | 65 |
2328298 | 2328298 | 2022-03-21 | Berrien | Michigan | 26021 | 34564 | 539 |
2328299 | 2328299 | 2022-03-21 | Branch | Michigan | 26023 | 12127 | 204 |
2328300 | 2328300 | 2022-03-21 | Calhoun | Michigan | 26025 | 33965 | 564 |
2328301 | 2328301 | 2022-03-21 | Cass | Michigan | 26027 | 11079 | 140 |
2328302 | 2328302 | 2022-03-21 | Charlevoix | Michigan | 26029 | 4898 | 60 |
2328303 | 2328303 | 2022-03-21 | Cheboygan | Michigan | 26031 | 4579 | 102 |
2328304 | 2328304 | 2022-03-21 | Chippewa | Michigan | 26033 | 11562 | 117 |
2328305 | 2328305 | 2022-03-21 | Clare | Michigan | 26035 | 6721 | 156 |
2328306 | 2328306 | 2022-03-21 | Clinton | Michigan | 26037 | 21100 | 206 |
2328307 | 2328307 | 2022-03-21 | Crawford | Michigan | 26039 | 2549 | 30 |
2328308 | 2328308 | 2022-03-21 | Delta | Michigan | 26041 | 9916 | 154 |
2328309 | 2328309 | 2022-03-21 | Dickinson | Michigan | 26043 | 7361 | 108 |
2328310 | 2328310 | 2022-03-21 | Eaton | Michigan | 26045 | 26657 | 393 |
2328311 | 2328311 | 2022-03-21 | Emmet | Michigan | 26047 | 6354 | 86 |
2328312 | 2328312 | 2022-03-21 | Genesee | Michigan | 26049 | 100727 | 1692 |
2328313 | 2328313 | 2022-03-21 | Gladwin | Michigan | 26051 | 5558 | 112 |
2328314 | 2328314 | 2022-03-21 | Gogebic | Michigan | 26053 | 3245 | 68 |
2328315 | 2328315 | 2022-03-21 | Grand Traverse | Michigan | 26055 | 17115 | 225 |
2328316 | 2328316 | 2022-03-21 | Gratiot | Michigan | 26057 | 13635 | 182 |
2328317 | 2328317 | 2022-03-21 | Hillsdale | Michigan | 26059 | 10301 | 202 |
2328318 | 2328318 | 2022-03-21 | Houghton | Michigan | 26061 | 7760 | 89 |
2328319 | 2328319 | 2022-03-21 | Huron | Michigan | 26063 | 7997 | 146 |
2328320 | 2328320 | 2022-03-21 | Ingham | Michigan | 26065 | 63618 | 750 |
2328321 | 2328321 | 2022-03-21 | Ionia | Michigan | 26067 | 19455 | 179 |
2328322 | 2328322 | 2022-03-21 | Iosco | Michigan | 26069 | 4793 | 138 |
2328323 | 2328323 | 2022-03-21 | Iron | Michigan | 26071 | 2643 | 86 |
2328324 | 2328324 | 2022-03-21 | Isabella | Michigan | 26073 | 15494 | 203 |
2328325 | 2328325 | 2022-03-21 | Jackson | Michigan | 26075 | 44444 | 576 |
2328326 | 2328326 | 2022-03-21 | Kalamazoo | Michigan | 26077 | 58764 | 665 |
2328327 | 2328327 | 2022-03-21 | Kalkaska | Michigan | 26079 | 3514 | 60 |
2328328 | 2328328 | 2022-03-21 | Kent | Michigan | 26081 | 165835 | 1501 |
2328329 | 2328329 | 2022-03-21 | Keweenaw | Michigan | 26083 | 504 | 13 |
2328330 | 2328330 | 2022-03-21 | Lake | Michigan | 26085 | 1836 | 37 |
2328331 | 2328331 | 2022-03-21 | Lapeer | Michigan | 26087 | 20732 | 422 |
2328332 | 2328332 | 2022-03-21 | Leelanau | Michigan | 26089 | 3555 | 52 |
2328333 | 2328333 | 2022-03-21 | Lenawee | Michigan | 26091 | 25849 | 322 |
2328334 | 2328334 | 2022-03-21 | Livingston | Michigan | 26093 | 45774 | 441 |
2328335 | 2328335 | 2022-03-21 | Luce | Michigan | 26095 | 2280 | 11 |
2328336 | 2328336 | 2022-03-21 | Mackinac | Michigan | 26097 | 2379 | 29 |
2328337 | 2328337 | 2022-03-21 | Macomb | Michigan | 26099 | 227917 | 3906 |
2328338 | 2328338 | 2022-03-21 | Manistee | Michigan | 26101 | 4448 | 88 |
2328339 | 2328339 | 2022-03-21 | Marquette | Michigan | 26103 | 15778 | 126 |
2328340 | 2328340 | 2022-03-21 | Mason | Michigan | 26105 | 6708 | 89 |
2328341 | 2328341 | 2022-03-21 | Mecosta | Michigan | 26107 | 8613 | 105 |
2328342 | 2328342 | 2022-03-21 | Menominee | Michigan | 26109 | 5601 | 69 |
2328343 | 2328343 | 2022-03-21 | Midland | Michigan | 26111 | 18992 | 222 |
2328344 | 2328344 | 2022-03-21 | Missaukee | Michigan | 26113 | 2899 | 59 |
2328345 | 2328345 | 2022-03-21 | Monroe | Michigan | 26115 | 37800 | 464 |
2328346 | 2328346 | 2022-03-21 | Montcalm | Michigan | 26117 | 17099 | 212 |
2328347 | 2328347 | 2022-03-21 | Montmorency | Michigan | 26119 | 1714 | 47 |
2328348 | 2328348 | 2022-03-21 | Muskegon | Michigan | 26121 | 41545 | 637 |
2328349 | 2328349 | 2022-03-21 | Newaygo | Michigan | 26123 | 11444 | 155 |
2328350 | 2328350 | 2022-03-21 | Oakland | Michigan | 26125 | 284496 | 3777 |
2328351 | 2328351 | 2022-03-21 | Oceana | Michigan | 26127 | 6311 | 89 |
2328352 | 2328352 | 2022-03-21 | Ogemaw | Michigan | 26129 | 4302 | 105 |
2328353 | 2328353 | 2022-03-21 | Ontonagon | Michigan | 26131 | 975 | 38 |
2328354 | 2328354 | 2022-03-21 | Osceola | Michigan | 26133 | 4977 | 80 |
2328355 | 2328355 | 2022-03-21 | Oscoda | Michigan | 26135 | 1430 | 54 |
2328356 | 2328356 | 2022-03-21 | Otsego | Michigan | 26137 | 5616 | 97 |
2328357 | 2328357 | 2022-03-21 | Ottawa | Michigan | 26139 | 74437 | 781 |
2328358 | 2328358 | 2022-03-21 | Presque Isle | Michigan | 26141 | 2059 | 56 |
2328359 | 2328359 | 2022-03-21 | Roscommon | Michigan | 26143 | 4602 | 113 |
2328360 | 2328360 | 2022-03-21 | Saginaw | Michigan | 26145 | 50208 | 937 |
2328361 | 2328361 | 2022-03-21 | Sanilac | Michigan | 26151 | 8654 | 187 |
2328362 | 2328362 | 2022-03-21 | Schoolcraft | Michigan | 26153 | 1749 | 17 |
2328363 | 2328363 | 2022-03-21 | Shiawassee | Michigan | 26155 | 17724 | 228 |
2328364 | 2328364 | 2022-03-21 | St. Clair | Michigan | 26147 | 40350 | 820 |
2328365 | 2328365 | 2022-03-21 | St. Joseph | Michigan | 26149 | 13636 | 205 |
2328366 | 2328366 | 2022-03-21 | Tuscola | Michigan | 26157 | 13195 | 274 |
2328367 | 2328367 | 2022-03-21 | Unknown | Michigan | 12073 | 36 | |
2328368 | 2328368 | 2022-03-21 | Van Buren | Michigan | 26159 | 16944 | 264 |
2328369 | 2328369 | 2022-03-21 | Washtenaw | Michigan | 26161 | 74561 | 512 |
2328370 | 2328370 | 2022-03-21 | Wayne | Michigan | 26163 | 396858 | 7825 |
2328371 | 2328371 | 2022-03-21 | Wexford | Michigan | 26165 | 7039 | 105 |
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);