ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 26075 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110410 | 2110410 | 2022-01-13 | Jackson | Michigan | 26075 | 37305 | 489 |
2107159 | 2107159 | 2022-01-12 | Jackson | Michigan | 26075 | 37305 | 489 |
2103908 | 2103908 | 2022-01-11 | Jackson | Michigan | 26075 | 36575 | 482 |
2100657 | 2100657 | 2022-01-10 | Jackson | Michigan | 26075 | 36575 | 482 |
2097406 | 2097406 | 2022-01-09 | Jackson | Michigan | 26075 | 35905 | 482 |
2094154 | 2094154 | 2022-01-08 | Jackson | Michigan | 26075 | 35905 | 482 |
2090902 | 2090902 | 2022-01-07 | Jackson | Michigan | 26075 | 35905 | 482 |
2087651 | 2087651 | 2022-01-06 | Jackson | Michigan | 26075 | 35239 | 478 |
2084399 | 2084399 | 2022-01-05 | Jackson | Michigan | 26075 | 35239 | 478 |
2081147 | 2081147 | 2022-01-04 | Jackson | Michigan | 26075 | 34792 | 473 |
2077895 | 2077895 | 2022-01-03 | Jackson | Michigan | 26075 | 34792 | 473 |
2074644 | 2074644 | 2022-01-02 | Jackson | Michigan | 26075 | 34079 | 467 |
2071393 | 2071393 | 2022-01-01 | Jackson | Michigan | 26075 | 34079 | 467 |
2068142 | 2068142 | 2021-12-31 | Jackson | Michigan | 26075 | 34079 | 467 |
2064891 | 2064891 | 2021-12-30 | Jackson | Michigan | 26075 | 34079 | 467 |
2061641 | 2061641 | 2021-12-29 | Jackson | Michigan | 26075 | 34079 | 467 |
2058392 | 2058392 | 2021-12-28 | Jackson | Michigan | 26075 | 33766 | 457 |
2055143 | 2055143 | 2021-12-27 | Jackson | Michigan | 26075 | 33766 | 457 |
2051893 | 2051893 | 2021-12-26 | Jackson | Michigan | 26075 | 33453 | 451 |
2048643 | 2048643 | 2021-12-25 | Jackson | Michigan | 26075 | 33453 | 451 |
2045393 | 2045393 | 2021-12-24 | Jackson | Michigan | 26075 | 33453 | 451 |
2042143 | 2042143 | 2021-12-23 | Jackson | Michigan | 26075 | 33453 | 451 |
2038894 | 2038894 | 2021-12-22 | Jackson | Michigan | 26075 | 33453 | 451 |
2035644 | 2035644 | 2021-12-21 | Jackson | Michigan | 26075 | 33262 | 444 |
2032394 | 2032394 | 2021-12-20 | Jackson | Michigan | 26075 | 33262 | 444 |
2029143 | 2029143 | 2021-12-19 | Jackson | Michigan | 26075 | 33076 | 441 |
2025892 | 2025892 | 2021-12-18 | Jackson | Michigan | 26075 | 33076 | 441 |
2022641 | 2022641 | 2021-12-17 | Jackson | Michigan | 26075 | 33076 | 441 |
2019390 | 2019390 | 2021-12-16 | Jackson | Michigan | 26075 | 32921 | 437 |
2016140 | 2016140 | 2021-12-15 | Jackson | Michigan | 26075 | 32921 | 437 |
2012889 | 2012889 | 2021-12-14 | Jackson | Michigan | 26075 | 32806 | 428 |
2009638 | 2009638 | 2021-12-13 | Jackson | Michigan | 26075 | 32806 | 428 |
2006387 | 2006387 | 2021-12-12 | Jackson | Michigan | 26075 | 32507 | 426 |
2003136 | 2003136 | 2021-12-11 | Jackson | Michigan | 26075 | 32507 | 426 |
1999886 | 1999886 | 2021-12-10 | Jackson | Michigan | 26075 | 32507 | 426 |
1996635 | 1996635 | 2021-12-09 | Jackson | Michigan | 26075 | 32264 | 421 |
1993384 | 1993384 | 2021-12-08 | Jackson | Michigan | 26075 | 32264 | 421 |
1990133 | 1990133 | 2021-12-07 | Jackson | Michigan | 26075 | 31932 | 417 |
1986883 | 1986883 | 2021-12-06 | Jackson | Michigan | 26075 | 31932 | 417 |
1983633 | 1983633 | 2021-12-05 | Jackson | Michigan | 26075 | 31620 | 417 |
1980383 | 1980383 | 2021-12-04 | Jackson | Michigan | 26075 | 31620 | 417 |
1977133 | 1977133 | 2021-12-03 | Jackson | Michigan | 26075 | 31620 | 417 |
1973883 | 1973883 | 2021-12-02 | Jackson | Michigan | 26075 | 31223 | 407 |
1970634 | 1970634 | 2021-12-01 | Jackson | Michigan | 26075 | 31223 | 407 |
1967384 | 1967384 | 2021-11-30 | Jackson | Michigan | 26075 | 30876 | 398 |
1964132 | 1964132 | 2021-11-29 | Jackson | Michigan | 26075 | 30876 | 398 |
1960881 | 1960881 | 2021-11-28 | Jackson | Michigan | 26075 | 30362 | 397 |
1957630 | 1957630 | 2021-11-27 | Jackson | Michigan | 26075 | 30362 | 397 |
1954379 | 1954379 | 2021-11-26 | Jackson | Michigan | 26075 | 30362 | 397 |
1951128 | 1951128 | 2021-11-25 | Jackson | Michigan | 26075 | 30362 | 397 |
1947877 | 1947877 | 2021-11-24 | Jackson | Michigan | 26075 | 30362 | 397 |
1944626 | 1944626 | 2021-11-23 | Jackson | Michigan | 26075 | 29990 | 393 |
1941375 | 1941375 | 2021-11-22 | Jackson | Michigan | 26075 | 29990 | 393 |
1938125 | 1938125 | 2021-11-21 | Jackson | Michigan | 26075 | 29583 | 393 |
1934875 | 1934875 | 2021-11-20 | Jackson | Michigan | 26075 | 29583 | 393 |
1931625 | 1931625 | 2021-11-19 | Jackson | Michigan | 26075 | 29583 | 393 |
1928374 | 1928374 | 2021-11-18 | Jackson | Michigan | 26075 | 29045 | 393 |
1925124 | 1925124 | 2021-11-17 | Jackson | Michigan | 26075 | 29045 | 393 |
1921875 | 1921875 | 2021-11-16 | Jackson | Michigan | 26075 | 28608 | 386 |
1918625 | 1918625 | 2021-11-15 | Jackson | Michigan | 26075 | 28608 | 386 |
1915375 | 1915375 | 2021-11-14 | Jackson | Michigan | 26075 | 27991 | 382 |
1912125 | 1912125 | 2021-11-13 | Jackson | Michigan | 26075 | 27991 | 382 |
1908875 | 1908875 | 2021-11-12 | Jackson | Michigan | 26075 | 27991 | 382 |
1905626 | 1905626 | 2021-11-11 | Jackson | Michigan | 26075 | 27629 | 380 |
1902377 | 1902377 | 2021-11-10 | Jackson | Michigan | 26075 | 27629 | 380 |
1899127 | 1899127 | 2021-11-09 | Jackson | Michigan | 26075 | 27376 | 376 |
1895877 | 1895877 | 2021-11-08 | Jackson | Michigan | 26075 | 27376 | 376 |
1892627 | 1892627 | 2021-11-07 | Jackson | Michigan | 26075 | 27134 | 376 |
1889377 | 1889377 | 2021-11-06 | Jackson | Michigan | 26075 | 27134 | 376 |
1886127 | 1886127 | 2021-11-05 | Jackson | Michigan | 26075 | 27134 | 376 |
1882878 | 1882878 | 2021-11-04 | Jackson | Michigan | 26075 | 26817 | 375 |
1879629 | 1879629 | 2021-11-03 | Jackson | Michigan | 26075 | 26817 | 375 |
1876380 | 1876380 | 2021-11-02 | Jackson | Michigan | 26075 | 26530 | 368 |
1873131 | 1873131 | 2021-11-01 | Jackson | Michigan | 26075 | 26530 | 368 |
1869882 | 1869882 | 2021-10-31 | Jackson | Michigan | 26075 | 26280 | 367 |
1866633 | 1866633 | 2021-10-30 | Jackson | Michigan | 26075 | 26280 | 367 |
1863384 | 1863384 | 2021-10-29 | Jackson | Michigan | 26075 | 26280 | 367 |
1860135 | 1860135 | 2021-10-28 | Jackson | Michigan | 26075 | 26039 | 363 |
1856886 | 1856886 | 2021-10-27 | Jackson | Michigan | 26075 | 26039 | 363 |
1853637 | 1853637 | 2021-10-26 | Jackson | Michigan | 26075 | 25800 | 359 |
1850388 | 1850388 | 2021-10-25 | Jackson | Michigan | 26075 | 25800 | 359 |
1847138 | 1847138 | 2021-10-24 | Jackson | Michigan | 26075 | 25594 | 359 |
1843888 | 1843888 | 2021-10-23 | Jackson | Michigan | 26075 | 25594 | 359 |
1840638 | 1840638 | 2021-10-22 | Jackson | Michigan | 26075 | 25594 | 359 |
1837389 | 1837389 | 2021-10-21 | Jackson | Michigan | 26075 | 25392 | 356 |
1834140 | 1834140 | 2021-10-20 | Jackson | Michigan | 26075 | 25392 | 356 |
1830891 | 1830891 | 2021-10-19 | Jackson | Michigan | 26075 | 25172 | 354 |
1827642 | 1827642 | 2021-10-18 | Jackson | Michigan | 26075 | 25172 | 354 |
1824393 | 1824393 | 2021-10-17 | Jackson | Michigan | 26075 | 24991 | 352 |
1821144 | 1821144 | 2021-10-16 | Jackson | Michigan | 26075 | 24991 | 352 |
1817895 | 1817895 | 2021-10-15 | Jackson | Michigan | 26075 | 24991 | 352 |
1814646 | 1814646 | 2021-10-14 | Jackson | Michigan | 26075 | 24791 | 351 |
1811398 | 1811398 | 2021-10-13 | Jackson | Michigan | 26075 | 24791 | 351 |
1808149 | 1808149 | 2021-10-12 | Jackson | Michigan | 26075 | 24595 | 351 |
1804898 | 1804898 | 2021-10-11 | Jackson | Michigan | 26075 | 24595 | 351 |
1801649 | 1801649 | 2021-10-10 | Jackson | Michigan | 26075 | 24433 | 351 |
1798400 | 1798400 | 2021-10-09 | Jackson | Michigan | 26075 | 24433 | 351 |
1795151 | 1795151 | 2021-10-08 | Jackson | Michigan | 26075 | 24433 | 351 |
1791902 | 1791902 | 2021-10-07 | Jackson | Michigan | 26075 | 24249 | 348 |
1788653 | 1788653 | 2021-10-06 | Jackson | Michigan | 26075 | 24249 | 348 |
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);