ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Perry" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814464 | 1814464 | 2021-10-14 | Perry | Kentucky | 21193 | 5943 | 87 |
1811215 | 1811215 | 2021-10-13 | Perry | Kentucky | 21193 | 5932 | 87 |
1807966 | 1807966 | 2021-10-12 | Perry | Kentucky | 21193 | 5915 | 87 |
1804715 | 1804715 | 2021-10-11 | Perry | Kentucky | 21193 | 5893 | 87 |
1801466 | 1801466 | 2021-10-10 | Perry | Kentucky | 21193 | 5852 | 84 |
1798217 | 1798217 | 2021-10-09 | Perry | Kentucky | 21193 | 5852 | 84 |
1794968 | 1794968 | 2021-10-08 | Perry | Kentucky | 21193 | 5852 | 84 |
1791720 | 1791720 | 2021-10-07 | Perry | Kentucky | 21193 | 5825 | 84 |
1788471 | 1788471 | 2021-10-06 | Perry | Kentucky | 21193 | 5790 | 84 |
1785222 | 1785222 | 2021-10-05 | Perry | Kentucky | 21193 | 5755 | 84 |
1781973 | 1781973 | 2021-10-04 | Perry | Kentucky | 21193 | 5706 | 84 |
1778723 | 1778723 | 2021-10-03 | Perry | Kentucky | 21193 | 5648 | 82 |
1775473 | 1775473 | 2021-10-02 | Perry | Kentucky | 21193 | 5648 | 82 |
1772223 | 1772223 | 2021-10-01 | Perry | Kentucky | 21193 | 5648 | 82 |
1768974 | 1768974 | 2021-09-30 | Perry | Kentucky | 21193 | 5593 | 82 |
1765725 | 1765725 | 2021-09-29 | Perry | Kentucky | 21193 | 5575 | 81 |
1762476 | 1762476 | 2021-09-28 | Perry | Kentucky | 21193 | 5532 | 80 |
1759228 | 1759228 | 2021-09-27 | Perry | Kentucky | 21193 | 5493 | 77 |
1755980 | 1755980 | 2021-09-26 | Perry | Kentucky | 21193 | 5424 | 76 |
1752732 | 1752732 | 2021-09-25 | Perry | Kentucky | 21193 | 5424 | 76 |
1749483 | 1749483 | 2021-09-24 | Perry | Kentucky | 21193 | 5424 | 76 |
1746233 | 1746233 | 2021-09-23 | Perry | Kentucky | 21193 | 5379 | 76 |
1742984 | 1742984 | 2021-09-22 | Perry | Kentucky | 21193 | 5343 | 76 |
1739735 | 1739735 | 2021-09-21 | Perry | Kentucky | 21193 | 5293 | 76 |
1736486 | 1736486 | 2021-09-20 | Perry | Kentucky | 21193 | 5237 | 76 |
1733236 | 1733236 | 2021-09-19 | Perry | Kentucky | 21193 | 5122 | 76 |
1729986 | 1729986 | 2021-09-18 | Perry | Kentucky | 21193 | 5122 | 76 |
1726736 | 1726736 | 2021-09-17 | Perry | Kentucky | 21193 | 5122 | 76 |
1723487 | 1723487 | 2021-09-16 | Perry | Kentucky | 21193 | 5051 | 76 |
1720238 | 1720238 | 2021-09-15 | Perry | Kentucky | 21193 | 5000 | 76 |
1716990 | 1716990 | 2021-09-14 | Perry | Kentucky | 21193 | 4922 | 76 |
1713744 | 1713744 | 2021-09-13 | Perry | Kentucky | 21193 | 4881 | 76 |
1710497 | 1710497 | 2021-09-12 | Perry | Kentucky | 21193 | 4751 | 72 |
1707250 | 1707250 | 2021-09-11 | Perry | Kentucky | 21193 | 4751 | 72 |
1704002 | 1704002 | 2021-09-10 | Perry | Kentucky | 21193 | 4751 | 72 |
1700752 | 1700752 | 2021-09-09 | Perry | Kentucky | 21193 | 4679 | 72 |
1697503 | 1697503 | 2021-09-08 | Perry | Kentucky | 21193 | 4594 | 72 |
1694255 | 1694255 | 2021-09-07 | Perry | Kentucky | 21193 | 4524 | 72 |
1691006 | 1691006 | 2021-09-06 | Perry | Kentucky | 21193 | 4297 | 70 |
1687756 | 1687756 | 2021-09-05 | Perry | Kentucky | 21193 | 4297 | 70 |
1684506 | 1684506 | 2021-09-04 | Perry | Kentucky | 21193 | 4297 | 70 |
1681255 | 1681255 | 2021-09-03 | Perry | Kentucky | 21193 | 4297 | 70 |
1678007 | 1678007 | 2021-09-02 | Perry | Kentucky | 21193 | 4224 | 70 |
1674760 | 1674760 | 2021-09-01 | Perry | Kentucky | 21193 | 4129 | 70 |
1671511 | 1671511 | 2021-08-31 | Perry | Kentucky | 21193 | 4050 | 70 |
1668264 | 1668264 | 2021-08-30 | Perry | Kentucky | 21193 | 3980 | 70 |
1665017 | 1665017 | 2021-08-29 | Perry | Kentucky | 21193 | 3838 | 70 |
1661769 | 1661769 | 2021-08-28 | Perry | Kentucky | 21193 | 3838 | 70 |
1658521 | 1658521 | 2021-08-27 | Perry | Kentucky | 21193 | 3838 | 70 |
1655273 | 1655273 | 2021-08-26 | Perry | Kentucky | 21193 | 3718 | 70 |
1652026 | 1652026 | 2021-08-25 | Perry | Kentucky | 21193 | 3625 | 70 |
1648777 | 1648777 | 2021-08-24 | Perry | Kentucky | 21193 | 3610 | 69 |
1645529 | 1645529 | 2021-08-23 | Perry | Kentucky | 21193 | 3559 | 69 |
1642280 | 1642280 | 2021-08-22 | Perry | Kentucky | 21193 | 3455 | 68 |
1639030 | 1639030 | 2021-08-21 | Perry | Kentucky | 21193 | 3455 | 68 |
1635780 | 1635780 | 2021-08-20 | Perry | Kentucky | 21193 | 3455 | 68 |
1632530 | 1632530 | 2021-08-19 | Perry | Kentucky | 21193 | 3412 | 68 |
1629283 | 1629283 | 2021-08-18 | Perry | Kentucky | 21193 | 3372 | 68 |
1626036 | 1626036 | 2021-08-17 | Perry | Kentucky | 21193 | 3318 | 68 |
1622789 | 1622789 | 2021-08-16 | Perry | Kentucky | 21193 | 3276 | 68 |
1619542 | 1619542 | 2021-08-15 | Perry | Kentucky | 21193 | 3210 | 68 |
1616294 | 1616294 | 2021-08-14 | Perry | Kentucky | 21193 | 3210 | 68 |
1613045 | 1613045 | 2021-08-13 | Perry | Kentucky | 21193 | 3210 | 68 |
1609797 | 1609797 | 2021-08-12 | Perry | Kentucky | 21193 | 3156 | 68 |
1606548 | 1606548 | 2021-08-11 | Perry | Kentucky | 21193 | 3135 | 68 |
1603299 | 1603299 | 2021-08-10 | Perry | Kentucky | 21193 | 3117 | 66 |
1600050 | 1600050 | 2021-08-09 | Perry | Kentucky | 21193 | 3078 | 66 |
1596802 | 1596802 | 2021-08-08 | Perry | Kentucky | 21193 | 3045 | 66 |
1593553 | 1593553 | 2021-08-07 | Perry | Kentucky | 21193 | 3045 | 66 |
1590304 | 1590304 | 2021-08-06 | Perry | Kentucky | 21193 | 3045 | 66 |
1587055 | 1587055 | 2021-08-05 | Perry | Kentucky | 21193 | 3023 | 66 |
1583805 | 1583805 | 2021-08-04 | Perry | Kentucky | 21193 | 3000 | 66 |
1580555 | 1580555 | 2021-08-03 | Perry | Kentucky | 21193 | 2987 | 66 |
1577306 | 1577306 | 2021-08-02 | Perry | Kentucky | 21193 | 2963 | 66 |
1574058 | 1574058 | 2021-08-01 | Perry | Kentucky | 21193 | 2942 | 66 |
1570810 | 1570810 | 2021-07-31 | Perry | Kentucky | 21193 | 2942 | 66 |
1567562 | 1567562 | 2021-07-30 | Perry | Kentucky | 21193 | 2942 | 66 |
1564314 | 1564314 | 2021-07-29 | Perry | Kentucky | 21193 | 2929 | 66 |
1561066 | 1561066 | 2021-07-28 | Perry | Kentucky | 21193 | 2926 | 66 |
1557819 | 1557819 | 2021-07-27 | Perry | Kentucky | 21193 | 2909 | 66 |
1554572 | 1554572 | 2021-07-26 | Perry | Kentucky | 21193 | 2899 | 66 |
1551325 | 1551325 | 2021-07-25 | Perry | Kentucky | 21193 | 2876 | 66 |
1548078 | 1548078 | 2021-07-24 | Perry | Kentucky | 21193 | 2876 | 66 |
1544831 | 1544831 | 2021-07-23 | Perry | Kentucky | 21193 | 2876 | 66 |
1541583 | 1541583 | 2021-07-22 | Perry | Kentucky | 21193 | 2873 | 66 |
1538336 | 1538336 | 2021-07-21 | Perry | Kentucky | 21193 | 2866 | 66 |
1535088 | 1535088 | 2021-07-20 | Perry | Kentucky | 21193 | 2859 | 66 |
1531841 | 1531841 | 2021-07-19 | Perry | Kentucky | 21193 | 2842 | 66 |
1528594 | 1528594 | 2021-07-18 | Perry | Kentucky | 21193 | 2831 | 66 |
1525347 | 1525347 | 2021-07-17 | Perry | Kentucky | 21193 | 2831 | 66 |
1522099 | 1522099 | 2021-07-16 | Perry | Kentucky | 21193 | 2831 | 66 |
1518851 | 1518851 | 2021-07-15 | Perry | Kentucky | 21193 | 2828 | 66 |
1515604 | 1515604 | 2021-07-14 | Perry | Kentucky | 21193 | 2826 | 66 |
1512358 | 1512358 | 2021-07-13 | Perry | Kentucky | 21193 | 2819 | 66 |
1509111 | 1509111 | 2021-07-12 | Perry | Kentucky | 21193 | 2816 | 66 |
1505865 | 1505865 | 2021-07-11 | Perry | Kentucky | 21193 | 2811 | 66 |
1502619 | 1502619 | 2021-07-10 | Perry | Kentucky | 21193 | 2811 | 66 |
1499373 | 1499373 | 2021-07-09 | Perry | Kentucky | 21193 | 2811 | 66 |
1496126 | 1496126 | 2021-07-08 | Perry | Kentucky | 21193 | 2805 | 66 |
1492880 | 1492880 | 2021-07-07 | Perry | Kentucky | 21193 | 2802 | 66 |
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);