ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where "date" is on date 2020-10-12 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
622909 | 622909 | 2020-10-12 | Adair | Kentucky | 21001 | 418 | 20 |
622910 | 622910 | 2020-10-12 | Allen | Kentucky | 21003 | 445 | 10 |
622911 | 622911 | 2020-10-12 | Anderson | Kentucky | 21005 | 196 | 1 |
622912 | 622912 | 2020-10-12 | Ballard | Kentucky | 21007 | 60 | 1 |
622913 | 622913 | 2020-10-12 | Barren | Kentucky | 21009 | 866 | 13 |
622914 | 622914 | 2020-10-12 | Bath | Kentucky | 21011 | 94 | 1 |
622915 | 622915 | 2020-10-12 | Bell | Kentucky | 21013 | 565 | 16 |
622916 | 622916 | 2020-10-12 | Boone | Kentucky | 21015 | 1800 | 25 |
622917 | 622917 | 2020-10-12 | Bourbon | Kentucky | 21017 | 247 | 1 |
622918 | 622918 | 2020-10-12 | Boyd | Kentucky | 21019 | 552 | 14 |
622919 | 622919 | 2020-10-12 | Boyle | Kentucky | 21021 | 356 | 0 |
622920 | 622920 | 2020-10-12 | Bracken | Kentucky | 21023 | 43 | 0 |
622921 | 622921 | 2020-10-12 | Breathitt | Kentucky | 21025 | 100 | 0 |
622922 | 622922 | 2020-10-12 | Breckinridge | Kentucky | 21027 | 155 | 2 |
622923 | 622923 | 2020-10-12 | Bullitt | Kentucky | 21029 | 1069 | 12 |
622924 | 622924 | 2020-10-12 | Butler | Kentucky | 21031 | 384 | 16 |
622925 | 622925 | 2020-10-12 | Caldwell | Kentucky | 21033 | 193 | 0 |
622926 | 622926 | 2020-10-12 | Calloway | Kentucky | 21035 | 788 | 9 |
622927 | 622927 | 2020-10-12 | Campbell | Kentucky | 21037 | 992 | 19 |
622928 | 622928 | 2020-10-12 | Carlisle | Kentucky | 21039 | 88 | 1 |
622929 | 622929 | 2020-10-12 | Carroll | Kentucky | 21041 | 209 | 5 |
622930 | 622930 | 2020-10-12 | Carter | Kentucky | 21043 | 262 | 4 |
622931 | 622931 | 2020-10-12 | Casey | Kentucky | 21045 | 285 | 16 |
622932 | 622932 | 2020-10-12 | Christian | Kentucky | 21047 | 1579 | 26 |
622933 | 622933 | 2020-10-12 | Clark | Kentucky | 21049 | 400 | 10 |
622934 | 622934 | 2020-10-12 | Clay | Kentucky | 21051 | 371 | 6 |
622935 | 622935 | 2020-10-12 | Clinton | Kentucky | 21053 | 170 | 3 |
622936 | 622936 | 2020-10-12 | Crittenden | Kentucky | 21055 | 132 | 1 |
622937 | 622937 | 2020-10-12 | Cumberland | Kentucky | 21057 | 115 | 0 |
622938 | 622938 | 2020-10-12 | Daviess | Kentucky | 21059 | 1707 | 23 |
622939 | 622939 | 2020-10-12 | Edmonson | Kentucky | 21061 | 169 | 12 |
622940 | 622940 | 2020-10-12 | Elliott | Kentucky | 21063 | 59 | 0 |
622941 | 622941 | 2020-10-12 | Estill | Kentucky | 21065 | 226 | 0 |
622942 | 622942 | 2020-10-12 | Fayette | Kentucky | 21067 | 9385 | 82 |
622943 | 622943 | 2020-10-12 | Fleming | Kentucky | 21069 | 97 | 0 |
622944 | 622944 | 2020-10-12 | Floyd | Kentucky | 21071 | 237 | 4 |
622945 | 622945 | 2020-10-12 | Franklin | Kentucky | 21073 | 763 | 12 |
622946 | 622946 | 2020-10-12 | Fulton | Kentucky | 21075 | 202 | 3 |
622947 | 622947 | 2020-10-12 | Gallatin | Kentucky | 21077 | 107 | 8 |
622948 | 622948 | 2020-10-12 | Garrard | Kentucky | 21079 | 209 | 3 |
622949 | 622949 | 2020-10-12 | Grant | Kentucky | 21081 | 204 | 6 |
622950 | 622950 | 2020-10-12 | Graves | Kentucky | 21083 | 829 | 29 |
622951 | 622951 | 2020-10-12 | Grayson | Kentucky | 21085 | 430 | 15 |
622952 | 622952 | 2020-10-12 | Green | Kentucky | 21087 | 302 | 9 |
622953 | 622953 | 2020-10-12 | Greenup | Kentucky | 21089 | 509 | 5 |
622954 | 622954 | 2020-10-12 | Hancock | Kentucky | 21091 | 105 | 1 |
622955 | 622955 | 2020-10-12 | Hardin | Kentucky | 21093 | 1551 | 14 |
622956 | 622956 | 2020-10-12 | Harlan | Kentucky | 21095 | 526 | 13 |
622957 | 622957 | 2020-10-12 | Harrison | Kentucky | 21097 | 206 | 1 |
622958 | 622958 | 2020-10-12 | Hart | Kentucky | 21099 | 229 | 1 |
622959 | 622959 | 2020-10-12 | Henderson | Kentucky | 21101 | 1089 | 15 |
622960 | 622960 | 2020-10-12 | Henry | Kentucky | 21103 | 217 | 2 |
622961 | 622961 | 2020-10-12 | Hickman | Kentucky | 21105 | 92 | 1 |
622962 | 622962 | 2020-10-12 | Hopkins | Kentucky | 21107 | 830 | 41 |
622963 | 622963 | 2020-10-12 | Jackson | Kentucky | 21109 | 401 | 17 |
622964 | 622964 | 2020-10-12 | Jefferson | Kentucky | 21111 | 19646 | 336 |
622965 | 622965 | 2020-10-12 | Jessamine | Kentucky | 21113 | 751 | 0 |
622966 | 622966 | 2020-10-12 | Johnson | Kentucky | 21115 | 194 | 2 |
622967 | 622967 | 2020-10-12 | Kenton | Kentucky | 21117 | 2247 | 49 |
622968 | 622968 | 2020-10-12 | Knott | Kentucky | 21119 | 261 | 1 |
622969 | 622969 | 2020-10-12 | Knox | Kentucky | 21121 | 650 | 9 |
622970 | 622970 | 2020-10-12 | Larue | Kentucky | 21123 | 235 | 1 |
622971 | 622971 | 2020-10-12 | Laurel | Kentucky | 21125 | 1157 | 6 |
622972 | 622972 | 2020-10-12 | Lawrence | Kentucky | 21127 | 88 | 0 |
622973 | 622973 | 2020-10-12 | Lee | Kentucky | 21129 | 21 | 0 |
622974 | 622974 | 2020-10-12 | Leslie | Kentucky | 21131 | 105 | 0 |
622975 | 622975 | 2020-10-12 | Letcher | Kentucky | 21133 | 249 | 2 |
622976 | 622976 | 2020-10-12 | Lewis | Kentucky | 21135 | 249 | 15 |
622977 | 622977 | 2020-10-12 | Lincoln | Kentucky | 21137 | 250 | 16 |
622978 | 622978 | 2020-10-12 | Livingston | Kentucky | 21139 | 104 | 1 |
622979 | 622979 | 2020-10-12 | Logan | Kentucky | 21141 | 658 | 30 |
622980 | 622980 | 2020-10-12 | Lyon | Kentucky | 21143 | 86 | 4 |
622981 | 622981 | 2020-10-12 | Madison | Kentucky | 21151 | 2037 | 7 |
622982 | 622982 | 2020-10-12 | Magoffin | Kentucky | 21153 | 114 | 0 |
622983 | 622983 | 2020-10-12 | Marion | Kentucky | 21155 | 284 | 10 |
622984 | 622984 | 2020-10-12 | Marshall | Kentucky | 21157 | 374 | 4 |
622985 | 622985 | 2020-10-12 | Martin | Kentucky | 21159 | 98 | 3 |
622986 | 622986 | 2020-10-12 | Mason | Kentucky | 21161 | 139 | 2 |
622987 | 622987 | 2020-10-12 | McCracken | Kentucky | 21145 | 881 | 11 |
622988 | 622988 | 2020-10-12 | McCreary | Kentucky | 21147 | 226 | 1 |
622989 | 622989 | 2020-10-12 | McLean | Kentucky | 21149 | 106 | 0 |
622990 | 622990 | 2020-10-12 | Meade | Kentucky | 21163 | 302 | 3 |
622991 | 622991 | 2020-10-12 | Menifee | Kentucky | 21165 | 69 | 1 |
622992 | 622992 | 2020-10-12 | Mercer | Kentucky | 21167 | 288 | 5 |
622993 | 622993 | 2020-10-12 | Metcalfe | Kentucky | 21169 | 152 | 2 |
622994 | 622994 | 2020-10-12 | Monroe | Kentucky | 21171 | 230 | 4 |
622995 | 622995 | 2020-10-12 | Montgomery | Kentucky | 21173 | 339 | 3 |
622996 | 622996 | 2020-10-12 | Morgan | Kentucky | 21175 | 98 | 0 |
622997 | 622997 | 2020-10-12 | Muhlenberg | Kentucky | 21177 | 881 | 13 |
622998 | 622998 | 2020-10-12 | Nelson | Kentucky | 21179 | 595 | 4 |
622999 | 622999 | 2020-10-12 | Nicholas | Kentucky | 21181 | 68 | 1 |
623000 | 623000 | 2020-10-12 | Ohio | Kentucky | 21183 | 536 | 9 |
623001 | 623001 | 2020-10-12 | Oldham | Kentucky | 21185 | 1245 | 26 |
623002 | 623002 | 2020-10-12 | Owen | Kentucky | 21187 | 106 | 2 |
623003 | 623003 | 2020-10-12 | Owsley | Kentucky | 21189 | 52 | 1 |
623004 | 623004 | 2020-10-12 | Pendleton | Kentucky | 21191 | 106 | 0 |
623005 | 623005 | 2020-10-12 | Perry | Kentucky | 21193 | 377 | 9 |
623006 | 623006 | 2020-10-12 | Pike | Kentucky | 21195 | 585 | 3 |
623007 | 623007 | 2020-10-12 | Powell | Kentucky | 21197 | 123 | 0 |
623008 | 623008 | 2020-10-12 | Pulaski | Kentucky | 21199 | 915 | 12 |
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);