ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 26099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175488 | 2175488 | 2022-02-02 | Macomb | Michigan | 26099 | 219141 | 3611 |
2172235 | 2172235 | 2022-02-01 | Macomb | Michigan | 26099 | 216996 | 3564 |
2168982 | 2168982 | 2022-01-31 | Macomb | Michigan | 26099 | 216996 | 3564 |
2165727 | 2165727 | 2022-01-30 | Macomb | Michigan | 26099 | 214423 | 3557 |
2162472 | 2162472 | 2022-01-29 | Macomb | Michigan | 26099 | 214423 | 3557 |
2159217 | 2159217 | 2022-01-28 | Macomb | Michigan | 26099 | 214423 | 3557 |
2155963 | 2155963 | 2022-01-27 | Macomb | Michigan | 26099 | 212077 | 3530 |
2152710 | 2152710 | 2022-01-26 | Macomb | Michigan | 26099 | 212077 | 3530 |
2149458 | 2149458 | 2022-01-25 | Macomb | Michigan | 26099 | 209471 | 3480 |
2146206 | 2146206 | 2022-01-24 | Macomb | Michigan | 26099 | 209471 | 3480 |
2142951 | 2142951 | 2022-01-23 | Macomb | Michigan | 26099 | 205793 | 3477 |
2139696 | 2139696 | 2022-01-22 | Macomb | Michigan | 26099 | 205793 | 3477 |
2136440 | 2136440 | 2022-01-21 | Macomb | Michigan | 26099 | 205793 | 3477 |
2133188 | 2133188 | 2022-01-20 | Macomb | Michigan | 26099 | 202557 | 3459 |
2129935 | 2129935 | 2022-01-19 | Macomb | Michigan | 26099 | 202557 | 3459 |
2126681 | 2126681 | 2022-01-18 | Macomb | Michigan | 26099 | 193931 | 3398 |
2123429 | 2123429 | 2022-01-17 | Macomb | Michigan | 26099 | 193931 | 3398 |
2120177 | 2120177 | 2022-01-16 | Macomb | Michigan | 26099 | 193931 | 3398 |
2116925 | 2116925 | 2022-01-15 | Macomb | Michigan | 26099 | 193931 | 3398 |
2113674 | 2113674 | 2022-01-14 | Macomb | Michigan | 26099 | 193931 | 3398 |
2110422 | 2110422 | 2022-01-13 | Macomb | Michigan | 26099 | 190201 | 3367 |
2107171 | 2107171 | 2022-01-12 | Macomb | Michigan | 26099 | 190201 | 3367 |
2103920 | 2103920 | 2022-01-11 | Macomb | Michigan | 26099 | 187562 | 3310 |
2100669 | 2100669 | 2022-01-10 | Macomb | Michigan | 26099 | 187562 | 3310 |
2097418 | 2097418 | 2022-01-09 | Macomb | Michigan | 26099 | 181983 | 3309 |
2094166 | 2094166 | 2022-01-08 | Macomb | Michigan | 26099 | 181983 | 3309 |
2090914 | 2090914 | 2022-01-07 | Macomb | Michigan | 26099 | 181983 | 3309 |
2087663 | 2087663 | 2022-01-06 | Macomb | Michigan | 26099 | 176857 | 3282 |
2084411 | 2084411 | 2022-01-05 | Macomb | Michigan | 26099 | 176857 | 3282 |
2081159 | 2081159 | 2022-01-04 | Macomb | Michigan | 26099 | 174175 | 3252 |
2077907 | 2077907 | 2022-01-03 | Macomb | Michigan | 26099 | 174175 | 3252 |
2074656 | 2074656 | 2022-01-02 | Macomb | Michigan | 26099 | 166010 | 3220 |
2071405 | 2071405 | 2022-01-01 | Macomb | Michigan | 26099 | 166010 | 3220 |
2068154 | 2068154 | 2021-12-31 | Macomb | Michigan | 26099 | 166010 | 3220 |
2064903 | 2064903 | 2021-12-30 | Macomb | Michigan | 26099 | 166010 | 3220 |
2061653 | 2061653 | 2021-12-29 | Macomb | Michigan | 26099 | 166010 | 3220 |
2058404 | 2058404 | 2021-12-28 | Macomb | Michigan | 26099 | 162666 | 3181 |
2055155 | 2055155 | 2021-12-27 | Macomb | Michigan | 26099 | 162666 | 3181 |
2051905 | 2051905 | 2021-12-26 | Macomb | Michigan | 26099 | 157970 | 3144 |
2048655 | 2048655 | 2021-12-25 | Macomb | Michigan | 26099 | 157970 | 3144 |
2045405 | 2045405 | 2021-12-24 | Macomb | Michigan | 26099 | 157970 | 3144 |
2042155 | 2042155 | 2021-12-23 | Macomb | Michigan | 26099 | 157970 | 3144 |
2038906 | 2038906 | 2021-12-22 | Macomb | Michigan | 26099 | 157970 | 3144 |
2035656 | 2035656 | 2021-12-21 | Macomb | Michigan | 26099 | 156275 | 3100 |
2032406 | 2032406 | 2021-12-20 | Macomb | Michigan | 26099 | 156275 | 3100 |
2029155 | 2029155 | 2021-12-19 | Macomb | Michigan | 26099 | 154269 | 3095 |
2025904 | 2025904 | 2021-12-18 | Macomb | Michigan | 26099 | 154269 | 3095 |
2022653 | 2022653 | 2021-12-17 | Macomb | Michigan | 26099 | 154269 | 3095 |
2019402 | 2019402 | 2021-12-16 | Macomb | Michigan | 26099 | 152802 | 3061 |
2016152 | 2016152 | 2021-12-15 | Macomb | Michigan | 26099 | 152802 | 3061 |
2012901 | 2012901 | 2021-12-14 | Macomb | Michigan | 26099 | 151341 | 3012 |
2009650 | 2009650 | 2021-12-13 | Macomb | Michigan | 26099 | 151341 | 3012 |
2006399 | 2006399 | 2021-12-12 | Macomb | Michigan | 26099 | 149528 | 3003 |
2003148 | 2003148 | 2021-12-11 | Macomb | Michigan | 26099 | 149528 | 3003 |
1999898 | 1999898 | 2021-12-10 | Macomb | Michigan | 26099 | 149528 | 3003 |
1996647 | 1996647 | 2021-12-09 | Macomb | Michigan | 26099 | 148217 | 2971 |
1993396 | 1993396 | 2021-12-08 | Macomb | Michigan | 26099 | 148217 | 2971 |
1990145 | 1990145 | 2021-12-07 | Macomb | Michigan | 26099 | 146350 | 2921 |
1986895 | 1986895 | 2021-12-06 | Macomb | Michigan | 26099 | 146350 | 2921 |
1983645 | 1983645 | 2021-12-05 | Macomb | Michigan | 26099 | 144365 | 2912 |
1980395 | 1980395 | 2021-12-04 | Macomb | Michigan | 26099 | 144365 | 2912 |
1977145 | 1977145 | 2021-12-03 | Macomb | Michigan | 26099 | 144365 | 2912 |
1973895 | 1973895 | 2021-12-02 | Macomb | Michigan | 26099 | 142419 | 2890 |
1970646 | 1970646 | 2021-12-01 | Macomb | Michigan | 26099 | 142419 | 2890 |
1967396 | 1967396 | 2021-11-30 | Macomb | Michigan | 26099 | 140609 | 2860 |
1964144 | 1964144 | 2021-11-29 | Macomb | Michigan | 26099 | 140609 | 2860 |
1960893 | 1960893 | 2021-11-28 | Macomb | Michigan | 26099 | 137642 | 2845 |
1957642 | 1957642 | 2021-11-27 | Macomb | Michigan | 26099 | 137642 | 2845 |
1954391 | 1954391 | 2021-11-26 | Macomb | Michigan | 26099 | 137642 | 2845 |
1951140 | 1951140 | 2021-11-25 | Macomb | Michigan | 26099 | 137642 | 2845 |
1947889 | 1947889 | 2021-11-24 | Macomb | Michigan | 26099 | 137642 | 2845 |
1944638 | 1944638 | 2021-11-23 | Macomb | Michigan | 26099 | 135834 | 2817 |
1941387 | 1941387 | 2021-11-22 | Macomb | Michigan | 26099 | 135834 | 2817 |
1938137 | 1938137 | 2021-11-21 | Macomb | Michigan | 26099 | 133940 | 2814 |
1934887 | 1934887 | 2021-11-20 | Macomb | Michigan | 26099 | 133940 | 2814 |
1931637 | 1931637 | 2021-11-19 | Macomb | Michigan | 26099 | 133940 | 2814 |
1928386 | 1928386 | 2021-11-18 | Macomb | Michigan | 26099 | 132334 | 2799 |
1925136 | 1925136 | 2021-11-17 | Macomb | Michigan | 26099 | 132334 | 2799 |
1921887 | 1921887 | 2021-11-16 | Macomb | Michigan | 26099 | 130748 | 2774 |
1918637 | 1918637 | 2021-11-15 | Macomb | Michigan | 26099 | 130748 | 2774 |
1915387 | 1915387 | 2021-11-14 | Macomb | Michigan | 26099 | 128751 | 2769 |
1912137 | 1912137 | 2021-11-13 | Macomb | Michigan | 26099 | 128751 | 2769 |
1908887 | 1908887 | 2021-11-12 | Macomb | Michigan | 26099 | 128751 | 2769 |
1905638 | 1905638 | 2021-11-11 | Macomb | Michigan | 26099 | 127089 | 2758 |
1902389 | 1902389 | 2021-11-10 | Macomb | Michigan | 26099 | 127089 | 2758 |
1899139 | 1899139 | 2021-11-09 | Macomb | Michigan | 26099 | 126411 | 2741 |
1895889 | 1895889 | 2021-11-08 | Macomb | Michigan | 26099 | 126411 | 2741 |
1892639 | 1892639 | 2021-11-07 | Macomb | Michigan | 26099 | 125652 | 2738 |
1889389 | 1889389 | 2021-11-06 | Macomb | Michigan | 26099 | 125652 | 2738 |
1886139 | 1886139 | 2021-11-05 | Macomb | Michigan | 26099 | 125652 | 2738 |
1882890 | 1882890 | 2021-11-04 | Macomb | Michigan | 26099 | 124656 | 2724 |
1879641 | 1879641 | 2021-11-03 | Macomb | Michigan | 26099 | 124656 | 2724 |
1876392 | 1876392 | 2021-11-02 | Macomb | Michigan | 26099 | 123813 | 2713 |
1873143 | 1873143 | 2021-11-01 | Macomb | Michigan | 26099 | 123813 | 2713 |
1869894 | 1869894 | 2021-10-31 | Macomb | Michigan | 26099 | 122692 | 2704 |
1866645 | 1866645 | 2021-10-30 | Macomb | Michigan | 26099 | 122692 | 2704 |
1863396 | 1863396 | 2021-10-29 | Macomb | Michigan | 26099 | 122692 | 2704 |
1860147 | 1860147 | 2021-10-28 | Macomb | Michigan | 26099 | 121963 | 2687 |
1856898 | 1856898 | 2021-10-27 | Macomb | Michigan | 26099 | 121963 | 2687 |
1853649 | 1853649 | 2021-10-26 | Macomb | Michigan | 26099 | 121210 | 2674 |
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);