ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 21185 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947690 | 1947690 | 2021-11-24 | Oldham | Kentucky | 21185 | 10561 | 100 |
1944439 | 1944439 | 2021-11-23 | Oldham | Kentucky | 21185 | 10526 | 100 |
1941189 | 1941189 | 2021-11-22 | Oldham | Kentucky | 21185 | 10506 | 100 |
1937939 | 1937939 | 2021-11-21 | Oldham | Kentucky | 21185 | 10437 | 98 |
1934689 | 1934689 | 2021-11-20 | Oldham | Kentucky | 21185 | 10437 | 98 |
1931438 | 1931438 | 2021-11-19 | Oldham | Kentucky | 21185 | 10437 | 98 |
1928187 | 1928187 | 2021-11-18 | Oldham | Kentucky | 21185 | 10421 | 95 |
1924937 | 1924937 | 2021-11-17 | Oldham | Kentucky | 21185 | 10398 | 95 |
1921688 | 1921688 | 2021-11-16 | Oldham | Kentucky | 21185 | 10384 | 95 |
1918438 | 1918438 | 2021-11-15 | Oldham | Kentucky | 21185 | 10369 | 95 |
1915188 | 1915188 | 2021-11-14 | Oldham | Kentucky | 21185 | 10316 | 95 |
1911938 | 1911938 | 2021-11-13 | Oldham | Kentucky | 21185 | 10316 | 95 |
1908689 | 1908689 | 2021-11-12 | Oldham | Kentucky | 21185 | 10316 | 95 |
1905440 | 1905440 | 2021-11-11 | Oldham | Kentucky | 21185 | 10278 | 95 |
1902190 | 1902190 | 2021-11-10 | Oldham | Kentucky | 21185 | 10278 | 95 |
1898940 | 1898940 | 2021-11-09 | Oldham | Kentucky | 21185 | 10268 | 95 |
1895690 | 1895690 | 2021-11-08 | Oldham | Kentucky | 21185 | 10249 | 95 |
1892440 | 1892440 | 2021-11-07 | Oldham | Kentucky | 21185 | 10245 | 95 |
1889190 | 1889190 | 2021-11-06 | Oldham | Kentucky | 21185 | 10245 | 95 |
1885940 | 1885940 | 2021-11-05 | Oldham | Kentucky | 21185 | 10245 | 95 |
1882691 | 1882691 | 2021-11-04 | Oldham | Kentucky | 21185 | 10227 | 93 |
1879442 | 1879442 | 2021-11-03 | Oldham | Kentucky | 21185 | 10209 | 93 |
1876193 | 1876193 | 2021-11-02 | Oldham | Kentucky | 21185 | 10194 | 93 |
1872944 | 1872944 | 2021-11-01 | Oldham | Kentucky | 21185 | 10177 | 93 |
1869695 | 1869695 | 2021-10-31 | Oldham | Kentucky | 21185 | 10161 | 93 |
1866446 | 1866446 | 2021-10-30 | Oldham | Kentucky | 21185 | 10161 | 93 |
1863197 | 1863197 | 2021-10-29 | Oldham | Kentucky | 21185 | 10161 | 93 |
1859948 | 1859948 | 2021-10-28 | Oldham | Kentucky | 21185 | 10146 | 93 |
1856699 | 1856699 | 2021-10-27 | Oldham | Kentucky | 21185 | 10135 | 93 |
1853450 | 1853450 | 2021-10-26 | Oldham | Kentucky | 21185 | 10120 | 93 |
1850201 | 1850201 | 2021-10-25 | Oldham | Kentucky | 21185 | 10114 | 93 |
1846951 | 1846951 | 2021-10-24 | Oldham | Kentucky | 21185 | 10087 | 93 |
1843701 | 1843701 | 2021-10-23 | Oldham | Kentucky | 21185 | 10087 | 93 |
1840451 | 1840451 | 2021-10-22 | Oldham | Kentucky | 21185 | 10087 | 93 |
1837202 | 1837202 | 2021-10-21 | Oldham | Kentucky | 21185 | 10077 | 93 |
1833953 | 1833953 | 2021-10-20 | Oldham | Kentucky | 21185 | 10009 | 93 |
1830704 | 1830704 | 2021-10-19 | Oldham | Kentucky | 21185 | 9985 | 93 |
1827455 | 1827455 | 2021-10-18 | Oldham | Kentucky | 21185 | 9973 | 91 |
1824206 | 1824206 | 2021-10-17 | Oldham | Kentucky | 21185 | 9940 | 91 |
1820957 | 1820957 | 2021-10-16 | Oldham | Kentucky | 21185 | 9940 | 91 |
1817708 | 1817708 | 2021-10-15 | Oldham | Kentucky | 21185 | 9940 | 91 |
1814460 | 1814460 | 2021-10-14 | Oldham | Kentucky | 21185 | 9930 | 91 |
1811211 | 1811211 | 2021-10-13 | Oldham | Kentucky | 21185 | 9915 | 91 |
1807962 | 1807962 | 2021-10-12 | Oldham | Kentucky | 21185 | 9900 | 91 |
1804711 | 1804711 | 2021-10-11 | Oldham | Kentucky | 21185 | 9872 | 91 |
1801462 | 1801462 | 2021-10-10 | Oldham | Kentucky | 21185 | 9824 | 90 |
1798213 | 1798213 | 2021-10-09 | Oldham | Kentucky | 21185 | 9824 | 90 |
1794964 | 1794964 | 2021-10-08 | Oldham | Kentucky | 21185 | 9824 | 90 |
1791716 | 1791716 | 2021-10-07 | Oldham | Kentucky | 21185 | 9805 | 90 |
1788467 | 1788467 | 2021-10-06 | Oldham | Kentucky | 21185 | 9784 | 90 |
1785218 | 1785218 | 2021-10-05 | Oldham | Kentucky | 21185 | 9764 | 90 |
1781969 | 1781969 | 2021-10-04 | Oldham | Kentucky | 21185 | 9745 | 90 |
1778719 | 1778719 | 2021-10-03 | Oldham | Kentucky | 21185 | 9711 | 90 |
1775469 | 1775469 | 2021-10-02 | Oldham | Kentucky | 21185 | 9711 | 90 |
1772219 | 1772219 | 2021-10-01 | Oldham | Kentucky | 21185 | 9711 | 90 |
1768970 | 1768970 | 2021-09-30 | Oldham | Kentucky | 21185 | 9671 | 90 |
1765721 | 1765721 | 2021-09-29 | Oldham | Kentucky | 21185 | 9645 | 90 |
1762472 | 1762472 | 2021-09-28 | Oldham | Kentucky | 21185 | 9626 | 90 |
1759224 | 1759224 | 2021-09-27 | Oldham | Kentucky | 21185 | 9604 | 90 |
1755976 | 1755976 | 2021-09-26 | Oldham | Kentucky | 21185 | 9550 | 89 |
1752728 | 1752728 | 2021-09-25 | Oldham | Kentucky | 21185 | 9550 | 89 |
1749479 | 1749479 | 2021-09-24 | Oldham | Kentucky | 21185 | 9550 | 89 |
1746229 | 1746229 | 2021-09-23 | Oldham | Kentucky | 21185 | 9526 | 89 |
1742980 | 1742980 | 2021-09-22 | Oldham | Kentucky | 21185 | 9501 | 89 |
1739731 | 1739731 | 2021-09-21 | Oldham | Kentucky | 21185 | 9456 | 88 |
1736482 | 1736482 | 2021-09-20 | Oldham | Kentucky | 21185 | 9445 | 88 |
1733232 | 1733232 | 2021-09-19 | Oldham | Kentucky | 21185 | 9407 | 88 |
1729982 | 1729982 | 2021-09-18 | Oldham | Kentucky | 21185 | 9407 | 88 |
1726732 | 1726732 | 2021-09-17 | Oldham | Kentucky | 21185 | 9407 | 88 |
1723483 | 1723483 | 2021-09-16 | Oldham | Kentucky | 21185 | 9375 | 88 |
1720234 | 1720234 | 2021-09-15 | Oldham | Kentucky | 21185 | 9343 | 87 |
1716986 | 1716986 | 2021-09-14 | Oldham | Kentucky | 21185 | 9297 | 86 |
1713740 | 1713740 | 2021-09-13 | Oldham | Kentucky | 21185 | 9259 | 86 |
1710493 | 1710493 | 2021-09-12 | Oldham | Kentucky | 21185 | 9187 | 86 |
1707246 | 1707246 | 2021-09-11 | Oldham | Kentucky | 21185 | 9187 | 86 |
1703998 | 1703998 | 2021-09-10 | Oldham | Kentucky | 21185 | 9187 | 86 |
1700748 | 1700748 | 2021-09-09 | Oldham | Kentucky | 21185 | 9153 | 86 |
1697499 | 1697499 | 2021-09-08 | Oldham | Kentucky | 21185 | 9110 | 86 |
1694251 | 1694251 | 2021-09-07 | Oldham | Kentucky | 21185 | 9090 | 86 |
1691002 | 1691002 | 2021-09-06 | Oldham | Kentucky | 21185 | 8963 | 86 |
1687752 | 1687752 | 2021-09-05 | Oldham | Kentucky | 21185 | 8963 | 86 |
1684502 | 1684502 | 2021-09-04 | Oldham | Kentucky | 21185 | 8963 | 86 |
1681251 | 1681251 | 2021-09-03 | Oldham | Kentucky | 21185 | 8963 | 86 |
1678003 | 1678003 | 2021-09-02 | Oldham | Kentucky | 21185 | 8916 | 86 |
1674756 | 1674756 | 2021-09-01 | Oldham | Kentucky | 21185 | 8850 | 86 |
1671507 | 1671507 | 2021-08-31 | Oldham | Kentucky | 21185 | 8779 | 86 |
1668260 | 1668260 | 2021-08-30 | Oldham | Kentucky | 21185 | 8738 | 86 |
1665013 | 1665013 | 2021-08-29 | Oldham | Kentucky | 21185 | 8647 | 86 |
1661765 | 1661765 | 2021-08-28 | Oldham | Kentucky | 21185 | 8647 | 86 |
1658517 | 1658517 | 2021-08-27 | Oldham | Kentucky | 21185 | 8647 | 86 |
1655269 | 1655269 | 2021-08-26 | Oldham | Kentucky | 21185 | 8600 | 86 |
1652022 | 1652022 | 2021-08-25 | Oldham | Kentucky | 21185 | 8560 | 86 |
1648773 | 1648773 | 2021-08-24 | Oldham | Kentucky | 21185 | 8521 | 86 |
1645525 | 1645525 | 2021-08-23 | Oldham | Kentucky | 21185 | 8472 | 86 |
1642276 | 1642276 | 2021-08-22 | Oldham | Kentucky | 21185 | 8415 | 86 |
1639026 | 1639026 | 2021-08-21 | Oldham | Kentucky | 21185 | 8415 | 86 |
1635776 | 1635776 | 2021-08-20 | Oldham | Kentucky | 21185 | 8415 | 86 |
1632526 | 1632526 | 2021-08-19 | Oldham | Kentucky | 21185 | 8377 | 85 |
1629279 | 1629279 | 2021-08-18 | Oldham | Kentucky | 21185 | 8318 | 85 |
1626032 | 1626032 | 2021-08-17 | Oldham | Kentucky | 21185 | 8273 | 85 |
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);