ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
175 rows where deaths = 92 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500604 | 2500604 | 2022-05-13 | Clay | Kentucky | 21051 | 7867 | 92 |
2500694 | 2500694 | 2022-05-13 | Wayne | Kentucky | 21231 | 6107 | 92 |
2497346 | 2497346 | 2022-05-12 | Clay | Kentucky | 21051 | 7867 | 92 |
2497436 | 2497436 | 2022-05-12 | Wayne | Kentucky | 21231 | 6107 | 92 |
2494088 | 2494088 | 2022-05-11 | Clay | Kentucky | 21051 | 7867 | 92 |
2494178 | 2494178 | 2022-05-11 | Wayne | Kentucky | 21231 | 6107 | 92 |
2490830 | 2490830 | 2022-05-10 | Clay | Kentucky | 21051 | 7867 | 92 |
2490920 | 2490920 | 2022-05-10 | Wayne | Kentucky | 21231 | 6107 | 92 |
2487573 | 2487573 | 2022-05-09 | Clay | Kentucky | 21051 | 7867 | 92 |
2487663 | 2487663 | 2022-05-09 | Wayne | Kentucky | 21231 | 6107 | 92 |
2484315 | 2484315 | 2022-05-08 | Clay | Kentucky | 21051 | 7866 | 92 |
2484396 | 2484396 | 2022-05-08 | Simpson | Kentucky | 21213 | 5627 | 92 |
2481057 | 2481057 | 2022-05-07 | Clay | Kentucky | 21051 | 7866 | 92 |
2481138 | 2481138 | 2022-05-07 | Simpson | Kentucky | 21213 | 5627 | 92 |
2477799 | 2477799 | 2022-05-06 | Clay | Kentucky | 21051 | 7866 | 92 |
2477880 | 2477880 | 2022-05-06 | Simpson | Kentucky | 21213 | 5627 | 92 |
2474541 | 2474541 | 2022-05-05 | Clay | Kentucky | 21051 | 7866 | 92 |
2474622 | 2474622 | 2022-05-05 | Simpson | Kentucky | 21213 | 5627 | 92 |
2471284 | 2471284 | 2022-05-04 | Clay | Kentucky | 21051 | 7866 | 92 |
2471365 | 2471365 | 2022-05-04 | Simpson | Kentucky | 21213 | 5627 | 92 |
2468028 | 2468028 | 2022-05-03 | Clay | Kentucky | 21051 | 7866 | 92 |
2468109 | 2468109 | 2022-05-03 | Simpson | Kentucky | 21213 | 5627 | 92 |
2464773 | 2464773 | 2022-05-02 | Clay | Kentucky | 21051 | 7866 | 92 |
2464854 | 2464854 | 2022-05-02 | Simpson | Kentucky | 21213 | 5627 | 92 |
2461517 | 2461517 | 2022-05-01 | Clay | Kentucky | 21051 | 7864 | 92 |
2458261 | 2458261 | 2022-04-30 | Clay | Kentucky | 21051 | 7864 | 92 |
2455005 | 2455005 | 2022-04-29 | Clay | Kentucky | 21051 | 7864 | 92 |
2451749 | 2451749 | 2022-04-28 | Clay | Kentucky | 21051 | 7864 | 92 |
2448493 | 2448493 | 2022-04-27 | Clay | Kentucky | 21051 | 7864 | 92 |
2445237 | 2445237 | 2022-04-26 | Clay | Kentucky | 21051 | 7864 | 92 |
2441981 | 2441981 | 2022-04-25 | Clay | Kentucky | 21051 | 7864 | 92 |
2415925 | 2415925 | 2022-04-17 | Calloway | Kentucky | 21035 | 8119 | 92 |
2412669 | 2412669 | 2022-04-16 | Calloway | Kentucky | 21035 | 8119 | 92 |
2409413 | 2409413 | 2022-04-15 | Calloway | Kentucky | 21035 | 8119 | 92 |
2406157 | 2406157 | 2022-04-14 | Calloway | Kentucky | 21035 | 8119 | 92 |
2402901 | 2402901 | 2022-04-13 | Calloway | Kentucky | 21035 | 8119 | 92 |
2399647 | 2399647 | 2022-04-12 | Calloway | Kentucky | 21035 | 8119 | 92 |
2396391 | 2396391 | 2022-04-11 | Calloway | Kentucky | 21035 | 8119 | 92 |
2269550 | 2269550 | 2022-03-03 | Hart | Kentucky | 21099 | 5332 | 92 |
2266297 | 2266297 | 2022-03-02 | Hart | Kentucky | 21099 | 5327 | 92 |
2263046 | 2263046 | 2022-03-01 | Hart | Kentucky | 21099 | 5325 | 92 |
2259795 | 2259795 | 2022-02-28 | Hart | Kentucky | 21099 | 5318 | 92 |
2256496 | 2256496 | 2022-02-27 | Allen | Kentucky | 21003 | 6504 | 92 |
2256544 | 2256544 | 2022-02-27 | Hart | Kentucky | 21099 | 5314 | 92 |
2256552 | 2256552 | 2022-02-27 | Johnson | Kentucky | 21115 | 5833 | 92 |
2256599 | 2256599 | 2022-02-27 | Scott | Kentucky | 21209 | 15633 | 92 |
2253245 | 2253245 | 2022-02-26 | Allen | Kentucky | 21003 | 6504 | 92 |
2253293 | 2253293 | 2022-02-26 | Hart | Kentucky | 21099 | 5314 | 92 |
2253301 | 2253301 | 2022-02-26 | Johnson | Kentucky | 21115 | 5833 | 92 |
2253348 | 2253348 | 2022-02-26 | Scott | Kentucky | 21209 | 15633 | 92 |
2249994 | 2249994 | 2022-02-25 | Allen | Kentucky | 21003 | 6504 | 92 |
2250042 | 2250042 | 2022-02-25 | Hart | Kentucky | 21099 | 5314 | 92 |
2250050 | 2250050 | 2022-02-25 | Johnson | Kentucky | 21115 | 5833 | 92 |
2250097 | 2250097 | 2022-02-25 | Scott | Kentucky | 21209 | 15633 | 92 |
2246743 | 2246743 | 2022-02-24 | Allen | Kentucky | 21003 | 6497 | 92 |
2246791 | 2246791 | 2022-02-24 | Hart | Kentucky | 21099 | 5311 | 92 |
2246846 | 2246846 | 2022-02-24 | Scott | Kentucky | 21209 | 15564 | 92 |
2243492 | 2243492 | 2022-02-23 | Allen | Kentucky | 21003 | 6497 | 92 |
2243540 | 2243540 | 2022-02-23 | Hart | Kentucky | 21099 | 5311 | 92 |
2243595 | 2243595 | 2022-02-23 | Scott | Kentucky | 21209 | 15564 | 92 |
2240241 | 2240241 | 2022-02-22 | Allen | Kentucky | 21003 | 6487 | 92 |
2240289 | 2240289 | 2022-02-22 | Hart | Kentucky | 21099 | 5301 | 92 |
2240344 | 2240344 | 2022-02-22 | Scott | Kentucky | 21209 | 15513 | 92 |
2236990 | 2236990 | 2022-02-21 | Allen | Kentucky | 21003 | 6480 | 92 |
2237038 | 2237038 | 2022-02-21 | Hart | Kentucky | 21099 | 5300 | 92 |
2237093 | 2237093 | 2022-02-21 | Scott | Kentucky | 21209 | 15476 | 92 |
2233739 | 2233739 | 2022-02-20 | Allen | Kentucky | 21003 | 6461 | 92 |
2230488 | 2230488 | 2022-02-19 | Allen | Kentucky | 21003 | 6461 | 92 |
2227237 | 2227237 | 2022-02-18 | Allen | Kentucky | 21003 | 6461 | 92 |
2223986 | 2223986 | 2022-02-17 | Allen | Kentucky | 21003 | 6440 | 92 |
2220735 | 2220735 | 2022-02-16 | Allen | Kentucky | 21003 | 6422 | 92 |
2217484 | 2217484 | 2022-02-15 | Allen | Kentucky | 21003 | 6413 | 92 |
2214233 | 2214233 | 2022-02-14 | Allen | Kentucky | 21003 | 6396 | 92 |
2214307 | 2214307 | 2022-02-14 | Marshall | Kentucky | 21157 | 8180 | 92 |
2210981 | 2210981 | 2022-02-13 | Allen | Kentucky | 21003 | 6289 | 92 |
2211055 | 2211055 | 2022-02-13 | Marshall | Kentucky | 21157 | 8093 | 92 |
2211071 | 2211071 | 2022-02-13 | Ohio | Kentucky | 21183 | 7051 | 92 |
2207728 | 2207728 | 2022-02-12 | Allen | Kentucky | 21003 | 6289 | 92 |
2207802 | 2207802 | 2022-02-12 | Marshall | Kentucky | 21157 | 8093 | 92 |
2207818 | 2207818 | 2022-02-12 | Ohio | Kentucky | 21183 | 7051 | 92 |
2204475 | 2204475 | 2022-02-11 | Allen | Kentucky | 21003 | 6289 | 92 |
2204549 | 2204549 | 2022-02-11 | Marshall | Kentucky | 21157 | 8093 | 92 |
2204565 | 2204565 | 2022-02-11 | Ohio | Kentucky | 21183 | 7051 | 92 |
2201222 | 2201222 | 2022-02-10 | Allen | Kentucky | 21003 | 6267 | 92 |
2201296 | 2201296 | 2022-02-10 | Marshall | Kentucky | 21157 | 8073 | 92 |
2201312 | 2201312 | 2022-02-10 | Ohio | Kentucky | 21183 | 7023 | 92 |
2197968 | 2197968 | 2022-02-09 | Allen | Kentucky | 21003 | 6248 | 92 |
2198042 | 2198042 | 2022-02-09 | Marshall | Kentucky | 21157 | 8047 | 92 |
2194714 | 2194714 | 2022-02-08 | Allen | Kentucky | 21003 | 6182 | 92 |
2194734 | 2194734 | 2022-02-08 | Carter | Kentucky | 21043 | 7705 | 92 |
2191460 | 2191460 | 2022-02-07 | Allen | Kentucky | 21003 | 6149 | 92 |
2191480 | 2191480 | 2022-02-07 | Carter | Kentucky | 21043 | 7672 | 92 |
2188283 | 2188283 | 2022-02-06 | Mason | Kentucky | 21161 | 4274 | 92 |
2185030 | 2185030 | 2022-02-05 | Mason | Kentucky | 21161 | 4274 | 92 |
2181778 | 2181778 | 2022-02-04 | Mason | Kentucky | 21161 | 4274 | 92 |
2110131 | 2110131 | 2022-01-13 | Adair | Kentucky | 21001 | 4195 | 92 |
2015944 | 2015944 | 2021-12-15 | Mercer | Kentucky | 21167 | 4817 | 92 |
1986674 | 1986674 | 2021-12-06 | Logan | Kentucky | 21141 | 5324 | 92 |
1941107 | 1941107 | 2021-11-22 | Boyle | Kentucky | 21021 | 5579 | 92 |
1921713 | 1921713 | 2021-11-16 | Whitley | Kentucky | 21235 | 9002 | 92 |
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);