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-19 and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
348420 | 348420 | 2020-07-19 | Adair | Kentucky | 21001 | 176 | 19 |
348421 | 348421 | 2020-07-19 | Allen | Kentucky | 21003 | 199 | 7 |
348422 | 348422 | 2020-07-19 | Anderson | Kentucky | 21005 | 35 | 1 |
348423 | 348423 | 2020-07-19 | Ballard | Kentucky | 21007 | 25 | 0 |
348424 | 348424 | 2020-07-19 | Barren | Kentucky | 21009 | 171 | 2 |
348425 | 348425 | 2020-07-19 | Bath | Kentucky | 21011 | 23 | 1 |
348426 | 348426 | 2020-07-19 | Bell | Kentucky | 21013 | 159 | 1 |
348427 | 348427 | 2020-07-19 | Boone | Kentucky | 21015 | 837 | 23 |
348428 | 348428 | 2020-07-19 | Bourbon | Kentucky | 21017 | 55 | 1 |
348429 | 348429 | 2020-07-19 | Boyd | Kentucky | 21019 | 116 | 3 |
348430 | 348430 | 2020-07-19 | Boyle | Kentucky | 21021 | 58 | 0 |
348431 | 348431 | 2020-07-19 | Bracken | Kentucky | 21023 | 24 | 0 |
348432 | 348432 | 2020-07-19 | Breathitt | Kentucky | 21025 | 16 | 0 |
348433 | 348433 | 2020-07-19 | Breckinridge | Kentucky | 21027 | 37 | 2 |
348434 | 348434 | 2020-07-19 | Bullitt | Kentucky | 21029 | 197 | 4 |
348435 | 348435 | 2020-07-19 | Butler | Kentucky | 21031 | 280 | 14 |
348436 | 348436 | 2020-07-19 | Caldwell | Kentucky | 21033 | 41 | 0 |
348437 | 348437 | 2020-07-19 | Calloway | Kentucky | 21035 | 133 | 1 |
348438 | 348438 | 2020-07-19 | Campbell | Kentucky | 21037 | 391 | 13 |
348439 | 348439 | 2020-07-19 | Carlisle | Kentucky | 21039 | 14 | 1 |
348440 | 348440 | 2020-07-19 | Carroll | Kentucky | 21041 | 126 | 2 |
348441 | 348441 | 2020-07-19 | Carter | Kentucky | 21043 | 69 | 1 |
348442 | 348442 | 2020-07-19 | Casey | Kentucky | 21045 | 128 | 6 |
348443 | 348443 | 2020-07-19 | Christian | Kentucky | 21047 | 411 | 4 |
348444 | 348444 | 2020-07-19 | Clark | Kentucky | 21049 | 121 | 7 |
348445 | 348445 | 2020-07-19 | Clay | Kentucky | 21051 | 114 | 4 |
348446 | 348446 | 2020-07-19 | Clinton | Kentucky | 21053 | 14 | 0 |
348447 | 348447 | 2020-07-19 | Crittenden | Kentucky | 21055 | 19 | 1 |
348448 | 348448 | 2020-07-19 | Cumberland | Kentucky | 21057 | 20 | 0 |
348449 | 348449 | 2020-07-19 | Daviess | Kentucky | 21059 | 570 | 8 |
348450 | 348450 | 2020-07-19 | Edmonson | Kentucky | 21061 | 84 | 12 |
348451 | 348451 | 2020-07-19 | Elliott | Kentucky | 21063 | 7 | 0 |
348452 | 348452 | 2020-07-19 | Estill | Kentucky | 21065 | 8 | 0 |
348453 | 348453 | 2020-07-19 | Fayette | Kentucky | 21067 | 2343 | 41 |
348454 | 348454 | 2020-07-19 | Fleming | Kentucky | 21069 | 41 | 0 |
348455 | 348455 | 2020-07-19 | Floyd | Kentucky | 21071 | 57 | 1 |
348456 | 348456 | 2020-07-19 | Franklin | Kentucky | 21073 | 186 | 5 |
348457 | 348457 | 2020-07-19 | Fulton | Kentucky | 21075 | 31 | 1 |
348458 | 348458 | 2020-07-19 | Gallatin | Kentucky | 21077 | 72 | 8 |
348459 | 348459 | 2020-07-19 | Garrard | Kentucky | 21079 | 45 | 0 |
348460 | 348460 | 2020-07-19 | Grant | Kentucky | 21081 | 78 | 5 |
348461 | 348461 | 2020-07-19 | Graves | Kentucky | 21083 | 382 | 21 |
348462 | 348462 | 2020-07-19 | Grayson | Kentucky | 21085 | 158 | 11 |
348463 | 348463 | 2020-07-19 | Green | Kentucky | 21087 | 25 | 1 |
348464 | 348464 | 2020-07-19 | Greenup | Kentucky | 21089 | 53 | 0 |
348465 | 348465 | 2020-07-19 | Hancock | Kentucky | 21091 | 35 | 0 |
348466 | 348466 | 2020-07-19 | Hardin | Kentucky | 21093 | 355 | 7 |
348467 | 348467 | 2020-07-19 | Harlan | Kentucky | 21095 | 78 | 2 |
348468 | 348468 | 2020-07-19 | Harrison | Kentucky | 21097 | 91 | 0 |
348469 | 348469 | 2020-07-19 | Hart | Kentucky | 21099 | 57 | 0 |
348470 | 348470 | 2020-07-19 | Henderson | Kentucky | 21101 | 232 | 4 |
348471 | 348471 | 2020-07-19 | Henry | Kentucky | 21103 | 61 | 2 |
348472 | 348472 | 2020-07-19 | Hickman | Kentucky | 21105 | 14 | 0 |
348473 | 348473 | 2020-07-19 | Hopkins | Kentucky | 21107 | 354 | 35 |
348474 | 348474 | 2020-07-19 | Jackson | Kentucky | 21109 | 118 | 14 |
348475 | 348475 | 2020-07-19 | Jefferson | Kentucky | 21111 | 5170 | 230 |
348476 | 348476 | 2020-07-19 | Jessamine | Kentucky | 21113 | 181 | 0 |
348477 | 348477 | 2020-07-19 | Johnson | Kentucky | 21115 | 16 | 0 |
348478 | 348478 | 2020-07-19 | Kenton | Kentucky | 21117 | 1053 | 38 |
348479 | 348479 | 2020-07-19 | Knott | Kentucky | 21119 | 26 | 0 |
348480 | 348480 | 2020-07-19 | Knox | Kentucky | 21121 | 140 | 7 |
348481 | 348481 | 2020-07-19 | Larue | Kentucky | 21123 | 36 | 1 |
348482 | 348482 | 2020-07-19 | Laurel | Kentucky | 21125 | 251 | 4 |
348483 | 348483 | 2020-07-19 | Lawrence | Kentucky | 21127 | 15 | 0 |
348484 | 348484 | 2020-07-19 | Lee | Kentucky | 21129 | 2 | 0 |
348485 | 348485 | 2020-07-19 | Leslie | Kentucky | 21131 | 13 | 0 |
348486 | 348486 | 2020-07-19 | Letcher | Kentucky | 21133 | 26 | 0 |
348487 | 348487 | 2020-07-19 | Lewis | Kentucky | 21135 | 26 | 0 |
348488 | 348488 | 2020-07-19 | Lincoln | Kentucky | 21137 | 73 | 1 |
348489 | 348489 | 2020-07-19 | Livingston | Kentucky | 21139 | 25 | 0 |
348490 | 348490 | 2020-07-19 | Logan | Kentucky | 21141 | 269 | 21 |
348491 | 348491 | 2020-07-19 | Lyon | Kentucky | 21143 | 25 | 3 |
348492 | 348492 | 2020-07-19 | Madison | Kentucky | 21151 | 258 | 1 |
348493 | 348493 | 2020-07-19 | Magoffin | Kentucky | 21153 | 7 | 0 |
348494 | 348494 | 2020-07-19 | Marion | Kentucky | 21155 | 79 | 0 |
348495 | 348495 | 2020-07-19 | Marshall | Kentucky | 21157 | 92 | 2 |
348496 | 348496 | 2020-07-19 | Martin | Kentucky | 21159 | 15 | 0 |
348497 | 348497 | 2020-07-19 | Mason | Kentucky | 21161 | 43 | 1 |
348498 | 348498 | 2020-07-19 | McCracken | Kentucky | 21145 | 243 | 3 |
348499 | 348499 | 2020-07-19 | McCreary | Kentucky | 21147 | 20 | 0 |
348500 | 348500 | 2020-07-19 | McLean | Kentucky | 21149 | 35 | 0 |
348501 | 348501 | 2020-07-19 | Meade | Kentucky | 21163 | 49 | 2 |
348502 | 348502 | 2020-07-19 | Menifee | Kentucky | 21165 | 19 | 0 |
348503 | 348503 | 2020-07-19 | Mercer | Kentucky | 21167 | 32 | 0 |
348504 | 348504 | 2020-07-19 | Metcalfe | Kentucky | 21169 | 18 | 2 |
348505 | 348505 | 2020-07-19 | Monroe | Kentucky | 21171 | 61 | 2 |
348506 | 348506 | 2020-07-19 | Montgomery | Kentucky | 21173 | 89 | 0 |
348507 | 348507 | 2020-07-19 | Morgan | Kentucky | 21175 | 23 | 0 |
348508 | 348508 | 2020-07-19 | Muhlenberg | Kentucky | 21177 | 595 | 9 |
348509 | 348509 | 2020-07-19 | Nelson | Kentucky | 21179 | 145 | 2 |
348510 | 348510 | 2020-07-19 | Nicholas | Kentucky | 21181 | 17 | 0 |
348511 | 348511 | 2020-07-19 | Ohio | Kentucky | 21183 | 305 | 1 |
348512 | 348512 | 2020-07-19 | Oldham | Kentucky | 21185 | 396 | 8 |
348513 | 348513 | 2020-07-19 | Owen | Kentucky | 21187 | 22 | 0 |
348514 | 348514 | 2020-07-19 | Owsley | Kentucky | 21189 | 4 | 0 |
348515 | 348515 | 2020-07-19 | Pendleton | Kentucky | 21191 | 28 | 0 |
348516 | 348516 | 2020-07-19 | Perry | Kentucky | 21193 | 122 | 2 |
348517 | 348517 | 2020-07-19 | Pike | Kentucky | 21195 | 156 | 3 |
348518 | 348518 | 2020-07-19 | Powell | Kentucky | 21197 | 29 | 0 |
348519 | 348519 | 2020-07-19 | Pulaski | Kentucky | 21199 | 179 | 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);