ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2021-02-05" 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 |
---|---|---|---|---|---|---|---|
999331 | 999331 | 2021-02-05 | Adair | Kentucky | 21001 | 1558 | 49 |
999332 | 999332 | 2021-02-05 | Allen | Kentucky | 21003 | 1649 | 22 |
999333 | 999333 | 2021-02-05 | Anderson | Kentucky | 21005 | 1522 | 13 |
999334 | 999334 | 2021-02-05 | Ballard | Kentucky | 21007 | 318 | 5 |
999335 | 999335 | 2021-02-05 | Barren | Kentucky | 21009 | 3635 | 39 |
999336 | 999336 | 2021-02-05 | Bath | Kentucky | 21011 | 713 | 15 |
999337 | 999337 | 2021-02-05 | Bell | Kentucky | 21013 | 2492 | 33 |
999338 | 999338 | 2021-02-05 | Boone | Kentucky | 21015 | 11796 | 64 |
999339 | 999339 | 2021-02-05 | Bourbon | Kentucky | 21017 | 1454 | 12 |
999340 | 999340 | 2021-02-05 | Boyd | Kentucky | 21019 | 4362 | 35 |
999341 | 999341 | 2021-02-05 | Boyle | Kentucky | 21021 | 3002 | 28 |
999342 | 999342 | 2021-02-05 | Bracken | Kentucky | 21023 | 464 | 3 |
999343 | 999343 | 2021-02-05 | Breathitt | Kentucky | 21025 | 859 | 4 |
999344 | 999344 | 2021-02-05 | Breckinridge | Kentucky | 21027 | 1020 | 5 |
999345 | 999345 | 2021-02-05 | Bullitt | Kentucky | 21029 | 5885 | 40 |
999346 | 999346 | 2021-02-05 | Butler | Kentucky | 21031 | 1234 | 18 |
999347 | 999347 | 2021-02-05 | Caldwell | Kentucky | 21033 | 1195 | 21 |
999348 | 999348 | 2021-02-05 | Calloway | Kentucky | 21035 | 3281 | 36 |
999349 | 999349 | 2021-02-05 | Campbell | Kentucky | 21037 | 7353 | 44 |
999350 | 999350 | 2021-02-05 | Carlisle | Kentucky | 21039 | 415 | 1 |
999351 | 999351 | 2021-02-05 | Carroll | Kentucky | 21041 | 827 | 10 |
999352 | 999352 | 2021-02-05 | Carter | Kentucky | 21043 | 1868 | 21 |
999353 | 999353 | 2021-02-05 | Casey | Kentucky | 21045 | 1199 | 33 |
999354 | 999354 | 2021-02-05 | Christian | Kentucky | 21047 | 5895 | 75 |
999355 | 999355 | 2021-02-05 | Clark | Kentucky | 21049 | 2256 | 16 |
999356 | 999356 | 2021-02-05 | Clay | Kentucky | 21051 | 2251 | 25 |
999357 | 999357 | 2021-02-05 | Clinton | Kentucky | 21053 | 1314 | 26 |
999358 | 999358 | 2021-02-05 | Crittenden | Kentucky | 21055 | 518 | 15 |
999359 | 999359 | 2021-02-05 | Cumberland | Kentucky | 21057 | 620 | 8 |
999360 | 999360 | 2021-02-05 | Daviess | Kentucky | 21059 | 8978 | 148 |
999361 | 999361 | 2021-02-05 | Edmonson | Kentucky | 21061 | 813 | 15 |
999362 | 999362 | 2021-02-05 | Elliott | Kentucky | 21063 | 911 | 1 |
999363 | 999363 | 2021-02-05 | Estill | Kentucky | 21065 | 907 | 0 |
999364 | 999364 | 2021-02-05 | Fayette | Kentucky | 21067 | 30454 | 205 |
999365 | 999365 | 2021-02-05 | Fleming | Kentucky | 21069 | 1024 | 13 |
999366 | 999366 | 2021-02-05 | Floyd | Kentucky | 21071 | 2817 | 20 |
999367 | 999367 | 2021-02-05 | Franklin | Kentucky | 21073 | 3312 | 28 |
999368 | 999368 | 2021-02-05 | Fulton | Kentucky | 21075 | 452 | 4 |
999369 | 999369 | 2021-02-05 | Gallatin | Kentucky | 21077 | 595 | 19 |
999370 | 999370 | 2021-02-05 | Garrard | Kentucky | 21079 | 1307 | 4 |
999371 | 999371 | 2021-02-05 | Grant | Kentucky | 21081 | 1945 | 12 |
999372 | 999372 | 2021-02-05 | Graves | Kentucky | 21083 | 3778 | 65 |
999373 | 999373 | 2021-02-05 | Grayson | Kentucky | 21085 | 1800 | 45 |
999374 | 999374 | 2021-02-05 | Green | Kentucky | 21087 | 1024 | 13 |
999375 | 999375 | 2021-02-05 | Greenup | Kentucky | 21089 | 3156 | 23 |
999376 | 999376 | 2021-02-05 | Hancock | Kentucky | 21091 | 751 | 14 |
999377 | 999377 | 2021-02-05 | Hardin | Kentucky | 21093 | 8201 | 78 |
999378 | 999378 | 2021-02-05 | Harlan | Kentucky | 21095 | 2272 | 56 |
999379 | 999379 | 2021-02-05 | Harrison | Kentucky | 21097 | 1401 | 6 |
999380 | 999380 | 2021-02-05 | Hart | Kentucky | 21099 | 1696 | 24 |
999381 | 999381 | 2021-02-05 | Henderson | Kentucky | 21101 | 4095 | 57 |
999382 | 999382 | 2021-02-05 | Henry | Kentucky | 21103 | 1118 | 6 |
999383 | 999383 | 2021-02-05 | Hickman | Kentucky | 21105 | 291 | 7 |
999384 | 999384 | 2021-02-05 | Hopkins | Kentucky | 21107 | 3685 | 122 |
999385 | 999385 | 2021-02-05 | Jackson | Kentucky | 21109 | 1126 | 27 |
999386 | 999386 | 2021-02-05 | Jefferson | Kentucky | 21111 | 69399 | 828 |
999387 | 999387 | 2021-02-05 | Jessamine | Kentucky | 21113 | 3806 | 48 |
999388 | 999388 | 2021-02-05 | Johnson | Kentucky | 21115 | 1617 | 18 |
999389 | 999389 | 2021-02-05 | Kenton | Kentucky | 21117 | 13950 | 113 |
999390 | 999390 | 2021-02-05 | Knott | Kentucky | 21119 | 909 | 15 |
999391 | 999391 | 2021-02-05 | Knox | Kentucky | 21121 | 2687 | 11 |
999392 | 999392 | 2021-02-05 | Larue | Kentucky | 21123 | 1103 | 9 |
999393 | 999393 | 2021-02-05 | Laurel | Kentucky | 21125 | 5313 | 19 |
999394 | 999394 | 2021-02-05 | Lawrence | Kentucky | 21127 | 1121 | 12 |
999395 | 999395 | 2021-02-05 | Lee | Kentucky | 21129 | 1140 | 18 |
999396 | 999396 | 2021-02-05 | Leslie | Kentucky | 21131 | 706 | 2 |
999397 | 999397 | 2021-02-05 | Letcher | Kentucky | 21133 | 1551 | 16 |
999398 | 999398 | 2021-02-05 | Lewis | Kentucky | 21135 | 1022 | 30 |
999399 | 999399 | 2021-02-05 | Lincoln | Kentucky | 21137 | 1958 | 31 |
999400 | 999400 | 2021-02-05 | Livingston | Kentucky | 21139 | 676 | 16 |
999401 | 999401 | 2021-02-05 | Logan | Kentucky | 21141 | 2293 | 46 |
999402 | 999402 | 2021-02-05 | Lyon | Kentucky | 21143 | 425 | 12 |
999403 | 999403 | 2021-02-05 | Madison | Kentucky | 21151 | 7972 | 57 |
999404 | 999404 | 2021-02-05 | Magoffin | Kentucky | 21153 | 815 | 1 |
999405 | 999405 | 2021-02-05 | Marion | Kentucky | 21155 | 1965 | 21 |
999406 | 999406 | 2021-02-05 | Marshall | Kentucky | 21157 | 2338 | 38 |
999407 | 999407 | 2021-02-05 | Martin | Kentucky | 21159 | 882 | 11 |
999408 | 999408 | 2021-02-05 | Mason | Kentucky | 21161 | 1289 | 26 |
999409 | 999409 | 2021-02-05 | McCracken | Kentucky | 21145 | 5392 | 59 |
999410 | 999410 | 2021-02-05 | McCreary | Kentucky | 21147 | 1611 | 20 |
999411 | 999411 | 2021-02-05 | McLean | Kentucky | 21149 | 802 | 25 |
999412 | 999412 | 2021-02-05 | Meade | Kentucky | 21163 | 1718 | 10 |
999413 | 999413 | 2021-02-05 | Menifee | Kentucky | 21165 | 368 | 11 |
999414 | 999414 | 2021-02-05 | Mercer | Kentucky | 21167 | 2224 | 15 |
999415 | 999415 | 2021-02-05 | Metcalfe | Kentucky | 21169 | 844 | 14 |
999416 | 999416 | 2021-02-05 | Monroe | Kentucky | 21171 | 1196 | 36 |
999417 | 999417 | 2021-02-05 | Montgomery | Kentucky | 21173 | 2032 | 23 |
999418 | 999418 | 2021-02-05 | Morgan | Kentucky | 21175 | 1933 | 0 |
999419 | 999419 | 2021-02-05 | Muhlenberg | Kentucky | 21177 | 2618 | 50 |
999420 | 999420 | 2021-02-05 | Nelson | Kentucky | 21179 | 4252 | 27 |
999421 | 999421 | 2021-02-05 | Nicholas | Kentucky | 21181 | 429 | 6 |
999422 | 999422 | 2021-02-05 | Ohio | Kentucky | 21183 | 2190 | 45 |
999423 | 999423 | 2021-02-05 | Oldham | Kentucky | 21185 | 6574 | 68 |
999424 | 999424 | 2021-02-05 | Owen | Kentucky | 21187 | 576 | 7 |
999425 | 999425 | 2021-02-05 | Owsley | Kentucky | 21189 | 368 | 10 |
999426 | 999426 | 2021-02-05 | Pendleton | Kentucky | 21191 | 864 | 1 |
999427 | 999427 | 2021-02-05 | Perry | Kentucky | 21193 | 2055 | 29 |
999428 | 999428 | 2021-02-05 | Pike | Kentucky | 21195 | 4711 | 51 |
999429 | 999429 | 2021-02-05 | Powell | Kentucky | 21197 | 915 | 0 |
999430 | 999430 | 2021-02-05 | Pulaski | Kentucky | 21199 | 5372 | 77 |
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);