ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 17077 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174835 | 2174835 | 2022-02-02 | Jackson | Illinois | 17077 | 14732 | 116 |
2171582 | 2171582 | 2022-02-01 | Jackson | Illinois | 17077 | 14642 | 116 |
2168329 | 2168329 | 2022-01-31 | Jackson | Illinois | 17077 | 14549 | 116 |
2165074 | 2165074 | 2022-01-30 | Jackson | Illinois | 17077 | 14344 | 116 |
2161819 | 2161819 | 2022-01-29 | Jackson | Illinois | 17077 | 14344 | 116 |
2158564 | 2158564 | 2022-01-28 | Jackson | Illinois | 17077 | 14344 | 116 |
2155310 | 2155310 | 2022-01-27 | Jackson | Illinois | 17077 | 14165 | 116 |
2152057 | 2152057 | 2022-01-26 | Jackson | Illinois | 17077 | 13999 | 116 |
2148805 | 2148805 | 2022-01-25 | Jackson | Illinois | 17077 | 13895 | 116 |
2145553 | 2145553 | 2022-01-24 | Jackson | Illinois | 17077 | 13748 | 116 |
2142298 | 2142298 | 2022-01-23 | Jackson | Illinois | 17077 | 13331 | 115 |
2139043 | 2139043 | 2022-01-22 | Jackson | Illinois | 17077 | 13331 | 115 |
2135787 | 2135787 | 2022-01-21 | Jackson | Illinois | 17077 | 13331 | 115 |
2132535 | 2132535 | 2022-01-20 | Jackson | Illinois | 17077 | 13053 | 115 |
2129282 | 2129282 | 2022-01-19 | Jackson | Illinois | 17077 | 12821 | 114 |
2126028 | 2126028 | 2022-01-18 | Jackson | Illinois | 17077 | 12589 | 114 |
2122776 | 2122776 | 2022-01-17 | Jackson | Illinois | 17077 | 11996 | 114 |
2119524 | 2119524 | 2022-01-16 | Jackson | Illinois | 17077 | 11996 | 114 |
2116272 | 2116272 | 2022-01-15 | Jackson | Illinois | 17077 | 11996 | 114 |
2113021 | 2113021 | 2022-01-14 | Jackson | Illinois | 17077 | 11996 | 114 |
2109769 | 2109769 | 2022-01-13 | Jackson | Illinois | 17077 | 11810 | 114 |
2106518 | 2106518 | 2022-01-12 | Jackson | Illinois | 17077 | 11545 | 114 |
2103267 | 2103267 | 2022-01-11 | Jackson | Illinois | 17077 | 11272 | 113 |
2100016 | 2100016 | 2022-01-10 | Jackson | Illinois | 17077 | 11107 | 113 |
2096765 | 2096765 | 2022-01-09 | Jackson | Illinois | 17077 | 10719 | 113 |
2093513 | 2093513 | 2022-01-08 | Jackson | Illinois | 17077 | 10719 | 113 |
2090261 | 2090261 | 2022-01-07 | Jackson | Illinois | 17077 | 10719 | 113 |
2087010 | 2087010 | 2022-01-06 | Jackson | Illinois | 17077 | 10456 | 113 |
2083758 | 2083758 | 2022-01-05 | Jackson | Illinois | 17077 | 10274 | 113 |
2080506 | 2080506 | 2022-01-04 | Jackson | Illinois | 17077 | 10042 | 113 |
2077254 | 2077254 | 2022-01-03 | Jackson | Illinois | 17077 | 9866 | 113 |
2074003 | 2074003 | 2022-01-02 | Jackson | Illinois | 17077 | 9483 | 112 |
2070752 | 2070752 | 2022-01-01 | Jackson | Illinois | 17077 | 9483 | 112 |
2067501 | 2067501 | 2021-12-31 | Jackson | Illinois | 17077 | 9483 | 112 |
2064250 | 2064250 | 2021-12-30 | Jackson | Illinois | 17077 | 9483 | 112 |
2061000 | 2061000 | 2021-12-29 | Jackson | Illinois | 17077 | 9354 | 112 |
2057751 | 2057751 | 2021-12-28 | Jackson | Illinois | 17077 | 9282 | 112 |
2054502 | 2054502 | 2021-12-27 | Jackson | Illinois | 17077 | 9152 | 112 |
2051252 | 2051252 | 2021-12-26 | Jackson | Illinois | 17077 | 8988 | 111 |
2048002 | 2048002 | 2021-12-25 | Jackson | Illinois | 17077 | 8988 | 111 |
2044752 | 2044752 | 2021-12-24 | Jackson | Illinois | 17077 | 8988 | 111 |
2041503 | 2041503 | 2021-12-23 | Jackson | Illinois | 17077 | 8988 | 111 |
2038253 | 2038253 | 2021-12-22 | Jackson | Illinois | 17077 | 8950 | 111 |
2035003 | 2035003 | 2021-12-21 | Jackson | Illinois | 17077 | 8911 | 111 |
2031753 | 2031753 | 2021-12-20 | Jackson | Illinois | 17077 | 8880 | 111 |
2028502 | 2028502 | 2021-12-19 | Jackson | Illinois | 17077 | 8777 | 111 |
2025251 | 2025251 | 2021-12-18 | Jackson | Illinois | 17077 | 8777 | 111 |
2022000 | 2022000 | 2021-12-17 | Jackson | Illinois | 17077 | 8777 | 111 |
2018749 | 2018749 | 2021-12-16 | Jackson | Illinois | 17077 | 8749 | 110 |
2015499 | 2015499 | 2021-12-15 | Jackson | Illinois | 17077 | 8702 | 110 |
2012248 | 2012248 | 2021-12-14 | Jackson | Illinois | 17077 | 8679 | 110 |
2008997 | 2008997 | 2021-12-13 | Jackson | Illinois | 17077 | 8656 | 110 |
2005746 | 2005746 | 2021-12-12 | Jackson | Illinois | 17077 | 8601 | 109 |
2002495 | 2002495 | 2021-12-11 | Jackson | Illinois | 17077 | 8601 | 109 |
1999245 | 1999245 | 2021-12-10 | Jackson | Illinois | 17077 | 8601 | 109 |
1995994 | 1995994 | 2021-12-09 | Jackson | Illinois | 17077 | 8581 | 108 |
1992743 | 1992743 | 2021-12-08 | Jackson | Illinois | 17077 | 8538 | 108 |
1989492 | 1989492 | 2021-12-07 | Jackson | Illinois | 17077 | 8523 | 108 |
1986242 | 1986242 | 2021-12-06 | Jackson | Illinois | 17077 | 8515 | 107 |
1982992 | 1982992 | 2021-12-05 | Jackson | Illinois | 17077 | 8457 | 107 |
1979742 | 1979742 | 2021-12-04 | Jackson | Illinois | 17077 | 8457 | 107 |
1976492 | 1976492 | 2021-12-03 | Jackson | Illinois | 17077 | 8457 | 107 |
1973243 | 1973243 | 2021-12-02 | Jackson | Illinois | 17077 | 8449 | 107 |
1969993 | 1969993 | 2021-12-01 | Jackson | Illinois | 17077 | 8409 | 106 |
1966743 | 1966743 | 2021-11-30 | Jackson | Illinois | 17077 | 8390 | 106 |
1963491 | 1963491 | 2021-11-29 | Jackson | Illinois | 17077 | 8377 | 106 |
1960240 | 1960240 | 2021-11-28 | Jackson | Illinois | 17077 | 8339 | 106 |
1956989 | 1956989 | 2021-11-27 | Jackson | Illinois | 17077 | 8339 | 106 |
1953738 | 1953738 | 2021-11-26 | Jackson | Illinois | 17077 | 8339 | 106 |
1950487 | 1950487 | 2021-11-25 | Jackson | Illinois | 17077 | 8339 | 106 |
1947236 | 1947236 | 2021-11-24 | Jackson | Illinois | 17077 | 8339 | 106 |
1943985 | 1943985 | 2021-11-23 | Jackson | Illinois | 17077 | 8328 | 106 |
1940735 | 1940735 | 2021-11-22 | Jackson | Illinois | 17077 | 8319 | 106 |
1937485 | 1937485 | 2021-11-21 | Jackson | Illinois | 17077 | 8294 | 106 |
1934235 | 1934235 | 2021-11-20 | Jackson | Illinois | 17077 | 8294 | 106 |
1930984 | 1930984 | 2021-11-19 | Jackson | Illinois | 17077 | 8294 | 106 |
1927733 | 1927733 | 2021-11-18 | Jackson | Illinois | 17077 | 8285 | 106 |
1924483 | 1924483 | 2021-11-17 | Jackson | Illinois | 17077 | 8262 | 106 |
1921234 | 1921234 | 2021-11-16 | Jackson | Illinois | 17077 | 8245 | 106 |
1917984 | 1917984 | 2021-11-15 | Jackson | Illinois | 17077 | 8243 | 106 |
1914734 | 1914734 | 2021-11-14 | Jackson | Illinois | 17077 | 8211 | 106 |
1911484 | 1911484 | 2021-11-13 | Jackson | Illinois | 17077 | 8211 | 106 |
1908235 | 1908235 | 2021-11-12 | Jackson | Illinois | 17077 | 8211 | 106 |
1904986 | 1904986 | 2021-11-11 | Jackson | Illinois | 17077 | 8203 | 106 |
1901736 | 1901736 | 2021-11-10 | Jackson | Illinois | 17077 | 8203 | 106 |
1898486 | 1898486 | 2021-11-09 | Jackson | Illinois | 17077 | 8190 | 106 |
1895236 | 1895236 | 2021-11-08 | Jackson | Illinois | 17077 | 8188 | 106 |
1891986 | 1891986 | 2021-11-07 | Jackson | Illinois | 17077 | 8178 | 106 |
1888736 | 1888736 | 2021-11-06 | Jackson | Illinois | 17077 | 8178 | 106 |
1885486 | 1885486 | 2021-11-05 | Jackson | Illinois | 17077 | 8178 | 106 |
1882237 | 1882237 | 2021-11-04 | Jackson | Illinois | 17077 | 8175 | 106 |
1878988 | 1878988 | 2021-11-03 | Jackson | Illinois | 17077 | 8166 | 106 |
1875739 | 1875739 | 2021-11-02 | Jackson | Illinois | 17077 | 8165 | 106 |
1872490 | 1872490 | 2021-11-01 | Jackson | Illinois | 17077 | 8159 | 106 |
1869241 | 1869241 | 2021-10-31 | Jackson | Illinois | 17077 | 8140 | 106 |
1865992 | 1865992 | 2021-10-30 | Jackson | Illinois | 17077 | 8140 | 106 |
1862743 | 1862743 | 2021-10-29 | Jackson | Illinois | 17077 | 8140 | 106 |
1859494 | 1859494 | 2021-10-28 | Jackson | Illinois | 17077 | 8136 | 106 |
1856245 | 1856245 | 2021-10-27 | Jackson | Illinois | 17077 | 8132 | 106 |
1852996 | 1852996 | 2021-10-26 | Jackson | Illinois | 17077 | 8126 | 106 |
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);