ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where date = "2020-04-24" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
84953 | 84953 | 2020-04-24 | Adair | Kentucky | 21001 | 80 | 6 |
84954 | 84954 | 2020-04-24 | Allen | Kentucky | 21003 | 6 | 0 |
84955 | 84955 | 2020-04-24 | Anderson | Kentucky | 21005 | 7 | 1 |
84956 | 84956 | 2020-04-24 | Ballard | Kentucky | 21007 | 5 | 0 |
84957 | 84957 | 2020-04-24 | Barren | Kentucky | 21009 | 9 | 0 |
84958 | 84958 | 2020-04-24 | Bath | Kentucky | 21011 | 3 | 0 |
84959 | 84959 | 2020-04-24 | Boone | Kentucky | 21015 | 98 | 2 |
84960 | 84960 | 2020-04-24 | Bourbon | Kentucky | 21017 | 8 | 1 |
84961 | 84961 | 2020-04-24 | Boyd | Kentucky | 21019 | 31 | 3 |
84962 | 84962 | 2020-04-24 | Boyle | Kentucky | 21021 | 18 | 0 |
84963 | 84963 | 2020-04-24 | Bracken | Kentucky | 21023 | 7 | 0 |
84964 | 84964 | 2020-04-24 | Breathitt | Kentucky | 21025 | 3 | 0 |
84965 | 84965 | 2020-04-24 | Breckinridge | Kentucky | 21027 | 7 | 0 |
84966 | 84966 | 2020-04-24 | Bullitt | Kentucky | 21029 | 40 | 2 |
84967 | 84967 | 2020-04-24 | Butler | Kentucky | 21031 | 98 | 3 |
84968 | 84968 | 2020-04-24 | Caldwell | Kentucky | 21033 | 13 | 0 |
84969 | 84969 | 2020-04-24 | Calloway | Kentucky | 21035 | 26 | 1 |
84970 | 84970 | 2020-04-24 | Campbell | Kentucky | 21037 | 70 | 7 |
84971 | 84971 | 2020-04-24 | Carlisle | Kentucky | 21039 | 1 | 0 |
84972 | 84972 | 2020-04-24 | Carroll | Kentucky | 21041 | 2 | 0 |
84973 | 84973 | 2020-04-24 | Carter | Kentucky | 21043 | 4 | 0 |
84974 | 84974 | 2020-04-24 | Casey | Kentucky | 21045 | 1 | 0 |
84975 | 84975 | 2020-04-24 | Christian | Kentucky | 21047 | 86 | 3 |
84976 | 84976 | 2020-04-24 | Clark | Kentucky | 21049 | 19 | 0 |
84977 | 84977 | 2020-04-24 | Clay | Kentucky | 21051 | 1 | 0 |
84978 | 84978 | 2020-04-24 | Clinton | Kentucky | 21053 | 2 | 0 |
84979 | 84979 | 2020-04-24 | Crittenden | Kentucky | 21055 | 3 | 1 |
84980 | 84980 | 2020-04-24 | Cumberland | Kentucky | 21057 | 4 | 0 |
84981 | 84981 | 2020-04-24 | Daviess | Kentucky | 21059 | 146 | 6 |
84982 | 84982 | 2020-04-24 | Edmonson | Kentucky | 21061 | 11 | 0 |
84983 | 84983 | 2020-04-24 | Fayette | Kentucky | 21067 | 226 | 8 |
84984 | 84984 | 2020-04-24 | Fleming | Kentucky | 21069 | 2 | 0 |
84985 | 84985 | 2020-04-24 | Floyd | Kentucky | 21071 | 6 | 0 |
84986 | 84986 | 2020-04-24 | Franklin | Kentucky | 21073 | 15 | 0 |
84987 | 84987 | 2020-04-24 | Fulton | Kentucky | 21075 | 1 | 0 |
84988 | 84988 | 2020-04-24 | Gallatin | Kentucky | 21077 | 1 | 0 |
84989 | 84989 | 2020-04-24 | Garrard | Kentucky | 21079 | 1 | 0 |
84990 | 84990 | 2020-04-24 | Grant | Kentucky | 21081 | 18 | 3 |
84991 | 84991 | 2020-04-24 | Graves | Kentucky | 21083 | 89 | 10 |
84992 | 84992 | 2020-04-24 | Grayson | Kentucky | 21085 | 37 | 1 |
84993 | 84993 | 2020-04-24 | Green | Kentucky | 21087 | 1 | 0 |
84994 | 84994 | 2020-04-24 | Greenup | Kentucky | 21089 | 10 | 0 |
84995 | 84995 | 2020-04-24 | Hancock | Kentucky | 21091 | 6 | 0 |
84996 | 84996 | 2020-04-24 | Hardin | Kentucky | 21093 | 32 | 0 |
84997 | 84997 | 2020-04-24 | Harrison | Kentucky | 21097 | 18 | 0 |
84998 | 84998 | 2020-04-24 | Hart | Kentucky | 21099 | 3 | 0 |
84999 | 84999 | 2020-04-24 | Henderson | Kentucky | 21101 | 47 | 1 |
85000 | 85000 | 2020-04-24 | Henry | Kentucky | 21103 | 3 | 0 |
85001 | 85001 | 2020-04-24 | Hickman | Kentucky | 21105 | 2 | 0 |
85002 | 85002 | 2020-04-24 | Hopkins | Kentucky | 21107 | 171 | 20 |
85003 | 85003 | 2020-04-24 | Jackson | Kentucky | 21109 | 58 | 5 |
85004 | 85004 | 2020-04-24 | Jefferson | Kentucky | 21111 | 1121 | 78 |
85005 | 85005 | 2020-04-24 | Jessamine | Kentucky | 21113 | 32 | 0 |
85006 | 85006 | 2020-04-24 | Johnson | Kentucky | 21115 | 1 | 0 |
85007 | 85007 | 2020-04-24 | Kenton | Kentucky | 21117 | 223 | 16 |
85008 | 85008 | 2020-04-24 | Knott | Kentucky | 21119 | 4 | 0 |
85009 | 85009 | 2020-04-24 | Knox | Kentucky | 21121 | 5 | 0 |
85010 | 85010 | 2020-04-24 | Larue | Kentucky | 21123 | 5 | 0 |
85011 | 85011 | 2020-04-24 | Laurel | Kentucky | 21125 | 14 | 2 |
85012 | 85012 | 2020-04-24 | Lawrence | Kentucky | 21127 | 1 | 0 |
85013 | 85013 | 2020-04-24 | Leslie | Kentucky | 21131 | 2 | 0 |
85014 | 85014 | 2020-04-24 | Letcher | Kentucky | 21133 | 1 | 0 |
85015 | 85015 | 2020-04-24 | Lewis | Kentucky | 21135 | 3 | 0 |
85016 | 85016 | 2020-04-24 | Lincoln | Kentucky | 21137 | 4 | 1 |
85017 | 85017 | 2020-04-24 | Livingston | Kentucky | 21139 | 1 | 0 |
85018 | 85018 | 2020-04-24 | Logan | Kentucky | 21141 | 8 | 0 |
85019 | 85019 | 2020-04-24 | Lyon | Kentucky | 21143 | 14 | 3 |
85020 | 85020 | 2020-04-24 | Madison | Kentucky | 21151 | 26 | 1 |
85021 | 85021 | 2020-04-24 | Marion | Kentucky | 21155 | 13 | 0 |
85022 | 85022 | 2020-04-24 | Marshall | Kentucky | 21157 | 23 | 0 |
85023 | 85023 | 2020-04-24 | Martin | Kentucky | 21159 | 3 | 0 |
85024 | 85024 | 2020-04-24 | Mason | Kentucky | 21161 | 6 | 0 |
85025 | 85025 | 2020-04-24 | McCracken | Kentucky | 21145 | 31 | 2 |
85026 | 85026 | 2020-04-24 | McCreary | Kentucky | 21147 | 11 | 0 |
85027 | 85027 | 2020-04-24 | McLean | Kentucky | 21149 | 9 | 0 |
85028 | 85028 | 2020-04-24 | Meade | Kentucky | 21163 | 4 | 1 |
85029 | 85029 | 2020-04-24 | Menifee | Kentucky | 21165 | 3 | 0 |
85030 | 85030 | 2020-04-24 | Mercer | Kentucky | 21167 | 11 | 0 |
85031 | 85031 | 2020-04-24 | Monroe | Kentucky | 21171 | 3 | 0 |
85032 | 85032 | 2020-04-24 | Montgomery | Kentucky | 21173 | 10 | 0 |
85033 | 85033 | 2020-04-24 | Morgan | Kentucky | 21175 | 1 | 0 |
85034 | 85034 | 2020-04-24 | Muhlenberg | Kentucky | 21177 | 92 | 4 |
85035 | 85035 | 2020-04-24 | Nelson | Kentucky | 21179 | 17 | 0 |
85036 | 85036 | 2020-04-24 | Nicholas | Kentucky | 21181 | 1 | 0 |
85037 | 85037 | 2020-04-24 | Ohio | Kentucky | 21183 | 34 | 0 |
85038 | 85038 | 2020-04-24 | Oldham | Kentucky | 21185 | 24 | 0 |
85039 | 85039 | 2020-04-24 | Owsley | Kentucky | 21189 | 3 | 0 |
85040 | 85040 | 2020-04-24 | Pendleton | Kentucky | 21191 | 5 | 0 |
85041 | 85041 | 2020-04-24 | Perry | Kentucky | 21193 | 5 | 0 |
85042 | 85042 | 2020-04-24 | Pike | Kentucky | 21195 | 8 | 2 |
85043 | 85043 | 2020-04-24 | Powell | Kentucky | 21197 | 1 | 0 |
85044 | 85044 | 2020-04-24 | Pulaski | Kentucky | 21199 | 39 | 2 |
85045 | 85045 | 2020-04-24 | Rockcastle | Kentucky | 21203 | 11 | 0 |
85046 | 85046 | 2020-04-24 | Rowan | Kentucky | 21205 | 2 | 0 |
85047 | 85047 | 2020-04-24 | Russell | Kentucky | 21207 | 16 | 2 |
85048 | 85048 | 2020-04-24 | Scott | Kentucky | 21209 | 28 | 0 |
85049 | 85049 | 2020-04-24 | Shelby | Kentucky | 21211 | 26 | 3 |
85050 | 85050 | 2020-04-24 | Simpson | Kentucky | 21213 | 22 | 2 |
85051 | 85051 | 2020-04-24 | Spencer | Kentucky | 21215 | 9 | 0 |
85052 | 85052 | 2020-04-24 | Taylor | Kentucky | 21217 | 5 | 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);