ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
112 rows where "date" is on date 2020-05-02 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 |
---|---|---|---|---|---|---|---|
107656 | 107656 | 2020-05-02 | Adair | Kentucky | 21001 | 81 | 11 |
107657 | 107657 | 2020-05-02 | Allen | Kentucky | 21003 | 14 | 0 |
107658 | 107658 | 2020-05-02 | Anderson | Kentucky | 21005 | 8 | 1 |
107659 | 107659 | 2020-05-02 | Ballard | Kentucky | 21007 | 10 | 0 |
107660 | 107660 | 2020-05-02 | Barren | Kentucky | 21009 | 17 | 0 |
107661 | 107661 | 2020-05-02 | Bath | Kentucky | 21011 | 4 | 1 |
107662 | 107662 | 2020-05-02 | Boone | Kentucky | 21015 | 144 | 2 |
107663 | 107663 | 2020-05-02 | Bourbon | Kentucky | 21017 | 8 | 1 |
107664 | 107664 | 2020-05-02 | Boyd | Kentucky | 21019 | 33 | 3 |
107665 | 107665 | 2020-05-02 | Boyle | Kentucky | 21021 | 18 | 0 |
107666 | 107666 | 2020-05-02 | Bracken | Kentucky | 21023 | 9 | 0 |
107667 | 107667 | 2020-05-02 | Breathitt | Kentucky | 21025 | 3 | 0 |
107668 | 107668 | 2020-05-02 | Breckinridge | Kentucky | 21027 | 9 | 0 |
107669 | 107669 | 2020-05-02 | Bullitt | Kentucky | 21029 | 57 | 2 |
107670 | 107670 | 2020-05-02 | Butler | Kentucky | 21031 | 141 | 5 |
107671 | 107671 | 2020-05-02 | Caldwell | Kentucky | 21033 | 13 | 0 |
107672 | 107672 | 2020-05-02 | Calloway | Kentucky | 21035 | 34 | 1 |
107673 | 107673 | 2020-05-02 | Campbell | Kentucky | 21037 | 92 | 9 |
107674 | 107674 | 2020-05-02 | Carlisle | Kentucky | 21039 | 2 | 1 |
107675 | 107675 | 2020-05-02 | Carroll | Kentucky | 21041 | 2 | 0 |
107676 | 107676 | 2020-05-02 | Carter | Kentucky | 21043 | 5 | 0 |
107677 | 107677 | 2020-05-02 | Casey | Kentucky | 21045 | 1 | 0 |
107678 | 107678 | 2020-05-02 | Christian | Kentucky | 21047 | 88 | 3 |
107679 | 107679 | 2020-05-02 | Clark | Kentucky | 21049 | 21 | 0 |
107680 | 107680 | 2020-05-02 | Clay | Kentucky | 21051 | 1 | 0 |
107681 | 107681 | 2020-05-02 | Clinton | Kentucky | 21053 | 3 | 0 |
107682 | 107682 | 2020-05-02 | Crittenden | Kentucky | 21055 | 4 | 1 |
107683 | 107683 | 2020-05-02 | Cumberland | Kentucky | 21057 | 5 | 0 |
107684 | 107684 | 2020-05-02 | Daviess | Kentucky | 21059 | 194 | 4 |
107685 | 107685 | 2020-05-02 | Edmonson | Kentucky | 21061 | 32 | 0 |
107686 | 107686 | 2020-05-02 | Fayette | Kentucky | 21067 | 254 | 9 |
107687 | 107687 | 2020-05-02 | Fleming | Kentucky | 21069 | 2 | 0 |
107688 | 107688 | 2020-05-02 | Floyd | Kentucky | 21071 | 14 | 0 |
107689 | 107689 | 2020-05-02 | Franklin | Kentucky | 21073 | 16 | 0 |
107690 | 107690 | 2020-05-02 | Fulton | Kentucky | 21075 | 2 | 0 |
107691 | 107691 | 2020-05-02 | Gallatin | Kentucky | 21077 | 1 | 0 |
107692 | 107692 | 2020-05-02 | Garrard | Kentucky | 21079 | 2 | 0 |
107693 | 107693 | 2020-05-02 | Grant | Kentucky | 21081 | 24 | 3 |
107694 | 107694 | 2020-05-02 | Graves | Kentucky | 21083 | 137 | 14 |
107695 | 107695 | 2020-05-02 | Grayson | Kentucky | 21085 | 69 | 5 |
107696 | 107696 | 2020-05-02 | Green | Kentucky | 21087 | 1 | 0 |
107697 | 107697 | 2020-05-02 | Greenup | Kentucky | 21089 | 11 | 0 |
107698 | 107698 | 2020-05-02 | Hancock | Kentucky | 21091 | 6 | 0 |
107699 | 107699 | 2020-05-02 | Hardin | Kentucky | 21093 | 44 | 0 |
107700 | 107700 | 2020-05-02 | Harrison | Kentucky | 21097 | 17 | 0 |
107701 | 107701 | 2020-05-02 | Hart | Kentucky | 21099 | 8 | 0 |
107702 | 107702 | 2020-05-02 | Henderson | Kentucky | 21101 | 63 | 1 |
107703 | 107703 | 2020-05-02 | Henry | Kentucky | 21103 | 6 | 0 |
107704 | 107704 | 2020-05-02 | Hickman | Kentucky | 21105 | 1 | 0 |
107705 | 107705 | 2020-05-02 | Hopkins | Kentucky | 21107 | 201 | 23 |
107706 | 107706 | 2020-05-02 | Jackson | Kentucky | 21109 | 59 | 8 |
107707 | 107707 | 2020-05-02 | Jefferson | Kentucky | 21111 | 1365 | 96 |
107708 | 107708 | 2020-05-02 | Jessamine | Kentucky | 21113 | 41 | 0 |
107709 | 107709 | 2020-05-02 | Johnson | Kentucky | 21115 | 3 | 0 |
107710 | 107710 | 2020-05-02 | Kenton | Kentucky | 21117 | 292 | 20 |
107711 | 107711 | 2020-05-02 | Knott | Kentucky | 21119 | 4 | 0 |
107712 | 107712 | 2020-05-02 | Knox | Kentucky | 21121 | 6 | 0 |
107713 | 107713 | 2020-05-02 | Larue | Kentucky | 21123 | 5 | 0 |
107714 | 107714 | 2020-05-02 | Laurel | Kentucky | 21125 | 17 | 2 |
107715 | 107715 | 2020-05-02 | Lawrence | Kentucky | 21127 | 1 | 0 |
107716 | 107716 | 2020-05-02 | Leslie | Kentucky | 21131 | 4 | 0 |
107717 | 107717 | 2020-05-02 | Letcher | Kentucky | 21133 | 2 | 0 |
107718 | 107718 | 2020-05-02 | Lewis | Kentucky | 21135 | 3 | 0 |
107719 | 107719 | 2020-05-02 | Lincoln | Kentucky | 21137 | 5 | 1 |
107720 | 107720 | 2020-05-02 | Livingston | Kentucky | 21139 | 5 | 0 |
107721 | 107721 | 2020-05-02 | Logan | Kentucky | 21141 | 11 | 0 |
107722 | 107722 | 2020-05-02 | Lyon | Kentucky | 21143 | 13 | 3 |
107723 | 107723 | 2020-05-02 | Madison | Kentucky | 21151 | 29 | 1 |
107724 | 107724 | 2020-05-02 | Marion | Kentucky | 21155 | 17 | 0 |
107725 | 107725 | 2020-05-02 | Marshall | Kentucky | 21157 | 34 | 1 |
107726 | 107726 | 2020-05-02 | Martin | Kentucky | 21159 | 3 | 0 |
107727 | 107727 | 2020-05-02 | Mason | Kentucky | 21161 | 6 | 0 |
107728 | 107728 | 2020-05-02 | McCracken | Kentucky | 21145 | 58 | 2 |
107729 | 107729 | 2020-05-02 | McCreary | Kentucky | 21147 | 11 | 0 |
107730 | 107730 | 2020-05-02 | McLean | Kentucky | 21149 | 14 | 0 |
107731 | 107731 | 2020-05-02 | Meade | Kentucky | 21163 | 12 | 1 |
107732 | 107732 | 2020-05-02 | Menifee | Kentucky | 21165 | 3 | 0 |
107733 | 107733 | 2020-05-02 | Mercer | Kentucky | 21167 | 11 | 0 |
107734 | 107734 | 2020-05-02 | Metcalfe | Kentucky | 21169 | 1 | 0 |
107735 | 107735 | 2020-05-02 | Monroe | Kentucky | 21171 | 5 | 0 |
107736 | 107736 | 2020-05-02 | Montgomery | Kentucky | 21173 | 12 | 0 |
107737 | 107737 | 2020-05-02 | Morgan | Kentucky | 21175 | 1 | 0 |
107738 | 107738 | 2020-05-02 | Muhlenberg | Kentucky | 21177 | 125 | 4 |
107739 | 107739 | 2020-05-02 | Nelson | Kentucky | 21179 | 23 | 0 |
107740 | 107740 | 2020-05-02 | Nicholas | Kentucky | 21181 | 1 | 0 |
107741 | 107741 | 2020-05-02 | Ohio | Kentucky | 21183 | 49 | 0 |
107742 | 107742 | 2020-05-02 | Oldham | Kentucky | 21185 | 32 | 0 |
107743 | 107743 | 2020-05-02 | Owen | Kentucky | 21187 | 1 | 0 |
107744 | 107744 | 2020-05-02 | Owsley | Kentucky | 21189 | 2 | 0 |
107745 | 107745 | 2020-05-02 | Pendleton | Kentucky | 21191 | 6 | 0 |
107746 | 107746 | 2020-05-02 | Perry | Kentucky | 21193 | 13 | 0 |
107747 | 107747 | 2020-05-02 | Pike | Kentucky | 21195 | 13 | 2 |
107748 | 107748 | 2020-05-02 | Powell | Kentucky | 21197 | 1 | 0 |
107749 | 107749 | 2020-05-02 | Pulaski | Kentucky | 21199 | 43 | 2 |
107750 | 107750 | 2020-05-02 | Rockcastle | Kentucky | 21203 | 11 | 0 |
107751 | 107751 | 2020-05-02 | Rowan | Kentucky | 21205 | 2 | 0 |
107752 | 107752 | 2020-05-02 | Russell | Kentucky | 21207 | 16 | 3 |
107753 | 107753 | 2020-05-02 | Scott | Kentucky | 21209 | 29 | 0 |
107754 | 107754 | 2020-05-02 | Shelby | Kentucky | 21211 | 30 | 3 |
107755 | 107755 | 2020-05-02 | Simpson | Kentucky | 21213 | 28 | 2 |
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);