ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 21227 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175310 | 2175310 | 2022-02-02 | Warren | Kentucky | 21227 | 40042 | 319 |
2172057 | 2172057 | 2022-02-01 | Warren | Kentucky | 21227 | 39801 | 319 |
2168804 | 2168804 | 2022-01-31 | Warren | Kentucky | 21227 | 39538 | 319 |
2165549 | 2165549 | 2022-01-30 | Warren | Kentucky | 21227 | 39017 | 316 |
2162294 | 2162294 | 2022-01-29 | Warren | Kentucky | 21227 | 39017 | 316 |
2159039 | 2159039 | 2022-01-28 | Warren | Kentucky | 21227 | 39017 | 316 |
2155785 | 2155785 | 2022-01-27 | Warren | Kentucky | 21227 | 38546 | 316 |
2152532 | 2152532 | 2022-01-26 | Warren | Kentucky | 21227 | 38109 | 316 |
2149280 | 2149280 | 2022-01-25 | Warren | Kentucky | 21227 | 37751 | 316 |
2146028 | 2146028 | 2022-01-24 | Warren | Kentucky | 21227 | 37293 | 315 |
2142773 | 2142773 | 2022-01-23 | Warren | Kentucky | 21227 | 36371 | 314 |
2139518 | 2139518 | 2022-01-22 | Warren | Kentucky | 21227 | 36371 | 314 |
2136262 | 2136262 | 2022-01-21 | Warren | Kentucky | 21227 | 36371 | 314 |
2133010 | 2133010 | 2022-01-20 | Warren | Kentucky | 21227 | 35875 | 313 |
2129757 | 2129757 | 2022-01-19 | Warren | Kentucky | 21227 | 35418 | 313 |
2126503 | 2126503 | 2022-01-18 | Warren | Kentucky | 21227 | 34619 | 313 |
2123251 | 2123251 | 2022-01-17 | Warren | Kentucky | 21227 | 33165 | 310 |
2119999 | 2119999 | 2022-01-16 | Warren | Kentucky | 21227 | 33165 | 310 |
2116747 | 2116747 | 2022-01-15 | Warren | Kentucky | 21227 | 33165 | 310 |
2113496 | 2113496 | 2022-01-14 | Warren | Kentucky | 21227 | 33165 | 310 |
2110244 | 2110244 | 2022-01-13 | Warren | Kentucky | 21227 | 32725 | 310 |
2106993 | 2106993 | 2022-01-12 | Warren | Kentucky | 21227 | 32271 | 309 |
2103742 | 2103742 | 2022-01-11 | Warren | Kentucky | 21227 | 31720 | 309 |
2100491 | 2100491 | 2022-01-10 | Warren | Kentucky | 21227 | 31228 | 309 |
2097240 | 2097240 | 2022-01-09 | Warren | Kentucky | 21227 | 30728 | 306 |
2093988 | 2093988 | 2022-01-08 | Warren | Kentucky | 21227 | 30728 | 306 |
2090736 | 2090736 | 2022-01-07 | Warren | Kentucky | 21227 | 30728 | 306 |
2087485 | 2087485 | 2022-01-06 | Warren | Kentucky | 21227 | 30412 | 306 |
2084233 | 2084233 | 2022-01-05 | Warren | Kentucky | 21227 | 30138 | 306 |
2080981 | 2080981 | 2022-01-04 | Warren | Kentucky | 21227 | 29842 | 306 |
2077729 | 2077729 | 2022-01-03 | Warren | Kentucky | 21227 | 29560 | 306 |
2074478 | 2074478 | 2022-01-02 | Warren | Kentucky | 21227 | 28853 | 303 |
2071227 | 2071227 | 2022-01-01 | Warren | Kentucky | 21227 | 28853 | 303 |
2067976 | 2067976 | 2021-12-31 | Warren | Kentucky | 21227 | 28853 | 303 |
2064725 | 2064725 | 2021-12-30 | Warren | Kentucky | 21227 | 28853 | 303 |
2061475 | 2061475 | 2021-12-29 | Warren | Kentucky | 21227 | 28853 | 303 |
2058226 | 2058226 | 2021-12-28 | Warren | Kentucky | 21227 | 28769 | 302 |
2054977 | 2054977 | 2021-12-27 | Warren | Kentucky | 21227 | 28663 | 302 |
2051727 | 2051727 | 2021-12-26 | Warren | Kentucky | 21227 | 28322 | 299 |
2048477 | 2048477 | 2021-12-25 | Warren | Kentucky | 21227 | 28322 | 299 |
2045227 | 2045227 | 2021-12-24 | Warren | Kentucky | 21227 | 28322 | 299 |
2041978 | 2041978 | 2021-12-23 | Warren | Kentucky | 21227 | 28322 | 299 |
2038728 | 2038728 | 2021-12-22 | Warren | Kentucky | 21227 | 28322 | 299 |
2035478 | 2035478 | 2021-12-21 | Warren | Kentucky | 21227 | 28257 | 298 |
2032228 | 2032228 | 2021-12-20 | Warren | Kentucky | 21227 | 28204 | 295 |
2028977 | 2028977 | 2021-12-19 | Warren | Kentucky | 21227 | 28066 | 293 |
2025726 | 2025726 | 2021-12-18 | Warren | Kentucky | 21227 | 28066 | 293 |
2022475 | 2022475 | 2021-12-17 | Warren | Kentucky | 21227 | 28066 | 293 |
2019224 | 2019224 | 2021-12-16 | Warren | Kentucky | 21227 | 27996 | 293 |
2015974 | 2015974 | 2021-12-15 | Warren | Kentucky | 21227 | 27935 | 293 |
2012723 | 2012723 | 2021-12-14 | Warren | Kentucky | 21227 | 27891 | 293 |
2009472 | 2009472 | 2021-12-13 | Warren | Kentucky | 21227 | 27835 | 293 |
2006221 | 2006221 | 2021-12-12 | Warren | Kentucky | 21227 | 27750 | 292 |
2002970 | 2002970 | 2021-12-11 | Warren | Kentucky | 21227 | 27750 | 292 |
1999720 | 1999720 | 2021-12-10 | Warren | Kentucky | 21227 | 27750 | 292 |
1996469 | 1996469 | 2021-12-09 | Warren | Kentucky | 21227 | 27682 | 289 |
1993218 | 1993218 | 2021-12-08 | Warren | Kentucky | 21227 | 27593 | 288 |
1989967 | 1989967 | 2021-12-07 | Warren | Kentucky | 21227 | 27495 | 287 |
1986717 | 1986717 | 2021-12-06 | Warren | Kentucky | 21227 | 27451 | 287 |
1983467 | 1983467 | 2021-12-05 | Warren | Kentucky | 21227 | 27262 | 283 |
1980217 | 1980217 | 2021-12-04 | Warren | Kentucky | 21227 | 27262 | 283 |
1976967 | 1976967 | 2021-12-03 | Warren | Kentucky | 21227 | 27262 | 283 |
1973718 | 1973718 | 2021-12-02 | Warren | Kentucky | 21227 | 27165 | 279 |
1970468 | 1970468 | 2021-12-01 | Warren | Kentucky | 21227 | 27061 | 279 |
1967218 | 1967218 | 2021-11-30 | Warren | Kentucky | 21227 | 26941 | 279 |
1963966 | 1963966 | 2021-11-29 | Warren | Kentucky | 21227 | 26885 | 277 |
1960715 | 1960715 | 2021-11-28 | Warren | Kentucky | 21227 | 26682 | 274 |
1957464 | 1957464 | 2021-11-27 | Warren | Kentucky | 21227 | 26682 | 274 |
1954213 | 1954213 | 2021-11-26 | Warren | Kentucky | 21227 | 26682 | 274 |
1950962 | 1950962 | 2021-11-25 | Warren | Kentucky | 21227 | 26682 | 274 |
1947711 | 1947711 | 2021-11-24 | Warren | Kentucky | 21227 | 26682 | 274 |
1944460 | 1944460 | 2021-11-23 | Warren | Kentucky | 21227 | 26624 | 273 |
1941210 | 1941210 | 2021-11-22 | Warren | Kentucky | 21227 | 26571 | 273 |
1937960 | 1937960 | 2021-11-21 | Warren | Kentucky | 21227 | 26431 | 270 |
1934710 | 1934710 | 2021-11-20 | Warren | Kentucky | 21227 | 26431 | 270 |
1931459 | 1931459 | 2021-11-19 | Warren | Kentucky | 21227 | 26431 | 270 |
1928208 | 1928208 | 2021-11-18 | Warren | Kentucky | 21227 | 26398 | 267 |
1924958 | 1924958 | 2021-11-17 | Warren | Kentucky | 21227 | 26350 | 267 |
1921709 | 1921709 | 2021-11-16 | Warren | Kentucky | 21227 | 26293 | 266 |
1918459 | 1918459 | 2021-11-15 | Warren | Kentucky | 21227 | 26249 | 266 |
1915209 | 1915209 | 2021-11-14 | Warren | Kentucky | 21227 | 26139 | 264 |
1911959 | 1911959 | 2021-11-13 | Warren | Kentucky | 21227 | 26139 | 264 |
1908710 | 1908710 | 2021-11-12 | Warren | Kentucky | 21227 | 26139 | 264 |
1905461 | 1905461 | 2021-11-11 | Warren | Kentucky | 21227 | 26042 | 262 |
1902211 | 1902211 | 2021-11-10 | Warren | Kentucky | 21227 | 26042 | 262 |
1898961 | 1898961 | 2021-11-09 | Warren | Kentucky | 21227 | 25996 | 262 |
1895711 | 1895711 | 2021-11-08 | Warren | Kentucky | 21227 | 25927 | 261 |
1892461 | 1892461 | 2021-11-07 | Warren | Kentucky | 21227 | 25865 | 256 |
1889211 | 1889211 | 2021-11-06 | Warren | Kentucky | 21227 | 25865 | 256 |
1885961 | 1885961 | 2021-11-05 | Warren | Kentucky | 21227 | 25865 | 256 |
1882712 | 1882712 | 2021-11-04 | Warren | Kentucky | 21227 | 25826 | 255 |
1879463 | 1879463 | 2021-11-03 | Warren | Kentucky | 21227 | 25806 | 255 |
1876214 | 1876214 | 2021-11-02 | Warren | Kentucky | 21227 | 25780 | 255 |
1872965 | 1872965 | 2021-11-01 | Warren | Kentucky | 21227 | 25751 | 255 |
1869716 | 1869716 | 2021-10-31 | Warren | Kentucky | 21227 | 25692 | 254 |
1866467 | 1866467 | 2021-10-30 | Warren | Kentucky | 21227 | 25692 | 254 |
1863218 | 1863218 | 2021-10-29 | Warren | Kentucky | 21227 | 25692 | 254 |
1859969 | 1859969 | 2021-10-28 | Warren | Kentucky | 21227 | 25667 | 254 |
1856720 | 1856720 | 2021-10-27 | Warren | Kentucky | 21227 | 25645 | 249 |
1853471 | 1853471 | 2021-10-26 | Warren | Kentucky | 21227 | 25618 | 249 |
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);