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 2021-08-23 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1645433 | 1645433 | 2021-08-23 | Adair | Kentucky | 21001 | 2339 | 58 |
1645434 | 1645434 | 2021-08-23 | Allen | Kentucky | 21003 | 2597 | 48 |
1645435 | 1645435 | 2021-08-23 | Anderson | Kentucky | 21005 | 2142 | 25 |
1645436 | 1645436 | 2021-08-23 | Ballard | Kentucky | 21007 | 503 | 11 |
1645437 | 1645437 | 2021-08-23 | Barren | Kentucky | 21009 | 5476 | 108 |
1645438 | 1645438 | 2021-08-23 | Bath | Kentucky | 21011 | 1182 | 24 |
1645439 | 1645439 | 2021-08-23 | Bell | Kentucky | 21013 | 3888 | 58 |
1645440 | 1645440 | 2021-08-23 | Boone | Kentucky | 21015 | 16380 | 166 |
1645441 | 1645441 | 2021-08-23 | Bourbon | Kentucky | 21017 | 2099 | 20 |
1645442 | 1645442 | 2021-08-23 | Boyd | Kentucky | 21019 | 6001 | 81 |
1645443 | 1645443 | 2021-08-23 | Boyle | Kentucky | 21021 | 3998 | 80 |
1645444 | 1645444 | 2021-08-23 | Bracken | Kentucky | 21023 | 791 | 8 |
1645445 | 1645445 | 2021-08-23 | Breathitt | Kentucky | 21025 | 1234 | 12 |
1645446 | 1645446 | 2021-08-23 | Breckinridge | Kentucky | 21027 | 1725 | 19 |
1645447 | 1645447 | 2021-08-23 | Bullitt | Kentucky | 21029 | 8695 | 88 |
1645448 | 1645448 | 2021-08-23 | Butler | Kentucky | 21031 | 1677 | 28 |
1645449 | 1645449 | 2021-08-23 | Caldwell | Kentucky | 21033 | 1694 | 33 |
1645450 | 1645450 | 2021-08-23 | Calloway | Kentucky | 21035 | 4179 | 53 |
1645451 | 1645451 | 2021-08-23 | Campbell | Kentucky | 21037 | 9848 | 84 |
1645452 | 1645452 | 2021-08-23 | Carlisle | Kentucky | 21039 | 544 | 10 |
1645453 | 1645453 | 2021-08-23 | Carroll | Kentucky | 21041 | 1256 | 21 |
1645454 | 1645454 | 2021-08-23 | Carter | Kentucky | 21043 | 3070 | 38 |
1645455 | 1645455 | 2021-08-23 | Casey | Kentucky | 21045 | 1839 | 43 |
1645456 | 1645456 | 2021-08-23 | Christian | Kentucky | 21047 | 7812 | 108 |
1645457 | 1645457 | 2021-08-23 | Clark | Kentucky | 21049 | 3664 | 32 |
1645458 | 1645458 | 2021-08-23 | Clay | Kentucky | 21051 | 3805 | 46 |
1645459 | 1645459 | 2021-08-23 | Clinton | Kentucky | 21053 | 1579 | 33 |
1645460 | 1645460 | 2021-08-23 | Crittenden | Kentucky | 21055 | 820 | 27 |
1645461 | 1645461 | 2021-08-23 | Cumberland | Kentucky | 21057 | 774 | 14 |
1645462 | 1645462 | 2021-08-23 | Daviess | Kentucky | 21059 | 13137 | 207 |
1645463 | 1645463 | 2021-08-23 | Edmonson | Kentucky | 21061 | 1044 | 25 |
1645464 | 1645464 | 2021-08-23 | Elliott | Kentucky | 21063 | 1103 | 2 |
1645465 | 1645465 | 2021-08-23 | Estill | Kentucky | 21065 | 1443 | 12 |
1645466 | 1645466 | 2021-08-23 | Fayette | Kentucky | 21067 | 40964 | 326 |
1645467 | 1645467 | 2021-08-23 | Fleming | Kentucky | 21069 | 1539 | 26 |
1645468 | 1645468 | 2021-08-23 | Floyd | Kentucky | 21071 | 4707 | 75 |
1645469 | 1645469 | 2021-08-23 | Franklin | Kentucky | 21073 | 4986 | 62 |
1645470 | 1645470 | 2021-08-23 | Fulton | Kentucky | 21075 | 581 | 16 |
1645471 | 1645471 | 2021-08-23 | Gallatin | Kentucky | 21077 | 869 | 34 |
1645472 | 1645472 | 2021-08-23 | Garrard | Kentucky | 21079 | 1808 | 37 |
1645473 | 1645473 | 2021-08-23 | Grant | Kentucky | 21081 | 3019 | 25 |
1645474 | 1645474 | 2021-08-23 | Graves | Kentucky | 21083 | 5326 | 104 |
1645475 | 1645475 | 2021-08-23 | Grayson | Kentucky | 21085 | 2808 | 59 |
1645476 | 1645476 | 2021-08-23 | Green | Kentucky | 21087 | 1509 | 18 |
1645477 | 1645477 | 2021-08-23 | Greenup | Kentucky | 21089 | 4387 | 64 |
1645478 | 1645478 | 2021-08-23 | Hancock | Kentucky | 21091 | 1052 | 16 |
1645479 | 1645479 | 2021-08-23 | Hardin | Kentucky | 21093 | 12373 | 175 |
1645480 | 1645480 | 2021-08-23 | Harlan | Kentucky | 21095 | 3402 | 94 |
1645481 | 1645481 | 2021-08-23 | Harrison | Kentucky | 21097 | 2102 | 27 |
1645482 | 1645482 | 2021-08-23 | Hart | Kentucky | 21099 | 2509 | 55 |
1645483 | 1645483 | 2021-08-23 | Henderson | Kentucky | 21101 | 6097 | 83 |
1645484 | 1645484 | 2021-08-23 | Henry | Kentucky | 21103 | 1767 | 21 |
1645485 | 1645485 | 2021-08-23 | Hickman | Kentucky | 21105 | 430 | 16 |
1645486 | 1645486 | 2021-08-23 | Hopkins | Kentucky | 21107 | 5800 | 157 |
1645487 | 1645487 | 2021-08-23 | Jackson | Kentucky | 21109 | 1793 | 32 |
1645488 | 1645488 | 2021-08-23 | Jefferson | Kentucky | 21111 | 93146 | 1385 |
1645489 | 1645489 | 2021-08-23 | Jessamine | Kentucky | 21113 | 5593 | 75 |
1645490 | 1645490 | 2021-08-23 | Johnson | Kentucky | 21115 | 2589 | 38 |
1645491 | 1645491 | 2021-08-23 | Kenton | Kentucky | 21117 | 18976 | 220 |
1645492 | 1645492 | 2021-08-23 | Knott | Kentucky | 21119 | 1518 | 25 |
1645493 | 1645493 | 2021-08-23 | Knox | Kentucky | 21121 | 4678 | 49 |
1645494 | 1645494 | 2021-08-23 | Larue | Kentucky | 21123 | 1683 | 29 |
1645495 | 1645495 | 2021-08-23 | Laurel | Kentucky | 21125 | 9812 | 87 |
1645496 | 1645496 | 2021-08-23 | Lawrence | Kentucky | 21127 | 1730 | 30 |
1645497 | 1645497 | 2021-08-23 | Lee | Kentucky | 21129 | 1414 | 26 |
1645498 | 1645498 | 2021-08-23 | Leslie | Kentucky | 21131 | 1234 | 9 |
1645499 | 1645499 | 2021-08-23 | Letcher | Kentucky | 21133 | 2536 | 51 |
1645500 | 1645500 | 2021-08-23 | Lewis | Kentucky | 21135 | 1692 | 45 |
1645501 | 1645501 | 2021-08-23 | Lincoln | Kentucky | 21137 | 2920 | 63 |
1645502 | 1645502 | 2021-08-23 | Livingston | Kentucky | 21139 | 1043 | 27 |
1645503 | 1645503 | 2021-08-23 | Logan | Kentucky | 21141 | 3705 | 75 |
1645504 | 1645504 | 2021-08-23 | Lyon | Kentucky | 21143 | 1671 | 22 |
1645505 | 1645505 | 2021-08-23 | Madison | Kentucky | 21151 | 11058 | 115 |
1645506 | 1645506 | 2021-08-23 | Magoffin | Kentucky | 21153 | 1387 | 18 |
1645507 | 1645507 | 2021-08-23 | Marion | Kentucky | 21155 | 2774 | 39 |
1645508 | 1645508 | 2021-08-23 | Marshall | Kentucky | 21157 | 3796 | 66 |
1645509 | 1645509 | 2021-08-23 | Martin | Kentucky | 21159 | 1228 | 22 |
1645510 | 1645510 | 2021-08-23 | Mason | Kentucky | 21161 | 2000 | 41 |
1645511 | 1645511 | 2021-08-23 | McCracken | Kentucky | 21145 | 8086 | 138 |
1645512 | 1645512 | 2021-08-23 | McCreary | Kentucky | 21147 | 2348 | 34 |
1645513 | 1645513 | 2021-08-23 | McLean | Kentucky | 21149 | 1083 | 29 |
1645514 | 1645514 | 2021-08-23 | Meade | Kentucky | 21163 | 2490 | 27 |
1645515 | 1645515 | 2021-08-23 | Menifee | Kentucky | 21165 | 598 | 17 |
1645516 | 1645516 | 2021-08-23 | Mercer | Kentucky | 21167 | 3089 | 54 |
1645517 | 1645517 | 2021-08-23 | Metcalfe | Kentucky | 21169 | 1307 | 31 |
1645518 | 1645518 | 2021-08-23 | Monroe | Kentucky | 21171 | 1526 | 46 |
1645519 | 1645519 | 2021-08-23 | Montgomery | Kentucky | 21173 | 3468 | 32 |
1645520 | 1645520 | 2021-08-23 | Morgan | Kentucky | 21175 | 2481 | 5 |
1645521 | 1645521 | 2021-08-23 | Muhlenberg | Kentucky | 21177 | 3930 | 75 |
1645522 | 1645522 | 2021-08-23 | Nelson | Kentucky | 21179 | 6042 | 64 |
1645523 | 1645523 | 2021-08-23 | Nicholas | Kentucky | 21181 | 695 | 9 |
1645524 | 1645524 | 2021-08-23 | Ohio | Kentucky | 21183 | 3057 | 58 |
1645525 | 1645525 | 2021-08-23 | Oldham | Kentucky | 21185 | 8472 | 86 |
1645526 | 1645526 | 2021-08-23 | Owen | Kentucky | 21187 | 950 | 13 |
1645527 | 1645527 | 2021-08-23 | Owsley | Kentucky | 21189 | 596 | 16 |
1645528 | 1645528 | 2021-08-23 | Pendleton | Kentucky | 21191 | 1301 | 5 |
1645529 | 1645529 | 2021-08-23 | Perry | Kentucky | 21193 | 3559 | 69 |
1645530 | 1645530 | 2021-08-23 | Pike | Kentucky | 21195 | 7340 | 116 |
1645531 | 1645531 | 2021-08-23 | Powell | Kentucky | 21197 | 1551 | 14 |
1645532 | 1645532 | 2021-08-23 | Pulaski | Kentucky | 21199 | 7782 | 134 |
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);