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-10-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 |
---|---|---|---|---|---|---|---|
616423 | 616423 | 2020-10-10 | Adair | Kentucky | 21001 | 400 | 20 |
616424 | 616424 | 2020-10-10 | Allen | Kentucky | 21003 | 434 | 10 |
616425 | 616425 | 2020-10-10 | Anderson | Kentucky | 21005 | 191 | 1 |
616426 | 616426 | 2020-10-10 | Ballard | Kentucky | 21007 | 60 | 1 |
616427 | 616427 | 2020-10-10 | Barren | Kentucky | 21009 | 853 | 13 |
616428 | 616428 | 2020-10-10 | Bath | Kentucky | 21011 | 94 | 1 |
616429 | 616429 | 2020-10-10 | Bell | Kentucky | 21013 | 556 | 16 |
616430 | 616430 | 2020-10-10 | Boone | Kentucky | 21015 | 1761 | 25 |
616431 | 616431 | 2020-10-10 | Bourbon | Kentucky | 21017 | 247 | 1 |
616432 | 616432 | 2020-10-10 | Boyd | Kentucky | 21019 | 549 | 13 |
616433 | 616433 | 2020-10-10 | Boyle | Kentucky | 21021 | 340 | 0 |
616434 | 616434 | 2020-10-10 | Bracken | Kentucky | 21023 | 42 | 0 |
616435 | 616435 | 2020-10-10 | Breathitt | Kentucky | 21025 | 100 | 0 |
616436 | 616436 | 2020-10-10 | Breckinridge | Kentucky | 21027 | 150 | 2 |
616437 | 616437 | 2020-10-10 | Bullitt | Kentucky | 21029 | 1044 | 12 |
616438 | 616438 | 2020-10-10 | Butler | Kentucky | 21031 | 380 | 16 |
616439 | 616439 | 2020-10-10 | Caldwell | Kentucky | 21033 | 192 | 0 |
616440 | 616440 | 2020-10-10 | Calloway | Kentucky | 21035 | 750 | 9 |
616441 | 616441 | 2020-10-10 | Campbell | Kentucky | 21037 | 973 | 19 |
616442 | 616442 | 2020-10-10 | Carlisle | Kentucky | 21039 | 86 | 1 |
616443 | 616443 | 2020-10-10 | Carroll | Kentucky | 21041 | 207 | 5 |
616444 | 616444 | 2020-10-10 | Carter | Kentucky | 21043 | 252 | 4 |
616445 | 616445 | 2020-10-10 | Casey | Kentucky | 21045 | 284 | 16 |
616446 | 616446 | 2020-10-10 | Christian | Kentucky | 21047 | 1561 | 26 |
616447 | 616447 | 2020-10-10 | Clark | Kentucky | 21049 | 396 | 10 |
616448 | 616448 | 2020-10-10 | Clay | Kentucky | 21051 | 362 | 6 |
616449 | 616449 | 2020-10-10 | Clinton | Kentucky | 21053 | 167 | 3 |
616450 | 616450 | 2020-10-10 | Crittenden | Kentucky | 21055 | 131 | 1 |
616451 | 616451 | 2020-10-10 | Cumberland | Kentucky | 21057 | 114 | 0 |
616452 | 616452 | 2020-10-10 | Daviess | Kentucky | 21059 | 1682 | 23 |
616453 | 616453 | 2020-10-10 | Edmonson | Kentucky | 21061 | 166 | 12 |
616454 | 616454 | 2020-10-10 | Elliott | Kentucky | 21063 | 58 | 0 |
616455 | 616455 | 2020-10-10 | Estill | Kentucky | 21065 | 222 | 0 |
616456 | 616456 | 2020-10-10 | Fayette | Kentucky | 21067 | 9279 | 81 |
616457 | 616457 | 2020-10-10 | Fleming | Kentucky | 21069 | 93 | 0 |
616458 | 616458 | 2020-10-10 | Floyd | Kentucky | 21071 | 230 | 4 |
616459 | 616459 | 2020-10-10 | Franklin | Kentucky | 21073 | 760 | 12 |
616460 | 616460 | 2020-10-10 | Fulton | Kentucky | 21075 | 196 | 3 |
616461 | 616461 | 2020-10-10 | Gallatin | Kentucky | 21077 | 106 | 8 |
616462 | 616462 | 2020-10-10 | Garrard | Kentucky | 21079 | 204 | 3 |
616463 | 616463 | 2020-10-10 | Grant | Kentucky | 21081 | 200 | 6 |
616464 | 616464 | 2020-10-10 | Graves | Kentucky | 21083 | 820 | 29 |
616465 | 616465 | 2020-10-10 | Grayson | Kentucky | 21085 | 428 | 14 |
616466 | 616466 | 2020-10-10 | Green | Kentucky | 21087 | 298 | 9 |
616467 | 616467 | 2020-10-10 | Greenup | Kentucky | 21089 | 491 | 5 |
616468 | 616468 | 2020-10-10 | Hancock | Kentucky | 21091 | 103 | 1 |
616469 | 616469 | 2020-10-10 | Hardin | Kentucky | 21093 | 1523 | 13 |
616470 | 616470 | 2020-10-10 | Harlan | Kentucky | 21095 | 519 | 13 |
616471 | 616471 | 2020-10-10 | Harrison | Kentucky | 21097 | 206 | 1 |
616472 | 616472 | 2020-10-10 | Hart | Kentucky | 21099 | 218 | 1 |
616473 | 616473 | 2020-10-10 | Henderson | Kentucky | 21101 | 1061 | 15 |
616474 | 616474 | 2020-10-10 | Henry | Kentucky | 21103 | 214 | 2 |
616475 | 616475 | 2020-10-10 | Hickman | Kentucky | 21105 | 89 | 1 |
616476 | 616476 | 2020-10-10 | Hopkins | Kentucky | 21107 | 810 | 40 |
616477 | 616477 | 2020-10-10 | Jackson | Kentucky | 21109 | 401 | 17 |
616478 | 616478 | 2020-10-10 | Jefferson | Kentucky | 21111 | 19372 | 336 |
616479 | 616479 | 2020-10-10 | Jessamine | Kentucky | 21113 | 734 | 0 |
616480 | 616480 | 2020-10-10 | Johnson | Kentucky | 21115 | 191 | 2 |
616481 | 616481 | 2020-10-10 | Kenton | Kentucky | 21117 | 2223 | 49 |
616482 | 616482 | 2020-10-10 | Knott | Kentucky | 21119 | 252 | 1 |
616483 | 616483 | 2020-10-10 | Knox | Kentucky | 21121 | 622 | 9 |
616484 | 616484 | 2020-10-10 | Larue | Kentucky | 21123 | 231 | 1 |
616485 | 616485 | 2020-10-10 | Laurel | Kentucky | 21125 | 1130 | 6 |
616486 | 616486 | 2020-10-10 | Lawrence | Kentucky | 21127 | 80 | 0 |
616487 | 616487 | 2020-10-10 | Lee | Kentucky | 21129 | 18 | 0 |
616488 | 616488 | 2020-10-10 | Leslie | Kentucky | 21131 | 103 | 0 |
616489 | 616489 | 2020-10-10 | Letcher | Kentucky | 21133 | 242 | 2 |
616490 | 616490 | 2020-10-10 | Lewis | Kentucky | 21135 | 248 | 15 |
616491 | 616491 | 2020-10-10 | Lincoln | Kentucky | 21137 | 245 | 16 |
616492 | 616492 | 2020-10-10 | Livingston | Kentucky | 21139 | 99 | 1 |
616493 | 616493 | 2020-10-10 | Logan | Kentucky | 21141 | 635 | 30 |
616494 | 616494 | 2020-10-10 | Lyon | Kentucky | 21143 | 86 | 4 |
616495 | 616495 | 2020-10-10 | Madison | Kentucky | 21151 | 1994 | 7 |
616496 | 616496 | 2020-10-10 | Magoffin | Kentucky | 21153 | 114 | 0 |
616497 | 616497 | 2020-10-10 | Marion | Kentucky | 21155 | 269 | 10 |
616498 | 616498 | 2020-10-10 | Marshall | Kentucky | 21157 | 368 | 4 |
616499 | 616499 | 2020-10-10 | Martin | Kentucky | 21159 | 97 | 3 |
616500 | 616500 | 2020-10-10 | Mason | Kentucky | 21161 | 139 | 2 |
616501 | 616501 | 2020-10-10 | McCracken | Kentucky | 21145 | 852 | 11 |
616502 | 616502 | 2020-10-10 | McCreary | Kentucky | 21147 | 224 | 1 |
616503 | 616503 | 2020-10-10 | McLean | Kentucky | 21149 | 102 | 0 |
616504 | 616504 | 2020-10-10 | Meade | Kentucky | 21163 | 296 | 3 |
616505 | 616505 | 2020-10-10 | Menifee | Kentucky | 21165 | 68 | 1 |
616506 | 616506 | 2020-10-10 | Mercer | Kentucky | 21167 | 283 | 5 |
616507 | 616507 | 2020-10-10 | Metcalfe | Kentucky | 21169 | 147 | 2 |
616508 | 616508 | 2020-10-10 | Monroe | Kentucky | 21171 | 229 | 4 |
616509 | 616509 | 2020-10-10 | Montgomery | Kentucky | 21173 | 331 | 3 |
616510 | 616510 | 2020-10-10 | Morgan | Kentucky | 21175 | 96 | 0 |
616511 | 616511 | 2020-10-10 | Muhlenberg | Kentucky | 21177 | 872 | 13 |
616512 | 616512 | 2020-10-10 | Nelson | Kentucky | 21179 | 584 | 4 |
616513 | 616513 | 2020-10-10 | Nicholas | Kentucky | 21181 | 64 | 1 |
616514 | 616514 | 2020-10-10 | Ohio | Kentucky | 21183 | 534 | 9 |
616515 | 616515 | 2020-10-10 | Oldham | Kentucky | 21185 | 1239 | 26 |
616516 | 616516 | 2020-10-10 | Owen | Kentucky | 21187 | 105 | 2 |
616517 | 616517 | 2020-10-10 | Owsley | Kentucky | 21189 | 51 | 1 |
616518 | 616518 | 2020-10-10 | Pendleton | Kentucky | 21191 | 104 | 0 |
616519 | 616519 | 2020-10-10 | Perry | Kentucky | 21193 | 371 | 9 |
616520 | 616520 | 2020-10-10 | Pike | Kentucky | 21195 | 567 | 3 |
616521 | 616521 | 2020-10-10 | Powell | Kentucky | 21197 | 121 | 0 |
616522 | 616522 | 2020-10-10 | Pulaski | Kentucky | 21199 | 900 | 12 |
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);