ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2022-02-01" 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 |
---|---|---|---|---|---|---|---|
2172186 | 2172186 | 2022-02-01 | Alcona | Michigan | 26001 | 1619 | 66 |
2172187 | 2172187 | 2022-02-01 | Alger | Michigan | 26003 | 1759 | 12 |
2172188 | 2172188 | 2022-02-01 | Allegan | Michigan | 26005 | 25605 | 307 |
2172189 | 2172189 | 2022-02-01 | Alpena | Michigan | 26007 | 5183 | 123 |
2172190 | 2172190 | 2022-02-01 | Antrim | Michigan | 26009 | 4055 | 53 |
2172191 | 2172191 | 2022-02-01 | Arenac | Michigan | 26011 | 2985 | 60 |
2172192 | 2172192 | 2022-02-01 | Baraga | Michigan | 26013 | 2080 | 52 |
2172193 | 2172193 | 2022-02-01 | Barry | Michigan | 26015 | 13526 | 148 |
2172194 | 2172194 | 2022-02-01 | Bay | Michigan | 26017 | 25569 | 531 |
2172195 | 2172195 | 2022-02-01 | Benzie | Michigan | 26019 | 3215 | 60 |
2172196 | 2172196 | 2022-02-01 | Berrien | Michigan | 26021 | 33042 | 468 |
2172197 | 2172197 | 2022-02-01 | Branch | Michigan | 26023 | 11525 | 181 |
2172198 | 2172198 | 2022-02-01 | Calhoun | Michigan | 26025 | 32116 | 524 |
2172199 | 2172199 | 2022-02-01 | Cass | Michigan | 26027 | 10678 | 124 |
2172200 | 2172200 | 2022-02-01 | Charlevoix | Michigan | 26029 | 4708 | 55 |
2172201 | 2172201 | 2022-02-01 | Cheboygan | Michigan | 26031 | 4368 | 88 |
2172202 | 2172202 | 2022-02-01 | Chippewa | Michigan | 26033 | 10857 | 98 |
2172203 | 2172203 | 2022-02-01 | Clare | Michigan | 26035 | 6288 | 147 |
2172204 | 2172204 | 2022-02-01 | Clinton | Michigan | 26037 | 19189 | 185 |
2172205 | 2172205 | 2022-02-01 | Crawford | Michigan | 26039 | 2357 | 23 |
2172206 | 2172206 | 2022-02-01 | Delta | Michigan | 26041 | 9356 | 144 |
2172207 | 2172207 | 2022-02-01 | Dickinson | Michigan | 26043 | 6977 | 98 |
2172208 | 2172208 | 2022-02-01 | Eaton | Michigan | 26045 | 25035 | 349 |
2172209 | 2172209 | 2022-02-01 | Emmet | Michigan | 26047 | 6089 | 70 |
2172210 | 2172210 | 2022-02-01 | Genesee | Michigan | 26049 | 95914 | 1528 |
2172211 | 2172211 | 2022-02-01 | Gladwin | Michigan | 26051 | 5263 | 105 |
2172212 | 2172212 | 2022-02-01 | Gogebic | Michigan | 26053 | 3094 | 64 |
2172213 | 2172213 | 2022-02-01 | Grand Traverse | Michigan | 26055 | 15980 | 195 |
2172214 | 2172214 | 2022-02-01 | Gratiot | Michigan | 26057 | 12696 | 174 |
2172215 | 2172215 | 2022-02-01 | Hillsdale | Michigan | 26059 | 9745 | 180 |
2172216 | 2172216 | 2022-02-01 | Houghton | Michigan | 26061 | 7407 | 82 |
2172217 | 2172217 | 2022-02-01 | Huron | Michigan | 26063 | 7680 | 136 |
2172218 | 2172218 | 2022-02-01 | Ingham | Michigan | 26065 | 59942 | 670 |
2172219 | 2172219 | 2022-02-01 | Ionia | Michigan | 26067 | 18433 | 166 |
2172220 | 2172220 | 2022-02-01 | Iosco | Michigan | 26069 | 4491 | 128 |
2172221 | 2172221 | 2022-02-01 | Iron | Michigan | 26071 | 2483 | 74 |
2172222 | 2172222 | 2022-02-01 | Isabella | Michigan | 26073 | 14663 | 182 |
2172223 | 2172223 | 2022-02-01 | Jackson | Michigan | 26075 | 42863 | 510 |
2172224 | 2172224 | 2022-02-01 | Kalamazoo | Michigan | 26077 | 55084 | 608 |
2172225 | 2172225 | 2022-02-01 | Kalkaska | Michigan | 26079 | 3282 | 48 |
2172226 | 2172226 | 2022-02-01 | Kent | Michigan | 26081 | 158331 | 1382 |
2172227 | 2172227 | 2022-02-01 | Keweenaw | Michigan | 26083 | 482 | 12 |
2172228 | 2172228 | 2022-02-01 | Lake | Michigan | 26085 | 1687 | 33 |
2172229 | 2172229 | 2022-02-01 | Lapeer | Michigan | 26087 | 19964 | 385 |
2172230 | 2172230 | 2022-02-01 | Leelanau | Michigan | 26089 | 3341 | 44 |
2172231 | 2172231 | 2022-02-01 | Lenawee | Michigan | 26091 | 24593 | 294 |
2172232 | 2172232 | 2022-02-01 | Livingston | Michigan | 26093 | 43959 | 404 |
2172233 | 2172233 | 2022-02-01 | Luce | Michigan | 26095 | 2186 | 8 |
2172234 | 2172234 | 2022-02-01 | Mackinac | Michigan | 26097 | 2241 | 26 |
2172235 | 2172235 | 2022-02-01 | Macomb | Michigan | 26099 | 216996 | 3564 |
2172236 | 2172236 | 2022-02-01 | Manistee | Michigan | 26101 | 4087 | 77 |
2172237 | 2172237 | 2022-02-01 | Marquette | Michigan | 26103 | 14851 | 107 |
2172238 | 2172238 | 2022-02-01 | Mason | Michigan | 26105 | 6100 | 78 |
2172239 | 2172239 | 2022-02-01 | Mecosta | Michigan | 26107 | 8041 | 91 |
2172240 | 2172240 | 2022-02-01 | Menominee | Michigan | 26109 | 5238 | 67 |
2172241 | 2172241 | 2022-02-01 | Midland | Michigan | 26111 | 17875 | 203 |
2172242 | 2172242 | 2022-02-01 | Missaukee | Michigan | 26113 | 2699 | 57 |
2172243 | 2172243 | 2022-02-01 | Monroe | Michigan | 26115 | 36243 | 419 |
2172244 | 2172244 | 2022-02-01 | Montcalm | Michigan | 26117 | 16164 | 192 |
2172245 | 2172245 | 2022-02-01 | Montmorency | Michigan | 26119 | 1613 | 45 |
2172246 | 2172246 | 2022-02-01 | Muskegon | Michigan | 26121 | 39628 | 578 |
2172247 | 2172247 | 2022-02-01 | Newaygo | Michigan | 26123 | 10748 | 141 |
2172248 | 2172248 | 2022-02-01 | Oakland | Michigan | 26125 | 270830 | 3463 |
2172249 | 2172249 | 2022-02-01 | Oceana | Michigan | 26127 | 5881 | 87 |
2172250 | 2172250 | 2022-02-01 | Ogemaw | Michigan | 26129 | 4036 | 88 |
2172251 | 2172251 | 2022-02-01 | Ontonagon | Michigan | 26131 | 926 | 34 |
2172252 | 2172252 | 2022-02-01 | Osceola | Michigan | 26133 | 4666 | 67 |
2172253 | 2172253 | 2022-02-01 | Oscoda | Michigan | 26135 | 1374 | 53 |
2172254 | 2172254 | 2022-02-01 | Otsego | Michigan | 26137 | 5292 | 90 |
2172255 | 2172255 | 2022-02-01 | Ottawa | Michigan | 26139 | 70822 | 723 |
2172256 | 2172256 | 2022-02-01 | Presque Isle | Michigan | 26141 | 1990 | 55 |
2172257 | 2172257 | 2022-02-01 | Roscommon | Michigan | 26143 | 4332 | 109 |
2172258 | 2172258 | 2022-02-01 | Saginaw | Michigan | 26145 | 47616 | 863 |
2172259 | 2172259 | 2022-02-01 | Sanilac | Michigan | 26151 | 8239 | 174 |
2172260 | 2172260 | 2022-02-01 | Schoolcraft | Michigan | 26153 | 1602 | 12 |
2172261 | 2172261 | 2022-02-01 | Shiawassee | Michigan | 26155 | 16763 | 211 |
2172262 | 2172262 | 2022-02-01 | St. Clair | Michigan | 26147 | 38638 | 754 |
2172263 | 2172263 | 2022-02-01 | St. Joseph | Michigan | 26149 | 13050 | 181 |
2172264 | 2172264 | 2022-02-01 | Tuscola | Michigan | 26157 | 12530 | 257 |
2172265 | 2172265 | 2022-02-01 | Unknown | Michigan | 9013 | 28 | |
2172266 | 2172266 | 2022-02-01 | Van Buren | Michigan | 26159 | 16127 | 242 |
2172267 | 2172267 | 2022-02-01 | Washtenaw | Michigan | 26161 | 69514 | 483 |
2172268 | 2172268 | 2022-02-01 | Wayne | Michigan | 26163 | 378746 | 7133 |
2172269 | 2172269 | 2022-02-01 | Wexford | Michigan | 26165 | 6433 | 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);