ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Clinton" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387193 | 387193 | 2020-07-31 | Clinton | Michigan | 26037 | 404 | 13 |
383975 | 383975 | 2020-07-30 | Clinton | Michigan | 26037 | 397 | 13 |
380758 | 380758 | 2020-07-29 | Clinton | Michigan | 26037 | 388 | 12 |
377541 | 377541 | 2020-07-28 | Clinton | Michigan | 26037 | 380 | 12 |
374326 | 374326 | 2020-07-27 | Clinton | Michigan | 26037 | 367 | 12 |
371114 | 371114 | 2020-07-26 | Clinton | Michigan | 26037 | 359 | 12 |
367904 | 367904 | 2020-07-25 | Clinton | Michigan | 26037 | 353 | 12 |
364697 | 364697 | 2020-07-24 | Clinton | Michigan | 26037 | 349 | 12 |
361490 | 361490 | 2020-07-23 | Clinton | Michigan | 26037 | 338 | 12 |
358285 | 358285 | 2020-07-22 | Clinton | Michigan | 26037 | 334 | 12 |
355082 | 355082 | 2020-07-21 | Clinton | Michigan | 26037 | 332 | 12 |
351880 | 351880 | 2020-07-20 | Clinton | Michigan | 26037 | 331 | 12 |
348680 | 348680 | 2020-07-19 | Clinton | Michigan | 26037 | 326 | 12 |
345479 | 345479 | 2020-07-18 | Clinton | Michigan | 26037 | 325 | 12 |
342279 | 342279 | 2020-07-17 | Clinton | Michigan | 26037 | 319 | 12 |
339083 | 339083 | 2020-07-16 | Clinton | Michigan | 26037 | 314 | 12 |
335887 | 335887 | 2020-07-15 | Clinton | Michigan | 26037 | 305 | 12 |
332694 | 332694 | 2020-07-14 | Clinton | Michigan | 26037 | 296 | 12 |
329507 | 329507 | 2020-07-13 | Clinton | Michigan | 26037 | 294 | 12 |
326321 | 326321 | 2020-07-12 | Clinton | Michigan | 26037 | 291 | 12 |
323138 | 323138 | 2020-07-11 | Clinton | Michigan | 26037 | 290 | 12 |
319959 | 319959 | 2020-07-10 | Clinton | Michigan | 26037 | 282 | 12 |
316784 | 316784 | 2020-07-09 | Clinton | Michigan | 26037 | 279 | 12 |
313610 | 313610 | 2020-07-08 | Clinton | Michigan | 26037 | 271 | 12 |
310440 | 310440 | 2020-07-07 | Clinton | Michigan | 26037 | 263 | 12 |
307272 | 307272 | 2020-07-06 | Clinton | Michigan | 26037 | 253 | 12 |
304105 | 304105 | 2020-07-05 | Clinton | Michigan | 26037 | 250 | 12 |
300941 | 300941 | 2020-07-04 | Clinton | Michigan | 26037 | 247 | 12 |
297779 | 297779 | 2020-07-03 | Clinton | Michigan | 26037 | 241 | 12 |
294621 | 294621 | 2020-07-02 | Clinton | Michigan | 26037 | 236 | 12 |
291467 | 291467 | 2020-07-01 | Clinton | Michigan | 26037 | 226 | 12 |
288316 | 288316 | 2020-06-30 | Clinton | Michigan | 26037 | 223 | 12 |
285166 | 285166 | 2020-06-29 | Clinton | Michigan | 26037 | 220 | 12 |
282021 | 282021 | 2020-06-28 | Clinton | Michigan | 26037 | 217 | 12 |
278873 | 278873 | 2020-06-27 | Clinton | Michigan | 26037 | 215 | 12 |
275725 | 275725 | 2020-06-26 | Clinton | Michigan | 26037 | 214 | 12 |
272582 | 272582 | 2020-06-25 | Clinton | Michigan | 26037 | 207 | 12 |
269445 | 269445 | 2020-06-24 | Clinton | Michigan | 26037 | 205 | 11 |
266312 | 266312 | 2020-06-23 | Clinton | Michigan | 26037 | 204 | 11 |
263186 | 263186 | 2020-06-22 | Clinton | Michigan | 26037 | 201 | 11 |
260057 | 260057 | 2020-06-21 | Clinton | Michigan | 26037 | 201 | 11 |
256931 | 256931 | 2020-06-20 | Clinton | Michigan | 26037 | 199 | 11 |
253811 | 253811 | 2020-06-19 | Clinton | Michigan | 26037 | 195 | 11 |
250696 | 250696 | 2020-06-18 | Clinton | Michigan | 26037 | 193 | 11 |
247584 | 247584 | 2020-06-17 | Clinton | Michigan | 26037 | 191 | 11 |
244471 | 244471 | 2020-06-16 | Clinton | Michigan | 26037 | 190 | 11 |
241360 | 241360 | 2020-06-15 | Clinton | Michigan | 26037 | 190 | 11 |
238251 | 238251 | 2020-06-14 | Clinton | Michigan | 26037 | 190 | 11 |
235144 | 235144 | 2020-06-13 | Clinton | Michigan | 26037 | 188 | 11 |
232039 | 232039 | 2020-06-12 | Clinton | Michigan | 26037 | 188 | 11 |
228935 | 228935 | 2020-06-11 | Clinton | Michigan | 26037 | 188 | 11 |
225833 | 225833 | 2020-06-10 | Clinton | Michigan | 26037 | 187 | 11 |
222736 | 222736 | 2020-06-09 | Clinton | Michigan | 26037 | 186 | 11 |
219641 | 219641 | 2020-06-08 | Clinton | Michigan | 26037 | 183 | 11 |
216549 | 216549 | 2020-06-07 | Clinton | Michigan | 26037 | 182 | 11 |
213461 | 213461 | 2020-06-06 | Clinton | Michigan | 26037 | 182 | 11 |
210377 | 210377 | 2020-06-05 | Clinton | Michigan | 26037 | 181 | 11 |
207296 | 207296 | 2020-06-04 | Clinton | Michigan | 26037 | 142 | 11 |
204215 | 204215 | 2020-06-03 | Clinton | Michigan | 26037 | 141 | 11 |
201138 | 201138 | 2020-06-02 | Clinton | Michigan | 26037 | 140 | 11 |
198066 | 198066 | 2020-06-01 | Clinton | Michigan | 26037 | 140 | 11 |
194995 | 194995 | 2020-05-31 | Clinton | Michigan | 26037 | 139 | 11 |
191927 | 191927 | 2020-05-30 | Clinton | Michigan | 26037 | 139 | 10 |
188863 | 188863 | 2020-05-29 | Clinton | Michigan | 26037 | 139 | 10 |
185805 | 185805 | 2020-05-28 | Clinton | Michigan | 26037 | 139 | 10 |
182750 | 182750 | 2020-05-27 | Clinton | Michigan | 26037 | 142 | 10 |
179704 | 179704 | 2020-05-26 | Clinton | Michigan | 26037 | 138 | 10 |
176660 | 176660 | 2020-05-25 | Clinton | Michigan | 26037 | 138 | 10 |
173617 | 173617 | 2020-05-24 | Clinton | Michigan | 26037 | 138 | 10 |
170575 | 170575 | 2020-05-23 | Clinton | Michigan | 26037 | 137 | 10 |
167538 | 167538 | 2020-05-22 | Clinton | Michigan | 26037 | 136 | 10 |
164502 | 164502 | 2020-05-21 | Clinton | Michigan | 26037 | 137 | 10 |
161473 | 161473 | 2020-05-20 | Clinton | Michigan | 26037 | 136 | 10 |
158447 | 158447 | 2020-05-19 | Clinton | Michigan | 26037 | 136 | 10 |
155429 | 155429 | 2020-05-18 | Clinton | Michigan | 26037 | 135 | 10 |
152415 | 152415 | 2020-05-17 | Clinton | Michigan | 26037 | 134 | 10 |
149404 | 149404 | 2020-05-16 | Clinton | Michigan | 26037 | 132 | 10 |
146399 | 146399 | 2020-05-15 | Clinton | Michigan | 26037 | 132 | 10 |
143399 | 143399 | 2020-05-14 | Clinton | Michigan | 26037 | 129 | 10 |
140404 | 140404 | 2020-05-13 | Clinton | Michigan | 26037 | 127 | 10 |
137410 | 137410 | 2020-05-12 | Clinton | Michigan | 26037 | 126 | 10 |
134420 | 134420 | 2020-05-11 | Clinton | Michigan | 26037 | 128 | 10 |
131429 | 131429 | 2020-05-10 | Clinton | Michigan | 26037 | 126 | 10 |
128439 | 128439 | 2020-05-09 | Clinton | Michigan | 26037 | 127 | 10 |
125452 | 125452 | 2020-05-08 | Clinton | Michigan | 26037 | 126 | 10 |
122470 | 122470 | 2020-05-07 | Clinton | Michigan | 26037 | 126 | 10 |
119498 | 119498 | 2020-05-06 | Clinton | Michigan | 26037 | 123 | 10 |
116537 | 116537 | 2020-05-05 | Clinton | Michigan | 26037 | 120 | 10 |
113656 | 113656 | 2020-05-04 | Clinton | Michigan | 26037 | 119 | 10 |
110778 | 110778 | 2020-05-03 | Clinton | Michigan | 26037 | 118 | 10 |
107906 | 107906 | 2020-05-02 | Clinton | Michigan | 26037 | 118 | 10 |
105042 | 105042 | 2020-05-01 | Clinton | Michigan | 26037 | 118 | 9 |
102182 | 102182 | 2020-04-30 | Clinton | Michigan | 26037 | 118 | 9 |
99330 | 99330 | 2020-04-29 | Clinton | Michigan | 26037 | 117 | 9 |
96484 | 96484 | 2020-04-28 | Clinton | Michigan | 26037 | 114 | 9 |
93649 | 93649 | 2020-04-27 | Clinton | Michigan | 26037 | 112 | 9 |
90828 | 90828 | 2020-04-26 | Clinton | Michigan | 26037 | 109 | 9 |
88012 | 88012 | 2020-04-25 | Clinton | Michigan | 26037 | 106 | 9 |
85202 | 85202 | 2020-04-24 | Clinton | Michigan | 26037 | 106 | 9 |
82398 | 82398 | 2020-04-23 | Clinton | Michigan | 26037 | 105 | 8 |
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);