ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where date = "2020-04-26" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
90578 | 90578 | 2020-04-26 | Adair | Kentucky | 21001 | 83 | 9 |
90579 | 90579 | 2020-04-26 | Allen | Kentucky | 21003 | 7 | 0 |
90580 | 90580 | 2020-04-26 | Anderson | Kentucky | 21005 | 8 | 1 |
90581 | 90581 | 2020-04-26 | Ballard | Kentucky | 21007 | 7 | 0 |
90582 | 90582 | 2020-04-26 | Barren | Kentucky | 21009 | 13 | 0 |
90583 | 90583 | 2020-04-26 | Bath | Kentucky | 21011 | 4 | 0 |
90584 | 90584 | 2020-04-26 | Boone | Kentucky | 21015 | 113 | 2 |
90585 | 90585 | 2020-04-26 | Bourbon | Kentucky | 21017 | 8 | 1 |
90586 | 90586 | 2020-04-26 | Boyd | Kentucky | 21019 | 33 | 3 |
90587 | 90587 | 2020-04-26 | Boyle | Kentucky | 21021 | 18 | 0 |
90588 | 90588 | 2020-04-26 | Bracken | Kentucky | 21023 | 7 | 0 |
90589 | 90589 | 2020-04-26 | Breathitt | Kentucky | 21025 | 3 | 0 |
90590 | 90590 | 2020-04-26 | Breckinridge | Kentucky | 21027 | 8 | 0 |
90591 | 90591 | 2020-04-26 | Bullitt | Kentucky | 21029 | 48 | 2 |
90592 | 90592 | 2020-04-26 | Butler | Kentucky | 21031 | 104 | 3 |
90593 | 90593 | 2020-04-26 | Caldwell | Kentucky | 21033 | 13 | 0 |
90594 | 90594 | 2020-04-26 | Calloway | Kentucky | 21035 | 31 | 1 |
90595 | 90595 | 2020-04-26 | Campbell | Kentucky | 21037 | 79 | 7 |
90596 | 90596 | 2020-04-26 | Carlisle | Kentucky | 21039 | 1 | 0 |
90597 | 90597 | 2020-04-26 | Carroll | Kentucky | 21041 | 2 | 0 |
90598 | 90598 | 2020-04-26 | Carter | Kentucky | 21043 | 4 | 0 |
90599 | 90599 | 2020-04-26 | Casey | Kentucky | 21045 | 1 | 0 |
90600 | 90600 | 2020-04-26 | Christian | Kentucky | 21047 | 85 | 3 |
90601 | 90601 | 2020-04-26 | Clark | Kentucky | 21049 | 19 | 0 |
90602 | 90602 | 2020-04-26 | Clay | Kentucky | 21051 | 1 | 0 |
90603 | 90603 | 2020-04-26 | Clinton | Kentucky | 21053 | 2 | 0 |
90604 | 90604 | 2020-04-26 | Crittenden | Kentucky | 21055 | 3 | 1 |
90605 | 90605 | 2020-04-26 | Cumberland | Kentucky | 21057 | 5 | 0 |
90606 | 90606 | 2020-04-26 | Daviess | Kentucky | 21059 | 161 | 6 |
90607 | 90607 | 2020-04-26 | Edmonson | Kentucky | 21061 | 15 | 0 |
90608 | 90608 | 2020-04-26 | Fayette | Kentucky | 21067 | 238 | 8 |
90609 | 90609 | 2020-04-26 | Fleming | Kentucky | 21069 | 2 | 0 |
90610 | 90610 | 2020-04-26 | Floyd | Kentucky | 21071 | 10 | 0 |
90611 | 90611 | 2020-04-26 | Franklin | Kentucky | 21073 | 16 | 0 |
90612 | 90612 | 2020-04-26 | Fulton | Kentucky | 21075 | 1 | 0 |
90613 | 90613 | 2020-04-26 | Gallatin | Kentucky | 21077 | 1 | 0 |
90614 | 90614 | 2020-04-26 | Garrard | Kentucky | 21079 | 2 | 0 |
90615 | 90615 | 2020-04-26 | Grant | Kentucky | 21081 | 18 | 3 |
90616 | 90616 | 2020-04-26 | Graves | Kentucky | 21083 | 114 | 11 |
90617 | 90617 | 2020-04-26 | Grayson | Kentucky | 21085 | 60 | 1 |
90618 | 90618 | 2020-04-26 | Green | Kentucky | 21087 | 1 | 0 |
90619 | 90619 | 2020-04-26 | Greenup | Kentucky | 21089 | 11 | 0 |
90620 | 90620 | 2020-04-26 | Hancock | Kentucky | 21091 | 6 | 0 |
90621 | 90621 | 2020-04-26 | Hardin | Kentucky | 21093 | 35 | 0 |
90622 | 90622 | 2020-04-26 | Harrison | Kentucky | 21097 | 18 | 0 |
90623 | 90623 | 2020-04-26 | Hart | Kentucky | 21099 | 3 | 0 |
90624 | 90624 | 2020-04-26 | Henderson | Kentucky | 21101 | 58 | 1 |
90625 | 90625 | 2020-04-26 | Henry | Kentucky | 21103 | 6 | 0 |
90626 | 90626 | 2020-04-26 | Hickman | Kentucky | 21105 | 2 | 0 |
90627 | 90627 | 2020-04-26 | Hopkins | Kentucky | 21107 | 184 | 20 |
90628 | 90628 | 2020-04-26 | Jackson | Kentucky | 21109 | 60 | 6 |
90629 | 90629 | 2020-04-26 | Jefferson | Kentucky | 21111 | 1121 | 81 |
90630 | 90630 | 2020-04-26 | Jessamine | Kentucky | 21113 | 34 | 0 |
90631 | 90631 | 2020-04-26 | Johnson | Kentucky | 21115 | 2 | 0 |
90632 | 90632 | 2020-04-26 | Kenton | Kentucky | 21117 | 227 | 16 |
90633 | 90633 | 2020-04-26 | Knott | Kentucky | 21119 | 4 | 0 |
90634 | 90634 | 2020-04-26 | Knox | Kentucky | 21121 | 5 | 0 |
90635 | 90635 | 2020-04-26 | Larue | Kentucky | 21123 | 5 | 0 |
90636 | 90636 | 2020-04-26 | Laurel | Kentucky | 21125 | 14 | 2 |
90637 | 90637 | 2020-04-26 | Lawrence | Kentucky | 21127 | 1 | 0 |
90638 | 90638 | 2020-04-26 | Leslie | Kentucky | 21131 | 2 | 0 |
90639 | 90639 | 2020-04-26 | Letcher | Kentucky | 21133 | 2 | 0 |
90640 | 90640 | 2020-04-26 | Lewis | Kentucky | 21135 | 3 | 0 |
90641 | 90641 | 2020-04-26 | Lincoln | Kentucky | 21137 | 4 | 1 |
90642 | 90642 | 2020-04-26 | Livingston | Kentucky | 21139 | 1 | 0 |
90643 | 90643 | 2020-04-26 | Logan | Kentucky | 21141 | 8 | 0 |
90644 | 90644 | 2020-04-26 | Lyon | Kentucky | 21143 | 14 | 3 |
90645 | 90645 | 2020-04-26 | Madison | Kentucky | 21151 | 29 | 1 |
90646 | 90646 | 2020-04-26 | Marion | Kentucky | 21155 | 15 | 0 |
90647 | 90647 | 2020-04-26 | Marshall | Kentucky | 21157 | 31 | 0 |
90648 | 90648 | 2020-04-26 | Martin | Kentucky | 21159 | 3 | 0 |
90649 | 90649 | 2020-04-26 | Mason | Kentucky | 21161 | 6 | 0 |
90650 | 90650 | 2020-04-26 | McCracken | Kentucky | 21145 | 43 | 2 |
90651 | 90651 | 2020-04-26 | McCreary | Kentucky | 21147 | 11 | 0 |
90652 | 90652 | 2020-04-26 | McLean | Kentucky | 21149 | 11 | 0 |
90653 | 90653 | 2020-04-26 | Meade | Kentucky | 21163 | 7 | 1 |
90654 | 90654 | 2020-04-26 | Menifee | Kentucky | 21165 | 3 | 0 |
90655 | 90655 | 2020-04-26 | Mercer | Kentucky | 21167 | 11 | 0 |
90656 | 90656 | 2020-04-26 | Monroe | Kentucky | 21171 | 4 | 0 |
90657 | 90657 | 2020-04-26 | Montgomery | Kentucky | 21173 | 10 | 0 |
90658 | 90658 | 2020-04-26 | Morgan | Kentucky | 21175 | 1 | 0 |
90659 | 90659 | 2020-04-26 | Muhlenberg | Kentucky | 21177 | 111 | 4 |
90660 | 90660 | 2020-04-26 | Nelson | Kentucky | 21179 | 19 | 0 |
90661 | 90661 | 2020-04-26 | Nicholas | Kentucky | 21181 | 1 | 0 |
90662 | 90662 | 2020-04-26 | Ohio | Kentucky | 21183 | 40 | 0 |
90663 | 90663 | 2020-04-26 | Oldham | Kentucky | 21185 | 27 | 0 |
90664 | 90664 | 2020-04-26 | Owsley | Kentucky | 21189 | 3 | 0 |
90665 | 90665 | 2020-04-26 | Pendleton | Kentucky | 21191 | 5 | 0 |
90666 | 90666 | 2020-04-26 | Perry | Kentucky | 21193 | 6 | 0 |
90667 | 90667 | 2020-04-26 | Pike | Kentucky | 21195 | 9 | 2 |
90668 | 90668 | 2020-04-26 | Powell | Kentucky | 21197 | 1 | 0 |
90669 | 90669 | 2020-04-26 | Pulaski | Kentucky | 21199 | 41 | 2 |
90670 | 90670 | 2020-04-26 | Rockcastle | Kentucky | 21203 | 11 | 0 |
90671 | 90671 | 2020-04-26 | Rowan | Kentucky | 21205 | 2 | 0 |
90672 | 90672 | 2020-04-26 | Russell | Kentucky | 21207 | 16 | 2 |
90673 | 90673 | 2020-04-26 | Scott | Kentucky | 21209 | 28 | 0 |
90674 | 90674 | 2020-04-26 | Shelby | Kentucky | 21211 | 28 | 3 |
90675 | 90675 | 2020-04-26 | Simpson | Kentucky | 21213 | 24 | 2 |
90676 | 90676 | 2020-04-26 | Spencer | Kentucky | 21215 | 10 | 0 |
90677 | 90677 | 2020-04-26 | Taylor | Kentucky | 21217 | 6 | 0 |
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);