ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
143 rows where deaths = 116 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2399265 | 2399265 | 2022-04-12 | Iroquois | Illinois | 17075 | 7177 | 116 |
2396010 | 2396010 | 2022-04-11 | Iroquois | Illinois | 17075 | 7175 | 116 |
2392754 | 2392754 | 2022-04-10 | Iroquois | Illinois | 17075 | 7173 | 116 |
2389498 | 2389498 | 2022-04-09 | Iroquois | Illinois | 17075 | 7173 | 116 |
2386243 | 2386243 | 2022-04-08 | Iroquois | Illinois | 17075 | 7173 | 116 |
2382988 | 2382988 | 2022-04-07 | Iroquois | Illinois | 17075 | 7170 | 116 |
2379733 | 2379733 | 2022-04-06 | Iroquois | Illinois | 17075 | 7170 | 116 |
2376479 | 2376479 | 2022-04-05 | Iroquois | Illinois | 17075 | 7165 | 116 |
2373227 | 2373227 | 2022-04-04 | Iroquois | Illinois | 17075 | 7163 | 116 |
2369974 | 2369974 | 2022-04-03 | Iroquois | Illinois | 17075 | 7160 | 116 |
2366721 | 2366721 | 2022-04-02 | Iroquois | Illinois | 17075 | 7160 | 116 |
2363468 | 2363468 | 2022-04-01 | Iroquois | Illinois | 17075 | 7160 | 116 |
2360214 | 2360214 | 2022-03-31 | Iroquois | Illinois | 17075 | 7159 | 116 |
2356960 | 2356960 | 2022-03-30 | Iroquois | Illinois | 17075 | 7158 | 116 |
2353707 | 2353707 | 2022-03-29 | Iroquois | Illinois | 17075 | 7155 | 116 |
2350455 | 2350455 | 2022-03-28 | Iroquois | Illinois | 17075 | 7154 | 116 |
2278910 | 2278910 | 2022-03-06 | Lee | Illinois | 17103 | 8706 | 116 |
2275657 | 2275657 | 2022-03-05 | Lee | Illinois | 17103 | 8706 | 116 |
2272404 | 2272404 | 2022-03-04 | Lee | Illinois | 17103 | 8706 | 116 |
2269152 | 2269152 | 2022-03-03 | Lee | Illinois | 17103 | 8701 | 116 |
2265899 | 2265899 | 2022-03-02 | Lee | Illinois | 17103 | 8691 | 116 |
2262648 | 2262648 | 2022-03-01 | Lee | Illinois | 17103 | 8685 | 116 |
2259397 | 2259397 | 2022-02-28 | Lee | Illinois | 17103 | 8682 | 116 |
2256146 | 2256146 | 2022-02-27 | Lee | Illinois | 17103 | 8670 | 116 |
2252895 | 2252895 | 2022-02-26 | Lee | Illinois | 17103 | 8670 | 116 |
2249644 | 2249644 | 2022-02-25 | Lee | Illinois | 17103 | 8670 | 116 |
2246393 | 2246393 | 2022-02-24 | Lee | Illinois | 17103 | 8666 | 116 |
2243142 | 2243142 | 2022-02-23 | Lee | Illinois | 17103 | 8660 | 116 |
2236640 | 2236640 | 2022-02-21 | Lee | Illinois | 17103 | 8629 | 116 |
2233389 | 2233389 | 2022-02-20 | Lee | Illinois | 17103 | 8629 | 116 |
2230138 | 2230138 | 2022-02-19 | Lee | Illinois | 17103 | 8629 | 116 |
2226887 | 2226887 | 2022-02-18 | Lee | Illinois | 17103 | 8629 | 116 |
2223636 | 2223636 | 2022-02-17 | Lee | Illinois | 17103 | 8621 | 116 |
2220385 | 2220385 | 2022-02-16 | Lee | Illinois | 17103 | 8610 | 116 |
2210631 | 2210631 | 2022-02-13 | Lee | Illinois | 17103 | 8515 | 116 |
2207378 | 2207378 | 2022-02-12 | Lee | Illinois | 17103 | 8515 | 116 |
2204125 | 2204125 | 2022-02-11 | Lee | Illinois | 17103 | 8515 | 116 |
2200872 | 2200872 | 2022-02-10 | Lee | Illinois | 17103 | 8515 | 116 |
2178088 | 2178088 | 2022-02-03 | Jackson | Illinois | 17077 | 14732 | 116 |
2174835 | 2174835 | 2022-02-02 | Jackson | Illinois | 17077 | 14732 | 116 |
2171582 | 2171582 | 2022-02-01 | Jackson | Illinois | 17077 | 14642 | 116 |
2168329 | 2168329 | 2022-01-31 | Jackson | Illinois | 17077 | 14549 | 116 |
2165074 | 2165074 | 2022-01-30 | Jackson | Illinois | 17077 | 14344 | 116 |
2161819 | 2161819 | 2022-01-29 | Jackson | Illinois | 17077 | 14344 | 116 |
2158564 | 2158564 | 2022-01-28 | Jackson | Illinois | 17077 | 14344 | 116 |
2155310 | 2155310 | 2022-01-27 | Jackson | Illinois | 17077 | 14165 | 116 |
2152057 | 2152057 | 2022-01-26 | Jackson | Illinois | 17077 | 13999 | 116 |
2152085 | 2152085 | 2022-01-26 | Monroe | Illinois | 17133 | 8865 | 116 |
2148805 | 2148805 | 2022-01-25 | Jackson | Illinois | 17077 | 13895 | 116 |
2145553 | 2145553 | 2022-01-24 | Jackson | Illinois | 17077 | 13748 | 116 |
2051227 | 2051227 | 2021-12-26 | Clinton | Illinois | 17027 | 7976 | 116 |
2051284 | 2051284 | 2021-12-26 | Ogle | Illinois | 17141 | 9731 | 116 |
2047977 | 2047977 | 2021-12-25 | Clinton | Illinois | 17027 | 7976 | 116 |
2048034 | 2048034 | 2021-12-25 | Ogle | Illinois | 17141 | 9731 | 116 |
2044727 | 2044727 | 2021-12-24 | Clinton | Illinois | 17027 | 7976 | 116 |
2044784 | 2044784 | 2021-12-24 | Ogle | Illinois | 17141 | 9731 | 116 |
2041478 | 2041478 | 2021-12-23 | Clinton | Illinois | 17027 | 7976 | 116 |
2041535 | 2041535 | 2021-12-23 | Ogle | Illinois | 17141 | 9731 | 116 |
2038220 | 2038220 | 2021-12-22 | Bureau | Illinois | 17011 | 5450 | 116 |
2038228 | 2038228 | 2021-12-22 | Clinton | Illinois | 17027 | 7937 | 116 |
2034970 | 2034970 | 2021-12-21 | Bureau | Illinois | 17011 | 5419 | 116 |
2034978 | 2034978 | 2021-12-21 | Clinton | Illinois | 17027 | 7913 | 116 |
2031720 | 2031720 | 2021-12-20 | Bureau | Illinois | 17011 | 5392 | 116 |
2031728 | 2031728 | 2021-12-20 | Clinton | Illinois | 17027 | 7872 | 116 |
2028469 | 2028469 | 2021-12-19 | Bureau | Illinois | 17011 | 5306 | 116 |
2028477 | 2028477 | 2021-12-19 | Clinton | Illinois | 17027 | 7822 | 116 |
2028500 | 2028500 | 2021-12-19 | Henry | Illinois | 17073 | 7983 | 116 |
2025218 | 2025218 | 2021-12-18 | Bureau | Illinois | 17011 | 5306 | 116 |
2025226 | 2025226 | 2021-12-18 | Clinton | Illinois | 17027 | 7822 | 116 |
2025249 | 2025249 | 2021-12-18 | Henry | Illinois | 17073 | 7983 | 116 |
2021967 | 2021967 | 2021-12-17 | Bureau | Illinois | 17011 | 5306 | 116 |
2021975 | 2021975 | 2021-12-17 | Clinton | Illinois | 17027 | 7822 | 116 |
2021998 | 2021998 | 2021-12-17 | Henry | Illinois | 17073 | 7983 | 116 |
2018716 | 2018716 | 2021-12-16 | Bureau | Illinois | 17011 | 5283 | 116 |
2018724 | 2018724 | 2021-12-16 | Clinton | Illinois | 17027 | 7794 | 116 |
2015466 | 2015466 | 2021-12-15 | Bureau | Illinois | 17011 | 5241 | 116 |
2015474 | 2015474 | 2021-12-15 | Clinton | Illinois | 17027 | 7780 | 116 |
2012223 | 2012223 | 2021-12-14 | Clinton | Illinois | 17027 | 7756 | 116 |
2008972 | 2008972 | 2021-12-13 | Clinton | Illinois | 17027 | 7726 | 116 |
1940721 | 1940721 | 2021-11-22 | Effingham | Illinois | 17049 | 7011 | 116 |
1898536 | 1898536 | 2021-11-09 | Stephenson | Illinois | 17177 | 6284 | 116 |
1895286 | 1895286 | 2021-11-08 | Stephenson | Illinois | 17177 | 6255 | 116 |
1778273 | 1778273 | 2021-10-03 | Kendall | Illinois | 17093 | 16484 | 116 |
1775023 | 1775023 | 2021-10-02 | Kendall | Illinois | 17093 | 16484 | 116 |
1771773 | 1771773 | 2021-10-01 | Kendall | Illinois | 17093 | 16484 | 116 |
1768524 | 1768524 | 2021-09-30 | Kendall | Illinois | 17093 | 16484 | 116 |
1765275 | 1765275 | 2021-09-29 | Kendall | Illinois | 17093 | 16321 | 116 |
1762026 | 1762026 | 2021-09-28 | Kendall | Illinois | 17093 | 16321 | 116 |
1758778 | 1758778 | 2021-09-27 | Kendall | Illinois | 17093 | 16321 | 116 |
1755530 | 1755530 | 2021-09-26 | Kendall | Illinois | 17093 | 16321 | 116 |
1752282 | 1752282 | 2021-09-25 | Kendall | Illinois | 17093 | 16321 | 116 |
1749033 | 1749033 | 2021-09-24 | Kendall | Illinois | 17093 | 16321 | 116 |
1745783 | 1745783 | 2021-09-23 | Kendall | Illinois | 17093 | 16321 | 116 |
1388576 | 1388576 | 2021-06-05 | Macoupin | Illinois | 17117 | 4772 | 116 |
1385331 | 1385331 | 2021-06-04 | Macoupin | Illinois | 17117 | 4772 | 116 |
1382085 | 1382085 | 2021-06-03 | Macoupin | Illinois | 17117 | 4771 | 116 |
1378840 | 1378840 | 2021-06-02 | Macoupin | Illinois | 17117 | 4767 | 116 |
1375594 | 1375594 | 2021-06-01 | Macoupin | Illinois | 17117 | 4766 | 116 |
1372349 | 1372349 | 2021-05-31 | Macoupin | Illinois | 17117 | 4765 | 116 |
1369104 | 1369104 | 2021-05-30 | Macoupin | Illinois | 17117 | 4765 | 116 |
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);