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 120
- 21097 118
- 21111 118
- 21173 114
- 21017 112
- 21179 112
- 21049 111
- 21143 109
- 21073 108
- 21117 108
- 21227 108
- 21047 107
- 21059 107
- 21101 107
- 21199 107
- 21209 107
- 21035 106
- 21005 105
- 21151 105
- 21215 105
- 21003 104
- 21025 104
- 21093 104
- 21113 104
- 21185 104
- 21141 103
- 21145 102
- 21159 102
- 21165 102
- 21177 102
- …
county >30
- Fayette 120
- Harrison 118
- Jefferson 118
- Montgomery 114
- Bourbon 112
- Nelson 112
- Clark 111
- Lyon 109
- Franklin 108
- Kenton 108
- Warren 108
- Christian 107
- Daviess 107
- Henderson 107
- Pulaski 107
- Scott 107
- Calloway 106
- Anderson 105
- Madison 105
- Spencer 105
- Allen 104
- Breathitt 104
- Hardin 104
- Jessamine 104
- Oldham 104
- Logan 103
- Martin 102
- McCracken 102
- Menifee 102
- Muhlenberg 102
- …
state 1
- Kentucky · 11,092 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
297519 | 297519 | 2020-07-03 | Adair | Kentucky | 21001 | 127 | 19 |
297520 | 297520 | 2020-07-03 | Allen | Kentucky | 21003 | 174 | 7 |
297521 | 297521 | 2020-07-03 | Anderson | Kentucky | 21005 | 29 | 1 |
297522 | 297522 | 2020-07-03 | Ballard | Kentucky | 21007 | 15 | 0 |
297523 | 297523 | 2020-07-03 | Barren | Kentucky | 21009 | 92 | 2 |
297524 | 297524 | 2020-07-03 | Bath | Kentucky | 21011 | 18 | 1 |
297525 | 297525 | 2020-07-03 | Bell | Kentucky | 21013 | 13 | 0 |
297526 | 297526 | 2020-07-03 | Boone | Kentucky | 21015 | 615 | 23 |
297527 | 297527 | 2020-07-03 | Bourbon | Kentucky | 21017 | 34 | 1 |
297528 | 297528 | 2020-07-03 | Boyd | Kentucky | 21019 | 67 | 3 |
297529 | 297529 | 2020-07-03 | Boyle | Kentucky | 21021 | 40 | 0 |
297530 | 297530 | 2020-07-03 | Bracken | Kentucky | 21023 | 17 | 0 |
297531 | 297531 | 2020-07-03 | Breathitt | Kentucky | 21025 | 9 | 0 |
297532 | 297532 | 2020-07-03 | Breckinridge | Kentucky | 21027 | 25 | 2 |
297533 | 297533 | 2020-07-03 | Bullitt | Kentucky | 21029 | 154 | 4 |
297534 | 297534 | 2020-07-03 | Butler | Kentucky | 21031 | 257 | 14 |
297535 | 297535 | 2020-07-03 | Caldwell | Kentucky | 21033 | 15 | 0 |
297536 | 297536 | 2020-07-03 | Calloway | Kentucky | 21035 | 86 | 1 |
297537 | 297537 | 2020-07-03 | Campbell | Kentucky | 21037 | 270 | 13 |
297538 | 297538 | 2020-07-03 | Carlisle | Kentucky | 21039 | 5 | 1 |
297539 | 297539 | 2020-07-03 | Carroll | Kentucky | 21041 | 42 | 1 |
297540 | 297540 | 2020-07-03 | Carter | Kentucky | 21043 | 29 | 0 |
297541 | 297541 | 2020-07-03 | Casey | Kentucky | 21045 | 21 | 0 |
297542 | 297542 | 2020-07-03 | Christian | Kentucky | 21047 | 262 | 4 |
297543 | 297543 | 2020-07-03 | Clark | Kentucky | 21049 | 99 | 5 |
297544 | 297544 | 2020-07-03 | Clay | Kentucky | 21051 | 68 | 3 |
297545 | 297545 | 2020-07-03 | Clinton | Kentucky | 21053 | 5 | 0 |
297546 | 297546 | 2020-07-03 | Crittenden | Kentucky | 21055 | 9 | 1 |
297547 | 297547 | 2020-07-03 | Cumberland | Kentucky | 21057 | 6 | 0 |
297548 | 297548 | 2020-07-03 | Daviess | Kentucky | 21059 | 452 | 8 |
297549 | 297549 | 2020-07-03 | Edmonson | Kentucky | 21061 | 84 | 11 |
297550 | 297550 | 2020-07-03 | Elliott | Kentucky | 21063 | 3 | 0 |
297551 | 297551 | 2020-07-03 | Estill | Kentucky | 21065 | 4 | 0 |
297552 | 297552 | 2020-07-03 | Fayette | Kentucky | 21067 | 1637 | 30 |
297553 | 297553 | 2020-07-03 | Fleming | Kentucky | 21069 | 21 | 0 |
297554 | 297554 | 2020-07-03 | Floyd | Kentucky | 21071 | 32 | 0 |
297555 | 297555 | 2020-07-03 | Franklin | Kentucky | 21073 | 144 | 4 |
297556 | 297556 | 2020-07-03 | Fulton | Kentucky | 21075 | 24 | 0 |
297557 | 297557 | 2020-07-03 | Gallatin | Kentucky | 21077 | 65 | 8 |
297558 | 297558 | 2020-07-03 | Garrard | Kentucky | 21079 | 26 | 0 |
297559 | 297559 | 2020-07-03 | Grant | Kentucky | 21081 | 60 | 4 |
297560 | 297560 | 2020-07-03 | Graves | Kentucky | 21083 | 219 | 21 |
297561 | 297561 | 2020-07-03 | Grayson | Kentucky | 21085 | 140 | 11 |
297562 | 297562 | 2020-07-03 | Green | Kentucky | 21087 | 5 | 1 |
297563 | 297563 | 2020-07-03 | Greenup | Kentucky | 21089 | 33 | 0 |
297564 | 297564 | 2020-07-03 | Hancock | Kentucky | 21091 | 19 | 0 |
297565 | 297565 | 2020-07-03 | Hardin | Kentucky | 21093 | 177 | 6 |
297566 | 297566 | 2020-07-03 | Harlan | Kentucky | 21095 | 27 | 2 |
297567 | 297567 | 2020-07-03 | Harrison | Kentucky | 21097 | 74 | 0 |
297568 | 297568 | 2020-07-03 | Hart | Kentucky | 21099 | 49 | 0 |
297569 | 297569 | 2020-07-03 | Henderson | Kentucky | 21101 | 170 | 4 |
297570 | 297570 | 2020-07-03 | Henry | Kentucky | 21103 | 36 | 2 |
297571 | 297571 | 2020-07-03 | Hickman | Kentucky | 21105 | 5 | 0 |
297572 | 297572 | 2020-07-03 | Hopkins | Kentucky | 21107 | 266 | 34 |
297573 | 297573 | 2020-07-03 | Jackson | Kentucky | 21109 | 114 | 14 |
297574 | 297574 | 2020-07-03 | Jefferson | Kentucky | 21111 | 4034 | 211 |
297575 | 297575 | 2020-07-03 | Jessamine | Kentucky | 21113 | 111 | 0 |
297576 | 297576 | 2020-07-03 | Johnson | Kentucky | 21115 | 10 | 0 |
297577 | 297577 | 2020-07-03 | Kenton | Kentucky | 21117 | 814 | 37 |
297578 | 297578 | 2020-07-03 | Knott | Kentucky | 21119 | 11 | 0 |
297579 | 297579 | 2020-07-03 | Knox | Kentucky | 21121 | 73 | 0 |
297580 | 297580 | 2020-07-03 | Larue | Kentucky | 21123 | 17 | 1 |
297581 | 297581 | 2020-07-03 | Laurel | Kentucky | 21125 | 124 | 3 |
297582 | 297582 | 2020-07-03 | Lawrence | Kentucky | 21127 | 9 | 0 |
297583 | 297583 | 2020-07-03 | Lee | Kentucky | 21129 | 1 | 0 |
297584 | 297584 | 2020-07-03 | Leslie | Kentucky | 21131 | 10 | 0 |
297585 | 297585 | 2020-07-03 | Letcher | Kentucky | 21133 | 14 | 0 |
297586 | 297586 | 2020-07-03 | Lewis | Kentucky | 21135 | 22 | 0 |
297587 | 297587 | 2020-07-03 | Lincoln | Kentucky | 21137 | 30 | 1 |
297588 | 297588 | 2020-07-03 | Livingston | Kentucky | 21139 | 10 | 0 |
297589 | 297589 | 2020-07-03 | Logan | Kentucky | 21141 | 227 | 15 |
297590 | 297590 | 2020-07-03 | Lyon | Kentucky | 21143 | 20 | 3 |
297591 | 297591 | 2020-07-03 | Madison | Kentucky | 21151 | 130 | 1 |
297592 | 297592 | 2020-07-03 | Magoffin | Kentucky | 21153 | 6 | 0 |
297593 | 297593 | 2020-07-03 | Marion | Kentucky | 21155 | 52 | 0 |
297594 | 297594 | 2020-07-03 | Marshall | Kentucky | 21157 | 60 | 2 |
297595 | 297595 | 2020-07-03 | Martin | Kentucky | 21159 | 8 | 0 |
297596 | 297596 | 2020-07-03 | Mason | Kentucky | 21161 | 33 | 0 |
297597 | 297597 | 2020-07-03 | McCracken | Kentucky | 21145 | 172 | 3 |
297598 | 297598 | 2020-07-03 | McCreary | Kentucky | 21147 | 18 | 0 |
297599 | 297599 | 2020-07-03 | McLean | Kentucky | 21149 | 27 | 0 |
297600 | 297600 | 2020-07-03 | Meade | Kentucky | 21163 | 28 | 2 |
297601 | 297601 | 2020-07-03 | Menifee | Kentucky | 21165 | 13 | 0 |
297602 | 297602 | 2020-07-03 | Mercer | Kentucky | 21167 | 24 | 0 |
297603 | 297603 | 2020-07-03 | Metcalfe | Kentucky | 21169 | 11 | 2 |
297604 | 297604 | 2020-07-03 | Monroe | Kentucky | 21171 | 40 | 1 |
297605 | 297605 | 2020-07-03 | Montgomery | Kentucky | 21173 | 58 | 0 |
297606 | 297606 | 2020-07-03 | Morgan | Kentucky | 21175 | 9 | 0 |
297607 | 297607 | 2020-07-03 | Muhlenberg | Kentucky | 21177 | 527 | 8 |
297608 | 297608 | 2020-07-03 | Nelson | Kentucky | 21179 | 81 | 1 |
297609 | 297609 | 2020-07-03 | Nicholas | Kentucky | 21181 | 8 | 0 |
297610 | 297610 | 2020-07-03 | Ohio | Kentucky | 21183 | 208 | 0 |
297611 | 297611 | 2020-07-03 | Oldham | Kentucky | 21185 | 139 | 7 |
297612 | 297612 | 2020-07-03 | Owen | Kentucky | 21187 | 7 | 0 |
297613 | 297613 | 2020-07-03 | Owsley | Kentucky | 21189 | 3 | 0 |
297614 | 297614 | 2020-07-03 | Pendleton | Kentucky | 21191 | 19 | 0 |
297615 | 297615 | 2020-07-03 | Perry | Kentucky | 21193 | 62 | 1 |
297616 | 297616 | 2020-07-03 | Pike | Kentucky | 21195 | 99 | 2 |
297617 | 297617 | 2020-07-03 | Powell | Kentucky | 21197 | 8 | 0 |
297618 | 297618 | 2020-07-03 | Pulaski | Kentucky | 21199 | 100 | 2 |
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);