ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where "date" is on date 2020-05-11 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
134168 | 134168 | 2020-05-11 | Adair | Kentucky | 21001 | 88 | 13 |
134169 | 134169 | 2020-05-11 | Allen | Kentucky | 21003 | 29 | 1 |
134170 | 134170 | 2020-05-11 | Anderson | Kentucky | 21005 | 9 | 1 |
134171 | 134171 | 2020-05-11 | Ballard | Kentucky | 21007 | 8 | 0 |
134172 | 134172 | 2020-05-11 | Barren | Kentucky | 21009 | 28 | 0 |
134173 | 134173 | 2020-05-11 | Bath | Kentucky | 21011 | 6 | 1 |
134174 | 134174 | 2020-05-11 | Boone | Kentucky | 21015 | 232 | 5 |
134175 | 134175 | 2020-05-11 | Bourbon | Kentucky | 21017 | 8 | 1 |
134176 | 134176 | 2020-05-11 | Boyd | Kentucky | 21019 | 33 | 3 |
134177 | 134177 | 2020-05-11 | Boyle | Kentucky | 21021 | 17 | 0 |
134178 | 134178 | 2020-05-11 | Bracken | Kentucky | 21023 | 9 | 0 |
134179 | 134179 | 2020-05-11 | Breathitt | Kentucky | 21025 | 2 | 0 |
134180 | 134180 | 2020-05-11 | Breckinridge | Kentucky | 21027 | 13 | 0 |
134181 | 134181 | 2020-05-11 | Bullitt | Kentucky | 21029 | 83 | 4 |
134182 | 134182 | 2020-05-11 | Butler | Kentucky | 21031 | 201 | 6 |
134183 | 134183 | 2020-05-11 | Caldwell | Kentucky | 21033 | 12 | 0 |
134184 | 134184 | 2020-05-11 | Calloway | Kentucky | 21035 | 40 | 1 |
134185 | 134185 | 2020-05-11 | Campbell | Kentucky | 21037 | 118 | 9 |
134186 | 134186 | 2020-05-11 | Carlisle | Kentucky | 21039 | 3 | 1 |
134187 | 134187 | 2020-05-11 | Carroll | Kentucky | 21041 | 2 | 0 |
134188 | 134188 | 2020-05-11 | Carter | Kentucky | 21043 | 6 | 0 |
134189 | 134189 | 2020-05-11 | Casey | Kentucky | 21045 | 1 | 0 |
134190 | 134190 | 2020-05-11 | Christian | Kentucky | 21047 | 95 | 3 |
134191 | 134191 | 2020-05-11 | Clark | Kentucky | 21049 | 20 | 0 |
134192 | 134192 | 2020-05-11 | Clay | Kentucky | 21051 | 2 | 0 |
134193 | 134193 | 2020-05-11 | Clinton | Kentucky | 21053 | 3 | 0 |
134194 | 134194 | 2020-05-11 | Crittenden | Kentucky | 21055 | 4 | 1 |
134195 | 134195 | 2020-05-11 | Cumberland | Kentucky | 21057 | 5 | 0 |
134196 | 134196 | 2020-05-11 | Daviess | Kentucky | 21059 | 270 | 4 |
134197 | 134197 | 2020-05-11 | Edmonson | Kentucky | 21061 | 45 | 6 |
134198 | 134198 | 2020-05-11 | Fayette | Kentucky | 21067 | 411 | 10 |
134199 | 134199 | 2020-05-11 | Fleming | Kentucky | 21069 | 1 | 0 |
134200 | 134200 | 2020-05-11 | Floyd | Kentucky | 21071 | 15 | 0 |
134201 | 134201 | 2020-05-11 | Franklin | Kentucky | 21073 | 17 | 0 |
134202 | 134202 | 2020-05-11 | Fulton | Kentucky | 21075 | 1 | 0 |
134203 | 134203 | 2020-05-11 | Gallatin | Kentucky | 21077 | 1 | 0 |
134204 | 134204 | 2020-05-11 | Garrard | Kentucky | 21079 | 3 | 0 |
134205 | 134205 | 2020-05-11 | Grant | Kentucky | 21081 | 31 | 3 |
134206 | 134206 | 2020-05-11 | Graves | Kentucky | 21083 | 149 | 18 |
134207 | 134207 | 2020-05-11 | Grayson | Kentucky | 21085 | 98 | 6 |
134208 | 134208 | 2020-05-11 | Green | Kentucky | 21087 | 1 | 0 |
134209 | 134209 | 2020-05-11 | Greenup | Kentucky | 21089 | 13 | 0 |
134210 | 134210 | 2020-05-11 | Hancock | Kentucky | 21091 | 6 | 0 |
134211 | 134211 | 2020-05-11 | Hardin | Kentucky | 21093 | 61 | 2 |
134212 | 134212 | 2020-05-11 | Harlan | Kentucky | 21095 | 1 | 0 |
134213 | 134213 | 2020-05-11 | Harrison | Kentucky | 21097 | 19 | 0 |
134214 | 134214 | 2020-05-11 | Hart | Kentucky | 21099 | 8 | 0 |
134215 | 134215 | 2020-05-11 | Henderson | Kentucky | 21101 | 82 | 3 |
134216 | 134216 | 2020-05-11 | Henry | Kentucky | 21103 | 10 | 0 |
134217 | 134217 | 2020-05-11 | Hickman | Kentucky | 21105 | 5 | 0 |
134218 | 134218 | 2020-05-11 | Hopkins | Kentucky | 21107 | 215 | 27 |
134219 | 134219 | 2020-05-11 | Jackson | Kentucky | 21109 | 56 | 12 |
134220 | 134220 | 2020-05-11 | Jefferson | Kentucky | 21111 | 1691 | 119 |
134221 | 134221 | 2020-05-11 | Jessamine | Kentucky | 21113 | 47 | 0 |
134222 | 134222 | 2020-05-11 | Johnson | Kentucky | 21115 | 5 | 0 |
134223 | 134223 | 2020-05-11 | Kenton | Kentucky | 21117 | 401 | 30 |
134224 | 134224 | 2020-05-11 | Knott | Kentucky | 21119 | 4 | 0 |
134225 | 134225 | 2020-05-11 | Knox | Kentucky | 21121 | 7 | 0 |
134226 | 134226 | 2020-05-11 | Larue | Kentucky | 21123 | 6 | 0 |
134227 | 134227 | 2020-05-11 | Laurel | Kentucky | 21125 | 21 | 2 |
134228 | 134228 | 2020-05-11 | Lawrence | Kentucky | 21127 | 1 | 0 |
134229 | 134229 | 2020-05-11 | Leslie | Kentucky | 21131 | 5 | 0 |
134230 | 134230 | 2020-05-11 | Letcher | Kentucky | 21133 | 3 | 0 |
134231 | 134231 | 2020-05-11 | Lewis | Kentucky | 21135 | 6 | 0 |
134232 | 134232 | 2020-05-11 | Lincoln | Kentucky | 21137 | 5 | 1 |
134233 | 134233 | 2020-05-11 | Livingston | Kentucky | 21139 | 6 | 0 |
134234 | 134234 | 2020-05-11 | Logan | Kentucky | 21141 | 63 | 2 |
134235 | 134235 | 2020-05-11 | Lyon | Kentucky | 21143 | 14 | 3 |
134236 | 134236 | 2020-05-11 | Madison | Kentucky | 21151 | 34 | 1 |
134237 | 134237 | 2020-05-11 | Marion | Kentucky | 21155 | 17 | 0 |
134238 | 134238 | 2020-05-11 | Marshall | Kentucky | 21157 | 34 | 1 |
134239 | 134239 | 2020-05-11 | Martin | Kentucky | 21159 | 3 | 0 |
134240 | 134240 | 2020-05-11 | Mason | Kentucky | 21161 | 7 | 0 |
134241 | 134241 | 2020-05-11 | McCracken | Kentucky | 21145 | 72 | 2 |
134242 | 134242 | 2020-05-11 | McCreary | Kentucky | 21147 | 13 | 0 |
134243 | 134243 | 2020-05-11 | McLean | Kentucky | 21149 | 18 | 0 |
134244 | 134244 | 2020-05-11 | Meade | Kentucky | 21163 | 18 | 2 |
134245 | 134245 | 2020-05-11 | Menifee | Kentucky | 21165 | 3 | 0 |
134246 | 134246 | 2020-05-11 | Mercer | Kentucky | 21167 | 11 | 0 |
134247 | 134247 | 2020-05-11 | Metcalfe | Kentucky | 21169 | 2 | 0 |
134248 | 134248 | 2020-05-11 | Monroe | Kentucky | 21171 | 6 | 0 |
134249 | 134249 | 2020-05-11 | Montgomery | Kentucky | 21173 | 11 | 0 |
134250 | 134250 | 2020-05-11 | Morgan | Kentucky | 21175 | 1 | 0 |
134251 | 134251 | 2020-05-11 | Muhlenberg | Kentucky | 21177 | 457 | 6 |
134252 | 134252 | 2020-05-11 | Nelson | Kentucky | 21179 | 31 | 0 |
134253 | 134253 | 2020-05-11 | Nicholas | Kentucky | 21181 | 1 | 0 |
134254 | 134254 | 2020-05-11 | Ohio | Kentucky | 21183 | 105 | 0 |
134255 | 134255 | 2020-05-11 | Oldham | Kentucky | 21185 | 37 | 0 |
134256 | 134256 | 2020-05-11 | Owen | Kentucky | 21187 | 1 | 0 |
134257 | 134257 | 2020-05-11 | Owsley | Kentucky | 21189 | 2 | 0 |
134258 | 134258 | 2020-05-11 | Pendleton | Kentucky | 21191 | 6 | 0 |
134259 | 134259 | 2020-05-11 | Perry | Kentucky | 21193 | 16 | 0 |
134260 | 134260 | 2020-05-11 | Pike | Kentucky | 21195 | 15 | 2 |
134261 | 134261 | 2020-05-11 | Powell | Kentucky | 21197 | 1 | 0 |
134262 | 134262 | 2020-05-11 | Pulaski | Kentucky | 21199 | 44 | 2 |
134263 | 134263 | 2020-05-11 | Rockcastle | Kentucky | 21203 | 13 | 0 |
134264 | 134264 | 2020-05-11 | Rowan | Kentucky | 21205 | 6 | 0 |
134265 | 134265 | 2020-05-11 | Russell | Kentucky | 21207 | 18 | 4 |
134266 | 134266 | 2020-05-11 | Scott | Kentucky | 21209 | 32 | 0 |
134267 | 134267 | 2020-05-11 | Shelby | Kentucky | 21211 | 52 | 3 |
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);