ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92,572 rows where state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Fayette 115
- Harrison 113
- Jefferson 113
- Montgomery 109
- Bourbon 107
- Nelson 107
- Clark 106
- Lyon 104
- Franklin 103
- Kenton 103
- Warren 103
- Christian 102
- Daviess 102
- Henderson 102
- Pulaski 102
- Scott 102
- Calloway 101
- Anderson 100
- Madison 100
- Spencer 100
- Allen 99
- Breathitt 99
- Hardin 99
- Jessamine 99
- Oldham 99
- Logan 98
- Martin 97
- McCracken 97
- Menifee 97
- Muhlenberg 97
- …
state 1
- Kentucky · 10,494 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281762 | 281762 | 2020-06-28 | Adair | Kentucky | 21001 | 116 | 19 |
281763 | 281763 | 2020-06-28 | Allen | Kentucky | 21003 | 165 | 6 |
281764 | 281764 | 2020-06-28 | Anderson | Kentucky | 21005 | 26 | 1 |
281765 | 281765 | 2020-06-28 | Ballard | Kentucky | 21007 | 15 | 0 |
281766 | 281766 | 2020-06-28 | Barren | Kentucky | 21009 | 84 | 2 |
281767 | 281767 | 2020-06-28 | Bath | Kentucky | 21011 | 13 | 1 |
281768 | 281768 | 2020-06-28 | Bell | Kentucky | 21013 | 8 | 0 |
281769 | 281769 | 2020-06-28 | Boone | Kentucky | 21015 | 594 | 23 |
281770 | 281770 | 2020-06-28 | Bourbon | Kentucky | 21017 | 30 | 1 |
281771 | 281771 | 2020-06-28 | Boyd | Kentucky | 21019 | 61 | 3 |
281772 | 281772 | 2020-06-28 | Boyle | Kentucky | 21021 | 38 | 0 |
281773 | 281773 | 2020-06-28 | Bracken | Kentucky | 21023 | 17 | 0 |
281774 | 281774 | 2020-06-28 | Breathitt | Kentucky | 21025 | 8 | 0 |
281775 | 281775 | 2020-06-28 | Breckinridge | Kentucky | 21027 | 24 | 2 |
281776 | 281776 | 2020-06-28 | Bullitt | Kentucky | 21029 | 149 | 4 |
281777 | 281777 | 2020-06-28 | Butler | Kentucky | 21031 | 253 | 14 |
281778 | 281778 | 2020-06-28 | Caldwell | Kentucky | 21033 | 13 | 0 |
281779 | 281779 | 2020-06-28 | Calloway | Kentucky | 21035 | 79 | 1 |
281780 | 281780 | 2020-06-28 | Campbell | Kentucky | 21037 | 248 | 12 |
281781 | 281781 | 2020-06-28 | Carlisle | Kentucky | 21039 | 5 | 1 |
281782 | 281782 | 2020-06-28 | Carroll | Kentucky | 21041 | 37 | 0 |
281783 | 281783 | 2020-06-28 | Carter | Kentucky | 21043 | 22 | 0 |
281784 | 281784 | 2020-06-28 | Casey | Kentucky | 21045 | 15 | 0 |
281785 | 281785 | 2020-06-28 | Christian | Kentucky | 21047 | 226 | 4 |
281786 | 281786 | 2020-06-28 | Clark | Kentucky | 21049 | 98 | 5 |
281787 | 281787 | 2020-06-28 | Clay | Kentucky | 21051 | 53 | 3 |
281788 | 281788 | 2020-06-28 | Clinton | Kentucky | 21053 | 5 | 0 |
281789 | 281789 | 2020-06-28 | Crittenden | Kentucky | 21055 | 8 | 1 |
281790 | 281790 | 2020-06-28 | Cumberland | Kentucky | 21057 | 6 | 0 |
281791 | 281791 | 2020-06-28 | Daviess | Kentucky | 21059 | 428 | 8 |
281792 | 281792 | 2020-06-28 | Edmonson | Kentucky | 21061 | 79 | 11 |
281793 | 281793 | 2020-06-28 | Elliott | Kentucky | 21063 | 3 | 0 |
281794 | 281794 | 2020-06-28 | Estill | Kentucky | 21065 | 4 | 0 |
281795 | 281795 | 2020-06-28 | Fayette | Kentucky | 21067 | 1439 | 24 |
281796 | 281796 | 2020-06-28 | Fleming | Kentucky | 21069 | 18 | 0 |
281797 | 281797 | 2020-06-28 | Floyd | Kentucky | 21071 | 27 | 0 |
281798 | 281798 | 2020-06-28 | Franklin | Kentucky | 21073 | 128 | 4 |
281799 | 281799 | 2020-06-28 | Fulton | Kentucky | 21075 | 21 | 0 |
281800 | 281800 | 2020-06-28 | Gallatin | Kentucky | 21077 | 61 | 7 |
281801 | 281801 | 2020-06-28 | Garrard | Kentucky | 21079 | 20 | 0 |
281802 | 281802 | 2020-06-28 | Grant | Kentucky | 21081 | 57 | 4 |
281803 | 281803 | 2020-06-28 | Graves | Kentucky | 21083 | 199 | 21 |
281804 | 281804 | 2020-06-28 | Grayson | Kentucky | 21085 | 137 | 10 |
281805 | 281805 | 2020-06-28 | Green | Kentucky | 21087 | 4 | 1 |
281806 | 281806 | 2020-06-28 | Greenup | Kentucky | 21089 | 28 | 0 |
281807 | 281807 | 2020-06-28 | Hancock | Kentucky | 21091 | 18 | 0 |
281808 | 281808 | 2020-06-28 | Hardin | Kentucky | 21093 | 145 | 5 |
281809 | 281809 | 2020-06-28 | Harlan | Kentucky | 21095 | 22 | 2 |
281810 | 281810 | 2020-06-28 | Harrison | Kentucky | 21097 | 68 | 0 |
281811 | 281811 | 2020-06-28 | Hart | Kentucky | 21099 | 46 | 0 |
281812 | 281812 | 2020-06-28 | Henderson | Kentucky | 21101 | 161 | 4 |
281813 | 281813 | 2020-06-28 | Henry | Kentucky | 21103 | 33 | 2 |
281814 | 281814 | 2020-06-28 | Hickman | Kentucky | 21105 | 5 | 0 |
281815 | 281815 | 2020-06-28 | Hopkins | Kentucky | 21107 | 251 | 34 |
281816 | 281816 | 2020-06-28 | Jackson | Kentucky | 21109 | 104 | 13 |
281817 | 281817 | 2020-06-28 | Jefferson | Kentucky | 21111 | 3829 | 201 |
281818 | 281818 | 2020-06-28 | Jessamine | Kentucky | 21113 | 105 | 0 |
281819 | 281819 | 2020-06-28 | Johnson | Kentucky | 21115 | 10 | 0 |
281820 | 281820 | 2020-06-28 | Kenton | Kentucky | 21117 | 787 | 37 |
281821 | 281821 | 2020-06-28 | Knott | Kentucky | 21119 | 7 | 0 |
281822 | 281822 | 2020-06-28 | Knox | Kentucky | 21121 | 63 | 0 |
281823 | 281823 | 2020-06-28 | Larue | Kentucky | 21123 | 15 | 1 |
281824 | 281824 | 2020-06-28 | Laurel | Kentucky | 21125 | 85 | 3 |
281825 | 281825 | 2020-06-28 | Lawrence | Kentucky | 21127 | 7 | 0 |
281826 | 281826 | 2020-06-28 | Lee | Kentucky | 21129 | 1 | 0 |
281827 | 281827 | 2020-06-28 | Leslie | Kentucky | 21131 | 8 | 0 |
281828 | 281828 | 2020-06-28 | Letcher | Kentucky | 21133 | 15 | 0 |
281829 | 281829 | 2020-06-28 | Lewis | Kentucky | 21135 | 21 | 0 |
281830 | 281830 | 2020-06-28 | Lincoln | Kentucky | 21137 | 25 | 1 |
281831 | 281831 | 2020-06-28 | Livingston | Kentucky | 21139 | 10 | 0 |
281832 | 281832 | 2020-06-28 | Logan | Kentucky | 21141 | 215 | 14 |
281833 | 281833 | 2020-06-28 | Lyon | Kentucky | 21143 | 20 | 3 |
281834 | 281834 | 2020-06-28 | Madison | Kentucky | 21151 | 125 | 1 |
281835 | 281835 | 2020-06-28 | Magoffin | Kentucky | 21153 | 5 | 0 |
281836 | 281836 | 2020-06-28 | Marion | Kentucky | 21155 | 49 | 0 |
281837 | 281837 | 2020-06-28 | Marshall | Kentucky | 21157 | 55 | 2 |
281838 | 281838 | 2020-06-28 | Martin | Kentucky | 21159 | 5 | 0 |
281839 | 281839 | 2020-06-28 | Mason | Kentucky | 21161 | 29 | 0 |
281840 | 281840 | 2020-06-28 | McCracken | Kentucky | 21145 | 159 | 3 |
281841 | 281841 | 2020-06-28 | McCreary | Kentucky | 21147 | 17 | 0 |
281842 | 281842 | 2020-06-28 | McLean | Kentucky | 21149 | 25 | 0 |
281843 | 281843 | 2020-06-28 | Meade | Kentucky | 21163 | 25 | 2 |
281844 | 281844 | 2020-06-28 | Menifee | Kentucky | 21165 | 13 | 0 |
281845 | 281845 | 2020-06-28 | Mercer | Kentucky | 21167 | 23 | 0 |
281846 | 281846 | 2020-06-28 | Metcalfe | Kentucky | 21169 | 9 | 2 |
281847 | 281847 | 2020-06-28 | Monroe | Kentucky | 21171 | 35 | 1 |
281848 | 281848 | 2020-06-28 | Montgomery | Kentucky | 21173 | 58 | 0 |
281849 | 281849 | 2020-06-28 | Morgan | Kentucky | 21175 | 8 | 0 |
281850 | 281850 | 2020-06-28 | Muhlenberg | Kentucky | 21177 | 514 | 8 |
281851 | 281851 | 2020-06-28 | Nelson | Kentucky | 21179 | 69 | 1 |
281852 | 281852 | 2020-06-28 | Nicholas | Kentucky | 21181 | 5 | 0 |
281853 | 281853 | 2020-06-28 | Ohio | Kentucky | 21183 | 197 | 0 |
281854 | 281854 | 2020-06-28 | Oldham | Kentucky | 21185 | 129 | 6 |
281855 | 281855 | 2020-06-28 | Owen | Kentucky | 21187 | 6 | 0 |
281856 | 281856 | 2020-06-28 | Owsley | Kentucky | 21189 | 2 | 0 |
281857 | 281857 | 2020-06-28 | Pendleton | Kentucky | 21191 | 16 | 0 |
281858 | 281858 | 2020-06-28 | Perry | Kentucky | 21193 | 59 | 1 |
281859 | 281859 | 2020-06-28 | Pike | Kentucky | 21195 | 76 | 2 |
281860 | 281860 | 2020-06-28 | Powell | Kentucky | 21197 | 6 | 0 |
281861 | 281861 | 2020-06-28 | Pulaski | Kentucky | 21199 | 93 | 2 |
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);