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 591
- 21097 589
- 21111 589
- 21173 585
- 21017 583
- 21179 583
- 21049 582
- 21143 580
- 21073 579
- 21117 579
- 21227 579
- 21047 578
- 21059 578
- 21101 578
- 21199 578
- 21209 578
- 21035 577
- 21005 576
- 21151 576
- 21215 576
- 21003 575
- 21025 575
- 21093 575
- 21113 575
- 21185 575
- 21141 574
- 21145 573
- 21159 573
- 21165 573
- 21177 573
- …
county >30
- Fayette 591
- Harrison 589
- Jefferson 589
- Montgomery 585
- Bourbon 583
- Nelson 583
- Clark 582
- Lyon 580
- Franklin 579
- Kenton 579
- Warren 579
- Christian 578
- Daviess 578
- Henderson 578
- Pulaski 578
- Scott 578
- Calloway 577
- Anderson 576
- Madison 576
- Spencer 576
- Allen 575
- Breathitt 575
- Hardin 575
- Jessamine 575
- Oldham 575
- Logan 574
- Martin 573
- McCracken 573
- Menifee 573
- Muhlenberg 573
- …
state 1
- Kentucky · 67,612 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1824114 | 1824114 | 2021-10-17 | Adair | Kentucky | 21001 | 3358 | 76 |
1824115 | 1824115 | 2021-10-17 | Allen | Kentucky | 21003 | 3730 | 63 |
1824116 | 1824116 | 2021-10-17 | Anderson | Kentucky | 21005 | 3292 | 40 |
1824117 | 1824117 | 2021-10-17 | Ballard | Kentucky | 21007 | 657 | 19 |
1824118 | 1824118 | 2021-10-17 | Barren | Kentucky | 21009 | 7814 | 133 |
1824119 | 1824119 | 2021-10-17 | Bath | Kentucky | 21011 | 1554 | 29 |
1824120 | 1824120 | 2021-10-17 | Bell | Kentucky | 21013 | 5736 | 90 |
1824121 | 1824121 | 2021-10-17 | Boone | Kentucky | 21015 | 20474 | 197 |
1824122 | 1824122 | 2021-10-17 | Bourbon | Kentucky | 21017 | 3099 | 32 |
1824123 | 1824123 | 2021-10-17 | Boyd | Kentucky | 21019 | 8188 | 98 |
1824124 | 1824124 | 2021-10-17 | Boyle | Kentucky | 21021 | 5273 | 79 |
1824125 | 1824125 | 2021-10-17 | Bracken | Kentucky | 21023 | 1075 | 8 |
1824126 | 1824126 | 2021-10-17 | Breathitt | Kentucky | 21025 | 1964 | 24 |
1824127 | 1824127 | 2021-10-17 | Breckinridge | Kentucky | 21027 | 2635 | 30 |
1824128 | 1824128 | 2021-10-17 | Bullitt | Kentucky | 21029 | 11794 | 118 |
1824129 | 1824129 | 2021-10-17 | Butler | Kentucky | 21031 | 2295 | 32 |
1824130 | 1824130 | 2021-10-17 | Caldwell | Kentucky | 21033 | 2269 | 46 |
1824131 | 1824131 | 2021-10-17 | Calloway | Kentucky | 21035 | 5111 | 60 |
1824132 | 1824132 | 2021-10-17 | Campbell | Kentucky | 21037 | 12793 | 97 |
1824133 | 1824133 | 2021-10-17 | Carlisle | Kentucky | 21039 | 618 | 11 |
1824134 | 1824134 | 2021-10-17 | Carroll | Kentucky | 21041 | 1827 | 26 |
1824135 | 1824135 | 2021-10-17 | Carter | Kentucky | 21043 | 4475 | 57 |
1824136 | 1824136 | 2021-10-17 | Casey | Kentucky | 21045 | 2793 | 53 |
1824137 | 1824137 | 2021-10-17 | Christian | Kentucky | 21047 | 10093 | 125 |
1824138 | 1824138 | 2021-10-17 | Clark | Kentucky | 21049 | 5098 | 36 |
1824139 | 1824139 | 2021-10-17 | Clay | Kentucky | 21051 | 5069 | 56 |
1824140 | 1824140 | 2021-10-17 | Clinton | Kentucky | 21053 | 2172 | 34 |
1824141 | 1824141 | 2021-10-17 | Crittenden | Kentucky | 21055 | 1158 | 35 |
1824142 | 1824142 | 2021-10-17 | Cumberland | Kentucky | 21057 | 1201 | 19 |
1824143 | 1824143 | 2021-10-17 | Daviess | Kentucky | 21059 | 16609 | 259 |
1824144 | 1824144 | 2021-10-17 | Edmonson | Kentucky | 21061 | 1520 | 28 |
1824145 | 1824145 | 2021-10-17 | Elliott | Kentucky | 21063 | 1300 | 7 |
1824146 | 1824146 | 2021-10-17 | Estill | Kentucky | 21065 | 2172 | 12 |
1824147 | 1824147 | 2021-10-17 | Fayette | Kentucky | 21067 | 50887 | 383 |
1824148 | 1824148 | 2021-10-17 | Fleming | Kentucky | 21069 | 2087 | 32 |
1824149 | 1824149 | 2021-10-17 | Floyd | Kentucky | 21071 | 6898 | 109 |
1824150 | 1824150 | 2021-10-17 | Franklin | Kentucky | 21073 | 6786 | 75 |
1824151 | 1824151 | 2021-10-17 | Fulton | Kentucky | 21075 | 728 | 16 |
1824152 | 1824152 | 2021-10-17 | Gallatin | Kentucky | 21077 | 1207 | 38 |
1824153 | 1824153 | 2021-10-17 | Garrard | Kentucky | 21079 | 2741 | 45 |
1824154 | 1824154 | 2021-10-17 | Grant | Kentucky | 21081 | 4199 | 35 |
1824155 | 1824155 | 2021-10-17 | Graves | Kentucky | 21083 | 7113 | 120 |
1824156 | 1824156 | 2021-10-17 | Grayson | Kentucky | 21085 | 4597 | 84 |
1824157 | 1824157 | 2021-10-17 | Green | Kentucky | 21087 | 2416 | 32 |
1824158 | 1824158 | 2021-10-17 | Greenup | Kentucky | 21089 | 6196 | 78 |
1824159 | 1824159 | 2021-10-17 | Hancock | Kentucky | 21091 | 1373 | 17 |
1824160 | 1824160 | 2021-10-17 | Hardin | Kentucky | 21093 | 17643 | 252 |
1824161 | 1824161 | 2021-10-17 | Harlan | Kentucky | 21095 | 5276 | 124 |
1824162 | 1824162 | 2021-10-17 | Harrison | Kentucky | 21097 | 3206 | 35 |
1824163 | 1824163 | 2021-10-17 | Hart | Kentucky | 21099 | 3447 | 61 |
1824164 | 1824164 | 2021-10-17 | Henderson | Kentucky | 21101 | 7864 | 98 |
1824165 | 1824165 | 2021-10-17 | Henry | Kentucky | 21103 | 2510 | 24 |
1824166 | 1824166 | 2021-10-17 | Hickman | Kentucky | 21105 | 547 | 19 |
1824167 | 1824167 | 2021-10-17 | Hopkins | Kentucky | 21107 | 7895 | 192 |
1824168 | 1824168 | 2021-10-17 | Jackson | Kentucky | 21109 | 2547 | 49 |
1824169 | 1824169 | 2021-10-17 | Jefferson | Kentucky | 21111 | 117371 | 1556 |
1824170 | 1824170 | 2021-10-17 | Jessamine | Kentucky | 21113 | 7932 | 90 |
1824171 | 1824171 | 2021-10-17 | Johnson | Kentucky | 21115 | 3646 | 46 |
1824172 | 1824172 | 2021-10-17 | Kenton | Kentucky | 21117 | 24161 | 257 |
1824173 | 1824173 | 2021-10-17 | Knott | Kentucky | 21119 | 2363 | 36 |
1824174 | 1824174 | 2021-10-17 | Knox | Kentucky | 21121 | 7094 | 52 |
1824175 | 1824175 | 2021-10-17 | Larue | Kentucky | 21123 | 2357 | 45 |
1824176 | 1824176 | 2021-10-17 | Laurel | Kentucky | 21125 | 12677 | 111 |
1824177 | 1824177 | 2021-10-17 | Lawrence | Kentucky | 21127 | 2556 | 38 |
1824178 | 1824178 | 2021-10-17 | Lee | Kentucky | 21129 | 1710 | 31 |
1824179 | 1824179 | 2021-10-17 | Leslie | Kentucky | 21131 | 2122 | 18 |
1824180 | 1824180 | 2021-10-17 | Letcher | Kentucky | 21133 | 3750 | 65 |
1824181 | 1824181 | 2021-10-17 | Lewis | Kentucky | 21135 | 2462 | 55 |
1824182 | 1824182 | 2021-10-17 | Lincoln | Kentucky | 21137 | 4230 | 80 |
1824183 | 1824183 | 2021-10-17 | Livingston | Kentucky | 21139 | 1371 | 41 |
1824184 | 1824184 | 2021-10-17 | Logan | Kentucky | 21141 | 4994 | 79 |
1824185 | 1824185 | 2021-10-17 | Lyon | Kentucky | 21143 | 1925 | 26 |
1824186 | 1824186 | 2021-10-17 | Madison | Kentucky | 21151 | 15532 | 145 |
1824187 | 1824187 | 2021-10-17 | Magoffin | Kentucky | 21153 | 2152 | 20 |
1824188 | 1824188 | 2021-10-17 | Marion | Kentucky | 21155 | 3824 | 43 |
1824189 | 1824189 | 2021-10-17 | Marshall | Kentucky | 21157 | 4967 | 76 |
1824190 | 1824190 | 2021-10-17 | Martin | Kentucky | 21159 | 1848 | 35 |
1824191 | 1824191 | 2021-10-17 | Mason | Kentucky | 21161 | 2489 | 62 |
1824192 | 1824192 | 2021-10-17 | McCracken | Kentucky | 21145 | 9898 | 167 |
1824193 | 1824193 | 2021-10-17 | McCreary | Kentucky | 21147 | 3655 | 51 |
1824194 | 1824194 | 2021-10-17 | McLean | Kentucky | 21149 | 1439 | 37 |
1824195 | 1824195 | 2021-10-17 | Meade | Kentucky | 21163 | 3420 | 35 |
1824196 | 1824196 | 2021-10-17 | Menifee | Kentucky | 21165 | 813 | 21 |
1824197 | 1824197 | 2021-10-17 | Mercer | Kentucky | 21167 | 4370 | 72 |
1824198 | 1824198 | 2021-10-17 | Metcalfe | Kentucky | 21169 | 1868 | 38 |
1824199 | 1824199 | 2021-10-17 | Monroe | Kentucky | 21171 | 2240 | 59 |
1824200 | 1824200 | 2021-10-17 | Montgomery | Kentucky | 21173 | 4401 | 51 |
1824201 | 1824201 | 2021-10-17 | Morgan | Kentucky | 21175 | 2822 | 6 |
1824202 | 1824202 | 2021-10-17 | Muhlenberg | Kentucky | 21177 | 5487 | 87 |
1824203 | 1824203 | 2021-10-17 | Nelson | Kentucky | 21179 | 8134 | 77 |
1824204 | 1824204 | 2021-10-17 | Nicholas | Kentucky | 21181 | 1132 | 17 |
1824205 | 1824205 | 2021-10-17 | Ohio | Kentucky | 21183 | 4276 | 78 |
1824206 | 1824206 | 2021-10-17 | Oldham | Kentucky | 21185 | 9940 | 91 |
1824207 | 1824207 | 2021-10-17 | Owen | Kentucky | 21187 | 1335 | 22 |
1824208 | 1824208 | 2021-10-17 | Owsley | Kentucky | 21189 | 970 | 15 |
1824209 | 1824209 | 2021-10-17 | Pendleton | Kentucky | 21191 | 1991 | 16 |
1824210 | 1824210 | 2021-10-17 | Perry | Kentucky | 21193 | 5962 | 87 |
1824211 | 1824211 | 2021-10-17 | Pike | Kentucky | 21195 | 10393 | 159 |
1824212 | 1824212 | 2021-10-17 | Powell | Kentucky | 21197 | 2442 | 21 |
1824213 | 1824213 | 2021-10-17 | Pulaski | Kentucky | 21199 | 11114 | 181 |
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);