ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where "date" is on date 2020-04-27 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 |
---|---|---|---|---|---|---|---|
93399 | 93399 | 2020-04-27 | Adair | Kentucky | 21001 | 83 | 9 |
93400 | 93400 | 2020-04-27 | Allen | Kentucky | 21003 | 8 | 0 |
93401 | 93401 | 2020-04-27 | Anderson | Kentucky | 21005 | 8 | 1 |
93402 | 93402 | 2020-04-27 | Ballard | Kentucky | 21007 | 7 | 0 |
93403 | 93403 | 2020-04-27 | Barren | Kentucky | 21009 | 15 | 0 |
93404 | 93404 | 2020-04-27 | Bath | Kentucky | 21011 | 4 | 0 |
93405 | 93405 | 2020-04-27 | Boone | Kentucky | 21015 | 116 | 2 |
93406 | 93406 | 2020-04-27 | Bourbon | Kentucky | 21017 | 8 | 1 |
93407 | 93407 | 2020-04-27 | Boyd | Kentucky | 21019 | 33 | 3 |
93408 | 93408 | 2020-04-27 | Boyle | Kentucky | 21021 | 18 | 0 |
93409 | 93409 | 2020-04-27 | Bracken | Kentucky | 21023 | 7 | 0 |
93410 | 93410 | 2020-04-27 | Breathitt | Kentucky | 21025 | 3 | 0 |
93411 | 93411 | 2020-04-27 | Breckinridge | Kentucky | 21027 | 8 | 0 |
93412 | 93412 | 2020-04-27 | Bullitt | Kentucky | 21029 | 50 | 2 |
93413 | 93413 | 2020-04-27 | Butler | Kentucky | 21031 | 104 | 3 |
93414 | 93414 | 2020-04-27 | Caldwell | Kentucky | 21033 | 13 | 0 |
93415 | 93415 | 2020-04-27 | Calloway | Kentucky | 21035 | 31 | 1 |
93416 | 93416 | 2020-04-27 | Campbell | Kentucky | 21037 | 81 | 7 |
93417 | 93417 | 2020-04-27 | Carlisle | Kentucky | 21039 | 2 | 0 |
93418 | 93418 | 2020-04-27 | Carroll | Kentucky | 21041 | 2 | 0 |
93419 | 93419 | 2020-04-27 | Carter | Kentucky | 21043 | 4 | 0 |
93420 | 93420 | 2020-04-27 | Casey | Kentucky | 21045 | 1 | 0 |
93421 | 93421 | 2020-04-27 | Christian | Kentucky | 21047 | 86 | 3 |
93422 | 93422 | 2020-04-27 | Clark | Kentucky | 21049 | 19 | 0 |
93423 | 93423 | 2020-04-27 | Clay | Kentucky | 21051 | 1 | 0 |
93424 | 93424 | 2020-04-27 | Clinton | Kentucky | 21053 | 2 | 0 |
93425 | 93425 | 2020-04-27 | Crittenden | Kentucky | 21055 | 3 | 1 |
93426 | 93426 | 2020-04-27 | Cumberland | Kentucky | 21057 | 5 | 0 |
93427 | 93427 | 2020-04-27 | Daviess | Kentucky | 21059 | 161 | 6 |
93428 | 93428 | 2020-04-27 | Edmonson | Kentucky | 21061 | 17 | 0 |
93429 | 93429 | 2020-04-27 | Fayette | Kentucky | 21067 | 239 | 9 |
93430 | 93430 | 2020-04-27 | Fleming | Kentucky | 21069 | 2 | 0 |
93431 | 93431 | 2020-04-27 | Floyd | Kentucky | 21071 | 10 | 0 |
93432 | 93432 | 2020-04-27 | Franklin | Kentucky | 21073 | 16 | 0 |
93433 | 93433 | 2020-04-27 | Fulton | Kentucky | 21075 | 1 | 0 |
93434 | 93434 | 2020-04-27 | Gallatin | Kentucky | 21077 | 1 | 0 |
93435 | 93435 | 2020-04-27 | Garrard | Kentucky | 21079 | 2 | 0 |
93436 | 93436 | 2020-04-27 | Grant | Kentucky | 21081 | 18 | 3 |
93437 | 93437 | 2020-04-27 | Graves | Kentucky | 21083 | 119 | 11 |
93438 | 93438 | 2020-04-27 | Grayson | Kentucky | 21085 | 60 | 1 |
93439 | 93439 | 2020-04-27 | Green | Kentucky | 21087 | 1 | 0 |
93440 | 93440 | 2020-04-27 | Greenup | Kentucky | 21089 | 11 | 0 |
93441 | 93441 | 2020-04-27 | Hancock | Kentucky | 21091 | 6 | 0 |
93442 | 93442 | 2020-04-27 | Hardin | Kentucky | 21093 | 37 | 0 |
93443 | 93443 | 2020-04-27 | Harrison | Kentucky | 21097 | 18 | 0 |
93444 | 93444 | 2020-04-27 | Hart | Kentucky | 21099 | 3 | 0 |
93445 | 93445 | 2020-04-27 | Henderson | Kentucky | 21101 | 58 | 1 |
93446 | 93446 | 2020-04-27 | Henry | Kentucky | 21103 | 6 | 0 |
93447 | 93447 | 2020-04-27 | Hickman | Kentucky | 21105 | 2 | 0 |
93448 | 93448 | 2020-04-27 | Hopkins | Kentucky | 21107 | 188 | 22 |
93449 | 93449 | 2020-04-27 | Jackson | Kentucky | 21109 | 60 | 6 |
93450 | 93450 | 2020-04-27 | Jefferson | Kentucky | 21111 | 1140 | 83 |
93451 | 93451 | 2020-04-27 | Jessamine | Kentucky | 21113 | 34 | 0 |
93452 | 93452 | 2020-04-27 | Johnson | Kentucky | 21115 | 2 | 0 |
93453 | 93453 | 2020-04-27 | Kenton | Kentucky | 21117 | 230 | 16 |
93454 | 93454 | 2020-04-27 | Knott | Kentucky | 21119 | 4 | 0 |
93455 | 93455 | 2020-04-27 | Knox | Kentucky | 21121 | 6 | 0 |
93456 | 93456 | 2020-04-27 | Larue | Kentucky | 21123 | 5 | 0 |
93457 | 93457 | 2020-04-27 | Laurel | Kentucky | 21125 | 14 | 2 |
93458 | 93458 | 2020-04-27 | Lawrence | Kentucky | 21127 | 1 | 0 |
93459 | 93459 | 2020-04-27 | Leslie | Kentucky | 21131 | 2 | 0 |
93460 | 93460 | 2020-04-27 | Letcher | Kentucky | 21133 | 2 | 0 |
93461 | 93461 | 2020-04-27 | Lewis | Kentucky | 21135 | 3 | 0 |
93462 | 93462 | 2020-04-27 | Lincoln | Kentucky | 21137 | 4 | 1 |
93463 | 93463 | 2020-04-27 | Livingston | Kentucky | 21139 | 4 | 0 |
93464 | 93464 | 2020-04-27 | Logan | Kentucky | 21141 | 8 | 0 |
93465 | 93465 | 2020-04-27 | Lyon | Kentucky | 21143 | 14 | 3 |
93466 | 93466 | 2020-04-27 | Madison | Kentucky | 21151 | 29 | 1 |
93467 | 93467 | 2020-04-27 | Marion | Kentucky | 21155 | 16 | 0 |
93468 | 93468 | 2020-04-27 | Marshall | Kentucky | 21157 | 33 | 0 |
93469 | 93469 | 2020-04-27 | Martin | Kentucky | 21159 | 3 | 0 |
93470 | 93470 | 2020-04-27 | Mason | Kentucky | 21161 | 6 | 0 |
93471 | 93471 | 2020-04-27 | McCracken | Kentucky | 21145 | 44 | 2 |
93472 | 93472 | 2020-04-27 | McCreary | Kentucky | 21147 | 11 | 0 |
93473 | 93473 | 2020-04-27 | McLean | Kentucky | 21149 | 11 | 0 |
93474 | 93474 | 2020-04-27 | Meade | Kentucky | 21163 | 9 | 1 |
93475 | 93475 | 2020-04-27 | Menifee | Kentucky | 21165 | 3 | 0 |
93476 | 93476 | 2020-04-27 | Mercer | Kentucky | 21167 | 11 | 0 |
93477 | 93477 | 2020-04-27 | Monroe | Kentucky | 21171 | 4 | 0 |
93478 | 93478 | 2020-04-27 | Montgomery | Kentucky | 21173 | 10 | 0 |
93479 | 93479 | 2020-04-27 | Morgan | Kentucky | 21175 | 1 | 0 |
93480 | 93480 | 2020-04-27 | Muhlenberg | Kentucky | 21177 | 111 | 4 |
93481 | 93481 | 2020-04-27 | Nelson | Kentucky | 21179 | 19 | 0 |
93482 | 93482 | 2020-04-27 | Nicholas | Kentucky | 21181 | 1 | 0 |
93483 | 93483 | 2020-04-27 | Ohio | Kentucky | 21183 | 40 | 0 |
93484 | 93484 | 2020-04-27 | Oldham | Kentucky | 21185 | 27 | 0 |
93485 | 93485 | 2020-04-27 | Owsley | Kentucky | 21189 | 3 | 0 |
93486 | 93486 | 2020-04-27 | Pendleton | Kentucky | 21191 | 6 | 0 |
93487 | 93487 | 2020-04-27 | Perry | Kentucky | 21193 | 6 | 0 |
93488 | 93488 | 2020-04-27 | Pike | Kentucky | 21195 | 9 | 2 |
93489 | 93489 | 2020-04-27 | Powell | Kentucky | 21197 | 1 | 0 |
93490 | 93490 | 2020-04-27 | Pulaski | Kentucky | 21199 | 41 | 2 |
93491 | 93491 | 2020-04-27 | Rockcastle | Kentucky | 21203 | 11 | 0 |
93492 | 93492 | 2020-04-27 | Rowan | Kentucky | 21205 | 2 | 0 |
93493 | 93493 | 2020-04-27 | Russell | Kentucky | 21207 | 16 | 2 |
93494 | 93494 | 2020-04-27 | Scott | Kentucky | 21209 | 28 | 0 |
93495 | 93495 | 2020-04-27 | Shelby | Kentucky | 21211 | 28 | 3 |
93496 | 93496 | 2020-04-27 | Simpson | Kentucky | 21213 | 24 | 2 |
93497 | 93497 | 2020-04-27 | Spencer | Kentucky | 21215 | 10 | 0 |
93498 | 93498 | 2020-04-27 | Taylor | Kentucky | 21217 | 6 | 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);