ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 26099 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194400 | 1194400 | 2021-04-06 | Macomb | Michigan | 26099 | 78430 | 2059 |
1191151 | 1191151 | 2021-04-05 | Macomb | Michigan | 26099 | 77720 | 2053 |
1187903 | 1187903 | 2021-04-04 | Macomb | Michigan | 26099 | 76232 | 2052 |
1184656 | 1184656 | 2021-04-03 | Macomb | Michigan | 26099 | 76232 | 2052 |
1181410 | 1181410 | 2021-04-02 | Macomb | Michigan | 26099 | 74844 | 2041 |
1178163 | 1178163 | 2021-04-01 | Macomb | Michigan | 26099 | 74042 | 2040 |
1174916 | 1174916 | 2021-03-31 | Macomb | Michigan | 26099 | 73016 | 2030 |
1171669 | 1171669 | 2021-03-30 | Macomb | Michigan | 26099 | 72016 | 2030 |
1168421 | 1168421 | 2021-03-29 | Macomb | Michigan | 26099 | 71046 | 2026 |
1165173 | 1165173 | 2021-03-28 | Macomb | Michigan | 26099 | 69538 | 2025 |
1161925 | 1161925 | 2021-03-27 | Macomb | Michigan | 26099 | 69538 | 2025 |
1158677 | 1158677 | 2021-03-26 | Macomb | Michigan | 26099 | 68753 | 2020 |
1155430 | 1155430 | 2021-03-25 | Macomb | Michigan | 26099 | 67879 | 2016 |
1152183 | 1152183 | 2021-03-24 | Macomb | Michigan | 26099 | 67055 | 2012 |
1148936 | 1148936 | 2021-03-23 | Macomb | Michigan | 26099 | 66359 | 2012 |
1145689 | 1145689 | 2021-03-22 | Macomb | Michigan | 26099 | 65756 | 2011 |
1142442 | 1142442 | 2021-03-21 | Macomb | Michigan | 26099 | 64963 | 2011 |
1139195 | 1139195 | 2021-03-20 | Macomb | Michigan | 26099 | 64963 | 2011 |
1135949 | 1135949 | 2021-03-19 | Macomb | Michigan | 26099 | 64517 | 2007 |
1132703 | 1132703 | 2021-03-18 | Macomb | Michigan | 26099 | 63886 | 2006 |
1129455 | 1129455 | 2021-03-17 | Macomb | Michigan | 26099 | 63529 | 2001 |
1126208 | 1126208 | 2021-03-16 | Macomb | Michigan | 26099 | 63045 | 2001 |
1122962 | 1122962 | 2021-03-15 | Macomb | Michigan | 26099 | 62710 | 2000 |
1119715 | 1119715 | 2021-03-14 | Macomb | Michigan | 26099 | 62222 | 2000 |
1116468 | 1116468 | 2021-03-13 | Macomb | Michigan | 26099 | 62222 | 2000 |
1113222 | 1113222 | 2021-03-12 | Macomb | Michigan | 26099 | 61987 | 1993 |
1109976 | 1109976 | 2021-03-11 | Macomb | Michigan | 26099 | 61625 | 1991 |
1106730 | 1106730 | 2021-03-10 | Macomb | Michigan | 26099 | 61331 | 1989 |
1103484 | 1103484 | 2021-03-09 | Macomb | Michigan | 26099 | 61005 | 1988 |
1100238 | 1100238 | 2021-03-08 | Macomb | Michigan | 26099 | 60810 | 1986 |
1096991 | 1096991 | 2021-03-07 | Macomb | Michigan | 26099 | 60588 | 1984 |
1093744 | 1093744 | 2021-03-06 | Macomb | Michigan | 26099 | 60588 | 1984 |
1090498 | 1090498 | 2021-03-05 | Macomb | Michigan | 26099 | 60378 | 1978 |
1087253 | 1087253 | 2021-03-04 | Macomb | Michigan | 26099 | 60169 | 1978 |
1084008 | 1084008 | 2021-03-03 | Macomb | Michigan | 26099 | 59926 | 1975 |
1080762 | 1080762 | 2021-03-02 | Macomb | Michigan | 26099 | 59726 | 1976 |
1077516 | 1077516 | 2021-03-01 | Macomb | Michigan | 26099 | 59556 | 1972 |
1074270 | 1074270 | 2021-02-28 | Macomb | Michigan | 26099 | 59372 | 1972 |
1071024 | 1071024 | 2021-02-27 | Macomb | Michigan | 26099 | 59372 | 1972 |
1067779 | 1067779 | 2021-02-26 | Macomb | Michigan | 26099 | 59195 | 1965 |
1064534 | 1064534 | 2021-02-25 | Macomb | Michigan | 26099 | 59094 | 1965 |
1061290 | 1061290 | 2021-02-24 | Macomb | Michigan | 26099 | 58926 | 1958 |
1058044 | 1058044 | 2021-02-23 | Macomb | Michigan | 26099 | 58784 | 1959 |
1054798 | 1054798 | 2021-02-22 | Macomb | Michigan | 26099 | 58609 | 1954 |
1051551 | 1051551 | 2021-02-21 | Macomb | Michigan | 26099 | 58439 | 1954 |
1048304 | 1048304 | 2021-02-20 | Macomb | Michigan | 26099 | 58439 | 1954 |
1045058 | 1045058 | 2021-02-19 | Macomb | Michigan | 26099 | 58344 | 1948 |
1041813 | 1041813 | 2021-02-18 | Macomb | Michigan | 26099 | 58222 | 1947 |
1038568 | 1038568 | 2021-02-17 | Macomb | Michigan | 26099 | 58117 | 1937 |
1035323 | 1035323 | 2021-02-16 | Macomb | Michigan | 26099 | 58014 | 1937 |
1032078 | 1032078 | 2021-02-15 | Macomb | Michigan | 26099 | 57933 | 1935 |
1028831 | 1028831 | 2021-02-14 | Macomb | Michigan | 26099 | 57832 | 1935 |
1025585 | 1025585 | 2021-02-13 | Macomb | Michigan | 26099 | 57832 | 1935 |
1022340 | 1022340 | 2021-02-12 | Macomb | Michigan | 26099 | 57754 | 1923 |
1019095 | 1019095 | 2021-02-11 | Macomb | Michigan | 26099 | 57655 | 1923 |
1015850 | 1015850 | 2021-02-10 | Macomb | Michigan | 26099 | 57522 | 1914 |
1012605 | 1012605 | 2021-02-09 | Macomb | Michigan | 26099 | 57397 | 1913 |
1009360 | 1009360 | 2021-02-08 | Macomb | Michigan | 26099 | 57326 | 1908 |
1006113 | 1006113 | 2021-02-07 | Macomb | Michigan | 26099 | 57141 | 1909 |
1002867 | 1002867 | 2021-02-06 | Macomb | Michigan | 26099 | 57141 | 1909 |
999622 | 999622 | 2021-02-05 | Macomb | Michigan | 26099 | 57048 | 1897 |
996376 | 996376 | 2021-02-04 | Macomb | Michigan | 26099 | 56914 | 1896 |
993130 | 993130 | 2021-02-03 | Macomb | Michigan | 26099 | 56670 | 1879 |
989884 | 989884 | 2021-02-02 | Macomb | Michigan | 26099 | 56553 | 1873 |
986637 | 986637 | 2021-02-01 | Macomb | Michigan | 26099 | 56432 | 1867 |
983390 | 983390 | 2021-01-31 | Macomb | Michigan | 26099 | 56229 | 1865 |
980144 | 980144 | 2021-01-30 | Macomb | Michigan | 26099 | 56229 | 1865 |
976898 | 976898 | 2021-01-29 | Macomb | Michigan | 26099 | 56112 | 1845 |
973653 | 973653 | 2021-01-28 | Macomb | Michigan | 26099 | 55946 | 1847 |
970408 | 970408 | 2021-01-27 | Macomb | Michigan | 26099 | 55767 | 1836 |
967163 | 967163 | 2021-01-26 | Macomb | Michigan | 26099 | 55605 | 1834 |
963919 | 963919 | 2021-01-25 | Macomb | Michigan | 26099 | 55367 | 1825 |
960674 | 960674 | 2021-01-24 | Macomb | Michigan | 26099 | 55141 | 1822 |
957428 | 957428 | 2021-01-23 | Macomb | Michigan | 26099 | 55141 | 1822 |
954183 | 954183 | 2021-01-22 | Macomb | Michigan | 26099 | 54942 | 1797 |
950938 | 950938 | 2021-01-21 | Macomb | Michigan | 26099 | 54692 | 1795 |
947692 | 947692 | 2021-01-20 | Macomb | Michigan | 26099 | 54488 | 1778 |
944445 | 944445 | 2021-01-19 | Macomb | Michigan | 26099 | 54255 | 1774 |
941200 | 941200 | 2021-01-18 | Macomb | Michigan | 26099 | 54076 | 1772 |
937955 | 937955 | 2021-01-17 | Macomb | Michigan | 26099 | 53777 | 1772 |
934710 | 934710 | 2021-01-16 | Macomb | Michigan | 26099 | 53777 | 1772 |
931465 | 931465 | 2021-01-15 | Macomb | Michigan | 26099 | 53629 | 1756 |
928220 | 928220 | 2021-01-14 | Macomb | Michigan | 26099 | 53401 | 1753 |
924974 | 924974 | 2021-01-13 | Macomb | Michigan | 26099 | 53063 | 1734 |
921729 | 921729 | 2021-01-12 | Macomb | Michigan | 26099 | 52793 | 1734 |
918484 | 918484 | 2021-01-11 | Macomb | Michigan | 26099 | 52638 | 1721 |
915239 | 915239 | 2021-01-10 | Macomb | Michigan | 26099 | 52238 | 1716 |
911994 | 911994 | 2021-01-09 | Macomb | Michigan | 26099 | 52238 | 1716 |
908749 | 908749 | 2021-01-08 | Macomb | Michigan | 26099 | 52050 | 1683 |
905503 | 905503 | 2021-01-07 | Macomb | Michigan | 26099 | 51731 | 1681 |
902258 | 902258 | 2021-01-06 | Macomb | Michigan | 26099 | 51470 | 1663 |
899013 | 899013 | 2021-01-05 | Macomb | Michigan | 26099 | 51026 | 1661 |
895768 | 895768 | 2021-01-04 | Macomb | Michigan | 26099 | 50859 | 1641 |
892521 | 892521 | 2021-01-03 | Macomb | Michigan | 26099 | 50395 | 1637 |
889275 | 889275 | 2021-01-02 | Macomb | Michigan | 26099 | 50395 | 1637 |
886029 | 886029 | 2021-01-01 | Macomb | Michigan | 26099 | 49744 | 1606 |
882784 | 882784 | 2020-12-31 | Macomb | Michigan | 26099 | 49744 | 1606 |
879539 | 879539 | 2020-12-30 | Macomb | Michigan | 26099 | 49744 | 1606 |
876294 | 876294 | 2020-12-29 | Macomb | Michigan | 26099 | 49460 | 1603 |
873049 | 873049 | 2020-12-28 | Macomb | Michigan | 26099 | 49156 | 1580 |
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);