ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
474 rows where deaths = 59 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Caldwell 49
- Livingston 35
- Greenup 27
- Lincoln 27
- Rockcastle 26
- Monroe 23
- Lawrence 21
- Spencer 19
- Metcalfe 17
- McCreary 15
- Marshall 14
- Casey 13
- Grayson 11
- Jackson 11
- Ohio 11
- Russell 9
- Wayne 9
- Anderson 8
- Carter 8
- Clay 7
- Garrard 7
- Knott 7
- Mercer 7
- Washington 7
- Whitley 7
- Taylor 6
- Warren 6
- Bourbon 5
- Calloway 5
- Fleming 5
- …
state 1
- Kentucky · 474 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500587 | 2500587 | 2022-05-13 | Bourbon | Kentucky | 21017 | 6002 | 59 |
2500613 | 2500613 | 2022-05-13 | Fleming | Kentucky | 21069 | 3928 | 59 |
2500680 | 2500680 | 2022-05-13 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2500686 | 2500686 | 2022-05-13 | Spencer | Kentucky | 21215 | 5384 | 59 |
2497329 | 2497329 | 2022-05-12 | Bourbon | Kentucky | 21017 | 6002 | 59 |
2497355 | 2497355 | 2022-05-12 | Fleming | Kentucky | 21069 | 3928 | 59 |
2497422 | 2497422 | 2022-05-12 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2497428 | 2497428 | 2022-05-12 | Spencer | Kentucky | 21215 | 5384 | 59 |
2494071 | 2494071 | 2022-05-11 | Bourbon | Kentucky | 21017 | 6002 | 59 |
2494097 | 2494097 | 2022-05-11 | Fleming | Kentucky | 21069 | 3928 | 59 |
2494164 | 2494164 | 2022-05-11 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2494170 | 2494170 | 2022-05-11 | Spencer | Kentucky | 21215 | 5384 | 59 |
2490813 | 2490813 | 2022-05-10 | Bourbon | Kentucky | 21017 | 6002 | 59 |
2490839 | 2490839 | 2022-05-10 | Fleming | Kentucky | 21069 | 3928 | 59 |
2490906 | 2490906 | 2022-05-10 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2490912 | 2490912 | 2022-05-10 | Spencer | Kentucky | 21215 | 5384 | 59 |
2487556 | 2487556 | 2022-05-09 | Bourbon | Kentucky | 21017 | 6002 | 59 |
2487582 | 2487582 | 2022-05-09 | Fleming | Kentucky | 21069 | 3928 | 59 |
2487649 | 2487649 | 2022-05-09 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2487655 | 2487655 | 2022-05-09 | Spencer | Kentucky | 21215 | 5384 | 59 |
2484391 | 2484391 | 2022-05-08 | Rockcastle | Kentucky | 21203 | 5049 | 59 |
2484397 | 2484397 | 2022-05-08 | Spencer | Kentucky | 21215 | 5365 | 59 |
2481133 | 2481133 | 2022-05-07 | Rockcastle | Kentucky | 21203 | 5049 | 59 |
2481139 | 2481139 | 2022-05-07 | Spencer | Kentucky | 21215 | 5365 | 59 |
2477875 | 2477875 | 2022-05-06 | Rockcastle | Kentucky | 21203 | 5049 | 59 |
2477881 | 2477881 | 2022-05-06 | Spencer | Kentucky | 21215 | 5365 | 59 |
2474617 | 2474617 | 2022-05-05 | Rockcastle | Kentucky | 21203 | 5049 | 59 |
2474623 | 2474623 | 2022-05-05 | Spencer | Kentucky | 21215 | 5365 | 59 |
2471360 | 2471360 | 2022-05-04 | Rockcastle | Kentucky | 21203 | 5049 | 59 |
2471366 | 2471366 | 2022-05-04 | Spencer | Kentucky | 21215 | 5365 | 59 |
2468104 | 2468104 | 2022-05-03 | Rockcastle | Kentucky | 21203 | 5049 | 59 |
2468110 | 2468110 | 2022-05-03 | Spencer | Kentucky | 21215 | 5365 | 59 |
2464849 | 2464849 | 2022-05-02 | Rockcastle | Kentucky | 21203 | 5049 | 59 |
2464855 | 2464855 | 2022-05-02 | Spencer | Kentucky | 21215 | 5365 | 59 |
2461508 | 2461508 | 2022-05-01 | Caldwell | Kentucky | 21033 | 4131 | 59 |
2461593 | 2461593 | 2022-05-01 | Rockcastle | Kentucky | 21203 | 5047 | 59 |
2461599 | 2461599 | 2022-05-01 | Spencer | Kentucky | 21215 | 5344 | 59 |
2458252 | 2458252 | 2022-04-30 | Caldwell | Kentucky | 21033 | 4131 | 59 |
2458337 | 2458337 | 2022-04-30 | Rockcastle | Kentucky | 21203 | 5047 | 59 |
2458343 | 2458343 | 2022-04-30 | Spencer | Kentucky | 21215 | 5344 | 59 |
2454996 | 2454996 | 2022-04-29 | Caldwell | Kentucky | 21033 | 4131 | 59 |
2455081 | 2455081 | 2022-04-29 | Rockcastle | Kentucky | 21203 | 5047 | 59 |
2455087 | 2455087 | 2022-04-29 | Spencer | Kentucky | 21215 | 5344 | 59 |
2451740 | 2451740 | 2022-04-28 | Caldwell | Kentucky | 21033 | 4131 | 59 |
2451825 | 2451825 | 2022-04-28 | Rockcastle | Kentucky | 21203 | 5047 | 59 |
2451831 | 2451831 | 2022-04-28 | Spencer | Kentucky | 21215 | 5344 | 59 |
2448484 | 2448484 | 2022-04-27 | Caldwell | Kentucky | 21033 | 4131 | 59 |
2448569 | 2448569 | 2022-04-27 | Rockcastle | Kentucky | 21203 | 5047 | 59 |
2448575 | 2448575 | 2022-04-27 | Spencer | Kentucky | 21215 | 5344 | 59 |
2445228 | 2445228 | 2022-04-26 | Caldwell | Kentucky | 21033 | 4131 | 59 |
2445313 | 2445313 | 2022-04-26 | Rockcastle | Kentucky | 21203 | 5047 | 59 |
2445319 | 2445319 | 2022-04-26 | Spencer | Kentucky | 21215 | 5344 | 59 |
2441972 | 2441972 | 2022-04-25 | Caldwell | Kentucky | 21033 | 4131 | 59 |
2442057 | 2442057 | 2022-04-25 | Rockcastle | Kentucky | 21203 | 5047 | 59 |
2442063 | 2442063 | 2022-04-25 | Spencer | Kentucky | 21215 | 5344 | 59 |
2438716 | 2438716 | 2022-04-24 | Caldwell | Kentucky | 21033 | 4123 | 59 |
2438801 | 2438801 | 2022-04-24 | Rockcastle | Kentucky | 21203 | 5044 | 59 |
2435460 | 2435460 | 2022-04-23 | Caldwell | Kentucky | 21033 | 4123 | 59 |
2435545 | 2435545 | 2022-04-23 | Rockcastle | Kentucky | 21203 | 5044 | 59 |
2432204 | 2432204 | 2022-04-22 | Caldwell | Kentucky | 21033 | 4123 | 59 |
2432289 | 2432289 | 2022-04-22 | Rockcastle | Kentucky | 21203 | 5044 | 59 |
2428948 | 2428948 | 2022-04-21 | Caldwell | Kentucky | 21033 | 4123 | 59 |
2429033 | 2429033 | 2022-04-21 | Rockcastle | Kentucky | 21203 | 5044 | 59 |
2425692 | 2425692 | 2022-04-20 | Caldwell | Kentucky | 21033 | 4123 | 59 |
2425777 | 2425777 | 2022-04-20 | Rockcastle | Kentucky | 21203 | 5044 | 59 |
2422436 | 2422436 | 2022-04-19 | Caldwell | Kentucky | 21033 | 4123 | 59 |
2422521 | 2422521 | 2022-04-19 | Rockcastle | Kentucky | 21203 | 5044 | 59 |
2419180 | 2419180 | 2022-04-18 | Caldwell | Kentucky | 21033 | 4123 | 59 |
2419265 | 2419265 | 2022-04-18 | Rockcastle | Kentucky | 21203 | 5044 | 59 |
2415924 | 2415924 | 2022-04-17 | Caldwell | Kentucky | 21033 | 4125 | 59 |
2415977 | 2415977 | 2022-04-17 | Livingston | Kentucky | 21139 | 2466 | 59 |
2412668 | 2412668 | 2022-04-16 | Caldwell | Kentucky | 21033 | 4125 | 59 |
2412721 | 2412721 | 2022-04-16 | Livingston | Kentucky | 21139 | 2466 | 59 |
2409412 | 2409412 | 2022-04-15 | Caldwell | Kentucky | 21033 | 4125 | 59 |
2409465 | 2409465 | 2022-04-15 | Livingston | Kentucky | 21139 | 2466 | 59 |
2406156 | 2406156 | 2022-04-14 | Caldwell | Kentucky | 21033 | 4125 | 59 |
2406209 | 2406209 | 2022-04-14 | Livingston | Kentucky | 21139 | 2466 | 59 |
2402900 | 2402900 | 2022-04-13 | Caldwell | Kentucky | 21033 | 4125 | 59 |
2402953 | 2402953 | 2022-04-13 | Livingston | Kentucky | 21139 | 2466 | 59 |
2399646 | 2399646 | 2022-04-12 | Caldwell | Kentucky | 21033 | 4125 | 59 |
2399699 | 2399699 | 2022-04-12 | Livingston | Kentucky | 21139 | 2466 | 59 |
2396390 | 2396390 | 2022-04-11 | Caldwell | Kentucky | 21033 | 4125 | 59 |
2396443 | 2396443 | 2022-04-11 | Livingston | Kentucky | 21139 | 2466 | 59 |
2393135 | 2393135 | 2022-04-10 | Caldwell | Kentucky | 21033 | 4124 | 59 |
2393188 | 2393188 | 2022-04-10 | Livingston | Kentucky | 21139 | 2468 | 59 |
2393233 | 2393233 | 2022-04-10 | Washington | Kentucky | 21229 | 3921 | 59 |
2389879 | 2389879 | 2022-04-09 | Caldwell | Kentucky | 21033 | 4124 | 59 |
2389932 | 2389932 | 2022-04-09 | Livingston | Kentucky | 21139 | 2468 | 59 |
2389977 | 2389977 | 2022-04-09 | Washington | Kentucky | 21229 | 3921 | 59 |
2386623 | 2386623 | 2022-04-08 | Caldwell | Kentucky | 21033 | 4124 | 59 |
2386676 | 2386676 | 2022-04-08 | Livingston | Kentucky | 21139 | 2468 | 59 |
2386721 | 2386721 | 2022-04-08 | Washington | Kentucky | 21229 | 3921 | 59 |
2383368 | 2383368 | 2022-04-07 | Caldwell | Kentucky | 21033 | 4124 | 59 |
2383421 | 2383421 | 2022-04-07 | Livingston | Kentucky | 21139 | 2468 | 59 |
2383466 | 2383466 | 2022-04-07 | Washington | Kentucky | 21229 | 3921 | 59 |
2380113 | 2380113 | 2022-04-06 | Caldwell | Kentucky | 21033 | 4124 | 59 |
2380166 | 2380166 | 2022-04-06 | Livingston | Kentucky | 21139 | 2468 | 59 |
2380211 | 2380211 | 2022-04-06 | Washington | Kentucky | 21229 | 3921 | 59 |
2376858 | 2376858 | 2022-04-05 | Caldwell | Kentucky | 21033 | 4124 | 59 |
2376911 | 2376911 | 2022-04-05 | Livingston | Kentucky | 21139 | 2468 | 59 |
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);