ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,543 rows where deaths = 5 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Calhoun 323
- Gallatin 216
- Christian 140
- Grundy 89
- Putnam 89
- Ogle 67
- Iroquois 53
- Pope 37
- Piatt 36
- Henry 34
- Stephenson 34
- Mercer 32
- Scott 24
- Douglas 23
- Cumberland 22
- Wayne 19
- Ford 18
- Morgan 17
- Pulaski 14
- Wabash 14
- Alexander 13
- Marshall 11
- Moultrie 10
- Henderson 9
- Williamson 9
- Jasper 8
- Effingham 7
- Franklin 7
- Hancock 7
- Tazewell 7
- …
state 1
- Illinois · 1,543 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2012216 | 2012216 | 2021-12-14 | Calhoun | Illinois | 17013 | 887 | 5 |
2008965 | 2008965 | 2021-12-13 | Calhoun | Illinois | 17013 | 874 | 5 |
2005714 | 2005714 | 2021-12-12 | Calhoun | Illinois | 17013 | 867 | 5 |
2002463 | 2002463 | 2021-12-11 | Calhoun | Illinois | 17013 | 867 | 5 |
1999213 | 1999213 | 2021-12-10 | Calhoun | Illinois | 17013 | 867 | 5 |
1995962 | 1995962 | 2021-12-09 | Calhoun | Illinois | 17013 | 866 | 5 |
1992711 | 1992711 | 2021-12-08 | Calhoun | Illinois | 17013 | 852 | 5 |
1989460 | 1989460 | 2021-12-07 | Calhoun | Illinois | 17013 | 851 | 5 |
1986210 | 1986210 | 2021-12-06 | Calhoun | Illinois | 17013 | 835 | 5 |
1982960 | 1982960 | 2021-12-05 | Calhoun | Illinois | 17013 | 818 | 5 |
1979710 | 1979710 | 2021-12-04 | Calhoun | Illinois | 17013 | 818 | 5 |
1976460 | 1976460 | 2021-12-03 | Calhoun | Illinois | 17013 | 818 | 5 |
1973211 | 1973211 | 2021-12-02 | Calhoun | Illinois | 17013 | 818 | 5 |
1969961 | 1969961 | 2021-12-01 | Calhoun | Illinois | 17013 | 807 | 5 |
1966711 | 1966711 | 2021-11-30 | Calhoun | Illinois | 17013 | 790 | 5 |
1963459 | 1963459 | 2021-11-29 | Calhoun | Illinois | 17013 | 778 | 5 |
1960208 | 1960208 | 2021-11-28 | Calhoun | Illinois | 17013 | 761 | 5 |
1956957 | 1956957 | 2021-11-27 | Calhoun | Illinois | 17013 | 761 | 5 |
1953706 | 1953706 | 2021-11-26 | Calhoun | Illinois | 17013 | 761 | 5 |
1950455 | 1950455 | 2021-11-25 | Calhoun | Illinois | 17013 | 761 | 5 |
1947204 | 1947204 | 2021-11-24 | Calhoun | Illinois | 17013 | 761 | 5 |
1943953 | 1943953 | 2021-11-23 | Calhoun | Illinois | 17013 | 760 | 5 |
1944024 | 1944024 | 2021-11-23 | Putnam | Illinois | 17155 | 617 | 5 |
1940703 | 1940703 | 2021-11-22 | Calhoun | Illinois | 17013 | 751 | 5 |
1940774 | 1940774 | 2021-11-22 | Putnam | Illinois | 17155 | 612 | 5 |
1937453 | 1937453 | 2021-11-21 | Calhoun | Illinois | 17013 | 746 | 5 |
1937524 | 1937524 | 2021-11-21 | Putnam | Illinois | 17155 | 605 | 5 |
1934203 | 1934203 | 2021-11-20 | Calhoun | Illinois | 17013 | 746 | 5 |
1934274 | 1934274 | 2021-11-20 | Putnam | Illinois | 17155 | 605 | 5 |
1930952 | 1930952 | 2021-11-19 | Calhoun | Illinois | 17013 | 746 | 5 |
1931023 | 1931023 | 2021-11-19 | Putnam | Illinois | 17155 | 605 | 5 |
1927701 | 1927701 | 2021-11-18 | Calhoun | Illinois | 17013 | 746 | 5 |
1927772 | 1927772 | 2021-11-18 | Putnam | Illinois | 17155 | 604 | 5 |
1924451 | 1924451 | 2021-11-17 | Calhoun | Illinois | 17013 | 740 | 5 |
1924522 | 1924522 | 2021-11-17 | Putnam | Illinois | 17155 | 599 | 5 |
1921202 | 1921202 | 2021-11-16 | Calhoun | Illinois | 17013 | 730 | 5 |
1921273 | 1921273 | 2021-11-16 | Putnam | Illinois | 17155 | 596 | 5 |
1917952 | 1917952 | 2021-11-15 | Calhoun | Illinois | 17013 | 725 | 5 |
1918023 | 1918023 | 2021-11-15 | Putnam | Illinois | 17155 | 591 | 5 |
1914702 | 1914702 | 2021-11-14 | Calhoun | Illinois | 17013 | 722 | 5 |
1914773 | 1914773 | 2021-11-14 | Putnam | Illinois | 17155 | 588 | 5 |
1911452 | 1911452 | 2021-11-13 | Calhoun | Illinois | 17013 | 722 | 5 |
1911523 | 1911523 | 2021-11-13 | Putnam | Illinois | 17155 | 588 | 5 |
1908203 | 1908203 | 2021-11-12 | Calhoun | Illinois | 17013 | 722 | 5 |
1908274 | 1908274 | 2021-11-12 | Putnam | Illinois | 17155 | 588 | 5 |
1904954 | 1904954 | 2021-11-11 | Calhoun | Illinois | 17013 | 720 | 5 |
1905025 | 1905025 | 2021-11-11 | Putnam | Illinois | 17155 | 586 | 5 |
1901704 | 1901704 | 2021-11-10 | Calhoun | Illinois | 17013 | 720 | 5 |
1901775 | 1901775 | 2021-11-10 | Putnam | Illinois | 17155 | 586 | 5 |
1898454 | 1898454 | 2021-11-09 | Calhoun | Illinois | 17013 | 720 | 5 |
1898525 | 1898525 | 2021-11-09 | Putnam | Illinois | 17155 | 581 | 5 |
1895204 | 1895204 | 2021-11-08 | Calhoun | Illinois | 17013 | 719 | 5 |
1895275 | 1895275 | 2021-11-08 | Putnam | Illinois | 17155 | 579 | 5 |
1891954 | 1891954 | 2021-11-07 | Calhoun | Illinois | 17013 | 713 | 5 |
1892025 | 1892025 | 2021-11-07 | Putnam | Illinois | 17155 | 576 | 5 |
1888704 | 1888704 | 2021-11-06 | Calhoun | Illinois | 17013 | 713 | 5 |
1888775 | 1888775 | 2021-11-06 | Putnam | Illinois | 17155 | 576 | 5 |
1885454 | 1885454 | 2021-11-05 | Calhoun | Illinois | 17013 | 713 | 5 |
1885525 | 1885525 | 2021-11-05 | Putnam | Illinois | 17155 | 576 | 5 |
1882205 | 1882205 | 2021-11-04 | Calhoun | Illinois | 17013 | 710 | 5 |
1882276 | 1882276 | 2021-11-04 | Putnam | Illinois | 17155 | 575 | 5 |
1878956 | 1878956 | 2021-11-03 | Calhoun | Illinois | 17013 | 709 | 5 |
1879027 | 1879027 | 2021-11-03 | Putnam | Illinois | 17155 | 572 | 5 |
1875707 | 1875707 | 2021-11-02 | Calhoun | Illinois | 17013 | 709 | 5 |
1875778 | 1875778 | 2021-11-02 | Putnam | Illinois | 17155 | 571 | 5 |
1872458 | 1872458 | 2021-11-01 | Calhoun | Illinois | 17013 | 707 | 5 |
1872529 | 1872529 | 2021-11-01 | Putnam | Illinois | 17155 | 568 | 5 |
1869209 | 1869209 | 2021-10-31 | Calhoun | Illinois | 17013 | 701 | 5 |
1869280 | 1869280 | 2021-10-31 | Putnam | Illinois | 17155 | 568 | 5 |
1865960 | 1865960 | 2021-10-30 | Calhoun | Illinois | 17013 | 701 | 5 |
1866031 | 1866031 | 2021-10-30 | Putnam | Illinois | 17155 | 568 | 5 |
1862711 | 1862711 | 2021-10-29 | Calhoun | Illinois | 17013 | 701 | 5 |
1862782 | 1862782 | 2021-10-29 | Putnam | Illinois | 17155 | 568 | 5 |
1859462 | 1859462 | 2021-10-28 | Calhoun | Illinois | 17013 | 701 | 5 |
1859533 | 1859533 | 2021-10-28 | Putnam | Illinois | 17155 | 568 | 5 |
1856213 | 1856213 | 2021-10-27 | Calhoun | Illinois | 17013 | 698 | 5 |
1856284 | 1856284 | 2021-10-27 | Putnam | Illinois | 17155 | 568 | 5 |
1852964 | 1852964 | 2021-10-26 | Calhoun | Illinois | 17013 | 695 | 5 |
1853035 | 1853035 | 2021-10-26 | Putnam | Illinois | 17155 | 568 | 5 |
1849715 | 1849715 | 2021-10-25 | Calhoun | Illinois | 17013 | 694 | 5 |
1849786 | 1849786 | 2021-10-25 | Putnam | Illinois | 17155 | 568 | 5 |
1846465 | 1846465 | 2021-10-24 | Calhoun | Illinois | 17013 | 693 | 5 |
1846536 | 1846536 | 2021-10-24 | Putnam | Illinois | 17155 | 567 | 5 |
1843215 | 1843215 | 2021-10-23 | Calhoun | Illinois | 17013 | 693 | 5 |
1843286 | 1843286 | 2021-10-23 | Putnam | Illinois | 17155 | 567 | 5 |
1839965 | 1839965 | 2021-10-22 | Calhoun | Illinois | 17013 | 693 | 5 |
1840036 | 1840036 | 2021-10-22 | Putnam | Illinois | 17155 | 567 | 5 |
1836716 | 1836716 | 2021-10-21 | Calhoun | Illinois | 17013 | 693 | 5 |
1836787 | 1836787 | 2021-10-21 | Putnam | Illinois | 17155 | 565 | 5 |
1833467 | 1833467 | 2021-10-20 | Calhoun | Illinois | 17013 | 692 | 5 |
1833538 | 1833538 | 2021-10-20 | Putnam | Illinois | 17155 | 565 | 5 |
1830218 | 1830218 | 2021-10-19 | Calhoun | Illinois | 17013 | 692 | 5 |
1830289 | 1830289 | 2021-10-19 | Putnam | Illinois | 17155 | 563 | 5 |
1826969 | 1826969 | 2021-10-18 | Calhoun | Illinois | 17013 | 690 | 5 |
1827040 | 1827040 | 2021-10-18 | Putnam | Illinois | 17155 | 561 | 5 |
1823720 | 1823720 | 2021-10-17 | Calhoun | Illinois | 17013 | 686 | 5 |
1823791 | 1823791 | 2021-10-17 | Putnam | Illinois | 17155 | 560 | 5 |
1820471 | 1820471 | 2021-10-16 | Calhoun | Illinois | 17013 | 686 | 5 |
1820542 | 1820542 | 2021-10-16 | Putnam | Illinois | 17155 | 560 | 5 |
1817222 | 1817222 | 2021-10-15 | Calhoun | Illinois | 17013 | 686 | 5 |
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);