ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
366 rows where deaths = 63 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461551 | 2461551 | 2022-05-01 | Knott | Kentucky | 21119 | 4225 | 63 |
2458295 | 2458295 | 2022-04-30 | Knott | Kentucky | 21119 | 4225 | 63 |
2455039 | 2455039 | 2022-04-29 | Knott | Kentucky | 21119 | 4225 | 63 |
2451783 | 2451783 | 2022-04-28 | Knott | Kentucky | 21119 | 4225 | 63 |
2448527 | 2448527 | 2022-04-27 | Knott | Kentucky | 21119 | 4225 | 63 |
2445271 | 2445271 | 2022-04-26 | Knott | Kentucky | 21119 | 4225 | 63 |
2442015 | 2442015 | 2022-04-25 | Knott | Kentucky | 21119 | 4225 | 63 |
2438759 | 2438759 | 2022-04-24 | Knott | Kentucky | 21119 | 4218 | 63 |
2435503 | 2435503 | 2022-04-23 | Knott | Kentucky | 21119 | 4218 | 63 |
2432247 | 2432247 | 2022-04-22 | Knott | Kentucky | 21119 | 4218 | 63 |
2428991 | 2428991 | 2022-04-21 | Knott | Kentucky | 21119 | 4218 | 63 |
2425735 | 2425735 | 2022-04-20 | Knott | Kentucky | 21119 | 4218 | 63 |
2422479 | 2422479 | 2022-04-19 | Knott | Kentucky | 21119 | 4218 | 63 |
2419223 | 2419223 | 2022-04-18 | Knott | Kentucky | 21119 | 4218 | 63 |
2415992 | 2415992 | 2022-04-17 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2412736 | 2412736 | 2022-04-16 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2409480 | 2409480 | 2022-04-15 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2406224 | 2406224 | 2022-04-14 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2402968 | 2402968 | 2022-04-13 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2399714 | 2399714 | 2022-04-12 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2396458 | 2396458 | 2022-04-11 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2393221 | 2393221 | 2022-04-10 | Rowan | Kentucky | 21205 | 6631 | 63 |
2389965 | 2389965 | 2022-04-09 | Rowan | Kentucky | 21205 | 6631 | 63 |
2386709 | 2386709 | 2022-04-08 | Rowan | Kentucky | 21205 | 6631 | 63 |
2383454 | 2383454 | 2022-04-07 | Rowan | Kentucky | 21205 | 6631 | 63 |
2380199 | 2380199 | 2022-04-06 | Rowan | Kentucky | 21205 | 6631 | 63 |
2376944 | 2376944 | 2022-04-05 | Rowan | Kentucky | 21205 | 6631 | 63 |
2373692 | 2373692 | 2022-04-04 | Rowan | Kentucky | 21205 | 6631 | 63 |
2370439 | 2370439 | 2022-04-03 | Rowan | Kentucky | 21205 | 6589 | 63 |
2367186 | 2367186 | 2022-04-02 | Rowan | Kentucky | 21205 | 6589 | 63 |
2363933 | 2363933 | 2022-04-01 | Rowan | Kentucky | 21205 | 6589 | 63 |
2360679 | 2360679 | 2022-03-31 | Rowan | Kentucky | 21205 | 6589 | 63 |
2357425 | 2357425 | 2022-03-30 | Rowan | Kentucky | 21205 | 6589 | 63 |
2354172 | 2354172 | 2022-03-29 | Rowan | Kentucky | 21205 | 6589 | 63 |
2350920 | 2350920 | 2022-03-28 | Rowan | Kentucky | 21205 | 6589 | 63 |
2324856 | 2324856 | 2022-03-20 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2321602 | 2321602 | 2022-03-19 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2318348 | 2318348 | 2022-03-18 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2315095 | 2315095 | 2022-03-17 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2311842 | 2311842 | 2022-03-16 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2308589 | 2308589 | 2022-03-15 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2305338 | 2305338 | 2022-03-14 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2266250 | 2266250 | 2022-03-02 | Anderson | Kentucky | 21005 | 6168 | 63 |
2191513 | 2191513 | 2022-02-07 | Jackson | Kentucky | 21109 | 3862 | 63 |
2188219 | 2188219 | 2022-02-06 | Breckinridge | Kentucky | 21027 | 4735 | 63 |
2188260 | 2188260 | 2022-02-06 | Jackson | Kentucky | 21109 | 3842 | 63 |
2184966 | 2184966 | 2022-02-05 | Breckinridge | Kentucky | 21027 | 4735 | 63 |
2185007 | 2185007 | 2022-02-05 | Jackson | Kentucky | 21109 | 3842 | 63 |
2181714 | 2181714 | 2022-02-04 | Breckinridge | Kentucky | 21027 | 4735 | 63 |
2181755 | 2181755 | 2022-02-04 | Jackson | Kentucky | 21109 | 3842 | 63 |
2178504 | 2178504 | 2022-02-03 | Jackson | Kentucky | 21109 | 3819 | 63 |
2175251 | 2175251 | 2022-02-02 | Jackson | Kentucky | 21109 | 3777 | 63 |
2103703 | 2103703 | 2022-01-11 | Marion | Kentucky | 21155 | 4749 | 63 |
2100452 | 2100452 | 2022-01-10 | Marion | Kentucky | 21155 | 4699 | 63 |
2097201 | 2097201 | 2022-01-09 | Marion | Kentucky | 21155 | 4665 | 63 |
2093949 | 2093949 | 2022-01-08 | Marion | Kentucky | 21155 | 4665 | 63 |
2090697 | 2090697 | 2022-01-07 | Marion | Kentucky | 21155 | 4665 | 63 |
2087446 | 2087446 | 2022-01-06 | Marion | Kentucky | 21155 | 4629 | 63 |
2084194 | 2084194 | 2022-01-05 | Marion | Kentucky | 21155 | 4599 | 63 |
2080942 | 2080942 | 2022-01-04 | Marion | Kentucky | 21155 | 4564 | 63 |
2077690 | 2077690 | 2022-01-03 | Marion | Kentucky | 21155 | 4523 | 63 |
2074439 | 2074439 | 2022-01-02 | Marion | Kentucky | 21155 | 4457 | 63 |
2071188 | 2071188 | 2022-01-01 | Marion | Kentucky | 21155 | 4457 | 63 |
2067937 | 2067937 | 2021-12-31 | Marion | Kentucky | 21155 | 4457 | 63 |
2064686 | 2064686 | 2021-12-30 | Marion | Kentucky | 21155 | 4457 | 63 |
2061436 | 2061436 | 2021-12-29 | Marion | Kentucky | 21155 | 4457 | 63 |
2058187 | 2058187 | 2021-12-28 | Marion | Kentucky | 21155 | 4453 | 63 |
2054938 | 2054938 | 2021-12-27 | Marion | Kentucky | 21155 | 4422 | 63 |
2028886 | 2028886 | 2021-12-19 | Casey | Kentucky | 21045 | 3034 | 63 |
2025635 | 2025635 | 2021-12-18 | Casey | Kentucky | 21045 | 3034 | 63 |
2022384 | 2022384 | 2021-12-17 | Casey | Kentucky | 21045 | 3034 | 63 |
2019133 | 2019133 | 2021-12-16 | Casey | Kentucky | 21045 | 3025 | 63 |
2015883 | 2015883 | 2021-12-15 | Casey | Kentucky | 21045 | 3025 | 63 |
2012632 | 2012632 | 2021-12-14 | Casey | Kentucky | 21045 | 3006 | 63 |
2009381 | 2009381 | 2021-12-13 | Casey | Kentucky | 21045 | 3000 | 63 |
2006130 | 2006130 | 2021-12-12 | Casey | Kentucky | 21045 | 3000 | 63 |
2002879 | 2002879 | 2021-12-11 | Casey | Kentucky | 21045 | 3000 | 63 |
1999629 | 1999629 | 2021-12-10 | Casey | Kentucky | 21045 | 3000 | 63 |
1996423 | 1996423 | 2021-12-09 | Lewis | Kentucky | 21135 | 2853 | 63 |
1989933 | 1989933 | 2021-12-07 | McCreary | Kentucky | 21147 | 3993 | 63 |
1986683 | 1986683 | 2021-12-06 | McCreary | Kentucky | 21147 | 3977 | 63 |
1986707 | 1986707 | 2021-12-06 | Russell | Kentucky | 21207 | 4113 | 63 |
1983457 | 1983457 | 2021-12-05 | Russell | Kentucky | 21207 | 4099 | 63 |
1983460 | 1983460 | 2021-12-05 | Simpson | Kentucky | 21213 | 3479 | 63 |
1980207 | 1980207 | 2021-12-04 | Russell | Kentucky | 21207 | 4099 | 63 |
1980210 | 1980210 | 2021-12-04 | Simpson | Kentucky | 21213 | 3479 | 63 |
1976957 | 1976957 | 2021-12-03 | Russell | Kentucky | 21207 | 4096 | 63 |
1976960 | 1976960 | 2021-12-03 | Simpson | Kentucky | 21213 | 3479 | 63 |
1973708 | 1973708 | 2021-12-02 | Russell | Kentucky | 21207 | 4082 | 63 |
1970458 | 1970458 | 2021-12-01 | Russell | Kentucky | 21207 | 4061 | 63 |
1967191 | 1967191 | 2021-11-30 | Montgomery | Kentucky | 21173 | 4758 | 63 |
1967208 | 1967208 | 2021-11-30 | Russell | Kentucky | 21207 | 4043 | 63 |
1963878 | 1963878 | 2021-11-29 | Clay | Kentucky | 21051 | 5179 | 63 |
1963939 | 1963939 | 2021-11-29 | Montgomery | Kentucky | 21173 | 4753 | 63 |
1963956 | 1963956 | 2021-11-29 | Russell | Kentucky | 21207 | 4043 | 63 |
1960705 | 1960705 | 2021-11-28 | Russell | Kentucky | 21207 | 4028 | 63 |
1957454 | 1957454 | 2021-11-27 | Russell | Kentucky | 21207 | 4028 | 63 |
1954203 | 1954203 | 2021-11-26 | Russell | Kentucky | 21207 | 4028 | 63 |
1950952 | 1950952 | 2021-11-25 | Russell | Kentucky | 21207 | 4028 | 63 |
1892397 | 1892397 | 2021-11-07 | Hart | Kentucky | 21099 | 3580 | 63 |
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);