ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where deaths = 7, fips = 26067 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 |
---|---|---|---|---|---|---|---|
600488 | 600488 | 2020-10-05 | Ionia | Michigan | 26067 | 562 | 7 |
597245 | 597245 | 2020-10-04 | Ionia | Michigan | 26067 | 549 | 7 |
594004 | 594004 | 2020-10-03 | Ionia | Michigan | 26067 | 549 | 7 |
590763 | 590763 | 2020-10-02 | Ionia | Michigan | 26067 | 541 | 7 |
587522 | 587522 | 2020-10-01 | Ionia | Michigan | 26067 | 536 | 7 |
584282 | 584282 | 2020-09-30 | Ionia | Michigan | 26067 | 535 | 7 |
581041 | 581041 | 2020-09-29 | Ionia | Michigan | 26067 | 528 | 7 |
577800 | 577800 | 2020-09-28 | Ionia | Michigan | 26067 | 525 | 7 |
574559 | 574559 | 2020-09-27 | Ionia | Michigan | 26067 | 525 | 7 |
571316 | 571316 | 2020-09-26 | Ionia | Michigan | 26067 | 525 | 7 |
568074 | 568074 | 2020-09-25 | Ionia | Michigan | 26067 | 521 | 7 |
564834 | 564834 | 2020-09-24 | Ionia | Michigan | 26067 | 512 | 7 |
561594 | 561594 | 2020-09-23 | Ionia | Michigan | 26067 | 507 | 7 |
558357 | 558357 | 2020-09-22 | Ionia | Michigan | 26067 | 509 | 7 |
555120 | 555120 | 2020-09-21 | Ionia | Michigan | 26067 | 506 | 7 |
551882 | 551882 | 2020-09-20 | Ionia | Michigan | 26067 | 506 | 7 |
548643 | 548643 | 2020-09-19 | Ionia | Michigan | 26067 | 506 | 7 |
545405 | 545405 | 2020-09-18 | Ionia | Michigan | 26067 | 503 | 7 |
542168 | 542168 | 2020-09-17 | Ionia | Michigan | 26067 | 503 | 7 |
538932 | 538932 | 2020-09-16 | Ionia | Michigan | 26067 | 372 | 7 |
535695 | 535695 | 2020-09-15 | Ionia | Michigan | 26067 | 369 | 7 |
532460 | 532460 | 2020-09-14 | Ionia | Michigan | 26067 | 370 | 7 |
529224 | 529224 | 2020-09-13 | Ionia | Michigan | 26067 | 366 | 7 |
525988 | 525988 | 2020-09-12 | Ionia | Michigan | 26067 | 366 | 7 |
522752 | 522752 | 2020-09-11 | Ionia | Michigan | 26067 | 366 | 7 |
519515 | 519515 | 2020-09-10 | Ionia | Michigan | 26067 | 362 | 7 |
516280 | 516280 | 2020-09-09 | Ionia | Michigan | 26067 | 361 | 7 |
513046 | 513046 | 2020-09-08 | Ionia | Michigan | 26067 | 352 | 7 |
509814 | 509814 | 2020-09-07 | Ionia | Michigan | 26067 | 328 | 7 |
506581 | 506581 | 2020-09-06 | Ionia | Michigan | 26067 | 320 | 7 |
503348 | 503348 | 2020-09-05 | Ionia | Michigan | 26067 | 320 | 7 |
500114 | 500114 | 2020-09-04 | Ionia | Michigan | 26067 | 389 | 7 |
496880 | 496880 | 2020-09-03 | Ionia | Michigan | 26067 | 311 | 7 |
493647 | 493647 | 2020-09-02 | Ionia | Michigan | 26067 | 306 | 7 |
490413 | 490413 | 2020-09-01 | Ionia | Michigan | 26067 | 304 | 7 |
487180 | 487180 | 2020-08-31 | Ionia | Michigan | 26067 | 302 | 7 |
483946 | 483946 | 2020-08-30 | Ionia | Michigan | 26067 | 301 | 7 |
480711 | 480711 | 2020-08-29 | Ionia | Michigan | 26067 | 300 | 7 |
477479 | 477479 | 2020-08-28 | Ionia | Michigan | 26067 | 296 | 7 |
474246 | 474246 | 2020-08-27 | Ionia | Michigan | 26067 | 295 | 7 |
471014 | 471014 | 2020-08-26 | Ionia | Michigan | 26067 | 294 | 7 |
467784 | 467784 | 2020-08-25 | Ionia | Michigan | 26067 | 292 | 7 |
464555 | 464555 | 2020-08-24 | Ionia | Michigan | 26067 | 291 | 7 |
461324 | 461324 | 2020-08-23 | Ionia | Michigan | 26067 | 287 | 7 |
458097 | 458097 | 2020-08-22 | Ionia | Michigan | 26067 | 285 | 7 |
454869 | 454869 | 2020-08-21 | Ionia | Michigan | 26067 | 285 | 7 |
451641 | 451641 | 2020-08-20 | Ionia | Michigan | 26067 | 285 | 7 |
448413 | 448413 | 2020-08-19 | Ionia | Michigan | 26067 | 285 | 7 |
445187 | 445187 | 2020-08-18 | Ionia | Michigan | 26067 | 281 | 7 |
441961 | 441961 | 2020-08-17 | Ionia | Michigan | 26067 | 281 | 7 |
438734 | 438734 | 2020-08-16 | Ionia | Michigan | 26067 | 281 | 7 |
435509 | 435509 | 2020-08-15 | Ionia | Michigan | 26067 | 282 | 7 |
432283 | 432283 | 2020-08-14 | Ionia | Michigan | 26067 | 281 | 7 |
429056 | 429056 | 2020-08-13 | Ionia | Michigan | 26067 | 279 | 7 |
425832 | 425832 | 2020-08-12 | Ionia | Michigan | 26067 | 278 | 7 |
422610 | 422610 | 2020-08-11 | Ionia | Michigan | 26067 | 278 | 7 |
419388 | 419388 | 2020-08-10 | Ionia | Michigan | 26067 | 278 | 7 |
416167 | 416167 | 2020-08-09 | Ionia | Michigan | 26067 | 277 | 7 |
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);