ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
114 rows where date = "2020-05-07" 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 |
---|---|---|---|---|---|---|---|
122217 | 122217 | 2020-05-07 | Adair | Kentucky | 21001 | 84 | 13 |
122218 | 122218 | 2020-05-07 | Allen | Kentucky | 21003 | 25 | 0 |
122219 | 122219 | 2020-05-07 | Anderson | Kentucky | 21005 | 9 | 1 |
122220 | 122220 | 2020-05-07 | Ballard | Kentucky | 21007 | 8 | 0 |
122221 | 122221 | 2020-05-07 | Barren | Kentucky | 21009 | 24 | 0 |
122222 | 122222 | 2020-05-07 | Bath | Kentucky | 21011 | 4 | 1 |
122223 | 122223 | 2020-05-07 | Boone | Kentucky | 21015 | 197 | 4 |
122224 | 122224 | 2020-05-07 | Bourbon | Kentucky | 21017 | 9 | 1 |
122225 | 122225 | 2020-05-07 | Boyd | Kentucky | 21019 | 32 | 3 |
122226 | 122226 | 2020-05-07 | Boyle | Kentucky | 21021 | 19 | 0 |
122227 | 122227 | 2020-05-07 | Bracken | Kentucky | 21023 | 10 | 0 |
122228 | 122228 | 2020-05-07 | Breathitt | Kentucky | 21025 | 3 | 0 |
122229 | 122229 | 2020-05-07 | Breckinridge | Kentucky | 21027 | 11 | 0 |
122230 | 122230 | 2020-05-07 | Bullitt | Kentucky | 21029 | 74 | 2 |
122231 | 122231 | 2020-05-07 | Butler | Kentucky | 21031 | 188 | 6 |
122232 | 122232 | 2020-05-07 | Caldwell | Kentucky | 21033 | 12 | 0 |
122233 | 122233 | 2020-05-07 | Calloway | Kentucky | 21035 | 35 | 1 |
122234 | 122234 | 2020-05-07 | Campbell | Kentucky | 21037 | 110 | 9 |
122235 | 122235 | 2020-05-07 | Carlisle | Kentucky | 21039 | 2 | 1 |
122236 | 122236 | 2020-05-07 | Carroll | Kentucky | 21041 | 2 | 0 |
122237 | 122237 | 2020-05-07 | Carter | Kentucky | 21043 | 6 | 0 |
122238 | 122238 | 2020-05-07 | Casey | Kentucky | 21045 | 1 | 0 |
122239 | 122239 | 2020-05-07 | Christian | Kentucky | 21047 | 92 | 3 |
122240 | 122240 | 2020-05-07 | Clark | Kentucky | 21049 | 20 | 0 |
122241 | 122241 | 2020-05-07 | Clay | Kentucky | 21051 | 1 | 0 |
122242 | 122242 | 2020-05-07 | Clinton | Kentucky | 21053 | 3 | 0 |
122243 | 122243 | 2020-05-07 | Crittenden | Kentucky | 21055 | 4 | 1 |
122244 | 122244 | 2020-05-07 | Cumberland | Kentucky | 21057 | 5 | 0 |
122245 | 122245 | 2020-05-07 | Daviess | Kentucky | 21059 | 258 | 4 |
122246 | 122246 | 2020-05-07 | Edmonson | Kentucky | 21061 | 42 | 6 |
122247 | 122247 | 2020-05-07 | Fayette | Kentucky | 21067 | 336 | 9 |
122248 | 122248 | 2020-05-07 | Fleming | Kentucky | 21069 | 2 | 0 |
122249 | 122249 | 2020-05-07 | Floyd | Kentucky | 21071 | 13 | 0 |
122250 | 122250 | 2020-05-07 | Franklin | Kentucky | 21073 | 17 | 0 |
122251 | 122251 | 2020-05-07 | Fulton | Kentucky | 21075 | 1 | 0 |
122252 | 122252 | 2020-05-07 | Gallatin | Kentucky | 21077 | 1 | 0 |
122253 | 122253 | 2020-05-07 | Garrard | Kentucky | 21079 | 2 | 0 |
122254 | 122254 | 2020-05-07 | Grant | Kentucky | 21081 | 27 | 3 |
122255 | 122255 | 2020-05-07 | Graves | Kentucky | 21083 | 145 | 14 |
122256 | 122256 | 2020-05-07 | Grayson | Kentucky | 21085 | 93 | 6 |
122257 | 122257 | 2020-05-07 | Green | Kentucky | 21087 | 1 | 0 |
122258 | 122258 | 2020-05-07 | Greenup | Kentucky | 21089 | 12 | 0 |
122259 | 122259 | 2020-05-07 | Hancock | Kentucky | 21091 | 6 | 0 |
122260 | 122260 | 2020-05-07 | Hardin | Kentucky | 21093 | 56 | 2 |
122261 | 122261 | 2020-05-07 | Harlan | Kentucky | 21095 | 1 | 0 |
122262 | 122262 | 2020-05-07 | Harrison | Kentucky | 21097 | 18 | 0 |
122263 | 122263 | 2020-05-07 | Hart | Kentucky | 21099 | 11 | 0 |
122264 | 122264 | 2020-05-07 | Henderson | Kentucky | 21101 | 79 | 2 |
122265 | 122265 | 2020-05-07 | Henry | Kentucky | 21103 | 8 | 0 |
122266 | 122266 | 2020-05-07 | Hickman | Kentucky | 21105 | 5 | 0 |
122267 | 122267 | 2020-05-07 | Hopkins | Kentucky | 21107 | 212 | 24 |
122268 | 122268 | 2020-05-07 | Jackson | Kentucky | 21109 | 60 | 12 |
122269 | 122269 | 2020-05-07 | Jefferson | Kentucky | 21111 | 1578 | 113 |
122270 | 122270 | 2020-05-07 | Jessamine | Kentucky | 21113 | 40 | 0 |
122271 | 122271 | 2020-05-07 | Johnson | Kentucky | 21115 | 4 | 0 |
122272 | 122272 | 2020-05-07 | Kenton | Kentucky | 21117 | 360 | 26 |
122273 | 122273 | 2020-05-07 | Knott | Kentucky | 21119 | 4 | 0 |
122274 | 122274 | 2020-05-07 | Knox | Kentucky | 21121 | 6 | 0 |
122275 | 122275 | 2020-05-07 | Larue | Kentucky | 21123 | 6 | 0 |
122276 | 122276 | 2020-05-07 | Laurel | Kentucky | 21125 | 20 | 2 |
122277 | 122277 | 2020-05-07 | Lawrence | Kentucky | 21127 | 1 | 0 |
122278 | 122278 | 2020-05-07 | Leslie | Kentucky | 21131 | 4 | 0 |
122279 | 122279 | 2020-05-07 | Letcher | Kentucky | 21133 | 3 | 0 |
122280 | 122280 | 2020-05-07 | Lewis | Kentucky | 21135 | 3 | 0 |
122281 | 122281 | 2020-05-07 | Lincoln | Kentucky | 21137 | 6 | 1 |
122282 | 122282 | 2020-05-07 | Livingston | Kentucky | 21139 | 6 | 0 |
122283 | 122283 | 2020-05-07 | Logan | Kentucky | 21141 | 40 | 2 |
122284 | 122284 | 2020-05-07 | Lyon | Kentucky | 21143 | 13 | 3 |
122285 | 122285 | 2020-05-07 | Madison | Kentucky | 21151 | 33 | 1 |
122286 | 122286 | 2020-05-07 | Marion | Kentucky | 21155 | 17 | 0 |
122287 | 122287 | 2020-05-07 | Marshall | Kentucky | 21157 | 34 | 1 |
122288 | 122288 | 2020-05-07 | Martin | Kentucky | 21159 | 3 | 0 |
122289 | 122289 | 2020-05-07 | Mason | Kentucky | 21161 | 6 | 0 |
122290 | 122290 | 2020-05-07 | McCracken | Kentucky | 21145 | 68 | 2 |
122291 | 122291 | 2020-05-07 | McCreary | Kentucky | 21147 | 11 | 0 |
122292 | 122292 | 2020-05-07 | McLean | Kentucky | 21149 | 16 | 0 |
122293 | 122293 | 2020-05-07 | Meade | Kentucky | 21163 | 17 | 1 |
122294 | 122294 | 2020-05-07 | Menifee | Kentucky | 21165 | 3 | 0 |
122295 | 122295 | 2020-05-07 | Mercer | Kentucky | 21167 | 11 | 0 |
122296 | 122296 | 2020-05-07 | Metcalfe | Kentucky | 21169 | 2 | 0 |
122297 | 122297 | 2020-05-07 | Monroe | Kentucky | 21171 | 6 | 0 |
122298 | 122298 | 2020-05-07 | Montgomery | Kentucky | 21173 | 12 | 0 |
122299 | 122299 | 2020-05-07 | Morgan | Kentucky | 21175 | 1 | 0 |
122300 | 122300 | 2020-05-07 | Muhlenberg | Kentucky | 21177 | 458 | 6 |
122301 | 122301 | 2020-05-07 | Nelson | Kentucky | 21179 | 28 | 0 |
122302 | 122302 | 2020-05-07 | Nicholas | Kentucky | 21181 | 1 | 0 |
122303 | 122303 | 2020-05-07 | Ohio | Kentucky | 21183 | 81 | 0 |
122304 | 122304 | 2020-05-07 | Oldham | Kentucky | 21185 | 36 | 0 |
122305 | 122305 | 2020-05-07 | Owen | Kentucky | 21187 | 1 | 0 |
122306 | 122306 | 2020-05-07 | Owsley | Kentucky | 21189 | 2 | 0 |
122307 | 122307 | 2020-05-07 | Pendleton | Kentucky | 21191 | 6 | 0 |
122308 | 122308 | 2020-05-07 | Perry | Kentucky | 21193 | 14 | 0 |
122309 | 122309 | 2020-05-07 | Pike | Kentucky | 21195 | 15 | 2 |
122310 | 122310 | 2020-05-07 | Powell | Kentucky | 21197 | 1 | 0 |
122311 | 122311 | 2020-05-07 | Pulaski | Kentucky | 21199 | 43 | 2 |
122312 | 122312 | 2020-05-07 | Rockcastle | Kentucky | 21203 | 13 | 0 |
122313 | 122313 | 2020-05-07 | Rowan | Kentucky | 21205 | 2 | 0 |
122314 | 122314 | 2020-05-07 | Russell | Kentucky | 21207 | 17 | 4 |
122315 | 122315 | 2020-05-07 | Scott | Kentucky | 21209 | 32 | 0 |
122316 | 122316 | 2020-05-07 | Shelby | Kentucky | 21211 | 35 | 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);