ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 21041 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811139 | 1811139 | 2021-10-13 | Carroll | Kentucky | 21041 | 1816 | 23 |
1807890 | 1807890 | 2021-10-12 | Carroll | Kentucky | 21041 | 1808 | 23 |
1804639 | 1804639 | 2021-10-11 | Carroll | Kentucky | 21041 | 1795 | 23 |
1801390 | 1801390 | 2021-10-10 | Carroll | Kentucky | 21041 | 1782 | 23 |
1798141 | 1798141 | 2021-10-09 | Carroll | Kentucky | 21041 | 1782 | 23 |
1794892 | 1794892 | 2021-10-08 | Carroll | Kentucky | 21041 | 1782 | 23 |
1791644 | 1791644 | 2021-10-07 | Carroll | Kentucky | 21041 | 1779 | 23 |
1788395 | 1788395 | 2021-10-06 | Carroll | Kentucky | 21041 | 1770 | 23 |
1785146 | 1785146 | 2021-10-05 | Carroll | Kentucky | 21041 | 1761 | 23 |
1781897 | 1781897 | 2021-10-04 | Carroll | Kentucky | 21041 | 1750 | 23 |
1778647 | 1778647 | 2021-10-03 | Carroll | Kentucky | 21041 | 1743 | 23 |
1775397 | 1775397 | 2021-10-02 | Carroll | Kentucky | 21041 | 1743 | 23 |
1772147 | 1772147 | 2021-10-01 | Carroll | Kentucky | 21041 | 1743 | 23 |
1768898 | 1768898 | 2021-09-30 | Carroll | Kentucky | 21041 | 1733 | 23 |
1765649 | 1765649 | 2021-09-29 | Carroll | Kentucky | 21041 | 1728 | 22 |
1762400 | 1762400 | 2021-09-28 | Carroll | Kentucky | 21041 | 1725 | 22 |
1759152 | 1759152 | 2021-09-27 | Carroll | Kentucky | 21041 | 1714 | 22 |
1755904 | 1755904 | 2021-09-26 | Carroll | Kentucky | 21041 | 1700 | 21 |
1752656 | 1752656 | 2021-09-25 | Carroll | Kentucky | 21041 | 1700 | 21 |
1749407 | 1749407 | 2021-09-24 | Carroll | Kentucky | 21041 | 1700 | 21 |
1746157 | 1746157 | 2021-09-23 | Carroll | Kentucky | 21041 | 1688 | 21 |
1742908 | 1742908 | 2021-09-22 | Carroll | Kentucky | 21041 | 1676 | 21 |
1739659 | 1739659 | 2021-09-21 | Carroll | Kentucky | 21041 | 1658 | 21 |
1736410 | 1736410 | 2021-09-20 | Carroll | Kentucky | 21041 | 1642 | 21 |
1733160 | 1733160 | 2021-09-19 | Carroll | Kentucky | 21041 | 1617 | 21 |
1729910 | 1729910 | 2021-09-18 | Carroll | Kentucky | 21041 | 1617 | 21 |
1726660 | 1726660 | 2021-09-17 | Carroll | Kentucky | 21041 | 1617 | 21 |
1723411 | 1723411 | 2021-09-16 | Carroll | Kentucky | 21041 | 1603 | 21 |
1720162 | 1720162 | 2021-09-15 | Carroll | Kentucky | 21041 | 1586 | 21 |
1716914 | 1716914 | 2021-09-14 | Carroll | Kentucky | 21041 | 1579 | 21 |
1713668 | 1713668 | 2021-09-13 | Carroll | Kentucky | 21041 | 1570 | 21 |
1710421 | 1710421 | 2021-09-12 | Carroll | Kentucky | 21041 | 1534 | 21 |
1707174 | 1707174 | 2021-09-11 | Carroll | Kentucky | 21041 | 1534 | 21 |
1703926 | 1703926 | 2021-09-10 | Carroll | Kentucky | 21041 | 1534 | 21 |
1700676 | 1700676 | 2021-09-09 | Carroll | Kentucky | 21041 | 1512 | 21 |
1697427 | 1697427 | 2021-09-08 | Carroll | Kentucky | 21041 | 1502 | 21 |
1694179 | 1694179 | 2021-09-07 | Carroll | Kentucky | 21041 | 1488 | 21 |
1690930 | 1690930 | 2021-09-06 | Carroll | Kentucky | 21041 | 1443 | 21 |
1687680 | 1687680 | 2021-09-05 | Carroll | Kentucky | 21041 | 1443 | 21 |
1684430 | 1684430 | 2021-09-04 | Carroll | Kentucky | 21041 | 1443 | 21 |
1681179 | 1681179 | 2021-09-03 | Carroll | Kentucky | 21041 | 1443 | 21 |
1677931 | 1677931 | 2021-09-02 | Carroll | Kentucky | 21041 | 1423 | 21 |
1674684 | 1674684 | 2021-09-01 | Carroll | Kentucky | 21041 | 1403 | 21 |
1671435 | 1671435 | 2021-08-31 | Carroll | Kentucky | 21041 | 1368 | 21 |
1668188 | 1668188 | 2021-08-30 | Carroll | Kentucky | 21041 | 1359 | 21 |
1664941 | 1664941 | 2021-08-29 | Carroll | Kentucky | 21041 | 1324 | 21 |
1661693 | 1661693 | 2021-08-28 | Carroll | Kentucky | 21041 | 1324 | 21 |
1658445 | 1658445 | 2021-08-27 | Carroll | Kentucky | 21041 | 1324 | 21 |
1655197 | 1655197 | 2021-08-26 | Carroll | Kentucky | 21041 | 1311 | 21 |
1651950 | 1651950 | 2021-08-25 | Carroll | Kentucky | 21041 | 1292 | 21 |
1648701 | 1648701 | 2021-08-24 | Carroll | Kentucky | 21041 | 1267 | 21 |
1645453 | 1645453 | 2021-08-23 | Carroll | Kentucky | 21041 | 1256 | 21 |
1642204 | 1642204 | 2021-08-22 | Carroll | Kentucky | 21041 | 1224 | 21 |
1638954 | 1638954 | 2021-08-21 | Carroll | Kentucky | 21041 | 1224 | 21 |
1635704 | 1635704 | 2021-08-20 | Carroll | Kentucky | 21041 | 1224 | 21 |
1632454 | 1632454 | 2021-08-19 | Carroll | Kentucky | 21041 | 1207 | 21 |
1629207 | 1629207 | 2021-08-18 | Carroll | Kentucky | 21041 | 1187 | 21 |
1625960 | 1625960 | 2021-08-17 | Carroll | Kentucky | 21041 | 1175 | 21 |
1622713 | 1622713 | 2021-08-16 | Carroll | Kentucky | 21041 | 1168 | 21 |
1619466 | 1619466 | 2021-08-15 | Carroll | Kentucky | 21041 | 1153 | 21 |
1616218 | 1616218 | 2021-08-14 | Carroll | Kentucky | 21041 | 1153 | 21 |
1612969 | 1612969 | 2021-08-13 | Carroll | Kentucky | 21041 | 1153 | 21 |
1609721 | 1609721 | 2021-08-12 | Carroll | Kentucky | 21041 | 1138 | 21 |
1606472 | 1606472 | 2021-08-11 | Carroll | Kentucky | 21041 | 1121 | 21 |
1603223 | 1603223 | 2021-08-10 | Carroll | Kentucky | 21041 | 1116 | 21 |
1599974 | 1599974 | 2021-08-09 | Carroll | Kentucky | 21041 | 1103 | 21 |
1596726 | 1596726 | 2021-08-08 | Carroll | Kentucky | 21041 | 1094 | 21 |
1593477 | 1593477 | 2021-08-07 | Carroll | Kentucky | 21041 | 1094 | 21 |
1590228 | 1590228 | 2021-08-06 | Carroll | Kentucky | 21041 | 1094 | 21 |
1586979 | 1586979 | 2021-08-05 | Carroll | Kentucky | 21041 | 1087 | 21 |
1583729 | 1583729 | 2021-08-04 | Carroll | Kentucky | 21041 | 1085 | 21 |
1580479 | 1580479 | 2021-08-03 | Carroll | Kentucky | 21041 | 1081 | 21 |
1577230 | 1577230 | 2021-08-02 | Carroll | Kentucky | 21041 | 1074 | 21 |
1573982 | 1573982 | 2021-08-01 | Carroll | Kentucky | 21041 | 1063 | 21 |
1570734 | 1570734 | 2021-07-31 | Carroll | Kentucky | 21041 | 1063 | 21 |
1567486 | 1567486 | 2021-07-30 | Carroll | Kentucky | 21041 | 1063 | 21 |
1564238 | 1564238 | 2021-07-29 | Carroll | Kentucky | 21041 | 1062 | 21 |
1560990 | 1560990 | 2021-07-28 | Carroll | Kentucky | 21041 | 1057 | 21 |
1557743 | 1557743 | 2021-07-27 | Carroll | Kentucky | 21041 | 1052 | 21 |
1554496 | 1554496 | 2021-07-26 | Carroll | Kentucky | 21041 | 1050 | 21 |
1551249 | 1551249 | 2021-07-25 | Carroll | Kentucky | 21041 | 1049 | 21 |
1548002 | 1548002 | 2021-07-24 | Carroll | Kentucky | 21041 | 1049 | 21 |
1544755 | 1544755 | 2021-07-23 | Carroll | Kentucky | 21041 | 1049 | 21 |
1541507 | 1541507 | 2021-07-22 | Carroll | Kentucky | 21041 | 1049 | 21 |
1538260 | 1538260 | 2021-07-21 | Carroll | Kentucky | 21041 | 1049 | 21 |
1535012 | 1535012 | 2021-07-20 | Carroll | Kentucky | 21041 | 1049 | 21 |
1531765 | 1531765 | 2021-07-19 | Carroll | Kentucky | 21041 | 1048 | 21 |
1528518 | 1528518 | 2021-07-18 | Carroll | Kentucky | 21041 | 1047 | 21 |
1525271 | 1525271 | 2021-07-17 | Carroll | Kentucky | 21041 | 1047 | 21 |
1522023 | 1522023 | 2021-07-16 | Carroll | Kentucky | 21041 | 1047 | 21 |
1518775 | 1518775 | 2021-07-15 | Carroll | Kentucky | 21041 | 1046 | 21 |
1515528 | 1515528 | 2021-07-14 | Carroll | Kentucky | 21041 | 1046 | 21 |
1512282 | 1512282 | 2021-07-13 | Carroll | Kentucky | 21041 | 1046 | 21 |
1509035 | 1509035 | 2021-07-12 | Carroll | Kentucky | 21041 | 1045 | 21 |
1505789 | 1505789 | 2021-07-11 | Carroll | Kentucky | 21041 | 1045 | 21 |
1502543 | 1502543 | 2021-07-10 | Carroll | Kentucky | 21041 | 1045 | 21 |
1499297 | 1499297 | 2021-07-09 | Carroll | Kentucky | 21041 | 1045 | 21 |
1496050 | 1496050 | 2021-07-08 | Carroll | Kentucky | 21041 | 1045 | 21 |
1492804 | 1492804 | 2021-07-07 | Carroll | Kentucky | 21041 | 1044 | 21 |
1489557 | 1489557 | 2021-07-06 | Carroll | Kentucky | 21041 | 1043 | 21 |
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);