ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 21179 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175286 | 2175286 | 2022-02-02 | Nelson | Kentucky | 21179 | 13487 | 127 |
2172033 | 2172033 | 2022-02-01 | Nelson | Kentucky | 21179 | 13402 | 126 |
2168780 | 2168780 | 2022-01-31 | Nelson | Kentucky | 21179 | 13283 | 126 |
2165525 | 2165525 | 2022-01-30 | Nelson | Kentucky | 21179 | 13023 | 125 |
2162270 | 2162270 | 2022-01-29 | Nelson | Kentucky | 21179 | 13023 | 125 |
2159015 | 2159015 | 2022-01-28 | Nelson | Kentucky | 21179 | 13023 | 125 |
2155761 | 2155761 | 2022-01-27 | Nelson | Kentucky | 21179 | 12830 | 124 |
2152508 | 2152508 | 2022-01-26 | Nelson | Kentucky | 21179 | 12662 | 125 |
2149256 | 2149256 | 2022-01-25 | Nelson | Kentucky | 21179 | 12481 | 123 |
2146004 | 2146004 | 2022-01-24 | Nelson | Kentucky | 21179 | 12308 | 123 |
2142749 | 2142749 | 2022-01-23 | Nelson | Kentucky | 21179 | 11950 | 122 |
2139494 | 2139494 | 2022-01-22 | Nelson | Kentucky | 21179 | 11950 | 122 |
2136238 | 2136238 | 2022-01-21 | Nelson | Kentucky | 21179 | 11950 | 122 |
2132986 | 2132986 | 2022-01-20 | Nelson | Kentucky | 21179 | 11754 | 122 |
2129733 | 2129733 | 2022-01-19 | Nelson | Kentucky | 21179 | 11569 | 122 |
2126479 | 2126479 | 2022-01-18 | Nelson | Kentucky | 21179 | 11381 | 122 |
2123227 | 2123227 | 2022-01-17 | Nelson | Kentucky | 21179 | 10926 | 119 |
2119975 | 2119975 | 2022-01-16 | Nelson | Kentucky | 21179 | 10926 | 119 |
2116723 | 2116723 | 2022-01-15 | Nelson | Kentucky | 21179 | 10926 | 119 |
2113472 | 2113472 | 2022-01-14 | Nelson | Kentucky | 21179 | 10926 | 119 |
2110220 | 2110220 | 2022-01-13 | Nelson | Kentucky | 21179 | 10792 | 119 |
2106969 | 2106969 | 2022-01-12 | Nelson | Kentucky | 21179 | 10685 | 117 |
2103718 | 2103718 | 2022-01-11 | Nelson | Kentucky | 21179 | 10567 | 116 |
2100467 | 2100467 | 2022-01-10 | Nelson | Kentucky | 21179 | 10440 | 112 |
2097216 | 2097216 | 2022-01-09 | Nelson | Kentucky | 21179 | 10256 | 112 |
2093964 | 2093964 | 2022-01-08 | Nelson | Kentucky | 21179 | 10256 | 112 |
2090712 | 2090712 | 2022-01-07 | Nelson | Kentucky | 21179 | 10256 | 112 |
2087461 | 2087461 | 2022-01-06 | Nelson | Kentucky | 21179 | 10175 | 112 |
2084209 | 2084209 | 2022-01-05 | Nelson | Kentucky | 21179 | 10072 | 111 |
2080957 | 2080957 | 2022-01-04 | Nelson | Kentucky | 21179 | 9941 | 111 |
2077705 | 2077705 | 2022-01-03 | Nelson | Kentucky | 21179 | 9835 | 111 |
2074454 | 2074454 | 2022-01-02 | Nelson | Kentucky | 21179 | 9636 | 110 |
2071203 | 2071203 | 2022-01-01 | Nelson | Kentucky | 21179 | 9636 | 110 |
2067952 | 2067952 | 2021-12-31 | Nelson | Kentucky | 21179 | 9636 | 110 |
2064701 | 2064701 | 2021-12-30 | Nelson | Kentucky | 21179 | 9636 | 110 |
2061451 | 2061451 | 2021-12-29 | Nelson | Kentucky | 21179 | 9636 | 110 |
2058202 | 2058202 | 2021-12-28 | Nelson | Kentucky | 21179 | 9589 | 110 |
2054953 | 2054953 | 2021-12-27 | Nelson | Kentucky | 21179 | 9527 | 110 |
2051703 | 2051703 | 2021-12-26 | Nelson | Kentucky | 21179 | 9430 | 109 |
2048453 | 2048453 | 2021-12-25 | Nelson | Kentucky | 21179 | 9430 | 109 |
2045203 | 2045203 | 2021-12-24 | Nelson | Kentucky | 21179 | 9430 | 109 |
2041954 | 2041954 | 2021-12-23 | Nelson | Kentucky | 21179 | 9430 | 109 |
2038704 | 2038704 | 2021-12-22 | Nelson | Kentucky | 21179 | 9430 | 109 |
2035454 | 2035454 | 2021-12-21 | Nelson | Kentucky | 21179 | 9399 | 108 |
2032204 | 2032204 | 2021-12-20 | Nelson | Kentucky | 21179 | 9350 | 108 |
2028953 | 2028953 | 2021-12-19 | Nelson | Kentucky | 21179 | 9308 | 107 |
2025702 | 2025702 | 2021-12-18 | Nelson | Kentucky | 21179 | 9308 | 107 |
2022451 | 2022451 | 2021-12-17 | Nelson | Kentucky | 21179 | 9308 | 107 |
2019200 | 2019200 | 2021-12-16 | Nelson | Kentucky | 21179 | 9278 | 107 |
2015950 | 2015950 | 2021-12-15 | Nelson | Kentucky | 21179 | 9256 | 107 |
2012699 | 2012699 | 2021-12-14 | Nelson | Kentucky | 21179 | 9210 | 107 |
2009448 | 2009448 | 2021-12-13 | Nelson | Kentucky | 21179 | 9168 | 107 |
2006197 | 2006197 | 2021-12-12 | Nelson | Kentucky | 21179 | 9111 | 107 |
2002946 | 2002946 | 2021-12-11 | Nelson | Kentucky | 21179 | 9111 | 107 |
1999696 | 1999696 | 2021-12-10 | Nelson | Kentucky | 21179 | 9111 | 107 |
1996445 | 1996445 | 2021-12-09 | Nelson | Kentucky | 21179 | 9088 | 107 |
1993194 | 1993194 | 2021-12-08 | Nelson | Kentucky | 21179 | 9053 | 107 |
1989943 | 1989943 | 2021-12-07 | Nelson | Kentucky | 21179 | 8990 | 104 |
1986693 | 1986693 | 2021-12-06 | Nelson | Kentucky | 21179 | 8961 | 104 |
1983443 | 1983443 | 2021-12-05 | Nelson | Kentucky | 21179 | 8906 | 101 |
1980193 | 1980193 | 2021-12-04 | Nelson | Kentucky | 21179 | 8906 | 101 |
1976943 | 1976943 | 2021-12-03 | Nelson | Kentucky | 21179 | 8906 | 101 |
1973694 | 1973694 | 2021-12-02 | Nelson | Kentucky | 21179 | 8882 | 101 |
1970444 | 1970444 | 2021-12-01 | Nelson | Kentucky | 21179 | 8844 | 101 |
1967194 | 1967194 | 2021-11-30 | Nelson | Kentucky | 21179 | 8804 | 101 |
1963942 | 1963942 | 2021-11-29 | Nelson | Kentucky | 21179 | 8764 | 101 |
1960691 | 1960691 | 2021-11-28 | Nelson | Kentucky | 21179 | 8712 | 101 |
1957440 | 1957440 | 2021-11-27 | Nelson | Kentucky | 21179 | 8712 | 101 |
1954189 | 1954189 | 2021-11-26 | Nelson | Kentucky | 21179 | 8712 | 101 |
1950938 | 1950938 | 2021-11-25 | Nelson | Kentucky | 21179 | 8712 | 101 |
1947687 | 1947687 | 2021-11-24 | Nelson | Kentucky | 21179 | 8712 | 101 |
1944436 | 1944436 | 2021-11-23 | Nelson | Kentucky | 21179 | 8688 | 101 |
1941186 | 1941186 | 2021-11-22 | Nelson | Kentucky | 21179 | 8674 | 101 |
1937936 | 1937936 | 2021-11-21 | Nelson | Kentucky | 21179 | 8635 | 99 |
1934686 | 1934686 | 2021-11-20 | Nelson | Kentucky | 21179 | 8635 | 99 |
1931435 | 1931435 | 2021-11-19 | Nelson | Kentucky | 21179 | 8635 | 99 |
1928184 | 1928184 | 2021-11-18 | Nelson | Kentucky | 21179 | 8631 | 98 |
1924934 | 1924934 | 2021-11-17 | Nelson | Kentucky | 21179 | 8603 | 97 |
1921685 | 1921685 | 2021-11-16 | Nelson | Kentucky | 21179 | 8572 | 97 |
1918435 | 1918435 | 2021-11-15 | Nelson | Kentucky | 21179 | 8552 | 97 |
1915185 | 1915185 | 2021-11-14 | Nelson | Kentucky | 21179 | 8525 | 96 |
1911935 | 1911935 | 2021-11-13 | Nelson | Kentucky | 21179 | 8525 | 96 |
1908686 | 1908686 | 2021-11-12 | Nelson | Kentucky | 21179 | 8525 | 96 |
1905437 | 1905437 | 2021-11-11 | Nelson | Kentucky | 21179 | 8500 | 96 |
1902187 | 1902187 | 2021-11-10 | Nelson | Kentucky | 21179 | 8500 | 96 |
1898937 | 1898937 | 2021-11-09 | Nelson | Kentucky | 21179 | 8478 | 95 |
1895687 | 1895687 | 2021-11-08 | Nelson | Kentucky | 21179 | 8456 | 95 |
1892437 | 1892437 | 2021-11-07 | Nelson | Kentucky | 21179 | 8439 | 93 |
1889187 | 1889187 | 2021-11-06 | Nelson | Kentucky | 21179 | 8439 | 93 |
1885937 | 1885937 | 2021-11-05 | Nelson | Kentucky | 21179 | 8439 | 93 |
1882688 | 1882688 | 2021-11-04 | Nelson | Kentucky | 21179 | 8416 | 91 |
1879439 | 1879439 | 2021-11-03 | Nelson | Kentucky | 21179 | 8400 | 90 |
1876190 | 1876190 | 2021-11-02 | Nelson | Kentucky | 21179 | 8378 | 90 |
1872941 | 1872941 | 2021-11-01 | Nelson | Kentucky | 21179 | 8355 | 90 |
1869692 | 1869692 | 2021-10-31 | Nelson | Kentucky | 21179 | 8335 | 88 |
1866443 | 1866443 | 2021-10-30 | Nelson | Kentucky | 21179 | 8335 | 88 |
1863194 | 1863194 | 2021-10-29 | Nelson | Kentucky | 21179 | 8335 | 88 |
1859945 | 1859945 | 2021-10-28 | Nelson | Kentucky | 21179 | 8319 | 88 |
1856696 | 1856696 | 2021-10-27 | Nelson | Kentucky | 21179 | 8306 | 87 |
1853447 | 1853447 | 2021-10-26 | Nelson | Kentucky | 21179 | 8281 | 87 |
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);