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-07-01 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 |
---|---|---|---|---|---|---|---|
291207 | 291207 | 2020-07-01 | Adair | Kentucky | 21001 | 126 | 19 |
291208 | 291208 | 2020-07-01 | Allen | Kentucky | 21003 | 170 | 7 |
291209 | 291209 | 2020-07-01 | Anderson | Kentucky | 21005 | 26 | 1 |
291210 | 291210 | 2020-07-01 | Ballard | Kentucky | 21007 | 15 | 0 |
291211 | 291211 | 2020-07-01 | Barren | Kentucky | 21009 | 86 | 2 |
291212 | 291212 | 2020-07-01 | Bath | Kentucky | 21011 | 15 | 1 |
291213 | 291213 | 2020-07-01 | Bell | Kentucky | 21013 | 8 | 0 |
291214 | 291214 | 2020-07-01 | Boone | Kentucky | 21015 | 602 | 23 |
291215 | 291215 | 2020-07-01 | Bourbon | Kentucky | 21017 | 32 | 1 |
291216 | 291216 | 2020-07-01 | Boyd | Kentucky | 21019 | 62 | 3 |
291217 | 291217 | 2020-07-01 | Boyle | Kentucky | 21021 | 39 | 0 |
291218 | 291218 | 2020-07-01 | Bracken | Kentucky | 21023 | 17 | 0 |
291219 | 291219 | 2020-07-01 | Breathitt | Kentucky | 21025 | 8 | 0 |
291220 | 291220 | 2020-07-01 | Breckinridge | Kentucky | 21027 | 24 | 2 |
291221 | 291221 | 2020-07-01 | Bullitt | Kentucky | 21029 | 151 | 4 |
291222 | 291222 | 2020-07-01 | Butler | Kentucky | 21031 | 257 | 14 |
291223 | 291223 | 2020-07-01 | Caldwell | Kentucky | 21033 | 15 | 0 |
291224 | 291224 | 2020-07-01 | Calloway | Kentucky | 21035 | 82 | 1 |
291225 | 291225 | 2020-07-01 | Campbell | Kentucky | 21037 | 266 | 13 |
291226 | 291226 | 2020-07-01 | Carlisle | Kentucky | 21039 | 5 | 1 |
291227 | 291227 | 2020-07-01 | Carroll | Kentucky | 21041 | 37 | 0 |
291228 | 291228 | 2020-07-01 | Carter | Kentucky | 21043 | 25 | 0 |
291229 | 291229 | 2020-07-01 | Casey | Kentucky | 21045 | 19 | 0 |
291230 | 291230 | 2020-07-01 | Christian | Kentucky | 21047 | 249 | 4 |
291231 | 291231 | 2020-07-01 | Clark | Kentucky | 21049 | 98 | 5 |
291232 | 291232 | 2020-07-01 | Clay | Kentucky | 21051 | 62 | 3 |
291233 | 291233 | 2020-07-01 | Clinton | Kentucky | 21053 | 5 | 0 |
291234 | 291234 | 2020-07-01 | Crittenden | Kentucky | 21055 | 9 | 1 |
291235 | 291235 | 2020-07-01 | Cumberland | Kentucky | 21057 | 6 | 0 |
291236 | 291236 | 2020-07-01 | Daviess | Kentucky | 21059 | 435 | 8 |
291237 | 291237 | 2020-07-01 | Edmonson | Kentucky | 21061 | 83 | 11 |
291238 | 291238 | 2020-07-01 | Elliott | Kentucky | 21063 | 3 | 0 |
291239 | 291239 | 2020-07-01 | Estill | Kentucky | 21065 | 4 | 0 |
291240 | 291240 | 2020-07-01 | Fayette | Kentucky | 21067 | 1553 | 29 |
291241 | 291241 | 2020-07-01 | Fleming | Kentucky | 21069 | 21 | 0 |
291242 | 291242 | 2020-07-01 | Floyd | Kentucky | 21071 | 29 | 0 |
291243 | 291243 | 2020-07-01 | Franklin | Kentucky | 21073 | 138 | 4 |
291244 | 291244 | 2020-07-01 | Fulton | Kentucky | 21075 | 23 | 0 |
291245 | 291245 | 2020-07-01 | Gallatin | Kentucky | 21077 | 65 | 7 |
291246 | 291246 | 2020-07-01 | Garrard | Kentucky | 21079 | 24 | 0 |
291247 | 291247 | 2020-07-01 | Grant | Kentucky | 21081 | 59 | 4 |
291248 | 291248 | 2020-07-01 | Graves | Kentucky | 21083 | 207 | 21 |
291249 | 291249 | 2020-07-01 | Grayson | Kentucky | 21085 | 138 | 10 |
291250 | 291250 | 2020-07-01 | Green | Kentucky | 21087 | 5 | 1 |
291251 | 291251 | 2020-07-01 | Greenup | Kentucky | 21089 | 28 | 0 |
291252 | 291252 | 2020-07-01 | Hancock | Kentucky | 21091 | 18 | 0 |
291253 | 291253 | 2020-07-01 | Hardin | Kentucky | 21093 | 165 | 6 |
291254 | 291254 | 2020-07-01 | Harlan | Kentucky | 21095 | 24 | 2 |
291255 | 291255 | 2020-07-01 | Harrison | Kentucky | 21097 | 73 | 0 |
291256 | 291256 | 2020-07-01 | Hart | Kentucky | 21099 | 48 | 0 |
291257 | 291257 | 2020-07-01 | Henderson | Kentucky | 21101 | 165 | 4 |
291258 | 291258 | 2020-07-01 | Henry | Kentucky | 21103 | 35 | 2 |
291259 | 291259 | 2020-07-01 | Hickman | Kentucky | 21105 | 5 | 0 |
291260 | 291260 | 2020-07-01 | Hopkins | Kentucky | 21107 | 256 | 34 |
291261 | 291261 | 2020-07-01 | Jackson | Kentucky | 21109 | 109 | 14 |
291262 | 291262 | 2020-07-01 | Jefferson | Kentucky | 21111 | 3942 | 209 |
291263 | 291263 | 2020-07-01 | Jessamine | Kentucky | 21113 | 108 | 0 |
291264 | 291264 | 2020-07-01 | Johnson | Kentucky | 21115 | 9 | 0 |
291265 | 291265 | 2020-07-01 | Kenton | Kentucky | 21117 | 800 | 37 |
291266 | 291266 | 2020-07-01 | Knott | Kentucky | 21119 | 8 | 0 |
291267 | 291267 | 2020-07-01 | Knox | Kentucky | 21121 | 69 | 0 |
291268 | 291268 | 2020-07-01 | Larue | Kentucky | 21123 | 17 | 1 |
291269 | 291269 | 2020-07-01 | Laurel | Kentucky | 21125 | 111 | 3 |
291270 | 291270 | 2020-07-01 | Lawrence | Kentucky | 21127 | 8 | 0 |
291271 | 291271 | 2020-07-01 | Lee | Kentucky | 21129 | 1 | 0 |
291272 | 291272 | 2020-07-01 | Leslie | Kentucky | 21131 | 8 | 0 |
291273 | 291273 | 2020-07-01 | Letcher | Kentucky | 21133 | 14 | 0 |
291274 | 291274 | 2020-07-01 | Lewis | Kentucky | 21135 | 22 | 0 |
291275 | 291275 | 2020-07-01 | Lincoln | Kentucky | 21137 | 28 | 1 |
291276 | 291276 | 2020-07-01 | Livingston | Kentucky | 21139 | 10 | 0 |
291277 | 291277 | 2020-07-01 | Logan | Kentucky | 21141 | 223 | 15 |
291278 | 291278 | 2020-07-01 | Lyon | Kentucky | 21143 | 20 | 3 |
291279 | 291279 | 2020-07-01 | Madison | Kentucky | 21151 | 125 | 1 |
291280 | 291280 | 2020-07-01 | Magoffin | Kentucky | 21153 | 5 | 0 |
291281 | 291281 | 2020-07-01 | Marion | Kentucky | 21155 | 52 | 0 |
291282 | 291282 | 2020-07-01 | Marshall | Kentucky | 21157 | 59 | 2 |
291283 | 291283 | 2020-07-01 | Martin | Kentucky | 21159 | 7 | 0 |
291284 | 291284 | 2020-07-01 | Mason | Kentucky | 21161 | 31 | 0 |
291285 | 291285 | 2020-07-01 | McCracken | Kentucky | 21145 | 168 | 3 |
291286 | 291286 | 2020-07-01 | McCreary | Kentucky | 21147 | 18 | 0 |
291287 | 291287 | 2020-07-01 | McLean | Kentucky | 21149 | 25 | 0 |
291288 | 291288 | 2020-07-01 | Meade | Kentucky | 21163 | 26 | 2 |
291289 | 291289 | 2020-07-01 | Menifee | Kentucky | 21165 | 13 | 0 |
291290 | 291290 | 2020-07-01 | Mercer | Kentucky | 21167 | 23 | 0 |
291291 | 291291 | 2020-07-01 | Metcalfe | Kentucky | 21169 | 10 | 2 |
291292 | 291292 | 2020-07-01 | Monroe | Kentucky | 21171 | 36 | 1 |
291293 | 291293 | 2020-07-01 | Montgomery | Kentucky | 21173 | 58 | 0 |
291294 | 291294 | 2020-07-01 | Morgan | Kentucky | 21175 | 8 | 0 |
291295 | 291295 | 2020-07-01 | Muhlenberg | Kentucky | 21177 | 523 | 8 |
291296 | 291296 | 2020-07-01 | Nelson | Kentucky | 21179 | 76 | 1 |
291297 | 291297 | 2020-07-01 | Nicholas | Kentucky | 21181 | 5 | 0 |
291298 | 291298 | 2020-07-01 | Ohio | Kentucky | 21183 | 205 | 0 |
291299 | 291299 | 2020-07-01 | Oldham | Kentucky | 21185 | 130 | 7 |
291300 | 291300 | 2020-07-01 | Owen | Kentucky | 21187 | 6 | 0 |
291301 | 291301 | 2020-07-01 | Owsley | Kentucky | 21189 | 2 | 0 |
291302 | 291302 | 2020-07-01 | Pendleton | Kentucky | 21191 | 17 | 0 |
291303 | 291303 | 2020-07-01 | Perry | Kentucky | 21193 | 59 | 1 |
291304 | 291304 | 2020-07-01 | Pike | Kentucky | 21195 | 86 | 2 |
291305 | 291305 | 2020-07-01 | Powell | Kentucky | 21197 | 7 | 0 |
291306 | 291306 | 2020-07-01 | Pulaski | Kentucky | 21199 | 94 | 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);