ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where "date" is on date 2020-09-14 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
532266 | 532266 | 2020-09-14 | McLean | Kentucky | 21149 | 66 | 0 |
532267 | 532267 | 2020-09-14 | Meade | Kentucky | 21163 | 179 | 3 |
532268 | 532268 | 2020-09-14 | Menifee | Kentucky | 21165 | 40 | 0 |
532269 | 532269 | 2020-09-14 | Mercer | Kentucky | 21167 | 165 | 1 |
532270 | 532270 | 2020-09-14 | Metcalfe | Kentucky | 21169 | 98 | 2 |
532271 | 532271 | 2020-09-14 | Monroe | Kentucky | 21171 | 185 | 4 |
532272 | 532272 | 2020-09-14 | Montgomery | Kentucky | 21173 | 220 | 1 |
532273 | 532273 | 2020-09-14 | Morgan | Kentucky | 21175 | 50 | 0 |
532274 | 532274 | 2020-09-14 | Muhlenberg | Kentucky | 21177 | 727 | 13 |
532275 | 532275 | 2020-09-14 | Nelson | Kentucky | 21179 | 449 | 4 |
532276 | 532276 | 2020-09-14 | Nicholas | Kentucky | 21181 | 29 | 1 |
532277 | 532277 | 2020-09-14 | Ohio | Kentucky | 21183 | 440 | 9 |
532278 | 532278 | 2020-09-14 | Oldham | Kentucky | 21185 | 955 | 25 |
532279 | 532279 | 2020-09-14 | Owen | Kentucky | 21187 | 89 | 2 |
532280 | 532280 | 2020-09-14 | Owsley | Kentucky | 21189 | 37 | 1 |
532281 | 532281 | 2020-09-14 | Pendleton | Kentucky | 21191 | 88 | 0 |
532282 | 532282 | 2020-09-14 | Perry | Kentucky | 21193 | 310 | 8 |
532283 | 532283 | 2020-09-14 | Pike | Kentucky | 21195 | 369 | 3 |
532284 | 532284 | 2020-09-14 | Powell | Kentucky | 21197 | 87 | 0 |
532285 | 532285 | 2020-09-14 | Pulaski | Kentucky | 21199 | 703 | 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);