ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Clark" and fips = 17023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1813979 | 1813979 | 2021-10-14 | Clark | Illinois | 17023 | 2640 | 47 |
1810730 | 1810730 | 2021-10-13 | Clark | Illinois | 17023 | 2638 | 47 |
1807481 | 1807481 | 2021-10-12 | Clark | Illinois | 17023 | 2635 | 47 |
1804230 | 1804230 | 2021-10-11 | Clark | Illinois | 17023 | 2626 | 47 |
1800981 | 1800981 | 2021-10-10 | Clark | Illinois | 17023 | 2626 | 47 |
1797732 | 1797732 | 2021-10-09 | Clark | Illinois | 17023 | 2626 | 47 |
1794483 | 1794483 | 2021-10-08 | Clark | Illinois | 17023 | 2626 | 47 |
1791235 | 1791235 | 2021-10-07 | Clark | Illinois | 17023 | 2610 | 47 |
1787986 | 1787986 | 2021-10-06 | Clark | Illinois | 17023 | 2610 | 47 |
1784737 | 1784737 | 2021-10-05 | Clark | Illinois | 17023 | 2602 | 47 |
1781488 | 1781488 | 2021-10-04 | Clark | Illinois | 17023 | 2596 | 47 |
1778238 | 1778238 | 2021-10-03 | Clark | Illinois | 17023 | 2583 | 47 |
1774988 | 1774988 | 2021-10-02 | Clark | Illinois | 17023 | 2583 | 47 |
1771738 | 1771738 | 2021-10-01 | Clark | Illinois | 17023 | 2583 | 47 |
1768489 | 1768489 | 2021-09-30 | Clark | Illinois | 17023 | 2578 | 47 |
1765240 | 1765240 | 2021-09-29 | Clark | Illinois | 17023 | 2568 | 47 |
1761991 | 1761991 | 2021-09-28 | Clark | Illinois | 17023 | 2558 | 46 |
1758743 | 1758743 | 2021-09-27 | Clark | Illinois | 17023 | 2552 | 46 |
1755495 | 1755495 | 2021-09-26 | Clark | Illinois | 17023 | 2535 | 46 |
1752247 | 1752247 | 2021-09-25 | Clark | Illinois | 17023 | 2535 | 46 |
1748998 | 1748998 | 2021-09-24 | Clark | Illinois | 17023 | 2535 | 46 |
1745748 | 1745748 | 2021-09-23 | Clark | Illinois | 17023 | 2519 | 46 |
1742499 | 1742499 | 2021-09-22 | Clark | Illinois | 17023 | 2507 | 46 |
1739250 | 1739250 | 2021-09-21 | Clark | Illinois | 17023 | 2495 | 46 |
1736001 | 1736001 | 2021-09-20 | Clark | Illinois | 17023 | 2487 | 46 |
1732751 | 1732751 | 2021-09-19 | Clark | Illinois | 17023 | 2441 | 46 |
1729501 | 1729501 | 2021-09-18 | Clark | Illinois | 17023 | 2441 | 46 |
1726251 | 1726251 | 2021-09-17 | Clark | Illinois | 17023 | 2441 | 46 |
1723002 | 1723002 | 2021-09-16 | Clark | Illinois | 17023 | 2429 | 46 |
1719753 | 1719753 | 2021-09-15 | Clark | Illinois | 17023 | 2410 | 46 |
1716505 | 1716505 | 2021-09-14 | Clark | Illinois | 17023 | 2389 | 46 |
1713259 | 1713259 | 2021-09-13 | Clark | Illinois | 17023 | 2360 | 45 |
1710012 | 1710012 | 2021-09-12 | Clark | Illinois | 17023 | 2327 | 44 |
1706765 | 1706765 | 2021-09-11 | Clark | Illinois | 17023 | 2327 | 44 |
1703517 | 1703517 | 2021-09-10 | Clark | Illinois | 17023 | 2327 | 44 |
1700267 | 1700267 | 2021-09-09 | Clark | Illinois | 17023 | 2311 | 44 |
1697018 | 1697018 | 2021-09-08 | Clark | Illinois | 17023 | 2291 | 44 |
1693770 | 1693770 | 2021-09-07 | Clark | Illinois | 17023 | 2284 | 44 |
1690521 | 1690521 | 2021-09-06 | Clark | Illinois | 17023 | 2237 | 44 |
1687271 | 1687271 | 2021-09-05 | Clark | Illinois | 17023 | 2237 | 44 |
1684021 | 1684021 | 2021-09-04 | Clark | Illinois | 17023 | 2237 | 44 |
1680770 | 1680770 | 2021-09-03 | Clark | Illinois | 17023 | 2237 | 44 |
1677522 | 1677522 | 2021-09-02 | Clark | Illinois | 17023 | 2210 | 44 |
1674275 | 1674275 | 2021-09-01 | Clark | Illinois | 17023 | 2196 | 44 |
1671026 | 1671026 | 2021-08-31 | Clark | Illinois | 17023 | 2183 | 44 |
1667779 | 1667779 | 2021-08-30 | Clark | Illinois | 17023 | 2169 | 44 |
1664532 | 1664532 | 2021-08-29 | Clark | Illinois | 17023 | 2141 | 44 |
1661284 | 1661284 | 2021-08-28 | Clark | Illinois | 17023 | 2141 | 44 |
1658036 | 1658036 | 2021-08-27 | Clark | Illinois | 17023 | 2141 | 44 |
1654788 | 1654788 | 2021-08-26 | Clark | Illinois | 17023 | 2131 | 44 |
1651541 | 1651541 | 2021-08-25 | Clark | Illinois | 17023 | 2118 | 44 |
1648292 | 1648292 | 2021-08-24 | Clark | Illinois | 17023 | 2107 | 44 |
1645044 | 1645044 | 2021-08-23 | Clark | Illinois | 17023 | 2102 | 44 |
1641795 | 1641795 | 2021-08-22 | Clark | Illinois | 17023 | 2077 | 44 |
1638545 | 1638545 | 2021-08-21 | Clark | Illinois | 17023 | 2077 | 44 |
1635295 | 1635295 | 2021-08-20 | Clark | Illinois | 17023 | 2077 | 44 |
1632045 | 1632045 | 2021-08-19 | Clark | Illinois | 17023 | 2068 | 44 |
1628798 | 1628798 | 2021-08-18 | Clark | Illinois | 17023 | 2058 | 44 |
1625551 | 1625551 | 2021-08-17 | Clark | Illinois | 17023 | 2045 | 43 |
1622304 | 1622304 | 2021-08-16 | Clark | Illinois | 17023 | 2036 | 43 |
1619057 | 1619057 | 2021-08-15 | Clark | Illinois | 17023 | 2012 | 43 |
1615809 | 1615809 | 2021-08-14 | Clark | Illinois | 17023 | 2012 | 43 |
1612560 | 1612560 | 2021-08-13 | Clark | Illinois | 17023 | 2012 | 43 |
1609312 | 1609312 | 2021-08-12 | Clark | Illinois | 17023 | 2005 | 43 |
1606063 | 1606063 | 2021-08-11 | Clark | Illinois | 17023 | 1996 | 42 |
1602814 | 1602814 | 2021-08-10 | Clark | Illinois | 17023 | 1978 | 42 |
1599565 | 1599565 | 2021-08-09 | Clark | Illinois | 17023 | 1973 | 42 |
1596317 | 1596317 | 2021-08-08 | Clark | Illinois | 17023 | 1952 | 42 |
1593068 | 1593068 | 2021-08-07 | Clark | Illinois | 17023 | 1952 | 42 |
1589819 | 1589819 | 2021-08-06 | Clark | Illinois | 17023 | 1952 | 42 |
1586570 | 1586570 | 2021-08-05 | Clark | Illinois | 17023 | 1947 | 42 |
1583320 | 1583320 | 2021-08-04 | Clark | Illinois | 17023 | 1937 | 42 |
1580070 | 1580070 | 2021-08-03 | Clark | Illinois | 17023 | 1936 | 42 |
1576821 | 1576821 | 2021-08-02 | Clark | Illinois | 17023 | 1919 | 42 |
1573573 | 1573573 | 2021-08-01 | Clark | Illinois | 17023 | 1913 | 42 |
1570325 | 1570325 | 2021-07-31 | Clark | Illinois | 17023 | 1913 | 42 |
1567077 | 1567077 | 2021-07-30 | Clark | Illinois | 17023 | 1913 | 42 |
1563829 | 1563829 | 2021-07-29 | Clark | Illinois | 17023 | 1912 | 42 |
1560581 | 1560581 | 2021-07-28 | Clark | Illinois | 17023 | 1907 | 42 |
1557334 | 1557334 | 2021-07-27 | Clark | Illinois | 17023 | 1904 | 42 |
1554087 | 1554087 | 2021-07-26 | Clark | Illinois | 17023 | 1897 | 42 |
1550840 | 1550840 | 2021-07-25 | Clark | Illinois | 17023 | 1890 | 42 |
1547593 | 1547593 | 2021-07-24 | Clark | Illinois | 17023 | 1890 | 42 |
1544346 | 1544346 | 2021-07-23 | Clark | Illinois | 17023 | 1890 | 42 |
1541098 | 1541098 | 2021-07-22 | Clark | Illinois | 17023 | 1889 | 42 |
1537851 | 1537851 | 2021-07-21 | Clark | Illinois | 17023 | 1886 | 42 |
1534603 | 1534603 | 2021-07-20 | Clark | Illinois | 17023 | 1886 | 42 |
1531356 | 1531356 | 2021-07-19 | Clark | Illinois | 17023 | 1885 | 42 |
1528109 | 1528109 | 2021-07-18 | Clark | Illinois | 17023 | 1885 | 42 |
1524862 | 1524862 | 2021-07-17 | Clark | Illinois | 17023 | 1885 | 42 |
1521614 | 1521614 | 2021-07-16 | Clark | Illinois | 17023 | 1885 | 42 |
1518366 | 1518366 | 2021-07-15 | Clark | Illinois | 17023 | 1885 | 42 |
1515119 | 1515119 | 2021-07-14 | Clark | Illinois | 17023 | 1881 | 42 |
1511873 | 1511873 | 2021-07-13 | Clark | Illinois | 17023 | 1876 | 42 |
1508626 | 1508626 | 2021-07-12 | Clark | Illinois | 17023 | 1873 | 42 |
1505380 | 1505380 | 2021-07-11 | Clark | Illinois | 17023 | 1872 | 42 |
1502134 | 1502134 | 2021-07-10 | Clark | Illinois | 17023 | 1872 | 42 |
1498888 | 1498888 | 2021-07-09 | Clark | Illinois | 17023 | 1872 | 42 |
1495641 | 1495641 | 2021-07-08 | Clark | Illinois | 17023 | 1870 | 42 |
1492395 | 1492395 | 2021-07-07 | Clark | Illinois | 17023 | 1867 | 41 |
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);