ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Kane" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174841 | 2174841 | 2022-02-02 | Kane | Illinois | 17089 | 119863 | 1093 |
2171588 | 2171588 | 2022-02-01 | Kane | Illinois | 17089 | 119562 | 1086 |
2168335 | 2168335 | 2022-01-31 | Kane | Illinois | 17089 | 119128 | 1084 |
2165080 | 2165080 | 2022-01-30 | Kane | Illinois | 17089 | 118100 | 1078 |
2161825 | 2161825 | 2022-01-29 | Kane | Illinois | 17089 | 118100 | 1078 |
2158570 | 2158570 | 2022-01-28 | Kane | Illinois | 17089 | 118100 | 1078 |
2155316 | 2155316 | 2022-01-27 | Kane | Illinois | 17089 | 117562 | 1074 |
2152063 | 2152063 | 2022-01-26 | Kane | Illinois | 17089 | 117042 | 1072 |
2148811 | 2148811 | 2022-01-25 | Kane | Illinois | 17089 | 116516 | 1068 |
2145559 | 2145559 | 2022-01-24 | Kane | Illinois | 17089 | 116009 | 1064 |
2142304 | 2142304 | 2022-01-23 | Kane | Illinois | 17089 | 111479 | 1052 |
2139049 | 2139049 | 2022-01-22 | Kane | Illinois | 17089 | 111479 | 1052 |
2135793 | 2135793 | 2022-01-21 | Kane | Illinois | 17089 | 111479 | 1052 |
2132541 | 2132541 | 2022-01-20 | Kane | Illinois | 17089 | 109013 | 1047 |
2129288 | 2129288 | 2022-01-19 | Kane | Illinois | 17089 | 108243 | 1044 |
2126034 | 2126034 | 2022-01-18 | Kane | Illinois | 17089 | 107382 | 1041 |
2122782 | 2122782 | 2022-01-17 | Kane | Illinois | 17089 | 103086 | 1036 |
2119530 | 2119530 | 2022-01-16 | Kane | Illinois | 17089 | 103086 | 1036 |
2116278 | 2116278 | 2022-01-15 | Kane | Illinois | 17089 | 103086 | 1036 |
2113027 | 2113027 | 2022-01-14 | Kane | Illinois | 17089 | 103086 | 1036 |
2109775 | 2109775 | 2022-01-13 | Kane | Illinois | 17089 | 101893 | 1032 |
2106524 | 2106524 | 2022-01-12 | Kane | Illinois | 17089 | 100702 | 1025 |
2103273 | 2103273 | 2022-01-11 | Kane | Illinois | 17089 | 99335 | 1022 |
2100022 | 2100022 | 2022-01-10 | Kane | Illinois | 17089 | 98216 | 1020 |
2096771 | 2096771 | 2022-01-09 | Kane | Illinois | 17089 | 95298 | 1011 |
2093519 | 2093519 | 2022-01-08 | Kane | Illinois | 17089 | 95298 | 1011 |
2090267 | 2090267 | 2022-01-07 | Kane | Illinois | 17089 | 95298 | 1011 |
2087016 | 2087016 | 2022-01-06 | Kane | Illinois | 17089 | 93750 | 1008 |
2083764 | 2083764 | 2022-01-05 | Kane | Illinois | 17089 | 91844 | 1006 |
2080512 | 2080512 | 2022-01-04 | Kane | Illinois | 17089 | 90653 | 1002 |
2077260 | 2077260 | 2022-01-03 | Kane | Illinois | 17089 | 89682 | 1002 |
2074009 | 2074009 | 2022-01-02 | Kane | Illinois | 17089 | 86289 | 1000 |
2070758 | 2070758 | 2022-01-01 | Kane | Illinois | 17089 | 86289 | 1000 |
2067507 | 2067507 | 2021-12-31 | Kane | Illinois | 17089 | 86289 | 1000 |
2064256 | 2064256 | 2021-12-30 | Kane | Illinois | 17089 | 86289 | 1000 |
2061006 | 2061006 | 2021-12-29 | Kane | Illinois | 17089 | 85159 | 997 |
2057757 | 2057757 | 2021-12-28 | Kane | Illinois | 17089 | 84314 | 997 |
2054508 | 2054508 | 2021-12-27 | Kane | Illinois | 17089 | 83466 | 995 |
2051258 | 2051258 | 2021-12-26 | Kane | Illinois | 17089 | 81467 | 993 |
2048008 | 2048008 | 2021-12-25 | Kane | Illinois | 17089 | 81467 | 993 |
2044758 | 2044758 | 2021-12-24 | Kane | Illinois | 17089 | 81467 | 993 |
2041509 | 2041509 | 2021-12-23 | Kane | Illinois | 17089 | 81467 | 993 |
2038259 | 2038259 | 2021-12-22 | Kane | Illinois | 17089 | 80744 | 990 |
2035009 | 2035009 | 2021-12-21 | Kane | Illinois | 17089 | 80132 | 988 |
2031759 | 2031759 | 2021-12-20 | Kane | Illinois | 17089 | 79823 | 987 |
2028508 | 2028508 | 2021-12-19 | Kane | Illinois | 17089 | 78713 | 982 |
2025257 | 2025257 | 2021-12-18 | Kane | Illinois | 17089 | 78713 | 982 |
2022006 | 2022006 | 2021-12-17 | Kane | Illinois | 17089 | 78713 | 982 |
2018755 | 2018755 | 2021-12-16 | Kane | Illinois | 17089 | 78353 | 981 |
2015505 | 2015505 | 2021-12-15 | Kane | Illinois | 17089 | 77932 | 978 |
2012254 | 2012254 | 2021-12-14 | Kane | Illinois | 17089 | 77566 | 977 |
2009003 | 2009003 | 2021-12-13 | Kane | Illinois | 17089 | 77279 | 974 |
2005752 | 2005752 | 2021-12-12 | Kane | Illinois | 17089 | 76493 | 966 |
2002501 | 2002501 | 2021-12-11 | Kane | Illinois | 17089 | 76493 | 966 |
1999251 | 1999251 | 2021-12-10 | Kane | Illinois | 17089 | 76493 | 966 |
1996000 | 1996000 | 2021-12-09 | Kane | Illinois | 17089 | 76226 | 963 |
1992749 | 1992749 | 2021-12-08 | Kane | Illinois | 17089 | 75827 | 960 |
1989498 | 1989498 | 2021-12-07 | Kane | Illinois | 17089 | 75597 | 960 |
1986248 | 1986248 | 2021-12-06 | Kane | Illinois | 17089 | 75354 | 958 |
1982998 | 1982998 | 2021-12-05 | Kane | Illinois | 17089 | 74539 | 956 |
1979748 | 1979748 | 2021-12-04 | Kane | Illinois | 17089 | 74539 | 956 |
1976498 | 1976498 | 2021-12-03 | Kane | Illinois | 17089 | 74539 | 956 |
1973249 | 1973249 | 2021-12-02 | Kane | Illinois | 17089 | 74238 | 954 |
1969999 | 1969999 | 2021-12-01 | Kane | Illinois | 17089 | 73777 | 953 |
1966749 | 1966749 | 2021-11-30 | Kane | Illinois | 17089 | 73556 | 953 |
1963497 | 1963497 | 2021-11-29 | Kane | Illinois | 17089 | 73338 | 953 |
1960246 | 1960246 | 2021-11-28 | Kane | Illinois | 17089 | 72551 | 950 |
1956995 | 1956995 | 2021-11-27 | Kane | Illinois | 17089 | 72551 | 950 |
1953744 | 1953744 | 2021-11-26 | Kane | Illinois | 17089 | 72551 | 950 |
1950493 | 1950493 | 2021-11-25 | Kane | Illinois | 17089 | 72551 | 950 |
1947242 | 1947242 | 2021-11-24 | Kane | Illinois | 17089 | 72551 | 950 |
1943991 | 1943991 | 2021-11-23 | Kane | Illinois | 17089 | 72344 | 950 |
1940741 | 1940741 | 2021-11-22 | Kane | Illinois | 17089 | 72169 | 950 |
1937491 | 1937491 | 2021-11-21 | Kane | Illinois | 17089 | 71661 | 948 |
1934241 | 1934241 | 2021-11-20 | Kane | Illinois | 17089 | 71661 | 948 |
1930990 | 1930990 | 2021-11-19 | Kane | Illinois | 17089 | 71661 | 948 |
1927739 | 1927739 | 2021-11-18 | Kane | Illinois | 17089 | 71425 | 948 |
1924489 | 1924489 | 2021-11-17 | Kane | Illinois | 17089 | 71207 | 948 |
1921240 | 1921240 | 2021-11-16 | Kane | Illinois | 17089 | 70975 | 948 |
1917990 | 1917990 | 2021-11-15 | Kane | Illinois | 17089 | 70856 | 948 |
1914740 | 1914740 | 2021-11-14 | Kane | Illinois | 17089 | 70510 | 948 |
1911490 | 1911490 | 2021-11-13 | Kane | Illinois | 17089 | 70510 | 948 |
1908241 | 1908241 | 2021-11-12 | Kane | Illinois | 17089 | 70510 | 948 |
1904992 | 1904992 | 2021-11-11 | Kane | Illinois | 17089 | 70234 | 944 |
1901742 | 1901742 | 2021-11-10 | Kane | Illinois | 17089 | 70234 | 944 |
1898492 | 1898492 | 2021-11-09 | Kane | Illinois | 17089 | 70049 | 943 |
1895242 | 1895242 | 2021-11-08 | Kane | Illinois | 17089 | 69984 | 943 |
1891992 | 1891992 | 2021-11-07 | Kane | Illinois | 17089 | 69766 | 940 |
1888742 | 1888742 | 2021-11-06 | Kane | Illinois | 17089 | 69766 | 940 |
1885492 | 1885492 | 2021-11-05 | Kane | Illinois | 17089 | 69766 | 940 |
1882243 | 1882243 | 2021-11-04 | Kane | Illinois | 17089 | 69626 | 940 |
1878994 | 1878994 | 2021-11-03 | Kane | Illinois | 17089 | 69488 | 940 |
1875745 | 1875745 | 2021-11-02 | Kane | Illinois | 17089 | 69437 | 940 |
1872496 | 1872496 | 2021-11-01 | Kane | Illinois | 17089 | 69350 | 939 |
1869247 | 1869247 | 2021-10-31 | Kane | Illinois | 17089 | 69139 | 937 |
1865998 | 1865998 | 2021-10-30 | Kane | Illinois | 17089 | 69139 | 937 |
1862749 | 1862749 | 2021-10-29 | Kane | Illinois | 17089 | 69139 | 937 |
1859500 | 1859500 | 2021-10-28 | Kane | Illinois | 17089 | 69040 | 935 |
1856251 | 1856251 | 2021-10-27 | Kane | Illinois | 17089 | 68965 | 933 |
1853002 | 1853002 | 2021-10-26 | Kane | Illinois | 17089 | 68883 | 932 |
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);