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 354
- 21097 352
- 21111 352
- 21173 348
- 21017 346
- 21179 346
- 21049 345
- 21143 343
- 21073 342
- 21117 342
- 21227 342
- 21047 341
- 21059 341
- 21101 341
- 21199 341
- 21209 341
- 21035 340
- 21005 339
- 21151 339
- 21215 339
- 21003 338
- 21025 338
- 21093 338
- 21113 338
- 21185 338
- 21141 337
- 21145 336
- 21159 336
- 21165 336
- 21177 336
- …
county >30
- Fayette 354
- Harrison 352
- Jefferson 352
- Montgomery 348
- Bourbon 346
- Nelson 346
- Clark 345
- Lyon 343
- Franklin 342
- Kenton 342
- Warren 342
- Christian 341
- Daviess 341
- Henderson 341
- Pulaski 341
- Scott 341
- Calloway 340
- Anderson 339
- Madison 339
- Spencer 339
- Allen 338
- Breathitt 338
- Hardin 338
- Jessamine 338
- Oldham 338
- Logan 337
- Martin 336
- McCracken 336
- Menifee 336
- Muhlenberg 336
- …
state 1
- Kentucky · 39,172 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054507 | 1054507 | 2021-02-22 | Adair | Kentucky | 21001 | 1653 | 49 |
1054508 | 1054508 | 2021-02-22 | Allen | Kentucky | 21003 | 1782 | 22 |
1054509 | 1054509 | 2021-02-22 | Anderson | Kentucky | 21005 | 1596 | 16 |
1054510 | 1054510 | 2021-02-22 | Ballard | Kentucky | 21007 | 339 | 5 |
1054511 | 1054511 | 2021-02-22 | Barren | Kentucky | 21009 | 3962 | 71 |
1054512 | 1054512 | 2021-02-22 | Bath | Kentucky | 21011 | 744 | 16 |
1054513 | 1054513 | 2021-02-22 | Bell | Kentucky | 21013 | 2684 | 34 |
1054514 | 1054514 | 2021-02-22 | Boone | Kentucky | 21015 | 12757 | 72 |
1054515 | 1054515 | 2021-02-22 | Bourbon | Kentucky | 21017 | 1521 | 12 |
1054516 | 1054516 | 2021-02-22 | Boyd | Kentucky | 21019 | 4587 | 43 |
1054517 | 1054517 | 2021-02-22 | Boyle | Kentucky | 21021 | 3125 | 31 |
1054518 | 1054518 | 2021-02-22 | Bracken | Kentucky | 21023 | 501 | 4 |
1054519 | 1054519 | 2021-02-22 | Breathitt | Kentucky | 21025 | 913 | 6 |
1054520 | 1054520 | 2021-02-22 | Breckinridge | Kentucky | 21027 | 1086 | 9 |
1054521 | 1054521 | 2021-02-22 | Bullitt | Kentucky | 21029 | 6298 | 48 |
1054522 | 1054522 | 2021-02-22 | Butler | Kentucky | 21031 | 1326 | 23 |
1054523 | 1054523 | 2021-02-22 | Caldwell | Kentucky | 21033 | 1329 | 23 |
1054524 | 1054524 | 2021-02-22 | Calloway | Kentucky | 21035 | 3350 | 38 |
1054525 | 1054525 | 2021-02-22 | Campbell | Kentucky | 21037 | 7942 | 46 |
1054526 | 1054526 | 2021-02-22 | Carlisle | Kentucky | 21039 | 426 | 1 |
1054527 | 1054527 | 2021-02-22 | Carroll | Kentucky | 21041 | 872 | 10 |
1054528 | 1054528 | 2021-02-22 | Carter | Kentucky | 21043 | 1954 | 22 |
1054529 | 1054529 | 2021-02-22 | Casey | Kentucky | 21045 | 1263 | 34 |
1054530 | 1054530 | 2021-02-22 | Christian | Kentucky | 21047 | 6162 | 79 |
1054531 | 1054531 | 2021-02-22 | Clark | Kentucky | 21049 | 2372 | 18 |
1054532 | 1054532 | 2021-02-22 | Clay | Kentucky | 21051 | 2351 | 26 |
1054533 | 1054533 | 2021-02-22 | Clinton | Kentucky | 21053 | 1380 | 27 |
1054534 | 1054534 | 2021-02-22 | Crittenden | Kentucky | 21055 | 550 | 17 |
1054535 | 1054535 | 2021-02-22 | Cumberland | Kentucky | 21057 | 650 | 9 |
1054536 | 1054536 | 2021-02-22 | Daviess | Kentucky | 21059 | 9555 | 155 |
1054537 | 1054537 | 2021-02-22 | Edmonson | Kentucky | 21061 | 864 | 18 |
1054538 | 1054538 | 2021-02-22 | Elliott | Kentucky | 21063 | 935 | 1 |
1054539 | 1054539 | 2021-02-22 | Estill | Kentucky | 21065 | 961 | 1 |
1054540 | 1054540 | 2021-02-22 | Fayette | Kentucky | 21067 | 32131 | 230 |
1054541 | 1054541 | 2021-02-22 | Fleming | Kentucky | 21069 | 1068 | 14 |
1054542 | 1054542 | 2021-02-22 | Floyd | Kentucky | 21071 | 2980 | 34 |
1054543 | 1054543 | 2021-02-22 | Franklin | Kentucky | 21073 | 3603 | 28 |
1054544 | 1054544 | 2021-02-22 | Fulton | Kentucky | 21075 | 469 | 6 |
1054545 | 1054545 | 2021-02-22 | Gallatin | Kentucky | 21077 | 644 | 19 |
1054546 | 1054546 | 2021-02-22 | Garrard | Kentucky | 21079 | 1377 | 9 |
1054547 | 1054547 | 2021-02-22 | Grant | Kentucky | 21081 | 2144 | 13 |
1054548 | 1054548 | 2021-02-22 | Graves | Kentucky | 21083 | 3932 | 70 |
1054549 | 1054549 | 2021-02-22 | Grayson | Kentucky | 21085 | 1924 | 45 |
1054550 | 1054550 | 2021-02-22 | Green | Kentucky | 21087 | 1099 | 13 |
1054551 | 1054551 | 2021-02-22 | Greenup | Kentucky | 21089 | 3285 | 23 |
1054552 | 1054552 | 2021-02-22 | Hancock | Kentucky | 21091 | 800 | 15 |
1054553 | 1054553 | 2021-02-22 | Hardin | Kentucky | 21093 | 8676 | 88 |
1054554 | 1054554 | 2021-02-22 | Harlan | Kentucky | 21095 | 2357 | 68 |
1054555 | 1054555 | 2021-02-22 | Harrison | Kentucky | 21097 | 1481 | 9 |
1054556 | 1054556 | 2021-02-22 | Hart | Kentucky | 21099 | 1799 | 33 |
1054557 | 1054557 | 2021-02-22 | Henderson | Kentucky | 21101 | 4298 | 57 |
1054558 | 1054558 | 2021-02-22 | Henry | Kentucky | 21103 | 1198 | 7 |
1054559 | 1054559 | 2021-02-22 | Hickman | Kentucky | 21105 | 312 | 7 |
1054560 | 1054560 | 2021-02-22 | Hopkins | Kentucky | 21107 | 3866 | 128 |
1054561 | 1054561 | 2021-02-22 | Jackson | Kentucky | 21109 | 1187 | 29 |
1054562 | 1054562 | 2021-02-22 | Jefferson | Kentucky | 21111 | 73173 | 888 |
1054563 | 1054563 | 2021-02-22 | Jessamine | Kentucky | 21113 | 4054 | 49 |
1054564 | 1054564 | 2021-02-22 | Johnson | Kentucky | 21115 | 1714 | 18 |
1054565 | 1054565 | 2021-02-22 | Kenton | Kentucky | 21117 | 15174 | 125 |
1054566 | 1054566 | 2021-02-22 | Knott | Kentucky | 21119 | 1012 | 15 |
1054567 | 1054567 | 2021-02-22 | Knox | Kentucky | 21121 | 2818 | 11 |
1054568 | 1054568 | 2021-02-22 | Larue | Kentucky | 21123 | 1180 | 12 |
1054569 | 1054569 | 2021-02-22 | Laurel | Kentucky | 21125 | 5722 | 25 |
1054570 | 1054570 | 2021-02-22 | Lawrence | Kentucky | 21127 | 1202 | 18 |
1054571 | 1054571 | 2021-02-22 | Lee | Kentucky | 21129 | 1182 | 19 |
1054572 | 1054572 | 2021-02-22 | Leslie | Kentucky | 21131 | 769 | 2 |
1054573 | 1054573 | 2021-02-22 | Letcher | Kentucky | 21133 | 1646 | 18 |
1054574 | 1054574 | 2021-02-22 | Lewis | Kentucky | 21135 | 1082 | 30 |
1054575 | 1054575 | 2021-02-22 | Lincoln | Kentucky | 21137 | 2064 | 32 |
1054576 | 1054576 | 2021-02-22 | Livingston | Kentucky | 21139 | 753 | 17 |
1054577 | 1054577 | 2021-02-22 | Logan | Kentucky | 21141 | 2442 | 51 |
1054578 | 1054578 | 2021-02-22 | Lyon | Kentucky | 21143 | 474 | 13 |
1054579 | 1054579 | 2021-02-22 | Madison | Kentucky | 21151 | 8510 | 79 |
1054580 | 1054580 | 2021-02-22 | Magoffin | Kentucky | 21153 | 855 | 1 |
1054581 | 1054581 | 2021-02-22 | Marion | Kentucky | 21155 | 2124 | 24 |
1054582 | 1054582 | 2021-02-22 | Marshall | Kentucky | 21157 | 2482 | 46 |
1054583 | 1054583 | 2021-02-22 | Martin | Kentucky | 21159 | 910 | 11 |
1054584 | 1054584 | 2021-02-22 | Mason | Kentucky | 21161 | 1412 | 27 |
1054585 | 1054585 | 2021-02-22 | McCracken | Kentucky | 21145 | 5672 | 63 |
1054586 | 1054586 | 2021-02-22 | McCreary | Kentucky | 21147 | 1743 | 23 |
1054587 | 1054587 | 2021-02-22 | McLean | Kentucky | 21149 | 830 | 25 |
1054588 | 1054588 | 2021-02-22 | Meade | Kentucky | 21163 | 1819 | 13 |
1054589 | 1054589 | 2021-02-22 | Menifee | Kentucky | 21165 | 395 | 11 |
1054590 | 1054590 | 2021-02-22 | Mercer | Kentucky | 21167 | 2333 | 29 |
1054591 | 1054591 | 2021-02-22 | Metcalfe | Kentucky | 21169 | 944 | 19 |
1054592 | 1054592 | 2021-02-22 | Monroe | Kentucky | 21171 | 1245 | 38 |
1054593 | 1054593 | 2021-02-22 | Montgomery | Kentucky | 21173 | 2273 | 23 |
1054594 | 1054594 | 2021-02-22 | Morgan | Kentucky | 21175 | 2010 | 1 |
1054595 | 1054595 | 2021-02-22 | Muhlenberg | Kentucky | 21177 | 2711 | 55 |
1054596 | 1054596 | 2021-02-22 | Nelson | Kentucky | 21179 | 4535 | 33 |
1054597 | 1054597 | 2021-02-22 | Nicholas | Kentucky | 21181 | 446 | 6 |
1054598 | 1054598 | 2021-02-22 | Ohio | Kentucky | 21183 | 2312 | 47 |
1054599 | 1054599 | 2021-02-22 | Oldham | Kentucky | 21185 | 6844 | 69 |
1054600 | 1054600 | 2021-02-22 | Owen | Kentucky | 21187 | 622 | 8 |
1054601 | 1054601 | 2021-02-22 | Owsley | Kentucky | 21189 | 407 | 10 |
1054602 | 1054602 | 2021-02-22 | Pendleton | Kentucky | 21191 | 914 | 1 |
1054603 | 1054603 | 2021-02-22 | Perry | Kentucky | 21193 | 2216 | 33 |
1054604 | 1054604 | 2021-02-22 | Pike | Kentucky | 21195 | 5010 | 57 |
1054605 | 1054605 | 2021-02-22 | Powell | Kentucky | 21197 | 963 | 1 |
1054606 | 1054606 | 2021-02-22 | Pulaski | Kentucky | 21199 | 5687 | 84 |
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);