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 2020-08-18 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 |
---|---|---|---|---|---|---|---|
445154 | 445154 | 2020-08-18 | Alcona | Michigan | 26001 | 29 | 1 |
445155 | 445155 | 2020-08-18 | Alger | Michigan | 26003 | 17 | 0 |
445156 | 445156 | 2020-08-18 | Allegan | Michigan | 26005 | 573 | 6 |
445157 | 445157 | 2020-08-18 | Alpena | Michigan | 26007 | 130 | 14 |
445158 | 445158 | 2020-08-18 | Antrim | Michigan | 26009 | 43 | 0 |
445159 | 445159 | 2020-08-18 | Arenac | Michigan | 26011 | 49 | 3 |
445160 | 445160 | 2020-08-18 | Baraga | Michigan | 26013 | 6 | 0 |
445161 | 445161 | 2020-08-18 | Barry | Michigan | 26015 | 198 | 2 |
445162 | 445162 | 2020-08-18 | Bay | Michigan | 26017 | 724 | 35 |
445163 | 445163 | 2020-08-18 | Benzie | Michigan | 26019 | 37 | 1 |
445164 | 445164 | 2020-08-18 | Berrien | Michigan | 26021 | 1537 | 69 |
445165 | 445165 | 2020-08-18 | Branch | Michigan | 26023 | 1202 | 25 |
445166 | 445166 | 2020-08-18 | Calhoun | Michigan | 26025 | 853 | 43 |
445167 | 445167 | 2020-08-18 | Cass | Michigan | 26027 | 369 | 15 |
445168 | 445168 | 2020-08-18 | Charlevoix | Michigan | 26029 | 62 | 2 |
445169 | 445169 | 2020-08-18 | Cheboygan | Michigan | 26031 | 57 | 2 |
445170 | 445170 | 2020-08-18 | Chippewa | Michigan | 26033 | 48 | 0 |
445171 | 445171 | 2020-08-18 | Clare | Michigan | 26035 | 88 | 3 |
445172 | 445172 | 2020-08-18 | Clinton | Michigan | 26037 | 443 | 13 |
445173 | 445173 | 2020-08-18 | Crawford | Michigan | 26039 | 111 | 5 |
445174 | 445174 | 2020-08-18 | Delta | Michigan | 26041 | 116 | 3 |
445175 | 445175 | 2020-08-18 | Dickinson | Michigan | 26043 | 60 | 2 |
445176 | 445176 | 2020-08-18 | Eaton | Michigan | 26045 | 476 | 8 |
445177 | 445177 | 2020-08-18 | Emmet | Michigan | 26047 | 88 | 2 |
445178 | 445178 | 2020-08-18 | Genesee | Michigan | 26049 | 3774 | 298 |
445179 | 445179 | 2020-08-18 | Gladwin | Michigan | 26051 | 70 | 2 |
445180 | 445180 | 2020-08-18 | Gogebic | Michigan | 26053 | 137 | 1 |
445181 | 445181 | 2020-08-18 | Grand Traverse | Michigan | 26055 | 253 | 5 |
445182 | 445182 | 2020-08-18 | Gratiot | Michigan | 26057 | 174 | 15 |
445183 | 445183 | 2020-08-18 | Hillsdale | Michigan | 26059 | 283 | 25 |
445184 | 445184 | 2020-08-18 | Houghton | Michigan | 26061 | 55 | 0 |
445185 | 445185 | 2020-08-18 | Huron | Michigan | 26063 | 178 | 4 |
445186 | 445186 | 2020-08-18 | Ingham | Michigan | 26065 | 1640 | 33 |
445187 | 445187 | 2020-08-18 | Ionia | Michigan | 26067 | 281 | 7 |
445188 | 445188 | 2020-08-18 | Iosco | Michigan | 26069 | 138 | 12 |
445189 | 445189 | 2020-08-18 | Iron | Michigan | 26071 | 23 | 1 |
445190 | 445190 | 2020-08-18 | Isabella | Michigan | 26073 | 228 | 9 |
445191 | 445191 | 2020-08-18 | Jackson | Michigan | 26075 | 2473 | 58 |
445192 | 445192 | 2020-08-18 | Kalamazoo | Michigan | 26077 | 1766 | 86 |
445193 | 445193 | 2020-08-18 | Kalkaska | Michigan | 26079 | 57 | 4 |
445194 | 445194 | 2020-08-18 | Kent | Michigan | 26081 | 7850 | 158 |
445195 | 445195 | 2020-08-18 | Keweenaw | Michigan | 26083 | 2 | 0 |
445196 | 445196 | 2020-08-18 | Lake | Michigan | 26085 | 29 | 0 |
445197 | 445197 | 2020-08-18 | Lapeer | Michigan | 26087 | 816 | 40 |
445198 | 445198 | 2020-08-18 | Leelanau | Michigan | 26089 | 76 | 0 |
445199 | 445199 | 2020-08-18 | Lenawee | Michigan | 26091 | 1208 | 17 |
445200 | 445200 | 2020-08-18 | Livingston | Michigan | 26093 | 987 | 30 |
445201 | 445201 | 2020-08-18 | Luce | Michigan | 26095 | 33 | 0 |
445202 | 445202 | 2020-08-18 | Mackinac | Michigan | 26097 | 28 | 0 |
445203 | 445203 | 2020-08-18 | Macomb | Michigan | 26099 | 11727 | 961 |
445204 | 445204 | 2020-08-18 | Manistee | Michigan | 26101 | 55 | 1 |
445205 | 445205 | 2020-08-18 | Marquette | Michigan | 26103 | 210 | 11 |
445206 | 445206 | 2020-08-18 | Mason | Michigan | 26105 | 108 | 0 |
445207 | 445207 | 2020-08-18 | Mecosta | Michigan | 26107 | 76 | 2 |
445208 | 445208 | 2020-08-18 | Menominee | Michigan | 26109 | 196 | 0 |
445209 | 445209 | 2020-08-18 | Midland | Michigan | 26111 | 363 | 10 |
445210 | 445210 | 2020-08-18 | Missaukee | Michigan | 26113 | 42 | 1 |
445211 | 445211 | 2020-08-18 | Monroe | Michigan | 26115 | 1094 | 24 |
445212 | 445212 | 2020-08-18 | Montcalm | Michigan | 26117 | 209 | 3 |
445213 | 445213 | 2020-08-18 | Montmorency | Michigan | 26119 | 8 | 0 |
445214 | 445214 | 2020-08-18 | Muskegon | Michigan | 26121 | 1455 | 63 |
445215 | 445215 | 2020-08-18 | Newaygo | Michigan | 26123 | 275 | 0 |
445216 | 445216 | 2020-08-18 | Oakland | Michigan | 26125 | 16641 | 1144 |
445217 | 445217 | 2020-08-18 | Oceana | Michigan | 26127 | 492 | 6 |
445218 | 445218 | 2020-08-18 | Ogemaw | Michigan | 26129 | 54 | 3 |
445219 | 445219 | 2020-08-18 | Ontonagon | Michigan | 26131 | 30 | 0 |
445220 | 445220 | 2020-08-18 | Osceola | Michigan | 26133 | 71 | 0 |
445221 | 445221 | 2020-08-18 | Oscoda | Michigan | 26135 | 29 | 1 |
445222 | 445222 | 2020-08-18 | Otsego | Michigan | 26137 | 147 | 11 |
445223 | 445223 | 2020-08-18 | Ottawa | Michigan | 26139 | 1955 | 59 |
445224 | 445224 | 2020-08-18 | Presque Isle | Michigan | 26141 | 21 | 1 |
445225 | 445225 | 2020-08-18 | Roscommon | Michigan | 26143 | 59 | 2 |
445226 | 445226 | 2020-08-18 | Saginaw | Michigan | 26145 | 2215 | 128 |
445227 | 445227 | 2020-08-18 | Sanilac | Michigan | 26151 | 117 | 6 |
445228 | 445228 | 2020-08-18 | Schoolcraft | Michigan | 26153 | 14 | 0 |
445229 | 445229 | 2020-08-18 | Shiawassee | Michigan | 26155 | 361 | 29 |
445230 | 445230 | 2020-08-18 | St. Clair | Michigan | 26147 | 851 | 53 |
445231 | 445231 | 2020-08-18 | St. Joseph | Michigan | 26149 | 636 | 10 |
445232 | 445232 | 2020-08-18 | Tuscola | Michigan | 26157 | 391 | 29 |
445233 | 445233 | 2020-08-18 | Unknown | Michigan | 542 | 3 | |
445234 | 445234 | 2020-08-18 | Van Buren | Michigan | 26159 | 514 | 13 |
445235 | 445235 | 2020-08-18 | Washtenaw | Michigan | 26161 | 3191 | 123 |
445236 | 445236 | 2020-08-18 | Wayne | Michigan | 26163 | 29424 | 2847 |
445237 | 445237 | 2020-08-18 | Wexford | Michigan | 26165 | 79 | 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);