ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2022-04-29" 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 |
---|---|---|---|---|---|---|---|
2455222 | 2455222 | 2022-04-29 | Alcona | Michigan | 26001 | 1733 | 71 |
2455223 | 2455223 | 2022-04-29 | Alger | Michigan | 26003 | 1867 | 13 |
2455224 | 2455224 | 2022-04-29 | Allegan | Michigan | 26005 | 27205 | 347 |
2455225 | 2455225 | 2022-04-29 | Alpena | Michigan | 26007 | 5728 | 139 |
2455226 | 2455226 | 2022-04-29 | Antrim | Michigan | 26009 | 4383 | 65 |
2455227 | 2455227 | 2022-04-29 | Arenac | Michigan | 26011 | 3210 | 67 |
2455228 | 2455228 | 2022-04-29 | Baraga | Michigan | 26013 | 2213 | 54 |
2455229 | 2455229 | 2022-04-29 | Barry | Michigan | 26015 | 14391 | 167 |
2455230 | 2455230 | 2022-04-29 | Bay | Michigan | 26017 | 27154 | 582 |
2455231 | 2455231 | 2022-04-29 | Benzie | Michigan | 26019 | 3458 | 67 |
2455232 | 2455232 | 2022-04-29 | Berrien | Michigan | 26021 | 34962 | 555 |
2455233 | 2455233 | 2022-04-29 | Branch | Michigan | 26023 | 12194 | 206 |
2455234 | 2455234 | 2022-04-29 | Calhoun | Michigan | 26025 | 34477 | 573 |
2455235 | 2455235 | 2022-04-29 | Cass | Michigan | 26027 | 11134 | 144 |
2455236 | 2455236 | 2022-04-29 | Charlevoix | Michigan | 26029 | 4943 | 60 |
2455237 | 2455237 | 2022-04-29 | Cheboygan | Michigan | 26031 | 4618 | 103 |
2455238 | 2455238 | 2022-04-29 | Chippewa | Michigan | 26033 | 11670 | 120 |
2455239 | 2455239 | 2022-04-29 | Clare | Michigan | 26035 | 6762 | 157 |
2455240 | 2455240 | 2022-04-29 | Clinton | Michigan | 26037 | 21463 | 207 |
2455241 | 2455241 | 2022-04-29 | Crawford | Michigan | 26039 | 2585 | 31 |
2455242 | 2455242 | 2022-04-29 | Delta | Michigan | 26041 | 9951 | 157 |
2455243 | 2455243 | 2022-04-29 | Dickinson | Michigan | 26043 | 7412 | 108 |
2455244 | 2455244 | 2022-04-29 | Eaton | Michigan | 26045 | 27063 | 401 |
2455245 | 2455245 | 2022-04-29 | Emmet | Michigan | 26047 | 6460 | 86 |
2455246 | 2455246 | 2022-04-29 | Genesee | Michigan | 26049 | 102026 | 1715 |
2455247 | 2455247 | 2022-04-29 | Gladwin | Michigan | 26051 | 5580 | 114 |
2455248 | 2455248 | 2022-04-29 | Gogebic | Michigan | 26053 | 3270 | 69 |
2455249 | 2455249 | 2022-04-29 | Grand Traverse | Michigan | 26055 | 17427 | 233 |
2455250 | 2455250 | 2022-04-29 | Gratiot | Michigan | 26057 | 13722 | 192 |
2455251 | 2455251 | 2022-04-29 | Hillsdale | Michigan | 26059 | 10371 | 204 |
2455252 | 2455252 | 2022-04-29 | Houghton | Michigan | 26061 | 7867 | 92 |
2455253 | 2455253 | 2022-04-29 | Huron | Michigan | 26063 | 8034 | 145 |
2455254 | 2455254 | 2022-04-29 | Ingham | Michigan | 26065 | 64895 | 765 |
2455255 | 2455255 | 2022-04-29 | Ionia | Michigan | 26067 | 19643 | 181 |
2455256 | 2455256 | 2022-04-29 | Iosco | Michigan | 26069 | 4814 | 143 |
2455257 | 2455257 | 2022-04-29 | Iron | Michigan | 26071 | 2653 | 87 |
2455258 | 2455258 | 2022-04-29 | Isabella | Michigan | 26073 | 15632 | 208 |
2455259 | 2455259 | 2022-04-29 | Jackson | Michigan | 26075 | 44948 | 588 |
2455260 | 2455260 | 2022-04-29 | Kalamazoo | Michigan | 26077 | 59847 | 673 |
2455261 | 2455261 | 2022-04-29 | Kalkaska | Michigan | 26079 | 3564 | 60 |
2455262 | 2455262 | 2022-04-29 | Kent | Michigan | 26081 | 167891 | 1531 |
2455263 | 2455263 | 2022-04-29 | Keweenaw | Michigan | 26083 | 515 | 14 |
2455264 | 2455264 | 2022-04-29 | Lake | Michigan | 26085 | 1850 | 37 |
2455265 | 2455265 | 2022-04-29 | Lapeer | Michigan | 26087 | 20909 | 427 |
2455266 | 2455266 | 2022-04-29 | Leelanau | Michigan | 26089 | 3620 | 54 |
2455267 | 2455267 | 2022-04-29 | Lenawee | Michigan | 26091 | 26146 | 330 |
2455268 | 2455268 | 2022-04-29 | Livingston | Michigan | 26093 | 46705 | 450 |
2455269 | 2455269 | 2022-04-29 | Luce | Michigan | 26095 | 2292 | 14 |
2455270 | 2455270 | 2022-04-29 | Mackinac | Michigan | 26097 | 2421 | 31 |
2455271 | 2455271 | 2022-04-29 | Macomb | Michigan | 26099 | 233892 | 3961 |
2455272 | 2455272 | 2022-04-29 | Manistee | Michigan | 26101 | 4485 | 90 |
2455273 | 2455273 | 2022-04-29 | Marquette | Michigan | 26103 | 15951 | 130 |
2455274 | 2455274 | 2022-04-29 | Mason | Michigan | 26105 | 6793 | 95 |
2455275 | 2455275 | 2022-04-29 | Mecosta | Michigan | 26107 | 8699 | 106 |
2455276 | 2455276 | 2022-04-29 | Menominee | Michigan | 26109 | 5638 | 70 |
2455277 | 2455277 | 2022-04-29 | Midland | Michigan | 26111 | 19157 | 225 |
2455278 | 2455278 | 2022-04-29 | Missaukee | Michigan | 26113 | 2917 | 60 |
2455279 | 2455279 | 2022-04-29 | Monroe | Michigan | 26115 | 38305 | 473 |
2455280 | 2455280 | 2022-04-29 | Montcalm | Michigan | 26117 | 17219 | 216 |
2455281 | 2455281 | 2022-04-29 | Montmorency | Michigan | 26119 | 1732 | 48 |
2455282 | 2455282 | 2022-04-29 | Muskegon | Michigan | 26121 | 42067 | 649 |
2455283 | 2455283 | 2022-04-29 | Newaygo | Michigan | 26123 | 11514 | 158 |
2455284 | 2455284 | 2022-04-29 | Oakland | Michigan | 26125 | 292717 | 3837 |
2455285 | 2455285 | 2022-04-29 | Oceana | Michigan | 26127 | 6359 | 90 |
2455286 | 2455286 | 2022-04-29 | Ogemaw | Michigan | 26129 | 4321 | 106 |
2455287 | 2455287 | 2022-04-29 | Ontonagon | Michigan | 26131 | 996 | 38 |
2455288 | 2455288 | 2022-04-29 | Osceola | Michigan | 26133 | 5022 | 80 |
2455289 | 2455289 | 2022-04-29 | Oscoda | Michigan | 26135 | 1437 | 55 |
2455290 | 2455290 | 2022-04-29 | Otsego | Michigan | 26137 | 5674 | 100 |
2455291 | 2455291 | 2022-04-29 | Ottawa | Michigan | 26139 | 75339 | 782 |
2455292 | 2455292 | 2022-04-29 | Presque Isle | Michigan | 26141 | 2070 | 58 |
2455293 | 2455293 | 2022-04-29 | Roscommon | Michigan | 26143 | 4635 | 114 |
2455294 | 2455294 | 2022-04-29 | Saginaw | Michigan | 26145 | 50629 | 951 |
2455295 | 2455295 | 2022-04-29 | Sanilac | Michigan | 26151 | 8738 | 192 |
2455296 | 2455296 | 2022-04-29 | Schoolcraft | Michigan | 26153 | 1746 | 16 |
2455297 | 2455297 | 2022-04-29 | Shiawassee | Michigan | 26155 | 17880 | 231 |
2455298 | 2455298 | 2022-04-29 | St. Clair | Michigan | 26147 | 41063 | 834 |
2455299 | 2455299 | 2022-04-29 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2455300 | 2455300 | 2022-04-29 | Tuscola | Michigan | 26157 | 13239 | 277 |
2455301 | 2455301 | 2022-04-29 | Unknown | Michigan | 17453 | 80 | |
2455302 | 2455302 | 2022-04-29 | Van Buren | Michigan | 26159 | 17155 | 270 |
2455303 | 2455303 | 2022-04-29 | Washtenaw | Michigan | 26161 | 79762 | 517 |
2455304 | 2455304 | 2022-04-29 | Wayne | Michigan | 26163 | 406822 | 7942 |
2455305 | 2455305 | 2022-04-29 | Wexford | Michigan | 26165 | 7106 | 106 |
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);