ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where "date" is on date 2020-04-11 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Adair 1
- Allen 1
- Anderson 1
- Ballard 1
- Barren 1
- Bath 1
- Boone 1
- Bourbon 1
- Boyd 1
- Boyle 1
- Bracken 1
- Breathitt 1
- Breckinridge 1
- Bullitt 1
- Butler 1
- Caldwell 1
- Calloway 1
- Campbell 1
- Carroll 1
- Carter 1
- Christian 1
- Clark 1
- Clinton 1
- Crittenden 1
- Cumberland 1
- Daviess 1
- Edmonson 1
- Fayette 1
- Fleming 1
- Floyd 1
- …
state 1
- Kentucky · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
49297 | 49297 | 2020-04-11 | Adair | Kentucky | 21001 | 11 | 1 |
49298 | 49298 | 2020-04-11 | Allen | Kentucky | 21003 | 4 | 0 |
49299 | 49299 | 2020-04-11 | Anderson | Kentucky | 21005 | 3 | 1 |
49300 | 49300 | 2020-04-11 | Ballard | Kentucky | 21007 | 1 | 0 |
49301 | 49301 | 2020-04-11 | Barren | Kentucky | 21009 | 5 | 0 |
49302 | 49302 | 2020-04-11 | Bath | Kentucky | 21011 | 2 | 0 |
49303 | 49303 | 2020-04-11 | Boone | Kentucky | 21015 | 48 | 2 |
49304 | 49304 | 2020-04-11 | Bourbon | Kentucky | 21017 | 4 | 1 |
49305 | 49305 | 2020-04-11 | Boyd | Kentucky | 21019 | 26 | 2 |
49306 | 49306 | 2020-04-11 | Boyle | Kentucky | 21021 | 13 | 0 |
49307 | 49307 | 2020-04-11 | Bracken | Kentucky | 21023 | 6 | 0 |
49308 | 49308 | 2020-04-11 | Breathitt | Kentucky | 21025 | 2 | 0 |
49309 | 49309 | 2020-04-11 | Breckinridge | Kentucky | 21027 | 3 | 0 |
49310 | 49310 | 2020-04-11 | Bullitt | Kentucky | 21029 | 27 | 2 |
49311 | 49311 | 2020-04-11 | Butler | Kentucky | 21031 | 11 | 1 |
49312 | 49312 | 2020-04-11 | Caldwell | Kentucky | 21033 | 10 | 0 |
49313 | 49313 | 2020-04-11 | Calloway | Kentucky | 21035 | 14 | 1 |
49314 | 49314 | 2020-04-11 | Campbell | Kentucky | 21037 | 47 | 3 |
49315 | 49315 | 2020-04-11 | Carroll | Kentucky | 21041 | 2 | 0 |
49316 | 49316 | 2020-04-11 | Carter | Kentucky | 21043 | 1 | 0 |
49317 | 49317 | 2020-04-11 | Christian | Kentucky | 21047 | 62 | 3 |
49318 | 49318 | 2020-04-11 | Clark | Kentucky | 21049 | 17 | 0 |
49319 | 49319 | 2020-04-11 | Clinton | Kentucky | 21053 | 3 | 0 |
49320 | 49320 | 2020-04-11 | Crittenden | Kentucky | 21055 | 3 | 0 |
49321 | 49321 | 2020-04-11 | Cumberland | Kentucky | 21057 | 3 | 0 |
49322 | 49322 | 2020-04-11 | Daviess | Kentucky | 21059 | 81 | 3 |
49323 | 49323 | 2020-04-11 | Edmonson | Kentucky | 21061 | 6 | 0 |
49324 | 49324 | 2020-04-11 | Fayette | Kentucky | 21067 | 179 | 7 |
49325 | 49325 | 2020-04-11 | Fleming | Kentucky | 21069 | 1 | 0 |
49326 | 49326 | 2020-04-11 | Floyd | Kentucky | 21071 | 1 | 0 |
49327 | 49327 | 2020-04-11 | Franklin | Kentucky | 21073 | 10 | 0 |
49328 | 49328 | 2020-04-11 | Gallatin | Kentucky | 21077 | 1 | 0 |
49329 | 49329 | 2020-04-11 | Grant | Kentucky | 21081 | 13 | 1 |
49330 | 49330 | 2020-04-11 | Graves | Kentucky | 21083 | 9 | 0 |
49331 | 49331 | 2020-04-11 | Grayson | Kentucky | 21085 | 4 | 0 |
49332 | 49332 | 2020-04-11 | Green | Kentucky | 21087 | 2 | 0 |
49333 | 49333 | 2020-04-11 | Greenup | Kentucky | 21089 | 5 | 0 |
49334 | 49334 | 2020-04-11 | Hancock | Kentucky | 21091 | 2 | 0 |
49335 | 49335 | 2020-04-11 | Hardin | Kentucky | 21093 | 21 | 0 |
49336 | 49336 | 2020-04-11 | Harrison | Kentucky | 21097 | 14 | 0 |
49337 | 49337 | 2020-04-11 | Hart | Kentucky | 21099 | 1 | 0 |
49338 | 49338 | 2020-04-11 | Henderson | Kentucky | 21101 | 29 | 0 |
49339 | 49339 | 2020-04-11 | Henry | Kentucky | 21103 | 4 | 0 |
49340 | 49340 | 2020-04-11 | Hopkins | Kentucky | 21107 | 88 | 8 |
49341 | 49341 | 2020-04-11 | Jackson | Kentucky | 21109 | 5 | 0 |
49342 | 49342 | 2020-04-11 | Jefferson | Kentucky | 21111 | 495 | 40 |
49343 | 49343 | 2020-04-11 | Jessamine | Kentucky | 21113 | 26 | 0 |
49344 | 49344 | 2020-04-11 | Johnson | Kentucky | 21115 | 1 | 0 |
49345 | 49345 | 2020-04-11 | Kenton | Kentucky | 21117 | 91 | 8 |
49346 | 49346 | 2020-04-11 | Knott | Kentucky | 21119 | 1 | 0 |
49347 | 49347 | 2020-04-11 | Knox | Kentucky | 21121 | 1 | 0 |
49348 | 49348 | 2020-04-11 | Larue | Kentucky | 21123 | 3 | 0 |
49349 | 49349 | 2020-04-11 | Laurel | Kentucky | 21125 | 9 | 0 |
49350 | 49350 | 2020-04-11 | Lawrence | Kentucky | 21127 | 1 | 0 |
49351 | 49351 | 2020-04-11 | Leslie | Kentucky | 21131 | 1 | 0 |
49352 | 49352 | 2020-04-11 | Letcher | Kentucky | 21133 | 1 | 0 |
49353 | 49353 | 2020-04-11 | Lewis | Kentucky | 21135 | 2 | 0 |
49354 | 49354 | 2020-04-11 | Lincoln | Kentucky | 21137 | 1 | 0 |
49355 | 49355 | 2020-04-11 | Logan | Kentucky | 21141 | 5 | 0 |
49356 | 49356 | 2020-04-11 | Lyon | Kentucky | 21143 | 12 | 2 |
49357 | 49357 | 2020-04-11 | Madison | Kentucky | 21151 | 18 | 1 |
49358 | 49358 | 2020-04-11 | Marion | Kentucky | 21155 | 11 | 0 |
49359 | 49359 | 2020-04-11 | Marshall | Kentucky | 21157 | 11 | 0 |
49360 | 49360 | 2020-04-11 | Martin | Kentucky | 21159 | 4 | 0 |
49361 | 49361 | 2020-04-11 | Mason | Kentucky | 21161 | 5 | 0 |
49362 | 49362 | 2020-04-11 | McCracken | Kentucky | 21145 | 21 | 2 |
49363 | 49363 | 2020-04-11 | McCreary | Kentucky | 21147 | 8 | 0 |
49364 | 49364 | 2020-04-11 | McLean | Kentucky | 21149 | 6 | 0 |
49365 | 49365 | 2020-04-11 | Meade | Kentucky | 21163 | 2 | 1 |
49366 | 49366 | 2020-04-11 | Menifee | Kentucky | 21165 | 3 | 0 |
49367 | 49367 | 2020-04-11 | Mercer | Kentucky | 21167 | 9 | 0 |
49368 | 49368 | 2020-04-11 | Monroe | Kentucky | 21171 | 2 | 0 |
49369 | 49369 | 2020-04-11 | Montgomery | Kentucky | 21173 | 8 | 0 |
49370 | 49370 | 2020-04-11 | Muhlenberg | Kentucky | 21177 | 28 | 0 |
49371 | 49371 | 2020-04-11 | Nelson | Kentucky | 21179 | 10 | 0 |
49372 | 49372 | 2020-04-11 | Nicholas | Kentucky | 21181 | 1 | 0 |
49373 | 49373 | 2020-04-11 | Ohio | Kentucky | 21183 | 8 | 0 |
49374 | 49374 | 2020-04-11 | Oldham | Kentucky | 21185 | 16 | 0 |
49375 | 49375 | 2020-04-11 | Pendleton | Kentucky | 21191 | 3 | 0 |
49376 | 49376 | 2020-04-11 | Perry | Kentucky | 21193 | 3 | 0 |
49377 | 49377 | 2020-04-11 | Pike | Kentucky | 21195 | 4 | 0 |
49378 | 49378 | 2020-04-11 | Powell | Kentucky | 21197 | 2 | 0 |
49379 | 49379 | 2020-04-11 | Pulaski | Kentucky | 21199 | 33 | 2 |
49380 | 49380 | 2020-04-11 | Rockcastle | Kentucky | 21203 | 8 | 0 |
49381 | 49381 | 2020-04-11 | Rowan | Kentucky | 21205 | 1 | 0 |
49382 | 49382 | 2020-04-11 | Russell | Kentucky | 21207 | 8 | 0 |
49383 | 49383 | 2020-04-11 | Scott | Kentucky | 21209 | 22 | 0 |
49384 | 49384 | 2020-04-11 | Shelby | Kentucky | 21211 | 18 | 1 |
49385 | 49385 | 2020-04-11 | Simpson | Kentucky | 21213 | 17 | 1 |
49386 | 49386 | 2020-04-11 | Spencer | Kentucky | 21215 | 6 | 0 |
49387 | 49387 | 2020-04-11 | Taylor | Kentucky | 21217 | 3 | 0 |
49388 | 49388 | 2020-04-11 | Todd | Kentucky | 21219 | 6 | 0 |
49389 | 49389 | 2020-04-11 | Trimble | Kentucky | 21223 | 2 | 0 |
49390 | 49390 | 2020-04-11 | Union | Kentucky | 21225 | 5 | 0 |
49391 | 49391 | 2020-04-11 | Warren | Kentucky | 21227 | 49 | 0 |
49392 | 49392 | 2020-04-11 | Washington | Kentucky | 21229 | 3 | 0 |
49393 | 49393 | 2020-04-11 | Wayne | Kentucky | 21231 | 4 | 0 |
49394 | 49394 | 2020-04-11 | Webster | Kentucky | 21233 | 8 | 0 |
49395 | 49395 | 2020-04-11 | Whitley | Kentucky | 21235 | 4 | 0 |
49396 | 49396 | 2020-04-11 | Woodford | Kentucky | 21239 | 17 | 0 |
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);