ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
953 rows where deaths = 11 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Estill 74
- Grayson 66
- Martin 44
- Carlisle 40
- Franklin 37
- Knox 37
- Breathitt 36
- Edmonson 35
- Muhlenberg 31
- Laurel 30
- Perry 28
- Henry 23
- Marion 22
- Menifee 19
- Hancock 15
- Christian 14
- Morgan 14
- Wolfe 14
- Campbell 13
- McCracken 13
- Larue 12
- Union 12
- Mercer 11
- Ballard 10
- Gallatin 10
- Ohio 10
- Clark 9
- Grant 9
- Johnson 9
- Boone 8
- …
state 1
- Kentucky · 953 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1983385 | 1983385 | 2021-12-05 | Elliott | Kentucky | 21063 | 1400 | 11 |
1980135 | 1980135 | 2021-12-04 | Elliott | Kentucky | 21063 | 1400 | 11 |
1976885 | 1976885 | 2021-12-03 | Elliott | Kentucky | 21063 | 1400 | 11 |
1973636 | 1973636 | 2021-12-02 | Elliott | Kentucky | 21063 | 1399 | 11 |
1973692 | 1973692 | 2021-12-02 | Morgan | Kentucky | 21175 | 3011 | 11 |
1970442 | 1970442 | 2021-12-01 | Morgan | Kentucky | 21175 | 3009 | 11 |
1967192 | 1967192 | 2021-11-30 | Morgan | Kentucky | 21175 | 3004 | 11 |
1963940 | 1963940 | 2021-11-29 | Morgan | Kentucky | 21175 | 2993 | 11 |
1960689 | 1960689 | 2021-11-28 | Morgan | Kentucky | 21175 | 2987 | 11 |
1957438 | 1957438 | 2021-11-27 | Morgan | Kentucky | 21175 | 2987 | 11 |
1954187 | 1954187 | 2021-11-26 | Morgan | Kentucky | 21175 | 2987 | 11 |
1950936 | 1950936 | 2021-11-25 | Morgan | Kentucky | 21175 | 2987 | 11 |
1947685 | 1947685 | 2021-11-24 | Morgan | Kentucky | 21175 | 2987 | 11 |
1944434 | 1944434 | 2021-11-23 | Morgan | Kentucky | 21175 | 2983 | 11 |
1941184 | 1941184 | 2021-11-22 | Morgan | Kentucky | 21175 | 2976 | 11 |
1937934 | 1937934 | 2021-11-21 | Morgan | Kentucky | 21175 | 2954 | 11 |
1934684 | 1934684 | 2021-11-20 | Morgan | Kentucky | 21175 | 2954 | 11 |
1931433 | 1931433 | 2021-11-19 | Morgan | Kentucky | 21175 | 2954 | 11 |
1918357 | 1918357 | 2021-11-15 | Bracken | Kentucky | 21023 | 1189 | 11 |
1915107 | 1915107 | 2021-11-14 | Bracken | Kentucky | 21023 | 1180 | 11 |
1911857 | 1911857 | 2021-11-13 | Bracken | Kentucky | 21023 | 1180 | 11 |
1908608 | 1908608 | 2021-11-12 | Bracken | Kentucky | 21023 | 1180 | 11 |
1905359 | 1905359 | 2021-11-11 | Bracken | Kentucky | 21023 | 1172 | 11 |
1902109 | 1902109 | 2021-11-10 | Bracken | Kentucky | 21023 | 1172 | 11 |
1898859 | 1898859 | 2021-11-09 | Bracken | Kentucky | 21023 | 1163 | 11 |
1895716 | 1895716 | 2021-11-08 | Wolfe | Kentucky | 21237 | 1215 | 11 |
1892466 | 1892466 | 2021-11-07 | Wolfe | Kentucky | 21237 | 1209 | 11 |
1889216 | 1889216 | 2021-11-06 | Wolfe | Kentucky | 21237 | 1209 | 11 |
1885966 | 1885966 | 2021-11-05 | Wolfe | Kentucky | 21237 | 1209 | 11 |
1882717 | 1882717 | 2021-11-04 | Wolfe | Kentucky | 21237 | 1203 | 11 |
1879468 | 1879468 | 2021-11-03 | Wolfe | Kentucky | 21237 | 1201 | 11 |
1876219 | 1876219 | 2021-11-02 | Wolfe | Kentucky | 21237 | 1201 | 11 |
1872970 | 1872970 | 2021-11-01 | Wolfe | Kentucky | 21237 | 1197 | 11 |
1869622 | 1869622 | 2021-10-31 | Carlisle | Kentucky | 21039 | 638 | 11 |
1869721 | 1869721 | 2021-10-31 | Wolfe | Kentucky | 21237 | 1191 | 11 |
1866373 | 1866373 | 2021-10-30 | Carlisle | Kentucky | 21039 | 638 | 11 |
1866472 | 1866472 | 2021-10-30 | Wolfe | Kentucky | 21237 | 1191 | 11 |
1863124 | 1863124 | 2021-10-29 | Carlisle | Kentucky | 21039 | 638 | 11 |
1863223 | 1863223 | 2021-10-29 | Wolfe | Kentucky | 21237 | 1191 | 11 |
1859875 | 1859875 | 2021-10-28 | Carlisle | Kentucky | 21039 | 638 | 11 |
1859974 | 1859974 | 2021-10-28 | Wolfe | Kentucky | 21237 | 1189 | 11 |
1856626 | 1856626 | 2021-10-27 | Carlisle | Kentucky | 21039 | 635 | 11 |
1856725 | 1856725 | 2021-10-27 | Wolfe | Kentucky | 21237 | 1188 | 11 |
1853377 | 1853377 | 2021-10-26 | Carlisle | Kentucky | 21039 | 634 | 11 |
1853476 | 1853476 | 2021-10-26 | Wolfe | Kentucky | 21237 | 1186 | 11 |
1850128 | 1850128 | 2021-10-25 | Carlisle | Kentucky | 21039 | 629 | 11 |
1846878 | 1846878 | 2021-10-24 | Carlisle | Kentucky | 21039 | 626 | 11 |
1843628 | 1843628 | 2021-10-23 | Carlisle | Kentucky | 21039 | 626 | 11 |
1840378 | 1840378 | 2021-10-22 | Carlisle | Kentucky | 21039 | 626 | 11 |
1837129 | 1837129 | 2021-10-21 | Carlisle | Kentucky | 21039 | 624 | 11 |
1833880 | 1833880 | 2021-10-20 | Carlisle | Kentucky | 21039 | 623 | 11 |
1830631 | 1830631 | 2021-10-19 | Carlisle | Kentucky | 21039 | 621 | 11 |
1827382 | 1827382 | 2021-10-18 | Carlisle | Kentucky | 21039 | 619 | 11 |
1824133 | 1824133 | 2021-10-17 | Carlisle | Kentucky | 21039 | 618 | 11 |
1820884 | 1820884 | 2021-10-16 | Carlisle | Kentucky | 21039 | 618 | 11 |
1817635 | 1817635 | 2021-10-15 | Carlisle | Kentucky | 21039 | 618 | 11 |
1814387 | 1814387 | 2021-10-14 | Carlisle | Kentucky | 21039 | 617 | 11 |
1811138 | 1811138 | 2021-10-13 | Carlisle | Kentucky | 21039 | 611 | 11 |
1811230 | 1811230 | 2021-10-13 | Trimble | Kentucky | 21223 | 1152 | 11 |
1807889 | 1807889 | 2021-10-12 | Carlisle | Kentucky | 21039 | 609 | 11 |
1807981 | 1807981 | 2021-10-12 | Trimble | Kentucky | 21223 | 1150 | 11 |
1804638 | 1804638 | 2021-10-11 | Carlisle | Kentucky | 21039 | 609 | 11 |
1804730 | 1804730 | 2021-10-11 | Trimble | Kentucky | 21223 | 1149 | 11 |
1801389 | 1801389 | 2021-10-10 | Carlisle | Kentucky | 21039 | 601 | 11 |
1801481 | 1801481 | 2021-10-10 | Trimble | Kentucky | 21223 | 1142 | 11 |
1798140 | 1798140 | 2021-10-09 | Carlisle | Kentucky | 21039 | 601 | 11 |
1798232 | 1798232 | 2021-10-09 | Trimble | Kentucky | 21223 | 1142 | 11 |
1794891 | 1794891 | 2021-10-08 | Carlisle | Kentucky | 21039 | 601 | 11 |
1794983 | 1794983 | 2021-10-08 | Trimble | Kentucky | 21223 | 1142 | 11 |
1791643 | 1791643 | 2021-10-07 | Carlisle | Kentucky | 21039 | 600 | 11 |
1791735 | 1791735 | 2021-10-07 | Trimble | Kentucky | 21223 | 1137 | 11 |
1788394 | 1788394 | 2021-10-06 | Carlisle | Kentucky | 21039 | 598 | 11 |
1788486 | 1788486 | 2021-10-06 | Trimble | Kentucky | 21223 | 1132 | 11 |
1785145 | 1785145 | 2021-10-05 | Carlisle | Kentucky | 21039 | 597 | 11 |
1781896 | 1781896 | 2021-10-04 | Carlisle | Kentucky | 21039 | 596 | 11 |
1778646 | 1778646 | 2021-10-03 | Carlisle | Kentucky | 21039 | 596 | 11 |
1775396 | 1775396 | 2021-10-02 | Carlisle | Kentucky | 21039 | 596 | 11 |
1772146 | 1772146 | 2021-10-01 | Carlisle | Kentucky | 21039 | 596 | 11 |
1768897 | 1768897 | 2021-09-30 | Carlisle | Kentucky | 21039 | 596 | 11 |
1765648 | 1765648 | 2021-09-29 | Carlisle | Kentucky | 21039 | 595 | 11 |
1762399 | 1762399 | 2021-09-28 | Carlisle | Kentucky | 21039 | 595 | 11 |
1759151 | 1759151 | 2021-09-27 | Carlisle | Kentucky | 21039 | 594 | 11 |
1755903 | 1755903 | 2021-09-26 | Carlisle | Kentucky | 21039 | 593 | 11 |
1752655 | 1752655 | 2021-09-25 | Carlisle | Kentucky | 21039 | 593 | 11 |
1749406 | 1749406 | 2021-09-24 | Carlisle | Kentucky | 21039 | 593 | 11 |
1746156 | 1746156 | 2021-09-23 | Carlisle | Kentucky | 21039 | 590 | 11 |
1742907 | 1742907 | 2021-09-22 | Carlisle | Kentucky | 21039 | 589 | 11 |
1723456 | 1723456 | 2021-09-16 | Leslie | Kentucky | 21131 | 1770 | 11 |
1723486 | 1723486 | 2021-09-16 | Pendleton | Kentucky | 21191 | 1604 | 11 |
1720207 | 1720207 | 2021-09-15 | Leslie | Kentucky | 21131 | 1752 | 11 |
1720237 | 1720237 | 2021-09-15 | Pendleton | Kentucky | 21191 | 1591 | 11 |
1716959 | 1716959 | 2021-09-14 | Leslie | Kentucky | 21131 | 1736 | 11 |
1716989 | 1716989 | 2021-09-14 | Pendleton | Kentucky | 21191 | 1566 | 11 |
1713713 | 1713713 | 2021-09-13 | Leslie | Kentucky | 21131 | 1701 | 11 |
1674667 | 1674667 | 2021-09-01 | Ballard | Kentucky | 21007 | 531 | 11 |
1671418 | 1671418 | 2021-08-31 | Ballard | Kentucky | 21007 | 529 | 11 |
1668171 | 1668171 | 2021-08-30 | Ballard | Kentucky | 21007 | 528 | 11 |
1664924 | 1664924 | 2021-08-29 | Ballard | Kentucky | 21007 | 514 | 11 |
1661676 | 1661676 | 2021-08-28 | Ballard | Kentucky | 21007 | 514 | 11 |
1658428 | 1658428 | 2021-08-27 | Ballard | Kentucky | 21007 | 514 | 11 |
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);