ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 17039 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1813986 | 1813986 | 2021-10-14 | De Witt | Illinois | 17039 | 2041 | 37 |
1810737 | 1810737 | 2021-10-13 | De Witt | Illinois | 17039 | 2042 | 37 |
1807488 | 1807488 | 2021-10-12 | De Witt | Illinois | 17039 | 2036 | 37 |
1804237 | 1804237 | 2021-10-11 | De Witt | Illinois | 17039 | 2029 | 37 |
1800988 | 1800988 | 2021-10-10 | De Witt | Illinois | 17039 | 2029 | 37 |
1797739 | 1797739 | 2021-10-09 | De Witt | Illinois | 17039 | 2029 | 37 |
1794490 | 1794490 | 2021-10-08 | De Witt | Illinois | 17039 | 2029 | 37 |
1791242 | 1791242 | 2021-10-07 | De Witt | Illinois | 17039 | 2028 | 37 |
1787993 | 1787993 | 2021-10-06 | De Witt | Illinois | 17039 | 2025 | 37 |
1784744 | 1784744 | 2021-10-05 | De Witt | Illinois | 17039 | 2017 | 37 |
1781495 | 1781495 | 2021-10-04 | De Witt | Illinois | 17039 | 2011 | 37 |
1778245 | 1778245 | 2021-10-03 | De Witt | Illinois | 17039 | 2003 | 37 |
1774995 | 1774995 | 2021-10-02 | De Witt | Illinois | 17039 | 2003 | 37 |
1771745 | 1771745 | 2021-10-01 | De Witt | Illinois | 17039 | 2003 | 37 |
1768496 | 1768496 | 2021-09-30 | De Witt | Illinois | 17039 | 1995 | 37 |
1765247 | 1765247 | 2021-09-29 | De Witt | Illinois | 17039 | 1988 | 37 |
1761998 | 1761998 | 2021-09-28 | De Witt | Illinois | 17039 | 1984 | 37 |
1758750 | 1758750 | 2021-09-27 | De Witt | Illinois | 17039 | 1981 | 37 |
1755502 | 1755502 | 2021-09-26 | De Witt | Illinois | 17039 | 1968 | 37 |
1752254 | 1752254 | 2021-09-25 | De Witt | Illinois | 17039 | 1968 | 37 |
1749005 | 1749005 | 2021-09-24 | De Witt | Illinois | 17039 | 1968 | 37 |
1745755 | 1745755 | 2021-09-23 | De Witt | Illinois | 17039 | 1963 | 37 |
1742506 | 1742506 | 2021-09-22 | De Witt | Illinois | 17039 | 1955 | 37 |
1739257 | 1739257 | 2021-09-21 | De Witt | Illinois | 17039 | 1942 | 37 |
1736008 | 1736008 | 2021-09-20 | De Witt | Illinois | 17039 | 1939 | 37 |
1732758 | 1732758 | 2021-09-19 | De Witt | Illinois | 17039 | 1927 | 37 |
1729508 | 1729508 | 2021-09-18 | De Witt | Illinois | 17039 | 1927 | 37 |
1726258 | 1726258 | 2021-09-17 | De Witt | Illinois | 17039 | 1927 | 37 |
1723009 | 1723009 | 2021-09-16 | De Witt | Illinois | 17039 | 1920 | 37 |
1719760 | 1719760 | 2021-09-15 | De Witt | Illinois | 17039 | 1912 | 37 |
1716512 | 1716512 | 2021-09-14 | De Witt | Illinois | 17039 | 1900 | 37 |
1713266 | 1713266 | 2021-09-13 | De Witt | Illinois | 17039 | 1889 | 37 |
1710019 | 1710019 | 2021-09-12 | De Witt | Illinois | 17039 | 1873 | 37 |
1706772 | 1706772 | 2021-09-11 | De Witt | Illinois | 17039 | 1873 | 37 |
1703524 | 1703524 | 2021-09-10 | De Witt | Illinois | 17039 | 1873 | 37 |
1700274 | 1700274 | 2021-09-09 | De Witt | Illinois | 17039 | 1863 | 37 |
1697025 | 1697025 | 2021-09-08 | De Witt | Illinois | 17039 | 1857 | 37 |
1693777 | 1693777 | 2021-09-07 | De Witt | Illinois | 17039 | 1850 | 37 |
1690528 | 1690528 | 2021-09-06 | De Witt | Illinois | 17039 | 1826 | 37 |
1687278 | 1687278 | 2021-09-05 | De Witt | Illinois | 17039 | 1826 | 37 |
1684028 | 1684028 | 2021-09-04 | De Witt | Illinois | 17039 | 1826 | 37 |
1680777 | 1680777 | 2021-09-03 | De Witt | Illinois | 17039 | 1826 | 37 |
1677529 | 1677529 | 2021-09-02 | De Witt | Illinois | 17039 | 1818 | 37 |
1674282 | 1674282 | 2021-09-01 | De Witt | Illinois | 17039 | 1813 | 37 |
1671033 | 1671033 | 2021-08-31 | De Witt | Illinois | 17039 | 1804 | 37 |
1667786 | 1667786 | 2021-08-30 | De Witt | Illinois | 17039 | 1784 | 37 |
1664539 | 1664539 | 2021-08-29 | De Witt | Illinois | 17039 | 1762 | 37 |
1661291 | 1661291 | 2021-08-28 | De Witt | Illinois | 17039 | 1762 | 37 |
1658043 | 1658043 | 2021-08-27 | De Witt | Illinois | 17039 | 1762 | 37 |
1654795 | 1654795 | 2021-08-26 | De Witt | Illinois | 17039 | 1757 | 37 |
1651548 | 1651548 | 2021-08-25 | De Witt | Illinois | 17039 | 1751 | 37 |
1648299 | 1648299 | 2021-08-24 | De Witt | Illinois | 17039 | 1738 | 36 |
1645051 | 1645051 | 2021-08-23 | De Witt | Illinois | 17039 | 1732 | 36 |
1641802 | 1641802 | 2021-08-22 | De Witt | Illinois | 17039 | 1713 | 36 |
1638552 | 1638552 | 2021-08-21 | De Witt | Illinois | 17039 | 1713 | 36 |
1635302 | 1635302 | 2021-08-20 | De Witt | Illinois | 17039 | 1713 | 36 |
1632052 | 1632052 | 2021-08-19 | De Witt | Illinois | 17039 | 1699 | 36 |
1628805 | 1628805 | 2021-08-18 | De Witt | Illinois | 17039 | 1698 | 36 |
1625558 | 1625558 | 2021-08-17 | De Witt | Illinois | 17039 | 1692 | 36 |
1622311 | 1622311 | 2021-08-16 | De Witt | Illinois | 17039 | 1689 | 36 |
1619064 | 1619064 | 2021-08-15 | De Witt | Illinois | 17039 | 1676 | 36 |
1615816 | 1615816 | 2021-08-14 | De Witt | Illinois | 17039 | 1676 | 36 |
1612567 | 1612567 | 2021-08-13 | De Witt | Illinois | 17039 | 1676 | 36 |
1609319 | 1609319 | 2021-08-12 | De Witt | Illinois | 17039 | 1663 | 36 |
1606070 | 1606070 | 2021-08-11 | De Witt | Illinois | 17039 | 1662 | 36 |
1602821 | 1602821 | 2021-08-10 | De Witt | Illinois | 17039 | 1659 | 36 |
1599572 | 1599572 | 2021-08-09 | De Witt | Illinois | 17039 | 1644 | 36 |
1596324 | 1596324 | 2021-08-08 | De Witt | Illinois | 17039 | 1633 | 36 |
1593075 | 1593075 | 2021-08-07 | De Witt | Illinois | 17039 | 1633 | 36 |
1589826 | 1589826 | 2021-08-06 | De Witt | Illinois | 17039 | 1633 | 36 |
1586577 | 1586577 | 2021-08-05 | De Witt | Illinois | 17039 | 1629 | 36 |
1583327 | 1583327 | 2021-08-04 | De Witt | Illinois | 17039 | 1627 | 36 |
1580077 | 1580077 | 2021-08-03 | De Witt | Illinois | 17039 | 1627 | 36 |
1576828 | 1576828 | 2021-08-02 | De Witt | Illinois | 17039 | 1623 | 36 |
1573580 | 1573580 | 2021-08-01 | De Witt | Illinois | 17039 | 1615 | 36 |
1570332 | 1570332 | 2021-07-31 | De Witt | Illinois | 17039 | 1615 | 36 |
1567084 | 1567084 | 2021-07-30 | De Witt | Illinois | 17039 | 1615 | 36 |
1563836 | 1563836 | 2021-07-29 | De Witt | Illinois | 17039 | 1615 | 36 |
1560588 | 1560588 | 2021-07-28 | De Witt | Illinois | 17039 | 1614 | 36 |
1557341 | 1557341 | 2021-07-27 | De Witt | Illinois | 17039 | 1611 | 36 |
1554094 | 1554094 | 2021-07-26 | De Witt | Illinois | 17039 | 1610 | 36 |
1550847 | 1550847 | 2021-07-25 | De Witt | Illinois | 17039 | 1606 | 36 |
1547600 | 1547600 | 2021-07-24 | De Witt | Illinois | 17039 | 1606 | 36 |
1544353 | 1544353 | 2021-07-23 | De Witt | Illinois | 17039 | 1606 | 36 |
1541105 | 1541105 | 2021-07-22 | De Witt | Illinois | 17039 | 1605 | 36 |
1537858 | 1537858 | 2021-07-21 | De Witt | Illinois | 17039 | 1600 | 36 |
1534610 | 1534610 | 2021-07-20 | De Witt | Illinois | 17039 | 1597 | 36 |
1531363 | 1531363 | 2021-07-19 | De Witt | Illinois | 17039 | 1594 | 36 |
1528116 | 1528116 | 2021-07-18 | De Witt | Illinois | 17039 | 1592 | 36 |
1524869 | 1524869 | 2021-07-17 | De Witt | Illinois | 17039 | 1592 | 36 |
1521621 | 1521621 | 2021-07-16 | De Witt | Illinois | 17039 | 1592 | 36 |
1518373 | 1518373 | 2021-07-15 | De Witt | Illinois | 17039 | 1592 | 36 |
1515126 | 1515126 | 2021-07-14 | De Witt | Illinois | 17039 | 1589 | 36 |
1511880 | 1511880 | 2021-07-13 | De Witt | Illinois | 17039 | 1587 | 36 |
1508633 | 1508633 | 2021-07-12 | De Witt | Illinois | 17039 | 1587 | 36 |
1505387 | 1505387 | 2021-07-11 | De Witt | Illinois | 17039 | 1585 | 36 |
1502141 | 1502141 | 2021-07-10 | De Witt | Illinois | 17039 | 1585 | 36 |
1498895 | 1498895 | 2021-07-09 | De Witt | Illinois | 17039 | 1585 | 36 |
1495648 | 1495648 | 2021-07-08 | De Witt | Illinois | 17039 | 1584 | 36 |
1492402 | 1492402 | 2021-07-07 | De Witt | Illinois | 17039 | 1580 | 36 |
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);