ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 26125 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194413 | 1194413 | 2021-04-06 | Oakland | Michigan | 26125 | 93013 | 2075 |
1191164 | 1191164 | 2021-04-05 | Oakland | Michigan | 26125 | 92253 | 2070 |
1187916 | 1187916 | 2021-04-04 | Oakland | Michigan | 26125 | 90618 | 2070 |
1184669 | 1184669 | 2021-04-03 | Oakland | Michigan | 26125 | 90618 | 2070 |
1181423 | 1181423 | 2021-04-02 | Oakland | Michigan | 26125 | 89337 | 2064 |
1178176 | 1178176 | 2021-04-01 | Oakland | Michigan | 26125 | 88629 | 2066 |
1174929 | 1174929 | 2021-03-31 | Oakland | Michigan | 26125 | 87871 | 2060 |
1171682 | 1171682 | 2021-03-30 | Oakland | Michigan | 26125 | 87010 | 2060 |
1168434 | 1168434 | 2021-03-29 | Oakland | Michigan | 26125 | 86247 | 2055 |
1165186 | 1165186 | 2021-03-28 | Oakland | Michigan | 26125 | 84984 | 2054 |
1161938 | 1161938 | 2021-03-27 | Oakland | Michigan | 26125 | 84984 | 2054 |
1158690 | 1158690 | 2021-03-26 | Oakland | Michigan | 26125 | 84210 | 2053 |
1155443 | 1155443 | 2021-03-25 | Oakland | Michigan | 26125 | 83444 | 2050 |
1152196 | 1152196 | 2021-03-24 | Oakland | Michigan | 26125 | 82624 | 2049 |
1148949 | 1148949 | 2021-03-23 | Oakland | Michigan | 26125 | 81961 | 2048 |
1145702 | 1145702 | 2021-03-22 | Oakland | Michigan | 26125 | 81335 | 2046 |
1142455 | 1142455 | 2021-03-21 | Oakland | Michigan | 26125 | 80481 | 2046 |
1139208 | 1139208 | 2021-03-20 | Oakland | Michigan | 26125 | 80481 | 2046 |
1135962 | 1135962 | 2021-03-19 | Oakland | Michigan | 26125 | 79999 | 2039 |
1132716 | 1132716 | 2021-03-18 | Oakland | Michigan | 26125 | 79397 | 2036 |
1129468 | 1129468 | 2021-03-17 | Oakland | Michigan | 26125 | 78978 | 2030 |
1126221 | 1126221 | 2021-03-16 | Oakland | Michigan | 26125 | 78465 | 2030 |
1122975 | 1122975 | 2021-03-15 | Oakland | Michigan | 26125 | 78091 | 2027 |
1119728 | 1119728 | 2021-03-14 | Oakland | Michigan | 26125 | 77604 | 2027 |
1116481 | 1116481 | 2021-03-13 | Oakland | Michigan | 26125 | 77604 | 2027 |
1113235 | 1113235 | 2021-03-12 | Oakland | Michigan | 26125 | 77335 | 2022 |
1109989 | 1109989 | 2021-03-11 | Oakland | Michigan | 26125 | 76969 | 2022 |
1106743 | 1106743 | 2021-03-10 | Oakland | Michigan | 26125 | 76649 | 2021 |
1103497 | 1103497 | 2021-03-09 | Oakland | Michigan | 26125 | 76359 | 2021 |
1100251 | 1100251 | 2021-03-08 | Oakland | Michigan | 26125 | 76119 | 2019 |
1097004 | 1097004 | 2021-03-07 | Oakland | Michigan | 26125 | 75863 | 2019 |
1093757 | 1093757 | 2021-03-06 | Oakland | Michigan | 26125 | 75863 | 2019 |
1090511 | 1090511 | 2021-03-05 | Oakland | Michigan | 26125 | 75649 | 2008 |
1087266 | 1087266 | 2021-03-04 | Oakland | Michigan | 26125 | 75487 | 2006 |
1084021 | 1084021 | 2021-03-03 | Oakland | Michigan | 26125 | 75328 | 2004 |
1080775 | 1080775 | 2021-03-02 | Oakland | Michigan | 26125 | 75147 | 2001 |
1077529 | 1077529 | 2021-03-01 | Oakland | Michigan | 26125 | 74973 | 1998 |
1074283 | 1074283 | 2021-02-28 | Oakland | Michigan | 26125 | 74754 | 1998 |
1071037 | 1071037 | 2021-02-27 | Oakland | Michigan | 26125 | 74754 | 1998 |
1067792 | 1067792 | 2021-02-26 | Oakland | Michigan | 26125 | 74607 | 1989 |
1064547 | 1064547 | 2021-02-25 | Oakland | Michigan | 26125 | 74481 | 1989 |
1061303 | 1061303 | 2021-02-24 | Oakland | Michigan | 26125 | 74318 | 1982 |
1058057 | 1058057 | 2021-02-23 | Oakland | Michigan | 26125 | 74155 | 1980 |
1054811 | 1054811 | 2021-02-22 | Oakland | Michigan | 26125 | 73922 | 1977 |
1051564 | 1051564 | 2021-02-21 | Oakland | Michigan | 26125 | 73744 | 1977 |
1048317 | 1048317 | 2021-02-20 | Oakland | Michigan | 26125 | 73744 | 1977 |
1045071 | 1045071 | 2021-02-19 | Oakland | Michigan | 26125 | 73653 | 1965 |
1041826 | 1041826 | 2021-02-18 | Oakland | Michigan | 26125 | 73470 | 1965 |
1038581 | 1038581 | 2021-02-17 | Oakland | Michigan | 26125 | 73290 | 1955 |
1035336 | 1035336 | 2021-02-16 | Oakland | Michigan | 26125 | 73116 | 1955 |
1032091 | 1032091 | 2021-02-15 | Oakland | Michigan | 26125 | 72987 | 1954 |
1028844 | 1028844 | 2021-02-14 | Oakland | Michigan | 26125 | 72810 | 1953 |
1025598 | 1025598 | 2021-02-13 | Oakland | Michigan | 26125 | 72810 | 1953 |
1022353 | 1022353 | 2021-02-12 | Oakland | Michigan | 26125 | 72750 | 1944 |
1019108 | 1019108 | 2021-02-11 | Oakland | Michigan | 26125 | 72577 | 1944 |
1015863 | 1015863 | 2021-02-10 | Oakland | Michigan | 26125 | 72411 | 1933 |
1012618 | 1012618 | 2021-02-09 | Oakland | Michigan | 26125 | 72246 | 1933 |
1009373 | 1009373 | 2021-02-08 | Oakland | Michigan | 26125 | 72077 | 1926 |
1006126 | 1006126 | 2021-02-07 | Oakland | Michigan | 26125 | 71810 | 1925 |
1002880 | 1002880 | 2021-02-06 | Oakland | Michigan | 26125 | 71810 | 1925 |
999635 | 999635 | 2021-02-05 | Oakland | Michigan | 26125 | 71677 | 1916 |
996389 | 996389 | 2021-02-04 | Oakland | Michigan | 26125 | 71441 | 1914 |
993143 | 993143 | 2021-02-03 | Oakland | Michigan | 26125 | 71177 | 1907 |
989897 | 989897 | 2021-02-02 | Oakland | Michigan | 26125 | 71009 | 1906 |
986650 | 986650 | 2021-02-01 | Oakland | Michigan | 26125 | 70804 | 1898 |
983403 | 983403 | 2021-01-31 | Oakland | Michigan | 26125 | 70447 | 1898 |
980157 | 980157 | 2021-01-30 | Oakland | Michigan | 26125 | 70447 | 1898 |
976911 | 976911 | 2021-01-29 | Oakland | Michigan | 26125 | 70269 | 1889 |
973666 | 973666 | 2021-01-28 | Oakland | Michigan | 26125 | 70023 | 1891 |
970421 | 970421 | 2021-01-27 | Oakland | Michigan | 26125 | 69772 | 1878 |
967176 | 967176 | 2021-01-26 | Oakland | Michigan | 26125 | 69558 | 1877 |
963932 | 963932 | 2021-01-25 | Oakland | Michigan | 26125 | 69285 | 1869 |
960687 | 960687 | 2021-01-24 | Oakland | Michigan | 26125 | 68958 | 1866 |
957441 | 957441 | 2021-01-23 | Oakland | Michigan | 26125 | 68958 | 1866 |
954196 | 954196 | 2021-01-22 | Oakland | Michigan | 26125 | 68795 | 1836 |
950951 | 950951 | 2021-01-21 | Oakland | Michigan | 26125 | 68496 | 1838 |
947705 | 947705 | 2021-01-20 | Oakland | Michigan | 26125 | 68244 | 1816 |
944458 | 944458 | 2021-01-19 | Oakland | Michigan | 26125 | 67987 | 1814 |
941213 | 941213 | 2021-01-18 | Oakland | Michigan | 26125 | 67674 | 1812 |
937968 | 937968 | 2021-01-17 | Oakland | Michigan | 26125 | 67307 | 1809 |
934723 | 934723 | 2021-01-16 | Oakland | Michigan | 26125 | 67307 | 1809 |
931478 | 931478 | 2021-01-15 | Oakland | Michigan | 26125 | 66986 | 1792 |
928233 | 928233 | 2021-01-14 | Oakland | Michigan | 26125 | 66619 | 1787 |
924987 | 924987 | 2021-01-13 | Oakland | Michigan | 26125 | 66226 | 1764 |
921742 | 921742 | 2021-01-12 | Oakland | Michigan | 26125 | 65837 | 1763 |
918497 | 918497 | 2021-01-11 | Oakland | Michigan | 26125 | 65546 | 1751 |
915252 | 915252 | 2021-01-10 | Oakland | Michigan | 26125 | 64880 | 1754 |
912007 | 912007 | 2021-01-09 | Oakland | Michigan | 26125 | 64880 | 1754 |
908762 | 908762 | 2021-01-08 | Oakland | Michigan | 26125 | 64666 | 1717 |
905516 | 905516 | 2021-01-07 | Oakland | Michigan | 26125 | 64221 | 1715 |
902271 | 902271 | 2021-01-06 | Oakland | Michigan | 26125 | 63751 | 1680 |
899026 | 899026 | 2021-01-05 | Oakland | Michigan | 26125 | 63188 | 1677 |
895781 | 895781 | 2021-01-04 | Oakland | Michigan | 26125 | 62826 | 1661 |
892534 | 892534 | 2021-01-03 | Oakland | Michigan | 26125 | 62094 | 1659 |
889288 | 889288 | 2021-01-02 | Oakland | Michigan | 26125 | 62094 | 1659 |
886042 | 886042 | 2021-01-01 | Oakland | Michigan | 26125 | 61195 | 1636 |
882797 | 882797 | 2020-12-31 | Oakland | Michigan | 26125 | 61195 | 1636 |
879552 | 879552 | 2020-12-30 | Oakland | Michigan | 26125 | 61195 | 1636 |
876307 | 876307 | 2020-12-29 | Oakland | Michigan | 26125 | 60724 | 1632 |
873062 | 873062 | 2020-12-28 | Oakland | Michigan | 26125 | 60147 | 1606 |
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);