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 2021-09-06 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1691152 | 1691152 | 2021-09-06 | Alcona | Michigan | 26001 | 834 | 37 |
1691153 | 1691153 | 2021-09-06 | Alger | Michigan | 26003 | 719 | 7 |
1691154 | 1691154 | 2021-09-06 | Allegan | Michigan | 26005 | 12148 | 167 |
1691155 | 1691155 | 2021-09-06 | Alpena | Michigan | 26007 | 2515 | 66 |
1691156 | 1691156 | 2021-09-06 | Antrim | Michigan | 26009 | 1786 | 33 |
1691157 | 1691157 | 2021-09-06 | Arenac | Michigan | 26011 | 1302 | 31 |
1691158 | 1691158 | 2021-09-06 | Baraga | Michigan | 26013 | 1062 | 41 |
1691159 | 1691159 | 2021-09-06 | Barry | Michigan | 26015 | 6437 | 74 |
1691160 | 1691160 | 2021-09-06 | Bay | Michigan | 26017 | 11858 | 365 |
1691161 | 1691161 | 2021-09-06 | Benzie | Michigan | 26019 | 1364 | 38 |
1691162 | 1691162 | 2021-09-06 | Berrien | Michigan | 26021 | 16698 | 306 |
1691163 | 1691163 | 2021-09-06 | Branch | Michigan | 26023 | 6427 | 126 |
1691164 | 1691164 | 2021-09-06 | Calhoun | Michigan | 26025 | 15663 | 327 |
1691165 | 1691165 | 2021-09-06 | Cass | Michigan | 26027 | 5930 | 80 |
1691166 | 1691166 | 2021-09-06 | Charlevoix | Michigan | 26029 | 1940 | 27 |
1691167 | 1691167 | 2021-09-06 | Cheboygan | Michigan | 26031 | 2103 | 52 |
1691168 | 1691168 | 2021-09-06 | Chippewa | Michigan | 26033 | 5850 | 50 |
1691169 | 1691169 | 2021-09-06 | Clare | Michigan | 26035 | 2707 | 89 |
1691170 | 1691170 | 2021-09-06 | Clinton | Michigan | 26037 | 8181 | 97 |
1691171 | 1691171 | 2021-09-06 | Crawford | Michigan | 26039 | 1059 | 14 |
1691172 | 1691172 | 2021-09-06 | Delta | Michigan | 26041 | 4544 | 95 |
1691173 | 1691173 | 2021-09-06 | Dickinson | Michigan | 26043 | 2972 | 74 |
1691174 | 1691174 | 2021-09-06 | Eaton | Michigan | 26045 | 10997 | 213 |
1691175 | 1691175 | 2021-09-06 | Emmet | Michigan | 26047 | 2629 | 45 |
1691176 | 1691176 | 2021-09-06 | Genesee | Michigan | 26049 | 44545 | 1006 |
1691177 | 1691177 | 2021-09-06 | Gladwin | Michigan | 26051 | 2471 | 62 |
1691178 | 1691178 | 2021-09-06 | Gogebic | Michigan | 26053 | 1536 | 53 |
1691179 | 1691179 | 2021-09-06 | Grand Traverse | Michigan | 26055 | 7105 | 104 |
1691180 | 1691180 | 2021-09-06 | Gratiot | Michigan | 26057 | 7217 | 127 |
1691181 | 1691181 | 2021-09-06 | Hillsdale | Michigan | 26059 | 4812 | 100 |
1691182 | 1691182 | 2021-09-06 | Houghton | Michigan | 26061 | 3325 | 45 |
1691183 | 1691183 | 2021-09-06 | Huron | Michigan | 26063 | 4309 | 86 |
1691184 | 1691184 | 2021-09-06 | Ingham | Michigan | 26065 | 26637 | 409 |
1691185 | 1691185 | 2021-09-06 | Ionia | Michigan | 26067 | 9812 | 87 |
1691186 | 1691186 | 2021-09-06 | Iosco | Michigan | 26069 | 2197 | 78 |
1691187 | 1691187 | 2021-09-06 | Iron | Michigan | 26071 | 1157 | 53 |
1691188 | 1691188 | 2021-09-06 | Isabella | Michigan | 26073 | 6721 | 102 |
1691189 | 1691189 | 2021-09-06 | Jackson | Michigan | 26075 | 22465 | 336 |
1691190 | 1691190 | 2021-09-06 | Kalamazoo | Michigan | 26077 | 25363 | 418 |
1691191 | 1691191 | 2021-09-06 | Kalkaska | Michigan | 26079 | 1265 | 31 |
1691192 | 1691192 | 2021-09-06 | Kent | Michigan | 26081 | 78715 | 893 |
1691193 | 1691193 | 2021-09-06 | Keweenaw | Michigan | 26083 | 185 | 2 |
1691194 | 1691194 | 2021-09-06 | Lake | Michigan | 26085 | 714 | 17 |
1691195 | 1691195 | 2021-09-06 | Lapeer | Michigan | 26087 | 10362 | 222 |
1691196 | 1691196 | 2021-09-06 | Leelanau | Michigan | 26089 | 1364 | 21 |
1691197 | 1691197 | 2021-09-06 | Lenawee | Michigan | 26091 | 11711 | 183 |
1691198 | 1691198 | 2021-09-06 | Livingston | Michigan | 26093 | 18578 | 206 |
1691199 | 1691199 | 2021-09-06 | Luce | Michigan | 26095 | 1364 | 6 |
1691200 | 1691200 | 2021-09-06 | Mackinac | Michigan | 26097 | 819 | 4 |
1691201 | 1691201 | 2021-09-06 | Macomb | Michigan | 26099 | 106664 | 2547 |
1691202 | 1691202 | 2021-09-06 | Manistee | Michigan | 26101 | 2147 | 28 |
1691203 | 1691203 | 2021-09-06 | Marquette | Michigan | 26103 | 6229 | 67 |
1691204 | 1691204 | 2021-09-06 | Mason | Michigan | 26105 | 2433 | 39 |
1691205 | 1691205 | 2021-09-06 | Mecosta | Michigan | 26107 | 3432 | 39 |
1691206 | 1691206 | 2021-09-06 | Menominee | Michigan | 26109 | 2437 | 44 |
1691207 | 1691207 | 2021-09-06 | Midland | Michigan | 26111 | 8147 | 103 |
1691208 | 1691208 | 2021-09-06 | Missaukee | Michigan | 26113 | 1569 | 29 |
1691209 | 1691209 | 2021-09-06 | Monroe | Michigan | 26115 | 16545 | 277 |
1691210 | 1691210 | 2021-09-06 | Montcalm | Michigan | 26117 | 8612 | 124 |
1691211 | 1691211 | 2021-09-06 | Montmorency | Michigan | 26119 | 695 | 21 |
1691212 | 1691212 | 2021-09-06 | Muskegon | Michigan | 26121 | 19589 | 391 |
1691213 | 1691213 | 2021-09-06 | Newaygo | Michigan | 26123 | 5156 | 71 |
1691214 | 1691214 | 2021-09-06 | Oakland | Michigan | 26125 | 127718 | 2521 |
1691215 | 1691215 | 2021-09-06 | Oceana | Michigan | 26127 | 2907 | 62 |
1691216 | 1691216 | 2021-09-06 | Ogemaw | Michigan | 26129 | 1924 | 45 |
1691217 | 1691217 | 2021-09-06 | Ontonagon | Michigan | 26131 | 535 | 22 |
1691218 | 1691218 | 2021-09-06 | Osceola | Michigan | 26133 | 2098 | 31 |
1691219 | 1691219 | 2021-09-06 | Oscoda | Michigan | 26135 | 730 | 31 |
1691220 | 1691220 | 2021-09-06 | Otsego | Michigan | 26137 | 2577 | 42 |
1691221 | 1691221 | 2021-09-06 | Ottawa | Michigan | 26139 | 35320 | 452 |
1691222 | 1691222 | 2021-09-06 | Presque Isle | Michigan | 26141 | 1119 | 35 |
1691223 | 1691223 | 2021-09-06 | Roscommon | Michigan | 26143 | 1992 | 55 |
1691224 | 1691224 | 2021-09-06 | Saginaw | Michigan | 26145 | 24070 | 647 |
1691225 | 1691225 | 2021-09-06 | Sanilac | Michigan | 26151 | 4403 | 127 |
1691226 | 1691226 | 2021-09-06 | Schoolcraft | Michigan | 26153 | 502 | 5 |
1691227 | 1691227 | 2021-09-06 | Shiawassee | Michigan | 26155 | 7029 | 113 |
1691228 | 1691228 | 2021-09-06 | St. Clair | Michigan | 26147 | 19434 | 464 |
1691229 | 1691229 | 2021-09-06 | St. Joseph | Michigan | 26149 | 6777 | 104 |
1691230 | 1691230 | 2021-09-06 | Tuscola | Michigan | 26157 | 6022 | 179 |
1691231 | 1691231 | 2021-09-06 | Unknown | Michigan | 814 | 18 | |
1691232 | 1691232 | 2021-09-06 | Van Buren | Michigan | 26159 | 7706 | 142 |
1691233 | 1691233 | 2021-09-06 | Washtenaw | Michigan | 26161 | 29280 | 316 |
1691234 | 1691234 | 2021-09-06 | Wayne | Michigan | 26163 | 177167 | 5312 |
1691235 | 1691235 | 2021-09-06 | Wexford | Michigan | 26165 | 3005 | 49 |
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);