ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 26093 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110419 | 2110419 | 2022-01-13 | Livingston | Michigan | 26093 | 37370 | 377 |
2107168 | 2107168 | 2022-01-12 | Livingston | Michigan | 26093 | 37370 | 377 |
2103917 | 2103917 | 2022-01-11 | Livingston | Michigan | 26093 | 36684 | 366 |
2100666 | 2100666 | 2022-01-10 | Livingston | Michigan | 26093 | 36684 | 366 |
2097415 | 2097415 | 2022-01-09 | Livingston | Michigan | 26093 | 35913 | 366 |
2094163 | 2094163 | 2022-01-08 | Livingston | Michigan | 26093 | 35913 | 366 |
2090911 | 2090911 | 2022-01-07 | Livingston | Michigan | 26093 | 35913 | 366 |
2087660 | 2087660 | 2022-01-06 | Livingston | Michigan | 26093 | 35024 | 365 |
2084408 | 2084408 | 2022-01-05 | Livingston | Michigan | 26093 | 35024 | 365 |
2081156 | 2081156 | 2022-01-04 | Livingston | Michigan | 26093 | 34196 | 362 |
2077904 | 2077904 | 2022-01-03 | Livingston | Michigan | 26093 | 34196 | 362 |
2074653 | 2074653 | 2022-01-02 | Livingston | Michigan | 26093 | 33150 | 357 |
2071402 | 2071402 | 2022-01-01 | Livingston | Michigan | 26093 | 33150 | 357 |
2068151 | 2068151 | 2021-12-31 | Livingston | Michigan | 26093 | 33150 | 357 |
2064900 | 2064900 | 2021-12-30 | Livingston | Michigan | 26093 | 33150 | 357 |
2061650 | 2061650 | 2021-12-29 | Livingston | Michigan | 26093 | 33150 | 357 |
2058401 | 2058401 | 2021-12-28 | Livingston | Michigan | 26093 | 32736 | 354 |
2055152 | 2055152 | 2021-12-27 | Livingston | Michigan | 26093 | 32736 | 354 |
2051902 | 2051902 | 2021-12-26 | Livingston | Michigan | 26093 | 32151 | 349 |
2048652 | 2048652 | 2021-12-25 | Livingston | Michigan | 26093 | 32151 | 349 |
2045402 | 2045402 | 2021-12-24 | Livingston | Michigan | 26093 | 32151 | 349 |
2042152 | 2042152 | 2021-12-23 | Livingston | Michigan | 26093 | 32151 | 349 |
2038903 | 2038903 | 2021-12-22 | Livingston | Michigan | 26093 | 32151 | 349 |
2035653 | 2035653 | 2021-12-21 | Livingston | Michigan | 26093 | 31857 | 340 |
2032403 | 2032403 | 2021-12-20 | Livingston | Michigan | 26093 | 31857 | 340 |
2029152 | 2029152 | 2021-12-19 | Livingston | Michigan | 26093 | 31575 | 335 |
2025901 | 2025901 | 2021-12-18 | Livingston | Michigan | 26093 | 31575 | 335 |
2022650 | 2022650 | 2021-12-17 | Livingston | Michigan | 26093 | 31575 | 335 |
2019399 | 2019399 | 2021-12-16 | Livingston | Michigan | 26093 | 31317 | 331 |
2016149 | 2016149 | 2021-12-15 | Livingston | Michigan | 26093 | 31317 | 331 |
2012898 | 2012898 | 2021-12-14 | Livingston | Michigan | 26093 | 31002 | 321 |
2009647 | 2009647 | 2021-12-13 | Livingston | Michigan | 26093 | 31002 | 321 |
2006396 | 2006396 | 2021-12-12 | Livingston | Michigan | 26093 | 30653 | 314 |
2003145 | 2003145 | 2021-12-11 | Livingston | Michigan | 26093 | 30653 | 314 |
1999895 | 1999895 | 2021-12-10 | Livingston | Michigan | 26093 | 30653 | 314 |
1996644 | 1996644 | 2021-12-09 | Livingston | Michigan | 26093 | 30300 | 311 |
1993393 | 1993393 | 2021-12-08 | Livingston | Michigan | 26093 | 30300 | 311 |
1990142 | 1990142 | 2021-12-07 | Livingston | Michigan | 26093 | 29922 | 304 |
1986892 | 1986892 | 2021-12-06 | Livingston | Michigan | 26093 | 29922 | 304 |
1983642 | 1983642 | 2021-12-05 | Livingston | Michigan | 26093 | 29554 | 303 |
1980392 | 1980392 | 2021-12-04 | Livingston | Michigan | 26093 | 29554 | 303 |
1977142 | 1977142 | 2021-12-03 | Livingston | Michigan | 26093 | 29554 | 303 |
1973892 | 1973892 | 2021-12-02 | Livingston | Michigan | 26093 | 29036 | 296 |
1970643 | 1970643 | 2021-12-01 | Livingston | Michigan | 26093 | 29036 | 296 |
1967393 | 1967393 | 2021-11-30 | Livingston | Michigan | 26093 | 28509 | 283 |
1964141 | 1964141 | 2021-11-29 | Livingston | Michigan | 26093 | 28509 | 283 |
1960890 | 1960890 | 2021-11-28 | Livingston | Michigan | 26093 | 27844 | 279 |
1957639 | 1957639 | 2021-11-27 | Livingston | Michigan | 26093 | 27844 | 279 |
1954388 | 1954388 | 2021-11-26 | Livingston | Michigan | 26093 | 27844 | 279 |
1951137 | 1951137 | 2021-11-25 | Livingston | Michigan | 26093 | 27844 | 279 |
1947886 | 1947886 | 2021-11-24 | Livingston | Michigan | 26093 | 27844 | 279 |
1944635 | 1944635 | 2021-11-23 | Livingston | Michigan | 26093 | 27313 | 273 |
1941384 | 1941384 | 2021-11-22 | Livingston | Michigan | 26093 | 27313 | 273 |
1938134 | 1938134 | 2021-11-21 | Livingston | Michigan | 26093 | 26875 | 268 |
1934884 | 1934884 | 2021-11-20 | Livingston | Michigan | 26093 | 26875 | 268 |
1931634 | 1931634 | 2021-11-19 | Livingston | Michigan | 26093 | 26875 | 268 |
1928383 | 1928383 | 2021-11-18 | Livingston | Michigan | 26093 | 26409 | 262 |
1925133 | 1925133 | 2021-11-17 | Livingston | Michigan | 26093 | 26409 | 262 |
1921884 | 1921884 | 2021-11-16 | Livingston | Michigan | 26093 | 25930 | 258 |
1918634 | 1918634 | 2021-11-15 | Livingston | Michigan | 26093 | 25930 | 258 |
1915384 | 1915384 | 2021-11-14 | Livingston | Michigan | 26093 | 25356 | 257 |
1912134 | 1912134 | 2021-11-13 | Livingston | Michigan | 26093 | 25356 | 257 |
1908884 | 1908884 | 2021-11-12 | Livingston | Michigan | 26093 | 25356 | 257 |
1905635 | 1905635 | 2021-11-11 | Livingston | Michigan | 26093 | 24885 | 254 |
1902386 | 1902386 | 2021-11-10 | Livingston | Michigan | 26093 | 24885 | 254 |
1899136 | 1899136 | 2021-11-09 | Livingston | Michigan | 26093 | 24591 | 249 |
1895886 | 1895886 | 2021-11-08 | Livingston | Michigan | 26093 | 24591 | 249 |
1892636 | 1892636 | 2021-11-07 | Livingston | Michigan | 26093 | 24308 | 248 |
1889386 | 1889386 | 2021-11-06 | Livingston | Michigan | 26093 | 24308 | 248 |
1886136 | 1886136 | 2021-11-05 | Livingston | Michigan | 26093 | 24308 | 248 |
1882887 | 1882887 | 2021-11-04 | Livingston | Michigan | 26093 | 23976 | 247 |
1879638 | 1879638 | 2021-11-03 | Livingston | Michigan | 26093 | 23976 | 247 |
1876389 | 1876389 | 2021-11-02 | Livingston | Michigan | 26093 | 23679 | 246 |
1873140 | 1873140 | 2021-11-01 | Livingston | Michigan | 26093 | 23679 | 246 |
1869891 | 1869891 | 2021-10-31 | Livingston | Michigan | 26093 | 23452 | 245 |
1866642 | 1866642 | 2021-10-30 | Livingston | Michigan | 26093 | 23452 | 245 |
1863393 | 1863393 | 2021-10-29 | Livingston | Michigan | 26093 | 23452 | 245 |
1860144 | 1860144 | 2021-10-28 | Livingston | Michigan | 26093 | 23228 | 241 |
1856895 | 1856895 | 2021-10-27 | Livingston | Michigan | 26093 | 23228 | 241 |
1853646 | 1853646 | 2021-10-26 | Livingston | Michigan | 26093 | 22997 | 239 |
1850397 | 1850397 | 2021-10-25 | Livingston | Michigan | 26093 | 22997 | 239 |
1847147 | 1847147 | 2021-10-24 | Livingston | Michigan | 26093 | 22799 | 239 |
1843897 | 1843897 | 2021-10-23 | Livingston | Michigan | 26093 | 22799 | 239 |
1840647 | 1840647 | 2021-10-22 | Livingston | Michigan | 26093 | 22799 | 239 |
1837398 | 1837398 | 2021-10-21 | Livingston | Michigan | 26093 | 22622 | 236 |
1834149 | 1834149 | 2021-10-20 | Livingston | Michigan | 26093 | 22622 | 236 |
1830900 | 1830900 | 2021-10-19 | Livingston | Michigan | 26093 | 22388 | 231 |
1827651 | 1827651 | 2021-10-18 | Livingston | Michigan | 26093 | 22388 | 231 |
1824402 | 1824402 | 2021-10-17 | Livingston | Michigan | 26093 | 22143 | 230 |
1821153 | 1821153 | 2021-10-16 | Livingston | Michigan | 26093 | 22143 | 230 |
1817904 | 1817904 | 2021-10-15 | Livingston | Michigan | 26093 | 22143 | 230 |
1814655 | 1814655 | 2021-10-14 | Livingston | Michigan | 26093 | 21878 | 229 |
1811407 | 1811407 | 2021-10-13 | Livingston | Michigan | 26093 | 21878 | 229 |
1808158 | 1808158 | 2021-10-12 | Livingston | Michigan | 26093 | 21583 | 229 |
1804907 | 1804907 | 2021-10-11 | Livingston | Michigan | 26093 | 21583 | 229 |
1801658 | 1801658 | 2021-10-10 | Livingston | Michigan | 26093 | 21280 | 228 |
1798409 | 1798409 | 2021-10-09 | Livingston | Michigan | 26093 | 21280 | 228 |
1795160 | 1795160 | 2021-10-08 | Livingston | Michigan | 26093 | 21280 | 228 |
1791911 | 1791911 | 2021-10-07 | Livingston | Michigan | 26093 | 21011 | 222 |
1788662 | 1788662 | 2021-10-06 | Livingston | Michigan | 26093 | 21011 | 222 |
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);