ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 26045 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636149 | 636149 | 2020-10-16 | Eaton | Michigan | 26045 | 894 | 10 |
632903 | 632903 | 2020-10-15 | Eaton | Michigan | 26045 | 878 | 10 |
629658 | 629658 | 2020-10-14 | Eaton | Michigan | 26045 | 852 | 10 |
626414 | 626414 | 2020-10-13 | Eaton | Michigan | 26045 | 838 | 10 |
623172 | 623172 | 2020-10-12 | Eaton | Michigan | 26045 | 828 | 10 |
619929 | 619929 | 2020-10-11 | Eaton | Michigan | 26045 | 816 | 10 |
616687 | 616687 | 2020-10-10 | Eaton | Michigan | 26045 | 816 | 10 |
613446 | 613446 | 2020-10-09 | Eaton | Michigan | 26045 | 799 | 10 |
610204 | 610204 | 2020-10-08 | Eaton | Michigan | 26045 | 781 | 10 |
606962 | 606962 | 2020-10-07 | Eaton | Michigan | 26045 | 763 | 10 |
603719 | 603719 | 2020-10-06 | Eaton | Michigan | 26045 | 749 | 10 |
600477 | 600477 | 2020-10-05 | Eaton | Michigan | 26045 | 740 | 10 |
597234 | 597234 | 2020-10-04 | Eaton | Michigan | 26045 | 730 | 10 |
593993 | 593993 | 2020-10-03 | Eaton | Michigan | 26045 | 730 | 10 |
590752 | 590752 | 2020-10-02 | Eaton | Michigan | 26045 | 714 | 10 |
587511 | 587511 | 2020-10-01 | Eaton | Michigan | 26045 | 703 | 10 |
584271 | 584271 | 2020-09-30 | Eaton | Michigan | 26045 | 694 | 10 |
581030 | 581030 | 2020-09-29 | Eaton | Michigan | 26045 | 690 | 10 |
577789 | 577789 | 2020-09-28 | Eaton | Michigan | 26045 | 670 | 10 |
574548 | 574548 | 2020-09-27 | Eaton | Michigan | 26045 | 664 | 10 |
571305 | 571305 | 2020-09-26 | Eaton | Michigan | 26045 | 664 | 10 |
568063 | 568063 | 2020-09-25 | Eaton | Michigan | 26045 | 647 | 11 |
564823 | 564823 | 2020-09-24 | Eaton | Michigan | 26045 | 639 | 11 |
561583 | 561583 | 2020-09-23 | Eaton | Michigan | 26045 | 634 | 10 |
558346 | 558346 | 2020-09-22 | Eaton | Michigan | 26045 | 624 | 10 |
555109 | 555109 | 2020-09-21 | Eaton | Michigan | 26045 | 618 | 10 |
551871 | 551871 | 2020-09-20 | Eaton | Michigan | 26045 | 610 | 10 |
548632 | 548632 | 2020-09-19 | Eaton | Michigan | 26045 | 610 | 10 |
545394 | 545394 | 2020-09-18 | Eaton | Michigan | 26045 | 611 | 10 |
542157 | 542157 | 2020-09-17 | Eaton | Michigan | 26045 | 602 | 10 |
538921 | 538921 | 2020-09-16 | Eaton | Michigan | 26045 | 594 | 10 |
535684 | 535684 | 2020-09-15 | Eaton | Michigan | 26045 | 586 | 10 |
532449 | 532449 | 2020-09-14 | Eaton | Michigan | 26045 | 576 | 10 |
529213 | 529213 | 2020-09-13 | Eaton | Michigan | 26045 | 569 | 10 |
525977 | 525977 | 2020-09-12 | Eaton | Michigan | 26045 | 569 | 10 |
522741 | 522741 | 2020-09-11 | Eaton | Michigan | 26045 | 564 | 9 |
519504 | 519504 | 2020-09-10 | Eaton | Michigan | 26045 | 557 | 9 |
516269 | 516269 | 2020-09-09 | Eaton | Michigan | 26045 | 554 | 9 |
513035 | 513035 | 2020-09-08 | Eaton | Michigan | 26045 | 551 | 9 |
509803 | 509803 | 2020-09-07 | Eaton | Michigan | 26045 | 548 | 9 |
506570 | 506570 | 2020-09-06 | Eaton | Michigan | 26045 | 540 | 9 |
503337 | 503337 | 2020-09-05 | Eaton | Michigan | 26045 | 540 | 9 |
500103 | 500103 | 2020-09-04 | Eaton | Michigan | 26045 | 526 | 9 |
496869 | 496869 | 2020-09-03 | Eaton | Michigan | 26045 | 523 | 9 |
493636 | 493636 | 2020-09-02 | Eaton | Michigan | 26045 | 522 | 9 |
490402 | 490402 | 2020-09-01 | Eaton | Michigan | 26045 | 518 | 9 |
487169 | 487169 | 2020-08-31 | Eaton | Michigan | 26045 | 512 | 8 |
483935 | 483935 | 2020-08-30 | Eaton | Michigan | 26045 | 510 | 8 |
480700 | 480700 | 2020-08-29 | Eaton | Michigan | 26045 | 509 | 8 |
477468 | 477468 | 2020-08-28 | Eaton | Michigan | 26045 | 509 | 8 |
474235 | 474235 | 2020-08-27 | Eaton | Michigan | 26045 | 503 | 8 |
471003 | 471003 | 2020-08-26 | Eaton | Michigan | 26045 | 499 | 8 |
467773 | 467773 | 2020-08-25 | Eaton | Michigan | 26045 | 497 | 8 |
464544 | 464544 | 2020-08-24 | Eaton | Michigan | 26045 | 492 | 8 |
461313 | 461313 | 2020-08-23 | Eaton | Michigan | 26045 | 490 | 8 |
458086 | 458086 | 2020-08-22 | Eaton | Michigan | 26045 | 488 | 8 |
454858 | 454858 | 2020-08-21 | Eaton | Michigan | 26045 | 479 | 8 |
451630 | 451630 | 2020-08-20 | Eaton | Michigan | 26045 | 479 | 8 |
448402 | 448402 | 2020-08-19 | Eaton | Michigan | 26045 | 480 | 8 |
445176 | 445176 | 2020-08-18 | Eaton | Michigan | 26045 | 476 | 8 |
441950 | 441950 | 2020-08-17 | Eaton | Michigan | 26045 | 474 | 8 |
438723 | 438723 | 2020-08-16 | Eaton | Michigan | 26045 | 473 | 8 |
435498 | 435498 | 2020-08-15 | Eaton | Michigan | 26045 | 473 | 8 |
432272 | 432272 | 2020-08-14 | Eaton | Michigan | 26045 | 471 | 8 |
429045 | 429045 | 2020-08-13 | Eaton | Michigan | 26045 | 465 | 8 |
425821 | 425821 | 2020-08-12 | Eaton | Michigan | 26045 | 461 | 8 |
422599 | 422599 | 2020-08-11 | Eaton | Michigan | 26045 | 463 | 8 |
419377 | 419377 | 2020-08-10 | Eaton | Michigan | 26045 | 462 | 8 |
416156 | 416156 | 2020-08-09 | Eaton | Michigan | 26045 | 462 | 8 |
412936 | 412936 | 2020-08-08 | Eaton | Michigan | 26045 | 459 | 8 |
409716 | 409716 | 2020-08-07 | Eaton | Michigan | 26045 | 456 | 8 |
406496 | 406496 | 2020-08-06 | Eaton | Michigan | 26045 | 455 | 8 |
403278 | 403278 | 2020-08-05 | Eaton | Michigan | 26045 | 449 | 8 |
400061 | 400061 | 2020-08-04 | Eaton | Michigan | 26045 | 445 | 8 |
396847 | 396847 | 2020-08-03 | Eaton | Michigan | 26045 | 456 | 8 |
393631 | 393631 | 2020-08-02 | Eaton | Michigan | 26045 | 454 | 7 |
390414 | 390414 | 2020-08-01 | Eaton | Michigan | 26045 | 451 | 7 |
387197 | 387197 | 2020-07-31 | Eaton | Michigan | 26045 | 447 | 7 |
383979 | 383979 | 2020-07-30 | Eaton | Michigan | 26045 | 442 | 7 |
380762 | 380762 | 2020-07-29 | Eaton | Michigan | 26045 | 433 | 7 |
377545 | 377545 | 2020-07-28 | Eaton | Michigan | 26045 | 432 | 7 |
374330 | 374330 | 2020-07-27 | Eaton | Michigan | 26045 | 421 | 7 |
371118 | 371118 | 2020-07-26 | Eaton | Michigan | 26045 | 410 | 7 |
367908 | 367908 | 2020-07-25 | Eaton | Michigan | 26045 | 405 | 7 |
364701 | 364701 | 2020-07-24 | Eaton | Michigan | 26045 | 403 | 7 |
361494 | 361494 | 2020-07-23 | Eaton | Michigan | 26045 | 399 | 7 |
358289 | 358289 | 2020-07-22 | Eaton | Michigan | 26045 | 394 | 7 |
355086 | 355086 | 2020-07-21 | Eaton | Michigan | 26045 | 389 | 7 |
351884 | 351884 | 2020-07-20 | Eaton | Michigan | 26045 | 381 | 7 |
348684 | 348684 | 2020-07-19 | Eaton | Michigan | 26045 | 375 | 7 |
345483 | 345483 | 2020-07-18 | Eaton | Michigan | 26045 | 374 | 7 |
342283 | 342283 | 2020-07-17 | Eaton | Michigan | 26045 | 369 | 7 |
339087 | 339087 | 2020-07-16 | Eaton | Michigan | 26045 | 363 | 7 |
335891 | 335891 | 2020-07-15 | Eaton | Michigan | 26045 | 360 | 7 |
332698 | 332698 | 2020-07-14 | Eaton | Michigan | 26045 | 358 | 7 |
329511 | 329511 | 2020-07-13 | Eaton | Michigan | 26045 | 358 | 7 |
326325 | 326325 | 2020-07-12 | Eaton | Michigan | 26045 | 356 | 7 |
323142 | 323142 | 2020-07-11 | Eaton | Michigan | 26045 | 357 | 7 |
319963 | 319963 | 2020-07-10 | Eaton | Michigan | 26045 | 349 | 7 |
316788 | 316788 | 2020-07-09 | Eaton | Michigan | 26045 | 348 | 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);