ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92,572 rows where state = "Kentucky" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 21049 784
- 21059 784
- 21067 784
- 21073 784
- 21097 784
- 21101 784
- 21111 784
- 21117 784
- 21143 784
- 21151 784
- 21173 784
- 21179 784
- 21199 784
- 21209 784
- 21215 784
- 21227 784
- 21003 783
- 21005 783
- 21017 783
- 21025 783
- 21035 783
- 21047 783
- 21093 783
- 21113 783
- 21185 783
- 21141 782
- 21145 781
- 21159 781
- 21165 781
- 21177 781
- …
county >30
- Clark 784
- Daviess 784
- Fayette 784
- Franklin 784
- Harrison 784
- Henderson 784
- Jefferson 784
- Kenton 784
- Lyon 784
- Madison 784
- Montgomery 784
- Nelson 784
- Pulaski 784
- Scott 784
- Spencer 784
- Warren 784
- Allen 783
- Anderson 783
- Bourbon 783
- Breathitt 783
- Calloway 783
- Christian 783
- Hardin 783
- Jessamine 783
- Oldham 783
- Logan 782
- Martin 781
- McCracken 781
- Menifee 781
- Muhlenberg 781
- …
state 1
- Kentucky · 92,472 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6428 | 6428 | 2020-03-21 | Clark | Kentucky | 21049 | 2 | 0 |
6429 | 6429 | 2020-03-21 | Daviess | Kentucky | 21059 | 4 | 0 |
6430 | 6430 | 2020-03-21 | Fayette | Kentucky | 21067 | 13 | 0 |
6431 | 6431 | 2020-03-21 | Franklin | Kentucky | 21073 | 1 | 0 |
6432 | 6432 | 2020-03-21 | Harrison | Kentucky | 21097 | 10 | 0 |
6433 | 6433 | 2020-03-21 | Henderson | Kentucky | 21101 | 3 | 0 |
6434 | 6434 | 2020-03-21 | Jefferson | Kentucky | 21111 | 25 | 1 |
6435 | 6435 | 2020-03-21 | Kenton | Kentucky | 21117 | 3 | 0 |
6436 | 6436 | 2020-03-21 | Lyon | Kentucky | 21143 | 1 | 0 |
6437 | 6437 | 2020-03-21 | Madison | Kentucky | 21151 | 1 | 0 |
6438 | 6438 | 2020-03-21 | Montgomery | Kentucky | 21173 | 2 | 0 |
6439 | 6439 | 2020-03-21 | Nelson | Kentucky | 21179 | 1 | 0 |
6440 | 6440 | 2020-03-21 | Pulaski | Kentucky | 21199 | 2 | 0 |
6441 | 6441 | 2020-03-21 | Scott | Kentucky | 21209 | 1 | 0 |
6442 | 6442 | 2020-03-21 | Spencer | Kentucky | 21215 | 1 | 0 |
6443 | 6443 | 2020-03-21 | Unknown | Kentucky | 5 | 0 | |
6444 | 6444 | 2020-03-21 | Warren | Kentucky | 21227 | 4 | 0 |
7493 | 7493 | 2020-03-22 | Allen | Kentucky | 21003 | 1 | 0 |
7494 | 7494 | 2020-03-22 | Anderson | Kentucky | 21005 | 1 | 1 |
7495 | 7495 | 2020-03-22 | Bourbon | Kentucky | 21017 | 2 | 1 |
7496 | 7496 | 2020-03-22 | Breathitt | Kentucky | 21025 | 1 | 0 |
7497 | 7497 | 2020-03-22 | Calloway | Kentucky | 21035 | 1 | 0 |
7498 | 7498 | 2020-03-22 | Christian | Kentucky | 21047 | 2 | 0 |
7499 | 7499 | 2020-03-22 | Clark | Kentucky | 21049 | 2 | 0 |
7500 | 7500 | 2020-03-22 | Daviess | Kentucky | 21059 | 6 | 0 |
7501 | 7501 | 2020-03-22 | Fayette | Kentucky | 21067 | 14 | 0 |
7502 | 7502 | 2020-03-22 | Franklin | Kentucky | 21073 | 1 | 0 |
7503 | 7503 | 2020-03-22 | Hardin | Kentucky | 21093 | 1 | 0 |
7504 | 7504 | 2020-03-22 | Harrison | Kentucky | 21097 | 10 | 0 |
7505 | 7505 | 2020-03-22 | Henderson | Kentucky | 21101 | 5 | 0 |
7506 | 7506 | 2020-03-22 | Jefferson | Kentucky | 21111 | 26 | 1 |
7507 | 7507 | 2020-03-22 | Jessamine | Kentucky | 21113 | 1 | 0 |
7508 | 7508 | 2020-03-22 | Kenton | Kentucky | 21117 | 7 | 0 |
7509 | 7509 | 2020-03-22 | Lyon | Kentucky | 21143 | 1 | 0 |
7510 | 7510 | 2020-03-22 | Madison | Kentucky | 21151 | 2 | 0 |
7511 | 7511 | 2020-03-22 | Montgomery | Kentucky | 21173 | 2 | 0 |
7512 | 7512 | 2020-03-22 | Nelson | Kentucky | 21179 | 1 | 0 |
7513 | 7513 | 2020-03-22 | Oldham | Kentucky | 21185 | 1 | 0 |
7514 | 7514 | 2020-03-22 | Pulaski | Kentucky | 21199 | 2 | 0 |
7515 | 7515 | 2020-03-22 | Scott | Kentucky | 21209 | 1 | 0 |
7516 | 7516 | 2020-03-22 | Spencer | Kentucky | 21215 | 1 | 0 |
7517 | 7517 | 2020-03-22 | Unknown | Kentucky | 6 | 0 | |
7518 | 7518 | 2020-03-22 | Warren | Kentucky | 21227 | 5 | 0 |
8655 | 8655 | 2020-03-23 | Allen | Kentucky | 21003 | 1 | 0 |
8656 | 8656 | 2020-03-23 | Anderson | Kentucky | 21005 | 2 | 1 |
8657 | 8657 | 2020-03-23 | Bourbon | Kentucky | 21017 | 2 | 1 |
8658 | 8658 | 2020-03-23 | Breathitt | Kentucky | 21025 | 2 | 0 |
8659 | 8659 | 2020-03-23 | Calloway | Kentucky | 21035 | 1 | 0 |
8660 | 8660 | 2020-03-23 | Christian | Kentucky | 21047 | 2 | 0 |
8661 | 8661 | 2020-03-23 | Clark | Kentucky | 21049 | 3 | 0 |
8662 | 8662 | 2020-03-23 | Daviess | Kentucky | 21059 | 10 | 0 |
8663 | 8663 | 2020-03-23 | Fayette | Kentucky | 21067 | 14 | 0 |
8664 | 8664 | 2020-03-23 | Franklin | Kentucky | 21073 | 2 | 0 |
8665 | 8665 | 2020-03-23 | Hardin | Kentucky | 21093 | 2 | 0 |
8666 | 8666 | 2020-03-23 | Harrison | Kentucky | 21097 | 11 | 0 |
8667 | 8667 | 2020-03-23 | Henderson | Kentucky | 21101 | 5 | 0 |
8668 | 8668 | 2020-03-23 | Jefferson | Kentucky | 21111 | 31 | 1 |
8669 | 8669 | 2020-03-23 | Jessamine | Kentucky | 21113 | 1 | 0 |
8670 | 8670 | 2020-03-23 | Kenton | Kentucky | 21117 | 7 | 0 |
8671 | 8671 | 2020-03-23 | Logan | Kentucky | 21141 | 1 | 0 |
8672 | 8672 | 2020-03-23 | Lyon | Kentucky | 21143 | 1 | 0 |
8673 | 8673 | 2020-03-23 | Madison | Kentucky | 21151 | 2 | 0 |
8674 | 8674 | 2020-03-23 | Montgomery | Kentucky | 21173 | 2 | 0 |
8675 | 8675 | 2020-03-23 | Nelson | Kentucky | 21179 | 1 | 0 |
8676 | 8676 | 2020-03-23 | Oldham | Kentucky | 21185 | 1 | 0 |
8677 | 8677 | 2020-03-23 | Pulaski | Kentucky | 21199 | 3 | 0 |
8678 | 8678 | 2020-03-23 | Scott | Kentucky | 21209 | 1 | 0 |
8679 | 8679 | 2020-03-23 | Spencer | Kentucky | 21215 | 1 | 0 |
8680 | 8680 | 2020-03-23 | Unknown | Kentucky | 9 | 0 | |
8681 | 8681 | 2020-03-23 | Warren | Kentucky | 21227 | 6 | 0 |
9938 | 9938 | 2020-03-24 | Allen | Kentucky | 21003 | 1 | 0 |
9939 | 9939 | 2020-03-24 | Anderson | Kentucky | 21005 | 2 | 1 |
9940 | 9940 | 2020-03-24 | Bourbon | Kentucky | 21017 | 2 | 1 |
9941 | 9941 | 2020-03-24 | Breathitt | Kentucky | 21025 | 2 | 0 |
9942 | 9942 | 2020-03-24 | Calloway | Kentucky | 21035 | 1 | 0 |
9943 | 9943 | 2020-03-24 | Christian | Kentucky | 21047 | 3 | 0 |
9944 | 9944 | 2020-03-24 | Clark | Kentucky | 21049 | 3 | 0 |
9945 | 9945 | 2020-03-24 | Daviess | Kentucky | 21059 | 12 | 0 |
9946 | 9946 | 2020-03-24 | Fayette | Kentucky | 21067 | 20 | 0 |
9947 | 9947 | 2020-03-24 | Franklin | Kentucky | 21073 | 2 | 0 |
9948 | 9948 | 2020-03-24 | Hardin | Kentucky | 21093 | 2 | 0 |
9949 | 9949 | 2020-03-24 | Harrison | Kentucky | 21097 | 11 | 0 |
9950 | 9950 | 2020-03-24 | Henderson | Kentucky | 21101 | 5 | 0 |
9951 | 9951 | 2020-03-24 | Jefferson | Kentucky | 21111 | 40 | 1 |
9952 | 9952 | 2020-03-24 | Jessamine | Kentucky | 21113 | 2 | 0 |
9953 | 9953 | 2020-03-24 | Kenton | Kentucky | 21117 | 8 | 0 |
9954 | 9954 | 2020-03-24 | Logan | Kentucky | 21141 | 1 | 0 |
9955 | 9955 | 2020-03-24 | Lyon | Kentucky | 21143 | 1 | 0 |
9956 | 9956 | 2020-03-24 | Madison | Kentucky | 21151 | 2 | 0 |
9957 | 9957 | 2020-03-24 | Martin | Kentucky | 21159 | 1 | 0 |
9958 | 9958 | 2020-03-24 | McCracken | Kentucky | 21145 | 2 | 0 |
9959 | 9959 | 2020-03-24 | Menifee | Kentucky | 21165 | 2 | 0 |
9960 | 9960 | 2020-03-24 | Montgomery | Kentucky | 21173 | 2 | 0 |
9961 | 9961 | 2020-03-24 | Muhlenberg | Kentucky | 21177 | 2 | 0 |
9962 | 9962 | 2020-03-24 | Nelson | Kentucky | 21179 | 1 | 0 |
9963 | 9963 | 2020-03-24 | Oldham | Kentucky | 21185 | 1 | 0 |
9964 | 9964 | 2020-03-24 | Pulaski | Kentucky | 21199 | 4 | 0 |
9965 | 9965 | 2020-03-24 | Scott | Kentucky | 21209 | 1 | 0 |
9966 | 9966 | 2020-03-24 | Simpson | Kentucky | 21213 | 1 | 0 |
9967 | 9967 | 2020-03-24 | Spencer | Kentucky | 21215 | 1 | 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);