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 2022-02-10 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2201221 | 2201221 | 2022-02-10 | Adair | Kentucky | 21001 | 5072 | 96 |
2201222 | 2201222 | 2022-02-10 | Allen | Kentucky | 21003 | 6267 | 92 |
2201223 | 2201223 | 2022-02-10 | Anderson | Kentucky | 21005 | 5848 | 60 |
2201224 | 2201224 | 2022-02-10 | Ballard | Kentucky | 21007 | 1216 | 27 |
2201225 | 2201225 | 2022-02-10 | Barren | Kentucky | 21009 | 12038 | 195 |
2201226 | 2201226 | 2022-02-10 | Bath | Kentucky | 21011 | 2588 | 35 |
2201227 | 2201227 | 2022-02-10 | Bell | Kentucky | 21013 | 8241 | 124 |
2201228 | 2201228 | 2022-02-10 | Boone | Kentucky | 21015 | 37978 | 264 |
2201229 | 2201229 | 2022-02-10 | Bourbon | Kentucky | 21017 | 5576 | 47 |
2201230 | 2201230 | 2022-02-10 | Boyd | Kentucky | 21019 | 15125 | 153 |
2201231 | 2201231 | 2022-02-10 | Boyle | Kentucky | 21021 | 7795 | 120 |
2201232 | 2201232 | 2022-02-10 | Bracken | Kentucky | 21023 | 2041 | 23 |
2201233 | 2201233 | 2022-02-10 | Breathitt | Kentucky | 21025 | 3193 | 50 |
2201234 | 2201234 | 2022-02-10 | Breckinridge | Kentucky | 21027 | 4820 | 65 |
2201235 | 2201235 | 2022-02-10 | Bullitt | Kentucky | 21029 | 20344 | 176 |
2201236 | 2201236 | 2022-02-10 | Butler | Kentucky | 21031 | 3445 | 49 |
2201237 | 2201237 | 2022-02-10 | Caldwell | Kentucky | 21033 | 3722 | 57 |
2201238 | 2201238 | 2022-02-10 | Calloway | Kentucky | 21035 | 7749 | 73 |
2201239 | 2201239 | 2022-02-10 | Campbell | Kentucky | 21037 | 23624 | 147 |
2201240 | 2201240 | 2022-02-10 | Carlisle | Kentucky | 21039 | 934 | 17 |
2201241 | 2201241 | 2022-02-10 | Carroll | Kentucky | 21041 | 3337 | 40 |
2201242 | 2201242 | 2022-02-10 | Carter | Kentucky | 21043 | 7792 | 94 |
2201243 | 2201243 | 2022-02-10 | Casey | Kentucky | 21045 | 3613 | 65 |
2201244 | 2201244 | 2022-02-10 | Christian | Kentucky | 21047 | 14563 | 191 |
2201245 | 2201245 | 2022-02-10 | Clark | Kentucky | 21049 | 9260 | 51 |
2201246 | 2201246 | 2022-02-10 | Clay | Kentucky | 21051 | 7209 | 72 |
2201247 | 2201247 | 2022-02-10 | Clinton | Kentucky | 21053 | 3165 | 41 |
2201248 | 2201248 | 2022-02-10 | Crittenden | Kentucky | 21055 | 1920 | 41 |
2201249 | 2201249 | 2022-02-10 | Cumberland | Kentucky | 21057 | 2034 | 24 |
2201250 | 2201250 | 2022-02-10 | Daviess | Kentucky | 21059 | 29863 | 349 |
2201251 | 2201251 | 2022-02-10 | Edmonson | Kentucky | 21061 | 2394 | 37 |
2201252 | 2201252 | 2022-02-10 | Elliott | Kentucky | 21063 | 1886 | 15 |
2201253 | 2201253 | 2022-02-10 | Estill | Kentucky | 21065 | 3684 | 40 |
2201254 | 2201254 | 2022-02-10 | Fayette | Kentucky | 21067 | 88938 | 528 |
2201255 | 2201255 | 2022-02-10 | Fleming | Kentucky | 21069 | 3426 | 44 |
2201256 | 2201256 | 2022-02-10 | Floyd | Kentucky | 21071 | 11099 | 155 |
2201257 | 2201257 | 2022-02-10 | Franklin | Kentucky | 21073 | 12468 | 126 |
2201258 | 2201258 | 2022-02-10 | Fulton | Kentucky | 21075 | 1121 | 23 |
2201259 | 2201259 | 2022-02-10 | Gallatin | Kentucky | 21077 | 2120 | 45 |
2201260 | 2201260 | 2022-02-10 | Garrard | Kentucky | 21079 | 4497 | 66 |
2201261 | 2201261 | 2022-02-10 | Grant | Kentucky | 21081 | 7263 | 55 |
2201262 | 2201262 | 2022-02-10 | Graves | Kentucky | 21083 | 10969 | 146 |
2201263 | 2201263 | 2022-02-10 | Grayson | Kentucky | 21085 | 7491 | 114 |
2201264 | 2201264 | 2022-02-10 | Green | Kentucky | 21087 | 3293 | 40 |
2201265 | 2201265 | 2022-02-10 | Greenup | Kentucky | 21089 | 11225 | 114 |
2201266 | 2201266 | 2022-02-10 | Hancock | Kentucky | 21091 | 2364 | 20 |
2201267 | 2201267 | 2022-02-10 | Hardin | Kentucky | 21093 | 31248 | 389 |
2201268 | 2201268 | 2022-02-10 | Harlan | Kentucky | 21095 | 8542 | 174 |
2201269 | 2201269 | 2022-02-10 | Harrison | Kentucky | 21097 | 5875 | 58 |
2201270 | 2201270 | 2022-02-10 | Hart | Kentucky | 21099 | 5146 | 88 |
2201271 | 2201271 | 2022-02-10 | Henderson | Kentucky | 21101 | 13001 | 144 |
2201272 | 2201272 | 2022-02-10 | Henry | Kentucky | 21103 | 4598 | 44 |
2201273 | 2201273 | 2022-02-10 | Hickman | Kentucky | 21105 | 797 | 22 |
2201274 | 2201274 | 2022-02-10 | Hopkins | Kentucky | 21107 | 13928 | 235 |
2201275 | 2201275 | 2022-02-10 | Jackson | Kentucky | 21109 | 3944 | 65 |
2201276 | 2201276 | 2022-02-10 | Jefferson | Kentucky | 21111 | 212825 | 1988 |
2201277 | 2201277 | 2022-02-10 | Jessamine | Kentucky | 21113 | 14437 | 124 |
2201278 | 2201278 | 2022-02-10 | Johnson | Kentucky | 21115 | 5536 | 86 |
2201279 | 2201279 | 2022-02-10 | Kenton | Kentucky | 21117 | 43973 | 356 |
2201280 | 2201280 | 2022-02-10 | Knott | Kentucky | 21119 | 3628 | 53 |
2201281 | 2201281 | 2022-02-10 | Knox | Kentucky | 21121 | 10689 | 119 |
2201282 | 2201282 | 2022-02-10 | Larue | Kentucky | 21123 | 3532 | 64 |
2201283 | 2201283 | 2022-02-10 | Laurel | Kentucky | 21125 | 17199 | 195 |
2201284 | 2201284 | 2022-02-10 | Lawrence | Kentucky | 21127 | 4135 | 56 |
2201285 | 2201285 | 2022-02-10 | Lee | Kentucky | 21129 | 2428 | 45 |
2201286 | 2201286 | 2022-02-10 | Leslie | Kentucky | 21131 | 3243 | 39 |
2201287 | 2201287 | 2022-02-10 | Letcher | Kentucky | 21133 | 6196 | 90 |
2201288 | 2201288 | 2022-02-10 | Lewis | Kentucky | 21135 | 4196 | 74 |
2201289 | 2201289 | 2022-02-10 | Lincoln | Kentucky | 21137 | 5868 | 118 |
2201290 | 2201290 | 2022-02-10 | Livingston | Kentucky | 21139 | 2160 | 54 |
2201291 | 2201291 | 2022-02-10 | Logan | Kentucky | 21141 | 7916 | 108 |
2201292 | 2201292 | 2022-02-10 | Lyon | Kentucky | 21143 | 2666 | 32 |
2201293 | 2201293 | 2022-02-10 | Madison | Kentucky | 21151 | 26295 | 234 |
2201294 | 2201294 | 2022-02-10 | Magoffin | Kentucky | 21153 | 3519 | 38 |
2201295 | 2201295 | 2022-02-10 | Marion | Kentucky | 21155 | 6144 | 67 |
2201296 | 2201296 | 2022-02-10 | Marshall | Kentucky | 21157 | 8073 | 92 |
2201297 | 2201297 | 2022-02-10 | Martin | Kentucky | 21159 | 2958 | 44 |
2201298 | 2201298 | 2022-02-10 | Mason | Kentucky | 21161 | 4368 | 93 |
2201299 | 2201299 | 2022-02-10 | McCracken | Kentucky | 21145 | 17258 | 213 |
2201300 | 2201300 | 2022-02-10 | McCreary | Kentucky | 21147 | 4674 | 71 |
2201301 | 2201301 | 2022-02-10 | McLean | Kentucky | 21149 | 2527 | 44 |
2201302 | 2201302 | 2022-02-10 | Meade | Kentucky | 21163 | 5536 | 61 |
2201303 | 2201303 | 2022-02-10 | Menifee | Kentucky | 21165 | 1295 | 30 |
2201304 | 2201304 | 2022-02-10 | Mercer | Kentucky | 21167 | 6969 | 98 |
2201305 | 2201305 | 2022-02-10 | Metcalfe | Kentucky | 21169 | 2668 | 54 |
2201306 | 2201306 | 2022-02-10 | Monroe | Kentucky | 21171 | 3485 | 70 |
2201307 | 2201307 | 2022-02-10 | Montgomery | Kentucky | 21173 | 6106 | 85 |
2201308 | 2201308 | 2022-02-10 | Morgan | Kentucky | 21175 | 4132 | 17 |
2201309 | 2201309 | 2022-02-10 | Muhlenberg | Kentucky | 21177 | 9750 | 110 |
2201310 | 2201310 | 2022-02-10 | Nelson | Kentucky | 21179 | 13855 | 128 |
2201311 | 2201311 | 2022-02-10 | Nicholas | Kentucky | 21181 | 1780 | 29 |
2201312 | 2201312 | 2022-02-10 | Ohio | Kentucky | 21183 | 7023 | 92 |
2201313 | 2201313 | 2022-02-10 | Oldham | Kentucky | 21185 | 17322 | 121 |
2201314 | 2201314 | 2022-02-10 | Owen | Kentucky | 21187 | 2286 | 32 |
2201315 | 2201315 | 2022-02-10 | Owsley | Kentucky | 21189 | 1413 | 23 |
2201316 | 2201316 | 2022-02-10 | Pendleton | Kentucky | 21191 | 3336 | 33 |
2201317 | 2201317 | 2022-02-10 | Perry | Kentucky | 21193 | 9307 | 141 |
2201318 | 2201318 | 2022-02-10 | Pike | Kentucky | 21195 | 16285 | 241 |
2201319 | 2201319 | 2022-02-10 | Powell | Kentucky | 21197 | 4429 | 32 |
2201320 | 2201320 | 2022-02-10 | Pulaski | Kentucky | 21199 | 14764 | 251 |
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);