ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 26011 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054754 | 1054754 | 2021-02-22 | Arenac | Michigan | 26011 | 746 | 24 |
1051507 | 1051507 | 2021-02-21 | Arenac | Michigan | 26011 | 741 | 24 |
1048260 | 1048260 | 2021-02-20 | Arenac | Michigan | 26011 | 741 | 24 |
1045014 | 1045014 | 2021-02-19 | Arenac | Michigan | 26011 | 740 | 24 |
1041769 | 1041769 | 2021-02-18 | Arenac | Michigan | 26011 | 739 | 24 |
1038524 | 1038524 | 2021-02-17 | Arenac | Michigan | 26011 | 738 | 24 |
1035279 | 1035279 | 2021-02-16 | Arenac | Michigan | 26011 | 738 | 24 |
1032034 | 1032034 | 2021-02-15 | Arenac | Michigan | 26011 | 738 | 24 |
1028787 | 1028787 | 2021-02-14 | Arenac | Michigan | 26011 | 735 | 24 |
1025541 | 1025541 | 2021-02-13 | Arenac | Michigan | 26011 | 735 | 24 |
1022296 | 1022296 | 2021-02-12 | Arenac | Michigan | 26011 | 734 | 24 |
1019051 | 1019051 | 2021-02-11 | Arenac | Michigan | 26011 | 732 | 24 |
1015806 | 1015806 | 2021-02-10 | Arenac | Michigan | 26011 | 731 | 24 |
1012561 | 1012561 | 2021-02-09 | Arenac | Michigan | 26011 | 730 | 24 |
1009316 | 1009316 | 2021-02-08 | Arenac | Michigan | 26011 | 730 | 24 |
1006069 | 1006069 | 2021-02-07 | Arenac | Michigan | 26011 | 725 | 24 |
1002823 | 1002823 | 2021-02-06 | Arenac | Michigan | 26011 | 725 | 24 |
999578 | 999578 | 2021-02-05 | Arenac | Michigan | 26011 | 722 | 23 |
996332 | 996332 | 2021-02-04 | Arenac | Michigan | 26011 | 717 | 23 |
993086 | 993086 | 2021-02-03 | Arenac | Michigan | 26011 | 712 | 23 |
989840 | 989840 | 2021-02-02 | Arenac | Michigan | 26011 | 705 | 23 |
986593 | 986593 | 2021-02-01 | Arenac | Michigan | 26011 | 703 | 23 |
983346 | 983346 | 2021-01-31 | Arenac | Michigan | 26011 | 701 | 23 |
980100 | 980100 | 2021-01-30 | Arenac | Michigan | 26011 | 701 | 23 |
976854 | 976854 | 2021-01-29 | Arenac | Michigan | 26011 | 698 | 23 |
973609 | 973609 | 2021-01-28 | Arenac | Michigan | 26011 | 698 | 23 |
970364 | 970364 | 2021-01-27 | Arenac | Michigan | 26011 | 698 | 23 |
967119 | 967119 | 2021-01-26 | Arenac | Michigan | 26011 | 697 | 23 |
963875 | 963875 | 2021-01-25 | Arenac | Michigan | 26011 | 697 | 23 |
960630 | 960630 | 2021-01-24 | Arenac | Michigan | 26011 | 694 | 23 |
957384 | 957384 | 2021-01-23 | Arenac | Michigan | 26011 | 694 | 23 |
954139 | 954139 | 2021-01-22 | Arenac | Michigan | 26011 | 689 | 23 |
950894 | 950894 | 2021-01-21 | Arenac | Michigan | 26011 | 684 | 23 |
947648 | 947648 | 2021-01-20 | Arenac | Michigan | 26011 | 682 | 23 |
944401 | 944401 | 2021-01-19 | Arenac | Michigan | 26011 | 680 | 23 |
941156 | 941156 | 2021-01-18 | Arenac | Michigan | 26011 | 678 | 24 |
937911 | 937911 | 2021-01-17 | Arenac | Michigan | 26011 | 670 | 25 |
934666 | 934666 | 2021-01-16 | Arenac | Michigan | 26011 | 670 | 25 |
931421 | 931421 | 2021-01-15 | Arenac | Michigan | 26011 | 666 | 25 |
928176 | 928176 | 2021-01-14 | Arenac | Michigan | 26011 | 661 | 25 |
924930 | 924930 | 2021-01-13 | Arenac | Michigan | 26011 | 655 | 25 |
921685 | 921685 | 2021-01-12 | Arenac | Michigan | 26011 | 651 | 25 |
918440 | 918440 | 2021-01-11 | Arenac | Michigan | 26011 | 648 | 25 |
915195 | 915195 | 2021-01-10 | Arenac | Michigan | 26011 | 638 | 25 |
911950 | 911950 | 2021-01-09 | Arenac | Michigan | 26011 | 638 | 25 |
908705 | 908705 | 2021-01-08 | Arenac | Michigan | 26011 | 632 | 25 |
905459 | 905459 | 2021-01-07 | Arenac | Michigan | 26011 | 630 | 25 |
902214 | 902214 | 2021-01-06 | Arenac | Michigan | 26011 | 625 | 25 |
898969 | 898969 | 2021-01-05 | Arenac | Michigan | 26011 | 622 | 25 |
895724 | 895724 | 2021-01-04 | Arenac | Michigan | 26011 | 619 | 25 |
892477 | 892477 | 2021-01-03 | Arenac | Michigan | 26011 | 611 | 25 |
889231 | 889231 | 2021-01-02 | Arenac | Michigan | 26011 | 611 | 25 |
885985 | 885985 | 2021-01-01 | Arenac | Michigan | 26011 | 597 | 24 |
882740 | 882740 | 2020-12-31 | Arenac | Michigan | 26011 | 597 | 24 |
879495 | 879495 | 2020-12-30 | Arenac | Michigan | 26011 | 597 | 24 |
876250 | 876250 | 2020-12-29 | Arenac | Michigan | 26011 | 593 | 24 |
873005 | 873005 | 2020-12-28 | Arenac | Michigan | 26011 | 588 | 24 |
869760 | 869760 | 2020-12-27 | Arenac | Michigan | 26011 | 585 | 24 |
866515 | 866515 | 2020-12-26 | Arenac | Michigan | 26011 | 585 | 24 |
863270 | 863270 | 2020-12-25 | Arenac | Michigan | 26011 | 580 | 23 |
860025 | 860025 | 2020-12-24 | Arenac | Michigan | 26011 | 580 | 23 |
856780 | 856780 | 2020-12-23 | Arenac | Michigan | 26011 | 580 | 23 |
853535 | 853535 | 2020-12-22 | Arenac | Michigan | 26011 | 575 | 23 |
850290 | 850290 | 2020-12-21 | Arenac | Michigan | 26011 | 573 | 23 |
847045 | 847045 | 2020-12-20 | Arenac | Michigan | 26011 | 567 | 23 |
843799 | 843799 | 2020-12-19 | Arenac | Michigan | 26011 | 567 | 23 |
840554 | 840554 | 2020-12-18 | Arenac | Michigan | 26011 | 569 | 24 |
837309 | 837309 | 2020-12-17 | Arenac | Michigan | 26011 | 563 | 24 |
834063 | 834063 | 2020-12-16 | Arenac | Michigan | 26011 | 557 | 24 |
830816 | 830816 | 2020-12-15 | Arenac | Michigan | 26011 | 557 | 24 |
827570 | 827570 | 2020-12-14 | Arenac | Michigan | 26011 | 553 | 24 |
824323 | 824323 | 2020-12-13 | Arenac | Michigan | 26011 | 542 | 23 |
821077 | 821077 | 2020-12-12 | Arenac | Michigan | 26011 | 542 | 23 |
817831 | 817831 | 2020-12-11 | Arenac | Michigan | 26011 | 537 | 22 |
814585 | 814585 | 2020-12-10 | Arenac | Michigan | 26011 | 531 | 22 |
811340 | 811340 | 2020-12-09 | Arenac | Michigan | 26011 | 527 | 22 |
808095 | 808095 | 2020-12-08 | Arenac | Michigan | 26011 | 521 | 22 |
804850 | 804850 | 2020-12-07 | Arenac | Michigan | 26011 | 511 | 19 |
801605 | 801605 | 2020-12-06 | Arenac | Michigan | 26011 | 495 | 19 |
798360 | 798360 | 2020-12-05 | Arenac | Michigan | 26011 | 495 | 19 |
795115 | 795115 | 2020-12-04 | Arenac | Michigan | 26011 | 482 | 17 |
791870 | 791870 | 2020-12-03 | Arenac | Michigan | 26011 | 477 | 17 |
788625 | 788625 | 2020-12-02 | Arenac | Michigan | 26011 | 464 | 16 |
785380 | 785380 | 2020-12-01 | Arenac | Michigan | 26011 | 459 | 16 |
782136 | 782136 | 2020-11-30 | Arenac | Michigan | 26011 | 446 | 15 |
778890 | 778890 | 2020-11-29 | Arenac | Michigan | 26011 | 425 | 14 |
775645 | 775645 | 2020-11-28 | Arenac | Michigan | 26011 | 425 | 14 |
772400 | 772400 | 2020-11-27 | Arenac | Michigan | 26011 | 412 | 13 |
769155 | 769155 | 2020-11-26 | Arenac | Michigan | 26011 | 377 | 12 |
765909 | 765909 | 2020-11-25 | Arenac | Michigan | 26011 | 377 | 12 |
762664 | 762664 | 2020-11-24 | Arenac | Michigan | 26011 | 366 | 11 |
759419 | 759419 | 2020-11-23 | Arenac | Michigan | 26011 | 355 | 11 |
756172 | 756172 | 2020-11-22 | Arenac | Michigan | 26011 | 309 | 11 |
752926 | 752926 | 2020-11-21 | Arenac | Michigan | 26011 | 309 | 11 |
749680 | 749680 | 2020-11-20 | Arenac | Michigan | 26011 | 297 | 11 |
746434 | 746434 | 2020-11-19 | Arenac | Michigan | 26011 | 283 | 9 |
743187 | 743187 | 2020-11-18 | Arenac | Michigan | 26011 | 273 | 9 |
739940 | 739940 | 2020-11-17 | Arenac | Michigan | 26011 | 256 | 6 |
736696 | 736696 | 2020-11-16 | Arenac | Michigan | 26011 | 241 | 6 |
733450 | 733450 | 2020-11-15 | Arenac | Michigan | 26011 | 215 | 6 |
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);