ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2020-11-21" 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 |
---|---|---|---|---|---|---|---|
752679 | 752679 | 2020-11-21 | Adair | Kentucky | 21001 | 873 | 29 |
752680 | 752680 | 2020-11-21 | Allen | Kentucky | 21003 | 660 | 15 |
752681 | 752681 | 2020-11-21 | Anderson | Kentucky | 21005 | 444 | 1 |
752682 | 752682 | 2020-11-21 | Ballard | Kentucky | 21007 | 128 | 2 |
752683 | 752683 | 2020-11-21 | Barren | Kentucky | 21009 | 1822 | 25 |
752684 | 752684 | 2020-11-21 | Bath | Kentucky | 21011 | 231 | 1 |
752685 | 752685 | 2020-11-21 | Bell | Kentucky | 21013 | 1150 | 18 |
752686 | 752686 | 2020-11-21 | Boone | Kentucky | 21015 | 3888 | 28 |
752687 | 752687 | 2020-11-21 | Bourbon | Kentucky | 21017 | 490 | 1 |
752688 | 752688 | 2020-11-21 | Boyd | Kentucky | 21019 | 1458 | 24 |
752689 | 752689 | 2020-11-21 | Boyle | Kentucky | 21021 | 798 | 0 |
752690 | 752690 | 2020-11-21 | Bracken | Kentucky | 21023 | 121 | 3 |
752691 | 752691 | 2020-11-21 | Breathitt | Kentucky | 21025 | 292 | 3 |
752692 | 752692 | 2020-11-21 | Breckinridge | Kentucky | 21027 | 412 | 4 |
752693 | 752693 | 2020-11-21 | Bullitt | Kentucky | 21029 | 2509 | 22 |
752694 | 752694 | 2020-11-21 | Butler | Kentucky | 21031 | 517 | 16 |
752695 | 752695 | 2020-11-21 | Caldwell | Kentucky | 21033 | 484 | 1 |
752696 | 752696 | 2020-11-21 | Calloway | Kentucky | 21035 | 1522 | 13 |
752697 | 752697 | 2020-11-21 | Campbell | Kentucky | 21037 | 2461 | 21 |
752698 | 752698 | 2020-11-21 | Carlisle | Kentucky | 21039 | 178 | 1 |
752699 | 752699 | 2020-11-21 | Carroll | Kentucky | 21041 | 298 | 6 |
752700 | 752700 | 2020-11-21 | Carter | Kentucky | 21043 | 609 | 5 |
752701 | 752701 | 2020-11-21 | Casey | Kentucky | 21045 | 562 | 19 |
752702 | 752702 | 2020-11-21 | Christian | Kentucky | 21047 | 2690 | 39 |
752703 | 752703 | 2020-11-21 | Clark | Kentucky | 21049 | 801 | 12 |
752704 | 752704 | 2020-11-21 | Clay | Kentucky | 21051 | 920 | 8 |
752705 | 752705 | 2020-11-21 | Clinton | Kentucky | 21053 | 438 | 11 |
752706 | 752706 | 2020-11-21 | Crittenden | Kentucky | 21055 | 217 | 1 |
752707 | 752707 | 2020-11-21 | Cumberland | Kentucky | 21057 | 274 | 0 |
752708 | 752708 | 2020-11-21 | Daviess | Kentucky | 21059 | 3046 | 41 |
752709 | 752709 | 2020-11-21 | Edmonson | Kentucky | 21061 | 342 | 12 |
752710 | 752710 | 2020-11-21 | Elliott | Kentucky | 21063 | 560 | 0 |
752711 | 752711 | 2020-11-21 | Estill | Kentucky | 21065 | 409 | 0 |
752712 | 752712 | 2020-11-21 | Fayette | Kentucky | 21067 | 15241 | 112 |
752713 | 752713 | 2020-11-21 | Fleming | Kentucky | 21069 | 292 | 0 |
752714 | 752714 | 2020-11-21 | Floyd | Kentucky | 21071 | 1025 | 5 |
752715 | 752715 | 2020-11-21 | Franklin | Kentucky | 21073 | 1242 | 14 |
752716 | 752716 | 2020-11-21 | Fulton | Kentucky | 21075 | 276 | 3 |
752717 | 752717 | 2020-11-21 | Gallatin | Kentucky | 21077 | 181 | 9 |
752718 | 752718 | 2020-11-21 | Garrard | Kentucky | 21079 | 498 | 4 |
752719 | 752719 | 2020-11-21 | Grant | Kentucky | 21081 | 540 | 6 |
752720 | 752720 | 2020-11-21 | Graves | Kentucky | 21083 | 1553 | 34 |
752721 | 752721 | 2020-11-21 | Grayson | Kentucky | 21085 | 831 | 19 |
752722 | 752722 | 2020-11-21 | Green | Kentucky | 21087 | 543 | 10 |
752723 | 752723 | 2020-11-21 | Greenup | Kentucky | 21089 | 1091 | 12 |
752724 | 752724 | 2020-11-21 | Hancock | Kentucky | 21091 | 276 | 10 |
752725 | 752725 | 2020-11-21 | Hardin | Kentucky | 21093 | 3727 | 32 |
752726 | 752726 | 2020-11-21 | Harlan | Kentucky | 21095 | 807 | 15 |
752727 | 752727 | 2020-11-21 | Harrison | Kentucky | 21097 | 404 | 1 |
752728 | 752728 | 2020-11-21 | Hart | Kentucky | 21099 | 697 | 3 |
752729 | 752729 | 2020-11-21 | Henderson | Kentucky | 21101 | 1864 | 37 |
752730 | 752730 | 2020-11-21 | Henry | Kentucky | 21103 | 449 | 3 |
752731 | 752731 | 2020-11-21 | Hickman | Kentucky | 21105 | 141 | 1 |
752732 | 752732 | 2020-11-21 | Hopkins | Kentucky | 21107 | 1628 | 47 |
752733 | 752733 | 2020-11-21 | Jackson | Kentucky | 21109 | 621 | 18 |
752734 | 752734 | 2020-11-21 | Jefferson | Kentucky | 21111 | 33989 | 470 |
752735 | 752735 | 2020-11-21 | Jessamine | Kentucky | 21113 | 1546 | 29 |
752736 | 752736 | 2020-11-21 | Johnson | Kentucky | 21115 | 653 | 3 |
752737 | 752737 | 2020-11-21 | Kenton | Kentucky | 21117 | 4662 | 62 |
752738 | 752738 | 2020-11-21 | Knott | Kentucky | 21119 | 510 | 9 |
752739 | 752739 | 2020-11-21 | Knox | Kentucky | 21121 | 1132 | 10 |
752740 | 752740 | 2020-11-21 | Larue | Kentucky | 21123 | 552 | 2 |
752741 | 752741 | 2020-11-21 | Laurel | Kentucky | 21125 | 2227 | 11 |
752742 | 752742 | 2020-11-21 | Lawrence | Kentucky | 21127 | 339 | 1 |
752743 | 752743 | 2020-11-21 | Lee | Kentucky | 21129 | 846 | 13 |
752744 | 752744 | 2020-11-21 | Leslie | Kentucky | 21131 | 199 | 1 |
752745 | 752745 | 2020-11-21 | Letcher | Kentucky | 21133 | 463 | 2 |
752746 | 752746 | 2020-11-21 | Lewis | Kentucky | 21135 | 448 | 19 |
752747 | 752747 | 2020-11-21 | Lincoln | Kentucky | 21137 | 550 | 20 |
752748 | 752748 | 2020-11-21 | Livingston | Kentucky | 21139 | 244 | 2 |
752749 | 752749 | 2020-11-21 | Logan | Kentucky | 21141 | 1135 | 33 |
752750 | 752750 | 2020-11-21 | Lyon | Kentucky | 21143 | 176 | 5 |
752751 | 752751 | 2020-11-21 | Madison | Kentucky | 21151 | 3334 | 18 |
752752 | 752752 | 2020-11-21 | Magoffin | Kentucky | 21153 | 371 | 1 |
752753 | 752753 | 2020-11-21 | Marion | Kentucky | 21155 | 866 | 12 |
752754 | 752754 | 2020-11-21 | Marshall | Kentucky | 21157 | 840 | 11 |
752755 | 752755 | 2020-11-21 | Martin | Kentucky | 21159 | 364 | 5 |
752756 | 752756 | 2020-11-21 | Mason | Kentucky | 21161 | 341 | 2 |
752757 | 752757 | 2020-11-21 | McCracken | Kentucky | 21145 | 2268 | 16 |
752758 | 752758 | 2020-11-21 | McCreary | Kentucky | 21147 | 418 | 1 |
752759 | 752759 | 2020-11-21 | McLean | Kentucky | 21149 | 353 | 12 |
752760 | 752760 | 2020-11-21 | Meade | Kentucky | 21163 | 687 | 4 |
752761 | 752761 | 2020-11-21 | Menifee | Kentucky | 21165 | 113 | 1 |
752762 | 752762 | 2020-11-21 | Mercer | Kentucky | 21167 | 586 | 6 |
752763 | 752763 | 2020-11-21 | Metcalfe | Kentucky | 21169 | 348 | 2 |
752764 | 752764 | 2020-11-21 | Monroe | Kentucky | 21171 | 655 | 9 |
752765 | 752765 | 2020-11-21 | Montgomery | Kentucky | 21173 | 805 | 8 |
752766 | 752766 | 2020-11-21 | Morgan | Kentucky | 21175 | 268 | 0 |
752767 | 752767 | 2020-11-21 | Muhlenberg | Kentucky | 21177 | 1301 | 20 |
752768 | 752768 | 2020-11-21 | Nelson | Kentucky | 21179 | 1908 | 8 |
752769 | 752769 | 2020-11-21 | Nicholas | Kentucky | 21181 | 153 | 3 |
752770 | 752770 | 2020-11-21 | Ohio | Kentucky | 21183 | 845 | 14 |
752771 | 752771 | 2020-11-21 | Oldham | Kentucky | 21185 | 2139 | 30 |
752772 | 752772 | 2020-11-21 | Owen | Kentucky | 21187 | 173 | 3 |
752773 | 752773 | 2020-11-21 | Owsley | Kentucky | 21189 | 178 | 1 |
752774 | 752774 | 2020-11-21 | Pendleton | Kentucky | 21191 | 297 | 1 |
752775 | 752775 | 2020-11-21 | Perry | Kentucky | 21193 | 867 | 10 |
752776 | 752776 | 2020-11-21 | Pike | Kentucky | 21195 | 1628 | 17 |
752777 | 752777 | 2020-11-21 | Powell | Kentucky | 21197 | 415 | 0 |
752778 | 752778 | 2020-11-21 | Pulaski | Kentucky | 21199 | 1836 | 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);