ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where date = "2020-03-30" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
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 · 61 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20341 | 20341 | 2020-03-30 | Allen | Kentucky | 21003 | 1 | 0 |
20342 | 20342 | 2020-03-30 | Anderson | Kentucky | 21005 | 2 | 1 |
20343 | 20343 | 2020-03-30 | Boone | Kentucky | 21015 | 5 | 0 |
20344 | 20344 | 2020-03-30 | Bourbon | Kentucky | 21017 | 2 | 1 |
20345 | 20345 | 2020-03-30 | Boyd | Kentucky | 21019 | 4 | 0 |
20346 | 20346 | 2020-03-30 | Boyle | Kentucky | 21021 | 1 | 0 |
20347 | 20347 | 2020-03-30 | Bracken | Kentucky | 21023 | 1 | 0 |
20348 | 20348 | 2020-03-30 | Breathitt | Kentucky | 21025 | 2 | 0 |
20349 | 20349 | 2020-03-30 | Breckinridge | Kentucky | 21027 | 2 | 0 |
20350 | 20350 | 2020-03-30 | Bullitt | Kentucky | 21029 | 5 | 0 |
20351 | 20351 | 2020-03-30 | Butler | Kentucky | 21031 | 1 | 0 |
20352 | 20352 | 2020-03-30 | Calloway | Kentucky | 21035 | 3 | 0 |
20353 | 20353 | 2020-03-30 | Campbell | Kentucky | 21037 | 5 | 0 |
20354 | 20354 | 2020-03-30 | Carroll | Kentucky | 21041 | 1 | 0 |
20355 | 20355 | 2020-03-30 | Christian | Kentucky | 21047 | 7 | 0 |
20356 | 20356 | 2020-03-30 | Clark | Kentucky | 21049 | 7 | 0 |
20357 | 20357 | 2020-03-30 | Daviess | Kentucky | 21059 | 20 | 0 |
20358 | 20358 | 2020-03-30 | Fayette | Kentucky | 21067 | 83 | 1 |
20359 | 20359 | 2020-03-30 | Floyd | Kentucky | 21071 | 1 | 0 |
20360 | 20360 | 2020-03-30 | Franklin | Kentucky | 21073 | 3 | 0 |
20361 | 20361 | 2020-03-30 | Grant | Kentucky | 21081 | 1 | 0 |
20362 | 20362 | 2020-03-30 | Grayson | Kentucky | 21085 | 2 | 0 |
20363 | 20363 | 2020-03-30 | Hardin | Kentucky | 21093 | 5 | 0 |
20364 | 20364 | 2020-03-30 | Harrison | Kentucky | 21097 | 11 | 0 |
20365 | 20365 | 2020-03-30 | Henderson | Kentucky | 21101 | 5 | 0 |
20366 | 20366 | 2020-03-30 | Hopkins | Kentucky | 21107 | 11 | 1 |
20367 | 20367 | 2020-03-30 | Jefferson | Kentucky | 21111 | 125 | 4 |
20368 | 20368 | 2020-03-30 | Jessamine | Kentucky | 21113 | 11 | 0 |
20369 | 20369 | 2020-03-30 | Kenton | Kentucky | 21117 | 20 | 2 |
20370 | 20370 | 2020-03-30 | Larue | Kentucky | 21123 | 1 | 0 |
20371 | 20371 | 2020-03-30 | Laurel | Kentucky | 21125 | 1 | 0 |
20372 | 20372 | 2020-03-30 | Lewis | Kentucky | 21135 | 1 | 0 |
20373 | 20373 | 2020-03-30 | Logan | Kentucky | 21141 | 2 | 0 |
20374 | 20374 | 2020-03-30 | Lyon | Kentucky | 21143 | 1 | 0 |
20375 | 20375 | 2020-03-30 | Madison | Kentucky | 21151 | 7 | 0 |
20376 | 20376 | 2020-03-30 | Marion | Kentucky | 21155 | 1 | 0 |
20377 | 20377 | 2020-03-30 | Marshall | Kentucky | 21157 | 1 | 0 |
20378 | 20378 | 2020-03-30 | Martin | Kentucky | 21159 | 1 | 0 |
20379 | 20379 | 2020-03-30 | Mason | Kentucky | 21161 | 1 | 0 |
20380 | 20380 | 2020-03-30 | McCracken | Kentucky | 21145 | 5 | 0 |
20381 | 20381 | 2020-03-30 | McCreary | Kentucky | 21147 | 1 | 0 |
20382 | 20382 | 2020-03-30 | Menifee | Kentucky | 21165 | 2 | 0 |
20383 | 20383 | 2020-03-30 | Mercer | Kentucky | 21167 | 2 | 0 |
20384 | 20384 | 2020-03-30 | Montgomery | Kentucky | 21173 | 2 | 0 |
20385 | 20385 | 2020-03-30 | Muhlenberg | Kentucky | 21177 | 2 | 0 |
20386 | 20386 | 2020-03-30 | Nelson | Kentucky | 21179 | 3 | 0 |
20387 | 20387 | 2020-03-30 | Nicholas | Kentucky | 21181 | 1 | 0 |
20388 | 20388 | 2020-03-30 | Oldham | Kentucky | 21185 | 3 | 0 |
20389 | 20389 | 2020-03-30 | Pulaski | Kentucky | 21199 | 7 | 0 |
20390 | 20390 | 2020-03-30 | Scott | Kentucky | 21209 | 6 | 0 |
20391 | 20391 | 2020-03-30 | Shelby | Kentucky | 21211 | 1 | 0 |
20392 | 20392 | 2020-03-30 | Simpson | Kentucky | 21213 | 2 | 1 |
20393 | 20393 | 2020-03-30 | Spencer | Kentucky | 21215 | 1 | 0 |
20394 | 20394 | 2020-03-30 | Taylor | Kentucky | 21217 | 2 | 0 |
20395 | 20395 | 2020-03-30 | Union | Kentucky | 21225 | 1 | 0 |
20396 | 20396 | 2020-03-30 | Unknown | Kentucky | 55 | 0 | |
20397 | 20397 | 2020-03-30 | Warren | Kentucky | 21227 | 11 | 0 |
20398 | 20398 | 2020-03-30 | Washington | Kentucky | 21229 | 2 | 0 |
20399 | 20399 | 2020-03-30 | Wayne | Kentucky | 21231 | 1 | 0 |
20400 | 20400 | 2020-03-30 | Webster | Kentucky | 21233 | 1 | 0 |
20401 | 20401 | 2020-03-30 | Woodford | Kentucky | 21239 | 5 | 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);