ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where deaths = 5, fips = 26055 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 |
---|---|---|---|---|---|---|---|
464549 | 464549 | 2020-08-24 | Grand Traverse | Michigan | 26055 | 289 | 5 |
461318 | 461318 | 2020-08-23 | Grand Traverse | Michigan | 26055 | 280 | 5 |
458091 | 458091 | 2020-08-22 | Grand Traverse | Michigan | 26055 | 279 | 5 |
454863 | 454863 | 2020-08-21 | Grand Traverse | Michigan | 26055 | 279 | 5 |
451635 | 451635 | 2020-08-20 | Grand Traverse | Michigan | 26055 | 261 | 5 |
448407 | 448407 | 2020-08-19 | Grand Traverse | Michigan | 26055 | 256 | 5 |
445181 | 445181 | 2020-08-18 | Grand Traverse | Michigan | 26055 | 253 | 5 |
441955 | 441955 | 2020-08-17 | Grand Traverse | Michigan | 26055 | 252 | 5 |
438728 | 438728 | 2020-08-16 | Grand Traverse | Michigan | 26055 | 252 | 5 |
435503 | 435503 | 2020-08-15 | Grand Traverse | Michigan | 26055 | 240 | 5 |
432277 | 432277 | 2020-08-14 | Grand Traverse | Michigan | 26055 | 240 | 5 |
429050 | 429050 | 2020-08-13 | Grand Traverse | Michigan | 26055 | 237 | 5 |
425826 | 425826 | 2020-08-12 | Grand Traverse | Michigan | 26055 | 226 | 5 |
422604 | 422604 | 2020-08-11 | Grand Traverse | Michigan | 26055 | 223 | 5 |
419382 | 419382 | 2020-08-10 | Grand Traverse | Michigan | 26055 | 218 | 5 |
416161 | 416161 | 2020-08-09 | Grand Traverse | Michigan | 26055 | 213 | 5 |
412941 | 412941 | 2020-08-08 | Grand Traverse | Michigan | 26055 | 213 | 5 |
409721 | 409721 | 2020-08-07 | Grand Traverse | Michigan | 26055 | 213 | 5 |
406501 | 406501 | 2020-08-06 | Grand Traverse | Michigan | 26055 | 208 | 5 |
403283 | 403283 | 2020-08-05 | Grand Traverse | Michigan | 26055 | 205 | 5 |
400066 | 400066 | 2020-08-04 | Grand Traverse | Michigan | 26055 | 206 | 5 |
396852 | 396852 | 2020-08-03 | Grand Traverse | Michigan | 26055 | 205 | 5 |
393636 | 393636 | 2020-08-02 | Grand Traverse | Michigan | 26055 | 200 | 5 |
390419 | 390419 | 2020-08-01 | Grand Traverse | Michigan | 26055 | 196 | 5 |
387202 | 387202 | 2020-07-31 | Grand Traverse | Michigan | 26055 | 195 | 5 |
383984 | 383984 | 2020-07-30 | Grand Traverse | Michigan | 26055 | 190 | 5 |
380767 | 380767 | 2020-07-29 | Grand Traverse | Michigan | 26055 | 175 | 5 |
377550 | 377550 | 2020-07-28 | Grand Traverse | Michigan | 26055 | 175 | 5 |
374335 | 374335 | 2020-07-27 | Grand Traverse | Michigan | 26055 | 168 | 5 |
371123 | 371123 | 2020-07-26 | Grand Traverse | Michigan | 26055 | 160 | 5 |
367913 | 367913 | 2020-07-25 | Grand Traverse | Michigan | 26055 | 159 | 5 |
364706 | 364706 | 2020-07-24 | Grand Traverse | Michigan | 26055 | 159 | 5 |
361499 | 361499 | 2020-07-23 | Grand Traverse | Michigan | 26055 | 153 | 5 |
358294 | 358294 | 2020-07-22 | Grand Traverse | Michigan | 26055 | 145 | 5 |
355091 | 355091 | 2020-07-21 | Grand Traverse | Michigan | 26055 | 139 | 5 |
351889 | 351889 | 2020-07-20 | Grand Traverse | Michigan | 26055 | 135 | 5 |
348689 | 348689 | 2020-07-19 | Grand Traverse | Michigan | 26055 | 131 | 5 |
345488 | 345488 | 2020-07-18 | Grand Traverse | Michigan | 26055 | 127 | 5 |
342288 | 342288 | 2020-07-17 | Grand Traverse | Michigan | 26055 | 123 | 5 |
339092 | 339092 | 2020-07-16 | Grand Traverse | Michigan | 26055 | 114 | 5 |
335896 | 335896 | 2020-07-15 | Grand Traverse | Michigan | 26055 | 108 | 5 |
332703 | 332703 | 2020-07-14 | Grand Traverse | Michigan | 26055 | 105 | 5 |
329516 | 329516 | 2020-07-13 | Grand Traverse | Michigan | 26055 | 98 | 5 |
326330 | 326330 | 2020-07-12 | Grand Traverse | Michigan | 26055 | 94 | 5 |
323147 | 323147 | 2020-07-11 | Grand Traverse | Michigan | 26055 | 95 | 5 |
319968 | 319968 | 2020-07-10 | Grand Traverse | Michigan | 26055 | 83 | 5 |
316793 | 316793 | 2020-07-09 | Grand Traverse | Michigan | 26055 | 78 | 5 |
313619 | 313619 | 2020-07-08 | Grand Traverse | Michigan | 26055 | 75 | 5 |
310449 | 310449 | 2020-07-07 | Grand Traverse | Michigan | 26055 | 71 | 5 |
307281 | 307281 | 2020-07-06 | Grand Traverse | Michigan | 26055 | 71 | 5 |
304114 | 304114 | 2020-07-05 | Grand Traverse | Michigan | 26055 | 64 | 5 |
300950 | 300950 | 2020-07-04 | Grand Traverse | Michigan | 26055 | 56 | 5 |
297788 | 297788 | 2020-07-03 | Grand Traverse | Michigan | 26055 | 55 | 5 |
294630 | 294630 | 2020-07-02 | Grand Traverse | Michigan | 26055 | 53 | 5 |
291476 | 291476 | 2020-07-01 | Grand Traverse | Michigan | 26055 | 53 | 5 |
288325 | 288325 | 2020-06-30 | Grand Traverse | Michigan | 26055 | 53 | 5 |
285175 | 285175 | 2020-06-29 | Grand Traverse | Michigan | 26055 | 51 | 5 |
282030 | 282030 | 2020-06-28 | Grand Traverse | Michigan | 26055 | 46 | 5 |
278882 | 278882 | 2020-06-27 | Grand Traverse | Michigan | 26055 | 46 | 5 |
275734 | 275734 | 2020-06-26 | Grand Traverse | Michigan | 26055 | 46 | 5 |
272591 | 272591 | 2020-06-25 | Grand Traverse | Michigan | 26055 | 44 | 5 |
269454 | 269454 | 2020-06-24 | Grand Traverse | Michigan | 26055 | 44 | 5 |
260066 | 260066 | 2020-06-21 | Grand Traverse | Michigan | 26055 | 43 | 5 |
256940 | 256940 | 2020-06-20 | Grand Traverse | Michigan | 26055 | 43 | 5 |
253820 | 253820 | 2020-06-19 | Grand Traverse | Michigan | 26055 | 43 | 5 |
250705 | 250705 | 2020-06-18 | Grand Traverse | Michigan | 26055 | 41 | 5 |
247593 | 247593 | 2020-06-17 | Grand Traverse | Michigan | 26055 | 41 | 5 |
244480 | 244480 | 2020-06-16 | Grand Traverse | Michigan | 26055 | 41 | 5 |
241369 | 241369 | 2020-06-15 | Grand Traverse | Michigan | 26055 | 41 | 5 |
238260 | 238260 | 2020-06-14 | Grand Traverse | Michigan | 26055 | 41 | 5 |
235153 | 235153 | 2020-06-13 | Grand Traverse | Michigan | 26055 | 41 | 5 |
232048 | 232048 | 2020-06-12 | Grand Traverse | Michigan | 26055 | 41 | 5 |
228944 | 228944 | 2020-06-11 | Grand Traverse | Michigan | 26055 | 41 | 5 |
225842 | 225842 | 2020-06-10 | Grand Traverse | Michigan | 26055 | 40 | 5 |
222745 | 222745 | 2020-06-09 | Grand Traverse | Michigan | 26055 | 40 | 5 |
219650 | 219650 | 2020-06-08 | Grand Traverse | Michigan | 26055 | 39 | 5 |
216558 | 216558 | 2020-06-07 | Grand Traverse | Michigan | 26055 | 37 | 5 |
213470 | 213470 | 2020-06-06 | Grand Traverse | Michigan | 26055 | 36 | 5 |
210386 | 210386 | 2020-06-05 | Grand Traverse | Michigan | 26055 | 34 | 5 |
207305 | 207305 | 2020-06-04 | Grand Traverse | Michigan | 26055 | 34 | 5 |
204224 | 204224 | 2020-06-03 | Grand Traverse | Michigan | 26055 | 33 | 5 |
201147 | 201147 | 2020-06-02 | Grand Traverse | Michigan | 26055 | 33 | 5 |
198075 | 198075 | 2020-06-01 | Grand Traverse | Michigan | 26055 | 33 | 5 |
195004 | 195004 | 2020-05-31 | Grand Traverse | Michigan | 26055 | 27 | 5 |
191936 | 191936 | 2020-05-30 | Grand Traverse | Michigan | 26055 | 27 | 5 |
188872 | 188872 | 2020-05-29 | Grand Traverse | Michigan | 26055 | 25 | 5 |
185814 | 185814 | 2020-05-28 | Grand Traverse | Michigan | 26055 | 23 | 5 |
182759 | 182759 | 2020-05-27 | Grand Traverse | Michigan | 26055 | 23 | 5 |
179713 | 179713 | 2020-05-26 | Grand Traverse | Michigan | 26055 | 23 | 5 |
176669 | 176669 | 2020-05-25 | Grand Traverse | Michigan | 26055 | 23 | 5 |
173626 | 173626 | 2020-05-24 | Grand Traverse | Michigan | 26055 | 23 | 5 |
170584 | 170584 | 2020-05-23 | Grand Traverse | Michigan | 26055 | 23 | 5 |
167547 | 167547 | 2020-05-22 | Grand Traverse | Michigan | 26055 | 23 | 5 |
164511 | 164511 | 2020-05-21 | Grand Traverse | Michigan | 26055 | 23 | 5 |
161482 | 161482 | 2020-05-20 | Grand Traverse | Michigan | 26055 | 23 | 5 |
158456 | 158456 | 2020-05-19 | Grand Traverse | Michigan | 26055 | 23 | 5 |
155438 | 155438 | 2020-05-18 | Grand Traverse | Michigan | 26055 | 23 | 5 |
152424 | 152424 | 2020-05-17 | Grand Traverse | Michigan | 26055 | 23 | 5 |
149413 | 149413 | 2020-05-16 | Grand Traverse | Michigan | 26055 | 23 | 5 |
146408 | 146408 | 2020-05-15 | Grand Traverse | Michigan | 26055 | 23 | 5 |
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);