ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 21173 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814454 | 1814454 | 2021-10-14 | Montgomery | Kentucky | 21173 | 4393 | 51 |
1811205 | 1811205 | 2021-10-13 | Montgomery | Kentucky | 21173 | 4385 | 51 |
1807956 | 1807956 | 2021-10-12 | Montgomery | Kentucky | 21173 | 4370 | 50 |
1804705 | 1804705 | 2021-10-11 | Montgomery | Kentucky | 21173 | 4330 | 50 |
1801456 | 1801456 | 2021-10-10 | Montgomery | Kentucky | 21173 | 4292 | 48 |
1798207 | 1798207 | 2021-10-09 | Montgomery | Kentucky | 21173 | 4292 | 48 |
1794958 | 1794958 | 2021-10-08 | Montgomery | Kentucky | 21173 | 4292 | 48 |
1791710 | 1791710 | 2021-10-07 | Montgomery | Kentucky | 21173 | 4282 | 47 |
1788461 | 1788461 | 2021-10-06 | Montgomery | Kentucky | 21173 | 4278 | 47 |
1785212 | 1785212 | 2021-10-05 | Montgomery | Kentucky | 21173 | 4272 | 47 |
1781963 | 1781963 | 2021-10-04 | Montgomery | Kentucky | 21173 | 4258 | 46 |
1778713 | 1778713 | 2021-10-03 | Montgomery | Kentucky | 21173 | 4239 | 45 |
1775463 | 1775463 | 2021-10-02 | Montgomery | Kentucky | 21173 | 4239 | 45 |
1772213 | 1772213 | 2021-10-01 | Montgomery | Kentucky | 21173 | 4239 | 45 |
1768964 | 1768964 | 2021-09-30 | Montgomery | Kentucky | 21173 | 4200 | 45 |
1765715 | 1765715 | 2021-09-29 | Montgomery | Kentucky | 21173 | 4190 | 45 |
1762466 | 1762466 | 2021-09-28 | Montgomery | Kentucky | 21173 | 4164 | 42 |
1759218 | 1759218 | 2021-09-27 | Montgomery | Kentucky | 21173 | 4155 | 38 |
1755970 | 1755970 | 2021-09-26 | Montgomery | Kentucky | 21173 | 4124 | 38 |
1752722 | 1752722 | 2021-09-25 | Montgomery | Kentucky | 21173 | 4124 | 38 |
1749473 | 1749473 | 2021-09-24 | Montgomery | Kentucky | 21173 | 4124 | 38 |
1746223 | 1746223 | 2021-09-23 | Montgomery | Kentucky | 21173 | 4105 | 38 |
1742974 | 1742974 | 2021-09-22 | Montgomery | Kentucky | 21173 | 4089 | 38 |
1739725 | 1739725 | 2021-09-21 | Montgomery | Kentucky | 21173 | 4079 | 38 |
1736476 | 1736476 | 2021-09-20 | Montgomery | Kentucky | 21173 | 4066 | 37 |
1733226 | 1733226 | 2021-09-19 | Montgomery | Kentucky | 21173 | 4025 | 37 |
1729976 | 1729976 | 2021-09-18 | Montgomery | Kentucky | 21173 | 4025 | 37 |
1726726 | 1726726 | 2021-09-17 | Montgomery | Kentucky | 21173 | 4025 | 37 |
1723477 | 1723477 | 2021-09-16 | Montgomery | Kentucky | 21173 | 3990 | 37 |
1720228 | 1720228 | 2021-09-15 | Montgomery | Kentucky | 21173 | 3943 | 37 |
1716980 | 1716980 | 2021-09-14 | Montgomery | Kentucky | 21173 | 3932 | 36 |
1713734 | 1713734 | 2021-09-13 | Montgomery | Kentucky | 21173 | 3923 | 36 |
1710487 | 1710487 | 2021-09-12 | Montgomery | Kentucky | 21173 | 3872 | 36 |
1707240 | 1707240 | 2021-09-11 | Montgomery | Kentucky | 21173 | 3872 | 36 |
1703992 | 1703992 | 2021-09-10 | Montgomery | Kentucky | 21173 | 3872 | 36 |
1700742 | 1700742 | 2021-09-09 | Montgomery | Kentucky | 21173 | 3845 | 36 |
1697493 | 1697493 | 2021-09-08 | Montgomery | Kentucky | 21173 | 3809 | 36 |
1694245 | 1694245 | 2021-09-07 | Montgomery | Kentucky | 21173 | 3794 | 36 |
1690996 | 1690996 | 2021-09-06 | Montgomery | Kentucky | 21173 | 3710 | 35 |
1687746 | 1687746 | 2021-09-05 | Montgomery | Kentucky | 21173 | 3710 | 35 |
1684496 | 1684496 | 2021-09-04 | Montgomery | Kentucky | 21173 | 3710 | 35 |
1681245 | 1681245 | 2021-09-03 | Montgomery | Kentucky | 21173 | 3710 | 35 |
1677997 | 1677997 | 2021-09-02 | Montgomery | Kentucky | 21173 | 3680 | 35 |
1674750 | 1674750 | 2021-09-01 | Montgomery | Kentucky | 21173 | 3659 | 35 |
1671501 | 1671501 | 2021-08-31 | Montgomery | Kentucky | 21173 | 3642 | 35 |
1668254 | 1668254 | 2021-08-30 | Montgomery | Kentucky | 21173 | 3625 | 35 |
1665007 | 1665007 | 2021-08-29 | Montgomery | Kentucky | 21173 | 3575 | 33 |
1661759 | 1661759 | 2021-08-28 | Montgomery | Kentucky | 21173 | 3575 | 33 |
1658511 | 1658511 | 2021-08-27 | Montgomery | Kentucky | 21173 | 3575 | 33 |
1655263 | 1655263 | 2021-08-26 | Montgomery | Kentucky | 21173 | 3553 | 33 |
1652016 | 1652016 | 2021-08-25 | Montgomery | Kentucky | 21173 | 3533 | 32 |
1648767 | 1648767 | 2021-08-24 | Montgomery | Kentucky | 21173 | 3499 | 32 |
1645519 | 1645519 | 2021-08-23 | Montgomery | Kentucky | 21173 | 3468 | 32 |
1642270 | 1642270 | 2021-08-22 | Montgomery | Kentucky | 21173 | 3414 | 32 |
1639020 | 1639020 | 2021-08-21 | Montgomery | Kentucky | 21173 | 3414 | 32 |
1635770 | 1635770 | 2021-08-20 | Montgomery | Kentucky | 21173 | 3414 | 32 |
1632520 | 1632520 | 2021-08-19 | Montgomery | Kentucky | 21173 | 3387 | 32 |
1629273 | 1629273 | 2021-08-18 | Montgomery | Kentucky | 21173 | 3366 | 32 |
1626026 | 1626026 | 2021-08-17 | Montgomery | Kentucky | 21173 | 3335 | 32 |
1622779 | 1622779 | 2021-08-16 | Montgomery | Kentucky | 21173 | 3296 | 32 |
1619532 | 1619532 | 2021-08-15 | Montgomery | Kentucky | 21173 | 3218 | 30 |
1616284 | 1616284 | 2021-08-14 | Montgomery | Kentucky | 21173 | 3218 | 30 |
1613035 | 1613035 | 2021-08-13 | Montgomery | Kentucky | 21173 | 3218 | 30 |
1609787 | 1609787 | 2021-08-12 | Montgomery | Kentucky | 21173 | 3179 | 30 |
1606538 | 1606538 | 2021-08-11 | Montgomery | Kentucky | 21173 | 3157 | 30 |
1603289 | 1603289 | 2021-08-10 | Montgomery | Kentucky | 21173 | 3124 | 30 |
1600040 | 1600040 | 2021-08-09 | Montgomery | Kentucky | 21173 | 3111 | 30 |
1596792 | 1596792 | 2021-08-08 | Montgomery | Kentucky | 21173 | 3051 | 30 |
1593543 | 1593543 | 2021-08-07 | Montgomery | Kentucky | 21173 | 3051 | 30 |
1590294 | 1590294 | 2021-08-06 | Montgomery | Kentucky | 21173 | 3051 | 30 |
1587045 | 1587045 | 2021-08-05 | Montgomery | Kentucky | 21173 | 3008 | 30 |
1583795 | 1583795 | 2021-08-04 | Montgomery | Kentucky | 21173 | 2992 | 30 |
1580545 | 1580545 | 2021-08-03 | Montgomery | Kentucky | 21173 | 2962 | 30 |
1577296 | 1577296 | 2021-08-02 | Montgomery | Kentucky | 21173 | 2951 | 30 |
1574048 | 1574048 | 2021-08-01 | Montgomery | Kentucky | 21173 | 2931 | 30 |
1570800 | 1570800 | 2021-07-31 | Montgomery | Kentucky | 21173 | 2931 | 30 |
1567552 | 1567552 | 2021-07-30 | Montgomery | Kentucky | 21173 | 2931 | 30 |
1564304 | 1564304 | 2021-07-29 | Montgomery | Kentucky | 21173 | 2919 | 30 |
1561056 | 1561056 | 2021-07-28 | Montgomery | Kentucky | 21173 | 2914 | 30 |
1557809 | 1557809 | 2021-07-27 | Montgomery | Kentucky | 21173 | 2903 | 30 |
1554562 | 1554562 | 2021-07-26 | Montgomery | Kentucky | 21173 | 2898 | 30 |
1551315 | 1551315 | 2021-07-25 | Montgomery | Kentucky | 21173 | 2891 | 30 |
1548068 | 1548068 | 2021-07-24 | Montgomery | Kentucky | 21173 | 2891 | 30 |
1544821 | 1544821 | 2021-07-23 | Montgomery | Kentucky | 21173 | 2891 | 30 |
1541573 | 1541573 | 2021-07-22 | Montgomery | Kentucky | 21173 | 2886 | 30 |
1538326 | 1538326 | 2021-07-21 | Montgomery | Kentucky | 21173 | 2885 | 30 |
1535078 | 1535078 | 2021-07-20 | Montgomery | Kentucky | 21173 | 2881 | 30 |
1531831 | 1531831 | 2021-07-19 | Montgomery | Kentucky | 21173 | 2876 | 30 |
1528584 | 1528584 | 2021-07-18 | Montgomery | Kentucky | 21173 | 2874 | 30 |
1525337 | 1525337 | 2021-07-17 | Montgomery | Kentucky | 21173 | 2874 | 30 |
1522089 | 1522089 | 2021-07-16 | Montgomery | Kentucky | 21173 | 2874 | 30 |
1518841 | 1518841 | 2021-07-15 | Montgomery | Kentucky | 21173 | 2873 | 30 |
1515594 | 1515594 | 2021-07-14 | Montgomery | Kentucky | 21173 | 2873 | 30 |
1512348 | 1512348 | 2021-07-13 | Montgomery | Kentucky | 21173 | 2872 | 30 |
1509101 | 1509101 | 2021-07-12 | Montgomery | Kentucky | 21173 | 2871 | 30 |
1505855 | 1505855 | 2021-07-11 | Montgomery | Kentucky | 21173 | 2870 | 30 |
1502609 | 1502609 | 2021-07-10 | Montgomery | Kentucky | 21173 | 2870 | 30 |
1499363 | 1499363 | 2021-07-09 | Montgomery | Kentucky | 21173 | 2870 | 30 |
1496116 | 1496116 | 2021-07-08 | Montgomery | Kentucky | 21173 | 2870 | 30 |
1492870 | 1492870 | 2021-07-07 | Montgomery | Kentucky | 21173 | 2869 | 30 |
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);