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 193
- 21097 191
- 21111 191
- 21173 187
- 21017 185
- 21179 185
- 21049 184
- 21143 182
- 21227 182
- 21073 181
- 21117 181
- 21209 181
- 21047 180
- 21059 180
- 21101 180
- 21199 180
- 21035 179
- 21215 179
- 21005 178
- 21151 178
- 21003 177
- 21025 177
- 21093 177
- 21113 177
- 21185 177
- 21141 176
- 21213 176
- 21145 175
- 21159 175
- 21165 175
- …
county >30
- Fayette 193
- Harrison 191
- Jefferson 191
- Montgomery 187
- Bourbon 185
- Nelson 185
- Clark 184
- Lyon 182
- Warren 182
- Franklin 181
- Kenton 181
- Scott 181
- Christian 180
- Daviess 180
- Henderson 180
- Pulaski 180
- Calloway 179
- Spencer 179
- Anderson 178
- Madison 178
- Allen 177
- Breathitt 177
- Hardin 177
- Jessamine 177
- Oldham 177
- Logan 176
- Simpson 176
- Martin 175
- McCracken 175
- Menifee 175
- …
state 1
- Kentucky · 19,872 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535521 | 535521 | 2020-09-15 | Robertson | Kentucky | 21201 | 12 | 0 |
535522 | 535522 | 2020-09-15 | Rockcastle | Kentucky | 21203 | 154 | 1 |
535523 | 535523 | 2020-09-15 | Rowan | Kentucky | 21205 | 194 | 1 |
535524 | 535524 | 2020-09-15 | Russell | Kentucky | 21207 | 240 | 6 |
535525 | 535525 | 2020-09-15 | Scott | Kentucky | 21209 | 695 | 8 |
535526 | 535526 | 2020-09-15 | Shelby | Kentucky | 21211 | 994 | 24 |
535527 | 535527 | 2020-09-15 | Simpson | Kentucky | 21213 | 252 | 8 |
535528 | 535528 | 2020-09-15 | Spencer | Kentucky | 21215 | 189 | 0 |
535529 | 535529 | 2020-09-15 | Taylor | Kentucky | 21217 | 270 | 6 |
535530 | 535530 | 2020-09-15 | Todd | Kentucky | 21219 | 174 | 8 |
535531 | 535531 | 2020-09-15 | Trigg | Kentucky | 21221 | 144 | 0 |
535532 | 535532 | 2020-09-15 | Trimble | Kentucky | 21223 | 52 | 0 |
535533 | 535533 | 2020-09-15 | Union | Kentucky | 21225 | 216 | 1 |
535534 | 535534 | 2020-09-15 | Warren | Kentucky | 21227 | 3991 | 40 |
535535 | 535535 | 2020-09-15 | Washington | Kentucky | 21229 | 140 | 1 |
535536 | 535536 | 2020-09-15 | Wayne | Kentucky | 21231 | 124 | 0 |
535537 | 535537 | 2020-09-15 | Webster | Kentucky | 21233 | 141 | 2 |
535538 | 535538 | 2020-09-15 | Whitley | Kentucky | 21235 | 246 | 2 |
535539 | 535539 | 2020-09-15 | Wolfe | Kentucky | 21237 | 30 | 0 |
535540 | 535540 | 2020-09-15 | Woodford | Kentucky | 21239 | 238 | 0 |
532186 | 532186 | 2020-09-14 | Adair | Kentucky | 21001 | 291 | 19 |
532187 | 532187 | 2020-09-14 | Allen | Kentucky | 21003 | 296 | 9 |
532188 | 532188 | 2020-09-14 | Anderson | Kentucky | 21005 | 133 | 1 |
532189 | 532189 | 2020-09-14 | Ballard | Kentucky | 21007 | 48 | 1 |
532190 | 532190 | 2020-09-14 | Barren | Kentucky | 21009 | 585 | 13 |
532191 | 532191 | 2020-09-14 | Bath | Kentucky | 21011 | 71 | 1 |
532192 | 532192 | 2020-09-14 | Bell | Kentucky | 21013 | 450 | 11 |
532193 | 532193 | 2020-09-14 | Boone | Kentucky | 21015 | 1423 | 25 |
532194 | 532194 | 2020-09-14 | Bourbon | Kentucky | 21017 | 161 | 1 |
532195 | 532195 | 2020-09-14 | Boyd | Kentucky | 21019 | 351 | 4 |
532196 | 532196 | 2020-09-14 | Boyle | Kentucky | 21021 | 237 | 0 |
532197 | 532197 | 2020-09-14 | Bracken | Kentucky | 21023 | 38 | 0 |
532198 | 532198 | 2020-09-14 | Breathitt | Kentucky | 21025 | 70 | 0 |
532199 | 532199 | 2020-09-14 | Breckinridge | Kentucky | 21027 | 116 | 2 |
532200 | 532200 | 2020-09-14 | Bullitt | Kentucky | 21029 | 739 | 8 |
532201 | 532201 | 2020-09-14 | Butler | Kentucky | 21031 | 332 | 16 |
532202 | 532202 | 2020-09-14 | Caldwell | Kentucky | 21033 | 104 | 0 |
532203 | 532203 | 2020-09-14 | Calloway | Kentucky | 21035 | 494 | 8 |
532204 | 532204 | 2020-09-14 | Campbell | Kentucky | 21037 | 784 | 18 |
532205 | 532205 | 2020-09-14 | Carlisle | Kentucky | 21039 | 68 | 1 |
532206 | 532206 | 2020-09-14 | Carroll | Kentucky | 21041 | 195 | 5 |
532207 | 532207 | 2020-09-14 | Carter | Kentucky | 21043 | 145 | 3 |
532208 | 532208 | 2020-09-14 | Casey | Kentucky | 21045 | 265 | 16 |
532209 | 532209 | 2020-09-14 | Christian | Kentucky | 21047 | 1066 | 15 |
532210 | 532210 | 2020-09-14 | Clark | Kentucky | 21049 | 286 | 8 |
532211 | 532211 | 2020-09-14 | Clay | Kentucky | 21051 | 261 | 6 |
532212 | 532212 | 2020-09-14 | Clinton | Kentucky | 21053 | 100 | 2 |
532213 | 532213 | 2020-09-14 | Crittenden | Kentucky | 21055 | 99 | 1 |
532214 | 532214 | 2020-09-14 | Cumberland | Kentucky | 21057 | 93 | 0 |
532215 | 532215 | 2020-09-14 | Daviess | Kentucky | 21059 | 1146 | 13 |
532216 | 532216 | 2020-09-14 | Edmonson | Kentucky | 21061 | 142 | 12 |
532217 | 532217 | 2020-09-14 | Elliott | Kentucky | 21063 | 32 | 0 |
532218 | 532218 | 2020-09-14 | Estill | Kentucky | 21065 | 74 | 0 |
532219 | 532219 | 2020-09-14 | Fayette | Kentucky | 21067 | 7200 | 70 |
532220 | 532220 | 2020-09-14 | Fleming | Kentucky | 21069 | 75 | 0 |
532221 | 532221 | 2020-09-14 | Floyd | Kentucky | 21071 | 162 | 2 |
532222 | 532222 | 2020-09-14 | Franklin | Kentucky | 21073 | 566 | 11 |
532223 | 532223 | 2020-09-14 | Fulton | Kentucky | 21075 | 131 | 2 |
532224 | 532224 | 2020-09-14 | Gallatin | Kentucky | 21077 | 96 | 8 |
532225 | 532225 | 2020-09-14 | Garrard | Kentucky | 21079 | 139 | 3 |
532226 | 532226 | 2020-09-14 | Grant | Kentucky | 21081 | 150 | 6 |
532227 | 532227 | 2020-09-14 | Graves | Kentucky | 21083 | 691 | 29 |
532228 | 532228 | 2020-09-14 | Grayson | Kentucky | 21085 | 345 | 13 |
532229 | 532229 | 2020-09-14 | Green | Kentucky | 21087 | 242 | 9 |
532230 | 532230 | 2020-09-14 | Greenup | Kentucky | 21089 | 315 | 2 |
532231 | 532231 | 2020-09-14 | Hancock | Kentucky | 21091 | 67 | 0 |
532232 | 532232 | 2020-09-14 | Hardin | Kentucky | 21093 | 1102 | 10 |
532233 | 532233 | 2020-09-14 | Harlan | Kentucky | 21095 | 352 | 10 |
532234 | 532234 | 2020-09-14 | Harrison | Kentucky | 21097 | 165 | 0 |
532235 | 532235 | 2020-09-14 | Hart | Kentucky | 21099 | 172 | 1 |
532236 | 532236 | 2020-09-14 | Henderson | Kentucky | 21101 | 588 | 4 |
532237 | 532237 | 2020-09-14 | Henry | Kentucky | 21103 | 175 | 2 |
532238 | 532238 | 2020-09-14 | Hickman | Kentucky | 21105 | 72 | 0 |
532239 | 532239 | 2020-09-14 | Hopkins | Kentucky | 21107 | 569 | 38 |
532240 | 532240 | 2020-09-14 | Jackson | Kentucky | 21109 | 326 | 15 |
532241 | 532241 | 2020-09-14 | Jefferson | Kentucky | 21111 | 15155 | 314 |
532242 | 532242 | 2020-09-14 | Jessamine | Kentucky | 21113 | 539 | 0 |
532243 | 532243 | 2020-09-14 | Johnson | Kentucky | 21115 | 136 | 1 |
532244 | 532244 | 2020-09-14 | Kenton | Kentucky | 21117 | 1877 | 44 |
532245 | 532245 | 2020-09-14 | Knott | Kentucky | 21119 | 110 | 1 |
532246 | 532246 | 2020-09-14 | Knox | Kentucky | 21121 | 408 | 9 |
532247 | 532247 | 2020-09-14 | Larue | Kentucky | 21123 | 124 | 1 |
532248 | 532248 | 2020-09-14 | Laurel | Kentucky | 21125 | 699 | 5 |
532249 | 532249 | 2020-09-14 | Lawrence | Kentucky | 21127 | 53 | 0 |
532250 | 532250 | 2020-09-14 | Lee | Kentucky | 21129 | 15 | 0 |
532251 | 532251 | 2020-09-14 | Leslie | Kentucky | 21131 | 45 | 0 |
532252 | 532252 | 2020-09-14 | Letcher | Kentucky | 21133 | 96 | 2 |
532253 | 532253 | 2020-09-14 | Lewis | Kentucky | 21135 | 210 | 14 |
532254 | 532254 | 2020-09-14 | Lincoln | Kentucky | 21137 | 164 | 12 |
532255 | 532255 | 2020-09-14 | Livingston | Kentucky | 21139 | 72 | 1 |
532256 | 532256 | 2020-09-14 | Logan | Kentucky | 21141 | 490 | 27 |
532257 | 532257 | 2020-09-14 | Lyon | Kentucky | 21143 | 59 | 4 |
532258 | 532258 | 2020-09-14 | Madison | Kentucky | 21151 | 1406 | 4 |
532259 | 532259 | 2020-09-14 | Magoffin | Kentucky | 21153 | 78 | 0 |
532260 | 532260 | 2020-09-14 | Marion | Kentucky | 21155 | 209 | 8 |
532261 | 532261 | 2020-09-14 | Marshall | Kentucky | 21157 | 237 | 2 |
532262 | 532262 | 2020-09-14 | Martin | Kentucky | 21159 | 62 | 2 |
532263 | 532263 | 2020-09-14 | Mason | Kentucky | 21161 | 118 | 2 |
532264 | 532264 | 2020-09-14 | McCracken | Kentucky | 21145 | 618 | 6 |
532265 | 532265 | 2020-09-14 | McCreary | Kentucky | 21147 | 131 | 0 |
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);