ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,057 rows where deaths = 7 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Trimble 125
- Bracken 94
- Hickman 70
- Taylor 54
- Simpson 41
- Gallatin 34
- Owen 34
- Clark 33
- Wolfe 31
- Rockcastle 29
- Russell 28
- Elliott 26
- Allen 23
- Carroll 18
- Madison 18
- Metcalfe 18
- Oldham 18
- Laurel 17
- Muhlenberg 17
- Daviess 16
- Fayette 15
- Breathitt 14
- Leslie 13
- Marshall 13
- Nicholas 12
- Pulaski 12
- Perry 11
- Lyon 10
- Meade 10
- Breckinridge 9
- …
state 1
- Kentucky · 1,057 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1872883 | 1872883 | 2021-11-01 | Elliott | Kentucky | 21063 | 1343 | 7 |
1869634 | 1869634 | 2021-10-31 | Elliott | Kentucky | 21063 | 1339 | 7 |
1866385 | 1866385 | 2021-10-30 | Elliott | Kentucky | 21063 | 1339 | 7 |
1863136 | 1863136 | 2021-10-29 | Elliott | Kentucky | 21063 | 1339 | 7 |
1859887 | 1859887 | 2021-10-28 | Elliott | Kentucky | 21063 | 1337 | 7 |
1856638 | 1856638 | 2021-10-27 | Elliott | Kentucky | 21063 | 1335 | 7 |
1853389 | 1853389 | 2021-10-26 | Elliott | Kentucky | 21063 | 1314 | 7 |
1850140 | 1850140 | 2021-10-25 | Elliott | Kentucky | 21063 | 1311 | 7 |
1846890 | 1846890 | 2021-10-24 | Elliott | Kentucky | 21063 | 1309 | 7 |
1843640 | 1843640 | 2021-10-23 | Elliott | Kentucky | 21063 | 1309 | 7 |
1840390 | 1840390 | 2021-10-22 | Elliott | Kentucky | 21063 | 1309 | 7 |
1837141 | 1837141 | 2021-10-21 | Elliott | Kentucky | 21063 | 1309 | 7 |
1833892 | 1833892 | 2021-10-20 | Elliott | Kentucky | 21063 | 1307 | 7 |
1830643 | 1830643 | 2021-10-19 | Elliott | Kentucky | 21063 | 1307 | 7 |
1827394 | 1827394 | 2021-10-18 | Elliott | Kentucky | 21063 | 1303 | 7 |
1824145 | 1824145 | 2021-10-17 | Elliott | Kentucky | 21063 | 1300 | 7 |
1820896 | 1820896 | 2021-10-16 | Elliott | Kentucky | 21063 | 1300 | 7 |
1817647 | 1817647 | 2021-10-15 | Elliott | Kentucky | 21063 | 1300 | 7 |
1814399 | 1814399 | 2021-10-14 | Elliott | Kentucky | 21063 | 1299 | 7 |
1811150 | 1811150 | 2021-10-13 | Elliott | Kentucky | 21063 | 1296 | 7 |
1807901 | 1807901 | 2021-10-12 | Elliott | Kentucky | 21063 | 1290 | 7 |
1804650 | 1804650 | 2021-10-11 | Elliott | Kentucky | 21063 | 1284 | 7 |
1801401 | 1801401 | 2021-10-10 | Elliott | Kentucky | 21063 | 1279 | 7 |
1798152 | 1798152 | 2021-10-09 | Elliott | Kentucky | 21063 | 1279 | 7 |
1794903 | 1794903 | 2021-10-08 | Elliott | Kentucky | 21063 | 1279 | 7 |
1791655 | 1791655 | 2021-10-07 | Elliott | Kentucky | 21063 | 1278 | 7 |
1700751 | 1700751 | 2021-09-09 | Pendleton | Kentucky | 21191 | 1508 | 7 |
1697502 | 1697502 | 2021-09-08 | Pendleton | Kentucky | 21191 | 1493 | 7 |
1609819 | 1609819 | 2021-08-12 | Wolfe | Kentucky | 21237 | 600 | 7 |
1606570 | 1606570 | 2021-08-11 | Wolfe | Kentucky | 21237 | 595 | 7 |
1603321 | 1603321 | 2021-08-10 | Wolfe | Kentucky | 21237 | 591 | 7 |
1600072 | 1600072 | 2021-08-09 | Wolfe | Kentucky | 21237 | 579 | 7 |
1596824 | 1596824 | 2021-08-08 | Wolfe | Kentucky | 21237 | 571 | 7 |
1593575 | 1593575 | 2021-08-07 | Wolfe | Kentucky | 21237 | 571 | 7 |
1590326 | 1590326 | 2021-08-06 | Wolfe | Kentucky | 21237 | 571 | 7 |
1587077 | 1587077 | 2021-08-05 | Wolfe | Kentucky | 21237 | 566 | 7 |
1583827 | 1583827 | 2021-08-04 | Wolfe | Kentucky | 21237 | 563 | 7 |
1580577 | 1580577 | 2021-08-03 | Wolfe | Kentucky | 21237 | 562 | 7 |
1577328 | 1577328 | 2021-08-02 | Wolfe | Kentucky | 21237 | 556 | 7 |
1574073 | 1574073 | 2021-08-01 | Trimble | Kentucky | 21223 | 730 | 7 |
1574080 | 1574080 | 2021-08-01 | Wolfe | Kentucky | 21237 | 553 | 7 |
1570825 | 1570825 | 2021-07-31 | Trimble | Kentucky | 21223 | 730 | 7 |
1570832 | 1570832 | 2021-07-31 | Wolfe | Kentucky | 21237 | 553 | 7 |
1567577 | 1567577 | 2021-07-30 | Trimble | Kentucky | 21223 | 730 | 7 |
1567584 | 1567584 | 2021-07-30 | Wolfe | Kentucky | 21237 | 553 | 7 |
1564329 | 1564329 | 2021-07-29 | Trimble | Kentucky | 21223 | 729 | 7 |
1564336 | 1564336 | 2021-07-29 | Wolfe | Kentucky | 21237 | 553 | 7 |
1561081 | 1561081 | 2021-07-28 | Trimble | Kentucky | 21223 | 727 | 7 |
1561088 | 1561088 | 2021-07-28 | Wolfe | Kentucky | 21237 | 551 | 7 |
1557834 | 1557834 | 2021-07-27 | Trimble | Kentucky | 21223 | 722 | 7 |
1557841 | 1557841 | 2021-07-27 | Wolfe | Kentucky | 21237 | 550 | 7 |
1554587 | 1554587 | 2021-07-26 | Trimble | Kentucky | 21223 | 719 | 7 |
1554594 | 1554594 | 2021-07-26 | Wolfe | Kentucky | 21237 | 550 | 7 |
1551340 | 1551340 | 2021-07-25 | Trimble | Kentucky | 21223 | 717 | 7 |
1551347 | 1551347 | 2021-07-25 | Wolfe | Kentucky | 21237 | 550 | 7 |
1548093 | 1548093 | 2021-07-24 | Trimble | Kentucky | 21223 | 717 | 7 |
1548100 | 1548100 | 2021-07-24 | Wolfe | Kentucky | 21237 | 550 | 7 |
1544846 | 1544846 | 2021-07-23 | Trimble | Kentucky | 21223 | 717 | 7 |
1544853 | 1544853 | 2021-07-23 | Wolfe | Kentucky | 21237 | 550 | 7 |
1541598 | 1541598 | 2021-07-22 | Trimble | Kentucky | 21223 | 715 | 7 |
1541605 | 1541605 | 2021-07-22 | Wolfe | Kentucky | 21237 | 550 | 7 |
1538351 | 1538351 | 2021-07-21 | Trimble | Kentucky | 21223 | 714 | 7 |
1538358 | 1538358 | 2021-07-21 | Wolfe | Kentucky | 21237 | 550 | 7 |
1535103 | 1535103 | 2021-07-20 | Trimble | Kentucky | 21223 | 713 | 7 |
1535110 | 1535110 | 2021-07-20 | Wolfe | Kentucky | 21237 | 550 | 7 |
1531856 | 1531856 | 2021-07-19 | Trimble | Kentucky | 21223 | 711 | 7 |
1531863 | 1531863 | 2021-07-19 | Wolfe | Kentucky | 21237 | 549 | 7 |
1528609 | 1528609 | 2021-07-18 | Trimble | Kentucky | 21223 | 710 | 7 |
1528616 | 1528616 | 2021-07-18 | Wolfe | Kentucky | 21237 | 549 | 7 |
1525362 | 1525362 | 2021-07-17 | Trimble | Kentucky | 21223 | 710 | 7 |
1525369 | 1525369 | 2021-07-17 | Wolfe | Kentucky | 21237 | 549 | 7 |
1522114 | 1522114 | 2021-07-16 | Trimble | Kentucky | 21223 | 710 | 7 |
1522121 | 1522121 | 2021-07-16 | Wolfe | Kentucky | 21237 | 549 | 7 |
1518866 | 1518866 | 2021-07-15 | Trimble | Kentucky | 21223 | 710 | 7 |
1518873 | 1518873 | 2021-07-15 | Wolfe | Kentucky | 21237 | 548 | 7 |
1515619 | 1515619 | 2021-07-14 | Trimble | Kentucky | 21223 | 709 | 7 |
1515626 | 1515626 | 2021-07-14 | Wolfe | Kentucky | 21237 | 548 | 7 |
1512373 | 1512373 | 2021-07-13 | Trimble | Kentucky | 21223 | 708 | 7 |
1512380 | 1512380 | 2021-07-13 | Wolfe | Kentucky | 21237 | 548 | 7 |
1509126 | 1509126 | 2021-07-12 | Trimble | Kentucky | 21223 | 708 | 7 |
1505880 | 1505880 | 2021-07-11 | Trimble | Kentucky | 21223 | 708 | 7 |
1502634 | 1502634 | 2021-07-10 | Trimble | Kentucky | 21223 | 708 | 7 |
1499388 | 1499388 | 2021-07-09 | Trimble | Kentucky | 21223 | 708 | 7 |
1496141 | 1496141 | 2021-07-08 | Trimble | Kentucky | 21223 | 708 | 7 |
1492895 | 1492895 | 2021-07-07 | Trimble | Kentucky | 21223 | 708 | 7 |
1489648 | 1489648 | 2021-07-06 | Trimble | Kentucky | 21223 | 708 | 7 |
1486401 | 1486401 | 2021-07-05 | Trimble | Kentucky | 21223 | 707 | 7 |
1483155 | 1483155 | 2021-07-04 | Trimble | Kentucky | 21223 | 707 | 7 |
1479908 | 1479908 | 2021-07-03 | Trimble | Kentucky | 21223 | 707 | 7 |
1476662 | 1476662 | 2021-07-02 | Trimble | Kentucky | 21223 | 707 | 7 |
1473316 | 1473316 | 2021-07-01 | Bracken | Kentucky | 21023 | 673 | 7 |
1473416 | 1473416 | 2021-07-01 | Trimble | Kentucky | 21223 | 706 | 7 |
1470070 | 1470070 | 2021-06-30 | Bracken | Kentucky | 21023 | 673 | 7 |
1470170 | 1470170 | 2021-06-30 | Trimble | Kentucky | 21223 | 705 | 7 |
1466825 | 1466825 | 2021-06-29 | Bracken | Kentucky | 21023 | 674 | 7 |
1466925 | 1466925 | 2021-06-29 | Trimble | Kentucky | 21223 | 702 | 7 |
1463580 | 1463580 | 2021-06-28 | Bracken | Kentucky | 21023 | 674 | 7 |
1463680 | 1463680 | 2021-06-28 | Trimble | Kentucky | 21223 | 702 | 7 |
1460335 | 1460335 | 2021-06-27 | Bracken | Kentucky | 21023 | 672 | 7 |
1460435 | 1460435 | 2021-06-27 | Trimble | Kentucky | 21223 | 702 | 7 |
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);