ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

25,218 rows where state = "Michigan" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Michigan · 25,218 ✖
Link rowid date ▲ county state fips cases deaths
954214 954214 2021-01-22 Alcona Michigan 26001 391 22
954215 954215 2021-01-22 Alger Michigan 26003 539 3
954216 954216 2021-01-22 Allegan Michigan 26005 6698 97
954217 954217 2021-01-22 Alpena Michigan 26007 1394 43
954218 954218 2021-01-22 Antrim Michigan 26009 950 17
954219 954219 2021-01-22 Arenac Michigan 26011 689 23
954220 954220 2021-01-22 Baraga Michigan 26013 743 31
954221 954221 2021-01-22 Barry Michigan 26015 3424 40
954222 954222 2021-01-22 Bay Michigan 26017 6971 246
954223 954223 2021-01-22 Benzie Michigan 26019 822 29
954224 954224 2021-01-22 Berrien Michigan 26021 10539 217
954225 954225 2021-01-22 Branch Michigan 26023 4368 102
954226 954226 2021-01-22 Calhoun Michigan 26025 8657 209
954227 954227 2021-01-22 Cass Michigan 26027 3619 56
954228 954228 2021-01-22 Charlevoix Michigan 26029 1117 11
954229 954229 2021-01-22 Cheboygan Michigan 26031 846 34
954230 954230 2021-01-22 Chippewa Michigan 26033 4547 34
954231 954231 2021-01-22 Clare Michigan 26035 1436 64
954232 954232 2021-01-22 Clinton Michigan 26037 4600 53
954233 954233 2021-01-22 Crawford Michigan 26039 533 5
954234 954234 2021-01-22 Delta Michigan 26041 3051 80
954235 954235 2021-01-22 Dickinson Michigan 26043 2304 70
954236 954236 2021-01-22 Eaton Michigan 26045 5598 122
954237 954237 2021-01-22 Emmet Michigan 26047 1552 34
954238 954238 2021-01-22 Genesee Michigan 26049 23916 690
954239 954239 2021-01-22 Gladwin Michigan 26051 1377 38
954240 954240 2021-01-22 Gogebic Michigan 26053 1114 39
954241 954241 2021-01-22 Grand Traverse Michigan 26055 3824 55
954242 954242 2021-01-22 Gratiot Michigan 26057 5527 95
954243 954243 2021-01-22 Hillsdale Michigan 26059 3044 69
954244 954244 2021-01-22 Houghton Michigan 26061 2394 36
954245 954245 2021-01-22 Huron Michigan 26063 1910 53
954246 954246 2021-01-22 Ingham Michigan 26065 14493 238
954247 954247 2021-01-22 Ionia Michigan 26067 6017 63
954248 954248 2021-01-22 Iosco Michigan 26069 1222 62
954249 954249 2021-01-22 Iron Michigan 26071 901 41
954250 954250 2021-01-22 Isabella Michigan 26073 3793 65
954251 954251 2021-01-22 Jackson Michigan 26075 13066 223
954252 954252 2021-01-22 Kalamazoo Michigan 26077 13835 293
954253 954253 2021-01-22 Kalkaska Michigan 26079 537 14
954254 954254 2021-01-22 Kent Michigan 26081 48204 627
954255 954255 2021-01-22 Keweenaw Michigan 26083 124 2
954256 954256 2021-01-22 Lake Michigan 26085 340 11
954257 954257 2021-01-22 Lapeer Michigan 26087 4983 119
954258 954258 2021-01-22 Leelanau Michigan 26089 796 10
954259 954259 2021-01-22 Lenawee Michigan 26091 6857 92
954260 954260 2021-01-22 Livingston Michigan 26093 9333 103
954261 954261 2021-01-22 Luce Michigan 26095 1058 1
954262 954262 2021-01-22 Mackinac Michigan 26097 413 3
954263 954263 2021-01-22 Macomb Michigan 26099 54942 1797
954264 954264 2021-01-22 Manistee Michigan 26101 950 20
954265 954265 2021-01-22 Marquette Michigan 26103 4691 54
954266 954266 2021-01-22 Mason Michigan 26105 1143 23
954267 954267 2021-01-22 Mecosta Michigan 26107 1821 17
954268 954268 2021-01-22 Menominee Michigan 26109 1823 36
954269 954269 2021-01-22 Midland Michigan 26111 4593 53
954270 954270 2021-01-22 Missaukee Michigan 26113 648 15
954271 954271 2021-01-22 Monroe Michigan 26115 8876 173
954272 954272 2021-01-22 Montcalm Michigan 26117 5407 84
954273 954273 2021-01-22 Montmorency Michigan 26119 344 14
954274 954274 2021-01-22 Muskegon Michigan 26121 12220 299
954275 954275 2021-01-22 Newaygo Michigan 26123 2561 41
954276 954276 2021-01-22 Oakland Michigan 26125 68795 1836
954277 954277 2021-01-22 Oceana Michigan 26127 1776 45
954278 954278 2021-01-22 Ogemaw Michigan 26129 1029 31
954279 954279 2021-01-22 Ontonagon Michigan 26131 339 17
954280 954280 2021-01-22 Osceola Michigan 26133 965 20
954281 954281 2021-01-22 Oscoda Michigan 26135 349 19
954282 954282 2021-01-22 Otsego Michigan 26137 1251 25
954283 954283 2021-01-22 Ottawa Michigan 26139 20715 317
954284 954284 2021-01-22 Presque Isle Michigan 26141 600 23
954285 954285 2021-01-22 Roscommon Michigan 26143 1063 30
954286 954286 2021-01-22 Saginaw Michigan 26145 14860 464
954287 954287 2021-01-22 Sanilac Michigan 26151 1796 69
954288 954288 2021-01-22 Schoolcraft Michigan 26153 248 5
954289 954289 2021-01-22 Shiawassee Michigan 26155 3454 67
954290 954290 2021-01-22 St. Clair Michigan 26147 8041 211
954291 954291 2021-01-22 St. Joseph Michigan 26149 4261 71
954292 954292 2021-01-22 Tuscola Michigan 26157 2978 122
954293 954293 2021-01-22 Unknown Michigan   0 19
954294 954294 2021-01-22 Van Buren Michigan 26159 4607 91
954295 954295 2021-01-22 Washtenaw Michigan 26161 16402 228
954296 954296 2021-01-22 Wayne Michigan 26163 94480 3901
954297 954297 2021-01-22 Wexford Michigan 26165 1232 19
950969 950969 2021-01-21 Alcona Michigan 26001 391 22
950970 950970 2021-01-21 Alger Michigan 26003 536 3
950971 950971 2021-01-21 Allegan Michigan 26005 6671 97
950972 950972 2021-01-21 Alpena Michigan 26007 1384 43
950973 950973 2021-01-21 Antrim Michigan 26009 945 17
950974 950974 2021-01-21 Arenac Michigan 26011 684 23
950975 950975 2021-01-21 Baraga Michigan 26013 742 31
950976 950976 2021-01-21 Barry Michigan 26015 3409 40
950977 950977 2021-01-21 Bay Michigan 26017 6941 246
950978 950978 2021-01-21 Benzie Michigan 26019 817 29
950979 950979 2021-01-21 Berrien Michigan 26021 10501 217
950980 950980 2021-01-21 Branch Michigan 26023 4345 102
950981 950981 2021-01-21 Calhoun Michigan 26025 8609 208
950982 950982 2021-01-21 Cass Michigan 26027 3603 56
950983 950983 2021-01-21 Charlevoix Michigan 26029 1117 11
950984 950984 2021-01-21 Cheboygan Michigan 26031 844 34

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);