ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 21151 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947670 | 1947670 | 2021-11-24 | Madison | Kentucky | 21151 | 16676 | 191 |
1944419 | 1944419 | 2021-11-23 | Madison | Kentucky | 21151 | 16619 | 191 |
1941169 | 1941169 | 2021-11-22 | Madison | Kentucky | 21151 | 16519 | 190 |
1937919 | 1937919 | 2021-11-21 | Madison | Kentucky | 21151 | 16462 | 190 |
1934669 | 1934669 | 2021-11-20 | Madison | Kentucky | 21151 | 16462 | 190 |
1931418 | 1931418 | 2021-11-19 | Madison | Kentucky | 21151 | 16462 | 190 |
1928167 | 1928167 | 2021-11-18 | Madison | Kentucky | 21151 | 16421 | 189 |
1924917 | 1924917 | 2021-11-17 | Madison | Kentucky | 21151 | 16367 | 188 |
1921668 | 1921668 | 2021-11-16 | Madison | Kentucky | 21151 | 16303 | 187 |
1918418 | 1918418 | 2021-11-15 | Madison | Kentucky | 21151 | 16231 | 187 |
1915168 | 1915168 | 2021-11-14 | Madison | Kentucky | 21151 | 16175 | 186 |
1911918 | 1911918 | 2021-11-13 | Madison | Kentucky | 21151 | 16175 | 186 |
1908669 | 1908669 | 2021-11-12 | Madison | Kentucky | 21151 | 16175 | 186 |
1905420 | 1905420 | 2021-11-11 | Madison | Kentucky | 21151 | 16116 | 179 |
1902170 | 1902170 | 2021-11-10 | Madison | Kentucky | 21151 | 16116 | 179 |
1898920 | 1898920 | 2021-11-09 | Madison | Kentucky | 21151 | 16078 | 177 |
1895670 | 1895670 | 2021-11-08 | Madison | Kentucky | 21151 | 16023 | 176 |
1892420 | 1892420 | 2021-11-07 | Madison | Kentucky | 21151 | 15992 | 167 |
1889170 | 1889170 | 2021-11-06 | Madison | Kentucky | 21151 | 15992 | 167 |
1885920 | 1885920 | 2021-11-05 | Madison | Kentucky | 21151 | 15992 | 167 |
1882671 | 1882671 | 2021-11-04 | Madison | Kentucky | 21151 | 15962 | 163 |
1879422 | 1879422 | 2021-11-03 | Madison | Kentucky | 21151 | 15945 | 162 |
1876173 | 1876173 | 2021-11-02 | Madison | Kentucky | 21151 | 15923 | 162 |
1872924 | 1872924 | 2021-11-01 | Madison | Kentucky | 21151 | 15880 | 162 |
1869675 | 1869675 | 2021-10-31 | Madison | Kentucky | 21151 | 15834 | 160 |
1866426 | 1866426 | 2021-10-30 | Madison | Kentucky | 21151 | 15834 | 160 |
1863177 | 1863177 | 2021-10-29 | Madison | Kentucky | 21151 | 15834 | 160 |
1859928 | 1859928 | 2021-10-28 | Madison | Kentucky | 21151 | 15813 | 160 |
1856679 | 1856679 | 2021-10-27 | Madison | Kentucky | 21151 | 15791 | 160 |
1853430 | 1853430 | 2021-10-26 | Madison | Kentucky | 21151 | 15771 | 158 |
1850181 | 1850181 | 2021-10-25 | Madison | Kentucky | 21151 | 15725 | 157 |
1846931 | 1846931 | 2021-10-24 | Madison | Kentucky | 21151 | 15702 | 153 |
1843681 | 1843681 | 2021-10-23 | Madison | Kentucky | 21151 | 15702 | 153 |
1840431 | 1840431 | 2021-10-22 | Madison | Kentucky | 21151 | 15702 | 153 |
1837182 | 1837182 | 2021-10-21 | Madison | Kentucky | 21151 | 15677 | 152 |
1833933 | 1833933 | 2021-10-20 | Madison | Kentucky | 21151 | 15649 | 152 |
1830684 | 1830684 | 2021-10-19 | Madison | Kentucky | 21151 | 15621 | 145 |
1827435 | 1827435 | 2021-10-18 | Madison | Kentucky | 21151 | 15579 | 145 |
1824186 | 1824186 | 2021-10-17 | Madison | Kentucky | 21151 | 15532 | 145 |
1820937 | 1820937 | 2021-10-16 | Madison | Kentucky | 21151 | 15532 | 145 |
1817688 | 1817688 | 2021-10-15 | Madison | Kentucky | 21151 | 15532 | 145 |
1814440 | 1814440 | 2021-10-14 | Madison | Kentucky | 21151 | 15493 | 145 |
1811191 | 1811191 | 2021-10-13 | Madison | Kentucky | 21151 | 15455 | 145 |
1807942 | 1807942 | 2021-10-12 | Madison | Kentucky | 21151 | 15416 | 144 |
1804691 | 1804691 | 2021-10-11 | Madison | Kentucky | 21151 | 15339 | 144 |
1801442 | 1801442 | 2021-10-10 | Madison | Kentucky | 21151 | 15236 | 144 |
1798193 | 1798193 | 2021-10-09 | Madison | Kentucky | 21151 | 15236 | 144 |
1794944 | 1794944 | 2021-10-08 | Madison | Kentucky | 21151 | 15236 | 144 |
1791696 | 1791696 | 2021-10-07 | Madison | Kentucky | 21151 | 15168 | 144 |
1788447 | 1788447 | 2021-10-06 | Madison | Kentucky | 21151 | 15117 | 144 |
1785198 | 1785198 | 2021-10-05 | Madison | Kentucky | 21151 | 15042 | 144 |
1781949 | 1781949 | 2021-10-04 | Madison | Kentucky | 21151 | 14979 | 144 |
1778699 | 1778699 | 2021-10-03 | Madison | Kentucky | 21151 | 14875 | 134 |
1775449 | 1775449 | 2021-10-02 | Madison | Kentucky | 21151 | 14875 | 134 |
1772199 | 1772199 | 2021-10-01 | Madison | Kentucky | 21151 | 14875 | 134 |
1768950 | 1768950 | 2021-09-30 | Madison | Kentucky | 21151 | 14792 | 133 |
1765701 | 1765701 | 2021-09-29 | Madison | Kentucky | 21151 | 14711 | 133 |
1762452 | 1762452 | 2021-09-28 | Madison | Kentucky | 21151 | 14627 | 133 |
1759204 | 1759204 | 2021-09-27 | Madison | Kentucky | 21151 | 14518 | 133 |
1755956 | 1755956 | 2021-09-26 | Madison | Kentucky | 21151 | 14380 | 127 |
1752708 | 1752708 | 2021-09-25 | Madison | Kentucky | 21151 | 14380 | 127 |
1749459 | 1749459 | 2021-09-24 | Madison | Kentucky | 21151 | 14380 | 127 |
1746209 | 1746209 | 2021-09-23 | Madison | Kentucky | 21151 | 14285 | 127 |
1742960 | 1742960 | 2021-09-22 | Madison | Kentucky | 21151 | 14140 | 126 |
1739711 | 1739711 | 2021-09-21 | Madison | Kentucky | 21151 | 13977 | 126 |
1736462 | 1736462 | 2021-09-20 | Madison | Kentucky | 21151 | 13880 | 126 |
1733212 | 1733212 | 2021-09-19 | Madison | Kentucky | 21151 | 13705 | 125 |
1729962 | 1729962 | 2021-09-18 | Madison | Kentucky | 21151 | 13705 | 125 |
1726712 | 1726712 | 2021-09-17 | Madison | Kentucky | 21151 | 13705 | 125 |
1723463 | 1723463 | 2021-09-16 | Madison | Kentucky | 21151 | 13557 | 124 |
1720214 | 1720214 | 2021-09-15 | Madison | Kentucky | 21151 | 13367 | 124 |
1716966 | 1716966 | 2021-09-14 | Madison | Kentucky | 21151 | 13131 | 124 |
1713720 | 1713720 | 2021-09-13 | Madison | Kentucky | 21151 | 12982 | 124 |
1710473 | 1710473 | 2021-09-12 | Madison | Kentucky | 21151 | 12733 | 121 |
1707226 | 1707226 | 2021-09-11 | Madison | Kentucky | 21151 | 12733 | 121 |
1703978 | 1703978 | 2021-09-10 | Madison | Kentucky | 21151 | 12733 | 121 |
1700728 | 1700728 | 2021-09-09 | Madison | Kentucky | 21151 | 12614 | 121 |
1697479 | 1697479 | 2021-09-08 | Madison | Kentucky | 21151 | 12488 | 119 |
1694231 | 1694231 | 2021-09-07 | Madison | Kentucky | 21151 | 12389 | 119 |
1690982 | 1690982 | 2021-09-06 | Madison | Kentucky | 21151 | 12120 | 118 |
1687732 | 1687732 | 2021-09-05 | Madison | Kentucky | 21151 | 12120 | 118 |
1684482 | 1684482 | 2021-09-04 | Madison | Kentucky | 21151 | 12120 | 118 |
1681231 | 1681231 | 2021-09-03 | Madison | Kentucky | 21151 | 12120 | 118 |
1677983 | 1677983 | 2021-09-02 | Madison | Kentucky | 21151 | 11994 | 118 |
1674736 | 1674736 | 2021-09-01 | Madison | Kentucky | 21151 | 11822 | 117 |
1671487 | 1671487 | 2021-08-31 | Madison | Kentucky | 21151 | 11744 | 117 |
1668240 | 1668240 | 2021-08-30 | Madison | Kentucky | 21151 | 11627 | 116 |
1664993 | 1664993 | 2021-08-29 | Madison | Kentucky | 21151 | 11456 | 116 |
1661745 | 1661745 | 2021-08-28 | Madison | Kentucky | 21151 | 11456 | 116 |
1658497 | 1658497 | 2021-08-27 | Madison | Kentucky | 21151 | 11456 | 116 |
1655249 | 1655249 | 2021-08-26 | Madison | Kentucky | 21151 | 11365 | 115 |
1652002 | 1652002 | 2021-08-25 | Madison | Kentucky | 21151 | 11253 | 115 |
1648753 | 1648753 | 2021-08-24 | Madison | Kentucky | 21151 | 11140 | 115 |
1645505 | 1645505 | 2021-08-23 | Madison | Kentucky | 21151 | 11058 | 115 |
1642256 | 1642256 | 2021-08-22 | Madison | Kentucky | 21151 | 10928 | 113 |
1639006 | 1639006 | 2021-08-21 | Madison | Kentucky | 21151 | 10928 | 113 |
1635756 | 1635756 | 2021-08-20 | Madison | Kentucky | 21151 | 10928 | 113 |
1632506 | 1632506 | 2021-08-19 | Madison | Kentucky | 21151 | 10866 | 113 |
1629259 | 1629259 | 2021-08-18 | Madison | Kentucky | 21151 | 10732 | 113 |
1626012 | 1626012 | 2021-08-17 | Madison | Kentucky | 21151 | 10661 | 113 |
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);