ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
127 rows where deaths = 120 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 |
---|---|---|---|---|---|---|---|
2236592 | 2236592 | 2022-02-21 | Boone | Illinois | 17007 | 13554 | 120 |
2233341 | 2233341 | 2022-02-20 | Boone | Illinois | 17007 | 13554 | 120 |
2230090 | 2230090 | 2022-02-19 | Boone | Illinois | 17007 | 13554 | 120 |
2226839 | 2226839 | 2022-02-18 | Boone | Illinois | 17007 | 13554 | 120 |
2223588 | 2223588 | 2022-02-17 | Boone | Illinois | 17007 | 13538 | 120 |
2197605 | 2197605 | 2022-02-09 | Jackson | Illinois | 17077 | 15027 | 120 |
2197669 | 2197669 | 2022-02-09 | Woodford | Illinois | 17203 | 10097 | 120 |
2194326 | 2194326 | 2022-02-08 | Clinton | Illinois | 17027 | 11600 | 120 |
2194351 | 2194351 | 2022-02-08 | Jackson | Illinois | 17077 | 14981 | 120 |
2191072 | 2191072 | 2022-02-07 | Clinton | Illinois | 17027 | 11569 | 120 |
2191097 | 2191097 | 2022-02-07 | Jackson | Illinois | 17077 | 14918 | 120 |
2187834 | 2187834 | 2022-02-06 | Fulton | Illinois | 17057 | 9620 | 120 |
2187844 | 2187844 | 2022-02-06 | Jackson | Illinois | 17077 | 14839 | 120 |
2184581 | 2184581 | 2022-02-05 | Fulton | Illinois | 17057 | 9620 | 120 |
2184591 | 2184591 | 2022-02-05 | Jackson | Illinois | 17077 | 14839 | 120 |
2181329 | 2181329 | 2022-02-04 | Fulton | Illinois | 17057 | 9620 | 120 |
2181339 | 2181339 | 2022-02-04 | Jackson | Illinois | 17077 | 14839 | 120 |
2178116 | 2178116 | 2022-02-03 | Monroe | Illinois | 17133 | 9150 | 120 |
2178128 | 2178128 | 2022-02-03 | Randolph | Illinois | 17157 | 9927 | 120 |
2174863 | 2174863 | 2022-02-02 | Monroe | Illinois | 17133 | 9150 | 120 |
2174875 | 2174875 | 2022-02-02 | Randolph | Illinois | 17157 | 9927 | 120 |
2171610 | 2171610 | 2022-02-01 | Monroe | Illinois | 17133 | 9118 | 120 |
2155282 | 2155282 | 2022-01-27 | Christian | Illinois | 17021 | 9326 | 120 |
2152029 | 2152029 | 2022-01-26 | Christian | Illinois | 17021 | 9237 | 120 |
2148777 | 2148777 | 2022-01-25 | Christian | Illinois | 17021 | 9157 | 120 |
2145525 | 2145525 | 2022-01-24 | Christian | Illinois | 17021 | 9100 | 120 |
2073970 | 2073970 | 2022-01-02 | Bureau | Illinois | 17011 | 5716 | 120 |
2070719 | 2070719 | 2022-01-01 | Bureau | Illinois | 17011 | 5716 | 120 |
2067468 | 2067468 | 2021-12-31 | Bureau | Illinois | 17011 | 5716 | 120 |
2064217 | 2064217 | 2021-12-30 | Bureau | Illinois | 17011 | 5716 | 120 |
2060967 | 2060967 | 2021-12-29 | Bureau | Illinois | 17011 | 5661 | 120 |
2057718 | 2057718 | 2021-12-28 | Bureau | Illinois | 17011 | 5623 | 120 |
1982978 | 1982978 | 2021-12-05 | Effingham | Illinois | 17049 | 7278 | 120 |
1979728 | 1979728 | 2021-12-04 | Effingham | Illinois | 17049 | 7278 | 120 |
1976478 | 1976478 | 2021-12-03 | Effingham | Illinois | 17049 | 7278 | 120 |
1973229 | 1973229 | 2021-12-02 | Effingham | Illinois | 17049 | 7254 | 120 |
1927783 | 1927783 | 2021-11-18 | Stephenson | Illinois | 17177 | 6609 | 120 |
1924533 | 1924533 | 2021-11-17 | Stephenson | Illinois | 17177 | 6573 | 120 |
1810765 | 1810765 | 2021-10-13 | Kendall | Illinois | 17093 | 16770 | 120 |
1810787 | 1810787 | 2021-10-13 | Morgan | Illinois | 17137 | 5188 | 120 |
1807516 | 1807516 | 2021-10-12 | Kendall | Illinois | 17093 | 16770 | 120 |
1807538 | 1807538 | 2021-10-12 | Morgan | Illinois | 17137 | 5173 | 120 |
1804246 | 1804246 | 2021-10-11 | Franklin | Illinois | 17055 | 7200 | 120 |
1804287 | 1804287 | 2021-10-11 | Morgan | Illinois | 17137 | 5148 | 120 |
1800997 | 1800997 | 2021-10-10 | Franklin | Illinois | 17055 | 7200 | 120 |
1801038 | 1801038 | 2021-10-10 | Morgan | Illinois | 17137 | 5148 | 120 |
1797748 | 1797748 | 2021-10-09 | Franklin | Illinois | 17055 | 7200 | 120 |
1797789 | 1797789 | 2021-10-09 | Morgan | Illinois | 17137 | 5148 | 120 |
1794499 | 1794499 | 2021-10-08 | Franklin | Illinois | 17055 | 7200 | 120 |
1794540 | 1794540 | 2021-10-08 | Morgan | Illinois | 17137 | 5148 | 120 |
1625595 | 1625595 | 2021-08-17 | Macoupin | Illinois | 17117 | 5348 | 120 |
1622348 | 1622348 | 2021-08-16 | Macoupin | Illinois | 17117 | 5313 | 120 |
1619101 | 1619101 | 2021-08-15 | Macoupin | Illinois | 17117 | 5268 | 120 |
1615853 | 1615853 | 2021-08-14 | Macoupin | Illinois | 17117 | 5268 | 120 |
1612604 | 1612604 | 2021-08-13 | Macoupin | Illinois | 17117 | 5268 | 120 |
1609356 | 1609356 | 2021-08-12 | Macoupin | Illinois | 17117 | 5242 | 120 |
1291170 | 1291170 | 2021-05-06 | Jefferson | Illinois | 17081 | 4251 | 120 |
1287924 | 1287924 | 2021-05-05 | Jefferson | Illinois | 17081 | 4237 | 120 |
1284678 | 1284678 | 2021-05-04 | Jefferson | Illinois | 17081 | 4232 | 120 |
1281431 | 1281431 | 2021-05-03 | Jefferson | Illinois | 17081 | 4228 | 120 |
1278184 | 1278184 | 2021-05-02 | Jefferson | Illinois | 17081 | 4228 | 120 |
1274937 | 1274937 | 2021-05-01 | Jefferson | Illinois | 17081 | 4222 | 120 |
1271690 | 1271690 | 2021-04-30 | Jefferson | Illinois | 17081 | 4214 | 120 |
1268443 | 1268443 | 2021-04-29 | Jefferson | Illinois | 17081 | 4211 | 120 |
1265196 | 1265196 | 2021-04-28 | Jefferson | Illinois | 17081 | 4205 | 120 |
1261949 | 1261949 | 2021-04-27 | Jefferson | Illinois | 17081 | 4201 | 120 |
1258702 | 1258702 | 2021-04-26 | Jefferson | Illinois | 17081 | 4195 | 120 |
1255455 | 1255455 | 2021-04-25 | Jefferson | Illinois | 17081 | 4195 | 120 |
1252208 | 1252208 | 2021-04-24 | Jefferson | Illinois | 17081 | 4188 | 120 |
1248961 | 1248961 | 2021-04-23 | Jefferson | Illinois | 17081 | 4181 | 120 |
1245714 | 1245714 | 2021-04-22 | Jefferson | Illinois | 17081 | 4174 | 120 |
1242467 | 1242467 | 2021-04-21 | Jefferson | Illinois | 17081 | 4167 | 120 |
1239220 | 1239220 | 2021-04-20 | Jefferson | Illinois | 17081 | 4163 | 120 |
1235973 | 1235973 | 2021-04-19 | Jefferson | Illinois | 17081 | 4158 | 120 |
1232726 | 1232726 | 2021-04-18 | Jefferson | Illinois | 17081 | 4158 | 120 |
1229477 | 1229477 | 2021-04-17 | Jefferson | Illinois | 17081 | 4153 | 120 |
1226229 | 1226229 | 2021-04-16 | Jefferson | Illinois | 17081 | 4143 | 120 |
1226246 | 1226246 | 2021-04-16 | Marion | Illinois | 17121 | 4404 | 120 |
1222999 | 1222999 | 2021-04-15 | Marion | Illinois | 17121 | 4381 | 120 |
1219751 | 1219751 | 2021-04-14 | Marion | Illinois | 17121 | 4379 | 120 |
1216503 | 1216503 | 2021-04-13 | Marion | Illinois | 17121 | 4377 | 120 |
1213256 | 1213256 | 2021-04-12 | Marion | Illinois | 17121 | 4374 | 120 |
1210008 | 1210008 | 2021-04-11 | Marion | Illinois | 17121 | 4373 | 120 |
1206759 | 1206759 | 2021-04-10 | Marion | Illinois | 17121 | 4372 | 120 |
1203511 | 1203511 | 2021-04-09 | Marion | Illinois | 17121 | 4369 | 120 |
1200263 | 1200263 | 2021-04-08 | Marion | Illinois | 17121 | 4367 | 120 |
1197014 | 1197014 | 2021-04-07 | Marion | Illinois | 17121 | 4365 | 120 |
1177528 | 1177528 | 2021-04-01 | Marion | Illinois | 17121 | 4365 | 120 |
1174281 | 1174281 | 2021-03-31 | Marion | Illinois | 17121 | 4364 | 120 |
1171034 | 1171034 | 2021-03-30 | Marion | Illinois | 17121 | 4359 | 120 |
1167786 | 1167786 | 2021-03-29 | Marion | Illinois | 17121 | 4355 | 120 |
1164538 | 1164538 | 2021-03-28 | Marion | Illinois | 17121 | 4354 | 120 |
1161290 | 1161290 | 2021-03-27 | Marion | Illinois | 17121 | 4351 | 120 |
1158042 | 1158042 | 2021-03-26 | Marion | Illinois | 17121 | 4347 | 120 |
1154795 | 1154795 | 2021-03-25 | Marion | Illinois | 17121 | 4347 | 120 |
1141769 | 1141769 | 2021-03-21 | DeKalb | Illinois | 17037 | 8662 | 120 |
1138523 | 1138523 | 2021-03-20 | DeKalb | Illinois | 17037 | 8662 | 120 |
1135277 | 1135277 | 2021-03-19 | DeKalb | Illinois | 17037 | 8662 | 120 |
1132030 | 1132030 | 2021-03-18 | DeKalb | Illinois | 17037 | 8652 | 120 |
1128782 | 1128782 | 2021-03-17 | DeKalb | Illinois | 17037 | 8639 | 120 |
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);