ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 21239 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811238 | 1811238 | 2021-10-13 | Woodford | Kentucky | 21239 | 3299 | 27 |
1807989 | 1807989 | 2021-10-12 | Woodford | Kentucky | 21239 | 3292 | 27 |
1804738 | 1804738 | 2021-10-11 | Woodford | Kentucky | 21239 | 3282 | 26 |
1801489 | 1801489 | 2021-10-10 | Woodford | Kentucky | 21239 | 3258 | 26 |
1798240 | 1798240 | 2021-10-09 | Woodford | Kentucky | 21239 | 3258 | 26 |
1794991 | 1794991 | 2021-10-08 | Woodford | Kentucky | 21239 | 3258 | 26 |
1791743 | 1791743 | 2021-10-07 | Woodford | Kentucky | 21239 | 3248 | 26 |
1788494 | 1788494 | 2021-10-06 | Woodford | Kentucky | 21239 | 3238 | 26 |
1785245 | 1785245 | 2021-10-05 | Woodford | Kentucky | 21239 | 3232 | 26 |
1781996 | 1781996 | 2021-10-04 | Woodford | Kentucky | 21239 | 3223 | 26 |
1778746 | 1778746 | 2021-10-03 | Woodford | Kentucky | 21239 | 3195 | 26 |
1775496 | 1775496 | 2021-10-02 | Woodford | Kentucky | 21239 | 3195 | 26 |
1772246 | 1772246 | 2021-10-01 | Woodford | Kentucky | 21239 | 3195 | 26 |
1768997 | 1768997 | 2021-09-30 | Woodford | Kentucky | 21239 | 3186 | 26 |
1765748 | 1765748 | 2021-09-29 | Woodford | Kentucky | 21239 | 3176 | 26 |
1762499 | 1762499 | 2021-09-28 | Woodford | Kentucky | 21239 | 3163 | 26 |
1759251 | 1759251 | 2021-09-27 | Woodford | Kentucky | 21239 | 3148 | 26 |
1756003 | 1756003 | 2021-09-26 | Woodford | Kentucky | 21239 | 3109 | 25 |
1752755 | 1752755 | 2021-09-25 | Woodford | Kentucky | 21239 | 3109 | 25 |
1749506 | 1749506 | 2021-09-24 | Woodford | Kentucky | 21239 | 3109 | 25 |
1746256 | 1746256 | 2021-09-23 | Woodford | Kentucky | 21239 | 3094 | 25 |
1743007 | 1743007 | 2021-09-22 | Woodford | Kentucky | 21239 | 3079 | 25 |
1739758 | 1739758 | 2021-09-21 | Woodford | Kentucky | 21239 | 3063 | 25 |
1736509 | 1736509 | 2021-09-20 | Woodford | Kentucky | 21239 | 3045 | 25 |
1733259 | 1733259 | 2021-09-19 | Woodford | Kentucky | 21239 | 2993 | 25 |
1730009 | 1730009 | 2021-09-18 | Woodford | Kentucky | 21239 | 2993 | 25 |
1726759 | 1726759 | 2021-09-17 | Woodford | Kentucky | 21239 | 2993 | 25 |
1723510 | 1723510 | 2021-09-16 | Woodford | Kentucky | 21239 | 2962 | 25 |
1720261 | 1720261 | 2021-09-15 | Woodford | Kentucky | 21239 | 2946 | 24 |
1717013 | 1717013 | 2021-09-14 | Woodford | Kentucky | 21239 | 2932 | 24 |
1713767 | 1713767 | 2021-09-13 | Woodford | Kentucky | 21239 | 2921 | 24 |
1710520 | 1710520 | 2021-09-12 | Woodford | Kentucky | 21239 | 2893 | 23 |
1707273 | 1707273 | 2021-09-11 | Woodford | Kentucky | 21239 | 2893 | 23 |
1704025 | 1704025 | 2021-09-10 | Woodford | Kentucky | 21239 | 2893 | 23 |
1700775 | 1700775 | 2021-09-09 | Woodford | Kentucky | 21239 | 2877 | 23 |
1697526 | 1697526 | 2021-09-08 | Woodford | Kentucky | 21239 | 2857 | 23 |
1694278 | 1694278 | 2021-09-07 | Woodford | Kentucky | 21239 | 2845 | 23 |
1691029 | 1691029 | 2021-09-06 | Woodford | Kentucky | 21239 | 2648 | 23 |
1687779 | 1687779 | 2021-09-05 | Woodford | Kentucky | 21239 | 2648 | 23 |
1684529 | 1684529 | 2021-09-04 | Woodford | Kentucky | 21239 | 2648 | 23 |
1681278 | 1681278 | 2021-09-03 | Woodford | Kentucky | 21239 | 2648 | 23 |
1678030 | 1678030 | 2021-09-02 | Woodford | Kentucky | 21239 | 2637 | 23 |
1674783 | 1674783 | 2021-09-01 | Woodford | Kentucky | 21239 | 2629 | 23 |
1671534 | 1671534 | 2021-08-31 | Woodford | Kentucky | 21239 | 2616 | 23 |
1668287 | 1668287 | 2021-08-30 | Woodford | Kentucky | 21239 | 2610 | 23 |
1665040 | 1665040 | 2021-08-29 | Woodford | Kentucky | 21239 | 2596 | 23 |
1661792 | 1661792 | 2021-08-28 | Woodford | Kentucky | 21239 | 2596 | 23 |
1658544 | 1658544 | 2021-08-27 | Woodford | Kentucky | 21239 | 2596 | 23 |
1655296 | 1655296 | 2021-08-26 | Woodford | Kentucky | 21239 | 2588 | 23 |
1652049 | 1652049 | 2021-08-25 | Woodford | Kentucky | 21239 | 2580 | 23 |
1648800 | 1648800 | 2021-08-24 | Woodford | Kentucky | 21239 | 2572 | 22 |
1645552 | 1645552 | 2021-08-23 | Woodford | Kentucky | 21239 | 2557 | 22 |
1642303 | 1642303 | 2021-08-22 | Woodford | Kentucky | 21239 | 2540 | 22 |
1639053 | 1639053 | 2021-08-21 | Woodford | Kentucky | 21239 | 2540 | 22 |
1635803 | 1635803 | 2021-08-20 | Woodford | Kentucky | 21239 | 2540 | 22 |
1632553 | 1632553 | 2021-08-19 | Woodford | Kentucky | 21239 | 2533 | 22 |
1629306 | 1629306 | 2021-08-18 | Woodford | Kentucky | 21239 | 2513 | 22 |
1626059 | 1626059 | 2021-08-17 | Woodford | Kentucky | 21239 | 2510 | 22 |
1622812 | 1622812 | 2021-08-16 | Woodford | Kentucky | 21239 | 2492 | 22 |
1619565 | 1619565 | 2021-08-15 | Woodford | Kentucky | 21239 | 2472 | 22 |
1616317 | 1616317 | 2021-08-14 | Woodford | Kentucky | 21239 | 2472 | 22 |
1613068 | 1613068 | 2021-08-13 | Woodford | Kentucky | 21239 | 2472 | 22 |
1609820 | 1609820 | 2021-08-12 | Woodford | Kentucky | 21239 | 2456 | 22 |
1606571 | 1606571 | 2021-08-11 | Woodford | Kentucky | 21239 | 2449 | 22 |
1603322 | 1603322 | 2021-08-10 | Woodford | Kentucky | 21239 | 2442 | 22 |
1600073 | 1600073 | 2021-08-09 | Woodford | Kentucky | 21239 | 2424 | 22 |
1596825 | 1596825 | 2021-08-08 | Woodford | Kentucky | 21239 | 2393 | 22 |
1593576 | 1593576 | 2021-08-07 | Woodford | Kentucky | 21239 | 2393 | 22 |
1590327 | 1590327 | 2021-08-06 | Woodford | Kentucky | 21239 | 2393 | 22 |
1587078 | 1587078 | 2021-08-05 | Woodford | Kentucky | 21239 | 2385 | 22 |
1583828 | 1583828 | 2021-08-04 | Woodford | Kentucky | 21239 | 2371 | 22 |
1580578 | 1580578 | 2021-08-03 | Woodford | Kentucky | 21239 | 2363 | 22 |
1577329 | 1577329 | 2021-08-02 | Woodford | Kentucky | 21239 | 2350 | 22 |
1574081 | 1574081 | 2021-08-01 | Woodford | Kentucky | 21239 | 2328 | 22 |
1570833 | 1570833 | 2021-07-31 | Woodford | Kentucky | 21239 | 2328 | 22 |
1567585 | 1567585 | 2021-07-30 | Woodford | Kentucky | 21239 | 2328 | 22 |
1564337 | 1564337 | 2021-07-29 | Woodford | Kentucky | 21239 | 2318 | 22 |
1561089 | 1561089 | 2021-07-28 | Woodford | Kentucky | 21239 | 2314 | 22 |
1557842 | 1557842 | 2021-07-27 | Woodford | Kentucky | 21239 | 2308 | 22 |
1554595 | 1554595 | 2021-07-26 | Woodford | Kentucky | 21239 | 2298 | 22 |
1551348 | 1551348 | 2021-07-25 | Woodford | Kentucky | 21239 | 2285 | 22 |
1548101 | 1548101 | 2021-07-24 | Woodford | Kentucky | 21239 | 2285 | 22 |
1544854 | 1544854 | 2021-07-23 | Woodford | Kentucky | 21239 | 2285 | 22 |
1541606 | 1541606 | 2021-07-22 | Woodford | Kentucky | 21239 | 2276 | 22 |
1538359 | 1538359 | 2021-07-21 | Woodford | Kentucky | 21239 | 2277 | 22 |
1535111 | 1535111 | 2021-07-20 | Woodford | Kentucky | 21239 | 2268 | 22 |
1531864 | 1531864 | 2021-07-19 | Woodford | Kentucky | 21239 | 2259 | 22 |
1528617 | 1528617 | 2021-07-18 | Woodford | Kentucky | 21239 | 2242 | 22 |
1525370 | 1525370 | 2021-07-17 | Woodford | Kentucky | 21239 | 2242 | 22 |
1522122 | 1522122 | 2021-07-16 | Woodford | Kentucky | 21239 | 2242 | 22 |
1518874 | 1518874 | 2021-07-15 | Woodford | Kentucky | 21239 | 2241 | 22 |
1515627 | 1515627 | 2021-07-14 | Woodford | Kentucky | 21239 | 2234 | 22 |
1512381 | 1512381 | 2021-07-13 | Woodford | Kentucky | 21239 | 2223 | 22 |
1509134 | 1509134 | 2021-07-12 | Woodford | Kentucky | 21239 | 2213 | 22 |
1505888 | 1505888 | 2021-07-11 | Woodford | Kentucky | 21239 | 2200 | 22 |
1502642 | 1502642 | 2021-07-10 | Woodford | Kentucky | 21239 | 2200 | 22 |
1499396 | 1499396 | 2021-07-09 | Woodford | Kentucky | 21239 | 2200 | 22 |
1496149 | 1496149 | 2021-07-08 | Woodford | Kentucky | 21239 | 2191 | 22 |
1492903 | 1492903 | 2021-07-07 | Woodford | Kentucky | 21239 | 2181 | 22 |
1489656 | 1489656 | 2021-07-06 | Woodford | Kentucky | 21239 | 2180 | 22 |
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);