ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Ottawa" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175508 | 2175508 | 2022-02-02 | Ottawa | Michigan | 26139 | 71571 | 733 |
2172255 | 2172255 | 2022-02-01 | Ottawa | Michigan | 26139 | 70822 | 723 |
2169002 | 2169002 | 2022-01-31 | Ottawa | Michigan | 26139 | 70822 | 723 |
2165747 | 2165747 | 2022-01-30 | Ottawa | Michigan | 26139 | 70237 | 722 |
2162492 | 2162492 | 2022-01-29 | Ottawa | Michigan | 26139 | 70237 | 722 |
2159237 | 2159237 | 2022-01-28 | Ottawa | Michigan | 26139 | 70237 | 722 |
2155983 | 2155983 | 2022-01-27 | Ottawa | Michigan | 26139 | 69222 | 715 |
2152730 | 2152730 | 2022-01-26 | Ottawa | Michigan | 26139 | 69222 | 715 |
2149478 | 2149478 | 2022-01-25 | Ottawa | Michigan | 26139 | 68241 | 710 |
2146226 | 2146226 | 2022-01-24 | Ottawa | Michigan | 26139 | 68241 | 710 |
2142971 | 2142971 | 2022-01-23 | Ottawa | Michigan | 26139 | 66529 | 707 |
2139716 | 2139716 | 2022-01-22 | Ottawa | Michigan | 26139 | 66529 | 707 |
2136460 | 2136460 | 2022-01-21 | Ottawa | Michigan | 26139 | 66529 | 707 |
2133208 | 2133208 | 2022-01-20 | Ottawa | Michigan | 26139 | 65259 | 703 |
2129955 | 2129955 | 2022-01-19 | Ottawa | Michigan | 26139 | 65259 | 703 |
2126701 | 2126701 | 2022-01-18 | Ottawa | Michigan | 26139 | 62279 | 689 |
2123449 | 2123449 | 2022-01-17 | Ottawa | Michigan | 26139 | 62279 | 689 |
2120197 | 2120197 | 2022-01-16 | Ottawa | Michigan | 26139 | 62279 | 689 |
2116945 | 2116945 | 2022-01-15 | Ottawa | Michigan | 26139 | 62279 | 689 |
2113694 | 2113694 | 2022-01-14 | Ottawa | Michigan | 26139 | 62279 | 689 |
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 |
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);