ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 17157 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174875 | 2174875 | 2022-02-02 | Randolph | Illinois | 17157 | 9927 | 120 |
2171622 | 2171622 | 2022-02-01 | Randolph | Illinois | 17157 | 9829 | 119 |
2168369 | 2168369 | 2022-01-31 | Randolph | Illinois | 17157 | 9775 | 119 |
2165114 | 2165114 | 2022-01-30 | Randolph | Illinois | 17157 | 9666 | 119 |
2161859 | 2161859 | 2022-01-29 | Randolph | Illinois | 17157 | 9666 | 119 |
2158604 | 2158604 | 2022-01-28 | Randolph | Illinois | 17157 | 9666 | 119 |
2155350 | 2155350 | 2022-01-27 | Randolph | Illinois | 17157 | 9471 | 118 |
2152097 | 2152097 | 2022-01-26 | Randolph | Illinois | 17157 | 9293 | 118 |
2148845 | 2148845 | 2022-01-25 | Randolph | Illinois | 17157 | 9090 | 118 |
2145593 | 2145593 | 2022-01-24 | Randolph | Illinois | 17157 | 8898 | 118 |
2142338 | 2142338 | 2022-01-23 | Randolph | Illinois | 17157 | 8660 | 118 |
2139083 | 2139083 | 2022-01-22 | Randolph | Illinois | 17157 | 8660 | 118 |
2135827 | 2135827 | 2022-01-21 | Randolph | Illinois | 17157 | 8660 | 118 |
2132575 | 2132575 | 2022-01-20 | Randolph | Illinois | 17157 | 8566 | 118 |
2129322 | 2129322 | 2022-01-19 | Randolph | Illinois | 17157 | 8367 | 118 |
2126068 | 2126068 | 2022-01-18 | Randolph | Illinois | 17157 | 8209 | 118 |
2122816 | 2122816 | 2022-01-17 | Randolph | Illinois | 17157 | 7508 | 115 |
2119564 | 2119564 | 2022-01-16 | Randolph | Illinois | 17157 | 7508 | 115 |
2116312 | 2116312 | 2022-01-15 | Randolph | Illinois | 17157 | 7508 | 115 |
2113061 | 2113061 | 2022-01-14 | Randolph | Illinois | 17157 | 7508 | 115 |
2109809 | 2109809 | 2022-01-13 | Randolph | Illinois | 17157 | 7438 | 115 |
2106558 | 2106558 | 2022-01-12 | Randolph | Illinois | 17157 | 7295 | 115 |
2103307 | 2103307 | 2022-01-11 | Randolph | Illinois | 17157 | 7133 | 115 |
2100056 | 2100056 | 2022-01-10 | Randolph | Illinois | 17157 | 6986 | 115 |
2096805 | 2096805 | 2022-01-09 | Randolph | Illinois | 17157 | 6857 | 114 |
2093553 | 2093553 | 2022-01-08 | Randolph | Illinois | 17157 | 6857 | 114 |
2090301 | 2090301 | 2022-01-07 | Randolph | Illinois | 17157 | 6857 | 114 |
2087050 | 2087050 | 2022-01-06 | Randolph | Illinois | 17157 | 6784 | 113 |
2083798 | 2083798 | 2022-01-05 | Randolph | Illinois | 17157 | 6687 | 113 |
2080546 | 2080546 | 2022-01-04 | Randolph | Illinois | 17157 | 6581 | 113 |
2077294 | 2077294 | 2022-01-03 | Randolph | Illinois | 17157 | 6503 | 113 |
2074043 | 2074043 | 2022-01-02 | Randolph | Illinois | 17157 | 6333 | 113 |
2070792 | 2070792 | 2022-01-01 | Randolph | Illinois | 17157 | 6333 | 113 |
2067541 | 2067541 | 2021-12-31 | Randolph | Illinois | 17157 | 6333 | 113 |
2064290 | 2064290 | 2021-12-30 | Randolph | Illinois | 17157 | 6333 | 113 |
2061040 | 2061040 | 2021-12-29 | Randolph | Illinois | 17157 | 6245 | 113 |
2057791 | 2057791 | 2021-12-28 | Randolph | Illinois | 17157 | 6191 | 113 |
2054542 | 2054542 | 2021-12-27 | Randolph | Illinois | 17157 | 6135 | 113 |
2051292 | 2051292 | 2021-12-26 | Randolph | Illinois | 17157 | 6082 | 113 |
2048042 | 2048042 | 2021-12-25 | Randolph | Illinois | 17157 | 6082 | 113 |
2044792 | 2044792 | 2021-12-24 | Randolph | Illinois | 17157 | 6082 | 113 |
2041543 | 2041543 | 2021-12-23 | Randolph | Illinois | 17157 | 6082 | 113 |
2038293 | 2038293 | 2021-12-22 | Randolph | Illinois | 17157 | 6064 | 113 |
2035043 | 2035043 | 2021-12-21 | Randolph | Illinois | 17157 | 6054 | 113 |
2031793 | 2031793 | 2021-12-20 | Randolph | Illinois | 17157 | 6041 | 113 |
2028542 | 2028542 | 2021-12-19 | Randolph | Illinois | 17157 | 6001 | 112 |
2025291 | 2025291 | 2021-12-18 | Randolph | Illinois | 17157 | 6001 | 112 |
2022040 | 2022040 | 2021-12-17 | Randolph | Illinois | 17157 | 6001 | 112 |
2018789 | 2018789 | 2021-12-16 | Randolph | Illinois | 17157 | 5982 | 111 |
2015539 | 2015539 | 2021-12-15 | Randolph | Illinois | 17157 | 5955 | 110 |
2012288 | 2012288 | 2021-12-14 | Randolph | Illinois | 17157 | 5940 | 110 |
2009037 | 2009037 | 2021-12-13 | Randolph | Illinois | 17157 | 5918 | 110 |
2005786 | 2005786 | 2021-12-12 | Randolph | Illinois | 17157 | 5869 | 110 |
2002535 | 2002535 | 2021-12-11 | Randolph | Illinois | 17157 | 5869 | 110 |
1999285 | 1999285 | 2021-12-10 | Randolph | Illinois | 17157 | 5869 | 110 |
1996034 | 1996034 | 2021-12-09 | Randolph | Illinois | 17157 | 5845 | 110 |
1992783 | 1992783 | 2021-12-08 | Randolph | Illinois | 17157 | 5825 | 110 |
1989532 | 1989532 | 2021-12-07 | Randolph | Illinois | 17157 | 5819 | 110 |
1986282 | 1986282 | 2021-12-06 | Randolph | Illinois | 17157 | 5800 | 109 |
1983032 | 1983032 | 2021-12-05 | Randolph | Illinois | 17157 | 5768 | 109 |
1979782 | 1979782 | 2021-12-04 | Randolph | Illinois | 17157 | 5768 | 109 |
1976532 | 1976532 | 2021-12-03 | Randolph | Illinois | 17157 | 5768 | 109 |
1973283 | 1973283 | 2021-12-02 | Randolph | Illinois | 17157 | 5758 | 109 |
1970033 | 1970033 | 2021-12-01 | Randolph | Illinois | 17157 | 5744 | 109 |
1966783 | 1966783 | 2021-11-30 | Randolph | Illinois | 17157 | 5736 | 109 |
1963531 | 1963531 | 2021-11-29 | Randolph | Illinois | 17157 | 5729 | 109 |
1960280 | 1960280 | 2021-11-28 | Randolph | Illinois | 17157 | 5706 | 109 |
1957029 | 1957029 | 2021-11-27 | Randolph | Illinois | 17157 | 5706 | 109 |
1953778 | 1953778 | 2021-11-26 | Randolph | Illinois | 17157 | 5706 | 109 |
1950527 | 1950527 | 2021-11-25 | Randolph | Illinois | 17157 | 5706 | 109 |
1947276 | 1947276 | 2021-11-24 | Randolph | Illinois | 17157 | 5706 | 109 |
1944025 | 1944025 | 2021-11-23 | Randolph | Illinois | 17157 | 5695 | 109 |
1940775 | 1940775 | 2021-11-22 | Randolph | Illinois | 17157 | 5684 | 109 |
1937525 | 1937525 | 2021-11-21 | Randolph | Illinois | 17157 | 5670 | 109 |
1934275 | 1934275 | 2021-11-20 | Randolph | Illinois | 17157 | 5670 | 109 |
1931024 | 1931024 | 2021-11-19 | Randolph | Illinois | 17157 | 5670 | 109 |
1927773 | 1927773 | 2021-11-18 | Randolph | Illinois | 17157 | 5663 | 109 |
1924523 | 1924523 | 2021-11-17 | Randolph | Illinois | 17157 | 5650 | 109 |
1921274 | 1921274 | 2021-11-16 | Randolph | Illinois | 17157 | 5646 | 109 |
1918024 | 1918024 | 2021-11-15 | Randolph | Illinois | 17157 | 5640 | 109 |
1914774 | 1914774 | 2021-11-14 | Randolph | Illinois | 17157 | 5630 | 109 |
1911524 | 1911524 | 2021-11-13 | Randolph | Illinois | 17157 | 5630 | 109 |
1908275 | 1908275 | 2021-11-12 | Randolph | Illinois | 17157 | 5630 | 109 |
1905026 | 1905026 | 2021-11-11 | Randolph | Illinois | 17157 | 5615 | 109 |
1901776 | 1901776 | 2021-11-10 | Randolph | Illinois | 17157 | 5615 | 109 |
1898526 | 1898526 | 2021-11-09 | Randolph | Illinois | 17157 | 5613 | 109 |
1895276 | 1895276 | 2021-11-08 | Randolph | Illinois | 17157 | 5611 | 109 |
1892026 | 1892026 | 2021-11-07 | Randolph | Illinois | 17157 | 5603 | 109 |
1888776 | 1888776 | 2021-11-06 | Randolph | Illinois | 17157 | 5603 | 109 |
1885526 | 1885526 | 2021-11-05 | Randolph | Illinois | 17157 | 5603 | 109 |
1882277 | 1882277 | 2021-11-04 | Randolph | Illinois | 17157 | 5602 | 109 |
1879028 | 1879028 | 2021-11-03 | Randolph | Illinois | 17157 | 5598 | 109 |
1875779 | 1875779 | 2021-11-02 | Randolph | Illinois | 17157 | 5595 | 109 |
1872530 | 1872530 | 2021-11-01 | Randolph | Illinois | 17157 | 5592 | 109 |
1869281 | 1869281 | 2021-10-31 | Randolph | Illinois | 17157 | 5585 | 108 |
1866032 | 1866032 | 2021-10-30 | Randolph | Illinois | 17157 | 5585 | 108 |
1862783 | 1862783 | 2021-10-29 | Randolph | Illinois | 17157 | 5585 | 108 |
1859534 | 1859534 | 2021-10-28 | Randolph | Illinois | 17157 | 5582 | 107 |
1856285 | 1856285 | 2021-10-27 | Randolph | Illinois | 17157 | 5580 | 107 |
1853036 | 1853036 | 2021-10-26 | Randolph | Illinois | 17157 | 5578 | 107 |
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);