ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where "date" is on date 2020-05-22 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
167282 | 167282 | 2020-05-22 | Adair | Kentucky | 21001 | 96 | 18 |
167283 | 167283 | 2020-05-22 | Allen | Kentucky | 21003 | 44 | 2 |
167284 | 167284 | 2020-05-22 | Anderson | Kentucky | 21005 | 15 | 1 |
167285 | 167285 | 2020-05-22 | Ballard | Kentucky | 21007 | 10 | 0 |
167286 | 167286 | 2020-05-22 | Barren | Kentucky | 21009 | 40 | 1 |
167287 | 167287 | 2020-05-22 | Bath | Kentucky | 21011 | 8 | 1 |
167288 | 167288 | 2020-05-22 | Bell | Kentucky | 21013 | 1 | 0 |
167289 | 167289 | 2020-05-22 | Boone | Kentucky | 21015 | 379 | 11 |
167290 | 167290 | 2020-05-22 | Bourbon | Kentucky | 21017 | 9 | 1 |
167291 | 167291 | 2020-05-22 | Boyd | Kentucky | 21019 | 39 | 3 |
167292 | 167292 | 2020-05-22 | Boyle | Kentucky | 21021 | 20 | 0 |
167293 | 167293 | 2020-05-22 | Bracken | Kentucky | 21023 | 11 | 0 |
167294 | 167294 | 2020-05-22 | Breathitt | Kentucky | 21025 | 3 | 0 |
167295 | 167295 | 2020-05-22 | Breckinridge | Kentucky | 21027 | 16 | 2 |
167296 | 167296 | 2020-05-22 | Bullitt | Kentucky | 21029 | 101 | 4 |
167297 | 167297 | 2020-05-22 | Butler | Kentucky | 21031 | 219 | 6 |
167298 | 167298 | 2020-05-22 | Caldwell | Kentucky | 21033 | 12 | 0 |
167299 | 167299 | 2020-05-22 | Calloway | Kentucky | 21035 | 49 | 1 |
167300 | 167300 | 2020-05-22 | Campbell | Kentucky | 21037 | 144 | 11 |
167301 | 167301 | 2020-05-22 | Carlisle | Kentucky | 21039 | 5 | 1 |
167302 | 167302 | 2020-05-22 | Carroll | Kentucky | 21041 | 6 | 0 |
167303 | 167303 | 2020-05-22 | Carter | Kentucky | 21043 | 9 | 0 |
167304 | 167304 | 2020-05-22 | Casey | Kentucky | 21045 | 2 | 0 |
167305 | 167305 | 2020-05-22 | Christian | Kentucky | 21047 | 101 | 3 |
167306 | 167306 | 2020-05-22 | Clark | Kentucky | 21049 | 37 | 0 |
167307 | 167307 | 2020-05-22 | Clay | Kentucky | 21051 | 3 | 0 |
167308 | 167308 | 2020-05-22 | Clinton | Kentucky | 21053 | 3 | 0 |
167309 | 167309 | 2020-05-22 | Crittenden | Kentucky | 21055 | 5 | 1 |
167310 | 167310 | 2020-05-22 | Cumberland | Kentucky | 21057 | 5 | 0 |
167311 | 167311 | 2020-05-22 | Daviess | Kentucky | 21059 | 300 | 6 |
167312 | 167312 | 2020-05-22 | Edmonson | Kentucky | 21061 | 53 | 9 |
167313 | 167313 | 2020-05-22 | Elliott | Kentucky | 21063 | 1 | 0 |
167314 | 167314 | 2020-05-22 | Fayette | Kentucky | 21067 | 603 | 13 |
167315 | 167315 | 2020-05-22 | Fleming | Kentucky | 21069 | 2 | 0 |
167316 | 167316 | 2020-05-22 | Floyd | Kentucky | 21071 | 18 | 0 |
167317 | 167317 | 2020-05-22 | Franklin | Kentucky | 21073 | 24 | 0 |
167318 | 167318 | 2020-05-22 | Fulton | Kentucky | 21075 | 3 | 0 |
167319 | 167319 | 2020-05-22 | Gallatin | Kentucky | 21077 | 5 | 0 |
167320 | 167320 | 2020-05-22 | Garrard | Kentucky | 21079 | 4 | 0 |
167321 | 167321 | 2020-05-22 | Grant | Kentucky | 21081 | 36 | 3 |
167322 | 167322 | 2020-05-22 | Graves | Kentucky | 21083 | 152 | 19 |
167323 | 167323 | 2020-05-22 | Grayson | Kentucky | 21085 | 120 | 8 |
167324 | 167324 | 2020-05-22 | Green | Kentucky | 21087 | 1 | 0 |
167325 | 167325 | 2020-05-22 | Greenup | Kentucky | 21089 | 13 | 0 |
167326 | 167326 | 2020-05-22 | Hancock | Kentucky | 21091 | 7 | 0 |
167327 | 167327 | 2020-05-22 | Hardin | Kentucky | 21093 | 90 | 2 |
167328 | 167328 | 2020-05-22 | Harlan | Kentucky | 21095 | 1 | 0 |
167329 | 167329 | 2020-05-22 | Harrison | Kentucky | 21097 | 19 | 0 |
167330 | 167330 | 2020-05-22 | Hart | Kentucky | 21099 | 21 | 0 |
167331 | 167331 | 2020-05-22 | Henderson | Kentucky | 21101 | 103 | 4 |
167332 | 167332 | 2020-05-22 | Henry | Kentucky | 21103 | 14 | 0 |
167333 | 167333 | 2020-05-22 | Hickman | Kentucky | 21105 | 5 | 0 |
167334 | 167334 | 2020-05-22 | Hopkins | Kentucky | 21107 | 220 | 29 |
167335 | 167335 | 2020-05-22 | Jackson | Kentucky | 21109 | 60 | 13 |
167336 | 167336 | 2020-05-22 | Jefferson | Kentucky | 21111 | 2233 | 146 |
167337 | 167337 | 2020-05-22 | Jessamine | Kentucky | 21113 | 50 | 0 |
167338 | 167338 | 2020-05-22 | Johnson | Kentucky | 21115 | 5 | 0 |
167339 | 167339 | 2020-05-22 | Kenton | Kentucky | 21117 | 520 | 32 |
167340 | 167340 | 2020-05-22 | Knott | Kentucky | 21119 | 4 | 0 |
167341 | 167341 | 2020-05-22 | Knox | Kentucky | 21121 | 8 | 0 |
167342 | 167342 | 2020-05-22 | Larue | Kentucky | 21123 | 6 | 0 |
167343 | 167343 | 2020-05-22 | Laurel | Kentucky | 21125 | 21 | 2 |
167344 | 167344 | 2020-05-22 | Lawrence | Kentucky | 21127 | 2 | 0 |
167345 | 167345 | 2020-05-22 | Leslie | Kentucky | 21131 | 6 | 0 |
167346 | 167346 | 2020-05-22 | Letcher | Kentucky | 21133 | 5 | 0 |
167347 | 167347 | 2020-05-22 | Lewis | Kentucky | 21135 | 8 | 0 |
167348 | 167348 | 2020-05-22 | Lincoln | Kentucky | 21137 | 8 | 1 |
167349 | 167349 | 2020-05-22 | Livingston | Kentucky | 21139 | 8 | 0 |
167350 | 167350 | 2020-05-22 | Logan | Kentucky | 21141 | 114 | 3 |
167351 | 167351 | 2020-05-22 | Lyon | Kentucky | 21143 | 14 | 3 |
167352 | 167352 | 2020-05-22 | Madison | Kentucky | 21151 | 45 | 1 |
167353 | 167353 | 2020-05-22 | Magoffin | Kentucky | 21153 | 1 | 0 |
167354 | 167354 | 2020-05-22 | Marion | Kentucky | 21155 | 18 | 0 |
167355 | 167355 | 2020-05-22 | Marshall | Kentucky | 21157 | 37 | 2 |
167356 | 167356 | 2020-05-22 | Martin | Kentucky | 21159 | 3 | 0 |
167357 | 167357 | 2020-05-22 | Mason | Kentucky | 21161 | 8 | 0 |
167358 | 167358 | 2020-05-22 | McCracken | Kentucky | 21145 | 85 | 2 |
167359 | 167359 | 2020-05-22 | McCreary | Kentucky | 21147 | 13 | 0 |
167360 | 167360 | 2020-05-22 | McLean | Kentucky | 21149 | 20 | 1 |
167361 | 167361 | 2020-05-22 | Meade | Kentucky | 21163 | 21 | 2 |
167362 | 167362 | 2020-05-22 | Menifee | Kentucky | 21165 | 8 | 0 |
167363 | 167363 | 2020-05-22 | Mercer | Kentucky | 21167 | 12 | 0 |
167364 | 167364 | 2020-05-22 | Metcalfe | Kentucky | 21169 | 4 | 0 |
167365 | 167365 | 2020-05-22 | Monroe | Kentucky | 21171 | 7 | 0 |
167366 | 167366 | 2020-05-22 | Montgomery | Kentucky | 21173 | 17 | 0 |
167367 | 167367 | 2020-05-22 | Morgan | Kentucky | 21175 | 1 | 0 |
167368 | 167368 | 2020-05-22 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
167369 | 167369 | 2020-05-22 | Nelson | Kentucky | 21179 | 36 | 0 |
167370 | 167370 | 2020-05-22 | Nicholas | Kentucky | 21181 | 1 | 0 |
167371 | 167371 | 2020-05-22 | Ohio | Kentucky | 21183 | 145 | 0 |
167372 | 167372 | 2020-05-22 | Oldham | Kentucky | 21185 | 60 | 3 |
167373 | 167373 | 2020-05-22 | Owen | Kentucky | 21187 | 1 | 0 |
167374 | 167374 | 2020-05-22 | Owsley | Kentucky | 21189 | 2 | 0 |
167375 | 167375 | 2020-05-22 | Pendleton | Kentucky | 21191 | 7 | 0 |
167376 | 167376 | 2020-05-22 | Perry | Kentucky | 21193 | 19 | 0 |
167377 | 167377 | 2020-05-22 | Pike | Kentucky | 21195 | 28 | 2 |
167378 | 167378 | 2020-05-22 | Powell | Kentucky | 21197 | 1 | 0 |
167379 | 167379 | 2020-05-22 | Pulaski | Kentucky | 21199 | 53 | 2 |
167380 | 167380 | 2020-05-22 | Rockcastle | Kentucky | 21203 | 13 | 0 |
167381 | 167381 | 2020-05-22 | Rowan | Kentucky | 21205 | 7 | 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);