ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
751 rows where deaths = 34 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- McCreary 82
- Casey 69
- Bath 46
- Mason 30
- Gallatin 29
- Edmonson 28
- Spencer 24
- Green 21
- Knox 20
- Webster 20
- Johnson 19
- Lyon 19
- Fleming 18
- Hopkins 17
- Breckinridge 14
- Carroll 14
- Clinton 14
- Magoffin 14
- Pendleton 14
- Barren 13
- Carter 13
- Owen 12
- Meade 11
- Caldwell 9
- Lee 9
- Graves 8
- Hart 8
- Ohio 8
- Knott 7
- Lawrence 7
- …
state 1
- Kentucky · 751 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500650 | 2500650 | 2022-05-13 | Lyon | Kentucky | 21143 | 2881 | 34 |
2500672 | 2500672 | 2022-05-13 | Owen | Kentucky | 21187 | 2370 | 34 |
2497392 | 2497392 | 2022-05-12 | Lyon | Kentucky | 21143 | 2881 | 34 |
2497414 | 2497414 | 2022-05-12 | Owen | Kentucky | 21187 | 2370 | 34 |
2494134 | 2494134 | 2022-05-11 | Lyon | Kentucky | 21143 | 2881 | 34 |
2494156 | 2494156 | 2022-05-11 | Owen | Kentucky | 21187 | 2370 | 34 |
2490876 | 2490876 | 2022-05-10 | Lyon | Kentucky | 21143 | 2881 | 34 |
2490898 | 2490898 | 2022-05-10 | Owen | Kentucky | 21187 | 2370 | 34 |
2487619 | 2487619 | 2022-05-09 | Lyon | Kentucky | 21143 | 2881 | 34 |
2487641 | 2487641 | 2022-05-09 | Owen | Kentucky | 21187 | 2370 | 34 |
2484361 | 2484361 | 2022-05-08 | Lyon | Kentucky | 21143 | 2874 | 34 |
2484383 | 2484383 | 2022-05-08 | Owen | Kentucky | 21187 | 2369 | 34 |
2481103 | 2481103 | 2022-05-07 | Lyon | Kentucky | 21143 | 2874 | 34 |
2481125 | 2481125 | 2022-05-07 | Owen | Kentucky | 21187 | 2369 | 34 |
2477845 | 2477845 | 2022-05-06 | Lyon | Kentucky | 21143 | 2874 | 34 |
2477867 | 2477867 | 2022-05-06 | Owen | Kentucky | 21187 | 2369 | 34 |
2474587 | 2474587 | 2022-05-05 | Lyon | Kentucky | 21143 | 2874 | 34 |
2474609 | 2474609 | 2022-05-05 | Owen | Kentucky | 21187 | 2369 | 34 |
2471330 | 2471330 | 2022-05-04 | Lyon | Kentucky | 21143 | 2874 | 34 |
2471352 | 2471352 | 2022-05-04 | Owen | Kentucky | 21187 | 2369 | 34 |
2468074 | 2468074 | 2022-05-03 | Lyon | Kentucky | 21143 | 2874 | 34 |
2468096 | 2468096 | 2022-05-03 | Owen | Kentucky | 21187 | 2369 | 34 |
2464819 | 2464819 | 2022-05-02 | Lyon | Kentucky | 21143 | 2874 | 34 |
2464841 | 2464841 | 2022-05-02 | Owen | Kentucky | 21187 | 2369 | 34 |
2461563 | 2461563 | 2022-05-01 | Lyon | Kentucky | 21143 | 2869 | 34 |
2458307 | 2458307 | 2022-04-30 | Lyon | Kentucky | 21143 | 2869 | 34 |
2455051 | 2455051 | 2022-04-29 | Lyon | Kentucky | 21143 | 2869 | 34 |
2451795 | 2451795 | 2022-04-28 | Lyon | Kentucky | 21143 | 2869 | 34 |
2448539 | 2448539 | 2022-04-27 | Lyon | Kentucky | 21143 | 2869 | 34 |
2445283 | 2445283 | 2022-04-26 | Lyon | Kentucky | 21143 | 2869 | 34 |
2442027 | 2442027 | 2022-04-25 | Lyon | Kentucky | 21143 | 2869 | 34 |
2302118 | 2302118 | 2022-03-13 | Pendleton | Kentucky | 21191 | 3416 | 34 |
2298866 | 2298866 | 2022-03-12 | Pendleton | Kentucky | 21191 | 3416 | 34 |
2295614 | 2295614 | 2022-03-11 | Pendleton | Kentucky | 21191 | 3416 | 34 |
2292362 | 2292362 | 2022-03-10 | Pendleton | Kentucky | 21191 | 3416 | 34 |
2289110 | 2289110 | 2022-03-09 | Pendleton | Kentucky | 21191 | 3416 | 34 |
2285859 | 2285859 | 2022-03-08 | Pendleton | Kentucky | 21191 | 3416 | 34 |
2282607 | 2282607 | 2022-03-07 | Pendleton | Kentucky | 21191 | 3416 | 34 |
2279354 | 2279354 | 2022-03-06 | Pendleton | Kentucky | 21191 | 3415 | 34 |
2276101 | 2276101 | 2022-03-05 | Pendleton | Kentucky | 21191 | 3415 | 34 |
2272848 | 2272848 | 2022-03-04 | Pendleton | Kentucky | 21191 | 3415 | 34 |
2269596 | 2269596 | 2022-03-03 | Pendleton | Kentucky | 21191 | 3412 | 34 |
2266343 | 2266343 | 2022-03-02 | Pendleton | Kentucky | 21191 | 3410 | 34 |
2263092 | 2263092 | 2022-03-01 | Pendleton | Kentucky | 21191 | 3409 | 34 |
2259841 | 2259841 | 2022-02-28 | Pendleton | Kentucky | 21191 | 3408 | 34 |
2175308 | 2175308 | 2022-02-02 | Trimble | Kentucky | 21223 | 2029 | 34 |
2172055 | 2172055 | 2022-02-01 | Trimble | Kentucky | 21223 | 2017 | 34 |
2168802 | 2168802 | 2022-01-31 | Trimble | Kentucky | 21223 | 1994 | 34 |
2165547 | 2165547 | 2022-01-30 | Trimble | Kentucky | 21223 | 1970 | 34 |
2162292 | 2162292 | 2022-01-29 | Trimble | Kentucky | 21223 | 1970 | 34 |
2159037 | 2159037 | 2022-01-28 | Trimble | Kentucky | 21223 | 1970 | 34 |
2155677 | 2155677 | 2022-01-27 | Bath | Kentucky | 21011 | 2366 | 34 |
2155783 | 2155783 | 2022-01-27 | Trimble | Kentucky | 21223 | 1946 | 34 |
2152424 | 2152424 | 2022-01-26 | Bath | Kentucky | 21011 | 2345 | 34 |
2149172 | 2149172 | 2022-01-25 | Bath | Kentucky | 21011 | 2327 | 34 |
2149277 | 2149277 | 2022-01-25 | Trigg | Kentucky | 21221 | 2945 | 34 |
2145920 | 2145920 | 2022-01-24 | Bath | Kentucky | 21011 | 2306 | 34 |
2146025 | 2146025 | 2022-01-24 | Trigg | Kentucky | 21221 | 2935 | 34 |
2142665 | 2142665 | 2022-01-23 | Bath | Kentucky | 21011 | 2271 | 34 |
2142770 | 2142770 | 2022-01-23 | Trigg | Kentucky | 21221 | 2890 | 34 |
2139410 | 2139410 | 2022-01-22 | Bath | Kentucky | 21011 | 2271 | 34 |
2139515 | 2139515 | 2022-01-22 | Trigg | Kentucky | 21221 | 2890 | 34 |
2136154 | 2136154 | 2022-01-21 | Bath | Kentucky | 21011 | 2271 | 34 |
2136259 | 2136259 | 2022-01-21 | Trigg | Kentucky | 21221 | 2890 | 34 |
2132902 | 2132902 | 2022-01-20 | Bath | Kentucky | 21011 | 2247 | 34 |
2133007 | 2133007 | 2022-01-20 | Trigg | Kentucky | 21221 | 2875 | 34 |
2129649 | 2129649 | 2022-01-19 | Bath | Kentucky | 21011 | 2227 | 34 |
2126395 | 2126395 | 2022-01-18 | Bath | Kentucky | 21011 | 2210 | 34 |
2123143 | 2123143 | 2022-01-17 | Bath | Kentucky | 21011 | 2143 | 34 |
2119891 | 2119891 | 2022-01-16 | Bath | Kentucky | 21011 | 2143 | 34 |
2116639 | 2116639 | 2022-01-15 | Bath | Kentucky | 21011 | 2143 | 34 |
2113388 | 2113388 | 2022-01-14 | Bath | Kentucky | 21011 | 2143 | 34 |
2110136 | 2110136 | 2022-01-13 | Bath | Kentucky | 21011 | 2118 | 34 |
2106885 | 2106885 | 2022-01-12 | Bath | Kentucky | 21011 | 2103 | 34 |
2103634 | 2103634 | 2022-01-11 | Bath | Kentucky | 21011 | 2089 | 34 |
2100383 | 2100383 | 2022-01-10 | Bath | Kentucky | 21011 | 2082 | 34 |
2097132 | 2097132 | 2022-01-09 | Bath | Kentucky | 21011 | 2065 | 34 |
2093880 | 2093880 | 2022-01-08 | Bath | Kentucky | 21011 | 2065 | 34 |
2090628 | 2090628 | 2022-01-07 | Bath | Kentucky | 21011 | 2065 | 34 |
2087377 | 2087377 | 2022-01-06 | Bath | Kentucky | 21011 | 2059 | 34 |
2087402 | 2087402 | 2022-01-06 | Edmonson | Kentucky | 21061 | 1854 | 34 |
2084125 | 2084125 | 2022-01-05 | Bath | Kentucky | 21011 | 2050 | 34 |
2084150 | 2084150 | 2022-01-05 | Edmonson | Kentucky | 21061 | 1841 | 34 |
2080873 | 2080873 | 2022-01-04 | Bath | Kentucky | 21011 | 2040 | 34 |
2080898 | 2080898 | 2022-01-04 | Edmonson | Kentucky | 21061 | 1824 | 34 |
2077621 | 2077621 | 2022-01-03 | Bath | Kentucky | 21011 | 2038 | 34 |
2077646 | 2077646 | 2022-01-03 | Edmonson | Kentucky | 21061 | 1813 | 34 |
2074370 | 2074370 | 2022-01-02 | Bath | Kentucky | 21011 | 2014 | 34 |
2074385 | 2074385 | 2022-01-02 | Carroll | Kentucky | 21041 | 2348 | 34 |
2074395 | 2074395 | 2022-01-02 | Edmonson | Kentucky | 21061 | 1748 | 34 |
2071119 | 2071119 | 2022-01-01 | Bath | Kentucky | 21011 | 2014 | 34 |
2071134 | 2071134 | 2022-01-01 | Carroll | Kentucky | 21041 | 2348 | 34 |
2071144 | 2071144 | 2022-01-01 | Edmonson | Kentucky | 21061 | 1748 | 34 |
2067868 | 2067868 | 2021-12-31 | Bath | Kentucky | 21011 | 2014 | 34 |
2067883 | 2067883 | 2021-12-31 | Carroll | Kentucky | 21041 | 2348 | 34 |
2067893 | 2067893 | 2021-12-31 | Edmonson | Kentucky | 21061 | 1748 | 34 |
2064617 | 2064617 | 2021-12-30 | Bath | Kentucky | 21011 | 2014 | 34 |
2064632 | 2064632 | 2021-12-30 | Carroll | Kentucky | 21041 | 2348 | 34 |
2064642 | 2064642 | 2021-12-30 | Edmonson | Kentucky | 21061 | 1748 | 34 |
2061367 | 2061367 | 2021-12-29 | Bath | Kentucky | 21011 | 2014 | 34 |
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);