ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where deaths = 127 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2415918 | 2415918 | 2022-04-17 | Boyle | Kentucky | 21021 | 8404 | 127 |
2412662 | 2412662 | 2022-04-16 | Boyle | Kentucky | 21021 | 8404 | 127 |
2409406 | 2409406 | 2022-04-15 | Boyle | Kentucky | 21021 | 8404 | 127 |
2406150 | 2406150 | 2022-04-14 | Boyle | Kentucky | 21021 | 8404 | 127 |
2402894 | 2402894 | 2022-04-13 | Boyle | Kentucky | 21021 | 8404 | 127 |
2399640 | 2399640 | 2022-04-12 | Boyle | Kentucky | 21021 | 8404 | 127 |
2396384 | 2396384 | 2022-04-11 | Boyle | Kentucky | 21021 | 8404 | 127 |
2393129 | 2393129 | 2022-04-10 | Boyle | Kentucky | 21021 | 8394 | 127 |
2393187 | 2393187 | 2022-04-10 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2389873 | 2389873 | 2022-04-09 | Boyle | Kentucky | 21021 | 8394 | 127 |
2389931 | 2389931 | 2022-04-09 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2386617 | 2386617 | 2022-04-08 | Boyle | Kentucky | 21021 | 8394 | 127 |
2386675 | 2386675 | 2022-04-08 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2383362 | 2383362 | 2022-04-07 | Boyle | Kentucky | 21021 | 8394 | 127 |
2383420 | 2383420 | 2022-04-07 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2380107 | 2380107 | 2022-04-06 | Boyle | Kentucky | 21021 | 8394 | 127 |
2380165 | 2380165 | 2022-04-06 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2376852 | 2376852 | 2022-04-05 | Boyle | Kentucky | 21021 | 8394 | 127 |
2376910 | 2376910 | 2022-04-05 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2373600 | 2373600 | 2022-04-04 | Boyle | Kentucky | 21021 | 8394 | 127 |
2373658 | 2373658 | 2022-04-04 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2370405 | 2370405 | 2022-04-03 | Lincoln | Kentucky | 21137 | 6351 | 127 |
2367152 | 2367152 | 2022-04-02 | Lincoln | Kentucky | 21137 | 6351 | 127 |
2363899 | 2363899 | 2022-04-01 | Lincoln | Kentucky | 21137 | 6351 | 127 |
2360645 | 2360645 | 2022-03-31 | Lincoln | Kentucky | 21137 | 6351 | 127 |
2357391 | 2357391 | 2022-03-30 | Lincoln | Kentucky | 21137 | 6351 | 127 |
2354138 | 2354138 | 2022-03-29 | Lincoln | Kentucky | 21137 | 6351 | 127 |
2350886 | 2350886 | 2022-03-28 | Lincoln | Kentucky | 21137 | 6351 | 127 |
2279351 | 2279351 | 2022-03-06 | Oldham | Kentucky | 21185 | 18035 | 127 |
2276098 | 2276098 | 2022-03-05 | Oldham | Kentucky | 21185 | 18035 | 127 |
2272845 | 2272845 | 2022-03-04 | Oldham | Kentucky | 21185 | 18035 | 127 |
2223991 | 2223991 | 2022-02-17 | Bell | Kentucky | 21013 | 8609 | 127 |
2220740 | 2220740 | 2022-02-16 | Bell | Kentucky | 21013 | 8569 | 127 |
2214268 | 2214268 | 2022-02-14 | Franklin | Kentucky | 21073 | 12681 | 127 |
2198056 | 2198056 | 2022-02-09 | Nelson | Kentucky | 21179 | 13812 | 127 |
2194802 | 2194802 | 2022-02-08 | Nelson | Kentucky | 21179 | 13723 | 127 |
2191548 | 2191548 | 2022-02-07 | Nelson | Kentucky | 21179 | 13672 | 127 |
2188295 | 2188295 | 2022-02-06 | Nelson | Kentucky | 21179 | 13626 | 127 |
2185042 | 2185042 | 2022-02-05 | Nelson | Kentucky | 21179 | 13626 | 127 |
2181790 | 2181790 | 2022-02-04 | Nelson | Kentucky | 21179 | 13626 | 127 |
2178539 | 2178539 | 2022-02-03 | Nelson | Kentucky | 21179 | 13584 | 127 |
2175286 | 2175286 | 2022-02-02 | Nelson | Kentucky | 21179 | 13487 | 127 |
2012706 | 2012706 | 2021-12-14 | Perry | Kentucky | 21193 | 6623 | 127 |
2009455 | 2009455 | 2021-12-13 | Perry | Kentucky | 21193 | 6599 | 127 |
1986721 | 1986721 | 2021-12-06 | Whitley | Kentucky | 21235 | 9344 | 127 |
1921637 | 1921637 | 2021-11-16 | Graves | Kentucky | 21083 | 7354 | 127 |
1918387 | 1918387 | 2021-11-15 | Graves | Kentucky | 21083 | 7332 | 127 |
1915137 | 1915137 | 2021-11-14 | Graves | Kentucky | 21083 | 7320 | 127 |
1911887 | 1911887 | 2021-11-13 | Graves | Kentucky | 21083 | 7320 | 127 |
1908638 | 1908638 | 2021-11-12 | Graves | Kentucky | 21083 | 7320 | 127 |
1905389 | 1905389 | 2021-11-11 | Graves | Kentucky | 21083 | 7307 | 127 |
1905410 | 1905410 | 2021-11-11 | Laurel | Kentucky | 21125 | 12966 | 127 |
1902139 | 1902139 | 2021-11-10 | Graves | Kentucky | 21083 | 7307 | 127 |
1902160 | 1902160 | 2021-11-10 | Laurel | Kentucky | 21125 | 12966 | 127 |
1898889 | 1898889 | 2021-11-09 | Graves | Kentucky | 21083 | 7298 | 127 |
1898910 | 1898910 | 2021-11-09 | Laurel | Kentucky | 21125 | 12943 | 127 |
1869617 | 1869617 | 2021-10-31 | Bullitt | Kentucky | 21029 | 12054 | 127 |
1866368 | 1866368 | 2021-10-30 | Bullitt | Kentucky | 21029 | 12054 | 127 |
1863119 | 1863119 | 2021-10-29 | Bullitt | Kentucky | 21029 | 12054 | 127 |
1859870 | 1859870 | 2021-10-28 | Bullitt | Kentucky | 21029 | 12033 | 127 |
1856621 | 1856621 | 2021-10-27 | Bullitt | Kentucky | 21029 | 12016 | 127 |
1853372 | 1853372 | 2021-10-26 | Bullitt | Kentucky | 21029 | 11986 | 127 |
1850123 | 1850123 | 2021-10-25 | Bullitt | Kentucky | 21029 | 11972 | 127 |
1846906 | 1846906 | 2021-10-24 | Harlan | Kentucky | 21095 | 5347 | 127 |
1843656 | 1843656 | 2021-10-23 | Harlan | Kentucky | 21095 | 5347 | 127 |
1840406 | 1840406 | 2021-10-22 | Harlan | Kentucky | 21095 | 5347 | 127 |
1837157 | 1837157 | 2021-10-21 | Harlan | Kentucky | 21095 | 5321 | 127 |
1801374 | 1801374 | 2021-10-10 | Barren | Kentucky | 21009 | 7721 | 127 |
1798125 | 1798125 | 2021-10-09 | Barren | Kentucky | 21009 | 7721 | 127 |
1794876 | 1794876 | 2021-10-08 | Barren | Kentucky | 21009 | 7721 | 127 |
1791628 | 1791628 | 2021-10-07 | Barren | Kentucky | 21009 | 7706 | 127 |
1755956 | 1755956 | 2021-09-26 | Madison | Kentucky | 21151 | 14380 | 127 |
1752708 | 1752708 | 2021-09-25 | Madison | Kentucky | 21151 | 14380 | 127 |
1749459 | 1749459 | 2021-09-24 | Madison | Kentucky | 21151 | 14380 | 127 |
1746209 | 1746209 | 2021-09-23 | Madison | Kentucky | 21151 | 14285 | 127 |
1363035 | 1363035 | 2021-05-28 | McCracken | Kentucky | 21145 | 6827 | 127 |
1359788 | 1359788 | 2021-05-27 | McCracken | Kentucky | 21145 | 6824 | 127 |
1356542 | 1356542 | 2021-05-26 | McCracken | Kentucky | 21145 | 6808 | 127 |
1353296 | 1353296 | 2021-05-25 | McCracken | Kentucky | 21145 | 6805 | 127 |
1350050 | 1350050 | 2021-05-24 | McCracken | Kentucky | 21145 | 6800 | 127 |
1346803 | 1346803 | 2021-05-23 | McCracken | Kentucky | 21145 | 6793 | 127 |
1343555 | 1343555 | 2021-05-22 | McCracken | Kentucky | 21145 | 6788 | 127 |
1031900 | 1031900 | 2021-02-15 | Warren | Kentucky | 21227 | 14137 | 127 |
1028653 | 1028653 | 2021-02-14 | Warren | Kentucky | 21227 | 14113 | 127 |
1025408 | 1025408 | 2021-02-13 | Warren | Kentucky | 21227 | 14063 | 127 |
1022163 | 1022163 | 2021-02-12 | Warren | Kentucky | 21227 | 14029 | 127 |
953921 | 953921 | 2021-01-22 | Daviess | Kentucky | 21059 | 7828 | 127 |
152214 | 152214 | 2020-05-17 | Jefferson | Kentucky | 21111 | 1922 | 127 |
149203 | 149203 | 2020-05-16 | Jefferson | Kentucky | 21111 | 1922 | 127 |
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);