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 2021-05-16 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1324236 | 1324236 | 2021-05-16 | Alcona | Michigan | 26001 | 726 | 29 |
1324237 | 1324237 | 2021-05-16 | Alger | Michigan | 26003 | 663 | 6 |
1324238 | 1324238 | 2021-05-16 | Allegan | Michigan | 26005 | 10827 | 139 |
1324239 | 1324239 | 2021-05-16 | Alpena | Michigan | 26007 | 2200 | 61 |
1324240 | 1324240 | 2021-05-16 | Antrim | Michigan | 26009 | 1598 | 28 |
1324241 | 1324241 | 2021-05-16 | Arenac | Michigan | 26011 | 1178 | 29 |
1324242 | 1324242 | 2021-05-16 | Baraga | Michigan | 26013 | 943 | 38 |
1324243 | 1324243 | 2021-05-16 | Barry | Michigan | 26015 | 5808 | 65 |
1324244 | 1324244 | 2021-05-16 | Bay | Michigan | 26017 | 11039 | 341 |
1324245 | 1324245 | 2021-05-16 | Benzie | Michigan | 26019 | 1263 | 34 |
1324246 | 1324246 | 2021-05-16 | Berrien | Michigan | 26021 | 15236 | 278 |
1324247 | 1324247 | 2021-05-16 | Branch | Michigan | 26023 | 5573 | 120 |
1324248 | 1324248 | 2021-05-16 | Calhoun | Michigan | 26025 | 14108 | 286 |
1324249 | 1324249 | 2021-05-16 | Cass | Michigan | 26027 | 5340 | 76 |
1324250 | 1324250 | 2021-05-16 | Charlevoix | Michigan | 26029 | 1630 | 20 |
1324251 | 1324251 | 2021-05-16 | Cheboygan | Michigan | 26031 | 1898 | 45 |
1324252 | 1324252 | 2021-05-16 | Chippewa | Michigan | 26033 | 5566 | 49 |
1324253 | 1324253 | 2021-05-16 | Clare | Michigan | 26035 | 2414 | 79 |
1324254 | 1324254 | 2021-05-16 | Clinton | Michigan | 26037 | 7464 | 85 |
1324255 | 1324255 | 2021-05-16 | Crawford | Michigan | 26039 | 974 | 14 |
1324256 | 1324256 | 2021-05-16 | Delta | Michigan | 26041 | 3984 | 91 |
1324257 | 1324257 | 2021-05-16 | Dickinson | Michigan | 26043 | 2711 | 74 |
1324258 | 1324258 | 2021-05-16 | Eaton | Michigan | 26045 | 9952 | 202 |
1324259 | 1324259 | 2021-05-16 | Emmet | Michigan | 26047 | 2340 | 41 |
1324260 | 1324260 | 2021-05-16 | Genesee | Michigan | 26049 | 41098 | 917 |
1324261 | 1324261 | 2021-05-16 | Gladwin | Michigan | 26051 | 2264 | 56 |
1324262 | 1324262 | 2021-05-16 | Gogebic | Michigan | 26053 | 1391 | 50 |
1324263 | 1324263 | 2021-05-16 | Grand Traverse | Michigan | 26055 | 6346 | 95 |
1324264 | 1324264 | 2021-05-16 | Gratiot | Michigan | 26057 | 6875 | 118 |
1324265 | 1324265 | 2021-05-16 | Hillsdale | Michigan | 26059 | 4314 | 90 |
1324266 | 1324266 | 2021-05-16 | Houghton | Michigan | 26061 | 3101 | 40 |
1324267 | 1324267 | 2021-05-16 | Huron | Michigan | 26063 | 4051 | 75 |
1324268 | 1324268 | 2021-05-16 | Ingham | Michigan | 26065 | 24388 | 369 |
1324269 | 1324269 | 2021-05-16 | Ionia | Michigan | 26067 | 9105 | 84 |
1324270 | 1324270 | 2021-05-16 | Iosco | Michigan | 26069 | 1949 | 71 |
1324271 | 1324271 | 2021-05-16 | Iron | Michigan | 26071 | 1040 | 51 |
1324272 | 1324272 | 2021-05-16 | Isabella | Michigan | 26073 | 6165 | 92 |
1324273 | 1324273 | 2021-05-16 | Jackson | Michigan | 26075 | 20658 | 302 |
1324274 | 1324274 | 2021-05-16 | Kalamazoo | Michigan | 26077 | 22589 | 385 |
1324275 | 1324275 | 2021-05-16 | Kalkaska | Michigan | 26079 | 1100 | 23 |
1324276 | 1324276 | 2021-05-16 | Kent | Michigan | 26081 | 71197 | 813 |
1324277 | 1324277 | 2021-05-16 | Keweenaw | Michigan | 26083 | 175 | 2 |
1324278 | 1324278 | 2021-05-16 | Lake | Michigan | 26085 | 608 | 15 |
1324279 | 1324279 | 2021-05-16 | Lapeer | Michigan | 26087 | 9570 | 198 |
1324280 | 1324280 | 2021-05-16 | Leelanau | Michigan | 26089 | 1227 | 18 |
1324281 | 1324281 | 2021-05-16 | Lenawee | Michigan | 26091 | 10676 | 166 |
1324282 | 1324282 | 2021-05-16 | Livingston | Michigan | 26093 | 16462 | 180 |
1324283 | 1324283 | 2021-05-16 | Luce | Michigan | 26095 | 1283 | 4 |
1324284 | 1324284 | 2021-05-16 | Mackinac | Michigan | 26097 | 674 | 3 |
1324285 | 1324285 | 2021-05-16 | Macomb | Michigan | 26099 | 98634 | 2370 |
1324286 | 1324286 | 2021-05-16 | Manistee | Michigan | 26101 | 1947 | 24 |
1324287 | 1324287 | 2021-05-16 | Marquette | Michigan | 26103 | 5873 | 62 |
1324288 | 1324288 | 2021-05-16 | Mason | Michigan | 26105 | 2100 | 36 |
1324289 | 1324289 | 2021-05-16 | Mecosta | Michigan | 26107 | 3120 | 30 |
1324290 | 1324290 | 2021-05-16 | Menominee | Michigan | 26109 | 2101 | 41 |
1324291 | 1324291 | 2021-05-16 | Midland | Michigan | 26111 | 7369 | 84 |
1324292 | 1324292 | 2021-05-16 | Missaukee | Michigan | 26113 | 1475 | 24 |
1324293 | 1324293 | 2021-05-16 | Monroe | Michigan | 26115 | 15096 | 253 |
1324294 | 1324294 | 2021-05-16 | Montcalm | Michigan | 26117 | 7925 | 113 |
1324295 | 1324295 | 2021-05-16 | Montmorency | Michigan | 26119 | 592 | 19 |
1324296 | 1324296 | 2021-05-16 | Muskegon | Michigan | 26121 | 17686 | 356 |
1324297 | 1324297 | 2021-05-16 | Newaygo | Michigan | 26123 | 4724 | 62 |
1324298 | 1324298 | 2021-05-16 | Oakland | Michigan | 26125 | 116183 | 2305 |
1324299 | 1324299 | 2021-05-16 | Oceana | Michigan | 26127 | 2710 | 59 |
1324300 | 1324300 | 2021-05-16 | Ogemaw | Michigan | 26129 | 1665 | 40 |
1324301 | 1324301 | 2021-05-16 | Ontonagon | Michigan | 26131 | 463 | 21 |
1324302 | 1324302 | 2021-05-16 | Osceola | Michigan | 26133 | 1894 | 28 |
1324303 | 1324303 | 2021-05-16 | Oscoda | Michigan | 26135 | 637 | 29 |
1324304 | 1324304 | 2021-05-16 | Otsego | Michigan | 26137 | 2306 | 40 |
1324305 | 1324305 | 2021-05-16 | Ottawa | Michigan | 26139 | 32106 | 408 |
1324306 | 1324306 | 2021-05-16 | Presque Isle | Michigan | 26141 | 1031 | 32 |
1324307 | 1324307 | 2021-05-16 | Roscommon | Michigan | 26143 | 1861 | 48 |
1324308 | 1324308 | 2021-05-16 | Saginaw | Michigan | 26145 | 21936 | 591 |
1324309 | 1324309 | 2021-05-16 | Sanilac | Michigan | 26151 | 4200 | 112 |
1324310 | 1324310 | 2021-05-16 | Schoolcraft | Michigan | 26153 | 407 | 5 |
1324311 | 1324311 | 2021-05-16 | Shiawassee | Michigan | 26155 | 6271 | 102 |
1324312 | 1324312 | 2021-05-16 | St. Clair | Michigan | 26147 | 18048 | 425 |
1324313 | 1324313 | 2021-05-16 | St. Joseph | Michigan | 26149 | 6075 | 96 |
1324314 | 1324314 | 2021-05-16 | Tuscola | Michigan | 26157 | 5585 | 168 |
1324315 | 1324315 | 2021-05-16 | Unknown | Michigan | 557 | 13 | |
1324316 | 1324316 | 2021-05-16 | Van Buren | Michigan | 26159 | 6973 | 123 |
1324317 | 1324317 | 2021-05-16 | Washtenaw | Michigan | 26161 | 26716 | 291 |
1324318 | 1324318 | 2021-05-16 | Wayne | Michigan | 26163 | 161588 | 4873 |
1324319 | 1324319 | 2021-05-16 | Wexford | Michigan | 26165 | 2841 | 45 |
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);