ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,297 rows where deaths = 9 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Simpson 89
- Ohio 77
- Knox 65
- Breathitt 61
- Carlisle 60
- Ballard 57
- Cumberland 55
- Green 54
- Perry 51
- Nicholas 46
- Gallatin 44
- Union 43
- Allen 42
- Leslie 36
- Knott 33
- Calloway 28
- Breckinridge 27
- Trimble 27
- Harrison 26
- Whitley 21
- Floyd 17
- Campbell 16
- Muhlenberg 16
- Edmonson 15
- Morgan 15
- Bullitt 14
- Fayette 14
- Washington 13
- Daviess 11
- Rowan 11
- …
state 1
- Kentucky · 1,297 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1937878 | 1937878 | 2021-11-21 | Elliott | Kentucky | 21063 | 1376 | 9 |
1934628 | 1934628 | 2021-11-20 | Elliott | Kentucky | 21063 | 1376 | 9 |
1931377 | 1931377 | 2021-11-19 | Elliott | Kentucky | 21063 | 1376 | 9 |
1928126 | 1928126 | 2021-11-18 | Elliott | Kentucky | 21063 | 1374 | 9 |
1924876 | 1924876 | 2021-11-17 | Elliott | Kentucky | 21063 | 1369 | 9 |
1872939 | 1872939 | 2021-11-01 | Morgan | Kentucky | 21175 | 2892 | 9 |
1869690 | 1869690 | 2021-10-31 | Morgan | Kentucky | 21175 | 2883 | 9 |
1866441 | 1866441 | 2021-10-30 | Morgan | Kentucky | 21175 | 2883 | 9 |
1863192 | 1863192 | 2021-10-29 | Morgan | Kentucky | 21175 | 2883 | 9 |
1859943 | 1859943 | 2021-10-28 | Morgan | Kentucky | 21175 | 2873 | 9 |
1856694 | 1856694 | 2021-10-27 | Morgan | Kentucky | 21175 | 2865 | 9 |
1853445 | 1853445 | 2021-10-26 | Morgan | Kentucky | 21175 | 2853 | 9 |
1850196 | 1850196 | 2021-10-25 | Morgan | Kentucky | 21175 | 2851 | 9 |
1846946 | 1846946 | 2021-10-24 | Morgan | Kentucky | 21175 | 2849 | 9 |
1843696 | 1843696 | 2021-10-23 | Morgan | Kentucky | 21175 | 2849 | 9 |
1840446 | 1840446 | 2021-10-22 | Morgan | Kentucky | 21175 | 2849 | 9 |
1837197 | 1837197 | 2021-10-21 | Morgan | Kentucky | 21175 | 2848 | 9 |
1833948 | 1833948 | 2021-10-20 | Morgan | Kentucky | 21175 | 2842 | 9 |
1830699 | 1830699 | 2021-10-19 | Morgan | Kentucky | 21175 | 2840 | 9 |
1827450 | 1827450 | 2021-10-18 | Morgan | Kentucky | 21175 | 2829 | 9 |
1801488 | 1801488 | 2021-10-10 | Wolfe | Kentucky | 21237 | 1145 | 9 |
1798239 | 1798239 | 2021-10-09 | Wolfe | Kentucky | 21237 | 1145 | 9 |
1794990 | 1794990 | 2021-10-08 | Wolfe | Kentucky | 21237 | 1145 | 9 |
1791742 | 1791742 | 2021-10-07 | Wolfe | Kentucky | 21237 | 1140 | 9 |
1778738 | 1778738 | 2021-10-03 | Trimble | Kentucky | 21223 | 1109 | 9 |
1775488 | 1775488 | 2021-10-02 | Trimble | Kentucky | 21223 | 1109 | 9 |
1772238 | 1772238 | 2021-10-01 | Trimble | Kentucky | 21223 | 1109 | 9 |
1768989 | 1768989 | 2021-09-30 | Trimble | Kentucky | 21223 | 1102 | 9 |
1765740 | 1765740 | 2021-09-29 | Trimble | Kentucky | 21223 | 1102 | 9 |
1762491 | 1762491 | 2021-09-28 | Trimble | Kentucky | 21223 | 1096 | 9 |
1759243 | 1759243 | 2021-09-27 | Trimble | Kentucky | 21223 | 1094 | 9 |
1755995 | 1755995 | 2021-09-26 | Trimble | Kentucky | 21223 | 1086 | 9 |
1752747 | 1752747 | 2021-09-25 | Trimble | Kentucky | 21223 | 1086 | 9 |
1749498 | 1749498 | 2021-09-24 | Trimble | Kentucky | 21223 | 1086 | 9 |
1746248 | 1746248 | 2021-09-23 | Trimble | Kentucky | 21223 | 1079 | 9 |
1742999 | 1742999 | 2021-09-22 | Trimble | Kentucky | 21223 | 1074 | 9 |
1739750 | 1739750 | 2021-09-21 | Trimble | Kentucky | 21223 | 1074 | 9 |
1736501 | 1736501 | 2021-09-20 | Trimble | Kentucky | 21223 | 1068 | 9 |
1733251 | 1733251 | 2021-09-19 | Trimble | Kentucky | 21223 | 1055 | 9 |
1730001 | 1730001 | 2021-09-18 | Trimble | Kentucky | 21223 | 1055 | 9 |
1726751 | 1726751 | 2021-09-17 | Trimble | Kentucky | 21223 | 1055 | 9 |
1723502 | 1723502 | 2021-09-16 | Trimble | Kentucky | 21223 | 1051 | 9 |
1720253 | 1720253 | 2021-09-15 | Trimble | Kentucky | 21223 | 1046 | 9 |
1717005 | 1717005 | 2021-09-14 | Trimble | Kentucky | 21223 | 1038 | 9 |
1713743 | 1713743 | 2021-09-13 | Pendleton | Kentucky | 21191 | 1545 | 9 |
1713759 | 1713759 | 2021-09-13 | Trimble | Kentucky | 21223 | 1031 | 9 |
1710512 | 1710512 | 2021-09-12 | Trimble | Kentucky | 21223 | 1020 | 9 |
1707265 | 1707265 | 2021-09-11 | Trimble | Kentucky | 21223 | 1020 | 9 |
1704017 | 1704017 | 2021-09-10 | Trimble | Kentucky | 21223 | 1020 | 9 |
1700767 | 1700767 | 2021-09-09 | Trimble | Kentucky | 21223 | 1016 | 9 |
1697518 | 1697518 | 2021-09-08 | Trimble | Kentucky | 21223 | 1012 | 9 |
1694270 | 1694270 | 2021-09-07 | Trimble | Kentucky | 21223 | 1011 | 9 |
1690975 | 1690975 | 2021-09-06 | Leslie | Kentucky | 21131 | 1515 | 9 |
1687725 | 1687725 | 2021-09-05 | Leslie | Kentucky | 21131 | 1515 | 9 |
1684475 | 1684475 | 2021-09-04 | Leslie | Kentucky | 21131 | 1515 | 9 |
1681224 | 1681224 | 2021-09-03 | Leslie | Kentucky | 21131 | 1515 | 9 |
1677976 | 1677976 | 2021-09-02 | Leslie | Kentucky | 21131 | 1492 | 9 |
1674729 | 1674729 | 2021-09-01 | Leslie | Kentucky | 21131 | 1467 | 9 |
1671480 | 1671480 | 2021-08-31 | Leslie | Kentucky | 21131 | 1430 | 9 |
1668233 | 1668233 | 2021-08-30 | Leslie | Kentucky | 21131 | 1392 | 9 |
1664986 | 1664986 | 2021-08-29 | Leslie | Kentucky | 21131 | 1322 | 9 |
1665011 | 1665011 | 2021-08-29 | Nicholas | Kentucky | 21181 | 726 | 9 |
1661738 | 1661738 | 2021-08-28 | Leslie | Kentucky | 21131 | 1322 | 9 |
1661763 | 1661763 | 2021-08-28 | Nicholas | Kentucky | 21181 | 726 | 9 |
1658490 | 1658490 | 2021-08-27 | Leslie | Kentucky | 21131 | 1322 | 9 |
1658515 | 1658515 | 2021-08-27 | Nicholas | Kentucky | 21181 | 726 | 9 |
1655242 | 1655242 | 2021-08-26 | Leslie | Kentucky | 21131 | 1295 | 9 |
1655267 | 1655267 | 2021-08-26 | Nicholas | Kentucky | 21181 | 713 | 9 |
1651995 | 1651995 | 2021-08-25 | Leslie | Kentucky | 21131 | 1269 | 9 |
1652020 | 1652020 | 2021-08-25 | Nicholas | Kentucky | 21181 | 704 | 9 |
1648746 | 1648746 | 2021-08-24 | Leslie | Kentucky | 21131 | 1265 | 9 |
1648771 | 1648771 | 2021-08-24 | Nicholas | Kentucky | 21181 | 701 | 9 |
1645498 | 1645498 | 2021-08-23 | Leslie | Kentucky | 21131 | 1234 | 9 |
1645523 | 1645523 | 2021-08-23 | Nicholas | Kentucky | 21181 | 695 | 9 |
1642249 | 1642249 | 2021-08-22 | Leslie | Kentucky | 21131 | 1200 | 9 |
1642274 | 1642274 | 2021-08-22 | Nicholas | Kentucky | 21181 | 674 | 9 |
1638999 | 1638999 | 2021-08-21 | Leslie | Kentucky | 21131 | 1200 | 9 |
1639024 | 1639024 | 2021-08-21 | Nicholas | Kentucky | 21181 | 674 | 9 |
1635749 | 1635749 | 2021-08-20 | Leslie | Kentucky | 21131 | 1200 | 9 |
1635774 | 1635774 | 2021-08-20 | Nicholas | Kentucky | 21181 | 674 | 9 |
1632499 | 1632499 | 2021-08-19 | Leslie | Kentucky | 21131 | 1185 | 9 |
1632524 | 1632524 | 2021-08-19 | Nicholas | Kentucky | 21181 | 667 | 9 |
1629252 | 1629252 | 2021-08-18 | Leslie | Kentucky | 21131 | 1175 | 9 |
1629277 | 1629277 | 2021-08-18 | Nicholas | Kentucky | 21181 | 658 | 9 |
1626005 | 1626005 | 2021-08-17 | Leslie | Kentucky | 21131 | 1155 | 9 |
1626030 | 1626030 | 2021-08-17 | Nicholas | Kentucky | 21181 | 655 | 9 |
1622758 | 1622758 | 2021-08-16 | Leslie | Kentucky | 21131 | 1131 | 9 |
1622783 | 1622783 | 2021-08-16 | Nicholas | Kentucky | 21181 | 655 | 9 |
1619511 | 1619511 | 2021-08-15 | Leslie | Kentucky | 21131 | 1111 | 9 |
1619536 | 1619536 | 2021-08-15 | Nicholas | Kentucky | 21181 | 641 | 9 |
1616263 | 1616263 | 2021-08-14 | Leslie | Kentucky | 21131 | 1111 | 9 |
1616288 | 1616288 | 2021-08-14 | Nicholas | Kentucky | 21181 | 641 | 9 |
1613014 | 1613014 | 2021-08-13 | Leslie | Kentucky | 21131 | 1111 | 9 |
1613039 | 1613039 | 2021-08-13 | Nicholas | Kentucky | 21181 | 641 | 9 |
1609766 | 1609766 | 2021-08-12 | Leslie | Kentucky | 21131 | 1093 | 9 |
1609791 | 1609791 | 2021-08-12 | Nicholas | Kentucky | 21181 | 637 | 9 |
1606517 | 1606517 | 2021-08-11 | Leslie | Kentucky | 21131 | 1083 | 9 |
1606542 | 1606542 | 2021-08-11 | Nicholas | Kentucky | 21181 | 635 | 9 |
1603268 | 1603268 | 2021-08-10 | Leslie | Kentucky | 21131 | 1077 | 9 |
1603293 | 1603293 | 2021-08-10 | Nicholas | Kentucky | 21181 | 630 | 9 |
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);