ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35,332 rows where state = "Kentucky" sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
fips
- 21067 322
- 21097 320
- 21111 320
- 21173 316
- 21017 314
- 21179 314
- 21049 313
- 21143 311
- 21073 310
- 21117 310
- 21227 310
- 21047 309
- 21059 309
- 21101 309
- 21199 309
- 21209 309
- 21035 308
- 21005 307
- 21151 307
- 21215 307
- 21003 306
- 21025 306
- 21093 306
- 21113 306
- 21185 306
- 21141 305
- 21145 304
- 21159 304
- 21165 304
- 21177 304
- ...
county
- Fayette 322
- Harrison 320
- Jefferson 320
- Montgomery 316
- Bourbon 314
- Nelson 314
- Clark 313
- Lyon 311
- Franklin 310
- Kenton 310
- Warren 310
- Christian 309
- Daviess 309
- Henderson 309
- Pulaski 309
- Scott 309
- Calloway 308
- Anderson 307
- Madison 307
- Spencer 307
- Allen 306
- Breathitt 306
- Hardin 306
- Jessamine 306
- Oldham 306
- Logan 305
- Martin 304
- McCracken 304
- Menifee 304
- Muhlenberg 304
- ...
state
- Kentucky · 35,332 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
950727 | 950727 | 2021-01-21 | Adair | Kentucky | 21001 | 1467 | 47 |
950728 | 950728 | 2021-01-21 | Allen | Kentucky | 21003 | 1449 | 22 |
950729 | 950729 | 2021-01-21 | Anderson | Kentucky | 21005 | 1310 | 8 |
950730 | 950730 | 2021-01-21 | Ballard | Kentucky | 21007 | 289 | 3 |
950731 | 950731 | 2021-01-21 | Barren | Kentucky | 21009 | 3184 | 36 |
950732 | 950732 | 2021-01-21 | Bath | Kentucky | 21011 | 652 | 10 |
950733 | 950733 | 2021-01-21 | Bell | Kentucky | 21013 | 2296 | 32 |
950734 | 950734 | 2021-01-21 | Boone | Kentucky | 21015 | 10455 | 49 |
950735 | 950735 | 2021-01-21 | Bourbon | Kentucky | 21017 | 1279 | 9 |
950736 | 950736 | 2021-01-21 | Boyd | Kentucky | 21019 | 3989 | 33 |
950737 | 950737 | 2021-01-21 | Boyle | Kentucky | 21021 | 2860 | 16 |
950738 | 950738 | 2021-01-21 | Bracken | Kentucky | 21023 | 406 | 3 |
950739 | 950739 | 2021-01-21 | Breathitt | Kentucky | 21025 | 787 | 3 |
950740 | 950740 | 2021-01-21 | Breckinridge | Kentucky | 21027 | 925 | 5 |
950741 | 950741 | 2021-01-21 | Bullitt | Kentucky | 21029 | 5128 | 33 |
950742 | 950742 | 2021-01-21 | Butler | Kentucky | 21031 | 1062 | 17 |
950743 | 950743 | 2021-01-21 | Caldwell | Kentucky | 21033 | 1088 | 19 |
950744 | 950744 | 2021-01-21 | Calloway | Kentucky | 21035 | 2974 | 31 |
950745 | 950745 | 2021-01-21 | Campbell | Kentucky | 21037 | 6424 | 39 |
950746 | 950746 | 2021-01-21 | Carlisle | Kentucky | 21039 | 400 | 1 |
950747 | 950747 | 2021-01-21 | Carroll | Kentucky | 21041 | 764 | 9 |
950748 | 950748 | 2021-01-21 | Carter | Kentucky | 21043 | 1705 | 19 |
950749 | 950749 | 2021-01-21 | Casey | Kentucky | 21045 | 1054 | 30 |
950750 | 950750 | 2021-01-21 | Christian | Kentucky | 21047 | 5440 | 74 |
950751 | 950751 | 2021-01-21 | Clark | Kentucky | 21049 | 1996 | 16 |
950752 | 950752 | 2021-01-21 | Clay | Kentucky | 21051 | 2099 | 16 |
950753 | 950753 | 2021-01-21 | Clinton | Kentucky | 21053 | 1218 | 23 |
950754 | 950754 | 2021-01-21 | Crittenden | Kentucky | 21055 | 485 | 6 |
950755 | 950755 | 2021-01-21 | Cumberland | Kentucky | 21057 | 571 | 8 |
950756 | 950756 | 2021-01-21 | Daviess | Kentucky | 21059 | 7731 | 124 |
950757 | 950757 | 2021-01-21 | Edmonson | Kentucky | 21061 | 686 | 13 |
950758 | 950758 | 2021-01-21 | Elliott | Kentucky | 21063 | 885 | 1 |
950759 | 950759 | 2021-01-21 | Estill | Kentucky | 21065 | 834 | 0 |
950760 | 950760 | 2021-01-21 | Fayette | Kentucky | 21067 | 27881 | 179 |
950761 | 950761 | 2021-01-21 | Fleming | Kentucky | 21069 | 909 | 8 |
950762 | 950762 | 2021-01-21 | Floyd | Kentucky | 21071 | 2417 | 18 |
950763 | 950763 | 2021-01-21 | Franklin | Kentucky | 21073 | 2732 | 24 |
950764 | 950764 | 2021-01-21 | Fulton | Kentucky | 21075 | 419 | 4 |
950765 | 950765 | 2021-01-21 | Gallatin | Kentucky | 21077 | 544 | 16 |
950766 | 950766 | 2021-01-21 | Garrard | Kentucky | 21079 | 1183 | 4 |
950767 | 950767 | 2021-01-21 | Grant | Kentucky | 21081 | 1663 | 10 |
950768 | 950768 | 2021-01-21 | Graves | Kentucky | 21083 | 3459 | 56 |
950769 | 950769 | 2021-01-21 | Grayson | Kentucky | 21085 | 1610 | 38 |
950770 | 950770 | 2021-01-21 | Green | Kentucky | 21087 | 940 | 13 |
950771 | 950771 | 2021-01-21 | Greenup | Kentucky | 21089 | 2882 | 21 |
950772 | 950772 | 2021-01-21 | Hancock | Kentucky | 21091 | 667 | 14 |
950773 | 950773 | 2021-01-21 | Hardin | Kentucky | 21093 | 7484 | 56 |
950774 | 950774 | 2021-01-21 | Harlan | Kentucky | 21095 | 2046 | 35 |
950775 | 950775 | 2021-01-21 | Harrison | Kentucky | 21097 | 1210 | 2 |
950776 | 950776 | 2021-01-21 | Hart | Kentucky | 21099 | 1489 | 14 |
950777 | 950777 | 2021-01-21 | Henderson | Kentucky | 21101 | 3765 | 52 |
950778 | 950778 | 2021-01-21 | Henry | Kentucky | 21103 | 998 | 5 |
950779 | 950779 | 2021-01-21 | Hickman | Kentucky | 21105 | 260 | 7 |
950780 | 950780 | 2021-01-21 | Hopkins | Kentucky | 21107 | 3374 | 115 |
950781 | 950781 | 2021-01-21 | Jackson | Kentucky | 21109 | 1069 | 23 |
950782 | 950782 | 2021-01-21 | Jefferson | Kentucky | 21111 | 63192 | 754 |
950783 | 950783 | 2021-01-21 | Jessamine | Kentucky | 21113 | 3326 | 48 |
950784 | 950784 | 2021-01-21 | Johnson | Kentucky | 21115 | 1454 | 16 |
950785 | 950785 | 2021-01-21 | Kenton | Kentucky | 21117 | 12256 | 91 |
950786 | 950786 | 2021-01-21 | Knott | Kentucky | 21119 | 863 | 14 |
950787 | 950787 | 2021-01-21 | Knox | Kentucky | 21121 | 2357 | 10 |
950788 | 950788 | 2021-01-21 | Larue | Kentucky | 21123 | 990 | 6 |
950789 | 950789 | 2021-01-21 | Laurel | Kentucky | 21125 | 4820 | 17 |
950790 | 950790 | 2021-01-21 | Lawrence | Kentucky | 21127 | 1021 | 5 |
950791 | 950791 | 2021-01-21 | Lee | Kentucky | 21129 | 1113 | 18 |
950792 | 950792 | 2021-01-21 | Leslie | Kentucky | 21131 | 643 | 2 |
950793 | 950793 | 2021-01-21 | Letcher | Kentucky | 21133 | 1400 | 5 |
950794 | 950794 | 2021-01-21 | Lewis | Kentucky | 21135 | 945 | 29 |
950795 | 950795 | 2021-01-21 | Lincoln | Kentucky | 21137 | 1774 | 29 |
950796 | 950796 | 2021-01-21 | Livingston | Kentucky | 21139 | 593 | 15 |
950797 | 950797 | 2021-01-21 | Logan | Kentucky | 21141 | 2057 | 44 |
950798 | 950798 | 2021-01-21 | Lyon | Kentucky | 21143 | 390 | 11 |
950799 | 950799 | 2021-01-21 | Madison | Kentucky | 21151 | 7142 | 48 |
950800 | 950800 | 2021-01-21 | Magoffin | Kentucky | 21153 | 782 | 1 |
950801 | 950801 | 2021-01-21 | Marion | Kentucky | 21155 | 1794 | 20 |
950802 | 950802 | 2021-01-21 | Marshall | Kentucky | 21157 | 2039 | 32 |
950803 | 950803 | 2021-01-21 | Martin | Kentucky | 21159 | 794 | 11 |
950804 | 950804 | 2021-01-21 | Mason | Kentucky | 21161 | 1159 | 24 |
950805 | 950805 | 2021-01-21 | McCracken | Kentucky | 21145 | 5018 | 48 |
950806 | 950806 | 2021-01-21 | McCreary | Kentucky | 21147 | 1390 | 18 |
950807 | 950807 | 2021-01-21 | McLean | Kentucky | 21149 | 709 | 24 |
950808 | 950808 | 2021-01-21 | Meade | Kentucky | 21163 | 1501 | 5 |
950809 | 950809 | 2021-01-21 | Menifee | Kentucky | 21165 | 284 | 3 |
950810 | 950810 | 2021-01-21 | Mercer | Kentucky | 21167 | 2018 | 11 |
950811 | 950811 | 2021-01-21 | Metcalfe | Kentucky | 21169 | 722 | 12 |
950812 | 950812 | 2021-01-21 | Monroe | Kentucky | 21171 | 1107 | 33 |
950813 | 950813 | 2021-01-21 | Montgomery | Kentucky | 21173 | 1851 | 16 |
950814 | 950814 | 2021-01-21 | Morgan | Kentucky | 21175 | 1734 | 0 |
950815 | 950815 | 2021-01-21 | Muhlenberg | Kentucky | 21177 | 2434 | 47 |
950816 | 950816 | 2021-01-21 | Nelson | Kentucky | 21179 | 3746 | 23 |
950817 | 950817 | 2021-01-21 | Nicholas | Kentucky | 21181 | 397 | 5 |
950818 | 950818 | 2021-01-21 | Ohio | Kentucky | 21183 | 1996 | 36 |
950819 | 950819 | 2021-01-21 | Oldham | Kentucky | 21185 | 6028 | 55 |
950820 | 950820 | 2021-01-21 | Owen | Kentucky | 21187 | 515 | 7 |
950821 | 950821 | 2021-01-21 | Owsley | Kentucky | 21189 | 362 | 10 |
950822 | 950822 | 2021-01-21 | Pendleton | Kentucky | 21191 | 772 | 1 |
950823 | 950823 | 2021-01-21 | Perry | Kentucky | 21193 | 1896 | 17 |
950824 | 950824 | 2021-01-21 | Pike | Kentucky | 21195 | 4064 | 38 |
950825 | 950825 | 2021-01-21 | Powell | Kentucky | 21197 | 833 | 0 |
950826 | 950826 | 2021-01-21 | Pulaski | Kentucky | 21199 | 4869 | 72 |
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]);