ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2021-08-24" 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 |
---|---|---|---|---|---|---|---|
1648681 | 1648681 | 2021-08-24 | Adair | Kentucky | 21001 | 2370 | 58 |
1648682 | 1648682 | 2021-08-24 | Allen | Kentucky | 21003 | 2645 | 48 |
1648683 | 1648683 | 2021-08-24 | Anderson | Kentucky | 21005 | 2147 | 25 |
1648684 | 1648684 | 2021-08-24 | Ballard | Kentucky | 21007 | 506 | 11 |
1648685 | 1648685 | 2021-08-24 | Barren | Kentucky | 21009 | 5532 | 109 |
1648686 | 1648686 | 2021-08-24 | Bath | Kentucky | 21011 | 1194 | 24 |
1648687 | 1648687 | 2021-08-24 | Bell | Kentucky | 21013 | 3948 | 61 |
1648688 | 1648688 | 2021-08-24 | Boone | Kentucky | 21015 | 16453 | 169 |
1648689 | 1648689 | 2021-08-24 | Bourbon | Kentucky | 21017 | 2120 | 20 |
1648690 | 1648690 | 2021-08-24 | Boyd | Kentucky | 21019 | 6063 | 82 |
1648691 | 1648691 | 2021-08-24 | Boyle | Kentucky | 21021 | 4025 | 80 |
1648692 | 1648692 | 2021-08-24 | Bracken | Kentucky | 21023 | 797 | 8 |
1648693 | 1648693 | 2021-08-24 | Breathitt | Kentucky | 21025 | 1260 | 12 |
1648694 | 1648694 | 2021-08-24 | Breckinridge | Kentucky | 21027 | 1739 | 19 |
1648695 | 1648695 | 2021-08-24 | Bullitt | Kentucky | 21029 | 8770 | 88 |
1648696 | 1648696 | 2021-08-24 | Butler | Kentucky | 21031 | 1694 | 28 |
1648697 | 1648697 | 2021-08-24 | Caldwell | Kentucky | 21033 | 1706 | 33 |
1648698 | 1648698 | 2021-08-24 | Calloway | Kentucky | 21035 | 4206 | 53 |
1648699 | 1648699 | 2021-08-24 | Campbell | Kentucky | 21037 | 9924 | 86 |
1648700 | 1648700 | 2021-08-24 | Carlisle | Kentucky | 21039 | 545 | 10 |
1648701 | 1648701 | 2021-08-24 | Carroll | Kentucky | 21041 | 1267 | 21 |
1648702 | 1648702 | 2021-08-24 | Carter | Kentucky | 21043 | 3089 | 39 |
1648703 | 1648703 | 2021-08-24 | Casey | Kentucky | 21045 | 1863 | 43 |
1648704 | 1648704 | 2021-08-24 | Christian | Kentucky | 21047 | 7838 | 108 |
1648705 | 1648705 | 2021-08-24 | Clark | Kentucky | 21049 | 3702 | 32 |
1648706 | 1648706 | 2021-08-24 | Clay | Kentucky | 21051 | 3834 | 46 |
1648707 | 1648707 | 2021-08-24 | Clinton | Kentucky | 21053 | 1593 | 33 |
1648708 | 1648708 | 2021-08-24 | Crittenden | Kentucky | 21055 | 820 | 27 |
1648709 | 1648709 | 2021-08-24 | Cumberland | Kentucky | 21057 | 778 | 14 |
1648710 | 1648710 | 2021-08-24 | Daviess | Kentucky | 21059 | 13216 | 207 |
1648711 | 1648711 | 2021-08-24 | Edmonson | Kentucky | 21061 | 1055 | 25 |
1648712 | 1648712 | 2021-08-24 | Elliott | Kentucky | 21063 | 1112 | 2 |
1648713 | 1648713 | 2021-08-24 | Estill | Kentucky | 21065 | 1447 | 12 |
1648714 | 1648714 | 2021-08-24 | Fayette | Kentucky | 21067 | 41361 | 326 |
1648715 | 1648715 | 2021-08-24 | Fleming | Kentucky | 21069 | 1543 | 26 |
1648716 | 1648716 | 2021-08-24 | Floyd | Kentucky | 21071 | 4752 | 75 |
1648717 | 1648717 | 2021-08-24 | Franklin | Kentucky | 21073 | 5038 | 62 |
1648718 | 1648718 | 2021-08-24 | Fulton | Kentucky | 21075 | 583 | 16 |
1648719 | 1648719 | 2021-08-24 | Gallatin | Kentucky | 21077 | 884 | 34 |
1648720 | 1648720 | 2021-08-24 | Garrard | Kentucky | 21079 | 1839 | 37 |
1648721 | 1648721 | 2021-08-24 | Grant | Kentucky | 21081 | 3047 | 25 |
1648722 | 1648722 | 2021-08-24 | Graves | Kentucky | 21083 | 5365 | 105 |
1648723 | 1648723 | 2021-08-24 | Grayson | Kentucky | 21085 | 2852 | 59 |
1648724 | 1648724 | 2021-08-24 | Green | Kentucky | 21087 | 1553 | 18 |
1648725 | 1648725 | 2021-08-24 | Greenup | Kentucky | 21089 | 4414 | 64 |
1648726 | 1648726 | 2021-08-24 | Hancock | Kentucky | 21091 | 1056 | 16 |
1648727 | 1648727 | 2021-08-24 | Hardin | Kentucky | 21093 | 12558 | 175 |
1648728 | 1648728 | 2021-08-24 | Harlan | Kentucky | 21095 | 3437 | 95 |
1648729 | 1648729 | 2021-08-24 | Harrison | Kentucky | 21097 | 2127 | 27 |
1648730 | 1648730 | 2021-08-24 | Hart | Kentucky | 21099 | 2533 | 55 |
1648731 | 1648731 | 2021-08-24 | Henderson | Kentucky | 21101 | 6184 | 83 |
1648732 | 1648732 | 2021-08-24 | Henry | Kentucky | 21103 | 1783 | 21 |
1648733 | 1648733 | 2021-08-24 | Hickman | Kentucky | 21105 | 431 | 16 |
1648734 | 1648734 | 2021-08-24 | Hopkins | Kentucky | 21107 | 5844 | 157 |
1648735 | 1648735 | 2021-08-24 | Jackson | Kentucky | 21109 | 1814 | 32 |
1648736 | 1648736 | 2021-08-24 | Jefferson | Kentucky | 21111 | 93702 | 1386 |
1648737 | 1648737 | 2021-08-24 | Jessamine | Kentucky | 21113 | 5652 | 76 |
1648738 | 1648738 | 2021-08-24 | Johnson | Kentucky | 21115 | 2631 | 38 |
1648739 | 1648739 | 2021-08-24 | Kenton | Kentucky | 21117 | 19076 | 223 |
1648740 | 1648740 | 2021-08-24 | Knott | Kentucky | 21119 | 1530 | 25 |
1648741 | 1648741 | 2021-08-24 | Knox | Kentucky | 21121 | 4739 | 49 |
1648742 | 1648742 | 2021-08-24 | Larue | Kentucky | 21123 | 1722 | 29 |
1648743 | 1648743 | 2021-08-24 | Laurel | Kentucky | 21125 | 9919 | 87 |
1648744 | 1648744 | 2021-08-24 | Lawrence | Kentucky | 21127 | 1736 | 30 |
1648745 | 1648745 | 2021-08-24 | Lee | Kentucky | 21129 | 1421 | 26 |
1648746 | 1648746 | 2021-08-24 | Leslie | Kentucky | 21131 | 1265 | 9 |
1648747 | 1648747 | 2021-08-24 | Letcher | Kentucky | 21133 | 2552 | 51 |
1648748 | 1648748 | 2021-08-24 | Lewis | Kentucky | 21135 | 1719 | 45 |
1648749 | 1648749 | 2021-08-24 | Lincoln | Kentucky | 21137 | 2941 | 63 |
1648750 | 1648750 | 2021-08-24 | Livingston | Kentucky | 21139 | 1051 | 27 |
1648751 | 1648751 | 2021-08-24 | Logan | Kentucky | 21141 | 3729 | 75 |
1648752 | 1648752 | 2021-08-24 | Lyon | Kentucky | 21143 | 1678 | 22 |
1648753 | 1648753 | 2021-08-24 | Madison | Kentucky | 21151 | 11140 | 115 |
1648754 | 1648754 | 2021-08-24 | Magoffin | Kentucky | 21153 | 1403 | 18 |
1648755 | 1648755 | 2021-08-24 | Marion | Kentucky | 21155 | 2801 | 39 |
1648756 | 1648756 | 2021-08-24 | Marshall | Kentucky | 21157 | 3839 | 66 |
1648757 | 1648757 | 2021-08-24 | Martin | Kentucky | 21159 | 1237 | 22 |
1648758 | 1648758 | 2021-08-24 | Mason | Kentucky | 21161 | 2007 | 41 |
1648759 | 1648759 | 2021-08-24 | McCracken | Kentucky | 21145 | 8138 | 138 |
1648760 | 1648760 | 2021-08-24 | McCreary | Kentucky | 21147 | 2353 | 34 |
1648761 | 1648761 | 2021-08-24 | McLean | Kentucky | 21149 | 1094 | 29 |
1648762 | 1648762 | 2021-08-24 | Meade | Kentucky | 21163 | 2522 | 27 |
1648763 | 1648763 | 2021-08-24 | Menifee | Kentucky | 21165 | 606 | 17 |
1648764 | 1648764 | 2021-08-24 | Mercer | Kentucky | 21167 | 3150 | 54 |
1648765 | 1648765 | 2021-08-24 | Metcalfe | Kentucky | 21169 | 1317 | 31 |
1648766 | 1648766 | 2021-08-24 | Monroe | Kentucky | 21171 | 1559 | 46 |
1648767 | 1648767 | 2021-08-24 | Montgomery | Kentucky | 21173 | 3499 | 32 |
1648768 | 1648768 | 2021-08-24 | Morgan | Kentucky | 21175 | 2491 | 5 |
1648769 | 1648769 | 2021-08-24 | Muhlenberg | Kentucky | 21177 | 3987 | 76 |
1648770 | 1648770 | 2021-08-24 | Nelson | Kentucky | 21179 | 6123 | 64 |
1648771 | 1648771 | 2021-08-24 | Nicholas | Kentucky | 21181 | 701 | 9 |
1648772 | 1648772 | 2021-08-24 | Ohio | Kentucky | 21183 | 3114 | 58 |
1648773 | 1648773 | 2021-08-24 | Oldham | Kentucky | 21185 | 8521 | 86 |
1648774 | 1648774 | 2021-08-24 | Owen | Kentucky | 21187 | 962 | 13 |
1648775 | 1648775 | 2021-08-24 | Owsley | Kentucky | 21189 | 603 | 16 |
1648776 | 1648776 | 2021-08-24 | Pendleton | Kentucky | 21191 | 1314 | 5 |
1648777 | 1648777 | 2021-08-24 | Perry | Kentucky | 21193 | 3610 | 69 |
1648778 | 1648778 | 2021-08-24 | Pike | Kentucky | 21195 | 7399 | 116 |
1648779 | 1648779 | 2021-08-24 | Powell | Kentucky | 21197 | 1579 | 14 |
1648780 | 1648780 | 2021-08-24 | Pulaski | Kentucky | 21199 | 7832 | 138 |
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);