ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,087 rows where deaths = 18 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Magoffin 113
- Green 98
- Breckinridge 74
- Lee 62
- Bourbon 48
- Hancock 47
- Johnson 37
- Wolfe 35
- Leslie 23
- Elliott 21
- Edmonson 18
- Union 17
- Bell 16
- Letcher 16
- Spencer 16
- Campbell 15
- Carlisle 15
- Henry 15
- Webster 15
- Butler 14
- Clark 13
- Monroe 13
- Jackson 12
- Garrard 11
- Graves 11
- Allen 10
- Grant 10
- Grayson 10
- Harlan 10
- Morgan 10
- …
state 1
- Kentucky · 1,087 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2393150 | 2393150 | 2022-04-10 | Elliott | Kentucky | 21063 | 2395 | 18 |
2389894 | 2389894 | 2022-04-09 | Elliott | Kentucky | 21063 | 2395 | 18 |
2386638 | 2386638 | 2022-04-08 | Elliott | Kentucky | 21063 | 2395 | 18 |
2383383 | 2383383 | 2022-04-07 | Elliott | Kentucky | 21063 | 2395 | 18 |
2380128 | 2380128 | 2022-04-06 | Elliott | Kentucky | 21063 | 2395 | 18 |
2376873 | 2376873 | 2022-04-05 | Elliott | Kentucky | 21063 | 2395 | 18 |
2373621 | 2373621 | 2022-04-04 | Elliott | Kentucky | 21063 | 2395 | 18 |
2370368 | 2370368 | 2022-04-03 | Elliott | Kentucky | 21063 | 2375 | 18 |
2367115 | 2367115 | 2022-04-02 | Elliott | Kentucky | 21063 | 2375 | 18 |
2363862 | 2363862 | 2022-04-01 | Elliott | Kentucky | 21063 | 2375 | 18 |
2360608 | 2360608 | 2022-03-31 | Elliott | Kentucky | 21063 | 2375 | 18 |
2357354 | 2357354 | 2022-03-30 | Elliott | Kentucky | 21063 | 2375 | 18 |
2354101 | 2354101 | 2022-03-29 | Elliott | Kentucky | 21063 | 2375 | 18 |
2350849 | 2350849 | 2022-03-28 | Elliott | Kentucky | 21063 | 2375 | 18 |
2347596 | 2347596 | 2022-03-27 | Elliott | Kentucky | 21063 | 2341 | 18 |
2344343 | 2344343 | 2022-03-26 | Elliott | Kentucky | 21063 | 2341 | 18 |
2341090 | 2341090 | 2022-03-25 | Elliott | Kentucky | 21063 | 2341 | 18 |
2337837 | 2337837 | 2022-03-24 | Elliott | Kentucky | 21063 | 2341 | 18 |
2334583 | 2334583 | 2022-03-23 | Elliott | Kentucky | 21063 | 2341 | 18 |
2331329 | 2331329 | 2022-03-22 | Elliott | Kentucky | 21063 | 2341 | 18 |
2328077 | 2328077 | 2022-03-21 | Elliott | Kentucky | 21063 | 2341 | 18 |
2302110 | 2302110 | 2022-03-13 | Morgan | Kentucky | 21175 | 4692 | 18 |
2302141 | 2302141 | 2022-03-13 | Wolfe | Kentucky | 21237 | 2408 | 18 |
2298858 | 2298858 | 2022-03-12 | Morgan | Kentucky | 21175 | 4692 | 18 |
2298889 | 2298889 | 2022-03-12 | Wolfe | Kentucky | 21237 | 2408 | 18 |
2295606 | 2295606 | 2022-03-11 | Morgan | Kentucky | 21175 | 4692 | 18 |
2295637 | 2295637 | 2022-03-11 | Wolfe | Kentucky | 21237 | 2408 | 18 |
2292354 | 2292354 | 2022-03-10 | Morgan | Kentucky | 21175 | 4692 | 18 |
2292385 | 2292385 | 2022-03-10 | Wolfe | Kentucky | 21237 | 2408 | 18 |
2289102 | 2289102 | 2022-03-09 | Morgan | Kentucky | 21175 | 4692 | 18 |
2289133 | 2289133 | 2022-03-09 | Wolfe | Kentucky | 21237 | 2408 | 18 |
2285851 | 2285851 | 2022-03-08 | Morgan | Kentucky | 21175 | 4692 | 18 |
2285882 | 2285882 | 2022-03-08 | Wolfe | Kentucky | 21237 | 2408 | 18 |
2282599 | 2282599 | 2022-03-07 | Morgan | Kentucky | 21175 | 4692 | 18 |
2282630 | 2282630 | 2022-03-07 | Wolfe | Kentucky | 21237 | 2408 | 18 |
2279346 | 2279346 | 2022-03-06 | Morgan | Kentucky | 21175 | 4659 | 18 |
2279377 | 2279377 | 2022-03-06 | Wolfe | Kentucky | 21237 | 2398 | 18 |
2276093 | 2276093 | 2022-03-05 | Morgan | Kentucky | 21175 | 4659 | 18 |
2276124 | 2276124 | 2022-03-05 | Wolfe | Kentucky | 21237 | 2398 | 18 |
2272840 | 2272840 | 2022-03-04 | Morgan | Kentucky | 21175 | 4659 | 18 |
2272871 | 2272871 | 2022-03-04 | Wolfe | Kentucky | 21237 | 2398 | 18 |
2269619 | 2269619 | 2022-03-03 | Wolfe | Kentucky | 21237 | 2385 | 18 |
2266366 | 2266366 | 2022-03-02 | Wolfe | Kentucky | 21237 | 2375 | 18 |
2263016 | 2263016 | 2022-03-01 | Carlisle | Kentucky | 21039 | 964 | 18 |
2263115 | 2263115 | 2022-03-01 | Wolfe | Kentucky | 21237 | 2358 | 18 |
2259765 | 2259765 | 2022-02-28 | Carlisle | Kentucky | 21039 | 963 | 18 |
2259864 | 2259864 | 2022-02-28 | Wolfe | Kentucky | 21237 | 2347 | 18 |
2256514 | 2256514 | 2022-02-27 | Carlisle | Kentucky | 21039 | 961 | 18 |
2256613 | 2256613 | 2022-02-27 | Wolfe | Kentucky | 21237 | 2319 | 18 |
2253263 | 2253263 | 2022-02-26 | Carlisle | Kentucky | 21039 | 961 | 18 |
2253362 | 2253362 | 2022-02-26 | Wolfe | Kentucky | 21237 | 2319 | 18 |
2250012 | 2250012 | 2022-02-25 | Carlisle | Kentucky | 21039 | 961 | 18 |
2250111 | 2250111 | 2022-02-25 | Wolfe | Kentucky | 21237 | 2319 | 18 |
2246761 | 2246761 | 2022-02-24 | Carlisle | Kentucky | 21039 | 956 | 18 |
2246860 | 2246860 | 2022-02-24 | Wolfe | Kentucky | 21237 | 2301 | 18 |
2243510 | 2243510 | 2022-02-23 | Carlisle | Kentucky | 21039 | 956 | 18 |
2243609 | 2243609 | 2022-02-23 | Wolfe | Kentucky | 21237 | 2301 | 18 |
2240259 | 2240259 | 2022-02-22 | Carlisle | Kentucky | 21039 | 955 | 18 |
2240358 | 2240358 | 2022-02-22 | Wolfe | Kentucky | 21237 | 2262 | 18 |
2237008 | 2237008 | 2022-02-21 | Carlisle | Kentucky | 21039 | 951 | 18 |
2237107 | 2237107 | 2022-02-21 | Wolfe | Kentucky | 21237 | 2258 | 18 |
2233757 | 2233757 | 2022-02-20 | Carlisle | Kentucky | 21039 | 949 | 18 |
2233856 | 2233856 | 2022-02-20 | Wolfe | Kentucky | 21237 | 2226 | 18 |
2230506 | 2230506 | 2022-02-19 | Carlisle | Kentucky | 21039 | 949 | 18 |
2230605 | 2230605 | 2022-02-19 | Wolfe | Kentucky | 21237 | 2226 | 18 |
2227255 | 2227255 | 2022-02-18 | Carlisle | Kentucky | 21039 | 949 | 18 |
2227354 | 2227354 | 2022-02-18 | Wolfe | Kentucky | 21237 | 2226 | 18 |
2224004 | 2224004 | 2022-02-17 | Carlisle | Kentucky | 21039 | 947 | 18 |
2224103 | 2224103 | 2022-02-17 | Wolfe | Kentucky | 21237 | 2207 | 18 |
2220753 | 2220753 | 2022-02-16 | Carlisle | Kentucky | 21039 | 944 | 18 |
2220852 | 2220852 | 2022-02-16 | Wolfe | Kentucky | 21237 | 2183 | 18 |
2217502 | 2217502 | 2022-02-15 | Carlisle | Kentucky | 21039 | 941 | 18 |
2217601 | 2217601 | 2022-02-15 | Wolfe | Kentucky | 21237 | 2175 | 18 |
2214350 | 2214350 | 2022-02-14 | Wolfe | Kentucky | 21237 | 2169 | 18 |
2211098 | 2211098 | 2022-02-13 | Wolfe | Kentucky | 21237 | 2131 | 18 |
2207845 | 2207845 | 2022-02-12 | Wolfe | Kentucky | 21237 | 2131 | 18 |
2204592 | 2204592 | 2022-02-11 | Wolfe | Kentucky | 21237 | 2131 | 18 |
2201339 | 2201339 | 2022-02-10 | Wolfe | Kentucky | 21237 | 2113 | 18 |
2198085 | 2198085 | 2022-02-09 | Wolfe | Kentucky | 21237 | 2093 | 18 |
2194831 | 2194831 | 2022-02-08 | Wolfe | Kentucky | 21237 | 2037 | 18 |
2191577 | 2191577 | 2022-02-07 | Wolfe | Kentucky | 21237 | 2019 | 18 |
2084220 | 2084220 | 2022-01-05 | Robertson | Kentucky | 21201 | 470 | 18 |
2080968 | 2080968 | 2022-01-04 | Robertson | Kentucky | 21201 | 465 | 18 |
2077716 | 2077716 | 2022-01-03 | Robertson | Kentucky | 21201 | 465 | 18 |
2074465 | 2074465 | 2022-01-02 | Robertson | Kentucky | 21201 | 449 | 18 |
2071214 | 2071214 | 2022-01-01 | Robertson | Kentucky | 21201 | 449 | 18 |
2067963 | 2067963 | 2021-12-31 | Robertson | Kentucky | 21201 | 449 | 18 |
2064712 | 2064712 | 2021-12-30 | Robertson | Kentucky | 21201 | 449 | 18 |
2061462 | 2061462 | 2021-12-29 | Robertson | Kentucky | 21201 | 449 | 18 |
2058213 | 2058213 | 2021-12-28 | Robertson | Kentucky | 21201 | 448 | 18 |
2032160 | 2032160 | 2021-12-20 | Hancock | Kentucky | 21091 | 1623 | 18 |
2028909 | 2028909 | 2021-12-19 | Hancock | Kentucky | 21091 | 1611 | 18 |
2025658 | 2025658 | 2021-12-18 | Hancock | Kentucky | 21091 | 1611 | 18 |
2022407 | 2022407 | 2021-12-17 | Hancock | Kentucky | 21091 | 1611 | 18 |
2019156 | 2019156 | 2021-12-16 | Hancock | Kentucky | 21091 | 1603 | 18 |
2015906 | 2015906 | 2021-12-15 | Hancock | Kentucky | 21091 | 1593 | 18 |
2012655 | 2012655 | 2021-12-14 | Hancock | Kentucky | 21091 | 1579 | 18 |
2009404 | 2009404 | 2021-12-13 | Hancock | Kentucky | 21091 | 1571 | 18 |
2006153 | 2006153 | 2021-12-12 | Hancock | Kentucky | 21091 | 1554 | 18 |
2002902 | 2002902 | 2021-12-11 | Hancock | Kentucky | 21091 | 1554 | 18 |
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);