ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where "date" is on date 2020-03-31 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
22440 | 22440 | 2020-03-31 | Allen | Kentucky | 21003 | 1 | 0 |
22441 | 22441 | 2020-03-31 | Anderson | Kentucky | 21005 | 2 | 1 |
22442 | 22442 | 2020-03-31 | Barren | Kentucky | 21009 | 1 | 0 |
22443 | 22443 | 2020-03-31 | Boone | Kentucky | 21015 | 5 | 0 |
22444 | 22444 | 2020-03-31 | Bourbon | Kentucky | 21017 | 4 | 1 |
22445 | 22445 | 2020-03-31 | Boyd | Kentucky | 21019 | 4 | 0 |
22446 | 22446 | 2020-03-31 | Boyle | Kentucky | 21021 | 1 | 0 |
22447 | 22447 | 2020-03-31 | Bracken | Kentucky | 21023 | 1 | 0 |
22448 | 22448 | 2020-03-31 | Breathitt | Kentucky | 21025 | 2 | 0 |
22449 | 22449 | 2020-03-31 | Breckinridge | Kentucky | 21027 | 2 | 0 |
22450 | 22450 | 2020-03-31 | Bullitt | Kentucky | 21029 | 6 | 1 |
22451 | 22451 | 2020-03-31 | Butler | Kentucky | 21031 | 1 | 0 |
22452 | 22452 | 2020-03-31 | Calloway | Kentucky | 21035 | 3 | 0 |
22453 | 22453 | 2020-03-31 | Campbell | Kentucky | 21037 | 6 | 0 |
22454 | 22454 | 2020-03-31 | Carroll | Kentucky | 21041 | 2 | 0 |
22455 | 22455 | 2020-03-31 | Christian | Kentucky | 21047 | 8 | 0 |
22456 | 22456 | 2020-03-31 | Clark | Kentucky | 21049 | 8 | 0 |
22457 | 22457 | 2020-03-31 | Daviess | Kentucky | 21059 | 34 | 1 |
22458 | 22458 | 2020-03-31 | Edmonson | Kentucky | 21061 | 2 | 0 |
22459 | 22459 | 2020-03-31 | Fayette | Kentucky | 21067 | 106 | 2 |
22460 | 22460 | 2020-03-31 | Floyd | Kentucky | 21071 | 1 | 0 |
22461 | 22461 | 2020-03-31 | Franklin | Kentucky | 21073 | 6 | 0 |
22462 | 22462 | 2020-03-31 | Grant | Kentucky | 21081 | 1 | 0 |
22463 | 22463 | 2020-03-31 | Graves | Kentucky | 21083 | 1 | 0 |
22464 | 22464 | 2020-03-31 | Grayson | Kentucky | 21085 | 2 | 0 |
22465 | 22465 | 2020-03-31 | Hancock | Kentucky | 21091 | 1 | 0 |
22466 | 22466 | 2020-03-31 | Hardin | Kentucky | 21093 | 6 | 0 |
22467 | 22467 | 2020-03-31 | Harrison | Kentucky | 21097 | 11 | 0 |
22468 | 22468 | 2020-03-31 | Henderson | Kentucky | 21101 | 5 | 0 |
22469 | 22469 | 2020-03-31 | Henry | Kentucky | 21103 | 1 | 0 |
22470 | 22470 | 2020-03-31 | Hopkins | Kentucky | 21107 | 21 | 1 |
22471 | 22471 | 2020-03-31 | Jefferson | Kentucky | 21111 | 190 | 8 |
22472 | 22472 | 2020-03-31 | Jessamine | Kentucky | 21113 | 14 | 0 |
22473 | 22473 | 2020-03-31 | Kenton | Kentucky | 21117 | 21 | 2 |
22474 | 22474 | 2020-03-31 | Larue | Kentucky | 21123 | 2 | 0 |
22475 | 22475 | 2020-03-31 | Laurel | Kentucky | 21125 | 2 | 0 |
22476 | 22476 | 2020-03-31 | Lawrence | Kentucky | 21127 | 1 | 0 |
22477 | 22477 | 2020-03-31 | Lewis | Kentucky | 21135 | 1 | 0 |
22478 | 22478 | 2020-03-31 | Logan | Kentucky | 21141 | 2 | 0 |
22479 | 22479 | 2020-03-31 | Lyon | Kentucky | 21143 | 1 | 0 |
22480 | 22480 | 2020-03-31 | Madison | Kentucky | 21151 | 9 | 0 |
22481 | 22481 | 2020-03-31 | Marion | Kentucky | 21155 | 1 | 0 |
22482 | 22482 | 2020-03-31 | Marshall | Kentucky | 21157 | 1 | 0 |
22483 | 22483 | 2020-03-31 | Martin | Kentucky | 21159 | 1 | 0 |
22484 | 22484 | 2020-03-31 | Mason | Kentucky | 21161 | 1 | 0 |
22485 | 22485 | 2020-03-31 | McCracken | Kentucky | 21145 | 6 | 0 |
22486 | 22486 | 2020-03-31 | McCreary | Kentucky | 21147 | 1 | 0 |
22487 | 22487 | 2020-03-31 | Menifee | Kentucky | 21165 | 2 | 0 |
22488 | 22488 | 2020-03-31 | Mercer | Kentucky | 21167 | 2 | 0 |
22489 | 22489 | 2020-03-31 | Montgomery | Kentucky | 21173 | 3 | 0 |
22490 | 22490 | 2020-03-31 | Muhlenberg | Kentucky | 21177 | 8 | 0 |
22491 | 22491 | 2020-03-31 | Nelson | Kentucky | 21179 | 3 | 0 |
22492 | 22492 | 2020-03-31 | Nicholas | Kentucky | 21181 | 1 | 0 |
22493 | 22493 | 2020-03-31 | Oldham | Kentucky | 21185 | 3 | 0 |
22494 | 22494 | 2020-03-31 | Powell | Kentucky | 21197 | 1 | 0 |
22495 | 22495 | 2020-03-31 | Pulaski | Kentucky | 21199 | 8 | 0 |
22496 | 22496 | 2020-03-31 | Rockcastle | Kentucky | 21203 | 1 | 0 |
22497 | 22497 | 2020-03-31 | Russell | Kentucky | 21207 | 1 | 0 |
22498 | 22498 | 2020-03-31 | Scott | Kentucky | 21209 | 7 | 0 |
22499 | 22499 | 2020-03-31 | Shelby | Kentucky | 21211 | 4 | 0 |
22500 | 22500 | 2020-03-31 | Simpson | Kentucky | 21213 | 5 | 1 |
22501 | 22501 | 2020-03-31 | Spencer | Kentucky | 21215 | 2 | 0 |
22502 | 22502 | 2020-03-31 | Taylor | Kentucky | 21217 | 2 | 0 |
22503 | 22503 | 2020-03-31 | Union | Kentucky | 21225 | 2 | 0 |
22504 | 22504 | 2020-03-31 | Warren | Kentucky | 21227 | 13 | 0 |
22505 | 22505 | 2020-03-31 | Washington | Kentucky | 21229 | 2 | 0 |
22506 | 22506 | 2020-03-31 | Wayne | Kentucky | 21231 | 3 | 0 |
22507 | 22507 | 2020-03-31 | Webster | Kentucky | 21233 | 2 | 0 |
22508 | 22508 | 2020-03-31 | Woodford | Kentucky | 21239 | 6 | 0 |
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);