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-10-12 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
623150 | 623150 | 2020-10-12 | Alcona | Michigan | 26001 | 48 | 2 |
623151 | 623151 | 2020-10-12 | Alger | Michigan | 26003 | 50 | 0 |
623152 | 623152 | 2020-10-12 | Allegan | Michigan | 26005 | 927 | 7 |
623153 | 623153 | 2020-10-12 | Alpena | Michigan | 26007 | 148 | 14 |
623154 | 623154 | 2020-10-12 | Antrim | Michigan | 26009 | 82 | 0 |
623155 | 623155 | 2020-10-12 | Arenac | Michigan | 26011 | 82 | 3 |
623156 | 623156 | 2020-10-12 | Baraga | Michigan | 26013 | 57 | 3 |
623157 | 623157 | 2020-10-12 | Barry | Michigan | 26015 | 441 | 4 |
623158 | 623158 | 2020-10-12 | Bay | Michigan | 26017 | 1138 | 54 |
623159 | 623159 | 2020-10-12 | Benzie | Michigan | 26019 | 94 | 2 |
623160 | 623160 | 2020-10-12 | Berrien | Michigan | 26021 | 2203 | 76 |
623161 | 623161 | 2020-10-12 | Branch | Michigan | 26023 | 1518 | 32 |
623162 | 623162 | 2020-10-12 | Calhoun | Michigan | 26025 | 1877 | 51 |
623163 | 623163 | 2020-10-12 | Cass | Michigan | 26027 | 700 | 21 |
623164 | 623164 | 2020-10-12 | Charlevoix | Michigan | 26029 | 126 | 4 |
623165 | 623165 | 2020-10-12 | Cheboygan | Michigan | 26031 | 101 | 2 |
623166 | 623166 | 2020-10-12 | Chippewa | Michigan | 26033 | 91 | 0 |
623167 | 623167 | 2020-10-12 | Clare | Michigan | 26035 | 152 | 6 |
623168 | 623168 | 2020-10-12 | Clinton | Michigan | 26037 | 805 | 14 |
623169 | 623169 | 2020-10-12 | Crawford | Michigan | 26039 | 132 | 5 |
623170 | 623170 | 2020-10-12 | Delta | Michigan | 26041 | 832 | 14 |
623171 | 623171 | 2020-10-12 | Dickinson | Michigan | 26043 | 332 | 4 |
623172 | 623172 | 2020-10-12 | Eaton | Michigan | 26045 | 828 | 10 |
623173 | 623173 | 2020-10-12 | Emmet | Michigan | 26047 | 178 | 4 |
623174 | 623174 | 2020-10-12 | Genesee | Michigan | 26049 | 5389 | 314 |
623175 | 623175 | 2020-10-12 | Gladwin | Michigan | 26051 | 133 | 2 |
623176 | 623176 | 2020-10-12 | Gogebic | Michigan | 26053 | 196 | 2 |
623177 | 623177 | 2020-10-12 | Grand Traverse | Michigan | 26055 | 587 | 10 |
623178 | 623178 | 2020-10-12 | Gratiot | Michigan | 26057 | 359 | 16 |
623179 | 623179 | 2020-10-12 | Hillsdale | Michigan | 26059 | 400 | 27 |
623180 | 623180 | 2020-10-12 | Houghton | Michigan | 26061 | 809 | 5 |
623181 | 623181 | 2020-10-12 | Huron | Michigan | 26063 | 246 | 5 |
623182 | 623182 | 2020-10-12 | Ingham | Michigan | 26065 | 4054 | 53 |
623183 | 623183 | 2020-10-12 | Ionia | Michigan | 26067 | 656 | 8 |
623184 | 623184 | 2020-10-12 | Iosco | Michigan | 26069 | 250 | 13 |
623185 | 623185 | 2020-10-12 | Iron | Michigan | 26071 | 300 | 10 |
623186 | 623186 | 2020-10-12 | Isabella | Michigan | 26073 | 857 | 15 |
623187 | 623187 | 2020-10-12 | Jackson | Michigan | 26075 | 3044 | 76 |
623188 | 623188 | 2020-10-12 | Kalamazoo | Michigan | 26077 | 3732 | 96 |
623189 | 623189 | 2020-10-12 | Kalkaska | Michigan | 26079 | 101 | 4 |
623190 | 623190 | 2020-10-12 | Kent | Michigan | 26081 | 11512 | 172 |
623191 | 623191 | 2020-10-12 | Keweenaw | Michigan | 26083 | 14 | 0 |
623192 | 623192 | 2020-10-12 | Lake | Michigan | 26085 | 39 | 0 |
623193 | 623193 | 2020-10-12 | Lapeer | Michigan | 26087 | 1015 | 45 |
623194 | 623194 | 2020-10-12 | Leelanau | Michigan | 26089 | 121 | 1 |
623195 | 623195 | 2020-10-12 | Lenawee | Michigan | 26091 | 1675 | 22 |
623196 | 623196 | 2020-10-12 | Livingston | Michigan | 26093 | 1619 | 33 |
623197 | 623197 | 2020-10-12 | Luce | Michigan | 26095 | 274 | 0 |
623198 | 623198 | 2020-10-12 | Mackinac | Michigan | 26097 | 107 | 0 |
623199 | 623199 | 2020-10-12 | Macomb | Michigan | 26099 | 16310 | 1046 |
623200 | 623200 | 2020-10-12 | Manistee | Michigan | 26101 | 107 | 3 |
623201 | 623201 | 2020-10-12 | Marquette | Michigan | 26103 | 540 | 12 |
623202 | 623202 | 2020-10-12 | Mason | Michigan | 26105 | 154 | 1 |
623203 | 623203 | 2020-10-12 | Mecosta | Michigan | 26107 | 309 | 3 |
623204 | 623204 | 2020-10-12 | Menominee | Michigan | 26109 | 549 | 3 |
623205 | 623205 | 2020-10-12 | Midland | Michigan | 26111 | 726 | 13 |
623206 | 623206 | 2020-10-12 | Missaukee | Michigan | 26113 | 70 | 1 |
623207 | 623207 | 2020-10-12 | Monroe | Michigan | 26115 | 1679 | 29 |
623208 | 623208 | 2020-10-12 | Montcalm | Michigan | 26117 | 416 | 7 |
623209 | 623209 | 2020-10-12 | Montmorency | Michigan | 26119 | 18 | 0 |
623210 | 623210 | 2020-10-12 | Muskegon | Michigan | 26121 | 2714 | 77 |
623211 | 623211 | 2020-10-12 | Newaygo | Michigan | 26123 | 465 | 2 |
623212 | 623212 | 2020-10-12 | Oakland | Michigan | 26125 | 22033 | 1221 |
623213 | 623213 | 2020-10-12 | Oceana | Michigan | 26127 | 550 | 6 |
623214 | 623214 | 2020-10-12 | Ogemaw | Michigan | 26129 | 78 | 5 |
623215 | 623215 | 2020-10-12 | Ontonagon | Michigan | 26131 | 57 | 0 |
623216 | 623216 | 2020-10-12 | Osceola | Michigan | 26133 | 110 | 0 |
623217 | 623217 | 2020-10-12 | Oscoda | Michigan | 26135 | 50 | 1 |
623218 | 623218 | 2020-10-12 | Otsego | Michigan | 26137 | 212 | 12 |
623219 | 623219 | 2020-10-12 | Ottawa | Michigan | 26139 | 4022 | 70 |
623220 | 623220 | 2020-10-12 | Presque Isle | Michigan | 26141 | 29 | 1 |
623221 | 623221 | 2020-10-12 | Roscommon | Michigan | 26143 | 114 | 4 |
623222 | 623222 | 2020-10-12 | Saginaw | Michigan | 26145 | 3212 | 144 |
623223 | 623223 | 2020-10-12 | Sanilac | Michigan | 26151 | 160 | 7 |
623224 | 623224 | 2020-10-12 | Schoolcraft | Michigan | 26153 | 44 | 0 |
623225 | 623225 | 2020-10-12 | Shiawassee | Michigan | 26155 | 589 | 32 |
623226 | 623226 | 2020-10-12 | St. Clair | Michigan | 26147 | 1175 | 60 |
623227 | 623227 | 2020-10-12 | St. Joseph | Michigan | 26149 | 930 | 12 |
623228 | 623228 | 2020-10-12 | Tuscola | Michigan | 26157 | 543 | 34 |
623229 | 623229 | 2020-10-12 | Unknown | Michigan | 169 | 4 | |
623230 | 623230 | 2020-10-12 | Van Buren | Michigan | 26159 | 872 | 18 |
623231 | 623231 | 2020-10-12 | Washtenaw | Michigan | 26161 | 4615 | 126 |
623232 | 623232 | 2020-10-12 | Wayne | Michigan | 26163 | 37087 | 3008 |
623233 | 623233 | 2020-10-12 | Wexford | Michigan | 26165 | 145 | 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);