ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where date = "2020-05-06" 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 |
---|---|---|---|---|---|---|---|
119247 | 119247 | 2020-05-06 | Adair | Kentucky | 21001 | 82 | 13 |
119248 | 119248 | 2020-05-06 | Allen | Kentucky | 21003 | 19 | 0 |
119249 | 119249 | 2020-05-06 | Anderson | Kentucky | 21005 | 9 | 1 |
119250 | 119250 | 2020-05-06 | Ballard | Kentucky | 21007 | 8 | 0 |
119251 | 119251 | 2020-05-06 | Barren | Kentucky | 21009 | 22 | 0 |
119252 | 119252 | 2020-05-06 | Bath | Kentucky | 21011 | 4 | 1 |
119253 | 119253 | 2020-05-06 | Boone | Kentucky | 21015 | 196 | 4 |
119254 | 119254 | 2020-05-06 | Bourbon | Kentucky | 21017 | 9 | 1 |
119255 | 119255 | 2020-05-06 | Boyd | Kentucky | 21019 | 31 | 3 |
119256 | 119256 | 2020-05-06 | Boyle | Kentucky | 21021 | 19 | 0 |
119257 | 119257 | 2020-05-06 | Bracken | Kentucky | 21023 | 9 | 0 |
119258 | 119258 | 2020-05-06 | Breathitt | Kentucky | 21025 | 3 | 0 |
119259 | 119259 | 2020-05-06 | Breckinridge | Kentucky | 21027 | 11 | 0 |
119260 | 119260 | 2020-05-06 | Bullitt | Kentucky | 21029 | 72 | 2 |
119261 | 119261 | 2020-05-06 | Butler | Kentucky | 21031 | 183 | 5 |
119262 | 119262 | 2020-05-06 | Caldwell | Kentucky | 21033 | 12 | 0 |
119263 | 119263 | 2020-05-06 | Calloway | Kentucky | 21035 | 35 | 1 |
119264 | 119264 | 2020-05-06 | Campbell | Kentucky | 21037 | 107 | 9 |
119265 | 119265 | 2020-05-06 | Carlisle | Kentucky | 21039 | 2 | 1 |
119266 | 119266 | 2020-05-06 | Carroll | Kentucky | 21041 | 2 | 0 |
119267 | 119267 | 2020-05-06 | Carter | Kentucky | 21043 | 6 | 0 |
119268 | 119268 | 2020-05-06 | Casey | Kentucky | 21045 | 1 | 0 |
119269 | 119269 | 2020-05-06 | Christian | Kentucky | 21047 | 92 | 3 |
119270 | 119270 | 2020-05-06 | Clark | Kentucky | 21049 | 20 | 0 |
119271 | 119271 | 2020-05-06 | Clay | Kentucky | 21051 | 1 | 0 |
119272 | 119272 | 2020-05-06 | Clinton | Kentucky | 21053 | 3 | 0 |
119273 | 119273 | 2020-05-06 | Crittenden | Kentucky | 21055 | 4 | 1 |
119274 | 119274 | 2020-05-06 | Cumberland | Kentucky | 21057 | 5 | 0 |
119275 | 119275 | 2020-05-06 | Daviess | Kentucky | 21059 | 248 | 4 |
119276 | 119276 | 2020-05-06 | Edmonson | Kentucky | 21061 | 38 | 0 |
119277 | 119277 | 2020-05-06 | Fayette | Kentucky | 21067 | 320 | 9 |
119278 | 119278 | 2020-05-06 | Fleming | Kentucky | 21069 | 2 | 0 |
119279 | 119279 | 2020-05-06 | Floyd | Kentucky | 21071 | 12 | 0 |
119280 | 119280 | 2020-05-06 | Franklin | Kentucky | 21073 | 17 | 0 |
119281 | 119281 | 2020-05-06 | Fulton | Kentucky | 21075 | 1 | 0 |
119282 | 119282 | 2020-05-06 | Gallatin | Kentucky | 21077 | 1 | 0 |
119283 | 119283 | 2020-05-06 | Garrard | Kentucky | 21079 | 2 | 0 |
119284 | 119284 | 2020-05-06 | Grant | Kentucky | 21081 | 27 | 3 |
119285 | 119285 | 2020-05-06 | Graves | Kentucky | 21083 | 142 | 14 |
119286 | 119286 | 2020-05-06 | Grayson | Kentucky | 21085 | 90 | 5 |
119287 | 119287 | 2020-05-06 | Green | Kentucky | 21087 | 1 | 0 |
119288 | 119288 | 2020-05-06 | Greenup | Kentucky | 21089 | 12 | 0 |
119289 | 119289 | 2020-05-06 | Hancock | Kentucky | 21091 | 6 | 0 |
119290 | 119290 | 2020-05-06 | Hardin | Kentucky | 21093 | 55 | 1 |
119291 | 119291 | 2020-05-06 | Harrison | Kentucky | 21097 | 18 | 0 |
119292 | 119292 | 2020-05-06 | Hart | Kentucky | 21099 | 8 | 0 |
119293 | 119293 | 2020-05-06 | Henderson | Kentucky | 21101 | 76 | 2 |
119294 | 119294 | 2020-05-06 | Henry | Kentucky | 21103 | 8 | 0 |
119295 | 119295 | 2020-05-06 | Hickman | Kentucky | 21105 | 5 | 0 |
119296 | 119296 | 2020-05-06 | Hopkins | Kentucky | 21107 | 211 | 24 |
119297 | 119297 | 2020-05-06 | Jackson | Kentucky | 21109 | 60 | 12 |
119298 | 119298 | 2020-05-06 | Jefferson | Kentucky | 21111 | 1535 | 108 |
119299 | 119299 | 2020-05-06 | Jessamine | Kentucky | 21113 | 40 | 0 |
119300 | 119300 | 2020-05-06 | Johnson | Kentucky | 21115 | 3 | 0 |
119301 | 119301 | 2020-05-06 | Kenton | Kentucky | 21117 | 353 | 26 |
119302 | 119302 | 2020-05-06 | Knott | Kentucky | 21119 | 4 | 0 |
119303 | 119303 | 2020-05-06 | Knox | Kentucky | 21121 | 6 | 0 |
119304 | 119304 | 2020-05-06 | Larue | Kentucky | 21123 | 6 | 0 |
119305 | 119305 | 2020-05-06 | Laurel | Kentucky | 21125 | 20 | 2 |
119306 | 119306 | 2020-05-06 | Lawrence | Kentucky | 21127 | 1 | 0 |
119307 | 119307 | 2020-05-06 | Leslie | Kentucky | 21131 | 4 | 0 |
119308 | 119308 | 2020-05-06 | Letcher | Kentucky | 21133 | 3 | 0 |
119309 | 119309 | 2020-05-06 | Lewis | Kentucky | 21135 | 3 | 0 |
119310 | 119310 | 2020-05-06 | Lincoln | Kentucky | 21137 | 6 | 1 |
119311 | 119311 | 2020-05-06 | Livingston | Kentucky | 21139 | 6 | 0 |
119312 | 119312 | 2020-05-06 | Logan | Kentucky | 21141 | 15 | 1 |
119313 | 119313 | 2020-05-06 | Lyon | Kentucky | 21143 | 13 | 3 |
119314 | 119314 | 2020-05-06 | Madison | Kentucky | 21151 | 31 | 1 |
119315 | 119315 | 2020-05-06 | Marion | Kentucky | 21155 | 17 | 0 |
119316 | 119316 | 2020-05-06 | Marshall | Kentucky | 21157 | 34 | 1 |
119317 | 119317 | 2020-05-06 | Martin | Kentucky | 21159 | 3 | 0 |
119318 | 119318 | 2020-05-06 | Mason | Kentucky | 21161 | 6 | 0 |
119319 | 119319 | 2020-05-06 | McCracken | Kentucky | 21145 | 65 | 2 |
119320 | 119320 | 2020-05-06 | McCreary | Kentucky | 21147 | 11 | 0 |
119321 | 119321 | 2020-05-06 | McLean | Kentucky | 21149 | 16 | 0 |
119322 | 119322 | 2020-05-06 | Meade | Kentucky | 21163 | 17 | 1 |
119323 | 119323 | 2020-05-06 | Menifee | Kentucky | 21165 | 3 | 0 |
119324 | 119324 | 2020-05-06 | Mercer | Kentucky | 21167 | 11 | 0 |
119325 | 119325 | 2020-05-06 | Metcalfe | Kentucky | 21169 | 1 | 0 |
119326 | 119326 | 2020-05-06 | Monroe | Kentucky | 21171 | 6 | 0 |
119327 | 119327 | 2020-05-06 | Montgomery | Kentucky | 21173 | 12 | 0 |
119328 | 119328 | 2020-05-06 | Morgan | Kentucky | 21175 | 1 | 0 |
119329 | 119329 | 2020-05-06 | Muhlenberg | Kentucky | 21177 | 446 | 6 |
119330 | 119330 | 2020-05-06 | Nelson | Kentucky | 21179 | 24 | 0 |
119331 | 119331 | 2020-05-06 | Nicholas | Kentucky | 21181 | 1 | 0 |
119332 | 119332 | 2020-05-06 | Ohio | Kentucky | 21183 | 75 | 0 |
119333 | 119333 | 2020-05-06 | Oldham | Kentucky | 21185 | 35 | 0 |
119334 | 119334 | 2020-05-06 | Owen | Kentucky | 21187 | 1 | 0 |
119335 | 119335 | 2020-05-06 | Owsley | Kentucky | 21189 | 2 | 0 |
119336 | 119336 | 2020-05-06 | Pendleton | Kentucky | 21191 | 6 | 0 |
119337 | 119337 | 2020-05-06 | Perry | Kentucky | 21193 | 14 | 0 |
119338 | 119338 | 2020-05-06 | Pike | Kentucky | 21195 | 14 | 2 |
119339 | 119339 | 2020-05-06 | Powell | Kentucky | 21197 | 1 | 0 |
119340 | 119340 | 2020-05-06 | Pulaski | Kentucky | 21199 | 43 | 2 |
119341 | 119341 | 2020-05-06 | Rockcastle | Kentucky | 21203 | 13 | 0 |
119342 | 119342 | 2020-05-06 | Rowan | Kentucky | 21205 | 2 | 0 |
119343 | 119343 | 2020-05-06 | Russell | Kentucky | 21207 | 17 | 4 |
119344 | 119344 | 2020-05-06 | Scott | Kentucky | 21209 | 31 | 0 |
119345 | 119345 | 2020-05-06 | Shelby | Kentucky | 21211 | 34 | 3 |
119346 | 119346 | 2020-05-06 | Simpson | Kentucky | 21213 | 31 | 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);