ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92,572 rows where state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 21067 558
- 21097 556
- 21111 556
- 21173 552
- 21017 550
- 21179 550
- 21049 549
- 21143 547
- 21073 546
- 21117 546
- 21227 546
- 21047 545
- 21059 545
- 21101 545
- 21199 545
- 21209 545
- 21035 544
- 21005 543
- 21151 543
- 21215 543
- 21003 542
- 21025 542
- 21093 542
- 21113 542
- 21185 542
- 21141 541
- 21145 540
- 21159 540
- 21165 540
- 21177 540
- …
county >30
- Fayette 558
- Harrison 556
- Jefferson 556
- Montgomery 552
- Bourbon 550
- Nelson 550
- Clark 549
- Lyon 547
- Franklin 546
- Kenton 546
- Warren 546
- Christian 545
- Daviess 545
- Henderson 545
- Pulaski 545
- Scott 545
- Calloway 544
- Anderson 543
- Madison 543
- Spencer 543
- Allen 542
- Breathitt 542
- Hardin 542
- Jessamine 542
- Oldham 542
- Logan 541
- Martin 540
- McCracken 540
- Menifee 540
- Muhlenberg 540
- …
state 1
- Kentucky · 63,652 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716894 | 1716894 | 2021-09-14 | Adair | Kentucky | 21001 | 2830 | 63 |
1716895 | 1716895 | 2021-09-14 | Allen | Kentucky | 21003 | 3257 | 58 |
1716896 | 1716896 | 2021-09-14 | Anderson | Kentucky | 21005 | 2543 | 31 |
1716897 | 1716897 | 2021-09-14 | Ballard | Kentucky | 21007 | 582 | 12 |
1716898 | 1716898 | 2021-09-14 | Barren | Kentucky | 21009 | 6684 | 111 |
1716899 | 1716899 | 2021-09-14 | Bath | Kentucky | 21011 | 1366 | 24 |
1716900 | 1716900 | 2021-09-14 | Bell | Kentucky | 21013 | 5062 | 71 |
1716901 | 1716901 | 2021-09-14 | Boone | Kentucky | 21015 | 18202 | 182 |
1716902 | 1716902 | 2021-09-14 | Bourbon | Kentucky | 21017 | 2638 | 22 |
1716903 | 1716903 | 2021-09-14 | Boyd | Kentucky | 21019 | 7116 | 86 |
1716904 | 1716904 | 2021-09-14 | Boyle | Kentucky | 21021 | 4725 | 80 |
1716905 | 1716905 | 2021-09-14 | Bracken | Kentucky | 21023 | 915 | 8 |
1716906 | 1716906 | 2021-09-14 | Breathitt | Kentucky | 21025 | 1684 | 14 |
1716907 | 1716907 | 2021-09-14 | Breckinridge | Kentucky | 21027 | 2298 | 20 |
1716908 | 1716908 | 2021-09-14 | Bullitt | Kentucky | 21029 | 10402 | 98 |
1716909 | 1716909 | 2021-09-14 | Butler | Kentucky | 21031 | 2018 | 29 |
1716910 | 1716910 | 2021-09-14 | Caldwell | Kentucky | 21033 | 1882 | 37 |
1716911 | 1716911 | 2021-09-14 | Calloway | Kentucky | 21035 | 4719 | 56 |
1716912 | 1716912 | 2021-09-14 | Campbell | Kentucky | 21037 | 11390 | 92 |
1716913 | 1716913 | 2021-09-14 | Carlisle | Kentucky | 21039 | 577 | 10 |
1716914 | 1716914 | 2021-09-14 | Carroll | Kentucky | 21041 | 1579 | 21 |
1716915 | 1716915 | 2021-09-14 | Carter | Kentucky | 21043 | 3916 | 47 |
1716916 | 1716916 | 2021-09-14 | Casey | Kentucky | 21045 | 2379 | 50 |
1716917 | 1716917 | 2021-09-14 | Christian | Kentucky | 21047 | 8734 | 115 |
1716918 | 1716918 | 2021-09-14 | Clark | Kentucky | 21049 | 4344 | 32 |
1716919 | 1716919 | 2021-09-14 | Clay | Kentucky | 21051 | 4688 | 52 |
1716920 | 1716920 | 2021-09-14 | Clinton | Kentucky | 21053 | 1896 | 33 |
1716921 | 1716921 | 2021-09-14 | Crittenden | Kentucky | 21055 | 921 | 28 |
1716922 | 1716922 | 2021-09-14 | Cumberland | Kentucky | 21057 | 975 | 15 |
1716923 | 1716923 | 2021-09-14 | Daviess | Kentucky | 21059 | 14918 | 224 |
1716924 | 1716924 | 2021-09-14 | Edmonson | Kentucky | 21061 | 1282 | 26 |
1716925 | 1716925 | 2021-09-14 | Elliott | Kentucky | 21063 | 1208 | 2 |
1716926 | 1716926 | 2021-09-14 | Estill | Kentucky | 21065 | 1800 | 12 |
1716927 | 1716927 | 2021-09-14 | Fayette | Kentucky | 21067 | 46119 | 345 |
1716928 | 1716928 | 2021-09-14 | Fleming | Kentucky | 21069 | 1799 | 26 |
1716929 | 1716929 | 2021-09-14 | Floyd | Kentucky | 21071 | 5897 | 87 |
1716930 | 1716930 | 2021-09-14 | Franklin | Kentucky | 21073 | 5955 | 66 |
1716931 | 1716931 | 2021-09-14 | Fulton | Kentucky | 21075 | 660 | 16 |
1716932 | 1716932 | 2021-09-14 | Gallatin | Kentucky | 21077 | 1047 | 35 |
1716933 | 1716933 | 2021-09-14 | Garrard | Kentucky | 21079 | 2244 | 39 |
1716934 | 1716934 | 2021-09-14 | Grant | Kentucky | 21081 | 3557 | 29 |
1716935 | 1716935 | 2021-09-14 | Graves | Kentucky | 21083 | 6511 | 112 |
1716936 | 1716936 | 2021-09-14 | Grayson | Kentucky | 21085 | 3751 | 66 |
1716937 | 1716937 | 2021-09-14 | Green | Kentucky | 21087 | 1897 | 23 |
1716938 | 1716938 | 2021-09-14 | Greenup | Kentucky | 21089 | 5301 | 67 |
1716939 | 1716939 | 2021-09-14 | Hancock | Kentucky | 21091 | 1234 | 16 |
1716940 | 1716940 | 2021-09-14 | Hardin | Kentucky | 21093 | 15297 | 204 |
1716941 | 1716941 | 2021-09-14 | Harlan | Kentucky | 21095 | 4241 | 101 |
1716942 | 1716942 | 2021-09-14 | Harrison | Kentucky | 21097 | 2610 | 28 |
1716943 | 1716943 | 2021-09-14 | Hart | Kentucky | 21099 | 3001 | 56 |
1716944 | 1716944 | 2021-09-14 | Henderson | Kentucky | 21101 | 7142 | 88 |
1716945 | 1716945 | 2021-09-14 | Henry | Kentucky | 21103 | 2167 | 21 |
1716946 | 1716946 | 2021-09-14 | Hickman | Kentucky | 21105 | 500 | 16 |
1716947 | 1716947 | 2021-09-14 | Hopkins | Kentucky | 21107 | 6809 | 174 |
1716948 | 1716948 | 2021-09-14 | Jackson | Kentucky | 21109 | 2178 | 42 |
1716949 | 1716949 | 2021-09-14 | Jefferson | Kentucky | 21111 | 104393 | 1442 |
1716950 | 1716950 | 2021-09-14 | Jessamine | Kentucky | 21113 | 6750 | 81 |
1716951 | 1716951 | 2021-09-14 | Johnson | Kentucky | 21115 | 3198 | 40 |
1716952 | 1716952 | 2021-09-14 | Kenton | Kentucky | 21117 | 21246 | 236 |
1716953 | 1716953 | 2021-09-14 | Knott | Kentucky | 21119 | 1924 | 28 |
1716954 | 1716954 | 2021-09-14 | Knox | Kentucky | 21121 | 5926 | 49 |
1716955 | 1716955 | 2021-09-14 | Larue | Kentucky | 21123 | 2139 | 30 |
1716956 | 1716956 | 2021-09-14 | Laurel | Kentucky | 21125 | 11820 | 87 |
1716957 | 1716957 | 2021-09-14 | Lawrence | Kentucky | 21127 | 2117 | 33 |
1716958 | 1716958 | 2021-09-14 | Lee | Kentucky | 21129 | 1599 | 29 |
1716959 | 1716959 | 2021-09-14 | Leslie | Kentucky | 21131 | 1736 | 11 |
1716960 | 1716960 | 2021-09-14 | Letcher | Kentucky | 21133 | 3069 | 53 |
1716961 | 1716961 | 2021-09-14 | Lewis | Kentucky | 21135 | 2018 | 48 |
1716962 | 1716962 | 2021-09-14 | Lincoln | Kentucky | 21137 | 3452 | 70 |
1716963 | 1716963 | 2021-09-14 | Livingston | Kentucky | 21139 | 1153 | 30 |
1716964 | 1716964 | 2021-09-14 | Logan | Kentucky | 21141 | 4427 | 77 |
1716965 | 1716965 | 2021-09-14 | Lyon | Kentucky | 21143 | 1786 | 23 |
1716966 | 1716966 | 2021-09-14 | Madison | Kentucky | 21151 | 13131 | 124 |
1716967 | 1716967 | 2021-09-14 | Magoffin | Kentucky | 21153 | 1749 | 18 |
1716968 | 1716968 | 2021-09-14 | Marion | Kentucky | 21155 | 3402 | 40 |
1716969 | 1716969 | 2021-09-14 | Marshall | Kentucky | 21157 | 4488 | 72 |
1716970 | 1716970 | 2021-09-14 | Martin | Kentucky | 21159 | 1542 | 25 |
1716971 | 1716971 | 2021-09-14 | Mason | Kentucky | 21161 | 2200 | 46 |
1716972 | 1716972 | 2021-09-14 | McCracken | Kentucky | 21145 | 9047 | 145 |
1716973 | 1716973 | 2021-09-14 | McCreary | Kentucky | 21147 | 2805 | 36 |
1716974 | 1716974 | 2021-09-14 | McLean | Kentucky | 21149 | 1250 | 31 |
1716975 | 1716975 | 2021-09-14 | Meade | Kentucky | 21163 | 2914 | 30 |
1716976 | 1716976 | 2021-09-14 | Menifee | Kentucky | 21165 | 724 | 17 |
1716977 | 1716977 | 2021-09-14 | Mercer | Kentucky | 21167 | 3785 | 59 |
1716978 | 1716978 | 2021-09-14 | Metcalfe | Kentucky | 21169 | 1586 | 35 |
1716979 | 1716979 | 2021-09-14 | Monroe | Kentucky | 21171 | 1911 | 49 |
1716980 | 1716980 | 2021-09-14 | Montgomery | Kentucky | 21173 | 3932 | 36 |
1716981 | 1716981 | 2021-09-14 | Morgan | Kentucky | 21175 | 2639 | 5 |
1716982 | 1716982 | 2021-09-14 | Muhlenberg | Kentucky | 21177 | 4734 | 81 |
1716983 | 1716983 | 2021-09-14 | Nelson | Kentucky | 21179 | 7165 | 70 |
1716984 | 1716984 | 2021-09-14 | Nicholas | Kentucky | 21181 | 876 | 10 |
1716985 | 1716985 | 2021-09-14 | Ohio | Kentucky | 21183 | 3677 | 63 |
1716986 | 1716986 | 2021-09-14 | Oldham | Kentucky | 21185 | 9297 | 86 |
1716987 | 1716987 | 2021-09-14 | Owen | Kentucky | 21187 | 1163 | 15 |
1716988 | 1716988 | 2021-09-14 | Owsley | Kentucky | 21189 | 793 | 16 |
1716989 | 1716989 | 2021-09-14 | Pendleton | Kentucky | 21191 | 1566 | 11 |
1716990 | 1716990 | 2021-09-14 | Perry | Kentucky | 21193 | 4922 | 76 |
1716991 | 1716991 | 2021-09-14 | Pike | Kentucky | 21195 | 9126 | 130 |
1716992 | 1716992 | 2021-09-14 | Powell | Kentucky | 21197 | 2038 | 15 |
1716993 | 1716993 | 2021-09-14 | Pulaski | Kentucky | 21199 | 9243 | 152 |
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);