ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2021-01-24" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
960383 | 960383 | 2021-01-24 | Adair | Kentucky | 21001 | 1486 | 47 |
960384 | 960384 | 2021-01-24 | Allen | Kentucky | 21003 | 1472 | 21 |
960385 | 960385 | 2021-01-24 | Anderson | Kentucky | 21005 | 1351 | 11 |
960386 | 960386 | 2021-01-24 | Ballard | Kentucky | 21007 | 300 | 3 |
960387 | 960387 | 2021-01-24 | Barren | Kentucky | 21009 | 3272 | 37 |
960388 | 960388 | 2021-01-24 | Bath | Kentucky | 21011 | 678 | 11 |
960389 | 960389 | 2021-01-24 | Bell | Kentucky | 21013 | 2347 | 32 |
960390 | 960390 | 2021-01-24 | Boone | Kentucky | 21015 | 10720 | 52 |
960391 | 960391 | 2021-01-24 | Bourbon | Kentucky | 21017 | 1324 | 9 |
960392 | 960392 | 2021-01-24 | Boyd | Kentucky | 21019 | 4081 | 33 |
960393 | 960393 | 2021-01-24 | Boyle | Kentucky | 21021 | 2928 | 21 |
960394 | 960394 | 2021-01-24 | Bracken | Kentucky | 21023 | 418 | 3 |
960395 | 960395 | 2021-01-24 | Breathitt | Kentucky | 21025 | 795 | 3 |
960396 | 960396 | 2021-01-24 | Breckinridge | Kentucky | 21027 | 948 | 5 |
960397 | 960397 | 2021-01-24 | Bullitt | Kentucky | 21029 | 5409 | 33 |
960398 | 960398 | 2021-01-24 | Butler | Kentucky | 21031 | 1077 | 17 |
960399 | 960399 | 2021-01-24 | Caldwell | Kentucky | 21033 | 1106 | 19 |
960400 | 960400 | 2021-01-24 | Calloway | Kentucky | 21035 | 3018 | 31 |
960401 | 960401 | 2021-01-24 | Campbell | Kentucky | 21037 | 6601 | 40 |
960402 | 960402 | 2021-01-24 | Carlisle | Kentucky | 21039 | 401 | 1 |
960403 | 960403 | 2021-01-24 | Carroll | Kentucky | 21041 | 778 | 10 |
960404 | 960404 | 2021-01-24 | Carter | Kentucky | 21043 | 1732 | 19 |
960405 | 960405 | 2021-01-24 | Casey | Kentucky | 21045 | 1101 | 30 |
960406 | 960406 | 2021-01-24 | Christian | Kentucky | 21047 | 5562 | 74 |
960407 | 960407 | 2021-01-24 | Clark | Kentucky | 21049 | 2086 | 16 |
960408 | 960408 | 2021-01-24 | Clay | Kentucky | 21051 | 2134 | 17 |
960409 | 960409 | 2021-01-24 | Clinton | Kentucky | 21053 | 1236 | 25 |
960410 | 960410 | 2021-01-24 | Crittenden | Kentucky | 21055 | 494 | 6 |
960411 | 960411 | 2021-01-24 | Cumberland | Kentucky | 21057 | 578 | 8 |
960412 | 960412 | 2021-01-24 | Daviess | Kentucky | 21059 | 8005 | 130 |
960413 | 960413 | 2021-01-24 | Edmonson | Kentucky | 21061 | 695 | 13 |
960414 | 960414 | 2021-01-24 | Elliott | Kentucky | 21063 | 887 | 1 |
960415 | 960415 | 2021-01-24 | Estill | Kentucky | 21065 | 852 | 0 |
960416 | 960416 | 2021-01-24 | Fayette | Kentucky | 21067 | 28523 | 179 |
960417 | 960417 | 2021-01-24 | Fleming | Kentucky | 21069 | 935 | 8 |
960418 | 960418 | 2021-01-24 | Floyd | Kentucky | 21071 | 2516 | 19 |
960419 | 960419 | 2021-01-24 | Franklin | Kentucky | 21073 | 2843 | 24 |
960420 | 960420 | 2021-01-24 | Fulton | Kentucky | 21075 | 425 | 4 |
960421 | 960421 | 2021-01-24 | Gallatin | Kentucky | 21077 | 554 | 16 |
960422 | 960422 | 2021-01-24 | Garrard | Kentucky | 21079 | 1231 | 4 |
960423 | 960423 | 2021-01-24 | Grant | Kentucky | 21081 | 1698 | 11 |
960424 | 960424 | 2021-01-24 | Graves | Kentucky | 21083 | 3521 | 60 |
960425 | 960425 | 2021-01-24 | Grayson | Kentucky | 21085 | 1654 | 38 |
960426 | 960426 | 2021-01-24 | Green | Kentucky | 21087 | 963 | 13 |
960427 | 960427 | 2021-01-24 | Greenup | Kentucky | 21089 | 2903 | 21 |
960428 | 960428 | 2021-01-24 | Hancock | Kentucky | 21091 | 693 | 14 |
960429 | 960429 | 2021-01-24 | Hardin | Kentucky | 21093 | 7663 | 59 |
960430 | 960430 | 2021-01-24 | Harlan | Kentucky | 21095 | 2104 | 35 |
960431 | 960431 | 2021-01-24 | Harrison | Kentucky | 21097 | 1276 | 2 |
960432 | 960432 | 2021-01-24 | Hart | Kentucky | 21099 | 1546 | 15 |
960433 | 960433 | 2021-01-24 | Henderson | Kentucky | 21101 | 3832 | 53 |
960434 | 960434 | 2021-01-24 | Henry | Kentucky | 21103 | 1036 | 5 |
960435 | 960435 | 2021-01-24 | Hickman | Kentucky | 21105 | 271 | 7 |
960436 | 960436 | 2021-01-24 | Hopkins | Kentucky | 21107 | 3397 | 115 |
960437 | 960437 | 2021-01-24 | Jackson | Kentucky | 21109 | 1082 | 24 |
960438 | 960438 | 2021-01-24 | Jefferson | Kentucky | 21111 | 64386 | 773 |
960439 | 960439 | 2021-01-24 | Jessamine | Kentucky | 21113 | 3446 | 48 |
960440 | 960440 | 2021-01-24 | Johnson | Kentucky | 21115 | 1474 | 17 |
960441 | 960441 | 2021-01-24 | Kenton | Kentucky | 21117 | 12580 | 97 |
960442 | 960442 | 2021-01-24 | Knott | Kentucky | 21119 | 870 | 14 |
960443 | 960443 | 2021-01-24 | Knox | Kentucky | 21121 | 2418 | 10 |
960444 | 960444 | 2021-01-24 | Larue | Kentucky | 21123 | 1001 | 7 |
960445 | 960445 | 2021-01-24 | Laurel | Kentucky | 21125 | 4952 | 17 |
960446 | 960446 | 2021-01-24 | Lawrence | Kentucky | 21127 | 1038 | 8 |
960447 | 960447 | 2021-01-24 | Lee | Kentucky | 21129 | 1121 | 18 |
960448 | 960448 | 2021-01-24 | Leslie | Kentucky | 21131 | 656 | 2 |
960449 | 960449 | 2021-01-24 | Letcher | Kentucky | 21133 | 1437 | 5 |
960450 | 960450 | 2021-01-24 | Lewis | Kentucky | 21135 | 977 | 29 |
960451 | 960451 | 2021-01-24 | Lincoln | Kentucky | 21137 | 1801 | 29 |
960452 | 960452 | 2021-01-24 | Livingston | Kentucky | 21139 | 609 | 15 |
960453 | 960453 | 2021-01-24 | Logan | Kentucky | 21141 | 2110 | 45 |
960454 | 960454 | 2021-01-24 | Lyon | Kentucky | 21143 | 400 | 11 |
960455 | 960455 | 2021-01-24 | Madison | Kentucky | 21151 | 7254 | 47 |
960456 | 960456 | 2021-01-24 | Magoffin | Kentucky | 21153 | 792 | 1 |
960457 | 960457 | 2021-01-24 | Marion | Kentucky | 21155 | 1825 | 20 |
960458 | 960458 | 2021-01-24 | Marshall | Kentucky | 21157 | 2121 | 32 |
960459 | 960459 | 2021-01-24 | Martin | Kentucky | 21159 | 812 | 11 |
960460 | 960460 | 2021-01-24 | Mason | Kentucky | 21161 | 1175 | 26 |
960461 | 960461 | 2021-01-24 | McCracken | Kentucky | 21145 | 5082 | 50 |
960462 | 960462 | 2021-01-24 | McCreary | Kentucky | 21147 | 1433 | 18 |
960463 | 960463 | 2021-01-24 | McLean | Kentucky | 21149 | 729 | 24 |
960464 | 960464 | 2021-01-24 | Meade | Kentucky | 21163 | 1571 | 7 |
960465 | 960465 | 2021-01-24 | Menifee | Kentucky | 21165 | 296 | 4 |
960466 | 960466 | 2021-01-24 | Mercer | Kentucky | 21167 | 2043 | 11 |
960467 | 960467 | 2021-01-24 | Metcalfe | Kentucky | 21169 | 741 | 12 |
960468 | 960468 | 2021-01-24 | Monroe | Kentucky | 21171 | 1118 | 33 |
960469 | 960469 | 2021-01-24 | Montgomery | Kentucky | 21173 | 1892 | 20 |
960470 | 960470 | 2021-01-24 | Morgan | Kentucky | 21175 | 1757 | 0 |
960471 | 960471 | 2021-01-24 | Muhlenberg | Kentucky | 21177 | 2474 | 50 |
960472 | 960472 | 2021-01-24 | Nelson | Kentucky | 21179 | 3841 | 24 |
960473 | 960473 | 2021-01-24 | Nicholas | Kentucky | 21181 | 404 | 5 |
960474 | 960474 | 2021-01-24 | Ohio | Kentucky | 21183 | 2024 | 37 |
960475 | 960475 | 2021-01-24 | Oldham | Kentucky | 21185 | 6201 | 63 |
960476 | 960476 | 2021-01-24 | Owen | Kentucky | 21187 | 527 | 7 |
960477 | 960477 | 2021-01-24 | Owsley | Kentucky | 21189 | 363 | 10 |
960478 | 960478 | 2021-01-24 | Pendleton | Kentucky | 21191 | 799 | 1 |
960479 | 960479 | 2021-01-24 | Perry | Kentucky | 21193 | 1917 | 24 |
960480 | 960480 | 2021-01-24 | Pike | Kentucky | 21195 | 4171 | 39 |
960481 | 960481 | 2021-01-24 | Powell | Kentucky | 21197 | 849 | 0 |
960482 | 960482 | 2021-01-24 | Pulaski | Kentucky | 21199 | 4995 | 73 |
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);