ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2020-11-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 |
---|---|---|---|---|---|---|---|
762417 | 762417 | 2020-11-24 | Adair | Kentucky | 21001 | 909 | 30 |
762418 | 762418 | 2020-11-24 | Allen | Kentucky | 21003 | 682 | 15 |
762419 | 762419 | 2020-11-24 | Anderson | Kentucky | 21005 | 458 | 1 |
762420 | 762420 | 2020-11-24 | Ballard | Kentucky | 21007 | 133 | 2 |
762421 | 762421 | 2020-11-24 | Barren | Kentucky | 21009 | 1882 | 25 |
762422 | 762422 | 2020-11-24 | Bath | Kentucky | 21011 | 241 | 1 |
762423 | 762423 | 2020-11-24 | Bell | Kentucky | 21013 | 1184 | 18 |
762424 | 762424 | 2020-11-24 | Boone | Kentucky | 21015 | 4160 | 29 |
762425 | 762425 | 2020-11-24 | Bourbon | Kentucky | 21017 | 510 | 1 |
762426 | 762426 | 2020-11-24 | Boyd | Kentucky | 21019 | 1562 | 24 |
762427 | 762427 | 2020-11-24 | Boyle | Kentucky | 21021 | 856 | 0 |
762428 | 762428 | 2020-11-24 | Bracken | Kentucky | 21023 | 132 | 3 |
762429 | 762429 | 2020-11-24 | Breathitt | Kentucky | 21025 | 311 | 3 |
762430 | 762430 | 2020-11-24 | Breckinridge | Kentucky | 21027 | 420 | 4 |
762431 | 762431 | 2020-11-24 | Bullitt | Kentucky | 21029 | 2615 | 22 |
762432 | 762432 | 2020-11-24 | Butler | Kentucky | 21031 | 529 | 16 |
762433 | 762433 | 2020-11-24 | Caldwell | Kentucky | 21033 | 513 | 1 |
762434 | 762434 | 2020-11-24 | Calloway | Kentucky | 21035 | 1598 | 14 |
762435 | 762435 | 2020-11-24 | Campbell | Kentucky | 21037 | 2580 | 21 |
762436 | 762436 | 2020-11-24 | Carlisle | Kentucky | 21039 | 187 | 1 |
762437 | 762437 | 2020-11-24 | Carroll | Kentucky | 21041 | 322 | 6 |
762438 | 762438 | 2020-11-24 | Carter | Kentucky | 21043 | 663 | 5 |
762439 | 762439 | 2020-11-24 | Casey | Kentucky | 21045 | 588 | 19 |
762440 | 762440 | 2020-11-24 | Christian | Kentucky | 21047 | 2805 | 44 |
762441 | 762441 | 2020-11-24 | Clark | Kentucky | 21049 | 833 | 12 |
762442 | 762442 | 2020-11-24 | Clay | Kentucky | 21051 | 949 | 8 |
762443 | 762443 | 2020-11-24 | Clinton | Kentucky | 21053 | 459 | 14 |
762444 | 762444 | 2020-11-24 | Crittenden | Kentucky | 21055 | 225 | 1 |
762445 | 762445 | 2020-11-24 | Cumberland | Kentucky | 21057 | 286 | 1 |
762446 | 762446 | 2020-11-24 | Daviess | Kentucky | 21059 | 3170 | 45 |
762447 | 762447 | 2020-11-24 | Edmonson | Kentucky | 21061 | 362 | 13 |
762448 | 762448 | 2020-11-24 | Elliott | Kentucky | 21063 | 565 | 0 |
762449 | 762449 | 2020-11-24 | Estill | Kentucky | 21065 | 425 | 0 |
762450 | 762450 | 2020-11-24 | Fayette | Kentucky | 21067 | 15965 | 112 |
762451 | 762451 | 2020-11-24 | Fleming | Kentucky | 21069 | 311 | 0 |
762452 | 762452 | 2020-11-24 | Floyd | Kentucky | 21071 | 1089 | 5 |
762453 | 762453 | 2020-11-24 | Franklin | Kentucky | 21073 | 1300 | 14 |
762454 | 762454 | 2020-11-24 | Fulton | Kentucky | 21075 | 282 | 3 |
762455 | 762455 | 2020-11-24 | Gallatin | Kentucky | 21077 | 194 | 9 |
762456 | 762456 | 2020-11-24 | Garrard | Kentucky | 21079 | 530 | 4 |
762457 | 762457 | 2020-11-24 | Grant | Kentucky | 21081 | 575 | 6 |
762458 | 762458 | 2020-11-24 | Graves | Kentucky | 21083 | 1643 | 34 |
762459 | 762459 | 2020-11-24 | Grayson | Kentucky | 21085 | 866 | 19 |
762460 | 762460 | 2020-11-24 | Green | Kentucky | 21087 | 560 | 10 |
762461 | 762461 | 2020-11-24 | Greenup | Kentucky | 21089 | 1210 | 12 |
762462 | 762462 | 2020-11-24 | Hancock | Kentucky | 21091 | 288 | 11 |
762463 | 762463 | 2020-11-24 | Hardin | Kentucky | 21093 | 3890 | 34 |
762464 | 762464 | 2020-11-24 | Harlan | Kentucky | 21095 | 840 | 15 |
762465 | 762465 | 2020-11-24 | Harrison | Kentucky | 21097 | 429 | 1 |
762466 | 762466 | 2020-11-24 | Hart | Kentucky | 21099 | 722 | 3 |
762467 | 762467 | 2020-11-24 | Henderson | Kentucky | 21101 | 1923 | 36 |
762468 | 762468 | 2020-11-24 | Henry | Kentucky | 21103 | 462 | 4 |
762469 | 762469 | 2020-11-24 | Hickman | Kentucky | 21105 | 144 | 1 |
762470 | 762470 | 2020-11-24 | Hopkins | Kentucky | 21107 | 1714 | 50 |
762471 | 762471 | 2020-11-24 | Jackson | Kentucky | 21109 | 630 | 17 |
762472 | 762472 | 2020-11-24 | Jefferson | Kentucky | 21111 | 35396 | 485 |
762473 | 762473 | 2020-11-24 | Jessamine | Kentucky | 21113 | 1640 | 29 |
762474 | 762474 | 2020-11-24 | Johnson | Kentucky | 21115 | 691 | 3 |
762475 | 762475 | 2020-11-24 | Kenton | Kentucky | 21117 | 4881 | 63 |
762476 | 762476 | 2020-11-24 | Knott | Kentucky | 21119 | 531 | 9 |
762477 | 762477 | 2020-11-24 | Knox | Kentucky | 21121 | 1145 | 10 |
762478 | 762478 | 2020-11-24 | Larue | Kentucky | 21123 | 583 | 2 |
762479 | 762479 | 2020-11-24 | Laurel | Kentucky | 21125 | 2281 | 11 |
762480 | 762480 | 2020-11-24 | Lawrence | Kentucky | 21127 | 357 | 1 |
762481 | 762481 | 2020-11-24 | Lee | Kentucky | 21129 | 871 | 13 |
762482 | 762482 | 2020-11-24 | Leslie | Kentucky | 21131 | 229 | 1 |
762483 | 762483 | 2020-11-24 | Letcher | Kentucky | 21133 | 481 | 2 |
762484 | 762484 | 2020-11-24 | Lewis | Kentucky | 21135 | 453 | 19 |
762485 | 762485 | 2020-11-24 | Lincoln | Kentucky | 21137 | 604 | 20 |
762486 | 762486 | 2020-11-24 | Livingston | Kentucky | 21139 | 257 | 2 |
762487 | 762487 | 2020-11-24 | Logan | Kentucky | 21141 | 1183 | 33 |
762488 | 762488 | 2020-11-24 | Lyon | Kentucky | 21143 | 187 | 5 |
762489 | 762489 | 2020-11-24 | Madison | Kentucky | 21151 | 3580 | 18 |
762490 | 762490 | 2020-11-24 | Magoffin | Kentucky | 21153 | 413 | 1 |
762491 | 762491 | 2020-11-24 | Marion | Kentucky | 21155 | 906 | 12 |
762492 | 762492 | 2020-11-24 | Marshall | Kentucky | 21157 | 868 | 11 |
762493 | 762493 | 2020-11-24 | Martin | Kentucky | 21159 | 380 | 6 |
762494 | 762494 | 2020-11-24 | Mason | Kentucky | 21161 | 364 | 2 |
762495 | 762495 | 2020-11-24 | McCracken | Kentucky | 21145 | 2448 | 19 |
762496 | 762496 | 2020-11-24 | McCreary | Kentucky | 21147 | 462 | 1 |
762497 | 762497 | 2020-11-24 | McLean | Kentucky | 21149 | 363 | 14 |
762498 | 762498 | 2020-11-24 | Meade | Kentucky | 21163 | 727 | 4 |
762499 | 762499 | 2020-11-24 | Menifee | Kentucky | 21165 | 116 | 1 |
762500 | 762500 | 2020-11-24 | Mercer | Kentucky | 21167 | 631 | 6 |
762501 | 762501 | 2020-11-24 | Metcalfe | Kentucky | 21169 | 365 | 3 |
762502 | 762502 | 2020-11-24 | Monroe | Kentucky | 21171 | 676 | 9 |
762503 | 762503 | 2020-11-24 | Montgomery | Kentucky | 21173 | 871 | 8 |
762504 | 762504 | 2020-11-24 | Morgan | Kentucky | 21175 | 293 | 0 |
762505 | 762505 | 2020-11-24 | Muhlenberg | Kentucky | 21177 | 1361 | 20 |
762506 | 762506 | 2020-11-24 | Nelson | Kentucky | 21179 | 1991 | 9 |
762507 | 762507 | 2020-11-24 | Nicholas | Kentucky | 21181 | 160 | 3 |
762508 | 762508 | 2020-11-24 | Ohio | Kentucky | 21183 | 886 | 15 |
762509 | 762509 | 2020-11-24 | Oldham | Kentucky | 21185 | 2237 | 30 |
762510 | 762510 | 2020-11-24 | Owen | Kentucky | 21187 | 177 | 3 |
762511 | 762511 | 2020-11-24 | Owsley | Kentucky | 21189 | 198 | 1 |
762512 | 762512 | 2020-11-24 | Pendleton | Kentucky | 21191 | 328 | 1 |
762513 | 762513 | 2020-11-24 | Perry | Kentucky | 21193 | 884 | 11 |
762514 | 762514 | 2020-11-24 | Pike | Kentucky | 21195 | 1694 | 17 |
762515 | 762515 | 2020-11-24 | Powell | Kentucky | 21197 | 462 | 0 |
762516 | 762516 | 2020-11-24 | Pulaski | Kentucky | 21199 | 1992 | 14 |
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);