ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 26151 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194424 | 1194424 | 2021-04-06 | Sanilac | Michigan | 26151 | 3243 | 87 |
1191175 | 1191175 | 2021-04-05 | Sanilac | Michigan | 26151 | 3183 | 86 |
1187927 | 1187927 | 2021-04-04 | Sanilac | Michigan | 26151 | 3133 | 86 |
1184680 | 1184680 | 2021-04-03 | Sanilac | Michigan | 26151 | 3133 | 86 |
1181434 | 1181434 | 2021-04-02 | Sanilac | Michigan | 26151 | 3059 | 86 |
1178187 | 1178187 | 2021-04-01 | Sanilac | Michigan | 26151 | 3011 | 86 |
1174940 | 1174940 | 2021-03-31 | Sanilac | Michigan | 26151 | 2971 | 84 |
1171693 | 1171693 | 2021-03-30 | Sanilac | Michigan | 26151 | 2908 | 83 |
1168445 | 1168445 | 2021-03-29 | Sanilac | Michigan | 26151 | 2846 | 82 |
1165197 | 1165197 | 2021-03-28 | Sanilac | Michigan | 26151 | 2774 | 82 |
1161949 | 1161949 | 2021-03-27 | Sanilac | Michigan | 26151 | 2774 | 82 |
1158701 | 1158701 | 2021-03-26 | Sanilac | Michigan | 26151 | 2748 | 82 |
1155454 | 1155454 | 2021-03-25 | Sanilac | Michigan | 26151 | 2698 | 82 |
1152207 | 1152207 | 2021-03-24 | Sanilac | Michigan | 26151 | 2631 | 80 |
1148960 | 1148960 | 2021-03-23 | Sanilac | Michigan | 26151 | 2581 | 80 |
1145713 | 1145713 | 2021-03-22 | Sanilac | Michigan | 26151 | 2525 | 79 |
1142466 | 1142466 | 2021-03-21 | Sanilac | Michigan | 26151 | 2472 | 79 |
1139219 | 1139219 | 2021-03-20 | Sanilac | Michigan | 26151 | 2472 | 79 |
1135973 | 1135973 | 2021-03-19 | Sanilac | Michigan | 26151 | 2442 | 79 |
1132727 | 1132727 | 2021-03-18 | Sanilac | Michigan | 26151 | 2404 | 79 |
1129479 | 1129479 | 2021-03-17 | Sanilac | Michigan | 26151 | 2369 | 78 |
1126232 | 1126232 | 2021-03-16 | Sanilac | Michigan | 26151 | 2318 | 77 |
1122986 | 1122986 | 2021-03-15 | Sanilac | Michigan | 26151 | 2296 | 77 |
1119739 | 1119739 | 2021-03-14 | Sanilac | Michigan | 26151 | 2255 | 77 |
1116492 | 1116492 | 2021-03-13 | Sanilac | Michigan | 26151 | 2255 | 77 |
1113246 | 1113246 | 2021-03-12 | Sanilac | Michigan | 26151 | 2246 | 77 |
1110000 | 1110000 | 2021-03-11 | Sanilac | Michigan | 26151 | 2223 | 77 |
1106754 | 1106754 | 2021-03-10 | Sanilac | Michigan | 26151 | 2208 | 77 |
1103508 | 1103508 | 2021-03-09 | Sanilac | Michigan | 26151 | 2193 | 77 |
1100262 | 1100262 | 2021-03-08 | Sanilac | Michigan | 26151 | 2179 | 77 |
1097015 | 1097015 | 2021-03-07 | Sanilac | Michigan | 26151 | 2155 | 77 |
1093768 | 1093768 | 2021-03-06 | Sanilac | Michigan | 26151 | 2155 | 77 |
1090522 | 1090522 | 2021-03-05 | Sanilac | Michigan | 26151 | 2137 | 77 |
1087277 | 1087277 | 2021-03-04 | Sanilac | Michigan | 26151 | 2124 | 77 |
1084032 | 1084032 | 2021-03-03 | Sanilac | Michigan | 26151 | 2111 | 77 |
1080786 | 1080786 | 2021-03-02 | Sanilac | Michigan | 26151 | 2094 | 77 |
1077540 | 1077540 | 2021-03-01 | Sanilac | Michigan | 26151 | 2081 | 77 |
1074294 | 1074294 | 2021-02-28 | Sanilac | Michigan | 26151 | 2070 | 77 |
1071048 | 1071048 | 2021-02-27 | Sanilac | Michigan | 26151 | 2070 | 77 |
1067803 | 1067803 | 2021-02-26 | Sanilac | Michigan | 26151 | 2065 | 77 |
1064558 | 1064558 | 2021-02-25 | Sanilac | Michigan | 26151 | 2046 | 77 |
1061314 | 1061314 | 2021-02-24 | Sanilac | Michigan | 26151 | 2030 | 76 |
1058068 | 1058068 | 2021-02-23 | Sanilac | Michigan | 26151 | 2020 | 76 |
1054822 | 1054822 | 2021-02-22 | Sanilac | Michigan | 26151 | 2009 | 76 |
1051575 | 1051575 | 2021-02-21 | Sanilac | Michigan | 26151 | 1995 | 75 |
1048328 | 1048328 | 2021-02-20 | Sanilac | Michigan | 26151 | 1995 | 75 |
1045082 | 1045082 | 2021-02-19 | Sanilac | Michigan | 26151 | 1988 | 74 |
1041837 | 1041837 | 2021-02-18 | Sanilac | Michigan | 26151 | 1977 | 74 |
1038592 | 1038592 | 2021-02-17 | Sanilac | Michigan | 26151 | 1969 | 74 |
1035347 | 1035347 | 2021-02-16 | Sanilac | Michigan | 26151 | 1963 | 74 |
1032102 | 1032102 | 2021-02-15 | Sanilac | Michigan | 26151 | 1957 | 74 |
1028855 | 1028855 | 2021-02-14 | Sanilac | Michigan | 26151 | 1953 | 74 |
1025609 | 1025609 | 2021-02-13 | Sanilac | Michigan | 26151 | 1953 | 74 |
1022364 | 1022364 | 2021-02-12 | Sanilac | Michigan | 26151 | 1947 | 73 |
1019119 | 1019119 | 2021-02-11 | Sanilac | Michigan | 26151 | 1935 | 73 |
1015874 | 1015874 | 2021-02-10 | Sanilac | Michigan | 26151 | 1929 | 73 |
1012629 | 1012629 | 2021-02-09 | Sanilac | Michigan | 26151 | 1920 | 73 |
1009384 | 1009384 | 2021-02-08 | Sanilac | Michigan | 26151 | 1911 | 73 |
1006137 | 1006137 | 2021-02-07 | Sanilac | Michigan | 26151 | 1906 | 73 |
1002891 | 1002891 | 2021-02-06 | Sanilac | Michigan | 26151 | 1906 | 73 |
999646 | 999646 | 2021-02-05 | Sanilac | Michigan | 26151 | 1898 | 73 |
996400 | 996400 | 2021-02-04 | Sanilac | Michigan | 26151 | 1894 | 73 |
993154 | 993154 | 2021-02-03 | Sanilac | Michigan | 26151 | 1892 | 73 |
989908 | 989908 | 2021-02-02 | Sanilac | Michigan | 26151 | 1891 | 73 |
986661 | 986661 | 2021-02-01 | Sanilac | Michigan | 26151 | 1887 | 73 |
983414 | 983414 | 2021-01-31 | Sanilac | Michigan | 26151 | 1874 | 73 |
980168 | 980168 | 2021-01-30 | Sanilac | Michigan | 26151 | 1874 | 73 |
976922 | 976922 | 2021-01-29 | Sanilac | Michigan | 26151 | 1865 | 73 |
973677 | 973677 | 2021-01-28 | Sanilac | Michigan | 26151 | 1863 | 73 |
970432 | 970432 | 2021-01-27 | Sanilac | Michigan | 26151 | 1845 | 72 |
967187 | 967187 | 2021-01-26 | Sanilac | Michigan | 26151 | 1831 | 72 |
963943 | 963943 | 2021-01-25 | Sanilac | Michigan | 26151 | 1818 | 72 |
960698 | 960698 | 2021-01-24 | Sanilac | Michigan | 26151 | 1806 | 71 |
957452 | 957452 | 2021-01-23 | Sanilac | Michigan | 26151 | 1806 | 71 |
954207 | 954207 | 2021-01-22 | Sanilac | Michigan | 26151 | 1796 | 69 |
950962 | 950962 | 2021-01-21 | Sanilac | Michigan | 26151 | 1776 | 69 |
947716 | 947716 | 2021-01-20 | Sanilac | Michigan | 26151 | 1753 | 69 |
944469 | 944469 | 2021-01-19 | Sanilac | Michigan | 26151 | 1743 | 70 |
941224 | 941224 | 2021-01-18 | Sanilac | Michigan | 26151 | 1740 | 70 |
937979 | 937979 | 2021-01-17 | Sanilac | Michigan | 26151 | 1722 | 70 |
934734 | 934734 | 2021-01-16 | Sanilac | Michigan | 26151 | 1722 | 70 |
931489 | 931489 | 2021-01-15 | Sanilac | Michigan | 26151 | 1709 | 69 |
928244 | 928244 | 2021-01-14 | Sanilac | Michigan | 26151 | 1698 | 69 |
924998 | 924998 | 2021-01-13 | Sanilac | Michigan | 26151 | 1682 | 67 |
921753 | 921753 | 2021-01-12 | Sanilac | Michigan | 26151 | 1667 | 67 |
918508 | 918508 | 2021-01-11 | Sanilac | Michigan | 26151 | 1650 | 67 |
915263 | 915263 | 2021-01-10 | Sanilac | Michigan | 26151 | 1631 | 67 |
912018 | 912018 | 2021-01-09 | Sanilac | Michigan | 26151 | 1631 | 67 |
908773 | 908773 | 2021-01-08 | Sanilac | Michigan | 26151 | 1617 | 67 |
905527 | 905527 | 2021-01-07 | Sanilac | Michigan | 26151 | 1593 | 67 |
902282 | 902282 | 2021-01-06 | Sanilac | Michigan | 26151 | 1567 | 65 |
899037 | 899037 | 2021-01-05 | Sanilac | Michigan | 26151 | 1559 | 65 |
895792 | 895792 | 2021-01-04 | Sanilac | Michigan | 26151 | 1538 | 64 |
892545 | 892545 | 2021-01-03 | Sanilac | Michigan | 26151 | 1525 | 63 |
889299 | 889299 | 2021-01-02 | Sanilac | Michigan | 26151 | 1525 | 63 |
886053 | 886053 | 2021-01-01 | Sanilac | Michigan | 26151 | 1497 | 57 |
882808 | 882808 | 2020-12-31 | Sanilac | Michigan | 26151 | 1497 | 57 |
879563 | 879563 | 2020-12-30 | Sanilac | Michigan | 26151 | 1497 | 57 |
876318 | 876318 | 2020-12-29 | Sanilac | Michigan | 26151 | 1482 | 57 |
873073 | 873073 | 2020-12-28 | Sanilac | Michigan | 26151 | 1468 | 57 |
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);