ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where fips = 17175 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174884 | 2174884 | 2022-02-02 | Stark | Illinois | 17175 | 1436 | 31 |
2171631 | 2171631 | 2022-02-01 | Stark | Illinois | 17175 | 1430 | 31 |
2168378 | 2168378 | 2022-01-31 | Stark | Illinois | 17175 | 1423 | 31 |
2165123 | 2165123 | 2022-01-30 | Stark | Illinois | 17175 | 1412 | 31 |
2161868 | 2161868 | 2022-01-29 | Stark | Illinois | 17175 | 1412 | 31 |
2158613 | 2158613 | 2022-01-28 | Stark | Illinois | 17175 | 1412 | 31 |
2155359 | 2155359 | 2022-01-27 | Stark | Illinois | 17175 | 1392 | 31 |
2152106 | 2152106 | 2022-01-26 | Stark | Illinois | 17175 | 1384 | 31 |
2148854 | 2148854 | 2022-01-25 | Stark | Illinois | 17175 | 1365 | 31 |
2145602 | 2145602 | 2022-01-24 | Stark | Illinois | 17175 | 1353 | 31 |
2142347 | 2142347 | 2022-01-23 | Stark | Illinois | 17175 | 1322 | 30 |
2139092 | 2139092 | 2022-01-22 | Stark | Illinois | 17175 | 1322 | 30 |
2135836 | 2135836 | 2022-01-21 | Stark | Illinois | 17175 | 1322 | 30 |
2132584 | 2132584 | 2022-01-20 | Stark | Illinois | 17175 | 1306 | 30 |
2129331 | 2129331 | 2022-01-19 | Stark | Illinois | 17175 | 1290 | 30 |
2126077 | 2126077 | 2022-01-18 | Stark | Illinois | 17175 | 1254 | 30 |
2122825 | 2122825 | 2022-01-17 | Stark | Illinois | 17175 | 1203 | 30 |
2119573 | 2119573 | 2022-01-16 | Stark | Illinois | 17175 | 1203 | 30 |
2116321 | 2116321 | 2022-01-15 | Stark | Illinois | 17175 | 1203 | 30 |
2113070 | 2113070 | 2022-01-14 | Stark | Illinois | 17175 | 1203 | 30 |
2109818 | 2109818 | 2022-01-13 | Stark | Illinois | 17175 | 1182 | 30 |
2106567 | 2106567 | 2022-01-12 | Stark | Illinois | 17175 | 1156 | 30 |
2103316 | 2103316 | 2022-01-11 | Stark | Illinois | 17175 | 1140 | 30 |
2100065 | 2100065 | 2022-01-10 | Stark | Illinois | 17175 | 1119 | 30 |
2096814 | 2096814 | 2022-01-09 | Stark | Illinois | 17175 | 1089 | 30 |
2093562 | 2093562 | 2022-01-08 | Stark | Illinois | 17175 | 1089 | 30 |
2090310 | 2090310 | 2022-01-07 | Stark | Illinois | 17175 | 1089 | 30 |
2087059 | 2087059 | 2022-01-06 | Stark | Illinois | 17175 | 1072 | 30 |
2083807 | 2083807 | 2022-01-05 | Stark | Illinois | 17175 | 1051 | 30 |
2080555 | 2080555 | 2022-01-04 | Stark | Illinois | 17175 | 1042 | 30 |
2077303 | 2077303 | 2022-01-03 | Stark | Illinois | 17175 | 1030 | 30 |
2074052 | 2074052 | 2022-01-02 | Stark | Illinois | 17175 | 1018 | 29 |
2070801 | 2070801 | 2022-01-01 | Stark | Illinois | 17175 | 1018 | 29 |
2067550 | 2067550 | 2021-12-31 | Stark | Illinois | 17175 | 1018 | 29 |
2064299 | 2064299 | 2021-12-30 | Stark | Illinois | 17175 | 1018 | 29 |
2061049 | 2061049 | 2021-12-29 | Stark | Illinois | 17175 | 1013 | 29 |
2057800 | 2057800 | 2021-12-28 | Stark | Illinois | 17175 | 1010 | 29 |
2054551 | 2054551 | 2021-12-27 | Stark | Illinois | 17175 | 1006 | 29 |
2051301 | 2051301 | 2021-12-26 | Stark | Illinois | 17175 | 997 | 29 |
2048051 | 2048051 | 2021-12-25 | Stark | Illinois | 17175 | 997 | 29 |
2044801 | 2044801 | 2021-12-24 | Stark | Illinois | 17175 | 997 | 29 |
2041552 | 2041552 | 2021-12-23 | Stark | Illinois | 17175 | 997 | 29 |
2038302 | 2038302 | 2021-12-22 | Stark | Illinois | 17175 | 994 | 29 |
2035052 | 2035052 | 2021-12-21 | Stark | Illinois | 17175 | 992 | 29 |
2031802 | 2031802 | 2021-12-20 | Stark | Illinois | 17175 | 989 | 29 |
2028551 | 2028551 | 2021-12-19 | Stark | Illinois | 17175 | 983 | 29 |
2025300 | 2025300 | 2021-12-18 | Stark | Illinois | 17175 | 983 | 29 |
2022049 | 2022049 | 2021-12-17 | Stark | Illinois | 17175 | 983 | 29 |
2018798 | 2018798 | 2021-12-16 | Stark | Illinois | 17175 | 979 | 29 |
2015548 | 2015548 | 2021-12-15 | Stark | Illinois | 17175 | 977 | 29 |
2012297 | 2012297 | 2021-12-14 | Stark | Illinois | 17175 | 970 | 29 |
2009046 | 2009046 | 2021-12-13 | Stark | Illinois | 17175 | 964 | 29 |
2005795 | 2005795 | 2021-12-12 | Stark | Illinois | 17175 | 958 | 29 |
2002544 | 2002544 | 2021-12-11 | Stark | Illinois | 17175 | 958 | 29 |
1999294 | 1999294 | 2021-12-10 | Stark | Illinois | 17175 | 958 | 29 |
1996043 | 1996043 | 2021-12-09 | Stark | Illinois | 17175 | 956 | 29 |
1992792 | 1992792 | 2021-12-08 | Stark | Illinois | 17175 | 947 | 29 |
1989541 | 1989541 | 2021-12-07 | Stark | Illinois | 17175 | 935 | 29 |
1986291 | 1986291 | 2021-12-06 | Stark | Illinois | 17175 | 924 | 29 |
1983041 | 1983041 | 2021-12-05 | Stark | Illinois | 17175 | 912 | 29 |
1979791 | 1979791 | 2021-12-04 | Stark | Illinois | 17175 | 912 | 29 |
1976541 | 1976541 | 2021-12-03 | Stark | Illinois | 17175 | 912 | 29 |
1973292 | 1973292 | 2021-12-02 | Stark | Illinois | 17175 | 904 | 29 |
1970042 | 1970042 | 2021-12-01 | Stark | Illinois | 17175 | 896 | 29 |
1966792 | 1966792 | 2021-11-30 | Stark | Illinois | 17175 | 890 | 29 |
1963540 | 1963540 | 2021-11-29 | Stark | Illinois | 17175 | 885 | 29 |
1960289 | 1960289 | 2021-11-28 | Stark | Illinois | 17175 | 877 | 29 |
1957038 | 1957038 | 2021-11-27 | Stark | Illinois | 17175 | 877 | 29 |
1953787 | 1953787 | 2021-11-26 | Stark | Illinois | 17175 | 877 | 29 |
1950536 | 1950536 | 2021-11-25 | Stark | Illinois | 17175 | 877 | 29 |
1947285 | 1947285 | 2021-11-24 | Stark | Illinois | 17175 | 877 | 29 |
1944034 | 1944034 | 2021-11-23 | Stark | Illinois | 17175 | 874 | 29 |
1940784 | 1940784 | 2021-11-22 | Stark | Illinois | 17175 | 867 | 29 |
1937534 | 1937534 | 2021-11-21 | Stark | Illinois | 17175 | 860 | 29 |
1934284 | 1934284 | 2021-11-20 | Stark | Illinois | 17175 | 860 | 29 |
1931033 | 1931033 | 2021-11-19 | Stark | Illinois | 17175 | 860 | 29 |
1927782 | 1927782 | 2021-11-18 | Stark | Illinois | 17175 | 855 | 29 |
1924532 | 1924532 | 2021-11-17 | Stark | Illinois | 17175 | 853 | 29 |
1921283 | 1921283 | 2021-11-16 | Stark | Illinois | 17175 | 853 | 29 |
1918033 | 1918033 | 2021-11-15 | Stark | Illinois | 17175 | 850 | 29 |
1914783 | 1914783 | 2021-11-14 | Stark | Illinois | 17175 | 846 | 29 |
1911533 | 1911533 | 2021-11-13 | Stark | Illinois | 17175 | 846 | 29 |
1908284 | 1908284 | 2021-11-12 | Stark | Illinois | 17175 | 846 | 29 |
1905035 | 1905035 | 2021-11-11 | Stark | Illinois | 17175 | 841 | 29 |
1901785 | 1901785 | 2021-11-10 | Stark | Illinois | 17175 | 841 | 29 |
1898535 | 1898535 | 2021-11-09 | Stark | Illinois | 17175 | 838 | 29 |
1895285 | 1895285 | 2021-11-08 | Stark | Illinois | 17175 | 835 | 29 |
1892035 | 1892035 | 2021-11-07 | Stark | Illinois | 17175 | 835 | 29 |
1888785 | 1888785 | 2021-11-06 | Stark | Illinois | 17175 | 835 | 29 |
1885535 | 1885535 | 2021-11-05 | Stark | Illinois | 17175 | 835 | 29 |
1882286 | 1882286 | 2021-11-04 | Stark | Illinois | 17175 | 835 | 29 |
1879037 | 1879037 | 2021-11-03 | Stark | Illinois | 17175 | 833 | 28 |
1875788 | 1875788 | 2021-11-02 | Stark | Illinois | 17175 | 832 | 28 |
1872539 | 1872539 | 2021-11-01 | Stark | Illinois | 17175 | 830 | 28 |
1869290 | 1869290 | 2021-10-31 | Stark | Illinois | 17175 | 826 | 28 |
1866041 | 1866041 | 2021-10-30 | Stark | Illinois | 17175 | 826 | 28 |
1862792 | 1862792 | 2021-10-29 | Stark | Illinois | 17175 | 826 | 28 |
1859543 | 1859543 | 2021-10-28 | Stark | Illinois | 17175 | 824 | 28 |
1856294 | 1856294 | 2021-10-27 | Stark | Illinois | 17175 | 824 | 28 |
1853045 | 1853045 | 2021-10-26 | Stark | Illinois | 17175 | 821 | 28 |
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);