ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2020-10-30" 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 |
---|---|---|---|---|---|---|---|
681308 | 681308 | 2020-10-30 | Adair | Kentucky | 21001 | 569 | 23 |
681309 | 681309 | 2020-10-30 | Allen | Kentucky | 21003 | 557 | 12 |
681310 | 681310 | 2020-10-30 | Anderson | Kentucky | 21005 | 271 | 1 |
681311 | 681311 | 2020-10-30 | Ballard | Kentucky | 21007 | 77 | 1 |
681312 | 681312 | 2020-10-30 | Barren | Kentucky | 21009 | 1309 | 13 |
681313 | 681313 | 2020-10-30 | Bath | Kentucky | 21011 | 136 | 1 |
681314 | 681314 | 2020-10-30 | Bell | Kentucky | 21013 | 729 | 17 |
681315 | 681315 | 2020-10-30 | Boone | Kentucky | 21015 | 2269 | 25 |
681316 | 681316 | 2020-10-30 | Bourbon | Kentucky | 21017 | 338 | 1 |
681317 | 681317 | 2020-10-30 | Boyd | Kentucky | 21019 | 709 | 22 |
681318 | 681318 | 2020-10-30 | Boyle | Kentucky | 21021 | 476 | 0 |
681319 | 681319 | 2020-10-30 | Bracken | Kentucky | 21023 | 73 | 1 |
681320 | 681320 | 2020-10-30 | Breathitt | Kentucky | 21025 | 146 | 1 |
681321 | 681321 | 2020-10-30 | Breckinridge | Kentucky | 21027 | 209 | 2 |
681322 | 681322 | 2020-10-30 | Bullitt | Kentucky | 21029 | 1540 | 14 |
681323 | 681323 | 2020-10-30 | Butler | Kentucky | 21031 | 446 | 16 |
681324 | 681324 | 2020-10-30 | Caldwell | Kentucky | 21033 | 292 | 0 |
681325 | 681325 | 2020-10-30 | Calloway | Kentucky | 21035 | 1036 | 10 |
681326 | 681326 | 2020-10-30 | Campbell | Kentucky | 21037 | 1367 | 19 |
681327 | 681327 | 2020-10-30 | Carlisle | Kentucky | 21039 | 106 | 1 |
681328 | 681328 | 2020-10-30 | Carroll | Kentucky | 21041 | 231 | 5 |
681329 | 681329 | 2020-10-30 | Carter | Kentucky | 21043 | 374 | 4 |
681330 | 681330 | 2020-10-30 | Casey | Kentucky | 21045 | 361 | 16 |
681331 | 681331 | 2020-10-30 | Christian | Kentucky | 21047 | 2017 | 31 |
681332 | 681332 | 2020-10-30 | Clark | Kentucky | 21049 | 550 | 12 |
681333 | 681333 | 2020-10-30 | Clay | Kentucky | 21051 | 602 | 6 |
681334 | 681334 | 2020-10-30 | Clinton | Kentucky | 21053 | 268 | 4 |
681335 | 681335 | 2020-10-30 | Crittenden | Kentucky | 21055 | 172 | 1 |
681336 | 681336 | 2020-10-30 | Cumberland | Kentucky | 21057 | 185 | 0 |
681337 | 681337 | 2020-10-30 | Daviess | Kentucky | 21059 | 2054 | 31 |
681338 | 681338 | 2020-10-30 | Edmonson | Kentucky | 21061 | 209 | 12 |
681339 | 681339 | 2020-10-30 | Elliott | Kentucky | 21063 | 336 | 0 |
681340 | 681340 | 2020-10-30 | Estill | Kentucky | 21065 | 294 | 0 |
681341 | 681341 | 2020-10-30 | Fayette | Kentucky | 21067 | 11060 | 97 |
681342 | 681342 | 2020-10-30 | Fleming | Kentucky | 21069 | 196 | 0 |
681343 | 681343 | 2020-10-30 | Floyd | Kentucky | 21071 | 434 | 4 |
681344 | 681344 | 2020-10-30 | Franklin | Kentucky | 21073 | 895 | 14 |
681345 | 681345 | 2020-10-30 | Fulton | Kentucky | 21075 | 237 | 3 |
681346 | 681346 | 2020-10-30 | Gallatin | Kentucky | 21077 | 128 | 8 |
681347 | 681347 | 2020-10-30 | Garrard | Kentucky | 21079 | 358 | 4 |
681348 | 681348 | 2020-10-30 | Grant | Kentucky | 21081 | 278 | 6 |
681349 | 681349 | 2020-10-30 | Graves | Kentucky | 21083 | 913 | 30 |
681350 | 681350 | 2020-10-30 | Grayson | Kentucky | 21085 | 531 | 16 |
681351 | 681351 | 2020-10-30 | Green | Kentucky | 21087 | 361 | 9 |
681352 | 681352 | 2020-10-30 | Greenup | Kentucky | 21089 | 660 | 12 |
681353 | 681353 | 2020-10-30 | Hancock | Kentucky | 21091 | 161 | 3 |
681354 | 681354 | 2020-10-30 | Hardin | Kentucky | 21093 | 2230 | 17 |
681355 | 681355 | 2020-10-30 | Harlan | Kentucky | 21095 | 616 | 14 |
681356 | 681356 | 2020-10-30 | Harrison | Kentucky | 21097 | 278 | 1 |
681357 | 681357 | 2020-10-30 | Hart | Kentucky | 21099 | 480 | 1 |
681358 | 681358 | 2020-10-30 | Henderson | Kentucky | 21101 | 1364 | 36 |
681359 | 681359 | 2020-10-30 | Henry | Kentucky | 21103 | 298 | 2 |
681360 | 681360 | 2020-10-30 | Hickman | Kentucky | 21105 | 124 | 1 |
681361 | 681361 | 2020-10-30 | Hopkins | Kentucky | 21107 | 1088 | 44 |
681362 | 681362 | 2020-10-30 | Jackson | Kentucky | 21109 | 486 | 17 |
681363 | 681363 | 2020-10-30 | Jefferson | Kentucky | 21111 | 24761 | 402 |
681364 | 681364 | 2020-10-30 | Jessamine | Kentucky | 21113 | 1028 | 12 |
681365 | 681365 | 2020-10-30 | Johnson | Kentucky | 21115 | 343 | 2 |
681366 | 681366 | 2020-10-30 | Kenton | Kentucky | 21117 | 2883 | 51 |
681367 | 681367 | 2020-10-30 | Knott | Kentucky | 21119 | 368 | 6 |
681368 | 681368 | 2020-10-30 | Knox | Kentucky | 21121 | 893 | 10 |
681369 | 681369 | 2020-10-30 | Larue | Kentucky | 21123 | 351 | 2 |
681370 | 681370 | 2020-10-30 | Laurel | Kentucky | 21125 | 1507 | 8 |
681371 | 681371 | 2020-10-30 | Lawrence | Kentucky | 21127 | 161 | 0 |
681372 | 681372 | 2020-10-30 | Lee | Kentucky | 21129 | 182 | 6 |
681373 | 681373 | 2020-10-30 | Leslie | Kentucky | 21131 | 136 | 1 |
681374 | 681374 | 2020-10-30 | Letcher | Kentucky | 21133 | 313 | 2 |
681375 | 681375 | 2020-10-30 | Lewis | Kentucky | 21135 | 309 | 16 |
681376 | 681376 | 2020-10-30 | Lincoln | Kentucky | 21137 | 352 | 19 |
681377 | 681377 | 2020-10-30 | Livingston | Kentucky | 21139 | 131 | 1 |
681378 | 681378 | 2020-10-30 | Logan | Kentucky | 21141 | 852 | 31 |
681379 | 681379 | 2020-10-30 | Lyon | Kentucky | 21143 | 113 | 4 |
681380 | 681380 | 2020-10-30 | Madison | Kentucky | 21151 | 2408 | 13 |
681381 | 681381 | 2020-10-30 | Magoffin | Kentucky | 21153 | 183 | 0 |
681382 | 681382 | 2020-10-30 | Marion | Kentucky | 21155 | 520 | 11 |
681383 | 681383 | 2020-10-30 | Marshall | Kentucky | 21157 | 515 | 7 |
681384 | 681384 | 2020-10-30 | Martin | Kentucky | 21159 | 218 | 3 |
681385 | 681385 | 2020-10-30 | Mason | Kentucky | 21161 | 182 | 2 |
681386 | 681386 | 2020-10-30 | McCracken | Kentucky | 21145 | 1213 | 12 |
681387 | 681387 | 2020-10-30 | McCreary | Kentucky | 21147 | 286 | 1 |
681388 | 681388 | 2020-10-30 | McLean | Kentucky | 21149 | 224 | 3 |
681389 | 681389 | 2020-10-30 | Meade | Kentucky | 21163 | 459 | 4 |
681390 | 681390 | 2020-10-30 | Menifee | Kentucky | 21165 | 90 | 1 |
681391 | 681391 | 2020-10-30 | Mercer | Kentucky | 21167 | 376 | 6 |
681392 | 681392 | 2020-10-30 | Metcalfe | Kentucky | 21169 | 220 | 2 |
681393 | 681393 | 2020-10-30 | Monroe | Kentucky | 21171 | 333 | 4 |
681394 | 681394 | 2020-10-30 | Montgomery | Kentucky | 21173 | 551 | 5 |
681395 | 681395 | 2020-10-30 | Morgan | Kentucky | 21175 | 144 | 0 |
681396 | 681396 | 2020-10-30 | Muhlenberg | Kentucky | 21177 | 1007 | 16 |
681397 | 681397 | 2020-10-30 | Nelson | Kentucky | 21179 | 1064 | 4 |
681398 | 681398 | 2020-10-30 | Nicholas | Kentucky | 21181 | 119 | 3 |
681399 | 681399 | 2020-10-30 | Ohio | Kentucky | 21183 | 638 | 10 |
681400 | 681400 | 2020-10-30 | Oldham | Kentucky | 21185 | 1486 | 26 |
681401 | 681401 | 2020-10-30 | Owen | Kentucky | 21187 | 126 | 3 |
681402 | 681402 | 2020-10-30 | Owsley | Kentucky | 21189 | 99 | 1 |
681403 | 681403 | 2020-10-30 | Pendleton | Kentucky | 21191 | 133 | 0 |
681404 | 681404 | 2020-10-30 | Perry | Kentucky | 21193 | 557 | 9 |
681405 | 681405 | 2020-10-30 | Pike | Kentucky | 21195 | 1004 | 4 |
681406 | 681406 | 2020-10-30 | Powell | Kentucky | 21197 | 149 | 0 |
681407 | 681407 | 2020-10-30 | Pulaski | Kentucky | 21199 | 1072 | 13 |
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);