ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2020-12-19" 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 |
---|---|---|---|---|---|---|---|
843552 | 843552 | 2020-12-19 | Adair | Kentucky | 21001 | 1221 | 41 |
843553 | 843553 | 2020-12-19 | Allen | Kentucky | 21003 | 1001 | 17 |
843554 | 843554 | 2020-12-19 | Anderson | Kentucky | 21005 | 813 | 1 |
843555 | 843555 | 2020-12-19 | Ballard | Kentucky | 21007 | 214 | 2 |
843556 | 843556 | 2020-12-19 | Barren | Kentucky | 21009 | 2384 | 34 |
843557 | 843557 | 2020-12-19 | Bath | Kentucky | 21011 | 437 | 2 |
843558 | 843558 | 2020-12-19 | Bell | Kentucky | 21013 | 1640 | 23 |
843559 | 843559 | 2020-12-19 | Boone | Kentucky | 21015 | 6991 | 36 |
843560 | 843560 | 2020-12-19 | Bourbon | Kentucky | 21017 | 779 | 1 |
843561 | 843561 | 2020-12-19 | Boyd | Kentucky | 21019 | 2711 | 30 |
843562 | 843562 | 2020-12-19 | Boyle | Kentucky | 21021 | 1651 | 0 |
843563 | 843563 | 2020-12-19 | Bracken | Kentucky | 21023 | 253 | 3 |
843564 | 843564 | 2020-12-19 | Breathitt | Kentucky | 21025 | 514 | 3 |
843565 | 843565 | 2020-12-19 | Breckinridge | Kentucky | 21027 | 560 | 4 |
843566 | 843566 | 2020-12-19 | Bullitt | Kentucky | 21029 | 3780 | 27 |
843567 | 843567 | 2020-12-19 | Butler | Kentucky | 21031 | 738 | 16 |
843568 | 843568 | 2020-12-19 | Caldwell | Kentucky | 21033 | 828 | 13 |
843569 | 843569 | 2020-12-19 | Calloway | Kentucky | 21035 | 2140 | 19 |
843570 | 843570 | 2020-12-19 | Campbell | Kentucky | 21037 | 4187 | 27 |
843571 | 843571 | 2020-12-19 | Carlisle | Kentucky | 21039 | 272 | 1 |
843572 | 843572 | 2020-12-19 | Carroll | Kentucky | 21041 | 505 | 7 |
843573 | 843573 | 2020-12-19 | Carter | Kentucky | 21043 | 1165 | 5 |
843574 | 843574 | 2020-12-19 | Casey | Kentucky | 21045 | 833 | 24 |
843575 | 843575 | 2020-12-19 | Christian | Kentucky | 21047 | 3799 | 52 |
843576 | 843576 | 2020-12-19 | Clark | Kentucky | 21049 | 1326 | 14 |
843577 | 843577 | 2020-12-19 | Clay | Kentucky | 21051 | 1341 | 8 |
843578 | 843578 | 2020-12-19 | Clinton | Kentucky | 21053 | 748 | 17 |
843579 | 843579 | 2020-12-19 | Crittenden | Kentucky | 21055 | 315 | 3 |
843580 | 843580 | 2020-12-19 | Cumberland | Kentucky | 21057 | 382 | 4 |
843581 | 843581 | 2020-12-19 | Daviess | Kentucky | 21059 | 5130 | 76 |
843582 | 843582 | 2020-12-19 | Edmonson | Kentucky | 21061 | 512 | 13 |
843583 | 843583 | 2020-12-19 | Elliott | Kentucky | 21063 | 740 | 1 |
843584 | 843584 | 2020-12-19 | Estill | Kentucky | 21065 | 604 | 0 |
843585 | 843585 | 2020-12-19 | Fayette | Kentucky | 21067 | 21627 | 147 |
843586 | 843586 | 2020-12-19 | Fleming | Kentucky | 21069 | 588 | 1 |
843587 | 843587 | 2020-12-19 | Floyd | Kentucky | 21071 | 1645 | 9 |
843588 | 843588 | 2020-12-19 | Franklin | Kentucky | 21073 | 1939 | 17 |
843589 | 843589 | 2020-12-19 | Fulton | Kentucky | 21075 | 340 | 4 |
843590 | 843590 | 2020-12-19 | Gallatin | Kentucky | 21077 | 408 | 9 |
843591 | 843591 | 2020-12-19 | Garrard | Kentucky | 21079 | 856 | 4 |
843592 | 843592 | 2020-12-19 | Grant | Kentucky | 21081 | 1155 | 7 |
843593 | 843593 | 2020-12-19 | Graves | Kentucky | 21083 | 2339 | 43 |
843594 | 843594 | 2020-12-19 | Grayson | Kentucky | 21085 | 1178 | 28 |
843595 | 843595 | 2020-12-19 | Green | Kentucky | 21087 | 744 | 11 |
843596 | 843596 | 2020-12-19 | Greenup | Kentucky | 21089 | 1987 | 18 |
843597 | 843597 | 2020-12-19 | Hancock | Kentucky | 21091 | 392 | 12 |
843598 | 843598 | 2020-12-19 | Hardin | Kentucky | 21093 | 5470 | 40 |
843599 | 843599 | 2020-12-19 | Harlan | Kentucky | 21095 | 1350 | 16 |
843600 | 843600 | 2020-12-19 | Harrison | Kentucky | 21097 | 649 | 1 |
843601 | 843601 | 2020-12-19 | Hart | Kentucky | 21099 | 1172 | 8 |
843602 | 843602 | 2020-12-19 | Henderson | Kentucky | 21101 | 2654 | 47 |
843603 | 843603 | 2020-12-19 | Henry | Kentucky | 21103 | 734 | 3 |
843604 | 843604 | 2020-12-19 | Hickman | Kentucky | 21105 | 216 | 3 |
843605 | 843605 | 2020-12-19 | Hopkins | Kentucky | 21107 | 2395 | 87 |
843606 | 843606 | 2020-12-19 | Jackson | Kentucky | 21109 | 779 | 18 |
843607 | 843607 | 2020-12-19 | Jefferson | Kentucky | 21111 | 47935 | 612 |
843608 | 843608 | 2020-12-19 | Jessamine | Kentucky | 21113 | 2421 | 42 |
843609 | 843609 | 2020-12-19 | Johnson | Kentucky | 21115 | 1023 | 13 |
843610 | 843610 | 2020-12-19 | Kenton | Kentucky | 21117 | 7986 | 67 |
843611 | 843611 | 2020-12-19 | Knott | Kentucky | 21119 | 685 | 12 |
843612 | 843612 | 2020-12-19 | Knox | Kentucky | 21121 | 1552 | 10 |
843613 | 843613 | 2020-12-19 | Larue | Kentucky | 21123 | 776 | 3 |
843614 | 843614 | 2020-12-19 | Laurel | Kentucky | 21125 | 3196 | 12 |
843615 | 843615 | 2020-12-19 | Lawrence | Kentucky | 21127 | 613 | 4 |
843616 | 843616 | 2020-12-19 | Lee | Kentucky | 21129 | 1016 | 18 |
843617 | 843617 | 2020-12-19 | Leslie | Kentucky | 21131 | 411 | 1 |
843618 | 843618 | 2020-12-19 | Letcher | Kentucky | 21133 | 839 | 2 |
843619 | 843619 | 2020-12-19 | Lewis | Kentucky | 21135 | 681 | 22 |
843620 | 843620 | 2020-12-19 | Lincoln | Kentucky | 21137 | 1247 | 21 |
843621 | 843621 | 2020-12-19 | Livingston | Kentucky | 21139 | 437 | 4 |
843622 | 843622 | 2020-12-19 | Logan | Kentucky | 21141 | 1551 | 37 |
843623 | 843623 | 2020-12-19 | Lyon | Kentucky | 21143 | 280 | 5 |
843624 | 843624 | 2020-12-19 | Madison | Kentucky | 21151 | 5275 | 26 |
843625 | 843625 | 2020-12-19 | Magoffin | Kentucky | 21153 | 675 | 1 |
843626 | 843626 | 2020-12-19 | Marion | Kentucky | 21155 | 1431 | 17 |
843627 | 843627 | 2020-12-19 | Marshall | Kentucky | 21157 | 1331 | 19 |
843628 | 843628 | 2020-12-19 | Martin | Kentucky | 21159 | 600 | 10 |
843629 | 843629 | 2020-12-19 | Mason | Kentucky | 21161 | 813 | 11 |
843630 | 843630 | 2020-12-19 | McCracken | Kentucky | 21145 | 3949 | 36 |
843631 | 843631 | 2020-12-19 | McCreary | Kentucky | 21147 | 975 | 4 |
843632 | 843632 | 2020-12-19 | McLean | Kentucky | 21149 | 503 | 20 |
843633 | 843633 | 2020-12-19 | Meade | Kentucky | 21163 | 1029 | 4 |
843634 | 843634 | 2020-12-19 | Menifee | Kentucky | 21165 | 175 | 1 |
843635 | 843635 | 2020-12-19 | Mercer | Kentucky | 21167 | 1194 | 6 |
843636 | 843636 | 2020-12-19 | Metcalfe | Kentucky | 21169 | 552 | 7 |
843637 | 843637 | 2020-12-19 | Monroe | Kentucky | 21171 | 879 | 19 |
843638 | 843638 | 2020-12-19 | Montgomery | Kentucky | 21173 | 1272 | 12 |
843639 | 843639 | 2020-12-19 | Morgan | Kentucky | 21175 | 476 | 0 |
843640 | 843640 | 2020-12-19 | Muhlenberg | Kentucky | 21177 | 1772 | 32 |
843641 | 843641 | 2020-12-19 | Nelson | Kentucky | 21179 | 2646 | 17 |
843642 | 843642 | 2020-12-19 | Nicholas | Kentucky | 21181 | 225 | 3 |
843643 | 843643 | 2020-12-19 | Ohio | Kentucky | 21183 | 1382 | 27 |
843644 | 843644 | 2020-12-19 | Oldham | Kentucky | 21185 | 3373 | 48 |
843645 | 843645 | 2020-12-19 | Owen | Kentucky | 21187 | 344 | 3 |
843646 | 843646 | 2020-12-19 | Owsley | Kentucky | 21189 | 274 | 6 |
843647 | 843647 | 2020-12-19 | Pendleton | Kentucky | 21191 | 563 | 1 |
843648 | 843648 | 2020-12-19 | Perry | Kentucky | 21193 | 1436 | 11 |
843649 | 843649 | 2020-12-19 | Pike | Kentucky | 21195 | 2524 | 33 |
843650 | 843650 | 2020-12-19 | Powell | Kentucky | 21197 | 637 | 0 |
843651 | 843651 | 2020-12-19 | Pulaski | Kentucky | 21199 | 3370 | 49 |
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);