ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where "date" is on date 2020-10-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 |
---|---|---|---|---|---|---|---|
671579 | 671579 | 2020-10-27 | Adair | Kentucky | 21001 | 535 | 23 |
671580 | 671580 | 2020-10-27 | Allen | Kentucky | 21003 | 547 | 12 |
671581 | 671581 | 2020-10-27 | Anderson | Kentucky | 21005 | 251 | 1 |
671582 | 671582 | 2020-10-27 | Ballard | Kentucky | 21007 | 72 | 1 |
671583 | 671583 | 2020-10-27 | Barren | Kentucky | 21009 | 1211 | 13 |
671584 | 671584 | 2020-10-27 | Bath | Kentucky | 21011 | 122 | 1 |
671585 | 671585 | 2020-10-27 | Bell | Kentucky | 21013 | 679 | 17 |
671586 | 671586 | 2020-10-27 | Boone | Kentucky | 21015 | 2165 | 25 |
671587 | 671587 | 2020-10-27 | Bourbon | Kentucky | 21017 | 327 | 1 |
671588 | 671588 | 2020-10-27 | Boyd | Kentucky | 21019 | 674 | 21 |
671589 | 671589 | 2020-10-27 | Boyle | Kentucky | 21021 | 452 | 0 |
671590 | 671590 | 2020-10-27 | Bracken | Kentucky | 21023 | 71 | 1 |
671591 | 671591 | 2020-10-27 | Breathitt | Kentucky | 21025 | 130 | 0 |
671592 | 671592 | 2020-10-27 | Breckinridge | Kentucky | 21027 | 191 | 2 |
671593 | 671593 | 2020-10-27 | Bullitt | Kentucky | 21029 | 1447 | 14 |
671594 | 671594 | 2020-10-27 | Butler | Kentucky | 21031 | 434 | 16 |
671595 | 671595 | 2020-10-27 | Caldwell | Kentucky | 21033 | 255 | 0 |
671596 | 671596 | 2020-10-27 | Calloway | Kentucky | 21035 | 977 | 9 |
671597 | 671597 | 2020-10-27 | Campbell | Kentucky | 21037 | 1255 | 19 |
671598 | 671598 | 2020-10-27 | Carlisle | Kentucky | 21039 | 103 | 1 |
671599 | 671599 | 2020-10-27 | Carroll | Kentucky | 21041 | 224 | 5 |
671600 | 671600 | 2020-10-27 | Carter | Kentucky | 21043 | 343 | 4 |
671601 | 671601 | 2020-10-27 | Casey | Kentucky | 21045 | 325 | 16 |
671602 | 671602 | 2020-10-27 | Christian | Kentucky | 21047 | 1922 | 31 |
671603 | 671603 | 2020-10-27 | Clark | Kentucky | 21049 | 531 | 11 |
671604 | 671604 | 2020-10-27 | Clay | Kentucky | 21051 | 530 | 6 |
671605 | 671605 | 2020-10-27 | Clinton | Kentucky | 21053 | 257 | 4 |
671606 | 671606 | 2020-10-27 | Crittenden | Kentucky | 21055 | 164 | 1 |
671607 | 671607 | 2020-10-27 | Cumberland | Kentucky | 21057 | 158 | 0 |
671608 | 671608 | 2020-10-27 | Daviess | Kentucky | 21059 | 1974 | 29 |
671609 | 671609 | 2020-10-27 | Edmonson | Kentucky | 21061 | 202 | 12 |
671610 | 671610 | 2020-10-27 | Elliott | Kentucky | 21063 | 333 | 0 |
671611 | 671611 | 2020-10-27 | Estill | Kentucky | 21065 | 278 | 0 |
671612 | 671612 | 2020-10-27 | Fayette | Kentucky | 21067 | 10652 | 92 |
671613 | 671613 | 2020-10-27 | Fleming | Kentucky | 21069 | 179 | 0 |
671614 | 671614 | 2020-10-27 | Floyd | Kentucky | 21071 | 386 | 4 |
671615 | 671615 | 2020-10-27 | Franklin | Kentucky | 21073 | 856 | 14 |
671616 | 671616 | 2020-10-27 | Fulton | Kentucky | 21075 | 235 | 3 |
671617 | 671617 | 2020-10-27 | Gallatin | Kentucky | 21077 | 126 | 8 |
671618 | 671618 | 2020-10-27 | Garrard | Kentucky | 21079 | 322 | 4 |
671619 | 671619 | 2020-10-27 | Grant | Kentucky | 21081 | 258 | 6 |
671620 | 671620 | 2020-10-27 | Graves | Kentucky | 21083 | 885 | 30 |
671621 | 671621 | 2020-10-27 | Grayson | Kentucky | 21085 | 510 | 16 |
671622 | 671622 | 2020-10-27 | Green | Kentucky | 21087 | 349 | 9 |
671623 | 671623 | 2020-10-27 | Greenup | Kentucky | 21089 | 628 | 11 |
671624 | 671624 | 2020-10-27 | Hancock | Kentucky | 21091 | 147 | 2 |
671625 | 671625 | 2020-10-27 | Hardin | Kentucky | 21093 | 2006 | 16 |
671626 | 671626 | 2020-10-27 | Harlan | Kentucky | 21095 | 589 | 14 |
671627 | 671627 | 2020-10-27 | Harrison | Kentucky | 21097 | 265 | 1 |
671628 | 671628 | 2020-10-27 | Hart | Kentucky | 21099 | 426 | 1 |
671629 | 671629 | 2020-10-27 | Henderson | Kentucky | 21101 | 1307 | 31 |
671630 | 671630 | 2020-10-27 | Henry | Kentucky | 21103 | 280 | 2 |
671631 | 671631 | 2020-10-27 | Hickman | Kentucky | 21105 | 121 | 1 |
671632 | 671632 | 2020-10-27 | Hopkins | Kentucky | 21107 | 1044 | 44 |
671633 | 671633 | 2020-10-27 | Jackson | Kentucky | 21109 | 454 | 17 |
671634 | 671634 | 2020-10-27 | Jefferson | Kentucky | 21111 | 23459 | 389 |
671635 | 671635 | 2020-10-27 | Jessamine | Kentucky | 21113 | 975 | 11 |
671636 | 671636 | 2020-10-27 | Johnson | Kentucky | 21115 | 314 | 2 |
671637 | 671637 | 2020-10-27 | Kenton | Kentucky | 21117 | 2689 | 49 |
671638 | 671638 | 2020-10-27 | Knott | Kentucky | 21119 | 345 | 4 |
671639 | 671639 | 2020-10-27 | Knox | Kentucky | 21121 | 842 | 9 |
671640 | 671640 | 2020-10-27 | Larue | Kentucky | 21123 | 308 | 2 |
671641 | 671641 | 2020-10-27 | Laurel | Kentucky | 21125 | 1435 | 7 |
671642 | 671642 | 2020-10-27 | Lawrence | Kentucky | 21127 | 153 | 0 |
671643 | 671643 | 2020-10-27 | Lee | Kentucky | 21129 | 139 | 3 |
671644 | 671644 | 2020-10-27 | Leslie | Kentucky | 21131 | 129 | 1 |
671645 | 671645 | 2020-10-27 | Letcher | Kentucky | 21133 | 303 | 2 |
671646 | 671646 | 2020-10-27 | Lewis | Kentucky | 21135 | 287 | 16 |
671647 | 671647 | 2020-10-27 | Lincoln | Kentucky | 21137 | 327 | 19 |
671648 | 671648 | 2020-10-27 | Livingston | Kentucky | 21139 | 126 | 1 |
671649 | 671649 | 2020-10-27 | Logan | Kentucky | 21141 | 798 | 31 |
671650 | 671650 | 2020-10-27 | Lyon | Kentucky | 21143 | 106 | 4 |
671651 | 671651 | 2020-10-27 | Madison | Kentucky | 21151 | 2343 | 13 |
671652 | 671652 | 2020-10-27 | Magoffin | Kentucky | 21153 | 164 | 0 |
671653 | 671653 | 2020-10-27 | Marion | Kentucky | 21155 | 476 | 11 |
671654 | 671654 | 2020-10-27 | Marshall | Kentucky | 21157 | 472 | 7 |
671655 | 671655 | 2020-10-27 | Martin | Kentucky | 21159 | 195 | 3 |
671656 | 671656 | 2020-10-27 | Mason | Kentucky | 21161 | 171 | 2 |
671657 | 671657 | 2020-10-27 | McCracken | Kentucky | 21145 | 1130 | 12 |
671658 | 671658 | 2020-10-27 | McCreary | Kentucky | 21147 | 272 | 1 |
671659 | 671659 | 2020-10-27 | McLean | Kentucky | 21149 | 197 | 2 |
671660 | 671660 | 2020-10-27 | Meade | Kentucky | 21163 | 425 | 4 |
671661 | 671661 | 2020-10-27 | Menifee | Kentucky | 21165 | 84 | 1 |
671662 | 671662 | 2020-10-27 | Mercer | Kentucky | 21167 | 367 | 6 |
671663 | 671663 | 2020-10-27 | Metcalfe | Kentucky | 21169 | 206 | 2 |
671664 | 671664 | 2020-10-27 | Monroe | Kentucky | 21171 | 288 | 4 |
671665 | 671665 | 2020-10-27 | Montgomery | Kentucky | 21173 | 470 | 4 |
671666 | 671666 | 2020-10-27 | Morgan | Kentucky | 21175 | 129 | 0 |
671667 | 671667 | 2020-10-27 | Muhlenberg | Kentucky | 21177 | 991 | 15 |
671668 | 671668 | 2020-10-27 | Nelson | Kentucky | 21179 | 928 | 4 |
671669 | 671669 | 2020-10-27 | Nicholas | Kentucky | 21181 | 110 | 3 |
671670 | 671670 | 2020-10-27 | Ohio | Kentucky | 21183 | 609 | 10 |
671671 | 671671 | 2020-10-27 | Oldham | Kentucky | 21185 | 1423 | 26 |
671672 | 671672 | 2020-10-27 | Owen | Kentucky | 21187 | 120 | 3 |
671673 | 671673 | 2020-10-27 | Owsley | Kentucky | 21189 | 94 | 1 |
671674 | 671674 | 2020-10-27 | Pendleton | Kentucky | 21191 | 126 | 0 |
671675 | 671675 | 2020-10-27 | Perry | Kentucky | 21193 | 528 | 9 |
671676 | 671676 | 2020-10-27 | Pike | Kentucky | 21195 | 868 | 3 |
671677 | 671677 | 2020-10-27 | Powell | Kentucky | 21197 | 143 | 0 |
671678 | 671678 | 2020-10-27 | Pulaski | Kentucky | 21199 | 1029 | 13 |
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);