ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 26111 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387230 | 387230 | 2020-07-31 | Midland | Michigan | 26111 | 292 | 9 |
384012 | 384012 | 2020-07-30 | Midland | Michigan | 26111 | 289 | 9 |
380795 | 380795 | 2020-07-29 | Midland | Michigan | 26111 | 285 | 9 |
377578 | 377578 | 2020-07-28 | Midland | Michigan | 26111 | 278 | 9 |
374363 | 374363 | 2020-07-27 | Midland | Michigan | 26111 | 270 | 9 |
371151 | 371151 | 2020-07-26 | Midland | Michigan | 26111 | 265 | 9 |
367941 | 367941 | 2020-07-25 | Midland | Michigan | 26111 | 260 | 9 |
364734 | 364734 | 2020-07-24 | Midland | Michigan | 26111 | 254 | 9 |
361527 | 361527 | 2020-07-23 | Midland | Michigan | 26111 | 250 | 9 |
358322 | 358322 | 2020-07-22 | Midland | Michigan | 26111 | 243 | 9 |
355119 | 355119 | 2020-07-21 | Midland | Michigan | 26111 | 236 | 9 |
351917 | 351917 | 2020-07-20 | Midland | Michigan | 26111 | 230 | 9 |
348717 | 348717 | 2020-07-19 | Midland | Michigan | 26111 | 225 | 9 |
345516 | 345516 | 2020-07-18 | Midland | Michigan | 26111 | 225 | 9 |
342316 | 342316 | 2020-07-17 | Midland | Michigan | 26111 | 222 | 9 |
339120 | 339120 | 2020-07-16 | Midland | Michigan | 26111 | 217 | 9 |
335924 | 335924 | 2020-07-15 | Midland | Michigan | 26111 | 202 | 9 |
332731 | 332731 | 2020-07-14 | Midland | Michigan | 26111 | 192 | 9 |
329544 | 329544 | 2020-07-13 | Midland | Michigan | 26111 | 184 | 9 |
326358 | 326358 | 2020-07-12 | Midland | Michigan | 26111 | 183 | 9 |
323175 | 323175 | 2020-07-11 | Midland | Michigan | 26111 | 182 | 9 |
319996 | 319996 | 2020-07-10 | Midland | Michigan | 26111 | 182 | 9 |
316821 | 316821 | 2020-07-09 | Midland | Michigan | 26111 | 178 | 9 |
313647 | 313647 | 2020-07-08 | Midland | Michigan | 26111 | 173 | 9 |
310477 | 310477 | 2020-07-07 | Midland | Michigan | 26111 | 172 | 9 |
307309 | 307309 | 2020-07-06 | Midland | Michigan | 26111 | 172 | 9 |
304142 | 304142 | 2020-07-05 | Midland | Michigan | 26111 | 172 | 9 |
300978 | 300978 | 2020-07-04 | Midland | Michigan | 26111 | 171 | 9 |
297816 | 297816 | 2020-07-03 | Midland | Michigan | 26111 | 171 | 9 |
294658 | 294658 | 2020-07-02 | Midland | Michigan | 26111 | 169 | 9 |
291504 | 291504 | 2020-07-01 | Midland | Michigan | 26111 | 169 | 9 |
288353 | 288353 | 2020-06-30 | Midland | Michigan | 26111 | 166 | 9 |
285203 | 285203 | 2020-06-29 | Midland | Michigan | 26111 | 164 | 9 |
282058 | 282058 | 2020-06-28 | Midland | Michigan | 26111 | 164 | 9 |
278910 | 278910 | 2020-06-27 | Midland | Michigan | 26111 | 160 | 9 |
275762 | 275762 | 2020-06-26 | Midland | Michigan | 26111 | 160 | 9 |
272619 | 272619 | 2020-06-25 | Midland | Michigan | 26111 | 161 | 9 |
269482 | 269482 | 2020-06-24 | Midland | Michigan | 26111 | 160 | 9 |
266349 | 266349 | 2020-06-23 | Midland | Michigan | 26111 | 160 | 9 |
263223 | 263223 | 2020-06-22 | Midland | Michigan | 26111 | 159 | 9 |
260094 | 260094 | 2020-06-21 | Midland | Michigan | 26111 | 159 | 9 |
256968 | 256968 | 2020-06-20 | Midland | Michigan | 26111 | 158 | 9 |
253848 | 253848 | 2020-06-19 | Midland | Michigan | 26111 | 156 | 9 |
250733 | 250733 | 2020-06-18 | Midland | Michigan | 26111 | 153 | 9 |
247621 | 247621 | 2020-06-17 | Midland | Michigan | 26111 | 153 | 9 |
244508 | 244508 | 2020-06-16 | Midland | Michigan | 26111 | 152 | 9 |
241397 | 241397 | 2020-06-15 | Midland | Michigan | 26111 | 153 | 9 |
238288 | 238288 | 2020-06-14 | Midland | Michigan | 26111 | 152 | 9 |
235181 | 235181 | 2020-06-13 | Midland | Michigan | 26111 | 152 | 9 |
232076 | 232076 | 2020-06-12 | Midland | Michigan | 26111 | 145 | 9 |
228972 | 228972 | 2020-06-11 | Midland | Michigan | 26111 | 140 | 9 |
225870 | 225870 | 2020-06-10 | Midland | Michigan | 26111 | 138 | 9 |
222772 | 222772 | 2020-06-09 | Midland | Michigan | 26111 | 128 | 9 |
219677 | 219677 | 2020-06-08 | Midland | Michigan | 26111 | 125 | 9 |
216585 | 216585 | 2020-06-07 | Midland | Michigan | 26111 | 121 | 9 |
213497 | 213497 | 2020-06-06 | Midland | Michigan | 26111 | 120 | 9 |
210413 | 210413 | 2020-06-05 | Midland | Michigan | 26111 | 120 | 9 |
207332 | 207332 | 2020-06-04 | Midland | Michigan | 26111 | 120 | 8 |
204251 | 204251 | 2020-06-03 | Midland | Michigan | 26111 | 120 | 8 |
201174 | 201174 | 2020-06-02 | Midland | Michigan | 26111 | 120 | 8 |
198101 | 198101 | 2020-06-01 | Midland | Michigan | 26111 | 82 | 8 |
195030 | 195030 | 2020-05-31 | Midland | Michigan | 26111 | 82 | 8 |
191962 | 191962 | 2020-05-30 | Midland | Michigan | 26111 | 82 | 8 |
188898 | 188898 | 2020-05-29 | Midland | Michigan | 26111 | 81 | 8 |
185840 | 185840 | 2020-05-28 | Midland | Michigan | 26111 | 81 | 8 |
182785 | 182785 | 2020-05-27 | Midland | Michigan | 26111 | 80 | 8 |
179739 | 179739 | 2020-05-26 | Midland | Michigan | 26111 | 79 | 8 |
176695 | 176695 | 2020-05-25 | Midland | Michigan | 26111 | 79 | 8 |
173652 | 173652 | 2020-05-24 | Midland | Michigan | 26111 | 79 | 8 |
170610 | 170610 | 2020-05-23 | Midland | Michigan | 26111 | 79 | 8 |
167573 | 167573 | 2020-05-22 | Midland | Michigan | 26111 | 79 | 8 |
164537 | 164537 | 2020-05-21 | Midland | Michigan | 26111 | 76 | 8 |
161508 | 161508 | 2020-05-20 | Midland | Michigan | 26111 | 76 | 8 |
158482 | 158482 | 2020-05-19 | Midland | Michigan | 26111 | 76 | 8 |
155464 | 155464 | 2020-05-18 | Midland | Michigan | 26111 | 71 | 8 |
152450 | 152450 | 2020-05-17 | Midland | Michigan | 26111 | 70 | 8 |
149439 | 149439 | 2020-05-16 | Midland | Michigan | 26111 | 70 | 8 |
146434 | 146434 | 2020-05-15 | Midland | Michigan | 26111 | 69 | 8 |
143434 | 143434 | 2020-05-14 | Midland | Michigan | 26111 | 67 | 8 |
140439 | 140439 | 2020-05-13 | Midland | Michigan | 26111 | 67 | 8 |
137445 | 137445 | 2020-05-12 | Midland | Michigan | 26111 | 67 | 8 |
134455 | 134455 | 2020-05-11 | Midland | Michigan | 26111 | 66 | 8 |
131464 | 131464 | 2020-05-10 | Midland | Michigan | 26111 | 66 | 8 |
128474 | 128474 | 2020-05-09 | Midland | Michigan | 26111 | 66 | 8 |
125487 | 125487 | 2020-05-08 | Midland | Michigan | 26111 | 66 | 8 |
122505 | 122505 | 2020-05-07 | Midland | Michigan | 26111 | 63 | 8 |
119533 | 119533 | 2020-05-06 | Midland | Michigan | 26111 | 63 | 7 |
116572 | 116572 | 2020-05-05 | Midland | Michigan | 26111 | 62 | 7 |
113691 | 113691 | 2020-05-04 | Midland | Michigan | 26111 | 62 | 7 |
110813 | 110813 | 2020-05-03 | Midland | Michigan | 26111 | 62 | 6 |
107941 | 107941 | 2020-05-02 | Midland | Michigan | 26111 | 62 | 6 |
105077 | 105077 | 2020-05-01 | Midland | Michigan | 26111 | 60 | 6 |
102217 | 102217 | 2020-04-30 | Midland | Michigan | 26111 | 61 | 5 |
99365 | 99365 | 2020-04-29 | Midland | Michigan | 26111 | 59 | 5 |
96519 | 96519 | 2020-04-28 | Midland | Michigan | 26111 | 56 | 4 |
93684 | 93684 | 2020-04-27 | Midland | Michigan | 26111 | 56 | 3 |
90863 | 90863 | 2020-04-26 | Midland | Michigan | 26111 | 52 | 3 |
88047 | 88047 | 2020-04-25 | Midland | Michigan | 26111 | 51 | 3 |
85237 | 85237 | 2020-04-24 | Midland | Michigan | 26111 | 50 | 3 |
82433 | 82433 | 2020-04-23 | Midland | Michigan | 26111 | 51 | 3 |
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);