ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 1469 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1710510 | 1710510 | 2021-09-12 | Todd | Kentucky | 21219 | 1469 | 28 |
1707263 | 1707263 | 2021-09-11 | Todd | Kentucky | 21219 | 1469 | 28 |
1704015 | 1704015 | 2021-09-10 | Todd | Kentucky | 21219 | 1469 | 28 |
1677923 | 1677923 | 2021-09-02 | Breathitt | Kentucky | 21025 | 1469 | 13 |
1664994 | 1664994 | 2021-08-29 | Magoffin | Kentucky | 21153 | 1469 | 18 |
1661746 | 1661746 | 2021-08-28 | Magoffin | Kentucky | 21153 | 1469 | 18 |
1658498 | 1658498 | 2021-08-27 | Magoffin | Kentucky | 21153 | 1469 | 18 |
1596719 | 1596719 | 2021-08-08 | Breckinridge | Kentucky | 21027 | 1469 | 18 |
1593470 | 1593470 | 2021-08-07 | Breckinridge | Kentucky | 21027 | 1469 | 18 |
1590221 | 1590221 | 2021-08-06 | Breckinridge | Kentucky | 21027 | 1469 | 18 |
1437622 | 1437622 | 2021-06-20 | Caldwell | Kentucky | 21033 | 1469 | 32 |
1434375 | 1434375 | 2021-06-19 | Caldwell | Kentucky | 21033 | 1469 | 32 |
1431129 | 1431129 | 2021-06-18 | Caldwell | Kentucky | 21033 | 1469 | 32 |
1349987 | 1349987 | 2021-05-24 | Butler | Kentucky | 21031 | 1469 | 24 |
1346740 | 1346740 | 2021-05-23 | Butler | Kentucky | 21031 | 1469 | 24 |
1343492 | 1343492 | 2021-05-22 | Butler | Kentucky | 21031 | 1469 | 24 |
1236434 | 1236434 | 2021-04-19 | Rockcastle | Kentucky | 21203 | 1469 | 21 |
989696 | 989696 | 2021-02-02 | Russell | Kentucky | 21207 | 1469 | 37 |
895560 | 895560 | 2021-01-04 | Mercer | Kentucky | 21167 | 1469 | 6 |
889008 | 889008 | 2021-01-02 | Clark | Kentucky | 21049 | 1469 | 15 |
876094 | 876094 | 2020-12-29 | Ohio | Kentucky | 21183 | 1469 | 30 |
609986 | 609986 | 2020-10-08 | Hardin | Kentucky | 21093 | 1469 | 13 |
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);