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-07-13 and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
329247 | 329247 | 2020-07-13 | Adair | Kentucky | 21001 | 160 | 19 |
329248 | 329248 | 2020-07-13 | Allen | Kentucky | 21003 | 191 | 7 |
329249 | 329249 | 2020-07-13 | Anderson | Kentucky | 21005 | 31 | 1 |
329250 | 329250 | 2020-07-13 | Ballard | Kentucky | 21007 | 18 | 0 |
329251 | 329251 | 2020-07-13 | Barren | Kentucky | 21009 | 129 | 2 |
329252 | 329252 | 2020-07-13 | Bath | Kentucky | 21011 | 21 | 1 |
329253 | 329253 | 2020-07-13 | Bell | Kentucky | 21013 | 105 | 0 |
329254 | 329254 | 2020-07-13 | Boone | Kentucky | 21015 | 733 | 23 |
329255 | 329255 | 2020-07-13 | Bourbon | Kentucky | 21017 | 46 | 1 |
329256 | 329256 | 2020-07-13 | Boyd | Kentucky | 21019 | 93 | 3 |
329257 | 329257 | 2020-07-13 | Boyle | Kentucky | 21021 | 48 | 0 |
329258 | 329258 | 2020-07-13 | Bracken | Kentucky | 21023 | 19 | 0 |
329259 | 329259 | 2020-07-13 | Breathitt | Kentucky | 21025 | 15 | 0 |
329260 | 329260 | 2020-07-13 | Breckinridge | Kentucky | 21027 | 30 | 2 |
329261 | 329261 | 2020-07-13 | Bullitt | Kentucky | 21029 | 174 | 4 |
329262 | 329262 | 2020-07-13 | Butler | Kentucky | 21031 | 266 | 14 |
329263 | 329263 | 2020-07-13 | Caldwell | Kentucky | 21033 | 34 | 0 |
329264 | 329264 | 2020-07-13 | Calloway | Kentucky | 21035 | 111 | 1 |
329265 | 329265 | 2020-07-13 | Campbell | Kentucky | 21037 | 333 | 13 |
329266 | 329266 | 2020-07-13 | Carlisle | Kentucky | 21039 | 11 | 1 |
329267 | 329267 | 2020-07-13 | Carroll | Kentucky | 21041 | 85 | 1 |
329268 | 329268 | 2020-07-13 | Carter | Kentucky | 21043 | 38 | 0 |
329269 | 329269 | 2020-07-13 | Casey | Kentucky | 21045 | 98 | 3 |
329270 | 329270 | 2020-07-13 | Christian | Kentucky | 21047 | 343 | 4 |
329271 | 329271 | 2020-07-13 | Clark | Kentucky | 21049 | 114 | 6 |
329272 | 329272 | 2020-07-13 | Clay | Kentucky | 21051 | 85 | 4 |
329273 | 329273 | 2020-07-13 | Clinton | Kentucky | 21053 | 9 | 0 |
329274 | 329274 | 2020-07-13 | Crittenden | Kentucky | 21055 | 12 | 1 |
329275 | 329275 | 2020-07-13 | Cumberland | Kentucky | 21057 | 13 | 0 |
329276 | 329276 | 2020-07-13 | Daviess | Kentucky | 21059 | 511 | 8 |
329277 | 329277 | 2020-07-13 | Edmonson | Kentucky | 21061 | 84 | 12 |
329278 | 329278 | 2020-07-13 | Elliott | Kentucky | 21063 | 3 | 0 |
329279 | 329279 | 2020-07-13 | Estill | Kentucky | 21065 | 6 | 0 |
329280 | 329280 | 2020-07-13 | Fayette | Kentucky | 21067 | 2076 | 36 |
329281 | 329281 | 2020-07-13 | Fleming | Kentucky | 21069 | 31 | 0 |
329282 | 329282 | 2020-07-13 | Floyd | Kentucky | 21071 | 40 | 0 |
329283 | 329283 | 2020-07-13 | Franklin | Kentucky | 21073 | 164 | 4 |
329284 | 329284 | 2020-07-13 | Fulton | Kentucky | 21075 | 28 | 1 |
329285 | 329285 | 2020-07-13 | Gallatin | Kentucky | 21077 | 68 | 8 |
329286 | 329286 | 2020-07-13 | Garrard | Kentucky | 21079 | 39 | 0 |
329287 | 329287 | 2020-07-13 | Grant | Kentucky | 21081 | 70 | 5 |
329288 | 329288 | 2020-07-13 | Graves | Kentucky | 21083 | 313 | 21 |
329289 | 329289 | 2020-07-13 | Grayson | Kentucky | 21085 | 147 | 11 |
329290 | 329290 | 2020-07-13 | Green | Kentucky | 21087 | 14 | 1 |
329291 | 329291 | 2020-07-13 | Greenup | Kentucky | 21089 | 44 | 0 |
329292 | 329292 | 2020-07-13 | Hancock | Kentucky | 21091 | 32 | 0 |
329293 | 329293 | 2020-07-13 | Hardin | Kentucky | 21093 | 274 | 6 |
329294 | 329294 | 2020-07-13 | Harlan | Kentucky | 21095 | 37 | 2 |
329295 | 329295 | 2020-07-13 | Harrison | Kentucky | 21097 | 81 | 0 |
329296 | 329296 | 2020-07-13 | Hart | Kentucky | 21099 | 51 | 0 |
329297 | 329297 | 2020-07-13 | Henderson | Kentucky | 21101 | 214 | 4 |
329298 | 329298 | 2020-07-13 | Henry | Kentucky | 21103 | 45 | 2 |
329299 | 329299 | 2020-07-13 | Hickman | Kentucky | 21105 | 7 | 0 |
329300 | 329300 | 2020-07-13 | Hopkins | Kentucky | 21107 | 307 | 35 |
329301 | 329301 | 2020-07-13 | Jackson | Kentucky | 21109 | 117 | 14 |
329302 | 329302 | 2020-07-13 | Jefferson | Kentucky | 21111 | 4588 | 224 |
329303 | 329303 | 2020-07-13 | Jessamine | Kentucky | 21113 | 146 | 0 |
329304 | 329304 | 2020-07-13 | Johnson | Kentucky | 21115 | 11 | 0 |
329305 | 329305 | 2020-07-13 | Kenton | Kentucky | 21117 | 890 | 38 |
329306 | 329306 | 2020-07-13 | Knott | Kentucky | 21119 | 20 | 0 |
329307 | 329307 | 2020-07-13 | Knox | Kentucky | 21121 | 95 | 5 |
329308 | 329308 | 2020-07-13 | Larue | Kentucky | 21123 | 23 | 1 |
329309 | 329309 | 2020-07-13 | Laurel | Kentucky | 21125 | 187 | 3 |
329310 | 329310 | 2020-07-13 | Lawrence | Kentucky | 21127 | 11 | 0 |
329311 | 329311 | 2020-07-13 | Lee | Kentucky | 21129 | 1 | 0 |
329312 | 329312 | 2020-07-13 | Leslie | Kentucky | 21131 | 11 | 0 |
329313 | 329313 | 2020-07-13 | Letcher | Kentucky | 21133 | 20 | 0 |
329314 | 329314 | 2020-07-13 | Lewis | Kentucky | 21135 | 22 | 0 |
329315 | 329315 | 2020-07-13 | Lincoln | Kentucky | 21137 | 56 | 1 |
329316 | 329316 | 2020-07-13 | Livingston | Kentucky | 21139 | 19 | 0 |
329317 | 329317 | 2020-07-13 | Logan | Kentucky | 21141 | 251 | 17 |
329318 | 329318 | 2020-07-13 | Lyon | Kentucky | 21143 | 23 | 3 |
329319 | 329319 | 2020-07-13 | Madison | Kentucky | 21151 | 193 | 1 |
329320 | 329320 | 2020-07-13 | Magoffin | Kentucky | 21153 | 7 | 0 |
329321 | 329321 | 2020-07-13 | Marion | Kentucky | 21155 | 67 | 0 |
329322 | 329322 | 2020-07-13 | Marshall | Kentucky | 21157 | 72 | 2 |
329323 | 329323 | 2020-07-13 | Martin | Kentucky | 21159 | 12 | 0 |
329324 | 329324 | 2020-07-13 | Mason | Kentucky | 21161 | 39 | 1 |
329325 | 329325 | 2020-07-13 | McCracken | Kentucky | 21145 | 206 | 3 |
329326 | 329326 | 2020-07-13 | McCreary | Kentucky | 21147 | 19 | 0 |
329327 | 329327 | 2020-07-13 | McLean | Kentucky | 21149 | 29 | 0 |
329328 | 329328 | 2020-07-13 | Meade | Kentucky | 21163 | 39 | 2 |
329329 | 329329 | 2020-07-13 | Menifee | Kentucky | 21165 | 15 | 0 |
329330 | 329330 | 2020-07-13 | Mercer | Kentucky | 21167 | 30 | 0 |
329331 | 329331 | 2020-07-13 | Metcalfe | Kentucky | 21169 | 17 | 2 |
329332 | 329332 | 2020-07-13 | Monroe | Kentucky | 21171 | 50 | 2 |
329333 | 329333 | 2020-07-13 | Montgomery | Kentucky | 21173 | 65 | 0 |
329334 | 329334 | 2020-07-13 | Morgan | Kentucky | 21175 | 15 | 0 |
329335 | 329335 | 2020-07-13 | Muhlenberg | Kentucky | 21177 | 566 | 8 |
329336 | 329336 | 2020-07-13 | Nelson | Kentucky | 21179 | 116 | 2 |
329337 | 329337 | 2020-07-13 | Nicholas | Kentucky | 21181 | 12 | 0 |
329338 | 329338 | 2020-07-13 | Ohio | Kentucky | 21183 | 265 | 0 |
329339 | 329339 | 2020-07-13 | Oldham | Kentucky | 21185 | 174 | 7 |
329340 | 329340 | 2020-07-13 | Owen | Kentucky | 21187 | 10 | 0 |
329341 | 329341 | 2020-07-13 | Owsley | Kentucky | 21189 | 3 | 0 |
329342 | 329342 | 2020-07-13 | Pendleton | Kentucky | 21191 | 22 | 0 |
329343 | 329343 | 2020-07-13 | Perry | Kentucky | 21193 | 91 | 2 |
329344 | 329344 | 2020-07-13 | Pike | Kentucky | 21195 | 120 | 3 |
329345 | 329345 | 2020-07-13 | Powell | Kentucky | 21197 | 10 | 0 |
329346 | 329346 | 2020-07-13 | Pulaski | Kentucky | 21199 | 146 | 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);