ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 17027 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109744 | 2109744 | 2022-01-13 | Clinton | Illinois | 17027 | 10035 | 117 |
2106493 | 2106493 | 2022-01-12 | Clinton | Illinois | 17027 | 9817 | 117 |
2103242 | 2103242 | 2022-01-11 | Clinton | Illinois | 17027 | 9692 | 117 |
2099991 | 2099991 | 2022-01-10 | Clinton | Illinois | 17027 | 9492 | 117 |
2096740 | 2096740 | 2022-01-09 | Clinton | Illinois | 17027 | 9146 | 117 |
2093488 | 2093488 | 2022-01-08 | Clinton | Illinois | 17027 | 9146 | 117 |
2090236 | 2090236 | 2022-01-07 | Clinton | Illinois | 17027 | 9146 | 117 |
2086985 | 2086985 | 2022-01-06 | Clinton | Illinois | 17027 | 9021 | 117 |
2083733 | 2083733 | 2022-01-05 | Clinton | Illinois | 17027 | 8840 | 117 |
2080481 | 2080481 | 2022-01-04 | Clinton | Illinois | 17027 | 8680 | 117 |
2077229 | 2077229 | 2022-01-03 | Clinton | Illinois | 17027 | 8453 | 117 |
2073978 | 2073978 | 2022-01-02 | Clinton | Illinois | 17027 | 8266 | 117 |
2070727 | 2070727 | 2022-01-01 | Clinton | Illinois | 17027 | 8266 | 117 |
2067476 | 2067476 | 2021-12-31 | Clinton | Illinois | 17027 | 8266 | 117 |
2064225 | 2064225 | 2021-12-30 | Clinton | Illinois | 17027 | 8266 | 117 |
2060975 | 2060975 | 2021-12-29 | Clinton | Illinois | 17027 | 8155 | 117 |
2057726 | 2057726 | 2021-12-28 | Clinton | Illinois | 17027 | 8115 | 117 |
2054477 | 2054477 | 2021-12-27 | Clinton | Illinois | 17027 | 8048 | 117 |
2051227 | 2051227 | 2021-12-26 | Clinton | Illinois | 17027 | 7976 | 116 |
2047977 | 2047977 | 2021-12-25 | Clinton | Illinois | 17027 | 7976 | 116 |
2044727 | 2044727 | 2021-12-24 | Clinton | Illinois | 17027 | 7976 | 116 |
2041478 | 2041478 | 2021-12-23 | Clinton | Illinois | 17027 | 7976 | 116 |
2038228 | 2038228 | 2021-12-22 | Clinton | Illinois | 17027 | 7937 | 116 |
2034978 | 2034978 | 2021-12-21 | Clinton | Illinois | 17027 | 7913 | 116 |
2031728 | 2031728 | 2021-12-20 | Clinton | Illinois | 17027 | 7872 | 116 |
2028477 | 2028477 | 2021-12-19 | Clinton | Illinois | 17027 | 7822 | 116 |
2025226 | 2025226 | 2021-12-18 | Clinton | Illinois | 17027 | 7822 | 116 |
2021975 | 2021975 | 2021-12-17 | Clinton | Illinois | 17027 | 7822 | 116 |
2018724 | 2018724 | 2021-12-16 | Clinton | Illinois | 17027 | 7794 | 116 |
2015474 | 2015474 | 2021-12-15 | Clinton | Illinois | 17027 | 7780 | 116 |
2012223 | 2012223 | 2021-12-14 | Clinton | Illinois | 17027 | 7756 | 116 |
2008972 | 2008972 | 2021-12-13 | Clinton | Illinois | 17027 | 7726 | 116 |
2005721 | 2005721 | 2021-12-12 | Clinton | Illinois | 17027 | 7687 | 115 |
2002470 | 2002470 | 2021-12-11 | Clinton | Illinois | 17027 | 7687 | 115 |
1999220 | 1999220 | 2021-12-10 | Clinton | Illinois | 17027 | 7687 | 115 |
1995969 | 1995969 | 2021-12-09 | Clinton | Illinois | 17027 | 7662 | 114 |
1992718 | 1992718 | 2021-12-08 | Clinton | Illinois | 17027 | 7639 | 114 |
1989467 | 1989467 | 2021-12-07 | Clinton | Illinois | 17027 | 7596 | 114 |
1986217 | 1986217 | 2021-12-06 | Clinton | Illinois | 17027 | 7560 | 114 |
1982967 | 1982967 | 2021-12-05 | Clinton | Illinois | 17027 | 7518 | 114 |
1979717 | 1979717 | 2021-12-04 | Clinton | Illinois | 17027 | 7518 | 114 |
1976467 | 1976467 | 2021-12-03 | Clinton | Illinois | 17027 | 7518 | 114 |
1973218 | 1973218 | 2021-12-02 | Clinton | Illinois | 17027 | 7485 | 114 |
1969968 | 1969968 | 2021-12-01 | Clinton | Illinois | 17027 | 7472 | 114 |
1966718 | 1966718 | 2021-11-30 | Clinton | Illinois | 17027 | 7451 | 114 |
1963466 | 1963466 | 2021-11-29 | Clinton | Illinois | 17027 | 7414 | 114 |
1960215 | 1960215 | 2021-11-28 | Clinton | Illinois | 17027 | 7379 | 114 |
1956964 | 1956964 | 2021-11-27 | Clinton | Illinois | 17027 | 7379 | 114 |
1953713 | 1953713 | 2021-11-26 | Clinton | Illinois | 17027 | 7379 | 114 |
1950462 | 1950462 | 2021-11-25 | Clinton | Illinois | 17027 | 7379 | 114 |
1947211 | 1947211 | 2021-11-24 | Clinton | Illinois | 17027 | 7379 | 114 |
1943960 | 1943960 | 2021-11-23 | Clinton | Illinois | 17027 | 7368 | 114 |
1940710 | 1940710 | 2021-11-22 | Clinton | Illinois | 17027 | 7349 | 114 |
1937460 | 1937460 | 2021-11-21 | Clinton | Illinois | 17027 | 7338 | 114 |
1934210 | 1934210 | 2021-11-20 | Clinton | Illinois | 17027 | 7338 | 114 |
1930959 | 1930959 | 2021-11-19 | Clinton | Illinois | 17027 | 7338 | 114 |
1927708 | 1927708 | 2021-11-18 | Clinton | Illinois | 17027 | 7328 | 114 |
1924458 | 1924458 | 2021-11-17 | Clinton | Illinois | 17027 | 7324 | 114 |
1921209 | 1921209 | 2021-11-16 | Clinton | Illinois | 17027 | 7316 | 114 |
1917959 | 1917959 | 2021-11-15 | Clinton | Illinois | 17027 | 7296 | 113 |
1914709 | 1914709 | 2021-11-14 | Clinton | Illinois | 17027 | 7278 | 113 |
1911459 | 1911459 | 2021-11-13 | Clinton | Illinois | 17027 | 7278 | 113 |
1908210 | 1908210 | 2021-11-12 | Clinton | Illinois | 17027 | 7278 | 113 |
1904961 | 1904961 | 2021-11-11 | Clinton | Illinois | 17027 | 7264 | 113 |
1901711 | 1901711 | 2021-11-10 | Clinton | Illinois | 17027 | 7264 | 113 |
1898461 | 1898461 | 2021-11-09 | Clinton | Illinois | 17027 | 7255 | 113 |
1895211 | 1895211 | 2021-11-08 | Clinton | Illinois | 17027 | 7238 | 113 |
1891961 | 1891961 | 2021-11-07 | Clinton | Illinois | 17027 | 7223 | 113 |
1888711 | 1888711 | 2021-11-06 | Clinton | Illinois | 17027 | 7223 | 113 |
1885461 | 1885461 | 2021-11-05 | Clinton | Illinois | 17027 | 7223 | 113 |
1882212 | 1882212 | 2021-11-04 | Clinton | Illinois | 17027 | 7210 | 113 |
1878963 | 1878963 | 2021-11-03 | Clinton | Illinois | 17027 | 7191 | 112 |
1875714 | 1875714 | 2021-11-02 | Clinton | Illinois | 17027 | 7185 | 112 |
1872465 | 1872465 | 2021-11-01 | Clinton | Illinois | 17027 | 7180 | 111 |
1869216 | 1869216 | 2021-10-31 | Clinton | Illinois | 17027 | 7168 | 111 |
1865967 | 1865967 | 2021-10-30 | Clinton | Illinois | 17027 | 7168 | 111 |
1862718 | 1862718 | 2021-10-29 | Clinton | Illinois | 17027 | 7168 | 111 |
1859469 | 1859469 | 2021-10-28 | Clinton | Illinois | 17027 | 7158 | 111 |
1856220 | 1856220 | 2021-10-27 | Clinton | Illinois | 17027 | 7152 | 111 |
1852971 | 1852971 | 2021-10-26 | Clinton | Illinois | 17027 | 7149 | 111 |
1849722 | 1849722 | 2021-10-25 | Clinton | Illinois | 17027 | 7143 | 111 |
1846472 | 1846472 | 2021-10-24 | Clinton | Illinois | 17027 | 7136 | 111 |
1843222 | 1843222 | 2021-10-23 | Clinton | Illinois | 17027 | 7136 | 111 |
1839972 | 1839972 | 2021-10-22 | Clinton | Illinois | 17027 | 7136 | 111 |
1836723 | 1836723 | 2021-10-21 | Clinton | Illinois | 17027 | 7129 | 111 |
1833474 | 1833474 | 2021-10-20 | Clinton | Illinois | 17027 | 7124 | 111 |
1830225 | 1830225 | 2021-10-19 | Clinton | Illinois | 17027 | 7115 | 111 |
1826976 | 1826976 | 2021-10-18 | Clinton | Illinois | 17027 | 7113 | 111 |
1823727 | 1823727 | 2021-10-17 | Clinton | Illinois | 17027 | 7095 | 111 |
1820478 | 1820478 | 2021-10-16 | Clinton | Illinois | 17027 | 7095 | 111 |
1817229 | 1817229 | 2021-10-15 | Clinton | Illinois | 17027 | 7095 | 111 |
1813981 | 1813981 | 2021-10-14 | Clinton | Illinois | 17027 | 7080 | 111 |
1810732 | 1810732 | 2021-10-13 | Clinton | Illinois | 17027 | 7060 | 111 |
1807483 | 1807483 | 2021-10-12 | Clinton | Illinois | 17027 | 7036 | 111 |
1804232 | 1804232 | 2021-10-11 | Clinton | Illinois | 17027 | 7017 | 110 |
1800983 | 1800983 | 2021-10-10 | Clinton | Illinois | 17027 | 7017 | 110 |
1797734 | 1797734 | 2021-10-09 | Clinton | Illinois | 17027 | 7017 | 110 |
1794485 | 1794485 | 2021-10-08 | Clinton | Illinois | 17027 | 7017 | 110 |
1791237 | 1791237 | 2021-10-07 | Clinton | Illinois | 17027 | 6980 | 110 |
1787988 | 1787988 | 2021-10-06 | Clinton | Illinois | 17027 | 6958 | 110 |
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);