ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where "date" is on date 2020-04-15 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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
- Casey 1
- Christian 1
- Clark 1
- Clinton 1
- Crittenden 1
- Cumberland 1
- Daviess 1
- Edmonson 1
- Fayette 1
- Fleming 1
- …
state 1
- Kentucky · 106 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
60048 | 60048 | 2020-04-15 | Adair | Kentucky | 21001 | 45 | 2 |
60049 | 60049 | 2020-04-15 | Allen | Kentucky | 21003 | 3 | 0 |
60050 | 60050 | 2020-04-15 | Anderson | Kentucky | 21005 | 4 | 1 |
60051 | 60051 | 2020-04-15 | Ballard | Kentucky | 21007 | 3 | 0 |
60052 | 60052 | 2020-04-15 | Barren | Kentucky | 21009 | 7 | 0 |
60053 | 60053 | 2020-04-15 | Bath | Kentucky | 21011 | 3 | 0 |
60054 | 60054 | 2020-04-15 | Boone | Kentucky | 21015 | 65 | 2 |
60055 | 60055 | 2020-04-15 | Bourbon | Kentucky | 21017 | 4 | 1 |
60056 | 60056 | 2020-04-15 | Boyd | Kentucky | 21019 | 27 | 2 |
60057 | 60057 | 2020-04-15 | Boyle | Kentucky | 21021 | 13 | 0 |
60058 | 60058 | 2020-04-15 | Bracken | Kentucky | 21023 | 6 | 0 |
60059 | 60059 | 2020-04-15 | Breathitt | Kentucky | 21025 | 3 | 0 |
60060 | 60060 | 2020-04-15 | Breckinridge | Kentucky | 21027 | 4 | 0 |
60061 | 60061 | 2020-04-15 | Bullitt | Kentucky | 21029 | 32 | 2 |
60062 | 60062 | 2020-04-15 | Butler | Kentucky | 21031 | 50 | 3 |
60063 | 60063 | 2020-04-15 | Caldwell | Kentucky | 21033 | 10 | 0 |
60064 | 60064 | 2020-04-15 | Calloway | Kentucky | 21035 | 19 | 1 |
60065 | 60065 | 2020-04-15 | Campbell | Kentucky | 21037 | 51 | 5 |
60066 | 60066 | 2020-04-15 | Carroll | Kentucky | 21041 | 2 | 0 |
60067 | 60067 | 2020-04-15 | Carter | Kentucky | 21043 | 5 | 0 |
60068 | 60068 | 2020-04-15 | Casey | Kentucky | 21045 | 1 | 0 |
60069 | 60069 | 2020-04-15 | Christian | Kentucky | 21047 | 73 | 3 |
60070 | 60070 | 2020-04-15 | Clark | Kentucky | 21049 | 18 | 0 |
60071 | 60071 | 2020-04-15 | Clinton | Kentucky | 21053 | 2 | 0 |
60072 | 60072 | 2020-04-15 | Crittenden | Kentucky | 21055 | 3 | 0 |
60073 | 60073 | 2020-04-15 | Cumberland | Kentucky | 21057 | 2 | 0 |
60074 | 60074 | 2020-04-15 | Daviess | Kentucky | 21059 | 100 | 3 |
60075 | 60075 | 2020-04-15 | Edmonson | Kentucky | 21061 | 7 | 0 |
60076 | 60076 | 2020-04-15 | Fayette | Kentucky | 21067 | 212 | 7 |
60077 | 60077 | 2020-04-15 | Fleming | Kentucky | 21069 | 2 | 0 |
60078 | 60078 | 2020-04-15 | Floyd | Kentucky | 21071 | 1 | 0 |
60079 | 60079 | 2020-04-15 | Franklin | Kentucky | 21073 | 11 | 0 |
60080 | 60080 | 2020-04-15 | Gallatin | Kentucky | 21077 | 1 | 0 |
60081 | 60081 | 2020-04-15 | Garrard | Kentucky | 21079 | 3 | 0 |
60082 | 60082 | 2020-04-15 | Grant | Kentucky | 21081 | 16 | 1 |
60083 | 60083 | 2020-04-15 | Graves | Kentucky | 21083 | 19 | 0 |
60084 | 60084 | 2020-04-15 | Grayson | Kentucky | 21085 | 5 | 0 |
60085 | 60085 | 2020-04-15 | Green | Kentucky | 21087 | 1 | 0 |
60086 | 60086 | 2020-04-15 | Greenup | Kentucky | 21089 | 7 | 0 |
60087 | 60087 | 2020-04-15 | Hancock | Kentucky | 21091 | 2 | 0 |
60088 | 60088 | 2020-04-15 | Hardin | Kentucky | 21093 | 27 | 0 |
60089 | 60089 | 2020-04-15 | Harrison | Kentucky | 21097 | 16 | 0 |
60090 | 60090 | 2020-04-15 | Hart | Kentucky | 21099 | 1 | 0 |
60091 | 60091 | 2020-04-15 | Henderson | Kentucky | 21101 | 26 | 0 |
60092 | 60092 | 2020-04-15 | Henry | Kentucky | 21103 | 3 | 0 |
60093 | 60093 | 2020-04-15 | Hopkins | Kentucky | 21107 | 102 | 10 |
60094 | 60094 | 2020-04-15 | Jackson | Kentucky | 21109 | 26 | 1 |
60095 | 60095 | 2020-04-15 | Jefferson | Kentucky | 21111 | 582 | 53 |
60096 | 60096 | 2020-04-15 | Jessamine | Kentucky | 21113 | 29 | 0 |
60097 | 60097 | 2020-04-15 | Johnson | Kentucky | 21115 | 1 | 0 |
60098 | 60098 | 2020-04-15 | Kenton | Kentucky | 21117 | 107 | 10 |
60099 | 60099 | 2020-04-15 | Knott | Kentucky | 21119 | 1 | 0 |
60100 | 60100 | 2020-04-15 | Knox | Kentucky | 21121 | 1 | 0 |
60101 | 60101 | 2020-04-15 | Larue | Kentucky | 21123 | 4 | 0 |
60102 | 60102 | 2020-04-15 | Laurel | Kentucky | 21125 | 12 | 2 |
60103 | 60103 | 2020-04-15 | Lawrence | Kentucky | 21127 | 1 | 0 |
60104 | 60104 | 2020-04-15 | Leslie | Kentucky | 21131 | 2 | 0 |
60105 | 60105 | 2020-04-15 | Letcher | Kentucky | 21133 | 1 | 0 |
60106 | 60106 | 2020-04-15 | Lewis | Kentucky | 21135 | 2 | 0 |
60107 | 60107 | 2020-04-15 | Lincoln | Kentucky | 21137 | 2 | 1 |
60108 | 60108 | 2020-04-15 | Livingston | Kentucky | 21139 | 1 | 0 |
60109 | 60109 | 2020-04-15 | Logan | Kentucky | 21141 | 9 | 0 |
60110 | 60110 | 2020-04-15 | Lyon | Kentucky | 21143 | 13 | 2 |
60111 | 60111 | 2020-04-15 | Madison | Kentucky | 21151 | 21 | 1 |
60112 | 60112 | 2020-04-15 | Marion | Kentucky | 21155 | 12 | 0 |
60113 | 60113 | 2020-04-15 | Marshall | Kentucky | 21157 | 12 | 0 |
60114 | 60114 | 2020-04-15 | Martin | Kentucky | 21159 | 1 | 0 |
60115 | 60115 | 2020-04-15 | Mason | Kentucky | 21161 | 6 | 0 |
60116 | 60116 | 2020-04-15 | McCracken | Kentucky | 21145 | 25 | 2 |
60117 | 60117 | 2020-04-15 | McCreary | Kentucky | 21147 | 9 | 0 |
60118 | 60118 | 2020-04-15 | McLean | Kentucky | 21149 | 5 | 0 |
60119 | 60119 | 2020-04-15 | Meade | Kentucky | 21163 | 2 | 1 |
60120 | 60120 | 2020-04-15 | Menifee | Kentucky | 21165 | 3 | 0 |
60121 | 60121 | 2020-04-15 | Mercer | Kentucky | 21167 | 9 | 0 |
60122 | 60122 | 2020-04-15 | Monroe | Kentucky | 21171 | 3 | 0 |
60123 | 60123 | 2020-04-15 | Montgomery | Kentucky | 21173 | 8 | 0 |
60124 | 60124 | 2020-04-15 | Morgan | Kentucky | 21175 | 1 | 0 |
60125 | 60125 | 2020-04-15 | Muhlenberg | Kentucky | 21177 | 52 | 2 |
60126 | 60126 | 2020-04-15 | Nelson | Kentucky | 21179 | 13 | 0 |
60127 | 60127 | 2020-04-15 | Nicholas | Kentucky | 21181 | 1 | 0 |
60128 | 60128 | 2020-04-15 | Ohio | Kentucky | 21183 | 11 | 0 |
60129 | 60129 | 2020-04-15 | Oldham | Kentucky | 21185 | 21 | 0 |
60130 | 60130 | 2020-04-15 | Owsley | Kentucky | 21189 | 2 | 0 |
60131 | 60131 | 2020-04-15 | Pendleton | Kentucky | 21191 | 3 | 0 |
60132 | 60132 | 2020-04-15 | Perry | Kentucky | 21193 | 4 | 0 |
60133 | 60133 | 2020-04-15 | Pike | Kentucky | 21195 | 6 | 1 |
60134 | 60134 | 2020-04-15 | Powell | Kentucky | 21197 | 1 | 0 |
60135 | 60135 | 2020-04-15 | Pulaski | Kentucky | 21199 | 31 | 2 |
60136 | 60136 | 2020-04-15 | Rockcastle | Kentucky | 21203 | 10 | 0 |
60137 | 60137 | 2020-04-15 | Rowan | Kentucky | 21205 | 1 | 0 |
60138 | 60138 | 2020-04-15 | Russell | Kentucky | 21207 | 8 | 0 |
60139 | 60139 | 2020-04-15 | Scott | Kentucky | 21209 | 27 | 0 |
60140 | 60140 | 2020-04-15 | Shelby | Kentucky | 21211 | 21 | 1 |
60141 | 60141 | 2020-04-15 | Simpson | Kentucky | 21213 | 17 | 2 |
60142 | 60142 | 2020-04-15 | Spencer | Kentucky | 21215 | 8 | 0 |
60143 | 60143 | 2020-04-15 | Taylor | Kentucky | 21217 | 4 | 0 |
60144 | 60144 | 2020-04-15 | Todd | Kentucky | 21219 | 10 | 0 |
60145 | 60145 | 2020-04-15 | Trigg | Kentucky | 21221 | 4 | 0 |
60146 | 60146 | 2020-04-15 | Trimble | Kentucky | 21223 | 1 | 0 |
60147 | 60147 | 2020-04-15 | Union | Kentucky | 21225 | 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);