ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 26101 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921730 | 921730 | 2021-01-12 | Manistee | Michigan | 26101 | 695 | 19 |
918485 | 918485 | 2021-01-11 | Manistee | Michigan | 26101 | 685 | 18 |
915240 | 915240 | 2021-01-10 | Manistee | Michigan | 26101 | 671 | 19 |
911995 | 911995 | 2021-01-09 | Manistee | Michigan | 26101 | 671 | 19 |
908750 | 908750 | 2021-01-08 | Manistee | Michigan | 26101 | 671 | 19 |
905504 | 905504 | 2021-01-07 | Manistee | Michigan | 26101 | 660 | 18 |
902259 | 902259 | 2021-01-06 | Manistee | Michigan | 26101 | 652 | 18 |
899014 | 899014 | 2021-01-05 | Manistee | Michigan | 26101 | 645 | 18 |
895769 | 895769 | 2021-01-04 | Manistee | Michigan | 26101 | 640 | 15 |
892522 | 892522 | 2021-01-03 | Manistee | Michigan | 26101 | 627 | 16 |
889276 | 889276 | 2021-01-02 | Manistee | Michigan | 26101 | 627 | 16 |
886030 | 886030 | 2021-01-01 | Manistee | Michigan | 26101 | 609 | 15 |
882785 | 882785 | 2020-12-31 | Manistee | Michigan | 26101 | 609 | 15 |
879540 | 879540 | 2020-12-30 | Manistee | Michigan | 26101 | 609 | 15 |
876295 | 876295 | 2020-12-29 | Manistee | Michigan | 26101 | 608 | 15 |
873050 | 873050 | 2020-12-28 | Manistee | Michigan | 26101 | 602 | 14 |
869805 | 869805 | 2020-12-27 | Manistee | Michigan | 26101 | 606 | 14 |
866560 | 866560 | 2020-12-26 | Manistee | Michigan | 26101 | 606 | 14 |
863315 | 863315 | 2020-12-25 | Manistee | Michigan | 26101 | 585 | 15 |
860070 | 860070 | 2020-12-24 | Manistee | Michigan | 26101 | 585 | 15 |
856825 | 856825 | 2020-12-23 | Manistee | Michigan | 26101 | 585 | 15 |
853580 | 853580 | 2020-12-22 | Manistee | Michigan | 26101 | 579 | 15 |
850335 | 850335 | 2020-12-21 | Manistee | Michigan | 26101 | 563 | 13 |
847090 | 847090 | 2020-12-20 | Manistee | Michigan | 26101 | 554 | 14 |
843844 | 843844 | 2020-12-19 | Manistee | Michigan | 26101 | 554 | 14 |
840599 | 840599 | 2020-12-18 | Manistee | Michigan | 26101 | 559 | 14 |
837354 | 837354 | 2020-12-17 | Manistee | Michigan | 26101 | 543 | 13 |
834108 | 834108 | 2020-12-16 | Manistee | Michigan | 26101 | 537 | 12 |
830861 | 830861 | 2020-12-15 | Manistee | Michigan | 26101 | 530 | 12 |
827615 | 827615 | 2020-12-14 | Manistee | Michigan | 26101 | 522 | 11 |
824368 | 824368 | 2020-12-13 | Manistee | Michigan | 26101 | 509 | 10 |
821122 | 821122 | 2020-12-12 | Manistee | Michigan | 26101 | 509 | 10 |
817876 | 817876 | 2020-12-11 | Manistee | Michigan | 26101 | 502 | 10 |
814630 | 814630 | 2020-12-10 | Manistee | Michigan | 26101 | 492 | 10 |
811385 | 811385 | 2020-12-09 | Manistee | Michigan | 26101 | 485 | 10 |
808140 | 808140 | 2020-12-08 | Manistee | Michigan | 26101 | 478 | 9 |
804895 | 804895 | 2020-12-07 | Manistee | Michigan | 26101 | 465 | 9 |
801650 | 801650 | 2020-12-06 | Manistee | Michigan | 26101 | 453 | 8 |
798405 | 798405 | 2020-12-05 | Manistee | Michigan | 26101 | 453 | 8 |
795160 | 795160 | 2020-12-04 | Manistee | Michigan | 26101 | 444 | 9 |
791915 | 791915 | 2020-12-03 | Manistee | Michigan | 26101 | 415 | 8 |
788670 | 788670 | 2020-12-02 | Manistee | Michigan | 26101 | 409 | 7 |
785425 | 785425 | 2020-12-01 | Manistee | Michigan | 26101 | 399 | 6 |
782181 | 782181 | 2020-11-30 | Manistee | Michigan | 26101 | 393 | 5 |
778935 | 778935 | 2020-11-29 | Manistee | Michigan | 26101 | 382 | 6 |
775690 | 775690 | 2020-11-28 | Manistee | Michigan | 26101 | 382 | 6 |
772445 | 772445 | 2020-11-27 | Manistee | Michigan | 26101 | 375 | 6 |
769200 | 769200 | 2020-11-26 | Manistee | Michigan | 26101 | 354 | 5 |
765954 | 765954 | 2020-11-25 | Manistee | Michigan | 26101 | 354 | 5 |
762709 | 762709 | 2020-11-24 | Manistee | Michigan | 26101 | 352 | 5 |
759464 | 759464 | 2020-11-23 | Manistee | Michigan | 26101 | 344 | 5 |
756217 | 756217 | 2020-11-22 | Manistee | Michigan | 26101 | 310 | 5 |
752971 | 752971 | 2020-11-21 | Manistee | Michigan | 26101 | 310 | 5 |
749725 | 749725 | 2020-11-20 | Manistee | Michigan | 26101 | 310 | 5 |
746479 | 746479 | 2020-11-19 | Manistee | Michigan | 26101 | 302 | 5 |
743232 | 743232 | 2020-11-18 | Manistee | Michigan | 26101 | 289 | 5 |
739985 | 739985 | 2020-11-17 | Manistee | Michigan | 26101 | 277 | 5 |
736741 | 736741 | 2020-11-16 | Manistee | Michigan | 26101 | 260 | 5 |
733495 | 733495 | 2020-11-15 | Manistee | Michigan | 26101 | 246 | 5 |
730250 | 730250 | 2020-11-14 | Manistee | Michigan | 26101 | 246 | 5 |
727007 | 727007 | 2020-11-13 | Manistee | Michigan | 26101 | 246 | 5 |
723764 | 723764 | 2020-11-12 | Manistee | Michigan | 26101 | 236 | 5 |
720521 | 720521 | 2020-11-11 | Manistee | Michigan | 26101 | 224 | 5 |
717278 | 717278 | 2020-11-10 | Manistee | Michigan | 26101 | 215 | 5 |
714034 | 714034 | 2020-11-09 | Manistee | Michigan | 26101 | 212 | 5 |
710790 | 710790 | 2020-11-08 | Manistee | Michigan | 26101 | 198 | 5 |
707546 | 707546 | 2020-11-07 | Manistee | Michigan | 26101 | 198 | 5 |
704303 | 704303 | 2020-11-06 | Manistee | Michigan | 26101 | 198 | 5 |
701061 | 701061 | 2020-11-05 | Manistee | Michigan | 26101 | 196 | 4 |
697817 | 697817 | 2020-11-04 | Manistee | Michigan | 26101 | 189 | 4 |
694574 | 694574 | 2020-11-03 | Manistee | Michigan | 26101 | 186 | 3 |
691332 | 691332 | 2020-11-02 | Manistee | Michigan | 26101 | 180 | 3 |
688087 | 688087 | 2020-11-01 | Manistee | Michigan | 26101 | 163 | 3 |
684843 | 684843 | 2020-10-31 | Manistee | Michigan | 26101 | 163 | 3 |
681600 | 681600 | 2020-10-30 | Manistee | Michigan | 26101 | 163 | 3 |
678356 | 678356 | 2020-10-29 | Manistee | Michigan | 26101 | 160 | 3 |
675114 | 675114 | 2020-10-28 | Manistee | Michigan | 26101 | 153 | 3 |
671871 | 671871 | 2020-10-27 | Manistee | Michigan | 26101 | 149 | 3 |
668629 | 668629 | 2020-10-26 | Manistee | Michigan | 26101 | 146 | 3 |
665385 | 665385 | 2020-10-25 | Manistee | Michigan | 26101 | 137 | 3 |
662140 | 662140 | 2020-10-24 | Manistee | Michigan | 26101 | 137 | 3 |
658896 | 658896 | 2020-10-23 | Manistee | Michigan | 26101 | 134 | 3 |
655651 | 655651 | 2020-10-22 | Manistee | Michigan | 26101 | 130 | 3 |
652406 | 652406 | 2020-10-21 | Manistee | Michigan | 26101 | 129 | 3 |
649161 | 649161 | 2020-10-20 | Manistee | Michigan | 26101 | 127 | 3 |
645917 | 645917 | 2020-10-19 | Manistee | Michigan | 26101 | 125 | 3 |
642670 | 642670 | 2020-10-18 | Manistee | Michigan | 26101 | 119 | 3 |
639423 | 639423 | 2020-10-17 | Manistee | Michigan | 26101 | 119 | 3 |
636177 | 636177 | 2020-10-16 | Manistee | Michigan | 26101 | 119 | 3 |
632931 | 632931 | 2020-10-15 | Manistee | Michigan | 26101 | 115 | 3 |
629686 | 629686 | 2020-10-14 | Manistee | Michigan | 26101 | 114 | 3 |
626442 | 626442 | 2020-10-13 | Manistee | Michigan | 26101 | 111 | 3 |
623200 | 623200 | 2020-10-12 | Manistee | Michigan | 26101 | 107 | 3 |
619957 | 619957 | 2020-10-11 | Manistee | Michigan | 26101 | 103 | 3 |
616715 | 616715 | 2020-10-10 | Manistee | Michigan | 26101 | 103 | 3 |
613474 | 613474 | 2020-10-09 | Manistee | Michigan | 26101 | 103 | 3 |
610232 | 610232 | 2020-10-08 | Manistee | Michigan | 26101 | 103 | 3 |
606990 | 606990 | 2020-10-07 | Manistee | Michigan | 26101 | 101 | 3 |
603747 | 603747 | 2020-10-06 | Manistee | Michigan | 26101 | 100 | 3 |
600505 | 600505 | 2020-10-05 | Manistee | Michigan | 26101 | 101 | 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);