ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where "date" is on date 2020-04-13 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
- Fleming 1
- Floyd 1
- …
state 1
- Kentucky · 104 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
54644 | 54644 | 2020-04-13 | Adair | Kentucky | 21001 | 43 | 1 |
54645 | 54645 | 2020-04-13 | Allen | Kentucky | 21003 | 2 | 0 |
54646 | 54646 | 2020-04-13 | Anderson | Kentucky | 21005 | 3 | 1 |
54647 | 54647 | 2020-04-13 | Ballard | Kentucky | 21007 | 2 | 0 |
54648 | 54648 | 2020-04-13 | Barren | Kentucky | 21009 | 5 | 0 |
54649 | 54649 | 2020-04-13 | Bath | Kentucky | 21011 | 3 | 0 |
54650 | 54650 | 2020-04-13 | Boone | Kentucky | 21015 | 58 | 2 |
54651 | 54651 | 2020-04-13 | Bourbon | Kentucky | 21017 | 4 | 1 |
54652 | 54652 | 2020-04-13 | Boyd | Kentucky | 21019 | 23 | 2 |
54653 | 54653 | 2020-04-13 | Boyle | Kentucky | 21021 | 14 | 0 |
54654 | 54654 | 2020-04-13 | Bracken | Kentucky | 21023 | 5 | 0 |
54655 | 54655 | 2020-04-13 | Breathitt | Kentucky | 21025 | 3 | 0 |
54656 | 54656 | 2020-04-13 | Breckinridge | Kentucky | 21027 | 3 | 0 |
54657 | 54657 | 2020-04-13 | Bullitt | Kentucky | 21029 | 34 | 2 |
54658 | 54658 | 2020-04-13 | Butler | Kentucky | 21031 | 22 | 1 |
54659 | 54659 | 2020-04-13 | Caldwell | Kentucky | 21033 | 9 | 0 |
54660 | 54660 | 2020-04-13 | Calloway | Kentucky | 21035 | 16 | 1 |
54661 | 54661 | 2020-04-13 | Campbell | Kentucky | 21037 | 45 | 3 |
54662 | 54662 | 2020-04-13 | Carroll | Kentucky | 21041 | 2 | 0 |
54663 | 54663 | 2020-04-13 | Carter | Kentucky | 21043 | 3 | 0 |
54664 | 54664 | 2020-04-13 | Christian | Kentucky | 21047 | 69 | 3 |
54665 | 54665 | 2020-04-13 | Clark | Kentucky | 21049 | 18 | 0 |
54666 | 54666 | 2020-04-13 | Clinton | Kentucky | 21053 | 2 | 0 |
54667 | 54667 | 2020-04-13 | Crittenden | Kentucky | 21055 | 3 | 0 |
54668 | 54668 | 2020-04-13 | Cumberland | Kentucky | 21057 | 2 | 0 |
54669 | 54669 | 2020-04-13 | Daviess | Kentucky | 21059 | 87 | 3 |
54670 | 54670 | 2020-04-13 | Edmonson | Kentucky | 21061 | 6 | 0 |
54671 | 54671 | 2020-04-13 | Fayette | Kentucky | 21067 | 197 | 7 |
54672 | 54672 | 2020-04-13 | Fleming | Kentucky | 21069 | 2 | 0 |
54673 | 54673 | 2020-04-13 | Floyd | Kentucky | 21071 | 1 | 0 |
54674 | 54674 | 2020-04-13 | Franklin | Kentucky | 21073 | 11 | 0 |
54675 | 54675 | 2020-04-13 | Gallatin | Kentucky | 21077 | 1 | 0 |
54676 | 54676 | 2020-04-13 | Grant | Kentucky | 21081 | 14 | 1 |
54677 | 54677 | 2020-04-13 | Graves | Kentucky | 21083 | 13 | 0 |
54678 | 54678 | 2020-04-13 | Grayson | Kentucky | 21085 | 5 | 0 |
54679 | 54679 | 2020-04-13 | Green | Kentucky | 21087 | 1 | 0 |
54680 | 54680 | 2020-04-13 | Greenup | Kentucky | 21089 | 5 | 0 |
54681 | 54681 | 2020-04-13 | Hancock | Kentucky | 21091 | 2 | 0 |
54682 | 54682 | 2020-04-13 | Hardin | Kentucky | 21093 | 24 | 0 |
54683 | 54683 | 2020-04-13 | Harrison | Kentucky | 21097 | 15 | 0 |
54684 | 54684 | 2020-04-13 | Hart | Kentucky | 21099 | 1 | 0 |
54685 | 54685 | 2020-04-13 | Henderson | Kentucky | 21101 | 23 | 0 |
54686 | 54686 | 2020-04-13 | Henry | Kentucky | 21103 | 4 | 0 |
54687 | 54687 | 2020-04-13 | Hopkins | Kentucky | 21107 | 88 | 9 |
54688 | 54688 | 2020-04-13 | Jackson | Kentucky | 21109 | 12 | 0 |
54689 | 54689 | 2020-04-13 | Jefferson | Kentucky | 21111 | 531 | 46 |
54690 | 54690 | 2020-04-13 | Jessamine | Kentucky | 21113 | 28 | 0 |
54691 | 54691 | 2020-04-13 | Johnson | Kentucky | 21115 | 1 | 0 |
54692 | 54692 | 2020-04-13 | Kenton | Kentucky | 21117 | 99 | 8 |
54693 | 54693 | 2020-04-13 | Knott | Kentucky | 21119 | 1 | 0 |
54694 | 54694 | 2020-04-13 | Knox | Kentucky | 21121 | 1 | 0 |
54695 | 54695 | 2020-04-13 | Larue | Kentucky | 21123 | 3 | 0 |
54696 | 54696 | 2020-04-13 | Laurel | Kentucky | 21125 | 9 | 2 |
54697 | 54697 | 2020-04-13 | Lawrence | Kentucky | 21127 | 1 | 0 |
54698 | 54698 | 2020-04-13 | Leslie | Kentucky | 21131 | 1 | 0 |
54699 | 54699 | 2020-04-13 | Letcher | Kentucky | 21133 | 1 | 0 |
54700 | 54700 | 2020-04-13 | Lewis | Kentucky | 21135 | 2 | 0 |
54701 | 54701 | 2020-04-13 | Lincoln | Kentucky | 21137 | 1 | 0 |
54702 | 54702 | 2020-04-13 | Logan | Kentucky | 21141 | 5 | 0 |
54703 | 54703 | 2020-04-13 | Lyon | Kentucky | 21143 | 12 | 2 |
54704 | 54704 | 2020-04-13 | Madison | Kentucky | 21151 | 20 | 1 |
54705 | 54705 | 2020-04-13 | Marion | Kentucky | 21155 | 10 | 0 |
54706 | 54706 | 2020-04-13 | Marshall | Kentucky | 21157 | 11 | 0 |
54707 | 54707 | 2020-04-13 | Martin | Kentucky | 21159 | 1 | 0 |
54708 | 54708 | 2020-04-13 | Mason | Kentucky | 21161 | 5 | 0 |
54709 | 54709 | 2020-04-13 | McCracken | Kentucky | 21145 | 23 | 2 |
54710 | 54710 | 2020-04-13 | McCreary | Kentucky | 21147 | 7 | 0 |
54711 | 54711 | 2020-04-13 | McLean | Kentucky | 21149 | 5 | 0 |
54712 | 54712 | 2020-04-13 | Meade | Kentucky | 21163 | 2 | 1 |
54713 | 54713 | 2020-04-13 | Menifee | Kentucky | 21165 | 3 | 0 |
54714 | 54714 | 2020-04-13 | Mercer | Kentucky | 21167 | 9 | 0 |
54715 | 54715 | 2020-04-13 | Monroe | Kentucky | 21171 | 2 | 0 |
54716 | 54716 | 2020-04-13 | Montgomery | Kentucky | 21173 | 8 | 0 |
54717 | 54717 | 2020-04-13 | Morgan | Kentucky | 21175 | 1 | 0 |
54718 | 54718 | 2020-04-13 | Muhlenberg | Kentucky | 21177 | 45 | 2 |
54719 | 54719 | 2020-04-13 | Nelson | Kentucky | 21179 | 13 | 0 |
54720 | 54720 | 2020-04-13 | Nicholas | Kentucky | 21181 | 1 | 0 |
54721 | 54721 | 2020-04-13 | Ohio | Kentucky | 21183 | 8 | 0 |
54722 | 54722 | 2020-04-13 | Oldham | Kentucky | 21185 | 18 | 0 |
54723 | 54723 | 2020-04-13 | Owsley | Kentucky | 21189 | 2 | 0 |
54724 | 54724 | 2020-04-13 | Pendleton | Kentucky | 21191 | 3 | 0 |
54725 | 54725 | 2020-04-13 | Perry | Kentucky | 21193 | 4 | 0 |
54726 | 54726 | 2020-04-13 | Pike | Kentucky | 21195 | 5 | 1 |
54727 | 54727 | 2020-04-13 | Powell | Kentucky | 21197 | 1 | 0 |
54728 | 54728 | 2020-04-13 | Pulaski | Kentucky | 21199 | 31 | 2 |
54729 | 54729 | 2020-04-13 | Rockcastle | Kentucky | 21203 | 9 | 0 |
54730 | 54730 | 2020-04-13 | Rowan | Kentucky | 21205 | 1 | 0 |
54731 | 54731 | 2020-04-13 | Russell | Kentucky | 21207 | 7 | 0 |
54732 | 54732 | 2020-04-13 | Scott | Kentucky | 21209 | 26 | 0 |
54733 | 54733 | 2020-04-13 | Shelby | Kentucky | 21211 | 18 | 1 |
54734 | 54734 | 2020-04-13 | Simpson | Kentucky | 21213 | 16 | 1 |
54735 | 54735 | 2020-04-13 | Spencer | Kentucky | 21215 | 6 | 0 |
54736 | 54736 | 2020-04-13 | Taylor | Kentucky | 21217 | 4 | 0 |
54737 | 54737 | 2020-04-13 | Todd | Kentucky | 21219 | 7 | 0 |
54738 | 54738 | 2020-04-13 | Trigg | Kentucky | 21221 | 4 | 0 |
54739 | 54739 | 2020-04-13 | Trimble | Kentucky | 21223 | 1 | 0 |
54740 | 54740 | 2020-04-13 | Union | Kentucky | 21225 | 5 | 0 |
54741 | 54741 | 2020-04-13 | Unknown | Kentucky | 23 | 0 | |
54742 | 54742 | 2020-04-13 | Warren | Kentucky | 21227 | 47 | 0 |
54743 | 54743 | 2020-04-13 | Washington | Kentucky | 21229 | 3 | 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);