ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2020-10-20" 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 |
---|---|---|---|---|---|---|---|
648869 | 648869 | 2020-10-20 | Adair | Kentucky | 21001 | 472 | 22 |
648870 | 648870 | 2020-10-20 | Allen | Kentucky | 21003 | 494 | 11 |
648871 | 648871 | 2020-10-20 | Anderson | Kentucky | 21005 | 225 | 1 |
648872 | 648872 | 2020-10-20 | Ballard | Kentucky | 21007 | 68 | 1 |
648873 | 648873 | 2020-10-20 | Barren | Kentucky | 21009 | 1004 | 13 |
648874 | 648874 | 2020-10-20 | Bath | Kentucky | 21011 | 104 | 1 |
648875 | 648875 | 2020-10-20 | Bell | Kentucky | 21013 | 623 | 17 |
648876 | 648876 | 2020-10-20 | Boone | Kentucky | 21015 | 1941 | 25 |
648877 | 648877 | 2020-10-20 | Bourbon | Kentucky | 21017 | 297 | 1 |
648878 | 648878 | 2020-10-20 | Boyd | Kentucky | 21019 | 600 | 19 |
648879 | 648879 | 2020-10-20 | Boyle | Kentucky | 21021 | 406 | 0 |
648880 | 648880 | 2020-10-20 | Bracken | Kentucky | 21023 | 52 | 1 |
648881 | 648881 | 2020-10-20 | Breathitt | Kentucky | 21025 | 112 | 0 |
648882 | 648882 | 2020-10-20 | Breckinridge | Kentucky | 21027 | 177 | 2 |
648883 | 648883 | 2020-10-20 | Bullitt | Kentucky | 21029 | 1256 | 14 |
648884 | 648884 | 2020-10-20 | Butler | Kentucky | 21031 | 410 | 16 |
648885 | 648885 | 2020-10-20 | Caldwell | Kentucky | 21033 | 239 | 0 |
648886 | 648886 | 2020-10-20 | Calloway | Kentucky | 21035 | 857 | 9 |
648887 | 648887 | 2020-10-20 | Campbell | Kentucky | 21037 | 1085 | 19 |
648888 | 648888 | 2020-10-20 | Carlisle | Kentucky | 21039 | 101 | 1 |
648889 | 648889 | 2020-10-20 | Carroll | Kentucky | 21041 | 212 | 5 |
648890 | 648890 | 2020-10-20 | Carter | Kentucky | 21043 | 303 | 4 |
648891 | 648891 | 2020-10-20 | Casey | Kentucky | 21045 | 307 | 16 |
648892 | 648892 | 2020-10-20 | Christian | Kentucky | 21047 | 1774 | 28 |
648893 | 648893 | 2020-10-20 | Clark | Kentucky | 21049 | 452 | 10 |
648894 | 648894 | 2020-10-20 | Clay | Kentucky | 21051 | 444 | 6 |
648895 | 648895 | 2020-10-20 | Clinton | Kentucky | 21053 | 221 | 4 |
648896 | 648896 | 2020-10-20 | Crittenden | Kentucky | 21055 | 153 | 1 |
648897 | 648897 | 2020-10-20 | Cumberland | Kentucky | 21057 | 132 | 0 |
648898 | 648898 | 2020-10-20 | Daviess | Kentucky | 21059 | 1822 | 27 |
648899 | 648899 | 2020-10-20 | Edmonson | Kentucky | 21061 | 188 | 12 |
648900 | 648900 | 2020-10-20 | Elliott | Kentucky | 21063 | 62 | 0 |
648901 | 648901 | 2020-10-20 | Estill | Kentucky | 21065 | 251 | 0 |
648902 | 648902 | 2020-10-20 | Fayette | Kentucky | 21067 | 10016 | 89 |
648903 | 648903 | 2020-10-20 | Fleming | Kentucky | 21069 | 143 | 0 |
648904 | 648904 | 2020-10-20 | Floyd | Kentucky | 21071 | 298 | 4 |
648905 | 648905 | 2020-10-20 | Franklin | Kentucky | 21073 | 800 | 14 |
648906 | 648906 | 2020-10-20 | Fulton | Kentucky | 21075 | 217 | 3 |
648907 | 648907 | 2020-10-20 | Gallatin | Kentucky | 21077 | 117 | 8 |
648908 | 648908 | 2020-10-20 | Garrard | Kentucky | 21079 | 258 | 3 |
648909 | 648909 | 2020-10-20 | Grant | Kentucky | 21081 | 220 | 6 |
648910 | 648910 | 2020-10-20 | Graves | Kentucky | 21083 | 849 | 29 |
648911 | 648911 | 2020-10-20 | Grayson | Kentucky | 21085 | 466 | 15 |
648912 | 648912 | 2020-10-20 | Green | Kentucky | 21087 | 329 | 9 |
648913 | 648913 | 2020-10-20 | Greenup | Kentucky | 21089 | 568 | 8 |
648914 | 648914 | 2020-10-20 | Hancock | Kentucky | 21091 | 120 | 1 |
648915 | 648915 | 2020-10-20 | Hardin | Kentucky | 21093 | 1711 | 15 |
648916 | 648916 | 2020-10-20 | Harlan | Kentucky | 21095 | 566 | 13 |
648917 | 648917 | 2020-10-20 | Harrison | Kentucky | 21097 | 247 | 1 |
648918 | 648918 | 2020-10-20 | Hart | Kentucky | 21099 | 309 | 1 |
648919 | 648919 | 2020-10-20 | Henderson | Kentucky | 21101 | 1222 | 24 |
648920 | 648920 | 2020-10-20 | Henry | Kentucky | 21103 | 239 | 2 |
648921 | 648921 | 2020-10-20 | Hickman | Kentucky | 21105 | 103 | 1 |
648922 | 648922 | 2020-10-20 | Hopkins | Kentucky | 21107 | 950 | 43 |
648923 | 648923 | 2020-10-20 | Jackson | Kentucky | 21109 | 422 | 17 |
648924 | 648924 | 2020-10-20 | Jefferson | Kentucky | 21111 | 21513 | 361 |
648925 | 648925 | 2020-10-20 | Jessamine | Kentucky | 21113 | 876 | 6 |
648926 | 648926 | 2020-10-20 | Johnson | Kentucky | 21115 | 260 | 2 |
648927 | 648927 | 2020-10-20 | Kenton | Kentucky | 21117 | 2407 | 49 |
648928 | 648928 | 2020-10-20 | Knott | Kentucky | 21119 | 303 | 2 |
648929 | 648929 | 2020-10-20 | Knox | Kentucky | 21121 | 739 | 9 |
648930 | 648930 | 2020-10-20 | Larue | Kentucky | 21123 | 262 | 1 |
648931 | 648931 | 2020-10-20 | Laurel | Kentucky | 21125 | 1272 | 7 |
648932 | 648932 | 2020-10-20 | Lawrence | Kentucky | 21127 | 126 | 0 |
648933 | 648933 | 2020-10-20 | Lee | Kentucky | 21129 | 46 | 0 |
648934 | 648934 | 2020-10-20 | Leslie | Kentucky | 21131 | 120 | 0 |
648935 | 648935 | 2020-10-20 | Letcher | Kentucky | 21133 | 286 | 2 |
648936 | 648936 | 2020-10-20 | Lewis | Kentucky | 21135 | 264 | 15 |
648937 | 648937 | 2020-10-20 | Lincoln | Kentucky | 21137 | 283 | 18 |
648938 | 648938 | 2020-10-20 | Livingston | Kentucky | 21139 | 121 | 1 |
648939 | 648939 | 2020-10-20 | Logan | Kentucky | 21141 | 728 | 30 |
648940 | 648940 | 2020-10-20 | Lyon | Kentucky | 21143 | 98 | 4 |
648941 | 648941 | 2020-10-20 | Madison | Kentucky | 21151 | 2186 | 11 |
648942 | 648942 | 2020-10-20 | Magoffin | Kentucky | 21153 | 143 | 0 |
648943 | 648943 | 2020-10-20 | Marion | Kentucky | 21155 | 359 | 10 |
648944 | 648944 | 2020-10-20 | Marshall | Kentucky | 21157 | 429 | 6 |
648945 | 648945 | 2020-10-20 | Martin | Kentucky | 21159 | 143 | 3 |
648946 | 648946 | 2020-10-20 | Mason | Kentucky | 21161 | 158 | 2 |
648947 | 648947 | 2020-10-20 | McCracken | Kentucky | 21145 | 977 | 11 |
648948 | 648948 | 2020-10-20 | McCreary | Kentucky | 21147 | 249 | 1 |
648949 | 648949 | 2020-10-20 | McLean | Kentucky | 21149 | 149 | 2 |
648950 | 648950 | 2020-10-20 | Meade | Kentucky | 21163 | 370 | 3 |
648951 | 648951 | 2020-10-20 | Menifee | Kentucky | 21165 | 76 | 1 |
648952 | 648952 | 2020-10-20 | Mercer | Kentucky | 21167 | 324 | 6 |
648953 | 648953 | 2020-10-20 | Metcalfe | Kentucky | 21169 | 182 | 2 |
648954 | 648954 | 2020-10-20 | Monroe | Kentucky | 21171 | 255 | 4 |
648955 | 648955 | 2020-10-20 | Montgomery | Kentucky | 21173 | 385 | 4 |
648956 | 648956 | 2020-10-20 | Morgan | Kentucky | 21175 | 104 | 0 |
648957 | 648957 | 2020-10-20 | Muhlenberg | Kentucky | 21177 | 952 | 15 |
648958 | 648958 | 2020-10-20 | Nelson | Kentucky | 21179 | 725 | 4 |
648959 | 648959 | 2020-10-20 | Nicholas | Kentucky | 21181 | 98 | 1 |
648960 | 648960 | 2020-10-20 | Ohio | Kentucky | 21183 | 584 | 9 |
648961 | 648961 | 2020-10-20 | Oldham | Kentucky | 21185 | 1342 | 26 |
648962 | 648962 | 2020-10-20 | Owen | Kentucky | 21187 | 115 | 3 |
648963 | 648963 | 2020-10-20 | Owsley | Kentucky | 21189 | 70 | 1 |
648964 | 648964 | 2020-10-20 | Pendleton | Kentucky | 21191 | 111 | 0 |
648965 | 648965 | 2020-10-20 | Perry | Kentucky | 21193 | 454 | 9 |
648966 | 648966 | 2020-10-20 | Pike | Kentucky | 21195 | 713 | 3 |
648967 | 648967 | 2020-10-20 | Powell | Kentucky | 21197 | 133 | 0 |
648968 | 648968 | 2020-10-20 | Pulaski | Kentucky | 21199 | 969 | 13 |
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);