ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where deaths = 144 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500639 | 2500639 | 2022-05-13 | Knox | Kentucky | 21121 | 11523 | 144 |
2497381 | 2497381 | 2022-05-12 | Knox | Kentucky | 21121 | 11523 | 144 |
2494123 | 2494123 | 2022-05-11 | Knox | Kentucky | 21121 | 11523 | 144 |
2490865 | 2490865 | 2022-05-10 | Knox | Kentucky | 21121 | 11523 | 144 |
2487608 | 2487608 | 2022-05-09 | Knox | Kentucky | 21121 | 11523 | 144 |
2484334 | 2484334 | 2022-05-08 | Greenup | Kentucky | 21089 | 12076 | 144 |
2481076 | 2481076 | 2022-05-07 | Greenup | Kentucky | 21089 | 12076 | 144 |
2477818 | 2477818 | 2022-05-06 | Greenup | Kentucky | 21089 | 12076 | 144 |
2474560 | 2474560 | 2022-05-05 | Greenup | Kentucky | 21089 | 12076 | 144 |
2471303 | 2471303 | 2022-05-04 | Greenup | Kentucky | 21089 | 12076 | 144 |
2468047 | 2468047 | 2022-05-03 | Greenup | Kentucky | 21089 | 12076 | 144 |
2464792 | 2464792 | 2022-05-02 | Greenup | Kentucky | 21089 | 12076 | 144 |
2302112 | 2302112 | 2022-03-13 | Nelson | Kentucky | 21179 | 14297 | 144 |
2298860 | 2298860 | 2022-03-12 | Nelson | Kentucky | 21179 | 14297 | 144 |
2295608 | 2295608 | 2022-03-11 | Nelson | Kentucky | 21179 | 14297 | 144 |
2292356 | 2292356 | 2022-03-10 | Nelson | Kentucky | 21179 | 14297 | 144 |
2289104 | 2289104 | 2022-03-09 | Nelson | Kentucky | 21179 | 14297 | 144 |
2285853 | 2285853 | 2022-03-08 | Nelson | Kentucky | 21179 | 14297 | 144 |
2282601 | 2282601 | 2022-03-07 | Nelson | Kentucky | 21179 | 14297 | 144 |
2256600 | 2256600 | 2022-02-27 | Shelby | Kentucky | 21211 | 13042 | 144 |
2253349 | 2253349 | 2022-02-26 | Shelby | Kentucky | 21211 | 13042 | 144 |
2250098 | 2250098 | 2022-02-25 | Shelby | Kentucky | 21211 | 13042 | 144 |
2246838 | 2246838 | 2022-02-24 | Perry | Kentucky | 21193 | 10167 | 144 |
2246847 | 2246847 | 2022-02-24 | Shelby | Kentucky | 21211 | 13013 | 144 |
2243587 | 2243587 | 2022-02-23 | Perry | Kentucky | 21193 | 10167 | 144 |
2243596 | 2243596 | 2022-02-23 | Shelby | Kentucky | 21211 | 13013 | 144 |
2240336 | 2240336 | 2022-02-22 | Perry | Kentucky | 21193 | 10092 | 144 |
2240345 | 2240345 | 2022-02-22 | Shelby | Kentucky | 21211 | 13004 | 144 |
2237085 | 2237085 | 2022-02-21 | Perry | Kentucky | 21193 | 10006 | 144 |
2237094 | 2237094 | 2022-02-21 | Shelby | Kentucky | 21211 | 12982 | 144 |
2233788 | 2233788 | 2022-02-20 | Henderson | Kentucky | 21101 | 13424 | 144 |
2233834 | 2233834 | 2022-02-20 | Perry | Kentucky | 21193 | 9873 | 144 |
2233843 | 2233843 | 2022-02-20 | Shelby | Kentucky | 21211 | 12954 | 144 |
2230537 | 2230537 | 2022-02-19 | Henderson | Kentucky | 21101 | 13424 | 144 |
2230583 | 2230583 | 2022-02-19 | Perry | Kentucky | 21193 | 9873 | 144 |
2230592 | 2230592 | 2022-02-19 | Shelby | Kentucky | 21211 | 12954 | 144 |
2227286 | 2227286 | 2022-02-18 | Henderson | Kentucky | 21101 | 13424 | 144 |
2227332 | 2227332 | 2022-02-18 | Perry | Kentucky | 21193 | 9873 | 144 |
2227341 | 2227341 | 2022-02-18 | Shelby | Kentucky | 21211 | 12954 | 144 |
2224035 | 2224035 | 2022-02-17 | Henderson | Kentucky | 21101 | 13377 | 144 |
2224090 | 2224090 | 2022-02-17 | Shelby | Kentucky | 21211 | 12904 | 144 |
2220784 | 2220784 | 2022-02-16 | Henderson | Kentucky | 21101 | 13325 | 144 |
2217533 | 2217533 | 2022-02-15 | Henderson | Kentucky | 21101 | 13281 | 144 |
2214282 | 2214282 | 2022-02-14 | Henderson | Kentucky | 21101 | 13244 | 144 |
2211030 | 2211030 | 2022-02-13 | Henderson | Kentucky | 21101 | 13042 | 144 |
2207777 | 2207777 | 2022-02-12 | Henderson | Kentucky | 21101 | 13042 | 144 |
2204524 | 2204524 | 2022-02-11 | Henderson | Kentucky | 21101 | 13042 | 144 |
2201271 | 2201271 | 2022-02-10 | Henderson | Kentucky | 21101 | 13001 | 144 |
2198017 | 2198017 | 2022-02-09 | Henderson | Kentucky | 21101 | 12954 | 144 |
2194731 | 2194731 | 2022-02-08 | Campbell | Kentucky | 21037 | 23481 | 144 |
2194763 | 2194763 | 2022-02-08 | Henderson | Kentucky | 21101 | 12925 | 144 |
2191477 | 2191477 | 2022-02-07 | Campbell | Kentucky | 21037 | 23404 | 144 |
2191500 | 2191500 | 2022-02-07 | Graves | Kentucky | 21083 | 10859 | 144 |
2191509 | 2191509 | 2022-02-07 | Henderson | Kentucky | 21101 | 12891 | 144 |
2188224 | 2188224 | 2022-02-06 | Campbell | Kentucky | 21037 | 23306 | 144 |
2188247 | 2188247 | 2022-02-06 | Graves | Kentucky | 21083 | 10764 | 144 |
2184971 | 2184971 | 2022-02-05 | Campbell | Kentucky | 21037 | 23306 | 144 |
2184994 | 2184994 | 2022-02-05 | Graves | Kentucky | 21083 | 10764 | 144 |
2181719 | 2181719 | 2022-02-04 | Campbell | Kentucky | 21037 | 23306 | 144 |
2181742 | 2181742 | 2022-02-04 | Graves | Kentucky | 21083 | 10764 | 144 |
2178491 | 2178491 | 2022-02-03 | Graves | Kentucky | 21083 | 10707 | 144 |
2175238 | 2175238 | 2022-02-02 | Graves | Kentucky | 21083 | 10633 | 144 |
2171985 | 2171985 | 2022-02-01 | Graves | Kentucky | 21083 | 10553 | 144 |
2168732 | 2168732 | 2022-01-31 | Graves | Kentucky | 21083 | 10511 | 144 |
2165477 | 2165477 | 2022-01-30 | Graves | Kentucky | 21083 | 10286 | 144 |
2162222 | 2162222 | 2022-01-29 | Graves | Kentucky | 21083 | 10286 | 144 |
2158967 | 2158967 | 2022-01-28 | Graves | Kentucky | 21083 | 10286 | 144 |
2155713 | 2155713 | 2022-01-27 | Graves | Kentucky | 21083 | 10136 | 144 |
2051649 | 2051649 | 2021-12-26 | Floyd | Kentucky | 21071 | 7949 | 144 |
2048399 | 2048399 | 2021-12-25 | Floyd | Kentucky | 21071 | 7949 | 144 |
2045149 | 2045149 | 2021-12-24 | Floyd | Kentucky | 21071 | 7949 | 144 |
2041900 | 2041900 | 2021-12-23 | Floyd | Kentucky | 21071 | 7949 | 144 |
2038650 | 2038650 | 2021-12-22 | Floyd | Kentucky | 21071 | 7949 | 144 |
2035400 | 2035400 | 2021-12-21 | Floyd | Kentucky | 21071 | 7931 | 144 |
2032150 | 2032150 | 2021-12-20 | Floyd | Kentucky | 21071 | 7899 | 144 |
1807942 | 1807942 | 2021-10-12 | Madison | Kentucky | 21151 | 15416 | 144 |
1804691 | 1804691 | 2021-10-11 | Madison | Kentucky | 21151 | 15339 | 144 |
1801442 | 1801442 | 2021-10-10 | Madison | Kentucky | 21151 | 15236 | 144 |
1798193 | 1798193 | 2021-10-09 | Madison | Kentucky | 21151 | 15236 | 144 |
1794944 | 1794944 | 2021-10-08 | Madison | Kentucky | 21151 | 15236 | 144 |
1791696 | 1791696 | 2021-10-07 | Madison | Kentucky | 21151 | 15168 | 144 |
1788447 | 1788447 | 2021-10-06 | Madison | Kentucky | 21151 | 15117 | 144 |
1785198 | 1785198 | 2021-10-05 | Madison | Kentucky | 21151 | 15042 | 144 |
1781949 | 1781949 | 2021-10-04 | Madison | Kentucky | 21151 | 14979 | 144 |
1259115 | 1259115 | 2021-04-26 | Hopkins | Kentucky | 21107 | 4378 | 144 |
1255868 | 1255868 | 2021-04-25 | Hopkins | Kentucky | 21107 | 4374 | 144 |
1252621 | 1252621 | 2021-04-24 | Hopkins | Kentucky | 21107 | 4372 | 144 |
1249374 | 1249374 | 2021-04-23 | Hopkins | Kentucky | 21107 | 4365 | 144 |
1246127 | 1246127 | 2021-04-22 | Hopkins | Kentucky | 21107 | 4357 | 144 |
1242880 | 1242880 | 2021-04-21 | Hopkins | Kentucky | 21107 | 4343 | 144 |
1239633 | 1239633 | 2021-04-20 | Hopkins | Kentucky | 21107 | 4336 | 144 |
1236386 | 1236386 | 2021-04-19 | Hopkins | Kentucky | 21107 | 4326 | 144 |
1233139 | 1233139 | 2021-04-18 | Hopkins | Kentucky | 21107 | 4326 | 144 |
1229891 | 1229891 | 2021-04-17 | Hopkins | Kentucky | 21107 | 4322 | 144 |
1226643 | 1226643 | 2021-04-16 | Hopkins | Kentucky | 21107 | 4317 | 144 |
1223396 | 1223396 | 2021-04-15 | Hopkins | Kentucky | 21107 | 4312 | 144 |
1220148 | 1220148 | 2021-04-14 | Hopkins | Kentucky | 21107 | 4303 | 144 |
1216900 | 1216900 | 2021-04-13 | Hopkins | Kentucky | 21107 | 4292 | 144 |
1213653 | 1213653 | 2021-04-12 | Hopkins | Kentucky | 21107 | 4282 | 144 |
1210405 | 1210405 | 2021-04-11 | Hopkins | Kentucky | 21107 | 4281 | 144 |
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);