ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2020-10-17" 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 |
---|---|---|---|---|---|---|---|
639131 | 639131 | 2020-10-17 | Adair | Kentucky | 21001 | 448 | 21 |
639132 | 639132 | 2020-10-17 | Allen | Kentucky | 21003 | 469 | 10 |
639133 | 639133 | 2020-10-17 | Anderson | Kentucky | 21005 | 222 | 1 |
639134 | 639134 | 2020-10-17 | Ballard | Kentucky | 21007 | 66 | 1 |
639135 | 639135 | 2020-10-17 | Barren | Kentucky | 21009 | 947 | 13 |
639136 | 639136 | 2020-10-17 | Bath | Kentucky | 21011 | 103 | 1 |
639137 | 639137 | 2020-10-17 | Bell | Kentucky | 21013 | 596 | 16 |
639138 | 639138 | 2020-10-17 | Boone | Kentucky | 21015 | 1887 | 25 |
639139 | 639139 | 2020-10-17 | Bourbon | Kentucky | 21017 | 283 | 1 |
639140 | 639140 | 2020-10-17 | Boyd | Kentucky | 21019 | 585 | 17 |
639141 | 639141 | 2020-10-17 | Boyle | Kentucky | 21021 | 392 | 0 |
639142 | 639142 | 2020-10-17 | Bracken | Kentucky | 21023 | 50 | 1 |
639143 | 639143 | 2020-10-17 | Breathitt | Kentucky | 21025 | 108 | 0 |
639144 | 639144 | 2020-10-17 | Breckinridge | Kentucky | 21027 | 173 | 2 |
639145 | 639145 | 2020-10-17 | Bullitt | Kentucky | 21029 | 1191 | 14 |
639146 | 639146 | 2020-10-17 | Butler | Kentucky | 21031 | 399 | 16 |
639147 | 639147 | 2020-10-17 | Caldwell | Kentucky | 21033 | 236 | 0 |
639148 | 639148 | 2020-10-17 | Calloway | Kentucky | 21035 | 840 | 9 |
639149 | 639149 | 2020-10-17 | Campbell | Kentucky | 21037 | 1066 | 19 |
639150 | 639150 | 2020-10-17 | Carlisle | Kentucky | 21039 | 98 | 1 |
639151 | 639151 | 2020-10-17 | Carroll | Kentucky | 21041 | 209 | 5 |
639152 | 639152 | 2020-10-17 | Carter | Kentucky | 21043 | 284 | 4 |
639153 | 639153 | 2020-10-17 | Casey | Kentucky | 21045 | 290 | 16 |
639154 | 639154 | 2020-10-17 | Christian | Kentucky | 21047 | 1700 | 28 |
639155 | 639155 | 2020-10-17 | Clark | Kentucky | 21049 | 437 | 10 |
639156 | 639156 | 2020-10-17 | Clay | Kentucky | 21051 | 423 | 6 |
639157 | 639157 | 2020-10-17 | Clinton | Kentucky | 21053 | 196 | 4 |
639158 | 639158 | 2020-10-17 | Crittenden | Kentucky | 21055 | 146 | 1 |
639159 | 639159 | 2020-10-17 | Cumberland | Kentucky | 21057 | 125 | 0 |
639160 | 639160 | 2020-10-17 | Daviess | Kentucky | 21059 | 1781 | 25 |
639161 | 639161 | 2020-10-17 | Edmonson | Kentucky | 21061 | 175 | 12 |
639162 | 639162 | 2020-10-17 | Elliott | Kentucky | 21063 | 62 | 0 |
639163 | 639163 | 2020-10-17 | Estill | Kentucky | 21065 | 243 | 0 |
639164 | 639164 | 2020-10-17 | Fayette | Kentucky | 21067 | 9818 | 87 |
639165 | 639165 | 2020-10-17 | Fleming | Kentucky | 21069 | 117 | 0 |
639166 | 639166 | 2020-10-17 | Floyd | Kentucky | 21071 | 267 | 4 |
639167 | 639167 | 2020-10-17 | Franklin | Kentucky | 21073 | 787 | 13 |
639168 | 639168 | 2020-10-17 | Fulton | Kentucky | 21075 | 214 | 3 |
639169 | 639169 | 2020-10-17 | Gallatin | Kentucky | 21077 | 113 | 8 |
639170 | 639170 | 2020-10-17 | Garrard | Kentucky | 21079 | 239 | 3 |
639171 | 639171 | 2020-10-17 | Grant | Kentucky | 21081 | 214 | 6 |
639172 | 639172 | 2020-10-17 | Graves | Kentucky | 21083 | 840 | 29 |
639173 | 639173 | 2020-10-17 | Grayson | Kentucky | 21085 | 450 | 15 |
639174 | 639174 | 2020-10-17 | Green | Kentucky | 21087 | 320 | 9 |
639175 | 639175 | 2020-10-17 | Greenup | Kentucky | 21089 | 553 | 7 |
639176 | 639176 | 2020-10-17 | Hancock | Kentucky | 21091 | 114 | 1 |
639177 | 639177 | 2020-10-17 | Hardin | Kentucky | 21093 | 1683 | 16 |
639178 | 639178 | 2020-10-17 | Harlan | Kentucky | 21095 | 558 | 13 |
639179 | 639179 | 2020-10-17 | Harrison | Kentucky | 21097 | 239 | 1 |
639180 | 639180 | 2020-10-17 | Hart | Kentucky | 21099 | 267 | 1 |
639181 | 639181 | 2020-10-17 | Henderson | Kentucky | 21101 | 1187 | 22 |
639182 | 639182 | 2020-10-17 | Henry | Kentucky | 21103 | 229 | 2 |
639183 | 639183 | 2020-10-17 | Hickman | Kentucky | 21105 | 97 | 1 |
639184 | 639184 | 2020-10-17 | Hopkins | Kentucky | 21107 | 908 | 42 |
639185 | 639185 | 2020-10-17 | Jackson | Kentucky | 21109 | 418 | 17 |
639186 | 639186 | 2020-10-17 | Jefferson | Kentucky | 21111 | 20851 | 350 |
639187 | 639187 | 2020-10-17 | Jessamine | Kentucky | 21113 | 827 | 2 |
639188 | 639188 | 2020-10-17 | Johnson | Kentucky | 21115 | 233 | 2 |
639189 | 639189 | 2020-10-17 | Kenton | Kentucky | 21117 | 2350 | 49 |
639190 | 639190 | 2020-10-17 | Knott | Kentucky | 21119 | 291 | 2 |
639191 | 639191 | 2020-10-17 | Knox | Kentucky | 21121 | 721 | 9 |
639192 | 639192 | 2020-10-17 | Larue | Kentucky | 21123 | 254 | 1 |
639193 | 639193 | 2020-10-17 | Laurel | Kentucky | 21125 | 1223 | 7 |
639194 | 639194 | 2020-10-17 | Lawrence | Kentucky | 21127 | 116 | 0 |
639195 | 639195 | 2020-10-17 | Lee | Kentucky | 21129 | 35 | 0 |
639196 | 639196 | 2020-10-17 | Leslie | Kentucky | 21131 | 114 | 0 |
639197 | 639197 | 2020-10-17 | Letcher | Kentucky | 21133 | 276 | 2 |
639198 | 639198 | 2020-10-17 | Lewis | Kentucky | 21135 | 260 | 15 |
639199 | 639199 | 2020-10-17 | Lincoln | Kentucky | 21137 | 273 | 16 |
639200 | 639200 | 2020-10-17 | Livingston | Kentucky | 21139 | 117 | 1 |
639201 | 639201 | 2020-10-17 | Logan | Kentucky | 21141 | 692 | 30 |
639202 | 639202 | 2020-10-17 | Lyon | Kentucky | 21143 | 93 | 4 |
639203 | 639203 | 2020-10-17 | Madison | Kentucky | 21151 | 2145 | 11 |
639204 | 639204 | 2020-10-17 | Magoffin | Kentucky | 21153 | 128 | 0 |
639205 | 639205 | 2020-10-17 | Marion | Kentucky | 21155 | 331 | 10 |
639206 | 639206 | 2020-10-17 | Marshall | Kentucky | 21157 | 411 | 4 |
639207 | 639207 | 2020-10-17 | Martin | Kentucky | 21159 | 121 | 3 |
639208 | 639208 | 2020-10-17 | Mason | Kentucky | 21161 | 149 | 2 |
639209 | 639209 | 2020-10-17 | McCracken | Kentucky | 21145 | 954 | 11 |
639210 | 639210 | 2020-10-17 | McCreary | Kentucky | 21147 | 243 | 1 |
639211 | 639211 | 2020-10-17 | McLean | Kentucky | 21149 | 125 | 2 |
639212 | 639212 | 2020-10-17 | Meade | Kentucky | 21163 | 353 | 3 |
639213 | 639213 | 2020-10-17 | Menifee | Kentucky | 21165 | 76 | 1 |
639214 | 639214 | 2020-10-17 | Mercer | Kentucky | 21167 | 313 | 5 |
639215 | 639215 | 2020-10-17 | Metcalfe | Kentucky | 21169 | 169 | 2 |
639216 | 639216 | 2020-10-17 | Monroe | Kentucky | 21171 | 247 | 4 |
639217 | 639217 | 2020-10-17 | Montgomery | Kentucky | 21173 | 371 | 4 |
639218 | 639218 | 2020-10-17 | Morgan | Kentucky | 21175 | 100 | 0 |
639219 | 639219 | 2020-10-17 | Muhlenberg | Kentucky | 21177 | 937 | 13 |
639220 | 639220 | 2020-10-17 | Nelson | Kentucky | 21179 | 674 | 4 |
639221 | 639221 | 2020-10-17 | Nicholas | Kentucky | 21181 | 89 | 1 |
639222 | 639222 | 2020-10-17 | Ohio | Kentucky | 21183 | 563 | 9 |
639223 | 639223 | 2020-10-17 | Oldham | Kentucky | 21185 | 1329 | 26 |
639224 | 639224 | 2020-10-17 | Owen | Kentucky | 21187 | 112 | 2 |
639225 | 639225 | 2020-10-17 | Owsley | Kentucky | 21189 | 67 | 1 |
639226 | 639226 | 2020-10-17 | Pendleton | Kentucky | 21191 | 109 | 0 |
639227 | 639227 | 2020-10-17 | Perry | Kentucky | 21193 | 429 | 9 |
639228 | 639228 | 2020-10-17 | Pike | Kentucky | 21195 | 679 | 3 |
639229 | 639229 | 2020-10-17 | Powell | Kentucky | 21197 | 132 | 0 |
639230 | 639230 | 2020-10-17 | Pulaski | Kentucky | 21199 | 957 | 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);