ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where "date" is on date 2020-04-09 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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
- Floyd 1
- Franklin 1
- …
state 1
- Kentucky · 96 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
44052 | 44052 | 2020-04-09 | Adair | Kentucky | 21001 | 9 | 1 |
44053 | 44053 | 2020-04-09 | Allen | Kentucky | 21003 | 4 | 0 |
44054 | 44054 | 2020-04-09 | Anderson | Kentucky | 21005 | 3 | 1 |
44055 | 44055 | 2020-04-09 | Ballard | Kentucky | 21007 | 1 | 0 |
44056 | 44056 | 2020-04-09 | Barren | Kentucky | 21009 | 3 | 0 |
44057 | 44057 | 2020-04-09 | Bath | Kentucky | 21011 | 1 | 0 |
44058 | 44058 | 2020-04-09 | Boone | Kentucky | 21015 | 46 | 1 |
44059 | 44059 | 2020-04-09 | Bourbon | Kentucky | 21017 | 4 | 1 |
44060 | 44060 | 2020-04-09 | Boyd | Kentucky | 21019 | 22 | 2 |
44061 | 44061 | 2020-04-09 | Boyle | Kentucky | 21021 | 13 | 0 |
44062 | 44062 | 2020-04-09 | Bracken | Kentucky | 21023 | 1 | 0 |
44063 | 44063 | 2020-04-09 | Breathitt | Kentucky | 21025 | 2 | 0 |
44064 | 44064 | 2020-04-09 | Breckinridge | Kentucky | 21027 | 3 | 0 |
44065 | 44065 | 2020-04-09 | Bullitt | Kentucky | 21029 | 21 | 2 |
44066 | 44066 | 2020-04-09 | Butler | Kentucky | 21031 | 2 | 0 |
44067 | 44067 | 2020-04-09 | Caldwell | Kentucky | 21033 | 6 | 0 |
44068 | 44068 | 2020-04-09 | Calloway | Kentucky | 21035 | 8 | 1 |
44069 | 44069 | 2020-04-09 | Campbell | Kentucky | 21037 | 41 | 3 |
44070 | 44070 | 2020-04-09 | Carroll | Kentucky | 21041 | 2 | 0 |
44071 | 44071 | 2020-04-09 | Carter | Kentucky | 21043 | 1 | 0 |
44072 | 44072 | 2020-04-09 | Christian | Kentucky | 21047 | 45 | 0 |
44073 | 44073 | 2020-04-09 | Clark | Kentucky | 21049 | 11 | 0 |
44074 | 44074 | 2020-04-09 | Clinton | Kentucky | 21053 | 1 | 0 |
44075 | 44075 | 2020-04-09 | Crittenden | Kentucky | 21055 | 3 | 0 |
44076 | 44076 | 2020-04-09 | Cumberland | Kentucky | 21057 | 1 | 0 |
44077 | 44077 | 2020-04-09 | Daviess | Kentucky | 21059 | 72 | 2 |
44078 | 44078 | 2020-04-09 | Edmonson | Kentucky | 21061 | 6 | 0 |
44079 | 44079 | 2020-04-09 | Fayette | Kentucky | 21067 | 174 | 7 |
44080 | 44080 | 2020-04-09 | Floyd | Kentucky | 21071 | 1 | 0 |
44081 | 44081 | 2020-04-09 | Franklin | Kentucky | 21073 | 10 | 0 |
44082 | 44082 | 2020-04-09 | Grant | Kentucky | 21081 | 11 | 1 |
44083 | 44083 | 2020-04-09 | Graves | Kentucky | 21083 | 5 | 0 |
44084 | 44084 | 2020-04-09 | Grayson | Kentucky | 21085 | 2 | 0 |
44085 | 44085 | 2020-04-09 | Green | Kentucky | 21087 | 2 | 0 |
44086 | 44086 | 2020-04-09 | Greenup | Kentucky | 21089 | 2 | 0 |
44087 | 44087 | 2020-04-09 | Hancock | Kentucky | 21091 | 2 | 0 |
44088 | 44088 | 2020-04-09 | Hardin | Kentucky | 21093 | 11 | 0 |
44089 | 44089 | 2020-04-09 | Harrison | Kentucky | 21097 | 14 | 0 |
44090 | 44090 | 2020-04-09 | Hart | Kentucky | 21099 | 1 | 0 |
44091 | 44091 | 2020-04-09 | Henderson | Kentucky | 21101 | 23 | 0 |
44092 | 44092 | 2020-04-09 | Henry | Kentucky | 21103 | 3 | 0 |
44093 | 44093 | 2020-04-09 | Hopkins | Kentucky | 21107 | 78 | 7 |
44094 | 44094 | 2020-04-09 | Jackson | Kentucky | 21109 | 3 | 0 |
44095 | 44095 | 2020-04-09 | Jefferson | Kentucky | 21111 | 436 | 33 |
44096 | 44096 | 2020-04-09 | Jessamine | Kentucky | 21113 | 18 | 0 |
44097 | 44097 | 2020-04-09 | Johnson | Kentucky | 21115 | 1 | 0 |
44098 | 44098 | 2020-04-09 | Kenton | Kentucky | 21117 | 80 | 8 |
44099 | 44099 | 2020-04-09 | Knox | Kentucky | 21121 | 1 | 0 |
44100 | 44100 | 2020-04-09 | Larue | Kentucky | 21123 | 3 | 0 |
44101 | 44101 | 2020-04-09 | Laurel | Kentucky | 21125 | 3 | 0 |
44102 | 44102 | 2020-04-09 | Lawrence | Kentucky | 21127 | 1 | 0 |
44103 | 44103 | 2020-04-09 | Leslie | Kentucky | 21131 | 1 | 0 |
44104 | 44104 | 2020-04-09 | Letcher | Kentucky | 21133 | 1 | 0 |
44105 | 44105 | 2020-04-09 | Lewis | Kentucky | 21135 | 2 | 0 |
44106 | 44106 | 2020-04-09 | Lincoln | Kentucky | 21137 | 1 | 0 |
44107 | 44107 | 2020-04-09 | Logan | Kentucky | 21141 | 5 | 0 |
44108 | 44108 | 2020-04-09 | Lyon | Kentucky | 21143 | 6 | 2 |
44109 | 44109 | 2020-04-09 | Madison | Kentucky | 21151 | 14 | 1 |
44110 | 44110 | 2020-04-09 | Marion | Kentucky | 21155 | 5 | 0 |
44111 | 44111 | 2020-04-09 | Marshall | Kentucky | 21157 | 8 | 0 |
44112 | 44112 | 2020-04-09 | Martin | Kentucky | 21159 | 4 | 0 |
44113 | 44113 | 2020-04-09 | Mason | Kentucky | 21161 | 3 | 0 |
44114 | 44114 | 2020-04-09 | McCracken | Kentucky | 21145 | 13 | 1 |
44115 | 44115 | 2020-04-09 | McCreary | Kentucky | 21147 | 3 | 0 |
44116 | 44116 | 2020-04-09 | McLean | Kentucky | 21149 | 4 | 0 |
44117 | 44117 | 2020-04-09 | Meade | Kentucky | 21163 | 2 | 1 |
44118 | 44118 | 2020-04-09 | Menifee | Kentucky | 21165 | 3 | 0 |
44119 | 44119 | 2020-04-09 | Mercer | Kentucky | 21167 | 4 | 0 |
44120 | 44120 | 2020-04-09 | Monroe | Kentucky | 21171 | 2 | 0 |
44121 | 44121 | 2020-04-09 | Montgomery | Kentucky | 21173 | 7 | 0 |
44122 | 44122 | 2020-04-09 | Muhlenberg | Kentucky | 21177 | 26 | 0 |
44123 | 44123 | 2020-04-09 | Nelson | Kentucky | 21179 | 7 | 0 |
44124 | 44124 | 2020-04-09 | Nicholas | Kentucky | 21181 | 1 | 0 |
44125 | 44125 | 2020-04-09 | Ohio | Kentucky | 21183 | 7 | 0 |
44126 | 44126 | 2020-04-09 | Oldham | Kentucky | 21185 | 11 | 0 |
44127 | 44127 | 2020-04-09 | Pendleton | Kentucky | 21191 | 3 | 0 |
44128 | 44128 | 2020-04-09 | Perry | Kentucky | 21193 | 3 | 0 |
44129 | 44129 | 2020-04-09 | Pike | Kentucky | 21195 | 1 | 0 |
44130 | 44130 | 2020-04-09 | Powell | Kentucky | 21197 | 1 | 0 |
44131 | 44131 | 2020-04-09 | Pulaski | Kentucky | 21199 | 26 | 1 |
44132 | 44132 | 2020-04-09 | Rockcastle | Kentucky | 21203 | 6 | 0 |
44133 | 44133 | 2020-04-09 | Russell | Kentucky | 21207 | 4 | 0 |
44134 | 44134 | 2020-04-09 | Scott | Kentucky | 21209 | 21 | 0 |
44135 | 44135 | 2020-04-09 | Shelby | Kentucky | 21211 | 13 | 0 |
44136 | 44136 | 2020-04-09 | Simpson | Kentucky | 21213 | 14 | 1 |
44137 | 44137 | 2020-04-09 | Spencer | Kentucky | 21215 | 4 | 0 |
44138 | 44138 | 2020-04-09 | Taylor | Kentucky | 21217 | 3 | 0 |
44139 | 44139 | 2020-04-09 | Todd | Kentucky | 21219 | 3 | 0 |
44140 | 44140 | 2020-04-09 | Union | Kentucky | 21225 | 3 | 0 |
44141 | 44141 | 2020-04-09 | Unknown | Kentucky | 0 | 7 | |
44142 | 44142 | 2020-04-09 | Warren | Kentucky | 21227 | 35 | 0 |
44143 | 44143 | 2020-04-09 | Washington | Kentucky | 21229 | 3 | 0 |
44144 | 44144 | 2020-04-09 | Wayne | Kentucky | 21231 | 4 | 0 |
44145 | 44145 | 2020-04-09 | Webster | Kentucky | 21233 | 7 | 0 |
44146 | 44146 | 2020-04-09 | Whitley | Kentucky | 21235 | 1 | 0 |
44147 | 44147 | 2020-04-09 | Woodford | Kentucky | 21239 | 13 | 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);