ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-10-20" 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 |
---|---|---|---|---|---|---|---|
649111 | 649111 | 2020-10-20 | Alcona | Michigan | 26001 | 51 | 2 |
649112 | 649112 | 2020-10-20 | Alger | Michigan | 26003 | 99 | 1 |
649113 | 649113 | 2020-10-20 | Allegan | Michigan | 26005 | 1088 | 7 |
649114 | 649114 | 2020-10-20 | Alpena | Michigan | 26007 | 155 | 14 |
649115 | 649115 | 2020-10-20 | Antrim | Michigan | 26009 | 104 | 0 |
649116 | 649116 | 2020-10-20 | Arenac | Michigan | 26011 | 89 | 3 |
649117 | 649117 | 2020-10-20 | Baraga | Michigan | 26013 | 75 | 4 |
649118 | 649118 | 2020-10-20 | Barry | Michigan | 26015 | 552 | 5 |
649119 | 649119 | 2020-10-20 | Bay | Michigan | 26017 | 1254 | 55 |
649120 | 649120 | 2020-10-20 | Benzie | Michigan | 26019 | 109 | 2 |
649121 | 649121 | 2020-10-20 | Berrien | Michigan | 26021 | 2492 | 80 |
649122 | 649122 | 2020-10-20 | Branch | Michigan | 26023 | 1614 | 33 |
649123 | 649123 | 2020-10-20 | Calhoun | Michigan | 26025 | 2308 | 54 |
649124 | 649124 | 2020-10-20 | Cass | Michigan | 26027 | 875 | 23 |
649125 | 649125 | 2020-10-20 | Charlevoix | Michigan | 26029 | 143 | 4 |
649126 | 649126 | 2020-10-20 | Cheboygan | Michigan | 26031 | 118 | 2 |
649127 | 649127 | 2020-10-20 | Chippewa | Michigan | 26033 | 111 | 0 |
649128 | 649128 | 2020-10-20 | Clare | Michigan | 26035 | 219 | 8 |
649129 | 649129 | 2020-10-20 | Clinton | Michigan | 26037 | 918 | 14 |
649130 | 649130 | 2020-10-20 | Crawford | Michigan | 26039 | 140 | 5 |
649131 | 649131 | 2020-10-20 | Delta | Michigan | 26041 | 1027 | 19 |
649132 | 649132 | 2020-10-20 | Dickinson | Michigan | 26043 | 497 | 10 |
649133 | 649133 | 2020-10-20 | Eaton | Michigan | 26045 | 984 | 10 |
649134 | 649134 | 2020-10-20 | Emmet | Michigan | 26047 | 192 | 4 |
649135 | 649135 | 2020-10-20 | Genesee | Michigan | 26049 | 6104 | 327 |
649136 | 649136 | 2020-10-20 | Gladwin | Michigan | 26051 | 166 | 2 |
649137 | 649137 | 2020-10-20 | Gogebic | Michigan | 26053 | 302 | 2 |
649138 | 649138 | 2020-10-20 | Grand Traverse | Michigan | 26055 | 666 | 13 |
649139 | 649139 | 2020-10-20 | Gratiot | Michigan | 26057 | 423 | 16 |
649140 | 649140 | 2020-10-20 | Hillsdale | Michigan | 26059 | 462 | 27 |
649141 | 649141 | 2020-10-20 | Houghton | Michigan | 26061 | 859 | 7 |
649142 | 649142 | 2020-10-20 | Huron | Michigan | 26063 | 259 | 5 |
649143 | 649143 | 2020-10-20 | Ingham | Michigan | 26065 | 4350 | 61 |
649144 | 649144 | 2020-10-20 | Ionia | Michigan | 26067 | 767 | 8 |
649145 | 649145 | 2020-10-20 | Iosco | Michigan | 26069 | 270 | 15 |
649146 | 649146 | 2020-10-20 | Iron | Michigan | 26071 | 382 | 20 |
649147 | 649147 | 2020-10-20 | Isabella | Michigan | 26073 | 938 | 15 |
649148 | 649148 | 2020-10-20 | Jackson | Michigan | 26075 | 3261 | 84 |
649149 | 649149 | 2020-10-20 | Kalamazoo | Michigan | 26077 | 4290 | 102 |
649150 | 649150 | 2020-10-20 | Kalkaska | Michigan | 26079 | 117 | 4 |
649151 | 649151 | 2020-10-20 | Kent | Michigan | 26081 | 12820 | 179 |
649152 | 649152 | 2020-10-20 | Keweenaw | Michigan | 26083 | 18 | 0 |
649153 | 649153 | 2020-10-20 | Lake | Michigan | 26085 | 55 | 0 |
649154 | 649154 | 2020-10-20 | Lapeer | Michigan | 26087 | 1129 | 45 |
649155 | 649155 | 2020-10-20 | Leelanau | Michigan | 26089 | 136 | 2 |
649156 | 649156 | 2020-10-20 | Lenawee | Michigan | 26091 | 1765 | 22 |
649157 | 649157 | 2020-10-20 | Livingston | Michigan | 26093 | 1868 | 34 |
649158 | 649158 | 2020-10-20 | Luce | Michigan | 26095 | 290 | 0 |
649159 | 649159 | 2020-10-20 | Mackinac | Michigan | 26097 | 143 | 0 |
649160 | 649160 | 2020-10-20 | Macomb | Michigan | 26099 | 17460 | 1071 |
649161 | 649161 | 2020-10-20 | Manistee | Michigan | 26101 | 127 | 3 |
649162 | 649162 | 2020-10-20 | Marquette | Michigan | 26103 | 860 | 12 |
649163 | 649163 | 2020-10-20 | Mason | Michigan | 26105 | 191 | 1 |
649164 | 649164 | 2020-10-20 | Mecosta | Michigan | 26107 | 405 | 4 |
649165 | 649165 | 2020-10-20 | Menominee | Michigan | 26109 | 627 | 3 |
649166 | 649166 | 2020-10-20 | Midland | Michigan | 26111 | 840 | 13 |
649167 | 649167 | 2020-10-20 | Missaukee | Michigan | 26113 | 82 | 1 |
649168 | 649168 | 2020-10-20 | Monroe | Michigan | 26115 | 1851 | 31 |
649169 | 649169 | 2020-10-20 | Montcalm | Michigan | 26117 | 523 | 8 |
649170 | 649170 | 2020-10-20 | Montmorency | Michigan | 26119 | 21 | 0 |
649171 | 649171 | 2020-10-20 | Muskegon | Michigan | 26121 | 2849 | 80 |
649172 | 649172 | 2020-10-20 | Newaygo | Michigan | 26123 | 542 | 3 |
649173 | 649173 | 2020-10-20 | Oakland | Michigan | 26125 | 23394 | 1228 |
649174 | 649174 | 2020-10-20 | Oceana | Michigan | 26127 | 577 | 6 |
649175 | 649175 | 2020-10-20 | Ogemaw | Michigan | 26129 | 90 | 5 |
649176 | 649176 | 2020-10-20 | Ontonagon | Michigan | 26131 | 73 | 0 |
649177 | 649177 | 2020-10-20 | Osceola | Michigan | 26133 | 126 | 0 |
649178 | 649178 | 2020-10-20 | Oscoda | Michigan | 26135 | 54 | 1 |
649179 | 649179 | 2020-10-20 | Otsego | Michigan | 26137 | 229 | 12 |
649180 | 649180 | 2020-10-20 | Ottawa | Michigan | 26139 | 4508 | 72 |
649181 | 649181 | 2020-10-20 | Presque Isle | Michigan | 26141 | 41 | 1 |
649182 | 649182 | 2020-10-20 | Roscommon | Michigan | 26143 | 140 | 5 |
649183 | 649183 | 2020-10-20 | Saginaw | Michigan | 26145 | 3479 | 149 |
649184 | 649184 | 2020-10-20 | Sanilac | Michigan | 26151 | 171 | 7 |
649185 | 649185 | 2020-10-20 | Schoolcraft | Michigan | 26153 | 54 | 0 |
649186 | 649186 | 2020-10-20 | Shiawassee | Michigan | 26155 | 636 | 33 |
649187 | 649187 | 2020-10-20 | St. Clair | Michigan | 26147 | 1341 | 63 |
649188 | 649188 | 2020-10-20 | St. Joseph | Michigan | 26149 | 1083 | 12 |
649189 | 649189 | 2020-10-20 | Tuscola | Michigan | 26157 | 600 | 34 |
649190 | 649190 | 2020-10-20 | Unknown | Michigan | 747 | 4 | |
649191 | 649191 | 2020-10-20 | Van Buren | Michigan | 26159 | 967 | 18 |
649192 | 649192 | 2020-10-20 | Washtenaw | Michigan | 26161 | 5360 | 126 |
649193 | 649193 | 2020-10-20 | Wayne | Michigan | 26163 | 38690 | 3027 |
649194 | 649194 | 2020-10-20 | Wexford | Michigan | 26165 | 157 | 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);