ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Delta" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175459 | 2175459 | 2022-02-02 | Delta | Michigan | 26041 | 9506 | 145 |
2172206 | 2172206 | 2022-02-01 | Delta | Michigan | 26041 | 9356 | 144 |
2168953 | 2168953 | 2022-01-31 | Delta | Michigan | 26041 | 9356 | 144 |
2165698 | 2165698 | 2022-01-30 | Delta | Michigan | 26041 | 9309 | 144 |
2162443 | 2162443 | 2022-01-29 | Delta | Michigan | 26041 | 9309 | 144 |
2159188 | 2159188 | 2022-01-28 | Delta | Michigan | 26041 | 9309 | 144 |
2155934 | 2155934 | 2022-01-27 | Delta | Michigan | 26041 | 9209 | 143 |
2152681 | 2152681 | 2022-01-26 | Delta | Michigan | 26041 | 9209 | 143 |
2149429 | 2149429 | 2022-01-25 | Delta | Michigan | 26041 | 9033 | 143 |
2146177 | 2146177 | 2022-01-24 | Delta | Michigan | 26041 | 9033 | 143 |
2142922 | 2142922 | 2022-01-23 | Delta | Michigan | 26041 | 8858 | 143 |
2139667 | 2139667 | 2022-01-22 | Delta | Michigan | 26041 | 8858 | 143 |
2136411 | 2136411 | 2022-01-21 | Delta | Michigan | 26041 | 8858 | 143 |
2133159 | 2133159 | 2022-01-20 | Delta | Michigan | 26041 | 8591 | 140 |
2129906 | 2129906 | 2022-01-19 | Delta | Michigan | 26041 | 8591 | 140 |
2126652 | 2126652 | 2022-01-18 | Delta | Michigan | 26041 | 8014 | 139 |
2123400 | 2123400 | 2022-01-17 | Delta | Michigan | 26041 | 8014 | 139 |
2120148 | 2120148 | 2022-01-16 | Delta | Michigan | 26041 | 8014 | 139 |
2116896 | 2116896 | 2022-01-15 | Delta | Michigan | 26041 | 8014 | 139 |
2113645 | 2113645 | 2022-01-14 | Delta | Michigan | 26041 | 8014 | 139 |
2110393 | 2110393 | 2022-01-13 | Delta | Michigan | 26041 | 7862 | 139 |
2107142 | 2107142 | 2022-01-12 | Delta | Michigan | 26041 | 7862 | 139 |
2103891 | 2103891 | 2022-01-11 | Delta | Michigan | 26041 | 7678 | 138 |
2100640 | 2100640 | 2022-01-10 | Delta | Michigan | 26041 | 7678 | 138 |
2097389 | 2097389 | 2022-01-09 | Delta | Michigan | 26041 | 7491 | 138 |
2094137 | 2094137 | 2022-01-08 | Delta | Michigan | 26041 | 7491 | 138 |
2090885 | 2090885 | 2022-01-07 | Delta | Michigan | 26041 | 7491 | 138 |
2087634 | 2087634 | 2022-01-06 | Delta | Michigan | 26041 | 7369 | 137 |
2084382 | 2084382 | 2022-01-05 | Delta | Michigan | 26041 | 7369 | 137 |
2081130 | 2081130 | 2022-01-04 | Delta | Michigan | 26041 | 7252 | 137 |
2077878 | 2077878 | 2022-01-03 | Delta | Michigan | 26041 | 7252 | 137 |
2074627 | 2074627 | 2022-01-02 | Delta | Michigan | 26041 | 7154 | 135 |
2071376 | 2071376 | 2022-01-01 | Delta | Michigan | 26041 | 7154 | 135 |
2068125 | 2068125 | 2021-12-31 | Delta | Michigan | 26041 | 7154 | 135 |
2064874 | 2064874 | 2021-12-30 | Delta | Michigan | 26041 | 7154 | 135 |
2061624 | 2061624 | 2021-12-29 | Delta | Michigan | 26041 | 7154 | 135 |
2058375 | 2058375 | 2021-12-28 | Delta | Michigan | 26041 | 7104 | 132 |
2055126 | 2055126 | 2021-12-27 | Delta | Michigan | 26041 | 7104 | 132 |
2051876 | 2051876 | 2021-12-26 | Delta | Michigan | 26041 | 7035 | 132 |
2048626 | 2048626 | 2021-12-25 | Delta | Michigan | 26041 | 7035 | 132 |
2045376 | 2045376 | 2021-12-24 | Delta | Michigan | 26041 | 7035 | 132 |
2042126 | 2042126 | 2021-12-23 | Delta | Michigan | 26041 | 7035 | 132 |
2038877 | 2038877 | 2021-12-22 | Delta | Michigan | 26041 | 7035 | 132 |
2035627 | 2035627 | 2021-12-21 | Delta | Michigan | 26041 | 7008 | 131 |
2032377 | 2032377 | 2021-12-20 | Delta | Michigan | 26041 | 7008 | 131 |
2029126 | 2029126 | 2021-12-19 | Delta | Michigan | 26041 | 6973 | 131 |
2025875 | 2025875 | 2021-12-18 | Delta | Michigan | 26041 | 6973 | 131 |
2022624 | 2022624 | 2021-12-17 | Delta | Michigan | 26041 | 6973 | 131 |
2019373 | 2019373 | 2021-12-16 | Delta | Michigan | 26041 | 6931 | 131 |
2016123 | 2016123 | 2021-12-15 | Delta | Michigan | 26041 | 6931 | 131 |
2012872 | 2012872 | 2021-12-14 | Delta | Michigan | 26041 | 6886 | 130 |
2009621 | 2009621 | 2021-12-13 | Delta | Michigan | 26041 | 6886 | 130 |
2006370 | 2006370 | 2021-12-12 | Delta | Michigan | 26041 | 6845 | 129 |
2003119 | 2003119 | 2021-12-11 | Delta | Michigan | 26041 | 6845 | 129 |
1999869 | 1999869 | 2021-12-10 | Delta | Michigan | 26041 | 6845 | 129 |
1996618 | 1996618 | 2021-12-09 | Delta | Michigan | 26041 | 6809 | 128 |
1993367 | 1993367 | 2021-12-08 | Delta | Michigan | 26041 | 6809 | 128 |
1990116 | 1990116 | 2021-12-07 | Delta | Michigan | 26041 | 6749 | 128 |
1986866 | 1986866 | 2021-12-06 | Delta | Michigan | 26041 | 6749 | 128 |
1983616 | 1983616 | 2021-12-05 | Delta | Michigan | 26041 | 6703 | 125 |
1980366 | 1980366 | 2021-12-04 | Delta | Michigan | 26041 | 6703 | 125 |
1977116 | 1977116 | 2021-12-03 | Delta | Michigan | 26041 | 6703 | 125 |
1973866 | 1973866 | 2021-12-02 | Delta | Michigan | 26041 | 6646 | 123 |
1970617 | 1970617 | 2021-12-01 | Delta | Michigan | 26041 | 6646 | 123 |
1967367 | 1967367 | 2021-11-30 | Delta | Michigan | 26041 | 6569 | 122 |
1964115 | 1964115 | 2021-11-29 | Delta | Michigan | 26041 | 6569 | 122 |
1960864 | 1960864 | 2021-11-28 | Delta | Michigan | 26041 | 6497 | 119 |
1957613 | 1957613 | 2021-11-27 | Delta | Michigan | 26041 | 6497 | 119 |
1954362 | 1954362 | 2021-11-26 | Delta | Michigan | 26041 | 6497 | 119 |
1951111 | 1951111 | 2021-11-25 | Delta | Michigan | 26041 | 6497 | 119 |
1947860 | 1947860 | 2021-11-24 | Delta | Michigan | 26041 | 6497 | 119 |
1944609 | 1944609 | 2021-11-23 | Delta | Michigan | 26041 | 6435 | 117 |
1941358 | 1941358 | 2021-11-22 | Delta | Michigan | 26041 | 6435 | 117 |
1938108 | 1938108 | 2021-11-21 | Delta | Michigan | 26041 | 6386 | 115 |
1934858 | 1934858 | 2021-11-20 | Delta | Michigan | 26041 | 6386 | 115 |
1931608 | 1931608 | 2021-11-19 | Delta | Michigan | 26041 | 6386 | 115 |
1928357 | 1928357 | 2021-11-18 | Delta | Michigan | 26041 | 6312 | 114 |
1925107 | 1925107 | 2021-11-17 | Delta | Michigan | 26041 | 6312 | 114 |
1921858 | 1921858 | 2021-11-16 | Delta | Michigan | 26041 | 6240 | 112 |
1918608 | 1918608 | 2021-11-15 | Delta | Michigan | 26041 | 6240 | 112 |
1915358 | 1915358 | 2021-11-14 | Delta | Michigan | 26041 | 6146 | 111 |
1912108 | 1912108 | 2021-11-13 | Delta | Michigan | 26041 | 6146 | 111 |
1908858 | 1908858 | 2021-11-12 | Delta | Michigan | 26041 | 6146 | 111 |
1905609 | 1905609 | 2021-11-11 | Delta | Michigan | 26041 | 6081 | 111 |
1902360 | 1902360 | 2021-11-10 | Delta | Michigan | 26041 | 6081 | 111 |
1899110 | 1899110 | 2021-11-09 | Delta | Michigan | 26041 | 6042 | 111 |
1895860 | 1895860 | 2021-11-08 | Delta | Michigan | 26041 | 6042 | 111 |
1892610 | 1892610 | 2021-11-07 | Delta | Michigan | 26041 | 6003 | 110 |
1889360 | 1889360 | 2021-11-06 | Delta | Michigan | 26041 | 6003 | 110 |
1886110 | 1886110 | 2021-11-05 | Delta | Michigan | 26041 | 6003 | 110 |
1882861 | 1882861 | 2021-11-04 | Delta | Michigan | 26041 | 5963 | 110 |
1879612 | 1879612 | 2021-11-03 | Delta | Michigan | 26041 | 5963 | 110 |
1876363 | 1876363 | 2021-11-02 | Delta | Michigan | 26041 | 5912 | 108 |
1873114 | 1873114 | 2021-11-01 | Delta | Michigan | 26041 | 5912 | 108 |
1869865 | 1869865 | 2021-10-31 | Delta | Michigan | 26041 | 5853 | 106 |
1866616 | 1866616 | 2021-10-30 | Delta | Michigan | 26041 | 5853 | 106 |
1863367 | 1863367 | 2021-10-29 | Delta | Michigan | 26041 | 5853 | 106 |
1860118 | 1860118 | 2021-10-28 | Delta | Michigan | 26041 | 5802 | 106 |
1856869 | 1856869 | 2021-10-27 | Delta | Michigan | 26041 | 5802 | 106 |
1853620 | 1853620 | 2021-10-26 | Delta | Michigan | 26041 | 5747 | 104 |
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);