ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
319 rows where deaths = 78 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Boyle 55
- Shelby 48
- Breckinridge 40
- Jackson 21
- Hart 12
- Lewis 12
- Henderson 10
- Marshall 10
- Christian 9
- Johnson 7
- McCreary 7
- Allen 6
- Franklin 6
- Jessamine 6
- Oldham 6
- Wayne 6
- Garrard 5
- Scott 5
- Bell 4
- Ohio 4
- Adair 3
- Grayson 3
- Greenup 3
- Hardin 3
- Laurel 3
- Letcher 3
- Mason 3
- Simpson 3
- Jefferson 2
- Montgomery 2
- …
state 1
- Kentucky · 319 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500592 | 2500592 | 2022-05-13 | Breckinridge | Kentucky | 21027 | 5170 | 78 |
2500618 | 2500618 | 2022-05-13 | Garrard | Kentucky | 21079 | 4815 | 78 |
2497334 | 2497334 | 2022-05-12 | Breckinridge | Kentucky | 21027 | 5170 | 78 |
2497360 | 2497360 | 2022-05-12 | Garrard | Kentucky | 21079 | 4815 | 78 |
2494076 | 2494076 | 2022-05-11 | Breckinridge | Kentucky | 21027 | 5170 | 78 |
2494102 | 2494102 | 2022-05-11 | Garrard | Kentucky | 21079 | 4815 | 78 |
2490818 | 2490818 | 2022-05-10 | Breckinridge | Kentucky | 21027 | 5170 | 78 |
2490844 | 2490844 | 2022-05-10 | Garrard | Kentucky | 21079 | 4815 | 78 |
2487561 | 2487561 | 2022-05-09 | Breckinridge | Kentucky | 21027 | 5170 | 78 |
2487587 | 2487587 | 2022-05-09 | Garrard | Kentucky | 21079 | 4815 | 78 |
2484303 | 2484303 | 2022-05-08 | Breckinridge | Kentucky | 21027 | 5154 | 78 |
2481045 | 2481045 | 2022-05-07 | Breckinridge | Kentucky | 21027 | 5154 | 78 |
2477787 | 2477787 | 2022-05-06 | Breckinridge | Kentucky | 21027 | 5154 | 78 |
2474529 | 2474529 | 2022-05-05 | Breckinridge | Kentucky | 21027 | 5154 | 78 |
2471272 | 2471272 | 2022-05-04 | Breckinridge | Kentucky | 21027 | 5154 | 78 |
2468016 | 2468016 | 2022-05-03 | Breckinridge | Kentucky | 21027 | 5154 | 78 |
2464761 | 2464761 | 2022-05-02 | Breckinridge | Kentucky | 21027 | 5154 | 78 |
2461505 | 2461505 | 2022-05-01 | Breckinridge | Kentucky | 21027 | 5143 | 78 |
2461546 | 2461546 | 2022-05-01 | Jackson | Kentucky | 21109 | 4279 | 78 |
2458249 | 2458249 | 2022-04-30 | Breckinridge | Kentucky | 21027 | 5143 | 78 |
2458290 | 2458290 | 2022-04-30 | Jackson | Kentucky | 21109 | 4279 | 78 |
2454993 | 2454993 | 2022-04-29 | Breckinridge | Kentucky | 21027 | 5143 | 78 |
2455034 | 2455034 | 2022-04-29 | Jackson | Kentucky | 21109 | 4279 | 78 |
2451737 | 2451737 | 2022-04-28 | Breckinridge | Kentucky | 21027 | 5143 | 78 |
2451778 | 2451778 | 2022-04-28 | Jackson | Kentucky | 21109 | 4279 | 78 |
2448481 | 2448481 | 2022-04-27 | Breckinridge | Kentucky | 21027 | 5143 | 78 |
2448522 | 2448522 | 2022-04-27 | Jackson | Kentucky | 21109 | 4279 | 78 |
2445225 | 2445225 | 2022-04-26 | Breckinridge | Kentucky | 21027 | 5143 | 78 |
2445266 | 2445266 | 2022-04-26 | Jackson | Kentucky | 21109 | 4279 | 78 |
2441969 | 2441969 | 2022-04-25 | Breckinridge | Kentucky | 21027 | 5143 | 78 |
2442010 | 2442010 | 2022-04-25 | Jackson | Kentucky | 21109 | 4279 | 78 |
2438713 | 2438713 | 2022-04-24 | Breckinridge | Kentucky | 21027 | 5065 | 78 |
2438754 | 2438754 | 2022-04-24 | Jackson | Kentucky | 21109 | 4276 | 78 |
2435457 | 2435457 | 2022-04-23 | Breckinridge | Kentucky | 21027 | 5065 | 78 |
2435498 | 2435498 | 2022-04-23 | Jackson | Kentucky | 21109 | 4276 | 78 |
2432201 | 2432201 | 2022-04-22 | Breckinridge | Kentucky | 21027 | 5065 | 78 |
2432242 | 2432242 | 2022-04-22 | Jackson | Kentucky | 21109 | 4276 | 78 |
2428945 | 2428945 | 2022-04-21 | Breckinridge | Kentucky | 21027 | 5065 | 78 |
2428986 | 2428986 | 2022-04-21 | Jackson | Kentucky | 21109 | 4276 | 78 |
2425689 | 2425689 | 2022-04-20 | Breckinridge | Kentucky | 21027 | 5065 | 78 |
2425730 | 2425730 | 2022-04-20 | Jackson | Kentucky | 21109 | 4276 | 78 |
2422433 | 2422433 | 2022-04-19 | Breckinridge | Kentucky | 21027 | 5065 | 78 |
2422474 | 2422474 | 2022-04-19 | Jackson | Kentucky | 21109 | 4276 | 78 |
2419177 | 2419177 | 2022-04-18 | Breckinridge | Kentucky | 21027 | 5065 | 78 |
2419218 | 2419218 | 2022-04-18 | Jackson | Kentucky | 21109 | 4276 | 78 |
2415921 | 2415921 | 2022-04-17 | Breckinridge | Kentucky | 21027 | 5029 | 78 |
2415962 | 2415962 | 2022-04-17 | Jackson | Kentucky | 21109 | 4275 | 78 |
2415987 | 2415987 | 2022-04-17 | McCreary | Kentucky | 21147 | 5715 | 78 |
2412665 | 2412665 | 2022-04-16 | Breckinridge | Kentucky | 21027 | 5029 | 78 |
2412706 | 2412706 | 2022-04-16 | Jackson | Kentucky | 21109 | 4275 | 78 |
2412731 | 2412731 | 2022-04-16 | McCreary | Kentucky | 21147 | 5715 | 78 |
2409409 | 2409409 | 2022-04-15 | Breckinridge | Kentucky | 21027 | 5029 | 78 |
2409450 | 2409450 | 2022-04-15 | Jackson | Kentucky | 21109 | 4275 | 78 |
2409475 | 2409475 | 2022-04-15 | McCreary | Kentucky | 21147 | 5715 | 78 |
2406153 | 2406153 | 2022-04-14 | Breckinridge | Kentucky | 21027 | 5029 | 78 |
2406194 | 2406194 | 2022-04-14 | Jackson | Kentucky | 21109 | 4275 | 78 |
2406219 | 2406219 | 2022-04-14 | McCreary | Kentucky | 21147 | 5715 | 78 |
2402897 | 2402897 | 2022-04-13 | Breckinridge | Kentucky | 21027 | 5029 | 78 |
2402938 | 2402938 | 2022-04-13 | Jackson | Kentucky | 21109 | 4275 | 78 |
2402963 | 2402963 | 2022-04-13 | McCreary | Kentucky | 21147 | 5715 | 78 |
2399643 | 2399643 | 2022-04-12 | Breckinridge | Kentucky | 21027 | 5029 | 78 |
2399684 | 2399684 | 2022-04-12 | Jackson | Kentucky | 21109 | 4275 | 78 |
2399709 | 2399709 | 2022-04-12 | McCreary | Kentucky | 21147 | 5715 | 78 |
2396387 | 2396387 | 2022-04-11 | Breckinridge | Kentucky | 21027 | 5029 | 78 |
2396428 | 2396428 | 2022-04-11 | Jackson | Kentucky | 21109 | 4275 | 78 |
2396453 | 2396453 | 2022-04-11 | McCreary | Kentucky | 21147 | 5715 | 78 |
2393132 | 2393132 | 2022-04-10 | Breckinridge | Kentucky | 21027 | 5013 | 78 |
2389876 | 2389876 | 2022-04-09 | Breckinridge | Kentucky | 21027 | 5013 | 78 |
2386620 | 2386620 | 2022-04-08 | Breckinridge | Kentucky | 21027 | 5013 | 78 |
2383365 | 2383365 | 2022-04-07 | Breckinridge | Kentucky | 21027 | 5013 | 78 |
2380110 | 2380110 | 2022-04-06 | Breckinridge | Kentucky | 21027 | 5013 | 78 |
2376855 | 2376855 | 2022-04-05 | Breckinridge | Kentucky | 21027 | 5013 | 78 |
2373603 | 2373603 | 2022-04-04 | Breckinridge | Kentucky | 21027 | 5013 | 78 |
2256562 | 2256562 | 2022-02-27 | Lewis | Kentucky | 21135 | 4390 | 78 |
2253311 | 2253311 | 2022-02-26 | Lewis | Kentucky | 21135 | 4390 | 78 |
2250060 | 2250060 | 2022-02-25 | Lewis | Kentucky | 21135 | 4390 | 78 |
2246809 | 2246809 | 2022-02-24 | Lewis | Kentucky | 21135 | 4383 | 78 |
2243558 | 2243558 | 2022-02-23 | Lewis | Kentucky | 21135 | 4383 | 78 |
2240265 | 2240265 | 2022-02-22 | Clay | Kentucky | 21051 | 7623 | 78 |
2240307 | 2240307 | 2022-02-22 | Lewis | Kentucky | 21135 | 4372 | 78 |
2237056 | 2237056 | 2022-02-21 | Lewis | Kentucky | 21135 | 4354 | 78 |
2237092 | 2237092 | 2022-02-21 | Russell | Kentucky | 21207 | 6024 | 78 |
2233805 | 2233805 | 2022-02-20 | Lewis | Kentucky | 21135 | 4333 | 78 |
2230554 | 2230554 | 2022-02-19 | Lewis | Kentucky | 21135 | 4333 | 78 |
2227303 | 2227303 | 2022-02-18 | Lewis | Kentucky | 21135 | 4333 | 78 |
2224052 | 2224052 | 2022-02-17 | Lewis | Kentucky | 21135 | 4331 | 78 |
2220801 | 2220801 | 2022-02-16 | Lewis | Kentucky | 21135 | 4320 | 78 |
2172059 | 2172059 | 2022-02-01 | Wayne | Kentucky | 21231 | 4355 | 78 |
2168806 | 2168806 | 2022-01-31 | Wayne | Kentucky | 21231 | 4335 | 78 |
2165542 | 2165542 | 2022-01-30 | Simpson | Kentucky | 21213 | 5119 | 78 |
2165551 | 2165551 | 2022-01-30 | Wayne | Kentucky | 21231 | 4277 | 78 |
2162287 | 2162287 | 2022-01-29 | Simpson | Kentucky | 21213 | 5119 | 78 |
2162296 | 2162296 | 2022-01-29 | Wayne | Kentucky | 21231 | 4277 | 78 |
2159032 | 2159032 | 2022-01-28 | Simpson | Kentucky | 21213 | 5119 | 78 |
2159041 | 2159041 | 2022-01-28 | Wayne | Kentucky | 21231 | 4277 | 78 |
2155787 | 2155787 | 2022-01-27 | Wayne | Kentucky | 21231 | 4244 | 78 |
2126494 | 2126494 | 2022-01-18 | Scott | Kentucky | 21209 | 12036 | 78 |
2123242 | 2123242 | 2022-01-17 | Scott | Kentucky | 21209 | 11460 | 78 |
2119990 | 2119990 | 2022-01-16 | Scott | Kentucky | 21209 | 11460 | 78 |
2116738 | 2116738 | 2022-01-15 | Scott | Kentucky | 21209 | 11460 | 78 |
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);