ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
94 rows where deaths = 34, fips = 17005 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2210582 | 2210582 | 2022-02-13 | Bond | Illinois | 17005 | 4245 | 34 |
2207329 | 2207329 | 2022-02-12 | Bond | Illinois | 17005 | 4245 | 34 |
2204076 | 2204076 | 2022-02-11 | Bond | Illinois | 17005 | 4245 | 34 |
2200823 | 2200823 | 2022-02-10 | Bond | Illinois | 17005 | 4245 | 34 |
2197569 | 2197569 | 2022-02-09 | Bond | Illinois | 17005 | 4241 | 34 |
2194315 | 2194315 | 2022-02-08 | Bond | Illinois | 17005 | 4226 | 34 |
2191061 | 2191061 | 2022-02-07 | Bond | Illinois | 17005 | 4212 | 34 |
2187808 | 2187808 | 2022-02-06 | Bond | Illinois | 17005 | 4196 | 34 |
2184555 | 2184555 | 2022-02-05 | Bond | Illinois | 17005 | 4196 | 34 |
2181303 | 2181303 | 2022-02-04 | Bond | Illinois | 17005 | 4196 | 34 |
2178052 | 2178052 | 2022-02-03 | Bond | Illinois | 17005 | 4162 | 34 |
2174799 | 2174799 | 2022-02-02 | Bond | Illinois | 17005 | 4162 | 34 |
2171546 | 2171546 | 2022-02-01 | Bond | Illinois | 17005 | 4155 | 34 |
2168293 | 2168293 | 2022-01-31 | Bond | Illinois | 17005 | 4129 | 34 |
2165038 | 2165038 | 2022-01-30 | Bond | Illinois | 17005 | 4097 | 34 |
2161783 | 2161783 | 2022-01-29 | Bond | Illinois | 17005 | 4097 | 34 |
2158528 | 2158528 | 2022-01-28 | Bond | Illinois | 17005 | 4097 | 34 |
2155274 | 2155274 | 2022-01-27 | Bond | Illinois | 17005 | 4072 | 34 |
2152021 | 2152021 | 2022-01-26 | Bond | Illinois | 17005 | 4048 | 34 |
2148769 | 2148769 | 2022-01-25 | Bond | Illinois | 17005 | 4020 | 34 |
2145517 | 2145517 | 2022-01-24 | Bond | Illinois | 17005 | 3964 | 34 |
2142262 | 2142262 | 2022-01-23 | Bond | Illinois | 17005 | 3900 | 34 |
2139007 | 2139007 | 2022-01-22 | Bond | Illinois | 17005 | 3900 | 34 |
2135751 | 2135751 | 2022-01-21 | Bond | Illinois | 17005 | 3900 | 34 |
2132499 | 2132499 | 2022-01-20 | Bond | Illinois | 17005 | 3868 | 34 |
2129246 | 2129246 | 2022-01-19 | Bond | Illinois | 17005 | 3836 | 34 |
2125992 | 2125992 | 2022-01-18 | Bond | Illinois | 17005 | 3741 | 34 |
2122740 | 2122740 | 2022-01-17 | Bond | Illinois | 17005 | 3630 | 34 |
2119488 | 2119488 | 2022-01-16 | Bond | Illinois | 17005 | 3630 | 34 |
2116236 | 2116236 | 2022-01-15 | Bond | Illinois | 17005 | 3630 | 34 |
2112985 | 2112985 | 2022-01-14 | Bond | Illinois | 17005 | 3630 | 34 |
2109733 | 2109733 | 2022-01-13 | Bond | Illinois | 17005 | 3549 | 34 |
2106482 | 2106482 | 2022-01-12 | Bond | Illinois | 17005 | 3498 | 34 |
2103231 | 2103231 | 2022-01-11 | Bond | Illinois | 17005 | 3401 | 34 |
2099980 | 2099980 | 2022-01-10 | Bond | Illinois | 17005 | 3346 | 34 |
2096729 | 2096729 | 2022-01-09 | Bond | Illinois | 17005 | 3294 | 34 |
2093477 | 2093477 | 2022-01-08 | Bond | Illinois | 17005 | 3294 | 34 |
2090225 | 2090225 | 2022-01-07 | Bond | Illinois | 17005 | 3294 | 34 |
2086974 | 2086974 | 2022-01-06 | Bond | Illinois | 17005 | 3255 | 34 |
2083722 | 2083722 | 2022-01-05 | Bond | Illinois | 17005 | 3181 | 34 |
2080470 | 2080470 | 2022-01-04 | Bond | Illinois | 17005 | 3122 | 34 |
2077218 | 2077218 | 2022-01-03 | Bond | Illinois | 17005 | 3103 | 34 |
2073967 | 2073967 | 2022-01-02 | Bond | Illinois | 17005 | 3049 | 34 |
2070716 | 2070716 | 2022-01-01 | Bond | Illinois | 17005 | 3049 | 34 |
2067465 | 2067465 | 2021-12-31 | Bond | Illinois | 17005 | 3049 | 34 |
2064214 | 2064214 | 2021-12-30 | Bond | Illinois | 17005 | 3049 | 34 |
2060964 | 2060964 | 2021-12-29 | Bond | Illinois | 17005 | 3021 | 34 |
2057715 | 2057715 | 2021-12-28 | Bond | Illinois | 17005 | 3005 | 34 |
2054466 | 2054466 | 2021-12-27 | Bond | Illinois | 17005 | 2985 | 34 |
2051216 | 2051216 | 2021-12-26 | Bond | Illinois | 17005 | 2964 | 34 |
2047966 | 2047966 | 2021-12-25 | Bond | Illinois | 17005 | 2964 | 34 |
2044716 | 2044716 | 2021-12-24 | Bond | Illinois | 17005 | 2964 | 34 |
2041467 | 2041467 | 2021-12-23 | Bond | Illinois | 17005 | 2964 | 34 |
2038217 | 2038217 | 2021-12-22 | Bond | Illinois | 17005 | 2957 | 34 |
2034967 | 2034967 | 2021-12-21 | Bond | Illinois | 17005 | 2943 | 34 |
2031717 | 2031717 | 2021-12-20 | Bond | Illinois | 17005 | 2924 | 34 |
2028466 | 2028466 | 2021-12-19 | Bond | Illinois | 17005 | 2913 | 34 |
2025215 | 2025215 | 2021-12-18 | Bond | Illinois | 17005 | 2913 | 34 |
2021964 | 2021964 | 2021-12-17 | Bond | Illinois | 17005 | 2913 | 34 |
2018713 | 2018713 | 2021-12-16 | Bond | Illinois | 17005 | 2906 | 34 |
2015463 | 2015463 | 2021-12-15 | Bond | Illinois | 17005 | 2889 | 34 |
2012212 | 2012212 | 2021-12-14 | Bond | Illinois | 17005 | 2876 | 34 |
2008961 | 2008961 | 2021-12-13 | Bond | Illinois | 17005 | 2866 | 34 |
2005710 | 2005710 | 2021-12-12 | Bond | Illinois | 17005 | 2849 | 34 |
2002459 | 2002459 | 2021-12-11 | Bond | Illinois | 17005 | 2849 | 34 |
1999209 | 1999209 | 2021-12-10 | Bond | Illinois | 17005 | 2849 | 34 |
1995958 | 1995958 | 2021-12-09 | Bond | Illinois | 17005 | 2833 | 34 |
1992707 | 1992707 | 2021-12-08 | Bond | Illinois | 17005 | 2822 | 34 |
1989456 | 1989456 | 2021-12-07 | Bond | Illinois | 17005 | 2809 | 34 |
1986206 | 1986206 | 2021-12-06 | Bond | Illinois | 17005 | 2796 | 34 |
1982956 | 1982956 | 2021-12-05 | Bond | Illinois | 17005 | 2778 | 34 |
1979706 | 1979706 | 2021-12-04 | Bond | Illinois | 17005 | 2778 | 34 |
1976456 | 1976456 | 2021-12-03 | Bond | Illinois | 17005 | 2778 | 34 |
1973207 | 1973207 | 2021-12-02 | Bond | Illinois | 17005 | 2769 | 34 |
1969957 | 1969957 | 2021-12-01 | Bond | Illinois | 17005 | 2742 | 34 |
1966707 | 1966707 | 2021-11-30 | Bond | Illinois | 17005 | 2730 | 34 |
1963455 | 1963455 | 2021-11-29 | Bond | Illinois | 17005 | 2718 | 34 |
1960204 | 1960204 | 2021-11-28 | Bond | Illinois | 17005 | 2698 | 34 |
1956953 | 1956953 | 2021-11-27 | Bond | Illinois | 17005 | 2698 | 34 |
1953702 | 1953702 | 2021-11-26 | Bond | Illinois | 17005 | 2698 | 34 |
1950451 | 1950451 | 2021-11-25 | Bond | Illinois | 17005 | 2698 | 34 |
1947200 | 1947200 | 2021-11-24 | Bond | Illinois | 17005 | 2698 | 34 |
1943949 | 1943949 | 2021-11-23 | Bond | Illinois | 17005 | 2694 | 34 |
1940699 | 1940699 | 2021-11-22 | Bond | Illinois | 17005 | 2690 | 34 |
1937449 | 1937449 | 2021-11-21 | Bond | Illinois | 17005 | 2688 | 34 |
1934199 | 1934199 | 2021-11-20 | Bond | Illinois | 17005 | 2688 | 34 |
1930948 | 1930948 | 2021-11-19 | Bond | Illinois | 17005 | 2688 | 34 |
1927697 | 1927697 | 2021-11-18 | Bond | Illinois | 17005 | 2681 | 34 |
1924447 | 1924447 | 2021-11-17 | Bond | Illinois | 17005 | 2670 | 34 |
1921198 | 1921198 | 2021-11-16 | Bond | Illinois | 17005 | 2664 | 34 |
1917948 | 1917948 | 2021-11-15 | Bond | Illinois | 17005 | 2655 | 34 |
1914698 | 1914698 | 2021-11-14 | Bond | Illinois | 17005 | 2645 | 34 |
1911448 | 1911448 | 2021-11-13 | Bond | Illinois | 17005 | 2645 | 34 |
1908199 | 1908199 | 2021-11-12 | Bond | Illinois | 17005 | 2645 | 34 |
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);