ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 26139 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110442 | 2110442 | 2022-01-13 | Ottawa | Michigan | 26139 | 61146 | 684 |
2107191 | 2107191 | 2022-01-12 | Ottawa | Michigan | 26139 | 61146 | 684 |
2103940 | 2103940 | 2022-01-11 | Ottawa | Michigan | 26139 | 60057 | 672 |
2100689 | 2100689 | 2022-01-10 | Ottawa | Michigan | 26139 | 60057 | 672 |
2097438 | 2097438 | 2022-01-09 | Ottawa | Michigan | 26139 | 58717 | 672 |
2094186 | 2094186 | 2022-01-08 | Ottawa | Michigan | 26139 | 58717 | 672 |
2090934 | 2090934 | 2022-01-07 | Ottawa | Michigan | 26139 | 58717 | 672 |
2087683 | 2087683 | 2022-01-06 | Ottawa | Michigan | 26139 | 57600 | 665 |
2084431 | 2084431 | 2022-01-05 | Ottawa | Michigan | 26139 | 57600 | 665 |
2081179 | 2081179 | 2022-01-04 | Ottawa | Michigan | 26139 | 56769 | 658 |
2077927 | 2077927 | 2022-01-03 | Ottawa | Michigan | 26139 | 56769 | 658 |
2074676 | 2074676 | 2022-01-02 | Ottawa | Michigan | 26139 | 55516 | 646 |
2071425 | 2071425 | 2022-01-01 | Ottawa | Michigan | 26139 | 55516 | 646 |
2068174 | 2068174 | 2021-12-31 | Ottawa | Michigan | 26139 | 55516 | 646 |
2064923 | 2064923 | 2021-12-30 | Ottawa | Michigan | 26139 | 55516 | 646 |
2061673 | 2061673 | 2021-12-29 | Ottawa | Michigan | 26139 | 55516 | 646 |
2058424 | 2058424 | 2021-12-28 | Ottawa | Michigan | 26139 | 54992 | 641 |
2055175 | 2055175 | 2021-12-27 | Ottawa | Michigan | 26139 | 54992 | 641 |
2051925 | 2051925 | 2021-12-26 | Ottawa | Michigan | 26139 | 54422 | 629 |
2048675 | 2048675 | 2021-12-25 | Ottawa | Michigan | 26139 | 54422 | 629 |
2045425 | 2045425 | 2021-12-24 | Ottawa | Michigan | 26139 | 54422 | 629 |
2042175 | 2042175 | 2021-12-23 | Ottawa | Michigan | 26139 | 54422 | 629 |
2038926 | 2038926 | 2021-12-22 | Ottawa | Michigan | 26139 | 54422 | 629 |
2035676 | 2035676 | 2021-12-21 | Ottawa | Michigan | 26139 | 54051 | 622 |
2032426 | 2032426 | 2021-12-20 | Ottawa | Michigan | 26139 | 54051 | 622 |
2029175 | 2029175 | 2021-12-19 | Ottawa | Michigan | 26139 | 53777 | 617 |
2025924 | 2025924 | 2021-12-18 | Ottawa | Michigan | 26139 | 53777 | 617 |
2022673 | 2022673 | 2021-12-17 | Ottawa | Michigan | 26139 | 53777 | 617 |
2019422 | 2019422 | 2021-12-16 | Ottawa | Michigan | 26139 | 53384 | 609 |
2016172 | 2016172 | 2021-12-15 | Ottawa | Michigan | 26139 | 53384 | 609 |
2012921 | 2012921 | 2021-12-14 | Ottawa | Michigan | 26139 | 53029 | 600 |
2009670 | 2009670 | 2021-12-13 | Ottawa | Michigan | 26139 | 53029 | 600 |
2006419 | 2006419 | 2021-12-12 | Ottawa | Michigan | 26139 | 52439 | 598 |
2003168 | 2003168 | 2021-12-11 | Ottawa | Michigan | 26139 | 52439 | 598 |
1999918 | 1999918 | 2021-12-10 | Ottawa | Michigan | 26139 | 52439 | 598 |
1996667 | 1996667 | 2021-12-09 | Ottawa | Michigan | 26139 | 52064 | 595 |
1993416 | 1993416 | 2021-12-08 | Ottawa | Michigan | 26139 | 52064 | 595 |
1990165 | 1990165 | 2021-12-07 | Ottawa | Michigan | 26139 | 51462 | 579 |
1986915 | 1986915 | 2021-12-06 | Ottawa | Michigan | 26139 | 51462 | 579 |
1983665 | 1983665 | 2021-12-05 | Ottawa | Michigan | 26139 | 50897 | 573 |
1980415 | 1980415 | 2021-12-04 | Ottawa | Michigan | 26139 | 50897 | 573 |
1977165 | 1977165 | 2021-12-03 | Ottawa | Michigan | 26139 | 50897 | 573 |
1973915 | 1973915 | 2021-12-02 | Ottawa | Michigan | 26139 | 50068 | 572 |
1970666 | 1970666 | 2021-12-01 | Ottawa | Michigan | 26139 | 50068 | 572 |
1967416 | 1967416 | 2021-11-30 | Ottawa | Michigan | 26139 | 49303 | 562 |
1964164 | 1964164 | 2021-11-29 | Ottawa | Michigan | 26139 | 49303 | 562 |
1960913 | 1960913 | 2021-11-28 | Ottawa | Michigan | 26139 | 48398 | 557 |
1957662 | 1957662 | 2021-11-27 | Ottawa | Michigan | 26139 | 48398 | 557 |
1954411 | 1954411 | 2021-11-26 | Ottawa | Michigan | 26139 | 48398 | 557 |
1951160 | 1951160 | 2021-11-25 | Ottawa | Michigan | 26139 | 48398 | 557 |
1947909 | 1947909 | 2021-11-24 | Ottawa | Michigan | 26139 | 48398 | 557 |
1944658 | 1944658 | 2021-11-23 | Ottawa | Michigan | 26139 | 47685 | 544 |
1941407 | 1941407 | 2021-11-22 | Ottawa | Michigan | 26139 | 47685 | 544 |
1938157 | 1938157 | 2021-11-21 | Ottawa | Michigan | 26139 | 46980 | 544 |
1934907 | 1934907 | 2021-11-20 | Ottawa | Michigan | 26139 | 46980 | 544 |
1931657 | 1931657 | 2021-11-19 | Ottawa | Michigan | 26139 | 46980 | 544 |
1928406 | 1928406 | 2021-11-18 | Ottawa | Michigan | 26139 | 46060 | 536 |
1925156 | 1925156 | 2021-11-17 | Ottawa | Michigan | 26139 | 46060 | 536 |
1921907 | 1921907 | 2021-11-16 | Ottawa | Michigan | 26139 | 45474 | 530 |
1918657 | 1918657 | 2021-11-15 | Ottawa | Michigan | 26139 | 45474 | 530 |
1915407 | 1915407 | 2021-11-14 | Ottawa | Michigan | 26139 | 44467 | 527 |
1912157 | 1912157 | 2021-11-13 | Ottawa | Michigan | 26139 | 44467 | 527 |
1908907 | 1908907 | 2021-11-12 | Ottawa | Michigan | 26139 | 44467 | 527 |
1905658 | 1905658 | 2021-11-11 | Ottawa | Michigan | 26139 | 43675 | 522 |
1902409 | 1902409 | 2021-11-10 | Ottawa | Michigan | 26139 | 43675 | 522 |
1899159 | 1899159 | 2021-11-09 | Ottawa | Michigan | 26139 | 43452 | 514 |
1895909 | 1895909 | 2021-11-08 | Ottawa | Michigan | 26139 | 43452 | 514 |
1892659 | 1892659 | 2021-11-07 | Ottawa | Michigan | 26139 | 43084 | 513 |
1889409 | 1889409 | 2021-11-06 | Ottawa | Michigan | 26139 | 43084 | 513 |
1886159 | 1886159 | 2021-11-05 | Ottawa | Michigan | 26139 | 43084 | 513 |
1882910 | 1882910 | 2021-11-04 | Ottawa | Michigan | 26139 | 42610 | 509 |
1879661 | 1879661 | 2021-11-03 | Ottawa | Michigan | 26139 | 42610 | 509 |
1876412 | 1876412 | 2021-11-02 | Ottawa | Michigan | 26139 | 42143 | 507 |
1873163 | 1873163 | 2021-11-01 | Ottawa | Michigan | 26139 | 42143 | 507 |
1869914 | 1869914 | 2021-10-31 | Ottawa | Michigan | 26139 | 41778 | 505 |
1866665 | 1866665 | 2021-10-30 | Ottawa | Michigan | 26139 | 41778 | 505 |
1863416 | 1863416 | 2021-10-29 | Ottawa | Michigan | 26139 | 41778 | 505 |
1860167 | 1860167 | 2021-10-28 | Ottawa | Michigan | 26139 | 41440 | 505 |
1856918 | 1856918 | 2021-10-27 | Ottawa | Michigan | 26139 | 41440 | 505 |
1853669 | 1853669 | 2021-10-26 | Ottawa | Michigan | 26139 | 41101 | 501 |
1850420 | 1850420 | 2021-10-25 | Ottawa | Michigan | 26139 | 41101 | 501 |
1847170 | 1847170 | 2021-10-24 | Ottawa | Michigan | 26139 | 40850 | 499 |
1843920 | 1843920 | 2021-10-23 | Ottawa | Michigan | 26139 | 40850 | 499 |
1840670 | 1840670 | 2021-10-22 | Ottawa | Michigan | 26139 | 40850 | 499 |
1837421 | 1837421 | 2021-10-21 | Ottawa | Michigan | 26139 | 40542 | 497 |
1834172 | 1834172 | 2021-10-20 | Ottawa | Michigan | 26139 | 40542 | 497 |
1830923 | 1830923 | 2021-10-19 | Ottawa | Michigan | 26139 | 40251 | 492 |
1827674 | 1827674 | 2021-10-18 | Ottawa | Michigan | 26139 | 40251 | 492 |
1824425 | 1824425 | 2021-10-17 | Ottawa | Michigan | 26139 | 39985 | 489 |
1821176 | 1821176 | 2021-10-16 | Ottawa | Michigan | 26139 | 39985 | 489 |
1817927 | 1817927 | 2021-10-15 | Ottawa | Michigan | 26139 | 39985 | 489 |
1814678 | 1814678 | 2021-10-14 | Ottawa | Michigan | 26139 | 39679 | 488 |
1811430 | 1811430 | 2021-10-13 | Ottawa | Michigan | 26139 | 39679 | 488 |
1808181 | 1808181 | 2021-10-12 | Ottawa | Michigan | 26139 | 39284 | 483 |
1804930 | 1804930 | 2021-10-11 | Ottawa | Michigan | 26139 | 39284 | 483 |
1801681 | 1801681 | 2021-10-10 | Ottawa | Michigan | 26139 | 39021 | 483 |
1798432 | 1798432 | 2021-10-09 | Ottawa | Michigan | 26139 | 39021 | 483 |
1795183 | 1795183 | 2021-10-08 | Ottawa | Michigan | 26139 | 39021 | 483 |
1791934 | 1791934 | 2021-10-07 | Ottawa | Michigan | 26139 | 38700 | 479 |
1788685 | 1788685 | 2021-10-06 | Ottawa | Michigan | 26139 | 38700 | 479 |
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);