ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-08-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 |
---|---|---|---|---|---|---|---|
1639175 | 1639175 | 2021-08-21 | Alcona | Michigan | 26001 | 787 | 36 |
1639176 | 1639176 | 2021-08-21 | Alger | Michigan | 26003 | 687 | 7 |
1639177 | 1639177 | 2021-08-21 | Allegan | Michigan | 26005 | 11765 | 164 |
1639178 | 1639178 | 2021-08-21 | Alpena | Michigan | 26007 | 2451 | 66 |
1639179 | 1639179 | 2021-08-21 | Antrim | Michigan | 26009 | 1712 | 33 |
1639180 | 1639180 | 2021-08-21 | Arenac | Michigan | 26011 | 1261 | 29 |
1639181 | 1639181 | 2021-08-21 | Baraga | Michigan | 26013 | 1019 | 41 |
1639182 | 1639182 | 2021-08-21 | Barry | Michigan | 26015 | 6213 | 72 |
1639183 | 1639183 | 2021-08-21 | Bay | Michigan | 26017 | 11618 | 359 |
1639184 | 1639184 | 2021-08-21 | Benzie | Michigan | 26019 | 1325 | 38 |
1639185 | 1639185 | 2021-08-21 | Berrien | Michigan | 26021 | 16213 | 303 |
1639186 | 1639186 | 2021-08-21 | Branch | Michigan | 26023 | 6246 | 122 |
1639187 | 1639187 | 2021-08-21 | Calhoun | Michigan | 26025 | 15195 | 325 |
1639188 | 1639188 | 2021-08-21 | Cass | Michigan | 26027 | 5743 | 78 |
1639189 | 1639189 | 2021-08-21 | Charlevoix | Michigan | 26029 | 1864 | 26 |
1639190 | 1639190 | 2021-08-21 | Cheboygan | Michigan | 26031 | 1995 | 50 |
1639191 | 1639191 | 2021-08-21 | Chippewa | Michigan | 26033 | 5738 | 50 |
1639192 | 1639192 | 2021-08-21 | Clare | Michigan | 26035 | 2593 | 87 |
1639193 | 1639193 | 2021-08-21 | Clinton | Michigan | 26037 | 7973 | 96 |
1639194 | 1639194 | 2021-08-21 | Crawford | Michigan | 26039 | 1031 | 14 |
1639195 | 1639195 | 2021-08-21 | Delta | Michigan | 26041 | 4326 | 95 |
1639196 | 1639196 | 2021-08-21 | Dickinson | Michigan | 26043 | 2867 | 74 |
1639197 | 1639197 | 2021-08-21 | Eaton | Michigan | 26045 | 10590 | 213 |
1639198 | 1639198 | 2021-08-21 | Emmet | Michigan | 26047 | 2512 | 43 |
1639199 | 1639199 | 2021-08-21 | Genesee | Michigan | 26049 | 43234 | 991 |
1639200 | 1639200 | 2021-08-21 | Gladwin | Michigan | 26051 | 2362 | 61 |
1639201 | 1639201 | 2021-08-21 | Gogebic | Michigan | 26053 | 1505 | 53 |
1639202 | 1639202 | 2021-08-21 | Grand Traverse | Michigan | 26055 | 6811 | 101 |
1639203 | 1639203 | 2021-08-21 | Gratiot | Michigan | 26057 | 7101 | 125 |
1639204 | 1639204 | 2021-08-21 | Hillsdale | Michigan | 26059 | 4621 | 97 |
1639205 | 1639205 | 2021-08-21 | Houghton | Michigan | 26061 | 3245 | 43 |
1639206 | 1639206 | 2021-08-21 | Huron | Michigan | 26063 | 4209 | 84 |
1639207 | 1639207 | 2021-08-21 | Ingham | Michigan | 26065 | 25985 | 402 |
1639208 | 1639208 | 2021-08-21 | Ionia | Michigan | 26067 | 9602 | 86 |
1639209 | 1639209 | 2021-08-21 | Iosco | Michigan | 26069 | 2116 | 77 |
1639210 | 1639210 | 2021-08-21 | Iron | Michigan | 26071 | 1094 | 53 |
1639211 | 1639211 | 2021-08-21 | Isabella | Michigan | 26073 | 6515 | 102 |
1639212 | 1639212 | 2021-08-21 | Jackson | Michigan | 26075 | 21887 | 332 |
1639213 | 1639213 | 2021-08-21 | Kalamazoo | Michigan | 26077 | 24507 | 410 |
1639214 | 1639214 | 2021-08-21 | Kalkaska | Michigan | 26079 | 1219 | 29 |
1639215 | 1639215 | 2021-08-21 | Kent | Michigan | 26081 | 76346 | 878 |
1639216 | 1639216 | 2021-08-21 | Keweenaw | Michigan | 26083 | 177 | 2 |
1639217 | 1639217 | 2021-08-21 | Lake | Michigan | 26085 | 673 | 17 |
1639218 | 1639218 | 2021-08-21 | Lapeer | Michigan | 26087 | 10105 | 217 |
1639219 | 1639219 | 2021-08-21 | Leelanau | Michigan | 26089 | 1318 | 21 |
1639220 | 1639220 | 2021-08-21 | Lenawee | Michigan | 26091 | 11277 | 181 |
1639221 | 1639221 | 2021-08-21 | Livingston | Michigan | 26093 | 17736 | 200 |
1639222 | 1639222 | 2021-08-21 | Luce | Michigan | 26095 | 1351 | 6 |
1639223 | 1639223 | 2021-08-21 | Mackinac | Michigan | 26097 | 753 | 3 |
1639224 | 1639224 | 2021-08-21 | Macomb | Michigan | 26099 | 104143 | 2525 |
1639225 | 1639225 | 2021-08-21 | Manistee | Michigan | 26101 | 2066 | 28 |
1639226 | 1639226 | 2021-08-21 | Marquette | Michigan | 26103 | 6040 | 66 |
1639227 | 1639227 | 2021-08-21 | Mason | Michigan | 26105 | 2286 | 39 |
1639228 | 1639228 | 2021-08-21 | Mecosta | Michigan | 26107 | 3326 | 38 |
1639229 | 1639229 | 2021-08-21 | Menominee | Michigan | 26109 | 2280 | 44 |
1639230 | 1639230 | 2021-08-21 | Midland | Michigan | 26111 | 7853 | 99 |
1639231 | 1639231 | 2021-08-21 | Missaukee | Michigan | 26113 | 1540 | 29 |
1639232 | 1639232 | 2021-08-21 | Monroe | Michigan | 26115 | 16052 | 269 |
1639233 | 1639233 | 2021-08-21 | Montcalm | Michigan | 26117 | 8370 | 122 |
1639234 | 1639234 | 2021-08-21 | Montmorency | Michigan | 26119 | 670 | 20 |
1639235 | 1639235 | 2021-08-21 | Muskegon | Michigan | 26121 | 19096 | 386 |
1639236 | 1639236 | 2021-08-21 | Newaygo | Michigan | 26123 | 5034 | 70 |
1639237 | 1639237 | 2021-08-21 | Oakland | Michigan | 26125 | 124280 | 2496 |
1639238 | 1639238 | 2021-08-21 | Oceana | Michigan | 26127 | 2847 | 61 |
1639239 | 1639239 | 2021-08-21 | Ogemaw | Michigan | 26129 | 1859 | 44 |
1639240 | 1639240 | 2021-08-21 | Ontonagon | Michigan | 26131 | 511 | 22 |
1639241 | 1639241 | 2021-08-21 | Osceola | Michigan | 26133 | 2022 | 31 |
1639242 | 1639242 | 2021-08-21 | Oscoda | Michigan | 26135 | 706 | 31 |
1639243 | 1639243 | 2021-08-21 | Otsego | Michigan | 26137 | 2428 | 41 |
1639244 | 1639244 | 2021-08-21 | Ottawa | Michigan | 26139 | 34113 | 448 |
1639245 | 1639245 | 2021-08-21 | Presque Isle | Michigan | 26141 | 1090 | 34 |
1639246 | 1639246 | 2021-08-21 | Roscommon | Michigan | 26143 | 1942 | 55 |
1639247 | 1639247 | 2021-08-21 | Saginaw | Michigan | 26145 | 23459 | 645 |
1639248 | 1639248 | 2021-08-21 | Sanilac | Michigan | 26151 | 4338 | 126 |
1639249 | 1639249 | 2021-08-21 | Schoolcraft | Michigan | 26153 | 465 | 5 |
1639250 | 1639250 | 2021-08-21 | Shiawassee | Michigan | 26155 | 6733 | 110 |
1639251 | 1639251 | 2021-08-21 | St. Clair | Michigan | 26147 | 18964 | 457 |
1639252 | 1639252 | 2021-08-21 | St. Joseph | Michigan | 26149 | 6535 | 104 |
1639253 | 1639253 | 2021-08-21 | Tuscola | Michigan | 26157 | 5867 | 176 |
1639254 | 1639254 | 2021-08-21 | Unknown | Michigan | 794 | 18 | |
1639255 | 1639255 | 2021-08-21 | Van Buren | Michigan | 26159 | 7530 | 138 |
1639256 | 1639256 | 2021-08-21 | Washtenaw | Michigan | 26161 | 28331 | 315 |
1639257 | 1639257 | 2021-08-21 | Wayne | Michigan | 26163 | 172976 | 5252 |
1639258 | 1639258 | 2021-08-21 | Wexford | Michigan | 26165 | 2961 | 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);