ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where "date" is on date 2020-04-08 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adair 1
- Allen 1
- Anderson 1
- Ballard 1
- Barren 1
- Bath 1
- Boone 1
- Bourbon 1
- Boyd 1
- Boyle 1
- Bracken 1
- Breathitt 1
- Breckinridge 1
- Bullitt 1
- Butler 1
- Caldwell 1
- Calloway 1
- Campbell 1
- Carroll 1
- Carter 1
- Christian 1
- Clark 1
- Clinton 1
- Crittenden 1
- Cumberland 1
- Daviess 1
- Edmonson 1
- Fayette 1
- Floyd 1
- Franklin 1
- …
state 1
- Kentucky · 95 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
41477 | 41477 | 2020-04-08 | Adair | Kentucky | 21001 | 4 | 1 |
41478 | 41478 | 2020-04-08 | Allen | Kentucky | 21003 | 3 | 0 |
41479 | 41479 | 2020-04-08 | Anderson | Kentucky | 21005 | 3 | 1 |
41480 | 41480 | 2020-04-08 | Ballard | Kentucky | 21007 | 1 | 0 |
41481 | 41481 | 2020-04-08 | Barren | Kentucky | 21009 | 2 | 0 |
41482 | 41482 | 2020-04-08 | Bath | Kentucky | 21011 | 1 | 0 |
41483 | 41483 | 2020-04-08 | Boone | Kentucky | 21015 | 34 | 1 |
41484 | 41484 | 2020-04-08 | Bourbon | Kentucky | 21017 | 4 | 1 |
41485 | 41485 | 2020-04-08 | Boyd | Kentucky | 21019 | 20 | 2 |
41486 | 41486 | 2020-04-08 | Boyle | Kentucky | 21021 | 8 | 0 |
41487 | 41487 | 2020-04-08 | Bracken | Kentucky | 21023 | 1 | 0 |
41488 | 41488 | 2020-04-08 | Breathitt | Kentucky | 21025 | 2 | 0 |
41489 | 41489 | 2020-04-08 | Breckinridge | Kentucky | 21027 | 3 | 0 |
41490 | 41490 | 2020-04-08 | Bullitt | Kentucky | 21029 | 14 | 2 |
41491 | 41491 | 2020-04-08 | Butler | Kentucky | 21031 | 2 | 0 |
41492 | 41492 | 2020-04-08 | Caldwell | Kentucky | 21033 | 5 | 0 |
41493 | 41493 | 2020-04-08 | Calloway | Kentucky | 21035 | 8 | 1 |
41494 | 41494 | 2020-04-08 | Campbell | Kentucky | 21037 | 37 | 3 |
41495 | 41495 | 2020-04-08 | Carroll | Kentucky | 21041 | 2 | 0 |
41496 | 41496 | 2020-04-08 | Carter | Kentucky | 21043 | 1 | 0 |
41497 | 41497 | 2020-04-08 | Christian | Kentucky | 21047 | 45 | 0 |
41498 | 41498 | 2020-04-08 | Clark | Kentucky | 21049 | 11 | 0 |
41499 | 41499 | 2020-04-08 | Clinton | Kentucky | 21053 | 1 | 0 |
41500 | 41500 | 2020-04-08 | Crittenden | Kentucky | 21055 | 3 | 0 |
41501 | 41501 | 2020-04-08 | Cumberland | Kentucky | 21057 | 1 | 0 |
41502 | 41502 | 2020-04-08 | Daviess | Kentucky | 21059 | 63 | 2 |
41503 | 41503 | 2020-04-08 | Edmonson | Kentucky | 21061 | 6 | 0 |
41504 | 41504 | 2020-04-08 | Fayette | Kentucky | 21067 | 170 | 7 |
41505 | 41505 | 2020-04-08 | Floyd | Kentucky | 21071 | 1 | 0 |
41506 | 41506 | 2020-04-08 | Franklin | Kentucky | 21073 | 10 | 0 |
41507 | 41507 | 2020-04-08 | Grant | Kentucky | 21081 | 9 | 1 |
41508 | 41508 | 2020-04-08 | Graves | Kentucky | 21083 | 5 | 0 |
41509 | 41509 | 2020-04-08 | Grayson | Kentucky | 21085 | 2 | 0 |
41510 | 41510 | 2020-04-08 | Green | Kentucky | 21087 | 2 | 0 |
41511 | 41511 | 2020-04-08 | Greenup | Kentucky | 21089 | 2 | 0 |
41512 | 41512 | 2020-04-08 | Hancock | Kentucky | 21091 | 2 | 0 |
41513 | 41513 | 2020-04-08 | Hardin | Kentucky | 21093 | 11 | 0 |
41514 | 41514 | 2020-04-08 | Harrison | Kentucky | 21097 | 14 | 0 |
41515 | 41515 | 2020-04-08 | Hart | Kentucky | 21099 | 1 | 0 |
41516 | 41516 | 2020-04-08 | Henderson | Kentucky | 21101 | 20 | 0 |
41517 | 41517 | 2020-04-08 | Henry | Kentucky | 21103 | 3 | 0 |
41518 | 41518 | 2020-04-08 | Hopkins | Kentucky | 21107 | 57 | 3 |
41519 | 41519 | 2020-04-08 | Jackson | Kentucky | 21109 | 3 | 0 |
41520 | 41520 | 2020-04-08 | Jefferson | Kentucky | 21111 | 402 | 27 |
41521 | 41521 | 2020-04-08 | Jessamine | Kentucky | 21113 | 18 | 0 |
41522 | 41522 | 2020-04-08 | Johnson | Kentucky | 21115 | 1 | 0 |
41523 | 41523 | 2020-04-08 | Kenton | Kentucky | 21117 | 75 | 8 |
41524 | 41524 | 2020-04-08 | Larue | Kentucky | 21123 | 3 | 0 |
41525 | 41525 | 2020-04-08 | Laurel | Kentucky | 21125 | 3 | 0 |
41526 | 41526 | 2020-04-08 | Lawrence | Kentucky | 21127 | 1 | 0 |
41527 | 41527 | 2020-04-08 | Leslie | Kentucky | 21131 | 1 | 0 |
41528 | 41528 | 2020-04-08 | Letcher | Kentucky | 21133 | 1 | 0 |
41529 | 41529 | 2020-04-08 | Lewis | Kentucky | 21135 | 2 | 0 |
41530 | 41530 | 2020-04-08 | Lincoln | Kentucky | 21137 | 1 | 0 |
41531 | 41531 | 2020-04-08 | Logan | Kentucky | 21141 | 5 | 0 |
41532 | 41532 | 2020-04-08 | Lyon | Kentucky | 21143 | 6 | 2 |
41533 | 41533 | 2020-04-08 | Madison | Kentucky | 21151 | 14 | 1 |
41534 | 41534 | 2020-04-08 | Marion | Kentucky | 21155 | 5 | 0 |
41535 | 41535 | 2020-04-08 | Marshall | Kentucky | 21157 | 8 | 0 |
41536 | 41536 | 2020-04-08 | Martin | Kentucky | 21159 | 4 | 0 |
41537 | 41537 | 2020-04-08 | Mason | Kentucky | 21161 | 3 | 0 |
41538 | 41538 | 2020-04-08 | McCracken | Kentucky | 21145 | 13 | 1 |
41539 | 41539 | 2020-04-08 | McCreary | Kentucky | 21147 | 3 | 0 |
41540 | 41540 | 2020-04-08 | McLean | Kentucky | 21149 | 3 | 0 |
41541 | 41541 | 2020-04-08 | Meade | Kentucky | 21163 | 2 | 0 |
41542 | 41542 | 2020-04-08 | Menifee | Kentucky | 21165 | 3 | 0 |
41543 | 41543 | 2020-04-08 | Mercer | Kentucky | 21167 | 4 | 0 |
41544 | 41544 | 2020-04-08 | Monroe | Kentucky | 21171 | 2 | 0 |
41545 | 41545 | 2020-04-08 | Montgomery | Kentucky | 21173 | 7 | 0 |
41546 | 41546 | 2020-04-08 | Muhlenberg | Kentucky | 21177 | 26 | 0 |
41547 | 41547 | 2020-04-08 | Nelson | Kentucky | 21179 | 7 | 0 |
41548 | 41548 | 2020-04-08 | Nicholas | Kentucky | 21181 | 1 | 0 |
41549 | 41549 | 2020-04-08 | Ohio | Kentucky | 21183 | 6 | 0 |
41550 | 41550 | 2020-04-08 | Oldham | Kentucky | 21185 | 11 | 0 |
41551 | 41551 | 2020-04-08 | Pendleton | Kentucky | 21191 | 3 | 0 |
41552 | 41552 | 2020-04-08 | Perry | Kentucky | 21193 | 3 | 0 |
41553 | 41553 | 2020-04-08 | Pike | Kentucky | 21195 | 1 | 0 |
41554 | 41554 | 2020-04-08 | Powell | Kentucky | 21197 | 1 | 0 |
41555 | 41555 | 2020-04-08 | Pulaski | Kentucky | 21199 | 26 | 1 |
41556 | 41556 | 2020-04-08 | Rockcastle | Kentucky | 21203 | 6 | 0 |
41557 | 41557 | 2020-04-08 | Russell | Kentucky | 21207 | 4 | 0 |
41558 | 41558 | 2020-04-08 | Scott | Kentucky | 21209 | 21 | 0 |
41559 | 41559 | 2020-04-08 | Shelby | Kentucky | 21211 | 11 | 0 |
41560 | 41560 | 2020-04-08 | Simpson | Kentucky | 21213 | 14 | 1 |
41561 | 41561 | 2020-04-08 | Spencer | Kentucky | 21215 | 3 | 0 |
41562 | 41562 | 2020-04-08 | Taylor | Kentucky | 21217 | 3 | 0 |
41563 | 41563 | 2020-04-08 | Todd | Kentucky | 21219 | 3 | 0 |
41564 | 41564 | 2020-04-08 | Union | Kentucky | 21225 | 4 | 0 |
41565 | 41565 | 2020-04-08 | Unknown | Kentucky | 0 | 7 | |
41566 | 41566 | 2020-04-08 | Warren | Kentucky | 21227 | 32 | 0 |
41567 | 41567 | 2020-04-08 | Washington | Kentucky | 21229 | 3 | 0 |
41568 | 41568 | 2020-04-08 | Wayne | Kentucky | 21231 | 4 | 0 |
41569 | 41569 | 2020-04-08 | Webster | Kentucky | 21233 | 3 | 0 |
41570 | 41570 | 2020-04-08 | Whitley | Kentucky | 21235 | 1 | 0 |
41571 | 41571 | 2020-04-08 | Woodford | Kentucky | 21239 | 9 | 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);