ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where "date" is on date 2020-03-29 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Allen 1
- Anderson 1
- Boone 1
- Bourbon 1
- Boyd 1
- Boyle 1
- Bracken 1
- Breathitt 1
- Breckinridge 1
- Bullitt 1
- Butler 1
- Calloway 1
- Campbell 1
- Carroll 1
- Christian 1
- Clark 1
- Daviess 1
- Fayette 1
- Floyd 1
- Franklin 1
- Grant 1
- Grayson 1
- Hardin 1
- Harrison 1
- Henderson 1
- Hopkins 1
- Jefferson 1
- Jessamine 1
- Kenton 1
- Larue 1
- …
state 1
- Kentucky · 59 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
18327 | 18327 | 2020-03-29 | Allen | Kentucky | 21003 | 1 | 0 |
18328 | 18328 | 2020-03-29 | Anderson | Kentucky | 21005 | 2 | 1 |
18329 | 18329 | 2020-03-29 | Boone | Kentucky | 21015 | 4 | 0 |
18330 | 18330 | 2020-03-29 | Bourbon | Kentucky | 21017 | 2 | 1 |
18331 | 18331 | 2020-03-29 | Boyd | Kentucky | 21019 | 4 | 0 |
18332 | 18332 | 2020-03-29 | Boyle | Kentucky | 21021 | 1 | 0 |
18333 | 18333 | 2020-03-29 | Bracken | Kentucky | 21023 | 1 | 0 |
18334 | 18334 | 2020-03-29 | Breathitt | Kentucky | 21025 | 2 | 0 |
18335 | 18335 | 2020-03-29 | Breckinridge | Kentucky | 21027 | 2 | 0 |
18336 | 18336 | 2020-03-29 | Bullitt | Kentucky | 21029 | 2 | 0 |
18337 | 18337 | 2020-03-29 | Butler | Kentucky | 21031 | 1 | 0 |
18338 | 18338 | 2020-03-29 | Calloway | Kentucky | 21035 | 3 | 0 |
18339 | 18339 | 2020-03-29 | Campbell | Kentucky | 21037 | 4 | 0 |
18340 | 18340 | 2020-03-29 | Carroll | Kentucky | 21041 | 1 | 0 |
18341 | 18341 | 2020-03-29 | Christian | Kentucky | 21047 | 6 | 0 |
18342 | 18342 | 2020-03-29 | Clark | Kentucky | 21049 | 6 | 0 |
18343 | 18343 | 2020-03-29 | Daviess | Kentucky | 21059 | 20 | 0 |
18344 | 18344 | 2020-03-29 | Fayette | Kentucky | 21067 | 75 | 1 |
18345 | 18345 | 2020-03-29 | Floyd | Kentucky | 21071 | 1 | 0 |
18346 | 18346 | 2020-03-29 | Franklin | Kentucky | 21073 | 3 | 0 |
18347 | 18347 | 2020-03-29 | Grant | Kentucky | 21081 | 1 | 0 |
18348 | 18348 | 2020-03-29 | Grayson | Kentucky | 21085 | 2 | 0 |
18349 | 18349 | 2020-03-29 | Hardin | Kentucky | 21093 | 5 | 0 |
18350 | 18350 | 2020-03-29 | Harrison | Kentucky | 21097 | 11 | 0 |
18351 | 18351 | 2020-03-29 | Henderson | Kentucky | 21101 | 5 | 0 |
18352 | 18352 | 2020-03-29 | Hopkins | Kentucky | 21107 | 7 | 1 |
18353 | 18353 | 2020-03-29 | Jefferson | Kentucky | 21111 | 108 | 4 |
18354 | 18354 | 2020-03-29 | Jessamine | Kentucky | 21113 | 10 | 0 |
18355 | 18355 | 2020-03-29 | Kenton | Kentucky | 21117 | 19 | 1 |
18356 | 18356 | 2020-03-29 | Larue | Kentucky | 21123 | 1 | 0 |
18357 | 18357 | 2020-03-29 | Laurel | Kentucky | 21125 | 1 | 0 |
18358 | 18358 | 2020-03-29 | Lewis | Kentucky | 21135 | 1 | 0 |
18359 | 18359 | 2020-03-29 | Logan | Kentucky | 21141 | 2 | 0 |
18360 | 18360 | 2020-03-29 | Lyon | Kentucky | 21143 | 1 | 0 |
18361 | 18361 | 2020-03-29 | Madison | Kentucky | 21151 | 7 | 0 |
18362 | 18362 | 2020-03-29 | Martin | Kentucky | 21159 | 1 | 0 |
18363 | 18363 | 2020-03-29 | Mason | Kentucky | 21161 | 1 | 0 |
18364 | 18364 | 2020-03-29 | McCracken | Kentucky | 21145 | 5 | 0 |
18365 | 18365 | 2020-03-29 | McCreary | Kentucky | 21147 | 1 | 0 |
18366 | 18366 | 2020-03-29 | Menifee | Kentucky | 21165 | 2 | 0 |
18367 | 18367 | 2020-03-29 | Mercer | Kentucky | 21167 | 2 | 0 |
18368 | 18368 | 2020-03-29 | Montgomery | Kentucky | 21173 | 2 | 0 |
18369 | 18369 | 2020-03-29 | Muhlenberg | Kentucky | 21177 | 2 | 0 |
18370 | 18370 | 2020-03-29 | Nelson | Kentucky | 21179 | 3 | 0 |
18371 | 18371 | 2020-03-29 | Nicholas | Kentucky | 21181 | 1 | 0 |
18372 | 18372 | 2020-03-29 | Oldham | Kentucky | 21185 | 3 | 0 |
18373 | 18373 | 2020-03-29 | Pulaski | Kentucky | 21199 | 7 | 0 |
18374 | 18374 | 2020-03-29 | Scott | Kentucky | 21209 | 6 | 0 |
18375 | 18375 | 2020-03-29 | Shelby | Kentucky | 21211 | 1 | 0 |
18376 | 18376 | 2020-03-29 | Simpson | Kentucky | 21213 | 2 | 0 |
18377 | 18377 | 2020-03-29 | Spencer | Kentucky | 21215 | 1 | 0 |
18378 | 18378 | 2020-03-29 | Taylor | Kentucky | 21217 | 2 | 0 |
18379 | 18379 | 2020-03-29 | Union | Kentucky | 21225 | 1 | 0 |
18380 | 18380 | 2020-03-29 | Unknown | Kentucky | 57 | 0 | |
18381 | 18381 | 2020-03-29 | Warren | Kentucky | 21227 | 10 | 0 |
18382 | 18382 | 2020-03-29 | Washington | Kentucky | 21229 | 2 | 0 |
18383 | 18383 | 2020-03-29 | Wayne | Kentucky | 21231 | 1 | 0 |
18384 | 18384 | 2020-03-29 | Webster | Kentucky | 21233 | 1 | 0 |
18385 | 18385 | 2020-03-29 | Woodford | Kentucky | 21239 | 3 | 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);