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