ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where "date" is on date 2020-06-29 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
284908 | 284908 | 2020-06-29 | Adair | Kentucky | 21001 | 118 | 19 |
284909 | 284909 | 2020-06-29 | Allen | Kentucky | 21003 | 165 | 7 |
284910 | 284910 | 2020-06-29 | Anderson | Kentucky | 21005 | 26 | 1 |
284911 | 284911 | 2020-06-29 | Ballard | Kentucky | 21007 | 15 | 0 |
284912 | 284912 | 2020-06-29 | Barren | Kentucky | 21009 | 85 | 2 |
284913 | 284913 | 2020-06-29 | Bath | Kentucky | 21011 | 13 | 1 |
284914 | 284914 | 2020-06-29 | Bell | Kentucky | 21013 | 8 | 0 |
284915 | 284915 | 2020-06-29 | Boone | Kentucky | 21015 | 594 | 23 |
284916 | 284916 | 2020-06-29 | Bourbon | Kentucky | 21017 | 30 | 1 |
284917 | 284917 | 2020-06-29 | Boyd | Kentucky | 21019 | 61 | 3 |
284918 | 284918 | 2020-06-29 | Boyle | Kentucky | 21021 | 38 | 0 |
284919 | 284919 | 2020-06-29 | Bracken | Kentucky | 21023 | 17 | 0 |
284920 | 284920 | 2020-06-29 | Breathitt | Kentucky | 21025 | 8 | 0 |
284921 | 284921 | 2020-06-29 | Breckinridge | Kentucky | 21027 | 24 | 2 |
284922 | 284922 | 2020-06-29 | Bullitt | Kentucky | 21029 | 149 | 4 |
284923 | 284923 | 2020-06-29 | Butler | Kentucky | 21031 | 255 | 14 |
284924 | 284924 | 2020-06-29 | Caldwell | Kentucky | 21033 | 13 | 0 |
284925 | 284925 | 2020-06-29 | Calloway | Kentucky | 21035 | 79 | 1 |
284926 | 284926 | 2020-06-29 | Campbell | Kentucky | 21037 | 249 | 13 |
284927 | 284927 | 2020-06-29 | Carlisle | Kentucky | 21039 | 5 | 1 |
284928 | 284928 | 2020-06-29 | Carroll | Kentucky | 21041 | 37 | 0 |
284929 | 284929 | 2020-06-29 | Carter | Kentucky | 21043 | 22 | 0 |
284930 | 284930 | 2020-06-29 | Casey | Kentucky | 21045 | 18 | 0 |
284931 | 284931 | 2020-06-29 | Christian | Kentucky | 21047 | 237 | 4 |
284932 | 284932 | 2020-06-29 | Clark | Kentucky | 21049 | 98 | 5 |
284933 | 284933 | 2020-06-29 | Clay | Kentucky | 21051 | 53 | 3 |
284934 | 284934 | 2020-06-29 | Clinton | Kentucky | 21053 | 5 | 0 |
284935 | 284935 | 2020-06-29 | Crittenden | Kentucky | 21055 | 8 | 1 |
284936 | 284936 | 2020-06-29 | Cumberland | Kentucky | 21057 | 6 | 0 |
284937 | 284937 | 2020-06-29 | Daviess | Kentucky | 21059 | 431 | 8 |
284938 | 284938 | 2020-06-29 | Edmonson | Kentucky | 21061 | 81 | 11 |
284939 | 284939 | 2020-06-29 | Elliott | Kentucky | 21063 | 3 | 0 |
284940 | 284940 | 2020-06-29 | Estill | Kentucky | 21065 | 4 | 0 |
284941 | 284941 | 2020-06-29 | Fayette | Kentucky | 21067 | 1491 | 27 |
284942 | 284942 | 2020-06-29 | Fleming | Kentucky | 21069 | 18 | 0 |
284943 | 284943 | 2020-06-29 | Floyd | Kentucky | 21071 | 27 | 0 |
284944 | 284944 | 2020-06-29 | Franklin | Kentucky | 21073 | 128 | 4 |
284945 | 284945 | 2020-06-29 | Fulton | Kentucky | 21075 | 23 | 0 |
284946 | 284946 | 2020-06-29 | Gallatin | Kentucky | 21077 | 61 | 7 |
284947 | 284947 | 2020-06-29 | Garrard | Kentucky | 21079 | 21 | 0 |
284948 | 284948 | 2020-06-29 | Grant | Kentucky | 21081 | 57 | 4 |
284949 | 284949 | 2020-06-29 | Graves | Kentucky | 21083 | 200 | 21 |
284950 | 284950 | 2020-06-29 | Grayson | Kentucky | 21085 | 137 | 10 |
284951 | 284951 | 2020-06-29 | Green | Kentucky | 21087 | 4 | 1 |
284952 | 284952 | 2020-06-29 | Greenup | Kentucky | 21089 | 28 | 0 |
284953 | 284953 | 2020-06-29 | Hancock | Kentucky | 21091 | 18 | 0 |
284954 | 284954 | 2020-06-29 | Hardin | Kentucky | 21093 | 146 | 5 |
284955 | 284955 | 2020-06-29 | Harlan | Kentucky | 21095 | 23 | 2 |
284956 | 284956 | 2020-06-29 | Harrison | Kentucky | 21097 | 68 | 0 |
284957 | 284957 | 2020-06-29 | Hart | Kentucky | 21099 | 47 | 0 |
284958 | 284958 | 2020-06-29 | Henderson | Kentucky | 21101 | 163 | 4 |
284959 | 284959 | 2020-06-29 | Henry | Kentucky | 21103 | 33 | 2 |
284960 | 284960 | 2020-06-29 | Hickman | Kentucky | 21105 | 5 | 0 |
284961 | 284961 | 2020-06-29 | Hopkins | Kentucky | 21107 | 251 | 34 |
284962 | 284962 | 2020-06-29 | Jackson | Kentucky | 21109 | 104 | 13 |
284963 | 284963 | 2020-06-29 | Jefferson | Kentucky | 21111 | 3852 | 203 |
284964 | 284964 | 2020-06-29 | Jessamine | Kentucky | 21113 | 106 | 0 |
284965 | 284965 | 2020-06-29 | Johnson | Kentucky | 21115 | 10 | 0 |
284966 | 284966 | 2020-06-29 | Kenton | Kentucky | 21117 | 787 | 37 |
284967 | 284967 | 2020-06-29 | Knott | Kentucky | 21119 | 7 | 0 |
284968 | 284968 | 2020-06-29 | Knox | Kentucky | 21121 | 64 | 0 |
284969 | 284969 | 2020-06-29 | Larue | Kentucky | 21123 | 16 | 1 |
284970 | 284970 | 2020-06-29 | Laurel | Kentucky | 21125 | 90 | 3 |
284971 | 284971 | 2020-06-29 | Lawrence | Kentucky | 21127 | 7 | 0 |
284972 | 284972 | 2020-06-29 | Lee | Kentucky | 21129 | 1 | 0 |
284973 | 284973 | 2020-06-29 | Leslie | Kentucky | 21131 | 8 | 0 |
284974 | 284974 | 2020-06-29 | Letcher | Kentucky | 21133 | 15 | 0 |
284975 | 284975 | 2020-06-29 | Lewis | Kentucky | 21135 | 22 | 0 |
284976 | 284976 | 2020-06-29 | Lincoln | Kentucky | 21137 | 25 | 1 |
284977 | 284977 | 2020-06-29 | Livingston | Kentucky | 21139 | 10 | 0 |
284978 | 284978 | 2020-06-29 | Logan | Kentucky | 21141 | 221 | 14 |
284979 | 284979 | 2020-06-29 | Lyon | Kentucky | 21143 | 20 | 3 |
284980 | 284980 | 2020-06-29 | Madison | Kentucky | 21151 | 125 | 1 |
284981 | 284981 | 2020-06-29 | Magoffin | Kentucky | 21153 | 5 | 0 |
284982 | 284982 | 2020-06-29 | Marion | Kentucky | 21155 | 51 | 0 |
284983 | 284983 | 2020-06-29 | Marshall | Kentucky | 21157 | 56 | 2 |
284984 | 284984 | 2020-06-29 | Martin | Kentucky | 21159 | 5 | 0 |
284985 | 284985 | 2020-06-29 | Mason | Kentucky | 21161 | 30 | 0 |
284986 | 284986 | 2020-06-29 | McCracken | Kentucky | 21145 | 161 | 3 |
284987 | 284987 | 2020-06-29 | McCreary | Kentucky | 21147 | 18 | 0 |
284988 | 284988 | 2020-06-29 | McLean | Kentucky | 21149 | 25 | 0 |
284989 | 284989 | 2020-06-29 | Meade | Kentucky | 21163 | 25 | 2 |
284990 | 284990 | 2020-06-29 | Menifee | Kentucky | 21165 | 13 | 0 |
284991 | 284991 | 2020-06-29 | Mercer | Kentucky | 21167 | 23 | 0 |
284992 | 284992 | 2020-06-29 | Metcalfe | Kentucky | 21169 | 9 | 2 |
284993 | 284993 | 2020-06-29 | Monroe | Kentucky | 21171 | 35 | 1 |
284994 | 284994 | 2020-06-29 | Montgomery | Kentucky | 21173 | 58 | 0 |
284995 | 284995 | 2020-06-29 | Morgan | Kentucky | 21175 | 8 | 0 |
284996 | 284996 | 2020-06-29 | Muhlenberg | Kentucky | 21177 | 520 | 8 |
284997 | 284997 | 2020-06-29 | Nelson | Kentucky | 21179 | 70 | 1 |
284998 | 284998 | 2020-06-29 | Nicholas | Kentucky | 21181 | 5 | 0 |
284999 | 284999 | 2020-06-29 | Ohio | Kentucky | 21183 | 204 | 0 |
285000 | 285000 | 2020-06-29 | Oldham | Kentucky | 21185 | 129 | 6 |
285001 | 285001 | 2020-06-29 | Owen | Kentucky | 21187 | 6 | 0 |
285002 | 285002 | 2020-06-29 | Owsley | Kentucky | 21189 | 2 | 0 |
285003 | 285003 | 2020-06-29 | Pendleton | Kentucky | 21191 | 16 | 0 |
285004 | 285004 | 2020-06-29 | Perry | Kentucky | 21193 | 59 | 1 |
285005 | 285005 | 2020-06-29 | Pike | Kentucky | 21195 | 76 | 2 |
285006 | 285006 | 2020-06-29 | Powell | Kentucky | 21197 | 6 | 0 |
285007 | 285007 | 2020-06-29 | Pulaski | Kentucky | 21199 | 94 | 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);