ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where "date" is on date 2020-03-28 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
- 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
- Laurel 1
- …
state 1
- Kentucky · 56 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
16418 | 16418 | 2020-03-28 | Allen | Kentucky | 21003 | 1 | 0 |
16419 | 16419 | 2020-03-28 | Anderson | Kentucky | 21005 | 2 | 1 |
16420 | 16420 | 2020-03-28 | Boone | Kentucky | 21015 | 4 | 0 |
16421 | 16421 | 2020-03-28 | Bourbon | Kentucky | 21017 | 2 | 1 |
16422 | 16422 | 2020-03-28 | Boyle | Kentucky | 21021 | 1 | 0 |
16423 | 16423 | 2020-03-28 | Bracken | Kentucky | 21023 | 1 | 0 |
16424 | 16424 | 2020-03-28 | Breathitt | Kentucky | 21025 | 2 | 0 |
16425 | 16425 | 2020-03-28 | Breckinridge | Kentucky | 21027 | 2 | 0 |
16426 | 16426 | 2020-03-28 | Bullitt | Kentucky | 21029 | 2 | 0 |
16427 | 16427 | 2020-03-28 | Butler | Kentucky | 21031 | 1 | 0 |
16428 | 16428 | 2020-03-28 | Calloway | Kentucky | 21035 | 2 | 0 |
16429 | 16429 | 2020-03-28 | Campbell | Kentucky | 21037 | 3 | 0 |
16430 | 16430 | 2020-03-28 | Carroll | Kentucky | 21041 | 1 | 0 |
16431 | 16431 | 2020-03-28 | Christian | Kentucky | 21047 | 6 | 0 |
16432 | 16432 | 2020-03-28 | Clark | Kentucky | 21049 | 6 | 0 |
16433 | 16433 | 2020-03-28 | Daviess | Kentucky | 21059 | 20 | 0 |
16434 | 16434 | 2020-03-28 | Fayette | Kentucky | 21067 | 60 | 1 |
16435 | 16435 | 2020-03-28 | Floyd | Kentucky | 21071 | 1 | 0 |
16436 | 16436 | 2020-03-28 | Franklin | Kentucky | 21073 | 2 | 0 |
16437 | 16437 | 2020-03-28 | Grant | Kentucky | 21081 | 1 | 0 |
16438 | 16438 | 2020-03-28 | Grayson | Kentucky | 21085 | 2 | 0 |
16439 | 16439 | 2020-03-28 | Hardin | Kentucky | 21093 | 5 | 0 |
16440 | 16440 | 2020-03-28 | Harrison | Kentucky | 21097 | 11 | 0 |
16441 | 16441 | 2020-03-28 | Henderson | Kentucky | 21101 | 5 | 0 |
16442 | 16442 | 2020-03-28 | Hopkins | Kentucky | 21107 | 2 | 1 |
16443 | 16443 | 2020-03-28 | Jefferson | Kentucky | 21111 | 99 | 4 |
16444 | 16444 | 2020-03-28 | Jessamine | Kentucky | 21113 | 10 | 0 |
16445 | 16445 | 2020-03-28 | Kenton | Kentucky | 21117 | 18 | 1 |
16446 | 16446 | 2020-03-28 | Larue | Kentucky | 21123 | 1 | 0 |
16447 | 16447 | 2020-03-28 | Laurel | Kentucky | 21125 | 1 | 0 |
16448 | 16448 | 2020-03-28 | Logan | Kentucky | 21141 | 2 | 0 |
16449 | 16449 | 2020-03-28 | Lyon | Kentucky | 21143 | 1 | 0 |
16450 | 16450 | 2020-03-28 | Madison | Kentucky | 21151 | 7 | 0 |
16451 | 16451 | 2020-03-28 | Martin | Kentucky | 21159 | 1 | 0 |
16452 | 16452 | 2020-03-28 | Mason | Kentucky | 21161 | 1 | 0 |
16453 | 16453 | 2020-03-28 | McCracken | Kentucky | 21145 | 3 | 0 |
16454 | 16454 | 2020-03-28 | McCreary | Kentucky | 21147 | 1 | 0 |
16455 | 16455 | 2020-03-28 | Menifee | Kentucky | 21165 | 2 | 0 |
16456 | 16456 | 2020-03-28 | Mercer | Kentucky | 21167 | 2 | 0 |
16457 | 16457 | 2020-03-28 | Montgomery | Kentucky | 21173 | 2 | 0 |
16458 | 16458 | 2020-03-28 | Muhlenberg | Kentucky | 21177 | 2 | 0 |
16459 | 16459 | 2020-03-28 | Nelson | Kentucky | 21179 | 2 | 0 |
16460 | 16460 | 2020-03-28 | Nicholas | Kentucky | 21181 | 1 | 0 |
16461 | 16461 | 2020-03-28 | Oldham | Kentucky | 21185 | 3 | 0 |
16462 | 16462 | 2020-03-28 | Pulaski | Kentucky | 21199 | 7 | 0 |
16463 | 16463 | 2020-03-28 | Scott | Kentucky | 21209 | 5 | 0 |
16464 | 16464 | 2020-03-28 | Shelby | Kentucky | 21211 | 1 | 0 |
16465 | 16465 | 2020-03-28 | Simpson | Kentucky | 21213 | 2 | 0 |
16466 | 16466 | 2020-03-28 | Spencer | Kentucky | 21215 | 1 | 0 |
16467 | 16467 | 2020-03-28 | Union | Kentucky | 21225 | 1 | 0 |
16468 | 16468 | 2020-03-28 | Unknown | Kentucky | 56 | 0 | |
16469 | 16469 | 2020-03-28 | Warren | Kentucky | 21227 | 10 | 0 |
16470 | 16470 | 2020-03-28 | Washington | Kentucky | 21229 | 2 | 0 |
16471 | 16471 | 2020-03-28 | Wayne | Kentucky | 21231 | 1 | 0 |
16472 | 16472 | 2020-03-28 | Webster | Kentucky | 21233 | 1 | 0 |
16473 | 16473 | 2020-03-28 | 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);