ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,005 rows where deaths = 22 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Hickman 86
- Rowan 73
- Woodford 58
- Lyon 42
- Webster 38
- Grant 35
- Cumberland 34
- Allen 32
- Bath 30
- Knott 29
- Harrison 28
- Bracken 25
- Lewis 24
- Shelby 23
- Martin 22
- Meade 21
- Morgan 21
- Warren 20
- Lee 19
- Owen 18
- Scott 18
- Bullitt 17
- Spencer 15
- Trigg 15
- Bourbon 14
- Rockcastle 14
- Owsley 13
- Anderson 12
- McLean 12
- Fleming 10
- …
state 1
- Kentucky · 1,005 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2415995 | 2415995 | 2022-04-17 | Morgan | Kentucky | 21175 | 5067 | 22 |
2412739 | 2412739 | 2022-04-16 | Morgan | Kentucky | 21175 | 5067 | 22 |
2409483 | 2409483 | 2022-04-15 | Morgan | Kentucky | 21175 | 5067 | 22 |
2406227 | 2406227 | 2022-04-14 | Morgan | Kentucky | 21175 | 5067 | 22 |
2402971 | 2402971 | 2022-04-13 | Morgan | Kentucky | 21175 | 5067 | 22 |
2399717 | 2399717 | 2022-04-12 | Morgan | Kentucky | 21175 | 5067 | 22 |
2396461 | 2396461 | 2022-04-11 | Morgan | Kentucky | 21175 | 5067 | 22 |
2393206 | 2393206 | 2022-04-10 | Morgan | Kentucky | 21175 | 5004 | 22 |
2393237 | 2393237 | 2022-04-10 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2389950 | 2389950 | 2022-04-09 | Morgan | Kentucky | 21175 | 5004 | 22 |
2389981 | 2389981 | 2022-04-09 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2386694 | 2386694 | 2022-04-08 | Morgan | Kentucky | 21175 | 5004 | 22 |
2386725 | 2386725 | 2022-04-08 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2383439 | 2383439 | 2022-04-07 | Morgan | Kentucky | 21175 | 5004 | 22 |
2383470 | 2383470 | 2022-04-07 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2380184 | 2380184 | 2022-04-06 | Morgan | Kentucky | 21175 | 5004 | 22 |
2380215 | 2380215 | 2022-04-06 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2376929 | 2376929 | 2022-04-05 | Morgan | Kentucky | 21175 | 5004 | 22 |
2376960 | 2376960 | 2022-04-05 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2373677 | 2373677 | 2022-04-04 | Morgan | Kentucky | 21175 | 5004 | 22 |
2373708 | 2373708 | 2022-04-04 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2370424 | 2370424 | 2022-04-03 | Morgan | Kentucky | 21175 | 4956 | 22 |
2367171 | 2367171 | 2022-04-02 | Morgan | Kentucky | 21175 | 4956 | 22 |
2363918 | 2363918 | 2022-04-01 | Morgan | Kentucky | 21175 | 4956 | 22 |
2360664 | 2360664 | 2022-03-31 | Morgan | Kentucky | 21175 | 4956 | 22 |
2357410 | 2357410 | 2022-03-30 | Morgan | Kentucky | 21175 | 4956 | 22 |
2354157 | 2354157 | 2022-03-29 | Morgan | Kentucky | 21175 | 4956 | 22 |
2350905 | 2350905 | 2022-03-28 | Morgan | Kentucky | 21175 | 4956 | 22 |
2246794 | 2246794 | 2022-02-24 | Hickman | Kentucky | 21105 | 815 | 22 |
2243543 | 2243543 | 2022-02-23 | Hickman | Kentucky | 21105 | 815 | 22 |
2240292 | 2240292 | 2022-02-22 | Hickman | Kentucky | 21105 | 813 | 22 |
2237041 | 2237041 | 2022-02-21 | Hickman | Kentucky | 21105 | 811 | 22 |
2233790 | 2233790 | 2022-02-20 | Hickman | Kentucky | 21105 | 811 | 22 |
2230539 | 2230539 | 2022-02-19 | Hickman | Kentucky | 21105 | 811 | 22 |
2227288 | 2227288 | 2022-02-18 | Hickman | Kentucky | 21105 | 811 | 22 |
2224037 | 2224037 | 2022-02-17 | Hickman | Kentucky | 21105 | 809 | 22 |
2220786 | 2220786 | 2022-02-16 | Hickman | Kentucky | 21105 | 809 | 22 |
2217535 | 2217535 | 2022-02-15 | Hickman | Kentucky | 21105 | 808 | 22 |
2214284 | 2214284 | 2022-02-14 | Hickman | Kentucky | 21105 | 808 | 22 |
2211032 | 2211032 | 2022-02-13 | Hickman | Kentucky | 21105 | 799 | 22 |
2207779 | 2207779 | 2022-02-12 | Hickman | Kentucky | 21105 | 799 | 22 |
2204526 | 2204526 | 2022-02-11 | Hickman | Kentucky | 21105 | 799 | 22 |
2201273 | 2201273 | 2022-02-10 | Hickman | Kentucky | 21105 | 797 | 22 |
2198019 | 2198019 | 2022-02-09 | Hickman | Kentucky | 21105 | 796 | 22 |
2194765 | 2194765 | 2022-02-08 | Hickman | Kentucky | 21105 | 793 | 22 |
2191511 | 2191511 | 2022-02-07 | Hickman | Kentucky | 21105 | 792 | 22 |
2188258 | 2188258 | 2022-02-06 | Hickman | Kentucky | 21105 | 780 | 22 |
2185005 | 2185005 | 2022-02-05 | Hickman | Kentucky | 21105 | 780 | 22 |
2181753 | 2181753 | 2022-02-04 | Hickman | Kentucky | 21105 | 780 | 22 |
2178502 | 2178502 | 2022-02-03 | Hickman | Kentucky | 21105 | 780 | 22 |
2175249 | 2175249 | 2022-02-02 | Hickman | Kentucky | 21105 | 776 | 22 |
2171996 | 2171996 | 2022-02-01 | Hickman | Kentucky | 21105 | 769 | 22 |
2168743 | 2168743 | 2022-01-31 | Hickman | Kentucky | 21105 | 762 | 22 |
2165447 | 2165447 | 2022-01-30 | Bracken | Kentucky | 21023 | 1944 | 22 |
2165488 | 2165488 | 2022-01-30 | Hickman | Kentucky | 21105 | 748 | 22 |
2162192 | 2162192 | 2022-01-29 | Bracken | Kentucky | 21023 | 1944 | 22 |
2162233 | 2162233 | 2022-01-29 | Hickman | Kentucky | 21105 | 748 | 22 |
2158937 | 2158937 | 2022-01-28 | Bracken | Kentucky | 21023 | 1944 | 22 |
2158978 | 2158978 | 2022-01-28 | Hickman | Kentucky | 21105 | 748 | 22 |
2155683 | 2155683 | 2022-01-27 | Bracken | Kentucky | 21023 | 1906 | 22 |
2155724 | 2155724 | 2022-01-27 | Hickman | Kentucky | 21105 | 733 | 22 |
2152430 | 2152430 | 2022-01-26 | Bracken | Kentucky | 21023 | 1890 | 22 |
2152471 | 2152471 | 2022-01-26 | Hickman | Kentucky | 21105 | 723 | 22 |
2149178 | 2149178 | 2022-01-25 | Bracken | Kentucky | 21023 | 1876 | 22 |
2149219 | 2149219 | 2022-01-25 | Hickman | Kentucky | 21105 | 720 | 22 |
2145926 | 2145926 | 2022-01-24 | Bracken | Kentucky | 21023 | 1850 | 22 |
2145967 | 2145967 | 2022-01-24 | Hickman | Kentucky | 21105 | 713 | 22 |
2142671 | 2142671 | 2022-01-23 | Bracken | Kentucky | 21023 | 1777 | 22 |
2142712 | 2142712 | 2022-01-23 | Hickman | Kentucky | 21105 | 700 | 22 |
2139416 | 2139416 | 2022-01-22 | Bracken | Kentucky | 21023 | 1777 | 22 |
2139457 | 2139457 | 2022-01-22 | Hickman | Kentucky | 21105 | 700 | 22 |
2136160 | 2136160 | 2022-01-21 | Bracken | Kentucky | 21023 | 1777 | 22 |
2136201 | 2136201 | 2022-01-21 | Hickman | Kentucky | 21105 | 700 | 22 |
2132908 | 2132908 | 2022-01-20 | Bracken | Kentucky | 21023 | 1749 | 22 |
2132949 | 2132949 | 2022-01-20 | Hickman | Kentucky | 21105 | 692 | 22 |
2129655 | 2129655 | 2022-01-19 | Bracken | Kentucky | 21023 | 1701 | 22 |
2129696 | 2129696 | 2022-01-19 | Hickman | Kentucky | 21105 | 687 | 22 |
2126401 | 2126401 | 2022-01-18 | Bracken | Kentucky | 21023 | 1688 | 22 |
2126442 | 2126442 | 2022-01-18 | Hickman | Kentucky | 21105 | 677 | 22 |
2123149 | 2123149 | 2022-01-17 | Bracken | Kentucky | 21023 | 1641 | 22 |
2123190 | 2123190 | 2022-01-17 | Hickman | Kentucky | 21105 | 648 | 22 |
2119897 | 2119897 | 2022-01-16 | Bracken | Kentucky | 21023 | 1641 | 22 |
2119938 | 2119938 | 2022-01-16 | Hickman | Kentucky | 21105 | 648 | 22 |
2116645 | 2116645 | 2022-01-15 | Bracken | Kentucky | 21023 | 1641 | 22 |
2116686 | 2116686 | 2022-01-15 | Hickman | Kentucky | 21105 | 648 | 22 |
2113394 | 2113394 | 2022-01-14 | Bracken | Kentucky | 21023 | 1641 | 22 |
2113435 | 2113435 | 2022-01-14 | Hickman | Kentucky | 21105 | 648 | 22 |
2110142 | 2110142 | 2022-01-13 | Bracken | Kentucky | 21023 | 1629 | 22 |
2110183 | 2110183 | 2022-01-13 | Hickman | Kentucky | 21105 | 645 | 22 |
2106891 | 2106891 | 2022-01-12 | Bracken | Kentucky | 21023 | 1610 | 22 |
2106932 | 2106932 | 2022-01-12 | Hickman | Kentucky | 21105 | 644 | 22 |
2103640 | 2103640 | 2022-01-11 | Bracken | Kentucky | 21023 | 1578 | 22 |
2103681 | 2103681 | 2022-01-11 | Hickman | Kentucky | 21105 | 641 | 22 |
2100389 | 2100389 | 2022-01-10 | Bracken | Kentucky | 21023 | 1554 | 22 |
2100430 | 2100430 | 2022-01-10 | Hickman | Kentucky | 21105 | 633 | 22 |
2097138 | 2097138 | 2022-01-09 | Bracken | Kentucky | 21023 | 1540 | 22 |
2097179 | 2097179 | 2022-01-09 | Hickman | Kentucky | 21105 | 630 | 22 |
2093886 | 2093886 | 2022-01-08 | Bracken | Kentucky | 21023 | 1540 | 22 |
2093927 | 2093927 | 2022-01-08 | Hickman | Kentucky | 21105 | 630 | 22 |
2090634 | 2090634 | 2022-01-07 | Bracken | Kentucky | 21023 | 1540 | 22 |
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);