ny_times_us_counties

⚠️ 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

8,166 rows where state = "Michigan" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Michigan · 8,166
Link rowid date ▲ county state fips cases deaths
292984 2020-07-03 Alcona Michigan 26001 22 1
292985 2020-07-03 Alger Michigan 26003 4 0
292986 2020-07-03 Allegan Michigan 26005 328 7
292987 2020-07-03 Alpena Michigan 26007 123 12
292988 2020-07-03 Antrim Michigan 26009 21 0
292989 2020-07-03 Arenac Michigan 26011 38 2
292990 2020-07-03 Baraga Michigan 26013 5 0
292991 2020-07-03 Barry Michigan 26015 108 2
292992 2020-07-03 Bay Michigan 26017 401 30
292993 2020-07-03 Benzie Michigan 26019 10 0
292994 2020-07-03 Berrien Michigan 26021 963 60
292995 2020-07-03 Branch Michigan 26023 1053 25
292996 2020-07-03 Calhoun Michigan 26025 557 36
292997 2020-07-03 Cass Michigan 26027 156 5
292998 2020-07-03 Charlevoix Michigan 26029 30 2
292999 2020-07-03 Cheboygan Michigan 26031 27 2
293000 2020-07-03 Chippewa Michigan 26033 13 0
293001 2020-07-03 Clare Michigan 26035 30 3
293002 2020-07-03 Clinton Michigan 26037 241 12
293003 2020-07-03 Crawford Michigan 26039 70 5
293004 2020-07-03 Delta Michigan 26041 27 3
293005 2020-07-03 Dickinson Michigan 26043 9 2
293006 2020-07-03 Eaton Michigan 26045 328 7
293007 2020-07-03 Emmet Michigan 26047 29 2
293008 2020-07-03 Genesee Michigan 26049 2789 288
293009 2020-07-03 Gladwin Michigan 26051 27 1
293010 2020-07-03 Gogebic Michigan 26053 7 1
293011 2020-07-03 Grand Traverse Michigan 26055 55 5
293012 2020-07-03 Gratiot Michigan 26057 99 13
293013 2020-07-03 Hillsdale Michigan 26059 197 25
293014 2020-07-03 Houghton Michigan 26061 16 0
293015 2020-07-03 Huron Michigan 26063 66 3
293016 2020-07-03 Ingham Michigan 26065 1070 29
293017 2020-07-03 Ionia Michigan 26067 203 4
293018 2020-07-03 Iosco Michigan 26069 118 11
293019 2020-07-03 Iron Michigan 26071 6 1
293020 2020-07-03 Isabella Michigan 26073 129 8
293021 2020-07-03 Jackson Michigan 26075 2128 53
293022 2020-07-03 Kalamazoo Michigan 26077 1103 68
293023 2020-07-03 Kalkaska Michigan 26079 35 2
293024 2020-07-03 Kent Michigan 26081 5165 136
293025 2020-07-03 Keweenaw Michigan 26083 1 0
293026 2020-07-03 Lake Michigan 26085 9 0
293027 2020-07-03 Lapeer Michigan 26087 608 38
293028 2020-07-03 Leelanau Michigan 26089 19 0
293029 2020-07-03 Lenawee Michigan 26091 964 10
293030 2020-07-03 Livingston Michigan 26093 632 29
293031 2020-07-03 Luce Michigan 26095 4 0
293032 2020-07-03 Mackinac Michigan 26097 9 0
293033 2020-07-03 Macomb Michigan 26099 7742 924
293034 2020-07-03 Manistee Michigan 26101 33 0
293035 2020-07-03 Marquette Michigan 26103 71 11
293036 2020-07-03 Mason Michigan 26105 58 0
293037 2020-07-03 Mecosta Michigan 26107 30 2
293038 2020-07-03 Menominee Michigan 26109 21 0
293039 2020-07-03 Midland Michigan 26111 171 9
293040 2020-07-03 Missaukee Michigan 26113 29 1
293041 2020-07-03 Monroe Michigan 26115 626 21
293042 2020-07-03 Montcalm Michigan 26117 100 1
293043 2020-07-03 Montmorency Michigan 26119 5 0
293044 2020-07-03 Muskegon Michigan 26121 842 52
293045 2020-07-03 Newaygo Michigan 26123 177 0
293046 2020-07-03 Oakland Michigan 26125 12160 1091
293047 2020-07-03 Oceana Michigan 26127 320 3
293048 2020-07-03 Ogemaw Michigan 26129 35 2
293049 2020-07-03 Osceola Michigan 26133 30 0
293050 2020-07-03 Oscoda Michigan 26135 21 1
293051 2020-07-03 Otsego Michigan 26137 134 10
293052 2020-07-03 Ottawa Michigan 26139 1096 51
293053 2020-07-03 Presque Isle Michigan 26141 13 0
293054 2020-07-03 Roscommon Michigan 26143 28 0
293055 2020-07-03 Saginaw Michigan 26145 1316 123
293056 2020-07-03 Sanilac Michigan 26151 50 6
293057 2020-07-03 Schoolcraft Michigan 26153 5 0
293058 2020-07-03 Shiawassee Michigan 26155 276 28
293059 2020-07-03 St. Clair Michigan 26147 579 50
293060 2020-07-03 St. Joseph Michigan 26149 339 4
293061 2020-07-03 Tuscola Michigan 26157 233 26
293062 2020-07-03 Unknown Michigan   153 2
293063 2020-07-03 Van Buren Michigan 26159 232 8
293064 2020-07-03 Washtenaw Michigan 26161 2217 116
293065 2020-07-03 Wayne Michigan 26163 23078 2730
293066 2020-07-03 Wexford Michigan 26165 34 4
289905 2020-07-02 Alcona Michigan 26001 22 1
289906 2020-07-02 Alger Michigan 26003 4 0
289907 2020-07-02 Allegan Michigan 26005 325 7
289908 2020-07-02 Alpena Michigan 26007 122 12
289909 2020-07-02 Antrim Michigan 26009 20 0
289910 2020-07-02 Arenac Michigan 26011 38 2
289911 2020-07-02 Baraga Michigan 26013 5 0
289912 2020-07-02 Barry Michigan 26015 106 2
289913 2020-07-02 Bay Michigan 26017 396 30
289914 2020-07-02 Benzie Michigan 26019 10 0
289915 2020-07-02 Berrien Michigan 26021 963 60
289916 2020-07-02 Branch Michigan 26023 1050 25
289917 2020-07-02 Calhoun Michigan 26025 550 36
289918 2020-07-02 Cass Michigan 26027 152 5
289919 2020-07-02 Charlevoix Michigan 26029 30 2
289920 2020-07-02 Cheboygan Michigan 26031 27 2
289921 2020-07-02 Chippewa Michigan 26033 12 0

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
);
Powered by Datasette · Query took 980.972ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette