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 194
- 21097 192
- 21111 192
- 21173 188
- 21017 186
- 21179 186
- 21049 185
- 21143 183
- 21073 182
- 21117 182
- 21227 182
- 21047 181
- 21059 181
- 21101 181
- 21199 181
- 21209 181
- 21035 180
- 21005 179
- 21151 179
- 21215 179
- 21003 178
- 21025 178
- 21093 178
- 21113 178
- 21185 178
- 21141 177
- 21145 176
- 21159 176
- 21165 176
- 21177 176
- …
county >30
- Fayette 194
- Harrison 192
- Jefferson 192
- Montgomery 188
- Bourbon 186
- Nelson 186
- Clark 185
- Lyon 183
- Franklin 182
- Kenton 182
- Warren 182
- Christian 181
- Daviess 181
- Henderson 181
- Pulaski 181
- Scott 181
- Calloway 180
- Anderson 179
- Madison 179
- Spencer 179
- Allen 178
- Breathitt 178
- Hardin 178
- Jessamine 178
- Oldham 178
- Logan 177
- Martin 176
- McCracken 176
- Menifee 176
- Muhlenberg 176
- …
state 1
- Kentucky · 19,972 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535421 | 535421 | 2020-09-15 | Adair | Kentucky | 21001 | 296 | 19 |
535422 | 535422 | 2020-09-15 | Allen | Kentucky | 21003 | 296 | 9 |
535423 | 535423 | 2020-09-15 | Anderson | Kentucky | 21005 | 132 | 1 |
535424 | 535424 | 2020-09-15 | Ballard | Kentucky | 21007 | 48 | 1 |
535425 | 535425 | 2020-09-15 | Barren | Kentucky | 21009 | 594 | 13 |
535426 | 535426 | 2020-09-15 | Bath | Kentucky | 21011 | 72 | 1 |
535427 | 535427 | 2020-09-15 | Bell | Kentucky | 21013 | 454 | 11 |
535428 | 535428 | 2020-09-15 | Boone | Kentucky | 21015 | 1436 | 25 |
535429 | 535429 | 2020-09-15 | Bourbon | Kentucky | 21017 | 163 | 1 |
535430 | 535430 | 2020-09-15 | Boyd | Kentucky | 21019 | 357 | 4 |
535431 | 535431 | 2020-09-15 | Boyle | Kentucky | 21021 | 241 | 0 |
535432 | 535432 | 2020-09-15 | Bracken | Kentucky | 21023 | 39 | 0 |
535433 | 535433 | 2020-09-15 | Breathitt | Kentucky | 21025 | 76 | 0 |
535434 | 535434 | 2020-09-15 | Breckinridge | Kentucky | 21027 | 116 | 2 |
535435 | 535435 | 2020-09-15 | Bullitt | Kentucky | 21029 | 749 | 9 |
535436 | 535436 | 2020-09-15 | Butler | Kentucky | 21031 | 332 | 16 |
535437 | 535437 | 2020-09-15 | Caldwell | Kentucky | 21033 | 109 | 0 |
535438 | 535438 | 2020-09-15 | Calloway | Kentucky | 21035 | 498 | 8 |
535439 | 535439 | 2020-09-15 | Campbell | Kentucky | 21037 | 793 | 18 |
535440 | 535440 | 2020-09-15 | Carlisle | Kentucky | 21039 | 68 | 1 |
535441 | 535441 | 2020-09-15 | Carroll | Kentucky | 21041 | 195 | 5 |
535442 | 535442 | 2020-09-15 | Carter | Kentucky | 21043 | 149 | 3 |
535443 | 535443 | 2020-09-15 | Casey | Kentucky | 21045 | 265 | 16 |
535444 | 535444 | 2020-09-15 | Christian | Kentucky | 21047 | 1095 | 17 |
535445 | 535445 | 2020-09-15 | Clark | Kentucky | 21049 | 293 | 8 |
535446 | 535446 | 2020-09-15 | Clay | Kentucky | 21051 | 263 | 6 |
535447 | 535447 | 2020-09-15 | Clinton | Kentucky | 21053 | 101 | 2 |
535448 | 535448 | 2020-09-15 | Crittenden | Kentucky | 21055 | 113 | 1 |
535449 | 535449 | 2020-09-15 | Cumberland | Kentucky | 21057 | 95 | 0 |
535450 | 535450 | 2020-09-15 | Daviess | Kentucky | 21059 | 1163 | 13 |
535451 | 535451 | 2020-09-15 | Edmonson | Kentucky | 21061 | 142 | 12 |
535452 | 535452 | 2020-09-15 | Elliott | Kentucky | 21063 | 32 | 0 |
535453 | 535453 | 2020-09-15 | Estill | Kentucky | 21065 | 75 | 0 |
535454 | 535454 | 2020-09-15 | Fayette | Kentucky | 21067 | 7296 | 70 |
535455 | 535455 | 2020-09-15 | Fleming | Kentucky | 21069 | 75 | 0 |
535456 | 535456 | 2020-09-15 | Floyd | Kentucky | 21071 | 165 | 2 |
535457 | 535457 | 2020-09-15 | Franklin | Kentucky | 21073 | 577 | 11 |
535458 | 535458 | 2020-09-15 | Fulton | Kentucky | 21075 | 133 | 2 |
535459 | 535459 | 2020-09-15 | Gallatin | Kentucky | 21077 | 96 | 8 |
535460 | 535460 | 2020-09-15 | Garrard | Kentucky | 21079 | 139 | 3 |
535461 | 535461 | 2020-09-15 | Grant | Kentucky | 21081 | 150 | 6 |
535462 | 535462 | 2020-09-15 | Graves | Kentucky | 21083 | 693 | 29 |
535463 | 535463 | 2020-09-15 | Grayson | Kentucky | 21085 | 350 | 13 |
535464 | 535464 | 2020-09-15 | Green | Kentucky | 21087 | 248 | 9 |
535465 | 535465 | 2020-09-15 | Greenup | Kentucky | 21089 | 318 | 2 |
535466 | 535466 | 2020-09-15 | Hancock | Kentucky | 21091 | 69 | 0 |
535467 | 535467 | 2020-09-15 | Hardin | Kentucky | 21093 | 1135 | 10 |
535468 | 535468 | 2020-09-15 | Harlan | Kentucky | 21095 | 353 | 10 |
535469 | 535469 | 2020-09-15 | Harrison | Kentucky | 21097 | 165 | 0 |
535470 | 535470 | 2020-09-15 | Hart | Kentucky | 21099 | 172 | 1 |
535471 | 535471 | 2020-09-15 | Henderson | Kentucky | 21101 | 597 | 4 |
535472 | 535472 | 2020-09-15 | Henry | Kentucky | 21103 | 175 | 2 |
535473 | 535473 | 2020-09-15 | Hickman | Kentucky | 21105 | 73 | 0 |
535474 | 535474 | 2020-09-15 | Hopkins | Kentucky | 21107 | 578 | 39 |
535475 | 535475 | 2020-09-15 | Jackson | Kentucky | 21109 | 332 | 15 |
535476 | 535476 | 2020-09-15 | Jefferson | Kentucky | 21111 | 15303 | 314 |
535477 | 535477 | 2020-09-15 | Jessamine | Kentucky | 21113 | 545 | 0 |
535478 | 535478 | 2020-09-15 | Johnson | Kentucky | 21115 | 136 | 1 |
535479 | 535479 | 2020-09-15 | Kenton | Kentucky | 21117 | 1894 | 45 |
535480 | 535480 | 2020-09-15 | Knott | Kentucky | 21119 | 113 | 1 |
535481 | 535481 | 2020-09-15 | Knox | Kentucky | 21121 | 416 | 9 |
535482 | 535482 | 2020-09-15 | Larue | Kentucky | 21123 | 126 | 1 |
535483 | 535483 | 2020-09-15 | Laurel | Kentucky | 21125 | 704 | 5 |
535484 | 535484 | 2020-09-15 | Lawrence | Kentucky | 21127 | 52 | 0 |
535485 | 535485 | 2020-09-15 | Lee | Kentucky | 21129 | 15 | 0 |
535486 | 535486 | 2020-09-15 | Leslie | Kentucky | 21131 | 47 | 0 |
535487 | 535487 | 2020-09-15 | Letcher | Kentucky | 21133 | 96 | 2 |
535488 | 535488 | 2020-09-15 | Lewis | Kentucky | 21135 | 211 | 14 |
535489 | 535489 | 2020-09-15 | Lincoln | Kentucky | 21137 | 165 | 12 |
535490 | 535490 | 2020-09-15 | Livingston | Kentucky | 21139 | 73 | 1 |
535491 | 535491 | 2020-09-15 | Logan | Kentucky | 21141 | 531 | 27 |
535492 | 535492 | 2020-09-15 | Lyon | Kentucky | 21143 | 56 | 4 |
535493 | 535493 | 2020-09-15 | Madison | Kentucky | 21151 | 1438 | 4 |
535494 | 535494 | 2020-09-15 | Magoffin | Kentucky | 21153 | 79 | 0 |
535495 | 535495 | 2020-09-15 | Marion | Kentucky | 21155 | 210 | 8 |
535496 | 535496 | 2020-09-15 | Marshall | Kentucky | 21157 | 239 | 2 |
535497 | 535497 | 2020-09-15 | Martin | Kentucky | 21159 | 62 | 2 |
535498 | 535498 | 2020-09-15 | Mason | Kentucky | 21161 | 118 | 2 |
535499 | 535499 | 2020-09-15 | McCracken | Kentucky | 21145 | 633 | 6 |
535500 | 535500 | 2020-09-15 | McCreary | Kentucky | 21147 | 132 | 0 |
535501 | 535501 | 2020-09-15 | McLean | Kentucky | 21149 | 67 | 0 |
535502 | 535502 | 2020-09-15 | Meade | Kentucky | 21163 | 187 | 3 |
535503 | 535503 | 2020-09-15 | Menifee | Kentucky | 21165 | 41 | 0 |
535504 | 535504 | 2020-09-15 | Mercer | Kentucky | 21167 | 171 | 1 |
535505 | 535505 | 2020-09-15 | Metcalfe | Kentucky | 21169 | 100 | 2 |
535506 | 535506 | 2020-09-15 | Monroe | Kentucky | 21171 | 188 | 4 |
535507 | 535507 | 2020-09-15 | Montgomery | Kentucky | 21173 | 221 | 1 |
535508 | 535508 | 2020-09-15 | Morgan | Kentucky | 21175 | 50 | 0 |
535509 | 535509 | 2020-09-15 | Muhlenberg | Kentucky | 21177 | 733 | 13 |
535510 | 535510 | 2020-09-15 | Nelson | Kentucky | 21179 | 454 | 4 |
535511 | 535511 | 2020-09-15 | Nicholas | Kentucky | 21181 | 29 | 1 |
535512 | 535512 | 2020-09-15 | Ohio | Kentucky | 21183 | 444 | 9 |
535513 | 535513 | 2020-09-15 | Oldham | Kentucky | 21185 | 976 | 25 |
535514 | 535514 | 2020-09-15 | Owen | Kentucky | 21187 | 89 | 2 |
535515 | 535515 | 2020-09-15 | Owsley | Kentucky | 21189 | 37 | 1 |
535516 | 535516 | 2020-09-15 | Pendleton | Kentucky | 21191 | 88 | 0 |
535517 | 535517 | 2020-09-15 | Perry | Kentucky | 21193 | 311 | 8 |
535518 | 535518 | 2020-09-15 | Pike | Kentucky | 21195 | 373 | 3 |
535519 | 535519 | 2020-09-15 | Powell | Kentucky | 21197 | 88 | 0 |
535520 | 535520 | 2020-09-15 | Pulaski | Kentucky | 21199 | 710 | 9 |
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);