ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Warren" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1849803 | 1849803 | 2021-10-25 | Warren | Illinois | 17187 | 2453 | 69 |
1846553 | 1846553 | 2021-10-24 | Warren | Illinois | 17187 | 2448 | 69 |
1843303 | 1843303 | 2021-10-23 | Warren | Illinois | 17187 | 2448 | 69 |
1840053 | 1840053 | 2021-10-22 | Warren | Illinois | 17187 | 2448 | 69 |
1836804 | 1836804 | 2021-10-21 | Warren | Illinois | 17187 | 2442 | 69 |
1833555 | 1833555 | 2021-10-20 | Warren | Illinois | 17187 | 2440 | 69 |
1830306 | 1830306 | 2021-10-19 | Warren | Illinois | 17187 | 2438 | 68 |
1827057 | 1827057 | 2021-10-18 | Warren | Illinois | 17187 | 2436 | 68 |
1823808 | 1823808 | 2021-10-17 | Warren | Illinois | 17187 | 2427 | 68 |
1820559 | 1820559 | 2021-10-16 | Warren | Illinois | 17187 | 2427 | 68 |
1817310 | 1817310 | 2021-10-15 | Warren | Illinois | 17187 | 2427 | 68 |
1814062 | 1814062 | 2021-10-14 | Warren | Illinois | 17187 | 2422 | 68 |
1810813 | 1810813 | 2021-10-13 | Warren | Illinois | 17187 | 2417 | 68 |
1807564 | 1807564 | 2021-10-12 | Warren | Illinois | 17187 | 2414 | 68 |
1804313 | 1804313 | 2021-10-11 | Warren | Illinois | 17187 | 2395 | 68 |
1801064 | 1801064 | 2021-10-10 | Warren | Illinois | 17187 | 2395 | 68 |
1797815 | 1797815 | 2021-10-09 | Warren | Illinois | 17187 | 2395 | 68 |
1794566 | 1794566 | 2021-10-08 | Warren | Illinois | 17187 | 2395 | 68 |
1791318 | 1791318 | 2021-10-07 | Warren | Illinois | 17187 | 2383 | 67 |
1788069 | 1788069 | 2021-10-06 | Warren | Illinois | 17187 | 2377 | 67 |
1784820 | 1784820 | 2021-10-05 | Warren | Illinois | 17187 | 2359 | 67 |
1781571 | 1781571 | 2021-10-04 | Warren | Illinois | 17187 | 2348 | 67 |
1778321 | 1778321 | 2021-10-03 | Warren | Illinois | 17187 | 2324 | 67 |
1775071 | 1775071 | 2021-10-02 | Warren | Illinois | 17187 | 2324 | 67 |
1771821 | 1771821 | 2021-10-01 | Warren | Illinois | 17187 | 2324 | 67 |
1768572 | 1768572 | 2021-09-30 | Warren | Illinois | 17187 | 2318 | 66 |
1765323 | 1765323 | 2021-09-29 | Warren | Illinois | 17187 | 2310 | 66 |
1762074 | 1762074 | 2021-09-28 | Warren | Illinois | 17187 | 2302 | 65 |
1758826 | 1758826 | 2021-09-27 | Warren | Illinois | 17187 | 2288 | 65 |
1755578 | 1755578 | 2021-09-26 | Warren | Illinois | 17187 | 2271 | 64 |
1752330 | 1752330 | 2021-09-25 | Warren | Illinois | 17187 | 2271 | 64 |
1749081 | 1749081 | 2021-09-24 | Warren | Illinois | 17187 | 2271 | 64 |
1745831 | 1745831 | 2021-09-23 | Warren | Illinois | 17187 | 2260 | 64 |
1742582 | 1742582 | 2021-09-22 | Warren | Illinois | 17187 | 2249 | 63 |
1739333 | 1739333 | 2021-09-21 | Warren | Illinois | 17187 | 2230 | 63 |
1736084 | 1736084 | 2021-09-20 | Warren | Illinois | 17187 | 2224 | 60 |
1732834 | 1732834 | 2021-09-19 | Warren | Illinois | 17187 | 2204 | 59 |
1729584 | 1729584 | 2021-09-18 | Warren | Illinois | 17187 | 2204 | 59 |
1726334 | 1726334 | 2021-09-17 | Warren | Illinois | 17187 | 2204 | 59 |
1723085 | 1723085 | 2021-09-16 | Warren | Illinois | 17187 | 2197 | 59 |
1719836 | 1719836 | 2021-09-15 | Warren | Illinois | 17187 | 2186 | 58 |
1716588 | 1716588 | 2021-09-14 | Warren | Illinois | 17187 | 2178 | 57 |
1713342 | 1713342 | 2021-09-13 | Warren | Illinois | 17187 | 2158 | 57 |
1710095 | 1710095 | 2021-09-12 | Warren | Illinois | 17187 | 2137 | 57 |
1706848 | 1706848 | 2021-09-11 | Warren | Illinois | 17187 | 2137 | 57 |
1703600 | 1703600 | 2021-09-10 | Warren | Illinois | 17187 | 2137 | 57 |
1700350 | 1700350 | 2021-09-09 | Warren | Illinois | 17187 | 2119 | 57 |
1697101 | 1697101 | 2021-09-08 | Warren | Illinois | 17187 | 2095 | 56 |
1693853 | 1693853 | 2021-09-07 | Warren | Illinois | 17187 | 2084 | 54 |
1690604 | 1690604 | 2021-09-06 | Warren | Illinois | 17187 | 2053 | 54 |
1687354 | 1687354 | 2021-09-05 | Warren | Illinois | 17187 | 2053 | 54 |
1684104 | 1684104 | 2021-09-04 | Warren | Illinois | 17187 | 2053 | 54 |
1680853 | 1680853 | 2021-09-03 | Warren | Illinois | 17187 | 2053 | 54 |
1677605 | 1677605 | 2021-09-02 | Warren | Illinois | 17187 | 2039 | 54 |
1674358 | 1674358 | 2021-09-01 | Warren | Illinois | 17187 | 2036 | 54 |
1671109 | 1671109 | 2021-08-31 | Warren | Illinois | 17187 | 2019 | 54 |
1667862 | 1667862 | 2021-08-30 | Warren | Illinois | 17187 | 2005 | 54 |
1664615 | 1664615 | 2021-08-29 | Warren | Illinois | 17187 | 1987 | 54 |
1661367 | 1661367 | 2021-08-28 | Warren | Illinois | 17187 | 1987 | 54 |
1658119 | 1658119 | 2021-08-27 | Warren | Illinois | 17187 | 1987 | 54 |
1654871 | 1654871 | 2021-08-26 | Warren | Illinois | 17187 | 1981 | 53 |
1651624 | 1651624 | 2021-08-25 | Warren | Illinois | 17187 | 1978 | 53 |
1648375 | 1648375 | 2021-08-24 | Warren | Illinois | 17187 | 1967 | 53 |
1645127 | 1645127 | 2021-08-23 | Warren | Illinois | 17187 | 1962 | 53 |
1641878 | 1641878 | 2021-08-22 | Warren | Illinois | 17187 | 1951 | 53 |
1638628 | 1638628 | 2021-08-21 | Warren | Illinois | 17187 | 1951 | 53 |
1635378 | 1635378 | 2021-08-20 | Warren | Illinois | 17187 | 1951 | 53 |
1632128 | 1632128 | 2021-08-19 | Warren | Illinois | 17187 | 1948 | 53 |
1628881 | 1628881 | 2021-08-18 | Warren | Illinois | 17187 | 1935 | 53 |
1625634 | 1625634 | 2021-08-17 | Warren | Illinois | 17187 | 1928 | 53 |
1622387 | 1622387 | 2021-08-16 | Warren | Illinois | 17187 | 1923 | 53 |
1619140 | 1619140 | 2021-08-15 | Warren | Illinois | 17187 | 1913 | 53 |
1615892 | 1615892 | 2021-08-14 | Warren | Illinois | 17187 | 1913 | 53 |
1612643 | 1612643 | 2021-08-13 | Warren | Illinois | 17187 | 1913 | 53 |
1609395 | 1609395 | 2021-08-12 | Warren | Illinois | 17187 | 1905 | 53 |
1606146 | 1606146 | 2021-08-11 | Warren | Illinois | 17187 | 1903 | 53 |
1602897 | 1602897 | 2021-08-10 | Warren | Illinois | 17187 | 1896 | 53 |
1599648 | 1599648 | 2021-08-09 | Warren | Illinois | 17187 | 1894 | 53 |
1596400 | 1596400 | 2021-08-08 | Warren | Illinois | 17187 | 1890 | 53 |
1593151 | 1593151 | 2021-08-07 | Warren | Illinois | 17187 | 1890 | 53 |
1589902 | 1589902 | 2021-08-06 | Warren | Illinois | 17187 | 1890 | 53 |
1586653 | 1586653 | 2021-08-05 | Warren | Illinois | 17187 | 1887 | 53 |
1583403 | 1583403 | 2021-08-04 | Warren | Illinois | 17187 | 1882 | 53 |
1580153 | 1580153 | 2021-08-03 | Warren | Illinois | 17187 | 1875 | 53 |
1576904 | 1576904 | 2021-08-02 | Warren | Illinois | 17187 | 1872 | 53 |
1573656 | 1573656 | 2021-08-01 | Warren | Illinois | 17187 | 1868 | 53 |
1570408 | 1570408 | 2021-07-31 | Warren | Illinois | 17187 | 1868 | 53 |
1567160 | 1567160 | 2021-07-30 | Warren | Illinois | 17187 | 1868 | 53 |
1563912 | 1563912 | 2021-07-29 | Warren | Illinois | 17187 | 1867 | 53 |
1560664 | 1560664 | 2021-07-28 | Warren | Illinois | 17187 | 1867 | 53 |
1557417 | 1557417 | 2021-07-27 | Warren | Illinois | 17187 | 1864 | 53 |
1554170 | 1554170 | 2021-07-26 | Warren | Illinois | 17187 | 1863 | 53 |
1550923 | 1550923 | 2021-07-25 | Warren | Illinois | 17187 | 1862 | 53 |
1547676 | 1547676 | 2021-07-24 | Warren | Illinois | 17187 | 1862 | 53 |
1544429 | 1544429 | 2021-07-23 | Warren | Illinois | 17187 | 1862 | 53 |
1541181 | 1541181 | 2021-07-22 | Warren | Illinois | 17187 | 1859 | 53 |
1537934 | 1537934 | 2021-07-21 | Warren | Illinois | 17187 | 1859 | 53 |
1534686 | 1534686 | 2021-07-20 | Warren | Illinois | 17187 | 1860 | 53 |
1531439 | 1531439 | 2021-07-19 | Warren | Illinois | 17187 | 1859 | 53 |
1528192 | 1528192 | 2021-07-18 | Warren | Illinois | 17187 | 1854 | 53 |
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);