ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-10-08" 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 |
---|---|---|---|---|---|---|---|
610182 | 610182 | 2020-10-08 | Alcona | Michigan | 26001 | 49 | 2 |
610183 | 610183 | 2020-10-08 | Alger | Michigan | 26003 | 37 | 0 |
610184 | 610184 | 2020-10-08 | Allegan | Michigan | 26005 | 873 | 7 |
610185 | 610185 | 2020-10-08 | Alpena | Michigan | 26007 | 145 | 14 |
610186 | 610186 | 2020-10-08 | Antrim | Michigan | 26009 | 79 | 0 |
610187 | 610187 | 2020-10-08 | Arenac | Michigan | 26011 | 77 | 3 |
610188 | 610188 | 2020-10-08 | Baraga | Michigan | 26013 | 53 | 3 |
610189 | 610189 | 2020-10-08 | Barry | Michigan | 26015 | 395 | 4 |
610190 | 610190 | 2020-10-08 | Bay | Michigan | 26017 | 1091 | 54 |
610191 | 610191 | 2020-10-08 | Benzie | Michigan | 26019 | 88 | 2 |
610192 | 610192 | 2020-10-08 | Berrien | Michigan | 26021 | 2118 | 76 |
610193 | 610193 | 2020-10-08 | Branch | Michigan | 26023 | 1501 | 32 |
610194 | 610194 | 2020-10-08 | Calhoun | Michigan | 26025 | 1740 | 51 |
610195 | 610195 | 2020-10-08 | Cass | Michigan | 26027 | 671 | 20 |
610196 | 610196 | 2020-10-08 | Charlevoix | Michigan | 26029 | 120 | 4 |
610197 | 610197 | 2020-10-08 | Cheboygan | Michigan | 26031 | 98 | 2 |
610198 | 610198 | 2020-10-08 | Chippewa | Michigan | 26033 | 87 | 0 |
610199 | 610199 | 2020-10-08 | Clare | Michigan | 26035 | 128 | 6 |
610200 | 610200 | 2020-10-08 | Clinton | Michigan | 26037 | 770 | 14 |
610201 | 610201 | 2020-10-08 | Crawford | Michigan | 26039 | 128 | 5 |
610202 | 610202 | 2020-10-08 | Delta | Michigan | 26041 | 781 | 13 |
610203 | 610203 | 2020-10-08 | Dickinson | Michigan | 26043 | 259 | 4 |
610204 | 610204 | 2020-10-08 | Eaton | Michigan | 26045 | 781 | 10 |
610205 | 610205 | 2020-10-08 | Emmet | Michigan | 26047 | 177 | 4 |
610206 | 610206 | 2020-10-08 | Genesee | Michigan | 26049 | 5152 | 310 |
610207 | 610207 | 2020-10-08 | Gladwin | Michigan | 26051 | 119 | 2 |
610208 | 610208 | 2020-10-08 | Gogebic | Michigan | 26053 | 185 | 2 |
610209 | 610209 | 2020-10-08 | Grand Traverse | Michigan | 26055 | 563 | 9 |
610210 | 610210 | 2020-10-08 | Gratiot | Michigan | 26057 | 327 | 16 |
610211 | 610211 | 2020-10-08 | Hillsdale | Michigan | 26059 | 382 | 27 |
610212 | 610212 | 2020-10-08 | Houghton | Michigan | 26061 | 767 | 4 |
610213 | 610213 | 2020-10-08 | Huron | Michigan | 26063 | 238 | 5 |
610214 | 610214 | 2020-10-08 | Ingham | Michigan | 26065 | 3888 | 51 |
610215 | 610215 | 2020-10-08 | Ionia | Michigan | 26067 | 604 | 8 |
610216 | 610216 | 2020-10-08 | Iosco | Michigan | 26069 | 243 | 13 |
610217 | 610217 | 2020-10-08 | Iron | Michigan | 26071 | 267 | 10 |
610218 | 610218 | 2020-10-08 | Isabella | Michigan | 26073 | 798 | 15 |
610219 | 610219 | 2020-10-08 | Jackson | Michigan | 26075 | 2953 | 73 |
610220 | 610220 | 2020-10-08 | Kalamazoo | Michigan | 26077 | 3483 | 96 |
610221 | 610221 | 2020-10-08 | Kalkaska | Michigan | 26079 | 96 | 4 |
610222 | 610222 | 2020-10-08 | Kent | Michigan | 26081 | 10981 | 175 |
610223 | 610223 | 2020-10-08 | Keweenaw | Michigan | 26083 | 13 | 0 |
610224 | 610224 | 2020-10-08 | Lake | Michigan | 26085 | 38 | 0 |
610225 | 610225 | 2020-10-08 | Lapeer | Michigan | 26087 | 985 | 44 |
610226 | 610226 | 2020-10-08 | Leelanau | Michigan | 26089 | 118 | 1 |
610227 | 610227 | 2020-10-08 | Lenawee | Michigan | 26091 | 1640 | 22 |
610228 | 610228 | 2020-10-08 | Livingston | Michigan | 26093 | 1584 | 33 |
610229 | 610229 | 2020-10-08 | Luce | Michigan | 26095 | 268 | 0 |
610230 | 610230 | 2020-10-08 | Mackinac | Michigan | 26097 | 86 | 0 |
610231 | 610231 | 2020-10-08 | Macomb | Michigan | 26099 | 15822 | 1043 |
610232 | 610232 | 2020-10-08 | Manistee | Michigan | 26101 | 103 | 3 |
610233 | 610233 | 2020-10-08 | Marquette | Michigan | 26103 | 480 | 12 |
610234 | 610234 | 2020-10-08 | Mason | Michigan | 26105 | 145 | 0 |
610235 | 610235 | 2020-10-08 | Mecosta | Michigan | 26107 | 279 | 3 |
610236 | 610236 | 2020-10-08 | Menominee | Michigan | 26109 | 521 | 3 |
610237 | 610237 | 2020-10-08 | Midland | Michigan | 26111 | 698 | 12 |
610238 | 610238 | 2020-10-08 | Missaukee | Michigan | 26113 | 70 | 1 |
610239 | 610239 | 2020-10-08 | Monroe | Michigan | 26115 | 1641 | 28 |
610240 | 610240 | 2020-10-08 | Montcalm | Michigan | 26117 | 387 | 7 |
610241 | 610241 | 2020-10-08 | Montmorency | Michigan | 26119 | 17 | 0 |
610242 | 610242 | 2020-10-08 | Muskegon | Michigan | 26121 | 2655 | 76 |
610243 | 610243 | 2020-10-08 | Newaygo | Michigan | 26123 | 436 | 2 |
610244 | 610244 | 2020-10-08 | Oakland | Michigan | 26125 | 21592 | 1214 |
610245 | 610245 | 2020-10-08 | Oceana | Michigan | 26127 | 542 | 6 |
610246 | 610246 | 2020-10-08 | Ogemaw | Michigan | 26129 | 76 | 5 |
610247 | 610247 | 2020-10-08 | Ontonagon | Michigan | 26131 | 50 | 0 |
610248 | 610248 | 2020-10-08 | Osceola | Michigan | 26133 | 103 | 0 |
610249 | 610249 | 2020-10-08 | Oscoda | Michigan | 26135 | 50 | 1 |
610250 | 610250 | 2020-10-08 | Otsego | Michigan | 26137 | 205 | 12 |
610251 | 610251 | 2020-10-08 | Ottawa | Michigan | 26139 | 3836 | 69 |
610252 | 610252 | 2020-10-08 | Presque Isle | Michigan | 26141 | 29 | 1 |
610253 | 610253 | 2020-10-08 | Roscommon | Michigan | 26143 | 111 | 4 |
610254 | 610254 | 2020-10-08 | Saginaw | Michigan | 26145 | 3154 | 143 |
610255 | 610255 | 2020-10-08 | Sanilac | Michigan | 26151 | 157 | 7 |
610256 | 610256 | 2020-10-08 | Schoolcraft | Michigan | 26153 | 40 | 0 |
610257 | 610257 | 2020-10-08 | Shiawassee | Michigan | 26155 | 565 | 32 |
610258 | 610258 | 2020-10-08 | St. Clair | Michigan | 26147 | 1124 | 60 |
610259 | 610259 | 2020-10-08 | St. Joseph | Michigan | 26149 | 885 | 11 |
610260 | 610260 | 2020-10-08 | Tuscola | Michigan | 26157 | 536 | 33 |
610261 | 610261 | 2020-10-08 | Unknown | Michigan | 113 | 4 | |
610262 | 610262 | 2020-10-08 | Van Buren | Michigan | 26159 | 825 | 18 |
610263 | 610263 | 2020-10-08 | Washtenaw | Michigan | 26161 | 4569 | 126 |
610264 | 610264 | 2020-10-08 | Wayne | Michigan | 26163 | 36564 | 3004 |
610265 | 610265 | 2020-10-08 | Wexford | Michigan | 26165 | 144 | 4 |
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);