ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-11-14" 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 |
---|---|---|---|---|---|---|---|
730200 | 730200 | 2020-11-14 | Alcona | Michigan | 26001 | 92 | 3 |
730201 | 730201 | 2020-11-14 | Alger | Michigan | 26003 | 189 | 2 |
730202 | 730202 | 2020-11-14 | Allegan | Michigan | 26005 | 2596 | 13 |
730203 | 730203 | 2020-11-14 | Alpena | Michigan | 26007 | 297 | 16 |
730204 | 730204 | 2020-11-14 | Antrim | Michigan | 26009 | 259 | 1 |
730205 | 730205 | 2020-11-14 | Arenac | Michigan | 26011 | 215 | 6 |
730206 | 730206 | 2020-11-14 | Baraga | Michigan | 26013 | 306 | 5 |
730207 | 730207 | 2020-11-14 | Barry | Michigan | 26015 | 1347 | 10 |
730208 | 730208 | 2020-11-14 | Bay | Michigan | 26017 | 2846 | 80 |
730209 | 730209 | 2020-11-14 | Benzie | Michigan | 26019 | 224 | 3 |
730210 | 730210 | 2020-11-14 | Berrien | Michigan | 26021 | 4453 | 102 |
730211 | 730211 | 2020-11-14 | Branch | Michigan | 26023 | 2333 | 43 |
730212 | 730212 | 2020-11-14 | Calhoun | Michigan | 26025 | 4742 | 99 |
730213 | 730213 | 2020-11-14 | Cass | Michigan | 26027 | 1595 | 27 |
730214 | 730214 | 2020-11-14 | Charlevoix | Michigan | 26029 | 347 | 5 |
730215 | 730215 | 2020-11-14 | Cheboygan | Michigan | 26031 | 311 | 14 |
730216 | 730216 | 2020-11-14 | Chippewa | Michigan | 26033 | 541 | 2 |
730217 | 730217 | 2020-11-14 | Clare | Michigan | 26035 | 525 | 23 |
730218 | 730218 | 2020-11-14 | Clinton | Michigan | 26037 | 2042 | 18 |
730219 | 730219 | 2020-11-14 | Crawford | Michigan | 26039 | 226 | 5 |
730220 | 730220 | 2020-11-14 | Delta | Michigan | 26041 | 2036 | 55 |
730221 | 730221 | 2020-11-14 | Dickinson | Michigan | 26043 | 1245 | 28 |
730222 | 730222 | 2020-11-14 | Eaton | Michigan | 26045 | 2086 | 23 |
730223 | 730223 | 2020-11-14 | Emmet | Michigan | 26047 | 711 | 18 |
730224 | 730224 | 2020-11-14 | Genesee | Michigan | 26049 | 10245 | 372 |
730225 | 730225 | 2020-11-14 | Gladwin | Michigan | 26051 | 458 | 6 |
730226 | 730226 | 2020-11-14 | Gogebic | Michigan | 26053 | 641 | 19 |
730227 | 730227 | 2020-11-14 | Grand Traverse | Michigan | 26055 | 1266 | 15 |
730228 | 730228 | 2020-11-14 | Gratiot | Michigan | 26057 | 1065 | 21 |
730229 | 730229 | 2020-11-14 | Hillsdale | Michigan | 26059 | 986 | 32 |
730230 | 730230 | 2020-11-14 | Houghton | Michigan | 26061 | 1265 | 9 |
730231 | 730231 | 2020-11-14 | Huron | Michigan | 26063 | 460 | 8 |
730232 | 730232 | 2020-11-14 | Ingham | Michigan | 26065 | 6578 | 85 |
730233 | 730233 | 2020-11-14 | Ionia | Michigan | 26067 | 2228 | 13 |
730234 | 730234 | 2020-11-14 | Iosco | Michigan | 26069 | 477 | 19 |
730235 | 730235 | 2020-11-14 | Iron | Michigan | 26071 | 605 | 31 |
730236 | 730236 | 2020-11-14 | Isabella | Michigan | 26073 | 1741 | 18 |
730237 | 730237 | 2020-11-14 | Jackson | Michigan | 26075 | 4965 | 106 |
730238 | 730238 | 2020-11-14 | Kalamazoo | Michigan | 26077 | 7177 | 143 |
730239 | 730239 | 2020-11-14 | Kalkaska | Michigan | 26079 | 237 | 4 |
730240 | 730240 | 2020-11-14 | Kent | Michigan | 26081 | 23631 | 247 |
730241 | 730241 | 2020-11-14 | Keweenaw | Michigan | 26083 | 38 | 1 |
730242 | 730242 | 2020-11-14 | Lake | Michigan | 26085 | 126 | 1 |
730243 | 730243 | 2020-11-14 | Lapeer | Michigan | 26087 | 1850 | 51 |
730244 | 730244 | 2020-11-14 | Leelanau | Michigan | 26089 | 255 | 2 |
730245 | 730245 | 2020-11-14 | Lenawee | Michigan | 26091 | 2415 | 26 |
730246 | 730246 | 2020-11-14 | Livingston | Michigan | 26093 | 3575 | 36 |
730247 | 730247 | 2020-11-14 | Luce | Michigan | 26095 | 558 | 0 |
730248 | 730248 | 2020-11-14 | Mackinac | Michigan | 26097 | 216 | 0 |
730249 | 730249 | 2020-11-14 | Macomb | Michigan | 26099 | 27445 | 1171 |
730250 | 730250 | 2020-11-14 | Manistee | Michigan | 26101 | 246 | 5 |
730251 | 730251 | 2020-11-14 | Marquette | Michigan | 26103 | 2916 | 22 |
730252 | 730252 | 2020-11-14 | Mason | Michigan | 26105 | 412 | 7 |
730253 | 730253 | 2020-11-14 | Mecosta | Michigan | 26107 | 891 | 6 |
730254 | 730254 | 2020-11-14 | Menominee | Michigan | 26109 | 1044 | 10 |
730255 | 730255 | 2020-11-14 | Midland | Michigan | 26111 | 2086 | 16 |
730256 | 730256 | 2020-11-14 | Missaukee | Michigan | 26113 | 182 | 1 |
730257 | 730257 | 2020-11-14 | Monroe | Michigan | 26115 | 3452 | 51 |
730258 | 730258 | 2020-11-14 | Montcalm | Michigan | 26117 | 1259 | 16 |
730259 | 730259 | 2020-11-14 | Montmorency | Michigan | 26119 | 81 | 0 |
730260 | 730260 | 2020-11-14 | Muskegon | Michigan | 26121 | 5828 | 115 |
730261 | 730261 | 2020-11-14 | Newaygo | Michigan | 26123 | 1091 | 8 |
730262 | 730262 | 2020-11-14 | Oakland | Michigan | 26125 | 34658 | 1282 |
730263 | 730263 | 2020-11-14 | Oceana | Michigan | 26127 | 892 | 8 |
730264 | 730264 | 2020-11-14 | Ogemaw | Michigan | 26129 | 291 | 7 |
730265 | 730265 | 2020-11-14 | Ontonagon | Michigan | 26131 | 237 | 6 |
730266 | 730266 | 2020-11-14 | Osceola | Michigan | 26133 | 334 | 2 |
730267 | 730267 | 2020-11-14 | Oscoda | Michigan | 26135 | 91 | 2 |
730268 | 730268 | 2020-11-14 | Otsego | Michigan | 26137 | 530 | 14 |
730269 | 730269 | 2020-11-14 | Ottawa | Michigan | 26139 | 9530 | 98 |
730270 | 730270 | 2020-11-14 | Presque Isle | Michigan | 26141 | 149 | 2 |
730271 | 730271 | 2020-11-14 | Roscommon | Michigan | 26143 | 359 | 8 |
730272 | 730272 | 2020-11-14 | Saginaw | Michigan | 26145 | 6228 | 178 |
730273 | 730273 | 2020-11-14 | Sanilac | Michigan | 26151 | 408 | 9 |
730274 | 730274 | 2020-11-14 | Schoolcraft | Michigan | 26153 | 153 | 1 |
730275 | 730275 | 2020-11-14 | Shiawassee | Michigan | 26155 | 1310 | 35 |
730276 | 730276 | 2020-11-14 | St. Clair | Michigan | 26147 | 2822 | 71 |
730277 | 730277 | 2020-11-14 | St. Joseph | Michigan | 26149 | 1993 | 27 |
730278 | 730278 | 2020-11-14 | Tuscola | Michigan | 26157 | 1149 | 41 |
730279 | 730279 | 2020-11-14 | Unknown | Michigan | 2001 | 4 | |
730280 | 730280 | 2020-11-14 | Van Buren | Michigan | 26159 | 1925 | 25 |
730281 | 730281 | 2020-11-14 | Washtenaw | Michigan | 26161 | 7925 | 133 |
730282 | 730282 | 2020-11-14 | Wayne | Michigan | 26163 | 50512 | 3121 |
730283 | 730283 | 2020-11-14 | Wexford | Michigan | 26165 | 341 | 7 |
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);