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-09-08 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1697407 | 1697407 | 2021-09-08 | Adair | Kentucky | 21001 | 2656 | 62 |
1697408 | 1697408 | 2021-09-08 | Allen | Kentucky | 21003 | 3084 | 48 |
1697409 | 1697409 | 2021-09-08 | Anderson | Kentucky | 21005 | 2424 | 28 |
1697410 | 1697410 | 2021-09-08 | Ballard | Kentucky | 21007 | 558 | 12 |
1697411 | 1697411 | 2021-09-08 | Barren | Kentucky | 21009 | 6360 | 110 |
1697412 | 1697412 | 2021-09-08 | Bath | Kentucky | 21011 | 1325 | 24 |
1697413 | 1697413 | 2021-09-08 | Bell | Kentucky | 21013 | 4811 | 69 |
1697414 | 1697414 | 2021-09-08 | Boone | Kentucky | 21015 | 17657 | 178 |
1697415 | 1697415 | 2021-09-08 | Bourbon | Kentucky | 21017 | 2503 | 21 |
1697416 | 1697416 | 2021-09-08 | Boyd | Kentucky | 21019 | 6795 | 85 |
1697417 | 1697417 | 2021-09-08 | Boyle | Kentucky | 21021 | 4523 | 80 |
1697418 | 1697418 | 2021-09-08 | Bracken | Kentucky | 21023 | 866 | 8 |
1697419 | 1697419 | 2021-09-08 | Breathitt | Kentucky | 21025 | 1583 | 14 |
1697420 | 1697420 | 2021-09-08 | Breckinridge | Kentucky | 21027 | 2179 | 20 |
1697421 | 1697421 | 2021-09-08 | Bullitt | Kentucky | 21029 | 9962 | 96 |
1697422 | 1697422 | 2021-09-08 | Butler | Kentucky | 21031 | 1918 | 28 |
1697423 | 1697423 | 2021-09-08 | Caldwell | Kentucky | 21033 | 1833 | 34 |
1697424 | 1697424 | 2021-09-08 | Calloway | Kentucky | 21035 | 4557 | 56 |
1697425 | 1697425 | 2021-09-08 | Campbell | Kentucky | 21037 | 10928 | 89 |
1697426 | 1697426 | 2021-09-08 | Carlisle | Kentucky | 21039 | 566 | 10 |
1697427 | 1697427 | 2021-09-08 | Carroll | Kentucky | 21041 | 1502 | 21 |
1697428 | 1697428 | 2021-09-08 | Carter | Kentucky | 21043 | 3705 | 46 |
1697429 | 1697429 | 2021-09-08 | Casey | Kentucky | 21045 | 2282 | 48 |
1697430 | 1697430 | 2021-09-08 | Christian | Kentucky | 21047 | 8367 | 113 |
1697431 | 1697431 | 2021-09-08 | Clark | Kentucky | 21049 | 4171 | 32 |
1697432 | 1697432 | 2021-09-08 | Clay | Kentucky | 21051 | 4531 | 50 |
1697433 | 1697433 | 2021-09-08 | Clinton | Kentucky | 21053 | 1843 | 33 |
1697434 | 1697434 | 2021-09-08 | Crittenden | Kentucky | 21055 | 883 | 27 |
1697435 | 1697435 | 2021-09-08 | Cumberland | Kentucky | 21057 | 914 | 15 |
1697436 | 1697436 | 2021-09-08 | Daviess | Kentucky | 21059 | 14468 | 218 |
1697437 | 1697437 | 2021-09-08 | Edmonson | Kentucky | 21061 | 1219 | 26 |
1697438 | 1697438 | 2021-09-08 | Elliott | Kentucky | 21063 | 1183 | 2 |
1697439 | 1697439 | 2021-09-08 | Estill | Kentucky | 21065 | 1701 | 12 |
1697440 | 1697440 | 2021-09-08 | Fayette | Kentucky | 21067 | 44661 | 340 |
1697441 | 1697441 | 2021-09-08 | Fleming | Kentucky | 21069 | 1760 | 26 |
1697442 | 1697442 | 2021-09-08 | Floyd | Kentucky | 21071 | 5573 | 86 |
1697443 | 1697443 | 2021-09-08 | Franklin | Kentucky | 21073 | 5679 | 65 |
1697444 | 1697444 | 2021-09-08 | Fulton | Kentucky | 21075 | 639 | 16 |
1697445 | 1697445 | 2021-09-08 | Gallatin | Kentucky | 21077 | 987 | 35 |
1697446 | 1697446 | 2021-09-08 | Garrard | Kentucky | 21079 | 2078 | 38 |
1697447 | 1697447 | 2021-09-08 | Grant | Kentucky | 21081 | 3387 | 28 |
1697448 | 1697448 | 2021-09-08 | Graves | Kentucky | 21083 | 6261 | 109 |
1697449 | 1697449 | 2021-09-08 | Grayson | Kentucky | 21085 | 3439 | 61 |
1697450 | 1697450 | 2021-09-08 | Green | Kentucky | 21087 | 1821 | 22 |
1697451 | 1697451 | 2021-09-08 | Greenup | Kentucky | 21089 | 5025 | 65 |
1697452 | 1697452 | 2021-09-08 | Hancock | Kentucky | 21091 | 1183 | 16 |
1697453 | 1697453 | 2021-09-08 | Hardin | Kentucky | 21093 | 14594 | 194 |
1697454 | 1697454 | 2021-09-08 | Harlan | Kentucky | 21095 | 3972 | 101 |
1697455 | 1697455 | 2021-09-08 | Harrison | Kentucky | 21097 | 2474 | 28 |
1697456 | 1697456 | 2021-09-08 | Hart | Kentucky | 21099 | 2847 | 56 |
1697457 | 1697457 | 2021-09-08 | Henderson | Kentucky | 21101 | 6930 | 88 |
1697458 | 1697458 | 2021-09-08 | Henry | Kentucky | 21103 | 2066 | 21 |
1697459 | 1697459 | 2021-09-08 | Hickman | Kentucky | 21105 | 477 | 16 |
1697460 | 1697460 | 2021-09-08 | Hopkins | Kentucky | 21107 | 6581 | 165 |
1697461 | 1697461 | 2021-09-08 | Jackson | Kentucky | 21109 | 2072 | 40 |
1697462 | 1697462 | 2021-09-08 | Jefferson | Kentucky | 21111 | 101566 | 1433 |
1697463 | 1697463 | 2021-09-08 | Jessamine | Kentucky | 21113 | 6352 | 79 |
1697464 | 1697464 | 2021-09-08 | Johnson | Kentucky | 21115 | 2976 | 39 |
1697465 | 1697465 | 2021-09-08 | Kenton | Kentucky | 21117 | 20561 | 230 |
1697466 | 1697466 | 2021-09-08 | Knott | Kentucky | 21119 | 1785 | 28 |
1697467 | 1697467 | 2021-09-08 | Knox | Kentucky | 21121 | 5497 | 49 |
1697468 | 1697468 | 2021-09-08 | Larue | Kentucky | 21123 | 2078 | 30 |
1697469 | 1697469 | 2021-09-08 | Laurel | Kentucky | 21125 | 11304 | 87 |
1697470 | 1697470 | 2021-09-08 | Lawrence | Kentucky | 21127 | 2042 | 32 |
1697471 | 1697471 | 2021-09-08 | Lee | Kentucky | 21129 | 1536 | 27 |
1697472 | 1697472 | 2021-09-08 | Leslie | Kentucky | 21131 | 1618 | 10 |
1697473 | 1697473 | 2021-09-08 | Letcher | Kentucky | 21133 | 2900 | 52 |
1697474 | 1697474 | 2021-09-08 | Lewis | Kentucky | 21135 | 1925 | 48 |
1697475 | 1697475 | 2021-09-08 | Lincoln | Kentucky | 21137 | 3309 | 69 |
1697476 | 1697476 | 2021-09-08 | Livingston | Kentucky | 21139 | 1116 | 27 |
1697477 | 1697477 | 2021-09-08 | Logan | Kentucky | 21141 | 4238 | 77 |
1697478 | 1697478 | 2021-09-08 | Lyon | Kentucky | 21143 | 1765 | 23 |
1697479 | 1697479 | 2021-09-08 | Madison | Kentucky | 21151 | 12488 | 119 |
1697480 | 1697480 | 2021-09-08 | Magoffin | Kentucky | 21153 | 1640 | 18 |
1697481 | 1697481 | 2021-09-08 | Marion | Kentucky | 21155 | 3218 | 40 |
1697482 | 1697482 | 2021-09-08 | Marshall | Kentucky | 21157 | 4353 | 70 |
1697483 | 1697483 | 2021-09-08 | Martin | Kentucky | 21159 | 1426 | 22 |
1697484 | 1697484 | 2021-09-08 | Mason | Kentucky | 21161 | 2156 | 46 |
1697485 | 1697485 | 2021-09-08 | McCracken | Kentucky | 21145 | 8799 | 142 |
1697486 | 1697486 | 2021-09-08 | McCreary | Kentucky | 21147 | 2677 | 35 |
1697487 | 1697487 | 2021-09-08 | McLean | Kentucky | 21149 | 1202 | 30 |
1697488 | 1697488 | 2021-09-08 | Meade | Kentucky | 21163 | 2798 | 30 |
1697489 | 1697489 | 2021-09-08 | Menifee | Kentucky | 21165 | 701 | 17 |
1697490 | 1697490 | 2021-09-08 | Mercer | Kentucky | 21167 | 3602 | 57 |
1697491 | 1697491 | 2021-09-08 | Metcalfe | Kentucky | 21169 | 1515 | 32 |
1697492 | 1697492 | 2021-09-08 | Monroe | Kentucky | 21171 | 1784 | 49 |
1697493 | 1697493 | 2021-09-08 | Montgomery | Kentucky | 21173 | 3809 | 36 |
1697494 | 1697494 | 2021-09-08 | Morgan | Kentucky | 21175 | 2582 | 5 |
1697495 | 1697495 | 2021-09-08 | Muhlenberg | Kentucky | 21177 | 4554 | 80 |
1697496 | 1697496 | 2021-09-08 | Nelson | Kentucky | 21179 | 6862 | 70 |
1697497 | 1697497 | 2021-09-08 | Nicholas | Kentucky | 21181 | 833 | 10 |
1697498 | 1697498 | 2021-09-08 | Ohio | Kentucky | 21183 | 3499 | 61 |
1697499 | 1697499 | 2021-09-08 | Oldham | Kentucky | 21185 | 9110 | 86 |
1697500 | 1697500 | 2021-09-08 | Owen | Kentucky | 21187 | 1118 | 14 |
1697501 | 1697501 | 2021-09-08 | Owsley | Kentucky | 21189 | 753 | 16 |
1697502 | 1697502 | 2021-09-08 | Pendleton | Kentucky | 21191 | 1493 | 7 |
1697503 | 1697503 | 2021-09-08 | Perry | Kentucky | 21193 | 4594 | 72 |
1697504 | 1697504 | 2021-09-08 | Pike | Kentucky | 21195 | 8675 | 133 |
1697505 | 1697505 | 2021-09-08 | Powell | Kentucky | 21197 | 1893 | 15 |
1697506 | 1697506 | 2021-09-08 | Pulaski | Kentucky | 21199 | 8861 | 147 |
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);