ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
255 rows where deaths = 92 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Ogle 77
- Boone 28
- Henry 26
- Lee 19
- Bureau 14
- Iroquois 9
- DeKalb 7
- Coles 6
- Fulton 6
- Livingston 6
- Champaign 5
- McDonough 5
- Stephenson 5
- Christian 4
- Fayette 4
- Peoria 4
- Grundy 3
- Kendall 3
- Macoupin 3
- Effingham 2
- Monroe 2
- Randolph 2
- Saline 2
- Vermilion 2
- Clinton 1
- Knox 1
- Madison 1
- Marion 1
- McHenry 1
- Morgan 1
- …
state 1
- Illinois · 255 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2187867 | 2187867 | 2022-02-06 | McDonough | Illinois | 17109 | 6795 | 92 |
2184614 | 2184614 | 2022-02-05 | McDonough | Illinois | 17109 | 6795 | 92 |
2181362 | 2181362 | 2022-02-04 | McDonough | Illinois | 17109 | 6795 | 92 |
2178075 | 2178075 | 2022-02-03 | Fayette | Illinois | 17051 | 6834 | 92 |
2178111 | 2178111 | 2022-02-03 | McDonough | Illinois | 17109 | 6743 | 92 |
2174822 | 2174822 | 2022-02-02 | Fayette | Illinois | 17051 | 6834 | 92 |
2174858 | 2174858 | 2022-02-02 | McDonough | Illinois | 17109 | 6743 | 92 |
2171569 | 2171569 | 2022-02-01 | Fayette | Illinois | 17051 | 6809 | 92 |
2168316 | 2168316 | 2022-01-31 | Fayette | Illinois | 17051 | 6780 | 92 |
2080505 | 2080505 | 2022-01-04 | Iroquois | Illinois | 17075 | 5605 | 92 |
2080549 | 2080549 | 2022-01-04 | Saline | Illinois | 17165 | 5194 | 92 |
2077253 | 2077253 | 2022-01-03 | Iroquois | Illinois | 17075 | 5540 | 92 |
2077297 | 2077297 | 2022-01-03 | Saline | Illinois | 17165 | 5126 | 92 |
2074002 | 2074002 | 2022-01-02 | Iroquois | Illinois | 17075 | 5420 | 92 |
2070751 | 2070751 | 2022-01-01 | Iroquois | Illinois | 17075 | 5420 | 92 |
2067500 | 2067500 | 2021-12-31 | Iroquois | Illinois | 17075 | 5420 | 92 |
2064249 | 2064249 | 2021-12-30 | Iroquois | Illinois | 17075 | 5420 | 92 |
2060999 | 2060999 | 2021-12-29 | Iroquois | Illinois | 17075 | 5372 | 92 |
2057750 | 2057750 | 2021-12-28 | Iroquois | Illinois | 17075 | 5339 | 92 |
2054501 | 2054501 | 2021-12-27 | Iroquois | Illinois | 17075 | 5308 | 92 |
1914724 | 1914724 | 2021-11-14 | Fulton | Illinois | 17057 | 5420 | 92 |
1911474 | 1911474 | 2021-11-13 | Fulton | Illinois | 17057 | 5420 | 92 |
1908225 | 1908225 | 2021-11-12 | Fulton | Illinois | 17057 | 5420 | 92 |
1904976 | 1904976 | 2021-11-11 | Fulton | Illinois | 17057 | 5403 | 92 |
1901726 | 1901726 | 2021-11-10 | Fulton | Illinois | 17057 | 5403 | 92 |
1898476 | 1898476 | 2021-11-09 | Fulton | Illinois | 17057 | 5389 | 92 |
1878981 | 1878981 | 2021-11-03 | Grundy | Illinois | 17063 | 7538 | 92 |
1875732 | 1875732 | 2021-11-02 | Grundy | Illinois | 17063 | 7524 | 92 |
1872483 | 1872483 | 2021-11-01 | Grundy | Illinois | 17063 | 7506 | 92 |
1739263 | 1739263 | 2021-09-21 | Effingham | Illinois | 17049 | 6010 | 92 |
1736014 | 1736014 | 2021-09-20 | Effingham | Illinois | 17049 | 5965 | 92 |
1700326 | 1700326 | 2021-09-09 | Ogle | Illinois | 17141 | 6880 | 92 |
1697077 | 1697077 | 2021-09-08 | Ogle | Illinois | 17141 | 6830 | 92 |
1693829 | 1693829 | 2021-09-07 | Ogle | Illinois | 17141 | 6810 | 92 |
1690580 | 1690580 | 2021-09-06 | Ogle | Illinois | 17141 | 6747 | 92 |
1687330 | 1687330 | 2021-09-05 | Ogle | Illinois | 17141 | 6747 | 92 |
1684080 | 1684080 | 2021-09-04 | Ogle | Illinois | 17141 | 6747 | 92 |
1680829 | 1680829 | 2021-09-03 | Ogle | Illinois | 17141 | 6747 | 92 |
1677581 | 1677581 | 2021-09-02 | Ogle | Illinois | 17141 | 6713 | 92 |
1674334 | 1674334 | 2021-09-01 | Ogle | Illinois | 17141 | 6686 | 92 |
1671085 | 1671085 | 2021-08-31 | Ogle | Illinois | 17141 | 6658 | 92 |
1667838 | 1667838 | 2021-08-30 | Ogle | Illinois | 17141 | 6641 | 92 |
1664591 | 1664591 | 2021-08-29 | Ogle | Illinois | 17141 | 6598 | 92 |
1661343 | 1661343 | 2021-08-28 | Ogle | Illinois | 17141 | 6598 | 92 |
1658095 | 1658095 | 2021-08-27 | Ogle | Illinois | 17141 | 6598 | 92 |
1654847 | 1654847 | 2021-08-26 | Ogle | Illinois | 17141 | 6579 | 92 |
1651600 | 1651600 | 2021-08-25 | Ogle | Illinois | 17141 | 6557 | 92 |
1648351 | 1648351 | 2021-08-24 | Ogle | Illinois | 17141 | 6543 | 92 |
1645103 | 1645103 | 2021-08-23 | Ogle | Illinois | 17141 | 6523 | 92 |
1641854 | 1641854 | 2021-08-22 | Ogle | Illinois | 17141 | 6507 | 92 |
1638604 | 1638604 | 2021-08-21 | Ogle | Illinois | 17141 | 6507 | 92 |
1635354 | 1635354 | 2021-08-20 | Ogle | Illinois | 17141 | 6507 | 92 |
1632104 | 1632104 | 2021-08-19 | Ogle | Illinois | 17141 | 6489 | 92 |
1628857 | 1628857 | 2021-08-18 | Ogle | Illinois | 17141 | 6476 | 92 |
1625610 | 1625610 | 2021-08-17 | Ogle | Illinois | 17141 | 6456 | 92 |
1622363 | 1622363 | 2021-08-16 | Ogle | Illinois | 17141 | 6439 | 92 |
1619116 | 1619116 | 2021-08-15 | Ogle | Illinois | 17141 | 6402 | 92 |
1615868 | 1615868 | 2021-08-14 | Ogle | Illinois | 17141 | 6402 | 92 |
1612619 | 1612619 | 2021-08-13 | Ogle | Illinois | 17141 | 6402 | 92 |
1609371 | 1609371 | 2021-08-12 | Ogle | Illinois | 17141 | 6394 | 92 |
1606122 | 1606122 | 2021-08-11 | Ogle | Illinois | 17141 | 6380 | 92 |
1602873 | 1602873 | 2021-08-10 | Ogle | Illinois | 17141 | 6375 | 92 |
1599624 | 1599624 | 2021-08-09 | Ogle | Illinois | 17141 | 6367 | 92 |
1596309 | 1596309 | 2021-08-08 | Boone | Illinois | 17007 | 7018 | 92 |
1596376 | 1596376 | 2021-08-08 | Ogle | Illinois | 17141 | 6349 | 92 |
1593060 | 1593060 | 2021-08-07 | Boone | Illinois | 17007 | 7018 | 92 |
1593127 | 1593127 | 2021-08-07 | Ogle | Illinois | 17141 | 6349 | 92 |
1589811 | 1589811 | 2021-08-06 | Boone | Illinois | 17007 | 7018 | 92 |
1589878 | 1589878 | 2021-08-06 | Ogle | Illinois | 17141 | 6349 | 92 |
1586562 | 1586562 | 2021-08-05 | Boone | Illinois | 17007 | 7004 | 92 |
1586629 | 1586629 | 2021-08-05 | Ogle | Illinois | 17141 | 6344 | 92 |
1583312 | 1583312 | 2021-08-04 | Boone | Illinois | 17007 | 6991 | 92 |
1583379 | 1583379 | 2021-08-04 | Ogle | Illinois | 17141 | 6335 | 92 |
1580062 | 1580062 | 2021-08-03 | Boone | Illinois | 17007 | 6985 | 92 |
1580129 | 1580129 | 2021-08-03 | Ogle | Illinois | 17141 | 6333 | 92 |
1576813 | 1576813 | 2021-08-02 | Boone | Illinois | 17007 | 6973 | 92 |
1576880 | 1576880 | 2021-08-02 | Ogle | Illinois | 17141 | 6325 | 92 |
1573565 | 1573565 | 2021-08-01 | Boone | Illinois | 17007 | 6965 | 92 |
1573632 | 1573632 | 2021-08-01 | Ogle | Illinois | 17141 | 6305 | 92 |
1570317 | 1570317 | 2021-07-31 | Boone | Illinois | 17007 | 6965 | 92 |
1570384 | 1570384 | 2021-07-31 | Ogle | Illinois | 17141 | 6305 | 92 |
1567069 | 1567069 | 2021-07-30 | Boone | Illinois | 17007 | 6965 | 92 |
1567136 | 1567136 | 2021-07-30 | Ogle | Illinois | 17141 | 6305 | 92 |
1563821 | 1563821 | 2021-07-29 | Boone | Illinois | 17007 | 6947 | 92 |
1563888 | 1563888 | 2021-07-29 | Ogle | Illinois | 17141 | 6300 | 92 |
1560573 | 1560573 | 2021-07-28 | Boone | Illinois | 17007 | 6942 | 92 |
1560640 | 1560640 | 2021-07-28 | Ogle | Illinois | 17141 | 6298 | 92 |
1557326 | 1557326 | 2021-07-27 | Boone | Illinois | 17007 | 6933 | 92 |
1557393 | 1557393 | 2021-07-27 | Ogle | Illinois | 17141 | 6291 | 92 |
1554079 | 1554079 | 2021-07-26 | Boone | Illinois | 17007 | 6926 | 92 |
1554146 | 1554146 | 2021-07-26 | Ogle | Illinois | 17141 | 6285 | 92 |
1550832 | 1550832 | 2021-07-25 | Boone | Illinois | 17007 | 6911 | 92 |
1550899 | 1550899 | 2021-07-25 | Ogle | Illinois | 17141 | 6275 | 92 |
1547585 | 1547585 | 2021-07-24 | Boone | Illinois | 17007 | 6911 | 92 |
1547652 | 1547652 | 2021-07-24 | Ogle | Illinois | 17141 | 6275 | 92 |
1544338 | 1544338 | 2021-07-23 | Boone | Illinois | 17007 | 6911 | 92 |
1544405 | 1544405 | 2021-07-23 | Ogle | Illinois | 17141 | 6275 | 92 |
1541090 | 1541090 | 2021-07-22 | Boone | Illinois | 17007 | 6906 | 92 |
1541157 | 1541157 | 2021-07-22 | Ogle | Illinois | 17141 | 6272 | 92 |
1537843 | 1537843 | 2021-07-21 | Boone | Illinois | 17007 | 6902 | 92 |
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);