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 397
- 21097 395
- 21111 395
- 21173 391
- 21017 389
- 21179 389
- 21049 388
- 21143 386
- 21073 385
- 21117 385
- 21227 385
- 21047 384
- 21059 384
- 21101 384
- 21199 384
- 21209 384
- 21035 383
- 21005 382
- 21151 382
- 21215 382
- 21003 381
- 21025 381
- 21093 381
- 21113 381
- 21185 381
- 21141 380
- 21145 379
- 21159 379
- 21165 379
- 21177 379
- …
county >30
- Fayette 397
- Harrison 395
- Jefferson 395
- Montgomery 391
- Bourbon 389
- Nelson 389
- Clark 388
- Lyon 386
- Franklin 385
- Kenton 385
- Warren 385
- Christian 384
- Daviess 384
- Henderson 384
- Pulaski 384
- Scott 384
- Calloway 383
- Anderson 382
- Madison 382
- Spencer 382
- Allen 381
- Breathitt 381
- Hardin 381
- Jessamine 381
- Oldham 381
- Logan 380
- Martin 379
- McCracken 379
- Menifee 379
- Muhlenberg 379
- …
state 1
- Kentucky · 44,332 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194110 | 1194110 | 2021-04-06 | Adair | Kentucky | 21001 | 1794 | 53 |
1194111 | 1194111 | 2021-04-06 | Allen | Kentucky | 21003 | 1959 | 35 |
1194112 | 1194112 | 2021-04-06 | Anderson | Kentucky | 21005 | 1684 | 19 |
1194113 | 1194113 | 2021-04-06 | Ballard | Kentucky | 21007 | 384 | 8 |
1194114 | 1194114 | 2021-04-06 | Barren | Kentucky | 21009 | 4282 | 86 |
1194115 | 1194115 | 2021-04-06 | Bath | Kentucky | 21011 | 833 | 20 |
1194116 | 1194116 | 2021-04-06 | Bell | Kentucky | 21013 | 2970 | 50 |
1194117 | 1194117 | 2021-04-06 | Boone | Kentucky | 21015 | 13781 | 131 |
1194118 | 1194118 | 2021-04-06 | Bourbon | Kentucky | 21017 | 1634 | 18 |
1194119 | 1194119 | 2021-04-06 | Boyd | Kentucky | 21019 | 4806 | 71 |
1194120 | 1194120 | 2021-04-06 | Boyle | Kentucky | 21021 | 3302 | 68 |
1194121 | 1194121 | 2021-04-06 | Bracken | Kentucky | 21023 | 546 | 7 |
1194122 | 1194122 | 2021-04-06 | Breathitt | Kentucky | 21025 | 989 | 8 |
1194123 | 1194123 | 2021-04-06 | Breckinridge | Kentucky | 21027 | 1144 | 13 |
1194124 | 1194124 | 2021-04-06 | Bullitt | Kentucky | 21029 | 6828 | 72 |
1194125 | 1194125 | 2021-04-06 | Butler | Kentucky | 21031 | 1429 | 24 |
1194126 | 1194126 | 2021-04-06 | Caldwell | Kentucky | 21033 | 1412 | 29 |
1194127 | 1194127 | 2021-04-06 | Calloway | Kentucky | 21035 | 3456 | 48 |
1194128 | 1194128 | 2021-04-06 | Campbell | Kentucky | 21037 | 8546 | 80 |
1194129 | 1194129 | 2021-04-06 | Carlisle | Kentucky | 21039 | 457 | 8 |
1194130 | 1194130 | 2021-04-06 | Carroll | Kentucky | 21041 | 971 | 18 |
1194131 | 1194131 | 2021-04-06 | Carter | Kentucky | 21043 | 2182 | 32 |
1194132 | 1194132 | 2021-04-06 | Casey | Kentucky | 21045 | 1348 | 34 |
1194133 | 1194133 | 2021-04-06 | Christian | Kentucky | 21047 | 6658 | 98 |
1194134 | 1194134 | 2021-04-06 | Clark | Kentucky | 21049 | 2654 | 28 |
1194135 | 1194135 | 2021-04-06 | Clay | Kentucky | 21051 | 2592 | 38 |
1194136 | 1194136 | 2021-04-06 | Clinton | Kentucky | 21053 | 1445 | 30 |
1194137 | 1194137 | 2021-04-06 | Crittenden | Kentucky | 21055 | 612 | 19 |
1194138 | 1194138 | 2021-04-06 | Cumberland | Kentucky | 21057 | 681 | 9 |
1194139 | 1194139 | 2021-04-06 | Daviess | Kentucky | 21059 | 10237 | 173 |
1194140 | 1194140 | 2021-04-06 | Edmonson | Kentucky | 21061 | 946 | 21 |
1194141 | 1194141 | 2021-04-06 | Elliott | Kentucky | 21063 | 945 | 2 |
1194142 | 1194142 | 2021-04-06 | Estill | Kentucky | 21065 | 1047 | 11 |
1194143 | 1194143 | 2021-04-06 | Fayette | Kentucky | 21067 | 34294 | 290 |
1194144 | 1194144 | 2021-04-06 | Fleming | Kentucky | 21069 | 1122 | 21 |
1194145 | 1194145 | 2021-04-06 | Floyd | Kentucky | 21071 | 3231 | 62 |
1194146 | 1194146 | 2021-04-06 | Franklin | Kentucky | 21073 | 3877 | 46 |
1194147 | 1194147 | 2021-04-06 | Fulton | Kentucky | 21075 | 496 | 14 |
1194148 | 1194148 | 2021-04-06 | Gallatin | Kentucky | 21077 | 684 | 25 |
1194149 | 1194149 | 2021-04-06 | Garrard | Kentucky | 21079 | 1464 | 31 |
1194150 | 1194150 | 2021-04-06 | Grant | Kentucky | 21081 | 2348 | 18 |
1194151 | 1194151 | 2021-04-06 | Graves | Kentucky | 21083 | 4057 | 90 |
1194152 | 1194152 | 2021-04-06 | Grayson | Kentucky | 21085 | 2063 | 51 |
1194153 | 1194153 | 2021-04-06 | Green | Kentucky | 21087 | 1189 | 15 |
1194154 | 1194154 | 2021-04-06 | Greenup | Kentucky | 21089 | 3452 | 54 |
1194155 | 1194155 | 2021-04-06 | Hancock | Kentucky | 21091 | 841 | 16 |
1194156 | 1194156 | 2021-04-06 | Hardin | Kentucky | 21093 | 9324 | 147 |
1194157 | 1194157 | 2021-04-06 | Harlan | Kentucky | 21095 | 2601 | 80 |
1194158 | 1194158 | 2021-04-06 | Harrison | Kentucky | 21097 | 1618 | 22 |
1194159 | 1194159 | 2021-04-06 | Hart | Kentucky | 21099 | 1917 | 45 |
1194160 | 1194160 | 2021-04-06 | Henderson | Kentucky | 21101 | 4523 | 71 |
1194161 | 1194161 | 2021-04-06 | Henry | Kentucky | 21103 | 1304 | 11 |
1194162 | 1194162 | 2021-04-06 | Hickman | Kentucky | 21105 | 346 | 10 |
1194163 | 1194163 | 2021-04-06 | Hopkins | Kentucky | 21107 | 4245 | 141 |
1194164 | 1194164 | 2021-04-06 | Jackson | Kentucky | 21109 | 1281 | 32 |
1194165 | 1194165 | 2021-04-06 | Jefferson | Kentucky | 21111 | 78243 | 1106 |
1194166 | 1194166 | 2021-04-06 | Jessamine | Kentucky | 21113 | 4400 | 60 |
1194167 | 1194167 | 2021-04-06 | Johnson | Kentucky | 21115 | 1866 | 30 |
1194168 | 1194168 | 2021-04-06 | Kenton | Kentucky | 21117 | 16318 | 193 |
1194169 | 1194169 | 2021-04-06 | Knott | Kentucky | 21119 | 1122 | 22 |
1194170 | 1194170 | 2021-04-06 | Knox | Kentucky | 21121 | 3290 | 32 |
1194171 | 1194171 | 2021-04-06 | Larue | Kentucky | 21123 | 1278 | 25 |
1194172 | 1194172 | 2021-04-06 | Laurel | Kentucky | 21125 | 6349 | 60 |
1194173 | 1194173 | 2021-04-06 | Lawrence | Kentucky | 21127 | 1351 | 20 |
1194174 | 1194174 | 2021-04-06 | Lee | Kentucky | 21129 | 1254 | 22 |
1194175 | 1194175 | 2021-04-06 | Leslie | Kentucky | 21131 | 869 | 6 |
1194176 | 1194176 | 2021-04-06 | Letcher | Kentucky | 21133 | 1828 | 41 |
1194177 | 1194177 | 2021-04-06 | Lewis | Kentucky | 21135 | 1139 | 32 |
1194178 | 1194178 | 2021-04-06 | Lincoln | Kentucky | 21137 | 2213 | 45 |
1194179 | 1194179 | 2021-04-06 | Livingston | Kentucky | 21139 | 796 | 20 |
1194180 | 1194180 | 2021-04-06 | Logan | Kentucky | 21141 | 2676 | 64 |
1194181 | 1194181 | 2021-04-06 | Lyon | Kentucky | 21143 | 1489 | 19 |
1194182 | 1194182 | 2021-04-06 | Madison | Kentucky | 21151 | 9045 | 108 |
1194183 | 1194183 | 2021-04-06 | Magoffin | Kentucky | 21153 | 911 | 14 |
1194184 | 1194184 | 2021-04-06 | Marion | Kentucky | 21155 | 2214 | 36 |
1194185 | 1194185 | 2021-04-06 | Marshall | Kentucky | 21157 | 2671 | 54 |
1194186 | 1194186 | 2021-04-06 | Martin | Kentucky | 21159 | 986 | 20 |
1194187 | 1194187 | 2021-04-06 | Mason | Kentucky | 21161 | 1529 | 34 |
1194188 | 1194188 | 2021-04-06 | McCracken | Kentucky | 21145 | 6210 | 118 |
1194189 | 1194189 | 2021-04-06 | McCreary | Kentucky | 21147 | 1935 | 30 |
1194190 | 1194190 | 2021-04-06 | McLean | Kentucky | 21149 | 858 | 27 |
1194191 | 1194191 | 2021-04-06 | Meade | Kentucky | 21163 | 1949 | 22 |
1194192 | 1194192 | 2021-04-06 | Menifee | Kentucky | 21165 | 429 | 15 |
1194193 | 1194193 | 2021-04-06 | Mercer | Kentucky | 21167 | 2476 | 45 |
1194194 | 1194194 | 2021-04-06 | Metcalfe | Kentucky | 21169 | 1005 | 25 |
1194195 | 1194195 | 2021-04-06 | Monroe | Kentucky | 21171 | 1283 | 40 |
1194196 | 1194196 | 2021-04-06 | Montgomery | Kentucky | 21173 | 2456 | 30 |
1194197 | 1194197 | 2021-04-06 | Morgan | Kentucky | 21175 | 2130 | 3 |
1194198 | 1194198 | 2021-04-06 | Muhlenberg | Kentucky | 21177 | 2869 | 58 |
1194199 | 1194199 | 2021-04-06 | Nelson | Kentucky | 21179 | 4757 | 50 |
1194200 | 1194200 | 2021-04-06 | Nicholas | Kentucky | 21181 | 504 | 8 |
1194201 | 1194201 | 2021-04-06 | Ohio | Kentucky | 21183 | 2444 | 53 |
1194202 | 1194202 | 2021-04-06 | Oldham | Kentucky | 21185 | 7346 | 80 |
1194203 | 1194203 | 2021-04-06 | Owen | Kentucky | 21187 | 642 | 12 |
1194204 | 1194204 | 2021-04-06 | Owsley | Kentucky | 21189 | 484 | 12 |
1194205 | 1194205 | 2021-04-06 | Pendleton | Kentucky | 21191 | 986 | 3 |
1194206 | 1194206 | 2021-04-06 | Perry | Kentucky | 21193 | 2554 | 62 |
1194207 | 1194207 | 2021-04-06 | Pike | Kentucky | 21195 | 5383 | 84 |
1194208 | 1194208 | 2021-04-06 | Powell | Kentucky | 21197 | 1106 | 8 |
1194209 | 1194209 | 2021-04-06 | Pulaski | Kentucky | 21199 | 6125 | 94 |
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);