ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Kendall" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174843 | 2174843 | 2022-02-02 | Kendall | Illinois | 17093 | 29304 | 152 |
2171590 | 2171590 | 2022-02-01 | Kendall | Illinois | 17093 | 29224 | 152 |
2168337 | 2168337 | 2022-01-31 | Kendall | Illinois | 17093 | 29089 | 152 |
2165082 | 2165082 | 2022-01-30 | Kendall | Illinois | 17093 | 28853 | 151 |
2161827 | 2161827 | 2022-01-29 | Kendall | Illinois | 17093 | 28853 | 151 |
2158572 | 2158572 | 2022-01-28 | Kendall | Illinois | 17093 | 28853 | 151 |
2155318 | 2155318 | 2022-01-27 | Kendall | Illinois | 17093 | 28697 | 151 |
2152065 | 2152065 | 2022-01-26 | Kendall | Illinois | 17093 | 28527 | 150 |
2148813 | 2148813 | 2022-01-25 | Kendall | Illinois | 17093 | 28356 | 150 |
2145561 | 2145561 | 2022-01-24 | Kendall | Illinois | 17093 | 28239 | 150 |
2142306 | 2142306 | 2022-01-23 | Kendall | Illinois | 17093 | 27769 | 149 |
2139051 | 2139051 | 2022-01-22 | Kendall | Illinois | 17093 | 27769 | 149 |
2135795 | 2135795 | 2022-01-21 | Kendall | Illinois | 17093 | 27769 | 149 |
2132543 | 2132543 | 2022-01-20 | Kendall | Illinois | 17093 | 27505 | 148 |
2129290 | 2129290 | 2022-01-19 | Kendall | Illinois | 17093 | 27304 | 146 |
2126036 | 2126036 | 2022-01-18 | Kendall | Illinois | 17093 | 27089 | 144 |
2122784 | 2122784 | 2022-01-17 | Kendall | Illinois | 17093 | 26259 | 141 |
2119532 | 2119532 | 2022-01-16 | Kendall | Illinois | 17093 | 26259 | 141 |
2116280 | 2116280 | 2022-01-15 | Kendall | Illinois | 17093 | 26259 | 141 |
2113029 | 2113029 | 2022-01-14 | Kendall | Illinois | 17093 | 26259 | 141 |
2109777 | 2109777 | 2022-01-13 | Kendall | Illinois | 17093 | 26023 | 139 |
2106526 | 2106526 | 2022-01-12 | Kendall | Illinois | 17093 | 25706 | 139 |
2103275 | 2103275 | 2022-01-11 | Kendall | Illinois | 17093 | 25410 | 137 |
2100024 | 2100024 | 2022-01-10 | Kendall | Illinois | 17093 | 25117 | 137 |
2096773 | 2096773 | 2022-01-09 | Kendall | Illinois | 17093 | 24302 | 136 |
2093521 | 2093521 | 2022-01-08 | Kendall | Illinois | 17093 | 24302 | 136 |
2090269 | 2090269 | 2022-01-07 | Kendall | Illinois | 17093 | 24302 | 136 |
2087018 | 2087018 | 2022-01-06 | Kendall | Illinois | 17093 | 23962 | 136 |
2083766 | 2083766 | 2022-01-05 | Kendall | Illinois | 17093 | 23429 | 136 |
2080514 | 2080514 | 2022-01-04 | Kendall | Illinois | 17093 | 23071 | 135 |
2077262 | 2077262 | 2022-01-03 | Kendall | Illinois | 17093 | 22832 | 136 |
2074011 | 2074011 | 2022-01-02 | Kendall | Illinois | 17093 | 21819 | 136 |
2070760 | 2070760 | 2022-01-01 | Kendall | Illinois | 17093 | 21819 | 136 |
2067509 | 2067509 | 2021-12-31 | Kendall | Illinois | 17093 | 21819 | 136 |
2064258 | 2064258 | 2021-12-30 | Kendall | Illinois | 17093 | 21819 | 136 |
2061008 | 2061008 | 2021-12-29 | Kendall | Illinois | 17093 | 21421 | 135 |
2057759 | 2057759 | 2021-12-28 | Kendall | Illinois | 17093 | 21176 | 135 |
2054510 | 2054510 | 2021-12-27 | Kendall | Illinois | 17093 | 20878 | 135 |
2051260 | 2051260 | 2021-12-26 | Kendall | Illinois | 17093 | 20271 | 134 |
2048010 | 2048010 | 2021-12-25 | Kendall | Illinois | 17093 | 20271 | 134 |
2044760 | 2044760 | 2021-12-24 | Kendall | Illinois | 17093 | 20271 | 134 |
2041511 | 2041511 | 2021-12-23 | Kendall | Illinois | 17093 | 20271 | 134 |
2038261 | 2038261 | 2021-12-22 | Kendall | Illinois | 17093 | 20017 | 134 |
2035011 | 2035011 | 2021-12-21 | Kendall | Illinois | 17093 | 19942 | 134 |
2031761 | 2031761 | 2021-12-20 | Kendall | Illinois | 17093 | 19942 | 134 |
2028510 | 2028510 | 2021-12-19 | Kendall | Illinois | 17093 | 19942 | 134 |
2025259 | 2025259 | 2021-12-18 | Kendall | Illinois | 17093 | 19942 | 134 |
2022008 | 2022008 | 2021-12-17 | Kendall | Illinois | 17093 | 19942 | 134 |
2018757 | 2018757 | 2021-12-16 | Kendall | Illinois | 17093 | 19942 | 134 |
2015507 | 2015507 | 2021-12-15 | Kendall | Illinois | 17093 | 19339 | 133 |
2012256 | 2012256 | 2021-12-14 | Kendall | Illinois | 17093 | 19339 | 133 |
2009005 | 2009005 | 2021-12-13 | Kendall | Illinois | 17093 | 19339 | 131 |
2005754 | 2005754 | 2021-12-12 | Kendall | Illinois | 17093 | 19339 | 129 |
2002503 | 2002503 | 2021-12-11 | Kendall | Illinois | 17093 | 19339 | 129 |
1999253 | 1999253 | 2021-12-10 | Kendall | Illinois | 17093 | 19339 | 129 |
1996002 | 1996002 | 2021-12-09 | Kendall | Illinois | 17093 | 19339 | 129 |
1992751 | 1992751 | 2021-12-08 | Kendall | Illinois | 17093 | 18680 | 129 |
1989500 | 1989500 | 2021-12-07 | Kendall | Illinois | 17093 | 18680 | 129 |
1986250 | 1986250 | 2021-12-06 | Kendall | Illinois | 17093 | 18680 | 129 |
1983000 | 1983000 | 2021-12-05 | Kendall | Illinois | 17093 | 18680 | 129 |
1979750 | 1979750 | 2021-12-04 | Kendall | Illinois | 17093 | 18680 | 129 |
1976500 | 1976500 | 2021-12-03 | Kendall | Illinois | 17093 | 18680 | 129 |
1973251 | 1973251 | 2021-12-02 | Kendall | Illinois | 17093 | 18680 | 129 |
1970001 | 1970001 | 2021-12-01 | Kendall | Illinois | 17093 | 18282 | 128 |
1966751 | 1966751 | 2021-11-30 | Kendall | Illinois | 17093 | 18282 | 128 |
1963499 | 1963499 | 2021-11-29 | Kendall | Illinois | 17093 | 18282 | 128 |
1960248 | 1960248 | 2021-11-28 | Kendall | Illinois | 17093 | 18282 | 128 |
1956997 | 1956997 | 2021-11-27 | Kendall | Illinois | 17093 | 18282 | 128 |
1953746 | 1953746 | 2021-11-26 | Kendall | Illinois | 17093 | 18282 | 128 |
1950495 | 1950495 | 2021-11-25 | Kendall | Illinois | 17093 | 18282 | 128 |
1947244 | 1947244 | 2021-11-24 | Kendall | Illinois | 17093 | 18282 | 128 |
1943993 | 1943993 | 2021-11-23 | Kendall | Illinois | 17093 | 17933 | 128 |
1940743 | 1940743 | 2021-11-22 | Kendall | Illinois | 17093 | 17933 | 128 |
1937493 | 1937493 | 2021-11-21 | Kendall | Illinois | 17093 | 17933 | 127 |
1934243 | 1934243 | 2021-11-20 | Kendall | Illinois | 17093 | 17933 | 127 |
1930992 | 1930992 | 2021-11-19 | Kendall | Illinois | 17093 | 17933 | 127 |
1927741 | 1927741 | 2021-11-18 | Kendall | Illinois | 17093 | 17933 | 127 |
1924491 | 1924491 | 2021-11-17 | Kendall | Illinois | 17093 | 17710 | 127 |
1921242 | 1921242 | 2021-11-16 | Kendall | Illinois | 17093 | 17710 | 127 |
1917992 | 1917992 | 2021-11-15 | Kendall | Illinois | 17093 | 17710 | 127 |
1914742 | 1914742 | 2021-11-14 | Kendall | Illinois | 17093 | 17710 | 127 |
1911492 | 1911492 | 2021-11-13 | Kendall | Illinois | 17093 | 17710 | 127 |
1908243 | 1908243 | 2021-11-12 | Kendall | Illinois | 17093 | 17710 | 127 |
1904994 | 1904994 | 2021-11-11 | Kendall | Illinois | 17093 | 17421 | 127 |
1901744 | 1901744 | 2021-11-10 | Kendall | Illinois | 17093 | 17421 | 127 |
1898494 | 1898494 | 2021-11-09 | Kendall | Illinois | 17093 | 17421 | 127 |
1895244 | 1895244 | 2021-11-08 | Kendall | Illinois | 17093 | 17421 | 127 |
1891994 | 1891994 | 2021-11-07 | Kendall | Illinois | 17093 | 17421 | 127 |
1888744 | 1888744 | 2021-11-06 | Kendall | Illinois | 17093 | 17421 | 127 |
1885494 | 1885494 | 2021-11-05 | Kendall | Illinois | 17093 | 17421 | 127 |
1882245 | 1882245 | 2021-11-04 | Kendall | Illinois | 17093 | 17421 | 126 |
1878996 | 1878996 | 2021-11-03 | Kendall | Illinois | 17093 | 17252 | 125 |
1875747 | 1875747 | 2021-11-02 | Kendall | Illinois | 17093 | 17252 | 125 |
1872498 | 1872498 | 2021-11-01 | Kendall | Illinois | 17093 | 17252 | 125 |
1869249 | 1869249 | 2021-10-31 | Kendall | Illinois | 17093 | 17252 | 124 |
1866000 | 1866000 | 2021-10-30 | Kendall | Illinois | 17093 | 17252 | 124 |
1862751 | 1862751 | 2021-10-29 | Kendall | Illinois | 17093 | 17252 | 124 |
1859502 | 1859502 | 2021-10-28 | Kendall | Illinois | 17093 | 17252 | 124 |
1856253 | 1856253 | 2021-10-27 | Kendall | Illinois | 17093 | 17102 | 124 |
1853004 | 1853004 | 2021-10-26 | Kendall | Illinois | 17093 | 17102 | 124 |
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);