ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 21141 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947668 | 1947668 | 2021-11-24 | Logan | Kentucky | 21141 | 5217 | 90 |
1944417 | 1944417 | 2021-11-23 | Logan | Kentucky | 21141 | 5207 | 90 |
1941167 | 1941167 | 2021-11-22 | Logan | Kentucky | 21141 | 5202 | 90 |
1937917 | 1937917 | 2021-11-21 | Logan | Kentucky | 21141 | 5178 | 89 |
1934667 | 1934667 | 2021-11-20 | Logan | Kentucky | 21141 | 5178 | 89 |
1931416 | 1931416 | 2021-11-19 | Logan | Kentucky | 21141 | 5178 | 89 |
1928165 | 1928165 | 2021-11-18 | Logan | Kentucky | 21141 | 5176 | 88 |
1924915 | 1924915 | 2021-11-17 | Logan | Kentucky | 21141 | 5170 | 88 |
1921666 | 1921666 | 2021-11-16 | Logan | Kentucky | 21141 | 5161 | 88 |
1918416 | 1918416 | 2021-11-15 | Logan | Kentucky | 21141 | 5160 | 88 |
1915166 | 1915166 | 2021-11-14 | Logan | Kentucky | 21141 | 5146 | 85 |
1911916 | 1911916 | 2021-11-13 | Logan | Kentucky | 21141 | 5146 | 85 |
1908667 | 1908667 | 2021-11-12 | Logan | Kentucky | 21141 | 5146 | 85 |
1905418 | 1905418 | 2021-11-11 | Logan | Kentucky | 21141 | 5134 | 85 |
1902168 | 1902168 | 2021-11-10 | Logan | Kentucky | 21141 | 5134 | 85 |
1898918 | 1898918 | 2021-11-09 | Logan | Kentucky | 21141 | 5130 | 84 |
1895668 | 1895668 | 2021-11-08 | Logan | Kentucky | 21141 | 5119 | 84 |
1892418 | 1892418 | 2021-11-07 | Logan | Kentucky | 21141 | 5111 | 83 |
1889168 | 1889168 | 2021-11-06 | Logan | Kentucky | 21141 | 5111 | 83 |
1885918 | 1885918 | 2021-11-05 | Logan | Kentucky | 21141 | 5111 | 83 |
1882669 | 1882669 | 2021-11-04 | Logan | Kentucky | 21141 | 5109 | 82 |
1879420 | 1879420 | 2021-11-03 | Logan | Kentucky | 21141 | 5108 | 81 |
1876171 | 1876171 | 2021-11-02 | Logan | Kentucky | 21141 | 5104 | 81 |
1872922 | 1872922 | 2021-11-01 | Logan | Kentucky | 21141 | 5100 | 81 |
1869673 | 1869673 | 2021-10-31 | Logan | Kentucky | 21141 | 5090 | 81 |
1866424 | 1866424 | 2021-10-30 | Logan | Kentucky | 21141 | 5090 | 81 |
1863175 | 1863175 | 2021-10-29 | Logan | Kentucky | 21141 | 5090 | 81 |
1859926 | 1859926 | 2021-10-28 | Logan | Kentucky | 21141 | 5085 | 81 |
1856677 | 1856677 | 2021-10-27 | Logan | Kentucky | 21141 | 5075 | 81 |
1853428 | 1853428 | 2021-10-26 | Logan | Kentucky | 21141 | 5067 | 81 |
1850179 | 1850179 | 2021-10-25 | Logan | Kentucky | 21141 | 5061 | 81 |
1846929 | 1846929 | 2021-10-24 | Logan | Kentucky | 21141 | 5044 | 81 |
1843679 | 1843679 | 2021-10-23 | Logan | Kentucky | 21141 | 5044 | 81 |
1840429 | 1840429 | 2021-10-22 | Logan | Kentucky | 21141 | 5044 | 81 |
1837180 | 1837180 | 2021-10-21 | Logan | Kentucky | 21141 | 5029 | 81 |
1833931 | 1833931 | 2021-10-20 | Logan | Kentucky | 21141 | 5027 | 81 |
1830682 | 1830682 | 2021-10-19 | Logan | Kentucky | 21141 | 5021 | 81 |
1827433 | 1827433 | 2021-10-18 | Logan | Kentucky | 21141 | 5013 | 81 |
1824184 | 1824184 | 2021-10-17 | Logan | Kentucky | 21141 | 4994 | 79 |
1820935 | 1820935 | 2021-10-16 | Logan | Kentucky | 21141 | 4994 | 79 |
1817686 | 1817686 | 2021-10-15 | Logan | Kentucky | 21141 | 4994 | 79 |
1814438 | 1814438 | 2021-10-14 | Logan | Kentucky | 21141 | 4989 | 79 |
1811189 | 1811189 | 2021-10-13 | Logan | Kentucky | 21141 | 4981 | 79 |
1807940 | 1807940 | 2021-10-12 | Logan | Kentucky | 21141 | 4975 | 79 |
1804689 | 1804689 | 2021-10-11 | Logan | Kentucky | 21141 | 4955 | 79 |
1801440 | 1801440 | 2021-10-10 | Logan | Kentucky | 21141 | 4937 | 79 |
1798191 | 1798191 | 2021-10-09 | Logan | Kentucky | 21141 | 4937 | 79 |
1794942 | 1794942 | 2021-10-08 | Logan | Kentucky | 21141 | 4937 | 79 |
1791694 | 1791694 | 2021-10-07 | Logan | Kentucky | 21141 | 4930 | 79 |
1788445 | 1788445 | 2021-10-06 | Logan | Kentucky | 21141 | 4911 | 79 |
1785196 | 1785196 | 2021-10-05 | Logan | Kentucky | 21141 | 4900 | 77 |
1781947 | 1781947 | 2021-10-04 | Logan | Kentucky | 21141 | 4893 | 77 |
1778697 | 1778697 | 2021-10-03 | Logan | Kentucky | 21141 | 4841 | 77 |
1775447 | 1775447 | 2021-10-02 | Logan | Kentucky | 21141 | 4841 | 77 |
1772197 | 1772197 | 2021-10-01 | Logan | Kentucky | 21141 | 4841 | 77 |
1768948 | 1768948 | 2021-09-30 | Logan | Kentucky | 21141 | 4811 | 77 |
1765699 | 1765699 | 2021-09-29 | Logan | Kentucky | 21141 | 4797 | 77 |
1762450 | 1762450 | 2021-09-28 | Logan | Kentucky | 21141 | 4785 | 77 |
1759202 | 1759202 | 2021-09-27 | Logan | Kentucky | 21141 | 4771 | 77 |
1755954 | 1755954 | 2021-09-26 | Logan | Kentucky | 21141 | 4723 | 77 |
1752706 | 1752706 | 2021-09-25 | Logan | Kentucky | 21141 | 4723 | 77 |
1749457 | 1749457 | 2021-09-24 | Logan | Kentucky | 21141 | 4723 | 77 |
1746207 | 1746207 | 2021-09-23 | Logan | Kentucky | 21141 | 4703 | 77 |
1742958 | 1742958 | 2021-09-22 | Logan | Kentucky | 21141 | 4678 | 77 |
1739709 | 1739709 | 2021-09-21 | Logan | Kentucky | 21141 | 4652 | 77 |
1736460 | 1736460 | 2021-09-20 | Logan | Kentucky | 21141 | 4629 | 77 |
1733210 | 1733210 | 2021-09-19 | Logan | Kentucky | 21141 | 4539 | 77 |
1729960 | 1729960 | 2021-09-18 | Logan | Kentucky | 21141 | 4539 | 77 |
1726710 | 1726710 | 2021-09-17 | Logan | Kentucky | 21141 | 4539 | 77 |
1723461 | 1723461 | 2021-09-16 | Logan | Kentucky | 21141 | 4492 | 77 |
1720212 | 1720212 | 2021-09-15 | Logan | Kentucky | 21141 | 4461 | 77 |
1716964 | 1716964 | 2021-09-14 | Logan | Kentucky | 21141 | 4427 | 77 |
1713718 | 1713718 | 2021-09-13 | Logan | Kentucky | 21141 | 4393 | 77 |
1710471 | 1710471 | 2021-09-12 | Logan | Kentucky | 21141 | 4293 | 77 |
1707224 | 1707224 | 2021-09-11 | Logan | Kentucky | 21141 | 4293 | 77 |
1703976 | 1703976 | 2021-09-10 | Logan | Kentucky | 21141 | 4293 | 77 |
1700726 | 1700726 | 2021-09-09 | Logan | Kentucky | 21141 | 4263 | 76 |
1697477 | 1697477 | 2021-09-08 | Logan | Kentucky | 21141 | 4238 | 77 |
1694229 | 1694229 | 2021-09-07 | Logan | Kentucky | 21141 | 4219 | 77 |
1690980 | 1690980 | 2021-09-06 | Logan | Kentucky | 21141 | 4095 | 77 |
1687730 | 1687730 | 2021-09-05 | Logan | Kentucky | 21141 | 4095 | 77 |
1684480 | 1684480 | 2021-09-04 | Logan | Kentucky | 21141 | 4095 | 77 |
1681229 | 1681229 | 2021-09-03 | Logan | Kentucky | 21141 | 4095 | 77 |
1677981 | 1677981 | 2021-09-02 | Logan | Kentucky | 21141 | 4068 | 77 |
1674734 | 1674734 | 2021-09-01 | Logan | Kentucky | 21141 | 4009 | 77 |
1671485 | 1671485 | 2021-08-31 | Logan | Kentucky | 21141 | 3968 | 77 |
1668238 | 1668238 | 2021-08-30 | Logan | Kentucky | 21141 | 3933 | 77 |
1664991 | 1664991 | 2021-08-29 | Logan | Kentucky | 21141 | 3855 | 77 |
1661743 | 1661743 | 2021-08-28 | Logan | Kentucky | 21141 | 3855 | 77 |
1658495 | 1658495 | 2021-08-27 | Logan | Kentucky | 21141 | 3855 | 77 |
1655247 | 1655247 | 2021-08-26 | Logan | Kentucky | 21141 | 3824 | 76 |
1652000 | 1652000 | 2021-08-25 | Logan | Kentucky | 21141 | 3773 | 76 |
1648751 | 1648751 | 2021-08-24 | Logan | Kentucky | 21141 | 3729 | 75 |
1645503 | 1645503 | 2021-08-23 | Logan | Kentucky | 21141 | 3705 | 75 |
1642254 | 1642254 | 2021-08-22 | Logan | Kentucky | 21141 | 3649 | 74 |
1639004 | 1639004 | 2021-08-21 | Logan | Kentucky | 21141 | 3649 | 74 |
1635754 | 1635754 | 2021-08-20 | Logan | Kentucky | 21141 | 3649 | 74 |
1632504 | 1632504 | 2021-08-19 | Logan | Kentucky | 21141 | 3616 | 74 |
1629257 | 1629257 | 2021-08-18 | Logan | Kentucky | 21141 | 3558 | 74 |
1626010 | 1626010 | 2021-08-17 | Logan | Kentucky | 21141 | 3530 | 74 |
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);