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-04-11 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1210352 | 1210352 | 2021-04-11 | Adair | Kentucky | 21001 | 1803 | 53 |
1210353 | 1210353 | 2021-04-11 | Allen | Kentucky | 21003 | 1996 | 36 |
1210354 | 1210354 | 2021-04-11 | Anderson | Kentucky | 21005 | 1694 | 19 |
1210355 | 1210355 | 2021-04-11 | Ballard | Kentucky | 21007 | 385 | 8 |
1210356 | 1210356 | 2021-04-11 | Barren | Kentucky | 21009 | 4313 | 88 |
1210357 | 1210357 | 2021-04-11 | Bath | Kentucky | 21011 | 853 | 20 |
1210358 | 1210358 | 2021-04-11 | Bell | Kentucky | 21013 | 2997 | 50 |
1210359 | 1210359 | 2021-04-11 | Boone | Kentucky | 21015 | 13850 | 131 |
1210360 | 1210360 | 2021-04-11 | Bourbon | Kentucky | 21017 | 1641 | 18 |
1210361 | 1210361 | 2021-04-11 | Boyd | Kentucky | 21019 | 4831 | 72 |
1210362 | 1210362 | 2021-04-11 | Boyle | Kentucky | 21021 | 3323 | 69 |
1210363 | 1210363 | 2021-04-11 | Bracken | Kentucky | 21023 | 562 | 7 |
1210364 | 1210364 | 2021-04-11 | Breathitt | Kentucky | 21025 | 991 | 8 |
1210365 | 1210365 | 2021-04-11 | Breckinridge | Kentucky | 21027 | 1167 | 13 |
1210366 | 1210366 | 2021-04-11 | Bullitt | Kentucky | 21029 | 6876 | 71 |
1210367 | 1210367 | 2021-04-11 | Butler | Kentucky | 21031 | 1429 | 24 |
1210368 | 1210368 | 2021-04-11 | Caldwell | Kentucky | 21033 | 1417 | 29 |
1210369 | 1210369 | 2021-04-11 | Calloway | Kentucky | 21035 | 3459 | 49 |
1210370 | 1210370 | 2021-04-11 | Campbell | Kentucky | 21037 | 8574 | 80 |
1210371 | 1210371 | 2021-04-11 | Carlisle | Kentucky | 21039 | 460 | 8 |
1210372 | 1210372 | 2021-04-11 | Carroll | Kentucky | 21041 | 979 | 19 |
1210373 | 1210373 | 2021-04-11 | Carter | Kentucky | 21043 | 2206 | 32 |
1210374 | 1210374 | 2021-04-11 | Casey | Kentucky | 21045 | 1364 | 34 |
1210375 | 1210375 | 2021-04-11 | Christian | Kentucky | 21047 | 6719 | 100 |
1210376 | 1210376 | 2021-04-11 | Clark | Kentucky | 21049 | 2696 | 28 |
1210377 | 1210377 | 2021-04-11 | Clay | Kentucky | 21051 | 2600 | 38 |
1210378 | 1210378 | 2021-04-11 | Clinton | Kentucky | 21053 | 1445 | 30 |
1210379 | 1210379 | 2021-04-11 | Crittenden | Kentucky | 21055 | 617 | 19 |
1210380 | 1210380 | 2021-04-11 | Cumberland | Kentucky | 21057 | 692 | 9 |
1210381 | 1210381 | 2021-04-11 | Daviess | Kentucky | 21059 | 10303 | 177 |
1210382 | 1210382 | 2021-04-11 | Edmonson | Kentucky | 21061 | 946 | 21 |
1210383 | 1210383 | 2021-04-11 | Elliott | Kentucky | 21063 | 949 | 2 |
1210384 | 1210384 | 2021-04-11 | Estill | Kentucky | 21065 | 1053 | 11 |
1210385 | 1210385 | 2021-04-11 | Fayette | Kentucky | 21067 | 34557 | 296 |
1210386 | 1210386 | 2021-04-11 | Fleming | Kentucky | 21069 | 1132 | 21 |
1210387 | 1210387 | 2021-04-11 | Floyd | Kentucky | 21071 | 3273 | 62 |
1210388 | 1210388 | 2021-04-11 | Franklin | Kentucky | 21073 | 3921 | 46 |
1210389 | 1210389 | 2021-04-11 | Fulton | Kentucky | 21075 | 499 | 14 |
1210390 | 1210390 | 2021-04-11 | Gallatin | Kentucky | 21077 | 688 | 26 |
1210391 | 1210391 | 2021-04-11 | Garrard | Kentucky | 21079 | 1478 | 32 |
1210392 | 1210392 | 2021-04-11 | Grant | Kentucky | 21081 | 2364 | 18 |
1210393 | 1210393 | 2021-04-11 | Graves | Kentucky | 21083 | 4076 | 90 |
1210394 | 1210394 | 2021-04-11 | Grayson | Kentucky | 21085 | 2093 | 51 |
1210395 | 1210395 | 2021-04-11 | Green | Kentucky | 21087 | 1191 | 15 |
1210396 | 1210396 | 2021-04-11 | Greenup | Kentucky | 21089 | 3480 | 54 |
1210397 | 1210397 | 2021-04-11 | Hancock | Kentucky | 21091 | 849 | 16 |
1210398 | 1210398 | 2021-04-11 | Hardin | Kentucky | 21093 | 9383 | 147 |
1210399 | 1210399 | 2021-04-11 | Harlan | Kentucky | 21095 | 2639 | 80 |
1210400 | 1210400 | 2021-04-11 | Harrison | Kentucky | 21097 | 1633 | 22 |
1210401 | 1210401 | 2021-04-11 | Hart | Kentucky | 21099 | 1925 | 45 |
1210402 | 1210402 | 2021-04-11 | Henderson | Kentucky | 21101 | 4548 | 72 |
1210403 | 1210403 | 2021-04-11 | Henry | Kentucky | 21103 | 1311 | 11 |
1210404 | 1210404 | 2021-04-11 | Hickman | Kentucky | 21105 | 349 | 10 |
1210405 | 1210405 | 2021-04-11 | Hopkins | Kentucky | 21107 | 4281 | 144 |
1210406 | 1210406 | 2021-04-11 | Jackson | Kentucky | 21109 | 1286 | 32 |
1210407 | 1210407 | 2021-04-11 | Jefferson | Kentucky | 21111 | 78868 | 1123 |
1210408 | 1210408 | 2021-04-11 | Jessamine | Kentucky | 21113 | 4429 | 60 |
1210409 | 1210409 | 2021-04-11 | Johnson | Kentucky | 21115 | 1873 | 31 |
1210410 | 1210410 | 2021-04-11 | Kenton | Kentucky | 21117 | 16380 | 194 |
1210411 | 1210411 | 2021-04-11 | Knott | Kentucky | 21119 | 1126 | 22 |
1210412 | 1210412 | 2021-04-11 | Knox | Kentucky | 21121 | 3321 | 34 |
1210413 | 1210413 | 2021-04-11 | Larue | Kentucky | 21123 | 1287 | 25 |
1210414 | 1210414 | 2021-04-11 | Laurel | Kentucky | 21125 | 6422 | 65 |
1210415 | 1210415 | 2021-04-11 | Lawrence | Kentucky | 21127 | 1374 | 20 |
1210416 | 1210416 | 2021-04-11 | Lee | Kentucky | 21129 | 1259 | 23 |
1210417 | 1210417 | 2021-04-11 | Leslie | Kentucky | 21131 | 876 | 6 |
1210418 | 1210418 | 2021-04-11 | Letcher | Kentucky | 21133 | 1850 | 42 |
1210419 | 1210419 | 2021-04-11 | Lewis | Kentucky | 21135 | 1157 | 32 |
1210420 | 1210420 | 2021-04-11 | Lincoln | Kentucky | 21137 | 2228 | 45 |
1210421 | 1210421 | 2021-04-11 | Livingston | Kentucky | 21139 | 807 | 20 |
1210422 | 1210422 | 2021-04-11 | Logan | Kentucky | 21141 | 2720 | 64 |
1210423 | 1210423 | 2021-04-11 | Lyon | Kentucky | 21143 | 1503 | 19 |
1210424 | 1210424 | 2021-04-11 | Madison | Kentucky | 21151 | 9086 | 108 |
1210425 | 1210425 | 2021-04-11 | Magoffin | Kentucky | 21153 | 918 | 14 |
1210426 | 1210426 | 2021-04-11 | Marion | Kentucky | 21155 | 2224 | 37 |
1210427 | 1210427 | 2021-04-11 | Marshall | Kentucky | 21157 | 2688 | 54 |
1210428 | 1210428 | 2021-04-11 | Martin | Kentucky | 21159 | 994 | 20 |
1210429 | 1210429 | 2021-04-11 | Mason | Kentucky | 21161 | 1552 | 34 |
1210430 | 1210430 | 2021-04-11 | McCracken | Kentucky | 21145 | 6265 | 118 |
1210431 | 1210431 | 2021-04-11 | McCreary | Kentucky | 21147 | 1945 | 30 |
1210432 | 1210432 | 2021-04-11 | McLean | Kentucky | 21149 | 861 | 27 |
1210433 | 1210433 | 2021-04-11 | Meade | Kentucky | 21163 | 1967 | 22 |
1210434 | 1210434 | 2021-04-11 | Menifee | Kentucky | 21165 | 439 | 15 |
1210435 | 1210435 | 2021-04-11 | Mercer | Kentucky | 21167 | 2479 | 47 |
1210436 | 1210436 | 2021-04-11 | Metcalfe | Kentucky | 21169 | 1012 | 25 |
1210437 | 1210437 | 2021-04-11 | Monroe | Kentucky | 21171 | 1293 | 40 |
1210438 | 1210438 | 2021-04-11 | Montgomery | Kentucky | 21173 | 2490 | 30 |
1210439 | 1210439 | 2021-04-11 | Morgan | Kentucky | 21175 | 2145 | 3 |
1210440 | 1210440 | 2021-04-11 | Muhlenberg | Kentucky | 21177 | 2872 | 60 |
1210441 | 1210441 | 2021-04-11 | Nelson | Kentucky | 21179 | 4783 | 51 |
1210442 | 1210442 | 2021-04-11 | Nicholas | Kentucky | 21181 | 510 | 8 |
1210443 | 1210443 | 2021-04-11 | Ohio | Kentucky | 21183 | 2451 | 55 |
1210444 | 1210444 | 2021-04-11 | Oldham | Kentucky | 21185 | 7373 | 82 |
1210445 | 1210445 | 2021-04-11 | Owen | Kentucky | 21187 | 643 | 12 |
1210446 | 1210446 | 2021-04-11 | Owsley | Kentucky | 21189 | 486 | 12 |
1210447 | 1210447 | 2021-04-11 | Pendleton | Kentucky | 21191 | 994 | 3 |
1210448 | 1210448 | 2021-04-11 | Perry | Kentucky | 21193 | 2580 | 63 |
1210449 | 1210449 | 2021-04-11 | Pike | Kentucky | 21195 | 5407 | 85 |
1210450 | 1210450 | 2021-04-11 | Powell | Kentucky | 21197 | 1132 | 10 |
1210451 | 1210451 | 2021-04-11 | Pulaski | Kentucky | 21199 | 6156 | 96 |
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);