ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
453 rows where deaths = 57 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Union 33
- Henderson 28
- Marshall 28
- Harrison 23
- Washington 21
- Whitley 20
- Anderson 18
- Larue 18
- Warren 18
- Nelson 16
- Caldwell 14
- Mercer 14
- Casey 13
- Wayne 13
- Muhlenberg 12
- Lewis 10
- Adair 9
- Calloway 9
- Monroe 9
- Grant 8
- Bourbon 7
- Greenup 7
- Metcalfe 7
- Pike 7
- Rowan 7
- Scott 7
- Carter 6
- Christian 6
- Logan 6
- Floyd 5
- …
state 1
- Kentucky · 453 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500691 | 2500691 | 2022-05-13 | Union | Kentucky | 21225 | 4341 | 57 |
2497433 | 2497433 | 2022-05-12 | Union | Kentucky | 21225 | 4341 | 57 |
2494175 | 2494175 | 2022-05-11 | Union | Kentucky | 21225 | 4341 | 57 |
2490917 | 2490917 | 2022-05-10 | Union | Kentucky | 21225 | 4341 | 57 |
2487660 | 2487660 | 2022-05-09 | Union | Kentucky | 21225 | 4341 | 57 |
2484298 | 2484298 | 2022-05-08 | Bourbon | Kentucky | 21017 | 5991 | 57 |
2484402 | 2484402 | 2022-05-08 | Union | Kentucky | 21225 | 4341 | 57 |
2481040 | 2481040 | 2022-05-07 | Bourbon | Kentucky | 21017 | 5991 | 57 |
2481144 | 2481144 | 2022-05-07 | Union | Kentucky | 21225 | 4341 | 57 |
2477782 | 2477782 | 2022-05-06 | Bourbon | Kentucky | 21017 | 5991 | 57 |
2477886 | 2477886 | 2022-05-06 | Union | Kentucky | 21225 | 4341 | 57 |
2474524 | 2474524 | 2022-05-05 | Bourbon | Kentucky | 21017 | 5991 | 57 |
2474628 | 2474628 | 2022-05-05 | Union | Kentucky | 21225 | 4341 | 57 |
2471267 | 2471267 | 2022-05-04 | Bourbon | Kentucky | 21017 | 5991 | 57 |
2471371 | 2471371 | 2022-05-04 | Union | Kentucky | 21225 | 4341 | 57 |
2468011 | 2468011 | 2022-05-03 | Bourbon | Kentucky | 21017 | 5991 | 57 |
2468115 | 2468115 | 2022-05-03 | Union | Kentucky | 21225 | 4341 | 57 |
2464756 | 2464756 | 2022-05-02 | Bourbon | Kentucky | 21017 | 5991 | 57 |
2464860 | 2464860 | 2022-05-02 | Union | Kentucky | 21225 | 4341 | 57 |
2461604 | 2461604 | 2022-05-01 | Union | Kentucky | 21225 | 4338 | 57 |
2458348 | 2458348 | 2022-04-30 | Union | Kentucky | 21225 | 4338 | 57 |
2455092 | 2455092 | 2022-04-29 | Union | Kentucky | 21225 | 4338 | 57 |
2451836 | 2451836 | 2022-04-28 | Union | Kentucky | 21225 | 4338 | 57 |
2448580 | 2448580 | 2022-04-27 | Union | Kentucky | 21225 | 4338 | 57 |
2445324 | 2445324 | 2022-04-26 | Union | Kentucky | 21225 | 4338 | 57 |
2442068 | 2442068 | 2022-04-25 | Union | Kentucky | 21225 | 4338 | 57 |
2438812 | 2438812 | 2022-04-24 | Union | Kentucky | 21225 | 4337 | 57 |
2435556 | 2435556 | 2022-04-23 | Union | Kentucky | 21225 | 4337 | 57 |
2432300 | 2432300 | 2022-04-22 | Union | Kentucky | 21225 | 4337 | 57 |
2429044 | 2429044 | 2022-04-21 | Union | Kentucky | 21225 | 4337 | 57 |
2425788 | 2425788 | 2022-04-20 | Union | Kentucky | 21225 | 4337 | 57 |
2422532 | 2422532 | 2022-04-19 | Union | Kentucky | 21225 | 4337 | 57 |
2419276 | 2419276 | 2022-04-18 | Union | Kentucky | 21225 | 4337 | 57 |
2416020 | 2416020 | 2022-04-17 | Union | Kentucky | 21225 | 4334 | 57 |
2412764 | 2412764 | 2022-04-16 | Union | Kentucky | 21225 | 4334 | 57 |
2409508 | 2409508 | 2022-04-15 | Union | Kentucky | 21225 | 4334 | 57 |
2406252 | 2406252 | 2022-04-14 | Union | Kentucky | 21225 | 4334 | 57 |
2402996 | 2402996 | 2022-04-13 | Union | Kentucky | 21225 | 4334 | 57 |
2399742 | 2399742 | 2022-04-12 | Union | Kentucky | 21225 | 4334 | 57 |
2396486 | 2396486 | 2022-04-11 | Union | Kentucky | 21225 | 4334 | 57 |
2370451 | 2370451 | 2022-04-03 | Washington | Kentucky | 21229 | 3911 | 57 |
2367198 | 2367198 | 2022-04-02 | Washington | Kentucky | 21229 | 3911 | 57 |
2363945 | 2363945 | 2022-04-01 | Washington | Kentucky | 21229 | 3911 | 57 |
2360691 | 2360691 | 2022-03-31 | Washington | Kentucky | 21229 | 3911 | 57 |
2357437 | 2357437 | 2022-03-30 | Washington | Kentucky | 21229 | 3911 | 57 |
2354184 | 2354184 | 2022-03-29 | Washington | Kentucky | 21229 | 3911 | 57 |
2350932 | 2350932 | 2022-03-28 | Washington | Kentucky | 21229 | 3911 | 57 |
2347679 | 2347679 | 2022-03-27 | Washington | Kentucky | 21229 | 3901 | 57 |
2344426 | 2344426 | 2022-03-26 | Washington | Kentucky | 21229 | 3901 | 57 |
2341173 | 2341173 | 2022-03-25 | Washington | Kentucky | 21229 | 3901 | 57 |
2337920 | 2337920 | 2022-03-24 | Washington | Kentucky | 21229 | 3901 | 57 |
2334666 | 2334666 | 2022-03-23 | Washington | Kentucky | 21229 | 3901 | 57 |
2331412 | 2331412 | 2022-03-22 | Washington | Kentucky | 21229 | 3901 | 57 |
2328160 | 2328160 | 2022-03-21 | Washington | Kentucky | 21229 | 3901 | 57 |
2324895 | 2324895 | 2022-03-20 | Rowan | Kentucky | 21205 | 6485 | 57 |
2324907 | 2324907 | 2022-03-20 | Washington | Kentucky | 21229 | 3875 | 57 |
2321641 | 2321641 | 2022-03-19 | Rowan | Kentucky | 21205 | 6485 | 57 |
2321653 | 2321653 | 2022-03-19 | Washington | Kentucky | 21229 | 3875 | 57 |
2318387 | 2318387 | 2022-03-18 | Rowan | Kentucky | 21205 | 6485 | 57 |
2318399 | 2318399 | 2022-03-18 | Washington | Kentucky | 21229 | 3875 | 57 |
2315134 | 2315134 | 2022-03-17 | Rowan | Kentucky | 21205 | 6485 | 57 |
2315146 | 2315146 | 2022-03-17 | Washington | Kentucky | 21229 | 3875 | 57 |
2311881 | 2311881 | 2022-03-16 | Rowan | Kentucky | 21205 | 6485 | 57 |
2311893 | 2311893 | 2022-03-16 | Washington | Kentucky | 21229 | 3875 | 57 |
2308628 | 2308628 | 2022-03-15 | Rowan | Kentucky | 21205 | 6485 | 57 |
2308640 | 2308640 | 2022-03-15 | Washington | Kentucky | 21229 | 3875 | 57 |
2305377 | 2305377 | 2022-03-14 | Rowan | Kentucky | 21205 | 6485 | 57 |
2305389 | 2305389 | 2022-03-14 | Washington | Kentucky | 21229 | 3875 | 57 |
2289055 | 2289055 | 2022-03-09 | Grant | Kentucky | 21081 | 7595 | 57 |
2285804 | 2285804 | 2022-03-08 | Grant | Kentucky | 21081 | 7583 | 57 |
2282552 | 2282552 | 2022-03-07 | Grant | Kentucky | 21081 | 7581 | 57 |
2279299 | 2279299 | 2022-03-06 | Grant | Kentucky | 21081 | 7566 | 57 |
2279318 | 2279318 | 2022-03-06 | Knott | Kentucky | 21119 | 4045 | 57 |
2276046 | 2276046 | 2022-03-05 | Grant | Kentucky | 21081 | 7566 | 57 |
2276065 | 2276065 | 2022-03-05 | Knott | Kentucky | 21119 | 4045 | 57 |
2272793 | 2272793 | 2022-03-04 | Grant | Kentucky | 21081 | 7566 | 57 |
2272812 | 2272812 | 2022-03-04 | Knott | Kentucky | 21119 | 4045 | 57 |
2269541 | 2269541 | 2022-03-03 | Grant | Kentucky | 21081 | 7555 | 57 |
2269560 | 2269560 | 2022-03-03 | Knott | Kentucky | 21119 | 4041 | 57 |
2266288 | 2266288 | 2022-03-02 | Grant | Kentucky | 21081 | 7550 | 57 |
2266307 | 2266307 | 2022-03-02 | Knott | Kentucky | 21119 | 4025 | 57 |
2237058 | 2237058 | 2022-02-21 | Livingston | Kentucky | 21139 | 2256 | 57 |
2233807 | 2233807 | 2022-02-20 | Livingston | Kentucky | 21139 | 2224 | 57 |
2233822 | 2233822 | 2022-02-20 | Metcalfe | Kentucky | 21169 | 2763 | 57 |
2230556 | 2230556 | 2022-02-19 | Livingston | Kentucky | 21139 | 2224 | 57 |
2230571 | 2230571 | 2022-02-19 | Metcalfe | Kentucky | 21169 | 2763 | 57 |
2227305 | 2227305 | 2022-02-18 | Livingston | Kentucky | 21139 | 2224 | 57 |
2227320 | 2227320 | 2022-02-18 | Metcalfe | Kentucky | 21169 | 2763 | 57 |
2224048 | 2224048 | 2022-02-17 | Lawrence | Kentucky | 21127 | 4288 | 57 |
2224054 | 2224054 | 2022-02-17 | Livingston | Kentucky | 21139 | 2202 | 57 |
2224069 | 2224069 | 2022-02-17 | Metcalfe | Kentucky | 21169 | 2745 | 57 |
2220818 | 2220818 | 2022-02-16 | Metcalfe | Kentucky | 21169 | 2738 | 57 |
2217567 | 2217567 | 2022-02-15 | Metcalfe | Kentucky | 21169 | 2728 | 57 |
2214316 | 2214316 | 2022-02-14 | Metcalfe | Kentucky | 21169 | 2716 | 57 |
2210996 | 2210996 | 2022-02-13 | Caldwell | Kentucky | 21033 | 3732 | 57 |
2207743 | 2207743 | 2022-02-12 | Caldwell | Kentucky | 21033 | 3732 | 57 |
2204490 | 2204490 | 2022-02-11 | Caldwell | Kentucky | 21033 | 3732 | 57 |
2201237 | 2201237 | 2022-02-10 | Caldwell | Kentucky | 21033 | 3722 | 57 |
2197983 | 2197983 | 2022-02-09 | Caldwell | Kentucky | 21033 | 3708 | 57 |
2194729 | 2194729 | 2022-02-08 | Caldwell | Kentucky | 21033 | 3693 | 57 |
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);