ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
711 rows where county = "Iron" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054784 | 1054784 | 2021-02-22 | Iron | Michigan | 26071 | 926 | 49 |
1051537 | 1051537 | 2021-02-21 | Iron | Michigan | 26071 | 926 | 49 |
1048290 | 1048290 | 2021-02-20 | Iron | Michigan | 26071 | 926 | 49 |
1045044 | 1045044 | 2021-02-19 | Iron | Michigan | 26071 | 926 | 48 |
1041799 | 1041799 | 2021-02-18 | Iron | Michigan | 26071 | 926 | 48 |
1038554 | 1038554 | 2021-02-17 | Iron | Michigan | 26071 | 926 | 48 |
1035309 | 1035309 | 2021-02-16 | Iron | Michigan | 26071 | 925 | 48 |
1032064 | 1032064 | 2021-02-15 | Iron | Michigan | 26071 | 925 | 48 |
1028817 | 1028817 | 2021-02-14 | Iron | Michigan | 26071 | 925 | 48 |
1025571 | 1025571 | 2021-02-13 | Iron | Michigan | 26071 | 925 | 48 |
1022326 | 1022326 | 2021-02-12 | Iron | Michigan | 26071 | 925 | 48 |
1019081 | 1019081 | 2021-02-11 | Iron | Michigan | 26071 | 924 | 48 |
1015836 | 1015836 | 2021-02-10 | Iron | Michigan | 26071 | 923 | 48 |
1012591 | 1012591 | 2021-02-09 | Iron | Michigan | 26071 | 922 | 48 |
1009346 | 1009346 | 2021-02-08 | Iron | Michigan | 26071 | 921 | 48 |
1006099 | 1006099 | 2021-02-07 | Iron | Michigan | 26071 | 920 | 48 |
1002853 | 1002853 | 2021-02-06 | Iron | Michigan | 26071 | 920 | 48 |
999608 | 999608 | 2021-02-05 | Iron | Michigan | 26071 | 919 | 48 |
996362 | 996362 | 2021-02-04 | Iron | Michigan | 26071 | 918 | 48 |
993116 | 993116 | 2021-02-03 | Iron | Michigan | 26071 | 918 | 47 |
989870 | 989870 | 2021-02-02 | Iron | Michigan | 26071 | 916 | 47 |
986623 | 986623 | 2021-02-01 | Iron | Michigan | 26071 | 914 | 47 |
983376 | 983376 | 2021-01-31 | Iron | Michigan | 26071 | 912 | 46 |
980130 | 980130 | 2021-01-30 | Iron | Michigan | 26071 | 912 | 46 |
976884 | 976884 | 2021-01-29 | Iron | Michigan | 26071 | 911 | 43 |
973639 | 973639 | 2021-01-28 | Iron | Michigan | 26071 | 910 | 43 |
970394 | 970394 | 2021-01-27 | Iron | Michigan | 26071 | 907 | 42 |
967149 | 967149 | 2021-01-26 | Iron | Michigan | 26071 | 907 | 42 |
963905 | 963905 | 2021-01-25 | Iron | Michigan | 26071 | 905 | 41 |
960660 | 960660 | 2021-01-24 | Iron | Michigan | 26071 | 903 | 41 |
957414 | 957414 | 2021-01-23 | Iron | Michigan | 26071 | 903 | 41 |
954169 | 954169 | 2021-01-22 | Iron | Michigan | 26071 | 901 | 41 |
950924 | 950924 | 2021-01-21 | Iron | Michigan | 26071 | 897 | 41 |
947678 | 947678 | 2021-01-20 | Iron | Michigan | 26071 | 898 | 38 |
944431 | 944431 | 2021-01-19 | Iron | Michigan | 26071 | 892 | 38 |
941186 | 941186 | 2021-01-18 | Iron | Michigan | 26071 | 890 | 37 |
937941 | 937941 | 2021-01-17 | Iron | Michigan | 26071 | 886 | 37 |
934696 | 934696 | 2021-01-16 | Iron | Michigan | 26071 | 886 | 37 |
931451 | 931451 | 2021-01-15 | Iron | Michigan | 26071 | 881 | 37 |
928206 | 928206 | 2021-01-14 | Iron | Michigan | 26071 | 871 | 37 |
924960 | 924960 | 2021-01-13 | Iron | Michigan | 26071 | 872 | 37 |
921715 | 921715 | 2021-01-12 | Iron | Michigan | 26071 | 867 | 37 |
918470 | 918470 | 2021-01-11 | Iron | Michigan | 26071 | 867 | 37 |
915225 | 915225 | 2021-01-10 | Iron | Michigan | 26071 | 861 | 37 |
911980 | 911980 | 2021-01-09 | Iron | Michigan | 26071 | 861 | 37 |
908735 | 908735 | 2021-01-08 | Iron | Michigan | 26071 | 855 | 37 |
905489 | 905489 | 2021-01-07 | Iron | Michigan | 26071 | 844 | 37 |
902244 | 902244 | 2021-01-06 | Iron | Michigan | 26071 | 838 | 37 |
898999 | 898999 | 2021-01-05 | Iron | Michigan | 26071 | 836 | 37 |
895754 | 895754 | 2021-01-04 | Iron | Michigan | 26071 | 827 | 37 |
892507 | 892507 | 2021-01-03 | Iron | Michigan | 26071 | 822 | 37 |
889261 | 889261 | 2021-01-02 | Iron | Michigan | 26071 | 822 | 37 |
886015 | 886015 | 2021-01-01 | Iron | Michigan | 26071 | 813 | 37 |
882770 | 882770 | 2020-12-31 | Iron | Michigan | 26071 | 813 | 37 |
879525 | 879525 | 2020-12-30 | Iron | Michigan | 26071 | 813 | 37 |
876280 | 876280 | 2020-12-29 | Iron | Michigan | 26071 | 809 | 37 |
873035 | 873035 | 2020-12-28 | Iron | Michigan | 26071 | 809 | 37 |
869790 | 869790 | 2020-12-27 | Iron | Michigan | 26071 | 806 | 37 |
866545 | 866545 | 2020-12-26 | Iron | Michigan | 26071 | 806 | 37 |
863300 | 863300 | 2020-12-25 | Iron | Michigan | 26071 | 800 | 37 |
860055 | 860055 | 2020-12-24 | Iron | Michigan | 26071 | 800 | 37 |
856810 | 856810 | 2020-12-23 | Iron | Michigan | 26071 | 800 | 37 |
853565 | 853565 | 2020-12-22 | Iron | Michigan | 26071 | 792 | 37 |
850320 | 850320 | 2020-12-21 | Iron | Michigan | 26071 | 792 | 37 |
847075 | 847075 | 2020-12-20 | Iron | Michigan | 26071 | 789 | 37 |
843829 | 843829 | 2020-12-19 | Iron | Michigan | 26071 | 789 | 37 |
840584 | 840584 | 2020-12-18 | Iron | Michigan | 26071 | 785 | 37 |
837339 | 837339 | 2020-12-17 | Iron | Michigan | 26071 | 783 | 37 |
834093 | 834093 | 2020-12-16 | Iron | Michigan | 26071 | 780 | 37 |
830846 | 830846 | 2020-12-15 | Iron | Michigan | 26071 | 776 | 37 |
827600 | 827600 | 2020-12-14 | Iron | Michigan | 26071 | 777 | 37 |
824353 | 824353 | 2020-12-13 | Iron | Michigan | 26071 | 770 | 37 |
821107 | 821107 | 2020-12-12 | Iron | Michigan | 26071 | 770 | 37 |
817861 | 817861 | 2020-12-11 | Iron | Michigan | 26071 | 768 | 36 |
814615 | 814615 | 2020-12-10 | Iron | Michigan | 26071 | 766 | 36 |
811370 | 811370 | 2020-12-09 | Iron | Michigan | 26071 | 763 | 36 |
808125 | 808125 | 2020-12-08 | Iron | Michigan | 26071 | 757 | 36 |
804880 | 804880 | 2020-12-07 | Iron | Michigan | 26071 | 756 | 36 |
801635 | 801635 | 2020-12-06 | Iron | Michigan | 26071 | 752 | 36 |
798390 | 798390 | 2020-12-05 | Iron | Michigan | 26071 | 752 | 36 |
795145 | 795145 | 2020-12-04 | Iron | Michigan | 26071 | 746 | 34 |
791900 | 791900 | 2020-12-03 | Iron | Michigan | 26071 | 741 | 34 |
788655 | 788655 | 2020-12-02 | Iron | Michigan | 26071 | 739 | 33 |
785410 | 785410 | 2020-12-01 | Iron | Michigan | 26071 | 730 | 33 |
782166 | 782166 | 2020-11-30 | Iron | Michigan | 26071 | 727 | 33 |
778920 | 778920 | 2020-11-29 | Iron | Michigan | 26071 | 716 | 33 |
775675 | 775675 | 2020-11-28 | Iron | Michigan | 26071 | 716 | 33 |
772430 | 772430 | 2020-11-27 | Iron | Michigan | 26071 | 710 | 33 |
769185 | 769185 | 2020-11-26 | Iron | Michigan | 26071 | 698 | 33 |
765939 | 765939 | 2020-11-25 | Iron | Michigan | 26071 | 698 | 33 |
762694 | 762694 | 2020-11-24 | Iron | Michigan | 26071 | 692 | 33 |
759449 | 759449 | 2020-11-23 | Iron | Michigan | 26071 | 688 | 33 |
756202 | 756202 | 2020-11-22 | Iron | Michigan | 26071 | 674 | 32 |
752956 | 752956 | 2020-11-21 | Iron | Michigan | 26071 | 674 | 32 |
749710 | 749710 | 2020-11-20 | Iron | Michigan | 26071 | 659 | 31 |
746464 | 746464 | 2020-11-19 | Iron | Michigan | 26071 | 653 | 31 |
743217 | 743217 | 2020-11-18 | Iron | Michigan | 26071 | 646 | 31 |
739970 | 739970 | 2020-11-17 | Iron | Michigan | 26071 | 633 | 32 |
736726 | 736726 | 2020-11-16 | Iron | Michigan | 26071 | 627 | 32 |
733480 | 733480 | 2020-11-15 | Iron | Michigan | 26071 | 605 | 31 |
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);