ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,568 rows where deaths = 8 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Gallatin 127
- Bracken 110
- Nicholas 106
- Leslie 90
- Wolfe 55
- Ballard 52
- Clay 49
- Daviess 47
- Muhlenberg 44
- Breathitt 42
- Clark 41
- Whitley 40
- Todd 38
- Trigg 38
- Carlisle 37
- Allen 36
- Trimble 36
- Hardin 34
- Knox 32
- Cumberland 29
- Owen 27
- Calloway 22
- Perry 22
- Henry 21
- Grayson 18
- Simpson 17
- Montgomery 16
- Elliott 15
- Taylor 15
- Powell 14
- …
state 1
- Kentucky · 1,568 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1921627 | 1921627 | 2021-11-16 | Elliott | Kentucky | 21063 | 1363 | 8 |
1918377 | 1918377 | 2021-11-15 | Elliott | Kentucky | 21063 | 1359 | 8 |
1915127 | 1915127 | 2021-11-14 | Elliott | Kentucky | 21063 | 1357 | 8 |
1911877 | 1911877 | 2021-11-13 | Elliott | Kentucky | 21063 | 1357 | 8 |
1908628 | 1908628 | 2021-11-12 | Elliott | Kentucky | 21063 | 1357 | 8 |
1905379 | 1905379 | 2021-11-11 | Elliott | Kentucky | 21063 | 1356 | 8 |
1902129 | 1902129 | 2021-11-10 | Elliott | Kentucky | 21063 | 1356 | 8 |
1898879 | 1898879 | 2021-11-09 | Elliott | Kentucky | 21063 | 1353 | 8 |
1895629 | 1895629 | 2021-11-08 | Elliott | Kentucky | 21063 | 1351 | 8 |
1892379 | 1892379 | 2021-11-07 | Elliott | Kentucky | 21063 | 1350 | 8 |
1889129 | 1889129 | 2021-11-06 | Elliott | Kentucky | 21063 | 1350 | 8 |
1885879 | 1885879 | 2021-11-05 | Elliott | Kentucky | 21063 | 1350 | 8 |
1882630 | 1882630 | 2021-11-04 | Elliott | Kentucky | 21063 | 1349 | 8 |
1879381 | 1879381 | 2021-11-03 | Elliott | Kentucky | 21063 | 1347 | 8 |
1876132 | 1876132 | 2021-11-02 | Elliott | Kentucky | 21063 | 1343 | 8 |
1830623 | 1830623 | 2021-10-19 | Bracken | Kentucky | 21023 | 1084 | 8 |
1827374 | 1827374 | 2021-10-18 | Bracken | Kentucky | 21023 | 1075 | 8 |
1824125 | 1824125 | 2021-10-17 | Bracken | Kentucky | 21023 | 1075 | 8 |
1820876 | 1820876 | 2021-10-16 | Bracken | Kentucky | 21023 | 1075 | 8 |
1817627 | 1817627 | 2021-10-15 | Bracken | Kentucky | 21023 | 1075 | 8 |
1814379 | 1814379 | 2021-10-14 | Bracken | Kentucky | 21023 | 1071 | 8 |
1811130 | 1811130 | 2021-10-13 | Bracken | Kentucky | 21023 | 1065 | 8 |
1807881 | 1807881 | 2021-10-12 | Bracken | Kentucky | 21023 | 1059 | 8 |
1804630 | 1804630 | 2021-10-11 | Bracken | Kentucky | 21023 | 1053 | 8 |
1801381 | 1801381 | 2021-10-10 | Bracken | Kentucky | 21023 | 1049 | 8 |
1798132 | 1798132 | 2021-10-09 | Bracken | Kentucky | 21023 | 1049 | 8 |
1794883 | 1794883 | 2021-10-08 | Bracken | Kentucky | 21023 | 1049 | 8 |
1791635 | 1791635 | 2021-10-07 | Bracken | Kentucky | 21023 | 1046 | 8 |
1788386 | 1788386 | 2021-10-06 | Bracken | Kentucky | 21023 | 1040 | 8 |
1788493 | 1788493 | 2021-10-06 | Wolfe | Kentucky | 21237 | 1132 | 8 |
1785137 | 1785137 | 2021-10-05 | Bracken | Kentucky | 21023 | 1031 | 8 |
1785244 | 1785244 | 2021-10-05 | Wolfe | Kentucky | 21237 | 1125 | 8 |
1781888 | 1781888 | 2021-10-04 | Bracken | Kentucky | 21023 | 1028 | 8 |
1781995 | 1781995 | 2021-10-04 | Wolfe | Kentucky | 21237 | 1121 | 8 |
1778638 | 1778638 | 2021-10-03 | Bracken | Kentucky | 21023 | 1018 | 8 |
1778745 | 1778745 | 2021-10-03 | Wolfe | Kentucky | 21237 | 1105 | 8 |
1775388 | 1775388 | 2021-10-02 | Bracken | Kentucky | 21023 | 1018 | 8 |
1775495 | 1775495 | 2021-10-02 | Wolfe | Kentucky | 21237 | 1105 | 8 |
1772138 | 1772138 | 2021-10-01 | Bracken | Kentucky | 21023 | 1018 | 8 |
1772245 | 1772245 | 2021-10-01 | Wolfe | Kentucky | 21237 | 1105 | 8 |
1768889 | 1768889 | 2021-09-30 | Bracken | Kentucky | 21023 | 1013 | 8 |
1768996 | 1768996 | 2021-09-30 | Wolfe | Kentucky | 21237 | 1100 | 8 |
1765640 | 1765640 | 2021-09-29 | Bracken | Kentucky | 21023 | 1012 | 8 |
1765747 | 1765747 | 2021-09-29 | Wolfe | Kentucky | 21237 | 1096 | 8 |
1762391 | 1762391 | 2021-09-28 | Bracken | Kentucky | 21023 | 1007 | 8 |
1762498 | 1762498 | 2021-09-28 | Wolfe | Kentucky | 21237 | 1092 | 8 |
1759143 | 1759143 | 2021-09-27 | Bracken | Kentucky | 21023 | 999 | 8 |
1759250 | 1759250 | 2021-09-27 | Wolfe | Kentucky | 21237 | 1088 | 8 |
1755895 | 1755895 | 2021-09-26 | Bracken | Kentucky | 21023 | 984 | 8 |
1756002 | 1756002 | 2021-09-26 | Wolfe | Kentucky | 21237 | 1081 | 8 |
1752647 | 1752647 | 2021-09-25 | Bracken | Kentucky | 21023 | 984 | 8 |
1752754 | 1752754 | 2021-09-25 | Wolfe | Kentucky | 21237 | 1081 | 8 |
1749398 | 1749398 | 2021-09-24 | Bracken | Kentucky | 21023 | 984 | 8 |
1749505 | 1749505 | 2021-09-24 | Wolfe | Kentucky | 21237 | 1081 | 8 |
1746148 | 1746148 | 2021-09-23 | Bracken | Kentucky | 21023 | 973 | 8 |
1746255 | 1746255 | 2021-09-23 | Wolfe | Kentucky | 21237 | 1072 | 8 |
1742899 | 1742899 | 2021-09-22 | Bracken | Kentucky | 21023 | 968 | 8 |
1743006 | 1743006 | 2021-09-22 | Wolfe | Kentucky | 21237 | 1065 | 8 |
1739650 | 1739650 | 2021-09-21 | Bracken | Kentucky | 21023 | 957 | 8 |
1739757 | 1739757 | 2021-09-21 | Wolfe | Kentucky | 21237 | 1054 | 8 |
1736401 | 1736401 | 2021-09-20 | Bracken | Kentucky | 21023 | 946 | 8 |
1736508 | 1736508 | 2021-09-20 | Wolfe | Kentucky | 21237 | 1039 | 8 |
1733151 | 1733151 | 2021-09-19 | Bracken | Kentucky | 21023 | 931 | 8 |
1733258 | 1733258 | 2021-09-19 | Wolfe | Kentucky | 21237 | 1011 | 8 |
1729901 | 1729901 | 2021-09-18 | Bracken | Kentucky | 21023 | 931 | 8 |
1730008 | 1730008 | 2021-09-18 | Wolfe | Kentucky | 21237 | 1011 | 8 |
1726651 | 1726651 | 2021-09-17 | Bracken | Kentucky | 21023 | 931 | 8 |
1726758 | 1726758 | 2021-09-17 | Wolfe | Kentucky | 21237 | 1011 | 8 |
1723402 | 1723402 | 2021-09-16 | Bracken | Kentucky | 21023 | 931 | 8 |
1723509 | 1723509 | 2021-09-16 | Wolfe | Kentucky | 21237 | 1003 | 8 |
1720153 | 1720153 | 2021-09-15 | Bracken | Kentucky | 21023 | 922 | 8 |
1720260 | 1720260 | 2021-09-15 | Wolfe | Kentucky | 21237 | 986 | 8 |
1716905 | 1716905 | 2021-09-14 | Bracken | Kentucky | 21023 | 915 | 8 |
1717012 | 1717012 | 2021-09-14 | Wolfe | Kentucky | 21237 | 972 | 8 |
1713659 | 1713659 | 2021-09-13 | Bracken | Kentucky | 21023 | 899 | 8 |
1713766 | 1713766 | 2021-09-13 | Wolfe | Kentucky | 21237 | 953 | 8 |
1710412 | 1710412 | 2021-09-12 | Bracken | Kentucky | 21023 | 886 | 8 |
1710496 | 1710496 | 2021-09-12 | Pendleton | Kentucky | 21191 | 1522 | 8 |
1710519 | 1710519 | 2021-09-12 | Wolfe | Kentucky | 21237 | 922 | 8 |
1707165 | 1707165 | 2021-09-11 | Bracken | Kentucky | 21023 | 886 | 8 |
1707249 | 1707249 | 2021-09-11 | Pendleton | Kentucky | 21191 | 1522 | 8 |
1707272 | 1707272 | 2021-09-11 | Wolfe | Kentucky | 21237 | 922 | 8 |
1703917 | 1703917 | 2021-09-10 | Bracken | Kentucky | 21023 | 886 | 8 |
1704001 | 1704001 | 2021-09-10 | Pendleton | Kentucky | 21191 | 1522 | 8 |
1704024 | 1704024 | 2021-09-10 | Wolfe | Kentucky | 21237 | 922 | 8 |
1700667 | 1700667 | 2021-09-09 | Bracken | Kentucky | 21023 | 875 | 8 |
1700774 | 1700774 | 2021-09-09 | Wolfe | Kentucky | 21237 | 902 | 8 |
1697418 | 1697418 | 2021-09-08 | Bracken | Kentucky | 21023 | 866 | 8 |
1697525 | 1697525 | 2021-09-08 | Wolfe | Kentucky | 21237 | 892 | 8 |
1694170 | 1694170 | 2021-09-07 | Bracken | Kentucky | 21023 | 850 | 8 |
1694277 | 1694277 | 2021-09-07 | Wolfe | Kentucky | 21237 | 884 | 8 |
1690921 | 1690921 | 2021-09-06 | Bracken | Kentucky | 21023 | 843 | 8 |
1691021 | 1691021 | 2021-09-06 | Trimble | Kentucky | 21223 | 984 | 8 |
1691028 | 1691028 | 2021-09-06 | Wolfe | Kentucky | 21237 | 845 | 8 |
1687671 | 1687671 | 2021-09-05 | Bracken | Kentucky | 21023 | 843 | 8 |
1687771 | 1687771 | 2021-09-05 | Trimble | Kentucky | 21223 | 984 | 8 |
1687778 | 1687778 | 2021-09-05 | Wolfe | Kentucky | 21237 | 845 | 8 |
1684421 | 1684421 | 2021-09-04 | Bracken | Kentucky | 21023 | 843 | 8 |
1684521 | 1684521 | 2021-09-04 | Trimble | Kentucky | 21223 | 984 | 8 |
1684528 | 1684528 | 2021-09-04 | Wolfe | Kentucky | 21237 | 845 | 8 |
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);