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 2022-01-28 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2159168 | 2159168 | 2022-01-28 | Alcona | Michigan | 26001 | 1608 | 63 |
2159169 | 2159169 | 2022-01-28 | Alger | Michigan | 26003 | 1747 | 12 |
2159170 | 2159170 | 2022-01-28 | Allegan | Michigan | 26005 | 25344 | 305 |
2159171 | 2159171 | 2022-01-28 | Alpena | Michigan | 26007 | 5125 | 123 |
2159172 | 2159172 | 2022-01-28 | Antrim | Michigan | 26009 | 3957 | 53 |
2159173 | 2159173 | 2022-01-28 | Arenac | Michigan | 26011 | 2967 | 60 |
2159174 | 2159174 | 2022-01-28 | Baraga | Michigan | 26013 | 2068 | 51 |
2159175 | 2159175 | 2022-01-28 | Barry | Michigan | 26015 | 13375 | 147 |
2159176 | 2159176 | 2022-01-28 | Bay | Michigan | 26017 | 25283 | 531 |
2159177 | 2159177 | 2022-01-28 | Benzie | Michigan | 26019 | 3189 | 60 |
2159178 | 2159178 | 2022-01-28 | Berrien | Michigan | 26021 | 32698 | 464 |
2159179 | 2159179 | 2022-01-28 | Branch | Michigan | 26023 | 11366 | 181 |
2159180 | 2159180 | 2022-01-28 | Calhoun | Michigan | 26025 | 31807 | 523 |
2159181 | 2159181 | 2022-01-28 | Cass | Michigan | 26027 | 10616 | 124 |
2159182 | 2159182 | 2022-01-28 | Charlevoix | Michigan | 26029 | 4613 | 55 |
2159183 | 2159183 | 2022-01-28 | Cheboygan | Michigan | 26031 | 4337 | 88 |
2159184 | 2159184 | 2022-01-28 | Chippewa | Michigan | 26033 | 10784 | 97 |
2159185 | 2159185 | 2022-01-28 | Clare | Michigan | 26035 | 6206 | 147 |
2159186 | 2159186 | 2022-01-28 | Clinton | Michigan | 26037 | 18790 | 185 |
2159187 | 2159187 | 2022-01-28 | Crawford | Michigan | 26039 | 2333 | 23 |
2159188 | 2159188 | 2022-01-28 | Delta | Michigan | 26041 | 9309 | 144 |
2159189 | 2159189 | 2022-01-28 | Dickinson | Michigan | 26043 | 6900 | 98 |
2159190 | 2159190 | 2022-01-28 | Eaton | Michigan | 26045 | 24800 | 349 |
2159191 | 2159191 | 2022-01-28 | Emmet | Michigan | 26047 | 5963 | 65 |
2159192 | 2159192 | 2022-01-28 | Genesee | Michigan | 26049 | 95106 | 1524 |
2159193 | 2159193 | 2022-01-28 | Gladwin | Michigan | 26051 | 5210 | 103 |
2159194 | 2159194 | 2022-01-28 | Gogebic | Michigan | 26053 | 3061 | 64 |
2159195 | 2159195 | 2022-01-28 | Grand Traverse | Michigan | 26055 | 15824 | 195 |
2159196 | 2159196 | 2022-01-28 | Gratiot | Michigan | 26057 | 12550 | 175 |
2159197 | 2159197 | 2022-01-28 | Hillsdale | Michigan | 26059 | 9596 | 180 |
2159198 | 2159198 | 2022-01-28 | Houghton | Michigan | 26061 | 7367 | 82 |
2159199 | 2159199 | 2022-01-28 | Huron | Michigan | 26063 | 7594 | 136 |
2159200 | 2159200 | 2022-01-28 | Ingham | Michigan | 26065 | 59438 | 666 |
2159201 | 2159201 | 2022-01-28 | Ionia | Michigan | 26067 | 18253 | 166 |
2159202 | 2159202 | 2022-01-28 | Iosco | Michigan | 26069 | 4466 | 126 |
2159203 | 2159203 | 2022-01-28 | Iron | Michigan | 26071 | 2413 | 74 |
2159204 | 2159204 | 2022-01-28 | Isabella | Michigan | 26073 | 14517 | 182 |
2159205 | 2159205 | 2022-01-28 | Jackson | Michigan | 26075 | 42551 | 510 |
2159206 | 2159206 | 2022-01-28 | Kalamazoo | Michigan | 26077 | 54636 | 606 |
2159207 | 2159207 | 2022-01-28 | Kalkaska | Michigan | 26079 | 3207 | 48 |
2159208 | 2159208 | 2022-01-28 | Kent | Michigan | 26081 | 157169 | 1381 |
2159209 | 2159209 | 2022-01-28 | Keweenaw | Michigan | 26083 | 476 | 12 |
2159210 | 2159210 | 2022-01-28 | Lake | Michigan | 26085 | 1664 | 33 |
2159211 | 2159211 | 2022-01-28 | Lapeer | Michigan | 26087 | 19799 | 383 |
2159212 | 2159212 | 2022-01-28 | Leelanau | Michigan | 26089 | 3315 | 44 |
2159213 | 2159213 | 2022-01-28 | Lenawee | Michigan | 26091 | 24374 | 294 |
2159214 | 2159214 | 2022-01-28 | Livingston | Michigan | 26093 | 43640 | 403 |
2159215 | 2159215 | 2022-01-28 | Luce | Michigan | 26095 | 2179 | 8 |
2159216 | 2159216 | 2022-01-28 | Mackinac | Michigan | 26097 | 2224 | 26 |
2159217 | 2159217 | 2022-01-28 | Macomb | Michigan | 26099 | 214423 | 3557 |
2159218 | 2159218 | 2022-01-28 | Manistee | Michigan | 26101 | 4014 | 77 |
2159219 | 2159219 | 2022-01-28 | Marquette | Michigan | 26103 | 14657 | 107 |
2159220 | 2159220 | 2022-01-28 | Mason | Michigan | 26105 | 5979 | 78 |
2159221 | 2159221 | 2022-01-28 | Mecosta | Michigan | 26107 | 7932 | 91 |
2159222 | 2159222 | 2022-01-28 | Menominee | Michigan | 26109 | 5193 | 67 |
2159223 | 2159223 | 2022-01-28 | Midland | Michigan | 26111 | 17675 | 202 |
2159224 | 2159224 | 2022-01-28 | Missaukee | Michigan | 26113 | 2662 | 56 |
2159225 | 2159225 | 2022-01-28 | Monroe | Michigan | 26115 | 35968 | 419 |
2159226 | 2159226 | 2022-01-28 | Montcalm | Michigan | 26117 | 15944 | 192 |
2159227 | 2159227 | 2022-01-28 | Montmorency | Michigan | 26119 | 1594 | 45 |
2159228 | 2159228 | 2022-01-28 | Muskegon | Michigan | 26121 | 39337 | 577 |
2159229 | 2159229 | 2022-01-28 | Newaygo | Michigan | 26123 | 10583 | 141 |
2159230 | 2159230 | 2022-01-28 | Oakland | Michigan | 26125 | 267558 | 3460 |
2159231 | 2159231 | 2022-01-28 | Oceana | Michigan | 26127 | 5808 | 87 |
2159232 | 2159232 | 2022-01-28 | Ogemaw | Michigan | 26129 | 3994 | 88 |
2159233 | 2159233 | 2022-01-28 | Ontonagon | Michigan | 26131 | 921 | 34 |
2159234 | 2159234 | 2022-01-28 | Osceola | Michigan | 26133 | 4627 | 67 |
2159235 | 2159235 | 2022-01-28 | Oscoda | Michigan | 26135 | 1365 | 53 |
2159236 | 2159236 | 2022-01-28 | Otsego | Michigan | 26137 | 5172 | 90 |
2159237 | 2159237 | 2022-01-28 | Ottawa | Michigan | 26139 | 70237 | 722 |
2159238 | 2159238 | 2022-01-28 | Presque Isle | Michigan | 26141 | 1971 | 55 |
2159239 | 2159239 | 2022-01-28 | Roscommon | Michigan | 26143 | 4305 | 109 |
2159240 | 2159240 | 2022-01-28 | Saginaw | Michigan | 26145 | 47151 | 862 |
2159241 | 2159241 | 2022-01-28 | Sanilac | Michigan | 26151 | 8189 | 173 |
2159242 | 2159242 | 2022-01-28 | Schoolcraft | Michigan | 26153 | 1593 | 12 |
2159243 | 2159243 | 2022-01-28 | Shiawassee | Michigan | 26155 | 16609 | 211 |
2159244 | 2159244 | 2022-01-28 | St. Clair | Michigan | 26147 | 38379 | 754 |
2159245 | 2159245 | 2022-01-28 | St. Joseph | Michigan | 26149 | 12916 | 181 |
2159246 | 2159246 | 2022-01-28 | Tuscola | Michigan | 26157 | 12424 | 257 |
2159247 | 2159247 | 2022-01-28 | Unknown | Michigan | 9016 | 28 | |
2159248 | 2159248 | 2022-01-28 | Van Buren | Michigan | 26159 | 15999 | 242 |
2159249 | 2159249 | 2022-01-28 | Washtenaw | Michigan | 26161 | 68693 | 481 |
2159250 | 2159250 | 2022-01-28 | Wayne | Michigan | 26163 | 374385 | 7120 |
2159251 | 2159251 | 2022-01-28 | Wexford | Michigan | 26165 | 6318 | 95 |
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);