ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Warren" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947711 | 1947711 | 2021-11-24 | Warren | Kentucky | 21227 | 26682 | 274 |
1944460 | 1944460 | 2021-11-23 | Warren | Kentucky | 21227 | 26624 | 273 |
1941210 | 1941210 | 2021-11-22 | Warren | Kentucky | 21227 | 26571 | 273 |
1937960 | 1937960 | 2021-11-21 | Warren | Kentucky | 21227 | 26431 | 270 |
1934710 | 1934710 | 2021-11-20 | Warren | Kentucky | 21227 | 26431 | 270 |
1931459 | 1931459 | 2021-11-19 | Warren | Kentucky | 21227 | 26431 | 270 |
1928208 | 1928208 | 2021-11-18 | Warren | Kentucky | 21227 | 26398 | 267 |
1924958 | 1924958 | 2021-11-17 | Warren | Kentucky | 21227 | 26350 | 267 |
1921709 | 1921709 | 2021-11-16 | Warren | Kentucky | 21227 | 26293 | 266 |
1918459 | 1918459 | 2021-11-15 | Warren | Kentucky | 21227 | 26249 | 266 |
1915209 | 1915209 | 2021-11-14 | Warren | Kentucky | 21227 | 26139 | 264 |
1911959 | 1911959 | 2021-11-13 | Warren | Kentucky | 21227 | 26139 | 264 |
1908710 | 1908710 | 2021-11-12 | Warren | Kentucky | 21227 | 26139 | 264 |
1905461 | 1905461 | 2021-11-11 | Warren | Kentucky | 21227 | 26042 | 262 |
1902211 | 1902211 | 2021-11-10 | Warren | Kentucky | 21227 | 26042 | 262 |
1898961 | 1898961 | 2021-11-09 | Warren | Kentucky | 21227 | 25996 | 262 |
1895711 | 1895711 | 2021-11-08 | Warren | Kentucky | 21227 | 25927 | 261 |
1892461 | 1892461 | 2021-11-07 | Warren | Kentucky | 21227 | 25865 | 256 |
1889211 | 1889211 | 2021-11-06 | Warren | Kentucky | 21227 | 25865 | 256 |
1885961 | 1885961 | 2021-11-05 | Warren | Kentucky | 21227 | 25865 | 256 |
1882712 | 1882712 | 2021-11-04 | Warren | Kentucky | 21227 | 25826 | 255 |
1879463 | 1879463 | 2021-11-03 | Warren | Kentucky | 21227 | 25806 | 255 |
1876214 | 1876214 | 2021-11-02 | Warren | Kentucky | 21227 | 25780 | 255 |
1872965 | 1872965 | 2021-11-01 | Warren | Kentucky | 21227 | 25751 | 255 |
1869716 | 1869716 | 2021-10-31 | Warren | Kentucky | 21227 | 25692 | 254 |
1866467 | 1866467 | 2021-10-30 | Warren | Kentucky | 21227 | 25692 | 254 |
1863218 | 1863218 | 2021-10-29 | Warren | Kentucky | 21227 | 25692 | 254 |
1859969 | 1859969 | 2021-10-28 | Warren | Kentucky | 21227 | 25667 | 254 |
1856720 | 1856720 | 2021-10-27 | Warren | Kentucky | 21227 | 25645 | 249 |
1853471 | 1853471 | 2021-10-26 | Warren | Kentucky | 21227 | 25618 | 249 |
1850222 | 1850222 | 2021-10-25 | Warren | Kentucky | 21227 | 25583 | 249 |
1846972 | 1846972 | 2021-10-24 | Warren | Kentucky | 21227 | 25517 | 246 |
1843722 | 1843722 | 2021-10-23 | Warren | Kentucky | 21227 | 25517 | 246 |
1840472 | 1840472 | 2021-10-22 | Warren | Kentucky | 21227 | 25517 | 246 |
1837223 | 1837223 | 2021-10-21 | Warren | Kentucky | 21227 | 25483 | 246 |
1833974 | 1833974 | 2021-10-20 | Warren | Kentucky | 21227 | 25440 | 246 |
1830725 | 1830725 | 2021-10-19 | Warren | Kentucky | 21227 | 25402 | 246 |
1827476 | 1827476 | 2021-10-18 | Warren | Kentucky | 21227 | 25348 | 244 |
1824227 | 1824227 | 2021-10-17 | Warren | Kentucky | 21227 | 25278 | 240 |
1820978 | 1820978 | 2021-10-16 | Warren | Kentucky | 21227 | 25278 | 240 |
1817729 | 1817729 | 2021-10-15 | Warren | Kentucky | 21227 | 25278 | 240 |
1814481 | 1814481 | 2021-10-14 | Warren | Kentucky | 21227 | 25223 | 238 |
1811232 | 1811232 | 2021-10-13 | Warren | Kentucky | 21227 | 25192 | 236 |
1807983 | 1807983 | 2021-10-12 | Warren | Kentucky | 21227 | 25133 | 236 |
1804732 | 1804732 | 2021-10-11 | Warren | Kentucky | 21227 | 25065 | 236 |
1801483 | 1801483 | 2021-10-10 | Warren | Kentucky | 21227 | 24957 | 235 |
1798234 | 1798234 | 2021-10-09 | Warren | Kentucky | 21227 | 24957 | 235 |
1794985 | 1794985 | 2021-10-08 | Warren | Kentucky | 21227 | 24957 | 235 |
1791737 | 1791737 | 2021-10-07 | Warren | Kentucky | 21227 | 24928 | 233 |
1788488 | 1788488 | 2021-10-06 | Warren | Kentucky | 21227 | 24862 | 225 |
1785239 | 1785239 | 2021-10-05 | Warren | Kentucky | 21227 | 24805 | 223 |
1781990 | 1781990 | 2021-10-04 | Warren | Kentucky | 21227 | 24738 | 223 |
1778740 | 1778740 | 2021-10-03 | Warren | Kentucky | 21227 | 24588 | 222 |
1775490 | 1775490 | 2021-10-02 | Warren | Kentucky | 21227 | 24588 | 222 |
1772240 | 1772240 | 2021-10-01 | Warren | Kentucky | 21227 | 24588 | 222 |
1768991 | 1768991 | 2021-09-30 | Warren | Kentucky | 21227 | 24480 | 222 |
1765742 | 1765742 | 2021-09-29 | Warren | Kentucky | 21227 | 24425 | 221 |
1762493 | 1762493 | 2021-09-28 | Warren | Kentucky | 21227 | 24332 | 218 |
1759245 | 1759245 | 2021-09-27 | Warren | Kentucky | 21227 | 24270 | 218 |
1755997 | 1755997 | 2021-09-26 | Warren | Kentucky | 21227 | 24078 | 218 |
1752749 | 1752749 | 2021-09-25 | Warren | Kentucky | 21227 | 24078 | 218 |
1749500 | 1749500 | 2021-09-24 | Warren | Kentucky | 21227 | 24078 | 218 |
1746250 | 1746250 | 2021-09-23 | Warren | Kentucky | 21227 | 23921 | 218 |
1743001 | 1743001 | 2021-09-22 | Warren | Kentucky | 21227 | 23759 | 218 |
1739752 | 1739752 | 2021-09-21 | Warren | Kentucky | 21227 | 23614 | 218 |
1736503 | 1736503 | 2021-09-20 | Warren | Kentucky | 21227 | 23477 | 218 |
1733253 | 1733253 | 2021-09-19 | Warren | Kentucky | 21227 | 23118 | 217 |
1730003 | 1730003 | 2021-09-18 | Warren | Kentucky | 21227 | 23118 | 217 |
1726753 | 1726753 | 2021-09-17 | Warren | Kentucky | 21227 | 23118 | 217 |
1723504 | 1723504 | 2021-09-16 | Warren | Kentucky | 21227 | 22907 | 216 |
1720255 | 1720255 | 2021-09-15 | Warren | Kentucky | 21227 | 22704 | 212 |
1717007 | 1717007 | 2021-09-14 | Warren | Kentucky | 21227 | 22472 | 207 |
1713761 | 1713761 | 2021-09-13 | Warren | Kentucky | 21227 | 22281 | 207 |
1710514 | 1710514 | 2021-09-12 | Warren | Kentucky | 21227 | 21938 | 204 |
1707267 | 1707267 | 2021-09-11 | Warren | Kentucky | 21227 | 21938 | 204 |
1704019 | 1704019 | 2021-09-10 | Warren | Kentucky | 21227 | 21938 | 204 |
1700769 | 1700769 | 2021-09-09 | Warren | Kentucky | 21227 | 21790 | 201 |
1697520 | 1697520 | 2021-09-08 | Warren | Kentucky | 21227 | 21613 | 201 |
1694272 | 1694272 | 2021-09-07 | Warren | Kentucky | 21227 | 21451 | 201 |
1691023 | 1691023 | 2021-09-06 | Warren | Kentucky | 21227 | 20974 | 201 |
1687773 | 1687773 | 2021-09-05 | Warren | Kentucky | 21227 | 20974 | 201 |
1684523 | 1684523 | 2021-09-04 | Warren | Kentucky | 21227 | 20974 | 201 |
1681272 | 1681272 | 2021-09-03 | Warren | Kentucky | 21227 | 20974 | 201 |
1678024 | 1678024 | 2021-09-02 | Warren | Kentucky | 21227 | 20784 | 199 |
1674777 | 1674777 | 2021-09-01 | Warren | Kentucky | 21227 | 20590 | 199 |
1671528 | 1671528 | 2021-08-31 | Warren | Kentucky | 21227 | 20428 | 199 |
1668281 | 1668281 | 2021-08-30 | Warren | Kentucky | 21227 | 20280 | 198 |
1665034 | 1665034 | 2021-08-29 | Warren | Kentucky | 21227 | 19961 | 198 |
1661786 | 1661786 | 2021-08-28 | Warren | Kentucky | 21227 | 19961 | 198 |
1658538 | 1658538 | 2021-08-27 | Warren | Kentucky | 21227 | 19961 | 198 |
1655290 | 1655290 | 2021-08-26 | Warren | Kentucky | 21227 | 19815 | 197 |
1652043 | 1652043 | 2021-08-25 | Warren | Kentucky | 21227 | 19611 | 197 |
1648794 | 1648794 | 2021-08-24 | Warren | Kentucky | 21227 | 19436 | 196 |
1645546 | 1645546 | 2021-08-23 | Warren | Kentucky | 21227 | 19259 | 196 |
1642297 | 1642297 | 2021-08-22 | Warren | Kentucky | 21227 | 18860 | 195 |
1639047 | 1639047 | 2021-08-21 | Warren | Kentucky | 21227 | 18860 | 195 |
1635797 | 1635797 | 2021-08-20 | Warren | Kentucky | 21227 | 18860 | 195 |
1632547 | 1632547 | 2021-08-19 | Warren | Kentucky | 21227 | 18715 | 195 |
1629300 | 1629300 | 2021-08-18 | Warren | Kentucky | 21227 | 18512 | 195 |
1626053 | 1626053 | 2021-08-17 | Warren | Kentucky | 21227 | 18347 | 195 |
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);