ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where date = "2020-06-25" 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 |
---|---|---|---|---|---|---|---|
272323 | 272323 | 2020-06-25 | Adair | Kentucky | 21001 | 110 | 19 |
272324 | 272324 | 2020-06-25 | Allen | Kentucky | 21003 | 162 | 5 |
272325 | 272325 | 2020-06-25 | Anderson | Kentucky | 21005 | 26 | 1 |
272326 | 272326 | 2020-06-25 | Ballard | Kentucky | 21007 | 15 | 0 |
272327 | 272327 | 2020-06-25 | Barren | Kentucky | 21009 | 82 | 2 |
272328 | 272328 | 2020-06-25 | Bath | Kentucky | 21011 | 11 | 1 |
272329 | 272329 | 2020-06-25 | Bell | Kentucky | 21013 | 6 | 0 |
272330 | 272330 | 2020-06-25 | Boone | Kentucky | 21015 | 588 | 23 |
272331 | 272331 | 2020-06-25 | Bourbon | Kentucky | 21017 | 29 | 1 |
272332 | 272332 | 2020-06-25 | Boyd | Kentucky | 21019 | 55 | 3 |
272333 | 272333 | 2020-06-25 | Boyle | Kentucky | 21021 | 38 | 0 |
272334 | 272334 | 2020-06-25 | Bracken | Kentucky | 21023 | 17 | 0 |
272335 | 272335 | 2020-06-25 | Breathitt | Kentucky | 21025 | 7 | 0 |
272336 | 272336 | 2020-06-25 | Breckinridge | Kentucky | 21027 | 24 | 2 |
272337 | 272337 | 2020-06-25 | Bullitt | Kentucky | 21029 | 148 | 4 |
272338 | 272338 | 2020-06-25 | Butler | Kentucky | 21031 | 247 | 14 |
272339 | 272339 | 2020-06-25 | Caldwell | Kentucky | 21033 | 13 | 0 |
272340 | 272340 | 2020-06-25 | Calloway | Kentucky | 21035 | 75 | 1 |
272341 | 272341 | 2020-06-25 | Campbell | Kentucky | 21037 | 238 | 12 |
272342 | 272342 | 2020-06-25 | Carlisle | Kentucky | 21039 | 5 | 1 |
272343 | 272343 | 2020-06-25 | Carroll | Kentucky | 21041 | 30 | 0 |
272344 | 272344 | 2020-06-25 | Carter | Kentucky | 21043 | 22 | 0 |
272345 | 272345 | 2020-06-25 | Casey | Kentucky | 21045 | 14 | 0 |
272346 | 272346 | 2020-06-25 | Christian | Kentucky | 21047 | 225 | 4 |
272347 | 272347 | 2020-06-25 | Clark | Kentucky | 21049 | 96 | 4 |
272348 | 272348 | 2020-06-25 | Clay | Kentucky | 21051 | 44 | 3 |
272349 | 272349 | 2020-06-25 | Clinton | Kentucky | 21053 | 5 | 0 |
272350 | 272350 | 2020-06-25 | Crittenden | Kentucky | 21055 | 8 | 1 |
272351 | 272351 | 2020-06-25 | Cumberland | Kentucky | 21057 | 6 | 0 |
272352 | 272352 | 2020-06-25 | Daviess | Kentucky | 21059 | 414 | 8 |
272353 | 272353 | 2020-06-25 | Edmonson | Kentucky | 21061 | 79 | 11 |
272354 | 272354 | 2020-06-25 | Elliott | Kentucky | 21063 | 3 | 0 |
272355 | 272355 | 2020-06-25 | Estill | Kentucky | 21065 | 4 | 0 |
272356 | 272356 | 2020-06-25 | Fayette | Kentucky | 21067 | 1374 | 23 |
272357 | 272357 | 2020-06-25 | Fleming | Kentucky | 21069 | 14 | 0 |
272358 | 272358 | 2020-06-25 | Floyd | Kentucky | 21071 | 26 | 0 |
272359 | 272359 | 2020-06-25 | Franklin | Kentucky | 21073 | 123 | 3 |
272360 | 272360 | 2020-06-25 | Fulton | Kentucky | 21075 | 18 | 0 |
272361 | 272361 | 2020-06-25 | Gallatin | Kentucky | 21077 | 58 | 7 |
272362 | 272362 | 2020-06-25 | Garrard | Kentucky | 21079 | 17 | 0 |
272363 | 272363 | 2020-06-25 | Grant | Kentucky | 21081 | 57 | 4 |
272364 | 272364 | 2020-06-25 | Graves | Kentucky | 21083 | 190 | 21 |
272365 | 272365 | 2020-06-25 | Grayson | Kentucky | 21085 | 137 | 10 |
272366 | 272366 | 2020-06-25 | Green | Kentucky | 21087 | 4 | 1 |
272367 | 272367 | 2020-06-25 | Greenup | Kentucky | 21089 | 28 | 0 |
272368 | 272368 | 2020-06-25 | Hancock | Kentucky | 21091 | 16 | 0 |
272369 | 272369 | 2020-06-25 | Hardin | Kentucky | 21093 | 138 | 5 |
272370 | 272370 | 2020-06-25 | Harlan | Kentucky | 21095 | 18 | 2 |
272371 | 272371 | 2020-06-25 | Harrison | Kentucky | 21097 | 66 | 0 |
272372 | 272372 | 2020-06-25 | Hart | Kentucky | 21099 | 46 | 0 |
272373 | 272373 | 2020-06-25 | Henderson | Kentucky | 21101 | 155 | 4 |
272374 | 272374 | 2020-06-25 | Henry | Kentucky | 21103 | 32 | 2 |
272375 | 272375 | 2020-06-25 | Hickman | Kentucky | 21105 | 5 | 0 |
272376 | 272376 | 2020-06-25 | Hopkins | Kentucky | 21107 | 243 | 34 |
272377 | 272377 | 2020-06-25 | Jackson | Kentucky | 21109 | 96 | 13 |
272378 | 272378 | 2020-06-25 | Jefferson | Kentucky | 21111 | 3714 | 201 |
272379 | 272379 | 2020-06-25 | Jessamine | Kentucky | 21113 | 102 | 0 |
272380 | 272380 | 2020-06-25 | Johnson | Kentucky | 21115 | 10 | 0 |
272381 | 272381 | 2020-06-25 | Kenton | Kentucky | 21117 | 759 | 37 |
272382 | 272382 | 2020-06-25 | Knott | Kentucky | 21119 | 7 | 0 |
272383 | 272383 | 2020-06-25 | Knox | Kentucky | 21121 | 16 | 0 |
272384 | 272384 | 2020-06-25 | Larue | Kentucky | 21123 | 15 | 1 |
272385 | 272385 | 2020-06-25 | Laurel | Kentucky | 21125 | 71 | 3 |
272386 | 272386 | 2020-06-25 | Lawrence | Kentucky | 21127 | 5 | 0 |
272387 | 272387 | 2020-06-25 | Lee | Kentucky | 21129 | 1 | 0 |
272388 | 272388 | 2020-06-25 | Leslie | Kentucky | 21131 | 8 | 0 |
272389 | 272389 | 2020-06-25 | Letcher | Kentucky | 21133 | 14 | 0 |
272390 | 272390 | 2020-06-25 | Lewis | Kentucky | 21135 | 18 | 0 |
272391 | 272391 | 2020-06-25 | Lincoln | Kentucky | 21137 | 24 | 1 |
272392 | 272392 | 2020-06-25 | Livingston | Kentucky | 21139 | 8 | 0 |
272393 | 272393 | 2020-06-25 | Logan | Kentucky | 21141 | 215 | 14 |
272394 | 272394 | 2020-06-25 | Lyon | Kentucky | 21143 | 17 | 3 |
272395 | 272395 | 2020-06-25 | Madison | Kentucky | 21151 | 106 | 1 |
272396 | 272396 | 2020-06-25 | Magoffin | Kentucky | 21153 | 5 | 0 |
272397 | 272397 | 2020-06-25 | Marion | Kentucky | 21155 | 49 | 0 |
272398 | 272398 | 2020-06-25 | Marshall | Kentucky | 21157 | 53 | 2 |
272399 | 272399 | 2020-06-25 | Martin | Kentucky | 21159 | 5 | 0 |
272400 | 272400 | 2020-06-25 | Mason | Kentucky | 21161 | 28 | 0 |
272401 | 272401 | 2020-06-25 | McCracken | Kentucky | 21145 | 151 | 3 |
272402 | 272402 | 2020-06-25 | McCreary | Kentucky | 21147 | 17 | 0 |
272403 | 272403 | 2020-06-25 | McLean | Kentucky | 21149 | 25 | 0 |
272404 | 272404 | 2020-06-25 | Meade | Kentucky | 21163 | 25 | 2 |
272405 | 272405 | 2020-06-25 | Menifee | Kentucky | 21165 | 12 | 0 |
272406 | 272406 | 2020-06-25 | Mercer | Kentucky | 21167 | 17 | 0 |
272407 | 272407 | 2020-06-25 | Metcalfe | Kentucky | 21169 | 9 | 2 |
272408 | 272408 | 2020-06-25 | Monroe | Kentucky | 21171 | 34 | 0 |
272409 | 272409 | 2020-06-25 | Montgomery | Kentucky | 21173 | 46 | 0 |
272410 | 272410 | 2020-06-25 | Morgan | Kentucky | 21175 | 8 | 0 |
272411 | 272411 | 2020-06-25 | Muhlenberg | Kentucky | 21177 | 511 | 8 |
272412 | 272412 | 2020-06-25 | Nelson | Kentucky | 21179 | 67 | 1 |
272413 | 272413 | 2020-06-25 | Nicholas | Kentucky | 21181 | 5 | 0 |
272414 | 272414 | 2020-06-25 | Ohio | Kentucky | 21183 | 193 | 0 |
272415 | 272415 | 2020-06-25 | Oldham | Kentucky | 21185 | 126 | 6 |
272416 | 272416 | 2020-06-25 | Owen | Kentucky | 21187 | 6 | 0 |
272417 | 272417 | 2020-06-25 | Owsley | Kentucky | 21189 | 2 | 0 |
272418 | 272418 | 2020-06-25 | Pendleton | Kentucky | 21191 | 15 | 0 |
272419 | 272419 | 2020-06-25 | Perry | Kentucky | 21193 | 55 | 1 |
272420 | 272420 | 2020-06-25 | Pike | Kentucky | 21195 | 68 | 2 |
272421 | 272421 | 2020-06-25 | Powell | Kentucky | 21197 | 5 | 0 |
272422 | 272422 | 2020-06-25 | Pulaski | Kentucky | 21199 | 84 | 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);