ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2021-02-25" 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 |
---|---|---|---|---|---|---|---|
1064244 | 1064244 | 2021-02-25 | Adair | Kentucky | 21001 | 1674 | 49 |
1064245 | 1064245 | 2021-02-25 | Allen | Kentucky | 21003 | 1789 | 22 |
1064246 | 1064246 | 2021-02-25 | Anderson | Kentucky | 21005 | 1607 | 16 |
1064247 | 1064247 | 2021-02-25 | Ballard | Kentucky | 21007 | 345 | 5 |
1064248 | 1064248 | 2021-02-25 | Barren | Kentucky | 21009 | 4019 | 71 |
1064249 | 1064249 | 2021-02-25 | Bath | Kentucky | 21011 | 752 | 16 |
1064250 | 1064250 | 2021-02-25 | Bell | Kentucky | 21013 | 2721 | 35 |
1064251 | 1064251 | 2021-02-25 | Boone | Kentucky | 21015 | 12895 | 75 |
1064252 | 1064252 | 2021-02-25 | Bourbon | Kentucky | 21017 | 1535 | 12 |
1064253 | 1064253 | 2021-02-25 | Boyd | Kentucky | 21019 | 4613 | 43 |
1064254 | 1064254 | 2021-02-25 | Boyle | Kentucky | 21021 | 3144 | 31 |
1064255 | 1064255 | 2021-02-25 | Bracken | Kentucky | 21023 | 516 | 4 |
1064256 | 1064256 | 2021-02-25 | Breathitt | Kentucky | 21025 | 918 | 6 |
1064257 | 1064257 | 2021-02-25 | Breckinridge | Kentucky | 21027 | 1092 | 9 |
1064258 | 1064258 | 2021-02-25 | Bullitt | Kentucky | 21029 | 6381 | 48 |
1064259 | 1064259 | 2021-02-25 | Butler | Kentucky | 21031 | 1326 | 23 |
1064260 | 1064260 | 2021-02-25 | Caldwell | Kentucky | 21033 | 1525 | 23 |
1064261 | 1064261 | 2021-02-25 | Calloway | Kentucky | 21035 | 3355 | 38 |
1064262 | 1064262 | 2021-02-25 | Campbell | Kentucky | 21037 | 8024 | 47 |
1064263 | 1064263 | 2021-02-25 | Carlisle | Kentucky | 21039 | 431 | 1 |
1064264 | 1064264 | 2021-02-25 | Carroll | Kentucky | 21041 | 880 | 10 |
1064265 | 1064265 | 2021-02-25 | Carter | Kentucky | 21043 | 1969 | 23 |
1064266 | 1064266 | 2021-02-25 | Casey | Kentucky | 21045 | 1269 | 34 |
1064267 | 1064267 | 2021-02-25 | Christian | Kentucky | 21047 | 6209 | 79 |
1064268 | 1064268 | 2021-02-25 | Clark | Kentucky | 21049 | 2407 | 18 |
1064269 | 1064269 | 2021-02-25 | Clay | Kentucky | 21051 | 2378 | 26 |
1064270 | 1064270 | 2021-02-25 | Clinton | Kentucky | 21053 | 1389 | 27 |
1064271 | 1064271 | 2021-02-25 | Crittenden | Kentucky | 21055 | 552 | 17 |
1064272 | 1064272 | 2021-02-25 | Cumberland | Kentucky | 21057 | 656 | 9 |
1064273 | 1064273 | 2021-02-25 | Daviess | Kentucky | 21059 | 9666 | 155 |
1064274 | 1064274 | 2021-02-25 | Edmonson | Kentucky | 21061 | 864 | 18 |
1064275 | 1064275 | 2021-02-25 | Elliott | Kentucky | 21063 | 939 | 2 |
1064276 | 1064276 | 2021-02-25 | Estill | Kentucky | 21065 | 966 | 2 |
1064277 | 1064277 | 2021-02-25 | Fayette | Kentucky | 21067 | 32437 | 232 |
1064278 | 1064278 | 2021-02-25 | Fleming | Kentucky | 21069 | 1073 | 14 |
1064279 | 1064279 | 2021-02-25 | Floyd | Kentucky | 21071 | 3015 | 39 |
1064280 | 1064280 | 2021-02-25 | Franklin | Kentucky | 21073 | 3617 | 28 |
1064281 | 1064281 | 2021-02-25 | Fulton | Kentucky | 21075 | 474 | 6 |
1064282 | 1064282 | 2021-02-25 | Gallatin | Kentucky | 21077 | 648 | 19 |
1064283 | 1064283 | 2021-02-25 | Garrard | Kentucky | 21079 | 1382 | 9 |
1064284 | 1064284 | 2021-02-25 | Grant | Kentucky | 21081 | 2172 | 13 |
1064285 | 1064285 | 2021-02-25 | Graves | Kentucky | 21083 | 3949 | 71 |
1064286 | 1064286 | 2021-02-25 | Grayson | Kentucky | 21085 | 1942 | 45 |
1064287 | 1064287 | 2021-02-25 | Green | Kentucky | 21087 | 1115 | 13 |
1064288 | 1064288 | 2021-02-25 | Greenup | Kentucky | 21089 | 3310 | 23 |
1064289 | 1064289 | 2021-02-25 | Hancock | Kentucky | 21091 | 802 | 15 |
1064290 | 1064290 | 2021-02-25 | Hardin | Kentucky | 21093 | 8754 | 94 |
1064291 | 1064291 | 2021-02-25 | Harlan | Kentucky | 21095 | 2379 | 69 |
1064292 | 1064292 | 2021-02-25 | Harrison | Kentucky | 21097 | 1495 | 9 |
1064293 | 1064293 | 2021-02-25 | Hart | Kentucky | 21099 | 1814 | 33 |
1064294 | 1064294 | 2021-02-25 | Henderson | Kentucky | 21101 | 4312 | 57 |
1064295 | 1064295 | 2021-02-25 | Henry | Kentucky | 21103 | 1217 | 8 |
1064296 | 1064296 | 2021-02-25 | Hickman | Kentucky | 21105 | 319 | 7 |
1064297 | 1064297 | 2021-02-25 | Hopkins | Kentucky | 21107 | 3906 | 128 |
1064298 | 1064298 | 2021-02-25 | Jackson | Kentucky | 21109 | 1200 | 29 |
1064299 | 1064299 | 2021-02-25 | Jefferson | Kentucky | 21111 | 73700 | 909 |
1064300 | 1064300 | 2021-02-25 | Jessamine | Kentucky | 21113 | 4129 | 51 |
1064301 | 1064301 | 2021-02-25 | Johnson | Kentucky | 21115 | 1747 | 18 |
1064302 | 1064302 | 2021-02-25 | Kenton | Kentucky | 21117 | 15293 | 128 |
1064303 | 1064303 | 2021-02-25 | Knott | Kentucky | 21119 | 1043 | 15 |
1064304 | 1064304 | 2021-02-25 | Knox | Kentucky | 21121 | 2866 | 11 |
1064305 | 1064305 | 2021-02-25 | Larue | Kentucky | 21123 | 1201 | 14 |
1064306 | 1064306 | 2021-02-25 | Laurel | Kentucky | 21125 | 5826 | 25 |
1064307 | 1064307 | 2021-02-25 | Lawrence | Kentucky | 21127 | 1240 | 20 |
1064308 | 1064308 | 2021-02-25 | Lee | Kentucky | 21129 | 1188 | 19 |
1064309 | 1064309 | 2021-02-25 | Leslie | Kentucky | 21131 | 779 | 2 |
1064310 | 1064310 | 2021-02-25 | Letcher | Kentucky | 21133 | 1675 | 18 |
1064311 | 1064311 | 2021-02-25 | Lewis | Kentucky | 21135 | 1087 | 31 |
1064312 | 1064312 | 2021-02-25 | Lincoln | Kentucky | 21137 | 2085 | 32 |
1064313 | 1064313 | 2021-02-25 | Livingston | Kentucky | 21139 | 754 | 17 |
1064314 | 1064314 | 2021-02-25 | Logan | Kentucky | 21141 | 2466 | 51 |
1064315 | 1064315 | 2021-02-25 | Lyon | Kentucky | 21143 | 486 | 13 |
1064316 | 1064316 | 2021-02-25 | Madison | Kentucky | 21151 | 8587 | 86 |
1064317 | 1064317 | 2021-02-25 | Magoffin | Kentucky | 21153 | 865 | 1 |
1064318 | 1064318 | 2021-02-25 | Marion | Kentucky | 21155 | 2142 | 24 |
1064319 | 1064319 | 2021-02-25 | Marshall | Kentucky | 21157 | 2510 | 48 |
1064320 | 1064320 | 2021-02-25 | Martin | Kentucky | 21159 | 924 | 11 |
1064321 | 1064321 | 2021-02-25 | Mason | Kentucky | 21161 | 1422 | 27 |
1064322 | 1064322 | 2021-02-25 | McCracken | Kentucky | 21145 | 5729 | 67 |
1064323 | 1064323 | 2021-02-25 | McCreary | Kentucky | 21147 | 1758 | 25 |
1064324 | 1064324 | 2021-02-25 | McLean | Kentucky | 21149 | 831 | 25 |
1064325 | 1064325 | 2021-02-25 | Meade | Kentucky | 21163 | 1850 | 16 |
1064326 | 1064326 | 2021-02-25 | Menifee | Kentucky | 21165 | 409 | 13 |
1064327 | 1064327 | 2021-02-25 | Mercer | Kentucky | 21167 | 2348 | 30 |
1064328 | 1064328 | 2021-02-25 | Metcalfe | Kentucky | 21169 | 961 | 20 |
1064329 | 1064329 | 2021-02-25 | Monroe | Kentucky | 21171 | 1248 | 38 |
1064330 | 1064330 | 2021-02-25 | Montgomery | Kentucky | 21173 | 2299 | 24 |
1064331 | 1064331 | 2021-02-25 | Morgan | Kentucky | 21175 | 2024 | 1 |
1064332 | 1064332 | 2021-02-25 | Muhlenberg | Kentucky | 21177 | 2731 | 55 |
1064333 | 1064333 | 2021-02-25 | Nelson | Kentucky | 21179 | 4579 | 38 |
1064334 | 1064334 | 2021-02-25 | Nicholas | Kentucky | 21181 | 453 | 6 |
1064335 | 1064335 | 2021-02-25 | Ohio | Kentucky | 21183 | 2333 | 48 |
1064336 | 1064336 | 2021-02-25 | Oldham | Kentucky | 21185 | 6881 | 69 |
1064337 | 1064337 | 2021-02-25 | Owen | Kentucky | 21187 | 623 | 8 |
1064338 | 1064338 | 2021-02-25 | Owsley | Kentucky | 21189 | 419 | 10 |
1064339 | 1064339 | 2021-02-25 | Pendleton | Kentucky | 21191 | 921 | 1 |
1064340 | 1064340 | 2021-02-25 | Perry | Kentucky | 21193 | 2278 | 34 |
1064341 | 1064341 | 2021-02-25 | Pike | Kentucky | 21195 | 5093 | 57 |
1064342 | 1064342 | 2021-02-25 | Powell | Kentucky | 21197 | 968 | 1 |
1064343 | 1064343 | 2021-02-25 | Pulaski | Kentucky | 21199 | 5753 | 87 |
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);